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

About Types

We identify many types of thing: animals, plants, concepts, pictures. Any one type is usually a member of a hierarchy (such as clothing-> outdoor-> footwear-> boot or Painting-> Landscape-> Rembrandt). In this way types allow us to workout how things can be accumulated, grouped and compared.

Using these relationships make any programming more reliable – including Excel formulas.

May
19
0

Types in programming

The purpose of a type system is to help validate the source code for a program. Without a type system (or some proxy for one) there is nothing to stop a programmer writing nonsense code such as adding apples and oranges. There’s nothing in Javascript or Excel to prevent these mistakes but there is in any statically typed language.

This article will review relevant ideas from general programming that should also apply to a type system for Excel. If you program using a language that uses a type system, you’ll probably have a good idea of the likely topics.

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