Chapter 8. Data and Rules in Excel
At the start of the book we said 'If you can understand Microsoft Excel, then you should be OK'. To prove this, we're going to devote this entire chapter to Excel.
Almost everybody understands Excel spreadsheets, or their equivalent in OpenOffice and Google Docs. All of these are simple, grid-based editors that allow us to store, edit, and share information. Spreadsheets may not be perfect, but they're popular and well-understood. First, we're going to use them to hold the data that we supply to the business rules. Then we're going to use spreadsheets to hold the actual rules in a decision table format.
Reading data from Excel
One of the basic problems that we face is getting information into and out of our business ...