{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["Mittelhilfstabelle","Kurztabelle","Sichtst.","Monatsdiagramm","Daten für Diagr.","Modul1","Erdbodentem."],"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",0,97,1027.0999999999999,7.3,8,null,"00",0,98,1024.8,7.5,8]
["01",1,98,1027.2,7.5,8,null,"01",0,98,1024.8,7.5,6]
["02",0,98,1027,7.3,7,null,"02",0,98,1024.4000000000001,7.2,8]
["03",0,98,1026.4000000000001,7.3,7,null,"03",0,98,1024.0999999999999,7.1,7]
["04",1,98,1026.5,7,7,null,"04",0,98,1023.7,7.1,7]
["05",1,98,1026.3,6.8,7,null,"05",0,99,1023.5,7.5,7]
["06",0,98,1026.9000000000001,6.6,7,null,"06",1,98,1023.5,7.1,7]
["07",1,98,1026.5,6.7,7,null,"07",0,99,1023.8,7.6,7]
["08",0,98,1027,7,7,null,"08",0,99,1023.8,8.4,6]
["09",1,95,1027.3,7.7,7,null,"09"]
["10",1,93,1027.0999999999999,8.6,7,null,"10"]
["11",1,88,1027.2,9.6999999999999993,5,null,"11"]
["12",1,84,1027,10.4,4,null,"12"]
["13",1,82,1026.3,11.1,5,null,"13"]
["14",1,83,1025.9000000000001,10.9,6,null,"14"]
[15,1,87,1025.5999999999999,11.4,7,null,"15"]
["16",1,88,1025.5999999999999,10.5,7,null,"16"]
["17",0,92,1025.4000000000001,9.6999999999999993,8,null,"17"]
["18",0,94,1025.5,9.1999999999999993,7,null,"18"]
["19",1,95,1025.4000000000001,8.6999999999999993,7,null,"19"]
["20",0,97,1025.5999999999999,8.5,7,null,"20"]
["21",0,97,1025.3,8.1999999999999993,7,null,"21"]
["22",0,98,1025.2,8,7,null,"22"]
["23",0,98,1025,7.8,8,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":93.8},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1026.3},{"$f":"AVERAGE(E3:E26)","v":8.4958333333333318},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":6.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.1},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":98.3},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1024},{"$f":"AVERAGE(L3:L26)","v":7.4444444444444446},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":7}]
[]
[null,null,null,null,"2014-10-31",null,null,null,null,null,null,"2014-11-01"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,80,1020,0.3,0,null,"00",1,94,1022.4,3.6,7]
["01",1,81,1019.8,0.4,0,null,"01",1,94,1022.3,3.8,7]
["02",2,83,1019.7,0.6,0,null,"02",1,93,1022.9,3.6,7]
["03",1,86,1019.3,0,0,null,"03",0,94,1022.8,4.0999999999999996,7]
["04",2,90,1018.6,0.1,0,null,"04",1,93,1023,3.4,7]
["05",2,90,1018.3,0.4,0,null,"05",1,94,1023.5,4.0999999999999996,3]
["06",2,90,1018.5,0.5,0,null,"06",2,93,1023.3,4.0999999999999996,7]
["07",2,92,1018.9,0.1,0,null,"07",1,92,1024.3,4,8]
["08",1,92,1019.5,1.1000000000000001,0,null,"08",1,91,1024.7,4.7,8]
["09",1,89,1019.7,2.4,0,null,"09",0,92,1025.8,5.7,8]
["10",2,87,1019.8,3.2,0,null,"10",0,90,1026.0999999999999,5.9,8]
["11",2,86,1019.9,4.2,1,null,"11",1,88,1026.2,6.1,8]
["12",1,80,1019.69,4.8,0,null,"12",0,88,1026.2,6.4,8]
["13",3,81,1019.4,4.9000000000000004,0,null,"13",1,88,1026.0999999999999,6.8,8]
["14",2,81,1019.4,5.3,0,null,"14",1,89,1026.0999999999999,7.2,8]
["15",2,83,1019.3,5.0999999999999996,0,null,"15",1,89,1026.3,7.4,8]
["16",2,86,1019.2,4.5,1,null,"16",0,90,1026.3,7.4,8]
["17",2,89,1019.4,3.8,1,null,"17",0,92,1026.5,7.2,8]
["18",1,91,1019.8,3.6,0,null,"18",0,92,1027.0999999999999,7.2,8]
["19",1,93,1020.5,3.2,0,null,"19",0,93,1027.2,7.3,8]
["20",1,94,1021,3.1,1,null,"20",1,93,1027.0999999999999,7,8]
["21",1,94,1021.3,3.8,6,null,"21",0,95,1027.4000000000001,7.3,8]
["22",0,94,1021.7,3.8,5,null,"22",0,94,1027.5,7.3,8]
["23",0,95,1021.9,3.8,3,null,"23",0,96,1027.5,7.4,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.5},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":87.8},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1019.8},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":2.6},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":0.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.6},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":92},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1025.4000000000001},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":5.8},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":7.5}]
[]
[null,null,null,null,"2014-10-29",null,null,null,null,null,null,"2014-10-30"]

{"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:","Oktober",null,null,null,null,"Jahr:",null,null,"2014"]
[]
["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.",15.4,19.899999999999999,11.7,"-",69,91,5.4,".",null,null,1.7,1026.5999999999999,13.9,1,null,null,null,null,null,null,3,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.",14,19.3,11.4,10,71,91,5.6,".",null,null,1.8,1029,12.8,0,null,null,null,null,null,null,2,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":1},{"$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.",11.8,18,7.4,6.1,75,93,1,".",null,null,5.4,1027.5999999999999,10.7,1,null,null,null,null,null,null,3,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":6},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":1},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",10.7,16.8,6.6,5.6,71,89,0.4,".",null,null,4.5999999999999996,1022.3,8.9,1,null,null,null,null,null,null,4,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":3},{"$f":"COUNTIF(I30:I40,\">=1\")","v":2},{"$f":"COUNTIF(I30:I40,\">=3\")","v":2},{"$f":"COUNTIF(I30:I40,\">=10\")","v":1},{"$f":"COUNTIF(I30:I40,\">=20\")","v":0}]
["05.",11.7,15.8,7,6.1,79,91,3.4,".",null,null,1.4,1019.2,10.199999999999999,1,null,null,null,null,null,null,4]
["06.",12.1,16.2,8.9,6.7,71,86,2.2000000000000002,".",null,null,1.4,1016.1,9.9,2,null,null,null,null,null,null,5,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.",13.1,15.7,10.7,8.9,77,84,6.2,".",null,null,1,1011.1,10.4,3,null,null,null,null,1,null,6,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.",14.3,16.600000000000001,12.5,11.1,81,89,7,1.5,"R",null,0.3,1012.5,12.5,2,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":0},{"$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.",15.7,20,12.6,11.1,72,86,4.2,".",null,null,4.9000000000000004,1010.7,13.3,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":0},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":9},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",14.5,18.100000000000001,11.7,10.6,84,93,6.1,0,null,null,".",1015.9,13.5,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":133.30000000000001},{"$f":"SUM(C6:C15)","v":176.4},100.5,76.2,"XXX","XXX",{"$f":"SUM(H6:H15)","v":41.5},{"$f":"SUM(I6:I15)","v":1.5},"XX",null,{"$f":"SUM(L6:L15)","v":22.5},{"$f":"SUM(M6:M15)","v":10191},116.10000000000001,14,{"$f":"SUM(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":1},{"$f":"SUM(S6:S15)","v":0},1,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":13.330000000000002},{"$f":"AVERAGE(C6:C15)","v":17.64},10.050000000000001,8.4666666666666668,"XXX",89.3,4.1500000000000004,"XXX","XX",null,{"$f":"L16/10","v":2.25},{"$f":"AVERAGE(M6:M15)","v":1019.1},{"$f":"AVERAGE(N6:N15)","v":11.610000000000001},1.4,{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":4},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":1},{"$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.",15.8,19.7,12.8,12.8,79,92,7.3,1.1000000000000001,"R",null,0.2,1014,14.5,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$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.",14.3,18.600000000000001,11.1,9.4,75,89,4.5999999999999996,".",null,null,1.8,1015.1,12.6,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":3},{"$f":"COUNTIF(L30:L40,\"<1\")","v":2},{"$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.",14.8,18.899999999999999,11,8.9,80,91,6.4,11.8,"R",null,0.9,1009.4,13.2,2,null,null,1,null,null,null,5]
["14.",14.5,19.100000000000001,10.7,9.4,71,91,5.8,2.8,"R",null,1.7,1009.1,13.1,1,null,null,1,null,null,null,4,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",12.7,17.399999999999999,9.4,8.3000000000000007,79,95,7,9.6999999999999993,"R",null,1.3,1008.1,11.8,1,null,null,1,1,null,null,4,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":15.8},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":20.2},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-1.7},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":12.8}]
["16.",12.6,17.600000000000001,8.6999999999999993,8.3000000000000007,79,94,6.8,1.8,"R",null,1,1007.6,11.4,1,null,null,1,null,null,null,5,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",13.6,16.600000000000001,11.7,10,79,89,6.3,0.1,"R",null,0.3,1012.9,11.8,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":4.5999999999999996},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":1.2},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":54},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":0}]
["18.",13.4,18.3,9.9,8.9,71,90,4.5999999999999996,".",null,null,1.5,1023.4,11.7,1,null,null,null,null,null,null,4]
["19.",14.8,20.2,10,6.7,73,88,0.8,2.9,"R",null,3.3,1018.8,12.6,2,null,null,1,null,null,null,5]
["20.",14.7,18.3,11.8,10.6,59,78,6.2,".",null,null,3.4,1018.4,11.1,2,null,null,null,null,1,null,6]
["Su",{"$f":"SUM(B18:B27)","v":141.19999999999999},{"$f":"SUM(C18:C27)","v":184.7},107.1,93.3,"XXX","XXX",{"$f":"SUM(H18:H27)","v":55.8},{"$f":"SUM(I18:I27)","v":30.2},"XX",null,{"$f":"SUM(L18:L27)","v":15.4},{"$f":"SUM(M18:M27)","v":10136.799999999999},123.8,13,{"$f":"SUM(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":7},{"$f":"SUM(S18:S27)","v":1},1,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":14.12},{"$f":"AVERAGE(C18:C27)","v":18.47},10.709999999999999,9.33,74.5,89.7,5.58,"XXX","XX",null,{"$f":"L28/10","v":1.54},{"$f":"AVERAGE(M18:M27)","v":1013.68},{"$f":"AVERAGE(N18:N27)","v":12.379999999999999},1.3,{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4.4000000000000004}]
["21.",12.5,15.9,9.1,8.4,54,79,6.8,4,"R",null,0.9,1007.4,8.8000000000000007,2,null,null,1,null,1,null,7]
["22.",7.3,9.3000000000000007,4.5999999999999996,5,83,92,7.9,12.8,"R",null,".",1006.5,6,3,null,null,1,null,1,null,7]
["23.",9.8000000000000007,11,8.3000000000000007,7.8,89,94,8,0.2,"R",null,".",1019.5,9,2,null,null,1,null,null,null,5]
["24.",7.5,9.8000000000000007,3.3,1.6,88,93,5.5,".",null,null,0.2,1024.2,6.6,1,null,null,null,null,null,null,3]
["25.",5.9,9.6999999999999993,1.5,0.6,84,93,4,".",null,null,1.1000000000000001,1022.6,4.7,2,null,null,null,null,null,null,5]
["26.",9.1,12.9,5.9,4.4000000000000004,82,91,6.7,".",null,null,1,1027.5999999999999,7.7,1,null,null,null,null,null,null,4]
["27.",6.8,11.8,4.0999999999999996,1.7,76,90,3.9,".",null,null,3.2,1028.5,5.4,2,null,null,null,null,null,null,4]
["28.",5.4,11,2.6,0,61,83,1.1000000000000001,".",null,null,3.3,1023.4,2.8,2,null,null,null,null,null,null,5]
["29.",4.5999999999999996,8.6,1.2,-1.7,75,88,0.8,".",null,null,3.2,1019.8,2.6,2,null,null,null,null,null,null,4]
["30.",7.1,9.3000000000000007,4.2,2.8,87,92,7.5,".",null,null,".",1025.4000000000001,5.8,1,null,null,null,null,null,null,3]
["31.",9.4,14.1,6.6,5.6,81,93,6.8,".",null,null,1.3,1026.3,8.5,1,null,null,null,null,null,null,2]
["Su",{"$f":"SUM(B30:B40)","v":85.399999999999991},{"$f":"SUM(C30:C40)","v":123.39999999999999},{"$f":"SUM(D30:D40)","v":51.400000000000013},{"$f":"SUM(E30:E40)","v":36.200000000000003},"XXX",{"$f":"SUM(G30:G40)","v":988},{"$f":"SUM(H30:H40)","v":59},{"$f":"SUM(I30:I40)","v":17},"XX",null,{"$f":"SUM(L30:L40)","v":14.2},{"$f":"SUM(M30:M40)","v":11231.199999999999},{"$f":"SUM(N30:N40)","v":67.900000000000006},{"$f":"SUM(O30:O40)","v":19},{"$f":"SUM(P30:P40)","v":0},"X",{"$f":"SUM(R30:R40)","v":3},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":2},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B40)","v":7.7636363636363628},{"$f":"AVERAGE(C30:C40)","v":11.218181818181817},{"$f":"AVERAGE(D30:D40)","v":4.6727272727272737},{"$f":"AVERAGE(E30:E40)","v":3.290909090909091},"XXX",{"$f":"AVERAGE(G30:G40)","v":89.818181818181813},{"$f":"AVERAGE(H30:H40)","v":5.3636363636363633},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M40)","v":1021.0181818181817},{"$f":"AVERAGE(N30:N40)","v":6.1727272727272728},{"$f":"AVERAGE(O30:O40)","v":1.7272727272727273},{"$f":"ROUND(AVERAGE(P30:P40),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V40)","v":4.4545454545454541}]
["MSu",{"$f":"SUM(B16+B28+B41)","v":359.9},{"$f":"SUM(C16+C28+C41)","v":484.5},{"$f":"SUM(D16+D28+D41)","v":259},{"$f":"SUM(E16+E28+E41)","v":205.7},"XXX","XXX,",{"$f":"SUM(H16+H28+H41)","v":156.30000000000001},{"$f":"SUM(I16+I28+I41)","v":48.7},"XX",null,{"$f":"SUM(L16+L28+L41)","v":52.099999999999994},{"$f":"SUM(M16+M28+M41)","v":31559},{"$f":"SUM(N16+N28+N41)","v":307.8},"XXX",{"$f":"SUM(P16+P28+P41)","v":0},"X",{"$f":"SUM(R16+R28+R41)","v":11},{"$f":"SUM(S16+S28+S41)","v":1},{"$f":"SUM(T16+T28+T41)","v":4},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B40)","v":11.60967741935484},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C40)","v":15.629032258064518},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D40)","v":8.3548387096774182},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E40)","v":6.8566666666666674},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G40)","v":89.612903225806448},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H40)","v":5.0419354838709678},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M40)","v":1018.0322580645162},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N40)","v":9.9290322580645185},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O40)","v":1.4838709677419355},{"$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":4.2848484848484851}]
[]
[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":11},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":4}]
["TTT",9.8000000000000007,"XXXX",{"$f":"SUM(B44-B48)","v":1.8096774193548395},"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":6}]
["RRR",43,{"$f":"SUM(I43*100/B49)","v":113.25581395348837},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":4},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",120,{"$f":"SUM(L43*100/B50)","v":43.416666666666657},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":0},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":2},"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.",333,{"$f":"SUM(L43*100/B52)","v":15.645645645645644},"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":0},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":27},">/= 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 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:","Oktober",null,null,null,"Jahr:",2014]
[]
["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,"-"," -",null,null,null,null,null," "," "," "," ",0]
["03.","01:20:00",1,1,1,1,"-"," -",null,null,null,null,null,1.3333333333333333," ",2,3,2]
["04.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["11.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["12.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["13.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["14.","-","-",1,1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-",1,1,1,1,"-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["19.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["20.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["21.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-",1,"-","-"]
["29.","-","-","-",1,1,"-","-"]
["30.","-","-","-",1,"-","-","-"]
["30.","-","-",1,1,"-","-","-"]
["Su.",{"$f":"SUM(B9:B39)","v":"01:20:00"},1,7,24,27,4,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":1}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","v":4}]

{"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)"]
[]
["Oktober 2014"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C32)","v":20.2},"am","2014-10-19"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":11.60967741935484},{"$f":"Kurztabelle!B48","v":9.8000000000000007},{"$f":"C7-D7","v":1.8096774193548395},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D32)","v":1.2},"am","2014-10-29"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":48.7},{"$f":"Kurztabelle!B49","v":43},{"$f":"100/D9*C9","v":113.25581395348838},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":52.099999999999994},{"$f":"Kurztabelle!B50","v":120},{"$f":"100/D10*C10","v":43.416666666666664},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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"]
["2014-10-01",15.4,19.899999999999999,11.7,null,null,1.7,1026.5999999999999,12.05,"BM","H Lutz","Leicht schwül."]
["2014-10-02",14,19.3,11.4,null,null,1.8,1029,11.9,null,null,"Von 22:40 Uhr - 23:59 Uhr Bodennebelschwaden (WW 11). Leicht schwül."]
["2014-10-03",11.8,18,7.4,null,null,5.4,1027.5999999999999,11.75,"HFa","H Nikolai","Von 09:10 Uhr - 10:29 Uhr leichter Nebel (WW 45). Von 00:00 Uhr - 09:09 Uhr Uhr Bodennebelschwaden (WW 11)."]
["2014-10-04",10.7,16.8,6.6,null,null,4.5999999999999996,1022.3,11.6]
["2014-10-05",11.7,15.8,7,null,null,1.4,1019.2,11.45]
["2014-10-06",12.1,16.2,8.9,null,null,1.4,1016.1,11.3,"U"]
["2014-10-07",13.1,15.7,10.7,null,null,1,1011.1,11.15,"Wz","T Katrin"]
["2014-10-08",14.3,16.600000000000001,12.5,1.5,null,0.3,1012.5,11,"SWz"]
["2014-10-09",15.7,20,12.6,null,null,4.9000000000000004,1010.7,10.85,null,null,"Leicht schwül."]
["2014-10-10",14.5,18.100000000000001,11.7,null,null,null,1015.9,10.7,null,null,"Leicht schwül."]
["2014-10-11",15.8,19.7,12.8,1.1000000000000001,null,0.2,1014,10.55,null,null,"Leicht schwül."]
["2014-10-12",14.3,18.600000000000001,11.1,null,null,1.8,1015.1,10.4]
["2014-10-13",14.8,18.899999999999999,11,11.8,null,0.9,1009.4,10.25,null,"T Livia","Von 23:50 Uhr - 23:59 Uhr leichter Regen (WW 61). Leicht schwül."]
["2014-10-14",14.5,19.100000000000001,10.7,2.8,null,1.7,1009.1,10.1,"Ws",null,"Von 03:10 Uhr - 04:09 Uhr starker Regen (WW 65). Von 00:00 Uhr - 03:09 Uhr; 04:10 Uhr - 05:29 Uhr mäßiger Regen (WW 63). Von 05:30 Uhr - 06:59 Uhr leichter Regen (WW 61)."]
["2014-10-15",12.7,17.399999999999999,9.4,9.6999999999999993,null,1.3,1008.1,9.9499999999999993,null,null,"06:01 Uhr: Donner hörbar (WW 92). Von 05:40 Uhr - 06:29 Uhr; 07:40 Uhr - 08:49 Uhr; 17:30 Uhr - 18:09 Uhr starker Regenschauer (WW 81)."]
["2014-10-16",12.6,17.600000000000001,8.6999999999999993,1.8,null,1,1007.6,9.7999999999999901,null,null,"Von 21:20 Uhr - 21:59 Uhr starker Regenschauer (WW 81). Von 06:20 Uhr - 07:19 Uhr mäßiger Regen (WW 63). Von 07:20 Uhr - 07:59 Uhr leichter Regen (WW 61)."]
["2014-10-17",13.6,16.600000000000001,11.7,0.1,null,0.3,1012.9,9.6499999999999897,null,null,"Gegen 15:00 Uhr leichter Regen (WW 61)."]
["2014-10-18",13.4,18.3,9.9,null,null,1.5,1023.4,9.4999999999999893,"SWa","H Oz"]
["2014-10-19",14.8,20.2,10,2.9,null,3.3,1018.8,9.3499999999999908,null,null,"Leicht schwül."]
["2014-10-20",14.7,18.3,11.8,null,null,3.4,1018.4,9.1999999999999904,"Wz","T Noa","Von 02:50 Uhr - 03:49 Uhr starker Regen (WW 65). Von 03:50 Uhr - 04:29 Uhr leichter Regen (WW 61)."]
["2014-10-21",12.5,15.9,9.1,4,null,0.8,1007.4,9.0499999999999901,null,null,"Gegen 18:00 Uhr leichter Regenschauer (WW 80). Von 20:00 Uhr - 20:29 Uhr starker Regen (WW 65). Von 20:30 Uhr - 23:59 Uhr mäßiger Regen, unterbrochen (WW 62)."]
["2014-10-22",7.3,9.3000000000000007,4.5999999999999996,12.8,null,null,1006.5,8.8999999999999897,"NWz","Ex - Gonzalo","Von 01:10 Uhr - 01:29 Uhr starker Regen (WW 65). Von 01:30 Uhr - 01:59 Uhr mäßiger Regen (WW 63). Von 00:00 Uhr - 01:09 Uhr; 09:00 Uhr - 14:29 Uhr; 19:40 Uhr - 23:09 Uhr mäßiger Regen, unterbrochen (WW 62). Von 02:00 Uhr - 02:40 Uhr; 23:40 Uhr - 23:59 Uhr leichter Regen (WW 61)."]
["2014-10-23",9.8000000000000007,11,8.3000000000000007,0.2,null,null,1019.5,8.7499999999999893,"Ww",null,"Von 00:00 Uhr - 00:29 Uhr; Gegen 15:00 Uhr leichter Regen (WW 61)."]
["2014-10-24",7.5,9.8000000000000007,3.3,null,null,0.2,1024.2,8.5999999999999908]
["2014-10-25",5.9,9.6999999999999993,1.5,null,null,1.1000000000000001,1022.6,8.4499999999999904,"SWa","H Pitter"]
["2014-10-26",9.1,12.9,5.9,null,null,1,1027.5999999999999,8.2999999999999901]
["2014-10-27",6.8,11.8,4.0999999999999996,null,null,3.2,1028.5,8.1499999999999897,"SEa"]
["2014-10-28",5.4,11,2.6,null,null,3.3,1023.4,7.9999999999999902]
["2014-10-29",4.5999999999999996,8.6,1.2,null,null,3.2,1019.8,7.8499999999999899,"SWa","H Quinn"]
["2014-10-30",7.1,9.3000000000000007,4.2,null,null,null,1025.4000000000001,7.6999999999999904]
["2014-10-31",9.4,14.1,6.6,null,null,1.3,1026.3,7.5499999999999901]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":11.60967741935484},{"$f":"AVERAGE(C2:C32)","v":15.629032258064518},{"$f":"AVERAGE(D2:D32)","v":8.3548387096774182},"-",null,{"$f":"AVERAGE(G2:G32)","v":1.9259259259259258},{"$f":"AVERAGE(H2:H32)","v":1018.0322580645162},{"$f":"AVERAGE(I2:I32)","v":9.7999999999999954}]
["Mittel",9.8000000000000007,null,null,43,"-",120,1017.2]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[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":"Erdbodentem.","index":6,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":false,"merged":[[37,1,37,2],[37,3,37,4],[37,5,37,6],[4,6,4,7],[6,1,7,1],[6,2,7,2],[6,3,7,3],[6,4,7,4],[6,7,7,7],[6,5,7,6],[16,1,16,2],[8,5,8,6],[9,5,9,6],[10,5,10,6],[11,5,11,6],[16,3,16,4],[12,5,12,6],[14,3,14,4],[15,3,15,4],[14,1,14,2],[15,1,15,2],[14,5,14,6],[15,5,15,6],[16,5,16,6],[6,0,7,0],[13,5,13,6],[8,1,8,2],[8,3,8,4],[9,3,9,4],[10,3,10,4],[11,3,11,4],[12,3,12,4],[9,1,9,2],[10,1,10,2],[11,1,11,2],[12,1,12,2],[13,1,13,2],[13,3,13,4],[30,3,30,4],[31,3,31,4],[32,3,32,4],[17,1,17,2],[28,1,28,2],[29,1,29,2],[23,3,23,4],[24,3,24,4],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[27,3,27,4],[18,3,18,4],[21,3,21,4],[22,3,22,4],[23,1,23,2],[24,1,24,2],[18,1,18,2],[17,3,17,4],[19,1,19,2],[20,1,20,2],[21,1,21,2],[22,1,22,2],[19,3,19,4],[20,3,20,4],[28,5,28,6],[29,5,29,6],[26,5,26,6],[27,5,27,6],[17,5,17,6],[23,5,23,6],[24,5,24,6],[25,5,25,6],[18,5,18,6],[19,5,19,6],[20,5,20,6],[21,5,21,6],[22,5,22,6],[38,1,38,2],[38,3,38,4],[38,5,38,6],[34,1,34,2],[25,1,25,2],[30,1,30,2],[26,1,26,2],[27,1,27,2],[34,3,34,4],[31,1,31,2],[32,1,32,2],[33,1,33,2],[30,5,30,6],[31,5,31,6],[34,5,34,6],[36,3,36,4],[36,5,36,6],[35,5,35,6],[35,1,35,2],[36,1,36,2],[35,3,35,4],[33,3,33,4],[32,5,32,6],[33,5,33,6]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","Oktober",null,null,null,"Jahr:",2014]
[]
["Dat.","6 Uhr","7 Uhr","11 Uh","12 Uhr","19 Uhr",null,"NN","10 °C - "]
[null,null,null,null,null,null,null,null,"Eindringtiefe"]
["01.","> 10 °C",null,"-",null,"-",null,"n ","> 1 m"]
["02.","13,5 °C/14,9 °C/ 16,4 °C",null,"-",null,"-",null,"n","> 1 m"]
["03.","-",null,"-",null,"-",null,"-","-"]
["04.","> 10 °C",null,"-",null,"-",null,"h","> 1 m"]
["05.","-",null,"-",null,"-",null,"-","-"]
["06.","10,5 °C/12,4 °C/14,6 °C",null,"-",null,"-",null,"n","> 1 m"]
["07.","-",null,"-",null,"-",null,"n","> 1 m"]
["08.","12,5 °C/13,2 °C/14,5 °C",null,"-",null,"-",null,"t","> 1 m"]
["09.","13,0 °C/13,4 °C/14,8 °C",null,"-",null,"-",null,"n","> 1 m"]
["10.","12,9 °C/13,8 °C/15,4 °C",null,"-",null,"-",null,"t","> 1 m"]
["11.","-",null,"-",null,"-",null,"t","> 1 m"]
["12.","-",null,"-",null,"-",null,"n","> 1 m"]
["13.","11,2 °C/13,4 °C/15,4 °C",null,"-",null,"-",null,"n","> 1 m"]
["14.","-",null,"-",null,"-",null,"n","> 1 m"]
["15.","-",null,"-",null,"-",null,"t","> 1 m"]
["16.","-",null,"-",null,"-",null,"t","> 1 m"]
["17.","-",null,"-",null,"-",null,"n","> 1 m"]
["18.","-",null,"-",null,"-",null,"n","> 1 m"]
["19.","-",null,"-",null,"-",null,"h","> 1 m"]
["20.","-",null,"-",null,"-",null,"n","> 1 m"]
["21.","-",null,"-",null,"-",null,"t","> 1 m"]
["22.","-",null,"-",null,"-",null,"t","> 1 m"]
["23.","-",null,"-",null,"-",null,"t","> 1 m"]
["24.","-",null,"-",null,"-",null,"-","-"]
["25.","7,5 °C/8,6 °C/13,3 °C",null,"-",null,"-",null,"n","Ab 29 cm"]
["26.","-",null,"-",null,"-",null,"-","-"]
["27.","7,6 °C/9,3 °C/12,7 °C",null,"-",null,"-",null,"n","Ab 26 cm"]
["28.","5,7 °C/7,5 °C/11,3 °C",null,"-",null,"-",null,"h","Ab 40 cm"]
["29.","4,2 °C/5,9 °C/11,4 °C",null,"-",null,"-",null,"h","Ab 42 cm"]
["30.","-",null,"-",null,"-",null,"-","-"]
["31.","-",null,"-",null,"-",null,"-","-"]
[]
[null,"Temperatur - 10 cm/Temperatur - 20 cm/Temperatur -50 cm"]