[ More about Excelsior | Jocelyn Ireson-Paine's home page ]
This is a repository I've set up of spreadsheets coded in Excelsior. At the moment, there are three example:
Predator-prey spreadsheet. I've coded it to emulate the original that's on Norm Herr's site at www.csun.edu/science/ref/spreadsheets/xls/predator_prey.xls.
Spreadsheet that finds all text strings matching a given pattern. This uses the same style of recursive programming as the science-fiction generator, but this time applied to a "real-world" problem. This is something that came up in one of my consultancy-with-Excelsior jobs, when I had to create several sublists of dropdown options from a master list. Each sublist had to contain only those elements that matched a given pattern. This is difficult to code directly in Excel, but pretty easy in Excelsior.
In these examples, the documentation was generated by Literate Excelsior, as described in It Ain't What You View, But The Way That You View It: documenting spreadsheets with Excelsior, semantic wikis, and literate programming. In Proceedings of EuSpRIG 2007, Greenwich, 8-10 July 2007.
[ Buy Excelsior | More about Excelsior | Jocelyn Ireson-Paine's home page ]