Language to define references between elements in a 2D array/grid.

Question

Has someone created a language which can be used to track/analyze dependencies between grid cells in a generic way?

I'm trying to write a spreadsheet which uses a functional language. What I'm after is something similar to what Excel might use to manage references between cells. The language will be used create a model which can be analysed for optimisation.

Answer 1

There is a Lisp library which was ported to many Lisps (and some other languages)

http://common-lisp.net/project/cells/

At least some ideas there are worth borrowing.