hakim_tanzil
Board Regular
- Joined
- May 10, 2012
- Messages
- 56
- Office Version
- 2019
- 2016
- Platform
- Windows
Hi there,
Recently, I've been assigned to handle the tasks for the ship containers, in which I need a formula to calculate the estimation of the time arrival (ETA) based on the loading day
Here are some of my understanding that might help:
1. Every vessel has their own specific departure days (eg: Vessel A: Wed or Sun, Vessel B: Mon or Thur, Vessel C: Mon or Wed, etc)
2. The last day (or the so called closing day) for the terminal to accept all the containers is about 3 days prior departure (eg: if depart on Sun, the last day for the containers to be accepted at the terminal has to be on Thursday)
3. Let's assume once the vessel departed, it will take about 6 days for the containers to arrive at my warehouse (this is the date that I'm looking for)
Hope the explanation above can assist you all.
Any inputs would be greatly appreciated
Recently, I've been assigned to handle the tasks for the ship containers, in which I need a formula to calculate the estimation of the time arrival (ETA) based on the loading day
Here are some of my understanding that might help:
1. Every vessel has their own specific departure days (eg: Vessel A: Wed or Sun, Vessel B: Mon or Thur, Vessel C: Mon or Wed, etc)
2. The last day (or the so called closing day) for the terminal to accept all the containers is about 3 days prior departure (eg: if depart on Sun, the last day for the containers to be accepted at the terminal has to be on Thursday)
3. Let's assume once the vessel departed, it will take about 6 days for the containers to arrive at my warehouse (this is the date that I'm looking for)
Hope the explanation above can assist you all.
Any inputs would be greatly appreciated