{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Title","Input"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":3,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Title","index":0,"n_rows":20,"n_cols":6,"rows_kept":20,"cut":false,"hidden":false,"merged":[[12,4,12,10],[14,5,16,10],[10,2,10,12],[19,5,21,10]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"DEAP 4.2.0 Elements Adjacent to Unheated Spaces Application"]
[]
[null,null,null,null,"Version 1.0"]
[]
[null,null,null,null,null,"The purpose of this utility is to enable the calculation of the resultant U value of an element adjacent to Unheated Spaces in the SEAI DEAP (Domestic Energy Assessment Procedure) software."]
[]
[]
[]
[]
[null,null,null,null,null,"Assessors should proceed to the relevant \"Input\" tab"]

{"sheet":"Input","index":1,"n_rows":63,"n_cols":33,"rows_kept":63,"cut":false,"hidden":false,"merged":[[1,7,1,9],[0,4,0,6],[2,8,3,8],[0,9,0,10],[7,4,7,5],[2,4,3,5],[2,9,3,9],[46,0,46,11],[4,9,5,9],[6,9,7,9],[10,0,10,11],[28,0,28,11]]}
[10,null,null,null,"Resultant U Value Calculation",null,null,null,null,{"$f":"Title!E13","v":"Version 1.0"},null,null,null,null," ","WALL",null,{"$f":"ISERROR(S1)","v":true},{"$f":"IF(R8>3,S8,IF(AND(R8<1,U8>0.1),S8,IF(AND(R8>=1,U8>0.05),S8,0)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F5=0,\"Not Applicable\",T8)","v":"Not Applicable"},{"$f":"ISERROR(T1)","v":false},"CEILING",null,{"$f":"ISERROR(Y1)","v":true},{"$f":"IF(X8>3,Y8,IF(AND(X8<1,AA8>0.1),Y8,IF(AND(X8>=1,AA8>0.05),Y8,0)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F6=0,\"Not Applicable\",Z8)","v":"Not Applicable"},{"$f":"ISERROR(Z1)","v":false},"Floor",null,{"$f":"ISERROR(AE1)","v":true},{"$f":"IF(AD8>3,AE8,IF(AND(AD8<1,AG8>0.1),AE8,IF(AND(AD8>=1,AG8>0.05),AE8,0)))","v":{"$error":"#DIV/0!"}},{"$f":"IF(F7=0,\"Not Applicable\",AF8)","v":"Not Applicable"},{"$f":"ISERROR(AF1)","v":false}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[" ","MPRN:","BER Number:","Element","Number of types of elements \nadjoining an Unheated Space",null,null,"Area (m2)","Area Weighted Adjusted U Value (W/m2K) ","  ",null,null,null,"Yes",1,null,"Area","Original U Value","Adjusted U Value","Km Value","% Difference",null,"Area","Original U Value","Adjusted U Value","Km Value","% Difference",null,"Area","Original U Value","Adjusted U Value","Km Value","% Difference"]
[" ",null,null,null,null,null,null,null,null,null,null,null,null,"No",2,1,{"$f":"SUM(B12)","v":0},{"$f":"SUM(K12)","v":0},{"$f":"SUM(L12)","v":{"$error":"#DIV/0!"}},{"$f":"K15","v":0},{"$f":"(R4-S4)/R4","v":{"$error":"#DIV/0!"}},1,{"$f":"SUM(B30)","v":0},{"$f":"SUM(K30)","v":0},{"$f":"SUM(L30)","v":{"$error":"#DIV/0!"}},{"$f":"SUM(K33)","v":0},{"$f":"(X4-Y4)/X4","v":{"$error":"#DIV/0!"}},1,{"$f":"SUM(B48)","v":0},{"$f":"SUM(K48)","v":0},{"$f":"SUM(L48)","v":{"$error":"#DIV/0!"}},{"$f":"K51","v":0},{"$f":"(AD4-AE4)/AD4","v":{"$error":"#DIV/0!"}}]
[" ","Date of Survey","Address","Year of Construction","Internal Walls",0,"Internal Walls",{"$f":"IF(F5=0,0,Q8)","v":0},{"$f":"IF(F5=0,\"Not Applicable\",IF(R1=FALSE,IF(S1=0,\"Adjustment not Required\",IF(S1>1,ROUND(S1,1),S1)),\"Incomplete Inputs\"))","v":"Not Applicable"},"  ",null,null,null,null,3,2,{"$f":"SUM(B12,B16)","v":0},{"$f":"((K12*B12)+(B16*K16))/(B12+B16)","v":{"$error":"#DIV/0!"}},{"$f":"((L12*B12)+(B16*L16))/(B12+B16)","v":{"$error":"#DIV/0!"}},{"$f":"((K15*B12)+(B16*K19))/(B12+B16)","v":{"$error":"#DIV/0!"}},{"$f":"(R5-S5)/R5","v":{"$error":"#DIV/0!"}},2,{"$f":"SUM(B30,B34)","v":0},{"$f":"((K30*B30)+(B34*K34))/(B30+B34)","v":{"$error":"#DIV/0!"}},{"$f":"((L30*B30)+(B34*L34))/(B30+B34)","v":{"$error":"#DIV/0!"}},{"$f":"((K33*B30)+(B34*K37))/(B30+B34)","v":{"$error":"#DIV/0!"}},{"$f":"(X5-Y5)/X5","v":{"$error":"#DIV/0!"}},2,{"$f":"SUM(B48,B52)","v":0},{"$f":"((K48*B48)+(B52*K52))/(B48+B52)","v":{"$error":"#DIV/0!"}},{"$f":"((L48*B48)+(B52*L52))/(B48+B52)","v":{"$error":"#DIV/0!"}},{"$f":"((K51*B48)+(B52*K55))/(B48+B52)","v":{"$error":"#DIV/0!"}},{"$f":"(AD5-AE5)/AD5","v":{"$error":"#DIV/0!"}}]
[" ",null,null,null,"Internal Ceiling",0,"Internal Ceiling",{"$f":"IF(F6=0,0,W8)","v":0},{"$f":"IF(F6=0,\"Not Applicable\",IF(X1=FALSE,IF(Y1=0,\"Adjustment not Required\",IF(Y1>1,ROUND(Y1,1),Y1)),\"Incomplete Inputs\"))","v":"Not Applicable"},null,null,null,null,null,4,3,{"$f":"SUM(B12,B16,B20)","v":0},{"$f":"((K12*B12)+(B16*K16)+(B20*K20))/(B12+B16+B20)","v":{"$error":"#DIV/0!"}},{"$f":"((L12*B12)+(B16*L16)+(B20*L20))/(B12+B16+B20)","v":{"$error":"#DIV/0!"}},{"$f":"((K15*B12)+(B16*K19)+(B20*K23))/(B12+B16+B20)","v":{"$error":"#DIV/0!"}},{"$f":"(R6-S6)/R6","v":{"$error":"#DIV/0!"}},3,{"$f":"SUM(B30,B34,B38)","v":0},{"$f":"((K30*B30)+(B34*K34)+(B38*K38))/(B30+B34+B38)","v":{"$error":"#DIV/0!"}},{"$f":"((L30*B30)+(B34*L34)+(B38*L38))/(B30+B34+B38)","v":{"$error":"#DIV/0!"}},{"$f":"((K33*B30)+(B34*K37)+(B38*K41))/(B30+B34+B38)","v":{"$error":"#DIV/0!"}},{"$f":"(X6-Y6)/X6","v":{"$error":"#DIV/0!"}},3,{"$f":"SUM(B48,B52,B56)","v":0},{"$f":"((K48*B48)+(B52*K52)+(B56*K56))/(B48+B52+B56)","v":{"$error":"#DIV/0!"}},{"$f":"((L48*B48)+(B52*L52)+(B56*L56))/(B48+B52+B56)","v":{"$error":"#DIV/0!"}},{"$f":"((K51*B48)+(B52*K55)+(B56*K59))/(B48+B52+B56)","v":{"$error":"#DIV/0!"}},{"$f":"(AD6-AE6)/AD6","v":{"$error":"#DIV/0!"}}]
[" ","Assessor No","Assessor Name","Comment","Internal Floors",0,"Internal Floors",{"$f":"IF(F7=0,0,AC8)","v":0},{"$f":"IF(F7=0,\"Not Applicable\",IF(AD1=FALSE,IF(AE1=0,\"Adjustment not Required\",IF(AE1>1,ROUND(AE1,1),AE1)),\"Incomplete Inputs\"))","v":"Not Applicable"},"  ",null,null,null," ",null,4,{"$f":"SUM(B12,B16,B20,B24)","v":0},{"$f":"((K12*B12)+(B16*K16)+(B20*K20)+(B24*K24))/(B12+B16+B20+B24)","v":{"$error":"#DIV/0!"}},{"$f":"((L12*B12)+(B16*L16)+(B20*L20)+(B24*L24))/(B12+B16+B20+B24)","v":{"$error":"#DIV/0!"}},{"$f":"((K15*B12)+(B16*K19)+(B20*K23)+(B24*K27))/(B12+B16+B20+B24)","v":{"$error":"#DIV/0!"}},{"$f":"(R7-S7)/R7","v":{"$error":"#DIV/0!"}},4,{"$f":"SUM(B30,B34,B38,B42)","v":0},{"$f":"((K30*B30)+(B34*K34)+(B38*K38)+(B42*K42))/(B30+B34+B38+B42)","v":{"$error":"#DIV/0!"}},{"$f":"((L30*B30)+(B34*L34)+(B38*L38)+(B42*L42))/(B30+B34+B38+B42)","v":{"$error":"#DIV/0!"}},{"$f":"((K33*B30)+(B34*K37)+(B38*K41)+(B42*K45))/(B30+B34+B38+B42)","v":{"$error":"#DIV/0!"}},{"$f":"(X7-Y7)/X7","v":{"$error":"#DIV/0!"}},4,{"$f":"SUM(B48,B52,B56,B60)","v":0},{"$f":"((K48*B48)+(B52*K52)+(B56*K56)+(B60*K60))/(B48+B52+B56+B60)","v":{"$error":"#DIV/0!"}},{"$f":"((L48*B48)+(B52*L52)+(B56*L56)+(B60*L60))/(B48+B52+B56+B60)","v":{"$error":"#DIV/0!"}},{"$f":"((K51*B48)+(B52*K55)+(B56*K59)+(B60*K63))/(B48+B52+B56+B60)","v":{"$error":"#DIV/0!"}},{"$f":"(AD7-AE7)/AD7","v":{"$error":"#DIV/0!"}}]
[" ",null,null,null," ",null," "," "," ",null,null,null,null,null,null,null,{"$f":"IF($F5=1,Q4,IF($F5=2,Q5,IF($F5=3,Q6,Q7)))","v":0},{"$f":"IF($F5=1,R4,IF($F5=2,R5,IF($F5=3,R6,R7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F5=1,S4,IF($F5=2,S5,IF($F5=3,S6,S7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F5=1,T4,IF($F5=2,T5,IF($F5=3,T6,T7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F5=1,U4,IF($F5=2,U5,IF($F5=3,U6,U7)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($F6=1,W4,IF($F6=2,W5,IF($F6=3,W6,W7)))","v":0},{"$f":"IF($F6=1,X4,IF($F6=2,X5,IF($F6=3,X6,X7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F6=1,Y4,IF($F6=2,Y5,IF($F6=3,Y6,Y7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F6=1,Z4,IF($F6=2,Z5,IF($F6=3,Z6,Z7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F6=1,AA4,IF($F6=2,AA5,IF($F6=3,AA6,AA7)))","v":{"$error":"#DIV/0!"}},null,{"$f":"IF($F7=1,AC4,IF($F7=2,AC5,IF($F7=3,AC6,AC7)))","v":0},{"$f":"IF($F7=1,AD4,IF($F7=2,AD5,IF($F7=3,AD6,AD7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F7=1,AE4,IF($F7=2,AE5,IF($F7=3,AE6,AE7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F7=1,AF4,IF($F7=2,AF5,IF($F7=3,AF6,AF7)))","v":{"$error":"#DIV/0!"}},{"$f":"IF($F7=1,AG4,IF($F7=2,AG5,IF($F7=3,AG6,AG7)))","v":{"$error":"#DIV/0!"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
["Element","Area (m2) of Element","Description of Unheated Space","External Elements in Unheated Space","Area (m2) of External Element","U-Value(W/m2K) of External Element","Sum of (AxU) for External Element in Unheated Space","Ventilation Rate of Unheated Space (ach)","Volume of Unheated Space (m3)","Ru Value","Original U-Value(W/m2K) of Element","Adjusted U-Value(W/m2K) for Element",null,null,null,null,null,0.1," ",null,null,null," "]
["Internal Wall Elements Adjoining Unheated Spaces",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," ",null,null,null,2,0,{"$f":"IF(X11=0,\"\",W11/X11)","v":""}]
[" ",null,null,"Wall",0,0,{"$f":"(E12*F12)+(E13*F13)+(E14*F14)+(E15*F15)","v":0},null,"0",{"$f":"B12/(G12+(0.33*H12*I12))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K12)+J12)","v":{"$error":"#DIV/0!"}},null,null,null,null,null,0.5," ",null," "]
[null,null,null,"Roof",0,0,null,null," "," "," ",null,null,null,null,null,null,1," ",null," "]
[null,null,null,"Window",0,0," "," ",null,null,null,null,null,null,null,null,null,3," "]
[null,null,null,"Other",0,0," "," ",null,null,null,null,null,null,null,null,null,10," "]
[" ",0," ","Wall",0,2,{"$f":"(E16*F16)+(E17*F17)+(E18*F18)+(E19*F19)","v":0},3,"0",{"$f":"B16/(G16+(0.33*H16*I16))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K16)+J16)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0," ","Wall",0,2,{"$f":"(E20*F20)+(E21*F21)+(E22*F22)+(E23*F23)","v":0},3,"0",{"$f":"B20/(G20+(0.33*H20*I20))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K20)+J20)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E24*F24)+(E25*F25)+(E26*F26)+(E27*F27)","v":0},3,"0",{"$f":"B24/(G24+(0.33*H24*I24))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K24)+J24)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[]
["Internal Ceiling Elements Adjoining Unheated Spaces"]
[" ",0," ","Wall",0,2,{"$f":"(E30*F30)+(E31*F31)+(E32*F32)+(E33*F33)","v":0},3,"0",{"$f":"B30/(G30+(0.33*H30*I30))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K30)+J30)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E34*F34)+(E35*F35)+(E36*F36)+(E37*F37)","v":0},3,"0",{"$f":"B34/(G34+(0.33*H34*I34))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K34)+J34)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E38*F38)+(E39*F39)+(E40*F40)+(E41*F41)","v":0},3,"0",{"$f":"B38/(G38+(0.33*H38*I38))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K38)+J38)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E42*F42)+(E43*F43)+(E44*F44)+(E45*F45)","v":0},3,"0",{"$f":"B42/(G42+(0.33*H42*I42))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K42)+J42)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[]
["Internal Floor Elements Adjoining Unheated Spaces"]
[" ",0,null,"Wall",0,2,{"$f":"(E48*F48)+(E49*F49)+(E50*F50)+(E51*F51)","v":0},3,"0",{"$f":"B48/(G48+(0.33*H48*I48))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K48)+J48)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E52*F52)+(E53*F53)+(E54*F54)+(E55*F55)","v":0},3,"0",{"$f":"B52/(G52+(0.33*H52*I52))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K52)+J52)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E56*F56)+(E57*F57)+(E58*F58)+(E59*F59)","v":0},3,"0",{"$f":"B56/(G56+(0.33*H56*I56))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K56)+J56)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]
[" ",0,null,"Wall",0,2,{"$f":"(E60*F60)+(E61*F61)+(E62*F62)+(E63*F63)","v":0},3,"0",{"$f":"B60/(G60+(0.33*H60*I60))","v":{"$error":"#DIV/0!"}},0,{"$f":"1/((1/K60)+J60)","v":{"$error":"#DIV/0!"}}]
[null,null,null,"Roof",0,2,null,null," "," "," "]
[null,null,null,"Window",0,2," "," "]
[null,null,null,"Other",0,2," "," "]