Sorry for the delay, but I think I'm finally done. For this year's spreadsheet, I modified my NaNo Tracker spreadsheet into a year-long version. With this version, you just have to enter your total word count at the end of each day and the spreadsheet calculates everything for you--total words written each day, total for the month and year, remaining words to meet your goal for that month, etc.*
|
Enter total word count in the green column and the spreadsheet does all the work for you. |
In addition to a sheet for each month, the workbook includes a setup page with the options to enter a later start date and a starting word count. I've also included a stats page so you can keep track of how you're doing for the year.
I've created three separate workbooks to allow you to set a daily, monthly, or annual goal based on what meets your individual needs. Click below to download.
Annual Goal
Monthly Goal
Daily Goal
Please note, the spreadsheets are locked. You will only be able to modify the green cells. These are the cells that drive all the formulas. To protect my work, I will not be giving out the password. If you have issues downloading or getting it to work, please let me know either in the comments or by
email, and I'll send you the file(s) directly.
I think I've worked out all the bugs*, but it's possible I missed something. If you find that something doesn't work like it should or if you have any questions, please let me know. Happy writing! :)
*Spreadsheets were created with Microsoft Excel 2013. They may lose some functionality with earlier versions of Excel.