{"text_format":"1","workbook":"xlsx","n_sheets":21,"sheets":["Skupiny","Cenník","Zápis údajov","Plánované prerušenie pre obec","Plánované prerušenie pre obyv","Preplachy pre obec","Preplachy pre obyvateľov","Porucha pre obec","Porucha pre obyvateľov","BA počty","Ext. lab.","Porovnanie","MO počty","SE počty","Hárok2","Fosfor","ZVS","Tatry","BVS bilancia","Hotel Junior","BEZ"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":2,"comments":8,"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":"Skupiny","index":0,"n_rows":42,"n_cols":32,"rows_kept":42,"cut":false,"hidden":true,"merged":[]}
[]
["Číslo skupiny","Ukazovatele zoradené v bunke","Počet","Cena"]
[1,{"$f":"E3&F3&G3&H3&I3&J3&K3&L3&M3&N3&O3&P3&Q3&R3&S3&T3&U3&V3&W3&X3&Y3&Z3&AA3&AB3&AC3&AD3&AE3&AF3","v":"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, "},{"$f":"COUNTA(E3:AF3)","v":8},{"$f":"Cenník!C35","v":113.52000000000001},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, "]
[2,{"$f":"E4&F4&G4&H4&I4&J4&K4&L4&M4&N4&O4&P4&Q4&R4&S4&T4&U4&V4&W4&X4&Y4&Z4&AA4&AB4&AC4&AD4&AE4&AF4","v":"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), EL-IČ, "},{"$f":"COUNTA(E4:AF4)","v":7},{"$f":"Cenník!E35","v":70.37},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ","EL-IČ, "]
[3,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), ",7,{"$f":"Cenník!G35","v":77.010000000000005},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), "]
[4,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, ",6,{"$f":"Cenník!I35","v":70.37},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, "]
[5,"RL-105, NL-105, pH, CHSK-Cr, NEL-IČ, ",5,{"$f":"Cenník!K35","v":62.07},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,"NEL-IČ, "]
[6,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), EL-IČ, Pc, Nc, ",9,{"$f":"Cenník!M35","v":91.95},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ","EL-IČ, ","Pc, ","Nc, "]
[7,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Pc, ",9,{"$f":"Cenník!O35","v":121.82000000000001},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ","Pc, "]
[8,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), EL-IČ, Pc, ",8,{"$f":"Cenník!Q35","v":78.67},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ","EL-IČ, ","Pc, "]
[9,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), Pc, ",8,{"$f":"Cenník!S35","v":85.31},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ",null,"Pc, "]
[10,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, Pc, ",7,{"$f":"Cenník!U35","v":78.67},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ",null,null,"Pc, "]
[11,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Hg, Cu, Cr6+,Crcelk., Pb, As, Cd, ",15,{"$f":"Cenník!W35","v":164.226},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ",null,null,"Hg, ","Cu, ","Cr6+,","Crcelk., ","Pb, ","As, ","Cd, "]
[12,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Hg, Cu, Cr6+,Crcelk., Pb, As, Cd, Ni, Zn, ",17,{"$f":"Cenník!Y35","v":175.506},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ",null,null,"Hg, ","Cu, ","Cr6+,","Crcelk., ","Pb, ","As, ","Cd, ","Ni, ","Zn, "]
[13,"RL-105, NL-105, pH, CHSK-Cr, Cu, Crcelk., Ni, Zn, CNcelk., ",9,{"$f":"Cenník!AA35","v":61.31},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,null,null,null,null,null,null,"Cu, ",null,"Crcelk., ",null,null,null,"Ni, ","Zn, ","CNcelk., "]
[14,"RL-105, NL-105, pH, CHSK-Cr, Cu, Crcelk., Pb, Ni, Zn, CNcelk., ",10,{"$f":"Cenník!AC35","v":67.28},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,null,null,null,null,null,null,"Cu, ",null,"Crcelk., ","Pb, ",null,null,"Ni, ","Zn, ","CNcelk., "]
[15,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), Pc, ",7,{"$f":"Cenník!AE35","v":42.16},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ",null,"Pc, "]
[16,"RL-105, NL-105, pH, CHSK-Cr, BSK5(ATM), ",5,{"$f":"Cenník!AG35","v":25.560000000000002},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,null,"BSK5(ATM), "]
[17,"RL-105, NL-105, pH, CHSK-Cr, NEL-IČ, Pc, Ni, Zn, AOX, ",9,{"$f":"Cenník!AI35","v":127.65},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,"NEL-IČ, ",null,null,"Pc, ",null,null,null,null,null,null,null,null,"Ni, ","Zn, ",null,null,"AOX, "]
[18,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), Cu, Crcelk., Ni, Zn, ",11,{"$f":"Cenník!AK35","v":119.08600000000001},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ",null,null,null,null,"Cu, ",null,"Crcelk., ",null,null,null,"Ni, ","Zn, "]
[19,"RL-105, NL-105, pH, CHSK-Cr, NEL-IČ, BSK5(ATM), ",6,{"$f":"Cenník!AM35","v":68.709999999999994},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,"NEL-IČ, ","BSK5(ATM), "]
[20,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, Propylénglykol, ",7,{"$f":"Cenník!AO35","v":116.37},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Propylénglykol, "]
[21,"RL-105, NL-105, pH, NEL-IČ, ",4,{"$f":"Cenník!AQ35","v":55.43},"RL-105, ","NL-105, ","pH, ",null,null,"NEL-IČ, "]
[22,"RL-105, NL-105, pH, CHSK-Cr, Cu, AOX, Sn, Fe, ",8,{"$f":"Cenník!AS35","v":130.19},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,null,null,null,null,null,null,"Cu, ",null,null,null,null,null,null,null,null,null,"AOX, ",null,"Sn, ","Fe, "]
[23,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Pc, Nc, Hg, Cd, ",12,{"$f":"Cenník!AU35","v":149.46599999999998},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ","Pc, ","Nc, ","Hg, ",null,null,null,null,null,"Cd, "]
[24,"RL-105, pH, CHSK-Cr, NEL-IČ, BSK5(ATM), N-NH4, N-NO2, N-NO3, ",8,{"$f":"Cenník!AW35","v":80.160000000000011},"RL-105, ",null,"pH, ","CHSK-Cr, ",null,"NEL-IČ, ","BSK5(ATM), ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-NH4, ","N-NO2, ","N-NO3, "]
[25,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Crcelk., Zn, ",10,{"$f":"Cenník!AY35","v":124.80000000000001},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ",null,null,null,null,null,"Crcelk., ",null,null,null,null,"Zn, "]
[26,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, Zn, ",6,{"$f":"Cenník!BA35","v":32.53},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,null,null,null,null,null,null,null,null,null,null,null,null,"Zn, "]
[27,"RL-105, NL-105, pH, CHSK-Cr, NEL-IČ, BSK5(ATM), Cd, ",7,{"$f":"Cenník!BC35","v":74.679999999999993},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,"NEL-IČ, ","BSK5(ATM), ",null,null,null,null,null,null,null,null,null,"Cd, "]
[28,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), ",6,{"$f":"Cenník!BE35","v":33.86},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), "]
[29,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, NEL-IČ, BSK5(ATM), EL-IČ, Cu, Zn, ",10,{"$f":"Cenník!BG35","v":124.80000000000001},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ","NEL-IČ, ","BSK5(ATM), ","EL-IČ, ",null,null,null,"Cu, ",null,null,null,null,null,null,"Zn, "]
[30,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), EL-IČ, Cu, Cr6+,Crcelk., Zn, ",11,{"$f":"Cenník!BI35","v":98.080000000000013},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ","EL-IČ, ",null,null,null,"Cu, ","Cr6+,","Crcelk., ",null,null,null,null,"Zn, "]
[31,"RL-105, NL-105, pH, CHSK-Cr, Cu, Cr6+,Crcelk., Zn, ",8,{"$f":"Cenník!BK35","v":46.63},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ",null,null,null,null,null,null,null,"Cu, ","Cr6+,","Crcelk., ",null,null,null,null,"Zn, "]
[32,{"$f":"E34&F34&G34&H34&I34&J34&K34&L34&M34&N34&O34&P34&Q34&R34&S34&T34&U34&V34&W34&X34&Y34&Z34&AA34&AB34&AC34&AD34&AE34&AF34","v":"RL-105, NL-105, pH, CHSK-Cr, PAL-A, "},5,{"$f":"Cenník!BM35","v":27.220000000000002},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, "]
[33,"RL-105, NL-105, pH, CHSK-Cr, PAL-A, EL-IČ, ",6,{"$f":"Cenník!BO35","v":63.730000000000004},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,null,"EL-IČ, "]
[34,{"$f":"E36&F36&G36&H36&I36&J36&K36&L36&M36&N36&O36&P36&Q36&R36&S36&T36&U36&V36&W36&X36&Y36&Z36&AA36&AB36&AC36&AD36&AE36&AF36&AG36","v":"RL-105, NL-105, pH, CHSK-Cr, PAL-A, BSK5(ATM), EL-grav,Pc, Nc, "},{"$f":"COUNTA(E36:AG36)","v":9},{"$f":"Cenník!BQ35","v":88.02},"RL-105, ","NL-105, ","pH, ","CHSK-Cr, ","PAL-A, ",null,"BSK5(ATM), ","EL-grav,","Pc, ","Nc, "]
[35,"pH, BSK5(ATM), Pc, Nc, ",4,{"$f":"Cenník!BS35","v":31.54},null,null,"pH, ",null,null,null,"BSK5(ATM), ",null,"Pc, ","Nc, "]
[36,"Hg,Pb,As,Cd,",4,{"$f":"Cenník!BU35","v":28.305999999999997},null,null,null,null,null,null,null,null,null,null,"Hg,",null,null,null,"Pb,","As,","Cd,"]
[37,"CHSK-Cr, BSK5(ATM), N-NH4, ",3,{"$f":"Cenník!BW35","v":19.25},null,null,null,"CHSK-Cr, ",null,null,"BSK5(ATM), ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"N-NH4, "]
[38,"",0]
[39,"",0]
[40,"",0]

{"sheet":"Cenník","index":1,"n_rows":36,"n_cols":80,"rows_kept":36,"cut":false,"hidden":true,"merged":[]}
[null,"Skupina 1","Cena1","Skupina 2","Cena2","Skupina 3","Cena3","Skupina 4","Cena4","Skupina 5","Cena5","Skupina 6","Cena6","Skupina 7","Cena7","Skupina 8","Cena","Skupina 9","Cena9","Skupina 10","Cena10","Skupina 11","Cena11","Skupina 12","Cena12","Skupina 13","Cena13","Skupina 14","Cena14","Skupina 15","Cena15","Skupina 16","Cena16","Skupina 17","Cena17","Skupina 18","Cena18","Skupina 19","Cena19","Skupina 20","Cena20","Skupina 21","Cena21","Skupina 22","Cena22","Skupina 23","Cena23","Skupina 24","Cena24","Skupina 25","Cena25","Skupina 26","Cena26","Skupina 27","Cena27","Skupina 28","Cena28","Skupina 29","Cena29","Skupina 30","Cena30","Skupina 31","Cena31","Skupina 32","Cena32","Skupina 33","Cena33","Skupina 34","Cena34","Skupina 35","Cena35","Skupina 36","Cena36","Skupina 37","Cena37",null,"Zoznam ukazovateľov","Skratka","Cena"]
[null,"RL-105",{"$f":"IF(ISBLANK(B2),\" \",VLOOKUP(B2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(D2),\" \",VLOOKUP(D2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(F2),\" \",VLOOKUP(F2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(H2),\" \",VLOOKUP(H2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(J2),\" \",VLOOKUP(J2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(L2),\" \",VLOOKUP(L2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(N2),\" \",VLOOKUP(N2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(P2),\" \",VLOOKUP(P2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(R2),\" \",VLOOKUP(R2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(T2),\" \",VLOOKUP(T2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(V2),\" \",VLOOKUP(V2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(X2),\" \",VLOOKUP(X2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(Z2),\" \",VLOOKUP(Z2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AB2),\" \",VLOOKUP(AB2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AD2),\" \",VLOOKUP(AD2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AF2),\" \",VLOOKUP(AF2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AH2),\" \",VLOOKUP(AH2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AJ2),\" \",VLOOKUP(AJ2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AL2),\" \",VLOOKUP(AL2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AN2),\" \",VLOOKUP(AN2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AP2),\" \",VLOOKUP(AP2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AR2),\" \",VLOOKUP(AR2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AT2),\" \",VLOOKUP(AT2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AV2),\" \",VLOOKUP(AV2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AX2),\" \",VLOOKUP(AX2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(AZ2),\" \",VLOOKUP(AZ2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BB2),\" \",VLOOKUP(BB2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BD2),\" \",VLOOKUP(BD2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BF2),\" \",VLOOKUP(BF2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BH2),\" \",VLOOKUP(BH2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BJ2),\" \",VLOOKUP(BJ2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BL2),\" \",VLOOKUP(BL2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BN2),\" \",VLOOKUP(BN2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"RL-105",{"$f":"IF(ISBLANK(BP2),\" \",VLOOKUP(BP2,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},null,{"$f":"IF(ISBLANK(BR2),\" \",VLOOKUP(BR2,$BZ$2:$CA$34,2,FALSE))","v":" "},null,{"$f":"IF(ISBLANK(BT2),\" \",VLOOKUP(BT2,$BZ$2:$CA$34,2,FALSE))","v":" "},null,{"$f":"IF(ISBLANK(BV2),\" \",VLOOKUP(BV2,$BZ$2:$CA$34,2,FALSE))","v":" "},null,"Rozpustené látky pri 105 °C","RL-105",4.4800000000000004]
[null,"NL-105",{"$f":"IF(ISBLANK(B3),\" \",VLOOKUP(B3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(D3),\" \",VLOOKUP(D3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(F3),\" \",VLOOKUP(F3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(H3),\" \",VLOOKUP(H3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(J3),\" \",VLOOKUP(J3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(L3),\" \",VLOOKUP(L3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(N3),\" \",VLOOKUP(N3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(P3),\" \",VLOOKUP(P3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(R3),\" \",VLOOKUP(R3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(T3),\" \",VLOOKUP(T3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(V3),\" \",VLOOKUP(V3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(X3),\" \",VLOOKUP(X3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(Z3),\" \",VLOOKUP(Z3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AB3),\" \",VLOOKUP(AB3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AD3),\" \",VLOOKUP(AD3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AF3),\" \",VLOOKUP(AF3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AH3),\" \",VLOOKUP(AH3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AJ3),\" \",VLOOKUP(AJ3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AL3),\" \",VLOOKUP(AL3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AN3),\" \",VLOOKUP(AN3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AP3),\" \",VLOOKUP(AP3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AR3),\" \",VLOOKUP(AR3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AT3),\" \",VLOOKUP(AT3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},null,{"$f":"IF(ISBLANK(AV3),\" \",VLOOKUP(AV3,$BZ$2:$CA$34,2,FALSE))","v":" "},"NL-105",{"$f":"IF(ISBLANK(AX3),\" \",VLOOKUP(AX3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(AZ3),\" \",VLOOKUP(AZ3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BB3),\" \",VLOOKUP(BB3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BD3),\" \",VLOOKUP(BD3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BF3),\" \",VLOOKUP(BF3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BH3),\" \",VLOOKUP(BH3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BJ3),\" \",VLOOKUP(BJ3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BL3),\" \",VLOOKUP(BL3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BN3),\" \",VLOOKUP(BN3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},"NL-105",{"$f":"IF(ISBLANK(BP3),\" \",VLOOKUP(BP3,$BZ$2:$CA$34,2,FALSE))","v":4.4800000000000004},null," ",null,{"$f":"IF(ISBLANK(BT3),\" \",VLOOKUP(BT3,$BZ$2:$CA$34,2,FALSE))","v":" "},null,{"$f":"IF(ISBLANK(BV3),\" \",VLOOKUP(BV3,$BZ$2:$CA$34,2,FALSE))","v":" "},null,"Nerozpustené látky pri 105 °C","NL-105",4.4800000000000004]
[null,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,"pH",3.32,null," ",null," ",null,"Reakcia vody","pH",3.32]
[null,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,null," ","CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,"CHSK-Cr",6.64,null," ",null," ","CHSK-Cr",6.64,null,"Chemická spotreba kyslíka dvojchromanom","CHSK-Cr",6.64]
[null,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,null," ","PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,null," ",null," ","PAL-A",8.3000000000000007,null," ",null," ","PAL-A",8.3000000000000007,null," ","PAL-A",8.3000000000000007,null," ",null," ","PAL-A",8.3000000000000007,null," ","PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,null," ","PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,null," ","PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,"PAL-A",8.3000000000000007,null," ",null," ",null," ",null,"Povrchovo aktívne látky aniónové","PAL-A",8.3000000000000007]
[null,"NEL-IČ",43.15,null," ","NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,null," ","NEL-IČ",43.15,null," ","NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,null," ",null," ",null," ",null," ","NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,null," ","NEL-IČ",43.15,"NEL-IČ",43.15,"NEL-IČ",43.15,null," ","NEL-IČ",43.15,null," ","NEL-IČ",43.15,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Nepolárne extrahovateľné látky IČ","NEL-IČ",43.15]
[null,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ",null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ",null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ",null," ",null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ",null," ",null," ","BSK5(ATM)",6.64,"BSK5(ATM)",6.64,null," ","BSK5(ATM)",6.64,null,"Biologická spotreba kyslíka - s potlačením nitrifikácie","BSK5(ATM)",6.64]
[null,"EL-IČ",36.51,"EL-IČ",36.51,null," ",null," ",null," ","EL-IČ",36.51,"EL-IČ",36.51,"EL-IČ",36.51,null," ",null," ","EL-IČ",36.51,"EL-IČ",36.51,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","EL-IČ",36.51,null," ","EL-IČ",36.51,null," ",null," ",null," ","EL-IČ",36.51,"EL-IČ",36.51,null," ",null," ","EL-IČ",36.51,null," ",null," ",null," ",null," ",null,"Extrahovateľné látky IČ","EL-IČ",36.51,"el gravimetricjy pre mliekaren senica cena 32,58."]
[null,null," ",null," ",null," ",null," ",null," ","Pc",8.3000000000000007,"Pc",8.3000000000000007,"Pc",8.3000000000000007,"Pc",8.3000000000000007,"Pc",8.3000000000000007,null," ",null," ",null," ",null," ","Pc",8.3000000000000007,null," ","Pc",8.3000000000000007,null," ",null," ",null," ",null," ",null," ","Pc",8.3000000000000007,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Pc",8.3000000000000007,"Pc",8.3000000000000007,null," ",null," ",null,"Celkový fosfor","Pc",8.3000000000000007]
[null,null," ",null," ",null," ",null," ",null," ","Nc",13.28,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Nc",13.28,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Nc",13.28,"Nc",13.28,null," ",null," ",null,"Celkový dusík","Nc",13.28]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Hg",8.3960000000000008,"Hg",8.3960000000000008,null," ",null," ",null," ",null," ",null," ","Hg",8.3960000000000008,null," ",null," ",null," ",null," ","Hg",8.3960000000000008,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Hg",8.3960000000000008,null," ",null,"Ortuť","Hg",8.3960000000000008]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cu",5.97,"Cu",5.97,"Cu",5.97,"Cu",5.97,null," ",null," ",null," ","Cu",5.97,null," ",null," ",null," ","Cu",5.97,null," ",null," ",null," ",null," ",null," ",null," ","Cu",5.97,"Cu",5.97,"Cu",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null,"Meď","Cu",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cr6+",10.46,"Cr6+",10.46,null," ",null," ",null," ",null," ",null," ","Cr6+",10.46,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cr6+",10.46,"Cr6+",10.46,null," ",null," ",null," ",null," ",null," ",null," ",null,"Chróm VI","Cr6+",10.46,"vuvh"]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Crcelk.",5.97,"Crcelk.",5.97,"Crcelk.",5.97,"Crcelk.",5.97,null," ",null," ",null," ","Crcelk.",5.97,null," ",null," ",null," ",null," ",null," ",null," ","Crcelk.",5.97,null," ",null," ",null," ",null," ","Crcelk.",5.97,"Crcelk.",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null,"Chróm celkový","Crcelk.",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Pb",5.97,"Pb",5.97,null," ","Pb",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Pb",5.97,null," ",null,"Olovo","Pb",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","As",7.97,"As",7.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","As",7.97,null," ",null,"Arzén","As",7.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cd",5.97,"Cd",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cd",5.97,null," ",null," ",null," ","Cd",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Cd",5.97,null," ",null,"meď","Cd",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Ni",5.97,"Ni",5.97,"Ni",5.97,null," ",null," ","Ni",5.97,"Ni",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Nikel","Ni",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Zn",5.31,"Zn",5.31,"Zn",5.31,null," ",null," ","Zn",5.31,"Zn",5.31,null," ",null," ",null," ",null," ",null," ",null," ","Zn",5.31,"Zn",5.31,null," ",null," ","Zn",5.31,"Zn",5.31,"Zn",5.31,null," ",null," ",null," ",null," ",null," ",null," ",null,"Zinok","Zn",5.31]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","CNcelk.",19.170000000000002,"CNcelk.",19.170000000000002,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Kyanidy celkové","CNcelk.",19.170000000000002]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Adsorbovateľné, organicky viazané halogény","AOX",46]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","AOX",46,null," ",null," ",null," ",null," ","AOX",46,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Propylénglykol","Propylénglykol",46,"vuvh"]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Propylénglykol",46,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Cín","Sn",45,"aj manipulačný poplatok"]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Sn",45,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Železo","Fe",14.3,"aj manipulačný poplatok"]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","Fe",14.3,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Amoniakálny dusík","N-NH4",5.97]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","N-NH4",5.97,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","N-NH4",5.97,null,"Dusitanový dusík","N-NO2",4.9800000000000004]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","N-NO2",4.9800000000000004,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Dusičnanový dusík","N-NO3",4.9800000000000004]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","N-NO3",4.9800000000000004,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null,"Extrahovateľné látky gravimetricky","EL-grav",32.58]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ","EL-grav",32.58,null," ",null," ",null," "]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," "]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," "]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," "]
[null,null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," ",null," "]
["Počet / cena",{"$f":"COUNTA(B2:B34)","v":8},{"$f":"SUM(C2:C34)","v":113.52000000000001},{"$f":"COUNTA(D2:D34)","v":7},{"$f":"SUM(E2:E34)","v":70.37},7,{"$f":"SUM(G2:G34)","v":77.010000000000005},6,{"$f":"SUM(I2:I34)","v":70.37},5,{"$f":"SUM(K2:K34)","v":62.07},9,{"$f":"SUM(M2:M34)","v":91.95},9,{"$f":"SUM(O2:O34)","v":121.82000000000001},8,{"$f":"SUM(Q2:Q34)","v":78.67},8,{"$f":"SUM(S2:S34)","v":85.31},7,{"$f":"SUM(U2:U34)","v":78.67},15,{"$f":"SUM(W2:W34)","v":164.226},17,{"$f":"SUM(Y2:Y34)","v":175.506},9,{"$f":"SUM(AA2:AA34)","v":61.31},10,{"$f":"SUM(AC2:AC34)","v":67.28},7,{"$f":"SUM(AE2:AE34)","v":42.16},5,{"$f":"SUM(AG2:AG34)","v":25.560000000000002},9,{"$f":"SUM(AI2:AI34)","v":127.65},13,{"$f":"SUM(AK2:AK34)","v":119.08600000000001},6,{"$f":"SUM(AM2:AM34)","v":68.709999999999994},7,{"$f":"SUM(AO2:AO34)","v":116.37},4,{"$f":"SUM(AQ2:AQ34)","v":55.43},8,{"$f":"SUM(AS2:AS34)","v":130.19},12,{"$f":"SUM(AU2:AU34)","v":149.46599999999998},8,{"$f":"SUM(AW2:AW34)","v":80.160000000000011},10,{"$f":"SUM(AY2:AY34)","v":124.80000000000001},6,{"$f":"SUM(BA2:BA34)","v":32.53},7,{"$f":"SUM(BC2:BC34)","v":74.679999999999993},6,{"$f":"SUM(BE2:BE34)","v":33.86},10,{"$f":"SUM(BG2:BG34)","v":124.80000000000001},11,{"$f":"SUM(BI2:BI34)","v":98.080000000000013},8,{"$f":"SUM(BK2:BK34)","v":46.63},5,{"$f":"SUM(BM2:BM34)","v":27.220000000000002},6,{"$f":"SUM(BO2:BO34)","v":63.730000000000004},9,{"$f":"SUM(BQ2:BQ34)","v":88.02},4,{"$f":"SUM(BS2:BS34)","v":31.54},{"$f":"COUNTA(BT2:BT34)","v":4},{"$f":"SUM(BU2:BU34)","v":28.305999999999997},3,{"$f":"SUM(BW2:BW34)","v":19.25}]
[null,"Skupina 1","Cena1","Skupina 2","Cena2","Skupina 3","Cena3","Skupina 4","Cena4","Skupina 5","Cena5","Skupina 6","Cena6","Skupina 7","Cena7","Skupina 8","Cena","Skupina 9","Cena9","Skupina 10","Cena10","Skupina 11","Cena11","Skupina 12","Cena12","Skupina 13","Cena13","Skupina 14","Cena14","Skupina 15","Cena15","Skupina 16","Cena16","Skupina 17","Cena17","Skupina 18","Cena18","Skupina 19","Cena19","Skupina 20","Cena20","Skupina 21","Cena21","Skupina 22","Cena22","Skupina 23","Cena23","Skupina 24","Cena24","Skupina 25","Cena25","Skupina 26","Cena26","Skupina 27","Cena27","Skupina 28","Cena28","Skupina 29","Cena29","Skupina 30","Cena30","Skupina 31","Cena31","Skupina 32","Cena32","Skupina 33","Cena33","Skupina 34","Cena34","Skupina 35","Cena35","Skupina 36","Cena36","Skupina 37","Cena37"]

{"sheet":"Zápis údajov","index":2,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,0,1,1]]}
["Oznámenie o prerušení dodávky vody, poruche, preplachoch"]
["Vypĺňať len žlté bunky v stĺpci B !!!! ( Z týchto polí sa prenášajú údaje do oznámení)"]
["Miesto prerušenia:","Kopčianska ul.","Zapísať vo formáte: Názov Mesta/Obce - Názov mestskej časti, prípadne miestnej časti (napr. Ostredky, Trnávka, Pošeň, ....)                            NEPOUŽÍVAŤ SKRATKY (BA III. a pod.)!!!"]
["Oblasť bez vody:","Kopčianska ul.","Zapísať vo formáte: Názov ulice, resp. bližšie špecifikovať oblasť bez vody vypísaním  viacerých ulíc                                                                                      NEPOUŽÍVAŤ SKRATKY (BA II., ul. a pod.)!!!"]
["Plánovaný začiatok prerušenia: ","07.07.2020 od 8:00 hod.","Zapísať vo formáte: Deň.Mesiac.Rok od 00:00 hod."]
["Plánovaný čas ukončenia prerušenia:","07.07.2020 do 16:00 hod.","Zapísať vo formáte: Deň.Mesiac.Rok do 00:00 hod."]
["Náhradné zásobovanie pitnou vodou:","áno","Zapísať vo formáte: Áno / Nie"]
["Spôsob a miesto náhradného zásobovania :","cisterna s pitnou vodou","Len v  prípade, že bude zabezpečené náhradné zásobovanie PV. Zapísať vo formáte: cisterna s pitnou vodou / výtokovým stojanom umiestneným (napr. na Galvaniho ulici č. 48)"]
["Doplňujúce informácie:","Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody.","Zapísať vo formáte: Pole určené pre zapísanie informácií týkajúcich sa konkrétnej udalosti a dotknutí odberatelia by im mali venovať zvýšenú pozornosť! Návrh textu čo by mohlo pole obsahovať - viď bunky C10-C11:"]
[null,null,"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."]
[null,null,"Upozorňujeme, že počas vykonávania preplachu siete verejného vodovodu, môže prísť k dočasnému zhoršeniu kvality vody a zníženiu prevádzkového tlaku dodávanej pitnej vody."]
[null,null,"Počas trvania opravy môže dochádzať ku krátkodobým prerušeniam dodávky pitnej vody, a s tým spojenému dočasnému zhoršeniu kvality vody, ktoré je odstraňované mimoriadnymi preplachmi vodovodnej siete."]

{"sheet":"Plánované prerušenie pre obec","index":3,"n_rows":37,"n_cols":6,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,0,36,4],[20,0,23,8],[25,0,27,8],[29,1,29,8],[33,5,33,7],[34,5,34,7],[16,0,16,2],[16,3,16,8],[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[13,0,13,2],[13,3,13,8],[14,0,14,2],[14,3,14,8],[15,0,15,2],[15,3,15,8],[0,7,0,8],[1,7,1,8],[8,0,10,8],[12,0,12,2],[12,3,12,8],[6,0,6,8]]}
[]
[]
[]
[]
[]
[]
["Oznámenie o prerušení dodávky vody z verejného vodovodu pre obec"]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, §32 ods.7 bod b) Vám oznamuje prerušenie dodávky vody z verejného vodovodu z dôvodu vykonávania plánovanej opravy verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok prerušenia: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme avšak oprava daného úseku verejného vodovodu je potrebná z dôvodu poruchovej udalosti, ako aj z dôvodu zabezpečenia požadovanej kvality dodávanej pitnej vody. V prípade akýchkoľvek problémov s dodávkou vody, môžete kontaktovať Poruchový dispečing  BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
["                 Zároveň si Vás dovoľujeme požiadať o informovanie obyvateľov v dotknutej oblasti  miestne obvyklým spôsobom, napr. vyhlásením oznamu miestnym rozhlasom, resp. zverejnením oznamu na Vašej webovej stránke."]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
["Na vedomie:"]
["Obyvatelia v dotknutej oblasti"]

{"sheet":"Plánované prerušenie pre obyv","index":4,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":false,"merged":[[37,0,37,3],[6,0,6,8],[21,0,24,8],[26,1,26,8],[31,5,31,7],[32,5,32,7],[35,0,35,4],[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[19,0,19,2],[19,3,19,8],[14,0,14,2],[14,3,14,8],[15,0,15,2],[15,3,15,8],[16,0,16,2],[16,3,16,8],[0,7,0,8],[1,7,1,8],[9,0,11,8],[13,0,13,2],[13,3,13,8]]}
[]
[]
[]
[]
[]
[]
["Oznámenie o prerušení dodávky vody z verejného vodovodu pre obyvateľov"]
[]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, §32 ods.7 bod b) Vám oznamuje prerušenie dodávky vody z verejného vodovodu z dôvodu vykonávania plánovanej opravy verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok prerušenia: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme avšak oprava daného úseku verejného vodovodu je potrebná z dôvodu poruchovej udalosti, ako aj z dôvodu zabezpečenia požadovanej kvality dodávanej pitnej vody. V prípade akýchkoľvek problémov s dodávkou vody, môžete kontaktovať Poruchový dispečing  BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
[]
["Na vedomie:"]
["Obec"]

{"sheet":"Preplachy pre obec","index":5,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[39,0,39,5],[41,0,41,3],[20,0,23,8],[25,0,27,8],[29,1,29,6],[33,5,33,7],[34,5,34,7],[37,0,37,5],[16,0,16,2],[16,3,16,8],[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[13,0,13,2],[13,3,13,8],[14,0,14,2],[14,3,14,8],[15,0,15,2],[15,3,15,8],[0,7,0,8],[1,7,1,8],[8,0,10,8],[12,0,12,2],[12,3,12,8],[6,0,6,8]]}
[]
[]
[]
[]
[]
[]
["Oznámenie o vykonávaní prevetívneho preplachu  verejného vodovodu pre obec"]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, Vám oznamuje vykonávanie preventívneho preplachu verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok preplachu: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia preplachu:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme, avšak preventívny preplach verejného vodovodu je potrebný z dôvodu zachovania kvality dodávanej pitnej vody. V prípade akýchkoľvek problémov s dodávkou vody, môžete kontaktovať Poruchový dispečing BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
["                 Zároveň si Vás dovoľujeme požiadať o informovanie obyvateľov v dotknutej oblasti  miestne obvyklým spôsobom, napr. vyhlásením oznamu miestnym rozhlasom, resp. zverejnením oznamu na Vašej webovej stránke."]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
[]
["Na vedomie:"]
["Obyvatelia v dotknutej oblasti"]

{"sheet":"Preplachy pre obyvateľov","index":6,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[19,0,19,2],[19,3,19,8],[21,0,24,8],[26,1,26,6],[30,5,30,7],[31,5,31,7],[37,0,37,5],[15,0,15,2],[15,3,15,8],[16,0,16,2],[16,3,16,8],[0,7,0,8],[1,7,1,8],[9,0,11,8],[13,0,13,2],[13,3,13,8],[6,0,6,8],[14,0,14,2],[14,3,14,8],[7,0,7,8]]}
[]
[]
[]
[]
[]
[]
["Oznámenie o vykonávaní prevetívneho preplachu  verejného vodovodu"]
["        pre obyvateľov"]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, Vám oznamuje vykonávanie preventívneho preplachu verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok preplachu: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia preplachu:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme, avšak preventívny preplach verejného vodovodu je potrebný z dôvodu zachovania kvality dodávanej pitnej vody. V prípade akýchkoľvek problémov s dodávkou vody, môžete kontaktovať Poruchový dispečing BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
[]
[]
[]
[]
["Na vedomie:"]
["Obec"]

{"sheet":"Porucha pre obec","index":7,"n_rows":38,"n_cols":6,"rows_kept":38,"cut":false,"hidden":false,"merged":[[29,1,29,6],[33,5,33,7],[34,5,34,7],[37,0,37,4],[25,0,27,8],[20,0,23,8],[13,0,13,2],[13,3,13,8],[14,0,14,2],[14,3,14,8],[15,0,15,2],[15,3,15,8],[16,0,16,2],[16,3,16,8],[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[0,7,0,8],[1,7,1,8],[6,1,6,8],[8,0,10,8],[12,0,12,2],[12,3,12,8]]}
[]
[]
[]
[]
[]
[]
[null,"Oznámenie o prerušení dodávky vody z verejného vodovodu pre obec"]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, §32 ods.1 bod b), Vám oznamuje prerušenie dodávky vody z verejného vodovodu z dôvodu neplánovanej opravy poruchy verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok prerušenia: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme. Oprava daného úseku verejného vodovodu je potrebná z dôvodu poruchovej udalosti, ako aj z dôvodu zabezpečenia požadovanej kvality pitnej vody. V prípade akýchkoľvek problémov s dodávkou pitnej vody, môžete kontaktovať poruchový dispečing BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
["                 Zároveň si Vás dovoľujeme požiadať o informovanie obyvateľov v dotknutej oblasti  miestne obvyklým spôsobom, napr. vyhlásením oznamu miestnym rozhlasom, resp. zverejnením oznamu na Vašej webovej stránke."]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
[]
["Na vedomie:"]
["Obyvatelia v dotknutej oblasti"]

{"sheet":"Porucha pre obyvateľov","index":8,"n_rows":39,"n_cols":6,"rows_kept":39,"cut":false,"hidden":false,"merged":[[21,0,24,8],[26,1,26,6],[31,5,31,7],[32,5,32,7],[38,0,38,4],[17,0,17,2],[17,3,17,8],[18,0,18,2],[18,3,18,8],[19,0,19,2],[19,3,19,8],[14,0,14,2],[14,3,14,8],[15,0,15,2],[15,3,15,8],[16,0,16,2],[16,3,16,8],[0,7,0,8],[1,7,1,8],[9,0,11,8],[13,0,13,2],[13,3,13,8],[6,0,6,8],[7,0,7,8]]}
[]
[]
[]
[]
[]
[]
["               Oznámenie o prerušení dodávky vody z verejného vodovodu "]
["pre obyvateľov"]
[]
["                 Bratislavská vodárenská spoločnosť, a.s. ako prevádzkovateľ verejného vodovodu a v zmysle Zákona č.442/2002 Z.z. o verejných vodovodoch a verejných kanalizáciách, §32 ods.1 bod b), Vám oznamuje prerušenie dodávky vody z verejného vodovodu z dôvodu neplánovanej opravy poruchy verejného vodovodu."]
[]
[]
[]
["Miesto prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B3),\" \",'Zápis údajov'!B3)","v":"Kopčianska ul."}]
["Oblasť bez vody:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B4),\" \",'Zápis údajov'!B4)","v":"Kopčianska ul."}]
["Plánovaný začiatok prerušenia: ",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B5),\" \",'Zápis údajov'!B5)","v":"07.07.2020 od 8:00 hod."}]
["Plánovaný čas ukončenia prerušenia:",null,null,{"$f":"IF(ISBLANK('Zápis údajov'!B6),\" \",'Zápis údajov'!B6)","v":"07.07.2020 do 16:00 hod."}]
["Náhradné zásobovanie pitnou vodou:",null,null,{"$f":"'Zápis údajov'!B7","v":"áno"}]
["Spôsob a miesto náhradného zásobovania :",null,null,{"$f":"'Zápis údajov'!B8","v":"cisterna s pitnou vodou"}]
["Doplňujúce informácie:",null,null,{"$f":"'Zápis údajov'!B9","v":"Dovoľujeme si požiadať odberateľov v dotknutej oblasti o kontrolu vodovodných uzáverov vo svojich nehnuteľnostiach a v prípade potreby si pripraviť primerané zásoby vody."}]
[]
["                 Za spôsobené komplikácie sa Vám ospravedlňujeme. Oprava daného úseku verejného vodovodu je potrebná z dôvodu poruchovej udalosti, ako aj z dôvodu zabezpečenia požadovanej kvality pitnej vody. V prípade akýchkoľvek problémov s dodávkou pitnej vody, môžete kontaktovať poruchový dispečing BVS, a.s. s 24-hodinovou prevádzkou na bezplatnom telefónnom čísle 0800 121 333."]
[]
[]
[]
[]
[null,"Ďakujeme za pochopenie a ostávame s pozdravom."]
[]
[]
[]
[]
[null,null,null,null,null,"Ing. Michal Dušanič"]
[null,null,null,null,null,"vedúci divízie distribúcie vody"]
[]
[]
[]
[]
["Na vedomie:"]
["Obec"]

{"sheet":"BA počty","index":9,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Bratislava",null,"Počet "]
["Zoznam ukazovateľov","Skratka","inšpekčný","zberače","DOOV","spolu"]
["Rozpustené látky pri 105 °C","RL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C3+D3+E3","v":{"$error":"#REF!"}}]
["Nerozpustené látky pri 105 °C","NL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C4+D4+E4","v":{"$error":"#REF!"}}]
["Reakcia vody","pH",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chemická spotreba kyslíka dvojchromanom","CHSK-Cr",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Povrchovo aktívne látky aniónové","PAL-A",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nepolárne extrahovateľné látky IČ","NEL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Biologická spotreba kyslíka - s potlačením nitrifikácie","BSK5(ATM)",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky IČ","EL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový fosfor","Pc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový dusík","Nc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Ortuť","Hg",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Meď","Cu",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm VI","Cr6+",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm celkový","Crcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Olovo","Pb",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Arzén","As",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kadmium","Cd",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nikel","Ni",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Zinok","Zn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kyanidy celkové","CNcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Adsorbovateľné, organicky viazané halogény","AOX",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Propylénglykol","Propylénglykol",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Cín","Sn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Železo","Fe",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Amoniakálny dusík","N-NH4",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusitanový dusík","N-NO2",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusičnanový dusík","N-NO3",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky gravimetricky","EL-grav",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[{"$f":"COUNTA(A3:A35)","v":28},{"$f":"COUNTA(B3:B35)","v":28},{"$f":"SUM(C3:C35)","v":{"$error":"#REF!"}},{"$f":"SUM(D3:D35)","v":{"$error":"#REF!"}},{"$f":"SUM(E3:E35)","v":{"$error":"#REF!"}},{"$f":"SUM(F3:F35)","v":{"$error":"#REF!"}}]
[]
[null,"Počet odberov","Cena","Počet ukazovateľov"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C36","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"D36","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"E36","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B39:B41)","v":{"$error":"#REF!"}},{"$f":"SUM(C39:C41)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Producenti inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"KBV","BV","24Z"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B48:B50)","v":{"$error":"#REF!"}},{"$f":"SUM(C48:C50)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(B51:D51)","v":{"$error":"#REF!"}}]

{"sheet":"Ext. lab.","index":10,"n_rows":51,"n_cols":3,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["P.č.","Názov","Poznámka"]
[1,"ALS Group"]
[2,"AQUASECO s.r.o."]
[3,"AQUATEST a.s."]
[4,"BVS a.s."]
[5,"Ekolab s.r.o."]
[6,"Eurofins Bel/Novamann s.r.o.","8.10.2014 stanovuje: NEL IČ aj NEL UV, EL IČ aj EL UV, BSK5(ATM) uvádzajú aj v protokole,"]
[7,"Chemický ústav SAV"]
[8,"Chempal"]
[9,"INGEO-ENVILAB s.r.o."]
[10,"Labeko s.r.o."]
[11,"Monitoring s.r.o."]
[12,"Slovenský vodohos.podnik, š.p., Bratislava"]
[13,"Úrad verejného zdravotníctva SR"]
[14,"Slovenský vodohos.podnik, š.p., Piešťany"]
[15,"VÚRUP a.s."]
[16,"VÚVH"]
[17,"Výskumný ústav zváračský"]
[18,"MND a.s."]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]

{"sheet":"Porovnanie","index":11,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":true,"merged":[]}
["BVS"]
["Prietok","Prietok","Ukazovateľ / Koeficient znečistenia","Ukazovateľ / Koeficient znečistenia","Ukazovateľ / Koeficient znečistenia"]
["l/s","l/s","CHSKCr, BSK5, NEL IČ, ťažké kovy","pH","ostatné"]
[0,5,0.08,6.5000000000000002E-2,0.04]
[5.0000000010000001,10,7.0000000000000007E-2,6.5000000000000002E-2,0.03]
[10.0000000001,50,0.06,6.5000000000000002E-2,0.02]
[50.000000000999997,1000000,0.05,6.5000000000000002E-2,0.01]
[]
["VVS"]
[null,null,"BSK5, NEL IČ, ťažké kovy"," CHSKCr a ostatné"," CHSKCr a ostatné"]
[0,5,0.04,0.02,0.12]
[5.0000000010000001,10,0.03,0.02,0.09]
[10.0000000001,50,0.02,0.01,0.06]
[50.000000000999997,1000000,0.02,0.01,0.06]
[]
["Tatry"]
["Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie koncentračného limitu (Euro)","Sadzba za ďalšie % prekročenia koncentračnéholimitu ( Euro)"]
["Q <=0,2",20,"(+) 0,33Euro za každé % prekročenia"]
["0,2 <Q <=0,5",40,"(+) 0,83Euro za každé % prekročenia"]
["0,5 <Q <=1,0",65,"(+) 3,33 Euro za každé % prekročenia"]
["1,0 <Q <=2,0",100,"(+) 3,33 Euro za každé % prekročenia"]
["2,0 <Q <=5,0",165,"(+) 3,33 Euro za každé % prekročenia"]
["5,0 <Q <=10,0",330,"(+) 6,66 Euro za každé % prekročenia"]
["10,0 <Q ",500,"(+) 11,66 Euro za každé % prekročenia"]
[]
[]
["ZVS","koeficienty"]
["Prietok l/s",null,null,null,null,null,"BVS"]
[null,null,null,"pH","ostatné",null,"Ukazovateľ",null,"NEL"]
["do 5 vrátane",null,null,0.04,0.08,null,"Nameraná hodnota","N",15,"mg/l"]
["nad 5 do 10 vrátane",null,null,0.03,7.0000000000000007E-2,null,"Limitná hodnota","L",10,"mg/l"]
["nad 10 do 50 vrátane",null,null,0.02,0.06,null,"Prekročenie",null,{"$f":"I30-I31","v":5},"mg/l"]
["nad 50",null,null,0.01,0.05,null,"Percento prekročenia","P",{"$f":"((I30-I31)*100)/I31","v":50},"%"]
[]
[null,null,null,null,null,null,"Cena za odvádzanie a čistenie odpadovej vody verejnou kanalizáciou","S",0.92159999999999997,"za 1m3 bez DPH"]
[null,null,null,null,null,null,"Denná spotreba vody za sledované obdobie",null,26.562999999999999,"m3/deň",{"$f":"I36/24","v":1.1067916666666666},"m3/hod",{"$f":"K36/36","v":3.0744212962962963E-2},"l/s"]
[null,null,null,null,null,null,"Koeficient znečistenia",null,0.08,"podľa ukazovateľa z tabuľka a podľa Q"]
[null,null,null,null,null,null,"Počet dní počas ktorých došlo k prekročeniu","d",31,"dní"]
[]
[null,null,null,null,null,null,"Úhrada= Cena * Množstvo OV * %prekročenia * Počet dní * Koeficient znečistenia "]
[null,null,null,null,null,null,"Úhrada","U",{"$f":"(I35*I36*I38*I37*I33)","v":3035.5771392000001},"BVS"]
[]
[]
[null,null,null,null,null,null,"VVS"]
[null,null,null,null,null,null,"Ukazovateľ",null,"NEL"]
[null,null,null,null,null,null,"Nameraná hodnota","N",15,"mg/l"]
[null,null,null,null,null,null,"Limitná hodnota","L",10,"mg/l"]
[null,null,null,null,null,null,"Prekročenie",null,{"$f":"I46-I47","v":5},"mg/l"]
[null,null,null,null,null,null,"Percento prekročenia","P",{"$f":"((I46-I47)*100)/I47","v":50},"%"]
[]
[null,null,null,null,null,null,"Cena za odvádzanie a čistenie odpadovej vody verejnou kanalizáciou","S",0.92159999999999997,"za 1m3 bez DPH"]
[null,null,null,null,null,null,"Denná spotreba vody za sledované obdobie",null,26.562999999999999,"m3/deň",{"$f":"I52/24","v":1.1067916666666666},"m3/hod",{"$f":"K52/36","v":3.0744212962962963E-2},"l/s"]
[null,null,null,null,null,null,"Percento zmluvnej pokuty",null,4,"podľa ukazovateľa z tabuľka a podľa Q"]
[null,null,null,null,null,null,"Počet dní počas ktorých došlo k prekročeniu","d",31,"dní"]
[]
[]
[]
[null,null,null,null,null,null,"Výška stočného",null,{"$f":"I52*I54*I51","v":758.89428479999992}]
[]
[]
[]
[null,null,null,null,null,null,"Percento prekročenia",null,{"$f":"((((I46/I47)*100)-100)/2)","v":25},"%"]
[]
[]
[]
[null,null,null,null,null,null,"Úhrada","U",{"$f":"I62*(I58*I53)/100","v":758.89428479999992},"VVS"]
[]
[]
[null,null,null,null,null,null,"Tatry"]
[null,null,null,null,null,null,"Ukazovateľ",null,"NEL"]
[null,null,null,null,null,null,"Nameraná hodnota","N",15,"mg/l"]
[null,null,null,null,null,null,"Limitná hodnota","L",10,"mg/l"]
[null,null,null,null,null,null,"Prekročenie",null,{"$f":"I71-I72","v":5},"mg/l"]
[null,null,null,null,null,null,"Percento prekročenia","P",{"$f":"((I71-I72)*100)/I72","v":50},"%"]
[]
[null,null,null,null,null,null,"Cena za odvádzanie a čistenie odpadovej vody verejnou kanalizáciou","S",null,"za 1m3 bez DPH"]
[null,null,null,null,null,null,"Denná spotreba vody za sledované obdobie",null,26.562999999999999,"m3/deň",{"$f":"I77/24","v":1.1067916666666666},"m3/hod",{"$f":"K77/36","v":3.0744212962962963E-2},"l/s"]
[null,null,null,null,null,null,"Koeficient znečistenia",null,null,"podľa ukazovateľa z tabuľka a podľa Q"]
[null,null,null,null,null,null,"Počet dní počas ktorých došlo k prekročeniu","d",null,"dní"]
[]
[null,null,null,null,null,null,"Sadzba za prekročenie bilančného limitu (Euro)",null,20,"údaj z tabuľky"]
[null,null,null,null,null,null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",null,0.33,"údaj z tabuľky"]
[]
[null,null,null,null,null,null,"Úhrada","U",{"$f":"I81+(I82*I74)","v":36.5},"Tatry","nemajú určené presne"]
[]
[]
[null,null,null,null,null,null,"ZVS"]
[null,null,null,null,null,null,"Ukazovateľ",null,"NEL"]
[null,null,null,null,null,null,"Nameraná hodnota","N",15,"mg/l"]
[null,null,null,null,null,null,"Limitná hodnota","L",10,"mg/l"]
[null,null,null,null,null,null,"Prekročenie",null,{"$f":"I89-I90","v":5},"mg/l"]
[null,null,null,null,null,null,"Percento prekročenia","P",{"$f":"((I89-I90)*100)/I90","v":50},"%"]
[]
[null,null,null,null,null,null,"Cena za odvádzanie a čistenie odpadovej vody verejnou kanalizáciou","S",0.92159999999999997,"za 1m3 bez DPH"]
[null,null,null,null,null,null,"Povolené denné množstvo OV asi zo Zmluvy",null,26.562999999999999,"m3/deň",{"$f":"I95/24","v":1.1067916666666666},"m3/hod",{"$f":"K95/36","v":3.0744212962962963E-2},"l/s"]
[null,null,null,null,null,null,"Koeficient znečistenia",null,0.08,"podľa ukazovateľa z tabuľka a podľa Q"]
[null,null,null,null,null,null,"Počet dní počas ktorých došlo k prekročeniu","d",31,"dní"]
[]
[]
[null,null,null,null,null,null,"Úhrada= Cena * Množstvo OV * %prekročenia * Počet dní * Koeficient znečistenia "]
[null,null,null,null,null,null,"Úhrada","U",{"$f":"I94*I95*I96*I97*I92","v":3035.5771392000001},"ZVS"]

{"sheet":"MO počty","index":12,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Modra",null,"Počet "]
["Zoznam ukazovateľov","Skratka","inšpekčný","zberače","DOOV","spolu"]
["Rozpustené látky pri 105 °C","RL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C3+D3+E3","v":{"$error":"#REF!"}}]
["Nerozpustené látky pri 105 °C","NL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C4+D4+E4","v":{"$error":"#REF!"}}]
["Reakcia vody","pH",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chemická spotreba kyslíka dvojchromanom","CHSK-Cr",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Povrchovo aktívne látky aniónové","PAL-A",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nepolárne extrahovateľné látky IČ","NEL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Biologická spotreba kyslíka - s potlačením nitrifikácie","BSK5(ATM)",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky IČ","EL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový fosfor","Pc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový dusík","Nc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Ortuť","Hg",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Meď","Cu",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm VI","Cr6+",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm celkový","Crcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Olovo","Pb",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Arzén","As",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kadmium","Cd",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nikel","Ni",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Zinok","Zn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kyanidy celkové","CNcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Adsorbovateľné, organicky viazané halogény","AOX",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Propylénglykol","Propylénglykol",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Cín","Sn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Železo","Fe",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Amoniakálny dusík","N-NH4",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusitanový dusík","N-NO2",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusičnanový dusík","N-NO3",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky gravimetricky","EL-grav",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[{"$f":"COUNTA(A3:A35)","v":28},{"$f":"COUNTA(B3:B35)","v":28},{"$f":"SUM(C3:C35)","v":{"$error":"#REF!"}},{"$f":"SUM(D3:D35)","v":{"$error":"#REF!"}},{"$f":"SUM(E3:E35)","v":{"$error":"#REF!"}},{"$f":"SUM(F3:F35)","v":{"$error":"#REF!"}}]
[]
[null,"Počet odberov","Cena","Počet ukazovateľov"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C36","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"D36","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"E36","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B39:B41)","v":{"$error":"#REF!"}},{"$f":"SUM(C39:C41)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Producenti inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"KBV","BV","24Z"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B48:B50)","v":{"$error":"#REF!"}},{"$f":"SUM(C48:C50)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(B51:D51)","v":{"$error":"#REF!"}}]

{"sheet":"SE počty","index":13,"n_rows":51,"n_cols":6,"rows_kept":51,"cut":false,"hidden":true,"merged":[]}
["Senica",null,"Počet "]
["Zoznam ukazovateľov","Skratka","inšpekčný","zberače","DOOV","spolu"]
["Rozpustené látky pri 105 °C","RL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C3+D3+E3","v":{"$error":"#REF!"}}]
["Nerozpustené látky pri 105 °C","NL-105",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C4+D4+E4","v":{"$error":"#REF!"}}]
["Reakcia vody","pH",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chemická spotreba kyslíka dvojchromanom","CHSK-Cr",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Povrchovo aktívne látky aniónové","PAL-A",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nepolárne extrahovateľné látky IČ","NEL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Biologická spotreba kyslíka - s potlačením nitrifikácie","BSK5(ATM)",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky IČ","EL-IČ",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový fosfor","Pc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Celkový dusík","Nc",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Ortuť","Hg",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Meď","Cu",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm VI","Cr6+",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Chróm celkový","Crcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Olovo","Pb",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Arzén","As",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kadmium","Cd",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Nikel","Ni",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Zinok","Zn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Kyanidy celkové","CNcelk.",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Adsorbovateľné, organicky viazané halogény","AOX",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Propylénglykol","Propylénglykol",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Cín","Sn",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Železo","Fe",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Amoniakálny dusík","N-NH4",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusitanový dusík","N-NO2",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Dusičnanový dusík","N-NO3",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
["Extrahovateľné látky gravimetricky","EL-grav",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[{"$f":"COUNTA(A3:A35)","v":28},{"$f":"COUNTA(B3:B35)","v":28},{"$f":"SUM(C3:C35)","v":{"$error":"#REF!"}},{"$f":"SUM(D3:D35)","v":{"$error":"#REF!"}},{"$f":"SUM(E3:E35)","v":{"$error":"#REF!"}},{"$f":"SUM(F3:F35)","v":{"$error":"#REF!"}}]
[]
[null,"Počet odberov","Cena","Počet ukazovateľov"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"C36","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"D36","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"E36","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B39:B41)","v":{"$error":"#REF!"}},{"$f":"SUM(C39:C41)","v":{"$error":"#REF!"}},{"$error":"#REF!"}]
[]
["Producenti inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[]
[]
[null,"KBV","BV","24Z"]
["BVS inšpekčný monitoring",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["BVS zberače",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
["Špecifické požiadavky DOOV",{"$f":"SUMIFS(#REF!,#REF!,$B$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$C$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}},{"$f":"SUMIFS(#REF!,#REF!,$D$47,#REF!,$A$1,#REF!,\"M\")","v":{"$error":"#REF!"}}]
[null,{"$f":"SUM(B48:B50)","v":{"$error":"#REF!"}},{"$f":"SUM(C48:C50)","v":{"$error":"#REF!"}},{"$error":"#REF!"},{"$f":"SUM(B51:D51)","v":{"$error":"#REF!"}}]

{"sheet":"Hárok2","index":14,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":true,"merged":[]}
[null,"Podtatranská"]
[]
[null,"Počet pracovných dní v týždni",null,5,"v roku",{"$f":"D3*52","v":260}]
[]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:"]
[]
[null,"a) komunálne OV","Prietok",1056,"m3/rok",{"$f":"D7/F3","v":4.0615384615384613},"m3/deň",{"$f":"F7/24","v":0.16923076923076921},"m3/hod",{"$f":"(H7/3600)*1000","v":4.7008547008547001E-2},"lit/sek"]
[null,null,"Prietok",4.7010000000000003E-2,"lit/sek",{"$f":"(D8*3600)/1000","v":0.16923600000000003},"m3/hod",{"$f":"F8*24","v":4.0616640000000004},"m3/deň",{"$f":"H8*F3","v":1056.0326400000001},"m3/rok"]
[]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit"]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok"]
[null,"BSK5",200,400,{"$f":"C12*$F$7*(1/1000)","v":0.81230769230769229},{"$f":"C12*$D$7*(1/1000000)","v":0.2112}]
[null,"CHSKCr",300,600,{"$f":"C13*$F$7*(1/1000)","v":1.2184615384615383},{"$f":"C13*$D$7*(1/1000000)","v":0.31679999999999997}]
[null,"NL",100,150,0.40615384615384614,0.1056]
[null,"RL",600,900,2.4369230769230765,0.63359999999999994]
[null,"Extrahovateľné látky",40,55,0.16246153846153846,4.224E-2]
[null,"PAL- A",7,10,2.8430769230769228E-2,7.3919999999999993E-3]
[]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Ukazovateľ","BSK5"]
[null,"Priemerná koncentrácia ",200,"mg/l","priemerná ročná koncentrácia"]
[null,"Množstvo OV",1056,"m3/rok","za rok"]
[]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":0.2112},"ton/rok"]

{"sheet":"Fosfor","index":15,"n_rows":65,"n_cols":29,"rows_kept":65,"cut":false,"hidden":true,"merged":[]}
[null,"Rajo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.01.2014",8.83,null,9.5299999999999994,null,{"$f":"IF(ISBLANK(AA1),\" \",Y1-AA1)","v":-0.69999999999999929}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prietok OV, ziastené za rok (l/s)","Sadzba za prekročenie bilančného limitu (Euro)","Sadzba za ďalšie % prekročenia bilančného limitu ( Euro)",null,null,null,null,null,null,null,"13.01.2014",6.19,null,7.65,null,{"$f":"IF(ISBLANK(AA2),\" \",Y2-AA2)","v":-1.46}]
[null,"Počet pracovných dní v týždni",null,null,"v roku",365,null,null,null,null,null,null,null,"Q <=0,2",53,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"20.01.2014",8.9700000000000006,null,6.9,null,2.0700000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0,2 <Q <=0,5",106,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"27.01.2014",10.199999999999999,null,12.1,null,-1.9000000000000004]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:",null,null,null,null,null,null,null,null,null,null,null,"0,5 <Q <=1,0",159,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.02.2014",13.7,null,14,null,-0.30000000000000071]
[null,null,null,"zmluva",null,null,null,null,null,null,null,null,null,"1,0 <Q <=2,0",212,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"12.02.2014",9.4,null,9.25,null,0.15000000000000036]
[null,"a) komunálne OV","Prietok",578843,"m3/rok",{"$f":"D7/F3","v":1585.8712328767124},"m3/deň",{"$f":"F7/24","v":66.077968036529683},"m3/hod",{"$f":"(H7/3600)*1000","v":18.354991121258244},"lit/sek",null,null,"2,0 <Q <=5,0",265,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"17.02.2014",6.49,null,6.55,null,-5.9999999999999609E-2]
[null,null,"Prietok",18.355,"lit/sek",{"$f":"(D8*3600)/1000","v":66.078000000000003},"m3/hod",{"$f":"F8*24","v":1585.8720000000001},"m3/deň",{"$f":"H8*F3","v":578843.28},"m3/rok",null,null,"5,0 <Q <=10,0",664,"(+) 6,64 Euro za každé % prekročenia",null,null,null,null,null,null,null,"24.02.2014",10.6,null,10.9,null,-0.30000000000000071]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",1328,"(+) 13,28 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.03.2014",15.1,null,15.5,null,-0.40000000000000036]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.03.2014",27.2,null,13,null,14.2]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.03.2014",9.33,null,10,null,-0.66999999999999993]
[null,"Pc",16.100000000000001,50,{"$f":"C12*$F$7*(1/1000)","v":25.532526849315072},{"$f":"C12*$D$7*(1/1000000)","v":9.3193722999999995},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"24.03.2014",15.3,null,15.5,null,-0.19999999999999929]
[null,"Pc",15,50,{"$f":"C13*$F$7*(1/1000)","v":23.788068493150686},{"$f":"C13*$D$7*(1/1000000)","v":8.6826449999999991},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.04.2014",19.7,null,22.6,null,-2.9000000000000021]
[null,"Pc",7.5,15,11.894034246575343,4.3413224999999995,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09.04.2014",37.700000000000003,null,29.7,null,8.0000000000000036]
[null,"RL",200,900,317.17424657534252,115.76859999999999,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.04.2014",14,null,14.3,null,-0.30000000000000071]
[null,"Extrahovateľné látky",null,55,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21.04.2014",10.199999999999999,null,10,null,0.19999999999999929]
[null,"PAL- A",null,10,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28.04.2014",10.5,null,7.7,null,2.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05.05.2014",19.8,null,21.3,null,-1.5]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.05.2014",22.9,null,25.8,null,-2.9000000000000021]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.05.2014",24.6,null,25.8,null,-1.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.05.2014",16.8,null,18.3,null,-1.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.06.2014",22.8,null,28,null,-5.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.06.2014",12.7,null,14.7,null,-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.06.2014",7.57,null,7.5,null,7.0000000000000284E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.06.2014",10.8,null,11.6,null,-0.79999999999999893]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.07.2014",7,null,8.8000000000000007,null,-1.8000000000000007]
[null,"Vlož Bilančný limit pre sledovaný ukazovateľ",null,null,8.68,"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07.07.2014",14.5,null,12.2,null,2.3000000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.07.2014",13.9,null,15,null,-1.0999999999999996]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21.07.2014",8.09,null,10.9,null,-2.8100000000000005]
[null,"Ukazovateľ","Pc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28.07.2014",9.7899999999999991,null,12.6,null,-2.8100000000000005]
[null,"Priemerná koncentrácia ",16.100000000000001,"mg/l","priemerná ročná koncentrácia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05.08.2014",8.26,null,9.1,null,-0.83999999999999986]
[null,"Množstvo OV",578856,"m3/rok","za rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"12.08.2014",5.14,null,6,null,-0.86000000000000032]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.08.2014",11.2,null,13.4,null,-2.2000000000000011]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":9.3195816000000011},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25.08.2014",13.1,null,18.100000000000001,null,-5.0000000000000018]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.09.2014",21.7,null,24.2,null,-2.5]
[null,"Výpočet úhrady za prekročenie bilančného limitu",null,null,{"$f":"IF($C$34<E27,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Počíta sa úhrada za prekročenie bilančného limitu"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09.09.2014",26.1,null,29.7,null,-3.5999999999999979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.09.2014",19.100000000000001,null,21.8,null,-2.6999999999999993]
[null,"Prekročenie bilančného limitu",null,null,{"$f":"IF(C34>E27,ABS(C34-E27), \" \")","v":0.63958160000000142},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E38)/E27","v":7.3684516129032422},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.09.2014",17.2,null,22.3,null,-5.1000000000000014]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29.09.2014",25.1,null,29.7,null,-4.5999999999999979]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Prietok ",18.350000000000001,"l/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.10.2014",10.9,null,12,null,-1.0999999999999996]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",1328,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.10.2014",16.3,null,18.899999999999999,null,-2.5999999999999979]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",13.28,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22.10.2014",22.3,null,27.5,null,-5.1999999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.10.2014",8.84,null,9.5,null,-0.66000000000000014]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$43+($C$44*$E$39)","v":1425.8530374193551},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.11.2014",20.9,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.11.2014",15.3,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.11.2014",12,null,null,null," "]
[null,"BVS"]
[null,"Dáta zo zmluvy",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priemer",{"$f":"AVERAGE(Y1:Y48)","v":14.741304347826086},{"$f":"SUM(Y1:Y48)","v":678.09999999999991},{"$f":"AVERAGE(AA1:AA48)","v":15.57860465116279}]
[null,"Ukazovateľ","Pc",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(Y1:Y48)","v":46}]
[null,"Bilančný limit",8.68,"t/rok","limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z50/Z51","v":14.741304347826086}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"spolu",{"$f":"AVERAGE(Y1:AA48)","v":15.145842696629213}]
[null,"Dáta za kalendárny rok"]
[null,"Ukazovateľ","Pc"]
[null,"Nameraná koncentrácia ",25,"mg/l",{"$f":"C56*C57*(1/1000000)","v":14.471399999999999},"ton/rok"]
[null,"Množstvo OV",578856,"m3/rok",{"$f":"C57/F3","v":1585.9068493150685},"m3/deň",{"$f":"E57/24","v":66.079452054794515},"m3/hod",{"$f":"(G57/3600)*1000","v":18.355403348554031},"lit/sek"]
[]
[null,"Prekročenie bilančný limit",{"$f":"(E56-C52)","v":5.7913999999999994},"t/rok",{"$f":"(100*C59)/C52","v":66.721198156682021},"%"]
[]
[null,"Koeficient ako %",0.04,"na základe prietoku zo zmluvy"]
[null,"Stočné",0.92159999999999997,"Euro/m3"]
[null,"Počet dní prekročenia",365]
[]
[null,"Úhrada koncentrácia",{"$f":"C61*E57*C61*E59*C63","v":61795.145408294928}]

{"sheet":"ZVS","index":16,"n_rows":57,"n_cols":7,"rows_kept":57,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Producent môže vypúšťať OV do VK v maximálnom množstve podľa jednotlivých zdrojov:"]
[null,"Označenie zdroja ",null,"m3/rok","m3/deň","l/s"]
[null,"Verejný vodovod","áno",300,{"$f":"D4/365","v":0.82191780821917804},{"$f":"(E4/(24*60*60))*1000","v":9.5129375951293754E-3},"ide do výpočtu bilančných limitov"]
[null,"Iné (vlastné )zdroje vody","nie",null,{"$f":"D5/365","v":0},{"$f":"(E5/(24*60*60))*1000","v":0}]
[null,"Vody z povrchového odtoku","áno",1733,4.7479452054794518,5.4953069507864022E-2]
[null,"Celkom",null,{"$f":"SUM(D4:D6)","v":2033},{"$f":"SUM(E4:E6)","v":5.5698630136986296},6.4466007102993397E-2]
[]
[null,"Limitné hodnoty znečistenia vo vypúšťaných OV:"]
[null,"Ukazovateľ","od","do"]
[null,"pH",6,9]
[null,null,"mg/l","max. mg/l","g/s","kg/deň","t/rok"]
[null,"CHSKCr",0,800,{"$f":"$F$4*(D13/1000)","v":7.6103500761035003E-3},{"$f":"$E$4*D13*(1/1000)","v":0.65753424657534243},{"$f":"$D$4*D13*(1/1000000)","v":0.24}]
[null,"Nerozpustné látky 105",0,500,{"$f":"$F$4*(D14/1000)","v":4.7564687975646877E-3},{"$f":"$E$4*D14*(1/1000)","v":0.41095890410958902},{"$f":"$D$4*D14*(1/1000000)","v":0.15}]
[null,"Rozpustné látky 550",0,1200,1.1415525114155251E-2,0.98630136986301364,0.36]
[null,"N-NH4",0,80,7.6103500761035003E-4,6.575342465753424E-2,2.4E-2]
[null,"P celk",0,15,1.4269406392694063E-4,1.2328767123287671E-2,4.4999999999999997E-3]
[null,"Tuky",0,60,5.7077625570776253E-4,4.9315068493150684E-2,1.7999999999999999E-2]
[null,"NEL",0,10,9.5129375951293754E-5,8.21917808219178E-3,3.0000000000000001E-3]
[]
[]
[]
[]
[]
[]
[null,"ZVS","koeficienty"]
[null,"Prietok l/s"]
[null,null,null,null,"pH","ostatné"]
[null,"do 5 vrátane",null,null,0.04,0.08]
[null,"nad 5 do 10 vrátane",null,null,0.03,7.0000000000000007E-2]
[null,"nad 10 do 50 vrátane",null,null,0.02,0.06]
[null,"nad 50",null,null,0.01,0.05]
[]
[]
[]
[]
[]
[]
[null,"Dáta zo Zmluvy"]
[null,"Množstvo OV",0.82,"kg/deň","zo Zmluvy"]
[null,"Ukazovateľ","CHSKCr"]
[null,"Max. Limitná koncentrácia ",800,"mg/l","limit"]
[null,"Bilančný limit",0.24,"t/rok","limit"]
[]
[null,"Namerané dáta "]
[null,"Ukazovateľ","CHSKCr"]
[null,"Nameraná koncentrácia ",950,"mg/l",{"$f":"C47*D4*(1/1000000)","v":0.28499999999999998},"ton/rok"]
[]
[null,"Prekročenie konc. Limit",{"$f":"IF(C47>C42,ABS(C47-C42), \" \")","v":150},"mg/l",{"$f":"(100*C49)/C42","v":18.75},"%"]
[null,"Prekročenie bilančný limit",{"$f":"IF(E47>C43,ABS(E47-C43), \" \")","v":4.4999999999999984E-2},"t/rok",{"$f":"(100*C50)/C43","v":18.749999999999993},"%"]
[]
[null,"Koeficient ako %",0.08,"na základe prietoku zo zmluvy"]
[null,"Stočné",0.92159999999999997,"Euro/m3"]
[null,"Počet dní prekročenia",30]
[]
[null,"Úhrada koncentrácia",{"$f":"C53*C40*C52*E49*C54","v":34.007039999999996},null,"ZVS má rovnaký spôsob výpočtu úhrady za zvýšený koncentračný limit"]
[null,"Úhrada bilancia",{"$f":"C53*C40*C52*E50*C54","v":34.007039999999982}]

{"sheet":"Tatry","index":17,"n_rows":68,"n_cols":27,"rows_kept":68,"cut":false,"hidden":true,"merged":[]}
[null,"Rajo",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.01.2014",8.83,null,9.5299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie bilančného limitu (Euro)","Sadzba za ďalšie % prekročenia bilančného limitu ( Euro)",null,null,null,null,null,null,null,"13.01.2014",6.19,null,7.65]
[null,"Počet pracovných dní v týždni",null,5,"v roku",{"$f":"D3*52","v":260},null,null,null,null,null,null,null,"Q <=0,2",53,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"20.01.2014",8.9700000000000006,null,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0,2 <Q <=0,5",106,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"27.01.2014",10.199999999999999,null,12.1]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:",null,null,null,null,null,null,null,null,null,null,null,"0,5 <Q <=1,0",159,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.02.2014",13.7,null,14]
[null,null,null,"zmluva",null,null,null,null,null,null,null,null,null,"1,0 <Q <=2,0",212,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"12.02.2014",94,null,9.25]
[null,"a) komunálne OV","Prietok",1056,"m3/rok",{"$f":"D7/F3","v":4.0615384615384613},"m3/deň",{"$f":"F7/24","v":0.16923076923076921},"m3/hod",{"$f":"(H7/3600)*1000","v":4.7008547008547001E-2},"lit/sek",null,null,"2,0 <Q <=5,0",265,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"17.02.2014",6.49,null,6.55]
[null,null,"Prietok",4.7010000000000003E-2,"lit/sek",{"$f":"(D8*3600)/1000","v":0.16923600000000003},"m3/hod",{"$f":"F8*24","v":4.0616640000000004},"m3/deň",{"$f":"H8*F3","v":1056.0326400000001},"m3/rok",null,null,"5,0 <Q <=10,0",664,"(+) 6,64 Euro za každé % prekročenia",null,null,null,null,null,null,null,"24.02.2014",10.6,null,10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",1328,"(+) 13,28 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.03.2014",15.1,null,15.5]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.03.2014",27.2,null,13]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok",null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie koncentračného limitu (Euro)","Sadzba za ďalšie % prekročenia koncentračnéholimitu ( Euro)",null,null,null,null,null,null,null,"17.03.2014",9.33,null,10]
[null,"BSK5",200,400,{"$f":"C12*$F$7*(1/1000)","v":0.81230769230769229},{"$f":"C12*$D$7*(1/1000000)","v":0.2112},null,null,null,null,null,null,null,"Q <=0,2",20,"(+) 0,33Euro za každé % prekročenia",null,null,null,null,null,null,null,"24.03.2014",15.3,null,15.5]
[null,"CHSK",300,600,{"$f":"C13*$F$7*(1/1000)","v":1.2184615384615383},{"$f":"C13*$D$7*(1/1000000)","v":0.31679999999999997},null,null,null,null,null,null,null,"0,2 <Q <=0,5",40,"(+) 0,83Euro za každé % prekročenia",null,null,null,null,null,null,null,"02.04.2014",19.7,null,22.6]
[null,"Nerozpustené látky",100,150,0.40615384615384614,0.1056,null,null,null,null,null,null,null,"0,5 <Q <=1,0",65,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"09.04.2014",37.700000000000003,null,29.7]
[null,"RL",600,900,2.4369230769230765,0.63359999999999994,null,null,null,null,null,null,null,"1,0 <Q <=2,0",100,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"14.04.2014",14,null,14.3]
[null,"Extrahovateľné látky",40,55,0.16246153846153846,4.224E-2,null,null,null,null,null,null,null,"2,0 <Q <=5,0",165,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"21.04.2014",10.199999999999999,null,10]
[null,"PAL- A",7,10,2.8430769230769228E-2,7.3919999999999993E-3,null,null,null,null,null,null,null,"5,0 <Q <=10,0",330,"(+) 6,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,"28.04.2014",10.5,null,7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",500,"(+) 11,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,"05.05.2014",19.8,null,21.3]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.05.2014",22.9,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.05.2014",24.6,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.05.2014",16.8,null,18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.06.2014",22.8,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.06.2014",12.7,null,14.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.06.2014",7.57,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.06.2014",10.8,null,11.6]
[null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.07.2014",7,null,8.8000000000000007]
[null,"Vlož Bilančný limit pre sledovaný ukazovateľ",null,null,0.2112,"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07.07.2014",14.5,null,12.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.07.2014",13.9,null,15]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21.07.2014",8.09,null,10.9]
[null,"Ukazovateľ","BSK5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28.07.2014",9.7899999999999991,null,12.6]
[null,"Priemerná koncentrácia ",250,"mg/l","priemerná ročná koncentrácia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05.08.2014",8.26,null,9.1]
[null,"Množstvo OV",1000,"m3/rok","za rok",{"$f":"C32/F3","v":3.8461538461538463},"m3/deň",{"$f":"F32/24","v":0.16025641025641027},"m3/hod",{"$f":"(H32/3600)*1000","v":4.4515669515669515E-2},"lit/sek",null,null,null,null,null,null,null,null,null,null,null,null,"12.08.2014",5.14,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.08.2014",11.2,null,13.4]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":0.25},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25.08.2014",13.1,null,18.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.09.2014",21.7,null,24.2]
[null,"Výpočet úhrady za prekročenie bilančného limitu",null,null,{"$f":"IF($C$34<E27,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Počíta sa úhrada za prekročenie bilančného limitu"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09.09.2014",26.1,null,29.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.09.2014",19.100000000000001,null,21.8]
[null,"Prekročenie bilančného limitu",null,null,{"$f":"IF(C34>E27,ABS(C34-E27), \" \")","v":3.8800000000000001E-2},"ton/rok"]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E38)/E27","v":18.371212121212121},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.09.2014",17.2,null,22.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29.09.2014",25.1,null,29.7]
[]
[null,"Prietok ",4.4499999999999998E-2,"l/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.10.2014",10.9,null,12]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",53,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.10.2014",16.3,null,18.899999999999999]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",2.68,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22.10.2014",22.3,null,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.10.2014",8.84,null,9.5]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$43+($C$44*$E$39)","v":102.23484848484848},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.11.2014",20.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.11.2014",15.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.11.2014",12]
[null,"Koncentračný limit"]
[null,"Vlož koncentračný limit pre sledovaný ukazovateľ",null,null,600,"mg/l",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Priemer",{"$f":"AVERAGE(Y1:Y48)","v":16.580434782608698},{"$f":"SUM(Y1:Y48)","v":762.7},{"$f":"AVERAGE(AA1:AA48)","v":15.57860465116279}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNT(Y1:Y48)","v":46}]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Z50/Z51","v":16.580434782608698}]
[null,"Ukazovateľ","CHSK"]
[null,"Priemerná koncentrácia ",650,"mg/l","priemerná ročná koncentrácia"]
[null,"Množstvo OV",null,"m3/rok","za rok"]
[]
[]
[null,"Výpočet úhrady za prekročenie koncentračného limitu",null,null,{"$f":"IF($C$54<E50,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Počíta sa úhrada za prekročenie bilančného limitu"}]
[]
[null,"Prekročenie koncentrančného limitu",null,null,{"$f":"IF(C54>E50,ABS(C54-E50), \" \")","v":50}]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E60)/E50","v":8.3333333333333339},"%"]
[]
[]
[null,"Prietok ",4.7010000000000003E-2,"l/s"]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",20,"údaj z tabuľky"]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",0.33,"údaj z tabuľky"]
[]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$65+($C$66*$E$61)","v":22.75}]

{"sheet":"BVS bilancia","index":18,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[null,"BVS","MVN",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.01.2014",8.83,null,9.5299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie bilančného limitu (Euro)","Sadzba za ďalšie % prekročenia bilančného limitu ( Euro)",null,null,null,null,null,null,null,"13.01.2014",6.19,null,7.65]
[null,"Počet pracovných dní v týždni",null,5,"v roku",365,null,null,null,null,null,null,null,"Q <=0,2",53,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"20.01.2014",8.9700000000000006,null,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0,2 <Q <=0,5",106,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"27.01.2014",10.199999999999999,null,12.1]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:",null,null,null,null,null,null,null,null,null,null,null,"0,5 <Q <=1,0",159,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.02.2014",13.7,null,14]
[null,null,null,"zmluva",null,null,null,null,null,null,null,null,null,"1,0 <Q <=2,0",212,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"12.02.2014",94,null,9.25]
[null,"a) komunálne OV","Prietok",4500,"m3/rok",{"$f":"D7/F3","v":12.328767123287671},"m3/deň",{"$f":"F7/24","v":0.51369863013698625},"m3/hod",{"$f":"(H7/3600)*1000","v":0.14269406392694062},"lit/sek",null,null,"2,0 <Q <=5,0",265,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,"17.02.2014",6.49,null,6.55]
[null,null,"Prietok",0.3044,"lit/sek",{"$f":"(D8*3600)/1000","v":1.0958399999999999},"m3/hod",{"$f":"F8*24","v":26.300159999999998},"m3/deň",{"$f":"H8*F3","v":9599.5583999999999},"m3/rok",null,null,"5,0 <Q <=10,0",664,"(+) 6,64 Euro za každé % prekročenia",null,null,null,null,null,null,null,"24.02.2014",10.6,null,10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",1328,"(+) 13,28 Euro za každé % prekročenia",null,null,null,null,null,null,null,"03.03.2014",15.1,null,15.5]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"10.03.2014",27.2,null,13]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok",null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie koncentračného limitu (Euro)","Sadzba za ďalšie % prekročenia koncentračnéholimitu ( Euro)",null,null,null,null,null,null,null,"17.03.2014",9.33,null,10]
[null,"BSK5",400,750,{"$f":"C12*$F$7*(1/1000)","v":4.9315068493150687},{"$f":"C12*$D$7*(1/1000000)","v":1.7999999999999998},null,null,null,null,null,null,null,"Q <=0,2",20,"(+) 0,33Euro za každé % prekročenia",null,null,null,null,null,null,null,"24.03.2014",15.3,null,15.5]
[null,"CHSK",300,600,{"$f":"C13*$F$7*(1/1000)","v":3.6986301369863015},{"$f":"C13*$D$7*(1/1000000)","v":1.3499999999999999},null,null,null,null,null,null,null,"0,2 <Q <=0,5",40,"(+) 0,83Euro za každé % prekročenia",null,null,null,null,null,null,null,"02.04.2014",19.7,null,22.6]
[null,"Nerozpustené látky",100,150,1.2328767123287672,0.44999999999999996,null,null,null,null,null,null,null,"0,5 <Q <=1,0",65,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"09.04.2014",37.700000000000003,null,29.7]
[null,"RL",600,900,7.397260273972603,2.6999999999999997,null,null,null,null,null,null,null,"1,0 <Q <=2,0",100,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"14.04.2014",14,null,14.3]
[null,"Extrahovateľné látky",40,55,0.49315068493150682,0.18,null,null,null,null,null,null,null,"2,0 <Q <=5,0",165,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,"21.04.2014",10.199999999999999,null,10]
[null,"PAL- A",7,10,8.6301369863013691E-2,3.15E-2,null,null,null,null,null,null,null,"5,0 <Q <=10,0",330,"(+) 6,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,"28.04.2014",10.5,null,7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",500,"(+) 11,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,"05.05.2014",19.8,null,21.3]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.05.2014",22.9,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.05.2014",24.6,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.05.2014",16.8,null,18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.06.2014",22.8,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.06.2014",12.7,null,14.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"18.06.2014",7.57,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.06.2014",10.8,null,11.6]
[null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"02.07.2014",7,null,8.8000000000000007]
[null,"Vlož Bilančný limit pre sledovaný ukazovateľ",null,null,1.8,"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"07.07.2014",14.5,null,12.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"14.07.2014",13.9,null,15]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"21.07.2014",8.09,null,10.9]
[null,"Ukazovateľ","BSK5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"28.07.2014",9.7899999999999991,null,12.6]
[null,"Priemerná koncentrácia ",1500,"mg/l","priemerná ročná koncentrácia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"05.08.2014",8.26,null,9.1]
[null,"Množstvo OV",4500,"m3/rok","za rok",{"$f":"C32/F3","v":12.328767123287671},"m3/deň",{"$f":"F32/24","v":0.51369863013698625},"m3/hod",{"$f":"(H32/3600)*1000","v":0.14269406392694062},"lit/sek",null,null,null,null,null,null,null,null,null,null,null,null,"12.08.2014",5.14,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"19.08.2014",11.2,null,13.4]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":6.75},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"25.08.2014",13.1,null,18.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.09.2014",21.7,null,24.2]
[null,"Výpočet úhrady za prekročenie bilančného limitu",null,null,{"$f":"IF($C$34<E27,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Počíta sa úhrada za prekročenie bilančného limitu"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"09.09.2014",26.1,null,29.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.09.2014",19.100000000000001,null,21.8]
[null,"Prekročenie bilančného limitu",null,null,{"$f":"IF(C34>E27,ABS(C34-E27), \" \")","v":4.95},"ton/rok"]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E38)/E27","v":275},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"23.09.2014",17.2,null,22.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"29.09.2014",25.1,null,29.7]
[]
[null,"Prietok ",0.14000000000000001,"l/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"08.10.2014",10.9,null,12]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",53,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"15.10.2014",16.3,null,18.899999999999999]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",2.68,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22.10.2014",22.3,null,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"27.10.2014",8.84,null,9.5]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$43+($C$44*$E$39)","v":790},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"03.11.2014",20.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"11.11.2014",15.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"17.11.2014",12]
[]
[null,"BVS"]
[null,"Dáta zo zmluvy"]
[null,"Ukazovateľ","bsk5"]
[null,"Bilančný limit",1.8,"t/rok","limit"]
[]
[null,"Dáta za kalendárny rok"]
[null,"Ukazovateľ","bsk5"]
[null,"Nameraná koncentrácia ",1500,"mg/l",{"$f":"C57*C58*(1/1000000)","v":6.75},"ton/rok"]
[null,"Množstvo OV",4500,"m3/rok",{"$f":"C58/F3","v":12.328767123287671},"m3/deň",{"$f":"E58/24","v":0.51369863013698625},"m3/hod",{"$f":"(G58/3600)*1000","v":0.14269406392694062},"lit/sek"]
[]
[null,"Prekročenie bilančný limit",{"$f":"(E57-C53)","v":4.95},"t/rok",{"$f":"(100*C60)/C53","v":275},"%"]
[]
[null,"Koeficient ako %",0.08,"na základe prietoku zo zmluvy"]
[null,"Stočné",0.92159999999999997,"Euro/m3"]
[null,"Počet dní prekročenia",365]
[]
[null,"Úhrada koncentrácia",{"$f":"C62*E58*C62*E60*C64","v":7919.9999999999991},null,"ZVS má rovnaký spôsob výpočtu úhrady za zvýšený koncentračný limit"]

{"sheet":"Hotel Junior","index":19,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[null,"BVS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie bilančného limitu (Euro)","Sadzba za ďalšie % prekročenia bilančného limitu ( Euro)",null,null,null,null,null,null,null,null,null,null,7.65]
[null,"Počet pracovných dní v týždni",null,5,"v roku",365,null,null,null,null,null,null,null,"Q <=0,2",53,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0,2 <Q <=0,5",106,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,12.1]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:",null,null,null,null,null,null,null,null,null,null,null,"0,5 <Q <=1,0",159,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,"zmluva",null,null,null,null,null,null,null,null,null,"1,0 <Q <=2,0",212,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,9.25]
[null,"a) komunálne OV","Prietok",8640,"m3/rok",{"$f":"D7/F3","v":23.671232876712327},"m3/deň",{"$f":"F7/24","v":0.98630136986301364},"m3/hod",{"$f":"(H7/3600)*1000","v":0.27397260273972601},"lit/sek",null,null,"2,0 <Q <=5,0",265,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,6.55]
[null,null,"Prietok",0.27400000000000002,"lit/sek",{"$f":"(D8*3600)/1000","v":0.98640000000000005},"m3/hod",{"$f":"F8*24","v":23.6736},"m3/deň",{"$f":"H8*F3","v":8640.8639999999996},"m3/rok",null,null,"5,0 <Q <=10,0",664,"(+) 6,64 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",1328,"(+) 13,28 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,15.5]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok",null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie koncentračného limitu (Euro)","Sadzba za ďalšie % prekročenia koncentračnéholimitu ( Euro)",null,null,null,null,null,null,null,null,null,null,10]
[null,"BSK5",375,750,{"$f":"C12*$F$7*(1/1000)","v":8.8767123287671215},{"$f":"C12*$D$7*(1/1000000)","v":3.2399999999999998},null,null,null,null,null,null,null,"Q <=0,2",20,"(+) 0,33Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,15.5]
[null,"CHSK",300,600,{"$f":"C13*$F$7*(1/1000)","v":7.1013698630136979},{"$f":"C13*$D$7*(1/1000000)","v":2.5920000000000001},null,null,null,null,null,null,null,"0,2 <Q <=0,5",40,"(+) 0,83Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,22.6]
[null,"Nerozpustené látky",100,150,2.3671232876712329,0.86399999999999999,null,null,null,null,null,null,null,"0,5 <Q <=1,0",65,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,29.7]
[null,"RL",600,900,14.202739726027396,5.1840000000000002,null,null,null,null,null,null,null,"1,0 <Q <=2,0",100,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,14.3]
[null,"Extrahovateľné látky",40,55,0.94684931506849312,0.34559999999999996,null,null,null,null,null,null,null,"2,0 <Q <=5,0",165,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,10]
[null,"PAL- A",7,10,0.1656986301369863,6.0479999999999999E-2,null,null,null,null,null,null,null,"5,0 <Q <=10,0",330,"(+) 6,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",500,"(+) 11,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,21.3]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.6]
[null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8000000000000007]
[null,"Vlož Bilančný limit pre sledovaný ukazovateľ",null,null,3.24,"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.9]
[null,"Ukazovateľ","BSK5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.6]
[null,"Priemerná koncentrácia ",466,"mg/l","priemerná ročná koncentrácia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1]
[null,"Množstvo OV",8640,"m3/rok","za rok",{"$f":"C32/F3","v":23.671232876712327},"m3/deň",{"$f":"F32/24","v":0.98630136986301364},"m3/hod",{"$f":"(H32/3600)*1000","v":0.27397260273972601},"lit/sek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.4]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":4.0262399999999996},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.2]
[null,"Výpočet úhrady za prekročenie bilančného limitu",null,null,{"$f":"IF($C$34<E27,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Počíta sa úhrada za prekročenie bilančného limitu"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.8]
[null,"Prekročenie bilančného limitu",null,null,{"$f":"IF(C34>E27,ABS(C34-E27), \" \")","v":0.78623999999999938},"ton/rok"]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E38)/E27","v":24.266666666666644},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.7]
[]
[null,"Prietok ",0.26800000000000002,"l/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",106,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.899999999999999]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",2.68,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$43+($C$44*$E$39)","v":171.03466666666662}]
[]
[]
[]
[null,"BVS"]
[null,"Dáta zo zmluvy"]
[null,"Ukazovateľ","bsk5"]
[null,"Bilančný limit",3.24,"t/rok","limit"]
[]
[null,"Dáta za kalendárny rok"]
[null,"Ukazovateľ","bsk5"]
[null,"Nameraná koncentrácia ",466,"mg/l",{"$f":"C57*C58*(1/1000000)","v":4.0262399999999996},"ton/rok"]
[null,"Množstvo OV",8640,"m3/rok",{"$f":"C58/F3","v":23.671232876712327},"m3/deň",{"$f":"E58/24","v":0.98630136986301364},"m3/hod",{"$f":"(G58/3600)*1000","v":0.27397260273972601},"lit/sek"]
[]
[null,"Prekročenie bilančný limit",{"$f":"(E57-C53)","v":0.78623999999999938},"t/rok",{"$f":"(100*C60)/C53","v":24.266666666666644},"%"]
[]
[null,"Koeficient ako %",0.08,"na základe prietoku zo zmluvy"]
[null,"Stočné",0.92159999999999997,"Euro/m3"]
[null,"Počet dní prekročenia",365]
[]
[null,"Úhrada koncentrácia",{"$f":"C62*E58*C62*E60*C64","v":1341.8495999999986}]

{"sheet":"BEZ","index":20,"n_rows":66,"n_cols":27,"rows_kept":66,"cut":false,"hidden":true,"merged":[]}
[null,"BVS",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5299999999999994]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie bilančného limitu (Euro)","Sadzba za ďalšie % prekročenia bilančného limitu ( Euro)",null,null,null,null,null,null,null,null,null,null,7.65]
[null,"Počet pracovných dní v týždni",null,5,"v roku",260,null,null,null,null,null,null,null,"Q <=0,2",53,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,6.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"0,2 <Q <=0,5",106,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,12.1]
[null,"Odberateľ môže do verejnej kanalizácie vypúšťať odpadové vody v nasledujúcom maximálnom množstve:",null,null,null,null,null,null,null,null,null,null,null,"0,5 <Q <=1,0",159,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,14]
[null,null,null,"zmluva",null,null,null,null,null,null,null,null,null,"1,0 <Q <=2,0",212,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,9.25]
[null,"a) komunálne OV","Prietok",44400,"m3/rok",{"$f":"D7/F3","v":170.76923076923077},"m3/deň",{"$f":"F7/24","v":7.1153846153846159},"m3/hod",{"$f":"(H7/3600)*1000","v":1.9764957264957264},"lit/sek",null,null,"2,0 <Q <=5,0",265,"(+) 2,68 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,6.55]
[null,null,"Prietok",1.9764999999999999,"lit/sek",{"$f":"(D8*3600)/1000","v":7.1153999999999993},"m3/hod",{"$f":"F8*24","v":170.76959999999997},"m3/deň",{"$f":"H8*F3","v":44400.09599999999},"m3/rok",null,null,"5,0 <Q <=10,0",664,"(+) 6,64 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,10.9]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",1328,"(+) 13,28 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,15.5]
[null,"Ukazovateľ znečistenia","Koncentračný limit",null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13]
[null,null,"Priemerný (mg/l)","Max. (mg/l)","kg/deň","ton/rok",null,null,null,null,null,null,null,"Prietok OV, zistené za rok (l/s)","Sadzba za prekročenie koncentračného limitu (Euro)","Sadzba za ďalšie % prekročenia koncentračnéholimitu ( Euro)",null,null,null,null,null,null,null,null,null,null,10]
[null,"BSK5",375,750,{"$f":"C12*$F$7*(1/1000)","v":64.038461538461547},{"$f":"C12*$D$7*(1/1000000)","v":16.649999999999999},null,null,null,null,null,null,null,"Q <=0,2",20,"(+) 0,33Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,15.5]
[null,"CHSK",300,600,{"$f":"C13*$F$7*(1/1000)","v":51.230769230769234},{"$f":"C13*$D$7*(1/1000000)","v":13.32},null,null,null,null,null,null,null,"0,2 <Q <=0,5",40,"(+) 0,83Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,22.6]
[null,"Nerozpustené látky",100,150,17.076923076923077,4.4399999999999995,null,null,null,null,null,null,null,"0,5 <Q <=1,0",65,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,29.7]
[null,"RL",600,900,102.46153846153847,26.64,null,null,null,null,null,null,null,"1,0 <Q <=2,0",100,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,14.3]
[null,"Extrahovateľné látky",40,55,6.8307692307692305,1.776,null,null,null,null,null,null,null,"2,0 <Q <=5,0",165,"(+) 3,33 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,10]
[null,"PAL- A",7,10,1.1953846153846155,0.31079999999999997,null,null,null,null,null,null,null,"5,0 <Q <=10,0",330,"(+) 6,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,7.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"10,0 <Q ",500,"(+) 11,66 Euro za každé % prekročenia",null,null,null,null,null,null,null,null,null,null,21.3]
[null,"Výpočet prekročenia bilančných limitov vykoná dodávateľ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,25.8]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,28]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,14.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,7.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,11.6]
[null,"Bilančný limit",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8.8000000000000007]
[null,"Vlož Bilančný limit pre sledovaný ukazovateľ",null,null,16.649999999999999,"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,15]
[null,"Namerané dáta ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,10.9]
[null,"Ukazovateľ","BSK5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12.6]
[null,"Priemerná koncentrácia ",74.7,"mg/l","priemerná ročná koncentrácia",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.1]
[null,"Množstvo OV",44400,"m3/rok","za rok",{"$f":"C32/F3","v":170.76923076923077},"m3/deň",{"$f":"F32/24","v":7.1153846153846159},"m3/hod",{"$f":"(H32/3600)*1000","v":1.9764957264957264},"lit/sek",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,13.4]
[null,"Ročná bilancia",{"$f":"(C31*C32)*(1/1000000)","v":3.3166799999999999},"ton/rok",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.100000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,24.2]
[null,"Výpočet úhrady za prekročenie bilančného limitu",null,null,{"$f":"IF($C$34<E27,\"Nepočí ta sa úhrada za prekročenie bilančného limitu\",\"Počíta sa úhrada za prekročenie bilančného limitu\")","v":"Nepočí ta sa úhrada za prekročenie bilančného limitu"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.7]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,21.8]
[null,"Prekročenie bilančného limitu",null,null,{"$f":"IF(C34>E27,ABS(C34-E27), \" \")","v":" "},"ton/rok"]
[null,"Percento prekročenia bilančného limitu",null,null,{"$f":"(100*E38)/E27","v":{"$error":"#VALUE!"}},"%",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,22.3]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,29.7]
[]
[null,"Prietok ",1.9750000000000001,"l/s",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,12]
[null,"Sadzba za prekročenie bilančného limitu (Euro)",212,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,18.899999999999999]
[null,"Sadzba za ďalšie (začaté)% prekročenia bilančného limitu ( Euro)",2.68,"údaj z tabuľky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,27.5]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,9.5]
[null,"Úhrada za prekročenie bilančného limiitu",null,null,{"$f":"$C$43+($C$44*$E$39)","v":{"$error":"#VALUE!"}}]
[]
[]
[]
[null,"BVS"]
[null,"Dáta zo zmluvy"]
[null,"Ukazovateľ","bsk5"]
[null,"Bilančný limit",16.649999999999999,"t/rok","limit"]
[]
[null,"Dáta za kalendárny rok"]
[null,"Ukazovateľ","bsk5"]
[null,"Nameraná koncentrácia ",376,"mg/l",{"$f":"C57*C58*(1/1000000)","v":16.694399999999998},"ton/rok"]
[null,"Množstvo OV",44400,"m3/rok",{"$f":"C58/F3","v":170.76923076923077},"m3/deň",{"$f":"E58/24","v":7.1153846153846159},"m3/hod",{"$f":"(G58/3600)*1000","v":1.9764957264957264},"lit/sek"]
[]
[null,"Prekročenie bilančný limit",{"$f":"(E57-C53)","v":4.4399999999999551E-2},"t/rok",{"$f":"(100*C60)/C53","v":0.266666666666664},"%"]
[]
[null,"Koeficient ako %",0.08,"na základe prietoku zo zmluvy"]
[null,"Stočné",0.92159999999999997,"Euro/m3"]
[null,"Počet dní prekročenia",260]
[]
[null,"Úhrada koncentrácia",{"$f":"C62*E58*C62*E60*C64","v":75.775999999999257}]