Hacker News new | ask | show | jobs
by daemon13 4615 days ago
I agree with your valid point, re

>> Invalid point: Formulae are easy to follow and audience can easily verify/reproduce your work.

Actually this is another valid point of Excel.

Unless the financial model was done incorrectly (using VBA, complicated formula chains, unclear logic), it is very easy to verify financial model in Excel, which is a big plus.

1 comments

Excel has been partly to blame for many bugs in mathematical models, in part because of its datatypes and in part because of its builtins. Some of these bugs are not at all easy to spot, depending on how you go about the building and the verifying.
What mathematical models? For your company financial assumptions and forecasts you generally need, in essence, the sum(...) function, percentages and multiplication, repeated ad nauseam, and if any of your formulas even have space for 'not easy to spot' bugs then the bug is in thinking of making such formulas in the first place.

Your spreadsheets would be big because of quantity of different things included, not because of complexity of those things