{"text_format":"3","workbook":"xlsx","n_sheets":2,"sheets":["b-Faktor","Hilfe"],"not_rendered":{"defined_names":30},"read":"whole","date_system":"1900"}

{"sheet":"b-Faktor","index":0,"n_rows":57,"n_cols":43,"rows_kept":57,"merged":[[1,1,1,4],[1,23,1,31],[2,1,2,4],[2,5,2,31],[4,1,4,4],[4,5,4,31],[7,10,7,15],[7,16,7,27],[24,2,24,7],[24,8,24,10],[26,2,26,9],[26,11,26,12],[27,2,27,9],[27,11,27,12],[50,2,50,29],[51,2,51,31],[52,2,52,31],[53,2,53,31],[54,2,54,31],[55,2,55,31],[56,27,56,31]]}
[null,"Berechnung der Reduktionsfaktoren gegen Erdreich"]
[{"$nulls":23},"nach Norm SN EN ISO 13370"]
[null,"Objekt      :"]
[]
[null,"Bauteil-Nr.:"]
[]
[{"$nulls":38},"Typ A: Ohne Nebengebäude",{"$f":"K27*K28","v":1500},{"$f":"2*(K27+K28)","v":170},1]
[{"$nulls":10},"Gebäudetyp =",{"$nulls":5},"Typ A: Ohne Nebengebäude",{"$nulls":21},"Typ B: Mit beheiztem Nebengebäude",{"$f":"K27*K28","v":1500},{"$f":"K27+2*K28","v":110},2]
[{"$nulls":38},"Typ C: Mit unbeheiztem Nebengebäude",{"$f":"K27","v":60},{"$f":"K28","v":25},3]
[{"$nulls":41},{"$f":"VLOOKUP(Q8,AM7:AP9,4,FALSE)","v":1}]
[{"$nulls":12},"OK Erdreich"]
[]
[{"$nulls":22},"Wanddicke w =",{"v":0.4,"d":"0.40"},"[m]"]
[{"$nulls":22},"U-Wert Wand Uw =",{"v":0.2,"d":"0.20"},"[W/m2.K]",{"$nulls":13},"Schluff/Ton",1.5]
[{"$nulls":9},"Tiefe z =",{"v":0.3,"d":"0.30"},"[m]",{"$nulls":26},"Kies/Sand",2]
[null,null,"Reduktionsfaktor bGW =",{"$nulls":7},{"$f":"bGW","v":{"v":0.8720405881339927,"d":"0.87"}},{"$nulls":11},"U-Wert Bodenplatte =",{"v":3,"d":"3.00"},"[W/m2.K]",{"$nulls":13},"Fels",3.5]
[{"$nulls":39},{"$f":"VLOOKUP(I25,AM14:AN16,2,FALSE)","v":2}]
[{"$nulls":8},"UK Bodenplatte"]
[]
[{"$nulls":11},{"$f":"IF(AND(Ds>0,Dh>0),AP24,\"\")","v":""},{"$nulls":13},{"$f":"IF(AND(Ds>0,Dh>0),AP24,\"\")","v":""}]
[{"$nulls":9},"Höhe D =",{"v":0,"d":"0.00"},"[m]",{"$nulls":10},"Breite D =",null,"[m]"]
[{"$nulls":38},"Rn",{"$f":"IF(OR(dn=0,ln=0),0,dn/ln)","v":2.5}]
[{"$nulls":10},".",{"$nulls":27},"R_",{"$f":"IF(OR(dn=0,ln=0),0,Rn-(dn/l))","v":2.45}]
[{"$nulls":22},"Dämmdicke dn =",{"v":0.1,"d":"0.10"},"[m]",{"$nulls":16},"Beide Werte nicht möglich"]
[null,null,"Erdreich =",{"$nulls":5},"Kies/Sand",{"$nulls":13},"Wärmeleitfähigkeit ln =",{"v":0.04,"d":"0.040"},"[W/m.K]",{"$nulls":13},"Uo1",{"$f":"IF(OR(dt=\"\",B_=\"\"),0,(2*l/(PI()*B_+dt+0.5*tz))*LN(PI()*B_/(dt+0.5*tz)+1))","v":{"v":0.2711702971498561,"d":"0.271"}},null,"Länge a =","Länge b ="]
[{"$nulls":38},"Uo2",{"$f":"IF(OR(dt=\"\",B_=\"\"),0,l/(0.457*B_+dt+0.5*tz))","v":{"v":0.21548537023344244,"d":"0.215"}},null,"Länge a =","Länge b ="]
[null,null,{"$f":"INDEX(AP25:AP27,AP10)","v":"Länge a ="},{"$nulls":7},60,"[m]",{"$nulls":10},"Fläche A =",{"$f":"INDEX(AN7:AN9,AP10)","v":1500},"[m2]",{"$nulls":13},"(dt+0,5z)<B'",{"$f":"IF(dt=\"\",0,IF((dt+0.5*tz)<B_,_Uo1,_Uo2))","v":{"v":0.2711702971498561,"d":"0.271"}},null,"Fläche A =","Perimeterumfang P ="]
[null,null,{"$f":"INDEX(AQ25:AQ27,AP10)","v":"Länge b ="},{"$nulls":7},25,"[m]",{"$nulls":10},"Perimeterumfang P =",{"$f":"INDEX(AO7:AO9,AP10)","v":170},"[m]"]
[]
[{"$nulls":22},"Reduktionsfaktor bGF =",{"$f":"bGF","v":{"v":0.09039009904995203,"d":"0.09"}}]
[{"$nulls":38},"DYw",{"$f":"IF(OR(dt=\"\",d_=\"\"),0,-l/PI()*(LN(Dh/dt+1)-LN(Dh/(dt+d_)+1)))","v":0}]
[{"$nulls":38},"DYs",{"$f":"IF(AND(dt=\"\",d_=\"\"),0,-l/PI()*(LN(2*Ds/dt+1)-LN(2*Ds/(dt+d_)+1)))","v":0}]
[null,null,"Resultate Bodenplatte",{"$nulls":35},"dw",{"$f":"IF(OR(Uw=0,tz=0),0,l/Uw)","v":10}]
[null,null,"Charakteristisches Bodenplattenmass",{"$nulls":19},"B' =",{"$f":"IF(A=0,\"\",IF(P=0,\"\",2*A/P))","v":{"v":17.647058823529413,"d":"17.65"}},"[m]",{"$nulls":13},"Ubw",{"$f":"IF(tz=0,Uw,((2*l/(PI()*tz))*(1+0.5*dt/(dt+tz))*LN(tz/dw+1)))","v":0.17440811762679853}]
[null,null,"Wirksame Gesamtdicke der Bodenplatte",{"$nulls":19},"dt =",{"$f":"IF(OR(_Uf2=\"\",w=0),\"\",w+l*1/_Uf2)","v":{"v":1.0666666666666667,"d":"1.07"}},"[m]"]
[null,null,"Zusätzliche wirksame Dicke der Randdämmung",{"$nulls":19},"d' =",{"$f":"IF(dt=\"\",\"\",R_*l)","v":{"v":4.9,"d":"4.90"}},"[m]"]
[null,null,"Wärmedurchlasskoeffizient Bodenplatte",{"$nulls":19},"Uf =",{"$f":"IF(X16=0,\"\",X16)","v":{"v":3,"d":"3.00"}},"[W/m2.K]"]
[null,null,"Korrekturwert bei Randdämmung",{"$nulls":19},"DY =",{"$f":"IF(OR(Z20=AP24,dt=\"\",B_=\"\"),\"\",MIN(DYw,DYs))","v":{"v":0,"d":"0.000"}},"[W/m.K]"]
[null,null,"Wirksamer Wärmedurchlasskoeffizient ohne Randdämmung",{"$nulls":19},"Uo =",{"$f":"IF(Uo=0,\"\",Uo)","v":{"v":0.2711702971498561,"d":"0.27"}},"[W/m2.K]"]
[null,null,"Wirksamer Wärmedurchlasskoeffizient mit Randdämmung",{"$nulls":19},"UbF =",{"$f":"IF(OR(Z20=AP24,dt=\"\",B_=\"\"),\"\",Uo+2*DY/B_)","v":{"v":0.2711702971498561,"d":"0.27"}},"[W/m2.K]"]
[null,null,"Reduktionsfaktor Bodenplatte",{"$nulls":19},"bGF =",{"$f":"IF(OR(Z20=AP24,dt=\"\",B_=\"\"),\"\",UbF/_Uf2)","v":{"v":0.09039009904995203,"d":"0.09"}},"[-]"]
[]
[null,null,"Resultate Kellerwand"]
[null,null,"Wirksame Gesamtdicke der Kellerwände",{"$nulls":19},"dw =",{"$f":"IF(dw=0,\"--\",dw)","v":{"v":10,"d":"10.00"}},"[m]"]
[null,null,"Wärmedurchlasskoeffizient der Kellerwand",{"$nulls":19},"Uw =",{"$f":"IF(Uw=0,\"\",Uw)","v":{"v":0.2,"d":"0.20"}},"[W/m2.K]"]
[null,null,"Wirksamer Wärmedurchlasskoeffizient der Kellerwand",{"$nulls":19},"UbW =",{"$f":"IF(Ubw=0,\"\",Ubw)","v":{"v":0.17440811762679853,"d":"0.17"}},"[W/m2.K]"]
[null,null,"Reduktionsfaktor Kellerwand",{"$nulls":19},"bGW =",{"$f":"IF(tz=0,\"\",IF(OR(dw=0,tz=0),\"\",Ubw/Uw))","v":{"v":0.8720405881339927,"d":"0.87"}},"[-]"]
[]
[null,null,"Achtung! Die U-Werte von Wand und Bodenplatte werden mit Rse = 0,04 [m2.K/W] berechnet."]
[]
[null,null,"Bemerkungen:"]
[]
[]
[]
[]
[]
[null,null,"©Wolfgang Maurer, Dpl-Ing. HTL, Brühlstrase 103, 9320 Arbon",{"$nulls":23},"gedruckt:",{"$f":"NOW()","v":"2025-02-18T15:30:07.640"}]

{"sheet":"Hilfe","index":1,"n_rows":59,"n_cols":26,"rows_kept":59,"merged":[[7,25,8,34],[9,25,10,34],[11,25,12,34],[13,25,14,34],[29,25,30,34],[31,25,32,34],[33,25,34,34],[53,25,54,34]]}
[]
[]
[null,null,"Bestimmen des charakteristischen Bodenplattenmasses B'"]
[]
[null,null,"Typ A: Vollständiges Gebäude"]
[]
[]
[{"$nulls":25},"Allseitig Erdreich oder unbeheizt"]
[]
[{"$nulls":25},"A = a*b"]
[]
[{"$nulls":13},"beheizt",{"$nulls":9},"b",null,"P = 2*(a+b)"]
[]
[{"$nulls":25},"Eventuelle Randdämmung"]
[]
[]
[{"$nulls":12},"a"]
[]
[null,null,"Typ B: Beheizter Gebäudeteil"]
[]
[]
[]
[]
[{"$nulls":13},"beheiztes Nebengebäude"]
[]
[]
[]
[]
[]
[{"$nulls":25},"A = a*b"]
[]
[{"$nulls":13},"beheizt",{"$nulls":11},"P = a + 2b"]
[{"$nulls":23},"b"]
[{"$nulls":25},"Eventuelle Randdämmung"]
[]
[]
[{"$nulls":13},"a"]
[]
[null,null,"Typ C: Unbeheizter Gebäudeteil (Beispiel)"]
[]
[]
[]
[]
[{"$nulls":8},"unbeheiztes Nebengebäude"]
[]
[]
[]
[]
[]
[{"$nulls":25},"A = berechnen"]
[]
[{"$nulls":25},"P = berechnen"]
[{"$nulls":13},"beheizt"]
[{"$nulls":23},"b",null,"Der unbeheizte Gebäudeteil wird wie Erdreich behandelt"]
[]
[]
[{"$nulls":25},"Eventuelle Randdämmung"]
[]
[{"$nulls":12},"a"]