I have an elaborate google spreadsheet for keeping track of my writing, and I hate it. I need it, but I hate it. Until today!
So, what’s wrong with my elaborate google spreadsheet? First, I have to create a new one every year. In order to be able to parse the information on it, I have the data organized in a way that is easy to interpret, but so very stupid in terms of data organization. So I recreate this sheet every year in a way that I know to be organizationally stupid, but there’s no other way. Also, I fight with google’s charts.
Today, I decided it was time to recreate the spreadsheet, but this time with beautiful and correct data organization. Instead of using google spreadsheets for visualizing the data, I’m using Tableau.
I’m pleased with the results so far. All I really want are some bar charts and some aggregate numbers (e.g. avg per day written, avg per day in general). I want to get more writing intelligence (as opposed to business intelligence) out of the data, but that’s for another day. Today, I can just add to my writing count in google sheets, keep track of things I want to keep track of, and the charts will update daily and I can bend that data to my visualizing will later.
One thing I haven’t figured out yet is how to account for writing effort that’s not actually writing, such as planning, plotting, outlining, and editing. I wish I could add marketing to that list, but I hate self-marketing. Anyway, like today, I accomplished significant planning & plotting while at the playground with my kid, but how do I want to keep track of that? idk. Suggestions welcome.
Here’s what we have so far: