For me, a motivator for publishing was imposing a schedule for myself. Initially,I posted three times a month. During one contract writing/editing job, I cut the posting to once a month throughout 2011. Since then, except for a 16-episode of weekly century plant posts in 2013, I have posted twice a month.
Not sure I'd return to more often if and when I again exit the working world. In any case, when I publish, the motions remind me of the clock reset (countdown timer) in the Lost TV show.
My graphs reflect the stats for the 5 periods for September through August (2009 through 2014). Wanting to generate stats, formulas, and graphs sent me scurrying to some Excel how-to Google searches. (I hardly ever use Excel.) Was I rusty! Couldn't remember how to assign repeating rows, create a formula, or generate a graph! Conveniently, during my research over my 130 articles, I ran across my SurveyMonkey article, which I had foresight to list some Excel formulas.
A couple of handy Excel-info webpages:
I had a bit of fun playing with Excel in creating the tables and graphs, then playing with them in my ancient PaintShopPro 7.04. In Excel, I became reacquainted with inserting some basic formulas and creating graphs. I rediscovered graphing options for type (bar, line), inserting numbers and titles, and moving numbers. In PSP, I further played with moving pieces, cropping areas, and combining the charts.
Related posts, besides the one about SurveyMonkey and using Excel:
October 31, 2014: Links to the series
- 5 Years of Continuous Blogging, Part 1
Focus on single- and five-year views for total articles, articles with images, and recipe articles.
- 5 Years of Continuous Blogging, Part 2
Focus on numbers of words in articles and graphical representations.
- 5 Years of Continuous Blogging, Part 3
More details on collecting the data.
- 5 Years of Continuous Blogging, Part 4
Emphasis on data sorting and distribution of word count groupings.