Seite 10 von 17

Re: Datenübernahme von 1.9 in software2

Verfasst: Sa Jan 13, 2024 6:47 pm
von aiole
sunnykleineichen hat geschrieben: Sa Jan 13, 2024 1:00 pm Ich finde leider auch keine Hinweise (und ich habe schon einige Zeit gesucht), welche Dateien genau zu ändern sind bzw. wie man vorgehen sollte (speziell bei einem Zählerwechsel). Auch finde ich keinen Hinweis, ob man bei einer erneuten Datenübernahme zuerst die OpenWB zurücksetzen muss oder ob man die Datenübernahme erneut starten kann und die schon bestehenden Werte einfach überschrieben werden.
Ich würde es auf einem Testsystem ausprobieren. Ich vermute, dass die Daten einfach überschrieben werden.
sunnykleineichen hat geschrieben: Sa Jan 13, 2024 1:00 pm Ich bin wirklich bereit Zeit und Energie zu investieren - aber es gibt wirklich wenig Hinweise oder Beschreibungen, wie und wo die Daten manipuliert werden können und worauf mach achten muss.
Das liegt sicher mit daran, dass normalerweise NICHT manipuliert werden soll.

Re: Datenübernahme von 1.9 in software2

Verfasst: So Jan 14, 2024 11:05 am
von sunnykleineichen
aiole hat geschrieben: Sa Jan 13, 2024 6:47 pm Ich würde es auf einem Testsystem ausprobieren. Ich vermute, dass die Daten einfach überschrieben werden.
Das mache ich schon seit Wochen / Monaten. Immer wieder versuche ich die Datenübernahme auf einem Testsystem. Meine "richtige" OpenWB läuft noch unter 1.9
aiole hat geschrieben: Sa Jan 13, 2024 6:47 pm Das liegt sicher mit daran, dass normalerweise NICHT manipuliert werden soll.
Jetzt drehen wir uns im Kreis :-(
Wenn die Datenübernahme "sauber" funktionieren würde, müsste man nicht händisch eingreifen (was weiter vorne im Thread empfohlen und als Lösung angeboten wurde).
Ich würde zumindest hoffen / erwarten, dass die 1.9 und die 2.x gleich mit historischen Daten umgeht.
Denn wie geschrieben ... in der 1.9 sieht es gut aus.

Re: Datenübernahme von 1.9 in software2

Verfasst: So Jan 14, 2024 12:29 pm
von aiole
Ich rede von der DOKU für Manipulation ;).

Ich würde zuerst die "Sprungstellen" im Logging rausfischen und hier zeigen.

Re: Datenübernahme von 1.9 in software2

Verfasst: So Jan 14, 2024 1:03 pm
von sunnykleineichen
Okay, hier meine Daten. Ich hoffe es gibt eine Lösung.

Erstes Thema: März 2021
Problem: Neuer Zähler

Hier die Original-Daten aus dem Export (Monatssicht):

Code: Alles auswählen

20210301,27114554.900000002,11540795.3,20923113,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210302,27123510.3,11547594.600000001,20934756,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210303,27132664.3,11554647.100000001,20946456,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210304,27142473.3,11559916.100000001,20955978,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210305,27157124.5,11560070.100000001,20957657,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210306,27167714.400000002,11567082.200000001,20969752,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210307,27175237.8,11574095.3,20982557,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210308,27186266.6,11583361.8,20995681,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210309,27198038.8,11583778.600000001,20999586,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210310,27210755.8,11583778.600000001,21000781,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210311,27221302.3,11586127.9,21006337,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210312,27231784.900000002,11590119.4,21014503,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210313,27242670.1,11592303.5,21020027,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210314,27252910,11594614.3,21025326,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210315,27266694,11595216.4,21029199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210316,27277030.900000002,11598284.700000001,21035556,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210317,27287579.8,11600331.3,21040736,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210318,27296634,11602394.200000001,21046026,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210319,27306305.400000002,11605313.700000001,21052144,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210320,27339201.900000002,11613509.9,21066751,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210321,27349628.700000003,11621828.600000001,21080931,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210322,27361578,11622908.4,21085049,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210323,27374827.5,11622914.200000001,21087515,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210324,27384110.900000002,11626208.3,21094684,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210325,11860.6,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210326,21398.300000000003,6325.6,21119667,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210327,35182.200000000004,10969.800000000001,21132795,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210328,42347.5,17497.8,21144409,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210329,51264.5,22772,21153448,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210330,63643.100000000006,23514.4,21169745,66735.000,0,0,66735.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210331,70372.90000000001,31546.5,21185949,69209.000,0,0,69209.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
Das Problem beginnt ab dem 25.3.

Hier meine manipulierte Datei:

Code: Alles auswählen

20210301,27114554.900000002,11540795.3,20923113,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210302,27123510.3,11547594.600000001,20934756,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210303,27132664.3,11554647.100000001,20946456,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210304,27142473.3,11559916.100000001,20955978,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210305,27157124.5,11560070.100000001,20957657,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210306,27167714.400000002,11567082.200000001,20969752,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210307,27175237.8,11574095.3,20982557,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210308,27186266.6,11583361.8,20995681,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210309,27198038.8,11583778.600000001,20999586,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210310,27210755.8,11583778.600000001,21000781,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210311,27221302.3,11586127.9,21006337,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210312,27231784.900000002,11590119.4,21014503,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210313,27242670.1,11592303.5,21020027,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210314,27252910,11594614.3,21025326,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210315,27266694,11595216.4,21029199,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210316,27277030.900000002,11598284.700000001,21035556,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210317,27287579.8,11600331.3,21040736,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210318,27296634,11602394.200000001,21046026,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210319,27306305.400000002,11605313.700000001,21052144,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210320,27339201.900000002,11613509.9,21066751,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210321,27349628.700000003,11621828.600000001,21080931,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210322,27361578,11622908.4,21085049,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210323,27374827.5,11622914.200000001,21087515,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210324,27384110.900000002,11626208.3,21094684,26072.000,0,0,26072.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210325,27393614,11632240,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210326,27403152,11638272,21119667,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210327,27416936,11642916,21132795,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210328,27424101,11649444,21144409,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210329,27433018,11654719,21153448,52375.000,0,0,52375.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210330,27445397,11655461,21169745,66735.000,0,0,66735.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
20210331,27452126,11663493,21185949,69209.000,0,0,69209.000,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
Das Diagramm liefert mit dieser Änderung für den 31.3. falsche Werte (ich gehe fast davon aus, dass man sich noch Daten aus dem Monat 04 holt). In der Monatsdatei 04 sind natürlich auch wieder die neuen Zählerstände.

Hier die Tagesdaten im Original für den 24.3.2021 (musste ich kürzen, da der Post sonst zu groß ist):

Code: Alles auswählen

1210,27389595.900000002,11626466.9,21101525,31422.000,0,0,31422.000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1215,27389596.1,11626479.5,21101710,31545.000,0,0,31545.000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1220,27389649.900000002,11626482.100000001,21101897,31659.000,0,0,31659.000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1225,27389683.400000002,11626488.700000001,21102088,31775.000,0,0,31775.000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1230,27389695.8,11626498.5,21102279,31913.000,0,0,31913.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1235,27389706.200000003,11626511.3,21102467,32045.000,0,0,32045.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1240,27389714.700000003,11626523.9,21102653,32176.000,0,0,32176.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1245,27389723.700000003,11626537.600000001,21102840,32305.000,0,0,32305.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1250,27389733.8,11626547.8,21103016,32428.000,0,0,32428.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1255,27389740.3,11626560.4,21103200,32556.000,0,0,32556.000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1300,27389747,11626567.8,21103385,32677.000,0,0,32677.000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1305,27389754.200000003,11626580.5,21103568,32798.000,0,0,32798.000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1310,27389763,11626593.600000001,21103751,32929.000,0,0,32929.000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1315,27389770,11626605.200000001,21103931,33056.000,0,0,33056.000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1320,27389776.700000003,11626613.8,21104110,33232.000,0,0,33232.000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1325,2.2250738585072014e-308,2.2250738585072014e-308,21104291,33529.000,0,0,33529.000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1330,2.2250738585072014e-308,2.2250738585072014e-308,21104470,33827.000,0,0,33827.000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1335,2.2250738585072014e-308,2.2250738585072014e-308,21104648,34125.000,0,0,34125.000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1340,1000,2.2250738585072014e-308,21104825,34424.000,0,0,34424.000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1345,1000,2.2250738585072014e-308,21104997,34722.000,0,0,34722.000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1350,1000,2.2250738585072014e-308,21105168,35018.000,0,0,35018.000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1355,1000,2.2250738585072014e-308,21105340,35313.000,0,0,35313.000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1400,1000,2.2250738585072014e-308,21105509,35608.000,0,0,35608.000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1405,"last":1616591092780,,"last":1616591036296,,21105678,35901.000,0,0,35901.000,0,0,0,0,0,0,0,0,0,0,0,0,0,66,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1410,"last":1616591392715,,"last":1616591036296,,21105843,36196.000,0,0,36196.000,0,0,0,0,0,0,0,0,0,0,0,0,0,66,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1415,"last":1616591693742,,"last":1616591648042,,21106005,36496.000,0,0,36496.000,0,0,0,0,0,0,0,0,0,0,0,0,0,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1420,"last":1616591993299,,"last":0,,21106165,36794.000,0,0,36794.000,0,0,0,0,0,0,0,0,0,0,0,0,0,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1425,"last":1616592293223,,"last":1616592208678,,21106320,37092.000,0,0,37092.000,0,0,0,0,0,0,0,0,0,0,0,0,0,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1430,"last":1616592593033,,"last":1616592305635,,21106475,37390.00,0,0,37390.00,0,0,0,0,0,0,0,0,0,0,0,0,0,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1435,"last":1616592893230,,"last":1616592305635,,21106628,37687.000,0,0,37687.000,0,0,0,0,0,0,0,0,0,0,0,0,0,69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1440,"last":1616593192577,,"last":1616592305635,,21106779,37983.000,0,0,37983.000,0,0,0,0,0,0,0,0,0,0,0,0,0,69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1445,"last":1616593493016,,"last":1616592305635,,21106926,38281.000,0,0,38281.000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1450,"last":1616593792953,,"last":1616593497133,,21107070,38578.000,0,0,38578.000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1455,"last":1616594092782,,"last":0,,21107210,38877.000,0,0,38877.000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1500,"last":1616594393431,,"last":1616594184903,,21107346,39175.000,0,0,39175.000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1505,"last":1616594692526,,"last":1616594184903,,21107481,39475.000,0,0,39475.000,0,0,0,0,0,0,0,0,0,0,0,0,0,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1510,"last":1616594991905,,"last":1616594184903,,21107613,39779.000,0,0,39779.000,0,0,0,0,0,0,0,0,0,0,0,0,0,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1515,"last":1616595292523,,"last":1616595282796,,21107742,40082.000,0,0,40082.000,0,0,0,0,0,0,0,0,0,0,0,0,0,73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1520,"last":1616595593173,,"last":1616595575481,,21107868,40383.000,0,0,40383.000,0,0,0,0,0,0,0,0,0,0,0,0,0,73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1525,"last":1616595893108,,"last":1616595869953,,21107988,40681.000,0,0,40681.000,0,0,0,0,0,0,0,0,0,0,0,0,0,74,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1530,"last":1616596193672,,"last":1616596146051,,21108106,40976.000,0,0,40976.000,0,0,0,0,0,0,0,0,0,0,0,0,0,74,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1535,"last":1616596493113,,"last":1616596431759,,21108223,41270.00,0,0,41270.00,0,0,0,0,0,0,0,0,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1540,"last":1616596792922,,"last":1616596716646,,21108336,41562.000,0,0,41562.000,0,0,0,0,0,0,0,0,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1545,"last":1616597093183,,"last":1616596911466,,21108445,41855.000,0,0,41855.000,0,0,0,0,0,0,0,0,0,0,0,0,0,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1550,"last":1616597392624,,"last":1616596911466,,21108551,42148.000,0,0,42148.000,0,0,0,0,0,0,0,0,0,0,0,0,0,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1555,"last":1616597692665,,"last":1616596911466,,21108654,42445.000,0,0,42445.000,0,0,0,0,0,0,0,0,0,0,0,0,0,77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1600,"last":1616597993734,,"last":1616597968216,,21108753,42740.00,0,0,42740.00,0,0,0,0,0,0,0,0,0,0,0,0,0,77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1605,"last":1616598293068,,"last":1616598170213,,21108849,43034.000,0,0,43034.000,0,0,0,0,0,0,0,0,0,0,0,0,0,78,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1610,"last":1616598593475,,"last":1616598170213,,21108940,43328.000,0,0,43328.000,0,0,0,0,0,0,0,0,0,0,0,0,0,78,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1615,"last":1616598893829,,"last":1616598170213,,21109027,43623.000,0,0,43623.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1620,"last":1616599193230,,"last":1616599176088,,21109110,43918.000,0,0,43918.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1625,"last":1616599493154,,"last":1616599478507,,21109166,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1630,"last":1616599792700,,"last":1616599478507,,21109229,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1635,"last":1616600055865,,"last":1616600093477,,21109300,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1640,7763.700000000001,262.6,21109366,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1645,7763.8,277.8,21109412,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1650,7831.5,283.6,21109461,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1655,7834.400000000001,286.5,21109492,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1700,7842.6,286.6,21109515,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1705,7861.6,286.6,21109534,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1710,7886.6,286.6,21109556,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1715,7903.1,286.6,21109574,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1720,7916.8,286.6,21109594,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1725,7920.900000000001,287.6,21109622,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1730,7921.6,288.8,21109653,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1735,7922.3,292.7,21109687,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1740,7926.400000000001,293.7,21109714,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1745,7937.700000000001,293.7,21109735,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1750,7951.400000000001,293.7,21109757,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1755,7962.5,293.7,21109777,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1800,7975.1,293.7,21109793,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1805,7993.8,293.7,21109805,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1810,8010.3,293.7,21109818,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1815,8028.3,293.7,21109829,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1820,8050.6,293.7,21109836,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1825,8078.700000000001,293.7,21109841,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1830,8112.1,293.7,21109845,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1835,8146.3,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1840,8188.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1845,8228.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1850,8263.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1855,8298.9,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1900,8356.800000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1905,8424.800000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1910,8498.9,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1915,8572.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1920,8648.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1925,8725.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1930,8799.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1935,8880.800000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1940,8947.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1945,9012.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1950,9088.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1955,9161.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2000,9219.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2005,9276.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2010,9332.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2015,9389.4,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2020,9447.6,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2025,9509.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2030,9574,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2035,9632.2,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2040,9690.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2045,9749.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2050,9823.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2055,9903.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2100,9980.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2105,10053.900000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2110,10128.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2115,10197.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2120,10266.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2125,10334.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2130,10402.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2135,10471.900000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2140,10535.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2145,10600.900000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2150,10667.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2155,10727.800000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2200,10789.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2205,10850.900000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2210,10909.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2215,10971.300000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2220,11031.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2225,11099.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2230,11169.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2235,11236.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2240,11298.6,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2245,11359.7,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2250,11434.5,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2255,11489,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2300,11519.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2305,11556.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2310,11592.800000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2315,11620.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2320,11648.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2325,11676.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2330,11704.400000000001,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2335,11730.6,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2340,11757,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2345,11781.6,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2350,11812.2,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2355,11834.1,293.7,21109847,44099.000,0,0,44099.000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
Das Problem beginnt ab Uhrzeit 13:25 Uhr

Hier meine manipulierte Datei:

Code: Alles auswählen

1210,27389595.900000002,11626466.9,21101525,31422000,0,0,31422000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1215,27389596.1,11626479.5,21101710,31545000,0,0,31545000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1220,27389649.900000002,11626482.100000001,21101897,31659000,0,0,31659000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1225,27389683.400000002,11626488.700000001,21102088,31775000,0,0,31775000,0,0,0,0,0,0,0,0,0,0,0,0,0,60,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1230,27389695.8,11626498.5,21102279,31913000,0,0,31913000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1235,27389706.200000003,11626511.3,21102467,32045000,0,0,32045000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1240,27389714.700000003,11626523.9,21102653,32176000,0,0,32176000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1245,27389723.700000003,11626537.600000001,21102840,32305000,0,0,32305000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1250,27389733.8,11626547.8,21103016,32428000,0,0,32428000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1255,27389740.3,11626560.4,21103200,32556000,0,0,32556000,0,0,0,0,0,0,0,0,0,0,0,0,0,61,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1300,27389747,11626567.8,21103385,32677000,0,0,32677000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1305,27389754.200000003,11626580.5,21103568,32798000,0,0,32798000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1310,27389763,11626593.600000001,21103751,32929000,0,0,32929000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1315,27389770,11626605.200000001,21103931,33056000,0,0,33056000,0,0,0,0,0,0,0,0,0,0,0,0,0,62,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1320,27389776.700000003,11626613.8,21104110,33232000,0,0,33232000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1325,27389808.0551181,11626613.2440945,21104291,33529000,0,0,33529000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1330,27389840.1102362,11626613.488189,21104470,33827000,0,0,33827000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1335,27389872.1653543,11626613.7322835,21104648,34125000,0,0,34125000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1340,27389904.2204724,11626613.9763779,21104825,34424000,0,0,34424000,0,0,0,0,0,0,0,0,0,0,0,0,0,63,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1345,27389936.2755906,11626614.2204724,21104997,34722000,0,0,34722000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1350,27389968.3307087,11626614.4645669,21105168,35018000,0,0,35018000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1355,27390000.3858268,11626614.7086614,21105340,35313000,0,0,35313000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1400,27390032.4409449,11626614.9527559,21105509,35608000,0,0,35608000,0,0,0,0,0,0,0,0,0,0,0,0,0,65,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1405,27390064.496063,11626615.1968504,21105678,35901000,0,0,35901000,0,0,0,0,0,0,0,0,0,0,0,0,0,66,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1410,27390096.5511811,11626615.4409449,21105843,36196000,0,0,36196000,0,0,0,0,0,0,0,0,0,0,0,0,0,66,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1415,27390128.6062992,11626615.6850394,21106005,36496000,0,0,36496000,0,0,0,0,0,0,0,0,0,0,0,0,0,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1420,27390160.6614173,11626615.9291338,21106165,36794000,0,0,36794000,0,0,0,0,0,0,0,0,0,0,0,0,0,67,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1425,27390192.7165354,11626616.1732283,21106320,37092000,0,0,37092000,0,0,0,0,0,0,0,0,0,0,0,0,0,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1430,27390224.7716535,11626616.4173228,21106475,37390000,0,0,37390000,0,0,0,0,0,0,0,0,0,0,0,0,0,68,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1435,27390256.8267716,11626616.6614173,21106628,37687000,0,0,37687000,0,0,0,0,0,0,0,0,0,0,0,0,0,69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1440,27390288.8818898,11626616.9055118,21106779,37983000,0,0,37983000,0,0,0,0,0,0,0,0,0,0,0,0,0,69,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1445,27390320.9370079,11626617.1496063,21106926,38281000,0,0,38281000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1450,27390352.992126,11626617.3937008,21107070,38578000,0,0,38578000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1455,27390385.0472441,11626617.6377953,21107210,38877000,0,0,38877000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1500,27390417.1023622,11626617.8818897,21107346,39175000,0,0,39175000,0,0,0,0,0,0,0,0,0,0,0,0,0,70,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1505,27390449.1574803,11626618.1259842,21107481,39475000,0,0,39475000,0,0,0,0,0,0,0,0,0,0,0,0,0,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1510,27390481.2125984,11626618.3700787,21107613,39779000,0,0,39779000,0,0,0,0,0,0,0,0,0,0,0,0,0,72,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1515,27390513.2677165,11626618.6141732,21107742,40082000,0,0,40082000,0,0,0,0,0,0,0,0,0,0,0,0,0,73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1520,27390545.3228346,11626618.8582677,21107868,40383000,0,0,40383000,0,0,0,0,0,0,0,0,0,0,0,0,0,73,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1525,27390577.3779527,11626619.1023622,21107988,40681000,0,0,40681000,0,0,0,0,0,0,0,0,0,0,0,0,0,74,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1530,27390609.4330709,11626619.3464567,21108106,40976000,0,0,40976000,0,0,0,0,0,0,0,0,0,0,0,0,0,74,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1535,27390641.488189,11626619.5905512,21108223,41270000,0,0,41270000,0,0,0,0,0,0,0,0,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1540,27390673.5433071,11626619.8346456,21108336,41562000,0,0,41562000,0,0,0,0,0,0,0,0,0,0,0,0,0,75,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1545,27390705.5984252,11626620.0787401,21108445,41855000,0,0,41855000,0,0,0,0,0,0,0,0,0,0,0,0,0,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1550,27390737.6535433,11626620.3228346,21108551,42148000,0,0,42148000,0,0,0,0,0,0,0,0,0,0,0,0,0,76,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1555,27390769.7086614,11626620.5669291,21108654,42445000,0,0,42445000,0,0,0,0,0,0,0,0,0,0,0,0,0,77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1600,27390801.7637795,11626620.8110236,21108753,42740000,0,0,42740000,0,0,0,0,0,0,0,0,0,0,0,0,0,77,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1605,27390833.8188976,11626621.0551181,21108849,43034000,0,0,43034000,0,0,0,0,0,0,0,0,0,0,0,0,0,78,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1610,27390865.8740157,11626621.2992126,21108940,43328000,0,0,43328000,0,0,0,0,0,0,0,0,0,0,0,0,0,78,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1615,27390897.9291338,11626621.5433071,21109027,43623000,0,0,43623000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1620,27390929.984252,11626621.7874015,21109110,43918000,0,0,43918000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1625,27390962.0393701,11626622.031496,21109166,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1630,27390994.0944882,11626622.2755905,21109229,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1635,27391026.1496063,11626622.519685,21109300,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1640,27391058.2047244,11626622.7637795,21109366,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1645,27391090.2598425,11626623.007874,21109412,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1650,27391122.3149606,11626623.2519685,21109461,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1655,27391154.3700787,11626623.496063,21109492,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1700,27391186.4251968,11626623.7401574,21109515,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1705,27391218.480315,11626623.9842519,21109534,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1710,27391250.5354331,11626624.2283464,21109556,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1715,27391282.5905512,11626624.4724409,21109574,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1720,27391314.6456693,11626624.7165354,21109594,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1725,27391346.7007874,11626624.9606299,21109622,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1730,27391378.7559055,11626625.2047244,21109653,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1735,27391410.8110236,11626625.4488189,21109687,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1740,27391442.8661417,11626625.6929133,21109714,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1745,27391474.9212598,11626625.9370078,21109735,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1750,27391506.9763779,11626626.1811023,21109757,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1755,27391539.0314961,11626626.4251968,21109777,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1800,27391571.0866142,11626626.6692913,21109793,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1805,27391603.1417323,11626626.9133858,21109805,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1810,27391635.1968504,11626627.1574803,21109818,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1815,27391667.2519685,11626627.4015748,21109829,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1820,27391699.3070866,11626627.6456692,21109836,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1825,27391731.3622047,11626627.8897637,21109841,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1830,27391763.4173228,11626628.1338582,21109845,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1835,27391795.4724409,11626628.3779527,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1840,27391827.527559,11626628.6220472,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1845,27391859.5826772,11626628.8661417,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1850,27391891.6377953,11626629.1102362,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1855,27391923.6929134,11626629.3543306,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1900,27391955.7480315,11626629.5984251,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1905,27391987.8031496,11626629.8425196,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1910,27392019.8582677,11626630.0866141,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1915,27392051.9133858,11626630.3307086,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1920,27392083.9685039,11626630.5748031,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1925,27392116.023622,11626630.8188976,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1930,27392148.0787401,11626631.0629921,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1935,27392180.1338582,11626631.3070865,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1940,27392212.1889764,11626631.551181,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1945,27392244.2440945,11626631.7952755,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1950,27392276.2992126,11626632.03937,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
1955,27392308.3543307,11626632.2834645,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2000,27392340.4094488,11626632.527559,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2005,27392372.4645669,11626632.7716535,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2010,27392404.519685,11626633.015748,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2015,27392436.5748031,11626633.2598424,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2020,27392468.6299212,11626633.5039369,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2025,27392500.6850394,11626633.7480314,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2030,27392532.7401575,11626633.9921259,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2035,27392564.7952756,11626634.2362204,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2040,27392596.8503937,11626634.4803149,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2045,27392628.9055118,11626634.7244094,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2050,27392660.9606299,11626634.9685039,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2055,27392693.015748,11626635.2125983,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2100,27392725.0708661,11626635.4566928,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2105,27392757.1259842,11626635.7007873,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2110,27392789.1811023,11626635.9448818,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2115,27392821.2362205,11626636.1889763,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2120,27392853.2913386,11626636.4330708,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2125,27392885.3464567,11626636.6771653,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2130,27392917.4015748,11626636.9212598,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2135,27392949.4566929,11626637.1653542,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2140,27392981.511811,11626637.4094487,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2145,27393013.5669291,11626637.6535432,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2150,27393045.6220472,11626637.8976377,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2155,27393077.6771653,11626638.1417322,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2200,27393109.7322834,11626638.3858267,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2205,27393141.7874016,11626638.6299212,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2210,27393173.8425197,11626638.8740157,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2215,27393205.8976378,11626639.1181101,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2220,27393237.9527559,11626639.3622046,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2225,27393270.007874,11626639.6062991,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2230,27393302.0629921,11626639.8503936,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2235,27393334.1181102,11626640.0944881,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2240,27393366.1732283,11626640.3385826,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2245,27393398.2283464,11626640.5826771,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2250,27393430.2834645,11626640.8267716,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2255,27393462.3385827,11626641.070866,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2300,27393494.3937008,11626641.3149605,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2305,27393526.4488189,11626641.559055,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2310,27393558.503937,11626641.8031495,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2315,27393590.5590551,11626642.047244,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2320,27393622.6141732,11626642.2913385,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2325,27393654.6692913,11626642.535433,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2330,27393686.7244094,11626642.7795274,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2335,27393718.7795275,11626643.0236219,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2340,27393750.8346456,11626643.2677164,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2345,27393782.8897638,11626643.5118109,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2350,27393814.9448819,11626643.7559054,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
2355,27393847,11626643.9999999,21109847,44099000,0,0,44099000,0,0,0,0,0,0,0,0,0,0,0,0,0,79,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0
In den Diagrammen ist der 23.3. (warum auch immer) und der 24.3. jeweils mit einem Peak am Ende des Tages nicht leserlich.


Beim zweiten Thema habe ich selber noch ein Fehler in der manipulierten Datei gefunden und teste es erst nochmal selber.

Re: Datenübernahme von 1.9 in software2

Verfasst: Sa Jan 20, 2024 10:27 am
von sunnykleineichen
aiole hat geschrieben: So Jan 14, 2024 12:29 pm Ich würde zuerst die "Sprungstellen" im Logging rausfischen und hier zeigen.
Hhhmmm - das habe ich vor knapp eine Woche gemacht ...

Re: Datenübernahme von 1.9 in software2

Verfasst: Fr Jan 26, 2024 9:11 pm
von KaiGo
Moin,

ich habe da mal eine kurze Frage. Ich habe von 1.9 auf 2.1 umgezogen und auch die Datenübernahme gemacht. Ich hatte zwei Geräte im SmartHome 2,0 drin. Da scheinen die Daten nicht übernommen wurden zu sein. Hatte ich eigentlich im UI zugewiesen, meine ich. Kann man den Datenimport einfach nochmal wiederholen und gucken ob es dann geklappt hat? Mir ist das jetzt erst aufgefallen, als ich mir die daily_logs per Python abgeholt habe und der Punkt "sh" leer war. Für alle logs nach dem Umstieg auf 2.0 sind Daten vorhanden.

Re: Datenübernahme von 1.9 in software2

Verfasst: Fr Jan 26, 2024 10:19 pm
von warbird
Ich habe auch sporadisch Tage im Log, wo die devices nicht richtig zugeordnet sind. Steht dann nur was mit "sh". Zudem sind die Daten der Tage komplett falsch. Teilweise ist dann nur der Ladepunkt im Graph zu sehen und sonst nichts. Die Datenübernahme scheint nicht wirklich zu funktionieren. Sehr schade. Ich hoffe, dass das noch mal gefixt wird und auch, dass man jederzeit die Datenübernahme erneut starten kann. Deshalb lasse ich mein letztes Backup der 1.9 mal liegen, bis es sicher funktioniert. Ist schon seltsam, dass Tage dabei sind die passen und Tage dabei sind, die überhaupt nicht passen... Ansonsten muss ein separater Pi für die Logs ab Umstellung 2.0 zurück her.

Re: Datenübernahme von 1.9 in software2

Verfasst: So Jan 28, 2024 9:56 am
von marcd
sunnykleineichen hat geschrieben: Sa Dez 30, 2023 10:55 am Ich habe das neue tar nochmal entpackt und die Datei 'var/www/html/openWB/openwb.conf' ist ganz normal vorhanden.
Was mache ich falsch?
Schau mal, ob Du im tar-Archiv den absoluten Pfad pro Datei inkludiert hast: "./var/<...>" statt "var/<...>". Der Befehl dazu: "tar -tvf <deine_backup_datei.tar.gz".

Wenn Du das Archiv erstellst, dann gehst Du in das Verzeichnis, in dem sich dein ausgepacktes Backup befindet (also die ausgepackte Ordnerstruktur von "var"), und erstellst mit diesem Befehl ein neues Archiv:

Code: Alles auswählen

tar -czf neue_backup_datei.tar.gz var/www/html/
Klappt das?

Grüße!
Marc

Re: Datenübernahme von 1.9 in software2

Verfasst: Mi Jan 31, 2024 7:10 pm
von sunnykleineichen
sunnykleineichen hat geschrieben: Sa Jan 20, 2024 10:27 am
aiole hat geschrieben: So Jan 14, 2024 12:29 pm Ich würde zuerst die "Sprungstellen" im Logging rausfischen und hier zeigen.
Hhhmmm - das habe ich vor knapp eine Woche gemacht ...
Ich muss gestehen, dass ich bei diesem Thema inzwischen ziemlich "frustriert" bin. Ich habe mehrere Anläufe genommen und Stunden investiert, um die Daten des Exports zu verstehen, zu manipulieren und in die 2.0 zu laden. Und immer wieder kommt es zu Problemen, welche meine historischen Daten nur eingeschränkt nutzbar machen.

Auf den Hinweis, mal die Daten hier hoch zu laden, gibt es keine Reaktion mehr :-(

Ich bin bereit, weitere Stunden zu investieren - aber ohne Unterstützung von Entwicklerseite (die wissen, wie der Import sowie die neue Datenablage funktioniert) mach es leider keinen Sinn.

Re: Datenübernahme von 1.9 in software2

Verfasst: Do Feb 01, 2024 5:58 am
von warbird
Ich glaube Daten manipulieren macht hier auch keinen Sinn! Meine Daten sind teilweise so enorm falsch, als würden komplette Tage für fast alle Geräte fehlen. Habe auch mehrmals den Import laufen gelassen, immer das gleiche Ergebnis, es sind Tage komplett "zerschossen" und ich rede hier nicht von einer Hand voll, deshalb macht Manipulation auch keinen Sinn.Ich habe noch nicht geprüft, ob es immer die gleichen Tage sind, das mache ich am WE mal....
Ich weiß, Prio ist wo anders aber dass ein Import von Jahren an Logging der "alten" OpenWb nicht funktioniert, ist in meinen Augen auch nicht Prio B. Aber das ist wahrscheinlich subjektiv.

Ich hatte es in einem anderen Post schon mal erwähnt, ich vermute es sind viel mehr bzw. alle, die solche Fehler beim Import haben. Aber wenn man sich nicht mal mehrere Tage und Wochen anschaut und nur die Meldung "Import erfolgreich" liest glaubt man, dass alles richtig ist.

Ich bin auch frustriert aber habe für mich zum Übergang die Lösung, eine 1.9, auf einem alten Pi laufen und dort die alten Logs importiert. Jetzt muss ich zwei Systeme checken aber besser als fast 4 Jahre Daten verlieren....Und vielleicht wird der Import doch irgendwann laufen