Python OPS v0.9.18

Active Jobs

0

Jobs in Approved or Active status

Job Templates

0

Total job setups created

Stages Reported

0

Phase 2: Stage_Reporting

Invoice Ready

$0

Well_Flow_SUM output

Well_Flow Process Flow

Job_Template

→

Stage_Reporting

→

Post_Job

Job_Ticket

QC_Reconciliation

→

Well_Flow_SUM

→

Invoicing

Build Status

Module	Status
Login / Security (shared with FOAM)	Ready
Job_Template (Phase 1)	Ready
Stage_Reporting (Phase 2)	Shell
Post_Job / Job_Ticket / QC	Phase 2
Well_Flow_SUM / Invoicing	Planned

Job_Template

Create the master job setup that feeds all downstream modules.

Phase 1 • Ready

Stage_Reporting

Capture stage-level operational and product usage inputs.

Phase 2 • Shell

Well_Flow_SUM

Totalize product usage and financials for invoicing.

Planned

Job_Template Setup

Customer

Job Number

Pad

County / State

Number of Wells

Planned Stages (Pad Total — auto)

Fleet

Job Status

Est. Start Date

Wells on Pad

Each well has its own API/AFE, Planned Stages, and Casing & Completion. Capacity (bbl/ft) is looked up from the API casing chart by size + weight and drives Flush Volume on that well's Post Frac Report. Pad total stages auto-sum above.

Customer Logo (for PFR & Job Ticket)

Upload Logo

Planned Products

Proppant, chemical, and acid planned here flow into per-well and per-pad product totals, on-location inventory, and invoicing.

Charge Structure

Include products on Job Ticket (bill proppant / chemicals / acid at unit prices)

Service Charges — bill each line By Stage or Hourly, independently

ChargeBasisRate / Amount

Per-stage flat subtotal: $0.00

Pump-Hour Rate Grid — by Avg HHP (proppant)

HHP MinHHP MaxAvg PSIRate $/hr

Used by any Service Charge whose basis is “Pump-Hour (HHP grid)”. The rate is chosen by the stage’s Avg HHP while pumping proppant.

Allow pump-time credit adjustments for stage issues (credited against hourly & pump-hour lines)

Each service line bills on its own basis — e.g. Pump-Hour Rate hourly while Monoline and Environmental bill per stage. Pump-hour rate comes from the HHP grid by the stage’s Avg HHP while pumping proppant.

Job Notes

Job_Template Purpose

This module is the master source of truth for customer, well, pricing, planned products, planned stages, and job assumptions. Everything downstream (Stage_Reporting, Post_Job, Job_Ticket, QC, and Well_Flow_SUM) is keyed to the Job created here.

Recent Templates

No job templates yet.

Active Jobs

Job #	Customer	Pad	Wells	Fleet	Status	Stages	Actions
No jobs yet. Create one in Job_Template.

Stage_Reporting

Job / Pad

Well

Stage #

Date

WITSML File(s) (.xml — add multiple if the stage was split)

Drag & drop WITSML .xml file(s) here, or browse.
Multiple files combine into one stage (e.g. shutdown for weather / electronics).

Charts / Screenshots (.png — add multiple)

Drag & drop PNG images here, or browse.

Review & Approve Draft

Load a WITSML file to review time and product totals.

Parsed From WITSML

Drop a WITSML file to auto-extract stage data (well, formation, volumes, proppant, chemicals, pressures, shut-ins, and the pump schedule) for the Job Ticket, Post Frac Report, and QC.

Reported Stages

Job	Well	Stage	Status	Charts	Actions
No stages reported yet.

Audit_Center

Well Tolerance ±%

Awaiting Audit

0

Approved, not yet audited

Approved

0

Sent to Invoice Rollup

Flagged

0

Discrepancy vs Job Log

Job	Well	Stage	Reports	Audit	Actions
No approved stages to audit yet. Approve a stage in Stage_Reporting to send it here.

The technical specialist reconciles each stage's Post Frac Report and Job Ticket against the FOAM Job Log, then signs off. Only audited stages advance to Post_Job.

Audit Workspace

Select Audit on a stage to reconcile its reported figures against the FOAM Job Log.

Post_Job Center

Phase 2. Compiles completed job/stage data into the customer-facing post-job package.

QC Center — Reconciliation

Tolerance ±%

Stages

0

With WITSML data

Flagged

0

Outside tolerance

QC Signed

0

Reviewed & signed

Pending

0

Awaiting QC

Job	Well	Stage	Proppant Δ	Chem Δ (worst)	QC Result	Signed	Actions
No stages to reconcile yet.

QC compares Design (plan) → Metered (WITSML) → Actual (treater). A stage flags when Actual differs from Metered or Design by more than the tolerance. Sign off to lock QC.

Well Flow Product SUM — On-Location Inventory

Pad / Job

Products

0

On the Job Template

BOL Deliveries

0

Recorded for this pad

Wells Debiting

0

With approved usage

Short Products

0

Used > delivered

Inventory On Hand

BOL deliveries credit inventory; each well's approved usage debits it. On Hand = Delivered − Used, per product (names from the Job Template).

Product	Category	Delivered (BOL)	Used by Wells	On Hand	Unit
Select a pad to view inventory.

Record BOL Delivery

Product

Quantity Delivered

Unit

BOL #

Delivery Date

Attach BOL

Date	BOL #	Product	Delivered	Doc
No BOL deliveries recorded for this pad yet.

Proppant reconciles in the product's unit (ton/lb/MT/sacks are converted automatically); chemicals/acids reconcile in gallons (bbl converts at 42 gal/bbl).

Well Flow Invoice Rollup

Job

Approved Stages

0

Approved in Audit Center

Wells

0

With approved stages

Invoiceable Total

$0

Service + product

Total Proppant

0

Tons pumped (actual)

Job	Well	Stages	Proppant (ton)	Service $	Product $	Total $	Actions
No approved stages yet. Approve stages in Stage Reporting to totalize them here.

Totalizes only approved stages. Each well is invoiced individually; financials mirror the Job Ticket (service always billed, products billed when enabled on the template). Product inventory now lives in Well Flow Product SUM.

Invoice Queue

Show

Draft

0

Ready to send

Sent

0

Awaiting payment

Outstanding

$0

Sent, not yet paid

Paid

$0

Collected to date

Invoice #	Customer	Well	Stages	Total	Status	Updated	Actions
No invoiceable wells yet. Approve stages in Stage Reporting to populate the queue.

One invoice per well. Status moves Draft → Sent → Paid. Totals mirror Well_Flow_SUM and the Job Tickets (service always; products when enabled). Marking an invoice Sent locks in the amount at that moment.

Avg Cost / Stage

$0

Future KPI

Product Variance

0%

Future KPI

NPT Hours

0

Future KPI

Ticket Accuracy

0%

Future KPI

Analytics Workspace

Charts, trend cards, product analysis, financial performance, and customer KPIs will be added here.

Customer Reports

Customer-facing report exports: post-job summaries, product totals, service summaries, and invoice support packages.

Python OPS v0.9.18

OPS Admin

Well_Flow Process Flow

Build Status

Job_Template

Stage_Reporting

Well_Flow_SUM

Job_Template Setup

Job_Template Purpose

Active Jobs

Stage_Reporting

Parsed From WITSML

Reported Stages

Audit_Center

Audit Workspace

Post_Job Center

QC Center — Reconciliation

Well Flow Product SUM — On-Location Inventory

Inventory On Hand

Record BOL Delivery

Well Flow Invoice Rollup

Invoice Queue

Analytics Workspace

Customer Reports