{"text_format":"1","workbook":"xlsx","n_sheets":9,"sheets":["Entry","Instructions","Calculations","FRE","Table 1B","Table 2B","Table 3B","Table 3C","CPI-U Index"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":16,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Entry","index":0,"n_rows":86,"n_cols":18,"rows_kept":86,"cut":false,"hidden":false,"merged":[[51,7,51,12],[47,7,47,12],[18,1,19,3],[45,7,45,12],[46,7,46,12],[49,7,49,12],[50,7,50,12],[43,7,43,12],[39,7,39,12],[34,7,37,12],[20,7,20,8],[22,7,22,8],[28,7,28,8],[29,7,29,8],[32,7,32,8],[25,7,25,8],[4,8,5,8],[4,9,5,9],[7,0,7,1],[8,0,8,1],[9,0,9,1],[1,13,2,13],[4,13,5,13],[13,0,13,1],[14,0,14,1],[17,0,17,1],[15,0,15,1],[16,0,16,1],[0,0,3,1],[7,2,7,5],[4,10,5,10],[4,11,5,11],[4,12,5,12],[1,7,2,12],[11,0,11,1],[12,0,12,1],[5,0,5,4],[40,7,40,12],[41,7,41,12],[42,7,42,12],[17,7,17,8],[18,7,18,8],[19,7,19,8],[30,7,30,8],[31,7,31,8],[26,7,26,8],[27,7,27,8],[23,7,23,8],[24,7,24,8]]}
["Accelerated Payment Estimator Tier 2",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"2011-01-01"]
[null,null,null,null,null,null,null,{"$f":"CONCATENATE(\"Accelerated Payment Estimate Calculation for \",PROPER(C8))","v":"Accelerated Payment Estimate Calculation for "},null,null,null,null,null,"Tier 2"]
[]
[]
[null,null,null,null,null,null,null,null,"Wage Period","Wages for Pension","Increase","Allowable Wage Increase","Excess","Wages as Entered"]
["Estimator only Applicable for Tier 2 Regular retirements (Not Applicable for ECO or SLEP)"]
[null,null,null,null,null,null,null,"Base Year",{"$f":"CONCATENATE(TEXT(VLOOKUP(1,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(12,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,1,FRE!$H$14:$H$133)","v":0},null,null,null,{"$f":"SUMIF(FRE!$A$14:$A$133,1,FRE!$D$14:$D$133)","v":0}]
["Member's Name",null,null,null,null,null,null,"Year 1",{"$f":"CONCATENATE(TEXT(VLOOKUP(13,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(24,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,2,FRE!$H$14:$H$133)","v":0},{"$f":"J8-J7","v":0},{"$f":"J7*Calculations!D56","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(13,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K8>L8,K8-L8,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,2,FRE!$D$14:$D$133)","v":0}]
["Member's Date of Birth",null,null,null,null,null,null,"Year 2",{"$f":"CONCATENATE(TEXT(VLOOKUP(25,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(36,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,3,FRE!$H$14:$H$133)","v":0},{"$f":"J9-J8","v":0},{"$f":"J8*Calculations!D57","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(25,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K9>L9,K9-L9,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,3,FRE!$D$14:$D$133)","v":0}]
["Member's Estimated Termination Date",null,null,null,null,null,null,"Year 3",{"$f":"CONCATENATE(TEXT(VLOOKUP(37,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(48,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,4,FRE!$H$14:$H$133)","v":0},{"$f":"J10-J9","v":0},{"$f":"J9*Calculations!D58","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(37,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K10>L10,K10-L10,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,4,FRE!$D$14:$D$133)","v":0}]
[null,"Include Wages for Month Following Termination",null,null,null,null,null,"Year 4",{"$f":"CONCATENATE(TEXT(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(60,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,5,FRE!$H$14:$H$133)","v":0},{"$f":"J11-J10","v":0},{"$f":"J10*Calculations!D59","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K11>L11,K11-L11,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,5,FRE!$D$14:$D$133)","v":0},null,null,null,0]
["Member's Estimated Retirement Date",null,{"$f":"Calculations!C7","v":"1962-02-01"},null,null,null,null,"Year 5",{"$f":"CONCATENATE(TEXT(VLOOKUP(61,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(72,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,6,FRE!$H$14:$H$133)","v":0},{"$f":"J12-J11","v":0},{"$f":"J11*Calculations!D60","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K12>L12,K12-L12,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,6,FRE!$D$14:$D$133)","v":0}]
["IMRF Service (at Retirement)",null,null,"Years",null,"Months",null,"Year 6",{"$f":"CONCATENATE(TEXT(VLOOKUP(73,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(84,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,7,FRE!$H$14:$H$133)","v":0},0,{"$f":"J12*Calculations!D61","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K13>L13,K13-L13,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,7,FRE!$D$14:$D$133)","v":0}]
["Unused/Unpaid Sick Days",null,null,"Days",null,null,null,"Year 7",{"$f":"CONCATENATE(TEXT(VLOOKUP(85,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(96,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,8,FRE!$H$14:$H$133)","v":0},0,{"$f":"J13*Calculations!D62","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K14>L14,K14-L14,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,8,FRE!$D$14:$D$133)","v":0}]
["Retirement Service Credit",null,{"$f":"Calculations!C24","v":0},null,null,null,null,"Year 8",{"$f":"CONCATENATE(TEXT(VLOOKUP(97,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"),\" - \",TEXT(VLOOKUP(108,FRE!$B$14:$C$133,2,FALSE),\"mmmm yyyy\"))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,9,FRE!$H$14:$H$133)","v":0},0,{"$f":"J14*Calculations!D63","v":{"$error":"#N/A"}},{"$f":"IF(VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)<$R$1,0,IF(K15>L15,K15-L15,0))","v":{"$error":"#N/A"}},{"$f":"SUMIF(FRE!$A$14:$A$133,9,FRE!$D$14:$D$133)","v":0}]
["Male/Female",null,null,null,null,null,null,null,null,{"$f":"SUM(J7:J15)","v":0},null,null,{"$f":"SUM(M7:M15)","v":{"$error":"#N/A"}},{"$f":"SUM(N7:N15)","v":0}]
["Marital Status (at Retirement)"]
["IMRF Service Type",null,"Regular",null,null,null,null,"Birth Date",null,{"$f":"C9","v":"00:00:00"}]
[null,{"$f":"\"Wages for \"&PROPER(C8)","v":"Wages for "},null,null,null,null,null,"Retirement Date",null,{"$f":"C12","v":"1962-02-01"}]
[null,null,null,null,null,null,null,"Member's Age",null,{"$f":"ROUND(Calculations!B15,3)","v":{"$error":"#VALUE!"}}]
[{"$f":"DATE(YEAR(A22),MONTH(A22)-1,DAY(A22))","v":{"$error":"#NUM!"}},0,null,{"$f":"DATE(YEAR(D22),MONTH(D22)-1,DAY(D22))","v":{"$error":"#NUM!"}},0,null,null,"IMRF Service at Retirement",null,{"$f":"Calculations!C21","v":0},"Years"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,null,null,{"$f":"Calculations!E21","v":0},"Months"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Male/Female",null,{"$f":"C16","v":0}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Marital Status at Retirement",null,{"$f":"C17","v":0}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"IMRF Service Type",null,{"$f":"C18","v":"Regular"}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Excess (AP Wages)",null,{"$f":"M16","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Divide by 96",null,{"$f":"J26/96","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Times Service Factor",null,{"$f":"IF(J25=\"Regular\",ROUND(Calculations!C37*Calculations!F32,5),Calculations!F37)","v":{"$error":"#VALUE!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Monthly Retirement from AP Wages",null,{"$f":"IF(J25=\"Regular\",ROUND(J27*Calculations!C37*Calculations!F32,2),ROUND(Entry!J27*Calculations!F37,2))","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,{"$f":"IF($J$33>=5000,3,IF(AND(Entry!$J$33<5000,Entry!$J$33>4500),2,1))","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Annuity Factor",null,{"$f":"Calculations!E45","v":{"$error":"#VALUE!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Increase to Present Value Caused by Excess",null,{"$f":"ROUND(J29*J30,0)","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Member Contributions on Excess",null,{"$f":"ROUND(Calculations!C48,0)","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"AP Amount",null,{"$f":"ROUND(J29*J30-Calculations!C48,0)","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,{"$f":"IF($J$33>=5000,Calculations!B53,IF(AND(Entry!$J$33<5000,Entry!$J$33>4500),Calculations!B52,Calculations!B51))","v":{"$error":"#N/A"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"The above estimate is based on information you entered. Wages before those entered have not been"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"considered for the 125% rule. The actual AP amount will be determined after IMRF reviews the final "]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"wages and may include wages after the month of termination and sick time converted to IMRF"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"service. The final AP uses the highest 96 months in the member's Final Rate of Earnings (FRE)"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"calculation, which may not be the last 96 months."]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,{"$f":"\"Please remember that the estimate and the original notice from IMRF may include \"&\"amounts for which \"","v":"Please remember that the estimate and the original notice from IMRF may include amounts for which "}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"you may claim an exclusion. Please review General Memorandum 620, for a list of exclusions that may"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"be claimed."]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,{"$f":"\"The Accelerated Payment (AP) is not a penalty and does not increase the cost to the employer. \"","v":"The Accelerated Payment (AP) is not a penalty and does not increase the cost to the employer. "}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"The AP only requires current funding for your employee's retirement that were based on reported wages"]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"that were above the normal actuarial assumptions."]
[{"$f":"DATE(YEAR(A54),MONTH(A54)-1,DAY(A54))","v":{"$error":"#NUM!"}},0,null,{"$f":"DATE(YEAR(D54),MONTH(D54)-1,DAY(D54))","v":{"$error":"#NUM!"}},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$f":"DATE(YEAR(D81),MONTH(D81)-1,DAY(D81))","v":{"$error":"#NUM!"}},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$f":"DATE(YEAR(D86),MONTH(D86)-1,DAY(D86))","v":{"$error":"#NUM!"}},0]
[{"$f":"DATE(YEAR(D21),MONTH(D21)-1,DAY(D21))","v":{"$error":"#NUM!"}},0,null,{"$f":"IF(R11=1,DATE(YEAR(C10),MONTH(C10)+1,DAY(1)),DATE(YEAR(C10),MONTH(C10),DAY(1)))","v":"1900-01-01"},0]

{"sheet":"Instructions","index":1,"n_rows":69,"n_cols":17,"rows_kept":69,"cut":false,"hidden":false,"merged":[[68,1,68,9],[52,2,52,9],[54,1,54,9],[56,1,56,9],[58,1,58,9],[62,1,62,9],[66,2,66,9],[48,1,48,9],[50,1,50,9],[33,1,33,6],[33,9,33,14],[31,1,31,6],[28,7,29,7],[28,8,29,8],[28,9,29,14],[31,9,31,14],[37,0,37,9],[28,1,29,6],[26,1,26,6],[9,0,10,6],[11,9,12,14],[0,0,0,9],[1,0,1,9],[2,1,2,8],[4,0,4,9],[5,0,5,9],[26,9,26,14],[16,1,18,6],[14,9,14,14],[16,9,18,14],[20,9,20,14],[22,9,22,14],[24,9,24,14],[11,7,12,7],[6,0,6,9],[14,1,14,6],[20,1,20,6],[22,1,22,6],[24,1,24,6],[11,1,12,6],[11,8,12,8],[16,7,18,7],[16,8,18,8]]}
["Accelerated Payment Estimator"]
["This spreadsheet was created to help employers estimate the amount of any Accelerated Payment (AP) that may arise due to higher than normal increases to reported wages. Please NOTE: The AP is not due at the time of the increase but only when the member retires. For additional information, including  exceptions to the AP, please review  the AP topic at "]
[null,"https://www.imrf.org/en/employers/employer-tasks/accelerated-payments"]
[]
["Special Situations May Affect This Estimator"]
["This spreadsheet only provides an estimate of a possible AP. Many variables can affect the actual AP; all of the variables could not be programmed into this spreadsheet."]
[" Your actual AP may be different, either higher or lower, than this estimate. "]
[]
["Please verify that this spreadsheet is appropriate for your specific situation"]
["THIS SPREADSHEET IS NOT PROGRAMMED TO ACCURATELY ESTIMATE AN AP WITH THIS CONDITION",null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"COUNTIF(P12:P36,\"=TRUE\")","v":0}]
[null,null,null,null,null,null,null,"YES","NO"]
[null,"Member will have more than 10 years of reported wages following the increase",null,null,null,null,null,null,null,"The AP calculation only considers wages in the final 10 years",null,null,null,null,null,false,false]
[]
[]
[null,"Member Participates in Tier 1",null,null,null,null,null,null,null,"This estimator is only meant for Tier 2 members",null,null,null,null,null,false,false]
[]
[null,"These wages will not be included in the member's Final Rate of Earnings (FRE) period (highest 48 months of last 120 months of wages)",null,null,null,null,null,null,null,"The AP calculation only considers wages within the FRE period",null,null,null,null,null,false,false]
[]
[]
[]
[null,"The annual increase in wages reported to IMRF is less than 6%",null,null,null,null,null,null,null,"An AP is only created if the annual increase is over 6%",null,null,null,null,null,false,false]
[]
[null,"Member has ECO or SLEP service",null,null,null,null,null,null,null,"Spreadsheet does not consider ECO or SLEP service, contact IMRF for estimate",null,null,null,null,null,false,false]
[]
[null,"Member participated in both Regular and SLEP plans with IMRF",null,null,null,null,null,null,null,"Mulitple plans may result in a unique benefit calculation",null,null,null,null,null,false,false]
[]
[null,"Member has reciprocal service",null,null,null,null,null,null,null,"IMRF service may not be accurate due to unkown details of reciprocal service",null,null,null,null,null,false,false]
[]
[null,"Member has been on disability in the last 10 years of service",null,null,null,null,null,null,null,"Disability claims may cause the member's service or wages to be different from what was reported during the member's disability",null,null,null,null,null,false,false]
[]
[]
[null,"Member has gaps in service and wages in the last 10 years",null,null,null,null,null,null,null,"Gaps will cause an inaccurate calculation of the excess wage amount",null,null,null,null,null,false,false]
[]
[null,"Member is purchasing ERI service",null,null,null,null,null,null,null,"Retirement age and benefit calculation may not be accurate due to ERI",null,null,null,null,null,false,false]
[]
[null,"Wages from before 2012 are included in the member's FRE",null,null,null,null,null,null,null,"This estimator will not be able to calculate a base yar for the AP Calculation",null,null,null,null,null,false,false]
[]
["This spreadsheet has certain limitations and cannot always produce an accurate estimate of an Accelerated Payment. Some of the reasons for these limitations are listed above. In addition, the accuracy of the estimate that is produced depends on the accuracy of the data you enter. This spreadsheet produces an estimate. The actual AP will be determined when a member retires and will be based on the IMRF records for the retiring member. In all cases, the requirements of the Illinois Pension Code will apply"]
[]
["Entering Your Data (Entry tab)"]
[]
["Start by clicking on the tab labeled \"Entry\""]
["You enter data in the yellow shaded fields.  "]
[]
["For each member, enter the following information:"]
[]
[null,"Member's date of birth (used to determine age at retirement)"]
[]
[null,"Member's Estimated Termination Date (used to determine age at retirement and the applicable months for which wages should be entered)"]
[]
[null,"IMRF Service (at retirement) - Enter the service in years and months and  include the member's future service up to the date of termination. You should also include the additional service credit that will be granted for unused/unpaid sick time. (One month is granted for each 20 days  - e.g. 21 to 40 days becomes 2 months) "]
[]
[null,null,"Note: If the member worked for another IMRF or reciprocal employer, you need to include all of the member's service for the most accurate estimate."]
[]
[null,"Male/Female (used to determine the appropriate Present Value table) - select from the list."]
[]
[null,"Marital Status (used to determine the appropriate Present Value table)  - select from the list."]
[]
[null,"IMRF Service Type (used to determine the appropriate pension formula) - select from the list."]
[]
[]
[null,"Monthly Wages"]
[null,"Based on the date entered as the estimated termination date, the spreadsheet will determine the months where wages should be entered."]
[]
[null,null,"For each month in the past, enter the wages that were reported to IMRF."]
[]
[null,null,"For each month in the future, determine the number of payrolls for that month and the projected earnings that will be reported to IMRF."]
[]
[null,"You can view a monthly breakdown of a member's reported wages on the employer copy of the annual member's statement which can be found in the document archive in Employer Access or by viewing your monthly wage report."]

{"sheet":"Calculations","index":2,"n_rows":63,"n_cols":10,"rows_kept":63,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Male","Regular","Married"]
[null,"Initial Retirement Date",{"$f":"DATE(YEAR(Entry!C10),MONTH(Entry!C10)+1,DAY(1))","v":"1900-02-01"},null,"Female","SLEP","Single"]
[null,null,null,null,null,null,"Divorced"]
[null,"RG01 Retirement Date",{"$f":"DATE(YEAR($C$9)+62,MONTH($C$9)+1,DAY(1))","v":"1962-02-01"},null,null,null,"Widowed"]
[null,"SLEP Retirement Date",{"$f":"DATE(YEAR($C$9)+50,MONTH($C$9)+1,DAY(1))","v":"1950-02-01"}]
[]
[null,"Calculated Retirment Date",{"$f":"IF(AND(Entry!C18=\"Regular\",Calculations!C2<Calculations!C4),Calculations!C4,IF(AND(Entry!C18=\"SLEP\",Calculations!C2<Calculations!C5),Calculations!C5,Calculations!C2))","v":"1962-02-01"}]
[]
[null,"Birth Date",{"$f":"Entry!C9","v":"00:00:00"}]
[]
[null,"AGE CALCULATION",null,"2010-12-31"]
[null,{"$f":"YEAR(C7)-YEAR(C9)","v":62},null,{"$f":"DATEVALUE(MONTH(C9)&\"/\"&DAY(C9)&\"/\"&2011)","v":{"$error":"#VALUE!"}},{"$f":"D12-D$11","v":{"$error":"#VALUE!"}}]
[null,{"$f":"IF(E13>E12,(E13-E12)/365,((E12-E13)/365)*-1)","v":{"$error":"#VALUE!"}},null,{"$f":"DATEVALUE(MONTH(C7)&\"/\"&DAY(C7)&\"/\"&2011)","v":"2011-02-01"},{"$f":"D13-D$11","v":32}]
[]
[null,{"$f":"B12+B13","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,0,0]
[null,"CALCULATE RETIREMENT SERVICE",null,null,null,null,null,null,1,8.3000000000000004E-2]
[null,"Service",{"$f":"Entry!C13","v":0},"years",{"$f":"Entry!E13","v":0},"Months",null,null,2,0.16700000000000001]
[null,"svc fr unused sick",null,null,{"$f":"ROUNDUP(Entry!C14/20,0)","v":0},null,null,null,3,0.25]
[null,"pass 1",null,null,{"$f":"E18+E19","v":0},null,null,null,4,0.33300000000000002]
[null,"Retirement Svc",{"$f":"IF(AND(Entry!C18=\"Regular\",IF(E20>11,C18+1,C18)>40),40,IF(AND(Entry!C18=\"SLEP\",IF(E20>11,C18+1,C18)>32),32,IF(E20>11,C18+1,C18)))","v":0},"years",{"$f":"IF(AND(Entry!C18=\"Regular\",C21=40),0,IF(AND(Entry!C18=\"SLEP\",Calculations!C21=32),0,IF(E20>11,E20-12,E20)))","v":0},"Months",null,null,5,0.41699999999999998]
[null,null,null,null,null,null,null,null,6,0.5]
[null,null,null,null,null,null,null,null,7,0.58299999999999996]
[null,"IMRF Service",{"$f":"C21+VLOOKUP(E21,I16:J28,2,FALSE)","v":0},null,null,null,null,null,8,0.66700000000000004]
[null,null,null,null,null,null,null,null,9,0.75]
[null,null,null,null,null,null,null,null,10,0.83299999999999996]
[null,"AGE/SERVICE REDUCTION",null,null,null,null,null,null,11,0.91700000000000004]
[null,"REGULAR (AGE)","SLEP (AGE)","SERVICE",null,null,null,null,12,1]
[null,{"$f":"67-B15","v":{"$error":"#VALUE!"}},{"$f":"55-B15","v":{"$error":"#VALUE!"}},{"$f":"35-C24","v":35}]
[null,{"$f":"B29*6","v":{"$error":"#VALUE!"}},{"$f":"C29*6","v":{"$error":"#VALUE!"}},{"$f":"D29*6","v":210}]
[null,{"$f":"100-B30","v":{"$error":"#VALUE!"}},{"$f":"100-C30","v":{"$error":"#VALUE!"}},{"$f":"100-D30","v":-110}]
[null,{"$f":"MIN(B31/100,1)","v":{"$error":"#VALUE!"}},{"$f":"MIN(C31/100,1)","v":{"$error":"#VALUE!"}},{"$f":"MIN(D31/100,1)","v":-1.1000000000000001},null,{"$f":"IF(Entry!C18=\"REGULAR\",MAX(B32,D32),MAX(Calculations!C32,Calculations!D32))","v":{"$error":"#VALUE!"}}]
[]
[null,"SERVICE FACTORS (BEFORE REDUCTION)"]
[null,"0-15",{"$f":"IF(C24>15,0.25005,ROUND(C24*0.01667,5))","v":0},null,2.5000000000000001E-2,{"$f":"IF(ROUND(C24*0.025,5)>0.8,0.8,ROUND(C24*0.025,5))","v":0}]
[null,"15 +",{"$f":"IF(C24<15,0,ROUND((C24-15)*0.02,5))","v":0}]
[null,null,{"$f":"IF((C35+C36)>0.75,0.75,C35+C36)","v":0},null,null,{"$f":"F35","v":0}]
[]
[]
[null,"ANNUITY FACTOR"]
[null,null,"Male","Female"]
[null,"Elig Sps",{"$f":"'Table 1B'!L4","v":{"$error":"#VALUE!"}},{"$f":"'Table 3C'!K9","v":{"$error":"#VALUE!"}}]
[null,"No Sps",{"$f":"'Table 2B'!L4","v":{"$error":"#VALUE!"}},{"$f":"'Table 3B'!L4","v":{"$error":"#VALUE!"}}]
[]
[null,"Selected",{"$f":"IF(Entry!$C$17=\"Married\",Calculations!C42,Calculations!C43)","v":{"$error":"#VALUE!"}},{"$f":"IF(Entry!$C$17=\"Married\",Calculations!D42,Calculations!D43)","v":{"$error":"#VALUE!"}},{"$f":"IF(Entry!C16=\"Male\",Calculations!C45,Calculations!D45)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Contributions on Excess",{"$f":"ROUND(IF(AND(Entry!C18=\"Regular\",Entry!C17=\"Married\"),Entry!M16*0.045,IF(AND(Entry!C18=\"Regular\",Entry!C17=\"Single\"),Entry!M16*0.0375,IF(AND(Entry!C18=\"SLEP\",Entry!C17=\"Married\"),Entry!M16*0.075,IF(AND(Entry!C18=\"SLEP\",Entry!C17=\"Single\"),Entry!M16*0.0675,Entry!M16*0.045)))),2)","v":{"$error":"#N/A"}}]
[]
[]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR\"&\" \"&UPPER(Entry!C8)&\" \"&\"WILL BE \"&TEXT(Entry!J33,\"$0,0.00\")&\". IMRF WILL NOT ISSUE ISSUE AN INVOICE IF THE ACTUAL AP IS LESS THAN $5,000.00\"","v":{"$error":"#N/A"}}]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR \"&UPPER(Entry!C8)&\" WILL BE \"&TEXT(Entry!J33,\"$0,0.00\")&\". IMRF WILL NOT ISSUE AN INVOICE FOR AN ACTUAL AP THAT IS LESS THAN $5,000.00.  THIS ESTIMATE IS WITHIN \"&TEXT(5000-Entry!J33,\"$0,0.00\")&\" OF $5,000.00, PLEASE CONTACT IMRF TO VERIFY ACCURACY OF THIS ESTIMATE\"","v":{"$error":"#N/A"}}]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR \"&UPPER(Entry!C8)&\" WILL BE \"&TEXT(Entry!J33,\"$0,0.00\")","v":{"$error":"#N/A"}}]
[]
[null,{"$f":"VLOOKUP(1,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(12,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(13,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(24,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$A$2:$N$44,14,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(25,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(36,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$B$2:$N$44,13,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(37,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(48,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$C$2:$N$44,12,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(60,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$D$2:$N$44,11,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(61,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(72,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$E$2:$N$44,10,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(73,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(84,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$F$2:$N$44,9,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(85,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(96,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$G$2:$N$44,8,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(97,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(108,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$H$2:$N$44,7,FALSE)","v":{"$error":"#N/A"}}]

{"sheet":"FRE","index":3,"n_rows":135,"n_cols":12,"rows_kept":135,"cut":false,"hidden":true,"merged":[]}
[null,"Count","Month/Year","Wages","125% Rule Max","125% of  Max","48 Month Total","FRE Wage","Annual FRE","Monthly FRE","48 Month Start",{"$f":"CONCATENATE(L59,\" \",L60)","v":" "}]
[{"$f":"INT((B2+11)/12)","v":0},{"$f":"IF(AND(L108=\"\",L109=\" MAX\"),1,IF(AND(B1>=1,B1<109),B1+1,0))","v":0},{"$f":"Entry!A21","v":{"$error":"#NUM!"}},{"$f":"Entry!B21","v":0},null,null,null,{"$f":"IF(AND($D2>$F5,$L5=\" MAX\"),$F5,IF(AND($D2>$F4,$L4=\" MAX\"),$F4,IF(AND($D2>$F3,$L3=\" MAX\"),$F3,IF(AND($D2>$F2,$L2=\" MAX\"),$F2,$D2))))","v":0}]
[0,{"$f":"IF(AND(L109=\"\",L110=\" MAX\"),1,IF(AND(B2>=1,B2<109),B2+1,0))","v":0},{"$f":"Entry!A22","v":{"$error":"#NUM!"}},{"$f":"Entry!B22","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A23","v":{"$error":"#NUM!"}},{"$f":"Entry!B23","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A24","v":{"$error":"#NUM!"}},{"$f":"Entry!B24","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A25","v":{"$error":"#NUM!"}},{"$f":"Entry!B25","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A26","v":{"$error":"#NUM!"}},{"$f":"Entry!B26","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A27","v":{"$error":"#NUM!"}},{"$f":"Entry!B27","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A28","v":{"$error":"#NUM!"}},{"$f":"Entry!B28","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A29","v":{"$error":"#NUM!"}},{"$f":"Entry!B29","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A30","v":{"$error":"#NUM!"}},{"$f":"Entry!B30","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A31","v":{"$error":"#NUM!"}},{"$f":"Entry!B31","v":0},null,null,null,0]
[0,0,{"$f":"Entry!A32","v":{"$error":"#NUM!"}},{"$f":"Entry!B32","v":0},null,null,null,0]
[0,0,{"$f":"DATE(YEAR(C15),MONTH(C15)-1,DAY(C15))","v":{"$error":"#NUM!"}},{"$f":"Entry!B33","v":0},null,null,null,0]
[0,0,{"$f":"DATE(YEAR(C16),MONTH(C16)-1,DAY(C16))","v":{"$error":"#NUM!"}},{"$f":"Entry!B34","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B35","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B36","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B37","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B38","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B39","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B40","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B41","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B42","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B43","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B44","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B45","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B46","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B47","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B48","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B49","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B50","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B51","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B52","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B53","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B54","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B55","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B56","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B57","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B58","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B59","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B60","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B61","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B62","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B63","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B64","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B65","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B66","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B67","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B68","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B69","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B70","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B71","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B72","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B73","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B74","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B75","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B76","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B77","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B78","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B79","v":0},null,null,null,0]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B80","v":0},null,null,null,0,null,null,null,{"$f":"IF(G61=G$135,\" MAX\",\"\")","v":" MAX"}]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B81","v":0},null,null,null,0,null,null,null,{"$f":"IF(G62=G$135,\" MAX\",\"\")","v":" MAX"}]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B82","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B83","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B84","v":0},null,null,null,0,null,null,null," MAX"]
[{"$f":"INT((B66+11)/12)","v":0},0,{"$error":"#NUM!"},{"$f":"Entry!B85","v":0},null,null,null,{"$f":"IF(AND($D66>$F69,$L69=\" MAX\"),$F69,IF(AND($D66>$F68,$L68=\" MAX\"),$F68,IF(AND($D66>$F67,$L67=\" MAX\"),$F67,IF(AND($D66>$F66,$L66=\" MAX\"),$F66,$D66))))","v":0},null,null,null," MAX"]
[0,{"$f":"IF(AND(L173=\"\",L174=\" MAX\"),1,IF(AND(B66>=1,B66<109),B66+1,0))","v":0},{"$error":"#NUM!"},{"$f":"Entry!B86","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E21","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E22","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E23","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E24","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E25","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E26","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E27","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E28","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E29","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E30","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E31","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$f":"DATE(YEAR(C80),MONTH(C80)-1,DAY(C80))","v":{"$error":"#NUM!"}},{"$f":"Entry!E32","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E33","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E34","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E35","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E36","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E37","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E38","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E39","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E40","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E41","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E42","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E43","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E44","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E45","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E46","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E47","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E48","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E49","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E50","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E51","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E52","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E53","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E54","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E55","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E56","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E57","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E58","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E59","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E60","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E61","v":0},null,null,null,0,null,null,null," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E62","v":0},{"$f":"MAX($D14:$D106)","v":0},{"$f":"ROUND(E109*1.25,2)","v":0},{"$f":"SUM(D14:D106)+ MIN(IF(ISBLANK(D107),0,D107),F109)+MIN(IF(ISBLANK(D108),0,D108),F109)+MIN(IF(ISBLANK(D108),0,D109),F109)","v":0},0,{"$f":"ROUND(G109/8,2)","v":0},{"$f":"ROUND(G109/96,2)","v":0},{"$f":"C62","v":{"$error":"#NUM!"}}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E63","v":0},{"$f":"MAX($D15:$D107)","v":0},0,{"$f":"SUM(D15:D107)+ MIN(IF(ISBLANK(D108),0,D108),F110)+MIN(IF(ISBLANK(D109),0,D109),F110)+MIN(IF(ISBLANK(D109),0,D110),F110)","v":0},0,{"$f":"ROUND(G110/8,2)","v":0},{"$f":"ROUND(G110/96,2)","v":0},{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E64","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E65","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E66","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E67","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E68","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E69","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E70","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E71","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E72","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E73","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E74","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E75","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E76","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E77","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E78","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E79","v":0},0,{"$f":"ROUND(E126*1.25,2)","v":0},0,0,0,0,{"$f":"C79","v":{"$error":"#NUM!"}},{"$f":"IF(G126=G$135,\" MAX\",\"\")","v":" MAX"}]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E80","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E81","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E82","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[{"$f":"INT((B130+11)/12)","v":0},0,{"$error":"#NUM!"},{"$f":"Entry!E83","v":0},0,0,0,{"$f":"IF(AND($D130>$F133,$L133=\" MAX\"),$F133,IF(AND($D130>$F132,$L132=\" MAX\"),$F132,IF(AND($D130>$F131,$L131=\" MAX\"),$F131,IF(AND($D130>$F130,$L130=\" MAX\"),$F130,$D130))))","v":0},0,0,{"$error":"#NUM!"}," MAX"]
[0,{"$f":"IF(AND(L237=\"\",L238=\" MAX\"),1,IF(AND(B130>=1,B130<109),B130+1,0))","v":0},{"$error":"#NUM!"},{"$f":"Entry!E84","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$f":"DATE(YEAR(C133),MONTH(C133)-1,DAY(C133))","v":{"$error":"#NUM!"}},{"$f":"Entry!E85","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$f":"IF(Entry!R11=1,DATE(YEAR(Entry!C10),MONTH(Entry!C10)+1,DAY(1)),DATE(YEAR(Entry!C10),MONTH(Entry!C10),DAY(1)))","v":"1900-01-01"},{"$f":"Entry!E86","v":0},0,{"$f":"ROUND(E133*1.25,2)","v":0},0,{"$f":"IF(AND($D133>$F136,$L136=\" MAX\"),$F136,IF(AND($D133>$F135,$L135=\" MAX\"),$F135,IF(AND($D133>$F134,$L134=\" MAX\"),$F134,IF(AND($D133>$F133,$L133=\" MAX\"),$F133,$D133))))","v":0},0,0,{"$error":"#NUM!"}," MAX"]
[]
[null,null,null,null,null,null,{"$f":"MAX(G109:G133)","v":0}]

{"sheet":"Table 1B","index":4,"n_rows":129,"n_cols":12,"rows_kept":129,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Illinois Municipal Retirement Fund",null,null,null,"Table 1B - Tier 2 Only",null,null,"2018 table"]
[]
[null,null,null,null,"FACTOR FOR DETERMINING THE COST OF FORMULA LIFE ANNUITY PAYABLE TO ",null,null,null,null,null,"Age",{"$f":"Calculations!B15","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"MALE EMPLOYEES WITH ELIGIBLE SPOUSE TERMINATING ON OR AFTER",null,null,null,null,null,"Factor",{"$f":"VLOOKUP(INT(L3),B60:D129,2)-ROUND(((L3-INT(L3))*VLOOKUP(INT(L3),B60:D129,3)),5)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"SEPTEMBER 8, 1971*",null,null,null,null,null,"Mtly Bft",1388]
[null,null,null,null,null,null,null,null,null,null,"PV",{"$f":"ROUND(L4*L5,2)","v":{"$error":"#VALUE!"}}]
[null,"Age","Factor","Difference",null,"Age","Factor","Difference"]
[]
[null,30,167.76,0.26999999999998181,null,65,147.38,0.96999999999999886]
[null,31,167.49,0.28000000000000114,null,66,146.41,2.4799999999999898]
[null,32,167.21,0.29000000000002046,null,67,143.93,2.5900000000000034]
[null,33,166.92,0.30999999999997385,null,68,141.34,2.7000000000000171]
[null,34,166.61,0.33000000000001251,null,69,138.63999999999999,2.7999999999999829]
[null,35,166.28,0.34999999999999432,null,70,135.84,2.9200000000000159]
[null,36,165.93,0.37000000000000455,null,71,132.91999999999999,3.0300000000000011]
[null,37,165.56,0.40000000000000568,null,72,129.88999999999999,3.1299999999999812]
[null,38,165.16,0.41999999999998749,null,73,126.76,3.230000000000004]
[null,39,164.74,0.45000000000001705,null,74,123.53,3.3299999999999983]
[null,40,164.29,0.46999999999999886,null,75,120.2,3.4300000000000068]
[null,41,163.82,0.50999999999999091,null,76,116.77,3.5099999999999909]
[null,42,163.31,0.53999999999999204,null,77,113.26,3.5900000000000034]
[null,43,162.77000000000001,0.58000000000001251,null,78,109.67,3.6599999999999966]
[null,44,162.19,0.60999999999998522,null,79,106.01,3.7199999999999989]
[null,45,161.58000000000001,0.64000000000001478,null,80,102.29,3.7600000000000051]
[null,46,160.94,0.65000000000000568,null,81,98.53,3.7999999999999972]
[null,47,160.29,0.65000000000000568,null,82,94.73,3.8100000000000023]
[null,48,159.63999999999999,0.65999999999999659,null,83,90.92,3.8100000000000023]
[null,49,158.97999999999999,0.62999999999999545,null,84,87.11,3.7900000000000063]
[null,50,158.35,0.57999999999998408,null,85,83.32,3.7599999999999909]
[null,51,157.77000000000001,0.61000000000001364,null,86,79.56,3.7000000000000028]
[null,52,157.16,0.62999999999999545,null,87,75.86,3.6400000000000006]
[null,53,156.53,0.65000000000000568,null,88,72.22,3.5499999999999972]
[null,54,155.88,0.65999999999999659,null,89,68.67,3.4399999999999977]
[null,55,155.22,0.66999999999998749,null,90,65.23,3.3200000000000074]
[null,56,154.55000000000001,0.68999999999999773,null,91,61.91,3.1899999999999977]
[null,57,153.86000000000001,0.72000000000002728,null,92,58.72,3.0499999999999972]
[null,58,153.13999999999999,0.72999999999998977,null,93,55.67,2.9100000000000037]
[null,59,152.41,0.75999999999999091,null,94,52.76,2.7800000000000011]
[null,60,151.65,0.78999999999999204,null,95,49.98,2.6599999999999966]
[null,61,150.86000000000001,0.81000000000000227,null,96,47.32,2.5200000000000031]
[null,62,150.05000000000001,0.85000000000002274,null,97,44.8,2.4099999999999966]
[null,63,149.19999999999999,0.88999999999998636,null,98,42.39,2.2899999999999991]
[null,64,148.31,0.93000000000000682,null,99,40.1,2.1799999999999997]
[null,null,null,null,null,100,35.29]
["* Factor applied to regular annuity.  Includes 3% annuity increment"]
[]
["Males: 120% of RP 2000 male table at 7.5% interest projected to 2020"]
["Females: 92% of RP 2000 female table at 7.5% interest projected to 2020"]
["Females assumed to be 5 years younger than spouse."]
["Payments assumed to be made beginning of the month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B9","v":30},167.76,0.26999999999998181]
[null,{"$f":"B10","v":31},167.49,0.28000000000000114]
[null,{"$f":"B11","v":32},167.21,0.29000000000002046]
[null,{"$f":"B12","v":33},166.92,0.30999999999997385]
[null,{"$f":"B13","v":34},166.61,0.33000000000001251]
[null,{"$f":"B14","v":35},166.28,0.34999999999999432]
[null,{"$f":"B15","v":36},165.93,0.37000000000000455]
[null,{"$f":"B16","v":37},165.56,0.40000000000000568]
[null,{"$f":"B17","v":38},165.16,0.41999999999998749]
[null,{"$f":"B18","v":39},164.74,0.45000000000001705]
[null,{"$f":"B19","v":40},164.29,0.46999999999999886]
[null,{"$f":"B20","v":41},163.82,0.50999999999999091]
[null,{"$f":"B21","v":42},163.31,0.53999999999999204]
[null,{"$f":"B22","v":43},162.77000000000001,0.58000000000001251]
[null,{"$f":"B23","v":44},162.19,0.60999999999998522]
[null,{"$f":"B24","v":45},161.58000000000001,0.64000000000001478]
[null,{"$f":"B25","v":46},160.94,0.65000000000000568]
[null,{"$f":"B26","v":47},160.29,0.65000000000000568]
[null,{"$f":"B27","v":48},159.63999999999999,0.65999999999999659]
[null,{"$f":"B28","v":49},158.97999999999999,0.62999999999999545]
[null,{"$f":"B29","v":50},158.35,0.57999999999998408]
[null,{"$f":"B30","v":51},157.77000000000001,0.61000000000001364]
[null,{"$f":"B31","v":52},157.16,0.62999999999999545]
[null,{"$f":"B32","v":53},156.53,0.65000000000000568]
[null,{"$f":"B33","v":54},155.88,0.65999999999999659]
[null,{"$f":"B34","v":55},155.22,0.66999999999998749]
[null,{"$f":"B35","v":56},154.55000000000001,0.68999999999999773]
[null,{"$f":"B36","v":57},153.86000000000001,0.72000000000002728]
[null,{"$f":"B37","v":58},153.13999999999999,0.72999999999998977]
[null,{"$f":"B38","v":59},152.41,0.75999999999999091]
[null,{"$f":"B39","v":60},151.65,0.78999999999999204]
[null,{"$f":"B40","v":61},150.86000000000001,0.81000000000000227]
[null,{"$f":"B41","v":62},150.05000000000001,0.85000000000002274]
[null,{"$f":"B42","v":63},149.19999999999999,0.88999999999998636]
[null,{"$f":"B43","v":64},148.31,0.93000000000000682]
[null,{"$f":"F9","v":65},{"$f":"G9","v":147.38},{"$f":"H9","v":0.96999999999999886}]
[null,{"$f":"F10","v":66},146.41,2.4799999999999898]
[null,{"$f":"F11","v":67},143.93,2.5900000000000034]
[null,{"$f":"F12","v":68},141.34,2.7000000000000171]
[null,{"$f":"F13","v":69},138.63999999999999,2.7999999999999829]
[null,{"$f":"F14","v":70},135.84,2.9200000000000159]
[null,{"$f":"F15","v":71},132.91999999999999,3.0300000000000011]
[null,{"$f":"F16","v":72},129.88999999999999,3.1299999999999812]
[null,{"$f":"F17","v":73},126.76,3.230000000000004]
[null,{"$f":"F18","v":74},123.53,3.3299999999999983]
[null,{"$f":"F19","v":75},120.2,3.4300000000000068]
[null,{"$f":"F20","v":76},116.77,3.5099999999999909]
[null,{"$f":"F21","v":77},113.26,3.5900000000000034]
[null,{"$f":"F22","v":78},109.67,3.6599999999999966]
[null,{"$f":"F23","v":79},106.01,3.7199999999999989]
[null,{"$f":"F24","v":80},102.29,3.7600000000000051]
[null,{"$f":"F25","v":81},98.53,3.7999999999999972]
[null,{"$f":"F26","v":82},94.73,3.8100000000000023]
[null,{"$f":"F27","v":83},90.92,3.8100000000000023]
[null,{"$f":"F28","v":84},87.11,3.7900000000000063]
[null,{"$f":"F29","v":85},83.32,3.7599999999999909]
[null,{"$f":"F30","v":86},79.56,3.7000000000000028]
[null,{"$f":"F31","v":87},75.86,3.6400000000000006]
[null,{"$f":"F32","v":88},72.22,3.5499999999999972]
[null,{"$f":"F33","v":89},68.67,3.4399999999999977]
[null,{"$f":"F34","v":90},65.23,3.3200000000000074]
[null,{"$f":"F35","v":91},61.91,3.1899999999999977]
[null,{"$f":"F36","v":92},58.72,3.0499999999999972]
[null,{"$f":"F37","v":93},55.67,2.9100000000000037]
[null,{"$f":"F38","v":94},52.76,2.7800000000000011]
[null,{"$f":"F39","v":95},49.98,2.6599999999999966]
[null,{"$f":"F40","v":96},47.32,2.5200000000000031]
[null,{"$f":"F41","v":97},44.8,2.4099999999999966]
[null,{"$f":"F42","v":98},42.39,2.2899999999999991]
[null,{"$f":"F43","v":99},{"$f":"G43","v":40.1},{"$f":"H43","v":2.1799999999999997}]

{"sheet":"Table 2B","index":5,"n_rows":124,"n_cols":12,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Illinois Municipal Retirement Fund",null,null,null,"Table 2B - Tier 2 Only",null,null,"2018 Table"]
[]
[null,null,null,null,"FACTOR FOR DETERMINING THE COST OF FORMULA LIFE ANNUITY PAYABLE TO MALE",null,null,null,null,null,"Age",{"$f":"Calculations!B15","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EMPLOYEES WITHOUT ELIGIBLE SPOUSE TERMINATING ON OR AFTER SEPTEMBER 8, 1971*",null,null,null,null,null,"Factor",{"$f":"VLOOKUP(INT(L3),B55:D124,2)-ROUND(((L3-INT(L3))*VLOOKUP(INT(L3),B55:D124,3)),5)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Mtly Bft",1388]
[null,"Age","Factor","Difference",null,"Age","Factor","Difference",null,null,"PV",{"$f":"ROUND(L4*L5,2)","v":{"$error":"#VALUE!"}}]
[]
[null,30,162.44,0.56000000000000227,null,65,123.94,1.7199999999999989]
[null,31,161.88,0.59000000000000341,null,66,122.22,2.980000000000004]
[null,32,161.29,0.62999999999999545,null,67,119.24,3.0799999999999983]
[null,33,160.66,0.65999999999999659,null,68,116.16,3.1700000000000017]
[null,34,160,0.68999999999999773,null,69,112.99,3.25]
[null,35,159.31,0.74000000000000909,null,70,109.74,3.3299999999999983]
[null,36,158.57,0.76999999999998181,null,71,106.41,3.4099999999999966]
[null,37,157.80000000000001,0.83000000000001251,null,72,103,3.4699999999999989]
[null,38,156.97,0.87000000000000455,null,73,99.53,3.5400000000000063]
[null,39,156.1,0.93999999999999773,null,74,95.99,3.5899999999999892]
[null,40,155.16,0.99000000000000909,null,75,92.4,3.6200000000000045]
[null,41,154.16999999999999,1.0499999999999829,null,76,88.78,3.6500000000000057]
[null,42,153.12,1.1299999999999955,null,77,85.13,3.6700000000000017]
[null,43,151.99,1.2000000000000171,null,78,81.459999999999994,3.6599999999999966]
[null,44,150.79,1.2800000000000011,null,79,77.8,3.6400000000000006]
[null,45,149.51,1.3100000000000023,null,80,74.16,3.6099999999999994]
[null,46,148.19999999999999,1.3199999999999932,null,81,70.55,3.5499999999999972]
[null,47,146.88,1.3100000000000023,null,82,67,3.4600000000000009]
[null,48,145.57,1.2599999999999909,null,83,63.54,3.3699999999999974]
[null,49,144.31,1.1700000000000159,null,84,60.17,3.25]
[null,50,143.13999999999999,1,null,85,56.92,3.1099999999999994]
[null,51,142.13999999999999,1.0499999999999829,null,86,53.81,2.9699999999999989]
[null,52,141.09,1.0999999999999943,null,87,50.84,2.8200000000000003]
[null,53,139.99,1.1299999999999955,null,88,48.02,2.6500000000000057]
[null,54,138.86000000000001,1.160000000000025,null,89,45.37,2.4899999999999949]
[null,55,137.69999999999999,1.1999999999999886,null,90,42.88,2.3200000000000003]
[null,56,136.5,1.2299999999999898,null,91,40.56,2.1500000000000057]
[null,57,135.27000000000001,1.2600000000000193,null,92,38.409999999999997,2.009999999999998]
[null,58,134.01,1.289999999999992,null,93,36.4,1.9099999999999966]
[null,59,132.72,1.3300000000000125,null,94,34.49,1.8200000000000003]
[null,60,131.38999999999999,1.3699999999999761,null,95,32.67,1.7600000000000016]
[null,61,130.02000000000001,1.4200000000000159,null,96,30.91,1.6999999999999993]
[null,62,128.6,1.4799999999999898,null,97,29.21,1.6099999999999994]
[null,63,127.12,1.5500000000000114,null,98,27.6,1.5400000000000027]
[null,64,125.57,1.6299999999999955,null,99,26.06,1.4299999999999997]
[null,null,null,null,null,100,20.9]
["* Factor applied to regular annuity.  Includes 3% annuity increment"]
[]
["Males: 120% of RP 2000 male table at 7.5% interest projected to 2020"]
["Payments assumed to be made beginning of the month"]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B8","v":30},{"$f":"C8","v":162.44},0.56000000000000227]
[null,{"$f":"B9","v":31},161.88,0.59000000000000341]
[null,{"$f":"B10","v":32},161.29,0.62999999999999545]
[null,{"$f":"B11","v":33},160.66,0.65999999999999659]
[null,{"$f":"B12","v":34},160,0.68999999999999773]
[null,{"$f":"B13","v":35},159.31,0.74000000000000909]
[null,{"$f":"B14","v":36},158.57,0.76999999999998181]
[null,{"$f":"B15","v":37},157.80000000000001,0.83000000000001251]
[null,{"$f":"B16","v":38},156.97,0.87000000000000455]
[null,{"$f":"B17","v":39},156.1,0.93999999999999773]
[null,{"$f":"B18","v":40},155.16,0.99000000000000909]
[null,{"$f":"B19","v":41},154.16999999999999,1.0499999999999829]
[null,{"$f":"B20","v":42},153.12,1.1299999999999955]
[null,{"$f":"B21","v":43},151.99,1.2000000000000171]
[null,{"$f":"B22","v":44},150.79,1.2800000000000011]
[null,{"$f":"B23","v":45},149.51,1.3100000000000023]
[null,{"$f":"B24","v":46},148.19999999999999,1.3199999999999932]
[null,{"$f":"B25","v":47},146.88,1.3100000000000023]
[null,{"$f":"B26","v":48},145.57,1.2599999999999909]
[null,{"$f":"B27","v":49},144.31,1.1700000000000159]
[null,{"$f":"B28","v":50},143.13999999999999,1]
[null,{"$f":"B29","v":51},142.13999999999999,1.0499999999999829]
[null,{"$f":"B30","v":52},141.09,1.0999999999999943]
[null,{"$f":"B31","v":53},139.99,1.1299999999999955]
[null,{"$f":"B32","v":54},138.86000000000001,1.160000000000025]
[null,{"$f":"B33","v":55},137.69999999999999,1.1999999999999886]
[null,{"$f":"B34","v":56},136.5,1.2299999999999898]
[null,{"$f":"B35","v":57},135.27000000000001,1.2600000000000193]
[null,{"$f":"B36","v":58},134.01,1.289999999999992]
[null,{"$f":"B37","v":59},132.72,1.3300000000000125]
[null,{"$f":"B38","v":60},131.38999999999999,1.3699999999999761]
[null,{"$f":"B39","v":61},130.02000000000001,1.4200000000000159]
[null,{"$f":"B40","v":62},128.6,1.4799999999999898]
[null,{"$f":"B41","v":63},127.12,1.5500000000000114]
[null,{"$f":"B42","v":64},125.57,1.6299999999999955]
[null,{"$f":"F8","v":65},{"$f":"G8","v":123.94},{"$f":"H8","v":1.7199999999999989}]
[null,{"$f":"F9","v":66},122.22,2.980000000000004]
[null,67,119.24,3.0799999999999983]
[null,68,116.16,3.1700000000000017]
[null,69,112.99,3.25]
[null,70,109.74,3.3299999999999983]
[null,71,106.41,3.4099999999999966]
[null,72,103,3.4699999999999989]
[null,73,99.53,3.5400000000000063]
[null,74,95.99,3.5899999999999892]
[null,75,92.4,3.6200000000000045]
[null,76,88.78,3.6500000000000057]
[null,77,85.13,3.6700000000000017]
[null,78,81.459999999999994,3.6599999999999966]
[null,79,77.8,3.6400000000000006]
[null,80,74.16,3.6099999999999994]
[null,81,70.55,3.5499999999999972]
[null,82,67,3.4600000000000009]
[null,83,63.54,3.3699999999999974]
[null,84,60.17,3.25]
[null,85,56.92,3.1099999999999994]
[null,86,53.81,2.9699999999999989]
[null,87,50.84,2.8200000000000003]
[null,88,48.02,2.6500000000000057]
[null,89,45.37,2.4899999999999949]
[null,90,42.88,2.3200000000000003]
[null,91,40.56,2.1500000000000057]
[null,92,38.409999999999997,2.009999999999998]
[null,93,36.4,1.9099999999999966]
[null,94,34.49,1.8200000000000003]
[null,95,32.67,1.7600000000000016]
[null,96,30.91,1.6999999999999993]
[null,97,29.21,1.6099999999999994]
[null,98,27.6,1.5400000000000027]
[null,99,26.06,1.4299999999999997]

{"sheet":"Table 3B","index":6,"n_rows":124,"n_cols":12,"rows_kept":124,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Illinois Municipal Retirement Fund",null,null,null,"Table 3B - Tier 2 Only",null,null,"2018 Tables"]
[]
[null,null,null,null,"FACTOR FOR DETERMINING THE COST OF FORMULA LIFE ANNUITY PAYABLE TO FEMALE",null,null,null,null,null,"Age",{"$f":"Calculations!B15","v":{"$error":"#VALUE!"}}]
[null,null,null,null,"EMPLOYEES WITHOUT ELIGIBLE SPOUSE TERMINATING ON OR AFTER SEPTEMBER 8, 1971*",null,null,null,null,null,"Factor",{"$f":"VLOOKUP(INT(L3),B55:D124,2)-ROUND(((L3-INT(L3))*VLOOKUP(INT(L3),B55:D124,3)),5)","v":{"$error":"#VALUE!"}}]
[null,null,null,null,null,null,null,null,null,null,"Mtly Bft",1388]
[null,"Age","Factor","Difference",null,"Age","Factor","Difference",null,null,"PV",{"$f":"ROUND(L4*L5,2)","v":{"$error":"#VALUE!"}}]
[]
[null,30,null,0,null,65,138.02000000000001,1.4900000000000091]
[null,31,null,0,null,66,136.53,2.9099999999999966]
[null,32,null,0,null,67,133.62,3.0300000000000011]
[null,33,null,0,null,68,130.59,3.1300000000000097]
[null,34,null,0,null,69,127.46,3.25]
[null,35,164.28,0.47999999999998977,null,70,124.21,3.3499999999999943]
[null,36,163.80000000000001,0.52000000000001023,null,71,120.86,3.4500000000000028]
[null,37,163.28,0.53999999999999204,null,72,117.41,3.5499999999999972]
[null,38,162.74,0.59000000000000341,null,73,113.86,3.6400000000000006]
[null,39,162.15,0.61000000000001364,null,74,110.22,3.7199999999999989]
[null,40,161.54,0.65999999999999659,null,75,106.5,3.7800000000000011]
[null,41,160.88,0.71000000000000796,null,76,102.72,3.8499999999999943]
[null,42,160.16999999999999,0.75,null,77,98.87,3.9100000000000108]
[null,43,159.41999999999999,0.79999999999998295,null,78,94.96,3.9399999999999977]
[null,44,158.62,0.86000000000001364,null,79,91.02,3.9699999999999989]
[null,45,157.76,0.87999999999999545,null,80,87.05,3.9899999999999949]
[null,46,156.88,0.88999999999998636,null,81,83.06,3.9699999999999989]
[null,47,155.99,0.90000000000000568,null,82,79.09,3.9500000000000028]
[null,48,155.09,0.87999999999999545,null,83,75.14,3.9000000000000057]
[null,49,154.21,0.8200000000000216,null,84,71.239999999999995,3.8299999999999983]
[null,50,153.38999999999999,0.71999999999999886,null,85,67.41,3.7399999999999949]
[null,51,152.66999999999999,0.75999999999999091,null,86,63.67,3.6099999999999994]
[null,52,151.91,0.78999999999999204,null,87,60.06,3.4500000000000028]
[null,53,151.12,0.83000000000001251,null,88,56.61,3.2800000000000011]
[null,54,150.29,0.87000000000000455,null,89,53.33,3.0799999999999983]
[null,55,149.41999999999999,0.89999999999997726,null,90,50.25,2.8599999999999994]
[null,56,148.52000000000001,0.95000000000001705,null,91,47.39,2.6600000000000037]
[null,57,147.57,1,null,92,44.73,2.4899999999999949]
[null,58,146.57,1.039999999999992,null,93,42.24,2.3500000000000014]
[null,59,145.53,1.0999999999999943,null,94,39.89,2.25]
[null,60,144.43,1.1599999999999966,null,95,37.64,2.1700000000000017]
[null,61,143.27000000000001,1.210000000000008,null,96,35.47,2.0700000000000003]
[null,62,142.06,1.2800000000000011,null,97,33.4,1.9799999999999969]
[null,63,140.78,1.3499999999999943,null,98,31.42,1.8800000000000026]
[null,64,139.43,1.4099999999999966,null,99,29.54,1.7699999999999996]
[null,null,null,null,null,100,37.979999999999997]
["* Factor applied to regular annuity.  Includes 3% annuity increment"]
[]
["Females: 120% of RP 2000 female table at 7.5% interest projected to 2020"]
["Payments assumed to be made beginning of the month"]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B8","v":30},{"$f":"C8","v":0},0]
[null,{"$f":"B9","v":31},0,0]
[null,{"$f":"B10","v":32},0,0]
[null,{"$f":"B11","v":33},0,0]
[null,{"$f":"B12","v":34},0,0]
[null,{"$f":"B13","v":35},164.28,0.47999999999998977]
[null,{"$f":"B14","v":36},163.80000000000001,0.52000000000001023]
[null,{"$f":"B15","v":37},163.28,0.53999999999999204]
[null,{"$f":"B16","v":38},162.74,0.59000000000000341]
[null,{"$f":"B17","v":39},162.15,0.61000000000001364]
[null,{"$f":"B18","v":40},161.54,0.65999999999999659]
[null,{"$f":"B19","v":41},160.88,0.71000000000000796]
[null,{"$f":"B20","v":42},160.16999999999999,0.75]
[null,{"$f":"B21","v":43},159.41999999999999,0.79999999999998295]
[null,{"$f":"B22","v":44},158.62,0.86000000000001364]
[null,{"$f":"B23","v":45},157.76,0.87999999999999545]
[null,{"$f":"B24","v":46},156.88,0.88999999999998636]
[null,{"$f":"B25","v":47},155.99,0.90000000000000568]
[null,{"$f":"B26","v":48},155.09,0.87999999999999545]
[null,{"$f":"B27","v":49},154.21,0.8200000000000216]
[null,{"$f":"B28","v":50},153.38999999999999,0.71999999999999886]
[null,{"$f":"B29","v":51},152.66999999999999,0.75999999999999091]
[null,{"$f":"B30","v":52},151.91,0.78999999999999204]
[null,{"$f":"B31","v":53},151.12,0.83000000000001251]
[null,{"$f":"B32","v":54},150.29,0.87000000000000455]
[null,{"$f":"B33","v":55},149.41999999999999,0.89999999999997726]
[null,{"$f":"B34","v":56},148.52000000000001,0.95000000000001705]
[null,{"$f":"B35","v":57},147.57,1]
[null,{"$f":"B36","v":58},146.57,1.039999999999992]
[null,{"$f":"B37","v":59},145.53,1.0999999999999943]
[null,{"$f":"B38","v":60},144.43,1.1599999999999966]
[null,{"$f":"B39","v":61},143.27000000000001,1.210000000000008]
[null,{"$f":"B40","v":62},142.06,1.2800000000000011]
[null,{"$f":"B41","v":63},140.78,1.3499999999999943]
[null,{"$f":"B42","v":64},139.43,1.4099999999999966]
[null,{"$f":"F8","v":65},{"$f":"G8","v":138.02000000000001},{"$f":"H8","v":1.4900000000000091}]
[null,{"$f":"F9","v":66},136.53,2.9099999999999966]
[null,67,133.62,3.0300000000000011]
[null,68,130.59,3.1300000000000097]
[null,69,127.46,3.25]
[null,70,124.21,3.3499999999999943]
[null,71,120.86,3.4500000000000028]
[null,72,117.41,3.5499999999999972]
[null,73,113.86,3.6400000000000006]
[null,74,110.22,3.7199999999999989]
[null,75,106.5,3.7800000000000011]
[null,76,102.72,3.8499999999999943]
[null,77,98.87,3.9100000000000108]
[null,78,94.96,3.9399999999999977]
[null,79,91.02,3.9699999999999989]
[null,80,87.05,3.9899999999999949]
[null,81,83.06,3.9699999999999989]
[null,82,79.09,3.9500000000000028]
[null,83,75.14,3.9000000000000057]
[null,84,71.239999999999995,3.8299999999999983]
[null,85,67.41,3.7399999999999949]
[null,86,63.67,3.6099999999999994]
[null,87,60.06,3.4500000000000028]
[null,88,56.61,3.2800000000000011]
[null,89,53.33,3.0799999999999983]
[null,90,50.25,2.8599999999999994]
[null,91,47.39,2.6600000000000037]
[null,92,44.73,2.4899999999999949]
[null,93,42.24,2.3500000000000014]
[null,94,39.89,2.25]
[null,95,37.64,2.1700000000000017]
[null,96,35.47,2.0700000000000003]
[null,97,33.4,1.9799999999999969]
[null,98,31.42,1.8800000000000026]
[null,99,29.54,1.7699999999999996]

{"sheet":"Table 3C","index":7,"n_rows":164,"n_cols":11,"rows_kept":164,"cut":false,"hidden":true,"merged":[]}
[null,null,null,null,"Illinois Municipal Retirement Fund",null,null,null,"Table 3C"]
[]
[null,null,null,null,"FACTOR FOR DETERMINING THE COST OF FORMULA LIFE ANNUITY PAYABLE TO FEMALE"]
[null,null,null,null,"EMPLOYEES WITH ELIGIBLE SPOUSE TERMINATING ON OR AFTER JULY 27, 1972*"]
[null,null,null,null,null,null,null,null,null,null,"2018 table"]
[null,"Age","Factor","Difference",null,"Age","Factor","Difference"]
[]
[null,35,167.15,0.31999999999999318,null,65,147.13999999999999,1.2199999999999989,null,"Age",{"$f":"Calculations!B15","v":{"$error":"#VALUE!"}}]
[null,36,166.83,0.35000000000002274,null,66,145.91999999999999,2.7299999999999898,null,"Factor",{"$f":"VLOOKUP(INT(K8),B100:D164,2)-ROUND(((K8-INT(K8))*VLOOKUP(INT(K8),B100:D164,3)),5)","v":{"$error":"#VALUE!"}}]
[null,37,166.48,0.35999999999998522,null,67,143.19,2.8499999999999943,null,"Mtly Bft",185.7]
[null,38,166.12,0.39000000000001478,null,68,140.34,2.9699999999999989,null,"PV",{"$f":"ROUND(K9*K10,2)","v":{"$error":"#VALUE!"}}]
[null,39,165.73,0.40999999999999659,null,69,137.37,3.0900000000000034]
[null,40,165.32,0.43999999999999773,null,70,134.28,3.1999999999999886]
[null,41,164.88,0.46999999999999886,null,71,131.08000000000001,3.3200000000000074]
[null,42,164.41,0.50999999999999091,null,72,127.76,3.4400000000000119]
[null,43,163.9,0.53000000000000114,null,73,124.32,3.539999999999992]
[null,44,163.37,0.58000000000001251,null,74,120.78,3.6400000000000006]
[null,45,162.79,0.59000000000000341,null,75,117.14,3.7399999999999949]
[null,46,162.19999999999999,0.61999999999997613,null,76,113.4,3.8200000000000074]
[null,47,161.58000000000001,0.63000000000002387,null,77,109.58,3.8999999999999915]
[null,48,160.94999999999999,0.62999999999999545,null,78,105.68,3.9700000000000131]
[null,49,160.32,0.62000000000000455,null,79,101.71,4.019999999999996]
[null,50,159.69999999999999,0.57999999999998408,null,80,97.69,4.0499999999999972]
[null,51,159.12,0.61000000000001364,null,81,93.64,4.0700000000000074]
[null,52,158.51,0.63999999999998636,null,82,89.57,4.0599999999999881]
[null,53,157.87,0.68000000000000682,null,83,85.51,4.0300000000000011]
[null,54,157.19,0.71000000000000796,null,84,81.48,3.9699999999999989]
[null,55,156.47999999999999,0.73999999999998067,null,85,77.510000000000005,3.9000000000000057]
[null,56,155.74,0.78000000000000114,null,86,73.61,3.7900000000000063]
[null,57,154.96,0.8200000000000216,null,87,69.819999999999993,3.6599999999999966]
[null,58,154.13999999999999,0.85999999999998522,null,88,66.16,3.5]
[null,59,153.28,0.90000000000000568,null,89,62.66,3.3199999999999932]
[null,60,152.38,0.94999999999998863,null,90,59.34,3.1200000000000045]
[null,61,151.43,0.99000000000000909,null,91,56.22,2.9499999999999957]
[null,62,150.44,1.0500000000000114,null,92,53.27,2.7800000000000011]
[null,63,149.38999999999999,1.0999999999999943,null,93,50.49,2.6600000000000037]
[null,64,148.29,1.1500000000000057,null,94,47.83,2.5599999999999952]
[null,null,null,null,null,95,45.27,2.490000000000002]
[null,null,null,null,null,96,42.78,2.3900000000000006]
[null,null,null,null,null,97,40.39,2.2899999999999991]
[null,null,null,null,null,98,38.1,2.1900000000000048]
[null,null,null,null,null,99,35.909999999999997,2.0599999999999952]
[null,null,null,null,null,100,40.68]
[]
["* Factor applied to regular annuity.  Includes 3% annuity increment"]
[]
["Males: 120% of RP 2000 male table at 7.5% interest projected to 2020"]
["Females: 92% of RP 2000 female table at 7.5% interest projected to 2020"]
["Females assumed to be same age as spouse"]
["Payments assumed to be made beginning of the month"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,{"$f":"B8","v":35},167.15,0.31999999999999318]
[null,36,166.83,0.35000000000002274]
[null,37,166.48,0.35999999999998522]
[null,38,166.12,0.39000000000001478]
[null,39,165.73,0.40999999999999659]
[null,40,165.32,0.43999999999999773]
[null,41,164.88,0.46999999999999886]
[null,42,164.41,0.50999999999999091]
[null,43,163.9,0.53000000000000114]
[null,44,163.37,0.58000000000001251]
[null,45,162.79,0.59000000000000341]
[null,46,162.19999999999999,0.61999999999997613]
[null,47,161.58000000000001,0.63000000000002387]
[null,48,160.94999999999999,0.62999999999999545]
[null,49,160.32,0.62000000000000455]
[null,50,159.69999999999999,0.57999999999998408]
[null,{"$f":"B24","v":51},159.12,0.61000000000001364]
[null,52,158.51,0.63999999999998636]
[null,53,157.87,0.68000000000000682]
[null,54,157.19,0.71000000000000796]
[null,55,156.47999999999999,0.73999999999998067]
[null,56,155.74,0.78000000000000114]
[null,57,154.96,0.8200000000000216]
[null,58,154.13999999999999,0.85999999999998522]
[null,59,153.28,0.90000000000000568]
[null,60,152.38,0.94999999999998863]
[null,61,151.43,0.99000000000000909]
[null,62,150.44,1.0500000000000114]
[null,63,149.38999999999999,1.0999999999999943]
[null,64,148.29,1.1500000000000057]
[null,{"$f":"F8","v":65},{"$f":"G8","v":147.13999999999999},{"$f":"H8","v":1.2199999999999989}]
[null,{"$f":"F9","v":66},145.91999999999999,2.7299999999999898]
[null,67,143.19,2.8499999999999943]
[null,68,140.34,2.9699999999999989]
[null,69,137.37,3.0900000000000034]
[null,70,134.28,3.1999999999999886]
[null,71,131.08000000000001,3.3200000000000074]
[null,72,127.76,3.4400000000000119]
[null,73,124.32,3.539999999999992]
[null,74,120.78,3.6400000000000006]
[null,75,117.14,3.7399999999999949]
[null,76,113.4,3.8200000000000074]
[null,77,109.58,3.8999999999999915]
[null,78,105.68,3.9700000000000131]
[null,79,101.71,4.019999999999996]
[null,80,97.69,4.0499999999999972]
[null,81,93.64,4.0700000000000074]
[null,82,89.57,4.0599999999999881]
[null,83,85.51,4.0300000000000011]
[null,84,81.48,3.9699999999999989]
[null,85,77.510000000000005,3.9000000000000057]
[null,86,73.61,3.7900000000000063]
[null,87,69.819999999999993,3.6599999999999966]
[null,88,66.16,3.5]
[null,89,62.66,3.3199999999999932]
[null,90,59.34,3.1200000000000045]
[null,91,56.22,2.9499999999999957]
[null,92,53.27,2.7800000000000011]
[null,93,50.49,2.6600000000000037]
[null,94,47.83,2.5599999999999952]
[null,95,45.27,2.490000000000002]
[null,96,42.78,2.3900000000000006]
[null,97,40.39,2.2899999999999991]
[null,98,38.1,2.1900000000000048]
[null,99,35.909999999999997,2.0599999999999952]

{"sheet":"CPI-U Index","index":8,"n_rows":44,"n_cols":14,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"IF(AND($I2<=Calculations!$B$56,'CPI-U Index'!$J2>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$57,'CPI-U Index'!$J2>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$58,'CPI-U Index'!$J2>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$59,'CPI-U Index'!$J2>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$60,'CPI-U Index'!$J2>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$61,'CPI-U Index'!$J2>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$62,'CPI-U Index'!$J2>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I2<=Calculations!$B$63,'CPI-U Index'!$J2>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2008-10-01","2009-09-30",4.9000000000000002E-2,{"$f":"K2*1.5","v":7.350000000000001E-2},0.06,{"$f":"MAX(L2:M2)","v":7.350000000000001E-2}]
[{"$f":"IF(AND($I3<=Calculations!$B$56,'CPI-U Index'!$J3>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$57,'CPI-U Index'!$J3>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$58,'CPI-U Index'!$J3>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$59,'CPI-U Index'!$J3>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$60,'CPI-U Index'!$J3>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$61,'CPI-U Index'!$J3>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$62,'CPI-U Index'!$J3>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I3<=Calculations!$B$63,'CPI-U Index'!$J3>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2009-10-01","2010-09-30",-1.2999999999999999E-2,{"$f":"K3*1.5","v":-1.95E-2},0.06,{"$f":"MAX(L3:M3)","v":0.06}]
[{"$f":"IF(AND($I4<=Calculations!$B$56,'CPI-U Index'!$J4>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$57,'CPI-U Index'!$J4>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$58,'CPI-U Index'!$J4>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$59,'CPI-U Index'!$J4>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$60,'CPI-U Index'!$J4>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$61,'CPI-U Index'!$J4>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$62,'CPI-U Index'!$J4>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I4<=Calculations!$B$63,'CPI-U Index'!$J4>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2010-10-01","2011-09-30",1.0999999999999999E-2,1.6500000000000001E-2,0.06,0.06]
[{"$f":"IF(AND($I5<=Calculations!$B$56,'CPI-U Index'!$J5>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$57,'CPI-U Index'!$J5>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$58,'CPI-U Index'!$J5>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$59,'CPI-U Index'!$J5>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$60,'CPI-U Index'!$J5>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$61,'CPI-U Index'!$J5>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$62,'CPI-U Index'!$J5>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I5<=Calculations!$B$63,'CPI-U Index'!$J5>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2011-10-01","2012-09-30",3.9E-2,5.8499999999999996E-2,0.06,0.06]
[{"$f":"IF(AND($I6<=Calculations!$B$56,'CPI-U Index'!$J6>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$57,'CPI-U Index'!$J6>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$58,'CPI-U Index'!$J6>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$59,'CPI-U Index'!$J6>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$60,'CPI-U Index'!$J6>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$61,'CPI-U Index'!$J6>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$62,'CPI-U Index'!$J6>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I6<=Calculations!$B$63,'CPI-U Index'!$J6>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2012-10-01","2013-09-30",0.02,0.03,0.06,0.06]
[{"$f":"IF(AND($I7<=Calculations!$B$56,'CPI-U Index'!$J7>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$57,'CPI-U Index'!$J7>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$58,'CPI-U Index'!$J7>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$59,'CPI-U Index'!$J7>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$60,'CPI-U Index'!$J7>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$61,'CPI-U Index'!$J7>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$62,'CPI-U Index'!$J7>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I7<=Calculations!$B$63,'CPI-U Index'!$J7>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2013-10-01","2014-09-30",1.2E-2,1.8000000000000002E-2,0.06,0.06]
[{"$f":"IF(AND($I8<=Calculations!$B$56,'CPI-U Index'!$J8>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$57,'CPI-U Index'!$J8>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$58,'CPI-U Index'!$J8>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$59,'CPI-U Index'!$J8>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$60,'CPI-U Index'!$J8>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$61,'CPI-U Index'!$J8>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$62,'CPI-U Index'!$J8>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I8<=Calculations!$B$63,'CPI-U Index'!$J8>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2014-10-01","2015-09-30",1.7000000000000001E-2,2.5500000000000002E-2,0.06,0.06]
[{"$f":"IF(AND($I9<=Calculations!$B$56,'CPI-U Index'!$J9>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$57,'CPI-U Index'!$J9>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$58,'CPI-U Index'!$J9>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$59,'CPI-U Index'!$J9>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$60,'CPI-U Index'!$J9>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$61,'CPI-U Index'!$J9>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$62,'CPI-U Index'!$J9>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I9<=Calculations!$B$63,'CPI-U Index'!$J9>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2015-10-01","2016-09-30",0,0,0.06,0.06]
[{"$f":"IF(AND($I10<=Calculations!$B$56,'CPI-U Index'!$J10>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$57,'CPI-U Index'!$J10>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$58,'CPI-U Index'!$J10>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$59,'CPI-U Index'!$J10>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$60,'CPI-U Index'!$J10>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$61,'CPI-U Index'!$J10>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$62,'CPI-U Index'!$J10>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I10<=Calculations!$B$63,'CPI-U Index'!$J10>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2016-10-01","2017-09-30",1.4999999999999999E-2,2.2499999999999999E-2,0.06,0.06]
[{"$f":"IF(AND($I11<=Calculations!$B$56,'CPI-U Index'!$J11>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$57,'CPI-U Index'!$J11>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$58,'CPI-U Index'!$J11>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$59,'CPI-U Index'!$J11>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$60,'CPI-U Index'!$J11>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$61,'CPI-U Index'!$J11>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$62,'CPI-U Index'!$J11>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I11<=Calculations!$B$63,'CPI-U Index'!$J11>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2017-10-01","2018-09-30",2.2329999999999999E-2,3.3494999999999997E-2,0.06,0.06]
[{"$f":"IF(AND($I12<=Calculations!$B$56,'CPI-U Index'!$J12>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$57,'CPI-U Index'!$J12>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$58,'CPI-U Index'!$J12>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$59,'CPI-U Index'!$J12>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$60,'CPI-U Index'!$J12>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$61,'CPI-U Index'!$J12>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$62,'CPI-U Index'!$J12>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I12<=Calculations!$B$63,'CPI-U Index'!$J12>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2018-10-01","2019-09-30",2.2769999999999999E-2,3.4154999999999998E-2,0.06,0.06]
[{"$f":"IF(AND($I13<=Calculations!$B$56,'CPI-U Index'!$J13>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$57,'CPI-U Index'!$J13>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$58,'CPI-U Index'!$J13>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$59,'CPI-U Index'!$J13>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$60,'CPI-U Index'!$J13>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$61,'CPI-U Index'!$J13>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$62,'CPI-U Index'!$J13>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I13<=Calculations!$B$63,'CPI-U Index'!$J13>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2019-10-01","2020-09-30",1.711E-2,2.5665E-2,0.06,0.06]
[{"$f":"IF(AND($I14<=Calculations!$B$56,'CPI-U Index'!$J14>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$57,'CPI-U Index'!$J14>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$58,'CPI-U Index'!$J14>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$59,'CPI-U Index'!$J14>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$60,'CPI-U Index'!$J14>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$61,'CPI-U Index'!$J14>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$62,'CPI-U Index'!$J14>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I14<=Calculations!$B$63,'CPI-U Index'!$J14>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2020-10-01","2021-09-30",1.371E-2,2.0565E-2,0.06,0.06]
[{"$f":"IF(AND($I15<=Calculations!$B$56,'CPI-U Index'!$J15>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$57,'CPI-U Index'!$J15>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$58,'CPI-U Index'!$J15>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$59,'CPI-U Index'!$J15>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$60,'CPI-U Index'!$J15>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$61,'CPI-U Index'!$J15>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$62,'CPI-U Index'!$J15>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I15<=Calculations!$B$63,'CPI-U Index'!$J15>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2021-10-01","2022-12-31",5.3900000000000003E-2,8.0850000000000005E-2,0.06,8.0850000000000005E-2]
[{"$f":"IF(AND($I16<=Calculations!$B$56,'CPI-U Index'!$J16>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$57,'CPI-U Index'!$J16>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$58,'CPI-U Index'!$J16>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$59,'CPI-U Index'!$J16>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$60,'CPI-U Index'!$J16>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$61,'CPI-U Index'!$J16>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$62,'CPI-U Index'!$J16>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I16<=Calculations!$B$63,'CPI-U Index'!$J16>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2023-01-01","2023-12-31",8.2000000000000003E-2,0.123,0.06,{"$f":"MAX(L16:M16)","v":0.123}]
[{"$f":"IF(AND($I17<=Calculations!$B$56,'CPI-U Index'!$J17>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$57,'CPI-U Index'!$J17>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$58,'CPI-U Index'!$J17>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$59,'CPI-U Index'!$J17>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$60,'CPI-U Index'!$J17>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$61,'CPI-U Index'!$J17>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$62,'CPI-U Index'!$J17>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I17<=Calculations!$B$63,'CPI-U Index'!$J17>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2024-01-01","2024-12-31",3.6999999999999998E-2,5.5499999999999994E-2,0.06,0.06]
[{"$f":"IF(AND($I18<=Calculations!$B$56,'CPI-U Index'!$J18>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$57,'CPI-U Index'!$J18>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$58,'CPI-U Index'!$J18>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$59,'CPI-U Index'!$J18>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$60,'CPI-U Index'!$J18>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$61,'CPI-U Index'!$J18>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$62,'CPI-U Index'!$J18>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I18<=Calculations!$B$63,'CPI-U Index'!$J18>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2025-01-01","2025-12-31",2.4E-2,3.6000000000000004E-2,0.06,0.06]
[{"$f":"IF(AND($I19<=Calculations!$B$56,'CPI-U Index'!$J19>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$57,'CPI-U Index'!$J19>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$58,'CPI-U Index'!$J19>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$59,'CPI-U Index'!$J19>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$60,'CPI-U Index'!$J19>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$61,'CPI-U Index'!$J19>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$62,'CPI-U Index'!$J19>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I19<=Calculations!$B$63,'CPI-U Index'!$J19>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2026-01-01","2026-12-31",0,{"$f":"K19*1.5","v":0},0.06,0.06]
[{"$f":"IF(AND($I20<=Calculations!$B$56,'CPI-U Index'!$J20>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$57,'CPI-U Index'!$J20>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$58,'CPI-U Index'!$J20>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$59,'CPI-U Index'!$J20>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$60,'CPI-U Index'!$J20>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$61,'CPI-U Index'!$J20>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$62,'CPI-U Index'!$J20>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I20<=Calculations!$B$63,'CPI-U Index'!$J20>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2027-01-01","2027-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I21<=Calculations!$B$56,'CPI-U Index'!$J21>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$57,'CPI-U Index'!$J21>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$58,'CPI-U Index'!$J21>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$59,'CPI-U Index'!$J21>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$60,'CPI-U Index'!$J21>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$61,'CPI-U Index'!$J21>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$62,'CPI-U Index'!$J21>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I21<=Calculations!$B$63,'CPI-U Index'!$J21>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2028-01-01","2028-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I22<=Calculations!$B$56,'CPI-U Index'!$J22>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$57,'CPI-U Index'!$J22>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$58,'CPI-U Index'!$J22>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$59,'CPI-U Index'!$J22>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$60,'CPI-U Index'!$J22>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$61,'CPI-U Index'!$J22>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$62,'CPI-U Index'!$J22>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I22<=Calculations!$B$63,'CPI-U Index'!$J22>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2029-01-01","2029-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I23<=Calculations!$B$56,'CPI-U Index'!$J23>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$57,'CPI-U Index'!$J23>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$58,'CPI-U Index'!$J23>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$59,'CPI-U Index'!$J23>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$60,'CPI-U Index'!$J23>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$61,'CPI-U Index'!$J23>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$62,'CPI-U Index'!$J23>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I23<=Calculations!$B$63,'CPI-U Index'!$J23>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2030-01-01","2030-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I24<=Calculations!$B$56,'CPI-U Index'!$J24>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$57,'CPI-U Index'!$J24>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$58,'CPI-U Index'!$J24>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$59,'CPI-U Index'!$J24>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$60,'CPI-U Index'!$J24>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$61,'CPI-U Index'!$J24>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$62,'CPI-U Index'!$J24>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I24<=Calculations!$B$63,'CPI-U Index'!$J24>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2031-01-01","2031-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I25<=Calculations!$B$56,'CPI-U Index'!$J25>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$57,'CPI-U Index'!$J25>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$58,'CPI-U Index'!$J25>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$59,'CPI-U Index'!$J25>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$60,'CPI-U Index'!$J25>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$61,'CPI-U Index'!$J25>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$62,'CPI-U Index'!$J25>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I25<=Calculations!$B$63,'CPI-U Index'!$J25>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2032-01-01","2032-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I26<=Calculations!$B$56,'CPI-U Index'!$J26>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$57,'CPI-U Index'!$J26>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$58,'CPI-U Index'!$J26>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$59,'CPI-U Index'!$J26>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$60,'CPI-U Index'!$J26>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$61,'CPI-U Index'!$J26>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$62,'CPI-U Index'!$J26>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I26<=Calculations!$B$63,'CPI-U Index'!$J26>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2033-01-01","2033-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I27<=Calculations!$B$56,'CPI-U Index'!$J27>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$57,'CPI-U Index'!$J27>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$58,'CPI-U Index'!$J27>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$59,'CPI-U Index'!$J27>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$60,'CPI-U Index'!$J27>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$61,'CPI-U Index'!$J27>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$62,'CPI-U Index'!$J27>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I27<=Calculations!$B$63,'CPI-U Index'!$J27>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2034-01-01","2034-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I28<=Calculations!$B$56,'CPI-U Index'!$J28>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$57,'CPI-U Index'!$J28>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$58,'CPI-U Index'!$J28>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$59,'CPI-U Index'!$J28>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$60,'CPI-U Index'!$J28>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$61,'CPI-U Index'!$J28>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$62,'CPI-U Index'!$J28>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I28<=Calculations!$B$63,'CPI-U Index'!$J28>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2035-01-01","2035-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I29<=Calculations!$B$56,'CPI-U Index'!$J29>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$57,'CPI-U Index'!$J29>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$58,'CPI-U Index'!$J29>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$59,'CPI-U Index'!$J29>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$60,'CPI-U Index'!$J29>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$61,'CPI-U Index'!$J29>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$62,'CPI-U Index'!$J29>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I29<=Calculations!$B$63,'CPI-U Index'!$J29>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2036-01-01","2036-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I30<=Calculations!$B$56,'CPI-U Index'!$J30>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$57,'CPI-U Index'!$J30>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$58,'CPI-U Index'!$J30>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$59,'CPI-U Index'!$J30>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$60,'CPI-U Index'!$J30>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$61,'CPI-U Index'!$J30>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$62,'CPI-U Index'!$J30>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I30<=Calculations!$B$63,'CPI-U Index'!$J30>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2037-01-01","2037-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I31<=Calculations!$B$56,'CPI-U Index'!$J31>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$57,'CPI-U Index'!$J31>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$58,'CPI-U Index'!$J31>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$59,'CPI-U Index'!$J31>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$60,'CPI-U Index'!$J31>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$61,'CPI-U Index'!$J31>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$62,'CPI-U Index'!$J31>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I31<=Calculations!$B$63,'CPI-U Index'!$J31>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2038-01-01","2038-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I32<=Calculations!$B$56,'CPI-U Index'!$J32>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$57,'CPI-U Index'!$J32>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$58,'CPI-U Index'!$J32>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$59,'CPI-U Index'!$J32>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$60,'CPI-U Index'!$J32>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$61,'CPI-U Index'!$J32>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$62,'CPI-U Index'!$J32>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I32<=Calculations!$B$63,'CPI-U Index'!$J32>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2039-01-01","2039-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I33<=Calculations!$B$56,'CPI-U Index'!$J33>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$57,'CPI-U Index'!$J33>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$58,'CPI-U Index'!$J33>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$59,'CPI-U Index'!$J33>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$60,'CPI-U Index'!$J33>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$61,'CPI-U Index'!$J33>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$62,'CPI-U Index'!$J33>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I33<=Calculations!$B$63,'CPI-U Index'!$J33>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2040-01-01","2040-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I34<=Calculations!$B$56,'CPI-U Index'!$J34>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$57,'CPI-U Index'!$J34>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$58,'CPI-U Index'!$J34>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$59,'CPI-U Index'!$J34>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$60,'CPI-U Index'!$J34>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$61,'CPI-U Index'!$J34>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$62,'CPI-U Index'!$J34>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I34<=Calculations!$B$63,'CPI-U Index'!$J34>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2041-01-01","2041-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I35<=Calculations!$B$56,'CPI-U Index'!$J35>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$57,'CPI-U Index'!$J35>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$58,'CPI-U Index'!$J35>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$59,'CPI-U Index'!$J35>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$60,'CPI-U Index'!$J35>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$61,'CPI-U Index'!$J35>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$62,'CPI-U Index'!$J35>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I35<=Calculations!$B$63,'CPI-U Index'!$J35>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2042-01-01","2042-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I36<=Calculations!$B$56,'CPI-U Index'!$J36>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$57,'CPI-U Index'!$J36>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$58,'CPI-U Index'!$J36>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$59,'CPI-U Index'!$J36>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$60,'CPI-U Index'!$J36>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$61,'CPI-U Index'!$J36>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$62,'CPI-U Index'!$J36>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I36<=Calculations!$B$63,'CPI-U Index'!$J36>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2043-01-01","2043-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I37<=Calculations!$B$56,'CPI-U Index'!$J37>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$57,'CPI-U Index'!$J37>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$58,'CPI-U Index'!$J37>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$59,'CPI-U Index'!$J37>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$60,'CPI-U Index'!$J37>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$61,'CPI-U Index'!$J37>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$62,'CPI-U Index'!$J37>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I37<=Calculations!$B$63,'CPI-U Index'!$J37>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2044-01-01","2044-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I38<=Calculations!$B$56,'CPI-U Index'!$J38>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$57,'CPI-U Index'!$J38>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$58,'CPI-U Index'!$J38>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$59,'CPI-U Index'!$J38>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$60,'CPI-U Index'!$J38>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$61,'CPI-U Index'!$J38>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$62,'CPI-U Index'!$J38>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I38<=Calculations!$B$63,'CPI-U Index'!$J38>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2045-01-01","2045-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I39<=Calculations!$B$56,'CPI-U Index'!$J39>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$57,'CPI-U Index'!$J39>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$58,'CPI-U Index'!$J39>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$59,'CPI-U Index'!$J39>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$60,'CPI-U Index'!$J39>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$61,'CPI-U Index'!$J39>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$62,'CPI-U Index'!$J39>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I39<=Calculations!$B$63,'CPI-U Index'!$J39>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2046-01-01","2046-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I40<=Calculations!$B$56,'CPI-U Index'!$J40>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$57,'CPI-U Index'!$J40>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$58,'CPI-U Index'!$J40>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$59,'CPI-U Index'!$J40>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$60,'CPI-U Index'!$J40>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$61,'CPI-U Index'!$J40>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$62,'CPI-U Index'!$J40>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I40<=Calculations!$B$63,'CPI-U Index'!$J40>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2047-01-01","2047-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I41<=Calculations!$B$56,'CPI-U Index'!$J41>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$57,'CPI-U Index'!$J41>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$58,'CPI-U Index'!$J41>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$59,'CPI-U Index'!$J41>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$60,'CPI-U Index'!$J41>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$61,'CPI-U Index'!$J41>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$62,'CPI-U Index'!$J41>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I41<=Calculations!$B$63,'CPI-U Index'!$J41>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2048-01-01","2048-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I42<=Calculations!$B$56,'CPI-U Index'!$J42>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$57,'CPI-U Index'!$J42>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$58,'CPI-U Index'!$J42>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$59,'CPI-U Index'!$J42>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$60,'CPI-U Index'!$J42>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$61,'CPI-U Index'!$J42>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$62,'CPI-U Index'!$J42>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I42<=Calculations!$B$63,'CPI-U Index'!$J42>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2049-01-01","2049-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I43<=Calculations!$B$56,'CPI-U Index'!$J43>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$57,'CPI-U Index'!$J43>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$58,'CPI-U Index'!$J43>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$59,'CPI-U Index'!$J43>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$60,'CPI-U Index'!$J43>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$61,'CPI-U Index'!$J43>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$62,'CPI-U Index'!$J43>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I43<=Calculations!$B$63,'CPI-U Index'!$J43>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2050-01-01","2050-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($I44<=Calculations!$B$56,'CPI-U Index'!$J44>=Calculations!$B$56),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$57,'CPI-U Index'!$J44>=Calculations!$B$57),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$58,'CPI-U Index'!$J44>=Calculations!$B$58),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$59,'CPI-U Index'!$J44>=Calculations!$B$59),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$60,'CPI-U Index'!$J44>=Calculations!$B$60),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$61,'CPI-U Index'!$J44>=Calculations!$B$61),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$62,'CPI-U Index'!$J44>=Calculations!$B$62),1,0)","v":{"$error":"#N/A"}},{"$f":"IF(AND($I44<=Calculations!$B$63,'CPI-U Index'!$J44>=Calculations!$B$63),1,0)","v":{"$error":"#N/A"}},"2051-01-01","2051-12-31",0,0,0.06,0.06]