I'm not participating in NaNo this year, but I've updated my NaNo Tracker for 2015. If you're interested it using to track your NaNo progress, just click here to download the Excel 2007 and newer version. :)
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.
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.
Things have been crazy with moving (I got a new house! Yay!) and then the holidays and work, so I haven't had any time to work on anything extra. But I am planning on putting together a tracking spreadsheet for 2015, kind of like the one I did for 2014, only better. I'm hoping to have it done by the end of this week. Be sure to check back!