TIP: Powerful automation technique

Did you know it's possible to run a whole set of scenarios through a spreadsheet , or run many rows of data through a set of calculations, one row at a time, without any code at all?

This is a very powerful technique.

See it here
http://www.westnet.net.au/balson/Mod...MaNoCode.shtml
(menus may only work in IE, sorry, I prefer Firefox but it doesn't like the CSS template, and I was committed before I realised)

It's part of the site I'm building on financial modelling. Lots of other good stuff there. And I'm not selling anything.

regards

Dermot Balson

Hi Dermot,

Will have to check that out, but it is good to see you here again and know
that you are still active.

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"Dermot" <Dermot.2cd6ao_1155280203.5421@excelforum-nospam.com> wrote in
message news:Dermot.2cd6ao_1155280203.5421@excelforum-nospam.com...
>
> Did you know it's possible to run a whole set of scenarios through a
> spreadsheet , or run many rows of data through a set of calculations,
> one row at a time, without any code at all?
>
> This is a very powerful technique.
>
> See it here
> http://www.westnet.net.au/balson/Mod...MaNoCode.shtml
> (menus may only work in IE, sorry, I prefer Firefox but it doesn't like
> the CSS template, and I was committed before I realised)
>
> It's part of the site I'm building on financial modelling. Lots of
> other good stuff there. And I'm not selling anything.
>
> regards
>
> Dermot Balson
>
>
> --
> Dermot
> ------------------------------------------------------------------------
> Dermot's Profile:
http://www.excelforum.com/member.php...o&userid=37375
> View this thread: http://www.excelforum.com/showthread...hreadid=570640
>

>but it is good to see you here again
Long time ago

Welcome back Dermot

--
Regards Ron de Bruin
http://www.rondebruin.nl



"Bob Phillips" <bob.NGs@somewhere.com> wrote in message news:Oj%23aGRSvGHA.4384@TK2MSFTNGP04.phx.gbl...
> Hi Dermot,
>
> Will have to check that out, but it is good to see you here again and know
> that you are still active.
>
> --
> HTH
>
> Bob Phillips
>
> (replace somewhere in email address with gmail if mailing direct)
>
> "Dermot" <Dermot.2cd6ao_1155280203.5421@excelforum-nospam.com> wrote in
> message news:Dermot.2cd6ao_1155280203.5421@excelforum-nospam.com...
>>
>> Did you know it's possible to run a whole set of scenarios through a
>> spreadsheet , or run many rows of data through a set of calculations,
>> one row at a time, without any code at all?
>>
>> This is a very powerful technique.
>>
>> See it here
>> http://www.westnet.net.au/balson/Mod...MaNoCode.shtml
>> (menus may only work in IE, sorry, I prefer Firefox but it doesn't like
>> the CSS template, and I was committed before I realised)
>>
>> It's part of the site I'm building on financial modelling. Lots of
>> other good stuff there. And I'm not selling anything.
>>
>> regards
>>
>> Dermot Balson
>>
>>
>> --
>> Dermot
>> ------------------------------------------------------------------------
>> Dermot's Profile:
> http://www.excelforum.com/member.php...o&userid=37375
>> View this thread: http://www.excelforum.com/showthread...hreadid=570640
>>
>
>