Deadlegs are where integrity programmes quietly fail. Stagnant branches, capped lines, low-point drains and abandoned spools trap water, solids and corrodents, and they are routinely missed by mainstream RBI because they carry no flow. The CorrovIQ Deadleg Integrity Management Toolkit v2.0 gives corrosion, inspection and asset-integrity teams a structured, defensible way to find these threats, rank them, predict how long they have left and drive them to close-out — all inside one Excel workbook, with no software to install and no subscription.

What it does

•Builds a complete deadleg register with one row per location and consistent, dropdown-driven data entry.

•Scores every deadleg automatically using a configurable, weighted model covering configuration, flow, water presence, environment, MIC, inspection condition, consequence and history.

•Screens MIC susceptibility from SRB, ATP, H2S, pH, water, solids and qPCR indicators.

•Predicts remaining life and retirement date from wall-thickness and corrosion-rate data, and flags RETIRE/FFS candidates.

•Cross-checks the risk-based inspection interval against the corrosion-rate life-limited interval and selects the governing one.

•Assigns a mitigation and barrier strategy on an Eliminate > Isolate > Treat > Inspect hierarchy and tracks it to verification.

•Quantifies the cost-benefit and ROI of each mitigation so spend can be justified to management.

•Logs management-of-change and audit decisions for governance.

•Rolls everything up into a KPI dashboard, risk heatmap and a monthly executive report.

Who it is for

Corrosion engineers, inspection engineers, asset integrity engineers, reliability and maintenance teams, integrity consultants and operations leaders responsible for piping and pressure-system integrity in oil & gas, petrochemical and processing facilities.

Why operators choose it

•Works the day you download it — sample data is pre-loaded so you can see every module live.

•Fully formula-driven and transparent: every score traces back to an editable configuration table.

•No installation, no licences to manage, no internet dependency — a single Excel file your team owns.

•Built around recognised integrity practice (risk ranking, RBI logic, FFS triggers, MOC governance) without claiming to replace formal engineering assessment.

What's Included

Deadleg Register

Structured inventory with automated risk score, category, interval and next-due date.

Scoring Engine

Transparent factor-by-factor breakdown behind every risk score.

MIC Monitoring

Corrodent trending and MIC index from biological and chemical indicators.

Remaining Life

Corrosion-rate remaining-life and retirement-date prediction with RETIRE/FFS flags.

RBI Cross-check

Governing-interval logic reconciling risk-based and life-limited inspection timing.

Inspection Planner

Risk-driven inspection scope, priority and due-status tracking.

Action Tracker

Close-out governance with status, ageing and overdue flags.

Mitigation Strategy

Barrier register on an Eliminate/Isolate/Treat/Inspect hierarchy.

Cost-Benefit (ROI)

Risk-reduction value vs mitigation cost with benefit:cost ratios.

MOC Log

Management-of-change and audit trail for integrity decisions.

KPI Dashboard

Live programme metrics including predictive and economic KPIs.

Heatmap & Executive Report

Consequence/susceptibility heatmap and a ready monthly management report.

Config, Data Dictionary, Guide

Editable scoring tables, field definitions and a methodology guide.

Sample Data, Case Study, License

Worked examples, a reference case and clear licensing terms.

Format: Microsoft Excel (.xlsx), 23 worksheets, fully formula-driven. Delivered as an instant download.

Benefits & Outcomes

•       Stop missing deadlegs — capture them all in one auditable register.

•       Defend your inspection priorities with a transparent, configurable risk score.

•       Know which deadlegs are running out of life before they leak.

•       Right-size inspection intervals using risk and corrosion rate together.

•       Justify mitigation spend to management with benefit:cost numbers.

•       Walk into integrity reviews with a dashboard and executive report already done.

FAQ

Do I need any special software?

No. It runs in Microsoft Excel. No installation, add-ins or internet connection are required.

Is this a substitute for engineering assessment?

No. It is a screening, prioritisation and management tool. Formal FFS, inspection codes, company standards and competent engineering judgement still govern final decisions.

Can I change the scoring?

Yes. Every weighting, category and interval lives in an editable Configuration sheet.

Will it work for onshore and offshore?

Yes. The model is built for both, with environment and consequence categories covering sweet/sour, produced water, crude, sludge and emergency routes.

How many deadlegs can it hold?

Up to 300 rows out of the box; the structure can be extended.

Do I get updates?

Buyers of v2.0 receive the current release. Future major versions may be offered as a separate or discounted upgrade.