10 sheets tagged with "sample":

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.

This spreadsheet calculates an approximate Answer to the Ultimate Question of Life, the Universe, and Everything.

As the calculation takes some time (about five seconds for this approximation!), it is stored in a cached worksheet so that it doesn't need to be calculated on every recalculation.

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

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.

Row and column level formulae allow you to apply a formula to every row or column in a worksheet. They are extremely useful for removing duplication and avoiding certain kinds of common errors in spreadsheets.

You can also use them in surprising ways; like combining them with list comprehensions to do data aggregation.

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.

Drop-downs allow you to create lists of values for the user to select from. They enable richer user interfaces for your spreadsheet applications.

Drop-down lists in cells can be created from the GUI (where you specify the values as a cellrange), or from user code (where you can use any Python list as the source of values).

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.

Header rows and columns make it easier to access data in both worksheets and cellranges; using header names rather than row / column references. This makes your spreadsheets easier to understand and easier to maintain.

This spreadsheet demonstrates using headers, along with named ranges as an easy way of creating cell ranges from the user interface.

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

The Resolver One object model uses an API that allow spreadsheet objects to be treated as ordinary Python objects as much as possible - making them natural to work with from user code and even formulae.

Cell ranges can be sliced as if they were collections. You can use numbers and the names of header rows and cols in slices. Unlike worksheets, you can use negative numbers as either the start or end of a slice. Cell range slicing is right-exclusive. It may seem little counter-intuitive, especially when you use names from headers, but it's consistent with Python slicing.

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

RunWorkbook is one of the most powerful features of Resolver One. You use the RunWorkbook function to run external Resolver One documents, overriding values in specific cells or cellranges, and using their results in your calculations. That way, you can put common functionality or data in a standalone Resolver One file and use it from many other documents, without the need of copy-pasting.

This sample is a zip-file containing two Resolver One spreadsheets (.rsl files). The main spreadsheet is RunWorkbook.rsl, which loads the data contained in trades.rsl in several different ways.

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