{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Úvodní informace","Přehled změn a dodatků","List1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":9,"comments":1,"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":"Úvodní informace","index":0,"n_rows":36,"n_cols":13,"rows_kept":36,"cut":false,"hidden":false,"merged":[[34,1,34,13],[35,1,36,13],[27,1,28,13],[31,10,31,11],[0,0,2,13],[3,0,8,13],[18,2,19,13],[22,2,24,13],[11,1,11,13],[13,1,13,13],[9,1,9,13],[10,1,10,13],[12,1,12,13],[14,2,16,13]]}
["Úvodní informace k tomuto dokumentu"]
[]
[]
["Upozornění: \nTento dokument využívá funkci maker, tudíž se může jevit jako nedůvěryhodný či nebezpečný, a to v návaznosti na bezpečnostní nastavení Vašeho počítače, připadně aplikace MS Excel. Makra však můžete bez obav používat, případně jejich používání povolit - makra jsou nastavena v nezbytném rozsahu pro zjednodušení a správnou funkčnost níže uvedené tabulky. V případě technických potíží kontaktujte své IT oddělení."]
[]
[]
[]
[]
[]
["1)","Tento soubor obsahuje dva listy s názvy \"Instrukce\" a \"Přehled změn a dodatků\" (viz níže). "]
[]
["2)","Tabulka určená k doplnění je obsahem listu Přehled změn a dodatků. Tabulka vychází ze zákona č. 137/2006 Sb., o veřejných zakázkách, ve znění pozdějších předpisů (dále jen \"ZVZ\") a zákona č. 134/2016 Sb., o zadávání veřejných zakázek, ve znění pozdějších předpisů (dále jen \"ZZVZ\")."]
[]
["3)","Instrukce pro doplňování Přehledu změn a dodatků (dále jen \"Přehled\"):"]
[null,"a)","pokud bude Přehled předkládán prvně, budou v něm obsaženy aktuální (výchozí) informace o změnách a dodatcích k dotčené akci (veřejné zakázky). Pokud následně vyvstane potřeba předložit upravený Přehled, bude tento vycházet z předchozího Přehledu, přičemž bude doplněn o nové informace (tj. bude se jednat o aktualizovaný Přehled)."]
[]
[]
[null,"b)","doplňují se žlutě podbarvená pole; tato pole po výběru zobrací nápovědu,"]
[null,"c)","u buněk označených v pravém horním rohu červeným trojúhelníkem jsou uvedeny poznámky, komentáře či bližší upřesnění,"]
[]
[null,"d)","ostatní pole neslouží k doplnění (jsou doplňována automaticky, je-li to pro dané pole relevantní),"]
[null,"e)","částky budou zadávány v Kč bez daně z přidané hodnoty (DPH),"]
[null,"f)","u změnové tabulky určené k doplnění je možné vkládat nové řádky kliknutím na příslušné tlařítko s tím, že vzorce by měly být automaticky přenášeny; pro jistotu však výstupy překontrolujte. Nové řádky nevkládejte pokud není doplněn žádný údaj o změně (popis změny)."]
[]
[]
[null,"g)","Finanční částky ve sloupci hodnot budou uváděny v Kč bez DPH s přesností na 2 desetinná místa."]
[]
["4)","Přehled změn a dodatků zasílá příjemce dotace v souladu se stanoveným příkazem ředitele OIVZ (tj. elektronicky); tisk slouží pouze pro vlastní potřebu příjemce dotace."]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,"Verze dokumentu:",null,"1.02"]
[]
[null,"Změny oproti předchozí verzi:"]
[null," - upraveny nesrovnalosti v komentářích k ust. § 222 odst. 5 a 6 ZZVZ (buňky I6 až L6)"]
[null," - upraven vzorec pro výpočet celkového cenového nárůstu ve smyslu ust. § 222 odst. 9 ZZVZ (tabulka nepočítala validně pokud byly vícepráce a méněpráce na různých řádcích - původně bylo předpokládáno, že jsou změny činěny v rámci jednoho ZL)"]

{"sheet":"Přehled změn a dodatků","index":1,"n_rows":79,"n_cols":42,"rows_kept":79,"cut":false,"hidden":false,"merged":[[61,2,61,4],[64,2,64,4],[76,2,76,4],[74,2,74,4],[75,2,75,4],[67,2,67,4],[68,2,68,4],[0,0,0,13],[73,2,73,4],[63,2,63,4],[1,12,1,13],[2,10,2,11],[60,2,60,4],[60,6,60,7],[71,2,71,4],[69,2,69,4],[70,2,70,4],[65,2,65,4],[66,2,66,4],[60,8,60,9],[61,12,61,13],[60,10,60,11],[60,12,60,13],[78,11,78,12],[57,7,57,13],[2,12,2,13],[61,10,61,11],[1,0,1,2],[2,0,2,2],[3,0,3,2],[3,3,3,6],[2,3,2,9],[1,3,1,9],[1,10,1,11],[77,2,77,4],[62,2,62,4],[61,6,61,7],[61,8,61,9],[72,2,72,4]]}
["Přehled změn a dodatků",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,"Druh veřejné zakázky"]
["Název akce:",null,null,"Integrované městské centrum služeb Tilia",null,null,null,null,null,null,"Identifikační č. akce EDS/SMVS:",null,"Z2021-044824",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,"dodávky"]
["Název veřejné zakázky:",null,null,"Integrované městské centrum služeb Tilia",null,null,null,null,null,null,"Druh veřejné zakázky:",null,"stavební práce",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,"služby"]
["Původní hodnota závazku (cena sjednaná ve smlouvě bez DPH):",null,null,80628787.019999996,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,"stavební práce"]
[]
["Změna č.","Popis změn","Dodatek č.","Celková hodnota změn","Hodnota změny\n(ZVZ)\n-","Hodnota změny\n(ZVZ)\n+","Hodnota změny\n(§222 odst. 4 ZZVZ)\n-","Hodnota změny\n(§222 odst. 4 ZZVZ)\n+","Hodnota změny\n(§222 odst. 5 ZZVZ)\n-","Hodnota změny\n(§222 odst. 5 ZZVZ)\n+","Hodnota změny\n(§222 odst. 6 ZZVZ)\n-","Hodnota změny\n(§222 odst. 6 ZZVZ)\n+","Hodnota změny\n(§222 odst. 7 ZZVZ)\n-","Hodnota změny\n(§222 odst. 7 ZZVZ) \n+","Hodnota změny ve vztahu k § 222 odst. 4 ZZVZ","Hodnota změny ve vztahu k §222 odst. 5 ZZVZ","Hodnota změny ve vztahu k §222 odst. 6 ZZVZ\n","Cenový nárůst související se změnou \npodle §222 odst. 5 a 6 ZZVZ (ve smyslu ust. § 222odst. 9)","Dodatek č. 1","Dodatek č. 2","Dodatek č. 3","Dodatek č. 4","Dodatek č. 5","Dodatek č. 6","Dodatek č. 7","Dodatek č. 8","Dodatek č. 9","Dodatek č. 10","Dodatek č. 11","Dodatek č. 12","Dodatek č. 13","Dodatek č. 14","Dodatek č. 15"]
[1,"Válečný stav",2,{"$f":"(F7-E7)+(H7-G7)+(J7-I7)+(L7-K7)+(N7-M7)","v":2917099.09},null,null,null,2917099.09,null,null,null,null,null,null,{"$f":"G7+H7","v":2917099.09},{"$f":"J7+I7","v":0},{"$f":"L7+K7+F7","v":0},{"$f":"L7+J7+F7","v":0},{"$f":"IF($C7=1,$D7,\"\")","v":""},{"$f":"IF($C7=2,$D7,\"\")","v":2917099.09},{"$f":"IF($C7=3,$D7,\"\")","v":""},{"$f":"IF($C7=4,$D7,\"\")","v":""},{"$f":"IF($C7=5,$D7,\"\")","v":""},{"$f":"IF($C7=6,$D7,\"\")","v":""},{"$f":"IF($C7=7,$D7,\"\")","v":""},{"$f":"IF($C7=8,$D7,\"\")","v":""},{"$f":"IF($C7=9,$D7,\"\")","v":""},{"$f":"IF($C7=10,$D7,\"\")","v":""},{"$f":"IF($C7=11,$D7,\"\")","v":""},{"$f":"IF($C7=12,$D7,\"\")","v":""},{"$f":"IF($C7=13,$D7,\"\")","v":""},{"$f":"IF($C7=14,$D7,\"\")","v":""},{"$f":"IF($C7=15,$D7,\"\")","v":""}]
[2,"Stažení obvodových konstrukcí a nátěry krokví",3,{"$f":"(F8-E8)+(H8-G8)+(J8-I8)+(L8-K8)+(N8-M8)","v":367311.15},null,null,null,367311.15,null,null,null,null,null,null,{"$f":"G8+H8","v":367311.15},{"$f":"J8+I8","v":0},{"$f":"L8+K8+F8","v":0},0,{"$f":"IF($C8=1,$D8,\"\")","v":""},{"$f":"IF($C8=2,$D8,\"\")","v":""},{"$f":"IF($C8=3,$D8,\"\")","v":367311.15},{"$f":"IF($C8=4,$D8,\"\")","v":""},{"$f":"IF($C8=5,$D8,\"\")","v":""},{"$f":"IF($C8=6,$D8,\"\")","v":""},{"$f":"IF($C8=7,$D8,\"\")","v":""},{"$f":"IF($C8=8,$D8,\"\")","v":""},{"$f":"IF($C8=9,$D8,\"\")","v":""},{"$f":"IF($C8=10,$D8,\"\")","v":""},{"$f":"IF($C8=11,$D8,\"\")","v":""},{"$f":"IF($C8=12,$D8,\"\")","v":""},{"$f":"IF($C8=13,$D8,\"\")","v":""},{"$f":"IF($C8=14,$D8,\"\")","v":""},{"$f":"IF($C8=15,$D8,\"\")","v":""}]
[3,"Přístavba - bourací práce",3,102385.85,null,null,null,102385.85,null,null,null,null,null,null,{"$f":"G9+H9","v":102385.85},{"$f":"J9+I9","v":0},0,0,"","",102385.85,"","","","","","","","","","","",""]
[4,"Přístavba - zdivo a základy",3,605394.96,null,null,null,605394.96,null,null,null,null,null,null,605394.96,0,0,0,"","",605394.96,"","","","","","","","","","","",""]
[5,"VRN - prdloužení termínu",3,538254.35,null,null,null,538254.35,null,null,null,null,null,null,{"$f":"G11+H11","v":538254.35},0,0,0,"","",538254.35,"","","","","","","","","","","",""]
[6,"Násyp betonového recyklátu",4,274080,null,null,null,null,null,null,null,274080,null,null,0,0,274080,274080,"","","",274080,"","","","","","","","","","",""]
[7,"střešní okna",4,{"$f":"(F13-E13)+(H13-G13)+(J13-I13)+(L13-K13)+(N13-M13)","v":119133.5},null,null,null,148685,null,null,null,null,327617.13,298065.63,{"$f":"G13+H13","v":148685},{"$f":"J13+I13","v":0},{"$f":"L13+K13+F13","v":0},0,{"$f":"IF($C13=1,$D13,\"\")","v":""},{"$f":"IF($C13=2,$D13,\"\")","v":""},{"$f":"IF($C13=3,$D13,\"\")","v":""},{"$f":"IF($C13=4,$D13,\"\")","v":119133.5},{"$f":"IF($C13=5,$D13,\"\")","v":""},{"$f":"IF($C13=6,$D13,\"\")","v":""},{"$f":"IF($C13=7,$D13,\"\")","v":""},{"$f":"IF($C13=8,$D13,\"\")","v":""},{"$f":"IF($C13=9,$D13,\"\")","v":""},{"$f":"IF($C13=10,$D13,\"\")","v":""},{"$f":"IF($C13=11,$D13,\"\")","v":""},{"$f":"IF($C13=12,$D13,\"\")","v":""},{"$f":"IF($C13=13,$D13,\"\")","v":""},{"$f":"IF($C13=14,$D13,\"\")","v":""},{"$f":"IF($C13=15,$D13,\"\")","v":""}]
[8,"retenční nádrž",4,-204692.83999999997,null,null,null,null,null,null,null,null,710437.84,505745,0,0,0,0,"","","",-204692.83999999997,"","","","","","","","","","",""]
[9,"světlík",4,127145.66999999998,null,null,null,null,null,null,26319.599999999999,153465.26999999999,null,null,0,0,179784.87,153465.26999999999,"","","",127145.66999999998,"","","","","","","","","","",""]
[10,"vnější parapety",4,141331.76999999999,null,null,null,null,null,null,70491.100000000006,211822.87,null,null,0,0,282313.96999999997,211822.87,"","","",141331.76999999999,"","","","","","","","","","",""]
[11,"Otvorová výplň F13",4,{"$f":"(F17-E17)+(H17-G17)+(J17-I17)+(L17-K17)+(N17-M17)","v":412900.41000000003},null,null,154675,567575.41,null,null,null,null,null,null,{"$f":"G17+H17","v":722250.41},{"$f":"J17+I17","v":0},{"$f":"L17+K17+F17","v":0},{"$f":"L17+J17+F17","v":0},{"$f":"IF($C17=1,$D17,\"\")","v":""},{"$f":"IF($C17=2,$D17,\"\")","v":""},{"$f":"IF($C17=3,$D17,\"\")","v":""},{"$f":"IF($C17=4,$D17,\"\")","v":412900.41000000003},{"$f":"IF($C17=5,$D17,\"\")","v":""},{"$f":"IF($C17=6,$D17,\"\")","v":""},{"$f":"IF($C17=7,$D17,\"\")","v":""},{"$f":"IF($C17=8,$D17,\"\")","v":""},{"$f":"IF($C17=9,$D17,\"\")","v":""},{"$f":"IF($C17=10,$D17,\"\")","v":""},{"$f":"IF($C17=11,$D17,\"\")","v":""},{"$f":"IF($C17=12,$D17,\"\")","v":""},{"$f":"IF($C17=13,$D17,\"\")","v":""},{"$f":"IF($C17=14,$D17,\"\")","v":""},{"$f":"IF($C17=15,$D17,\"\")","v":""}]
[12,"Vnější žaluzie",4,134780.32999999999,null,null,null,null,null,null,null,134780.32999999999,null,null,0,0,134780.32999999999,134780.32999999999,"","","",134780.32999999999,"","","","","","","","","","",""]
[13,"radiátory",4,211330,null,null,161997,373327,null,null,null,null,null,null,535324,0,0,0,"","","",211330,"","","","","","","","","","",""]
[14,"VRN - prdloužení termínu k ZL09",4,112637.9,null,null,null,null,null,null,null,112637.9,null,null,0,0,112637.9,112637.9,"","","",112637.9,"","","","","","","","","","",""]
[15,"Obklady a dlažby",5,-29786.660000000033,null,null,366369.08,336582.42,null,null,null,null,null,null,702951.5,0,0,0,"","","","",-29786.660000000033,"","","","","","","","","",""]
[16,"Vnitřní omítky",5,20493.709999999963,null,null,null,null,null,null,null,null,1386050.02,1406543.73,0,0,0,0,"","","","",20493.709999999963,"","","","","","","","","",""]
[16,"vnitřní barytová omítka",5,121288.3,null,null,null,null,null,null,null,121288.3,null,null,0,0,121288.3,121288.3,"","","","",121288.3,"","","","","","","","","",""]
[17,"povrchy podlah",5,233917.28000000003,null,null,null,null,null,null,null,null,1475233.53,1709150.81,0,0,0,0,"","","","",233917.28000000003,"","","","","","","","","",""]
[null,"povrchy podlah neuz.koberce",5,424820,null,null,null,null,null,null,null,null,null,424820,0,0,0,0,"","","","",424820,"","","","","","","","","",""]
[null,"dřevěná podlaha",5,327709.65000000002,null,null,null,327709.65000000002,null,null,null,null,null,null,327709.65000000002,0,0,0,"","","","",327709.65000000002,"","","","","","","","","",""]
[18,"venkovní výplně",5,-23313.23000000001,null,null,null,null,null,null,277031.5,253718.27,null,null,0,0,530749.77,253718.27,"","","","",-23313.23000000001,"","","","","","","","","",""]
[19,"SDK",5,{"$f":"(F28-E28)+(H28-G28)+(J28-I28)+(L28-K28)+(N28-M28)","v":32954.5},null,null,null,null,null,null,null,null,1256607.31,1289561.81,{"$f":"G28+H28","v":0},{"$f":"J28+I28","v":0},{"$f":"L28+K28+F28","v":0},{"$f":"L28+J28+F28","v":0},{"$f":"IF($C28=1,$D28,\"\")","v":""},{"$f":"IF($C28=2,$D28,\"\")","v":""},{"$f":"IF($C28=3,$D28,\"\")","v":""},{"$f":"IF($C28=4,$D28,\"\")","v":""},{"$f":"IF($C28=5,$D28,\"\")","v":32954.5},{"$f":"IF($C28=6,$D28,\"\")","v":""},{"$f":"IF($C28=7,$D28,\"\")","v":""},{"$f":"IF($C28=8,$D28,\"\")","v":""},{"$f":"IF($C28=9,$D28,\"\")","v":""},{"$f":"IF($C28=10,$D28,\"\")","v":""},{"$f":"IF($C28=11,$D28,\"\")","v":""},{"$f":"IF($C28=12,$D28,\"\")","v":""},{"$f":"IF($C28=13,$D28,\"\")","v":""},{"$f":"IF($C28=14,$D28,\"\")","v":""},{"$f":"IF($C28=15,$D28,\"\")","v":""}]
[20,"úprava vnitřních výplní",5,283204.99000000022,null,null,null,null,null,null,null,null,2685175,2968379.99,0,0,0,0,"","","","",283204.99000000022,"","","","","","","","","",""]
[21,"fasáda",5,326040.93000000005,null,null,null,null,null,null,272977.25,599018.18000000005,null,null,0,0,871995.43,599018.18000000005,"","","","",326040.93000000005,"","","","","","","","","",""]
[22,"zárubně",5,-20017.48000000001,null,null,null,null,null,null,null,null,195287,175269.52,0,0,0,0,"","","","",-20017.48000000001,"","","","","","","","","",""]
[23,"vnější schodiště",5,318359.09999999998,null,null,null,null,null,null,149841.85,468200.95,null,null,0,0,618042.80000000005,468200.95,"","","","",318359.09999999998,"","","","","","","","","",""]
[24,"Elektro",5,-615871.4,null,null,null,null,null,null,615871.4,null,null,null,0,0,615871.4,0,"","","","",-615871.4,"","","","","","","","","",""]
[null,"EZS",5,132666.29,null,null,null,null,null,null,null,132666.29,null,null,0,0,132666.29,132666.29,"","","","",132666.29,"","","","","","","","","",""]
[null,"úprava vrátníků a DT",5,162296.79,null,null,null,null,null,null,null,162296.79,null,null,0,0,162296.79,162296.79,"","","","",162296.79,"","","","","","","","","",""]
[null,"změna koncových prvků Levit",5,36807.49,null,null,null,36807.49,null,null,null,null,null,null,36807.49,0,0,0,"","","","",36807.49,"","","","","","","","","",""]
[null,"doplnění topných kabelů",5,15020.81,null,null,null,null,null,null,null,15020.81,null,null,0,0,15020.81,15020.81,"","","","",15020.81,"","","","","","","","","",""]
[null,"lékárna",5,45798,null,null,null,45798,null,null,null,null,null,null,45798,0,0,0,"","","","",45798,"","","","","","","","","",""]
[null,"přenosná indukční smyčka",5,38312.78,null,null,null,null,null,null,null,38312.78,null,null,0,0,38312.78,38312.78,"","","","",38312.78,"","","","","","","","","",""]
[null,"doplnění distančních podložek na inst. Krabice pod koncové prvky",5,28795,null,null,null,null,null,null,null,28795,null,null,0,0,28795,28795,"","","","",28795,"","","","","","","","","",""]
[null,"doplnění instalačních rámečků na svítidla A1",5,51540,null,null,null,null,null,null,null,51540,null,null,0,0,51540,51540,"","","","",51540,"","","","","","","","","",""]
[null,"změna svítidel dle revize PD",5,371024.6,null,null,null,null,null,null,null,null,null,371024.6,0,0,0,0,"","","","",371024.6,"","","","","","","","","",""]
[null,"doplnění aktivních prvků AP",5,9150,null,null,null,9150,null,null,null,null,null,null,9150,0,0,0,"","","","",9150,"","","","","","","","","",""]
[25,"vnitřní dveře",5,-82870.75,null,null,null,null,null,null,118012,35141.25,null,null,0,0,153153.25,35141.25,"","","","",-82870.75,"","","","","","","","","",""]
[26,"ordinace zubního lékaře nezp.",5,24738,null,null,null,24738,null,null,null,null,null,null,24738,0,0,0,"","","","",24738,"","","","","","","","","",""]
[27,"betonáž základové desky",5,573584.12,null,null,null,null,null,null,null,573584.12,null,null,0,0,573584.12,573584.12,"","","","",573584.12,"","","","","","","","","",""]
[28,"VRN - ",5,140313.57999999999,null,null,null,140313.57999999999,null,null,null,null,null,null,140313.57999999999,0,0,0,"","","","",140313.57999999999,"","","","","","","","","",""]
[29,"ocelové zábradlí",6,{"$f":"(F48-E48)+(H48-G48)+(J48-I48)+(L48-K48)+(N48-M48)","v":266419.12},null,null,551070.65,817489.77,null,null,null,null,null,null,{"$f":"G48+H48","v":1368560.42},{"$f":"J48+I48","v":0},{"$f":"L48+K48+F48","v":0},{"$f":"L48+J48+F48","v":0},{"$f":"IF($C48=1,$D48,\"\")","v":""},{"$f":"IF($C48=2,$D48,\"\")","v":""},{"$f":"IF($C48=3,$D48,\"\")","v":""},{"$f":"IF($C48=4,$D48,\"\")","v":""},{"$f":"IF($C48=5,$D48,\"\")","v":""},{"$f":"IF($C48=6,$D48,\"\")","v":266419.12},{"$f":"IF($C48=7,$D48,\"\")","v":""},{"$f":"IF($C48=8,$D48,\"\")","v":""},{"$f":"IF($C48=9,$D48,\"\")","v":""},{"$f":"IF($C48=10,$D48,\"\")","v":""},{"$f":"IF($C48=11,$D48,\"\")","v":""},{"$f":"IF($C48=12,$D48,\"\")","v":""},{"$f":"IF($C48=13,$D48,\"\")","v":""},{"$f":"IF($C48=14,$D48,\"\")","v":""},{"$f":"IF($C48=15,$D48,\"\")","v":""}]
[30,"rampa česaný beton",6,-114902.35,null,null,null,null,null,null,null,null,335815.18,220912.83,0,0,0,0,"","","","","",-114902.35,"","","","","","","","",""]
[31,"ZTI, ÚT",6,-1390540.59,null,null,null,null,null,null,null,null,1790140,399599.41,0,0,0,0,"","","","","",-1390540.59,"","","","","","","","",""]
[32,"VZT",6,52688.45,null,null,null,null,null,null,40057,92711.45,null,34,0,0,132768.45000000001,92711.45,"","","","","",52688.45,"","","","","","","","",""]
[33,"malby",6,135163.85999999999,null,null,null,null,null,null,null,135163.85999999999,null,null,0,0,135163.85999999999,135163.85999999999,"","","","","",135163.85999999999,"","","","","","","","",""]
[34,"zpevněné plochy",6,-70360.829999999987,null,null,null,null,null,null,329086.53999999998,258725.71,null,null,0,0,587812.25,258725.71,"","","","","",-70360.829999999987,"","","","","","","","",""]
[35,"dešťová kanalizace",6,202284,null,null,0,202284,null,null,null,null,null,null,202284,0,0,0,"","","","","",202284,"","","","","","","","",""]
[36,"neprovedené práce a dodávky",6,-342349.37,null,null,null,null,null,null,null,null,342349.37,0,0,0,0,0,"","","","","",-342349.37,"","","","","","","","",""]
[null,null,null,0,null,null,null,null,null,null,null,null,null,null,0,0,0,0,"","","","","","","","","","","","","","",""]
[null,"CELKEM",null,{"$f":"SUBTOTAL(109,Tabulka1[Celková hodnota změn])","v":7544470.8299999973},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(ZVZ)\n-])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(ZVZ)\n+])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 4 ZZVZ)\n-])","v":1234111.73},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 4 ZZVZ)\n+])","v":7560905.7200000007},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 5 ZZVZ)\n-])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 5 ZZVZ)\n+])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 6 ZZVZ)\n-])","v":1899688.24},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 6 ZZVZ)\n+])","v":3852970.1300000004},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 7 ZZVZ)\n-])","v":10504712.379999999},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny\n(§222 odst. 7 ZZVZ) \n+])","v":9769107.3300000001},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny ve vztahu k § 222 odst. 4 ZZVZ])","v":8795017.4499999993},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny ve vztahu k §222 odst. 5 ZZVZ])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Hodnota změny ve vztahu k §222 odst. 6 ZZVZ\n])","v":5752658.3700000001},{"$f":"SUBTOTAL(109,Tabulka1[Cenový nárůst související se změnou \npodle §222 odst. 5 a 6 ZZVZ (ve smyslu ust. § 222odst. 9)])","v":3852970.1300000004},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 1])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 2])","v":2917099.09},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 3])","v":1613346.31},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 4])","v":1328646.7399999998},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 5])","v":2946976.4000000008},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 6])","v":-1261597.7100000004},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 7])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 8])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 9])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 10])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 11])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 12])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 13])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 14])","v":0},{"$f":"SUBTOTAL(109,Tabulka1[Dodatek č. 15])","v":0}]
[null,"CELKEM (v %)",null,{"$f":"IF($D$4=0,0,$D$57/$D$4)","v":9.3570436922591788E-2},null,null,null,"*Kliknutím na toto pole dojde k přidání nového řádku za poslední výskyt doplněného (neprázdného) pole ve výše uvedené tabulce, ",null,null,null,null,null,null,{"$f":"IF($D$4=0,0,$O$57/$D$4)","v":0.10908036416098375},{"$f":"IF($D$4=0,0,$P$57/$D$4)","v":0},{"$f":"IF($D$4=0,0,($Q$57)/$D$4)","v":7.1347450242219959E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR($M$3=\"dodávky\",$M$3=\"služby\"),O58<0.1,O58<0.15)","v":true},{"$f":"IF(P58<=0.5,TRUE,FALSE)","v":true},{"$f":"IF(Q58<=0.5,TRUE,FALSE)","v":true}]
["Souhrnný přehled celkové ceny včetně změn"]
[null,"Popis","Cena",null,null,null,"Hodnota změny \nve vztahu k § 222 odst. 4 ZZVZ",null,"Hodnota změny \nve vztahu k §222 odst. 5 ZZVZ",null,"Hodnota změny \nve vztahu k §222 odst. 6 ZZVZ\n",null,"Cenový nárůst související se změnou \npodle §222 odst. 5 a 6 ZZVZ (ve smyslu ust. § 222odst. 9)"]
[null,"Původní smlouva",{"$f":"$D$4","v":80628787.019999996},null,null,null,{"$f":"IF($D$4=0,0,$O$57/$D$4)","v":0.10908036416098375},null,{"$f":"IF($D$4=0,0,$P$57/$D$4)","v":0},null,{"$f":"IF($D$4=0,0,($Q$57)/$D$4)","v":7.1347450242219959E-2},null,{"$f":"IF($D$4=0,0,(VALUE(IF(($L$57+$J$57)-($K$57+$I$57)<=0,\"0\",($L$57-$K$57)+($J$57-$I$57)))+$F$57)/$D$4)","v":2.4225614227775596E-2},null,null," "]
[null,{"$f":"IFERROR(IF(VLOOKUP(H63,$C$7:$C$56,1,FALSE),CONCATENATE(G63,\" \",H63),\"\"),\"\")","v":""},{"$f":"IF(F63=TRUE,SUMIFS($D$7:$D$56,$C$7:$C$56,H63),\"\")","v":""},null,null,{"$f":"IFERROR(IF(VLOOKUP(VALUE(RIGHT(B63,2)),$C$7:$C$56,1,FALSE),TRUE,FALSE),FALSE)","v":false},"Dodatek č.",1,null,null,null,null,null,{"$f":"IF(M62<=0.3,TRUE,FALSE)","v":true}]
[null,"Dodatek č. 2",2917099.09,null,null,true,"Dodatek č.",2]
[null,"Dodatek č. 3",1613346.31,null,null,true,"Dodatek č.",3]
[null,"Dodatek č. 4",1328646.7399999998,null,null,true,"Dodatek č.",4]
[null,"Dodatek č. 5",2946976.4000000008,null,null,true,"Dodatek č.",5]
[null,"Dodatek č. 6",-1261597.7100000004,null,null,true,"Dodatek č.",6]
[null,"","",null,null,false,"Dodatek č.",7]
[null,"","",null,null,false,"Dodatek č.",8]
[null,"","",null,null,false,"Dodatek č.",9]
[null,"","",null,null,false,"Dodatek č.",10]
[null,"","",null,null,false,"Dodatek č.",11]
[null,"","",null,null,false,"Dodatek č.",12]
[null,"","",null,null,false,"Dodatek č.",13]
[null,"","",null,null,false,"Dodatek č.",14]
[null,"","",null,null,false,"Dodatek č.",15]
[null,"Realizační cena CELKEM vč. změn",{"$f":"SUM(C62:E77)","v":88173257.850000009}]
[null,null,null,null,null,null,null,null,null,null,null,"Verze dokumentu:",null,{"$f":"'Úvodní informace'!M32","v":"1.02"}]

{"sheet":"List1","index":2,"n_rows":5,"n_cols":4,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
[]
["vysoutěženo",null,80628787.019999996]
["dodatek č.2",null,2917099.09,{"$f":"C2+C3","v":83545886.109999999}]
["dodatek č. 3",null,1613346.31,{"$f":"D3+C4","v":85159232.420000002}]
["dodatek č. 4",null,1347826.91,{"$f":"D4+C5","v":86507059.329999998}]