iag-posting-analysis

To analyze VDOT IAG Posting Status workbooks for transaction rejection trends, use this Skill to process IAGPostingStatus Excel files and generate agency-level rejection metrics, plate-specific analysis, and trend reports in both markdown and Excel formats.

Tracking toll transaction rejection rates by agency is done by processing IAGPostingStatus workbooks to calculate average and peak rejection rates per agency, identifying which agencies have the highest out-of-state toll transaction rejections over a selected time window.

Yes, you can configure the analysis time window for VDOT IAG rejection reports. The Skill supports configurable periods of 7, 14, 30, 60, or 90 days to generate rejection metrics and trend reports tailored to your specific reporting needs.

To isolate plate-related rejections in VDOT IAG posting data, the Skill performs plate-specific analysis on IAGPostingStatus workbooks, separating plate issue rejections from other rejection types to pinpoint common reasons for out-of-state toll transaction failures.

You need IAGPostingStatus Excel files (IAGPostingStatus*.xlsx) to generate VDOT IAG rejection metrics and trend reports. The Skill processes these workbooks and outputs both a markdown summary and a detailed Excel workbook with the analysis results.

No, this Skill does not require any external dependencies to analyze IAG posting status files. It operates independently using its built-in scripts and references to process IAGPostingStatus Excel workbooks and generate rejection trend reports.