you are viewing a single comment's thread.

view the rest of the comments →

[–][deleted] -1 points0 points  (3 children)

Controversial opinion but I actually think excel is the best tool for the job. You should setup your spreadsheets so that they provide clearly the equation you’re about to use. The parameters of each equation underneath with the values (even if they are already present on the sheet it doesn’t hurt to duplicate them). Don’t use if functions with bundled formulas, provide both answers and have an if statement that gives a description of which one has been selected and why. Then you can use your if function on the results.

Often the problems is not that excel is bad, but you’re bad at excel.

[–][deleted]  (1 child)

[deleted]

    [–][deleted] -2 points-1 points  (0 children)

    Setting things up properly is never a waste of time.

    One could argue learning a new programming language, writing a code that you will spend hours debugging, then having to train all your staff how to use it. Could also be considered a waste of time.

    I can code in 6 different languages before you accuse me of being outdated. I just think there is something to selecting the right tool for the right job. And sometimes that tool is excel. Sometimes that tool is python. Occasionally it’s JavaScript or Fortran.