Every writer needs tools to get the job done. (Yes, pen and paper or laptop, I heard you. Please sit back down, peanut gallery.) I'm not talking about a word processor, or even a thesaurus. Plotting, organizing, scheduling, pacing... our tasks are many and guidelines few. My wife and I have developed and discovered some tools that I use, and I thought I would share what I am using and how I use it. To that end, this is the Writer's Toolbox series.
This post, I'd like to share the first tab of what we call the Novel Stats sheet. This is a dynamic spreadsheet that my wife and I worked up to help me with scheduling my writing time and tracking my progress. If you would like your own copy of this document to play with as you read this post, it is available here. Check my first post in this series, on Google Docs, for information about how to Save a Copy.
The embedded document above is the template. All the numbers are blank. The images I'm going to show you come from a sample document that I made up, using the same Template shown here. This document is great for keeping me on track with my writing. It lets me know when I am behind schedule and how far I have to go to get on schedule. It's also packed with neat little facts that help me figure out other things, like how long my chapters are, and what kind of deadline I can afford to set for myself. It also has some minimal plotting features worked into it, though I'll show you some more involved and complicated methods later.
I start by hiding that big, yellow banner with the page instructions.
To begin with, the Novel Stats page is pretty blank. It needs information from you. The only typing you do on this tab is in the green section. (Remember those big, yellow instructions at the top? You didn't read them, did you? This is what they were talking about. Shame, shame.)
We'll talk about the neat gadget on the side in a minute. Focus on the numbers in green, please. The three items in green are "Target Words in Novel," "Target Weeks to Completion," and "Start Date." Under Column B of Target Words is where you put your word count goal. NaNoWriMo's is 50k, so I filled that in for my Sample Novel sheet. It's summer, so I decided to claim 3 months (12 weeks) to write my novel. Then I put in a start date of June 15th.
Once I've filled in those numbers, notice that some of the other areas on the page have magically generated some values. Down at the bottom, the first red arrow I've drawn in the picture, you see that the sheet now knows what week it is. It has calculated based on the deadlines I gave it, what week of writing I should be on and what percentage of the novel I should have written at this point. As you can see by the rest of the document, I haven't written anything in this novel yet, so I'm horribly behind schedule. So far in fact, that it can't yet tell me how far behind I am! The next arrow points out a piece of information for me to use in my time management: I should be averaging 4,167 words/week to hit my goal.
However, with more information, the sheet becomes even more useful! I'll just take a break and go write a little. It said I needed 4k words, right?
Let's get one more week's worth of writing in before leaving this tab. Let's see, how many times do I turn this stupid time necklace again? ...
19 hours ago