Documentation Contents

Start using Resolver One

• Resolver One Feature Overview: An overview of Resolver One.
• Quick Start Guide: A quick tour to get you going.
• Tutorial: Get the best out of Resolver One by working your way through this.
• Converting from Microsoft Excel: Import then enhance your legacy spreadsheets.

Support

• Sample Spreadsheets: Examples of Resolver One in action.
• Frequently Asked Questions: Things you might want to know.
• Support and Contact Details: We're here to help...

Before you begin

• Differences Between Resolver One's Formula Language and Python Expressions: For Python programmers.
• Identifying Errors.

Basics

• Complex numbers: Handling complex numbers.
• Named Ranges: Referring to ranges or cells by names.
• Row and column level formulae: Applying a formula to an entire row or column.
• Worksheet level formulae: Applying a formula to an entire worksheet.

Accessing other spreadsheets

• External cells: Reference cell values from other spreadsheets.
• RunWorkbook: Reuse Resolver One documents in your calculations.
• Resolverlib: Reference the contents of Resolver one documents from your own stand-alone IronPython code.

Accessing databases from Resolver One

• Database Worksheets: Display database data in a Resolver One worksheet.
• Database-triggered Recalculation

See also Advanced Examples, Working with data and databases (below).

Advanced

• Arrays: Expanding arrays and lists into the grid.
• Cell validation: Drop-down menus in cells.
• Comments in cells: Documenting your spreadsheets.
• Header Rows and Columns: Referring to cells by headers.
• Histograms in the Grid: Generating images and placing them in the grid.
• How to put List Comprehensions in the Grid: For hard-core Python users.
• NumPy: Using the popular CPython package in Resolver One.

Basics

• Tips for Writing User Code: Get started with Resolver One's Python programming environment.
• Model vs Results: How your code and the spreadsheet grid interact; if changes to the grid that you're making from the code aren't having the effect you expect, this might help.
• Traits: Change the way cells are displayed.
• The Console: Instant results from your Python user code.

Common techniques

• The Auto-Total: A nifty trick.
• Buttons: How to add buttons to your cells.
• Cached worksheets: Persist worksheets across recalculations.
• IRONPYTHONPATH: Creating a standard location for your own Resolver One functions.

Useful functions

• Aggregating Values: A more powerful alternative to traditional pivot tables.
• Formatter trait: Adding custom formatting.

Working with data and databases

• Loading data from CSV files.
• Loading data from a database in user code.
• Reading from databases to arrays.
• Writing to a database.

See also Working with Resolver One Spreadsheets, Accessing databases from Resolver One (above).

Beyond Resolver One

• Access to data from Bloomberg using the optional Financial Data Feeds add-on.
• Access to data from Thomson using the optional Financial Data Feeds add-on.
• The Ironclad project to get Python C extensions working in IronPython.
• How to get Resolver One working with Google Spreadsheets.
• Loading data into Resolver One from Amazon SimpleDB.
• Download large data series from Timetric using Resolver One
• Get free market data from Yahoo! Finance

Resolver One in action

• The Resolver One Exchange: A place where you can find and share Resolver One spreadsheets.
• Extreme Programming Pair Generator.
• Our Usage Tracking Spreadsheet, showing getting data from a Web server, charting, and more!
• The Black-Scholes financial model implemented as a reusable spreadsheet: Black-Scholes with RunWorkbook.
• Performing a range of projections on a share portfolio: Value at Risk with RunWorkbook.
• An Apache Access Log Analysis Spreadsheet