Writing Tracker and Statistics 2.0

This is a spreadsheet designed for writers who are encouraged by statistics – or at least, those of us who like watching numbers get bigger. Once it's set up with your projects, all you need to do is input your daily writing, and watch the graphs, charts and statistics on the rest of the workbook generate over time. (And you don't need to be a genius at spreadsheets to set this up, either! The instruction manual walks through each sheet and covers a variety of customisations and manual changes you might like to make).

Its 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.

Note: The instructions are tailored to Excel and Google Sheets. There is a link to a Google Sheets-optimised version in the first sheet of the downloadable xlsx file. The xlsx file format is also compatible with LibreOffice's Calc and WPS Office's Spreadsheet, but as I haven't tested this workbook in either application, I can't speak to its functionality there.