The Writing Tracker and Statistics spreadsheet for 2024 is here!
What is it?
The spreadsheet is a way for writers who like statistics to track their daily wordcounts and writing habits (and also, probably, don't want to or can't pay to use software for this purpose). The idea is, once you've got the workbook set up and customised to your tastes, all you need to do is input your daily wordcount per project into one sheet and let the rest of the workbook populate from there. I originally designed this in late 2022 because I wanted a way to track my writing habits while also comparing how much original fiction VS fanfiction I wrote. It has since expanded to be more flexible, with a comparison function that's easy to adjust or scrap entirely, and a variety of other neat statistics besides. Key features include:
Line graph that displays your daily writing across the whole year.
Total word counts for each month displayed in stacked columns so you can see which projects you worked on.
Counters for your current daily writing streak and longest daily writing streak.
Pie chart to show which projects were worked on the most overall.
Ability to separate projects into "types" – i.e., personal and academic – and compare type totals each month.
Words-over-time progress charts for specific projects, with the ability to help set and track writing goals.
Daily and monthly averages.
You don't need to be a genius (or even fairly confident in using) Excel/Google Sheets to make this work for you. I've written up a detailed set of instructions that walk through each sheet and explain how to make a variety of changes, as well as breaking down how certain aspects work.
If this is something that interests you, follow the link below to my Payhip. It's a free resource; Payhip just gives you the option to leave a tip, should you feel like it and have the cash to spare.
This is a spreadsheet designed for writers who are encouraged by statistics – or at least, those of us who like watching numbers get bigger.
Want to know more? Keep reading below the cut for a closer look at the features.
