Excel is a powerful tool. I was solving system of differential equations with Newton method in it. Sometimes it is easier than in Matlab (or Mathematica) if all you have is good understanding of how step-wise equations should look like, but not the differential equations themselves. Those steps may include if statements, for example.
Had to do a similar project and it took me three full days of back and forth with another software before I found out EXCEL rounds small numbers in very weird ways.
Also, in EXCEL functions/formulas and data/values are wildly mixed.
(Not mentioning a plethora of other mildly infuriating quirks here)
Call me crazy, but the admittance matrix hw (Gaussian, G-S, Newton, N-R, etc.) I did last semester was much more intuitive for me on MATLAB than on Excel… but I’m gonna get screwed for that because a vast majority of companies would never bother to pay for MATLAB (+ Toolboxes) licenses.
Excel is a powerful tool. I was solving system of differential equations with Newton method in it. Sometimes it is easier than in Matlab (or Mathematica) if all you have is good understanding of how step-wise equations should look like, but not the differential equations themselves. Those steps may include if statements, for example.
Had to do a similar project and it took me three full days of back and forth with another software before I found out EXCEL rounds small numbers in very weird ways.
Also, in EXCEL functions/formulas and data/values are wildly mixed.
(Not mentioning a plethora of other mildly infuriating quirks here)
Call me crazy, but the admittance matrix hw (Gaussian, G-S, Newton, N-R, etc.) I did last semester was much more intuitive for me on MATLAB than on Excel… but I’m gonna get screwed for that because a vast majority of companies would never bother to pay for MATLAB (+ Toolboxes) licenses.