Recently a ton of people have liked an older story of mine, Writing Dashboard: Track Your Writing Habits.
Based on some amazing user feedback, I’ve put some extra thought into the functions my Writing Dashboard performs to add to its feature set, while also keeping to the core reason I built it in the first place.
Apps that track data are nice, but you really get excited when you put the effort into the manual, daily recording of effort.
So, what is different?
From the first incarnation I’ve made some minor tweaks to how the dashboard records dates and times.
Firstly, dynamic dates.
I’ve updated the sheet to be incredibly flexible depending on the start date you choose.
In the Date Started field, simply type today’s date in DD/MM/YYYY format, and the Writing Totals sheet will automagically adjust the dates and days to fit. This also updates the first day of the week, so if you do happen to choose a mid-week day to start, just be aware of that.
No longer is daily time just a dumb number field, but now you can enter hours and minutes.
Did you write for seven minutes and nailed a hundred word masterpiece? Put it in!
I’ve also updated the dynamic tracking of additional data collected from the sheet, anytime you enter data it will update the newly minted Total Words, Total Time, and # of Days Written metrics.
Of course it wouldn’t be complete with a few new tricks over on the dashboard view.
I’ve tightened up the statistics with new auto-colouring, along with a new statistic of total days written for the year. Graphs have been slightly refreshed, and overall graph dynamics have been improved.
As an additional step I’ve also removed the Microsoft Excel version from development as the statistics I’ve gathered showed a negligible amount of downloads when compared to Apple Numbers.
Also published on Medium.