{"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,96,1024.7,6.5,8,null,"00",1,98,1010.4,5.5,8]
["01",1,96,1024.9000000000001,6.6,8,null,"01",1,97,1010.2,4.7,8]
["02",0,97,1025.0999999999999,6.6,8,null,"02",1,98,1010.6,4.5,8]
["03",0,98,1024.9000000000001,6.7,8,null,"03",1,98,1011.2,3.9,8]
["04",0,98,1024.9000000000001,6.7,8,null,"04",1,97,1011.9,3.3,8]
["05",0,96,1025.3,6.4,8,null,"05",1,97,1012.6,3.2,8]
["06",1,94,1025.4000000000001,6.3,8,null,"06",1,98,1013.5,3.2,8]
["07",1,94,1025.5,6.8,8,null,"07",1,97,1014.4,2.8,8]
["08",1,91,1025.5,7,8,null,"08",1,97,1015.6,3,8]
["09",1,92,1025.5999999999999,7.4,8,null,"09",1,97,1016.3,3.5,8]
["10",null,null,null,null,null,null,"10",1,96,1017.2,3.9,8]
["11",null,null,null,null,null,null,"11",1,90,1016.9,4.7,8]
["12",null,null,null,null,null,null,"12",1,82,1017.6,4.3,7]
["13",null,null,null,null,null,null,"13",1,82,1018,5.4,7]
["14",null,null,null,null,null,null,"14",1,75,1017.9,5,7]
["15",null,null,null,null,null,null,"15",1,73,1017.8,5.0999999999999996,7]
["16",null,null,null,null,null,null,"16",1,72,1017.8,5.2,7]
["17",null,null,null,null,null,null,"17",1,71,1017.5,5.0999999999999996,7]
["18",null,null,null,null,null,null,"18",0,75,1017.4,5.8,7]
["19",null,null,null,null,null,null,"19",0,80,1017.5,6,7]
["20",null,null,null,null,null,null,"20",0,84,1017.6,5.8,7]
["21",null,null,null,null,null,null,"21",0,87,1017.6,6.5,7]
["22",null,null,null,null,null,null,"22",0,89,1017.5,6.5,8]
["23",null,null,null,null,null,null,"23",0,89,1017.4,6.5,8]
["Mittel",{"$f":"ROUND(AVERAGE(B3:B26),1)","v":0.6},{"$f":"ROUND(AVERAGE(C3:C26),1)","v":95.2},{"$f":"ROUND(AVERAGE(D3:D26),1)","v":1025.2},{"$f":"AVERAGE(E3:E26)","v":6.7},{"$f":"ROUND(AVERAGE(F3:F26),1)","v":8},null,"Mittel",{"$f":"ROUND(AVERAGE(I3:I26),1)","v":0.8},{"$f":"ROUND(AVERAGE(J3:J26),1)","v":88.3},{"$f":"ROUND(AVERAGE(K3:K26),1)","v":1015.5},{"$f":"AVERAGE(L3:L26)","v":4.7249999999999988},{"$f":"ROUND(AVERAGE(M3:M26),1)","v":7.6}]
[]
[null,null,null,null,"2013-05-01",null,null,null,null,null,null,"2013-04-28"]
[]
[]
["Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung",null,"Stunde","Wind","Luftfeuchtigkeit","Luftdruck","Taupunkttemperatur","Bewölkung"]
["00",0,92,1017.3,6.1,8,null,"00",0,84,1021.1,5.6,4]
["01",1,93,1017.1,5.6,8,null,"01",0,88,1021.2,5.2,6]
["02",0,90,1016.5,5.6,8,null,"02",1,87,1021.5,4.8,6]
["03",1,90,1016.3,6.2,8,null,"03",1,87,1021.7,5.4,6]
["04",1,86,1015.7,6.3,8,null,"04",0,90,1021.8,4.9000000000000004,6]
["05",1,85,1015.6,6.3,8,null,"05",1,91,1022.1,5.2,7]
["06",1,85,1015.7,6.3,8,null,"06",0,92,1022.2,5.6,8]
["07",0,90,1016.6,7.2,8,null,"07",0,93,1022.6,6.3,8]
["08",0,88,1016.5,7.2,8,null,"08",0,94,1023.2,6.8,8]
["09",1,88,1016.3,7.9,8,null,"09",0,94,1023,7,8]
["10",1,88,1016.6,8.5,8,null,"10",0,93,1023,8,8]
["11",0,90,1017.2,9.6,8,null,"11",1,88,1022.4,8.6999999999999993,8]
["12",1,81,1016.8,8.9,8,null,"12",1,82,1022,8.3000000000000007,8]
["13",1,77,1017.2,9.1,8,null,"13",1,76,1021.5,8.1999999999999993,8]
["14",1,75,1017.3,9.1999999999999993,8,null,"14",1,74,1021.1,7.8,8]
["15",1,74,1017.5,8,8,null,"15",2,82,1021.8,8.1,8]
["16",1,70,1017.8,7.7,8,null,"16",1,82,1022,7.4,8]
["17",0,78,1018.3,9.4,6,null,"17",1,87,1022,7.3,8]
["18",1,65,1018.5,7.3,7,null,"18",0,93,1022,7.5,8]
["19",0,70,1019.2,7.1,6,null,"19",1,95,1022.6,7.4,8]
["20",1,79,1019.9,6.9,7,null,"20",1,96,1023.5,7.2,8]
["21",1,80,1020.6,6.7,7,null,"21",0,96,1023.9,7.1,8]
["22",0,83,1020.9,6.5,7,null,"22",1,95,1024.0999999999999,6.8,8]
["23",0,82,1021.1,6.1,7,null,"23",1,96,1024.3,6.7,8]
["Mittel",{"$f":"ROUND(AVERAGE(B33:B56),1)","v":0.6},{"$f":"ROUND(AVERAGE(C33:C56),1)","v":82.5},{"$f":"ROUND(AVERAGE(D33:D56),1)","v":1017.6},{"$f":"AVERAGE(E33:E56)","v":7.3208333333333329},{"$f":"ROUND(AVERAGE(F33:F56),1)","v":7.6},null,"Mittel",{"$f":"ROUND(AVERAGE(I33:I56),1)","v":0.6},{"$f":"ROUND(AVERAGE(J33:J56),1)","v":89},{"$f":"ROUND(AVERAGE(K33:K56),1)","v":1022.4},{"$f":"AVERAGE(L33:L56)","v":6.8041666666666645},{"$f":"ROUND(AVERAGE(M33:M56),1)","v":7.5}]
[]
[null,null,null,null,"2013-04-29",null,null,null,null,null,null,"2013-04-30"]

{"sheet":"Kurztabelle","index":1,"n_rows":53,"n_cols":34,"rows_kept":53,"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:","April",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.",-0.8,0.9,-2.1,-2.2000000000000002,71,86,8,0.1,"S",null,1.3,1011.5,-2.9,1,10,"*",1,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"]
["02.",-1.3,2.2999999999999998,-5.8,-6.1,65,84,7.8,0.1,"S",null,2,1014.9,-3.9,1,10,"*",1,null,null,null,4,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":2},{"$f":"COUNTIF(I6:I15,\">=3\")","v":0},{"$f":"COUNTIF(I6:I15,\">=10\")","v":0}]
["03.",-0.3,0.9,-1.1000000000000001,-1.7,73,82,8,".",null,null,".",1017.5,-3.1,2,9,"*",null,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(C18:C27,\">=30\")","v":0},{"$f":"COUNTIF(C18:C27,\">=25\")","v":1},{"$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":3},{"$f":"COUNTIF(I18:I27,\">=10\")","v":0}]
["04.",0.1,1.3,-1.3,-1.7,81,88,8,".",null,null,".",1014.4,-1.8,1,8,"D",null,null,null,null,2,null,null,null,null,{"$f":"COUNTIF(C30:C39,\">=30\")","v":0},{"$f":"COUNTIF(C30:C39,\">=25\")","v":1},{"$f":"COUNTIF(C30:C39,\"<0\")","v":0},null,{"$f":"COUNTIF(I30:I39,\">=0,1\")","v":6},{"$f":"COUNTIF(I30:I39,\">=1\")","v":4},{"$f":"COUNTIF(I30:I39,\">=3\")","v":2},{"$f":"COUNTIF(I30:I39,\">=10\")","v":0}]
["05.",0.9,2.1,-0.2,-0.6,83,88,8,0.3,"R",null,".",1010.8,-0.8,1,8,"D",1,null,null,null,3]
["06.",0.8,1.6,0.2,0,90,94,8,1.2,"R/S",null,".",1017.6,0,1,7,"D",1,null,null,null,2,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.",1.7,6.3,-1.8,-2.8,43,78,4.7,".",null,null,7.3,1021.2,-2.1,1,8,"D",null,null,null,null,3,null,null,null,null,{"$f":"COUNTIF(D6:D15,\"<0\")","v":7},{"$f":"COUNTIF(D6:D15,\"<=-10\")","v":0},null,null,{"$f":"COUNTIF(F6:F15,\">=70\")","v":5},null,{"$f":"COUNTIF(F6:F15,\"<=40\")","v":1}]
["08.",2.7,8.9,-4,-5,39,67,4.8,".",null,null,7.3,1012.2,-3.4,1,0,"V",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":0},null,{"$f":"COUNTIF(F18:F27,\"<=40\")","v":1}]
["09.",5.6,11.2,1.2,0.6,54,72,7.6,0.5,"R",null,6.3,1006.1,0.8,1,0,"R",1,null,null,null,3,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":3},null,{"$f":"COUNTIF(F30:F39,\"<=40\")","v":2}]
["10.",7.2,12.6,2.7,1.1000000000000001,62,84,7.4,1,"R",null,1.2,1006.9,4.5,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B6:B15)","v":16.600000000000001},{"$f":"SUM(C6:C15)","v":48.1},{"$f":"SUM(D6:D15)","v":-12.200000000000003},{"$f":"SUM(E6:E15)","v":-18.399999999999995},"XXX",{"$f":"SUM(G6:G15)","v":823},{"$f":"SUM(H6:H15)","v":72.3},{"$f":"SUM(I6:I15)","v":3.2},{"$f":"SUM(K6:K15)","v":0},null,{"$f":"SUM(L6:L15)","v":25.4},{"$f":"SUM(M6:M15)","v":10133.1},{"$f":"SUM(N6:N15)","v":-12.7},{"$f":"SUM(O6:O15)","v":11},{"$f":"COUNT(P6:P15)","v":9},"X",{"$f":"SUM(R6:R15)","v":6},{"$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":1.6600000000000001},{"$f":"AVERAGE(C16/10)","v":4.8100000000000005},{"$f":"AVERAGE(D16/10)","v":-1.2200000000000002},{"$f":"E16/10","v":-1.8399999999999994},"XXX",{"$f":"AVERAGE(G16/10)","v":82.3},{"$f":"AVERAGE(H16/10)","v":7.2299999999999995},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M16/10)","v":1013.3100000000001},{"$f":"AVERAGE(N16/10)","v":-1.27},{"$f":"O16/10","v":1.1000000000000001},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V6:V15)","v":3.1},null,null,null,null,{"$f":"COUNTIF(L6:L15,\".\")","v":4},{"$f":"COUNTIF(L6:L15,\"<1\")","v":0},{"$f":"COUNTIF(L6:L15,\">=10\")","v":0},null,{"$f":"COUNTIF(P6:P15,\">=1\")","v":7},{"$f":"COUNTIF(P6:P15,\">=3\")","v":7},{"$f":"COUNTIF(P6:P15,\">=10\")","v":2}]
["11.",9.8000000000000007,14.4,4.4000000000000004,1.7,67,80,7,3,"R",null,2.2999999999999998,1005.4,6.3,1,null,null,1,null,null,null,5,null,null,null,null,{"$f":"COUNTIF(L18:L27,\".\")","v":1},{"$f":"COUNTIF(L18:L27,\"<1\")","v":0},{"$f":"COUNTIF(L18:L27,\">=10\")","v":1},null,{"$f":"COUNTIF(P18:P27,\">=1\")","v":0},{"$f":"COUNTIF(P18:P27,\">=3\")","v":0},{"$f":"COUNTIF(P18:P27,\">=10\")","v":0}]
["12.",10.199999999999999,12.4,7.2,5,69,83,5.8,4,"R",null,1.3,1003.5,7.6,1,null,null,1,null,null,null,4,null,null,null,null,{"$f":"COUNTIF(L30:L39,\".\")","v":2},{"$f":"COUNTIF(L30:L39,\"<1\")","v":1},{"$f":"COUNTIF(L30:L39,\">=10\")","v":2},null,{"$f":"COUNTIF(P30:P39,\">=1\")","v":0},{"$f":"COUNTIF(P30:P39,\">=3\")","v":0},{"$f":"COUNTIF(P30:P39,\">=10\")","v":0}]
["13.",8.9,13.4,5.3,4.4000000000000004,56,76,4.3,3,"R/G",null,3.6,1016.3,4.7,1,null,null,1,null,null,null,5]
["14.",10,16.899999999999999,3.4,2.2000000000000002,52,78,4,".",null,null,3,1026.9000000000001,5.9,1,null,null,null,null,null,null,2,null,null,null,null,"Max TT","Max TxTx","Min TgTg",null,"Max RR"]
["15.",14.4,21,6.4,3.9,43,60,3.1,".",null,null,11.7,1023.1,6.2,1,null,null,null,null,null,null,3,null,null,null,null,{"$f":"MAX(B6:B15,B18:B27,B30:B39)","v":19},{"$f":"MAX(C6:C15,C18:C27,C30:C39)","v":26.2},{"$f":"MIN(E6:E15,E18:E27,E30:E39)","v":-6.1},null,{"$f":"MAX(I6:I15,I18:I27,I30:I39)","v":7.9}]
["16.",14.9,19.7,10.7,8.9,42,59,6,0.2,"R",null,3.8,1019.8,6.7,1,null,null,1,null,null,null,3,null,null,null,null,"Min TT","Min TnTn","Min U14",null,"Max SS"]
["17.",15.5,21.3,10.6,9.4,42,69,6.8,".",null,null,5,1022,9.4,1,null,null,null,null,null,null,2,null,null,null,null,{"$f":"MIN(B6:B15,B18:B27,B30:B39)","v":-1.3},{"$f":"MIN(D6:D15,D18:D27,D30:D39)","v":-5.8},{"$f":"MIN(F6:F15,F18:F27,F30:F39)","v":32},null,{"$f":"MAX(P6:P15,P18:P27,P30:P39)","v":10}]
["18.",19,26.2,12.2,10,41,60,6.4,0.3,"R",null,6.7,1015.8,10.7,1,null,null,1,1,null,null,3]
["19.",12.9,16.3,9.8000000000000007,8.9,34,53,6.9,".",null,null,2,1021,3.5,1,null,null,null,null,null,null,3]
["20.",8.8000000000000007,11.3,6.9,6.7,56,69,8,".",null,null,".",1027.3,3.5,1,null,null,null,null,null,null,4]
["Su",{"$f":"SUM(B18:B27)","v":124.4},{"$f":"SUM(C18:C27)","v":172.9},{"$f":"SUM(D18:D27)","v":76.900000000000006},{"$f":"SUM(E18:E27)","v":61.1},"XXX",{"$f":"SUM(G18:G27)","v":687},{"$f":"SUM(H18:H27)","v":58.3},{"$f":"SUM(I18:I27)","v":10.5},{"$f":"SUM(K18:K27)","v":0},null,{"$f":"SUM(L18:L27)","v":39.4},{"$f":"SUM(M18:M27)","v":10181.099999999999},{"$f":"SUM(N18:N27)","v":64.5},{"$f":"SUM(O18:O27)","v":10},{"$f":"COUNT(P18:P27)","v":0},"X",{"$f":"SUM(R18:R27)","v":5},{"$f":"SUM(S18:S27)","v":1},{"$f":"SUM(T18:T27)","v":0},{"$f":"SUM(U18:U27)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B28/10)","v":12.440000000000001},{"$f":"AVERAGE(C28/10)","v":17.29},{"$f":"AVERAGE(D28/10)","v":7.69},{"$f":"AVERAGE(E28/10)","v":6.11},"XXX",{"$f":"AVERAGE(G28/10)","v":68.7},{"$f":"AVERAGE(H28/10)","v":5.83},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M28/10)","v":1018.1099999999999},{"$f":"AVERAGE(N28/10)","v":6.45},{"$f":"O28/10","v":1},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V18:V27)","v":3.4}]
["21.",10.3,18.100000000000001,2.1,2.2000000000000002,52,73,5,".",null,null,7.7,1020.1,5.4,1,null,null,null,null,null,null,4]
["22.",12.7,18,7.4,6.7,60,75,7.5,0.6,"R",null,2.2999999999999998,1015.2,8.3000000000000007,1,null,null,1,null,null,null,3]
["23.",13.6,19.399999999999999,8.1,7.8,34,64,5.9,".",null,null,10.7,1019.6,5.9,1,null,null,null,null,null,null,4]
["24.",14.3,20.100000000000001,9.4,8.9,47,67,5.2,".",null,null,10.7,1025.0999999999999,8.1,1,null,null,null,null,null,null,3]
["25.",16,22.5,10.199999999999999,8.3000000000000007,42,67,4.4000000000000004,".",null,null,8.8000000000000007,1023.3,9.6,1,null,null,null,null,null,null,3]
["26.",18.100000000000001,25.7,10.7,8.3000000000000007,32,59,3.6,2,"R",null,7.8,1009.7,9,1,null,null,1,null,null,null,3]
["27.",8.4,13.2,5.8,6.7,91,95,8,7.9,"R",null,".",1006.1,7.9,1,null,null,1,null,null,null,3]
["28.",6.7,10.3,3.2,3.9,69,88,7.6,0.5,"R",null,0.7,1015.5,4.7,1,null,null,1,null,null,null,3]
["29.",10.3,14.1,6.4,5.6,70,82,7.6,1.1000000000000001,"R",null,1,1017.6,7.3,1,null,null,1,null,null,null,3]
["30.",8.6,12.6,6.3,5,72,89,7.5,6.8,"R",null,".",1022.4,6.8,1,null,null,1,null,null,null,3]
["Su",{"$f":"SUM(B30:B39)","v":119},{"$f":"SUM(C30:C39)","v":174},{"$f":"SUM(D30:D39)","v":69.600000000000009},{"$f":"SUM(E30:E39)","v":63.400000000000006},"XXX",{"$f":"SUM(G30:G39)","v":759},{"$f":"SUM(H30:H39)","v":62.300000000000004},{"$f":"SUM(I30:I39)","v":18.899999999999999},{"$f":"SUM(K30:K39)","v":0},null,{"$f":"SUM(L30:L39)","v":49.7},{"$f":"SUM(M30:M39)","v":10174.6},{"$f":"SUM(N30:N39)","v":73},{"$f":"SUM(O30:O39)","v":10},{"$f":"COUNT(P30:P39)","v":0},"X",{"$f":"SUM(R30:R39)","v":6},{"$f":"SUM(S30:S39)","v":0},{"$f":"SUM(T30:T39)","v":0},{"$f":"SUM(U30:U39)","v":0},"XXX"]
["Mi",{"$f":"AVERAGE(B40/10)","v":11.9},{"$f":"AVERAGE(C40/10)","v":17.399999999999999},6.9600000000000009,6.3400000000000007,"XXX",{"$f":"AVERAGE(G40/10)","v":75.900000000000006},{"$f":"AVERAGE(H40/10)","v":6.23},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M40/10)","v":1017.46},{"$f":"AVERAGE(N40/10)","v":7.3},1,"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V30:V39)","v":3.2}]
["MSu",{"$f":"SUM(B16+B28+B40)","v":260},{"$f":"SUM(C16+C28+C40)","v":395},{"$f":"SUM(D16+D28+D40)","v":134.30000000000001},{"$f":"SUM(E16+E28+E40)","v":106.10000000000001},"XXX",{"$f":"SUM(G16+G28+G40)","v":2269},{"$f":"SUM(H16+H28+H40)","v":192.9},{"$f":"SUM(I16+I28+I40)","v":32.599999999999994},{"$f":"SUM(J16+J28+J40)","v":0},null,{"$f":"SUM(L16+L28+L40)","v":114.5},{"$f":"SUM(M16+M28+M40)","v":30488.799999999996},{"$f":"SUM(N16+N28+N40)","v":124.8},"XXX",{"$f":"SUM(P16+P28+P40)","v":9},"X",{"$f":"SUM(R16+R28+R40)","v":17},{"$f":"SUM(S16+S28+S40)","v":1},{"$f":"SUM(T16+T28+T40)","v":0},{"$f":"SUM(U16+U28+U40)","v":0},"XXX"]
["MMi",{"$f":"AVERAGE(B17,B29,B41)","v":8.6666666666666661},{"$f":"AVERAGE(C42/30)","v":13.166666666666666},{"$f":"AVERAGE(D42/30)","v":4.4766666666666675},{"$f":"AVERAGE(E42/30)","v":3.5366666666666671},"XXX",{"$f":"AVERAGE(G42/30)","v":75.63333333333334},{"$f":"AVERAGE(H42/30)","v":6.4300000000000006},"XXXXX","XX",null,"XXXX",{"$f":"AVERAGE(M42/30)","v":1016.2933333333332},{"$f":"AVERAGE(N42/30)","v":4.16},{"$f":"AVERAGE(O17,O29,O41)","v":1.0333333333333334},"XXX","X","XX","XX","XX","XX",{"$f":"AVERAGE(V17,V29,V41)","v":3.2333333333333329}]
[]
[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":17},"ohne Sonne",null,null,null,null,null,7]
["TTT",8.6999999999999993,"XXXX",{"$f":"SUM(B43-B47)","v":-3.3333333333333215E-2},"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,1]
["RRR",47,{"$f":"SUM(I42*100/B48)","v":69.361702127659569},"XXXX","Sommertag",null,null,null,{"$f":"SUM(AB7:AB9)","v":2},null,null,">/=  3,0",null,null,{"$f":"SUM(AG7:AG9)","v":5},">/= 10,0",null,null,null,null,null,{"$f":"SUM(AC17:AC19)","v":3}]
["sss",166,{"$f":"SUM(L42*100/B49)","v":68.975903614457835},"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","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":7}]
["mgl.",414,{"$f":"SUM(L42*100/B51)","v":27.657004830917874},"XXXX","Frosttag",null,null,null,{"$f":"SUM(AA12:AA14)","v":7},null,null,"Rel. Luftfeuchte 14 Uhr",null,null,null,">/=   3",null,null,null,null,null,{"$f":"SUM(AF17:AF19)","v":7}]
["sss",null,null,"XXXX","starker Eistag",null,null,null,{"$f":"SUM(AB12:AB14)","v":0},null,null,">/=70%",null,null,{"$f":"SUM(AE12:AE14)","v":8},">/= 10",null,null,null,null,null,{"$f":"SUM(AG17:AG19)","v":2}]
[null,null,null,null,null,null,null,null,null,null,null,"</=40%",null,null,{"$f":"SUM(AG12:AG14)","v":4}]

{"sheet":"Sichtst.","index":2,"n_rows":42,"n_cols":18,"rows_kept":42,"cut":false,"hidden":false,"merged":[[4,6,4,7]]}
[null,null,null,null,"Sichtweitenstatistik "]
[]
[]
[]
[null,"Wetterstation: Köttewitz",null,null,null,"Monat:","April",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,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,1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["07.","-","-",1,1,1,"-","-",null,null,null,null,null," "," "," "," ",0]
["08.","-","-","-","-",1,"-","-",null,null,null,null,null," "," "," "," ",0]
["09.","-","-","-",1,"-","-","-",null,null,null,null,null," "," "," "," ",0]
["10.","-","-","-","-",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,"-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["17.","-","-","-","-",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,"-","-",null,null,null,null,null," "," "," "," ",0]
["22.","-","-",1,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,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.","-","-",1,1,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]
["Su.","XXXXXXXXX",{"$f":"SUM(C9:C38)","v":0},7,18,22,2,0]
[]
[null,"Anzahl der Nebeltage                  :",null,null,{"$f":"SUM(C39)","v":0}]
[null,"Anzahl der Tage Sicht >= 50 km :",null,null,{"$f":"SUM(G39,H39)","v":2}]

{"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)"]
[]
["April 2013"]
[]
[null,null,"aktuell","langj.  Mittel ","Abw. vom lj. Mittel"]
[null,"höchste Temperatur (°C):",{"$f":"MAX('Daten für Diagr.'!C2:C29)","v":26.2},"am","2013-04-18"]
[null,"mittlere Temperatur (°C):",{"$f":"'Daten für Diagr.'!B32","v":8.6666666666666679},{"$f":"Kurztabelle!B47","v":8.6999999999999993},{"$f":"C7-D7","v":-3.3333333333331439E-2},"K"]
[null,"tiefste Temperatur (°C):",{"$f":"MIN('Daten für Diagr.'!D2:D29)","v":-5.8},"am","2013-04-02"]
[null,"Niederschlagshöhe (mm):",{"$f":"Kurztabelle!I42","v":32.599999999999994},{"$f":"Kurztabelle!B48","v":47},{"$f":"100/D9*C9","v":69.361702127659555},"%"]
[null,"Sonnenscheindauer (Std.)*:",{"$f":"Kurztabelle!L42","v":114.5},{"$f":"Kurztabelle!B49","v":166},{"$f":"100/D10*C10","v":68.975903614457835},"%"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*Die Wetterstation kann, durch geographische Hindernisse, nicht die maximal mögliche Sonnenscheindauer aufzeichnen. Es gilt ein Übergangsprozentsatz von: Nov - Feb 50 %; Mär & Okt 65 %; Apr & Sep 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":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
[null,"Td","Tmax","Tmin","RR","Schnee","Sonne","Luftdr.","MWT","GWL","Name","Sonstiges"]
["2013-04-01",-0.8,0.9,-2.1,0.1,10,1.3,1011.5,6.4]
["2013-04-02",-1.3,2.2999999999999998,-5.8,0.1,10,2,1014.9,6.5,null,"H Liebhild 2"]
["2013-04-03",-0.3,0.9,-1.1000000000000001,null,9,".",1017.5,6.65]
["2013-04-04",0.1,1.3,-1.3,null,8,".",1014.4,6.8,null,null,"Von 03:40 Uhr - 10:09 Uhr leichter Dunst."]
["2013-04-05",0.9,2.1,-0.2,0.3,8,".",1010.8,6.95]
["2013-04-06",0.8,1.6,0.2,1.2,7,".",1017.6,7.1,"Nz","T Hansi","Von 21:40 Uhr - 23:59 Uhr mäßiger Dunst. Von 02:20 Uhr - 20:39 Uhr leichter Dunst."]
["2013-04-07",1.7,6.3,-1.8,null,8,7.3,1021.2,7.25,null,null,"Von 00:00 Uhr - 06:59 mäßiger Dunst. Von 07:00 Uhr - 08:59 Uhr leichter Dunst."]
["2013-04-08",2.7,8.9,-4,null,0,7.3,1012.2,7.4,"WS","T Ingo"]
["2013-04-09",5.6,11.2,1.2,0.5,null,6.3,1006.1,7.55,null,null,"Beginn der Krokusblüte."]
["2013-04-10",7.2,12.6,2.7,1,null,1.2,1006.9,7.7,"TB","T Joel"]
["2013-04-11",9.8000000000000007,14.4,4.4000000000000004,3,null,2.2999999999999998,1005.4,7.85]
["2013-04-12",10.199999999999999,12.4,7.2,4,null,1.3,1003.5,8,"Wz",null,"Beginn des phänologischen Erstfrühlings."]
["2013-04-13",8.9,13.4,5.3,3,null,3.6,1016.3,8.15,"Wa","H Notburga","Beginn der Forsythienblüte."]
["2013-04-14",10,16.899999999999999,3.4,null,null,3,1026.9000000000001,8.3000000000000007,"SWa"]
["2013-04-15",14.4,21,6.4,null,null,11.7,1023.1,8.4499999999999993,null,null,"Beginn der Weidenkätzchenblüte."]
["2013-04-16",14.9,19.7,10.7,0.2,null,3.8,1019.8,8.65,null,null,"Ergrünen des Dauergrünlandes."]
["2013-04-17",15.5,21.3,10.6,null,null,5,1022,8.8000000000000007,null,null,"Beginn der Feldbestellung."]
["2013-04-18",19,26.2,12.2,null,null,6.7,1015.8,8.9499999999999993,"NWz","T Nils","Beginn des allgemeinen Austriebes, darunter Apfel, Birne."]
["2013-04-19",12.9,16.3,9.8000000000000007,null,null,2,1021,9.15,"BM","H Oxana","Beginn der Birkenblüte."]
["2013-04-20",8.8000000000000007,11.3,6.9,null,null,0,1027.9000000000001,9.3000000000000007,null,null,"Beginn des Austriebes der Himbeere."]
["2013-04-21",10.3,18.100000000000001,2.1,null,null,7.7,1020.1,9.4499999999999993,null,null,"Beginn des Graswachstums. "]
["2013-04-22",12.7,18,7.4,0.6,null,2.2999999999999998,1015.2,9.65,null,null,"Von 09:40 Uhr  - 12:10 Uhr leichter trockener Dunst."]
["2013-04-23",13.6,19.399999999999999,8.1,null,null,10.7,1019.6,9.8000000000000007,"Wa","H Paula","Beginn der Löwenzahnblüte."]
["2013-04-24",14.3,20.100000000000001,9.4,null,null,10.7,1025.0999999999999,10,null,null,"Beginn der Blattentfaltung bei Ahorn."]
["2013-04-25",16,22.5,10.199999999999999,null,null,8.8000000000000007,1023.3,10.15,null,null,"Beginn der Birnenblüte."]
["2013-04-26",18.100000000000001,25.7,10.7,2,null,7.8,1009.7,10.3,"TrW","T Stephan","Vollblüte Süßkirsche."]
["2013-04-27",8.4,13.2,5.8,7.9,null,0,1006.1,10.5,null,null,"Von 04:50 Uhr - 11:59 Uhr; 18:00 Uhr - 23:59 Uhr  leichter Dunst (Sprühregen)."]
["2013-04-28",6.7,10.3,3.2,0.5,null,0.7,1015.5,10.7,"NWz","T Ullrich","Von 00:00 Uhr - 10:19 Uhr leichter Dunst (Sprühregen)."]
["2013-04-29",10.3,14.1,6.4,1.1000000000000001,null,1,1017.6,10.9]
["2013-04-30",8.6,12.6,6.3,6.8,null,0,1022.4,11.1,null,null,"Von 21:00 Uhr - 23:59 Uhr starker Dunst. Von 20:00 Uhr - 20:59 Uhr mäßiger Dunst. Von 19:40 Uhr - 19:59 Uhr leichter Dunst."]
["Durchschnitt",{"$f":"AVERAGE(B2:B31)","v":8.6666666666666679},{"$f":"AVERAGE(C2:C31)","v":13.166666666666668},{"$f":"AVERAGE(D2:D31)","v":4.4766666666666675},null,null,null,{"$f":"AVERAGE(H2:H31)","v":1016.3133333333332},{"$f":"AVERAGE(I2:I31)","v":8.615000000000002}]
["Mittel",8.6999999999999993,null,null,47,"-",166,1014.5]