I've always been a calendar girl. Not in the pinup sense, but in the milestone tracking sense. Even mundane tracking appeals to me. I actually still have the calendars I used all four years in college listing daily homework assignments. Back then, I tracked which parties I went to on the weekends as well. There's a novel hiding in those date books, just waiting to be written someday...
If you've read some of my recent posts, you know I follow Austin Kleon, an artist from Austin, TX. He had a recent post about
Jerry Seinfeld's plan for productivity that tied my calendar obsession to my writing, and I'm loving it, so I thought I'd share.
Briefly, Seinfeld used a wall calendar and tracked the days he wrote with a big red X. Then he saw his progress and hated to break the writing chain. It helped him reach his goals, and I knew right away that it would help me stay on track this summer.
I created a Google doc spreadsheet for the remaining months of the year. Using Conditional Formatting (under Format menu) I added color coding for word counts for new books on one sheet and hours of editing for revisions on another.
 |
| Words Written |
|
- 0-500 words or 15 mins. = RED
- 501-1000 words or 30 mins. = ORANGE
- 1001-1500 words or 45 mins. = YELLOW
- 1501-2000 words or 60 mins. = GREEN
- 2001-2500 words or 75 mins. = BLUE
- 2501-3000+ words or 76+ mins. = PURPLE
|
 |
Hours Minutes of Editing
I was doing some SERIOUS editing in hours - ha! |
Now the document automatically shows me good days and bad days by color. I'm working towards all purple days because purple is Lucie's favorite color. My editing minutes are low, but I found that I needed more incentive to work on the edits than new writing. This way, even on a busy day I know I'll search harder for time to edit. Slow and steady wins the race.
Not much purple yet, but I'm hoping for a big day today. And once I start a purple chain, I'll work even harder not to break it. If you're interested, at the end of July I'll post my updated spreadsheet to show my progress.