The amount of issues I have seen in the last ~20 years caused by "off by one" type of errors in Excel is insane.
Few examples:
- incorrect schedule for the electricity grid for an entire country
- incorrect assessment of an airport use for an airline (causing few millions USD loss in revenue)
- incorrect financial position assessment for a mine (resulting incorrect deciosion to optimize the wrong business process, not sure about how much they lost)
Making illegal states unrepresentable is a concept that benefits programming langues and business processes alike.
Few examples:
- incorrect schedule for the electricity grid for an entire country
- incorrect assessment of an airport use for an airline (causing few millions USD loss in revenue)
- incorrect financial position assessment for a mine (resulting incorrect deciosion to optimize the wrong business process, not sure about how much they lost)
Making illegal states unrepresentable is a concept that benefits programming langues and business processes alike.