Tuesday, April 5, 2016

2016 Words Per Day Tracking Spreadsheets


I realize it's April, so many of you are probably well past the point of needing a tracking spreadsheet for your word count. And really, I hadn't planned on updating the spreadsheets for 2016. Between work and teenagers, time is not my friend these days. Then I got an email from Hugh Pile* with a request to update them, and he might have said something about them being the "best wordcount-tracking spreadsheets on the Web." So, of course, I dropped everything and updated them right away. Well, I wanted to, anyway.

The past couple of months have been insane with the implementation of a new electronic timekeeping system at work (we've finally entered the 21st century!), which I'm super excited about, but Hugh had to wait over a month for me to get the spreadsheets updated. Thanks for being so patient, Hugh. :)

Download links are below if you would like to use them. I've created three different versions--daily, monthly, and annual. Use one or all. Whatever works for you. Let me know if you have problems with any them. Also, FYI, I've protected the pages and the workbook to protect the formulas and formatting, and the hours and hours of work I've put into them. If the protections affect the functionality, please let me know.

Happy writing, everyone! :)

Words Per Day - Annual Goal
Words Per Day - Monthly Goal
Words Per Day - Daily Goal

 *Hugh, if you're reading this and would like me to link to a blog or website, please send me your info or leave it in the comments and I'll update this post.




Thursday, October 29, 2015

NaNo Tracker 2015

I'm not participating in NaNo this year, but I've updated my NaNo Tracker for 2015. If you're interested it using to track your NaNo progress, just click here to download the Excel 2007 and newer version. :)

Original NaNo Tracker (with more pictures) here.


Happy writing!
Want a spreadsheet to track your NaNoWriMo goals? Download one here from @abbyannis

Thursday, January 15, 2015

2015 Writing Goal Tracking Spreadsheet

Sorry for the delay, but I think I'm finally done. For this year's spreadsheet, I modified my NaNo Tracker spreadsheet into a year-long version. With this version, you just have to enter your total word count at the end of each day and the spreadsheet calculates everything for you--total words written each day, total for the month and year, remaining words to meet your goal for that month, etc.*

Enter total word count in the green column and the spreadsheet does all the work for you.
In addition to a sheet for each month, the workbook includes a setup page with the options to enter a later start date and a starting word count. I've also included a stats page so you can keep track of how you're doing for the year.



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.

Sunday, January 4, 2015

2015 Writing Goal Tracking Spreadsheet Coming Soon!

Things have been crazy with moving (I got a new house! Yay!) and then the holidays and work, so I haven't had any time to work on anything extra. But I am planning on putting together a tracking spreadsheet for 2015, kind of like the one I did for 2014, only better. I'm hoping to have it done by the end of this week. Be sure to check back!

Happy 2015, everyone! :)

Thursday, October 30, 2014

NaNo Tracker 2014

I'm not able to participate in NaNo this year because we're buying a new house! There's just too much to pack and clean before its completion on December 1st. So overwhelming but so exciting. :)


Even though I'm not participating, I've adjusted my NaNo Tracker from last year to work for this year. If you're interested in using it to help track your NaNo progress, just click here to download the Excel 2007 and newer version.

If you would like the 97-2003 version, shoot me an email by clicking the button on the left or leave your email address in the comments and I'll send it to you. Just so you know, I got about a million compatibility warnings when I saved that version, so no guarantees it will work properly.

If you have issues getting the spreadsheet to work, please take a look at last year's post for more info or leave your questions in the comments.

Happy NaNoing, everyone! I hope you all reach your goals. :)
Want a spreadsheet to track your NaNoWriMo goals? Download one here from @abbyannis