Don't know if Solver is suitable/able for this.
But I have recently read about Finite State Machines
(http://www.splatco.com/tips/fsm/fsmartcl.htm), which may be applicable to
you.
There's a VB example here (http://rookscape.com/vbgaming/tutAN.php),
although how good/relevant it is I can't say.

Otherwise building an object model of your network with collections of
consumers, generators etc would give you more control of the structure and
expansion than a Solver solution, I would imagine.

NickHK

"shibojyoti" wrote in message
...
I have a problem in my hand on network analysis. The network consist of
various pipes, valves & controllers with 72 no.of major nodes and carries
byproduct gas from 7-8 generation points to multiple consumers of
different
consumption levels. I need to find solutions for flow of gas under (i)
steady
state distribution and (ii) transient states. Can anyone guide me in this
regard? On how to utilize EXCEL recources to solve such problems, if at
all
they can be solved, what are the best ways to solve such problems and
resource materials on the net as well as on hardcopy.