Generate reports and sheets

Using the Report sheets button, the user can generate sheets, report and charts for the calculated location again. Sheets are always generated in accordance with the result configuration.

Report Options Dialog

When you click the "Report sheets" button, a dialog appears allowing you to configure all reporting options before generating the report. This dialog provides centralized control over what data is included and how it is formatted.

File Range Selection

The dialog includes a range slider that allows you to select which files to include in the report:

• Use the left handle to set the starting file
• Use the right handle to set the ending file
• Only data from files within the selected range will be included in the generated sheets

This is useful when you have a long measurement session but only need to report on a specific time period.

Movement Filter

The dialog also includes a Movement filter. Uncheck any movement that should not be included in generated reports.

• The history, speed, ALPR, CO2 and other history-based report sections exclude trackers that contain an unchecked movement.
• Quantity sheets split multi-movement tracker rows first, so the checked movement can still be counted while unchecked movements are omitted.
• Leaving all movements checked is the same as using no movement filter.

Available Options

The Report Options dialog allows you to configure:

Option	Description
Vehicle Classification	Choose the classification method (GPR, Euro-6, SCPR, etc.)
History Sheet	Enable/disable generation of full tracker history
Movement Filter	Include or exclude selected traffic movements from generated reports
Quantity Grouping	Set the time period for grouping results (15 min, 30 min, 1 hour, etc.)
Main Category	Select the primary category for quantity sheets
Sheet Layout	Choose between different output formats
Velocity Sheet	Enable/disable speed measurement results
ALPR Sheet	Enable/disable license plate recognition results

After clicking OK, all settings are saved to the configuration and the report generation begins with the selected options.

Output Types - History

• History.csv - a sheet with the entire history of all objects (correct and incorrect) and all parameters determined for each tracker. Each passage occupies one row. A tracker counted in multiple movements is split into subrecords linked by TUID, with subtuid numbered from 0.

The is_counted column states whether the row contributes to quantity reports. validation_reason contains the stable validation status code:

Validated	validation_reason	is_counted
0	Unknown	false
1	Validated	true
2	AreaUncounted	false
3	RelationUncounted	false
4	CrosssectionUncounted	false
5	Cargo	false
6	LabelUncounted	false
7	ValidatedMerged	true
8	MultiValidated	true
9	MergedUncounted	false
255	Invalid	false

Types of output data - Quantity

• Quantity.csv/xlsx - Sheet with the result data of quantitative counting. See output sheet formats in Output configuration.
• *.png - quantitative charts in user and hour grouping,
• Report.docx - a fragment of the report concerning quantitative results, average daily traffic, peak hours, etc. is added.

The daily traffic chart highlights the busiest 60 minutes in three parts of the day: morning peak (06:00–10:00), midday peak (10:00–15:00), and afternoon peak (15:00–19:00). Each hour is selected as the busiest four consecutive, complete 15-minute intervals within its search window. Bars are split by movement color and present traffic in 15-minute intervals by default.

Quantity sheet layouts

Currently supported layouts are:

• Csv - flat CSV output.
• XlsxEntrances - one Quantity.xlsx workbook with one sheet per entrance.
• XlsxEntrancesHorizontal - one Quantity.xlsx workbook with one sheet per entrance and horizontal movement tables.
• XlsxEntrancesVertical - a Quantity.xlsx workbook with vertically stacked GPR-standard tables for consecutive 15-minute intervals. Tables group movements by entrance and turn (Zaw, L, P, W), show pedestrians separately for each entrance, and append a summary table for the automatically selected peak hour (four consecutive intervals).

For intersection configurations that include pedestrian crossings, the XlsxEntrances and XlsxEntrancesHorizontal layouts also append dedicated crossing sheets at the end of Quantity.xlsx (one sheet per crossing).

The crossing sheet title uses a configurable prefix (for example translated in UI), followed by crossing id.

Legacy note: the old MultiXlsxEntrances layout has been removed. Existing old configs that used legacy value 3 are automatically mapped to XlsxEntrances.

Output Types - Speed

• Velocity.csv - A sheet with the history of each vehicle and the measured speed of movement.
• *.png - speed (scatter) and average speed charts,
• Report.docx - a fragment of the report is added regarding speed results, average speed depending on the "grouping category", limit violations, accuracy and correctness of counting.

Types of output data - ALPR

• Alpr.xlsx - A sheet with the history of each vehicle, read license plate and photos of plates and vehicle location.
• *.png - graph of the accuracy of ALPR measurement and statistics of letter codes and countries,
• Report.docx - a fragment of the report concerning ALPR results, measurement accuracy, letter codes and countries is added,