All, what's all this fuss about?
Took me 20 min to write a script that solves any puzzle.
Challenge me now ;)
simes wrote:All hail VB Guru <bow><scrape>
care to post a link to a downloadable version?
(and in VB too - what a masochist!)
IJ wrote:Your post made me think again. I cut and pasted my macro into a new spreadsheet, unchanged, and it ran in less than a second. Microsoft, eh?
tannedblondbloke wrote:
To be fair I'm amazed at how efficient VBA is. I can run an algorithm on VBA , with all it's baggage of Windows and Excel, and it will still run many many times faster than my first museum piece computer (a Model 1 TRS80 from the late 70s!!)
Anonymous wrote:tannedblondbloke wrote:
To be fair I'm amazed at how efficient VBA is. I can run an algorithm on VBA , with all it's baggage of Windows and Excel, and it will still run many many times faster than my first museum piece computer (a Model 1 TRS80 from the late 70s!!)
Except that you are likely running now on a multi-scalar 2-3GHz machine with 512MB+ of RAM, and the old TRS-80's ran in the low MHz, with 4KB (thats K and not M) of RAM. So you've got 2.5-3 orders of magnitude more raw clock speed (never mind the parallel processing stuff), and 5 orders of magnitude more RAM.
Anonymous wrote:Except that you are likely running now on a multi-scalar 2-3GHz machine with 512MB+ of RAM, and the old TRS-80's ran in the low MHz, with 4KB (thats K and not M) of RAM. So you've got 2.5-3 orders of magnitude more raw clock speed (never mind the parallel processing stuff), and 5 orders of magnitude more RAM.