Some significant time ago those nice people at Resolver emailed me about a new feature they had added to the then latest version. (BTW they have some competition on at the moment to win 17k USD – thats about half a million fine British pounds I think at today’s exchange rate?)
Unfortunately, it arrived at the point of maximum turmoil in my web life (change of hosting and all the crap that goes with)
Anyway the point was a new feature that allows one resolver workbook to expose its logic as if it were a function to other workbooks. That means you can pass in parameters and receive back an answer/value.
I think that’s pretty neat. I have always maintained that the most important component of spreadsheets is the logic not the data. The data is normally sourced from, and still available in, some enterprise system somewhere. People aren’t trying to expose the static data they have in spreadsheets – they are trying to expose the logic, certainly in my experience. Would you agree?
I’ve written a few systems that open up a specific workbook in Excel throw in a load of values, calc, run some VBA (sorry Excel services!) calc a bit more, then fire out a value or a few values to some web front end or other spreadsheet. I think that is a fairly common usage pattern, does anyone else come across it?
What sort of things do you do to implement this functionality?
Do you use Resolver to do it?