{"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",82,1009.8,-1.9,0,null,"00",82,1002.2,1.9,5]
["01",84,1010,-1.9,0,null,"01",83,1001.4,1.9,6]
["02",79,1010.2,-2.1,1,null,"02",83,1000.1,2.5,7]
["03",81,1010.2,-2.5,1,null,"03",85,999.8,2.6,8]
["04",83,1010.4,-2.9,1,null,"04",86,999.1,3.5,8]
["05",84,1010.1,-2.7,1,null,"05",86,998.4,3.5,8]
["06",86,1010,-3.2,5,null,"06",85,997.8,3.1,8]
["07",85,1010.4,-2.2999999999999998,6,null,"07",86,997.8,3.1,7]
["08",86,1010.5,-1.2,7,null,"08",83,997.7,3.1,8]
["09",79,1010.3,0.6,7,null,"09",83,997.6,3.7,8]
["10",67,1009.9,2.5,6,null,"10",81,997.1,4.5999999999999996,8]
["11",54,1009.1,2.2999999999999998,7,null,"11",80,997,5,8]
["12",51,1008.4,2.6,6,null,"12",82,996.6,6.3,8]
["13",48,1007.6,2.2000000000000002,6,null,"13",80,997.4,5,8]
["14",45,1006.7,1,6,null,"14",87,997.5,5.3,8]
[15,44,1005.6,1.2,5,null,"15",92,997.6,5.3,8]
["16",43,1004.8,0.6,5,null,"16",91,997.6,5,8]
["17",46,1004.3,0.6,6,null,"17",84,997.6,3.8,8]
[18,51,1004.2,0.6,5,null,"18",82,997.9,3.2,8]
["19",59,1004,0.3,4,null,"19",84,997.8,2.7,8]
["20",64,1003.7,0.3,4,null,"20",84,998.5,2.6,8]
["21",71,1003.3,1.1000000000000001,1,null,"21",85,998.5,2.1,8]
["22",75,1003.1,0.9,1,null,"22",87,998.8,1.4,8]
["23",80,1002.9,1.3,3,null,"23",88,998.8,0.5,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":67.8},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":1007.5},{"$f":"AVERAGE(D3:D26)","v":-0.10833333333333328},{"$f":"ROUND(AVERAGE(E3:E26),1)","v":3.9},null,"Mittel",{"$f":"ROUND(AVERAGE(H3:H26),1)","v":84.5},{"$f":"ROUND(AVERAGE(I3:I26),1)","v":998.4},{"$f":"AVERAGE(J3:J26)","v":3.4041666666666663},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":7.7}]
[]
[null,null,null,"2018-03-30",null,null,null,null,null,"2018-03-31"]
[null,null,null,null,null,null,null,null,null,"G 176,3"]
[]
["Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",78,1010.9,-1.7,7,null,"00",93,998.1,4.8,8]
["01",78,1010.5,-1.4,7,null,"01",89,997.9,5.2,8]
["02",78,1009.9,-1.4,8,null,"02",85,998.2,5.4,8]
["03",79,1009.3,-1.4,8,null,"03",83,998.6,5.4,8]
["04",79,1008.8,-1.2,8,null,"04",81,1000.2,3.7,8]
["05",77,1008.4,-1,8,null,"05",77,1001.1,2.4,8]
["06",80,1008.3,-0.7,8,null,"06",76,1002.2,2,7]
["07",81,1007.9,-0.3,8,null,"07",71,1003.4,0.5,7]
["08",80,1007.3,0.2,8,null,"08",72,1004.8,0.3,6]
["09",77,1006.8,1.7,8,null,"09",68,1005.3,-0.2,7]
["10",78,1006.2,1.6,8,null,"10",69,1006.1,0.2,7]
["11",76,1006,1.6,8,null,"11",58,1006.3,-0.8,7]
["12",81,1005.4,2.8,8,null,"12",54,1006.4,-1.2,7]
["13",76,1005,3,8,null,"13",50,1006.6,-1,7]
["14",78,1004.8,3.5,8,null,"14",53,1006.8,-1,7]
["15",76,1004.1,4.0999999999999996,8,null,"15",56,1006.9,0,7]
["16",81,1003.6,4.3,8,null,"16",54,1006.8,-0.8,7]
["17",84,1003,4.5,8,null,"17",55,1006.8,-0.6,6]
["18",89,1002.5,4.7,8,null,"18",57,1007.1,-0.8,4]
["19",90,1002,4,8,null,"19",60,1007.9,-1.5,7]
["20",86,1001.5,4.0999999999999996,8,null,"20",69,1008.4,-1.4,4]
["21",87,1000.6,4,8,null,"21",67,1009.3,-1.7,7]
["22",89,999.8,4.7,8,null,"22",73,1009.5,-0.8,4]
["23",91,999.3,5.0999999999999996,8,null,"23",79,1009.5,-1.2,1]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":81.2},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":1005.5},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1.9},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":7.9},null,"Mittel",{"$f":"ROUND(AVERAGE(H33:H56),1)","v":68.7},{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1004.8},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":0.7},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":6.5}]
[]
[null,null,null,"2018-03-28",null,null,null,null,null,"2018-03-29"]

{"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:","März",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.6999999999999993,-2.1,-14.2,-16.100000000000001,40,65,0.8,".",null,null,6.7,1017.8,-14.4,7,0,null,null,null,null,null,31,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.9,-1.3,-12.8,-14.4,50,65,4.2,0,"T",null,1.5,1005.5,-12.6,7,0,null,null,null,null,null,27,null,null,null,null,{"$f":"COUNTIF(C6:C15,\">=30\")","v":0},{"$f":"COUNTIF(C6:C15,\">=25\")","v":0},{"$f":"COUNTIF(C6:C15,\"<0\")","v":3},null,{"$f":"COUNTIF(I6:I15,\">=0,1\")","v":3},{"$f":"COUNTIF(I6:I15,\">=1\")","v":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":1},{"$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.",-7.2,-1.2,-12.4,-13.9,45,63,2.9,".",null,null,1.4,1004.8,-13.2,3,0,null,null,null,null,null,23,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":0},{"$f":"COUNTIF(C18:C27,\"<0\")","v":3},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":7},{"$f":"COUNTIF(I18:I27,\">=1\")","v":4},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$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.",-2.4,4.4000000000000004,-10.199999999999999,-12.8,35,56,3.5,".",null,null,3.7,1005,-10.4,9,0,null,null,null,null,null,31,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":4},{"$f":"COUNTIF(I30:I40,\">=1\")","v":2},{"$f":"COUNTIF(I30:I40,\">=3\")","v":0},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",0.3,3.9,-2,-3.9,62,72,6.7,".",null,null,".",1000.9,-4.2,11,0,null,null,null,null,null,34]
["06.",0.5,3,-1.9,-3.9,75,87,7.4,6.6,"Tl",null,".",994.2,-1.5,4,0,null,1,null,null,null,26,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.",2.8,7.1,-0.9,-2.2000000000000002,75,87,7.3,1.3,"Tl",null,0.2,995,0.7,5,3,"T",1,null,null,null,34,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":7},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":4},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":2},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":2}]
["08.",6.4,10.1,3,-1.7,46,65,5.6,0,"l",null,2.7,1003.5,0,12,0,null,null,null,1,null,44,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":6},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":1},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":4},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":1}]
["09.",5.6,9.9,2.9,0,41,63,3.6,0.8,"l",null,7,1008,1,10,0,null,1,null,1,null,44,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":6},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":3},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",8,14.9,1.9,0,62,79,7.6,0,"l",null,1.1000000000000001,1006.5,4.4000000000000004,6,0,null,null,null,null,null,27]
["Su",{"$f":"SUM(B6:B15)","v":-1.5999999999999979},{"$f":"SUM(C6:C15)","v":48.699999999999996},{"$f":"SUM(D6:D15)","v":-46.599999999999994},{"$f":"SUM(E6:E15)","v":-68.900000000000006},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":8.6999999999999993},"XX",null,{"$f":"SUM(L6:L15)","v":24.3},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":3},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":2},{"$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":-0.15999999999999978},{"$f":"AVERAGE(C6:C15)","v":4.8699999999999992},-4.6599999999999993,-6.8900000000000006,53.1,70.2,4.96,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M6:M15)","v":1004.1200000000001},{"$f":"AVERAGE(N6:N15)","v":-5.0200000000000005},{"$f":"AVERAGE(O6:O15)","v":7.4},{"$f":"AVERAGE(P6:P15)","v":0.3},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":32.1},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":2},{"$f":"COUNTIF(L6:L15,\"<1\")","v":1},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":1},{"$f":"COUNTIF(P6:P15,\">=3\")","v":1},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",10.9,17.2,6.8,3.3,52,74,6.5,".",null,null,3.4,1001,6.4,6,0,null,null,null,null,null,29,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":4},{"$f":"COUNTIF(L18:L27,\"<1\")","v":1},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":3},{"$f":"COUNTIF(P18:P27,\">=3\")","v":3},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",8.4,10.1,6.2,2.8,77,87,7.6,11.7,"l",null,".",993.3,6.4,5,0,null,1,null,null,null,32,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":4},{"$f":"COUNTIF(L30:L40,\"<1\")","v":2},{"$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.",9.1999999999999993,12.2,6.8,3.3,57,72,6.6,1.1000000000000001,"l",null,0.2,1001,4.4000000000000004,11,0,null,1,null,1,null,44]
["14.",3.6,6.8,1.8,1.1000000000000001,75,85,8,0.8,"l",null,".",1011,1.4,5,0,null,1,null,1,null,39,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",4.3,10.1,-1.6,-3.9,51,77,4.9000000000000004,0.3,"l",null,3.5,1007.6,0.2,8,0,null,1,null,null,null,37,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":10.9},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":17.2},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-16.100000000000001},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":11.7}]
["16.",1.1000000000000001,3.8,-2.8,-2.8,80,89,8,5.8,"Tl",null,".",1004.7,-0.5,7,0,null,1,null,null,null,25,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",-4.9000000000000004,-2.8,-5.8,-5.6,73,81,8,0.4,"T",null,".",1010.5,-7.6,15,6,"T",1,null,1,null,44,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-8.6999999999999993},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-14.2},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":35},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":6}]
["18.",-5.3,-2.7,-8.1,-8.3000000000000007,51,62,7.6,".",null,null,9,1014.2,-11.5,19,5,"D",null,null,1,null,45]
["19.",-4.4000000000000004,-0.2,-10.3,-12.2,46,59,3.7,".",null,null,8.9,1014.3,-11.4,6,5,"D",null,null,null,null,29]
["20.",-2.4,3,-8.3000000000000007,-10.6,39,69,5.3,1.4,"T",null,3.5,1015.8,-7.7,5,0,"F",1,null,null,null,26]
["Su",{"$f":"SUM(B18:B27)","v":20.5},{"$f":"SUM(C18:C27)","v":57.499999999999993},{"$f":"SUM(D18:D27)","v":-15.300000000000002},{"$f":"SUM(E18:E27)","v":-32.9},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":21.499999999999996},"XX",null,{"$f":"SUM(L18:L27)","v":28.5},"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":2.0499999999999998},{"$f":"AVERAGE(C18:C27)","v":5.7499999999999991},-1.5300000000000002,-3.29,60.1,75.5,6.62,"XXX","XX",null,"XXX",{"$f":"AVERAGE(M18:M27)","v":1007.3399999999999},{"$f":"AVERAGE(N18:N27)","v":-1.9899999999999998},{"$f":"AVERAGE(O18:O27)","v":8.6999999999999993},{"$f":"AVERAGE(P18:P27)","v":1.6},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":35}]
["21.",-0.7,3.5,-5.0999999999999996,-7.8,49,71,3,".",null,null,5.3,1026.9000000000001,-5.5,5,2,"D",null,null,null,null,23]
["22.",1.4,4,-2.4,-4.4000000000000004,50,70,7.7,1.2,"Tl",null,".",1016.4,-3.7,8,0,"F",1,null,1,null,40]
["23.",2.6,4.0999999999999996,1.7,1.1000000000000001,77,86,7.8,".",null,null,".",1008.1,0.5,3,0,"F",null,null,null,null,21]
["24.",3.2,8.9,-2.2000000000000002,-5,50,74,5.2,".",null,null,4.7,1006.1,-1.3,2,0,"R",null,null,null,null,18]
["25.",2.8,8,-2.2999999999999998,-5,58,74,2,".",null,null,8.3000000000000007,1008.8,-1.4,6,0,"R",null,null,null,null,31]
["26.",3.6,8.6999999999999993,-0.5,-3.3,57,80,7.5,0.1,"l",null,".",1013.1,0.3,2,0,"R",1,null,null,null,24]
["27.",3.7,7.8,1.3,1.7,46,74,6.2,".",null,null,3.2,1014.9,-0.6,3,0,"R",null,null,null,null,24]
["28.",4.9000000000000004,8.3000000000000007,1.5,0,73,81,7.9,1.9,"l",null,".",1005.5,1.9,6,0,"R",1,null,1,null,39]
["29.",6.2,9.5,4.8,3.9,48,69,6.5,".",null,null,0.3,1004.8,0.7,9,0,"R",null,null,1,null,44]
["30.",5.9,13.2,-1.2,-3.9,42,68,3.9,0,"l",null,8.1999999999999993,1007.5,-0.1,5,0,"R",null,null,null,null,32]
["31.",5.8,9.9,2.2999999999999998,2.2000000000000002,76,84,7.7,0.9,"l",null,0.1,998.4,3.4,4,0,"R",1,null,null,null,34]
["Su",{"$f":"SUM(B30:B40)","v":39.4},{"$f":"SUM(C30:C40)","v":85.9},{"$f":"SUM(D30:D40)","v":-2.1000000000000005},{"$f":"SUM(E30:E40)","v":-20.500000000000004},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":4.1000000000000005},"XX",null,{"$f":"SUM(L30:L40)","v":30.1},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":4},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":3},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":3.5818181818181816},7.8090909090909095,-0.19090909090909094,-1.863636363636364,56.909090909090907,75.545454545454547,5.9454545454545462,"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1010.0454545454545},{"$f":"AVERAGE(N30:N40)","v":-0.52727272727272723},{"$f":"AVERAGE(O30:O40)","v":4.8181818181818183},{"$f":"AVERAGE(P30:P40)","v":0.18181818181818182},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":30}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":58.3},{"$f":"SUM(C16+C28+C41)","v":192.1},{"$f":"SUM(D16+D28+D41)","v":-64},{"$f":"SUM(E16+E28+E41)","v":-122.30000000000001},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":34.299999999999997},"XX",null,{"$f":"SUM(L16+L28+L41)","v":82.9},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":14},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":9},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":1.8806451612903228},6.1967741935483867,-2.064516129032258,-3.9451612903225803,56.70967741935484,73.806451612903231,5.8451612903225802,"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1007.2612903225807},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":-2.4483870967741934},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":6.903225806451613},{"$f":"AVERAGE(P17,P29,P42)","v":0.69393939393939397},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":32.366666666666667}]
[]
[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":14},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":10}]
["TTT",4.5,"XXXX",{"$f":"SUM(B44-B48)","v":-2.6193548387096772},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":8},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":4}]
["RRR",45,{"$f":"SUM(I43*100/B49)","v":76.222222222222214},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":3},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",113,{"$f":"SUM(L43*100/B50)","v":73.362831858407077},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":6},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":5}]
["mgl.",366,{"$f":"SUM(L43*100/B52)","v":22.650273224043715},"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":4}]
["sss",null,null,"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":19},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":9},">/= 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":3}]
[]
[]
[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:","März",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,1,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,1,null,null,null,null,null,null,null," "," "," "," ",0]
["06.",null,null,1,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,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["09.",null,null,null,null,1,1,null,null,null,null,null,null," "," "," "," ",0]
["10.",null,null,null,1,1,1,null,null,null,null,null,null," "," "," "," ",0]
["11.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["12.",null,null,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["13.",null,null,null,null,1,1,1,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,null,null,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,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.",null,null,null,null,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,1,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["24.",null,null,1,1,1,null,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.",null,null,1,1,1]
["28.",null,null,1,1,1]
["29.",null,null,1,1,1]
["30.",null,null,null,null,1,null,null,null,null,null,null,null," "," "," "," ",0]
["31.",null,null,null,1,1,null,null,null,null,null,null,null," "," "," "," ",0]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,12,21,28,4,1]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":4}]

{"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)"]
[]
["März 2018"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":17.2},"am","2018-03-11"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":1.8806451612903228},{"$f":"Kurztabelle!B48","v":4.5},{"$f":"C7-D7","v":-2.6193548387096772},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-14.2},"am","2018-03-01"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":34.299999999999997},{"$f":"Kurztabelle!B49","v":45},{"$f":"100/D9*C9","v":76.222222222222214},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":82.9},{"$f":"Kurztabelle!B50","v":113},{"$f":"100/D10*C10","v":73.362831858407091},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":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-03-01",-8.6999999999999993,-2.1,-14.2,null,null,6.7,1017.8,1.5,"(HNFz)","(H Hartmut)"]
["2018-03-02",-6.9,-1.3,-12.8,null,null,1.5,1005.5,1.65]
["2018-03-03",-7.2,-1.2,-12.4,null,null,1.4,1004.8,1.8,"TrW","T Ulrike"]
["2018-03-04",-2.4,4.4000000000000004,-10.199999999999999,null,null,3.7,1005,1.95]
["2018-03-05",0.3,3.9,-2,null,null,null,1000.9,2.15]
["2018-03-06",0.5,3,-1.9,6.6,0,null,994.2,2.35,"TrM","T Wiebke"]
["2018-03-07",2.8,7.1,-0.9,1.3,3,0.2,995,2.5499999999999998]
["2018-03-08",6.4,10.1,3,null,0,2.7,1003.5,2.75,"Ws","T Xenia"]
["2018-03-09",5.6,9.9,2.9,0.8,null,7,1008,2.95]
["2018-03-10",8,14.9,1.9,null,null,1.1000000000000001,1006.5,3.15,"TrW","T Yuliya"]
["2018-03-11",10.9,17.2,6.8,null,null,3.4,1001,3.35]
["2018-03-12",8.4,10.1,6.2,11.7,null,null,993.3,3.55,"Ws"]
["2018-03-13",9.1999999999999993,12.2,6.8,1.1000000000000001,null,0.2,1001,3.75]
["2018-03-14",3.6,6.8,1.8,0.8,null,null,1011,3.95,"U"]
["2018-03-15",4.3,10.1,-1.6,0.3,null,3.5,1007.6,4.1500000000000004,"HNFz","H Irenäus"]
["2018-03-16",1.1000000000000001,3.8,-2.8,5.8,0,null,1004.7,4.3499999999999996]
["2018-03-17",-4.9000000000000004,-2.8,-5.8,0.4,6,null,1010.5,4.55]
["2018-03-18",-5.3,-2.7,-8.1,null,5,9,1014.2,4.75]
["2018-03-19",-4.4000000000000004,-0.2,-10.3,null,5,8.9,1014.3,4.9000000000000004,"NEa"]
["2018-03-20",-2.4,3,-8.3000000000000007,1.4,0,3.5,1015.8,5.05]
["2018-03-21",-0.7,3.5,-5.0999999999999996,null,2,5.3,1026.9000000000001,5.2,"BM"]
["2018-03-22",1.4,4,-2.4,1.2,0,null,1016.4,5.35]
["2018-03-23",2.6,4.0999999999999996,1.7,null,null,null,1008.1,5.5]
["2018-03-24",3.2,8.9,-2.2000000000000002,null,null,4.7,1006.1,5.65,"Ww","H Jost"]
["2018-03-25",2.8,8,-2.2999999999999998,null,null,8.3000000000000007,1008.8,5.8]
["2018-03-26",3.6,8.6999999999999993,-0.5,0.1,null,null,1013.1,5.95,null,"T Carola"]
["2018-03-27",3.7,7.8,1.3,null,null,3.2,1014.9,6.1,"Wz","T Elisabeth"]
["2018-03-28",4.9000000000000004,8.3000000000000007,1.5,1.9,null,null,1005.5,6.25,"HNz"]
["2018-03-29",6.2,9.5,4.8,null,null,0.3,1004.8,6.4]
["2018-03-30",5.9,13.2,-1.2,null,null,null,1007.5,6.55,"HNFz"]
["2018-03-31",5.8,9.9,2.2999999999999998,0.9,null,0.1,998.4,6.7,"TM","T Franziska"]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":1.8806451612903228},{"$f":"AVERAGE(C2:C32)","v":6.1967741935483867},{"$f":"AVERAGE(D2:D32)","v":-2.064516129032258},"-",null,{"$f":"AVERAGE(G2:G32)","v":3.7349999999999994},{"$f":"AVERAGE(H2:H32)","v":1007.2612903225807},{"$f":"AVERAGE(I2:I32)","v":4.2129032258064516}]
["Mittel",4.5,null,null,45,"-",113,1016.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:","März",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.","-15,0 °C/1,1 °C/-9,4 °C","-4,4 °C/-2,2 °C/-2,8 °C","-2,8 °C/-1,7 °C/-1,7 °C","0,0 °C/0,0 °C/0,0 °C","h","35 cm"]
["02.","-13,3 °C/1,7 °C/-6,1 °C","-4,4 °C/-1,7 °C/-1,7 °C","-2,8 °C/-1,7 °C/-1,1 °C","0,0 °C/0,0 °C/0,0 °C","n","35 cm"]
["03.","-13,9 °C/2,2 °C/-8,9 °C","-3,9 °C/-1,7 °C/-2,2 °C","-2,2 °C/-1,7 °C/-1,7 °C","0,0 °C/0,0 °C/0,0 °C","n","35 cm"]
["04.","-6,1 °C/7,2 °C/-2,8 °C","-3,3 °C/-0,6 °C/-1,1 °C","-2,2 °C/-1,1 °C/-1,1 °C","0,0 °C/0,0 °C/0,0 °C","n","35 cm"]
["05.","-1,7 °C/6,7 °C/-2,2 °C","-1,1 °C/-0,6 °C/-0,6 °C","-1,1 °C/-0,6 °C/-0,6 °C","0,0 °C/0,0 °C/0,0 °C","t","35 cm"]
["06.","-0,6 °C/2,2 °C/0,0 °C","-0,6 °C/-0,6 °C/0,0 °C","-0,6 °C/-0,6 °C/-0,6 °C","0,0 °C/0,0 °C/0,0 °C","t","< 4; 35 >"]
["07.","-0,6 °C/4,4 °C/3,3 °C","0,0 °C/0,0 °C/0,0 °C","-0,6 °C/-0,6 °C/-0,6 °C","0,0 °C/-0,6 °C/0,0 °C","t","< 10; 40 >"]
["08.","3,3 °C/10,6 °C/3,9 °C","0,0 °C/0,0 °C/0,0 °C","0,0 °C/0,0 °C/0,0 °C","0,0 °C/0,0 °C/0,0 °C","n","< 10; 35 >"]
["09.","1,7 °C/12,2 °C/1,1 °C","0,0 °C/0,6 °C/0,0 °C","0,0 °C/0,0 °C/0,0 °C","0,0 °C/0,0 °C/0,0 °C","n","< 20; 35 >"]
["10.","3,9 °C/18,3 °C/6,7 °C","0,0 °C/1,7 °C/1,1 °C","0,0 °C/0,0 °C/0,0 °C","0,0 °C/0,0 °C/0,0 °C","t","< 20; 35 >"]
["11.","5,6 °C/20,0 °C/7,2 °C","1,1 °C/5,0 °C/2,8 °C","0,0 °C/1,7 °C/1,1 °C","0,0 °C/0,0 °C/0,0 °C","t","< 35 cm >","4 cm"]
["12.","5,0 °C/10,0 °C/7,2 °C","1,7 °C/2,8 °C/3,3 °C","0,6 °C/1,7 °C/2,2 °C","0,0 °C/0,6 °C/0,6 °C","t","> 50 cm","3 cm"]
["13.","6,7 °C/12,2 °C/6,7 °C","2,2 °C/5,0 °C/3,9 °C","1,1 °C/2,8 °C/3,3 °C","0,6 °C/1,1 °C/1,7 °C","t","> 50 cm","6 cm"]
["14.","2,8 °C/5,6 °C/2,2 °C","2,8 °C/4,4 °C/3,9 °C","2,8 °C/3,3 °C/3,9 °C","2,2 °C/2,2 °C/2,8 °C","t","> 50 cm"]
["15.","-2,2 °C/11,1 °C/2,2 °C","1,7 °C/5,6 °C/4,4 °C","2,8 °C/3,9 °C/3,9 °C","2,8 °C/2,8 °C/3,3 °C","n","> 50 cm"]
["16.","2,8 °C/1,1 °C/-1,7 °C","3,3 °C/3,3 °C/2,2 °C","3,3 °C/3,3 °C/2,8 °C","3,3 °C/3,3 °C/3,3 °C","n","> 50 cm"]
["17.","-5,0 °C/-3,3 °C/-5,0 °C","1,7 °C/1,7 °C/1,1 °C","2,2 °C/2,2 °C/1,7 °C","2,8 °C/2,8 °C/2,8 °C","t","7 cm"]
["18.","-7,8 °C/-0,6 °C/-5,6 °C","0,6 °C/1,1 °C/0,6 °C","1,7 °C/1,7 °C/1,1 °C","2,8 °C/2,2 °C/2,2 °C","t","8 cm"]
["19.","-10,0 °C/5,0 °C/-3,9 °C","0,0 °C/1,1 °C/0,6 °C","1,1 °C/1,1 °C/1,1 °C","2,2 °C/2,2 °C/2,2 °C","n","8 cm"]
["20.","-7,8 °C/5,6 °C/-1,1 °C","0,0 °C/1,1 °C/0,6 °C","0,6 °C/1,1 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","n","5 cm"]
["21.","-6,7 °C/4,4 °C/-2,8 °C","0,6 °C/1,1 °C/1,1 °C","0,6 °C/1,7 °C/1,1 °C","1,7 °C/1,7 °C/1,7 °C","n","5 cm"]
["22.","1,1 °C/3,1 °C/1,1 °C","0,6 °C/1,1 °C/1,7 °C","1,1 °C/1,1 °C/1,7 °C","1,7 °C/1,7 °C/1,7 °C","t","> 50 cm"]
["23.","1,7 °C/6,1 °C/-0,6 °C","1,7 °C/3,3 °C/2,8 °C","1,7 °C/2,8 °C/2,8 °C","1,7 °C/2,2 °C/2,2 °C","t","> 50 cm"]
["24.","-2,8 °C/10,6 °C/-1,7 °C","1,1 °C/5,0 °C/3,9 °C","1,7 °C/3,9 °C/3,9 °C","2,2 °C/2,8 °C/3,3 °C","n","> 50 cm"]
["25.","0,0 °C/13,3 °C/-2,2 °C","1,7 °C/5,6 °C/3,9 °C","2,2 °C/3,9 °C/3,9 °C","2,8 °C/2,8 °C/3,3 °C","n","> 50 cm"]
["26.","1,1 °C/7,8 °C/3,3 °C","2,2 °C/5,0 °C/4,4 °C","2,8 °C/3,9 °C/4,4 °C","3,3 °C/3,3 °C/3,9 °C","t","> 50 cm"]
["27.","1,7 °C/13,9 °C/1,1 °C","3,3 °C/6,7 °C/5,0 °C","3,9 °C/5,6 °C/5,0 °C","3,9 °C/3,9 °C/4,4 °C","n","> 50 cm"]
["28.","2,8 °C/8,3 °C/5,0 °C","3,3 °C/5,6 °C/5,6 °C","3,9 °C/5,0 °C/5,0 °C","4,4 °C/4,4 °C/4,4 °C","t","> 50 cm"]
["29.","4,4 °C/10,6 °C/1,7 °C","5,0 °C/7,2 °C/5,6 °C","5,0 °C/6,1 °C/5,6 °C","4,4 °C/4,4 °C/5,0 °C","t","> 50 cm"]
["30.","1,1 °C/16,7 °C/3,3 °C","2,8 °C/7,8 °C/6,1 °C","3,3 °C/6,1 °C/6,1 °C","4,4 °C/4,4 °C/5,0 °C","n","> 50 cm","29 cm"]
["31.","5,6 °C/6,7 °C/3,9 °C","5,0 °C/7,2 °C/6,1 °C","5,0 °C/6,1 °C/6,1 °C","5,0 °C/5,0 °C/5,6 °C","t","> 50 cm","> 50 cm"]
[]
[null,"Werte von 7 Uhr/14 Uhr/21 Uhr MEZ"]
[]
[null,"Mit Gelb markiert ist der Temperaturbereich des Erdbodens."]