Product line
Local workbook tools that turn field activity into structured source records for procurement intake, material traceability, pipe tally, pressure test, weld/NDE, drawing, and closure package workflows.
.png){kind=logo}
Suite launch point
The operational start point for each AFE. The Hub gives teams one controlled entry point for product launch, shared resources, license validation, and consistent project folder structure.
Procurement intake
The first step for bringing SAP Crystal procurement status report data into the suite. The helper converts a known .rpt layout into a structured CSV that downstream tools can trust.
Procurement cleanup
The second step for procurement status report intake. PSR Sanitizer strips pricing and unneeded fields, gives the file a ready-state suffix, and reshapes the CSV into a readable table with headers.
Material accountability
The backbone of the suite. Master Material List ties procurement data to the project BOM so item balls, PO lines, heat numbers, serial numbers, manufacturers, quantities needed, and quantities ordered can be checked from one place.
MTR/CoC intake
Planned OCR support for reading Material Test Reports and Certificates of Compliance. The goal is to capture heat numbers plus PO and line references from known manufacturer layouts into a clean CSV.
Pipe installation records
Captures project-wide pipe information once, then generates individual pipe tally forms by grouping designated pipe properties that match the required tally structure.
Pipe tally output
The required output form used by Master Pipe Tally. The template stays beside the master workbook so grouped pipe data can populate the project-submittal tally form without retyping.
Pressure test records
A field-facing Project Box form that users can complete normally, with a Power Query collection sheet behind it for pulling pressure test data into other FlowCTRL workflows.
As-built inputs
Assigns pipe and components to IFC drawing pages. Pipe entries use joint numbers from Master Pipe Tally, while components use item balls from Master Material List so PO, heat, and serial data can flow into drawing-ready records.
Weld tracking
Consolidates project weld information in one place for easier input and audit. The weld bank becomes the source for daily weld reports and connected weld tracking workflows.
Weld mapping
Assigns weld numbers to drawings using batch numbers from Central Weld Bank, then auto-populates WeldID and welder stencil data for faster checking.
Daily reporting
A Project Box form that pulls weld information from Central Weld Bank by NDE date. The report completes yes/no fields from source entries instead of asking the inspector to rebuild the same status checks.
Pilot planning
For beta access, module questions, or project fit review, contact FlowCTRL, LLC.