Analyzing a fleet one device at a time takes time and makes differences between vehicles harder to find. This update expanded Secure GPS tools for reviewing GPS statistics and activity summaries for multiple devices, while also exporting results in a structure suited to combined analysis or individual delivery.
Users can select several devices, review their activity over the same date range, and download all statistics in one Excel workbook or multiple workbooks organized inside a ZIP file. The improvement supports operational closeouts, performance comparisons, exception documentation, and distribution of information among responsible teams.
Select multiple devices for the same analysis
The workflow starts by selecting the devices to compare and a common period. Secure GPS processes statistics and the activity summary for each device based on information received during that interval.
Applying the same date range to several devices creates a consistent reference. A supervisor can compare a shift, week, or monthly closeout without manually repeating the query for every vehicle.
Download all selected statistics
Previously, downloads focused on the visible statistic for all devices or the analysis of one device. The new function can include all available statistics for selected devices and lets the user choose how files are organized.
This flexibility serves two different needs: consolidating information to analyze the fleet as a group or separating results for individual delivery.
Option 1: one consolidated Excel workbook
In the single-file mode, Secure GPS generates an Excel workbook where each sheet represents a different statistic and selected devices appear together. This structure supports comparison because fleet data is grouped under the same categories.
It is a good choice for analysts and coordinators who need to filter, sort, or summarize several devices in one document. It also simplifies storage when one file per period is preferred.
Option 2: multiple Excel workbooks inside a ZIP
In the multiple-file mode, Secure GPS downloads a compressed ZIP file. It contains a separate Excel workbook for each device, and every workbook organizes the different statistics in individual sheets.
This structure is useful when each driver, branch, customer, or manager should receive only the file for a specific device. It also helps keep separate records without manually splitting a consolidated workbook.
How to choose between one file and multiple files
- One consolidated file: best for comparing devices, preparing general indicators, and working as a team from one source.
- Multiple files: best for distributing results, separating responsibility, or archiving each device individually.
- ZIP: makes many workbooks easier to download and transport as one package, but it must be extracted before opening each Excel file.
The choice does not change source information; it changes how the output is organized for the next workflow.
Activity summary for multiple devices
The second improvement lets users select multiple devices and review the activity summary for each one at the same time. The view brings period indicators together to provide an overview and simplify comparison without opening a separate page for every device.
Depending on compatible data availability, the summary can include distance traveled, generated alerts, sensor time, estimated fuel consumption, movement time, and other activity indicators.
Decisions the summary can support
- Distance: compare travel or recorded activity over the same period.
- Movement: identify devices with more or less operating time.
- Alerts: recognize devices with concentrated events that need review.
- Sensors: analyze active time when trackers transmit those variables.
- Fuel: review available estimates or measurements to find differences that require validation.
The summary helps teams prioritize. When an indicator differs from expectations, the user can continue with history, the map, or a more detailed report to investigate the cause.
Real-world applications in fleet operations
- Monthly closeout: generate a consolidated file for administration and separate workbooks for each manager.
- Route comparison: review activity for vehicles that performed similar tasks.
- Exception control: locate devices with more alerts or unexpected activity.
- Equipment monitoring: review sensors and usage time for machinery or assets.
- Customer delivery: distribute one file per device without manually separating data.
- Planning: use differences in distance and movement as input for assigning resources.
How to review and export statistics for several devices
- Open the Secure GPS statistics or activity summary area.
- Select the devices that will be included in the analysis.
- Define the date range and confirm the applicable time zone.
- Review the combined summary and identify indicators that require detail.
- Choose the consolidated download when analyzing the fleet as a group.
- Choose multiple files when a separate workbook is needed for each device.
- Verify a sample of sheets and values before distributing or archiving the output.
Indicator quality and availability
Results depend on information received by Secure GPS. Coverage, reporting frequency, installation, GPS accuracy, calibration, and sensor compatibility can affect distance, time, fuel, and other indicators. Missing data does not always mean there was no activity.
The number of devices, period length, and number of statistics also affect generation time and file size. User permissions, plan, and tracker capabilities determine which devices and variables can be queried.
Functional summary for users and integrators
The update added bulk statistics export for selected devices with two output contracts: one consolidated Excel workbook, with a sheet per statistic and devices combined; or a ZIP with one workbook per device and one sheet per statistic. It also enabled simultaneous activity summaries for several devices, with indicators such as distance, alerts, time, sensors, and fuel when data is available.
Explore Secure GPS plans and features to compare devices, analyze fleet activity, and share results with less manual work.