My Automated Writing Dashboard

A little something I have been playing around with in the tiny scraps of free time I have is some Google App Scripts that allow me to automate the presentation of some of my writing metrics. Or, in simpler terms: automatically create charts based on my writing data. This is still a work-in-progress, but here is how my automated dashboard is looking as of this morning:

Click to enlarge
Click to enlarge

The biggest benefit of these scripts is that they save me the time of having to create the charts manually from the data. I can open my spreadsheet, click on a menu option, and the charts update automatically. This means that not only is my data collected automatically, while I write, but the charts are now created automatically. And I can spend my time writing instead of manually collecting data and building charts.

By the way, the data for the “Writing Minutes/Day” chart comes from the new scripts I’ve written to track the time I spend writing, in addition to the words.

Published by Jamie Todd Rubin

Jamie Todd Rubin writes fiction and nonfiction for a variety of publications including Analog, Clarkesworld, The Daily Beast, 99U, Daily Science Fiction, Lightspeed, InterGalactic Medicine Show, and several anthologies. He was featured in Lifehacker’s How I Work series. He has been blogging since 2005. By day, he manages software projects and occasionally writes code. He lives in Falls Church, Virginia with his wife and three children. Find him on Twitter at @jamietr.

One reply on “My Automated Writing Dashboard”

Comments are closed.