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" [http://www.tameri.com/write/plotnstory.html].

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
Minor…
Major Beat 4 -> Real Challenge -> Corrupt leaders creating the chaos to gain powers
Minor…

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.

Comments

Popular posts from this blog

Comic Sans Is (Generally) Lousy: Letters and Reading Challenges

Specimen of the typeface Comic Sans. (Photo credit: Wikipedia) Personally, I support everyone being able to type and read in whatever typefaces individuals prefer. If you like Comic Sans, then change the font while you type or read online content. If you like Helvetica, use that.

The digital world is not print. You can change typefaces. You can change their sizes. You can change colors. There is no reason to argue over what you use to type or to read as long as I can use typefaces that I like.

Now, as a design researcher? I'll tell you that type matters a lot to both the biological act of reading and the psychological act of constructing meaning. Statistically, there are "better" and "worse" type for conveying messages. There are also typefaces that are more legible and more readable. Sometimes, legibility does not help readability, either, as a type with overly distinct letters (legibility) can hinder word shapes and decoding (readability).

One of the co…

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 (48hourfilm.com), 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…

Edutainment: Move Beyond Entertaining, to Learning

A drawing made in Tux Paint using various brushes and the Paint tool. (Photo credit: Wikipedia) Visalia Direct: Virtual Valley
November 2, 2015 Deadline
December 2015 Issue

Randomly clicking on letters, the young boy I was watching play an educational game “won” each level. He paid no attention to the letters themselves. His focus was on the dancing aliens at the end of each alphabet invasion.

Situations like this occur in classrooms and homes every day. Technology appeals to parents, politicians and some educators as a path towards more effective teaching. We often bring technology into our schools and homes, imagining the latest gadgets and software will magically transfer skills and information to our children.

This school year, I left teaching business communications to return to my doctoral specialty in education, technology and language development. As a board member of an autism-related charity, I speak to groups on how technology both helps and hinders special education. Busin…