{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["rozcesti","uvod A","podminky B","podminky C","konstrukce","ostatni vstupy","navrh opatreni a vysledky","help","vypocet","data","doplnit"],"not_rendered":{"charts":4,"images":2,"macros":1,"external_links":0,"defined_names":15,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"rozcesti","index":0,"n_rows":23,"n_cols":3,"rows_kept":23,"cut":false,"hidden":false,"merged":[[0,2,0,3]]}
[null,null,"Orientační výpočet dotace z programu Nová zelená úsporám 2013"]
[]
[]
[]
[]
[]
[]
[]
[null,null,"A - Snižování energetické náročnosti stávajících rodinných domů. \nMožná kombinace s C - výměna neekologického zdroje tepla, instalace termického solárního systému nebo instalace systému nuceného větrání se zpětným získáváním  (rekuperací) tepla."]
[null,null,"Dotace ze způsobilých výdajů 30, 40 nebo 55 %. "]
[]
[null,null,"B - Výstavba rodinných domů s velmi nízkou energetickou náročností."]
[null,null,"Dotace až 550 000 Kč."]
[]
[null,null,"C - Efektivní využití zdrojů energie - výměna neekologických zdrojů tepla, instalace termických solárních systémů."]
[null,null,"Dotace až 100 000 Kč."]
[]
[null,null,"D - Podpora na přípravu a zajištění realizace podporovaných opatření. "]
[null,null,"Podpora na projekt, posudek, stavební dozor, testy vzduchotěsnosti. "]
[null,null,"Dotace až 35 000 Kč."]
[]
[null,null,"E - Bonusy za kombinaci vybraných opatření."]
[null,null,"Dotace až 10 000 Kč."]

{"sheet":"uvod A","index":1,"n_rows":30,"n_cols":3,"rows_kept":30,"cut":false,"hidden":false,"merged":[[31,1,31,2],[15,1,15,2],[22,1,22,2],[29,1,29,2],[17,1,17,2],[0,1,0,2],[1,1,1,2],[2,1,2,2],[4,1,4,2],[24,1,24,2]]}
[null,"Orientační výpočet pro program Nová zelená úsporám 2013 - Oblast A - Snižování energetické náročnosti RD"]
[null,"Tento výpočet nenahrazuje odborný posudek, ale slouží pro hrubé posouzení splnitelnosti podmínek programu."]
[null,"Tento nástroj umožňuje zadání tvarově jednoduchého RD s omezeným počtem stavebních konstrukcí."]
[]
[null,"Kritéria dosažení dotace jsou následující:"]
[null,"A.1: dotace 30 %"]
[null,"A.1.1"]
[null,"Podmínka 1","dosažení hodnoty průměrného součinitele prostupu tepla obálkou budovy Uem ve výši 0,95 násobku průměrného součinitele prostupu tepla referenční budovy "]
[null,"Podmínka 2","snížení vypočtené hodnoty měrné roční potřeby tepla na vytápění EA oproti stavu před realizací opatření alespoň o 40 %"]
[]
[null,"A.1.2"]
[null,"Podmínka 1","splnění maximální hodnoty součinitele prostupu tepla ve výši 0,95 násobku doporučené hodnoty součinitele prostupu tepla určeného dle ČSN 73 0540-2:2011 pro všechny měněné konstrukce"]
[null,"Podmínka 2","dosažení vypočtené měrné roční potřeby tepla na vytápění EA nejvýše 70 kWh.m-2.rok-1"]
[null,"Podmínka 3","snížení vypočtené hodnoty měrné roční potřeby tepla na vytápění po realizaci zateplení alespoň o 40 % oproti stavu před jeho realizací"]
[]
[null,"V případě památkově chráněných budov, ve smyslu zákona č. 406/2000 Sb., o hospodaření energií, ve znění pozdějších předpisů, je podmínkou poskytnutí podpory dosažení hodnoty součinitelů prostupu tepla měněných konstrukcí ve výši 0,95 násobku doporučené hodnoty součinitele prostupu tepla dle ČSN 73 0540-2:2011."]
[]
[null,"A.2: dotace 40 %"]
[null,"Podmínka 1","dosažení hodnoty průměrného součinitele prostupu tepla obálkou budovy Uem ve výši 0,85 násobku průměrného součinitele prostupu tepla referenční budovy"]
[null,"Podmínka 2","dosažení hodnoty měrné roční potřeby tepla na vytápění EA nejvýše 55 kWh.m-2.rok-1"]
[null,"Podmínka 3","snížení hodnoty měrné roční potřeby tepla na vytápění EA oproti stavu před realizací opatření alespoň o 50 %"]
[]
[null,"V případě památkově chráněných budov, ve smyslu zákona č. 406/2000 Sb., o hospodaření energií, ve znění pozdějších předpisů, je podmínkou poskytnutí podpory dosažení hodnoty součinitelů prostupu tepla měněných konstrukcí ve výši 0,85 násobku doporučené hodnoty součinitele prostupu tepla dle ČSN 73 0540-2:2011."]
[]
[null,"A.3: dotace 55 %"]
[null,"Podmínka 1","dosažení hodnoty průměrného součinitele prostupu tepla obálkou budovy Uem ve výši 0,75 násobku průměrného součinitele prostupu tepla referenční budovy"]
[null,"Podmínka 2","dosažení hodnoty měrné roční potřeby tepla na vytápění EA nejvýše 35 kWh.m-2.rok-1 "]
[null,"Podmínka 3","snížení hodnoty měrné roční potřeby tepla na vytápění EA oproti stavu před realizací opatření alespoň o 60 %"]
[]
[null,"V případě památkově chráněných budov, ve smyslu zákona č. 406/2000 Sb., o hospodaření energií, ve znění pozdějších předpisů, je podmínkou poskytnutí podpory dosažení hodnoty součinitelů prostupu tepla měněných konstrukcí ve výši 0,75 násobku doporučené hodnoty součinitele prostupu tepla dle ČSN 73 0540-2:2011."]

{"sheet":"podminky B","index":2,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[[22,1,22,2],[1,1,1,2],[2,1,2,2],[15,1,16,1],[15,2,16,2],[5,1,6,1],[5,2,6,2],[7,4,8,4],[9,1,10,1],[9,2,10,2],[9,3,10,3],[9,4,10,4],[7,1,8,1],[7,2,8,2],[0,1,0,4],[15,3,16,3],[15,4,16,4],[17,1,18,1],[17,2,18,2],[17,3,18,3],[17,4,18,4],[11,3,12,3],[11,4,12,4],[13,1,14,1],[13,2,14,2],[13,3,14,3],[13,4,14,4],[11,1,12,1],[11,2,12,2],[7,3,8,3]]}
[null,"Podmínky programu Nová zelená úsporám 2013 - Oblast B - Výstavba budov s velmi nízkou energetickou náročností"]
[]
[]
[]
[null,"Kritéria dosažení dotace:",null,"B.1: dotace 400 000 Kč","B.2: dotace 550 000 Kč"]
[null,"Sledované parametry","Označení       Jednotky","Oblast podpory","Oblast podpory"]
[null,null,null,"B.1","B.2"]
[null,"Měrná roční potřeba tepla na vytápění"," EA [kWh/m2.rok]","≤ 20","≤ 15"]
[]
[null,"Měrná neobnovitelná primární energie","EpN,A   [kWh/m2.rok]","≤ 90","≤ 60"]
[]
[null,"Součinitel prostupu tepla jednotlivých konstrukcí na systémové hranici","U         [W/(m2.K)]","≤ Upas,20","≤ Upas,20"]
[]
[null,"Průměrný součinitel prostupu tepla","Uem       W/(m2.K)   ","≤ 0,22","≤ 0,22"]
[]
[null,"Neprůvzdušnost obálky budovy po dokončení stavby","n50             [1/h].","≤ 0,6","≤ 0,6"]
[]
[null,"Nejvyšší teplota vzduchu v pobytové místnosti","θai,max             [°C]","≤ θai,max,N ","≤ θai,max,N "]
[]
[null,"Povinná instalace systému nuceného větrání","[-]","Ano","Ano"]
[null,"Účinnost zpětného získávání tepla z odváděného vzduchu","η                             [%] ","≥ 75","≥ 75"]

{"sheet":"podminky C","index":3,"n_rows":20,"n_cols":22,"rows_kept":20,"cut":false,"hidden":false,"merged":[[2,1,2,6],[3,1,3,6],[4,1,4,6],[0,1,0,7],[20,1,20,2]]}
[null,"Podmínky programu Nová zelená úsporám 2013 - Oblast C - \nEfektivní využití zdrojů energie a instalace termických solárních systémů."]
[]
[null,"Dotace slouží k podpoře výměny neekologických kotlů na tuhá a vyjmenovaná kapalná paliva v objektech s měrnou potřebou tepla na vytápění nižší než 150 kWh/m2.rok."]
[null,"Dále lze instalovat solární systém pro ohřev vody nebo pro ohřev vody a přitápění.",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD2","v":"Bez výměny"}]
[null,"Podporována je také instalace větracích systémů s rekuperací tepla z odpadního vzduchu, \nale pouze v kombinaci s komplexním zateplením budov (Oblast A).",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD3","v":"Kotel na biomasu s ruční dodávkou paliva"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD4","v":"Kotel na biomasu s automatickou dodávkou paliva"}]
[null,"Výměna neekologického zdroje tepla:",null,null,"Kotel na biomasu s automatickou dodávkou paliva",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD5","v":"Krbová kamna na biomasu s výměníkem s ruční dodávkou paliva"}]
[null,"Instalace solárního systému:",null,null,"Solární systém pro ohřev vody",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD6","v":"Krbová kamna na biomasu s výměníkem se samočinnou dodávkou paliva"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD7","v":"Tepelné čerpadlo voda-voda"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD8","v":"Tepelné čerpadlo země – voda"}]
[null,"Maximální výše způsobilých výdajů:","Kč s DPH",null,"Maximální výše dotace","Kč",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD9","v":"Tepelné čerpadlo vzduch-voda"}]
[null,"Výměna neekologického zdroje tepla",{"$f":"data!AJ42","v":145454.54545454544},null,{"$f":"B12","v":"Výměna neekologického zdroje tepla"},{"$f":"data!AH42","v":80000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD10","v":"Plynový kondenzační kotel"}]
[null,"Instalace rekuperační jednotky",{"$f":"IF(E9=V20,100000,0)","v":0},null,"Instalace rekuperační jednotky",{"$f":"C13","v":0}]
[null,"Instalace solárního systému",{"$f":"data!AJ47","v":87500},null,{"$f":"B14","v":"Instalace solárního systému"},{"$f":"data!AH47","v":35000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD11","v":"C3"}]
[null,"Dokumentace - posudek pro oblast C",{"$f":"IF((C12)>0,5000,0)","v":5000},null,{"$f":"B15","v":"Dokumentace - posudek pro oblast C"},{"$f":"IF((F12)>0,5000,0)","v":5000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD12","v":"Žádný"}]
[null,null,null,null,"Bonus za souběh opatření",{"$f":"IF(AND(F12>0,F14>0),10000,0)","v":10000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD13","v":"Solární systém pro ohřev vody"}]
[null,"Celkem",{"$f":"SUM(C12:C15)","v":237954.54545454544},null,"Celkem",{"$f":"SUM(F12:F16)","v":130000},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD14","v":"Solární systém pro ohřev vody a přitápění"}]
[null,"(Skutečné náklady projektu se mohou lišit podle místních podmínek).",null,null,"Podíl dotace",{"$f":"IFERROR(F17/C17,0)","v":0.54632282712511937}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Žádný"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rovnotlaký systém s rekuperací"]

{"sheet":"konstrukce","index":4,"n_rows":35,"n_cols":13,"rows_kept":35,"cut":false,"hidden":false,"merged":[[36,9,36,10],[0,1,0,5],[36,1,36,2],[36,3,36,4],[36,5,36,6],[36,7,36,8]]}
[null,"Popis stavebních konstrukcí",null,null,null,null,null,null,"Zpět","Pokračovat","Nápověda"]
[]
[null,"Obvodové stěny mezi vytápěnou částí a venkovním prostředím","Výška (m)","Délka (m)","Hrubá plocha včetně oken (m2)","Materiál stěny","Existující zateplení (cm)",null,"Okna a dveře - 1. typ (celková plocha) (m2)","Typ oken nebo dveří","Okna a dveře - 2. typ (celková plocha) (m2)","Typ oken nebo dveří","Čistá plocha stěny (m2)"]
[null,"Severní stěna 1",null,null,{"$f":"C4*D4","v":0},null,null,null,null,null,null,null,{"$f":"E4-I4-K4","v":0}]
[null,"Severní stěna 2",null,null,{"$f":"C5*D5","v":0},null,null,null,null,null,null,null,{"$f":"E5-I5-K5","v":0}]
[]
[null,"Jižní stěna 1",null,null,{"$f":"C7*D7","v":0},null,null,null,null,null,null,null,{"$f":"E7-I7-K7","v":0}]
[null,"Jižní stěna 2",null,null,0,null,null,null,null,null,null,null,{"$f":"E8-I8-K8","v":0}]
[]
[null,"Východní stěna 1",null,null,0,null,null,null,null,null,null,null,{"$f":"E10-I10-K10","v":0}]
[null,"Východní stěna 2",null,null,0,null,null,null,null,null,null,null,{"$f":"E11-I11-K11","v":0}]
[]
[null,"Západní stěna 1",null,null,0,null,null,null,null,null,null,null,{"$f":"E13-I13-K13","v":0}]
[null,"Západní stěna 2",null,null,0,null,null,null,null,null,null,null,{"$f":"E14-I14-K14","v":0}]
[]
[null,"Podlahy","Délka (m)","Šířka (m)","Celková plocha (m2)","Materiál"]
[null,"Podlaha na zemině 1",null,null,{"$f":"C17*D17","v":0}]
[null,"Podlaha na zemině 2",null,null,0]
[]
[null,"Podlaha nad nevytápěným sklepem 1",null,null,{"$f":"C20*D20","v":0}]
[null,"Podlaha nad nevytápěným sklepem 2",null,null,0]
[]
[null,"Střechy a stropy","Délka (m)","Šířka (m)","Celková plocha (m2)","Materiál","Existující dodatečná tepelná izolace (cm)",null,"Střešní okno (m2)","Typ","Plocha po odečtení oken (m2)"]
[null,"Střecha plochá nebo do 45 ° 1",null,null,{"$f":"C24*D24","v":0},null,null,null,null,null,{"$f":"E24-I24","v":0}]
[null,"Střecha plochá nebo do 45 ° 2",null,null,0,null,null,null,null,null,{"$f":"E25-I25","v":0}]
[]
[null,"Střecha šikmá nad 45 ° 1",null,null,0,null,null,null,null,null,{"$f":"E27-I27","v":0}]
[null,"Střecha šikmá nad 45 ° 1",null,null,0,null,null,null,null,null,{"$f":"E28-I28","v":0}]
[]
[null,"Strop pod půdou 1",null,null,0]
[null,"Strop pod půdou 2",null,null,0]
[]
[null,"Ostatní","Výška (m)","Šířka (m)","Celková plocha (m2)","Materiál","Dveře k nevytápěnému prostoru (m2)",null,"Typ dveří","Čistá plocha stěny (m2)"]
[null,"Stěna k nevytápěnému prostoru 1",null,null,{"$f":"C34*D34","v":0},null,null,null,null,{"$f":"E34-G34","v":0}]
[null,"Stěna k nevytápěnému prostoru 2",null,null,0,null,null,null,null,{"$f":"E35-G35","v":0}]

{"sheet":"ostatni vstupy","index":5,"n_rows":19,"n_cols":11,"rows_kept":19,"cut":false,"hidden":false,"merged":[[0,1,0,5],[18,5,18,10],[19,5,19,10],[23,0,23,4],[23,5,23,9],[23,10,23,11]]}
[null,"Ostatní vstupy",null,null,null,null,null,null,"Zpět","Pokračovat","Nápověda"]
[]
[null,"Objem vytápěné části budovy",null,null,"m3"]
[]
[null,"Pomocná kalkulačka pro základní tvar",null,"délka (m)"]
[null,null,"a"]
[null,null,"b"]
[null,null,"c"]
[null,null,"d"]
[null,null,"e"]
[null,null,"Výsledek",{"$f":"D6*D7*D8+D9*D10*D6+(D8-D9)*D6*D10","v":0},"m3"]
[]
[]
[]
[]
[]
[]
[]
[null,"Celková energeticky vztažná podlahová plocha",null,null,"m2","Plocha vytápěné části stanovená z vnějších rozměrů, tj. včetně tloušťky obvodových stěn. Pokud má dům více podlaží, sčítají se."]

{"sheet":"navrh opatreni a vysledky","index":6,"n_rows":41,"n_cols":37,"rows_kept":41,"cut":false,"hidden":false,"merged":[[0,1,0,5],[16,6,16,8],[16,10,16,12],[3,11,3,13],[59,1,59,2]]}
[null,"Návrh opatření a výsledky",null,null,null,null,null,null,"Zpět",null,"Nápověda",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"ponechat v původním stavu",0,null,null,"Požadavek ZÚ na dotaci 30 %",null,null,null,null,{"$f":"data!AD2","v":"Bez výměny"}]
[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,"zateplit na doporučenou hodnotu",1,null,null,"Požadavek ZÚ na dotaci 40 %",null,null,null,null,{"$f":"data!AD3","v":"Kotel na biomasu s ruční dodávkou paliva"}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kontrola zadání konstrukcí","uznatelné náklady",null,"opatření",null,"zateplit na lepší než doporučenou hodnotu",2,null,null,"Požadavek ZÚ na dotaci 55 %",null,null,null,null,{"$f":"data!AD4","v":"Kotel na biomasu s automatickou dodávkou paliva"}]
[null,"Severní stěna",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J4+vypocet!J5","v":0},{"$f":"IF(Z4=0,0,W4*data!$AB$3)","v":0},null,{"$f":"IF(C4=$AB$1,$AC$1,IF(C4=$AB$2,$AC$2,IF(C4=$AB$3,$AC$3,IF(C4=$AB$4,$AC$4,IF(C4=$AB$5,$AC$5,\"chyba\")))))","v":"chyba"},null,"zateplit na min. hodnotu pro pasivní domy",3,null,null,"Původní stav",null,null,null,null,{"$f":"data!AD5","v":"Krbová kamna na biomasu s výměníkem s ruční dodávkou paliva"}]
[null,"Jižní stěna","ponechat v původním stavu",null,null,null,null,null,null,null,null,0.3,0.4,0.55000000000000004,null,null,null,null,null,null,null,null,{"$f":"vypocet!J7+vypocet!J8","v":0},{"$f":"IF(Z5=0,0,W5*data!$AB$3)","v":0},null,{"$f":"IF(C5=$AB$1,$AC$1,IF(C5=$AB$2,$AC$2,IF(C5=$AB$3,$AC$3,IF(C5=$AB$4,$AC$4,IF(C5=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"zateplit na max. hodnotu pro pasivní domy",4,null,null,"Stav po opatřeních",null,null,null,null,{"$f":"data!AD6","v":"Krbová kamna na biomasu s výměníkem se samočinnou dodávkou paliva"}]
[null,"Východní stěna","ponechat v původním stavu",null,"Původní měrná potřeba tepla na vytápění EV",null,null,null,null,{"$f":"IFERROR(vypocet!I207,0)","v":0},"kWh/m2,rok",null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J10+vypocet!J11","v":0},{"$f":"IF(Z6=0,0,W6*data!$AB$3)","v":0},null,{"$f":"IF(C6=$AB$1,$AC$1,IF(C6=$AB$2,$AC$2,IF(C6=$AB$3,$AC$3,IF(C6=$AB$4,$AC$4,IF(C6=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"ponechat v původním stavu",0,null,null,null,null,null,null,null,{"$f":"data!AD7","v":"Tepelné čerpadlo voda-voda"}]
[null,"Západní stěna","ponechat v původním stavu",null,"Nová měrná potřeba tepla na vytápění EV",null,null,null,null,{"$f":"IFERROR(vypocet!AE207,0)","v":0},"kWh/m2,rok",70,55,35,null,null,null,null,null,null,null,null,{"$f":"vypocet!J13+vypocet!J14","v":0},{"$f":"IF(Z7=0,0,W7*data!$AB$3)","v":0},null,{"$f":"IF(C7=$AB$1,$AC$1,IF(C7=$AB$2,$AC$2,IF(C7=$AB$3,$AC$3,IF(C7=$AB$4,$AC$4,IF(C7=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"vyměnit za okna s dvojsklem",1,null,null,null,null,null,null,null,{"$f":"data!AD8","v":"Tepelné čerpadlo země – voda"}]
[null,null,null,null,"Pokles měrné potřeby tepla na vytápění",null,null,null,null,{"$f":"IFERROR((1-(J7/J6)),0)","v":0},null,0.4,0.5,0.6,null,null,null,null,null,null,null,null,null,null,null,null,null,"vyměnit za okna s trojsklem",2,null,null,null,null,null,null,null,{"$f":"data!AD9","v":"Tepelné čerpadlo vzduch-voda"}]
[null,"Podlaha na zemině","ponechat v původním stavu",null,null,null,null,null,null,{"$f":"J10/J11","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J17+vypocet!J18","v":0},{"$f":"IF(Z9=0,0,W9*data!AB8)","v":0},null,{"$f":"IF(C9=$AB$1,$AC$1,IF(C9=$AB$2,$AC$2,IF(C9=$AB$3,$AC$3,IF(C9=$AB$4,$AC$4,IF(C9=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"vyměnit za okna s trojsklem - nejlepší",3,null,null,null,null,null,null,null,{"$f":"data!AD10","v":"Plynový kondenzační kotel"}]
[null,"Podlaha nad sklepem","ponechat v původním stavu",null,"Původní průměrný součinitel prostupu tepla Uem",null,null,null,null,{"$f":"IFERROR(vypocet!B79,0)","v":0},"W/m2,K",null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J20+vypocet!J21","v":0},{"$f":"IF(Z10=0,0,W10*data!AB7)","v":0},null,{"$f":"IF(C10=$AB$1,$AC$1,IF(C10=$AB$2,$AC$2,IF(C10=$AB$3,$AC$3,IF(C10=$AB$4,$AC$4,IF(C10=$AB$5,$AC$5,\"chyba\")))))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD11","v":"C3"}]
[null,null,null,null,"Průměrný součinitel prostupu tepla - referenční budova Uem,R",null,null,null,null,{"$f":"IFERROR(vypocet!O67,0)","v":0},"W/m2,K",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"pouze okny",0,null,null,null,null,null,null,null,{"$f":"data!AD12","v":"Žádný"}]
[null,"Střecha plochá nebo šikmá do 45°","ponechat v původním stavu",null,"Nový průměrný součinitel prostupu tepla Uem",null,null,null,null,{"$f":"IFERROR(vypocet!X79,0)","v":0},"W/m2,K",null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J24+vypocet!J25","v":0},{"$f":"IF(Z12=0,0,W12*data!$AB$5)","v":0},null,{"$f":"IF(C12=$AB$1,$AC$1,IF(C12=$AB$2,$AC$2,IF(C12=$AB$3,$AC$3,IF(C12=$AB$4,$AC$4,IF(C12=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"minimální hygienické větrání zajištěno",1,null,null,null,null,null,null,null,{"$f":"data!AD13","v":"Solární systém pro ohřev vody"}]
[null,"Střecha šikmá nad 45°","ponechat v původním stavu",null,"Dosažená hodnota vůči referenční budově",null,null,null,null,{"$f":"IFERROR(J12/J11,0)","v":0},"-",0.95,0.85,0.75,null,null,null,null,null,null,null,null,{"$f":"vypocet!J27+vypocet!J28","v":0},{"$f":"IF(Z13=0,0,W13*data!$AB$5)","v":0},null,{"$f":"IF(C13=$AB$1,$AC$1,IF(C13=$AB$2,$AC$2,IF(C13=$AB$3,$AC$3,IF(C13=$AB$4,$AC$4,IF(C13=$AB$5,$AC$5,\"chyba\")))))","v":0},null,"instalovat rekuperační jednotku",2,null,null,null,null,null,null,null,{"$f":"data!AD14","v":"Solární systém pro ohřev vody a přitápění"}]
[null,"Strop pod nevytápěnou půdou","ponechat v původním stavu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J30+vypocet!J31","v":0},{"$f":"IF(Z14=0,0,W14*data!$AB$5)","v":0},null,{"$f":"IF(C14=$AB$1,$AC$1,IF(C14=$AB$2,$AC$2,IF(C14=$AB$3,$AC$3,IF(C14=$AB$4,$AC$4,IF(C14=$AB$5,$AC$5,\"chyba\")))))","v":0},null,null,null,null,null,null,null,null,null,null,{"$f":"data!AD15","v":"posudek"}]
[null,null,null,null,"Požadavek na zajištění hygienicky nutného větrání",null,null,null,null,{"$f":"IF(C27=AB11,\"není splněn\",\"je splněn\")","v":"není splněn"}]
[null,"Stěny k nevytápěnému prostoru","ponechat v původním stavu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"vypocet!J34+vypocet!J35","v":0},{"$f":"IF(Z16=0,0,W16*data!AB6)","v":0},null,{"$f":"IF(C16=$AB$1,$AC$1,IF(C16=$AB$2,$AC$2,IF(C16=$AB$3,$AC$3,IF(C16=$AB$4,$AC$4,IF(C16=$AB$5,$AC$5,\"chyba\")))))","v":0},null,null,null,null,null,null,null,null,null,null,"výměna zdroje"]
[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,"instalace solára"]
[null,null,null,null,null,null,null,null,"Energetická náročnost","Obálka budovy","Úspora %","Kvalita měněných konstrukcí","Zajištění větrání","Splnění podmínek dotace",null,null,null,null,null,null,null,null,null,null,null,null,null,"splnění požadavků",null,null,null,null,"součet"]
[null,"Okna a dveře sever","ponechat v původním stavu",null,"Dosažení dotace 30 %",null,"A.1.1",null,null,{"$f":"IF(L13>J13,\"+\",\"-\")","v":"+"},{"$f":"IF(J8>=L8,\"+\",\"-\")","v":"-"},null,{"$f":"IF(C27=AB11,\"-\",\"+\")","v":"-"},{"$f":"AH19","v":"NE"},null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J37:J40)","v":0},{"$f":"IF(Z19=0,0,W19*data!$AB$4)","v":0},null,{"$f":"IF(C19=$AB$6,$AC$6,IF(C19=$AB$7,$AC$7,IF(C19=$AB$8,$AC$8,IF(C19=$AB$9,$AC$9,\"chyba\"))))","v":0},null,{"$f":"IF(I19=\"-\",1,0)","v":0},{"$f":"IF(J19=\"-\",1,0)","v":0},1,0,1,{"$f":"SUM(AB19:AF19)","v":2},{"$f":"IF(AG19>0,\"NE\",\"ANO\")","v":"NE"}]
[null,"Okna a dveře jih","ponechat v původním stavu",null,"Dosažení dotace 30 %",null,"A.1.2",null,{"$f":"IF(J7<=L7,\"+\",\"-\")","v":"+"},null,{"$f":"IF(J8>=L8,\"+\",\"-\")","v":"-"},{"$f":"IF(Z25=0,\"+\",\"-\")","v":"+"},{"$f":"IF(C27=AB11,\"-\",\"+\")","v":"-"},{"$f":"AH20","v":"NE"},null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J42:J45)","v":0},{"$f":"IF(Z20=0,0,W20*data!$AB$4)","v":0},null,{"$f":"IF(C20=$AB$6,$AC$6,IF(C20=$AB$7,$AC$7,IF(C20=$AB$8,$AC$8,IF(C20=$AB$9,$AC$9,\"chyba\"))))","v":0},null,{"$f":"IF(I20=\"-\",1,0)","v":0},{"$f":"IF(J20=\"-\",1,0)","v":0},{"$f":"IF(K20=\"-\",1,0)","v":1},{"$f":"IF(L20=\"-\",1,0)","v":0},{"$f":"IF(M20=\"-\",1,0)","v":1},{"$f":"SUM(AB20:AF20)","v":2},{"$f":"IF(AG20>0,\"NE\",\"ANO\")","v":"NE"}]
[null,"Okna a dveře východ","ponechat v původním stavu",null,"Dosažení dotace 40 %",null,"A.2",null,{"$f":"IF(J7<=M7,\"+\",\"-\")","v":"+"},{"$f":"IF(M13>J13,\"+\",\"-\")","v":"+"},{"$f":"IF(J8>=M8,\"+\",\"-\")","v":"-"},null,{"$f":"IF(C27=AB11,\"-\",\"+\")","v":"-"},"NE",null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J47:J50)","v":0},{"$f":"IF(Z21=0,0,W21*data!$AB$4)","v":0},null,0,null,0,0,1,0,1,2,"NE"]
[null,"Okna a dveře západ","ponechat v původním stavu",null,"Dosažení dotace 55 %",null,"A.3",null,{"$f":"IF(J7<=N7,\"+\",\"-\")","v":"+"},{"$f":"IF(N13>J13,\"+\",\"-\")","v":"+"},{"$f":"IF(J8>=N8,\"+\",\"-\")","v":"-"},null,{"$f":"IF(C27=AB11,\"-\",\"+\")","v":"-"},"NE",null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J52:J55)","v":0},{"$f":"IF(Z22=0,0,W22*data!$AB$4)","v":0},null,0,null,0,0,1,0,1,2,"NE"]
[null,"Střešní okna","ponechat v původním stavu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J57:J60)","v":0},{"$f":"IF(Z23=0,0,W23*data!$AB$4)","v":0},null,{"$f":"IF(C23=$AB$6,$AC$6,IF(C23=$AB$7,$AC$7,IF(C23=$AB$8,$AC$8,IF(C23=$AB$9,$AC$9,\"chyba\"))))","v":0},null,null,null,null,null,null,"dotace přidělena?",{"$f":"IF(COUNTIF(AH19:AH22,\"ANO\")>0,1,0)","v":0}]
[null,"Dveře do nevytápěného prostoru","ponechat v původním stavu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(vypocet!J61:J62)","v":0},{"$f":"IF(Z24=0,0,W24*data!AB6)","v":0},null,{"$f":"IF(C24=$AB$1,$AC$1,IF(C24=$AB$2,$AC$2,IF(C24=$AB$3,$AC$3,IF(C24=$AB$4,$AC$4,IF(C24=$AB$5,$AC$5,\"chyba\")))))","v":0}]
[null,null,null,null,"Maximální výše způsobilých výdajů:",null,null,"Kč s DPH",null,null,"Výše dotace max:",null,null,"Kč",null,null,null,null,null,null,null,null,null,{"$f":"SUM(X4:X24)","v":0},"kontrola U,95",{"$f":"COUNTIF(Z4:Z24,1)","v":0}]
[null,null,null,null,"Úprava stavebních konstrukcí",null,null,{"$f":"X25","v":0},null,null,"Úprava stavebních konstrukcí",null,null,{"$f":"IF($N$22=\"ANO\",0.55,IF($N$21=\"ANO\",0.4,IF(OR($N$20=\"ANO\",$N$19=\"ANO\"),0.3,0)))*H26","v":0},null,null,null,null,null,null,null,null,null,null,"kontrola větrání",{"$f":"IF(C27=$AB$11,$AC$11,IF(C27=$AB$12,$AC$12,IF(C27=$AB$13,$AC$13,\"chyba\")))","v":0}]
[null,"Větrání","pouze okny",null,"Dokumentace - posudek pro oblast A",null,null,{"$f":"IF(AH23=1,10000,0)","v":0},null,null,"Dokumentace",null,null,{"$f":"IF(AH23=1,H27,0)","v":0}]
[null,null,null,null,"Dozor na stavbě",null,null,{"$f":"IF(AH23=1,5000,0)","v":0},null,null,"Dozor na stavbě",null,null,{"$f":"IF(AH23=1,H28,0)","v":0}]
[null,null,null,null,"Celkem",null,null,{"$f":"SUM(H26:H28)","v":0},null,null,"Celkem",null,null,{"$f":"SUM(N26:N28)","v":0}]
[null,"Výměna neekologického zdroje tepla:","Bez výměny"]
[null,null,null,null,"Maximální výše způsobilých výdajů:",null,null,"Kč s DPH",null,null,"Výše dotace max.:",null,null,"Kč"]
[null,"Instalace solárního systému:","Žádný",null,"Instalace rekuperační jednotky",null,null,{"$f":"IF(C27=AB13,100000,0)","v":0},null,null,"Instalace rekuperační jednotky",null,null,{"$f":"IF(AH23=1,H32,0)","v":0}]
[null,null,null,null,"Výměna neekologického zdroje tepla",null,null,{"$f":"IF(AH23=1,data!AG26,data!AJ26)","v":0},null,null,{"$f":"E33","v":"Výměna neekologického zdroje tepla"},null,null,{"$f":"IF(J7<=150,IF(AH23=1,data!AE26,data!AH26),0)","v":0}]
[null,null,null,null,"Instalace solárního systému",null,null,{"$f":"data!AG31","v":0},null,null,{"$f":"E34","v":"Instalace solárního systému"},null,null,{"$f":"data!AE31","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Bonus za souběh opatření",null,null,{"$f":"IF(AND(N29>0,N34>0),10000,0)","v":0}]
[null,null,null,null,"Celkem",null,null,{"$f":"SUM(H32:H34)","v":0},null,null,"Celkem",null,null,{"$f":"SUM(N32:N35)","v":0}]
[]
[null,null,null,null,null,null,null,"Kč s DPH",null,null,null,null,null,"Kč"]
[null,null,null,null,"Maximální způsobilé náklady dle ZÚ",null,null,{"$f":"H29+H36","v":0},null,null,"Maximální výše dotace",null,null,{"$f":"N29+N36","v":0}]
[null,null,null,null,"Podíl dotace na způsobilých nákladech",null,null,{"$f":"IF(H39=0,\"\",N39/H39)","v":""},null,null,"Vlastní zdroje žadatele ",null,null,{"$f":"H39-N39","v":0}]
[null,null,null,null,"(Skutečné náklady projektu se mohou lišit podle místních podmínek).",null,null,null,null,null,"(do výše způsobilých nákladů)"]

{"sheet":"help","index":7,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Stavební konstrukce"]
["Plocha konstrukce se zadává pomocí rozměrů v metrech. Výsledek je v m2. Okna zadaná k dané konstrukci jsou od celkové plochy odečtena. Výpočet dále pracuje s hodnotou získanou po odečtení oken.","zpět"]
["Pokud není snadné zadat plochu pomocí násobení dvou rozměrů, lze ji zadat tak, že se do jednoho z rozměrů vloží vypočtená celková plocha a do druhého číslice 1."]
["Zadávají se pouze konstrukce mezi vytápěnou částí a venkovním prostředím nebo mezi vytápěnou a nevytápěnou částí budovy."]
["U konstrukcí nad vytápěným prostorem se uvádějí tyto části: střecha nebo strop k nevytápěné půdě. Pokud je střecha bez zateplení, zadává se pouze strop pod půdou.","zpět"]
["Kontrukce pod vytápěným prostorem mohou být buď podlaha na zemině nebo podlaha nad nevytápěným sklepem.","zpět"]
["V každé stěně se zadávají příslušná okna nebo dveře."]
["Existující zateplení předpokládá jako izolant polystyren nebo minerální vatu. Pro termoizolační omítku zadejte poloviční hodnotu.","zpět"]
["Do objemu budovy se vkládá vypočtený objem vytápěné části budovy včetně všech vnitřních konstrukcí. Pro jednoduchý tvar je možné použít kalkulačku.","zpět"]
["Zateplení na \"lepší než doporučenou hodnotu\" znamená splnění požadavku 0,95 * UR","zpět"]
["U zateplení konstrukcí se předpokládá, že i když je daná konstrukce ze dvou částí s různými výchozími vlastnostmi, opatření se provede pro celou konstrukci.","zpět"]

{"sheet":"vypocet","index":8,"n_rows":208,"n_cols":43,"rows_kept":208,"cut":false,"hidden":true,"merged":[]}
["Současný stav",null,null,null,null,null,null,null,null,null,null,null,null,"Referenční budova",null,null,null,null,null,null,null,null,"Nový stav"]
["výpočet Ht",null,"lanbda původní izolace",null,0.05,null,null,null,null,null,null,null,null,"výpočet Ht",null,5.5E-2,null,null,null,null,null,null,{"$f":"A2","v":"výpočet Ht"}]
["konstrukce","kód","popis","Uzáklad","zateplení","Rsi","Rse","Rpův","Ucelk","A","b","Ucelk*A*b",null,"konstrukce",null,null,"Unorm","A","b","Ucelk*A*b",null,null,{"$f":"A3","v":"konstrukce"},null,"A","opatření","U původní","U norm","U norm 0,95","U pas min","U pas max","U vybrané","b","U*A*b"]
[{"$f":"konstrukce!B4","v":"Severní stěna 1"},1,{"$f":"VLOOKUP(vypocet!B4,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B4,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G4","v":0},0.13,0.04,{"$f":"1/D4-F4-G4","v":0.42880239520958091},{"$f":"1/(F4+G4+(E4/100)/$E$2+H4)","v":1.67},{"$f":"konstrukce!M4","v":0},1,{"$f":"I4*J4*K4","v":0},null,{"$f":"A4","v":"Severní stěna 1"},null,null,0.3,{"$f":"J4","v":0},{"$f":"K4","v":1},{"$f":"Q4*R4*S4","v":0},null,null,"Severní stěna 1",null,{"$f":"R4","v":0},{"$f":"'navrh opatreni a vysledky'!Z4","v":"chyba"},{"$f":"I4","v":1.67},{"$f":"VLOOKUP(B4,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B4,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B4,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B4,data!$A$3:$G$23,7)","v":0.12},{"$f":"IF(Z4=0,AA4,IF(Z4=1,AB4,IF(Z4=2,AC4,IF(Z4=3,AD4,IF(Z4=4,AE4,\"chyba\")))))","v":"chyba"},{"$f":"S4","v":1},{"$f":"Y4*AF4*AG4","v":{"$error":"#VALUE!"}}]
[{"$f":"konstrukce!B5","v":"Severní stěna 2"},1,{"$f":"VLOOKUP(vypocet!B5,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B5,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G5","v":0},0.13,0.04,{"$f":"1/D5-F5-G5","v":0.42880239520958091},{"$f":"1/(F5+G5+(E5/100)/$E$2+H5)","v":1.67},{"$f":"konstrukce!M5","v":0},1,{"$f":"I5*J5*K5","v":0},null,"Severní stěna 2",null,null,0.3,0,1,{"$f":"Q5*R5*S5","v":0},null,null,"Severní stěna 2",null,{"$f":"R5","v":0},{"$f":"Z4","v":"chyba"},{"$f":"I5","v":1.67},{"$f":"VLOOKUP(B5,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B5,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B5,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B5,data!$A$3:$G$23,7)","v":0.12},{"$f":"IF(Z5=0,AA5,IF(Z5=1,AB5,IF(Z5=2,AC5,IF(Z5=3,AD5,IF(Z5=4,AE5,\"chyba\")))))","v":"chyba"},{"$f":"S5","v":1},{"$f":"Y5*AF5*AG5","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B7","v":"Jižní stěna 1"},1,{"$f":"VLOOKUP(vypocet!B7,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B7,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G7","v":0},0.13,0.04,{"$f":"1/D7-F7-G7","v":0.42880239520958091},{"$f":"1/(F7+G7+(E7/100)/$E$2+H7)","v":1.67},{"$f":"konstrukce!M7","v":0},1,0,null,"Jižní stěna 1",null,null,0.3,0,1,0,null,null,"Jižní stěna 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z5","v":0},1.67,{"$f":"VLOOKUP(B7,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B7,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B7,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B7,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[{"$f":"konstrukce!B8","v":"Jižní stěna 2"},1,{"$f":"VLOOKUP(vypocet!B8,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B8,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G8","v":0},0.13,0.04,0.42880239520958091,{"$f":"1/(F8+G8+(E8/100)/$E$2+H8)","v":1.67},{"$f":"konstrukce!M8","v":0},1,0,null,"Jižní stěna 2",null,null,0.3,0,1,0,null,null,"Jižní stěna 2",null,0,{"$f":"Z7","v":0},1.67,{"$f":"VLOOKUP(B8,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B8,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B8,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B8,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B10","v":"Východní stěna 1"},1,{"$f":"VLOOKUP(vypocet!B10,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B10,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G10","v":0},0.13,0.04,{"$f":"1/D10-F10-G10","v":0.42880239520958091},{"$f":"1/(F10+G10+(E10/100)/$E$2+H10)","v":1.67},{"$f":"konstrukce!M10","v":0},1,0,null,"Východní stěna 1",null,null,0.3,0,1,0,null,null,"Východní stěna 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z6","v":0},1.67,{"$f":"VLOOKUP(B10,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B10,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B10,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B10,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[{"$f":"konstrukce!B11","v":"Východní stěna 2"},1,{"$f":"VLOOKUP(vypocet!B11,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B11,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G11","v":0},0.13,0.04,{"$f":"1/D11-F11-G11","v":0.42880239520958091},{"$f":"1/(F11+G11+(E11/100)/$E$2+H11)","v":1.67},{"$f":"konstrukce!M11","v":0},1,0,null,"Východní stěna 2",null,null,0.3,0,1,0,null,null,"Východní stěna 2",null,0,{"$f":"Z10","v":0},1.67,{"$f":"VLOOKUP(B11,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B11,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B11,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B11,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B13","v":"Západní stěna 1"},1,{"$f":"VLOOKUP(vypocet!B13,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B13,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G13","v":0},0.13,0.04,{"$f":"1/D13-F13-G13","v":0.42880239520958091},{"$f":"1/(F13+G13+(E13/100)/$E$2+H13)","v":1.67},{"$f":"konstrukce!M13","v":0},1,0,null,"Západní stěna 1",null,null,0.3,0,1,0,null,null,"Západní stěna 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z7","v":0},1.67,{"$f":"VLOOKUP(B13,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B13,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B13,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B13,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[{"$f":"konstrukce!B14","v":"Západní stěna 2"},1,{"$f":"VLOOKUP(vypocet!B14,data!$A$3:$B$23,2)","v":"Cihly plné 30 cm"},{"$f":"VLOOKUP(B14,data!$A$3:$C$23,3)","v":1.67},{"$f":"konstrukce!G14","v":0},0.13,0.04,{"$f":"1/D14-F14-G14","v":0.42880239520958091},{"$f":"1/(F14+G14+(E14/100)/$E$2+H14)","v":1.67},{"$f":"konstrukce!M14","v":0},1,0,null,"Západní stěna 2",null,null,0.3,0,1,0,null,null,"Západní stěna 2",null,0,{"$f":"Z13","v":0},1.67,{"$f":"VLOOKUP(B14,data!$A$3:$G$23,4)","v":0.25},{"$f":"VLOOKUP(B14,data!$A$3:$G$23,5)","v":0.23749999999999999},{"$f":"VLOOKUP(B14,data!$A$3:$G$23,6)","v":0.18},{"$f":"VLOOKUP(B14,data!$A$3:$G$23,7)","v":0.12},1.67,1,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B17","v":"Podlaha na zemině 1"},1,{"$f":"VLOOKUP(vypocet!B17,data!$A$67:$B$68,2)","v":"Podlaha na terénu bez izolace"},{"$f":"VLOOKUP(B17,data!$A$67:$C$68,3)","v":1.7},null,0.17,null,{"$f":"1/D17-F17-G17","v":0.41823529411764704},{"$f":"1/(F17+G17+(E17/100)/$E$2+H17)","v":1.7},{"$f":"konstrukce!E17","v":0},0.5,0,null,"Podlaha na zemině 1",null,null,0.45,0,0.5,0,null,null,"Podlaha na zemině 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z9","v":0},1.7,{"$f":"VLOOKUP(B17,data!$A$67:$G$68,4)","v":0.3},{"$f":"VLOOKUP(B17,data!$A$67:$G$68,5)","v":0.28499999999999998},{"$f":"VLOOKUP(B17,data!$A$67:$G$68,6)","v":0.22},{"$f":"VLOOKUP(B17,data!$A$67:$G$68,7)","v":0.15},1.7,0.5,0]
[{"$f":"konstrukce!B18","v":"Podlaha na zemině 2"},1,{"$f":"VLOOKUP(vypocet!B18,data!$A$67:$B$68,2)","v":"Podlaha na terénu bez izolace"},{"$f":"VLOOKUP(B18,data!$A$67:$C$68,3)","v":1.7},null,0.17,null,{"$f":"1/D18-F18-G18","v":0.41823529411764704},{"$f":"1/(F18+G18+(E18/100)/$E$2+H18)","v":1.7},{"$f":"konstrukce!E18","v":0},0.5,0,null,"Podlaha na zemině 2",null,null,0.45,0,0.5,0,null,null,"Podlaha na zemině 2",null,0,{"$f":"Z17","v":0},1.7,{"$f":"VLOOKUP(B18,data!$A$67:$G$68,4)","v":0.3},{"$f":"VLOOKUP(B18,data!$A$67:$G$689,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B18,data!$A$67:$G$68,6)","v":0.22},{"$f":"VLOOKUP(B18,data!$A$67:$G$68,7)","v":0.15},1.7,0.5,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B20","v":"Podlaha nad nevytápěným sklepem 1"},1,{"$f":"VLOOKUP(vypocet!B20,data!$A$69:$B$70,2)","v":"Podlaha nad suterénem bez tep. izolace"},{"$f":"VLOOKUP(B20,data!$A$69:$C$70,3)","v":1.53},null,0.17,0.04,{"$f":"1/D20-F20-G20","v":0.44359477124183005},{"$f":"1/(F20+G20+(E20/100)/$E$2+H20)","v":1.53},{"$f":"konstrukce!E20","v":0},0.43,0,null,"Podlaha nad nevytápěným sklepem 1",null,null,0.6,0,0.43,0,null,null,"Podlaha nad nevytápěným sklepem 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z10","v":0},1.53,{"$f":"VLOOKUP(B20,data!$A$69:$G$70,4)","v":0.3},{"$f":"VLOOKUP(B20,data!$A$69:$G$70,5)","v":0.28499999999999998},{"$f":"VLOOKUP(B20,data!$A$69:$G$70,6)","v":0.22},{"$f":"VLOOKUP(B20,data!$A$69:$G$709,7)","v":0.6},1.53,0.43,0]
[{"$f":"konstrukce!B21","v":"Podlaha nad nevytápěným sklepem 2"},1,{"$f":"VLOOKUP(vypocet!B21,data!$A$69:$B$70,2)","v":"Podlaha nad suterénem bez tep. izolace"},{"$f":"VLOOKUP(B21,data!$A$69:$C$70,3)","v":1.53},null,0.17,0.04,{"$f":"1/D21-F21-G21","v":0.44359477124183005},{"$f":"1/(F21+G21+(E21/100)/$E$2+H21)","v":1.53},{"$f":"konstrukce!E21","v":0},0.43,0,null,"Podlaha nad nevytápěným sklepem 2",null,null,0.6,0,0.43,0,null,null,"Podlaha nad nevytápěným sklepem 2",null,0,{"$f":"Z20","v":0},1.53,{"$f":"VLOOKUP(B21,data!$A$69:$G$70,4)","v":0.3},{"$f":"VLOOKUP(B21,data!$A$69:$G$70,5)","v":0.28499999999999998},{"$f":"VLOOKUP(B21,data!$A$67:$G$79,6)","v":0.22},{"$f":"VLOOKUP(B21,data!$A$69:$G$70,7)","v":0.15},1.53,0.43,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B23","v":"Střechy a stropy"},null,null,null,null,null,null,null,null,null,null,0,null,"Střechy a stropy",null,null,null,0,0,0,null,null,"Střechy a stropy",null,0,null,null,null,null,null,null,null,0,0]
[{"$f":"konstrukce!B24","v":"Střecha plochá nebo do 45 ° 1"},3,{"$f":"VLOOKUP(vypocet!B24,data!A44:G47,2)","v":"Střecha šikmá - izolace mezi krokvemi"},{"$f":"VLOOKUP(B24,data!A44:G47,3)","v":1},{"$f":"konstrukce!G24","v":0},0.1,0.04,{"$f":"1/D24-F24-G24","v":0.86},{"$f":"1/(F24+G24+(E24/100)/$E$2+H24)","v":1},{"$f":"konstrukce!K24","v":0},1,0,null,"Střecha plochá nebo do 45 ° 1",null,null,0.24,{"$f":"J24","v":0},1,0,null,null,"Střecha plochá nebo do 45 ° 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z12","v":0},{"$f":"I24","v":1},{"$f":"VLOOKUP(B24,data!$A$44:$G$47,4)","v":0.16},{"$f":"VLOOKUP(B24,data!$A$44:$G$47,5)","v":0.152},{"$f":"VLOOKUP(B24,data!$A$44:$G$47,6)","v":0.15},{"$f":"VLOOKUP(B24,data!$A$44:$G$47,7)","v":0.1},1,1,0]
[{"$f":"konstrukce!B25","v":"Střecha plochá nebo do 45 ° 2"},3,{"$f":"VLOOKUP(vypocet!B25,data!A44:G47,2)","v":"Střecha šikmá - izolace mezi krokvemi"},{"$f":"VLOOKUP(B25,data!A44:G47,3)","v":1},{"$f":"konstrukce!G25","v":0},0.1,0.04,{"$f":"1/D25-F25-G25","v":0.86},{"$f":"1/(F25+G25+(E25/100)/$E$2+H25)","v":1},{"$f":"konstrukce!K25","v":0},1,0,null,"Střecha plochá nebo do 45 ° 2",null,null,0.24,{"$f":"J25","v":0},1,0,null,null,"Střecha plochá nebo do 45 ° 2",null,0,{"$f":"Z24","v":0},1,{"$f":"VLOOKUP(B25,data!$A$44:$G$47,4)","v":0.16},{"$f":"VLOOKUP(B25,data!$A$44:$G$47,5)","v":0.152},{"$f":"VLOOKUP(B25,data!$A$44:$G$47,6)","v":0.15},{"$f":"VLOOKUP(B25,data!$A$44:$G$47,7)","v":0.1},1,1,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B27","v":"Střecha šikmá nad 45 ° 1"},1,{"$f":"VLOOKUP(vypocet!B27,data!A50:G51,2)","v":"Střecha šikmá - izolace mezi krokvemi"},{"$f":"VLOOKUP(B27,data!A50:G51,3)","v":0.28000000000000003},{"$f":"konstrukce!G27","v":0},0.1,0.04,{"$f":"1/D27-F27-G27","v":3.4314285714285711},{"$f":"1/(F27+G27+(E27/100)/$E$2+H27)","v":0.28000000000000003},{"$f":"konstrukce!E27","v":0},1,0,null,"Střecha šikmá nad 45 ° 1",null,null,0.3,0,1,0,null,null,"Střecha šikmá nad 45 ° 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z13","v":0},{"$f":"I27","v":0.28000000000000003},{"$f":"VLOOKUP(B27,data!$A$50:$G$51,4)","v":0.2},{"$f":"VLOOKUP(B27,data!$A$50:$G$51,5)","v":0.19},{"$f":"VLOOKUP(B27,data!$A$50:$G$51,6)","v":0.18},{"$f":"VLOOKUP(B27,data!$A$50:$G$51,7)","v":0.12},0.28000000000000003,1,0]
[{"$f":"konstrukce!B28","v":"Střecha šikmá nad 45 ° 1"},1,{"$f":"VLOOKUP(vypocet!B28,data!A5:G50,2)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(B28,data!A50:G51,3)","v":0.28000000000000003},{"$f":"konstrukce!G28","v":0},0.1,0.04,{"$f":"1/D28-F28-G28","v":3.4314285714285711},{"$f":"1/(F28+G28+(E28/100)/$E$2+H28)","v":0.28000000000000003},{"$f":"konstrukce!E28","v":0},1,0,null,"Střecha šikmá nad 45 ° 1",null,null,0.3,0,1,0,null,null,"Střecha šikmá nad 45 ° 1",null,0,{"$f":"Z27","v":0},0.28000000000000003,{"$f":"VLOOKUP(B28,data!$A$50:$G$51,4)","v":0.2},{"$f":"VLOOKUP(B28,data!$A$50:$G$51,5)","v":0.19},{"$f":"VLOOKUP(B28,data!$A$50:$G$51,6)","v":0.18},{"$f":"VLOOKUP(B28,data!$A$50:$G$51,7)","v":0.12},0.28000000000000003,1,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B30","v":"Strop pod půdou 1"},1,{"$f":"VLOOKUP(vypocet!B30,data!A56:G57,2)","v":"Trámový strop"},{"$f":"VLOOKUP(B30,data!A56:G57,3)","v":0.99},{"$f":"konstrukce!G30","v":0},0.1,0.04,{"$f":"1/D30-F30-G30","v":0.87010101010101015},{"$f":"1/(F30+G30+(E30/100)/$E$2+H30)","v":0.99},{"$f":"konstrukce!E30","v":0},0.83,0,null,"Strop pod půdou 1",null,null,0.3,0,0.83,0,null,null,"Strop pod půdou 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z14","v":0},{"$f":"I30","v":0.99},{"$f":"VLOOKUP(B30,data!$A$56:$G$57,4)","v":0.2},{"$f":"VLOOKUP(B30,data!$A$56:$G$57,5)","v":0.19},{"$f":"VLOOKUP(B30,data!$A$56:$G$57,6)","v":0.15},{"$f":"VLOOKUP(B30,data!$A$56:$G$57,7)","v":0.1},0.99,0.83,0]
[{"$f":"konstrukce!B31","v":"Strop pod půdou 2"},1,{"$f":"VLOOKUP(vypocet!B31,data!A56:G57,2)","v":"Trámový strop"},{"$f":"VLOOKUP(B31,data!A56:G57,3)","v":0.99},{"$f":"konstrukce!G31","v":0},0.1,0.04,{"$f":"1/D31-F31-G31","v":0.87010101010101015},{"$f":"1/(F31+G31+(E31/100)/$E$2+H31)","v":0.99},{"$f":"konstrukce!E31","v":0},0.83,0,null,"Strop pod půdou 2",null,null,0.3,0,0.83,0,null,null,"Strop pod půdou 2",null,0,{"$f":"Z30","v":0},0.99,{"$f":"VLOOKUP(B31,data!$A$56:$G$57,4)","v":0.2},{"$f":"VLOOKUP(B31,data!$A$56:$G$57,5)","v":0.19},{"$f":"VLOOKUP(B31,data!$A$56:$G$57,6)","v":0.15},{"$f":"VLOOKUP(B31,data!$A$56:$G$57,7)","v":0.1},0.99,0.83,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
[{"$f":"konstrukce!B34","v":"Stěna k nevytápěnému prostoru 1"},15,{"$f":"VLOOKUP(vypocet!B34,data!$A$118:$B$138,2)","v":"Moderní děrované cihly 30 cm"},{"$f":"VLOOKUP(B34,data!$A$118:$C$138,3)","v":0.7},null,0.13,0.04,{"$f":"1/D34-F34-G34","v":1.2585714285714285},{"$f":"1/(F34+G34+(E34/100)/$E$2+H34)","v":0.70000000000000007},{"$f":"konstrukce!E34","v":0},0.49,0,null,"Stěna k nevytápěnému prostoru 1",null,null,0.6,0,0.49,0,null,null,"Stěna k nevytápěnému prostoru 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z16","v":0},{"$f":"I34","v":0.70000000000000007},{"$f":"VLOOKUP(B34,data!$A$118:$G$138,4)","v":0.4},{"$f":"VLOOKUP(B34,data!$A$13:$G$118,5)","v":0.38},{"$f":"VLOOKUP(B34,data!$A$13:$G$118,6)","v":0.3},{"$f":"VLOOKUP(B34,data!$A$13:$G$118,7)","v":0.2},0.70000000000000007,0.49,0]
[{"$f":"konstrukce!B35","v":"Stěna k nevytápěnému prostoru 2"},1,{"$f":"VLOOKUP(vypocet!B35,data!$A$118:$B$138,2)","v":"Cihly plné 10 cm"},{"$f":"VLOOKUP(B35,data!$A$118:$C$138,3)","v":2.87},null,0.13,0.04,{"$f":"1/D35-F35-G35","v":0.17843205574912888},{"$f":"1/(F35+G35+(E35/100)/$E$2+H35)","v":2.87},{"$f":"konstrukce!E35","v":0},0.49,0,null,"Stěna k nevytápěnému prostoru 2",null,null,0.6,0,0.49,0,null,null,"Stěna k nevytápěnému prostoru 2",null,0,{"$f":"Z34","v":0},2.87,{"$f":"VLOOKUP(B35,data!$A$118:$G$138,4)","v":0.4},{"$f":"VLOOKUP(B35,data!$A$13:$G$118,5)","v":0.28499999999999998},{"$f":"VLOOKUP(B35,data!$A$13:$G$118,6)","v":0.22},{"$f":"VLOOKUP(B35,data!$A$13:$G$118,7)","v":0.15},2.87,0.49,0]
[null,null,null,null,null,null,null,null,null,null,null,0,"korekce dveře",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"korekce dveře",null,"výměna oken"]
["Sever okno 11",3,{"$f":"VLOOKUP(vypocet!B37,data!$A$93:$B$110,2)","v":"okno zdvojené (sešroubované rámy) s dvěma skly"},{"$f":"VLOOKUP(B37,data!$A$93:$C$103,3)","v":2.4},null,null,null,null,{"$f":"D37","v":2.4},{"$f":"konstrukce!I4","v":0},1,0,{"$f":"IF(OR(B37=8,B37=11),-J37,0)","v":0},{"$f":"A37","v":"Sever okno 11"},null,null,1.5,{"$f":"J37","v":0},{"$f":"K37","v":1},0,null,null,"Sever okno 11",null,0,{"$f":"'navrh opatreni a vysledky'!Z19","v":0},{"$f":"I37","v":2.4},{"$f":"VLOOKUP(B37,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B37,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B37,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B37,data!$A$93:$G$103,7)","v":0.6},2.4,1,0,{"$f":"M37","v":0},null,{"$f":"IF(Z37>0,1,0)","v":0}]
["Sever okno 12",3,{"$f":"VLOOKUP(vypocet!B38,data!$A$93:$B$110,2)","v":"okno zdvojené (sešroubované rámy) s dvěma skly"},{"$f":"VLOOKUP(B38,data!$A$93:$C$103,3)","v":2.4},null,null,null,null,{"$f":"D38","v":2.4},{"$f":"konstrukce!K4","v":0},1,0,{"$f":"IF(OR(B38=8,B38=11),-J38,0)","v":0},"Sever okno 12",null,null,1.5,0,1,0,null,null,"Sever okno 12",null,0,{"$f":"Z37","v":0},2.4,{"$f":"VLOOKUP(B38,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B38,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B38,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B38,data!$A$93:$G$103,7)","v":0.6},2.4,1,0,{"$f":"M38","v":0},null,{"$f":"IF(Z38>0,1,0)","v":0}]
["Sever okno 21",1,{"$f":"VLOOKUP(vypocet!B39,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B39,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I5","v":0},1,0,0,"Sever okno 21",null,null,1.5,0,1,0,null,null,"Sever okno 21",null,0,{"$f":"Z37","v":0},4.5,{"$f":"VLOOKUP(B39,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B39,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B39,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B39,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Sever okno 22",1,{"$f":"VLOOKUP(vypocet!B40,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B40,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!K5","v":0},1,0,0,"Sever okno 22",null,null,1.5,0,1,0,null,null,"Sever okno 22",null,0,{"$f":"Z37","v":0},4.5,{"$f":"VLOOKUP(B40,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B40,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B40,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B40,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Jih okno 11",3,{"$f":"VLOOKUP(vypocet!B42,data!$A$93:$B$110,2)","v":"okno zdvojené (sešroubované rámy) s dvěma skly"},{"$f":"VLOOKUP(B42,data!$A$93:$C$103,3)","v":2.4},null,null,null,null,{"$f":"D42","v":2.4},{"$f":"konstrukce!I7","v":0},1,0,0,"Jih okno 11",null,null,1.5,0,1,0,null,null,"Jih okno 11",null,0,{"$f":"'navrh opatreni a vysledky'!Z20","v":0},{"$f":"I42","v":2.4},{"$f":"VLOOKUP(B42,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B42,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B42,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B42,data!$A$93:$G$103,7)","v":0.6},2.4,1,0,0,null,0]
["Jih okno 12",1,{"$f":"VLOOKUP(vypocet!B43,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B43,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,{"$f":"D43","v":4.5},{"$f":"konstrukce!K7","v":0},1,0,0,"Jih okno 12",null,null,1.5,0,1,0,null,null,"Jih okno 12",null,0,{"$f":"Z42","v":0},4.5,{"$f":"VLOOKUP(B43,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B43,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B43,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B43,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Jih okno 21",1,{"$f":"VLOOKUP(vypocet!B44,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B44,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I8","v":0},1,0,0,"Jih okno 21",null,null,1.5,0,1,0,null,null,"Jih okno 21",null,0,{"$f":"Z42","v":0},4.5,{"$f":"VLOOKUP(B44,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B44,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B44,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B44,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Jih okno 22",1,{"$f":"VLOOKUP(vypocet!B45,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B45,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!K8","v":0},1,0,0,"Jih okno 22",null,null,1.5,0,1,0,null,null,"Jih okno 22",null,0,{"$f":"Z42","v":0},4.5,{"$f":"VLOOKUP(B45,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B45,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B45,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B45,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Východ okno 11",3,{"$f":"VLOOKUP(vypocet!B47,data!$A$93:$B$110,2)","v":"okno zdvojené (sešroubované rámy) s dvěma skly"},{"$f":"VLOOKUP(B47,data!$A$93:$C$103,3)","v":2.4},null,null,null,null,{"$f":"D47","v":2.4},{"$f":"konstrukce!I10","v":0},1,0,0,"Východ okno 11",null,null,1.5,0,1,0,null,null,"Východ okno 11",null,0,{"$f":"'navrh opatreni a vysledky'!Z21","v":0},{"$f":"I47","v":2.4},{"$f":"VLOOKUP(B47,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B47,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B47,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B47,data!$A$93:$G$103,7)","v":0.6},2.4,1,0,0,null,0]
["Východ okno 12",1,{"$f":"VLOOKUP(vypocet!B48,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B48,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,{"$f":"D48","v":4.5},{"$f":"konstrukce!K10","v":0},1,0,0,"Východ okno 12",null,null,1.5,0,1,0,null,null,"Východ okno 12",null,0,{"$f":"Z47","v":0},4.5,{"$f":"VLOOKUP(B48,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B48,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B48,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B48,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Východ okno 21",1,{"$f":"VLOOKUP(vypocet!B49,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B49,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I11","v":0},1,0,0,"Východ okno 21",null,null,1.5,0,1,0,null,null,"Východ okno 21",null,0,{"$f":"Z47","v":0},4.5,{"$f":"VLOOKUP(B49,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B49,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B49,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B49,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Východ okno 22",1,{"$f":"VLOOKUP(vypocet!B50,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B50,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!K11","v":0},1,0,0,"Východ okno 22",null,null,1.5,0,1,0,null,null,"Východ okno 22",null,0,{"$f":"Z47","v":0},4.5,{"$f":"VLOOKUP(B50,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B50,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B50,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B50,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0,0]
["Západ okno 11",3,{"$f":"VLOOKUP(vypocet!B52,data!$A$93:$B$110,2)","v":"okno zdvojené (sešroubované rámy) s dvěma skly"},{"$f":"VLOOKUP(B52,data!$A$93:$C$103,3)","v":2.4},null,null,null,null,{"$f":"D52","v":2.4},{"$f":"konstrukce!I13","v":0},1,0,0,"Západ okno 11",null,null,1.5,0,1,0,null,null,"Západ okno 11",null,0,{"$f":"'navrh opatreni a vysledky'!Z22","v":0},2.4,{"$f":"VLOOKUP(B52,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B52,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B52,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B52,data!$A$93:$G$103,7)","v":0.6},2.4,1,0,0,null,0]
["Západ okno 12",8,{"$f":"VLOOKUP(vypocet!B53,data!$A$93:$B$110,2)","v":"dveře dřevěné vchodové plné"},{"$f":"VLOOKUP(B53,data!$A$93:$C$103,3)","v":2.2999999999999998},null,null,null,null,{"$f":"D53","v":2.2999999999999998},{"$f":"konstrukce!K13","v":0},1,0,0,"Západ okno 12",null,null,1.5,0,1,0,null,null,"Západ okno 12",null,0,{"$f":"Z52","v":0},2.2999999999999998,{"$f":"VLOOKUP(B53,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B53,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B53,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B53,data!$A$93:$G$103,7)","v":0.6},2.2999999999999998,1,0,0,null,0]
["Západ okno 21",1,{"$f":"VLOOKUP(vypocet!B54,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B54,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I14","v":0},1,0,0,"Západ okno 21",null,null,1.5,0,1,0,null,null,"Západ okno 21",null,0,{"$f":"Z52","v":0},4.5,{"$f":"VLOOKUP(B54,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B54,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B54,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B54,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
["Západ okno 22",1,{"$f":"VLOOKUP(vypocet!B55,data!$A$93:$B$110,2)","v":"okno jednoduché s jedním sklem"},{"$f":"VLOOKUP(B55,data!$A$93:$C$103,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!K14","v":0},1,0,0,"Západ okno 22",null,null,1.5,0,1,0,null,null,"Západ okno 22",null,0,{"$f":"Z52","v":0},4.5,{"$f":"VLOOKUP(B55,data!$A$93:$G$103,4)","v":1.2},{"$f":"VLOOKUP(B55,data!$A$93:$G$103,5)","v":1.1399999999999999},{"$f":"VLOOKUP(B55,data!$A$93:$G$103,6)","v":0.8},{"$f":"VLOOKUP(B55,data!$A$93:$G$103,7)","v":0.6},4.5,1,0,0,null,0]
[null,null,null,null,null,null,null,null,null,null,null,0]
["Střešní okno 1",1,{"$f":"VLOOKUP(vypocet!B57,data!$A$104:$B$110,2)","v":"okno střešní jednoduché s jedním sklem"},{"$f":"VLOOKUP(B57,data!$A$104:$C$107,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I27","v":0},1,0,null,"Střešní okno 1",null,null,1.4,0,1,0,null,null,"Střešní okno 1",null,0,{"$f":"'navrh opatreni a vysledky'!Z23","v":0},4.5,{"$f":"VLOOKUP(B57,data!$A$104:$G$110,4)","v":1.1000000000000001},{"$f":"VLOOKUP(B57,data!$A$104:$G$110,5)","v":1.0449999999999999},{"$f":"VLOOKUP(B57,data!$A$104:$G$110,6)","v":0.9},{"$f":"VLOOKUP(B57,data!$A$104:$G$110,7)","v":0.9},4.5,1,0,null,null,0]
["Střešní okno 2",1,{"$f":"VLOOKUP(vypocet!B58,data!$A$104:$B$110,2)","v":"okno střešní jednoduché s jedním sklem"},{"$f":"VLOOKUP(B58,data!$A$104:$C$107,3)","v":4.5},null,null,null,null,4.5,{"$f":"konstrukce!I28","v":0},1,0,null,"Střešní okno 2",null,null,1.4,0,1,0,null,null,"Střešní okno 2",null,0,{"$f":"Z57","v":0},4.5,{"$f":"VLOOKUP(B58,data!$A$104:$G$110,4)","v":1.1000000000000001},{"$f":"VLOOKUP(B58,data!$A$104:$G$110,5)","v":1.0449999999999999},{"$f":"VLOOKUP(B58,data!$A$104:$G$110,6)","v":0.9},{"$f":"VLOOKUP(B58,data!$A$104:$G$110,7)","v":0.9},4.5,1,0,null,null,0]
["Střešní okno 3",3,{"$f":"VLOOKUP(vypocet!B59,data!$A$104:$B$110,2)","v":"okno střešní zdvojené s dvěma skly"},{"$f":"VLOOKUP(B59,data!$A$104:$C$107,3)","v":2.4},null,null,null,null,2.4,{"$f":"konstrukce!$I$24","v":0},1,0,null,"Střešní okno 3",null,null,1.4,0,1,0,null,null,"Střešní okno 3",null,0,{"$f":"Z57","v":0},2.4,{"$f":"VLOOKUP(B59,data!$A$104:$G$110,4)","v":1.1000000000000001},{"$f":"VLOOKUP(B59,data!$A$104:$G$110,5)","v":1.0449999999999999},{"$f":"VLOOKUP(B59,data!$A$104:$G$110,6)","v":0.9},{"$f":"VLOOKUP(B59,data!$A$104:$G$110,7)","v":0.9},2.4,1,0,null,null,0]
["Střešní okno 4",3,{"$f":"VLOOKUP(vypocet!B60,data!$A$104:$B$110,2)","v":"okno střešní zdvojené s dvěma skly"},{"$f":"VLOOKUP(B60,data!$A$104:$C$107,3)","v":2.4},null,null,null,null,2.4,{"$f":"konstrukce!$I$25","v":0},1,0,null,"Střešní okno 4",null,null,1.4,0,1,0,null,null,"Střešní okno 4",null,0,{"$f":"Z57","v":0},2.4,{"$f":"VLOOKUP(B60,data!$A$104:$G$110,4)","v":1.1000000000000001},{"$f":"VLOOKUP(B60,data!$A$104:$G$110,5)","v":1.0449999999999999},{"$f":"VLOOKUP(B60,data!$A$104:$G$110,6)","v":0.9},{"$f":"VLOOKUP(B60,data!$A$104:$G$110,7)","v":0.9},2.4,1,0,null,null,0]
["Dveře do nevyt. prostoru",1,{"$f":"VLOOKUP(vypocet!B61,data!$A$140:$B$141,2)","v":"Dveře vnitřní plné"},{"$f":"VLOOKUP(B61,data!$A$140:$C$141,3)","v":2},null,null,null,null,{"$f":"D61","v":2},{"$f":"konstrukce!G34","v":0},0.6,0,null,"Dveře do nevyt. prostoru",null,null,2,0,0.6,0,null,null,"Dveře do nevyt. prostoru",null,0,{"$f":"'navrh opatreni a vysledky'!Z24","v":0},2,{"$f":"VLOOKUP(B61,data!$A$140:$G$141,4)","v":2.2999999999999998},{"$f":"VLOOKUP(B61,data!$A$140:$G$141,5)","v":2.1849999999999996},{"$f":"VLOOKUP(B61,data!$A$140:$G$141,6)","v":1.7},{"$f":"VLOOKUP(B61,data!$A$140:$G$141,7)","v":1.7},2,0.6,0]
["Dveře do nevyt. prostoru",1,{"$f":"VLOOKUP(vypocet!B62,data!$A$140:$B$141,2)","v":"Dveře vnitřní plné"},{"$f":"VLOOKUP(B62,data!$A$140:$C$141,3)","v":2},null,null,null,null,2,{"$f":"konstrukce!G35","v":0},0.6,0,null,"Dveře do nevyt. prostoru",null,null,2,0,0.6,0,null,null,"Dveře do nevyt. prostoru",null,0,{"$f":"Z61","v":0},{"$f":"I62","v":2},{"$f":"VLOOKUP(B62,data!$A$140:$G$141,4)","v":2.2999999999999998},{"$f":"VLOOKUP(B62,data!$A$140:$G$141,5)","v":2.1849999999999996},{"$f":"VLOOKUP(B62,data!$A$140:$G$141,6)","v":1.7},{"$f":"VLOOKUP(B62,data!$A$140:$G$141,7)","v":1.7},2,0.6,0]
["suma A",null,null,null,null,null,null,null,null,{"$f":"SUM(J4:J62)","v":0},null,null,null,"suma A",null,null,null,{"$f":"J63","v":0},null,null,null,null,"suma A",null,{"$f":"SUM(Y4:Y62)","v":0},null,null,null,null,null,null,null,null,0,null,null,{"$f":"COUNTIF(AK37:AK62,1)","v":0},"počet vyměněných oken"]
["tepelné mosty",null,null,null,"delta U",null,null,null,0.1,{"$f":"SUM(J4:J62)","v":0},null,{"$f":"I64*J64","v":0},null,"tepelné mosty",null,"delta U",0.02,{"$f":"SUM(R4:R36)","v":0},null,{"$f":"Q64*R64","v":0},null,null,"tepelné mosty",null,null,null,"delta U",null,null,null,{"$f":"0.1-(0.1-0.02)*AK65","v":0.1},{"$f":"Y63","v":0},null,{"$f":"AE64*AF64","v":0},null,null,{"$f":"COUNT(AK37:AK60)","v":20},"celkem"]
["HT",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(L4:L64)","v":0},null,"HT",null,null,null,null,null,{"$f":"SUM(T4:T64)","v":0},null,null,"HT",null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AH4:AH64)","v":{"$error":"#VALUE!"}},null,null,{"$f":"AK63/AK64","v":0},"podíl měněných"]
["Ht",{"$f":"L65","v":0},"W/K",null,null,null,null,null,null,null,null,null,null,"Ht",{"$f":"T65","v":0},"W/K",null,null,null,null,null,null,"Ht",{"$f":"AH65","v":{"$error":"#VALUE!"}},"W/K"]
["HV",null,null,null,null,null,null,null,null,null,null,null,null,"UemR",{"$f":"IF(O66/R63<0.5,O66/R63,0.5)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,"UemR",{"$f":"IF(X66/Y63<0.5,X66/Y63,0.5)","v":{"$error":"#VALUE!"}}]
["objem vzduchu v zóně",{"$f":"'ostatni vstupy'!D3*D68","v":0},"m3",0.8,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"A68","v":"objem vzduchu v zóně"},{"$f":"B68","v":0}]
["větrací tok",0.3,"h-1",null,null,null,null,null,null,null,null,null,null,"Upožadavek dotace","stěna vnější, střecha nad 45 - lehká",0.2,0.3,null,null,null,null,null,"větrací tok",{"$f":"B69","v":0.3},{"$f":"C69","v":"h-1"}]
["větrací tok",{"$f":"B68*B69","v":0},"m3/h",null,null,null,null,null,null,null,null,null,null,null,"stěna vnější, střecha nad 45 - těžká",0.25,0.38,null,null,null,null,null,"větrací tok",{"$f":"X68*X69","v":0},"m3/h","rekuperace",{"$f":"IF('navrh opatreni a vysledky'!C27='navrh opatreni a vysledky'!AB13,1,0)","v":0},0.75]
["HV",{"$f":"0.34*B70","v":0},"W/K",null,null,null,null,null,null,null,null,null,null,null,"střecha plochá a šikmá do 45",0.16,0.24,null,null,null,null,null,"HV",{"$f":"IF(AA70=0,0.34*X70,0.34*X70*(1-AB70))","v":0},"W/K"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"strop s podlahou nad venkovním prostorem",0.16,0.24,null,null,null,null,null,0]
["HC",{"$f":"B71+L65","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"strop pod nevyt. půdou (se střechou bez tepelné izolace)",0.2,0.3,null,null,null,null,null,"HC",0]
["tis",20,"°C",null,null,null,null,null,null,null,null,null,null,null,"podlaha a stěna k zemině (vyt prostor)",0.3,0.45,null,null,null,null,null,"tis",20,"°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"strop a stěna z vyt. do nevyt.",0.4,0.6,null,null,null,null,null,0]
["Celková podlahová plocha",{"$f":"'ostatni vstupy'!D19","v":0},"m2","stanovená z vnějších rozměrů",null,null,null,null,null,null,null,null,null,null,"stěna k sousednímu objektu",0.75,1.05,null,null,null,null,null,"Celková podlahová plocha",{"$f":"B76","v":0},{"$f":"C76","v":"m2"},{"$f":"D76","v":"stanovená z vnějších rozměrů"}]
["Počet osob",{"$f":"B76/40","v":0},"osob","40 m2/os z vnějších rozměrů",null,null,null,null,null,null,null,null,null,null,"volné",0,0,null,null,null,null,null,"Počet osob",0,"osob","40 m2/os z vnějších rozměrů"]
["redukce na vnitřní plochu",{"$f":"C78*B76","v":0},0.9,null,null,null,null,null,null,null,null,null,null,null,"volné",0,0,null,null,null,null,null,"redukce na vnitřní plochu",{"$f":"Y78*X76","v":0},0.9]
["Uem",{"$f":"B66/J63","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,"volné",0,0,null,null,null,null,null,"Uem",{"$f":"X66/AF64","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"volné",0,0]
[]
["Měrná tepelná ztráta",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Měrná tepelná ztráta"]
[]
[null,null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,null,null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Celková měrná zráta ",null,null,null,null,"H","W/K",null,{"$f":"B73","v":0},{"$f":"I85","v":0},{"$f":"J85","v":0},0,0,0,0,0,0,0,0,0,0,null,"Celková měrná zráta ",null,null,null,null,"H","W/K",null,{"$f":"X73","v":0},{"$f":"AE85","v":0},{"$f":"AF85","v":0},{"$f":"AG85","v":0},{"$f":"AH85","v":0},{"$f":"AI85","v":0},{"$f":"AJ85","v":0},{"$f":"AK85","v":0},{"$f":"AL85","v":0},{"$f":"AM85","v":0},{"$f":"AN85","v":0},{"$f":"AO85","v":0},{"$f":"AP85","v":0}]
["Venkovní výpočtová teplota pro ztrátu",null,null,null,null,"Te","°C",null,-12,null,null,null,null,null,null,null,null,null,null,null,null,null,"Venkovní výpočtová teplota pro ztrátu",null,null,null,null,"Te","°C",null,-12]
["Výpočtová tepelná ztráta - výběr PVSO, PVNO, HV, NV",null,null,null,null,null,"kW",null,{"$f":"I85*($B$74-$M$892)/1000","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Výpočtová tepelná ztráta - výběr PVSO, PVNO, HV, NV",null,null,null,null,null,"kW",null,{"$f":"AE85*($B$74-$M$892)/1000","v":0}]
["Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,"Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Délka",null,null,null,null,"t","[dny]",null,{"$f":"SUM(J89:U89)","v":365},31,28,31,30,31,30,31,31,30,31,30,31,null,"Délka",null,null,null,null,"t","[dny]",null,{"$f":"SUM(AF89:AQ89)","v":365},31,28,31,30,31,30,31,31,30,31,30,31]
["Počet hodin",null,null,null,null,"t","[h]",null,{"$f":"24*I89","v":8760},{"$f":"24*J89","v":744},{"$f":"24*K89","v":672},{"$f":"24*L89","v":744},{"$f":"24*M89","v":720},{"$f":"24*N89","v":744},720,744,744,720,744,720,744,null,"Počet hodin",null,null,null,null,"t","[h]",null,{"$f":"24*AE89","v":8760},{"$f":"24*AF89","v":744},{"$f":"24*AG89","v":672},{"$f":"24*AH89","v":744},{"$f":"24*AI89","v":720},{"$f":"24*AJ89","v":744},720,744,744,720,744,720,744]
["Průměrná venkovní teplota",null,null,null,null,"Te","[°C]",null,null,{"$f":"data!N3","v":-1},{"$f":"data!O3","v":1},{"$f":"data!P3","v":4},{"$f":"data!Q3","v":9},{"$f":"data!R3","v":14.6},{"$f":"data!S3","v":17},{"$f":"data!T3","v":18.2},{"$f":"data!U3","v":18.8},{"$f":"data!V3","v":13.8},{"$f":"data!W3","v":9.4},{"$f":"data!X3","v":4},{"$f":"data!Y3","v":-0.5},null,"Průměrná venkovní teplota",null,null,null,null,"Te","[°C]",null,null,{"$f":"data!N3","v":-1},{"$f":"data!O3","v":1},{"$f":"data!P3","v":4},{"$f":"data!Q3","v":9},{"$f":"data!R3","v":14.6},{"$f":"data!S3","v":17},{"$f":"data!T3","v":18.2},{"$f":"data!U3","v":18.8},{"$f":"data!V3","v":13.8},{"$f":"data!W3","v":9.4},{"$f":"data!X3","v":4},{"$f":"data!Y3","v":-0.5}]
["Teplotní rozdíl",null,null,null,null,"Dte","[°C]",null,null,{"$f":"$B$74-J91","v":21},19,16,11,5.4,3,1.8000000000000007,1.1999999999999993,6.1999999999999993,10.6,16,20.5,null,"Teplotní rozdíl",null,null,null,null,"Dte","[°C]",null,null,{"$f":"$B$74-AF91","v":21},19,16,11,5.4,3,1.8000000000000007,1.1999999999999993,6.1999999999999993,10.6,16,20.5]
[]
["Suma tepelných ztrát prostupem tepla",null,null,null,null,"Qt","[kWh]",null,{"$f":"SUM(J94:U94)","v":0},{"$f":"IF(J91>$B$74,0,0.001*$B$66*J92*J90)","v":0},{"$f":"IF(K91>$B$74,0,0.001*$B$66*K92*K90)","v":0},0,0,0,0,0,0,0,0,0,0,null,"Suma tepelných ztrát prostupem tepla",null,null,null,null,"Qt","[kWh]",null,{"$f":"SUM(AF94:AQ94)","v":{"$error":"#VALUE!"}},{"$f":"IF(AF91>$X$74,0,0.001*$X$66*AF92*AF90)","v":{"$error":"#VALUE!"}},{"$f":"IF(AG91>$X$74,0,0.001*$X$66*AG92*AG90)","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Suma tepelných ztrát budovy / rok na ohřev větracího vzduchu - NV výběr TNI 730330 nebo ČSN EN ISO 13790",null,null,null,null,"Qnv","[kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suma tepelných ztrát budovy / rok na ohřev větracího vzduchu - NV výběr TNI 730330 nebo ČSN EN ISO 13790",null,null,null,null,"Qnv","[kWh]"]
["Suma tepelných ztrát budovy / rok na ohřev vzd. pr. netěsnostmi - NV výběr TNI 730330 nebo ČSN EN ISO 13790",null,null,null,null,"Qnv","[kWh]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suma tepelných ztrát budovy / rok na ohřev vzd. pr. netěsnostmi - NV výběr TNI 730330 nebo ČSN EN ISO 13790",null,null,null,null,"Qnv","[kWh]"]
["Suma tepelných ztrát větráním",null,null,null,null,"Qv","[kWh]",null,{"$f":"SUM(J98:U98)","v":0},{"$f":"IF(J91>$B$74,0,0.001*$B$71*J92*$J$90)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Suma tepelných ztrát větráním",null,null,null,null,"Qv","[kWh]",null,{"$f":"SUM(AF98:AQ98)","v":0},{"$f":"IF(AF91>$X$74,0,0.001*$X$71*AF92*$J$90)","v":0},{"$f":"IF(AG91>$X$74,0,0.001*$X$71*AG92*$J$90)","v":0},0,0,0,0,0,0,0,0,0,0]
[]
["Suma tepelných ztrát budovy / rok  - výběr PVSO, PVNO, HV, NV",null,null,null,null,"Ql","[kWh]",null,{"$f":"SUM(J100:U100)","v":0},{"$f":"J94+J98","v":0},{"$f":"K94+K98","v":0},0,0,0,0,0,0,0,0,0,0,null,"Suma tepelných ztrát budovy / rok  - výběr PVSO, PVNO, HV, NV",null,null,null,null,"Ql","[kWh]",null,{"$f":"SUM(AF100:AQ100)","v":{"$error":"#VALUE!"}},{"$f":"AF94+AF98","v":{"$error":"#VALUE!"}},{"$f":"AG94+AG98","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Suma tepelných ztrát budovy / rok - výběr PVSO, PVNO, HV, NV",null,null,null,null,"Ql","[GJ]",null,{"$f":"I100/(1000/3.6)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Suma tepelných ztrát budovy / rok - výběr PVSO, PVNO, HV, NV",null,null,null,null,"Ql","[GJ]",null,{"$f":"AE100/(1000/3.6)","v":{"$error":"#VALUE!"}}]
[]
["Tepelné zisky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tepelné zisky"]
["Časová konstanta zóny",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Časová konstanta zóny"]
["Tepelná kapacita na 1m2",null,null,null,null,"C","kJ/m2/K",null,165,null,null,null,null,null,null,null,null,null,null,null,null,null,"Tepelná kapacita na 1m2",null,null,null,null,"C","kJ/m2/K",null,165]
["Celková tepelná kapacita",null,null,null,null,"C","kJ/K",null,{"$f":"I105*B76","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Celková tepelná kapacita",null,null,null,null,"C","kJ/K",null,{"$f":"AE105*X76","v":0}]
["Celková tepelná kapacita",null,null,null,null,"C","[Wh/K]",null,{"$f":"I106/3.6","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Celková tepelná kapacita",null,null,null,null,"C","[Wh/K]",null,{"$f":"AE106/3.6","v":0}]
["Časová konstanta zóny - výběr PV, NV",null,null,null,null,"t","[hod]",null,{"$f":"I107/I85","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Časová konstanta zóny - výběr PV, NV",null,null,null,null,"t","[hod]",null,{"$f":"AE107/AE85","v":{"$error":"#DIV/0!"}}]
[]
["Vnitřní tepelné zisky dle TNI 73 0330",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vnitřní tepelné zisky dle TNI 73 0330"]
["osoby a vybavení",null,null,null,null,null,"[W]",null,{"$f":"B78*(1.5*0.7+3*0.2)","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"osoby a vybavení",null,null,null,null,null,"[W]",null,{"$f":"X78*(1.5*0.7+3*0.2)","v":0}]
[null,null,null,null,null,null,null,null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,1]
["osvětlení",null,null,null,null,null,"[W]",null,{"$f":"4500*0.85/I151*B78","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"osvětlení",null,null,null,null,null,"[W]",null,{"$f":"4500*0.85/AE151*X78","v":0}]
["Vnitřní zisky - stálá produkce bez ohledu na obsazenost",null,null,null,null,null,"[W]",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vnitřní zisky - stálá produkce bez ohledu na obsazenost",null,null,null,null,null,"[W]"]
["Celkové vnitřní tepelné zisky",null,null,null,null,"Fi","[W]",null,{"$f":"I113+I111","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Celkové vnitřní tepelné zisky",null,null,null,null,"Fi","[W]",null,{"$f":"AE113+AE111","v":0}]
[]
["Vnitřní tepelné zisky použité ve výpočtu",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vnitřní tepelné zisky použité ve výpočtu"]
[null,null,null,null,null,null,"[W]",null,{"$f":"I115","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"[W]",null,{"$f":"AE115","v":0}]
["Solární tepelné zisky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solární tepelné zisky"]
["Plocha oken (čistá)",null,null,null,null,null,"m2",null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Plocha oken (čistá)",null,null,null,null,null,"m2",null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,{"$f":"konstrukce!I4+konstrukce!I5+konstrukce!K4+konstrukce!K5+SUM(M37:M40)","v":0},{"$f":"konstrukce!I7+konstrukce!I8+konstrukce!K7+konstrukce!K8+SUM(M42:M45)","v":0},{"$f":"konstrukce!I10+konstrukce!I11+konstrukce!K10+konstrukce!K11+SUM(M47:M50)","v":0},{"$f":"konstrukce!I13+konstrukce!I14+konstrukce!K14+SUM(M52:M55)","v":0},{"$f":"konstrukce!I27+konstrukce!I28","v":0},null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,{"$f":"I121","v":0},{"$f":"J121","v":0},0,{"$f":"L121","v":0},0]
[]
["Korekční činitel zasklení",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Korekční činitel zasklení",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,0.7,0.7,0.7,0.7,0.75,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,0.75,0.75,0.75,0.75,0.75]
[]
["Korekční činitel stínění horizontem",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Korekční činitel stínění horizontem",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,0.7,0.7,0.7,0.7,1,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1]
[]
["Úhel stínění markýzou °",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Úhel stínění markýzou °",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1]
[]
["Korekční činitel stínění markýzou °",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Korekční činitel stínění markýzou °",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1]
[]
["Úhel stínění bočním žebrem °",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Úhel stínění bočním žebrem °",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1]
[]
["Korekční činitel stínění bočním žebrem °",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Korekční činitel stínění bočním žebrem °",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,1,1,1,1,1]
[]
["Celková propustnost solárního záření",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Celková propustnost solárního záření",null,null,null,null,null,null,null,"S","J","V","Z","H",null,{"$f":"AE141","v":"S"},{"$f":"AF141","v":"J"},"V","Z",{"$f":"AI141","v":"H"}]
["Průčelní stěny",null,null,null,null,null,null,null,0.75,0.75,0.75,0.75,0.75,null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,{"$f":"VLOOKUP(Z37,AJ142:AO145,2)","v":0.75},{"$f":"VLOOKUP(Z42,AJ142:AO145,3)","v":0.75},{"$f":"VLOOKUP(Z47,AJ142:AO145,4)","v":0.75},{"$f":"VLOOKUP(Z52,AJ142:AO145,5)","v":0.75},{"$f":"VLOOKUP(Z57,AJ142:AO145,6)","v":0.75},0,{"$f":"I142","v":0.75},{"$f":"J142","v":0.75},0.75,0.75,0.75]
[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,1,0.67,0.67,0.67,0.67,0.67]
["Sběrná plocha oken",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Sběrná plocha oken",null,null,null,null,null,null,null,"S","J","V","Z","H",2,0.5,0.5,0.5,0.5,0.5]
["Průčelní stěny",null,null,null,null,null,null,null,{"$f":"I121*I124*I127*I133*I139*I142","v":0},{"$f":"J121*J124*J127*J133*J139*J142","v":0},{"$f":"K121*K124*K127*K133*K139*K142","v":0},{"$f":"L121*L124*L127*L133*L139*L142","v":0},{"$f":"M121*M124*M127*M133*M139*M142","v":0},null,null,null,null,null,null,null,null,null,"Průčelní stěny",null,null,null,null,null,null,null,{"$f":"AE121*AE124*AE127*AE133*AE139*AE142","v":0},{"$f":"AF121*AF124*AF127*AF133*AF139*AF142","v":0},{"$f":"AG121*AG124*AG127*AG133*AG139*AG142","v":0},{"$f":"AH121*AH124*AH127*AH133*AH139*AH142","v":0},{"$f":"AI121*AI124*AI127*AI133*AI139*AI142","v":0},3,0.6,0.6,0.6,0.6,0.6]
[null,null,null,null,null,null,null,null,null,null,null,null,"Suma",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Suma"]
["Celkem",null,null,null,null,null,null,null,{"$f":"I145","v":0},{"$f":"J145","v":0},0,0,{"$f":"SUM(I147:L147)","v":0},null,null,null,null,null,null,null,null,null,"Celkem",null,null,null,null,null,null,null,{"$f":"AE145","v":0},{"$f":"AF145","v":0},0,0,{"$f":"SUM(AE147:AH147)","v":0}]
[]
["Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,"Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Délka",null,null,null,null,"t","[dny]",null,{"$f":"SUM(J150:U150)","v":365},31,28,31,30,31,30,31,31,30,31,30,31,null,"Délka",null,null,null,null,"t","[dny]",null,{"$f":"SUM(AF150:AQ150)","v":365},31,28,31,30,31,30,31,31,30,31,30,31]
["Počet hodin",null,null,null,null,"t","[h]",null,{"$f":"24*I150","v":8760},{"$f":"24*J150","v":744},{"$f":"24*K150","v":672},{"$f":"24*L150","v":744},{"$f":"24*M150","v":720},{"$f":"24*N150","v":744},720,744,744,720,744,720,744,null,"Počet hodin",null,null,null,null,"t","[h]",null,{"$f":"24*AE150","v":8760},{"$f":"24*AF150","v":744},{"$f":"24*AG150","v":672},{"$f":"24*AH150","v":744},{"$f":"24*AI150","v":720},{"$f":"24*AJ150","v":744},720,744,744,720,744,720,744]
["Průměrná venkovní teplota",null,null,null,null,"Te","[°C]",null,null,{"$f":"data!N3","v":-1},{"$f":"data!O3","v":1},{"$f":"data!P3","v":4},{"$f":"data!Q3","v":9},{"$f":"data!R3","v":14.6},{"$f":"data!S3","v":17},{"$f":"data!T3","v":18.2},{"$f":"data!U3","v":18.8},{"$f":"data!V3","v":13.8},{"$f":"data!W3","v":9.4},{"$f":"data!X3","v":4},{"$f":"data!Y3","v":-0.5},null,"Průměrná venkovní teplota",null,null,null,null,"Te","[°C]",null,null,{"$f":"data!N3","v":-1},{"$f":"data!O3","v":1},{"$f":"data!P3","v":4},{"$f":"data!Q3","v":9},{"$f":"data!R3","v":14.6},{"$f":"data!S3","v":17},{"$f":"data!T3","v":18.2},{"$f":"data!U3","v":18.8},{"$f":"data!V3","v":13.8},{"$f":"data!W3","v":9.4},{"$f":"data!X3","v":4},{"$f":"data!Y3","v":-0.5}]
["Teplotní rozdíl",null,null,null,null,"Dte","[°C]",null,null,{"$f":"$B$74-J152","v":21},19,16,11,5.4,3,1.8000000000000007,1.1999999999999993,6.1999999999999993,10.6,16,20.5,null,"Teplotní rozdíl",null,null,null,null,"Dte","[°C]",null,null,{"$f":"$B$74-AF152","v":21},19,16,11,5.4,3,1.8000000000000007,1.1999999999999993,6.1999999999999993,10.6,16,20.5]
[]
["Intenzita slunečního záření",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Intenzita slunečního záření"]
["S",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N4","v":7},{"$f":"data!O4","v":13},{"$f":"data!P4","v":23},{"$f":"data!Q4","v":32},{"$f":"data!R4","v":47},{"$f":"data!S4","v":52},{"$f":"data!T4","v":47},{"$f":"data!U4","v":38},{"$f":"data!V4","v":24},{"$f":"data!W4","v":17},{"$f":"data!X4","v":9},{"$f":"data!Y4","v":6},null,"S",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N4","v":7},{"$f":"data!O4","v":13},{"$f":"data!P4","v":23},{"$f":"data!Q4","v":32},{"$f":"data!R4","v":47},{"$f":"data!S4","v":52},{"$f":"data!T4","v":47},{"$f":"data!U4","v":38},{"$f":"data!V4","v":24},{"$f":"data!W4","v":17},{"$f":"data!X4","v":9},{"$f":"data!Y4","v":6}]
["J",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N5","v":50},{"$f":"data!O5","v":56},{"$f":"data!P5","v":82},{"$f":"data!Q5","v":95},{"$f":"data!R5","v":97},{"$f":"data!S5","v":87},{"$f":"data!T5","v":93},{"$f":"data!U5","v":100},{"$f":"data!V5","v":95},{"$f":"data!W5","v":75},{"$f":"data!X5","v":36},{"$f":"data!Y5","v":29},null,"J",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N5","v":50},{"$f":"data!O5","v":56},{"$f":"data!P5","v":82},{"$f":"data!Q5","v":95},{"$f":"data!R5","v":97},{"$f":"data!S5","v":87},{"$f":"data!T5","v":93},{"$f":"data!U5","v":100},{"$f":"data!V5","v":95},{"$f":"data!W5","v":75},{"$f":"data!X5","v":36},{"$f":"data!Y5","v":29}]
["V",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N6","v":15},{"$f":"data!O6","v":26},{"$f":"data!P6","v":51},{"$f":"data!Q6","v":73.999999999999986},{"$f":"data!R6","v":104},{"$f":"data!S6","v":115},{"$f":"data!T6","v":100},{"$f":"data!U6","v":88},{"$f":"data!V6","v":60},{"$f":"data!W6","v":34},{"$f":"data!X6","v":14},{"$f":"data!Y6","v":11},null,"V",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N6","v":15},{"$f":"data!O6","v":26},{"$f":"data!P6","v":51},{"$f":"data!Q6","v":73.999999999999986},{"$f":"data!R6","v":104},{"$f":"data!S6","v":115},{"$f":"data!T6","v":100},{"$f":"data!U6","v":88},{"$f":"data!V6","v":60},{"$f":"data!W6","v":34},{"$f":"data!X6","v":14},{"$f":"data!Y6","v":11}]
["Z",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N7","v":20},{"$f":"data!O7","v":28},{"$f":"data!P7","v":53},{"$f":"data!Q7","v":72},{"$f":"data!R7","v":93},{"$f":"data!S7","v":88},{"$f":"data!T7","v":93},{"$f":"data!U7","v":88},{"$f":"data!V7","v":64},{"$f":"data!W7","v":48},{"$f":"data!X7","v":18},{"$f":"data!Y7","v":12},null,"Z",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N7","v":20},{"$f":"data!O7","v":28},{"$f":"data!P7","v":53},{"$f":"data!Q7","v":72},{"$f":"data!R7","v":93},{"$f":"data!S7","v":88},{"$f":"data!T7","v":93},{"$f":"data!U7","v":88},{"$f":"data!V7","v":64},{"$f":"data!W7","v":48},{"$f":"data!X7","v":18},{"$f":"data!Y7","v":12}]
["H",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N8","v":23},{"$f":"data!O8","v":40},{"$f":"data!P8","v":79},{"$f":"data!Q8","v":118},{"$f":"data!R8","v":161},{"$f":"data!S8","v":166},{"$f":"data!T8","v":162},{"$f":"data!U8","v":142.99999999999997},{"$f":"data!V8","v":96},{"$f":"data!W8","v":57},{"$f":"data!X8","v":24},{"$f":"data!Y8","v":17},null,"H",null,null,null,null,"Is","[kWh/m2]",null,null,{"$f":"data!N8","v":23},{"$f":"data!O8","v":40},{"$f":"data!P8","v":79},{"$f":"data!Q8","v":118},{"$f":"data!R8","v":161},{"$f":"data!S8","v":166},{"$f":"data!T8","v":162},{"$f":"data!U8","v":142.99999999999997},{"$f":"data!V8","v":96},{"$f":"data!W8","v":57},{"$f":"data!X8","v":24},{"$f":"data!Y8","v":17}]
[]
["Celková sběrná plocha oken",null,null,null,null,null,null,null,"S","J","V","Z","H",null,null,null,null,null,null,null,null,null,"Celková sběrná plocha oken",null,null,null,null,null,null,null,"S","J","V","Z","H"]
["S",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"I145","v":0},null,null,null,null,null,null,null,null,null,"S",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"AE145","v":0}]
["J",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"J145","v":0},null,null,null,null,null,null,null,null,null,"J",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"AF145","v":0}]
["V",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"K145","v":0},null,null,null,null,null,null,null,null,null,"V",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"AG145","v":0}]
["Z",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"L145","v":0},null,null,null,null,null,null,null,null,null,"Z",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"AH145","v":0}]
["H",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"M145","v":0},null,null,null,null,null,null,null,null,null,"H",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"AI145","v":0}]
["Celkem",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"SUM(M163:M167)","v":0},null,null,null,null,null,null,null,null,null,"Celkem",null,null,null,null,"As","[m2]",null,null,null,null,null,{"$f":"SUM(AI163:AI167)","v":0}]
[]
[]
[]
["Solární zisky",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,"Solární zisky",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["S",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M163*J156","v":0},{"$f":"$M163*K156","v":0},0,0,0,0,0,0,0,0,0,0,null,"S",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M163*AF156","v":0},0,0,0,0,0,0,0,0,0,0,0]
["J",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M164*J157","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"J",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M164*AF157","v":0},0,0,0,0,0,0,0,0,0,0,0]
["V",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M165*J158","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"V",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M165*AF158","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Z",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M166*J159","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Z",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M166*AF159","v":0},0,0,0,0,0,0,0,0,0,0,0]
["H",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M167*J160","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"H",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"$M167*AF160","v":0},0,0,0,0,0,0,0,0,0,0,0]
[]
["Celkové tepelné zisky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Celkové tepelné zisky"]
["Solární zisky",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"SUM(J173:J177)","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Solární zisky",null,null,null,null,"Qs","[kWh]",null,null,{"$f":"SUM(AF173:AF177)","v":0},0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"[GJ]",null,null,{"$f":"J180/(1000/3.6)","v":0},{"$f":"K180/(1000/3.6)","v":0},{"$f":"L180/(1000/3.6)","v":0},{"$f":"M180/(1000/3.6)","v":0},{"$f":"N180/(1000/3.6)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,"[GJ]",null,null,{"$f":"AF180/(1000/3.6)","v":0},{"$f":"AG180/(1000/3.6)","v":0},{"$f":"AH180/(1000/3.6)","v":0},{"$f":"AI180/(1000/3.6)","v":0},{"$f":"AJ180/(1000/3.6)","v":0},0,0,0,0,0,0,0]
["Vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,null,{"$f":"$I$118*J151/1000","v":0},{"$f":"$I$118*K151/1000","v":0},0,0,0,0,0,0,0,0,0,0,null,"Vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,null,{"$f":"$AE$118*AF151/1000","v":0},{"$f":"$AE$118*AG151/1000","v":0},0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,"[GJ]",null,null,{"$f":"J182/(1000/3.6)","v":0},{"$f":"K182/(1000/3.6)","v":0},{"$f":"L182/(1000/3.6)","v":0},{"$f":"M182/(1000/3.6)","v":0},{"$f":"N182/(1000/3.6)","v":0},0,0,0,0,0,0,0,null,null,null,null,null,null,null,"[GJ]",null,null,{"$f":"AF182/(1000/3.6)","v":0},{"$f":"AG182/(1000/3.6)","v":0},{"$f":"AH182/(1000/3.6)","v":0},{"$f":"AI182/(1000/3.6)","v":0},{"$f":"AJ182/(1000/3.6)","v":0},0,0,0,0,0,0,0]
["Celkové zisky",null,null,null,null,"Qg","[kWh]",null,null,{"$f":"J182+J180","v":0},{"$f":"K182+K180","v":0},{"$f":"L182+L180","v":0},{"$f":"M182+M180","v":0},{"$f":"N182+N180","v":0},0,0,0,0,0,0,0,null,"Celkové zisky",null,null,null,null,"Qg","[kWh]",null,null,{"$f":"AF182+AF180","v":0},{"$f":"AG182+AG180","v":0},{"$f":"AH182+AH180","v":0},{"$f":"AI182+AI180","v":0},{"$f":"AJ182+AJ180","v":0},0,0,0,0,0,0,0]
[]
["Využitelnost tepelných zisků",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Využitelnost tepelných zisků"]
["Tepelná ztráta budovy ",null,null,null,null,"Ql","[kWh]",null,null,{"$f":"J100","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Tepelná ztráta budovy ",null,null,null,null,"Ql","[kWh]",null,null,{"$f":"AF100","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Poměr zisků a ztrát",null,null,null,null,"g","[ - ]",null,null,{"$f":"J184/J187","v":{"$error":"#DIV/0!"}},{"$f":"K184/K187","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Poměr zisků a ztrát",null,null,null,null,"g","[ - ]",null,null,{"$f":"AF184/AF187","v":{"$error":"#VALUE!"}},{"$f":"AG184/AG187","v":{"$error":"#VALUE!"}},{"$f":"AH184/AH187","v":{"$error":"#VALUE!"}},{"$f":"AI184/AI187","v":{"$error":"#VALUE!"}},{"$f":"AJ184/AJ187","v":{"$error":"#VALUE!"}},{"$f":"AK184/AK187","v":{"$error":"#VALUE!"}},{"$f":"AL184/AL187","v":{"$error":"#VALUE!"}},{"$f":"AM184/AM187","v":{"$error":"#VALUE!"}},{"$f":"AN184/AN187","v":{"$error":"#VALUE!"}},{"$f":"AO184/AO187","v":{"$error":"#VALUE!"}},{"$f":"AP184/AP187","v":{"$error":"#VALUE!"}},{"$f":"AQ184/AQ187","v":{"$error":"#VALUE!"}}]
["Parametr",null,null,null,null,"a0","[ - ]",null,1,null,null,null,null,null,null,null,null,null,null,null,null,null,"Parametr",null,null,null,null,"a0","[ - ]",null,1]
["Časová konstanta zóny - 0",null,null,null,null,"t0","[hod]",null,16,null,null,null,null,null,null,null,null,null,null,null,null,null,"Časová konstanta zóny - 0",null,null,null,null,"t0","[hod]",null,16]
["Parametr",null,null,null,null,"a","[ - ]",null,{"$f":"I189+I190/I108","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Parametr",null,null,null,null,"a","[ - ]",null,{"$f":"AE189+AE190/AE108","v":{"$error":"#DIV/0!"}}]
["Stupeň využití zisků",null,null,null,null,"h","[ - ]",null,null,{"$f":"IF(J152>$B$74,0,IF(J188=1,$I191/($I191+1),(1-J188^$I191)/(1-J188^($I191+1))))","v":{"$error":"#DIV/0!"}},{"$f":"IF(K152>$B$74,0,IF(K188=1,$I191/($I191+1),(1-K188^$I191)/(1-K188^($I191+1))))","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Stupeň využití zisků",null,null,null,null,"h","[ - ]",null,null,{"$f":"IF(AF152>$X$74,0,IF(AF188=1,$AE191/($AE191+1),(1-AF188^$AE191)/(1-AF188^($AE191+1))))","v":{"$error":"#VALUE!"}},{"$f":"IF(AG152>$X$74,0,IF(AG188=1,$AE191/($AE191+1),(1-AG188^$AE191)/(1-AG188^($AE191+1))))","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Využitelné zisky",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Využitelné zisky"]
[]
["Využ. solární zisky",null,null,null,null,"Qs","[kWh]",null,{"$f":"SUM(J196:U196)","v":{"$error":"#DIV/0!"}},{"$f":"J192*J180","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využ. solární zisky",null,null,null,null,"Qs","[kWh]",null,{"$f":"SUM(AF196:AQ196)","v":{"$error":"#VALUE!"}},{"$f":"AF192*AF180","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Využ. vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,{"$f":"SUM(J197:U197)","v":{"$error":"#DIV/0!"}},{"$f":"J192*J182","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využ. vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,{"$f":"SUM(AF197:AQ197)","v":{"$error":"#VALUE!"}},{"$f":"AF192*AF182","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Využ. celkové zisky",null,null,null,null,"Qg","[kWh]",null,{"$f":"SUM(J198:U198)","v":{"$error":"#DIV/0!"}},{"$f":"J197+J196","v":{"$error":"#DIV/0!"}},{"$f":"K197+K196","v":{"$error":"#DIV/0!"}},{"$f":"L197+L196","v":{"$error":"#DIV/0!"}},{"$f":"M197+M196","v":{"$error":"#DIV/0!"}},{"$f":"N197+N196","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využ. celkové zisky",null,null,null,null,"Qg","[kWh]",null,{"$f":"SUM(AF198:AQ198)","v":{"$error":"#VALUE!"}},{"$f":"AF197+AF196","v":{"$error":"#VALUE!"}},{"$f":"AG197+AG196","v":{"$error":"#VALUE!"}},{"$f":"AH197+AH196","v":{"$error":"#VALUE!"}},{"$f":"AI197+AI196","v":{"$error":"#VALUE!"}},{"$f":"AJ197+AJ196","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
[]
["Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,"Měsíc",null,null,null,null,null,null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec"]
["Tepelná ztráta",null,null,null,null,"Ql","[kWh]",null,{"$f":"SUM(J201:U201)","v":0},{"$f":"J187","v":0},{"$f":"K187","v":0},0,0,0,0,0,0,0,0,0,0,null,"Tepelná ztráta",null,null,null,null,"Ql","[kWh]",null,{"$f":"SUM(AF201:AQ201)","v":{"$error":"#VALUE!"}},{"$f":"AF187","v":{"$error":"#VALUE!"}},{"$f":"AG187","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Celkové zisky",null,null,null,null,"Qg","[kWh]",null,{"$f":"SUM(J202:U202)","v":0},{"$f":"J184","v":0},0,0,0,0,0,0,0,0,0,0,0,null,"Celkové zisky",null,null,null,null,"Qg","[kWh]",null,0,{"$f":"AF184","v":0},0,0,0,0,0,0,0,0,0,0,0]
["Využitelné solární zisky",null,null,null,null,"Qs","[kWh]",null,{"$error":"#DIV/0!"},{"$f":"J196","v":{"$error":"#DIV/0!"}},{"$f":"K196","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využitelné solární zisky",null,null,null,null,"Qs","[kWh]",null,{"$error":"#VALUE!"},{"$f":"AF196","v":{"$error":"#VALUE!"}},{"$f":"AG196","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Využitelné vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,{"$f":"SUM(J204:U204)","v":{"$error":"#DIV/0!"}},{"$f":"J197","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využitelné vnitřní zisky",null,null,null,null,"Qi","[kWh]",null,{"$f":"SUM(AF204:AQ204)","v":{"$error":"#VALUE!"}},{"$f":"AF197","v":{"$error":"#VALUE!"}},{"$f":"AG197","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Využitelné celkové zisky",null,null,null,null,"Qg","[kWh]",null,{"$error":"#DIV/0!"},{"$f":"J198","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Využitelné celkové zisky",null,null,null,null,"Qg","[kWh]",null,{"$error":"#VALUE!"},{"$f":"AF198","v":{"$error":"#VALUE!"}},{"$f":"AG198","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Potřeba tepla na vytápění",null,null,null,null,"e","[kWh]",null,{"$f":"SUM(J206:U206)","v":{"$error":"#DIV/0!"}},{"$f":"J201-J205","v":{"$error":"#DIV/0!"}},{"$f":"K201-K205","v":{"$error":"#DIV/0!"}},{"$f":"L201-L205","v":{"$error":"#DIV/0!"}},{"$f":"M201-M205","v":{"$error":"#DIV/0!"}},{"$f":"N201-N205","v":{"$error":"#DIV/0!"}},{"$f":"O201-O205","v":{"$error":"#DIV/0!"}},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},{"$error":"#DIV/0!"},null,"Potřeba tepla na vytápění",null,null,null,null,"e","[kWh]",null,{"$f":"SUM(AF206:AQ206)","v":{"$error":"#VALUE!"}},{"$f":"AF201-AF205","v":{"$error":"#VALUE!"}},{"$f":"AG201-AG205","v":{"$error":"#VALUE!"}},{"$f":"AH201-AH205","v":{"$error":"#VALUE!"}},{"$f":"AI201-AI205","v":{"$error":"#VALUE!"}},{"$f":"AJ201-AJ205","v":{"$error":"#VALUE!"}},{"$f":"AK201-AK205","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$error":"#VALUE!"}]
["Měrná potřeba tepla na vytápění",null,null,null,null,"eA","[kWh/(m2.a)]",null,{"$f":"I206/B76","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Měrná potřeba tepla na vytápění",null,null,null,null,"eA","[kWh/(m2.a)]",null,{"$f":"AE206/X76","v":{"$error":"#VALUE!"}}]
["Zisky pokrývají ze ztrát",null,null,null,null,null,"%/100",null,{"$f":"I205/I201","v":{"$error":"#DIV/0!"}},null,null,null,null,null,null,null,null,null,null,null,null,null,"Zisky pokrývají ze ztrát",null,null,null,null,null,"%/100",null,{"$f":"AE205/AE201","v":{"$error":"#VALUE!"}}]

{"sheet":"data","index":9,"n_rows":141,"n_cols":36,"rows_kept":141,"cut":false,"hidden":true,"merged":[]}
[null,"stěna","U","U Norm dop","U Norm*0,95","U pas min","U pas max",null,null,"klima",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Náklady A","s DPH",null,"C","C1",null,"uznatelné","C2",null,"uznatelné"]
[null,"konstrukce",null,null,null,null,null,null,null,"měsíc",null,null,null,"leden","únor","březen","duben","květen","červen","červenec","srpen","září","říjen","listopad","prosinec",null,null,null,null,"Bez výměny",0,0,0,0,0,0]
[1,"Cihly plné 30 cm",1.67,0.25,{"$f":"0.95*D3","v":0.23749999999999999},0.18,0.12,null,null,"průměrná venkovní teplota",null,"qe","[°C]",-1,1,4,9,14.6,17,18.2,18.8,13.8,9.4,4,-0.5,null,"obvodové stěny",1495,null,"Kotel na biomasu s ruční dodávkou paliva",50000,0.75,{"$f":"AE3/AF3","v":66666.666666666672},40000,0.55000000000000004,{"$f":"AH3/AI3","v":72727.272727272721}]
[2,"Cihly plné 45 cm",1.27,0.25,{"$f":"0.95*D4","v":0.23749999999999999},0.18,0.12,null,null,"intenzita slunečního záření","S","Is","[kWh/m2]",7,13,23,32,47,52,47,38,24,17,9,6,null,"otvorové výplně",6900,null,"Kotel na biomasu s automatickou dodávkou paliva",100000,0.75,{"$f":"AE4/AF4","v":133333.33333333334},80000,0.55000000000000004,{"$f":"AH4/AI4","v":145454.54545454544}]
[3,"Cihly plné 60 cm",1.03,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","J","Is","[kWh/m2]",50,56,82,95,97,87,93,100,95,75,36,29,null,"střecha",1495,null,"Krbová kamna na biomasu s výměníkem s ruční dodávkou paliva",50000,0.75,66666.666666666672,40000,0.55000000000000004,72727.272727272721]
[4,"Zdivo smíšené 30 cm",2.91,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","V","Is","[kWh/m2]",15,26,51,73.999999999999986,104,115,100,88,60,34,14,11,null,"vnitřní kce",575,null,"Krbová kamna na biomasu s výměníkem se samočinnou dodávkou paliva",55000,0.75,73333.333333333328,45000,0.55000000000000004,81818.181818181809]
[5,"Zdivo smíšené 45 cm",2.48,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","Z","Is","[kWh/m2]",20,28,53,72,93,88,93,88,64,48,18,12,null,"podlaha nad sklepem",575,null,"Tepelné čerpadlo voda-voda",100000,0.75,133333.33333333334,80000,0.55000000000000004,145454.54545454544]
[6,"Zdivo smíšené 60 cm",2.16,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","H","Is","[kWh/m2]",23,40,79,118,161,166,162,142.99999999999997,96,57,24,17,null,"podlaha na terénu",1955,null,"Tepelné čerpadlo země – voda",100000,0.75,133333.33333333334,80000,0.55000000000000004,145454.54545454544]
[7,"Děrované cihly 30 cm",1.56,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","SV ","Is","[kWh/m2]",12,20,36,51,79,91,78,64,38,21,10,9,null,null,null,null,"Tepelné čerpadlo vzduch-voda",75000,0.75,100000,60000,0.55000000000000004,109090.90909090909]
[8,"Děrované cihly 45 cm",1.18,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","SZ ","Is","[kWh/m2]",12,20,36.999999999999993,49,73,73,75,63,40,25,11,9,null,null,null,null,"Plynový kondenzační kotel",18000,0.75,24000,15000,0.55000000000000004,27272.727272727272]
[9,"Děrované cihly 60 cm",0.95,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","JV ","Is","[kWh/m2]",36.999999999999993,47,73,92,109,108,103,101,82,51,25,23,null,null,null,null,"C3"]
[10,"Tvárnice šedé 30 cm",1.59,0.25,0.23749999999999999,0.18,0.12,null,null,"intenzita slunečního záření","JZ","Is","[kWh/m2]",44,51,76,86,98,88,97,100,86,71,32,26,null,null,null,null,"Žádný"]
[11,"Tvárnice šedé 45 cm",1.2,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solární systém pro ohřev vody",35000,0.4,{"$f":"AE13/AF13","v":87500}]
[12,"Tvárnice šedé 60 cm",0.97,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Solární systém pro ohřev vody a přitápění",50000,0.4,{"$f":"AE14/AF14","v":125000}]
[13,"Moderní děrované cihly 30 cm",0.7,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"posudek",5000]
[14,"Moderní děrované cihly 45 cm",0.49,0.25,0.23749999999999999,0.18,0.12]
[15,"Moderní děrované cihly 60 cm",0.38,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"výběr zdroje dle zadání pro A+C",{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AE2,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AF2,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AG2,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AH2,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AI2,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD2,data!AJ2,0)","v":0}]
[16,"Moderní pórobeton 30 cm",0.57999999999999996,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AE3,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AF3,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AG3,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AH3,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AI3,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD3,data!AJ3,0)","v":0}]
[17,"Moderní pórobeton 45 cm",0.4,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AE4,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AF4,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AG4,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AH4,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AI4,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD4,data!AJ4,0)","v":0}]
[18,"Moderní pórobeton 60 cm",0.31,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AE5,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AF5,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AG5,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AH5,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AI5,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD5,data!AJ5,0)","v":0}]
[19,"Vápenopískové cihly 30 cm",1.75,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AE6,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AF6,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AG6,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AH6,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AI6,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD6,data!AJ6,0)","v":0}]
[20,"Vápenopískové cihly 45 cm",1.34,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AE7,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AF7,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AG7,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AH7,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AI7,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD7,data!AJ7,0)","v":0}]
[21,"Vápenopískové cihly 60 cm",1.0900000000000001,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AE8,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AF8,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AG8,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AH8,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AI8,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD8,data!AJ8,0)","v":0}]
[22,"Porotherm 30 P+D - běžná malta",0.74,0.25,{"$f":"0.95*D24","v":0.23749999999999999},0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AE9,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AF9,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AG9,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AH9,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AI9,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD9,data!AJ9,0)","v":0}]
[23,"Porotherm 30 Profi - tenké spáry",0.54,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AE10,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AF10,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AG10,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AH10,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AI10,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$30=data!$AD10,data!AJ10,0)","v":0}]
[24,"Porotherm 36,5 P+D - běžná malta",0.43,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE17:AE25)","v":0},{"$f":"SUM(AF17:AF25)","v":0},0,0,0,0]
[25,"Porotherm 36,5 Profi - tenké spáry",0.36,0.25,0.23749999999999999,0.18,0.12]
[26,"Porotherm 44 P+D - běžná malta",0.39,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"výběr solára dle zadání pro A+C",{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD13,data!AE13,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD13,data!AF13,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD13,data!AG13,0)","v":0}]
[27,"Porotherm 44 Profi - tenké spáry",0.28999999999999998,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD14,data!AE14,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD14,data!AF14,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD14,data!AG14,0)","v":0}]
[28,"Porotherm 50 Hi CB - tenké spáry",0.17,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD15,data!AE15,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD15,data!AF15,0)","v":0},{"$f":"IF('navrh opatreni a vysledky'!$C$32=data!$AD15,data!AG15,0)","v":0}]
[29,"Požadavek na stěny od roku 1979",0.89,0.25,{"$f":"0.95*D31","v":0.23749999999999999},0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE28:AE30)","v":0},{"$f":"SUM(AF28:AF30)","v":0},0]
[30,"Požadavek na stěny od roku 1992",0.46,0.25,0.23749999999999999,0.18,0.12]
[31,"Požadavek na těžké stěny od roku 2002",0.38,0.25,0.23749999999999999,0.18,0.12,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"výběr zdroje dle zadání pro C",null,null,null,{"$f":"IF('podminky C'!$E$7=data!$AD2,data!AH2,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD2,data!AI2,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD2,data!AJ2,0)","v":0}]
[32,"Požadavek na lehké stěny od roku 2002",0.3,0.25,0.23749999999999999,0.18,0.12,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,{"$f":"IF('podminky C'!$E$7=data!$AD3,data!AH3,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD3,data!AI3,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD3,data!AJ3,0)","v":0}]
[33,"Požadavek na stěny od roku 2011",0.3,0.25,{"$f":"0.95*D35","v":0.23749999999999999},0.18,0.12,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,{"$f":"IF('podminky C'!$E$7=data!$AD4,data!AH4,0)","v":80000},{"$f":"IF('podminky C'!$E$7=data!$AD4,data!AI4,0)","v":0.55000000000000004},{"$f":"IF('podminky C'!$E$7=data!$AD4,data!AJ4,0)","v":145454.54545454544}]
[34,"Stěna pro nízkoenergetický dům",0.25,0.25,0.23749999999999999,0.18,0.12,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,{"$f":"IF('podminky C'!$E$7=data!$AD5,data!AH5,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD5,data!AI5,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD5,data!AJ5,0)","v":0}]
[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,{"$f":"IF('podminky C'!$E$7=data!$AD6,data!AH6,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD6,data!AI6,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD6,data!AJ6,0)","v":0}]
[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,{"$f":"IF('podminky C'!$E$7=data!$AD7,data!AH7,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD7,data!AI7,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD7,data!AJ7,0)","v":0}]
[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,{"$f":"IF('podminky C'!$E$7=data!$AD8,data!AH8,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD8,data!AI8,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD8,data!AJ8,0)","v":0}]
[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,{"$f":"IF('podminky C'!$E$7=data!$AD9,data!AH9,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD9,data!AI9,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD9,data!AJ9,0)","v":0}]
[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,{"$f":"IF('podminky C'!$E$7=data!$AD10,data!AH10,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD10,data!AI10,0)","v":0},{"$f":"IF('podminky C'!$E$7=data!$AD10,data!AJ10,0)","v":0}]
[null,"strop a střecha",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,{"$f":"SUM(AH33:AH41)","v":80000},0.55000000000000004,145454.54545454544]
[null,"konstrukce"]
[1,"Střecha plochá s železobetonovou deskou",0.5,0.16,{"$f":"0.95*D44","v":0.152},0.15,0.1,"do 45°",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"výběr solára dle zadání pro C",null,null,null,{"$f":"IF('podminky C'!$E$8=data!$AD12,data!AE12,0)","v":0},{"$f":"IF('podminky C'!$E$8=data!$AD12,data!AF12,0)","v":0},{"$f":"IF('podminky C'!$E$8=data!$AD12,data!AG12,0)","v":0}]
[2,"Střecha plochá s keramickými vložkami",1.34,0.16,0.152,0.15,0.1,"do 45°",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":"IF('podminky C'!$E$8=data!$AD13,data!AE13,0)","v":35000},{"$f":"IF('podminky C'!$E$8=data!$AD13,data!AF13,0)","v":0.4},{"$f":"IF('podminky C'!$E$8=data!$AD13,data!AG13,0)","v":87500}]
[3,"Střecha šikmá - izolace mezi krokvemi",1,0.16,0.152,0.15,0.1,"do 45°",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":"IF('podminky C'!$E$8=data!$AD14,data!AE14,0)","v":0},{"$f":"IF('podminky C'!$E$8=data!$AD14,data!AF14,0)","v":0},{"$f":"IF('podminky C'!$E$8=data!$AD14,data!AG14,0)","v":0}]
[4,"Střecha šikmá - izolace i pod krokvemi",1,0.16,0.152,0.15,0.1,"do 45°",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":"SUM(AH44:AH46)","v":35000},{"$f":"SUM(AI44:AI46)","v":0.4},87500]
[5,"strop 5",1,0.16,0.152,0.15,0.1,"do 45°"]
[6,"strop 6",1,0.16,0.152,0.15,0.1,"do 45°"]
[1,"Střecha šikmá - izolace mezi krokvemi",0.28000000000000003,0.2,0.19,0.18,0.12,"nad 45°"]
[2,"Střecha šikmá - izolace i pod krokvemi",0.22,0.2,0.19,0.18,0.12,"nad 45°"]
[3,"strop 9",1,0.2,0.19,0.18,0.12,"nad 45°"]
[4,"strop 10",1,0.2,0.19,0.18,0.12,"nad 45°"]
[5,"strop 11",1,0.2,0.19,0.18,0.12,"nad 45°"]
[6,"strop 12",1,0.2,0.19,0.18,0.12,"nad 45°"]
[1,"Trámový strop",0.99,0.2,0.19,0.15,0.1,"podlaha půdy"]
[2,"Strop s nosnou keramickou vložkou",1.5,0.2,0.19,0.15,0.1,"podlaha půdy"]
[3,"strop 15",1,0.2,0.19,0.15,0.1,"podlaha půdy"]
[4,"strop 16",1,0.2,0.19,0.15,0.1,"podlaha půdy"]
[5,"strop 17",1,0.2,0.19,0.15,0.1,"podlaha půdy"]
[6,"strop 18",1,0.2,0.19,0.15,0.1,"podlaha půdy"]
[]
[]
[]
[]
[null,"podlaha"]
[1,"Podlaha na terénu bez izolace",1.7,0.3,{"$f":"0.95*D67","v":0.28499999999999998},0.22,0.15]
[2,"Podlaha na terénu s izolací",0.97,0.3,0.28499999999999998,0.22,0.15]
[1,"Podlaha nad suterénem bez tep. izolace",1.53,0.3,0.28499999999999998,0.22,0.15]
[2,"Podlaha nad suterénem s tep. izolací",0.82,0.3,0.28499999999999998,0.22,0.15]
[3,"podlaha 5",1,0.3,0.28499999999999998,0.22,0.15]
[4,"podlaha 6",1,0.3,0.28499999999999998,0.22,0.15]
[5,"podlaha 7",1,0.3,0.28499999999999998,0.22,0.15]
[6,"podlaha 8",1,0.3,0.28499999999999998,0.22,0.15]
[7,"podlaha 9",1,0.3,0.28499999999999998,0.22,0.15]
[8,"podlaha 10",1,0.3,0.28499999999999998,0.22,0.15]
[9,null,1,0.3,0.28499999999999998,0.22,0.15]
[10,null,1,0.3,0.28499999999999998,0.22,0.15]
[11,null,1,0.3,0.28499999999999998,0.22,0.15]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"okna",null,null,null,null,null,null,"g"]
[1,"okno jednoduché s jedním sklem",4.5,1.2,{"$f":"0.95*D93","v":1.1399999999999999},0.8,0.6,null,0.81]
[2,"okno jednoduché s dvojsklem (starší)",2.5,1.2,1.1399999999999999,0.8,0.6,null,0.75]
[3,"okno zdvojené (sešroubované rámy) s dvěma skly",2.4,1.2,1.1399999999999999,0.8,0.6,null,0.75]
[4,"okno špaletové",2.35,1.2,1.1399999999999999,0.8,0.6,null,0.75]
[5,"okno s kovovým rámem a drátosklem",3.5,1.2,1.1399999999999999,0.8,0.6,null,0.5]
[6,"luxfery",4,1.2,1.1399999999999999,0.8,0.6,null,0.3]
[7,"okno novější s dvojsklem ",1.2,1.2,1.1399999999999999,0.8,0.6,null,0.75]
[8,"dveře dřevěné vchodové plné",2.2999999999999998,1.2,1.1399999999999999,0.8,0.6,null,0]
[9,"dveře dřevěné vchodové s prosklením",4,1.2,1.1399999999999999,0.8,0.6]
[10,"dveře balkonové dřevěné",2.4,1.2,1.1399999999999999,0.8,0.6]
[11,"dveře vchodové novější",1.2,1.2,1.1399999999999999,0.8,0.9]
[1,"okno střešní jednoduché s jedním sklem",4.5,1.1000000000000001,1.0449999999999999,0.9,0.9]
[2,"okno střešní starší jednoduché s dvojsklem",2.5,1.1000000000000001,1.0449999999999999,0.9,0.9]
[3,"okno střešní zdvojené s dvěma skly",2.4,1.1000000000000001,1.0449999999999999,0.9,0.9]
[4,"okno střešní novější s dvojsklem",1.2,1.1000000000000001,1.0449999999999999,0.9,0.9]
[5,null,1]
[6,null,1]
[7,null,1]
[]
[]
[]
[]
[]
[]
[null,"vnitřní stěny"]
[1,"Cihly plné 10 cm",2.87,0.4,{"$f":"0.95*D118","v":0.38},0.3,0.2]
[2,"Cihly plné 20 cm",2.11,0.4,0.38,0.3,0.2]
[3,"Cihly plné 30 cm",1.67,0.4,0.38,0.3,0.2]
[4,"Zdivo smíšené 10 cm",3.8,0.4,0.38,0.3,0.2]
[5,"Zdivo smíšené 20 cm",3.3,0.4,0.38,0.3,0.2]
[6,"Zdivo smíšené 30 cm",2.91,0.4,0.38,0.3,0.2]
[7,"Děrované cihly 10 cm",2.76,0.4,0.38,0.3,0.2]
[8,"Děrované cihly 20 cm",2,0.4,0.38,0.3,0.2]
[9,"Děrované cihly 30 cm",1.56,0.4,0.38,0.3,0.2]
[10,"Tvárnice šedé 10 cm",2.79,0.4,0.38,0.3,0.2]
[11,"Tvárnice šedé 20 cm",2.0299999999999998,0.4,0.38,0.3,0.2]
[12,"Tvárnice šedé 30 cm",1.59,0.4,0.38,0.3,0.2]
[13,"Moderní děrované cihly 10 cm",1.6,0.4,0.38,0.3,0.2]
[14,"Moderní děrované cihly 20 cm",0.98,0.4,0.38,0.3,0.2]
[15,"Moderní děrované cihly 30 cm",0.7,0.4,0.38,0.3,0.2]
[16,"Moderní pórobeton 10 cm",1.38,0.4,0.38,0.3,0.2]
[17,"Moderní pórobeton 20 cm",0.82,0.4,0.38,0.3,0.2]
[18,"Moderní pórobeton 30 cm",0.57999999999999996,0.4,0.38,0.3,0.2]
[19,"Vápenopískové cihly 10 cm",2.94,0.4,{"$f":"0.95*D136","v":0.38},0.3,0.2]
[20,"Vápenopískové cihly 20 cm",2.19,0.4,0.38,0.3,0.2]
[21,"Vápenopískové cihly 30 cm",1.75,0.4,0.38,0.3,0.2]
[]
[1,"Dveře vnitřní plné",2,2.2999999999999998,{"$f":"0.95*D140","v":2.1849999999999996},1.7,1.7]
[2,"Dveře vnitřní 2/3 prosklené",3,2.2999999999999998,2.1849999999999996,1.7,1.7]

{"sheet":"doplnit","index":10,"n_rows":5,"n_cols":1,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["korekční faktory pro stínění oken"]
["tepelné zisky"]
["podmínky C"]
["Bonusy"]
["opravit bonusy ve výpočtu"]