Home | Blog | Software | Reviews and Features | Forum | Help | Donate | About us
topbanner_forum
  *

avatar image

Welcome, Guest. Please login or register.
Did you miss your activation email?

Login with username, password and session length
  • December 06, 2016, 01:59:19 PM
  • Proudly celebrating 10 years online.
  • Donate now to become a lifetime supporting member of the site and get a non-expiring license key for all of our programs.
  • donate

Author Topic: New kind of spreadsheet: Resolver One  (Read 3595 times)

CWuestefeld

  • Supporting Member
  • Joined in 2006
  • **
  • Posts: 1,002
    • View Profile
    • Donate to Member
New kind of spreadsheet: Resolver One
« on: March 28, 2008, 09:29:12 AM »
I've been playing a bit with a new kind of spreadsheet product called Resolver One (http://www.resolvers...cts/resolver-one.php). Since DC people are very software-literate, and are frequently interested in alternative approaches, I thought this might be interesting to all.

The thing about Resolver is that it's really a spreadsheet framework with a built-in code generator. You don't need to know this; it's perfectly usable as a regular old spreadsheet. But as you interact with it, it generates Python code that implements the spreadsheet and all its calculations.

This is a little bit like using the form designers in Visual Studio.Net, for example. You can see the code that creates the sheets, sets the cell values and functions, etc. And you can edit that code and the spreadsheet "view" changes dynamically.

Since all of this is Python code, it means that you can have much more sophisticated cell calculations. But it goes much farther than that.

The logic you can implement isn't limited to the calculations that go on in the cell; anything that's happening in the whole spreadsheet is under your control. Old "macros", or the stuff that Excel might allow in VBA code, can all be accomplished through Python. In fact, since it's part of the code implementing the sheet rather than an adjunct to it, you can do much more powerful stuff.

Also, this is all written in .Net -- IronPython to be specific. So you have access to the whole .Net framework. You can use its classes, call their methods. You can also write your own .Net code in C# (or whatever), expose it into the spreadsheet's code, and use your own classes and methods.

Free for non-commercial use, a little bit expensive otherwise.

mouser

  • First Author
  • Administrator
  • Joined in 2005
  • *****
  • Posts: 36,406
    • View Profile
    • Mouser's Software Zone on DonationCoder.com
    • Read more about this member.
    • Donate to Member
Re: New kind of spreadsheet: Resolver One
« Reply #1 on: March 28, 2008, 09:33:35 AM »
Very nice idea.. They have some screencasts too that help shed light on what it does  :up:

Perry Mowbray

  • N.A.N.Y. Organizer
  • Charter Member
  • Joined in 2005
  • ***
  • Posts: 1,817
    • View Profile
    • Donate to Member
Re: New kind of spreadsheet: Resolver One
« Reply #2 on: March 28, 2008, 06:24:36 PM »
Very nice idea.. They have some screencasts too that help shed light on what it does  :up:

Here are the links:
Screenshot - 29_03_2008 , 10_22_59 AM.png

Screenshot - 29_03_2008 , 10_26_42 AM.png

Screenshot - 29_03_2008 , 10_30_41 AM.png


This certainly looks like an interersting application!

« Last Edit: March 28, 2008, 06:33:08 PM by Perry Mowbray »