Saturday, January 10, 2015

2015 Writing Goal Tracking Spreadsheet - Done and Ready to Download!

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.

1 comment:

Unknown said...

Thanks a lot for this! I was really expecting that you would update last year's spreadsheet. I have to say that this has been really REALLY helpful with my writing and I can only hope that someone who knows about programming/web could turn this wonderful tool into a website.

I'm a Spanish translator, so let me know if you're interested in translating this spreadsheet ;)

Best regards,

Felipe.