{"text_format":"1","workbook":"xlsx","n_sheets":39,"sheets":["Welcome","Guidance","Outcome Table","Managing Well","WM1","WM2","WC1","WC2","WP1","BM1","BM2","BC1","BC2","BC3","BP1","BP2","MM1","MM2","MM3","MM4","MC1","MC2","MC3","MP1","MP2","A1","A2","A3","U","D","Questions","Output File","1. Financial wellbeing","4. Behaviour","2. Means","3. Pressure","5.  Connection","6. Mindset","7. Ability"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":2,"defined_names":24,"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":"Welcome","index":0,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[null,null,"Adult Outcome Frameworks"]
[]
[]
[]
[null,null,"Welcome to the Adults Outcome Frameworks tool"]
[null,null,"Use the buttons below to view guidance, start usting the Outcomes Framework, "]
[null,null,"or view the source reference to see the surveys we sourced questions from."]
[null,null,"Once in the tool, you can navigate back to these sections using buttons on the top of each page"]

{"sheet":"Guidance","index":1,"n_rows":23,"n_cols":2,"rows_kept":23,"cut":false,"hidden":false,"merged":[[15,1,20,11],[58,12,88,21],[22,1,27,11]]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"How to use the Financial Capability Question Bank for Older People in Retirement "]
[]
[]
[]
[]
[]
[]
[null,"\n"]

{"sheet":"Outcome Table","index":2,"n_rows":2,"n_cols":12,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,"Click on the cells below to see relevant questions. Use the grey buttons on the left to navigate to the welcome page, view the guidance, go back to the screener page to select additional or fewer outcome areas, "]
[null,null,null,null,null,null,null,null,null,null,null,"and see all the questions you have selected so far"]

{"sheet":"Managing Well","index":3,"n_rows":9,"n_cols":2,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Managing well day-to-day"]
[]
[null,"How to use this tool:"]
[null,"Choose the outcomes that are relevant to your interventions by selecting on the boxes below."]

{"sheet":"WM1","index":4,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Financial Wellbeing - Live within means"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Live within means"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Has enough income to meet everday expenditure "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How often these days do you run out of money before the end of the week or month or need to use a loan, credit card or overdraft to get by? \nCHOOSE ONE ONLY\n\n1. Always\n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never"},28]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Live within means"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Not experiencing material deprivation"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Looking at this list, can I just check whether your household could afford the following things? \nCHOOSE ALL THAT APPLY\n\n1. A week's annual holiday away from home\n2. Buying new, rather than second hand, clothes\n3. Keeping your home adequately warm in winter\n4. Having friends or family for a drink or meal once a month\n5. Going out or socialising\n6. A hobby or leisure activity\n7. Replacing a major electrical appliance (e.g. fridge)\n8. Keeping your home in a decent state of decoration\n9. None of these (SINGLE CODE ONLY)"},29]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Live within means"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Has sufficient cash savings to cover a small unexpected bill"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"Thinking about an unexpected bill which you have to pay within seven days from today.\nWhich, if any of the following would you do to pay a bill of £300? \nIf you think you would do more than one, please select the main thing you would do, that is the one you would get the most money from.\nPLEASE SELECT ONE ONLY\n\n1. I would pay it with my own money, without dipping into savings or cutting back on essentials\n2. I would pay it with my own money, without dipping into savings but I would have to cut back on essentials\n3. I would have to dip into savings \n4. I would use a form of credit (e.g. credit card, take out a loan or make use of an authorised overdraft facility)\n5. I would go overdrawn without authorisation\n6. I would get the money from friends or family as gift or loan\n7. I would have to sell personal/household item(s) to get the money  \n8. I would not be able to pay this expense\n9. Don’t know\n10. Prefer not to say"},30]

{"sheet":"WM2","index":5,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Financial Wellbeing - Satisfied and not anxious about finances"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Financial situation supports wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Satisfied with financial circumstances "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How satisfied are you with your overall financial circumstances? \n\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all satisfied’ and 10 is ‘completely satisfied’ \n\n0 Not at all satisfied\n...\n10 Completely satisfied\nDon’t know"},31]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Financial situation supports wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Financial situation does not affect mental health by causing stress or anxiety "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"A) To what extent, if at all, do you worry about your current financial situation?\nCHOOSE ONE ONLY\n\n1. Worry a great deal \n2. Worry to some extent \n3. Worry a little \n4. Don’t worry at all \n5. Don’t know\n\nB) And which of the following, if any, do you experience these days because of your household's financial situation?\nCHOOSE ALL THAT APPLY\n\n1. Stress or anxiety\n2. Low mood or depression\n3. Difficulty concentrating or relaxing\n4. Difficulty sleeping\n5. Panic attacks\n6. Difficulty eating, or eating too much\n7. Increased use of alcohol \n8. Dependence on prescription or over-the-counter drugs\n9. Use of illicit (illegal) drugs\n10. None of these (SINGLE CODE ONLY)\n11. Don't know\n12. Prefer not to say"},32]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Financial situation supports wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Do not feel money has a negative impact on their social life"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"Shortage of money stops me socialising / seeing friends and family\n\n1 Often\n2 Sometimes\n3 Not often\n4 Never"},33]

{"sheet":"WC1","index":6,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,2,12,2],[11,3,12,3]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Financial Wellbeing - Feel secure and in control"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Feel secure and in control"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Have peace of mind over personal finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n - I often worry about my finances (r)\n - I have peace of mind over my finances\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},1]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Feel secure and in control"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Good understanding of personal financial situation"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n - I understand my current financial situation\n - I know exactly what I want to know about my finances\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},2]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Feel secure and in control"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Those who rely on others for support in managing money feel they are in control of finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n-  I have the final say over how my money is spent\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},"3a"]
[null,null,null,null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"Are you comfortable with your level of control over your own finances?\n\n1. Yes\n2. No\n3. Don’t know"},"3b"]

{"sheet":"WC2","index":7,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,4,13,4]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Financial Wellbeing - Carers, family members or friends support financial wellbeing"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Carers, family members or friends support financial wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"People who help older people manage their money talk to them about what is happening with their finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n- People who help me to manage my money talk to me about what they are doing \n- People who help me to manage my money make sure I understand how my money is being spent\n- People who help me to manage my money talk to me about my wishes\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},4]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Carers, family members or friends support financial wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"People who help older people manage their money have the skills and knowledge to do so"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Many older people, particularly those in later life or experiencing ill-health, disability or cognitive decline, will need to rely on others to access their money and help them manage their finances. This could range from taking out cash and doing the shopping to managing bills and, at the extreme end, to deciding how to use assets like property to pay for care. \n\nThe extent to which people who help out in this way have the skills they need to make the most of an older person's money and assets will critically shape that person's wellbeing. In addition, in some cases, a carer may not  act in the older person's best interests or in line with their wishes. Whether or not this is intentional, this both undermines the older person's financial security and can cause significant distress.\n\nSuch arrangements and situations are very complex and unique to each older person. Different older people might feel comfortable with different arrangements and degrees of input.  As a result, at this stage, we do not know enough about the charactersitics of positive and negative/harmful arrangements to set quantitative measures for these. Indeed, the complex nature of these situations may make quantitative measurement impossible. \n\nIf your organsisation is seeking to improve the financial capability of people that you know help your clients to manage their finances, you should consider using the Adults framework to identify measures of relevant skills and behaviours e.g. maximising income, making the most of assets, and planning ahead. \n\nIf however, you are interested in understanding the interpersonal aspects of this outcome, and issues around financial abuse or acting against an older person's wishes, it may be that qualitative approaches are more suitable. Please get in touch with MAS and we can help you to think this through in more depth.  "},5]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Carers, family members or friends support financial wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"People who help older people manage their money make the most of their money and assets by shopping around for the best deals on purchases, utilities or other products and services"},null,6]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),3)","v":"Carers, family members or friends support financial wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),4)","v":"People who help older people manage their money make the most of their money by managing assets appropriately (property, savings, investments)"},null,7]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),3)","v":"Carers, family members or friends support financial wellbeing"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),4)","v":"People who help older people manage their money act in their best interest and in line with their wishes"},null,8]

{"sheet":"WP1","index":8,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[11,1,12,1],[11,2,12,2],[11,3,12,3]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Financial Wellbeing - Well placed to cope with life events"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Well placed to cope with life events "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Have taken steps to prepare for expected and unexpected life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"There are a wide range of actions and behaviours that older people can adopt that will help them to cope better if their circumstances changed. These range from keeping all their paperwork in one place to having funds set aside for home modifications and care and having an up-to-date will.  \n\nCurrently, we do not know enough about what actions and behaviours make older people more resilient to develop specific indicators and measures. If you are plannning work to help older people to prepare for life events, please get in touch and we can support you to design some measures for your evaluation. \n\nAs part of the Financial Capability strategy, research is underway to understand how older people can be enabled and encouraged to be well placed to cope with life events.  We will use the learnings from this research to further develop this indicator."},42]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Well placed to cope with life events "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Power of attorney on bank account is in place"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Do you have Power of Attorney  in place for your finances? \n\n1. Yes\n2. No\n3. Don't know\n\nDo you have any other arrangements in place to allow a third party (e.g. family member) to access your bank accounts and financial products on your behalf?\n\n1. Yes\n2. No\n3. Don't know"},43]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Well placed to cope with life events "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Discuss wishes with others in case of life event"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"Is there anyone who you have talked to about your wishes in case you had a serious health issue? \n\n1. Yes\n2. No\n3. Don't know"},"44a"]
[null,null,null,null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"How confident are you that others would know what to do with your money if you had a serious health issue?\n\n1. Very confident\n2. Confident\n3. Neither confident or unconfident\n4. Not confident\n5. Not at all confident"},"44b"]

{"sheet":"BM1","index":9,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,2],[9,3,10,3],[11,1,12,1],[11,2,12,2],[11,3,12,3]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Budget and keep track of finances"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Budget and keep track of finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Keep track of income and spending"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Which of these best describes how accurately you know how much money you have to spend at present, excluding any savings?  We’re not interested in how much money you have, just how accurately you know how much money you have to spend. \nCHOOSE ONE ONLY\n\n1. I know within a pound or two\n2. I know within £10 \n3. I know within £50\n4. I know within £100 \n5. I know within £500\n6. I have no idea at all"},"34a"]
[null,null,null,null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Which of these do you regularly use to keep track of your income and spending? Please select all that apply. \n1. An online budgeting tool\n2. An App on a mobile or other electronic device\n3. A spreadsheet\n4. A piece of paper\n5. An accounts book or notebook\n6. A financial software package\n7. By checking my bank balance\n8. By reviewing  bank statements\n9. In my head\n10. Other (please specify)\n11. I don’t keep track\n12. Don’t know "},"34b"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Managing money well day-to-day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Budget and keep track of finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Create and stick to a viable budget"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"A) How closely do you normally plan how you will spend your money over the coming week or month? For example by drawing up a budget.\nCHOOSE ONE ONLY\n\n1. Very closely\n2. Fairly closely\n3. Not very closely\n4. I do not plan my spending at all\n5. Don't know\n\nB) And, how often do you keep to the budget you set?\nCHOOSE ONE ONLY\n\n1. Always \n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never\n6. Do not budget"},"35a"]
[null,null,null,null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"To what extent would you say the following applies to you?\n- I think of my money in terms of “pots” put aside for different things.\n\nPlease answer on a scale of 0 to 10, where 0 means it doesn’t sound like you at all and 10 means it sounds a lot like you"},"35b"]

{"sheet":"BM2","index":10,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Claim benefits that they are entitled to"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day-to-day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Claim benefits that they are entitled to"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Take up benefits when entitled (e.g., pension credits, benevolent funds) "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"We have not included a measure of this behaviour as the actions an individual should take and when will differ depending on the their circumstances, the benefits they are claiming and changes to welfare policy.  \n\nIf your intervention is seeking to maximise beneficiary's income by supporting them to claim benefits, you might consider using changes to beneficiaries income alongside other administration data (e.g. whether the advisor helped them to make a claim) to evidence this. Please get in touch with the Money Advice Service if you would like help deciding how best to measure this outcome.   \n\nWe have included a question on knowledge of benefits and checking entitlement as a proxy measure for this outcome. This may be relevant if your intervention is seeking to promote awareness and uptake of benefits amongst older people. \n\nDid you know that there are some government benefits designed for older people which you might be entitled to?\n1. Yes\n2. No\n\nIF Yes: Have you ever looked into whether you are entitled to these benefits?\n1. Yes\n2.No "},36]

{"sheet":"BC1","index":11,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[[9,1,10,1],[9,2,10,2],[9,3,10,3]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Make the most of money and assets"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Make the most of money and assets"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Shop around for best deals on purchases, utilities or other products and services"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"When choosing or renewing a product or package, how often do you or your someone else in your household spend time comparing different products or packages? This might include mobile phone contracts, gas and electricity, or insurance.\nCHOOSE ONE ONLY\n1. I/we always spend time comparing\n2. I/we sometimes spend time comparing\n3. I/we very rarely spend time comparing\n4. I/we never spend time comparing\n5. Don’t know"},"9a"]
[null,null,null,null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Which of the following things, if any, do you currently do to make your money go further?  \nCHOOSE ALL THAT APPLY\n\n1. Shop around for food and groceries \n2. Look out for special offers or reduced items\n3. Plan meals in advance \n4. Make a shopping list\n5. Avoid treats and non-essential items\n6. Use money saving tips\n7. Turn lights/power off at home when they are not in use\n8. Check the charges on essential bills such as electricity or phone to see if there is a cheaper tariff or supplier available  \n9. None of these"},"9b"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Make the most of money and assets"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Has a plan for managing assets (property, savings, investments)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"We have not included a mindset measure relating to asset use in the framework as it is difficult to show positive change in this regard. The attitudes and circumstances that influence older people's views about using wealth held in property are complex and may reflect their own wishes or pressure from family.  \n\nIf your intervention is aiming to empower older people to consider drawing down wealth from property, in order to fund a more comfortable retirement, please contact us so we can help you to determine the best way to evaluate this.\n\nA) Have you recently (e.g. within the last …) made or adapted a financial plan for managing your assets throughout retirement?\n\n1. Yes\n2. No\n\nB) If you answered yes, did you seek help from any of the bodies below?\nPLEASE TICK AS MANY AS APPLY\n\n1. An Independent Financial Adviser (IFA)\n2. A Mortgage Advisor\n3. A lawyer \n5. Did not seek help "},10]

{"sheet":"BC2","index":12,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Manage credit use"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Manage credit use"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Method of credit card repayment"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How do you generally handle paying your bill each month for your credit cards or store cards? \n\n1. I generally make the minimum payment each month, but I pay more than the minimum when I can\n2. I vary in the amount I pay off – between the minimum and the full amount\n3. I usually pay in full, but sometimes let part of the balance roll over to the next month\n4. I always pay in full\n5. Don’t know\n6. Prefer not so say"},11]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Manage credit use"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Review credit card statements"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"In the last three months have you reviewed your credit card statements, loan statements, or other financial account statements?\n\n1. Yes\n2. No\n3. N/A"},12]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Manage credit use"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Take steps to reduce their debt (such contacting creditors, sticking to an agreed repayment plan etc.)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"A) PRE\nWhich, if any, of the following steps have you taken [in the last X months] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nCHOOSE ALL THAT APPLY\n\n1. Increased my regular payments\n2. Paid a lump sum towards them\n3. Spoken to my lender\n4. Sought independent advice (e.g. from Citizen's Advice Bureau, StepChange, Money Advice Service, [OTHERS])\n5. Consolidate your loans or credit cards\n6. Set up a Debt Management Plan or Debt Arrangement Scheme\n7. Arranged to write off some or all of my debts (e.g. Applied for bankruptcy or a debt relief order or set up an IVA)\n8. None of these  (SINGLE CODE ONLY)\n9. Do not have any debts  (SINGLE CODE ONLY)\n\nB) POST\nWhich, if any, of the following steps have you taken since [REFERENCE POINT] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nCHOOSE ALL THAT APPLY\n\n1. Increased my regular payments\n2. Paid a lump sum towards them\n3. Spoken to my lender\n4. Sought independent advice (e.g. from Citizen's Advice Bureau, StepChange, Money Advice Service, [OTHERS])\n5. Consolidate your loans or credit cards\n6. Set up a Debt Management Plan or Debt Arrangement Scheme\n7. Arranged to write off some or all of my debts (e.g. Applied for bankruptcy or a debt relief order or set up an IVA)\n8. None of these  (SINGLE CODE ONLY)\n9. Do not have any debts  (SINGLE CODE ONLY)\n"},13]

{"sheet":"BC3","index":13,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Actively seek guidance and regulated financial advice"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Actively seek guidance and regulated financial advice"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Proactively approach financial adviser and guidance provider when needed for an independent perspective"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n - When I need financial information I look for advice\n - I try not to make difficult financial decisions without receiving advice or guidance beforehand\n - I seek advice whenever I am unsure about aspects of my finances\n - I seek out paid-for financial advice when making decisions about my assets\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},14]

{"sheet":"BP1","index":14,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Plan to cope with life events"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Plan to cope with life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Has a financial plan which includes life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Have you made a concrete plan, a rough plan or no plan for the following aspects of life events?\n-  Funding care costs\n-  Funding funeral \n-  Mortage repayment\n-  Debt repayment\n- Funding long term care \nPLEASE SELECT ONE ANSWER FOR EACH QUESTION\n\n1. A concrete plan \n2. A rough plan \n3. No plan \n4. NA"},45]

{"sheet":"BP2","index":15,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Behaviour - Work towards financial goals"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Work towards financial goals"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Actively planning to achieve long-term financial goals"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"A) Which, if any, of these financial goals do you have for the next five years?\nPLEASE SELECT ALL THAT APPLY\n\n1. Just making ends meet day to day\n2. Paying off my debts/reducing debts\n3. To buy, rent or move house\n4. Saving money to help grown-up children to buy/rent  a home\n5. Saving money for a holiday\n6. Saving money for home improvements\n8. Saving money generally\n9. Other (please specify)\n10. None of these (SINGLE CODE ONLY)"},46]

{"sheet":"MM1","index":16,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[[4,1,4,4]]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Confident in managing finances"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Confident in managing finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Confident in managing money"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How confident do you feel managing your money?\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all confident and 10 is ‘very confident'.\n\n 0…10 scale\nDon't know"},37]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Confident in managing finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Confident to choose appropriate products/services"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How confident do you feel making decisions about financial products and services?  \nPlease answer on a scale of 0 to 10, where 0 is ‘not at all confident and 10 is ‘very confident'.\n\n 0…10 scale\nDon't know"},38]

{"sheet":"MM2","index":17,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Feel entitled to claim benefits"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Feel entitled to claim benefits"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Feel entitled to claim  benefits"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n-  I am reluctant to take means tested benefits (r)\n - When I have qualified for state benefits I feel comfortable taking them\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},39]

{"sheet":"MM3","index":18,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Motivated to shop around to make money go further"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Motivated to shop around to make money go further"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Willing and motivated to change service provider if needed"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?:\n- I prefer to stick with one company over time rather than keep changing suppliers (such as utility companies) (r)\n - There's no point switching things like insurance, energy or bank accounts, it's not worth the hassle (r)\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},40]

{"sheet":"MM4","index":19,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Attitudes to saving and spending to enjoy retirement"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Managing money well day to day"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Attitudes towards saving and spending to enjoy retirement "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Does not go without essentials (heating/food) to save money"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How often these days do you go without food, heating or other essentials in order to save money? \nCHOOSE ONE ONLY\n\n1. Always\n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never"},41]

{"sheet":"MC1","index":20,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Attitudes towards asking for help"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Appropriate attitude towards asking for help"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Confident in knowing when to ask for help"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?\n - I am confident I know when to ask for help managing my finances when I need it\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},15]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Appropriate attitude towards asking for help"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Willing to ask for help if needed"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statement?\n - I am willing to ask for help managing my daily finances when I need it.\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},16]

{"sheet":"MC2","index":21,"n_rows":12,"n_cols":6,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Confident spotting and challenging a scammer"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Confident spotting and challenging a scammer "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Confident recognising scams and challenging or taking action to protect themselves "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n - I am confident that I can recognise when I am being taken advantage of financially\n - I feel confident I would quickly recognise a scammer if one approached me\n - I would challenge someone I thought was trying to scam me \n - If I believed someone had tried to scam me I would report this\n\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},17]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Confident spotting and challenging a scammer "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Aware they could become a victim of a scam"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n - As a retiree I am more at risk of being targeted by scams than other adults\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},18]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Confident spotting and challenging a scammer "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Confident checking whether request for financial details is coming from a reputable source"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?\n - If someone asks for my personal or banking information, I know how to check this is a legitimate request from a reputable organisation \n - I am extremely careful before giving my bank details to other people\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},19]

{"sheet":"MC3","index":22,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Confident dealing with financial guidance or regulated financial advice providers"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Cross-cutting outcomes"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Confident dealing with financial guidance or regulated financial advice providers"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Willing to challenge and question advice and guidance "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n - When I am given financial advice that I am unsure of, I feel confident to challenge this advice\n- When I don't understand the financial advice I'm given, I tend to ask questions\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},20]

{"sheet":"MP1","index":23,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Consider the risks of negative life events"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Consider the risks of negative life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Aware of life events and the impact they might have on finacial situation (e.g, access to financial services, cost of care, funeral)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Have you thought about or made any plans for how you might fund the care and support you may need as you get older? This might include in-home support or a care home.\nCODES 3,4,5,6 CAN BE MULTICODE\n1. I haven't really thought about it\n2. I've thought about it but haven’t done anything specific\n3. I’m saving money which could pay for this (e.g. savings, pension or investments)\n4. I’ve taken out insurance cover to pay for this (e.g. long-term care plan)\n5. I could sell property to pay for this\n6. I hope my family would help fund this\n7. I hope the state will fund this \n8. Other (please specify)\n9. Don't know"},47]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Consider the risks of negative life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Recognise the need to plan ahead (e.g. make will, put PoA in place)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n - I need to make a plan to manage my money throughout my retirement in case my circumstances change (e.g. bereavement, illness)\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},48]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Consider the risks of negative life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Understand and thought about third party access options"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \n - I have considered giving a third party (such as a relative) access to my bank accounts.\n - I understand how I would go about giving third party access to my bank accounts.\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},49]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),3)","v":"Consider the risks of negative life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),4)","v":"Willing to discuss wishes with friends and family"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement? \n- In my daily life I'm willing to talk with people I trust about the financial aspects of death and ill health.\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},50]

{"sheet":"MP2","index":24,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Mindset - Adaptable to changing circumstances"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":"Prepared for life events"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Adaptable to changing circumstances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Willing to adapt spending in response to changes in income/outgoings"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":" I am prepared to adjust the amount of money I spend on non-essentials if my life changes: 0 (does not sound like me at all) to 10 (sounds a lot like me)\n\n0…10 scale\n11. Don't know"},51]

{"sheet":"A1","index":25,"n_rows":13,"n_cols":6,"rows_kept":13,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Ability - General financial skills"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"General financial skills"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Able to manage housing and care costs"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Which of these statements best describes how knowledgeable you feel about: \n -  Managing my housing costs \n -  Managing my care costs \n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable"},21]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"General financial skills"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Able to apply for pension credits if needed"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"Which of these statements best describes how knowledgeable you feel about: \n - Applying for pension credits\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable"},22]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"General financial skills"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Able to check bank balance"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"Which of these statements best describes how knowledgeable you feel about: \n - Checking the balance on your bank account\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable"},23]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),3)","v":"General financial skills"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),4)","v":"Know how to make their money go further "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"Which of these statements best describes how knowledgeable you feel about: \n - using a price comparison website \n - comparing different types of insurance\n - comparing savings products \n- checking you’re getting all benefits you are entitled to\n - checking that you are paying the correct amount of tax\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable"},24]

{"sheet":"A2","index":26,"n_rows":10,"n_cols":6,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Ability - Digital skills for management of finances"]
[null,"Please select the first question for each indicator"]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F9,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F9,Questions!$D$3:$D$73,0),3)","v":"Digital skills for management of finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F9,Questions!$D$3:$D$73,0),4)","v":"Able to manage bank accounts online, check benefit entitlement online, and transact online (e.g, shopping around online, paying bills)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F9,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?:\n - I can check the balance on my bank account using online banking\n - I can check the recent transactions on my bank account using online banking\n - I can transfer money between accounts using online banking\n - I can check which benefits I am entitled to using the internet\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},"25a"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Digital skills for management of finances"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Able to manage bank accounts online, check benefit entitlement online, and transact online (e.g, shopping around online, paying bills)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Do you access to the internet at home or elsewhere?\n1. Yes\n2. No\n3. Don't know\n\nIF DO HAVE ACCESS\nI’d like you to think about different commercial transactions people do in their everyday lives like banking or shopping. How often do you use the internet for the following purposes? \n- Buying a product online\n- Making travel reservations/bookings\n- Paying bills\n- Using your bank’s online services\n- Comparing products and services\n- Ordering groceries or food online\n- Selling things online\n- Finding the location of a house,  office, store or restaurant \n\n1. Several times a day\n2. Daily\n3. Weekly\n4. Monthly\n5. Less than monthly\n6. Never\n7. Don't know"},"25b"]

{"sheet":"A3","index":27,"n_rows":11,"n_cols":6,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Ability - Awareness of guidance and regulated financial advice providers and how to access them"]
[null,"Please select the first question for each indicator"]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Awareness of guidance and regulated financial advice providers and how to access them"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Know where to go for guidance "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":" Which of these statements best describes how knowledgeable you feel about:  \n- where to get  guidance if you need help with your finances\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable"},26]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Awareness of guidance and regulated financial advice providers and how to access them"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Understand when regulated financial advice is beneficial"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n - I know enough about regulated financial advice (such as mortgage brokers, investment adviser or pension adivser) to know when I should approach one\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},27]

{"sheet":"U","index":28,"n_rows":15,"n_cols":6,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Understanding your clients"]
[null,"Please select the first question for each indicator"]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":"Access to financial products and services"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Able to access basic financial products and services (including current account checking balances, opening new accounts and products, using features like direct debit and payment services) in a way that works for them. "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"How easy or difficult is it for you to do each of the following things?\nCHOOSE ONE ANSWER ONLY FOR EACH\n- Check your bank balance\n- Withdraw money\n- Open a new bank account\n- Pay for products and services without using cash\n- Transfer money to friends and family\n- Use direct debit \n\n1. Very easy\n2. Quite easy\n3. Quite difficult\n4. Very difficult\n5. Unable to do\n6. Do not wish to do this"},52]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":"Access to appropriate guidance and regulated financial advice "},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Able to access appropriate guidance and regulated financial advice on pension drawdown, money management, meeting mortgage debt/housing costs, safeguarding, long-term care, or assessments (housing, care, vulnerability)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with each of the following statements?  \nIf I needed to, I would be able to speak to a regulated financial advisor to get advice about my finances :\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n\nIf I needed to, I would be able to access free guidance about my finances using the communication method which best suits my needs (for example face to face)\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},53]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":"Socially included"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Has someone they trust to discuss money issues with"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"How much do you agree or disagree with the following statement?  \n- When I have money problems I have someone I can talk with about them\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know"},54]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),3)","v":"Good physical and mental health"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),4)","v":"Limitation due to health condition"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"For at least the past six months, to what extent have you been limited because of a health problem in activities people usually do? \n\n1. Severely limited\n2. Limited but not severely \n3. Not limited at all"},55]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),3)","v":"Sufficient income to meet basic needs \n"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),4)","v":"Enough income to cover basic needs"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),6)","v":"This should be explored through an assessment of beneficiaries income and expenditure, as well as scope for maximising their income. "},56]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),3)","v":"General skills (literacy and numeracy)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),4)","v":"Able to apply mathematical skills to financial problems, fill in forms, write formal letters in English (or Welsh in Wales) and confidently interact with others in English (or Welsh in Wales)"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),6)","v":"A) How good are you at the following:\n - Working with numbers when you need to in everyday life? For example working out your income or benefits, or checking bills and statements?\n - Working with numbers when you need to in everyday life? For example working out your benefits, or checking bills and statements?\n -  Writing in English when you need to in daily life? For example: writing letters or notes or filling in official forms?\n - Reading in English when you need to? For example reading newspapers and magazines or reading letters, paperwork or forms?\n\n1. Very good \n2. Fairly good \n3. Below average \n4. Poor \n5. No opinion\n6, Don't Know  \n\nB) Can I check, is English or Welsh your first language?  \nYes - English\nYes - Welsh\nNo, neither\n\n[IF NEITHER]  So can I check would you have any difficulty speaking in English or Welsh to a member of staff in a bank about choosing a financial product?\n1. Yes\n2. No"},57]

{"sheet":"D","index":29,"n_rows":17,"n_cols":6,"rows_kept":17,"cut":false,"hidden":false,"merged":[]}
[]
[null,null,null,"Older People in Retirement"]
[null,null,null,"Outcomes Framework"]
[]
[null,"Demographics"]
[null,"Select the questions that are relevant to your intervention -  use the first question for each indicator, "]
[null,"only use additional questions if that indicator is particularly important."]
[]
[null,{"$f":"'1. Financial wellbeing'!C2","v":"Higher level outcome"},{"$f":"'1. Financial wellbeing'!D2","v":"Lower level outcome"},"Indicator","Question","Question"]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),4)","v":"Sex"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F10,Questions!$D$3:$D$73,0),6)","v":"Sex \n\n1. Male\n2. Female"},58]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),4)","v":"Age"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F11,Questions!$D$3:$D$73,0),6)","v":"A) What is your date of birth?  \n\nDay: ___ Month:___Year:___\n\nOR \nB) How old are you?"},59]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),4)","v":"Civil status"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F12,Questions!$D$3:$D$73,0),6)","v":"What is your marital status?\n\n1. Single\n2. Married \n3. Widower \n4. Separated or divorced \n5. A civil partner in a legally-recognised Civil \n6. Partnership\n7. Other\n8. Does not know/ N/A "},60]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),4)","v":"Marital property regime"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F13,Questions!$D$3:$D$73,0),6)","v":"Do you know if a marital property regime applies to your marriage? \n\n1. Yes\n2. No"},61]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),4)","v":"Urbanity"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F14,Questions!$D$3:$D$73,0),6)","v":"Size and name of the municipality________________________\n\n1. Up to 5.000 inhabitants.\n2. 5,001 – 10,000 inh.\n3. 10,001 – 20,000 inh.\n4. 20,001 – 100,000 inh.\n5. 100.000 - 1,000,000 inh.\n6. more than  1,000,000 inh."},62]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),4)","v":"Nationality"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F15,Questions!$D$3:$D$73,0),6)","v":"What is your nation of birth? ________________________"},63]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F16,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F16,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F16,Questions!$D$3:$D$73,0),4)","v":"Years of involvement in the UK"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F16,Questions!$D$3:$D$73,0),6)","v":"In which year did you arrive to the UK? ________________________"},64]
[null,{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F17,Questions!$D$3:$D$73,0),2)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F17,Questions!$D$3:$D$73,0),3)","v":0},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F17,Questions!$D$3:$D$73,0),4)","v":"Ethnicity"},{"$f":"INDEX(Questions!$D$3:$J$73,MATCH(F17,Questions!$D$3:$D$73,0),6)","v":"How would you describe your ethnicity?\n\n1. White UK\n2. White Irish\n3. White Other\n4. Arab\n5. Asian/Asian British – Indian\n6. Asian/Asian British – Pakistani\n7. Asian/Asian British – Bangladeshi\n8. Asian/Asian British - Other _____specify\n9. Black/Black British – Caribbean\n10. Black/Black British – African\n11. Black/Black British - Other ______ specify\n12. Hispanic/Latino \n13. Mixed ethnicity - White and Black Caribbean\n14. Mixed ethnicity - White and Black African\n15. Mixed ethnicity - White and Asian\n16. Mixed ethnicity - Other _______ specify\n17. Other ____________\nPrefer not to say"},65]

{"sheet":"Questions","index":30,"n_rows":73,"n_cols":21,"rows_kept":73,"cut":false,"hidden":false,"merged":[]}
[]
["Ticks","In/Out","Sheet","Question","Higher level outcome","Lower level outcome","Indicator","Original source","Final framework question","Notes for users",null,null,null,"Question","Section","Higher level outcome","Lower level outcome","Indicator","Original source","Final framework question","Notes for users"]
[false,{"$f":"IF(A3=TRUE,\"In\",\"Out\")","v":"Out"},"WC1",1,"Cross-cutting outcomes","Feel secure and in control","Have peace of mind over personal finances","New \nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with each of the following statements?  \n - I often worry about my finances (r)\n - I have peace of mind over my finances\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D1))),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N3,$D$3:$D$73,0),8),\"\")","v":""}]
[false,{"$f":"IF(A4=TRUE,\"In\",\"Out\")","v":"Out"},"WC1",2,"Cross-cutting outcomes","Feel secure and in control","Good understanding of personal financial situation","New \nCognitively tested in Round 2","How much do you agree or disagree with each of the following statements?  \n - I understand my current financial situation\n - I know exactly what I want to know about my finances\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D2))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N4,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC1","3a","Cross-cutting outcomes","Feel secure and in control","Those who rely on others for support in managing money feel they are in control of finances","New","How much do you agree or disagree with the following statement?  \n-  I have the final say over how my money is spent\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","This question has been drafted specifically for older people who have help managing their money. This question has not been tested  and further work is needed to understand what good financial wellbeing looks like in this situation",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D3))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N5,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC1","3b","Cross-cutting outcomes","Feel secure and in control","Those who rely on others for support in managing money feel they are in control of finances","New\nCognitively tested in Round 1 and Round 2","Are you comfortable with your level of control over your own finances?\n\n1. Yes\n2. No\n3. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D4))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N6,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC2",4,"Cross-cutting outcomes","Carers, family members or friends support financial wellbeing","People who help older people manage their money talk to them about what is happening with their finances","New\nThis requires further cognitive testing to understand whether multiple statements are required and which of the three statements work well / best.  ","How much do you agree or disagree with each of the following statements?  \n- People who help me to manage my money talk to me about what they are doing \n- People who help me to manage my money make sure I understand how my money is being spent\n- People who help me to manage my money talk to me about my wishes\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D5))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N7,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC2",5,"Cross-cutting outcomes","Carers, family members or friends support financial wellbeing","People who help older people manage their money have the skills and knowledge to do so",null,"Many older people, particularly those in later life or experiencing ill-health, disability or cognitive decline, will need to rely on others to access their money and help them manage their finances. This could range from taking out cash and doing the shopping to managing bills and, at the extreme end, to deciding how to use assets like property to pay for care. \n\nThe extent to which people who help out in this way have the skills they need to make the most of an older person's money and assets will critically shape that person's wellbeing. In addition, in some cases, a carer may not  act in the older person's best interests or in line with their wishes. Whether or not this is intentional, this both undermines the older person's financial security and can cause significant distress.\n\nSuch arrangements and situations are very complex and unique to each older person. Different older people might feel comfortable with different arrangements and degrees of input.  As a result, at this stage, we do not know enough about the charactersitics of positive and negative/harmful arrangements to set quantitative measures for these. Indeed, the complex nature of these situations may make quantitative measurement impossible. \n\nIf your organsisation is seeking to improve the financial capability of people that you know help your clients to manage their finances, you should consider using the Adults framework to identify measures of relevant skills and behaviours e.g. maximising income, making the most of assets, and planning ahead. \n\nIf however, you are interested in understanding the interpersonal aspects of this outcome, and issues around financial abuse or acting against an older person's wishes, it may be that qualitative approaches are more suitable. Please get in touch with MAS and we can help you to think this through in more depth.  ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D6))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N8,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC2",6,"Cross-cutting outcomes","Carers, family members or friends support financial wellbeing","People who help older people manage their money make the most of their money and assets by shopping around for the best deals on purchases, utilities or other products and services",null,"Many older people, particularly those in later life or experiencing ill-health, disability or cognitive decline, will need to rely on others to access their money and help them manage their finances. This could range from taking out cash and doing the shopping to managing bills and, at the extreme end, to deciding how to use assets like property to pay for care. \n\nThe extent to which people who help out in this way have the skills they need to make the most of an older person's money and assets will critically shape that person's wellbeing. In addition, in some cases, a carer may not  act in the older person's best interests or in line with their wishes. Whether or not this is intentional, this both undermines the older person's financial security and can cause significant distress.\n\nSuch arrangements and situations are very complex and unique to each older person. Different older people might feel comfortable with different arrangements and degrees of input.  As a result, at this stage, we do not know enough about the charactersitics of positive and negative/harmful arrangements to set quantitative measures for these. Indeed, the complex nature of these situations may make quantitative measurement impossible. \n\nIf your organsisation is seeking to improve the financial capability of people that you know help your clients to manage their finances, you should consider using the Adults framework to identify measures of relevant skills and behaviours e.g. maximising income, making the most of assets, and planning ahead. \n\nIf however, you are interested in understanding the interpersonal aspects of this outcome, and issues around financial abuse or acting against an older person's wishes, it may be that qualitative approaches are more suitable. Please get in touch with MAS and we can help you to think this through in more depth.  ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D7))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N9,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC2",7,"Cross-cutting outcomes","Carers, family members or friends support financial wellbeing","People who help older people manage their money make the most of their money by managing assets appropriately (property, savings, investments)",null,"Many older people, particularly those in later life or experiencing ill-health, disability or cognitive decline, will need to rely on others to access their money and help them manage their finances. This could range from taking out cash and doing the shopping to managing bills and, at the extreme end, to deciding how to use assets like property to pay for care. \n\nThe extent to which people who help out in this way have the skills they need to make the most of an older person's money and assets will critically shape that person's wellbeing. In addition, in some cases, a carer may not  act in the older person's best interests or in line with their wishes. Whether or not this is intentional, this both undermines the older person's financial security and can cause significant distress.\n\nSuch arrangements and situations are very complex and unique to each older person. Different older people might feel comfortable with different arrangements and degrees of input.  As a result, at this stage, we do not know enough about the charactersitics of positive and negative/harmful arrangements to set quantitative measures for these. Indeed, the complex nature of these situations may make quantitative measurement impossible. \n\nIf your organsisation is seeking to improve the financial capability of people that you know help your clients to manage their finances, you should consider using the Adults framework to identify measures of relevant skills and behaviours e.g. maximising income, making the most of assets, and planning ahead. \n\nIf however, you are interested in understanding the interpersonal aspects of this outcome, and issues around financial abuse or acting against an older person's wishes, it may be that qualitative approaches are more suitable. Please get in touch with MAS and we can help you to think this through in more depth.  \n",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D8))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N10,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WC2",8,"Cross-cutting outcomes","Carers, family members or friends support financial wellbeing","People who help older people manage their money act in their best interest and in line with their wishes",null,"Many older people, particularly those in later life or experiencing ill-health, disability or cognitive decline, will need to rely on others to access their money and help them manage their finances. This could range from taking out cash and doing the shopping to managing bills and, at the extreme end, to deciding how to use assets like property to pay for care. \n\nThe extent to which people who help out in this way have the skills they need to make the most of an older person's money and assets will critically shape that person's wellbeing. In addition, in some cases, a carer may not  act in the older person's best interests or in line with their wishes. Whether or not this is intentional, this both undermines the older person's financial security and can cause significant distress.\n\nSuch arrangements and situations are very complex and unique to each older person. Different older people might feel comfortable with different arrangements and degrees of input.  As a result, at this stage, we do not know enough about the charactersitics of positive and negative/harmful arrangements to set quantitative measures for these. Indeed, the complex nature of these situations may make quantitative measurement impossible. \n\nIf your organsisation is seeking to improve the financial capability of people that you know help your clients to manage their finances, you should consider using the Adults framework to identify measures of relevant skills and behaviours e.g. maximising income, making the most of assets, and planning ahead. \n\nIf however, you are interested in understanding the interpersonal aspects of this outcome, and issues around financial abuse or acting against an older person's wishes, it may be that qualitative approaches are more suitable. Please get in touch with MAS and we can help you to think this through in more depth.  \n",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D9))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N11,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC1","9a","Cross-cutting outcomes","Make the most of money and assets","Shop around for best deals on purchases, utilities or other products and services","AOF","When choosing or renewing a product or package, how often do you or your someone else in your household spend time comparing different products or packages? This might include mobile phone contracts, gas and electricity, or insurance.\nCHOOSE ONE ONLY\n1. I/we always spend time comparing\n2. I/we sometimes spend time comparing\n3. I/we very rarely spend time comparing\n4. I/we never spend time comparing\n5. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D10))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N12,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC1","9b","Cross-cutting outcomes","Make the most of money and assets","Shop around for best deals on purchases, utilities or other products and services","AOF: CitA","Which of the following things, if any, do you currently do to make your money go further?  \nCHOOSE ALL THAT APPLY\n\n1. Shop around for food and groceries \n2. Look out for special offers or reduced items\n3. Plan meals in advance \n4. Make a shopping list\n5. Avoid treats and non-essential items\n6. Use money saving tips\n7. Turn lights/power off at home when they are not in use\n8. Check the charges on essential bills such as electricity or phone to see if there is a cheaper tariff or supplier available  \n9. None of these",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D11))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N13,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC1",10,"Cross-cutting outcomes","Make the most of money and assets","Has a plan for managing assets (property, savings, investments)","New","We have not included a mindset measure relating to asset use in the framework as it is difficult to show positive change in this regard. The attitudes and circumstances that influence older people's views about using wealth held in property are complex and may reflect their own wishes or pressure from family.  \n\nIf your intervention is aiming to empower older people to consider drawing down wealth from property, in order to fund a more comfortable retirement, please contact us so we can help you to determine the best way to evaluate this.\n\nA) Have you recently (e.g. within the last …) made or adapted a financial plan for managing your assets throughout retirement?\n\n1. Yes\n2. No\n\nB) If you answered yes, did you seek help from any of the bodies below?\nPLEASE TICK AS MANY AS APPLY\n\n1. An Independent Financial Adviser (IFA)\n2. A Mortgage Advisor\n3. A lawyer \n5. Did not seek help ","Given the complexity and financial risk associated with such plans, this measure seeks to explore not just whether they have made or revised their plan but also whether they sought independent paid for advice when doing so. Therefore Part B would not be appropriate for older people who do not have sufficient wealth in assets to warrant the cost of independent financial advice.\n\nYou can edit or expand the list of information providers to make this more relevant to your intervention or locality.  ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D12))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N14,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC2",11,"Cross-cutting outcomes","Manage credit use","Method of credit card repayment","AOF: Fincap E10","How do you generally handle paying your bill each month for your credit cards or store cards? \n\n1. I generally make the minimum payment each month, but I pay more than the minimum when I can\n2. I vary in the amount I pay off – between the minimum and the full amount\n3. I usually pay in full, but sometimes let part of the balance roll over to the next month\n4. I always pay in full\n5. Don’t know\n6. Prefer not so say","Managing the repayment of debts is a less common issue in the retired population than the working-age population. If you are targeting older people with debt issues we recommending referring to the Adults' Outcome Framework. These questions should be used with some care however as older people do not always have the same choices and options when it comes to paying down debt. Also the existance of debt in the older population is not always negative, and older people should not be so scared of debt that their quality of life suffers. For example, older people should not be scared of using heating because they are worried their bill will be unaffordable.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D13))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N15,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC2",12,"Cross-cutting outcomes","Manage credit use","Review credit card statements","AARP 2014","In the last three months have you reviewed your credit card statements, loan statements, or other financial account statements?\n\n1. Yes\n2. No\n3. N/A",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D14))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N16,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC2",13,"Cross-cutting outcomes","Manage credit use","Take steps to reduce their debt (such contacting creditors, sticking to an agreed repayment plan etc.)","AOF: Fincap J4","A) PRE\nWhich, if any, of the following steps have you taken [in the last X months] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nCHOOSE ALL THAT APPLY\n\n1. Increased my regular payments\n2. Paid a lump sum towards them\n3. Spoken to my lender\n4. Sought independent advice (e.g. from Citizen's Advice Bureau, StepChange, Money Advice Service, [OTHERS])\n5. Consolidate your loans or credit cards\n6. Set up a Debt Management Plan or Debt Arrangement Scheme\n7. Arranged to write off some or all of my debts (e.g. Applied for bankruptcy or a debt relief order or set up an IVA)\n8. None of these  (SINGLE CODE ONLY)\n9. Do not have any debts  (SINGLE CODE ONLY)\n\nB) POST\nWhich, if any, of the following steps have you taken since [REFERENCE POINT] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nCHOOSE ALL THAT APPLY\n\n1. Increased my regular payments\n2. Paid a lump sum towards them\n3. Spoken to my lender\n4. Sought independent advice (e.g. from Citizen's Advice Bureau, StepChange, Money Advice Service, [OTHERS])\n5. Consolidate your loans or credit cards\n6. Set up a Debt Management Plan or Debt Arrangement Scheme\n7. Arranged to write off some or all of my debts (e.g. Applied for bankruptcy or a debt relief order or set up an IVA)\n8. None of these  (SINGLE CODE ONLY)\n9. Do not have any debts  (SINGLE CODE ONLY)\n",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D15))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N17,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BC3",14,"Cross-cutting outcomes","Actively seek guidance and regulated financial advice","Proactively approach financial adviser and guidance provider when needed for an independent perspective","New \nPartially cognitively tested","How much do you agree or disagree with each of the following statements?  \n - When I need financial information I look for advice\n - I try not to make difficult financial decisions without receiving advice or guidance beforehand\n - I seek advice whenever I am unsure about aspects of my finances\n - I seek out paid-for financial advice when making decisions about my assets\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D16))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N18,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC1",15,"Cross-cutting outcomes","Appropriate attitude towards asking for help","Confident in knowing when to ask for help","New \nCognitively tested in Round 2","How much do you agree or disagree with the following statement?\n - I am confident I know when to ask for help managing my finances when I need it\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","This question assesses general confidence in asking for help. However, for older people with assets, it may be more useful to determine their willingness and confidence accessing paid for regulated financial advice. As the circumstances, triggers and reasons for requiring regulated financial advice are different for different people, we have not included indicators for willingness to access paid for advice. If this is something you are interested in testing, please get in touch. ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D17))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N19,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC1",16,"Cross-cutting outcomes","Appropriate attitude towards asking for help","Willing to ask for help if needed","New \nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with each of the following statement?\n - I am willing to ask for help managing my daily finances when I need it.\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D18))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N20,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC2",17,"Cross-cutting outcomes","Confident spotting and challenging a scammer ","Confident recognising scams and challenging or taking action to protect themselves ","New\nStatement 1 Cognitively tested in Round 1 and Round 2; Statements 2-4 are new.","How much do you agree or disagree with the following statement?  \n - I am confident that I can recognise when I am being taken advantage of financially\n - I feel confident I would quickly recognise a scammer if one approached me\n - I would challenge someone I thought was trying to scam me \n - If I believed someone had tried to scam me I would report this\n\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","Confidence is only an indicator that people are able to spot scams. If you want to measure changes in knowledge in recognising scams, please get in touch with MAS. Resources from organisations such as Take Five (https://takefive-stopfraud.org.uk ) may be helpful in educating older people on how to avoid scams and MAS can advise on how you can develop a question to measure how able your beneficiaries are to spot a scam.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D19))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N21,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC2",18,"Cross-cutting outcomes","Confident spotting and challenging a scammer ","Aware they could become a victim of a scam","New\nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with the following statement?  \n - As a retiree I am more at risk of being targeted by scams than other adults\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D20))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N22,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC2",19,"Cross-cutting outcomes","Confident spotting and challenging a scammer ","Confident checking whether request for financial details is coming from a reputable source","New\nPartially cognitively tested (second statement) in Round 1 and Round 2","How much do you agree or disagree with each of the following statements?\n - If someone asks for my personal or banking information, I know how to check this is a legitimate request from a reputable organisation \n - I am extremely careful before giving my bank details to other people\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D21))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N23,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MC3",20,"Cross-cutting outcomes","Confident dealing with financial guidance or regulated financial advice providers","Willing to challenge and question advice and guidance ","AOF\nCognitively tested in Round 2","How much do you agree or disagree with each of the following statements?  \n - When I am given financial advice that I am unsure of, I feel confident to challenge this advice\n- When I don't understand the financial advice I'm given, I tend to ask questions\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D22))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N24,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A1",21,null,"General financial skills","Able to manage housing and care costs","New","Which of these statements best describes how knowledgeable you feel about: \n -  Managing my housing costs \n -  Managing my care costs \n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable","If you are looking for more questions about general financial skills, a larger set of questions is available in the Adult's Financial Capability Outcomes Framework (https://www.fincap.org.uk/outcomes_adults)",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D23))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N25,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A1",22,null,"General financial skills","Able to apply for pension credits if needed","AOF\nCognitively tested in Round 1 and Round 2","Which of these statements best describes how knowledgeable you feel about: \n - Applying for pension credits\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable","If you are looking for more questions about general financial skills, a larger set of questions is available in the Adult's Financial Capability Outcomes Framework (https://www.fincap.org.uk/outcomes_adults)",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D24))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N26,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A1",23,null,"General financial skills","Able to check bank balance","AOF","Which of these statements best describes how knowledgeable you feel about: \n - Checking the balance on your bank account\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable","If you are looking for more questions about general financial skills, a larger set of questions is available in the Adult's Financial Capability Outcomes Framework (https://www.fincap.org.uk/outcomes_adults)",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D25))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N27,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A1",24,null,"General financial skills","Know how to make their money go further ","AOF","Which of these statements best describes how knowledgeable you feel about: \n - using a price comparison website \n - comparing different types of insurance\n - comparing savings products \n- checking you’re getting all benefits you are entitled to\n - checking that you are paying the correct amount of tax\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable","If you are looking for more questions about general financial skills, a larger set of questions is available in the Adult's Financial Capability Outcomes Framework (https://www.fincap.org.uk/outcomes_adults)",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D26))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N28,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A2","25a",null,"Digital skills for management of finances","Able to manage bank accounts online, check benefit entitlement online, and transact online (e.g, shopping around online, paying bills)","New\nCognitively tested in Round 1","How much do you agree or disagree with each of the following statements?:\n - I can check the balance on my bank account using online banking\n - I can check the recent transactions on my bank account using online banking\n - I can transfer money between accounts using online banking\n - I can check which benefits I am entitled to using the internet\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","Whilst the three measurements of digital skills for financial management are the most relevant to finances, interventions focusing on developing digital skills should consider measuring change using the Basic Digital Skills Framework. This tested framework breaks digital skills into five categories: managing information, communicating, transacting, problem-solving, and creating. The framework can be seen here: https://doteveryone.org.uk/digital-skills/digital-skills-framework/ \nAlternatively, the EU-backed comprehensive digital skills indicator is available here: https://ec.europa.eu/digital-single-market/en/news/new-comprehensive-digital-skills-indicator ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D27))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N29,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A2","25b",null,"Digital skills for management of finances","Able to manage bank accounts online, check benefit entitlement online, and transact online (e.g, shopping around online, paying bills)","DSK (2.3)","Do you access to the internet at home or elsewhere?\n1. Yes\n2. No\n3. Don't know\n\nIF DO HAVE ACCESS\nI’d like you to think about different commercial transactions people do in their everyday lives like banking or shopping. How often do you use the internet for the following purposes? \n- Buying a product online\n- Making travel reservations/bookings\n- Paying bills\n- Using your bank’s online services\n- Comparing products and services\n- Ordering groceries or food online\n- Selling things online\n- Finding the location of a house,  office, store or restaurant \n\n1. Several times a day\n2. Daily\n3. Weekly\n4. Monthly\n5. Less than monthly\n6. Never\n7. Don't know","Whilst the three measurements of digital skills for financial management are the most relevant to finances, interventions focusing on developing digital skills should consider measuring change using the Basic Digital Skills Framework. This tested framework breaks digital skills into five categories: managing information, communicating, transacting, problem-solving, and creating. The framework can be seen here: https://doteveryone.org.uk/digital-skills/digital-skills-framework/ \nAlternatively, the EU-backed comprehensive digital skills indicator is available here: https://ec.europa.eu/digital-single-market/en/news/new-comprehensive-digital-skills-indicator ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D28))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N30,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A3",26,null,"Awareness of guidance and regulated financial advice providers and how to access them","Know where to go for guidance ","AOF"," Which of these statements best describes how knowledgeable you feel about:  \n- where to get  guidance if you need help with your finances\n\n1. I have an excellent knowledge\n2. I have a good knowledge\n3. I have a basic knowledge\n4. I know nothing about this\n5. Not applicable",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D29))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N31,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","A3",27,null,"Awareness of guidance and regulated financial advice providers and how to access them","Understand when regulated financial advice is beneficial","New\nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with the following statement?  \n - I know enough about regulated financial advice (such as mortgage brokers, investment adviser or pension adivser) to know when I should approach one\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","This question may only be relevant to older people with assets who are facing certain life changes or decisions, for example, how to fund care costs. If you have the opportunity, ask an open question about when they would approach a regulated financial advisor - even if older people are confident in their knowledge, they may only approach financial advisers in extreme circumstances.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D30))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N32,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM1",28,"Managing money well day to day","Live within means","Has enough income to meet everday expenditure ","AOF: WAS Orunout","How often these days do you run out of money before the end of the week or month or need to use a loan, credit card or overdraft to get by? \nCHOOSE ONE ONLY\n\n1. Always\n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D31))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N33,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM1",29,"Managing money well day to day","Live within means","Not experiencing material deprivation","AOF: SILK Afford","Looking at this list, can I just check whether your household could afford the following things? \nCHOOSE ALL THAT APPLY\n\n1. A week's annual holiday away from home\n2. Buying new, rather than second hand, clothes\n3. Keeping your home adequately warm in winter\n4. Having friends or family for a drink or meal once a month\n5. Going out or socialising\n6. A hobby or leisure activity\n7. Replacing a major electrical appliance (e.g. fridge)\n8. Keeping your home in a decent state of decoration\n9. None of these (SINGLE CODE ONLY)",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D32))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N34,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM1",30,"Managing money well day to day","Live within means","Has sufficient cash savings to cover a small unexpected bill","Fincap F2","Thinking about an unexpected bill which you have to pay within seven days from today.\nWhich, if any of the following would you do to pay a bill of £300? \nIf you think you would do more than one, please select the main thing you would do, that is the one you would get the most money from.\nPLEASE SELECT ONE ONLY\n\n1. I would pay it with my own money, without dipping into savings or cutting back on essentials\n2. I would pay it with my own money, without dipping into savings but I would have to cut back on essentials\n3. I would have to dip into savings \n4. I would use a form of credit (e.g. credit card, take out a loan or make use of an authorised overdraft facility)\n5. I would go overdrawn without authorisation\n6. I would get the money from friends or family as gift or loan\n7. I would have to sell personal/household item(s) to get the money  \n8. I would not be able to pay this expense\n9. Don’t know\n10. Prefer not to say",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D33))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N35,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM2",31,"Managing money well day to day","Financial situation supports wellbeing","Satisfied with financial circumstances ",null,"How satisfied are you with your overall financial circumstances? \n\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all satisfied’ and 10 is ‘completely satisfied’ \n\n0 Not at all satisfied\n...\n10 Completely satisfied\nDon’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D34))),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),1),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N36,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM2",32,"Managing money well day to day","Financial situation supports wellbeing","Financial situation does not affect mental health by causing stress or anxiety ","AOF: NI L&T 2000 LoseJob and DAE Q28","A) To what extent, if at all, do you worry about your current financial situation?\nCHOOSE ONE ONLY\n\n1. Worry a great deal \n2. Worry to some extent \n3. Worry a little \n4. Don’t worry at all \n5. Don’t know\n\nB) And which of the following, if any, do you experience these days because of your household's financial situation?\nCHOOSE ALL THAT APPLY\n\n1. Stress or anxiety\n2. Low mood or depression\n3. Difficulty concentrating or relaxing\n4. Difficulty sleeping\n5. Panic attacks\n6. Difficulty eating, or eating too much\n7. Increased use of alcohol \n8. Dependence on prescription or over-the-counter drugs\n9. Use of illicit (illegal) drugs\n10. None of these (SINGLE CODE ONLY)\n11. Don't know\n12. Prefer not to say",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D35))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N37,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WM2",33,"Managing money well day to day","Financial situation supports wellbeing","Do not feel money has a negative impact on their social life","ELSA","Shortage of money stops me socialising / seeing friends and family\n\n1 Often\n2 Sometimes\n3 Not often\n4 Never",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D36))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N38,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BM1","34a","Managing money well day to day","Budget and keep track of finances","Keep track of income and spending","AOF:Fincap F2","Which of these best describes how accurately you know how much money you have to spend at present, excluding any savings?  We’re not interested in how much money you have, just how accurately you know how much money you have to spend. \nCHOOSE ONE ONLY\n\n1. I know within a pound or two\n2. I know within £10 \n3. I know within £50\n4. I know within £100 \n5. I know within £500\n6. I have no idea at all",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D37))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N39,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BM1","34b","Managing money well day to day","Budget and keep track of finances","Keep track of income and spending","AOF:Fincap F2","Which of these do you regularly use to keep track of your income and spending? Please select all that apply. \n1. An online budgeting tool\n2. An App on a mobile or other electronic device\n3. A spreadsheet\n4. A piece of paper\n5. An accounts book or notebook\n6. A financial software package\n7. By checking my bank balance\n8. By reviewing  bank statements\n9. In my head\n10. Other (please specify)\n11. I don’t keep track\n12. Don’t know ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D38))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N40,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BM1","35a","Managing money well day-to-day","Budget and keep track of finances","Create and stick to a viable budget","FinCap 14","A) How closely do you normally plan how you will spend your money over the coming week or month? For example by drawing up a budget.\nCHOOSE ONE ONLY\n\n1. Very closely\n2. Fairly closely\n3. Not very closely\n4. I do not plan my spending at all\n5. Don't know\n\nB) And, how often do you keep to the budget you set?\nCHOOSE ONE ONLY\n\n1. Always \n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never\n6. Do not budget",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D39))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N41,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BM1","35b","Managing money well day-to-day","Budget and keep track of finances","Create and stick to a viable budget","FinCap 14","To what extent would you say the following applies to you?\n- I think of my money in terms of “pots” put aside for different things.\n\nPlease answer on a scale of 0 to 10, where 0 means it doesn’t sound like you at all and 10 means it sounds a lot like you",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D40))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N42,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BM2",36,"Managing money well day-to-day","Claim benefits that they are entitled to","Take up benefits when entitled (e.g., pension credits, benevolent funds) ","AOF \nCognitively tested in Round 1 and Round 2\nProxy question new","We have not included a measure of this behaviour as the actions an individual should take and when will differ depending on the their circumstances, the benefits they are claiming and changes to welfare policy.  \n\nIf your intervention is seeking to maximise beneficiary's income by supporting them to claim benefits, you might consider using changes to beneficiaries income alongside other administration data (e.g. whether the advisor helped them to make a claim) to evidence this. Please get in touch with the Money Advice Service if you would like help deciding how best to measure this outcome.   \n\nWe have included a question on knowledge of benefits and checking entitlement as a proxy measure for this outcome. This may be relevant if your intervention is seeking to promote awareness and uptake of benefits amongst older people. \n\nDid you know that there are some government benefits designed for older people which you might be entitled to?\n1. Yes\n2. No\n\nIF Yes: Have you ever looked into whether you are entitled to these benefits?\n1. Yes\n2.No ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D41))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N43,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MM1",37,"Managing money well day to day","Confident in managing finances","Confident in managing money","AOF: Fin cap survey (B3)","How confident do you feel managing your money?\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all confident and 10 is ‘very confident'.\n\n 0…10 scale\nDon't know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D42))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N44,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MM1",38,"Managing money well day to day","Confident in managing finances","Confident to choose appropriate products/services","AOF:Fincap (B4)","How confident do you feel making decisions about financial products and services?  \nPlease answer on a scale of 0 to 10, where 0 is ‘not at all confident and 10 is ‘very confident'.\n\n 0…10 scale\nDon't know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D43))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N45,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MM2",39,"Managing money well day to day","Feel entitled to claim benefits","Feel entitled to claim  benefits","New\nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with each of the following statements?  \n-  I am reluctant to take means tested benefits (r)\n - When I have qualified for state benefits I feel comfortable taking them\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D44))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N46,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MM3",40,"Managing money well day to day","Motivated to shop around to make money go further","Willing and motivated to change service provider if needed","AOF\nCognitively tested in Round 2","How much do you agree or disagree with each of the following statements?:\n- I prefer to stick with one company over time rather than keep changing suppliers (such as utility companies) (r)\n - There's no point switching things like insurance, energy or bank accounts, it's not worth the hassle (r)\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D45))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N47,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MM4",41,"Managing money well day to day","Attitudes towards saving and spending to enjoy retirement ","Does not go without essentials (heating/food) to save money","New","How often these days do you go without food, heating or other essentials in order to save money? \nCHOOSE ONE ONLY\n\n1. Always\n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never","The balance between savings and enjoying retirement is a complex issue and therefore hard to measure. Whilst older people should seek to build a savings buffer if they need to, older people should not be putting money aside at the expense of their wellbeing. Iin cases of poverty, older people may neither have savings nor enjoy retirement. Consider whether you can capture this through conversation rather than survey measurement.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D46))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N48,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WP1",42,"Prepared for life events","Well placed to cope with life events ","Have taken steps to prepare for expected and unexpected life events",null,"There are a wide range of actions and behaviours that older people can adopt that will help them to cope better if their circumstances changed. These range from keeping all their paperwork in one place to having funds set aside for home modifications and care and having an up-to-date will.  \n\nCurrently, we do not know enough about what actions and behaviours make older people more resilient to develop specific indicators and measures. If you are plannning work to help older people to prepare for life events, please get in touch and we can support you to design some measures for your evaluation. \n\nAs part of the Financial Capability strategy, research is underway to understand how older people can be enabled and encouraged to be well placed to cope with life events.  We will use the learnings from this research to further develop this indicator.",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D47))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N49,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WP1",43,"Prepared for life events","Well placed to cope with life events ","Power of attorney on bank account is in place","New\nCognitively tested in Round 2","Do you have Power of Attorney  in place for your finances? \n\n1. Yes\n2. No\n3. Don't know\n\nDo you have any other arrangements in place to allow a third party (e.g. family member) to access your bank accounts and financial products on your behalf?\n\n1. Yes\n2. No\n3. Don't know","Part 2 on third party access is new and untested. If you use this question you may want to check whether respondents understand that third party access is a formal arrangement with their financial service provider and is not, for example, giving a family member their pin and passwords.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D48))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N50,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WP1","44a","Prepared for life events","Well placed to cope with life events ","Discuss wishes with others in case of life event","New","Is there anyone who you have talked to about your wishes in case you had a serious health issue? \n\n1. Yes\n2. No\n3. Don't know","As life events such as serious illness are sensitive topics, it may be more appropriate to explore this using qualitative methods. Contact us for advice on how to do this. ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D49))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N51,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","WP1","44b","Prepared for life events","Well placed to cope with life events ","Discuss wishes with others in case of life event","New","How confident are you that others would know what to do with your money if you had a serious health issue?\n\n1. Very confident\n2. Confident\n3. Neither confident or unconfident\n4. Not confident\n5. Not at all confident","As life events such as serious illness are sensitive topics, it may be more appropriate to explore this using qualitative methods. Contact us for advice on how to do this. ",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D50))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N52,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BP1",45,"Prepared for life events","Plan to cope with life events","Has a financial plan which includes life events","New \nCognitively tested in Round 1 and Round 2","Have you made a concrete plan, a rough plan or no plan for the following aspects of life events?\n-  Funding care costs\n-  Funding funeral \n-  Mortage repayment\n-  Debt repayment\n- Funding long term care \nPLEASE SELECT ONE ANSWER FOR EACH QUESTION\n\n1. A concrete plan \n2. A rough plan \n3. No plan \n4. NA","You may want to add or amend this list, including adding more positive life events, or events that are relevant to your beneficiary group.",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D51))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N53,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","BP2",46,"Prepared for life events","Work towards financial goals","Actively planning to achieve long-term financial goals","AOF: Fincap D2 (a few items deleted) ","A) Which, if any, of these financial goals do you have for the next five years?\nPLEASE SELECT ALL THAT APPLY\n\n1. Just making ends meet day to day\n2. Paying off my debts/reducing debts\n3. To buy, rent or move house\n4. Saving money to help grown-up children to buy/rent  a home\n5. Saving money for a holiday\n6. Saving money for home improvements\n8. Saving money generally\n9. Other (please specify)\n10. None of these (SINGLE CODE ONLY)",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D52))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N54,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MP1",47,"Prepared for life events","Consider the risks of negative life events","Aware of life events and the impact they might have on finacial situation (e.g, access to financial services, cost of care, funeral)","Northern Ireland Life and Times (2010)","Have you thought about or made any plans for how you might fund the care and support you may need as you get older? This might include in-home support or a care home.\nCODES 3,4,5,6 CAN BE MULTICODE\n1. I haven't really thought about it\n2. I've thought about it but haven’t done anything specific\n3. I’m saving money which could pay for this (e.g. savings, pension or investments)\n4. I’ve taken out insurance cover to pay for this (e.g. long-term care plan)\n5. I could sell property to pay for this\n6. I hope my family would help fund this\n7. I hope the state will fund this \n8. Other (please specify)\n9. Don't know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D53))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N55,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MP1",48,"Prepared for life events","Consider the risks of negative life events","Recognise the need to plan ahead (e.g. make will, put PoA in place)","New \nCognitively tested in Round 1 and Round 2","How much do you agree or disagree with the following statement?  \n - I need to make a plan to manage my money throughout my retirement in case my circumstances change (e.g. bereavement, illness)\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D54))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N56,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MP1",49,"Prepared for life events","Consider the risks of negative life events","Understand and thought about third party access options","New \nCognitively tested in Round 2","How much do you agree or disagree with each of the following statements?  \n - I have considered giving a third party (such as a relative) access to my bank accounts.\n - I understand how I would go about giving third party access to my bank accounts.\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D55))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N57,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MP1",50,"Prepared for life events","Consider the risks of negative life events","Willing to discuss wishes with friends and family","New","How much do you agree or disagree with the following statement? \n- In my daily life I'm willing to talk with people I trust about the financial aspects of death and ill health.\n \n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D56))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N58,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","MP2",51,"Prepared for life events","Adaptable to changing circumstances","Willing to adapt spending in response to changes in income/outgoings","AOF: Fincap O4"," I am prepared to adjust the amount of money I spend on non-essentials if my life changes: 0 (does not sound like me at all) to 10 (sounds a lot like me)\n\n0…10 scale\n11. Don't know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D57))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N59,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",52,null,"Access to financial products and services","Able to access basic financial products and services (including current account checking balances, opening new accounts and products, using features like direct debit and payment services) in a way that works for them. ","ASF: ELSA SC5 and SEG C6","How easy or difficult is it for you to do each of the following things?\nCHOOSE ONE ANSWER ONLY FOR EACH\n- Check your bank balance\n- Withdraw money\n- Open a new bank account\n- Pay for products and services without using cash\n- Transfer money to friends and family\n- Use direct debit \n\n1. Very easy\n2. Quite easy\n3. Quite difficult\n4. Very difficult\n5. Unable to do\n6. Do not wish to do this",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D58))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N60,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",53,null,"Access to appropriate guidance and regulated financial advice ","Able to access appropriate guidance and regulated financial advice on pension drawdown, money management, meeting mortgage debt/housing costs, safeguarding, long-term care, or assessments (housing, care, vulnerability)","New","How much do you agree or disagree with each of the following statements?  \nIf I needed to, I would be able to speak to a regulated financial advisor to get advice about my finances :\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n\nIf I needed to, I would be able to access free guidance about my finances using the communication method which best suits my needs (for example face to face)\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D59))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N61,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",54,null,"Socially included","Has someone they trust to discuss money issues with","New","How much do you agree or disagree with the following statement?  \n- When I have money problems I have someone I can talk with about them\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","If you are interested in measuring social isolation more generally you can try De Jong's Loneliness scale. This is a tried and tested scale of six questions measuring loneliness. Guidance for administering can be found here:\nhttp://www.campaigntoendloneliness.org/wp-content/uploads/Loneliness-Measurement-Guidance1.pdf",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D60))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N62,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",55,null,"Good physical and mental health","Limitation due to health condition","Tested measure for Healthy Life Years (HLY) used across Europe.","For at least the past six months, to what extent have you been limited because of a health problem in activities people usually do? \n\n1. Severely limited\n2. Limited but not severely \n3. Not limited at all","If you are interested in physical health, you can also consider the European Quaity of life scale (EuroQol). This is a much longer set of questions that requires some specialised analysis. Guidance for administering the EuroQol can be found here: http://www.euroqol.org/fileadmin/user_upload/Documenten/PDF/Folders_Flyers/EQ-5D-5L_UserGuide_2015.pdf \nIf you are interested in measuring wellbeing, the most used scale in the UK is the Warwick and Edinburgh Mental Wellbeing Scale (WEBWBS). This is a well test scale which comes in a short (7 questions) and long (14 questions). Guidance for the short version is here: http://www.healthscotland.com/documents/4741.aspx",null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D61))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N63,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",56,null,"Sufficient income to meet basic needs \n","Enough income to cover basic needs",null,"This should be explored through an assessment of beneficiaries income and expenditure, as well as scope for maximising their income. ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D62))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N64,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","U",57,null,"General skills (literacy and numeracy)","Able to apply mathematical skills to financial problems, fill in forms, write formal letters in English (or Welsh in Wales) and confidently interact with others in English (or Welsh in Wales)",null,"A) How good are you at the following:\n - Working with numbers when you need to in everyday life? For example working out your income or benefits, or checking bills and statements?\n - Working with numbers when you need to in everyday life? For example working out your benefits, or checking bills and statements?\n -  Writing in English when you need to in daily life? For example: writing letters or notes or filling in official forms?\n - Reading in English when you need to? For example reading newspapers and magazines or reading letters, paperwork or forms?\n\n1. Very good \n2. Fairly good \n3. Below average \n4. Poor \n5. No opinion\n6, Don't Know  \n\nB) Can I check, is English or Welsh your first language?  \nYes - English\nYes - Welsh\nNo, neither\n\n[IF NEITHER]  So can I check would you have any difficulty speaking in English or Welsh to a member of staff in a bank about choosing a financial product?\n1. Yes\n2. No",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D63))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N65,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","D",58,null,null,"Sex","LFS UK Q2 2013","Sex \n\n1. Male\n2. Female",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D64))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N66,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","D",59,null,null,"Age","LFS SP 2016 ENG","A) What is your date of birth?  \n\nDay: ___ Month:___Year:___\n\nOR \nB) How old are you?",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D65))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N67,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","D",60,null,null,"Civil status","LFS SP 2016 ENG","What is your marital status?\n\n1. Single\n2. Married \n3. Widower \n4. Separated or divorced \n5. A civil partner in a legally-recognised Civil \n6. Partnership\n7. Other\n8. Does not know/ N/A ",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D66))),\"\")","v":""},"",{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),3),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),4),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),5),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),6),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),7),\"\")","v":""},{"$f":"IFERROR(INDEX($C$3:$J$73,MATCH($N68,$D$3:$D$73,0),8),\"\")","v":""}]
[false,"Out","D",61,null,null,"Marital property regime","Castellanos Serrano (2016)","Do you know if a marital property regime applies to your marriage? \n\n1. Yes\n2. No",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D67))),\"\")","v":""}]
[false,"Out","D",62,null,null,"Urbanity","SP (2009) (adapted)","Size and name of the municipality________________________\n\n1. Up to 5.000 inhabitants.\n2. 5,001 – 10,000 inh.\n3. 10,001 – 20,000 inh.\n4. 20,001 – 100,000 inh.\n5. 100.000 - 1,000,000 inh.\n6. more than  1,000,000 inh.",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D68))),\"\")","v":""}]
[false,"Out","D",63,null,null,"Nationality","LFS SP 2016 ENG","What is your nation of birth? ________________________",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D69))),\"\")","v":""}]
[false,"Out","D",64,null,null,"Years of involvement in the UK","LFS SP 2016 ENG","In which year did you arrive to the UK? ________________________",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D70))),\"\")","v":""}]
[false,"Out","D",65,null,null,"Ethnicity",null,"How would you describe your ethnicity?\n\n1. White UK\n2. White Irish\n3. White Other\n4. Arab\n5. Asian/Asian British – Indian\n6. Asian/Asian British – Pakistani\n7. Asian/Asian British – Bangladeshi\n8. Asian/Asian British - Other _____specify\n9. Black/Black British – Caribbean\n10. Black/Black British – African\n11. Black/Black British - Other ______ specify\n12. Hispanic/Latino \n13. Mixed ethnicity - White and Black Caribbean\n14. Mixed ethnicity - White and Black African\n15. Mixed ethnicity - White and Asian\n16. Mixed ethnicity - Other _______ specify\n17. Other ____________\nPrefer not to say",null,null,null,null,{"$f":"IFERROR(INDEX(D$2:D$73,SMALL(IF(B$2:B$73=\"In\",ROW(D$2:D$73)-1),ROW(D71))),\"\")","v":""}]

{"sheet":"Output File","index":31,"n_rows":74,"n_cols":9,"rows_kept":74,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Question No.","Area","Higher level outcome","Lower level outcome","Indicator","Original source","Final framework question","Notes for users"]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,"","","","","","","",""]
[null,""]
[null,""]
[null,""]
[null,""]
[null,""]

{"sheet":"1. Financial wellbeing","index":32,"n_rows":14,"n_cols":12,"rows_kept":14,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Original source","Status","Final framework question","Require testing? (Yes, No, Potentially)","Reason for testing (if applicable)","Adapt for pre/post?","Notes for users"]
[null,1,"Ability to live (adequately) within means","Managing well day-to-day","Satisfaction with standard of living \n","USOC Finnow","Adapted","How well would you say you yourself are managing financially these days? Would you say you are...\nCHOOSE ONE ONLY\n1. Living comfortably\n2. Getting by alright\n3. Just about getting by\n4. Finding it quite difficult\n5. or finding it very difficult?","No - removes only \"[yourself]\" qualifier from the question.",null,"No"]
[null,2,"Ability to live (adequately) within means","Managing well day-to-day","Satisfaction with standard of living \n","Fincap (B2) - originally ONS","Original","Overall, how satisfied are you with your life nowadays?\n\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all satisfied’ and 10 is ‘completely satisfied’ \n\n0 Not at all satisfied\n...\n10 Completely satisfied\nDon’t know","No",null,"No","Use a visual 0 to 10 scale with the statements indicated attached the extremes.\n\nUse in conjuction with question 1, to demonstrate impact of improved financial capability on wider wellbeing"]
[null,3,"Ability to live (adequately) within means","Managing well day-to-day","Satisfaction with standard of living","OECD QF10","Adapted","I am now going to read out some statements. I would like to know how much you agree or disagree with each of the following statements. \n- My financial situation limits my ability to do the things that are important to me \n- I am satisfied with my present financial situation\nCHOOSE ONE FOR EACH\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","No - slight wording changes","Are the different items distinct? Does it matter if people think they overlap?\n\nLow priority as there are 2 other questions within this indicator.","No"," "]
[null,4,"Ability to live (adequately) within means","Managing well day-to-day","Living within means\n","WAS ORunout","Adapted","How often these days do you run out of money before the end of the week or month or need to use a loan, credit card or overdraft to get by?\nCHOOSE ONE ONLY\n1. Always,\n2. Most of the time,\n3. Sometimes,\n4. Hardly ever,\n5. Never","Potentially - 'these days' replaced past 12 months  ","Test 'these days' in the context of running out. What reference period do people have in mind?\n\nLow priority as possible to use Q5, also change is minor and may not require testing","No"]
[null,6,"Ability to live (adequately) within means","Self-reported financial difficulty",null,"Fincap J1","Changed","Which one of the following statements best describes how well you are keeping up with your bills and credit commitments at the moment? [Please include those you have personally or jointly with your partner/spouse]\nCHOOSE ONE ONLY\n1. Falling behind\n2. It is a constant struggle\n3. It is a struggle from time to time\n4. Keeping up without any difficulties\n5. Don’t have any bills or credit commitments\n6. Don't know\n8. Prefer not to say","Yes - questions editted for conciseness and to remove I/we. Responses have been re-ordered.","This is essentially a new question. Test whether people understand all the response codes and state falling behind if they have any arrears. Do they think about all their commitments, including those of the household which they are responsible for?","No"]
[null,{"$f":"B7+1","v":7},"Ability to live (adequately) within means","Falling behind/in debt/in arrears",null,"FFH Unable","Adapted","In the last [SIX] months, have [you / or your partner] been unable to pay any of these bills due to a lack of money?\nCHOOSE ALL THAT APPLY\n1. Rent or mortgage payments\n2. Council tax\n3. Gas, electricity or other fuel bills\n4. Water bill\n5. Telephone bill (including mobile phone, broadband)\n6. Credit or store card bills\n7. Repayments on a loan or advance,\n8. Repayments on goods bought on hire purchase or mail order\n9. TV licence\n10. Income Tax or VAT payments\n11. Any other bill or regular commitment\n12. None of these (SINGLE CODE ONLY)","No - modified only to reflect change to reference period","No - Will need to check that users are able to change reference period","No, but note use of reference period in question","Practitioners can change [six] months to a reference period which is consistent with the lapsed time between the intervention and follow up measurement"]
[null,{"$f":"B8+1","v":8},"Ability to live (adequately) within means","Material deprivation",null,"WB B3","Adapted","How often these days do you and your household go without food, heating, bills or other necessary items due to a lack of money?\nCHOOSE ONE ONLY\n1. Always,\n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never","Yes","What do people understand by the examples given in the question? Is there a seasonal effect, given mention of heating. Also test 'these days'.\n\nLow priority as there is another tested question within the indicator","No"]
[null,9,"Ability to live (adequately) within means","Material deprivation",null,"SILC Afford","Adapted","Looking at this list, can I just check whether your household could afford the following things? \nCHOOSE ALL THAT APPLY\n1. A week's annual holiday away from home\n2. Buying new, rather than second hand, clothes\n3. Keeping your home adequately warm in winter\n4. Having friends or family for a drink or meal once a month\n5. Going out or socialising\n6. A hobby or leisure activity\n7. Replacing a major electrical appliance (e.g. fridge)\n8. Keeping your home in a decent state of decoration\n9. None of these (SINGLE CODE ONLY)","No - Minor changes to options drawing on alternative questions",null,"No"]
[null,10,"Financial resilience - ability to withstand financial shocks",null,null,"Fincap I10","Adapted","Thinking about an unexpected bill which you have to pay within seven days from today.\n\nWhich, if any of the following would you do to pay a bill of £300? \n\nIf you think you would do more than one, please select the main thing you would do, that is the one you would get the most money from.\nCHOOSE ONE ONLY\n1. I  would pay it with my own money, without dipping into savings or cutting back on essentials\n2. I would pay it with my own money, without dipping into savings but I would have to cut back on essentials\n3. I would have to dip into savings \n4. I would use a form of credit (e.g. credit card, take out a loan or make use of an authorised overdraft facility)\n5. I would go overdrawn without authorisation\n6. I would get the money from friends or family as gift or loan\n7. I would have to sell personal/household item(s) to get the money  \n8. I would not be able to pay this expense\n9. Don’t know \n10. Prefer not to say","No - minor changes to remove \"we/our\" qualifier from the question",null,"No"]
[null,11,"Financial resilience - ability to withstand financial shocks",null,null,"Genworth","Adapted","Do you (and your partner) currently have at least as much money in savings as you get in income each month? \nCHOOSE ONE ONLY\n1. No\n2. Yes, about 1 month\n3. Yes, about 2 months\n4. Yes, three months of more\n\n","Potentially","Do people feel able to make the calculations and then select the code that best apply\n\nFinCap q is complex / long - need a concise alternative for short questionairres ","No"]
[null,12,"Finances and emotional/mental wellbeing",null,null,"NI L&T 2000 LoseJob and DAE Q28","Changed","A) To what extent, if at all, do you worry about your current financial situation?\nCHOOSE ONE ONLY\n1. Worry a great deal \n2. Worry to some extent \n3. Worry a little \n4. Don’t worry at all \n5. Don’t know\n\nB) And which of the following, if any, do you experience these days because of your household's financial situation?\nCHOOSE ALL THAT APPLY\n1. Stress or anxiety\n2. Low mood or depression\n3. Difficulty concentrating or relaxing\n4. Difficulty sleeping\n5. Panic attacks\n6. Difficulty eating, or eating too much\n7. Increased use of alcohol \n8. Dependence on prescription or over-the-counter drugs\n9. Use of illicit (illegal) drugs\n10. None of these (SINGLE CODE ONLY)\n11. Don't know\n12. Prefer not to say","Potentially","These are essentially new questions. Are the response codes at B meaningful and comprehensive; are people comfortable choosing them?","No","Both questions can be asked, but in this order."]
[null,13,"Confidence in financial future",null,null,"BASE QCstali ","Adapted","Taking everything into account, how confident are you that you will have enough money to give you the standard of living you hope for in a year from now?\nCHOOSE ONE ONLY\n1. Very confident\n2. Fairly confident\n3. Not very confident\n4. Not at all confident\n5. Don’t know","No - minor change from 'in retirement' to 'in a year from now'",null,"No"]

{"sheet":"4. Behaviour","index":33,"n_rows":27,"n_cols":13,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Additional subindicator","Original Source","Status","Final framework question","Require testing? (Yes, No, Potentially)","Reasons for testing (if applicable)","Adapt for pre/post?","Notes for users"]
[null,1,"Dealing with financial difficulties",null,"Taking steps to reduce their debt (such contacting creditors, sticking to an agreed repayment plan etc.) or to reduce their spending/commitments ",null,"Fincap J4","Changed","PRE\nWhich, if any, of the following steps have you taken [in the last X months] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nPOST\nWhich, if any, of the following steps have you taken since [REFERENCE POINT] to reduce the amount of money you owe on your outstanding debts, including credit commitments and bill arrears?\nCHOOSE ALL THAT APPLY\n1. Increased my regular payments\n2. Paid a lump sum towards them\n3. Spoken to my lender\n4. Sought independent advice (e.g. from Citizen's Advice Bureau, StepChange, Money Advice Service, [OTHERS])\n5. Consolidate your loans or credit cards\n6. Set up a Debt Management Plan or Debt Arrangement Scheme\n7. Arranged to write off some or all of my debts (e.g. Applied for bankruptcy or a debt relief order or set up an IVA)\n8. None of these  (SINGLE CODE ONLY)\n9. Do not have any debts  (SINGLE CODE ONLY)\n","Yes","Response code may be too long and not coherent (or comprehensive) enough","Yes","Practitioners can optionally insert additional actions relevant to their intervention prior to code 'None of these'. Actions need to be relevant, clearly stated and as succinct as possible.\n\nPractitioners will need to insert a reference period which is relevant to their intervention and, if using the POST version, change REFERENCE POINT to something relevant to intervention (e.g. since the workshop, or since you last saw us)."]
[null,{"$f":"B3+1","v":2},"Managing money well day-to-day",null,"Keeping track of income and spending",null,"Fincap F2","Adapted","Which of these best describes how accurately you know how much money you have at present, excluding any savings?  We’re not interested in how much money you have, just how accurately you know how much money you have to spend. \nCHOOSE ONE ONLY\n1. I know within a pound or two\n2. I know within £10 \n3. I know within £50\n4. I know within £100 \n5. I know within £500\n6. I have no idea at all\n\n","Potentially","It would be useful to see how respondents cope with the values given in the response codes. Do they feel they prompt them into saying they know within a pound or two (consider testing a question with codes reversed).","No","This question should be asked before asking respondents about how they keep track of their money (Q3)."]
[null,{"$f":"B4+1","v":3},"Managing money well day-to-day",null,"Keeping track of income and spending",null,"Fincap F4","Adapted","Which, if any, of the following describe what you do to keep track of your money?\nCHOOSE ALL THAT APPLY\n1. Keep a mental note/ a note in my head\n2. Keep a spending diary, log or spreadsheet\n3. Keep receipts\n4. Check your balance\n5. Compare receipts/spending against your statements\n6. Check all incomings and outgoings on your statements\n7. Compare spending between one month and another\n8. File and retain statements\n9. Something else\n10. None of these  (SINGLE CODE ONLY)\n\n","Potentially","To check the response codes are meaningful and come in an order which makes sense","No","Practitioners can optionally insert additional actions relevant to their intervention prior to code 'Something else'. Actions need to be relevant, clearly stated and as succinct as possible.\n\nPositive change includes movement from 1 or 10 to any others and / or increasing the number of behaviours they have adopted "]
[null,4,"Managing money well day-to-day",null,"Creating and sticking to a viable budget",null,"CitA 3","Adapted","A) How closely do you normally plan how you will spend your money over the coming week or month? For example by drawing up a budget.\nCHOOSE ONE ONLY\n1. Very closely\n2. Fairly closely\n3. Not very closely\n4. I do not plan my spending at all\n5. Don't know\n\nB) And, how often do you keep to the budget you set?\nCHOOSE ONE ONLY\n1. Always \n2. Most of the time\n3. Sometimes\n4. Hardly ever\n5. Never\n6. Do not budget","No - (A) Minor re-drafting of question wording, drawing on similar, alternative questions",null,"No","Both questions should be used together, in this order."]
[null,5,"Managing money well day-to-day",null,"Creating and sticking to a viable budget",null,"FinCap I4","Adapted","To what extent would you say the following applies to you?\n\n- I think of my money in terms of “pots” put aside for different things.\n\nPlease answer on a scale of 0 to 10, where 0 means it doesn’t sound like you at all and 10 means it sounds a lot like you\n","No - removal only of autofill text which refers to partner/spouse",null,"No","Use a visual 0 to 10 scale with the statements indicated attached the extremes."]
[null,6,"Managing money well day-to-day",null,"Managing bill payments - pay bills on time (and in full if possible) ",null,"DAE Q19","Adapted","How often do you delay or miss paying a bill, beyond the date it becomes due?\nCHOOSE ONE ONLY\n1. I often do this \n2. I occasionally do this \n3. I rarely do this \n4. I never do this","Potentially","How do people understand the due date","No"]
[null,7,"Managing money well day-to-day",null,"Managing bill payments - pay bills on time (and in full if possible)",null,"BASE Qbplan","Adapted","How well do you usually plan ahead to make sure you have the money to pay for regular bills and expenses? \nCHOOSE ONE ONLY\n1. Plan ahead to cover the full amount\n2. Plan ahead to cover some of the amount\n3. Don't plan ahead because there is always enough money to cover them\n4. Don't plan ahead at all\n","Yes","This is essentially a new question and the response codes are not mutually exclusive. Also conflates affordability with planning.","No"]
[null,8,"Managing money well day-to-day",null,"Maximising income (e.g.. claim benefits, shopping around for best deals etc.) ","Shopping around for the best deals ","Fincap E14","New","A) When did you last do each of the following things?:\n\n- Compared bank accounts to make sure you are not paying more fees or charges than you need to pay\n- Compared saving accounts to make sure you are receiving the best rate of interest on your savings\n- Compared credit cards or loans to make sure you are paying as little in interest as possible\n - Compared electricity or gas deals to make sure you are on the best deal available\n- Compared phone,  broadband or TV deals to make sure you are on the best deal available\n- Compared insurance policies (e.g. car, home, pet) to make sure you are on the best deal available\nCHOOSE ONE FOR EACH\n1. Within the last month\n2. Between one and three months ago\n3. Between three and six months ago\n4. Between six and one year ago\n5. Between one and five years ago\n6. More than five years ago\n7. Never \n8. Not applicable - don't have or need this\n\nB) And thinking about the last time you checked whether you were on the best deal, what did you do as a result?\nCHOOSE ONE FOR EACH CODED 1-6 ABOVE\n1. I switched product or provider \n2. I chose to stay with my current product/provider \n3. I haven’t made my mind up\n4. Don't know/can't remember","Yes","The question needs considerable development and then testing","Yes, potentially, in relation to timeframes","This question may not be needed if the one above is adequate. \n\nPractitioners can select which of the actions they wish to include and add additional items if appropriate. New items should be relevant, clear and as succinct as possible\n\nThese questions should be asked in this order. B need not be asked if response to A is 7 or 8.\n\nFor measurement at post intervention, users will need to take into account the long time periods referenced in the answers to A, as longer periods may overlap with pre-intervention"]
[null,9,"Managing money well day-to-day",null,"Maximising income (e.g.. claim benefits, shopping around for best deals etc.)","Shopping around for the best deals ","CitA","Adapted","Which of the following things, if any, do you currently do to make your money go further?  \nCHOOSE ALL THAT APPLY\n1. Shop around for food and groceries \n2. Look out for special offers or reduced items\n3. Plan meals in advance \n4. Make a shopping list\n5. Avoid treats and non-essential items\n6. Use money saving tips\n7. Turn lights/power off at home when they are not in use\n8. Check the charges on essential bills such as electricity or phone to see if there is a cheaper tariff or supplier available  \n9. None of these","No - minor change only to question text to remove reference to \"regular\" actions and addition (5,6,8) and slight modification of actions (4), ideas taken from other alternative questions",null,"No","Practitioners can optionally insert additional actions relevant to their intervention prior to code 'None of these'. Actions need to be relevant, clearly stated and as succinct as possible."]
[null,10,"Managing money well day-to-day",null,"Maximising income (e.g.. claim benefits, shopping around for best deals etc.) ","Shopping around for the best deals ","X","New","When choosing or renewing a product such as mobile phone contracts, energy tariffs, or credit cards which of the following is most like you.\nCHOOSE ONE ONLY\n1. I always spend time comparing different products  \n2. I sometimes spend time comparing different products but I don't always have the time\n3.  I  tend to make decisions based on convenience rather than shopping around.","Yes","New question","No"]
[null,{"$f":"B12+1","v":11},"Managing money well day-to-day",null,"Maximising income (e.g.. claim benefits, shopping around for best deals etc.)","Claiming benefits ","X","New","When did you last do each of the following things?:\n- Checked whether you are receiving all the benefits, tax credits or pension that you are entitlement to\n- Applied for new or additional benefits, tax credits or pension that you are entitled to\n- Increased or tried to increase your income in some other way (e.g. applied for a job, claimed grants)\nCHOOSE ONE FOR EACH\n1. Within the last month\n2. Between one and three months ago\n3. Between three and six months ago\n4. Between six and one year ago\n5. Between one and five years ago\n6. More than five years ago\n7. Never (SINGLE CODE ONLY)\n8. Not applicable - don't have or need this 9SINGLE CODE ONLY)","Yes","These are new questions","No","Practioners can select which of the actions they wish to include and add additional items if appropriate. New items should be relevant, clear and as succinct as possible"]
[null,12,"Managing money well day-to-day",null,"Using credit responsibly/sensibly",null,"Fincap E10","Changed","Which of the following describes how you normally repay the money owed on your credit or store card(s) ?\nCHOOSE ONE ONLY\n1. The minimum payment allowed\n2. More than the minimum but less than the full amount\n3. The full amount\n4. It varies too much to say\n5. Don’t know\n6. Prefer not so say","No - simplification of the question and response codes, based on alternative, established questions",null,"No"]
[null,13,"Managing money well day-to-day",null,"Using credit responsibly/sensibly ]",null,"DAE Q23","New","Which of the following, if any, do you currently have? \nCHOOSE ALL THAT APPLY\n1. A credit card which you are using to pay off another card\n2. A credit or store card which you are unable to make the minimum payments on\n3. A loan, hire purchase or mail order account which you are unable to pay when the payment(s) came due  \n4. A loan, including a payday or pawnbroking loan, which you have rolled over, extended or renewed\n5. An authorised overdraft balance which is getting bigger each month \n6. An unauthorised overdraft which you are using\n7. Money you have borrowed from an unlicensed lender ('loan shark') \n8. None of these (SINGLE CODE ONLY)\n9. Don't know (SINGLE CODE ONLY)\n10. Prefer not to say (SINGLE CODE ONLY)","Yes","New question. ","No"]
[null,14,"Managing money well day-to-day",null,"Using credit responsibly/sensibly",null,"WB B4a and HCC 8.9","Changed","A) Do you and your household ever [use credit or borrow money] to buy food or pay for other necessary items because you have run short of money?\nCHOOSE ONE ONLY\n1. Yes, regularly\n2. Yes, sometimes \n3. No\n\nB) And which of the following types of credit would you normally use to pay for food or other necessary items?\n1. Credit or store card\n2. Overdraft \n3. Payday loan\n3. Loan from company that collects payments from your home (e.g. Provident, Greenwoods)\n5. Loan from a pawnbroker\n7. Loan from a Credit Union or other community finance organisation\n8. A loan from a friend or relative.\n9. Loan from the Social Fund\n10. Loan from an unlicensed lender who charges interest, sometimes called a loan shark\n11. Any other type of loan from a bank, building society or finance company e.g. Norton Finance, Blackhorse car finance\n11) Something else\n12) Don't know\n13) Prefer not to say","No - recast from yes/no into frequency question using standard question wording, also only minor changes to question wording which draws on existing alternative survey questions",null,"No"]
[null,15,"General saving behaviour ",null,"Saving on a regular basis ",null,"FinCap G3 and G4\n\nCitA Q33","Original\n\nChanged","A) Which of these best describes how often you save money?\nCHOOSE ONE ONLY\n1. Every month\n2. Most months\n3. Some months, but not others\n4. Rarely/never\n5. Don’t know\n\nB) Just thinking about the months that you save money is the amount that you save…\n1. Roughly the same each month\n2. A little different from month to month\n3. Very different from month to month\n4. Don’t know\n\nC) About how much on average do you personally manage to save each month, at the moment? \nENTER AMOUNT IN £\nVaries too much to say","Yes","To check the modified question and response codes make sense and are as inclusive as possible\n\nHow easily can people estimate how much they save and do they need more prompts etc.","No","These questions are best asked only if an initial question has been asked which defines what we mean by saving (see, for example the question which asks In which of the following ways are you currently putting money aside or saving it for a later time?).  It is advisable to use these questions together as an integrated set."]
[null,16,"General saving behaviour ",null,"How people save ",null,"OECD QF3","Adapted\n\nOriginal\n\nChanged","In which of the following ways are you currently putting money aside or saving it for a later time? \nCHOOSE ALL THAT APPLY\n1. By saving cash at home, in your wallet or another safe place\n2. Building up a balance of money in your bank account \n3. Paying money into a savings account\n4. Paying money into a credit union account \n5. Giving money to family to save on your behalf \n6. Saving in <an informal savings club> \n7. Buying financial investment products, other than pension funds [give examples such as bonds, investment trusts, stocks and shares]\n8. Or in some other way (including remittances, buying livestock, gold or property)\n9. None of these (SINGLE CODE ONLY)\n10. Don’t know","Yes","To check the modified question and response codes make sense and are as inclusive as possible\n\nHow easily can people estimate how much they save and do they need more prompts etc.","No","The follow up questions (B,C) can only be asked if the first question has been asked to orientate people to what we mean by saving."]
[null,17,"General saving behaviour ",null,"What people save for ",null,"WAS OWhySav","New","A) People save money for different reasons.  Which, if any, of the following reasons are you saving for?\nCHOOSE ALL THAT APPLY\n1. For a specific expense, purchase or event\n2. For unexpected expenditures\n3. As a safety net or peace of mind\n4. To see my money grow/ as speculation\n5. Don't spend all of income\n6. No particular reason\n7. None of these\n\nIF CODE 1 AT A (SPECIFIC/PLANNED EXPENSES)\nB) What planned expenses, purchases or events, if any, are you saving for?\nCHOOSE ALL THAT APPLY \n1. For known or expected bills\n2. For holidays, day trips or other leisure activities \n3. For birthdays, Christmas, Eid or other celebrations\n4. Home improvements\n5. Purchasing a car/van/motorbike\n6. To buy, rent or move house\n7. A wedding\n8. Starting a family/having another child\n9. Education or change of career \n10. To help other family members financially through gifts or an inheritance\n11. To provide a regular income for the coming months\n12. To provide income for retirement\n13. Some other planned expense\n14. None of these","Yes","This essentially a new question. Does breaking the codes up into two lists work?  Does \"no particular reason\" overlap with other codes e.g. safety net.","No","Practitioners can choose to use either question or both, remembering to include the preamble once."]
[null,18,"Preparing for and managing life events",null,"Working towards relevant longer-term financial goals e.g.. home ownership",null,"Fincap D2","Original\n\n","A) Which, if any, of these financial goals do you have for the next five years?\nPLEASE SELECT ALL THAT APPLY \n1. Just making ends meet day to day\n2. Paying off my debts/reducing debts\n3. To buy, rent or move house\n4. Saving money for a wedding\n5. Saving money to start a family/have another child\n6. Saving money for education (for me or my children)\n7. Saving money to help grown-up children to buy/rent  a home\n8. Saving money for a holiday\n9. Saving money for retirement\n10. Saving money for home improvements\n11. Saving money to purchase a car/van/motorbike\n12. Saving money generally\n13. Other (please specify)\n14. None of these (SINGLE CODE ONLY)","No",null,"No"]
[null,19,"Preparing for and managing life events",null,"Saving for retirement",null,"Fincap H1","Adapted","Are you currently paying into one or more pensions? This can include an employer or any other type of private pension\nCHOOSE ONE ONLY\n1. Yes\n2. No\n3. I am retired so I am not paying into a pension\n4. Don’t know","No - minor changes only to qualifier text (types of pensions to include)",null,"No"]
[null,20,"Preparing for and managing life events",null,"Saving for retirement",null,"X","New","When did you last increase the amount you pay into your pension? \nCHOOSE THE FIRST ONE WHICH APPLIES TO YOU\n1. Within the last three months\n2. Within the last year\n3. Within the last two years\n4. Within the last five years\n5. Longer than five years ago\n6. I am retired so I am not paying into a pension","Yes","This is a new question. How is increasing the amount interpreted by people with different types of pensions or none. Are the response codes inclusive"]
[null,21,"Preparing for and managing life events",null,"Saving for retirement","Checking projected income","AtP IncKnow","Adapted","I'd now like you to think about how much your income in retirement will be. \n\nA) Which of these statements best describes your knowledge of how much your income in retirement will be? \nCHOOSE ONE ONLY\n1. I have a good idea of what my income in retirement will be\n2. I have a fair idea of what my income in retirement will be\n3. I know vaguely whether I will have enough to live on or not in retirement, but no more than that\n4. I have no idea of what my income in retirement will be\n\nB) Which of the following best describes your expectations of your income in retirement? \nCHOOSE ONE ONLY\n1. I know it will meet my needs\n2. I know it won't meet my needs\n3. I don't know if it will meet my needs or not","Yes","The second part of the question is new. How is it understood and how is it distinct from the previous question","No","Practitioners can use either or both, remembering to use the preamble once.\n\nUsers should be aware that clients may experience a drop on this measure following an intervention if there increased knowledge means they are less confident about their retirement income. "]
[null,22,"Preparing for and managing life events",null,"Saving for retirement","Steps to ensure adequate income","X","New","PRE\nThinking about the last [SIX] months, which of the following, if any, have you done in relation to your pension or retirement income? \nPOST\nSince [REFERENCE POINT], which of the following, if any, have you done in relation to your pension or retirement income? \nCHOOSE ALL THAT APPLY\n1. Checked whether my income will be enough will be enough to meet my needs in retirement\n2. Increased how much I am paying towards my retirement income\n3. None of these (SINGLE CODE ONLY)","Yes","Yes, this is a new question. Is it comprehensible and inclusive?","No","Practitioners can change the standard reference period of [SIX] months for pre-intervention to one relevant to their intervention (which may depend on how acute the advice need is), and should change REFERENCE POINT to reference their intervention (e.g. \"since the workshop\" \"since you last saw\")"]
[null,23,"Preparing for and managing life events",null,"Having appropriate insurance/income protection",null,"Fincap E12\n/3","Changed","Which, if any, of the following protection products do you and your partner/spouse have, even if you didn't arrange them yourself? \nCHOOSE ALL THAT APPLY\n1.  Home insurance (covering contents and/or the building)\n2. Insurance for specific items (e.g. white goods, mobile phone)\n3. Payment protection insurance (e.g. for a credit card or mortgage)\n4. Private Medical Insurance (paying or part-paying private hospital or specialist health care)\n5. . Critical illness Insurance (paying a lump sum if you become seriously ill)\n6. Income protection insurance  (providing regular payments if you cannot work due to ill health or accident)\n7. Life insurance that pays out on death\n8. Anther type of insurance\n9. Funeral plan\n10. A will \n11.[OTHER/ADDITIONAL ITEMS]\n12. None of these (SINGLE CODE ONLY)","No - Merges two fincap questions with little change to wording.",null,"No"]
[null,24,"Cross-cutting",null,"Proactively seeking advice and guidance ",null,"WAS DBurdW","Adapted","PRE\nWhich of these, if any, have you sought advice from in relation to money or your finances in the last [SIX] months?\nPOST\nWhich of these, if any, have you sought advice from in relation to money or finances since [REFERENCE POINT]?\nCODE ALL THAT APPLY\n1. A free advice agency (Citizens Advice Bureau, money advice centre, debt advice agency, law centre, consumer credit counselling service, National Debtline)\n2. A fee-charging advice company\n3. An insolvency practitioner\n4. Accountant, bank manager or other financial adviser\n5. Solicitor or lawyer\n6. A social landlord\n7. Friends or relatives\n8. The internet\n9. Some other source \n10. None of these (SINGLE CODE ONLY)","Yes","What do people count as advice. Are the response codes complete and appropriate?","See textfill (indicated in [ ] )","Practitioners can change the standard reference period of [six] months for pre-intervention to one relevant to their intervention (which may depend on how acute the advice need is), and should change REFERENCE POINT to reference their intervention (e.g. \"since the workshop\" \"since you last saw\")"]
[null,25,"Cross-cutting",null,"Proactively seeking advice and guidance online","Using the internet to manage their money better","DSK 2.1","Adapted","How often in the last [THREE MONTHS] have you gone online for the following purposes?\n\n- For information or advice on a financial product you needed or wanted\n- To find out whether a financial product was suitable for you\n- To compare financial products to find the best deal for you\n\nCHOOSE ONE FOR EACH\n1. Every day\n2. Every week\n3. Every few weeks\n4. Never \n5. Don’t know","Potentially","The response codes may need testing for sense and completeness","No","Practitioners can replace [THREE MONTHS] with a reference period which relates to their intervention. \n\nPractitioners may additionally wish to use only those items which relate to their intervention"]

{"sheet":"2. Means","index":34,"n_rows":12,"n_cols":11,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Higher level outcome","Lower level outcome","Original source","Status","Final framework question","Require testing? (Yes, No, Potentially)","Reason for testing \n(if applicable)","Adapt for pre/post?","Notes for users"]
[null,1,"Income","Employment status","Standard question","Original","Thinking about your employment, what is your current status?\n\nSELECT ONE ONLY\nIF MORE THAN ONE APPLIES, SELECT MAIN STATUS\nIF ON MATERNITY LEAVE FROM EMPLOYER AND PLANNING ON RETURNING COUNT THIS AS WORKING\n1. Working for an employer full-time (that is for 30 or more hours per week)\n2. Working for an employer part-time (that is for less than 30 hours per week)\n3. Self-employed (with or without workers)\n4. Unemployed and looking for work\n5. Unemployed and not looking for work\n6. Retired\n7. Student\n8. Permanently sick / disabled\n9. Temporarily sick \n10. Looking after home\n11. Other \n","No",null,"No","No"]
[null,2,"Income",null,"Fincap P4","Changed","A) Which of the following sources of income, if any, do you currently have? Please include any income you receive personally or jointly with your partner or spouse. \nCHOOSE ALL THAT APPLY  \n1. Income from employment/self-employment (including sick pay)\n2. Income from personal or occupational pensions\n3. Income from savings/investments\n4. Rent you receive from boarders or lodgers (not family members) or other property you rent out or sublet\n5. Child maintenance payments\n6. Other types of payments or maintenance from parents or other family members who you do not live with, including as regular gifts\n7. None of these (SINGLE CODE ONLY)\n8. Don’t know  (SINGLE CODE ONLY)\n9. Prefer not to say  (SINGLE CODE ONLY)\n\nB) And which of the following sources of income do you currently have, if any?\nCHOOSE ALL THAT APPLY  \n1. State Pension\n2. Pension Credit\n3. Child benefit\n4. Universal Credit\n5. Working Tax Credits\n6. Job Seekers Allowance (JSA) \n7. Employment and Support Allowance (ESA)\n8. Income Support \n9. Housing benefit\n10. Council Tax Reduction\n11. Disability Living Allowance (DLA), Personal Independence Payment (PIP) or Attendance Allowance (AA)\n12. Carers Allowance\n13. Something else \n14. None of these (SINGLE CODE ONLY)\n15. Don't know (SINGLE CODE ONLY)\n16. Prefer not to say (SINGLE CODE ONLY)","No - draws on standardised questions widely used elsewhere",null,"Yes","Practitioners can choose to use either or both questions, depending on need."]
[null,3,"Income",null,"Fincap P1","Adapted ","Which band from the grid below does your household’s total gross income from all sources fall into?\n[INCOME is any money from work, including a second job or occasional work, and any other sources, such as benefits, pensions, savings and investments, maintenance payments and rent from property or subletting.]\nGROSS means the amount you receive before any deductions, income tax, National Insurance etc. \nCHOOSE ONE ONLY\n Per Week Per Month Per Year\n1. Up to £86 Up to £374 Under £4,500\n2. £87 - £124 £375 - £541 £4,500 - £6,499\n3.  £125 - £143 £542 - £624 £6,500 - £7,499\n4.  £144 - £182 £625 - £791 £7,500 - £9,499\n5. £183 - £220 £792 - £957 £9,500 - £11,499\n6. £221 - £259 £958 - £1,124 £11,500 - £13,499\n7.  £260 - £297 £1,125 - £1,291 £13,500 - £15,499\n8.  £298 - £336 £1,292 - £1,457 £15,500 - £17,499\n9.  £337 - £384 £1,458 - £1,666 £17,500 - £19,999\n10.  £385 - £480 £1,667 - £2,082 £20,000 - £24,999\n11. £481 - £576 £2,083 - £2,499 £25,000 - £29,999\n12. £577 - £672 £2,500 - £2,916 £30,000 - £34,999\n13. £673 - £768 £2,917 - £3,332 £35,000 - £39,999\n14. £769 - £961 £3,333 - £4,166 £40,000 - £49,999\n15 £962 - £1,441 £4,167 - £6,249 £50,000 - £74,999\n16.  £1,442 - £1,922 £6,250 - £8,332 £75,000 - £99,999\n17. £1,923+ £8,333+ £100,000+\n18. Don’t know\n19. Prefer not to say ","No - only removes some autofill text used in the routing to the original question",null,"No","The text shown in [green text] is optional and need only be asked if questions about sources of income have not been asked.\n\nUsers can alternatively ask for a precise figure or specify by week, month or year, depending on the nature and needs of the client."]
[null,4,"Income",null,"X","NEW","POST\nBy how much has your income increased since [REFERENCE POINT]?\n1. ENTER AMOUNT IN £\n2. Stayed the same\n3. Has fallen\n4. Don't know\n5. Prefer not to say","Potentially","Need to check whether people can estimate without prompt, whether we need to specify 'annual' income and how people on weekly or monthly incomes answer (e.g. benefit recipients may think of income on a month by month basis).\n\nHigh priority as increased income may be a key outcome for interventions seeking to maximise income and this question will be more straightforward to capture and analyse than income \n\n \n\n","No, but POST only","Suitable for use post-intervention only. Practitioners should replace [REFERENCE POINT] with something appropriate to their intervention (such as 'since the workshop' or 'since you last saw us')"]
[null,5,"Income",null,"Fincap P3","Original","Which one of these best applies to you personally?\n1. Pay income tax at a basic rate\n2. Pay income tax at a higher rate\n3. Do not pay income tax\n4. Don’t know\n5. Prefer not to say","No",null,"No"]
[null,6,"Savings",null,"Fincap G5","Adapted ","A) Approximately how much, if anything, do you personally have in savings and investments? Please do not include any money that you have saved in a pension. \n1. ENTER EXACT AMOUNT\n2. I do not have any savings and investments\n3. Don’t know \n4. Prefer not to say \n\nB) Could you estimate the total within the following bands?\nCHOOSE ONE ONLY\n1. £100 or less\n2. £101 - £500\n3. £501 - £1,000\n4. £1,001 - £9,999\n5. £10,000 - £19,999\n6. £20,000 or more\n7. Don’t know\n8. Prefer not to say ","No - Changes only to formatting (separating out banded options into second question)",null,"No","B will not be necessary if client has been able to answer 1 or 2 at A\n\nUsers can alternatively go straight to the banded answers, depending on the nature and needs of the client."]
[null,7,"Savings",null,"PDL Qsav","Adapted ","Please can you tell me whether you currently have money saved in any of the following types of savings accounts and investments, including any joint accounts? CHOOSE ALL THAT APPLY\n1. A savings or deposit account with a bank or building society\n2. An account with a Credit Union\n3. Cash ISA\n4. Premium bonds\n5. Stocks and shares\n6. Other savings products\n7. Other investment product (not including pension)\n8. None of these (SINGLE CODE ONLY)\n9. Don't know (SINGLE CODE ONLY)\n10. Prefer not to say (SINGLE CODE ONLY)","Potentially","To distinguish saving from current and credit union accounts\n\nLow priority - low likely use and probably only by interventions that will be educating beneficiaries about different savings options","No"]
[null,8,"Other assets",null,"ELSA IAPROP and SEG N6","Adapted ","A) Which, if any, of these assets do you have, not including your own home? Please include any in your sole name or jointly owned with someone else\nCHOOSE ALL THAT APPLY. \n1. Houses, flats or holiday homes, including timeshares (not including this home) \n2. Farm or Business Property (such as a shop, warehouse or garage) \n3. Other land \n4. Cars, motorbikes, boats and other motor vehicles\n5. Money owed to you by others \n6. Money held in a trust \n7. Art, antiques, collectables, jewellery, and other valuables\n8. Other assets\n9. None of these (SINGLE CODE ONLY)\n10. Don't know (SINGLE CODE ONLY)\n11. Prefer not to say (SINGLE CODE ONLY)\n\nB) How much, in total, do you think they are currently worth? We only need your best estimate if you are unsure. \nCHOOSE ONE ONLY\n1. Less than £30,000 \n2. £30,000 to £39,999\n3. £40,000 to £49,999\n4. £50,000 to £74,999\n5. £75,000 to £99,999\n6. £100,000 to £149,999\n7. £150,000 to £199,999\n8. £200,000 to £249,999\n9. £250,000 to £500,000\n10. £500,000+\n11. Don't know (SINGLE CODE ONLY)\n12. Prefer not to say (SINGLE CODE ONLY)","No - a fuller response code compared with the original draws on other established questions. Also removes autofill text in original question which referred to their partner if they had one ",0,"No","This should be last question asked in relation to Other Assets"]
[null,9,"Other assets",null,"WAS Ten1\nSEG F21\nWAS Hvalue","Original","A) In which of these ways do you (and your household) occupy your home?\n1. Own it outright\n2. Buying it with the help of a mortgage or loan\n3. Pay part rent and part mortgage (shared ownership)\n4. Rent it\n5. Live here rent-free (including rent-free in relative's/friend's property; excluding\nsquatting)\n6. Squatting\n\nB) And how much in total is left to pay on your mortgage (or mortgages, if you have more than one). If you are unsure, please give your best estimate.\nCHOOSE ONE ONLY\n1. Less than £10,000\n2. £10,000 to £19,999\n3. £20,000 to £29,999\n4. £30,000 to £39,999\n5. £40,000 to £49,999\n6. £50,000 to £74,999\n7. £75,000 to £99,999\n8. £100,000\n9. to £149,999\n10. £150,000 to £199,999\n11. £200,000 to £249,999\n12. £250,000 to £299,999\n13. £300,000 to £399,999\n14. £400,000 to £499,999\n15. £500,000 or more\n16. Don't know\n17. Prefer not to say\n\nC) About how much would you expect to get (in total and not just your share) for your current home if you sold it today (before paying off any outstanding mortgage or loan on the property)?\nCHOOSE ONE ONLY\nENTER AMOUNT IN £s  If DK, then asked banded question: \n1. Less than £60,000\n2. £60,000 to £99,999\n3. £100,000 to £149.999\n4. £150,000 to £199,999\n5. £200,000 to £249,999\n6. £250,000 to £299,999\n7. £300,000 to £349,999\n8. £350,000 to £399,999\n9. £400,000 to £499,999\n10. £500,000 to £749,999\n11. £750,000 to £999,999\n12. £1 million or more ","No",0,"No","Question B should only be asked if choosing 2 or 3 at A.\n\nAt Question B, users can alternatively asked for a precise figure, depending on the nature of the client.\n\nQuestion C should only be asked if choosing 1, 2 or 3 at A\n\n"]
[null,10,"Access to affordable credit (??)",null,"HCC 8.9","Adapted ","Please can you tell me which of the following you have had in the last [3 months], whether in your own name or jointly with someone else? Please include any that you are in arrears with.\n1. Credit or store card\n2. Overdraft \n3. Payday loan\n3. Loan from company that collects payments from your home (e.g. Provident, Greenwoods)\n5. Loan from a pawnbroker\n7. Loan from a Credit Union or other community finance organisation\n8. A loan from a friend or relative.\n9. Loan from the Social Fund\n10. Loan from an unlicensed lender who charges interest, sometimes called a loan shark\n11. Any other type of loan from a bank, building society or finance company e.g. Norton Finance, Blackhorse car finance\n11) Something else\n12) Don't know\n13) Prefer not to say","No - minor changes to response codes only, based on alternative, established questions. Also removal of some optional qualifier text",0,"No, but see notes for users","Practitioners can amend the 3 months shown to a reference period which is in keeping with their intervention and following period."]

{"sheet":"3. Pressure","index":35,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Original Source","Status","Final framework question","Require testing? \n(Yes, No, Potentially)","Reasons for testing","Adapt for pre/post?","Notes to users"]
[null,1,"Committed expenditure","Debt/credit repayments",null,"SILC 419\nSEG L1","Adapted","A) Apart from any mortgages, do you currently have to repay any credit card, overdraft, hire purchase or other loans or advances? Please include any held in your own name or jointly with someone else.\n1. Yes \n2. No \n3. Don’t know\n\nB) Thinking about the loans and credit commitments held in your own name or jointly with someone else, how much in total do you currently owe on these? We only need your best estimate if you are unsure\nCHOOSE ONE ONLY\n1. Less than £500 \n2. £500 to £999 \n3. £1,000 to £2,499 \n4. £2,500 to £4,999 \n5. £5,000 to £9,999 \n6. £10,000 to £24,999 \n7. £25,000 to £49,999 \n8. £50,000 to £99,999 \n9. £100,000 to £249,999 \n10. £250,000 or more\n11. Don’t know\n12. Prefer not to say","No - (A) only minor reorganisation of the question text for clarity and removal of text which refers to others in the household. (B) Slight recasting of the question to refer to all (non mortgage) borrowing types only, drawing on other established questions",null,"No","B should only be asked if choosing 1 at A"]
[null,2,"Committed expenditure","Additional outgoings",null,"Fincap K2","Adapted","Do you (and your partner if you have one) regularly spend more than £200 a month on any of the following items? \nCHOOSE ALL THAT APPLY \n1. Travel to work\n2. Rent paid because you work away from home and cannot claim it back\n3. Child care\n4. School fees\n5. Care for someone else (including nursing home)\n6. Financial support to a partner, child or other family member who does not live with you\n7. None of these (SINGLE CODE ONLY)\n8. Don’t know (SINGLE CODE ONLY)\n9. Prefer not to say (SINGLE CODE ONLY)","No - removal only of autofill text relating to partner/spouse",null,"No"]
[null,3,"Committed expenditure","Additional outgoings",null,"Fincap K2","Changed","Do you (and your partner if you have one) regularly spend more than you can afford on any of the following items? \nPLEASE SELECT ALL THAT APPLY \n1. Travel to work\n2. Rent paid because you work away from home and cannot claim it back\n3. Child care\n4. School fees\n5. Care for someone else (including nursing home)\n6. Financial support to a partner, child or other family member who does not live with you\n7. Paying off credit or store cards \n8. Paying for goods bought on hire purchase or mail order\n8. None of these (SINGLE CODE ONLY)","No - removal only of autofill text relating to partner/spouse and slight recasting to spend 'more than you can afford' ",null,"No"]
[null,4,"Committed expenditure","Dependent children",null,"WB C12b","Adapted","How many children depend on you financially?","No - minor change of wording only, from 'economically' to 'financially'",null,"No"]

{"sheet":"5.  Connection","index":36,"n_rows":6,"n_cols":12,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Original Source","Status","Final framework question","Require testing? (Yes, No, Potentially)","Reasons for testing (if applicable)","Adapt for pre/post?","Notes for users"]
[null,1,"Ease & Accessibility ","Exposure and access to appropriate financial advice, guidance and tools and appropriate financial products and channels","People have the physical ability to access financial advice, guidance and tools which meet their needs in a form and language they can understand, and channel they can use effectively","ELSA SC5 and SEG C6","Adapted","How easy or difficult is it for you to do each of the following things?\nCHOOSE ONE ONLY FOR EACH\n-Get to a Citizens Advice Bureau or other advice agency using your normal forms of transport\n-Get to a Jobcentre Plus or local benefit office using your normal forms of transport\n-Use a telephone in private to discuss financial matters\n-Receive confidential financial information by post\n\n1.Very easy\n2.Quite easy\n3.Quite difficult\n4.Very difficult\n5.Unable to go\n6.Do not wish to go","Potentially","The 3rd and 4th response codes are new","No","Practitioners can optionally insert additional locations relevant to their intervention at the bottom of the list. Locations need to be relevant, clearly stated and as succinct as possible."]
[null,2,"Ease & Accessibility ","Exposure and access to appropriate financial advice, guidance and tools and appropriate financial products and channels","People have the physical ability to access appropriate financial products which meet their needs via appropriate channels","ELSA SC5 and SEG C6","Adapted","How easy or difficult is it for you to do each of the folllowing things?\nCHOOSE ONE ONLY FOR EACH\n- Get to a Post Office using your normal forms of transport\n- Get to a Cash point using your normal forms of transport\n- Get to a Bank, building society or credit union using your normal forms of transport\n- Receive confidential financial documents by post, such as a payment card or chequebook\n\n1.Very easy\n2.Quite easy\n3.Quite difficult\n4.Very difficult\n5.Unable to go\n6.Do not wish to go","Potentially","The 4th response code is new","No","Practitioners can optionally insert additional locations relevant to their intervention at the bottom of the list. Locations need to be relevant, clearly stated and as succinct as possible.\n\nCould also apply to \"Physical ability to access advice\""]
[null,3,"Ease & Accessibility ","Exposure and access to appropriate financial advice, guidance and tools and appropriate financial products and channels","People have the physical ability to access appropriate financial products which meet their needs via appropriate channels ","FRS Showcard N1","Adapted","Which of the following types of everyday accounts do you have, if any, either in your own name or jointly with someone else? These might be held with a bank, building society or other provider such as a credit union or post office. \nCHOOSE ALL THAT APPLY\n1. Current account (usually offered with an overdraft facility, even if you don't want one)\n2. Basic Bank Account (normally without an overdraft facility)\n3. Post Office Card Account (for receiving your pension, benefits or tax credits) \n4. A saving deposit account (e.g. an instant access or notice account, including cash ISA)\n5. None of these","No - shortens the original list of response codes, based on alternative questions",null,"No"]
[null,4,"Ease & Accessibility ","Exposure and access to appropriate financial advice, guidance and tools and appropriate financial products and channels","People have the technical ability to access financial advice, guidance and tools which meet their needs in a form and language they can understand, and channel they can use effectively and to access appropriate financial products which meet their needs via appropriate channels","X","New","In which of the following ways, if any, can or do you use the internet when you need to access information about money or your finances?\nCHOOSE ALL THAT APPLY\n1. At home, using a computer or laptop\n2. At home, using a mobile phone, tablet or internet-enabled TV\n3. At work, college or at a friend or relative's home\n4. In a library, community centre or other public setting\n5. Somewhere else\n6. Do not use the internet","Yes","New question. Are the response codes inclusive and meaningful? Does 'internet' need to be explained? What do people think of in response to \"access information about money or your finances\"","No","Practitioners can optionally insert additional locations relevant to their intervention before 'Somewhere else'. Locations need to be relevant, clearly stated and as succinct as possible."]

{"sheet":"6. Mindset","index":37,"n_rows":30,"n_cols":13,"rows_kept":30,"cut":false,"hidden":true,"merged":[[2,1,2,12],[20,1,20,12]]}
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Additional subindicator","Original source","Status","Final framework question","Require testing? (Yes, No, Potentially)","Reasons for testing (if applicable)","Adapt for pre/post?","Notes for users"]
[null,"Financial attitudes and motivations"]
[null,1,"Financial attitudes and motivations","Attitudes to receiving money advice and guidance",null,null,"x","New","How likely is that you would seek advice from an external advice organisation to deal with money worries?\nCHOOSE ONE ONLY\n1.Very likely\n2. Fairly likely\n3. Fairly unlikely\n4. Very unlikely\n5. Don’t know\n","Yes","New question","No"]
[null,{"$f":"+B4+1","v":2}," Financial attitudes and motivations","Attitudes to receiving money advice and guidance",null,null,"x","New","How much do you agree or disagree with each of the following statements?  \n\n - Seeking financial advice seems too daunting \n - I think I would make better financial decisions with the help of advice\n -  I would feel too embarrassed to seek professional advice about money problems \n - When it comes to financial advice I don't know where to start. \n -  I can sort out my own money issues, without seeking advice \n - When it comes to choosing financial products, I find there is not enough information out there that I can trust \n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","Yes","Entirely new question","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,{"$f":"+B5+1","v":3}," Financial attitudes and motivations","Attitudes to money","People are motivated to keep track of their finances\n\n",null,"Fincap (O3C)","Original","How important, if at all, do you think it is to keep track of your household’s income and expenditure \n\n1. Very important\n2. Fairly important\n3. Neither important nor unimportant\n4. Fairly unimportant\n5. Very unimportant\n6. Don’t know\n","No",null,"No"]
[null,5," Financial attitudes and motivations","Attitudes to money","Attitudes to managing money","Social influences","Fincap (Q4c/d)","Changed"," A) I feel under pressure to spend money on my children even when I can't afford it 0 (does not sound like me at all) to 10 (sounds a lot like me)\n\nB) I feel under pressure to have a lifestyle which I can't really afford.0 (does not sound like me at all) to 10 (sounds a lot like me)\n\n0 does not sound like me\n...\n10 sounds a lot like me\nDon't know\nNot applicable","Yes","B) is new/adapted","No"]
[null,6," Financial attitudes and motivations","Attitudes to money","Attitudes to managing money",null,"Fincap (O2D)","Original","To what extent do you agree or disagree with the\nstatement \n\n“I am too busy to sort out my finances at the moment\"\n \"Nothing I do will make much difference to my financial situation\"\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","No",null,"No"]
[null,7," Financial attitudes and motivations","Attitudes to money","People value making their money go further (eg. by shopping around and switching)\n\n",null,"x","New (except * which is from SEG Q3)","Q3\nAnd how much do you agree or disagree with each of the following statements?:\n- I prefer to stick with one company over time rather than keep changing suppliers*\n - There's no point in switching providers, it's not worth the hassle \n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","Yes","Most of these statements are new (except *)","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,8," Financial attitudes and motivations","Attitudes to money","People value saving for expected and unexpected events\n\n",null,"OECD (f10)/SEG (c44)/ SEG (d35)/BASE (qpla4)","Original except * which is adapted","How much do you agree or disagree with each of the following statements?  \n\n - I find it more satisfying to spend money than to save it for the long term \n- I always make sure I have some money saved to pay for emergencies or unexpected expenses*\n - If I had to choose, I would rather have a good standard of living today than save for the future.\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","Yes","* question requires testing as new.","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,9," Financial attitudes and motivations","Attitudes to money","People have a cautious attitude to debt and credit \n\n",null,"SEG (c44)/PDL (Q95)/IDL/Fincap (O2F)/BSA 2001 (credspnd)","Original except *","I am now going to read you some things that other people have said about managing money. Please tell me how strongly you agree or disagree with them.\n\n\n - Spending to the maximum on all my credit cards is a way of life for me\n - I hate to borrow – I would much rather save up in advance\n - Sometimes I ignore letters and phone calls in case they are to tell me that I owe money\n  - Being in debt does not worry me\n - I would prefer to have luxuries and treats than be debt free \n- I would rather cut back than run up debts on a credit card\n - It's okay to constantly use an overdraft *\n- I prefer to buy things on credit rather than wait and save up\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","Yes","* question requires testing as new.","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top\n\nSelect responses that are relevant to the intervention"]
[null,10," Financial attitudes and motivations","Attitudes to money","People talk openly and honestly about money with friends and family\n",null,"IDL/SEG Q3","Original","How much do you agree or disagree with each of the following statements?  \n\n - I would be too embarrassed to discuss my financial situation\n \n- I would talk to family and friends before making an important financial decision\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","No",null,"No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,11," Financial attitudes and motivations","Attitudes to money","People talk openly and honestly about money with friends and family\n\n",null,"Fincap (M1)","Original","Do you discuss your household finances openly with any of the following people?\nSELECT ALL THAT APPLY \n1. Friends\n2. My partner/spouse\n3. Parents/Family\n4. My children\n5. My colleagues\n6. Members of my local community\n7. Other, please specify\n8. I prefer not to talk about my finances with any of these people (SINGLE CODE ONLY)\n9. Don’t know (SINGLE CODE ONLY)\n","No",null,"No"]
[null,{"$f":"+B13+1","v":12}," Financial attitudes and motivations","Attitudes to the future","People have concrete short to medium term financial goals and/or longer term aspirations\n",null,"Fincap (D2)","Adapted","A) Which, if any, of these financial goals do you have for the next five years?\nPLEASE SELECT ALL THAT APPLY \n1. Just making ends meet day to day\n2. Paying off my debts/reducing debts\n3. To buy, rent or move house\n4. Saving money for a wedding\n5. Saving money to start a family/have another child\n6. Saving money for education (for me or my children)\n7. Saving money to help grown-up children to buy/rent  a home\n8. Saving money for a holiday\n9. Saving money for retirement\n10. Saving money for home improvements\n11. Saving money to purchase a car/van/motorbike\n12. Saving money generally\n13. Other (please specify)\n14. None of these (SINGLE CODE ONLY)\n\nFOR EACH CODED ABOVE\nB) How much of a plan do you have about how you will achieve your financial goal for <ANSWER FROM ABOVE>. \nPlease answer on a scale of 0 to 10, where 0 means you don’t have a plan of what you need to do and 10 means you have a very specific plan of what you need to do.\n0 I don’t have a plan of what I need to do, I just know I want to do it\n...\n10 I have a very specific plan of what I need to do\nDon’t know","Yes","Sufficiently changed that requires re-testing","No","For B) use a visual 0 to 10 scale with the statements indicated attached the extremes."]
[null,13," Financial attitudes and motivations","Attitudes to the future","People have concrete short to medium term financial goals and/or longer term aspirations\n","People are confident that they will achieve retirement income goals\n","BASE QCstali ","Adapted","Taking all this into account, how confident are you that your household income in retirement will (continue to) give you the standard of living you hope for? \nCHOOSE ONE ONLY\n1. Very confident\n2. Fairly confident\n3. Not very confident\n4. Not at all confident\n5. Don’t know","Yes","Does this work for people in retirement? (previous version was for pre-retirement only)","No"]
[null,14," Financial attitudes and motivations","Attitudes to the future","People anticipate and plan for less positive scenarios (eg. planning for care costs) \n\n","Engagement with the provision of  care needs","NI Life & Times survey 2010 (careplan/Q15)","Adapted","Have you thought about or made any plans about how you might fund any care and support needs as you get older?\nCODES 4,5,6,7 CAN BE MULTI-CODED\n1 I've thought about it but haven t done anything specific \n2 I haven t really thought about it\n3 I don’t think there is anything I can do to plan\nfor this now/I can’t afford to make any such plans\n4 I am saving money which I could use for these kinds of needs(eg insurance, savings, pension, investment, care plan etc)\n5 I am buying/have bought a property and would be willing to use  its value to pay for care needs in the\nfuture\n6 I expect my family to help fund any such care\n7 Other (please specify)\n8 Don't know\n","Yes","Some adaptations against original plus need to check for up-to-dateness.","No"]
[null,15," Financial attitudes and motivations","Attitudes to the future","People anticipate and plan for less positive scenarios (eg. planning for care costs) \n\n","Engagement with the risk of changes to tax/benefits","NI Life & Times survey 2010 (careplan/Q15)","Changed","Have you thought about or made any plans about how you might cope financially with an unexpected fall in household income due to changes to tax or benefits?\nCODES 4,5,6 CAN BE MULTI-CODED\n1 I've thought about it but haven't done anything specific \n2 I haven t really thought about it\n3 I don’t think there is anything I can do to plan\nfor this now/I can’t afford to make any such plans\n4 I am saving money which I could use for these kinds of eventuality (eg savings, investment,  etc)\n5 I would expect my family to help me out financially\n6 Other (please specify)\n7 Don't know\n","Yes","Some adaptations against original plus need to check for up-to-dateness.","No"]
[null,{"$f":"+B17+1","v":16}," Financial attitudes and motivations","Attitudes to the future","People anticipate and plan for less positive scenarios (eg. planning for care costs) \n\n","Engagement with the risk of a drop in income","NI Life & Times survey 2010 (careplan/Q15)","Changed","Have you thought about or made any plans about how you might cope financially with an unexpected fall in household income for example due to redundancy or ill-health?\nCODES 4,5,6 CAN BE MULTI-CODED\n1 I've thought about it but haven't done anything specific \n2 I haven t really thought about it\n3 I don’t think there is anything I can do to plan\nfor this now/I can’t afford to make any such plans\n4 I am saving money which I could use for these kinds of needs(eg savings, investment,  etc)\n5 I have an income-protection insurance policy to cover these tyopes of eventuality\n6 I would expect my family to help me out financially\n7 Other (please specify)\n8 Don't know\n","Yes","Some adaptations against original plus need to check for up-to-dateness.","No"]
[null,17," Financial attitudes and motivations","Attitudes to the future","People anticipate and plan for less positive scenarios (eg. planning for care costs) \n\n","Engagement with the risk of an interest rate rise affecting mortgage payments","NI Life & Times survey 2010 (careplan/Q15)","Changed","Have you thought about or made any plans about how you might cope financially with extra mortgage costs associated with an interest rate rise?\nCODES 4,5,6,7 CAN BE MULTI-CODED\n1 I've thought about it but haven t done anything specific \n2 I haven t really thought about it\n3 I don’t think there is anything I can do to plan\nfor this now/I can’t afford to make any such plans\n4 I am saving money which I could use for these kinds of needs(eg insurance, savings, investment,  etc)\n5 I am considering switching to a different mortgage product \n6 I would expect my family to help me out financially\n7 Other (please specify)\n8 Don't know\n","Yes","Some adaptations against original plus need to check for up-to-dateness.","No","For those with a mortgage only"]
[null,18," Financial attitudes and motivations","Attitudes to financial institutions","People trust financial institutions (such as banks and credit unions) to provide them with appropriate products, services and advice\n\n\n",null,"x","New"," How much do you agree or disagree with each of the following statements?  \n\n - There is no point taking out insurance as they rarely pay out when something goes wrong \n - I  trust pension providers to act in my best interests \n - I trust pension providers to make the most of money that people pay in\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","Yes","All are new and untested (apart from the first one)","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[]
[null,19,"General attitudes and motivations (applied to money)","Self-confidence","People have confidence in their approach to budgetting \n\n",null,"Fincap (I8)","Original","Thinking overall about your (and your partner/spouse’s) approach to keeping track of income and expenditure, how well do you think this approach works?\n\nPlease answer on a scale of 0 to 10, where 0 means not at all well and 10 means very well\n\n0…10 scale\nDon't know","No",null,"No","Use a visual 0 to 10 scale with the statements indicated attached the extremes."]
[null,20,"General attitudes and motivations (applied to money)","Self-confidence","People feel in control of their financial situation\n",null,"Fincap (O2C)","Original except *","How much do you agree or disagree with each of the following statements?  \n \n- I am very organised when it comes to managing my money day to day\n - I feel in control of my finances*\n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n \n","No","For * terms widely used and understood","No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,21,"General attitudes and motivations (applied to money)","Self-confidence","People have the confidence to question or challenge financial advice they are given \n\n",null,"SEG (B1)","Original","How much do you agree or disagree with the following statement?  \n \n- When dealing with companies or making purchases, I would consider myself to be a confident and savvy customer\n \n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know\n","Yes","Second statement is new and requires testing to check understanding of term \"creditors\". ","No"]
[null,{"$f":"+B24+1","v":22},"General attitudes and motivations (applied to money)","Self-confidence","People have the confidence to question or challenge financial advice they are given\n",null,"x","New","How confident would you feel  talking to people who can give you advice about money\n\n1.Very confident \n2. Fairly confident \n3. Not very confident \n4. Not at all confident\n5. Don't know\n","Yes","New questions","No"]
[null,23,"General attitudes and motivations (applied to money)","Self-confidence","People have the confidence to question or challenge their creditors\n",null,"x","New","A) - If you owed money, how confident would you feel negotiating with creditors or organisations you owe money to\n\n\n1.Very confident \n2. Fairly confident \n3. Not very confident \n4. Not at all confident\n5. Don't know\n","Yes","New questions","No"]
[null,24,"General attitudes and motivations (applied to money)","Self-confidence","People have the confidence to choose appropriate products/services",null,"Fincap (B4)","Original","How confident do you feel making decisions about financial products and services?  \n\nPlease answer on a scale of 0 to 10, where 0 is ‘not at all confident and 10 is ‘very confident\n 0…10 scale\nDon't know\n","No",null,"No","Use a visual 0 to 10 scale with the statements indicated attached the extremes."]
[null,25,"General attitudes and motivations (applied to money)","Self-confidence","People have the confidence to choose an appropriate pension product",null,"AtP (QA19,21,31)","Original","How much do you agree or disagree with each of the following statements?  \n \n - I know enough about pensions to decide with confidence  how to save for my retirement \n - Sometimes pensions seem so complicated that I cannot really understand the best thing to do \n - Dealing with pensions scares me \n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","No",null,"No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,26,"General attitudes and motivations (applied to money)","Self-control","People are able to abstain from/delay spending in order to live within their means and save for the future\n\n",null,"SEG (c44)/OECD (F10)","Original though first one is adapted","How much do you agree or disagree with each of the following statements?  \n \n- I tend to buy things even when I can’t really afford them\n - I tend to live for today and let tomorrow take care of itself  \n - I find it more satisfying to spend money than to save it for the long term \n\n1. Strongly agree\n2. Tend to agree\n3. Neither agree nor disagree\n4. Tend to disagree\n5. Strongly disagree\n6. Don’t know","No - First statement represents minor adpatation only",null,"No","If administering on paper/web can set this up s a grid with Agree/Disagree scale along the top"]
[null,27,"General attitudes and motivations (applied to money)","Adaptability",null,null,"Fincap (O4B)","Original"," I am prepared to adjust the amount of money I spend on non-essentials if my life changes: 0 (does not sound like me at all) to 10 (sounds a lot like me)\n\n0…10 scale\nDon't know","No",null,"No","Use a visual 0 to 10 scale with the statements indicated attached the extremes."]

{"sheet":"7. Ability","index":38,"n_rows":41,"n_cols":12,"rows_kept":41,"cut":false,"hidden":true,"merged":[[7,1,7,11],[31,1,31,11],[4,3,4,5],[2,3,2,5],[1,3,1,5],[3,3,3,5],[1,6,1,7],[2,6,2,7],[3,6,3,7],[4,6,4,7]]}
[null,null,"In this section we use some stem questions which are used throughout the Ability framework.  The main questions are indicated here and referenced in the matrix."]
[null,null,"STEM Question","Wording",null,null,"User notes"]
[null,null,"STEM Question A","[FLEXIBLE QUESTION = CHOOSE/ADD OPTIONS AS APPLICABLE]\nWhich of these statements best describes how knowledgeable you feel about...\n\n - Bank accounts\n - Credit cards\n - Mortgages\n - Savings accounts \n - Credit Unions\n - Investments\n - Pensions\n - Insurance\n - The different types of financial fraud\n - the different types of loans and credit' \n[OTHERS]\n\nI have a good knowledge\nI have a reasonable knowledge\nI have a basic knowledge but do not understand the details\nMy knowledge is very limited \nI know nothing about this\n",null,null,"This question is flexible and items can be added according to relevance to intervention.  Can be set up as a grid if used in a web/self -completion setting with products down the side, responses along the top.  Note that although we have \"don't know\" as standard on most questions, in this case it would be confusing to include this given the nature of the question.  "]
[null,null,"STEM Question B","[FLEXIBLE QUESTION = CHOOSE/ADD OPTIONS AS APPLICABLE]\nWhich of these statements best describes your ability in ...\n - Using a price comparison website\n - Checking the balance on your bank account\n - Creating a weekly or monthly household budget\n - Comparing different insurance products to check you are getting the best deal\n - Comparing different savings products to check you are getting the account which is best for you\n   - Comparing different loans and credit products to check you are getting the best product for you\n - Checking you are getting all benefits you are entitled to\n - Checking how much pension income you will get when you retire\n - Planning a pension that will provide you with the income in retirement that you require \n-  Checking that you are paying the correct amount of tax\n - Protecting yourself from online financial fraud\n - Accessing advice if you need help with my finances\n - Taking out a mortgage\n - Working out how to calculate your monthly mortgage payments in the event of an interest rate rise\n - Working out the total cost of a loan or credit purchase such as Brighthouse  (by \"total cost\" we mean the amount you have to pay in total including interest and charge)\n - Working out which household bills should take priority over others\n[OTHERS]\n1. I  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know\n[Not applicable]",null,null,"This question is flexible and items can be added according to relevance to intervention.  Can be set up as a grid if used in a web/self -completion setting with behaviours down the side, responses along the top.  If relevance of items will vary by client then add a \"not applicable\" to the response list.\n\n"]
[null,null,"Quiz-style questions","Questions that fit into this format have been labelled with a \"QUIZ\" indicator.",null,null,"Quiz-style questions can be a better way of measuring knowledge as they are objective.  Questions which rely on self-reported knowledge are more subjective and can sometimes be a measure of confidence as opposed to knowledge.  If using quiz-style questions it is advisable to open these with a soft introduction eg \"I would like to ask you some questions more in the style of a quiz.  It doesn't matter whether the answer you give is right or wrong.  We just want to find out what people understand so we can make sure we are giving the right advice.\""]
[]
[null,null,"Higher level outcome","Lower level outcome","Indicator","Original source","Final framework question","Can the question be asked via all modes (e.g. self-completion, face to face, phone)?","Require testing? (Yes, No, Potentially)","Reasons for testing (if applicable)","Adapt for pre/post?","Notes for users"]
[null,"Financial knowledge and understanding"]
[null,{"$f":"SUBTOTAL(3, F$6:F7)","v":1},"Financial knowledge and understanding","Understanding financial concepts, products and situations","People are able to answer basic questions around different financial products e.g. bank accounts, loan types and investments.\n\n","x","See STEM A Which of these statements best describes how knowledgeable you feel about…[LIST OF PRODUCTS]\n\nI have a good knowledge\nI have a reasonable knowledge\nI have a basic knowledge but do not understand the details\nMy knowledge is very limited \nI know nothing about this\n","Yes","Yes","STEM A is a new question ","No","This question can be used in its entirety or to select relevant items. See STEM A notes"]
[null,{"$f":"+B9+1","v":2},"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around interest rates, loan types, investment, inflation etc.\n\n","x","See STEM B Which of these statements best describes your ability in … [LIST OF FINANCIAL BEHAVIOURS]\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","This question can be used in its entirety or to select relevant items. See STEM B notes"]
[null,{"$f":"+B10+1","v":3},"Financial knowledge and understanding","Understanding financial concepts, products and situations","People are able to answer basic questions about interest rates and savings  \n","Fincap (N3)","QUIZ Suppose you put £100 into a savings account with a guaranteed interest rate of 2% per year. You don’t make any further payments into this account and you don’t withdraw any money.\n\nHow much would be in the account at the end of the first year, once the interest payment is made?\n1: A. £120\n2: B. £140\n3: C. £104\n4: D. £102","Yes  - though best suited to visual presentation, more difficult to administer on the phone","Yes","Question has been adapted and put into a multi-choice format rather than open format as this is likely to be simpler to use in a provider setting","No","Correct answer D."]
[null,4,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People are able to answer basic questions about the interest rates and loans \n\n\n\n","PDL (Q97a)","QUIZ You have taken out a loan for £500, and the interest rate you are charged is 10 percent per month. There are no other fees. At this interest rate, how much money would you owe in total after one month?\n\nA £505\nB £550\nC £510\nD £600\n","Yes  - though best suited to visual presentation, more difficult to administer on the phone","Yes","Question has been adapted and put into a multi-choice format rather than open format as this is likely to be simpler to use in a provider setting","No","Correct answer B."]
[null,5,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People are able to answer basic questions about the interest rates and loans \n\n","x","See STEM B Which of these statements best describes your ability in … \n\n - Working out how to calculate your monthly mortgage payments in the event of an interest rate rise\n - Working out the total cost of a loan or credit purchase such as Brighthouse  (by \"total cost\" we mean the amount you have to pay in total including interest and charges)\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,6,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around interest rates and inflation \n","Fincap (N2)","QUIZ If the inflation rate is 5% and the interest rate you get on your savings is 3%, will your savings have more, less or the same amount of buying power in a year’s time?\n1. More\n2. The same\n3. Less\n4. Don’t know","Yes","Yes","Need to re-ensure that the concept of \"buying power\" is fully understood. Possible alternative wording: \"After one year, would the money in the account buy more than it does today, exactly the same or less than today?\"","No","Correct answer \"Less\"."]
[null,7,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around inflation\n","OECD (QK7)","QUIZI would like to know whether you think the following statements are true or false.....\n\n - An investment with a high return is likely to be low risk*\n - High inflation means that the cost of living is increasing rapidly  \n - It is usually possible to reduce the risk of investing in the stock market by buying a wide range of stocks and shares \n - It will cost you more to borrow on money on a loan with a low APR than a loan with a high APR* \n\nTrue\nFalse\nDon't know","Yes","Yes","Some new and changed questions here (see  *)","No","Correct answers: False, True, True, False."]
[null,8,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around investment\n\n","OECD (QK7)","QUIZ I would like to know whether you think the following statements are true or false.....\n\n - An investment with a high return is likely to be low risk* \n - High inflation means that the cost of living is increasing rapidly \n - It is usually possible to reduce the risk of investing in the stock market by buying a wide range of stocks and shares. \n - It will cost you more to borrow on money on a loan with a low APR than a loan with a high APR*\n\nTrue\nFalse\nDon't know","Yes","Yes","Some new and changed questions here (see  *)","No","Correct answers: False, True, True, False."]
[null,9,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around loan types\n","OECD (QK7)","QUIZ I would like to know whether you think the following statements are true or false.....\n\n - An investment with a high return is likely to be low risk *\n - High inflation means that the cost of living is increasing rapidly \n - It is usually possible to reduce the risk of investing in the stock market by buying a wide range of stocks and shares. \n - For a six month loan, it will cost you more to borrow money on a loan with a low APR than a loan with a high APR*\n\nTrue\nFalse\nDon't know","Yes","Yes","Some new and changed questions here (see  *)","No","Correct answers: False, True, True, False."]
[null,10,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around loan types\n","x","See STEM A Which of these statements best describes how knowledgeable you feel about…\n\n  - the different types of loans and credit\n\nI have a good knowledge\nI have a reasonable knowledge\nI have a basic knowledge but do not understand the details\nMy knowledge is very limited \nI know nothing about this\n",null,"Yes","STEM A is a new question "]
[null,11,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand basic financial concepts and are able to answer basic questions around loan types\n","x","See STEM B Which of these statements best describes your ability in … \n - Comparing different loans and credit products to check you are getting the best product for you\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,12,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People are able to check their bank balance","x","See STEM B Which of these statements best describes your ability in … \n  - Checking the balance on your bank account\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,13,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand different insurance products and can assess which options are right for them\n","x","See STEM B Which of these statements best describes your ability in … \n -  Comparing different insurance products to check you are getting the one that is best for you\n\n I.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,14,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand different types of savings vehicles, and can assess which options are right for them\n","x","See STEM B Which of these statements best describes your ability in … \n  - Comparing different savings products to check you are getting the account which is best for you\n\n I.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,15,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand concepts, products and options relevant to their issue, life stage or event eg, pensions\n\n","x","See STEM B\n- Checking how much pension income you will get when you retire\n -Making decisions about a pension that will provide you with the income in retirement that you require \n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,16,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand concepts, products and options relevant to their issue, life stage or event eg. Mortgages","x","See STEM B Which of these statements best describes your ability in … \n - Applying for a mortgage\n  - [IF RELEVANT] Calculating your monthly mortgage payments in the event of an interest rate rise\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,17,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand concepts, products and options relevant to their issue, life stage or event eg. problem debt","DAE (Q25)","How well do you understand each of the following:\na) the steps you need to take to sort out  debts or arrears?. \nb) the different options available for sorting out debt problems \nc) the fees that are charged for debt solutions such as bankruptcy, Debt Relief Orders, and Debt Management Plans \nd)  the steps I should take if I am not able to pay creditors \ne) my rights if creditors try to recover  money owed to them \nf) the steps that creditors can take to recover money owed to them \n\n1. A great deal\n2. A fair amount\n3. Only a little\n4. Not at all\n5. Don't know\n\n\n","Yes","Yes","Question has been adapted to suit a different format.","No"]
[null,18,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People know where to go for advice, guidance and tools about their financial situation, in person, by phone and using digital resources","Fincap (F2)","Which, if any, of these providers of advice on your money you have ever heard of, even if you’re not very familiar with them?\n\nSELECT ALL THAT APPLY\n\n1. Money Advice Service\n2.Citizen’s Advice Bureau\n3.Money Sense\n4.Which?\n5.Money Saving Expert (Martin Lewis)\n6.Other price comparison sites (e.g. Moneysupermarket, Comparethemarket)\n7.Directgov (gov.co.uk)\n8.Alvin Hall\n9. Consumer Credit Counselling Service (CCCS)/StepChange\n10. National Debtline\n[ADD OTHER RELEVANT ORGANISATIONS/SITES]\n11. None of these\n","Yes\n","Potentially","Might be worth checking that list is comprehensive (though may differ depending on local area)","No","NB - This question only captures awareness of providers and by prompting users there is a risk that reported awareness will not be a reliable indicator of where they would look for information unprompted. Users should consider an open-ended question to capture unprompted awareness \n\nFlexible question: can adapt list as relevant."]
[null,19,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People know where to go for advice, guidance and tools about their financial situation, in person, by phone and using digital resources","x","See STEM B Which of these statements best describes your ability in … \n - Accessing advice if you need help with your finances\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,20,"Financial knowledge and understanding","Understanding financial concepts, products and situations","People understand the main types of financial fraud and how to protect themselves from it","x","See STEM A Which of these statements best describes how knowledgeable you feel about...\n - The different types of financial fraud\n\nI have a good knowledge\nI have a reasonable knowledge\nI have a basic knowledge but do not understand the details\nMy knowledge is very limited \nI know nothing about this\n\nSee STEM B Which of these statements best describes your ability in … \n - Protecting yourself from online financial fraud\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know\n\n\n","Yes","Yes","STEM A/ STEM B are new question ","No","See STEM A/STEM B notes"]
[null,21,"Financial knowledge and understanding","Understanding own financial situation","People understand the steps they should take to deal with problem debts and their rights","DAE (Q25)"," How well do you understand each of the following:\na) the steps you need to take to sort out  debts or arrears?. \nb) the different options available for sorting out debt problems \nc) the fees that are charged for debt solutions such as bankruptcy, Debt Relief Orders, and Debt Management Plans \nd)  the steps I should take if I am not able to pay my creditors \ne) my rights when creditors try to recover the money owed to them \nf) the steps that creditors can take to recover money owed to them \n\nA great deal\nA fair amount\nOnly a little\nNot at all","Yes","Yes","Question has been adapted to suit a different format.","No"]
[null,22,"Financial knowledge and understanding","Understanding money management","People understand the principles of budgeting and can develop a budget suited to their needs","x","See STEM B Which of these statements best describes your ability in … \n -   creating a weekly or monthly household budget\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,23,"Financial knowledge and understanding","Understanding money management","People know how to make their money go further","x","See STEM B Which of these statements best describes your ability in … \n - using a price comparison website \n -  comparing different insurance products accounts to check you are getting the best deal\n -  comparing different savings products to check you are getting the account which is best for you\n -  checking you are getting all benefits you are entitled to;\n -  checking that you are paying the correct amount of tax\n\nI.  have a clear idea about how to do this\n2. I have some idea about how to do this\n3. My knowledge is limited - I know a little bit about this but no more\n3. I  have no idea about how to do this\nDon’t know\n","Yes","Yes","STEM B is a new question ","No","See STEM B notes"]
[null,"Basic skills"]
[null,{"$f":"+B31+1","v":24},"Basic skills","Applied numeracy","People can successfully apply mathematical skills to financial problems","CDS (Q28)","QUIZ The same TV is on sale in both shop A and B. In Shop A it is priced at £400.  In Shop B it is on sale for £500 with 10% discount.  Which one is cheaper? \n\n1:  The one sold in shop A \n2: The one sold in shop B \n3: They are both the same price \n4. Don't know","Yes ","Yes","Has been adapted to suit a unimodal context and therefore would be helpful to check it still works ok.","No","Correct answer: Shop A"]
[null,{"$f":"+B33+1","v":25},"Basic skills","Applied numeracy","People can successfully apply mathematical skills to financial problems","SKILL (Bqmath)","And how good are you at each of the following:\n\na) working with numbers when you need to in everyday life? For example working out your wages or benefits, or checking bills and statements?\n b)  writing in English when you need to in daily life? For example: writing letters or notes or filling in official forms?\nc) reading in English when you need to? For example\nreading newspapers and magazines or reading letters, paperwork or forms?\n\n1. Very good \n2. Fairly good \n3. Below average \n4. Poor \n5. No opinion. \n6, Don't Know  ","Yes","No",null,"No"]
[null,{"$f":"+B34+1","v":26},"Basic skills","Literacy","People have the level of literacy needed to fill in forms and write formal letters in English (or Welsh in Wales)","SKILL (bqwrite)","And how good are you at each of the following:\n\na) working with numbers when you need to in everyday life? For example working out your wages or benefits, or checking bills and statements?\n b)  writing in English when you need to in daily life? For example: writing letters or notes or filling in official forms?\nc) reading in English when you need to? For example\nreading newspapers and magazines or reading letters, paperwork or forms?\n\n1. Very good \n2. Fairly good \n3. Below average \n4. Poor \n5. No opinion. \n6, Don't Know  ","If someone has literacy problems, then this question may be problematic in a self-completion setting","No",null,"No"]
[null,27,"Basic skills","Literacy","People have the level of literacy needed to read and understand information about financial products and services in English (or Welsh in Wales)","SKILL (bqread)","And how good are you at each of the following:\n\na) working with numbers when you need to in everyday life? For example working out your wages or benefits, or checking bills and statements?\n b)  writing in English when you need to in daily life? For example: writing letters or notes or filling in official forms?\nc) reading in English when you need to? For example reading newspapers and magazines or reading letters, paperwork or forms?\n\n1. Very good \n2. Fairly good \n3. Below average \n4. Poor \n5. No opinion. \n6, Don't Know  ","If someone has literacy problems, then this question may be problematic in a self-completion setting","No - Changes to question structure only rather than wording",null,"No"]
[null,28,"Basic skills","Digital literacy","People are able to use financial/money-related online services eg. forms, tools, emails, and online banking\n","DSK (2.3)","A) Do you access to the internet at home or elsewhere?\nYes\nNo\nDon't know\n\nIF DO HAVE ACCESS\nB) I’d like you to think about different commercial transactions people do in their everyday lives like banking or shopping. How easy do you find it to use the internet for the following purposes? \na) Buying a product online\nb) Making travel reservations/bookings\nc) Paying bills\nd) Using your bank’s online services\ne) Comparing products and services\nf) Ordering groceries or food online\ng) Selling things online\nh) Finding the location of a house,  office, store or restaurant \n\n1. Several times a day\n2. Daily\n3. Weekly\n4. Monthly\n5. Less than monthly\n6. Never\n7. Don't know\n","Yes","No",null,"No"]
[null,29,"Basic skills","Digital literacy","People are able to navigate online content and locate the information they need\n\n","DSK (1.1.3a)","How would you rate your ability to use the\nInternet?\n1. Excellent\n2. Good\n3. Fair\n4. Poor\n5. Bad\n6. Don’t know","Yes","No",null,"No"]
[null,30,"Basic skills","Digital literacy","People are able to navigate online content and locate the information they need\n\n","SEG (P5)","To what extent do you agree or disagree with the following statements?\n\n- When I need information the first place I look is the internet\n - I find it easy to find what I am looking for online\n - I would rather look at information in a paper leaflet than on a company’s website\n\nStrongly Agree\nTend to Agree\nTend to disagree\nStrongly  disagree\nDon’t know\nDoes not apply to me\n ","Yes","No",null,"No"]
[null,31,"Basic skills","Communication","People are able to confidently interact with others in English (or Welsh in Wales)\n\n","x","Can I check, is English your first language?  Yes/No\n\n[IF NO]  So can I check would you have any difficulty speaking in English to a member of staff in a bank about choosing a financial product?\n1. Yes\n2. No\n\n\n","Yes","Potentially","Though might be difficult finding people who lack English skills to icnlude within a cog test","No","Can also extend this to include reading and writing in English if not using the basic skills questions above."]
[null,32,"Basic skills","Communication","People are able to confidently interact with others in English (or Welsh in Wales)\n\n","x","Can I check, is English or Welsh your first language?  \nYes - English\nYes - Welsh\nNo, neither\n\n[IF NEITHER]  So can I check would you have any difficulty speaking in English or Welsh to a member of staff in a bank about choosing a financial product?\n1. Yes\n2. No\n","Yes","No - Standard phrasing",null,"No","Welsh language version of the above"]