Domain: resolversystems.com
Stories and comments across the archive that link to resolversystems.com.
Comments · 7
-
Resolver One
Have you looked at Resolver One ( http://www.resolversystems.com/products/resolver-one/ ) - it lets you program in Python.
-
Re:Java bashers, where are you?
ResolverOne is written entirely on IronPython. IIRC, each file also can embed Python code with a subset of the standard library, so it's like VBA on steroids. You decide if that's good or bad.
-
Re:sounds like a decades-out-of-date argument
http://www.resolversystems.com/products/resolver-one/
I suspect there are plenty of other such things that you also do not know about. I guess it doesn't exactly fit one of your labels, but it fits what you are going on about.
-
What about the opportunity to learn something new?
When Resolver Systems started their $25,000 competition for the best spreadsheet examples for Resolver One, I saw it as a great opportunity to learn IronPython and play around with a new program that looked interesting. I spent some free time having fun coding in a new language, and the Texas Holdem Monte Carlo Hand Evaluator worksheet that I made ended up being pretty useful. Oh... and it won one of the rounds, so I see it as time very well spent
:-P
Now this competition is a bit more structured and has much less of a "fun" factor, but it still is a good incentive to look at the data that is available and try and think of new ways to visualize or use it. -
Re:I hate baby programming in spreadsheets
Maybe somewhere out there is some sort of "spreadsheet for smart people" where I can use say python expressions to manipulate a big table of data.
*cough* Resolver One *cough*
-
Re:Misuse of spreadsheets
That is true, but the user cannot add columns quickly. I'm thinking of having a reserved row for the column name. If you don't put a name there, then it is automatically named the spreadsheet column letter, or the like (and column letters can perhaps still be aliases even if you do have an explicit name).
That's not really a feature of the DBMS, but of the UI, though. Given the generality of the programmability that resolver one appears to offer, it seems like it should be nearly trivial to implement a spreadsheet in it that would use a appropriate SQL backend this way.Well, but spreadsheets have a grid feel instead of a table feel and follow grid rules instead of table rules.
That's generally true, though good spreadsheets make it possible to implement worksheets, or ranges of worksheets, that obey table-like rules to a greater or lesser extent, and the particular features highlighted in resolver one suggest that it does so far more than most out of the box (in ways that allow columns and rows to act like table columns and rows, and even allow worksheets to work like views backed by some set of other worksheets.) At least, that's what I infer from the description of worksheet formulae on the resolver one home page:Worksheet formulae
Resolver features formulae for worksheets as well as for cells; this allows a single formula to fill a worksheet with values calculated from one or more other worksheets. Result worksheets calculated in this way will be updated correctly as the input data grows or shrinks; this method also diminishes the incidence of single cells with incorrect formulae, since there is no need to mechanically specify the formula for every cell in the worksheet. -
Re:Why should I use this rather than SQL?
SQL databases have become much lighter and more efficient these days. Why should I use this store data over a lightweight SQL database?
One of the selling points is using it to interact with SQL databases that are used to store data. From the resolver one homepage:
Entire database tables, or the results of arbitrary SQL queries, can be imported directly into Resolver documents as new worksheets, which can immediately be used in calculations. If necessary, Resolver can update the worksheet in real time as the underlying dataset changes. Because there is no need for the user to write code themselves, this allows for sophisticated data analysis without assistance from IT.