NaNo Wrap-Up: Beat Sheets 101

by Jami Gold on December 3, 2013

in Writing Stuff

Green chalkboard with text: Beat Sheets 101

Now is the time of year when thousands of writers look at their NaNoWriMo story and think: Yay! Okay, now what? (Or if you’re like me, you’re still drafting the denouement for the final scene, but I’m close to finishing. *smile*)

Whether we wrote by the seat of our pants or had an outline, there are many ways we can make our story better. The advice usually tells us to wait a few weeks or a month to gain distance on our story before digging into revisions, but we can take notes while the details are fresh in our minds.

Do we know of any plot holes? Where do we suspect the characterization is lacking or “off”? Where do we fear the pacing is slow?

Also, the early stage of revision is the perfect time to pull out the beat sheet of our choice and see how our story stacks up. Do we have a random jumbling of unrelated events? Or do we have a story?

What Is a Beat Sheet?

First we need to understand the terminology. Story beats are the plot events (including choices, dilemmas, and questions) that occur on a regular basis and drive the story forward. My post about the Basic Beat Sheet gives a rundown of what the most important story beats are.

Beat sheets provide a visual way of “tracking” our story and its structure. At this early stage of revision, we can ensure we have all the beats necessary for good storytelling (the 4 major beats and maybe the 4 minor beats).

During our big revision phase later, we can verify the beats create increasing tension and stakes. We can see where beats should fall page-count or word-count wise and compare that to our story’s actual pacing. Is our story too slow in places? Do we have unnecessary scenes? Or have we underdeveloped an idea or reaction?

If I Don’t Know MS Excel, Can I Still Use Beat Sheets?

Beat sheets are often in a spreadsheet program like MS Excel, but that doesn’t mean we have to know formulas or do math. It’s actually the fact that the beat sheets are in Excel that makes all that math automatic.

In other words, I have no plans to ever offer my beat sheets in MS Word. All beat sheets available on my website include automatic formulas for word count and page count, and that wouldn’t be possible in MS Word. (I strongly believe in no math. *smile*)

Beat Sheet 101: How to Create a Beat Sheet for Our Story

If you’re already a beat sheet expert, this post might still have a few tricks you haven’t tried before. And if you’re not sure how to use beat sheets at all, read on…

Step 1. Download the Beat Sheet of Your Choice

I have several beat sheets available and will be adding more by request. If you’re not sure which beat sheet would be most helpful for your situation, check the descriptions and associated posts for each one or feel free to ask. The following example images are taken from the MS Excel file of my Basic Beat Sheet.

Full screen of the Basic Beat Sheet file

(Note: Click on each image to see the full-size version. And if you’re viewing this post in my newsletter, click through to this post on my website to view the instructional images.)

Step 2. (Optional) Make a Reference Copy of the Beat Sheet

MS Excel allows us to have multiple spreadsheets within one file that we can then switch between with a click on the appropriate tab at the bottom of the window. One of my workshop students, Jennifer Rose, suggested that we make a reference copy of the beat sheet, so we could easily switch between the beat descriptions and the specific details for our story. I liked her idea so much I’m sharing it here.

To make a copy, find the tab at the bottom of the MS Excel window with the name of the spreadsheet. (Note: These instructions are for MS Excel ’07, but other versions should work similarly.)

Close-up of Sheet Tab

Right-click on that tab to bring up the right-click menu and select “Move or Copy.”

Right-click menu for Copy

In the “Move or Copy” dialog box, check mark the “Create a copy” box and then click “OK.”

Move or Copy dialog box

Now two tabs show up at the bottom of the window. These can be dragged into any order.

New sheet tab

Double click on the new tab and the tab name is now highlighted. Type the new name (like your story name) to overwrite the old name, and then you’ll have two tabs. Ta-da! One you can leave “as is” as a reference, and the other you can update with the specifics of your story.

Highlighted sheet tab name

Step 3. (Optional) Enter Our Story’s General Information

If desired, update the “Story Title here” and the “Logline goes here” fields. Once we’ve written several stories, we might appreciate knowing to which story each beat sheet file belongs.

How to Enter Information in MS Excel:

Before we can type, we must click on the field we want to update, for example, the “Story Title here” field. Once we click on a field, the same information currently in that field will display in the formula bar near the top of the window (marked with a red arrow in the image below). Sometimes, it might be easier to edit information by clicking on the field and then changing the text in the formula bar. Click on another field to “activate” the information.

Step 4. Enter Our Story’s Word Count

To make the auto-math work, we must update the word count field. In this example, we’d click on the field with “110,000” to the right of the Word Count description. Update the number with an estimated or exact word count. Once we “enter” or click on another field, all beats will automatically adjust to show the expected page/word count marks for each beat.

Close-up of top of beat sheet

Notes: In most cases we do not want to touch the page count field. This number will automatically change when we update the word count. If we click on this field, we notice that “400” doesn’t display in the formula bar.

The formula for page count

Instead, the formula bar displays the formula (the auto-math) for how the spreadsheet figures out how many pages our story would be (approximately). The only time we’d need to change this field is if we’re using Courier New for our manuscript, as the calculations assume we’re using Times New Roman. In that case, we’d change the formula in the formula bar to fix the math (just change the 275 to 250, leaving all other characters and symbols the same).

Formula for Courier manuscripts

Again, we’d touch this formula only if we were using the Courier New font and needed more accurate page counts.

Step 5. (Optional) Enter Descriptions for Each Beat

If desired, we can fill in the description for what plot event fulfills each of the beats to help us remember the turning points of our story. (We wouldn’t need to specify the Act One/Two/Three descriptions in most cases.) This is where our reference copy on another tab could be helpful, as we could remind ourselves of the purpose of each beat if we change the story structure while revising.

Close-up of the Descriptions field

Note: Do not touch the Page or Word Count columns to the right of each beat. These columns contain formulas for the auto-math based on the word count entered at Step 4 above.

The page numbers are not expected to be exact. Depending on how much “white space” we use (short vs. long paragraphs), the actual page numbers might be higher or lower. The formula estimates 275 words per page when using Times New Roman.

Beat Sheet 101: How to Use a Beat Sheet

Okay, we have a beat sheet with our beat descriptions and a bunch of numbers in columns that automatically change to match our word count. What next?

First, we want to check our story structure:

  • Do we have a definitive plot event or turning point for each beat?
  • Does the story’s arc show change?
  • Are there any missing or misplaced beats?
  • Do the beats follow a cause-and-effect chain?
  • Are there any scenes not acting or reacting to a beat?
  • Do the stakes increase throughout story?

(Note: Bullet points are roughly in order of early-stage revising to later-stage revising.)

Second, as we move into later-stage revising, we can use a beat sheet to check our pacing. In my Pantser’s Guide to Beat Sheets, I shared how we can use beat sheets both before and after the drafting phase. Pre/during drafting, we might use the Word Count column to track what we should be writing at each point of our story.

Post-drafting, we’re more likely to use the Page column to the right of the beat descriptions and check the page count for each beat. Do the beats each land close to their goal?

  • Beats don’t need to fall on exact page numbers but more than 2-5% off (maybe more in some stories, or for the minor beats) might indicate a pacing problem.
  • Too many pages between beats might indicate an unnecessary scene.

What Do the Double Columns of Numbers on Some Rows Mean?

Many of the rows show a range. In the rows for the three Acts, the range gives the beginning and ending marks of the Acts. In the rows for the Inciting Incident, End of the Beginning, Crisis, and Resolution, the specific plot event of the beat might occur anywhere within that range. (Other beat sheets use different names for the beats. The point remains the same.)

Close-up of Page and Word Count ranges

The Climax is a special case in that the range encompasses everything leading up to up to the Climax as well as the actual “showdown.” For example, the Climax would include: deciding to storm the castle, gathering weapons and allies, traveling to the castle, breaching the castle’s defenses, battling the minor bad guys, rescuing the good guys, and fighting the big bad villain.

It’s difficult to separate those steps into separate beats, so they’re frequently lumped together in one breathless-race-to-the-end-of-the-story rush. All of the Climax-related scenes typically take up the majority of Act Three.

Beat Sheets 101: Beat Sheets Are a Tool, Not a Rule

Once we’re comfortable with the information on beat sheets, we can tell at a glance whether our story is on track or not. However, we should not sacrifice story flow to stick to strict word or page counts.

Those numbers are guidelines. Good story flow and storytelling comes first. Just as our characters shouldn’t be puppets to the plot, we shouldn’t be puppets to the beat sheet. *smile*

(If you’re interested in taking your knowledge of beat sheets further, check out my workshops. Leave a comment on that page to receive more information as it becomes available. I hope to offer “On Demand” classes soon.)

Did I miss anything in my explanation or do you still have questions about how to read and use beat sheets? Ask away! If you’re already a beat sheet expert, do you have additional insights to share? If you participated in NaNo, how did your story turn out? Did you end up with a story or a random jumble? Do you already know where some problems lie?

Pin It
51 Comments below - Time to Add your own.

Sharon Hughson December 3, 2013 at 10:05 am

Thanks to your wonderful beat sheets which I got from your class at WANACon in October, my novel turned out pretty well-paced.
What is interesting to me is that the event I chose as the end of beginning was actually the inciting incident, but I managed to place another event in he right area that works as the first plot point.
Thanks for sharing your genius and beat sheets with us.

Reply

Jami Gold December 3, 2013 at 4:57 pm

Hi Sharon,

Yay! I’m so happy to hear that–and congratulations on your NaNo novel. 🙂

Yes, as a pantser, I often have events moving around as I’m drafting. LOL! Thanks for the comment!

Reply

Davonne Burns December 3, 2013 at 12:01 pm

I’ve made sure to keep a copy of your beat sheets next to me while I write. It’s always a good reminder when I get stuck or am not sure where I need to go. Thank you!

Reply

Jami Gold December 3, 2013 at 5:02 pm

Hi Davonne,

Believe me, I understand. 🙂 I’m happy to help. Thanks for the comment!

Reply

Katy White December 3, 2013 at 12:34 pm

Your beat sheet made NaNo possible for me! I plotted in advance, despite being a devoted pantser, and I finished my 76K novel EARLY! I was thrilled to see how much that outline made my creative juices flow. I’m a believer in beat sheets now, for sure.

Reply

Jami Gold December 3, 2013 at 5:03 pm

Hi Katy,

Awesome! Congratulations on your NaNo win and on finishing your novel! Thanks for sharing that great news and for the comment. 🙂

Reply

MA Hudson December 4, 2013 at 4:03 am

Hi Jami
I haven’t used your beat sheets yet but I’ve got to say that this looks like an amazing resource. Thank you so much for sharing it with us. I can’t wait to apply it to my WIP.
Cheers,
MA

Reply

Jami Gold December 4, 2013 at 8:03 am

Hi MA,

Let me know if you have any questions. I’m happy to help. 🙂 Thanks for the comment!

Reply

Lara McGill December 4, 2013 at 6:26 am

Everyone listen to Jami! This is the first year I’ve used beat sheets (from Jami’s download), and Nano was the first thing I used them on. Between Jami and Larry Brooks and his Story Engineering (great book) I was able to get 74K+ by the 10th of the month.

Jami and Larry are brilliant!!!

Reply

Jami Gold December 4, 2013 at 8:06 am

Hi Lara,

LOL! And awesome! Congratulations on your word count! *fist bump* Thanks for sharing and for the comment. 😀

Reply

Tracy Campbell December 4, 2013 at 12:34 pm

Although I didn’t participate this year, your beat sheets will help me with my WP’s. And I’ll be filing this post under “exceptional writing tips”.
Thanks, Jami. 🙂

Reply

Jami Gold December 4, 2013 at 12:36 pm

Hi Tracy,

I’m happy to help! Let me know if you have any questions. 🙂 Thanks for the comment!

Reply

Manny Essel April 11, 2014 at 3:10 pm

Great blog for writers. Thanks for sharing.

Reply

Jami Gold April 11, 2014 at 3:29 pm

Hi Manny,

I’m happy to help. 🙂 Thanks for stopping by!

Reply

George April 13, 2015 at 10:07 am

Hi Jami and thanks for the great website. However, I have a question – try as I might, I cannot get my head around the double columns of numbers in your beat sheets. (I feel like a dunce here as no-one else seems to have a problem with this.) Can you point me in the direction of help for this? I have read your information on this, googled in vain and am still no wiser!

Thank you!

Reply

Jami Gold April 13, 2015 at 11:08 am

Hi George,

As I mentioned in the post (under the “What Do the Double Columns of Numbers on Some Rows Mean?” heading), those columns simply give us a beginning and ending page/word count range:

In the rows for the three Acts, the range gives the beginning and ending marks of the Acts. In the rows for the Inciting Incident, End of the Beginning, Crisis, and Resolution, the specific plot event of the beat might occur anywhere within that range.

For example, using the page numbers of the image in the post, the Crisis (also known as the Black Moment) could occur on page 273 or it could occur on page 300–or anywhere in between. The logic behind those numbers (as opposed to random numbers 😉 ) is that our Crisis should happen around the 75% mark.

However, in some stories, the power of the Black Moment is going to come not during the big heartbreaking moment, but during the extended fallout from the Black Moment. So starting the range at page 273 gives us flexibility for the specifics of our story.

Sometimes we want to get to the event right away because those are the interesting fireworks, and sometimes the lead up to the event is filled with tension and dread, and we want to drag out the event for as long as possible. (And remember that these are all just guidelines anyway, so we can be “off” by 5% or so and not mess up the pacing of our story too much, so don’t overthink these ranges. 🙂 )

The exception comes with the Climax:

The Climax is a special case in that the range encompasses everything leading up to up to the Climax as well as the actual “showdown.” For example, the Climax would include: deciding to storm the castle, gathering weapons and allies, traveling to the castle, breaching the castle’s defenses, battling the minor bad guys, rescuing the good guys, and fighting the big bad villain.

It’s difficult to separate those steps into separate beats, so they’re frequently lumped together in one breathless-race-to-the-end-of-the-story rush. All of the Climax-related scenes typically take up the majority of Act Three.

So again, we don’t need to overthink the numbers too much, but for the Climax, the page/word count range means that our rush-to-the-finish scenes should take up most of those pages. If that’s still not clear, let me know. 🙂 Thanks for the comment!

Reply

George April 14, 2015 at 4:47 am

Thanks for the speedy response, Jami, and I will try to get this into my head. I am definitely a ‘word’ person and very definitely not a ‘numbers’ person!

Reply

Jami Gold April 14, 2015 at 8:56 am

Hi George,

LOL! I always say that I designed these sheets to use “auto-math” because I’m not a numbers person, so I understand. Good luck! 🙂

Reply

Kari June 12, 2015 at 6:01 am

Hello, Jami.
Thank you for sharing your experiences and what works for you. I’m not new to writing, but I’m new to trying to make a living at it. 🙂 I’m just putting my dreams into action, and a few of your beat sheets are going to help me so much.

I do have a question on the Beat Sheet. Under Act Two, there is only one column under “Page”. In the example in the post above, does this mean that the Pinch Point #1 should happen around page 150, the Midpoint by about page 200, etc. Then the Crisis should happen anywhere from 273 to 300 (like you mention in another comment)?

Thanks again,
Kari

Reply

Jami Gold June 12, 2015 at 10:08 am

Hi Kari,

Yay! In my post about business plans I share the quote: “A goal is a dream with a plan and a deadline,” so good for you at putting your dreams into action!

To answer your question, correct. In practice, because all of these page numbers are just guidelines, especially for a novel-length story, this usually means that the scene with the pinch point or midpoint would be around that page.

The reason why the other beats have ranges is multi-fold:

  • The Midpoint obviously hits at the “middle” of the story, and there’s not really a range for that. 😉
  • Many of the other beats have conflicting advice for where they should fall, so the ranges cover all the bases. (No one argues with where the middle is, and the Pinch Points are simply filling in the blanks between the major beats.)
  • The Pinch Points are Minor beats, so we’re already “allowed” greater leeway in how far off we can be, and giving a specific range isn’t necessary. (Technically, in a novel, we’re going to have lots of events that could be Pinch Points, so sometimes in revision, I’ll figure out which one is closest to the page number and amp up the conflict or emotions a bit–or whatever I want to accomplish with that Pinch Point. The point is just to ensure that we’re not suffering from a sagging middle, so I consider the PPs reminders. 🙂 )
  • Some of the other beats are harder to identify what makes up the beat, so a range gives us peace of mind. Like with a Crisis/Black Moment, is the beat the devastating event or when the fallout happens? It could be either depending on the circumstances, and a range helps us internalize that flexibility is okay. 😉

Does that help? Thanks for the great question, and good luck with your writing!

Reply

Etienne October 6, 2015 at 9:01 pm

how do you build a scene list from the beat spreadsheet?

Reply

Jami Gold October 6, 2015 at 10:20 pm

Hi Etienne,

Great question! Most beat sheets aren’t detailed enough to go directly from the beat sheet to a scene list. The reason is because the beat sheet isn’t going to list every scene, just the ones with turning points.

Some beat sheets, such as the Save the Cat or the Master Beat Sheet are more detailed than others. But it still wouldn’t be enough for a novel’s scene list, as I’ve heard a novel usually consists of about 60 scenes. (I haven’t counted mine, but that sounds about right.)

To get from the 8 beats of the Basic Beat Sheet to 60 scenes, what I’d do is list those 8 turning point scenes on note cards. Then I’d think about all the scenes needed to get to the first turning point scene and write each of those on a card, think about all the scenes needed to get from the first turning point to the second turning point, etc. Once you have those cards in the right order, that’s your scene list.

For example, in Star Wars, to get from the scene of Luke discovering that R2D2 disappeared (Inciting Incident?) to the First Plot Point of him deciding to join Obi Wan, we need scenes of searching for R2D2, meeting Obi Wan, the hologram message giving a goal, and the death of his aunt and uncle. The scene list is basically the cause-and-effect chain of how A leads to B.

I hope that helps, but this is such a great question, that I think I want to expand this into a full post. Look for it on October 8th. 🙂 Thanks for the comment!

Reply

James October 12, 2015 at 5:53 pm

Can you explain the word and page count breakdown? In one of the forms there are four lines that have 1 in each of the rows, with an increasing page/word count to the right of it.
Also, are the bolded “part #’s” meant to be filled in with plot points? I see they have the total number of words before the next part.

Reply

Jami Gold October 12, 2015 at 8:48 pm

Hi James,

As I explain in the “What Do the Double Columns of Numbers on Some Rows Mean?” section above:

“Many of the rows show a range. In the rows for the three Acts, the range gives the beginning and ending marks of the Acts. In the rows for the Inciting Incident, End of the Beginning, Crisis, and Resolution, the specific plot event of the beat might occur anywhere within that range. … The Climax is a special case in that the range encompasses everything leading up to up to the Climax as well as the actual “showdown.””

For example, Act One goes from pages 1 to 100 (in this specific example–the actual numbers would change with your project’s word count) and would hold our words from 1 to 27500 (approximately). Under each act are the beats that take place during that act, and the beat could take place anytime within that range (except for the Climax, which would potentially take up the whole range). So the Inciting Incident could take place anywhere between page 1 to 79 because it happens during Act One.

If that’s still unclear, see if you can be more specific with what part is confusing, and I can try to help. 🙂

It’s up to you whether you fill in anything in the act descriptions, but I gave the overview of what the act should accomplish as a reminder. Usually, there would be too many plot events to be specific, but we could do a high-level summary if we wanted. It’s not necessary though, so use the beat sheet however it best makes sense for you. 🙂 Thanks for the comment!

Reply

Cynthia January 27, 2016 at 6:27 pm

I’m really glad I stumbled over your site. This is so helpful! I’ve been hearing “beats” for a while now and didn’t have a clue. When I saw the form and read your post it was like a light going off. Thanks so much for the post and the hard work on the spreadsheets. That’s takes a lot of time.

I still feel I have a lot to learn about this but you’ve made it much easier.

Reply

Jami Gold January 27, 2016 at 7:12 pm

Hi Cynthia,

You’re welcome! I have quite a few posts here about beat sheets and story structure, so I hope you have fun exploring. 🙂 (You can find other related posts by clicking on the “beat sheet” tag below or use the search field in my sidebar to search on any topic.) Thanks for stopping by!

Reply

Susan Misey June 27, 2016 at 7:26 am

Hi Jami,
What a treasure you’ve published here! Thank you so much. I’m usually such a plotter, but I’d like to become more of a pantser. Your beat sheets will enable me to find my happy medium.
All the best,
Susan

Reply

What do you think?

51 Comments below - Time to Add your own.

Previous post:

Next post: