{"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":2,"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",1,86,1007.9,-2.6,8,null,"00",0,88,1009.6,-3.1,8]
["01",1,87,1007.8,-3.7,8,null,"01",0,89,1009.4,-3.3,8]
["02",0,88,1007.5,-3.4,8,null,"02",1,89,1009.3,-3.5,8]
["03",0,89,1007.6,-3.5,8,null,"03",1,89,1009.3,-3.5,8]
["04",1,91,1007.4,-3,8,null,"04",0,90,1009.1,-3.1,8]
["05",0,94,1007.4,-2.9,8,null,"05",1,91,1009.2,-3.2,8]
["06",0,94,1007.6,-2.9,8,null,"06",1,92,1009.2,-3.3,8]
["07",0,94,1007.9,-2.5,8,null,"07",0,93,1009.5,-3.4,8]
["08",0,93,1007.8,-2,8,null,"08",0,92,1009.7,-3.1,8]
["09",1,92,1008.2,-1.9,7,null,"09",1,89,1009.8,-2.7,8]
["10",1,89,1008.3,-1.5,7,null,"10",1,83,1010,-2.1,8]
["11",1,84,1007.9,-1.6,7,null,"11",2,74,1009.7,-2.9,8]
["12",1,78,1007.6,-1.8,7,null,"12",1,82,1009.7,-2.2999999999999998,8]
["13",1,73,1007.7,-2.2000000000000002,7,null,"13",1,84,1009.7,-2.1,8]
["14",1,64,1007.6,-3.5,7,null,"14",1,77,1009.5,-2.2000000000000002,8]
["15",1,66,1007.4,-3.6,8,null,"15",1,84,1009.5,-1.2,8]
["16",1,70,1007.7,-3.1,8,null,"16",1,86,1009.6,-1.6,8]
["17",1,67,1007.8,-3.8,8,null,"17",1,85,1009.9,-1.9,8]
["18",1,74,1007.8,-3,8,null,"18",1,93,1010.1,-1.2,8]
["19",1,78,1008.4,-2.6,8,null,"19",1,94,1010.5,-1.4,8]
["20",1,82,1008.9,-2.8,8,null,"20",1,90,1010.8,-2.2000000000000002,8]
["21",1,84,1009,-2.8,8,null,"21",1,93,1010.9,-1.9,8]
["22",0,84,1009.4,-3,8,null,"22",1,92,1010.6,-2.1,8]
["23",1,85,1009.6,-3,8,null,"23",1,92,1010.6,-2.2000000000000002,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.7},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":82.8},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1008},{"$f":"AVERAGE(E3:E26)","v":-2.7791666666666663},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":7.8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.8},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":88},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1009.8},{"$f":"AVERAGE(L3:L26)","v":-2.4791666666666674},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":8}]
[]
[null,null,null,null,"2013-03-30",null,null,null,null,null,null,"2013-03-31"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",1,93,1010.2,-2.2999999999999998,8,null,"00",0,86,1009,-1.7,7]
["01",1,92,1010,-2.7,8,null,"01",1,95,1008.4,-1.1000000000000001,8]
["02",1,93,1010.2,-2.8,8,null,"02",0,97,1007.4,-0.9,8]
["03",1,93,1010.2,-2.9,8,null,"03",0,97,1006.6,-0.9,8]
["04",1,92,1010,-3,8,null,"04",0,97,1006.2,-0.9,8]
["05",1,93,1009.9,-2.8,8,null,"05",0,96,1005.5,-0.9,8]
["06",1,94,1009.9,-2.8,8,null,"06",0,95,1005.3,-0.9,8]
["07",1,93,1010.2,-2.6,8,null,"07",0,93,1005,-1,8]
["08",1,91,1010.6,-2.5,8,null,"08",0,89,1005,-0.6,7]
["09",1,89,1010.7,-2.6,8,null,"09",1,84,1005.3,-0.3,7]
["10",1,88,1011.1,-2.6,8,null,"10",1,82,1005.9,-0.3,8]
["11",1,86,1011.3,-2.6,8,null,"11",2,78,1006.1,-1.4,8]
["12",1,76,1011.4,-2.8,8,null,"12",1,78,1006.4,-1.5,8]
["13",1,75,1011.6,-3,8,null,"13",1,74,1006.3,-1.8,8]
["14",1,85,1011.9,-2.8,8,null,"14",2,77,1006.4,-1.8,8]
["15",null,null,null,null,null,null,"15",2,77,1006.7,-2.2000000000000002,8]
["16",null,null,null,null,null,null,"16",1,83,1007,-1.4,8]
["17",null,null,null,null,null,null,"17",1,85,1006.9,-1.2,8]
["18",null,null,null,null,null,null,"18",1,87,1007.3,-1.3,8]
["19",null,null,null,null,null,null,"19",1,87,1007.6,-1.7,8]
["20",null,null,null,null,null,null,"20",0,88,1008.1,-2,8]
["21",null,null,null,null,null,null,"21",0,88,1007.9,-2.1,8]
["22",null,null,null,null,null,null,"22",0,87,1007.9,-2.2000000000000002,8]
["23",null,null,null,null,null,null,"23",0,87,1008.1,-2.4,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":1},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":88.9},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1010.6},{"$f":"AVERAGE(E33:E56)","v":-2.7199999999999998},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":8},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.6},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":87},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1006.8},{"$f":"AVERAGE(L33:L56)","v":-1.3541666666666667},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":7.9}]
[]
[null,null,null,null,"2013-04-01",null,null,null,null,null,null,"2013-03-29"]

{"sheet":"Kurztabelle","index":1,"n_rows":54,"n_cols":34,"rows_kept":54,"cut":false,"hidden":false,"merged":[[1,12,1,13],[1,18,1,19]]}
[]
["Wetterwarte: Köttewitz",null,null,null,null,null,null,null,null,null,null,"Monat:","März",null,null,null,null,null,null,null,null,null,null,null,"Jahr:",2013]
[]
["Dat.","TTT","TxTx","TnTn","Tg","Umin.","UU","NN","RRRR","Art",null,"sss","PPPP","eee","fff",null,null,"Tage mit",null,null,null,"fk"]
[null,null,null,null,null,null,null,null,null,"*",null,null,null,null,"Bft","SS","Art ( D )","NE","Ge","Bf6","Bf8","Bft"]
["01.",1.3,2.2999999999999998,0.4,0,81,88,8,0,null,null,0,1022.7,-0.4,1,7,"*",null,null,null,null,4,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"]
["02.",0.6,4.3,-2.7,-3.9,70,86,4.0999999999999996,0,null,null,4,1023.9,-1.6,1,6,"*",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":4},{"$f":"COUNTIF(I6:I15,\">=1\")","v":3},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0}]
["03.",1.7,3.3,0.2,-1.1000000000000001,75,83,7,0,null,null,0,1021.5,-0.9,1,5,"*",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":3},null,{"$f":"COUNTIF(I18:I27,\">=0,1\")","v":7},{"$f":"COUNTIF(I18:I27,\">=1\")","v":3},{"$f":"COUNTIF(I18:I27,\">=3\")","v":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0}]
["04.",2.2999999999999998,6.3,-1.3,-2.1,61,80,1.1000000000000001,0,null,null,5.5,1023.5,-0.9,0,4,"D",null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(C30:C40,\">=30\")","v":0},{"$f":"COUNTIF(C30:C40,\">=25\")","v":0},{"$f":"COUNTIF(C30:C40,\"<0\")","v":4},null,{"$f":"COUNTIF(I30:I40,\">=0,1\")","v":7},{"$f":"COUNTIF(I30:I40,\">=1\")","v":2},{"$f":"COUNTIF(I30:I40,\">=3\")","v":1},{"$f":"COUNTIF(I30:I40,\">=10\")","v":0}]
["05.",4.3,8.6,1,-1.1000000000000001,60,71,0,0,null,null,4.3,1015.7,-0.7,1,3,"D",null,null,null,null,3]
["06.",5.3,11.7,1,-1.7,49,71,1.7,0,null,null,4.5,1007.3,0.3,1,3,"V",null,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.",6.2,11.1,2.5,0,75,87,7.3,2,"R",null,0,1003.6,4.0999999999999996,1,0,"R",1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":3},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":6},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":0}]
["08.",3.2,5.2,0.7,0.6,94,96,8,0.1,"R",null,0,1005.6,2.7,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D18:D27,\"<0\")","v":10},{"$f":"COUNTIF(D18:D27,\"<=-10\")","v":2},null,null,{"$f":"COUNTIF(F18:F27,\">=70\")","v":6},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":0}]
["09.",1.4,2.8,0.2,0,93,96,8,2.8,"R",null,0,1004.9,0.9,1,null,null,1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D30:D40,\"<0\")","v":11},{"$f":"COUNTIF(D30:D40,\"<=-10\")","v":1},null,null,{"$f":"COUNTIF(F30:F40,\">=70\")","v":5},null,{"$f":"COUNTIF(F30:F40,\"<=40\")","v":0}]
["10.",4.0999999999999996,11.3,-1.6,-2.1,66,92,7.2,1.8,"SR",null,1.3,999.4,3,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":30.4},{"$f":"SUM(C6:C15)","v":66.900000000000006},{"$f":"SUM(D6:D15)","v":0.39999999999999947},{"$f":"SUM(E6:E15)","v":-11.399999999999999},"XXX",{"$f":"SUM(G6:G15)","v":850},{"$f":"SUM(H6:H15)","v":52.400000000000006},{"$f":"SUM(I6:I15)","v":6.7},{"$f":"SUM(K6:K15)","v":0},null,{"$f":"SUM(L6:L15)","v":19.600000000000001},{"$f":"SUM(M6:M15)","v":10128.1},{"$f":"SUM(N6:N15)","v":6.5},{"$f":"SUM(O6:O15)","v":9},{"$f":"COUNT(P6:P15)","v":7},"X",{"$f":"SUM(R6:R15)","v":4},{"$f":"SUM(S6:S15)","v":0},{"$f":"SUM(T6:T15)","v":0},{"$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":"SUM(B16/10)","v":3.04},{"$f":"AVERAGE(C16/10)","v":6.69},{"$f":"AVERAGE(D16/10)","v":3.9999999999999945E-2},{"$f":"E16/10","v":-1.1399999999999999},"XXX",{"$f":"AVERAGE(G16/10)","v":85},{"$f":"AVERAGE(H16/10)","v":5.24},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M16/10)","v":1012.8100000000001},{"$f":"AVERAGE(N16/10)","v":0.65},{"$f":"O16/10","v":0.9},"XXX","X","XX","XX","XX","XX","XXX",null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":0},{"$f":"COUNTIF(L6:L15,\"<1\")","v":5},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":6},{"$f":"COUNTIF(P6:P15,\">=3\")","v":6},{"$f":"COUNTIF(P6:P15,\">=10\")","v":0}]
["11.",-3.9,-1.6,-4.5999999999999996,-4.4000000000000004,87,91,8,0.8,"S",null,0,1005.2,-5.2,1,0,"R",1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":0},{"$f":"COUNTIF(L18:L27,\"<1\")","v":5},{"$f":"COUNTIF(L18:L27,\">=10\")","v":0},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":9},{"$f":"COUNTIF(P18:P27,\">=3\")","v":9},{"$f":"COUNTIF(P18:P27,\">=10\")","v":5}]
["12.",-4.2,-3.2,-4.9000000000000004,-4.4000000000000004,83,91,8,5.0999999999999996,"S",null,0,1005,-5.5,1,5,"*",1,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(L30:L40,\".\")","v":0},{"$f":"COUNTIF(L30:L40,\"<1\")","v":4},{"$f":"COUNTIF(L30:L40,\">=10\")","v":0},null,{"$f":"COUNTIF(P30:P40,\">=1\")","v":11},{"$f":"COUNTIF(P30:P40,\">=3\")","v":11},{"$f":"COUNTIF(P30:P40,\">=10\")","v":2}]
["13.",-4.5999999999999996,-3.1,-5.9,-3.3,79,88,7.9,0.2,"S",null,0,1004.8,-6.2,1,14,"*",1,null,null,null,2]
["14.",-5.5,0,-10.9,-7.2,53,80,1.3,0,null,null,7,1010.3,-8.6,1,12,"*",null,null,null,null,3,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",-3.6,0.3,-7.6,-6.7,70,86,5.7,0.3,"S",null,3.5,1015.4,-5.5,1,10,"*",1,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B40)","v":6.2},{"$f":"MAX(C6:C15,C18:C27,C30:C40)","v":11.7},{"$f":"MIN(E6:E15,E18:E27,E30:E40)","v":-13.9},null,{"$f":"MAX(I6:I15,I18:I27,I30:I40)","v":9.4}]
["16.",-4.5,2.7,-11.5,-11.1,55,74,0.3,0,null,null,6,1019.6,-8.8000000000000007,1,8,"*",null,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",-0.1,4.4000000000000004,-3.8,-6.1,57,67,6.5,0,null,null,3.8,1010.8,-5.7,1,8,"*",null,null,null,null,4,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B40)","v":-6.2},{"$f":"MIN(D6:D15,D18:D27,D30:D40)","v":-12.7},{"$f":"MIN(F6:F15,F18:F27,F30:F40)","v":41},null,{"$f":"MAX(P6:P15,P18:P27,P30:P40)","v":14}]
["18.",1.2,4.5999999999999996,-0.5,-1.7,68,80,8,7.1,"S",null,0,998.7,-2,1,5,"D",1,null,null,null,3]
["19.",-0.4,1.3,-1.8,-2.2000000000000002,86,93,8,3.8,"S",null,0,996.8,-1.4,0,13,"*",1,null,null,null,3]
["20.",1.6,5.0999999999999996,-0.8,-0.6,80,88,7.3,0.9,"SR",null,4.5,1005.9,-0.2,0,12,"*",1,null,null,null,1]
["Su",{"$f":"SUM(B18:B27)","v":-24},{"$f":"SUM(C18:C27)","v":10.5},{"$f":"SUM(D18:D27)","v":-52.29999999999999},"XXXX","XXX",{"$f":"SUM(G18:G27)","v":838},{"$f":"SUM(H18:H27)","v":61},{"$f":"SUM(I18:I27)","v":18.2},{"$f":"SUM(K18:K27)","v":0},null,{"$f":"SUM(L18:L27)","v":24.8},{"$f":"SUM(M18:M27)","v":10072.5},{"$f":"SUM(N18:N27)","v":-49.1},{"$f":"SUM(O18:O27)","v":8},{"$f":"COUNT(P18:P27)","v":10},"X",{"$f":"SUM(R18:R27)","v":7},{"$f":"SUM(S18:S27)","v":0},{"$f":"SUM(T18:T27)","v":0},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B28/10)","v":-2.4},{"$f":"AVERAGE(C28/10)","v":1.05},{"$f":"AVERAGE(D28/10)","v":-5.2299999999999986},"XXXX","XXX",{"$f":"AVERAGE(G28/10)","v":83.8},{"$f":"AVERAGE(H28/10)","v":6.1},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M28/10)","v":1007.25},{"$f":"AVERAGE(N28/10)","v":-4.91},{"$f":"O28/10","v":0.8},"XXX","X","XX","XX","XX","XX","XXX"]
["21.",0.2,2.8,-1.1000000000000001,-1.7,77,89,7.6,0.4,"S",null,0,1015,-1.4,1,6,"*",1,null,null,null,4]
["22.",-2.1,-0.6,-3.9,-4.4000000000000004,81,88,7.5,0.2,"S",null,0,1021.2,-3.7,1,7,"*",1,null,null,null,4]
["23.",-6.1,-3.7,-9.1,-10,47,70,3.5,0,null,null,9.8000000000000007,1024.4000000000001,-10.6,2,6,"*",null,null,null,null,4]
["24.",-6.2,-0.8,-12.7,-13.9,44,66,3,0,null,null,9,1024,-11.9,2,6,"*",null,null,null,null,5]
["25.",-3.8,-0.6,-6.9,-8.3000000000000007,56,69,6.1,0,null,null,5.8,1019.4,-8.8000000000000007,2,6,"*",null,null,null,null,5]
["26.",-3.1,0,-6.3,-7.8,41,63,6.2,0,null,null,6.3,1015.6,-9.4,2,5,"D",null,null,null,null,5]
["27.",-2.2999999999999998,0.7,-5,-5.6,56,72,8,0.2,"S",null,3.2,1014.7,-6.8,2,5,"D",1,null,null,null,5]
["28.",-1.3,0.8,-3.7,-4.4000000000000004,82,89,7.9,9.4,"S",null,0,1012.7,-3,1,5,"D",null,null,null,null,2]
["29.",0.6,3.2,-0.8,-1.7,72,87,7.9,0.3,"S",null,1.5,1006.8,-1.4,1,12,"*",null,null,null,null,4]
["30.",-0.1,3.1,-2.2000000000000002,-2.8,60,83,7.8,0.1,"S",null,4,1008,-2.8,1,11,"*",1,null,null,null,2]
["31.",-0.7,1.5,-2.5,-2.8,73,88,8,2.2000000000000002,"S",null,0.8,1009.8,-2.5,1,8,"*",1,null,null,null,3]
["Su",{"$f":"SUM(B30:B40)","v":-24.900000000000002},{"$f":"SUM(C30:C40)","v":6.3999999999999995},{"$f":"SUM(D30:D40)","v":-54.199999999999996},"XXXX","XXX",{"$f":"SUM(G30:G40)","v":864},{"$f":"SUM(H30:H40)","v":73.5},{"$f":"SUM(I30:I40)","v":12.8},{"$f":"SUM(K30:K40)","v":0},null,{"$f":"SUM(L30:L40)","v":40.4},{"$f":"SUM(M30:M40)","v":11171.599999999999},{"$f":"SUM(N30:N40)","v":-62.3},{"$f":"SUM(O30:O40)","v":16},{"$f":"COUNT(P30:P40)","v":11},"X",{"$f":"SUM(R30:R40)","v":5},{"$f":"SUM(S30:S40)","v":0},{"$f":"SUM(T30:T40)","v":0},{"$f":"SUM(U30:U40)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B41/11)","v":-2.2636363636363637},{"$f":"AVERAGE(C41/11)","v":0.58181818181818179},{"$f":"AVERAGE(D41/11)","v":-4.9272727272727268},"XXXX","XXX",{"$f":"AVERAGE(G41/11)","v":78.545454545454547},{"$f":"AVERAGE(H41/11)","v":6.6818181818181817},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M41/11)","v":1015.5999999999999},{"$f":"AVERAGE(N41/11)","v":-5.6636363636363631},{"$f":"O41/11","v":1.4545454545454546},"XXX","X","XX","XX","XX","XX","XXX"]
["MSu",{"$f":"SUM(B16+B28+B41)","v":-18.500000000000004},{"$f":"SUM(C16+C28+C41)","v":83.800000000000011},{"$f":"SUM(D16+D28+D41)","v":-106.1},"XXXX","XXX",{"$f":"SUM(G16+G28+G41)","v":2552},{"$f":"SUM(H16+H28+H41)","v":186.9},{"$f":"SUM(I16+I28+I41)","v":37.700000000000003},{"$f":"SUM(J16+J28+J41)","v":0},null,{"$f":"SUM(L16+L28+L41)","v":84.800000000000011},{"$f":"SUM(M16+M28+M41)","v":31372.199999999997},{"$f":"SUM(N16+N28+N41)","v":-104.9},"XXX",{"$f":"SUM(P16+P28+P41)","v":28},"X",{"$f":"SUM(R16+R28+R41)","v":16},{"$f":"SUM(S16+S28+S41)","v":0},{"$f":"SUM(T16+T28+T41)","v":0},{"$f":"SUM(U16+U28+U41)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B17,B29,B42)","v":-0.54121212121212114},{"$f":"AVERAGE(C43/31)","v":2.7032258064516133},{"$f":"AVERAGE(D43/31)","v":-3.4225806451612901},"XXXX","XXX",{"$f":"AVERAGE(G43/31)","v":82.322580645161295},{"$f":"AVERAGE(H43/31)","v":6.0290322580645164},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M43/31)","v":1012.0064516129031},{"$f":"AVERAGE(N43/31)","v":-3.3838709677419359},{"$f":"O17+O29+O42/3","v":2.184848484848485},"XXX","X","XX","XX","XX","XX","XXX"]
[]
[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":18},"ohne Sonne",null,null,null,null,null,13]
["TTT",4,"XXXX",{"$f":"SUM(B44-B48)","v":-4.541212121212121},"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,1]
["RRR",42,{"$f":"SUM(I43*100/B49)","v":89.761904761904773},"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",121,{"$f":"SUM(L43*100/B50)","v":70.082644628099189},"XXXX","Eistag",null,null,null,{"$f":"SUM(AC7:AC9)","v":7},null,null,">/=10,0",null,null,{"$f":"SUM(AH7:AH9)","v":0},"Schneedecke cm"]
["astr.",null,null,"XXXX","Min.d.Lufttemp.°C",null,null,null,null,null,null,">/=  20,0",null,null,0,">/=   1",null,null,null,null,null,{"$f":"SUM(AE17:AE19)","v":26}]
["mgl.",372,{"$f":"SUM(L43*100/B52)","v":22.795698924731187},"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":24},null,null,"Rel. Luftfeuchte 14 Uhr",null,null,null,">/=   3",null,null,null,null,null,{"$f":"SUM(AF17:AF19)","v":26}]
["sss",null,null,"XXXX","starker Eistag",null,null,null,{"$f":"SUM(AB12:AB14)","v":3},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":17},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":7}]
[null,null,null,null,null,null,null,null,null,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":0}]

{"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:",2013]
[]
["Dat.","Nebeldauer","Nebel","Dunst","Sicht","Sicht","Sicht","Sicht"]
[null,"in St. u. Min.",null,null,"mittel","normal","gut","sehr gut"]
["01.","-",{"$f":"IF(R9=1,1,\"-\")","v":"-"},{"$f":"IF(R9=2,1,\"-\")","v":"-"},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.","-","-","-",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,"-","-",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.","-","-",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,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["18.","03:20:00",1,1,1,1,"-","-",null,null,null,null,null,3.3333333333333335," ",2,3,2]
["19.","03:00:00",1,1,1," -","-","-",null,null,null,null,null,3," ",2,3,2]
["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,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,"-","-",null,null,null,null,null," "," "," "," ",0]
["27.","-","-","-",1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["28.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["29.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["30.","-","-",1,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["31.","-",{"$f":"IF(R39=1,1,\"-\")","v":"-"},1,"-","-","-","-",null,null,null,null,null,{"$f":"IF(ISNUMBER(B39),B39*24,\" \")","v":" "},{"$f":"IF(ISNUMBER(N39),IF(N39<1,1,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N39),IF(N39<8,2,\" \"),\" \")","v":" "},{"$f":"IF(ISNUMBER(N39),IF(N39<24,3,\" \"),\" \")","v":" "},{"$f":"MIN(O39:Q39)","v":0}]
["Su.","XXXXXXXXX",{"$f":"SUM(C9:C39)","v":2},15,24,15,0,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C40)","v":2}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G40,H40)","v":0}]

{"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,"(213 m ü. NHN)"]
[]
["März 2013"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":11.7},"am","2013-03-06"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B33","v":-0.59677419354838701},{"$f":"Kurztabelle!B48","v":4},{"$f":"C7-D7","v":-4.596774193548387},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":-12.7},"am","2013-03-16"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I43","v":37.700000000000003},{"$f":"Kurztabelle!B49","v":42},{"$f":"100/D9*C9","v":89.761904761904773},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L43","v":84.800000000000011},{"$f":"Kurztabelle!B50","v":121},{"$f":"100/D10*C10","v":70.082644628099189},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die Wetterstation kann, durch geographische Hindernisse, nicht die maximal mögliche Sonnenscheindauer aufzeichnen. Es gilt ein Übergangsprozentsatz von: Nov - Feb 50 %; Mär/Apr & Sep/Okt 65 %; Mai - Aug 80 %."]
["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":34,"n_cols":12,"rows_kept":34,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2013-03-01",1.3,2.2999999999999998,0.4,null,7,0,1022.7,1.7]
["2013-03-02",0.6,4.3,-2.7,null,6,4,1023.9,1.85]
["2013-03-03",1.7,3.3,0.2,null,5,0,1021.5,2,"HM"]
["2013-03-04",2.2999999999999998,6.3,-1.3,null,4,5.5,1023.5,2.2000000000000002]
["2013-03-05",4.3,8.6,1,null,3,4.3,1015.7,2.35,"SEa"]
["2013-03-06",5.3,11.7,1,null,3,4.5,1007.3,2.5,null,null,"Um 13:30 Uhr Nebensonne."]
["2013-03-07",6.2,11.1,2.5,2,0,0,1003.6,2.65,null,null,"Von 21:00 Uhr - 22:59 Uhr mäßiger Dunst. Von 20:00 Uhr - 20:59 Uhr; 23:00 Uhr - 23:59 Uhr leichter Dunst."]
["2013-03-08",3.2,5.2,0.7,0.1,null,0,1005.6,2.8,"U",null,"Vonn 00:00 Uhr - 08:30 Uhr; 21:00 Uhr - 23:59 Uhr  leichter Dunst."]
["2013-03-09",1.4,2.8,0.2,2.8,null,0,1004.9,2.95,"HFz","H Hildi","Von 17:01 Uhr - 23:59 Uhr mäßiger Dunst. Von 00:00 Uhr - 13:59 Uhr; 15:30 Uhr - 17:00 Uhr leichter Dunst."]
["2013-03-10",4.0999999999999996,11.3,-1.6,1.8,null,1.3,999.4,3.1,null,null,"Von 21:30 Uhr - 23:59 Uhr starker Dunst. Von 17:30 Uhr - 21:29 Uhr mäßiger Dunst.Von 15:00 Uhr - 17:30 Uhr leichter Dunst."]
["2013-03-11",-3.9,-1.6,-4.5999999999999996,0.8,0.1,0,1005.2,3.25,"HNz",null,"Von 00:00 Uhr - 00:59 Uhr mäßiger Dunst. Von 01:00 Uhr - 01:29 Uhr leichter Dunst."]
["2013-03-12",-4.2,-3.2,-4.9000000000000004,5.0999999999999996,5,0,1005,3.4,null,null,"Von 17:00 Uhr - 23:59 Uhr starker Dunst. Von 17:00 Uhr - 23:59 Uhr Sichteinschränkung durch Niederschlag. Von 02:20 Uhr - 08:59 Uhr leichter Dunst."]
["2013-03-13",-4.5999999999999996,-3.1,-5.9,0.2,14,0,1004.8,3.55,"Nez",null,"Von 00:00 Uhr - 07:09 Uhr starker Dunst. Von 07:10 Uhr - 07:29 Uhr mäßiger Dunst. Von 07:30 Uhr - 07:49 Uhr; 09:20 Uhr - 10:59 Uhr leichter Dunst. Von 09:20 Uhr - 09:49 Uhr Sichteinschränkung durch Niederschlag."]
["2013-03-14",-5.5,0,-10.9,null,12,7,1010.3,3.7]
["2013-03-15",-3.6,0.3,-7.6,0.3,10,3.5,1015.4,3.85,null,"H Ilse","Von 00:00 Uhr - 08:59 Uhr leichter Dunst."]
["2013-03-16",-4.5,2.7,-11.5,null,8,6,1019.6,4,"HM"]
["2013-03-17",-0.1,4.4000000000000004,-3.6,null,8,3.8,1010.8,4.1500000000000004,"TB","T Birk"]
["2013-03-18",1.2,4.5999999999999996,-0.5,7.1,5,0,998.7,4.3,null,null,"Von 21:40 Uhr - 23:59 Uhr leichter Nebel. Von 20:10 Uhr - 21:39 Uhr starker Dunst. Von 19:30 Uhr - 20:09 Uhr mäßiger Dunst. Von 18:30 Uhr - 19:29 Uhr leichter Dunst. Von 18:30 Uhr - 23:59 Uhr Sichteinschränkung durch Niederschlag."]
["2013-03-19",-0.4,1.3,-1.8,3.8,13,0,996.8,4.45,null,null,"Von 00:00 Uhr - 02:59 Uhr leichter Nebel. Von 03:00 Uhr - 09:20 Uhr; 16:20 Uhr - 18:59 Uhr starker Dunst. Von 22:00 Uhr - 23:59 Uhr mittlere Dunst. Von 00:00 Uhr - 09:20 Uhr; 16:20 Uhr - 18:59 Uhr  Sichteinschränkung durch Niederschlag."]
["2013-03-20",1.6,5.0999999999999996,-0.8,0.9,12,4.5,1009.5,4.5999999999999996,null,"T Andreas"]
["2013-03-21",0.2,2.8,-1.1000000000000001,0.4,6,0,1015,4.75,"Nez","t Birk","Von 06:30 Uhr - 08:19 Uhr mäßiger Dunst. Von 00:00 Uhr - 06:29 Uhr leichter Dunst. Von 06:30 Uhr - 08:19 Uhr Sichteinschränkung durch Niederschlag."]
["2013-03-22",-2.1,-0.6,-3.9,0.2,7,0,1021.2,4.9000000000000004,"HNFa","H Jill","Von 07:40 Uhr - 08:19 Uhr mäßiger Dunst. Von 07:40 Uhr - 08:19 Uhr Sichteinschränkung durch Niederschlag."]
["2013-03-23",-6.1,-3.7,-9.1,null,6,9.8000000000000007,1024.4000000000001,5.05,null,null,"Nachts Mondhof."]
["2013-03-24",-6.2,-0.8,-12.7,null,6,9,1024,5.2]
["2013-03-25",-3.8,-0.6,-6.9,null,6,5.8,1019.4,5.35,"HNa"]
["2013-03-26",-3.1,0,-6.3,null,5,6.3,1015.6,5.5]
["2013-03-27",-2.2999999999999998,0.7,-5,0.2,5,3.2,1014.7,5.65,"HNz"]
["2013-03-28",-1.3,0.8,-3.7,9.4,5,0,1012.7,5.8]
["2013-03-29",0.6,3.2,-0.8,0.3,12,1.5,1006.8,5.95,"HNFz","H Karin","Von 00:00 Uhr - 12:19 Uhr; 13:30 Uhr - 13:59 Uhr; 14:50 Uhr - 23:59 Uhr leichter Dunst."]
["2013-03-30",-0.1,3.1,-2.2000000000000002,0.1,11,4,1008,6.1,null,null,"Von 03:30 Uhr - 11:49 Uhr mäßiger Dunst. Von 00:00 Uhr - 03:29 Uhr; 11:50 - 13:39 Uhr leichter Dunst."]
["2013-03-31",-0.7,1.5,-2.5,2.2000000000000002,8,0.8,1009.8,6.3,null,null,"Von 00:00 Uhr - 11:20 Uhr; 14:30 Uhr - 23:59 Uhr leichter Dunst. Von 14:20 Uhr - 23:59 Uhr Sichteinschränkung durch Schneefall."]
["Durchschnitt",{"$f":"AVERAGE(B2:B32)","v":-0.59677419354838701},{"$f":"AVERAGE(C2:C32)","v":2.7032258064516128},-3.4161290322580649,null,null,null,{"$f":"AVERAGE(H2:H32)","v":1012.1225806451614},{"$f":"AVERAGE(I2:I32)","v":3.9967741935483869}]
["Mittel",4,null,null,42,"-",121,1016.3]