Track all the time
Tuesday, 2 February 2016 08:41 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
sarasa_catAdded a bunch of columns to my word/project tracking spreadsheet.
For each individual writing project I have 3 extra columns (per project, not aggregate!) for:
-- time writing new words
-- time editing (replacing words & punctuation with different words & punctuation)
-- time proofing, formatting, posting/submitting/etc.
I still need to add all the summation to my summary table...
Last month all time for all projects was in one column "time" that wasn't even formatted for time (it was pure numbers and it rounded). I made gross estimates of time across all writing and I can't tell when I over or under estimated for the day.
well. No more of that!
Yesterday was something like 800 words in 30 or 35 minutes and it is marked as such on my spreadsheet (exact numbers, not these from my phone random estimate memories). This is important. I have so little time to write that if I miss my daily writing window, it is gone. I really need to squeeze words out of an overly tight schedule and this is the only way I can make sense of it.
Yay data! curious to see what more accurate time tracking will reveal.
For each individual writing project I have 3 extra columns (per project, not aggregate!) for:
-- time writing new words
-- time editing (replacing words & punctuation with different words & punctuation)
-- time proofing, formatting, posting/submitting/etc.
I still need to add all the summation to my summary table...
Last month all time for all projects was in one column "time" that wasn't even formatted for time (it was pure numbers and it rounded). I made gross estimates of time across all writing and I can't tell when I over or under estimated for the day.
well. No more of that!
Yesterday was something like 800 words in 30 or 35 minutes and it is marked as such on my spreadsheet (exact numbers, not these from my phone random estimate memories). This is important. I have so little time to write that if I miss my daily writing window, it is gone. I really need to squeeze words out of an overly tight schedule and this is the only way I can make sense of it.
Yay data! curious to see what more accurate time tracking will reveal.
