HCJan 30, 2014
Spatial Modelling Techniques in Microsoft ExcelStephen Allen
We begin by considering the expectations of the creators of VisiCalc, the first spreadsheet. The emphasis is on the nature of the spreadsheet grid. The grid is taken as a presentational method for showing a solution to a Sudoku puzzle. We consider methods or approaches for the solution. We look at the relationship between this model and academic papers on the methods for describing and categorising end-user models generally. We consider whether the type of model described here should be categorised separately. The complexity of the model is reviewed in the context of commendations to minimise overly sophisticated presentational constructs and formulae.
SESep 16, 2012
On the Interpretation of Spreadsheets within their EnvironmentStephen Allen
A demonstration in MS Excel to show how users can connect their spreadsheet models to the external environment that the model represents. We employ indexes to generate a list of relevant evidence that is hyperlinked to the context in which the evidence is discussed. The hyperlinks between the index and the contextual discussion have their own specific presentational identity. We contend that these presentational differences aid the integrity and understanding of complex models. Where models are complex, separate individual results can lead to contradictory conclusions. The demonstration includes a methodology for interpreting the analyses within a workbook and presenting them in the form of a standard written report.