4 sheets tagged with "headers":

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.

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.

Once you have Resolver One up and running it is likely that you'll want to try out some of your existing Excel spreadsheets. Resolver One supports many of the features of Excel, so importing spreadsheets often requires few or no changes; more importantly once the spreadsheet is running on Resolver One you can take advantage of its features to make spreadsheets easier to maintain and less prone to errors.

This is an example Excel workbook, along with its equivalent converted for Resolver One. It accompanies the tutorial on converting Excel spreadsheets from the Resolver One documentation.

The Excel original uses the VLOOKUP function, along with INDEX and MATCH, to do dynamic lookups.

The Resolver One version does the lookups with headers, making for simpler formulae, and uses column level formulae to make it simpler to add new data.

Use Resolver One to download current data from the Yahoo Financial data feeds and parse it with a reader. The values are stored using the .Formula property so that data can be looked at offline.