I remember a neat tool Mrs. Johnson gave me in Pre-calculus my junior year of high school. At the start of the year, she handed us a sheet of paper with several columns labeled things like assignment name, points earned, and total points. It was a way for us to track our grade throughout the year. The OCD in me loved it and I used my own grade tracker throughout college.
Before I started writing and after I set my goals, I wasn't sure how to track my progress. And then I remembered Mrs. Johnson's Pre-Calc class.
And thankfully, I know how to use Microsoft Excel.
You might be able to find word count trackers online for NaNoWrMo (National Novel Writing Month) that you can edit to suit your needs, but I'll walk you through the bare minimum that I use.
In my Excel sheet, I have SIX columns: Date, Daily Goal, Daily Total, Running Total, % Complete, and Notes. I filled in the DATE and DAILY GOAL columns right away since I planned to write every day as well as my [projected word count]. The NOTES column is where I leave little updates such as when a chapter is completed. The remaining three columns are the most important and a little technical.
Once you fill in your Daily Goal and dates, all you have to do is add your daily total and running total cells as you write.
To calculate the % Completed, I used a simple formula: the running total / my projected word count. If you are savvy with Excel, all you have to do is select the running total cell and divide it by the cell of your choice. The formula will appear in the formula bar under the tool ribbon.
I decided to track my progress by chapter as well [see Progress Bar on the right side of blog]. Since I'm a plotter, I mapped out my novel by chapter thus I know how many chapters I have left to write and am able to track my chapter completion. It helps me see how far I've progress in the story overall, like a virtual bookmark.
Keeping track of your progress is great accountability when setting a goal. It also helps create a habit of writing daily. If you choose to track your progress, remember not to get caught up in it. Don't let it discourage you if you don't reach a certain goal. Life gets in the way sometimes. There are plenty of writers out there who would binge write and go days without writing a word. Tracking should just be another tool in your tool box.
Read More »