{"text_format":"1","workbook":"xlsx","n_sheets":26,"sheets":["Welcome","EarningsStub","Pay&DP","EmpType","W4Info","FedWHold","ORWHold","DedctnStub","FTCore","PTCore","LocalTax","FixedAcct","EDUQ","EDUTDEF","Optional","Optional Cont","Summarymath","Disclaimer","FullSummary","BriefSummary","FedStateCalc","LaterFedCalc","FIT2019Pr","ORSITBefore","ORSITAfter","InsNames"],"not_rendered":{"charts":0,"images":76,"macros":1,"external_links":1,"defined_names":95,"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":"Welcome","index":0,"n_rows":20,"n_cols":4,"rows_kept":20,"cut":false,"hidden":false,"merged":[[0,0,0,12],[2,1,8,9]]}
["Welcome State of Oregon Employees"]
[]
[null,"This calculator has been built to give State of Oregon employees an estimation of how your net pay will change with the transition to Workday Payroll for Domestic Partner Taxable Benefits to become subject to PERS withholding and contributions for OPSRP Members. You're welcome to use this calculator to see the change in your PERS contribution rate, or, alternatively, see an breakdown estimation of your paystub and how your net pay will change."]
[]
[]
[]
[]
[]
[]
[null,"Brief Summary of PERS Subject Income Change"]
[null,null,"Required information to continue:"]
[null,null,null,"Most recent paystub from ePayroll"]
[]
[]
[]
[null,"Detailed Summary of Full Paystub"]
[null,null,"Required information to continue:"]
[null,null,null,"Most recent paystub from ePayroll"]
[null,null,null,"Most recent Federal W-4 submitted"]
[null,null,null,"Most recent Oregon W-4 submitted"]

{"sheet":"EarningsStub","index":1,"n_rows":31,"n_cols":2,"rows_kept":31,"cut":false,"hidden":true,"merged":[[0,0,0,12],[2,1,4,11],[6,1,6,11],[30,1,30,10]]}
["ePayroll Paystub Required (Earnings)"]
[]
[null,"On the following page, you will be required to have your ePayroll Paystub available to provide information. This will be located on the left side of your paystub."]
[]
[]
[]
[null,"The image below will be the location in which we're asking you to find the information:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have this information available, please click the \"Next --->\" button to go to the entry page."]

{"sheet":"Pay&DP","index":2,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[16,3,17,4],[0,0,0,11],[2,1,3,9],[5,1,6,8],[8,6,8,8],[14,3,15,4]]}
["Gross Wages & Domestic Partner Taxable Income"]
[]
[null,"All of the entries on this page will be found directly on the Earnings (left) side of your paystub. Please refer to the \"Description\" and \"Amount\" Columns."]
[]
[]
[null,"If you have any of the following coding on your paystub, please enter the applicable amounts from the \"Amount\" Column:"]
[]
[]
[null,"Description Column",null,"Explanation of code",null,null,"Amount Column"]
[]
[null,"GROSS PAY",null,"(Total Wages Earned on the check)",null,null,"$",null,"* Required"]
[]
[]
[]
[null,"DOM PARTNER",null,"(Taxable portion of Domestic Partner's PEBB Benefits)"]
[null,"DP TAX BENEF",null,null,null,null,"$",null,"* Required"]
[]
[null,"DP SURCHG"]
[null,"DP SCHG BENEF",null,"(Domestic Partner Insurance Surcharge)",null,null,"$",null,"* Required"]
[]
[null,"DP NTAX ADJ",null,"(Domestic Partner Adjustment Entry)",null,null,"$",null,"* Required"]
[]
[]
[null,"HEM INCENT",null,"(Heath Engagement Model Payment (HEM)",null,null,"$",null,"* Required"]

{"sheet":"EmpType","index":3,"n_rows":3,"n_cols":1,"rows_kept":3,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,0,3,11]]}
["            Type of Employment"]
[]
["            Are you a Full-Time, or Part-time employee?"]

{"sheet":"W4Info","index":4,"n_rows":34,"n_cols":9,"rows_kept":34,"cut":false,"hidden":true,"merged":[[0,0,0,13],[2,1,3,13],[5,1,6,13],[33,1,33,13]]}
["Withholding Information (Workday)"]
[]
[null,"On the following two pages, you will be required to have your Federal & State W-4 Withholding Information available to input information. "]
[]
[]
[null,"The image below will be the within your Workday Profile Page / Pay Tab / Tax Elections location in which we're asking you to find the information as highlighted in yellow. The Blue highlight is for W-4s prior to 2020."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Instructions for Updating your Withholding in Workday found here: ",null,null,null,null,null,null,"Workday Withholding Update Instructions"]
[]
[]
[null,"Once you have this information available, please click the \"Next ---->\" button to go to the entry page."]

{"sheet":"FedWHold","index":5,"n_rows":41,"n_cols":10,"rows_kept":41,"cut":false,"hidden":true,"merged":[[26,1,26,7],[0,0,0,9],[2,1,3,9],[5,1,6,8],[12,1,13,9],[15,1,15,9]]}
["Federal Tax Withholding"]
[]
[null,"Using the information directly from the Tax Elections section of your profile in Workday, or your most recent submitted W-4s, please fill out the information below to get the most accurate estimate of your taxes."]
[]
[]
[null,"For Federal withholding, was the most recent effective date of your last W-4 prior to January of 2020, or January of 2020 or later?"]
[]
[]
[]
[]
[]
[]
[null,"Please fill out the following information as listed on your W-4. If left blank, this will process with Single and 0 allowances, or the equivalent for post-2020 Federal Withholding."]
[]
[]
[null,"Prior to January 2020 Withholding W-4"]
[]
[null,null,"Federal Marital Status",null,null,null,null,null,"*"]
[]
[null,null,"Number of Allowances",null,null,null,null,"  *"]
[]
[null,null,"Additional Withholding Amount",null,null,null,null,"  *"]
[]
[]
[]
[]
[null,"January 2020 or Later Withholding W-4"]
[]
[null,null,"Federal Marital Status",null,null,null,null,null,null,"*"]
[]
[null,null,"Box 2 (Multiple Jobs or Spouse Works)",null,null,null,null,"   *"]
[]
[null,null,"Box 3 (Total Dependent Amount)",null,null,null,null,"  *"]
[]
[null,null,"Box 4a (Other Income)",null,null,null,null,"  *"]
[]
[null,null,"Box 4b (Deductions)",null,null,null,null,"  *"]
[]
[null,null,"Box 4c (Extra Withholding)",null,null,null,null,"  *"]
[]
[null,null,"Did you claim Exempt?",null,null,null,null,"  *"]

{"sheet":"ORWHold","index":6,"n_rows":15,"n_cols":10,"rows_kept":15,"cut":false,"hidden":true,"merged":[[0,0,0,9],[2,1,3,9],[5,1,6,9]]}
["Oregon Tax Withholding"]
[]
[null,"Using the information directly from the Tax Elections section of your profile in Workday, or your most recent submitted W-4s, please fill out the following information to get the most accurate estimate of your taxes."]
[]
[]
[null,"Please fill out the following information as listed on your W-4. If left blank, this will process with Single and 0 allowances."]
[]
[]
[null,null,"Oregon Marital Status",null,null,null,null,null,null,"  *"]
[]
[null,null,"Number of Allowances",null,null,null,null,"  *"]
[]
[null,null,"Additional Amount",null,null,null,null,"  *"]
[]
[null,null,"Did you claim Exempt? ",null,null,null,null,"  *"]

{"sheet":"DedctnStub","index":7,"n_rows":32,"n_cols":2,"rows_kept":32,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,1,3,9],[6,1,7,9],[31,1,31,9]]}
["ePayroll Paystub Required (Deductions)"]
[]
[null,"On the following page, you will be required to have your ePayroll Paystub available to provide information. This will be located on the right side of your paystub."]
[]
[]
[]
[null,"The image below shows the location in which you will find the requested information as highlighted in yellow. Please do not include the amounts in red at the bottom:"]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"Once you have this information available, please click the \"Next ---->\" button below."]

{"sheet":"FTCore","index":8,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":true,"merged":[[42,1,43,1],[42,3,43,4],[29,0,29,5],[30,1,31,6],[30,7,31,9],[36,0,36,8],[38,1,39,9],[41,6,41,9],[15,0,15,5],[16,1,17,6],[16,7,17,9],[22,0,22,5],[23,1,24,6],[23,7,24,9],[0,0,0,8],[2,1,2,9],[4,1,5,3],[8,0,8,5],[9,1,10,6],[9,7,10,9]]}
["Full-Time Core Benefits through PEBB"]
[]
[null,"This page will walk through which benefits you have listed on your paystub that may be a \"pre-tax\" deduction."]
[]
[null,"Did you enroll for Medical, Dental, Vision and/or Basic Life insurance benefits?"]
[]
[]
[]
["Medical Insurance"]
[null,"Please select the Medical Insurance as it would appear in the \"Vendor\" Column of your paystub:",null,null,null,null,null,"Amount found in \"Current\":"]
[]
[]
[null,"Medical Insurances",null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Dental Insurance"]
[null,"Please select the Dental Insurance as it would appear in the \"Vendor\" Column of your paystub:",null,null,null,null,null,"Amount found in \"Current\":"]
[]
[]
[null,"Dental Insurances",null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Vision Insurance"]
[null,"Please select the Vision Insurance as it would appear in the \"Vendor\" Column of your paystub:",null,null,null,null,null,"Amount found in \"Current\":"]
[]
[]
[null,"Vision Insurances",null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Basic Life Insurance"]
[null,"Please select the Life Insurance as it would appear in the \"Vendor\" Column of your paystub:",null,null,null,null,null,"Amount found in \"Current\":"]
[]
[]
[null,"Basic Life Insurances",null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Misc Insurance Surcharges"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of code",null,null,"CURRENT COLUMN"]
[null,"DBL COV SC  ",null,"(If a spouse, domestic partner or a dependent child is enrolled in a medical plan (except opt out) and is also enrolled in a PEBB medical plan as a subscriber, this new surcharge will apply)"]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,"SPOUSE INS  ",null,"(Spouse/partner declined other ins)",null,null,null,"Amount ","$"]
[]
[null,"TOBACCO SC  ",null,"(Tobacco Surcharge)",null,null,null,"Amount ","$"]

{"sheet":"PTCore","index":9,"n_rows":48,"n_cols":9,"rows_kept":48,"cut":false,"hidden":true,"merged":[[36,0,36,8],[38,1,39,9],[42,1,43,1],[42,3,43,5],[15,0,15,5],[16,1,17,6],[22,0,22,5],[23,1,24,6],[29,0,29,5],[30,1,31,6],[0,0,0,8],[2,1,2,9],[4,1,6,3],[8,0,8,5],[9,1,10,5],[9,7,10,10]]}
["Part-Time Core Benefits through PEBB"]
[]
[null,"This page will walk through which benefits you have listed on your paystub that may be a \"pre-tax\" deduction."]
[]
[null,"Did you enroll for Medical, Dental, Vision and/or Basic Life insurance benefits?"]
[]
[]
[]
["Medical Insurance"]
[null,"Please select the Medical Insurance as it would appear in the \"Vendor\" Column of your paystub:",null,null,null,null,null,"Amount found in \"Current\":"]
[]
[]
[null,"Medical Insurances",null,null,null,null,null,"Amount","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Dental Insurance"]
[null,"Please select the Dental Insurance as it would appear in the \"Vendor\" Column of your paystub:"]
[]
[]
[null,"Dental Insurances",null,null,null,null,null,"Amount","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Vision Insurance"]
[null,"Please select the Vision Insurance as it would appear in the \"Vendor\" Column of your paystub:"]
[]
[]
[null,"Vision Insurances",null,null,null,null,null,"Amount","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Basic Life Insurance"]
[null,"Please select the Life Insurance as it would appear in the \"Vendor\" Column of your paystub:"]
[]
[]
[null,"Basic Life Insurances",null,null,null,null,null,"Amount","$"]
[]
[null,null,null,null,null,null,null," Hit [Enter] or [Tab] to move to the next box"]
["Misc Insurance Surcharges"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of code",null,null,null,"CURRENT COLUMN"]
[null,"DBL COV SC  ",null,"(If a spouse, domestic partner or a dependent child is enrolled in a medical plan (except opt out) and is also enrolled in a PEBB medical plan as a subscriber, this new surcharge will apply)"]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,"SPOUSE INS  ",null,"(Spouse/partner declined other ins)",null,null,null,"Amount ","$"]
[]
[null,"TOBACCO SC  ",null,"(Tobacco Surcharge)",null,null,null,"Amount ","$"]

{"sheet":"LocalTax","index":10,"n_rows":16,"n_cols":9,"rows_kept":16,"cut":false,"hidden":true,"merged":[[15,3,15,4],[0,0,0,11],[2,0,2,11],[4,0,4,8],[6,1,7,9],[11,3,11,4],[13,3,13,4]]}
["Local Taxes"]
[]
["All entries on this page are optional. The more information you can provide, the more accurate the summary of your net pay will be."]
[]
["Local Tax Deductions"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of code",null,null,null,"CURRENT COLUMN"]
[]
[null,"EUG TAX",null,"(Eugene Community Safety Payroll Tax)",null,null,null,"Amount ","$"]
[]
[null,"MULT TAX",null,"(Multnomah Co Preschool For All Personal Income Tax)",null,null,null,"Amount ","$"]
[]
[null,"PORT METRO",null,"(Metro Supportive Housing Svcs Personal Income Tax)",null,null,null,"Amount ","$"]

{"sheet":"FixedAcct","index":11,"n_rows":27,"n_cols":10,"rows_kept":27,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,1,3,9],[5,7,5,9]]}
["Fixed Accounts for Direct Deposit"]
[]
[null,"This will walk you through the different Fixed accounts you may have elected to deposit portions of your paycheck if it applies. This portion is optional."]
[]
[]
[null,"VENDOR COLUMN",null,"DESCRIPTION COLUMN",null,null,null,"CURRENT COLUMN"]
[]
[null,"DIRECT DEP",null,"FIXED 1",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"FIXED 2",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"FIXED 3",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"FIXED 4",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"FIXED 5",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"FIXED 6",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"OSP FIT CNTR",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"SOB WELLFUND",null,null,null,"Amount ","$"]
[]
[null,"DIRECT DEP",null,"CIR JUDG ASN",null,null,null,"Amount ","$"]
[]
[]
[null,null,null,"Subtotal of all Fixed Deposits",null,null,null,null,null,{"$f":"SUM(J8:J24)","v":0}]

{"sheet":"EDUQ","index":12,"n_rows":4,"n_cols":2,"rows_kept":4,"cut":false,"hidden":true,"merged":[[0,0,0,9],[3,1,5,6]]}
["Dept of Education"]
[]
[]
[null,"Are you an employee of the Dept of Education?"]

{"sheet":"EDUTDEF","index":13,"n_rows":24,"n_cols":9,"rows_kept":24,"cut":false,"hidden":true,"merged":[[0,0,0,11],[2,1,3,10],[7,1,7,10],[9,7,9,9]]}
["Dept of Education"]
[]
[null,"As an employee of the Dept of Education, fill in the appropriate information for Tax Deferred Accounts you may have opted into."]
[]
[]
["Dept of Education specific Tax Deferred Accounts"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"AMER CEN INV",null,"American Century Investors",null,null,null,"Amount ","$"]
[]
[null,"VOYA",null,"ING Life Insurance ",null,null,null,"Amount ","$"]
[]
[null,"AXA EQUIT",null,"AXA Equitable ",null,null,null,"Amount ","$"]
[]
[null,"VALIC/TDA",null,"VALIC/TDA",null,null,null,"Amount ","$"]
[]
[null,"IVY FUNDS",null,"Waddell & Reed, Inc ",null,null,null,"Amount ","$"]
[]
[null,"PENSERV",null,"Forestors Financial Services",null,null,null,"Amount ","$"]
[]
[null,"INVESCO",null,"Oppenheimer Fund",null,null,null,"Amount ","$"]

{"sheet":"Optional","index":14,"n_rows":92,"n_cols":9,"rows_kept":92,"cut":false,"hidden":true,"merged":[[73,1,74,9],[84,1,85,9],[32,0,32,9],[34,1,35,9],[46,0,46,9],[48,1,49,9],[58,0,58,9],[60,1,61,9],[22,1,23,9],[0,0,0,9],[2,1,2,9],[4,0,4,8],[6,1,7,9],[20,0,20,8]]}
["Optional Insurances through PEBB / Third Party Providers"]
[]
[null,"All entries on this page are optional. The more information you can provide, the more accurate the summary of your net pay will be."]
[]
["Flexible Spending Accounts (FSA)"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of code",null,null,null,"CURRENT COLUMN"]
[]
[null,"FSA/HLTHCARE",null,"(Healthcare FSA)",null,null,null,"Amount ","$"]
[]
[null,"COMM/TRANS",null,"(Commuter Account – Transportation FSA)",null,null,null,"Amount ","$"]
[]
[null,"FSA/DEP CARE",null,"(Dependent Care FSA)",null,null,null,"Amount ","$"]
[]
[null,"COMM/PKING",null,"(Commuter Account – Parking FSA)",null,null,null,"Amount ","$"]
[]
[]
["Pre-Tax Parking Deductions (State Parking)"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of code",null,null,null,"CURRENT COLUMN"]
[]
[null,"PARK PRETAX",null,"(Parking (pre-tax))",null,null,null,"Amount ","$"]
[]
[null,"OYA PARKING",null,"(OYA Parking (pre-tax))",null,null,null,"Amount ","$"]
[]
[]
["Oregon Savings Growth Plan Accounts (OSGP/VOYA)"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"DEF/COMP",null,"(Traditional 457 Deferred Compensation)",null,null,null,"Amount ","$"]
[]
[null,"ROTH 457 ",null,"(Roth 457 IRA)",null,null,null,"Amount ","$"]
[]
[null,"DEF/COMPLOAN",null,"(Deferred Comp Loan Program)",null,null,null,"Amount ","$"]
[]
[]
["The Standard Short & Long Term Disability"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"SHORTERM DIS",null,"(Short-term disability, 60%)",null,null,null,"Amount ","$"]
[]
[null,"LONGTERM DIS",null,"(Long-Term disability, one of four options)",null,null,null,"Amount ","$"]
[]
[]
["UNUM Long-Term Care Insurance (LTC)"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"UN LTC-EMP",null,"(UNUM Long Term Care Employee)",null,null,null,"Amount ","$"]
[]
[null,"UN LTC-SP/DP",null,"(UNUM Long Term Care Spouse/Dep)",null,null,null,"Amount ","$"]
[]
[]
[]
["Dependent Life Insurance"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"DEP LIFE",null,"(Life, optional, dependent)",null,null,null,"Amount ","$"]
[]
[]
[]
["Accidental Death and Dismemberment (AD&D)"]
[]
[null,"If you have any of the following coding in the Vendor Columns of your paystub, please enter the applicable amounts from the \"Current\" Column:"]
[]
[]
[null,"VENDOR COLUMN",null,"Explanation of Code",null,null,null,"CURRENT COLUMN"]
[]
[null,"EMP AD&D    ",null,"(AD&D, employee only)",null,null,null,"Amount ","$"]
[]
[null,"EMP/DEP AD&D",null,"(AD&D, employee & dependent(s))",null,null,null,"Amount ","$"]

{"sheet":"Optional Cont","index":15,"n_rows":61,"n_cols":10,"rows_kept":61,"cut":false,"hidden":true,"merged":[[60,4,60,7],[0,0,0,11],[2,1,2,9],[4,0,4,8],[6,1,7,9],[17,1,17,5],[26,1,26,5],[29,0,29,8],[31,1,34,9],[35,1,35,9]]}
["Continued Optional Insurances through PEBB / Third Party Providers"]
[]
[null,"This page will walk through the remaining optional benefits or deductions you have listed on your paystub."]
[]
["Optional Life Insurances"]
[]
[null,"If you selected an optional insurance amount that was greater than $40k, you will have two versions of your Optional Life Insurance."]
[]
[]
[]
["Employee Only Optional Life Insurance"]
[]
["Please find the Vendor Column that shows as \"040K PRETAX\" in the Description Column:"]
[]
[null,null,null,null,null,"\"040K PRETAX\"",null,"Amount ","$"]
[]
[]
[null,"If there is a second amount that says \"POSTTAX\" in the Description Column, enter the amount here:",null,null,null,null,null,"Amount ","$"]
[]
["Spousal/Domestic Partner Optional Insurance"]
[]
["Please find the Vendor Column that shows as \"040K PRETAX\" in the Description Column:"]
[]
[null,null,null,null,null,"\"040K PRETAX\"",null,"Amount ","$"]
[]
[]
[null,"If there is a second amount that says \"POSTTAX\" in the Description Column, enter the amount here:",null,null,null,null,null,"Amount ","$"]
[]
[]
["All Misc Other Deductions including Garnishments & Union Dues (Post-tax)"]
[]
[null,"You may have other deductions that appear in the Vendor Column that have amounts in the Current Column. You can use this section to enter the amounts so that the sum of them will show on the estimated summary of your paycheck. This does include union dues."]
[]
[]
[]
[null,"**Do not include the amount listed for \"EMPLOYE PAID\" in this section.**"]
[]
[null,"VENDOR COLUMN ",null,"(these are optional and for your reference)",null,null,null,"CURRENT COLUMN"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[null,null,null,null,null,null,null,"Amount ","$"]
[]
[]
[null,null,null,null,"Subtotal of Misc Deductions",null,null,null,null,{"$f":"SUM(J40,J42,J44,J46,J48,J50,J52,J54,J56,J58)","v":0}]

{"sheet":"Summarymath","index":16,"n_rows":106,"n_cols":23,"rows_kept":106,"cut":false,"hidden":true,"merged":[[103,0,103,2],[30,1,30,2],[35,1,35,2],[40,1,40,2],[48,1,48,3],[48,7,48,8],[62,1,62,2],[0,1,1,9],[3,1,3,5],[13,7,13,8],[15,1,15,5],[16,1,16,2],[24,1,24,2]]}
[null,"Math Breakdown",null,null,null,null,null,null,null,null,null,null,"Brief?","Detailed?"]
[]
[]
[null,"Income"]
[]
[null,null,"Gross Wages",null,{"$f":"'Pay&DP'!$H$11","v":0}]
[]
[null,null,null,"Hem",{"$f":"'Pay&DP'!$H$24","v":0}]
[]
[null,null,null,"DPT",{"$f":"'Pay&DP'!$H$16","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Employment Type?",null,null,null,{"$f":"InsNames!S9","v":"Full-Time"}]
[null,null,null,"DPS",{"$f":"'Pay&DP'!$H$19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"EE enrollment?"]
[null,null,null,"DPN",{"$f":"'Pay&DP'!$H$21","v":0}]
[]
[null,null,"PERS Subject Income",null,"Before Change",null,{"$f":"IF(SUM(E6-E8)<0,0,SUM(E6-E8))","v":0},"After Change",null,{"$f":"IF(E8 < 0, SUM(E6,0,E10:E12),SUM(E6,-E8,E10:E12))","v":0}]
[]
[null,"Pre-FICA Deductions",null,null,null,null,null,null,null,null,null,"DropDown Value","Lookup Type"]
[null,"Core Benefits",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"FTCORE","Type","PTCORE","Type","Paid"]
[null,null,"Medical",{"$f":"W18","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Medical",{"$f":"FTCore!J13","v":0},null,{"$f":"PTCore!J13","v":0},null,{"$f":"IF($W$10=\"Full-Time\",S18,U18)","v":0}]
[null,null,"Dental",{"$f":"W19","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Dental",{"$f":"FTCore!J20","v":0},null,{"$f":"PTCore!J20","v":0},null,{"$f":"IF($W$10=\"Full-Time\",S19,U19)","v":0}]
[null,null,"Basic Life",{"$f":"W20","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Basic Life",{"$f":"FTCore!J34","v":0},null,{"$f":"PTCore!J34","v":0},null,0]
[null,null,"Vision",{"$f":"W21","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,"Vision",{"$f":"FTCore!J27","v":0},null,{"$f":"PTCore!J27","v":0},null,0]
[]
[null,"Optional EE","40K",{"$f":"'Optional Cont'!J15","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Spousal","SGSC",{"$f":"FTCore!J44","v":0},null,{"$f":"PTCore!J44","v":0},null,{"$f":"IF($W$10=\"Full-Time\",S23,U23)","v":0}]
[null,"Optional Sp/DP","40K",{"$f":"'Optional Cont'!J24","v":0},null,null,null,null,null,null,null,null,null,null,null,null,"Tobacco","TBSC",{"$f":"FTCore!J48","v":0},null,{"$f":"PTCore!J46","v":0},null,{"$f":"IF($W$10=\"Full-Time\",S24,U24)","v":0}]
[null,"FSA Accounts",null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Double Cov","DBSC",{"$f":"FTCore!J46","v":0},null,{"$f":"PTCore!J48","v":0},null,0]
[null,null,"FHNN",{"$f":"Optional!J12","v":0}]
[null,null,"FTNN",{"$f":"Optional!J14","v":0}]
[null,null,"FDNN",{"$f":"Optional!J16","v":0}]
[null,null,"FKNN",{"$f":"Optional!J18","v":0}]
[]
[null,"Surcharges"]
[null,"Spousal","SGSC",{"$f":"W23","v":0}]
[null,"Tobacco","TBSC",{"$f":"W24","v":0}]
[null,"Double Cov","DBSC",{"$f":"W25","v":0}]
[]
[null,"Pre-Tax Parking"]
[null,null,"Pre-Tax Park",{"$f":"Optional!J28","v":0}]
[null,null,"OYA Park",{"$f":"Optional!J30","v":0}]
[]
[]
[null,"Agency 581 Tax Deferred Annuities"]
[null,null,"ZBNN",{"$f":"EDUTDEF!J12","v":0}]
[null,null,"ZCNN",{"$f":"EDUTDEF!J14","v":0}]
[null,null,"ZGNN",{"$f":"EDUTDEF!J16","v":0}]
[null,null,"ZJNN",{"$f":"EDUTDEF!J18","v":0}]
[null,null,"ZRNN",{"$f":"EDUTDEF!J20","v":0}]
[null,null,"ZZNN",{"$f":"EDUTDEF!J22","v":0}]
[null,null,"Z2NN",{"$f":"EDUTDEF!J24","v":0}]
[null,"Total Pre-FICA Deductions",null,null,"Before Change",null,{"$f":"SUM(D18:D48)","v":0},"After Change",null,{"$f":"SUM(D18:D48)","v":0}]
[]
[null,"DPT/DPS/DPN Add-On",null,null,null,null,{"$f":"SUM(E10:E12)","v":0}]
[null,"Hem Add-On",null,null,null,null,{"$f":"E8","v":0},null,null,{"$f":"E8","v":0}]
[null,"FICA Subject Income",null,null,"Before Change",null,{"$f":"G14-G49+G51+G52","v":0},"After Change",null,{"$f":"J14-J49","v":0}]
[]
[null,null,"Before",null,null,null,null,"After"]
[null,null,"Social Security Taxes",null,{"$f":"G53*0.062","v":0},null,null,"Social Security Taxes",null,{"$f":"J53*0.062","v":0}]
[null,null,"Medicare Taxes",null,{"$f":"G53*0.0145","v":0},null,null,"Medicare Taxes",null,{"$f":"J53*0.0145","v":0}]
[]
[null,"Post-FICA/Pre-FIT/SIT/OTT Deductions"]
[null,null,null,null,"Before",null,null,null,"After"]
[null,"PERS Contributions",null,null,{"$f":"G14*0.06","v":0},null,null,null,{"$f":"J14*0.06","v":0}]
[]
[null,"OSGP"]
[null,"Def Comp","DCNN",null,{"$f":"Optional!J40","v":0}]
[]
[null,"Total Pre-Fit Deductions",null,null,{"$f":"SUM(E61:E64)","v":0},null,null,null,{"$f":"I61+E64","v":0}]
[]
[null,"Total FIT/SIT/OTT Subject Income",null,null,null,{"$f":"G53-E66","v":0},null,null,null,{"$f":"J53-I66","v":0}]
[]
[null,null,"FIT Taxes",null,{"$f":"IFERROR(ROUND(IF(C71=TRUE,FIT2019Pr!D17,FedStateCalc!E8),2),\"\")","v":""},null,null,null,{"$f":"IFERROR(ROUND(IF(C71=TRUE,FIT2019Pr!F17,FedStateCalc!K10),2),\"\")","v":""}]
[null,"Prior?",false]
[null,null,"SIT Taxes",null,{"$f":"IFERROR(ORSITBefore!G9,\"\")","v":""},null,null,null,{"$f":"IFERROR(ORSITAfter!G9,\"\")","v":""}]
[]
[null,null,"OTT Taxes",null,{"$f":"F68*0.001","v":0},null,null,null,{"$f":"J68*0.001","v":0}]
[]
[]
[]
[]
[null,"AANN","Eugene Tax",{"$f":"LocalTax!J12","v":0}]
[null,"AAN1","Metro Tax",{"$f":"LocalTax!J16","v":0}]
[null,"AAN2","Mult Co Tax",{"$f":"LocalTax!J14","v":0}]
[]
[]
[null,"Post-Tax Deductions"]
[]
[null,"OSGP"]
[null,"Roth","RTNN",{"$f":"Optional!J42","v":0}]
[null,"Loan/Def","LONN",{"$f":"Optional!J44","v":0}]
[]
[null,"Optional Insurances"]
[null,"LTC","LBNN",{"$f":"Optional!J68","v":0}]
[null,"LTC","LCNN",{"$f":"Optional!J66","v":0}]
[null,"STD","STNN",{"$f":"Optional!J54","v":0}]
[null,"LTD","AG/AH/AJ/AK",{"$f":"Optional!J56","v":0}]
[null,"Dep Life","LTNN",{"$f":"Optional!J79","v":0}]
[null,"AD&D","ADNN",{"$f":"Optional!J92","v":0}]
[null,"AD&D","AENN",{"$f":"Optional!J90","v":0}]
[]
[null,"Optional Life Post","EE",{"$f":"'Optional Cont'!J18","v":0}]
[null,"Optional Life Post","SP/DP",{"$f":"'Optional Cont'!J27","v":0}]
[]
[null,"Total'd Misc Deductions",null,{"$f":"'Optional Cont'!J61","v":0}]
[]
["Fixed Deposits"]
[]
[null,"Fixed Deposit Total",null,{"$f":"FixedAcct!J27","v":0}]

{"sheet":"Disclaimer","index":17,"n_rows":8,"n_cols":2,"rows_kept":8,"cut":false,"hidden":true,"merged":[[0,0,0,9],[2,1,5,9],[7,1,11,9]]}
["Disclaimer"]
[]
[null,"****This calculator is intended to only provide an estimation of change for PERS Subject Income and PERS Contributions with the transition into Workday Payroll from OSPA regarding Domestic Partner Taxable Benefits, Domestic Partner Taxable Surcharges, and Domestic Partner Taxable Adjustments. This is only applicable for State of Oregon employees affected by the policy change for PERS Oregon Public Service Retirement Plan (OPSRP)."]
[]
[]
[]
[]
[null,"Use of this calculator is not a guarantee and is an estimation, at best, of how your PERS Subject Income, PERS Contributions, Taxable Income, Taxes, or Pay Deductions will appear on future paychecks due to potential discrepancies in math or rounding errors, variations in how programs calculate these amounts, or alternative interpretations in tax law, bargaining agreement language, and the meanings on the Paystub from ePayroll themselves.****"]

{"sheet":"FullSummary","index":18,"n_rows":74,"n_cols":11,"rows_kept":74,"cut":false,"hidden":true,"merged":[[73,0,75,10],[29,1,29,2],[29,7,29,8],[37,1,37,2],[37,7,37,8],[38,1,38,2],[38,7,38,8],[39,0,40,4],[39,6,40,10],[43,0,43,2],[43,6,43,8],[71,0,72,10],[8,0,8,2],[8,6,8,8],[0,0,0,10],[3,0,3,4],[3,6,3,10],[4,0,4,4],[4,6,4,10]]}
["Detailed Summary of Changes"]
[]
[]
["Current with OSPA Program",null,null,null,null,null,"After Transition to Workday Payroll"]
["PERS SUBJECT/TAXABLE INCOME BREAKDOWN",null,null,null,null,null,"PERS SUBJECT/TAXABLE INCOME BREAKDOWN"]
["Gross Wages (less HEM)",null,null,null,{"$f":"Summarymath!G14","v":0},null,"Gross Wages (less HEM)",null,null,null,{"$f":"Summarymath!G14","v":0}]
[null,null,null,null,null,null,"Total Domestic Partner Taxable Benefits ",null,null,null,{"$f":"SUM(Summarymath!E10:E12)","v":0}]
[]
["PERS Subject Wages",null,null,null,{"$f":"E6","v":0},null,"PERS Subject Wages",null,null,null,{"$f":"SUM(K6:K7)","v":0}]
[]
["    Pre-Social Security & Medicare Tax Deductions",null,null,null,null,null,"    Pre-Social Security & Medicare Tax Deductions"]
[null,"Core Medical",null,{"$f":"Summarymath!D18","v":0},null,null,null,"Core Medical",null,{"$f":"D12","v":0}]
[null,"Core Dent",null,{"$f":"Summarymath!D19","v":0},null,null,null,"Core Dent",null,0]
[null,"Core Vision",null,{"$f":"Summarymath!D21","v":0},null,null,null,"Core Vision",null,0]
[null,"Core Basic Life",null,{"$f":"Summarymath!D20","v":0},null,null,null,"Core Basic Life",null,0]
[null,"Optional Pre-tax Life",null,{"$f":"SUM(Summarymath!D23:D24)","v":0},null,null,null,"Optional Pre-tax Life",null,0]
[null,"Optional Health Care FSA",null,{"$f":"Summarymath!D26","v":0},null,null,null,"Optional Health Care FSA",null,0]
[null,"Optional Dependent Care FSA",null,{"$f":"Summarymath!D28","v":0},null,null,null,"Optional Dependent Care FSA",null,0]
[null,"Optional Commuter Transportation FSA",null,{"$f":"Summarymath!D27","v":0},null,null,null,"Optional Commuter Transportation FSA",null,0]
[null,"Optional Commuter Parking FSA",null,{"$f":"Summarymath!D29","v":0},null,null,null,"Optional Commuter Parking FSA",null,0]
[null,"Misc Spousal Ins Surcharge",null,{"$f":"Summarymath!D32","v":0},null,null,null,"Misc Spousal Ins Surcharge",null,0]
[null,"Misc Tobacco Surcharge",null,{"$f":"Summarymath!D33","v":0},null,null,null,"Misc Tobacco Surcharge",null,0]
[null,"Misc Double Coverage Surcharge",null,{"$f":"Summarymath!D34","v":0},null,null,null,"Misc Double Coverage Surcharge",null,0]
[null,"Pre-Tax Parking Payment",null,{"$f":"SUM(Summarymath!D37:D38)","v":0},null,null,null,"Pre-Tax Parking Payment",null,0]
[]
[null,"Total Pre-SS & Medicare Deductions",null,null,{"$f":"-SUM(D12:D25)","v":0},null,null,"Total Pre-SS & Medicare Deductions",null,null,{"$f":"-SUM(J12:J25)","v":0}]
[]
[null,"Total Domestic Partner Taxable Benefits",null,null,{"$f":"Summarymath!G51","v":0}]
[null,"HEM Payment",null,null,{"$f":"Summarymath!G52","v":0},null,null,"HEM Payment",null,null,{"$f":"Summarymath!G52","v":0}]
[null,"Social Security & Medicare Subject Wages",null,null,{"$f":"SUM(E9:E29)","v":0},null,null,"Social Security & Medicare Subject Wages",null,null,{"$f":"SUM($K$9,$K$26,$K$29)","v":0}]
[]
["    Pre-Federal & Oregon Tax Deductions",null,null,null,null,null,"    Pre-Federal & Oregon Tax Deductions"]
[null,"PERS Contributions",null,{"$f":"$E$9*0.06","v":0},null,null,null,"PERS Contributions",null,{"$f":"$K$9*0.06","v":0}]
[null,"OSGP Def Comp Contributions",null,{"$f":"Summarymath!E64","v":0},null,null,null,"OSGP Def Comp Contributions",null,{"$f":"Summarymath!E64","v":0}]
[]
[null,"Total Pre-FIT/SIT Tax Deductions",null,null,{"$f":"-SUM(D33:D34)","v":0},null,null,"Total Pre-FIT/SIT Tax Deductions",null,null,{"$f":"-SUM(J33:J34)","v":0}]
[]
[null,"Total Federal Income Tax Subject Income",null,null,{"$f":"SUM(E30:E36)","v":0},null,null,"Total Federal Income Tax Subject Income",null,null,{"$f":"SUM($K$30,$K$36)","v":0}]
[null,"Total State Income Tax Subject Income",null,null,{"$f":"E38","v":0},null,null,"Total State Income Tax Subject Income",null,null,{"$f":"K38","v":0}]
["PAYCHECK BREAKDOWN",null,null,null,null,null,"PAYCHECK BREAKDOWN"]
[]
["    Pay",null,null,null,null,null,"     Pay"]
[null,"Gross Pay",null,{"$f":"Summarymath!E6","v":0},null,null,null,"Gross Pay",null,{"$f":"D43","v":0}]
["    Taxes",null,null,null,null,null,"     Taxes"]
[null,"Federal Income Taxes *",null,{"$f":"Summarymath!E70","v":""},null,null,null,"Federal Income Taxes *",null,{"$f":"Summarymath!I70","v":""}]
[null,"Oregon Income Taxes*",null,{"$f":"Summarymath!E72","v":""},null,null,null,"Oregon Income Taxes*",null,{"$f":"Summarymath!I72","v":""}]
[null,"Oregon Transportation Tax*",null,{"$f":"Summarymath!E74","v":0},null,null,null,"Oregon Transportation Tax*",null,{"$f":"Summarymath!I74","v":0}]
[null,"Social Security Taxes*",null,{"$f":"E30*0.062","v":0},null,null,null,"Social Security Taxes",null,{"$f":"K30*0.062","v":0}]
[null,"Medicare Taxes*",null,{"$f":"E30*0.0145","v":0},null,null,null,"Medicare Taxes",null,{"$f":"K30*0.0145","v":0}]
[null,"Local Eugene City Tax",null,{"$f":"Summarymath!D79","v":0},null,null,null,"Local Eugene City Tax",null,{"$f":"Summarymath!D79","v":0}]
[null,"Local Mult Co Taxes",null,{"$f":"Summarymath!D81","v":0},null,null,null,"Local Mult Co Taxes",null,{"$f":"Summarymath!D81","v":0}]
[null,"Local Portland Metro Taxes",null,{"$f":"Summarymath!D80","v":0},null,null,null,"Local Portland Metro Taxes",null,{"$f":"Summarymath!D80","v":0}]
[]
["    PERS Contributions",null,null,{"$f":"Summarymath!E61","v":0},null,null,"    PERS Contributions",null,null,{"$f":"Summarymath!I61","v":0}]
[]
["    Deductions",null,null,null,null,null,"    Deductions"]
[null,"Core Insurances",null,{"$f":"SUM(D12:D15,D21:D23)","v":0},null,null,null,"Core Insurances",null,{"$f":"SUM(J12:J15)","v":0}]
[null,"Optional Insurances",null,{"$f":"SUM(D16,Summarymath!D87:D100)","v":0},null,null,null,"Optional Insurances",null,{"$f":"D58","v":0}]
[null,"FSA Contributions",null,{"$f":"SUM(D17:D20)","v":0},null,null,null,"FSA Contributions",null,{"$f":"SUM(J17:J20)","v":0}]
[null,"Parking",null,{"$f":"SUM(D24)","v":0},null,null,null,"Parking",null,{"$f":"D60","v":0}]
[null,"Misc Deductions Post-Tax (as listed on tab)",null,{"$f":"Summarymath!D102","v":0},null,null,null,"Misc Deductions (as listed on tab)",null,{"$f":"D61","v":0}]
[null,"OSGP Contributions/Payments",null,{"$f":"SUM(Summarymath!E64,Summarymath!D87:D88)","v":0},null,null,null,"OSGP Contributions/Payments",null,{"$f":"FullSummary!D62","v":0}]
[]
[null,"Total Pay",null,{"$f":"D43-SUM(D45:D62)","v":0},null,null,null,"Total Pay",null,{"$f":"J43-SUM(J45:J62)","v":0}]
[]
[null,"    Fixed Deposit Acct totals",null,{"$f":"Summarymath!D106","v":0},null,null,null,"     Fixed Deposit Acct totals",null,{"$f":"D66","v":0}]
[]
[null,"Net Check/Deposit Amount **",null,{"$f":"D64-D66","v":0},null,null,null,"Net Check/Deposit Amount **",null,{"$f":"J64-J66","v":0}]
[]
[]
[]
["*These taxes will not be exact due to the minor differences in rounding with the calculation within this document and how it varies to the Oregon State Payroll System. These taxes are a close estimation and not a guarantee of rate with your next paycheck. "]
[]
["**This is subject to change based on salary change, change in hours, added misc payouts of accrued time. This is not a guaranteed amount and is ONLY an estimation based on the information provided, and only applicable to members of PERS' OPSRP. This estimate does not include WBF tax due to it's calculation with the amount of hours worked."]

{"sheet":"BriefSummary","index":19,"n_rows":36,"n_cols":6,"rows_kept":36,"cut":false,"hidden":true,"merged":[[0,0,0,6],[19,0,19,4],[35,0,40,6]]}
["Brief Summary of Changes"]
[]
[]
["Current under OSPS Program:"]
[]
[null,"Current PERS Subject Income:",null,null,null,{"$f":"Summarymath!G14","v":0}]
[]
[null,"Current amount of PERS Contributions:",null,null,null,{"$f":"Summarymath!E61","v":0}]
[]
[]
[]
[{"$f":"\"After Transition to Workday Payroll:\"","v":"After Transition to Workday Payroll:"}]
[]
[null,"New PERS Subject Income:",null,null,null,{"$f":"Summarymath!J14","v":0}]
[]
[null,"New amount of PERS Contributions:",null,null,null,{"$f":"Summarymath!I61","v":0}]
[]
[]
[]
["Change Summary"]
[]
[null,"Total Increase in PERS Subject Income per monthly paycheck:",null,null,null,{"$f":"F14-F6","v":0}]
[]
[null,"Total Increase in PERS Contributions per monthly paycheck",null,null,null,{"$f":"F16-F8","v":0}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
["*This is subject to change based on salary change, change in hours, added misc payouts of accrued time. This is not a guaranteed amount and is ONLY an estimation based on the information provided, and only applicable to members of PERS' OPSRP."]

{"sheet":"FedStateCalc","index":20,"n_rows":36,"n_cols":23,"rows_kept":36,"cut":false,"hidden":true,"merged":[[26,13,26,16],[32,13,32,16],[32,20,32,23],[11,1,11,5],[12,13,12,18],[13,7,13,11],[14,18,14,24],[20,13,20,16],[20,18,20,25],[4,15,4,16],[4,17,4,18],[5,13,5,16],[6,13,6,16],[7,1,8,3],[7,4,8,5],[8,13,9,16],[8,17,9,18],[9,7,10,9],[9,10,10,11],[0,1,1,10],[0,13,1,21],[2,1,2,10],[2,13,2,21],[3,13,3,14],[3,15,3,16],[3,17,3,18]]}
[null,"Federal Income Tax Withholding Calculation (Approximation) 2020 W-4 or Later",null,null,null,null,null,null,null,null,null,null,null,"SIT Income Tax withholding Approximation"]
[]
[null,"Instructions: Only enter information in the yellow boxes/drop downs. It will calculate the withholding based on the IRS Publication 15-T (https://www.irs.gov/pub/irs-pdf/p15t.pdf). You will decide which method is used, Wage Bracket or Percentage method, based on the type of withholding your agency does. This calculates monthly pay only. ",null,null,null,null,null,null,null,null,null,null,null,"Instructions: Only enter information in the yellow boxes/drop downs. It will calculate the withholding based on the Oregon Publication 150-206-436 for 2022 OR Tax formulas for taxable wages greater than $4250 (https://www.oregon.gov/dor/programs/businesses/Documents/2022%20formulas.pdf)"]
[null,"Wages for the month (run 1 & 2)","Status (drop down list)","Box 2","Box 3","Box 4a","Box 4b","Box 4c","Yes","Single/Married filing Separate (S)",1,null,null,"Oregon Withholding Filing Status (Drop down list)",null,"Number of Allowances",null,"Additional Withholding"]
["Before",{"$f":"Summarymath!F68","v":0},"","",{"$f":"FedWHold!G33","v":0},{"$f":"FedWHold!G35","v":0},{"$f":"FedWHold!G37","v":0},{"$f":"FedWHold!G39","v":0},"No","Married Filing Jointly, or Qualifying Widow (J)",2,null,null,"Single / Married but withhold at higher Single Rate (S)",null,{"$f":"ORWHold!G11","v":0},null,0,null,null,1,"Married (J)",1]
["After",{"$f":"Summarymath!$J$68","v":0},null,false,null,null,null,null,null,"Head of Household (H)",3,null,null,"OR taxable Wages",null,null,null,null,null,null,2,"Single / Married but withhold at higher Single Rate (S)",2]
[null,null,"Before",null,null,null,null,null,null,"Exempt (N)",4,null,null,"FIT for PPE",null,null,null,257.47000000000003]
[null,"Percentage Method Tables",null,null,{"$f":"IF(C34<0,0,C34)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,false]
[null,null,null,null,null,null,null,null,"After",null,null,null,null,"Oregon Calculated Withholding",null,null,null,{"$f":"R33","v":0}]
[null,null,null,null,null,null,null,"Percentage Method Tables",null,null,{"$f":"IF(I36<0,0,I36)","v":{"$error":"#N/A"}}]
[]
[null,"Percentage Method Tables (p15T p51)"]
[null,"1a",{"$f":"$B5","v":0},null,null,null,null,null,null,null,null,null,null,"Worksheet"]
[null,"1b",12,null,null,null,null,"Percentage Method Tables (p15T p51)",null,null,null,null,null,"Monthly",null,null,null,{"$f":"R6","v":0}]
[null,"1c",{"$f":"$F$5","v":0},null,null,null,null,"1a",{"$f":"B6","v":0},null,null,null,null,"Annualized",null,null,null,{"$f":"R14*12","v":0}]
[null,"1d",{"$f":"C15/C14","v":0},null,null,null,null,"1b",12]
[null,"1e",{"$f":"C13+C16","v":0},null,null,null,null,"1c",{"$f":"L7","v":0},null,null,null,null,"Monthly FIT",null,null,null,{"$f":"R7","v":257.47000000000003}]
[null,"1f",{"$f":"$G$5","v":0},null,null,null,null,"1d",{"$f":"I17/I16","v":0},null,null,null,null,"Annualized FIT",null,null,"-",{"$f":"R17*12","v":3089.6400000000003}]
[null,"1g",{"$f":"C18/C14","v":0},null,null,null,null,"1e",{"$f":"I15+I18","v":0},null,null,null,null,"Phase-out Restrictions",null,null,"-"]
[null,"1h",{"$f":"C17-C19","v":0},"Adjusted Wage",null,null,null,"1f",{"$f":"G5","v":0},null,null,null,null,"less standard deduction",null,null,"-"]
[null,null,null,null,null,null,null,"1g",{"$f":"I20/I16","v":0},null,null,null,null,"BASE",null,null,null,{"$f":"R15-R19-R20","v":0}]
[null,"2a",{"$f":"LaterFedCalc!X18","v":{"$error":"#N/A"}},null,null,null,null,"1h",{"$f":"I19-I21","v":0},"Adjusted Wage"]
[null,"2b",{"$f":"LaterFedCalc!X26","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,"Threshold wages"]
[null,"2c",{"$f":"LaterFedCalc!X34","v":{"$error":"#N/A"}},null,null,null,null,"2a",{"$f":"LaterFedCalc!O51","v":{"$error":"#N/A"}},null,null,null,null,"Amount of BASE over threshold"]
[null,"2d",{"$f":"C20-C22","v":{"$error":"#N/A"}},null,null,null,null,"2b",{"$f":"LaterFedCalc!O59","v":{"$error":"#N/A"}},null,null,null,null,"Tax on BASE"]
[null,"2e",{"$f":"C24*C25","v":{"$error":"#N/A"}},null,null,null,null,"2c",{"$f":"LaterFedCalc!O67","v":{"$error":"#N/A"}},null,null,null,null,"Tax on excess over threshold"]
[null,"2f",{"$f":"LaterFedCalc!U14","v":{"$error":"#N/A"}},{"$f":"C26+C23","v":{"$error":"#N/A"}},null,null,null,"2d",{"$f":"I22-I24","v":{"$error":"#N/A"}},null,null,null,null,"Total Annual Tax",null,null,null,{"$f":"R25+R26","v":0}]
[null,null,null,null,null,null,null,"2e",{"$f":"I26*I27","v":{"$error":"#N/A"}}]
[null,"3a",{"$f":"E5","v":0},null,null,null,null,"2f",{"$f":"LaterFedCalc!L47","v":{"$error":"#N/A"}},{"$f":"I28+I25","v":{"$error":"#N/A"}},null,null,null,"Exemption Credit"]
[null,"3b",{"$f":"C29/C14","v":0},null,null,null,null,null,null,null,null,null,null,"less exemption credit less phase out",null,null,null,{"$f":"IF(R15>100000,0,R29)","v":0},null,{"$f":"R29","v":0}]
[null,"3c",{"$f":"C27-C30","v":{"$error":"#N/A"}},null,null,null,null,"3a",{"$f":"E5","v":0},null,null,null,null,"Annual Withholding",null,null,null,{"$f":"R27-R30","v":0},null,{"$f":"R27-T30","v":0}]
[null,null,null,null,null,null,null,"3b",{"$f":"I31/I16","v":0},null,null,null,null,"Additional Monthly Withholding",null,null,null,{"$f":"R5","v":0},null,{"$f":"R32","v":0}]
[null,"4a",{"$f":"H5","v":0},null,null,null,null,"3c",{"$f":"I29-I32","v":{"$error":"#N/A"}},null,null,null,null,"Monthly Withholding w/o",null,null,null,{"$f":"(R31/12)+R32","v":0},null,{"$f":"(T31/12)+T32","v":0},"Monthly withholding W/ Exemption Credit"]
[null,"4b",{"$f":"IF(D6=\"TRUE\",C33,C31+C33)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,"4a",{"$f":"H5","v":0}]
[null,null,null,null,null,null,null,"4b",{"$f":"IF(D6=\"TRUE\",I35,I33+I35)","v":{"$error":"#N/A"}}]

{"sheet":"LaterFedCalc","index":21,"n_rows":71,"n_cols":24,"rows_kept":71,"cut":false,"hidden":true,"merged":[[56,10,56,12],[64,10,64,12],[23,19,23,21],[31,19,31,21],[35,6,35,8],[43,10,43,12],[44,10,44,12],[48,10,48,12],[10,16,10,18],[10,19,10,21],[22,0,22,4],[22,6,22,10],[0,0,0,10],[1,12,1,14],[2,0,2,4],[2,6,2,10],[11,16,11,18],[11,19,11,21],[12,0,12,4],[12,6,12,10],[15,19,15,21]]}
["Monthly pay only",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"After Wages"]
[null,null,null,null,null,null,null,null,null,null,null,null,"Adjusted Wage Amount",null,null,{"$f":"FedStateCalc!C20","v":0},null,{"$f":"FedStateCalc!$B$6","v":0}]
["MFJ - Box 2 \"No\"",null,null,null,null,null,"MFJ - Box 2 \"Yes\"",null,null,null,null,null,"MFJ \"No\"",null,"MFJ \"Yes\"",null,null,null,null,null,"Box 2 Result"]
[0,2158,0,0,0,null,0,1079,0,0,0,null,null,null,null,null,null,null,null,"Filling Status","No","Yes",null,"Result"]
[2158,3871,0,0.1,2158,null,1079,1935,0,0.1,1079,null,{"$f":"LOOKUP($P$2,MFJ_PCT_NO)","v":0},null,{"$f":"LOOKUP($P$2,MFJ_PCT_YES)","v":0},null,null,null,null,"Married Filing Jointly (J)",{"$f":"M9","v":0},{"$f":"O9","v":0}]
[3871,9121,171.3,0.12,3871,null,1935,4560,85.6,0.12,1935,null,{"$f":"LOOKUP($P$2,MFJ_PCT_NO,MFJ_PCT_NO_BASEAMT)","v":0},null,{"$f":"LOOKUP($P$2,MFJ_PCT_YES,MFJ_PCT_YES_BASEAMT)","v":0},null,null,null,null,"Head of Household (H)",{"$f":"M29","v":0},{"$f":"O29","v":0}]
[9121,17004,801.3,0.22,9121,null,4560,8502,400.6,0.22,4560,null,{"$f":"LOOKUP($P$2,MFJ_PCT_NO,MFJ_PCT_NO_TAXPCT)","v":0},null,{"$f":"LOOKUP($P$2,MFJ_PCT_YES,MFJ_PCT_YES_PCTTAX)","v":0},null,null,null,null,"Single/Married filing Separate (S)",{"$f":"M20","v":0},{"$f":"O20","v":0}]
[17004,30500,2535.56,0.24,17004,null,8502,15250,1267.8399999999999,0.24,8502,null,{"$f":"($P$2-M5)","v":0},null,{"$f":"P2-O5","v":0},null,null,null,null,"Exempt (N)","N/A","N/A"]
[30500,38150,5774.6,0.32,30500,null,15250,19075,2887.36,0.32,15250,null,{"$f":"(M8*M7)+M6","v":0},null,{"$f":"(O8*O7)+O6","v":0}]
[38150,56146,8222.6,0.35,38150,null,19075,28073,4111.3599999999997,0.35,19075,null,null,null,null,null,null,null,null,null,null,null,"No","Yes"]
[56146,null,14521.2,0.37,56146,null,28073,null,7260.66,0.37,28073,null,null,null,null,null,"Filling Status on Front",null,null,{"$f":"FedStateCalc!C5","v":""},null,null,{"$f":"VLOOKUP(T11,T5:W7,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(T11, T5:V7,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 Result",null,null,{"$f":"FedStateCalc!$D$5","v":""}]
["Single/MFS \"No\"",null,null,null,null,null,"Single/MFS \"Yes\""]
[0,1079,0,0,0,null,0,540,0,0,0,null,"SMFS \"No\"",null,"SMFS \"Yes\"",null,null,null,null,"Taxes:",{"$f":"HLOOKUP(T12,W10:X11,2,FALSE)","v":{"$error":"#N/A"}}]
[1079,1935,0,0.1,1079,null,540,968,0,0.1,540]
[1935,4560,85.6,0.12,1935,null,968,2280,42.8,0.12,968,null,{"$f":"LOOKUP($P$2,SFMS_PCT_NO)","v":0},null,{"$f":"LOOKUP($P$2,SFMS_PCT_YES)","v":0},null,null,null,null,"Base amount"]
[4560,8502,400.6,0.22,4560,null,2280,4251,200.24,0.22,2280,null,{"$f":"LOOKUP($P$2,SFMS_PCT_NO,SMFS_PCT_NO_BASETAX)","v":0},null,{"$f":"LOOKUP($P$2,SFMS_PCT_YES,SMFS_PCT_YES_BASETAX)","v":0},null,null,null,null,null,"Box 2 Result",null,null,"Result"]
[8502,15250,1267.8399999999999,0.24,8502,null,4251,7625,633.86,0.24,4251,null,{"$f":"LOOKUP($P$2,SFMS_PCT_NO,SMFS_PCT_NO_TAXPCT)","v":0},null,{"$f":"LOOKUP($P$2,SFMS_PCT_YES,SMFS_PCT_YES_TAXPCT)","v":0},null,null,null,null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(T11,T18:V21,MATCH(T12,T18:V18,0),FALSE)","v":{"$error":"#N/A"}}]
[15250,19075,2887.36,0.32,15250,null,7625,9538,1443.62,0.32,7625,null,{"$f":"($P$2-M16)*M18","v":0},null,{"$f":"($P$2-O16)*O18","v":0},null,null,null,null,"Married Filing Jointly (J)",{"$f":"M5","v":0},{"$f":"O5","v":0}]
[19075,46071,4111.3599999999997,0.35,19075,null,9538,23035,2055.7800000000002,0.35,9538,null,{"$f":"M17+M19","v":0},null,{"$f":"(($P$2-O16)*O18)+O17","v":0},null,null,null,null,"Head of Household (H)",{"$f":"M26","v":0},{"$f":"O26","v":0}]
[46071,null,13559.96,0.37,46071,null,23035,null,6779.73,0.37,23035,null,null,null,null,null,null,null,null,"Single/Married filing Separate (S)",{"$f":"M16","v":0},{"$f":"O16","v":0}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exempt (N)","N/A","N/A"]
["HOH \"No\"",null,null,null,null,null,"HOH \"Yes\""]
[0,1617,0,0,0,null,0,808,0,0,0,null,"HOH \"No\"",null,"HOH \"Yes\"",null,null,null,null,"Base Tax"]
[1617,2838,0,0.1,1617,null,808,1419,0,0.1,808,null,null,null,null,null,null,null,null,null,"Box 2 Result",null,null,"Result"]
[2838,6275,122.1,0.12,2838,null,1419,3138,61.1,0.12,1419,null,{"$f":"LOOKUP($P$2,HOH_PCT_NO)","v":0},null,{"$f":"LOOKUP($P$2,HOH_PCT_YES)","v":0},null,null,null,null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(T11,T26:V29,MATCH(T12,T26:V26,0),FALSE)","v":{"$error":"#N/A"}}]
[6275,9038,534.54,0.22,6275,null,3138,4519,267.38,0.22,3138,null,{"$f":"LOOKUP($P$2,HOH_PCT_NO,HOH_PCT_NO_TAXBASE)","v":0},null,{"$f":"LOOKUP($P$2,HOH_PCT_YES,HOH_PCT_YES_BASETAX)","v":0},null,null,null,null,"Married Filing Jointly (J)",{"$f":"M6","v":0},{"$f":"O6","v":0}]
[9038,15788,1142.4000000000001,0.24,9038,null,4519,7894,571.20000000000005,0.24,4519,null,{"$f":"LOOKUP($P$2,HOH_PCT_NO,HOH_PCT_NO_PCTTAX)","v":0},null,{"$f":"LOOKUP($P$2,HOH_PCT_YES,HOH_PCT_YES_TAXPCT)","v":0},null,null,null,null,"Head of Household (H)",{"$f":"M27","v":0},{"$f":"O27","v":0}]
[15788,19613,2762.4,0.32,15788,null,7894,9806,1381.2,0.32,7894,null,{"$f":"(($P$2-M26)*M28)+M27","v":0},null,{"$f":"(($P$2-O26)*O28)+O27","v":0},null,null,null,null,"Single/Married filing Separate (S)",{"$f":"M17","v":0},{"$f":"O17","v":0}]
[19613,46608,3986.4,0.35,19613,null,9806,23304,1993.04,0.35,9806,null,null,null,null,null,null,null,null,"Exempt (N)","N/A","N/A"]
[46608,null,13434.65,0.37,46608,null,23304,null,6717.34,0.37,23304]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Percent Tax"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Box 2 Result",null,null,"Result"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(T11,T34:V37,MATCH(T12,T34:V34,0),FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Married Filing Jointly (J)",{"$f":"M7","v":0},{"$f":"O7","v":0}]
[null,null,null,null,null,null,"Afger",null,null,null,null,"Box 2 Result",null,null,null,null,null,null,null,"Head of Household (H)",{"$f":"M18","v":0},{"$f":"O18","v":0}]
[null,null,null,null,null,null,"MFJ \"No\"",null,"MFJ \"Yes\"",null,"Filling Status","No","Yes",null,"Result",null,null,null,null,"Single/Married filing Separate (S)",{"$f":"M18","v":0},{"$f":"O28","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Married Filing Jointly (J)",{"$f":"G43","v":0},{"$f":"I43","v":0},null,null,null,null,null,null,"Exempt (N)","N/A","N/A"]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,MFJ_PCT_NO)","v":0},null,{"$f":"LOOKUP($R$2,MFJ_PCT_YES)","v":0},null,"Head of Household (H)",{"$f":"G63","v":0},{"$f":"I63","v":0}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,MFJ_PCT_NO,MFJ_PCT_NO_BASEAMT)","v":0},null,{"$f":"LOOKUP($R$2,MFJ_PCT_YES,MFJ_PCT_YES_BASEAMT)","v":0},null,"Single/Married filing Separate (S)",{"$f":"G54","v":0},{"$f":"I54","v":0}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,MFJ_PCT_NO,MFJ_PCT_NO_TAXPCT)","v":0},null,{"$f":"LOOKUP($R$2,MFJ_PCT_YES,MFJ_PCT_YES_PCTTAX)","v":0},null,"Exempt (N)","N/A","N/A"]
[null,null,null,null,null,null,{"$f":"($R$2-G39)","v":0},null,{"$f":"$R$2-I39","v":0}]
[null,null,null,null,null,null,{"$f":"(G42*G41)+G40","v":0},null,{"$f":"(I42*I41)+I40","v":0},null,null,null,null,"No","Yes"]
[null,null,null,null,null,null,null,null,null,null,{"$f":"FedStateCalc!C5","v":""},null,null,{"$f":"VLOOKUP(K44,K38:N40,2,FALSE)","v":{"$error":"#N/A"}},{"$f":"VLOOKUP(K44, K38:M40,3,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,{"$f":"FedStateCalc!$D$5","v":""}]
[]
[null,null,null,null,null,null,null,null,null,null,"Taxes:",{"$f":"HLOOKUP(K45,N43:O44,2,FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,"SMFS \"No\"",null,"SMFS \"Yes\""]
[null,null,null,null,null,null,null,null,null,null,"Base amount"]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,SFMS_PCT_NO)","v":0},null,{"$f":"LOOKUP($R$2,SFMS_PCT_YES)","v":0},null,null,"Box 2 Result",null,null,"Result"]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,SFMS_PCT_NO,SMFS_PCT_NO_BASETAX)","v":0},null,{"$f":"LOOKUP($R$2,SFMS_PCT_YES,SMFS_PCT_YES_BASETAX)","v":0},null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(K44,K51:M54,MATCH(K45,K51:M51,0),FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,SFMS_PCT_NO,SMFS_PCT_NO_TAXPCT)","v":0},null,{"$f":"LOOKUP($R$2,SFMS_PCT_YES,SMFS_PCT_YES_TAXPCT)","v":0},null,"Married Filing Jointly (J)",{"$f":"G39","v":0},{"$f":"I39","v":0}]
[null,null,null,null,null,null,{"$f":"($R$2-G50)*G52","v":0},null,{"$f":"($R$2-I50)*I52","v":0},null,"Head of Household (H)",{"$f":"G60","v":0},{"$f":"I60","v":0}]
[null,null,null,null,null,null,{"$f":"G51+G53","v":0},null,{"$f":"I51+I53","v":0},null,"Single/Married filing Separate (S)",{"$f":"G50","v":0},{"$f":"I50","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Exempt (N)","N/A","N/A"]
[]
[null,null,null,null,null,null,null,null,null,null,"Base Tax"]
[null,null,null,null,null,null,"HOH \"No\"",null,"HOH \"Yes\"",null,null,"Box 2 Result",null,null,"Result"]
[null,null,null,null,null,null,null,null,null,null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(K44,K59:M62,MATCH(K45,K59:M59,0),FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,HOH_PCT_NO)","v":0},null,{"$f":"LOOKUP($R$2,HOH_PCT_YES)","v":0},null,"Married Filing Jointly (J)",{"$f":"G40","v":0},{"$f":"I40","v":0}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,HOH_PCT_NO,HOH_PCT_NO_TAXBASE)","v":0},null,{"$f":"LOOKUP($R$2,HOH_PCT_YES,HOH_PCT_YES_BASETAX)","v":0},null,"Head of Household (H)",{"$f":"G61","v":0},{"$f":"I61","v":0}]
[null,null,null,null,null,null,{"$f":"LOOKUP($R$2,HOH_PCT_NO,HOH_PCT_NO_PCTTAX)","v":0},null,{"$f":"LOOKUP($R$2,HOH_PCT_YES,HOH_PCT_YES_TAXPCT)","v":0},null,"Single/Married filing Separate (S)",{"$f":"G51","v":0},{"$f":"I51","v":0}]
[null,null,null,null,null,null,{"$f":"(($R$2-G60)*G62)+G61","v":0},null,{"$f":"(($R$2-I60)*I62)+I61","v":0},null,"Exempt (N)","N/A","N/A"]
[]
[null,null,null,null,null,null,null,null,null,null,"Percent Tax"]
[null,null,null,null,null,null,null,null,null,null,null,"Box 2 Result",null,null,"Result"]
[null,null,null,null,null,null,null,null,null,null,"Filling Status","No","Yes",null,{"$f":"VLOOKUP(K44,K67:M70,MATCH(K45,K67:M67,0),FALSE)","v":{"$error":"#N/A"}}]
[null,null,null,null,null,null,null,null,null,null,"Married Filing Jointly (J)",{"$f":"G41","v":0},{"$f":"I41","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Head of Household (H)",{"$f":"G62","v":0},{"$f":"I62","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Single/Married filing Separate (S)",{"$f":"G52","v":0},{"$f":"I52","v":0}]
[null,null,null,null,null,null,null,null,null,null,"Exempt (N)","N/A","N/A"]

{"sheet":"FIT2019Pr","index":22,"n_rows":37,"n_cols":24,"rows_kept":37,"cut":false,"hidden":true,"merged":[[29,8,29,9],[21,7,21,9],[21,13,21,14],[21,16,21,17],[22,8,22,9],[22,16,22,17],[23,8,23,9],[24,8,24,9],[25,8,25,9],[26,8,26,9],[27,8,27,9],[28,8,28,9],[1,0,1,5],[19,7,19,11],[19,12,19,13],[19,14,19,18],[20,7,20,12],[20,13,20,16],[20,17,20,18]]}
[]
["Withholding in 2022 with 2019 or earlier withholding elections",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Single/Married filing Separate (S)",1]
[null,"Filing Status",null,{"$f":"VLOOKUP($U$3,$W$2:$X$4,2,FALSE)","v":{"$error":"#N/A"}},null,{"$f":"VLOOKUP($U$3,$W$2:$X$4,2,FALSE)","v":{"$error":"#N/A"}},null,null,null,null,null,null,null,null,null,null,null,null,null,null,"",null,"Married Filing Jointly, or Qualifying Widow (J)",2]
["1a","Enter the employee's total taxable wages this payroll period ",null,{"$f":"Summarymath!F68","v":0},null,{"$f":"Summarymath!$J$68","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Exempt (N)",3]
["1b","Enter the number of allowances claimed on the employee's most recent Form W-4",null,{"$f":"FedWHold!$G$20","v":0},null,{"$f":"FedWHold!$G$20","v":0}]
["1c","Multiply line 1b by the amount in Table 7 for your pay frequency ",null,{"$f":"$D$5*358","v":0},null,{"$f":"F5*358","v":0}]
["1d","Subtract line 1c from line 1a. If zero or less, enter -0-. This is the Adjusted Wage Amount ",null,{"$f":"D4-D6","v":0},null,{"$f":"F4-F6","v":0}]
[]
["2a","Find the row in the Percentage Method table in this section in which the amount on line 1d is at least the amount in column A but less than the amount in column B, and then enter here the amount from column A of that row",null,{"$f":"IF($D$3=3,0,IF($D$3=1,B30,IF($D$3=2,B24,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(F3=3,0,IF($D$3=1,D30,IF($D$3=2,D24,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}}]
["2b","Enter the amount from column C of that row",null,{"$f":"IF(E3=\"Exempt\",0,IF($D$3=1,B31,IF($D$3=2,B25,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(F3=3,0,IF($D$3=1,D31,IF($D$3=2,D25,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}}]
["2c","Enter the percentage from column D of that row",null,{"$f":"IF(D3=3,0,IF($D$3=1,B32,IF($D$3=2,B26,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}},null,{"$f":"IF(F3=3,0,IF($D$3=1,D32,IF($D$3=2,D26,IF($D$3=3,0,\"\"))))","v":{"$error":"#N/A"}}]
["2d","Subtract line 2a from line 1d",null,{"$f":"D7-D9","v":{"$error":"#N/A"}},null,{"$f":"F7-F9","v":{"$error":"#N/A"}}]
["2e","Multiply the amount on line 2d by the percentage on line 2c",null,{"$f":"D12*D11","v":{"$error":"#N/A"}},null,{"$f":"F12*F11","v":{"$error":"#N/A"}}]
["2f","Add lines 2b and 2e. This is the Tentative Withholding Amount ",null,{"$f":"D10+D13","v":{"$error":"#N/A"}},null,{"$f":"F10+F13","v":{"$error":"#N/A"}}]
[]
["3a","Enter the additional amount to withhold from line 6 of the employee's Form W-4 ",null,{"$f":"FedWHold!$G$22","v":0},null,{"$f":"FedWHold!$G$22","v":0}]
["3b","Add lines 2f and 3a. This is the amount to withhold from the employee's wages this pay period",null,{"$f":"SUM(D14,D16)","v":{"$error":"#N/A"}},null,{"$f":"SUM(F14,F16)","v":{"$error":"#N/A"}}]
[]
[]
[null,null,null,null,null,null,null,null,null,null,null,null,"MONTHLY Payroll Period"]
[null,null,null,null,null,null,null,"MARRIED",null,null,null,null,null,"SINGLE Persons"]
[null,null,null,null,null,null,null,"If the Adjusted Wage\n  Amount (line 1d) is              \nat least…        But less\nthan…",null,null,"The tentative amount to withhold is…","Plus this percentage\n…","amount that the wage exceeds…","Amount (lin ed Wage\ne 1d) is           \nat least…     But less\nthan…",null,"The tentative amount to withhold is…","Plus this percentage\n…",null,"of the amount that the wage exceeds…"]
[null,"Married",null,"Married",null,null,null,"A","B",null,"C","D","E","A","B","C","D",null,"E"]
["2a",{"$f":"LOOKUP(D$7,$H$24:$H$31)","v":0},null,{"$f":"LOOKUP(F$7,$H$24:$H$31)","v":0},null,null,null,0,1083,null,0,0,0,0,363,0,0,null,0]
["2b",{"$f":"LOOKUP(D$7,$H$24:$H$31,$K$24:$K$31)","v":0},null,{"$f":"LOOKUP(F$7,$H$24:$H$31,$K$24:$K$31)","v":0},null,null,null,1083,2796,null,0,0.1,1083,363,1219,0,0.1,null,363]
["2c",{"$f":"LOOKUP(D$7,$H$24:$H$31,$L$24:$L$31)","v":0},null,{"$f":"LOOKUP(F$7,$H$24:$H$31,$L$24:$L$31)","v":0},null,null,null,2796,8046,null,171.3,0.12,2796,1219,3844,85.6,0.12,null,1219]
[null,null,null,null,null,null,null,8046,15929,null,801.3,0.22,8046,3844,7785,400.6,0.22,null,3844]
[null,null,null,null,null,null,null,15929,29425,null,2535.56,0.24,15929,7785,14533,1267.6199999999999,0.24,null,7785]
[null,"Single",null,"Single",null,null,null,29425,37075,null,5774.6,0.32,29425,14533,18358,2887.14,0.32,null,14533]
["2a",{"$f":"LOOKUP(D$7,$N$24:$N$31)","v":0},null,{"$f":"LOOKUP(F$7,$N$24:$N$31)","v":0},null,null,null,37075,55071,null,8222.6,0.35,37075,18358,45354,4111.1400000000003,0.35,null,18358]
["2b",{"$f":"LOOKUP(D$7,$N$24:$N$31,$P$24:$P$31)","v":0},null,{"$f":"LOOKUP(F$7,$N$24:$N$31,$P$24:$P$31)","v":0},null,null,null,55071,null,null,14521.2,0.37,55071,45354,null,13559.74,0.37,null,45354]
["2c",{"$f":"LOOKUP(D$7,$N$24:$N$31,$Q$24:$Q$31)","v":0},null,{"$f":"LOOKUP(F$7,$N$24:$N$31,$Q$24:$Q$31)","v":0}]
[]
[null,"Exempt",null,"Exempt"]
["2a",0,null,0]
["2b",0,null,0]
["2c",0,null,0]

{"sheet":"ORSITBefore","index":23,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":true,"merged":[[9,0,9,3],[13,0,13,3],[16,0,16,2],[28,1,28,5],[28,12,28,16]]}
["Before"]
[]
["Month's total SIT subject wages",null,null,{"$f":"Summarymath!F68","v":0},null,null,null,null,null,null,null,null,null,"Married (J)"]
["Allowances",null,null,{"$f":"ORWHold!G11","v":0},null,null,null,null,null,null,null,null,null,"Single / Married but withhold at higher Single Rate (S)"]
["Filing Status",null,null,{"$f":"FedStateCalc!N5","v":"Single / Married but withhold at higher Single Rate (S)"},null,null,null,null,null,null,null,null,null,"Exempt (N)"]
["Federal Withholding Amount",null,null,{"$f":"Summarymath!E70","v":""}]
["Additional Withholding",null,null,{"$f":"ORWHold!G13","v":0},null,null,null,null,null,null,null,null,null,{"$f":"FedStateCalc!V8","v":false}]
[]
["Annualized wages",null,null,{"$f":"D3*12","v":0},null,"Taxes",{"$f":"IF(N7=TRUE,D7,ROUND(VLOOKUP(TRUE,B21:N26,13,FALSE),2))","v":{"$error":"#VALUE!"}}]
["Federal Income Taxes"]
["Annualized FIT",null,null,{"$f":"D6*12","v":{"$error":"#VALUE!"}}]
["FIT after phase out threshold restrictions",null,null,{"$f":"VLOOKUP(TRUE,B21:H26,6,FALSE)","v":7250}]
[null,null,null,{"$f":"IF(D11>D12,D12,D11)","v":{"$error":"#VALUE!"}}]
["Standard Deduction Determination"]
["Single",2420]
["Married",4840]
["Standard Deduction Amount",null,null,{"$f":"IF($D$5=\"Single (S)\",IF(D4<3, B15, B16),B16)","v":4840}]
["BASE Wage",null,null,{"$f":"D9-D17-D13","v":{"$error":"#VALUE!"}}]
[]
["BASE Wage Determination",null,"Base Threshold","Base Amt adj","Base Tax amt","Pct","Phase Out","Phase out Math","Allowances","Base x Pct","Annual Withholding","Monthly withholding","Additional","Total w/ additional"]
["Single with fewer than 3 allowances, $50k or less",{"$f":"IF($D$5=$N$4,IF($D$9<50000,IF($D$4<3,TRUE,FALSE),FALSE),FALSE)","v":true},{"$f":"LOOKUP($D$18,B31:B33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,F31:F33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,D31:D33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,E31:E33)","v":{"$error":"#VALUE!"}},7250,{"$f":"IF($D$11>G21,G21,$D$11)","v":{"$error":"#VALUE!"}},{"$f":"$D$4*219","v":0},{"$f":"($D$18-D21)*F21","v":{"$error":"#VALUE!"}},{"$f":"E21+J21-I21","v":{"$error":"#VALUE!"}},{"$f":"K21/12","v":{"$error":"#VALUE!"}},{"$f":"$D$7","v":0},{"$f":"L21+M21","v":{"$error":"#VALUE!"}}]
["Single with 3 or more allowances, $50k or less",{"$f":"IF($D$5=$N$4,IF($D$9<50000,IF($D$4>=3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,B36:B38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,F36:F38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,D36:D38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,E36:E38)","v":{"$error":"#VALUE!"}},7250,{"$error":"#VALUE!"},0,{"$f":"($D$18-D22)*F22","v":{"$error":"#VALUE!"}},{"$f":"E22+J22-I22","v":{"$error":"#VALUE!"}},{"$f":"K22/12","v":{"$error":"#VALUE!"}},{"$f":"$D$7","v":0},{"$f":"L22+M22","v":{"$error":"#VALUE!"}}]
["Married with $50k or less",{"$f":"IF($D$5<>$N$4,IF($D$9<50000,TRUE,FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,B41:B43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,F41:F43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,D41:D43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,E41:E43)","v":{"$error":"#VALUE!"}},7250,{"$error":"#VALUE!"},0,{"$f":"($D$18-D23)*F23","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Single with <3 allowances, $50k+",{"$f":"IF($D$5=$N$4,IF($D$9>50000,IF($D$4<3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"IFERROR(LOOKUP($D$18,M31:M32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,Q31:Q32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,O31:O32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,P31:P32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$9,I31:I36,K31:K36),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"IFERROR(($D$18-D24)*F24,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Single with >3 allowances, $50k+",{"$f":"IF($D$5=$N$4,IF($D$9>50000,IF($D$4>=3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,M35:M36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,Q35:Q36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,O35:O36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,P35:P36)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(LOOKUP($D$9,I40:I45,K40:K45),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"($D$18-D25)*F25","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Married with $50k+",{"$f":"IF($D$5<>$N$4,IF($D$9>50000,TRUE,FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,M39:M40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,Q39:Q40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,O39:O40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,P39:P40)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(LOOKUP($D$9,I48:I53,K48:K53),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"($D$18-D26)*F26","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[]
[]
[null,"$50k or less annualized wages",null,null,null,null,null,null,"Greater than $50k Phase out",null,null,null,"Greater than $50k annualized wages"]
[null,"Single with fewer than 3 allowances, $50k or less",null,null,null,null,null,null,"Single with <3 allowances, $50k+",null,null,null,"Single with <3 allowances, $50k+"]
[null,0,3750,219,4.7500000000000001E-2,0,null,null,50000,125000,7250,null,40330,125000,563,8.7499999999999994E-2,9450]
[null,3750,9450,397,6.7500000000000004E-2,3750,null,null,125000,130000,5800,null,125000,null,10674,9.9000000000000005E-2,125000]
[null,9450,50000,782,8.7499999999999994E-2,9450,null,null,130000,135000,4350]
[null,null,null,null,null,null,null,null,135000,140000,2900,null,"Single with >3 allowances, $50k+"]
[null,"Single with 3 or more allowances, $50k or less",null,null,null,null,null,null,140000,145000,1450,null,37910,250000,1126,8.7499999999999994E-2,18900]
[null,0,7500,219,4.7500000000000001E-2,0,null,null,145000,null,0,null,250000,null,21347,9.9000000000000005E-2,250000]
[null,7500,18900,575,6.7500000000000004E-2,7500]
[null,18900,50000,1345,8.7499999999999994E-2,18900,null,null,null,null,null,null,"Married with $50k+"]
[null,null,null,null,null,null,null,null,"Single with >3 allowances, $50k+",null,null,null,37910,250000,1126,8.7499999999999994E-2,18900]
[null,"Married with $50k or less",null,null,null,null,null,null,50000,125000,7250,null,250000,null,21347,9.9000000000000005E-2,250000]
[null,0,7500,219,4.7500000000000001E-2,0,null,null,125000,130000,5800]
[null,7500,18900,575,6.7500000000000004E-2,7500,null,null,130000,135000,4350]
[null,18900,50000,1345,8.7499999999999994E-2,18900,null,null,135000,140000,2900]
[null,null,null,null,null,null,null,null,140000,145000,1450]
[null,null,null,null,null,null,null,null,145000,null,0]
[]
[null,null,null,null,null,null,null,null,"Married with $50k+"]
[null,null,null,null,null,null,null,null,50000,250000,7250]
[null,null,null,null,null,null,null,null,250000,260000,5800]
[null,null,null,null,null,null,null,null,260000,270000,4350]
[null,null,null,null,null,null,null,null,270000,280000,2900]
[null,null,null,null,null,null,null,null,280000,290000,1450]
[null,null,null,null,null,null,null,null,290000,null,0]

{"sheet":"ORSITAfter","index":24,"n_rows":53,"n_cols":17,"rows_kept":53,"cut":false,"hidden":true,"merged":[[9,0,9,3],[13,0,13,3],[16,0,16,2],[28,1,28,5],[28,12,28,16]]}
["After Change"]
[]
["Month's total SIT subject wages",null,null,{"$f":"Summarymath!J68","v":0},null,null,null,null,null,null,null,null,null,"Married (J)","Married (J)"]
["Allowances",null,null,{"$f":"ORWHold!G11","v":0},null,null,null,null,null,null,null,null,null,"Single / Married but withhold at higher Single Rate (S)","Single (S)"]
["Filing Status",null,null,{"$f":"FedStateCalc!N5","v":"Single / Married but withhold at higher Single Rate (S)"},null,null,null,null,null,null,null,null,{"$f":"FedStateCalc!$V$8","v":false},"Exempt (N)"]
["Federal Withholding Amount",null,null,{"$f":"Summarymath!I70","v":""}]
["Additional Withholding",null,null,{"$f":"ORWHold!G13","v":0}]
[]
["Annualized wages",null,null,{"$f":"D3*12","v":0},null,"Taxes",{"$f":"IF(M5=TRUE,D7,ROUND(VLOOKUP(TRUE,B21:N26,13,FALSE),2))","v":{"$error":"#VALUE!"}}]
["Federal Income Taxes"]
["Annualized FIT",null,null,{"$f":"D6*12","v":{"$error":"#VALUE!"}}]
["FIT after phase out threshold restrictions",null,null,{"$f":"VLOOKUP(TRUE,B21:H26,6,FALSE)","v":7250}]
[null,null,null,{"$f":"IF(D11>D12,D12,D11)","v":{"$error":"#VALUE!"}}]
["Standard Deduction Determination"]
["Single",2420]
["Married",4840]
["Standard Deduction Amount",null,null,{"$f":"IF($D$5=\"Single (S)\",IF(D4<3, B15, B16),B16)","v":4840}]
["BASE Wage",null,null,{"$f":"D9-D17-D13","v":{"$error":"#VALUE!"}}]
[]
["BASE Wage Determination",null,"Base Threshold","Base Amt adj","Base Tax amt","Pct","Phase Out","Phase out Math","Allowances","Base x Pct","Annual Withholding","Monthly withholding","Additional","Total w/ additional"]
["Single with fewer than 3 allowances, $50k or less",{"$f":"IF($D$5=$N$4,IF($D$9<50000,IF($D$4<3,TRUE,FALSE),FALSE),FALSE)","v":true},{"$f":"LOOKUP($D$18,B31:B33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,F31:F33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,D31:D33)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B31:B33,E31:E33)","v":{"$error":"#VALUE!"}},7250,{"$f":"IF($D$11>G21,G21,$D$11)","v":{"$error":"#VALUE!"}},{"$f":"$D$4*219","v":0},{"$f":"($D$18-D21)*F21","v":{"$error":"#VALUE!"}},{"$f":"E21+J21-I21","v":{"$error":"#VALUE!"}},{"$f":"K21/12","v":{"$error":"#VALUE!"}},{"$f":"$D$7","v":0},{"$f":"L21+M21","v":{"$error":"#VALUE!"}}]
["Single with 3 or more allowances, $50k or less",{"$f":"IF($D$5=$N$4,IF($D$9<50000,IF($D$4>=3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,B36:B38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,F36:F38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,D36:D38)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B36:B38,E36:E38)","v":{"$error":"#VALUE!"}},7250,{"$error":"#VALUE!"},0,{"$f":"($D$18-D22)*F22","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},{"$f":"$D$7","v":0},{"$f":"L22+M22","v":{"$error":"#VALUE!"}}]
["Married with $50k or less",{"$f":"IF($D$5<>$N$4,IF($D$9<50000,TRUE,FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,B41:B43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,F41:F43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,D41:D43)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,B41:B43,E41:E43)","v":{"$error":"#VALUE!"}},7250,{"$error":"#VALUE!"},0,{"$f":"($D$18-D23)*F23","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Single with <3 allowances, $50k+",{"$f":"IF($D$5=$N$4,IF($D$9>50000,IF($D$4<3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"IFERROR(LOOKUP($D$18,M31:M32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,Q31:Q32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,O31:O32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$18,M31:M32,P31:P32),\"\")","v":""},{"$f":"IFERROR(LOOKUP($D$9,I31:I36,K31:K36),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"IFERROR(($D$18-D24)*F24,\"\")","v":""},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Single with >3 allowances, $50k+",{"$f":"IF($D$5=$N$4,IF($D$9>50000,IF($D$4>=3,TRUE,FALSE),FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,M35:M36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,Q35:Q36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,O35:O36)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M35:M36,P35:P36)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(LOOKUP($D$9,I40:I45,K40:K45),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"($D$18-D25)*F25","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
["Married with $50k+",{"$f":"IF($D$5<>$N$4,IF($D$9>50000,TRUE,FALSE),FALSE)","v":false},{"$f":"LOOKUP($D$18,M39:M40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,Q39:Q40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,O39:O40)","v":{"$error":"#VALUE!"}},{"$f":"LOOKUP($D$18,M39:M40,P39:P40)","v":{"$error":"#VALUE!"}},{"$f":"IFERROR(LOOKUP($D$9,I48:I53,K48:K53),\"\")","v":""},{"$error":"#VALUE!"},0,{"$f":"($D$18-D26)*F26","v":{"$error":"#VALUE!"}},{"$error":"#VALUE!"},{"$error":"#VALUE!"},0,{"$error":"#VALUE!"}]
[]
[]
[null,"$50k or less annualized wages",null,null,null,null,null,null,"Greater than $50k Phase out",null,null,null,"Greater than $50k annualized wages"]
[null,"Single with fewer than 3 allowances, $50k or less",null,null,null,null,null,null,"Single with <3 allowances, $50k+",null,null,null,"Single with <3 allowances, $50k+"]
[null,0,3750,219,4.7500000000000001E-2,0,null,null,50000,125000,7250,null,40330,125000,563,8.7499999999999994E-2,9450]
[null,3750,9450,397,6.7500000000000004E-2,3750,null,null,125000,130000,5800,null,125000,null,10674,9.9000000000000005E-2,125000]
[null,9450,50000,782,8.7499999999999994E-2,9450,null,null,130000,135000,4350]
[null,null,null,null,null,null,null,null,135000,140000,2900,null,"Single with >3 allowances, $50k+"]
[null,"Single with 3 or more allowances, $50k or less",null,null,null,null,null,null,140000,145000,1450,null,37910,250000,1126,8.7499999999999994E-2,18900]
[null,0,7500,219,4.7500000000000001E-2,0,null,null,145000,null,0,null,250000,null,21347,9.9000000000000005E-2,250000]
[null,7500,18900,575,6.7500000000000004E-2,7500]
[null,18900,50000,1345,8.7499999999999994E-2,18900,null,null,null,null,null,null,"Married with $50k+"]
[null,null,null,null,null,null,null,null,"Single with >3 allowances, $50k+",null,null,null,37910,250000,1126,8.7499999999999994E-2,18900]
[null,"Married with $50k or less",null,null,null,null,null,null,50000,125000,7250,null,250000,null,21347,9.9000000000000005E-2,250000]
[null,0,7500,219,4.7500000000000001E-2,0,null,null,125000,130000,5800]
[null,7500,18900,575,6.7500000000000004E-2,7500,null,null,130000,135000,4350]
[null,18900,50000,1345,8.7499999999999994E-2,18900,null,null,135000,140000,2900]
[null,null,null,null,null,null,null,null,140000,145000,1450]
[null,null,null,null,null,null,null,null,145000,null,0]
[]
[null,null,null,null,null,null,null,null,"Married with $50k+"]
[null,null,null,null,null,null,null,null,50000,250000,7250]
[null,null,null,null,null,null,null,null,250000,260000,5800]
[null,null,null,null,null,null,null,null,260000,270000,4350]
[null,null,null,null,null,null,null,null,270000,280000,2900]
[null,null,null,null,null,null,null,null,280000,290000,1450]
[null,null,null,null,null,null,null,null,290000,null,0]

{"sheet":"InsNames","index":25,"n_rows":75,"n_cols":24,"rows_kept":75,"cut":false,"hidden":true,"merged":[]}
["Optional Life","Employee Optional Life","Spouse","Emp. Spouse Optional Life",null,"FSA Types",null,null,"Disability","Short-term Disabilty ",null,"Basic Life Ins","Basic Life Ins Drop-down",null,"Dental Ins","Dental Ins Drop-Down",null,null,"Enrollment?",null,null,null,null,"Opt Out"]
["U3NN","EMP LIFE/24-","U8NN","SP/DP 24-   ",null,"FHNN","FSA/HLTHCARE","Standard Short-term disability, 60%","STNN","SHORTERM DIS",null,"None","None","Kaiser Dental Plan 1% ","None","-",null,null,"Yes",null,null,null,null,"Opted out of medical and receive the Insurance Return Payment (\"INS RETURN\")"]
["U3SC","EMP TB 24-  ","U8SC","SP/DP TB 24-","Commuter Account – Transportation","FTNN","COMM/TRANS",null,"Disability","Long-term Disability","$10,000 Basic Life Insurance 1%","SL1N","BASIC LIFE1%","Kaiser Dental Plan 5%","KSR DENT 1% ","KD1N",null,null,"No, I'm not enrolled",null,null,null,null,"Declined coverage, and do not receive Insurance Return Payment"]
["U4NN","EMP LF/25-29","U9NN","SP/DP 25-29 ",null,"FDNN","FSA/DEP CARE",null,"AGNN","LONGTERM DIS","$10,000 Basic Life Insurance 5%","SLNN","BASIC LIFE5%","Delta PPO Dental Plan 1%","KSR DENT 5% ","KDNN"]
["U4SC","EMP TB 25-29","U9SC","SP/DPTB25-29","Commuter Account – Parking","FKNN","COMM/PKING",null,"AHNN","LONGTERM DIS","$10,000 Basic Life Insurance 3% ","SL3N","BASIC LIFE 3%","Delta PPO Dental 5% ","DLT PPO DT1%","OP1N"]
["UANN","EMP LF/30-34","UKNN","SP/DP 30-34 ",null,"FQNN","POST TAX FSA",null,"AJNN","LONGTERM DIS",null,"SLYJ","JUDICIAL INS","Delta Premier Dental 1%","DLT PPO DT5%","OPNN"]
["UASC","EMP TB 30-34","UKSC","SP/DPTB30-34",null,"FSCF","COMM ADM FEE",null,"AKNN","LONGTERM DIS",null,"SLYM","MGT LIFE","Delta Premier Dental 5%","DLT PRE DT1%","OT1N"]
["UBNN","EMP LF/35-39","ULNN","SP/DP 35-39 ",null,"FSAF","FSA ADM FEE ",null,null,null,null,"SLYP","MGT LIFE","Willamette Dental Services Plan 1% ","DLT PRE DT5%","OTNN",null,null,"Employment Type"]
["UBSC","EMP TB 35-39","ULSC","SP/DPTB35-39",null,null,null,null,"Accidental Death & Dismemberment","Accidental D & D",null,null,null,"Willamette Dental Services Plan 5%","WILMT DENT1%","WD1N",null,null,"Full-Time"]
["UCNN","EMP LF/40-44","UMNN","SP/DP 40-44 ",null,"Long Term Care",null,"AD&D, employee & dependent(s)","ADNN","EMP/DEP AD&D",null,null,null,null,"WILMT DENT5%","WDNN"]
["UCSC","EMP TB 40-44","UMSC","SP/DPTB40-44","UNUM Long Term Care Spouse/Dep","LBNN","UN LTC-SP/DP","AD&D, employee only","AENN","EMP AD&D    ",null,"Med FT","Medical Ins Drop-down",null,null,null,null,null,"Temp Ins Possibility"]
["UDNN","EMP LF/45-49","UNNN","SP/DP 45-49 ","UNUM Long Term Care Employee ","LCNN","UN LTC-EMP",null,null,null,null,"None",null,null,null,null,null,null,"KSR HD 1%   ","KA1C"]
["UDSC","EMP TB 45-49","UNSC","SP/DPTB45-49",null,null,null,null,null,null,"Kaiser Higher Deductible Plan 1% NO HEM","KSR HD 1%   ","KA1C",null,null,null,null,null,"KSR 250 1%  ","KA1N"]
["UENN","EMP LF/50-54","UONN","SP/DP 50-54 ",null,null,null,null,"Dependent Life Ins","Dependent Life Ins","Kaiser Deductible Plan 1% HEM ","KSR 250 1%  ","KA1N",null,null,null,null,null,"KSR 250 5%","KANN"]
["UESC","EMP TB 50-54","UOSC","SP/DPTB50-54",null,null,null,"Life, optional, dependent ","LTNN","DEP LIFE    ",null,"KSR 250 5%","KANN",null,"PT Dental",null,null,null,"KSR HMO 5%  ","KMNN"]
["UFNN","EMP LF/55-59","UPNN","SP/DP 55-59 ",null,"OSGP",null,null,null,null,"Kaiser Traditional HMO Plan 5% HEM ","KSR HMO 5%  ","KMNN","Kaiser Part-time Dental Plan 5%","None","-",null,null,"KSR HD 5%   ","KMSC"]
["UFSC","EMP TB 55-59","UPSC","SP/DPTB55-59",null,"DCNN","DEF/COMP",null,"Misc Surcharges",null,"Kaiser Traditional HMO Higher Deductible Plan 5% NO HEM","KSR HD 5%   ","KMSC","Kaiser Part-Time Dental Plan 1%","KSRDENT PT5%","KQNN",null,null,"SMT 1%NOHEM ","MS1C"]
["UGNN","EMP LF/60-64","UQNN","SP/DP 60-64 ",null,"RTNN","ROTH 457 ","Spouse/partner declined other ins","SGSC","SPOUSE INS  ",null,"SMT 1%NOHEM ","MS1C","Delta Dental Part-time Plan 1%","KSRDENT PT1%","KQ1N",null,null,"SMT 1% HEM  ","MS1N"]
["UGSC","EMP TB 60-64","UQSC","SP/DPTP60-64",null,"LONN","DEF/COMPLOAN","Tobacco Surcharge ","TBSC","TOBACCO SC  ",null,"SMT 1% HEM  ","MS1N","Delta Dental Part-time Plan 5%","DLT DENTPT1%","OQ1N",null,null,"SYN HDNOHEM ","MY1C"]
["UHNN","EMP LF/65-69","URNN","SP/DP 65-69 ",null,null,null,"If a spouse, domestic partner or a dependent\nchild is enrolled in a medical plan (except opt out)\nand is also enrolled in a PEBB medical plan as a\nsubscriber, this new surcharge will apply","DBSC","DBL COV SC  ","MODA Synergy HD Plan 1% NO HEM","SYN HDNOHEM ","MY1C",null,"DLT DENTPT5%","OQNN",null,null,"SYN 1% HEM  ","MY1N"]
["UHSC","EMP TB 65-69","URSC","SP/DPTP65-69",null,null,null,null,null,null,"MODA Synergy Plan 1% HEM","SYN 1% HEM  ","MY1N",null,null,null,null,null,"PRCH HD 1%  ","PV1C"]
["UJNN","EMP LF/70-74","USNN","SP/DP 70-74 ",null,"Pre-tax Parking",null,null,null,null,"Providence Choice PPO 1% NO HEM","PRCH HD 1%  ","PV1C",null,null,null,null,null,"PRCH 250 1% ","PV1N"]
["UJSC","EMP TB 70-74","USSC","SP/DPTB70-74",null,"MCNN - Pre-tax Marion Co Bus Svcs","PARK PRETAX",null,"OONN","MED OPT OUT","Providence Choice PPO 1% HEM","PRCH 250 1% ","PV1N",null,null,null,null,null,"PRSW 250 5% ","SWNN"]
["UWNN","EMP LIFE/75+","UYNN","SP/DP 75+",null,"PKNN","PARK PRETAX",null,null,null,"Providence PEBB Statewide Plan 5% HEM","PRSW 250 5% ","SWNN",null,null,null,null,null,"PRSW HD 5%  ","SWSC"]
["UWSC","EMP TB 75+","UYSC","SP/DPTB 75+",null,"PWNN","OYA PARKING",null,null,null,"Providence PEBB Statewide 350 Plan 5% NO HEM","PRSW HD 5%  ","SWSC",null,null,null,null,null,"KSR PT HD1%","KB1C"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Vision Ins","Vision Ins Drop-down",null,null,"KSR 250 PT1%","KB1N"]
[null,null,null,null,null,"Tax-Deferred Annuities - Dept of Education (58100) only",null,null,null,null,null,"Med PT",null,null,null,"None",null,null,"KSR 250 PT5%","KBNN"]
[null,null,null,null,"American Century Investors","ZBNN","AMER CEN INV",null,"Misc Optional Deductions - Post Tax",null,null,"None",null,"Vision Service Plan 1% ","VS1N","VSP 1%      ",null,null,"KSR HMO PT5%","KONN"]
[null,null,null,null,"ING Life Insurance","ZCNN","VOYA",null,"BK Codes","FOOD BANK","Kaiser Part-time Deductible Plan 1% HEM ","KSR PT HD1%","KB1C","Vision Service Plan 3% ","VS3N","VSP 3%      ",null,null,"KSR PT HD5%","KOSC"]
[null,null,null,null,"AXA Equitable","ZGNN","AXA EQUIT",null,"BSNN","BUS PASS","Kaiser Part-time Deductible Plan 1% HEM","KSR 250 PT1%","KB1N","Vision Service Plan 5%","VSNN","VSP 5%      ",null,null,"SYN PT HD NH","MZ1C"]
[null,null,null,null,"VALIC/TDA","ZJNN","VALIC/TDA",null,"BTNN","T/MET PASS",null,"KSR 250 PT5%","KBNN",null,null,null,null,null,"SYN PT1% HEM","MZ1N"]
[null,null,null,null,"Waddell & Reed, Inc ","ZRNN","IVY FUNDS",null,"EQNN","TRI-MET PASS","Kaiser Traditional Part-time HMO Plan 5% HEM","KSR HMO PT5%","KONN",null,null,null,null,null,"PRCH PT HD1%","PO1C"]
[null,null,null,null,"Forestors Financial Services","ZZNN","PENSERV",null,"FZNN","FREEZER USE","Kaiser Traditional Part-time HMO Higher Deductible Plan 5% NO HEM","KSR PT HD5%","KOSC",null,null,null,null,null,"PRCH250 PT1%","PO1N"]
[null,null,null,null,"Oppenheimer Fund ","Z2NN","INVESCO",null,"HSNN","HOUSING","MODA Synergy Part-time HD Plan 1% NO HEM","SYN PT HD NH","MZ1C",null,null,null,null,null,"PRSW 250 PT5","SPNN"]
[null,null,null,null,null,null,null,null,"JSNN","JACKSON SCHO","MODA Synergy Part-time Plan 1% HEM","SYN PT1% HEM","MZ1N",null,null,null,null,null,"PRSW PT HD5%","SPSC"]
[null,null,null,null,null,null,null,null,"OSNN","OSSC SCHOLAR","Providence Choice Part-time PPO1% NO HEM ","PRCH PT HD1%","PO1C"]
[null,null,null,null,null,null,null,null,"PCNN","CCB PARKING","Providence Choice Part-time PPO 1% HEM","PRCH250 PT1%","PO1N"]
[null,null,null,null,null,null,null,null,"PDNN","PILOT AD&D","Providence PEBB Statewide Part-time Plan 5% HEM","PRSW 250 PT5","SPNN"]
[null,null,null,null,null,null,null,null,"PENN","REA PARKING","Providence PEBB Statewide 350 Part-time Plan 5% NO HEM","PRSW PT HD5%","SPSC"]
[null,null,null,null,null,null,null,null,"PKXN","PARK POSTTAX"]
[null,null,null,null,null,null,null,null,"PRNN","ADDL RETIREM"]
[null,null,null,null,null,null,null,null,"PSNN","ADDL RETIREM"]
[null,null,null,null,null,null,null,null,"PUNN","PUC PARKING"]
[null,null,null,null,null,null,null,null,"Q5NN","CHARITABLE"]
[null,null,null,null,null,null,null,null,"SUNN","CHILD SUPRT"]
[null,null,null,null,null,null,null,null,"G Codes","Garnishments"]
[null,null,null,null,null,null,null,null,"WLNN","ASSURANT"]
[null,null,null,null,null,null,null,"Vision Service Plus Plan","VPNN","VISION PLUS "]
[]
[]
[null,null,null,null,null,"Optional Life","None",null,"Spouse","None"]
[null,null,null,null,"Life, optional, employee, ≤24 ","U3NN","EMP LIFE/24-","Life, optional, spouse/DP, ≤24 ","U8NN","SP/DP 24-   "]
[null,null,null,null,"Life, optional, employee, tobacco use, ≤24","U3SC","EMP TB 24-  ","Life, optional, spouse/DP, tobacco use, ≤24 ","U8SC","SP/DP TB 24-"]
[null,null,null,null,"Life, optional, employee, 25-29","U4NN","EMP LF/25-29","Life, optional, spouse/DP, 25-29","U9NN","SP/DP 25-29 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 25-29","U4SC","EMP TB 25-29","Life, optional, spouse/DP, tobacco use, 25-29 ","U9SC","SP/DPTB25-29"]
[null,null,null,null,"Life, optional, employee, 30-34","UANN","EMP LF/30-34","Life, optional, spouse/DP, 30-34","UKNN","SP/DP 30-34 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 30-34","UASC","EMP TB 30-34","Life, optional, spouse/DP, tobacco use, 30-34 ","UKSC","SP/DPTB30-34"]
[null,null,null,null,"Life, optional, employee, 35-39","UBNN","EMP LF/35-39","Life, optional, spouse/DP, 35-39 ","ULNN","SP/DP 35-39 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 35-39 ","UBSC","EMP TB 35-39","Life, optional, spouse/DP, tobacco use, 35-39","ULSC","SP/DPTB35-39"]
[null,null,null,null,"Life, optional, employee, 40-44","UCNN","EMP LF/40-44","Life, optional, spouse/DP, 40-44","UMNN","SP/DP 40-44 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 40-44 ","UCSC","EMP TB 40-44","Life, optional, spouse/DP, tobacco use, 40-44","UMSC","SP/DPTB40-44"]
[null,null,null,null,"Life, optional, employee, 45-49","UDNN","EMP LF/45-49","Life, optional, spouse/DP, 45-49","UNNN","SP/DP 45-49 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 45-49 ","UDSC","EMP TB 45-49","Life, optional, spouse/DP, tobacco use, 45-49 ","UNSC","SP/DPTB45-49"]
[null,null,null,null,"Life, optional, employee, 50-54 ","UENN","EMP LF/50-54","Life, optional, spouse/DP, 50-54 ","UONN","SP/DP 50-54 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 50-54 ","UESC","EMP TB 50-54","Life, optional, spouse/DP, tobacco use, 50-54 ","UOSC","SP/DPTB50-54"]
[null,null,null,null,"Life, optional, employee, 55-59 ","UFNN","EMP LF/55-59","Life, optional, spouse/DP, 55-59","UPNN","SP/DP 55-59 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 55-59 ","UFSC","EMP TB 55-59","Life, optional, spouse/DP, tobacco use, 55-59","UPSC","SP/DPTB55-59"]
[null,null,null,null,"Life, optional, employee, 60-64 ","UGNN","EMP LF/60-64","Life, optional, spouse/DP, 60-64","UQNN","SP/DP 60-64 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 60-64","UGSC","EMP TB 60-64","Life, optional, spouse/DP, tobacco use, 60-64 ","UQSC","SP/DPTP60-64"]
[null,null,null,null,"Life, optional, employee, 65-69 ","UHNN","EMP LF/65-69","Life, optional, spouse/DP, 65-69","URNN","SP/DP 65-69 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 65-69 ","UHSC","EMP TB 65-69","Life, optional, spouse/DP, tobacco use, 65-69 ","URSC","SP/DPTP65-69"]
[null,null,null,null,"Life, optional, employee, 70-74","UJNN","EMP LF/70-74","Life, optional, spouse/DP, 70-74","USNN","SP/DP 70-74 "]
[null,null,null,null,"Life, optional, employee, tobacco use, 70-74","UJSC","EMP TB 70-74","Life, optional, spouse/DP, tobacco use, 70-74 ","USSC","SP/DPTB70-74"]
[null,null,null,null,"Life, optional, employee, 75+ ","UWNN","EMP LIFE/75+","Life, optional, spouse/DP,75+","UYNN","SP/DP 75+"]
[null,null,null,null,"Life, optional, employee, tobacco use, 75+ ","UWSC","EMP TB 75+","Life, optional, spouse/DP, tobacco use, 75+","UYSC","SP/DPTB 75+"]