Python OPS v0.9.79

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

Reps here populate the Job_Template dropdowns and print on the Well Invoice signature block.

Python Invoicing Reps

Name	Actions
No invoicing reps yet.

Python Sales Reps

Name	Actions
No sales reps yet.

Add Customer

Customers here populate the Job_Template customer dropdown and print on the Invoice & Job Ticket.

Customer List

Company	Contact	Address	Terms	Quick Pay	Actions
No customers yet — add one on the left.

Job_Template Setup

CustomerAdd customers in the Customer tab.

Job Number

Pad

County / State

Number of Wells

Planned Stages (Pad Total — auto)

Fleet

Job Status

Est. Start Date

Python Invoicing RepManage in the Python Company tab.

Python Sales RepManage in the Python Company tab.

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.

Job #	Customer	Pad	Wells	Fleet	Status	Stages	Actions
No completed jobs yet.

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.

Stage Tracking

Record each additive's Set Point (concentration) and Clean Rate (BBL) for a stage. Design volume is figured as Set Point × 0.042 × BBL. Add a row for an additive when its set point changes during the stage.

Pad

Well Name

Stage

Select a pad, well, and stage to begin.

Audit_Center

Well Tolerance ±%

Awaiting Audit

0

Approved, not yet audited

Approved

0

Sent to Pad Invoicing

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.

Pad Inventory — On-Location Inventory

Pad / Job Well

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

Carrier

Truck

PO #

Attach BOL

Date	BOL #	Product	Mine	Carrier	Truck	PO #	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).

Pad Invoicing

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 Pad Inventory.

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 — Per-Well Stage Summary

Pad / Job Well

Cumulative-by-stage totals per well from approved stages: Water (gal & bbl, from clean base fluid), each Chemical (gal or lb by type), Proppant (lb), Acid (gal), and average Rate, PSI, ISIP & Frac Gradient. Totals row sums the volumes and averages the pressures/rates.

Select a pad and well to build the summary.

OPS Admin

Well_Flow Process Flow

Build Status

Job_Template

Stage_Reporting

Well_Flow_SUM

Users & Permissions

Python Invoicing Reps

Python Sales Reps

Add Customer

Customer List

Job_Template Setup

Job_Template Purpose

Active Jobs

Completed Jobs (History)

Stage_Reporting

Parsed From WITSML

Reported Stages

Stage Tracking

Audit_Center

Audit Workspace

Post_Job Center

QC Center — Reconciliation

Pad Inventory — On-Location Inventory

Inventory On Hand

Record BOL Delivery

Scan BOL Barcode / QR

Pad Invoicing

Invoice Queue

Analytics Workspace

Customer Reports — Per-Well Stage Summary