Tag: averages

Not only did I strut around in a tee-shirt this morning and early afternoon for errands, with my car window down no less, but yesterday I was sweating.

It’s February! In Pennsylvania!

Odd, odd stuff.

Well, Friday I ended up writing too late to get many words, but I eeked out 122 anyway. 304 words total. The upside is, I got words! The downside is that my daily average was dragged back down to 492. I’ll need another 1,000 words today to get my average back up to 500.

I can do that. I really can. But will my bok steal my attention tonight or will the words win? Only time will tell!

Math does not come naturally to me, but I do love me some spreadsheets and formulas to automatically calculate fabulousness.

For example. In my word tracking spreadsheet, I type in my words written for this blog in one cell and fiction in another. =SUM automatically calculates how many words I’ve written for the day. =SUBTOTAL calculates the cumulative words for the blog, fiction, and daily totals, as well as counts how many days I’ve written (I add comments about the day in a notes column).

=SUM gets me weekly totals as well. =ABS gets me the difference in words written from one week to the next. =AVERAGE is calculating the average total words I write per day, and also my average fiction words.

=RANK ranks my weekly totals, so at a glance, I can find my most productive week of the year.

I love my spreadsheets.

Yesterday I wrote 879 words of fiction. 242 words fell onto this blog. I’ve written 10 days in a row, and 11,152 words total. My average daily word count is 1,115, and my average fiction daily word count is 804.The week is ranked number two, so far, but really that’s not saying much as week one was one day (January 1st, because my weeks start on Mondays), and the number of words for week one were low (483), making it an easy target to beat.

The week is ranked number two, so far, but really that’s not saying much as week one was one day (January 1st, because my weeks start on Mondays), and the number of words for week one were low (483), making it an easy target to beat.

I’m going to continue working on today’s words. I managed to haul myself out of bed at my desired time of 5 a.m., and it has paid off. I look forward to making good progress today and bringing up my average daily count.