Tools for Writers: Butt kickin’, goal setting spreadsheet, free to use

Now that the curtains have closed on NaNoWriMo for another year, you may find yourself in the post-NaNo, pre-holiday slump. Persevere, dear friends! I’ve created something for you to help keep that old-timey NaNo feeling of panicked word production persisting throughout the year (sorry for the alliteration).

It’s a Google spreadsheet that– wait, where are you going? Come back! I promise, not all spreadsheets are boring, some can actually be useful, I swear! Especially for writers who are trying to keep on track and hit deadlines.

This spreadsheet is actually based on the ‘stats’ page in NaNoWriMo but you needn’t be a former NaNo participant to get use out of it. So, you’ll need to do a couple things to be able to use this spreadsheet. First, make sure you have a Google account. Then you can go to the Butt kickin’ goal tracker so you can pwn your novel! spreadsheet. You’ll need to make a copy of it so that you can edit it for yourself. Do that now by clicking on File –> Make a Copy. This will save it to your Google Drive.

targets

Just start out by filling in the project targets, the start date, end date and what you would like to achieve in that time. The other fields you see here are automatically calculated.

There’s even a message that pops up if you’re ahead of your target or falling a bit behind.

words

To the left, you’ll see a string of dates in one column and a corresponding target number in the next. That number is your cumulative goal for that date, in other words, where your total word count should be by that date.  The third column, labeled “Actual” is the one you actively fill in each day. It’s important to remember that this is a running total, not just the words you wrote today.

For example, you can see that on December 1st, I wrote 2600 words (I wish) and then on the 2nd, I have 4500. That means on the 2nd I wrote 1900 additional words, bringing my total to 4500. Sorry if this seems like hand-holding.

 

Finally, we come to the chart. For NaNo-ites, this is where the real action is. This is your visual representation of where you are on that golden novel highway… though based on the steep grade, you may want to drop it down a gear or two. Think of it as a highway to heaven. Heavenly, first draft goodness.

chart2

 

That’s it, it’s pretty simple but hopefully it will help you on your path. If you have any questions, just hit me up here, or over at twitter, @nmhall. And if you find this useful, give me some link love on Twitter, Reddit, Facebook, Google+ or whatever other flavor of impersonal digital socializing you prefer.

Goals and resolutions from other authors and creatives

After I wrote up my own resolutions in a previous post, my partner (in the domestic sense) suggested that maybe I should reach out and see what sort of resolutions other authors and creative people had. I panned on it at first, thinking that the response would be tepid at best. To my surprise and delight, I was overwhelmed by the number of people who agreed to take part. Thanks to each of you below who took time out of your busy lives to humor me.

Some of these folks I follow on Twitter, some I’m friends with offline. There are quite a number of authors in the mix, for obvious reasons, but there are people who also add teacher or game designer, editor or publisher to their daily duties. Each of them have (I think) some interesting perspective on their coming year and what they would like to achieve.

Continue Reading