I got a beta version of Resolver recently and had a decent chance to see what it is/what it does. So here is a (basic) screenshot:
It is a bit like a spreadsheet with a code editing window tacked below. Both Ross and I have tackled this issue with VBA in different ways in the past. Here is Ross’s code to unlock the VBAIDE Immediate window to float over the grid.
The Resolver code is Python though not VBA. But if you can do VBA you’ll find it very easy to pick up the python basics. And its not just a code window tacked on the bottom. The whole calculation process is opened up for you to code into.
They have it split into
- Imports (similar to setting refs in VB/VBA)
- Creation phase (system only)
- pre-constant user code (put your own formulas in here)
- constants and formatting (can’t mess in here)
- Pre-formula user code (can change sheet values etc here)
- Formula code (no messing in here)
- post formula stuff (didn’t use this)
So you can code into several of those phases, but still not moff up the systems stuff. You can quickly set up simple UDFs and immediately call them from cells. Apparently you can also reference .net objects from cells too, I didn’t try that. The code editor is similar to VS2005, with code folding, highlighting changed lines etc.
The big thing that caught my eye is the import export feature – web enable a spreadsheet in minutes (or seconds). Import a .xls specify input cells and export as a python app, job done. neat.
The other thing I took a look at was data sheets. Resolver can pull data in from a wide variety of sources.
I’ve only scratched the surface so far, but its pretty impressive. I’m not sure how much extra time I am going to get to delve deeper, but I think this is something to keep an eye on.
With this and all the other cool apps I want to play with its going to be hard to find the time to pay the bills or develop my fee generating skills.