Forum Discussion
Calculation of Truck Capacity Utilization
I am trying to calculate Truck Capacity Utilization & the cost we had to bear additionally for not utilizing the truck capacity. If the truck capacity is 25Mt & it carried more than 25Mt, it is 100%...
I assume the column 'Dispatch Qty' will hold the value for how much the truck carried.
Are you writing the text "25Mt" in that column? I suggest you only write the number 25 in the cell and add a custom number formatting to the cell to show 25Mt. Another option might be to change the column header to 'Dispatch Qty (in Mt)'
Now the calculation can be done using this formula:
=MIN(C2/25,100%)