Dan

Giles Thomas: ResolverOne, Combining a Spreadsheet with a Programming Language

Download this episode

Download Video

Description

Resolver One is a Power User's spreadsheet written in IronPython and DLR that dynamically generates IronPython code based on spreadsheet values and formulas.  The cool thing is you can write .NET code with IronPython (or call .NET code written in any language) directly inline and have it apply to your spreadsheet.

Resolver One has a non-commercial license that you can use to play with and experiment with Iron Python.







Embed

Format

Available formats for this video:

Actual format may change based on video formats available and browser capability.

    The Discussion

    • User profile image
      dcharles
      Iron python looks like it's be an easy language to learn!
    • User profile image
      Dan
      What's nice is that it's sort of like Excel's Macro Recorder on steroids in that it's always on and always visible so you can experiment/tinker with IronPython by running a few calculations or by typing values and see what the "generated code" is.
    • User profile image
      TommyCarlier
      This looks very interesting. You should really interview more people from outside of Microsoft that are using MS technologies. Great interview. Just the right length. Good balance between talking and demoing.
    • User profile image
      ymasuda_

      Not being compond document, but how different?

      That Python language speaking spreadsheet acquires static automation codes for complex work stacks, and dynamic language codes looks after simple work areas. May application having dynamic language nature meet needs of spreadsheet functions less costly? How much and where does dynamic language application benefit in subject of financial application development in the case of Resolver One? Whereas developers prefer Python, Resolver One solution providers may purchase more function points than simple construction of Python functions.

      For instance, XForm has influenced XML conformant application designs and it has more productive module development nature based on XForm submit controls. XForm clients may act as SOAP originators and communicate with flexible SOAP actors. That solution comparison means to tell that business practice led by present dynamic language nature might be costly, and more competitive networking spreadsheet solutions of standards should be extensible.

      What could be expected application designs truly for dynamic language runtime? Composition is major architectural subject in Office business application development. Is combining nature capable to meet composition for today's Office System solutions? Interestingly, is this project trying to evangelize partners with such architectural blueprints for .NET developers expectedly without loosing development business?

    • User profile image
      gbrayut

      Hmm... This says that it was posted Mar 24th, 2008, but the video just showed up in my RSS feed a few hours ago. That is quite the delay Tongue Out

      I have been using Resolver One these last few months as part of their $25,000 spreadsheet competition, and I have to say that it is a very powerful analytics tool. Highly recommended for anyone that wants do do complex analysis using a spreadsheet model. For instance, check out this spreadsheet that I made which can evaluate Texas Holdem poker hands:

      http://www.theg2.net/rsltexasholdem/

      More info and an overview of using Resolver One here:

      http://blog.theg2.net/2009/05/resolver-one-review-4-months-with-net.html

    Comments closed

    Comments have been closed since this content was published more than 30 days ago, but if you'd like to send us feedback you can Contact Us.