{"text_format":"3","workbook":"xlsx","n_sheets":17,"sheets":["Intro&Instructions","Release Notes","FPCalculationForm England","FPCalculationForm Wales","FPCalculationForm Scotland","params_eng","params_sco","Scotland MIS Backing","Sheet3","Sheet4","Sheet5","CommunityFPDatabase England","CommunityFPDatabase Wales","CommunityFPDatabase Scotland","DataCollectionFormEng (PRINT)","DataCollectionFormWal (PRINT)","DataCollectionFormSco (PRINT)"],"not_rendered":{"images":6,"macros":1,"defined_names":8,"comments":6},"read":"whole","date_system":"1900"}

{"sheet":"Intro&Instructions","index":0,"n_rows":53,"n_cols":4,"rows_kept":53,"merged":[[2,2,2,7],[6,2,6,9],[8,2,9,7],[19,2,19,9],[25,2,25,9],[26,2,26,9],[27,2,27,9],[29,2,29,9],[30,2,30,9],[31,2,31,9],[32,2,32,9],[36,3,36,9],[37,3,37,9],[38,3,38,9],[39,3,39,9],[40,3,40,9],[41,3,41,9],[42,3,44,9],[46,2,50,10]]}
[]
[]
[null,null,"FUEL POVERTY CALCULATOR"]
[null,null,"Last updated: 27/02/2026"]
[]
[]
[null,null,"The Fuel Poverty Calculator is a free Microsoft Excel tool that allows users to input occupancy information, income, housing costs and energy bill details to estimate fuel poverty status in England, Scotland, and Wales."]
[]
[null,null,"The process of calculating fuel poverty using the old and new definitions requires some or all of the following information (depending on the definition):"]
[]
[null,null,"• Total number of people in the household (permanent residents)"]
[null,null,"• Number of adults"]
[null,null,"• Number of children (under 14)*"]
[null,null,"• Number of children (0-1)†"]
[null,null,"• Number of children (2-4)†"]
[null,null,"• Number of children (primary school age)†"]
[null,null,"• Number of children (secondary school age)†"]
[null,null,"• Annual total household net income (including income from benefits, tax credits and savings)"]
[null,null,"• Annual fuel costs for heating, water heating, lights, appliances and cooking"]
[null,null,"• Annual housing costs (mortgage repayments and/or rent costs; for the full details on the calculation of a 'fuel poverty income' see the diagram below)"]
[null,null,"• The EPC rating of the building*"]
[]
[null,null,"*England only"]
[null,null,"†Scotland only"]
[]
[null,null,"The Department for Energy Security and Net Zero (DESNZ) publish an in-depth publication on the methodology used to calculate fuel poverty in England. This can be found here:"]
[null,null,"https://www.gov.uk/government/publications/fuel-poverty-statistics-methodology-handbook"]
[null,null,"The Welsh defintion for fuel poverty can be found in Appendix A of the Fuel poverty modelled estimates for Wales. This can be found here:"]
[null,null,"Fuel poverty modelled estimates for Wales: as at October 2024 | GOV.WALES"]
[null,null,"The Scottish Parliament passed an Act defining fuel poverty. This can be found here:"]
[null,null,"https://www.legislation.gov.uk/asp/2019/10/enacted"]
[null,null,"A further explanation of the Scotland fuel poverty definition can be found here:"]
[null,null,"https://fuelpovertypanel.scot/blog/definition-of-fuel-poverty-explained/"]
[]
[null,null,"This spreadsheet contains nine tabs:"]
[]
[null,null,"FPCalculationForm England","The FPCalculationForm England tab calculates fuel poverty of households using the required information described above, for England. This can be used for calculations on individual households. However, if you wish to record several households or even a whole community's fuel poverty status, then you can press the Transfer record to database button. This will export the information and results in a new row in the CommunityFPDatabase England tab. After transfering the data you can press the Clear data button to clear the form and enter new data."]
[null,null,"FPCalculationForm Wales","The FPCalculationForm Wales tab is the same as that for England but the information gathered in the form is modified to be suitable for the Welsh Fuel Poverty calculation."]
[null,null,"FPCalculationForm Scotland","The FPCalculationForm Scotland tab is the same as that for England but the information gathered in the form is modified to be suitable for the Scottish Fuel Poverty calculation."]
[null,null,"CommunityFPDatabase England","This tab will contain all the exported information from the FPCalculationForm England, with the most recently exported record at the top of the table."]
[null,null,"CommunityFPDatabase Wales","This tab will contain all the exported information from the FPCalculationForm Wales, with the most recently exported record at the top of the table."]
[null,null,"CommunityFPDatabase Scotland","This tab will contain all the exported information from the FPCalculationForm Scotland, with the most recently exported record at the top of the table."]
[null,null,"DataCollectionFormEng (PRINT)","These are forms that can be printed off and used to collect information to input into the relevant FPCalculationForm tab. This includes a section which can be used to calculate the total annual net income for a household from various sources and for different people in the household."]
[null,null,"DataCollectionFormWal (PRINT)"]
[null,null,"DataCollectionFormSco (PRINT)"]
[]
[null,null,"The different fuel poverty definitions\n\nEngland\n\nLow Income Low Energy Efficiency\nThe official definition in England (2021-). A household is defined as living in fuel poverty if they have a Fuel Poverty Energy Efficiency Rating (FPEER) below 68.5 (roughly EPC band D or below) AND if they were to spend their equivalised required fuel costs, they would be left with an equivalised income (after housing costs) below the relative low income threshold. The relative low income threshold is 60% of the national median of equivalised income (after housing costs).\n\nLow Income High Cost\nThe former definition in England (2013-2021). A household is defined as living in fuel poverty if their equivalised required fuel costs are above the national median of equivalised required fuel costs AND if they were to spend their equivalised required fuel costs, they would be left with an equivalised income (after housing costs) below the relative low income threshold. The relative low income threshold is 60% of the national median of equivalised income (after housing costs).\n\nThe former definition in England (-2013), before the Fuel Poverty Review by John Hills, was the 10% indicator.\n\nIn the above two definitions, household fuel costs and income are equivalised. Equivalising effectively increases the incomes and fuel costs of single people, and reduces the incomes and fuel costs of larger households, with the intention of making them comparable.\n\nScotland\n\nThe official definition in Scotland (2019-): A household is defined as living in fuel poverty if \n(a) the fuel costs necessary for the home in which members of the household live are more than 10% of the household’s adjusted (i.e. after housing costs) net income, and\n(b) after deducting such fuel costs, benefits received for a care need or disability (if any) and the household’s childcare costs (if any), the household’s remaining adjusted net income is insufficient to maintain an acceptable standard of living for members of the household.\n\nWales \n\n10% indicator\nThis definition is the official definition in Wales. A household is defined as living in fuel poverty if their required fuel costs (not equivalised) are more than 10% of their full income (not equivalised and before housing costs)."]
[]
[]
[]
[]
[]
[null,null,"The main steps in calculating equivalised income after housing costs (AHC) under the LILEE metric"]

{"sheet":"Release Notes","index":1,"n_rows":7,"n_cols":3,"rows_kept":7,"merged":[[2,2,2,7],[3,2,3,7],[4,2,5,7],[6,2,6,9]]}
[]
[]
[null,null,"FUEL POVERTY CALCULATOR"]
[null,null,"Release notes - February 2026"]
[]
[]
[null,null,"This updated version of the Fuel Poverty Calculator determines fuel poverty status for England using the LILEE definition of fuel poverty. It also now determines fuel poverty status for Scotland using the Scottish fuel poverty definition and builds out a separate, more accurate calculation form for Wales. The tool also includes England's former LIHC definition and \"10% indicator\" definition of fuel poverty.\n\nThe thresholds for income and fuel costs for England come from the \"Annual Fuel Poverty Statistics in England (2024 data)\" released in March 2025. Calculations for England have been completed following guidance from the Fuel Poverty Methodology Handbook from the Department for Energy Security & Net Zero (DESNZ).\n\nFor Scotland, results from the online Minimum Income Calculator have been used to establish an income threshold (https://www.minimumincome.org.uk/).\n\nFor Wales, a simple calculation has been made based on the 10% definiton. "]

{"sheet":"FPCalculationForm England","index":2,"n_rows":86,"n_cols":7,"rows_kept":86,"merged":[[2,1,4,5],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[41,2,41,3],[42,2,42,3],[46,2,46,3],[47,2,47,3],[49,2,49,3],[52,2,52,4],[59,2,59,3],[66,2,66,3],[68,2,68,3],[70,2,70,3],[77,1,79,5],[78,7,78,14],[79,7,79,14],[80,1,80,5],[80,6,81,8],[81,1,81,5],[82,1,82,5],[82,6,83,8],[83,1,83,3],[83,4,83,5],[84,1,84,5],[84,6,85,8],[85,1,85,3],[85,4,85,5],[86,1,86,5],[89,2,89,6]]}
[]
[]
[null,"FUEL POVERTY CALCULATION FORM"]
[]
[]
[]
[null,null,"Title"]
[null,null,"First name"]
[null,null,"Surname"]
[null,null,"Flat number"]
[null,null,"Building name"]
[null,null,"Building number"]
[null,null,"Street"]
[null,null,"District"]
[null,null,"Town"]
[null,null,"County"]
[null,null,"Post code"]
[]
[]
[null,null,"Household income"]
[null,null,"Monthly income from paid or self employment (less tax & NI)"]
[null,null,"Monthly income from state benefits1,2 and tax credits"]
[null,null,"Monthly income from any pension received3"]
[]
[null,null,"Monthly interest from savings or investments"]
[]
[null,null,"Annual council tax bill"]
[null,null,"Amount of Winter Fuel Payment received4"]
[]
[null,null,"Annual net household income",null,{"$f":"12*(E21+E22+E23+E25)-E27+E28","v":{"v":0,"d":"£0"}},"(INC1)"]
[null,null,"\n(Any income should take into account tax and NI deductions)"]
[null,null,"1 Also include housing related benefits, Council Tax Support/Reduction, and Mortage Payment Protection Insurance (MPPI). Ensure Universal Credit payment for lone parents is at least their theoretical entitlement."]
[null,null,"2 Exclude disability benefits (Disability Living Allowance, Personal Independence Payments, and Attendance Allowance)."]
[null,null,"3 Ensure pension payments are at least those of minimum state pension."]
[null,null,"4 Winter Fuel Payment varies between £100 and £300. Check here for the correct amount: "]
[null,null,"www.gov.uk/winter-fuel-payment/what-youll-get"]
[]
[]
[null,null,"Housing Costs"]
[null,null,"mortgage payments"]
[null,null,"If you have a mortgage, how much do you pay in each installment?"]
[null,null,"How often a year do you make these payments (i.e. If weekly enter '52', monthly enter '12', quarterly enter '4')"]
[null,null,"Annual mortgage payments",null,{"$f":"E41*E42","v":{"v":0,"d":"£0"}}]
[]
[null,null,"rent payments"]
[null,null,"If you pay rent, how much do you pay each installment?"]
[null,null,"How often a year do you make these payments (i.e. If weekly enter '52', monthly enter '12', quarterly enter '4')"]
[null,null,"Annual rent payments",null,{"$f":"E46*E47","v":{"v":0,"d":"£0"}}]
[]
[null,null,"Annual income (after housing costs)",null,{"$f":"E30-E43-E48","v":{"v":0,"d":"£0"}}]
[]
[]
[null,null,"Fuel costs\n(Enter monthly costs. So, if for example you pay quarterly, divide this amount by 3.)"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"What do you pay for other fuels each month?"]
[]
[null,null,"Do you receive the Warm Home Discount?"]
[null,null,"https://www.gov.uk/the-warm-home-discount-scheme"]
[null,null,"Annual fuel costs",null,{"$f":"(E54+E55+E56)*12-IF(E58=\"yes\",150,0)","v":{"v":0,"d":"£0"}}]
[]
[]
[null,null,"Household size"]
[null,null,"How many people aged 14 or over are regularly living in your household?"]
[null,null,"How many people aged under 14 are regularly living in your household?"]
[]
[null,null,"Total number of people regularly living in household",null,{"$f":"SUM(E64:E65)","v":0}]
[]
[null,null,"Annual equivalised fuel costs",null,{"$f":"IFERROR(E60/params_eng!F15,0)","v":{"v":0,"d":"£0"}}]
[]
[null,null,"Annual equivalised income (after housing costs)",null,{"$f":"IFERROR(E50/params_eng!J13,0)","v":{"v":0,"d":"£0"}}]
[]
[]
[null,null,"EPC band"]
[null,null,"What is the EPC band of your property?"]
[]
[]
[null,"Official fuel poverty definition in England (2021-)\n\nA household is defined as living in fuel poverty if they have a Fuel Poverty Energy Efficiency Rating (FPEER) below 68.5 (EPC band D or below) AND if they were to spend their equivalised required fuel costs, they would be left with an equivalised income (after housing costs) below the relative low income threshold. The relative low income threshold is 60% of the national median of equivalised income (after housing costs). \n\nOR, MORE SIMPLY:\nFuel poor households are low income households living in low energy efficiency homes\n\nThe above Low Income Low Energy Efficiency (LILEE) definition of fuel poverty replaced the Low Income High Cost (LIHC) definition in England in 2021, which itself replaced the 10% indicator definition in 2013. The 10% indicator definition is still used in Wales and Northern Ireland. See the \"Intro&Instructions\" tab for more details on the different fuel poverty definitions.\n\nTo calculate the official fuel poverty status of a household, the annual fuel costs must be those that are required to be spent in order to provide an 'adequate level of warmth' in the dwelling, as calculated by a BREDEM based energy assessment.\n\nIf you wish to use this tool to calculate whether a household is in official fuel poverty, then you will need to use the total annual energy costs as calculated by an energy assessment of a dwelling. If you are using actual expenditure on fuel to determine a households fuel poverty status, then you should be aware that this does not follow the official methodology for calculating fuel poverty.\n\nHowever, in the majority of cases (for various reasons) the amount people spend on their fuel bills will be lower than the amount required to be spent to heat homes to 'adequate' levels. Therefore, if you do use a household's actual fuel expenditure and find that that household is in fuel poverty, then it is likely that the household would also be in fuel poverty according to the official definition."]
[]
[]
[null,{"$f":"IF(E67=0,\"MISSING VALUE - HOUSEHOLD SIZE\",IF(ISBLANK(E75),\"MISSING VALUE - EPC BAND OF PROPERTY\",IF(E30=0,\"MISSING VALUE - HOUSEHOLD INCOME\",IF(params_eng!C18+params_eng!C15=2,\"Your household is living in fuel poverty\",\"Your household is not fuel poor\"))))","v":"MISSING VALUE - HOUSEHOLD SIZE"},{"$nulls":4},"Low Income Low Energy Efficiency (LILEE)\nOfficial definition in England (2021-)"]
[null,{"$f":"IF(params_eng!C15+params_eng!C18=2,\"Your 'fuel poverty gap' cannot be accurately calculated using the LILEE method\",\"\")","v":"Your 'fuel poverty gap' cannot be accurately calculated using the LILEE method"}]
[null,{"$f":"IF(E67=0,\"MISSING VALUE - HOUSEHOLD SIZE\",IF(E30=0,\"MISSING VALUE - HOUSEHOLD INCOME\",IF(params_eng!C18+params_eng!C16=2,\"Your household is living in fuel poverty\",\"Your household is not fuel poor\")))","v":"MISSING VALUE - HOUSEHOLD SIZE"},{"$nulls":4},"Low Income High Cost (LIHC)\nFormer definition in England (2013-2021)"]
[null,{"$f":"IF(params_eng!C16+params_eng!C18=2,\"Your annual 'fuel poverty gap' is:\",\"\")","v":""},null,null,{"$f":"IF(params_eng!C16+params_eng!C18=2,params_eng!F15*((E69-params_eng!C11)-MAX(E71-params_eng!C12, 0)),\"\")","v":""}]
[null,{"$f":"IFERROR(IF(E60/E30>0.1,\"Your household is living in fuel poverty\",\"Your household is not fuel poor\"),\"\")","v":""},{"$nulls":4},"10% indicator\nFormer definition in England (-2013)"]
[null,"% of household income (before housing costs) spent on fuel",null,null,{"$f":"IFERROR(E60/E30,\"\")","v":""}]

{"sheet":"FPCalculationForm Wales","index":3,"n_rows":51,"n_cols":6,"rows_kept":51,"merged":[[2,1,4,5],[29,2,29,3],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[37,2,37,4],[44,2,44,3],[46,1,48,5],[47,7,47,14],[48,7,48,14],[49,1,49,5],[49,6,50,8],[50,1,50,3],[50,4,50,5],[51,1,51,5],[54,2,54,6]]}
[]
[]
[null,"FUEL POVERTY CALCULATION FORM"]
[]
[]
[]
[null,null,"Title"]
[null,null,"First name"]
[null,null,"Surname"]
[null,null,"Flat number"]
[null,null,"Building name"]
[null,null,"Building number"]
[null,null,"Street"]
[null,null,"District"]
[null,null,"Town"]
[null,null,"County"]
[null,null,"Post code"]
[]
[]
[null,null,"Household income"]
[null,null,"Monthly income from paid or self employment (less tax & NI)"]
[null,null,"Monthly income from state benefits1 and tax credits"]
[null,null,"Monthly income from any pension received"]
[]
[null,null,"Monthly interest from savings or investments"]
[]
[null,null,"Annual council tax bill"]
[null,null,"Amount of Winter Fuel Payment received2"]
[]
[null,null,"Annual net household income",null,{"$f":"12*(E21+E22+E23+E25)-E27+E28","v":{"v":0,"d":"£0"}},"(INC1)"]
[null,null,"\n(Any income should take into account tax and NI deductions)"]
[null,null,"1 Also include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance (MPPI), and disability benefits."]
[]
[null,null,"2 Winter Fuel Payment varies between £100 and £300. Check here for the correct amount: "]
[null,null,"www.gov.uk/winter-fuel-payment/what-youll-get"]
[]
[]
[null,null,"Fuel costs\n(Enter monthly costs. So, if for example you pay quarterly, divide this amount by 3.)"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"What do you pay for other fuels each month?"]
[]
[null,null,"Do you receive the Warm Home Discount?"]
[null,null,"https://www.gov.uk/the-warm-home-discount-scheme"]
[null,null,"Annual fuel costs",null,{"$f":"(E39+E40+E41)*12-IF(E43=\"yes\",150,0)","v":{"v":0,"d":"£0"}}]
[]
[null,"Official fuel poverty definition in Wales\n\nA household is in fuel poverty if it needs to spend more than 10% of its income (including housing related benefits and net of council tax) on all household fuel use in order to maintain a satisfactory heating regime. Further, a household is in severe fuel poverty if it needs to spend more than 20% of its income on fuel, and a household is considered at risk of fuel poverty if it needs to spend 8-10% of its income on fuel. \n\nIf you wish to use this tool to calculate whether a household is in official fuel poverty, then you will need to use the total annual energy costs as calculated by an energy assessment of a dwelling. If you are using actual expenditure on fuel to determine a households fuel poverty status, then you should be aware that this does not follow the official methodology for calculating fuel poverty.\n\nHowever, in the majority of cases (for various reasons) the amount people spend on their fuel bills will be lower than the amount required to be spent to heat homes to 'adequate' levels. Therefore, if you do use a household's actual fuel expenditure and find that that household is in fuel poverty, then it is likely that the household would also be in fuel poverty according to the official definition."]
[]
[]
[null,{"$f":"IFERROR(IF(E45/E30>0.2, \"Your household is living in severe fuel poverty\",IF(E45/E30>0.1,\"Your household is living in fuel poverty\",IF(AND(E45/E30>0.08, E45/E30<=0.1),\"Your household is not fuel poor but is at risk of fuel poverty\",\"Your household is not fuel poor\"))),\"\")","v":""}]
[null,"% of household income (before housing costs) spent on fuel",null,null,{"$f":"IFERROR(E45/E30,\"\")","v":""}]

{"sheet":"FPCalculationForm Scotland","index":4,"n_rows":88,"n_cols":6,"rows_kept":88,"merged":[[2,1,4,5],[30,2,30,3],[31,2,31,3],[32,2,32,3],[33,2,33,3],[34,2,34,3],[35,2,35,3],[42,2,42,3],[43,2,43,3],[47,2,47,3],[48,2,48,3],[52,2,52,3],[55,2,55,4],[62,2,62,3],[66,2,66,3],[71,2,71,3],[73,2,73,3],[74,2,74,3],[76,2,76,3],[80,2,80,3],[82,1,84,5],[85,1,85,5],[85,6,86,8],[86,1,86,3],[86,4,86,5],[87,1,87,3],[87,4,87,5],[87,6,87,8],[88,1,88,5],[91,2,91,6]]}
[]
[]
[null,"FUEL POVERTY CALCULATION FORM"]
[]
[]
[]
[null,null,"Title"]
[null,null,"First name"]
[null,null,"Surname"]
[null,null,"Flat number"]
[null,null,"Building name"]
[null,null,"Building number"]
[null,null,"Street"]
[null,null,"District"]
[null,null,"Town"]
[null,null,"County"]
[null,null,"Post code"]
[]
[]
[null,null,"Household income"]
[null,null,"Monthly income from paid or self employment (less tax & NI)"]
[null,null,"Monthly income from non-disability state benefits1 and tax credits"]
[null,null,"Monthly income from disability benefits2"]
[null,null,"Monthly income from any pension received"]
[]
[null,null,"Monthly interest from savings or investments"]
[]
[null,null,"Annual council tax bill"]
[null,null,"Amount of Pension Age Winter Heating Payment received3"]
[]
[null,null,"Annual net household income",null,{"$f":"12*(E21+E22+E23+E24+E26)-E28+E29","v":{"v":0,"d":"£0"}},"(INC1)"]
[null,null,"\n(Any income should take into account tax and NI deductions)"]
[null,null,"1 Also include housing related benefits, Council Tax Support/Reduction, and Mortage Payment Protection Insurance (MPPI)."]
[null,null,"2 Adult Disability Payment, Scottish Adult Disability Living Allowance, and Pension Age Disability Payment."]
[]
[null,null,"3Pension Age Winter Heating Payment varies between £100 and £300. Check here for the correct amount: "]
[null,null,"www.mygov.scot/pension-age-winter-heating-payment/how-much-you-might-be-paid"]
[]
[]
[null,null,"Housing Costs"]
[null,null,"mortgage payments"]
[null,null,"If you have a mortgage, how much do you pay in each installment?"]
[null,null,"How often a year do you make these payments (i.e. If weekly enter '52', monthly enter '12', quarterly enter '4')"]
[null,null,"Annual mortgage payments",null,{"$f":"E42*E43","v":{"v":0,"d":"£0"}}]
[]
[null,null,"rent payments"]
[null,null,"If you pay rent, how much do you pay each installment?"]
[null,null,"How often a year do you make these payments (i.e. If weekly enter '52', monthly enter '12', quarterly enter '4')"]
[null,null,"Annual rent payments",null,{"$f":"E47*E48","v":{"v":0,"d":"£0"}}]
[]
[null,null,"What are your household's annual water and sewerage costs?"]
[]
[null,null,"Annual income (after housing costs)",null,{"$f":"E31-E44-E49-E51","v":{"v":0,"d":"£0"}}]
[]
[]
[null,null,"Fuel costs\n(Enter monthly costs. So, if for example you pay quarterly, divide this amount by 3.)"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"What do you pay for other fuels each month?"]
[]
[null,null,"Do you receive the Warm Home Discount?"]
[null,null,"https://www.gov.uk/the-warm-home-discount-scheme"]
[null,null,"Annual fuel costs",null,{"$f":"(E57+E58+E59)*12-IF(E61=\"yes\",150,0)","v":{"v":0,"d":"£0"}}]
[]
[]
[null,null,"Household size"]
[null,null,"How many children of the following ages regularly live in your household?"]
[null,null,"0-1 years old"]
[null,null,"2-4 years old"]
[null,null,"Primary School"]
[null,null,"Secondary School"]
[null,null,"Total number of children",null,{"$f":"SUM(E68:E71)","v":0}]
[]
[null,null,"How many non-pensioner adults are regularly living in your household?"]
[null,null,"How many pensioners are regularly living in your household?"]
[]
[null,null,"Total number of people regularly living in household",null,{"$f":"SUM(E74:E75,E72)","v":0}]
[]
[]
[null,null,"Childcare costs"]
[null,null,"What are your household's annual childcare costs?"]
[]
[null,"Official fuel poverty definition in Scotland (2019-)\n\nA household is in fuel poverty if -\n(a) the fuel costs necessary for the home in which members of the household live to meet reasonable fuel needs are more than 10% of the household’s adjusted net income, and\n(b) after deducting such fuel costs, benefits received for a care need or disability (if any) and the household’s childcare costs (if any), the household’s remaining adjusted net income is insufficient to maintain an acceptable standard of living for members of the household.\n\nFurther, a household is in extreme fuel poverty if (a) the fuel costs necessary for the home in which members of the household live to meet reasonable fuel needs are more than 20% of the household's adjusted net income, and (b) is met, as above.\n\nThe threshold for an 'acceptable standard of living' is defined as 90% of the Minimum Income Standard (MIS). The MIS thresholds have been sourced from the online Minimum Income Calculator (https://www.minimumincome.org.uk/). Where this calculator doesn't cover a household type, factors have been determined and applied based on a small selection of the households which are applied to less common household types. These factors don't adjust for rural households or different aged children, and so only forms as estimate as to whether a household falls into fuel poverty in Scotland.\n\nTo calculate the official fuel poverty status of a household, the annual fuel costs must be those that are required to be spent in order to provide an 'adequate level of warmth' in the dwelling, as defined in section 3 of the Fuel Poverty (Targets, Definition and Strategy) (Scotland) Act 2019.\n\nIf you wish to use this tool to calculate whether a household is in official fuel poverty, then you will need to use the total annual energy costs as calculated by an energy assessment of a dwelling. If you are using actual expenditure on fuel to determine a households fuel poverty status, then you should be aware that this does not follow the official methodology for calculating fuel poverty.\n\nHowever, in the majority of cases (for various reasons) the amount people spend on their fuel bills will be lower than the amount required to be spent to heat homes to 'adequate' levels. Therefore, if you do use a household's actual fuel expenditure and find that that household is in fuel poverty, then it is likely that the household would also be in fuel poverty according to the official definition."]
[]
[]
[null,{"$f":"IFERROR(IF(E77=0,\"MISSING VALUE - HOUSEHOLD SIZE\",IF(E31=0,\"MISSING VALUE - HOUSEHOLD INCOME\",IF(params_sco!C19+params_sco!C21=2,\"Your household is living in extreme fuel poverty\",IF(params_sco!C18+params_sco!C21=2,\"Your household is living in fuel poverty\",\"Your household is not fuel poor\")))),\"Your household is not fuel poor\")","v":"MISSING VALUE - HOUSEHOLD SIZE"}]
[null,{"$f":"IFERROR(IF(params_sco!C18+params_sco!C21=2,\"Your annual 'fuel poverty gap' is:\",\"\"),\"\")","v":""},null,null,{"$f":"IFERROR(IF(params_sco!C18+params_sco!C21=2,MIN(params_sco!C23,params_sco!C24),\"\"),\"\")","v":""}]
[null,"% of household income (after housing costs) spent on fuel   ",null,null,{"$f":"IFERROR('FPCalculationForm Scotland'!E63/'FPCalculationForm Scotland'!E53,\"\")","v":""}]

{"sheet":"params_eng","index":5,"n_rows":26,"n_cols":10,"rows_kept":26,"hidden":true}
[]
[]
[null,"Needs annual update/check"]
[null,"Equivalised required fuel costs (£)","Equivalised AHC income (£)"]
[null,"Weighted median","Weighted median"]
[null,{"v":2242,"d":"2242.00"},{"v":30733,"d":"30733.00"}]
[]
[{"$nulls":4},"FUEL COST EQUIV FACTORS",null,null,"INCOME EQUIV FACTORS"]
[null,"Thresholds",{"$nulls":3},"factor",null,null,"factor","factorCalc"]
[null,"Relative low income threshold (60% of median equivalised AHC income)",{"$f":"C6*0.6","v":{"v":18439.8,"d":"£18,439.80"}},1,"1 person",0.82,null,"Initial factor for first adult (HRP)",0.58,{"$f":"IF('FPCalculationForm England'!E67=0,0,I10)","v":{"v":0,"d":"0.00"}}]
[null,"Fuel cost threshold",{"$f":"B6","v":{"v":2242,"d":"£2,242.00"}},2,"2 people",{"v":1,"d":"1.00"},null,"Additional factor for any other adults (14 or over)",0.42,{"$f":"IF('FPCalculationForm England'!E64>1,('FPCalculationForm England'!E64-1)*I11,0)","v":{"v":0,"d":"0.00"}}]
[null,"Relative low income threshold plus fuel cost threshold",{"$f":"C11+C10","v":{"v":20681.8,"d":"£20,681.80"}},3,"3 people",1.07,null,"Factor for children (under 14)",{"v":0.2,"d":"0.20"},{"$f":"IF('FPCalculationForm England'!E65=0,0,('FPCalculationForm England'!E65*I12))","v":{"v":0,"d":"0.00"}}]
[{"$nulls":3},4,"4 people",1.21,{"$nulls":3},{"$f":"SUM(J10:J12)","v":{"v":0,"d":"0.00"}}]
[null,"Calculations",null,5,"5 or more people",1.32]
["LILEE","Is FPEER likely to be below 68.5 (based on EPC band below C)?",{"$f":"IF(OR('FPCalculationForm England'!E75=\"A\",'FPCalculationForm England'!E75=\"B\",'FPCalculationForm England'!E75=\"C\"),0,1)","v":1},null,null,{"$f":"IFERROR(VLOOKUP(IF('FPCalculationForm England'!E67>5,5,'FPCalculationForm England'!E67),D10:F14,3),\"\")","v":""}]
["LIHC","Is annual equivalised fuel costs greater than fuel cost threshold?",{"$f":"IF('FPCalculationForm England'!E69>C11,1,0)","v":0}]
[null,"Equivalised AHC income minus equivalised fuel costs",{"$f":"'FPCalculationForm England'!E71-'FPCalculationForm England'!E69","v":{"v":0,"d":"£0.00"}}]
["LIHC and LILEE","Is the above value below the relative low income threshold?",{"$f":"IF(C17<C10,1,0)","v":1},null,"Warm home discount dropdown","EPC bands",null,"Title dropdown"]
[{"$nulls":4},"Yes","A",null,"Mrs"]
[{"$nulls":4},"No","B",null,"Mr"]
[{"$nulls":5},"C",null,"Miss"]
[{"$nulls":5},"D",null,"Ms"]
[{"$nulls":5},"E",null,"Mx"]
[{"$nulls":5},"F",null,"Dr"]
[{"$nulls":5},"G",null,"Prof"]
[{"$nulls":7},"Rev"]

{"sheet":"params_sco","index":6,"n_rows":134,"n_cols":8,"rows_kept":134,"hidden":true}
[]
[]
[null,"Needs annual update/check"]
[null,"MIS baseline (£)"]
[null,{"$f":"'Scotland MIS Backing'!M4","v":34275.28}]
[]
[{"$nulls":4},"SCOTTISH INCOME EQUIV FACTORS"]
[null,"Thresholds",{"$nulls":3},"Factor","Factor Calc"]
[null,"Minimum income standard",{"$f":"IF(C14=1,_xlfn.XLOOKUP(1,(B28:B134='FPCalculationForm Scotland'!E74)*(params_sco!C28:C134='FPCalculationForm Scotland'!E75)*(params_sco!D28:D134='FPCalculationForm Scotland'!E68)*(params_sco!E28:E134='FPCalculationForm Scotland'!E69)*(params_sco!F28:F134='FPCalculationForm Scotland'!E70)*(params_sco!G28:G134='FPCalculationForm Scotland'!E71),params_sco!H28:H134),B5*G14)","v":{"$error":"#N/A"}},null,"Initial adult (HRP)",0.66,{"$f":"IF('FPCalculationForm Scotland'!E74>0,params_sco!F9,0)","v":{"v":0,"d":"0.00"}}]
[null,"90% of minimum income standard",{"$f":"C9*0.9","v":{"$error":"#N/A"}},null,"Additional factor for any other adults (anyone who has completed secondary school)",0.34,{"$f":"IF('FPCalculationForm Scotland'!E74>1,params_sco!F10*('FPCalculationForm Scotland'!E74-1),0)","v":{"v":0,"d":"0.00"}}]
[null,"Table Check 1 (pensioners)",{"$f":"IF(AND('FPCalculationForm Scotland'!E75<3,'FPCalculationForm Scotland'!E74=0,'FPCalculationForm Scotland'!E72=0),1,0)","v":1},null,"Factor for children",0.41,{"$f":"IF('FPCalculationForm Scotland'!E72>0,params_sco!F11*'FPCalculationForm Scotland'!E72, 0)","v":{"v":0,"d":"0.00"}}]
[null,"Table Check 2 (single parent)",{"$f":"IF(AND('FPCalculationForm Scotland'!E74=1,'FPCalculationForm Scotland'!E72<=3,'FPCalculationForm Scotland'!E75=0),1,0)","v":0},null,"Factor for pensioners HRP",0.53,{"$f":"IF(AND('FPCalculationForm Scotland'!E74=0,'FPCalculationForm Scotland'!E75>0),params_sco!F12,0)","v":{"v":0,"d":"0.00"}}]
[null,"Table Check 3 (2 parents)",{"$f":"IF(AND('FPCalculationForm Scotland'!E74=2,'FPCalculationForm Scotland'!E72<=4,'FPCalculationForm Scotland'!E75=0),1,0)","v":0},null,"Additional factor for pensioners",0.27,{"$f":"_xlfn.IFS(AND('FPCalculationForm Scotland'!E74=0,'FPCalculationForm Scotland'!E75>1),params_sco!F13*('FPCalculationForm Scotland'!E75-1),AND('FPCalculationForm Scotland'!E74>0,'FPCalculationForm Scotland'!E75>0),params_sco!F13*'FPCalculationForm Scotland'!E75,TRUE,0)","v":{"v":0,"d":"0.00"}}]
[null,"MIS calculator valid?",{"$f":"IF(SUM(C11:C13)=1,1,0)","v":1},{"$nulls":3},{"$f":"SUM(G9:G13)","v":{"v":0,"d":"0.00"}}]
[]
[{"$nulls":4},"Warm home discount dropdown"]
[null,"Calculations",null,null,"Yes"]
[null,"Is more than 10% of net income AHC required to pay for fuel? (Fuel poverty) (clause a)",{"$f":"IF(('FPCalculationForm Scotland'!E63/'FPCalculationForm Scotland'!E53)>0.1,1,0)","v":{"$error":"#DIV/0!"}},null,"No"]
[null,"Is more than 20% of net income AHC required to pay for fuel? (Extreme fuel poverty)",{"$f":"IF(('FPCalculationForm Scotland'!E63/'FPCalculationForm Scotland'!E53)>0.2,1,0)","v":{"$error":"#DIV/0!"}}]
[null,"Remaining income after removing fuel costs, disability benefits, and childcare costs",{"$f":"'FPCalculationForm Scotland'!E53-'FPCalculationForm Scotland'!E63-'FPCalculationForm Scotland'!E23*12-'FPCalculationForm Scotland'!E81","v":{"v":0,"d":"£0.00"}}]
[null,"Is this below 90% of minimum income standard? (clause b)",{"$f":"IF(C20<C10,1,0)","v":{"$error":"#N/A"}}]
[null,"10% of the household's adjusted net income",{"$f":"0.1*'FPCalculationForm Scotland'!E53","v":{"v":0,"d":"£0.00"}}]
[null,"Fuel gap definition 1",{"$f":"'FPCalculationForm Scotland'!E63-C22","v":{"v":0,"d":"£0.00"}}]
[null,"Fuel gap definition 2",{"$f":"C10-C20","v":{"$error":"#N/A"}}]
[]
[null,"Adjusted MIS Calculator outputs"]
[null,"No. adults","No.pensioners","No children (0-1)","No. children (2-4)","No. children (primary)","No.children (secondary)","MIS Calculator figure"]
[null,0,1,0,0,0,0,18150.08]
[null,0,2,0,0,0,0,27332.76]
[null,1,0,0,0,0,0,22763.52]
[null,2,0,0,0,0,0,34275.28]
[null,1,0,1,0,0,0,46595.64]
[null,2,0,1,0,0,0,55435.64]
[null,1,0,2,0,0,0,65447.719999999994]
[null,2,0,2,0,0,0,73957.52]
[null,1,0,3,0,0,0,86336.12]
[null,2,0,3,0,0,0,94092.96]
[null,2,0,0,0,0,4,75968.88]
[null,1,0,0,1,0,0,41772.64]
[null,2,0,0,1,0,0,50612.64]
[null,1,0,1,1,0,0,60630.96]
[null,2,0,1,1,0,0,69140.76000000001]
[null,1,0,2,1,0,0,81519.36]
[null,2,0,2,1,0,0,89276.2]
[null,2,0,0,0,1,3,77309.96]
[null,1,0,0,2,0,0,55804.840000000004]
[null,2,0,0,2,0,0,64314.64]
[null,1,0,1,2,0,0,76699.48]
[null,2,0,1,2,0,0,84456.32]
[null,2,0,0,0,2,2,78602.68]
[null,1,0,0,3,0,0,71873.36]
[null,2,0,0,3,0,0,79630.2]
[null,2,0,0,0,4,0,81168.88]
[null,2,0,0,0,3,1,79918.28]
[null,1,0,0,0,1,0,39788.32]
[null,2,0,0,0,1,0,48316.84]
[null,1,0,1,0,1,0,58773]
[null,2,0,1,0,1,0,66970.8]
[null,1,0,2,0,1,0,78486.72]
[null,2,0,2,0,1,0,85932.08]
[null,2,0,0,1,0,3,80208.44]
[null,1,0,0,1,1,0,53946.880000000005]
[null,2,0,0,1,1,0,62144.67999999999]
[null,1,0,1,1,1,0,73666.84]
[null,2,0,1,1,1,0,81112.2]
[null,2,0,0,1,1,2,81501.68]
[null,1,0,0,2,1,0,68840.72]
[null,2,0,0,2,1,0,76286.08]
[null,2,0,0,1,2,1,82817.28]
[null,2,0,0,1,3,0,84067.88]
[null,1,0,0,0,2,0,51295.92]
[null,2,0,0,0,2,0,59181.719999999994]
[null,1,0,1,0,2,0,71206.2]
[null,2,0,1,0,2,0,78339.56]
[null,2,0,0,2,0,2,84274.32]
[null,1,0,0,1,2,0,66380.08]
[null,2,0,0,1,2,0,73513.44]
[null,2,0,1,0,0,3,85031.44]
[null,2,0,0,2,1,1,85589.92]
[null,1,0,0,0,3,0,63793.6]
[null,2,0,0,0,3,0,70614.44]
[null,2,0,1,0,1,2,86327.8]
[null,2,0,0,2,2,0,86840.52]
[null,2,0,1,0,2,1,87643.40000000001]
[null,1,0,0,0,0,1,38262.119999999995]
[null,2,0,0,0,0,1,47102.119999999995]
[null,1,0,1,0,0,1,57268.64]
[null,2,0,1,0,0,1,65778.44]
[null,1,0,2,0,0,1,75869.56]
[null,2,0,2,0,0,1,84678.36]
[null,2,0,0,3,0,1,88308.48]
[null,1,0,0,1,0,1,52445.64]
[null,2,0,0,1,0,1,63189.880000000005]
[null,1,0,1,1,0,1,71052.8]
[null,2,0,1,1,0,1,79861.59999999999]
[null,2,0,1,0,3,0,88894]
[null,1,0,0,2,0,1,66226.68]
[null,2,0,0,2,0,1,75035.48]
[null,2,0,1,1,0,2,89100.44]
[null,2,0,0,3,1,0,89558.56]
[null,1,0,0,0,1,1,49794.68]
[null,2,0,0,0,1,1,57992.48]
[null,1,0,1,0,1,1,68528.2]
[null,2,0,1,0,1,1,77088.96]
[null,2,0,1,1,1,1,90416.04]
[null,1,0,0,1,1,1,63702.08]
[null,2,0,0,1,1,1,72262.84]
[null,2,0,1,1,2,0,91666.64]
[null,2,0,0,4,0,0,92903.2]
[null,1,0,0,0,2,1,61051.64]
[null,2,0,0,0,2,1,69364.36]
[null,2,0,1,2,0,1,93134.59999999999]
[null,2,0,2,0,0,2,93917.2]
[null,2,0,1,2,1,0,94384.68]
[null,1,0,0,0,0,2,48202.96]
[null,2,0,0,0,0,2,56712.76000000001]
[null,1,0,1,0,0,2,66958.32]
[null,2,0,1,0,0,2,75770.23999999999]
[null,2,0,2,0,1,1,95235.92]
[null,1,0,0,1,0,2,62135.32000000001]
[null,2,0,0,1,0,2,70947.23999999999]
[null,2,0,2,0,2,0,96486.52]
[null,2,0,1,3,0,0,97729.32]
[null,1,0,0,0,1,2,59484.36]
[null,2,0,0,0,1,2,68048.23999999999]
[null,2,0,2,1,0,1,97954.48]
[null,2,0,2,1,1,0,99204.56]
[null,2,0,2,2,0,0,102549.2]
[null,1,0,0,0,0,3,57915.52]
[null,2,0,0,0,0,3,65671.32]
[null,2,0,3,0,0,1,102771.23999999999]
[null,2,0,3,0,1,0,104024.44]
[null,2,0,3,1,0,0,107369.08]
[null,2,0,4,0,0,0,112239.92]

{"sheet":"Scotland MIS Backing","index":7,"n_rows":108,"n_cols":13,"rows_kept":108,"hidden":true}
["No. adults","No.pensioners","No children (0-1)","No. children (2-4)","No. children (primary)","No.children (secondary)","Total children","Weekly MIS","Annual MIS",null,null,"Factor calculation:"]
[0,1,0,0,0,0,0,{"v":349.04,"d":"£349.04"},{"$f":"H2*52","v":{"v":18150.08,"d":"£18,150.08"}}]
[0,2,0,0,0,0,0,{"v":525.63,"d":"£525.63"},{"$f":"H3*52","v":{"v":27332.76,"d":"£27,332.76"}},null,null,"Single Adult:",{"$f":"_xlfn.XLOOKUP(1,(A:A=1)*(B:B=0)*(G:G=0),I:I)","v":{"v":22763.52,"d":"£22,763.52"}}]
[1,0,0,0,0,0,0,{"v":437.76,"d":"£437.76"},{"v":22763.52,"d":"£22,763.52"},null,null,"Adult couple:",{"$f":"_xlfn.XLOOKUP(1,(A:A=2)*(B:B=0)*(G:G=0),I:I)","v":{"v":34275.28,"d":"£34,275.28"}}]
[2,0,0,0,0,0,0,{"v":659.14,"d":"£659.14"},{"v":34275.28,"d":"£34,275.28"},null,null,"Single pensioner:",{"$f":"_xlfn.XLOOKUP(1,(A:A=0)*(B:B=1)*(G:G=0),I:I)","v":{"v":18150.08,"d":"£18,150.08"}}]
[1,0,1,0,0,0,1,{"v":896.07,"d":"£896.07"},{"v":46595.64,"d":"£46,595.64"},null,null,"Pensioner couple:",{"$f":"_xlfn.XLOOKUP(1,(A:A=0)*(B:B=2)*(G:G=0),I:I)","v":{"v":27332.76,"d":"£27,332.76"}}]
[2,0,1,0,0,0,1,{"v":1066.07,"d":"£1,066.07"},{"v":55435.64,"d":"£55,435.64"},null,null,"Adult couple 2 children (0-2, primary):",{"$f":"_xlfn.XLOOKUP(1,(A:A=2)*(B:B=0)*(D:D=1)*(E:E=1),I:I)","v":{"v":62144.67999999999,"d":"£62,144.68"}}]
[1,0,2,0,0,0,2,{"v":1258.61,"d":"£1,258.61"},{"v":65447.719999999994,"d":"£65,447.72"}]
[2,0,2,0,0,0,2,{"v":1422.26,"d":"£1,422.26"},{"v":73957.52,"d":"£73,957.52"},null,null,"HRP Adult:",{"$f":"M3/M4","v":{"v":0.6641381193676609,"d":"0.66"}}]
[1,0,3,0,0,0,3,{"v":1660.31,"d":"£1,660.31"},{"v":86336.12,"d":"£86,336.12"},null,null,"Additional adult:",{"$f":"1-M9","v":{"v":0.3358618806323391,"d":"0.34"}}]
[2,0,3,0,0,0,3,{"v":1809.48,"d":"£1,809.48"},{"v":94092.96,"d":"£94,092.96"},null,null,"HRP pensioner:",{"$f":"M5/M4","v":{"v":0.5295384895469856,"d":"0.53"}}]
[2,0,0,0,0,4,4,{"v":1460.94,"d":"£1,460.94"},{"v":75968.88,"d":"£75,968.88"},null,null,"Additional pensioner:",{"$f":"(M6-M5)/M4","v":{"v":0.2679097005188578,"d":"0.27"}}]
[1,0,0,1,0,0,1,{"v":803.32,"d":"£803.32"},{"v":41772.64,"d":"£41,772.64"},null,null,"Child:",{"$f":"((M7-M4)/2)/M4","v":{"v":0.4065524774706435,"d":"0.41"}}]
[2,0,0,1,0,0,1,{"v":973.32,"d":"£973.32"},{"v":50612.64,"d":"£50,612.64"}]
[1,0,1,1,0,0,2,{"v":1165.98,"d":"£1,165.98"},{"v":60630.96,"d":"£60,630.96"}]
[2,0,1,1,0,0,2,{"v":1329.63,"d":"£1,329.63"},{"v":69140.76000000001,"d":"£69,140.76"}]
[1,0,2,1,0,0,3,{"v":1567.68,"d":"£1,567.68"},{"v":81519.36,"d":"£81,519.36"}]
[2,0,2,1,0,0,3,{"v":1716.85,"d":"£1,716.85"},{"v":89276.2,"d":"£89,276.20"}]
[2,0,0,0,1,3,4,{"v":1486.73,"d":"£1,486.73"},{"v":77309.96,"d":"£77,309.96"}]
[1,0,0,2,0,0,2,{"v":1073.17,"d":"£1,073.17"},{"v":55804.840000000004,"d":"£55,804.84"}]
[2,0,0,2,0,0,2,{"v":1236.82,"d":"£1,236.82"},{"v":64314.64,"d":"£64,314.64"}]
[1,0,1,2,0,0,3,{"v":1474.99,"d":"£1,474.99"},{"v":76699.48,"d":"£76,699.48"}]
[2,0,1,2,0,0,3,{"v":1624.16,"d":"£1,624.16"},{"v":84456.32,"d":"£84,456.32"}]
[2,0,0,0,2,2,4,{"v":1511.59,"d":"£1,511.59"},{"v":78602.68,"d":"£78,602.68"}]
[1,0,0,3,0,0,3,{"v":1382.18,"d":"£1,382.18"},{"v":71873.36,"d":"£71,873.36"}]
[2,0,0,3,0,0,3,{"v":1531.35,"d":"£1,531.35"},{"v":79630.2,"d":"£79,630.20"}]
[2,0,0,0,4,0,4,{"v":1560.94,"d":"£1,560.94"},{"v":81168.88,"d":"£81,168.88"}]
[2,0,0,0,3,1,4,{"v":1536.89,"d":"£1,536.89"},{"v":79918.28,"d":"£79,918.28"}]
[1,0,0,0,1,0,1,{"v":765.16,"d":"£765.16"},{"v":39788.32,"d":"£39,788.32"}]
[2,0,0,0,1,0,1,{"v":929.17,"d":"£929.17"},{"v":48316.84,"d":"£48,316.84"}]
[1,0,1,0,1,0,2,{"v":1130.25,"d":"£1,130.25"},{"v":58773,"d":"£58,773.00"}]
[2,0,1,0,1,0,2,{"v":1287.9,"d":"£1,287.90"},{"v":66970.8,"d":"£66,970.80"}]
[1,0,2,0,1,0,3,{"v":1509.36,"d":"£1,509.36"},{"v":78486.72,"d":"£78,486.72"}]
[2,0,2,0,1,0,3,{"v":1652.54,"d":"£1,652.54"},{"v":85932.08,"d":"£85,932.08"}]
[2,0,0,1,0,3,4,{"v":1542.47,"d":"£1,542.47"},{"v":80208.44,"d":"£80,208.44"}]
[1,0,0,1,1,0,2,{"v":1037.44,"d":"£1,037.44"},{"v":53946.880000000005,"d":"£53,946.88"}]
[2,0,0,1,1,0,2,{"v":1195.09,"d":"£1,195.09"},{"v":62144.67999999999,"d":"£62,144.68"}]
[1,0,1,1,1,0,3,{"v":1416.67,"d":"£1,416.67"},{"v":73666.84,"d":"£73,666.84"}]
[2,0,1,1,1,0,3,{"v":1559.85,"d":"£1,559.85"},{"v":81112.2,"d":"£81,112.20"}]
[2,0,0,1,1,2,4,{"v":1567.34,"d":"£1,567.34"},{"v":81501.68,"d":"£81,501.68"}]
[1,0,0,2,1,0,3,{"v":1323.86,"d":"£1,323.86"},{"v":68840.72,"d":"£68,840.72"}]
[2,0,0,2,1,0,3,{"v":1467.04,"d":"£1,467.04"},{"v":76286.08,"d":"£76,286.08"}]
[2,0,0,1,2,1,4,{"v":1592.64,"d":"£1,592.64"},{"v":82817.28,"d":"£82,817.28"}]
[2,0,0,1,3,0,4,{"v":1616.69,"d":"£1,616.69"},{"v":84067.88,"d":"£84,067.88"}]
[1,0,0,0,2,0,2,{"v":986.46,"d":"£986.46"},{"v":51295.92,"d":"£51,295.92"}]
[2,0,0,0,2,0,2,{"v":1138.11,"d":"£1,138.11"},{"v":59181.719999999994,"d":"£59,181.72"}]
[1,0,1,0,2,0,3,{"v":1369.35,"d":"£1,369.35"},{"v":71206.2,"d":"£71,206.20"}]
[2,0,1,0,2,0,3,{"v":1506.53,"d":"£1,506.53"},{"v":78339.56,"d":"£78,339.56"}]
[2,0,0,2,0,2,4,{"v":1620.66,"d":"£1,620.66"},{"v":84274.32,"d":"£84,274.32"}]
[1,0,0,1,2,0,3,{"v":1276.54,"d":"£1,276.54"},{"v":66380.08,"d":"£66,380.08"}]
[2,0,0,1,2,0,3,{"v":1413.72,"d":"£1,413.72"},{"v":73513.44,"d":"£73,513.44"}]
[2,0,1,0,0,3,4,{"v":1635.22,"d":"£1,635.22"},{"v":85031.44,"d":"£85,031.44"}]
[2,0,0,2,1,1,4,{"v":1645.96,"d":"£1,645.96"},{"v":85589.92,"d":"£85,589.92"}]
[1,0,0,0,3,0,3,{"v":1226.8,"d":"£1,226.80"},{"v":63793.6,"d":"£63,793.60"}]
[2,0,0,0,3,0,3,{"v":1357.97,"d":"£1,357.97"},{"v":70614.44,"d":"£70,614.44"}]
[2,0,1,0,1,2,4,{"v":1660.15,"d":"£1,660.15"},{"v":86327.8,"d":"£86,327.80"}]
[2,0,0,2,2,0,4,{"v":1670.01,"d":"£1,670.01"},{"v":86840.52,"d":"£86,840.52"}]
[2,0,1,0,2,1,4,{"v":1685.45,"d":"£1,685.45"},{"v":87643.40000000001,"d":"£87,643.40"}]
[1,0,0,0,0,1,1,{"v":735.81,"d":"£735.81"},{"v":38262.119999999995,"d":"£38,262.12"}]
[2,0,0,0,0,1,1,{"v":905.81,"d":"£905.81"},{"v":47102.119999999995,"d":"£47,102.12"}]
[1,0,1,0,0,1,2,{"v":1101.32,"d":"£1,101.32"},{"v":57268.64,"d":"£57,268.64"}]
[2,0,1,0,0,1,2,{"v":1264.97,"d":"£1,264.97"},{"v":65778.44,"d":"£65,778.44"}]
[1,0,2,0,0,1,3,{"v":1459.03,"d":"£1,459.03"},{"v":75869.56,"d":"£75,869.56"}]
[2,0,2,0,0,1,3,{"v":1628.43,"d":"£1,628.43"},{"v":84678.36,"d":"£84,678.36"}]
[2,0,0,3,0,1,4,{"v":1698.24,"d":"£1,698.24"},{"v":88308.48,"d":"£88,308.48"}]
[1,0,0,1,0,1,2,{"v":1008.57,"d":"£1,008.57"},{"v":52445.64,"d":"£52,445.64"}]
[2,0,0,1,0,1,2,{"v":1215.19,"d":"£1,215.19"},{"$f":"H67*52","v":{"v":63189.880000000005,"d":"£63,189.88"}}]
[1,0,1,1,0,1,3,{"v":1366.4,"d":"£1,366.40"},{"v":71052.8,"d":"£71,052.80"}]
[2,0,1,1,0,1,3,{"v":1535.8,"d":"£1,535.80"},{"v":79861.59999999999,"d":"£79,861.60"}]
[2,0,1,0,3,0,4,{"v":1709.5,"d":"£1,709.50"},{"v":88894,"d":"£88,894.00"}]
[1,0,0,2,0,1,3,{"v":1273.59,"d":"£1,273.59"},{"v":66226.68,"d":"£66,226.68"}]
[2,0,0,2,0,1,3,{"v":1442.99,"d":"£1,442.99"},{"v":75035.48,"d":"£75,035.48"}]
[2,0,1,1,0,2,4,{"v":1713.47,"d":"£1,713.47"},{"v":89100.44,"d":"£89,100.44"}]
[2,0,0,3,1,0,4,{"v":1722.28,"d":"£1,722.28"},{"v":89558.56,"d":"£89,558.56"}]
[1,0,0,0,1,1,2,{"v":957.59,"d":"£957.59"},{"v":49794.68,"d":"£49,794.68"}]
[2,0,0,0,1,1,2,{"v":1115.24,"d":"£1,115.24"},{"v":57992.48,"d":"£57,992.48"}]
[1,0,1,0,1,1,3,{"v":1317.85,"d":"£1,317.85"},{"v":68528.2,"d":"£68,528.20"}]
[2,0,1,0,1,1,3,{"v":1482.48,"d":"£1,482.48"},{"v":77088.96,"d":"£77,088.96"}]
[2,0,1,1,1,1,4,{"v":1738.77,"d":"£1,738.77"},{"v":90416.04,"d":"£90,416.04"}]
[1,0,0,1,1,1,3,{"v":1225.04,"d":"£1,225.04"},{"v":63702.08,"d":"£63,702.08"}]
[2,0,0,1,1,1,3,{"v":1389.67,"d":"£1,389.67"},{"v":72262.84,"d":"£72,262.84"}]
[2,0,1,1,2,0,4,{"v":1762.82,"d":"£1,762.82"},{"v":91666.64,"d":"£91,666.64"}]
[2,0,0,4,0,0,4,{"v":1786.6,"d":"£1,786.60"},{"v":92903.2,"d":"£92,903.20"}]
[1,0,0,0,2,1,3,{"v":1174.07,"d":"£1,174.07"},{"v":61051.64,"d":"£61,051.64"}]
[2,0,0,0,2,1,3,{"v":1333.93,"d":"£1,333.93"},{"v":69364.36,"d":"£69,364.36"}]
[2,0,1,2,0,1,4,{"v":1791.05,"d":"£1,791.05"},{"v":93134.59999999999,"d":"£93,134.60"}]
[2,0,2,0,0,2,4,{"v":1806.1,"d":"£1,806.10"},{"v":93917.2,"d":"£93,917.20"}]
[2,0,1,2,1,0,4,{"v":1815.09,"d":"£1,815.09"},{"v":94384.68,"d":"£94,384.68"}]
[1,0,0,0,0,2,2,{"v":926.98,"d":"£926.98"},{"v":48202.96,"d":"£48,202.96"}]
[2,0,0,0,0,2,2,{"v":1090.63,"d":"£1,090.63"},{"v":56712.76000000001,"d":"£56,712.76"}]
[1,0,1,0,0,2,3,{"v":1287.66,"d":"£1,287.66"},{"v":66958.32,"d":"£66,958.32"}]
[2,0,1,0,0,2,3,{"v":1457.12,"d":"£1,457.12"},{"v":75770.23999999999,"d":"£75,770.24"}]
[2,0,2,0,1,1,4,{"v":1831.46,"d":"£1,831.46"},{"v":95235.92,"d":"£95,235.92"}]
[1,0,0,1,0,2,3,{"v":1194.91,"d":"£1,194.91"},{"v":62135.32000000001,"d":"£62,135.32"}]
[2,0,0,1,0,2,3,{"v":1364.37,"d":"£1,364.37"},{"v":70947.23999999999,"d":"£70,947.24"}]
[2,0,2,0,2,0,4,{"v":1855.51,"d":"£1,855.51"},{"v":96486.52,"d":"£96,486.52"}]
[2,0,1,3,0,0,4,{"v":1879.41,"d":"£1,879.41"},{"v":97729.32,"d":"£97,729.32"}]
[1,0,0,0,1,2,3,{"v":1143.93,"d":"£1,143.93"},{"v":59484.36,"d":"£59,484.36"}]
[2,0,0,0,1,2,3,{"v":1308.62,"d":"£1,308.62"},{"v":68048.23999999999,"d":"£68,048.24"}]
[2,0,2,1,0,1,4,{"v":1883.74,"d":"£1,883.74"},{"v":97954.48,"d":"£97,954.48"}]
[2,0,2,1,1,0,4,{"v":1907.78,"d":"£1,907.78"},{"v":99204.56,"d":"£99,204.56"}]
[2,0,2,2,0,0,4,{"v":1972.1,"d":"£1,972.10"},{"v":102549.2,"d":"£102,549.20"}]
[1,0,0,0,0,3,3,{"v":1113.76,"d":"£1,113.76"},{"v":57915.52,"d":"£57,915.52"}]
[2,0,0,0,0,3,3,{"v":1262.91,"d":"£1,262.91"},{"v":65671.32,"d":"£65,671.32"}]
[2,0,3,0,0,1,4,{"v":1976.37,"d":"£1,976.37"},{"v":102771.23999999999,"d":"£102,771.24"}]
[2,0,3,0,1,0,4,{"v":2000.47,"d":"£2,000.47"},{"v":104024.44,"d":"£104,024.44"}]
[2,0,3,1,0,0,4,{"v":2064.79,"d":"£2,064.79"},{"v":107369.08,"d":"£107,369.08"}]
[2,0,4,0,0,0,4,{"v":2158.46,"d":"£2,158.46"},{"v":112239.92,"d":"£112,239.92"}]

{"sheet":"Sheet3","index":8,"n_rows":2,"n_cols":27,"rows_kept":2,"hidden":true}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual mortgage payments","Annual rent payments","Annual income (after housing costs)","Annual fuel costs","Household size","Number of adults (>14 years)","Number of children (<14 years)","Annual equivalised fuel costs","Annual equivalised income (after housing costs)","EPC band","Warm Home Discount?","Fuel poverty status: LILEE definition","Fuel poverty status: LIHC definition","Fuel poverty gap: LIHC definition","Fuel poverty status: 10% definition"]
[{"$f":"IF('FPCalculationForm England'!$D$7=0,\"\",'FPCalculationForm England'!$D$7)","v":""},{"$f":"IF('FPCalculationForm England'!$D$8=0,\"\",'FPCalculationForm England'!$D$8)","v":""},{"$f":"IF('FPCalculationForm England'!$D$9=0,\"\",'FPCalculationForm England'!$D$9)","v":""},{"$f":"IF('FPCalculationForm England'!$D$10=0,\"\",'FPCalculationForm England'!$D$10)","v":""},{"$f":"IF('FPCalculationForm England'!$D$11=0,\"\",'FPCalculationForm England'!$D$11)","v":""},{"$f":"IF('FPCalculationForm England'!$D$12=0,\"\",'FPCalculationForm England'!$D$12)","v":""},{"$f":"IF('FPCalculationForm England'!$D$13=0,\"\",'FPCalculationForm England'!$D$13)","v":""},{"$f":"IF('FPCalculationForm England'!$D$14=0,\"\",'FPCalculationForm England'!$D$14)","v":""},{"$f":"IF('FPCalculationForm England'!$D$15=0,\"\",'FPCalculationForm England'!$D$15)","v":""},{"$f":"IF('FPCalculationForm England'!$D$16=0,\"\",'FPCalculationForm England'!$D$16)","v":""},{"$f":"IF('FPCalculationForm England'!$D$17=0,\"\",'FPCalculationForm England'!$D$17)","v":""},{"$f":"'FPCalculationForm England'!E30","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E43","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E48","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E50","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E60","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E67","v":0},{"$f":"'FPCalculationForm England'!E64","v":0},{"$f":"'FPCalculationForm England'!E65","v":0},{"$f":"'FPCalculationForm England'!E69","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm England'!E71","v":{"v":0,"d":"£0"}},{"$f":"IF('FPCalculationForm England'!E75=0,\"\",'FPCalculationForm England'!E75)","v":""},{"$f":"IF('FPCalculationForm England'!E58=0,\"\",'FPCalculationForm England'!E58)","v":""},{"$f":"'FPCalculationForm England'!B81","v":"MISSING VALUE - HOUSEHOLD SIZE"},{"$f":"'FPCalculationForm England'!B83","v":"MISSING VALUE - HOUSEHOLD SIZE"},{"$f":"'FPCalculationForm England'!E84","v":""},{"$f":"'FPCalculationForm England'!B85","v":""}]

{"sheet":"Sheet4","index":9,"n_rows":2,"n_cols":27,"rows_kept":2,"hidden":true}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual mortgage payments","Annual rent payments","Annual income (after housing costs)","Annual fuel costs","Household size","Number of children (0-1)","Number of children (2-4)","Number of children (primary)","Number of children (secondary)","Total number of children","Number of adults (non-pensioners)","Number of pensioners","Warm Home Discount?","Fuel poverty status","Fuel poverty gap"]
[{"$f":"IF('FPCalculationForm Scotland'!D7=0,\"\",'FPCalculationForm Scotland'!D7)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D8=0,\"\",'FPCalculationForm Scotland'!D8)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D9=0,\"\",'FPCalculationForm Scotland'!D9)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D10=0,\"\",'FPCalculationForm Scotland'!D10)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D11=0,\"\",'FPCalculationForm Scotland'!D11)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D12=0,\"\",'FPCalculationForm Scotland'!D12)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D13=0,\"\",'FPCalculationForm Scotland'!D13)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D14=0,\"\",'FPCalculationForm Scotland'!D14)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D15=0,\"\",'FPCalculationForm Scotland'!D15)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D16=0,\"\",'FPCalculationForm Scotland'!D16)","v":""},{"$f":"IF('FPCalculationForm Scotland'!D17=0,\"\",'FPCalculationForm Scotland'!D17)","v":""},{"$f":"'FPCalculationForm Scotland'!E31","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Scotland'!E44","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Scotland'!E49","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Scotland'!E53","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Scotland'!E63","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Scotland'!E77","v":0},{"$f":"IF('FPCalculationForm Scotland'!E68=0,0,'FPCalculationForm Scotland'!E68)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E69=0,0,'FPCalculationForm Scotland'!E69)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E70=0,0,'FPCalculationForm Scotland'!E70)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E71=0,0,'FPCalculationForm Scotland'!E71)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E72=0,0,'FPCalculationForm Scotland'!E72)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E74=0,0,'FPCalculationForm Scotland'!E74)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E75=0,0,'FPCalculationForm Scotland'!E75)","v":0},{"$f":"IF('FPCalculationForm Scotland'!E61=0,\"\",'FPCalculationForm Scotland'!E61)","v":""},{"$f":"'FPCalculationForm Scotland'!B86","v":"MISSING VALUE - HOUSEHOLD SIZE"},{"$f":"'FPCalculationForm Scotland'!E87","v":""}]

{"sheet":"Sheet5","index":10,"n_rows":2,"n_cols":15,"rows_kept":2,"hidden":true}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual fuel costs","Warm Home Discount?","Fuel poverty status"]
[{"$f":"IF('FPCalculationForm Wales'!$D$7=0,\"\",'FPCalculationForm Wales'!$D$7)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$8=0,\"\",'FPCalculationForm Wales'!$D$8)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$9=0,\"\",'FPCalculationForm Wales'!$D$9)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$10=0,\"\",'FPCalculationForm Wales'!$D$10)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$11=0,\"\",'FPCalculationForm Wales'!$D$11)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$12=0,\"\",'FPCalculationForm Wales'!$D$12)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$13=0,\"\",'FPCalculationForm Wales'!$D$13)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$14=0,\"\",'FPCalculationForm Wales'!$D$14)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$15=0,\"\",'FPCalculationForm Wales'!$D$15)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$16=0,\"\",'FPCalculationForm Wales'!$D$16)","v":""},{"$f":"IF('FPCalculationForm Wales'!$D$17=0,\"\",'FPCalculationForm Wales'!$D$17)","v":""},{"$f":"'FPCalculationForm Wales'!E30","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Wales'!E45","v":{"v":0,"d":"£0"}},{"$f":"'FPCalculationForm Wales'!E43","v":0},{"$f":"'FPCalculationForm Wales'!B50","v":""}]

{"sheet":"CommunityFPDatabase England","index":11,"n_rows":1,"n_cols":27,"rows_kept":1}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual mortgage payments","Annual rent payments","Annual income (after housing costs)","Annual fuel costs","Household size","Number of adults (>14 years)","Number of children (<14 years)","Annual equivalised fuel costs","Annual equivalised income (after housing costs)","EPC band","Warm Home Discount?","Fuel poverty status: LILEE definition","Fuel poverty status: LIHC definition","Fuel poverty gap: LIHC definition","Fuel poverty status: 10% definition"]

{"sheet":"CommunityFPDatabase Wales","index":12,"n_rows":1,"n_cols":15,"rows_kept":1}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual fuel costs","Warm Home Discount?","Fuel poverty status"]

{"sheet":"CommunityFPDatabase Scotland","index":13,"n_rows":1,"n_cols":27,"rows_kept":1}
["Title","First name","Surname","Flat number","Building name","Building number","Street","District","Town","County","Post code","Annual net household income","Annual mortgage payments","Annual rent payments","Annual income (after housing costs)","Annual fuel costs","Household size","Number of children (0-1)","Number of children (2-4)","Number of children (primary)","Number of children (secondary)","Total number of children","Number of adults (non-pensioners)","Number of pensioners","Warm Home Discount?","Fuel poverty status","Fuel poverty gap"]

{"sheet":"DataCollectionFormEng (PRINT)","index":14,"n_rows":102,"n_cols":5,"rows_kept":102,"merged":[[3,1,5,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[55,2,55,3]]}
[]
[]
[]
[null,"FUEL POVERTY DATA COLLECTION QUESTIONNAIRE"]
[]
[]
[]
[null,null,"Title:"]
[null,null,"First name:"]
[null,null,"Surname:"]
[null,null,"Flat Number:"]
[null,null,"Building name:"]
[null,null,"Building number:"]
[null,null,"Street:"]
[null,null,"District:"]
[null,null,"Town:"]
[null,null,"County:"]
[null,null,"Post code:"]
[]
[]
[null,null,"INCOME"]
[null,null,"What is your total annual disposable household income?\nThis should include private income after tax and NI, any payments from benefits (apart from disability benefits) and tax credits, net interest from savings and investments, plus the Winter Fuel Payment if received. You should also subtract your annual council tax bill from your income (see overleaf for space to make notes)."]
[]
[]
[null,null,"HOUSING COSTS"]
[null,null,"Mortgage payments"]
[null,null,"If you have a mortgage, how much do you pay in each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[null,null,"Rent costs"]
[null,null,"If you pay rent, how much do you pay each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[]
[null,null,"FUEL COSTS"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"Do you receive the Warm Home Discount?"]
[]
[null,null,"Do you spend money on other fuels each month?"]
[null,null,"House coal"]
[null,null,"Wood (logs, pellets, chips)"]
[null,null,"LPG"]
[null,null,"Oil"]
[null,null,"Other"]
[]
[]
[null,null,"HOUSEHOLD SIZE"]
[null,null,"How many people are regularly living in your household?"]
[null,null,"How many of these are 14 or over?"]
[null,null,"How many of these are under 14?"]
[]
[]
[null,null,"INCOME CALCULATION NOTES"]
[]
[null,null,"The income for all persons over 16 should be included in the calculation where applicable. If benefits or tax credits are received as a couple or household as a whole then only include these for one person below."]
[]
[null,null,"PERSON 1"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, and Mortage Payment Protection Insurance. Exclude disability benefits: Disability Living Allowance, Personal Independence Payments, and Attendance Allowance. Ensure Universal Credit payment for lone parents is at least their theoretical entitlement and ensure pension payments are at least those of minimum state pension.","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 1 ANNUAL NET INCOME","£","(1)"]
[]
[null,null,"PERSON 2"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, and Mortage Payment Protection Insurance. Exclude disability benefits: Disability Living Allowance, Personal Independence Payments, and Attendance Allowance. Ensure Universal Credit payment for lone parents is at least their theoretical entitlement and ensure pension payments are at least those of minimum state pension.","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 2 ANNUAL NET INCOME","£","(2)"]
[]
[null,null,"OTHER PERSONS"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, and Mortage Payment Protection Insurance. Exclude disability benefits: Disability Living Allowance, Personal Independence Payments, and Attendance Allowance. Ensure Universal Credit payment for lone parents is at least their theoretical entitlement and ensure pension payments are at least those of minimum state pension.","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"OTHER PERSONS ANNUAL NET INCOME","£","(3)"]
[]
[null,null,"Preliminary total"]
[null,null,"TOTAL OF ALL PERSONS ANNUAL NET INCOME (1) + (2) + (3)","£","(4)"]
[]
[null,null,"From the preliminary total then add:"]
[null,null,"WINTER FUEL PAYMENTS","£","(5)"]
[null,null,"And then subtract:"]
[null,null,"ANNUAL COUNCIL TAX BILL","£","(6)"]
[]
[null,null,"FINAL TOTAL NET HOUSEHOLD INCOME (4) + (5) - (6)","£"]

{"sheet":"DataCollectionFormWal (PRINT)","index":15,"n_rows":96,"n_cols":5,"rows_kept":96,"merged":[[3,1,5,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[49,2,49,3]]}
[]
[]
[]
[null,"FUEL POVERTY DATA COLLECTION QUESTIONNAIRE"]
[]
[]
[]
[null,null,"Title:"]
[null,null,"First name:"]
[null,null,"Surname:"]
[null,null,"Flat Number:"]
[null,null,"Building name:"]
[null,null,"Building number:"]
[null,null,"Street:"]
[null,null,"District:"]
[null,null,"Town:"]
[null,null,"County:"]
[null,null,"Post code:"]
[]
[]
[null,null,"INCOME"]
[null,null,"What is your total annual disposable household income?\nThis should include private income after tax and NI, any payments from benefits and tax credits, net interest from savings and investments, plus the Winter Fuel Payment if received. You should also subtract your annual council tax bill from your income (see overleaf for space to make notes)."]
[]
[]
[null,null,"HOUSING COSTS"]
[null,null,"Mortgage payments"]
[null,null,"If you have a mortgage, how much do you pay in each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[null,null,"Rent costs"]
[null,null,"If you pay rent, how much do you pay each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[]
[null,null,"FUEL COSTS"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"Do you receive the Warm Home Discount?"]
[]
[null,null,"Do you spend money on other fuels each month?"]
[null,null,"House coal"]
[null,null,"Wood (logs, pellets, chips)"]
[null,null,"LPG"]
[null,null,"Oil"]
[null,null,"Other"]
[]
[]
[null,null,"INCOME CALCULATION NOTES"]
[]
[null,null,"The income for all persons over 16 should be included in the calculation where applicable. If benefits or tax credits are received as a couple or household as a whole then only include these for one person below."]
[]
[null,null,"PERSON 1"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Disability Living Allowance, Personal Independence Payments, and Attendance Allowance).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 1 ANNUAL NET INCOME","£","(1)"]
[]
[null,null,"PERSON 2"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Disability Living Allowance, Personal Independence Payments, and Attendance Allowance).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 2 ANNUAL NET INCOME","£","(2)"]
[]
[null,null,"OTHER PERSONS"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Disability Living Allowance, Personal Independence Payments, and Attendance Allowance).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"OTHER PERSONS ANNUAL NET INCOME","£","(3)"]
[]
[null,null,"Preliminary total"]
[null,null,"TOTAL OF ALL PERSONS ANNUAL NET INCOME (1) + (2) + (3)","£","(4)"]
[]
[null,null,"From the preliminary total then add:"]
[null,null,"WINTER FUEL PAYMENTS","£","(5)"]
[null,null,"And then subtract:"]
[null,null,"ANNUAL COUNCIL TAX BILL","£","(6)"]
[]
[null,null,"FINAL TOTAL NET HOUSEHOLD INCOME (4) + (5) - (6)","£"]

{"sheet":"DataCollectionFormSco (PRINT)","index":16,"n_rows":106,"n_cols":5,"rows_kept":106,"merged":[[3,1,5,4],[7,2,7,3],[8,2,8,3],[9,2,9,3],[10,2,10,3],[11,2,11,3],[12,2,12,3],[13,2,13,3],[14,2,14,3],[15,2,15,3],[16,2,16,3],[17,2,17,3],[59,2,59,3]]}
[]
[]
[]
[null,"FUEL POVERTY DATA COLLECTION QUESTIONNAIRE"]
[]
[]
[]
[null,null,"Title:"]
[null,null,"First name:"]
[null,null,"Surname:"]
[null,null,"Flat Number:"]
[null,null,"Building name:"]
[null,null,"Building number:"]
[null,null,"Street:"]
[null,null,"District:"]
[null,null,"Town:"]
[null,null,"County:"]
[null,null,"Post code:"]
[]
[]
[null,null,"INCOME"]
[null,null,"What is your total annual disposable household income?\nThis should include private income after tax and NI, any payments from benefits and tax credits, net interest from savings and investments, plus the Pension Age Winter Heating Payment if received. You should also subtract your annual council tax bill from your income (see overleaf for space to make notes)."]
[]
[]
[null,null,"HOUSING COSTS"]
[null,null,"Mortgage payments"]
[null,null,"If you have a mortgage, how much do you pay in each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[null,null,"Rent costs"]
[null,null,"If you pay rent, how much do you pay each installment?"]
[null,null,"How often do you pay these (e.g. weekly, monthly, other)"]
[]
[]
[null,null,"FUEL COSTS"]
[null,null,"What do you pay for electricity each month?"]
[null,null,"What do you pay for gas each month?"]
[null,null,"Do you receive the Warm Home Discount?"]
[]
[null,null,"Do you spend money on other fuels each month?"]
[null,null,"House coal"]
[null,null,"Wood (logs, pellets, chips)"]
[null,null,"LPG"]
[null,null,"Oil"]
[null,null,"Other"]
[]
[]
[null,null,"HOUSEHOLD SIZE"]
[null,null,"How many people are regularly living in your household?"]
[null,null,"How many of these are children aged 0-1 years old?"]
[null,null,"How many of these are children aged 2-4 years old?"]
[null,null,"How many of these are children of primary school age?"]
[null,null,"How many of these are children of secondary school age?"]
[null,null,"How many of these are older than secondary school age but below pensioner age?"]
[null,null,"How many of these are at pensioner age?"]
[]
[]
[null,null,"INCOME CALCULATION NOTES"]
[]
[null,null,"The income for all persons over 16 should be included in the calculation where applicable. If benefits or tax credits are received as a couple or household as a whole then only include these for one person below."]
[]
[null,null,"PERSON 1"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Adult Disability Payment, Scottish Adult Disability Living Allowance, and Pension Age Disability Payment).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 1 ANNUAL NET INCOME","£","(1)"]
[]
[null,null,"PERSON 2"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Adult Disability Payment, Scottish Adult Disability Living Allowance, and Pension Age Disability Payment).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"PERSON 2 ANNUAL NET INCOME","£","(2)"]
[]
[null,null,"OTHER PERSONS"]
[null,null,"ANNUAL GROSS PRIVATE INCOME (from earnings and/or pension)","£"]
[null,null,"ANNUAL NET PRIVATE INCOME (Deduct tax and & NI from GROSS PRIVATE INCOME)","£"]
[null,null,"Running total","£"]
[null,null,"To the NET PRIVATE EARNINGS then add:"]
[null,null,"ANNUAL NET INCOME FROM SAVINGS/INVESTMENTS","£"]
[null,null,"ANNUAL INCOME FROM STATE BENEFITS\nAlso include housing related benefits, Council Tax Support/Reduction, Mortage Payment Protection Insurance, and disability benefits (Adult Disability Payment, Scottish Adult Disability Living Allowance, and Pension Age Disability Payment).","£"]
[null,null,"ANNUAL INCOME FROM TAX CREDITS","£"]
[null,null,"Running total","£"]
[]
[null,null,"OTHER PERSONS ANNUAL NET INCOME","£","(3)"]
[]
[null,null,"Preliminary total"]
[null,null,"TOTAL OF ALL PERSONS ANNUAL NET INCOME (1) + (2) + (3)","£","(4)"]
[]
[null,null,"From the preliminary total then add:"]
[null,null,"PENSION AGE WINTER HEATING PAYMENT","£","(5)"]
[null,null,"And then subtract:"]
[null,null,"ANNUAL COUNCIL TAX BILL","£","(6)"]
[]
[null,null,"FINAL TOTAL NET HOUSEHOLD INCOME (4) + (5) - (6)","£"]