I was looking for a tool to track my novel submissions today, and I stumbled on this nifty little spreadsheet hacked together by Matt Bell. But I’m one of those guys who likes my stuff just so, and you know, with a little bit of color to keep my tiny brain interested. So I tweaked it and added a couple little things.
A nice feature of Matt’s sheet is a counter that tabulates how long your submission has been in a particular agent’s (or publisher’s) slush pile — it tallies days until you put in a response date. Handy, but a bit dry.
So I added color-coding for the days your piece has been out for submission: Less than 2 months, green (I’d consider that an “active” submission), 2-4 months, yellow (still active but getting dusty), 4+ months, red (probably mostly dead and time to resubmit). This gives you a nice idea at a glance for how many “active” subs you have out.
I also added a “days since last submission” counter, also color-coded, which goes yellow after two weeks and red after a month — a sharp, at-a-glance indicator for whether you might want to send out some fresh subs.
All the bells and whistles should work for up to 150 submissions. In the spirit of Matt’s offering, I’ve made the end result downloadable and shareable, in the hopes you might find it useful.
And it’s all on the ubiquitously useful and convenient GoogleDocs, so, you know.