Along with writing, I am very much a numbers geek. Goals, keeping track, statistics…
Oh yeah, I love ’em!
One of the many ways I do that is by keeping track of my writing and revising process. However, I had a problem when looking for a good way to keep track of it, and that is that I don’t like the daily tracking spreadsheets. I wanted something more flexible.
So, I came up with my own. One that tracks daily, weekly, and month. Depending on my mood and the events in (annoying) real-life, it is flexible enough to keep track. Plus, thanks to the “Totals” tab, I can see in an instant what projects I’ve written on in the year.
There is a tab with instructions, but here are the basics to get started:
1. Decide on the yearly goal and type into the box on the upper left corner in both the “Revision Count” and “New Word Count” tabs (Yellow cell ONLY). Stats and weekly/monthly goals will automatically adjust.
2. Update how many days of the week you have available to write (1-7). The “Writing Days” column will automatically adjust to show how many writing days you will have as each week progresses. You will also see in the last week how many writing days you’ve allotted yourself for the year.
NOTE: The first tab is information collected from the entire spreadsheet and displayed for convenience. Do not manipulate anything in this tab.
You can play with how big or small a yearly goal you want, as well as adjust to how many days a week you have available and see how the numbers change. This will help you come up with something realistic for your situation.
Stats included: Average Per Day Needed (Adjusted for how many days a week available to write), Average Per Week Needed, Average Per Month Needed, Ahead or Behind (Week), Goal for Tomorrow (Daily), Average Per Week, Average Per Day, Percent Complete, Year Total, Month Totals, Monthly Average
Down below you will find both Excel .exl and Open Office .ods formats. Have fun with 2014!
Excel File Format: 2014 WordCount Tracker TEMPLATE
Open Office File Format: 2014 WordCount Tracker TEMPLATE
The String Weavers
(The String Weavers – Book 1)
Disappearing food. Music no one else hears. An alien dropped off by a giant flaming bird…
Abducted from Earth, Kelsey Hale finds herself in the middle of a deadly conflict among alien worlds and parallel universes. She must not only survive, but also rescue her father from a dangerous group of unknown intent. In the process discovering a family secret that will change her life forever.
With the mysterious Weavers connecting it all.
** Book One in “The String Weavers” series **
Amazon | Apple | Barnes and Noble | Kobo | Smashwords