2014 Writing Progress Spreadsheet

NOTE: THIS SPREADSHEET IS OUTDATED. FOR THE MOST RECENT SPREADSHEET, CLICK HERE!

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. Also note that any added on projects will not automatically calculate in without additional adjustment to the code.

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!

NOTE: THIS SPREADSHEET IS OUTDATED. FOR THE MOST RECENT SPREADSHEET, CLICK HERE!

Jamie Raintree is the author of Perfectly Undone and Midnight at the Wandering Vineyard. She is a voracious student of life, which is why she became a writer, where she could put all that acquired information to good use. She is a mother of two, a wife, a businesswoman, a nature-lover, and a wannabe yogi. She also teaches writers about business and productivity. Since the setting is always an important part of her books, she is happy to call the Rocky Mountains of Northern Colorado her home and inspiration.

Loading Facebook Comments ...

Comments (84)

  1. Oooooo how pretty! I love what you did with it this year. Hmmmmm wonder how I can apply it to blogging…

    1. It’d be easy enough to write your blogging word count in there. Or just a “1” for every day you blog. You could keep track of how many blogs you post in a year that way.

      1. That would be pretty cool. Now to just figure out how to work excel. πŸ˜›

    1. You’re welcome! I love these types of things too. I’m organized to a fault. πŸ˜‰ Not the worst trait for a writer, right?

  2. Thanks for sharing Jamie. I do love spreadsheets. And I do like to keep track of my production. Have a great day!

  3. Love this Jamie! I can’t wait to get my projects up and running on here. One question: how do I add more projects? I love the idea of keeping track of blogging on here too and I have lots of projects that are in the finishing stages of editing, so I need some room for the new ones. I’m an excel illiterate, but I’m trying to learn!

      1. Just start a new spreadsheet and label it differently. Then you can have all new projects on that one! That’s what I did last year when I ran out of room. πŸ™‚
        Love this years spread sheet and I’m so excited to get started in January !

  4. This looks wonderful! I’m just about to tackle several projects that have minimum word counts so this will be very helpful. Thank you so much for sharing with us!

  5. Hi Jamie. I found your site and this excellent spreadsheet tool via Google. I’ve been looking for something exactly like this to start seriously tracking word counts on some short stories, a novel, and even some blog posting.

    May I have your permission to link to the blog post/article offering the spreadsheet on my home site? I would plan on doing a blog post there telling my readers generally about your site and your work, and specifically about the spreadsheet with a specific link to the spreadsheet.

    Gary

    1. I’m so glad you’re finding it useful, Gary. You can absolutely link to it. And I usually update it every year so come back if you need one for next year. πŸ™‚

  6. Hi. The daily activity you’ve committed to your Writing Progess Spreadsheet could be more efficiently tracked with an Excel pivot table, which would obviate the need for separate monthly tabs. You can email me about this if you wish.

    Thanks,
    Abbott Katz

  7. Jamie, I’ve used this daily in 2012, but 2013 is getting close. Will you have an update soon!?

  8. Thanks Jamie! Melissa McClone recommended this to me. It looks excellent. I’ll be sure to recommend it to my followers as well.

    Barb

  9. I’ve tried to create a spreadsheet to keep up with my writing projects without much success. This is great. Thanks for sharing, Jamie.

  10. I love this spreadsheet. I just linked to it because EVERYONE should know about this. I’m using the five-title tracking to help me write a series!

  11. Hey Jamie, this looks like a great system! I’d love to try this out for 2014. Any suggestions on how I can update it without breaking the code would be appreciated.

    Thanks for offering such an awesome tool for free!

    Happy holidays.

  12. I submitted my request and shared this post with two picture book/children’s writers groups. Thanks for sharing.

    1. Thank you so much! I got your email and will send it over shortly. πŸ™‚

  13. Do you have a version for Excel 2010 or one that will work? I would love to use it. I have several wips I would like to keep track of and it is hard. lol I write a little bit of everything from children’s, paranormal, and erotica. kbinmich AT yahoo DOT com

    1. That is great question! I got your email so I’ll send it over to you. I would love it if you could message me back and let me know how it works. Look for it shortly!

          1. As far as I can tell, it works great with Office 2010! I just peeked around a bit, until I can organize my documents to get them all typed into the spreadsheet, but it seems to function as intended! Thank you!

  14. I’ve been trying to do something like this and have failed. Would love to try it for 2014.

  15. This is awesome! Thanks for sharing. I’ve sent my email in. Cheers!

  16. Wow! This is amazing. I am emailing you for the worksheets and thanks!!! You rock πŸ™‚

    1. I got your email! I’ll get that to you by the end of the day. πŸ™‚

  17. Perfect! I’ve already set it up for January. My current book which needs much rewriting and revising is listed as Project 1; my 2 sequels are also listed as Project 2 and 3. I’ve got an idea for a short story – Project 4. Wow. Do-able!! Thanks so much for this, Jamie.

    1. You’re so welcome! Thank you for sharing how you’re using it! I’m just glad there are people out there who love stats as much as I do. Lol!

  18. Girl, you are the new excel queen. I remember a holiday when my girlfriend and I met in Williamsburg and sat in the hotel room sharing our spreadsheets. Sad, huh? This is a beautiful, awesomely practical spreadsheet. Thanks for making it available.

    1. Lol! Thanks, Martie! I promise you, I’m not. Just determined! Glad you like it!

  19. I’d love to get a copy of this spreadsheet too! I think I have the newest version of excel (2010?) so I would need the .xlsx.
    Thanks! Can’t wait to start it up!

    1. Hi, Debora! Absolutely! Just send me an to address listed above so I can attach it for you. Thanks!

  20. Jamie – thanks so much for sharing this again. I used your 2013 spreadsheet and LOVED it, and I was about to start adapting it for this year (a massive task, as you know) so I’m thrilled you’ve chosen to share your skills again. I’ll definitely be emailing!

    1. I’m glad to hear it worked well for you! I’ll be updating it every year for the foreseeable future. πŸ™‚

  21. I submitted my request and shared this post with two picture book/children’s writers groups. Thanks for sharing. Janice

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

%d bloggers like this: