{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Zadání","Cyklický odkaz","List1","PAHy"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"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":"Zadání","index":0,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"1. Na listu Cyklický odkaz vytvořte zjednodušenou mapu, ve které hodnota v buňce je průměrem osmi okolních hodnot. Vyplněné buňky nepřepisujte."]
[null,null,"2. Použijte funkci Podmíněné formátování pro barevné zvýraznění rozdílů v buňkách mapy."]
[null,null,"3. Na listu PAHy najdete měsíční koncentrace polyaromatických uhlovodíků v letech 2003-2012."]
[null,null,"4. Aktivujte buňku B3 na listu PAHy a zahajte záznam makra, které pojmenujete Graf."]
[null,null,"5. V režimu záznamu makra vytvořte sloupcový graf o čtyřech sloupcích udávajících koncentrace PAHů dne 15.10.2003, bez legendy s popisy osy x z řádku 2 a názvem grafu odpovídajícím kalendářnímu datu."]
[null,null,"6. Přiřaďte makru klávesovou zkratku Ctrl+Shift+Q."]
[null,null,"7. Přemístěte kurzor do buňky B4 a pomocí klávesové zkratky spusťte makro Graf za účelem vytvoření grafu obsahujícího údaje z řádku 4."]
[null,null,"8. Pokud makro neproběhlo, otevřete okno ditoru Visual Basic a pomocí funkce Debug vyhledejte a pokuste se opravit chybu."]
[null,null,"9. Proběhlo-li makro, komentujte, co bylo vykonáno v rozporu s naším požadavkem."]
[null,null,"10. Využijte funkce ActiveCell.Offset() pro relativizaci příslušných vybraných oblastí tak, aby makro kreslilo vždy graf z vybraného řádku."]
[null,null,"11. Vytvořte pomocí Visual Basic IDE vlastní funkci Prvocislo s jedním argumentem, která vrátí hodnotu 0 pokud není argument prvočíslo a hodnotu 1, pokud je prvočíslo."]
[null,null,"12. Využijte cyklus zadaný příkazem For, funkci Sqr pro odmocninu a funkci Mod pro dělení se zbytkem."]
[null,null,"13. Vytvořte vlastní formulář se čtveřicí tlačítek nazvaných Žlutá, Červená, Modrá a Zelená, po jejichž stisknutí se níže vyznačená buňka zbarví příslušnou barvou."]
[]
[null,null,null,"Tato buňka bude obarvena."]

{"sheet":"Cyklický odkaz","index":1,"n_rows":37,"n_cols":37,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,null,"Povolte na kartě Vzorce v Možnostech nastavení aplikace Excel iterativní přepočet a nastavte počet iterací na 100."]
[null,null,"V mapě 30 × 30 polí níže vložte do prázdných buněk vzorec, který spočítá hodnotu buňky jako průměr okolních 8 buněk."]
[null,null,"Buňky u krajů budou průměrem 5 okolních a buňky v rozích 3 okolních buněk."]
[null,null,"Použijte funkci Podmíněné formátování pro barevné zvýraznění rozdílů v buňkách mapy."]
[]
[null,null,{"$f":"AVERAGE(D8,D9,C9)","v":76.003430867443242},{"$f":"AVERAGE(C8,C9:E9,E8)","v":75.968522892080017},{"$f":"AVERAGE(D8,D9:F9,F8)","v":75.870659642462428},75.68163027949717,75.352049878424836,74.809468919516902,73.963363720323628,72.720751304811799,71.0105031171815,68.806262690969817,66.136089269386815,63.073052067709526,59.713004609962709,56.152003315329182,52.474329692251523,48.754252947705652,45.069011347501593,41.514700281170818,38.213613231050999,35.298717500606379,32.875957498093321,30.981079319423998,29.562926763164164,28.504333457350576,27.669499134180477,26.945974488622817,26.264705257169311,25.597478258769222,24.945173824579133,24.325550248870211,23.764218079194769,23.288271314134601,22.922004127231446,22.684304107802184,{"$f":"AVERAGE(AJ8,AJ9,AK9)","v":22.587334800028675}]
[null,null,{"$f":"AVERAGE(C8:D8,D9,C10:D10)","v":76.035391258206289},{"$f":"AVERAGE(C8:E8,C9,E9,C10:E10)","v":76.00704050506674},{"$f":"AVERAGE(D8:F8,D9,F9,D10:F10)","v":75.926969394332019},75.770002247858557,75.489323603024175,75.010661930837031,74.232767428061038,73.043978107281902,{"$f":"AVERAGE(J8:L8,J9,L9,J10:L10)","v":71.353945592930174},69.128378542781832,66.403203844907779,63.270368029800352,59.843428451210741,56.227020306620261,52.503095615221021,48.736147536898521,44.989556905017118,41.351277788025044,37.950923592814796,34.953336268271791,{"$f":"AVERAGE(V8:X8,V9,X9,V10:X10)","v":32.500664310469617},30.646929852658559,29.319905406470653,28.363432939867462,27.607017472602983,26.927920759820843,26.261979462660626,25.591483366386683,24.925412449272571,24.28735280343313,23.707038789139357,23.214350511556702,22.835238994054734,22.589362591497437,{"$f":"AVERAGE(AJ8:AK8,AJ9,AJ10:AK10)","v":22.489092253707156}]
[null,null,76.10600440846045,{"$f":"AVERAGE(C9:E9,C10,E10,C11:E11)","v":76.092612593389859},76.053599945014312,75.972542782068089,75.814082472506584,75.504971598110743,74.92006973409832,73.889659252133185,{"$f":"AVERAGE(J9:L9,J10,L10,J11:L11)","v":72.261539239745403},69.971265211796933,67.084999615923152,63.756010463478674,60.15396962497276,56.402831148847397,52.574346649658146,48.704689199676345,44.820756946426847,40.966476063645061,37.286036411354004,34.024082776944212,{"$f":"AVERAGE(V9:X9,V10,X10,V11:X11)","v":31.477557012422555},29.748545354945005,28.709743607692843,28.043257816157954,27.491859169658415,26.911014803524118,26.272537460007978,25.586003254692155,24.879911255409759,24.191724631525734,23.561206571458399,23.025076919338208,22.613209759950298,22.346805449728919,{"$f":"AVERAGE(AJ9:AK9,AJ10,AJ11:AK11)","v":22.23838943272553}]
[null,null,76.194653242593972,76.200969434975363,76.217125187617711,76.242377017532291,76.267683047338039,76.255894349699346,76.050060596756964,75.373310345020144,{"$f":"AVERAGE(J10:L10,J11,L11,J12:L12)","v":73.882331913767771},71.450170095899495,68.206288708514677,64.495069497808402,60.591539438752847,56.646297196799068,52.683777303646508,48.691749828477064,44.638918073741713,40.488066304142997,36.207081081587688,32.347837471007274,{"$f":"AVERAGE(V10:X10,V11,X11,V12:X12)","v":29.470009798943842},28.129856381636955,27.734557759375249,27.692404475174818,27.428169438998591,26.962764979833686,26.337050090808688,25.603324076651891,24.81761980317459,24.037703147902185,23.318918762894395,22.708878786410828,22.243183044277323,21.944203009529279,21.823190623829028]
[null,null,76.274549055529619,76.299763557820967,76.370282866552884,76.50567359387918,76.73882373160663,77.107865733252012,77.644327117212868,77.705076861690003,{"$f":"AVERAGE(J11:L11,J12,L12,J13:L13)","v":76.63407833150157},73.774208574714464,69.787319389140961,65.331973076708721,61.049201543440624,56.897742142401874,52.817771027027895,48.735602892313118,44.558945909342249,40.145850308808093,35.281225020274,29.117779280925618,{"$f":"AVERAGE(V11:X11,V12,X12,V13:X13)","v":25.91959239462058},24.995494175544248,26.984095471777966,27.573920417231744,27.574601985408552,27.176590253314007,26.511427288054023,25.673928308771732,24.749352615882032,23.820286513506066,22.963909795070023,22.243890588859529,21.702977449436641,21.361774943429619,21.225450199684389]
[null,null,76.320533574147859,76.357444775351667,76.46336683024893,76.676342200507094,77.070161295651104,77.785328884862565,79.051332496066664,81.826365593271305,{"$f":"AVERAGE(J12:L12,J13,L13,J14:L14)","v":81.179369431966464},77.882332789658989,71.172356108924731,65.986799430656959,61.367919498036436,57.077023549300051,52.949185377648661,48.861579297502054,44.683682164435382,40.226883153268965,35.082720759357187,28.634217690321684,10,{"$f":"AVERAGE(W12:Y12,W13,Y13,W14:Y14)","v":24.661993488146866},27.064394720962664,28.020939832334651,28.093116170083555,27.649916108456445,26.856751152734049,25.832223282464902,24.684850719952053,23.526089967332815,22.465076154054756,21.591680836022249,20.957758908171609,20.573716866340188,20.42499066282673]
[null,null,76.317754258085003,76.353761306172743,76.46034387880988,76.684101886668628,77.118734918045035,77.945129919526948,79.606907203276506,82.790219193453112,100,78.823038139209046,71.688715097687123,66.105069652875315,{"$f":"AVERAGE(N13:P13,N14,P14,N15:P15)","v":61.392522487577054},57.103753115060918,53.038850823943825,49.061930681431768,45.047433267516261,40.831978994460954,36.183931847625793,30.240521232656448,27.248410048168207,{"$f":"AVERAGE(W13:Y13,W14,Y14,W15:Y15)","v":26.494447764593016},28.590174712948134,29.194861681349238,29.093229389963074,28.461824305237965,27.432804589945871,26.116358933100088,24.633411644574132,23.128277827038985,21.764693869726209,20.682930243769096,19.953368746384214,19.552897783973464,19.411686733425817]
[null,null,76.268855648376331,76.288766536018557,76.353802806583758,76.505925232738065,76.824871105783657,77.458712144860286,78.645627214002559,81.353091299497081,{"$f":"AVERAGE(J14:L14,J15,L15,J16:L16)","v":80.659440431166288},77.345633128812977,70.656987032287716,65.538105092118542,{"$f":"AVERAGE(N14:P14,N15,P15,N16:P16)","v":61.037821759956572},56.924401465887946,53.043041786657028,49.290647056079848,45.581781297901806,41.841723853107396,38.008383551578284,34.605681701561409,32.161456043601518,{"$f":"AVERAGE(W14:Y14,W15,Y15,W16:Y16)","v":31.189606866693993},31.040251497026652,31.05567539760284,30.601954117592161,29.668451585081073,28.299325813594759,26.578578651270469,24.613944616631194,22.588001667833268,20.751190733230963,19.385341353683884,18.595372706115302,18.288300288423436,18.219044046406651]
[null,null,76.197505356959738,76.187066488099831,76.171801201567405,76.17939887119509,76.255065771015794,76.452584351260555,76.821414836496103,76.737537137668198,{"$f":"AVERAGE(J15:L15,J16,L16,J17:L17)","v":75.564127741575618},72.662417465828867,68.710918008455096,64.382623033528972,{"$f":"AVERAGE(N15:P15,N16,P16,N17:P17)","v":60.33085104221297},56.525952043862127,52.923147968576572,49.476394998039879,46.153342994540189,42.951538241307055,39.976122503844437,37.436272009767251,35.591047035123268,{"$f":"AVERAGE(W15:Y15,W16,Y16,W17:Y17)","v":34.486360457523645},33.905432355206578,33.406216437818792,32.614089712984224,31.32213425769541,29.523139450039785,27.292234261224788,24.718346397131633,21.857283490196536,19.237786356705598,17.366115790074833,16.732173627168205,16.802768050160655,17.04002478866736]
[null,null,76.147408103170932,76.095990160909736,75.973140924222292,75.791044168892853,75.56024538934426,75.268423924012495,74.786961262083139,73.868997407126642,{"$f":"AVERAGE(J16:L16,J17,L17,J18:L18)","v":72.201232548553619},69.685266921346511,66.476344422695064,62.940604771668774,{"$f":"AVERAGE(N16:P16,N17,P17,N18:P18)","v":59.370019772396695},55.927975565179104,52.651074283358795,49.546428921856538,46.622435378166266,43.916533509801525,41.512715694877954,39.536855468684102,38.098631740714445,{"$f":"AVERAGE(W16:Y16,W17,Y17,W18:Y18)","v":37.214229246741006},36.690952904105004,36.160903626770349,35.181230190120637,33.516938010179381,31.172762683881139,28.335535522490098,25.097099039062865,21.384938638736489,16.467755591394756,14.102407029442661,13.65761925762571,15.660223563250295,16.230197014625865]
[null,null,76.177842182792673,76.07917954814711,75.834694762640112,75.446659004020717,74.908039024607476,74.181420380246038,73.182311686779428,71.78363253905809,{"$f":"AVERAGE(J17:L17,J18,L18,J19:L19)","v":69.875381259338667},67.433117279656614,64.559222101058339,61.437227249273477,{"$f":"AVERAGE(N17:P17,N18,P18,N19:P19)","v":58.258294281400971},55.157313096740381,52.207854445519054,49.444245597786384,46.893665180050313,44.598068706153697,42.625115015784118,41.061952237287784,39.993713328966749,39.469341181120136,39.479060169898034,39.40677335519468,{"$f":"AVERAGE(Z17:AB17,Z18,AB18,Z19:AB19)","v":38.604163657173942},36.419326568660807,33.299393320756529,29.6741727539696,25.90792920578561,21.607129188639302,16.186881540513284,0,{"$f":"AVERAGE(AH17:AJ17,AH18,AJ18,AH19:AJ19)","v":13.171399208478162},15.426405490147053,16.221945811850677]
[null,null,76.35809907690458,76.209058129292771,75.837895799884308,75.245275381881484,74.423610666484166,73.348294038330309,71.974123579720271,70.247273989642991,{"$f":"AVERAGE(J18:L18,J19,L19,J20:L20)","v":68.133403055458899},65.650747303145252,62.883964460696092,59.967137066335738,{"$f":"AVERAGE(N18:P18,N19,P19,N20:P20)","v":57.042877403962393},54.223862473871684,51.577228003697705,49.135406845470719,46.920586205323261,44.966341875439696,43.327888298179097,42.08129584613252,41.320127154724574,41.167982538170151,41.790712116044752,43.932217617717043,{"$f":"AVERAGE(Z18:AB18,Z19,AB19,Z20:AB20)","v":43.415538230616633},40.800966758051437,35.364257089613012,31.111891825202811,27.10526713714809,22.948149317654561,17.759697750891391,15.225465678818001,{"$f":"AVERAGE(AH18:AJ18,AH19,AJ19,AH20:AJ20)","v":14.677312271934863},16.622443826417687,17.170845152543603]
[null,null,76.763406002168409,76.561511513561811,76.060500249166054,75.266946688724616,74.184508461810296,72.808385058988236,71.124586416830354,69.117707995891465,{"$f":"AVERAGE(J19:L19,J20,L20,J21:L21)","v":66.787660789495334},64.172313202336667,61.361524301889162,58.491037923700588,{"$f":"AVERAGE(N19:P19,N20,P20,N21:P21)","v":55.703567741003226},53.105212261491722,50.739204143320492,48.605398000355549,46.695766736529926,45.02650749077953,43.643859642576579,42.620691796471625,42.057739903354751,42.109002278032982,43.124826994605868,45.637079585714368,60,{"$f":"AVERAGE(AA19:AC19,AA20,AC20,AA21:AC21)","v":42.524183733073514},36.781351136160652,{"$f":"AVERAGE(AC19:AE19,AC20,AE20,AC21:AE21)","v":32.303454119836147},28.46005802401649,24.830117278155743,21.728852721428662,19.551710110178341,{"$f":"AVERAGE(AH19:AJ19,AH20,AJ20,AH21:AJ21)","v":18.728603925218664},18.693244069385006,18.890597671999643]
[null,null,77.474195344338426,77.214642081249721,76.574925773450417,75.574374131029231,74.235106530361378,72.57469342583353,70.602769147860243,68.324048465180482,{"$f":"AVERAGE(J20:L20,J21,L21,J22:L22)","v":65.74839472149074},62.907985282757586,59.905405679607419,56.914178840011594,{"$f":"AVERAGE(N20:P20,N21,P21,N22:P22)","v":54.150225215663369},51.734599512274727,49.670743581135866,47.861820074371416,46.243094842911923,44.807670067219426,43.607561943673083,42.713638829864522,42.214140346064433,42.235742630783605,42.961412816034517,45.165061794817071,44.707295957497642,42.189453739472221,36.935232112085352,{"$f":"AVERAGE(AC20:AE20,AC21,AE21,AC22:AE22)","v":33.022077241018479},29.648274470644221,26.712040202919077,24.279417956003993,22.52504949612268,{"$f":"AVERAGE(AH20:AJ20,AH21,AJ21,AH22:AJ22)","v":21.490120850338819},21.044343229204134,20.922558482556955]
[null,null,78.579857365655329,78.252005598378489,77.451325478482445,76.218690772770771,74.603578691832993,72.650262878297227,70.388934706724626,67.834113060526263,{"$f":"AVERAGE(J21:L21,J22,L22,J23:L23)","v":64.988791114552669},61.855095927757105,58.445238706582643,55.096397511815177,{"$f":"AVERAGE(N21:P21,N22,P22,N23:P23)","v":52.160551277546944},49.996782527424372,48.351062150727302,46.972462750659709,45.617462564477506,44.358340549783406,43.269461986687283,42.421036327241936,41.875335280674783,41.680645758014322,41.863526699971125,41.876067415201021,41.150921866404005,39.116254747308027,36.301104039758968,{"$f":"AVERAGE(AC21:AE21,AC22,AE22,AC23:AE23)","v":33.244750429026723},30.503216983131164,28.111342528999351,26.135927530541007,24.641207974970442,{"$f":"AVERAGE(AH21:AJ21,AH22,AJ22,AH23:AJ23)","v":23.645475063151242},23.092267044639044,22.892821457554582]
[null,null,80.188318522515445,79.770535664529888,78.762788844702129,77.24318788351971,75.304788917874305,73.028077419324887,70.464706812772775,67.63335576068495,{"$f":"AVERAGE(J22:L22,J23,L23,J24:L24)","v":64.522444769064521},61.085416754520665,57.237591506018326,52.560301552175382,{"$f":"AVERAGE(N22:P22,N23,P23,N24:P24)","v":49.398121230359827},47.434235011025919,47.075197640523967,46.063194947630521,44.897728430416464,43.736036000649499,42.688388483266472,41.823726253684157,41.176753546947516,40.737719424160794,40.38125348637508,39.871025550536416,38.908762645493901,37.374198790970816,35.36385366130088,{"$f":"AVERAGE(AC22:AE22,AC23,AE23,AC24:AE24)","v":33.163842854503812},31.021277396950225,29.103043613027602,27.488484983897159,26.227800027199226,{"$f":"AVERAGE(AH22:AJ22,AH23,AJ23,AH24:AJ24)","v":25.338373007645348},24.805637527011662,24.599812780040374]
[null,null,82.444554708550413,81.895008134636086,80.590916892158333,78.681137210167364,76.332781405779983,73.681107907286318,70.798975833040402,67.703345080687598,{"$f":"AVERAGE(J23:L23,J24,L24,J25:L25)","v":64.366046595965898},60.713890195137431,56.554701927964096,51.590101544487595,40,46.346889390163277,46.145624526483218,45.291835626537932,44.154762304086361,{"$f":"AVERAGE(S23:U23,S24,U24,S25:U25)","v":42.988359535553883},41.914448234553319,40.99639113213145,40.248708147222551,{"$f":"AVERAGE(W23:Y23,W24,Y24,W25:Y25)","v":39.631194640857707},39.045078978440429,38.345524136540277,37.397843235727976,36.139067461599858,34.616620920792322,{"$f":"AVERAGE(AC23:AE23,AC24,AE24,AC25:AE25)","v":32.955869036050274},31.304970216163365,29.784140860888467,28.475978163853224,27.429455670928846,{"$f":"AVERAGE(AH23:AJ23,AH24,AJ24,AH25:AJ25)","v":26.668535177110634},26.197657514310865,26.011217782396791]
[null,null,85.567775776556786,84.801455372727759,83.034146405493729,80.539515293578773,77.641427249444646,74.543479535451752,71.335107624188851,68.003113714531949,64.503494821118352,60.763785111686303,56.678087332805845,51.808838573888444,48.483451776635199,46.370786338279778,45.86812493905569,44.715227226175173,43.415385919272026,42.130939703410363,40.969834111708835,39.982588739325827,39.167386268954559,38.474633744385436,37.818774982856205,37.101281441914523,36.240975908900488,35.202745428628553,34.008411505499822,{"$f":"AVERAGE(AC24:AE24,AC25,AE25,AC26:AE26)","v":32.725890874900806},31.443037395291807,30.243650566604064,29.193709905688927,28.338594347802939,{"$f":"AVERAGE(AH24:AJ24,AH25,AJ25,AH26:AJ26)","v":27.705247575832317},27.306609757360171,27.146929066855002]
[null,null,89.896733807669733,88.801388200640744,86.18147182171748,82.782652898745667,79.071989617104563,75.499180133123389,71.987711996750207,68.464404497773032,64.866285393687718,61.147545618590371,57.28067159122994,53.565579212098243,50.318520169065728,47.867316806841586,45.936823586681484,44.271002376506466,42.63880983956664,{"$f":"AVERAGE(S25:U25,S26,U26,S27:U27)","v":41.132742231045967},39.833801752344854,38.780059575786993,37.950768995949176,37.27546342258043,36.660443097023837,36.017360467988006,35.285064302243086,34.439770566125034,33.495098254694241,{"$f":"AVERAGE(AC25:AE25,AC26,AE26,AC27:AE27)","v":32.493159209922304},31.490931736962565,30.546698253443161,29.710786753923969,29.021455632701631,{"$f":"AVERAGE(AH25:AJ25,AH26,AJ26,AH27:AJ27)","v":28.504692752716831},28.17610484865062,28.043628215832143]
[null,null,96.251043541240648,94.062195627293349,90.616545787453219,84.814176664213377,80.362294921584834,76.393574142950087,72.658267207966162,69.00499934351383,65.356697731256389,61.686688739143747,58.045098852129279,54.550190765891891,51.360218190438552,48.542237060657584,46.058853771685548,43.801551373453357,41.733783729481765,{"$f":"AVERAGE(S26:U26,S27,U27,S28:U28)","v":39.910416632896322},38.429565324824516,37.334896815894311,36.572296132494024,36.019523641981898,35.540613275451314,35.036663734645479,34.455874838962259,33.786689041249701,33.044193283916265,{"$f":"AVERAGE(AC26:AE26,AC27,AE27,AC28:AE28)","v":32.260857086182654},31.477828526392628,30.737350497390402,30.077350088174946,29.528580285169156,{"$f":"AVERAGE(AH26:AJ26,AH27,AJ27,AH28:AJ28)","v":29.113808169705553},28.848287081879626,28.740793211709445]
[null,null,98.494994266458818,110,{"$f":"AVERAGE(D27:F27,D28,F28,D29:F29)","v":92.255545571699983},86.035143892899299,81.208070892102882,77.093918327000651,73.267539961010996,69.555213776278734,65.884297221869474,62.244583619539334,58.668775666830243,55.217209229928535,51.9459161798219,48.875251808555888,45.975487667182563,43.20166830215851,40.596507116224146,38.318113911795976,{"$f":"AVERAGE(T27:V27,T28,V28,T29:V29)","v":36.600570732158211},35.526508715481889,34.986225292925781,34.705584879767933,34.465499021855514,34.145115006250492,33.724127711168038,33.213036314958998,32.63721766823619,{"$f":"AVERAGE(AC27:AE27,AC28,AE28,AC29:AE29)","v":32.028633622680708},31.420757249985154,30.845251595242651,30.330257089174584,29.899519265606212,{"$f":"AVERAGE(AH27:AJ27,AH28,AJ28,AH29:AJ29)","v":29.571904958741133},29.36107714565744,29.275457312230174]
[null,null,97.161079035834888,{"$f":"AVERAGE(C28:E28,C29,E29,C30:E30)","v":95.000728947118816},{"$f":"AVERAGE(D28:F28,D29,F29,D30:F30)","v":91.619105558083191},85.896695926005791,81.508990325432976,77.56009059147334,73.792869671384878,70.081766115554288,66.395677030265034,62.749176510649349,59.170699953330946,55.687015425814927,52.310229903628802,49.02546030927013,45.78410501862448,42.515274357707682,39.148286258319501,36.14346538289044,{"$f":"AVERAGE(T28:V28,T29,V29,T30:V30)","v":33.982824333635115},33.159303218301972,33.146954077207667,33.425351146034437,33.488884203242435,33.362970797385785,33.087042085561599,32.706424629593442,32.263557207971353,{"$f":"AVERAGE(AC28:AE28,AC29,AE29,AC30:AE30)","v":31.795232286940973},31.330359474736763,30.891533624508135,30.497618916992423,30.165943747665438,{"$f":"AVERAGE(AH28:AJ28,AH29,AJ29,AH30:AJ30)","v":29.911821784493625},29.747361397740036,29.680358167769736]
[null,null,91.671994834349675,{"$f":"AVERAGE(C29:E29,C30,E30,C31:E31)","v":90.637813209482857},{"$f":"AVERAGE(D29:F29,D30,F30,D31:F31)","v":88.165498586468161},84.961648364380039,81.419825043044071,77.896821119082347,74.293011672684273,70.594948901914464,66.870954175843892,63.184887722644397,59.573973188346521,56.040435248417609,52.569357307369813,49.121678899096786,45.62214739093185,41.936362125017077,37.858109900112161,32.617241084714692,{"$f":"AVERAGE(T29:V29,T30,V30,T31:V31)","v":30.026501714945599},29.47132754856618,31.534003373652723,32.367888796055752,32.708398272626667,32.730942577516302,32.554471212173056,32.259994588823986,31.912732408782389,{"$f":"AVERAGE(AC29:AE29,AC30,AE30,AC31:AE31)","v":31.556014211240132},31.213472209546914,30.892932103038778,30.602637077226767,30.353952130648548,{"$f":"AVERAGE(AH29:AJ29,AH30,AJ30,AH31:AJ31)","v":30.160960980328763},30.035009895331999,29.983474500461234]
[null,null,88.115546076121788,{"$f":"AVERAGE(C30:E30,C31,E31,C32:E32)","v":87.44496146463959},{"$f":"AVERAGE(D30:F30,D31,F31,D32:F32)","v":85.92380704622957},83.839456687163988,81.320051724245474,78.375108306737189,74.904910170293476,71.137900579446764,67.282862044453623,63.54081152212207,59.895376077194122,56.323836938012008,52.793465978621711,49.253220893151685,45.615934165879395,41.725627469164131,37.221875428045095,31.557161807481155,15,28.280989387501009,30.640408400642293,31.780331955777179,32.219375864455571,32.292081346764668,32.134982490298597,31.862013626196259,31.559437389240415,{"$f":"AVERAGE(AC30:AE30,AC31,AE31,AC32:AE32)","v":31.299932424177836},31.074204721487021,30.868467299091279,30.666145632756969,30.485557273136273,{"$f":"AVERAGE(AH30:AJ30,AH31,AJ31,AH32:AJ32)","v":30.342040694325537},30.247147821828641,30.208081578359689]
[null,null,85.626228712400888,{"$f":"AVERAGE(C31:E31,C32,E32,C33:E33)","v":85.196897386633324},{"$f":"AVERAGE(D31:F31,D32,F32,D33:F33)","v":84.222129197522932},82.922276069263006,81.780638697084001,79.364862926765127,76.020985367959099,71.555924961990655,67.579941340803799,63.79791097897062,60.14100814354957,56.560595386788215,53.016955979503933,49.462132585950187,45.824585213772401,41.982203219549902,37.744265394342946,32.354448484902711,{"$f":"AVERAGE(T31:V31,T32,V32,T33:V33)","v":29.63515231843413},28.977002631803089,30.963972412816901,31.748272132642949,32.060916652568523,32.066787118034512,31.861396703340951,31.452775737877612,31.160912190078893,{"$f":"AVERAGE(AC31:AE31,AC32,AE32,AC33:AE33)","v":30.971744571534813},30.951655501119607,30.840251993444554,30.707387215517034,30.579012585587126,{"$f":"AVERAGE(AH31:AJ31,AH32,AJ32,AH33:AJ33)","v":30.4734164869765},30.402404838888572,30.372952987471212]
[null,null,83.835520845944686,{"$f":"AVERAGE(C32:E32,C33,E33,C34:E34)","v":83.53838952712124},82.868824487583211,82.042643183891016,81.380862405688617,85,76.136513279526483,71.692879219594303,67.691728805301267,63.939888101756956,60.312088503785496,56.758005807164913,53.244497142048871,49.740380037905851,46.208515367128385,42.60915977613535,38.90814129127039,35.59595743778474,{"$f":"AVERAGE(T32:V32,T33,V33,T34:V34)","v":33.173476978999005},32.142638625926978,31.979882831338195,32.162795918519201,32.179070610519503,32.039214451041147,31.747848456286878,31.29601380908235,30,{"$f":"AVERAGE(AC32:AE32,AC33,AE33,AC34:AE34)","v":30.845805620145818},30.882550417221715,30.83108470641621,30.741444534493674,30.64814957934588,{"$f":"AVERAGE(AH32:AJ32,AH33,AJ33,AH34:AJ34)","v":30.569040961118525},30.515103993650353,30.492604209298634]
[null,null,82.527225495784876,82.289039907207609,81.741483892302199,80.99796274862311,80.427175706690349,78.511494723325555,75.561375075995272,71.384850898243158,67.612035685135481,63.970773525225354,60.414032831156035,56.914940533365531,53.4603999309968,50.043056356213832,46.663397489601536,43.343711136987665,40.19895871784837,37.436921567635714,35.316791842663498,33.929414065217088,33.165950971746398,32.749578330254828,32.455307794348499,32.150286516714964,31.792685022438807,31.324166157525081,31.028723871812389,30.870473617801046,30.901052410128706,30.849130854293829,30.776121908947658,30.701423649539258,{"$f":"AVERAGE(AH33:AJ33,AH34,AJ34,AH35:AJ35)","v":30.638421084614723},30.595511722027933,30.577620382649808]
[null,null,81.599099336033106,{"$f":"AVERAGE(C34:E34,C35,E35,C36:E36)","v":81.374259145042259},80.827756688102426,79.993230785529889,78.701951749192915,76.789491670536549,74.094840197141536,70.881222779248276,67.40854726259326,63.926772383028741,60.461510177580664,57.028730967832026,53.640731746931138,50.313348949651896,47.0736855744168,43.975836169746628,41.112512811162091,38.60995190911904,36.580111388502253,35.066405362949382,34.010614535730795,33.286856760627209,32.756741209832171,32.318520027722471,31.913501817837538,31.55250730363333,31.262637310642383,31.078822553203146,30.964925328883862,30.886453191848062,30.810335823014547,30.741955336193211,{"$f":"AVERAGE(AH34:AJ34,AH35,AJ35,AH36:AJ36)","v":30.686984631351454},30.650306698238207,30.635143753776198]
[null,null,{"$f":"AVERAGE(C35:D35,D36,C37:D37)","v":81.018211276600567},{"$f":"AVERAGE(C35:E35,C36,E36,C37:E37)","v":80.786945651784009},80.204556882719146,79.234819645969452,77.810386586663469,75.851309470549666,73.35767785475025,70.421607292462554,67.209192255773402,63.86230469405151,60.476199081870014,57.098774760796104,53.76373182590887,50.503364265412884,47.358933499013787,44.388357213064062,41.667662256644064,39.279241222032795,37.287962987699579,35.714762013315578,34.526209425277948,33.646328531280744,32.98472534081543,32.462937509095021,32.032591578656074,31.674946435452902,31.391456003650646,31.180700208308739,31.031378254037733,30.922239095863535,30.837370047081912,30.768992941063878,{"$f":"AVERAGE(AH35:AJ35,AH36,AJ36,AH37:AJ37)","v":30.717051425848382},30.683314502743894,30.669529698641895]
[null,null,{"$f":"AVERAGE(C36,D36,D37)","v":80.784008344195414},{"$f":"AVERAGE(C36:E36,C37,E37)","v":80.546930345490495},{"$f":"AVERAGE(D36:F36,D37,F37)","v":79.940992068027839},78.931771292681759,77.468167124085369,75.512618779867509,73.075629419473586,70.235018289373357,67.111078030214486,63.827369725270046,60.478184603289741,57.126391605038066,53.815190180022796,50.583815259926965,47.477986738023702,44.555596365100925,41.885177440688594,39.535167974753918,37.555936662050385,35.962693069470703,34.728741658487756,33.793865931424961,33.083478266860162,32.529690341250216,32.08487894583218,31.72439490890639,31.438277720260771,31.22008172382035,31.058805002764124,30.939853405368098,30.849720301688869,30.780406855821298,30.729171677564914,30.696371636180629,{"$f":"AVERAGE(AJ36,AK36,AJ37)","v":30.683071945855474}]

{"sheet":"List1","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"PAHy","index":3,"n_rows":120,"n_cols":6,"rows_kept":120,"cut":false,"hidden":false,"merged":[]}
[]
[null,"middle date","fluorene","phenantrene","fluoranthene","pyrene"]
[null,"2003-10-15",434.4,1091.8,297.39999999999998,156.19999999999999]
[null,"2003-11-12",479,1425.8,327.2,158.19999999999999]
[null,"2003-12-10",705.8,2222.1999999999998,635.6,335.4]
[null,"2004-01-07",1069.4000000000001,3792.4,1030.4000000000001,483.6]
[null,"2004-02-04",630.79999999999995,2142,674.2,266]
[null,"2004-03-03",745,2181.8000000000002,639.20000000000005,243.2]
[null,"2004-03-31",246.8,786,266,126.4]
[null,"2004-04-28",126.8,464.4,142.4,72]
[null,"2004-05-26",89.6,269.39999999999998,68,36]
[null,"2004-06-26",55.857140000000001,163.19999999999999,44.928570000000001,21.857140000000001]
[null,"2004-07-27",5.6,55.8,27.2,13]
[null,"2004-08-24",37.4,108.8,32.6,15.8]
[null,"2004-09-21",143.44640000000001,408.58929999999998,130.5,73.432140000000004]
[null,"2004-10-20",442.7679,1328.614,405.4821,205.9]
[null,"2004-12-01",1853.5,5524.357,1273.643,691.42859999999996]
[null,"2005-01-12",898.2,2967,823.2,501.8]
[null,"2005-02-09",688,1893.1,460.8,241.2]
[null,"2005-03-09",569.79999999999995,1817.6,494.6,204.4]
[null,"2005-04-06",216.6,700.4,306.60000000000002,348.6]
[null,"2005-05-04",64.7,193.8,84.8,106.4]
[null,"2005-06-01",140,363.6,103.4,42.6]
[null,"2005-06-29",138.19999999999999,296,60,23.2]
[null,"2005-07-27",94.4,293.2,82.4,52.6]
[null,"2005-08-24",97.4,272.60000000000002,111.6,193.2]
[null,"2005-09-21",58,137.80000000000001,61,38]
[null,"2005-10-19",417.6,1066.8,414.65,275.75]
[null,"2005-11-16",1354.44,3156.52,741.52,506.96]
[null,"2005-12-14",1261.3800000000001,3246.14,1107.68,541.28]
[null,"2006-01-11",1003.46,2293.98,418.36,181.86]
[null,"2006-02-08",1392.1,3389.92,614.41999999999996,241.46]
[null,"2006-03-08",612.78,2507.7399999999998,499.36,148.04]
[null,"2006-04-05",387.66,1367.14,296.56,125.48]
[null,"2006-05-03",125.82,445.32,113.7,50.56]
[null,"2006-05-31",99.02,299.24,77.92,32.96]
[null,"2006-06-28",82.24,221.26,58.48,24.84]
[null,"2006-07-26",84.34,214.3,86.8,138.36000000000001]
[null,"2006-08-23",53.8,148.12,43.16,23.18]
[null,"2006-09-20",75.02,171.46,56.1,29.92]
[null,"2006-10-18",210.02,571.12,164.94,93.08]
[null,"2006-11-15",390.46,1202.3599999999999,335.4,179.3]
[null,"2006-12-13",663.28,1860.88,471.92,258.39999999999998]
[null,"2007-01-10",218.5,880.88,342,169.54]
[null,"2007-02-07",390.56,1066.46,372.42,204.44]
[null,"2007-03-07",256.72000000000003,843.62,272.12,30.8]
[null,"2007-04-04",176.7,501.2,171.88,76.38]
[null,"2007-05-02",102.68,317.36,109.42,51.34]
[null,"2007-05-30",51.4,146.41999999999999,38.1,18.64]
[null,"2007-06-27",33.700000000000003,80.08,1.68,3.74]
[null,"2007-07-26",37.371429999999997,90.385710000000003,29.292860000000001,12.49286]
[null,"2007-08-23",62.520710000000001,157.77359999999999,44.237139999999997,23.520710000000001]
[null,"2007-09-19",122.84,316.76,121.74,51.6]
[null,"2007-10-17",342.74,842.74,262.22000000000003,150.16]
[null,"2007-11-14",441,1279.46,365.48,195.86]
[null,"2007-12-12",849.75,2461.21,671.87,322.11]
[null,"2008-01-24",1239.1866669999999,4255.4586669999999,1081.509333,494.536]
[null,"2008-02-21",826.17230770000003,2899.6153850000001,784.02153850000002,370.91384620000002]
[null,"2008-03-19",355.26,1239.3399999999999,352.12,161.86000000000001]
[null,"2008-04-16",216.18,675.02,201.28,97.66]
[null,"2008-05-14",95.54,317.94,101.84,53.78]
[null,"2008-06-11",42.4,119.78,42.74,28.34]
[null,"2008-07-09",72.84,222.62,56.12,23.6]
[null,"2008-08-06",48.66,138.97999999999999,46.1,20.6]
[null,"2008-09-03",87.6,183.1,52.64,28.6]
[null,"2008-10-01",213.96,632.76,185.58,98.6]
[null,"2008-10-29",264.94,841.78,224.68,108.92]
[null,"2008-11-26",445.9,1351.58,377.06,179.62]
[null,"2008-12-24",1119.28,2743.32,674.6,307.32]
[null,"2009-01-21",1295.32,3065.78,707.46,282.98]
[null,"2009-02-18",534.74,1619.68,442.78,174.32]
[null,"2009-03-18",209.2,672.92,202.78,86.78]
[null,"2009-04-15",55.1,174.22,59.56,26.44]
[null,"2009-05-13",33.86,113.64,38.700000000000003,18.14]
[null,"2009-06-10",22,67.28,17.52,8.98]
[null,"2009-07-08",18.100000000000001,61.18,18.32,9.14]
[null,"2009-08-05",14.46,38.58,12.42,5.98]
[null,"2009-09-02",32.76,73.88,22.9,12.22]
[null,"2009-09-30",892.38,2980.52,941.66,571.79999999999995]
[null,"2009-10-28",460.58,1177.08,322.8,166.56]
[null,"2009-11-25",233.56,813.18,251.38,137.94]
[null,"2009-12-23",701.78,1846.8,446.48,188.56]
[null,"2010-01-20",723.06,1738.92,412.08,147.18]
[null,"2010-02-17",680.8,1673.4,407.86,136.6]
[null,"2010-03-17",263.60000000000002,935.38,308.33999999999997,113.88]
[null,"2010-04-14",114.54,351.1,145.84,68.88]
[null,"2010-05-12",106.82,366.72,131.46,60.66]
[null,"2010-06-09",130.66,390.4,149.66,74.760000000000005]
[null,"2010-07-07",72.98,186.02,76.72,31.64]
[null,"2010-08-04",49.84,143.77000000000001,41.07,20.69]
[null,"2010-09-01",82.84,271.67,93.84,54.88]
[null,"2010-09-29",298.48,737.94,242.38,128.54]
[null,"2010-10-27",154.96,439.28,139.63999999999999,70.959999999999994]
[null,"2010-11-24",655.94,1517.62,358.42,186.5]
[null,"2010-12-22",664.88,1762.74,444.56,193.7]
[null,"2011-01-19",729.64,1852.7,469.72,198.7]
[null,"2011-02-16",759.36,1624.26,392.5,155.88]
[null,"2011-03-16",332.7,966.56,291.5,124.04]
[null,"2011-04-13",174.68,561.17999999999995,152.63999999999999,65.900000000000006]
[null,"2011-05-11",90.36,275.95999999999998,98.66,48.26]
[null,"2011-06-08",153.44,474.48,180.44,84.36]
[null,"2011-07-06",166.52,487.88,208.24,88.16]
[null,"2011-08-03",24.3,69.5,22.08,11.1]
[null,"2011-08-31",43.88,108.08,45.46,24.02]
[null,"2011-09-28",147.12,404.78,130.4,76.040000000000006]
[null,"2011-10-26",619.29999999999995,1704.62,683.82,343.44]
[null,"2011-11-23",827.76,2544.88,803.26,435.34]
[null,"2011-12-21",412.06,1650.82,601.74,318.38]
[null,"2012-01-18",941.72,2271.6,749.66,363.66]
[null,"2012-02-15",1006.72,3190.76,968.4,416.74]
[null,"2012-03-14",272.56,957.26,368.26,184.08]
[null,"2012-04-11",155.52000000000001,540.64,226.58,109.46]
[null,"2012-05-09",49.94,173.58,94.66,39.880000000000003]
[null,"2012-06-06",34.159999999999997,92.12,35.28,12.7]
[null,"2012-07-04",38.06,103.9,38.22,19.2]
[null,"2012-08-01",32.36,78.34,28.94,13.2]
[null,"2012-08-29",53.76,132.04,43.5,25.84]
[null,"2012-09-26",64.88,205.48,73.48,45.1]
[null,"2012-10-24",272,857.42,292.27999999999997,146.46]
[null,"2012-11-21",453.8,1301.5999999999999,445.2,220.62]