In which I spend all morning messing with spreadsheets again. :P

Basically, I took my old wordcount tracking spreadsheet and made it a lot prettier, more functional and more elegant. So at that point I figured I might as well share it.

Words by Story Spreadsheet (click to download)

This spreadsheet is designed for people who want to track their writing goals for a year primarily by story rather than by date. (kate's awesome 2012 Wordtracker spreadsheet does everything you need for by tracking by date anyway.) It's also designed for fanfic writers, people who tend to have a lot of different stories on the go at once, and people who like to watch the numbers dance. :D (Last year I found I was way more motivated by "watch the numbers dance" than "I made daily wordcount.")

Basics for using this spreadsheet: It's an Open Document Spreadsheet, which means it works natively with OpenOffice, LibreOffice, StarOffice, or pretty much any other open source office suite of your choice. (It will only partly work in GoogleDocs, and probably only partly works in Excel - they choke on the array formulas, which means most of the fancier statistics give errors. But the basic stuff will still work.)

Every time you work on a new story, you insert a new row at the top, and then fill in the columns for that row. If you update a previously worked on story, just change the values that have changed. Gray-background cells are automatically calculated and you should not type anything in them unless you know what you're doing with the formulas.

( More notes on optional stuff )

(Also I needed a 2012-only story to test it with, so I posted the silly Sherlock thing from t'other day to AO3. I now have fics up titled "Inconceivable" and "Unbelievable". Clearly I need to come up with a story for "Irretrievable".)