The Wonderful Wizard of Oz Story Grid Spreadsheet

	A	B	C	D	E	F	G	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	AA	AB	AC	AD	AE	AF	AG	AH	AI	AJ
1
2	Global Story Information
3
4	Title	The Wonderful Wizard of Oz
5	Author	L. Frank Baum
6	Analysis By	Shawn Coyne
7	Global Genre	Action
8	Global Subgenre	Adventure - Person Against Nature - Environment
9	Secondary Genre	Worldview
10	Secondary Subgenre	Maturation
11	Time Genre	Long
12	Reality Genre	Fantasy
13	Style Genre	Cinematic
14	Structure Genre	Archplot
15	Controlling Idea	Survival requires the protagonist to insightfully outwit or overpower mortal threats from an unexpected environmental change, unexpected lethal threats from another being or group of beings, or both.
16	Global Point of View	Third Person Omniscient
17	Global Want	to get home to Kansas
18	Global Need	to learn to use her own agency instead of ceding it to others
19
20	Scene	Word Count	Chapter	Chapter Title	Story Event	Story Event Summary	Trope Scene Type	Value - Beginning of Scene	Value - End of Scene	Polarity - Beginning of Scene	Polarity - End of Scene	Turning Point Category	Turning Point Summary	Point of View	Period/Time	Duration	Location	On-Stage Characters	On-Stage Characters (Number)	Off-Stage Characters	Off-Stage Characters (Number)	Quadrant	Convention	Obligatory Moment	Global Five Commandment	Quadrant Five Commandment	Global Genre Value Level	Secondary Genre Value Level	Subplot Value Level	Subplot Value Level
21	1	1150	1	The Cyclone	A Cyclone lifts a one-room Kansas farmhouse off of the ground with a little orphan girl and her dog still inside.	Cyclone hits Dorothy's home		Life	Unconsciousness	+	-	Active	Toto leaps from Dorothy's arms	3rd Person Omniscient	One day in early May in Kansas, circa 1900, the spring cyclone season	Hour after hour passed	A one room house in themidst of the great Kansas prairies	Dorothy, Uncle Henry, Aunt Em, Toto	4		0	Beginning Hook	Dorothy is a Luminary Agent	Inciting Attack	Inciting Incident (Coincidental)	Inciting Incident (Coincidental)	-8	-2
22	2	2007	2	The Council with the Munchkins	Dorothy drops into the Land of the Munchkins and asks and receives advice about how to begin navigating back home.	Munchkins guide Dorothy		Lost	Directed	-	+	Revelatory	The Good Witch of the North asks the universe about Dorothy and she gets the message that Dorothy should go to the Emerald City	3rd Person Omniscient	Same Day in the Afternoon	Twenty Minutes	The Land of the Munchkins	Dorothy, Toto, A group of the queerest people she had ever seen, three men and one woman, the Witch of the North	5	Uncle Henry, Wicked Witch of the East, Wicked Witch of the West, Aunt Em, Oz, The Quadlings, The Winkies	7	Beginning Hook	Disturbed, Unbalanced Physical and Social Setting; Speech in Praise of the Shadow Agent; Clock	Fix It and Forget It Mission; Dorothy Senses Disorder; Dorothy Runs Away; Dorothy Reluctantly Engages; Dorothy Agrees to Fight		Turning Point Progressive Complication (Active); Crisis (Best Bad Choice); Climax; Resolution	12	-3
23	3	1960	3	How Dorothy Saved the Scarecrow	After setting off for Emerald city, Dorothy and Toto find allies in a Munchkinn family and the scarecrow.	Dorothy meets scarecrow		Alone	Together	-	+	Active	Dorothy frees the scarecrow from his pole	3rd Person Omniscient	Same Day evening and the morning of the next day	All day long through dinner and breakfast the next morning	The Land of the Munchkins to the yellow brick road	Dorothy, Toto, Many men and women dancing, five little fiddlers, Boq the richest munchkin, Munchkin baby, scarecrow	8	The witch of the east, the great Oz	2	Middle Build 1		A Whole New World		Inciting Incident (Coincidental)	9	-4
24	4	1434	4	The Road Through the Forest	Dorothy and the scarecrow spend the day together, get to know each other, and establish a power hierarchy between them.	Dorothy takes leadership role		Confrontation	Put in one's place	+	-	Active	Scarecrow confronts Dorothy about why she would want to return to Kansas	3rd Person Omniscient	Before and after noon until evening	About ten hours	The Yellow Brick Road	Dorothy, Scarecrow, Toto	3	The farmer, Another Munchkin, Old Crow	3	Middle Build 1					1	-7
25	5	2061	5	The Rescue of the Tin Woodman	Dorothy and the scarecrow rescue a rusten tin woodman who joins their mission and cuts a pathway forward	The Tin Woodman joins the mission		Stopped	Restarted	-	+	Revelatory	The pathway is too dense to walk through.	3rd Person Omniscient	the next day	morning, four or five hours	The Yellow Brick Road	Dorothy, Toto, Scarecrow, Tin Woodman	4	the great Oz, A wooman, the tin man's mother, a Munchkin girl, An old Munchkin woman, The wicked witch of the East, a Tinsman, Aunt Em	8	Middle Build 1					10	-5
26	6	1502	6	The Cowardly Lion	Dorothy defends Toto from an attack by a lion.	Dorothy beats back the lion		Unsafe	Safe	-	+	Active	Dorothy smacks the lion on the nose	3rd Person Omniscient	All this Time	throughout the day	The Yellow Brick Road	Dorothy, her companions, Tin woodman, Toto, Scarecrow, A great lion	6	Oz, a man	2	Middle Build 1	Dorothy's Group is the Growth Hierarchy; The Land of Oz is the Power/Dominance Hierarchy	The Protagonist Becomes the Target of the Antagonist		Turning Point Progressive Complication (Active)	-2	-6
27	7	1805	7	The Journey to the Great Oz	The scarecrow displays keen insight, and the lion displays considerable courage as the group navigates closer to the Emerald City	Scarecrow and lion defeat obstacles		Mortally Threatened	Skillfully Alive	--	++	Revelatory	Scarecrow is a nimble thinker and Lion is a brave fighter	3rd Person Omniscient	That evening the next morning and the next day	Twenty four hours	The Yellow Brick Road	The tin woodman, Dorothy, the Lion, Toto, Scarecrow, the Kalidahs	6	The Kalidahs, Oz	2	Middle Build 1					-1	-1
28	8	1931	8	The Deadly Poppy Field	The band of companions face a raging river and a poppy field that anaesthetizes Dorothy and the Lion as they travel down the yellow brick road	River and poppy field obstacles		Conscious	Unconsciousness	+	--	Revelatory	The lion didn't make it out of the field	3rd Person Omniscient	The next morning	Five hours	The Yellow Brick Road/A River	Our little Party of travelers, Dorothy, Tin Woodman, Toto, The Lion, The Scarecrow, the Stork	7	The wicked witch of the west, the stork's babies,, Oz	3	Middle Build 1					-6	0
29	9	1383	9	The Queen of the Field Mice	The Tin Woodman and Scarecrow figure out how to save the Lion with the help of field mice	Mice save Lion		Unconscious	Conscious	--	+	Active	The tin woodman saves the life of the Queen of the Field Mice and she in turn saves the Lion	3rd Person Omniscient	Later that afternoon	Three hours	Just outside the poppy field	The scarecrow, the girl, the tin woodman, a wildcat, a little gray field mouse, The queen of the field mice, several mice, Toto, The Cowardly lion, Dorothy	10		0	Middle Build 1					11	1
30	10	1956	10	The Guardian Of the Gate	The group makes it to the Emerald City and meets the Guardian of the Gates who informs them that they must wear spectacles when they are in the city	Guardian grants them entry		Uninformed	Informed	-	+	Revelatory	All citizens must wear locked spectacles when in the Emerald City, All must have the same worldview attunement	3rd Person Omniscient	Late afternoon, evening, and the morning of the next day into the afternoon	Eighteen hours	The Yellow brick road, the Land of Oz	The cowardly lion, Dorothy, The scarecrow, the tin woodman, Toto, a woman, two children, a man, a little man (the guardian of the gates)	9	The field mice, the great Oz, the Munchkins	3	Middle Build 1					2	2
31	11	3608	11	The Wonderful City of Oz	The four friends see Oz individually and he tells them he won't grant any of their wishes until they kill the Wicked Witch of the West	Oz's Quid Pro Quo		Hope	Despair	+	--	Revelatory	In order to get what they want, the group will have to unleash their shadows and kill another being	3rd Person Omniscient	Afternoon into the evening and the next morning plus four days	Five days	Oz's palace	Dorothy, her friends, Men women children, the children, their mothers, the lion, the guardian of the gates, a soldier, a young girl, Toto, Scarecrow, a little spider, the tin woodman, many ladies and gentlemen of the court, Oz the great and terrible, a great head, a lovely lady, a terrible beast, a ball of fire	19	Oz the great wizard, the wicked witch of the east, good witch of the north, aunt em, uncle henry, wicked witch of the west, the winkies	7	Middle Build 1	Oz is a Shadow Agent; Set Piece: Quest to Kill the Wicked Witch	Comply or Defy?		Crisis (Best Bad Choice); Crisis (Irreconcilable Goods)	-4	3
32	12	3667	12	The Search for the Wicked Witch	The group moves through the west, evading the witch's power and eventually an angry Dorothy slays her by washing her away with a bucket of water	Dorothy slays the witch		Life	Death	+	--	Active	The winged monkeys seize Dorothy and the lion and kill the tin woodman and the scarecrow	3rd Person Omniscient	Morning through the afternoon and the next morning and days afterward	a week	In the west and then in the witch's castle	the soldier, the guardian of the gates, Dorothy, Toto, The Lion, The Wicked Witch of the West, The tin woodman, the scarecrow, a pack of wolves, the leader of the wolves, a flock of wild crows, King crow, black bees, a sozen winkie slaves, the winged monkeys, the leader of the monkeys	16	wicked with of the west, the winkies, Aunt em	3	Middle Build 1	The Wicked Witch of the West is a Shadow Agent	Dorothy Complies		Climax	-9	4
33	13	1191	13	The Rescue	Dorothy brings her friends back to life with the help of the cowardly lion and the Winkies	Dorothy revives tin woodman and scarecrow		Death	Life	--	+	Active	Dorothy asks the Winkies for help	3rd Person Omniscient	That day and part of the next three days and four nights all that day and part of the next, a few more happy days	Eight days	In the west with the Winkies at the Yellow Castle	the cowardly lion, Dorothy, the Winkies, the tin woodman, the scarecrow, Toto	6	Wicked witch of the west, the scarecrow, the tin woodman, the winged monkeys, Aunt Em, Oz	6	Middle Build 1					14	6
34	14	1902	14	The Winged Monkeys	Dorothy uses the first of three cap wishes to get a ride to the Emerald City from the Winged Monkeys	Dorothy uses first cap wish		Lost	Found	-	+	Revelatory	The queen of the mice tells Dorothy about the charms in the cap	2nd Person Omniscient and 3rd Person Omniscient	All Day all night day by day	Three days	In the west on the way back to Emerald City	the four travelers, the scarecorw, the tin woodman, Dorothy, The Cowardly Lion, the mouse Queen, the winged monkey king	7	the witch, the winged Monkeys, a beautiful princess, Gayelette, Quelala, Grandfather king	6	Middle Build 1	The Winged Monkeys are Agency-Deprived				4	7
35	15	2761	15	The Discovery of Oz the Terrible	Dorothy and the group discover that Oz is a fraud, but they take heart after he tells them he'll figure out how to get them what they want regardless	Oz is a fraud		Hopeless	Hopeful	-	+	Revelatory	Oz is not a wizard	3rd Person Omniscient	All day, the next, the next, the next	Four Days, four minutes after nine o'clock the next morning	Emerald City,, Palace of Oz, the throne room	The four travelers, the Guardian of the Gates, the scarecrow, Dorothy, the Lion, the sodier with the green whiskers, the beautiful green girl, Oz the great and terrible, the tin woodman, the cowardly lion, Toto, a little old man	12	Wicked witch of the west,, Oz, the winged monkeys, Aunt Em, A strange people, the witches	6	Middle Build 1		Oz Asserts His Dominant Power	Turning Point Progressive Complication (Revelatory)	Resolution	3	8
36	16	921	16	The Magic Art of the great humbug	The scarecrow, the tin woodman, and the cowardly lion find satisfaction	Oz validates S, TW, and L		Unsatisfied	Satisfied	-	+	Revelatory	Oz has the materials to make the three characters happy	3rd Person Omniscient	The next day	Three hours	The throne room	The scarecrow, Dorothy, Oz, the tin woodman, The cowardly Lion	5	Oz	1	Middle Build 2					6	5
37	17	1151	17	How the balloon was launched	Oz puts in motion his plan to leave via hot air balloon with Dorothy, but leaves without her	Oz leaves on balloon		Hope	All is lost	+	--	Active	Dorothy searches for Toto	3rd Person Omniscient	Four days later	Ten hours	Emerald City, Palace of Oz, the Throne Room	Dorothy, the scarecrow, the tin woodman, the lion, Oz, the soldier with green whiskers, towspeople, Toto	8	Oz, Kalidahs	2	Middle Build 2		Dorothy Reaches All is Lost; No Way Out/The Point of No Return; Encounter with an Unexplained Event	Crisis (Best Bad Choice); Crisis (Irreconcilable Goods)	Inciting Incident (Causal); Turning Point Progressive Complication (Revelatory)	-7	9
38	18	1162	18	Away to the South	After contemplating a series of dead end ideas, the group resolves to seek the help of Glinda the good witch and plans their departure	The group makes a plan		Despair	Hopeful	-	+	Revelatory	Glinda the good witch may be able to help	3rd Person Omniscient	the morning after	Three hours	the throne room	Dorothy, the tin woodman, the scarecrow, the Monkey King, the soldier with the green whiskers, the lion	6	Oz, Aunt em, Uncle Henry, the Winged Monkeys, Glinda, the Quadlings, wild beasts, A race of queer men	8	Middle Build 2		Absolute Commitment; How Can Death Be Meaningful?; Preparations to Enter the Ultimate Arena	Climax	Crisis (Best Bad Choice); Climax; Resolution	7	10
39	19	1011	19	Attacked by the Fighting Trees	The group travels toward Glinda and must overcome guardian trees and then faces the hurdle of getting over a porcelain wall	The road to Glinda		Stymied	Remedied	-	+	Active	The tin woodman cuts ths limbs of the trees so they can proceed	3rd Person Omniscient	the first day and a half	Thirty six hours	On the road, a thick wood	Dorothy, the pretty green girl, soldier with the green whiskers, the guadian of the gate, the scarecrow, the tin woodman, the Lion, Toto, the trees	9	Oz	1	Ending Payoff	Set Piece: Road to Glinda	No Holds Barred		Inciting Incident (Causal)	-3	11
40	20	1500	20	The Dainty China Country	The group makes their way through a magical world filled with beings made of china and accidentally disturbs it	Breaking the China world		Innocent	Guilty	+	-	Revelatory	The people made of china are very fragile	3rd Person Omniscient	The afternoon	Five hours	In a thick wood, China land	The Tin woodman, Dorothy, the Lion, Totot, the Scarecrow, Purple China Dog, China milkmai, China Cow, Princess, Mr. Joker	10	Milkmaids, shepherdesses, princesses, shepherds, Princes, funny clowns	6	Ending Payoff		The Dainty China Country Dies (Metaphorically)		Turning Point Progressive Complication (Active)	-5	12
41	21	891	21	The Lion Becomes King of the Beasts	On their way to see Glinda the good witch, the lion seizes opportunity by killing a giant spider and ascends to king of the forest	Lion becomes king		Threatened	Safe	-	+	Active	The lion sees the spider's thin neck and severs it	3rd Person Omniscient	End of day through the next morning	Ten hours	Another forest	The lion, the scarecrow, Dorothy, Toto, the Tin woodman, Hundreds of beasts, The biggest of the Tigers, The great spider	8		0	Ending Payoff					8	13
42	22	931	22	The Country and the Quadlings	The winged monkeys fly the group over the hammer-head rock pile and into Glinda the Good witch's domain	Monkeys fly them to Glinda		Stymied	Successful	-	+	Active	Dorothy calls the winged monkeys	3rd Person Omniscient	that afternoon	Five Hours	Rock wall south country land of quadlings	The scarecrow, a rough voice, Dorothy, Hundreds of the armless, hammer-heads, the lion, the winged Monkesy, the Tin woodman, King of the Monkeys, Toto, The farmer's wife	11	The quadlings, the Winkies, the munchkins, glinda	4	Ending Payoff					5	14
43	23	1250	23	Glinda the Good Witch Grants Dorothy's Wish	Dorothy trades the Golden Cap to get back to Kansas and Glinda uses the wishes to send the Lion, the Scarecrown, and the Tin woodman home. Glinda tells Dorohty to command the silver shoes to take her back to Kansas	Glinda gets Dorothy home		Unknown	Known	-	++	Revelatory	Glinda won't tell Dorothy how to get home without Dorothy giving her the Golden Cap	3rd Person Omniscient	later that afternoon and into the evening	Three Hours	South Country Glinda's Castle	Dorothy, the lion, the scarecrow, the Tin Woodman, the Soldier Girl, Glinda, Toto, Uncle Henry	8	Glinda, Aunt Em, Uncle Henry, Oz, Hammer Heads, The Winged Monkeys, The Winkies, The Beasts, The King of the Monkeys, the Wicked Witch, The People	11	Ending Payoff		Do the Ends Justify the Means?; The Protagonist at the Mercy of the Antagonist	Resolution	Crisis (Irreconcilable Goods); Climax	13	15
44	24	74	24	Home Again	Dorothy comes home and rushes into Aunt em's arms	Home again		Exiled	Home	-	++	Active	Dorothy runs into Aunt Em's arms	3rd Person Omniscient	Dusk	Five Minutes	Kansas	Aunt Em, Dorothy	2		0	Ending Payoff		Dorothy's Sacrifice is Rewarded	Resolution	Resolution	15	16
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100