{"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":[[43,7,43,12],[44,7,44,12],[47,7,47,12],[48,7,48,12],[49,7,49,12],[45,7,45,12],[13,7,13,12],[0,0,3,1],[1,7,2,13],[7,2,7,5],[4,10,5,10],[4,11,5,11],[4,12,5,12],[4,13,5,13],[11,0,11,1],[12,0,12,1],[5,0,5,4],[4,8,5,8],[4,9,5,9],[7,0,7,1],[8,0,8,1],[9,0,9,1],[13,0,13,1],[14,0,14,1],[17,0,17,1],[15,0,15,1],[16,0,16,1],[32,7,35,12],[18,7,18,8],[28,7,28,8],[29,7,29,8],[21,7,21,8],[22,7,22,8],[18,1,19,3],[26,7,26,8],[27,7,27,8],[30,7,30,8],[23,7,23,8],[24,7,24,8],[25,7,25,8],[14,9,14,12],[20,7,20,8],[14,7,14,8],[15,7,15,8],[16,7,16,8],[17,7,17,8],[38,7,38,12],[39,7,39,12],[40,7,40,12],[41,7,41,12],[37,7,37,12]]}
["Accelerated Payment Estimator",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,null,null,null,"Wage Period","Wages for Pension","Increase","Allowable Wage Increase","Excess","Wages as Entered"]
["Estimator only Applicable for Tier 1 Regular or SLEP retirements (Not Applicable for ECO)"]
[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":"#NUM!"}},{"$f":"SUMIF(FRE!$A$14:$A$133,2,FRE!$H$14:$H$133)","v":0},{"$f":"J8-J7","v":0},{"$f":"J7*(VLOOKUP(1,'CPI-U Index'!$A$2:$J$44,10,FALSE))","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":"#NUM!"}},{"$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":"#NUM!"}},{"$f":"SUMIF(FRE!$A$14:$A$133,3,FRE!$H$14:$H$133)","v":0},{"$f":"J9-J8","v":0},{"$f":"J8*(VLOOKUP(1,'CPI-U Index'!$B$2:$J$44,9,FALSE))","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":"#NUM!"}},{"$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":"#NUM!"}},{"$f":"SUMIF(FRE!$A$14:$A$133,4,FRE!$H$14:$H$133)","v":0},{"$f":"J10-J9","v":0},{"$f":"J9*(VLOOKUP(1,'CPI-U Index'!$C$2:$J$44,8,FALSE))","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":"#NUM!"}},{"$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":"#NUM!"}},{"$f":"SUMIF(FRE!$A$14:$A$133,5,FRE!$H$14:$H$133)","v":0},{"$f":"J11-J10","v":0},{"$f":"J10*(VLOOKUP(1,'CPI-U Index'!$D$2:$J$44,7,FALSE))","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":"#NUM!"}},{"$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":"1900-02-01"},null,null,null,null,null,null,{"$f":"SUM(J7:J11)","v":0},null,null,{"$f":"SUM(M7:M11)","v":{"$error":"#NUM!"}},{"$f":"SUM(N7:N11)","v":0}]
["IMRF Service (at Retirement)",null,null,"Years",null,"Months"]
["Unused/Unpaid Sick Days",null,null,"Days"]
["Retirement Service Credit",null,{"$f":"Calculations!C24","v":0}]
["Male/Female",null,null,null,null,null,null,"Birth Date",null,{"$f":"C9","v":"00:00:00"}]
["Marital Status (at Retirement)",null,null,null,null,null,null,"Retirement Date",null,{"$f":"C12","v":"1900-02-01"}]
["IMRF Service Type",null,null,null,null,null,null,"Member's Age",null,{"$f":"ROUND(Calculations!B15,3)","v":{"$error":"#VALUE!"}}]
[null,{"$f":"\"Wages for \"&PROPER(C8)","v":"Wages for "},null,null,null,null,null,"IMRF Service at Retirement",null,{"$f":"Calculations!C21","v":0},"Years"]
[null,null,null,null,null,null,null,null,null,{"$f":"Calculations!E21","v":0},"Months"]
[{"$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,"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":0}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Excess (AP Wages)",null,{"$f":"M12","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Divide by 48",null,{"$f":"J24/48","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Times Service Factor",null,{"$f":"IF(J23=\"Regular\",ROUND(Calculations!C36*Calculations!F31,5),Calculations!F36)","v":0}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Retirement from AP Wages",null,{"$f":"IF(J23=\"Regular\",ROUND(J25*Calculations!C36*Calculations!F31,2),ROUND(Entry!J25*Calculations!F36,2))","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Annuity Factor",null,{"$f":"Calculations!E44","v":{"$error":"#VALUE!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Increase to Present Value Caused by Excess",null,{"$f":"ROUND(J27*J28,0)","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"Member Contributions on Excess",null,{"$f":"ROUND(Calculations!C47,0)","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,"AP Amount",null,{"$f":"ROUND(J27*J28-Calculations!C47,0)","v":{"$error":"#NUM!"}},null,null,null,null,null,null,null,{"$f":"IF($J$31>=5000,3,IF(AND(Entry!$J$31<5000,Entry!$J$31>4500),2,1))","v":{"$error":"#NUM!"}}]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0,null,null,{"$f":"IF($J$31>=5000,Calculations!B52,IF(AND(Entry!$J$31<5000,Entry!$J$31>4500),Calculations!B51,Calculations!B50))","v":{"$error":"#NUM!"}}]
[{"$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 48 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 48 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."]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$error":"#NUM!"},0,null,{"$error":"#NUM!"},0]
[{"$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 2",null,null,null,null,null,null,null,"This estimator is only meant for Tier 1 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 service",null,null,null,null,null,null,null,"This spreadsheet is not programmed to consider ECO service",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 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":59,"n_cols":10,"rows_kept":59,"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)+55,MONTH($C$9)+1,DAY(1))","v":"1955-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":"1900-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":0},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,{"$f":"C18+VLOOKUP(E18,I16:J28,2,FALSE)","v":0},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,{"$f":"60-B15","v":{"$error":"#VALUE!"}},null,{"$f":"35-E24","v":35},null,null,null,null,12,1]
[null,{"$f":"B28*3","v":{"$error":"#VALUE!"}},null,{"$f":"D28*3","v":105}]
[null,{"$f":"100-B29","v":{"$error":"#VALUE!"}},null,{"$f":"100-D29","v":-5}]
[null,{"$f":"MIN(B30/100,1)","v":{"$error":"#VALUE!"}},null,{"$f":"MIN(D30/100,1)","v":-0.05},null,{"$f":"MAX(B31,D31)","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((C34+C35)>0.75,0.75,C34+C35)","v":0},null,null,{"$f":"F34","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!C41,Calculations!C42)","v":{"$error":"#VALUE!"}},{"$f":"IF(Entry!$C$17=\"Married\",Calculations!D41,Calculations!D42)","v":{"$error":"#VALUE!"}},{"$f":"IF(Entry!C16=\"Male\",Calculations!C44,Calculations!D44)","v":{"$error":"#VALUE!"}}]
[]
[]
[null,"Contributions on Excess",{"$f":"ROUND(IF(AND(Entry!C18=\"Regular\",Entry!C17=\"Married\"),Entry!M12*0.045,IF(AND(Entry!C18=\"Regular\",OR(Entry!C17=\"Single\",Entry!C17=\"Widowed\",Entry!C17=\"Never Married\")),Entry!M12*0.0375,IF(AND(Entry!C18=\"SLEP\",Entry!C17=\"Married\"),Entry!M12*0.075,IF(AND(Entry!C18=\"SLEP\",OR(Entry!C17=\"Single\",Entry!C17=\"Widowed\",Entry!C17=\"Never Married\")),Entry!M12*0.0675,Entry!M12*0.045)))),2)","v":{"$error":"#NUM!"}}]
[]
[]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR\"&\" \"&UPPER(Entry!C8)&\" \"&\"WILL BE \"&TEXT(Entry!J31,\"$0,0.00\")&\". IMRF WILL NOT ISSUE ISSUE AN INVOICE IF THE ACTUAL AP IS LESS THAN $5,000.00\"","v":{"$error":"#NUM!"}}]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR \"&UPPER(Entry!C8)&\" WILL BE \"&TEXT(Entry!J31,\"$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!J31,\"$0,0.00\")&\" OF $5,000.00, PLEASE CONTACT IMRF TO VERIFY ACCURACY OF THIS ESTIMATE\"","v":{"$error":"#NUM!"}}]
[null,{"$f":"\"BASED ON THE INFORMATION ENTERED, THE ESTIMATED ACCELERATED PAYMENT FOR \"&UPPER(Entry!C8)&\" WILL BE \"&TEXT(Entry!J31,\"$0,0.00\")","v":{"$error":"#NUM!"}}]
[]
[]
[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":"#NUM!"}},{"$f":"VLOOKUP(24,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$A$2:$J$15,10,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(25,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(36,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$B$2:$J$15,9,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(37,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(48,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$C$2:$J$15,8,FALSE)","v":{"$error":"#N/A"}}]
[null,{"$f":"VLOOKUP(49,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(60,FRE!$B$14:$C$133,2,FALSE)","v":{"$error":"#NUM!"}},{"$f":"VLOOKUP(1,'CPI-U Index'!$D$2:$J$15,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":"IF(AND(B2>=1,B2<=12),1,IF(AND(B2>=13,B2<=24),2,IF(AND(B2>=25,B2<=36),3,IF(AND(B2>=37,B2<=48),4,IF(AND(B2>=49,B2<=60),5,0)))))","v":1},{"$f":"IF(AND(L60=\"\",L61=\" MAX\"),1,IF(AND(B1>=1,B1<60),B1+1,0))","v":1},{"$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}]
[1,2,{"$f":"Entry!A22","v":{"$error":"#NUM!"}},{"$f":"Entry!B22","v":0},null,null,null,0]
[1,3,{"$f":"Entry!A23","v":{"$error":"#NUM!"}},{"$f":"Entry!B23","v":0},null,null,null,0]
[1,4,{"$f":"Entry!A24","v":{"$error":"#NUM!"}},{"$f":"Entry!B24","v":0},null,null,null,0]
[1,5,{"$f":"Entry!A25","v":{"$error":"#NUM!"}},{"$f":"Entry!B25","v":0},null,null,null,0]
[1,6,{"$f":"Entry!A26","v":{"$error":"#NUM!"}},{"$f":"Entry!B26","v":0},null,null,null,0]
[1,7,{"$f":"Entry!A27","v":{"$error":"#NUM!"}},{"$f":"Entry!B27","v":0},null,null,null,0]
[1,8,{"$f":"Entry!A28","v":{"$error":"#NUM!"}},{"$f":"Entry!B28","v":0},null,null,null,0]
[1,9,{"$f":"Entry!A29","v":{"$error":"#NUM!"}},{"$f":"Entry!B29","v":0},null,null,null,0]
[1,10,{"$f":"Entry!A30","v":{"$error":"#NUM!"}},{"$f":"Entry!B30","v":0},null,null,null,0]
[1,11,{"$f":"Entry!A31","v":{"$error":"#NUM!"}},{"$f":"Entry!B31","v":0},null,null,null,0]
[1,12,{"$f":"Entry!A32","v":{"$error":"#NUM!"}},{"$f":"Entry!B32","v":0},null,null,null,0]
[{"$f":"IF(AND(B14>=1,B14<=12),1,IF(AND(B14>=13,B14<=24),2,IF(AND(B14>=25,B14<=36),3,IF(AND(B14>=37,B14<=48),4,IF(AND(B14>=49,B14<=60),5,0)))))","v":2},{"$f":"IF(AND(L72=\"\",L73=\" MAX\"),1,IF(AND(B13>=1,B13<60),B13+1,0))","v":13},{"$f":"DATE(YEAR(C15),MONTH(C15)-1,DAY(C15))","v":{"$error":"#NUM!"}},{"$f":"Entry!B33","v":0},null,null,null,0]
[{"$f":"IF(AND(B15>=1,B15<=12),1,IF(AND(B15>=13,B15<=24),2,IF(AND(B15>=25,B15<=36),3,IF(AND(B15>=37,B15<=48),4,IF(AND(B15>=49,B15<=60),5,0)))))","v":2},{"$f":"IF(AND(L73=\"\",L74=\" MAX\"),1,IF(AND(B14>=1,B14<60),B14+1,0))","v":14},{"$f":"DATE(YEAR(C16),MONTH(C16)-1,DAY(C16))","v":{"$error":"#NUM!"}},{"$f":"Entry!B34","v":0},null,null,null,0]
[2,15,{"$error":"#NUM!"},{"$f":"Entry!B35","v":0},null,null,null,0]
[2,16,{"$error":"#NUM!"},{"$f":"Entry!B36","v":0},null,null,null,0]
[2,17,{"$error":"#NUM!"},{"$f":"Entry!B37","v":0},null,null,null,0]
[2,18,{"$error":"#NUM!"},{"$f":"Entry!B38","v":0},null,null,null,0]
[2,19,{"$error":"#NUM!"},{"$f":"Entry!B39","v":0},null,null,null,0]
[2,20,{"$error":"#NUM!"},{"$f":"Entry!B40","v":0},null,null,null,0]
[2,21,{"$error":"#NUM!"},{"$f":"Entry!B41","v":0},null,null,null,0]
[2,22,{"$error":"#NUM!"},{"$f":"Entry!B42","v":0},null,null,null,0]
[2,23,{"$error":"#NUM!"},{"$f":"Entry!B43","v":0},null,null,null,0]
[2,24,{"$error":"#NUM!"},{"$f":"Entry!B44","v":0},null,null,null,0]
[3,25,{"$error":"#NUM!"},{"$f":"Entry!B45","v":0},null,null,null,0]
[3,26,{"$error":"#NUM!"},{"$f":"Entry!B46","v":0},null,null,null,0]
[3,27,{"$error":"#NUM!"},{"$f":"Entry!B47","v":0},null,null,null,0]
[3,28,{"$error":"#NUM!"},{"$f":"Entry!B48","v":0},null,null,null,0]
[3,29,{"$error":"#NUM!"},{"$f":"Entry!B49","v":0},null,null,null,0]
[3,30,{"$error":"#NUM!"},{"$f":"Entry!B50","v":0},null,null,null,0]
[3,31,{"$error":"#NUM!"},{"$f":"Entry!B51","v":0},null,null,null,0]
[3,32,{"$error":"#NUM!"},{"$f":"Entry!B52","v":0},null,null,null,0]
[3,33,{"$error":"#NUM!"},{"$f":"Entry!B53","v":0},null,null,null,0]
[3,34,{"$error":"#NUM!"},{"$f":"Entry!B54","v":0},null,null,null,0]
[3,35,{"$error":"#NUM!"},{"$f":"Entry!B55","v":0},null,null,null,0]
[3,36,{"$error":"#NUM!"},{"$f":"Entry!B56","v":0},null,null,null,0]
[4,37,{"$error":"#NUM!"},{"$f":"Entry!B57","v":0},null,null,null,0]
[4,38,{"$error":"#NUM!"},{"$f":"Entry!B58","v":0},null,null,null,0]
[4,39,{"$error":"#NUM!"},{"$f":"Entry!B59","v":0},null,null,null,0]
[4,40,{"$error":"#NUM!"},{"$f":"Entry!B60","v":0},null,null,null,0]
[4,41,{"$error":"#NUM!"},{"$f":"Entry!B61","v":0},null,null,null,0]
[4,42,{"$error":"#NUM!"},{"$f":"Entry!B62","v":0},null,null,null,0]
[4,43,{"$error":"#NUM!"},{"$f":"Entry!B63","v":0},null,null,null,0]
[4,44,{"$error":"#NUM!"},{"$f":"Entry!B64","v":0},null,null,null,0]
[4,45,{"$error":"#NUM!"},{"$f":"Entry!B65","v":0},null,null,null,0]
[4,46,{"$error":"#NUM!"},{"$f":"Entry!B66","v":0},null,null,null,0]
[4,47,{"$error":"#NUM!"},{"$f":"Entry!B67","v":0},null,null,null,0]
[4,48,{"$error":"#NUM!"},{"$f":"Entry!B68","v":0},null,null,null,0]
[5,49,{"$error":"#NUM!"},{"$f":"Entry!B69","v":0},null,null,null,0]
[5,50,{"$error":"#NUM!"},{"$f":"Entry!B70","v":0},null,null,null,0]
[5,51,{"$error":"#NUM!"},{"$f":"Entry!B71","v":0},null,null,null,0]
[5,52,{"$error":"#NUM!"},{"$f":"Entry!B72","v":0},null,null,null,0]
[5,53,{"$error":"#NUM!"},{"$f":"Entry!B73","v":0},null,null,null,0]
[5,54,{"$error":"#NUM!"},{"$f":"Entry!B74","v":0},null,null,null,0]
[5,55,{"$error":"#NUM!"},{"$f":"Entry!B75","v":0},null,null,null,0]
[5,56,{"$error":"#NUM!"},{"$f":"Entry!B76","v":0},null,null,null,0]
[5,57,{"$error":"#NUM!"},{"$f":"Entry!B77","v":0},null,null,null,0]
[5,58,{"$error":"#NUM!"},{"$f":"Entry!B78","v":0},null,null,null,0]
[5,59,{"$error":"#NUM!"},{"$f":"Entry!B79","v":0},null,null,null,0]
[5,60,{"$error":"#NUM!"},{"$f":"Entry!B80","v":0},{"$f":"MAX($D14:$D58)","v":0},{"$f":"ROUND(E61*1.25,2)","v":0},{"$f":"SUM(D14:D58)+ MIN(IF(ISBLANK(D59),0,D59),F61)+MIN(IF(ISBLANK(D60),0,D60),F61)+MIN(IF(ISBLANK(D60),0,D61),F61)","v":0},0,{"$f":"ROUND(G61/4,2)","v":0},{"$f":"ROUND(G61/48,2)","v":0},{"$f":"C14","v":{"$error":"#NUM!"}},{"$f":"IF(G61=G$135,\" MAX\",\"\")","v":" MAX"}]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B81","v":0},0,{"$f":"ROUND(E62*1.25,2)","v":0},0,0,{"$f":"ROUND(G62/4,2)","v":0},{"$f":"ROUND(G62/48,2)","v":0},{"$f":"C15","v":{"$error":"#NUM!"}},{"$f":"IF(G62=G$135,\" MAX\",\"\")","v":" MAX"}]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B82","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B83","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B84","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B85","v":0},0,0,0,{"$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},0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!B86","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E21","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E22","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E23","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E24","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E25","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E26","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E27","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E28","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E29","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E30","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E31","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[{"$f":"IF(AND(B79>=1,B79<=12),1,IF(AND(B79>=13,B79<=24),2,IF(AND(B79>=25,B79<=36),3,IF(AND(B79>=37,B79<=48),4,IF(AND(B79>=49,B79<=60),5,0)))))","v":0},{"$f":"IF(AND(L137=\"\",L138=\" MAX\"),1,IF(AND(B78>=1,B78<60),B78+1,0))","v":0},{"$f":"DATE(YEAR(C80),MONTH(C80)-1,DAY(C80))","v":{"$error":"#NUM!"}},{"$f":"Entry!E32","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E33","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E34","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E35","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E36","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E37","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E38","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E39","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E40","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E41","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E42","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E43","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E44","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E45","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E46","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E47","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E48","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E49","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E50","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E51","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E52","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E53","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E54","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E55","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E56","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E57","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E58","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E59","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E60","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E61","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E62","v":0},0,0,0,0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E63","v":0},0,0,0,0,0,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,{"$f":"SUM(D78:D122)+ MIN(IF(ISBLANK(D123),0,D123),F125)+MIN(IF(ISBLANK(D124),0,D124),F125)+MIN(IF(ISBLANK(D124),0,D125),F125)","v":0},0,0,0,{"$error":"#NUM!"}," MAX"]
[0,0,{"$error":"#NUM!"},{"$f":"Entry!E79","v":0},{"$f":"MAX($D79:$D123)","v":0},{"$f":"ROUND(E126*1.25,2)","v":0},0,0,{"$f":"ROUND(G126/4,2)","v":0},{"$f":"ROUND(G126/48,2)","v":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"]
[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,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},{"$f":"MAX($D86:$D130)","v":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(G61:G133)","v":0}]

{"sheet":"Table 1B","index":4,"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 1B",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:D124,2)-ROUND(((L3-INT(L3))*VLOOKUP(INT(L3),B60:D124,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,35,222.2,1.1099999999999852,null,65,162.83000000000001,3.2600000000000193]
[null,36,221.09,1.1800000000000068,null,66,159.57,3.3899999999999864]
[null,37,219.91,1.2299999999999898,null,67,156.18,3.4900000000000091]
[null,38,218.68,1.3000000000000114,null,68,152.69,3.6099999999999852]
[null,39,217.38,1.3599999999999852,null,69,149.08000000000001,3.7199999999999989]
[null,40,216.02,1.4399999999999977,null,70,145.36000000000001,3.8300000000000125]
[null,41,214.58,1.5200000000000102,null,71,141.53,3.9300000000000068]
[null,42,213.06,1.5900000000000034,null,72,137.6,4.0099999999999909]
[null,43,211.47,1.6800000000000068,null,73,133.59,4.1100000000000136]
[null,44,209.79,1.7699999999999818,null,74,129.47999999999999,4.1699999999999875]
[null,45,208.02,1.8200000000000216,null,75,125.31,4.2400000000000091]
[null,46,206.2,1.8699999999999761,null,76,121.07,4.2999999999999972]
[null,47,204.33,1.9000000000000057,null,77,116.77,4.3299999999999983]
[null,48,202.43,1.9099999999999966,null,78,112.44,4.3700000000000045]
[null,49,200.52,1.8900000000000148,null,79,108.07,4.3699999999999903]
[null,50,198.63,1.8400000000000034,null,80,103.7,4.3700000000000045]
[null,51,196.79,1.9000000000000057,null,81,99.33,4.3499999999999943]
[null,52,194.89,1.9799999999999898,null,82,94.98,4.3100000000000023]
[null,53,192.91,2.039999999999992,null,83,90.67,4.2399999999999949]
[null,54,190.87,2.1100000000000136,null,84,86.43,4.1700000000000017]
[null,55,188.76,2.1699999999999875,null,85,82.26,4.0799999999999983]
[null,56,186.59,2.2400000000000091,null,86,78.180000000000007,3.960000000000008]
[null,57,184.35,2.3299999999999841,null,87,74.22,3.8499999999999943]
[null,58,182.02,2.4200000000000159,null,88,70.37,3.7000000000000028]
[null,59,179.6,2.5,null,89,66.67,3.5500000000000043]
[null,60,177.1,2.6099999999999852,null,90,63.12,3.3900000000000006]
[null,61,174.49,2.7199999999999989,null,91,59.73,3.2099999999999937]
[null,62,171.77,2.8500000000000227,null,92,56.52,3.0500000000000043]
[null,63,168.92,2.9699999999999989,null,93,53.47,2.8999999999999986]
[null,64,165.95,3.1199999999999761,null,94,50.57,2.759999999999998]
[null,null,null,null,null,95,47.81,2.6300000000000026]
[null,null,null,null,null,96,45.18,2.5]
[null,null,null,null,null,97,42.68,2.3699999999999974]
[null,null,null,null,null,98,40.31,2.25]
[null,null,null,null,null,99,38.06,2.1300000000000026]
[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":35},222.2,1.1099999999999852]
[null,36,221.09,1.1800000000000068]
[null,37,219.91,1.2299999999999898]
[null,38,218.68,1.3000000000000114]
[null,39,217.38,1.3599999999999852]
[null,40,216.02,1.4399999999999977]
[null,41,214.58,1.5200000000000102]
[null,42,213.06,1.5900000000000034]
[null,43,211.47,1.6800000000000068]
[null,44,209.79,1.7699999999999818]
[null,45,208.02,1.8200000000000216]
[null,46,206.2,1.8699999999999761]
[null,47,204.33,1.9000000000000057]
[null,48,202.43,1.9099999999999966]
[null,49,200.52,1.8900000000000148]
[null,50,198.63,1.8400000000000034]
[null,{"$f":"B25","v":51},196.79,1.9000000000000057]
[null,52,194.89,1.9799999999999898]
[null,53,192.91,2.039999999999992]
[null,54,190.87,2.1100000000000136]
[null,55,188.76,2.1699999999999875]
[null,56,186.59,2.2400000000000091]
[null,57,184.35,2.3299999999999841]
[null,58,182.02,2.4200000000000159]
[null,59,179.6,2.5]
[null,60,177.1,2.6099999999999852]
[null,61,174.49,2.7199999999999989]
[null,62,171.77,2.8500000000000227]
[null,63,168.92,2.9699999999999989]
[null,64,165.95,3.1199999999999761]
[null,{"$f":"F9","v":65},{"$f":"G9","v":162.83000000000001},{"$f":"H9","v":3.2600000000000193}]
[null,{"$f":"F10","v":66},159.57,3.3899999999999864]
[null,67,156.18,3.4900000000000091]
[null,68,152.69,3.6099999999999852]
[null,69,149.08000000000001,3.7199999999999989]
[null,70,145.36000000000001,3.8300000000000125]
[null,71,141.53,3.9300000000000068]
[null,72,137.6,4.0099999999999909]
[null,73,133.59,4.1100000000000136]
[null,74,129.47999999999999,4.1699999999999875]
[null,75,125.31,4.2400000000000091]
[null,76,121.07,4.2999999999999972]
[null,77,116.77,4.3299999999999983]
[null,78,112.44,4.3700000000000045]
[null,79,108.07,4.3699999999999903]
[null,80,103.7,4.3700000000000045]
[null,81,99.33,4.3499999999999943]
[null,82,94.98,4.3100000000000023]
[null,83,90.67,4.2399999999999949]
[null,84,86.43,4.1700000000000017]
[null,85,82.26,4.0799999999999983]
[null,86,78.180000000000007,3.960000000000008]
[null,87,74.22,3.8499999999999943]
[null,88,70.37,3.7000000000000028]
[null,89,66.67,3.5500000000000043]
[null,90,63.12,3.3900000000000006]
[null,91,59.73,3.2099999999999937]
[null,92,56.52,3.0500000000000043]
[null,93,53.47,2.8999999999999986]
[null,94,50.57,2.759999999999998]
[null,95,47.81,2.6300000000000026]
[null,96,45.18,2.5]
[null,97,42.68,2.3699999999999974]
[null,98,40.31,2.25]
[null,99,38.06,2.1300000000000026]

{"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",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,35,212.71,1.5300000000000011,null,65,140.44999999999999,3.6399999999999864]
[null,36,211.18,1.6100000000000136,null,66,136.81,3.7400000000000091]
[null,37,209.57,1.6899999999999977,null,67,133.07,3.8299999999999841]
[null,38,207.88,1.7800000000000011,null,68,129.24,3.9200000000000159]
[null,39,206.1,1.8599999999999852,null,69,125.32,4]
[null,40,204.24,1.960000000000008,null,70,121.32,4.0699999999999932]
[null,41,202.28,2.0600000000000023,null,71,117.25,4.1299999999999955]
[null,42,200.22,2.1699999999999875,null,72,113.12,4.1800000000000068]
[null,43,198.05,2.2800000000000011,null,73,108.94,4.2199999999999989]
[null,44,195.77,2.3900000000000148,null,74,104.72,4.2600000000000051]
[null,45,193.38,2.4399999999999977,null,75,100.46,4.2599999999999909]
[null,46,190.94,2.4699999999999989,null,76,96.2,4.2600000000000051]
[null,47,188.47,2.4699999999999989,null,77,91.94,4.2399999999999949]
[null,48,186,2.4300000000000068,null,78,87.7,4.210000000000008]
[null,49,183.57,2.3299999999999841,null,79,83.49,4.1499999999999915]
[null,50,181.24,2.1500000000000057,null,80,79.34,4.0799999999999983]
[null,51,179.09,2.2299999999999898,null,81,75.260000000000005,3.980000000000004]
[null,52,176.86,2.3100000000000023,null,82,71.28,3.8599999999999994]
[null,53,174.55,2.3800000000000239,null,83,67.42,3.730000000000004]
[null,54,172.17,2.4499999999999886,null,84,63.69,3.5700000000000003]
[null,55,169.72,2.5200000000000102,null,85,60.12,3.4099999999999966]
[null,56,167.2,2.5799999999999841,null,86,56.71,3.240000000000002]
[null,57,164.62,2.6700000000000159,null,87,53.47,3.0600000000000023]
[null,58,161.94999999999999,2.7399999999999807,null,88,50.41,2.8699999999999974]
[null,59,159.21,2.8300000000000125,null,89,47.54,2.6700000000000017]
[null,60,156.38,2.9300000000000068,null,90,44.87,2.4899999999999949]
[null,61,153.44999999999999,3.039999999999992,null,91,42.38,2.3000000000000043]
[null,62,150.41,3.1699999999999875,null,92,40.08,2.1499999999999986]
[null,63,147.24,3.3100000000000023,null,93,37.93,2.0300000000000011]
[null,64,143.93,3.4800000000000182,null,94,35.9,1.9399999999999977]
[null,null,null,null,null,95,33.96,1.8800000000000026]
[null,null,null,null,null,96,32.08,1.7899999999999991]
[null,null,null,null,null,97,30.29,1.7100000000000009]
[null,null,null,null,null,98,28.58,1.6099999999999994]
[null,null,null,null,null,99,26.97,1.509999999999998]
[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,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,{"$f":"B8","v":35},212.71,1.5300000000000011]
[null,36,211.18,1.6100000000000136]
[null,37,209.57,1.6899999999999977]
[null,38,207.88,1.7800000000000011]
[null,39,206.1,1.8599999999999852]
[null,40,204.24,1.960000000000008]
[null,41,202.28,2.0600000000000023]
[null,42,200.22,2.1699999999999875]
[null,43,198.05,2.2800000000000011]
[null,44,195.77,2.3900000000000148]
[null,45,193.38,2.4399999999999977]
[null,46,190.94,2.4699999999999989]
[null,47,188.47,2.4699999999999989]
[null,48,186,2.4300000000000068]
[null,49,183.57,2.3299999999999841]
[null,50,181.24,2.1500000000000057]
[null,{"$f":"B24","v":51},179.09,2.2299999999999898]
[null,52,176.86,2.3100000000000023]
[null,53,174.55,2.3800000000000239]
[null,54,172.17,2.4499999999999886]
[null,55,169.72,2.5200000000000102]
[null,56,167.2,2.5799999999999841]
[null,57,164.62,2.6700000000000159]
[null,58,161.94999999999999,2.7399999999999807]
[null,59,159.21,2.8300000000000125]
[null,60,156.38,2.9300000000000068]
[null,61,153.44999999999999,3.039999999999992]
[null,62,150.41,3.1699999999999875]
[null,63,147.24,3.3100000000000023]
[null,64,143.93,3.4800000000000182]
[null,{"$f":"F8","v":65},{"$f":"G8","v":140.44999999999999},{"$f":"H8","v":3.6399999999999864}]
[null,{"$f":"F9","v":66},136.81,3.7400000000000091]
[null,67,133.07,3.8299999999999841]
[null,68,129.24,3.9200000000000159]
[null,69,125.32,4]
[null,70,121.32,4.0699999999999932]
[null,71,117.25,4.1299999999999955]
[null,72,113.12,4.1800000000000068]
[null,73,108.94,4.2199999999999989]
[null,74,104.72,4.2600000000000051]
[null,75,100.46,4.2599999999999909]
[null,76,96.2,4.2600000000000051]
[null,77,91.94,4.2399999999999949]
[null,78,87.7,4.210000000000008]
[null,79,83.49,4.1499999999999915]
[null,80,79.34,4.0799999999999983]
[null,81,75.260000000000005,3.980000000000004]
[null,82,71.28,3.8599999999999994]
[null,83,67.42,3.730000000000004]
[null,84,63.69,3.5700000000000003]
[null,85,60.12,3.4099999999999966]
[null,86,56.71,3.240000000000002]
[null,87,53.47,3.0600000000000023]
[null,88,50.41,2.8699999999999974]
[null,89,47.54,2.6700000000000017]
[null,90,44.87,2.4899999999999949]
[null,91,42.38,2.3000000000000043]
[null,92,40.08,2.1499999999999986]
[null,93,37.93,2.0300000000000011]
[null,94,35.9,1.9399999999999977]
[null,95,33.96,1.8800000000000026]
[null,96,32.08,1.7899999999999991]
[null,97,30.29,1.7100000000000009]
[null,98,28.58,1.6099999999999994]
[null,99,26.97,1.509999999999998]

{"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",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,35,221.4,1.1899999999999977,null,65,157.94,3.6299999999999955]
[null,36,220.21,1.25,null,66,154.31,3.7400000000000091]
[null,37,218.96,1.3200000000000216,null,67,150.57,3.8700000000000045]
[null,38,217.64,1.3799999999999955,null,68,146.69999999999999,3.9799999999999898]
[null,39,216.26,1.4499999999999886,null,69,142.72,4.0900000000000034]
[null,40,214.81,1.539999999999992,null,70,138.63,4.1899999999999977]
[null,41,213.27,1.6100000000000136,null,71,134.44,4.2800000000000011]
[null,42,211.66,1.6999999999999886,null,72,130.16,4.3599999999999994]
[null,43,209.96,1.7900000000000205,null,73,125.8,4.4399999999999977]
[null,44,208.17,1.8799999999999955,null,74,121.36,4.4899999999999949]
[null,45,206.29,1.9399999999999977,null,75,116.87,4.5500000000000114]
[null,46,204.35,1.9799999999999898,null,76,112.32,4.5799999999999983]
[null,47,202.37,2.0099999999999909,null,77,107.74,4.5999999999999943]
[null,48,200.36,2,null,78,103.14,4.6099999999999994]
[null,49,198.36,1.960000000000008,null,79,98.53,4.6099999999999994]
[null,50,196.4,1.8600000000000136,null,80,93.92,4.5900000000000034]
[null,51,194.54,1.9299999999999784,null,81,89.33,4.539999999999992]
[null,52,192.61,2.0200000000000102,null,82,84.79,4.480000000000004]
[null,53,190.59,2.1100000000000136,null,83,80.31,4.3900000000000006]
[null,54,188.48,2.1899999999999977,null,84,75.92,4.2900000000000063]
[null,55,186.29,2.289999999999992,null,85,71.63,4.1499999999999915]
[null,56,184,2.3899999999999864,null,86,67.48,3.990000000000002]
[null,57,181.61,2.5,null,87,63.49,3.8000000000000043]
[null,58,179.11,2.6100000000000136,null,88,59.69,3.5899999999999963]
[null,59,176.5,2.75,null,89,56.1,3.3500000000000014]
[null,60,173.75,2.8700000000000045,null,90,52.75,3.1199999999999974]
[null,61,170.88,3.0099999999999909,null,91,49.63,2.8800000000000026]
[null,62,167.87,3.1599999999999966,null,92,46.75,2.6899999999999977]
[null,63,164.71,3.3100000000000023,null,93,44.06,2.5300000000000011]
[null,64,161.4,3.460000000000008,null,94,41.53,2.4100000000000037]
[null,null,null,null,null,95,39.119999999999997,2.3200000000000003]
[null,null,null,null,null,96,36.799999999999997,2.2099999999999937]
[null,null,null,null,null,97,34.590000000000003,2.1000000000000014]
[null,null,null,null,null,98,32.49,1.990000000000002]
[null,null,null,null,null,99,30.5,1.8599999999999994]
[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,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,{"$f":"B8","v":35},221.4,1.1899999999999977]
[null,36,220.21,1.25]
[null,37,218.96,1.3200000000000216]
[null,38,217.64,1.3799999999999955]
[null,39,216.26,1.4499999999999886]
[null,40,214.81,1.539999999999992]
[null,41,213.27,1.6100000000000136]
[null,42,211.66,1.6999999999999886]
[null,43,209.96,1.7900000000000205]
[null,44,208.17,1.8799999999999955]
[null,45,206.29,1.9399999999999977]
[null,46,204.35,1.9799999999999898]
[null,47,202.37,2.0099999999999909]
[null,48,200.36,2]
[null,49,198.36,1.960000000000008]
[null,50,196.4,1.8600000000000136]
[null,{"$f":"B24","v":51},194.54,1.9299999999999784]
[null,52,192.61,2.0200000000000102]
[null,53,190.59,2.1100000000000136]
[null,54,188.48,2.1899999999999977]
[null,55,186.29,2.289999999999992]
[null,56,184,2.3899999999999864]
[null,57,181.61,2.5]
[null,58,179.11,2.6100000000000136]
[null,59,176.5,2.75]
[null,60,173.75,2.8700000000000045]
[null,61,170.88,3.0099999999999909]
[null,62,167.87,3.1599999999999966]
[null,63,164.71,3.3100000000000023]
[null,64,161.4,3.460000000000008]
[null,{"$f":"F8","v":65},{"$f":"G8","v":157.94},{"$f":"H8","v":3.6299999999999955}]
[null,{"$f":"F9","v":66},154.31,3.7400000000000091]
[null,67,150.57,3.8700000000000045]
[null,68,146.69999999999999,3.9799999999999898]
[null,69,142.72,4.0900000000000034]
[null,70,138.63,4.1899999999999977]
[null,71,134.44,4.2800000000000011]
[null,72,130.16,4.3599999999999994]
[null,73,125.8,4.4399999999999977]
[null,74,121.36,4.4899999999999949]
[null,75,116.87,4.5500000000000114]
[null,76,112.32,4.5799999999999983]
[null,77,107.74,4.5999999999999943]
[null,78,103.14,4.6099999999999994]
[null,79,98.53,4.6099999999999994]
[null,80,93.92,4.5900000000000034]
[null,81,89.33,4.539999999999992]
[null,82,84.79,4.480000000000004]
[null,83,80.31,4.3900000000000006]
[null,84,75.92,4.2900000000000063]
[null,85,71.63,4.1499999999999915]
[null,86,67.48,3.990000000000002]
[null,87,63.49,3.8000000000000043]
[null,88,59.69,3.5899999999999963]
[null,89,56.1,3.3500000000000014]
[null,90,52.75,3.1199999999999974]
[null,91,49.63,2.8800000000000026]
[null,92,46.75,2.6899999999999977]
[null,93,44.06,2.5300000000000011]
[null,94,41.53,2.4100000000000037]
[null,95,39.119999999999997,2.3200000000000003]
[null,96,36.799999999999997,2.2099999999999937]
[null,97,34.590000000000003,2.1000000000000014]
[null,98,32.49,1.990000000000002]
[null,99,30.5,1.8599999999999994]

{"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,225.37,1.0099999999999909,null,65,166.56,3.5,null,"Age",{"$f":"Calculations!B15","v":{"$error":"#VALUE!"}}]
[null,36,224.36,1.0700000000000216,null,66,163.06,3.6299999999999955,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,223.29,1.1200000000000045,null,67,159.43,3.75,null,"Mtly Bft",185.7]
[null,38,222.17,1.1799999999999784,null,68,155.68,3.8799999999999955,null,"PV",{"$f":"ROUND(K9*K10,2)","v":{"$error":"#VALUE!"}}]
[null,39,220.99,1.25,null,69,151.80000000000001,4]
[null,40,219.74,1.3100000000000023,null,70,147.80000000000001,4.1100000000000136]
[null,41,218.43,1.3900000000000148,null,71,143.69,4.2199999999999989]
[null,42,217.04,1.4599999999999795,null,72,139.47,4.3199999999999932]
[null,43,215.58,1.5300000000000011,null,73,135.15,4.4099999999999966]
[null,44,214.05,1.6200000000000045,null,74,130.74,4.4900000000000091]
[null,45,212.43,1.6899999999999977,null,75,126.25,4.5600000000000023]
[null,46,210.74,1.7300000000000182,null,76,121.69,4.6099999999999994]
[null,47,209.01,1.7800000000000011,null,77,117.08,4.6700000000000017]
[null,48,207.23,1.7999999999999829,null,78,112.41,4.6899999999999977]
[null,49,205.43,1.8100000000000023,null,79,107.72,4.7000000000000028]
[null,50,203.62,1.7599999999999909,null,80,103.02,4.7000000000000028]
[null,51,201.86,1.8500000000000227,null,81,98.32,4.6799999999999926]
[null,52,200.01,1.9399999999999977,null,82,93.64,4.6200000000000045]
[null,53,198.07,2.0199999999999818,null,83,89.02,4.5499999999999972]
[null,54,196.05,2.1100000000000136,null,84,84.47,4.4599999999999937]
[null,55,193.94,2.210000000000008,null,85,80.010000000000005,4.3299999999999983]
[null,56,191.73,2.3100000000000023,null,86,75.680000000000007,4.1800000000000068]
[null,57,189.42,2.4099999999999966,null,87,71.5,4]
[null,58,187.01,2.5300000000000011,null,88,67.5,3.7999999999999972]
[null,59,184.48,2.6499999999999773,null,89,63.7,3.5800000000000054]
[null,60,181.83,2.7800000000000011,null,90,60.12,3.3499999999999943]
[null,61,179.05,2.910000000000025,null,91,56.77,3.1400000000000006]
[null,62,176.14,3.0499999999999829,null,92,53.63,2.9500000000000028]
[null,63,173.09,3.1899999999999977,null,93,50.68,2.7899999999999991]
[null,64,169.9,3.3400000000000034,null,94,47.89,2.6799999999999997]
[null,null,null,null,null,95,45.21,2.5799999999999983]
[null,null,null,null,null,96,42.63,2.480000000000004]
[null,null,null,null,null,97,40.15,2.3599999999999994]
[null,null,null,null,null,98,37.79,2.240000000000002]
[null,null,null,null,null,99,35.549999999999997,2.1099999999999994]
[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},225.37,1.0099999999999909]
[null,36,224.36,1.0700000000000216]
[null,37,223.29,1.1200000000000045]
[null,38,222.17,1.1799999999999784]
[null,39,220.99,1.25]
[null,40,219.74,1.3100000000000023]
[null,41,218.43,1.3900000000000148]
[null,42,217.04,1.4599999999999795]
[null,43,215.58,1.5300000000000011]
[null,44,214.05,1.6200000000000045]
[null,45,212.43,1.6899999999999977]
[null,46,210.74,1.7300000000000182]
[null,47,209.01,1.7800000000000011]
[null,48,207.23,1.7999999999999829]
[null,49,205.43,1.8100000000000023]
[null,50,203.62,1.7599999999999909]
[null,{"$f":"B24","v":51},201.86,1.8500000000000227]
[null,52,200.01,1.9399999999999977]
[null,53,198.07,2.0199999999999818]
[null,54,196.05,2.1100000000000136]
[null,55,193.94,2.210000000000008]
[null,56,191.73,2.3100000000000023]
[null,57,189.42,2.4099999999999966]
[null,58,187.01,2.5300000000000011]
[null,59,184.48,2.6499999999999773]
[null,60,181.83,2.7800000000000011]
[null,61,179.05,2.910000000000025]
[null,62,176.14,3.0499999999999829]
[null,63,173.09,3.1899999999999977]
[null,64,169.9,3.3400000000000034]
[null,{"$f":"F8","v":65},{"$f":"G8","v":166.56},{"$f":"H8","v":3.5}]
[null,{"$f":"F9","v":66},163.06,3.6299999999999955]
[null,67,159.43,3.75]
[null,68,155.68,3.8799999999999955]
[null,69,151.80000000000001,4]
[null,70,147.80000000000001,4.1100000000000136]
[null,71,143.69,4.2199999999999989]
[null,72,139.47,4.3199999999999932]
[null,73,135.15,4.4099999999999966]
[null,74,130.74,4.4900000000000091]
[null,75,126.25,4.5600000000000023]
[null,76,121.69,4.6099999999999994]
[null,77,117.08,4.6700000000000017]
[null,78,112.41,4.6899999999999977]
[null,79,107.72,4.7000000000000028]
[null,80,103.02,4.7000000000000028]
[null,81,98.32,4.6799999999999926]
[null,82,93.64,4.6200000000000045]
[null,83,89.02,4.5499999999999972]
[null,84,84.47,4.4599999999999937]
[null,85,80.010000000000005,4.3299999999999983]
[null,86,75.680000000000007,4.1800000000000068]
[null,87,71.5,4]
[null,88,67.5,3.7999999999999972]
[null,89,63.7,3.5800000000000054]
[null,90,60.12,3.3499999999999943]
[null,91,56.77,3.1400000000000006]
[null,92,53.63,2.9500000000000028]
[null,93,50.68,2.7899999999999991]
[null,94,47.89,2.6799999999999997]
[null,95,45.21,2.5799999999999983]
[null,96,42.63,2.480000000000004]
[null,97,40.15,2.3599999999999994]
[null,98,37.79,2.240000000000002]
[null,99,35.549999999999997,2.1099999999999994]

{"sheet":"CPI-U Index","index":8,"n_rows":44,"n_cols":10,"rows_kept":44,"cut":false,"hidden":true,"merged":[]}
[]
[{"$f":"IF(AND($E2<=Calculations!$B$56,'CPI-U Index'!$F2>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E2<=Calculations!$B$57,'CPI-U Index'!$F2>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E2<=Calculations!$B$58,'CPI-U Index'!$F2>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E2<=Calculations!$B$59,'CPI-U Index'!$F2>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2008-10-01","2009-09-30",4.9000000000000002E-2,{"$f":"G2*1.5","v":7.350000000000001E-2},0.06,{"$f":"MAX(H2:I2)","v":7.350000000000001E-2}]
[{"$f":"IF(AND($E3<=Calculations!$B$56,'CPI-U Index'!$F3>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E3<=Calculations!$B$57,'CPI-U Index'!$F3>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E3<=Calculations!$B$58,'CPI-U Index'!$F3>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E3<=Calculations!$B$59,'CPI-U Index'!$F3>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2009-10-01","2010-09-30",-1.2999999999999999E-2,{"$f":"G3*1.5","v":-1.95E-2},0.06,{"$f":"MAX(H3:I3)","v":0.06}]
[{"$f":"IF(AND($E4<=Calculations!$B$56,'CPI-U Index'!$F4>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E4<=Calculations!$B$57,'CPI-U Index'!$F4>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E4<=Calculations!$B$58,'CPI-U Index'!$F4>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E4<=Calculations!$B$59,'CPI-U Index'!$F4>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2010-10-01","2011-09-30",1.0999999999999999E-2,1.6500000000000001E-2,0.06,0.06]
[{"$f":"IF(AND($E5<=Calculations!$B$56,'CPI-U Index'!$F5>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E5<=Calculations!$B$57,'CPI-U Index'!$F5>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E5<=Calculations!$B$58,'CPI-U Index'!$F5>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E5<=Calculations!$B$59,'CPI-U Index'!$F5>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2011-10-01","2012-09-30",3.9E-2,5.8499999999999996E-2,0.06,0.06]
[{"$f":"IF(AND($E6<=Calculations!$B$56,'CPI-U Index'!$F6>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E6<=Calculations!$B$57,'CPI-U Index'!$F6>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E6<=Calculations!$B$58,'CPI-U Index'!$F6>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E6<=Calculations!$B$59,'CPI-U Index'!$F6>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2012-10-01","2013-09-30",0.02,0.03,0.06,0.06]
[{"$f":"IF(AND($E7<=Calculations!$B$56,'CPI-U Index'!$F7>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E7<=Calculations!$B$57,'CPI-U Index'!$F7>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E7<=Calculations!$B$58,'CPI-U Index'!$F7>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E7<=Calculations!$B$59,'CPI-U Index'!$F7>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2013-10-01","2014-09-30",1.2E-2,1.8000000000000002E-2,0.06,0.06]
[{"$f":"IF(AND($E8<=Calculations!$B$56,'CPI-U Index'!$F8>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E8<=Calculations!$B$57,'CPI-U Index'!$F8>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E8<=Calculations!$B$58,'CPI-U Index'!$F8>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E8<=Calculations!$B$59,'CPI-U Index'!$F8>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2014-10-01","2015-09-30",1.7000000000000001E-2,2.5500000000000002E-2,0.06,0.06]
[{"$f":"IF(AND($E9<=Calculations!$B$56,'CPI-U Index'!$F9>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E9<=Calculations!$B$57,'CPI-U Index'!$F9>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E9<=Calculations!$B$58,'CPI-U Index'!$F9>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E9<=Calculations!$B$59,'CPI-U Index'!$F9>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2015-10-01","2016-09-30",0,0,0.06,0.06]
[{"$f":"IF(AND($E10<=Calculations!$B$56,'CPI-U Index'!$F10>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E10<=Calculations!$B$57,'CPI-U Index'!$F10>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E10<=Calculations!$B$58,'CPI-U Index'!$F10>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E10<=Calculations!$B$59,'CPI-U Index'!$F10>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2016-10-01","2017-09-30",1.4999999999999999E-2,2.2499999999999999E-2,0.06,0.06]
[{"$f":"IF(AND($E11<=Calculations!$B$56,'CPI-U Index'!$F11>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E11<=Calculations!$B$57,'CPI-U Index'!$F11>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E11<=Calculations!$B$58,'CPI-U Index'!$F11>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E11<=Calculations!$B$59,'CPI-U Index'!$F11>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2017-10-01","2018-09-30",2.2329999999999999E-2,3.3494999999999997E-2,0.06,0.06]
[{"$f":"IF(AND($E12<=Calculations!$B$56,'CPI-U Index'!$F12>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E12<=Calculations!$B$57,'CPI-U Index'!$F12>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E12<=Calculations!$B$58,'CPI-U Index'!$F12>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E12<=Calculations!$B$59,'CPI-U Index'!$F12>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2018-10-01","2019-09-30",2.2769999999999999E-2,3.4154999999999998E-2,0.06,0.06]
[{"$f":"IF(AND($E13<=Calculations!$B$56,'CPI-U Index'!$F13>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E13<=Calculations!$B$57,'CPI-U Index'!$F13>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E13<=Calculations!$B$58,'CPI-U Index'!$F13>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E13<=Calculations!$B$59,'CPI-U Index'!$F13>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2019-10-01","2020-09-30",1.711E-2,2.5665E-2,0.06,0.06]
[{"$f":"IF(AND($E14<=Calculations!$B$56,'CPI-U Index'!$F14>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E14<=Calculations!$B$57,'CPI-U Index'!$F14>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E14<=Calculations!$B$58,'CPI-U Index'!$F14>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E14<=Calculations!$B$59,'CPI-U Index'!$F14>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2020-10-01","2021-09-30",1.371E-2,2.0565E-2,0.06,0.06]
[{"$f":"IF(AND($E15<=Calculations!$B$56,'CPI-U Index'!$F15>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E15<=Calculations!$B$57,'CPI-U Index'!$F15>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E15<=Calculations!$B$58,'CPI-U Index'!$F15>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E15<=Calculations!$B$59,'CPI-U Index'!$F15>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2021-10-01","2022-12-31",5.3900000000000003E-2,8.0850000000000005E-2,0.06,8.0850000000000005E-2]
[{"$f":"IF(AND($E16<=Calculations!$B$56,'CPI-U Index'!$F16>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E16<=Calculations!$B$57,'CPI-U Index'!$F16>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E16<=Calculations!$B$58,'CPI-U Index'!$F16>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E16<=Calculations!$B$59,'CPI-U Index'!$F16>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2023-01-01","2023-12-31",8.2000000000000003E-2,0.123,0.06,{"$f":"MAX(H16:I16)","v":0.123}]
[{"$f":"IF(AND($E17<=Calculations!$B$56,'CPI-U Index'!$F17>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E17<=Calculations!$B$57,'CPI-U Index'!$F17>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E17<=Calculations!$B$58,'CPI-U Index'!$F17>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E17<=Calculations!$B$59,'CPI-U Index'!$F17>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2024-01-01","2024-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E18<=Calculations!$B$56,'CPI-U Index'!$F18>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E18<=Calculations!$B$57,'CPI-U Index'!$F18>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E18<=Calculations!$B$58,'CPI-U Index'!$F18>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E18<=Calculations!$B$59,'CPI-U Index'!$F18>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2025-01-01","2025-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E19<=Calculations!$B$56,'CPI-U Index'!$F19>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E19<=Calculations!$B$57,'CPI-U Index'!$F19>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E19<=Calculations!$B$58,'CPI-U Index'!$F19>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E19<=Calculations!$B$59,'CPI-U Index'!$F19>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2026-01-01","2026-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E20<=Calculations!$B$56,'CPI-U Index'!$F20>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E20<=Calculations!$B$57,'CPI-U Index'!$F20>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E20<=Calculations!$B$58,'CPI-U Index'!$F20>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E20<=Calculations!$B$59,'CPI-U Index'!$F20>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2027-01-01","2027-12-31",0,{"$f":"G20*1.5","v":0},0.06,0.06]
[{"$f":"IF(AND($E21<=Calculations!$B$56,'CPI-U Index'!$F21>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E21<=Calculations!$B$57,'CPI-U Index'!$F21>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E21<=Calculations!$B$58,'CPI-U Index'!$F21>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E21<=Calculations!$B$59,'CPI-U Index'!$F21>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2028-01-01","2028-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E22<=Calculations!$B$56,'CPI-U Index'!$F22>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E22<=Calculations!$B$57,'CPI-U Index'!$F22>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E22<=Calculations!$B$58,'CPI-U Index'!$F22>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E22<=Calculations!$B$59,'CPI-U Index'!$F22>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2029-01-01","2029-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E23<=Calculations!$B$56,'CPI-U Index'!$F23>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E23<=Calculations!$B$57,'CPI-U Index'!$F23>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E23<=Calculations!$B$58,'CPI-U Index'!$F23>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E23<=Calculations!$B$59,'CPI-U Index'!$F23>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2030-01-01","2030-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E24<=Calculations!$B$56,'CPI-U Index'!$F24>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E24<=Calculations!$B$57,'CPI-U Index'!$F24>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E24<=Calculations!$B$58,'CPI-U Index'!$F24>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E24<=Calculations!$B$59,'CPI-U Index'!$F24>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2031-01-01","2031-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E25<=Calculations!$B$56,'CPI-U Index'!$F25>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E25<=Calculations!$B$57,'CPI-U Index'!$F25>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E25<=Calculations!$B$58,'CPI-U Index'!$F25>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E25<=Calculations!$B$59,'CPI-U Index'!$F25>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2032-01-01","2032-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E26<=Calculations!$B$56,'CPI-U Index'!$F26>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E26<=Calculations!$B$57,'CPI-U Index'!$F26>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E26<=Calculations!$B$58,'CPI-U Index'!$F26>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E26<=Calculations!$B$59,'CPI-U Index'!$F26>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2033-01-01","2033-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E27<=Calculations!$B$56,'CPI-U Index'!$F27>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E27<=Calculations!$B$57,'CPI-U Index'!$F27>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E27<=Calculations!$B$58,'CPI-U Index'!$F27>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E27<=Calculations!$B$59,'CPI-U Index'!$F27>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2034-01-01","2034-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E28<=Calculations!$B$56,'CPI-U Index'!$F28>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E28<=Calculations!$B$57,'CPI-U Index'!$F28>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E28<=Calculations!$B$58,'CPI-U Index'!$F28>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E28<=Calculations!$B$59,'CPI-U Index'!$F28>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2035-01-01","2035-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E29<=Calculations!$B$56,'CPI-U Index'!$F29>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E29<=Calculations!$B$57,'CPI-U Index'!$F29>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E29<=Calculations!$B$58,'CPI-U Index'!$F29>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E29<=Calculations!$B$59,'CPI-U Index'!$F29>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2036-01-01","2036-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E30<=Calculations!$B$56,'CPI-U Index'!$F30>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E30<=Calculations!$B$57,'CPI-U Index'!$F30>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E30<=Calculations!$B$58,'CPI-U Index'!$F30>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E30<=Calculations!$B$59,'CPI-U Index'!$F30>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2037-01-01","2037-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E31<=Calculations!$B$56,'CPI-U Index'!$F31>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E31<=Calculations!$B$57,'CPI-U Index'!$F31>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E31<=Calculations!$B$58,'CPI-U Index'!$F31>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E31<=Calculations!$B$59,'CPI-U Index'!$F31>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2038-01-01","2038-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E32<=Calculations!$B$56,'CPI-U Index'!$F32>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E32<=Calculations!$B$57,'CPI-U Index'!$F32>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E32<=Calculations!$B$58,'CPI-U Index'!$F32>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E32<=Calculations!$B$59,'CPI-U Index'!$F32>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2039-01-01","2039-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E33<=Calculations!$B$56,'CPI-U Index'!$F33>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E33<=Calculations!$B$57,'CPI-U Index'!$F33>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E33<=Calculations!$B$58,'CPI-U Index'!$F33>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E33<=Calculations!$B$59,'CPI-U Index'!$F33>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2040-01-01","2040-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E34<=Calculations!$B$56,'CPI-U Index'!$F34>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E34<=Calculations!$B$57,'CPI-U Index'!$F34>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E34<=Calculations!$B$58,'CPI-U Index'!$F34>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E34<=Calculations!$B$59,'CPI-U Index'!$F34>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2041-01-01","2041-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E35<=Calculations!$B$56,'CPI-U Index'!$F35>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E35<=Calculations!$B$57,'CPI-U Index'!$F35>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E35<=Calculations!$B$58,'CPI-U Index'!$F35>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E35<=Calculations!$B$59,'CPI-U Index'!$F35>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2042-01-01","2042-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E36<=Calculations!$B$56,'CPI-U Index'!$F36>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E36<=Calculations!$B$57,'CPI-U Index'!$F36>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E36<=Calculations!$B$58,'CPI-U Index'!$F36>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E36<=Calculations!$B$59,'CPI-U Index'!$F36>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2043-01-01","2043-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E37<=Calculations!$B$56,'CPI-U Index'!$F37>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E37<=Calculations!$B$57,'CPI-U Index'!$F37>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E37<=Calculations!$B$58,'CPI-U Index'!$F37>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E37<=Calculations!$B$59,'CPI-U Index'!$F37>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2044-01-01","2044-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E38<=Calculations!$B$56,'CPI-U Index'!$F38>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E38<=Calculations!$B$57,'CPI-U Index'!$F38>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E38<=Calculations!$B$58,'CPI-U Index'!$F38>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E38<=Calculations!$B$59,'CPI-U Index'!$F38>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2045-01-01","2045-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E39<=Calculations!$B$56,'CPI-U Index'!$F39>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E39<=Calculations!$B$57,'CPI-U Index'!$F39>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E39<=Calculations!$B$58,'CPI-U Index'!$F39>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E39<=Calculations!$B$59,'CPI-U Index'!$F39>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2046-01-01","2046-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E40<=Calculations!$B$56,'CPI-U Index'!$F40>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E40<=Calculations!$B$57,'CPI-U Index'!$F40>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E40<=Calculations!$B$58,'CPI-U Index'!$F40>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E40<=Calculations!$B$59,'CPI-U Index'!$F40>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2047-01-01","2047-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E41<=Calculations!$B$56,'CPI-U Index'!$F41>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E41<=Calculations!$B$57,'CPI-U Index'!$F41>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E41<=Calculations!$B$58,'CPI-U Index'!$F41>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E41<=Calculations!$B$59,'CPI-U Index'!$F41>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2048-01-01","2048-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E42<=Calculations!$B$56,'CPI-U Index'!$F42>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E42<=Calculations!$B$57,'CPI-U Index'!$F42>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E42<=Calculations!$B$58,'CPI-U Index'!$F42>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E42<=Calculations!$B$59,'CPI-U Index'!$F42>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2049-01-01","2049-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E43<=Calculations!$B$56,'CPI-U Index'!$F43>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E43<=Calculations!$B$57,'CPI-U Index'!$F43>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E43<=Calculations!$B$58,'CPI-U Index'!$F43>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E43<=Calculations!$B$59,'CPI-U Index'!$F43>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2050-01-01","2050-12-31",0,0,0.06,0.06]
[{"$f":"IF(AND($E44<=Calculations!$B$56,'CPI-U Index'!$F44>=Calculations!$B$56),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E44<=Calculations!$B$57,'CPI-U Index'!$F44>=Calculations!$B$57),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E44<=Calculations!$B$58,'CPI-U Index'!$F44>=Calculations!$B$58),1,0)","v":{"$error":"#NUM!"}},{"$f":"IF(AND($E44<=Calculations!$B$59,'CPI-U Index'!$F44>=Calculations!$B$59),1,0)","v":{"$error":"#NUM!"}},"2051-01-01","2051-12-31",0,0,0.06,0.06]