Enter total word count in the green column and the spreadsheet does all the work for you. |
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.
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.
ReplyDeleteI'm a Spanish translator, so let me know if you're interested in translating this spreadsheet ;)
Best regards,
Felipe.