Interfacing with Excel
Posted: Sat Aug 27, 2005 12:14 pm
Decisions
Date: Sat Aug 27 06:41:13 2005
From: Francisco Perez francisco77pp yahoo.com <system-dynamics@vensim.com>
To: sdmail@listserv.albany.edu
Posted by Francisco Perez <francisco77pp@yahoo.com>
I wonder whether any of you has used a System DYnamics Model with Excel for optimizing decsion at specific intervals. For example. If the model is to simulate behavior of a system and whe make a pause in order to introduce a decision, which may be done supported in Excel as an optimization problems taking as inputs the outputs of the SD model for that time and returning as an answer the decision levers to be introduced back to the SD model. This might be useful for simulating the effect of different decision approaches regarding planning and resource allocation or even multi-objective/criteria optimization in SD.
All comments are welcome. If anyone has any paper or model involving such a topic do not hesitate to share it with us.
Regards
Francisco
Posted by Francisco Perez <francisco77pp@yahoo.com>
posting date Thu, 25 Aug 2005 13:46:38 -0700 (PDT)
Date: Sat Aug 27 06:41:13 2005
From: Francisco Perez francisco77pp yahoo.com <system-dynamics@vensim.com>
To: sdmail@listserv.albany.edu
Posted by Francisco Perez <francisco77pp@yahoo.com>
I wonder whether any of you has used a System DYnamics Model with Excel for optimizing decsion at specific intervals. For example. If the model is to simulate behavior of a system and whe make a pause in order to introduce a decision, which may be done supported in Excel as an optimization problems taking as inputs the outputs of the SD model for that time and returning as an answer the decision levers to be introduced back to the SD model. This might be useful for simulating the effect of different decision approaches regarding planning and resource allocation or even multi-objective/criteria optimization in SD.
All comments are welcome. If anyone has any paper or model involving such a topic do not hesitate to share it with us.
Regards
Francisco
Posted by Francisco Perez <francisco77pp@yahoo.com>
posting date Thu, 25 Aug 2005 13:46:38 -0700 (PDT)