{"text_format":"1","workbook":"xlsx","n_sheets":18,"sheets":["Instructions","Factors (to hide)"," Carbon Account","Comparatives","1 Data","2 Elec Bills","3 Elec Use","4 Gas Bills","5 Gas Est","6 Public Trans","7 Car and Van","8 Road Fuel","9 Commute","10 Water bills","11 Water Est","12 Paper","13 PV Solar","Questionnaire - Carbon accounts"],"not_rendered":{"charts":0,"images":1,"macros":0,"external_links":0,"defined_names":33,"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":"Instructions","index":0,"n_rows":29,"n_cols":1,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[]
["We have selected data is complete Y (CELL G2) at the top of the screen for each tab that we have estimated or had information about please review each tab to ensure this is correct."]
["1.    Data: In the first table please fill in the box for the percentage of renewable electricity your company uses; applicable if you bought any electricity with a Climate Change Levy Exemption Certificate, enter the percentage of your total electricity usage that the renewable electricity covers. The table below holds records of any cars or vans used by your company; these include vehicles used for commuting and vehicles used for your business. Enter a unique name for the vehicle and the engines equivalent carbon dioxide emissions in grams per kilometre, this information should be available through the vehicles manufacturer. Finally enter the percentage of waste vegetable oil used by any vehicles you have entered."]
[]
["2.    Elec Bills: This tab is for regular electricity bills. If you do not have a regular electricity bill you can simply flag the tab as complete without entering anything; you can estimate your electricity usage on the next tab. If you do have bills enter the meter reading at the beginning of your accounting period, then simply enter the dates of each bill and the meter reading on that date. If you share the electricity with other businesses, estimate the percentage used by your business and enter this in the column E. "]
[]
["3.    Elec Use: If you do not have electricity bills you can estimate what your electricity use by listing the appliances you have in the office. Also if you do have bills but have some shared usage too, enter information into this tab as well as Elec Bills. Enter the information for each appliance to calculate its electricity use over the year. The percentage share box is for instances where appliances you use are also used by another business such as lights in a shared building atrium."]
[]
["4.    Gas Bills: Similar to the electricity bills tab, this tab is for regular gas bill information. If you do not have bills to reference, you can estimate your usage in the next tab. Firstly enter the meter reading at the beginning of your accounting period, then simply enter the dates of each bill and the meter reading. If you share the gas with other businesses, estimate the percentage used by your business and enter this in the column G."]
[]
["5.    Gas Est: This tab is used to estimate gas usage if bills are not available. Also if you do have bills but have some shared usage too, enter information into this tab as well. To determine how much gas you use, there are two methods, firstly the area method which involves entering your office size and how effective the building insulation is. A typical office space amount is 70 square feet per person. Secondly is the power method which involves entering the power of your heating system and how long the system is in operation during the year."]
[]
["6.    Public Trans: This tab is for recording journeys made using public transport, not including commuting. Each journey is recorded as one row.  Enter the date, type of transport used and how far you travelled and the CO2e will be calculated for each journey."]
[]
["7.    Car and Van: If you use a car or van for your business, record the journeys made on this tab. This does not include commuting. Each journey is recorded as one row.  Make sure to enter the correct car or van name that you entered into the Data tab otherwise the formula for calculating CO2e will not work."]
[]
["8.    Road Fuel: This tab is a simple recording of fuel used for business use. Each purchase of fuel is recorded as one row.  Take some care not to double count – fuel used for journeys recorded on the previous sheet does not need to be recorded here as well.  Enter the date, type of fuel and amount purchased."]
[]
["9.    Commute: The commute tab collects information regarding how each employee gets to work and back during the year. If cars are used, make sure the names of the cars entered into the Data tab are used. Enter the commuting distance for each day (to work and back again) followed by the regularity of the journey throughout the year and the transport type."]
[]
["10.  Water Bills: This tab works in the same way as the electricity and gas bills tabs. Enter in information from your water bills, if you do not have access to bills, you can estimate your usage in the next tab."]
[]
["11.  Water Est: If you do not have access to water bills then you can estimate your usage based on the number of employees and how much water the employees use."]
[]
["12.  Paper: This tab concerns how much paper is purchased for the business and whether any of that paper is recycled or not. Each paper purchase will be recorded as a row.  Enter the date of purchases, percentage of recycled paper in the purchase and the total weight of the paper."]
[]
["13.  PV Solar: This tab is only applicable if your business uses photovoltaic solar panels to generate your own electricity. "]
[]
["The  Carbon Account:  this is the results page.  If any row is shown as “Data not complete” please go back to tab or tabs relevant to that source of carbon emissions to complete the data and select “yes” in cell G2.  Once your results are displayed for the period you can save this as your carbon accounting record for that period.  To prepare figures for a new period simply save a copy of the spreadsheet and enter the new details from the Data tab and each tab thereafter."]

{"sheet":"Factors (to hide)","index":1,"n_rows":82,"n_cols":14,"rows_kept":82,"cut":false,"hidden":true,"merged":[]}
["Green Accountancy Carbon Accounting for Smaller Entities"]
[]
["Factors used in the CO2 calculations"]
["Type","Factor","Units","Expiry","Document Name","Tab","Line name","Notes"]
["Electricity generated - use",0.46218999999999999,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","UK electricity","Electricity generated"]
["Electricity generated - WTT",6.8879999999999997E-2,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- UK & overseas elec","WTT- UK electricity (generation)"]
["T&D- UK electricity - use",3.8159999999999999E-2,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Transmission and distribution","T&D- UK electricity"]
["T&D- UK electricity - WTT",5.6899999999999997E-3,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- UK & overseas elec","WTT- UK electricity (T&D)"]
["Electricity",{"$f":"SUM(B5:B8)","v":0.57491999999999988},"kg CO2e/ kWh",null,null,null,null,{"$f":"+B9*900","v":517.42799999999988}]
["Natural Gas - use",0.18445,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","Natural gas"]
["Natural Gas - WTT",2.4830000000000001E-2,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- fuels","Natural gas"]
["Natural Gas",{"$f":"SUM(B10:B11)","v":0.20927999999999999},"kg CO2e/ kWh"]
["Burning Oil",2.5321500000000001,"kg CO2e/ litre","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","Burning oil","No WTT"]
["Coal",{"$f":"3065.265/1000","v":3.0652649999999997},"kg CO2e/ kg","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","Coal (domestic)","Converted into kgs by / 1000, no WTT"]
["Wood logs",{"$f":"53.91/1000","v":5.391E-2},"kg CO2e/ kg","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Bioenergy","Wood logs","Converted into kgs by / 1000"]
["Wood logs",{"$f":"52.14/1000","v":5.2139999999999999E-2},"kg CO2e/ kg","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT - Bioenergy","Wood logs","Converted into kgs by / 1000"]
["Wood",{"$f":"SUM(B15:B16)","v":0.10605000000000001},"kg CO2e/ kg"]
[]
["Diesel",2.6761400000000002,"kg CO2e/ litre","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","Diesel (100% mineral diesel)","No WTT"]
["Petrol",2.2996799999999999,"kg CO2e/ litre","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","Petrol (100% mineral petrol)","No WTT"]
["LPG - use",0.21468000000000001,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Fuels","LPG",null,null,null,null,null,null,0.21451999999999999]
["LPG - WTT",2.6970000000000001E-2,"kg CO2e/ kWh","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- fuels","LPG",null,null,null,null,null,null,1.4928999999999999]
["LPG",{"$f":"SUM(B21:B22)*H23","v":1.6817046662315867},"kg CO2e/ litre",null,"Converted to litres using factor >>>",null,null,6.9592578780533279,null,null,null,"http://www.energyandcarbonmanagement.com/conversion-tables",null,{"$f":"+N22/N21","v":6.9592578780533279}]
["WVO",{"$f":"+B19*0.25","v":0.66903500000000005},"kg CO2e/ litre",null,null,null,null,"25% of diesel",null,null,null,null,null,{"$f":"+N21*N23","v":1.4928999999999999}]
[]
["Air travel long haul - use",0.19813,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- air","Long-haul","Average passenger with Radiative Forcing",null,null,null,null,null,0.27176]
["Air travel long haul - WTT",2.1600000000000001E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- business travel- air","Long-haul","Average passenger with Radiative Forcing",null,null,null,null,null,2.9342999999999999]
["Air travel long haul",{"$f":"SUM(B26:B27)","v":0.21973000000000001},"kg CO2e/ km",null,null,null,null,null,null,null,0.62137119200000002,{"$f":"+B28/K28","v":0.35362115725506632},null,{"$f":"+N27/N26","v":10.797394760082426}]
["Air travel short haul - use",0.16972000000000001,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- air","Short-haul","Average passenger with Radiative Forcing",null,null,null,null,null,{"$f":"+N26*N28","v":2.9342999999999999}]
["Air travel short haul - WTT",1.8499999999999999E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- business travel- air","Short-haul","Average passenger with Radiative Forcing"]
["Air travel short haul",{"$f":"SUM(B29:B30)","v":0.18822},"kg CO2e/ km",null,null,null,null,null,null,null,0.62137119200000002,{"$f":"+B31/K31","v":0.30291072779569733}]
["Train - use",4.5057E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- land","National rail"]
["Train - WTT",8.1600000000000006E-3,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- pass vehs & travel- land","National rail"]
["Train",{"$f":"SUM(B32:B33)","v":5.3217E-2},"kg CO2e/ km",null,null,null,null,null,null,null,0.62137119200000002,{"$f":"+B34/K34","v":8.5644459680712076E-2}]
["Coach - use",2.93E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- land","Coach"]
["Coach - WTT",6.2700000000000004E-3,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- pass vehs & travel- land","Coach"]
["Coach",{"$f":"SUM(B35:B36)","v":3.5569999999999997E-2},"kg CO2e/ km"]
["Local bus - use",0.10033,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- land","Average local bus"]
["Local bus - WTT",2.172E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- pass vehs & travel- land","Average local bus"]
["Local bus",{"$f":"SUM(B38:B39)","v":0.12205000000000001},"kg CO2e/ km",null,null,null,null,null,null,null,0.62137119200000002,{"$f":"+B40/K40","v":0.19642043527502318}]
["Underground - use",5.6309999999999999E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- land","London Underground"]
["Underground - WTT",8.3899999999999999E-3,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- pass vehs & travel- land","London Underground"]
["Underground",{"$f":"SUM(B41:B42)","v":6.4699999999999994E-2},"kg CO2e/ km"]
["Taxi - use",0.21872,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Business travel- land","Black cab"]
["Taxi - WTT",4.7500000000000001E-2,"kg CO2e/ km","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","WTT- pass vehs & travel- land","Black cab"]
["Taxi",{"$f":"SUM(B44:B45)","v":0.26622000000000001},"kg CO2e/ km"]
[]
[]
[]
[]
["Water supply",0.34399999999999997,"kg CO2e/ m3","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Water supply","Water supply"]
["Water treatment",0.70799999999999996,"kg CO2e/ m3","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Water treatment","Water treatment"]
["Water",{"$f":"SUM(B51:B52)","v":1.052},"kg CO2e/ m3"]
["Paper",{"$f":"+(939+490)/1000*2.5","v":3.5725000000000002},"CO2 kg / ream (500 sheets or 2.5kg paper)","2016-05-31","150625 DCFCarbonFactors_25_6_2015_114853","Material use","Paper and board: paper",null,null,1000]
["Recycled Paper",{"$f":"+B54/2","v":1.7862500000000001},"CO2 kg / ream (500 sheets or 2.5kg paper)"]
[]
[]
[]
["Translations"]
["mile",1.60934,"km"]
["kWh",1,"kWh"]
["Therms",29.307108332999999,"kWh",null,"Gas"]
["Cubic m",{"$f":"30.2/2.831684659","v":10.665029350642818},"kWh",null,"Gas"]
["1 kg Butane = ",1.74,"litres"]
["1 kg Propane =",1.95,"litres"]
["1 Gallon =",4.5460890000000003,"litres"]
[]
["Typical office use of gas",150,"kwh per square meter per year"]
["Typical office use of water",50,"litres per person per day",null,null,"http://www.green-office.org.uk/audit.php?goingto=factsheet5"]
[]
["Fuel prices ","Petrol","Diesel",null,"LPG","WVO"]
["Date from","£ / Litre","£ / Litre",null,"£ / Litre","£ / Litre"]
["2003-01-01",0.75,0.76400000000000001]
["2004-01-01",0.76200000000000001,0.77900000000000003]
["2005-01-01",0.79,0.84199999999999997]
["2006-01-01",0.88,0.93100000000000005]
["2007-01-01",0.86899999999999999,0.91400000000000003]
["2008-01-01",1.0369999999999999,1.087]
["2009-01-01",0.86299999999999999,0.98699999999999999]
["2010-01-01",1.115,1.133]
["2011-01-01",1.2749999999999999,1.321]
["2012-01-01",1.3460000000000001,1.4259999999999999]

{"sheet":" Carbon Account","index":2,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"}]
["Carbon Accounting Statement"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"}]
[]
[null,"CO2e kg"]
["Electricity",{"$f":"IF(AND('2 Elec Bills'!G2=\"Yes\",'3 Elec Use'!G2=\"Yes\"),+'2 Elec Bills'!G8+'3 Elec Use'!K8,\"Data not complete\")","v":"Data not complete"}]
["Gas",{"$f":"IF(AND('4 Gas Bills'!G2=\"Yes\",'5 Gas Est'!G2=\"Yes\"),+'4 Gas Bills'!I8+'5 Gas Est'!D21, \"Data not complete\")","v":"Data not complete"}]
["Travel: Commuting (non-air)",{"$f":"(IF(AND( '9 Commute'!G2=\"Yes\"),'9 Commute'!J9, \"Data not complete\"))","v":"Data not complete"}]
["Travel: Business (non-air)",{"$f":"(IF(AND('6 Public Trans'!G2=\"Yes\",'7 Car and Van'!G2=\"Yes\",'8 Road Fuel'!G2=\"Yes\"),+'6 Public Trans'!E8+'7 Car and Van'!E8+'8 Road Fuel'!E8, \"Data not complete\"))","v":"Data not complete"}]
["Travel: Air",{"$f":"(IF(AND('6 Public Trans'!G2=\"Yes\", '9 Commute'!G2=\"Yes\"),+'6 Public Trans'!E7+'9 Commute'!J8, \"Data not complete\"))","v":"Data not complete"}]
["Water",{"$f":"IF(AND('10 Water bills'!G2=\"Yes\",'11 Water Est'!G2=\"Yes\"),+'10 Water bills'!G8+'11 Water Est'!B8, \"Data not complete\")","v":"Data not complete"}]
["Paper use",{"$f":"IF(AND('12 Paper'!G2=\"Yes\"),+'12 Paper'!E8, \"Data not complete\")","v":"Data not complete"}]
[]
["Gross Total emissions (CO2e kg)",{"$f":"IF(COUNT(B6:B12)=7,SUM(B6:B12),\"Data not complete\")","v":"Data not complete"}]
[]
["Green tariff electricity",{"$f":"IFERROR(-B6*'1 Data'!B13,0)","v":0}]
["PV Solar electricity generated",{"$f":"+'13 PV Solar'!G8","v":0}]
["Carbon offsetting expenditure (CO2e kg)",0]
[]
["Net Total emissions (CO2e kg)",{"$f":"IF(COUNT(B6:B12)=7,SUM(B14:B19),\"Data not complete\")","v":"Data not complete"}]
[]
["Turnover (£)",{"$f":"+'1 Data'!B12","v":0}]
[]
["CO2 e kg per £1000 turnover - Gross",{"$f":"IF(COUNT(B6:B12)=7,+B14/B22*1000,\"Data not complete\")","v":"Data not complete"}]
["CO2 e kg per £1000 turnover - Net",{"$f":"IF(COUNT(B6:B12)=7,+B20/B22*1000,\"Data not complete\")","v":"Data not complete"}]

{"sheet":"Comparatives","index":3,"n_rows":21,"n_cols":3,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"}]
["Carbon Accounting Statement"]
["These figures show the CO2e kg per £1,000 of turnover. "]
[]
[null,{"$f":"\"For the period ending \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period ending 0 January 1900"},"For the period ending XX MONTH 20XX"]
[null,"CO2e kg","CO2e kg"]
["Electricity",{"$f":"+' Carbon Account'!B6/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Gas",{"$f":"+' Carbon Account'!B7/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Travel: Commuting (non-air)",{"$f":"+' Carbon Account'!B8/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Travel: Business (non-air)",{"$f":"+' Carbon Account'!B9/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Travel: Air",{"$f":"+' Carbon Account'!B10/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Water",{"$f":"+' Carbon Account'!B11/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
["Paper use",{"$f":"+' Carbon Account'!B12/' Carbon Account'!$B$22*1000","v":{"$error":"#VALUE!"}},0]
[]
["Gross Total emissions (CO2e kg)",{"$f":"IF(COUNT(B7:B13)=7,SUM(B7:B13),\"Data not complete\")","v":"Data not complete"},{"$f":"IF(COUNT(C7:C13)=7,SUM(C7:C13),\"Data not complete\")","v":0}]
[]
["Green tariff electricity",{"$f":"+' Carbon Account'!B16/' Carbon Account'!$B$22*1000","v":{"$error":"#DIV/0!"}},0]
["PV Solar electricity generated",{"$f":"+' Carbon Account'!B17/' Carbon Account'!$B$22*1000","v":{"$error":"#DIV/0!"}},0]
["Carbon offsetting expenditure (CO2e kg)",{"$f":"+' Carbon Account'!B18/' Carbon Account'!$B$22*1000","v":{"$error":"#DIV/0!"}},0]
[]
["Net Total emissions (CO2e kg)",{"$f":"IF(COUNT(B7:B13)=7,SUM(B15:B20),\"Data not complete\")","v":"Data not complete"},{"$f":"IF(COUNT(C7:C13)=7,SUM(C15:C20),\"Data not complete\")","v":0}]

{"sheet":"1 Data","index":4,"n_rows":16,"n_cols":7,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"Yes"]
["Data for Carbon Accounting"]
[]
["Please complete coloured cells.  White cells should not need to be amended"]
[]
[]
["Entity name:","The Example Company"]
[]
["Start"]
["End",null,"< calculated as one year but can be overtyped if different"]
["Turnover or Gross Income",0]
["% Renewable Electricity",null,"Record % of electricity with Climate Change Levy Exemption Certificate "]
[]
["Cars used","CO2e g per km","Waste Veg Oil %"]
[null,null,null,"Record cars and vans used for business use and commuting"]

{"sheet":"2 Elec Bills","index":5,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Electricity bills"]
[]
["Record here all electricity bills relating to the period.  Include date and reading at start of first bill"]
["If no bills then leave blank and complete \"Elec Use\" tab instead."]
["If you have electricity bills AND other electricity use, such as electricity in a shared space, then complete BOTH tabs."]
["Total for period",null,null,{"$f":"SUM(D11:D25)","v":0},null,{"$f":"SUM(F11:F25)","v":0},{"$f":"SUM(G11:G25)","v":0}]
["Date","Meter reading kWh","Electricity units on bill kWh","Electricity this period kWh","Percentage business","Business use in period kWh","CO2e Kg"]
[null,null,null,null,null,null,null,"< date and reading at start of first bill"]
[null,null,{"$f":"IF(B11>0,+B11-B10,0)","v":0},{"$f":"IF($A10>0,MAX(+$A11-$A10-MAX('1 Data'!$B$10-1-$A10,0)-MAX($A11-'1 Data'!$B$11,0),0)*$C11/($A11-$A10),0)","v":0},1,{"$f":"+D11*E11","v":0},{"$f":"F11*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of first bill"]
[null,null,0,{"$f":"IF($A11>0,MAX(+$A12-$A11-MAX('1 Data'!$B$10-1-$A11,0)-MAX($A12-'1 Data'!$B$11,0),0)*$C12/($A12-$A11),0)","v":0},1,{"$f":"+D12*E12","v":0},{"$f":"F12*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of second bill"]
[null,null,0,{"$f":"IF($A12>0,MAX(+$A13-$A12-MAX('1 Data'!$B$10-1-$A12,0)-MAX($A13-'1 Data'!$B$11,0),0)*$C13/($A13-$A12),0)","v":0},1,0,{"$f":"F13*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of third bill"]
[null,null,0,{"$f":"IF($A13>0,MAX(+$A14-$A13-MAX('1 Data'!$B$10-1-$A13,0)-MAX($A14-'1 Data'!$B$11,0),0)*$C14/($A14-$A13),0)","v":0},1,0,{"$f":"F14*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}," etc."]
[null,null,0,{"$f":"IF($A14>0,MAX(+$A15-$A14-MAX('1 Data'!$B$10-1-$A14,0)-MAX($A15-'1 Data'!$B$11,0),0)*$C15/($A15-$A14),0)","v":0},1,0,{"$f":"F15*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A15>0,MAX(+$A16-$A15-MAX('1 Data'!$B$10-1-$A15,0)-MAX($A16-'1 Data'!$B$11,0),0)*$C16/($A16-$A15),0)","v":0},1,0,{"$f":"F16*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,{"$f":"IF(B17>0,+B17-B16,0)","v":0},{"$f":"IF($A16>0,MAX(+$A17-$A16-MAX('1 Data'!$B$10-1-$A16,0)-MAX($A17-'1 Data'!$B$11,0),0)*$C17/($A17-$A16),0)","v":0},1,{"$f":"+D17*E17","v":0},{"$f":"F17*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A17>0,MAX(+$A18-$A17-MAX('1 Data'!$B$10-1-$A17,0)-MAX($A18-'1 Data'!$B$11,0),0)*$C18/($A18-$A17),0)","v":0},1,0,{"$f":"F18*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A18>0,MAX(+$A19-$A18-MAX('1 Data'!$B$10-1-$A18,0)-MAX($A19-'1 Data'!$B$11,0),0)*$C19/($A19-$A18),0)","v":0},1,0,{"$f":"F19*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A19>0,MAX(+$A20-$A19-MAX('1 Data'!$B$10-1-$A19,0)-MAX($A20-'1 Data'!$B$11,0),0)*$C20/($A20-$A19),0)","v":0},1,0,{"$f":"F20*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A20>0,MAX(+$A21-$A20-MAX('1 Data'!$B$10-1-$A20,0)-MAX($A21-'1 Data'!$B$11,0),0)*$C21/($A21-$A20),0)","v":0},1,0,{"$f":"F21*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A21>0,MAX(+$A22-$A21-MAX('1 Data'!$B$10-1-$A21,0)-MAX($A22-'1 Data'!$B$11,0),0)*$C22/($A22-$A21),0)","v":0},1,0,{"$f":"F22*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A22>0,MAX(+$A23-$A22-MAX('1 Data'!$B$10-1-$A22,0)-MAX($A23-'1 Data'!$B$11,0),0)*$C23/($A23-$A22),0)","v":0},1,0,{"$f":"F23*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A23>0,MAX(+$A24-$A23-MAX('1 Data'!$B$10-1-$A23,0)-MAX($A24-'1 Data'!$B$11,0),0)*$C24/($A24-$A23),0)","v":0},1,0,{"$f":"F24*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A24>0,MAX(+$A25-$A24-MAX('1 Data'!$B$10-1-$A24,0)-MAX($A25-'1 Data'!$B$11,0),0)*$C25/($A25-$A24),0)","v":0},1,0,{"$f":"F25*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]

{"sheet":"3 Elec Use","index":6,"n_rows":30,"n_cols":11,"rows_kept":30,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Electricity - use record"]
[]
["Record here any electricity use not already included in the Elec Bills tab"]
["If an item has been used for part of a year then adjust the Quantity column accordingly."]
[]
["Total for period",null,null,null,null,null,null,null,null,{"$f":"SUM(J10:J29)","v":0},{"$f":"SUM(K10:K29)","v":0}]
[null,null,"Power (kW)","Hours per day","Power used per day (kWh)","Quantity of appliances","Days per week","Weeks per year","% share ","kWh per period","CO2e KG  per period"]
["Appliance 1","Laptops",0.2,7,{"$f":"+C10*D10","v":1.4000000000000001},null,5,47,1,{"$f":"+E10*F10*G10*H10*I10","v":0},{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J10","v":0}]
["Appliance 2","Monitors",0.03,7,{"$f":"+C11*D11","v":0.21},null,5,47,1,{"$f":"+E11*F11*G11*H11*I11","v":0},{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J11","v":0}]
["Appliance 3","Telephones",0.01,7,7.0000000000000007E-2,null,5,47,1,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J12","v":0}]
["Appliance 4","Modems",0.05,7,0.35000000000000003,null,5,47,1,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J13","v":0}]
["Appliance 5","Lights",0.05,7,0.35000000000000003,null,5,47,1,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J14","v":0}]
["Appliance 6","Kettle",2,0.33300000000000002,0.66600000000000004,null,5,51,1,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J15","v":0}]
["Appliance 7",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J16","v":0}]
["Appliance 8",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J17","v":0}]
["Appliance 9",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J18","v":0}]
["Appliance 10",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J19","v":0}]
["Appliance 11",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J20","v":0}]
["Appliance 12",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J21","v":0}]
["Appliance 13",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J22","v":0}]
["Appliance 14",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J23","v":0}]
["Appliance 15",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J24","v":0}]
["Appliance 16",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J25","v":0}]
["Appliance 17",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J26","v":0}]
["Appliance 18",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J27","v":0}]
["Appliance 19",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J28","v":0}]
["Appliance 20",null,null,null,0,null,null,null,null,0,{"$f":"VLOOKUP(\"Electricity\",'Factors (to hide)'!$A:$B,2,FALSE)*J29","v":0}]
[null,null,null,null,"^ this calculation (column E) can be overwritten if useage monitor readings taken to find averge use per day on any or all appliances"]

{"sheet":"4 Gas Bills","index":7,"n_rows":25,"n_cols":10,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Gas bills"]
[]
["Record here all gas bills relating to the period.  Include date and reading at start of first bill"]
["If no bills then leave blank and complete \"Gas Est\" tab instead."]
["If you have gas bills AND other gas use, such as gas heating in a shared space, then complete BOTH tabs."]
["Total for period",null,null,null,{"$f":"SUM(E11:E25)","v":0},null,null,{"$f":"SUM(H11:H25)","v":0},{"$f":"SUM(I11:I25)","v":0}]
["Date","Meter reading","Units","Gas units on bill","Gas relating to this period","Converted to kWh","Percentage business","Business use in period kWh","CO2e Kg"]
[null,null,"kWh",null,null,null,null,null,null,"< date and reading at start of first bill"]
[null,null,"kWh",{"$f":"IF(B11>0,+B11-B10,0)","v":0},{"$f":"IF($A10>0,MAX(+$A11-$A10-MAX('1 Data'!$B$10-1-$A10,0)-MAX($A11-'1 Data'!$B$11,0),0)*$D11/($A11-$A10),0)","v":0},{"$f":"E11*VLOOKUP(C11,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,{"$f":"+F11*G11","v":0},{"$f":"H11*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of first bill"]
[null,null,"kWh",0,{"$f":"IF($A11>0,MAX(+$A12-$A11-MAX('1 Data'!$B$10-1-$A11,0)-MAX($A12-'1 Data'!$B$11,0),0)*$D12/($A12-$A11),0)","v":0},{"$f":"E12*VLOOKUP(C12,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,{"$f":"+F12*G12","v":0},{"$f":"H12*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of second bill"]
[null,null,"kWh",0,{"$f":"IF($A12>0,MAX(+$A13-$A12-MAX('1 Data'!$B$10-1-$A12,0)-MAX($A13-'1 Data'!$B$11,0),0)*$D13/($A13-$A12),0)","v":0},{"$f":"E13*VLOOKUP(C13,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H13*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of third bill"]
[null,null,"kWh",0,{"$f":"IF($A13>0,MAX(+$A14-$A13-MAX('1 Data'!$B$10-1-$A13,0)-MAX($A14-'1 Data'!$B$11,0),0)*$D14/($A14-$A13),0)","v":0},{"$f":"E14*VLOOKUP(C14,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H14*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}," etc."]
[null,null,"kWh",0,{"$f":"IF($A14>0,MAX(+$A15-$A14-MAX('1 Data'!$B$10-1-$A14,0)-MAX($A15-'1 Data'!$B$11,0),0)*$D15/($A15-$A14),0)","v":0},{"$f":"E15*VLOOKUP(C15,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H15*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A15>0,MAX(+$A16-$A15-MAX('1 Data'!$B$10-1-$A15,0)-MAX($A16-'1 Data'!$B$11,0),0)*$D16/($A16-$A15),0)","v":0},{"$f":"E16*VLOOKUP(C16,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H16*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A16>0,MAX(+$A17-$A16-MAX('1 Data'!$B$10-1-$A16,0)-MAX($A17-'1 Data'!$B$11,0),0)*$D17/($A17-$A16),0)","v":0},{"$f":"E17*VLOOKUP(C17,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H17*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A17>0,MAX(+$A18-$A17-MAX('1 Data'!$B$10-1-$A17,0)-MAX($A18-'1 Data'!$B$11,0),0)*$D18/($A18-$A17),0)","v":0},{"$f":"E18*VLOOKUP(C18,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H18*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A18>0,MAX(+$A19-$A18-MAX('1 Data'!$B$10-1-$A18,0)-MAX($A19-'1 Data'!$B$11,0),0)*$D19/($A19-$A18),0)","v":0},{"$f":"E19*VLOOKUP(C19,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H19*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A19>0,MAX(+$A20-$A19-MAX('1 Data'!$B$10-1-$A19,0)-MAX($A20-'1 Data'!$B$11,0),0)*$D20/($A20-$A19),0)","v":0},{"$f":"E20*VLOOKUP(C20,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H20*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A20>0,MAX(+$A21-$A20-MAX('1 Data'!$B$10-1-$A20,0)-MAX($A21-'1 Data'!$B$11,0),0)*$D21/($A21-$A20),0)","v":0},{"$f":"E21*VLOOKUP(C21,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H21*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A21>0,MAX(+$A22-$A21-MAX('1 Data'!$B$10-1-$A21,0)-MAX($A22-'1 Data'!$B$11,0),0)*$D22/($A22-$A21),0)","v":0},{"$f":"E22*VLOOKUP(C22,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H22*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A22>0,MAX(+$A23-$A22-MAX('1 Data'!$B$10-1-$A22,0)-MAX($A23-'1 Data'!$B$11,0),0)*$D23/($A23-$A22),0)","v":0},{"$f":"E23*VLOOKUP(C23,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H23*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A23>0,MAX(+$A24-$A23-MAX('1 Data'!$B$10-1-$A23,0)-MAX($A24-'1 Data'!$B$11,0),0)*$D24/($A24-$A23),0)","v":0},{"$f":"E24*VLOOKUP(C24,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H24*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,"kWh",0,{"$f":"IF($A24>0,MAX(+$A25-$A24-MAX('1 Data'!$B$10-1-$A24,0)-MAX($A25-'1 Data'!$B$11,0),0)*$D25/($A25-$A24),0)","v":0},{"$f":"E25*VLOOKUP(C25,'Factors (to hide)'!A:B,2,FALSE)","v":0},1,0,{"$f":"H25*VLOOKUP(\"Natural Gas\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]

{"sheet":"5 Gas Est","index":8,"n_rows":29,"n_cols":7,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Gas Estimations"]
[]
["This sheet is used to estimate gas used for heating.  This is needed if you don't have gas bills or use a shared space that is heated."]
[]
[]
["Total for period",{"$f":"MAX(B21:C21)","v":51.035543999999994},"CO2e kg"]
[null,"Area method","Power method"]
["Workspace size",70,null,"Estimate at 70 sq feet per person in absence of any information"]
["Size units","Sq feet"]
["Insulation factor","average"]
["Heating system power (kW)"]
["Hours heated per day"]
["Days heated per week"]
["Weeks heated per year"]
["Other factors",1,1]
["Percentage share",0.25,1]
["Calculated kWh for period",{"$f":"'Factors (to hide)'!$B68*B10*IF(B11=\"Sq feet\",0.0929,1)*VLOOKUP(B12,$A$25:$B$29,2,FALSE)*B17*B18","v":243.86249999999998},{"$f":"+C13*C14*C15*C16*C17*C18","v":0}]
["Fuel used","Natural Gas","Natural Gas","Higher figure"]
["CO2e for period",{"$f":"VLOOKUP(B20,'Factors (to hide)'!$A:$B,2,FALSE)*B19","v":51.035543999999994},{"$f":"VLOOKUP(C20,'Factors (to hide)'!$A:$B,2,FALSE)*C19","v":0},{"$f":"MAX(B21:C21)","v":51.035543999999994}]
[]
[]
["Insulation factors:"]
["very poor",1.5]
["poor",1.25]
["average",1]
["good",0.75]
["very good",0.5]

{"sheet":"6 Public Trans","index":9,"n_rows":94,"n_cols":7,"rows_kept":94,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Public transport (not regular commuting)"]
[]
["Record here any public transport use that is not regular commuting"]
[]
[null,null,"Total Air Travel",null,{"$f":"+SUMIFS($E$11:$E$94,$C$11:$C$94,\"*air*\")","v":0}]
[null,null,"Total Non-Air Travel",null,{"$f":"+E9-E7","v":0}]
["Total for period",null,null,{"$f":"SUM(D11:D94)","v":0},{"$f":"SUM(E11:E94)","v":0}]
["Date","Description","Transport type","Distance (miles)","CO2e"]
[null,null,null,null,{"$f":"IF(AND(A11>='1 Data'!$B$10,A11<='1 Data'!$B$11),IF(C11<>\"\",VLOOKUP(C11,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D11,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A12>='1 Data'!$B$10,A12<='1 Data'!$B$11),IF(C12<>\"\",VLOOKUP(C12,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D12,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A13>='1 Data'!$B$10,A13<='1 Data'!$B$11),IF(C13<>\"\",VLOOKUP(C13,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D13,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A14>='1 Data'!$B$10,A14<='1 Data'!$B$11),IF(C14<>\"\",VLOOKUP(C14,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D14,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A15>='1 Data'!$B$10,A15<='1 Data'!$B$11),IF(C15<>\"\",VLOOKUP(C15,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D15,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A16>='1 Data'!$B$10,A16<='1 Data'!$B$11),IF(C16<>\"\",VLOOKUP(C16,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D16,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A17>='1 Data'!$B$10,A17<='1 Data'!$B$11),IF(C17<>\"\",VLOOKUP(C17,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D17,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A18>='1 Data'!$B$10,A18<='1 Data'!$B$11),IF(C18<>\"\",VLOOKUP(C18,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D18,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A19>='1 Data'!$B$10,A19<='1 Data'!$B$11),IF(C19<>\"\",VLOOKUP(C19,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D19,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A20>='1 Data'!$B$10,A20<='1 Data'!$B$11),IF(C20<>\"\",VLOOKUP(C20,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D20,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A21>='1 Data'!$B$10,A21<='1 Data'!$B$11),IF(C21<>\"\",VLOOKUP(C21,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D21,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A22>='1 Data'!$B$10,A22<='1 Data'!$B$11),IF(C22<>\"\",VLOOKUP(C22,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D22,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A23>='1 Data'!$B$10,A23<='1 Data'!$B$11),IF(C23<>\"\",VLOOKUP(C23,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D23,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A24>='1 Data'!$B$10,A24<='1 Data'!$B$11),IF(C24<>\"\",VLOOKUP(C24,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D24,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A25>='1 Data'!$B$10,A25<='1 Data'!$B$11),IF(C25<>\"\",VLOOKUP(C25,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D25,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A26>='1 Data'!$B$10,A26<='1 Data'!$B$11),IF(C26<>\"\",VLOOKUP(C26,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D26,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A27>='1 Data'!$B$10,A27<='1 Data'!$B$11),IF(C27<>\"\",VLOOKUP(C27,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D27,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A28>='1 Data'!$B$10,A28<='1 Data'!$B$11),IF(C28<>\"\",VLOOKUP(C28,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D28,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A29>='1 Data'!$B$10,A29<='1 Data'!$B$11),IF(C29<>\"\",VLOOKUP(C29,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D29,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A30>='1 Data'!$B$10,A30<='1 Data'!$B$11),IF(C30<>\"\",VLOOKUP(C30,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D30,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A31>='1 Data'!$B$10,A31<='1 Data'!$B$11),IF(C31<>\"\",VLOOKUP(C31,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D31,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A32>='1 Data'!$B$10,A32<='1 Data'!$B$11),IF(C32<>\"\",VLOOKUP(C32,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D32,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A33>='1 Data'!$B$10,A33<='1 Data'!$B$11),IF(C33<>\"\",VLOOKUP(C33,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D33,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A34>='1 Data'!$B$10,A34<='1 Data'!$B$11),IF(C34<>\"\",VLOOKUP(C34,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D34,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A35>='1 Data'!$B$10,A35<='1 Data'!$B$11),IF(C35<>\"\",VLOOKUP(C35,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D35,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A36>='1 Data'!$B$10,A36<='1 Data'!$B$11),IF(C36<>\"\",VLOOKUP(C36,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D36,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A37>='1 Data'!$B$10,A37<='1 Data'!$B$11),IF(C37<>\"\",VLOOKUP(C37,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D37,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A38>='1 Data'!$B$10,A38<='1 Data'!$B$11),IF(C38<>\"\",VLOOKUP(C38,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D38,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A39>='1 Data'!$B$10,A39<='1 Data'!$B$11),IF(C39<>\"\",VLOOKUP(C39,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D39,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A40>='1 Data'!$B$10,A40<='1 Data'!$B$11),IF(C40<>\"\",VLOOKUP(C40,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D40,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A41>='1 Data'!$B$10,A41<='1 Data'!$B$11),IF(C41<>\"\",VLOOKUP(C41,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D41,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A42>='1 Data'!$B$10,A42<='1 Data'!$B$11),IF(C42<>\"\",VLOOKUP(C42,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D42,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A43>='1 Data'!$B$10,A43<='1 Data'!$B$11),IF(C43<>\"\",VLOOKUP(C43,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D43,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A44>='1 Data'!$B$10,A44<='1 Data'!$B$11),IF(C44<>\"\",VLOOKUP(C44,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D44,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A45>='1 Data'!$B$10,A45<='1 Data'!$B$11),IF(C45<>\"\",VLOOKUP(C45,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D45,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A46>='1 Data'!$B$10,A46<='1 Data'!$B$11),IF(C46<>\"\",VLOOKUP(C46,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D46,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A47>='1 Data'!$B$10,A47<='1 Data'!$B$11),IF(C47<>\"\",VLOOKUP(C47,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D47,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A48>='1 Data'!$B$10,A48<='1 Data'!$B$11),IF(C48<>\"\",VLOOKUP(C48,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D48,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A49>='1 Data'!$B$10,A49<='1 Data'!$B$11),IF(C49<>\"\",VLOOKUP(C49,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D49,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A50>='1 Data'!$B$10,A50<='1 Data'!$B$11),IF(C50<>\"\",VLOOKUP(C50,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D50,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A51>='1 Data'!$B$10,A51<='1 Data'!$B$11),IF(C51<>\"\",VLOOKUP(C51,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D51,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A52>='1 Data'!$B$10,A52<='1 Data'!$B$11),IF(C52<>\"\",VLOOKUP(C52,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D52,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A53>='1 Data'!$B$10,A53<='1 Data'!$B$11),IF(C53<>\"\",VLOOKUP(C53,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D53,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A54>='1 Data'!$B$10,A54<='1 Data'!$B$11),IF(C54<>\"\",VLOOKUP(C54,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D54,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A55>='1 Data'!$B$10,A55<='1 Data'!$B$11),IF(C55<>\"\",VLOOKUP(C55,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D55,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A56>='1 Data'!$B$10,A56<='1 Data'!$B$11),IF(C56<>\"\",VLOOKUP(C56,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D56,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A57>='1 Data'!$B$10,A57<='1 Data'!$B$11),IF(C57<>\"\",VLOOKUP(C57,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D57,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A58>='1 Data'!$B$10,A58<='1 Data'!$B$11),IF(C58<>\"\",VLOOKUP(C58,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D58,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A59>='1 Data'!$B$10,A59<='1 Data'!$B$11),IF(C59<>\"\",VLOOKUP(C59,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D59,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A60>='1 Data'!$B$10,A60<='1 Data'!$B$11),IF(C60<>\"\",VLOOKUP(C60,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D60,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A61>='1 Data'!$B$10,A61<='1 Data'!$B$11),IF(C61<>\"\",VLOOKUP(C61,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D61,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A62>='1 Data'!$B$10,A62<='1 Data'!$B$11),IF(C62<>\"\",VLOOKUP(C62,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D62,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A63>='1 Data'!$B$10,A63<='1 Data'!$B$11),IF(C63<>\"\",VLOOKUP(C63,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D63,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A64>='1 Data'!$B$10,A64<='1 Data'!$B$11),IF(C64<>\"\",VLOOKUP(C64,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D64,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A65>='1 Data'!$B$10,A65<='1 Data'!$B$11),IF(C65<>\"\",VLOOKUP(C65,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D65,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A66>='1 Data'!$B$10,A66<='1 Data'!$B$11),IF(C66<>\"\",VLOOKUP(C66,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D66,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A67>='1 Data'!$B$10,A67<='1 Data'!$B$11),IF(C67<>\"\",VLOOKUP(C67,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D67,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A68>='1 Data'!$B$10,A68<='1 Data'!$B$11),IF(C68<>\"\",VLOOKUP(C68,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D68,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A69>='1 Data'!$B$10,A69<='1 Data'!$B$11),IF(C69<>\"\",VLOOKUP(C69,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D69,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A70>='1 Data'!$B$10,A70<='1 Data'!$B$11),IF(C70<>\"\",VLOOKUP(C70,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D70,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A71>='1 Data'!$B$10,A71<='1 Data'!$B$11),IF(C71<>\"\",VLOOKUP(C71,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D71,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A72>='1 Data'!$B$10,A72<='1 Data'!$B$11),IF(C72<>\"\",VLOOKUP(C72,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D72,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A73>='1 Data'!$B$10,A73<='1 Data'!$B$11),IF(C73<>\"\",VLOOKUP(C73,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D73,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A74>='1 Data'!$B$10,A74<='1 Data'!$B$11),IF(C74<>\"\",VLOOKUP(C74,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D74,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A75>='1 Data'!$B$10,A75<='1 Data'!$B$11),IF(C75<>\"\",VLOOKUP(C75,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D75,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A76>='1 Data'!$B$10,A76<='1 Data'!$B$11),IF(C76<>\"\",VLOOKUP(C76,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D76,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A77>='1 Data'!$B$10,A77<='1 Data'!$B$11),IF(C77<>\"\",VLOOKUP(C77,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D77,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A78>='1 Data'!$B$10,A78<='1 Data'!$B$11),IF(C78<>\"\",VLOOKUP(C78,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D78,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A79>='1 Data'!$B$10,A79<='1 Data'!$B$11),IF(C79<>\"\",VLOOKUP(C79,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D79,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A80>='1 Data'!$B$10,A80<='1 Data'!$B$11),IF(C80<>\"\",VLOOKUP(C80,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D80,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A81>='1 Data'!$B$10,A81<='1 Data'!$B$11),IF(C81<>\"\",VLOOKUP(C81,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D81,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A82>='1 Data'!$B$10,A82<='1 Data'!$B$11),IF(C82<>\"\",VLOOKUP(C82,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D82,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A83>='1 Data'!$B$10,A83<='1 Data'!$B$11),IF(C83<>\"\",VLOOKUP(C83,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D83,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A84>='1 Data'!$B$10,A84<='1 Data'!$B$11),IF(C84<>\"\",VLOOKUP(C84,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D84,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A85>='1 Data'!$B$10,A85<='1 Data'!$B$11),IF(C85<>\"\",VLOOKUP(C85,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D85,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A86>='1 Data'!$B$10,A86<='1 Data'!$B$11),IF(C86<>\"\",VLOOKUP(C86,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D86,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A87>='1 Data'!$B$10,A87<='1 Data'!$B$11),IF(C87<>\"\",VLOOKUP(C87,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D87,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A88>='1 Data'!$B$10,A88<='1 Data'!$B$11),IF(C88<>\"\",VLOOKUP(C88,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D88,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A89>='1 Data'!$B$10,A89<='1 Data'!$B$11),IF(C89<>\"\",VLOOKUP(C89,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D89,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A90>='1 Data'!$B$10,A90<='1 Data'!$B$11),IF(C90<>\"\",VLOOKUP(C90,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D90,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A91>='1 Data'!$B$10,A91<='1 Data'!$B$11),IF(C91<>\"\",VLOOKUP(C91,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D91,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A92>='1 Data'!$B$10,A92<='1 Data'!$B$11),IF(C92<>\"\",VLOOKUP(C92,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D92,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A93>='1 Data'!$B$10,A93<='1 Data'!$B$11),IF(C93<>\"\",VLOOKUP(C93,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D93,\"\"),\"\")","v":""}]
[null,null,null,null,{"$f":"IF(AND(A94>='1 Data'!$B$10,A94<='1 Data'!$B$11),IF(C94<>\"\",VLOOKUP(C94,'Factors (to hide)'!A:B,2,FALSE)*'Factors (to hide)'!$B$60*'6 Public Trans'!D94,\"\"),\"\")","v":""}]

{"sheet":"7 Car and Van","index":10,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Car and Van (excluding regular commuting)"]
[]
["Each car or van used must be listed on the Data tab, otherwise an error will occur in column E"]
[]
[]
["Total for period",null,null,{"$f":"SUM(D10:D100)","v":0},{"$f":"SUM(E10:E100)","v":0}]
["Date","Description","Car or Van used","Distance (miles)","CO2e"]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A10>='1 Data'!$B$10,A10<='1 Data'!$B$11),IF(C10<>\"\",VLOOKUP(C10,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D10*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C10,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A11>='1 Data'!$B$10,A11<='1 Data'!$B$11),IF(C11<>\"\",VLOOKUP(C11,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D11*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C11,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A12>='1 Data'!$B$10,A12<='1 Data'!$B$11),IF(C12<>\"\",VLOOKUP(C12,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D12*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C12,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A13>='1 Data'!$B$10,A13<='1 Data'!$B$11),IF(C13<>\"\",VLOOKUP(C13,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D13*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C13,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A14>='1 Data'!$B$10,A14<='1 Data'!$B$11),IF(C14<>\"\",VLOOKUP(C14,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D14*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C14,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A15>='1 Data'!$B$10,A15<='1 Data'!$B$11),IF(C15<>\"\",VLOOKUP(C15,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D15*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C15,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A16>='1 Data'!$B$10,A16<='1 Data'!$B$11),IF(C16<>\"\",VLOOKUP(C16,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D16*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C16,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A17>='1 Data'!$B$10,A17<='1 Data'!$B$11),IF(C17<>\"\",VLOOKUP(C17,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D17*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C17,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A18>='1 Data'!$B$10,A18<='1 Data'!$B$11),IF(C18<>\"\",VLOOKUP(C18,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D18*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C18,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A19>='1 Data'!$B$10,A19<='1 Data'!$B$11),IF(C19<>\"\",VLOOKUP(C19,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D19*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C19,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A20>='1 Data'!$B$10,A20<='1 Data'!$B$11),IF(C20<>\"\",VLOOKUP(C20,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D20*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C20,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A21>='1 Data'!$B$10,A21<='1 Data'!$B$11),IF(C21<>\"\",VLOOKUP(C21,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D21*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C21,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A22>='1 Data'!$B$10,A22<='1 Data'!$B$11),IF(C22<>\"\",VLOOKUP(C22,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D22*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C22,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A23>='1 Data'!$B$10,A23<='1 Data'!$B$11),IF(C23<>\"\",VLOOKUP(C23,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D23*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C23,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A24>='1 Data'!$B$10,A24<='1 Data'!$B$11),IF(C24<>\"\",VLOOKUP(C24,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D24*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C24,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A25>='1 Data'!$B$10,A25<='1 Data'!$B$11),IF(C25<>\"\",VLOOKUP(C25,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D25*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C25,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A26>='1 Data'!$B$10,A26<='1 Data'!$B$11),IF(C26<>\"\",VLOOKUP(C26,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D26*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C26,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A27>='1 Data'!$B$10,A27<='1 Data'!$B$11),IF(C27<>\"\",VLOOKUP(C27,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D27*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C27,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A28>='1 Data'!$B$10,A28<='1 Data'!$B$11),IF(C28<>\"\",VLOOKUP(C28,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D28*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C28,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A29>='1 Data'!$B$10,A29<='1 Data'!$B$11),IF(C29<>\"\",VLOOKUP(C29,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D29*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C29,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A30>='1 Data'!$B$10,A30<='1 Data'!$B$11),IF(C30<>\"\",VLOOKUP(C30,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D30*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C30,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A31>='1 Data'!$B$10,A31<='1 Data'!$B$11),IF(C31<>\"\",VLOOKUP(C31,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D31*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C31,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A32>='1 Data'!$B$10,A32<='1 Data'!$B$11),IF(C32<>\"\",VLOOKUP(C32,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D32*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C32,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A33>='1 Data'!$B$10,A33<='1 Data'!$B$11),IF(C33<>\"\",VLOOKUP(C33,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D33*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C33,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A34>='1 Data'!$B$10,A34<='1 Data'!$B$11),IF(C34<>\"\",VLOOKUP(C34,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D34*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C34,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A35>='1 Data'!$B$10,A35<='1 Data'!$B$11),IF(C35<>\"\",VLOOKUP(C35,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D35*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C35,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A36>='1 Data'!$B$10,A36<='1 Data'!$B$11),IF(C36<>\"\",VLOOKUP(C36,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D36*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C36,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A37>='1 Data'!$B$10,A37<='1 Data'!$B$11),IF(C37<>\"\",VLOOKUP(C37,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D37*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C37,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A38>='1 Data'!$B$10,A38<='1 Data'!$B$11),IF(C38<>\"\",VLOOKUP(C38,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D38*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C38,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A39>='1 Data'!$B$10,A39<='1 Data'!$B$11),IF(C39<>\"\",VLOOKUP(C39,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D39*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C39,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A40>='1 Data'!$B$10,A40<='1 Data'!$B$11),IF(C40<>\"\",VLOOKUP(C40,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D40*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C40,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A41>='1 Data'!$B$10,A41<='1 Data'!$B$11),IF(C41<>\"\",VLOOKUP(C41,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D41*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C41,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A42>='1 Data'!$B$10,A42<='1 Data'!$B$11),IF(C42<>\"\",VLOOKUP(C42,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D42*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C42,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A43>='1 Data'!$B$10,A43<='1 Data'!$B$11),IF(C43<>\"\",VLOOKUP(C43,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D43*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C43,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A44>='1 Data'!$B$10,A44<='1 Data'!$B$11),IF(C44<>\"\",VLOOKUP(C44,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D44*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C44,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A45>='1 Data'!$B$10,A45<='1 Data'!$B$11),IF(C45<>\"\",VLOOKUP(C45,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D45*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C45,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A46>='1 Data'!$B$10,A46<='1 Data'!$B$11),IF(C46<>\"\",VLOOKUP(C46,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D46*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C46,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A47>='1 Data'!$B$10,A47<='1 Data'!$B$11),IF(C47<>\"\",VLOOKUP(C47,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D47*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C47,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A48>='1 Data'!$B$10,A48<='1 Data'!$B$11),IF(C48<>\"\",VLOOKUP(C48,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D48*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C48,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A49>='1 Data'!$B$10,A49<='1 Data'!$B$11),IF(C49<>\"\",VLOOKUP(C49,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D49*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C49,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A50>='1 Data'!$B$10,A50<='1 Data'!$B$11),IF(C50<>\"\",VLOOKUP(C50,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D50*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C50,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A51>='1 Data'!$B$10,A51<='1 Data'!$B$11),IF(C51<>\"\",VLOOKUP(C51,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D51*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C51,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A52>='1 Data'!$B$10,A52<='1 Data'!$B$11),IF(C52<>\"\",VLOOKUP(C52,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D52*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C52,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A53>='1 Data'!$B$10,A53<='1 Data'!$B$11),IF(C53<>\"\",VLOOKUP(C53,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D53*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C53,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A54>='1 Data'!$B$10,A54<='1 Data'!$B$11),IF(C54<>\"\",VLOOKUP(C54,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D54*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C54,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A55>='1 Data'!$B$10,A55<='1 Data'!$B$11),IF(C55<>\"\",VLOOKUP(C55,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D55*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C55,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A56>='1 Data'!$B$10,A56<='1 Data'!$B$11),IF(C56<>\"\",VLOOKUP(C56,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D56*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C56,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A57>='1 Data'!$B$10,A57<='1 Data'!$B$11),IF(C57<>\"\",VLOOKUP(C57,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D57*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C57,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A58>='1 Data'!$B$10,A58<='1 Data'!$B$11),IF(C58<>\"\",VLOOKUP(C58,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D58*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C58,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A59>='1 Data'!$B$10,A59<='1 Data'!$B$11),IF(C59<>\"\",VLOOKUP(C59,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D59*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C59,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A60>='1 Data'!$B$10,A60<='1 Data'!$B$11),IF(C60<>\"\",VLOOKUP(C60,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D60*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C60,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A61>='1 Data'!$B$10,A61<='1 Data'!$B$11),IF(C61<>\"\",VLOOKUP(C61,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D61*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C61,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A62>='1 Data'!$B$10,A62<='1 Data'!$B$11),IF(C62<>\"\",VLOOKUP(C62,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D62*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C62,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A63>='1 Data'!$B$10,A63<='1 Data'!$B$11),IF(C63<>\"\",VLOOKUP(C63,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D63*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C63,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A64>='1 Data'!$B$10,A64<='1 Data'!$B$11),IF(C64<>\"\",VLOOKUP(C64,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D64*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C64,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A65>='1 Data'!$B$10,A65<='1 Data'!$B$11),IF(C65<>\"\",VLOOKUP(C65,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D65*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C65,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A66>='1 Data'!$B$10,A66<='1 Data'!$B$11),IF(C66<>\"\",VLOOKUP(C66,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D66*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C66,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A67>='1 Data'!$B$10,A67<='1 Data'!$B$11),IF(C67<>\"\",VLOOKUP(C67,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D67*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C67,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A68>='1 Data'!$B$10,A68<='1 Data'!$B$11),IF(C68<>\"\",VLOOKUP(C68,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D68*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C68,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A69>='1 Data'!$B$10,A69<='1 Data'!$B$11),IF(C69<>\"\",VLOOKUP(C69,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D69*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C69,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A70>='1 Data'!$B$10,A70<='1 Data'!$B$11),IF(C70<>\"\",VLOOKUP(C70,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D70*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C70,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A71>='1 Data'!$B$10,A71<='1 Data'!$B$11),IF(C71<>\"\",VLOOKUP(C71,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D71*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C71,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A72>='1 Data'!$B$10,A72<='1 Data'!$B$11),IF(C72<>\"\",VLOOKUP(C72,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D72*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C72,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A73>='1 Data'!$B$10,A73<='1 Data'!$B$11),IF(C73<>\"\",VLOOKUP(C73,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D73*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C73,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A74>='1 Data'!$B$10,A74<='1 Data'!$B$11),IF(C74<>\"\",VLOOKUP(C74,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D74*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C74,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A75>='1 Data'!$B$10,A75<='1 Data'!$B$11),IF(C75<>\"\",VLOOKUP(C75,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D75*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C75,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A76>='1 Data'!$B$10,A76<='1 Data'!$B$11),IF(C76<>\"\",VLOOKUP(C76,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D76*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C76,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A77>='1 Data'!$B$10,A77<='1 Data'!$B$11),IF(C77<>\"\",VLOOKUP(C77,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D77*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C77,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A78>='1 Data'!$B$10,A78<='1 Data'!$B$11),IF(C78<>\"\",VLOOKUP(C78,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D78*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C78,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A79>='1 Data'!$B$10,A79<='1 Data'!$B$11),IF(C79<>\"\",VLOOKUP(C79,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D79*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C79,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A80>='1 Data'!$B$10,A80<='1 Data'!$B$11),IF(C80<>\"\",VLOOKUP(C80,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D80*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C80,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A81>='1 Data'!$B$10,A81<='1 Data'!$B$11),IF(C81<>\"\",VLOOKUP(C81,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D81*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C81,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A82>='1 Data'!$B$10,A82<='1 Data'!$B$11),IF(C82<>\"\",VLOOKUP(C82,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D82*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C82,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A83>='1 Data'!$B$10,A83<='1 Data'!$B$11),IF(C83<>\"\",VLOOKUP(C83,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D83*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C83,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A84>='1 Data'!$B$10,A84<='1 Data'!$B$11),IF(C84<>\"\",VLOOKUP(C84,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D84*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C84,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A85>='1 Data'!$B$10,A85<='1 Data'!$B$11),IF(C85<>\"\",VLOOKUP(C85,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D85*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C85,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A86>='1 Data'!$B$10,A86<='1 Data'!$B$11),IF(C86<>\"\",VLOOKUP(C86,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D86*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C86,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A87>='1 Data'!$B$10,A87<='1 Data'!$B$11),IF(C87<>\"\",VLOOKUP(C87,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D87*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C87,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A88>='1 Data'!$B$10,A88<='1 Data'!$B$11),IF(C88<>\"\",VLOOKUP(C88,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D88*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C88,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A89>='1 Data'!$B$10,A89<='1 Data'!$B$11),IF(C89<>\"\",VLOOKUP(C89,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D89*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C89,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A90>='1 Data'!$B$10,A90<='1 Data'!$B$11),IF(C90<>\"\",VLOOKUP(C90,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D90*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C90,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A91>='1 Data'!$B$10,A91<='1 Data'!$B$11),IF(C91<>\"\",VLOOKUP(C91,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D91*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C91,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A92>='1 Data'!$B$10,A92<='1 Data'!$B$11),IF(C92<>\"\",VLOOKUP(C92,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D92*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C92,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A93>='1 Data'!$B$10,A93<='1 Data'!$B$11),IF(C93<>\"\",VLOOKUP(C93,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D93*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C93,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A94>='1 Data'!$B$10,A94<='1 Data'!$B$11),IF(C94<>\"\",VLOOKUP(C94,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D94*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C94,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A95>='1 Data'!$B$10,A95<='1 Data'!$B$11),IF(C95<>\"\",VLOOKUP(C95,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D95*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C95,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A96>='1 Data'!$B$10,A96<='1 Data'!$B$11),IF(C96<>\"\",VLOOKUP(C96,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D96*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C96,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A97>='1 Data'!$B$10,A97<='1 Data'!$B$11),IF(C97<>\"\",VLOOKUP(C97,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D97*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C97,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A98>='1 Data'!$B$10,A98<='1 Data'!$B$11),IF(C98<>\"\",VLOOKUP(C98,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D98*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C98,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A99>='1 Data'!$B$10,A99<='1 Data'!$B$11),IF(C99<>\"\",VLOOKUP(C99,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D99*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C99,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]
[null,null,null,null,{"$f":"IFERROR(IF(AND(A100>='1 Data'!$B$10,A100<='1 Data'!$B$11),IF(C100<>\"\",VLOOKUP(C100,'1 Data'!$A$15:$C$415,2,FALSE)/1000*D100*'Factors (to hide)'!$B$60*(0.25+(1-VLOOKUP(C100,'1 Data'!$A$15:$C$35,3,FALSE))*0.75),\"\"),\"\"),0)","v":""}]

{"sheet":"8 Road Fuel","index":11,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Road fuel purchases for business use"]
[]
[]
[]
[]
["Total for period",null,null,null,{"$f":"SUM(E10:E100)","v":0},{"$f":"SUM(F10:F100)","v":0}]
["Date","Description","Type of fuel","£","Litres","CO2e"]
[null,null,null,null,{"$f":"+IFERROR(D10/VLOOKUP(A10,'Factors (to hide)'!$A$73:$F$82,MATCH(C10,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E10*(VLOOKUP(C10,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D11/VLOOKUP(A11,'Factors (to hide)'!$A$73:$F$82,MATCH(C11,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E11*(VLOOKUP(C11,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D12/VLOOKUP(A12,'Factors (to hide)'!$A$73:$F$82,MATCH(C12,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E12*(VLOOKUP(C12,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D13/VLOOKUP(A13,'Factors (to hide)'!$A$73:$F$82,MATCH(C13,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E13*(VLOOKUP(C13,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D14/VLOOKUP(A14,'Factors (to hide)'!$A$73:$F$82,MATCH(C14,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E14*(VLOOKUP(C14,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D15/VLOOKUP(A15,'Factors (to hide)'!$A$73:$F$82,MATCH(C15,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E15*(VLOOKUP(C15,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D16/VLOOKUP(A16,'Factors (to hide)'!$A$73:$F$82,MATCH(C16,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E16*(VLOOKUP(C16,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D17/VLOOKUP(A17,'Factors (to hide)'!$A$73:$F$82,MATCH(C17,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E17*(VLOOKUP(C17,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D18/VLOOKUP(A18,'Factors (to hide)'!$A$73:$F$82,MATCH(C18,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E18*(VLOOKUP(C18,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D19/VLOOKUP(A19,'Factors (to hide)'!$A$73:$F$82,MATCH(C19,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E19*(VLOOKUP(C19,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D20/VLOOKUP(A20,'Factors (to hide)'!$A$73:$F$82,MATCH(C20,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E20*(VLOOKUP(C20,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D21/VLOOKUP(A21,'Factors (to hide)'!$A$73:$F$82,MATCH(C21,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E21*(VLOOKUP(C21,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D22/VLOOKUP(A22,'Factors (to hide)'!$A$73:$F$82,MATCH(C22,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E22*(VLOOKUP(C22,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D23/VLOOKUP(A23,'Factors (to hide)'!$A$73:$F$82,MATCH(C23,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E23*(VLOOKUP(C23,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D24/VLOOKUP(A24,'Factors (to hide)'!$A$73:$F$82,MATCH(C24,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E24*(VLOOKUP(C24,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D25/VLOOKUP(A25,'Factors (to hide)'!$A$73:$F$82,MATCH(C25,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E25*(VLOOKUP(C25,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D26/VLOOKUP(A26,'Factors (to hide)'!$A$73:$F$82,MATCH(C26,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E26*(VLOOKUP(C26,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D27/VLOOKUP(A27,'Factors (to hide)'!$A$73:$F$82,MATCH(C27,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E27*(VLOOKUP(C27,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D28/VLOOKUP(A28,'Factors (to hide)'!$A$73:$F$82,MATCH(C28,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E28*(VLOOKUP(C28,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D29/VLOOKUP(A29,'Factors (to hide)'!$A$73:$F$82,MATCH(C29,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E29*(VLOOKUP(C29,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D30/VLOOKUP(A30,'Factors (to hide)'!$A$73:$F$82,MATCH(C30,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E30*(VLOOKUP(C30,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D31/VLOOKUP(A31,'Factors (to hide)'!$A$73:$F$82,MATCH(C31,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E31*(VLOOKUP(C31,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D32/VLOOKUP(A32,'Factors (to hide)'!$A$73:$F$82,MATCH(C32,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E32*(VLOOKUP(C32,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D33/VLOOKUP(A33,'Factors (to hide)'!$A$73:$F$82,MATCH(C33,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E33*(VLOOKUP(C33,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D34/VLOOKUP(A34,'Factors (to hide)'!$A$73:$F$82,MATCH(C34,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E34*(VLOOKUP(C34,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D35/VLOOKUP(A35,'Factors (to hide)'!$A$73:$F$82,MATCH(C35,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E35*(VLOOKUP(C35,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D36/VLOOKUP(A36,'Factors (to hide)'!$A$73:$F$82,MATCH(C36,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E36*(VLOOKUP(C36,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D37/VLOOKUP(A37,'Factors (to hide)'!$A$73:$F$82,MATCH(C37,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E37*(VLOOKUP(C37,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D38/VLOOKUP(A38,'Factors (to hide)'!$A$73:$F$82,MATCH(C38,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E38*(VLOOKUP(C38,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D39/VLOOKUP(A39,'Factors (to hide)'!$A$73:$F$82,MATCH(C39,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E39*(VLOOKUP(C39,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D40/VLOOKUP(A40,'Factors (to hide)'!$A$73:$F$82,MATCH(C40,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E40*(VLOOKUP(C40,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D41/VLOOKUP(A41,'Factors (to hide)'!$A$73:$F$82,MATCH(C41,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E41*(VLOOKUP(C41,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D42/VLOOKUP(A42,'Factors (to hide)'!$A$73:$F$82,MATCH(C42,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E42*(VLOOKUP(C42,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D43/VLOOKUP(A43,'Factors (to hide)'!$A$73:$F$82,MATCH(C43,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E43*(VLOOKUP(C43,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D44/VLOOKUP(A44,'Factors (to hide)'!$A$73:$F$82,MATCH(C44,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E44*(VLOOKUP(C44,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D45/VLOOKUP(A45,'Factors (to hide)'!$A$73:$F$82,MATCH(C45,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E45*(VLOOKUP(C45,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D46/VLOOKUP(A46,'Factors (to hide)'!$A$73:$F$82,MATCH(C46,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E46*(VLOOKUP(C46,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D47/VLOOKUP(A47,'Factors (to hide)'!$A$73:$F$82,MATCH(C47,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E47*(VLOOKUP(C47,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D48/VLOOKUP(A48,'Factors (to hide)'!$A$73:$F$82,MATCH(C48,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E48*(VLOOKUP(C48,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D49/VLOOKUP(A49,'Factors (to hide)'!$A$73:$F$82,MATCH(C49,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E49*(VLOOKUP(C49,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D50/VLOOKUP(A50,'Factors (to hide)'!$A$73:$F$82,MATCH(C50,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E50*(VLOOKUP(C50,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D51/VLOOKUP(A51,'Factors (to hide)'!$A$73:$F$82,MATCH(C51,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E51*(VLOOKUP(C51,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D52/VLOOKUP(A52,'Factors (to hide)'!$A$73:$F$82,MATCH(C52,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E52*(VLOOKUP(C52,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D53/VLOOKUP(A53,'Factors (to hide)'!$A$73:$F$82,MATCH(C53,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E53*(VLOOKUP(C53,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D54/VLOOKUP(A54,'Factors (to hide)'!$A$73:$F$82,MATCH(C54,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E54*(VLOOKUP(C54,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D55/VLOOKUP(A55,'Factors (to hide)'!$A$73:$F$82,MATCH(C55,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E55*(VLOOKUP(C55,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D56/VLOOKUP(A56,'Factors (to hide)'!$A$73:$F$82,MATCH(C56,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E56*(VLOOKUP(C56,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D57/VLOOKUP(A57,'Factors (to hide)'!$A$73:$F$82,MATCH(C57,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E57*(VLOOKUP(C57,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D58/VLOOKUP(A58,'Factors (to hide)'!$A$73:$F$82,MATCH(C58,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E58*(VLOOKUP(C58,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D59/VLOOKUP(A59,'Factors (to hide)'!$A$73:$F$82,MATCH(C59,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E59*(VLOOKUP(C59,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D60/VLOOKUP(A60,'Factors (to hide)'!$A$73:$F$82,MATCH(C60,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E60*(VLOOKUP(C60,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D61/VLOOKUP(A61,'Factors (to hide)'!$A$73:$F$82,MATCH(C61,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E61*(VLOOKUP(C61,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D62/VLOOKUP(A62,'Factors (to hide)'!$A$73:$F$82,MATCH(C62,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E62*(VLOOKUP(C62,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D63/VLOOKUP(A63,'Factors (to hide)'!$A$73:$F$82,MATCH(C63,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E63*(VLOOKUP(C63,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D64/VLOOKUP(A64,'Factors (to hide)'!$A$73:$F$82,MATCH(C64,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E64*(VLOOKUP(C64,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D65/VLOOKUP(A65,'Factors (to hide)'!$A$73:$F$82,MATCH(C65,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E65*(VLOOKUP(C65,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D66/VLOOKUP(A66,'Factors (to hide)'!$A$73:$F$82,MATCH(C66,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E66*(VLOOKUP(C66,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D67/VLOOKUP(A67,'Factors (to hide)'!$A$73:$F$82,MATCH(C67,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E67*(VLOOKUP(C67,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D68/VLOOKUP(A68,'Factors (to hide)'!$A$73:$F$82,MATCH(C68,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E68*(VLOOKUP(C68,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D69/VLOOKUP(A69,'Factors (to hide)'!$A$73:$F$82,MATCH(C69,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E69*(VLOOKUP(C69,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D70/VLOOKUP(A70,'Factors (to hide)'!$A$73:$F$82,MATCH(C70,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E70*(VLOOKUP(C70,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D71/VLOOKUP(A71,'Factors (to hide)'!$A$73:$F$82,MATCH(C71,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E71*(VLOOKUP(C71,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D72/VLOOKUP(A72,'Factors (to hide)'!$A$73:$F$82,MATCH(C72,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E72*(VLOOKUP(C72,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D73/VLOOKUP(A73,'Factors (to hide)'!$A$73:$F$82,MATCH(C73,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E73*(VLOOKUP(C73,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D74/VLOOKUP(A74,'Factors (to hide)'!$A$73:$F$82,MATCH(C74,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E74*(VLOOKUP(C74,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D75/VLOOKUP(A75,'Factors (to hide)'!$A$73:$F$82,MATCH(C75,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E75*(VLOOKUP(C75,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D76/VLOOKUP(A76,'Factors (to hide)'!$A$73:$F$82,MATCH(C76,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E76*(VLOOKUP(C76,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D77/VLOOKUP(A77,'Factors (to hide)'!$A$73:$F$82,MATCH(C77,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E77*(VLOOKUP(C77,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D78/VLOOKUP(A78,'Factors (to hide)'!$A$73:$F$82,MATCH(C78,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E78*(VLOOKUP(C78,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D79/VLOOKUP(A79,'Factors (to hide)'!$A$73:$F$82,MATCH(C79,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E79*(VLOOKUP(C79,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D80/VLOOKUP(A80,'Factors (to hide)'!$A$73:$F$82,MATCH(C80,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E80*(VLOOKUP(C80,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D81/VLOOKUP(A81,'Factors (to hide)'!$A$73:$F$82,MATCH(C81,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E81*(VLOOKUP(C81,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D82/VLOOKUP(A82,'Factors (to hide)'!$A$73:$F$82,MATCH(C82,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E82*(VLOOKUP(C82,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D83/VLOOKUP(A83,'Factors (to hide)'!$A$73:$F$82,MATCH(C83,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E83*(VLOOKUP(C83,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D84/VLOOKUP(A84,'Factors (to hide)'!$A$73:$F$82,MATCH(C84,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E84*(VLOOKUP(C84,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D85/VLOOKUP(A85,'Factors (to hide)'!$A$73:$F$82,MATCH(C85,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E85*(VLOOKUP(C85,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D86/VLOOKUP(A86,'Factors (to hide)'!$A$73:$F$82,MATCH(C86,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E86*(VLOOKUP(C86,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D87/VLOOKUP(A87,'Factors (to hide)'!$A$73:$F$82,MATCH(C87,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E87*(VLOOKUP(C87,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D88/VLOOKUP(A88,'Factors (to hide)'!$A$73:$F$82,MATCH(C88,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E88*(VLOOKUP(C88,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D89/VLOOKUP(A89,'Factors (to hide)'!$A$73:$F$82,MATCH(C89,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E89*(VLOOKUP(C89,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D90/VLOOKUP(A90,'Factors (to hide)'!$A$73:$F$82,MATCH(C90,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E90*(VLOOKUP(C90,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D91/VLOOKUP(A91,'Factors (to hide)'!$A$73:$F$82,MATCH(C91,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E91*(VLOOKUP(C91,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D92/VLOOKUP(A92,'Factors (to hide)'!$A$73:$F$82,MATCH(C92,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E92*(VLOOKUP(C92,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D93/VLOOKUP(A93,'Factors (to hide)'!$A$73:$F$82,MATCH(C93,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E93*(VLOOKUP(C93,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D94/VLOOKUP(A94,'Factors (to hide)'!$A$73:$F$82,MATCH(C94,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E94*(VLOOKUP(C94,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D95/VLOOKUP(A95,'Factors (to hide)'!$A$73:$F$82,MATCH(C95,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E95*(VLOOKUP(C95,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D96/VLOOKUP(A96,'Factors (to hide)'!$A$73:$F$82,MATCH(C96,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E96*(VLOOKUP(C96,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D97/VLOOKUP(A97,'Factors (to hide)'!$A$73:$F$82,MATCH(C97,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E97*(VLOOKUP(C97,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D98/VLOOKUP(A98,'Factors (to hide)'!$A$73:$F$82,MATCH(C98,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E98*(VLOOKUP(C98,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D99/VLOOKUP(A99,'Factors (to hide)'!$A$73:$F$82,MATCH(C99,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E99*(VLOOKUP(C99,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]
[null,null,null,null,{"$f":"+IFERROR(D100/VLOOKUP(A100,'Factors (to hide)'!$A$73:$F$82,MATCH(C100,'Factors (to hide)'!$B$71:$F$71,0)+1),0)","v":0},{"$f":"+IFERROR(E100*(VLOOKUP(C100,'Factors (to hide)'!A:B,2,FALSE)),\"\")","v":""}]

{"sheet":"9 Commute","index":12,"n_rows":31,"n_cols":10,"rows_kept":31,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Commuting and other regular journeys"]
[]
["Record regular journeys of all workers at your organisation."]
["If a worker uses more than one type of transport simply complete more than one row for that worker.  "]
[]
[null,null,null,null,null,null,"Total Air Travel",null,null,{"$f":"+SUMIFS(J12:J31,G12:G31,\"*air*\")","v":0}]
[null,null,null,null,null,null,"Total Non-Air Travel",null,null,{"$f":"+J10-J8","v":0}]
["Total for period",null,null,null,null,{"$f":"SUM(F12:F31)","v":0},null,null,null,{"$f":"SUM(J12:J31)","v":0}]
["Employee","Name (optional)","Commute distance (miles)","Days per week","Weeks in period","Distance per period (miles)","Transport Method","If car then car name","CO2 kg / km","CO2 kg / period"]
["Employee 1",null,null,null,null,{"$f":"+C12*D12*E12","v":0},null,null,{"$f":"IF(H12>0,IFERROR(VLOOKUP(H12,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G12,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F12*'Factors (to hide)'!$B$60*'9 Commute'!I12","v":0}]
["Employee 2",null,null,null,null,{"$f":"+C13*D13*E13","v":0},null,null,{"$f":"IF(H13>0,IFERROR(VLOOKUP(H13,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G13,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F13*'Factors (to hide)'!$B$60*'9 Commute'!I13","v":0}]
["Employee 3",null,null,null,null,0,null,null,{"$f":"IF(H14>0,IFERROR(VLOOKUP(H14,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G14,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F14*'Factors (to hide)'!$B$60*'9 Commute'!I14","v":0}]
["Employee 4",null,null,null,null,0,null,null,{"$f":"IF(H15>0,IFERROR(VLOOKUP(H15,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G15,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F15*'Factors (to hide)'!$B$60*'9 Commute'!I15","v":0}]
["Employee 5",null,null,null,null,0,null,null,{"$f":"IF(H16>0,IFERROR(VLOOKUP(H16,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G16,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F16*'Factors (to hide)'!$B$60*'9 Commute'!I16","v":0}]
["Employee 6",null,null,null,null,0,null,null,{"$f":"IF(H17>0,IFERROR(VLOOKUP(H17,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G17,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F17*'Factors (to hide)'!$B$60*'9 Commute'!I17","v":0}]
["Employee 7",null,null,null,null,0,null,null,{"$f":"IF(H18>0,IFERROR(VLOOKUP(H18,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G18,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F18*'Factors (to hide)'!$B$60*'9 Commute'!I18","v":0}]
["Employee 8",null,null,null,null,0,null,null,{"$f":"IF(H19>0,IFERROR(VLOOKUP(H19,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G19,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F19*'Factors (to hide)'!$B$60*'9 Commute'!I19","v":0}]
["Employee 9",null,null,null,null,0,null,null,{"$f":"IF(H20>0,IFERROR(VLOOKUP(H20,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G20,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F20*'Factors (to hide)'!$B$60*'9 Commute'!I20","v":0}]
["Employee 10",null,null,null,null,0,null,null,{"$f":"IF(H21>0,IFERROR(VLOOKUP(H21,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G21,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F21*'Factors (to hide)'!$B$60*'9 Commute'!I21","v":0}]
["Employee 11",null,null,null,null,0,null,null,{"$f":"IF(H22>0,IFERROR(VLOOKUP(H22,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G22,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F22*'Factors (to hide)'!$B$60*'9 Commute'!I22","v":0}]
["Employee 12",null,null,null,null,0,null,null,{"$f":"IF(H23>0,IFERROR(VLOOKUP(H23,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G23,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F23*'Factors (to hide)'!$B$60*'9 Commute'!I23","v":0}]
["Employee 13",null,null,null,null,0,null,null,{"$f":"IF(H24>0,IFERROR(VLOOKUP(H24,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G24,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F24*'Factors (to hide)'!$B$60*'9 Commute'!I24","v":0}]
["Employee 14",null,null,null,null,0,null,null,{"$f":"IF(H25>0,IFERROR(VLOOKUP(H25,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G25,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F25*'Factors (to hide)'!$B$60*'9 Commute'!I25","v":0}]
["Employee 15",null,null,null,null,0,null,null,{"$f":"IF(H26>0,IFERROR(VLOOKUP(H26,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G26,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F26*'Factors (to hide)'!$B$60*'9 Commute'!I26","v":0}]
["Employee 16",null,null,null,null,0,null,null,{"$f":"IF(H27>0,IFERROR(VLOOKUP(H27,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G27,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F27*'Factors (to hide)'!$B$60*'9 Commute'!I27","v":0}]
["Employee 17",null,null,null,null,0,null,null,{"$f":"IF(H28>0,IFERROR(VLOOKUP(H28,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G28,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F28*'Factors (to hide)'!$B$60*'9 Commute'!I28","v":0}]
["Employee 18",null,null,null,null,0,null,null,{"$f":"IF(H29>0,IFERROR(VLOOKUP(H29,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G29,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F29*'Factors (to hide)'!$B$60*'9 Commute'!I29","v":0}]
["Employee 19",null,null,null,null,0,null,null,{"$f":"IF(H30>0,IFERROR(VLOOKUP(H30,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G30,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F30*'Factors (to hide)'!$B$60*'9 Commute'!I30","v":0}]
["Employee 20",null,null,null,null,0,null,null,{"$f":"IF(H31>0,IFERROR(VLOOKUP(H31,'1 Data'!$A$16:$C$35,2,FALSE)/1000,\"NOT LISTED\"),IFERROR(VLOOKUP(G31,'Factors (to hide)'!A:B,2,FALSE),0))","v":0},{"$f":"+F31*'Factors (to hide)'!$B$60*'9 Commute'!I31","v":0}]

{"sheet":"10 Water bills","index":13,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Water bills"]
[]
["Record here all water bills relating to the period.  Include date and reading at start of first bill"]
["If no bills then leave blank and complete \"water Est\" tab instead."]
["If you have water bills and other water use, such as water heating in a shared space, then complete both tabs."]
["Total for period",null,null,{"$f":"SUM(D11:D25)","v":0},null,{"$f":"SUM(F11:F25)","v":0},{"$f":"SUM(G11:G25)","v":0}]
["Date","Meter reading m3","Water units on bill","Water relating to this period","Percentage business","Business use in period kWh","CO2e Kg"]
[null,null,null,null,null,null,null,"< date and reading at start of first bill"]
[null,null,{"$f":"IF(B11>0,+B11-B10,0)","v":0},{"$f":"IF($A10>0,MAX(+$A11-$A10-MAX('1 Data'!$B$10-1-$A10,0)-MAX($A11-'1 Data'!$B$11,0),0)*$C11/($A11-$A10),0)","v":0},1,{"$f":"+D11*E11","v":0},{"$f":"F11*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of first bil"]
[null,null,0,{"$f":"IF($A11>0,MAX(+$A12-$A11-MAX('1 Data'!$B$10-1-$A11,0)-MAX($A12-'1 Data'!$B$11,0),0)*$C12/($A12-$A11),0)","v":0},1,{"$f":"+D12*E12","v":0},{"$f":"F12*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of second bill"]
[null,null,0,{"$f":"IF($A12>0,MAX(+$A13-$A12-MAX('1 Data'!$B$10-1-$A12,0)-MAX($A13-'1 Data'!$B$11,0),0)*$C13/($A13-$A12),0)","v":0},1,0,{"$f":"F13*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of third bill"]
[null,null,0,{"$f":"IF($A13>0,MAX(+$A14-$A13-MAX('1 Data'!$B$10-1-$A13,0)-MAX($A14-'1 Data'!$B$11,0),0)*$C14/($A14-$A13),0)","v":0},1,0,{"$f":"F14*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}," etc."]
[null,null,0,{"$f":"IF($A14>0,MAX(+$A15-$A14-MAX('1 Data'!$B$10-1-$A14,0)-MAX($A15-'1 Data'!$B$11,0),0)*$C15/($A15-$A14),0)","v":0},1,0,{"$f":"F15*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A15>0,MAX(+$A16-$A15-MAX('1 Data'!$B$10-1-$A15,0)-MAX($A16-'1 Data'!$B$11,0),0)*$C16/($A16-$A15),0)","v":0},1,0,{"$f":"F16*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A16>0,MAX(+$A17-$A16-MAX('1 Data'!$B$10-1-$A16,0)-MAX($A17-'1 Data'!$B$11,0),0)*$C17/($A17-$A16),0)","v":0},1,0,{"$f":"F17*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A17>0,MAX(+$A18-$A17-MAX('1 Data'!$B$10-1-$A17,0)-MAX($A18-'1 Data'!$B$11,0),0)*$C18/($A18-$A17),0)","v":0},1,0,{"$f":"F18*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A18>0,MAX(+$A19-$A18-MAX('1 Data'!$B$10-1-$A18,0)-MAX($A19-'1 Data'!$B$11,0),0)*$C19/($A19-$A18),0)","v":0},1,0,{"$f":"F19*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A19>0,MAX(+$A20-$A19-MAX('1 Data'!$B$10-1-$A19,0)-MAX($A20-'1 Data'!$B$11,0),0)*$C20/($A20-$A19),0)","v":0},1,0,{"$f":"F20*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A20>0,MAX(+$A21-$A20-MAX('1 Data'!$B$10-1-$A20,0)-MAX($A21-'1 Data'!$B$11,0),0)*$C21/($A21-$A20),0)","v":0},1,0,{"$f":"F21*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A21>0,MAX(+$A22-$A21-MAX('1 Data'!$B$10-1-$A21,0)-MAX($A22-'1 Data'!$B$11,0),0)*$C22/($A22-$A21),0)","v":0},1,0,{"$f":"F22*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A22>0,MAX(+$A23-$A22-MAX('1 Data'!$B$10-1-$A22,0)-MAX($A23-'1 Data'!$B$11,0),0)*$C23/($A23-$A22),0)","v":0},1,0,{"$f":"F23*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A23>0,MAX(+$A24-$A23-MAX('1 Data'!$B$10-1-$A23,0)-MAX($A24-'1 Data'!$B$11,0),0)*$C24/($A24-$A23),0)","v":0},1,0,{"$f":"F24*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A24>0,MAX(+$A25-$A24-MAX('1 Data'!$B$10-1-$A24,0)-MAX($A25-'1 Data'!$B$11,0),0)*$C25/($A25-$A24),0)","v":0},1,0,{"$f":"F25*VLOOKUP(\"Water\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]

{"sheet":"11 Water Est","index":14,"n_rows":21,"n_cols":7,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Water use - Estimations"]
[]
[]
[]
[]
["CO2e for period",{"$f":"+B13*VLOOKUP(\"water\",'Factors (to hide)'!$A:$B,2,FALSE)/1000","v":3.7571428571428575E-2}]
["Average number of workers",1]
["Average days per person per week",5]
["Water use factor","average"]
["Other factors",1]
["Calculated litres for period",{"$f":"'Factors (to hide)'!$B69*B9*B10*('1 Data'!B11+1-'1 Data'!B10)/7*VLOOKUP(B11,$A$17:$B$21,2,FALSE)*B12","v":35.714285714285715}]
[]
[]
["Water usage factors:"]
["wasteful",1.5]
["poor",1.25]
["average",1]
["little",0.75]
["desert like",0.5]

{"sheet":"12 Paper","index":15,"n_rows":100,"n_cols":7,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,"Note: 1 ream of paper = 500 sheets = approx 2.5kg",null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Paper purchases (equivalent of paper use)"]
[]
[]
[]
[]
["Total for period",null,null,{"$f":"SUM(D10:D100)","v":0},{"$f":"SUM(E10:E100)","v":0}]
["Date","Description","% recycled","Weight kg","CO2e kg"]
[null,null,null,null,{"$f":"IF(AND(A10>='1 Data'!$B$10,A10<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D10*(1-C10)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D10*(C10)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A11>='1 Data'!$B$10,A11<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D11*(1-C11)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D11*(C11)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A12>='1 Data'!$B$10,A12<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D12*(1-C12)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D12*(C12)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A13>='1 Data'!$B$10,A13<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D13*(1-C13)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D13*(C13)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A14>='1 Data'!$B$10,A14<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D14*(1-C14)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D14*(C14)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A15>='1 Data'!$B$10,A15<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D15*(1-C15)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D15*(C15)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A16>='1 Data'!$B$10,A16<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D16*(1-C16)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D16*(C16)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A17>='1 Data'!$B$10,A17<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D17*(1-C17)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D17*(C17)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A18>='1 Data'!$B$10,A18<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D18*(1-C18)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D18*(C18)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A19>='1 Data'!$B$10,A19<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D19*(1-C19)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D19*(C19)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A20>='1 Data'!$B$10,A20<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D20*(1-C20)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D20*(C20)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A21>='1 Data'!$B$10,A21<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D21*(1-C21)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D21*(C21)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A22>='1 Data'!$B$10,A22<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D22*(1-C22)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D22*(C22)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A23>='1 Data'!$B$10,A23<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D23*(1-C23)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D23*(C23)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A24>='1 Data'!$B$10,A24<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D24*(1-C24)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D24*(C24)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A25>='1 Data'!$B$10,A25<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D25*(1-C25)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D25*(C25)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A26>='1 Data'!$B$10,A26<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D26*(1-C26)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D26*(C26)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A27>='1 Data'!$B$10,A27<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D27*(1-C27)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D27*(C27)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A28>='1 Data'!$B$10,A28<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D28*(1-C28)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D28*(C28)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A29>='1 Data'!$B$10,A29<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D29*(1-C29)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D29*(C29)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A30>='1 Data'!$B$10,A30<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D30*(1-C30)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D30*(C30)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A31>='1 Data'!$B$10,A31<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D31*(1-C31)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D31*(C31)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A32>='1 Data'!$B$10,A32<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D32*(1-C32)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D32*(C32)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A33>='1 Data'!$B$10,A33<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D33*(1-C33)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D33*(C33)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A34>='1 Data'!$B$10,A34<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D34*(1-C34)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D34*(C34)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A35>='1 Data'!$B$10,A35<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D35*(1-C35)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D35*(C35)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A36>='1 Data'!$B$10,A36<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D36*(1-C36)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D36*(C36)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A37>='1 Data'!$B$10,A37<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D37*(1-C37)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D37*(C37)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A38>='1 Data'!$B$10,A38<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D38*(1-C38)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D38*(C38)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A39>='1 Data'!$B$10,A39<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D39*(1-C39)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D39*(C39)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A40>='1 Data'!$B$10,A40<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D40*(1-C40)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D40*(C40)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A41>='1 Data'!$B$10,A41<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D41*(1-C41)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D41*(C41)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A42>='1 Data'!$B$10,A42<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D42*(1-C42)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D42*(C42)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A43>='1 Data'!$B$10,A43<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D43*(1-C43)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D43*(C43)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A44>='1 Data'!$B$10,A44<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D44*(1-C44)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D44*(C44)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A45>='1 Data'!$B$10,A45<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D45*(1-C45)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D45*(C45)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A46>='1 Data'!$B$10,A46<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D46*(1-C46)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D46*(C46)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A47>='1 Data'!$B$10,A47<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D47*(1-C47)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D47*(C47)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A48>='1 Data'!$B$10,A48<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D48*(1-C48)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D48*(C48)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A49>='1 Data'!$B$10,A49<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D49*(1-C49)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D49*(C49)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A50>='1 Data'!$B$10,A50<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D50*(1-C50)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D50*(C50)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A51>='1 Data'!$B$10,A51<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D51*(1-C51)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D51*(C51)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A52>='1 Data'!$B$10,A52<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D52*(1-C52)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D52*(C52)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A53>='1 Data'!$B$10,A53<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D53*(1-C53)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D53*(C53)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A54>='1 Data'!$B$10,A54<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D54*(1-C54)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D54*(C54)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A55>='1 Data'!$B$10,A55<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D55*(1-C55)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D55*(C55)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A56>='1 Data'!$B$10,A56<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D56*(1-C56)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D56*(C56)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A57>='1 Data'!$B$10,A57<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D57*(1-C57)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D57*(C57)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A58>='1 Data'!$B$10,A58<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D58*(1-C58)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D58*(C58)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A59>='1 Data'!$B$10,A59<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D59*(1-C59)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D59*(C59)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A60>='1 Data'!$B$10,A60<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D60*(1-C60)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D60*(C60)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A61>='1 Data'!$B$10,A61<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D61*(1-C61)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D61*(C61)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A62>='1 Data'!$B$10,A62<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D62*(1-C62)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D62*(C62)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A63>='1 Data'!$B$10,A63<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D63*(1-C63)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D63*(C63)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A64>='1 Data'!$B$10,A64<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D64*(1-C64)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D64*(C64)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A65>='1 Data'!$B$10,A65<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D65*(1-C65)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D65*(C65)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A66>='1 Data'!$B$10,A66<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D66*(1-C66)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D66*(C66)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A67>='1 Data'!$B$10,A67<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D67*(1-C67)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D67*(C67)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A68>='1 Data'!$B$10,A68<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D68*(1-C68)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D68*(C68)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A69>='1 Data'!$B$10,A69<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D69*(1-C69)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D69*(C69)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A70>='1 Data'!$B$10,A70<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D70*(1-C70)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D70*(C70)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A71>='1 Data'!$B$10,A71<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D71*(1-C71)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D71*(C71)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A72>='1 Data'!$B$10,A72<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D72*(1-C72)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D72*(C72)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A73>='1 Data'!$B$10,A73<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D73*(1-C73)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D73*(C73)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A74>='1 Data'!$B$10,A74<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D74*(1-C74)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D74*(C74)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A75>='1 Data'!$B$10,A75<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D75*(1-C75)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D75*(C75)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A76>='1 Data'!$B$10,A76<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D76*(1-C76)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D76*(C76)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A77>='1 Data'!$B$10,A77<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D77*(1-C77)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D77*(C77)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A78>='1 Data'!$B$10,A78<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D78*(1-C78)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D78*(C78)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A79>='1 Data'!$B$10,A79<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D79*(1-C79)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D79*(C79)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A80>='1 Data'!$B$10,A80<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D80*(1-C80)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D80*(C80)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A81>='1 Data'!$B$10,A81<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D81*(1-C81)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D81*(C81)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A82>='1 Data'!$B$10,A82<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D82*(1-C82)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D82*(C82)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A83>='1 Data'!$B$10,A83<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D83*(1-C83)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D83*(C83)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A84>='1 Data'!$B$10,A84<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D84*(1-C84)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D84*(C84)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A85>='1 Data'!$B$10,A85<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D85*(1-C85)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D85*(C85)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A86>='1 Data'!$B$10,A86<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D86*(1-C86)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D86*(C86)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A87>='1 Data'!$B$10,A87<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D87*(1-C87)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D87*(C87)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A88>='1 Data'!$B$10,A88<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D88*(1-C88)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D88*(C88)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A89>='1 Data'!$B$10,A89<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D89*(1-C89)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D89*(C89)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A90>='1 Data'!$B$10,A90<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D90*(1-C90)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D90*(C90)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A91>='1 Data'!$B$10,A91<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D91*(1-C91)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D91*(C91)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A92>='1 Data'!$B$10,A92<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D92*(1-C92)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D92*(C92)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A93>='1 Data'!$B$10,A93<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D93*(1-C93)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D93*(C93)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A94>='1 Data'!$B$10,A94<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D94*(1-C94)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D94*(C94)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A95>='1 Data'!$B$10,A95<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D95*(1-C95)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D95*(C95)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A96>='1 Data'!$B$10,A96<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D96*(1-C96)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D96*(C96)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A97>='1 Data'!$B$10,A97<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D97*(1-C97)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D97*(C97)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A98>='1 Data'!$B$10,A98<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D98*(1-C98)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D98*(C98)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A99>='1 Data'!$B$10,A99<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D99*(1-C99)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D99*(C99)),\"\")","v":0}]
[null,null,null,null,{"$f":"IF(AND(A100>='1 Data'!$B$10,A100<='1 Data'!$B$11),(VLOOKUP(\"paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D100*(1-C100)+VLOOKUP(\"recycled paper\",'Factors (to hide)'!A:B,2,FALSE)/(2.5)*D100*(C100)),\"\")","v":0}]

{"sheet":"13 PV Solar","index":16,"n_rows":25,"n_cols":8,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[{"$f":"+'1 Data'!B8","v":"The Example Company"},null,null,null,null,null,"Data Complete?"]
[{"$f":"\"For the period from \"&TEXT('1 Data'!B10,\"d mmmm yyyy\")&\" to \"&TEXT('1 Data'!B11,\"d mmmm yyyy\")","v":"For the period from 0 January 1900 to 0 January 1900"},null,null,null,null,null,"No"]
["Solar Photovoltaic (PV) electricity generated"]
[]
["Record here all solar power (pv) electricity generated.  Include date and reading at start of period."]
[]
[]
["Total for period",null,null,{"$f":"SUM(D11:D25)","v":0},null,{"$f":"SUM(F11:F25)","v":0},{"$f":"SUM(G11:G25)","v":0}]
["Date","Meter reading kWh","Electricity units on bill kWh","Electricity this period kWh","Percentage business","Business use in period kWh","CO2e Kg"]
[null,null,null,null,null,null,null,"< date and reading at start of first period"]
[null,null,{"$f":"IF(B11>0,+B11-B10,0)","v":0},{"$f":"IF($A10>0,MAX(+$A11-$A10-MAX('1 Data'!$B$10-1-$A10,0)-MAX($A11-'1 Data'!$B$11,0),0)*$C11/($A11-$A10),0)","v":0},1,{"$f":"+D11*E11","v":0},{"$f":"F11*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of first period"]
[null,null,0,{"$f":"IF($A11>0,MAX(+$A12-$A11-MAX('1 Data'!$B$10-1-$A11,0)-MAX($A12-'1 Data'!$B$11,0),0)*$C12/($A12-$A11),0)","v":0},1,{"$f":"+D12*E12","v":0},{"$f":"F12*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of second period"]
[null,null,0,{"$f":"IF($A12>0,MAX(+$A13-$A12-MAX('1 Data'!$B$10-1-$A12,0)-MAX($A13-'1 Data'!$B$11,0),0)*$C13/($A13-$A12),0)","v":0},1,0,{"$f":"F13*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0},"< date and reading at end of third period"]
[null,null,0,{"$f":"IF($A13>0,MAX(+$A14-$A13-MAX('1 Data'!$B$10-1-$A13,0)-MAX($A14-'1 Data'!$B$11,0),0)*$C14/($A14-$A13),0)","v":0},1,0,{"$f":"F14*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}," etc."]
[null,null,0,{"$f":"IF($A14>0,MAX(+$A15-$A14-MAX('1 Data'!$B$10-1-$A14,0)-MAX($A15-'1 Data'!$B$11,0),0)*$C15/($A15-$A14),0)","v":0},1,0,{"$f":"F15*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A15>0,MAX(+$A16-$A15-MAX('1 Data'!$B$10-1-$A15,0)-MAX($A16-'1 Data'!$B$11,0),0)*$C16/($A16-$A15),0)","v":0},1,0,{"$f":"F16*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A16>0,MAX(+$A17-$A16-MAX('1 Data'!$B$10-1-$A16,0)-MAX($A17-'1 Data'!$B$11,0),0)*$C17/($A17-$A16),0)","v":0},1,0,{"$f":"F17*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A17>0,MAX(+$A18-$A17-MAX('1 Data'!$B$10-1-$A17,0)-MAX($A18-'1 Data'!$B$11,0),0)*$C18/($A18-$A17),0)","v":0},1,0,{"$f":"F18*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A18>0,MAX(+$A19-$A18-MAX('1 Data'!$B$10-1-$A18,0)-MAX($A19-'1 Data'!$B$11,0),0)*$C19/($A19-$A18),0)","v":0},1,0,{"$f":"F19*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A19>0,MAX(+$A20-$A19-MAX('1 Data'!$B$10-1-$A19,0)-MAX($A20-'1 Data'!$B$11,0),0)*$C20/($A20-$A19),0)","v":0},1,0,{"$f":"F20*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A20>0,MAX(+$A21-$A20-MAX('1 Data'!$B$10-1-$A20,0)-MAX($A21-'1 Data'!$B$11,0),0)*$C21/($A21-$A20),0)","v":0},1,0,{"$f":"F21*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A21>0,MAX(+$A22-$A21-MAX('1 Data'!$B$10-1-$A21,0)-MAX($A22-'1 Data'!$B$11,0),0)*$C22/($A22-$A21),0)","v":0},1,0,{"$f":"F22*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A22>0,MAX(+$A23-$A22-MAX('1 Data'!$B$10-1-$A22,0)-MAX($A23-'1 Data'!$B$11,0),0)*$C23/($A23-$A22),0)","v":0},1,0,{"$f":"F23*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A23>0,MAX(+$A24-$A23-MAX('1 Data'!$B$10-1-$A23,0)-MAX($A24-'1 Data'!$B$11,0),0)*$C24/($A24-$A23),0)","v":0},1,0,{"$f":"F24*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]
[null,null,0,{"$f":"IF($A24>0,MAX(+$A25-$A24-MAX('1 Data'!$B$10-1-$A24,0)-MAX($A25-'1 Data'!$B$11,0),0)*$C25/($A25-$A24),0)","v":0},1,0,{"$f":"F25*VLOOKUP(\"Electricity\",'Factors (to hide)'!A:B,2,FALSE)","v":0}]

{"sheet":"Questionnaire - Carbon accounts","index":17,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[]}
["Carbon Accounting - Questionnaire","Answers (complete yellow cells)"]
[]
["Data for carbon accounting"]
["How much of your energy is renewable? (%)","[type details here]"]
["What vehicles does your organisation use? Please list vehicle type (i.e. cars, vans etc.)","[type details here]"]
["What are the CO2 emissions for each vehicle? (g/km)","[type details here]"]
["Do you use waste veg oil to fuel any of the vehicles?","[type details here]"]
[]
["Electricity use"]
["Please supply details on the appliances your business currently uses, along with details on their power (kWh) and usage.","Quantity of appliances"]
["Laptops"]
["Monitors"]
["Telephones"]
["Modems"]
["Lights"]
["Kettle"]
["Other (please specify)"]
["Other (please specify)"]
["Other (please specify)"]
["Other (please specify)"]
["Other (please specify)"]
[]
["Commute (use more rows as need be, use 2 or more rows for employees with varying transport)","Commute distance (miles)","Transport Method"]
["Employee 1"]
["Employee 2"]
["Employee 3"]
["Employee 4"]
["Employee 5"]
[]
["Other energy use:"]
["Gas: Approximately what is the insulation factor for your premises? (please select)","average"]
["Paper: Approximately how much paper have you used during the accounting period? (please give quantity in number of packets)","[type details here]"]
["What % of the paper used is recycled?","[type details here]"]
["N.B. 1 packet = approximately a ream of 500 sheets (30 x 21.4 x 5.4cm, 2.5kg)"]
["Water use: Do you think your water usage is…? (please select option)","average"]
["PV Solar approximately how much of your electricity is PV? (kWh)","[type details here]"]
["Cabon Offsetting purchased (tonnes of CO2e)","[type details here]"]
["% electricity bought that is green tarriff","[type details here]"]