Convert excel spreadsheets into online simulations and dashboards

December 9, 2012 | article by Ken Thompson in Business Simulation (14)

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 Presentation 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 Presentation Design

Crystal Presentation Design 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 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.

Here is a short video tutorial on SAP Crystal Presentation Design.

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.

About Ken Thompson

Ken Thompson delivers keynote conference speeches, workshop facilitation and in-house consultancy in four key business areas:

Creating High Performing Teams in enterprises including Virtual and Mobile Teams (based on the Bioteams Book)
Establishing effective Collaborative Business Networks enabling companies to co-operate effectively in areas such as sales and product development (based on the book - The Networked Enterprise)
How to use the latest social media technologies including blogging and online communities to promote enterprises, brand, organisation or event
Development of graphical on-line interactive Business Games, Dashboards and What-if Simulators for organisations to support Performance Improvement, Strategy Development and Executive Team Development.

Tags: analytics, dashboards, excel, simulators, visualization, what-if

Comments (0)| Related (3) | Permalink

Email to a friend | Print this article

Bioteams Books Reviews

Seven team decision-making methods

February 19, 2008 | article by Ken Thompson in Book Reviews (37)

The way a team decides to decide is one of the most important decisions it makes. In the excellent book, “Why Teams Don’t Work” the authors, Harvey Robbins and Michael Finley, identify seven key decision-making methods for teams.

Buy it now from:
Amazon.Com
Amazon.Co.UK

Comments (2) | Permalink

Click here to check all Bioteams book reviews

Related Business Simulation Articles

The Stakeholder Collaboration Game

April 6, 2011 | article by Ken Thompson in Business Simulation (16), Virtual Communities (34), Virtual Teams (46)

One of the challenges for teams is that the achievement of some of their goals are not fully under their own control - they need to be achieved in partnership with, or even in spite of, external parties (stakeholders) who are working to their own agendas and priorities. The Stakeholder Collaboration Game allows teams to simulate increasingly complex scenarios involving multiple goals and multiple stakeholders.

Comments | Permalink

15 Principles of Business Game Design for team-based learning

June 23, 2012 | article by Ken Thompson in Business Simulation (16)

I develop custom business games for team-based experiential learning workshops which usually have a significant computer element. This whole area is strewn with pitfalls, good intentions and misconceptions and there is a huge risk that the game becomes too complex or an end in itself or the graphical aspect of the user interface becomes all consuming at the expense of the learning.

Comments | Permalink

Create your own business simulation lab for better team decision-making

November 16, 2010 | article by Ken Thompson in Business Simulation (16), Virtual Teams (46)

The huge interest in Serious Games, where gaming technology is used for serious or business purposes, has made it feasible for far-sighted organizations to gain enduring competitive advantage by creating their own business simulation labs to regularly present their senior teams with possible future business scenarios to improve decision-making and to allow the big mistakes to happen in the simulator and not in the business. My new white paper explains how.

Comments | Permalink