RE: [PipingDesign] OFFTOPIC: animating excel graphs

From: <Steve>
Date: Fri Jan 21 2005 - 05:26:00 EST

Hi Paul
its not for presentation; just so I can fiddle with things in real time and see the results of my fiddling.

For example a control valve under PID, I would like to be able to play with the setpoint, gain and reset on the run and see the effect on valve position and MV.
Another example is project costing, fiddling with discount rates capex, opex, payment periods and construction times to see the effect on, say, NPV
Also cooling system loops, playing with fouling factors and scaling rates to see the effect on generation output. The list goes on.

I guess what I am after is to be able to do a dynamic sensitivity analysis, if such a term exists.
Currently I do this by rather large spreadsheets and just graph the relevant static cells.Sonetimes this gets very cumbersome. It would save a lot of time if I could adjust the input variables on the run and have the outputs traced on the screen.
I know it can be done (not sure about the exel linking though), because I have seen some excellent animated examples on the internet ; water hammer for example. Its just I don't know how to do it.

I will have a go at Erik, Al and Bens suggestions (thanks guys) and see what comes out of it.

Cheers

Steve

-----Original Message-----
From: Paul Bowers [mailto:pbowers@pipingdesign.com] Sent: Friday, January 21, 2005 12:42 PM
To: PipingDesign@yahoogroups.com
Subject: Re: [PipingDesign] OFFTOPIC: animating excel graphs

What kind of use is this for - a presentation of sorts?

This would likely be QED if the graph is placed into a HTML page (using some javascript).

Let more know more about what you want and I'll be able to give you more

information, or hack something together for you.

Paul

Steve McKenzie wrote:

> is it possible to "animate" an excel graph, so I can hit the start
> button and the graph unscrolls across the screen at an adjustable
> rate?
> Is there a simple way or do I have to learn a computer language like
> VB?

---

PipingOffice - Excel Spreadsheets for Piping Calculations http://www.pipingoffice.us/

---

Main site: http://www.pipingdesign.com

Yahoo! Groups Links Received on Fri Jan 21 05:26:00 2005