{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"Sheet1","index":0,"n_rows":67,"n_cols":15,"rows_kept":67,"cut":false,"hidden":false,"merged":[[29,0,29,5],[31,0,31,5],[33,0,33,5],[22,0,22,1],[23,0,23,1],[3,0,3,1],[3,2,3,5],[25,0,25,5],[0,0,2,5],[15,4,15,5],[4,0,4,2],[4,4,4,5],[9,4,9,5],[15,0,15,1],[16,0,16,1],[17,0,17,1],[18,0,18,1],[19,0,19,1],[21,0,21,1]]}
["Pension Spiking Estimate",null,null,null,null,null,null,null,null,null,null,null,null,"Age","Annuity Factor"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,30,14.3239]
[null,null,null,null,null,null,null,null,null,null,null,null,null,31,14.2918]
["Name:",null,null,null,null,null,null,null,null,null,null,null,null,32,14.2577]
["Average Final Compensation Estimate",null,null,null,"Years of Service",null,null,null,null,null,null,null,null,33,14.221399999999999]
["Year 1 (Current Year)",null,0,null,"Years",0,null,null,null,null,null,null,null,34,14.182700000000001]
["Year 2",null,0,null,"Months",0,null,null,null,null,null,null,null,35,14.141400000000001]
["Year 3",null,0,null,"Total",{"$f":"F6+(F7/12)","v":0},null,null,null,null,null,null,null,36,14.0975]
["Year 4",null,0,null,null,null,null,null,null,null,null,null,null,37,14.050599999999999]
["Leave Payout",null,{"$f":"(B11*B12)","v":0},null,"TSERS Benefit Estimate",null,null,null,null,null,null,null,null,38,14.000500000000001]
["Hourly Rate",0,null,null,"AFC",{"$f":"C14","v":0},null,null,null,null,null,null,null,39,13.947100000000001]
["Hours (Lv to be paid)",0,null,null,"Multiplier",1.8200000000000001E-2,null,null,null,null,null,null,null,40,13.8902]
["Longevity Payout",null,0,null,"YOS",{"$f":"F8","v":0},null,null,null,null,null,null,null,41,13.829599999999999]
["AFC Estimate",null,{"$f":"SUM(C6:C13)/4","v":0},null,null,{"$f":"F11*F12*F13","v":0},null,null,null,null,null,null,null,42,13.765000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,43,13.696300000000001]
["Total EE Contribution",null,{"$f":"F23","v":0},null,"Projected Additional Contributions**",null,null,null,null,null,null,null,null,44,13.6233]
["Age***",null,0,null,"Additional Salary",0,null,null,null,null,null,null,null,45,13.5457]
["Annuity Factor",null,{"$f":"IF(ISERROR(VLOOKUP(C17,$N$2:$O$67,2,FALSE)),0,VLOOKUP(C17,$N$2:$O$67,2,FALSE))","v":0},null,"Salary times 6% EE Contribution",{"$f":"F17*0.06","v":0},null,null,null,null,null,null,null,46,13.4634]
["Benefit Cap Factor",null,4.5,null,null,null,null,null,null,null,null,null,null,47,13.376200000000001]
["Benefit Cap",null,{"$f":"IF(ISERROR((C16/C18)*C19),0,(C16/C18)*C19)","v":0},null,"Current EE Contributions*",0,null,null,null,null,null,null,null,48,13.2837]
[null,null,null,null,"Proj Additional Contribs",{"$f":"F18","v":0},null,null,null,null,null,null,null,49,13.185700000000001]
["Max Ben - Ben Cap",null,{"$f":"F14-C20","v":0},null,"From Payouts",{"$f":"(C10+C13)*0.06","v":0},null,null,null,null,null,null,null,50,13.082000000000001]
["Annuity Factor",null,{"$f":"C18","v":0},null,"Total EE Contributions",{"$f":"SUM(F20:F22)","v":0},null,null,null,null,null,null,null,51,12.9869]
[{"$f":"\"Amount We \"&IF(C22<=0,\"Don't Pay\",\"Pay\")","v":"Amount We Don't Pay"},null,{"$f":"C22*C23","v":0},null,null,null,null,null,null,null,null,null,null,52,12.887]
[null,null,null,null,null,null,null,null,null,null,null,null,null,53,12.7821]
["Instuctions: Fill in the Green cells.  FYI, \"Hours (Lv to be paid)\" is the number of hours of leave for payout, enter the number of leave hours. Hourly rate is the current rate for the employee.",null,null,null,null,null,null,null,null,null,null,null,null,54,12.6721]
[null,null,null,null,null,null,null,null,null,null,null,null,null,55,12.556699999999999]
["*** Age is rounded up if it is 6 ½ months after the employee's last birthday.",null,null,null,null,null,null,null,null,null,null,null,null,56,12.435600000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,57,12.3085]
["** Projected Additional Contributions is the additonal amount contributed (salary * 6%) between when ORBIT stops and the employee retires. You will have to calculate this amount. ",null,null,null,null,null,null,null,null,null,null,null,null,58,12.1752]
[null,null,null,null,null,null,null,null,null,null,null,null,null,59,12.0351]
["* Current EE Contributions is available under the ORBIT View Account History menu. Use the Total Balance amount (Pre Tax Contribution PLUS Interest amounts). ",null,null,null,null,null,null,null,null,null,null,null,null,60,11.888]
[null,null,null,null,null,null,null,null,null,null,null,null,null,61,11.733499999999999]
["AMOUNT WE PAY - if amount is negative, you do not owe. If positive, then that is the est. amount owed",null,null,null,null,null,null,null,null,null,null,null,null,62,11.5716]
[null,null,null,null,null,null,null,null,null,null,null,null,null,63,11.401999999999999]
["Press \"Clear Entries\" if you want to start a new calculation.",null,null,null,null,null,null,null,null,null,null,null,null,64,11.2242]
[null,null,null,null,null,null,null,null,null,null,null,null,null,65,11.0381]
[null,null,null,null,null,null,null,null,null,null,null,null,null,66,10.8431]
[null,null,null,null,null,null,null,null,null,null,null,null,null,67,10.639099999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,68,10.425800000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,69,10.2029]
[null,null,null,null,null,null,null,null,null,null,null,null,null,70,9.9702999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,71,9.7277000000000005]
[null,null,null,null,null,null,null,null,null,null,null,null,null,72,9.4748999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,73,9.2116000000000007]
[null,null,null,null,null,null,null,null,null,null,null,null,null,74,8.9377999999999993]
[null,null,null,null,null,null,null,null,null,null,null,null,null,75,8.6532999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,76,8.3576999999999995]
[null,null,null,null,null,null,null,null,null,null,null,null,null,77,8.0508000000000006]
[null,null,null,null,null,null,null,null,null,null,null,null,null,78,7.7325999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,79,7.4485000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,80,7.1604999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,81,6.8693]
[null,null,null,null,null,null,null,null,null,null,null,null,null,82,6.5759999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,83,6.2816000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,84,5.9874000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,85,5.6944999999999997]
[null,null,null,null,null,null,null,null,null,null,null,null,null,86,5.4042000000000003]
[null,null,null,null,null,null,null,null,null,null,null,null,null,87,5.1181999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,88,4.8381999999999996]
[null,null,null,null,null,null,null,null,null,null,null,null,null,89,4.5655999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,90,4.3022999999999998]
[null,null,null,null,null,null,null,null,null,null,null,null,null,91,4.0503]
[null,null,null,null,null,null,null,null,null,null,null,null,null,92,3.8102]
[null,null,null,null,null,null,null,null,null,null,null,null,null,93,3.5817999999999999]
[null,null,null,null,null,null,null,null,null,null,null,null,null,94,3.3643000000000001]
[null,null,null,null,null,null,null,null,null,null,null,null,null,95,3.1562999999999999]