Hi,
I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart);
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
</tbody>
What I would like to do is at the closing of the day when entering the total deliveries the cumulative amount to populate in the incentive column of my sheet.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
<tbody>
</tbody>
when entering the amount of 22 or any other total in the total deliveries I would like to have driver incentive auto calculate based on the cumulative incentives in the payout info.
I have a delivery company and want to create an incentive tracking sheet. My drivers will start accumulating fixed commissions after a certain number of deliveries (below chart);
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
| Driver Incentive # of Orders | Commission per order | Payout |
| 10 | AED1.00 | AED1.00 |
| 11 | AED2.00 | AED3.00 |
| 12 | AED3.00 | AED6.00 |
| 13 | AED4.00 | AED10.00 |
| 14 | AED5.00 | AED15.00 |
| 15 | AED6.00 | AED21.00 |
| 16 | AED7.00 | AED28.00 |
| 17 | AED8.00 | AED36.00 |
| 18 | AED9.00 | AED45.00 |
| 19 | AED10.00 | AED55.00 |
| 20 | AED10.00 | AED65.00 |
| 21 | AED10.00 | AED75.00 |
| 22 | AED10.00 | AED85.00 |
| 23 | AED10.00 | AED95.00 |
| 24 | AED10.00 | AED105.00 |
| 25 | AED10.00 | AED115.00 |
<tbody>
</tbody>
What I would like to do is at the closing of the day when entering the total deliveries the cumulative amount to populate in the incentive column of my sheet.
<style type="text/css"><!--td {border: 1px solid #ccc;}br {mso-data-placement:same-cell;}--></style>
| Driver | Driver ID | Location | Date | Total Deliveries | Eligibale for incentive | Driver Incentive |
| Nadir Rafique | 1096 | Dubai | 01/05/2018 | 22 | yes | 85 |
<tbody>
</tbody>
when entering the amount of 22 or any other total in the total deliveries I would like to have driver incentive auto calculate based on the cumulative incentives in the payout info.
