ࡱ> b  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`acdefghijklmnopqrstuvwxyz{|}~Root Entry Fx+ E@ WorkbookYSummaryInformation(DocumentSummaryInformation8 g2\pIITS Ba= ThisWorkbook=|G/8X@"1pTms Rmn1pTms Rmn1pTms Rmn1pTms Rmn1pGeneva1 pPalatino1 pPalatino1 pPalatino1pTms Rmn1 pPalatino1pTms Rmn1pArial1pArial1pArial1 pArial1pArial1pArial1pArial1pArial1Calibri1 Calibri1Calibri14Calibri1 Calibri1Calibri1Calibri1,8Calibri18Calibri18Calibri1>141<Calibri1?Calibri1h8Cambria1Calibri1 Calibri"$"#,##0_);\("$"#,##0\)!"$"#,##0_);[Red]\("$"#,##0\)""$"#,##0.00_);\("$"#,##0.00\)'""$"#,##0.00_);[Red]\("$"#,##0.00\)7*2_("$"* #,##0_);_("$"* \(#,##0\);_("$"* "-"_);_(@_).))_(* #,##0_);_(* \(#,##0\);_(* "-"_);_(@_)?,:_("$"* #,##0.00_);_("$"* \(#,##0.00\);_("$"* "-"??_);_(@_)6+1_(* #,##0.00_);_(* \(#,##0.00\);_(* "-"??_);_(@_)#,##0.00\ ;\(#,##0.00\)#,##0\ ;\(#,##0\) #,##0.0000\ ;\(#,##0.0000\) 0.000"[Cyan]#,##0.00\ ;\(#,##0.00\)![Red]#,##0.00\ ;\(#,##0.00\) [Green]0% 0.0000 0.00000 #,##0.0000_);\(#,##0.0000\)"Yes";"Yes";"No""True";"True";"False""On";"On";"Off"],[$ -2]\ #,##0.00_);[Red]\([$ -2]\ #,##0.00\)#,##0.000_);\(#,##0.000\)                                                                      ff       P  P        `       !   " # a> $ !         ! !  # !8  ( !8    (  ,  (    ,@  ,@  ""  (     D  D h  d@ @ )     !P  D #T !x  "  @  D #P  D ' D  D  D    ,  ,  !8@ @  #@ @  #@ @  1#@ @  #@ @  @ @ !8@ @  l@ @   l@ @ 8    !  !  !   !@ @   @ @    @  !   ! #     '  ! !   !   @  #  ! ||:/}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef[$ -}A} 00_)ef [$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L[$ -}A} 00_)L [$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A} 00_)23[$ -}A}  00_)23[$ -}A}! 00_)23 [$ -}A}" 00_)[$ -}A}# 00_)[$ -}A}$ 00_)[$ -}A}% 00_)[$ -}A}& 00_)[$ -}A}' 00_) [$ -}A}( 00_)[$ -}}) }00_)[$ -##0.  }}* 00_)[$ -???##0.??? ??? ???}-}- 00_)}A}. a00_)[$ -}A}/ 00_)[$ -}A}0 00_)?[$ -}A}1 00_)23[$ -}-}2 00_)}}3 ??v00_)̙[$ -##0.  }A}4 }00_)[$ -}A}5 e00_)[$ -}x}600_)[$##  }}7 ???00_)[$???## ???  ??? ???}-}9 00_)}U}: 00_)[$## }-}; 00_)}(}Z00_) 20% - Accent1M 20% - Accent1 ef % 20% - Accent2M" 20% - Accent2 ef % 20% - Accent3M& 20% - Accent3 ef % 20% - Accent4M* 20% - Accent4 ef % 20% - Accent5M. 20% - Accent5 ef % 20% - Accent6M2 20% - Accent6  ef % 40% - Accent1M 40% - Accent1 L % 40% - Accent2M# 40% - Accent2 L渷 % 40% - Accent3M' 40% - Accent3 L % 40% - Accent4M+ 40% - Accent4 L % 40% - Accent5M/ 40% - Accent5 L % 40% - Accent6M3 40% - Accent6  Lմ % 60% - Accent1M 60% - Accent1 23 % 60% - Accent2M$ 60% - Accent2 23ږ % 60% - Accent3M( 60% - Accent3 23כ % 60% - Accent4M, 60% - Accent4 23 % 60% - Accent5M0 60% - Accent5 23 %! 60% - Accent6M4 60% - Accent6  23 % "Accent1AAccent1 O % #Accent2A!Accent2 PM % $Accent3A%Accent3 Y % %Accent4A)Accent4 d % &Accent5A-Accent5 K % 'Accent6A1Accent6  F %(Bad9Bad  %) Calculation Calculation  }% * Check Cell Check Cell  %????????? ???+ Comma,&Currency-Explanatory TextG5Explanatory Text % .Good;Good  a%/ Heading 1G Heading 1 I}%O0 Heading 2G Heading 2 I}%?1 Heading 3G Heading 3 I}%232 Heading 49 Heading 4 I}% 3InputuInput ̙ ??v% 4 Linked CellK Linked Cell }% 5NeutralANeutral  e%"Normal 6Noteb Note   7OutputwOutput  ???%????????? ???8$Percent 9Title1Title I}% :TotalMTotal %OO; Warning Text? Warning Text %XTableStyleMedium9PivotStyleLight16`%atPaycheck Calculator - CA 2018ADDALLOW:X CAT:DCA1:DCA2:DCA3:DCA4:DCA5:DCA6:DED1: DED2<DED3: DED4: EPMC: EPMC_: EPMC2: EPMCD: FAN1: FBSA1:' FBST1:7 FEDE:! FEDERAL;FEDEXM: FEDEXMPT:FEDM: Flex_Cash: FMTR1:/ FMTR2:0 FMTR3:1 FMTR4:2 FMTR5:3 FMTR6:4 FOVR1:? FTA1:G FTAX1:O FTAX2:P FTAX3:Q FTAX4:R FTAX5:S FTAX6:T FTG1: ! FTXTBLM;" FTXTBLSH; GROSS:& INSTRUCTIONS;#? IT;LIE:W LIEH:LIEM1:LIEM2:LIES:  MACROS;'e!MD_: MED: MED_: OA_: OAC:OASDI: OASDI_: PAYFACT: PER1: PER2: PER3: PER4:   ;% RETID_TABLE;? SADDALL:! SafetyCheck: SBSA1:h SBST1:x SDED:Y SDH: SDI: SDI_RATE: SDI1: SDIGRS: SDM1: SDM2: SDS: SMTR1:p SMTR2:q SMTR3:r SMTR4:s SMTR5:t SMTR6:u SOVR1: STA: STA1:  STATE;aSTAX1: STAX2: STAX3: STAX4: STAX5: STAX6: STE: STG1:` STM: ! STXTBLM;(! STXTBLS;" STXTBLUH;,6TCRM0:<TCRM1:<TCRM2:<TCRMR:<TCRS0:;TCRS1:;TCRS2:;TCRSR:;TG1: TG2: TG3: TG4: TG5: TG6: TIER:*Total_A_R_Deductions: Total_Flex:TXCRB:Z TXCREDIT:] TXCROV2:[ TXCRR:\ VOLDEDS: WORK; 8 h COMPUTED FIELDSSS %MED %FEDERAL INCOME TAX EXEMPTIONSTATE INCOME TAX Gross Pay MED%ADDITIONAL ALLOWANCESMEDSS%SINGLE/HEAD OF HOUSEHOLDSSEPMCBASE AMTPERCENTBASE TAX" LOW INCOME TAX EXEMPTIONFederal Marital Status (M, S, H)EPMC DED --- MARRIED ---HEAD OFNumber of Exemptions Fed(1-99)EPMC%SINGLE0 or 1 2 or more HOUSEHOLDState Marital StatusNumber of Exemptions StateSSTXGAdditional Exemptions StateMEDTXG STANDARD DEDUCTION TABLEFlex Cash OptionTXGRS1Total Other Flex DeductionsTXGRS2Total A/R Deductions3(Account Receivable deduction (Shown as ACCT RCVBL)TXGRS3Total-Voluntary DeductionsTXGRS4Deferred Comp/TSA TXGRS5MARRIED ------- SINGLE --------NET PAYTXGRS6Difference in NetFederal Tax Withheld FEDERAL TAXState Tax WithheldPAYFACTRetirement WithheldFED EXMSocial Security WithheldANNUALIZED GROSSMedicare WithheldFAN1Federal Taxable GrossFAN2State Taxable GrossFAN3Social Security Taxable GrossFAN4Medicare Taxable GrossFAN5FAN6GENERAL INFORMATION TAXABLE GROSS ------- MARRIED --------FTG1FTG2FTG3FTG4FTG5FTG6 BASE AMOUNTSpecific entry instructions:FBSA1FBSA2FBSA3FBAS4FBAS5FBAS6UNMARRIED HEAD OF HOUSEHOLDMARGINAL TAX RATEFMTR1FMTR2FMTR3FMTR4FMTR5FMTR6 BASE TAX AMOUNTFBST1FBST2FBST3FBST4FBST5MARITAL" ------- NUMBER OF ALLOWANCES ----FBST6STATUSOVER 2DIFFERENCE FOR OVER 2 OVER BASE AMOUNTMAR/HEADFOVR1FOVR2FOVR3FOVR4FOVR5FOVR6 ANNUALIZED TAXFTA1FTA2FTA3FTA4FTA5FTA6 PAY PERIOD TAXFTAX1FTAX2FTAX3FTAX4FTAX5FTAX6 STATE TAXESLIEADDALLOWSDEDTXCRBTXCROV2TXCRRTXCREDITSTATE ANNUALIZED TAXABLE GROSSSTG1STG2STG3STG4STG5STG6 BASE AMOUNTSBSA1SBSA2SBAS3SBAS4SBAS5SBAS6 MARGINAL TAX RATESMTR1SMTR2SMTR3SMTR4SMTR5SMTR6 BASE TAX AMOUNTSBST1SBST2SBST3SBST4SBST5SBST6 OVER BASE AMOUNTSOVR1SOVR2SOVR3SORV4SORV5SORV6 ANNUALIZED TAXSTA1STA2STA3STA4STA5STA6 PAY PERIOD TAXSTAX1STAX2STAX3STAX4STAX5STAX6See instructions below"(Shown as FLEX CASH or COBEN CASH)SDI %SDI (YES, NO) SDI WithheldSDI1SDIGRSRevisionSACEE RateExclusion AmountSS Med00NO010203040506070809101112131415161718191A1B1C1D1E1F1G1H1J1K1L1M1N1P1Q1R1S1T1U1V1W1X1Y1Z202122232425272A2B2C2D2E2F2G2H2I2J2K2L2M2N2O2P2Q2R2S2T2U2V2W2X2Y2Z30313233343637393A3B3C3D3E3F3G3H3J3K3L3M3N3P3Q3R3S3T3U3V3W3X3Y3Z404142434445464748494A4B4C4D4E4F4G4H4J4K4L4M4N4P4R4S4T4U4V4W4X4Y4Z5051525354555657585A5B5C5D5E5F5G5H5J5K5L5M5N5P5V5W5X5Y6162636467686J6K6L6M6P6R6S6T6V6W6X6Y6Z8283868788899192939495969798999A9B9C9D9E9F9G9H9J9K9L9M9N9P9R9S9T9V9W9X9YAAABADAEAFAGAHAIAJAKALAMANAOAPAQARASATAUAVAWAXAYAZJJAJBJCJDJEJFJGJHJIJJJKJLJMLLONNANMTTATDTETFTGTHTJTKTLTMTNTPTRTSTXTYTZRetirement CodeDetermined by Retirement CodeNONE1st Half (1) or 2nd Half (2)TC2(M, S, B for Monthly, Semi-Monthly, and Bi-Weekly) Pay Frequency% (Please call your HR for Ret. Code.)OIf Monthly or Bi-Weekly, leave blank. If Semi Monthly, see instructions below.M (Gross Pay)4QSocial Security/Medicare ---- TAX CREDIT TABLE ----WCALIFORNIA STATE CONTROLLER'S OFFICE PAYCHECK CALCULATOR - 2018 TAX RATES (EFF. 1/1/18)J +Paycheck Calculator 2018 (revised 12/20/17)`This spreadsheet is formulated to assist employees with calculating their net (take-home) pay. aIt can be used to estimate net pay and withholding amounts for employees paid on a monthly basis.By changing the marital status or number of exemptions for federal and/or state taxes you can estimate your net and withholdingzamounts based on these changes. You may want to review your current pay stub to setup your deductions on this calculator.rDeductions listed with a * on your paystub are considered pre-tax and are deducted from your gross prior to taxes.+Gross Pay - Enter your gross monthly pay. kThis amount is shown on your earnings statement/direct deposit advice as REGULAR. Do not add in FLEX CASH.-Retirement Code - Enter the appropriate code. vEnter code 08 if you are currently contributing to PERS and were hired in a PERS eligible position prior to 01/15/2011  Enter code 2Z if you are currently contributing to PERS and were first hired by the State and placed in a PERS eligible position between 1/16/2011 through 12/31/2012  Enter code 2N if you are currently contributing to PERS and were first hired by the State and placed in a PERS eligible position on or after January 1, 2013  Enter code NONE if you are not a member of any retirement plan (typically non-represented student employee, retired annuitant, overload or non-qualified appointment  6or your retirement is paid in full by the University).dEnter code TM if you are a member of the part-time, seasonal/temporary employee PST retirement plan.  lSocial Security/Medicare - If your earnings statement/direct deposit advice shows both SOC SEC and MEDICARE  Zdeductions enter SS, if it shows MEDICARE only enter MED or if it shows neither enter NO. 69 WY EFederal Marital Status - Enter any status (M = married, S = single) . +- 8: _Number of Exemptions Fed - Enter the number of exemptions you want to compute federal tax with. State Marital Status - Enter any status (M = married, S = single or H = head of household) Note: this calculates only California state tax. )+ 68 DE qNumber of Exemptions State - Enter the number of exeptions you want to compute state tax with. (California only)  }Additional Exemptions State - Enter the number of additional exemptions you want to compute state tax with. (California only) dFlex Cash Option-Enter the amount of flex cash option that you receive. This shows as FLEX CASH or  COBEN CASH on your earnings statement/direct deposit advice. Only employees that opt out of health and or dental coverage would receive7flex cash. If you do not receive flex cash enter 0.00kTotal Other Flex Deductions-Enter the sum of all flex deductions (except FLEX CASH) that you have deducted. These are all * deductions such as Parking and Healthcare that are deducted prior to tax. Do not include *TSA, *DC-457, *457, *401K, *403B, Z` A*PERSREDPST If you have no pre-taxed flex deductions enter 0.00wTotal Voluntary Deductions-Enter the sum of all other deductions you have that are not covered in the categories above. These may include things such as credit union deductions, union dues, administrative fees, additional life insurance, etc..(excluding all *)UThese deductions are taken after tax. If you have no voluntary deductions enter 0.00vDeferred Comp/TSA - Use this field to enter any Deferred Compensation/TSA amount that you want to see calculations on. w(NOTE:Also use this field to enter PERS/STRS Retirement buy back shown as *PERSRE<DPST or *STRS REDST on your earnings statement/direct deposit advice.cSUPA Unit 8 employees should contact Payroll Services at x4420 for assistance with calculating pay."D DzDErEFu'GG;H-HIyIkIFJ8JJ:K,K|K-LLyL M jM\ M *N VNH ~Np N N N O FO8 nO` O O O P 6P( ^PP Px P P P &Q NQ@ vQh Q Q Q R>R0fRXRRRS-SUSGzSlSSTUX\`\d*cc PK![Content_Types].xmlN0EH-J@%ǎǢ|ș$زULTB l,3;rØJB+$G]7O٭Vȉ<&J &M5BNe tY>?#!mfKx=[Ԃu}ˆ ~umoLz^W/}ةLo;9iwk/_tV[,ac߬56YvYp1ϡAz 9ۮ7ެe ."Zk1~EȰ RӔ/x$( :7vʗsSj{"bF^x^xz?>~,ɸ7Gg_zy5^|?}V I򋧿>OQ>19ٵ<Ÿ8ߊaG@tOE*\ʻ/ yToN:"1Q(v; y4<$jbRa|PŻǴI Y3wJG݈8b2(<& QHT^w/B(`Z!94[Mc˴j`jG7;Q]o YC5*CocU 9 IQ/ RV+`%*;æWѼ9/#~7qZ$*cߓrUngN>%OOi Dh[BvoLJƌB6>p&>w O]>.ɲ,5,<ؾt&9 ԔEЇIIqhJ#f6kAS&2D)p3ӕ5teO`jvzEOG)9cshger-# ~fu-ԙՍh&9܊- 6 AлY3hX"M$#Fz6#b.w*lyhĭɾ̮]nR3+=,)'Kak.zi X 8Ka6!_ 5[ M܆< kW Ds/Z/j@&8?&5- C⫲K3Zw1K|D!`~J0A?Uֶy&,Xg1K#[y$[BTV)bBRvVt=낕@[\׶Dž8d4~_@`rx \kp*O69mY&ԧ HE]HKN!Vj%2BƣJԊ=" u\ӵC&Y0>g4&oN)j rihr"VTU,koy#ŬjQJpRk3܎Ws;ɢ!JT~u "֠ۀW_ Nq֙4)ڬuZˋw֒TvќXHegvtm,{2Da*20V=CoOQ2'@C8D.IrG[Ȥiࠆ)d͛|?&f9>b|w##(ɇ"C *_p=ce΂aenv*Wm瓗{varAˇ$IDpKs6* ʢG0egAnlCYt֏$Ysă)2|FS` uz'Xr*󠍒F`Bi m/Ҷj9Xrmox86tFo˜ b`>ASDbƟPK! ѐ'theme/theme/_rels/themeManager.xml.relsM 0wooӺ&݈Э5 6?$Q ,.aic21h:qm@RN;d`o7gK(M&$R(.1r'JЊT8V"AȻHu}|$b{P8g/]QAsم(#L[PK-![Content_Types].xmlPK-!֧6 0_rels/.relsPK-!kytheme/theme/themeManager.xmlPK-!ÄA theme/theme/theme1.xmlPK-! ѐ' theme/theme/_rels/themeManager.xml.relsPK]  g2 8@ԗ% +4>G P2Y  dMbP?_*+% &f Page &p&?'?(?)?M HP LJ300-400 color M351-M451 P,!C odXXLetter$DINU" D W SMTJ HP LJ300-400 color M351-M451 PCL 6InputBinFORMSOURCERESDLLUniresDLLHPDocUISUITrueESPRITSupportedTrueHPPCompositeUSBGetSerialNumberhppdvq01.dll_getDeviceSerialNumberWHPPInstallTimeConfighppdvq01.dll_getDevicePPMDuplexerWHPPCompositeUSBFilehppdvq01.dll_getDeviceSerialNumber_getDevicePPMDuplexerResolution600dpiFastResTrueDuplexNONEOrientationPORTRAITHPOrientRotate180FalsePaperSizeLETTERMediaTypeAUTOCollateOFFHPMediaTypeTreeviewPopupTrueColorMode24bppTextAsBlackFalseTTAsBitmapsSettingTTModeOutlineJPEGEnableAutoHPEnableGrafitCompressionTrueHPRequestObjectTagDumpFalseHPRequestNullStripCommandFalseHPHybridRenderSwitchHPHybridAutoHPObjectTaggingVersionCLJ_2_0AlternateLetterHeadFalseHPPaperSizeALMConstraintsA5PrintQualityGroupPQGroup_1HPDocPropResourceDatahpchl120.cabHPColorSmartAutomaticHPColorSmart_ColorOptions_EdgeControlNormalHPColorSmart_ColorOptions_HalftoneSmoothHPColorSmart_Text_NeutralGraysBlackOnlyHPColorSmart_Graphics_NeutralGraysBlackOnlyHPColorSmart_Photo_NeutralGrays4-ColorHPColorModeCOLOR_MODEHPPDLTypePDL_PCL6HPPJLEncodingUTF8HPJobAccountingHPJOBACCT_JOBACNT_COLORAUTHHPBornOnDateHPBODHPJobByJobOverrideJBJOHPXMLFileUsedhpcm3516.xmlHPEnableObjectTaggingTrueHPReverseScanLinesForDuplexTrueHPEnablePageTimerFalseHPEnableNullStripsTrueHPEnableEfficientMonoFALSEHPEnableImageProcessingPathFALSEHPCallToWritePrinterRequiredTRUEHPMemoryManagerTrueHPGetCompressionRatioValue17MaxStripHeight64HPGetByteAlignedValueForWidth256HPGetDeltaRowHalfToneValue1HPManualDuplexDialogItemsInstructionID_01_FACEDOWN-NOROTATEHPPCL6PassThroughTrueHPSmartDuplexSinglePageJobTrueHPSmartDuplexOddPageJobTrueHPManualFeedOrientationFACEDOWNHPOutputBinOrientationFACEDOWNHPManualDuplexDialogModelModelessHPManualDuplexPageOrderEvenPagesFirstHPMapManualFeedToTray1TrueHPManualDuplexPageRotateDriverRotateHPPrintOnBothSidesManuallyFalseHPNUseDiffFirstPageChoiceTRUEHPPageExceptionsFileHPCPE120HPPageExceptionsLowEndHPPageExceptionsLowEndVerHPPageExceptionsInterfaceShowPageExceptionsHPPageExceptionsCoverInsertionHPPrintInGrayScaleFalseHPPngPassthroughTruePSAlignmentFileHPCLS120HPSmartHub_SupportandtroubleshootingTRUEHPSmartHub_ProductmanualsTRUEHPSmartHub_CheckfordriverupdatesTRUEHPSmartHubInet_SID_263_BID_514_HID_265HPConsumerCustomPaperTrueHPEnableRAWSpoolingTrueRGBColorDefault-sRGBColorEconomodeSupportedTrueEconomodeFalseHPBestGlossDefaultHPMHDLLNameHPFIE120HPPreAnalysisTrueHPEasyColorOnHP_DIBStitch_TintTestDisabledIUPH!x?o@ RF#J`U@q0 eĔV%R aU ʗ`ET`I9PJJNn(XP$X>U$U4O%hމ0sVOnU{.!ܟDˑrt~Ӭ$Z^NW;)'yܮࡄ[(KAt.Ɍ'HC2{cI~2NקӜ8K?X#}ʌ)uIDt;0kc 6|<^J"mY%7eQV 5,gД>GRxZHJZs@к iEb`n猘Xk[Dѻ1te,a1ǫ2Vd^h,Om毁<2JA(S܌|zb<`ԛ g.XzzynΩ 6MDDDDDDD71x<"YXX??& U} } U}  } U }  }  }  } 8 } U } }  } U } } q }  }  }  } }  \}  \}  \}  \}  }  }  @""8 "D "8"8 "8"8 "8"8"8 "8 "8 "8 "8  "8"8"8!D !D !8!8 !8!8!8!8!8!8 !8 !8 !8 !D  ! !8 A@@CCC <  < < < < W r{{ |Z ~V-?  DC8MED  #4*C8SS  #4 "B~  S@ X9v? V-? ?@  ${{{{{{{{{{{! g~ hp@ E FFF K < 4 =fffffE@ C+CCuC6A \\\\\\]~ ]@@\ g i GOOOI <  >X9v?  C8NO CSAF CSAF2 CPAT2 CPOF2 B%CPAT B%CPOF B%*C8SS  #7 "B  \\\ W \\\\ g j  Z@OOS < 4 =yf@  C+CCuC:A  ^W\ W W W\ W\ gk GOOOI <' =  C#ABf@ c  *DB C  BU c ?DB D C+ B$C+D C B  W\ ]]]\ W W\ g'k  C#ABfSS GOOOI <' ?p= ף?  C#ABf d CC+ CsB$eCs C+CC:DS Cs B$C+C""B  \\ ]@]$@]\ ^ ^ W W\ g k G@@@I < o T`h@ YDM  $ ADS  $ "DB  $ ""BF d`h@  0CC+ C+CCB  X\ ]@].@]$@\_p@_p@_o@_o@\ g~ k? G@@@I < ' H@ C+CCu >\X\ ]@@]?]@j@\\ g k G @ D B J <"' H@ C+CCu =\X\ ~ ]@ ]Q?~ ]pF@ \ W# \ g~ k? G @ D B J <@ Q *CHYes CKCI B >\X\  ]A`@@]x@ \ W W \ g!~ k G @ D B J <' R@  C+CCu >\\\  ]A`A@]@ \ ^ ^ W W \ g k G @DBJ <%: =@ $C+CtC CCuC >\\\ ~ ]pA aMbX?~ ]@ \ _@_@_@_@ \ g$~ h G @@@I <': =Z@ $C+CtC CCuC >\\\]]]\ \ g&~ hY@ G@@@I <*: =@ $C+CtC CCuC >WX\\\\\ W0\ g(~ h G)@@@I <,: =ʢ@  $C+CtC CCuC >WX\ W W/ \\ W W W\ g+~ h@ G@@@I <.: =:@ $C+CtC CCuC >WY\ W W W\~ _bI +?~ ]\ g-*lI@[Y@Ni@Nr@N@@N@ <2: =@@ $C+CtC CCuC >WY\ ]]]\~ _@bI +?~ ]@\ m1^nffff恠@ HC+C C9C5CCuCzCC"CYDCJze/@ dC LC+C C9C5CCuCzCC#CZDCJ BzL@ dC LC+C C9C5CCuCzCC$C[DCJ BzLǝ@ dC LC+C C9C5CCuCzCC%C\DCJ BzLeffff1@ dC LC+C C9C5CCuCzCC&C]DCJ BzLeffff@ dC LC+C C9C5CCuCzCC'C^DCJ B >WY\ ]@]$@]\~ _ @bI +?~ ]a@\ g3o>f@3333D@ (c dd B>M _@ (c dd B>Mi@ (c dd B>MIw@  (c dd B>M}@ (c dd B <5 >WY\ ]@].@]$@\~ _@ @bL7A`?~ ]_@\ w4xQq@ C"7yQq@ !c  ## B7zQp@ !c  #$ B7zq= ףPn@ !c  #% B7zq= ףj@ !c  #& B7zq= ף8h@ !c  #' B{ |7S }(@ =DS 'DB   "B ~ `@?@j@~ @I +?~ A{{{{{{{{{{ w6xQ9@ CY7yQ8@ !c  #Z B7zR5@ !c  #[ B7zQ3@ !c  #\ B7zq= ףp.@ H !c  #] B7zq= ף(@ !c  #^ B{ |9" }@X CC ~ ~ AQ?~  @~ [@|a2U0?~ A{{{{{{{{{{ w8x`h@( C y`h@(z`h@( z`h@(z`h@( z`h@( { |; {~  A@@@~ hAS:?~ k{{{{{{{{{{ w:xyf@(C9yyf@( zyf@(zyf@(zyf@(zyf@({ |=" }@  C;Cm ~ AA@@~ 2Aҿ?~ {{{{{{{{{{ w<xfffffE@(a C5yfffffE@(zfffffE@(zfffffE@(zfffffE@(zfffffE@({ |?" }@ C;Cn ~ ~ AAMbX?~ `A~ ƨ! Q?~ g{{{{{{{{{{ z(CJz(z(z(z(z(Z { |A" }[@ ! C;Co ~~ .A}гY?~ qfA{{{{{{{{{{ >z@ ` D zZ@ D z@ b D zʢ@ D z:@  D z@@  D { |C" }/@ " C;Cp ~~ Yb}гY?~ qfA{{{{{{{{{{ @z@ D zZ@ D z@ e D zʢ@ D z:@ 3 D z@@  D { |E" }@ # C;Cq ~  {  {  { {*{{{{{{{{{{{{{{ Bz@(D z@(z@(z@( z@(z@({ |F" }`@ $ C;Cr ~  { @s@ { {{{ I"{{{{{{{{{{{ D@(D @(@( @( @(@({{{~  { @ { {{{   {{{{{{{{{{{ {{{{{{{{ |H  {}  { { {{{~ I +?~ {{{{{{{{{{ p{ G{{{{{ |J" }(@  CC }  { @ { {{{~ @I +?~ @{{{{{{{{{{ Do,l 4hgVL-}pv{ !8!!8"!8#!8$!8%!8&!8'!8(!8)!8*!8+!8,!8-!8.!8/!80!81!;@2!83!84!85!86!87!88!89!8:!8;!8<!8=!8>!8?!8 p {{{{{{{ |K" }@  D C } { @ { {{{~  @ I +?~ @ {{{{{{{{{{ !p!{{{{{{{ !|L"! }f@ D C! } ! {! #@@ !{ !{{{~ !@ @!L7A`?~ !_A!{{{{{{{{{{ "p"{{{{{{{ "|M"" }:@c D C" } " {" @s@ "{ "{{{~ "@"I +?~ "A"{{{{{{{{{{ #q#{|{{{{{ #|N"# }@d D C# } # {# ?@ #{ #{{{~ #[@#|a2U0?~ #A#{{{{{{{{{{ $q{|{{{{{ $|O"$ }k@ D C$ } $ {$ @@ ${ ${{{~ $h A$S:?~ $4${{{{{{{{{{ %rQ%{{{{{{{{{} % {%  @@ %{ %{{{~ %2$A%ҿ?~ %3%{{{{{{{{{{ &s{{{{{{{ &|P & {} & {& @s@ &{ &{{{~ &.A& Q?~ &3&{{{{{{{{{{ 't'{{{{{{{ '|R}' }@? gcS cH b%c(#*bf5cM c(#)bf "B' } ' {' ?s@ '{ '{{{~ 'QC'}гY?~ ''{{{{{{{{{{ (s({ ({({{{{{ (|S}( }@@ gcS cH b%d #*bf5cM d #)bf "B( { ( {( @s@ ({ ({{{~ (Yb(}гY?~ (({{{{{{{{{{ )t{ ){){{{{{ )|T}) }@A gcS cH b%d! #*bf5cM d! #)bf "B) { ) {) @ ){ *){{{{{{{{{{{{{ *u*{{{{{{{ *|U}* }@B gcS cH b%d" #*bf5cM d" #)bf "B* } * {* @ *{ *{{{ *X"*{{{{{{{{{{ +s+{{{{{{{ +|V}+ }@C gcS cH b%d# #*bf5cM d# #)bf "B+ } + {+ @m@ +{ +{{{ + + ++{{{{{{{{{{ ,s,{ ,{,{{{{{ ,|W}, }@D gcS cH b%d$ #*bf5cM d$ #)bf "B, { , {, @m@ ,{ ,{{{~ ,,I +?~ ,,{{{{{{{{{{ -s-{{{{{{{{{} - {- @s@ -{ -{{{~ -@@-I +?~ -@-{{{{{{{{{{ .p.{{{{{{{ .|Y . {} . {. @s@ .{ .{{{~ . @.I +?~ .@.{{{{{{{{{{ /p/{{{{{{{ /|Z}/ }333333?7 gcS cH b%c(#*bf5cM c(#)bf "B/ } / {/ &@s@ /{ /{{{~ /@/L7A`?~ /@/{{{{{{{{{{ 0s0{{{{{{{ 0|[}0 }333333?8 gcS cH b%d #*bf5cM d #)bf "B0 } 0 {0 Q?~ 0 s@ 0{ 0{{{~ 0_@0I +?~ 0A0{{{{{{{{{{ 1p{{{{{{{ 1|\}1 }333333?9 gcS cH b%d! #*bf5cM d! #)bf "B1 } 1 {1 &@s@ 1{ 1{{{~ 1P@1|a2U0?~ 1A1{{{{{{{{{{ 2t2{{{{{{{ 2|]}2 }333333?y gcS cH b%d" #*bf5cM d" #)bf "B2 } 2 {2 &@s@ 2{ 2{{{~ 2hA2S:?~ 2J2{{{{{{{{{{ 3p3{{{{{{{ 3|^}3 }333333?+ gcS cH b%d# #*bf5cM d# #)bf "B3 { 3 {3 &@s@ 3{ 3{{{~ 3LwA3ҿ?~ 3/(3{{{{{{{{{{ 4s{{{{{{{ 4|_}4 }333333?< gcS cH b%d$ #*bf5cM d$ #)bf "B4 { 4 {4 &@s@ 4{ 4{{{~ 4-4 Q?4G&n@4{{{{{{{{{{ 5t5{{{{{{{{{} 5 {5 &@s@ 5{ 5{{{~ 5.A5}гY?~ 545{{{{{{{{{{ 6p{{{{{{{ 6|` 6 {} 6 {6 &@s@ 6{ 6{{{~ 6Yb6}гY?~ 646{{{{{{{{{{ 7t 7{{{{{{{ 7|a}7 }$@' gcS cH b%c(#*bf5cM c(#)bf "B7 } 7 {7 &@s@ 7{*7{{{{{{{{{{{{{ 8t{{{{{{{ 8|b}8 }$@* gcS cH b%d #*bf5cM d #)bf "B8 } 8 {8 &@s@ 8{ 8{{{ 8"8{{{{{{{{{{ 9t 9{{{{{{{ 9|c}9 }$@) gcS cH b%d! #*bf5cM d! #)bf "B9 } 9 {9 &@s@ 9{ 9{{{ 9f 9g 9{{{{{{{{{{ :t{{{{{{{ :|d}: }$@2 gcS cH b%d" #*bf5cM d" #)bf "B: } : {: &@s@ :{ :{{{ :i:?@ :j:{{{{{{{{{{ ;t ;{{{{{{{ ;|e}; }$@, gcS cH b%d# #*bf5cM d# #)bf "B; { ; {; "@ ;{ ;{{{ ;;~@~@~@ ;|k;{{{{{{{{{ <t <{{{{{{{ <|h}< }$@/ gcS cH b%d$ #*bf5cM d$ #)bf "B< { < {< @s@ <{ <{{{ <m<~@~@~@ <|k<{{{{{{{{{ =p{{{{{{{{{} = {= &@s@ ={ *={{{{{{{{{{{{{ >t >{{{{{{{ >|l > {} > {> &@s@ >{*>{{{{{{{{{{{{{{ ?p?{{{{{{{ ?|n"? }@( C(C? } ? {? &@s@ ?{*?{{{{{{{{{{{{{{ D$lQe)5MeQ[EQQI)AK[[@!8A!8B!8C!8D!8E!8F!8G!8H!8I!8J!8K!8L!8M!8N!8O! P Q R S T U V W X Y Z [ \ ] ^ _  @p@{{{{{{{ @|o"@ }p@0 D D( @ } @ {@ &@s@ @{ *@{{{{{{{{{{{{{{ Ap{{{{{{{ A|p"A }@s D! D) A } A {A &@s@ A{*A{{{{{{{{{{{{{{ BtB{|{{{{{ B|q"B }@: D" D* B } B {B @s@ B{ *B{{{{{{{{{{{{{{ CpC{{{{{{{ C|r"C }@; D# D+ C { C {C &@s@ C{ *C{{{{{{{{{{{{{{ DpD{{{{{{{ D|s"D }"@4 D$ D, D { D {D &@s@ D{*D{{{{{{{{{{{{{{ Ep{{{{{{{{{} E {E &@s@ E{ *E{{{{{{{{{{{{{{ FtF{{{{{{{ F|t F {} F {F +@s@ F{*F{{{{{{{{{{{{{{ GpG{{{{{{{ G|u.G }@@O CC CAG } G {G &@s@ G{ *G{{{{{{{{{{{{{{ HpH{{{{{{{ H|v.H }@P D8 D@ CAH } H {H $@s@ H{ *H{{{{{{{{{{{{{{ Ip{{{{{{{ I|w.I }$@Q D9 DA CAI } I {I I{ *I{{{{{{{{{{{{{{ JtJ{{{{{{{ J|x.J }@R D: DB CAJ } J {J J{ *J{{{{{{{{{{{{{{ KpK{{{{{{{ K|y.K }@S D; DC CAK { K {K @s@ K{ *K{{{{{{{{{{{{{{ LpL{{{{{{{ L|z.L }*@T D< DD CAL { L {L  @@ L{ *L{{{{{{{{{{{{{{ Mp{{{{{{{{{} M {M $@@ M{ *M{{{{{{{{{{{{{{ NvN{{{{{{{ N|{ N {} N {N  @@ N{ *N{{{{{{{{{{{{{{ O<|'O =Qq@C!C;AO = O O U&@Vs@ O P<}'P =Qq@L DH C;AP = P P U&@Vs@ P Q<~'Q =Qp@J DI C;AQ = Q Q U$@V@ Q R<'R =q= ףPn@ DJ C;AR = R R U$@V@ R SP S<'S =q= ףj@I DK C;A S S U$@V@ S T<'T =q= ף8h@K DL C;A T T U$@V@ T U = U U U$@V@ U VP V<V = V V U$@V@ V W<W =p@[ caS  #2caM c_ b$ #0[caM c_ b$ #1/caH  #/i@"""BW = W W U @V@ W X<"X =Y CVCBX = X X U$@V@ X Y<Y =@W caS  #NcaM c_ b$ #LUcaM c_ b$ #M)caH  #G """BY = Y Y U"@Vs@ Y Z<=Z =Y_@] 'D S D  B$ $;D S D  B$ $;D S D  B$ $;D M D  B$ $<~D M D H B$D  B% $<DD M D H B$D  B% $< """""BZ = Z Z U$@V@ Z [<;[ =\ %c_ c_B [  [ U @V@ [ \<:\ =Y_@ $caS  #l #hB \  \ U@V \ ]<)] =Y_@ CvCxCy] = ]  ] U$@V@ ] ^<== ^  ^ U @V@ ^ _<_ = _  _ U$@Vs@ _Dluuuuuk<Tp~wB` a b c d e f g h i j k l m n o p q r s t u v w x y z { | } ~   `<]` =@ GC;CmCCF C;CmCCFB` = ` ` U @V@ ` a<]a =d@ GC;CnCCF C;CnCCFBa = a a U"@Vs@ abP b<]b =8@GC;CoCCF C;CoCCFBb = b b U"@Vs@ b c<]c = @GC;CpCCF C;CpCCFB c c U@Vs@ c d<]d =@GC;CqCCF C;CqCCFB d d U"@Vs@ d eP e<]e ==@GC;CrCCF C;CrCCFBe = e e U"@V@ e f = f f U @V@ f g<g = g g U @V@ g h<h =@ caS c`#cbf`caM c`#bbf5caH c`#dbf ""Bh = h h U@V@ h i<i =@ caS da #cbf`caM da #bbf5caH da #dbf ""Bi = i i U&@Vs@ i j<j =@ caS db #cbf`caM db #bbf5caH db #dbf ""Bj = j j U @Vm@ j k<k =@ caS dc #cbf`caM dc #bbf5caH dc #dbf ""B k k U @Vm@ k l<l =@ caS dd #cbf`caM dd #bbf5caH dd #dbf ""B l l U?Vs@ l m<m =@ caS de #cbf`caM de #bbf5caH de #dbf ""B m m U@Vm@ m n n U*@Vm@ n o<o = o o U @V@ o p<p =I +?x caS c`#cbf`caM c`#bbf5caH c`#dbf ""Bp = p p U @Vm@ p q<q =I +?i caS da #cbf`caM da #bbf5caH da #dbf ""Bq = q q U*@V@ q r<r =I +?G caS db #cbf`caM db #bbf5caH db #dbf ""Br = r  r U*@V@ r s<s =I +?{ caS dc #cbf`caM dc #bbf5caH dc #dbf ""Bs = s !s U*@V@ s t<t =I +?| caS dd #cbf`caM dd #bbf5caH dd #dbf ""Bt = t "t U*@V@ t u<u =I +?} caS de #cbf`caM de #bbf5caH de #dbf ""Bu = u #u U*@V@ u v $v U*@V@ v w<w = w %w U&@V w x<x =Qf@h caS c`#cbf`caM c`#bbf5caH c`#dbf ""Bx = x &x U&@V x y<y =Qf@q caS da #cbf`caM da #bbf5caH da #dbf ""By = y 'y U @V@ y z<z =Qf@j caS db #cbf`caM db #bbf5caH db #dbf ""Bz = z (z U @V@ z {<{ =Qf@k caS dc #cbf`caM dc #bbf5caH dc #dbf ""B{ = { ){ U&@V@ { |<| =Qf@m caS dd #cbf`caM dd #bbf5caH dd #dbf ""B| = | *| U*@V@ | }<} =Qf@p caS de #cbf`caM de #bbf5caH de #dbf ""B } +} U @Vm@ } ~ ,~ U @Vm@ ~ < =  - U @Vm@ Dl<J2J2J2                                 <" =@1 C`CD = . U @Vm@  <" =@l Da Di  = / U*@V@  <" =Q@r Db Dj  = 0 U*@V@  <" =@z Dc Dk  = 1 U?V@  <" =@t Dd Dl  = 2 U*@V@  <" =@u De Dm  3 U&@V  4 U$@V@  < = 5 U*@V@  <. =K7z@ CECUCOA = 6 U&@V  <. =ty@ Dy D CPA = 7 U"@Vs@  <. =V-3x@ Dz D CQA = 8 U@V  <. =K7v@ D{ D CRA = 9 U@Vs@  <. =#~j@s@ D| D CSA = : U@V@  <. =#~j0q@ D} D CTA ; U@V  < U @V@  < = = U@Vs@  < =Q9@wCmC;C. CWCwC; B%@CWCwC; CWCwC;A"B = > U@V  < =Q8@wCnC;C. D CwC; B%@D CwC; D CwC;A"B = ? U&@Vs@  < =R5@wCoC;C. D CwC; B%@D CwC; D CwC;A"B = @ U"@V@  < =Q3@wCpC;C. D CwC; B%@D CwC; D CwC;A"B = A U @V@  < =q= ףp.@wCqC;C. D CwC; B%@D CwC; D CwC;A"B = B U @V@  < =q= ף(@wCrC;C. D CwC; B%@D CwC; D CwC;A"B C U@Vs@  D U@V   = E U@V   = F U@V   = G U"@V@   = H U"@V@   = I U@V@   = J UQ?~ Vs@  K U @V@  L U&@Vs@  = M U&@Vs@  DHlpppppf2J|||||r2J2<<<<<F22                                                                 = N U @V@   =  U@V@   = O U@V   = P U@V   = Q U$@V@  R U@V  S U @V@   = T U$@V@   = U U$@V@   = V U@V   = W UV   = X U @Vm@   = Y UVm@  Z UVm@  [ U @Vm@  \ U @Vm@  ] U*@V@  ^ U @V@  _ U @V@  ` U @V@  a U@V@  b U*@V@  c U*@V@  d U*@V@  e U*@V@  f U*@V@  g U*@V@  h U*@V@  i U*@V@  j U*@V@  k U@V@  l U@V@  D. l<<<<<22<<<<<<222222222222222222                                                                 m U@V@  n U@V@  o U*@V@  p U&@V@  q U*@V@  r U&@V@  s U'@V@  t U'@V@  u U @Vm@  v U @Vm@  w U?Vs@  x U?Vs@  y U&@Vs@  z U&@Vs@  { U&@Vs@  | UQ?~ Vs@  } U&@Vs@  ~ U&@Vs@   U @V@   U'@V@   U$@Vs@   U$@Vs@   U&@Vs@   U&@Vs@   U+@Vs@   U@Vs@   U@Vs@   UVm@   U @Vm@   UVm@   U @Vm@   UV Dl222222222222222<222222222222222                                                                  U@V   U?Vs@   U@V@   U@V   U@V   U"@Vs@   U@V   UV@   U"@V@   U"@V@   U"@V@   U@V   U&@Vs@   U&@Vs@   U$@V@   U&@Vs@   U&@Vs@   U@V@   U$@V@   U$@V@   U"@V@   U"@V@   U"@Vs@   U$@Vs@   U$@Vs@   U$@Vs@   U"@V@   U"@V@   U @V@   U$@V@   U$@V@   U$@V@  Dl2222222222222222222222222222222                                                                        U@V@    U?V@    U$@V@    U$@V@    U$@V@    U$@V@    U$@V@    U@V@    U$@V@     U?V@     U$@V@     U$@V@     U$@V@     U @V@    U @V@    U"@V@    U"@V@    U @V@    U"@V@    U?V@    U"@V@    U"@V@    U @V@    U#@V@    U @V    U?V    U?V    UV    U0@V    U0@V    U @V    UV Dl2222222222222222222222222222222   !  "  #  $  %  &  '  (  )  *  +  ,  -  .  /  0  1  2  3  4  5  6  7  8  9  :  ;  <  =  >  ?      UV  ! ! UV ! " " UV " # # UV # $ $ UV $ % % U @V % & & U@V & ' ' U @V ' ( ( UV ( ) ) UV ) * * UV * + + UV + , , UV , - - U @V - . . U$@V . / / U'?~ / V / 0 0 U@V 0 1 1 U"@V@ 1 2 2 U"@V@ 2 3 3 U"@V@ 3 4 4 U"@V@ 4 5 5 U @V@ 5 6 6 U @V@ 6 7 7 U@V@ 7 8 8 U@V 8 9 9 U@V@ 9 : : U#@V@ : ; ; U@V@ ; < < U"@V@ < = = U@V = > > U@V > ? ? U@V@ ? Dl222222222222222<222222222222222>@dVR 7 Sheet1gg@   !"#$Oh+'0 `h8P` x 8Paycheck Calculator - Tax Rate - Semi-monthly Version,Paycheck Calculator - Semi-monthly VersionLockhart, Jeff L.8Paycheck Calculator - Tax Rate - Semi-monthly VersionRevised 8/22/06IITSMicrosoft Excel@X@@ E՜.+,D՜.+,` PX  4Check Calculator - Tax Rate - Semi-monthly Version {Paycheck Calculator - CA 2018 ADDALLOWCATDCA1DCA2DCA3DCA4DCA5DCA6DED1DED3DED4EPMCEPMC_EPMC2EPMCDFAN1FBSA1FBST1FEDEFEDERALFEDEXM FEDEXMPTFEDM Flex_CashFMTR1FMTR2FMTR3FMTR4FMTR5FMTR6FOVR1FTA1FTAX1FTAX2FTAX3FTAX4FTAX5FTAX6FTG1FTXTBLM FTXTBLSHGROSS INSTRUCTIONSITLIELIEHLIEM1LIEM2LIESMACROSMD_MEDMED_OA_OACOASDIOASDI_PAYFACTPER1PER2PER3PER4+'Paycheck Calculator - CA 2018'!Print_Area RETID_TABLESADDALL SafetyCheckSBSA1SBST1SDEDSDHSDI SDI_RATESDI1SDIGRSSDM1SDM2SDSSMTR1SMTR2SMTR3SMTR4SMTR5SMTR6SOVR1STASTA1STATESTAX1STAX2STAX3STAX4STAX5STAX6STESTG1STMSTXTBLMSTXTBLS STXTBLUHTCRM0TCRM1TCRM2TCRMRTCRS0TCRS1TCRS2TCRSRTG1TG2TG3TG4TG5TG6TIERTotal_A_R_Deductions Total_FlexTXCRB TXCREDITTXCROV2TXCRRVOLDEDSWORK  Worksheets Named Rangesz :B_PID_LINKBASEAlhttp://www.sco.ca.gov/ppsd/empinfo/calc/paycalc/shtml