Insert Heat Maps and Traffic Lights

Insert Heatmaps

A heatmap is a graphical representation of data where the values taken by a variable, in a two-dimensional (or more) map, etc.

Heatmaps Multidimensional

Create Heatmaps combining Image, Font, color, backcolor Cell, Text & font type....

Rules Table

With this function you can insert an example that you can re-use or edit according to you convenience to make the categorization from your data.

Refresh

This option refresh all saved models in your active workbook as modified at the data base.

Manage Models

Through this functionality you will be able to manage in a simple way the refreshing of data.

Options - Delete Images

From this page you can insert images from the dialog box, simply, choose one cell and select the image you wish.

Options - Delete Icons

With this function you can delete inserted icons inside the selected range.

Categorize Databases

This tool extracts unique values from a column in a database.

This useful tool stratifies a database, by adding one more column to the database being observed.

To stratify a database we need a stratification table.

With this tool you can consolidate ranges of different sheets in the open workbooks as closed workbooks as well.

Stratification 1 to 1 was created to deal with the frequent need of stratifying a database.

Some times we want to select only the first row or first column of a specific range, but when it is too extensive, this task is very hard to accomplish.

Use Split field by groups to split a database in multiple data groups

Split field by date is the ideal tool to split a database according to date-type criteria such as year, month, day, week or weekday.

Tools

This powerful tool has been crated to do away with such loss of time.

We sometimes work with models whose information does not fit in the screen.

A comprehensive tool that will make any worksheet management task easier to you.

Use the "Export sheets as..." tool, and simplify this task.

Managing your open workbooks is made easy with the Workbook manager tool.

Do you need to manage many folders, workbooks and worksheets in one place? Use this powerful tool to select and manage them all.