Documentation Contents
Getting Started
- Change Log: The changes made in previous releases of Resolver One.
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...
Working with Resolver One Spreadsheets
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.
User code
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.
The Web
- Resolver One Web Server: Our optional web server.
Reference
- Reference guide to the object model and functions you can use in cell formulae and usercode: API documentation.
- Resolver One in Italiano - Massimo Corinaldesi, aka cameyo, a user of Resolver One, has written a user guide in Italian. Thanks, cameyo!
Advanced examples
- Charting: How to do charting in Resolver One.
- Column Level Formulae Example: An example of putting column formulae to good use by doing data aggregation with list comprehensions.
- .NET Objects in the Grid: For the .NET developer.
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
Comments
If you have comments, questions or suggestions about any of the Resolver One documentation, please post them to the Documentation Suggestions Forum.
