12-Month Word Count and Time Tracker - Excel Version

Tracks word count, time, and goals for multiple projects over 12 months, and shows NaNoWriMo-style graphs and statistics to help you stay on track! The sheet allows you to log daily word counts and time spent writing for each day of the year across multiple creative projects on a daily or cumulative basis . You can set your own custom 12 month period as well. You can also enter your word count and time goals separately for each project on an overall or month by month basis.

In addition, the writing tracker provides metrics such as your word count targets for each day, your cumulative word count progress vs. targets for each month, your day to day cumulative word count progress vs. targets over the whole year, and your daily and monthly targets for time spent writing.

The sheet also provides a number of graphs to help you see how you're doing day to day and across the year, as well as an overall summary page!

- Create an unlimited number of projects and project statuses

- 12 months of daily word count and time tracking

- Dynamic dates - do you go from December to November rather than January to December? That's fine! Put in your start date whenever you want - the sheet handles it for you!

- Flip between inputing daily word counts or cumulative word count to date

- Expand each month to enter daily progress or close for compact view

- Metrics for daily word count vs. daily targets and cumulative targets for the month and throughout the year

- Set variable daily word count targets for each month, including daily average, increasing, decreasing, and custom targets

- daily and yearly goal setting

- Flip between Hours or Minutes

- Project statistics - total written, average, days, longest streak, and more.

- Access to the full range of graphs - Select the month and view Written Daily, Cumulative by Month, Overall Cumulative, Hours/Minutes Written, and Words Per Hour/Minute, or view overall 12 Month Totals, 12 Month Cumulative, 12 Month Words Per Hour/Minute, and 12 Month Hours/Minutes Written

- Calculate Words Written - input two dates anywhere within the 12-month date range, and see how many words you wrote

- Project Dashboard with statistics, project summaries, and progress chart

- Project Status Pie Chart

- Overall summary tab that aggregates the data entered across all projects, and which also includes the full set of graphs that show your progress vs. your targets across all projects

- Google Docs version: Overall, monthly, and daily progress bars to help you see where you are at any point!

Want to try before you buy? Get the FREE Trial version here!

To grab it, simply copy the URL below into your browser, and do File -> Make a Copy, or File -> Download to grab the .xlsx file.

https://docs.google.com/spreadsheets/d/1fnipMg8a-kGCbWA11YzPfQezDz82ee_z-oQxVIVgBN0/edit?usp=sharing

The Free Trial version allows 3 months of tracking and up 2 projects, defaults to average daily targets, and has 3 graphs: Daily Written, Cumulative By Month, and 12 Month Totals.

If you enjoy the Trial version, be sure to grab the full one to get all the features a full 12 months of tracking, the Calculate Words Written feature, variable word count targets, the Overall summary tab that shows your metrics across all projects at a glance including graphs, and the full set of 9 graphs!

Need Help? Please see the USAGE GUIDE:

https://docs.google.com/spreadsheets/d/1UbalAA4brszV1FbbRgB05i9oDYVowzgYNIQawLHsGCU/edit?usp=sharing

Questions? Please contact evil.minion.universe [!at] gmail.com.