Home |
Search |
Today's Posts |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
A couple of things...
I should start by saying that I don't know what will be faster -- I suspect it will depend on the project. If I were doing a large Monte Carlo simulation and I thought that I might have to use it again and again I would probably put it VBA just so that it would easier to maintain and adjust. By "adjust" I mean that it might be easier making a few coding changes than changing all of your formulas. There are tools out there that do simulations in Excel. One that I used about 10 years ago is @Risk http://www.palisade.com/risk/default.asp. If you're working on a personal project, then @Risk may too expensive -- $700 or so. I have seen what appear to be free add ins that do Monte Carlo simulation. I haven't used them so I can't recommend them from personal experience. You could check http://home.uchicago.edu/~rmyerson/addins.htm. "schizoid_man" wrote: Hi, I have a spreadsheet that has multiple rows (10000) with several compound If statements throughout one sheet of my workbook. An example of such a statement is: IF(C2<"",IF(C2<=$M$14,0,IF(C2=$M$15,$M$17,C2-$M$14)),"") My question is: would it be faster for me to remove all the If statements from this sheet and simply write a VBA subroutine that would do the same thing? I'm certain that it would make the spreadsheet more compact, but would it improve performance? I'm writing a Monte-Carlo simulation so performance is paramount for me. Thanks. |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Lessons from optimizing a slow spreadsheet | Excel Discussion (Misc queries) | |||
Advice on Creating A Spreadsheet - HELP! | Excel Discussion (Misc queries) | |||
Multiple copying of a Spreadsheet advice please | Excel Discussion (Misc queries) | |||
Moving data from form to spreadsheet + VBA advice | Excel Programming | |||
Legal advice on selling Excel spreadsheet program file | Excel Programming |