View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Equipment loading using Excel graph

Perhaps you could modify a Gantt chart:

http://pubs.logicalexpressions.com/P...cle.asp?ID=343

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


wrote in message
...
Is it possible to show equipment loading using Excel diagramm?
For example (optimization task):
There are - 3 eqipment (E1, E2, E3) and 4 goods, processing on this
equiment (g1,g2,g3,g4).
For each goods there are 2 time, starting and ending processing.

g1: StartT1_E1 EndT1_E1 StartT1_E2 EndT1_E2 StartT1_E3 EndT1_E3
.................
g4: StartT4_E1 EndT4_E1 StartT4_E2 EndT4_E2 StartT4_E3 EndT4_E3

Is't possible using Excel graph show following graphiÓ for each
Equipment:


____g1___ ________g2________ __g3_
E1____|________|______|________________|__|____|__ ____t
.......
____g1____
E3_______________|___________|____________________ ___t

Thanks you very much for any comments

Konstantin