How to solve 70-point gas network problems using solver tool?
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. |
All times are GMT +1. The time now is 04:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com