Tag Archives: seasons

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. ๐Ÿ™‚


Vokhtan calendar – complete

This is the final version of the Vokhtan calendar. It shows the interactions between the two suns and the planet with respect to seasons [roughly] and the day/night cycle [also roughly].

For the days, I made an executive decision and decreed that the Vokhtan day would comprise 24 ‘turns’. I chose the number 24 because I needed to dissect a circle into ‘wedges’ of time. Now, a circle has 365 degrees and a ‘wedge’ of 15.2 degrees goes into 365 almost exactly 24 times. This is something Corel Draw does very easily:

Now, when I place these wedges of time over the visuals of the planet, I get a kind of clock that tells me how many turns of bright light, red light, orange light and dark there are in the day at different times of the year:

Bright light = yellow sun Takh alone in the sky.

Red light = red dwarf, Takhti, alone in the sky.

Orange light = both suns in the sky at the same time.

Dark = truedark, i.e. when neither sun is in the sky.

This is a representation of a day in the middle of Piihoh. The red dwarf is completely eclipsed, so Vokhtah has just a simple, day/night cycle:

This next graphic is from the middle of Tohoh:

The day begins with almost 2 turns of Takh [yellow star] alone in the sky [because the planet rotates to the east]. Then Takhti rises and creates an orangey kind of light. When Takh sets, Takhti is alone in the sky for a couple of turns and it’s like a red twilight. When Takhti finally sets, truedark begins.

This next graphic is what the Vokh see in the middle of Kohoh – half red twilight, half bright yellow day, no truedark:

And finally, the graphic from the middle of Tuhoh. This is a mirror image of the same time during Tohoh but…this time, it’s the red dwarf that ‘rises’ first [because the planet rotates to the east]. It’s alone in the sky for a couple of turns and the inhabitants experience a red, gloomy morning. Then Takh [yellow sun] rises to brighten the gloom. At the end of the day, Takh shines alone. When Takh sets, truedark begins:

So there you have it. Time on Vokhtah has been tamed. Most days start with firstlight, progress to secondlight, peak at midlight, dim with firstdark and end with truedark. Middark is the halfway point of any dark cycle, while deepdark is the ‘dead of night’ and corresponds to the time between middark and firstlight.

Was all this work worth it, given that it was all based on guesswork?

Yes, for me, because I’ve never been good at ‘fudging’ things, and I desperately needed to know what Takh and Takhti might feel like, to a creature living on the planet.

Why didn’t I just get an astronomer to help me?

Because I don’t know any, and none of the websites I visited had what I was looking for. So I made my own. ๐Ÿ™‚

As this post is more for my benefit than yours, I’ve turned comments off. ๐Ÿ™‚



Binary star systems

Since starting to write the Suns of Vokhtah series again, I’ve tripped up on some unexpected hurdles, one of which is the effect the binary star system has on the day/night and seasonal changes as experienced on the planet.

I thought I’d worked it all out over five years ago, and I do have graphics to prove it, but as I looked at those graphics I realised that I couldn’t remember the thinking behind them:

Was it actually right? I no longer knew. And it niggled so much I knew I had to go back and reinvent the wheel. So these are the earliest of the new graphics:

Creating the day/night cycle in Corel Draw 8 stage 1:

As you can see, the planet obits the G2 [yellow] star in an elliptical orbit which makes EVERYTHING so much harder. The lines connecting the centre of the star to the centre of the planet are always at right angles to simulate the orientation of the planet to its star. Assuming the star and planet exist on a flat plane, I think that’s right, from the point of view of geometry. Seems logical, but I know very little about actual astronomy.

Anyway, the big yellow star is Takh and the small red one is its binary companion, Takhti.

Next step in Corel was to group the positions of the planet, and flip a copy of them horizontally. A bit of realignment was necessary to get it looking like this:

And finally, I filled in the gaps at the top and bottom:

I haven’t modelled the effect of the dwarf red star yet, so it’s hard to see the significance of theย example at the very bottom, but mid-Piihoh is the time in the planetary cycle when the dwarf red sun is completely eclipsed by the G2 star.

The example at the very top is mid-Kohoh. This is when the planet experiences virtually no dark – i.e. night time. Again, this will become more obvious once I complete the red dwarf overlays. Of course, working /that/ out requires some hefty mental shifts on my part because the planet rotates in an easterly direction around its own axis, but revolves around the G2 sun in an anti-clockwise direction…

Nevermind, I sort of know what I’m doing, but it still gives me brain-ache.











%d bloggers like this: