{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["Cover Page","Input","Input_Output_LSA","Input_Output_LSA_SALS_SSTFC","LSA_to_LTA","FVSplit","Current_LTA_Rebalance","TTFAC_Protection","Glossary","IntermediateCalcs","Result","LTA Table","LSA Table","LSDBA Table","Protection Table","VersionHistory"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":134,"comments":7,"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":"Cover Page","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Input","index":1,"n_rows":25,"n_cols":29,"rows_kept":25,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,"LTA% used up by","RL policies","Other Provider","     LTA Spreadsheet",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,0]
[null,"General Information Mandatory Inputs for calculation or Populating Data",null,null,null,"RL Policy1/ This Policy",0,0]
[null,null,null,null,null,"RL Policy2",0,0]
[null,"Policy holder name*",null,null,null,"RL Policy3",0,0]
[null,"Policy number*",null,null,null,"RL Policy4",0,0,null,"LTA % used up with other provider",{"$f":"SUM(H2:H21)","v":0}]
[null,"Date of Birth*",null,"1970-08-21",null,"RL Policy5",0,0,null,"Total LTA % used up by other RL policies",{"$f":"SUM(G2:G21)","v":0}]
[null,"Today's Date*",null,"2025-08-21",null,"RL Policy6",0,0]
[null,"National Insurance Number*",null,null,null,"RL Policy7",0,0,null,"Type of most recent BCE"]
[null,null,null,null,null,"RL Policy8",0,0,null,null,null,null,null,null,"Product*"]
[null,null,null,null,null,"RL Policy9",0,0,null,"LTA Protection",null,null,null,null,"Location:",{"$f":"IF(Product_type=\"TAL-ID\",\"\\\\netehnas01\\income_drawdown\\New\\LTA Calculation\",\"\\\\royallondongroup.com\\depts\\RLIPD\\Special\\Calcs Projects\\LTA Spreadsheet Changes\\Phase 2\\Testing\\Multiple Policy\")","v":"\\\\royallondongroup.com\\depts\\RLIPD\\Special\\Calcs Projects\\LTA Spreadsheet Changes\\Phase 2\\Testing\\Multiple Policy"}]
[null,null,null,null,null,"RL Policy10",0,0,null,"Amount if Protected LTA"]
[null,"Age 75 specific Input",null,null,null,"RL Policy11",0,0]
[null,null,null,null,null,"RL Policy12",0,0]
[null,"Type of test (testing against)",null,null,null,"RL Policy13",0,0]
[null,null,null,null,null,"RL Policy14",0,0]
[null,"Original Investment Amount",null,null,null,"RL Policy15",0,0]
[null,"Tax free Cash Paid",null,null,null,"RL Policy16",0,0]
[null,"Crystallised Plan Value at Age 75",null,null,null,"RL Policy17",0,0]
[null,"Original LTA%",null,null,null,"RL Policy18",0,0]
[null,"Uncrystallised pension at age 75",null,null,null,"RL Policy19",0,0]
[null,null,null,null,null,"RL Policy20",0,0]
[]
[null,"Tax free cash payments before 6th April 2006 (Pre A Day)",null,null,null,null,null,null,null,null,"Tax free cash payments between 6th April 2006 (Post A Day) – 5th April 2024"]
[]
[null,null,"BCE Date","Type","Amount Crystallised","GAD Max","LTA Amount","LTA Protection",null,null,null,"BCE Date","Type","Amount Crystallised","GAD Max","LTA Amount","LTA Protection"]

{"sheet":"Input_Output_LSA","index":2,"n_rows":101,"n_cols":14,"rows_kept":101,"cut":false,"hidden":false,"merged":[[86,4,92,6]]}
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"RBCE type options"]
[null,"General Information Mandatory Inputs for calculation or Populating Data",null,null,null,null,null,null,null,null,null,null,null,"PCLS"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,"UFPLS"]
[]
[null,"Policy holder name"]
[null,"Policy number"]
[null,"Date of Birth*"]
[null,"Quote Date*"]
[]
[]
[" **This is sum of LTA% for  all Pre and Post April 2024 BCE events including SIHLs.  PLEASE NOTE: Oryx has known issues with calculating LTA% for SIHL and UFPLS. Please calculate LTA% manually using 'Input' tab of this spreadsheet for such cases","LTA % Used at Quote Date"]
[]
[]
[null,"Pre-commencement pensions",null,null,null,null,null,"Crystallised FV (Post Apr 2024) for Death and Serious Ill Health Lumpsum",null,"**Leave blank if:\n•\tTransferring a Beneficiary IR (Ben IR), or\n•\tCustomer is over 75 years old when they died, or\n•\tCustomer is under 75 when they died, however the bereavement claim is paid more than 2 years after notification of death"]
["**If current LTA% used up includes benefits taken on or after 06/04/2024 then you must select this as 'Yes' and complete the LTA% below","Benefits taken on or after 06/04/24"]
["**If current LTA% used up includes benefits taken on or after 06/04/2024 then you must calculate LTA% manually for those amounts and complete this input","Used up LTA% for Benefits after 06/04/24",null,null,null,null,null,"Uncrystallised FV for Death and Serious Ill Health Lumpsum",null,"**Leave blank if:\n•\tTransferring a Beneficiary IR (Ben IR), or\n•\tCustomer is over 75 years old when they died, or\n•\tCustomer is under 75 when they died, however the bereavement claim is paid more than 2 years after notification of death"]
[null,"LTA % age used up @ 5/4/24 for Non SIHL benefits",{"$f":"IF(LSA_BenAftApril_Ind=\"No\",LSA_Curr_LTA-LSA_SIHL_LTA_beforeApr-LSA_SIHL_LTA_AfterApr,LSA_Curr_LTA-LSA_LTAAftApril-LSA_SIHL_LTA_beforeApr-LSA_SIHL_LTA_AfterApr)","v":0}]
[null,null,null,null,null,null,null," Serious Ill Health Lumpsum taken before 06/04/24*"]
[null,"Has Protection*",null,null,null,null,null,"Used up LTA% for  Serious Ill Health Lumpsum taken before 06/04/24\n**If current LTA% used up includes SIHL taken before 06/04/2024 then you must calculate LTA% manually for those amounts and complete this input"]
[null,"Amount if Protected",null,null,null,null,null,"Used up LTA% for  Serious Ill Health Lumpsum taken after 06/04/24\n**If current LTA% used up includes SIHL taken on or after 06/04/2024 then you must calculate LTA% manually for those amounts and complete this input"]
[null,"Protected Pension Age 50 or under?"]
[]
[null,"Monetary amount after 6th April 2024 Table",null,null,null,null,null,"Serious Ill Health (Post April 2024)"]
[null,"Date","Amount for RBCE taken on or after 6/4/2024","Type","PCLS/Tax Free Cash **Assumed as 25% of RBCE",null,null,"Date"," Serious Ill Health Lumpsum Amount"]
[null,null,null,null,{"$f":"C26*0.25","v":0}]
[null,null,null,null,{"$f":"C27*0.25","v":0}]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,0]
[null,null,null,null,{"$f":"ROUND(SUM(E26:E56),2)","v":0},null,null,null,{"$f":"SUM(I26:I56)","v":0}]
[]
[]
[]
[null,"LSA protected amount applied",null,{"$f":"IF(LSA_Is_Protected=\"No protection (PP)\",0,IF(OR(LSA_Is_Protected=\"Primary protection (PP)\",LSA_Is_Protected=\"Enhanced protection (EP)\",LSA_Is_Protected=\"Individual protection 2014 (IP 2014)\",LSA_Is_Protected=\"Individual protection 2016 (IP 2016)\"),LSA_Protected_Amount,VLOOKUP(LSA_Is_Protected,Protection_Table,2,FALSE)))","v":{"$error":"#N/A"}}]
[null,"Lifetime allowance to use for conversion",null,{"$f":"IF(LSA_Is_Protected=\"No Protection\",VLOOKUP(2024,LTA_Table,4),LSA_Prot_Amount_Applied)","v":{"$error":"#N/A"}}]
[]
[null,"Equivalent LSA for benefits taken on before 05/4/2024",null,{"$f":"LSA_LTAat5April*0.25*LSA_Std_LTA_at6April+LSA_SIHL_LTA_beforeApr*0.25*LSA_Std_LTA_at6April","v":{"$error":"#N/A"}}]
[null,"Equivalent LSDBA used up for benefits taken on before 05/4/2024",null,{"$f":"IF(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr >= 100%,LSA_Std_LTA_at6April,IF(AND(LSA_SIHLtaken_beforeApril=\"Yes\",LSA_SIHL_LTA_beforeApr>0),(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April,0.25*(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April))","v":{"$error":"#N/A"}}]
[]
[null,"Total LSA till date",null,{"$f":"ROUND(D64+LSA_PCLS_TFC_AftApril+PreCommPension,2)","v":{"$error":"#N/A"}}]
[]
[null,"LSA at quote date",null,{"$f":"IF(LSA_Is_Protected=\"No Protection\",VLOOKUP(IF(MONTH(LSA_Q_Date)<4,YEAR(LSA_Q_Date)-1,IF(AND(MONTH(LSA_Q_Date)=4,DAY(LSA_Q_Date)<6),YEAR(LSA_Q_Date)-1,YEAR(LSA_Q_Date))),LSA_Table,4),LSA_Prot_Amount_Applied/4)","v":{"$error":"#N/A"}}]
[]
[null,"LSA after reduction applied (if any)",null,{"$f":"IF(OR(LSA_Is_Spl_Occupation=\"No\",B26=\"\"),LSA_At_QuoteDate,(100%-2.5%*IF(AND(LSA_Is_Spl_Occupation=\"Yes\",B26>=DATE(YEAR(LSA_DOB)+50,MONTH(LSA_DOB),DAY(LSA_DOB))),0,IFERROR(DATEDIF(B26,DATE(YEAR(LSA_DOB) + VLOOKUP(IF(MONTH(B26)=4,IF(DAY(B26)>=6,YEAR(B26),YEAR(B26)-1),IF(MONTH(B26)>4,YEAR(B26),YEAR(B26)-1)),LSA_Table,3),MONTH(LSA_DOB),DAY(LSA_DOB)),\"Y\"),0)))*LSA_At_QuoteDate)","v":{"$error":"#N/A"}}]
[]
[null,"Amount of last Lumpsum",null,{"$f":"IF(B26=\"\",,SUMIF(B26:B56,MAX(B26:B56),LSA_RBCE))","v":0}]
[]
[null,"Date of last Lumpsum",null,{"$f":"MAX(LSA_RBCE_Date)","v":"00:00:00"}]
[]
[null,"Available LSA before last lumpsum",null,{"$f":"LSA_Reduction-LSA_Total+LSA_Latest_LS_Amount","v":{"$error":"#N/A"}}]
[]
[null,"Excess LSA after taking last lumpsum",null,{"$f":"MAX(LSA_Latest_LS_Amount-IF(LSA_Available=\"No BCE after 6th April 2024\",0,LSA_Available),0)","v":{"$error":"#N/A"}},null,null,null,null,null,{"$f":"IF(LSA_Excess>0,\"**Please calculate Tax using Tax calculator\",\"\")","v":{"$error":"#N/A"}}]
[]
[null,"LSDBA at quote date",null,{"$f":"IF(LSA_Is_Protected=\"No Protection\",VLOOKUP(IF(MONTH(LSA_Q_Date)<4,YEAR(LSA_Q_Date)-1,IF(AND(MONTH(LSA_Q_Date)=4,DAY(LSA_Q_Date)<6),YEAR(LSA_Q_Date)-1,YEAR(LSA_Q_Date))),LSDBA_Table,4),LSA_Prot_Amount_Applied)","v":{"$error":"#N/A"}}]
[]
[null,"LSDBA after reduction applied (if any)",null,{"$f":"IF(OR(LSA_Is_Spl_Occupation=\"No\",B26=\"\"),LSA_LSDBA,(100%-2.5%*IF(AND(LSA_Is_Spl_Occupation=\"Yes\",B26>=DATE(YEAR(LSA_DOB)+50,MONTH(LSA_DOB),DAY(LSA_DOB))),0,IFERROR(DATEDIF(B26,DATE(YEAR(LSA_DOB) +VLOOKUP(IF(MONTH(B26)=4,IF(DAY(B26)>=6,YEAR(B26),YEAR(B26)-1),IF(MONTH(B26)>4,YEAR(B26),YEAR(B26)-1)),LSDBA_Table,3),MONTH(LSA_DOB),DAY(LSA_DOB)),\"Y\"),0)))*IF(LSA_Is_Protected=\"No Protection\",VLOOKUP(IF(MONTH(B26)=4,IF(DAY(B26)>=6,YEAR(B26),YEAR(B26)-1),IF(MONTH(B26)>4,YEAR(B26),YEAR(B26)-1)),LSDBA_Table,4),LSA_Prot_Amount_Applied))","v":{"$error":"#N/A"}}]
[]
[null,"Available LSDBA",null,{"$f":"MAX(0,LSA_LSDBA_Reduced-(D65+LSA_PCLS_TFC_AftApril+PreCommPension))","v":{"$error":"#N/A"}}]
[]
[null,"Total LSDBA Taken",null,{"$f":"D65+LSA_PCLS_TFC_AftApril+PreCommPension+LSA_SIHL_Tot+I15+I17","v":{"$error":"#N/A"}},{"$f":"IF(LSA_Total_LSDBA>VLOOKUP(IF(MONTH(LSA_Q_Date)<4,YEAR(LSA_Q_Date)-1,IF(AND(MONTH(LSA_Q_Date)=4,DAY(LSA_Q_Date)<6),YEAR(LSA_Q_Date)-1,YEAR(LSA_Q_Date))),LSDBA_Table,4),\"IF this is a SIHLS settlement and the customer has exceeded their LSDBA, please follow the exceptions SIHLS process AND update the Event 24 tracker held Here M:\\Customer Commitments\\01. RLI Servicing\\04. Transfers\\Event 24\",\"\")","v":{"$error":"#N/A"}}]
[]
[null,"Excess LSDBA",null,{"$f":"MAX(0,LSA_SIHL_Tot+I15+I17-D85)","v":{"$error":"#N/A"}}]
[]
[null,"LSA remaining",null,{"$f":"MAX(0,LSA_Available-LSA_Latest_LS_Amount)","v":{"$error":"#N/A"}}]
[]
[null,"LSDBA remaining",null,{"$f":"MAX(0,D85-LSA_SIHL_Tot-I17-I15)","v":{"$error":"#N/A"}},null,null,null,null,null,"DM!!! Remember to switch save warning in Sub Workbook_BeforeSave back on!!!!"]
[]
[null,"LSA used Pre 06/04/2024",null,{"$f":"D64","v":{"$error":"#N/A"}}]
[]
[null,"LSA used Post 06/04/2024",null,{"$f":"LSA_Total-D95","v":{"$error":"#N/A"}}]
[]
[null,"LSDBA used Pre 06/04/2024",null,{"$f":"D65","v":{"$error":"#N/A"}}]
[]
[null,"LSDBA used Post 06/04/2024",null,{"$f":"LSA_Total_LSDBA-D99","v":{"$error":"#N/A"}}]

{"sheet":"Input_Output_LSA_SALS_SSTFC","index":3,"n_rows":16,"n_cols":5,"rows_kept":16,"cut":false,"hidden":false,"merged":[]}
[null,"LSA and LSDBA Calculation for SALS and SSTFC"]
["Input"]
[]
[null,"Effective Date"]
[null,"Total Crystallised Amount"]
[null,"Total Tax-free Cash Amount",null,null,{"$f":"IF(ISERROR(LSA_Total),\"WARNING: LSA used up amount till date is not available\",IF(OR(Input_Output_LSA!D91=0),\"No LSA remaining hence can't take Tax free cash\",\"\"))","v":"WARNING: LSA used up amount till date is not available"}]
[]
["Output"]
[]
[null,"LSA Used for SALS and SSTFC only",{"$f":"ROUND(IF(SALS_SSTFC_TFC_Amt<ROUND(0.25*SALS_SSTFC_Crystallised_Amt,2),SALS_SSTFC_TFC_Amt,0.25*SALS_SSTFC_Crystallised_Amt),2)","v":0},null,{"$f":"IF(SALS_SSTFC_Eff_Dt=\"\",\"Please enter effective Date\",IF(SALS_SSTFC_LSA>VLOOKUP(IF(MONTH(SALS_SSTFC_Eff_Dt)<4,YEAR(SALS_SSTFC_Eff_Dt)-1,IF(AND(MONTH(SALS_SSTFC_Eff_Dt)=4,DAY(SALS_SSTFC_Eff_Dt)<6),YEAR(SALS_SSTFC_Eff_Dt)-1,YEAR(SALS_SSTFC_Eff_Dt))),LSA_Table,4),\"As the customer has used all of their LSA, please update the Event 24 tracker held Here --> M:\\Customer Commitments\\01. RLI Servicing\\04. Transfers\\Event 24\",\"\"))","v":"Please enter effective Date"}]
[]
[null,"LSDBA Used for SALS and SSTFC only",{"$f":"ROUND(SALS_SSTFC_TFC_Amt,2)","v":0}]
[]
[null,"Total LSA Used **includes LSA from Input_Output_LSA sheet",{"$f":" IF(ISERROR(LSA_Total),SALS_SSTFC_LSA,SALS_SSTFC_LSA+LSA_Total)","v":0},null,{"$f":"IF(ISERROR(LSA_Total),\"LSA used in Input_Output_LSA sheet is either not calculated or there is an error\",\"\")","v":"LSA used in Input_Output_LSA sheet is either not calculated or there is an error"}]
[null,null,null,null,{"$f":"IF(SALS_SSTFC_Eff_Dt=\"\",\"Please enter effective Date\",IF(SALS_SSTFC_Total_LSA>VLOOKUP(IF(MONTH(SALS_SSTFC_Eff_Dt)<4,YEAR(SALS_SSTFC_Eff_Dt)-1,IF(AND(MONTH(SALS_SSTFC_Eff_Dt)=4,DAY(SALS_SSTFC_Eff_Dt)<6),YEAR(SALS_SSTFC_Eff_Dt)-1,YEAR(SALS_SSTFC_Eff_Dt))),LSA_Table,4),\"As the customer has used all of their LSA, please update the Event 24 tracker held Here --> M:\\Customer Commitments\\01. RLI Servicing\\04. Transfers\\Event 24\",\"\"))","v":"Please enter effective Date"}]
[null,"Total LSDBA Used **includes LSDBA from Input_Output_LSA sheet",{"$f":" IF(ISERROR(LSA_Total_LSDBA),SALS_SSTFC_LSDBA,SALS_SSTFC_LSDBA+LSA_Total_LSDBA)","v":0},null,{"$f":"IF(ISERROR(LSA_Total_LSDBA),\"LSDBA used in Input_Output_LSA sheet is either not calculated or there is an error\",\"\")","v":"LSDBA used in Input_Output_LSA sheet is either not calculated or there is an error"}]

{"sheet":"LSA_to_LTA","index":4,"n_rows":23,"n_cols":8,"rows_kept":23,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Has Protection*",null,null,"LSA amount"]
[null,"Protected LTA Amount",null,null,"Date","LSA amount","Tax Year Start","LTA%"]
[null,"Protected LTA Used In Calculations",{"$f":"IF(LSA2LTA_Is_protection=\"\",\"\",\nIF(LEFT(LSA2LTA_Is_protection,2)=\"No\",\"LTA Not Protected. Standard LTA Used\",\nIF(LEFT(LSA2LTA_Is_protection,5)=\"Fixed\",VLOOKUP(LSA2LTA_Is_protection,Protection_Table,2,0),\nIF(LSA2LTA_Prt_amt=\"\",\"Enter \"&LSA2LTA_Is_protection&\" amount in cell above\",LSA2LTA_Prt_amt))))","v":""},null,null,null,{"$f":"IF($E4=\"\",\"\",YEAR($E4)-($E4<=DATE(YEAR($E4),4,5)))","v":""},{"$f":"IF(OR($E4=\"\",LSA2LTA_Is_protection=\"\",AND(LEFT(LSA2LTA_Is_protection,2)<>\"No\",ISNUMBER(Protected_LTA_To_Use)=FALSE)),\"\",\nROUNDDOWN($F4/(IF(LEFT(LSA2LTA_Is_protection,2)=\"No\",IF($G4<YEAR(LSA2LTA_AbolitionDate),VLOOKUP($G4,LTA_Table,4,0)/4,VLOOKUP($G4,LSA_Table,4,1)),\nProtected_LTA_To_Use/4)),4))","v":""}]
[null,"LTA abolition date","2024-04-06",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,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,"Total LTA",{"$f":"ROUNDDOWN(SUM(H4:H21),4)","v":0}]

{"sheet":"FVSplit","index":5,"n_rows":12,"n_cols":3,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
[null,"Eservice Values prior to exit","Factors"]
["IR £",347688.41,{"$f":"BeforeExitIR/TotalFVBeforeExit","v":0.74920520619517039}]
["Savings £",116387.93,{"$f":"BeforeExitSavings/TotalFVBeforeExit","v":0.25079479380482961}]
[null,{"$f":"SUM(BeforeExitIR,BeforeExitSavings)","v":464076.33999999997}]
[]
[]
["Eservice actual Exit Value:",467603.33]
[]
[]
[null,"Revalued IR / Savings"]
["IR £",{"$f":"ROUND(ActualExitValue*IRpct,2)","v":350330.85}]
["Savings £",{"$f":"ROUND(ActualExitValue-B11,2)","v":117272.48}]

{"sheet":"Current_LTA_Rebalance","index":6,"n_rows":14,"n_cols":3,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Policy holder name"]
[null,"Policy number"]
[null,"Quote Date*"]
[null,"LSA used up at quote date by this RL plan*"]
[null,"Total LSA used up at quote date by other RL plans/ providers*"]
[null,"Has Protection*"]
[null,"Protected LSA Amount if Protected"]
[]
[null,"Standard/ Protected LumpSum Allowance to use",{"$f":"IF(OR(IsProtected=\"\",IsProtected=\"No Protection\"),VLOOKUP(IF(MONTH(QuoteDate)<4,YEAR(QuoteDate)-1,IF(AND(MONTH(QuoteDate)=4,DAY(QuoteDate)<6),YEAR(QuoteDate)-1,YEAR(QuoteDate))),LSA_Table,4),Protection_Amount)","v":{"$error":"#N/A"}}]
[]
[null,"LTA% Used by RLG @ Current date",{"$f":"ROUNDDOWN(RL_LSAatQDt/Total_LSA_to_Use,4)","v":{"$error":"#N/A"}}]
[null,"LTA% Used by Other plan @ Current date",{"$f":"ROUNDDOWN(Other_LSAatQDt/Total_LSA_to_Use,4)","v":{"$error":"#N/A"}}]

{"sheet":"TTFAC_Protection","index":7,"n_rows":15,"n_cols":3,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
[]
[]
[null,"Policy holder name"]
[null,"Policy number"]
[null,"Total LSA Used up @ 06/04/2024*  \n(As per TTFAC certificate)"]
[null,"Total LTA % used up @06/04/2024*\n(As per TTFAC certificate)"]
[null,"Has Protection*"]
[null,"Amount if Protected"]
[null,"Total LSA Used up @ 05/04/2024 by this RL plan*"]
[]
[null,"Standard/ Protected LumpSum Allowance to use",{"$f":"IF(OR(TTFAC_IsProtected=\"\",TTFAC_IsProtected=\"No Protection\"),VLOOKUP(2024,LSA_Table,4),Protected_Amount)","v":268275}]
[]
[null,"LTA% Used by This RLG policy @ 05/04/2024",{"$f":"ROUNDDOWN(Total_LSA_at05042024_RL/TTFAC_Total_LSA_to_Use,4)","v":0}]
[null,"LTA% Used by Other plans @ 05/04/2024",{"$f":" MAX((Total_LTApct_at06042024-LTAat05042024RL),0)","v":0}]
[null,"LSA amount Used by Other plans @ 05/04/2024",{"$f":"Total_LSA_at06042024-Total_LSA_at05042024_RL","v":0}]

{"sheet":"Glossary","index":8,"n_rows":8,"n_cols":3,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,{"$f":"\"Term\"","v":"Term"},{"$f":"\"Description\"","v":"Description"}]
[null,"LTA","Lifetime Allowance"]
[null,"SIHLS","Serious Ill Health Lump Sum"]
[null,"RBCE","Relevant Benefit Crystallisation Event"]
[null,"PCLS","Pension Commencement Lump Sum"]
[null,"LSA","Lump Sum Allowance"]
[null,"LSBDA","Lump Sum & Death Benefit Allowance"]

{"sheet":"IntermediateCalcs","index":9,"n_rows":634,"n_cols":31,"rows_kept":634,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Current Age:",{"$f":"DATEDIF(DOB,TodayDate,\"Y\")","v":55},null,null,null,null,null,null,null,"LTA Charge",{"$f":"IF(OR(Uncrystallized <> \"\",Drawdown=\"Drawdown/ Annuity\", Drawdown = \"QROPS\"),25%,55%)","v":0.55000000000000004},null,null,"Is growth?",{"$f":"IF(Input!D18 > (Input!D16-Input!D17), \"Y\",\"N\")","v":"N"},null,null,null,null,{"$f":"SUMIF(S6:S608,MAX(S6:S608),PostA_LTA_prct_Amt)","v":0}]
[null,"Other LTA",{"$f":"ROUNDDOWN(LTA_other_provider+LTA_other_policy,5)","v":0}]
[]
[null,"Pre A-day BCE event","BCE Commencement Date","Type","Crystallization amount requested","GAD Max","LTA Amount","LTA protection","Age at BCE Commencement Date","Tax-Year start date","NMPA @ Tax year","LTA amount @ Tax year","LTA reduction","Calculated LTA amount","%LTA used",null,null,"Post A-day BCE event","BCE Commencement Date","Type","Crystallization amount requested","GAD Max","LTA Amount","LTA protection","Age at BCE Commencement Date","Tax-Year start date","NMPA @ Tax year","LTA amount @ Tax year","LTA reduction?","Calculated LTA Amount","%LTA used"]
[null,1,null,null,null,null,null,null,{"$f":"IF(C6=\"\",\"\",(DATEDIF(DOB,C6,\"Y\")))","v":""},{"$f":"IF(C6=\"\",\"\",IF(MONTH(C6)=4,IF(DAY(C6)>=6,YEAR(C6),YEAR(C6)-1),IF(MONTH(C6)>4,YEAR(C6),YEAR(C6)-1)))","v":""},{"$f":"IFERROR(IF(J6<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J6,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H6=\"Y\",G6,IF(C6=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C6=\"\",\"\",IF(K6>I6,100%-2.5%*DATEDIF(C6,DATE(YEAR(DOB) + K6, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},{"$f":"IF(L6=\"\",\"\",L6*M6)","v":""},{"$f":"IF(C6=\"\",\"\",IF(D6=\"Annuity\",ROUNDDOWN(25*E6/N6,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F6/N6,4),ROUNDDOWN(25*80%*F6/N6,4))))","v":""},null,null,1,null,null,null,null,null,null,{"$f":"IF(S6=\"\",\"\",(DATEDIF(DOB,S6,\"Y\")))","v":""},{"$f":"IF(S6=\"\",\"\",IF(MONTH(S6)=4,IF(DAY(S6)>=6,YEAR(S6),YEAR(S6)-1),IF(MONTH(S6)>4,YEAR(S6),YEAR(S6)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z6,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X6=\"Y\",W6,VLOOKUP(Z6,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S6=\"\",\"\",IF(AA6>Y6,100%-2.5%*DATEDIF(S6,DATE(YEAR(DOB) + AA6, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},{"$f":"IF(AB6=\"\",\"\",AB6*AC6)","v":""},{"$f":"IF(S6=\"\",\"\",ROUNDDOWN(U6/AD6,4))","v":""}]
[null,2,null,null,null,null,null,null,{"$f":"IF(C7=\"\",\"\",(DATEDIF(DOB,C7,\"Y\")))","v":""},{"$f":"IF(C7=\"\",\"\",IF(MONTH(C7)=4,IF(DAY(C7)>=6,YEAR(C7),YEAR(C7)-1),IF(MONTH(C7)>4,YEAR(C7),YEAR(C7)-1)))","v":""},"","","",{"$f":"IF(L7=\"\",\"\",L7*M7)","v":""},{"$f":"IF(C7=\"\",\"\",IF(D7=\"Annuity\",ROUNDDOWN(25*E7/N7,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F7/N7,4),ROUNDDOWN(25*80%*F7/N7,4))))","v":""},null,null,2,null,null,null,null,null,null,{"$f":"IF(S7=\"\",\"\",(DATEDIF(DOB,S7,\"Y\")))","v":""},{"$f":"IF(S7=\"\",\"\",IF(MONTH(S7)=4,IF(DAY(S7)>=6,YEAR(S7),YEAR(S7)-1),IF(MONTH(S7)>4,YEAR(S7),YEAR(S7)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z7,LTA_Table,3),\"\")","v":""},"","",{"$f":"IF(AB7=\"\",\"\",AB7*AC7)","v":""},{"$f":"IF(S7=\"\",\"\",ROUNDDOWN(U7/AD7,4))","v":""}]
[null,3,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C8=\"\",\"\",IF(D8=\"Annuity\",ROUNDDOWN(25*E8/N8,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F8/N8,4),ROUNDDOWN(25*80%*F8/N8,4))))","v":""},null,null,3,null,null,null,null,null,null,"","","","","","",""]
[null,4,null,null,null,null,null,null,"","","","","","","",null,null,4,null,null,null,null,null,null,"","","","","","",""]
[null,5,null,null,null,null,null,null,"","","","","","","",null,null,5,null,null,null,null,null,null,"","","","","","",""]
[null,6,null,null,null,null,null,null,"","","","","","","",null,null,6,null,null,null,null,null,null,"","","","","","",""]
[null,7,null,null,null,null,null,null,"","","","","","","",null,null,7,null,null,null,null,null,null,"","","","","","",""]
[null,8,null,null,null,null,null,null,"","","","","","","",null,null,8,null,null,null,null,null,null,"","","","","","",""]
[null,9,null,null,null,null,null,null,"","","","","","","",null,null,9,null,null,null,null,null,null,"","","","","","",""]
[null,10,null,null,null,null,null,null,"","","","","","","",null,null,10,null,null,null,null,null,null,"","","","","","",""]
[null,11,null,null,null,null,null,null,"","","","","","","",null,null,11,null,null,null,null,null,null,"","","","","","",""]
[null,12,null,null,null,null,null,null,"","","","","","","",null,null,12,null,null,null,null,null,null,"","","","","","",""]
[null,13,null,null,null,null,null,null,"","","","","","","",null,null,13,null,null,null,null,null,null,"","","","","","",""]
[null,14,null,null,null,null,null,null,"","","","","","","",null,null,14,null,null,null,null,null,null,"","","","","","",""]
[null,15,null,null,null,null,null,null,"","","","","","","",null,null,15,null,null,null,null,null,null,"","","","","","",""]
[null,16,null,null,null,null,null,null,"","","","","","","",null,null,16,null,null,null,null,null,null,"","","","","","",""]
[null,17,null,null,null,null,null,null,"","","","","","","",null,null,17,null,null,null,null,null,null,"","","","","","",""]
[null,18,null,null,null,null,null,null,"","","","","","","",null,null,18,null,null,null,null,null,null,"","","","","","",""]
[null,19,null,null,null,null,null,null,"","","","","","","",null,null,19,null,null,null,null,null,null,"","","","","","",""]
[null,20,null,null,null,null,null,null,"","","","","","","",null,null,20,null,null,null,null,null,null,"","","","","","",""]
[null,21,null,null,null,null,null,null,"","","","","","","",null,null,21,null,null,null,null,null,null,"","","","","","",""]
[null,22,null,null,null,null,null,null,"","","","","","","",null,null,22,null,null,null,null,null,null,"","","","","","",""]
[null,23,null,null,null,null,null,null,"","","","","","","",null,null,23,null,null,null,null,null,null,"","","","","","",""]
[null,24,null,null,null,null,null,null,"","","","","","","",null,null,24,null,null,null,null,null,null,"","","","","","",""]
[null,25,null,null,null,null,null,null,"","","","","","","",null,null,25,null,null,null,null,null,null,"","","","","","",""]
[null,26,null,null,null,null,null,null,"","","","","","","",null,null,26,null,null,null,null,null,null,"","","","","","",""]
[null,27,null,null,null,null,null,null,"","","","","","","",null,null,27,null,null,null,null,null,null,"","","","","","",""]
[null,28,null,null,null,null,null,null,"","","","","","","",null,null,28,null,null,null,null,null,null,"","","","","","",""]
[null,29,null,null,null,null,null,null,"","","","","","","",null,null,29,null,null,null,null,null,null,"","","","","","",""]
[null,30,null,null,null,null,null,null,"","","","","","","",null,null,30,null,null,null,null,null,null,"","","","","","",""]
[null,31,null,null,null,null,null,null,"","","","","","","",null,null,31,null,null,null,null,null,null,"","","","","","",""]
[null,32,null,null,null,null,null,null,"","","","","","","",null,null,32,null,null,null,null,null,null,"","","","","","",""]
[null,33,null,null,null,null,null,null,{"$f":"IF(C38=\"\",\"\",(DATEDIF(DOB,C38,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J38<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J38,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H38=\"Y\",G38,IF(C38=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C38=\"\",\"\",IF(K38>I38,100%-2.5%*DATEDIF(C38,DATE(YEAR(DOB) + K38, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,33,null,null,null,null,null,null,{"$f":"IF(S38=\"\",\"\",(DATEDIF(DOB,S38,\"Y\")))","v":""},{"$f":"IF(S38=\"\",\"\",IF(MONTH(S38)=4,IF(DAY(S38)>=6,YEAR(S38),YEAR(S38)-1),IF(MONTH(S38)>4,YEAR(S38),YEAR(S38)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z38,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X38=\"Y\",W38,VLOOKUP(Z38,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S38=\"\",\"\",IF(AA38>Y38,100%-2.5%*DATEDIF(S38,DATE(YEAR(DOB) + AA38, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,34,null,null,null,null,null,null,"","","","","","","",null,null,34,null,null,null,null,null,null,"","","","","","",""]
[null,35,null,null,null,null,null,null,"","","","","","","",null,null,35,null,null,null,null,null,null,"","","","","","",""]
[null,36,null,null,null,null,null,null,"","","","","","","",null,null,36,null,null,null,null,null,null,"","","","","","",""]
[null,37,null,null,null,null,null,null,"","","","","","","",null,null,37,null,null,null,null,null,null,"","","","","","",""]
[null,38,null,null,null,null,null,null,"","","","","","","",null,null,38,null,null,null,null,null,null,"","","","","","",""]
[null,39,null,null,null,null,null,null,"","","","","","","",null,null,39,null,null,null,null,null,null,"","","","","","",""]
[null,40,null,null,null,null,null,null,"","","","","","","",null,null,40,null,null,null,null,null,null,"","","","","","",""]
[null,41,null,null,null,null,null,null,"","","","","","","",null,null,41,null,null,null,null,null,null,"","","","","","",""]
[null,42,null,null,null,null,null,null,"","","","","","","",null,null,42,null,null,null,null,null,null,"","","","","","",""]
[null,43,null,null,null,null,null,null,"","","","","","","",null,null,43,null,null,null,null,null,null,"","","","","","",""]
[null,44,null,null,null,null,null,null,"","","","","","","",null,null,44,null,null,null,null,null,null,"","","","","","",""]
[null,45,null,null,null,null,null,null,"","","","","","","",null,null,45,null,null,null,null,null,null,"","","","","","",""]
[null,46,null,null,null,null,null,null,"","","","","","","",null,null,46,null,null,null,null,null,null,"","","","","","",""]
[null,47,null,null,null,null,null,null,"","","","","","","",null,null,47,null,null,null,null,null,null,"","","","","","",""]
[null,48,null,null,null,null,null,null,"","","","","","","",null,null,48,null,null,null,null,null,null,"","","","","","",""]
[null,49,null,null,null,null,null,null,"",{"$f":"IF(C54=\"\",\"\",IF(MONTH(C54)=4,IF(DAY(C54)>=6,YEAR(C54),YEAR(C54)-1),IF(MONTH(C54)>4,YEAR(C54),YEAR(C54)-1)))","v":""},"","","",{"$f":"IF(L54=\"\",\"\",L54*M54)","v":""},{"$f":"IF(C54=\"\",\"\",IF(D54=\"Annuity\",ROUNDDOWN(25*E54/N54,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F54/N54,4),ROUNDDOWN(25*80%*F54/N54,4))))","v":""},null,null,49,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB54=\"\",\"\",AB54*AC54)","v":""},{"$f":"IF(S54=\"\",\"\",ROUNDDOWN(U54/AD54,4))","v":""}]
[null,50,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C55=\"\",\"\",IF(D55=\"Annuity\",ROUNDDOWN(25*E55/N55,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F55/N55,4),ROUNDDOWN(25*80%*F55/N55,4))))","v":""},null,null,50,null,null,null,null,null,null,"","","","","","",""]
[null,51,null,null,null,null,null,null,"","","","","","","",null,null,51,null,null,null,null,null,null,"","","","","","",""]
[null,52,null,null,null,null,null,null,"","","","","","","",null,null,52,null,null,null,null,null,null,"","","","","","",""]
[null,53,null,null,null,null,null,null,"","","","","","","",null,null,53,null,null,null,null,null,null,"","","","","","",""]
[null,54,null,null,null,null,null,null,"","","","","","","",null,null,54,null,null,null,null,null,null,"","","","","","",""]
[null,55,null,null,null,null,null,null,"","","","","","","",null,null,55,null,null,null,null,null,null,"","","","","","",""]
[null,56,null,null,null,null,null,null,"","","","","","","",null,null,56,null,null,null,null,null,null,"","","","","","",""]
[null,57,null,null,null,null,null,null,"","","","","","","",null,null,57,null,null,null,null,null,null,"","","","","","",""]
[null,58,null,null,null,null,null,null,"","","","","","","",null,null,58,null,null,null,null,null,null,"","","","","","",""]
[null,59,null,null,null,null,null,null,"","","","","","","",null,null,59,null,null,null,null,null,null,"","","","","","",""]
[null,60,null,null,null,null,null,null,"","","","","","","",null,null,60,null,null,null,null,null,null,"","","","","","",""]
[null,61,null,null,null,null,null,null,"","","","","","","",null,null,61,null,null,null,null,null,null,"","","","","","",""]
[null,62,null,null,null,null,null,null,"","","","","","","",null,null,62,null,null,null,null,null,null,"","","","","","",""]
[null,63,null,null,null,null,null,null,"","","","","","","",null,null,63,null,null,null,null,null,null,"","","","","","",""]
[null,64,null,null,null,null,null,null,"","","","","","","",null,null,64,null,null,null,null,null,null,"","","","","","",""]
[null,65,null,null,null,null,null,null,"","","","","","","",null,null,65,null,null,null,null,null,null,"","","","","","",""]
[null,66,null,null,null,null,null,null,"","","","","","","",null,null,66,null,null,null,null,null,null,"","","","","","",""]
[null,67,null,null,null,null,null,null,"","","","","","","",null,null,67,null,null,null,null,null,null,"","","","","","",""]
[null,68,null,null,null,null,null,null,"","","","","","","",null,null,68,null,null,null,null,null,null,"","","","","","",""]
[null,69,null,null,null,null,null,null,"","","","","","","",null,null,69,null,null,null,null,null,null,"","","","","","",""]
[null,70,null,null,null,null,null,null,"","","","","","","",null,null,70,null,null,null,null,null,null,"","","","","","",""]
[null,71,null,null,null,null,null,null,"","","","","","","",null,null,71,null,null,null,null,null,null,"","","","","","",""]
[null,72,null,null,null,null,null,null,"","","","","","","",null,null,72,null,null,null,null,null,null,"","","","","","",""]
[null,73,null,null,null,null,null,null,"","","","","","","",null,null,73,null,null,null,null,null,null,"","","","","","",""]
[null,74,null,null,null,null,null,null,"","","","","","","",null,null,74,null,null,null,null,null,null,"","","","","","",""]
[null,75,null,null,null,null,null,null,"","","","","","","",null,null,75,null,null,null,null,null,null,"","","","","","",""]
[null,76,null,null,null,null,null,null,"","","","","","","",null,null,76,null,null,null,null,null,null,"","","","","","",""]
[null,77,null,null,null,null,null,null,"","","","","","","",null,null,77,null,null,null,null,null,null,"","","","","","",""]
[null,78,null,null,null,null,null,null,"","","","","","","",null,null,78,null,null,null,null,null,null,"","","","","","",""]
[null,79,null,null,null,null,null,null,"","","","","","","",null,null,79,null,null,null,null,null,null,"","","","","","",""]
[null,80,null,null,null,null,null,null,{"$f":"IF(C85=\"\",\"\",(DATEDIF(DOB,C85,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J85<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J85,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H85=\"Y\",G85,IF(C85=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C85=\"\",\"\",IF(K85>I85,100%-2.5%*DATEDIF(C85,DATE(YEAR(DOB) + K85, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,80,null,null,null,null,null,null,{"$f":"IF(S85=\"\",\"\",(DATEDIF(DOB,S85,\"Y\")))","v":""},{"$f":"IF(S85=\"\",\"\",IF(MONTH(S85)=4,IF(DAY(S85)>=6,YEAR(S85),YEAR(S85)-1),IF(MONTH(S85)>4,YEAR(S85),YEAR(S85)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z85,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X85=\"Y\",W85,VLOOKUP(Z85,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S85=\"\",\"\",IF(AA85>Y85,100%-2.5%*DATEDIF(S85,DATE(YEAR(DOB) + AA85, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,81,null,null,null,null,null,null,"","","","","","","",null,null,81,null,null,null,null,null,null,"","","","","","",""]
[null,82,null,null,null,null,null,null,"","","","","","","",null,null,82,null,null,null,null,null,null,"","","","","","",""]
[null,83,null,null,null,null,null,null,"","","","","","","",null,null,83,null,null,null,null,null,null,"","","","","","",""]
[null,84,null,null,null,null,null,null,"","","","","","","",null,null,84,null,null,null,null,null,null,"","","","","","",""]
[null,85,null,null,null,null,null,null,"","","","","","","",null,null,85,null,null,null,null,null,null,"","","","","","",""]
[null,86,null,null,null,null,null,null,"","","","","","","",null,null,86,null,null,null,null,null,null,"","","","","","",""]
[null,87,null,null,null,null,null,null,"","","","","","","",null,null,87,null,null,null,null,null,null,"","","","","","",""]
[null,88,null,null,null,null,null,null,"","","","","","","",null,null,88,null,null,null,null,null,null,"","","","","","",""]
[null,89,null,null,null,null,null,null,"","","","","","","",null,null,89,null,null,null,null,null,null,"","","","","","",""]
[null,90,null,null,null,null,null,null,"","","","","","","",null,null,90,null,null,null,null,null,null,"","","","","","",""]
[null,91,null,null,null,null,null,null,"","","","","","","",null,null,91,null,null,null,null,null,null,"","","","","","",""]
[null,92,null,null,null,null,null,null,"","","","","","","",null,null,92,null,null,null,null,null,null,"","","","","","",""]
[null,93,null,null,null,null,null,null,"","","","","","","",null,null,93,null,null,null,null,null,null,"","","","","","",""]
[null,94,null,null,null,null,null,null,"","","","","","","",null,null,94,null,null,null,null,null,null,"","","","","","",""]
[null,95,null,null,null,null,null,null,"","","","","","","",null,null,95,null,null,null,null,null,null,"","","","","","",""]
[null,96,null,null,null,null,null,null,"",{"$f":"IF(C101=\"\",\"\",IF(MONTH(C101)=4,IF(DAY(C101)>=6,YEAR(C101),YEAR(C101)-1),IF(MONTH(C101)>4,YEAR(C101),YEAR(C101)-1)))","v":""},"","","",{"$f":"IF(L101=\"\",\"\",L101*M101)","v":""},{"$f":"IF(C101=\"\",\"\",IF(D101=\"Annuity\",ROUNDDOWN(25*E101/N101,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F101/N101,4),ROUNDDOWN(25*80%*F101/N101,4))))","v":""},null,null,96,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB101=\"\",\"\",AB101*AC101)","v":""},{"$f":"IF(S101=\"\",\"\",ROUNDDOWN(U101/AD101,4))","v":""}]
[null,97,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C102=\"\",\"\",IF(D102=\"Annuity\",ROUNDDOWN(25*E102/N102,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F102/N102,4),ROUNDDOWN(25*80%*F102/N102,4))))","v":""},null,null,97,null,null,null,null,null,null,"","","","","","",""]
[null,98,null,null,null,null,null,null,"","","","","","","",null,null,98,null,null,null,null,null,null,"","","","","","",""]
[null,99,null,null,null,null,null,null,"","","","","","","",null,null,99,null,null,null,null,null,null,"","","","","","",""]
[null,100,null,null,null,null,null,null,"","","","","","","",null,null,100,null,null,null,null,null,null,"","","","","","",""]
[null,101,null,null,null,null,null,null,"","","","","","","",null,null,101,null,null,null,null,null,null,"","","","","","",""]
[null,102,null,null,null,null,null,null,"","","","","","","",null,null,102,null,null,null,null,null,null,"","","","","","",""]
[null,103,null,null,null,null,null,null,"","","","","","","",null,null,103,null,null,null,null,null,null,"","","","","","",""]
[null,104,null,null,null,null,null,null,"","","","","","","",null,null,104,null,null,null,null,null,null,"","","","","","",""]
[null,105,null,null,null,null,null,null,"","","","","","","",null,null,105,null,null,null,null,null,null,"","","","","","",""]
[null,106,null,null,null,null,null,null,"","","","","","","",null,null,106,null,null,null,null,null,null,"","","","","","",""]
[null,107,null,null,null,null,null,null,"","","","","","","",null,null,107,null,null,null,null,null,null,"","","","","","",""]
[null,108,null,null,null,null,null,null,"","","","","","","",null,null,108,null,null,null,null,null,null,"","","","","","",""]
[null,109,null,null,null,null,null,null,"","","","","","","",null,null,109,null,null,null,null,null,null,"","","","","","",""]
[null,110,null,null,null,null,null,null,"","","","","","","",null,null,110,null,null,null,null,null,null,"","","","","","",""]
[null,111,null,null,null,null,null,null,"","","","","","","",null,null,111,null,null,null,null,null,null,"","","","","","",""]
[null,112,null,null,null,null,null,null,"","","","","","","",null,null,112,null,null,null,null,null,null,"","","","","","",""]
[null,113,null,null,null,null,null,null,"","","","","","","",null,null,113,null,null,null,null,null,null,"","","","","","",""]
[null,114,null,null,null,null,null,null,"","","","","","","",null,null,114,null,null,null,null,null,null,"","","","","","",""]
[null,115,null,null,null,null,null,null,"","","","","","","",null,null,115,null,null,null,null,null,null,"","","","","","",""]
[null,116,null,null,null,null,null,null,"","","","","","","",null,null,116,null,null,null,null,null,null,"","","","","","",""]
[null,117,null,null,null,null,null,null,"","","","","","","",null,null,117,null,null,null,null,null,null,"","","","","","",""]
[null,118,null,null,null,null,null,null,"","","","","","","",null,null,118,null,null,null,null,null,null,"","","","","","",""]
[null,119,null,null,null,null,null,null,"","","","","","","",null,null,119,null,null,null,null,null,null,"","","","","","",""]
[null,120,null,null,null,null,null,null,"","","","","","","",null,null,120,null,null,null,null,null,null,"","","","","","",""]
[null,121,null,null,null,null,null,null,"","","","","","","",null,null,121,null,null,null,null,null,null,"","","","","","",""]
[null,122,null,null,null,null,null,null,"","","","","","","",null,null,122,null,null,null,null,null,null,"","","","","","",""]
[null,123,null,null,null,null,null,null,"","","","","","","",null,null,123,null,null,null,null,null,null,"","","","","","",""]
[null,124,null,null,null,null,null,null,"","","","","","","",null,null,124,null,null,null,null,null,null,"","","","","","",""]
[null,125,null,null,null,null,null,null,"","","","","","","",null,null,125,null,null,null,null,null,null,"","","","","","",""]
[null,126,null,null,null,null,null,null,"","","","","","","",null,null,126,null,null,null,null,null,null,"","","","","","",""]
[null,127,null,null,null,null,null,null,{"$f":"IF(C132=\"\",\"\",(DATEDIF(DOB,C132,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J132<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J132,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H132=\"Y\",G132,IF(C132=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C132=\"\",\"\",IF(K132>I132,100%-2.5%*DATEDIF(C132,DATE(YEAR(DOB) + K132, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,127,null,null,null,null,null,null,{"$f":"IF(S132=\"\",\"\",(DATEDIF(DOB,S132,\"Y\")))","v":""},{"$f":"IF(S132=\"\",\"\",IF(MONTH(S132)=4,IF(DAY(S132)>=6,YEAR(S132),YEAR(S132)-1),IF(MONTH(S132)>4,YEAR(S132),YEAR(S132)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z132,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X132=\"Y\",W132,VLOOKUP(Z132,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S132=\"\",\"\",IF(AA132>Y132,100%-2.5%*DATEDIF(S132,DATE(YEAR(DOB) + AA132, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,128,null,null,null,null,null,null,"","","","","","","",null,null,128,null,null,null,null,null,null,"","","","","","",""]
[null,129,null,null,null,null,null,null,"","","","","","","",null,null,129,null,null,null,null,null,null,"","","","","","",""]
[null,130,null,null,null,null,null,null,"","","","","","","",null,null,130,null,null,null,null,null,null,"","","","","","",""]
[null,131,null,null,null,null,null,null,"","","","","","","",null,null,131,null,null,null,null,null,null,"","","","","","",""]
[null,132,null,null,null,null,null,null,"","","","","","","",null,null,132,null,null,null,null,null,null,"","","","","","",""]
[null,133,null,null,null,null,null,null,"","","","","","","",null,null,133,null,null,null,null,null,null,"","","","","","",""]
[null,134,null,null,null,null,null,null,"","","","","","","",null,null,134,null,null,null,null,null,null,"","","","","","",""]
[null,135,null,null,null,null,null,null,"","","","","","","",null,null,135,null,null,null,null,null,null,"","","","","","",""]
[null,136,null,null,null,null,null,null,"","","","","","","",null,null,136,null,null,null,null,null,null,"","","","","","",""]
[null,137,null,null,null,null,null,null,"","","","","","","",null,null,137,null,null,null,null,null,null,"","","","","","",""]
[null,138,null,null,null,null,null,null,"","","","","","","",null,null,138,null,null,null,null,null,null,"","","","","","",""]
[null,139,null,null,null,null,null,null,"","","","","","","",null,null,139,null,null,null,null,null,null,"","","","","","",""]
[null,140,null,null,null,null,null,null,"","","","","","","",null,null,140,null,null,null,null,null,null,"","","","","","",""]
[null,141,null,null,null,null,null,null,"","","","","","","",null,null,141,null,null,null,null,null,null,"","","","","","",""]
[null,142,null,null,null,null,null,null,"","","","","","","",null,null,142,null,null,null,null,null,null,"","","","","","",""]
[null,143,null,null,null,null,null,null,"",{"$f":"IF(C148=\"\",\"\",IF(MONTH(C148)=4,IF(DAY(C148)>=6,YEAR(C148),YEAR(C148)-1),IF(MONTH(C148)>4,YEAR(C148),YEAR(C148)-1)))","v":""},"","","",{"$f":"IF(L148=\"\",\"\",L148*M148)","v":""},{"$f":"IF(C148=\"\",\"\",IF(D148=\"Annuity\",ROUNDDOWN(25*E148/N148,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F148/N148,4),ROUNDDOWN(25*80%*F148/N148,4))))","v":""},null,null,143,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB148=\"\",\"\",AB148*AC148)","v":""},{"$f":"IF(S148=\"\",\"\",ROUNDDOWN(U148/AD148,4))","v":""}]
[null,144,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C149=\"\",\"\",IF(D149=\"Annuity\",ROUNDDOWN(25*E149/N149,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F149/N149,4),ROUNDDOWN(25*80%*F149/N149,4))))","v":""},null,null,144,null,null,null,null,null,null,"","","","","","",""]
[null,145,null,null,null,null,null,null,"","","","","","","",null,null,145,null,null,null,null,null,null,"","","","","","",""]
[null,146,null,null,null,null,null,null,"","","","","","","",null,null,146,null,null,null,null,null,null,"","","","","","",""]
[null,147,null,null,null,null,null,null,"","","","","","","",null,null,147,null,null,null,null,null,null,"","","","","","",""]
[null,148,null,null,null,null,null,null,"","","","","","","",null,null,148,null,null,null,null,null,null,"","","","","","",""]
[null,149,null,null,null,null,null,null,"","","","","","","",null,null,149,null,null,null,null,null,null,"","","","","","",""]
[null,150,null,null,null,null,null,null,"","","","","","","",null,null,150,null,null,null,null,null,null,"","","","","","",""]
[null,151,null,null,null,null,null,null,"","","","","","","",null,null,151,null,null,null,null,null,null,"","","","","","",""]
[null,152,null,null,null,null,null,null,"","","","","","","",null,null,152,null,null,null,null,null,null,"","","","","","",""]
[null,153,null,null,null,null,null,null,"","","","","","","",null,null,153,null,null,null,null,null,null,"","","","","","",""]
[null,154,null,null,null,null,null,null,"","","","","","","",null,null,154,null,null,null,null,null,null,"","","","","","",""]
[null,155,null,null,null,null,null,null,"","","","","","","",null,null,155,null,null,null,null,null,null,"","","","","","",""]
[null,156,null,null,null,null,null,null,"","","","","","","",null,null,156,null,null,null,null,null,null,"","","","","","",""]
[null,157,null,null,null,null,null,null,"","","","","","","",null,null,157,null,null,null,null,null,null,"","","","","","",""]
[null,158,null,null,null,null,null,null,"","","","","","","",null,null,158,null,null,null,null,null,null,"","","","","","",""]
[null,159,null,null,null,null,null,null,"","","","","","","",null,null,159,null,null,null,null,null,null,"","","","","","",""]
[null,160,null,null,null,null,null,null,"","","","","","","",null,null,160,null,null,null,null,null,null,"","","","","","",""]
[null,161,null,null,null,null,null,null,"","","","","","","",null,null,161,null,null,null,null,null,null,"","","","","","",""]
[null,162,null,null,null,null,null,null,"","","","","","","",null,null,162,null,null,null,null,null,null,"","","","","","",""]
[null,163,null,null,null,null,null,null,"","","","","","","",null,null,163,null,null,null,null,null,null,"","","","","","",""]
[null,164,null,null,null,null,null,null,"","","","","","","",null,null,164,null,null,null,null,null,null,"","","","","","",""]
[null,165,null,null,null,null,null,null,"","","","","","","",null,null,165,null,null,null,null,null,null,"","","","","","",""]
[null,166,null,null,null,null,null,null,"","","","","","","",null,null,166,null,null,null,null,null,null,"","","","","","",""]
[null,167,null,null,null,null,null,null,"","","","","","","",null,null,167,null,null,null,null,null,null,"","","","","","",""]
[null,168,null,null,null,null,null,null,"","","","","","","",null,null,168,null,null,null,null,null,null,"","","","","","",""]
[null,169,null,null,null,null,null,null,"","","","","","","",null,null,169,null,null,null,null,null,null,"","","","","","",""]
[null,170,null,null,null,null,null,null,"","","","","","","",null,null,170,null,null,null,null,null,null,"","","","","","",""]
[null,171,null,null,null,null,null,null,"","","","","","","",null,null,171,null,null,null,null,null,null,"","","","","","",""]
[null,172,null,null,null,null,null,null,"","","","","","","",null,null,172,null,null,null,null,null,null,"","","","","","",""]
[null,173,null,null,null,null,null,null,"","","","","","","",null,null,173,null,null,null,null,null,null,"","","","","","",""]
[null,174,null,null,null,null,null,null,{"$f":"IF(C179=\"\",\"\",(DATEDIF(DOB,C179,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J179<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J179,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H179=\"Y\",G179,IF(C179=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C179=\"\",\"\",IF(K179>I179,100%-2.5%*DATEDIF(C179,DATE(YEAR(DOB) + K179, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,174,null,null,null,null,null,null,{"$f":"IF(S179=\"\",\"\",(DATEDIF(DOB,S179,\"Y\")))","v":""},{"$f":"IF(S179=\"\",\"\",IF(MONTH(S179)=4,IF(DAY(S179)>=6,YEAR(S179),YEAR(S179)-1),IF(MONTH(S179)>4,YEAR(S179),YEAR(S179)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z179,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X179=\"Y\",W179,VLOOKUP(Z179,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S179=\"\",\"\",IF(AA179>Y179,100%-2.5%*DATEDIF(S179,DATE(YEAR(DOB) + AA179, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,175,null,null,null,null,null,null,"","","","","","","",null,null,175,null,null,null,null,null,null,"","","","","","",""]
[null,176,null,null,null,null,null,null,"","","","","","","",null,null,176,null,null,null,null,null,null,"","","","","","",""]
[null,177,null,null,null,null,null,null,"","","","","","","",null,null,177,null,null,null,null,null,null,"","","","","","",""]
[null,178,null,null,null,null,null,null,"","","","","","","",null,null,178,null,null,null,null,null,null,"","","","","","",""]
[null,179,null,null,null,null,null,null,"","","","","","","",null,null,179,null,null,null,null,null,null,"","","","","","",""]
[null,180,null,null,null,null,null,null,"","","","","","","",null,null,180,null,null,null,null,null,null,"","","","","","",""]
[null,181,null,null,null,null,null,null,"","","","","","","",null,null,181,null,null,null,null,null,null,"","","","","","",""]
[null,182,null,null,null,null,null,null,"","","","","","","",null,null,182,null,null,null,null,null,null,"","","","","","",""]
[null,183,null,null,null,null,null,null,"","","","","","","",null,null,183,null,null,null,null,null,null,"","","","","","",""]
[null,184,null,null,null,null,null,null,"","","","","","","",null,null,184,null,null,null,null,null,null,"","","","","","",""]
[null,185,null,null,null,null,null,null,"","","","","","","",null,null,185,null,null,null,null,null,null,"","","","","","",""]
[null,186,null,null,null,null,null,null,"","","","","","","",null,null,186,null,null,null,null,null,null,"","","","","","",""]
[null,187,null,null,null,null,null,null,"","","","","","","",null,null,187,null,null,null,null,null,null,"","","","","","",""]
[null,188,null,null,null,null,null,null,"","","","","","","",null,null,188,null,null,null,null,null,null,"","","","","","",""]
[null,189,null,null,null,null,null,null,"","","","","","","",null,null,189,null,null,null,null,null,null,"","","","","","",""]
[null,190,null,null,null,null,null,null,"",{"$f":"IF(C195=\"\",\"\",IF(MONTH(C195)=4,IF(DAY(C195)>=6,YEAR(C195),YEAR(C195)-1),IF(MONTH(C195)>4,YEAR(C195),YEAR(C195)-1)))","v":""},"","","",{"$f":"IF(L195=\"\",\"\",L195*M195)","v":""},{"$f":"IF(C195=\"\",\"\",IF(D195=\"Annuity\",ROUNDDOWN(25*E195/N195,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F195/N195,4),ROUNDDOWN(25*80%*F195/N195,4))))","v":""},null,null,190,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB195=\"\",\"\",AB195*AC195)","v":""},{"$f":"IF(S195=\"\",\"\",ROUNDDOWN(U195/AD195,4))","v":""}]
[null,191,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C196=\"\",\"\",IF(D196=\"Annuity\",ROUNDDOWN(25*E196/N196,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F196/N196,4),ROUNDDOWN(25*80%*F196/N196,4))))","v":""},null,null,191,null,null,null,null,null,null,"","","","","","",""]
[null,192,null,null,null,null,null,null,"","","","","","","",null,null,192,null,null,null,null,null,null,"","","","","","",""]
[null,193,null,null,null,null,null,null,"","","","","","","",null,null,193,null,null,null,null,null,null,"","","","","","",""]
[null,194,null,null,null,null,null,null,"","","","","","","",null,null,194,null,null,null,null,null,null,"","","","","","",""]
[null,195,null,null,null,null,null,null,"","","","","","","",null,null,195,null,null,null,null,null,null,"","","","","","",""]
[null,196,null,null,null,null,null,null,"","","","","","","",null,null,196,null,null,null,null,null,null,"","","","","","",""]
[null,197,null,null,null,null,null,null,"","","","","","","",null,null,197,null,null,null,null,null,null,"","","","","","",""]
[null,198,null,null,null,null,null,null,"","","","","","","",null,null,198,null,null,null,null,null,null,"","","","","","",""]
[null,199,null,null,null,null,null,null,"","","","","","","",null,null,199,null,null,null,null,null,null,"","","","","","",""]
[null,200,null,null,null,null,null,null,"","","","","","","",null,null,200,null,null,null,null,null,null,"","","","","","",""]
[null,201,null,null,null,null,null,null,"","","","","","","",null,null,201,null,null,null,null,null,null,"","","","","","",""]
[null,202,null,null,null,null,null,null,"","","","","","","",null,null,202,null,null,null,null,null,null,"","","","","","",""]
[null,203,null,null,null,null,null,null,"","","","","","","",null,null,203,null,null,null,null,null,null,"","","","","","",""]
[null,204,null,null,null,null,null,null,"","","","","","","",null,null,204,null,null,null,null,null,null,"","","","","","",""]
[null,205,null,null,null,null,null,null,"","","","","","","",null,null,205,null,null,null,null,null,null,"","","","","","",""]
[null,206,null,null,null,null,null,null,"","","","","","","",null,null,206,null,null,null,null,null,null,"","","","","","",""]
[null,207,null,null,null,null,null,null,"","","","","","","",null,null,207,null,null,null,null,null,null,"","","","","","",""]
[null,208,null,null,null,null,null,null,"","","","","","","",null,null,208,null,null,null,null,null,null,"","","","","","",""]
[null,209,null,null,null,null,null,null,"","","","","","","",null,null,209,null,null,null,null,null,null,"","","","","","",""]
[null,210,null,null,null,null,null,null,"","","","","","","",null,null,210,null,null,null,null,null,null,"","","","","","",""]
[null,211,null,null,null,null,null,null,"","","","","","","",null,null,211,null,null,null,null,null,null,"","","","","","",""]
[null,212,null,null,null,null,null,null,"","","","","","","",null,null,212,null,null,null,null,null,null,"","","","","","",""]
[null,213,null,null,null,null,null,null,"","","","","","","",null,null,213,null,null,null,null,null,null,"","","","","","",""]
[null,214,null,null,null,null,null,null,"","","","","","","",null,null,214,null,null,null,null,null,null,"","","","","","",""]
[null,215,null,null,null,null,null,null,"","","","","","","",null,null,215,null,null,null,null,null,null,"","","","","","",""]
[null,216,null,null,null,null,null,null,"","","","","","","",null,null,216,null,null,null,null,null,null,"","","","","","",""]
[null,217,null,null,null,null,null,null,"","","","","","","",null,null,217,null,null,null,null,null,null,"","","","","","",""]
[null,218,null,null,null,null,null,null,"","","","","","","",null,null,218,null,null,null,null,null,null,"","","","","","",""]
[null,219,null,null,null,null,null,null,"","","","","","","",null,null,219,null,null,null,null,null,null,"","","","","","",""]
[null,220,null,null,null,null,null,null,"","","","","","","",null,null,220,null,null,null,null,null,null,"","","","","","",""]
[null,221,null,null,null,null,null,null,{"$f":"IF(C226=\"\",\"\",(DATEDIF(DOB,C226,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J226<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J226,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H226=\"Y\",G226,IF(C226=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C226=\"\",\"\",IF(K226>I226,100%-2.5%*DATEDIF(C226,DATE(YEAR(DOB) + K226, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,221,null,null,null,null,null,null,{"$f":"IF(S226=\"\",\"\",(DATEDIF(DOB,S226,\"Y\")))","v":""},{"$f":"IF(S226=\"\",\"\",IF(MONTH(S226)=4,IF(DAY(S226)>=6,YEAR(S226),YEAR(S226)-1),IF(MONTH(S226)>4,YEAR(S226),YEAR(S226)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z226,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X226=\"Y\",W226,VLOOKUP(Z226,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S226=\"\",\"\",IF(AA226>Y226,100%-2.5%*DATEDIF(S226,DATE(YEAR(DOB) + AA226, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,222,null,null,null,null,null,null,"","","","","","","",null,null,222,null,null,null,null,null,null,"","","","","","",""]
[null,223,null,null,null,null,null,null,"","","","","","","",null,null,223,null,null,null,null,null,null,"","","","","","",""]
[null,224,null,null,null,null,null,null,"","","","","","","",null,null,224,null,null,null,null,null,null,"","","","","","",""]
[null,225,null,null,null,null,null,null,"","","","","","","",null,null,225,null,null,null,null,null,null,"","","","","","",""]
[null,226,null,null,null,null,null,null,"","","","","","","",null,null,226,null,null,null,null,null,null,"","","","","","",""]
[null,227,null,null,null,null,null,null,"","","","","","","",null,null,227,null,null,null,null,null,null,"","","","","","",""]
[null,228,null,null,null,null,null,null,"","","","","","","",null,null,228,null,null,null,null,null,null,"","","","","","",""]
[null,229,null,null,null,null,null,null,"","","","","","","",null,null,229,null,null,null,null,null,null,"","","","","","",""]
[null,230,null,null,null,null,null,null,"","","","","","","",null,null,230,null,null,null,null,null,null,"","","","","","",""]
[null,231,null,null,null,null,null,null,"","","","","","","",null,null,231,null,null,null,null,null,null,"","","","","","",""]
[null,232,null,null,null,null,null,null,"","","","","","","",null,null,232,null,null,null,null,null,null,"","","","","","",""]
[null,233,null,null,null,null,null,null,"","","","","","","",null,null,233,null,null,null,null,null,null,"","","","","","",""]
[null,234,null,null,null,null,null,null,"","","","","","","",null,null,234,null,null,null,null,null,null,"","","","","","",""]
[null,235,null,null,null,null,null,null,"","","","","","","",null,null,235,null,null,null,null,null,null,"","","","","","",""]
[null,236,null,null,null,null,null,null,"","","","","","","",null,null,236,null,null,null,null,null,null,"","","","","","",""]
[null,237,null,null,null,null,null,null,"",{"$f":"IF(C242=\"\",\"\",IF(MONTH(C242)=4,IF(DAY(C242)>=6,YEAR(C242),YEAR(C242)-1),IF(MONTH(C242)>4,YEAR(C242),YEAR(C242)-1)))","v":""},"","","",{"$f":"IF(L242=\"\",\"\",L242*M242)","v":""},{"$f":"IF(C242=\"\",\"\",IF(D242=\"Annuity\",ROUNDDOWN(25*E242/N242,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F242/N242,4),ROUNDDOWN(25*80%*F242/N242,4))))","v":""},null,null,237,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB242=\"\",\"\",AB242*AC242)","v":""},{"$f":"IF(S242=\"\",\"\",ROUNDDOWN(U242/AD242,4))","v":""}]
[null,238,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C243=\"\",\"\",IF(D243=\"Annuity\",ROUNDDOWN(25*E243/N243,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F243/N243,4),ROUNDDOWN(25*80%*F243/N243,4))))","v":""},null,null,238,null,null,null,null,null,null,"","","","","","",""]
[null,239,null,null,null,null,null,null,"","","","","","","",null,null,239,null,null,null,null,null,null,"","","","","","",""]
[null,240,null,null,null,null,null,null,"","","","","","","",null,null,240,null,null,null,null,null,null,"","","","","","",""]
[null,241,null,null,null,null,null,null,"","","","","","","",null,null,241,null,null,null,null,null,null,"","","","","","",""]
[null,242,null,null,null,null,null,null,"","","","","","","",null,null,242,null,null,null,null,null,null,"","","","","","",""]
[null,243,null,null,null,null,null,null,"","","","","","","",null,null,243,null,null,null,null,null,null,"","","","","","",""]
[null,244,null,null,null,null,null,null,"","","","","","","",null,null,244,null,null,null,null,null,null,"","","","","","",""]
[null,245,null,null,null,null,null,null,"","","","","","","",null,null,245,null,null,null,null,null,null,"","","","","","",""]
[null,246,null,null,null,null,null,null,"","","","","","","",null,null,246,null,null,null,null,null,null,"","","","","","",""]
[null,247,null,null,null,null,null,null,"","","","","","","",null,null,247,null,null,null,null,null,null,"","","","","","",""]
[null,248,null,null,null,null,null,null,"","","","","","","",null,null,248,null,null,null,null,null,null,"","","","","","",""]
[null,249,null,null,null,null,null,null,"","","","","","","",null,null,249,null,null,null,null,null,null,"","","","","","",""]
[null,250,null,null,null,null,null,null,"","","","","","","",null,null,250,null,null,null,null,null,null,"","","","","","",""]
[null,251,null,null,null,null,null,null,"","","","","","","",null,null,251,null,null,null,null,null,null,"","","","","","",""]
[null,252,null,null,null,null,null,null,"","","","","","","",null,null,252,null,null,null,null,null,null,"","","","","","",""]
[null,253,null,null,null,null,null,null,"","","","","","","",null,null,253,null,null,null,null,null,null,"","","","","","",""]
[null,254,null,null,null,null,null,null,"","","","","","","",null,null,254,null,null,null,null,null,null,"","","","","","",""]
[null,255,null,null,null,null,null,null,"","","","","","","",null,null,255,null,null,null,null,null,null,"","","","","","",""]
[null,256,null,null,null,null,null,null,"","","","","","","",null,null,256,null,null,null,null,null,null,"","","","","","",""]
[null,257,null,null,null,null,null,null,"","","","","","","",null,null,257,null,null,null,null,null,null,"","","","","","",""]
[null,258,null,null,null,null,null,null,"","","","","","","",null,null,258,null,null,null,null,null,null,"","","","","","",""]
[null,259,null,null,null,null,null,null,"","","","","","","",null,null,259,null,null,null,null,null,null,"","","","","","",""]
[null,260,null,null,null,null,null,null,"","","","","","","",null,null,260,null,null,null,null,null,null,"","","","","","",""]
[null,261,null,null,null,null,null,null,"","","","","","","",null,null,261,null,null,null,null,null,null,"","","","","","",""]
[null,262,null,null,null,null,null,null,"","","","","","","",null,null,262,null,null,null,null,null,null,"","","","","","",""]
[null,263,null,null,null,null,null,null,"","","","","","","",null,null,263,null,null,null,null,null,null,"","","","","","",""]
[null,264,null,null,null,null,null,null,"","","","","","","",null,null,264,null,null,null,null,null,null,"","","","","","",""]
[null,265,null,null,null,null,null,null,"","","","","","","",null,null,265,null,null,null,null,null,null,"","","","","","",""]
[null,266,null,null,null,null,null,null,"","","","","","","",null,null,266,null,null,null,null,null,null,"","","","","","",""]
[null,267,null,null,null,null,null,null,"","","","","","","",null,null,267,null,null,null,null,null,null,"","","","","","",""]
[null,268,null,null,null,null,null,null,{"$f":"IF(C273=\"\",\"\",(DATEDIF(DOB,C273,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J273<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J273,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H273=\"Y\",G273,IF(C273=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C273=\"\",\"\",IF(K273>I273,100%-2.5%*DATEDIF(C273,DATE(YEAR(DOB) + K273, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,268,null,null,null,null,null,null,{"$f":"IF(S273=\"\",\"\",(DATEDIF(DOB,S273,\"Y\")))","v":""},{"$f":"IF(S273=\"\",\"\",IF(MONTH(S273)=4,IF(DAY(S273)>=6,YEAR(S273),YEAR(S273)-1),IF(MONTH(S273)>4,YEAR(S273),YEAR(S273)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z273,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X273=\"Y\",W273,VLOOKUP(Z273,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S273=\"\",\"\",IF(AA273>Y273,100%-2.5%*DATEDIF(S273,DATE(YEAR(DOB) + AA273, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,269,null,null,null,null,null,null,"","","","","","","",null,null,269,null,null,null,null,null,null,"","","","","","",""]
[null,270,null,null,null,null,null,null,"","","","","","","",null,null,270,null,null,null,null,null,null,"","","","","","",""]
[null,271,null,null,null,null,null,null,"","","","","","","",null,null,271,null,null,null,null,null,null,"","","","","","",""]
[null,272,null,null,null,null,null,null,"","","","","","","",null,null,272,null,null,null,null,null,null,"","","","","","",""]
[null,273,null,null,null,null,null,null,"","","","","","","",null,null,273,null,null,null,null,null,null,"","","","","","",""]
[null,274,null,null,null,null,null,null,"","","","","","","",null,null,274,null,null,null,null,null,null,"","","","","","",""]
[null,275,null,null,null,null,null,null,"","","","","","","",null,null,275,null,null,null,null,null,null,"","","","","","",""]
[null,276,null,null,null,null,null,null,"","","","","","","",null,null,276,null,null,null,null,null,null,"","","","","","",""]
[null,277,null,null,null,null,null,null,"","","","","","","",null,null,277,null,null,null,null,null,null,"","","","","","",""]
[null,278,null,null,null,null,null,null,"","","","","","","",null,null,278,null,null,null,null,null,null,"","","","","","",""]
[null,279,null,null,null,null,null,null,"","","","","","","",null,null,279,null,null,null,null,null,null,"","","","","","",""]
[null,280,null,null,null,null,null,null,"","","","","","","",null,null,280,null,null,null,null,null,null,"","","","","","",""]
[null,281,null,null,null,null,null,null,"","","","","","","",null,null,281,null,null,null,null,null,null,"","","","","","",""]
[null,282,null,null,null,null,null,null,"","","","","","","",null,null,282,null,null,null,null,null,null,"","","","","","",""]
[null,283,null,null,null,null,null,null,"","","","","","","",null,null,283,null,null,null,null,null,null,"","","","","","",""]
[null,284,null,null,null,null,null,null,"",{"$f":"IF(C289=\"\",\"\",IF(MONTH(C289)=4,IF(DAY(C289)>=6,YEAR(C289),YEAR(C289)-1),IF(MONTH(C289)>4,YEAR(C289),YEAR(C289)-1)))","v":""},"","","",{"$f":"IF(L289=\"\",\"\",L289*M289)","v":""},{"$f":"IF(C289=\"\",\"\",IF(D289=\"Annuity\",ROUNDDOWN(25*E289/N289,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F289/N289,4),ROUNDDOWN(25*80%*F289/N289,4))))","v":""},null,null,284,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB289=\"\",\"\",AB289*AC289)","v":""},{"$f":"IF(S289=\"\",\"\",ROUNDDOWN(U289/AD289,4))","v":""}]
[null,285,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C290=\"\",\"\",IF(D290=\"Annuity\",ROUNDDOWN(25*E290/N290,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F290/N290,4),ROUNDDOWN(25*80%*F290/N290,4))))","v":""},null,null,285,null,null,null,null,null,null,"","","","","","",""]
[null,286,null,null,null,null,null,null,"","","","","","","",null,null,286,null,null,null,null,null,null,"","","","","","",""]
[null,287,null,null,null,null,null,null,"","","","","","","",null,null,287,null,null,null,null,null,null,"","","","","","",""]
[null,288,null,null,null,null,null,null,"","","","","","","",null,null,288,null,null,null,null,null,null,"","","","","","",""]
[null,289,null,null,null,null,null,null,"","","","","","","",null,null,289,null,null,null,null,null,null,"","","","","","",""]
[null,290,null,null,null,null,null,null,"","","","","","","",null,null,290,null,null,null,null,null,null,"","","","","","",""]
[null,291,null,null,null,null,null,null,"","","","","","","",null,null,291,null,null,null,null,null,null,"","","","","","",""]
[null,292,null,null,null,null,null,null,"","","","","","","",null,null,292,null,null,null,null,null,null,"","","","","","",""]
[null,293,null,null,null,null,null,null,"","","","","","","",null,null,293,null,null,null,null,null,null,"","","","","","",""]
[null,294,null,null,null,null,null,null,"","","","","","","",null,null,294,null,null,null,null,null,null,"","","","","","",""]
[null,295,null,null,null,null,null,null,"","","","","","","",null,null,295,null,null,null,null,null,null,"","","","","","",""]
[null,296,null,null,null,null,null,null,"","","","","","","",null,null,296,null,null,null,null,null,null,"","","","","","",""]
[null,297,null,null,null,null,null,null,"","","","","","","",null,null,297,null,null,null,null,null,null,"","","","","","",""]
[null,298,null,null,null,null,null,null,"","","","","","","",null,null,298,null,null,null,null,null,null,"","","","","","",""]
[null,299,null,null,null,null,null,null,"","","","","","","",null,null,299,null,null,null,null,null,null,"","","","","","",""]
[null,300,null,null,null,null,null,null,"","","","","","","",null,null,300,null,null,null,null,null,null,"","","","","","",""]
[null,301,null,null,null,null,null,null,"","","","","","","",null,null,301,null,null,null,null,null,null,"","","","","","",""]
[null,302,null,null,null,null,null,null,"","","","","","","",null,null,302,null,null,null,null,null,null,"","","","","","",""]
[null,303,null,null,null,null,null,null,"","","","","","","",null,null,303,null,null,null,null,null,null,"","","","","","",""]
[null,304,null,null,null,null,null,null,"","","","","","","",null,null,304,null,null,null,null,null,null,"","","","","","",""]
[null,305,null,null,null,null,null,null,"","","","","","","",null,null,305,null,null,null,null,null,null,"","","","","","",""]
[null,306,null,null,null,null,null,null,"","","","","","","",null,null,306,null,null,null,null,null,null,"","","","","","",""]
[null,307,null,null,null,null,null,null,"","","","","","","",null,null,307,null,null,null,null,null,null,"","","","","","",""]
[null,308,null,null,null,null,null,null,"","","","","","","",null,null,308,null,null,null,null,null,null,"","","","","","",""]
[null,309,null,null,null,null,null,null,"","","","","","","",null,null,309,null,null,null,null,null,null,"","","","","","",""]
[null,310,null,null,null,null,null,null,"","","","","","","",null,null,310,null,null,null,null,null,null,"","","","","","",""]
[null,311,null,null,null,null,null,null,"","","","","","","",null,null,311,null,null,null,null,null,null,"","","","","","",""]
[null,312,null,null,null,null,null,null,"","","","","","","",null,null,312,null,null,null,null,null,null,"","","","","","",""]
[null,313,null,null,null,null,null,null,"","","","","","","",null,null,313,null,null,null,null,null,null,"","","","","","",""]
[null,314,null,null,null,null,null,null,"","","","","","","",null,null,314,null,null,null,null,null,null,"","","","","","",""]
[null,315,null,null,null,null,null,null,{"$f":"IF(C320=\"\",\"\",(DATEDIF(DOB,C320,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J320<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J320,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H320=\"Y\",G320,IF(C320=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C320=\"\",\"\",IF(K320>I320,100%-2.5%*DATEDIF(C320,DATE(YEAR(DOB) + K320, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"","",null,null,315,null,null,null,null,null,null,{"$f":"IF(S320=\"\",\"\",(DATEDIF(DOB,S320,\"Y\")))","v":""},{"$f":"IF(S320=\"\",\"\",IF(MONTH(S320)=4,IF(DAY(S320)>=6,YEAR(S320),YEAR(S320)-1),IF(MONTH(S320)>4,YEAR(S320),YEAR(S320)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z320,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X320=\"Y\",W320,VLOOKUP(Z320,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S320=\"\",\"\",IF(AA320>Y320,100%-2.5%*DATEDIF(S320,DATE(YEAR(DOB) + AA320, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,316,null,null,null,null,null,null,"","","","","","","",null,null,316,null,null,null,null,null,null,"","","","","","",""]
[null,317,null,null,null,null,null,null,"","","","","","","",null,null,317,null,null,null,null,null,null,"","","","","","",""]
[null,318,null,null,null,null,null,null,"","","","","","","",null,null,318,null,null,null,null,null,null,"","","","","","",""]
[null,319,null,null,null,null,null,null,"","","","","","","",null,null,319,null,null,null,null,null,null,"","","","","","",""]
[null,320,null,null,null,null,null,null,"","","","","","","",null,null,320,null,null,null,null,null,null,"","","","","","",""]
[null,321,null,null,null,null,null,null,"","","","","","","",null,null,321,null,null,null,null,null,null,"","","","","","",""]
[null,322,null,null,null,null,null,null,"","","","","","","",null,null,322,null,null,null,null,null,null,"","","","","","",""]
[null,323,null,null,null,null,null,null,"","","","","","","",null,null,323,null,null,null,null,null,null,"","","","","","",""]
[null,324,null,null,null,null,null,null,"","","","","","","",null,null,324,null,null,null,null,null,null,"","","","","","",""]
[null,325,null,null,null,null,null,null,"","","","","","","",null,null,325,null,null,null,null,null,null,"","","","","","",""]
[null,326,null,null,null,null,null,null,"","","","","","","",null,null,326,null,null,null,null,null,null,"","","","","","",""]
[null,327,null,null,null,null,null,null,"","","","","","","",null,null,327,null,null,null,null,null,null,"","","","","","",""]
[null,328,null,null,null,null,null,null,"","","","","","","",null,null,328,null,null,null,null,null,null,"","","","","","",""]
[null,329,null,null,null,null,null,null,"","","","","","","",null,null,329,null,null,null,null,null,null,"","","","","","",""]
[null,330,null,null,null,null,null,null,"","","","","","","",null,null,330,null,null,null,null,null,null,"","","","","","",""]
[null,331,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C336=\"\",\"\",IF(D336=\"Annuity\",ROUNDDOWN(25*E336/N336,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F336/N336,4),ROUNDDOWN(25*80%*F336/N336,4))))","v":""},null,null,331,null,null,null,null,null,null,"","","","","","",""]
[null,332,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C337=\"\",\"\",IF(D337=\"Annuity\",ROUNDDOWN(25*E337/N337,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F337/N337,4),ROUNDDOWN(25*80%*F337/N337,4))))","v":""},null,null,332,null,null,null,null,null,null,"","","","","","",""]
[null,333,null,null,null,null,null,null,"","","","","","","",null,null,333,null,null,null,null,null,null,"","","","","","",""]
[null,334,null,null,null,null,null,null,"","","","","","","",null,null,334,null,null,null,null,null,null,"","","","","","",""]
[null,335,null,null,null,null,null,null,"","","","","","","",null,null,335,null,null,null,null,null,null,"","","","","","",""]
[null,336,null,null,null,null,null,null,"","","","","","","",null,null,336,null,null,null,null,null,null,"","","","","","",""]
[null,337,null,null,null,null,null,null,"","","","","","","",null,null,337,null,null,null,null,null,null,"","","","","","",""]
[null,338,null,null,null,null,null,null,"","","","","","","",null,null,338,null,null,null,null,null,null,"","","","","","",""]
[null,339,null,null,null,null,null,null,"","","","","","","",null,null,339,null,null,null,null,null,null,"","","","","","",""]
[null,340,null,null,null,null,null,null,"","","","","","","",null,null,340,null,null,null,null,null,null,"","","","","","",""]
[null,341,null,null,null,null,null,null,"","","","","","","",null,null,341,null,null,null,null,null,null,"","","","","","",""]
[null,342,null,null,null,null,null,null,"","","","","","","",null,null,342,null,null,null,null,null,null,"","","","","","",""]
[null,343,null,null,null,null,null,null,"","","","","","","",null,null,343,null,null,null,null,null,null,"","","","","","",""]
[null,344,null,null,null,null,null,null,"","","","","","","",null,null,344,null,null,null,null,null,null,"","","","","","",""]
[null,345,null,null,null,null,null,null,"","","","","","","",null,null,345,null,null,null,null,null,null,"","","","","","",""]
[null,346,null,null,null,null,null,null,"","","","","","","",null,null,346,null,null,null,null,null,null,"","","","","","",""]
[null,347,null,null,null,null,null,null,"","","","","","","",null,null,347,null,null,null,null,null,null,"","","","","","",""]
[null,348,null,null,null,null,null,null,"",{"$f":"IF(C353=\"\",\"\",IF(MONTH(C353)=4,IF(DAY(C353)>=6,YEAR(C353),YEAR(C353)-1),IF(MONTH(C353)>4,YEAR(C353),YEAR(C353)-1)))","v":""},"","","",{"$f":"IF(L353=\"\",\"\",L353*M353)","v":""},"",null,null,348,null,null,null,null,null,null,"","","","","",{"$f":"IF(AB353=\"\",\"\",AB353*AC353)","v":""},{"$f":"IF(S353=\"\",\"\",ROUNDDOWN(U353/AD353,4))","v":""}]
[null,349,null,null,null,null,null,null,"","","","","","","",null,null,349,null,null,null,null,null,null,"","","","","","",""]
[null,350,null,null,null,null,null,null,"","","","","","","",null,null,350,null,null,null,null,null,null,"","","","","","",""]
[null,351,null,null,null,null,null,null,"","","","","","","",null,null,351,null,null,null,null,null,null,"","","","","","",""]
[null,352,null,null,null,null,null,null,"","","","","","","",null,null,352,null,null,null,null,null,null,"","","","","","",""]
[null,353,null,null,null,null,null,null,"","","","","","","",null,null,353,null,null,null,null,null,null,"","","","","","",""]
[null,354,null,null,null,null,null,null,"","","","","","","",null,null,354,null,null,null,null,null,null,"","","","","","",""]
[null,355,null,null,null,null,null,null,"","","","","","","",null,null,355,null,null,null,null,null,null,"","","","","","",""]
[null,356,null,null,null,null,null,null,"","","","","","","",null,null,356,null,null,null,null,null,null,"","","","","","",""]
[null,357,null,null,null,null,null,null,"","","","","","","",null,null,357,null,null,null,null,null,null,"","","","","","",""]
[null,358,null,null,null,null,null,null,"","","","","","","",null,null,358,null,null,null,null,null,null,"","","","","","",""]
[null,359,null,null,null,null,null,null,"","","","","","","",null,null,359,null,null,null,null,null,null,"","","","","","",""]
[null,360,null,null,null,null,null,null,"","","","","","","",null,null,360,null,null,null,null,null,null,"","","","","","",""]
[null,361,null,null,null,null,null,null,"","","","","","","",null,null,361,null,null,null,null,null,null,"","","","","","",""]
[null,362,null,null,null,null,null,null,"","","","","","","",null,null,362,null,null,null,null,null,null,"","","","","","",""]
[null,363,null,null,null,null,null,null,"","","","","","","",null,null,363,null,null,null,null,null,null,"","","","","","",""]
[null,364,null,null,null,null,null,null,"","","","","","","",null,null,364,null,null,null,null,null,null,"","","","","","",""]
[null,365,null,null,null,null,null,null,"","","","","","","",null,null,365,null,null,null,null,null,null,"","","","","","",""]
[null,366,null,null,null,null,null,null,"","","","","","","",null,null,366,null,null,null,null,null,null,"","","","","","",""]
[null,367,null,null,null,null,null,null,"","","","","","","",null,null,367,null,null,null,null,null,null,"","","","","","",""]
[null,368,null,null,null,null,null,null,"","","","","","","",null,null,368,null,null,null,null,null,null,"","","","","","",""]
[null,369,null,null,null,null,null,null,"","","","","","","",null,null,369,null,null,null,null,null,null,"","","","","","",""]
[null,370,null,null,null,null,null,null,"","","","","","","",null,null,370,null,null,null,null,null,null,"","","","","","",""]
[null,371,null,null,null,null,null,null,"","","","","","","",null,null,371,null,null,null,null,null,null,"","","","","","",""]
[null,372,null,null,null,null,null,null,"","","","","","","",null,null,372,null,null,null,null,null,null,"","","","","","",""]
[null,373,null,null,null,null,null,null,"","","","","","","",null,null,373,null,null,null,null,null,null,"","","","","","",""]
[null,374,null,null,null,null,null,null,"","","","","","","",null,null,374,null,null,null,null,null,null,"","","","","","",""]
[null,375,null,null,null,null,null,null,"","","","","","","",null,null,375,null,null,null,null,null,null,"","","","","","",""]
[null,376,null,null,null,null,null,null,"","","","","","","",null,null,376,null,null,null,null,null,null,"","","","","","",""]
[null,377,null,null,null,null,null,null,"","","","","","","",null,null,377,null,null,null,null,null,null,"","","","","","",""]
[null,378,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C383=\"\",\"\",IF(D383=\"Annuity\",ROUNDDOWN(25*E383/N383,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F383/N383,4),ROUNDDOWN(25*80%*F383/N383,4))))","v":""},null,null,378,null,null,null,null,null,null,"","","","","","",""]
[null,379,null,null,null,null,null,null,{"$f":"IF(C384=\"\",\"\",(DATEDIF(DOB,C384,\"Y\")))","v":""},"",{"$f":"IFERROR(IF(J384<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J384,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H384=\"Y\",G384,IF(C384=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C384=\"\",\"\",IF(K384>I384,100%-2.5%*DATEDIF(C384,DATE(YEAR(DOB) + K384, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",{"$f":"IF(C384=\"\",\"\",IF(D384=\"Annuity\",ROUNDDOWN(25*E384/N384,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F384/N384,4),ROUNDDOWN(25*80%*F384/N384,4))))","v":""},null,null,379,null,null,null,null,null,null,{"$f":"IF(S384=\"\",\"\",(DATEDIF(DOB,S384,\"Y\")))","v":""},{"$f":"IF(S384=\"\",\"\",IF(MONTH(S384)=4,IF(DAY(S384)>=6,YEAR(S384),YEAR(S384)-1),IF(MONTH(S384)>4,YEAR(S384),YEAR(S384)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z384,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X384=\"Y\",W384,VLOOKUP(Z384,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S384=\"\",\"\",IF(AA384>Y384,100%-2.5%*DATEDIF(S384,DATE(YEAR(DOB) + AA384, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},"",""]
[null,380,null,null,null,null,null,null,"","","","","","","",null,null,380,null,null,null,null,null,null,"","","","","","",""]
[null,381,null,null,null,null,null,null,"","","","","","","",null,null,381,null,null,null,null,null,null,"","","","","","",""]
[null,382,null,null,null,null,null,null,"","","","","","","",null,null,382,null,null,null,null,null,null,"","","","","","",""]
[null,383,null,null,null,null,null,null,"","","","","","","",null,null,383,null,null,null,null,null,null,"","","","","","",""]
[null,384,null,null,null,null,null,null,"","","","","","","",null,null,384,null,null,null,null,null,null,"","","","","","",""]
[null,385,null,null,null,null,null,null,"","","","","","","",null,null,385,null,null,null,null,null,null,"","","","","","",""]
[null,386,null,null,null,null,null,null,"","","","","","","",null,null,386,null,null,null,null,null,null,"","","","","","",""]
[null,387,null,null,null,null,null,null,"","","","","","","",null,null,387,null,null,null,null,null,null,"","","","","","",""]
[null,388,null,null,null,null,null,null,"","","","","","","",null,null,388,null,null,null,null,null,null,"","","","","","",""]
[null,389,null,null,null,null,null,null,"","","","","","","",null,null,389,null,null,null,null,null,null,"","","","","","",""]
[null,390,null,null,null,null,null,null,"","","","","","","",null,null,390,null,null,null,null,null,null,"","","","","","",""]
[null,391,null,null,null,null,null,null,"","","","","","","",null,null,391,null,null,null,null,null,null,"","","","","","",""]
[null,392,null,null,null,null,null,null,"","","","","","","",null,null,392,null,null,null,null,null,null,"","","","","","",""]
[null,393,null,null,null,null,null,null,"","","","","","","",null,null,393,null,null,null,null,null,null,"","","","","","",""]
[null,394,null,null,null,null,null,null,"","","","","","","",null,null,394,null,null,null,null,null,null,"","","","","","",""]
[null,395,null,null,null,null,null,null,"","","","","","","",null,null,395,null,null,null,null,null,null,"","","","","","",""]
[null,396,null,null,null,null,null,null,"","","","","","","",null,null,396,null,null,null,null,null,null,"","","","","","",""]
[null,397,null,null,null,null,null,null,"","","","","","","",null,null,397,null,null,null,null,null,null,"","","","","","",""]
[null,398,null,null,null,null,null,null,"","","","","","","",null,null,398,null,null,null,null,null,null,"","","","","","",""]
[null,399,null,null,null,null,null,null,"","","","","","","",null,null,399,null,null,null,null,null,null,"","","","","","",""]
[null,400,null,null,null,null,null,null,"","","","","","","",null,null,400,null,null,null,null,null,null,"","","","","","",""]
[null,401,null,null,null,null,null,null,"","","","","","","",null,null,401,null,null,null,null,null,null,"","","","","","",""]
[null,402,null,null,null,null,null,null,"","","","","","","",null,null,402,null,null,null,null,null,null,"","","","","","",""]
[null,403,null,null,null,null,null,null,"","","","","","","",null,null,403,null,null,null,null,null,null,"","","","","","",""]
[null,404,null,null,null,null,null,null,"","","","","","","",null,null,404,null,null,null,null,null,null,"","","","","","",""]
[null,405,null,null,null,null,null,null,"","","","","","","",null,null,405,null,null,null,null,null,null,"","","","","","",""]
[null,406,null,null,null,null,null,null,"","","","","","","",null,null,406,null,null,null,null,null,null,"","","","","","",""]
[null,407,null,null,null,null,null,null,"","","","","","","",null,null,407,null,null,null,null,null,null,"","","","","","",""]
[null,408,null,null,null,null,null,null,"","","","","","","",null,null,408,null,null,null,null,null,null,"","","","","","",""]
[null,409,null,null,null,null,null,null,"","","","","","","",null,null,409,null,null,null,null,null,null,"","","","","","",""]
[null,410,null,null,null,null,null,null,"","","","","","","",null,null,410,null,null,null,null,null,null,"","","","","","",""]
[null,411,null,null,null,null,null,null,"","","","","","","",null,null,411,null,null,null,null,null,null,"","","","","","",""]
[null,412,null,null,null,null,null,null,"","","","","","","",null,null,412,null,null,null,null,null,null,"","","","","","",""]
[null,413,null,null,null,null,null,null,"","","","","","","",null,null,413,null,null,null,null,null,null,"","","","","","",""]
[null,414,null,null,null,null,null,null,"","","","","","","",null,null,414,null,null,null,null,null,null,"","","","","","",""]
[null,415,null,null,null,null,null,null,"","","","","","","",null,null,415,null,null,null,null,null,null,"","","","","","",""]
[null,416,null,null,null,null,null,null,"","","","","","","",null,null,416,null,null,null,null,null,null,"","","","","","",""]
[null,417,null,null,null,null,null,null,"","","","","","","",null,null,417,null,null,null,null,null,null,"","","","","","",""]
[null,418,null,null,null,null,null,null,"","","","","","","",null,null,418,null,null,null,null,null,null,"","","","","","",""]
[null,419,null,null,null,null,null,null,"","","","","","","",null,null,419,null,null,null,null,null,null,"","","","","","",""]
[null,420,null,null,null,null,null,null,"","","","","","","",null,null,420,null,null,null,null,null,null,"","","","","","",""]
[null,421,null,null,null,null,null,null,"","","","","","","",null,null,421,null,null,null,null,null,null,"","","","","","",""]
[null,422,null,null,null,null,null,null,"","","","","","","",null,null,422,null,null,null,null,null,null,"","","","","","",""]
[null,423,null,null,null,null,null,null,"","","","","","","",null,null,423,null,null,null,null,null,null,"","","","","","",""]
[null,424,null,null,null,null,null,null,"","","","","","","",null,null,424,null,null,null,null,null,null,"","","","","","",""]
[null,425,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C430=\"\",\"\",IF(D430=\"Annuity\",ROUNDDOWN(25*E430/N430,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F430/N430,4),ROUNDDOWN(25*80%*F430/N430,4))))","v":""},null,null,425,null,null,null,null,null,null,"","","","","","",""]
[null,426,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C431=\"\",\"\",IF(D431=\"Annuity\",ROUNDDOWN(25*E431/N431,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F431/N431,4),ROUNDDOWN(25*80%*F431/N431,4))))","v":""},null,null,426,null,null,null,null,null,null,"","","","","","",""]
[null,427,null,null,null,null,null,null,"","","","","","","",null,null,427,null,null,null,null,null,null,"","","","","","",""]
[null,428,null,null,null,null,null,null,"","","","","","","",null,null,428,null,null,null,null,null,null,"","","","","","",""]
[null,429,null,null,null,null,null,null,"","","","","","","",null,null,429,null,null,null,null,null,null,"","","","","","",""]
[null,430,null,null,null,null,null,null,"","","","","","","",null,null,430,null,null,null,null,null,null,"","","","","","",""]
[null,431,null,null,null,null,null,null,"","","","","","","",null,null,431,null,null,null,null,null,null,"","","","","","",""]
[null,432,null,null,null,null,null,null,"","","","","","","",null,null,432,null,null,null,null,null,null,"","","","","","",""]
[null,433,null,null,null,null,null,null,"","","","","","","",null,null,433,null,null,null,null,null,null,"","","","","","",""]
[null,434,null,null,null,null,null,null,"","","","","","","",null,null,434,null,null,null,null,null,null,"","","","","","",""]
[null,435,null,null,null,null,null,null,"","","","","","","",null,null,435,null,null,null,null,null,null,"","","","","","",""]
[null,436,null,null,null,null,null,null,"","","","","","","",null,null,436,null,null,null,null,null,null,"","","","","","",""]
[null,437,null,null,null,null,null,null,"","","","","","","",null,null,437,null,null,null,null,null,null,"","","","","","",""]
[null,438,null,null,null,null,null,null,"","","","","","","",null,null,438,null,null,null,null,null,null,"","","","","","",""]
[null,439,null,null,null,null,null,null,"","","","","","","",null,null,439,null,null,null,null,null,null,"","","","","","",""]
[null,440,null,null,null,null,null,null,"","","","","","","",null,null,440,null,null,null,null,null,null,"","","","","","",""]
[null,441,null,null,null,null,null,null,"","","","","","","",null,null,441,null,null,null,null,null,null,"","","","","","",""]
[null,442,null,null,null,null,null,null,"","","","","","","",null,null,442,null,null,null,null,null,null,"","","","","","",""]
[null,443,null,null,null,null,null,null,"","","","","","","",null,null,443,null,null,null,null,null,null,"","","","","","",""]
[null,444,null,null,null,null,null,null,"","","","","","","",null,null,444,null,null,null,null,null,null,"","","","","","",""]
[null,445,null,null,null,null,null,null,"","","","","","","",null,null,445,null,null,null,null,null,null,"","","","","","",""]
[null,446,null,null,null,null,null,null,"","","","","","","",null,null,446,null,null,null,null,null,null,"","","","","","",""]
[null,447,null,null,null,null,null,null,"","","","","","","",null,null,447,null,null,null,null,null,null,"","","","","","",""]
[null,448,null,null,null,null,null,null,"","","","","","","",null,null,448,null,null,null,null,null,null,"","","","","","",""]
[null,449,null,null,null,null,null,null,"","","","","","","",null,null,449,null,null,null,null,null,null,"","","","","","",""]
[null,450,null,null,null,null,null,null,"","","","","","","",null,null,450,null,null,null,null,null,null,"","","","","","",""]
[null,451,null,null,null,null,null,null,"","","","","","","",null,null,451,null,null,null,null,null,null,"","","","","","",""]
[null,452,null,null,null,null,null,null,"","","","","","","",null,null,452,null,null,null,null,null,null,"","","","","","",""]
[null,453,null,null,null,null,null,null,"","","","","","","",null,null,453,null,null,null,null,null,null,"","","","","","",""]
[null,454,null,null,null,null,null,null,"","","","","","","",null,null,454,null,null,null,null,null,null,"","","","","","",""]
[null,455,null,null,null,null,null,null,"","","","","","","",null,null,455,null,null,null,null,null,null,"","","","","","",""]
[null,456,null,null,null,null,null,null,"","","","","","","",null,null,456,null,null,null,null,null,null,"","","","","","",""]
[null,457,null,null,null,null,null,null,"","","","","","","",null,null,457,null,null,null,null,null,null,"","","","","","",""]
[null,458,null,null,null,null,null,null,"","","","","","","",null,null,458,null,null,null,null,null,null,"","","","","","",""]
[null,459,null,null,null,null,null,null,"","","","","","","",null,null,459,null,null,null,null,null,null,"","","","","","",""]
[null,460,null,null,null,null,null,null,"","","","","","","",null,null,460,null,null,null,null,null,null,"","","","","","",""]
[null,461,null,null,null,null,null,null,"","","","","","","",null,null,461,null,null,null,null,null,null,"","","","","","",""]
[null,462,null,null,null,null,null,null,"","","","","","","",null,null,462,null,null,null,null,null,null,"","","","","","",""]
[null,463,null,null,null,null,null,null,"","","","","","","",null,null,463,null,null,null,null,null,null,"","","","","","",""]
[null,464,null,null,null,null,null,null,"","","","","","","",null,null,464,null,null,null,null,null,null,"","","","","","",""]
[null,465,null,null,null,null,null,null,"","","","","","","",null,null,465,null,null,null,null,null,null,"","","","","","",""]
[null,466,null,null,null,null,null,null,"","","","","","","",null,null,466,null,null,null,null,null,null,"","","","","","",""]
[null,467,null,null,null,null,null,null,"","","","","","","",null,null,467,null,null,null,null,null,null,"","","","","","",""]
[null,468,null,null,null,null,null,null,"","","","","","","",null,null,468,null,null,null,null,null,null,"","","","","","",""]
[null,469,null,null,null,null,null,null,"","","","","","","",null,null,469,null,null,null,null,null,null,"","","","","","",""]
[null,470,null,null,null,null,null,null,"","","","","","","",null,null,470,null,null,null,null,null,null,"","","","","","",""]
[null,471,null,null,null,null,null,null,"","","","","","","",null,null,471,null,null,null,null,null,null,"","","","","","",""]
[null,472,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C477=\"\",\"\",IF(D477=\"Annuity\",ROUNDDOWN(25*E477/N477,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F477/N477,4),ROUNDDOWN(25*80%*F477/N477,4))))","v":""},null,null,472,null,null,null,null,null,null,"","","","","","",""]
[null,473,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C478=\"\",\"\",IF(D478=\"Annuity\",ROUNDDOWN(25*E478/N478,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F478/N478,4),ROUNDDOWN(25*80%*F478/N478,4))))","v":""},null,null,473,null,null,null,null,null,null,"","","","","","",""]
[null,474,null,null,null,null,null,null,"","","","","","","",null,null,474,null,null,null,null,null,null,"","","","","","",""]
[null,475,null,null,null,null,null,null,"","","","","","","",null,null,475,null,null,null,null,null,null,"","","","","","",""]
[null,476,null,null,null,null,null,null,"","","","","","","",null,null,476,null,null,null,null,null,null,"","","","","","",""]
[null,477,null,null,null,null,null,null,"","","","","","","",null,null,477,null,null,null,null,null,null,"","","","","","",""]
[null,478,null,null,null,null,null,null,"","","","","","","",null,null,478,null,null,null,null,null,null,"","","","","","",""]
[null,479,null,null,null,null,null,null,"","","","","","","",null,null,479,null,null,null,null,null,null,"","","","","","",""]
[null,480,null,null,null,null,null,null,"","","","","","","",null,null,480,null,null,null,null,null,null,"","","","","","",""]
[null,481,null,null,null,null,null,null,"","","","","","","",null,null,481,null,null,null,null,null,null,"","","","","","",""]
[null,482,null,null,null,null,null,null,"","","","","","","",null,null,482,null,null,null,null,null,null,"","","","","","",""]
[null,483,null,null,null,null,null,null,"","","","","","","",null,null,483,null,null,null,null,null,null,"","","","","","",""]
[null,484,null,null,null,null,null,null,"","","","","","","",null,null,484,null,null,null,null,null,null,"","","","","","",""]
[null,485,null,null,null,null,null,null,"","","","","","","",null,null,485,null,null,null,null,null,null,"","","","","","",""]
[null,486,null,null,null,null,null,null,"","","","","","","",null,null,486,null,null,null,null,null,null,"","","","","","",""]
[null,487,null,null,null,null,null,null,"","","","","","","",null,null,487,null,null,null,null,null,null,"","","","","","",""]
[null,488,null,null,null,null,null,null,"","","","","","","",null,null,488,null,null,null,null,null,null,"","","","","","",""]
[null,489,null,null,null,null,null,null,"","","","","","","",null,null,489,null,null,null,null,null,null,"","","","","","",""]
[null,490,null,null,null,null,null,null,"","","","","","","",null,null,490,null,null,null,null,null,null,"","","","","","",""]
[null,491,null,null,null,null,null,null,"","","","","","","",null,null,491,null,null,null,null,null,null,"","","","","","",""]
[null,492,null,null,null,null,null,null,"","","","","","","",null,null,492,null,null,null,null,null,null,"","","","","","",""]
[null,493,null,null,null,null,null,null,"","","","","","","",null,null,493,null,null,null,null,null,null,"","","","","","",""]
[null,494,null,null,null,null,null,null,"","","","","","","",null,null,494,null,null,null,null,null,null,"","","","","","",""]
[null,495,null,null,null,null,null,null,"","","","","","","",null,null,495,null,null,null,null,null,null,"","","","","","",""]
[null,496,null,null,null,null,null,null,"","","","","","","",null,null,496,null,null,null,null,null,null,"","","","","","",""]
[null,497,null,null,null,null,null,null,"","","","","","","",null,null,497,null,null,null,null,null,null,"","","","","","",""]
[null,498,null,null,null,null,null,null,"","","","","","","",null,null,498,null,null,null,null,null,null,"","","","","","",""]
[null,499,null,null,null,null,null,null,"","","","","","","",null,null,499,null,null,null,null,null,null,"","","","","","",""]
[null,500,null,null,null,null,null,null,"","","","","","","",null,null,500,null,null,null,null,null,null,"","","","","","",""]
[null,501,null,null,null,null,null,null,"","","","","","","",null,null,501,null,null,null,null,null,null,"","","","","","",""]
[null,502,null,null,null,null,null,null,"","","","","","","",null,null,502,null,null,null,null,null,null,"","","","","","",""]
[null,503,null,null,null,null,null,null,"","","","","","","",null,null,503,null,null,null,null,null,null,"","","","","","",""]
[null,504,null,null,null,null,null,null,"","","","","","","",null,null,504,null,null,null,null,null,null,"","","","","","",""]
[null,505,null,null,null,null,null,null,"","","","","","","",null,null,505,null,null,null,null,null,null,"","","","","","",""]
[null,506,null,null,null,null,null,null,"","","","","","","",null,null,506,null,null,null,null,null,null,"","","","","","",""]
[null,507,null,null,null,null,null,null,"","","","","","","",null,null,507,null,null,null,null,null,null,"","","","","","",""]
[null,508,null,null,null,null,null,null,"","","","","","","",null,null,508,null,null,null,null,null,null,"","","","","","",""]
[null,509,null,null,null,null,null,null,"","","","","","","",null,null,509,null,null,null,null,null,null,"","","","","","",""]
[null,510,null,null,null,null,null,null,"","","","","","","",null,null,510,null,null,null,null,null,null,"","","","","","",""]
[null,511,null,null,null,null,null,null,"","","","","","","",null,null,511,null,null,null,null,null,null,"","","","","","",""]
[null,512,null,null,null,null,null,null,"","","","","","","",null,null,512,null,null,null,null,null,null,"","","","","","",""]
[null,513,null,null,null,null,null,null,"","","","","","","",null,null,513,null,null,null,null,null,null,"","","","","","",""]
[null,514,null,null,null,null,null,null,"","","","","","","",null,null,514,null,null,null,null,null,null,"","","","","","",""]
[null,515,null,null,null,null,null,null,"","","","","","","",null,null,515,null,null,null,null,null,null,"","","","","","",""]
[null,516,null,null,null,null,null,null,"","","","","","","",null,null,516,null,null,null,null,null,null,"","","","","","",""]
[null,517,null,null,null,null,null,null,"","","","","","","",null,null,517,null,null,null,null,null,null,"","","","","","",""]
[null,518,null,null,null,null,null,null,"","","","","","","",null,null,518,null,null,null,null,null,null,"","","","","","",""]
[null,519,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C524=\"\",\"\",IF(D524=\"Annuity\",ROUNDDOWN(25*E524/N524,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F524/N524,4),ROUNDDOWN(25*80%*F524/N524,4))))","v":""},null,null,519,null,null,null,null,null,null,"","","","","","",""]
[null,520,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C525=\"\",\"\",IF(D525=\"Annuity\",ROUNDDOWN(25*E525/N525,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F525/N525,4),ROUNDDOWN(25*80%*F525/N525,4))))","v":""},null,null,520,null,null,null,null,null,null,"","","","","","",""]
[null,521,null,null,null,null,null,null,"","","","","","","",null,null,521,null,null,null,null,null,null,"","","","","","",""]
[null,522,null,null,null,null,null,null,"","","","","","","",null,null,522,null,null,null,null,null,null,"","","","","","",""]
[null,523,null,null,null,null,null,null,"","","","","","","",null,null,523,null,null,null,null,null,null,"","","","","","",""]
[null,524,null,null,null,null,null,null,"","","","","","","",null,null,524,null,null,null,null,null,null,"","","","","","",""]
[null,525,null,null,null,null,null,null,"","","","","","","",null,null,525,null,null,null,null,null,null,"","","","","","",""]
[null,526,null,null,null,null,null,null,"","","","","","","",null,null,526,null,null,null,null,null,null,"","","","","","",""]
[null,527,null,null,null,null,null,null,"","","","","","","",null,null,527,null,null,null,null,null,null,"","","","","","",""]
[null,528,null,null,null,null,null,null,"","","","","","","",null,null,528,null,null,null,null,null,null,"","","","","","",""]
[null,529,null,null,null,null,null,null,"","","","","","","",null,null,529,null,null,null,null,null,null,"","","","","","",""]
[null,530,null,null,null,null,null,null,"","","","","","","",null,null,530,null,null,null,null,null,null,"","","","","","",""]
[null,531,null,null,null,null,null,null,"","","","","","","",null,null,531,null,null,null,null,null,null,"","","","","","",""]
[null,532,null,null,null,null,null,null,"","","","","","","",null,null,532,null,null,null,null,null,null,"","","","","","",""]
[null,533,null,null,null,null,null,null,"","","","","","","",null,null,533,null,null,null,null,null,null,"","","","","","",""]
[null,534,null,null,null,null,null,null,"","","","","","","",null,null,534,null,null,null,null,null,null,"","","","","","",""]
[null,535,null,null,null,null,null,null,"","","","","","","",null,null,535,null,null,null,null,null,null,"","","","","","",""]
[null,536,null,null,null,null,null,null,"","","","","","","",null,null,536,null,null,null,null,null,null,"","","","","","",""]
[null,537,null,null,null,null,null,null,"","","","","","","",null,null,537,null,null,null,null,null,null,"","","","","","",""]
[null,538,null,null,null,null,null,null,"","","","","","","",null,null,538,null,null,null,null,null,null,"","","","","","",""]
[null,539,null,null,null,null,null,null,"","","","","","","",null,null,539,null,null,null,null,null,null,"","","","","","",""]
[null,540,null,null,null,null,null,null,"","","","","","","",null,null,540,null,null,null,null,null,null,"","","","","","",""]
[null,541,null,null,null,null,null,null,"","","","","","","",null,null,541,null,null,null,null,null,null,"","","","","","",""]
[null,542,null,null,null,null,null,null,"","","","","","","",null,null,542,null,null,null,null,null,null,"","","","","","",""]
[null,543,null,null,null,null,null,null,"","","","","","","",null,null,543,null,null,null,null,null,null,"","","","","","",""]
[null,544,null,null,null,null,null,null,"","","","","","","",null,null,544,null,null,null,null,null,null,"","","","","","",""]
[null,545,null,null,null,null,null,null,"","","","","","","",null,null,545,null,null,null,null,null,null,"","","","","","",""]
[null,546,null,null,null,null,null,null,"","","","","","","",null,null,546,null,null,null,null,null,null,"","","","","","",""]
[null,547,null,null,null,null,null,null,"","","","","","","",null,null,547,null,null,null,null,null,null,"","","","","","",""]
[null,548,null,null,null,null,null,null,"","","","","","","",null,null,548,null,null,null,null,null,null,"","","","","","",""]
[null,549,null,null,null,null,null,null,"","","","","","","",null,null,549,null,null,null,null,null,null,"","","","","","",""]
[null,550,null,null,null,null,null,null,"","","","","","","",null,null,550,null,null,null,null,null,null,"","","","","","",""]
[null,551,null,null,null,null,null,null,"","","","","","","",null,null,551,null,null,null,null,null,null,"","","","","","",""]
[null,552,null,null,null,null,null,null,"","","","","","","",null,null,552,null,null,null,null,null,null,"","","","","","",""]
[null,553,null,null,null,null,null,null,"","","","","","","",null,null,553,null,null,null,null,null,null,"","","","","","",""]
[null,554,null,null,null,null,null,null,"","","","","","","",null,null,554,null,null,null,null,null,null,"","","","","","",""]
[null,555,null,null,null,null,null,null,"","","","","","","",null,null,555,null,null,null,null,null,null,"","","","","","",""]
[null,556,null,null,null,null,null,null,"","","","","","","",null,null,556,null,null,null,null,null,null,"","","","","","",""]
[null,557,null,null,null,null,null,null,"","","","","","","",null,null,557,null,null,null,null,null,null,"","","","","","",""]
[null,558,null,null,null,null,null,null,"","","","","","","",null,null,558,null,null,null,null,null,null,"","","","","","",""]
[null,559,null,null,null,null,null,null,"","","","","","","",null,null,559,null,null,null,null,null,null,"","","","","","",""]
[null,560,null,null,null,null,null,null,"","","","","","","",null,null,560,null,null,null,null,null,null,"","","","","","",""]
[null,561,null,null,null,null,null,null,"","","","","","","",null,null,561,null,null,null,null,null,null,"","","","","","",""]
[null,562,null,null,null,null,null,null,"","","","","","","",null,null,562,null,null,null,null,null,null,"","","","","","",""]
[null,563,null,null,null,null,null,null,"","","","","","","",null,null,563,null,null,null,null,null,null,"","","","","","",""]
[null,564,null,null,null,null,null,null,"","","","","","","",null,null,564,null,null,null,null,null,null,"","","","","","",""]
[null,565,null,null,null,null,null,null,"","","","","","","",null,null,565,null,null,null,null,null,null,"","","","","","",""]
[null,566,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C571=\"\",\"\",IF(D571=\"Annuity\",ROUNDDOWN(25*E571/N571,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F571/N571,4),ROUNDDOWN(25*80%*F571/N571,4))))","v":""},null,null,566,null,null,null,null,null,null,"","","","","","",""]
[null,567,null,null,null,null,null,null,"","","","","","",{"$f":"IF(C572=\"\",\"\",IF(D572=\"Annuity\",ROUNDDOWN(25*E572/N572,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F572/N572,4),ROUNDDOWN(25*80%*F572/N572,4))))","v":""},null,null,567,null,null,null,null,null,null,"","","","","","",""]
[null,568,null,null,null,null,null,null,"","","","","","","",null,null,568,null,null,null,null,null,null,"","","","","","",""]
[null,569,null,null,null,null,null,null,"","","","","","","",null,null,569,null,null,null,null,null,null,"","","","","","",""]
[null,570,null,null,null,null,null,null,"","","","","","","",null,null,570,null,null,null,null,null,null,"","","","","","",""]
[null,571,null,null,null,null,null,null,"","","","","","","",null,null,571,null,null,null,null,null,null,"","","","","","",""]
[null,572,null,null,null,null,null,null,"","","","","","","",null,null,572,null,null,null,null,null,null,"","","","","","",""]
[null,573,null,null,null,null,null,null,"","","","","","","",null,null,573,null,null,null,null,null,null,"","","","","","",""]
[null,574,null,null,null,null,null,null,"","","","","","","",null,null,574,null,null,null,null,null,null,"","","","","","",""]
[null,575,null,null,null,null,null,null,"","","","","","","",null,null,575,null,null,null,null,null,null,"","","","","","",""]
[null,576,null,null,null,null,null,null,"","","","","","","",null,null,576,null,null,null,null,null,null,"","","","","","",""]
[null,577,null,null,null,null,null,null,"","","","","","","",null,null,577,null,null,null,null,null,null,"","","","","","",""]
[null,578,null,null,null,null,null,null,"","","","","","","",null,null,578,null,null,null,null,null,null,"","","","","","",""]
[null,579,null,null,null,null,null,null,"","","","","","","",null,null,579,null,null,null,null,null,null,"","","","","","",""]
[null,580,null,null,null,null,null,null,"","","","","","","",null,null,580,null,null,null,null,null,null,"","","","","","",""]
[null,581,null,null,null,null,null,null,"","","","","","","",null,null,581,null,null,null,null,null,null,"","","","","","",""]
[null,582,null,null,null,null,null,null,"","","","","","","",null,null,582,null,null,null,null,null,null,"","","","","","",""]
[null,583,null,null,null,null,null,null,"","","","","","","",null,null,583,null,null,null,null,null,null,"","","","","","",""]
[null,584,null,null,null,null,null,null,"","","","","","","",null,null,584,null,null,null,null,null,null,"","","","","","",""]
[null,585,null,null,null,null,null,null,"","","","","","","",null,null,585,null,null,null,null,null,null,"","","","","","",""]
[null,586,null,null,null,null,null,null,"","","","","","","",null,null,586,null,null,null,null,null,null,"","","","","","",""]
[null,587,null,null,null,null,null,null,"","","","","","","",null,null,587,null,null,null,null,null,null,"","","","","","",""]
[null,588,null,null,null,null,null,null,"","","","","","","",null,null,588,null,null,null,null,null,null,"","","","","","",""]
[null,589,null,null,null,null,null,null,"","","","","","","",null,null,589,null,null,null,null,null,null,"","","","","","",""]
[null,590,null,null,null,null,null,null,"","","","","","","",null,null,590,null,null,null,null,null,null,"","","","","","",""]
[null,591,null,null,null,null,null,null,"","","","","","","",null,null,591,null,null,null,null,null,null,"","","","","","",""]
[null,592,null,null,null,null,null,null,"","","","","","","",null,null,592,null,null,null,null,null,null,"","","","","","",""]
[null,593,null,null,null,null,null,null,{"$f":"IF(C598=\"\",\"\",(DATEDIF(DOB,C598,\"Y\")))","v":""},{"$f":"IF(C598=\"\",\"\",IF(MONTH(C598)=4,IF(DAY(C598)>=6,YEAR(C598),YEAR(C598)-1),IF(MONTH(C598)>4,YEAR(C598),YEAR(C598)-1)))","v":""},{"$f":"IFERROR(IF(J598<2006,VLOOKUP(2006,LTA_Table,3),VLOOKUP(J598,LTA_Table,3)),\"\")","v":""},{"$f":"IFERROR(IF(H598=\"Y\",G598,IF(C598=\"\",\"\",VLOOKUP($Z$6,LTA_Table,4))),\"\")","v":""},{"$f":"IF(C598=\"\",\"\",IF(K598>I598,100%-2.5%*DATEDIF(C598,DATE(YEAR(DOB) + K598, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},{"$f":"IF(L598=\"\",\"\",L598*M598)","v":""},{"$f":"IF(C598=\"\",\"\",IF(D598=\"Annuity\",ROUNDDOWN(25*E598/N598,4),IF($S$6<DATE(2015,4,6),ROUNDDOWN(25*F598/N598,4),ROUNDDOWN(25*80%*F598/N598,4))))","v":""},null,null,593,null,null,null,null,null,null,{"$f":"IF(S598=\"\",\"\",(DATEDIF(DOB,S598,\"Y\")))","v":""},{"$f":"IF(S598=\"\",\"\",IF(MONTH(S598)=4,IF(DAY(S598)>=6,YEAR(S598),YEAR(S598)-1),IF(MONTH(S598)>4,YEAR(S598),YEAR(S598)-1)))","v":""},{"$f":"IFERROR(VLOOKUP(Z598,LTA_Table,3),\"\")","v":""},{"$f":"IFERROR(IF(X598=\"Y\",W598,VLOOKUP(Z598,LTA_Table,4)),\"\")","v":""},{"$f":"IF(S598=\"\",\"\",IF(AA598>Y598,100%-2.5%*DATEDIF(S598,DATE(YEAR(DOB) + AA598, MONTH(DOB), DAY(DOB)),\"Y\"),100%))","v":""},{"$f":"IF(AB598=\"\",\"\",AB598*AC598)","v":""},{"$f":"IF(S598=\"\",\"\",ROUNDDOWN(U598/AD598,4))","v":""}]
[null,594,null,null,null,null,null,null,"","","","","","","",null,null,594,null,null,null,null,null,null,"","","","","","",""]
[null,595,null,null,null,null,null,null,"","","","","","","",null,null,595,null,null,null,null,null,null,"","","","","","",""]
[null,596,null,null,null,null,null,null,"","","","","","","",null,null,596,null,null,null,null,null,null,"","","","","","",""]
[null,597,null,null,null,null,null,null,"","","","","","","",null,null,597,null,null,null,null,null,null,"","","","","","",""]
[null,598,null,null,null,null,null,null,"","","","","","","",null,null,598,null,null,null,null,null,null,"","","","","","",""]
[null,599,null,null,null,null,null,null,"","","","","","","",null,null,599,null,null,null,null,null,null,"","","","","","",""]
[null,600,null,null,null,null,null,null,"","","","","","","",null,null,600,null,null,null,null,null,null,"","","","","","",""]
[null,601,null,null,null,null,null,null,"","","","","","","",null,null,601,null,null,null,null,null,null,"","","","","","",""]
[null,602,null,null,null,null,null,null,"","","","","","","",null,null,602,null,null,null,null,null,null,"","","","","","",""]
[null,603,null,null,null,null,null,null,"","","","","","","",null,null,603,null,null,null,null,null,null,"","","","","","",""]
[null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(O6:O608)","v":0},null,null,"Total",null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"SUM(AE6:AE608)","v":0}]
[]
[]
[]
["Total LTA % used up till date",null,{"$f":"IF(Uncrystallized = \"Funds in Drawdown\",IF(P2=\"N\",IF(VLOOKUP(\"Age75Value\",T6:AE608,12)>Orig_LTA,VLOOKUP(\"Age75Value\",T6:AE608,12)+other_LTA_prct+preA_LTA,Orig_LTA+other_LTA_prct+preA_LTA),Orig_LTA+VLOOKUP(\"Age75Value\",T6:AE608,12)+other_LTA_prct+preA_LTA),IF(Uncrystallized = \"Both\",IF(P2=\"N\",IF(VLOOKUP(\"Age75Value\",T6:AE608,12)>Orig_LTA,postA_LTA - VLOOKUP(\"Age75Value\",T6:AE608,12)+other_LTA_prct+preA_LTA,postA_LTA - VLOOKUP(\"Age75Value\",T6:AE608,12) + Orig_LTA+other_LTA_prct+preA_LTA),postA_LTA + Orig_LTA +other_LTA_prct+preA_LTA),other_LTA_prct+preA_LTA+postA_LTA))","v":0}]
[]
["Available LTA %",null,{"$f":"IF(Tot_LTA<=100%,100% - Tot_LTA,0)","v":1}]
[]
["LTA amount as at last BCE",null,{"$f":"IF(S6=\"\",,LOOKUP(2,1/(PostA_LTA_amt <> \"\"),PostA_LTA_amt))","v":0}]
["LTA % for last BCE",null,{"$f":"IF(S6=\"\",,SUMIF(S6:S608,MAX(S6:S608),PostA_LTA_prct_Amt))","v":0}]
["LTA% available before last BCE",null,{"$f":"IF(S6=\"\",,IF((Tot_LTA-LTA_at_Last_BCE) >100%,0,100%-(Tot_LTA-LTA_at_Last_BCE)))","v":0}]
["Amount that could be paid till 100% LTA",null,{"$f":"current_LTA*C619","v":0}]
["Amount on last crystallization event",null,{"$f":"IF(S6=\"\",,SUMIF(S6:S608,MAX(S6:S608),PostA_Cryst_amount))","v":0}]
["Excess LTA on last crystallization event",null,{"$f":"IF(LTA_avlbl_amt> Latest_Cryst_amt, 0, Latest_Cryst_amt-LTA_avlbl_amt)","v":0}]
["LAC",null,{"$f":"excess_LTA*LTA_Charge","v":0},{"$f":"IF(OR(Uncrystallized<> \"\",Drawdown= \"Drawdown/ Annuity\", Drawdown=\"QROPS\"),\"**25% of the excess over the available LTA\",\"**Assume the policyholder wants the excess after the LTA charge has been applied to be paid as a lump sum, therefore a 55% LTA charge is applied\")","v":"**Assume the policyholder wants the excess after the LTA charge has been applied to be paid as a lump sum, therefore a 55% LTA charge is applied"}]
["LAELS",null,{"$f":"excess_LTA-LAC","v":0}]
[]
["25% TFC",null,{"$f":"LTA_avlbl_amt*25%","v":0}]
["75% Taxable Income",null,{"$f":"LTA_avlbl_amt*75%","v":0},"**Subject to PAYE"]
[]
["Issue Warning",null,{"$f":"IF(Orig_LTA = 0, \"N\",IF(Orig_LTA = preA_LTA + postA_LTA -VLOOKUP(\"Age75Value\",T6:AE608,12), \"N\",\"Y\"))","v":"N"}]
[]
[]
["LTA% used up after 5/4/24",null,{"$f":"IF(S6=\"\",,SUMIF(S6:S608,\">05/04/2024\",PostA_LTA_prct_Amt))","v":0}]
[]
["LTA% @ 5th April, 2024",null,{"$f":"Tot_LTA-LTA_after_5April","v":0}]

{"sheet":"Result","index":10,"n_rows":35,"n_cols":3,"rows_kept":35,"cut":false,"hidden":false,"merged":[]}
[]
["Total LTA% used to date"]
[]
["LTA tax charge paid to HMRC ",null,{"$f":"IF(OR(Uncrystallized <>  \"\",Drawdown= \"Drawdown/ Annuity\", Drawdown=\"QROPS\"),\"**25% of the excess over the available LTA\",\"**Assume the policyholder wants the excess after the LTA charge has been applied to be paid as a lump sum, therefore a 55% LTA charge is applied\")","v":"**Assume the policyholder wants the excess after the LTA charge has been applied to be paid as a lump sum, therefore a 55% LTA charge is applied"}]
[]
["Lump sum after the LTA charge has been applied"]
[]
[]
["LTA% @ 5th April, 2024",0]
["LTA% used up after 5/4/24",0]
[]
[]
["Running Total"]
[]
[null,"Within RL","Other Provider"]
["RL Policy1",{"$f":"Input!G2+LTA_at_Last_BCE","v":0},{"$f":"Input!H2","v":0}]
["RL Policy2",{"$f":"Input!G3","v":0},{"$f":"Input!H3","v":0}]
["RL Policy3",{"$f":"Input!G4","v":0},{"$f":"Input!H4","v":0}]
["RL Policy4",{"$f":"Input!G5","v":0},{"$f":"Input!H5","v":0}]
["RL Policy5",{"$f":"Input!G6","v":0},{"$f":"Input!H6","v":0}]
["RL Policy6",{"$f":"Input!G7","v":0},{"$f":"Input!H7","v":0}]
["RL Policy7",{"$f":"Input!G8","v":0},{"$f":"Input!H8","v":0}]
["RL Policy8",{"$f":"Input!G9","v":0},{"$f":"Input!H9","v":0}]
["RL Policy9",{"$f":"Input!G10","v":0},{"$f":"Input!H10","v":0}]
["RL Policy10",{"$f":"Input!G11","v":0},{"$f":"Input!H11","v":0}]
["RL Policy11",{"$f":"Input!G12","v":0},{"$f":"Input!H12","v":0}]
["RL Policy12",{"$f":"Input!G13","v":0},{"$f":"Input!H13","v":0}]
["RL Policy13",{"$f":"Input!G14","v":0},{"$f":"Input!H14","v":0}]
["RL Policy14",{"$f":"Input!G15","v":0},{"$f":"Input!H15","v":0}]
["RL Policy15",{"$f":"Input!G16","v":0},{"$f":"Input!H16","v":0}]
["RL Policy16",{"$f":"Input!G17","v":0},{"$f":"Input!H17","v":0}]
["RL Policy17",{"$f":"Input!G18","v":0},{"$f":"Input!H18","v":0}]
["RL Policy18",{"$f":"Input!G19","v":0},{"$f":"Input!H19","v":0}]
["RL Policy19",{"$f":"Input!G20","v":0},{"$f":"Input!H20","v":0}]
["RL Policy20",{"$f":"Input!G21","v":0},{"$f":"Input!H21","v":0}]

{"sheet":"LTA Table","index":11,"n_rows":21,"n_cols":5,"rows_kept":21,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tax year",null,"Normal Minumum Pension Age","LTA amount"]
[null,"Year A","Year B"]
[null,2006,2007,50,1500000]
[null,2007,2008,50,1600000]
[null,2008,2009,50,1650000]
[null,2009,2010,50,1750000]
[null,2010,2011,50,1800000]
[null,2011,2012,55,1800000]
[null,2012,2013,55,1500000]
[null,2013,2014,55,1500000]
[null,2014,2015,55,1250000]
[null,2015,2016,55,1250000]
[null,2016,2017,55,1000000]
[null,2017,2018,55,1000000]
[null,2018,2019,55,1030000]
[null,2019,2020,55,1055000]
[null,2020,2021,55,1073100]
[null,2021,2022,55,1073100]
[null,2022,2023,55,1073100]
[null,2023,2024,55,1073100]

{"sheet":"LSA Table","index":12,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tax year",null,"Normal Minumum Pension Age","LSA amount"]
[null,"Year A","Year B"]
[null,2024,2025,55,268275]

{"sheet":"LSDBA Table","index":13,"n_rows":4,"n_cols":5,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Tax year",null,"Normal Minumum Pension Age","LTA amount"]
[null,"Year A","Year B"]
[null,2024,2025,55,1073100]

{"sheet":"Protection Table","index":14,"n_rows":10,"n_cols":7,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Type Of Protection","Protected LTA Amount",null,"Type Of Protection","Min Protected LTA Amount","Max Protected LTA Amount"]
[null,"No Protection",null,null,"Individual protection 2014 (IP 2014)",1250000,1500000]
[null,"Primary protection (PP)",null,null,"Individual protection 2016 (IP 2016)",1000000,1250000]
[null,"Enhanced protection (EP)",null,null,"Primary protection (PP)",0,999999999]
[null,"Fixed protection (FP)",1800000,null,"Enhanced protection (EP)",0,999999999]
[null,"Fixed protection 2014 (FP 2014)",1500000,null,"Fixed protection (FP)",1800000,1800000]
[null,"Fixed protection 2016 (FP 2016)",1250000,null,"Fixed protection 2014 (FP 2014)",1500000,1500000]
[null,"Individual protection 2014 (IP 2014)",null,null,"Fixed protection 2016 (FP 2016)",1250000,1250000]
[null,"Individual protection 2016 (IP 2016)"]

{"sheet":"VersionHistory","index":15,"n_rows":29,"n_cols":4,"rows_kept":29,"cut":false,"hidden":false,"merged":[]}
["Version","Date","Author","Comments"]
[1,"2022-04-28","Amrita Panja","Intial version: Calculates Life Time Allowance, LACs and LCLS"]
[1.01,"2023-03-21","Amrita Panja","TAX Year Update: 2023\nLTA TAble\nUpdate NMPA and LTA"]
[1.02,"2024-02-23","Amrita Panja","LSA_to_LTA\nAdded new worksheet to convert LSA to LTA"]
[null,null,null,"Input_Output_LSA\nAdded new worksheet to calculate LSA and LSDBA remaining"]
[null,null,null,"LSA Table\nAdded new worksheet to store LSA from 06/04/2024 onwards"]
[null,null,null,"LSDBA Table\nAdded new worksheet to store LSDBA from 06/04/2024 onwards"]
[null,null,null,"Protection Table\nAdded new worksheet to store protection amounts for all protection types and range of permitted protection amounts for protections where amoungt is not a single value"]
[null,null,null,"IntermediateCalcs\nAdded named range LTA_after_5April in cell B9 to show LTA% used up after 05/04/2024\nAdded named range LTA_at_5_April in cell B10 to show LTA% used up at 05/04/2024"]
[null,null,null,"Result\nAdded named range Res_LTA_after_5April in cell C79 to show LTA% used up after 05/04/2024 copied from 'IntermediateCalcs' by VBA\nAdded named range Res_LTA_at_5_April in cell C81 to show LTA% used up at 05/04/2024 copied from 'IntermediateCalcs' by VBA"]
[null,null,null,"VBA\nSee VBA mdlVersionHistory"]
["2.00","2024-03-26","Ade Brandwood","VBA Changes => \n* New module called mdl_User_View_Settings => This will set the view based on internal or external users. External users only see a simplied version of Input_Output_LSA and the cells are RL branded\n* Commented out the Workbook_BeforeSave \n* In Workbook_Open added a call to the new Set_User_View routine & removed the call to Protection_On (because Set_User_View uses Protection_Off and then Protection_On)\n* Protection_On and Protection_Off added a line to Protect / Unprotect the workbook\n\nWorkbook Changes =>\nInput_Output_LSA =>\n* LSA_Is_Protected cell set Wrap Text as a cell property\n* Deleted Comments from these cells:- LSA_DOB, LSA_Q_Date, LSA_Curr_LTA, B15, LSA_LTAAftApril\n* Added picture called RL_Logo\n* Created new named ranges called Hide_Externally_Rows & Hide_Externally_Columns\n* Set property on Userform LSA_Copy_Input in Format Control to \"don't move\"\n* Changed the range for Inputs_Fields on Input_Output_LSA to the below because it included some cells that were formulas\n=Input_Output_LSA!$C$6:$C$9,Input_Output_LSA!$C$12,Input_Output_LSA!$C$15:$C$17,Input_Output_LSA!$I$15,Input_Output_LSA!$I$17,Input_Output_LSA!$I$19:$I$21,Input_Output_LSA!$C$20:$C$22,Input_Output_LSA!$B$26:$D$56,Input_Output_LSA!$H$26:$I$56\n\nLSA_to_LTA =>\n* Added picture called RL_Logo"]
[2.0099999999999998,"2024-03-27","Ade Brandwood","VBA Changes => Commented out the Worksheet_Change routine for LSA_to_LTA worksheet\n\nLSA_to_LTA=> Inserted a new column to work out the tax year start year and changed the LTA % Used formula from:-\n=IF(B8=\"\",\"\",ROUND(IF(B8<LSA2LTA_AbolitionDate,C8/(0.25*(IF(LSA2LTA_Is_protection=\"No Protection\",VLOOKUP(IF(MONTH(B8)<4,YEAR(B8)-1,IF(AND(MONTH(B8)=4,DAY(B8)<6),YEAR(B8)-1,YEAR(B8))),LTA_Table,4),LSA2LTA_Prt_amt))),C8/IF(LSA2LTA_Is_protection=\"No Protection\",VLOOKUP(IF(MONTH(B8)<4,YEAR(B8)-1,IF(AND(MONTH(B8)=4,DAY(B8)<6),YEAR(B8)-1,YEAR(B8))),LSA_Table,4),(0.25*LSA2LTA_Prt_amt))),4))\nTo this:-\n=IF(OR($B9=\"\",LSA2LTA_Is_protection=\"\",ISNUMBER(Protected_LTA_To_Use)=FALSE),\"\",\nROUNDDOWN($C9/(IF(LEFT(LSA2LTA_Is_protection,2)=\"No\",IF($D9<YEAR(LSA2LTA_AbolitionDate),VLOOKUP($D9,LTA_Table,4,0)/4,VLOOKUP($D9,LSA_Table,4,1)),\nProtected_LTA_To_Use/4)),4))\n\nRemoved data validation from the LSA2LTA_Prt_amt input cell\nAdded named range called Protected_LTA_To_Use and this selected the LTA to use if there is Protection\nMoved the table to right of the LTA inputs and deleted 5 rows from the table so the LTA used result can be seen without having to scroll the page down.\n\n\nGlossary => New Workshet Added"]
[2.02,"2024-04-03","David Martin","Input_Output_LSA\nAltered formula in D65 to refer to LSA_Std_LTA_at6April instead of LSA_LSDBA_Reduced"]
[2.0299999999999998,"2024-04-19","Alan Maxwell","Input\nMinor wording changes to some headings and added a couple of comments to some table column headers - requested by Richard Cain (SCTASK0269050).\nAlso made minor update to ClearInputs in the VBA"]
[2.04,"2024-04-24","Amrita Panja","Input\nIncreased the pre and post A day table inputs from 50 lines to 600 lines\nAdjusted the named ranges Input_Fields, PosA_Events_Input_Table, PreA_Events_Input_Table, PreADay_BCE_Data, PostADay_BCE_Data\nIntermediateCalcs\nAdjusted the pre and post A day calculation area from 60 lines to 600 lines.\nVBA\nChanged in mdl_MainCalc in SortInput(), ClearInputs() and Main() to adjust ranges from 75 to 628\nChanged the auto populate DOB to less 55 years from current date instead of 50 years from current date\nChanges marked as AP 24/04"]
[2.0499999999999998,"2024-05-17","Amrita Panja","Input\nAdded 'Crest' to the list of product types"]
[2.06,"2024-05-17","Amrita Panja","FVSplit\nAdded new worksheet 'Fvsplit' to calculate the updated savings and IR account split upon exit\nDefined the following named range and corresponding label text\nBeforeExitIR at B2\nBeforeExitSavings at B3\nTotalFVBeforeExit at B4\nIRpct at C2\nSavingspct at C3\nActualExitValue at B7\nAdded formula in B4:  =SUM(BeforeExitIR,BeforeExitSavings)\nAdded formula in cell C2: =BeforeExitIR/TotalFVBeforeExit\nAdded formula in cell C3: =BeforeExitSavings/TotalFVBeforeExit\nAdded formula in cell B11: =ROUND(ActualExitValue*IRpct,2)\nAdded formula in cell B11: =ActualExitValue-B11\nVBA\nAdded sheet name FVSplit to sub routine Protection_On() in mdl_Protection\nChanges marked as '17-05-2024 AP'"]
[2.0699999999999998,"2024-05-17","Amrita Panja","Input_Output_LSA\nModify the formula at cell D65 from\n=IF(AND(LSA_SIHLtaken_beforeApril=\"Yes\",LSA_SIHL_LTA_beforeApr>0),(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April,0.25*(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April)\nTo\n=IF(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr >= 100%,LSA_Std_LTA_at6April,IF(AND(LSA_SIHLtaken_beforeApril=\"Yes\",LSA_SIHL_LTA_beforeApr>0),(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April,0.25*(LSA_LTAat5April+LSA_SIHL_LTA_beforeApr)*LSA_Std_LTA_at6April))"]
[2.08,"2024-06-12","Amrita Panja","Protection Table\nAdded rows for FP, FP14 and FP16 to Prot_Individual_table and adjusted the range of Prot_Individual_table to include new rows\nInput_Output_LSA\nUpdated error message in Data valiadtion for FP, FP14 and FP16"]
[2.09,"2024-07-16","David Martin","Input_Output_LSA\nAdded table RBCETypeValidList in N3:N5 with entries \"PCLS\", \"UFPLS\" and \"SALS\".  Named N5 ValidListSALS.\nAlter Data Validation Source in cells D26:D56 to =RBCETypeValidList.\nAdded formula in L26 =IF(D26=\"SALS\",C26,0.25*C26).  Filled down to L56.\nAdded formula in cell L57 =ROUND(SUM(L26:L56),2).  Named cell L57 LSDBA_PCLS_TFC_AftApril.\nHid columns L:N.\nAltered formula in cell D87 from =D65+LSA_PCLS_TFC_AftApril+PreCommPension+LSA_SIHL_Tot+I15+I17 to =D65+LSDBA_PCLS_TFC_AftApril+PreCommPension+LSA_SIHL_Tot+I15+I17.\nAltered formula in D85 from =MAX(0,LSA_LSDBA_Reduced-(D65+LSA_PCLS_TFC_AftApril+PreCommPension)) to =MAX(0,LSA_LSDBA_Reduced-(D65+LSDBA_PCLS_TFC_AftApril+PreCommPension)).\nVBA\nSee mdl_versionHistory."]
[2.1,"2025-01-08","Amrita Panja","Input_Output_LSA_SALS_SSTFC\nAdded this new worksheet. Added three inputs and four outputs to the sheet to calculate LSA and LSDBA for SALS and SSTFC\nInput_Output_LSA\nRemoved ‘SALS’ from the table RBCETypeValidList.\nDeleted named range ValidListSALS and LSDBA_PCLS_TFC_AftApril\nDeleted cell content from L25 to L57\nReverted the formula in cell D87 from =D65+LSDBA_PCLS_TFC_AftApril+PreCommPension+LSA_SIHL_Tot+I15+I17 to\n=D65+LSA_PCLS_TFC_AftApril+PreCommPension+LSA_SIHL_Tot+I15+I17\nReverted the formula in D85 from =MAX(0,LSA_LSDBA_Reduced-(D65+LSDBA_PCLS_TFC_AftApril+PreCommPension)) to\n=MAX(0,LSA_LSDBA_Reduced-(D65+LSA_PCLS_TFC_AftApril+PreCommPension))\nVBA\nCommented the block v2.09 as this is no longer required and added sheet name 'Input_Output_LSA_SALS_SSTFC' to sub routine Protection_On() in mdl_Protection and added subroutine SALS_SSTFC_Calculate() to calculate LSA and LSDBA for SALS and SSTFC"]
[2.2000000000000002,"2025-01-08","Amrita Panja","LSA Table\nCorrected typo in heading. Changed 'LTA Amount' to 'LSA Amount' at cell E2"]
[2.2999999999999998,"2025-03-04","David Martin","VBA\nSee VBA mdlVersionHistory - changes marked v2.3"]
[2.4,"2025-03-07","Amrita Panja","Input_Output_LSA\nMergde cell E87 to G93 and added the formula \n=IF(LSA_Total_LSDBA>VLOOKUP(IF(MONTH(LSA_Q_Date)<4,YEAR(LSA_Q_Date)-1,IF(AND(MONTH(LSA_Q_Date)=4,DAY(LSA_Q_Date)<6),YEAR(LSA_Q_Date)-1,YEAR(LSA_Q_Date))),LSDBA_Table,4),\"IF this is a SIHLS settlement and the customer has exceeded their LSDBA, please follow the exceptions SIHLS process AND update the Event 24 tracker held Here M:\\Customer Commitments\\01. RLI Servicing\\04. Transfers\\Event 24\")\nAdded label ‘LSA used Pre 06/04/2024’ at cell B95 and at cell D95 set formula to\n=D64 \nAdded label ‘LSA used Post 06/04/2024’ at cell B97 and at cell D97 set formula to\n=LSA_Total-D95\nAdded label ‘LSDBA used Pre 06/04/2024’ at cell B99 and at cell D99 set formula to\n=D65 \nAdded label ‘LSDBA used Post 06/04/2024’ at cell B101 and at cell D101 set formula to\n=LSA_Total_LSDBA-D99"]
[2.5,"2025-03-14","Amrita Panja","VBA\nSee VBA mdlVersionHistory - changes marked v2.5"]
[2.6,"2025-05-02","Amrita Panja","Input_Output_LSA\nUpdated warning message in cell J15 and J17 \nfrom 'Leave blank if transferring a Beneficiary IR (Ben IR)'\nwith following:\nLeave blank if;\n•\tTransferring a Beneficiary IR (Ben IR), or\n•\tCustomer is over 75 years old when they died, or\n•\tCustomer is under 75 when they died, however the bereavement claim is paid more than 2 years after notification of death"]
[2.7,"2025-06-11","Amrita Panja","Added two new sheets Current_LTA_Rebalance and TTFAC _Protection\nAdded input and output in these sheets for below:\nCalculate the LTA% Used by RLG @ Current date in Current_LTA_Rebalance sheet\nCalculate the LTA% Used by Other plan @ Current date in Current_LTA_Rebalance sheet\nCalculate the LTA% Used by This RLG policy @ 05/04/2024 in TTFAC _Protection sheet\nCalculate the LTA% Used by Other plans @ 05/04/2024 in TTFAC _Protection sheet\nCalculate the LSA amount Used by Other plans @ 05/04/2024 in TTFAC _Protection sheet"]
[2.8,"2025-08-19","Amrita Panja","VBA\nSee VBA mdlVersionHistory - changes marked v2.8"]