NOTE: This post is repeated from last year but the spreadsheets have been updated for 2014.
It’s the start of the new year and, of course, that means the updated writing progress spreadsheet. For those of you who are new to using it, find the description and instructions below. For those of you who are spreadsheet veterans, skip right to the bottom to find out how to get your copy for this year!
The first thing you’ll notice (for 2007 users) is that there are multiple worksheets. The spreadsheet will open to the first worksheet, pictured below, where you will name your projects. Simply highlight the cell where it says “Project 1″, “Project 2″, etc. and replace it with the names of your projects. It will change the titles throughout the entire workbook. I recommend keeping them fairly short–one to two words or an acronym–otherwise they’ll run over on each other.
Along the bottom are your worksheets. There is one for the titles, one for each month of the year and a yearly totals sheet. Choose the month you’d like to go to and you’ll find a worksheet that looks like the one below. On the left, it’s laid out like a calendar, on the right, by day and at the bottom, a graph of your progress.
You will ONLY make changes to the daily section of the spreadsheet. All other areas have functions to automatically add up totals for you. So, for instance, you’ll go to the third day of January and enter the word count for Project 1 (or whatever you’ve renamed it). It adds your word count for today to the total Project word count for the month at the bottom of that column, it also appears in the calendar, which calculates your word count for all projects each day and then gives you a total sum at the end of each week and a total sum for the month at the bottom of the calendar. Note that on the weekly totals, it’s calculated for 7 days so the first week might look a little high, but it’s actually pulling the totals for the last days in the previous month.
Lastly, your final sheet will add up totals for the entire year by project, by month and also a grand total for the entire year.
The cells containing functions are locked to avoid accidentally deleting the function but if you need to make changes, there is no password so just hit enter when it prompts you for one and you should be allowed to make the changes after that. If you come across any bugs, let me know and I’ll do my best to fix them.
I hope this spreadsheet helps you keep track of your writing goals and I hope you fill each and every cell with writerly love.
Get Your Copy!
To get a copy of the spreadsheet, send me an email at author (at) jamieraintree (dot) com and let me know which format you need: .xls (Excel 97-2003) or .xlsx (Excel 2007). I’d love to know what kind of writing you do and how you plan to use the spreadsheet! I look forward to hearing from you and wish you all a productive new year!