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
- ? - Awaiting Response
- R - Rejected
- D - Withdrawn
- X - Other Non-Sale (e.g. market closed)
- W - Rewrite Requested
- A - Accepted
- P - Published
- T - Trunked
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.
( Collapse )