PPE 04 02 2005 Staff Mbr 00000xxxxxx C Gomer Homer Empl Grp LSP Wk St 2 Wk Pt 5 40 SUN AC N Cmnt N St C Vac ETO 999 9 Sck ESL 999 9 LB FH 0 BAH MIL RN DATE by mlz56749

VIEWS: 42 PAGES: 2

More Info
									PPE: 04-02-2005 Staff Mbr #: 00000xxxxxx C Gomer, Homer
Empl Grp: LSP Wk St: 2 Wk Pt: 5/40-SUN        AC: N Cmnt: N St: C
Vac/ETO: 999.9 Sck/ESL: 999.9 LB/FH: 0 BAH:        MIL:   RN:

  DATE         IN        OUT       TOTAL       REG          1.5        2             2.5         EVSD     NTSD       TYP       ENLOC     CCTR     JOBCD
MO21            0752       1338       5.77       5.77                                                              WRK           01031     6415    058516
MO21            1338       1408       0.50       0.50                                                              WKL           01031     6415    058516
MO21            1436       1638       2.00       1.73         0.27                                                 WRK           01031     6415    058516
TU22            0800       1200       4.00       4.00                                                              WRK           01031     6415    058516
TU22            1200       1230       0.50       0.50                                                              WKL           01031     6415    058516
TU22            1300       1630       3.50       3.50                                                              WRK           01031     6415    058516
WE23            0800       1200       4.00       4.00                                                              WRK           01031     6415    058516
WE23            1200       1230       0.50       0.50                                                              WKL           01031     6415    058516
WE23            1300       1630       3.50       3.50                                                              WRK           01031     6415    058516
SA26            0708       1217       5.15       5.15                                                              WRK           01031     6415    058516
SA26            1217       1247       0.50       0.50                                                              WKL           01031     6415    058516
SA26            1312       1627       3.22       2.35         0.87                                                 WRK           01031     6415    058516
SU27            0717       1255       5.63       5.63                                                              WRK           01031     6415    058516
SU27            1255       1325       0.50       0.50                                                              WKL           01031     6415    058516
SU27            1348       1556       2.20       1.87         0.33                                                 WRK           01031     6415    058516
MO28            1422       2302       8.63       8.00         0.63                                 8.63            WRK           01031     6415    058516
TU29            0800       1200       4.00       1.63         2.37                                                 WRK           01031     6415    058516
TU29            1200       1230       0.50       0.50                                                              WKL           01031     6415    058516
TU29            1300       1630       3.50       3.50                                                              WRK           01031     6415    058516
WE30            0800       1200       4.00       4.00                                                              WRK           01031     6415    058516
WE30            1200       1230       0.50       0.50                                                              WKL           01031     6415    058516
WE30            1300       1630       3.50       3.50                                                              WRK           01031     6415    058516




                                       0.00          0.00     0.00
                                      66.10         61.63     4.47         0.00            0.0      8.6      0.0

                                                                                                                                                                 Pay
  Month = 04                Day = 02             Year = 2005                     PPE =            38444 $ 2.25       3/20/05                                Reg          $3,164.70
                       1st match     pre       lunch       post    other/4th Rereg w/ ED         Reg     Reg ED       OT       OT ED     sum       type     Reg ED          $18.00
0         SU20                  0         0           0          0         0          0                0       0           0         0                      OT            $344.30
1         MO21                  6      5.77         0.5          2         0          8                8       0        0.27         0     8.27     WRK     OT ED            $2.13
2         TU22                  9         4         0.5        3.5         0          8                8       0           0         0     8.00     WRK     Missed           $0.00
3         WE23                 12         4         0.5        3.5         0          8                8       0           0         0     8.00     WRK     PTO              $0.00
4         TH24                  0         0           0          0         0          0                0       0           0         0                      Hol              $0.00
5         FR25                  0         0           0          0         0          0                0       0           0         0                                   $3,529.13
6         SA26                 15      5.15         0.5      3.22          0          8                8       0        0.87         0     8.87     WRK     Flex Cred       $59.13
7         SU27                 18      5.63         0.5        2.2         0          8                8       0        0.33         0     8.33     WRK     Flex Benefit   -$64.88
8         MO28                 21      8.63           0          0         0          8                0       8        0.63      0.63     8.63     WRK     GTL               5.31
9         TU29                 22         4         0.5        3.5         0       5.63             5.63       0        2.37         0     8.00     WRK                  $3,528.69
10        WE30                 25         4         0.5        3.5         0          8                8       0           0         0     8.00     WRK
11        TH31                  0         0           0          0         0          0                0       0           0         0                       401K %=        30% $1,058.74
12        FR01                  0         0           0          0         0          0                0       0           0         0                             Pre-tax pay = $2,469.95
13        SA02                  0         0           0          0         0          0                0       0           0         0
                                                                                                   53.63       8        4.47      0.63     66.1
                                              PTO                 0               -PTO&Hol             0
            EVSD=          $2.25              HNO                 0                                61.63
            NTSD=          $5.50              HOL                 0
          Pay Rate=       $51.35                                             Retro
              HTR=         $0.00                                      Missed meal/break
1) I created this for myself. It's complicated and I make no apologies, nor do I accept any liability for it's use or misuse.
         Use it at your own risk. It's free and worth the asking price. If you don't like it or any aspect of it-DON'T USE IT. And don't tell me.

1) YOU CAN ONLY CHANGE STUFF IN RED, THE REST IS PROTECTED

2) Cell A1 has to start with "PPE: MM-DD-YYYY" with the date of the payperiod end. In this sample it's "04-02-2005"
         The rest of the row and the 2 following rows are irrelevant. I just copy & paste from timesheet.
         This value is used in the lower section to correlate upper section entries with specific payperiod days
         BUT WITHOUT THIS CORRECTLY ENTERED NOTHING ELSE WORKS!

3) In the upper section:
         I've included sample data so you can see how it works.
         I copy and paste from my timesheet off the time system.
         The columns headed: Date, In, Out Total, Reg, 1.5 (OT), 2 (DT), 2.5 (?), EVSD (Evening shift diff), NTSD (night diff), Typ
                   must be filled in. The other columns (like loc code) don't matter except for people working multiple locations.

4) In the lower section:
         One time only
                 You need to fill in your Hard To Recruit (HTR) differential if your location gets one.
                 You need to fill in your Flex Credits.
                 You need to fill in your Flex Benefit cost (total of all).
                 You need to fill in your GTL if you get it.
                 You need to fill in your 401K deduction in %.
         Each payperiod
                 You need to fill in any retro in the appropriate cell (Reg, OT, etc).
                 You need to fill in any missed meal or break penalties (total).

With this Excel sheet I'm able to balance my paycheck to the penny. If there's a difference I'm alerted to an incorrect coding.
        Be aware that "retro" entries don't show a line item on your paycheck. Often you can only identify them because the
        hours on the check stub don't match the hours on the timesheet printout.

I hope you find it useful.
        Howard Hertz, Pharm.D.
        Guild for Professional Pharmacists
        Vice President & Chief steward for Kaiser Northern California

								
To top