ABCDEFGHIJK
1
2
Welcome to the Story Grid Spreadsheet Template!

Below, you'll find instructions for using this template to fill out a Story Grid Spreadsheet for your project.
If you have any questions or feedback, please contact us at support@storygrid.com.
3
4
Instructions
5
6
1. Make a copy of the template.
7
Click here to make a copy.
8
9
2. Allow access to link this sheet back to the template. This will populate the dropdowns and data checks.
10
Make a copy first. (See step 1)
11
12
3. Enter the Global Story Characteristics in the top section.
13
If you are analyzing a prose work, select Words in cell B19. If you are analyzing a work best measured in timestamps (like a film) select Time in cell B19.
14
15
4. Make sure you've selected the Global Genre in cell B7 on the Grid tab.
16
This will populate the Conventions and Obligatory Moments choices with the ones for your global genre.
17
If you have a global external genre, your secondary genre (B9) should be the internal genre, and vice versa.
18
19
5. Let's go over the columns:
20
21
Scene
22
Scene number.
23
24
Word Count
25
Word count of scene.
26
27
Chapter
28
Chapter Title
29
Chapter information that will help you find the scene. If you are working on an analysis for a work that does not need these fields, click the first minus sign at the top of the sheet to collapse them.
30
31
Time
32
Starting Timestamp
33
Ending Timestamp
34
These columns replace Word Count, Chapter, and Chapter Title if you have selected to measure units in Time.
35
The sheet automatically calculates Time and Starting Timestamp, so all you have to do is enter the Ending Timestamp for each scene. You can also edit the Starting Timestamp of Scene 1 (in cell C22).
36
37
Story Event
38
To determine a scene’s story event, answer these four questions:
39
1. What are the characters literally doing—that is, what are their micro on-the-surface actions?
40
2. What is the essential tactic of the characters—that is, what above-the-surface macro behaviors are they employing that are linked to a universal human value?
41
3. What beyond-the-surface universal human values have changed for one or more characters in the scene? Which one of those value changes is most important and should be included in the Story Grid Spreadsheet?
42
4. The Scene Event Synthesis: What Story Event sums up the scene’s on-the-surface, above-the-surface, and beyond-the-surface change? We will enter that event in the Story Grid Spreadsheet.
43
44
Story Event Summary
45
Keep this brief (60 characters max, but ideally 30-40). It will be the label on the graph for the individual scene point.
46
47
Trope Scene Type
48
Take the events of the scene and abstract them to a level that is descriptive but does not rely on the specific context of the Global Story. Express this as a trope. For example, "Stranger Knocks at the Door," "Savior Arrives," "Friends Have Coffee," etc.
49
Note that there are 6 collapsed scene type columns. These are not required.
67
68
Value - Beginning of Scene
69
Value - End of Scene
70
Enter the beginning and ending values separately. For example, if Scene 1 shifts from Life to Death, enter "Life" in N21 and "Death" in O21.
71
72
Polarity - Beginning of Scene
73
Polarity - End of Scene
74
Use the dropdowns to choose the polarity of the beginning and ending values.
75
76
Turning Point Category
77
Active or Revelatory.
78
79
Turning Point Summary
80
Describe the turning point of the scene.
81
82
Point of View
83
Describe the point of view in the scene.
84
85
Period/Time
86
The point in time when the scene takes place.
87
88
Duration
89
The length of time over which the scene's events take place.
90
91
Location
92
Identify the location in which the scene takes place.
93
94
On-Stage Characters
95
List the names of characters who appear in the scene.
96
97
On-Stage Characters (Number)
98
Count the On-Stage Characters.
99
100
Off-Stage Characters
101
List the names of characters who are mentioned, but do not appear in the scene.
102
103
Off-Stage Characters (Number)
104
Count the Off-Stage Characters.
105
106
Quadrant
107
Use the dropdown to select the quadrant of the Global Story that this scene is in.
108
109
Convention
110
Obligatory Moment
111
The Conventions and Obligatory Moments dropdowns contain patterns.
112
You can replace any [bracketed text] with story-specific information.
113
For example, you can change the Love story Convention "[Character] is a Helper" to "Jane Bennet is a Helper"
114
You can choose multiple values per cell to allow you to identify scenes that fulfill multiple Conventions or Obligatory Moments. When you select a new value, it will append to the existing cell contents to create a list separated by semicolons. You can still edit bracketed text.
115
The only limitation to this is that if you select a value that's already in the list, it will act like you are trying to delete the others and return only the new value. So, if you want to use the same pattern multiple times, follow these steps.
116
1. Select the pattern, e.g. "[Character] is a helper."
117
2. Edit it: "Jane Bennet is a helper."