Stumbled across a page with a number of interesting tutorials on it http://people.revoledu.com/kardi/tutorial/Excel/index.html including things like solving ODE’s, kernel regression, etc., mostly from within Excel (from the looks of things). Interestingly the author for his thesis looked into pedestrian simulations, and does mention CAs (http://people.revoledu.com/kardi/publication/Dissertation.pdf).
Tried to get a number of Python-based CA’s working, but irritatingly can’t get the PIL imaging library to work with v2.6 of Python on Win XP, due to MS C compiler used to compile either Python or PIL …. great. Managed to find a number of CA’s though.
NB Saw Paramics mentinoed somewhere before — they make microsimulation software: http://www.paramics-online.com/.
PS Go look at this chaps website as it could have some things of use on it ! http://www.maerivoet.org/index.php?page=phdresearch-dissertation
NB2 Not sure if this will have some useful Excel-like links in it: http://wofford-ecs.org/IntroComputationalScience/preface.htm
What I need to find out is: what is the difference between Mathematica and Matlab?