{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Instructions","Eligibility Form","Income Input Form","Expense Input Form","Estimated Benefit Overview","Eligibility Profile","MAPR Profile","MAPR Rates","Form Validation"],"not_rendered":{"charts":0,"images":7,"macros":1,"external_links":0,"defined_names":4,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":26,"n_cols":6,"rows_kept":26,"cut":false,"hidden":false,"merged":[[18,2,18,5],[2,2,2,5],[3,2,3,5],[8,2,8,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[15,2,15,3],[11,2,11,3]]}
[]
[]
[null,null,"PENSION BENEFITS ESTIMATOR"]
[null,null,"VA Aid and Attendance (A&A) or Housebound benefits provide monthly payments added to the amount of a monthly VA pension for qualified Veterans in need of help with daily activities or who are housebound.  This tool is provided to assist those seeking to apply for the benefit understand eligibility and estimate the potential monthly benefits based on the following criteria:"]
[null,null,"1) Basic Eligibility "]
[null,null,"2) Maximum Allowable Pension Rate"]
[null,null,"3) Veteran's Reoccurring Income"]
[null,null,"4) Veteran's Medical Expenses"]
[null,null,"*Please note this estimator is being provided as a tool and does not constitute a decision or guarantee a benefit amount.  To determine if the Veteran is eligible for VA benefits, please file a claim."]
[]
[null,null,"Steps To Complete Estimate"]
[null,null,"1) Provide answers to question about military service, level of care and dependency on the Eligibility Input Form"]
[null,null,"2) List recurring income on the Income Input Tab"]
[null,null,"3) List  medical expenses on the Expense Input Tab"]
[]
[null,null,"The Estimated Benefit Overview Tab provides a summary of your responses and an estimate of pension benefit payments."]
[]
[]
[null,null,"The Pension Benefits Estimator tool was created by the St. Paul VA Regional Office.  The tool is to be used for assistance in preparing a claim for VA benefits and does not provide a decision on a claim."]
[null,null,"For Questions or Concerns  Contact the St. Paul Regional Office at "]
[null,null,"VBADirectorStPaulRO@va.gov"]
[]
[null,null,"Additional Resources"]
[null,null,"The following resources are available to assist you with navigating care options and applying for VA Special Monthly Pension Benefits"]
[]
[null,null,"      FOCUS Resource Guide","Step-by-Step Guide for Caregivers",null,"VA.GOV Website for Pension"]

{"sheet":"Eligibility Form","index":1,"n_rows":38,"n_cols":3,"rows_kept":38,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,2,2,5],[3,2,3,5],[5,2,5,3],[7,2,7,3],[6,3,6,5],[8,2,8,5],[12,3,12,5],[13,2,13,3],[11,2,11,5],[18,3,18,5],[14,2,15,5],[9,2,9,3],[35,3,35,5],[37,3,37,5],[17,2,17,3],[33,2,34,3],[10,2,10,3],[19,2,19,3],[20,2,20,5],[22,3,22,5],[24,2,24,3],[25,2,25,5],[29,2,29,3],[27,3,27,5]]}
[]
[null,null,"Eligibility Input"]
[null,null,"The Veterans Pension program provides monthly payments to wartime Veterans who meet certain age or disability requirements, and who have income and net worth within certain limits. Answers to the following questions will help determine the Maximum Allowable Pension Rate (MAPR)* if pension benefits are awarded. The MAPR is based on number of dependents, if the Veteran is married to another Veteran who qualifies for a pension, and if the Veteran's disabilities qualify them for Housebound or Aid and Attendance benefits. MAPRs are adjusted each year for cost-of-living increases.  "]
[null,null,"*Please note this estimator is being provided as a tool and does not constitute a decision or guarantee a benefit amount.  To determine if the Veteran is eligible for VA benefits, please file a claim."]
[null,null,"Service Eligibility"]
[null,null,"Under current law, Veterans must have at least one day of honorable service during a wartime period.*"]
[null,null,"Select the Veteran's Period of Serivce from the drop down menu."]
[null,null,"Additional Information Based on Selection"]
[null,null,{"$f":"IF(D7=\"Did not serve during timeframes listed\",\"Veteran must have served at least 1 day during a wartime period to be eligible to receive Veterans Pension benefits\",IF(D7=\"\",\"\",\"Veteran served under an eligible wartime period for Veterans Pension benefits\"))","v":""}]
[null,null,"*For more information about service eligibility see https://www.va.gov/pension/eligibility/"]
[null,null,"Level of Care"]
[null,null,"VA Aid and Attendance or Housebound benefits provide monthly payments added to the amount of a monthly VA pension for qualified Veterans who need help with daily activities, or are housebound."]
[null,null,"Select the Veteran's Level of Care Need from the drop down menu."]
[null,null,"Additional Information Based on Selection"]
[null,null,{"$f":"IF(D13=\"Veteran is not housebound and does not require the care of another individual\",\"Special Monthly Pension Benefits are paid to a veteran who is housebound or requires the care of another individual\",IF(D13=\"\",\"\",IF(D13=\"Is in a nursing home due to loss of mental or physical abilities related to a disability\",\"Fill out VA Form 21-0779 Request for Nursing Home Information in Connection with Claim for Aid and Attendance and include with your application\",\"Fill out VA Form 21-2680 (Examination for Housebound Status or Permanent Need for Regular Aid and Attendance) and include with your application.\")))","v":""}]
[]
[null,null,"Marital Status"]
[null,null,"The MAPR is based on marital status, whether the spouse is also a Veteran and the spouse's care need."]
[null,null,"Select Marital Status from the drop down menu."]
[null,null,"Additional Information Based on Selection"]
[null,null,{"$f":"IF(D19=\"Married\",\"Ensure you provide full marital history to include all dates of marriages, divorces and deaths (if applicable) on the VA Form 21-257 EZ\",\"\")","v":""}]
[]
[null,null,"If married, did spouse serve in Military?"]
[null,null,"*if unmarried, enter \"Not Applicable\""]
[null,null,"Additional Information Based on Selection"]
[null,null,{"$f":"IF(D23=\"Spouse is a Veteran\",\"Please include spouse's Social Security Number or VA File Number on application.\",\"\")","v":""}]
[]
[null,null,"Select the Spouse's Care Needs from the drop down menu.*"]
[null,null,"*if unmarried, enter \"Not Applicable\""]
[null,null,"Additional Information Based on Selection"]
[]
[]
[null,null,"Dependent Children"]
[null,null,"The MAPR is based on the Veteran's number of dependents"]
[]
[null,null,"Does the Veteran Have Dependent Children?"]
[]
[null,null,"Select the Number of Dependent Children from the drop down menu."]

{"sheet":"Income Input Form","index":2,"n_rows":30,"n_cols":19,"rows_kept":30,"cut":false,"hidden":false,"merged":[[29,2,30,17],[2,2,2,17],[3,2,3,17],[11,7,11,8],[11,2,11,3],[11,16,11,17],[5,2,5,17],[6,2,6,17],[10,7,10,8],[10,16,10,17],[23,2,23,3],[23,7,23,8],[11,11,11,12],[17,11,17,12],[23,11,23,12],[19,2,19,3],[19,7,19,8],[21,2,21,3],[21,7,21,8],[15,2,15,3],[13,11,13,12],[13,2,13,3],[13,7,13,8],[15,7,15,8],[17,2,17,3],[17,7,17,8],[13,16,13,17],[15,11,15,12],[15,16,15,17],[23,16,23,17],[17,16,17,17],[19,11,19,12],[19,16,19,17],[21,11,21,12],[21,16,21,17]]}
[]
[]
[null,null,"Income Input"]
[null,null,"Veterans Pension is an income-based program.  Your countable income* is how much you earn, including your Social Security benefits, investment and retirement payments, and any income your dependents receive.  List all of your sources of income and the gross monthly or annual amount (amount before any deductions).  Report any irregular income as \"One-Time\". "]
[]
[null,null,"*VA excludes certain types of income from countable income when determining entitlement to pension benefits. "]
[null,null,"For a list of income exclusions, see CFR 3.272"]
[]
[null,null,"Veteran's Income",null,null,null,null,null,null,null,null,"Spouse's Income"]
[null,null,null,null,null,null,null,null,null,null,null,"(if Veteran is unmarried, leave blank)"]
[null,null,"TYPE OF INCOME",null,null,"AMOUNT",null,"FREQUENCY",null,null,null,"TYPE OF INCOME",null,null,"AMOUNT",null,"FREQUENCY"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H12=\"\",\"0.00\",IF(OR(H12=\"Annual\",H12=\"One-Time\"),(F12*1),IF(H12=\"Weekly\",(F12*52),(F12*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Q12=\"\",\"0.00\",IF(OR(Q12=\"Annual\",Q12=\"One-Time\"),(O12*1),IF(Q12=\"Weekly\",(O12*52),(O12*12))))","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H14=\"\",\"0.00\",IF(OR(H14=\"Annual\",H14=\"One-Time\"),(F14*1),IF(H14=\"Weekly\",(F14*52),(F14*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Q14=\"\",\"0.00\",IF(OR(Q14=\"Annual\",Q14=\"One-Time\"),(O14*1),IF(Q14=\"Weekly\",(O14*52),(O14*12))))","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,{"$f":"IF(Q16=\"\",\"0.00\",IF(OR(Q16=\"Annual\",Q16=\"One-Time\"),(O16*1),IF(Q16=\"Weekly\",(O16*52),(O16*12))))","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,"Veteran's Annual Income",null,null,{"$f":"J12+J14+J16+J18+J20+J22+J24","v":0},null,null,null,null,null,"Spouse's Annual Income",null,null,{"$f":"S12+S14+S16+S18+S20+S22+S24","v":0}]
[]
[null,null,"Total Annual Income",null,null,{"$f":"F26+O26","v":0}]
[]
[null,null,"NOTE:  A claimant may not be eligible to receive pension benefits if the combination of assets and income, less medical expenses, exceeds $155,356."]

{"sheet":"Expense Input Form","index":3,"n_rows":25,"n_cols":29,"rows_kept":25,"cut":false,"hidden":false,"merged":[[16,2,16,3],[16,7,16,8],[16,11,16,12],[16,16,16,17],[14,2,14,3],[14,7,14,8],[14,11,14,12],[14,16,14,17],[20,2,20,3],[20,7,20,8],[20,11,20,12],[20,16,20,17],[18,2,18,3],[18,7,18,8],[18,11,18,12],[18,16,18,17],[12,2,12,3],[12,7,12,8],[12,11,12,12],[12,16,12,17],[8,11,8,12],[8,16,8,17],[10,2,10,3],[10,7,10,8],[10,11,10,12],[10,16,10,17],[8,2,8,3],[8,7,8,8],[20,20,20,21],[20,25,20,26],[2,2,2,26],[3,2,3,26],[14,20,14,21],[14,25,14,26],[16,20,16,21],[16,25,16,26],[18,20,18,21],[18,25,18,26],[8,20,8,21],[8,25,8,26],[10,20,10,21],[10,25,10,26],[12,20,12,21],[12,25,12,26]]}
[]
[]
[null,null,"Medical Expense Input",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,"Unreimbursed medical expenses (medical expenses not covered by your insurance provider or other entity), may reduce your countable income.   List your medical expenses and the monthly or annual amount.  Report any irregular expense as \"Annual\". "]
[]
[null,null,"Veteran's Expenses",null,null,null,null,null,null,null,null,"Spouses's Expenses",null,null,null,null,null,null,null,null,"Dependent Children's Expenses"]
[null,null,null,null,null,null,null,null,null,null,null,"(if Veteran is unmarried, leave blank)",null,null,null,null,null,null,null,null,"(if Veteran has no dependent children, leave blank)"]
[null,null,"TYPE OF EXPENSE",null,null,"AMOUNT",null,"FREQUENCY",null,null,null,"TYPE OF EXPENSE",null,null,"AMOUNT",null,"FREQUENCY",null,null,null,"TYPE OF EXPENSE",null,null,"AMOUNT",null,"FREQUENCY"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H9=\"\",\"0.00\",(IF(H9=\"Annual\",(F9*1),(F9*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Q9=\"\",\"0.00\",(IF(Q9=\"Annual\",(O9*1),(O9*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Z9=\"\",\"0.00\",(IF(Z9=\"Annual\",(X9*1),(X9*12))))","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(H11=\"\",\"0.00\",(IF(H11=\"Annual\",(F11*1),(F11*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Q11=\"\",\"0.00\",(IF(Q11=\"Annual\",(O11*1),(O11*12))))","v":"0.00"},null,null,null,null,null,null,null,null,{"$f":"IF(Z11=\"\",\"0.00\",(IF(Z11=\"Annual\",(X11*1),(X11*12))))","v":"0.00"}]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00",null,null,null,null,null,null,null,null,"0.00"]
[]
[null,null,"Veteran's Annual Expenses",null,null,{"$f":"J9+J11+J13+J15+J17+J19+J21","v":0},null,null,null,null,null,"Spouse's Annual Expenses",null,null,{"$f":"S9+S11+S13+S15+S17+S19+S21","v":0},null,null,null,null,null,"Children's Annual Expenses",null,null,{"$f":"AB9+AB11+AB13+AB15+AB17+AB19+AB21","v":0}]
[]
[null,null,"Total Annual Expense*",null,null,{"$f":"F23+O23+X23","v":0}]

{"sheet":"Estimated Benefit Overview","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[[1,2,1,5],[2,2,2,5],[6,3,6,5],[4,2,4,5],[21,2,21,5],[7,3,7,4],[19,3,19,4],[5,3,5,4],[3,2,3,5]]}
[]
[null,null,"Estimated Benefit Overview*"]
[null,null,"VA Aid and Attendance (A&A) or Housebound benefits provide monthly payments added to the amount of a monthly VA pension for qualified Veterans in need of help with daily activities or who are housebound.  This form will assist in determining basic eligibility to pension based on military service, the Veteran's entitlement to a higher level of pension based on severity of disability and the Veteran's Maximum Alllowable Pension Rate (MAPR) based on dependent status."]
[null,null,"*Please note this estimator is being provided as a tool and does not constitute a decision or guarantee a benefit amount.  To determine if the Veteran is eligible for VA benefits, please file a claim."]
[null,null,"The estimates below are based on the MAPR for 2024"]
[null,null,"Wartime Service Eligibility ",{"$f":"IF('Eligibility Form'!D7=\"\",\"\",IF('Eligibility Form'!D7=\"Did not serve during timeframes listed\",\"Veteran does not have eligible service for pension benefit\",\"Veteran served under an eligible wartime period for Veterans Pension benefits\"))","v":""}]
[]
[null,null,"Veteran's Level of Care",{"$f":"IF('Eligibility Form'!D13=\"\",\"\",IF('Eligibility Form'!D13='Form Validation'!A12,\"Veteran does not meet Special Monthly Pension benefit criteria\",IF('Eligibility Form'!D13='Form Validation'!A13,\"Veteran may qualify for Housebound benefits\",\"Veteran may qualify for Aid and Attendance benefits\")))","v":""}]
[]
[null,null,"Maximum Annual Pension Rate (MAPR)",{"$f":"IFERROR(INDEX('MAPR Rates'!C:C,MATCH('Eligibility Profile'!D12,'MAPR Rates'!D:D,0)),\"\")","v":""}]
[]
[null,null,"Annual Income for VA Purposes",{"$f":"'Income Input Form'!F28","v":0}]
[]
[null,null,"Annual Expense",{"$f":"'Expense Input Form'!F25","v":0}]
[]
[null,null,"Estimated Pension Benefit*"]
[null,null,"Annual",{"$f":"IFERROR(ROUNDDOWN(H17,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(MAX(0,D10-(MAX(0,(D12-(IF(D14>('MAPR Rates'!C2*0.05),(D14-('MAPR Rates'!C2*0.05)),D14)))))),\"\")","v":""}]
[null,null,"Monthly",{"$f":"IFERROR(ROUNDDOWN(H18,0),\"\")","v":""},null,null,null,{"$f":"IFERROR(D17/12,\"\")","v":""}]
[]
[null,null,null,{"$f":"IF(D17=0,\"Income exceeds allowable limit for benefit.\",\"\")","v":""}]
[]
[null,null,"NOTE:  A claimant may not be eligible to receive pension benefits if the combination of assets and income, less medical expenses, exceeds $155,356 (the 2024 allowable limit).  For more information about how assets are evaluated, visit: "]
[null,null,"https://www.va.gov/pension/veterans-pension-rates/"]

{"sheet":"Eligibility Profile","index":5,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["Question","Questions",null,"Formula"]
[1,"Did the Veteran serve during a wartime period?",{"$f":"IF('Eligibility Form'!D7=\"Did not serve during timeframes listed\",\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(C2=\"yes\",1,0)","v":1}]
[2,"Does the Veteran have a perment disability?",{"$f":"IF('Eligibility Form'!D13=\"Veteran does not have a permanent disability\",\"No\",\"Yes\")","v":"Yes"},{"$f":"IF(C3=\"yes\",1,0)","v":1}]
[3,"Does the Veteran spend most of their time in their home because of a permanent disability?",{"$f":"IF('Eligibility Form'!D13=\"Spends most of their time at home because of a permanent disability, but does not need additional assistance\",\"Yes\",\"No\")","v":"No"},{"$f":"IF(C4=\"yes\",1,0)","v":0}]
[4,"Does the Veteran need/have one of the following?  The Veteran require another person to help them perform daily activities, like bathing, feeding and dressing.  The Veteran a patient in a nursing home due to the loss of mental or physical abilities related to a disability.  Veteran's eyesight limited to 5/200 or less visual acuity in both eyes or have concentric contraction of the visual field to 5 degrees or less. ",{"$f":"IF(OR('Eligibility Form'!D13=\"Requires another person to help them perform daily activities, like bathing, feeding and dressing\",'Eligibility Form'!D13=\"Is in a nursing home due to loss of mental or physical abilities related to a disability\",'Eligibility Form'!D13=\"Eyesight is limited to 5/200 or less visual acuity in both eyes or has concentric contraction of the visual field to 5 degrees or less\"),\"Yes\",\"No\")","v":"No"},0]
[5,"Is the Veteran married?",{"$f":"IF('Eligibility Form'!D19=\"Married\",\"Yes\",\"No\")","v":"No"},0]
[6,"If yes, is the Veteran's spouse a Veteran, as well?",{"$f":"IF('Eligibility Form'!D23=\"Spouse is a Veteran\",\"Yes\",\"No\")","v":"No"},0]
[7,"Does the Veteran-Spouse spend most of their time in their home because of a permanent disability",{"$f":"IF('Eligibility Form'!D28=\"Spouse spends most of their time at home because of a permanent disability, but does not need additional assistance\",\"Yes\",\"No\")","v":"No"},0]
[8,"Does the Veteran-Spouse need/have one of the following?  The Veteran require another person to help them perform daily activities, like bathing, feeding and dressing.  The Veteran a patient in a nursing home due to the loss of mental or physical abilities related to a disability.  Veteran's eyesight limited to 5/200 or less visual acuity in both eyes or have concentric contraction of the visual field to 5 degrees or less. ",{"$f":"IF(OR('Eligibility Form'!D28=\"Spouse requires another persoan to help them perform daily activities, like bathing, feeding and dressing\",'Eligibility Form'!D28=\"Spouse is in a nursing home due to loss of mental or physical abilities related to a disability\",'Eligibility Form'!D28=\"Eyesight is limited to 5/200 or less visual acuity in both eyes or has concentric contraction of the visual field to 5 degrees or less\"),\"Yes\",\"No\")","v":"No"},0]
[9,"Does the Veteran have dependent children?",{"$f":"'Eligibility Form'!D36","v":0},0]
[10,"If Yes, How Many?",{"$f":"'Eligibility Form'!D38","v":0}]
[null,"Veteran Profile Code",null,{"$f":"D2&D3&D4&D5&D6&D7&D8&D9&D10","v":"110000000"}]

{"sheet":"MAPR Profile","index":6,"n_rows":17,"n_cols":13,"rows_kept":17,"cut":false,"hidden":true,"merged":[]}
["Profile","Desciption ","Q1","Q2","Q3","Q4","Q5","Q6","Q7","Q8","Q9","Q10","Profile code"]
["Veteran - BP","Veteran with no dependents who does not need HB or AA",1,0,0,0,0,0,0,0,0,null,{"$f":"C2&D2&E2&F2&G2&H2&I2&J2&K2","v":"100000000"}]
["Veteran - HB","Veteran with no dependents who is HB",1,1,1,0,0,0,0,0,0,null,"111000000"]
["Veteran - AA","Veteran with no dependents who needs AA",1,1,0,1,0,0,0,0,0,null,"110100000"]
["Veteran + Spouse -BP","Veteran married to non-Veteran and does not need HB or AA",1,0,0,0,1,0,0,0,0,null,"100010000"]
["Veteran + Spouse -  HB","Veteran married to non-Veteran and needs HB",1,1,1,0,1,0,0,0,0,null,"111010000"]
["Veteran + Spouse - AA","Veteran married to non-Veteran and needs AA",1,1,0,1,1,0,0,0,0,null,"110110000"]
["Veteran + Veteran - BP","Veteran married to Veteran - neither need HB or AA",1,0,0,0,1,1,0,0,0,null,"100011000"]
["Veteran + Vetaran - V HB","Veteran married to Veteran - Veteran need HB ",1,1,1,0,1,1,0,0,0,null,"111011000"]
["Veteran + Vetaran - S HB","Veteran married to Veteran - Spouse need HB ",1,0,0,0,1,1,1,0,0,null,"100011100"]
["Veteran + Veteran  - 2 HB","Veteran married to Veteran - both need HB",1,1,1,0,1,1,1,0,0,null,"111011100"]
["Veteran + Veteran - V AA & S BP","Veteran married to Veteran - Veteran need AA & Spouse doesn't need HB or AA",1,1,0,1,1,1,0,0,0,null,"110111000"]
["Veteran + Veteran - V HB & S AA","Veteran married to Veteran - Vet needs HB & Spouse needs AA",1,1,1,0,1,1,0,1,0,null,"111011010"]
["Veteran + Veteran - 2 AA","Veteran married to Veteran - both need AA",1,1,0,1,1,1,0,1,0,null,"110111010"]
["Veteran + I Child - BP","Unmarried Veteran with 1 Child who does not need HB or AA",1,0,0,0,0,0,0,0,1,null,"100000001"]
["Veteran + 1 Child - V HB","Unmarried Veteran with 1 Child who who needs HB",1,1,1,0,0,0,0,0,1,null,"111000001"]
["Veteran + 1 Child  -  VAA","Unmarried Veteran with 1 Child who who needs AA",1,1,0,1,0,0,0,0,1,null,"110100001"]

{"sheet":"MAPR Rates","index":7,"n_rows":18,"n_cols":4,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
["Year","Veteran Profile","MAPR","Profile Code"]
[2024,"Veteran - BP",16551,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B2,'MAPR Profile'!A:A,0))","v":"100000000"}]
[2024,"Veteran - HB",20226,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B3,'MAPR Profile'!A:A,0))","v":"111000000"}]
[2024,"Veteran - AA",27609,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B4,'MAPR Profile'!A:A,0))","v":"110100000"}]
[2024,"Veteran + Spouse -BP",21674,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B5,'MAPR Profile'!A:A,0))","v":"100010000"}]
[2024,"Veteran + Spouse -  HB",25348,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B6,'MAPR Profile'!A:A,0))","v":"111010000"}]
[2024,"Veteran + Spouse - AA",32729,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B7,'MAPR Profile'!A:A,0))","v":"110110000"}]
[2024,"Veteran + Veteran - BP",21674,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B8,'MAPR Profile'!A:A,0))","v":"100011000"}]
[2024,"Veteran + Vetaran - V HB",25348,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B9,'MAPR Profile'!A:A,0))","v":"111011000"}]
[2024,"Veteran + Vetaran - S HB",25348,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B10,'MAPR Profile'!A:A,0))","v":"100011100"}]
[2024,"Veteran + Veteran  - 2 HB",29021,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B11,'MAPR Profile'!A:A,0))","v":"111011100"}]
[2024,"Veteran + Veteran - V AA & S BP",32729,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B12,'MAPR Profile'!A:A,0))","v":"110111000"}]
[2024,"Veteran + Veteran - V HB & S AA",36395,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B13,'MAPR Profile'!A:A,0))","v":"111011010"}]
[2024,"Veteran + Veteran - 2 AA",43791,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B14,'MAPR Profile'!A:A,0))","v":"110111010"}]
[2024,"Veteran + I Child - BP",21674,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B15,'MAPR Profile'!A:A,0))","v":"100000001"}]
[2024,"Veteran + 1 Child - V HB",25348,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B16,'MAPR Profile'!A:A,0))","v":"111000001"}]
[2024,"Veteran + 1 Child  -  VAA",32729,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B17,'MAPR Profile'!A:A,0))","v":"110100001"}]
[2024,"Each Additional Child",2831,{"$f":"INDEX('MAPR Profile'!M:M,MATCH(B18,'MAPR Profile'!A:A,0))","v":{"$error":"#N/A"}}]

{"sheet":"Form Validation","index":8,"n_rows":53,"n_cols":7,"rows_kept":53,"cut":false,"hidden":true,"merged":[]}
["Perior of Service"]
["Mexican Border (05/09/1916 -  04/05/1917)"]
["World War I (04/06/1917 - 11/11/1918)"]
["World War II (12/07/1941 - 12/31/1946)"]
["Korean Conflict (06/27/1950 - 01/31/1955)"]
["Vietnam War Era (02/28/1961 - 05/07/1975) "]
["Gulf War (08/02/1990 - current date)"]
["Did not serve during timeframes listed"]
[]
[]
["Level of Care"]
["Veteran is not housebound and does not require the care of another individual"]
["Spends most of their time at home because of a permanent disability, but does not need additional assistance"]
["Requires another person to help them perform daily activities, like bathing, feeding and dressing"]
["Is in a nursing home due to loss of mental or physical abilities related to a disability"]
["Eyesight is limited to 5/200 or less visual acuity in both eyes or has concentric contraction of the visual field to 5 degrees or less"]
[]
["Marital Status",null,"Unmarried",null,"Spouse Service",null,"Column1"]
["Married",null,"Not Applicable",null,"Spouse is not a Veteran ",null,"Spouse is not housebound and does not require the care of another individual"]
["Unmarried",null,null,null,"Spouse is a Veteran",null,"Spouse spends most of their time at home because of a permanent disability, but does not need additional assistance"]
[null,null,null,null,null,null,"Spouse requires another persoan to help them perform daily activities, like bathing, feeding and dressing"]
[null,null,null,null,null,null,"Spouse is in a nursing home due to loss of mental or physical abilities related to a disability"]
[null,null,null,null,null,null,"Spouse's eyesight is limited to 5/200 or less visual acuity in both eyes or has concentric contraction of the visual field to 5 degrees or less"]
["Column1",null,"Column1"]
["Yes",null,1]
["No",null,2,null,null,null,"Spouse is not housebound and does not require the care of another individual"]
[null,null,3,null,null,null,"Spouse spends most of their time at home because of a permanent disability, but does not need additional assistance"]
[null,null,4,null,null,null,"Spouse requires another persoan to help them perform daily activities, like bathing, feeding and dressing"]
[null,null,5,null,null,null,"Spouse is in a nursing home due to loss of mental or physical abilities related to a disability"]
[null,null,6,null,null,null,"Spouse's eyesight is limited to 5/200 or less visual acuity in both eyes or has concentric contraction of the visual field to 5 degrees or less"]
[null,null,7]
[null,null,8]
[null,null,9]
[null,null,10]
[]
[]
[]
["INCOME TAB"]
[]
["Column1"]
["One-Time"]
["Weekly"]
["Monthly  "]
["Annual"]
[]
["Social Security",null,"Care Expenses"]
["US Civil Service",null,"Medicare Premium"]
["Railroad Retirement",null,"Prescriptions"]
["Military Retired Pay",null,"Private Medical Insurance"]
["Black Lung Benefits",null,"Other"]
["SSI / Public Assistance"]
["Interest / Dividend Income"]
["Other Income"]