{"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",84,1013.2,2.2000000000000002,6,null,"00",85,1013.7,0.7,8]
["01",83,1013.8,1.6,5,null,"01",85,1013.1,0.5,8]
["02",84,1014.7,1.4,6,null,"02",85,1012.6,0.3,8]
["03",85,1015.1,1.2,4,null,"03",85,1012.2,0.4,8]
["04",85,1015.2,1.4,7,null,"04",85,1011.9,0.6,8]
["05",85,1015.5,1.5,7,null,"05",85,1011.5,0.7,8]
["06",85,1015.6,1.7,8,null,"06",86,1011.3,1,8]
["07",85,1016,1.8,8,null,"07",86,1010.8,1.3,8]
["08",85,1016.4,1.1000000000000001,8,null,"08",86,1011,1.6,8]
["09",85,1016.9,1.3,8,null,"09",87,1011,2.1,8]
["10",85,1017.1,2.2999999999999998,8,null,"10",87,1011.2,2.6,8]
["11",84,1016.8,2.9,8,null,"11",87,1011,4,8]
["12",85,1016.8,2.4,8,null,"12",85,1010.8,6.1,8]
["13",85,1016.5,2,8,null,"13",85,1010.8,6.9,8]
["14",85,1016.3,2,8,null,"14",85,1010.9,6.9,8]
[15,85,1016,2.1,8,null,"15",85,1010.7,7,8]
["16",85,1016,2.2000000000000002,8,null,"16",85,1010.9,6.8,8]
["17",85,1016,1.8,8,null,"17",84,1010.9,6.4,8]
[18,85,1015.9,1.4,8,null,"18",84,1011.1,6.2,8]
["19",85,1015.9,1.1000000000000001,8,null,"19",84,1011,6.1,6]
["20",85,1015.5,0.9,8,null,"20",84,1010.9,6.1,8]
["21",85,1015.3,0.9,8,null,"21",84,1010.9,5.9,8]
["22",85,1014.8,0.9,8,null,"22",84,1010.6,5.9,8]
["23",85,1014.4,1,8,null,"23",84,1010.7,6.1,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":84.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":1015.7},{"$f":"AVERAGE(D3:D26)","v":1.6291666666666664},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":7.5},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":85.1},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":1011.3},{"$f":"AVERAGE(J3:J26)","v":3.8416666666666663},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":7.9}]
[]
[null,null,null,"2017-11-20",null,null,null,null,null,"2017-11-21"]
[]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",null,null,null,null,null,"00",85,1013.3,1.2,7]
["01",null,null,null,null,null,"01",85,1012.8,0.9,7]
["02",null,null,null,null,null,"02",85,1012.4,1.1000000000000001,8]
["03",null,null,null,null,null,"03",84,1011.8,0.7,8]
["04",null,null,null,null,null,"04",83,1011.1,0.5,8]
["05",null,null,null,null,null,"05",85,1011,0.3,8]
["06",null,null,null,null,null,"06",84,1010.6,0.6,7]
["07",null,null,null,null,null,"07",84,1010.4,0.6,1]
["08",null,null,null,null,null,"08",84,1010.4,0.5,5]
["09",null,null,null,null,null,"09",82,1010.3,1.1000000000000001,7]
["10",null,null,null,null,null,"10",80,1010.3,1.3,7]
["11",null,null,null,null,null,"11",80,1010,1.6,7]
["12",null,null,null,null,null,"12",79,1009.8,1.8,7]
["13",null,null,null,null,null,"13",78,1009.6,2.2000000000000002,8]
["14",null,null,null,null,null,"14",78,1008.9,2.2000000000000002,8]
["15",null,null,null,null,null,"15",81,1009.5,2.5,8]
["16",null,null,null,null,null,"16",84,1009.6,2,8]
["17",null,null,null,null,null,"17",85,1009.9,1.8,8]
["18",null,null,null,null,null,"18",85,1009.9,2.2000000000000002,8]
["19",null,null,null,null,null,"19",85,1010,2.2999999999999998,8]
["20",null,null,null,null,null,"20",85,1010.3,2.2999999999999998,8]
["21",null,null,null,null,null,"21",85,1011,2,8]
["22",null,null,null,null,null,"22",85,1011.7,2.2000000000000002,8]
["23",null,null,null,null,null,"23",85,1012.3,2.5,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":{"$error":"#DIV/0!"}},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":83.2},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1010.7},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":1.5},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":7.3}]
[]
[null,null,null,"2017-11-22",null,null,null,null,null,"2017-11-19"]

{"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:","November",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.",8.8000000000000007,11.1,7.2,6.1,78,82,7.8,0.9,"l",null,".",1020.6,5.9,9,null,null,1,null,null,null,34,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.",10.199999999999999,14.3,7.7,6.1,64,79,7.4,0.2,"l",null,0.8,1013,6.7,5,null,null,1,null,null,null,35,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.",8.9,12.6,4.5999999999999996,1.1000000000000001,70,82,4.5999999999999996,null,null,null,2.2999999999999998,1017.5,6,3,null,null,null,null,null,null,21,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":7},{"$f":"COUNTIF(I18:I27,\">=1\")","v":4},{"$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.",6.9,10.6,2.8,0.6,76,83,5.4,null,null,null,2.1,1013.9,4.3,7,null,null,null,null,null,null,31,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":6},{"$f":"COUNTIF(I30:I39,\">=1\")","v":3},{"$f":"COUNTIF(I30:I39,\">=3\")","v":2},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",7.7,9.6999999999999993,5.8,4.4000000000000004,82,84,6.7,10.6,"l",null,".",1009,5.0999999999999996,9,null,null,1,null,null,null,34]
["06.",6.6,7.4,5.9,5.6,84,84,7.8,0.4,"l",null,".",1020.5,4.2,3,null,null,1,null,null,null,23,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.",6.9,8.6999999999999993,4.0999999999999996,0.6,84,84,7.3,".",null,null,".",1023.2,4.5,2,null,null,null,null,null,null,13,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":9},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",6.6,10,2.2999999999999998,0.6,81,84,6.3,0.1,"l",null,".",1019.3,4.0999999999999996,3,null,null,1,null,null,null,23,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":2},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":10},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",6.3,7.6,5.2,4.4000000000000004,84,84,7.9,".",null,null,".",1021.8,3.8,1,null,null,null,null,null,null,21,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":2},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":7},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",7.6,9.8000000000000007,5.0999999999999996,2.8,75,81,7.4,1.3,"l",null,".",1014.8,4.5999999999999996,10,null,null,1,null,1,null,52]
["Su",{"$f":"SUM(B6:B15)","v":76.5},{"$f":"SUM(C6:C15)","v":101.8},{"$f":"SUM(D6:D15)","v":50.7},{"$f":"SUM(E6:E15)","v":32.299999999999997},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":13.5},"XX",null,{"$f":"SUM(L6:L15)","v":5.1999999999999993},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":6},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":1},{"$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":7.65},{"$f":"AVERAGE(C6:C15)","v":10.18},5.07,3.2299999999999995,77.8,82.7,6.8599999999999994,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1017.3599999999999},{"$f":"AVERAGE(N6:N15)","v":4.92},{"$f":"AVERAGE(O6:O15)","v":5.2},{"$f":"AVERAGE(P6:P15)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":28.7},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":7},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$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.",5.8,8.1999999999999993,4.0999999999999996,1.7,70,81,6.2,0.5,"l",null,1.3,1008.3,2.6,13,null,null,1,null,1,null,56,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":4},{"$f":"COUNTIF(L18:L27,\"<1\")","v":4},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",4.2,6.6,2,0,74,83,7.5,8,"lT",null,".",1003.4,1.5,5,null,null,1,null,null,null,27,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":4},{"$f":"COUNTIF(L30:L39,\"<1\")","v":4},{"$f":"COUNTIF(L30:L39,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",3.3,4.5,0.9,0,85,85,7.7,".",null,null,".",1012,1.1000000000000001,4,null,null,null,null,null,null,24]
["14.",4.3,7.6,1.3,-1.1000000000000001,78,83,5.9,".",null,null,1.7,1023.8,1.7,4,null,null,null,null,null,null,26,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",6.4,8.3000000000000007,4.7,3.9,80,84,7.6,".",null,null,".",1026.8,3.9,1,null,null,null,null,null,null,19,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":10.199999999999999},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":14.4},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-3.9},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":10.6}]
["16.",5.3,8.1,3.1,0,82,84,7,0.1,"l",null,0.5,1025.2,3,2,null,null,1,null,null,null,19,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",3.7,6.7,-0.3,-3.3,85,85,5.0999999999999996,1.4,"l",null,".",1024.8,1.6,1,null,null,1,null,null,null,16,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":1.7},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":-1.5},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":62},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",2.5,5.6,-1.5,-3.9,75,83,6.3,0.4,"l",null,0.1,1018.7,-0.1,8,null,null,1,null,1,null,55]
["19.",4.2,5.9,2.6,0,76,83,7.3,3.1,"l",null,0.2,1010.7,1.5,16,null,null,1,null,1,null,48]
["20.",3.9,5.4,2.9,0.6,83,85,7.5,7.4,"l",null,0.1,1015.7,1.6,10,null,null,1,null,1,null,39]
["Su",{"$f":"SUM(B18:B27)","v":43.6},{"$f":"SUM(C18:C27)","v":66.900000000000006},{"$f":"SUM(D18:D27)","v":19.8},{"$f":"SUM(E18:E27)","v":-2.0999999999999996},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":20.9},"XX",null,{"$f":"SUM(L18:L27)","v":3.9000000000000004},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R18:R27)","v":7},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":4},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":4.3600000000000003},{"$f":"AVERAGE(C18:C27)","v":6.69},1.98,-0.20999999999999996,78.8,83.6,6.81,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1016.9400000000002},{"$f":"AVERAGE(N18:N27)","v":1.8399999999999999},{"$f":"AVERAGE(O18:O27)","v":6.4},{"$f":"AVERAGE(P18:P27)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":32.9}]
["21.",6.3,9.4,2.6,2.2000000000000002,84,85,7.9,3.9,"l",null,".",1011.3,3.8,6,null,null,1,null,null,null,35]
["22.",7.7,9.9,2.7,-1.1000000000000001,78,83,3.5,null,null,null,0.1,1010.9,4.0999999999999996,6,null,null,null,null,1,null,40]
["23.",7.2,11.6,2.1,-1.1000000000000001,67,79,3,null,null,null,0.3,1011.4,4.5,8,null,null,null,null,null,null,31]
["24.",9.4,14.4,6.3,2.8,67,80,6.8,1.8,"l",null,0.7,1012.6,6.1,9,null,null,1,null,1,null,39]
["25.",6.1,7.8,2.7,1.7,83,85,8,9.1999999999999993,"l",null,".",1010.4,2.8,4,null,null,1,null,null,null,27]
["26.",3.5,5.2,2.1,0,73,80,7.5,null,null,null,1.1000000000000001,1020.9,0.6,12,null,null,null,null,1,null,40]
["27.",4.2,6.5,2.5,0,62,79,6.7,0.2,"l",null,2.2999999999999998,1016.3,0.8,14,null,null,1,null,1,null,39]
["28.",5.0999999999999996,6.6,1.8,-1.7,78,83,6,0.4,"l",null,".",1007,2.4,7,null,null,1,null,null,null,34]
["29.",1.9,5.0999999999999996,-0.2,-2.8,79,85,2.8,null,null,null,0.5,1006.7,0.2,1,null,null,null,null,null,null,15]
["30.",1.7,3.3,-0.8,-3.3,79,84,5.7,0.2,"l",null,".",1005.4,-0.7,1,null,null,1,null,null,null,15]
["Su",{"$f":"SUM(B30:B39)","v":53.100000000000009},{"$f":"SUM(C30:C39)","v":79.799999999999983},{"$f":"SUM(D30:D39)","v":21.8},{"$f":"SUM(E30:E39)","v":-3.3},"XXX","XXX","XXX",{"$f":"SUM(I30:I39)","v":15.699999999999998},"XX",null,{"$f":"SUM(L30:L39)","v":5},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R39)","v":6},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":4},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":5.3100000000000005},7.9799999999999986,2.1800000000000002,-0.32999999999999996,75,82.3,5.7900000000000009,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":1011.29},{"$f":"AVERAGE(N30:N39)","v":2.46},{"$f":"AVERAGE(O30:O39)","v":6.8},{"$f":"AVERAGE(P30:P39)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":31.5}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":173.2},{"$f":"SUM(C16+C28+C40)","v":248.49999999999997},{"$f":"SUM(D16+D28+D40)","v":92.3},{"$f":"SUM(E16+E28+E40)","v":26.899999999999995},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I40)","v":50.099999999999994},"XX",null,{"$f":"SUM(L16+L28+L40)","v":14.1},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R40)","v":19},{"$f":"SUM(S16+S28+S40)","v":0},{"$f":"SUM(T16+T28+T40)","v":9},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":5.7733333333333317},8.2833333333333332,3.0766666666666662,0.89666666666666661,77.2,82.86666666666666,6.4866666666666664,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1015.1966666666668},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":3.0733333333333328},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":6.1333333333333337},{"$f":"AVERAGE(P17,P29,P41)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":31.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":19},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":15}]
["TTT",4.5,"XXXX",{"$f":"SUM(B43-B47)","v":1.2733333333333317},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":9},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":9}]
["RRR",56,{"$f":"SUM(I42*100/B48)","v":89.464285714285694},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":6},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",62,{"$f":"SUM(L42*100/B49)","v":22.741935483870968},"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.",270,{"$f":"SUM(L42*100/B51)","v":5.2222222222222223},"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":4},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":26},">/= 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":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:","November",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,1,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,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["04.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["05.",null,null,null,1,null,null,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,null,1,null,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,1,1,null,null,null,null,null,null,null,null," "," "," "," ",0]
["09.",null,null,1,1,null,null,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,1,1,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,null,null,null,null,null,null,null," "," "," "," ",0]
["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,1,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,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["19.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["20.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["21.","02:40:00",1,1,1,1,null,null,null,null,null,null,null,2.6666666666666665," ",2,3,2]
["22.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["23.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["24.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["25.",null,null,1,1,1,null,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,null,null,null,null,null,null,null," "," "," "," ",0]
["28.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["29.",null,null,null,null,1]
["30.",null,null,null,1,1]
["Su.",{"$f":"SUM(B9:B38)","v":"02:40:00"},1,11,21,26,1,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":1}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39)","v":1}]

{"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)"]
[]
["November 2017"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":14.4},"am","2017-11-24"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":5.7733333333333317},{"$f":"Kurztabelle!B47","v":4.5},{"$f":"C7-D7","v":1.2733333333333317},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":-1.5},"am","2017-11-18"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":50.099999999999994},{"$f":"Kurztabelle!B48","v":56},{"$f":"100/D9*C9","v":89.464285714285708},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":14.1},{"$f":"Kurztabelle!B49","v":62},{"$f":"100/D10*C10","v":22.741935483870964},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2017-11-01",8.8000000000000007,11.1,7.2,0.9,null,null,1020.6,7.4,"(Wa)","(H Vera)","Um 07:00 Uhr; Von 08:30 Uhr - 09:29 Uhr mäßiger Regen (WW 63)."]
["2017-11-02",10.199999999999999,14.3,7.7,0.2,null,0.8,1013,7.2,null,null,"Um 01:00 Uhr; 02:00 Uhr; 07:30 Uhr; 07:50 Uhr; 08:10 Uhr leichter Regen (WW 61)."]
["2017-11-03",8.9,12.6,4.5999999999999996,null,null,2.2999999999999998,1017.5,7]
["2017-11-04",6.9,10.6,2.8,null,null,2.1,1013.9,6.8]
["2017-11-05",7.7,9.6999999999999993,5.8,10.6,null,null,1009,6.6,"NWz","T Jürgen","Von 18:40 Uhr - 23:59 Uhr mäßiger Regen (WW 63)."]
["2017-11-06",6.6,7.4,5.9,0.4,null,null,1020.5,6.4,"U","T Karl","Von 00:00 Uhr - 00:14 Uhr; 02:55 Uhr - 03:14 Uhr; 07:50 Uhr - 08:29 Uhr mäßiger Regen (WW 63). Von 00:40 Uhr - 02:54 Uhr; 03:15 Uhr - 03:24 Uhr; 05:00 Uhr - 07:34 Uhr leichter Regen (WW 61)."]
["2017-11-07",6.9,8.6999999999999993,4.0999999999999996,null,null,null,1023.2,6.2,"BM","H Xandy"]
["2017-11-08",6.6,10,2.2999999999999998,0.1,null,null,1019.3,6]
["2017-11-09",6.3,7.6,5.2,null,null,null,1021.8,5.8]
["2017-11-10",7.6,9.8000000000000007,5.0999999999999996,1.3,null,null,1014.8,5.6,"Wz","T Michael"]
["2017-11-11",5.8,8.1999999999999993,4.0999999999999996,0.5,null,1.3,1008.3,5.4]
["2017-11-12",4.2,6.6,2,8,null,null,1003.4,5.2]
["2017-11-13",3.3,4.5,0.9,null,null,null,1012,5,"TrM","T Numa"]
["2017-11-14",4.3,7.6,1.3,null,null,1.7,1023.8,4.8,"BM","H Yaprak"]
["2017-11-15",6.4,8.3000000000000007,4.7,null,null,null,1026.8,4.5999999999999996]
["2017-11-16",5.3,8.1,3.1,0.1,null,0.5,1025.2,4.45]
["2017-11-17",3.7,6.7,2.6,1.4,null,null,1024.8,4.25]
["2017-11-18",2.5,5.6,-1.5,0.4,null,0.1,1018.7,4.0999999999999996,"NWz","T Peter"]
["2017-11-19",4.2,5.9,2.6,3.1,null,0.2,1010.7,3.95]
["2017-11-20",3.9,5.4,2.9,7.4,null,0.1,1015.7,3.75]
["2017-11-21",6.3,9.4,2.6,3.9,null,null,1011.3,3.6,"SWz","T Reinhard"]
["2017-11-22",7.7,9.9,2.7,null,null,0.1,1010.9,3.45]
["2017-11-23",7.2,11.6,2.1,null,null,0.3,1011.4,3.3]
["2017-11-24",9.4,14.4,6.3,1.8,null,0.7,1012.6,3.15]
["2017-11-25",6.1,7.8,2.7,9.1999999999999993,null,null,1010.4,3]
["2017-11-26",3.5,5.2,2.1,null,null,1.1000000000000001,1020.9,2.85]
["2017-11-27",4.2,6.5,2.5,0.2,null,2.2999999999999998,1016.3,2.7]
["2017-11-28",5.0999999999999996,6.6,1.8,0.4,null,null,1007,2.5499999999999998]
["2017-11-29",1.9,5.0999999999999996,-0.2,null,null,0.5,1006.7,2.4]
["2017-11-30",1.7,3.3,-0.8,0.2,null,null,1005.4,2.25]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":5.7733333333333317},{"$f":"AVERAGE(C2:C31)","v":8.2833333333333332},{"$f":"AVERAGE(D2:D31)","v":3.1733333333333325},"-",null,{"$f":"AVERAGE(G2:G31)","v":0.93999999999999984},{"$f":"AVERAGE(H2:H31)","v":1015.1966666666668},{"$f":"AVERAGE(I2:I31)","v":4.6583333333333332}]
["Mittel",4.5,null,null,56,"-",62,1016.4]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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:","November",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.","6,1 °C/8,9 °C/7,8 °C","7,8 °C/8,9 °C/8,9 °C","8,3 °C/8,9 °C/8,9 °C","9,4 °C/9,4 °C/9,4 °C","t","> 50 cm","> 50 cm"]
["02.","7,2 °C/14,4 °C/8,9 °C","8,9 °C/10,6 °C/10,0 °C","8,9 °C/9,4 °C/10,0 °C","9,4 °C/9,4 °C/9,4 °C","t","> 50 cm","> 50 cm"]
["03.","7,8 °C/13,3 °C/1,7 °C","9,4 °C/11,1 °C/8,9 °C","9,4 °C/10,6 °C/9,4 °C","10,0 °C/10,0 °C/10,0 °C","n","> 50 cm","> 50 cm","< 35 cm>"]
["04.","1,7 °C/10,0 °C/5,6 °C","6,7 °C/8,3 °C/7,8 °C","7,8 °C/8,3 °C/8,3 °C","9,4 °C/9,4 °C/8,9 °C","n","> 50 cm","> 50 cm"]
["05.","5,0 °C/11,1 °C/7,2 °C","7,2 °C/8,3 °C/8,3 °C","7,8 °C/8,3 °C/8,3 °C","8,9 °C/8,9 °C/8,9 °C","t","> 50 cm","> 50 cm"]
["06.","5,6 °C/7,2 °C/6,1 °C","7,8 °C/8,3 °C/8,3 °C","8,3 °C/8,3 °C/8,3 °C","8,9 °C/8,9 °C/8,9 °C","t","> 50 cm","> 50 cm"]
["07.","6,1 °C/9,4 °C/3,9 °C","7,8 °C/8,9 °C/8,3 °C","8,3 °C/8,9 °C/8,3 °C","8,9 °C/8,9 °C/8,9 °C","t","> 50 cm","> 50 cm"]
["08.","5,6 °C/8,9 °C/6,1 °C","6,7 °C/8,3 °C/8,3 °C","7,2 °C/8,3 °C/8,3 °C","8,9 °C/8,3 °C/8,9 °C","n","> 50 cm","> 50 cm"]
["09.","5,0 °C/7,2 °C/6,7 °C","7,8 °C/8,3 °C/8,3 °C","7,8 °C/8,3 °C/8,3 °C","8,9 °C/8,9 °C/8,9 °C","t","> 50 cm","> 50 cm"]
["10.","6,7 °C/10,0 °C/5,6 °C","7,8 °C/8,3 °C/7,8 °C","7,8 °C/8,3 °C/8,3 °C","8,9 °C/8,3 °C/8,9 °C","t","> 50 cm","> 50 cm"]
["11.","3,3 °C/7,8 °C/3,9 °C","6,1 °C/7,2 °C/6,7 °C","6,7 °C/7,2 °C/7,2 °C","8,3 °C/8,3 °C/8,3 °C","n","> 50 cm","> 50 cm"]
["12.","0,0 °C/5,6 °C/2,8 °C","5,6 °C/6,7 °C/6,1 °C","6,7 °C/6,7 °C/6,7 °C","7,8 °C/7,8 °C/7,8 °C","t","> 50 cm","< 10 > 50 cm"]
["13.","2,8 °C/4,4 °C/3,3 °C","5,6 °C/6,1 °C/5,6 °C","6,1 °C/6,1 °C/6,1 °C","7,2 °C/7,2 °C/7,2 °C","t","> 50 cm","< 10 > 50 cm"]
["14.","2,8 °C/5,6 °C/3,9 °C","5,0 °C/6,1 °C/5,6 °C","5,6 °C/6,1 °C/6,1 °C","7,2 °C/7,2 °C/7,2 °C","n","> 50 cm","< 9 > 50 cm"]
["15.","4,4 °C/8,3 °C/6,1 °C","5,6 °C/7,2 °C/7,2 °C","6,1 °C/6,7 °C/7,2 °C","7,2 °C/7,2 °C/7,2 °C","t","> 50 cm","> 50 cm"]
["16.","3,3 °C/7,2 °C/3,3 °C","6,1 °C/6,7 °C/6,1 °C","6,7 °C/6,7 °C/6,7 °C","7,8 °C/7,8 °C/7,8 °C","t","> 50 cm","> 50 cm"]
["17.","3,3 °C/6,7 °C/-2,2 °C","5,6 °C/6,7 °C/5,0 °C","6,1 °C/6,7 °C/6,1 °C","7,2 °C/7,2 °C/7,2 °C","n","> 50 cm","< 8 > 50 cm"]
["18.","-3,3 °C/3,9 °C/2,2 °C","3,3 °C/5,0 °C/4,4 °C","4,4 °C/5,0 °C/5,0 °C","6,7 °C/6,7 °C/6,7 °C","n","> 50 cm","< 21 > 50 cm"]
["19.","1,1 °C/6,1 °C/3,3 °C","3,9 °C/5,0 °C/5,0 °C","4,4 °C/5,0 °C/5,0 °C","6,1 °C/6,1 °C/6,1 °C","t","> 50 cm","< 22 > 50 cm"]
["20.","2,8 °C/4,4 °C/1,7 °C","4,4 °C/5,0 °C/5,0 °C","5,0 °C/5,0 °C/5,0 °C","6,1 °C/6,1 °C/6,1 °C","t","> 50 cm","< 20 > 50 cm"]
["21.","3,3 °C/8,9 °C/7,2 °C","4,4 °C/6,1 °C/6,7 °C","5,0 °C/5,6 °C/6,7 °C","6,1 °C/6,1 °C/6,7 °C","t","> 50 cm","> 50 cm"]
["22.","6,1 °C/10,0 °C/1,1 °C","6,7 °C/7,8 °C/6,1 °C","6,7 °C/7,2 °C/6,7 °C","6,7 °C/7,2 °C/7,2 °C","n","> 50 cm","> 50 cm"]
["23.","2,8 °C/8,3 °C/5,0 °C","4,4 °C/6,1 °C/6,1 °C","5,0 °C/6,1 °C/6,1 °C","6,7 °C/6,7 °C/6,7 °C","n","> 50 cm","> 50 cm"]
["24.","4,4 °C/11,1 °C/8,3 °C","5,6 °C/7,2 °C/7,2 °C","5,6 °C/6,7 °C/7,2 °C","6,7 °C/6,7 °C/6,7 °C","t","> 50 cm","> 50 cm"]
["25.","7,2 °C/6,7 °C/2,2 °C","7,2 °C/7,2 °C/6,1 °C","7,2 °C/7,2 °C/6,7 °C","7,2 °C/7,2 °C/7,2 °C","t","> 50 cm","> 50 cm"]
["26.","1,7 °C/5,0 °C/2,8 °C","5,0 °C/5,0 °C/4,4 °C","6,7 °C/5,6 °C/5,6 °C","7,2 °C/6,7 °C/6,7 °C","t","> 50 cm","< 12 > 50 cm"]
["27.","1,7 °C/5,0 °C/2,8 °C","4,4 °C/4,4 °C/4,4 °C","5,0 °C/5,0 °C/5,0 °C","6,1 °C/6,1 °C/6,1 °C","t","> 50 cm","< 20 > 50 cm"]
["28.","4,4 °C/5,6 °C/1,1 °C","4,4 °C/5,6 °C/5,0 °C","5,0 °C/5,6 °C/5,6 °C","6,1 °C/6,1 °C/6,1 °C","n","> 50 cm","< 10 > 50 cm"]
["29.","-0,6 °C/5,0 °C/-0,6 °C","3,3 °C/4,4 °C/3,9 °C","4,4 °C/4,4 °C/4,4 °C","6,1 °C/5,6 °C/5,6 °C","n","> 50 cm","< 27 > 50 cm"]
["30.","1,1 °C/5,0 °C/-0,6 °C","3,3 °C/4,4 °C/3,9 °C","3,9 °C/4,4 °C/4,4 °C","5,6 °C/5,6 °C/5,6 °C","n","> 50 cm","< 28 > 50 cm"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]