NOTE: This post is repeated from 2011 and 2012 but the spreadsheets have been updated for 2013. Enjoy!
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 and download the new files 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.
Want to Say “Thanks?”
I’m happy to offer this spreadsheet to you and I hope you enjoy it all year long. While I don’t require anything in return, if you feel so inclined, I always love the opportunity to meet new readers of Women’s Fiction and Romance. If you think any of your friends would be interested in reading online fiction, talking about TV, movies and books, or reading my future novels, please send them my way or share the link to my Facebook page, linked below. I truly appreciate it!