hello all,
I am trying to do a payroll spread sheet for transportation. The problem is that the pay scales are based on daily mileage, and thus rate of pay per mile, and delivery rate are affected.
This is the array I created for the pay values. The two columns on the left are the mileage ranges, the $per km column is the value I want to use for the mileage portion of the pay, to be entered in one cell of the spread sheet, and the value from the delivery row is to be multiplied by the value entered in the cell for number of delivery's.
from to $per km delivery
1 300 $0.32 $28.60
301 625 $0.29 $26.00
626 875 $0.27 $24.50
876 1100 $0.24 $23.00
This is the spread sheet that I will use
Day Of the week MON TUE WED THUR FRI SAT SUN
Zone
Kilometers
Drops
Deliveries
Single Store
Delay Time
Hourly
Shunting
Stat Holiday
Hours Worked
Daily Gross Income
For example, 345km and 6 deliveries will pay $256.05.
Lets use Monday for the example, when I enter 345 in the cell under Monday, it will look up the pay rate and multiply, and same for the Delivery rate. How ever I only want the total days earnings to show in the cell marked daily gross income under Monday.
All help greatly appreciated.
William
Bookmarks