Today I will bore you guys with a post about writing.
Back in 2014 I did a piece on how I use a spreadsheet to plan my action scenes.
And of course there is the good practice of keeping track of word count and time spent writing to improve productivity1.
Today I found out another interesting application for spreadsheets: explore an ongoing series of stories, trace character arcs and keep the new material fresh.
And maybe I’m re-inventing the wheel, but…
Writing a series, especially if we are writing the different episodes out of chronological order, presents a number of pitfalls.
How many sword & sorcery stories – not to mention roleplaying scenarios! – start in a tavern? How many times did our old friend Conan fight a giant snake? How many times the bad guys motivation boiled down to “evil”?
I started thinking about this as I started my new Aculeo & Amunet story – working title, Curse of the Crimson Sands2.
The Aculeo & Amunet series includes now eight stories, and at this point the need to come up with fresh ideas, together with the need to keep the characters growing, are paramount.
So, here’s what I did.
I created a spreadsheet with a story in each row, in chronological order, and columns for
- Title (obviously)
- Location A
- Location B
- Amunet’s Motivation
- Aculeo’s Motivation
- The bad guy’s Motivation
So, here’s what I found out
a . Thrilling Locations
Three stories start in a tavern. Ouch!
And three stories feature underground structures.
This means that tunnels and taverns3 will be off-limits for a while. Time to start thinking about something original.
b . Meet the monsters
In eight stories, Aculeo & Amunet have faced and defeated: a Blob-like monster (baby-Shoggoth?), vengeful legionaries, a mad sorcerer and his pet lovecraftian god, said god’s cultists and a crocodile monster, fish-men and a creepy demon, ape-men, animated skeletons, zombies.
Not bad – in the monsters department, we might be still able to surprise our readers.
c . Girls are more complicated
Amunet’s motivations in the stories include curiosity, greed, ambition, vengeance, blackmail and the sheer need to survive. Interestingly enough, loyalty appears as a motivation in later stories, meaning the spoiled brat of the first stories is growing up.
Aculeo, on the other hand, normally reacts rather than act, and loyalty and decency are his main motivators, together with the need to survive.
It’s pretty obvious that most story situations are triggered by Amunet’s plotting and planning, and Aculeo then has to make the best of what’s at hand. It works, but it also suggests a few different ideas…
d . Behold… evil!!
Evil remains the main motivation of the bad guys, in four stories out of eight. This is probably the worst bit4,and the one that needs work the most. because everyone loves a power-crazed evil sorcerer, but giving him a little depth makes for a better story.
And anyway, no more evil sorcerers for a while, even if…
So, now I know what needs to be tweaked to make Curse of the Crimson Sands a better, (and easier to sell!) story.
The system seems to work, and I’m thinking about adding a few other columns to my spreadsheet. What about secondary characters, for instance?
I’ll keep you posted.
- check out Rachel Aaron’s excellent 2000 to 10000. ↩
- all the Aculeo & Amunet stories should have the Something of something something title structure. Only Severed Heads Valley breaks this rule. ↩
- nice title for a game supplement – must talk with my friend Umberto, the author of Beasts & Barbarians… ↩
- yes, worse than tunnels and taverns, because it’s easier to make those original than “he’s evil!” as a character motivation. ↩