{"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",76,1027.0999999999999,5.6,8,null,"00",83,1017.9,5.6,8]
["01",78,1026.9000000000001,5.7,8,null,"01",87,1020.6,4.0999999999999996,8]
["02",78,1026.9000000000001,5.6,8,null,"02",83,1022.2,2.9,8]
["03",78,1026.5999999999999,5.6,8,null,"03",86,1023.1,1.7,7]
["04",78,1026.0999999999999,5.6,8,null,"04",78,1024.4000000000001,0.8,7]
["05",79,1025.9000000000001,5.7,8,null,"05",76,1025,-0.1,7]
["06",79,1025.5,5.6,8,null,"06",75,1025.5999999999999,0.2,6]
["07",80,1025.2,5.2,7,null,"07",77,1025.8,0.3,6]
["08",81,1025.0999999999999,4.9000000000000004,7,null,"08",80,1026.3,0.6,7]
["09",80,1024.7,5.0999999999999996,7,null,"09",78,1027.2,0.3,5]
["10",82,1024.5999999999999,5.6,7,null,"10",73,1027.9000000000001,0,7]
["11",69,1024.5999999999999,5.6,7,null,"11",71,1028.3,0.1,7]
["12",70,1023.9,5,7,null,"12",70,1028.0999999999999,0.1,7]
["13",71,1023,5.0999999999999996,7,null,"13",65,1027.5,-0.1,7]
["14",70,1022.2,5.0999999999999996,7,null,"14",64,1027.7,-0.8,7]
[15,70,1021.1,5.2,7,null,"15",63,1027.2,-0.5,5]
["16",70,1020.3,5.0999999999999996,7,null,"16",64,1026.9000000000001,-0.8,7]
["17",71,1019.9,4.9000000000000004,8,null,"17",67,1027.2,-1.1000000000000001,6]
[18,71,1019.6,4.7,7,null,"18",67,1027,-1.2,2]
["19",71,1019.3,4.5999999999999996,7,null,"19",73,1026.8,-1.5,1]
["20",71,1018.7,4.4000000000000004,7,null,"20",76,1026.9000000000001,-1.5,4]
["21",69,1017.9,4.0999999999999996,7,null,"21",79,1026.3,-1.9,4]
["22",71,1017.7,4.3,7,null,"22",80,1026,-2,5]
["23",79,1017.6,5.4,8,null,"23",83,1025.3,-2.2999999999999998,4]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":74.7},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":1022.9},{"$f":"AVERAGE(D3:D26)","v":5.1541666666666668},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":7.4},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":74.900000000000006},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1025.7},{"$f":"AVERAGE(J3:J26)","v":0.12083333333333346},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":5.9}]
[]
[null,null,null,"2018-01-29",null,null,null,null,null,"2018-01-30"]
[]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",84,1024.8,-2.2000000000000002,4,null,"00",79,1000.5,3.9,8]
["01",85,1024.2,-2.2999999999999998,4,null,"01",76,1000.4,3.4,8]
["02",87,1023.2,-1.9,4,null,"02",76,1000.1,3.2,8]
["03",84,1022.4,-1.3,4,null,"03",76,999.8,3.1,8]
["04",80,1021.1,-0.8,6,null,"04",76,999.5,2.9,8]
["05",77,1019.7,-0.7,7,null,"05",77,999.6,2.6,8]
["06",76,1018.8,-0.2,7,null,"06",83,1000.2,2.5,8]
["07",74,1017.7,0,7,null,"07",87,1001.2,1.5,8]
["08",75,1016.8,0.1,8,null,"08"]
["09",78,1015.5,0.3,7,null,"09"]
["10",77,1014.2,1,7,null,"10"]
["11",73,1011.8,2.4,8,null,"11"]
["12",71,1010.7,3.2,8,null,"12"]
["13",70,1013.1,4,8,null,"13"]
["14",75,1008.8,4.5,8,null,"14"]
["15",73,1007.9,4.0999999999999996,8,null,"15"]
["16",80,1007.3,4.9000000000000004,8,null,"16"]
["17",82,1005.7,4.4000000000000004,8,null,"17"]
["18",79,1004.9,4.5,8,null,"18"]
["19",80,1004.1,4.3,8,null,"19"]
["20",79,1003.3,4.2,8,null,"20"]
["21",82,1002.3,4.5,8,null,"21"]
["22",83,1001.6,4.5,8,null,"22"]
["23",84,1000.9,4.3,8,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":78.7},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":1012.5},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1.9},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":7},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":78.8},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1000.2},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":2.9},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":8}]
[]
[null,null,null,"2018-01-31",null,null,null,null,null,"2018-02-01"]

{"sheet":"Kurztabelle","index":1,"n_rows":113,"n_cols":45,"rows_kept":113,"cut":false,"hidden":false,"merged":[[1,12,1,13]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","Januar",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.",8.1999999999999993,10.9,3.8,-0.6,59,67,5.5,0.1,"l",null,1,1004.2,2.5,11,0,null,1,null,1,null,48,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.",4.5,6.2,2.1,-1.7,69,80,7.3,2.1,"l",null,".",1007.5,1.5,11,0,null,1,null,1,null,42,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":8},{"$f":"COUNTIF(I6:I15,\">=1\")","v":4},{"$f":"COUNTIF(I6:I15,\">=3\")","v":2},{"$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.",4.9000000000000004,9.3000000000000007,1.6,-2.8,69,79,6.5,4.7,"lr",null,0.2,995.8,1.4,19,0,null,1,null,1,1,72,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":0},{"$f":"COUNTIF(C18:C27,\"<0\")","v":0},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":6},{"$f":"COUNTIF(I18:I27,\">=1\")","v":2},{"$f":"COUNTIF(I18:I27,\">=3\")","v":1},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,11.4]
["04.",6.7,7.8,5.6,3.3,65,72,7.3,0.4,"l",null,".",996.8,2,18,0,null,1,null,1,null,53,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":0},{"$f":"COUNTIF(C30:C40,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":8},{"$f":"COUNTIF(I30:I40,\">=1\")","v":5},{"$f":"COUNTIF(I30:I40,\">=3\")","v":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",8.1,10.4,6,2.2000000000000002,65,74,6.1,0.3,"l",null,".",998.9,3.7,10,0,null,1,null,1,null,50]
["06.",7.3,8.9,5.9,3.3,76,84,7.4,6.3,"l",null,0.3,1008.9,4.7,2,0,null,1,null,null,null,21,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.",3,5.9,1.6,1.7,89,92,8,2.2999999999999998,"l",null,".",1024.5999999999999,2,4,0,null,1,null,null,null,21,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":1},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":5},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",1.3,3.2,-0.2,-1.7,86,90,7.1,".",null,null,".",1030.2,-0.1,4,0,null,null,null,null,null,19,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":6},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":7},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",7.3,9.8000000000000007,1.7,1.7,74,81,7.4,0.2,"l",null,".",1018.9,4.0999999999999996,15,0,null,1,null,1,null,47,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":3},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":8},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",5.2,8.4,1.1000000000000001,-1.7,82,88,4.7,".",null,null,0.4,1013.9,3.4,4,0,null,null,null,null,null,23]
["Su",{"$f":"SUM(B6:B15)","v":56.499999999999993},{"$f":"SUM(C6:C15)","v":80.800000000000011},{"$f":"SUM(D6:D15)","v":29.200000000000003},{"$f":"SUM(E6:E15)","v":3.7},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":16.399999999999999},"XX",null,{"$f":"SUM(L6:L15)","v":1.9},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":8},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":6},{"$f":"SUM(U6:U15)","v":1},"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":5.6499999999999995},{"$f":"AVERAGE(C6:C15)","v":8.0800000000000018},2.9200000000000004,0.37,73.400000000000006,80.7,6.7299999999999995,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1009.9699999999999},{"$f":"AVERAGE(N6:N15)","v":2.5199999999999996},{"$f":"AVERAGE(O6:O15)","v":9.8000000000000007},{"$f":"AVERAGE(P6:P15)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":39.6},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":6},{"$f":"COUNTIF(L6:L15,\"<1\")","v":3},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":0},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",2.9,6.3,0.8,-1.1000000000000001,81,90,6.5,0.7,"l",null,1.4,1016.8,1.4,1,0,null,1,null,null,null,11,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":2},{"$f":"COUNTIF(L18:L27,\"<1\")","v":4},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":1},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",2.9,3.8,2.1,2.2000000000000002,91,94,8,0.5,"l",null,".",1026.5,2.1,1,0,null,1,null,null,null,11,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":4},{"$f":"COUNTIF(L30:L40,\"<1\")","v":6},{"$f":"COUNTIF(L30:L40,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":1},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",0.5,2.2000000000000002,-2.1,-5,73,87,7.7,0,"lT",null,".",1029.9000000000001,-1.3,7,0,null,null,null,null,null,26]
["14.",-0.4,1.3,-2.9,-5,74,81,5.8,".",null,null,1.1000000000000001,1028,-3.3,7,0,null,null,null,null,null,34,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",0,1.3,-0.9,-1.7,73,77,6.4,0.1,"T",null,1,1018.6,-3.5,15,0,null,1,null,1,null,61,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":9.4},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":11.6},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-6.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":6.3}]
["16.",1.8,4.5,-0.9,-2.2000000000000002,76,83,6.6,3.3,"lT",null,0.6,995.8,-0.9,14,1,"D",1,null,1,null,61,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",1.7,3.3,0.6,-2.2000000000000002,70,79,6.5,0.5,"lT",null,1,997.2,-1.6,13,0,null,1,null,1,null,52,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-1.1000000000000001},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-5.0999999999999996},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":49},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":1}]
["18.",3.9,8.3000000000000007,1.2,0,49,72,7.3,1,"lT",null,0.3,998.6,-0.7,21,0,"R",1,null,1,1,82]
["19.",2.1,4.4000000000000004,-0.9,-4.4000000000000004,63,78,6.8,0,"lT",null,0.1,1006.4,-1.2,7,0,null,null,null,null,null,37]
["20.",1.2,3.9,-1.2,-5,67,78,6.1,".",null,null,0.7,1007.7,-2.2000000000000002,7,0,null,null,null,null,null,34]
["Su",{"$f":"SUM(B18:B27)","v":16.599999999999998},{"$f":"SUM(C18:C27)","v":39.300000000000004},{"$f":"SUM(D18:D27)","v":-4.1999999999999993},{"$f":"SUM(E18:E27)","v":-24.4},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":6.1},"XX",null,{"$f":"SUM(L18:L27)","v":6.1999999999999993},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":6},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":4},{"$f":"SUM(U18:U27)","v":1},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":1.6599999999999997},{"$f":"AVERAGE(C18:C27)","v":3.9300000000000006},-0.41999999999999993,-2.44,71.7,81.900000000000006,6.7699999999999987,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1012.5500000000002},{"$f":"AVERAGE(N18:N27)","v":-1.1199999999999999},{"$f":"AVERAGE(O18:O27)","v":9.3000000000000007},{"$f":"AVERAGE(P18:P27)","v":0.1},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":40.9}]
["21.",-0.9,1.3,-3.6,-6.1,84,90,7.4,0.3,"T",null,0.3,1011.9,-3,2,0,null,1,null,null,null,16]
["22.",-1.1000000000000001,0.4,-5.0999999999999996,-6.7,77,84,6.7,4.5999999999999996,"lT",null,".",1013.7,-3.5,7,1,"D",1,null,null,null,35]
["23.",3.4,6,0.2,-1.1000000000000001,79,90,7.5,1.8,"l",null,0.2,1022,1.8,4,0,"R",1,null,null,null,31]
["24.",6.9,11.6,4.0999999999999996,3.3,75,86,7.5,0.2,"l",null,1,1020.9,4.5999999999999996,9,0,null,1,null,1,null,53]
["25.",6.8,9.1999999999999993,3.8,2.8,73,80,7.8,0,"l",null,".",1016.2,3.7,8,0,null,null,null,null,null,27]
["26.",4.0999999999999996,6.3,3.1,2.2000000000000002,78,85,8,4.7,"l",null,".",1018.7,1.7,6,0,null,1,null,null,null,24]
["27.",3.9,5.8,2.8,-1.1000000000000001,90,94,7.1,0.5,"l",null,".",1030.4000000000001,3.1,1,0,null,1,null,null,null,19]
["28.",7.5,8.8000000000000007,3,0,63,76,7.5,0,"l",null,0.2,1028.0999999999999,3.4,14,0,null,null,null,1,null,50]
["29.",9.4,11.3,7.6,4.4000000000000004,68,75,7.4,2.2999999999999998,"l",null,0.3,1022.9,5.2,15,0,null,1,null,1,null,56]
["30.",3.9,8.3000000000000007,0.1,-2.2000000000000002,62,75,5.9,".",null,null,0.8,1025.7,0.1,11,0,null,null,null,1,null,52]
["31.",5.5,9.3000000000000007,-0.2,-2.8,70,79,7,2.2000000000000002,"l",null,0.6,1012.5,1.9,15,0,null,1,null,1,null,45]
["Su",{"$f":"SUM(B30:B40)","v":49.4},{"$f":"SUM(C30:C40)","v":78.299999999999983},{"$f":"SUM(D30:D40)","v":15.799999999999999},{"$f":"SUM(E30:E40)","v":-7.3000000000000007},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":16.599999999999998},"XX",null,{"$f":"SUM(L30:L40)","v":3.4},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":8},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":5},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":4.4909090909090912},7.1181818181818164,1.4363636363636363,-0.66363636363636369,74.454545454545453,83.090909090909093,7.2545454545454557,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1020.2727272727273},{"$f":"AVERAGE(N30:N40)","v":1.7272727272727273},{"$f":"AVERAGE(O30:O40)","v":8.3636363636363633},{"$f":"AVERAGE(P30:P40)","v":9.0909090909090912E-2},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":37.090909090909093}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":122.5},{"$f":"SUM(C16+C28+C41)","v":198.4},{"$f":"SUM(D16+D28+D41)","v":40.800000000000004},{"$f":"SUM(E16+E28+E41)","v":-28},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":39.099999999999994},"XX",null,{"$f":"SUM(L16+L28+L41)","v":11.5},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":22},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":15},{"$f":"SUM(U16+U28+U41)","v":2},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":3.9516129032258069},6.4000000000000021,1.3161290322580645,-0.9032258064516131,73.225806451612897,81.935483870967744,6.9290322580645167,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1014.4580645161292},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":1.064516129032258},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":9.129032258064516},{"$f":"AVERAGE(P17,P29,P42)","v":6.3636363636363644E-2},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":39.196969696969695}]
[]
[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":22},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":12}]
["TTT",0.5,"XXXX",{"$f":"SUM(B44-B48)","v":3.4516129032258069},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":11},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":13}]
["RRR",45,{"$f":"SUM(I43*100/B49)","v":86.888888888888886},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",64,{"$f":"SUM(L43*100/B50)","v":17.96875},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":0},"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":2}]
["mgl.",264,{"$f":"SUM(L43*100/B52)","v":4.3560606060606064},"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":10},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":20},">/= 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":0}]
[]
[]
[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":43,"n_cols":18,"rows_kept":43,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Januar",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,null,null,1,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,1,null,null,null,null,null,null," "," "," "," ",0]
["03.",null,null,null,1,1,1,null,null,null,null,null,null," "," "," "," ",0]
["04.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["05.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["07.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["08.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["09.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["11.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["12.","03:00:00",1,1,1,null,null,null,null,null,null,null,null,3," ",2,3,2]
["13.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["14.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["15.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["16.",null,null,null,1,1,1,null,null,null,null,null,null," "," "," "," ",0]
["17.",null,null,null,1,1,1,null,null,null,null,null,null," "," "," "," ",0]
["18.",null,null,null,null,1,1,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,null,null,null,null,null,null,null," "," "," "," ",0]
["21.","02:00:00",1,1,1,1,null,null,null,null,null,null,null,2," ",2,3,2]
["22.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["23.",null,null,1,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,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["26.",null,null,1,1,null,null,null,null,null,null,null,null," "," "," "," ",0]
["27.","02:10:00",1,1,1,1,null,null,null,null,null,null,null,2.1666666666666665," ",2,3,2]
["28.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["29.",null,null,null,null,null,1]
["30.",null,null,null,null,1,1]
["31.",null,null,null,null,1,1]
["Su.",{"$f":"SUM(B9:B39)","v":"07:10:00"},3,10,17,27,13,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":3}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":13}]

{"sheet":"Monatsdiagramm","index":3,"n_rows":67,"n_cols":9,"rows_kept":67,"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,"(211 m ü. NHN)"]
[]
["Januar 2018"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":11.6},"am","2018-01-24"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":3.9677419354838714},{"$f":"Kurztabelle!B48","v":0.5},{"$f":"C7-D7","v":3.4677419354838714},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-5.0999999999999996},"am","2018-01-22"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":39.099999999999994},{"$f":"Kurztabelle!B49","v":45},{"$f":"100/D9*C9","v":86.888888888888886},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":11.5},{"$f":"Kurztabelle!B50","v":64},{"$f":"100/D10*C10","v":17.96875},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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 %."]
["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":120,"n_cols":12,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2018-01-01",8.1999999999999993,10.9,3.8,0.1,null,1,1004.2,0.45]
["2018-01-02",4.5,6.2,2.1,2.1,null,null,1007.5,0.45]
["2018-01-03",4.9000000000000004,9.3000000000000007,1.6,4.7,null,0.2,995.8,0.45,"Ws","T Burglind"]
["2018-01-04",6.7,7.8,5.6,0.4,null,null,996.8,0.4]
["2018-01-05",8.1,10.4,6,0.3,null,null,998.9,0.4,"TrW","T Christine"]
["2018-01-06",7.3,8.9,5.9,6.3,null,0.3,1008.9,0.4,null,"T Dora"]
["2018-01-07",3,5.9,1.6,2.2999999999999998,null,null,1024.5999999999999,0.35]
["2018-01-08",1.3,3.2,-0.2,null,null,null,1030.2,0.35,"SEa","H Adam"]
["2018-01-09",7.3,9.8000000000000007,1.7,0.2,null,null,1018.9,0.35]
["2018-01-10",5.2,8.4,1.1000000000000001,null,null,0.4,1013.9,0.35]
["2018-01-11",2.9,6.3,0.8,0.7,null,1.4,1016.8,0.35,"HFa","H Borchert"]
["2018-01-12",2.9,3.8,2.1,0.5,null,null,1026.5,0.35]
["2018-01-13",0.5,2.2000000000000002,-2.1,null,null,null,1029.9000000000001,0.4]
["2018-01-14",-0.4,1.3,-2.9,null,null,1.1000000000000001,1028,0.4,"Sa"]
["2018-01-15",0,1.3,-0.9,0.1,0,1,1018.6,0.4]
["2018-01-16",1.8,4.5,-0.9,3.3,1,0.6,995.8,0.4,"Wz","T Evi"]
["2018-01-17",1.7,3.3,0.6,0.5,0,1,997.2,0.4]
["2018-01-18",3.9,8.3000000000000007,1.2,1,null,0.3,998.6,0.45,null,"T Friederike"]
["2018-01-19",2.1,4.4000000000000004,-0.9,null,null,0.1,1006.4,0.45]
["2018-01-20",1.7,3.9,-1.2,null,null,0.7,1007.7,0.45,"Ww","T Evi"]
["2018-01-21",-0.9,1.3,-3.6,0.3,0,0.3,1011.9,0.45]
["2018-01-22",-1.1000000000000001,0.4,-5.0999999999999996,4.5999999999999996,1,null,1013.7,0.45,null,"T Georgia"]
["2018-01-23",3.4,6,0.2,1.8,0,0.2,1022,0.5,"U","H Christian"]
["2018-01-24",6.9,11.6,4.0999999999999996,0.2,null,1,1020.9,0.5,"SWa"]
["2018-01-25",6.8,9.1999999999999993,3.8,null,null,null,1016.2,0.5]
["2018-01-26",4.0999999999999996,6.3,3.1,4.7,null,null,1018.7,0.5,"U"]
["2018-01-27",3.9,5.8,2.8,0.5,null,null,1030.4000000000001,0.5,"Wa"]
["2018-01-28",7.5,8.8000000000000007,3,null,null,0.2,1028.0999999999999,0.55000000000000004]
["2018-01-29",9.4,11.3,7.6,2.2999999999999998,null,0.3,1022.9,0.55000000000000004,"Wz","T Jira"]
["2018-01-30",3.9,8.3000000000000007,0.1,null,null,0.8,1025.7,0.55000000000000004]
["2018-01-31",5.5,9.3000000000000007,-0.2,2.2000000000000002,null,0.6,1012.5,0.55000000000000004,null,"T Kari"]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":3.9677419354838714},{"$f":"AVERAGE(C2:C32)","v":6.4000000000000021},{"$f":"AVERAGE(D2:D32)","v":1.3161290322580645},"-",null,{"$f":"AVERAGE(G2:G32)","v":0.60526315789473684},{"$f":"AVERAGE(H2:H32)","v":1014.4580645161292},{"$f":"AVERAGE(I2:I32)","v":0.43870967741935496}]
["Mittel",0.5,null,null,45,"-",64,1018.9]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":41,"n_cols":11,"rows_kept":41,"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:","Januar",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.","7,2 °C/7,2 °C/2,8 °C","5,6 °C/6,1 °C/4,4 °C","5,0 °C/5,6 °C/4,4 °C","5,0 °C/5,0 °C/5,0 °C","n","> 50 cm","> 50 cm"]
["02.","4,4 °C/5,0 °C/3,3 °C","4,4 °C/4,4 °C/4,4 °C","4,4 °C/4,4 °C/4,4 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm"]
["03.","2,2 °C/5,0 °C/4,4 °C","3,3 °C/3,9 °C/3,9 °C","3,9 °C/3,9 °C/3,9 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["04.","4,4 °C/7,8 °C/3,9 °C","4,4 °C/5,0 °C/4,4 °C","4,4 °C/4,4 °C/4,4 °C","4,4 °C/4,4 °C/5,0 °C","t","> 50 cm"]
["05.","4,4 °C/9,4 °C/5,0 °C","4,4 °C/5,0 °C/5,6 °C","4,4 °C/5,0 °C/5,0 °C","4,4 °C/5,0 °C/5,0 °C","n","> 50 cm","10 cm"]
["06.","5,0 °C/8,9 °C/5,6 °C","5,0 °C/5,6 °C/5,6 °C","5,0 °C/5,0 °C/5,6 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","35 cm"]
["07.","3,3 °C/2,8 °C/1,7 °C","5,0 °C/5,0 °C/4,4 °C","5,0 °C/5,0 °C/4,4 °C","5,0 °C/5,6 °C/5,0 °C","t","> 50 cm","< 30; 40 cm > "]
["08.","1,1 °C/3,3 °C/0,6 °C","3,9 °C/4,4 °C/3,3 °C","4,4 °C/4,4 °C/3,9 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","< 35 cm >"]
["09.","6,7 °C/9,4 °C/6,1 °C","3,9 °C/5,6 °C/5,6 °C","3,9 °C/5,0 °C/5,0 °C","4,4 °C/5,0 °C/5,0 °C","t","> 50 cm","14 cm"]
["10.","0,6 °C/8,3 °C/0,0 °C","4,4 °C/5,0 °C/4,4 °C","4,4 °C/5,0 °C/4,4 °C","5,0 °C/5,0 °C/5,0 °C","n","> 50 cm","< 35 cm >"]
["11.","0,0 °C/4,4 °C/0,6 °C","3,3 °C/3,9 °C/3,3 °C","3,9 °C/3,9 °C/3,9 °C","5,0 °C/5,0 °C/4,4 °C","t","> 50 cm"]
["12.","3,3 °C/3,9 °C/2,2 °C","3,9 °C/3,9 °C/3,9 °C","3,9 °C/3,9 °C/3,9 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["13.","1,1 °C/0,6 °C/-0,6 °C","3,9 °C/3,3 °C/2,8 °C","3,9 °C/3,3 °C/3,3 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["14.","-1,7 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,7 °C","2,2 °C/2,2 °C/2,2 °C","3,9 °C/3,9 °C/3,9 °C","n","> 50 cm"]
["15.","-0,6 °C/0,6 °C/-1,1 °C","1,7 °C/1,7 °C/1,1 °C","2,2 °C/2,2 °C/1,7 °C","3,3 °C/3,3 °C/3,3 °C","n","> 50 cm"]
["16.","0,6 °C/3,3 °C/-0,6 °C","1,1 °C/2,2 °C/1,7 °C","1,7 °C/2,2 °C/2,2 °C","3,3 °C/2,8 °C/3,3 °C","t","> 50 cm"]
["17.","-0,6 °C/2,8 °C/0,0 °C","1,1 °C/1,7 °C/1,7 °C","1,7 °C/2,2 °C/1,7 °C","2,8 °C/2,8 °C/2,8 °C","t","> 50 cm"]
["18.","0,6 °C/5,0 °C/3,3 °C","1,7 °C/2,2 °C/2,8 °C","1,7 °C/2,2 °C/2,8 °C","2,8 °C/2,8 °C/3,3 °C","t","> 50 cm"]
["19.","1,1 °C/5,6 °C/-2,8 °C","2,2 °C/2,8 °C/2,2 °C","2,8 °C/2,8 °C/2,8 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["20.","-1,7 °C/5,0 °C/-1,7 °C","1,7 °C/2,2 °C/1,7 °C","2,2 °C/2,2 °C/2,2 °C","3,3 °C/2,8 °C/2,8 °C","n","> 50 cm"]
["21.","-2,2 °C/0,6 °C/-2,2 °C","1,1 °C/1,7 °C/1,7 °C","1,7 °C/1,7 °C/1,7 °C","2,8 °C/2,8 °C/2,8 °C","t","7 cm"]
["22.","-2,2 °C/0,6 °C/0,0 °C","1,1 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","2,8 °C/2,8 °C/2,8 °C","t","> 50 cm"]
["23.","1,7 °C/6,7 °C/2,8 °C","1,7 °C/2,8 °C/3,3 °C","1,7 °C/2,2 °C/2,8 °C","2,8 °C/2,8 °C/2,8 °C","t","> 50 cm"]
["24.","3,9 °C/9,4 °C/6,1 °C","3,3 °C/5,0 °C/5,0 °C","3,3 °C/3,9 °C/4,4 °C","2,8 °C/3,3 °C/3,9 °C","t","> 50 cm","5 cm"]
["25.","5,6 °C/8,9 °C/4,4 °C","4,4 °C/5,6 °C/5,0 °C","4,4 °C/4,4 °C/5,0 °C","3,9 °C/4,4 °C/4,4 °C","t","> 50 cm","10 cm"]
["26.","2,8 °C/7,2 °C/3,9 °C","3,9 °C/5,0 °C/4,4 °C","3,9 °C/4,4 °C/4,4 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["27.","3,3 °C/6,7 °C/1,7 °C","4,4 °C/5,0 °C/4,4 °C","4,4 °C/5,0 °C/5,0 °C","4,4 °C/4,4 °C/5,0 °C","t","> 50 cm"]
["28.","6,1 °C/10,0 °C/7,8 °C","4,4 °C/5,6 °C/5,6 °C","4,4 °C/5,0 °C/5,6 °C","4,4 °C/4,4 °C/5,0 °C","t","> 50 cm","25 cm"]
["29.","6,1 °C/11,1 °C/8,3 °C","6,1 °C/6,7 °C/6,7 °C","5,6 °C/6,1 °C/6,1 °C","5,0 °C/5,6 °C/5,6 °C","t","> 50 cm","> 50 cm"]
["30.","2,2 °C/6,1 °C/-1,7 °C","5,6 °C/5,6 °C/3,9 °C","5,6 °C/5,6 °C/5,0 °C","5,6 °C/5,6 °C/5,6 °C","n","> 50 cm","< 14 > 50 cm"]
["31.","3,3 °C/8,9 °C/5,6 °C","3,3 °C/5,0 °C/5,0 °C","3,9 °C/4,4 °C/5,0 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","< 35 cm >"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]