excel simulations not running fast enough!
-
I was just perusing the Linode forums (a VM/VPS host) and came across this jem.
Get to like this post to really raise an eyebrow:
Funny how at the end he's pretty adamant there must be a way for linode to accommodate his insanity instead of fixing the obvious problem...
-
-
-
@delfinom said in excel simulations not running fast enough!:
Funny how at the end he's pretty adamant there must be a way for linode to accommodate his insanity instead of fixing the obvious problem...
There is a way. It might be underperformant, but it's better than nothing.
On the other hand, the peanut gallery has nothing to say but "just use Linux durrr". Are you going to pay the guy for all the manpower it's going to take to port that entire legacy system to Linux and find equivalents to the dependencies?
-
Just run them in LibreOffice, it has OpenCL support for maximum simulator efficiency.
-
@delfinom said in excel simulations not running fast enough!:
Funny how at the end he's pretty adamant there must be a way for linode to accommodate his insanity instead of fixing the obvious problem...
It occurs to me that the least incorrect solution is to get a physical machine that can run Windows and this Excel thing...
-
Maybe move to a provider that isn't specialized for linux VMs and only offers Windows as a "custom OS" with probably limited support if you need a Windows VM and have specific requirements for how it's supposed to work.
I'm surprised that you can even get a Windows VM to work on linode at all after looking at the main page of their website.
-
@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 !!!
-
@TimeBandit said in excel simulations not running fast enough!:
everything should be done in a spreadsheet with macros
-
@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.
-
@TimeBandit said in excel simulations not running fast enough!:
everything should be done in a spreadsheet with macros
That's the sad part. If you're actually doing everything with macros, then the spreadsheet basically becomes a really shitty GUI toolkit. You're so close to having a "real" programming environment but still refuse to go there.
Now, if you built your own physics simulator in pure Excel formulas, that's something I can respect.
-
@anonymous234 said in excel simulations not running fast enough!:
Now, if you built your own physics simulator in pure Excel formulas, that's something I can respect.
Yeah, I would respect that, but I would still call you an idiot for doing it
-
@anonymous234 said in excel simulations not running fast enough!:
Now, if you built your own physics simulator in pure Excel formulas, that's something I can respect.
I would respect them too, even after they'd been fitted for a straitjacket.
-
@delfinom said in excel simulations not running fast enough!:
I was just perusing the Linode forums (a VM/VPS host) and came across this jem.
Truly outrageous. Truly, truly, truly outrageous.
-
It's amazing how literally no one in that topic except OP realizes how big of a project would be to rewrite all the core software of that company to something else than it is now. Yes, the performance would be orders of magnitude better, but it would require at the very least $300,000 spare funds. If the business isn't making millions per year, it's unlikely it would ever pay off.
-
@Gąska said in excel simulations not running fast enough!:
unlikely it would ever pay off.
Very few projects actually do...
-
@RaceProUK said in excel simulations not running fast enough!:
@anonymous234 said in excel simulations not running fast enough!:
Now, if you built your own physics simulator in pure Excel formulas, that's something I can respect.
I would respect them too, even after they'd been fitted for a straitjacket.
You might wish to upgrade that.
-
@dkf said in excel simulations not running fast enough!:
@RaceProUK said in excel simulations not running fast enough!:
@anonymous234 said in excel simulations not running fast enough!:
Now, if you built your own physics simulator in pure Excel formulas, that's something I can respect.
I would respect them too, even after they'd been fitted for a straitjacket.
You might wish to upgrade that.
I recently watched that movie!
It was ok I guess...
-
@Tsaukpaetra said in excel simulations not running fast enough!:
I recently watched that movie!
It was ok I guess...But ordering Chianti will never be the same again!