cant remember, but I'll do a search and see if I cant relocate. It was an educational demo rather than an analysis tool, but did the business.
-----Original Message-----
From: aluser2 [mailto:alwynk@shaw.ca]
Sent: Saturday, January 22, 2005 6:37 AM
To: PipingDesign@yahoogroups.com
Subject: Re: [PipingDesign] OFFTOPIC: animating excel graphs
where did you see the anim graohics of water hammer on the inet??
>
> 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
>
>
>
>
>
>
>
>
>
>
>
> =========================================
> PipingOffice - Excel Spreadsheets for Piping Calculations
> http://www.pipingoffice.us/ =========================================
> Main site: http://www.pipingdesign.com
>
> Yahoo! Groups Links
>
>
>
>
>
>
>
http://www.pipingoffice.us/ =========================================Main site: http://www.pipingdesign.com
Yahoo! Groups Links Received on Fri Jan 21 15:41:00 2005
This archive was generated by hypermail 2.1.8 : Mon Oct 27 2008 - 20:24:06 EDT