HeatMapster FAQ

Practical answers about importing data, choosing an analysis, saving projects and sharing results.

Getting started

What is HeatMapster?

HeatMapster is a Windows application for turning numeric matrices and tables of records into heatmaps. It includes Matrix Builder, correlation, comparison, confusion-matrix and time-based analyses, together with export tools for reports and presentations.

Which operating systems are supported?

Use a 64-bit PC running Windows 10 or Windows 11. HeatMapster is a desktop application, with no native macOS, Android or iOS edition. Check the Microsoft Store listing for the current system requirements.

Where can I get it, and what does it cost?

Get HeatMapster from Microsoft Store. The listing shows the current price, availability and license terms for your region.

Do I need a HeatMapster account?

There is no separate HeatMapster account for working with your data. Microsoft Store handles acquisition and installation through its own account and licensing system.

Is there a sample I can try?

Yes. The application includes built-in samples and Help. You can also download three small CSV examples and follow the worked tutorials.

Import and data

Which files can I import?

Import Excel workbooks (.xlsx and .xls), CSV and other delimited text files, or paste a table from the clipboard. Use the preview to check the worksheet or range, headers, separators and data types before continuing.

Should I choose Matrix or Raw Table?

Choose Matrix when your data already has a numeric value at each row-and-column intersection. Choose Raw Table for individual records that need grouping or analysis. The import guide shows both cases.

Why are missing values different from zero?

Zero is an observed numeric value. A missing value or a combination with no records has a different meaning. Keeping them distinct prevents an empty cell from appearing to be a genuine low result. Invalid and analytically undefined values also need their own interpretation.

Can I filter records before analysis?

Yes. Source filters restrict the records used by the analysis. View filters affect the displayed result. Filtering is not redaction: a saved project may still contain the complete source dataset.

Does formatting numbers change their precision?

No. The displayed number of decimal places controls presentation; it does not round the underlying stored values used by the analysis.

Analysis and interpretation

What does Matrix Builder do?

It groups records by the row and column categories you choose and calculates a value for each combination. For example, the sales tutorial groups Region × Product and sums Sales. Other calculations answer different questions, such as Average or Count.

What is Split By?

Split By creates separate heatmaps for values of another category, such as region or team. Use a shared scale for direct color comparisons across maps. With per-map scales, similar colors may represent different numeric values.

How do Pearson and Spearman correlation differ?

Pearson describes linear association between numeric variables. Spearman works with ranks and describes monotonic association. Both require suitable observations; an undefined result, such as one involving a constant variable, should not be interpreted as no relationship. Neither proves causation.

How large is a correlation matrix?

It has one row and one column per selected variable. Four variables therefore produce a 4 × 4 matrix. The number of supporting observation records is a separate quantity.

What do Difference, Percentage Change and Ratio mean?

Difference is Current − Baseline. Percentage Change is (Current − Baseline) ÷ |Baseline| × 100. Ratio is Current ÷ Baseline. Their neutral points are 0, 0 and 1 respectively. See the 520-versus-500 example.

Why does a comparison show N/A?

Some results are mathematically undefined, especially percentage change or ratio with a zero baseline. N/A is distinct from missing input and numeric zero. Review the chosen policy for cases where both current and baseline are zero.

Can I compare two periods?

Yes, when the current and baseline values are prepared as two value columns or two matrices. There is no separate automatic workflow that picks two periods from one measure. Check category alignment and the chosen baseline before interpreting differences.

What can Time & Calendar show?

It groups dated or timed records into layouts such as weekday by hour, month by day or other calendar periods. Count events or aggregate a numeric measure. Check the date grouping and first-day-of-week options; imported timestamps are not automatically converted between time zones.

How do I read a confusion matrix?

Rows are actual classes and columns are predicted classes. Diagonal cells represent correct predictions. Inspect counts before normalized views, and read metrics in the context of the class distribution. HeatMapster analyzes supplied predictions rather than training a classifier.

Projects and sharing

What is the difference between a project and a template?

A .heatmap project lets you continue working with the imported data, analysis and presentation. A .heatmaptemplate reuses a setup without embedding that dataset and needs compatible fields from the new source.

Does Refresh Source update automatically?

No. Refresh Source is an explicit operation that you review after the source file changes. It is not continuous synchronization with a live online data source.

Which export formats are available?

Export images as PNG or JPEG, scalable graphics as SVG, documents as PDF, spreadsheets as Excel and presentations as PowerPoint. Copy Image provides a clipboard image. See the export guide for practical choices.

Can I edit the result in Excel?

Excel export preserves numeric values. Exact appearance uses static cell colors; the editable option uses Excel’s native color scale. A complex custom palette may be simplified, so inspect the workbook before sharing it.

Why are labels too small in an export?

A large matrix fitted into a small image or one printed page leaves little room per cell. Increase output dimensions, choose a tiled PDF or slide layout, or present a focused subset. Check the exported file at its intended viewing or print size.

Do filters remove sensitive data from a shared project?

No. A project may include the complete imported dataset, including records excluded by a filter. Excel export with raw data can include those records too. Inspect the saved or exported file and share only data your audience should receive.

Privacy and support

Where is my data processed?

Import, analysis and export are performed locally on your Windows PC. The application also uses Microsoft App Center Analytics and Crashes for usage statistics and crash diagnostics. These are separate from dataset processing; read the HeatMapster privacy policy for details.

Does uninstalling delete my projects and exports?

Uninstalling does not delete source files, projects or exports you saved outside the application’s data folders. Delete those files separately if you no longer need them.

Where can I get help?

Use the built-in Help and context-sensitive F1, follow the tutorials, or visit Support. Include the application version, the steps you took and the expected result. Use a small synthetic example when possible, and remove personal or confidential data from attachments.