{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["TMPO Calculator","State Benefits Premiums","Breakdown"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":5,"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":"TMPO Calculator","index":0,"n_rows":33,"n_cols":12,"rows_kept":33,"cut":false,"hidden":false,"merged":[[32,1,33,11],[19,1,19,11],[20,3,20,11],[21,5,21,11],[25,1,25,11],[26,1,26,11],[27,1,27,11],[30,1,30,11],[24,5,24,11],[22,5,22,11],[0,1,0,11],[2,1,2,11],[4,1,4,11],[8,1,8,11],[3,1,3,11],[5,1,5,11],[6,1,6,11],[7,1,7,11],[1,1,1,11],[16,1,16,11],[9,1,9,11],[23,5,23,11],[18,1,18,11],[13,1,13,11],[10,1,10,11],[15,1,15,11],[17,1,17,11],[11,1,11,11],[12,1,12,11],[14,1,14,11]]}
[null,"Twelve-Month Payment Option"]
[]
[null,"The \"Estimating Your Deduction for 24 Equal Paychecks\" calculator below will calculate the deduction amounts you should elect in order to receive approximately equal net payments for 24 pay periods.\n"]
[]
[null,"Once you decide upon your twelve-month payment option deduction amount(s), please complete the Twelve-Month Payment Option form located on the Human Resources website. You may also wish to refer to the Twelve-Month Payment Option Plan FAQs document, also located on the Human Resources website.  To go to the Human Resources website, you may click on the following link:"]
[]
[null,"http://hr.ucf.edu"]
[]
[null,"Using the Estimating Your Deduction for 24 Equal Paychecks Calculator"]
[]
[null,"To use the \"Estimating Your Deduction for 24 Equal Paychecks\" calculator, you will enter your net pay below and any State benefits premiums that are double deducted in the spring on the \"State Benefits Premiums\" worksheet. Your net pay and State benefits premiums can be found on your pay advice. If you would like instructions on how to find your pay advice, click on the following link:"]
[]
[null,"http://hr.ucf.edu/files/Pay_Advice_Access_Presentation.pdf"]
[]
[null,"Your net pay is located on your pay advice in the middle of the page on the right side under \"NET PAY.\" Your State benefits premiums are located in the middle of the page on the left side under \"BEFORE-TAX DEDUCTIONS\" and in the middle of the page in the center under \"AFTER-TAX DEDUCTIONS.\"  When determining the net pay to enter, use a \"normal\" pay period - one that does not contain double deductions for insurances. Keep in mind that there are a number of variables that will affect your net pay. For example, double deductions, changes to your benefit elections, taxes, pay increases and decreases, dual compensation, supplemental payments, awards and retroactive payments, etc. will produce variances in your net pay. "]
[]
[null,"State benefits for nine-month faculty members are double deducted between February and May of each year.  If you are subject to double deductions, enter your State benefit premiums on the \"State Benefits Premiums\" worksheet. The worksheet will sum the deductions you enter. This figure, which will be automatically populated in the \"State Benefits Premiums\" box below, will be used to estimate your net pay for the paychecks where double deductions are taken."]
[]
[null,"Estimating Your Deduction for 24 Approximately Equal Paychecks"]
[]
[null,"Enter Your Net Pay Below"]
[null,1404.03,null,null,null,"Enter Net Pay from Pay Advice\n*from a January Paydate for the current calendar year \n(pre-double deduction period which begins in February)"]
[]
[null,"State Benefits Premiums"]
[null,{"$f":"+'State Benefits Premiums'!F32","v":90},null,null,null,"Sum of all State Benefits Deductions\n(from State Benefits Premiums worksheet)"]
[]
[]
[]
[null,"Current Net Pay on \"Normal\" Paychecks",null,"Fall Set-Aside Deduction Amount ",null,"Spring Set-Aside Deduction Amount",null,"New Estimated Net Pay on 11 Fall Paychecks",null,"Estimated Net Pay on  8 Spring Paychecks",null,"Estimated Net Pay on 5 Summer Paychecks"]
[null,{"$f":"Pre_Double_Deduction_Net_Amount","v":1404.03},null,{"$f":"(Pre_Double_Deduction_Net_Amount-(((Pre_Double_Deduction_Net_Amount*19)-(Sum_of_State_Benefits_Deductions*8))/24))","v":322.50624999999991},null,{"$f":"Pre_Double_Deduction_Net_Amount-Sum_of_State_Benefits_Deductions-H30","v":232.50624999999991},null,{"$f":"Pre_Double_Deduction_Net_Amount-Fall_Set_Aside_Deduction_Amount","v":1081.5237500000001},null,{"$f":"Pre_Double_Deduction_Net_Amount-Spring_Set_Aside_Deduction_Amount-Sum_of_State_Benefits_Deductions","v":1081.5237500000001},null,{"$f":"((Fall_Set_Aside_Deduction_Amount*11)+(Spring_Set_Aside_Deduction_Amount*8))/5","v":1081.5237499999996}]
[]
[]
[null,"If you have any questions regarding this calculator or the Twelve-Month Payment Option, please contact Payroll Services at payroll@ucf.edu."]

{"sheet":"State Benefits Premiums","index":1,"n_rows":32,"n_cols":6,"rows_kept":32,"cut":false,"hidden":false,"merged":[[31,1,31,4],[2,1,4,5],[0,1,0,5]]}
[null,"Twelve-Month Payment Option Calculator\nState Benefits Premiums Worksheet"]
[]
[null,"Please enter the premiums for each of the following deductions taken from your regular paycheck (a paycheck prior to those that contain double deductions for State benefits)."]
[]
[]
[]
[]
[null,"Deduction Description on Paycheck",null,"Full Deduction Description",null,"Premium Amount from Pay Advice"]
[null,"AFL Sup Cr",null,"AFLAC Supplemental Cancer",null,0]
[null,"AFL Sup IC",null,"AFLAC Supp Intensive Care",null,0]
[null,"Alta"]
[null,"Alta Supp",null,null,null,0]
[null,"Col Acc/Pr",null,"Colonial Accident Protection",null,0]
[null,"Col Dis Pr",null,"Colonial Acc Dis Income Prot",null,0]
[null,"Col Sup Cr",null,"Colonial Supplemental Cancer",null,0]
[null,"DDC Reimb",null,"Dependent Day Care Reimb Ac",null,"$"]
[null,"Gab Hs Inc",null,"Gabor Hospital Income",null,0]
[null,"Cigna",null,null,null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[]
[]
[null,"HSA",null,"Health Savings Account"]
[null,"LPMRA",null,"Limited Purpose Med Reimb Act"]
[null,"Med Reimb",null,"Medical Reimbursement Acct"]
[null,"PretaxVis",null,"Pretax Vision Plan",null,0]
[null,"PretaxDntl",null,"Pretax Dental Contriubtion",null,0]
[null,"Pretax Hlt",null,"Pretax Health Contribution",null,90]
[null,"Pretax Life",null,"Pretax Basic Life (if less than 1.00 FTE)",null,0]
[null,null,null,null,null,0]
[null,null,null,null,null,0]
[null,"Total State Benefits Premiums",null,null,null,{"$f":"SUM(F9:F31)","v":90}]

{"sheet":"Breakdown","index":2,"n_rows":30,"n_cols":7,"rows_kept":30,"cut":false,"hidden":true,"merged":[]}
[null,"Normal Net Payment","Fall Set-Aside Deductions","Spring Set-Aside Deductions","Spring Double Deductions","New Net Pay"]
[1,{"$f":"Pre_Double_Deduction_Net_Amount","v":1404.03},{"$f":"-Fall_Set_Aside_Deduction_Amount","v":-322.50624999999991},null,null,{"$f":"SUM(B2:E2)","v":1081.5237500000001},1]
[2,1404.03,-322.50624999999991,null,null,1081.5237500000001,2]
[3,1404.03,-322.50624999999991,null,null,1081.5237500000001,3]
[4,1404.03,-322.50624999999991,null,null,1081.5237500000001,4]
[5,1404.03,-322.50624999999991,null,null,1081.5237500000001,5]
[6,1404.03,-322.50624999999991,null,null,1081.5237500000001,6]
[7,1404.03,-322.50624999999991,null,null,1081.5237500000001,7]
[8,1404.03,-322.50624999999991,null,null,1081.5237500000001,8]
[9,1404.03,-322.50624999999991,null,null,1081.5237500000001,9]
[10,1404.03,-322.50624999999991,null,null,1081.5237500000001,10]
[11,1404.03,-322.50624999999991,null,null,1081.5237500000001,11]
[12,1404.03,null,{"$f":"-Spring_Set_Aside_Deduction_Amount","v":-232.50624999999991},{"$f":"-Sum_of_State_Benefits_Deductions","v":-90},1081.5237500000001,12]
[13,1404.03,null,-232.50624999999991,-90,1081.5237500000001,13]
[14,1404.03,null,-232.50624999999991,-90,1081.5237500000001,14]
[15,1404.03,null,-232.50624999999991,-90,1081.5237500000001,15]
[16,1404.03,null,-232.50624999999991,-90,1081.5237500000001,16]
[17,1404.03,null,-232.50624999999991,-90,1081.5237500000001,17]
[18,1404.03,null,-232.50624999999991,-90,1081.5237500000001,18]
[19,1404.03,null,-232.50624999999991,-90,1081.5237500000001,19]
[]
[null,{"$f":"SUM(B2:B21)","v":26676.569999999996},{"$f":"SUM(C2:C21)","v":-3547.568749999999},{"$f":"SUM(D2:D21)","v":-1860.0499999999993},null,{"$f":"-SUM(C22:D22)","v":5407.6187499999978}]
[]
[null,null,"Balance",null,null,"Summer"]
[1,null,{"$f":"F22","v":5407.6187499999978},null,null,{"$f":"$C$25/5","v":1081.5237499999996},1]
[2,null,{"$f":"C25-F25","v":4326.0949999999984},null,null,{"$f":"$C$25/5","v":1081.5237499999996},2]
[3,null,{"$f":"C26-F26","v":3244.5712499999991},null,null,{"$f":"$C$25/5","v":1081.5237499999996},3]
[4,null,{"$f":"C27-F27","v":2163.0474999999997},null,null,{"$f":"$C$25/5","v":1081.5237499999996},4]
[5,null,{"$f":"C28-F28","v":1081.5237500000001},null,null,{"$f":"$C$25/5","v":1081.5237499999996},5]
[null,null,{"$f":"C29-F29","v":0}]