Documentation Contents
Getting Started
- Read the short Quick Start Guide
- Work through a tutorial
- See a quick feature overview
- Browse the Sample Spreadsheets that come with Resolver One
- Python for non-programmers
- Frequently Asked Questions
- Support and Contact Details
Feature Documentation
- Database Worksheets: How to display database data in a worksheet
- The Resolver One Web Server
- Differences Between Resolver One's Formula Language and Python Expressions
- Arrays: Expanding arrays and lists into the grid
- Header Rows and Columns: Referring to cells by headers
- Row and column level formulae: Applying a formula to an entire row or column.
- Traits: Change the way cells are displayed
- How Resolver One works
- Database-triggered Recalculation
- Formatter trait: Adding custom formatting
- How to put Buttons in cells
- CopyRange: Copying cells between worksheets
- Using Complex numbers in the grid
- Named Ranges: Referring to ranges or cells by names
- Cell validation: Drop-down menus in cells
- Comments in cells: Documenting your spreadsheets
- Learn how to program Resolver One
- RunWorkbook: Reuse Resolver One documents in your calculations
- Cached worksheets: Persist worksheets across recalculations
- External cells: Reference cell values from other spreadsheets
- Identifying Errors
- Resolver One in Italiano - Massimo Corinaldesi, aka cameyo, a user of Resolver One, has written a user guide in Italian. Thanks, cameyo!
Reference
- Reference guide to the object model and functions you can use in cell formulae and usercode: API documentation
Advanced examples
- How to do Charting
- For the .NET developer - .NET Objects in the Grid
- Loading data from CSV files
- Loading data from a database in user code
- Reading from databases to arrays
- Writing to a database
- For hard-core Python users - how to put List Comprehensions in the Grid
- Column Level Formulae Example - an example of putting column formulae to good use by doing data aggregation with list comprehensions
- A nifty trick: The Auto-Total
- Extreme Programming Pair Generator
- Our Usage Tracking Spreadsheet, showing getting data from a Web server, charting, and more!
- How to get Resolver One working with Google Spreadsheets
- Loading data into Resolver One from Amazon SimpleDB
- Creating a standard location for your own Resolver One functions using IRONPYTHONPATH
- 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
Comments
If you have comments, questions or suggestions about any of the Resolver One documentation, please post them to the Documentation Suggestions Forum.