A spreadsheet is really
just a very high level, problem-specific, programming environment.
A user "programs" interactively
by entering text or data in cells, defining functions, and performing other
operations. Each user action (event) generates an immediate response
from the spreadsheet program.
The user also "programs"
at a lower level by defining complicated functions for a particular cell,
or defining macros.
The user's instructions
are interpreted (rather than compiled) by the spreadsheet
What algorithms lie under
the surface of a spreadsheet?
NOTE: On the second spreadsheet the checksum cell! Whereas the highlighted cell summed the items in the column above it, the checksum sums the relevant items in the row. If the spreadsheet is correct, then the two sums should be equal.
Last Updated 2001/12/03
L.Heath, 2000, modified by J.A.N. Lee, 2001.