When a Pantster has to Plot – or how I wish I knew then what I know now…

Excel worksheet showing the timeline for each character

I consider myself to be a pantster because I don’t plot the events of my stories out in advance, but as you can see from the Excel worksheet above, there comes a time when plotting is a necessity.

Every ‘event’ shown in the top half of the timeline has already happened – in book 1 of Vokhtah – and generally speaking, I managed to keep that story nice and tight. The trouble started when I first realised that the timeline for the caravan to and from Deepwater was way out of whack.

That unpleasant discovery lead to the first Excel spreadsheet which reverse engineered the plot, but only for the Blue/Messenger and the Apprentice. If you haven’t read Vokhtah, don’t worry. All you need to know is that the Blue-disguised-as-a-Messenger and the na-Seneschal-disguised-as-an-Apprentice were the two main characters. Reverse engineering their timelines necessitated the making of a map:

Map of Vokhtah created using Inkarnate

The grid on the map allowed me to get a realistic [ahem] idea of how long the different parts of the journey would take. That was when I realised just how out of whack my guestimate in Vokhtah actually was.

What the hell was I going to do about it? Vokhtah was already published and book 2 relies on that timeline. Could I fudge it?

The simple answer is no, I can’t fudge it because a small fudge in book 1 will snowball in subsequent books as I weave the lives of the other characters into the storyline.

In desperation, I went back to Excel and created the spreadsheet you see up the top.

I’ve now got a pretty precise handle on the various timelines, but what’s become painfully obvious is that a few things will have to be changed in book 1. They’re not major things; the story stays the same. What will change is the sequence of some of the chapters. Chapters, and the sequence in which they occur, give the Reader a sense of time passing. I needed more time for certain things to happen, even though they aren’t mentioned at all in book 1. These are the things that happen concurrently with the main plot and lead directly to plot events in the next book.

What kind of things? Gestation, for one. The Six of Needlepoint is mated on day 16 of the story [in book 1]. Something has to happen XX number of days later, but it can only happen if the foetus has had a reasonable amount of time to develop…

Okay, I can see some of you rolling your eyes in disbelief. Why don’t I simply make the gestation period fit what the plot demands?

The reason is that biology is my thing, and although I’m writing about aliens, there are certain things that probably stay the same for all carbon based lifeforms – the bigger the animal, the longer its gestation period. So yes, I could fudge it, the Vokhtah series is a work of fiction about a place and a people that do not exist, but… -deep sigh- I HATE scifi that fudges things.

So, now to my regrets. When I published Vokhtah [book 1 of the Suns of Vokhtah], publishing anything was a brand new experience. I did a lot of research about how to publish as an Indie, but there were so many things I did not know, could not know. One of those things is that the first book of a series sets the rules of the world in place. Subsequent books have to live with those rules. You can’t just suddenly change a core constraint – like time – without ruining the story for people,like me, fussy, picky people with a decent memory. 😦

By the time I’d written the Innerscape series I knew better and did not publish book 1 until the whole damn lot was right. I think it shows in a plot that is tight, despite being written by a pantster. How can I do any less for Vokhtah?

The result of all this soul searching is that once the whole series is finished, I’ll put out a new edition of the first book before I publish the subsequent books. I just hope that doesn’t mean I’ll lose all the hard won reviews dating all the way back to 2013. 😦

Anyway… every decision has consequences, and I’ll just have to live with mine, but boy do I wish I’d known all this in 2013.

Anyone else have regrets?

Meeks-with-a-sad-face

Excel 2016 – how to fill a series… backwards

I’ve used Excel for a very long time, but I literally just discovered this neat trick so I’m going to share. 🙂

Ok, to start at the beginning, I started an Excel spreadsheet to create a super accurate timeline of the Vokhtah story. To track the number of days of the timeline, I created a column and ‘filled’ it with a sequence of numbers. Most people know how to do this but I’ll cover it nonetheless:

Step 1 Type in two consecutive numbers and then select both together:

Selecting these two consecutive numbers tells Excel the step order – i.e. 1 + 1 = 2, 2 + 1 = 3, 3 + 1 = 4 etc. If you typed in 10 followed by 20, Excel would know the step order was 10 + 10 = 20, 20 + 10 = 30, etc.

Once Excel knows the step order, clicking and holding the small square [as shown below] allows you to drag that step order to as many cells as you wish:

In the screenshot above, I dragged the handle down to the 7th cell, filling all the cells with the correct sequence of numbers.

So far so good? Stay with me. This is where it gets exciting. Being able to fill a series of cells with consecutive numbers was perfect for tracking how many days there were in the timeline, but that didn’t help me work out on which calendar day the journey/story began.

To put this as simply as possible, imagine a task takes you 10 days to complete, and you finish it on the last day of March [which has 31 days]. Now imagine if someone asked you which day of the month you started the task. If it’s only a few days you can easily count backwards, but if it’s more than a few days, you might have to drag out a calendar to work it out.

On Vokhtah, there are no months per se. Instead, there are 4 seasons which have an irregular number of days. Book 1 of Vokhtah takes place during the season of Tohoh, which has 100 days. To find out which calendar day the story began, I needed to do a backwards fill. This is how I did it.

1. Click in a vacant cell.
2. Look at the top right corner of the Excel toolbar and click the small arrow next to the ‘Fill’ icon:

This will display a small, drop down menu.

1. Select the ‘UP’ option from the drop down menu.
2. Now type the last number of your desired fill sequence in the cell.
3. Next, type the second last number of your desired fill sequence in the next cell up.
4. Select both cells.
5. Click-hold-drag the small square box UP to fill the cells from last to first [or any point in between]:

In the example shown above, I only dragged the small square as far as the number 4. In my real spreadsheet I dragged it from 100:

to Tohoh 42 – i.e. the day of the season on which the journey/story began:

I know a lot of writers out there will be shaking their heads right about now. “Use a spreadsheet? No way!”

To be honest, as a pantster, I would never have thought of using a spreadsheet to work out how the story should progress. But once I started writing books in a series, I had to make sure that info. in the first book married up to info in the second and third books. And that’s where Excel comes in because it allows me to outline in reverse.

So there you have it. Outlining in reverse aided by a backwards fill from Excel. It’s been a good day. 🙂

cheers,
Meeks