Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Equipment loading using Excel graph
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to create a graph after loading CSV file | Charts and Charting in Excel | |||
equipment service tracking | Excel Programming | |||
Need an excel template to log complaints/disposition of equipment | Excel Discussion (Misc queries) | |||
looking for equipment maintainance log | Excel Discussion (Misc queries) | |||
Accessing external test equipment using Excel | Excel Programming |