SCHEDULE PLOTTING

[amsuria]

hi,

Im so desperate solving this schedule plotting issue. I tried to visualize
every possible ways to solve this but unfortunately, everything goes wrong...

I am trying to make a SCHEDULE PLOTTING...

PROBLEM: the "PROJECT1" needs 16 trucks. How am i goin to put it in a
MAP/PLOT with 5mins interval...

for example:
PROJECT 1
----------------- M I N U T E S C O L U M N
-----------------------
HOUR - 5 10 15 20 25 30 35 40 45
50 55
-----------------------------------------------------------------------------------------
10:00 - T1 T2 T3 T4
T5

11:00 - T6 T7 T8 T9 T10
T11

12:00 - T12 T13 T14 T15
T16


EXPLANATION: PROJECT 1 with 16 trucks "T1 - T16" is scheduled to deliver
goods from 10:10 up to 12:50. Every trucks will be dispatched every 10 mins.
Truck 1 will be dispatched at 10:10 followed by TRUCK2 at 10:20, then TRUCK3
at 10:30 and so on...

Please, any suggestion to create this "AMBITIOUS" report. Thank you so much..

Happy New Year!

Amsuria

 

[amsuria]

By the way, the only data that I have in my database is the first Estimated
Time of Dedparture or ETD (at 10:10).

Number of trucks (16 trucks) and INTERVAL (10 mins) will be determined
through certain formulas...

My problem is PLACING the right data in the right column...

Thanks...

 

[Duane Hookom]

Do you realize you posted in a "Formscoding" news group asking for a report?

There are some sample schedule/calendar reports available for download at
http://www.access.hookom.net/Samples.htm.