Let containers with specs talk to eachother after sequence change

Will_vanthek

New Member
Joined
Oct 1, 2020
Messages
15
Office Version
  1. 365
Platform
  1. Windows
Dear All,
I have a question hope you can help me.

I am sailing with a ship to 10 different ports. From A to B and from B to C etc. etc. The list looks like the following image:

1602086261311.png

In a selection process I gained the following sailing schedule:

1602086269519.png


This means that for the distance between A and B, under 1 = 180Nm.
The distance between 1B and 2A (next port) = 323Nm.
When the schedule as described is followed I travelled: 180 + 323 + 6245 + 1542 + 6875 = 15165 Nm.

Each item ( Loading port, discharge port has specifications like the distance, expenses or revenues.
Actually it should be treated as a “Container” with specs and the sequence where the containers are positioned, defines the total travel time, total expenses or revenu.

Now a new “Container”, comes into the schedule with new specs. In our case the number 8.

1602086293957.png


The toal result will change as the ship will sail tot he loading port 1A to discharge port B. But from he is NOT sailing to 2A anymore he is sailing to 8A for loading and to 8B for discharge. Etc.

So now container 1 is talking to container 8, who is talking to container 2 and at the end we have a different result.

I have the following information:
- I know what each container contains for specs, POL, POD, Quantity, distance, exp. Rev.
- I know the distances between all possible combinations.
- I create a sequence by code, but the sequence will come from the list of ports i mentioned at the beginning. This list is dynamic and can change.
Means some cargoes will be added and some will be deleted. Everytime a change will happen, a new sequence will be created.
- After the sequence is created, we have to get the containers handshaking eachother and calculation should take place.

I know it is a mouthfull, but maybe one of you can help me.
1602086379902.png



 

Excel Facts

Excel Wisdom
Using a mouse in Excel is the work equivalent of wearing a lanyard when you first get to college

Forum statistics

Threads
1,143,674
Messages
5,720,234
Members
422,271
Latest member
xbaca

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top