Driver Commission Sheet using Google Maps Data(Google Sheets)
Budget: £10 – £20 GBP
This sheet is used to calculate the wages which includes commission for drivers.
I've included a screenshot of the sheet that I made myself to solve this problem. However the only problem right now is that the google maps service is being invoked too often. I need a solution where all the commission and wages is calculated once you press a button.
This involves making a function in the AppScript for the sheet and linking it to a button on the google sheet.
Commission:
- £1 for deliveries under 3.6 Miles
- £1.50 for deliveries 3.6 - 4.5 miles
- £2 for deliveries over 4.5 miles
£7 hourly base rates
If Driver is named "Caprinos"
Commission is slightly different:
- £3 for deliveries under 3.6 Miles
- £4 for deliveries 3.6 - 4.5 miles
- £5 for deliveries over 4.5 miles
No hourly base rates
I can share a link to the current google sheet if you need to review.
I've included a screenshot of the sheet that I made myself to solve this problem. However the only problem right now is that the google maps service is being invoked too often. I need a solution where all the commission and wages is calculated once you press a button.
This involves making a function in the AppScript for the sheet and linking it to a button on the google sheet.
Commission:
- £1 for deliveries under 3.6 Miles
- £1.50 for deliveries 3.6 - 4.5 miles
- £2 for deliveries over 4.5 miles
£7 hourly base rates
If Driver is named "Caprinos"
Commission is slightly different:
- £3 for deliveries under 3.6 Miles
- £4 for deliveries 3.6 - 4.5 miles
- £5 for deliveries over 4.5 miles
No hourly base rates
I can share a link to the current google sheet if you need to review.