Stories for women about women searching for truth in life and love

2014 Writing Progress Spreadsheet

Posted on Dec 17, 2013 | 82 comments

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!

  • http://arlenewritesromance.wordpress.com/ Arlene @ Love & Laughter

    This looks complicated … but I think I’ll give it a try.

    • http://jamieraintree.com Jamie Raintree

      Haha! You know me. It was complicated to make but it should be fairly easy to use (I hope!). Let me know what you think!

      • http://twitter.com/arlenehittle Arlene Hittle

        Now that I’ve started playing with it, it’s not as difficult as it looks. Thanks. ;)

        • http://jamieraintree.com Jamie Raintree

          Awesome! You’re welcome!

  • Wednesday

    I’ll try it. :) Thanks!

    • http://jamieraintree.com Jamie Raintree

      You’re very welcome! I want progress reports. ;)

  • RainGurl

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

    • http://jamieraintree.com Jamie Raintree

      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.

      • RainGurl

        That would be pretty cool. Now to just figure out how to work excel. :P

  • Pingback: Weekly recap | Allison Kelsey

  • http://twitter.com/jmatteliano Jessica Matteliano

    You’ve saved me a lot of work trying to design my own. I love these types of things, thank you so much!

    • http://jamieraintree.com Jamie Raintree

      You’re welcome! I love these types of things too. I’m organized to a fault. ;) Not the worst trait for a writer, right?

  • Pingback: Short Story Fridays: The Gate p.6b-Diligence | Neither Here nor There….

  • http://twitter.com/lorisizemore Lori Sizemore

    This is incredible. I can’t wait to start using this!

    • http://jamieraintree.com Jamie Raintree

      Thank you! Enjoy!

  • http://debsmorningpages.wordpress.com/ Debra

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

    • http://jamieraintree.com Jamie Raintree

      I told you I was a spreadsheet-aholic! Lol!

  • http://jessicaaspen.com Jessica Aspen

    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!

    • http://jamieraintree.com Jamie Raintree

      I’m so glad you like it! Unfortunately, adding more projects would mean recoding the entire spreadsheet. :(

      • http://jessicaaspen.com Jessica Aspen

        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 !

        • http://jamieraintree.com Jamie Raintree

          Nice! Good idea!

  • http://the-beginning-writer.blogspot.com Kelly Leiter

    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!

    • http://jamieraintree.com Jamie Raintree

      You’re very welcome! :)

  • http://www.ElizabethHaysmont.com Elizabeth Haysmont

    This is a BEAUTIFUL thing! Thank you, Ms. Raintree. It’s fantastic.

    • http://jamieraintree.com Jamie Raintree

      You’re welcome! Glad you found it useful. :)

  • http://www.garyspeer.com Gary Speer

    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

    • http://jamieraintree.com Jamie Raintree

      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. :)

  • http://www.spreadsheetjournalism.com Abbott Katz

    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

  • Ryan

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

    • http://jamieraintree.com Jamie Raintree

      Yikes! I better get on that. Thanks for the reminder. Yes, I will get that up soon.

  • http://arlenehittle.com Arlene Hittle

    I love using your spreadsheet. Thanks so much for updating it and sharing it again.

    • http://jamieraintree.com Jamie Raintree

      You’re welcome! Thanks for giving me the idea!

  • http://www.teacooperauthor.com Téa Cooper

    This is just what I need! An excellent New Year present. Thank you!

    • http://jamieraintree.com Jamie Raintree

      You’re very welcome! I hope you have a great year!

  • http://speculativesalon.blogspot.com Elizabeth Gibson

    Awesome Jamie! Thank you. It’s just what I need to see my progress.

    • http://jamieraintree.com Jamie Raintree

      Welcome!

  • Pingback: Let’s call resolutions something else | Leela Lou Dahlin

  • http://barbaraWallace.com Barb Wallace

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

    Barb

    • http://jamieraintree.com Jamie Raintree

      Thanks, Barb! I hope you get a lot of good use out of it!

  • http://callenerapp.wordpress.com Callene Rapp

    This. Is. So. Cool! Just what I needed and really easy to use! Thanks for sharing it with everyone.

    • http://jamieraintree.com Jamie Raintree

      You’re welcome! I’m glad you’re finding it useful!

  • Pingback: Here’s Something Else… from Wendig | Echoes Americana

  • http://nadiakilrick@blogspot.com Jacqueline

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

    • http://jamieraintree.com Jamie Raintree

      My pleasure. :)

  • Pingback: It’s a job(Repeat Indefinitely). | Only ONE Today. Every Day

  • http://twitter.com/youngshay513 Shannon

    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!

    • http://jamieraintree.com Jamie Raintree

      Awesome! Glad you like it! I’ll be posting one for 2014 in December.

  • Pingback: NaNoWriMo: Helpful Productivity Tools | The Discriminating Fangirl

  • Lauren Miller

    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.

    • http://jamieraintree.com Jamie Raintree

      Hey Lauren! Glad you like it! I’ll be updating it for 2014 and posting it here. Check back in a few weeks!

  • http://www.jonathanball.com Jonathan Ball

    This is brilliant. Please update it for 2014! I love it and if you update it I will love you. Thanks so much.

    • http://jamieraintree.com Jamie Raintree

      Well, who could deny that? ;) Updating it this week! Look for it here next week!

  • D. D. Falvo

    This is wonderful, Jamie! :D Thank you.

    • http://jamieraintree.com Jamie Raintree

      You’re welcome!

    • Jamie Raintree

      You’re so welcome!

  • Stacy S. Jensen

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

    • Jamie Raintree

      Thank you so much! I got your email and will send it over shortly. :)

  • https://www.facebook.com/Kimberly.Mayberry.69 Kimberly Mayberry

    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

    • Jamie Raintree

      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!

      • https://www.facebook.com/Kimberly.Mayberry.69 Kimberly Mayberry

        You got it. I will try working with it this weekend to see how it functions! I will email you back with my “review” of it. lol

        • Jamie Raintree

          Perfect! Thanks!

          • https://www.facebook.com/Kimberly.Mayberry.69 Kimberly Mayberry

            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!

          • Jamie Raintree

            Glad to hear it! You’re welcome!

  • JPaulette

    Thanks for posting this will have to give it a try.

    • Jamie Raintree

      Great! I’ll look for your email!

  • Robin Hillyer Miles

    Spreadsheets! I love spreadsheets!

    • Jamie Raintree

      Lol! You and me both. :)

  • Amy Pfaff

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

    • Jamie Raintree

      I’ll look for your email!

  • Pingback: How To Run Your Writing Career on an iPad | Jamie Raintree

  • Lauren Miller

    Hey Jamie, I’d love to get a copy of your spreadsheet.

    • Jamie Raintree

      I have your email! It’s heading your way!

  • Brenna Ash

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

    • Jamie Raintree

      Got it! Look for it shortly!

  • Christine Glover

    Wow! This is amazing. I am emailing you for the worksheets and thanks!!! You rock :)

    • Jamie Raintree

      I got your email! I’ll get that to you by the end of the day. :)

  • Celia Lewis

    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.

    • Jamie Raintree

      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!

  • Martie

    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.

    • Jamie Raintree

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

  • Debora Dennis

    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!

    • Jamie Raintree

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

  • Pingback: Guest Post–Jamie Raintree | Erindipity

  • Romy Sommer

    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!

    • Jamie Raintree

      I’m glad to hear it worked well for you! I’ll be updating it every year for the foreseeable future. :)

  • Pingback: The New Year has Options. | Only ONE Today. Every Day

  • Pingback: Stop Beating Yourself Up and Get Things Done - Heart-Shaped Glasses

  • Pingback: Writerly Links of the Week | AC MacLachlan

  • Author SarahLazowski

    This looks like what I have been searching for!!

    • Jamie Raintree

      Awesome! I got that out to you. Enjoy!

  • Janice

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

    • Jamie Raintree

      Awesome! Thank you for sharing! I hope you enjoy it!