{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Introduction","Energy input sheet","Sub-Meter Report (optional)","Output charts (ISO 12)","Example charts","Notes on use","Notes on sub-metering problems","Example building details"],"not_rendered":{"charts":9,"images":13,"macros":1,"external_links":0,"defined_names":35,"comments":2,"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":"Introduction","index":0,"n_rows":37,"n_cols":7,"rows_kept":37,"cut":false,"hidden":false,"merged":[[36,1,37,1],[35,6,38,7],[5,1,32,16]]}
[]
[]
[null,"The Operational Energy and Carbon (OpEC)© Calculation Tool V10.2021"]
[]
[]
[null,"Welcome to the OpEC calculation Tool. Ths spreadsheet is designed to be used in conjunction with the Energy and Carbon Reporting Framework  published by the Centre for Digital Built Britain (CDBB). Note that this is a beta version and will be modified as feedback is obtained from users.\n\nThe tool is free for use by construction professionals wishing to assess and track energy loads and carbon emissions throughout project procurement and delivery. It is consistent with published conventions for assessing energy such as  CIBSE TM54:2013 Evaluating the Operational Energy Performance of Buildings at the Design Stage and the post-occupancy energy analysis tool CIBSE TM22:2006 Energy Assessment and Reporting Methodology. The OpEC tool is most appropriate for use on Soft Landings and Government Soft Landings (GSL) projects where operational energy and emissions are required to be tracked during project delivery and into early occupation.\n\nThe spreadsheet calculates operational energy consumption for all regulated and unregulated electrical loads. Outputs are presented in tables and charts. Programmed macros enable the user to save changes and iterations as actual loads and their diversities become known during design development and product procurement, and as end-user needs become known. Thermal loads, calculated in other tools such as dynamic simulation models, can be imported and updated as required.\n\nUsers are advised to save a blank version of this spreadsheet prior to use.  Note that this spreadsheet contains data entries as a reference example. Users  should use the 'Erase All Content for Blank Sheet' button on the 'Energy Input Sheet' tab to create a clean version.\n\n           Instructions are included on a 'Notes on use' tab in this spreadsheet. The supporting OpEC guidance (opposite) contains additional instructions.\n\n\nNote that the beta OpEC spreadsheet tool is the copyrighted work of its authors and developers, John Field and Roderic Bunn. It is made available for use at users' own risk via www.cdbb.cam.ac.uk/BIM/government-soft-landings. Although free to use, the beta spreadsheet and its programming is protected to prevent corporate exploitation. Technical support is not formally available and the spreadsheet is neither warranted nor guaranteed. The website will host updates as and when they become available.  "]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]
[]
[null,null,null,null,null,null,"Example building details"]
[null,"START"]

{"sheet":"Energy input sheet","index":1,"n_rows":180,"n_cols":30,"rows_kept":180,"cut":false,"hidden":false,"merged":[[3,1,3,2],[2,19,2,24],[3,19,3,24],[1,11,1,12],[10,25,11,25],[8,9,8,11],[9,7,9,8],[10,8,11,8],[9,2,9,6],[10,12,11,12],[10,9,11,9],[9,9,9,11],[10,26,11,26],[10,17,11,17],[10,18,11,18],[10,19,11,19],[3,16,3,18],[10,21,11,21],[9,21,9,26],[10,22,11,22],[10,23,11,23],[10,24,11,24],[10,16,11,16],[102,0,103,0],[102,1,103,1],[102,6,103,6],[102,7,103,7],[9,16,9,19],[75,12,76,12],[10,1,11,1],[102,2,103,2],[102,3,103,3],[99,2,100,5],[101,16,101,19],[10,11,11,11],[10,6,11,6],[75,9,76,9],[75,10,76,10],[75,11,76,11],[75,14,76,14],[10,7,11,7],[75,2,75,7],[10,3,11,3],[76,3,76,8],[10,2,11,2],[10,10,11,10],[10,4,11,4]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,"Benchmark/Targets"]
[null,null,null,null,null,null,null,null,null,null,null,"kWh/m2 p.a.","kgCO2 p.a.",null,null,null,null,null,null,"  Toggle buttons"]
[null,"Notional primary school exemplar",null,"Annual billed (metered)  electricity (if known) ",null,"kWh",1000,"m2 TFA","Energy use kWh/m2 p.a.",{"$f":"IF(G4>0,ResultsEnergy/G4,\"(no TFA)\")","v":31.522156800000005},null,50,{"$f":"L4*M6","v":9.5},null,null,null,null,null,null,"Fully reversible"]
[]
[null,null,"Unit cost \"in use\"         (p/kWh)",12,null,null,"Hours \"in use\"/day",12,null,null,null,"Emission factor \"in use\" (kgCO2/kWh)",0.19,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Unit cost \"out of hours\" (p/kWh)",12,null,null,"Days per week      ",5.8,null,null,null,"Emission factor \"out of hours\" (kgCO2/kWh)",0.19]
[null,null,null,null,null,null,"Weeks per year     ",40]
[null,"Blue box for printing",null,null,null,null,null,null,null,"Do not adjust grey boxes",null,null,null,null,null,null,"Not for printing >>>>>>>"]
[null," ","Energy Loads Table",null,null,null,null,"Usage data",null,"Results",null,null,null,null,null,null,"Usage time",null,null,null,null,"Secondary results - Power Demand"]
[null,"Row item","Load type","End-use item \n(Select from \ndrop-down menu)\n\nDrop down  ","Number present      (or m2 area)","Units or floor area","Full load Watts (or W/m2)","Load factor    \"in use\"","Load factor   \"out of hours\"","Annual energy use\n(kWh p.a.)","Annual cost of energy\n(£ p.a.)","% of total cost","Emissions (kgCO2)",null,null,null,"Hours \"in use\" per day","Days per week","Weeks per year in-use","Factor for full load",null,"Total watts at full load (W)","Full load hours per year (hrs)","In-use summer average power demand (W)","In-use winter average power demand (W)","Out of hours summer average power demand (W)","Out of hours winter average power demand (W)"]
[null,null,null,null,null,"Drop down"]
[null,1,"Classroom main lighting","Lighting (internal)",420,"m2",8.1,0.65,0,{"$f":"V13*W13*0.001","v":6156.2592000000004},{"$f":"0.00001*S13*V13*($D$6*(Q13*R13*H13)+$D$7*((168-Q13*R13)*I13))","v":738.75110399999983},{"$f":"IF($K$73>0,K13/$K$73,0)","v":0.195299428242169},{"$f":"0.001*S13*V13*($M$6*(Q13*R13*H13)+$M$7*((168-Q13*R13)*I13))","v":1169.6892479999999},null,null,null,{"$f":"$H$6","v":12},{"$f":"$H$7","v":5.8},{"$f":"$H$8","v":40},1,null,{"$f":"G13*E13*T13","v":3402},{"$f":"Q13*R13*S13*H13+(168-Q13*R13)*S13*I13","v":1809.6000000000001},{"$f":"$G13*$E13*$T13*H13","v":2211.3000000000002},{"$f":"$G13*$E13*$T13*H13","v":2211.3000000000002},{"$f":"$G13*$E13*$T13*I13","v":0},{"$f":"$G13*$E13*$T13*I13","v":0}]
[null,2,"Classroom extra lighting","Lighting (internal)",30,"Units",26,0.65,0,{"$f":"V14*W14*0.001","v":1411.4880000000001},169.37855999999996,4.4777646686917055E-2,268.18271999999996,null,null,null,12,{"$f":"$H$7","v":5.8},{"$f":"$H$8","v":40},1,null,780,1809.6000000000001,507,507,0,0]
[null,3,"Corridor & circulation lighting","Lighting (internal)",300,"m2",9.8000000000000007,0.65,0.1,{"$f":"V15*W15*0.001","v":6477.4080000000013},777.28895999999997,0.20548746207619908,1230.7075199999999,null,null,null,12,{"$f":"$H$7","v":5.8},40,1,null,{"$f":"G15*E15*T15","v":2940},{"$f":"Q15*R15*S15*H15+(168-Q15*R15)*S15*I15","v":2203.2000000000003},{"$f":"$G15*$E15*$T15*H15","v":1911},{"$f":"$G15*$E15*$T15*H15","v":1911},{"$f":"$G15*$E15*$T15*I15","v":294},{"$f":"$G15*$E15*$T15*I15","v":294}]
[null,4,"Hall lighting","Lighting (internal)",40,"Units",26,0.6,0.2,2555.904,306.70848000000001,8.1082776670916137E-2,485.62176000000005,null,null,null,12,5.8,40,1,null,1040,2457.6,624,624,208,208]
[null,5,"Staff, reception, offices lighting","Lighting (internal)",130,"m2",11.4,0.8,0.1,3884.0256000000004,466.08307200000002,0.12321573122813731,737.96486400000003,null,null,null,12,5.8,40,1,null,1482,2620.8000000000002,1185.6000000000001,1185.6000000000001,148.20000000000002,148.20000000000002]
[null,6,null,null,null,null,null,null,null,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,7,"Playground lighting","Lighting (external)",3,"Units",150,0,0.22,389.66399999999999,46.75968000000001,1.2361590689124425E-2,74.03616000000001,null,null,null,12,5.8,40,1,null,450,865.92,0,0,99,99]
[null,8,null,null,null,null,null,null,null,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,9,"Classroom displays","ICT",6,"Units",150,0.7,0.2,{"$f":"V21*W21*0.001","v":2462.4},295.488,7.8116482181828387E-2,467.85599999999994,null,null,null,12,5.8,40,1,null,{"$f":"G21*E21*T21","v":900},{"$f":"Q21*R21*S21*H21+(168-Q21*R21)*S21*I21","v":2736},{"$f":"$G21*$E21*$T21*H21","v":630},{"$f":"$G21*$E21*$T21*H21","v":630},{"$f":"$G21*$E21*$T21*I21","v":180},{"$f":"$G21*$E21*$T21*I21","v":180}]
[null,10,"Office PCs and printers","ICT",3,"Units",100,0.6,0.2,{"$f":"V22*W22*0.001","v":737.28},88.473600000000005,2.3389262501225812E-2,140.08320000000001,null,null,null,12,5.8,40,1,null,{"$f":"G22*E22*T22","v":300},{"$f":"Q22*R22*S22*H22+(168-Q22*R22)*S22*I22","v":2457.6},{"$f":"$G22*$E22*$T22*H22","v":180},{"$f":"$G22*$E22*$T22*H22","v":180},{"$f":"$G22*$E22*$T22*I22","v":60},{"$f":"$G22*$E22*$T22*I22","v":60}]
[null,11,"Network hub cabinet","ICT",1,"Units",250,1,1,1680,201.60000000000002,5.3295845543157777E-2,319.20000000000005,null,null,null,12,5.8,40,1,null,250,6720,250,250,250,250]
[null,13,null,null,null,null,null,null,null,{"$f":"V24*W24*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G24*E24*T24","v":0},{"$f":"Q24*R24*S24*H24+(168-Q24*R24)*S24*I24","v":0},{"$f":"$G24*$E24*$T24*H24","v":0},{"$f":"$G24*$E24*$T24*H24","v":0},{"$f":"$G24*$E24*$T24*I24","v":0},{"$f":"$G24*$E24*$T24*I24","v":0}]
[null,14,"Boiler pump","Pumps",1,"Units",60,0.45,0,75.168000000000006,9.0201599999999988,2.3846084034452875E-3,14.281919999999998,null,null,null,12,5.8,40,1,null,60,1252.8,27,27,0,0]
[null,15,"Heating circulation pump","Pumps",1,"Units",200,0.45,0,{"$f":"V26*W26*0.001","v":250.56},30.0672,7.9486946781509582E-3,47.606399999999994,null,null,null,12,5.8,40,1,null,{"$f":"G26*E26*T26","v":200},{"$f":"Q26*R26*S26*H26+(168-Q26*R26)*S26*I26","v":1252.8},90,{"$f":"$G26*$E26*$T26*H26","v":90},{"$f":"$G26*$E26*$T26*I26","v":0},{"$f":"$G26*$E26*$T26*I26","v":0}]
[null,{"$f":"ROW()-ROW($B$11)","v":16},null,null,null,null,null,null,null,{"$f":"V27*W27*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G27*E27*T27","v":0},{"$f":"Q27*R27*S27*H27+(168-Q27*R27)*S27*I27","v":0},{"$f":"$G27*$E27*$T27*H27","v":0},{"$f":"$G27*$E27*$T27*H27","v":0},{"$f":"$G27*$E27*$T27*I27","v":0},{"$f":"$G27*$E27*$T27*I27","v":0}]
[null,17,"Hot water direct electric heater","Hot water",1,"Units",6000,0.12,0,2004.48,240.53759999999997,6.3589557425207666E-2,380.85119999999995,null,null,null,12,5.8,40,1,null,6000,334.08,720,720,0,0]
[null,18,null,null,null,null,null,null,null,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,19,"Fridges","Catering single site",2,"Units",120,0.35,0.25,{"$f":"V30*W30*0.001","v":470.01600000000002},56.401919999999997,1.4910654844531452E-2,89.303039999999982,null,null,null,12,5.8,40,1,null,{"$f":"G30*E30*T30","v":240},{"$f":"Q30*R30*S30*H30+(168-Q30*R30)*S30*I30","v":1958.4},{"$f":"$G30*$E30*$T30*H30","v":84},{"$f":"$G30*$E30*$T30*H30","v":84},60,{"$f":"$G30*$E30*$T30*I30","v":60}]
[null,20,"Freezers","Catering single site",1,"Units",150,0.25,0.2,{"$f":"V31*W31*0.001","v":222.48000000000002},26.697600000000005,7.05789268835818E-3,42.2712,null,null,null,12,5.8,40,1,null,{"$f":"G31*E31*T31","v":150},{"$f":"Q31*R31*S31*H31+(168-Q31*R31)*S31*I31","v":1483.2},{"$f":"$G31*$E31*$T31*H31","v":37.5},37.5,30,{"$f":"$G31*$E31*$T31*I31","v":30}]
[null,21,"Cooker hood fan","Catering single site",1,"Units",80,0.2,0,44.544000000000011,5.3452799999999998,1.4131012761157259E-3,8.4633599999999998,null,null,null,12,5.8,40,1,null,80,556.80000000000007,16,16,0,0]
[null,22,"Kitchen ventilation","Fans",1,"Units",200,0.6,0,334.08,40.089600000000004,1.0598259570867945E-2,63.475200000000001,null,null,null,12,5.8,40,1,null,200,1670.3999999999999,120,120,0,0]
[null,23,"Dishwasher","Catering single site",1,"Units",3000,0.15,0,1252.8,150.33599999999998,3.9743473390754791E-2,238.03200000000001,null,null,null,12,5.8,40,1,null,3000,417.59999999999997,450,450,0,0]
[null,24,"Servery","Catering single site",1,"Units",2000,0.2,0,1113.6000000000004,133.63200000000001,3.5327531902893151E-2,211.584,null,null,null,12,{"$f":"$H$7","v":5.8},40,1,null,2000,556.80000000000007,400,400,0,0]
[null,25," "," ",null,null,null,null,null,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,26,null," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,27," "," ",0,null,0,0,0,{"$f":"V38*W38*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G38*E38*T38","v":0},{"$f":"Q38*R38*S38*H38+(168-Q38*R38)*S38*I38","v":0},{"$f":"$G38*$E38*$T38*H38","v":0},{"$f":"$G38*$E38*$T38*H38","v":0},0,{"$f":"$G38*$E38*$T38*I38","v":0}]
[null,28," ",null,0,null,0,0,0,{"$f":"V39*W39*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G39*E39*T39","v":0},{"$f":"Q39*R39*S39*H39+(168-Q39*R39)*S39*I39","v":0},{"$f":"$G39*$E39*$T39*H39","v":0},0,0,{"$f":"$G39*$E39*$T39*I39","v":0}]
[null,29," "," ",0,null,0,0,0,{"$f":"V40*W40*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G40*E40*T40","v":0},{"$f":"Q40*R40*S40*H40+(168-Q40*R40)*S40*I40","v":0},{"$f":"$G40*$E40*$T40*H40","v":0},0,0,{"$f":"$G40*$E40*$T40*I40","v":0}]
[null,30," "," ",0,null,0,0,0,{"$f":"V41*W41*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G41*E41*T41","v":0},{"$f":"Q41*R41*S41*H41+(168-Q41*R41)*S41*I41","v":0},0,0,0,0]
[null,31," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,32," ",null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,33,null," ",0,null,0,0,0,{"$f":"V44*W44*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G44*E44*T44","v":0},{"$f":"Q44*R44*S44*H44+(168-Q44*R44)*S44*I44","v":0},{"$f":"$G44*$E44*$T44*H44","v":0},{"$f":"$G44*$E44*$T44*H44","v":0},{"$f":"$G44*$E44*$T44*I44","v":0},{"$f":"$G44*$E44*$T44*I44","v":0}]
[null,34," "," ",0,null,0,0,0,0,{"$f":"0.00001*S45*V45*($D$6*(Q45*R45*H45)+$D$7*((168-Q45*R45)*I45))","v":0},{"$f":"IF($K$73>0,K45/$K$73,0)","v":0},{"$f":"0.001*S45*V45*($M$6*(Q45*R45*H45)+$M$7*((168-Q45*R45)*I45))","v":0},null,null,null,{"$f":"$H$6","v":12},5.8,40,1,null,0,0,0,0,0,0]
[null,35," "," ",0,null,0,0,0,{"$f":"V46*W46*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G46*E46*T46","v":0},{"$f":"Q46*R46*S46*H46+(168-Q46*R46)*S46*I46","v":0},{"$f":"$G46*$E46*$T46*H46","v":0},{"$f":"$G46*$E46*$T46*H46","v":0},{"$f":"$G46*$E46*$T46*I46","v":0},{"$f":"$G46*$E46*$T46*I46","v":0}]
[null,36," ",null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,37," "," ",0,null,0,0,0,{"$f":"V48*W48*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G48*E48*T48","v":0},{"$f":"Q48*R48*S48*H48+(168-Q48*R48)*S48*I48","v":0},{"$f":"$G48*$E48*$T48*H48","v":0},{"$f":"$G48*$E48*$T48*H48","v":0},{"$f":"$G48*$E48*$T48*I48","v":0},{"$f":"$G48*$E48*$T48*I48","v":0}]
[null,38," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,39," "," ",0,null,0,0,0,{"$f":"V50*W50*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G50*E50*T50","v":0},{"$f":"Q50*R50*S50*H50+(168-Q50*R50)*S50*I50","v":0},{"$f":"$G50*$E50*$T50*H50","v":0},{"$f":"$G50*$E50*$T50*H50","v":0},{"$f":"$G50*$E50*$T50*I50","v":0},{"$f":"$G50*$E50*$T50*I50","v":0}]
[null,40," ",null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,41," "," ",0,null,0,0,0,{"$f":"V52*W52*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G52*E52*T52","v":0},{"$f":"Q52*R52*S52*H52+(168-Q52*R52)*S52*I52","v":0},{"$f":"$G52*$E52*$T52*H52","v":0},{"$f":"$G52*$E52*$T52*H52","v":0},0,{"$f":"$G52*$E52*$T52*I52","v":0}]
[null,42," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,43," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,44," ",null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,45," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,46," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,47," "," ",0,null,0,0,0,{"$f":"V58*W58*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G58*E58*T58","v":0},{"$f":"Q58*R58*S58*H58+(168-Q58*R58)*S58*I58","v":0},{"$f":"$G58*$E58*$T58*H58","v":0},0,0,{"$f":"$G58*$E58*$T58*I58","v":0}]
[null,48,null,null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,49," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,50," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,51," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,52," ",null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,53," "," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,54,null," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,55,null," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,56,null,null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,{"$f":"$G67*$E67*$T67*H67","v":0},{"$f":"$G67*$E67*$T67*H67","v":0},{"$f":"$G67*$E67*$T67*I67","v":0},{"$f":"$G67*$E67*$T67*I67","v":0}]
[null,57,null," ",0,null,0,0,0,{"$f":"V68*W68*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G68*E68*T68","v":0},{"$f":"Q68*R68*S68*H68+(168-Q68*R68)*S68*I68","v":0},{"$f":"$G68*$E68*$T68*H68","v":0},{"$f":"$G68*$E68*$T68*H68","v":0},{"$f":"$G68*$E68*$T68*I68","v":0},{"$f":"$G68*$E68*$T68*I68","v":0}]
[null,58,null," ",0,null,0,0,0,{"$f":"V69*W69*0.001","v":0},0,0,0,null,null,null,12,5.8,40,1,null,{"$f":"G69*E69*T69","v":0},{"$f":"Q69*R69*S69*H69+(168-Q69*R69)*S69*I69","v":0},{"$f":"$G69*$E69*$T69*H69","v":0},{"$f":"$G69*$E69*$T69*H69","v":0},{"$f":"$G69*$E69*$T69*I69","v":0},{"$f":"$G69*$E69*$T69*I69","v":0}]
[null,59,null," ",0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[null,60,null,null,0,null,0,0,0,0,0,0,0,null,null,null,12,5.8,40,1,null,0,0,0,0,0,0]
[]
[null,null," "," ",null,null,null,null,"Total",{"$f":"SUM(J$12:J$72)","v":31522.156800000004},{"$f":"SUM(K$12:K$72)","v":3782.6588159999992},{"$f":"SUM(L$12:L$72)","v":1.0000000000000004},{"$f":"SUM(M$12:M$72)","v":5989.2097919999997},null,null,null,null,null,null,null,null,{"$f":"SUM(V$12:V$72)","v":23474},{"$f":"J73*1000/V73","v":1342.854085371049},{"$f":"SUM(X$12:X$72)","v":9443.4000000000015},{"$f":"SUM(Y$12:Y$72)","v":9443.4000000000015},{"$f":"SUM(Z$12:Z$72)","v":1329.2},{"$f":"SUM(AA$12:AA$72)","v":1329.2}]
[null,null,null,null,null,null,null,null,"Metered electricity copied from Cell E4 for reconciliation",{"$f":"IF(E4>0,E4,\"\")","v":""},null,{"$f":"IF(E4>0,ResultsEnergy/J74-1,\"\")","v":""},null,null,null,null,null,null,null,null,null,null,null,181800,181800,54600,54600]
[null,"Blue box for printing"]
[null,null,"Summary Output Table",null,null,null,null,null,null,"Annual energy use (kWh)","Annual cost of energy (£)","% of total cost",{"$f":"M11","v":"Emissions (kgCO2)"},null,"kWh/m2 per annum TFA"]
[null,null,"Sub-meter reference","Load list"]
[null,{"$f":"ROW()-ROW($B$11)","v":67},"No meter","Space heating",null,null,null,null,null,{"$f":"SUM(IF($D$13:$D$72=$D78,J$13:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,K$12:K$72,0))","v":0},{"$f":"IF($K$73>0,K78/$K$73,0)","v":0},{"$f":"SUM(IF($D$13:$D$72=$D78,M$13:M$72,0))","v":0},null,{"$f":"J78/$G$4","v":0},null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D78,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D78,AA$12:AA$72,0))","v":0}]
[null,68,"E02","Hot water",null,null,null,null,null,{"$f":"SUM(IF($D$13:$D$72=$D79,J$13:J$72,0))","v":2004.48},{"$f":"SUM(IF($D$12:$D$72=$D79,K$12:K$72,0))","v":240.53759999999997},6.3589557425207666E-2,{"$f":"SUM(IF($D$13:$D$72=$D79,M$13:M$72,0))","v":380.85119999999995},null,2.00448,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D79,V$12:V$72,0))","v":6000},{"$f":"SUM(IF($D$12:$D$72=$D79,W$12:W$72,0))","v":334.08},{"$f":"SUM(IF($D$12:$D$72=$D79,X$12:X$72,0))","v":720},{"$f":"SUM(IF($D$12:$D$72=$D79,Y$12:Y$72,0))","v":720},{"$f":"SUM(IF($D$12:$D$72=$D79,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D79,AA$12:AA$72,0))","v":0}]
[null,69,"E03","Fans",null,null,null,null,null,{"$f":"SUM(IF($D$13:$D$72=$D80,J$13:J$72,0))","v":334.08},{"$f":"SUM(IF($D$12:$D$72=$D80,K$12:K$72,0))","v":40.089600000000004},1.0598259570867945E-2,{"$f":"SUM(IF($D$13:$D$72=$D80,M$13:M$72,0))","v":63.475200000000001},null,0.33407999999999999,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D80,V$12:V$72,0))","v":200},{"$f":"SUM(IF($D$12:$D$72=$D80,W$12:W$72,0))","v":1670.3999999999999},{"$f":"SUM(IF($D$12:$D$72=$D80,X$12:X$72,0))","v":120},{"$f":"SUM(IF($D$12:$D$72=$D80,Y$12:Y$72,0))","v":120},{"$f":"SUM(IF($D$12:$D$72=$D80,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D80,AA$12:AA$72,0))","v":0}]
[null,70,"E04","Pumps",null,null,null,null,null,{"$f":"SUM(IF($D$13:$D$72=$D81,J$13:J$72,0))","v":325.72800000000001},{"$f":"SUM(IF($D$12:$D$72=$D81,K$12:K$72,0))","v":39.087359999999997},1.0333303081596246E-2,{"$f":"SUM(IF($D$13:$D$72=$D81,M$13:M$72,0))","v":61.888319999999993},null,0.32572800000000002,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D81,V$12:V$72,0))","v":260},{"$f":"SUM(IF($D$12:$D$72=$D81,W$12:W$72,0))","v":2505.6},{"$f":"SUM(IF($D$12:$D$72=$D81,X$12:X$72,0))","v":117},{"$f":"SUM(IF($D$12:$D$72=$D81,Y$12:Y$72,0))","v":117},{"$f":"SUM(IF($D$12:$D$72=$D81,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D81,AA$12:AA$72,0))","v":0}]
[null,71,"E05","Refrigeration",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D82,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D82,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D82,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D82,AA$12:AA$72,0))","v":0}]
[null,72,"E06","Lighting (internal)",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D83,J$12:J$72,0))","v":20485.084800000001},{"$f":"SUM(IF($D$12:$D$72=$D83,K$12:K$72,0))","v":2458.210176},0.64986304490433866,{"$f":"SUM(IF($D$13:$D$72=$D83,M$13:M$72,0))","v":3892.1661119999999},null,20.485084799999999,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D83,V$12:V$72,0))","v":9644},{"$f":"SUM(IF($D$12:$D$72=$D83,W$12:W$72,0))","v":10900.8},{"$f":"SUM(IF($D$12:$D$72=$D83,X$12:X$72,0))","v":6438.9000000000005},{"$f":"SUM(IF($D$12:$D$72=$D83,Y$12:Y$72,0))","v":6438.9000000000005},{"$f":"SUM(IF($D$12:$D$72=$D83,Z$12:Z$72,0))","v":650.20000000000005},{"$f":"SUM(IF($D$12:$D$72=$D83,AA$12:AA$72,0))","v":650.20000000000005}]
[null,73,"E07","Lighting (external)",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D84,J$12:J$72,0))","v":389.66399999999999},{"$f":"SUM(IF($D$12:$D$72=$D84,K$12:K$72,0))","v":46.75968000000001},1.2361590689124425E-2,{"$f":"SUM(IF($D$13:$D$72=$D84,M$13:M$72,0))","v":74.03616000000001},null,0.38966400000000001,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D84,V$12:V$72,0))","v":450},{"$f":"SUM(IF($D$12:$D$72=$D84,W$12:W$72,0))","v":865.92},{"$f":"SUM(IF($D$12:$D$72=$D84,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D84,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D84,Z$12:Z$72,0))","v":99},{"$f":"SUM(IF($D$12:$D$72=$D84,AA$12:AA$72,0))","v":99}]
[null,74,"E08","Small power",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D85,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D85,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D85,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D85,AA$12:AA$72,0))","v":0}]
[null,75,"E09","ICT",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D86,J$12:J$72,0))","v":4879.68},{"$f":"SUM(IF($D$12:$D$72=$D86,K$12:K$72,0))","v":585.5616},0.15480159022621195,{"$f":"SUM(IF($D$13:$D$72=$D86,M$13:M$72,0))","v":927.13919999999996},null,4.8796800000000005,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D86,V$12:V$72,0))","v":1450},{"$f":"SUM(IF($D$12:$D$72=$D86,W$12:W$72,0))","v":11913.6},{"$f":"SUM(IF($D$12:$D$72=$D86,X$12:X$72,0))","v":1060},{"$f":"SUM(IF($D$12:$D$72=$D86,Y$12:Y$72,0))","v":1060},{"$f":"SUM(IF($D$12:$D$72=$D86,Z$12:Z$72,0))","v":490},{"$f":"SUM(IF($D$12:$D$72=$D86,AA$12:AA$72,0))","v":490}]
[null,76,"E10","Catering single site",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D87,J$12:J$72,0))","v":3103.4400000000005},{"$f":"SUM(IF($D$12:$D$72=$D87,K$12:K$72,0))","v":372.4128},9.8452654102653303E-2,{"$f":"SUM(IF($D$13:$D$72=$D87,M$13:M$72,0))","v":589.65359999999998},null,3.1034400000000004,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D87,V$12:V$72,0))","v":5470},{"$f":"SUM(IF($D$12:$D$72=$D87,W$12:W$72,0))","v":4972.8000000000011},{"$f":"SUM(IF($D$12:$D$72=$D87,X$12:X$72,0))","v":987.5},{"$f":"SUM(IF($D$12:$D$72=$D87,Y$12:Y$72,0))","v":987.5},{"$f":"SUM(IF($D$12:$D$72=$D87,Z$12:Z$72,0))","v":90},{"$f":"SUM(IF($D$12:$D$72=$D87,AA$12:AA$72,0))","v":90}]
[null,77,"E11","Catering multiple site",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D88,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D88,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D88,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D88,AA$12:AA$72,0))","v":0}]
[null,78,"No meter","Humidification",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D89,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D89,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D89,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D89,AA$12:AA$72,0))","v":0}]
[null,79,"No meter","Controls",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D90,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D90,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D90,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D90,AA$12:AA$72,0))","v":0}]
[null,80,"E14","Vertical transport",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D91,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D91,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D91,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D91,AA$12:AA$72,0))","v":0}]
[null,81,"E15","Other (Regulated)",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D92,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D92,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D92,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D92,AA$12:AA$72,0))","v":0}]
[null,82,"E16","Other (Non-regulated)",null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D93,J$12:J$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,K$12:K$72,0))","v":0},0,{"$f":"SUM(IF($D$13:$D$72=$D93,M$13:M$72,0))","v":0},null,0,null,null,null,null,null,null,{"$f":"SUM(IF($D$12:$D$72=$D93,V$12:V$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,W$12:W$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,X$12:X$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,Y$12:Y$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,Z$12:Z$72,0))","v":0},{"$f":"SUM(IF($D$12:$D$72=$D93,AA$12:AA$72,0))","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null," ",null,null,null,null,null,"Totals",{"$f":"SUM(J78:J93)","v":31522.156800000004},{"$f":"SUM(K78:K93)","v":3782.6588160000001},{"$f":"SUM(L76:L94)","v":1.0000000000000002},{"$f":"SUM(M78:M93)","v":5989.2097919999987},null,{"$f":"J95/$G$4","v":31.522156800000005},null,null,null,null,null,null,{"$f":"SUM(V78:V93)","v":23474},{"$f":"J95*1000/V95","v":1342.854085371049},{"$f":"SUM(X78:X93)","v":9443.4000000000015},{"$f":"SUM(Y78:Y93)","v":9443.4000000000015},{"$f":"SUM(Z78:Z93)","v":1329.2},{"$f":"SUM(AA78:AA93)","v":1329.2}]
[null,"Metering reports "]
[]
[]
[]
[null,null,"Tracked Changes table"]
[]
[null,7,{"$f":"\"Number of Changes in the list below: \"&TEXT(nChange,\"#\")","v":"Number of Changes in the list below: 7"},null,null,null,null,null,null,null,"Results after change",null,null,null,null,null,"Change from previous case"]
["Change","Mea-sure*","IItems(s) being changed (can be edited)","Parameter being changed",null,null,"No.of cells changed","Previous value","New","Energy","Cost","% change ","Emissions",null,null,null,"Change","Change","Change","Change"]
[null,null,null,null,null,null,null,null,"Value","kWh","(£)","of base","kgCO2",null,null,null,"kWh","(£)","£ (%)","kgCO2"]
[null,null,"Base Case",null,null,null,0,null,null,35242.97280000001,4229.16,{"$f":"IF($K105*$K$105=0,\"\",K105/$K$105)","v":1},6696.1648320000022]
["ChangeA",1,"Hall lighting","Rated Watts (or W/m2)",null,null,1,35,26,34385.884800000007,4126.3100000000004,0.97568074984157627,6533.3181120000017,null,null,null,{"$f":"IF($K106*$K$105=0,\"\",INDEX(J:J,ROW(),1)-INDEX(J:J,ROW()-1,1))","v":-857.08800000000338},{"$f":"IF($K106*$K$105=0,\"\",INDEX(K:K,ROW(),1)-INDEX(K:K,ROW()-1,1))","v":-102.84999999999945},{"$f":"IF($K106*$K$105=0,\"\",R106/$K$105)","v":-2.4319250158423768E-2},{"$f":"IF($K106*$K$105=0,\"\",INDEX(M:M,ROW(),1)-INDEX(M:M,ROW()-1,1))","v":-162.84672000000046}]
["ChangeB",1,"Classroom main lighting","Rated Watts (or W/m2)",null,null,1,11.5,8.1,31424.784000000011,3770.97,0.89165933660585084,5970.7089600000018,null,null,null,-2961.1007999999965,-355.3400000000006,-8.4021413235725442E-2,-562.60915199999999]
["ChangeC",3,"Classroom main lighting","Load factor    \"in use\"",null,null,3,0.8,0.65,28655.750400000015,3438.69,0.81309054280282611,5444.5925760000018,null,null,null,-2769.0335999999952,-332.27999999999975,-7.8568793803024659E-2,-526.11638399999993]
["ChangeD",2,"Classroom displays","Rated Watts (or W/m2)",null,null,1,60,150,30081.350400000014,3609.76,0.85354065582763483,5715.4565760000023,null,null,null,1425.5999999999985,171.07000000000016,4.0450113024808748E-2,270.86400000000049]
["ChangeE",2,"Network hub cabinet","Rated Watts (or W/m2)",null,null,1,120,250,30954.950400000012,3714.59,0.87832808406397489,5881.4405760000018,null,null,null,873.59999999999854,104.82999999999993,2.4787428236340062E-2,165.98399999999947]
["ChangeF",3,"Servery","Load factor   \"out of hours\"",null,null,1,0.12,0,29964.230400000011,3595.71,0.85021848310302761,5693.2037760000021,null,null,null,-990.72000000000116,-118.88000000000011,-2.8109600960947355E-2,-188.23679999999968]
["ChangeG",4,"General change","Days per week      ",null,null,1,5.4,5.8,31522.156800000004,3782.66,0.89442347889415397,5989.2097919999997,null,null,null,1557.926399999993,186.94999999999982,4.4204995791126328E-2,296.00601599999754]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","",""]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","",""]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","",""]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","",""]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"-",null,null,null,null,null,null,null,null,null,"",null,null,null,null,"","","","",null," "]
[null,"* Note: In tha table below, changes are grouped together with the same Measure number that you select in the table above",null,null,null,null,null,null,null,null,null,null,null,null,null,"Total",{"$f":"SUM(Q106:Q123)","v":-3720.8160000000062},{"$f":"SUM(R106:R123)","v":-446.5},-0.10557652110584612,-706.95504000000255,null," "]
[null,null," ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,"Mea-sure*","Summary of the effect of the Changes specified above, grouped by Measure",null,null,null,null,null,"Changes included","kWh","Cost (£)","Percent","kgCO2",null,null,null,null,null,null,null,null," "]
[null,1,"Classroom and hall relamping",null,null,null,null,null,{"$f":"IF($B$106=B127,\"A\",\"\")&IF($B$107=B127,\"B\",\"\")&IF($B$108=B127,\"C\",\"\")&IF($B$109=B127,\"D\",\"\")&IF($B$110=B127,\"E\",\"\")&IF($B$111=B127,\"F\",\"\")&IF($B$112=B127,\"G\",\"\")&IF($B$113=B127,\"H\",\"\")&IF($B$114=B127,\"I\",\"\")&IF($B$115=B127,\"J\",\"\")&IF($B$116=B127,\"K\",\"\")&IF($B$117=B127,\"L\",\"\")&IF($B$118=B127,\"M\",\"\")&IF($B$119=B127,\"N\",\"\")&IF($B$120=B127,\"O\",\"\")&IF($B$121=B127,\"P\",\"\")&IF($B$122=B127,\"Q\",\"\")&IF($B$123=B127,\"R\",\"\")","v":"AB"},{"$f":"SUM(IF($B$106:$B$123=$B127,Q$106:Q$123,0))","v":-3818.1887999999999},{"$f":"SUM(IF($B$106:$B$123=$B127,R$106:R$123,0))","v":-458.19000000000005},{"$f":"IF($K$105=\"\",\"\",K127/$K$105)","v":-0.1083406633941492},{"$f":"SUM(IF($B$106:$B$123=$B127,T$106:T$123,0))","v":-725.45587200000045},null,null,null,null,null,null,null,null," "]
[null,2,"Classroom display upgrades and associated network hub cabinet expansion",null,null,null,null,null,{"$f":"IF($B$106=B128,\"A\",\"\")&IF($B$107=B128,\"B\",\"\")&IF($B$108=B128,\"C\",\"\")&IF($B$109=B128,\"D\",\"\")&IF($B$110=B128,\"E\",\"\")&IF($B$111=B128,\"F\",\"\")&IF($B$112=B128,\"G\",\"\")&IF($B$113=B128,\"H\",\"\")&IF($B$114=B128,\"I\",\"\")&IF($B$115=B128,\"J\",\"\")&IF($B$116=B128,\"K\",\"\")&IF($B$117=B128,\"L\",\"\")&IF($B$118=B128,\"M\",\"\")&IF($B$119=B128,\"N\",\"\")&IF($B$120=B128,\"O\",\"\")&IF($B$121=B128,\"P\",\"\")&IF($B$122=B128,\"Q\",\"\")&IF($B$123=B128,\"R\",\"\")","v":"DE"},{"$f":"SUM(IF($B$106:$B$123=$B128,Q$106:Q$123,0))","v":2299.1999999999971},{"$f":"SUM(IF($B$106:$B$123=$B128,R$106:R$123,0))","v":275.90000000000009},{"$f":"IF($K$105=\"\",\"\",K128/$K$105)","v":6.5237541261148807E-2},{"$f":"SUM(IF($B$106:$B$123=$B128,T$106:T$123,0))","v":436.84799999999996},null,null,null,null,null,null,null,null," "]
[null,3,"Operational changes to classroom lighting and servery equipment",null,null,null,null,null,"CF",{"$f":"SUM(IF($B$106:$B$123=$B129,Q$106:Q$123,0))","v":-3759.7535999999964},{"$f":"SUM(IF($B$106:$B$123=$B129,R$106:R$123,0))","v":-451.15999999999985},-0.10667839476397201,{"$f":"SUM(IF($B$106:$B$123=$B129,T$106:T$123,0))","v":-714.3531839999996},null,null,null,null,null,null,null,null," "]
[null,4,"Extended weekend use",null,null,null,null,null,"G",{"$f":"SUM(IF($B$106:$B$123=$B130,Q$106:Q$123,0))","v":1557.926399999993},{"$f":"SUM(IF($B$106:$B$123=$B130,R$106:R$123,0))","v":186.94999999999982},4.4204995791126328E-2,{"$f":"SUM(IF($B$106:$B$123=$B130,T$106:T$123,0))","v":296.00601599999754},null,null,null,null,null,null,null,null," "]
[null,5,null,null,null,null,null,null,"",{"$f":"SUM(IF($B$106:$B$123=$B131,Q$106:Q$123,0))","v":0},{"$f":"SUM(IF($B$106:$B$123=$B131,R$106:R$123,0))","v":0},0,{"$f":"SUM(IF($B$106:$B$123=$B131,T$106:T$123,0))","v":0},null,null,null,null,null,null,null,null," "]
[null,6,null,null,null,null,null,null,"",{"$f":"SUM(IF($B$106:$B$123=$B132,Q$106:Q$123,0))","v":0},{"$f":"SUM(IF($B$106:$B$123=$B132,R$106:R$123,0))","v":0},0,{"$f":"SUM(IF($B$106:$B$123=$B132,T$106:T$123,0))","v":0},null,null,null,null,null,null,null,null," "]
[null,7,null,null,null,null,null,null,"",{"$f":"SUM(IF($B$106:$B$123=$B133,Q$106:Q$123,0))","v":0},{"$f":"SUM(IF($B$106:$B$123=$B133,R$106:R$123,0))","v":0},0,{"$f":"SUM(IF($B$106:$B$123=$B133,T$106:T$123,0))","v":0},null,null,null,null,null,null,null,null," "]
[null,8,null,null,null,null,null,null,"",{"$f":"SUM(IF($B$106:$B$123=$B134,Q$106:Q$123,0))","v":0},{"$f":"SUM(IF($B$106:$B$123=$B134,R$106:R$123,0))","v":0},0,{"$f":"SUM(IF($B$106:$B$123=$B134,T$106:T$123,0))","v":0},null,null,null,null,null,null,null,null," "]
[null,9,null,null,null,null,null,null,"",{"$f":"SUM(IF($B$106:$B$123=$B135,Q$106:Q$123,0))","v":0},{"$f":"SUM(IF($B$106:$B$123=$B135,R$106:R$123,0))","v":0},0,{"$f":"SUM(IF($B$106:$B$123=$B135,T$106:T$123,0))","v":0},null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,"Totals",{"$f":"SUM(J127:J135)","v":-3720.8160000000062},{"$f":"SUM(K127:K135)","v":-446.5},{"$f":"SUM(L127:L135)","v":-0.10557652110584606},{"$f":"SUM(M127:M135)","v":-706.95504000000255},null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"m2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,"Units",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null," "]
[]
[]
[]
[null,null,"Sub meter lookup list"]
[null,null,"No meter"]
[null,null,"E01"]
[null,null,"E02"]
[null,null,"E03"]
[null,null,"E04"]
[null,null,"E05"]
[null,null,"E06"]
[null,null,"E07"]
[null,null,"E08"]
[null,null,"E09",null,null,{"$f":"SUMIF(C78:C93, \"E1\", J78:J93)","v":0}]
[null,null,"E10"]
[null,null,"E11"]
[null,null,"E12"]
[null,null,"E13"]
[null,null,"E14"]
[null,null,"E15"]
[null,null,"E16"]
[null,null,"E17"]
[null,null,"E18"]
[null,null,"E19"]
[null,null,"E20"]
[null,null,"E21"]
[null,null,"E22"]
[null,null,"E23"]
[null,null,"E24"]
[null,null,"E25"]
[null,null,"E26"]
[null,null,"E27"]
[null,null,"E28"]
[null,null,"E29"]
[null,null,"E30"]

{"sheet":"Sub-Meter Report (optional)","index":2,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":false,"merged":[[2,5,2,7],[22,3,24,5],[27,3,29,5],[22,10,24,11]]}
[]
[null,null,"Sub-meter Report",null,null,"A",null,null,null,"Monthly Table",null,null,"M"]
[null,null,null,null,null,"Do not adjust grey boxes",null,null,null,null,null,null,"Do not adjust grey boxes"]
[null,null,"Sub meter allocation",{"$f":"'Energy input sheet'!J76","v":"Annual energy use (kWh)"},{"$f":"'Energy input sheet'!K76","v":"Annual cost of energy (£)"},{"$f":"'Energy input sheet'!L76","v":"% of total cost"},"Location (optional)","Meter type (optional)",null,{"$f":"C4","v":"Sub meter allocation"},"Modelled submeter values kWh pcm","  Actual  submeter values kWh","Variation vs load calc","Notes"]
[null,null,"E01",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E01\", 'Energy input sheet'!$J$78:$J$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E01\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E01\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E01",{"$f":"D5/12","v":0},0,{"$f":"L5-K5","v":0}]
[null,null,"E02",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E02\", 'Energy input sheet'!J78:J94)","v":2004.48},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E02\", 'Energy input sheet'!K78:K94)","v":240.53759999999997},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E02\", 'Energy input sheet'!L78:L94)","v":6.3589557425207666E-2},null,null,null,"E02",167.04,200,{"$f":"L6-K6","v":32.960000000000008}]
[null,null,"E03",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E03\", 'Energy input sheet'!J78:J94)","v":334.08},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E03\", 'Energy input sheet'!K78:K94)","v":40.089600000000004},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E03\", 'Energy input sheet'!L78:L94)","v":1.0598259570867945E-2},null,null,null,"E03",27.84,45,17.16]
[null,null,"E04",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E04\", 'Energy input sheet'!J78:J94)","v":325.72800000000001},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E04\", 'Energy input sheet'!K78:K94)","v":39.087359999999997},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E04\", 'Energy input sheet'!L78:L94)","v":1.0333303081596246E-2},null,null,null,"E04",27.144000000000002,0,-27.144000000000002]
[null,null,"E05",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E05\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E05\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E05\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E05",0,0,0]
[null,null,"E06",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E06\", 'Energy input sheet'!J78:J94)","v":20485.084800000001},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E06\", 'Energy input sheet'!K78:K94)","v":2458.210176},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E06\", 'Energy input sheet'!L78:L94)","v":0.64986304490433866},null,null,null,"E06",1707.0904,1600,-107.09040000000005]
[null,null,"E07",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E07\", 'Energy input sheet'!J78:J94)","v":389.66399999999999},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E07\", 'Energy input sheet'!K78:K94)","v":46.75968000000001},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E07\", 'Energy input sheet'!L78:L94)","v":1.2361590689124425E-2},null,null,null,"E07",32.472000000000001,30,-2.4720000000000013]
[null,null,"E08",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E08\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E08\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E08\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E08",0,0,0]
[null,null,"E09",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E09\", 'Energy input sheet'!J78:J94)","v":4879.68},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E09\", 'Energy input sheet'!K78:K94)","v":585.5616},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E09\", 'Energy input sheet'!L78:L94)","v":0.15480159022621195},null,null,null,"E09",406.64000000000004,400,-6.6400000000000432]
[null,null,"E10",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E10\", 'Energy input sheet'!J78:J94)","v":3103.4400000000005},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E10\", 'Energy input sheet'!K78:K94)","v":372.4128},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E10\", 'Energy input sheet'!L78:L94)","v":9.8452654102653303E-2},null,null,null,"E10",258.62000000000006,267,8.3799999999999386]
[null,null,"E11",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E11\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E11\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E11\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E11",0,0,0]
[null,null,"E12",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E12\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E12\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E12\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E12",0,0,0]
[null,null,"E13",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E13\", 'Energy input sheet'!$J$78:$J$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E13\", 'Energy input sheet'!$K$78:$K$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E13\", 'Energy input sheet'!$L$78:$L$94)","v":0},null,null,null,"E13",0,0,0]
[null,null,"E14",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E14\", 'Energy input sheet'!$J$78:$J$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E14\", 'Energy input sheet'!$K$78:$K$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E14\", 'Energy input sheet'!$L$78:$L$94)","v":0},null,null,null,"E14",0,0,0]
[null,null,"E15",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E15\", 'Energy input sheet'!$J$78:$J$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E15\", 'Energy input sheet'!$K$78:$K$94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E15\", 'Energy input sheet'!$L$78:$L$94)","v":0},null,null,null,"E15",0,0,0]
[null,null,"E16",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E16\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E16\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E16\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E16",0,0,0]
[null,null,"E17",{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E17\", 'Energy input sheet'!J78:J94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E17\", 'Energy input sheet'!K78:K94)","v":0},{"$f":"SUMIF('Energy input sheet'!$C$78:$C$93, \"E17\", 'Energy input sheet'!L78:L94)","v":0},null,null,null,"E17",0,0,0]
[]
[null,null,null,"Reconciliation check with Summary Output Table",null,null,null,null,null,null,"Totals, and variance between  main meters and modelled values"]
[]
[]
[null,null,null,{"$f":"SUM(D5:D21)","v":31522.156800000004},3782.6588160000001,1.0000000000000002,null,null,null,"Monthly",2626.8463999999999,2542]
[null,null,null,null,null,null,null,null,null," "]
[null,null,null,"See notes on sub-metering problems and associated checklist",null,null,null,null,null,"Annual",{"$f":"K26*12","v":31522.156799999997},{"$f":"L26*12","v":30504}," "]
[]
[null,null,null,null,null,null,null,null,null,"Meter  variance",{"$f":"K28-L28","v":1018.156799999997},{"$f":"(1-K28/L28)","v":-3.3377812745869262E-2}]
[]
[null,null,null,"Back to Summary Output Table",null,null,null,null,null,"Modelled vs billed",{"$f":"K28-'Energy input sheet'!E4","v":31522.156799999997},{"$f":"(1-'Energy input sheet'!E4/L28)","v":1}]

{"sheet":"Output charts (ISO 12)","index":3,"n_rows":132,"n_cols":56,"rows_kept":132,"cut":false,"hidden":false,"merged":[[130,1,132,11],[131,26,133,36]]}
[]
[]
[null,"Operational energy, carbon dioxide emissions, and energy cost histograms"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,"Target or benchmark","Space heating","Hot water","Fans","Pumps","Refrigeration","Lighting (internal)","Lighting (external)","Small power","ICT","Catering (central)","Catering (distributed)","Humidification","Controls","Vertical transport","Other (Regulated)","Other (Non-regulated)"]
[null,"Projected kWh/m2 p.a.",0,{"$f":"'Energy input sheet'!O78","v":0},{"$f":"'Energy input sheet'!O79","v":2.00448},{"$f":"'Energy input sheet'!O80","v":0.33407999999999999},{"$f":"'Energy input sheet'!O81","v":0.32572800000000002},{"$f":"'Energy input sheet'!O82","v":0},{"$f":"'Energy input sheet'!O83","v":20.485084799999999},{"$f":"'Energy input sheet'!O84","v":0.38966400000000001},{"$f":"'Energy input sheet'!O85","v":0},{"$f":"'Energy input sheet'!O86","v":4.8796800000000005},{"$f":"'Energy input sheet'!O87","v":3.1034400000000004},{"$f":"'Energy input sheet'!O88","v":0},{"$f":"'Energy input sheet'!O89","v":0},{"$f":"'Energy input sheet'!O90","v":0},{"$f":"'Energy input sheet'!O91","v":0},{"$f":"'Energy input sheet'!O92","v":0},{"$f":"'Energy input sheet'!O93","v":0}]
[null,"Target or benchmark",{"$f":"'Energy input sheet'!L4","v":50},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,null,{"$f":"C23","v":"Target or benchmark"},{"$f":"D23","v":"Space heating"},"Hot water","Fans","Pumps","Refrigeration","Lighting (internal)","Lighting (external)","Small power","ICT","Catering (central)","Catering (distributed)","Humidification","Controls","Vertical transport","Other (Regulated)","Other (Non-regulated)"]
[null,"Projected kgCO2/m2 p.a.",0,{"$f":"'Energy input sheet'!$O$78*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$79*'Energy input sheet'!$M$6","v":0.3808512},{"$f":"'Energy input sheet'!$O$80*'Energy input sheet'!$M$6","v":6.3475199999999996E-2},{"$f":"'Energy input sheet'!$O$81*'Energy input sheet'!$M$6","v":6.1888320000000004E-2},{"$f":"'Energy input sheet'!$O$82*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$83*'Energy input sheet'!$M$6","v":3.892166112},{"$f":"'Energy input sheet'!$O$84*'Energy input sheet'!$M$6","v":7.4036160000000004E-2},{"$f":"'Energy input sheet'!$O$85*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$86*'Energy input sheet'!$M$6","v":0.92713920000000005},{"$f":"'Energy input sheet'!$O$87*'Energy input sheet'!$M$6","v":0.58965360000000011},{"$f":"'Energy input sheet'!$O$88*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$89*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$90*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$91*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$92*'Energy input sheet'!$M$6","v":0},{"$f":"'Energy input sheet'!$O$93*'Energy input sheet'!$M$6","v":0}]
[null,{"$f":"B25","v":"Target or benchmark"},{"$f":"'Energy input sheet'!M4","v":9.5},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Change against base-case charts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Sub-Meter allocation charts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"A",null,null,null,null,null,null,null,null,null,null,null,"M"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Note that the vertical axes may need to be adjusted to show your data range"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Note that the vertical axes may need to be adjusted to show your data range"]

{"sheet":"Example charts","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Notes on use","index":5,"n_rows":56,"n_cols":2,"rows_kept":56,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Notes on use - if you have a completed example sheet with measures you can go straight to Section 3 below"]
[null,"Advanced users go to Section 5."]
[]
[null,"1. With a new sheet enter item data and reconcile with metered consumption (see 4. below to get a new sheet):"]
[null,"1.1 Review your \"types of use\" and if necessary edit/move/enter as free text in column D below the main table in the SUMMARY section, unhide or hide rows here as necessary"]
[null,"1.2 Enter the Items data in columns C to I and overall data below the items (unit costs, Hours \"in use\" per day and weeks per year). Enter the Building/Site name in B2."]
[]
[null,"2. Once you have a reconciled sheet, you can easily add and record reversible Changes each of which update one or more entries in the main table"]
[null,"2.1 Identify data that you want to change/improve - it must be a single cell or a block of IDENTICAL, NUMERIC entries (no formulae). "]
[null,"2.2 .. for example it might a single load factor or four Load factors of 90% that you want to change to 70%. It could also be in the overall data for example hours \"in use\" per day or one or both of the unit cost entries."]
[null,"2.3 Press the \"Add next Change\" button (or hit the key combo given above it). Any problems with your data selection it should tell you - correct them and re-try."]
[null,"2.4 It tells you the old value and asks for the new value (of course just one - they're all the same) so enter it.  NB % must be entered as e.g. 0.65 for 65%, and no commas."]
[null,"2.5 It makes the change(s), recalculates, colours the data range and records the details of the changes and the changed consumptions & costs, in the Changes table below the items list."]
[null,"2.6 You can enter a measure number in the Changes table (column B) to gather all the Changes with a particular number as a Measure in the next table below. The Measures numbers can be any order and edited at any time."]
[null,"2.7 Once you're happy with the Change and its effect, repeat for the next Change from step 2.1. But if you're not happy, you can delete the Change by pressing the \"Delete last Change\" button, then redo from 2.1."]
[null,"2.8 You can over-write the descriptions or formulae in columns C or D of the Changes or Measures tables to clarify them, you can later copy in this formula back in if needed again."]
[]
[null,"3. Review and revise the Changes, the Measures and their effect"]
[null,"3.1 You can Apply and Revert the Changes at will - their details are recorded in the table so can be re-applied by hitting the \"Apply\" button. This is useful for many purposes e.g. printing before-and-after sheets."]
[null,"3.2 You can remove the colours and re-apply. You can add gridlines every four rows to aid legibility, and remove them."]
[null,"3.3 You can revise the order and the way that Changes are grouped into Measures by changing the Measure numbers in the Changes table - they can be in any order"]
[null,"3.4 You can modify the Changes: use Delete the last Change one or more times - this is NOT reversible, but the block(s) of data will then be coloured grey (until you next \"Remove Colours\") so you can Add in again"]
[null,"3.5 ... or as a little but useful cheat you can manually alter the \"New Value\" of any change in column H of the Changes table (or indeed the \"Previous Value\"). Then just \"Revert Changes\" and \"Apply Changes\".. Check the Base Case results are still as expected."]
[]
[null,"4. Getting back to a blank sheet to re-use a completed sheet (after saving with new name)"]
[null,"4.1 The \"Erase all entries for blank sheet\" button can be used. Alternatively carry out the following:"]
[null,"4.2 Delete all Changes by successive use of the \"Delete last Change\" button - the Changes table should then just say \"Base Case\"  (no changes) and have zero Number of Changes"]
[null,"4.3 Unhide any rows between 4 and the bottom of the sheet say row 100 - can re-hide some on completion. To insert or delete rows see 5. below."]
[null,"4.4 Delete data in the main table cells C13 to I71. You'll need to review all the overall data at the top for example the Building/site name and unit costs, hours per day and weeks."]
[]
[null,"Advanced users"]
[null,"5. Changing the sheet rows or columns - SAVE FIRST!"]
[null,"5.1 Main table rows: you can delete rows freely. You can insert row(s) if you then copy a whole row with formulae into the new one(s)."]
[null,"5.2 Main table ordering: you can drag a row with shift-insert to the new position, but the following may be preferable:"]
[null,"5.3 Main table ordering: ..or as a favourite alternative: enter numbers in the desired order in Column A temporarily, hit Shift-Space (to get whole rows with col A highlighted) and then use Excel Re-order"]
[null,"5.4 Not a good idea to change row orders which include a coloured or uncoloured Change data block - but may be OK if it leaves or moves whole blocks. May need to Delete Changes, reorder then re-Add Changes."]
[null,"5.5 Adding or moving columns beyond column M is probably OK but probably not for A to M which affect the macro actions."]
[]
[null,"6. Overall data entries and Full Load Factors"]
[null,"6.1 Hours per day: in column R of each data item (row) with all values taken from a single entry in the visible table. However for an item you could overwrite the formula with, say, 5. Conditional formating changes the cell colour as a record. "]
[null,"6.2 Weeks per year - ditto as hours per day. NB if less than 52.1, the out-of hours time is for those weeks only so in-use and out-of hours will add up to less than 8660 in this case."]
[null,"6.3 Factor for full load (aka Electrical Load Factor) - is in Column T if required. Could be manually entered for each item in Column T with a covering statement in the \"overall data\": section near the hours per day:"]
[null,"    6.3 cont.. for example \"A Factor for full load is included as 1.15 for discharge lighting and LEDs, 0.8 for motors and 1.0 for all other items, unless noted\""]
[null,"6.4 Comment on Hours of use: better to have a single value (e.g. either plant or lighting your choice) and account for other with load factors.  But may need two overall hours (office, production) for a factory or hospital."]
[null,"6.5 Comment on Full Load factor: confuses clients better to incorporate in W/m2, or possibly into load factors in some cases. "]
[]
[null,"Printing and pasting options - system and time dependent"]
[null,"7. Print or Paste the results (row numbers below assume the TOTAL row of the main table Summary by type of use is at row 59 - otherwise adjust these numbers accordingly)"]
[null,"7.1 Tables in blue boxes are recommended as print-outs for reports and presentations.  "]
[null,"7.2 Users can export charts on the 'Output Charts' tab by using the Excel 'save as' function for PNG or PDF. Progress charts should be generated for each energy analysis iteration and/or project gateway."]
[null,"7.3 To paste main table before and after into Word: hit \"Revert Changes\".. Select A8:M73 edit-copy.. then In Word.. edit.. paste-special.. picture.. reformat picture."]
[null,"7.4 ...or can also do as above but paste-special.. Excel object.. reformat object. This is smaller file size for large tables but you may need to double click if re-loading the Word doc and the table is fuzzed-out"]
[null,"7.5 Hit \"Apply Changes\"  Select A8:M73 and carry on as 7.1 above. This will include the Changes and Measures tables, but you could do them on a separate third page if running out of room."]
[null,"7.6 ...or you can select print area as above and print, or print as pdf - this is very compact if you can use a pdf directly."]

{"sheet":"Notes on sub-metering problems","index":6,"n_rows":46,"n_cols":15,"rows_kept":46,"cut":false,"hidden":false,"merged":[[45,9,46,12],[22,14,23,14],[25,14,26,14],[28,14,29,14],[31,14,32,14],[34,14,35,14],[39,14,40,14],[19,14,20,14],[2,14,5,14],[7,14,8,14],[10,14,11,14],[13,14,14,14],[16,14,17,14]]}
[" "]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Resolved Y/N"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"No"]
[]
[]
[]
[]
[]
[null,null,null,null,null,null,null,null,null,"Print report to contractor for resolution"]

{"sheet":"Example building details","index":7,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":false,"merged":[[4,9,38,19]]}
[" "]
[null,null,"Exemplar school details"]
[]
[]
[null,null,null,null,null,null,null,null,null,"The example building is a single-storey primary school of approximately 1000 m2. The floor plan of the school that inspired the hypothetical energy model is shown left. \n\nThe data entry on the 'Energy Input Sheet' lists the major loads typically found in such schools. Note that the model assumes correct operation with no wasteful running. \n\nThe notional school has the following features:\n\n     - 7 x 60 m2 classrooms (420 m2 total)\n     - 300 m2 of corridors, circulation, entrance, foyer, wcs, support\n     - 1 x 150 m2 assembly/sports hall\n     - 1 x 45 m2 catering kitchen\n     - 130 m2 of staff rooms, offices, reception\n \nThe school is occupied for 5.8 days a week and 40 weeks a year. Heating runs for 26 weeks.\n\nThe seven design/use changes to the school, reflected in the highlighted cells and summarised in the 'tracked changes table' have been chosen to include:\n\n     - a simple lamp replacement  \n     - an area-based change for classroom lighting (from 11.5 to 8.1 W/m2)  \n     - classroom IT upgrade and associated hub change\n     - an example where three entries are changed at once (lighting load factors)\n     - an increase in weekend use (from 5.4 to 5.8 days a week)"]