Convert excel spreadsheets into online simulations and dashboards

0
615

Share on LinkedIn

There are two neat tools you can use to quickly turn excel spreadsheets into online simulations, what-if models and dashboards. They are Simulate from Forio and Crystal Dashboard Design (formerly known as xcelsius) from SAP. Here’s the lowdown.

Bioteams Questionnaire


Simulate

Simulate allows you to import excel models (and also a number of other tools including ithink) and then add a user interface with a drag and drop tool enabling you to add multiple pages with objects such as text, images, sliders and charts before publishing over the web. Here is a useful little video tutorial which takes you through the entire process in overview for a simple excel model.

Simulate is free provided your models do not exceed 200 equations and you are prepared to share them with others. Simulate Basic costs $479 per year and allows you private and bigger models (up to 2000 equations) but only 1 simulation. Beyond this Simulate gets rather pricey but does allow you to create very sophisticated simulations supporting multiple users and user login.

Crystal Dashboard Designer

Crystal Dashboard Designer works in a similar way to Simulate in that you start by building your excel worksheet and then you import it to the Crystal canvas where you can start to add objects such as text, images, sliders and charts.

The main difference is that all Crystal development is done on the windows desktop whereas Forio development is done in a browser. Crystal offers a 30-day free trial and starts at about £70 for the entry level version (Crystal Presentation Design) going up to about £400 for the all bells and whistles version.

Here is an example model I built with Crystal. As well as building dashboards Crystal is also very good at building online questionnaires (in my example a Bioteams Questionnaire) where you can instantly see charts and visualisations of the entered results.

Note that both Simulate and Crystal currently generate flash (SWF files) which means they won’t run on ipads although I believe the suppliers both have plans for HTML5.

ezViz Office

Another excel add-on tool worth noting is ezViz Office which is a budget data visualisation tool which reads excel data and produces interesting charts including heatmaps which can give you new insights. More about ezViz later when I look at data visualisation tools. ezViz office has a free version and a paid version ($50) – you can find out more about it here:

See also my other article: Microsoft Excel: The Bumblebee’s seven most useful Excel add-ins

Republished with author's permission from original post.

Ken Thompson
Ken Thompson specialises in four key business areas: 1. Creating High Performing Teams in enterprises including Virtual and Mobile Teams, 2. Establishing effective Collaborative Business Networks, 3. Development of graphical on-line interactive Business Dashboards and 4. What-if Simulators for organisations to support Performance Improvement, Strategy Development and Executive Team Development.

ADD YOUR COMMENT

Please use comments to add value to the discussion. Maximum one link to an educational blog post or article. We will NOT PUBLISH brief comments like "good post," comments that mainly promote links, or comments with links to companies, products, or services.

Please enter your comment!
Please enter your name here