{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Energy Index","Calculation sheet","Energy index data","Macro1"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":6,"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":"Energy Index","index":0,"n_rows":37,"n_cols":22,"rows_kept":37,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Energy index",null,null,null,null,null,null,null,null,null,"PROJECT INFORMATION"]
[]
[null,"Project Name :",null,null,null,"Obstruction angle, degrees :",null,null,null,null,null,27,3,"Internal gains (kWh)",null,null,null,null,null,3000]
[null,"Dwelling type :",null,"flat",1,"Floor to ceiling height (m)",null,null,null,null,null,2.4,null,"Aditional intern. gains (kWh)",null,null,null,null,null,0]
[null,"Location :",null,"LONDON",2,"Ventilation rate (ac/h)",null,null,null,null,null,0.2,4,"Fuel type :",null,null,null,null,null,"Gas"]
[null,"Latitude :",null,{"$f":"VLOOKUP(D6,'Energy index data'!A7:R18,2,)","v":"51°28'"},null,"Volume (m³)",null,null,null,null,null,{"$f":"L5*D10","v":128.4},null,"Mean whole house temperature (°C)",null,null,null,null,null,18.5]
[null,"Mean temp (°C)",null,{"$f":"VLOOKUP(D6,'Energy index data'!A7:R18,3,)","v":10.6},null,"Window / floor ratio, overall (%)",null,null,null,null,null,{"$f":"SUM(J10:J14)*100/D10","v":43.514018691588788},null,{"$f":"IF(L8<10,\"TOO DARK - INCREASE WINDOW AREA\",0)","v":0}]
[null,{"$f":"IF('Calculation sheet'!O41=\"Check location\",\"CHECK LOCATION\",0)","v":0},null,"Area (m²)",null,"U-value (W/m²K)",null,"Windows",null,"Area (m²)",null,"U-value (W/m²K)",null,"Net area (m²)",null,"SG, DG or LE",null,"Window / floor ratio, 10 - 50%",null,"Floor reflectance, 0.20 - 0.80",null,"Net solar gain, kWh"]
[null,"Floor (total)",null,53.5,null,null,null,"North",null,0,null,null,null,{"$f":"0.8*J10","v":0},null,null,null,null,null,0,null,{"$f":"IF(J10=0,0,ROUND('Calculation sheet'!O30,))","v":0}]
[null,"Ground floor",null,null,null,null,null,"NE/NW",null,null,null,null,null,0,null,null,null,null,null,null,null,{"$f":"IF(J11=0,0,ROUND('Calculation sheet'!O31,))","v":0}]
[null,"Walls (gross)",null,41,null,0.23,null,"E/W",null,4.9000000000000004,null,1.4,null,{"$f":"0.8*J12","v":3.9200000000000004},null,"LE",null,25,null,0.5,null,{"$f":"IF(J12=0,0,ROUND('Calculation sheet'!O32,))","v":701}]
[null,"Roof",null,null,null,null,null,"SE/SW",null,1.48,null,1.4,null,0,null,"LE",null,9,null,0.5,null,{"$f":"IF(J13=0,0,ROUND('Calculation sheet'!O33,))","v":317}]
[null,"Other",null,0,null,0,null,"South",null,16.899999999999999,null,1.4,null,{"$f":"0.8*J14","v":13.52},null,"LE",null,42,null,0.5,null,{"$f":"IF(J14=0,0,ROUND('Calculation sheet'!O34,))","v":3463}]
[null,null,null,null,null,null,null,"total",null,{"$f":"SUM(J10:J14)","v":23.28},null,{"$f":"IF(SUM(J10:J14)>D12, \"ERROR: WINDOW AREA LARGER THAN WALL AREA!\",0)","v":0},null,null,null,null,null,null,null,".",null,{"$f":"SUM(V10:V14)","v":4481}]
[null,null,null,"Mean U-value",null,{"$f":"(H19-(0.33*L7*L6))/(D12+D13+D11+D14)","v":0.89433170731707312}]
[null,null,null,"(W/m²K)",null,null,null,null,null,null,null,"RESULTS"]
[null,null,null,null,null,null,null,"total",null,"per m²",null,null,null,"CO2, kg",null,"CO2 kg/m2"]
[null,"Building heat loss coefficient, W/K",null,null,null,null,null,{"$f":"'Calculation sheet'!O15","v":45.142000000000003},null,{"$f":"'Calculation sheet'!O16","v":0.84377570093457954},null,null,null,null,null,null,"Excess gains, kWh",null,null,null,null,{"$f":"IF('Calculation sheet'!O69>0,'Calculation sheet'!O69,0)","v":3559.9994246144652}]
[null,"Annual heat loss, kWh",null,null,null,null,null,{"$f":"'Calculation sheet'!O24","v":3124.0069680000006},null,null,null,null,null,null,null,null,"Peak temperature, ºC",null,null,null,null,{"$f":"'Calculation sheet'!O72","v":29.4}]
[null,"Total internal gains, kWh",null,null,null,null,null,{"$f":"'Calculation sheet'!O37","v":3000},null,null,null,null,null,null,null,null,"Number of hours above 27ºC",null,null,null,null,{"$f":"'Calculation sheet'!O73","v":128}]
[null,"Total net solar gains, kWh",null,null,null,null,null,{"$f":"V15","v":4481}]
[null,"Total annual heat gains, kWh",null,null,null,null,null,{"$f":"'Calculation sheet'!O39","v":7481.1291253132795},null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(V19<=5000,0,IF(V19>10000,\"EXCESS GAINS OUT OF THE RANGE\",\"EXCESS GAINS ARE EXTRAPOLATED AND HAVE NOT BEEN VERIFIED\"))","v":0}]
[null,"Gains to Loss Ratio (GLR)",null,null,null,null,null,{"$f":"'Calculation sheet'!O43","v":2.394722291577577}]
[null,"Auxiliary Heating Fraction (AHF)",null,null,null,null,null,{"$f":"'Calculation sheet'!O41","v":0.12469362141726005},null,null,null,null,null,null,null,null,"comments"]
[null,"Continuous heating, kWh (useful)",null,null,null,null,null,{"$f":"ROUND('Calculation sheet'!O49,)","v":390},null,{"$f":"'Calculation sheet'!O50","v":7.2811914424798978},null,null,null,{"$f":"'Calculation sheet'!O61","v":81.80418585626164},null,{"$f":"N26/D10","v":1.5290502029207784},null,"Birken Flat"]
[]
[null,"Intermittent heating, kWh (useful)",null,null,null,null,null,{"$f":"ROUND('Calculation sheet'!O53,)","v":331},null,{"$f":"'Calculation sheet'!O54","v":6.1890127261079124},null,null,null,{"$f":"'Calculation sheet'!O64","v":69.533557977822383},null,{"$f":"N28/D10","v":1.2996926724826614}]
[null,null,null,null,null,null,null,null,null,{"$f":"H29/D10","v":0}]
[]
[null,"ENERGY INDEX © S. YANNAS 1994 WORKSHEET M. DOBRIN & S.YANNAS 1996-2011 "]
[null,"HOW TO USE THE WORKSHEET AND INTERPRET RESULTS: SEE \"SOLAR ENERGY AND HOUSING DESIGN\" VOLUME 1 PART IV,  AA PUBLICATIONS 1994 "]
[]
[1,"Detached, semi-detached, small house or a flat"]
[2,"Pymouth, London, Aberporth, Cambridge, Birmingham, Sheffield, Belfast, Newcastle, Glasgow, Aberdeen"]
[3,"Obstruction angle affects all orientations"]
[4,"If not specified, 0.75 is used as a default"]

{"sheet":"Calculation sheet","index":1,"n_rows":73,"n_cols":16,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
[null,"CALCULATION STEPS"]
["Step 1:","Heat Loss Coefficient"]
[]
[null,"ELEMENTS"]
[null,null,null,null,null,null,null,null,"Area (m²)",null,null,"U-value (W/m²K)",null,null,"A x U (W/K)"]
[null,"      Roof",null,null,null,null,null,null,{"$f":"'Energy Index'!D13","v":0},null,"x",{"$f":"IF('Energy Index'!F13>0,'Energy Index'!F13,IF('Energy Index'!D13=0,0,0.45))","v":0},null,"=",{"$f":"I7*L7","v":0}]
[null,"      Windows",null,null,null,null,null,null,{"$f":"IF(SUM('Energy Index'!J10:J14)>'Energy Index'!D12,'Energy Index'!D12,SUM('Energy Index'!J10:J14))","v":23.28},null,"x",{"$f":"O8/I8","v":1.4},null,"=",{"$f":"'Energy Index'!J10*(IF('Energy Index'!L10>0,'Energy Index'!L10,2.7))+'Energy Index'!J11*(IF('Energy Index'!L11>0,'Energy Index'!L11,2.7))+'Energy Index'!J12*(IF('Energy Index'!L12>0,'Energy Index'!L12,2.7))+'Energy Index'!J13*(IF('Energy Index'!L13>0,'Energy Index'!L13,2.7))+'Energy Index'!J14*(IF('Energy Index'!L14>0,'Energy Index'!L14,2.7))","v":32.591999999999999}]
[null,"      Walls (net)",null,null,null,null,null,null,{"$f":"'Energy Index'!D12-I8","v":17.72},null,"x",{"$f":"IF('Energy Index'!F12>0,'Energy Index'!F12,IF('Energy Index'!D12=0,0,0.45))","v":0.23},null,"=",{"$f":"I9*L9","v":4.0755999999999997}]
[null,"      Ground floor",null,null,null,null,null,null,{"$f":"'Energy Index'!D11","v":0},null,"x",{"$f":"IF('Energy Index'!F11>0,'Energy Index'!F11,IF('Energy Index'!D11=0,0,0.45))","v":0},null,"=",{"$f":"(IF('Energy Index'!D11<='Energy Index'!D10,'Energy Index'!D11,'Energy Index'!D10))*L10","v":0}]
[null,"      Other",null,null,null,null,null,null,{"$f":"'Energy Index'!D14","v":0},null,"x",{"$f":"IF('Energy Index'!F14>0,'Energy Index'!F14,IF('Energy Index'!D14=0,0,0.45))","v":0},null,"=",{"$f":"I11*L11","v":0}]
[]
[null,"      Ventilation",null,null,null,null,0.33,"x",{"$f":"'Energy Index'!D10*'Energy Index'!L5","v":128.4},2,"x",{"$f":"IF('Energy Index'!L6>0,'Energy Index'!L6,0.75)","v":0.2},3,"=",{"$f":"G13*I13*L13","v":8.474400000000001}]
[]
[null,"BUILDING HEAT LOSS COEFFICIENT, W/K",null,null,null,null,null,null,null,null,null,"(sum of A x U and ventilation)",null,"=",{"$f":"SUM(O5:O11)+O13","v":45.142000000000003},5]
[null,"      Heat loss per m2 floor area, W/K m2",null,null,null,null,null,null,{"$f":"O15","v":45.142000000000003},5,"÷",{"$f":"'Energy Index'!D10","v":53.5},1,"=",{"$f":"I16/L16","v":0.84377570093457954}]
[]
["Step 2:","Gross Annual Heat Loss"]
[]
[null,"      Mean whole house temperature, ºC",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"'Energy Index'!T7","v":18.5},6]
[null,"      Mean annual outdoor temperature, ºC (Table 13.2)",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"VLOOKUP('Energy Index'!D6,'Energy index data'!A7:R18,3,)","v":10.6},7]
[null,"      Mean temperature difference, ºC",null,null,null,null,null,null,{"$f":"O20","v":18.5},6,"-",{"$f":"O21","v":10.6},7,"=",{"$f":"I22-L22","v":7.9},8]
[]
[null,"ANNUAL HEAT LOSS, kWh",null,null,null,null,{"$f":"IF('Energy Index'!D6=\"Athens\",4.32,8.76)","v":8.76},"x",{"$f":"O22","v":7.9},8,"x",{"$f":"O15","v":45.142000000000003},5,"=",{"$f":"G24*I24*O15","v":3124.0069680000006},9]
[]
["Step 3:","Solar and Internal Heat Gains"]
[]
[null,"Window orientation     ","Correction factors",null,"Transmitted radiation (table 13.2)",null,"Fraction unobstructed",null,"Glass area, m2",null,null,"Fraction retained (Table 13.3)",null,null,"Net solar gain, kWh"]
[null,null,"(a)",null,"(b)",null,"(c)",null,"(d)",null,null,"(e)",null,null,"(f)"]
[null,"North",{"$f":"IF(I30=0,0,0.98)","v":0},"x",{"$f":"IF(I30=0,0,(VLOOKUP('Energy Index'!$D$6,'Energy index data'!$A$7:$R$18,IF('Energy Index'!P10=\"SG\",-1,0)+IF('Energy Index'!P10=\"DG\",0,0)+IF('Energy Index'!P10=\"LE\",1,0)+5,)))","v":0},"x",{"$f":"IF(I30=0,0,VLOOKUP('Energy Index'!$L$4,'Energy index data'!$A$119:$B$209,2))","v":0},"x",{"$f":"IF('Energy Index'!N10>0,IF('Energy Index'!N10<='Energy Index'!J10,'Energy Index'!N10,'Energy Index'!J10),'Energy Index'!J10*0.8)","v":0},null,"x",{"$f":"IF('Energy Index'!J10=0,0,(VLOOKUP(IF('Energy Index'!R10=0,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10>50,50,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10<10,10,SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10)),IF('Energy Index'!R10>50,50,IF('Energy Index'!R10<10,10,'Energy Index'!R10))),'Energy index data'!$A$69:$N$111,HLOOKUP(IF('Energy Index'!T10=0,0.5,IF('Energy Index'!T10<0.2,0.2,IF('Energy Index'!T10>0.8,0.8,'Energy Index'!T10))),'Energy index data'!$A$69:$N$111,43))))","v":0},null,"=",{"$f":"C30*E30*G30*I30*L30","v":0}]
[null,"NE/NW",{"$f":"IF(I31=0,0,0.9)","v":0},"x",{"$f":"IF(I31=0,0,(VLOOKUP('Energy Index'!$D$6,'Energy index data'!$A$7:$R$18,IF('Energy Index'!P11=\"SG\",-1,0)+IF('Energy Index'!P11=\"DG\",0,0)+IF('Energy Index'!P11=\"LE\",1,0)+8,)))","v":0},"x",{"$f":"IF(I31=0,0,VLOOKUP('Energy Index'!$L$4,'Energy index data'!$A$119:$B$209,2))","v":0},"x",{"$f":"IF('Energy Index'!N11>0,IF('Energy Index'!N11<='Energy Index'!J11,'Energy Index'!N11,'Energy Index'!J11),'Energy Index'!J11*0.8)","v":0},null,"x",{"$f":"IF('Energy Index'!J11=0,0,(VLOOKUP(IF('Energy Index'!R11=0,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10>50,50,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10<10,10,SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10)),IF('Energy Index'!R11>50,50,IF('Energy Index'!R11<10,10,'Energy Index'!R11))),'Energy index data'!$A$69:$N$111,HLOOKUP(IF('Energy Index'!T11=0,0.5,IF('Energy Index'!T11<0.2,0.2,IF('Energy Index'!T11>0.8,0.8,'Energy Index'!T11))),'Energy index data'!$A$69:$N$111,43))))","v":0},null,"=",{"$f":"C31*E31*G31*I31*L31","v":0}]
[null,"East/West",{"$f":"IF(I32=0,0,0.8)","v":0.8},"x",{"$f":"IF(I32=0,0,(VLOOKUP('Energy Index'!$D$6,'Energy index data'!$A$7:$R$18,IF('Energy Index'!P12=\"SG\",-1,0)+IF('Energy Index'!P12=\"DG\",0,0)+IF('Energy Index'!P12=\"LE\",1,0)+11,)))","v":329},"x",{"$f":"IF(I32=0,0,VLOOKUP('Energy Index'!$L$4,'Energy index data'!$A$119:$B$209,2))","v":0.81399999999999995},"x",{"$f":"IF('Energy Index'!N12>0,IF('Energy Index'!N12<='Energy Index'!J12,'Energy Index'!N12,'Energy Index'!J12),'Energy Index'!J12*0.8)","v":3.9200000000000004},null,"x",{"$f":"IF('Energy Index'!J12=0,0,(VLOOKUP(IF('Energy Index'!R12=0,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10>50,50,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10<10,10,SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10)),IF('Energy Index'!R12>50,50,IF('Energy Index'!R12<10,10,'Energy Index'!R12))),'Energy index data'!$A$69:$N$111,HLOOKUP(IF('Energy Index'!T12=0,0.5,IF('Energy Index'!T12<0.2,0.2,IF('Energy Index'!T12>0.8,0.8,'Energy Index'!T12))),'Energy index data'!$A$69:$N$111,43))))","v":0.83499999999999996},null,"=",{"$f":"C32*E32*G32*I32*L32","v":701.26607935999994}]
[null,"SE/SW",{"$f":"IF(I33=0,0,0.88)","v":0.88},"x",{"$f":"IF(I33=0,0,(VLOOKUP('Energy Index'!$D$6,'Energy index data'!$A$7:$R$18,IF('Energy Index'!P13=\"SG\",-1,0)+IF('Energy Index'!P13=\"DG\",0,0)+IF('Energy Index'!P13=\"LE\",1,0)+14,)))","v":403},"x",{"$f":"IF(I33=0,0,VLOOKUP('Energy Index'!$L$4,'Energy index data'!$A$119:$B$209,2))","v":0.81399999999999995},"x",{"$f":"IF('Energy Index'!N13>0,IF('Energy Index'!N13<='Energy Index'!J13,'Energy Index'!N13,'Energy Index'!J13),'Energy Index'!J13*0.8)","v":1.1839999999999999},null,"x",{"$f":"IF('Energy Index'!J13=0,0,(VLOOKUP(IF('Energy Index'!R13=0,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10>50,50,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10<10,10,SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10)),IF('Energy Index'!R13>50,50,IF('Energy Index'!R13<10,10,'Energy Index'!R13))),'Energy index data'!$A$69:$N$111,HLOOKUP(IF('Energy Index'!T13=0,0.5,IF('Energy Index'!T13<0.2,0.2,IF('Energy Index'!T13>0.8,0.8,'Energy Index'!T13))),'Energy index data'!$A$69:$N$111,43))))","v":0.92700000000000005},null,"=",{"$f":"C33*E33*G33*I33*L33","v":316.84259363327993}]
[null,"South",{"$f":"IF(I34=0,0,1)","v":1},"x",{"$f":"IF(I34=0,0,(VLOOKUP('Energy Index'!$D$6,'Energy index data'!$A$7:$R$18,IF('Energy Index'!P14=\"SG\",-1,0)+IF('Energy Index'!P14=\"DG\",0,0)+IF('Energy Index'!P14=\"LE\",1,0)+17,)))","v":419},"x",{"$f":"IF(I34=0,0,VLOOKUP('Energy Index'!$L$4,'Energy index data'!$A$119:$B$209,2))","v":0.81399999999999995},"x",{"$f":"IF('Energy Index'!N14>0,IF('Energy Index'!N14<='Energy Index'!J14,'Energy Index'!N14,'Energy Index'!J14),'Energy Index'!J14*0.8)","v":13.52},null,"x",{"$f":"IF('Energy Index'!J14=0,0,(VLOOKUP(IF('Energy Index'!R14=0,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10>50,50,IF(SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10<10,10,SUM('Energy Index'!$J$10:$J$14)*100/'Energy Index'!$D$10)),IF('Energy Index'!R14>50,50,IF('Energy Index'!R14<10,10,'Energy Index'!R14))),'Energy index data'!$A$69:$N$111,HLOOKUP(IF('Energy Index'!T14=0,0.5,IF('Energy Index'!T14<0.2,0.2,IF('Energy Index'!T14>0.8,0.8,'Energy Index'!T14))),'Energy index data'!$A$69:$N$111,43))))","v":0.751},null,"=",{"$f":"C34*E34*G34*I34*L34","v":3463.0204523199995}]
[null,"TOTAL ANNUAL SOLAR GAIN, kWh",null,null,null,null,null,null,null,null,null,"sum of column (f)",null,null,{"$f":"SUM(O30:O34)","v":4481.1291253132795},10]
[]
[null,"INTERNAL GAINS, kWh",null,null,null,null,null,null,null,null,null,"(6900 or 5400: see text; plus additional input by user)",null,"=",{"$f":"'Energy Index'!T4+'Energy Index'!T5","v":3000},11]
[]
[null,"TOTAL ANNUAL HEAT GAINS, kWh",null,null,null,null,null,null,{"$f":"O35","v":4481.1291253132795},10,"+",{"$f":"O37","v":3000},11,"=",{"$f":"I39+L39","v":7481.1291253132795},12]
[]
["Step 4:","Gains to loss and Auxiliary Heating Fraction",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF('Energy Index'!D6=\"London\",O42,IF(('Energy Index'!D6=\"Plymouth\")+OR('Energy Index'!D6=\"Athens\")+OR('Energy Index'!D6=\"Aberporth\")+OR('Energy Index'!D6=\"Cambridge\"),I42,IF(('Energy Index'!D6=\"Birmingham\")+OR('Energy Index'!D6=\"Sheffield\")+OR('Energy Index'!D6=\"Belfast\")+OR('Energy Index'!D6=\"Newcastle\")+OR('Energy Index'!D6=\"Glasgow\")+OR('Energy Index'!D6=\"Aberdeen\"),L42,\"Check location\")))","v":0.12469362141726005}]
[null,null,null,null,null,null,null,null,{"$f":"IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.15,B45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.2,C45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.25,D45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.3,E45,F45))))","v":0.10056286050896197},null,null,{"$f":"IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.2,H45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.25,I45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.3,J45,K45)))","v":0.10278143311374602},null,null,{"$f":"IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.2,M45,IF((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10)<0.3,N45,O45))","v":0.12469362141726005}]
[null,"GAINS TO LOSS RATIO (GLR)",null,null,null,null,null,null,{"$f":"O39","v":7481.1291253132795},12,"÷",{"$f":"O24","v":3124.0069680000006},9,"=",{"$f":"I43/L43","v":2.394722291577577},13]
[null,"AUXILIARY HEATING FRACTION (AHF)",null,null,null,null,null,null,null,null,null,"(from table 13.4 for window / floor as 4)",null,"=",{"$f":"IF('Energy Index'!D6=\"London\",O42,IF(('Energy Index'!D6=\"Plymouth\")+OR('Energy Index'!D6=\"Athens\")+OR('Energy Index'!D6=\"Aberporth\")+OR('Energy Index'!D6=\"Cambridge\"),I42,IF(('Energy Index'!D6=\"Birmingham\")+OR('Energy Index'!D6=\"Sheffield\")+OR('Energy Index'!D6=\"Belfast\")+OR('Energy Index'!D6=\"Newcastle\")+OR('Energy Index'!D6=\"Glasgow\")+OR('Energy Index'!D6=\"Aberdeen\"),L42,\"Check location\")))","v":0.12469362141726005},14]
[null,{"$f":"IF($O$43<0.575,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,2)*$O$43*(-1)))","v":0.10056286050896197},{"$f":"IF($O$43<0.55,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,2)*$O$43*(-1)))","v":0.10056286050896197},{"$f":"IF($O$43<0.5,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,2)*$O$43*(-1)))","v":0.10056286050896197},{"$f":"IF($O$43<0.45,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,2)*$O$43*(-1)))","v":0.10056286050896197},{"$f":"IF($O$43<0.4,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,2)*$O$43*(-1)))","v":0.10056286050896197},null,{"$f":"IF($O$43<0.5,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,3)*$O$43*(-1)))","v":0.10278143311374602},{"$f":"IF($O$43<0.475,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,3)*$O$43*(-1)))","v":0.10278143311374602},{"$f":"IF($O$43<0.45,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,3)*$O$43*(-1)))","v":0.10278143311374602},{"$f":"IF($O$43<0.4,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,3)*$O$43*(-1)))","v":0.10278143311374602},null,{"$f":"IF($O$43<0.455,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,4)*$O$43*(-1)))","v":0.12469362141726005},{"$f":"IF($O$43<0.4,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,4)*$O$43*(-1)))","v":0.12469362141726005},{"$f":"IF($O$43<0.35,1-$O$43,0.913*EXP(VLOOKUP((SUM('Energy Index'!$J$10:$J$14)/'Energy Index'!$D$10),'Energy index data'!$A$23:$D$63,4)*$O$43*(-1)))","v":0.12469362141726005}]
["Step 5:","Annual space heating requirement"]
[]
[null,"CONTINOUS HEATING"]
[null,"      Total, kWh",null,null,null,null,null,null,{"$f":"O44","v":0.12469362141726005},14,"x",{"$f":"O24","v":3124.0069680000006},9,"=",{"$f":"I49*L49","v":389.54374217267451},15]
[null,"      per m² floor area, kWh/m²",null,null,null,null,null,null,{"$f":"O49","v":389.54374217267451},15,"÷",{"$f":"'Energy Index'!D10","v":53.5},1,"=",{"$f":"I50/L50","v":7.2811914424798978},16]
[null,"      Primary energy equivalent, total, kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O49*VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,10)","v":589.88052386147865}]
[null,"INTERMITENT HEATING"]
[null,"      Total, kWh",null,null,null,null,null,null,0.85,null,"x",{"$f":"O49","v":389.54374217267451},15,"=",{"$f":"I53*L53","v":331.1121808467733},17]
[null,"      per m² floor area, kWh/m²",null,null,null,null,null,null,{"$f":"O53","v":331.1121808467733},17,"÷",{"$f":"'Energy Index'!D10","v":53.5},1,"=",{"$f":"I54/L54","v":6.1890127261079124},18]
[null,"      Primary energy equivalent, total, kWh",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"O53*VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,10)","v":501.39844528225677}]
[]
["Step 6:","Fuel Costs and CO2 Emissions"]
[]
[null,"CONTINOUS HEATING"]
[null,"      Fuel costs, £",null,null,null,null,null,null,{"$f":"VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,8)","v":0.02},null,"x",{"$f":"O49","v":389.54374217267451},15,"=",{"$f":"I60*L60","v":7.7908748434534907}]
[null,"      CO2 emissions, kg",null,null,null,null,null,null,{"$f":"VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,9)","v":0.21},null,"x",{"$f":"O49","v":389.54374217267451},15,"=",{"$f":"I61*L61","v":81.80418585626164}]
[null,"INTERMITENT HEATING"]
[null,"      Fuel costs, £",null,null,null,null,null,null,{"$f":"VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,8)","v":0.02},null,"x",{"$f":"O53","v":331.1121808467733},17,"=",{"$f":"I63*L63","v":6.6222436169354664}]
[null,"      CO2 emissions, kg",null,null,null,null,null,null,{"$f":"VLOOKUP('Energy Index'!T6,'Energy index data'!E124:N127,9)","v":0.21},null,"x",{"$f":"O53","v":331.1121808467733},17,"=",{"$f":"I64*L64","v":69.533557977822383}]
[]
["Step 7:","Overheating Risk"]
[]
[null,"EXCESS GAINS, kWh"]
[null,{"$f":"IF('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J12+AND('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J13),B71,IF('Energy Index'!J12>'Energy Index'!J13,B73,B72))","v":0.75},{"$f":"O35","v":4481.1291253132795},"+",0.75,"x (",{"$f":"O37","v":3000},"+",{"$f":"O49","v":389.54374217267451},null,"-",{"$f":"O24","v":3124.0069680000006},")","=",{"$f":"IF(INT(B69*C69+E69*(G69+I69-L69))>0,B69*C69+E69*(G69+I69-L69),0)","v":3559.9994246144652},19]
[null,"(see bellow)",10,null,null,null,11,null,15,null,null,9]
[null,0.75,"for North & South"]
[null,0.84,"for NE/NW/SE/SW",null,null,null,null,null,null,null,null,null,"PEAK TEMPERATURES, ºC (From Fig. 13.3 and 19)",null,{"$f":"IF('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J12+AND('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J13),VLOOKUP($O$69,'Energy index data'!$W$23:$Z$63,2),IF('Energy Index'!J12>'Energy Index'!J13,VLOOKUP($O$69,'Energy index data'!$W$23:$Z$63,4),VLOOKUP($O$69,'Energy index data'!$W$23:$Z$63,3)))","v":29.4}]
[null,0.94,"for East & West",null,null,null,null,null,null,null,null,null,"NUMBER OF HOURS ABOVE 27ºC (From Fig. 13.3 and 19)",null,{"$f":"IF('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J12+AND('Energy Index'!J10+'Energy Index'!J14>'Energy Index'!J13),VLOOKUP($O$69,'Energy index data'!$P$23:$S$63,2),IF('Energy Index'!J12>'Energy Index'!J13,VLOOKUP($O$69,'Energy index data'!$P$23:$S$63,4),VLOOKUP($O$69,'Energy index data'!$P$23:$S$63,3)))","v":128}]

{"sheet":"Energy index data","index":2,"n_rows":209,"n_cols":26,"rows_kept":209,"cut":false,"hidden":false,"merged":[]}
["Table 13.2. Mean annual outdoor temperature and solar radiation through single (SG), double (DG) and low-emissivity (LE) glazing"]
[]
["Location","Latitude","Temp.",null,null,null,null,null,null,null,null,null,null,"Transmitted solar radiation, kWh/m² year"]
[null,null,"°C",null,"North",null,null,"North-east",null,null,"East and West",null,null,"South-east",null,null,"South"]
[null,null,null,null,null,null,null,"North-west",null,null,null,null,null,"South-west"]
[null,null,null,"SG","DG","LE","SG","DG","LE","SG","DG","LE","SG","DG","LE","SG","DG","LE"]
["Athens","37°58'",12.27,{"$f":"0.8*169","v":135.20000000000002},{"$f":"0.7*169","v":118.3},{"$f":"0.65*169","v":109.85000000000001},0,0,0,{"$f":"0.8*400","v":320},{"$f":"0.7*400","v":280},{"$f":"0.65*400","v":260},0,0,0,{"$f":"0.8*607","v":485.6},420,{"$f":"0.65*600","v":390}]
["London","51°28'",10.6,265.60000000000002,209.79,189,325.76,259.27,233,452.38,365.21,329,553.30999999999995,447.91,403,579.67999999999995,465.49,419]
["Aberporth","52°08'",9.6999999999999993,296.08,233.56,210,371.18,295.55,266,513.24,415.42,374,613.07000000000005,495.54,446,631.38,507.51,457]
["Cambridge","52°20'",9.8000000000000007,277,219,197,340,270,243,470,380,342,573,464,418,600,484,436]
["Birmingham","52°28'",9.5,279.37,219.88,198,338.31,268.45,242,459.82,371.7,335,558.42999999999995,451.17,406,585.47,464.12,418]
["Sheffield","53°23'",9.5,274,216,194,327,261,235,442,356,320,537,434,391,564,454,409]
["Belfast","54°39'",8.9,268.56,211.55,190,326.83999999999997,260.08,234,449.28,363.09,327,550.6,445.92,401,579.29999999999995,467.04,420]
["Newcastle","55°01'",9.1,267.18,210.44,189,323.05,257.48,232,445.96,360.01,324,551.66999999999996,447.21,402,584.1,471.76,425]
["Glasgow","55°52'",8.9,261.03937893789401,206.19331233123313,186,316.56519490254868,251.89101949025493,227,429.41119868637105,347.00689655172403,312,523.9632385120351,425.5436323851203,383,552.27008547008541,447.61809116809115,403]
["Aberdeen","57°12'",7.7,258.25,203.99,184,313.51,249.46,225,436.58,352.8,318,549.20000000000005,446.04,401,589.20000000000005,477.55,430]
[]
["Plymouth","50°22'",10.7,308.02,242.73,218,387.39,308.39999999999998,278,542.91,439.27,395,654.96,530.39,477,677.26,543.91,490]
[]
["Values of b as function of window/floor ratio",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Figure 13.3: Excess Gains: Peak temperatures and number of hours above 27°C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Hours>27°C",null,null,null,null,null,null,"Peak Temperature, °C"]
["W / F","South","North","London",null,null,null,null,null,null,null,null,null,null,null,"Excess Gains","South","SW","West",null,null,null,"Excess Gains","South","SW","West"]
[0.1,{"$f":"-0.7623*A23^2-0.7746*A23+1.3952","v":1.310117},{"$f":"-1.9881*A23^2+0.232*A23+1.1799","v":1.183219},{"$f":"-0.9794*A23^2-0.3843*A23+1.1777","v":1.1294759999999999},null,null,null,null,null,null,null,null,null,null,null,0,null,null,null,null,null,null,0]
[0.11,1.3007701700000001,{"$f":"-1.9881*A24^2+0.232*A24+1.1799","v":1.1813639899999999},{"$f":"-0.9794*A24^2-0.3843*A24+1.1777","v":1.1235762599999999},null,null,null,null,null,null,null,null,null,null,null,200,null,null,null,null,null,null,200]
[0.12,1.2912708799999999,1.1791113600000001,1.1174806399999999,null,null,null,null,null,null,null,null,null,null,null,400,null,null,null,null,null,null,400]
[0.13,1.2816191299999999,1.17646111,1.11118914,null,null,null,null,null,null,null,null,null,null,null,600,null,null,null,null,null,null,600]
[0.14000000000000001,1.27181492,1.1734132399999999,1.10470176,null,null,null,null,null,null,null,null,null,null,null,800,null,null,null,null,null,null,800]
[0.15,1.26185825,1.1699677499999999,1.0980185,null,null,null,null,null,null,null,null,null,null,null,1000,null,null,null,null,null,null,1000]
[0.16,1.2517491199999999,1.16612464,1.0911393599999999,null,null,null,null,null,null,null,null,null,null,null,1200,null,null,null,null,null,null,1200]
[0.17,1.2414875300000001,1.16188391,1.0840643399999998,null,null,null,null,null,null,null,null,null,null,null,1400,null,null,null,null,null,null,1400]
[0.18,1.2310734800000001,1.15724556,1.0767934399999999,null,null,null,null,null,null,null,null,null,null,null,1600,null,null,{"$f":"ROUND(-95.892+0.0572591*P31+0.00000643633*P31^2,0)","v":12},null,null,null,1600,null,null,{"$f":"ROUND(24.7132+0.00216684*W31-0.0000000776485*W31^2,1)","v":28}]
[0.19,{"$f":"-0.7623*A32^2-0.7746*A32+1.3952","v":1.22050697},1.15220959,1.06932666,null,null,null,null,null,null,null,null,null,null,null,1800,{"$f":"ROUND(-25.5757-0.0103416*P32+0.0000162917*P32^2,)","v":9},12,28,null,null,null,1800,{"$f":"ROUND(25.1378+0.00146185*W32-0.0000000591501*W32^2,1)","v":27.6},{"$f":"ROUND(24.0035+0.00229225*W32-0.0000000984205*W32^2,1)","v":27.8},28.4]
[0.2,1.2097880000000001,1.146776,1.0616639999999999,null,null,null,null,null,null,null,null,null,null,null,2000,19,{"$f":"ROUND(-127.502+0.0571589*P33+0.00000967962*P33^2,0)","v":26},44,null,null,null,2000,27.8,28.2,28.7]
[0.21,1.19891657,1.14094479,1.05380546,null,null,null,null,null,null,null,null,null,null,null,2200,31,45,61,null,null,null,2200,28.1,28.6,29.1]
[0.22,1.18789268,1.1347159599999999,1.0457510399999999,null,null,null,null,null,null,null,null,null,null,null,2400,43,65,79,null,null,null,2400,28.3,28.9,29.5]
[0.23,1.1767163300000001,1.1280895099999999,1.03750074,null,null,null,null,null,null,null,null,null,null,null,2600,58,87,96,null,null,null,2600,28.5,29.3,29.8]
[0.24,1.1653875199999999,1.12106544,1.0290545600000001,null,null,null,null,null,null,null,null,null,null,null,2800,73,108,115,null,null,null,2800,28.8,29.7,30.2]
[0.25,1.1539062499999999,1.11364375,1.0204124999999999,null,null,null,null,null,null,null,null,null,null,null,3000,90,131,134,null,null,null,3000,29,30,30.5]
[0.26,{"$f":"-0.7623*A39^2-0.7746*A39+1.3952","v":1.1422725200000001},1.1058244399999999,1.0115745599999999,null,null,null,null,null,null,null,null,null,null,null,3200,108,155,153,null,null,null,3200,29.2,30.3,30.9]
[0.27,1.1304863300000001,{"$f":"-1.9881*A40^2+0.232*A40+1.1799","v":1.09760751},{"$f":"-0.9794*A40^2-0.3843*A40+1.1777","v":1.0025407399999999},null,null,null,null,null,null,null,null,null,null,null,3400,128,179,173,null,null,null,3400,29.4,30.7,31.2]
[0.28000000000000003,1.11854768,1.0889929599999999,0.99331103999999992,null,null,null,null,null,null,null,null,null,null,null,3600,148,204,194,null,null,null,3600,29.6,31,31.5]
[0.28999999999999998,1.10645657,1.07998079,0.98388545999999999,null,null,null,null,null,null,null,null,null,null,null,3800,170,229,215,null,null,null,3800,29.8,31.3,31.8]
[0.3,1.0942129999999999,1.0705709999999999,0.97426400000000002,null,null,null,null,null,null,null,null,null,null,null,4000,194,256,236,null,null,null,4000,30,31.6,32.1]
[0.31,1.08181697,1.0607635899999999,0.9644466599999999,null,null,null,null,null,null,null,null,null,null,null,4200,218,283,258,null,null,null,4200,30.2,31.9,32.4]
[0.32,1.0692684800000001,1.05055856,0.95443343999999997,null,null,null,null,null,null,null,null,null,null,null,4400,244,311,281,null,null,null,4400,30.4,32.200000000000003,32.700000000000003]
[0.33,1.0565675299999999,1.03995591,0.94422434,null,null,null,null,null,null,null,null,null,null,null,4600,272,340,304,null,null,null,4600,30.6,32.5,33]
[0.34,1.04371412,1.0289556399999999,0.93381935999999999,null,null,null,null,null,null,null,null,null,null,null,4800,300,370,327,null,null,null,4800,30.8,32.700000000000003,33.299999999999997]
[0.35,1.03070825,1.0175577499999999,0.92321849999999994,null,null,null,null,null,null,null,null,null,null,null,5000,330,400,351,null,null,null,5000,31,33,33.6]
[0.36,1.01754992,1.0057622399999999,0.91242175999999997,null,null,null,null,null,null,null,null,null,null,null,5200,361,431,376,null,null,null,5200,31.1,33.299999999999997,33.9]
[0.37,1.00423913,0.99356910999999992,0.90142913999999996,null,null,null,null,null,null,null,null,null,null,null,5400,394,463,401,null,null,null,5400,31.3,33.5,34.1]
[0.38,0.99077587999999994,0.98097835999999994,0.89024064000000003,null,null,null,null,null,null,null,null,null,null,null,5600,427,496,427,null,null,null,5600,31.5,33.799999999999997,34.4]
[0.39,0.97716016999999999,0.96798998999999997,0.87885625999999994,null,null,null,null,null,null,null,null,null,null,null,5800,462,530,453,null,null,null,5800,31.6,34,34.700000000000003]
[0.4,0.96339200000000003,0.9546039999999999,0.86727599999999994,null,null,null,null,null,null,null,null,null,null,null,6000,499,564,479,null,null,null,6000,31.8,34.200000000000003,34.9]
[0.41,0.94947137000000004,0.94082039000000006,0.85549986,null,null,null,null,null,null,null,null,null,null,null,6200,537,599,507,null,null,null,6200,31.9,34.4,35.200000000000003]
[0.42,{"$f":"-0.7623*A55^2-0.7746*A55+1.3952","v":0.93539828000000003},0.92663916000000002,0.84352784000000003,null,null,null,null,null,null,null,null,null,null,null,6400,576,635,534,null,null,null,6400,32.1,34.6,35.4]
[0.43,0.92117273,{"$f":"-1.9881*A56^2+0.232*A56+1.1799","v":0.91206030999999999},{"$f":"-0.9794*A56^2-0.3843*A56+1.1777","v":0.83135994000000002},null,null,null,null,null,null,null,null,null,null,null,6600,616,671,562,null,null,null,6600,32.200000000000003,34.799999999999997,35.6]
[0.44,0.90679472000000005,0.89708383999999997,0.81899615999999997,null,null,null,null,null,null,null,null,null,null,null,6800,657,709,591,null,null,null,6800,32.299999999999997,35,35.9]
[0.45,0.89226424999999998,0.88170974999999996,0.8064365,null,null,null,null,null,null,null,null,null,null,null,7000,700,747,620,null,null,null,7000,32.5,35.200000000000003,36.1]
[0.46,0.87758132,0.86593803999999996,0.79368095999999999,null,null,null,null,null,null,null,null,null,null,null,7200,{"$f":"ROUND(-25.5757-0.0103416*P59+0.0000162917*P59^2,)","v":745},{"$f":"ROUND(-127.502+0.0571589*P59+0.00000967962*P59^2,0)","v":786},{"$f":"ROUND(-95.892+0.0572591*P59+0.00000643633*P59^2,0)","v":650},null,null,null,7200,{"$f":"ROUND(25.1378+0.00146185*W59-0.0000000591501*W59^2,1)","v":32.6},{"$f":"ROUND(24.0035+0.00229225*W59-0.0000000984205*W59^2,1)","v":35.4},{"$f":"ROUND(24.7132+0.00216684*W59-0.0000000776485*W59^2,1)","v":36.299999999999997}]
[0.47,0.86274593000000011,0.84976870999999998,0.78072954000000006,null,null,null,null,null,null,null,null,null,null,null,7400,790,826,680,null,null,null,7400,32.700000000000003,35.6,36.5]
[0.48,0.84775807999999997,0.8332017599999999,0.76758223999999997,null,null,null,null,null,null,null,null,null,null,null,7600,837,866,711,null,null,null,7600,32.799999999999997,35.700000000000003,36.700000000000003]
[0.49,0.83261777000000003,0.81623719000000006,0.75423905999999996,null,null,null,null,null,null,null,null,null,null,null,7800,885,907,742,null,null,null,7800,32.9,35.9,36.9]
[0.5,0.81732500000000008,0.798875,0.74069999999999991,null,null,null,null,null,null,null,null,null,null,null,8000,934,949,774,null,null,null,8000,33,36,37.1]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8200,985,992,806,null,null,null,8200,33.1,36.200000000000003,37.299999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8400,1037,1036,839,null,null,null,8400,33.200000000000003,36.299999999999997,37.4]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8600,1090,1080,873,null,null,null,8600,33.299999999999997,36.4,37.6]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,8800,1145,1125,906,null,null,null,8800,33.4,36.6,37.799999999999997]
["Fraction of solar radiation retained",null,null,null,null,null,null,null,null,null,null,null,null,null,null,9000,1201,1171,941,null,null,null,9000,33.5,36.700000000000003,37.9]
["W/F /  R",0.2,0.25,0.3,0.35,0.4,0.45,0.5,0.55000000000000004,0.6,0.65,0.7,0.75,0.8,null,9200,1258,1218,976,null,null,null,9200,33.6,36.799999999999997,38.1]
[10,0.95199999999999996,0.94699999999999995,0.94299999999999995,0.93899999999999995,0.93500000000000005,0.93100000000000005,0.92700000000000005,0.92200000000000004,0.91800000000000004,0.91400000000000003,0.91,0.90600000000000003,0.90200000000000002,null,9400,1317,1265,1011,null,null,null,9400,33.700000000000003,36.9,38.200000000000003]
[11,0.94799999999999995,0.94299999999999995,0.93899999999999995,0.93400000000000005,0.92900000000000005,0.92500000000000004,0.92,0.91600000000000004,0.91100000000000003,0.90700000000000003,0.90200000000000002,0.89700000000000002,0.89300000000000002,null,9600,1377,1313,1047,null,null,null,9600,33.700000000000003,36.9,38.4]
[12,0.94399999999999995,0.93899999999999995,0.93400000000000005,0.92900000000000005,0.92400000000000004,0.91900000000000004,0.91400000000000003,0.90900000000000003,0.90400000000000003,0.89900000000000002,0.89400000000000002,0.88900000000000001,0.88400000000000001,null,9800,1438,1362,1083,null,null,null,9800,33.799999999999997,37,38.5]
[13,0.94,0.93500000000000005,0.92900000000000005,0.92400000000000004,0.91800000000000004,0.91300000000000003,0.90800000000000003,0.90200000000000002,0.89700000000000002,0.89100000000000001,0.88600000000000001,0.88100000000000001,0.875,null,10000,1500,1412,1120,null,null,null,10000,33.799999999999997,37.1,38.6]
[14,0.93600000000000005,0.93,0.92500000000000004,0.91900000000000004,0.91300000000000003,0.90700000000000003,0.90100000000000002,0.89500000000000002,0.89,0.88400000000000001,0.878,0.872,0.86599999999999999,null," (based on Kew, orientation South, South-west and West)"]
[15,0.93300000000000005,0.92600000000000005,0.92,0.91400000000000003,0.90800000000000003,0.90100000000000002,0.89500000000000002,0.88900000000000001,0.88300000000000001,0.876,0.87,0.86399999999999999,0.85799999999999998,null,"Data in blue are extrapolated and have not been validated on models."]
[16,0.92900000000000005,0.92200000000000004,0.91500000000000004,0.90900000000000003,0.90200000000000002,0.89500000000000002,0.88900000000000001,0.88200000000000001,0.875,0.86899999999999999,0.86199999999999999,0.85499999999999998,0.84899999999999998]
[17,0.92500000000000004,0.91800000000000004,0.91100000000000003,0.90400000000000003,0.89700000000000002,0.88900000000000001,0.88200000000000001,0.875,0.86799999999999999,0.86099999999999999,0.85399999999999998,0.84699999999999998,0.84]
[18,0.92100000000000004,0.91400000000000003,0.90600000000000003,0.89900000000000002,0.89100000000000001,0.88400000000000001,0.876,0.86899999999999999,0.86099999999999999,0.85399999999999998,0.84599999999999997,0.83899999999999997,0.83099999999999996]
[19,0.91700000000000004,0.90900000000000003,0.90100000000000002,0.89300000000000002,0.88600000000000001,0.878,0.87,0.86199999999999999,0.85399999999999998,0.84599999999999997,0.83799999999999997,0.83,0.82199999999999995]
[20,0.91300000000000003,0.90500000000000003,0.89700000000000002,0.88800000000000001,0.88,0.872,0.86299999999999999,0.85499999999999998,0.84699999999999998,0.83799999999999997,0.83,0.82199999999999995,0.81299999999999994]
[21,0.90900000000000003,0.90100000000000002,0.89200000000000002,0.88300000000000001,0.875,0.86599999999999999,0.85799999999999998,0.84899999999999998,0.84099999999999997,0.83199999999999996,0.82299999999999995,0.81499999999999995,0.80600000000000005]
[22,0.90500000000000003,0.89600000000000002,0.88700000000000001,0.879,0.87,0.86099999999999999,0.85199999999999998,0.84299999999999997,0.83399999999999996,0.82599999999999996,0.81699999999999995,0.80800000000000005,0.79900000000000004]
[23,0.90100000000000002,0.89200000000000002,0.88300000000000001,0.874,0.86499999999999999,0.85499999999999998,0.84599999999999997,0.83699999999999997,0.82799999999999996,0.81899999999999995,0.81,0.80100000000000005,0.79200000000000004]
[24,0.89700000000000002,0.88700000000000001,0.878,0.86899999999999999,0.85899999999999999,0.85,0.84099999999999997,0.83099999999999996,0.82199999999999995,0.81299999999999994,0.80300000000000005,0.79400000000000004,0.78500000000000003]
[25,0.89300000000000002,0.88300000000000001,0.873,0.86399999999999999,0.85399999999999998,0.84499999999999997,0.83499999999999996,0.82499999999999996,0.81599999999999995,0.80600000000000005,0.79700000000000004,0.78700000000000003,0.77700000000000002]
[26,0.88800000000000001,0.879,0.86899999999999999,0.85899999999999999,0.84899999999999998,0.83899999999999997,0.82899999999999996,0.81899999999999995,0.81,0.8,0.79,0.78,0.77]
[27,0.88400000000000001,0.874,0.86399999999999999,0.85399999999999998,0.84399999999999997,0.83399999999999996,0.82399999999999995,0.81399999999999995,0.80300000000000005,0.79300000000000004,0.78300000000000003,0.77300000000000002,0.76300000000000001]
[28,0.88,0.87,0.85899999999999999,0.84899999999999998,0.83899999999999997,0.82799999999999996,0.81799999999999995,0.80800000000000005,0.79700000000000004,0.78700000000000003,0.77700000000000002,0.76600000000000001,0.75600000000000001]
[29,0.876,0.86499999999999999,0.85499999999999998,0.84399999999999997,0.83299999999999996,0.82299999999999995,0.81200000000000006,0.80200000000000005,0.79100000000000004,0.78100000000000003,0.77,0.75900000000000001,0.749]
[30,0.872,0.86099999999999999,0.85,0.83899999999999997,0.82799999999999996,0.81699999999999995,0.80700000000000005,0.79600000000000004,0.78500000000000003,0.77400000000000002,0.76300000000000001,0.752,0.74199999999999999]
[31,0.86799999999999999,0.85699999999999998,0.84599999999999997,0.83499999999999996,0.82399999999999995,0.81299999999999994,0.80200000000000005,0.79100000000000004,0.78,0.76900000000000002,0.75800000000000001,0.747,0.73599999999999999]
[32,0.86399999999999999,0.85299999999999998,0.84199999999999997,0.83099999999999996,0.82,0.80800000000000005,0.79700000000000004,0.78600000000000003,0.77500000000000002,0.76400000000000001,0.753,0.74099999999999999,0.73]
[33,0.86099999999999999,0.84899999999999998,0.83799999999999997,0.82699999999999996,0.81499999999999995,0.80400000000000005,0.79300000000000004,0.78100000000000003,0.77,0.75900000000000001,0.747,0.73599999999999999,0.72499999999999998]
[34,0.85699999999999998,0.84499999999999997,0.83399999999999996,0.82199999999999995,0.81100000000000005,0.79900000000000004,0.78800000000000003,0.77600000000000002,0.76500000000000001,0.753,0.74199999999999999,0.73,0.71899999999999997]
[35,0.85299999999999998,0.84199999999999997,0.83,0.81799999999999995,0.80700000000000005,0.79500000000000004,0.78300000000000003,0.77200000000000002,0.76,0.748,0.73699999999999999,0.72499999999999998,0.71299999999999997]
[36,0.85,0.83799999999999997,0.82599999999999996,0.81399999999999995,0.80200000000000005,0.79,0.77900000000000003,0.76700000000000002,0.755,0.74299999999999999,0.73099999999999998,0.71899999999999997,0.70799999999999996]
[37,0.84599999999999997,0.83399999999999996,0.82199999999999995,0.81,0.79800000000000004,0.78600000000000003,0.77400000000000002,0.76200000000000001,0.75,0.73799999999999999,0.72599999999999998,0.71399999999999997,0.70199999999999996]
[38,0.84199999999999997,0.83,0.81799999999999995,0.80600000000000005,0.79400000000000004,0.78100000000000003,0.76900000000000002,0.75700000000000001,0.745,0.73299999999999998,0.72099999999999997,0.70799999999999996,0.69599999999999995]
[39,0.83899999999999997,0.82599999999999996,0.81399999999999995,0.80200000000000005,0.78900000000000003,0.77700000000000002,0.76500000000000001,0.752,0.74,0.72799999999999998,0.71499999999999997,0.70299999999999996,0.69099999999999995]
[40,0.83499999999999996,0.82299999999999995,0.81,0.79800000000000004,0.78500000000000003,0.77300000000000002,0.76,0.748,0.73499999999999999,0.72299999999999998,0.71,0.69799999999999995,0.68500000000000005]
[41,0.83199999999999996,0.81899999999999995,0.80600000000000005,0.79400000000000004,0.78100000000000003,0.76800000000000002,0.75600000000000001,0.74299999999999999,0.73,0.71799999999999997,0.70499999999999996,0.69199999999999995,0.68]
[42,0.82799999999999996,0.81499999999999995,0.80300000000000005,0.79,0.77700000000000002,0.76400000000000001,0.751,0.73799999999999999,0.72599999999999998,0.71299999999999997,0.7,0.68700000000000006,0.67400000000000004]
[43,0.82499999999999996,0.81200000000000006,0.79900000000000004,0.78600000000000003,0.77300000000000002,0.76,0.747,0.73399999999999999,0.72099999999999997,0.70799999999999996,0.69499999999999995,0.68200000000000005,0.66900000000000004]
[44,0.82199999999999995,0.80800000000000005,0.79500000000000004,0.78200000000000003,0.76900000000000002,0.75600000000000001,0.74299999999999999,0.72899999999999998,0.71599999999999997,0.70299999999999996,0.69,0.67700000000000005,0.66400000000000003]
[45,0.81799999999999995,0.80500000000000005,0.79200000000000004,0.77800000000000002,0.76500000000000001,0.752,0.73799999999999999,0.72499999999999998,0.71199999999999997,0.69799999999999995,0.68500000000000005,0.67200000000000004,0.65800000000000003]
[46,0.81499999999999995,0.80100000000000005,0.78800000000000003,0.77400000000000002,0.76100000000000001,0.747,0.73399999999999999,0.72,0.70699999999999996,0.69299999999999995,0.68,0.66600000000000004,0.65300000000000002]
[47,0.81200000000000006,0.79800000000000004,0.78400000000000003,0.77100000000000002,0.75700000000000001,0.74299999999999999,0.73,0.71599999999999997,0.70199999999999996,0.68899999999999995,0.67500000000000004,0.66100000000000003,0.64800000000000002]
[48,0.80800000000000005,0.79400000000000004,0.78100000000000003,0.76700000000000002,0.753,0.73899999999999999,0.72499999999999998,0.71099999999999997,0.69799999999999995,0.68400000000000005,0.67,0.65600000000000003,0.64200000000000002]
[49,0.80500000000000005,0.79100000000000004,0.77700000000000002,0.76300000000000001,0.749,0.73499999999999999,0.72099999999999997,0.70699999999999996,0.69299999999999995,0.67900000000000005,0.66500000000000004,0.65100000000000002,0.63700000000000001]
[50,0.80200000000000005,0.78700000000000003,0.77300000000000002,0.75900000000000001,0.745,0.73099999999999998,0.71699999999999997,0.70199999999999996,0.68799999999999994,0.67400000000000004,0.66,0.64600000000000002,0.63200000000000001]
[null,2,3,4,5,6,7,8,9,10,11,12,13,14]
[]
[]
[]
[]
["Figure 13.2. Fraction of unobstructed radiation as a function of obstruction angle"]
["(y = 1E-05x3 - 0.00072x2 + 0.00581x + 0.9854; 5° to 35°)"]
["Angle "]
[0,1]
[1,1]
[2,1,null,null,"Fuels"]
[3,0.999,null,null,null,null,null,"Seasonal conversion efficiency","PEU eq.","CO2 em.",null,"SEASONAL"]
[4,0.999,null,null,null,null,"Price, £/kWh",null,null,"kg/kWh",null,"Price","CO2","PEU eq."]
[5,0.998,null,null,"Gas",null,1.4E-2,0.7,1.06,0.19,null,{"$f":"G124/H124","v":0.02},0.21,{"$f":"I124/H124","v":1.5142857142857145}]
[6,0.997,null,null,"Oil",null,1.2E-2,0.7,1.08,0.28999999999999998,null,{"$f":"G125/H125","v":1.7142857142857144E-2},{"$f":"J125/H125","v":0.41428571428571426},{"$f":"I125/H125","v":1.5428571428571431}]
[7,0.995,null,null,"Electricity",null,7.0999999999999994E-2,1,3.73,0.7,null,{"$f":"G126/H126","v":7.0999999999999994E-2},{"$f":"J126/H126","v":0.7},{"$f":"I126/H126","v":3.73}]
[8,0.99099999999999999,null,null,"Coal",null,8.9999999999999993E-3,0.7,1.02,0.32,null,{"$f":"G127/H127","v":1.2857142857142857E-2},{"$f":"J127/H127","v":0.45714285714285718},{"$f":"I127/H127","v":1.4571428571428573}]
[9,0.98699999999999999]
[10,0.98199999999999998]
[11,0.97599999999999998]
[12,0.96899999999999997]
[13,0.96199999999999997]
[14,0.95399999999999996]
[15,0.94499999999999995]
[16,0.93500000000000005]
[17,0.92600000000000005]
[18,0.91500000000000004]
[19,0.90500000000000003]
[20,0.89400000000000002]
[21,0.88300000000000001]
[22,0.871]
[23,0.86]
[24,0.84799999999999998]
[25,0.83699999999999997]
[26,0.82499999999999996]
[27,0.81399999999999995]
[28,0.80200000000000005]
[29,0.79100000000000004]
[30,0.78100000000000003]
[31,0.77100000000000002]
[32,0.76100000000000001]
[33,0.751]
[34,0.74099999999999999]
[35,0.73099999999999998]
[36,0.72099999999999997]
[37,0.71099999999999997]
[38,0.70099999999999996]
[39,0.69099999999999995]
[40,0.68100000000000005]
[41,0.67100000000000004]
[42,0.65900000000000003]
[43,0.64700000000000002]
[44,0.63500000000000001]
[45,0.623]
[46,0.61099999999999999]
[47,0.59799999999999998]
[48,0.58499999999999996]
[49,0.57199999999999995]
[50,0.55800000000000005]
[51,0.54400000000000004]
[52,0.53]
[53,0.51600000000000001]
[54,0.501]
[55,0.48599999999999999]
[56,0.47099999999999997]
[57,0.45600000000000002]
[58,0.44]
[59,0.42399999999999999]
[60,0.40799999999999997]
[61,0.39200000000000002]
[62,0.375]
[63,0.35799999999999998]
[64,0.34100000000000003]
[65,0.32300000000000001]
[66,0.30499999999999999]
[67,0.28699999999999998]
[68,0.26900000000000002]
[69,0.251]
[70,0.23400000000000001]
[71,0.217]
[72,0.20100000000000001]
[73,0.185]
[74,0.17]
[75,0.155]
[76,0.14099999999999999]
[77,0.127]
[78,0.114]
[79,0.10100000000000001]
[80,8.7999999999999995E-2]
[81,7.5999999999999998E-2]
[82,6.5000000000000002E-2]
[83,5.3999999999999999E-2]
[84,4.3999999999999997E-2]
[85,3.4000000000000002E-2]
[86,2.5000000000000001E-2]
[87,1.4999999999999999E-2]
[88,7.0000000000000001E-3]
[89,0]
[90,0]

{"sheet":"Macro1","index":3,"n_rows":5,"n_cols":3,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Print_Energy_Index_Results (r)","Prints_Energy_Index_Calculation_Sheet (s)"]
[{"$f":"PRINT(1,,,1,,,,,,,,2)","v":true},{"$f":"WORKBOOK.UNHIDE(\"Calculation sheet\")","v":{"$error":"#VALUE!"}}]
[{"$f":"RETURN()","v":true},{"$f":"PRINT(1,,,1,,,,,,,,2)","v":true},{"$f":"SELECT(\"R2C1\")","v":true}]
[null,{"$f":"WORKBOOK.HIDE()","v":true}]
[null,{"$f":"RETURN()","v":true},{"$f":"WORKBOOK.SELECT(\"Energy Index\",\"Energy Index\")","v":true}]