(no subject)
Jul. 23rd, 2016 08:42 am![[personal profile]](https://www.dreamwidth.org/img/silk/identity/user.png){kind=small}
scarfmanI discovered that you can use the Excel date formula
=DATE([four digit year],[month number],[date])
like this:
=DATE([four digit year],1,[the date's day number for the year])
This is significant of course because the format of the Star Trek reboot movies' stardates is
[four digit year][decimal point][the date's day number for the year]
and it's going to revolutionarily simplify the airdate-to-chronology tracking formula in my crossover spreadsheet, just when I was already going to have to modify it with new data from Star Trek Beyond.
This is almost as thrilling as seeing the movie or drawing a cartoon. Who says there's no worldbuilding in fanfiction?
I also went through all Three Faces dialog and changed every instance of "Elder Spock" to "Ambassador Spock", to reflect usage in this movie.
=DATE([four digit year],[month number],[date])
like this:
=DATE([four digit year],1,[the date's day number for the year])
This is significant of course because the format of the Star Trek reboot movies' stardates is
[four digit year][decimal point][the date's day number for the year]
and it's going to revolutionarily simplify the airdate-to-chronology tracking formula in my crossover spreadsheet, just when I was already going to have to modify it with new data from Star Trek Beyond.
This is almost as thrilling as seeing the movie or drawing a cartoon. Who says there's no worldbuilding in fanfiction?
I also went through all Three Faces dialog and changed every instance of "Elder Spock" to "Ambassador Spock", to reflect usage in this movie.
