Roleplay Date Conversion

[Philip Culmer]

I'm currently playing with producing a smartwatch app (or apps) to show local time for Manticore, Gryphon, and Sphinx; obviously, if this ever goes any further than a purely private project, appropriate approval will be sought before any sort of sharing or publication.

One issue, at least at the spreadsheet stage of development is that 20th and 21st century based software isn't great at working on dates in what, to us, is the 40th century: most functions revert to a base of 1900CE, wrapping at the end of the 21st century. (Edit - Google sheets seems to be better on this)

I have a vague memory of some mention of a conversion of current dates to a roleplayed PD date - does anybody recall this, and possibly what the roleplayed dates were?

(Edit)
Also, here's a spreadsheet with my calculations - is there anyone interested in critiquing my figures?
https://docs.google.com/spreadsheets/d/ ... sp=sharing

[Karyn Hill, KDE, QBM, MP]

I've seen discussions about this but can't recall who was involved. Since none of them seem to have noticed this post, if you'd like, I can submit it as a question from the House of Commons as a question to the Prime Minister. Those questions get passed to the person who is able to answer it.

[Peter Gold]

Wouldn't it be simpler to calculate SKM local to PD followed up by adding the PD calc?
Earth is on the same calendar we are using in real life except the base year number is offset. That keeps everything in the 20th century as far as the spreadsheet is concerned.

Sent from my LM-G710 using Tapatalk

[Philip Culmer]

Wouldn't it be simpler to calculate SKM local to PD followed up by adding the PD calc?
Earth is on the same calendar we are using in real life except the base year number is offset. That keeps everything in the 20th century as far as the spreadsheet is concerned.

Possibly, though one has to allow for the correct placement of leap years.
Thankfully, Google Sheets is better at handling dates - though I will need to translate it all into Lua to get it working on the watch.

PMQs sounds like a great idea, Karyn.

[Rowan Wagstaff-Weston]

As a kludge, if you add 103 to the PD year then days of the week and leap years all line up correctly - so, for example, 1921PD would be the same calendar as 2024CE, unless my calculations are off.

[Rowan Wagstaff-Weston]

As a kludge, if you add 103 to the PD year then days of the week and leap years all line up correctly - so, for example, 1921PD would be the same calendar as 2024CE, unless my calculations are off.

Correction, that should be 102 years... I miscalculated based on the calendar starting in 0PD rather than 1PD.

[Philip Culmer]

That could be a possibility, at least in the immediate future; we might need to look at leap years, though.

Sent from my SM-T585 using Tapatalk

[Rowan Wagstaff-Weston]

Leap years *should* line up as well... since the Gregorian calendar repeats every 400 years, years in the 41st century would have the same distribution of leap years as the equivalent year in the 21st century. Since the year PD is equal to the year CE + 2102, adding 102 rather than 2102 shouldn't change the distribution of leap years etc.