{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdboden"],"not_rendered":{"charts":4,"images":1,"macros":1,"external_links":1,"defined_names":5,"comments":0,"pivot_tables":0},"unopened":[{"sheet":"Modul1","index":5,"reason":"part_missing"}],"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":"Mittelhilfstabelle","index":0,"n_rows":59,"n_cols":11,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",74,1010.1,4.8,5,null,"00",84,1011.5,10.6,8]
["01",70,1010,5.4,5,null,"01",84,1011,9.6999999999999993,8]
["02",76,1009.8,6.2,4,null,"02",84,1010.6,9.1,7]
["03",76,1009.9,6.2,5,null,"03",86,1010.8,8.5,7]
["04",74,1010,6.4,5,null,"04",88,1010.8,8.3000000000000007,6]
["05",77,1010.5,6.4,6,null,"05",88,1010.8,7.8,6]
["06",72,1011.2,7.2,6,null,"06",84,1010.9,8.6,4]
["07",68,1012.1,8.5,5,null,"07",80,1011.2,9.9,6]
["08",53,1012.4,7.3,3,null,"08",75,1011.6,10.8,6]
["09",50,1012.7,7.3,2,null,"09",69,1011.5,10.6,7]
["10",47,1013,7.9,3,null,"10",65,1010.7,11.3,7]
["11",42,1013,6.8,1,null,"11",64,1010.3,12.6,7]
["12",43,1012.5,8.5,3,null,"12",64,1009.5,14,6]
["13",42,1012.1,8.1999999999999993,2,null,"13",57,1008.9,13,4]
["14",42,1011.7,8.8000000000000007,5,null,"14",55,1008.3,13.4,3]
[15,46,1011.1,9.4,6,null,"15",61,1007.6,15.6,3]
["16",44,1011.1,9,6,null,"16",63,1006.9,15.8,3]
["17",47,1011.3,9.1999999999999993,7,null,"17",63,1006.2,15.9,3]
[18,50,1011.1,9.6999999999999993,7,null,"18",65,1005.7,15.2,5]
["19",56,1011.2,9.6999999999999993,7,null,"19",65,1005.3,14.6,3]
["20",58,1011.6,9,7,null,"20",68,1005.4,13.8,3]
["21",65,1011.4,9.4,7,null,"21",79,1004.8,13.9,3]
["22",69,1011.6,10.1,7,null,"22",84,1003.8,13.5,1]
["23",76,1011.5,10.6,7,null,"23",87,1002.8,13.2,1]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":59},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":1011.4},{"$f":"AVERAGE(D3:D26)","v":7.9999999999999991},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":5},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":73.400000000000006},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1008.6},{"$f":"AVERAGE(J3:J26)","v":12.070833333333333},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":4.9000000000000004}]
[]
[null,null,null,"2018-04-28",null,null,null,null,null,"2018-04-29"]
[]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",87,1002,12.5,0,null,"00"]
["01",89,1001,12.3,1,null,"01"]
["02",86,1000.1,11.6,2,null,"02"]
["03",83,999.4,11.2,1,null,"03"]
["04",78,998.9,10.8,3,null,"04"]
["05",77,998.5,10.8,5,null,"05"]
["06",78,998.6,11.4,4,null,"06"]
["07",80,998.3,13.5,6,null,"07"]
["08",64,998.1,12.2,6,null,"08"]
["09",50,998.4,11.8,6,null,"09"]
["10",55,1000,12.1,7,null,"10"]
["11",58,1002,10,7,null,"11"]
["12",49,1002.7,7.8,6,null,"12"]
["13",45,1003.2,7.2,7,null,"13"]
["14",46,1003.1,7.8,7,null,"14"]
["15",36,1003.8,5.3,4,null,"15"]
["16",38,1003.7,5.5,1,null,"16"]
["17",37,1004.2,4.4000000000000004,1,null,"17"]
["18",41,1004.6,5.2,1,null,"18"]
["19",46,1005,5.0999999999999996,1,null,"19"]
["20",56,1005.3,5.4,1,null,"20"]
["21",60,1005.9,5.6,1,null,"21"]
["22",68,1006.3,5.7,2,null,"22"]
["23",75,1006.6,5.7,4,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":61.8},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":1002.1},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":8.8000000000000007},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":3.5},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,"2018-04-30",null,null,null,null,null,"2018-05-01"]

{"sheet":"Kurztabelle","index":1,"n_rows":112,"n_cols":45,"rows_kept":112,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","April",null,null,null,null,"Jahr:",null,null,"2018"]
[]
["Dat.","TTT","TxTx","TnTn","Tg","Umin.","UU","NN","RRRR","Art",null,"sss","PPPP","eee","fff",null,null,"Tage mit",null,null,null,"fk","Summe "]
[null,null,null,null,null,null,null,null,null,"*",null,null,null,null,"Km/h","SS","Art ( D )","RR","Ge","Bf6","Bf8","Km/h","Gewitter"]
["01.",2.6,4.5999999999999996,1.2,1.1000000000000001,71,80,7.8,0.2,"l",null,".",1003.9,-0.5,13,null,null,1,null,1,null,45,null,null,null,null,"max >=30,0°C","max >=25,0°C","max  <0,0°C",null,"RR >=0,1 mm","RR >=1,0 mm","RR >=3,0 mm","RR >=10,0 mm","RR >=20,0 mm",null,null,null,null,null,null,null,null,null,"Hellmann"]
["02.",6.3,12.4,0.6,-1.7,39,64,5.5,0.1,"l",null,4.8,1011.3,-0.4,6,null,null,1,null,null,null,34,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":0},{"$f":"COUNTIF(C6:C15,\"<0\")","v":0},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":5},{"$f":"COUNTIF(I6:I15,\">=1\")","v":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,"200 cm3"]
["03.",13.2,19.899999999999999,7,6.1,43,57,6.7,0.3,"l",null,2.2999999999999998,1006.2,4.5999999999999996,5,null,null,1,null,null,null,26,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":1},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,11.4]
["04.",15.2,22.5,8.6999999999999993,5.6,34,58,6,2.2000000000000002,"l",null,6.1,1004.6,6.8,6,null,null,1,null,null,null,29,null,null,null,null,{"$f":"COUNTIF(C30:C39,\">=30\")","v":0},{"$f":"COUNTIF(C30:C39,\">=25\")","v":0},{"$f":"COUNTIF(C30:C39,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I39,\">=0,1\")","v":4},{"$f":"COUNTIF(I30:I39,\">=1\")","v":3},{"$f":"COUNTIF(I30:I39,\">=3\")","v":1},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",10.9,16.600000000000001,4.8,4.4000000000000004,46,66,5.0999999999999996,0.7,"l",null,4.7,1009.6,4.8,12,null,null,1,null,1,null,53]
["06.",6.4,12,0.9,-0.6,29,58,1.8,".",null,null,10.199999999999999,1024.0999999999999,-2,5,null,null,null,null,1,null,40,null,null,null,null,"min  <0,0°C","min <0-10,0°C",null,null,"rel.Lf. 14h >=70%",null,"rel.Lf. 14h <=40%"]
["07.",11.9,19.7,2.7,-1.1000000000000001,31,50,1.3,".",null,null,10.3,1018.6,1.4,14,null,null,null,null,1,null,52,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":0},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":1},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":6}]
["08.",11.2,15.2,7.7,5.6,58,68,1.3,".",null,null,7.6,1012.1,5.7,10,null,null,null,null,1,null,42,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":0},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":1},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":5}]
["09.",12.7,22.9,3.1,0,32,67,2,".",null,null,9.3000000000000007,1006.9,5.8,3,null,null,null,null,null,null,19,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":0},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":3}]
["10.",15.5,21.9,9.1,4.4000000000000004,38,57,2,".",null,null,10.3,1004.6,6.7,10,null,null,null,null,1,null,40]
["Su",{"$f":"SUM(B6:B15)","v":105.9},{"$f":"SUM(C6:C15)","v":167.70000000000002},{"$f":"SUM(D6:D15)","v":45.800000000000004},{"$f":"SUM(E6:E15)","v":23.799999999999997},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":3.5},"XX",null,{"$f":"SUM(L6:L15)","v":65.599999999999994},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":5},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":6},{"$f":"SUM(U6:U15)","v":0},"XXX",null,null,null,null,"ohne Sonne","Son. 0,1-0,9","Son.  >=10,0",null,"Sch. >=1 cm","Sch. >=3 cm","Sch. >=10 cm"]
["Mi",{"$f":"AVERAGE(B6:B15)","v":10.59},{"$f":"AVERAGE(C6:C15)","v":16.770000000000003},4.58,2.38,42.1,62.5,3.9499999999999993,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1010.1899999999999},{"$f":"AVERAGE(N6:N15)","v":3.2900000000000005},{"$f":"AVERAGE(O6:O15)","v":8.4},{"$f":"AVERAGE(P6:P15)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":38},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":1},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":3},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",14.3,20.9,9.1,5.6,44,67,3.7,".",null,null,4.2,1007.2,8,5,null,null,null,null,null,null,26,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":1},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":3},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",16.8,23.6,9.6,5,40,60,5.2,".",null,null,3.9,1005.2,8.6999999999999993,14,null,null,null,null,1,null,52,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":0},{"$f":"COUNTIF(L30:L39,\">=10\")","v":4},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",14.7,19.7,11.2,8.9,59,73,7.1,5.3,"l",null,1,1005.9,9.9,10,null,null,1,1,1,null,39,2]
["14.",14.6,19.899999999999999,9.8000000000000007,6.7,40,64,5.4,".",null,null,5.2,1017.9,7.5,9,null,null,null,null,1,null,44,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",14.4,21.1,7.8,5.6,50,69,5.9,3.7,"l",null,3.8,1013.8,8.4,4,null,null,1,null,null,null,23,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":19.399999999999999},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":26.9},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-1.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":13}]
["16.",12.1,13.3,11,9.4,71,92,8,13,"l",null,".",1013.2,10.9,3,null,null,1,null,null,null,23,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",12.5,16.8,9.6,6.7,60,84,4.4000000000000004,".",null,null,3.9,1025.7,9.8000000000000007,4,null,null,null,null,null,null,23,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":2.6},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":0.6},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":28},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",13.9,22.1,4.9000000000000004,2.2000000000000002,28,67,1,".",null,null,11.1,1032.3,6.9,2,null,null,null,null,null,null,15]
["19.",15.9,23.4,7.8,5.6,38,69,1.7,".",null,null,11.1,1030.7,9.6,2,null,null,null,null,null,null,13]
["20.",19.399999999999999,26.9,9.9,7.2,35,63,2.9,".",null,null,11.2,1024.2,11.3,7,null,null,null,null,null,null,29]
["Su",{"$f":"SUM(B18:B27)","v":148.6},{"$f":"SUM(C18:C27)","v":207.7},{"$f":"SUM(D18:D27)","v":90.7},{"$f":"SUM(E18:E27)","v":62.900000000000006},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":22},"XX",null,{"$f":"SUM(L18:L27)","v":55.400000000000006},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":3},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":3},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":14.86},{"$f":"AVERAGE(C18:C27)","v":20.77},9.07,6.2900000000000009,46.5,70.8,4.5299999999999994,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1017.61},{"$f":"AVERAGE(N18:N27)","v":9.1},{"$f":"AVERAGE(O18:O27)","v":6},{"$f":"AVERAGE(P18:P27)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":28.7}]
["21.",18,23.8,11.6,8.9,42,65,1.9,".",null,null,11.2,1018.7,11,4,null,null,null,null,null,null,24]
["22.",16.8,24.2,8.1,6.1,43,67,3,".",null,null,11.4,1015.6,10.199999999999999,2,null,null,null,null,null,null,24]
["23.",16.899999999999999,23.6,13,11.1,53,75,7.1,5.8,"l",null,2.8,1012.5,12.5,5,null,null,1,1,null,null,35,3]
["24.",14.3,19.600000000000001,8.6,6.7,47,73,6,".",null,null,6.2,1015.2,9.1999999999999993,5,null,null,null,null,1,null,40]
["25.",14.8,21.6,9.3000000000000007,7.2,43,69,5.9,2,"l",null,4.7,1009.9,8.8000000000000007,10,null,null,1,null,1,null,56]
["26.",10.199999999999999,14.6,5.3,3.9,46,74,5.2,0.7,"l∆",null,4.4000000000000004,1014.6,5.7,8,null,null,1,1,1,1,63]
["27.",10.8,17.399999999999999,3.8,2.2000000000000002,35,67,5.9,".",null,null,9.5,1015.3,5.8,4,null,null,null,null,null,null,31]
["28.",16.600000000000001,22.7,9.1999999999999993,6.7,37,59,5,".",null,null,11.3,1011.4,8,4,null,null,null,null,null,null,31]
["29.",17.2,24.1,9.6,8.3000000000000007,55,73,4.9000000000000004,".",null,null,11.2,1008.6,12.1,3,null,null,null,null,null,null,18]
["30.",16.7,23.8,9.9,8.3000000000000007,33,62,3.5,1.8,"l",null,3.7,1002.1,8.8000000000000007,6,null,null,1,null,1,null,45]
["Su",{"$f":"SUM(B30:B39)","v":152.29999999999998},{"$f":"SUM(C30:C39)","v":215.39999999999998},{"$f":"SUM(D30:D39)","v":88.4},{"$f":"SUM(E30:E39)","v":69.400000000000006},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":10.3},"XX",null,{"$f":"SUM(L30:L39)","v":76.400000000000006},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":4},{"$f":"SUM(S30:S39)","v":2},{"$f":"SUM(T30:T39)","v":4},{"$f":"SUM(U30:U39)","v":1},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":15.229999999999999},21.54,8.84,6.94,43.4,68.400000000000006,4.84,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1012.39},{"$f":"AVERAGE(N30:N39)","v":9.2099999999999991},{"$f":"AVERAGE(O30:O39)","v":5.0999999999999996},{"$f":"AVERAGE(P30:P39)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":36.700000000000003}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":406.79999999999995},{"$f":"SUM(C16+C28+C40)","v":590.79999999999995},{"$f":"SUM(D16+D28+D40)","v":224.9},{"$f":"SUM(E16+E28+E40)","v":156.10000000000002},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I40)","v":35.799999999999997},"XX",null,{"$f":"SUM(L16+L28+L40)","v":197.4},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R40)","v":12},{"$f":"SUM(S16+S28+S40)","v":3},{"$f":"SUM(T16+T28+T40)","v":13},{"$f":"SUM(U16+U28+U40)","v":1},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":13.56},19.693333333333339,7.496666666666667,5.2033333333333331,44,67.233333333333334,4.4400000000000004,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1013.3966666666666},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":7.2},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":6.5},{"$f":"AVERAGE(P17,P29,P41)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":34.466666666666669},6]
[]
[null,"Norm","% v N.-","Abw.","Zahl der Tage",null,null,null,null,null,null,"Niederschlag mm",null,null,null,"Sonnensch.-dauer Std"]
[null,"wert","wert","K","Max.d.Lufttemp.°C",null,null,null,null,null,null,">/=  0,1",null,null,{"$f":"SUM(AE7:AE9)","v":12},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":2}]
["TTT",9,"XXXX",{"$f":"SUM(B43-B47)","v":4.5600000000000005},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":7},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":0}]
["RRR",42,{"$f":"SUM(I42*100/B48)","v":85.238095238095227},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":1},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":4},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":10}]
["sss",170,{"$f":"SUM(L42*100/B49)","v":116.11764705882354},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":1},"Schneedecke cm"]
["astr.",null,null,"XXXX","Polartag",null,null,null,0,null,null,">/=  20,0",null,null,{"$f":"SUM(AI7:AI9)","v":0},">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":0}]
["mgl.",414,{"$f":"SUM(L42*100/B51)","v":47.681159420289852},"XXXX","Min.d.Lufttemp.°C",null,null,null,null,null,null,"Rel. Luftfeuchte 14 Uhr",null,null,null,">/=   3",null,null,null,null,null,{"$f":"SUM(AF17:AF19)","v":0}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":0},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":2},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":0}]
[null,null,null,null,"Tropennacht",null,null,null,0,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":14}]
[]
[]
[null,null,null,null,"Unter \"Tage mit\" sind die Angaben Bft 6 & Bft 8 nicht 10 min. - Mittel sonder 2,5 s - Werte."]
[null,null,null,null,"Wenn ein Wert auch mit einem 10 min. - Wert erreicht wird, erfolgt eine rote Markierung."]
[null,null,null,null,"Dies gilt rückwirkend bis November 2012."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,null,null,null,"Tage mit Bft 6 /8 eigentlich in 10 min. - Mittel"]

{"sheet":"Sichtst.","index":2,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","April",null,null,null,"Jahr:",2018]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.",null,null,null,1,1,null,null,null,null,null,null,null,{"$f":"IF(ISNUMBER(B9),B9*24,\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<1,1,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<8,2,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N9),IF(N9<24,3,\" \"),\" \")","v":" "},{"$f":"MIN(O9:Q9)","v":0}]
["02.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["03.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["04.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["05.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["07.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["08.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["09.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["11.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["12.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["13.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["14.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["15.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["16.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["17.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["18.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["19.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["20.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["21.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["22.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["23.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["24.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["25.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["26.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["27.",null,null,null,null,1,1]
["28.",null,null,null,null,1,1]
["29.",null,null,null,null,1,1]
["30.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["Su.",{"$f":"SUM(B9:B38)","v":"00:00:00"},0,3,8,30,16,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","v":16}]

{"sheet":"Monatsdiagramm","index":3,"n_rows":68,"n_cols":9,"rows_kept":68,"cut":false,"hidden":false,"merged":[[2,0,2,1],[5,4,5,5],[7,4,7,5]]}
["Klimadiagramm",null,"Wetterstation Köttewitz",null,null,null,null,null,"(214 m ü. NHN)"]
[]
["April 2018"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":26.9},"am","2018-04-20"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":13.56},{"$f":"Kurztabelle!B47","v":9},{"$f":"C7-D7","v":4.5600000000000005},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":0.6},"am","2018-04-02"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":35.799999999999997},{"$f":"Kurztabelle!B48","v":42},{"$f":"100/D9*C9","v":85.238095238095227},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":197.4},{"$f":"Kurztabelle!B49","v":170},{"$f":"100/D10*C10","v":116.11764705882354},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die Wetterstation kann, durch geographische Hindernisse, nicht die maximal mögliche Sonnenscheindauer aufzeichnen. Es gilt ein Übergangsprozentsatz von:"]
["Dez 30 %; Okt/Nov & Jan/Feb 40 %; Mär & Sep 65 %; Apr & Aug 80 %; Mai - Jul 90 %. Durch Baumfällarbeiten seit Orkan Herwart (Okt 2017) Okt & Feb 50 %."]
["Diese Werte entsprechend annähernd 100 % (Normalwert Köttewitz). Nach 10 Jahren erfolgt die Umstellung des Prozentsatzes nach der örtlichen Aufzeichnung."]

{"sheet":"Daten für Diagr.","index":4,"n_rows":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2018-04-01",2.6,4.5999999999999996,1.2,0.2,null,null,1003.9,6.7,"U","(T Franziska)"]
["2018-04-02",6.3,12.4,0.6,0.1,null,4.8,1011.3,6.85,"SWz","T Gabi"]
["2018-04-03",13.2,19.899999999999999,7,0.3,null,2.2999999999999998,1006.2,7]
["2018-04-04",15.2,22.5,8.6999999999999993,2.2000000000000002,null,6.1,1004.6,7.15,null,"T Hypatia","Von 21:27 Uhr - 21:41 Uhr mäßiges Gewitter mit Regen (WW 95). Von 21:07 Uhr - 21:26 Uhr; 21:42 Uhr - 21:55 Uhr leichtes Gewitter mit Regen (WW 95). Von 21:56 Uhr - 22:14 Uhr leichter Regenschauer (WW 80). Von 20:47 Uhr - 21:06 Uhr Ferngewitter (WW 17)."]
["2018-04-05",10.9,16.600000000000001,4.8,0.7,null,4.7,1009.6,7.3,"Wz",null,"Von 16:00 Uhr - 16:29 Uhr leichter Regenschauer (WW 80)."]
["2018-04-06",6.4,12,0.9,null,null,10.199999999999999,1024.0999999999999,7.45,"Sa","H Leo"]
["2018-04-07",11.9,19.7,2.7,null,null,10.3,1018.6,7.6]
["2018-04-08",11.2,15.2,7.7,null,null,7.6,1012.1,7.75,"Sz","T Joi"]
["2018-04-09",12.7,22.9,3.1,null,null,9.3000000000000007,1006.9,7.9,"SEz"]
["2018-04-10",15.5,21.9,9.1,null,null,10.3,1004.6,8.0500000000000007]
["2018-04-11",14.3,20.9,9.1,null,null,4.3,1007.2,8.1999999999999904]
["2018-04-12",16.8,23.6,9.6,null,null,3.9,1005.2,8.3499999999999908]
["2018-04-13",14.7,19.7,11.2,5.3,null,1,1005.9,8.4999999999999893,null,null,"Von 15:48 Uhr - 17:02 Uhr; 18:34 Uhr - 18:54 Uhr leichtes Gewitter mit Regen (WW 95). Außerdem WW 80."]
["2018-04-14",14.6,19.899999999999999,9.8000000000000007,null,null,5.2,1017.9,8.6499999999999897]
["2018-04-15",14.4,21.1,7.8,3.7,null,3.8,1013.8,8.7999999999999901,"Sz","T Kathrin"]
["2018-04-16",12.1,13.3,11,13,null,null,1013.2,8.9499999999999904]
["2018-04-17",12.5,16.8,9.6,null,null,3.9,1025.7,9.0999999999999908,"HM","H Norbert"]
["2018-04-18",13.9,22.1,4.9000000000000004,null,null,11.1,1032.3,9.2499999999999893]
["2018-04-19",15.9,23.4,7.8,null,null,11.1,1030.7,9.3999999999999897]
["2018-04-20",19.399999999999999,26.9,9.9,null,null,11.2,1024.2,9.5499999999999901]
["2018-04-21",18,23.8,11.6,null,null,11.2,1018.7,9.6999999999999904]
["2018-04-22",16.8,24.2,8.1,null,null,11.4,1015.6,9.8499999999999908,"Wa","H Onni"]
["2018-04-23",16.899999999999999,23.6,13,5.8,null,2.8,1012.5,9.9999999999999893,null,null,"Gegen 16:00 Uhr; 16:30 Uhr; 20:00 Uhr leichtes Gewitter mit Regen (WW 95)."]
["2018-04-24",14.3,19.600000000000001,8.6,null,null,6.2,1015.2,10.15]
["2018-04-25",14.8,21.6,9.3000000000000007,2,null,4.7,1009.9,10.3,"Wz","T Ottila"]
["2018-04-26",10.199999999999999,14.6,5.3,0.7,null,4.4000000000000004,1014.6,10.45,null,null,"Gegen 14:20 Uhr leichtes Gewitter mit Graupel (WW 96). Mehrmals (WW 80)."]
["2018-04-27",10.8,17.399999999999999,3.8,null,null,9.5,1015.3,10.6,"TrW","T Pearl"]
["2018-04-28",16.600000000000001,22.7,9.1999999999999993,null,null,11.3,1011.4,10.75,null,"T Quitta"]
["2018-04-29",17.2,24.1,9.6,null,null,11.2,1008.6,10.9,null,null,"Leicht schwül."]
["2018-04-30",16.7,23.8,9.9,1.8,null,3.7,1002.1,11.05]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":13.56},{"$f":"AVERAGE(C2:C31)","v":19.693333333333339},{"$f":"AVERAGE(D2:D31)","v":7.496666666666667},"-",null,{"$f":"AVERAGE(G2:G31)","v":7.0535714285714279},{"$f":"AVERAGE(H2:H31)","v":1013.3966666666666},{"$f":"AVERAGE(I2:I31)","v":8.8749999999999964}]
["Mittel",9,null,null,42,"-",170,1014.6]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[1]
[2]
[3]
[4]
[5]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]

{"sheet":"Erdboden","index":6,"n_rows":40,"n_cols":11,"rows_kept":40,"cut":false,"hidden":false,"merged":[[4,9,5,9],[4,10,5,10],[4,5,5,5],[4,6,5,6],[4,7,5,7],[4,8,5,8]]}
[null,null,null,null,null,"Erdbodenstatistik "]
[]
[null,"Wetterstation: ","Köttewitz",null,"Monat:","April",null,null,null,"Jahr:",2018]
[]
["Dat.","Temperatur","Temperatur","Temperatur","Temperatur","NN","0 °C - Grenze","5 °C - Grenze","10 °C - Grenze","15 °C - Grenze","20 °C - Grenze"]
[null,"5 cm","-10 cm","- 20 cm","- 35 cm"]
["01.","1,7 °C/7,8 °C/1,7 °C","4,4 °C/5,6 °C/5,0 °C","5,0 °C/5,0 °C/5,0 °C","5,6 °C/5,0 °C/5,0 °C","t","> 50 cm","< 10 > 50 cm"]
["02.","1,7 °C/19,4 °C/1,7 °C","3,3 °C/7,8 °C/6,7 °C","3,9 °C/6,1 °C/6,7 °C","5,0 °C/5,0 °C/5,6 °C","n","> 50 cm","> 50 cm"]
["03.","6,7 °C/18,9 °C/11,1 °C","6,1 °C/11,1 °C/9,4 °C","6,1 °C/8,3 °C/8,9 °C","5,6 °C/5,6 °C/6,7 °C","t","> 50 cm","> 50 cm","5 cm"]
["04.","9,4 °C/26,7 °C/13,3 °C","7,8 °C/13,3 °C/11,1 °C","7,8 °C/10,6 °C/10,6 °C","6,7 °C/7,2 °C/7,8 °C","n","> 50 cm","> 50 cm","19 cm"]
["05.","9,4 °C/22,8 °C/5,6 °C","8,3 °C/12,2 °C/10,0 °C","8,9 °C/10,6 °C/10,0 °C","8,3 °C/8,3 °C/8,3 °C","n","> 50 cm","> 50 cm","15 cm"]
["06.","2,8 °C/18,9 °C/1,7 °C","6,1 °C/11,7 °C/8,9 °C","7,2 °C/9,4 °C/9,4 °C","8,3 °C/7,8 °C/8,3 °C","n","> 50 cm","> 50 cm"]
["07.","6,7 °C/26,1 °C/12,2 °C","5,6 °C/11,7 °C/11,1 °C","6,7 °C/9,4 °C/10,6 °C","7,8 °C/7,8 °C/8,3 °C","h","> 50 cm","> 50 cm","10 cm"]
["08.","10,6 °C/19,4 °C/3,9 °C","8,3 °C/11,7 °C/10,0 °C","8,3 °C/10,6 °C/10,6 °C","8,3 °C/8,3 °C/8,9 °C","h","> 50 cm","> 50 cm","< 10;20 cm >"]
["09.","7,8 °C/27,2 °C/10,0 °C","6,7 °C/13,9 °C/12,2 °C","7,8 °C/11,1 °C/11,7 °C","8,3 °C/8,3 °C/8,9 °C","n","> 50 cm","> 50 cm","25 cm"]
["10.","15,6 °C/25,0 °C/9,4 °C","9,4 °C/15,0 °C/12,8 °C","9,4 °C/12,2 °C/12,2 °C","8,9 °C/8,9 °C/9,4 °C","n","> 50 cm","> 50 cm","30 cm"]
["11.","10,6 °C/21,7 °C/8,3 °C","10,0 °C/14,4 °C/12,8 °C","10,0 °C/12,8 °C/12,2 °C","10,0 °C/10,0 °C/10,6 °C","n","> 50 cm","> 50 cm","38 cm"]
["12.","12,2 °C/24,4 °C/17,2 °C","10,0 °C/15,0 °C/13,9 °C","10,6 °C/12,8 °C/13,3 °C","10,0 °C/10,0 °C/10,6 °C","n","> 50 cm","> 50 cm","38 cm"]
["13.","15,0 °C/16,1 °C/10,6 °C","11,7 °C/14,4 °C/12,8 °C","11,7 °C/12,8 °C/12,8 °C","10,6 °C/10,6 °C/11,1 °C","t","> 50 cm","> 50 cm","43 cm"]
["14.","10,0 °C/20,6 °C/9,4 °C","11,1 °C/15,6 °C/13,9 °C","11,1 °C/13,3 °C/13,9 °C","11,1 °C/11,1 °C/11,7 °C","n","> 50 cm","> 50 cm","48 cm"]
["15.","14,4 °C/27,2 °C/11,1 °C","11,1 °C/15,0 °C/14,4 °C","11,1 °C/13,3 °C/13,9 °C","11,1 °C/11,1 °C/11,7 °C","t","> 50 cm","> 50 cm","48 cm"]
["16.","11,7 °C/13,3 °C/11,1 °C","12,8 °C/12,8 °C/12,8 °C","12,8 °C/12,8 °C/12,8 °C","11,7 °C/11,7 °C/11,7 °C","n","> 50 cm","> 50 cm","> 50 cm"]
["17.","12,2 °C/25,6 °C/6,7 °C","11,7 °C/15,6 °C/13,9 °C","11,7 °C/13,3 °C/13,9 °C","11,1 °C/11,1 °C/11,7 °C","n","> 50 cm","> 50 cm","47 cm"]
["18.","15,0 °C/28,9 °C/11,1 °C","10,0 °C/16,7 °C/15,0 °C","11,1 °C/13,9 °C/14,4 °C","11,7 °C/11,7 °C/12,2 °C","h","> 50 cm","> 50 cm","> 50 cm","5 cm"]
["19.","17,2 °C/32,2 °C/13,3 °C","11,1 °C/18,3 °C/16,1 °C","11,7 °C/15,6 °C/16,1 °C","12,2 °C/12,2 °C/12,8 °C","n","> 50 cm","> 50 cm","> 50 cm","15 cm"]
["20.","18,9 °C/33,9 °C/16,7 °C","12,2 °C/20,0 °C/17,8 °C","12,8 °C/16,7 °C/17,2 °C","12,8 °C/12,8 °C/13,9 °C","n","> 50 cm","> 50 cm","> 50 cm","26 cm"]
["21.","20,6 °C/30,6 °C/13,9 °C","13,9 °C/20,6 °C/17,8 °C","13,9 °C/17,8 °C/17,8 °C","13,9 °C/13,9 °C/14,4 °C","n","> 50 cm","> 50 cm","> 50 cm","30 cm"]
["22.","18,9 °C/31,7 °C/13,9 °C","13,3 °C/20,6 °C/18,3 °C","13,9 °C/17,2 °C/17,8 °C","13,9 °C/13,9 °C/15,0 °C","n","> 50 cm","> 50 cm","> 50 cm","46 cm"]
["23.","18,3 °C/17,2 °C/13,3 °C","15,0 °C/18,9 °C/17,2 °C","15,0 °C/17,2 °C/16,7 °C","14,4 °C/14,4 °C/15,0 °C","t","> 50 cm","> 50 cm","> 50 cm","47 cm"]
["24.","15,6 °C/21,7 °C/11,1 °C","13,3 °C/18,9 °C/16,7 °C","13,9 °C/16,7 °C/16,7 °C","14,4 °C/14,4 °C/14,4 °C","n","> 50 cm","> 50 cm","> 50 cm","25 cm"]
["25.","22,8 °C/23,9 °C/8,9 °C","13,3 °C/18,9 °C/15,6 °C","13,9 °C/16,7 °C/16,1 °C","13,9 °C/13,9 °C/14,4 °C","n","> 50 cm","> 50 cm","> 50 cm","27 cm"]
["26.","8,3 °C/16,7 °C/5,6 °C","12,8 °C/16,7 °C/13,9 °C","13,3 °C/15,0 °C/14,4 °C","13,9 °C/13,9 °C/13,9 °C","n","> 50 cm","> 50 cm","> 50 cm"]
["27.","9,4 °C/22,8 °C/8,3 °C","10,6 °C/17,2 °C/15,0 °C","11,7 °C/15,0 °C/15,0 °C","13,3 °C/12,8 °C/13,3 °C","n","> 50 cm","> 50 cm","> 50 cm"]
["28.","17,2 °C/30,6 °C/14,4 °C","12,2 °C/20,0 °C/17,8 °C","12,8 °C/16,7 °C/17,2 °C","13,3 °C/13,3 °C/14,4 °C","n","> 50 cm","> 50 cm","> 50 cm","27 cm"]
["29.","19,4 °C/30,6 °C/15,0 °C","13,9 °C/20,6 °C/18,9 °C","14,4 °C/17,8 °C/18,3 °C","14,4 °C/14,4 °C/15,0 °C","n","> 50 cm","> 50 cm","> 50 cm","33 cm"]
["30.","21,7 °C/21,1 °C/10,0 °C","15,0 °C/18,9 °C/16,7 °C","15,0 °C/17,2 °C/16,7 °C","15,0 °C/15,0 °C/15,0 °C","n","> 50 cm","> 50 cm","> 50 cm","35 cm"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]