{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["QA Checklist","Tool Navigation","Tool","Tool Guidance","Building Zone Breakdown","Building Zone Guidance","Detailed Input Spreadsheet ","Detailed Input Guidance","Energy Results","Water Results","DataExtract"],"not_rendered":{"charts":0,"images":308,"macros":1,"external_links":0,"defined_names":8,"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":"QA Checklist","index":0,"n_rows":17,"n_cols":3,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
[]
[null,"INTERNAL QA CHECKLIST"]
[]
[null,"Last Updated by:","Francois Retief"]
[]
[null,null,"Completed?"]
[null,"Make necessary changes. Be careful of existing links and formulas!","Y"]
[null,"Update 'Last Update' date on first sheet","Y"]
[null,"Update Changelog with description of change","Y"]
[null,"Ensure all sheets are locked (except hidden sheets)","N"]
[null,"Test that all required fields can be populated (input mock figures)","Y"]
[null,"Test that calculations are working correctly","Y"]
[null,"Ensure hidden sheet 'Data Extract' is in place and working correctly (figures are pulling through)","Y"]
[null,"Ensure any 'hidden' sheets have been hidden","N"]
[null,"Lock workbook structure","N"]
[null,"'Save As' to server with date in filename","Y"]
[null,"Send to IES to upload to Certification Engine","Y"]

{"sheet":"Tool Navigation","index":1,"n_rows":41,"n_cols":3,"rows_kept":41,"cut":false,"hidden":false,"merged":[[6,0,6,5],[4,0,4,5],[0,0,0,5],[1,0,1,5],[2,0,2,5],[3,0,3,5],[5,0,5,5],[40,1,40,5],[7,0,7,5],[8,0,8,5],[9,0,9,5],[11,0,11,5],[10,0,10,5],[39,1,39,5]]}
["GBCSA's Energy Water Performance v1 Tool\n\nLast Issued - Nov 2014"]
["The pilot benchmarking tool is an operational performance measurement tool which rates the performance of a whole building, by comparing the energy and water usage figures against a national “average” benchmark."]
["Step 1: For a preliminary score only, input basic data in the 'Tool' sheet."]
["Step 2: For a formal final result, input detailed zone data in the 'Building Zone Breakdown' sheet, and the detailed consumption data in the 'Detailed Input"]
["Spreadsheet' sheet."]
["This is done as follows:    "]
["- In the 'Building Zone Breakdown' sheet the building is broken down into zones based on operating functionalities, once this data is captured it is"]
["transfered to the 'Detailed Input Spreadsheet' sheet using the 'Transfer Results' button. "]
["- In the 'Detailed Input Spreadsheet'' sheet the annual energy and water usages are entered according to billing periods, once this data is captured "]
["it is transfered to the 'Tool' sheet using the 'Transfer Results' button.   "]
["- In the 'Tool' sheet the energy and/or water benchmarks are created via the 'Calculate Energy Benchmark' and 'Calculate Water Benchmark' buttons."]
["Once these benchmarks are created the user is referred to the appropriate results page."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["  The development of this tool was sponsored by:"]
[]
[]
[null,null,"and"]
[]
[]
[]
[]
[]
[]
["Change Log:"]
["Reissue Date","Changes"]
["2014-11-28","Version 1"]

{"sheet":"Tool","index":2,"n_rows":32,"n_cols":21,"rows_kept":32,"cut":false,"hidden":false,"merged":[[0,0,0,11],[15,1,15,4],[4,7,4,11],[6,10,6,11],[8,10,8,11],[5,1,5,4],[22,0,22,11],[28,0,31,4],[23,1,23,4],[16,1,16,4],[8,1,8,4],[9,1,9,4],[15,7,15,11],[9,10,9,11],[10,1,10,4],[5,6,9,6],[21,1,21,4],[16,7,16,11],[4,1,4,4],[7,1,7,4],[6,1,6,4],[7,10,7,11],[17,1,17,4]]}
["GBCSA's Energy Water Performance v1 Tool"]
[]
["Building Details",null,null,null,null,null,"Energy Usage Inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,"- Enter a value or select from the drop down list -"]
[]
["Building Name",null,null,null,null,null,"*Number of Computers",null,null,null,null,null,null,null,null,null,null,"-"]
["Street Address",null,null,null,null,null,"*Energy Usage for Previous 12 Months","Type","Unit","Fuel Factor (kgCO₂/kWh)","Quantity",null,null,null,null,null,null,"Mains Electricity",null,null,"- Enter a value or select from the drop down list -"]
[null,null,null,null,null,null,null,null,{"$f":"IF(S7 = \"Mains Electricity\", \"kWh\", IF(S7  = \"Town Gas (From Coal)\", \"GJ\",  IF(S7  = \"LPG\", \"GJ\",  IF(S7  = \"Natural Gas\", \"GJ\",  IF(S7  = \"Biogas\", \"GJ\",   IF(S7  = \"Diesel\", \"L\",  IF(S7  = \"Oil\", \"L\",   IF(S7  = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":"kWh"},{"$f":"IF(S7 = \"Mains Electricity\", \"1.2\", IF(S7 = \"Town Gas (From Coal)\", \"0.16\",  IF(S7 = \"LPG\", \"0.23\",  IF(S7 = \"Natural Gas\", \"0.2\",  IF(S7 = \"Biogas\", \"0.03\",   IF(S7 = \"Diesel\", \"0.27\",  IF(S7 = \"Oil\", \"0.26\",   IF(S7 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":"1.2"},null,null,null,null,null,null,null,"Town Gas (From Coal)","Mains Electricity",null,"Typical office: approximately 45 hours per week"]
["Suburb",null,null,null,null,null,null,null,{"$f":"IF(S8 = \"Mains Electricity\", \"kWh\", IF(S8  = \"Town Gas (From Coal)\", \"GJ\",  IF(S8  = \"LPG\", \"GJ\",  IF(S8  = \"Natural Gas\", \"GJ\",  IF(S8  = \"Biogas\", \"GJ\",   IF(S8  = \"Diesel\", \"L\",  IF(S8  = \"Oil\", \"L\",   IF(S8  = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(S8 = \"Mains Electricity\", \"1.2\", IF(S8 = \"Town Gas (From Coal)\", \"0.16\",  IF(S8 = \"LPG\", \"0.23\",  IF(S8 = \"Natural Gas\", \"0.2\",  IF(S8 = \"Biogas\", \"0.03\",   IF(S8 = \"Diesel\", \"0.27\",  IF(S8 = \"Oil\", \"0.26\",   IF(S8 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"LPG","-",null,"Call centre or similar: approximately 80 hours per week"]
["City",null,null,null,null,null,null,null,{"$f":"IF(S9 = \"Mains Electricity\", \"kWh\", IF(S9  = \"Town Gas (From Coal)\", \"GJ\",  IF(S9  = \"LPG\", \"GJ\",  IF(S9  = \"Natural Gas\", \"GJ\",  IF(S9  = \"Biogas\", \"GJ\",   IF(S9  = \"Diesel\", \"L\",  IF(S9  = \"Oil\", \"L\",   IF(S9  = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(S9 = \"Mains Electricity\", \"1.2\", IF(S9 = \"Town Gas (From Coal)\", \"0.16\",  IF(S9 = \"LPG\", \"0.23\",  IF(S9 = \"Natural Gas\", \"0.2\",  IF(S9 = \"Biogas\", \"0.03\",   IF(S9 = \"Diesel\", \"0.27\",  IF(S9 = \"Oil\", \"0.26\",   IF(S9 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"Natural Gas","-",null,"24 hour operation: 120 hours per week"]
["Province",null,null,null,null,null,null,null,{"$f":"IF(S10 = \"Mains Electricity\", \"kWh\", IF(S10  = \"Town Gas (From Coal)\", \"GJ\",  IF(S10  = \"LPG\", \"GJ\",  IF(S10  = \"Natural Gas\", \"GJ\",  IF(S10  = \"Biogas\", \"GJ\",   IF(S10  = \"Diesel\", \"L\",  IF(S10  = \"Oil\", \"L\",   IF(S10  = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(S10 = \"Mains Electricity\", \"1.2\", IF(S10 = \"Town Gas (From Coal)\", \"0.16\",  IF(S10 = \"LPG\", \"0.23\",  IF(S10 = \"Natural Gas\", \"0.2\",  IF(S10 = \"Biogas\", \"0.03\",   IF(S10 = \"Diesel\", \"0.27\",  IF(S10 = \"Oil\", \"0.26\",   IF(S10 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"Biogas","-"]
["*Postal Code",7800,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal"]
["Building Metrics",null,null,null,null,null,"Water Usage Inputs"]
[]
["*GLA",null,null,null,null,null,"Number of Occupants",{"$f":"IF(U16 = \"- Enter a value or select from the drop down list -\", \"\", IF(U16 > 0, IF(U16 = \"Approximately 12m² / person on average\", B16/12, IF(U16 = \"Approximately 15m² / person on average\", B16/15,  IF(U16 = \"Approximately 17m² / person on average\", B16/17,  IF(U16 = \"Approximately 20m² / person on average\", B16/20,  B16/U16) ) ) ), \"\"))","v":""},null,null,null,null,null,null,null,null,null,{"$f":"IF(U16 > 0, IF(U16 = \"Approx. 12m²/person\", B16/12, IF(U16 = \"Approx. 15m²/person\", B16/15,  IF(U16 = \"Approx. 17m²/person\", B16/17,  IF(U16 = \"Approx. 20m²/person\", B16/20,  B16/U16) ) ) ), \"\")","v":{"$error":"#VALUE!"}},null,null,"- Enter a value or select from the drop down list -"]
["*Occupancy Hours (per week)",null,null,null,null,null,"*Water Usage (kl)  for Previous 12 Months",null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately 12m² / person on average"]
["*Occupancy Rate (m²/person)",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately 15m² / person on average"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately 17m² / person on average"]
["* Denotes a required field",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately 20m² / person on average"]
[]
[]
["  The development of this tool was sponsored by:"]
[]
[]
[null,null,null,null,null,null,"and",null,null,null,null,null,null,null,null,null,null,null,null,null,"- Enter a value or select from the drop down list -"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately same as number of occupants"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately equal to the number of occupants x 1.2"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately equal to the number of occupants x 1.4"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately equal to the number of occupants x 1.6"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately equal to the number of occupants x 1.8"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Approximately equal to the number of occupants x 2.0"]

{"sheet":"Tool Guidance","index":3,"n_rows":70,"n_cols":1,"rows_kept":70,"cut":false,"hidden":false,"merged":[[69,0,73,4],[3,0,5,4],[0,0,0,5],[49,1,49,4],[50,0,52,4],[60,0,61,4],[63,0,67,4]]}
["Energy Water Performance Tool                                                                                                                                                              Tool Input Guidance File"]
["Building Details"]
["Postal Code"]
["The South African postal code system consists of four digit codes ranging from 0001-9999 (please note that the number range 9000-9299 is excluded as this belongs to regions in Namibia). The following intervals may be used as a rough guide only:"]
[]
[]
["Limpopo"]
["- Northern and eastern regions 0699-0999"]
["- Southern and western regions 0500-0698"]
["North West"]
["- Northern regions 0300-0499"]
["- Southern and central regions 2500-2899"]
["Gauteng"]
["- Johannesburg 2000-2199"]
["- Tshwane 0001-0299"]
["- West Rand 1700-1799"]
["- Ekurhuleni 1400-1699"]
["- Soweto and Vereeniging/Vanderbijlpark 1800-1999"]
["Mpumalanga"]
["- Northern regions 1000-1399"]
["- Southern regions 2200-2499"]
["Northern Cape"]
["- Kimberley and eastern regions 8300-8799"]
["- Namaqualand region 8100-8299"]
["- Interior and northern (Gordonia) regions 8800-8999"]
["Free State"]
["- Bloemfontein and interior and southern regions 9300-9399, 9900-9999"]
["- Northern regions 9400-9699"]
["- Eastern regions 9700-9899"]
["KwaZulu Natal"]
["- Ethekwini 4000-4099"]
["- Pietermaritzburg and the Midlands 3200-3799"]
["- Richards Bay and northern regions 2900-3199, 3800-3999"]
["- North Coast 4300-4499"]
["- South Coast 4100-4299"]
["- Eastern Griqualand regions 4500-4730"]
["Western Cape"]
["- Greater Cape Town area and Cape Peninsula 7100-7299, 7400-8099"]
["- Garden Route regions 6500-6699"]
["- Karoo regions 6700-7099"]
["- West Coast regions 7300-7399"]
["Eastern Cape"]
["- East London 5200-5299"]
["- Port Elizabeth 6000-6099"]
["- Northern regions 5300-5499"]
["- Southern regions 6100-6499"]
["- Interior regions 4731-5199, 5500-5999"]
[]
["Building Metrics"]
["GLA"]
["The Gross Lettable Area (GLA) is calculated using the SAPOA definition for rentable area, which specifies the GLA as the total area of the building enclosed by the dominant face, adjusted by deducting major vertical penetrations. The GLA therefore includes all areas dedicated to exclusive use by tenants, including common areas such as:"]
[]
[]
["- Building entrance foyers"]
["- Plant and server rooms on tenant floors"]
["- Toilet areas on the tenant floors"]
["- Access or circulation areas on tenant floors."]
["The GLA excludes car parks."]
[]
["Occupancy Hours (per week)"]
["Occupancy hours is defined as the hours for which the building is occupied, measured on a weekly basis when 20% or more of the normal, permanent occupants of the building are present. Normal office buildings have occupancy hours of 40-60 hours per week. It is important to note that this measurement is taken in terms of business or normal office activities and not in terms of plant Heating, Ventilation and Air Conditioning (HVAC) system operations. For example, if 20% or more of the normal, permanent occupants of the building are present from 08:00 to 17:00 on weekdays, the occupancy hours are 9 hours per day, or 45 hours per week."]
[]
["Energy Usage Inputs"]
["Most buildings will typically only have a value for electricity (in kWh) which can be obtained from utility bills. It is vital that only a year’s consumption be entered (total of 12 consecutive months), otherwise the results will not be a true reflection of the building’s performance. If the building has onsite renewable energy sources such as photo voltaic panels that are connected on the building side of the electricity meter, these do not need to be sub-metered and entered, as the effect of these renewables is accounted for by the reduced consumption from the utility providers. If such power sources are mounted on the building but are connected directly to the grid (on the grid side of the building meter) then they are considered to be unassociated with the building and the generated energy is not permitted to be considered as a credit against the building’s consumption."]
[]
[]
[]
[]
["Water  Usage Inputs"]
["The annual water consumption, in the appropriate units of kilolitres, can be obtained from utility bills. It is vital that only a year’s consumption be entered (total of 12 consecutive months), otherwise the results will not be a true reflection of the building’s performance. If the building uses recycled (such as grey water) or harvested rainwater, these do not need to be sub-metered and entered, the effect of these renewables is accounted for by the reduced consumption from the utility providers. Borehole water needs to be metered and added to the consumption from utility providers."]

{"sheet":"Building Zone Breakdown","index":4,"n_rows":121,"n_cols":41,"rows_kept":121,"cut":false,"hidden":false,"merged":[[1,37,7,37],[1,28,7,28],[1,29,7,29],[1,30,7,30],[1,31,7,31],[1,34,7,34],[1,35,7,35],[1,36,7,36],[1,19,7,19],[1,20,7,20],[1,32,7,32],[1,33,7,33],[1,22,7,22],[1,23,7,23],[1,26,7,26],[1,27,7,27],[1,24,7,24],[1,25,7,25],[0,0,0,16],[4,8,5,8],[4,0,5,0],[4,11,5,11],[4,15,5,15],[4,9,5,9],[4,2,5,2],[4,1,5,1],[1,21,7,21],[4,14,5,14],[4,12,5,12],[4,13,5,13],[110,0,114,16],[4,16,5,16],[4,3,5,3],[4,4,5,4],[4,5,5,5],[4,7,5,7],[4,6,5,6],[4,10,5,10]]}
["Energy Water Performance Tool                                                                                                                                                                                                                          Building Zone Breakdown",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Transfer to Detailed Input Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mains Electricity","Included","Office","Total Area Adjusted with Vacancy Rate","Included Office Area Adjusted with Vacancy Rate","Included Non Office Area","Energy 1 Conversion","Energy 2 Conversion","Equivalent Energy 1 for Excluded Zones","Equivalent Energy 2 for Excluded Zones","Included Office Area *OccHours Adjusted with Vacancy Rate","Included Non-office Area *(Default - OccHours)","Total","Included Office Area *NumComp Adjusted with Vacancy Rate","Included Non-office Area *(Default - NumComp )","Total","Included Office Area *NumOcc Adjusted with Vacancy Rate","Included Non-office Area *(Default - NumOcc)","Total","Water"]
[null,"Resets all inputs",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Town Gas (From Coal)"]
[null,"Is February 29 included in the rating period? ",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"LPG"]
["Zone","Included in Rating?                          Y/N","Office Area? Y     /N","Floor Area (m²)","Annual Vacancy (days)","Weekly Operating Hours","Number of Computers","Number of Occupants","Excludable Energy Source ","Unit","Fuel Factor (kgCO₂/kWh)","Excludable Energy Usage","Excludable Energy Source ","Unit","Fuel Factor (kgCO2/kWh)","Excludable Energy Usage","Excludable Water Usage (kl) ",null,"Natural Gas"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Biogas"]
["Totals","-","-",{"$f":"V113","v":0},"-",{"$f":"V118","v":0},{"$f":"V119","v":0},{"$f":"V120","v":0},"Mains Electricity (Equiv.)","kWh",1.2,{"$f":"V116*365/S13","v":0},"Mains Electricity (Equiv.)","kWh",1.2,{"$f":"V117*365/S13","v":0},{"$f":"V121*365/S13","v":0},null,"Diesel"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Oil"]
[null,null,null,null,null,null,null,null,"-",{"$f":"IF(AN9 = \"Mains Electricity\", \"kWh\", IF(AN9 = \"Town Gas (From Coal)\", \"GJ\",  IF(AN9 = \"LPG\", \"GJ\",  IF(AN9 = \"Natural Gas\", \"GJ\",  IF(AN9 = \"Biogas\", \"GJ\",   IF(AN9 = \"Diesel\", \"L\",  IF(AN9 = \"Oil\", \"L\",   IF(AN9 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AN9 = \"Mains Electricity\", \"1.2\", IF(AN9 = \"Town Gas (From Coal)\", \"0.16\",  IF(AN9 = \"LPG\", \"0.23\",  IF(AN9 = \"Natural Gas\", \"0.2\",  IF(AN9 = \"Biogas\", \"0.03\",   IF(AN9 = \"Diesel\", \"0.27\",  IF(AN9 = \"Oil\", \"0.26\",   IF(AN9 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,"-",{"$f":"IF(AO9 = \"Mains Electricity\", \"kWh\", IF(AO9 = \"Town Gas (From Coal)\", \"GJ\",  IF(AO9 = \"LPG\", \"GJ\",  IF(AO9 = \"Natural Gas\", \"GJ\",  IF(AO9 = \"Biogas\", \"GJ\",   IF(AO9 = \"Diesel\", \"L\",  IF(AO9 = \"Oil\", \"L\",   IF(AO9 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AO9 = \"Mains Electricity\", \"1.2\", IF(AO9 = \"Town Gas (From Coal)\", \"0.16\",  IF(AO9 = \"LPG\", \"0.23\",  IF(AO9 = \"Natural Gas\", \"0.2\",  IF(AO9 = \"Biogas\", \"0.03\",   IF(AO9 = \"Diesel\", \"0.27\",  IF(AO9 = \"Oil\", \"0.26\",   IF(AO9 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,true,true,{"$f":"IF(AND(T9,U9),D9*(1-(E9/$S$13)),D9)","v":0},{"$f":"IF(AND(T9,U9),D9*(1-(E9/$S$13)),0)","v":0},{"$f":"IF(AND(T9,NOT(U9)),D9,0)","v":0},{"$f":" IF(AN9 = \"Town Gas (From Coal)\", 37.07,  IF(AN9 = \"LPG\", 53.28,  IF(AN9 = \"Natural Gas\", 46.33,  IF(AN9 = \"Biogas\", 6.95,   IF(AN9 = \"Diesel\", 2.67,  IF(AN9 = \"Oil\", 2.53,   IF(AN9 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":" IF(AO9 = \"Town Gas (From Coal)\", 37.07,  IF(AO9 = \"LPG\", 53.28,  IF(AO9 = \"Natural Gas\", 46.33,  IF(AO9 = \"Biogas\", 6.95,   IF(AO9 = \"Diesel\", 2.67,  IF(AO9 = \"Oil\", 2.53,   IF(AO9 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":"IF(NOT(T9),Y9*L9,0)","v":0},{"$f":"IF(NOT(T9),Z9*P9,0)","v":0},{"$f":"W9*F9","v":0},{"$f":"X9*45","v":0},{"$f":"AC9+AD9","v":0},{"$f":"IF(AND(T9,U9),G9*(1-(E9/$S$13)),0)","v":0},{"$f":"IF(AND(T9,NOT(U9)),(D9/19),0)","v":0},{"$f":"AF9+AG9","v":0},{"$f":"IF(AND(T9,U9),H9*(1-(E9/$S$13)),0)","v":0},{"$f":"AG9","v":0},{"$f":"AI9+AJ9","v":0},{"$f":"IF(NOT(T9),Q9,0)","v":0},null,"-","-"]
[null,null,null,null,null,null,null,null,"-",{"$f":"IF(AN10 = \"Mains Electricity\", \"kWh\", IF(AN10 = \"Town Gas (From Coal)\", \"GJ\",  IF(AN10 = \"LPG\", \"GJ\",  IF(AN10 = \"Natural Gas\", \"GJ\",  IF(AN10 = \"Biogas\", \"GJ\",   IF(AN10 = \"Diesel\", \"L\",  IF(AN10 = \"Oil\", \"L\",   IF(AN10 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AN10 = \"Mains Electricity\", \"1.2\", IF(AN10 = \"Town Gas (From Coal)\", \"0.16\",  IF(AN10 = \"LPG\", \"0.23\",  IF(AN10 = \"Natural Gas\", \"0.2\",  IF(AN10 = \"Biogas\", \"0.03\",   IF(AN10 = \"Diesel\", \"0.27\",  IF(AN10 = \"Oil\", \"0.26\",   IF(AN10 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,"-",{"$f":"IF(AO10 = \"Mains Electricity\", \"kWh\", IF(AO10 = \"Town Gas (From Coal)\", \"GJ\",  IF(AO10 = \"LPG\", \"GJ\",  IF(AO10 = \"Natural Gas\", \"GJ\",  IF(AO10 = \"Biogas\", \"GJ\",   IF(AO10 = \"Diesel\", \"L\",  IF(AO10 = \"Oil\", \"L\",   IF(AO10 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AO10 = \"Mains Electricity\", \"1.2\", IF(AO10 = \"Town Gas (From Coal)\", \"0.16\",  IF(AO10 = \"LPG\", \"0.23\",  IF(AO10 = \"Natural Gas\", \"0.2\",  IF(AO10 = \"Biogas\", \"0.03\",   IF(AO10 = \"Diesel\", \"0.27\",  IF(AO10 = \"Oil\", \"0.26\",   IF(AO10 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,"Yes",true,true,{"$f":"IF(AND(T10,U10),D10*(1-(E10/$S$13)),D10)","v":0},{"$f":"IF(AND(T10,U10),D10*(1-(E10/$S$13)),0)","v":0},{"$f":"IF(AND(T10,NOT(U10)),D10,0)","v":0},{"$f":" IF(AN10 = \"Town Gas (From Coal)\", 37.07,  IF(AN10 = \"LPG\", 53.28,  IF(AN10 = \"Natural Gas\", 46.33,  IF(AN10 = \"Biogas\", 6.95,   IF(AN10 = \"Diesel\", 2.67,  IF(AN10 = \"Oil\", 2.53,   IF(AN10 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":" IF(AO10 = \"Town Gas (From Coal)\", 37.07,  IF(AO10 = \"LPG\", 53.28,  IF(AO10 = \"Natural Gas\", 46.33,  IF(AO10 = \"Biogas\", 6.95,   IF(AO10 = \"Diesel\", 2.67,  IF(AO10 = \"Oil\", 2.53,   IF(AO10 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":"IF(NOT(T10),Y10*L10,0)","v":0},{"$f":"IF(NOT(T10),Z10*P10,0)","v":0},{"$f":"W10*F10","v":0},{"$f":"X10*45","v":0},{"$f":"AC10+AD10","v":0},{"$f":"IF(AND(T10,U10),G10*(1-(E10/$S$13)),0)","v":0},{"$f":"IF(AND(T10,NOT(U10)),(D10/19),0)","v":0},{"$f":"AF10+AG10","v":0},{"$f":"IF(AND(T10,U10),H10*(1-(E10/$S$13)),0)","v":0},{"$f":"AG10","v":0},{"$f":"AI10+AJ10","v":0},{"$f":"IF(NOT(T10),Q10,0)","v":0},null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,"No",true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"Mains Electricity","","",null,"-","","",null,null,null,"No",true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,{"$f":"IF(S12=\"Yes\",366,365)","v":365},true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-",{"$f":"IF(AN74 = \"Mains Electricity\", \"kWh\", IF(AN74 = \"Town Gas (From Coal)\", \"GJ\",  IF(AN74 = \"LPG\", \"GJ\",  IF(AN74 = \"Natural Gas\", \"GJ\",  IF(AN74 = \"Biogas\", \"GJ\",   IF(AN74 = \"Diesel\", \"L\",  IF(AN74 = \"Oil\", \"L\",   IF(AN74 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AN74 = \"Mains Electricity\", \"1.2\", IF(AN74 = \"Town Gas (From Coal)\", \"0.16\",  IF(AN74 = \"LPG\", \"0.23\",  IF(AN74 = \"Natural Gas\", \"0.2\",  IF(AN74 = \"Biogas\", \"0.03\",   IF(AN74 = \"Diesel\", \"0.27\",  IF(AN74 = \"Oil\", \"0.26\",   IF(AN74 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,"-",{"$f":"IF(AO74 = \"Mains Electricity\", \"kWh\", IF(AO74 = \"Town Gas (From Coal)\", \"GJ\",  IF(AO74 = \"LPG\", \"GJ\",  IF(AO74 = \"Natural Gas\", \"GJ\",  IF(AO74 = \"Biogas\", \"GJ\",   IF(AO74 = \"Diesel\", \"L\",  IF(AO74 = \"Oil\", \"L\",   IF(AO74 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(AO74 = \"Mains Electricity\", \"1.2\", IF(AO74 = \"Town Gas (From Coal)\", \"0.16\",  IF(AO74 = \"LPG\", \"0.23\",  IF(AO74 = \"Natural Gas\", \"0.2\",  IF(AO74 = \"Biogas\", \"0.03\",   IF(AO74 = \"Diesel\", \"0.27\",  IF(AO74 = \"Oil\", \"0.26\",   IF(AO74 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,true,true,{"$f":"IF(AND(T74,U74),D74*(1-(E74/$S$13)),D74)","v":0},{"$f":"IF(AND(T74,U74),D74*(1-(E74/$S$13)),0)","v":0},{"$f":"IF(AND(T74,NOT(U74)),D74,0)","v":0},{"$f":" IF(AN74 = \"Town Gas (From Coal)\", 37.07,  IF(AN74 = \"LPG\", 53.28,  IF(AN74 = \"Natural Gas\", 46.33,  IF(AN74 = \"Biogas\", 6.95,   IF(AN74 = \"Diesel\", 2.67,  IF(AN74 = \"Oil\", 2.53,   IF(AN74 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":" IF(AO74 = \"Town Gas (From Coal)\", 37.07,  IF(AO74 = \"LPG\", 53.28,  IF(AO74 = \"Natural Gas\", 46.33,  IF(AO74 = \"Biogas\", 6.95,   IF(AO74 = \"Diesel\", 2.67,  IF(AO74 = \"Oil\", 2.53,   IF(AO74 = \"Coal\", 1945.42, 1 )) )) ) ) )","v":1},{"$f":"IF(NOT(T74),Y74*L74,0)","v":0},{"$f":"IF(NOT(T74),Z74*P74,0)","v":0},{"$f":"W74*F74","v":0},{"$f":"X74*45","v":0},{"$f":"AC74+AD74","v":0},{"$f":"IF(AND(T74,U74),G74*(1-(E74/$S$13)),0)","v":0},{"$f":"IF(AND(T74,NOT(U74)),(D74/19),0)","v":0},{"$f":"AF74+AG74","v":0},{"$f":"IF(AND(T74,U74),H74*(1-(E74/$S$13)),0)","v":0},{"$f":"AG74","v":0},{"$f":"AI74+AJ74","v":0},{"$f":"IF(NOT(T74),Q74,0)","v":0},null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,"-","","",null,"-","","",null,null,null,null,true,true,0,0,0,1,1,0,0,0,0,0,0,0,0,0,0,0,0,null,"-","-"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(V9:V109)","v":0},{"$f":"SUM(W9:W109)","v":0},{"$f":"SUM(X9:X109)","v":0},null,null,{"$f":"SUM(AA9:AA109)","v":0},{"$f":"SUM(AB9:AB109)","v":0},null,null,{"$f":"SUM(AE9:AE109)","v":0},null,null,{"$f":"SUM(AH9:AH109)","v":0},null,null,{"$f":"SUM(AK9:AK109)","v":0},{"$f":"SUM(AL9:AL109)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Building Area",null,{"$f":"V110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Rated Area",null,{"$f":"W110+X110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Included Non office Area",null,{"$f":"X110","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Energy 1",null,{"$f":"AA110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total Energy 2",null,{"$f":"AB110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Area weighted hours",null,{"$f":"IF(V113>0,AE110/V113,0)","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num comp",null,{"$f":"AH110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Num peep's",null,{"$f":"AK110","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Water",null,{"$f":"AL110","v":0}]

{"sheet":"Building Zone Guidance","index":5,"n_rows":53,"n_cols":8,"rows_kept":53,"cut":false,"hidden":false,"merged":[[0,0,0,5],[9,0,10,4],[5,0,6,4],[27,0,27,4],[30,0,30,4],[13,0,15,4],[17,0,19,4],[7,0,7,4],[1,0,3,4],[2,7,3,21],[52,0,52,4],[31,0,31,4],[34,0,34,4],[37,0,37,4],[40,0,43,4],[46,0,49,4]]}
["Energy Water Performance Tool                                                                                                                                                              Building Zone Breakdown Guidance File"]
["The Building Zone Breakdown tab allows for a more detailed analysis of the building zones to account for different functionalities, and non-office and excluded zones.",null,null,null,null,null,null,"Example"]
[null,null,null,null,null,null,null,"The following example details how the Building Zone Guidance tab can be used to allocate deafult values to zones used for non-office activities, or subtract energy/water usages from bulk inputs fror excluded zones. "]
[]
["Zone"]
["For the purposes of this rating tool, the rated building is taken to be the sum of all building zones nominated for inclusion in the rating. A building zone denotes an area or a collection of spaces in the building which share the following distinct characteristics:\n• Included or excluded from the rating;\n• Office or non-office usage;\n• Equal annual vacancy rates; \n• Equal weekly operating hours."]
[]
[]
["Included in Rating (Y/N)"]
["In cases where the non-office portion does not exceed 10% of the GLA, the energy and/or water use of the non-office area(s) can be included or excluded from the rating at the owner or assessor’s discretion.  The excluded non-office area(s) must be separately metered and excluded from the figures entered into the rating tool. In cases where the non-office portions exceeds 10% but not 30% of the GLA, the energy and/or water use of the non-office area(s) in excess of the 10% must be separately metered and excluded from the figures entered into the rating tool, such that the maximum non-office portion included in the rating does not exceed 10%. Zones may only be excluded if the energy/water usage of this zone can be isolated from the bulk reading.\n"]
[]
[]
["Office Area (Y/N)"]
["Office spaces are defined as facilities used for business activities such as administrative, clerical and similar information-based duties. Spaces dedicated to office support activities for staff/tenants only (e.g.  receptions, meeting rooms, training rooms, IT and other equipment facilities; kitchenettes; staff amenities; refreshment areas; recreation areas; child care facilities) are treated the same as office area and are also included.  "]
[]
[]
["Floor Area"]
["The Gross Lettable Area (GLA) is calculated using the SAPOA definition for rentable area, which specifies the GLA as the total area of the building enclosed by the dominant face, adjusted by deducting major vertical penetrations. The GLA therefore includes all areas dedicated to exclusive use by tenants, including common areas such as:"]
[]
[]
["- Building entrance foyers"]
["- Plant and server rooms on tenant floors"]
["- Toilet areas on the tenant floors"]
["- Access or circulation areas on tenant floors."]
["The GLA excludes car parks."]
[]
["Annual Vacancy "]
["The vacancy is the total number of days over the analysis year that the building zone was unoccupied. A default value of zero is assigned to all excluded and non-office areas. "]
[]
["Weekly Operating Hours"]
["Occupancy hours is defined as the hours for which the building is occupied, measured on a weekly basis when 20% or more of the normal, permanent occupants of the building are present. Normal office buildings have occupancy hours of 40-60 hours per week. It is important to note that this measurement is taken in terms of business or normal office activities and not in terms of plant Heating, Ventilation and Air Conditioning (HVAC) system operations. For example, if 20% or more of the normal, permanent occupants of the building are present from 08:00 to 17:00 on weekdays, the occupancy hours are 9 hours per day, or 45 hours per week."]
["The occupancy hours of common areas and circulation areas should be taken to be equal to the operating hours of the office portions which they serve. For non-office zones included in the rating, a default (median) value of 45 hours will be assigned to each of these zones as the weekly operating hours, regardless of the actual value, unless the space has clearly advertised public operating hours, in which case these should be used."]
[]
["Number of Computers"]
["The number of computers in regular use by the building occupants during the weekly operating hours. This number excludes network machines, and spare or training computers which are usually turned off. For non-office zones included in the rating, the default (median) value of 19m²/computer will be assigned to each of these zones, regardless of the actual computer count in the zone."]
[]
["Number of Occupants"]
["For the purposes of this tool, an occupant is defined as a permanent or part-time employee who is likely to occupy the building for more than 20 hours per week. For non-office zones included in the rating, the default (median) value of 19m²/person will be assigned to each of these zones, regardless of the person count in the zone."]
[]
["Excludable Energy Usage"]
["If a zone is excluded from the rating, the annual energy consumption for that zone must be sub-metered in order to be deducted from the bulk usage. It is vital that only a year’s consumption be entered, otherwise the results will not be a true reflection of the building’s performance. If alternative fuel sources are used, these should be selected from the dropdown menu and the values according to the corresponding units entered. The tool will automatically convert these figures to equivalent kWh of mains electricity. If the building makes use of renewable energy sources, such as photovoltaic cells, these contributions should be excluded from the bulk usage entered into the tool."]
[]
[]
[]
[]
["Excludable Water Usage"]
["If a zone is excluded from the rating, the annual water consumption for that zone must be sub-metered in order to be deducted from the bulk usage. It is vital that only a year’s consumption be entered, otherwise the results will not be a true reflection of the building’s performance. It is vital that only a year’s consumption be entered, otherwise the results will not be a true reflection of the building’s performance. If a zone makes use of rainwater harvesting or has, for example, a grey water system to reduce the consumption of potable water, these contributions should be excluded from the bulk usage entered into the tool."]
[]
[]
[]
[]
["Transfer Results"]
["Once all the required entry fields have been populated, the results must be transferred to the Detailed Input Spreadsheet page."]

{"sheet":"Detailed Input Spreadsheet ","index":6,"n_rows":88,"n_cols":20,"rows_kept":88,"cut":false,"hidden":false,"merged":[[80,0,84,9],[21,14,21,16],[21,17,21,18],[21,0,21,6],[11,1,11,2],[12,1,12,2],[13,1,13,2],[0,0,0,9],[21,7,21,9],[8,1,8,2],[9,1,9,2],[10,1,10,2],[7,1,7,2],[19,0,19,2],[7,5,8,6],[15,5,16,6]]}
["Energy Water Performance Tool                                                                                                                                                                                                                          Detailed Input Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
[null,"Transfer to Tool",null,null,null,null,null,null,null,null,null,null,null,null,"Mains Electricity"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Town Gas (From Coal)"]
[null,"Resets all inputs",null,null,null,null,null,null,null,null,null,null,null,null,"LPG"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Natural Gas"]
["Building Details",null,null,null,null,"Energy Usage Inputs",null,null,null,null,null,null,null,null,"Biogas"]
[null,null,null,null,null,"Number of Computers",null,0,null,null,null,null,null,null,"Diesel"]
["Building Name",null,null,null,null,"Energy Usage for Previous 12 Months (kWh Equivalent Mains Electricity)",null,{"$f":"IF(Q88>397, \"Too many billing days!\",IF(Q88<334, \"Too few billing days!\", 365*Q82/Q88) )","v":"Too few billing days!"},null,null,null,null,null,null,"Oil"]
["Street Address",null,null,null,null,null,null,null,null,null,null,null,null,null,"Coal"]
[null,null,null,null,null,"Excluded Energy Usage (kWh)",null,0]
["Suburb"]
["City"]
["Province"]
["Postal Code",null,null,null,null,"Water Usage Inputs"]
[null,null,null,null,null,"Number of Occupants",null,0]
[null,null,null,null,null,"Water Usage (kl)  for Previous                                                                                  12 Months",null,{"$f":"IF(T88>397, \"Too many billing days!\",IF(T88<334, \"Too few billing days!\", 365*S82/T88) )","v":"Too few billing days!"}]
["Building Metrics"]
["GLA",0,null,null,null,"Excluded Water Usage (kl)",null,0]
["Occupancy Hours",0]
[]
[]
["*Bulk Energy Usage Details",null,null,null,null,null,null,"*Bulk Water Usage Details",null,null,null,null,null,null,"Energy",null,null,"Water"]
["Energy Connection 1",null,null,null,null,null,null,"Water Connection 1"]
["Description","Start Date","End Date","Type","Unit","Fuel Factor (kgCO₂/kWh)","Consumption","Start Date","End Date","Consumption (kl)",null,null,null,null,"Billing days","Conversion","Equiv Elec","Billing days","water"]
[null,null,null,"Mains Electricity",{"$f":"IF(N25 = \"Mains Electricity\", \"kWh\", IF(N25 = \"Town Gas (From Coal)\", \"GJ\",  IF(N25 = \"LPG\", \"GJ\",  IF(N25 = \"Natural Gas\", \"GJ\",  IF(N25 = \"Biogas\", \"GJ\",   IF(N25 = \"Diesel\", \"L\",  IF(N25 = \"Oil\", \"L\",   IF(N25 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N25 = \"Mains Electricity\", \"1.2\", IF(N25 = \"Town Gas (From Coal)\", \"0.16\",  IF(N25 = \"LPG\", \"0.23\",  IF(N25 = \"Natural Gas\", \"0.2\",  IF(N25 = \"Biogas\", \"0.03\",   IF(N25 = \"Diesel\", \"0.27\",  IF(N25 = \"Oil\", \"0.26\",   IF(N25 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",{"$f":"C25-B25","v":0},{"$f":" IF(N25 = \"Town Gas (From Coal)\", 37.07,  IF(N25 = \"LPG\", 53.28,  IF(N25 = \"Natural Gas\", 46.33,  IF(N25 = \"Biogas\", 6.95,   IF(N25 = \"Diesel\", 2.67,  IF(N25 = \"Oil\", 2.53,   IF(N25 = \"Coal\", 1945.42,  IF(N25 = \"-\", 0, 1 ) )) )) ) ) )","v":0},{"$f":"P25*G25","v":0},{"$f":"I25-H25","v":0},{"$f":"J25","v":0}]
[null,null,null,"Mains Electricity",{"$f":"IF(N26 = \"Mains Electricity\", \"kWh\", IF(N26 = \"Town Gas (From Coal)\", \"GJ\",  IF(N26 = \"LPG\", \"GJ\",  IF(N26 = \"Natural Gas\", \"GJ\",  IF(N26 = \"Biogas\", \"GJ\",   IF(N26 = \"Diesel\", \"L\",  IF(N26 = \"Oil\", \"L\",   IF(N26 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N26 = \"Mains Electricity\", \"1.2\", IF(N26 = \"Town Gas (From Coal)\", \"0.16\",  IF(N26 = \"LPG\", \"0.23\",  IF(N26 = \"Natural Gas\", \"0.2\",  IF(N26 = \"Biogas\", \"0.03\",   IF(N26 = \"Diesel\", \"0.27\",  IF(N26 = \"Oil\", \"0.26\",   IF(N26 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",{"$f":"C26-B26","v":0},{"$f":" IF(N26 = \"Town Gas (From Coal)\", 37.07,  IF(N26 = \"LPG\", 53.28,  IF(N26 = \"Natural Gas\", 46.33,  IF(N26 = \"Biogas\", 6.95,   IF(N26 = \"Diesel\", 2.67,  IF(N26 = \"Oil\", 2.53,   IF(N26 = \"Coal\", 1945.42,  IF(N26 = \"-\", 0, 1 ) )) )) ) ) )","v":0},0,{"$f":"I26-H26","v":0},{"$f":"J26","v":0}]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"-"]
["Energy Connection 2",null,null,null,null,null,null,"Water Connection 2",null,null,null,null,null,null,{"$f":"SUM(O25:O36)","v":0},null,{"$f":"SUM(Q25:Q36)","v":0},{"$f":"SUM(R25:R36)","v":0},{"$f":"SUM(S25:S36)","v":0}]
["Description","Start Date","End Date","Type","Unit","Fuel Factor (kgCO₂/kWh)","Consumption","Start Date","End Date","Consumption (kl)",null,null,null,null,"Billing days","Conversion","Equiv Elec","Billing days","water"]
[null,null,null,"Mains Electricity",{"$f":"IF(N40 = \"Mains Electricity\", \"kWh\", IF(N40 = \"Town Gas (From Coal)\", \"GJ\",  IF(N40 = \"LPG\", \"GJ\",  IF(N40 = \"Natural Gas\", \"GJ\",  IF(N40 = \"Biogas\", \"GJ\",   IF(N40 = \"Diesel\", \"L\",  IF(N40 = \"Oil\", \"L\",   IF(N40 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N40 = \"Mains Electricity\", \"1.2\", IF(N40 = \"Town Gas (From Coal)\", \"0.16\",  IF(N40 = \"LPG\", \"0.23\",  IF(N40 = \"Natural Gas\", \"0.2\",  IF(N40 = \"Biogas\", \"0.03\",   IF(N40 = \"Diesel\", \"0.27\",  IF(N40 = \"Oil\", \"0.26\",   IF(N40 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",{"$f":"C40-B40","v":0},{"$f":" IF(N40 = \"Town Gas (From Coal)\", 37.07,  IF(N40 = \"LPG\", 53.28,  IF(N40 = \"Natural Gas\", 46.33,  IF(N40 = \"Biogas\", 6.95,   IF(N40 = \"Diesel\", 2.67,  IF(N40 = \"Oil\", 2.53,   IF(N40 = \"Coal\", 1945.42,  IF(N40 = \"-\", 0, 1 ) )) )) ) ) )","v":0},{"$f":"P40*G40","v":0},{"$f":"I40-H40","v":0},{"$f":"J40","v":0}]
[null,null,null,"Mains Electricity",{"$f":"IF(N41 = \"Mains Electricity\", \"kWh\", IF(N41 = \"Town Gas (From Coal)\", \"GJ\",  IF(N41 = \"LPG\", \"GJ\",  IF(N41 = \"Natural Gas\", \"GJ\",  IF(N41 = \"Biogas\", \"GJ\",   IF(N41 = \"Diesel\", \"L\",  IF(N41 = \"Oil\", \"L\",   IF(N41 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N41 = \"Mains Electricity\", \"1.2\", IF(N41 = \"Town Gas (From Coal)\", \"0.16\",  IF(N41 = \"LPG\", \"0.23\",  IF(N41 = \"Natural Gas\", \"0.2\",  IF(N41 = \"Biogas\", \"0.03\",   IF(N41 = \"Diesel\", \"0.27\",  IF(N41 = \"Oil\", \"0.26\",   IF(N41 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",0,0,0,{"$f":"I41-H41","v":0},{"$f":"J41","v":0}]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
["Energy Connection 3",null,null,null,null,null,null,"Water Connection 3",null,null,null,null,null,"-",{"$f":"SUM(O40:O51)","v":0},null,{"$f":"SUM(Q40:Q51)","v":0},{"$f":"SUM(R40:R51)","v":0},{"$f":"SUM(S40:S51)","v":0}]
["Description","Start Date","End Date","Type","Unit","Fuel Factor (kgCO₂/kWh)","Consumption","Start Date","End Date","Consumption (kl)",null,null,null,null,"Billing days","Conversion","Equiv Elec","Billing days","water"]
[null,null,null,"Mains Electricity",{"$f":"IF(N54 = \"Mains Electricity\", \"kWh\", IF(N54 = \"Town Gas (From Coal)\", \"GJ\",  IF(N54 = \"LPG\", \"GJ\",  IF(N54 = \"Natural Gas\", \"GJ\",  IF(N54 = \"Biogas\", \"GJ\",   IF(N54 = \"Diesel\", \"L\",  IF(N54 = \"Oil\", \"L\",   IF(N54 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N54 = \"Mains Electricity\", \"1.2\", IF(N54 = \"Town Gas (From Coal)\", \"0.16\",  IF(N54 = \"LPG\", \"0.23\",  IF(N54 = \"Natural Gas\", \"0.2\",  IF(N54 = \"Biogas\", \"0.03\",   IF(N54 = \"Diesel\", \"0.27\",  IF(N54 = \"Oil\", \"0.26\",   IF(N54 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",{"$f":"C54-B54","v":0},{"$f":" IF(N54 = \"Town Gas (From Coal)\", 37.07,  IF(N54 = \"LPG\", 53.28,  IF(N54 = \"Natural Gas\", 46.33,  IF(N54 = \"Biogas\", 6.95,   IF(N54 = \"Diesel\", 2.67,  IF(N54 = \"Oil\", 2.53,   IF(N54 = \"Coal\", 1945.42,  IF(N54 = \"-\", 0, 1 ) )) )) ) ) )","v":0},{"$f":"P54*G54","v":0},{"$f":"I54-H54","v":0},{"$f":"J54","v":0}]
[null,null,null,"Mains Electricity",{"$f":"IF(N55 = \"Mains Electricity\", \"kWh\", IF(N55 = \"Town Gas (From Coal)\", \"GJ\",  IF(N55 = \"LPG\", \"GJ\",  IF(N55 = \"Natural Gas\", \"GJ\",  IF(N55 = \"Biogas\", \"GJ\",   IF(N55 = \"Diesel\", \"L\",  IF(N55 = \"Oil\", \"L\",   IF(N55 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N55 = \"Mains Electricity\", \"1.2\", IF(N55 = \"Town Gas (From Coal)\", \"0.16\",  IF(N55 = \"LPG\", \"0.23\",  IF(N55 = \"Natural Gas\", \"0.2\",  IF(N55 = \"Biogas\", \"0.03\",   IF(N55 = \"Diesel\", \"0.27\",  IF(N55 = \"Oil\", \"0.26\",   IF(N55 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",0,0,0,{"$f":"I55-H55","v":0},{"$f":"J55","v":0}]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
["Energy Connection 4",null,null,null,null,null,null,"Water Connection 4",null,null,null,null,null,"-",{"$f":"SUM(O54:O65)","v":0},null,{"$f":"SUM(Q54:Q65)","v":0},{"$f":"SUM(R54:R65)","v":0},{"$f":"SUM(S54:S65)","v":0}]
["Description","Start Date","End Date","Type","Unit","Fuel Factor (kgCO₂/kWh)","Consumption","Start Date","End Date","Consumption (kl)",null,null,null,null,"Billing days","Conversion","Equiv Elec","Billing days","water"]
[null,null,null,"Mains Electricity",{"$f":"IF(N68 = \"Mains Electricity\", \"kWh\", IF(N68 = \"Town Gas (From Coal)\", \"GJ\",  IF(N68 = \"LPG\", \"GJ\",  IF(N68 = \"Natural Gas\", \"GJ\",  IF(N68 = \"Biogas\", \"GJ\",   IF(N68 = \"Diesel\", \"L\",  IF(N68 = \"Oil\", \"L\",   IF(N68 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N68 = \"Mains Electricity\", \"1.2\", IF(N68 = \"Town Gas (From Coal)\", \"0.16\",  IF(N68 = \"LPG\", \"0.23\",  IF(N68 = \"Natural Gas\", \"0.2\",  IF(N68 = \"Biogas\", \"0.03\",   IF(N68 = \"Diesel\", \"0.27\",  IF(N68 = \"Oil\", \"0.26\",   IF(N68 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",{"$f":"C68-B68","v":0},{"$f":" IF(N68 = \"Town Gas (From Coal)\", 37.07,  IF(N68 = \"LPG\", 53.28,  IF(N68 = \"Natural Gas\", 46.33,  IF(N68 = \"Biogas\", 6.95,   IF(N68 = \"Diesel\", 2.67,  IF(N68 = \"Oil\", 2.53,   IF(N68 = \"Coal\", 1945.42,  IF(N68 = \"-\", 0, 1 ) )) )) ) ) )","v":0},{"$f":"P68*G68","v":0},{"$f":"I68-H68","v":0},{"$f":"J68","v":0}]
[null,null,null,"Mains Electricity",{"$f":"IF(N69 = \"Mains Electricity\", \"kWh\", IF(N69 = \"Town Gas (From Coal)\", \"GJ\",  IF(N69 = \"LPG\", \"GJ\",  IF(N69 = \"Natural Gas\", \"GJ\",  IF(N69 = \"Biogas\", \"GJ\",   IF(N69 = \"Diesel\", \"L\",  IF(N69 = \"Oil\", \"L\",   IF(N69 = \"Coal\", \"Tonnes\", \"\" )) )) ) ) ) )","v":""},{"$f":"IF(N69 = \"Mains Electricity\", \"1.2\", IF(N69 = \"Town Gas (From Coal)\", \"0.16\",  IF(N69 = \"LPG\", \"0.23\",  IF(N69 = \"Natural Gas\", \"0.2\",  IF(N69 = \"Biogas\", \"0.03\",   IF(N69 = \"Diesel\", \"0.27\",  IF(N69 = \"Oil\", \"0.26\",   IF(N69 = \"Coal\", \"0.35\", \"\" )) )) ) ) ) )","v":""},null,null,null,null,null,null,null,"-",0,0,0,{"$f":"I69-H69","v":0},{"$f":"J69","v":0}]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,"Mains Electricity","","",null,null,null,null,null,null,null,"-",0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"-",{"$f":"SUM(O68:O79)","v":0},null,{"$f":"SUM(Q68:Q79)","v":0},{"$f":"SUM(R68:R79)","v":0},{"$f":"SUM(S68:S79)","v":0}]
["(Insert tool logo/design)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"Q38+Q52+Q66+Q80","v":0},null,{"$f":"S38+S52+S66+S80","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(B25:B36)>0, MIN(B25:B36),\"\")","v":""},{"$f":"IF(MAX(C25:C36)>0,MAX(C25:C36),\"\")","v":""},null,{"$f":"IF(MIN(H25:H36)>0,MIN(H25:H36),\"\")","v":""},{"$f":"IF(MAX(I25:FI36)>0,MAX(I25:I36),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(B40:B51)>0, MIN(B40:B51),\"\")","v":""},{"$f":"IF(MAX(C40:C51)>0,MAX(C40:C51),\"\")","v":""},null,{"$f":"IF(MIN(H40:H51)>0,MIN(H40:H51),\"\")","v":""},{"$f":"IF(MAX(I40:I51)>0,MAX(I40:I51),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(B54:B65)>0,MIN(B54:B65),\"\")","v":""},{"$f":"IF(MAX(C54:C65)>0,MAX(C54:C65),\"\")","v":""},null,{"$f":"IF(MIN(H54:H65)>0,MIN(H54:H65),\"\")","v":""},{"$f":"IF(MAX(I54:I65)>0,MAX(I54:I65),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(B68:B79)>0,MIN(B68:B79),\"\")","v":""},{"$f":"IF(MAX(C68:C79)>0,MAX(C68:C79),\"\")","v":""},null,{"$f":"IF(MIN(H68:H79)>0,MIN(H68:H79),\"\")","v":""},{"$f":"IF(MAX(I68:I79)>0,MAX(I68:I79),\"\")","v":""}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(MIN(O84:O87)>0,MIN(O84:O87),\"\")","v":""},{"$f":"IF(MAX(P84:P87)>0,MAX(P84:P87),\"\")","v":""},{"$f":"IF(AND(NOT(P88=\"\"),NOT(O88=\"\")),P88-O88,0)","v":0},{"$f":"IF(MIN(R84:R87)>0,MIN(R84:R87),\"\")","v":""},{"$f":"IF(MAX(S84:S87)>0,MAX(S84:S87),\"\")","v":""},{"$f":"IF(AND(NOT(S88=\"\"),NOT(R88=\"\")),S88-R88,0)","v":0}]

{"sheet":"Detailed Input Guidance","index":7,"n_rows":62,"n_cols":8,"rows_kept":62,"cut":false,"hidden":false,"merged":[[61,0,61,4],[2,7,2,14],[55,0,59,4],[3,0,5,4],[49,0,53,4],[0,0,0,5]]}
["Energy Water Performance Tool                                                                                                                                                             Detailed Input Spreadsheet Guidance File"]
["Building Details",null,null,null,null,null,null,"Example"]
["Postal Code",null,null,null,null,null,null,"The following example shows how the Detailed Input Spreadsheet tab can be used:"]
["The South African postal code system consists of frous digit codes ranging from 0001-9999 (please note that the number range 9000-9299 is excluded as this belongs to regions in Namibia). The following intervals may be used as a rough guide only:"]
[]
[]
["Limpopo"]
["- Northern and eastern regions 0699-0999"]
["- Southern and western regions 0500-0698"]
["North West"]
["- Northern regions 0300-0499"]
["- Southern and central regions 2500-2899"]
["Gauteng"]
["- Johannesburg 2000-2199"]
["- Tshwane 0001-0299"]
["- West Rand 1700-1799"]
["- Ekurhuleni 1400-1699"]
["- Soweto and Vereeniging/Vanderbijlpark 1800-1999"]
["Mpumalanga"]
["- Northern regions 1000-1399"]
["- Southern regions 2200-2499"]
["Northern Cape"]
["- Kimberley and eastern regions 8300-8799"]
["- Namaqualand region 8100-8299"]
["- Interior and northern (Gordonia) regions 8800-8999"]
["Free State"]
["- Bloemfontein and interior and southern regions 9300-9399, 9900-9999"]
["- Northern regions 9400-9699"]
["- Eastern regions 9700-9899"]
["KwaZulu Natal"]
["- Ethekwini 4000-4099"]
["- Pietermaritzburg and the Midlands 3200-3799"]
["- Richards Bay and northern regions 2900-3199, 3800-3999"]
["- North Coast 4300-4499"]
["- South Coast 4100-4299"]
["- Eastern Griqualand regions 4500-4730"]
["Western Cape"]
["- Greater Cape Town area and Cape Peninsula 7100-7299, 7400-8099"]
["- Garden Route regions 6500-6699"]
["- Karoo regions 6700-7099"]
["- West Coast regions 7300-7399"]
["Eastern Cape"]
["- East London 5200-5299"]
["- Port Elizabeth 6000-6099"]
["- Northern regions 5300-5499"]
["- Southern regions 6100-6499"]
["- Interior regions 4731-5199, 5500-5999"]
[]
["Bulk Energy Usage Inputs"]
["Most buildings will typically only have a value for electricity (in kWh) which can be obtained from utility bills. It is vital that only a year’s consumption be entered, otherwise the results will not be a true reflection of the building’s performance. It should be noted that the billing periods need not necessarily  be on a monthly basis, but the start and end date for each billing period must be entered and must overlap. Allowance has been made for a total annual variance of 60 days (one month greater/less than a year) to accommodate bills which do not refelct a period of exactly one year.  If alternative fuel sources are used, these should be selected from the dropdown menu and the values according to the corresponding units entered. The tool will automatically convert these figures to equivalent kWh of mains electricity. If the building has onsite renewable energy sources such as photo voltaic panels that are connected on the building side of the electricity meter, these do not need to be sub-metered and entered, as the effect of these renewables is accounted for by the reduced consumption from the utility providers. If such power sources are mounted on the building but are connected directly to the grid (on the grid side of the building meter) then they are considered to be unassociated with the building and the generated energy is not permitted to be considered as a credit against the building’s consumption."]
[]
[]
[]
[]
["Bulk Water  Usage Inputs"]
["The annual water consumption, in the appropriate units of kilolitres, can be obtained from utility bills. It is vital that only a year’s consumption be entered, otherwise the results will not be a true reflection of the building’s performance. It should be noted that the billing periods need not necessarily  be on a monthly basis, but the start and end date for each billing period must be entered and must overlap. Allowance has been made for a total annual variance of 60 days (one month greater/less than a year) to accommodate bills which do not refelct a period of exactly one year. If the building uses recycled (such as grey water) or harvested rainwater, these do not need to be sub-metered and entered, the effect of these renewables is accounted for by the reduced consumption from the utility providers. Borehole water needs to be metered and added to the consumption from utility providers."]
[]
[]
[]
[]
["Transfer Results"]
["Once all the required entry fields have been populated, the results must be transferred to the tool input page."]

{"sheet":"Energy Results","index":8,"n_rows":30,"n_cols":18,"rows_kept":30,"cut":false,"hidden":false,"merged":[[27,0,27,10],[61,2,61,3],[16,9,16,10],[10,7,10,9],[4,7,4,9],[5,7,5,9],[6,7,6,9],[7,7,7,9],[8,7,8,9],[9,7,9,9],[62,2,62,3],[64,0,72,3],[32,0,32,3],[34,0,34,3],[35,0,39,3],[59,2,59,3],[60,2,60,3],[26,6,26,7],[0,0,0,10],[21,9,21,10],[22,9,22,10],[23,9,23,10],[24,9,24,10],[20,6,20,7],[21,6,21,7],[23,6,23,7],[24,6,24,7],[2,1,6,3]]}
["GBCSA's Energy Water Performance v1 Tool                                                                                                                                                                                                    Energy Rating Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kWh/m²/a"]
[]
[null," ",null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Building Name"]
[null,null,null,null,null,null,"Street Address"]
[]
[null,null,null,null,null,null,"Suburb"]
[null,null,null,null,null,null,"City"]
[null,null,null,null,null,null,"Province"]
[null,null,null,null,null,null,"Postal Code",7945]
[]
[null,null,null,null,null,null,"Inputs"]
[]
[null,null,null,null,null,null,"Total Energy Usage",null,900000,"kWh/annum"]
[null,null,null,null,null,null,"Total Mains Electricity Equivalent",null,900000,"kWh/annum"]
[null,null,null,null,null,null,"Total Emissions",null,1080000,"kgCO2/annum"]
[]
[null,null,null,null,null,null,"Results"]
[]
[null,null,null,null,null,null,"Energy Intensity",null,360,"kWh/m²/annum"]
[null,null,null,null,null,null,"Benchmark Building Energy Intensity",null,375.73488943199999,"kWh/m²/annum"]
[]
[null,null,null,null,null,null,"Total Emissions",null,432,"kgCO2/m²/annum"]
[null,null,null,null,null,null,"Benchmark Building Total Emissions",null,450.8818673184,"kgCO2/m²/annum"]
[]
[null,null,null,null,null,null,"Points towards Green Star SA rating**",null,5]
[]
[null,null,"*detailed info must be entered in the 'Building Zone Breakdown' and 'Detailed Input Spreadsheet' sheets to obtain a final result."]
[null,null,"**indicates the number of energy points achieved if the project were to target a Green Star SA - Existing Building Performance rating  - refer to www.gbcsa.org.za for more detail."]

{"sheet":"Water Results","index":9,"n_rows":28,"n_cols":18,"rows_kept":28,"cut":false,"hidden":false,"merged":[[10,7,10,9],[0,0,0,10],[21,9,21,10],[22,9,22,10],[24,9,24,10],[9,7,9,9],[23,6,23,7],[8,7,8,9],[2,1,6,3],[4,7,4,9],[7,7,7,9],[5,7,5,9],[6,7,6,9],[64,0,72,3],[21,6,21,7],[34,0,34,3],[60,2,60,3],[62,2,62,3],[61,2,61,3],[32,0,32,3],[35,0,39,3],[59,2,59,3],[28,0,28,10]]}
["GBCSA's Energy Water Performance v1 Tool                                                                                                                                                                                                    Water Rating Results",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"kl/m²/a"]
[]
[null," ",null,null,null,null," "]
[null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Building Name"]
[null,null,null,null,null,null,"Street Address"]
[]
[null,null,null,null,null,null,"Suburb"]
[null,null,null,null,null,null,"City"]
[null,null,null,null,null,null,"Province"]
[null,null,null,null,null,null,"Postal Code",7945]
[]
[null,null,null,null,null,null,"Inputs"]
[]
[null,null,null,null,null,null,"Water Usage ",null,1,"kl/annum"]
[null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,null,null," "]
[]
[null,null,null,null,null,null,"Results"]
[]
[null,null,null,null,null,null,"Water Intensity",null,4.0000000000000002E-4,"kl/m²/annum"]
[null,null,null,null,null,null,"Benchmark Building Water Intensity",null,1.2761399189333333,"kl/m²/annum"]
[null,null,null,null,null,null,null,null," "]
[null,null,null,null,null,null,"Points towards Green Star SA rating**",null,11.5]
[]
[]
[null,null,"*detailed info must be entered in the 'Building Zone Breakdown' and 'Detailed Input Spreadsheet' shEWatts to obtain a final result."]
[null,null,"**indicates the number of energy points achieved if the project were to target a Green Star SA - Existing Building Performance rating  - refer to www.gbcsa.org.za for more detail."]

{"sheet":"DataExtract","index":10,"n_rows":43,"n_cols":4,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Key","Value","Measure"]
["EBP_EWP_Energy_POINTS_SCORE ",{"$f":"'Energy Results'!I27","v":5},null,"ENERGY - Compliance Route 1"]
["EBP_EWP_Water_POINTS_SCORE ",{"$f":"'Water Results'!I24","v":11.5},null,"WATER - Compliance Route 1"]
["EWP_Energy_Rating_(1-10 Scale)",0]
["EWP_Water_Rating_(1-10 Scale)",0]
["EBP_EWP_Total_Energy_Usage",{"$f":"'Energy Results'!I15","v":900000}," (kWh/annum)","ENERGY - Compliance Route 1"]
["EBP_EWP_Total_Mains_Electricity_Equivalent",{"$f":"'Energy Results'!I16","v":900000}," (kWh/annum)"]
["EBP_EWP_Total_Emissions_PerAnnum",{"$f":"'Energy Results'!I17","v":1080000}," (kgCo2/annum)"]
["EBP_EWP_Energy_Intensity",{"$f":"'Energy Results'!I21","v":360}," (kWh/m2/annum)"]
["EBP_EWP_Benchmark_Building_Energy_Intensity",{"$f":"'Energy Results'!I22","v":375.73488943199999}," (kWh/m2/annum)"]
["EBP_EWP_Total_Emissions_PerSquareMeter_PerAnnum",{"$f":"'Energy Results'!I24","v":432}," (kgCo2/m2/annum)"]
["EBP_EWP_Benchmark_Building_Total_Emissions",{"$f":"'Energy Results'!I25","v":450.8818673184}," (kgCo2/m2/annum)"]
[]
["EBP_EWP_kWh_e_consumption_Month_1",{"$f":"'Detailed Input Spreadsheet '!G25+'Detailed Input Spreadsheet '!G40+'Detailed Input Spreadsheet '!G54+'Detailed Input Spreadsheet '!G68","v":0}]
["EBP_EWP_kWh_e_consumption_Month_2",{"$f":"'Detailed Input Spreadsheet '!G26+'Detailed Input Spreadsheet '!G41+'Detailed Input Spreadsheet '!G55+'Detailed Input Spreadsheet '!G69","v":0}]
["EBP_EWP_kWh_e_consumption_Month_3",{"$f":"'Detailed Input Spreadsheet '!G27+'Detailed Input Spreadsheet '!G42+'Detailed Input Spreadsheet '!G56+'Detailed Input Spreadsheet '!G70","v":0}]
["EBP_EWP_kWh_e_consumption_Month_4",{"$f":"'Detailed Input Spreadsheet '!G28+'Detailed Input Spreadsheet '!G43+'Detailed Input Spreadsheet '!G57+'Detailed Input Spreadsheet '!G71","v":0}]
["EBP_EWP_kWh_e_consumption_Month_5",{"$f":"'Detailed Input Spreadsheet '!G29+'Detailed Input Spreadsheet '!G44+'Detailed Input Spreadsheet '!G58+'Detailed Input Spreadsheet '!G72","v":0}]
["EBP_EWP_kWh_e_consumption_Month_6",{"$f":"'Detailed Input Spreadsheet '!G30+'Detailed Input Spreadsheet '!G45+'Detailed Input Spreadsheet '!G59+'Detailed Input Spreadsheet '!G73","v":0}]
["EBP_EWP_kWh_e_consumption_Month_7",{"$f":"'Detailed Input Spreadsheet '!G31+'Detailed Input Spreadsheet '!G46+'Detailed Input Spreadsheet '!G60+'Detailed Input Spreadsheet '!G74","v":0}]
["EBP_EWP_kWh_e_consumption_Month_8",{"$f":"'Detailed Input Spreadsheet '!G32+'Detailed Input Spreadsheet '!G47+'Detailed Input Spreadsheet '!G61+'Detailed Input Spreadsheet '!G75","v":0}]
["EBP_EWP_kWh_e_consumption_Month_9",{"$f":"'Detailed Input Spreadsheet '!G33+'Detailed Input Spreadsheet '!G48+'Detailed Input Spreadsheet '!G62+'Detailed Input Spreadsheet '!G76","v":0}]
["EBP_EWP_kWh_e_consumption_Month_10",{"$f":"'Detailed Input Spreadsheet '!G34+'Detailed Input Spreadsheet '!G49+'Detailed Input Spreadsheet '!G63+'Detailed Input Spreadsheet '!G77","v":0}]
["EBP_EWP_kWh_e_consumption_Month_11",{"$f":"'Detailed Input Spreadsheet '!G35+'Detailed Input Spreadsheet '!G50+'Detailed Input Spreadsheet '!G64+'Detailed Input Spreadsheet '!G78","v":0}]
["EBP_EWP_kWh_e_consumption_Month_12",{"$f":"'Detailed Input Spreadsheet '!G36+'Detailed Input Spreadsheet '!G51+'Detailed Input Spreadsheet '!G65+'Detailed Input Spreadsheet '!G79","v":0}]
[]
[]
["EBP_EWP_Total_Water_Usage",{"$f":"'Water Results'!I15","v":1}," (kl/annum)","WATER - Compliance Route 1"]
["EBP_EWP_Water_Intensity",{"$f":"'Water Results'!I21","v":4.0000000000000002E-4}," (kl/m2/annum)"]
["EBP_EWP_Benchmark_Building_Intensity ",{"$f":"'Water Results'!I22","v":1.2761399189333333},"(kl/m2/annum)"]
["kl consumption"]
["EBP_EWP_kl_w_consumption_Month_1",{"$f":"'Detailed Input Spreadsheet '!J25+'Detailed Input Spreadsheet '!J40+'Detailed Input Spreadsheet '!J54+'Detailed Input Spreadsheet '!J68","v":0}]
["EBP_EWP_kl_w_consumption_Month_2",{"$f":"'Detailed Input Spreadsheet '!J26+'Detailed Input Spreadsheet '!J41+'Detailed Input Spreadsheet '!J55+'Detailed Input Spreadsheet '!J69","v":0}]
["EBP_EWP_kl_w_consumption_Month_3",{"$f":"'Detailed Input Spreadsheet '!J27+'Detailed Input Spreadsheet '!J42+'Detailed Input Spreadsheet '!J56+'Detailed Input Spreadsheet '!J70","v":0}]
["EBP_EWP_kl_w_consumption_Month_4",{"$f":"'Detailed Input Spreadsheet '!J28+'Detailed Input Spreadsheet '!J43+'Detailed Input Spreadsheet '!J57+'Detailed Input Spreadsheet '!J71","v":0}]
["EBP_EWP_kl_w_consumption_Month_5",{"$f":"'Detailed Input Spreadsheet '!J29+'Detailed Input Spreadsheet '!J44+'Detailed Input Spreadsheet '!J58+'Detailed Input Spreadsheet '!J72","v":0}]
["EBP_EWP_kl_w_consumption_Month_6",{"$f":"'Detailed Input Spreadsheet '!J30+'Detailed Input Spreadsheet '!J45+'Detailed Input Spreadsheet '!J59+'Detailed Input Spreadsheet '!J73","v":0}]
["EBP_EWP_kl_w_consumption_Month_7",{"$f":"'Detailed Input Spreadsheet '!J31+'Detailed Input Spreadsheet '!J46+'Detailed Input Spreadsheet '!J60+'Detailed Input Spreadsheet '!J74","v":0}]
["EBP_EWP_kl_w_consumption_Month_8",{"$f":"'Detailed Input Spreadsheet '!J32+'Detailed Input Spreadsheet '!J47+'Detailed Input Spreadsheet '!J61+'Detailed Input Spreadsheet '!J75","v":0}]
["EBP_EWP_kl_w_consumption_Month_9",{"$f":"'Detailed Input Spreadsheet '!J33+'Detailed Input Spreadsheet '!J48+'Detailed Input Spreadsheet '!J62+'Detailed Input Spreadsheet '!J76","v":0}]
["EBP_EWP_kl_w_consumption_Month_10",{"$f":"'Detailed Input Spreadsheet '!J34+'Detailed Input Spreadsheet '!J49+'Detailed Input Spreadsheet '!J63+'Detailed Input Spreadsheet '!J77","v":0}]
["EBP_EWP_kl_w_consumption_Month_11",{"$f":"'Detailed Input Spreadsheet '!J35+'Detailed Input Spreadsheet '!J50+'Detailed Input Spreadsheet '!J64+'Detailed Input Spreadsheet '!J78","v":0}]
["EBP_EWP_kl_w_consumption_Month_12",{"$f":"'Detailed Input Spreadsheet '!J36+'Detailed Input Spreadsheet '!J51+'Detailed Input Spreadsheet '!J65+'Detailed Input Spreadsheet '!J79","v":0}]