Spreadsheet: 102357d1300304111-if-function-using-address-match-backup-sample-file-to-format
Sheet: YR2011

PERNR | Payment Date | Payment Rate |  | Wage Type Description | [NAME] | SumOfAmount
10011083 | 2010-01-14 00:00:00 |  |  | Commission Monthly | x | x
10011083 | 2011-01-14 00:00:00 |  |  | Holiday Pay ABBR | x | x
10011083 | 2011-01-14 00:00:00 |  |  | Regular Pay - Hourly | x | x
10011083 | 2011-01-14 00:00:00 |  |  | Training ABBR | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Commission Monthly | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Holiday OT | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Holiday Pay ABBR | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Holiday Premium | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Regular Pay - Hourly | x | x
10011083 | 2011-01-28 00:00:00 |  |  | Training ABBR | x | x
10011083 | 2011-02-11 00:00:00 |  |  | Commission Monthly | x | x
10011083 | 2011-02-11 00:00:00 |  |  | Flex Pay ABBR | x | x
10011083 | 2011-02-11 00:00:00 |  |  | Regular Pay - Hourly | x | x
10011083 | 2011-02-11 00:00:00 |  |  | Training ABBR | x | x
10011083 | 2011-02-25 00:00:00 |  |  | Regular Pay - Hourly | x | x
10011083 | 2011-02-25 00:00:00 |  |  | Special Pay | x | x
10011083 | 2011-02-25 00:00:00 |  |  | Training ABBR | x | x
10096433 | 2011-01-14 00:00:00 |  |  | Holiday Pay | x | x
10096433 | 2011-01-14 00:00:00 |  |  | Overtime Pay | x | x
10096433 | 2011-01-14 00:00:00 |  |  | Overtime Premium | x | x
10096433 | 2011-01-14 00:00:00 |  |  | Regular Pay - Hourly | x | x
10096433 | 2011-01-14 00:00:00 |  |  | Vacation Pay | x | x
10096433 | 2011-01-28 00:00:00 |  |  | Commission Monthly | x | x
10096433 | 2011-01-28 00:00:00 |  |  | Holiday Pay ABBR | x | x
10096433 | 2011-01-28 00:00:00 |  |  | Training ABBR | x | x
10096433 | 2011-01-28 00:00:00 |  |  | Training ABBR OT | x | x
10096433 | 2011-01-28 00:00:00 |  |  | Training ABBR OT Premium | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Afternoon Shift Diff | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Commission Monthly | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Flex Pay ABBR | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Overtime Pay | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Overtime Premium | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Regular Pay - Hourly | x | x
10096433 | 2011-02-11 00:00:00 |  |  | Training ABBR | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Afternoon Shift Diff | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Flex Pay ABBR | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Overtime Pay | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Overtime Premium | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Regular Pay - Hourly | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Training ABBR | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Training ABBR OT | x | x
10096433 | 2011-02-25 00:00:00 |  |  | Training ABBR OT Premium | x | x
10174210 | 1/14/2011 |  |  | Afternoon Shift Diff | x | x
10174210 | 1/14/2011 |  |  | Commissions | x | x
10174210 | 1/14/2011 |  |  | Flex Day | x | x
10174210 | 1/14/2011 |  |  | Floating Holiday | x | x
10174210 | 1/14/2011 |  |  | Holiday OT | x | x
10174210 | 1/14/2011 |  |  | Holiday Pay | x | x
10174210 | 1/14/2011 |  |  | Holiday Premium | x | x
10174210 | 1/14/2011 |  |  | Regular Pay - Hourly | x | x
10174210 | 1/28/2011 |  |  | Commission Monthly | x | x
10174210 | 1/28/2011 |  |  | Commissions | x | x
10174210 | 1/28/2011 |  |  | Holiday Pay | x | x
10174210 | 1/28/2011 |  |  | Overtime Pay | x | x
10174210 | 1/28/2011 |  |  | Overtime Premium | x | x
10174210 | 1/28/2011 |  |  | Regular Pay - Hourly | x | x
10174210 | 1/28/2011 |  |  | Vacation Pay | x | x
10174210 | 2/11/2011 |  |  | Award Day | x | x
10174210 | 2/11/2011 |  |  | Bonus Qtrl Frnt Ln Incntv | x | x
10174210 | 2/11/2011 |  |  | Commissions | x | x
10174210 | 2/11/2011 |  |  | Flex Day | x | x
10174210 | 2/11/2011 |  |  | Floating Holiday | x | x
10174210 | 2/11/2011 |  |  | Regular Pay - Hourly | x | x
10174210 | 2/11/2011 |  |  | Vacation Pay | x | x
10174210 | 2/25/2011 |  |  | Commissions | x | x
10174210 | 2/25/2011 |  |  | Overtime Pay | x | x
10174210 | 2/25/2011 |  |  | Overtime Premium | x | x
10174210 | 2/25/2011 |  |  | Regular Pay - Hourly | x | x
10174210 | 2/25/2011 |  |  | Vacation Pay | x | x