Skip to main content

Using a Spreadsheet to Write

Beat sheets, outlines, storyboard, and other tools help me organize my thoughts when writing. Too many writers stick with word processors as their sole "digital tools" when many other great applications exist — and "applications" for various applications, too.

How can you use a spreadsheet to write? And why might you try this?

A spreadsheet's columns and rows, a reflection of the ledger books they replaced, make an ideal way to track your pages, words, minutes, or other metrics. My writing spreadsheets range from simple checklists to complex sheets with calculations reflecting how much I need to cut or add to parts of story. (Scrivener's outline view is similar to this, so allow me to plug Scrivener yet again.)

My basic story sheet resembles the chart on our website page "Plot and Story" [].

Some plot points should be reached at specific pages, especially early in a story, while others should be reached within ranges of pages, as a percentage of the overall work. Using a spreadsheet helps me track these personal ideas.

For example: I like to have the "perceived problem / challenge" and the "real problem" within the first ten pages of a 90 minute screenplay or stage script. In a book, I might want those within the first "ten percent" of the work. Express each plot point in 25 words or less.

Major Beat 3 -> Perceived / Immediate Challenge -> Bomb ticking in a subway tunnel
Major Beat 4 -> Real Challenge -> Corrupt leaders creating the chaos to gain powers

Using Excel or another spreadsheet, I include columns reflecting page counts, minutes, real time, literary time, and more. These metrics help me pace my stories.

Do you have a checklist? If not, create one. Every creative writer using narratives should have a beat sheet, because it forces you to recognize when things are missing from a story.


Popular posts from this blog

Slowly Rebooting in 286 Mode

The lumbar radiculopathy, which sounds too much like "ridiculously" for me, hasn't faded completely. My left leg still cramps, tingles, and hurts with sharp pains. My mind remains cloudy, too, even as I stop taking painkillers for the back pain and a recent surgery.

Efforts to reboot and get back on track intellectually, physically, and emotionally are off to a slow, grinding start. It reminds me of an old 80286 PC, the infamously confused Intel CPU that wasn't sure what it was meant to be. And this was before the "SX" fiascos, which wedded 32-bit CPU cores with 16-bit connections. The 80286 was supposed to be able to multitask, but design flaws resulted in a first-generation that was useless to operating system vendors.

My back, my knees, my ankles are each making noises like those old computers.

If I haven't already lost you as a reader, the basic problem is that my mind cannot focus on one task for long without exhaustion and multitasking seems…

MarsEdit and Blogging

MarsEdit (Photo credit: Wikipedia) Mailing posts to blogs, a practice I adopted in 2005, allows a blogger like me to store copies of draft posts within email. If Blogger, WordPress, or the blogging platform of the moment crashes or for some other reason eats my posts, at least I have the original drafts of most entries. I find having such a nicely organized archive convenient — much easier than remembering to archive posts from Blogger or WordPress to my computer.

With this post, I am testing MarsEdit from Red Sweater Software based on recent reviews, including an overview on 9to5Mac.

Composing posts an email offers a fast way to prepare draft blogs, but the email does not always work well if you want to include basic formatting, images, and links to online resources. Submitting to Blogger via Apple Mail often produced complex HTML with unnecessary font and paragraph formatting styles. Problems with rich text led me to convert blog entries to plaintext in Apple Mail and then format th…

Let’s Make a Movie: Digital Filmmaking on a Budget

Film camera collection. (Photo credit: Wikipedia) Visalia Direct: Virtual Valley
June 5, 2015 Deadline
July 2015 Issue

Every weekend a small group of filmmakers I know make at least one three-minute movie and share the short film on their YouTube channel, 3X7 Films.

Inspired by the 48-Hour Film Project (, my colleagues started to joke about entering a 48-hour contest each month. Someone suggested that it might be possible to make a three-minute movie every week. Soon, 3X7 Films was launched as a Facebook group and members started to assemble teams to make movies.

The 48-Hour Film Project, also known as 48HFP, launched in 2001 by Mark Ruppert. He convinced some colleagues in Washington, D.C., that they could make a movie in 48 hours. The idea became a friendly competition. Fifteen years later, 48HFP is an international phenomenon, with competitions in cities around the world. Regional winners compete in national and international festivals.

On a Friday night, teams gathe…