3/14/08: My submission tracking process

Word count: 128392 | Since last entry: -24

The -24 words above is hilarious. I have been writing very head-down this week and have chopped off the entire last half chapter, replacing it with a new chapter-and-a-half. And this just HAPPENS to almost exactly equal the word count the last time I blogged. In point of fact I've removed almost 5000 words and written the same number of entirely new words. I hope to have a new complete draft ready to send to my beta readers today or tomorrow.

In the last week I also saw the excellent touring production of Twelve Angry Men, with Richard Thomas as Juror Eight, and have done a bit of decluttering. I've also been mildly sick. Not too surprising given the number of sick people at Potlatch.

The main reason I'm blogging right now is that I posted the following as a comment in kmckiernan's blog, and I thought it might be helpful to others.

For tracking story submissions I use an Excel spreadsheet with a separate sheet for each story. The name of each sheet is the story's filename (titles change, but I keep the same base filename for all versions) and it has the following columns:

• Date Out
• Sent To
• Date Back
• Days Out
• Response
• Comments

Each row represents a submission (well, technically a state change, because I also have rows for Wrote, Critiqued, and Edited for each story). The Days Out is automatically calculated from the Date Out and Date Back (or, if Date Back is blank, the current date). The Response field has the following values:

• ? - Awaiting Response
• R - Rejected
• D - Withdrawn
• X - Other Non-Sale (e.g. market closed)
• W - Rewrite Requested
• A - Accepted
• P - Published
• T - Trunked

I also have a Summary sheet with a macro that pulls together all of the rows in every sheet into a single sheet (adding the name of the sheet, which is the story identifier, as an additional column at the beginning). I use AutoFilter on this sheet to display only those rows where the status is Awaiting Response, and that's my summary of stories out and how long they've been wherever they are.

One important thing about my spreadsheet is that each sheet includes not only past submissions but future ones. The first few rows of each sheet have Wrote, Critiqued, and Edited in the Sent To field (with start and end dates and no Response value). The remaining rows are all markets, in the order in which I intend to send this story. I make up this list as soon as the story is finished. When I send the story out, I fill in the Date Out field. I use the Days Out field in my Summary sheet to see how long it's been out and to prompt me to query.

When I get a response, I fill in the Date Back and Response fields, and if the response is a rejection I just look down one row to see where I'm going to send it next. (If I already have a story at the next market, I move the next open market up a row and send it there instead.) This helps me to keep stories in submission. I rarely have a story sit around for more than a day or two. If the response is an acceptance, I remove the remaining markets and replace them with rows for Contract, Check, Galleys, and Publication for tracking the story through production.

( Here's an actual example... )

My Sawyer Nickname

Dogfighting scandal

Apropos recent revelations in the media, I can only say that kateyule will be standing beside me at a teary press conference at 11am PST today.