LPG cylinder bottling carousel controls: tare-weight validation, check-scale rejection, hydrotest interlocks, and distributor deposit ledgers

Topics: lpg bottling carousel tare weight software, gas cylinder management software, downstream oil and gas erp.

High-speed LPG bottling plants running 24-head or 36-head rotary carousels fill 1,200 to 2,400 domestic ($14.2\text{ kg}$ or $15.0\text{ kg}$) and commercial ($19.0\text{ kg}$ or $47.5\text{ kg}$) cylinders per hour. Unlike bulk road-tanker gantry loading (O025), cylinder bottling combines high-hazard pressure-vessel safety (an overfilled LPG cylinder lacks vapour outage space and can rupture hydrostatically under ambient warming) with legal-metrology net-weight enforcement and millions of circulating returnable steel shells. This guide (O115) defines the carousel tare-weight control, check-scale overfill/underfill loop, leak-test evacuation accounting, statutory hydrotest quarantine, and distributor cylinder-deposit ledger architecture.

Scope and governance boundary

This article specifies the PLC/check-scale-to-ERP integration model for LPG bottling plants:

• What this workflow governs: Empty cylinder induction and hydrotest-due quarantine (ISO 10464), tare-weight encoding (OCR/barcode/RFID vs dynamic residual-gas check), downstream check-scale tolerances (OIML R 51), leak-test evacuation mass recovery, shift sphere-to-cylinder LPG mass balance, and distributor empty-for-full shell custody ledgers (ERPNext Serial and Batch Bundle).
• What this workflow does not replace: It does not replace hazardous-area Zone 1/Zone 2 electrical explosion-proof design, physical hydrostatic expansion test rig calibration, gas-detector deluge fire protection interlocks, or statutory weights-and-measures inspector stamping.

1. Step 1 — Record intake & baseline identification: Enforce pre-filling quarantine gates on the conveyor before empty cylinders reach the rotary filling carousel: any cylinder past its statutory periodic hydrotest date ([ISO 10464](https://www.iso.org/standard/33519.html)) or failing tare-stencil legibility must be diverted to the requalification bay.
2. Step 2 — Cross-system reference & custody linkage: Separate carousel filling-head cutoffs from downstream legal-metrology check-scale verification ([OIML R 51](https://www.oiml.org/en/files/pdf_r/r051-1-e06.pdf)); automatically divert overfilled cylinders to an evacuation decant pump (unsafe liquid-full thermal expansion risk) and underfilled cylinders to a calibrated top-up station.
3. Step 3 — Exception quarantine & authority check: Require every filled cylinder to pass both pin/bung leak detection and O-ring joint leak verification before tamper-seal capping; route leaking valves to safe evacuation and brass-valve replacement rather than shipping them to distributors.
4. Step 4 — Verified disposition & audit trail closure: Reconcile shift bulk-sphere LPG mass drawdown against net check-scale filled weight plus evacuated slop-vessel recovery, and maintain a dual-ledger distributor account tracking both **LPG gas mass ($\text{MT}$)** and **returnable steel cylinder shells by test-status bucket**.

Why carousel bottling plants suffer hidden gas losses and safety escapes?

Bottling operations that track only the count of filled cylinders leaving the loading dock experience three costly failure modes:

1. Residual Heel Gas Masked as Fresh Fill or Overfill Hazard: When an empty cylinder returns from a distributor with $0.8\text{ kg}$ of unvaporized heavy C4/butane heel (or water contamination) and the carousel operator keys only the stenciled empty tare weight ($15.3\text{ kg}$) into a net-weight filling head without pre-weighing, the cylinder is overfilled to $15.0\text{ kg}$ liquid payload. Conversely, gross-weight filling heads cut off early, leaving the plant uncompensated for residual gas or shipping heavy liquid-full cylinders if stenciled tare was misread.
2. Unreconciled Evacuation / Decant Loop Losses: Overfilled cylinders and cylinders with leaking SC-valve O-rings or spindle pins are routed to an evacuation manifold to pull LPG back into a slop/re-pressurization vessel. If evacuated gas mass is not metered and credited back against the shift carousel counter, operators cannot distinguish nozzle disconnecting puffs from chronic filling-head drift.
3. Distributor Shell Float and Hydrotest Arbitrage: Distributors return truckloads of mixed-age empty cylinders. Without gate-level segregation of Good Empty, Hydrotest Due (Expired Test Ring Date), and Defective/Spurious Shells, plants inadvertently refill overdue cylinders or absorb unbilled shell replacement costs.

• Primary control scope: lpg bottling carousel tare weight software across operations and connected ERP/EAM records.
• Segregation boundary: Operational status updates never auto-close engineering, safety, or finance sign-off gates.
• Verification cadence: Reconcile open exceptions, overrides, and late adjustments at each shift or period close.

LPG bottling carousel and cylinder ledger control matrix

Illustrative worked example: 8-hour shift LPG carousel mass and shell reconciliation

Illustrative operating scenario with synthetic figures to demonstrate bottling mass balance and shell reconciliation arithmetic; not a client case study or statutory metrology certification.

Consider an LPG bottling plant running an 8-hour shift filling $14.20\text{ kg}$ net domestic LPG cylinders (legal metrology tolerance band: $\pm 0.15\text{ kg}$, or $14.05\text{ kg}$ to $14.35\text{ kg}$ net).

Step 1: Reconcile physical cylinder shell flow across the shift

Step 2: Reconcile shift bulk-sphere LPG mass against filled cylinders and evacuation recovery

1. Net LPG packaged inside the $12,030$ compliant cylinders:
   • The downstream OIML check scale records a shift mean net fill weight of $14.212\text{ kg/cylinder}$ (slight positive cushion of $+12\text{ g}$ to prevent legal-metrology underfill citations): $$M_{\text{packaged_lpg}} = 12,030\text{ cylinders} \times 14.212\text{ kg/cylinder} = 170,970.36\text{ kg}\quad (170.970\text{ MT})$$
2. Bulk storage sphere (SPH-01) net mass drawdown:
   • Opening sphere mass minus closing sphere mass (temperature/density-compensated radar + pressure-differential mass gauge) shows $171,380.00\text{ kg}$ transferred to the bottling pump header.
   • The evacuation/slop recovery vessel (V-SLOP-02) gained $148.50\text{ kg}$ of recovered liquid LPG from decanting the $142$ overfilled cylinders and evacuating the $60$ leaking cylinders.
   • Net bulk LPG consumed by the bottling house ($M_{\text{net_bulk}}$): $$M_{\text{net_bulk}} = 171,380.00\text{ kg} - 148.50\text{ kg} = 171,231.50\text{ kg}$$
3. Shift bottling loss (nozzle disconnect puffs + carousel calibration drift): $$M_{\text{loss}} = 171,231.50\text{ kg} - 170,970.36\text{ kg} = 261.14\text{ kg}\quad \left(\frac{261.14}{171,231.50} = 0.153%\right)$$ Because $0.153%$ is well within the plant's $0.250%$ maximum permissible bottling-loss threshold, the shift mass balance passes automated ERP verification. (Note: Compared against nominal invoice billing weight of $12,030 \times 14.200\text{ kg} = 170,826.00\text{ kg}$, the $+12\text{ g/cylinder}$ check-scale overfill giveaway accounts for $144.36\text{ kg}$ of the total $405.50\text{ kg}$ commercial variance—separating mechanical vent loss from filling-head target cushion.)

Acceptance tests and operational readiness criteria

1. ACT-O115-01 (Hydrotest-Due Pre-Fill Interlock): Given an empty cylinder whose encoded/scanned test-date ring is past its statutory periodic inspection month (ISO 10464), the conveyor PLC/ERP gate must divert the shell to WH-Quarantine-Hydrotest-Due before carousel induction.
2. ACT-O115-02 (Downstream Check-Scale Overfill/Underfill Segregation): Any cylinder exiting the carousel outside the legal-metrology net band ($14.20\text{ kg} \pm 0.15\text{ kg}$) must be physically diverted by the check-scale pusher and blocked from palletization until a passing re-weigh record is logged.
3. ACT-O115-03 (Evacuation Slop Mass Credit & Leak Quarantine): Cylinders failing valve/bung leak detection must be logged through the evacuation manifold before moving to WH-Quarantine-Valve-Change, crediting recovered LPG mass to the slop vessel ledger.
4. ACT-O115-04 (Distributor One-for-One Shell & Deposit Reconciliation): A filled-cylinder delivery note (Delivery Note) cannot release at the dispatch gate unless the distributor's returnable shell ledger records either matching verified empty returns or an approved security-deposit debit voucher.

Next steps

1. Separate mechanical bottling vent loss from check-scale giveaway in ERP shift reports: Capture actual check-scale net weights ($14.212\text{ kg}$) alongside nominal billed weights ($14.200\text{ kg}$) so filling-head drift is visible immediately.
2. Track quarantined cylinders across distinct sub-warehouses: Maintain separate ERP stock bins for Hydrotest-Due, Cold-Repair/Painting, and Valve-Replacement shells so usable empty float is never overstated.
3. Meter the evacuation/decant recovery vessel: Deduct recovered LPG from gross sphere transfers before calculating shift bottling loss percentages.
4. Automate filling-head drift alarms on the 24-head carousel: If any single carousel station accounts for $>15%$ of check-scale overfill/underfill rejects within an hour, lock out that filling head for load-cell recalibration.

Frequently Asked Questions

How do LPG bottling plants control carousel check-scale overfill/underfill rejection, O-ring/pin leak tests, statutory 5/10-year cylinder hydrotest due dates, and distributor empty-cylinder deposits?

Teams should govern lpg bottling carousel tare weight software by linking every transaction to its source evidence, timestamp, and assigned owner before permitting downstream posting. Distinct from O025 (bulk terminal gantry dispatch); O115 covers high-speed LPG cylinder filling carousels, dynamic tare-weight stencil verification, hot-water bath/electronic leak rejection, and expired-test-date cylinder quarantine. Rather than relying on informal spreadsheet overrides, the workflow enforces a documented verification gate and preserves the original observation whenever a correction is recorded.

How does gas cylinder management software handle exceptions and mismatches?

When a discrepancy occurs during gas cylinder management software, the system routes the blocked record into an owned exception queue rather than silently dropping or auto-adjusting the balance. Assigned operational, quality, and finance owners must review and approve exceptions before posting. Each exception retains the original quantity, date, and counterparty reference until the designated reviewer resolves the variance with supporting evidence.

What should teams test before automating downstream oil and gas erp?

Before scaling downstream oil and gas erp, run a bounded pilot using historical records that include partial receipts, late updates, duplicate messages, and rejected lines. Verify that the integration preserves idempotency, maintains a clear segregation of duties between operational entry and financial approval, and produces an auditable trail for every state transition.

Summary and next actions

1. Map the current lpg bottling carousel tare weight software record boundaries, system of record, and named approval owners before changing workflow rules.
2. Separate operational status updates from engineering, safety, or financial disposition sign-off.
3. Validate exception queues, duplicate handling, and cutoff reconciliation in a bounded pilot before production rollout.