Profile: glenn

At Resolver Systems, we practice Extreme Programming. If you're doing the same, you may find the spreadsheet on this page useful.

One of the core rules of XP is that you should move people around, to avoid situations where only a few people understand part of the system. We do that by having a rule that the same two people can never pair together for two days running. The problem with that rule is that it can get pretty hard to work out who should work with whom every morning... so, being developers - and in particular, the developers of Resolver One - we coded a spreadsheet in it to solve the problem.

This example shows you how to do several things:

- Download a file from a Web server for inclusion in your workbook.
- Split the contents of a file up and put it into a worksheet.
- Write a simple and easy-to-understand piece of code to generate a column from other columns.
- Display a stacked bar chart.

It analyses (made up!) data similar to the data that Resolver Systems gets when a user agrees to send usage data in Resolver One. This data is stored as a csv file on a server. The spreadsheet downloads the data, inserts it into a worksheet and draws a graph.

Solver is a .NET-based optimisation library from Frontline Systems. Since it is a .NET library, it is very simple to use from Resolver One. Here are a few sheets translated from the examples that ship with Solver. The numbered examples are taken from the Standard Examples project. You will need to install the Solver Platform SDK which can be downloaded from the Solver website at http://www.solver.com.

This sample demonstrates the use of RunWorkbook and the Digipede Network to distribute calculation across a number of agents.

It is a re-implementation of the "Value-at-risk analysis using RunWorkbook" spreadsheet. Instead of calculating each of the scenarios locally, they are submitted to the Digipede Network to run in parallel.

Go to the Digipede website for a free 30 day trial.

Note: This sample requires Resolver One version 1.5 or greater

This is one of the QuantLib Python examples converted to run in Resolver One. Instead of printing the results like the original example, this sheet puts the results in the grid.

See the notes in the spreadsheet for details about the conversion.

This example assumes that you have a working installation of QuantLib and the C# bindings. If you don't, you can download a binary distribution from the link below.