Excel VBA is not really code.Not worth my time to create a new code but I will post some old code of mine here sometime later this week and we can do a time test. We'll have to figure out a way to prevent you from "fudging" the numbers Barney...
are you talking about Excel VBA running the water fall? Unless things drastically changed in the last 5 years, I can honestly say whatever version you were using was not well written. We did the same thing and Woody and I got this thing to run under 20 minutes in 5 year older technology (on Woody's Mac and my old Thinkpad).Absolutely correct. Last semester we had to write code valuing structured securities. The average code ran approximately 45 minutes. Specs matter. I cannot tell you how many times I had to take a break while the numbers were churning...
Yes, waterfall.are you talking about Excel VBA running the water fall? Unless things drastically changed in the last 5 years, I can honestly say whatever version you were using was not well written. We did the same thing and Woody and I got this thing to run under 20 minutes in 5 year older technology (on Woody's Mac and my old Thinkpad).
The specs of the machine won't help you just hide a bad implementation.
As VBA speed is heavily dependent on many other variables, it is really not the best thing to compare system speeds with. Even if you used something such as C where you can control many of those variables, there are still others which cannot be controlled for. The OS itself, and how it manages processes/threading is a variable. Hence, this is not really a good experiment to compare raw hardware specs no matter how you do it.Yes, waterfall.
Funny you should mention it. Mine runs in 15 minutes and was one of the fastest in the class. But no it won't hide bad implementation but would still show which computer is more powerful. The computers with higher specs should complete the run in less time regardless.
Yes, waterfall.
Funny you should mention it. Mine runs in 15 minutes and was one of the fastest in the class. But no it won't hide bad implementation but would still show which computer is more powerful. The computers with higher specs should complete the run in less time regardless.