Unconstrained by layout

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 formulae.

See these features in action in these short screencasts: Named Ranges (1m37s), Column-level Formulae (2m36s).

Rich data types

Apart from numbers, text or dates, Resolver One can store and display all kinds of objects in cells, including .NET types, decimals and complex numbers.

See this feature in action in these two short screencasts: Complex Numbers (1m37s) and Objects in the Grid (2m47s).

Extensibility

Resolver One's unique architecture allows you to tap into an extensive range of Python and .NET libraries, and use them directly in your formulae. You no longer have to waste time re-implementing common algorithms, which lets you solely focus on the problem at hand.

Even if there's no third-party library that does what you want, the foundation of Python and .NET allows you to create reliable and fast custom programs that you can easily plug into your spreadsheet.

Database connectivity

Blur the lines between a database and a spreadsheet using Database Worksheets — with a few clicks, you can view your database tables or the results of SQL queries directly in the grid, and then analyse them with familiar spreadsheet functions.

Resolver One uses the standard ODBC protocol to connect to databases, so will work with the systems you already have — from Microsoft Access to MySQL to Oracle. What's more, if you're using Microsoft SQL Server, you can easily set it up to inform Resolver One when your data changes, so that your spreadsheets automatically update without you having to hit a "refresh" button.

Reusable spreadsheets

Sometimes a spreadsheet is better suited to express a calculation than a program. The problem that has been so troublesome up to this point is that spreadsheets weren't reusable. Resolver One brings the benefits of reusability to spreadsheets with the revolutionary RunWorkbook feature.

See RunWorkbook in action in this screencast (5m27s).

Use your spreadsheets from programs

Spreadsheets are often used as a prototyping tool because of the productivity gains they offer. However, handing a spreadsheet to a programmer to be turned into a program is often an arduous and time-consuming process. With Resolver One, programmers can use spreadsheets as programming modules, just as if they had been written in a .NET programming language.