Profile: resolverhacks

Resolver One allows you to display images, like charts, in an image worksheet.

This spreadsheet uses Gnuplot (a powerful charting and plotting application) to create 3D images from spreadsheet data.

It demonstrates both producing plots of 3 dimensional surfaces using Gnuplot and integating Resolver One with an external application.

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

Conway's Game of Life is a fun 'cellular automaton', where single celled beings live or die depending on how crowded their surroundings are. The resulting pattern is both fun and mesmerising - seeming to have a life of its own.

Because Resolver One has a cell based user interface, it is perfect for implementing 'the Game of Life' with; which is exactly what Jonathan Hartley has done. (Press F9 to recalculate and see the cells change.)

It includes a Python library that stores and calculates the state of the 'grid', and could be used to create a game of life using any Python or IronPython compatible user interface.

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

An image is a rectangular grid of pixels, each with a single colour. By coincidence, with Resolver One we have a grid of rectangles where we can control the colour of each cell. We can also change the row height and column width to make them a little more 'pixel-shaped'.

A simple bit of user code turns Resolver One into an image viewer! This spreadsheet even lets you change the size of each pixel to magnify the image, and uses the OpenFileDialog to select new images.

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

Some calculations take a long time, and rather than having to repeat them every time you open the spreadsheet you may want to store the results and only redo the calculation if some of your data changes.

This is actually two examples of persisting and reloading data into a worksheet from an external file. It uses the Python marshal library which is capable of serializing (storing) arbitrary Python objects including the basic types like numbers and strings.

The first example stores the data from a single cell, whilst the second example stores all the data in a worksheet.

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

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.

Apparently, when you have a grid of data, wanting to color alternate rows differently is common. It makes it easier to read, or something like that. As always this is easy to do in Resolver One.

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

With Resolver One you aren't limited to numbers, dates and text - you can store anything you want in cells, including any of the rich set of built-in types that Python provides. You can also create custom types for representing data.

This spreadsheet demonstrates using lists and tuples (Python types) in cells, working with complex numbers, and even creating your own custom numeric types.

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

Resolver One doesn't currently support importing from CSV files out of the box. Resolver One version 1.4 allows you to set data in the grid using the Formula property on cells. This spreadsheet is a tool to import CSV files into Resolver One.

Click the button on the 'Import' spreadsheet and select the CSV file to import. After importing, the contents of the file will be in the 'Data' worksheet and you can delete the user code and save the spreadsheet with a new name.

As well as being a useful tool this spreadsheet provides examples of using the cell Formula property plus using the OpenFileDialog and MessageBox (Windows Forms) dialogs from user code.

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