Airborne Contaminant TWA Ceiling Calculator

Purpose and model boundary

This model combines concentration-and-duration entries into an actual-shift average, a reference-period equivalent, entered-limit ratios, and a separate ceiling screen. It does not contain a contaminant library or decide which occupational exposure limit applies. The user must select a concentration unit and enter current, substance-specific limits from an authoritative source.

Inputs and units

The evaluation mode enables the TWA screen, the ceiling screen, or both. OSHA Table Z-1 screening fixes the TWA reference period at eight hours; custom mode uses the entered reference period. All concentrations and entered limits must use the selected unit consistently because the workbook does not convert among ppm, mg/m3, ug/m3, or fibers/cm3.

Each active table row is assigned either TWA period or Ceiling sample. TWA rows contain a concentration and duration in hours. A ceiling row is treated as a known constant/instantaneous maximum, or as a time-averaged sample that can be compared conclusively only when its duration matches the entered averaging window.

Governing relationships

For TWA row i, the concentration-time dose is:

D_i = C_i × t_i

The combined dose, actual-shift average, and active reference-period equivalent are:

D_total = Σ D_i

C_shift = D_total / T_shift

C_reference = D_total / T_reference

where T_reference = 8 h in the OSHA profile and is user-entered in the custom profile. The TWA utilization is:

TWA ratio = C_reference / TWA_limit

The ceiling calculation selects the largest comparable ceiling-sample concentration:

C_ceiling,max = max(C_j for matching ceiling rows j)

Ceiling ratio = C_ceiling,max / Ceiling_limit

In known/instantaneous mode every complete ceiling row is comparable. In time-averaged mode, only rows whose positive duration exactly matches the active averaging window are comparable; other ceiling rows remain visible but make the screen indeterminate.

Calculation sequence

1. Validate the selected modes, unit, active limits, table rows, and any visible reference or ceiling-window input.
2. Require at least one complete row for every selected screen and require all 12 table slots to be either complete and valid or unused.
3. For a TWA screen, require TWA-row durations to cover the shift length within the workbook tolerance and calculate dose, shift average, reference equivalent, and ratio.
4. For a ceiling screen, identify comparable samples, calculate the maximum and ratio when possible, and preserve mismatched averaged samples as an indeterminate condition.
5. Identify the dominant period and evaluate status in the precedence shown below.

Outputs and interpretation

The reference-period equivalent is the value compared with the entered TWA limit; it is distinct from the actual-shift average when the shift and reference periods differ. Ratios may exceed 100%. The entered duration above the ceiling is only the sum of durations on rows whose entered concentration exceeds that limit; it cannot reconstruct the true excursion duration hidden inside an averaged sample.

The combined result gives precedence to a conclusive at/above-limit finding over an otherwise indeterminate ceiling screen. These results are arithmetic screens, not regulatory determinations.

Validation and status logic

This is the workbook's exact Model_Status precedence. The reached-limit check intentionally precedes duplicate-label, window-mismatch, and extended-shift warnings.

Assumptions and limitations

• Every concentration and limit uses the same selected unit, and every populated row belongs to one calculation purpose only.
• TWA rows must cover the full shift; overlapping or nonrepresentative sampling periods are not detected.
• No OSHA PEL, NIOSH REL, ACGIH TLV, conversion factor, skin notation, mixture rule, excursion limit, respirator factor, or substance-specific exception is embedded.
• The 15-minute OSHA ceiling-window default reflects general Table Z-1 guidance where instantaneous monitoring is infeasible; it may not apply to a particular contaminant.
• Sampling uncertainty, additive-mixture exposure, peak rules, and extended-shift adjustment methods are outside scope.
• The authored concentration ceiling of 1e9 is a computational guardrail, not a health-based limit.

Restrictions and non-computing states

At least one active row is required. Active rows need a label, declared purpose, nonnegative numeric concentration, and valid duration. TWA duration must equal the shift length within 1e-8 h; a time-averaged ceiling sample must have positive duration. Active limits must be positive, reference and shift periods must be greater than zero and no more than 24 hours, and the ceiling window must be greater than zero and no more than 1,440 minutes.

Errors and warnings

NOT VALID means no supported exposure result can be interpreted from the entered state. CHECK preserves arithmetic where possible but identifies a reached limit, duplicate identifier, incomparable sample window, or unadjusted extended shift requiring review. A calculation-service or connection error is not an exposure finding.

The governing equations, exact sample-matching behavior, named outputs, validation rules, and status precedence were verified against the delivered workbook, its published input rules, tests, and reviewer packet. The workbook identifies these technical sources:

• OSHA 29 CFR 1910.1000 — Air contaminants — Eight-hour TWA arithmetic, ceiling interpretation, and the general 15-minute ceiling-sampling footnote.
• eCFR 29 CFR 1910.1000 — Current official regulatory text cross-check.
• NIOSH Pocket Guide introduction — Definitions and cautions distinguishing TWA, ceiling, and short-term exposure limits.