Equipment loading using Excel graph

K

kossrs

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
 
J

Jon Peltier

Perhaps you could modify a Gantt chart:

http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=343

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


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
 
Top