Groups | Search | Server Info | Keyboard shortcuts | Login | Register [http] [https] [nntp] [nntps]

Groups > microsoft.public.excel.programming > #109022

Re: Writing formulae from array to range

Show all headers | View raw

In message <XH$nr9CpCEbXFw9T@freenetname.co.uk> of Thu, 23 Jun 2016
21:03:53 in microsoft.public.excel.programming, Walter Briscoe
<wbriscoe@nospam.demon.co.uk> writes
>I started to compose this as a problem. I now have a solution, I would
>value an explanation. I have a second problem at the end.
>

[snip]

>p.s. I now measure:
>10 buscrawl, Time = 6381, Mean = 6639, sd = 1152
>I have not bothered doing any difference of means calculation.
>The optimisation has plainly not achieved anything useful.
>As my sub is called about 1400 times, time savings would be worth
>having. I run the relevant code about once a week.
>
>Any suggestions on optimisation?
>My sub consists of about 180 lines and I think it unreasonable to post
>here. I would email to any interested, well-known maven.
>
>I will post my statistics sub on any interest.

I've identified some writing to a string variable, which is not read for
anything essential.
My sub writes to cells; it derives from a sub which writes to a file.
The string operations are needed for that sub. I now have:
10 buscrawl, Time = 4680, Mean = 4766, sd = 771
That IS a result. Thanks to my readers here for helping me to thought.
-- 
Walter Briscoe

Back to microsoft.public.excel.programming | Previous | Next — Previous in thread | Next in thread | Find similar | Unroll thread

Thread

Writing formulae from array to range Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-06-23 21:03 +0100
  Re: Writing formulae from array to range Walter Briscoe <wbriscoe@nospam.demon.co.uk> - 2016-06-23 21:31 +0100
  Re: Writing formulae from array to range GS <gs@v.invalid> - 2016-06-23 22:31 -0400

csiph-web