{"text_format":"1","workbook":"xlsx","n_sheets":7,"sheets":["pokoj 1","pokoj 2","pracovna","ložnice","spodní kuchyň s obývákem","spodní pokoj 1","spodní pokoj 2"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":7,"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":"pokoj 1","index":0,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,4,"x",5.3,"x",2.5,"=",{"$f":"D6*F6*H6","v":53}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":21.2},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":13.25},null,null,"krátká stěna:",{"$f":"D6*H6","v":10}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",2.5,"x",2.4,"x",1,"=",{"$f":"D13*F13*H13","v":6},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":85},"=",{"$f":"L13*J13","v":510},null,null,null,null,null,370,150,85,3,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",140,"=",0,null,null,null,null,null,350,140,110,2]
["1.5","severovýchod","SV",null,"x",null,"x",null,"=",0,"x",170,"=",0,null,null,null,null,null,170,70,60,1]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,260,130,80,2]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":510}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,2,null,null,"x",200,"=",{"$f":"L49*H49","v":400}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":1}]

{"sheet":"pokoj 2","index":1,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,4,"x",5.3,"x",2.5,"=",{"$f":"D6*F6*H6","v":53}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":21.2},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":13.25},null,null,"krátká stěna:",{"$f":"D6*H6","v":10}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",2.5,"x",2.4,"x",1,"=",{"$f":"D13*F13*H13","v":6},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":85},"=",{"$f":"L13*J13","v":510},null,null,null,null,null,370,150,85,3,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",140,"=",0,null,null,null,null,null,350,140,110,2]
["1.5","severovýchod","SV",null,"x",null,"x",null,"=",0,"x",170,"=",0,null,null,null,null,null,170,70,60,1]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,260,130,80,2]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":510}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,2,null,null,"x",200,"=",{"$f":"L49*H49","v":400}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":1}]

{"sheet":"pracovna","index":2,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,3.5,"x",3,"x",2.5,"=",{"$f":"D6*F6*H6","v":26.25}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":10.5},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":7.5},null,null,"krátká stěna:",{"$f":"D6*H6","v":8.75}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",2.5,"x",2.4,"x",1,"=",{"$f":"D13*F13*H13","v":6},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":85},"=",{"$f":"L13*J13","v":510},null,null,null,null,null,370,150,85,3,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",140,"=",0,null,null,null,null,null,350,140,110,2]
["1.5","severovýchod","SV",null,"x",null,"x",null,"=",0,"x",170,"=",0,null,null,null,null,null,170,70,60,1]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,260,130,80,2]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":510}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,1,null,null,"x",200,"=",{"$f":"L49*H49","v":200}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":0.8}]

{"sheet":"ložnice","index":3,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,4.9000000000000004,"x",6,"x",2.5,"=",{"$f":"D6*F6*H6","v":73.5}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":29.400000000000002},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":15},null,null,"krátká stěna:",{"$f":"D6*H6","v":12.25}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",null,"x",null,"x",null,"=",{"$f":"D13*F13*H13","v":0},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":370},"=",{"$f":"L13*J13","v":0},null,null,null,null,null,370,150,85,1,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",{"$f":"D15*F15*H15","v":0},"x",110,"=",0,null,null,null,null,null,350,140,110,3]
["1.5","severovýchod","SV",2.5,"x",2.4,"x",1,"=",{"$f":"D16*F16*H16","v":6},"x",60,"=",360,null,null,null,null,null,170,70,60,3]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,260,130,80,2]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":360}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,2,null,null,"x",200,"=",{"$f":"L49*H49","v":400}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":0.8}]

{"sheet":"spodní kuchyň s obývákem","index":4,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,11.8,"x",4.8,"x",2.7,"=",{"$f":"D6*F6*H6","v":152.92800000000003}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":56.64},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":12.96},null,null,"krátká stěna:",{"$f":"D6*H6","v":31.860000000000003}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":230},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,1,null,"bez"]
["1.2","jihozápad","JZ",2.66,"x",2.5,"x",3,"=",{"$f":"D13*F13*H13","v":19.950000000000003},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":85},"=",{"$f":"L13*J13","v":1695.7500000000002},null,null,null,null,null,370,150,85,3,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",350,"=",0,null,null,null,null,null,350,140,110,1]
["1.5","severovýchod","SV",null,"x",null,"x",null,"=",0,"x",170,"=",0,null,null,null,null,null,170,70,60,1]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",490,"=",0,null,null,null,null,null,490,210,130,1]
["1.7","východ","V",0.5,"x",1.9,"x",1,"=",0.95,"x",80,"=",76,null,null,null,null,null,260,130,80,3]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":1695.7500000000002}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,4,null,null,"x",200,"=",{"$f":"L49*H49","v":800}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":2.5}]

{"sheet":"spodní pokoj 1","index":5,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,3.5,"x",4.8,"x",2.7,"=",{"$f":"D6*F6*H6","v":45.360000000000007}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":16.8},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":12.96},null,null,"krátká stěna:",{"$f":"D6*H6","v":9.4500000000000011}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",null,"x",null,"x",null,"=",{"$f":"D13*F13*H13","v":0},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":370},"=",{"$f":"L13*J13","v":0},null,null,null,null,null,370,150,85,1,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",140,"=",0,null,null,null,null,null,350,140,110,2]
["1.5","severovýchod","SV",1.2,"x",1.5,"x",1,"=",1.7999999999999998,"x",60,"=",107.99999999999999,null,null,null,null,null,170,70,60,3]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,260,130,80,2]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":107.99999999999999}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,2,null,null,"x",200,"=",{"$f":"L49*H49","v":400}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":0.60000000000000009}]

{"sheet":"spodní pokoj 2","index":6,"n_rows":61,"n_cols":25,"rows_kept":61,"cut":false,"hidden":false,"merged":[[7,3,7,4],[7,7,7,8],[7,11,7,12]]}
[null,null,"          Výpočet tepelné zátěže"]
[]
[]
[null," - (tato pole vyplnit)"]
["Objem místnosti",null,null,"šířka (m)",null,"délka (m)",null,"výška (m)",null,"(m3)"]
[null,null,null,2.9,"x",4.8,"x",2.7,"=",{"$f":"D6*F6*H6","v":37.584000000000003}]
[null,"plochy:(m2)"]
[null,null,"podlaha/strop:",{"$f":"D6*F6","v":13.92},null,null,"dlouhá stěna:",{"$f":"F6*H6","v":12.96},null,null,"krátká stěna:",{"$f":"D6*H6","v":7.83}]
[]
["1. Osluněná okna a vnější dveře"]
[null,"žaluzie",null,"šířka (m)","x","výška (m)","x","počet","=","(m2)","x","faktor","=","Watt",null,null,null,null,null,null,"faktor (žaluzie)"]
["1.1","jih","J",null,"x",null,"x",null,"=",{"$f":"D12*F12*H12","v":0},"x",{"$f":"IF(W12=1,T12,IF(W12=2,U12,IF(W12=3,V12,0)))","v":110},"=",{"$f":"L12*J12","v":0},null,null,null,null,null,230,110,60,2,null,"bez"]
["1.2","jihozápad","JZ",null,"x",null,"x",null,"=",{"$f":"D13*F13*H13","v":0},"x",{"$f":"IF(W13=1,T13,IF(W13=2,U13,IF(W13=3,V13,0)))","v":370},"=",{"$f":"L13*J13","v":0},null,null,null,null,null,370,150,85,1,null,"vnitřní"]
["1.3","jihovýchod","JV",null,"x",null,"x",null,"=",0,"x",230,"=",0,null,null,null,null,null,230,110,50,1,null,"vnější"]
["1.4","severozápad","SZ",null,"x",null,"x",null,"=",0,"x",140,"=",0,null,null,null,null,null,350,140,110,2]
["1.5","severovýchod","SV",null,"x",null,"x",null,"=",0,"x",170,"=",0,null,null,null,null,null,170,70,60,1]
["1.6","západ","Z",null,"x",null,"x",null,"=",0,"x",130,"=",0,null,null,null,null,null,490,210,130,3]
["1.7","východ","V",2.1,"x",1.5,"x",1,"=",3.1500000000000004,"x",80,"=",252.00000000000003,null,null,null,null,null,260,130,80,3]
[]
[null,"(počítá se jen nejvýšší hodnota)",null,null,null,null,null,null,null,null,null,null,null,{"$f":"MAXA(N12:N18)","v":252.00000000000003}]
[]
["2. Ostatní okna a vnější dveře"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 1.)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L24*(J24+H24+F24)","v":0}]
[]
["3. Osluněné vnější stěny (orientace dle části 1.)"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
["3.1","Lehké konstrukce (dřevo, plasty...)",null,null,null,null,"+",null,"+",null,"x",45,"=",{"$f":"L28*(J28+H28+F28)","v":0}]
["3.2","Těžké konstrukce (cihla, beton...)",null,null,null,null,"+",null,"+",null,"x",30,"=",{"$f":"L29*(J29+H29+F29)","v":0}]
[]
["4. Ostatní vnitřní a vnější stěny"]
[null,null,null,null,null,"(m2)",null,"(m2)",null,"(m2)",null,null,null,"Watt"]
[null,"(mimo části 2.)",null,null,null,null,"+",null,"+",null,"x",20,"=",{"$f":"L33*(J33+H33+F33)","v":0}]
[]
["5. Strop a střecha"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
["5.1","Strop pod neklimatizovanou místností",null,null,null,null,null,null,null,null,"x",7,"=",{"$f":"L37*H37","v":0}]
["5.2","Strop pod podkrovím",null,null,null,null,null,null,null,null,"x",35,"=",{"$f":"L38*H38","v":0}]
["5.3","Strop izolovaný (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",23,"=",{"$f":"L39*H39","v":0}]
["5.4","Plochá střecha neizolovaná",null,null,null,null,null,null,null,null,"x",60,"=",{"$f":"L40*H40","v":0}]
["5.5","Plochá střecha izolovaná (cca 5cm izolace)",null,null,null,null,null,null,null,null,"x",25,"=",{"$f":"L41*H41","v":0}]
[]
["6. Podlaha nad neklimatizovanou místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,"(nepočítat v případě nevytápěného suterénu)",null,null,null,null,null,null,null,null,"x",10,"=",{"$f":"L45*H45","v":0}]
[]
["7. Osoby"]
[null,null,null,null,null,null,null,"(počet)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,2,null,null,"x",200,"=",{"$f":"L49*H49","v":400}]
[]
["8. Příkon elektrického zařízení"]
[null,null,null,null,null,null,null,"(Watt)",null,null,null,null,null,"Watt"]
["8.1","Osvětlení ",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L53*H53","v":0}]
["8.2","Stroje a přístroje ( výrobní nástroje, počítače, …)",null,null,null,null,null,null,null,null,"x",0.2,null,{"$f":"L54*H54","v":0}]
["8.3","Ostatní",null,null,null,null,null,null,null,null,"x",1,"=",{"$f":"L55*H55","v":0}]
[]
["9. Dveře do neklimatizovaných místností"]
[null,null,null,null,null,null,null,"(m2)",null,null,null,null,null,"Watt"]
[null,null,null,null,null,null,null,null,null,null,"x",200,"=",{"$f":"L59*H59","v":0}]
[]
["10. Celková tepelná zátěž",null,null,null,null,null,null,null,null,null,"(KiloWatt)",null,"=",{"$f":"CEILING((N59+N55+N54+N53+N49+N45+N41+N40+N39+N38+N37+N33+N29+N28+N24+N20)/1000,0.1)","v":0.70000000000000007}]