Resolver One spreadsheet

Spreadsheets created in Microsoft Excel or compatible programs are very useful for analysing data using the built-in functions to create formulas.

But as experienced users working with large complicated spreadsheets can discover, if a function doesn’t do what you want it to do, it can’t be modified.

Resolver One solves this problem. It is an Excel-compatible spreadsheet program aimed at those familiar with programming. Its unique feature is that it instantaneously translates everything typed into a cell into program code using the Python programming language.

This allows users to create their own custom functions and perform advanced data manipulation, or even create entire applications. It can also import existing Excel files.

No knowledge of Python is needed in order to use the program, as it can be used just like a regular spreadsheet that looks and feels very similar to older versions of Excel.

As you enter data and formulas, these are displayed in a separate code pane below the spreadsheet. This makes it a good tool for those wanting to learn Python programming, too.

There is a free 30-day evaluation available, and it comes with sample spreadsheets that showcase its capabilities.