> It simply mangles and hides programming. So it creates just the atmosphere were people think they can "avoid" programming and use Excel.
This attitude bothers me somewhat. I'll certainly agree that the combination of Excel's power and ease of use allowing people to model really quite complex calculations and scenarios quickly and easily, and the ease of which they can do it leads to a inappropriate level of "respect" for the gravity of what they are calculating, insufficient testing, double checks, etc, leading to some massive blunders.
But many people seem to go beyond this, asserting that one cannot do such things properly in Excel. I've actually heard one person with an absolutely straight face say that Excel should literally be taken away from engineers and finance folks, and any calculations they need to do should be custom implemented by "professional" developers who will do it "properly".
People who make that suggestion don`t know that there are tools like ResolverONE. It is a spreadsheet that your finance people can use as usual. But when it comes time to validate assumptions and check the calculations, a professional developer can take the generated Python code, write unit tests and other kind of tests to make sure that it does what is intended. Creating spreadsheets could become a collaboration between professionals in finance and professionals in software development. The tools exist to allow this, but where is the will?
This attitude bothers me somewhat. I'll certainly agree that the combination of Excel's power and ease of use allowing people to model really quite complex calculations and scenarios quickly and easily, and the ease of which they can do it leads to a inappropriate level of "respect" for the gravity of what they are calculating, insufficient testing, double checks, etc, leading to some massive blunders.
But many people seem to go beyond this, asserting that one cannot do such things properly in Excel. I've actually heard one person with an absolutely straight face say that Excel should literally be taken away from engineers and finance folks, and any calculations they need to do should be custom implemented by "professional" developers who will do it "properly".
Thoughts?