{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","Lump Sum Calculator"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":27,"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":"Instructions","index":0,"n_rows":25,"n_cols":2,"rows_kept":25,"cut":false,"hidden":false,"merged":[[0,0,0,1]]}
["Disclaimer"]
["This calculator is designed as a tool to assist with the submission of Separation PARs to SCO with Pre-taxed Deferred Compensation."]
["SCO does not take responsibility or liability for the accuracy of the content that is contained, or entered in this tool."]
["It is not intended to provide legal, investment, tax, or accounting advice."]
["You assume full responsibility for any and all claims or disputes arising from the use of this calculator."]
["There is no guarantee this tool will be readily available at all times without interruption or error free."]
["In no event will SCO, its respective service providers, or employees be liable to you or any third party for any "]
["punitive damages or losses as a result of the information created with the use of this tool."]
[]
["Field"," Instructions"]
["Employee Name ","Complete employee's name."]
["Lump Sum Pay Period\n(LS PP)","Refers to the pay period lump sum will begin issuing.  (i.e. - Employee separation effective date is 10/30/19 - Pay period lump sum begins will be 11/19, for the November 2019 pay period with \"0\" Days \"0\" Hours of \"Regular Pay\".)"]
["Regular Pay","Complete regular pay possible per separation effective date.  (i.e. - Employee separation effective date is 10/15/19, \"LS PP\" will show 10/19 for the October 2019 pay period; completing Regular Pay possible for the pay period as \"11\" Days \"0\" Hours.) "]
["Salary Rate","Enter salary rate lump sum should be paid.  *Include any Earnings IDs (EIDs) in the rate that are subject to lump sum. "]
["Tax Year","Choose the tax year lump sum payments will be issued.  *If the current tax year is not available, please contact the Statewide Customer Contact Center at (916) 372-7200."]
["Social Security","Select from drop down if employee is subject to Social Security."]
["Medicare","Select from drop down if employee is subject to Medicare.  *Employee is automatically subjected to Medicare when also subjected to Social Security."]
["Vacation","*If applicable - Complete days and hours employee is entitled to for Vacation or Annual Leave (Payment Type 4).  If \"Days\" exceed over 99 convert remaining time to hours. (i.e. 99 Days 500 Hours Vacation)"]
["Extra ","*If applicable - Complete days and hours employee is entitled to for Extra (Payment Type 3).  If \"Days\" exceed over 99 convert remaining time to hours.  (i.e. 99 Days 300 Hours Extra)"]
["Sick ","*See PAM 3.250. This field may only be completed if separation is an S71 Transaction due to WCTD/IDL. (Payment Type 5)"]
["SS Withheld","*See PPM H256 for Social Security contribution rates and limitations.\nRefer to Social Security withheld on TAXI (Year to Date) and enter in \"SS Withheld\".  Social Security will then be withheld from the lump sum pay.\n*NOTE : You will need to take into consideration any payments other than lump sum, that will have an issue date within the same tax year but have not been included on the TAXI \"SS Withheld\" at the time of your lump sum calculation.  i.e. - Master warrant will be issued, redeposit/reissue of pay, shift, overtime etc."]
["Med Tax Gross","*See PPM H275 for contribution rates and limitations.\nRefer to Medicare Taxable Gross on TAXI and enter in \"Med Tax Gross\".  Medicare will then be withheld from the lump sum pay.\n*NOTE: Wages subject to Medicare in excess of $200,000 will be withheld at 2.35% for the employee."]
["Buffer","Amount needed to allow the payroll system to perform tax calculations within a given pay period so the deferral amount can be applied to the lump sum pay.  This amount ($50.00 for a full month /$100.00 for partial month) will be subtracted after SS/MED to determine the Max Amount available. "]
["Max Amount","The maximum amount the employee has available to defer after Social Security and/or Medicare (if applicable) are/is withheld and buffer is subtracted. "]
["Deferral Amount","Enter the amount to be deferred for each pay period.\nThe deferral amount must be equal to or less than the \"Max Amount\" available.\nRefer to \"Def Comp/Roth\" fields in TAXI (select F4) to determine what has already been deferred for the tax year.  You must also take into consideration if there will be regular pay that issues with monthly 401/457 contributions in the tax year to determine the deferral amount to apply to lump sum. (Contributions to the 403(b) must be included in the 401K totals. (select F8 for 2nd screen on TAXI)"]

{"sheet":"Lump Sum Calculator","index":1,"n_rows":78,"n_cols":58,"rows_kept":78,"cut":false,"hidden":false,"merged":[[2,2,2,7],[5,7,5,8],[4,10,4,11],[5,10,5,11]]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"revised 10/23/2023"]
[null,null,"Employee Name",null,null,null,null,null,null,null,null,null,null,"Pre-Tax Lump Sum Calculator"]
[]
[null,null,null,null,"Regular Pay"]
[null,null,"LS PP",null,"Days","Hours",null,"Salary Rate",null,null,"Tax Year",null,null,"Social Security",null,"Medicare"]
[null,null,"0123",null,0,0,null,0,null,null,2023,null,null,"Yes",null,"Yes"]
[]
[null,null,null,null,"Vacation",null,null,"Extra",null,null,"Sick *",null,null,"*Applies only to S71 disability approved retirement",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"tier 1 limit",{"$f":"VLOOKUP(K6,AA61:AF78,6)","v":200000}]
[null,null,null,null,"Days","Hours",null,"Days","Hours",null,"Days","Hours",null,"SS Withheld",null,"Med Tax Gross",null,null,null,null,null,null,"Contribution",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"rate",{"$f":"VLOOKUP(K6,AA61:AF78,2)","v":6.2E-2},null,null,"tier 1 rate",{"$f":"VLOOKUP(K6,AA61:AF78,4)","v":1.4500000000000001E-2}]
[null,null,null,null,0,0,null,0,0,null,0,0,null,0,null,0,null,"Buffer",null,"Max Amt.",null,null,"Amount",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"earn max",{"$f":"VLOOKUP(K6,AA61:AF78,3)","v":9932.4},null,null,"tier 2 rate",{"$f":"VLOOKUP(K6,AA61:AF78,5)+Med_T1_Rate","v":2.35E-2}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vacation",null,null,null,null,"Extra",null,null,null,null,"Sick",null,null,null,null,null,null,"Social Security",null,null,null,"Medicare"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"hide","days in pp","hrs left in pp","avail","use","days","hours","pad","avail","use","days","hrs","pad","avail","use","days","hrs","pad","total used","used pay","SS Withheld","SS WH left","max poss","deduct","Med Tax Gross","t1 salary","t1 deduct","t2 salary","t2 deduct","tot deduct","padding","Max","full pp"]
[null,null,{"$f":"C6","v":"0123"},null,{"$f":"IF(AE13=0,\"\",AE13)","v":""},{"$f":"IF(AF13=0,\"\",AF13)","v":""},null,{"$f":"IF(AJ13=0,\"\",AJ13)","v":""},{"$f":"IF(AK13=0,\"\",AK13)","v":""},null,{"$f":"IF(AO13=0,\"\",AO13)","v":""},{"$f":"IF(AP13=0,\"\",AP13)","v":""},null,{"$f":"IF(AW13=0,\"\",AW13)","v":""},null,{"$f":"IF(BC13=0,\"\",BC13)","v":""},null,{"$f":"IF(BD13=0,\"\",BD13)","v":""},null,{"$f":"IF(BE13=0,\"\",ROUNDDOWN(BE13,0))","v":""},null,null,0,null,null,null,{"$f":"getWorkdaysInPayPeriod(LEFT(C6,2),\"20\" & RIGHT(C6,2))","v":22},{"$f":"(8*AA13)-(8*E6+F6)","v":176},{"$f":"E10*8+F10","v":0},{"$f":"IF(AC13>AB13,AB13,AC13)","v":0},{"$f":"ROUNDDOWN(AD13/8,0)","v":0},{"$f":"AD13-(AE13*8)","v":0},null,{"$f":"H10*8+I10","v":0},{"$f":"IF(AD13=0,IF(AH13>AB13,AB13,AH13),0)","v":0},{"$f":"ROUNDDOWN(AI13/8,0)","v":0},{"$f":"AI13-(AJ13*8)","v":0},null,{"$f":"K10*8+L10","v":0},{"$f":"IF(AND(AD13=0,AI13=0),IF(AM13>AB13,AB13,AM13),0)","v":0},{"$f":"ROUNDDOWN(AN13/8,0)","v":0},{"$f":"AN13-(AO13*8)","v":0},null,{"$f":"AD13+AI13+AN13","v":0},{"$f":"($H$6/AA13/8)*AR13","v":0},{"$f":"SS_Withheld","v":0},{"$f":"IF($AU$10-AT13<0,0,$AU$10-AT13)","v":9932.4},{"$f":"AS13*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV13>AU13,AU13,AV13),0)","v":0},{"$f":"AS13+Med_Tax_Gross","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX13<=Med_T1_Limit,AS13,IF((Med_T1_Limit-Med_Tax_Gross)>0,(Med_T1_Limit-Med_Tax_Gross),0)),AS13)","v":0},{"$f":"AY13*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS13-AY13,0)","v":0},{"$f":"BA13*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ13+BB13,0)","v":0},{"$f":"IF(AND(AR13>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(Full_PP_Used,50,100),0)","v":0},{"$f":"IF(AS13-AW13-BC13-BD13<0,0,AS13-AW13-BC13-BD13)","v":0},{"$f":"IF((AR13/8)=AA13,TRUE,FALSE)","v":false}]
[null,null,{"$f":"IF(AB13=AR13,getNext_PayPeriod(C13),C13)","v":"0123"},null,{"$f":"IF(AE14=0,\"\",AE14)","v":""},{"$f":"IF(AF14=0,\"\",AF14)","v":""},null,{"$f":"IF(AJ14=0,\"\",AJ14)","v":""},"",null,{"$f":"IF(AO14=0,\"\",AO14)","v":""},{"$f":"IF(AP14=0,\"\",AP14)","v":""},null,{"$f":"IF(AW14=0,\"\",AW14)","v":""},null,{"$f":"IF(BC14=0,\"\",BC14)","v":""},null,{"$f":"IF(BD14=0,\"\",BD14)","v":""},null,"",null,null,0,null,null,{"$f":"IF(T14=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C14=\"\",0,getWorkdaysInPayPeriod(LEFT(C14,2),\"20\" & RIGHT(C14,2)))","v":22},{"$f":"IF(C14=C13,AB13-AR13,AA14*8)","v":176},{"$f":"AC13-AD13","v":0},0,0,0,{"$f":"IF(AND(AC14=AD14,AD14>0),50,0)","v":0},{"$f":"AH13-AI13","v":0},{"$f":"IF(AD14=0,IF(AH14>AB14,AB14,AH14),0)","v":0},0,0,{"$f":"IF(AND(AH14=AI14,AI14>0),50,0)","v":0},{"$f":"AM13-AN13","v":0},{"$f":"IF(AND(AD14=0,AI14=0),IF(AM14>AB14,AB14,AM14),0)","v":0},0,0,{"$f":"IF(AND(AM14=AN14,AN14>0),50,0)","v":0},0,{"$f":"IF(AR14=0,0,($H$6/AA14/8)*AR14)","v":0},{"$f":"AT13+AW13","v":0},9932.4,0,0,{"$f":"IF(AS14>0,AS14+AX13,0)","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX14<=Med_T1_Limit,AS14,IF((Med_T1_Limit-AX13)>0,(Med_T1_Limit-AX13),0)),AS14)","v":0},0,0,0,0,{"$f":"IF(AND(AR14>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG14+AL14+AQ14=0,50,AG14+AL14+AQ14),0)","v":0},0]
[null,null,{"$f":"IF(AB14=AR14,getNext_PayPeriod(C14),C14)","v":"0123"},null,"","",null,"","",null,{"$f":"IF(AO15=0,\"\",AO15)","v":""},"",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,{"$f":"IF(C15=C14,AB14-AR14,AA15*8)","v":176},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"IF(AS15>0,AS15+AX14,0)","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,{"$f":"IF(AO16=0,\"\",AO16)","v":""},"",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"IF(AS16>0,AS16+AX15,0)","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"IF(AS17>0,AS17+AX16,0)","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"AS18+AX17","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"AS19+AX18","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"AS20+AX19","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,{"$f":"AS21+AX20","v":0},0,0,0,0,0,0,0]
[null,null,{"$f":"IF(AB21=AR21,getNext_PayPeriod(C21),C21)","v":"0123"},null,{"$f":"IF(AE22=0,\"\",AE22)","v":""},{"$f":"IF(AF22=0,\"\",AF22)","v":""},null,{"$f":"IF(AJ22=0,\"\",AJ22)","v":""},{"$f":"IF(AK22=0,\"\",AK22)","v":""},null,{"$f":"IF(AO22=0,\"\",AO22)","v":""},{"$f":"IF(AP22=0,\"\",AP22)","v":""},null,{"$f":"IF(AW22=0,\"\",AW22)","v":""},null,{"$f":"IF(BC22=0,\"\",BC22)","v":""},null,{"$f":"IF(BD22=0,\"\",BD22)","v":""},null,{"$f":"IF(BE22=0,\"\",ROUNDDOWN(BE22,0))","v":""},null,null,0,null,null,{"$f":"IF(T22=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C22=\"\",0,getWorkdaysInPayPeriod(LEFT(C22,2),\"20\" & RIGHT(C22,2)))","v":22},{"$f":"IF(C22=C21,AB21-AR21,AA22*8)","v":176},{"$f":"AC21-AD21","v":0},{"$f":"IF(AC22>AB22,AB22,AC22)","v":0},{"$f":"ROUNDDOWN(AD22/8,0)","v":0},{"$f":"AD22-(AE22*8)","v":0},{"$f":"IF(AND(AC22=AD22,AD22>0),50,0)","v":0},{"$f":"AH21-AI21","v":0},{"$f":"IF(AD22=0,IF(AH22>AB22,AB22,AH22),0)","v":0},{"$f":"ROUNDDOWN(AI22/8,0)","v":0},{"$f":"AI22-(AJ22*8)","v":0},{"$f":"IF(AND(AH22=AI22,AI22>0),50,0)","v":0},{"$f":"AM21-AN21","v":0},{"$f":"IF(AND(AD22=0,AI22=0),IF(AM22>AB22,AB22,AM22),0)","v":0},{"$f":"ROUNDDOWN(AN22/8,0)","v":0},{"$f":"AN22-(AO22*8)","v":0},{"$f":"IF(AND(AM22=AN22,AN22>0),50,0)","v":0},{"$f":"AD22+AI22+AN22","v":0},{"$f":"IF(AR22=0,0,($H$6/AA22/8)*AR22)","v":0},{"$f":"AT21+AW21","v":0},{"$f":"IF($AU$10-AT22<0,0,$AU$10-AT22)","v":9932.4},{"$f":"AS22*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV22>AU22,AU22,AV22),0)","v":0},{"$f":"AS22+AX21","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX22<=Med_T1_Limit,AS22,IF((Med_T1_Limit-AX21)>0,(Med_T1_Limit-AX21),0)),AS22)","v":0},{"$f":"AY22*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS22-AY22,0)","v":0},{"$f":"BA22*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ22+BB22,0)","v":0},{"$f":"IF(AND(AR22>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG22+AL22+AQ22=0,50,AG22+AL22+AQ22),0)","v":0},{"$f":"IF(AS22-AW22-BC22-BD22<0,0,AS22-AW22-BC22-BD22)","v":0}]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,{"$f":"IF(AB37=AR37,getNext_PayPeriod(C37),C37)","v":"0123"},null,{"$f":"IF(AE38=0,\"\",AE38)","v":""},"",null,{"$f":"IF(AJ38=0,\"\",AJ38)","v":""},"",null,{"$f":"IF(AO38=0,\"\",AO38)","v":""},"",null,{"$f":"IF(AW38=0,\"\",AW38)","v":""},null,{"$f":"IF(BC38=0,\"\",BC38)","v":""},null,{"$f":"IF(BD38=0,\"\",BD38)","v":""},null,{"$f":"IF(BE38=0,\"\",ROUNDDOWN(BE38,0))","v":""},null,null,0,null,null,{"$f":"IF(T38=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C38=\"\",0,getWorkdaysInPayPeriod(LEFT(C38,2),\"20\" & RIGHT(C38,2)))","v":22},{"$f":"IF(C38=C37,AB37-AR37,AA38*8)","v":176},{"$f":"AC37-AD37","v":0},{"$f":"IF(AC38>AB38,AB38,AC38)","v":0},{"$f":"ROUNDDOWN(AD38/8,0)","v":0},{"$f":"AD38-(AE38*8)","v":0},{"$f":"IF(AND(AC38=AD38,AD38>0),50,0)","v":0},{"$f":"AH37-AI37","v":0},{"$f":"IF(AD38=0,IF(AH38>AB38,AB38,AH38),0)","v":0},{"$f":"ROUNDDOWN(AI38/8,0)","v":0},{"$f":"AI38-(AJ38*8)","v":0},{"$f":"IF(AND(AH38=AI38,AI38>0),50,0)","v":0},{"$f":"AM37-AN37","v":0},{"$f":"IF(AND(AD38=0,AI38=0),IF(AM38>AB38,AB38,AM38),0)","v":0},{"$f":"ROUNDDOWN(AN38/8,0)","v":0},{"$f":"AN38-(AO38*8)","v":0},{"$f":"IF(AND(AM38=AN38,AN38>0),50,0)","v":0},{"$f":"AD38+AI38+AN38","v":0},{"$f":"IF(AR38=0,0,($H$6/AA38/8)*AR38)","v":0},{"$f":"AT37+AW37","v":0},{"$f":"IF($AU$10-AT38<0,0,$AU$10-AT38)","v":9932.4},{"$f":"AS38*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV38>AU38,AU38,AV38),0)","v":0},{"$f":"AS38+AX37","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX38<=Med_T1_Limit,AS38,IF((Med_T1_Limit-AX37)>0,(Med_T1_Limit-AX37),0)),AS38)","v":0},{"$f":"AY38*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS38-AY38,0)","v":0},{"$f":"BA38*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ38+BB38,0)","v":0},{"$f":"IF(AND(AR38>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG38+AL38+AQ38=0,50,AG38+AL38+AQ38),0)","v":0},{"$f":"IF(AS38-AW38-BC38-BD38<0,0,AS38-AW38-BC38-BD38)","v":0}]
[null,null,{"$f":"IF(AB38=AR38,getNext_PayPeriod(C38),C38)","v":"0123"},null,"","",null,"","",null,"","",null,{"$f":"IF(AW39=0,\"\",AW39)","v":""},null,{"$f":"IF(BC39=0,\"\",BC39)","v":""},null,{"$f":"IF(BD39=0,\"\",BD39)","v":""},null,{"$f":"IF(BE39=0,\"\",ROUNDDOWN(BE39,0))","v":""},null,null,0,null,null,{"$f":"IF(T39=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C39=\"\",0,getWorkdaysInPayPeriod(LEFT(C39,2),\"20\" & RIGHT(C39,2)))","v":22},{"$f":"IF(C39=C38,AB38-AR38,AA39*8)","v":176},{"$f":"AC38-AD38","v":0},{"$f":"IF(AC39>AB39,AB39,AC39)","v":0},0,{"$f":"AD39-(AE39*8)","v":0},{"$f":"IF(AND(AC39=AD39,AD39>0),50,0)","v":0},{"$f":"AH38-AI38","v":0},{"$f":"IF(AD39=0,IF(AH39>AB39,AB39,AH39),0)","v":0},0,{"$f":"AI39-(AJ39*8)","v":0},{"$f":"IF(AND(AH39=AI39,AI39>0),50,0)","v":0},{"$f":"AM38-AN38","v":0},{"$f":"IF(AND(AD39=0,AI39=0),IF(AM39>AB39,AB39,AM39),0)","v":0},0,{"$f":"AN39-(AO39*8)","v":0},{"$f":"IF(AND(AM39=AN39,AN39>0),50,0)","v":0},{"$f":"AD39+AI39+AN39","v":0},{"$f":"IF(AR39=0,0,($H$6/AA39/8)*AR39)","v":0},{"$f":"AT38+AW38","v":0},{"$f":"IF($AU$10-AT39<0,0,$AU$10-AT39)","v":9932.4},{"$f":"AS39*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV39>AU39,AU39,AV39),0)","v":0},{"$f":"AS39+AX38","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX39<=Med_T1_Limit,AS39,IF((Med_T1_Limit-AX38)>0,(Med_T1_Limit-AX38),0)),AS39)","v":0},{"$f":"AY39*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS39-AY39,0)","v":0},{"$f":"BA39*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ39+BB39,0)","v":0},{"$f":"IF(AND(AR39>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG39+AL39+AQ39=0,50,AG39+AL39+AQ39),0)","v":0},{"$f":"IF(AS39-AW39-BC39-BD39<0,0,AS39-AW39-BC39-BD39)","v":0}]
[null,null,{"$f":"IF(AB39=AR39,getNext_PayPeriod(C39),C39)","v":"0123"},null,"","",null,"","",null,"","",null,{"$f":"IF(AW40=0,\"\",AW40)","v":""},null,{"$f":"IF(BC40=0,\"\",BC40)","v":""},null,{"$f":"IF(BD40=0,\"\",BD40)","v":""},null,{"$f":"IF(BE40=0,\"\",ROUNDDOWN(BE40,0))","v":""},null,null,0,null,null,{"$f":"IF(T40=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C40=\"\",0,getWorkdaysInPayPeriod(LEFT(C40,2),\"20\" & RIGHT(C40,2)))","v":22},{"$f":"IF(C40=C39,AB39-AR39,AA40*8)","v":176},{"$f":"AC39-AD39","v":0},{"$f":"IF(AC40>AB40,AB40,AC40)","v":0},0,{"$f":"AD40-(AE40*8)","v":0},{"$f":"IF(AND(AC40=AD40,AD40>0),50,0)","v":0},{"$f":"AH39-AI39","v":0},{"$f":"IF(AD40=0,IF(AH40>AB40,AB40,AH40),0)","v":0},0,{"$f":"AI40-(AJ40*8)","v":0},{"$f":"IF(AND(AH40=AI40,AI40>0),50,0)","v":0},{"$f":"AM39-AN39","v":0},{"$f":"IF(AND(AD40=0,AI40=0),IF(AM40>AB40,AB40,AM40),0)","v":0},0,{"$f":"AN40-(AO40*8)","v":0},{"$f":"IF(AND(AM40=AN40,AN40>0),50,0)","v":0},{"$f":"AD40+AI40+AN40","v":0},{"$f":"IF(AR40=0,0,($H$6/AA40/8)*AR40)","v":0},{"$f":"AT39+AW39","v":0},{"$f":"IF($AU$10-AT40<0,0,$AU$10-AT40)","v":9932.4},{"$f":"AS40*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV40>AU40,AU40,AV40),0)","v":0},{"$f":"AS40+AX39","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX40<=Med_T1_Limit,AS40,IF((Med_T1_Limit-AX39)>0,(Med_T1_Limit-AX39),0)),AS40)","v":0},{"$f":"AY40*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS40-AY40,0)","v":0},{"$f":"BA40*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ40+BB40,0)","v":0},{"$f":"IF(AND(AR40>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG40+AL40+AQ40=0,50,AG40+AL40+AQ40),0)","v":0},{"$f":"IF(AS40-AW40-BC40-BD40<0,0,AS40-AW40-BC40-BD40)","v":0}]
[null,null,{"$f":"IF(AB40=AR40,getNext_PayPeriod(C40),C40)","v":"0123"},null,"","",null,"","",null,"","",null,{"$f":"IF(AW41=0,\"\",AW41)","v":""},null,{"$f":"IF(BC41=0,\"\",BC41)","v":""},null,{"$f":"IF(BD41=0,\"\",BD41)","v":""},null,{"$f":"IF(BE41=0,\"\",ROUNDDOWN(BE41,0))","v":""},null,null,0,null,null,{"$f":"IF(T41=\"\",TRUE,FALSE)","v":true},{"$f":"IF(C41=\"\",0,getWorkdaysInPayPeriod(LEFT(C41,2),\"20\" & RIGHT(C41,2)))","v":22},{"$f":"IF(C41=C40,AB40-AR40,AA41*8)","v":176},{"$f":"AC40-AD40","v":0},{"$f":"IF(AC41>AB41,AB41,AC41)","v":0},0,{"$f":"AD41-(AE41*8)","v":0},{"$f":"IF(AND(AC41=AD41,AD41>0),50,0)","v":0},{"$f":"AH40-AI40","v":0},{"$f":"IF(AD41=0,IF(AH41>AB41,AB41,AH41),0)","v":0},0,{"$f":"AI41-(AJ41*8)","v":0},{"$f":"IF(AND(AH41=AI41,AI41>0),50,0)","v":0},{"$f":"AM40-AN40","v":0},{"$f":"IF(AND(AD41=0,AI41=0),IF(AM41>AB41,AB41,AM41),0)","v":0},0,{"$f":"AN41-(AO41*8)","v":0},{"$f":"IF(AND(AM41=AN41,AN41>0),50,0)","v":0},{"$f":"AD41+AI41+AN41","v":0},{"$f":"IF(AR41=0,0,($H$6/AA41/8)*AR41)","v":0},{"$f":"AT40+AW40","v":0},{"$f":"IF($AU$10-AT41<0,0,$AU$10-AT41)","v":9932.4},{"$f":"AS41*SS_Rate","v":0},{"$f":"IF(SS=\"Yes\",IF(AV41>AU41,AU41,AV41),0)","v":0},{"$f":"AS41+AX40","v":0},{"$f":"IF(Med_T1_Limit>0,IF(AX41<=Med_T1_Limit,AS41,IF((Med_T1_Limit-AX40)>0,(Med_T1_Limit-AX40),0)),AS41)","v":0},{"$f":"AY41*Med_T1_Rate","v":0},{"$f":"IF(Med_T1_Limit>0,AS41-AY41,0)","v":0},{"$f":"BA41*Med_T2_Rate","v":0},{"$f":"IF(Medicare = \"Yes\",AZ41+BB41,0)","v":0},{"$f":"IF(AND(AR41>0,OR(SS=\"Yes\",Medicare=\"Yes\")),IF(AG41+AL41+AQ41=0,50,AG41+AL41+AQ41),0)","v":0},{"$f":"IF(AS41-AW41-BC41-BD41<0,0,AS41-AW41-BC41-BD41)","v":0}]
[null,null,"0123",null,{"$f":"IF(AE42=0,\"\",AE42)","v":""},"",null,"","",null,{"$f":"IF(AO42=0,\"\",AO42)","v":""},"",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,{"$f":"AC41-AD41","v":0},{"$f":"IF(AC42>AB42,AB42,AC42)","v":0},0,{"$f":"AD42-(AE42*8)","v":0},{"$f":"IF(AND(AC42=AD42,AD42>0),50,0)","v":0},{"$f":"AH41-AI41","v":0},0,0,{"$f":"AI42-(AJ42*8)","v":0},{"$f":"IF(AND(AH42=AI42,AI42>0),50,0)","v":0},{"$f":"AM41-AN41","v":0},0,0,{"$f":"AN42-(AO42*8)","v":0},{"$f":"IF(AND(AM42=AN42,AN42>0),50,0)","v":0},0,0,{"$f":"AT41+AW41","v":0},9932.4,0,0,{"$f":"AS42+AX41","v":0},0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[null,null,"0123",null,"","",null,"","",null,"","",null,"",null,"",null,"",null,"",null,null,0,null,null,true,22,176,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,9932.4,0,0,0,0,0,0,0,0,0,0]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Total:",null,{"$f":"SUM(T13:T53)","v":0},null,null,{"$f":"SUM(W13:W53)","v":0}]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"PPM: Section H 256 (rev 10/14)",null,"PPM: Section H 275 (rev 10/14)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Social Security",null,"Medicare",null,null,null,"ss/med"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Employee","Earnings","Employee","Additional",null,null,"Yes"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Rate","Maximum","Rate","Rate","Over",null,"No"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2007,6.2E-2,6045,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2008,6.2E-2,6324,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2009,6.2E-2,6621.6,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2010,6.2E-2,6621.6,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2011,4.2000000000000003E-2,4485.6000000000004,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2012,4.2000000000000003E-2,4624.2,1.4500000000000001E-2]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2013,6.2E-2,7049.4,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2014,6.2E-2,7254,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2015,6.2E-2,7347,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2016,6.2E-2,7347,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2017,6.2E-2,7886.4,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2018,6.2E-2,7960.8,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2019,6.2E-2,8239.7999999999993,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2020,6.2E-2,8537.4,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2021,6.2E-2,8853.6,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2022,6.2E-2,9114,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2023,6.2E-2,9932.4,1.4500000000000001E-2,8.9999999999999993E-3,200000]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,2024,6.2E-2,10453.200000000001,1.4500000000000001E-2,8.9999999999999993E-3,200000]