Hello,
I'm trying to find a formula that can calculate the costs for the different transports in the example underneath.
The costs can be found in the table. There are different costs per day (for example from day 0 till 10 €0,- ; day 11 till 15 €2,- etc. This depends on the customer, Transporter and transporter. The last column has been added since it calculates the costs from the row before if applicable (15 days - 11 days)*2,- = 8,00
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Table
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you in advance.
I'm trying to find a formula that can calculate the costs for the different transports in the example underneath.
The costs can be found in the table. There are different costs per day (for example from day 0 till 10 €0,- ; day 11 till 15 €2,- etc. This depends on the customer, Transporter and transporter. The last column has been added since it calculates the costs from the row before if applicable (15 days - 11 days)*2,- = 8,00
Customer | Transporter | Truck | Days of transport | Costs |
A | Jans | 1' | 17 | ? |
A | Smith | 1' | 10 | ? |
B | Smith | 1' | 40 | ? |
B | A. Logistics | 2' Long | 20 | ? |
<colgroup><col><col><col><col><col></colgroup><tbody>
</tbody>
Table
Customer | Transporter | Container type | From days | Untill day | Costs per day | |
A | Jans | 1' | 0 | 10 | 0,00 | 0,00 |
A | Jans | 1' | 11 | 15 | 2,00 | 0,00 |
A | Jans | 1' | 16 | 1000 | 5,00 | 8,00 |
A | Jans | 2' | 0 | 10 | 0,00 | 0,00 |
A | Jans | 2' | 11 | 15 | 5,00 | 0,00 |
A | Jans | 2' | 16 | 1000 | 10,00 | 20,00 |
A | Smith | 1' | 0 | 5 | 0,00 | 0,00 |
A | Smith | 1' | 6 | 16 | 20,00 | 0,00 |
A | Smith | 1' | 17 | 10000 | 35,00 | 200,00 |
B | A. Logistics | 1' | 0 | 3 | 0,00 | 0,00 |
B | A. Logistics | 1' | 4 | 11 | 1,00 | 0,00 |
B | A. Logistics | 1' | 12 | 10000 | 5,00 | 7,00 |
B | A. Logistics | 2' Long | 0 | 3 | 0,00 | 0,00 |
B | A. Logistics | 2' Long | 4 | 11 | 14,00 | 0,00 |
B | A. Logistics | 2' Long | 12 | 10000 | 15,00 | 98,00 |
<colgroup><col><col><col><col><col><col><col></colgroup><tbody>
</tbody>
Thank you in advance.