Wow. Finite element methods at its most basic and fascinating. I am sure the algorithm for this isnt "tremendously" complex, I wish I knew how do do all of the conditional formating and whatnot in excel though. Awesome. Whats interesting is that foundries pay millions for software that does the same thing.
The algorithm is "tremendously" simple actually...
Basically: the VBA script copy the results calculated in the final worksheet and paste them in the inicial worksheet. Thus excel atomatically loops recalculating all the worksheets which have the formulae and conditionals at each cell. This example uses 12 worksheets for constants and calculations. The method is finite differece (FDM) and not FEM.
Wow. Finite element methods at its most basic and fascinating. I am sure the algorithm for this isnt "tremendously" complex, I wish I knew how do do all of the conditional formating and whatnot in excel though. Awesome. Whats interesting is that foundries pay millions for software that does the same thing.
gfriedline 1 year ago
@gfriedline
The algorithm is "tremendously" simple actually...
Basically: the VBA script copy the results calculated in the final worksheet and paste them in the inicial worksheet. Thus excel atomatically loops recalculating all the worksheets which have the formulae and conditionals at each cell. This example uses 12 worksheets for constants and calculations. The method is finite differece (FDM) and not FEM.
m69769 1 year ago