Spreadsheet: 798426d1664469391-if-and-formula-payroll-analytics-test
Sheet: Summary

2022-05-31 00:00:00 |  |  | 2022-05-01 00:00:00
New Hires Added |  | 2022-04-15 00:00:00 | 2022-05-15 00:00:00
April 2022 |  | 2022-04-16 00:00:00 | 2022-05-16 00:00:00
 |  | 2022-04-30 00:00:00 | 2022-05-31 00:00:00
Change in Comp
Employee number | Employee | Change | Reason | Old value - Currency | Old value | Old value - Compensation time period | New value - Currency | New value | New value - Compensation time period | Effective date | Employment Type | Department | Uplift | Payroll Start | Payroll End | New Formula to Use
1 | [NAME] | Compensation | Market adjustment | USD | 205000 | YEAR | USD | 220000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Engineering
2 | [NAME] | Compensation | Market adjustment | USD | 159600 | YEAR | USD | 180000 | YEAR | 2022-04-01 00:00:00 | Salaried, full-time | Marketing
10 | [NAME] | Compensation | Retention | USD | 156000 | YEAR | USD | 180000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Engineering - Production Engineering
35 | [NAME] | Compensation | Market adjustment | USD | 24.77 | HOUR | USD | 26.45 | HOUR | 2022-04-16 00:00:00 | Hourly, full-time | Customer Experience
52 | [NAME] | Compensation | Market adjustment | USD | 62400 | YEAR | USD | 69700 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Customer Experience
54 | [NAME] | Compensation | Employment status change | USD | 30.3 | HOUR | USD | 69000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Customer Experience
64 | [NAME] | Compensation | Market adjustment | USD | 25.25 | HOUR | USD | 26.45 | HOUR | 2022-04-01 00:00:00 | Hourly, full-time | Customer Experience
65 | [NAME] | Compensation | Market adjustment | USD | 68003.2 | YEAR | USD | 71000 | YEAR | 2022-04-01 00:00:00 | Salaried, full-time | Customer Experience
87 | [NAME] | Compensation | Market adjustment | USD | 30.3 | HOUR | USD | 31.74 | HOUR | 2022-04-01 00:00:00 | Hourly, full-time | Customer Experience
100 | [NAME] | Compensation | Market adjustment | USD | 62400 | YEAR | USD | 72000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Customer Experience
106 | [NAME] | Compensation | Employment type change | USD | 64050 | YEAR | USD | 74000 | YEAR | 2022-04-04 00:00:00 | Salaried, full-time | Customer Experience
107 | [NAME] | Compensation | Market adjustment | USD | 25.25 | HOUR | USD | 26.21 | HOUR | 2022-04-01 00:00:00 | Hourly, full-time | Customer Experience
114 | [NAME] | Compensation | Market adjustment | USD | 25.25 | HOUR | USD | 26.45 | HOUR | 2022-04-01 00:00:00 | Hourly, full-time | Customer Experience
155 | [NAME] | Compensation | Employment type change | USD | 27.76 | HOUR | USD | 29.33 | HOUR | 2022-04-25 00:00:00 | Hourly, full-time | Customer Experience
246 | [NAME] | Compensation | Market adjustment | USD | 106650 | YEAR | USD | 118000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Engineering
297 | [NAME] | Compensation | Market adjustment | USD | 113300 | YEAR | USD | 116300 | YEAR | 2022-04-01 00:00:00 | Salaried, full-time | Marketing
312 | Charne Morris | Compensation | Market adjustment | USD | 125000 | YEAR | USD | 128000 | YEAR | 2022-04-01 00:00:00 | Salaried, full-time | Customer Experience
323 | [NAME] | Compensation | Market adjustment | USD | 87000 | YEAR | USD | 95000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Engineering
360 | [NAME] | Compensation | Market adjustment | USD | 95000 | YEAR | USD | 97000 | YEAR | 2022-04-16 00:00:00 | Salaried, full-time | Engineering