{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1"],"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":13,"rows_kept":59,"cut":false,"hidden":false,"merged":[]}
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",2,87,1034.3,2.6,5,null,"00",4,55,1028,-7.9,1]
["01",1,87,1034.4000000000001,2.6,1,null,"01",4,54,1027.0999999999999,-8.4,0]
["02",2,89,1034.4000000000001,2.1,2,null,"02",4,56,1026.4000000000001,-8.1999999999999993,0]
["03",1,90,1034.8,1.9,0,null,"03",4,58,1025.9000000000001,-8.1,0]
["04",2,90,1035,2.5,1,null,"04",3,57,1025.8,-8.6,0]
["05",1,88,1035.0999999999999,2.4,2,null,"05",3,57,1025.8,-8.6999999999999993,1]
["06",2,87,1035.2,2.2999999999999998,7,null,"06",3,60,1026,-8.6,1]
["07",2,85,1035.0999999999999,1.9,8,null,"07",3,61,1026.5,-8.8000000000000007,1]
["08",3,84,1035.0999999999999,1.6,8,null,"08",3,63,1026.5,-8.6999999999999993,2]
["09",2,84,1035.0999999999999,1.4,7,null,"09",3,64,1027.0999999999999,-8.4,3]
["10",3,83,1034.8,1,4,null,"10",3,63,1027.0999999999999,-7.8,3]
["11",3,81,1034.5999999999999,0.7,3,null,"11",3,60,1026.5999999999999,-7.6,3]
["12",3,81,1034.0999999999999,0.7,3,null,"12",3,59,1026.5,-6.9,3]
["13",3,78,1033.5999999999999,0.3,3,null,"13",3,61,1026.7,-6,3]
["14",3,78,1032.8,0.2,2,null,"14",3,61,1026.9000000000001,-6.1,3]
[15,2,80,1033,-0.1,2,null,"15",3,64,1027.0999999999999,-6,3]
["16",2,83,1033,-0.7,1,null,"16",2,66,1027.2,-5.4,8]
["17",3,83,1032.5999999999999,-1.5,2,null,"17",2,66,1027.4000000000001,-5.2,8]
["18",3,82,1032,-1.9,2,null,"18",2,64,1027.7,-5.4,8]
["19",3,75,1031.2,-2.8,0,null,"19",2,67,1027.8,-4.4000000000000004,8]
["20",3,72,1030.7,-3.5,0,null,"20",2,80,1027.5,-2.6,8]
["21",4,70,1030.0999999999999,-4.3,0,null,"21",1,91,1027.3,-1.4,8]
["22",3,70,1029.7,-4.8,0,null,"22",1,97,1027.2,-0.3,8]
["23",4,64,1029.0999999999999,-5.9,0,null,"23",1,98,1027.4000000000001,-0.2,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":2.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":81.3},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1033.3},{"$f":"AVERAGE(E3:E26)","v":-5.4166666666666731E-2},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":2.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":2.7},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":65.900000000000006},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1026.9000000000001},{"$f":"AVERAGE(L3:L26)","v":-6.2375000000000007},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":3.8}]
[]
[null,null,null,null,"2015-12-30",null,null,null,null,null,null,"2015-12-31"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,98,1027.7,0.8,8,null,"00",1,95,1031.3,5.6,7]
["01",1,98,1027.9000000000001,-0.6,8,null,"01",2,96,1031,5.4,8]
["02",1,98,1027.5,-0.7,8,null,"02",2,96,1030.9000000000001,5.0999999999999996,8]
["03",0,98,1027.4000000000001,-1.1000000000000001,7,null,"03",1,96,1030.5,5.4,8]
["04",0,98,1027.5999999999999,-1.7,7,null,"04",3,95,1030.4000000000001,5.8,8]
["05",0,98,1027.4000000000001,-1.7,7,null,"05",2,94,1030.5,5.5,8]
["06",0,97,1027.5,-2.1,7,null,"06",3,90,1030.5999999999999,4.9000000000000004,8]
["07",1,97,1027.5,-2.2999999999999998,8,null,"07",3,91,1030.5,4.2,8]
["08",0,97,1027.9000000000001,-2.1,8,null,"08",3,93,1030.4000000000001,4.0999999999999996,8]
["09",0,97,1028.3,-1.6,8,null,"09",2,93,1030.9000000000001,4.0999999999999996,7]
["10",0,97,1028.5999999999999,-1.2,8,null,"10",3,92,1030.5,4.2,7]
["11",null,null,null,null,null,null,"11",2,90,1030.7,4.2,7]
["12",null,null,null,null,null,null,"12",3,87,1030.2,3.9,4]
["13",null,null,null,null,null,null,"13",3,85,1030.2,3.9,2]
["14",null,null,null,null,null,null,"14",2,83,1030.5999999999999,3.8,1]
["15",null,null,null,null,null,null,"15",2,83,1031.0999999999999,3.3,3]
["16",null,null,null,null,null,null,"16",2,85,1031.3,2.6,3]
["17",null,null,null,null,null,null,"17",2,88,1031.7,1.6,1]
["18",null,null,null,null,null,null,"18",2,87,1032.4000000000001,2.7,0]
["19",null,null,null,null,null,null,"19",2,87,1032.7,2.1,0]
["20",null,null,null,null,null,null,"20",2,88,1033.0999999999999,2.6,0]
["21",null,null,null,null,null,null,"21",2,87,1033.5999999999999,2.2000000000000002,0]
["22",null,null,null,null,null,null,"22",2,88,1033.7,2.4,2]
["23",null,null,null,null,null,null,"23",2,88,1034.4000000000001,2.8,6]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.4},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":97.5},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1027.8},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":-1.3},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":7.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":2.2000000000000002},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":89.9},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1031.4000000000001},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":3.9},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":4.8}]
[]
[null,null,null,null,"2016-01-01",null,null,null,null,null,null,"2015-12-29"]

{"sheet":"Kurztabelle","index":1,"n_rows":113,"n_cols":35,"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,"2015"]
[]
["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,"Bft","SS","Art ( D )","RR","Ge","Bf6","Bf8","Bft","Gewitter"]
["01.",7.2,10.8,5.5,3.1,71,83,7.1,0.9,"R",null,0.6,1019.1,4.5999999999999996,3,null,null,1,null,1,1,8,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"]
["02.",9.1999999999999993,11,5.2,3.1,71,84,7.5,0.1,"R",null,".",1027,6.5,2,null,null,1,null,1,null,6,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":1},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0},{"$f":"COUNTIF(I6:I15,\">=20\")","v":0}]
["03.",6.8,10.1,2.2999999999999998,-1.4,70,82,4.3,".",null,null,1.8,1030.3,3.9,1,null,null,null,null,null,null,4,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":2},{"$f":"COUNTIF(I18:I27,\">=3\")","v":1},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",7.2,10.8,4.8,"-",69,81,5.4,0.1,"R",null,0.6,1027.8,4.3,2,null,null,1,null,1,null,6,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":6},{"$f":"COUNTIF(I30:I40,\">=1\")","v":3},{"$f":"COUNTIF(I30:I40,\">=3\")","v":0},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",4.5,10.199999999999999,-0.6,-4.0999999999999996,68,82,4.3,".",null,null,0.6,1030.2,1.8,1,null,null,null,null,null,null,4]
["06.",8.6999999999999993,13.3,3.8,-1.1000000000000001,38,74,3.7,0.2,"R",null,1.1000000000000001,1026.2,3.9,2,null,null,1,null,1,null,6,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.",8.8000000000000007,10.8,6.7,"-",80,91,7.5,0.3,"R",null,".",1032.7,7.4,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":2},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":7},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":1}]
["08.",5.2,9.1999999999999993,2.4,"-",86,94,2,".",null,null,1.6,1033.3,4.4000000000000004,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":1},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":9},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",4.5999999999999996,7.1,0.9,-1.7,84,93,6.5,2.8,"R",null,".",1033.8,3.4,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":2},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":7},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",2.2999999999999998,7,-0.1,-4.4000000000000004,75,88,2.2999999999999998,".",null,null,1.4,1035.9000000000001,0.6,2,null,null,null,null,null,null,5]
["Su",{"$f":"SUM(B6:B15)","v":64.5},{"$f":"SUM(C6:C15)","v":100.3},{"$f":"SUM(D6:D15)","v":30.899999999999995},{"$f":"SUM(E6:E15)","v":-6.4999999999999991},"XXX","XXX","XXX",{"$f":"SUM(I6:I15)","v":4.4000000000000004},"XX",null,{"$f":"SUM(L6:L15)","v":7.7000000000000011},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R6:R15)","v":6},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":4},{"$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":6.45},{"$f":"AVERAGE(C6:C15)","v":10.029999999999999},3.0899999999999994,-0.92857142857142849,"XXX",85.2,5.0599999999999996,"XXX","XX",null,{"$f":"L16/10","v":0.77000000000000013},{"$f":"AVERAGE(M6:M15)","v":1029.6299999999997},{"$f":"AVERAGE(N6:N15)","v":4.08},{"$f":"AVERAGE(O6:O15)","v":1.7},{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":5.4},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":3},{"$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.",4.3,8.6999999999999993,0.1,-4.4000000000000004,63,82,5.7,2.7,"R",null,".",1025.0999999999999,1.4,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":6},{"$f":"COUNTIF(L18:L27,\"<1\")","v":3},{"$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.",5.4,7.9,4.2,0.4,71,82,5.8,0.6,"R",null,0.9,1021.8,2.6,2,null,null,1,null,1,null,6,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":3},{"$f":"COUNTIF(L30:L40,\"<1\")","v":6},{"$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.",6.6,10.9,2.8,"-",74,82,7.4,0.6,"R",null,".",1018.1,3.7,3,null,null,1,null,1,null,7]
["14.",2.2000000000000002,5.2,-1.8,-4.8,79,88,4.8,".",null,null,".",1025.5,0.4,1,null,null,null,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",4.9000000000000004,7.1,2.9,-0.9,86,91,7.3,".",null,null,".",1025.3,3.6,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":12.9},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":15.5},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-4.9000000000000004},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":4.9000000000000004}]
["16.",5.6,8.1,2.9,-0.9,84,92,5.3,0.8,"R",null,1,1028.5,4.3,1,null,null,1,null,null,null,5,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",8.8000000000000007,12.9,6.9,"-",84,93,7.3,0.3,"R",null,".",1024.4000000000001,7.7,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-0.4},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-2.7},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":38},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",8.3000000000000007,10.6,5.7,3.1,90,96,7,4.9000000000000004,"R",null,".",1023,7.6,1,null,null,1,null,null,null,4]
["19.",8.6,12.2,6.2,"-",85,90,4.7,".",null,null,0.9,1024.5,7.1,1,null,null,null,null,null,null,4]
["20.",6.2,8.6,4.4000000000000004,1.8,84,92,3.3,0.1,"R",null,0.9,1022.8,5.0999999999999996,2,null,null,1,null,1,null,7]
["Su",{"$f":"SUM(B18:B27)","v":60.9},{"$f":"SUM(C18:C27)","v":92.2},{"$f":"SUM(D18:D27)","v":34.299999999999997},{"$f":"SUM(E18:E27)","v":-5.700000000000002},"XXX","XXX","XXX",{"$f":"SUM(I18:I27)","v":10},"XX",null,{"$f":"SUM(L18:L27)","v":3.6999999999999997},"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":6.09},{"$f":"AVERAGE(C18:C27)","v":9.2200000000000006},3.4299999999999997,-0.81428571428571461,80,88.8,5.8599999999999994,"XXX","XX",null,{"$f":"L28/10","v":0.37},{"$f":"AVERAGE(M18:M27)","v":1023.9},{"$f":"AVERAGE(N18:N27)","v":4.3499999999999996},{"$f":"AVERAGE(O18:O27)","v":1.5},{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":5.2}]
["21.",7.9,10.7,4.9000000000000004,2.2000000000000002,71,85,6.5,1.5,"R",null,".",1022.9,5.5,2,null,null,1,null,1,null,6]
["22.",11.6,14.1,9.4,"-",71,77,6.6,0.2,"R",null,0.2,1023.8,7.8,3,null,null,1,null,1,null,7]
["23.",10.6,13.8,7.9,2.9,54,74,3.8,".",null,null,0.6,1025,6.1,2,null,null,null,null,1,null,6]
["24.",6.6,10.8,1.1000000000000001,-2.1,80,89,4.4000000000000004,0.4,"R",null,0.9,1027.3,4.8,2,null,null,1,null,1,null,6]
["25.",9.8000000000000007,12.1,6.9,4,75,86,7.3,1,"R",null,".",1027.5999999999999,7.4,2,null,null,1,null,null,null,5]
["26.",12.9,15.5,9.5,"-",66,74,5.2,".",null,null,0.5,1026.2,8.4,3,null,null,null,null,1,null,6]
["27.",11,14.9,7.9,2.5,54,70,6.3,0.3,"R",null,0.6,1027.3,5.6,2,null,null,1,null,null,null,5]
["28.",9.8000000000000007,12.1,6.3,"-",73,89,7.8,0,null,null,".",1030.9000000000001,8,1,null,null,null,null,null,null,5]
["29.",5.3,6.7,3.3,"-",82,90,4.8,".",null,null,0.7,1031.4000000000001,3.9,2,null,null,null,null,null,null,4]
["30.",2.8,4.5999999999999996,-0.1,"-",77,81,2.6,".",null,null,1.2,1033.3,-0.1,3,null,null,null,null,1,null,6]
["31.",-0.4,0.8,-2.7,-4.9000000000000004,52,66,3.8,2.2999999999999998,"R;E",null,1,1026.9000000000001,-6.2,3,null,null,1,null,1,null,7]
["Su",{"$f":"SUM(B30:B40)","v":87.899999999999991},{"$f":"SUM(C30:C40)","v":116.1},{"$f":"SUM(D30:D40)","v":54.399999999999991},{"$f":"SUM(E30:E40)","v":4.5999999999999996},"XXX","XXX","XXX",{"$f":"SUM(I30:I40)","v":5.6999999999999993},"XX",null,{"$f":"SUM(L30:L40)","v":5.7},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R30:R40)","v":6},{"$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":7.9909090909090903},{"$f":"AVERAGE(C30:C40)","v":10.554545454545455},{"$f":"AVERAGE(D30:D40)","v":4.9454545454545444},{"$f":"AVERAGE(E30:E40)","v":0.76666666666666661},"XXX",{"$f":"AVERAGE(G30:G40)","v":80.090909090909093},{"$f":"AVERAGE(H30:H40)","v":5.3727272727272712},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1027.5090909090907},{"$f":"AVERAGE(N30:N40)","v":4.6545454545454543},{"$f":"AVERAGE(O30:O40)","v":2.2727272727272729},{"$f":"AVERAGE(P30:P40)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":5.7272727272727275}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":213.3},{"$f":"SUM(C16+C28+C41)","v":308.60000000000002},{"$f":"SUM(D16+D28+D41)","v":119.59999999999998},{"$f":"SUM(E16+E28+E41)","v":-7.6000000000000014},"XXX","XXX","XXX",{"$f":"SUM(I16+I28+I41)","v":20.100000000000001},"XX",null,{"$f":"SUM(L16+L28+L41)","v":17.100000000000001},"XXX","XXX","XXX","XXX","X",{"$f":"SUM(R16+R28+R41)","v":19},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":15},{"$f":"SUM(U16+U28+U41)","v":1},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":6.8806451612903228},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":9.9548387096774196},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":3.858064516129033},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":-0.37999999999999962},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":84.548387096774192},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":5.4290322580645167},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1027.0290322580645},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":4.370967741935484},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.8387096774193548},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V42)","v":5.4424242424242424}]
[]
[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":12}]
["TTT",1.1000000000000001,"XXXX",{"$f":"SUM(B44-B48)","v":5.7806451612903231},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":6},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":12}]
["RRR",53,{"$f":"SUM(I43*100/B49)","v":37.924528301886795},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":1},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",55,{"$f":"SUM(L43*100/B50)","v":31.090909090909093},"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":0}]
["mgl.",247,{"$f":"SUM(L43*100/B52)","v":6.9230769230769242},"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":5},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":23},">/= 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":1}]
[]
[]
[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 auf 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:",2015]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-","-","-",1,1,1,"-",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.","-",{"$f":"IF(R10=1,1,\"-\")","v":"-"},1,1,1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","-","-","-","-",1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-",{"$f":"IF(R12=1,1,\"-\")","v":"-"},null,"-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-",{"$f":"IF(R13=1,1,\"-\")","v":"-"},"-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-",null,"-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-",null,"-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["14.","-",{"$f":"IF(R22=1,1,\"-\")","v":"-"},"-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-",1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-",null,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-","-",1,1,"-","-"]
["30.","-","-","-","-",1,"-","-"]
["31.","-","-","-",1,1,1,"-"]
["Su.",{"$f":"SUM(B9:B39)","v":"00:00:00"},0,4,13,31,10,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":10}]

{"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 2015"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":15.5},"am","2015-12-26"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":6.8806451612903228},{"$f":"Kurztabelle!B48","v":1.1000000000000001},{"$f":"C7-D7","v":5.7806451612903231},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":-2.7},"am","2015-12-31"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":20.100000000000001},{"$f":"Kurztabelle!B49","v":53},{"$f":"100/D9*C9","v":37.924528301886795},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":17.100000000000001},{"$f":"Kurztabelle!B50","v":55},{"$f":"100/D10*C10","v":31.090909090909093},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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 80 %; Mai - August 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"]
["2015-12-01",7.2,10.8,5.5,0.9,null,0.6,1019.1,2.1,"Wa","H Xena","Von 04:20 Uhr - 04:39 Uhr starker Regen (WW 65). Von 02:20 Uhr - 03:39 Uhr; 23:30 Uhr - 23:59 Uhr mäßiger Regen (WW 63). Von 00:20 Uhr - 00:49 Uhr; 03:40 Uhr - 04:19 Uhr; 04:40 Uhr - 05:29 Uhr; Gegen 22:20 Uhr; 23:10 Uhr - 23:29 Uhr leichter Regen (WW 61)."]
["2015-12-02",9.1999999999999993,11,5.2,0.1,null,null,1027,2,null,null,"Von 00:00 Uhr - 00:39 Uhr; Um 02:00 Uhr; 08:40 Uhr leichter Regen (WW 61)."]
["2015-12-03",6.8,10.1,2.2999999999999998,null,null,1.8,1030.3,1.9]
["2015-12-04",7.2,10.8,4.8,0.1,null,0.6,1027.8,1.8,"Wz","T Rudi","Gegen 15:45 Uhr leichter Regen (WW 61)."]
["2015-12-05",4.5,10.199999999999999,-0.6,null,null,0.6,1030.2,1.75,"SWa","H Yvonne"]
["2015-12-06",8.6999999999999993,13.3,3.8,0.2,null,1.1000000000000001,1026.2,1.65]
["2015-12-07",8.8000000000000007,10.8,6.7,0.3,null,null,1032.7,1.6,null,null,"Gegen 09:00 Uhr leichter Regen (WW 61). Zwischen 04:00 Uhr - 07:00 Uhr leichter Regen, unterbrochen (WW 60)."]
["2015-12-08",5.2,9.1999999999999993,2.4,null,null,1.6,1033.3,1.55]
["2015-12-09",4.5999999999999996,7.1,0.9,2.8,null,null,1033.8,1.5,"Wa","H Zita","Von 09:00 Uhr - 10:09 Uhr; 10:30 Uhr - 11:19 Uhr; 12:40 Uhr - 12:59 Uhr; 13:20 Uhr - 14:09 Uhr leichter Regen (WW 61). Von 10:10 Uhr - 10:29 Uhr; 11:20 Uhr - 12:39 Uhr; 13:00 Uhr - 13:19 Uhr starker Sprühregen (WW 55). "]
["2015-12-10",2.2999999999999998,7,-0.1,null,null,1.4,1035.9000000000001,1.4]
["2015-12-11",4.3,8.6999999999999993,0.1,2.7,null,null,1025.0999999999999,1.35,"Wz","T Vanechka","Von 16:00 Uhr - 18:19 Uhr mäßiger Regen (WW 63). Von 13:50 Uhr - 14:19 Uhr; 15:40 Uhr - 15:59 Uhr; 18:20 Uhr -  20:09 Uhr leichter Regen (WW 61)."]
["2015-12-12",5.4,7.9,4.2,0.6,null,0.9,1021.8,1.3]
["2015-12-13",6.6,10.9,2.8,0.6,null,null,1018.1,1.25,null,"T Werner","Von 10:50 Uhr - 11:24 Uhr leichter Regenschauer (WW 80). Von 02:20 Uhr - 02:39 Uhr mäßiger Regen (WW 63). Von 01:40 Uhr - 02:19 Uhr; 02:40 Uhr - 02:59 Uhr; 03:30 Uhr - 04:09 Uhr; 09:40 Uhr - 10:49 Uhr leichter Regen (WW 61)."]
["2015-12-14",2.2000000000000002,5.2,-1.8,null,null,null,1025.5,1.1499999999999999,"Wa","H Brigitte"]
["2015-12-15",4.9000000000000004,7.1,2.9,null,null,null,1025.3,1.1000000000000001]
["2015-12-16",5.6,8.1,2.9,0.8,null,1,1028.5,1.05,null,"T Jorrick","Von 04:30 Uhr - 05:19 Uhr mäßiger Regen (WW 63). Von 03:50 Uhr - 04:29 Uhr; Um 08:10 Uhr; 09:05 Uhr - 09:29 Uhr leichter Regen (WW 61). Gegen 11:00 Uhr; 13:00 Uhr leichter Sprühregen (WW 51)."]
["2015-12-17",8.8000000000000007,12.9,6.9,0.3,null,null,1024.4000000000001,1]
["2015-12-18",8.3000000000000007,10.6,5.7,4.9000000000000004,null,null,1023,0.95000000000000095,"SWa","H Brigitte","Von 10:50 Uhr - 11:39 Uhr; 13:30 Uhr - 14:09 Uhr mäßiger Regen (WW 63). Von 09:50 Uhr - 10:19 Uhr; 10:40 Uhr - 10:49 Uhr; 11:40 Uhr - 12:09 Uhr; 12:40 Uhr - 13:29 Uhr; 14:10 Uhr - 14:49 Uhr leichter Regen (WW 61)."]
["2015-12-19",8.6,12.2,6.2,null,null,0.9,1024.5,0.90000000000000102]
["2015-12-20",6.2,8.6,4.4000000000000004,0.1,null,0.9,1022.8,0.85000000000000098,"Wa"]
["2015-12-21",7.9,10.7,4.9000000000000004,1.5,null,null,1022.9,0.80000000000000104,"SWa",null,"Von 09:50 Uhr - 10:19 Uhr mäßiger Regen (WW 63). Von 07:20 Uhr - 07:29 Uhr; 07:40 Uhr - 09:49 Uhr; 10:20 Uhr - 11:19 Uhr;  11:40 Uhr - 12:14 Uhr; Gegen 19:10 Uhr leichter Regen (WW 61). Von 11:20 Uhr - 11:39 Uhr leichter Regen, unterbrochen (WW 60)."]
["2015-12-22",11.6,14.1,9.4,0.2,null,0.2,1023.8,0.8,null,null,"Von 10:50 Uhr - 11:39 Uhr leichter Regen (WW 61)."]
["2015-12-23",10.6,13.8,7.3,null,null,0.6,1025,0.75,"Wz","T Arend"]
["2015-12-24",6.6,10.8,1.1000000000000001,0.4,null,0.9,1027.3,0.6,null,null,"Von 18:20 Uhr - 19:29 Uhr leichter Regen (WW 61). Vor 06:00 Uhr - Gegen 10:00 Uhr Bodennebel (WW 12)."]
["2015-12-25",9.8000000000000007,12.1,6.9,1,null,null,1027.5999999999999,0.6,"Wa",null,"Von 09:30 Uhr - 10:29 Uhr; Um 10:45 Uhr; 15:40 Uhr - 17:19 Uhr; Um 17:45 Uhr leichter Regen (WW 61)."]
["2015-12-26",12.9,15.5,9.5,null,null,0.5,1026.2,0.55000000000000004,"Wz","T Daniel"]
["2015-12-27",11,14.9,7.9,0.3,null,0.6,1027.3,0.5]
["2015-12-28",9.8000000000000007,12.1,6.3,null,null,null,1030.9000000000001,0.45,null,null,"Um 03:35 Uhr; 05:00 Uhr; 05:30 Uhr - 05:49 Uhr leichter Regen (WW 61). Gegen 14:30 Uhr Regentropfen (WW 60)."]
["2015-12-29",5.3,6.7,3.3,null,null,0.7,1031.4000000000001,0.4,"SEa","H Christine"]
["2015-12-30",2.8,4.5999999999999996,-0.1,null,null,1.2,1033.0999999999999,0.4]
["2015-12-31",-0.4,0.8,-2.7,2.2999999999999998,null,1,1026.9000000000001,0.4,"Sa",null,"Von 20:40 Uhr - 20:59 Uhr leichte Eiskörner (WW 79). Von 21:00 Uhr - 23:59 Uhr leichter gefrierender Regen (WW 66)."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":6.8806451612903228},{"$f":"AVERAGE(C2:C32)","v":9.9548387096774196},{"$f":"AVERAGE(D2:D32)","v":3.8387096774193554},"-",null,{"$f":"AVERAGE(G2:G32)","v":0.9},{"$f":"AVERAGE(H2:H32)","v":1027.0225806451613},{"$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]