@TimeBandit said in excel simulations not running fast enough!:
@Maciejasjmj said in excel simulations not running fast enough!:
On the other hand, the peanut gallery has nothing to say but "just use Linux durrr"
The peanut gallery is saying "I would think that spending a little time implementing your simulation in basically any other language than Excel macros would be incredibly beneficial".
Excel is the perfect programming tool. Why the hell does Micro-Soft still sell Visual Studio, everything should be done in a spreadsheet with macros !!!
The original poster in that thread calls the code in question an "engine". Anything called an engine is probably a mass of weird undocumented requirements and "optimizations" that will probably be too painful and expensive to rewrite in a different, saner language.
Multithreaded VBA macros seems like the kind of thing where when you think you need them you're probably already doomed.