{"text_format":"1","workbook":"xlsx","n_sheets":8,"sheets":["Disclaimer","Version Control","INPTR; Reduced User Input Form","OUTPR; Appraisal","OUTPR; Integrity","INPTR; BEIS","Lists","DATABASEUPLOAD"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":138,"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":"Disclaimer","index":0,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[1,5,6,10]]}
[]
[null,null,null,null,null,"Reduced input cost effectiveness assessment tool to support Heat Network notification under Regulation 3 of The Heat Network (Metering and Billing) Regulations 2014 as amended (2020)"]
[]
[]
[]
[]
[]
[null,null,"Further guidance, including what is within scope of the Regulations is available at:"]
[null,null,"www.gov.uk/heat-networks"]
[null,null,"Please read our privacy notice of how your data will be used"]
[]
[null,null,"If you have any issues completing this, please call: 0121 345 1201"]

{"sheet":"Version Control","index":1,"n_rows":11,"n_cols":5,"rows_kept":11,"cut":false,"hidden":true,"merged":[]}
[]
[null,"VERSION CONTROL"]
[]
[null,"Version no.","Date created","Key changes since previous","Issued to"]
[null,"Beta v1.1","2020-10-19","Created to provide a reduced input tool following stakeholder feedback","Thomas Allard"]
[null,"Beta v1.2","2020-11-08","Updated with complete working formulae","Thomas Allard"]
[null,"Beta v1.3","2020-11-12","Reviewed and updated ","George Robinson"]
[null,"Beta v1.3","2020-11-16","Internal QA complete","James Darke"]
[null,"Version 1.0","2020-11-19","Update of supporting text ","Thomas Allard"]
[null,"Version 1.1","2020-11-23","Update of disclaimer and readiness for release","George Robinson"]
[null,"Version 1.1","2020-11-27","Published"]

{"sheet":"INPTR; Reduced User Input Form","index":2,"n_rows":90,"n_cols":10,"rows_kept":90,"cut":false,"hidden":true,"merged":[[19,2,22,5],[41,2,42,3],[46,2,49,5],[64,2,65,3],[69,2,72,5]]}
[null,null,"REDUCED INPUT COST EFFECTIVENESS ASSESSMENT TOOL "]
[null,null,{"$f":" RIGHT(CELL(\"filename\", C2), LEN(CELL(\"filename\", C2)) - SEARCH(\"]\", CELL(\"filename\", C2)))","v":"INPTR; Reduced User Input Form"}]
[null,null,"Tool integrity checks:",null,null,{"$f":"'OUTPR; Integrity'!D16","v":1}]
[]
[null,null,"SECTION 1: NETWORK SET UP"]
[]
[null,1,"Network name:",null,"text"]
[null,2,"Network geographical location:",null,"dropdown option"]
[null,3,"Network unique identification number:",null,"text"]
[]
[null,null,"BUILDING INPUTS:"]
[]
[]
[null,"A1","Building Name","This is just for your reference - e.g. Town Hall, Central Library, Block A…","text"]
[]
[null,null,"SECTION 2A: FUEL CONSUMPTION"]
[]
[null,null,"ADD FUEL DATA"]
[]
[null,null,"To add information on the fuel cost FOR A SINGLE YEAR of the building selected to supply/generate heat/cooling:\n1. Enter details in the yellow boxes in the form below\n2. Press 'ADD NEW FUEL ITEM'\n3. Repeat for each additional fuel type (n.b. if you have multiple invoices for the same fuel type "]
[]
[]
[]
[]
[null,null,"FUEL CONSUMPTION FOR THE BUILDING OVER THE YEAR PROVIDED BY THE HEAT NETWORK"]
[]
[null,null,null,null,null,"Fuel Type 1","Fuel Type 2","Fuel Type 3","Fuel Type 4","Fuel Type 5"]
[null,"BA1","Fuel description","You can enter free text to describe the fuel being entered (e.g. Gas-INV1)","text"]
[null,"BA2","Fuel type","Drop down selection to align with BEIS fuel types","dropdown"]
[null,"BA3","Consumption","The fuel consumed in line with the invoice from the supplier","kWh"]
[null,"BA4","Number of months consumption relates to","# months that BA3 relates to - total for a given fuel must = 12 across entries","months"]
[null,"BA5","Marginal cost of fuel","The cost of each additional kWh consumption of the fuel","p/kWh"]
[null,"BA6","Relevant consumption levies","For example CCL for gas and electricity","p/kWh"]
[null,"BA7","Other consumption charges","For example distribution use of system charges","p/kWh"]
[null,"BA8","Fixed charge over consumption period","This should be the fixed charge over the consumption period","£"]
[null,"BA9","Total fuel cost over consumption period","This should be the total fuel cost over the consumption period (fixed+variable)","£",{"$f":"(SUM(F32:F34)*F30/100+F35)","v":0},{"$f":"(SUM(G32:G34)*G30/100+G35)","v":0},0,0,0]
[null,"BA10","Output energy from fuel","Specifies what the fuel is used for: heat, cooling or heat + cooling","dropdown"]
[null,null,"FUEL INPUT CHECK","Checks that the total number of months per fuel type = 12 months",null,{"$f":"1*(SUMIF($F$29:$J$29,F29,$F$31:$J$31)<>12)*(F30<>0)","v":0},{"$f":"1*(SUMIF($F$29:$J$29,G29,$F$31:$J$31)<>12)*(G30<>0)","v":0},0,0,0]
[]
[null,null,"SECTION 3: UNIT TYPES WITHIN BUILDING"]
[]
[null,null,"Select the building from the drop down list for which you want to add information on unit types. "]
[]
[]
[null,null,"ADD DATA REGARDING UNIT TYPES WITHIN THE BUILDING"]
[]
[null,null,"To add information on unit types in the building selected (IMPORTANT: READ NOTES IN COL Q):\n1. Enter details in the yellow boxes in the form below\n"]
[]
[]
[]
[]
[null,null,"BUILDING UNIT INPUTS:"]
[]
[]
[null,"C2","Unit archetype","This relates to the primary use type - e.g. school, leisure centre etc.","dropdown"]
[null,"C3","Total number of units in building?","The total number of domestic dwellings and/or non-domestic units within the building","#"]
[null,"C20","Total number of heat meters required?","This is the total number of heat meters required across all units","#"]
[null,"C21","Can users change controls?","True or false","t/f"]
[null,"C23","Total number of hot water meters required?","This is the total number of hot water meters required across all units","#"]
[null,"C24","Total number of HCAs required","This is the total number of HCAs required across all units","#"]
[null,"C25","Total number of TRVs required?","This is the total number of TRVs required across all units","#"]
[]
[null,null,"SECTION 4: QUOTED COSTS"]
[]
[null,null,"Select the building from the drop down list for which you want to add information on unit types. "]
[]
[]
[null,null,"ADD DATA REGARDING QUOTED METERING COSTS "]
[]
[null,null,"To add information on unit types in the building selected (IMPORTANT: READ NOTES IN COL Q):\n1. Enter details in the yellow boxes in the form below\n"]
[]
[]
[]
[]
[null,null,"METERING COST INPUTS:"]
[null,null,null,null,null,"Capital cost","Operating cost"]
[null,null,null,null,null,"£","£/year"]
[null,"D1","Heat meter cost and installation","Total cost per meter","£"]
[null,"D2","Cost and installation of data gathering equipment","Total cost per unit / dwelling","£"]
[null,"D3","Annual heat meter operational costs (incl. billing)","Total cost including billing costs per dwelling / unit","£/yr"]
[null,null,null," "]
[null,"D4","Heat Cost Allocator cost and installation","Total cost per HCA","£"]
[null,"D5","Hot water meter cost and installation","Total cost per meter","£"]
[null,"D6","HCA cost of data gathering equipment","Total cost per unit / dwelling","£"]
[null,"D7","TRV cost and installation of modern radiator valve","Total cost per TRV","£"]
[null,"D8","Annual HCA operational costs (incl. billing)","Total cost including billing costs per dwelling / unit","£/yr"]
[]
[null,"D9","Additional costs permitted under Schedule 1","Total additional costs such as legal cost required to gain access to the units etc","£"]
[]
[null,null,"END OF WORKSHEET"]

{"sheet":"OUTPR; Appraisal","index":3,"n_rows":111,"n_cols":17,"rows_kept":111,"cut":false,"hidden":true,"merged":[[2,3,2,7]]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"OUTPR; Appraisal"}]
[]
[null,"Building for Appraisal for NPV:",null,{"$f":"'INPTR; Reduced User Input Form'!F14","v":0}]
[]
[null,"VALUE FOR MONEY ESTIMATE"]
[null,"Year",null,null,null,null,null,1,2,3,4,5,6,7,8,9,10]
[]
[null,null,"Heat meter CBA"]
[null,null,"Total value of fuel saving in building","£",null,null,null,{"$f":"H45","v":{"$error":"#N/A"}},{"$f":"I45","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Heat meter cost and installation","£",null,null,null,{"$f":"H52","v":0},{"$f":"I52","v":0},0,0,0,0,0,0,0,0]
[null,null,"Cost and installation of data gathering equipment","£",null,null,null,{"$f":"H59","v":0},{"$f":"I59","v":0},0,0,0,0,0,0,0,0]
[null,null,"Annual heat meter operational costs (incl. billing)","£",null,null,null,{"$f":"H64","v":0},{"$f":"I64","v":0},0,0,0,0,0,0,0,0]
[null,null,"User entered additional costs","£",null,null,null,{"$f":"H75","v":0},{"$f":"I75","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"10 year cash flows","£",null,null,null,{"$f":"SUM(H9:H13)","v":{"$error":"#N/A"}},{"$f":"SUM(I9:I13)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Discount rate (end of period)","Factor",null,3.5000000000000003E-2,null,{"$f":"1/((1+$F16)^H$6)","v":0.96618357487922713},{"$f":"1/((1+$F16)^I$6)","v":0.93351070036640305},{"$f":"1/((1+$F16)^J$6)","v":0.90194270566802237},0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217]
[null,null,"Discounted 10 year cash flows","£ NPV",null,{"$f":"SUM(H17:Q17)","v":{"$error":"#N/A"}},null,{"$f":"H15*H16","v":{"$error":"#N/A"}},{"$f":"I15*I16","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Meters required?",null,null,{"$f":"IF(F17>0,TRUE,FALSE)","v":{"$error":"#N/A"}}]
[]
[null,null,"Heat cost allocator CBA"]
[null,null,"Total value of fuel saving in building","£",null,null,null,{"$f":"H45","v":{"$error":"#N/A"}},{"$f":"I45","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Heat Cost Allocator cost and installation","£",null,null,null,{"$f":"H82","v":0},{"$f":"I82","v":0},0,0,0,0,0,0,0,0]
[null,null,"Hot water meter cost and installation","£",null,null,null,{"$f":"H89","v":0},{"$f":"I89","v":0},0,0,0,0,0,0,0,0]
[null,null,"HCA Cost of data gathering equipment","£",null,null,null,{"$f":"H96","v":0},{"$f":"I96","v":0},0,0,0,0,0,0,0,0]
[null,null,"HCA Cost of TRVs","£",null,null,null,{"$f":"H103","v":0},{"$f":"I103","v":0},0,0,0,0,0,0,0,0]
[null,null,"Annual HCA operational costs (incl. billing)","£",null,null,null,{"$f":"H108","v":0},{"$f":"I108","v":0},0,0,0,0,0,0,0,0]
[null,null,"User entered additional costs","£",null,null,null,{"$f":"H75","v":0},{"$f":"I75","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"10 year cash flows","£",null,null,null,{"$f":"SUM(H21:H27)","v":{"$error":"#N/A"}},{"$f":"SUM(I21:I27)","v":{"$error":"#N/A"}},{"$f":"SUM(J21:J27)","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Discount rate (end of period)","Factor",null,3.5000000000000003E-2,null,{"$f":"1/((1+$F30)^H$6)","v":0.96618357487922713},{"$f":"1/((1+$F30)^I$6)","v":0.93351070036640305},0.90194270566802237,0.87144222769857238,0.84197316685852419,0.81350064430775282,0.78599096068381913,0.75941155621625056,0.73373097218961414,0.70891881370977217]
[null,null,"Discounted 10 year cash flows","£ NPV",null,{"$f":"SUM(H31:Q31)","v":{"$error":"#N/A"}},null,{"$f":"H29*H30","v":{"$error":"#N/A"}},{"$f":"I29*I30","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"HCA required?",null,null,{"$f":"IF(AND(F18=FALSE,F31>0),TRUE,FALSE)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,"WORKINGS"]
[]
[null,null,"Total value of fuel saving in building"]
[]
[null,null,"Building type:",null,null,{"$f":"'INPTR; Reduced User Input Form'!F55","v":0}]
[null,null,"Building type list match:","#",null,{"$f":"MATCH(F39,lstBuildArchetypes1[Building Archetypes],0)","v":{"$error":"#N/A"}}]
[null,null,"Pofile of benefit realisation:","%",null,null,null,{"$f":"'INPTR; BEIS'!J7","v":0.5},{"$f":"'INPTR; BEIS'!K7","v":1},{"$f":"'INPTR; BEIS'!L7","v":1},{"$f":"'INPTR; BEIS'!M7","v":1},{"$f":"'INPTR; BEIS'!N7","v":1},{"$f":"'INPTR; BEIS'!O7","v":1},{"$f":"'INPTR; BEIS'!P7","v":1},{"$f":"'INPTR; BEIS'!Q7","v":1},{"$f":"'INPTR; BEIS'!R7","v":1},{"$f":"'INPTR; BEIS'!S7","v":1}]
[null,null,"Impact of meter installation on consumption:","%",null,{"$f":"INDEX(lstBuildArchetypes1[Energy saving],F40,1)","v":{"$error":"#N/A"}},null,{"$f":"$F42*H41","v":{"$error":"#N/A"}},{"$f":"$F42*I41","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Annual fuel cost saved","£",null,{"$f":"SUM('INPTR; Reduced User Input Form'!F36:J36)","v":0},null,{"$f":"$F43*H42","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[null,null,"Escalate to end of period","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!K11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!L11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!M11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!N11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!O11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!P11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!Q11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!R11","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!S11","v":1.0173494974687902}]
[null,null,"End of period valued fuel cost savings","£",null,null,null,{"$f":"H43*H44","v":{"$error":"#N/A"}},{"$f":"I43*I44","v":{"$error":"#N/A"}},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"},{"$error":"#N/A"}]
[]
[null,null,"Heat meter cost and installation"]
[null,null,"Heat meter cost and installation for unit type","£",null,{"$f":"'INPTR; Reduced User Input Form'!F78","v":0}]
[null,null,"Number of heat meters required to be installed","#",null,{"$f":"'INPTR; Reduced User Input Form'!F57","v":0}]
[null,null,"Total Heat meter cost and installation","£",null,null,null,{"$f":"F48*F49","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R12","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S12","v":1.0349999999999999}]
[null,null,"End of period purchase and installation cost","£",null,null,null,{"$f":"-H50*H51","v":0},{"$f":"-I50*I51","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Cost and installation of data gathering equipment"]
[null,null,"Cost and installation of data gathering equipment","£",null,{"$f":"'INPTR; Reduced User Input Form'!F79","v":0}]
[null,null,"Number of building units in building","#",null,{"$f":"'INPTR; Reduced User Input Form'!F56","v":0}]
[null,null,"Total cost of data gathering equipment","£",null,null,null,{"$f":"F55*F56","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R13","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S13","v":1.0349999999999999}]
[null,null,"End of period purchase and installation cost","£",null,null,null,{"$f":"-H57*H58","v":0},{"$f":"-I57*I58","v":0},{"$f":"-J57*J58","v":0},{"$f":"-K57*K58","v":0},{"$f":"-L57*L58","v":0},{"$f":"-M57*M58","v":0},{"$f":"-N57*N58","v":0},{"$f":"-O57*O58","v":0},{"$f":"-P57*P58","v":0},{"$f":"-Q57*Q58","v":0}]
[]
[null,null,"Annual heat meter operational costs (incl. billing)"]
[null,null,"Annual heat meter operational costs (incl. billing)","£",null,{"$f":"'INPTR; Reduced User Input Form'!G80","v":0},null,{"$f":"$F62","v":0},{"$f":"$F62","v":0},0,0,0,0,0,0,0,0]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!K14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!L14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!M14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!N14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!O14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!P14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!Q14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!R14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!S14","v":1.0173494974687902}]
[null,null,"End of period heat meter O&M","£",null,null,null,{"$f":"-H62*H63","v":0},{"$f":"-I62*I63","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User entered additional costs"]
[null,null,"User entered additional costs - capital","£",null,{"$f":"'INPTR; Reduced User Input Form'!F88","v":0},null,{"$f":"$F67","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R21","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S21","v":1.0349999999999999}]
[null,null,"End of period heat meter user entered additional costs","£",null,null,null,{"$f":"-H67*H68","v":0},{"$f":"-I67*I68","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"User entered additional costs - operating","£",null,{"$f":"'INPTR; Reduced User Input Form'!G88","v":0},null,{"$f":"$F71","v":0},{"$f":"$F71","v":0},0,0,0,0,0,0,0,0]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!K22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!L22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!M22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!N22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!O22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!P22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!Q22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!R22","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!S22","v":1.0173494974687902}]
[null,null,"End of period heat meter user entered additional costs","£",null,null,null,{"$f":"-H71*H72","v":0},{"$f":"-I71*I72","v":0},{"$f":"-J71*J72","v":0},{"$f":"-K71*K72","v":0},{"$f":"-L71*L72","v":0},{"$f":"-M71*M72","v":0},{"$f":"-N71*N72","v":0},{"$f":"-O71*O72","v":0},{"$f":"-P71*P72","v":0},{"$f":"-Q71*Q72","v":0}]
[]
[null,null,"User entered additional costs","£",null,null,null,{"$f":"H69+H73","v":0},{"$f":"I69+I73","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Heat Cost Allocator cost and installation"]
[null,null,"Heat Cost Allocator cost and installation","£",null,{"$f":"'INPTR; Reduced User Input Form'!F82","v":0}]
[null,null,"Number of heat cost allocators required","#",null,{"$f":"'INPTR; Reduced User Input Form'!F60","v":0}]
[null,null,"Total cost of HCAs","£",null,null,null,{"$f":"F78*F79","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R16","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S16","v":1.0349999999999999}]
[null,null,"End of period HCA cost","£",null,null,null,{"$f":"-H80*H81","v":0},{"$f":"-I80*I81","v":0},0,0,0,0,0,0,0,0]
[]
[null,null,"Hot water meter cost and installation"]
[null,null,"Hot water meter cost and installation","£",null,{"$f":"'INPTR; Reduced User Input Form'!F83","v":0}]
[null,null,"Number of hot water meters required","#",null,{"$f":"'INPTR; Reduced User Input Form'!F59","v":0}]
[null,null,"Total cost of hot water meters","£",null,null,null,{"$f":"F85*F86","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R17","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S17","v":1.0349999999999999}]
[null,null,"End of period hot water meter cost","£",null,null,null,{"$f":"-H87*H88","v":0},{"$f":"-I87*I88","v":0},{"$f":"-J87*J88","v":0},{"$f":"-K87*K88","v":0},{"$f":"-L87*L88","v":0},{"$f":"-M87*M88","v":0},{"$f":"-N87*N88","v":0},{"$f":"-O87*O88","v":0},{"$f":"-P87*P88","v":0},{"$f":"-Q87*Q88","v":0}]
[]
[null,null,"HCA Cost of data gathering equipment"]
[null,null,"HCA Cost of data gathering equipment","£",null,{"$f":"'INPTR; Reduced User Input Form'!F84","v":0}]
[null,null,"Number of building units","#",null,{"$f":"'INPTR; Reduced User Input Form'!F56","v":0}]
[null,null,"Total cost of data gathering equipment","£",null,null,null,{"$f":"F92*F93","v":0}]
[null,null,"Escalate to end of peiod","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R19","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S19","v":1.0349999999999999}]
[null,null,"End of period cost of data gathering equipment","£",null,null,null,{"$f":"-H94*H95","v":0},{"$f":"-I94*I95","v":0},{"$f":"-J94*J95","v":0},{"$f":"-K94*K95","v":0},{"$f":"-L94*L95","v":0},{"$f":"-M94*M95","v":0},{"$f":"-N94*N95","v":0},{"$f":"-O94*O95","v":0},{"$f":"-P94*P95","v":0},{"$f":"-Q94*Q95","v":0}]
[]
[null,null,"HCA Cost of TRVs"]
[null,null,"Cost of TRVs","£",null,{"$f":"'INPTR; Reduced User Input Form'!F85","v":0}]
[null,null,"Number of TRVs required","#",null,{"$f":"'INPTR; Reduced User Input Form'!F61","v":0}]
[null,null,"Total cost of TRVs","£",null,null,null,{"$f":"F99*F100","v":0}]
[null,null,"Escalate to end of period","Factor",null,null,null,{"$f":"'INPTR; BEIS'!J20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!K20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!L20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!M20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!N20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!O20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!P20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!Q20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!R20","v":1.0349999999999999},{"$f":"'INPTR; BEIS'!S20","v":1.0349999999999999}]
[null,null,"End of period cost of TRVs","£",null,null,null,{"$f":"-H101*H102","v":0},{"$f":"-I101*I102","v":0},{"$f":"-J101*J102","v":0},{"$f":"-K101*K102","v":0},{"$f":"-L101*L102","v":0},{"$f":"-M101*M102","v":0},{"$f":"-N101*N102","v":0},{"$f":"-O101*O102","v":0},{"$f":"-P101*P102","v":0},{"$f":"-Q101*Q102","v":0}]
[]
[null,null,"Annual HCA operational costs (incl. billing)"]
[null,null,"Annual HCA operational costs (incl. billing)","£",null,{"$f":"'INPTR; Reduced User Input Form'!G86","v":0},null,{"$f":"$F106","v":0},{"$f":"$F106","v":0},0,0,0,0,0,0,0,0]
[null,null,"End of period cost of TRVs",null,null,null,null,{"$f":"'INPTR; BEIS'!J14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!K14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!L14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!M14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!N14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!O14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!P14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!Q14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!R14","v":1.0173494974687902},{"$f":"'INPTR; BEIS'!S14","v":1.0173494974687902}]
[null,null,"End of period HCA O&M",null,null,null,null,{"$f":"-H106*H107","v":0},{"$f":"-I106*I107","v":0},{"$f":"-J106*J107","v":0},{"$f":"-K106*K107","v":0},{"$f":"-L106*L107","v":0},{"$f":"-M106*M107","v":0},{"$f":"-N106*N107","v":0},{"$f":"-O106*O107","v":0},{"$f":"-P106*P107","v":0},{"$f":"-Q106*Q107","v":0}]
[]
[]
[null,"END OF SHEET"]

{"sheet":"OUTPR; Integrity","index":4,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[{"$f":"RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"OUTPR; Integrity"}]
[]
[null,"Integrity Checks"]
[null,"#","Description","Check"]
[]
[null,{"$f":"MAX(B$5:B5)+1","v":1},"Has a network name been provided?",{"$f":"IF('INPTR; Reduced User Input Form'!F7=\"\",1,0)","v":1}]
[null,{"$f":"MAX(B$5:B6)+1","v":2},"Has the location of the network been selected?",{"$f":"IF('INPTR; Reduced User Input Form'!F8=\"\",1,0)","v":1}]
[null,{"$f":"MAX(B$5:B7)+1","v":3},"Has building name been entered?",{"$f":"IF('INPTR; Reduced User Input Form'!F14=\"\",1,0)","v":1}]
[null,{"$f":"MAX(B$5:B8)+1","v":4},"Is fuel consumption for 12 months?",{"$f":"SUM('INPTR; Reduced User Input Form'!F38:J38)","v":0}]
[null,{"$f":"MAX(B$5:B9)+1","v":5},"Has at least one of heating and/or cooling been entered in the tool?",{"$f":"IF(COUNTBLANK('INPTR; Reduced User Input Form'!F37:J37)>4,1,0)","v":1}]
[null,{"$f":"MAX(B$5:B10)+1","v":6},"Has total number of meters required been provided?",{"$f":"IF('INPTR; Reduced User Input Form'!F57=\"\",1,0)","v":1}]
[null,{"$f":"MAX(B$5:B11)+1","v":7},"Has total number of HCA required been provided?",{"$f":"IF('INPTR; Reduced User Input Form'!F60=\"\",1,0)","v":1}]
[null,{"$f":"MAX(B$5:B12)+1","v":8},"Has total metering cost been provided?",{"$f":"IF(SUM('INPTR; Reduced User Input Form'!F78:G80,'INPTR; Reduced User Input Form'!G78:G79)=0,1,0)","v":1}]
[null,{"$f":"MAX(B$5:B13)+1","v":9},"Has total HCA cost been provided?",{"$f":"IF(SUM('INPTR; Reduced User Input Form'!F82:F86,'INPTR; Reduced User Input Form'!G82:G85)=0,1,0)","v":1}]
[]
[null,null,"Total tool integrity checks:",{"$f":"IF(SUM(D6:D14)=0,0,1)","v":1}]

{"sheet":"INPTR; BEIS","index":5,"n_rows":24,"n_cols":19,"rows_kept":24,"cut":false,"hidden":true,"merged":[]}
[{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"INPTR; BEIS"}]
[]
[null,"APPRAISAL"]
[]
[null,"Discount rate",null,"%",3.5000000000000003E-2]
[null,null,null,null,null,null,null,"Year",null,{"$f":"I6+1","v":1},{"$f":"J6+1","v":2},3,4,5,6,7,8,9,10]
[null,"Savings profile - % of savings",null,"%",null,null,null,null,null,0.5,1,1,1,1,1,1,1,1,1]
[null,"Domestic energy savings from meters installed",null,"%",0.2]
[null,"Non-domestic energy savings from meters installed",null,"%",0.1]
[null,null,null,null,null,"Match","Discount","% of yea"]
[null,"Timing of energy savings",null,"DropDown","Average",{"$f":"MATCH(E11,lstCFTiming1[lstCFTiming],0)","v":2},3.5000000000000003E-2,{"$f":"CHOOSE(F11,1,0.5,0)","v":0.5},null,{"$f":"(1+$G11)^$H11","v":1.0173494974687902},{"$f":"(1+$G11)^$H11","v":1.0173494974687902},1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902]
[null,"Cost and installation of meters",null,"DropDown","Beginning",{"$f":"MATCH(E12,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,{"$f":"CHOOSE(F12,1,0.5,0)","v":1},null,{"$f":"(1+$G12)^$H12","v":1.0349999999999999},1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"Cost and data gathering equipment",null,"DropDown","Beginning",{"$f":"MATCH(E13,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"Meter O&M",null,"DropDown","Average",{"$f":"MATCH(E14,lstCFTiming1[lstCFTiming],0)","v":2},3.5000000000000003E-2,0.5,null,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902]
[null,"Cost of controls",null,"DropDown","Beginning",{"$f":"MATCH(E15,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"Heat cost allocator purchase",null,"DropDown","Beginning",{"$f":"MATCH(E16,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"Cost of water meter purchase",null,"DropDown","Beginning",{"$f":"MATCH(E17,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"Heat Cost Allocator O&M",null,"DropDown","Average",{"$f":"MATCH(E18,lstCFTiming1[lstCFTiming],0)","v":2},3.5000000000000003E-2,0.5,null,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902]
[null,"HCA Cost of data gathering equipment",null,"DropDown","Beginning",{"$f":"MATCH(E19,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"HCA Cost of TRVs",null,"DropDown","Beginning",{"$f":"MATCH(E20,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,1,null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"User entered capital costs",null,"DropDown","Beginning",{"$f":"MATCH(E21,lstCFTiming1[lstCFTiming],0)","v":1},3.5000000000000003E-2,{"$f":"CHOOSE(F21,1,0.5,0)","v":1},null,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999,1.0349999999999999]
[null,"User entered operating costs",null,"DropDown","Average",{"$f":"MATCH(E22,lstCFTiming1[lstCFTiming],0)","v":2},3.5000000000000003E-2,{"$f":"CHOOSE(F22,1,0.5,0)","v":0.5},null,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902,1.0173494974687902]
[]
[null,"END OF SHEET"]

{"sheet":"Lists","index":6,"n_rows":121,"n_cols":4,"rows_kept":121,"cut":false,"hidden":true,"merged":[]}
[null,{"$f":" RIGHT(CELL(\"filename\", A1), LEN(CELL(\"filename\", A1)) - SEARCH(\"]\", CELL(\"filename\", A1)))","v":"Lists"}]
[]
[null,"Region",null,"lstHidden"]
[null,"East Midlands",null,"shtLists"]
[null,"East of England",null,"shtInputGen"]
[null,"London",null,"shtDatabase"]
[null,"North East"]
[null,"North West"]
[null,"Northern Ireland"]
[null,"Scotland"]
[null,"South East"]
[null,"South West"]
[null,"Wales"]
[null,"West Midlands"]
[null,"Yorkshire and The Humber"]
[]
[]
[null,"Fuel input"]
[null,"Biofuel"]
[null,"Biomass"]
[null,"Coal"]
[null,"Electricity"]
[null,"Gas"]
[null,"LPG"]
[null,"Oil"]
[null,"RDF"]
[null,"Waste Heat"]
[]
[]
[null,"Unit Type"]
[null,"Residential"]
[null,"Non-residential"]
[]
[]
[null,"lstCFTiming"]
[null,"Beginning"]
[null,"Average"]
[null,"End"]
[]
[]
[null,"T/F"]
[null,true]
[null,false]
[]
[]
[null,"lstOpenClosed"]
[null,"Open"]
[null,"Closed"]
[]
[]
[null,"lstMonths"]
[null,"Jan"]
[null,"Feb"]
[null,"Mar"]
[null,"Apr"]
[null,"May"]
[null,"Jun"]
[null,"Jul"]
[null,"Aug"]
[null,"Sep"]
[null,"Oct"]
[null,"Nov"]
[null,"Dec"]
[]
[]
[null,"lstDayCategories"]
[null,"Early morning"]
[null,"Morning"]
[null,"Late morning"]
[null,"Early afternoon"]
[null,"Late afternoon"]
[null,"Evening"]
[null,"Late evening"]
[null,"Night"]
[]
[]
[null,"Building Archetypes","Energy saving","Column1"]
[null,"Cold store",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},{"$f":"$B$32","v":"Non-residential"}]
[null,"Cultural activities",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},{"$f":"$B$32","v":"Non-residential"}]
[null,"Dry sports",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Emergency serv",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"General retail",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Hospital",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Hotel",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Large food store",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Office (naturally ventilated 100–3000 m2)",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Office (naturally ventilated 500–4000 m2)",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Office (air conditioned 2000–8000 m2)",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Office (air conditioned HQ type)",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Public building / light usage",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Residential: <=1995",{"$f":"'INPTR; BEIS'!$E$8","v":0.2},{"$f":"$B$31","v":"Residential"}]
[null,"Residential: 1995-2000",{"$f":"'INPTR; BEIS'!$E$8","v":0.2},"Residential"]
[null,"Residential: 2000-2005",{"$f":"'INPTR; BEIS'!$E$8","v":0.2},"Residential"]
[null,"Residential: 2005-2010",{"$f":"'INPTR; BEIS'!$E$8","v":0.2},"Residential"]
[null,"Residential: 2010-present",{"$f":"'INPTR; BEIS'!$E$8","v":0.2},{"$f":"$B$31","v":"Residential"}]
[null,"Schools / seasonal public buildings",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},{"$f":"$B$32","v":"Non-residential"}]
[null,"Swimming pool",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"University",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[null,"Workshop",{"$f":"'INPTR; BEIS'!$E$9","v":0.1},"Non-residential"]
[]
[]
[null,"lstEnergy"]
[null,"Heat"]
[null,"Cooling"]
[null,"Heat & Cooling"]
[]
[]
[null,"lstAirInfilClass"]
[null,"Residential: <=1995"]
[null,"Residential: 1995-2000"]
[null,"Residential: 2000-2005"]
[null,"Residential: 2005-2010"]
[null,"Residential: 2010-present"]
[null,"Factories, warehouses, halls"]
[null,"Hospitals and health care buildings"]
[null,"Hotels"]
[null,"Office (naturally ventilated 100–3000 m2)"]
[null,"Office (naturally ventilated 500–4000 m2)"]
[null,"Office (air conditioned 2000–8000 m2)"]
[null,"Office (air conditioned HQ type)"]
[null,"Schools"]

{"sheet":"DATABASEUPLOAD","index":7,"n_rows":3,"n_cols":75,"rows_kept":3,"cut":false,"hidden":true,"merged":[]}
[1,2,3,"A1","BA1F1","BA2F1","BA3F1","BA4F1","BA6F1","BA7F1","BA8F1","BA9F1","BA10F1","BA11F1","BA1F2","BA2F2","BA3F2","BA4F2","BA6F2","BA7F2","BA8F2","BA9F2","BA10F2","BA11F2","BA1F3","BA2F3","BA3F3","BA4F3","BA6F3","BA7F3","BA8F3","BA9F3","BA10F3","BA11F3","BA1F4","BA2F4","BA3F4","BA4F4","BA6F4","BA7F4","BA8F4","BA9F4","BA10F4","BA11F4","BA1F5","BA2F5","BA3F5","BA4F5","BA6F5","BA7F5","BA8F5","BA9F5","BA10F5","BA11F5","C2","C3","C20","C21","C23","C24","C25","D1D","D2D","D3G","D4D","D5D","D6D","D7D","D8G","D9D","D9G","NPVM","MR","NPVHCA","HCAR"]
["Network name:","Network geographical location:","Network unique identification number:","Building Name","Fuel description (Fuel Type 1)","Fuel type (Fuel Type 1)","Consumption (Fuel Type 1)","Number of months consumption relates to (Fuel Type 1)","Marginal cost of fuel (Fuel Type 1)","Relevant consumption levies (Fuel Type 1)","Other consumption charges (Fuel Type 1)","Fixed charge over consumption period (Fuel Type 1)","Total fuel cost over consumption period (Fuel Type 1)","Output energy from fuel (Fuel Type 1)","Fuel description (Fuel Type 2)","Fuel type (Fuel Type 2)","Consumption (Fuel Type 2)","Number of months consumption relates to (Fuel Type 2)","Marginal cost of fuel (Fuel Type 2)","Relevant consumption levies (Fuel Type 2)","Other consumption charges (Fuel Type 2)","Fixed charge over consumption period (Fuel Type 2)","Total fuel cost over consumption period (Fuel Type 2)","Output energy from fuel (Fuel Type 2)","Fuel description (Fuel Type 3)","Fuel type (Fuel Type 3)","Consumption (Fuel Type 3)","Number of months consumption relates to (Fuel Type 3)","Marginal cost of fuel (Fuel Type 3)","Relevant consumption levies (Fuel Type 3)","Other consumption charges (Fuel Type 3)","Fixed charge over consumption period (Fuel Type 3)","Total fuel cost over consumption period (Fuel Type 3)","Output energy from fuel (Fuel Type 3)","Fuel description (Fuel Type 4)","Fuel type (Fuel Type 4)","Consumption (Fuel Type 4)","Number of months consumption relates to (Fuel Type 4)","Marginal cost of fuel (Fuel Type 4)","Relevant consumption levies (Fuel Type 4)","Other consumption charges (Fuel Type 4)","Fixed charge over consumption period (Fuel Type 4)","Total fuel cost over consumption period (Fuel Type 4)","Output energy from fuel (Fuel Type 4)","Fuel description (Fuel Type 5)","Fuel type (Fuel Type 5)","Consumption (Fuel Type 5)","Number of months consumption relates to (Fuel Type 5)","Marginal cost of fuel (Fuel Type 5)","Relevant consumption levies (Fuel Type 5)","Other consumption charges (Fuel Type 5)","Fixed charge over consumption period (Fuel Type 5)","Total fuel cost over consumption period (Fuel Type 5)","Output energy from fuel (Fuel Type 5)","Unit archetype","Total number of units in building?","Total number of heat meters required?","Can users change controls?","Total number of hot water meters required?","Total number of HCAs required","Total number of TRVs required?","Heat meter cost and installation\n(Capital cost)","Cost and installation of data gathering equipment\n(Capital cost)","Annual heat meter operational costs (incl. billing)\n(Operating cost)","Heat Cost Allocator cost and installation\n(Capital cost)","Hot water meter cost and installation\n(Capital cost)","HCA Cost of data gathering equipment\n(Capital cost)","HCA Cost of modern radiator valve\n(Capital cost)","Annual HCA operational costs (incl. billing)\n(Operating cost)","Additional costs permitted under Schedule 1\n(Capital cost)","Additional costs permitted under Schedule 1\n","NPV for meters","Meters required","NPV for HCAs","HCAs required"]
[{"$f":"'INPTR; Reduced User Input Form'!F7","v":0},{"$f":"'INPTR; Reduced User Input Form'!F8","v":0},{"$f":"'INPTR; Reduced User Input Form'!F9","v":0},{"$f":"'INPTR; Reduced User Input Form'!F14","v":0},{"$f":"'INPTR; Reduced User Input Form'!F28","v":0},{"$f":"'INPTR; Reduced User Input Form'!F29","v":0},{"$f":"'INPTR; Reduced User Input Form'!F30","v":0},{"$f":"'INPTR; Reduced User Input Form'!F31","v":0},{"$f":"'INPTR; Reduced User Input Form'!F32","v":0},{"$f":"'INPTR; Reduced User Input Form'!F33","v":0},{"$f":"'INPTR; Reduced User Input Form'!F34","v":0},{"$f":"'INPTR; Reduced User Input Form'!F35","v":0},{"$f":"'INPTR; Reduced User Input Form'!F36","v":0},{"$f":"'INPTR; Reduced User Input Form'!F37","v":0},{"$f":"'INPTR; Reduced User Input Form'!G28","v":0},{"$f":"'INPTR; Reduced User Input Form'!G29","v":0},{"$f":"'INPTR; Reduced User Input Form'!G30","v":0},{"$f":"'INPTR; Reduced User Input Form'!G31","v":0},{"$f":"'INPTR; Reduced User Input Form'!G32","v":0},{"$f":"'INPTR; Reduced User Input Form'!G33","v":0},{"$f":"'INPTR; Reduced User Input Form'!G34","v":0},{"$f":"'INPTR; Reduced User Input Form'!G35","v":0},{"$f":"'INPTR; Reduced User Input Form'!G36","v":0},{"$f":"'INPTR; Reduced User Input Form'!G37","v":0},{"$f":"'INPTR; Reduced User Input Form'!H28","v":0},{"$f":"'INPTR; Reduced User Input Form'!H29","v":0},{"$f":"'INPTR; Reduced User Input Form'!H30","v":0},{"$f":"'INPTR; Reduced User Input Form'!H31","v":0},{"$f":"'INPTR; Reduced User Input Form'!H32","v":0},{"$f":"'INPTR; Reduced User Input Form'!H33","v":0},{"$f":"'INPTR; Reduced User Input Form'!H34","v":0},{"$f":"'INPTR; Reduced User Input Form'!H35","v":0},{"$f":"'INPTR; Reduced User Input Form'!H36","v":0},{"$f":"'INPTR; Reduced User Input Form'!H37","v":0},{"$f":"'INPTR; Reduced User Input Form'!I28","v":0},{"$f":"'INPTR; Reduced User Input Form'!I29","v":0},{"$f":"'INPTR; Reduced User Input Form'!I30","v":0},{"$f":"'INPTR; Reduced User Input Form'!I31","v":0},{"$f":"'INPTR; Reduced User Input Form'!I32","v":0},{"$f":"'INPTR; Reduced User Input Form'!I33","v":0},{"$f":"'INPTR; Reduced User Input Form'!I34","v":0},{"$f":"'INPTR; Reduced User Input Form'!I35","v":0},{"$f":"'INPTR; Reduced User Input Form'!I36","v":0},{"$f":"'INPTR; Reduced User Input Form'!I37","v":0},{"$f":"'INPTR; Reduced User Input Form'!J28","v":0},{"$f":"'INPTR; Reduced User Input Form'!J29","v":0},{"$f":"'INPTR; Reduced User Input Form'!J30","v":0},{"$f":"'INPTR; Reduced User Input Form'!J31","v":0},{"$f":"'INPTR; Reduced User Input Form'!J32","v":0},{"$f":"'INPTR; Reduced User Input Form'!J33","v":0},{"$f":"'INPTR; Reduced User Input Form'!J34","v":0},{"$f":"'INPTR; Reduced User Input Form'!J35","v":0},{"$f":"'INPTR; Reduced User Input Form'!J36","v":0},{"$f":"'INPTR; Reduced User Input Form'!J37","v":0},{"$f":"'INPTR; Reduced User Input Form'!F55","v":0},{"$f":"'INPTR; Reduced User Input Form'!F56","v":0},{"$f":"'INPTR; Reduced User Input Form'!F57","v":0},{"$f":"'INPTR; Reduced User Input Form'!F58","v":0},{"$f":"'INPTR; Reduced User Input Form'!F59","v":0},{"$f":"'INPTR; Reduced User Input Form'!F60","v":0},{"$f":"'INPTR; Reduced User Input Form'!F61","v":0},{"$f":"'INPTR; Reduced User Input Form'!F78","v":0},{"$f":"'INPTR; Reduced User Input Form'!F79","v":0},{"$f":"'INPTR; Reduced User Input Form'!G80","v":0},{"$f":"'INPTR; Reduced User Input Form'!F82","v":0},{"$f":"'INPTR; Reduced User Input Form'!F83","v":0},{"$f":"'INPTR; Reduced User Input Form'!F84","v":0},{"$f":"'INPTR; Reduced User Input Form'!F85","v":0},{"$f":"'INPTR; Reduced User Input Form'!G86","v":0},{"$f":"'INPTR; Reduced User Input Form'!F88","v":0},{"$f":"'INPTR; Reduced User Input Form'!G80","v":0},{"$f":"'OUTPR; Appraisal'!F17","v":{"$error":"#N/A"}},{"$f":"'OUTPR; Appraisal'!F18","v":{"$error":"#N/A"}},{"$f":"'OUTPR; Appraisal'!F31","v":{"$error":"#N/A"}},{"$f":"'OUTPR; Appraisal'!F32","v":{"$error":"#N/A"}}]