Agency SemiAnnual – LDARtools

What this report does

Summarizes component activity, inspection counts, Delay of Repair (DOR) status, and leak rates for a selected date range — typically a six-month regulatory period. The output is a pivot table with one row per metric label per unit and component type, with one column per month.

The report is designed for semi-annual regulatory submissions under HON (Hazardous Organic NESHAP) and similar regulations. For each unit and component type, it shows how the component population changed month by month, how many inspections were performed and by which classification (DTM, NDE, UTM, or other), how many DORs were open, and how many leaks were found — culminating in a monthly Leak % and (in HON mode) a monthly DOR %. Components with a physical state of Heavy Liquid and components with an Exempt monitoring frequency are excluded from all counts. This report is in the Compliance folder on the Reports tab.

When to use it

Preparing the semi-annual compliance report for a regulatory agency covering HON or similar regulations.
Verifying monthly component counts, inspection tallies, and leak rates before filing.
Confirming that DOR activity is correctly reflected in the Leak % calculation for the selected regulation and period.
Reviewing TUx, DTM, NDE, and UTM classifications across months before submission.

Parameters

Parameter	Description	Required	How it filters
Regulation	The regulation to report on	Yes	Only components with an active rule binding for this regulation are included.
Unit Type	Whether to filter by Process Unit or Location Unit	Yes	Determines which Unit list populates; defaults to Location Unit
Units	One or more units to include	Yes	Only components in the selected unit(s) appear; one output section per unit
Comp Types	One or more component types to include	Yes	Only components of the selected type(s) appear; one output section per type within each unit
Inspection Type	The inspection method to count	Yes	Determines which inspections populate the inspection rows and Leak %; typically M21 for regulatory submissions
Include DORs in Leak %	Whether to include DOR counts in the Leak % formula	Yes	When Yes, uses the DOR-adjusted Leak % formula; when No, Leak % is calculated from leaks and inspections only (see How key values are calculated)
Is HON	Whether to apply HON-mode Leak % logic	Yes	When Yes, applies the DOR% threshold rule for Valves and adds the DOR % row; when No, uses standard Leak % logic
Start Date	First day of the reporting period	Yes	Months are built from this date forward through the End Date
End Date	Last day of the reporting period	Yes	The period spans from Start Date through End Date, covering one month per column

Note on Include DORs in Leak % and Is HON: These two parameters interact. If Include DORs in Leak % = Yes, Is HON defaults to No — the DOR-adjusted formula is applied uniformly across all component types without the HON valve threshold rule. If Include DORs in Leak % = No and Is HON = Yes, HON mode activates: DORs are excluded from the Valve Leak % when the DOR% is below 1% of the total valve count, and included when at or above 1%. A separate DOR % row appears for Valves in HON mode.

Note on date range: The report produces one column per calendar month between the Start Date and End Date. For a standard semi-annual period, use January 1 – June 30 (first half) or July 1 – December 31 (second half). The report supports other date ranges — including cross-year periods — but is typically run as a six-month period for regulatory submissions.

Rows

The report output is organized by Unit and Type. Each Unit × Type combination produces its own block of rows, labeled in the Description column. The row set differs by component type: Valve shows a full set including classification and inspection breakdowns; all other component types (Pump, Connector, Compressor, etc.) show a reduced set.

Rows shown for all component types

Description	What it shows	Notes
Beginning Count	Active components at the start of the month.	"Active" excludes deactivated components
Added / Reactivated Count	Components that became active during the month	Counts components newly added or returned from deactivated status
DeActivated Count	Components deactivated during the month
Total Count	Active components at the end of the month
TUx Count	Components in TUiS or TUP status at any point during the month	Temporarily Unavailable — includes both TUiS (Temporarily Unavailable - In Service) and TUP (Temporarily Unavailable - Purged)
Total Inspections	Components that had an inspection of the selected type during the month	Used as the denominator in Leak %; for Valve type this equals the sum of the four inspection classification rows below
Total DOR	DORs open at any point during the month, tied to the selected regulation	A DOR is counted if it was approved on or before the last day of the month and was not closed before the first day of the month
Leaks	Components with a new leak found during the month	Misidentified leaks (MisId) are excluded
Leak %	Leaks as a percentage of Total Inspections — see How key values for DOR adjustment	Shows 0 if Total Inspections = 0
Missed First Attempts	Leaks opened during the month where the first repair attempt was not made by the required deadline	Includes leaks with no attempt on record past the due date
Missed Final Repair	Leaks opened during the month where the final repair was not completed by the required deadline	Includes open leaks past the final resolution due date

Additional rows shown for Valve type only

Description	What it shows	Notes
DTM Count	Active Valve components with a Difficult to Monitor (DTM) designation at end of month	Only for active DTM components whose DTM frequency has not been canceled
NDE Count	Active Valve components with a No Detectable Emissions (NDE) designation at end of month
UTM Count	Active Valve components with an Unsafe to Monitor (UTM) designation at end of month
All Others	Total Count minus DTM, NDE, and UTM components	Valves that are active but not in any special monitoring category
DTM Inspections	DTM-designated Valves that had an inspection during the month	DTM property set to Yes and DTM frequency not canceled
NDE Inspections	NDE-designated Valves that had an inspection during the month
UTM Inspections	UTM-designated Valves that had an inspection during the month
All Other Inspections	Valves not in DTM, NDE, or UTM status that had an inspection	Together with the three rows above, sums to Total Inspections
DOR %	(HON mode only) Total DOR as a percentage of Total Count	Only appears when Is HON = Yes; used to determine whether the DOR threshold is met for Valves in the Leak % calculation

Overall Leak %

At the bottom of each unit section, the report displays a bold Overall Leak % row showing the weighted Leak % across all component types in that unit for each month. This is calculated as the total leaks across all types divided by the total inspections across all types for the unit.

What's included and excluded

Included:

Components with an active rule binding for the selected regulation during the relevant month.
Components in the selected unit(s) and component type(s).
All inspections of the selected type that fall within each month's date window; Cooling Tower inspections are excluded from all inspection and leak counts.

Excluded:

Components with a physical state of Heavy Liquid — excluded from all rows.
Components whose monitoring frequency for the selected regulation is Exempt — excluded from all rows.
Rejected (archived) components.
Leaks classified as Misidentified (MisId) are excluded from the Leaks row and from the Leak % calculation.

How key values are calculated

Component counts

Beginning Count and Total Count are snapshots: Beginning Count is taken at the start of the month; Total Count is taken at the end. Added / Reactivated Count and DeActivated Count reflect profile status transitions during the month. A component that transitions to Active during the month is counted in Added / Reactivated regardless of how many times its profile changed within that month.

DTM, NDE, and UTM counts are end-of-month snapshots. All Others is derived by subtracting DTM, NDE, and UTM from Total Count — it represents components that are active but carry no special monitoring designation.

TUx Count captures any component that held a TUiS or TUP profile at any point during the month, not just at month end.

Total DOR

A DOR is counted in a given month if it was approved on or before the last day of that month and was either still open or was closed on or after the first day of that month. The DOR must be linked to the selected regulation via the regulation's historical assignment record. Cooling Tower inspections do not qualify a component for DOR inclusion.

Leaks

The Leaks row counts distinct components with at least one non-MisId leak opened during the month. The leak must have been detected by an inspection of the selected type and associated with the selected regulation (for M21 inspections; for other inspection types, the regulation filter on leaks is not applied).

Leak %

Standard mode (Include DORs in Leak % = No, Is HON = No): Leak % = (Leaks / Total Inspections) × 100

DOR-adjusted mode (Include DORs in Leak % = Yes, Is HON = No): Leak % = ((Leaks − Leaks Also With DOR + Total DOR) / Total Inspections) × 100

"Leaks Also With DOR" is the number of leaks in the month that were also on a DOR during the month. Subtracting them and adding Total DOR replaces the component-level leak count with the DOR count, giving a DOR-weighted rate.

HON mode (Is HON = Yes):

For all component types other than Valves, the DOR-adjusted formula is applied.

For Valves specifically, the DOR % for that month is compared against 1% of the total Valve count. If the Valve DOR % is below 1%, the standard formula (no DOR adjustment) is used. If the Valve DOR % is at or above 1%, the DOR-adjusted formula is applied. A separate DOR % row appears in the Valve section showing the Valve DOR % for each month. The DOR % row does not appear for other component types.

If Total Inspections = 0 for any month, Leak % shows 0 for that month.

Missed First Attempts and Missed Final Repair

Missed First Attempts counts leaks opened during the month where the first monitoring attempt after the leak date occurred after the required first-attempt deadline — or no attempt has been made and the deadline has passed.

Missed Final Repair counts leaks opened during the month where the final repair was completed after the required repair deadline — or the leak remains open past the deadline.

For both rows, leaks with an approved DOR on or before the deadline are not counted as missed.

Tips and common questions

"What's the typical setup for a HON semi-annual submission?" Set Include DORs in Leak % = No, Is HON = Yes, Inspection Type = M21, and enter the first or second half of the calendar year as the date range. The DOR % threshold logic for Valves will be applied automatically.
"The DOR % row is not showing." The DOR % row only appears when Is HON = Yes. If you are running in standard or DOR-adjusted mode, set Is HON = Yes to enable it.
"A component I expect to see is missing." Confirm the component is not Heavy Liquid physical state and does not have an Exempt monitoring frequency for the selected regulation. Also verify the component has an active rule binding for the selected regulation during the months in question.
"The DTM, NDE, and UTM rows are not showing for my Pump or Connector type." The DTM, NDE, and UTM classification rows — and the corresponding inspection breakdown rows — are displayed only for the Valve component type. For all other component types, the report shows the core count, inspection, DOR, and leak rows only.
"My Leak % is higher than expected." Check whether Include DORs in Leak % is set to Yes — when set, the formula adds DOR counts to the numerator, which can raise the Leak % even if the raw leak count is low. Switch to Is HON = Yes (with Include DORs in Leak % = No) to use the HON threshold rule for Valves instead.
"Missed First Attempts or Missed Final Repair seems too high." These rows count leaks by when they were opened, not when the deadline passed. A leak opened in January that missed its 60-day repair deadline in March will still appear in the January row.
"Cooling Tower inspections are not counted." Cooling Tower inspections are excluded from all inspection and leak counts in this report. If a component was only inspected via a Cooling Tower inspection during the month, it will not contribute to any inspection or leak row.

Sample output

The report is organized by Unit and Type, with one block per component type per unit. Month columns display the calendar month name. (Example Unit ALKALYZATION, MACT-VVa, January–June 2022, Is HON = No, Include DORs in Leak % = No).

What the rows illustrate:

Valve — stable component count: Beginning Count and Total Count hold at 909 every month throughout the period, with no additions or deactivations (Added / Reactivated Count = 0, DeActivated Count = 0 in all months).
Valve — TUx Count in March, April, and May: 37 valves carried a TUx (Temporarily Unavailable) status during each of these three months, then returned to zero in June. TUx Count tracks components in TUiS or TUP status at any point during the month; it does not reduce Total Count.
Valve — DTM/NDE/UTM rows: All three special-classification counts are 0 throughout the period. All Others equals Total Count in every month (e.g., January: 909 − 0 − 0 − 0 = 909), and all inspection activity falls into the All Other Inspections row.
Valve — inspection concentration in March and June: 872 inspections were recorded in March and 909 in June, accounting for nearly all inspection activity in the period. January and February each had only 1 inspection; April had 10 and May had 23.
Valve — Leak % = 1.03 in March: 9 leaks found out of 872 inspections = 1.03%. The high inspection count in March drives the denominator up, yielding a low leak rate despite 9 leaks.
Valve — Leak % = 10.00 in April: 1 leak found out of 10 inspections = 10.00%. A small inspection count in April means a single leak produces a notably high leak rate compared to March.
Valve — Leak % = 0.11 in June: 1 leak found out of 909 inspections = 0.11%. With the full population inspected in June, a single leak results in the lowest non-zero leak rate of the period.
Valve — Total DOR: DOR counts increase gradually across the period (1 in January–March, 2 in April–June), reflecting DORs that were approved and remained open, independent of whether new leaks were found in a given month.
Overall Leak %: The row at the bottom of the unit section shows the weighted leak rate across all component types for the unit each month. Because only VALVE is included in this run, Overall Leak % matches the VALVE Leak % exactly for each month (0.00%, 0.00%, 1.03%, 10.00%, 0.00%, 0.11%).

Output format

Suitable for on-screen review, PDF export, and Excel download. Rows are grouped first by Unit, then by Type within each unit. Each unit section closes with a bold Overall Leak % row showing the weighted rate across all component types for that unit.

Month columns are labeled with the calendar month name. Percentage rows (Leak %, DOR %) display decimal places only when the value is not a whole number — for example, 100 not 100.00, and 45.45 where the decimal is significant. Count rows display whole numbers.

Related reports

Periodic Inspection Summary — a more detailed per-month breakdown that includes component subtype and physical state; use when your regulatory submission requires finer component classification detail.
Component Count Change — focused on component count changes by unit and regulation; use when you need only the count data without inspection or leak rate rows.
Simplified Leak History — shows individual leak records with DOR columns appended; use to look up the specific leaks contributing to the Leaks row in any given month.
DOR Summary — lists each open DOR individually with approval and close dates; use to verify the DORs counted in the Total DOR row.
HON Leak Report — calculates the HON valve leak rate in the aggregate format used for skip-period eligibility; use alongside this report when a skip-period determination is being made.
"The report comes back empty." The most common cause is a mismatch between the Regulation and Unit Type parameters. Confirm that the selected units have components mapped to the selected regulation and that monitoring activity was recorded during the period.