8 sheets tagged with "user code":

An example of using the powerful Aggregate function to aggregate data in worksheets.

Aggregate provides an easy way of summarising data from one worksheet into another worksheet. It is similar to, but more powerful than, the pivot tables you might be familiar with from Excel and other spreadsheets.

This example takes a set of transactions in the 'Data' worksheets and puts several different summaries into the other worksheets.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

An example of using the powerful Aggregate function to achieve a similar effect to pivot tables you might be familiar with from Excel and other spreadsheets.

The first sheet 'donations', is purely data I typed in.

The second sheet is generated using a few lines of post-formula usercode, which invokes Aggregate. This calculates the count, the total and the average donation, all by country.

I used three built-in functions to aggregate the values in the pivot table (len, SUM and AVERAGE.)

It also adds a column to the pivot table which lists the names of all people who donated from a particular country.

This sample spreadsheet takes a worksheet of transaction data, and summarises and formats it using cell ranges. The user code in this example makes use of several of the features of cell ranges.

The idea of the spreadsheet is that we have a long list of individual transactions (the 'Transactions' worksheet). Each transaction is a trade of shares (either a buy or a sell) for a particular customer. We want to be able to summarise this, so that we can see the total trades for each customer and for each stock.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

This spreadsheet avoids duplicating formulas by filling in a column with values generated from user code. It is a very simple example of using the Resolver One spreadsheet object model from code.

It uses the "withVat" function from the Quick Start Guide to add VAT (sales tax) to prices of office supplies.

Because the "Gross Price" column is populated from Python, if you add new items to the spreadsheet the gross price is automatically updated.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

Although a simple example, this spreadsheet shows off several key features of Resolver One.

The Fibonacci sequence is implemented as a Python generator function (in user code) which is called and configured from cells in the spreadsheet grid. The resulting generator object is stored directly in a cell, and used to generate values from the sequence - as a Python list also stored directly in the grid.

It shows how easy it is to write simple functions and call them from formulas, and how the basic Python types (including arbitrary objects) can be stored and displayed in your spreadsheet.

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

This is the example that is worked through in the Quick Start Guide.

It demonstrates creating a simple Python function in user code and using it from formulas.

It also uses the BackColor property on rows for conditional formatting (BackColor is available on all the spreadsheet objects including cells and cellranges as part of the formatting API).

This spreadsheet is one of the sample spreadsheets that comes with Resolver One.

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 spreasheet is an example that demonstrates some of the basic features of Resolver One, including writing user code, working with dates and handling errors.

This spreadsheet is an example of managing your accounts with Resolver One.

This spreadsheet was created for the Resolver Hacks website, and not by Resolver Systems.