Tuesday, June 30, 2009

Resolver One Spreadsheet


Resolver One is a program that combines the ease-of-use of a spreadsheet with the power of a programming language. It's designed for people who've hit the limits of what they can do with traditional spreadsheets, and want to write some "real code" without giving up the ease-of-use and rapid prototyping capabilities of a spreadsheet.

Resolver One is a new spreadsheet, designed for reliability. It's easily programmable, integrates easily with your (or your IT department's) .NET code, and comes with a built-in Web server. Resolver One is a program that blends a familiar spreadsheet-like interface with the powerful Python programming language, giving you a tool with which to better analyse and present your data.

Everything you can do with a traditional spreadsheet, you can do in Resolver One: write formulae, use cell references, format your sheets so they appear just as you like them, put comments in cells, create validation dropdowns, add buttons, and much more. You can even import your existing Microsoft Excel™ documents, or export Resolver One documents as .xls files.

Resolver One aims to solve the problems that often plague spreadsheets and cost your company money, time and effort. It has a wide range of powerful features that improve reliability, reduce maintenance costs and provide extensibility, without taking away the rapid prototyping and flexibility that a spreadsheet environment offers.

The important difference between Resolver One and traditional spreadsheets is that Resolver One makes scripting a first-class citizen, not an afterthought. In Resolver One, the spreadsheet is the program. As you change your formulae, Python code is generated and executed, with the results displayed as values in the grid. You can then edit the code, define your own functions and use programming constructs that give you unlimited power and flexibility.

Resolver One breaks the barriers of the traditional spreadsheet programming model where the layout is inherent in the calculations. Using named ranges, headers and row and column formulae allows you to change the layout of your sheets without tweaking all your formula.

A lot of businesses are run with spreadsheets developed with Microsoft Excel. Unfortunately, there is a limit on what you can do with them before they turn into a maintenance nightmare. Fortunately, you can import your existing Excel files into Resolver One and make the first step towards spreadsheet sanity. The goal is to make your existing spreadsheets work immediately upon being imported into Resolver One. We support a lot of common spreadsheet functions, formatting options and more.

Best of all, you don't have to be a programmer to use Resolver One! You can begin by using familiar spreadsheet functions. Then you can study the generated code to get a feel for how to accomplish certain things in Python. You can write as little or as much scripting code as you feel - it's just a spreadsheet, after all!

No comments:

Post a Comment