Columns | Storage |
---|---|
1-8 | (JPD, DWORD) Julian Period Day (the day that it will be at noon UTC) To get the time it was at 12AM, subtract 0.5; for 6AM, subtract 0.25; for 6PM, add 0.25; for 12AM the following day, add 0.5; for 6AM the following day, add 0.75. |
9 | Intentionally Left Blank |
10 | (WKDY, LONG) Weekday January 1 fell on. 0 = Mon, 1 = Tue, 2 = Wed, 3 = Thu, 4 = Fri, 5 = Sat, 6 = Sun. These values are stored in this file for easier visual checking of the accuracy of the formulas. |
11 | Intentionally Left Blank |
12-16 | (JCY, DWORD) Julian Calendar Year (NOT the Julian Period Year) + 20000. If the Julian Calendar Years are A.D. or C.E., then just add the 20000 and store it. For years that are B.C. or B.C.E. (note: this calendar has no year zero), take the absolute value of the year and subtract it from the value 20001. (Day 0 of the Julian Period Day has the year of 4713 B.C., stored as 20001 - 4713, or 15288; or think of 4713 B.C. as year -4712 and add that negative year to 20000 to get 15288). |
17-19 | (JCM, LONG) Julian Calendar Month + 100 |
20-22 | (JCD, LONG) Julian Calendar Day of the Month + 100 |
23 | Intentionally Left Blank |
Julian Period Day ÷ 365.25
JPY = JPD / 365.25 | |
24-28 | (JPY, SINGLE) Julian Period Year (integer) (it's the Julian-1 Calendar Year plus 4712) |
29-38 | (JPY, SINGLE) Julian Period Year (decimal portion) |
39 | Intentionally Left Blank |
Julian Period Day − (INT(Julian Period Day ÷ 365.25) × 365.25)
JPDY = JPD - (INT(JPD / 365.25) * 365.25) | |
40-42 | (JPDY, SINGLE) Julian Period Day of the Year (integer) |
43-52 | (JPDY, SINGLE) Julian Period Day of the Year (decimal portion) |
53 | Intentionally Left Blank |
Note: The Gregorian Period Day (GPD, DWORD) is always 38 days less than the Julian Period Day, so there's no need to store it in the database, but can be stored in a variable in a computer program for easier computing of the answers. This number is the offset of days that differ between the two proleptic Julian-1 and Gregorian calendars of the 48th century B.C. Like the JPD, the GPD day begins at noon the current day (decimal value is .0). | |
54-58 | (GCY, DWORD) Gregorian Calendar Year (NOT the Gregorian Period Year) + 20000. If the Gregorian Calendar Years are A.D. or C.E., then just add the 20000 and store it. For years that are B.C. or B.C.E. (note: this calendar has no year zero), take the absolute value of the year and subtract it from the value 20001. (Gregorian Period Day zero, which is Julian Period Day 38, has the year of 4713 B.C., stored as 20001 - 4713, or 15288; or think of 4713 B.C. as year -4712 and add that negative year to 20000 to get 15288). |
59-61 | (GCM, LONG) Gregorian Calendar Month + 100 |
62-64 | (GCD, LONG) Gregorian Calendar Day of the Month + 100 |
65 | Intentionally Left Blank |
(Julian Period Day − 38) ÷ 365.24218967
GPY = (JPD - 38) / 365.24218967 | |
66-70 | (GPY, SINGLE) Gregorian Period Year (integer) (may not always match the rate of the Gregorian Calendar Year, but its the Gregorian calendar year plus 4712) |
71-80 | (GPY, SINGLE) Gregorian Period Year (decimal portion) |
81 | Intentionally Left Blank |
INT(Julian Period Day − 38) − (INT((Julian Period Day − 38) ÷ 365.24218967) × 365.24218967))
GPDY = (JPD - 38) - (INT((JPD - 38) / 365.24218967) * 365.24218967)) | |
82-84 | (GPDY, SINGLE) Gregorian Period Day of the Year (integer) (may not always match the Gregorian Calendar Day of the Year) |
85-94 | (GPDY, SINGLE) Gregorian Period Day of the Year (decimal portion) |
95 | Intentionally Left Blank |
Note:
The Hebrew Period Day (HPD, DWORD) is always 347997.25 (due to the fact that the new Hebrew day begins around sunset) days
behind that of the Julian Period Day, so there's no need to store it in the database,
but can be stored in a variable in a computer program for easier computing of the answers.
The epochic date, Tishrei 1, year 1, is equivalent to Monday, October 7, 3761 B.C.E. proleptic Julian-1 calendar or September 7, 3761 B.C.E. in the proleptic Gregorian calendar. October 7, 3761 B.C.E. Julian-Roman-1 is the equivalent of the Julian Period Day 347998, which began at 12:00 PM. The equivalent Hebrew date that corresponds to October 7, 3761 B.C.E. Julian-Roman-1 began at sunset or around 6PM on October 6, 3761 B.C.E. Julian-Roman-1 or Julian Period Day 347997.25, marking the start of Hebrew Period Day number 0. When it was noon October 7, 3761 B.C.E., the Julian Period Day incremented to 347998.00 and the Hebrew Period Day incremented to 0.75, therefore, there is an offset of 347997.25 between the two Period Days. This number is the offset of days that differ between the two proleptic Julian-1 and Hebrew calendars of the 48th century B.C. Unlike the JPD, the HPD day listed on the same row as the JPD begins at sunset (around 6pm) the evening before the current day (decimal value is .75 at noon the current day). For example, if the JPD is at noon, it ends with the .0, while the HPD at the same time ends at .75. When it's around 6pm or sunset, the JPD ends with a .25, but the HPD values has 1.0 added to the listed value. If it's 9pm, add .375 to the JPD and 1.125 to the HPD value. | |
96-100 | (HCY, DWORD) Hebrew Calendar Year (NOT the Hebrew Period Year) + 20000. |
101-103 | (HCM, LONG) Hebrew Calendar Month (stored as 101-111 for the first months plus the leap month at 112, and 212 for the final month of the year) |
104-106 | (HCD, LONG) Hebrew Calendar Day of the Month + 100 |
107 | Intentionally Left Blank |
108-112 | (HPY, SINGLE) Hebrew Period Year (integer) |
113-122 | (HPY, SINGLE) Hebrew Period Year (decimal portion) |
123 | Intentionally Left Blank |
124-126 | (HPDY, SINGLE) Hebrew Period Day of the Year (integer) (may not always match the Hebrew Calendar Day of the Year) (note: The Hebrew Period Day is lined up between the first day of the first year of the Hebrew calendar and the matching Julian Period Date, and the Hebrew Calendar does not necessarily match the Hebrew Period Year due to the calendar's design. The epochic date, 1 Tishrei year 1, is equivalent to Monday, October 7, 3761 B.C.E. proleptic Julian-1 calendar or September 7, 3761 B.C.E. in the proleptic Gregorian calendar.) |
127-136 | (HPDY, SINGLE) Hebrew Period Day of the Year (decimal portion) |
137 | Intentionally Left Blank |
138-142 | (MCY, DWORD) Martian Calendar of Earth Year + 20000 (calendar based on arbitrary rules for calendar set) |
143-145 | (MCM, LONG) Martian Calendar of Earth Month + 100 (stored as 101-124) |
146-148 | (MCD, LONG) Martian Calendar of Earth Day of the Month + 100 |
149 | Intentionally Left Blank |
Julian Period Day ÷ 686.97258
MCEY = JPD / 686.97258 | |
150-154 | (MCEY, SINGLE) Martian Calendar of Earth Year (integer) (based on Earth synodic days and Mars synodic year) (lines up at zero with Julian Period Day zero.) |
155-164 | (MCEY, SINGLE) Martian Calendar of Earth Year (decimal portion) |
165 | Intentionally Left Blank |
Julian Period Day − (INT(Julian Period Day ÷ 686.97258) × 686.97258)
MCEDY = JPD - (INT(JPD / 686.97258) * 686.97258) | |
166-168 | (MCEDY, SINGLE) Martian Calendar of Earth Day of the Year (integer) |
169-178 | (MCEDY, SINGLE) Martian Calendar of Earth Day of the Year (decimal portion) |
179 | Intentionally Left Blank |
Julian Period Day ÷ 1.02749125170
MPMD = JPD / 1.02749125170 | |
180-187 | (MPMD, SINGLE) Martian Period of Mars Day (integer). Lines up at zero with Julian Period Day zero. Increments approximately by 0.9732 for every one increment of the Julian Period Day. (based on Mars synodic days and Mars synodic year) |
188-197 | (MPMD, SINGLE) Martian Period of Mars Day (decimal portion) |
198 | Intentionally Left Blank |
Martian Period of Mars Day ÷ 668.592018
MPMY = MPMD / 668.592018 | |
199-203 | (MPMY, SINGLE) Martian Period of Mars Year (integer) |
204-213 | (MPMY, SINGLE) Martian Period of Mars Year (decimal portion) |
214 | Intentionally Left Blank |
Martian Period of Mars Day − (INT(Martian Period of Mars Day ÷ 668.592018) × 668.592018)
MPMDY = MPMD - (INT(MPMD / 668.592018) * 668.592018) | |
215-217 | (MPMDY, SINGLE) Martian Period of Mars Day of the Year (integer) |
218-227 | (MPMDY, SINGLE) Martian Period of Mars Day of the Year (decimal portion) |
228 | Intentionally Left Blank |
?-end | Future expansion |
© 1995-2023. davesfunstuff.com. All Rights Reserved. Reproduction of any part of this website without expressed written consent is prohibited.