Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Table of Routes
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 -- JohnM |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Table of Routes
I don't really understand the question... what is a leg? Where do you get the
data from, etc. "JohnM" wrote: 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 -- JohnM |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Table of Routes
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 -- JohnM "AKphidelt" wrote: I don't really understand the question... what is a leg? Where do you get the data from, etc. "JohnM" wrote: 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 -- JohnM |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Table of Routes
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 -- Regards, Peo Sjoblom "AKphidelt" wrote in message ... I don't really understand the question... what is a leg? Where do you get the data from, etc. "JohnM" wrote: 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 -- JohnM |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Table of Routes
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. "AKphidelt" wrote: I don't really understand the question... what is a leg? Where do you get the data from, etc. "JohnM" wrote: 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 -- JohnM |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
spreadsheets for thanksgiving dinner routes | New Users to Excel | |||
entry removed from source table remains in pivot table pull down | Excel Worksheet Functions | |||
Insert rows in linked table that are added to secondary table | Excel Discussion (Misc queries) | |||
Excel Pivot Table Plugin? (crosstab to data table) | Excel Discussion (Misc queries) | |||
PIVOT TABLE - Summary Table into a Databasae Table. | Excel Worksheet Functions |