I lost track of which week I was supposed to post and missed last week. But that’s it, no more misses. That’s my goal.
I wrote earlier about having a goal for the number of words I would write this year for fiction. I set up a spreadsheet, so I could track myself. If you’re going to have a goal, you also need some way to know if you meet the goal or not. I’m going to set up a page where you can download the spreadsheet for anybody who wants to use it themselves. It’s set up so that I can enter the number of words I write in a day and track that against my goal.
Yeah, I’m a numbers guy and a spreadsheet geek. I thought I would write some posts about using Excel.
The spreadsheet is still a work in progress. I like to tweak it and add things. For now, if you want to use it for yourself you can download it. (Assuming you know a bit of basic Excel, of course.) To start using it for yourself do the steps listed below.
1.Change the beginning date to the date you want to start with.
2.Change the daily goal in cell I21 to your goal.
3.Delete all the numbers in column J from row 21 to 65.
4.Start entering your word counts. (If you’re using Word it will give you the word count in the lower left corner.) You’ll get a gold star on days when you exceed your goal and on days when your cumulative count is ahead of your goal.
There are no macros in this spreadsheet, so if you get a message asking you to enable content, do not do it.
I’ll go more in depth about this spreadsheet in future posts.
Tim Kane's memories, musings and updates.