When to use visual spreadsheet?

When you want to create a calculation application
Useful in cases of communication to the public

When you want other people to understand a phenomenon or a problem using calculation.

When you want to explain calculation.
When you want to show how to solve a problem.

When you want to show how to make a decision in certain circumstances.

Examples of using the visual spreadsheet


Value of a share and purchase decision

Car loan calculator


Speed; Distance; Time


Decision making

Usefulness of a spreadsheet.

It has different features:

  • Gather data
  • Put the data in grids in a certain order using rows and columns
  • Calculate a number using one or more other numbers using formulas

Usefulness of a visual spreadsheet

All the features of a spreadsheet


It is auto-explaining

Each cell may contain images, documents


It allows to easily sort the data

It allows to put a lot of data in a small space


Aesthetically unconvincing

A cell can not contain explanations

No pictures

Little visual


Allows to integrate images

Allows you to integrate explanations into cells

Show links between cells (lines and arrows)

It becomes self-explanatory


Takes more space compared to the data presented.

Sorting is done manually. It is therefore very flexible, but takes longer.

Functions must be written manually.

Application areas

Whenever there is a multitude of data.

When the communication factor (public explanation) does not play.

Application areas

Whenever you want others to understand and use the calculation of a table.

As the table is self-explanatory, you can publish it (internet) or send it to the public (mail). He will appreciate the explanations that the table contains.


Management of personal data

Enterprise data management


Communication from statistical institutions, international, governmental.

Problems solving.