I mentioned
earlier this month that I created a spreadsheet to manage the
timeline for November 2018’s NaNovel. Most of it was along the
lines of “this event happens so-and-so minutes after the previous
event” but there were also
- events that had to happen before other events.
- events that had to happen relative to much earlier events.
It also involved a
starship accelerating constantly at a multiple of 1g, the
acceleration due to gravity, (which is a clue that the Galactic
Imperium sneers at our primitive view of the laws of physics). I had
to keep track of how far away from Earth the ship was while heading
for a hyperjump point in the outer solar system, to take into account
lightspeed delays in communication. This post is for those who love
spreadsheet hacking; I’ll say a few words about how I did all this.