3 sheets tagged with "excel":

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.

Generating Sparklines from real time financial information with Resolver one and Google finance API
Sparklines are the greatest inventions of Professor Edward Tufte (statistician and Professor Emeritus of statistics at Yale University), a Sparkline is a proper tool to visualize financial information in a very small space. Sparklines are tiny informative graphs that can be inserted in financial reports.
Sparkline tools are available for MS-Excel. Our code generates sparklines from financial information in Resolver One; these sparklines can then be inserted in-line with texts in financial reports.
In our code, we read Google closing price from an API provided by Google finance, this API provides us with a CSV stream that we can load into Resolver One. We can additionally change the date range for the data stream from within Resolver One.
The code should work right out of the box and there is no need to download any additional package, it calls GDI+ functions and it should be very easy to modify and customize

Pivot Charts, Pivot Tables and Auto filter are three tools that help users analyze spreadsheet data. Resolver One currently does not include these 3 features, but since it is based on the IronPython programming language the data can easily be exported to another system for analysis.

This example shows how to create a spreadsheet using a complex business object (System.DateTime) and then use Microsoft .NET COM Automation to export the data into a Microsoft Excel workbook for analysis.

This shows how Resolver One can be used to easily extract data from complex business objects and quickly build an easy to maintain spreadsheet. It then shows how the data can be automatically transfered into another application for analysis and reporting.