{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Tabelle1","Tabelle2","Tabelle3"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Tabelle1","index":0,"n_rows":38,"n_cols":15,"rows_kept":38,"cut":false,"hidden":false,"merged":[[28,13,29,13],[32,13,33,13],[35,13,36,13],[13,6,14,6],[16,6,17,6],[19,6,20,6],[28,6,29,6],[35,6,36,6],[32,6,33,6]]}
[]
[null,"Sternzeit, Uhrzeit und geographische Länge"]
[]
[null,"GMST(0)","Mittlere Sternzeit in Greenwich heute 00:00 UT"]
[null,"LMST","Mittlere lokale, vom Längengrad abhängige Sternzeit",null,null,null,null,null,null,null,null,null,null,"Ingo Mennerich, März 2018"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Überarbeitet: 11/21 "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"mit Unterstützung Markus Schilling"]
[]
[null,null,null,null,null,null,null,null,null,"Deutschland"]
[null,"Ort A",null,null,null,"Heute (local)",{"$f":"TODAY()","v":"2021-11-30"},null,null,"Differenz zu GMT/UTC ",null,null,null,1,"Stunde"]
[null,null,null,null,null,null,null,null,null,"(Sommer +2h / Winter +1h)"]
[null,"Länge (Grad, Minuten)",null,null,null,"Heute (GMST(0))",{"$f":"Tabelle2!C27","v":"2021-11-30"}]
[]
[null,10,"°",0,"´","Greenwich Zeit ",{"$f":"Tabelle2!C40","v":44530.374701504632}]
[]
[]
[null,null,null,null,null,"GMST(0)",{"$f":"Tabelle2!M43","v":"04:36:21.440"}]
[]
[]
[null,null,null,null,null,"LMST(A)",{"$f":"Tabelle2!M45","v":"14:17:24.080"}]
[]
[]
[]
[]
[null,"Ort B",null,null,null,"Datum (UT)",{"$f":"Tabelle2!C60","v":"2021-11-30"},null,"Ort C",null,null,null,"Datum (UT)",{"$f":"Tabelle2!C93","v":"2021-11-29"}]
[]
[null,"Länge (Grad, Minuten)",null,null,null,null,null,null,"Länge (Grad, Minuten)"]
[]
[null,10,"°",0,"´","Uhrzeit (UT)",{"$f":"Tabelle2!C74","v":"22:00:00"},null,10,"°",0,"´","Uhrzeit (UT)",{"$f":"Tabelle2!C107","v":"23:00:00"}]
[]
[null,"Uhrzeit (MEZ/MESZ)",null,null,null,null,null,null,"Uhrzeit (MEZ/MESZ)"]
[]
[null,23,"h",0,"min","GMST(0)",{"$f":"Tabelle2!M81","v":"04:36:21.440"},null,0,"h",0,"min","GMST(0)",{"$f":"Tabelle2!M114","v":"04:32:24.885"}]
[]
[]
[null,"Zeitzone (UTC +/- h)",null,null,null,"LMST(B)",{"$f":"Tabelle2!M83","v":"03:19:58.290"},null,"Zeitzone (UTC +/- h)",null,null,null,"LMST(C)",{"$f":"Tabelle2!M116","v":"04:16:11.591"}]
[null,"z.B. MEZ + 1h, MESZ +2h",null,null,null,null,null,null,"z.B. MEZ + 1h, MESZ +2h"]
[null,1,"h",null,null,null,null,null,1,"h"]

{"sheet":"Tabelle2","index":1,"n_rows":116,"n_cols":13,"rows_kept":116,"cut":false,"hidden":false,"merged":[]}
[]
[null,"STERNZEIT (GMST(0) und LMST) durch JULIANISCHES DATUM (JD) berechnen"]
[]
[null,"Formeln WIKIPEDIA: \"Sternzeit\" und https://www.sternenhimmel.info/die-sternzeit.html"]
[]
[null,"Julianisches Datum: Anzahl der Tage seit dem 01. Januar -4723, 00:00 UT"]
[]
[]
[null,"T: Anzahl der dem 01.01.2000 vergangenen Jahrhunderte seit "]
[]
[]
[]
[null,"Greenwich Mean Sidereal Time (heute, 00:00 UT)"]
[]
[]
[]
[null,"Local Mean Sidereal Time"]
[]
[]
[]
[]
[]
[null,"Systemzeit, aktualisieren durch Anklicken"]
[]
[null,"Ort A"]
[]
[null,"SYSTEMZEIT",{"$f":"ROUNDDOWN(NOW()-Tabelle1!N10/24,0)","v":"2021-11-30"},"(Heute, 00:00h)"]
[]
[null,"JD",{"$f":"2451544.5+C27-DATE(2000,1,1)","v":2459548.5}]
[]
[null,"T",{"$f":"(C29-2451545)/36525","v":0.21912388774811772}]
[]
[null,"Länge",{"$f":"Tabelle1!B14","v":10},"°",{"$f":"Tabelle1!D14","v":0},"´"]
[]
[null,null,{"$f":"IF(C33>0,C33+E33/60,C33-E33/60)","v":10},"°"]
[]
[]
[]
[]
[null,"Uhrzeit",{"$f":"NOW()-Tabelle1!N10/24","v":44530.374701504632},"Systemzeit"]
[]
[]
[null,null,null,null,null,"GMST0",{"$f":"24110.54841+8640184.812866*C31+0.093104*C31^2-0.0000062*C31^3","v":1917381.4399377904},"Sekunden",{"$f":"G43/3600","v":532.60595553827511},"h",{"$f":"(I43/24-INT(I43/24))*24","v":4.6059555382751398},null,{"$f":"K43/24","v":"04:36:21.440"}]
[null,"Seit 00:00",{"$f":"(C40-INT(C40))*24","v":8.9928361111669801},"h (seit 00:00)"]
[null,null,null,null,null,"LST",{"$f":"G43+240*C35+1.002738*C46","v":1952244.0799497904},"Sekunden",{"$f":"G45/3600","v":542.2900222082751},"h",{"$f":"(I45/24-INT(I45/24))*24","v":14.290022208275076},null,{"$f":"K45/24","v":"14:17:24.080"}]
[null,null,{"$f":"INT(C44*3600)","v":32374},"s (seit 00:00)"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ort B"]
[]
[null,null,{"$f":"ROUNDDOWN(NOW()-Tabelle1!N10/24,0)","v":"2021-11-30"},null,"DATUM HEUTE, 00:00h MEZ/MESZ"]
[]
[null,null,{"$f":"IF((C71/24+E71/1440)<Tabelle1!N10/24,C58-1,C58)","v":"2021-11-30"},null,"DATUM HEUTE, 00:00h UTC"]
[]
[null,"JD",{"$f":"2451544.5+C60-DATE(2000,1,1)","v":2459548.5},null,"Julianisches Datum (Tage nach 01.01. -4723 12:00 UT)"]
[]
[null,"T",{"$f":"(C62-2451545)/36525","v":0.21912388774811772},null,"Jahrhunderte nach 01.01.2000"]
[]
[]
[null,"Länge",{"$f":"Tabelle1!B29","v":10},"°",{"$f":"Tabelle1!D29","v":0},"´"]
[]
[null,null,{"$f":"IF(C67>0,C67+E67/60,C67-E67/60)","v":10}]
[]
[null,null,{"$f":"Tabelle1!B33","v":23},"h",{"$f":"Tabelle1!D33","v":0},"min"]
[]
[]
[null,"Uhrzeit",{"$f":"IF(E74<0,E74+Tabelle1!N10,E74)","v":"22:00:00"},null,{"$f":"(C71/24+E71/1440)-Tabelle1!N10/24","v":0.91666666666666674},"Eingabe Stunden/Minuten -Offset UTC"]
[]
[]
[null,"Seit 00:00 UTC",{"$f":"(C74-INT(C74))*24","v":22},"h (seit 00:00)"]
[]
[null,null,{"$f":"INT(C77*3600)","v":79200},"s (seit 00:00)"]
[]
[null,null,null,null,null,"GMST0",{"$f":"24110.54841+8640184.812866*C64+0.093104*C64^2-0.0000062*C64^3","v":1917381.4399377904},"Sekunden",{"$f":"G81/3600","v":532.60595553827511},"h*",{"$f":"(I81/24-INT(I81/24))*24","v":4.6059555382751398},null,{"$f":"K81/24","v":"04:36:21.440"}]
[]
[null,null,null,null,null,"LST",{"$f":"G81+240*C69+1.002738*C79","v":1999198.2895377905},"Sekunden",{"$f":"G83/3600","v":555.33285820494177},"h",{"$f":"(I83/24-INT(I83/24))*24","v":3.3328582049418003},null,{"$f":"K83/24","v":"03:19:58.290"}]
[]
[]
[]
[]
[]
[null,"Ort C"]
[]
[null,null,{"$f":"ROUNDDOWN(NOW()-Tabelle1!N10/24,0)","v":"2021-11-30"},null,"DATUM HEUTE, 00:00h MEZ/MESZ"]
[]
[null,null,{"$f":"IF((C104/24+E104/1440)<Tabelle1!N10/24,C91-1,C91)","v":"2021-11-29"},null,"DATUM HEUTE, 00:00h UTC"]
[]
[null,"JD",{"$f":"2451544.5+C93-DATE(2000,1,1)","v":2459547.5},null,"Julianisches Datum (Tage nach 01.01. -4723 12:00 UT)"]
[]
[null,"T",{"$f":"(C95-2451545)/36525","v":0.2190965092402464},null,"Jahrhunderte nach 01.01.2000"]
[]
[]
[null,"Länge",{"$f":"Tabelle1!I29","v":10},"°",{"$f":"Tabelle1!K29","v":0},"´"]
[]
[null,null,{"$f":"IF(C100>0,C100+E100/60,C100-E100/60)","v":10}]
[]
[null,null,{"$f":"Tabelle1!I33","v":0},"h",{"$f":"Tabelle1!K33","v":0},"min"]
[]
[]
[null,"Uhrzeit",{"$f":"IF(E107<0,E107+Tabelle1!N10,E107)","v":"23:00:00"},null,{"$f":"(C104/24+E104/1440)-Tabelle1!N10/24","v":-4.1666666666666664E-2},"Eingabe Stunden/Minuten -Offset UTC"]
[]
[]
[null,"Seit 00:00 UTC",{"$f":"(C107-INT(C107))*24","v":23},"h (seit 00:00)"]
[]
[null,null,{"$f":"INT(C110*3600)","v":82800},"s (seit 00:00)"]
[]
[null,null,null,null,null,"GMST0",{"$f":"24110.54841+8640184.812866*C97+0.093104*C97^2-0.0000062*C97^3","v":1917144.8845687646},"Sekunden",{"$f":"G114/3600","v":532.54024571354569},"h*",{"$f":"(I114/24-INT(I114/24))*24","v":4.5402457135456871},null,{"$f":"K114/24","v":"04:32:24.885"}]
[]
[null,null,null,null,null,"LST",{"$f":"G114+240*C102+1.002738*C112","v":2002571.5909687646},"Sekunden",{"$f":"G116/3600","v":556.26988638021237},"h",{"$f":"(I116/24-INT(I116/24))*24","v":4.2698863802123697},null,{"$f":"K116/24","v":"04:16:11.591"}]

{"sheet":"Tabelle3","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}