• Home
  • About
  • Books
    • Book Extras
  • Blog
  • Editing
  • Contact D’Ann
  • search
  • Menu
  • Skip to right header navigation
  • Skip to main content
  • Skip to primary sidebar

D'Ann Mateer

Author, Editor, Reader

  • Home
  • About
  • Books
    • Book Extras
  • Blog
  • Editing
  • Contact D’Ann
  • search

Productivity spreadsheet

Home » Uncategorized » Productivity spreadsheet

In: Uncategorized on: January 2, 2012

Sometimes we feel as if a whole year has gone by and we have nothing to show for it, in terms of our writing. But this is not necessarily true. A little can add up to a lot!


If you have been writing for very long, you know that it can be very easy to feel unproductive over the long term. Unless you have a book published, you can come to the end of a year and wonder what all that butt-in-chair time has added up to, because it often feels like nothing. But if you are diligently working at your craft, be it fiction or non-fiction, blogging, article writing, etc., I would guess that you have accomplished more than you think you have over the course of a year. One way to see how all those writing minutes, word counts, and page revisions add up is to keep track of them. For me, the easiest way to do that has been a productivity spreadsheet.


It’s easy to set one up in Excel or Numbers. Just label the rows with each day of the year, leaving a blank row at the end of each month for your monthly totals. Then label the column headings with the writing activity that you desire to track. When I began this system in 2005, I tracked only new words written. Since then, I have added things like Pages Revised (of my own work), Pages Edited (for other people, like my critique group), Books Read, Writing Meetings Attended, Research Time, Pre-Writing Time, etc. The possibilities are endless. At the end of each column that contains a numeric value, add a function in the blank row that will calculate the total for that month. At the end of each month, you will see how much have have accomplished. This can serve to encourage you that you are doing more than you realize or it can serve as a kick in the pants to get to work! Either way, it helps break down your writing into quantifiable goals.

After the December monthly totals, add a row that will calculate your yearly totals for numeric columns. This can be huge in realizing that small amounts of work add up to so much over the course of twelve months. If you want, set up another sheet that charts the totals for each year, you can chart your progress over a span of year. For instance, this year (2011) I logged over 168,000 new words. Compare that to the first year I kept a spreadsheet (2005). That year I logged just under 60,000 words. This showed me that I have not only grown in my craft, but also time spent writing and in my output during that time.

The best way to use the spreadsheet (i.e. not forget to log in your activity), is to keep it in an easy to access place on your computer, such as your desktop. Get into the habit of logging what you’ve done immediately after you finish, not at the end of the day. And by adding the sum functions into your spreadsheet, you don’t have to remember to “total up” at the end of each month. Those totals just appear!

Writing can be a solitary task with little to “see” at the end, so keeping track of your progress daily can help keep you motivated for long term goals. Using a spreadsheet is one easy way to make that happen. Since as a writer, you are self-employed, think of your spreadsheet as your career performance review each year. I think you’ll come away amazed at all your have accomplished, no matter what type of writing you do.


Tagged: productivity, Uncategorized

« Previous
Next »

Reader Interactions

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Primary Sidebar

Let’s Stay in Touch!

Want to know what I’m blogging? What I’m reading? When the next book comes out? When you sign up, you’ll also receive a free short story via email. And every quarter I will choose a random subscriber who will receive a free book! So what are you waiting for? Let’s stay in touch!

You have Successfully Subscribed!

Blog Categories

  • Book Extras
  • Faith
  • Family
  • History
  • Life
  • Reading
  • Uncategorized
  • Writing

Recent Posts

  • Books I’ve Pre-Ordered March 22, 2023
  • Monarch of the Glen March 16, 2023
  • Matthew 7 March 8, 2023
  • Uncurated Research March 2, 2023
  • February Reads post February 28, 2023

Some blog posts and pages contain affiliate links. This means when you click on links to various merchants on this site and make a purchase, this can result in a commission that is credited to this site. Affiliate programs include, but are not limited to, Amazon.com. This disclosure complies with the FTC’s 16 CFR, Part 255 : “Guides Concerning the Use of Endorsements and Testimonials in Advertising.”

Site Footer

Quick Links

  • Home
  • Editing
  • About
  • Books
  • Contact D’Ann
  • Terms and Conditions
  • Privacy Policy

Copyright © 2023 · D'Ann Mateer. All Rights Reserved.
Website by Stormhill Media
Log in