Last week didn't go as I had planned. I took a vacation to head down to Lincoln City, Oregon, for a writing workshop on writing fantasy. I've done several of these workshops taught by Kristine Kathryn Rusch. I signed up for this one (and the Anthology Workshop I went to in February) back when I was finishing my MLIS degree as a sort of celebration of graduating. Despite looking forward to the workshop, I found my stress increasing as it drew closer and I ended up getting sick and leaving the workshop early. It's made me think about vacations and the importance of rest and balance.
Creating graphs is one way to visualize your writing progress. It can provide quick insights, particularly over time as you record more information about your word counts in your spreadsheet. If you're unfamiliar with using Excel, you may want to start with the previous posts in this series, starting with the benefits of writing streaks, demystifying spreadsheets, improving the tracker, pivoting for more information, adding project details, and writing a formula to track streaks.
I talked about writing streaks at the beginning of this series, then went on to describe how to set up a basic word count tracking spreadsheet, added improvements to the spreadsheet, created a pivot table summary, and expanded the spreadsheet with project details. In this post, I calculate a writing streak in the word count tracking spreadsheet. I'll walk you through each step of creating the formula necessary.
I started this series on creating a word count tracking spreadsheet by talking about the benefits of writing streaks, how to set up a basic spreadsheet, added enhancements, and created a pivot table summary. If you haven't read those posts you may want to go back and take a look unless you're already comfortable with Excel. As a next step, we'll add project details in this post, which gives us additional information about our writing.
This series started by talking about streaks, went on to spreadsheet basics in creating a tracking spreadsheet, and then leveled up the spreadsheet with an Excel table. In this post, I'll show you how to use pivot tables for greater insights into your writing. Yes, writers pivot tables too—it's an easy way to discover different ways to look at your word counts.
In the last post, I went over the basics of creating a simple word count spreadsheet. If you're not familiar with spreadsheets, it's a good place to start. As simple as the spreadsheet is, it provides a foundation for other improvements. Recording the data is only the first step. With the improvements to the word count spreadsheet in this post, we'll start to see how it can be used to provide more information about our writing.
I love data and data tools. Some of my fellow librarians find this amusing—and useful! I find data very useful. This isn't usually considered odd in athletic pursuits. People routinely track and discuss data about their favorite sports teams. If you're a runner you probably know how far, how long, and at what pace you ran. There's a good chance you track that information. Wearable tech has made it easier than ever to track our athletic efforts, visualize the data, and inform our attempts to improve. In my last post, I talked about the power of streaks. Today, I want to share some tips on using simple spreadsheets for tracking your word counts.
I'm a full-time librarian with a family and a writing career. The best way I've found to get words on the page is incredibly powerful. It's also a bit like trying to build a fire with your bare hands. Many writers try starting a writing streak after hearing about the benefits—and it works about as well as most New Year resolutions. I'm going to share the simple techniques that I use to start a streak and build it into a powerful force in your writing career.
I love reading short stories. I don't ever have enough time to read all of the short stories that I'd like to read (or novels). Although I'm always happy to read an anthology or collection, I love reading science fiction magazines. I continue to submit my stories to these markets as well, and look forward to appearing in the pages of these magazines.