{"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",88,988.7,1.2,8,null,"00",77,1004.5,-2.4,6]
["01",87,988.5,1.4,6,null,"01",75,1004.6,-3,7]
["02",88,988.7,1.5,8,null,"02",74,1005.4,-3.2,7]
["03",88,988.7,1.6,8,null,"03",74,1006.2,-3.2,5]
["04",91,988.5,1.9,8,null,"04",74,1006.9,-3.1,6]
["05",92,988.7,2.4,8,null,"05",76,1007.2,-3,7]
["06",90,989.2,1.9,8,null,"06",76,1007.8,-3,8]
["07",91,989.8,1.6,8,null,"07",76,1008.3,-2.8,6]
["08",93,990.3,1.8,8,null,"08",76,1008.7,-2.6,7]
["09",93,990.8,2,8,null,"09",76,1008.7,-2.6,7]
["10",92,991.6,2,8,null,"10",76,1008.9,-2.5,7]
["11",92,992.5,2,8,null,"11",73,1009.1,-2.5,7]
["12",92,993.5,0.9,8,null,"12",73,1009.6,-2.4,7]
["13",93,994.2,0.9,8,null,"13",72,1009.4,-2.2999999999999998,7]
["14",91,995.1,1.4,8,null,"14",71,1009,-2.1,2]
[15,88,996.1,1.3,8,null,"15",69,1008.6,-2.7,2]
["16",89,997.2,1,8,null,"16",73,1009.7,-3.5,3]
["17",88,998.4,0.6,7,null,"17",75,1009.4,-4,1]
[18,86,999.6,0.1,4,null,"18",75,1008.7,-4.9000000000000004,1]
["19",87,1000.1,0,4,null,"19",80,1008,-4.8,3]
["20",82,1001,-1,5,null,"20",80,1007.4,-5.0999999999999996,0]
["21",79,1002,-2,2,null,"21",79,1006.7,-4.0999999999999996,5]
["22",79,1003.1,-2.4,5,null,"22",78,1006,-4.0999999999999996,4]
["23",79,1004,-2.1,7,null,"23",77,1006.1,-4.7,4]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":88.3},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":994.2},{"$f":"AVERAGE(D3:D26)","v":0.83333333333333337},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":7},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":75.2},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1007.7},{"$f":"AVERAGE(J3:J26)","v":-3.2749999999999999},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":5}]
[]
[null,null,null,"2017-12-28",null,null,null,null,null,"2017-12-29"]
[]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",76,1005.9,-5,3,null,"00",74,1002.4,5.8,8]
["01",78,1006.4,-5.3,5,null,"01",70,1003.1,5.8,7]
["02",77,1006.7,-4.8,7,null,"02",70,1004.6,6.2,8]
["03",73,1006.9,-4.3,8,null,"03",77,1005,6.4,8]
["04",77,1007.1,-3.9,8,null,"04",79,1005.9,6.3,8]
["05",80,1007.3,-3.3,8,null,"05",86,1006.3,7.1,8]
["06",78,1007.2,-3.3,8,null,"06",88,1006.8,6.6,8]
["07",80,1007.5,-2.8,8,null,"07",91,1007.2,6.7,8]
["08",79,1007.8,-3,8,null,"08",93,1007.4,6.9,8]
["09",79,1007.8,-2.8,7,null,"09",92,1007.6,7.2,8]
["10",78,1007.7,-2.6,7,null,"10",93,1007.4,7.2,8]
["11",78,1006.6,-1.5,8,null,"11",95,1006.8,8.5,8]
["12",80,1005.7,-1,8,null,"12",79,1006.1,8.8000000000000007,7]
["13",81,1004.6,-0.5,8,null,"13",73,1005.8,8.3000000000000007,7]
["14",82,1003.5,-0.3,8,null,"14",71,1005.4,7.8,7]
["15",85,1002.1,0.6,8,null,"15",68,1005.5,6.8,7]
["16",84,1002.1,0.6,8,null,"16",70,1005.4,6.9,5]
["17",83,1001.8,0.6,8,null,"17",71,1005.3,6.9,6]
["18",84,1001.8,1.3,8,null,"18",73,1005.6,6.9,7]
["19",87,1002.2,2,8,null,"19",71,1004.7,6.8,7]
["20",80,1002,4.9000000000000004,8,null,"20",69,1004.6,6.5,7]
["21",78,1002.1,5.2,6,null,"21",75,1004.4,6.1,8]
["22",75,1002.1,5.3,3,null,"22",77,1003.6,5.8,6]
["23",75,1002.5,5.4,5,null,"23",72,1003.7,5.7,6]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":79.5},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":1004.9},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":-0.8},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":7.1},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":78.2},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1005.4},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":6.8},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":7.3}]
[]
[null,null,null,"2017-12-30",null,null,null,null,null,"2017-12-31"]

{"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:","Dezember",null,null,null,null,"Jahr:",null,null,"2017"]
[]
["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.",-0.3,2.2000000000000002,-2.8,-5,83,85,7.5,".",null,null,1,1017.1,-2.2999999999999998,1,0,null,null,null,null,null,13,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.",0.7,2.2000000000000002,-0.4,-2.2000000000000002,80,84,7.5,".",null,null,".",1026.5,-1.6,1,0,null,null,null,null,null,11,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":6},{"$f":"COUNTIF(I6:I15,\">=1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$f":"COUNTIF(I6:I15,\">=10\")","v":1},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0},null,null,null,null,null,null,null,null,null,"200 cm3"]
["03.",-0.1,1.3,-1.6,-3.9,70,81,5.2,2.7,"lT",null,1.4,1022.6,-2.7,3,0,null,1,null,null,null,31,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":8},{"$f":"COUNTIF(I18:I27,\">=1\")","v":6},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$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.",2.2999999999999998,3.8,0.7,0,85,85,7,13,"l",null,".",1024.2,0.6,11,0,null,1,null,1,null,42,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":7},{"$f":"COUNTIF(I30:I40,\">=1\")","v":4},{"$f":"COUNTIF(I30:I40,\">=3\")","v":1},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",4.8,6.3,2.9,1.7,82,85,8,0.6,"l",null,".",1029.0999999999999,3,13,0,null,1,null,1,null,44]
["06.",5.4,5.7,5.2,3.9,78,79,8,".",null,null,".",1027.9000000000001,2.1,11,0,null,null,null,1,null,45,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.",4.4000000000000004,9.1999999999999993,0.9,-2.2000000000000002,57,74,2.2000000000000002,".",null,null,1.4,1015.4,-0.1,5,0,null,null,null,null,null,24,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":5},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":7},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",4.5999999999999996,8.4,1.4,-2.2000000000000002,66,80,6.2,0.8,"l",null,1.2,1007.2,0.5,10,0,null,1,null,1,null,47,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":6},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",0.9,2.4,-0.1,-4.4000000000000004,71,81,7.8,0.2,"lT",null,0.1,1009.2,-2.6,15,0,null,1,null,1,null,52,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.",0.2,5.0999999999999996,-1.7,-4.4000000000000004,67,73,6.7,0.4,"lT",null,0.1,997.9,-4.0999999999999996,17,1,"T",null,null,1,null,56]
["Su",{"$f":"SUM(B6:B15)","v":22.900000000000002},{"$f":"SUM(C6:C15)","v":46.6},{"$f":"SUM(D6:D15)","v":4.5000000000000009},{"$f":"SUM(E6:E15)","v":-18.700000000000003},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":17.7},"XX",null,{"$f":"SUM(L6:L15)","v":5.1999999999999993},"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":2.29},{"$f":"AVERAGE(C6:C15)","v":4.66},0.45000000000000007,-1.8700000000000003,73.900000000000006,80.7,6.6100000000000012,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1017.7099999999998},{"$f":"AVERAGE(N6:N15)","v":-0.72},{"$f":"AVERAGE(O6:O15)","v":8.6999999999999993},{"$f":"AVERAGE(P6:P15)","v":0.1},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":36.5},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":4},{"$f":"COUNTIF(L6:L15,\"<1\")","v":2},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":1},{"$f":"COUNTIF(P6:P15,\">=3\")","v":0},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",5.8,7.1,2.6,1.1000000000000001,67,77,7.4,0.1,"l",null,".",987.2,1.9,11,0,null,1,null,1,null,45,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":5},{"$f":"COUNTIF(L18:L27,\"<1\")","v":4},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":3},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",4.8,7.3,3.1,1.1000000000000001,58,68,6.8,".",null,null,".",1001.8,-0.5,12,0,null,null,null,1,null,53,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":6},{"$f":"COUNTIF(L30:L40,\"<1\")","v":5},{"$f":"COUNTIF(L30:L40,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":0},{"$f":"COUNTIF(P30:P40,\">=3\")","v":0},{"$f":"COUNTIF(P30:P40,\">=10\")","v":0}]
["13.",1.9,3.6,-0.5,-4.4000000000000004,61,69,5.4,1,"l",null,0.5,1011.2,-3.3,12,0,null,1,null,null,null,29]
["14.",3.5,5.4,2.1,-1.1000000000000001,61,75,6.5,1.7,"l",null,0.4,994.3,-0.7,15,0,null,1,null,1,1,64,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",2.1,3.8,0.2,-2.8,76,84,6.8,3.5,"l",null,0.2,997,-0.4,6,0,null,1,null,null,null,34,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":10.6},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":13.2},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-7.8},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":13}]
["16.",1.2,3,-0.9,-3.9,80,89,7.3,3.8,"lT",null,".",1007.2,-0.5,3,0,null,1,null,null,null,23,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",0.8,2.5,-0.5,-1.1000000000000001,85,89,7.8,3,"lT",null,".",1018.7,-0.7,5,1,"T",1,null,null,null,35,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-1.7},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-5.3},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":57},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":1}]
["18.",-1.7,1.3,-5.3,-7.8,78,86,4.3,".",null,null,1.2,1026.3,-3.6,1,1,"T",null,null,null,null,13]
["19.",-0.6,1.6,-4.4000000000000004,-4.4000000000000004,84,90,7.7,2,"lT",null,".",1031.7,-2.1,1,1,"T",1,null,null,null,19]
["20.",1,2.9,-0.1,-2.2000000000000002,92,94,7.2,0.5,"l",null,0.3,1033.5999999999999,0.2,0,0,"F",1,null,null,null,11]
["Su",{"$f":"SUM(B18:B27)","v":18.8},{"$f":"SUM(C18:C27)","v":38.5},{"$f":"SUM(D18:D27)","v":-3.6999999999999997},{"$f":"SUM(E18:E27)","v":-25.499999999999996},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":15.6},"XX",null,{"$f":"SUM(L18:L27)","v":2.5999999999999996},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":8},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":3},{"$f":"SUM(U18:U27)","v":1},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":1.8800000000000001},{"$f":"AVERAGE(C18:C27)","v":3.85},-0.37,-2.5499999999999998,74.2,82.1,6.7199999999999989,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1010.9},{"$f":"AVERAGE(N18:N27)","v":-0.97},{"$f":"AVERAGE(O18:O27)","v":6.6},{"$f":"AVERAGE(P18:P27)","v":0.3},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":32.6}]
["21.",4.8,6.5,0.9,1.1000000000000001,88,93,8,1.4,"l",null,".",1030.8,3.7,6,0,null,1,null,null,null,34]
["22.",5,6.4,3.8,2.8,82,88,7.9,0.1,"l",null,".",1031.9000000000001,3.2,6,0,null,1,null,null,null,31]
["23.",6.8,8.9,2.7,0.6,76,81,7.7,".",null,null,0.2,1027.8,3.6,14,0,null,null,null,1,null,55]
["24.",8.6999999999999993,9.6999999999999993,8,6.1,74,77,7,".",null,null,0.3,1022,4.8,18,0,null,null,null,1,null,56]
["25.",5.4,8.6999999999999993,0.7,-3.3,73,79,6,".",null,null,".",1018.5,2.2000000000000002,8,0,null,null,null,1,null,53]
["26.",3.7,7.8,1,-1.1000000000000001,69,78,4.5,0.7,"l",null,0.5,1006.7,0.2,11,0,null,1,null,1,null,53]
["27.",1.9,3.2,-0.1,-2.8,79,85,6.5,2.5,"l",null,".",993.9,-0.9,8,0,null,1,null,null,null,37]
["28.",2.6,3.7,0.7,-1.7,77,88,7,5.9,"l",null,".",994.2,0.8,7,0,null,1,null,null,null,34]
["29.",0.6,3,-2.1,-5.6,69,75,5,".",null,null,0.5,1007.7,-3.3,12,0,null,null,null,1,null,40]
["30.",2.7,10.3,-2,-3.9,72,79,7.1,2.2000000000000002,"l",null,".",1004.9,-0.8,11,0,null,1,null,1,null,44]
["31.",10.6,13.2,7.8,6.1,67,78,7.3,0.8,"l",null,0.3,1005.4,6.8,14,0,null,1,null,1,null,58]
["Su",{"$f":"SUM(B30:B40)","v":52.800000000000011},{"$f":"SUM(C30:C40)","v":81.400000000000006},{"$f":"SUM(D30:D40)","v":21.4},{"$f":"SUM(E30:E40)","v":-1.7000000000000011},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":13.600000000000001},"XX",null,{"$f":"SUM(L30:L40)","v":1.8},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":7},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":7},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":4.8000000000000007},7.4,1.9454545454545453,-0.15454545454545465,75.090909090909093,81.909090909090907,6.7272727272727275,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1013.0727272727272},{"$f":"AVERAGE(N30:N40)","v":1.8454545454545455},{"$f":"AVERAGE(O30:O40)","v":10.454545454545455},{"$f":"AVERAGE(P30:P40)","v":0},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":45}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":94.500000000000014},{"$f":"SUM(C16+C28+C41)","v":166.5},{"$f":"SUM(D16+D28+D41)","v":22.2},{"$f":"SUM(E16+E28+E41)","v":-45.900000000000006},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":46.9},"XX",null,{"$f":"SUM(L16+L28+L41)","v":9.6},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":20},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":16},{"$f":"SUM(U16+U28+U41)","v":1},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":3.0483870967741931},5.370967741935484,0.71612903225806435,-1.4806451612903226,74.41935483870968,81.58064516129032,6.6870967741935488,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1013.867741935484},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":0.1096774193548387},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":8.6451612903225801},{"$f":"AVERAGE(P17,P29,P42)","v":0.13333333333333333},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":38.033333333333331}]
[]
[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":21},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":15}]
["TTT",1.1000000000000001,"XXXX",{"$f":"SUM(B44-B48)","v":1.948387096774193},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":12},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":11}]
["RRR",53,{"$f":"SUM(I43*100/B49)","v":88.490566037735846},"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",55,{"$f":"SUM(L43*100/B50)","v":17.454545454545453},"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":4}]
["mgl.",247,{"$f":"SUM(L43*100/B52)","v":3.8866396761133601},"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":14},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":21},">/= 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:","Dezember",null,null,null,"Jahr:",2017]
[]
["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,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["03.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["04.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["05.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["07.",null,null,null,null,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,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["11.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["12.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["13.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["14.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["15.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["16.",null,null,null,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,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["19.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["20.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["21.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["22.",null,null,1,1,1,null,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,null,null,null,null,null,null,null," "," "," "," ",0]
["27.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["28.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["29.",null,null,null,null,1]
["30.",null,null,null,null,1]
["31.",null,null,null,1,1,1]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,10,17,31,7,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":7}]

{"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)"]
[]
["Dezember 2017"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":13.2},"am","2017-12-31"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":3.0451612903225804},{"$f":"Kurztabelle!B48","v":1.1000000000000001},{"$f":"C7-D7","v":1.9451612903225803},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-5.3},"am","2017-12-18"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":46.9},{"$f":"Kurztabelle!B49","v":53},{"$f":"100/D9*C9","v":88.490566037735846},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":9.6},{"$f":"Kurztabelle!B50","v":55},{"$f":"100/D10*C10","v":17.454545454545453},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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"]
["2017-12-01",-0.3,2.2000000000000002,-2.8,null,null,1,1017.1,2.1]
["2017-12-02",0.7,2.2000000000000002,-0.4,null,null,null,1026.5,2]
["2017-12-03",-0.1,1.3,-1.6,2.7,null,1.4,1022.6,1.9]
["2017-12-04",2.2999999999999998,3.8,0.7,13,null,null,1024.2,1.8]
["2017-12-05",4.8,6.3,2.9,0.6,null,null,1029.0999999999999,1.75]
["2017-12-06",5.4,5.7,5.2,null,null,null,1027.9000000000001,1.65]
["2017-12-07",4.4000000000000004,9.1999999999999993,0.9,null,null,1.4,1015.4,1.6]
["2017-12-08",4.5999999999999996,8.4,1.4,0.8,null,1.2,1007.2,1.55]
["2017-12-09",0.9,2.4,-0.1,0.2,0,0.1,1009.2,1.5]
["2017-12-10",0.2,5.0999999999999996,-1.7,0.4,1,0.1,997.9,1.4,"TrW","T Xanthos"]
["2017-12-11",5.8,7.1,2.6,0.1,0,null,987.2,1.35]
["2017-12-12",4.8,7.3,3.1,null,null,null,1001.8,1.3]
["2017-12-13",1.9,3.6,-0.5,1,null,0.5,1011.2,1.25,"NWz","T Zubin"]
["2017-12-14",3.5,5.4,2.1,1.7,null,0.4,994.3,1.1499999999999999]
["2017-12-15",2.1,3.8,0.2,3.5,null,0.2,997,1.1000000000000001]
["2017-12-16",1.2,3,-0.9,3.8,0,null,1007.2,1.05]
["2017-12-17",0.8,2.5,-0.5,3,1,null,1018.7,1,"BM","H Carina"]
["2017-12-18",-1.8,1.3,-5.3,null,1,1.2,1026.3,0.95]
["2017-12-19",-0.6,1.6,-4.4000000000000004,2,1,null,1031.7,0.9]
["2017-12-20",1,2.9,-0.1,0.5,0,0.3,1033.5999999999999,0.85,"NWa"]
["2017-12-21",4.8,6.5,0.9,1.4,null,null,1030.8,0.8]
["2017-12-22",5,6.4,3.8,0.1,null,null,1031.9000000000001,0.8]
["2017-12-23",6.8,8.9,2.7,null,null,0.2,1027.8,0.75,"Wa"]
["2017-12-24",8.6999999999999993,9.6999999999999993,8,null,null,0.3,1022,0.6]
["2017-12-25",5.4,8.6999999999999993,0.7,null,null,null,1018.5,0.6]
["2017-12-26",3.7,7.8,1,0.7,null,0.5,1006.7,0.55000000000000004]
["2017-12-27",1.9,3.2,-0.1,2.5,null,null,993.9,0.5,"TrM","T Edilbert"]
["2017-12-28",2.6,3.7,0.7,5.9,null,null,994.2,0.45]
["2017-12-29",0.6,3,-2.1,null,null,0.5,1007.7,0.4,"Wz","T Gernot"]
["2017-12-30",2.7,10.3,-2,2.2000000000000002,null,null,1004.9,0.4]
["2017-12-31",10.6,13.2,7.8,0.8,null,0.3,null,0.4,null,"T Horst"]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":3.0451612903225804},{"$f":"AVERAGE(C2:C32)","v":5.370967741935484},{"$f":"AVERAGE(D2:D32)","v":0.71612903225806435},"-",null,{"$f":"AVERAGE(G2:G32)","v":0.60000000000000009},{"$f":"AVERAGE(H2:H32)","v":1014.1500000000001},{"$f":"AVERAGE(I2:I32)","v":1.1096774193548389}]
["Mittel",1.1000000000000001,null,null,53,"-",55,1017.3]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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:","Dezember",null,null,null,"Jahr:",2017]
[]
["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.","-5,0 °C/1,7 °C/-0,6 °C","2,2 °C/2,2 °C/2,2 °C","3,3 °C/3,3 °C/2,8 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","< 35 > 50 cm"]
["02.","-0,6 °C/2,2 °C/-0,6 °C","2,2 °C/3,3 °C/2,8 °C","2,8 °C/3,3 °C/3,3 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["03.","-2,2 °C/-1,1 °C/0,0 °C","2,2 °C/1,7 °C/1,7 °C","2,8 °C/2,8 °C/2,2 °C","4,4 °C/4,4 °C/3,9 °C","n","> 50 cm"]
["04.","1,7 °C/1,7 °C/1,1 °C","2,2 °C/3,3 °C/2,2 °C","2,8 °C/3,9 °C/2,8 °C","3,9 °C/3,3 °C/3,9 °C","t","> 50 cm"]
["05.","3,9 °C/5,6 °C/3,9 °C","2,8 °C/4,4 °C/4,4 °C","2,8 °C/3,9 °C/4,4 °C","3,9 °C/3,9 °C/4,4 °C","t","> 50 cm"]
["06.","4,4 °C/5,0 °C/4,4 °C","4,4 °C/4,4 °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"]
["07.","-1,1 °C/3,9 °C/0,0 °C","3,9 °C/3,9 °C/2,8 °C","4,4 °C/3,9 °C/3,3 °C","5,0 °C/5,0 °C/4,4 °C","n","> 50 cm"]
["08.","4,4 °C/3,3 °C/0,6 °C","3,9 °C/3,9 °C/2,8 °C","3,9 °C/3,9 °C/3,3 °C","4,4 °C/4,4 °C/4,4 °C","n","> 50 cm"]
["09.","-0,6 °C/1,1 °C/-0,6 °C","1,7 °C/2,2 °C/1,7 °C","2,8 °C/2,8 °C/2,2 °C","3,9 °C/3,9 °C/3,9 °C","t","> 50 cm"]
["10.","-3,3 °C/0,0 °C/1,7 °C","1,1 °C/1,1 °C/1,1 °C","2,2 °C/1,7 °C/1,7 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["11.","3,9 °C/5,6 °C/3,3 °C","1,7 °C/2,8 °C/3,3 °C","2,2 °C/2,8 °C/3,3 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["12.","4,4 °C/4,4 °C/2,2 °C","3,9 °C/3,9 °C/2,8 °C","3,3 °C/3,9 °C/3,3 °C","3,9 °C/3,9 °C/3,9 °C","t","> 50 cm"]
["13.","-2,2 °C/1,1 °C/2,2 °C","1,7 °C/1,7 °C/1,7 °C","2,2 °C/2,2 °C/2,2 °C","3,9 °C/3,3 °C/3,3 °C","n","> 50 cm"]
["14.","0,0 °C/2,8 °C/1,7 °C","1,7 °C/2,8 °C/2,2 °C","2,2 °C/2,8 °C/2,8 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["15.","1,7 °C/2,8 °C/-1,1 °C","2,2 °C/2,8 °C/2,2 °C","2,2 °C/2,8 °C/2,2 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["16.","-1,1 °C/3,3 °C/1,1 °C","1,7 °C/2,2 °C/2,2 °C","2,2 °C/2,2 °C/2,8 °C","2,8 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["17.","0,6 °C/1,7 °C/-0,6 °C","2,2 °C/2,2 °C/2,2 °C","2,2 °C/2,8 °C/2,2 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["18.","-3,9 °C/-1,1 °C/-7,2 °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","< 7 > 50 cm"]
["19.","-2,2 °C/1,1 °C/0,6 °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"]
["20.","0,0 °C/1,7 °C/0,0 °C","1,1 °C/1,7 °C/1,7 °C","1,7 °C/1,7 °C/2,2 °C","2,8 °C/2,8 °C/2,8 °C","t","> 50 cm"]
["21.","3,3 °C/6,1 °C/4,4 °C","2,2 °C/3,3 °C/3,9 °C","2,2 °C/3,3 °C/3,3 °C","2,8 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["22.","3,9 °C/5,0 °C/3,3 °C","3,3 °C/4,4 °C/3,9 °C","3,3 °C/3,9 °C/3,9 °C","3,9 °C/3,9 °C/3,9 °C","t","> 50 cm"]
["23.","3,9 °C/8,3 °C/7,8 °C","3,9 °C/5,0 °C/5,6 °C","3,9 °C/4,4 °C/5,0 °C","3,9 °C/4,4 °C/4,4 °C","t","> 50 cm","10 cm"]
["24.","6,1 °C/10,0 °C/7,8 °C","5,0 °C/6,1 °C/6,1 °C","5,0 °C/5,6 °C/5,6 °C","5,0 °C/5,0 °C/5,0 °C","t","> 50 cm","35 cm"]
["25.","6,1 °C/7,8 °C/0,6 °C","5,6 °C/6,1 °C/4,4 °C","5,6 °C/5,6 °C/5,0 °C","5,6 °C/5,6 °C/5,6 °C","n","> 50 cm","< 9 > 50 cm"]
["26.","-0,6 °C/3,9 °C/1,7 °C","2,8 °C/3,9 °C/3,9 °C","3,9 °C/3,9 °C/3,9 °C","5,0 °C/5,0 °C/4,4 °C","n","> 50 cm"]
["27.","0,0 °C/2,8 °C/2,2 °C","2,2 °C/2,8 °C/2,8 °C","2,8 °C/3,3 °C/3,3 °C","4,4 °C/4,4 °C/3,9 °C","t","> 50 cm"]
["28.","2,2 °C/2,8 °C/-0,6 °C","3,3 °C/3,3 °C/2,8 °C","3,3 °C/3,3 °C/3,3 °C","3,9 °C/3,9 °C/3,9 °C","t","> 50 cm"]
["29.","0,0 °C/0,6 °C/-2,2 °C","2,2 °C/2,8 °C/1,7 °C","2,8 °C/2,8 °C/2,2 °C","3,9 °C/3,9 °C/3,9 °C","n","> 50 cm"]
["30.","0,0 °C/2,2 °C/5,6 °C","1,1 °C/1,7 °C/2,8 °C","1,7 °C/2,2 °C/2,2 °C","3,3 °C/3,3 °C/3,3 °C","t","> 50 cm"]
["31.","6,1 °C/12,2 °C/6,7 °C","4,4 °C/6,1 °C/5,6 °C","3,9 °C/5,0 °C/5,0 °C","3,3 °C/3,9 °C/4,4 °C","t","> 50 cm","< 16 > 50 cm"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]