Incorrect use of Excel's NPV function is a common source of spreadsheet errors. We show several pitfalls and ways to avoid them.
95% of all spreadsheets contain errors. So, it is almost certain that your spreadsheets are wrong.
Solver Max provides a collection of optimization model examples in Excel (using the Solver and OpenSolver add-ins) and Python.
Only a quarter of survey participants were satisfied with their spreadsheet testing. Their techniques are largely manual and lack formalism.
Research concludes unanimously that spreadsheet errors are both common and non-trivial. We must seek ways to reduce spreadsheet errors.
See our bibliography of spreadsheet best practice, risk management, errors and testing, and methods for improving spreadsheets.
Spreadsheets can be considered to be the world's most successful end-user programming language. Spreadsheet formulas are Turing complete.
60% of large companies feel 'Spreadsheet Hell' describes their reliance on spreadsheets either completely or fairly well.
We can help you make better spreadsheets:
Contact us