• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Demurrage Calculation

how to Auto calculate Demurrage in Excel as per attached Tariff

No, of Free Days

20ft & 40ft Dry - 8 days / some time will change the free days
20 ft & 40 ft Reefer - 5 days

days Calculation Period

Dry 20 ft & 40ft - from 9th day to 13th - KWD 5.000 & KWD10.000
Dry 20 ft & 40ft - from 14th day to 18th - KWD 10.000 & KWD20.000
Dry 20 ft & 40ft - from 19th day to Onwards - KWD 20.000 & KWD40.000
Reefer 20 ft & 40 ft - From 6th to 8th - KWD 20.000 & KWD40.000
Reefer 20 ft & 40 ft - From 9th to 13th - KWD 40.000 & KWD80.000
Reefer 20 ft & 40 ft - From 14th to Onwards - KWD 80.000 & KWD160.000
 

Attachments

  • KUWAIT Tariff file.xlsx
    49.5 KB · Views: 38
For me this was a pretty heavy programming effort … and I had to restructure the tables so that I could look up data by period.
Maybe someone else will achieve something simpler.
 

Attachments

  • KUWAIT Tarif file (pb).xlsx
    53.5 KB · Views: 28
Thanks for your prompt reply, can you input the formula in my attached file as per the below tariff.

Dry 20 ft & 40ft - from 9th day to 13th - KWD 5.000 & KWD10.000
Dry 20 ft & 40ft - from 14th day to 18th - KWD 10.000 & KWD20.000
Dry 20 ft & 40ft - from 19th day to Onwards - KWD 20.000 & KWD40.000
Reefer 20 ft & 40 ft - From 6th to 8th - KWD 20.000 & KWD40.000
Reefer 20 ft & 40 ft - From 9th to 13th - KWD 40.000 & KWD80.000
Reefer 20 ft & 40 ft - From 14th to Onwards - KWD 80.000 & KWD160.000
 

Attachments

  • DEMURRAGE CALCULATION.xlsx
    10.9 KB · Views: 38
Not as it stands. However, since you are not interested in seeing the accumulation of charges over time (table at top of original sheet) it should be possible to change tack and lookup the charges accumulated to the start of each period block at the same time as looking up the ongoing daily charge.
 
An interesting challenge but to be honest I am not sure the workbook will be of value to you in that the principles I used in its construction are somewhat unusual.
 

Attachments

  • DEMURRAGE CALCULATION (PB).xlsx
    18.6 KB · Views: 49
Back
Top