{"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,99,1026.5999999999999,3.6,8,null,"00",0,98,1028.4000000000001,4.0999999999999996,8]
["01",0,99,1026.4000000000001,3.7,8,null,"01",1,98,1028.2,4,8]
["02",0,99,1026.7,3.8,8,null,"02",1,98,1028.3,3.8,8]
["03",0,99,1026.7,3.9,8,null,"03",0,98,1028,3.8,8]
["04",0,99,1026.9000000000001,3.9,8,null,"04",0,98,1027.9000000000001,3.8,8]
["05",0,99,1027.3,4,8,null,"05",0,98,1027.8,3.8,8]
["06",0,99,1027.2,4.0999999999999996,8,null,"06",0,98,1027.8,3.8,8]
["07",0,99,1027.3,4.0999999999999996,8,null,"07",0,97,1027.5999999999999,3.7,8]
["08",0,99,1027.9000000000001,4.2,8,null,"08",1,97,1027.5999999999999,3.5,8]
["09",0,99,1028.2,4.4000000000000004,8,null,"09",0,94,1028.3,3.1,8]
["10",1,99,1028.3,4.5,8,null,"10",1,93,1028.2,3.1,8]
["11",1,99,1028.3,4.5999999999999996,8,null,"11",1,93,1028.2,3.4,8]
["12",1,99,1028.0999999999999,4.5999999999999996,8,null,"12",0,92,1027.8,3.3,8]
["13",1,99,1028,4.5999999999999996,8,null,"13",1,91,1027.2,3.3,8]
["14",1,99,1027.8,4.5,8,null,"14",1,91,1027,3.5,8]
[15,1,98,1027.8,4.2,8,null,"15",0,91,1026.5999999999999,3.4,8]
["16",1,98,1027.8,4.5,8,null,"16",0,92,1026.3,3.5,8]
["17",1,98,1028,4.2,8,null,"17",0,93,1026,3.4,8]
["18",1,98,1028,4.2,8,null,"18",1,94,1026.2,3.5,8]
["19",1,98,1028,4.2,8,null,"19",2,90,1026.0999999999999,2.9,8]
["20",1,98,1028.3,4.2,8,null,"20"]
["21",0,98,1028.3,4.0999999999999996,8,null,"21"]
["22",0,98,1028.4000000000001,4.0999999999999996,8,null,"22"]
["23",0,98,1028.4000000000001,4.2,8,null,"23"]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.5},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":98.6},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1027.7},{"$f":"AVERAGE(E3:E26)","v":4.1833333333333336},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.5},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":94.7},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1027.5},{"$f":"AVERAGE(L3:L26)","v":3.5350000000000001},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":8}]
[]
[null,null,null,null,"2014-11-20",null,null,null,null,null,null,"2014-11-21"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,96,1010.1,7.9,8,null,"00",1,97,1010.2,5.7,8]
["01",2,97,1009.8,7.9,7,null,"01",2,97,1010.4,5.4,8]
["02",2,97,1009.8,7.9,8,null,"02",2,97,1010.9,5.3,8]
["03",1,97,1009.3,7.8,8,null,"03",2,98,1011.4,4.9000000000000004,8]
["04",2,96,1009.4,7.7,8,null,"04",2,98,1011.9,4.5,8]
["05",2,95,1009.1,7.5,8,null,"05",2,98,1012.7,4.4000000000000004,8]
["06",2,95,1008.9,7.4,8,null,"06",1,98,1013.4,4.3,8]
["07",2,95,1008.8,7.1,8,null,"07",2,98,1014.3,4.2,8]
["08",1,95,1009,7.2,8,null,"08",2,98,1015.4,3.8,8]
["09",2,96,1009,7.3,8,null,"09",1,98,1016.5,3.7,8]
["10",2,95,1009,7.4,8,null,"10",1,98,1017.7,3.8,8]
["11",1,95,1008.7,7.4,8,null,"11",1,99,1018.3,3.9,8]
["12",2,93,1008.3,7.5,8,null,"12",2,98,1019,3.6,8]
["13",3,91,1008,7.2,8,null,"13",2,98,1019.7,3.7,8]
["14",2,94,1008.2,6.9,8,null,"14",2,98,1020.5,3.6,8]
["15",2,96,1008.4,6.7,8,null,"15",1,99,1021.3,3.6,8]
["16",2,96,1008.3,6.3,8,null,"16",1,99,1022,3.7,8]
["17",1,96,1008.5,6,8,null,"17",2,99,1022.9,3.6,8]
["18",2,96,1008.7,5.8,8,null,"18",1,99,1023.5,3.6,8]
["19",2,96,1009,5.9,8,null,"19",1,99,1024,3.6,8]
["20",1,96,1009,5.8,8,null,"20",1,99,1024.8,3.6,8]
["21",1,97,1009.5,6,8,null,"21",1,99,1025.4000000000001,3.5,8]
["22",1,97,1009.8,6,8,null,"22",1,99,1026,3.5,8]
["23",1,97,1010,5.8,8,null,"23",0,99,1026.4000000000001,3.5,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1.7},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":95.6},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1009},{"$f":"ROUND(AVERAGE(E33:E56),1)","v":6.9},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":1.4},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":98.3},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1018.3},{"$f":"ROUND(AVERAGE(L33:L56),1)","v":4},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":8}]
[]
[null,null,null,null,"2014-11-18",null,null,null,null,null,null,"2014-11-19"]

{"sheet":"Kurztabelle","index":1,"n_rows":112,"n_cols":35,"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,"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.",9.5,15.3,7,5,81,95,4.7,".",null,null,3.8,1023.1,8.6999999999999993,0,null,null,null,null,null,null,2,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.1,15.3,5.6,4.4000000000000004,77,94,4.5999999999999996,".",null,null,2.8,1017.9,8.1,1,null,null,null,null,null,null,3,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":2},{"$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.",8.1999999999999993,11.2,7.1,3.9,84,92,5.3,".",null,null,3,1010.7,7,2,null,null,null,null,1,null,6,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":5},{"$f":"COUNTIF(I18:I27,\">=1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":2},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0},{"$f":"COUNTIF(I18:I27,\">=20\")","v":0}]
["04.",8.9,11.4,6.5,4.4000000000000004,79,88,5.6,".",null,null,0.7,1000.7,7.1,2,null,null,null,null,1,null,6,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":0},{"$f":"COUNTIF(I30:I39,\">=1\")","v":0},{"$f":"COUNTIF(I30:I39,\">=3\")","v":0},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0},{"$f":"COUNTIF(I30:I39,\">=20\")","v":0}]
["05.",10.8,14.2,8.9,7.2,75,86,7.4,0.8,"R",null,".",1000.7,8.6,2,null,null,1,null,null,null,4]
["06.",8.6999999999999993,10.8,7.8,7.2,85,94,7.9,1.8,"R",null,0.1,1011.3,7.9,1,null,null,1,null,null,null,3,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.1,10.4,4,2.8,82,93,7.6,".",null,null,".",1011.5,7.1,1,null,null,null,null,null,null,3,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.",7.6,14,3.9,2.8,61,87,3.4,".",null,null,2.7,1015.3,5.4,1,null,null,null,null,null,null,4,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":10},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",6.8,11.1,2.1,1.1000000000000001,84,94,5.3,".",null,null,0.5,1013,5.8,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(D30:D39,\"<0\")","v":0},{"$f":"COUNTIF(D30:D39,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F30:F39,\">=70\")","v":0},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":0}]
["10.",6.9,9.6,3.5,2.2000000000000002,91,96,6.9,".",null,null,".",1013.1,6.3,1,null,null,null,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":84.600000000000009},{"$f":"SUM(C6:C15)","v":123.29999999999998},56.4,41,"XXX","XXX",{"$f":"SUM(H6:H15)","v":58.699999999999996},{"$f":"SUM(I6:I15)","v":2.6},"XX",null,{"$f":"SUM(L6:L15)","v":13.599999999999998},{"$f":"SUM(M6:M15)","v":10117.300000000001},72,12,{"$f":"SUM(P6:P15)","v":0},"X",{"$f":"SUM(R6:R15)","v":2},{"$f":"SUM(S6:S15)","v":0},2,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":8.4600000000000009},{"$f":"AVERAGE(C6:C15)","v":12.329999999999998},5.64,4.0999999999999996,"XXX",91.9,5.8699999999999992,"XXX","XX",null,{"$f":"L16/10","v":1.3599999999999999},{"$f":"AVERAGE(M6:M15)","v":1011.7300000000001},{"$f":"AVERAGE(N6:N15)","v":7.2},1.2,{"$f":"ROUND(AVERAGE(P6:P15),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":3.8},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.",9.6999999999999993,13.4,5.5,4.4000000000000004,84,93,5.7,".",null,null,0.1,1012.2,8.6,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":5},{"$f":"COUNTIF(L18:L27,\"<1\")","v":4},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",11.1,13.9,6.8,6.1,83,90,5.5,0,null,null,0.4,1005.8,9.6,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":0},{"$f":"COUNTIF(L30:L39,\"<1\")","v":0},{"$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.",8.1999999999999993,9.1,7.2,7.2,96,97,8,0.6,"R",null,".",1013.3,7.8,0,null,null,1,null,null,null,2]
["14.",10.7,13.5,7.7,5.6,81,91,5.4,".",null,null,2.7,1014,9.1999999999999993,2,null,null,null,null,null,null,5,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",10.9,13.7,8.6,6.1,77,87,6.2,".",null,null,0.5,1006.7,8.9,2,null,null,null,null,null,null,5,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":11.1},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":15.3},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":0.6},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":4}]
["16.",10,13,5.2,2.8,76,87,7,0.6,"R",null,0.5,1003.1,8,2,null,null,1,null,null,null,5,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",7,10.4,2.6,0.6,84,93,5.3,".",null,null,".",1009.6,5.8,1,null,null,null,null,null,null,4,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":4.2},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":2.1},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":61},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":0}]
["18.",7.6,8.8000000000000007,6.2,6.1,91,96,8,4,"R",null,".",1009,6.9,2,null,null,1,null,null,null,4]
["19.",4.2,6.2,3.6,3.9,97,98,8,3.2,"R",null,".",1018.3,4,1,null,null,1,null,null,null,3]
["20.",4.4000000000000004,4.8,3.8,3.9,98,99,8,1.4,"R",null,".",1027.7,4.2,1,null,null,1,null,null,null,2]
["Su",{"$f":"SUM(B18:B27)","v":83.8},{"$f":"SUM(C18:C27)","v":106.8},57.2,46.699999999999996,"XXX","XXX",{"$f":"SUM(H18:H27)","v":67.099999999999994},{"$f":"SUM(I18:I27)","v":9.8000000000000007},"XX",null,{"$f":"SUM(L18:L27)","v":4.2},{"$f":"SUM(M18:M27)","v":10119.700000000001},73,15,{"$f":"SUM(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":0},0,0,"XXX"]
["Mi",{"$f":"AVERAGE(B18:B27)","v":8.379999999999999},{"$f":"AVERAGE(C18:C27)","v":10.68},5.7200000000000006,4.67,86.7,93.1,6.7099999999999991,"XXX","XX",null,{"$f":"L28/10","v":0.42000000000000004},{"$f":"AVERAGE(M18:M27)","v":1011.97},{"$f":"AVERAGE(N18:N27)","v":7.3},1.5,{"$f":"ROUND(AVERAGE(P18:P27),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":4}]
["21."]
["22."]
["23."]
["24."]
["25."]
["26."]
["27."]
["28."]
["29."]
["30."]
["Su",{"$f":"SUM(B30:B39)","v":0},{"$f":"SUM(C30:C39)","v":0},{"$f":"SUM(D30:D39)","v":0},{"$f":"SUM(E30:E39)","v":0},"XXX",{"$f":"SUM(G30:G39)","v":0},{"$f":"SUM(H30:H39)","v":0},{"$f":"SUM(I30:I39)","v":0},"XX",null,{"$f":"SUM(L30:L39)","v":0},{"$f":"SUM(M30:M39)","v":0},{"$f":"SUM(N30:N39)","v":0},{"$f":"SUM(O30:O39)","v":0},{"$f":"SUM(P30:P39)","v":0},"X",{"$f":"SUM(R30:R39)","v":0},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":0},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B30:B39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(C30:C39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(D30:D39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(E30:E39)","v":{"$error":"#DIV/0!"}},"XXX",{"$f":"AVERAGE(G30:G39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(H30:H39)","v":{"$error":"#DIV/0!"}},"XXX ","XX",null,"XXX ",{"$f":"AVERAGE(M30:M39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(N30:N39)","v":{"$error":"#DIV/0!"}},{"$f":"AVERAGE(O30:O39)","v":{"$error":"#DIV/0!"}},{"$f":"ROUND(AVERAGE(P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":{"$error":"#DIV/0!"}}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":168.4},{"$f":"SUM(C16+C28+C40)","v":230.09999999999997},{"$f":"SUM(D16+D28+D40)","v":113.6},{"$f":"SUM(E16+E28+E40)","v":87.699999999999989},"XXX","XXX,",{"$f":"SUM(H16+H28+H40)","v":125.79999999999998},{"$f":"SUM(I16+I28+I40)","v":12.4},"XX",null,{"$f":"SUM(L16+L28+L40)","v":17.799999999999997},{"$f":"SUM(M16+M28+M40)","v":20237},{"$f":"SUM(N16+N28+N40)","v":145},"XXX",{"$f":"SUM(P16+P28+P40)","v":0},"X",{"$f":"SUM(R16+R28+R40)","v":7},{"$f":"SUM(S16+S28+S40)","v":0},{"$f":"SUM(T16+T28+T40)","v":2},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B6:B15,B18:B27,B30:B39)","v":8.42},{"$f":"AVERAGE(C6:C15,C18:C27,C30:C39)","v":11.504999999999999},{"$f":"AVERAGE(D6:D15,D18:D27,D30:D39)","v":5.68},{"$f":"AVERAGE(E6:E15,E18:E27,E30:E39)","v":4.3849999999999998},"XXX",{"$f":"AVERAGE(G6:G15,G18:G27,G30:G39)","v":92.5},{"$f":"AVERAGE(H6:H15,H18:H27,H30:H39)","v":6.29},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M6:M15,M18:M27,M30:M39)","v":1011.85},{"$f":"AVERAGE(N6:N15,N18:N27,N30:N39)","v":7.25},{"$f":"AVERAGE(O6:O15,O18:O27,O30:O39)","v":1.35},{"$f":"ROUND(AVERAGE(P6:P15,P18:P27,P30:P39),1)","v":{"$error":"#DIV/0!"}},"X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":{"$error":"#DIV/0!"}}]
[]
[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":7},"ohne Sonne",null,null,null,null,null,{"$f":"SUM(AA17:AA19)","v":8}]
["TTT",4.5,"XXXX",{"$f":"SUM(B43-B47)","v":3.92},"Tropentag/Hitzetag",null,null,null,{"$f":"SUM(AA7:AA9)","v":0},null,null,">/=  1,0",null,null,{"$f":"SUM(AF7:AF9)","v":4},"0,1 bis 0,9",null,null,null,null,null,{"$f":"SUM(AB17:AB19)","v":7}]
["RRR",56,{"$f":"SUM(I42*100/B48)","v":22.142857142857142},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":0},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":2},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":0}]
["sss",62,{"$f":"SUM(L42*100/B49)","v":28.709677419354836},"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.",270,{"$f":"SUM(L42*100/B51)","v":6.5925925925925917},"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":19},">/= 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:","November",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,"-","-",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.","-","-","-",1,1,"-"," -",null,null,null,null,null," "," "," "," ",0]
["04.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["05.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["06.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,1,"-",null,null,null,null,null," "," "," "," ",0]
["09.","03:40:00",1,1,1,1,"-","-",null,null,null,null,null,3.6666666666666661," ",2,3,2]
["10.","03:10:00",1,1,1,1,"-","-",null,null,null,null,null,3.166666666666667," ",2,3,2]
["11.","-","-","-",1,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["15.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["16.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","-","-",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,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["23.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["24.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["25.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["26.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-","-","-","-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-","-","-","-","-"]
["29.","-","-","-","-","-","-","-"]
["30.","-","-","-","-","-","-","-"]
["30.","-","-","-","-","-","-","-"]
["Su.",{"$f":"SUM(B9:B39)","v":"06:50:00"},2,10,17,14,1,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":2}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40)","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 2014"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C31)","v":15.3},"am","2014-11-01"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":8.42},{"$f":"Kurztabelle!B47","v":4.5},{"$f":"C7-D7","v":3.92},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D31)","v":2.1},"am","2014-11-09"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":12.4},{"$f":"Kurztabelle!B48","v":56},{"$f":"100/D9*C9","v":22.142857142857146},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":17.799999999999997},{"$f":"Kurztabelle!B49","v":62},{"$f":"100/D10*C10","v":28.709677419354833},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*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":119,"n_cols":12,"rows_kept":119,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2014-10-01",9.5,15.3,7,null,null,3.8,1023.1,7.4]
["2014-10-02",9.1,15.3,5.6,null,null,2.8,1017.9,7.2]
["2014-10-03",8.1999999999999993,11.2,7.1,null,null,3,1010.7,7]
["2014-10-04",8.9,11.4,6.5,null,null,0.7,1000.7,6.8,"SWz","T Quendresa"]
["2014-10-05",10.8,14.2,8.9,0.8,null,null,1000.7,6.6,"TrW","T Pia"]
["2014-10-06",8.6999999999999993,10.8,7.8,1.8,null,0.1,1011.3,6.4,null,null,"Gegen 09:00 Uhr; Von 21:00 Uhr - 23:59 Uhr leichter Regen (WW 61). In der Nacht zum 6. leichter Sprühregen (WW 51)."]
["2014-10-07",8.1,10.4,4,null,null,null,1011.5,6.2,null,null,"In der Nacht zum 7. leichter Sprühregen, unterbrochen (WW 50)."]
["2014-10-08",7.6,14,3.9,null,null,2.7,1015.3,6,"Sz","T Quendresa"]
["2014-10-09",6.8,11.1,2.1,null,null,0.5,1013,5.8,null,null,"Von 04:20 Uhr - 08:09 Uhr starker Nebel (100m) (WW 45). Von 04:10 Uhr - 04:19 Uhr mäßiger Nebel (WW 45). Von 04:00 Uhr - 04:09 Uhr leichter Nebel (WW 45)."]
["2014-10-10",6.9,9.6,3.5,null,null,null,1013.1,5.6,null,null,"Von 07:50 Uhr - 10:59 Uhr starker Nebel (100 m) (WW 45). Von 06:50 Uhr - 07:49 Uhr Bodennebel (WW 12). Von 04:40 Uhr - 06:49 Uhr Bodennebelschwaden (WW 11)."]
["2014-10-11",9.6999999999999993,13.4,5.5,null,null,0.1,1012.2,5.4,null,"T Stephanie 2"]
["2014-10-12",11.1,13.9,6.8,null,null,0.4,1005.8,5.2,null,null,"Von 23:50 Uhr - 23:59 Uhr starker Dunst (WW 10). Von 22:10 Uhr - 23:49 Uhr mäßiger Dunst (WW 10). Von 21:00 Uhr - 22:09 Uhr leichter Dunst (WW 10)."]
["2014-10-13",8.1999999999999993,9.1,7.2,0.6,null,null,1013.3,5,null,null,"Von 07:40 Uhr - 09:29 Uhr; 14:00 Uhr - 15:39 Uhr leichter Sprühregen, unterbrochen (WW 50). Von 00:00 Uhr - 10:09 Uhr starker Dunst (WW 10). Von 10:10 Uhr - 18:09 Uhr  mäßiger Dunst. (WW 10). Von 18:10 Uhr - 23:59 Uhr leichter Dunst. (WW 10)."]
["2014-10-14",10.7,13.5,7.7,null,null,2.7,1014,4.8,null,null,"Von 00:00 Uhr - 01:09 Uhr leichter Dunst (WW 10)."]
["2014-10-15",10.9,13.7,8.6,null,null,0.5,1006.7,4.5999999999999996]
["2014-10-16",10,13,5.2,0.6,null,0.5,1003.1,4.45,"SWz","T Stephanie","Von 10:00 Uhr - 10:39 Uhr leichter Regen (WW 61)."]
["2014-10-17",7,10.4,2.6,null,null,null,1009.6,4.25]
["2014-10-18",7.6,8.8000000000000007,6.2,4,null,null,1009,4.0999999999999996,"Sez (Vb)","T Thea","Von 13:10 Uhr - 14:09 Uhr; 15:10 Uhr - 15:59 Uhr mäßiger Regen (WW 63). Von 14:10 Uhr - 15:09 Uhr leichter Regen (WW 61). Von 16:00 Uhr - 23:59 Uhr starker Sprühregen, unterbrochen (WW 54). Von 09:00 Uhr - 09:39 Uhr mäßiger Sprühregen (WW 53)."]
["2014-10-19",4.2,6.2,3.6,3.2,null,null,1018.3,3.95,null,null,"Von 07:43 Uhr - 08:09 Uhr starker Regen (WW 61). Von 00:00 Uhr - 07:42 Uhr; 08:10 Uhr - 19:09 Uhr starker Sprühregen, unterbrochen (WW 54). Von 18:40 Uhr - 23:59 Uhr starker Dunst (WW 10)."]
["2014-10-20",4.4000000000000004,4.8,3.8,1.4,null,null,1027.7,3.75,null,null,"Von 08:00 Uhr - 10:20 Uhr leichter Regen, unterbrochen (WW 60). Von  00:00 Uhr - 11:19 Uhr starker Dunst (WW 10)."]
["2014-10-21",null,null,null,null,null,null,null,3.6,"U"]
["2014-10-22",null,null,null,null,null,null,null,3.45]
["2014-10-23",null,null,null,null,null,null,null,3.3]
["2014-10-24",null,null,null,null,null,null,null,3.15]
["2014-10-25",null,null,null,null,null,null,null,3]
["2014-10-26",null,null,null,null,null,null,null,2.85]
["2014-10-27",null,null,null,null,null,null,null,2.7]
["2014-10-28",null,null,null,null,null,null,null,2.5499999999999998]
["2014-10-29",null,null,null,null,null,null,null,2.4]
["2014-10-30",null,null,null,null,null,null,null,2.25]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":8.42},{"$f":"AVERAGE(C2:C31)","v":11.504999999999999},{"$f":"AVERAGE(D2:D31)","v":5.68},"-",null,{"$f":"AVERAGE(G2:G31)","v":1.4833333333333332},{"$f":"AVERAGE(H2:H31)","v":1011.85},{"$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":"Erdbodentem.","index":6,"n_rows":40,"n_cols":12,"rows_kept":40,"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],[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],[12,5,12,6],[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],[17,1,17,2],[23,3,23,4],[24,3,24,4],[18,3,18,4],[21,3,21,4],[22,3,22,4],[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],[25,1,25,2],[30,1,30,2],[26,1,26,2],[27,1,27,2],[28,5,28,6],[29,5,29,6],[26,5,26,6],[27,5,27,6],[30,3,30,4],[28,1,28,2],[29,1,29,2],[25,3,25,4],[26,3,26,4],[28,3,28,4],[29,3,29,4],[27,3,27,4],[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],[33,3,33,4],[32,5,32,6],[33,5,33,6],[34,1,34,2],[31,3,31,4],[32,3,32,4],[36,3,36,4],[36,5,36,6],[35,5,35,6],[35,1,35,2],[36,1,36,2],[35,3,35,4]]}
[null,null,null,null,"Erdbodentemperatur"]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","November",null,null,null,"Jahr:",2014]
[]
["Dat.","6 Uhr","7 Uhr","11 Uh","12 Uhr","19 Uhr",null,"NN","5 °C - "]
[null,null,null,null,null,null,null,null,"Eindringtiefe"]
["01.","-",null,"-",null,"-",null,"n","> 5 °C"]
["02.","-",null,"-",null,"-",null,"n","> 5 °C"]
["03.","8,0 °C/8,5 °C/11,4 °C",null,"-",null,"-",null,"n","> 5 °C"]
["04.","7,0 °C/8,0 °C/11,3 °C",null,"-",null,"-",null,"n","> 5 °C"]
["05.","-",null,"-",null,"-",null,"t","> 5 °C"]
["06.","-",null,"-",null,"-",null,"t","> 5 °C"]
["07.","-",null,"-",null,"-",null,"t","> 5 °C"]
["08.","-",null,"-",null,"-",null,"n","> 5 °C"]
["09.","-",null,"-",null,"-",null,"n","> 5 °C"]
["10.","6,0 °C/7,1 °C/10,9 °C",null,"-",null,"-",null,"t","> 5 °C"]
["11.","-",null,"-",null,"-",null,"n","> 5 °C"]
["12.","-",null,"-",null,"-",null,"n","> 5 °C"]
["13.","-",null,"-",null,"-",null,"t","> 5 °C"]
["14.","-",null,"-",null,"-",null,"n","> 5 °C"]
["15.","-",null,"-",null,"-",null,"n","> 5 °C"]
["16.","-",null,"-",null,"-",null,"t","> 5 °C"]
["17.","-",null,"-",null,"-",null,"n","> 5 °C"]
["18.","-",null,"-",null,"-",null,"t","> 5 °C"]
["19.","-",null,"-",null,"-",null,"-","-"]
["20.","-",null,"-",null,"-",null,"-","-"]
["21.","-",null,"-",null,"-",null,"-","-"]
["22.","-",null,"-",null,"-",null,"-","-"]
["23.","-",null,"-",null,"-",null,"-","-"]
["24.","-",null,"-",null,"-",null,"-","-"]
["25.","-",null,"-",null,"-",null,"-","-"]
["26.","-",null,"-",null,"-",null,"-","-"]
["27.","-",null,"-",null,"-",null,"-","-"]
["28.","-",null,"-",null,"-",null,"-","-"]
["29.","-",null,"-",null,"-",null,"-","-"]
["30.","-",null,"-",null,"-",null,"-","-"]
[]
[null,"Temperatur - 10 cm/Temperatur - 20 cm/Temperatur -50 cm"]