Table of Routes

[JohnM]

I am trying to produce a vessel route sheet
You would enter Route No, Date, From, To, ETD, ETD
Click "Add Leg" and keep adding legs until the vessel route is complete eg

Leg1 - 2 May - From A To B, 1200 - 1600
Leg 2 - 2 May - From B to C, 1800 - 2300
Leg 3 - 3 May - From C to A. 0100 - 0300

At some stage the route may change so the legs would have to be amended

Is this possible to do this without buying another programme

John

 

[AKphidelt]

I don't really understand the question... what is a leg? Where do you get the
data from, etc.

 

[JohnM]

What I am trying to do could be equated to a delivery truck

It leaves the depot and goes to shop 1 (We call this leg 1), he then
continues to the next shop (Leg 2) and so on until he returns to the depot

The data comes from the despatchers working out the best route for
deliveries to be made

Hope this makes it clearer

 

[Peo Sjoblom]

I believe leg in this case is the same as the first stage of a trip using US
language
Take Tour De France the cycling race, the first leg would be the same as the
first stage. So if a ship travels from Southampton to Sydney Australia but
first it stops in Calais to pick up goods it would be the first leg of that
trip.

I really don't see that Excel would be of any greater help unless one writes
code especially for this problem. I am sure there are commercial trip
planners out there for these kind of things

 

[AKphidelt]

I'm sorry, now I get the Leg part, but now I just don't understand what you
need excel to do. Explain as, if someone inputs this, then I want this to
happen, and so on. Unless someone else understands the problem.