Deprecated: Function set_magic_quotes_runtime() is deprecated in /home/mwexler/public_html/tp/textpattern/lib/txplib_db.php on line 14
The Net Takeaway: Resolver One


Danny Flamberg's Blog
Danny has been marketing for a while, and his articles and work reflect great understanding of data driven marketing.

Eric Peterson the Demystifier
Eric gets metrics, analytics, interactive, and the real world. His advice is worth taking...

Geeking with Greg
Greg Linden created Amazon's recommendation system, so imagine what can write about...

Ned Batchelder's Blog
Ned just finds and writes interesting things. I don't know how he does it.

R at LoyaltyMatrix
Jim Porzak tells of his real-life use of R for marketing analysis.






Resolver One · 09/26/2008 07:41 PM, Analysis

What if you were given a spreadsheet which was actually a front end to a set of Python calculations? So that, when you wanted something which would just, well, act like a program in the spreadsheet, you just write the Python?

Well, I haven’t seen a perfect one yet, but I am intrigued by this product, Resolver One.

From their site:

It retains the familiar table-based interface, but has been comprehensively designed to give you the power and flexibility that the traditional spreadsheet lacks. Every time a you change a Resolver One spreadsheet, the software generates Python code expressing the your formulae as a computer program; this code is immediately executed, and the results are displayed back to you in the spreadsheet interface. You can then edit the code, writing your own functions and algorithms, and see the results in the grid too.

It’s interesting: it blurs the line between data grid and programming language on the data. If you think about it, SPSS and other stats grids are pretty rigid: columns of data, variable names at top, rownums along the side. Then came Pivot Tables and OLAP approaches which allow flexiblity in crosstabs. But the spreadsheet is really a blank canvas: throw your data anywhere, do something with it, then reference it. What was missing was stronger link to a programming language. Sure, VBA was in Office, but it was a pain to get to and a pain to use. It was clearly aimed at people writing applications, not people who wanted to manipulate the sheet as part of an analysis.

Besides all the stuff at their site, there are some good examples of what you can really do with it at Resolver Hacks.

I’ll play with it (they have a non-commercial license, totally cool!) and update the post with my thoughts.

* * *


  Textile Help
Please note that your email will be obfuscated via entities, so its ok to put a real one if you feel like it...

powered by Textpattern 4.0.4 (r1956)