Beta workbook system for Project Box and closure package records

FlowCTRL Suite

Built for pipeline construction teams that need material traceability, pipe tally, weld/NDE, pressure test, and as-built records to match before the package reaches records review.

Request beta access View product line

Built for: Project managers, construction managers, and field inspectors
Records: Project Box and job book deliverables
Method: Enter once, match everywhere

For FlowCTRL, LLC

Build the package while the work is happening.

FlowCTRL Suite is a local Excel-based workflow for projects where closure documentation cannot be fixed by memory at the end. It turns PO lines, MTR/CoC details, item balls, heat and serial numbers, joint numbers, weld numbers, NDE status, PTR data, and drawing references into source records that downstream reports can reuse.

That matters because common records review issues are usually mismatches: BOM to MTR, pipe tally to redline, weld map to NDE reader sheet, daily weld report to welder stencil, and PTR to tested material. FlowCTRL is built to expose those mismatches while the inspector still has the job in front of them.

FlowCTRL, LLC is independent and is not affiliated with or endorsed by Kinder Morgan. Operators and project teams remain responsible for internal review, acceptance, and regulatory compliance decisions.

Closeout control

Make the closure package easier to review.

The suite is organized around the records project managers and records analysts chase at the end of a pipeline job.

Material traceability

Connect PO and line, MTR/CoC, BOM item ball, heat or serial number, quantities ordered, quantities installed, and drawing use.

Weld/NDE consistency

Keep weld numbers, prefixes, suffixes, welder stencils, NDE reader sheets, daily weld reports, weld maps, and qualifications aligned.

PTR readiness

Pair pipe tally and joint-level source data with pressure test list records so PTRs, sketches, and tested material are easier to audit.

As-built support

Build IFC page exports and summary tables from source data so redlines, heat maps, and final as-built inputs tell the same story.

Documentation pipeline

From field source data to review-ready deliverables.

Procurement
Crystal reports, PSR data, PO lines, vendor records, and transfer or field purchase details.
Materials
MTRs, CoCs, BOM item balls, heat numbers, serial numbers, manufacturer data, and quantities.
Field install
Joint numbers, pipe lengths, weld numbers, batch numbers, welder stencils, and NDE status.
Hydro/as-built
Pressure test records, hydro limits, drawing pages, redlines, heat maps, and final install records.
Closeout
Pipe tallies, daily weld reports, lists, CSV exports, and static package deliverables.

FlowCTRL products

Modules that match how the Project Box is assembled.

Each workbook solves a specific records problem, while the suite keeps the same project identifiers moving through the reports that depend on them.

Suite launch point

FlowCTRL Hub

Controlled starting point for workbook launch, licensing, shared resources, and consistent AFE folder structure.

Materials

Master Material List

The suite backbone for BOM, PO/line, item ball, heat, serial, quantity ordered, quantity needed, and installed material tracking.

Pipe records

Master Pipe Tally

Captures project pipe data and automatically completes individual tally forms by matching designated pipe properties.

As-built inputs

Master As-Built Info Log

Assigns pipe and components to IFC drawing pages, then reuses joint and item ball lookups for hydro and final install summaries.

Welding

Central Weld Bank

Consolidates project weld information so weld IDs, welder stencils, NDE dates, and report outputs stay in one source.

Daily Weld Inspection Report product icon

Daily reports

Daily Weld Report

Pulls weld information by NDE date from the weld bank and completes daily inspection report fields from source entries.

Hydro records

List of Pressure Tests

Keeps pressure test list inputs available to pipe tally, hydro, and final package workflows.

Procurement intake

Crystal Export Engine

Retrieves SAP Crystal procurement status report data from .rpt files into structured CSV files for downstream cleanup.

Procurement cleanup

PSR Sanitizer

Removes unneeded cost fields and prepares procurement status CSV files for Master Material List import.

See all modules

Inspector workflow

A field-first workflow for the people actually touching the records.

Inspectors remain in control of the source entries, while FlowCTRL handles grouping, lookups, validations, totals, Power Query summaries, and static export formatting.

Start with the source number the crew already uses: item ball, joint number, batch number, weld number, or PTR number.
Refresh summaries after field entries instead of rebuilding tracking sheets by hand.
Correct PO, heat, serial, weld, or drawing data once and push consistency downstream.
Spot mismatched dimensions, quantities, stencils, and heat numbers before records review.
Generate formula-free deliverables for review, distribution, and closeout.

Material chain PO/LN to MTR/CoC to BOM to drawing

Pipe chain Joint number to tally group to hydro/final

Weld chain Batch number to weld map to NDE/DWR

Review goal: same numbers, same specs, same quantities, same records.

Beta access

Talk through a pilot before the next closeout crunch.

FlowCTRL products are currently in beta. Use the contact below for project manager review, inspector workflow questions, or controlled pilot access.

FlowCTRL, LLC support@flowctrl.pro 205.390.7578