May
19
0

Apples and Oranges

Apples and oranges, chalk and cheese: choose the metaphor you prefer.

Everyone knows Excel is an enormously popular tool. However Excel is also infamous and has been implicated in many stories of financial mismanagement. Excel is attractive because it is easy to use. But as news stories and groups like the European Spreadsheet Risks Interest Group (EUSprIG) highlight, it is also easy to abuse and this abuse is not just or even mainly by novice users. Rather some of the most serious abuse is by seasoned professionals.

May
19
0

Formulas review

Formulas review is the equivalent of a compile command in a statically typed system. It evaluates the Types, Scopes and Assertions assigned to cells and to formulas to create a report of the problems found.

This article provides some information that is likely to be helpful when interpreting type validation messages displayed when a formula is reviewed.

Copyright Lyquidity Solutions © 2018 · All Rights Reserved · Strongly typed spreadsheets · Strong Typing