Advanced Pay Prediction Excel Calendar
Budget: $30 – $250 CAD
Create an Excel calendar, for Mac, that can predict and log as I go bi/weekly and annual gross pay. Main purpose is to fill in the calendar as work is done to be able to predict upcoming pay checks. Simplified for use. I’m open to input
- Each year to be its own sheet, 10 years
- Summary Sheet
- Track a rotating work schedule
- Pre-populated to predict bi weekly and annual pay
- Ability to track pay by manually imputing as the year progresses
- Multiple pay types (18), multiple pay variations from the types (19 or more)
- Each pay variation to have a specific representation for easy data entry
- Pay rate changes % every 01 Feb, and base rate can change when pay rate is renegotiated
Pay
1- Base per/hr
2- Day shift, 12hrs base
3- Night shift, 12hrs base
4- Overtime, 2x base
5- Bonus
6- Annual pay increase, % 01 Feb each year
7- Dayshift premium
8- Nightshift premium
9- Shift turn over pay, 37.5% 1hr base pay
10- Sick day, 12hrs base pay
11- Differed Statutory holiday pay, 8hrs base pay
12- Statutory holiday pay, 8hrs base pay
13- Vacation pay, 12 hrs base pay
14- Assignment pay, undetermined hrs base pay plus 5%
15- Assignment pay, undetermined hrs base pay plus 10%
16- Floating holiday, 8hrs base pay
17- Off Days, no pay
18- Bank pay, 12hrs base pay
19- Meal allowance
Pay Variations
1- Off days, no pay
2- base pay, 8hr, 8.5hrs, 9hrs, 9.5hrs
3- Base pay overtime undetermined hours, hours worked can vary
4- Day shift, day shift premium
5- Day shift overtime, day shift premium
6- Day shift, shift turn over pay, day shift premium
7- Day shift overtime, shift turn over pay, day shift premium
8- Day shift overtime, shift turn over pay, day shift premium, statutory holiday pay
9- Night shift, night shift premium
10- Night shift overtime, night shift premium
11- Night shift, shift turn over pay, night shift premium
12- Night shift overtime, shift turn over pay, night shift premium
13- Vacation pay
14- Floating holiday pay
15- Bonus
16- Differed Statutory holiday pay
17- Bank pay
18- Assignment pay 5%
19- Assignment pay 10%
- Each year to be its own sheet, 10 years
- Summary Sheet
- Track a rotating work schedule
- Pre-populated to predict bi weekly and annual pay
- Ability to track pay by manually imputing as the year progresses
- Multiple pay types (18), multiple pay variations from the types (19 or more)
- Each pay variation to have a specific representation for easy data entry
- Pay rate changes % every 01 Feb, and base rate can change when pay rate is renegotiated
Pay
1- Base per/hr
2- Day shift, 12hrs base
3- Night shift, 12hrs base
4- Overtime, 2x base
5- Bonus
6- Annual pay increase, % 01 Feb each year
7- Dayshift premium
8- Nightshift premium
9- Shift turn over pay, 37.5% 1hr base pay
10- Sick day, 12hrs base pay
11- Differed Statutory holiday pay, 8hrs base pay
12- Statutory holiday pay, 8hrs base pay
13- Vacation pay, 12 hrs base pay
14- Assignment pay, undetermined hrs base pay plus 5%
15- Assignment pay, undetermined hrs base pay plus 10%
16- Floating holiday, 8hrs base pay
17- Off Days, no pay
18- Bank pay, 12hrs base pay
19- Meal allowance
Pay Variations
1- Off days, no pay
2- base pay, 8hr, 8.5hrs, 9hrs, 9.5hrs
3- Base pay overtime undetermined hours, hours worked can vary
4- Day shift, day shift premium
5- Day shift overtime, day shift premium
6- Day shift, shift turn over pay, day shift premium
7- Day shift overtime, shift turn over pay, day shift premium
8- Day shift overtime, shift turn over pay, day shift premium, statutory holiday pay
9- Night shift, night shift premium
10- Night shift overtime, night shift premium
11- Night shift, shift turn over pay, night shift premium
12- Night shift overtime, shift turn over pay, night shift premium
13- Vacation pay
14- Floating holiday pay
15- Bonus
16- Differed Statutory holiday pay
17- Bank pay
18- Assignment pay 5%
19- Assignment pay 10%