Welcome! I've written some of my favorite stories with simple writing prompts that have encouraged my imagination to come up with things I probably wouldn't have come up with otherwise. Check back each week for new writing prompts, or sign up for Readinary to receive my weekly emails and get the prompts in your inbox along with my latest posts. I've also set up a simple submission page you can use to suggest writing prompts.
I faced this recently with a problem I faced around titles for novels in a series. Don’t worry if you haven’t coded anything before—this is a short example of using Python to generate a list of possible titles for my books. The techniques used can apply to any programming language—or even to doing it entirely by hand.
I’ve been known to bounce around trying out different writing software. I’ve tried a range of programs including Microsoft Word, Scrivener, StoryBox, yWriter, Omniwriter, Write or Die, Wattpad, Evernote, and many others. Years ago, using Palm OS-based PDAs, I particularly liked WordSmith. I haven’t found the perfect program yet. I currently use Scrivener and Word for many projects. Right now I’m also using Novlr for writing my first drafts.
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.