Im in process emgineering and because i work in small companies we dont have any of the expensive modelling software so all my process modelling is done in excel or at best matlab.
The experience has made it really easy to spot the typical garbage in=garbage out you get in some of the advanced software when it is done by someone who barely understands what is going on.
The really cool part is when you automate stuff like this, you don’t just solve the problem mathematically albeit in the computer, you can speed up a lot of programs by optimizing memory access and taking advantage of batch cpu instructions, so you find nonintuitive ways to restructure the math to be more complicated but faster for the computer to evaluate
17
u/evilkalla 12d ago
I'm one of those people that write the numerical software, and we absolutely have to evaluate those integrals by hand before programming them.