PHX OpenCap · Field Workbook Ecosystem
A symbiotic pair: the Chrome exporter captures FieldCap; the Slide Sheet workbook turns that pack into plan vs. wellbore guidance, costs, fatigue, and morning EMAIL — without leaving the pad’s spreadsheet.
The product is the pair
FieldCap already knows the job. Excel already runs the well. OpenCap closes the gap — capture in the browser, decisions in the sheet — so lunchtime copy-paste stops owning your directional day.
OpenCap\ folderBrowser for capture. Workbook for decision. Same job folder. Same truth. That split is the product.
Five moves · zero archaeology
The workbook folder is the integration bus. No reporting database. No second platform to learn on tour.
Log into FieldCap. Stay in the job you’re running.
Confirm Job ID, tick the CSV set, write into the workbook’s OpenCap folder.
Setup / Data / DD Tools import the newest files and merge into hidden _OC_* tables.
Surveys, plan, proximity dial, BURR, and Comments slide advisor on the Slidesheet.
EMAIL HTML + corridor PNG — the dial you drilled by matches the picture you send.
Part 1 · Chrome intake valve
FieldCap does not expose every useful field on one public endpoint. The exporter combines three techniques so the pack is complete enough for the pad.
Job, crew, BHA, inventory, ActivityLogs, and tickets — pulled with your active browser session.
Intercepts FieldCap’s own traffic for hour and metric fields that never show up on public endpoints.
Reads the live BHA grid when the UI holds the truth — then normalizes into typed CSVs.
| Export | Role in the workbook |
|---|---|
| Job details | Identity, contacts, land, rig, directional constants → Setup |
| Crew / personnel | Names, emails, phones, roles → Setup crew manifest |
| BHA equipment | Serials, hours, metres, fatigue → DD Tools + Data motors sync |
| Inventory | Tool status and hour fields for job tooling |
| Slide / rotate by day | ActivityLog-derived daily metres per BHA — matches FieldCap’s Slide Sheet tab |
| Ticket costs by day | Calendar daily ticket totals → Costs form / Costs sheet (CSV wins on match) |
Part 2 · Standalone .xlsm cockpit
Once CSVs are in, the workbook is fully usable offline. You do not need the extension open to project the bit, paint the proximity dial, edit costs, or send EMAIL.
Job identity, geometry, contacts, crew, OpenCap file status, Import Plan / AC, REFRESH / REBUILD.
BHA selectors, slide/rotate/circ hours, serial-hour fatigue with high-hour emphasis.
Ops KPIs, motors, day-roll, AC concerns, TD calc, toolbar: EMAIL · Mini · Full · Costs · REFRESH.
Modeless calendar form over hidden Costs — OpenCap ticket totals stay authoritative on refresh.
Joint paste → bit depths; doubles/triples/triple-half stands; sidetrack sheets on demand.
Part 3 · Directional console
The Slidesheet is where measured depth marches down the page — plan targets beside you, live projections from the last survey to the bit, and Comments that tell the directional hand what to do next stand.
Plan center, survey marker, projected-to-bit. Gravity mode (Inc ≥ 5°) for UP/DN + LT/RT; magnetic mode near vertical with PRP distance.
Waypoint TVD corridor and lateral budget feed both the dial and the emailed corridor PNG — one vertical story with Data’s wellbore position.
Active target → build-up rate required → metres to slide / remain to rotate → required TF → Comments like Sliding 12.25m @ L90 · BURR 2.40, corrected by |cos(TF)|.
End-of-run archives Data to a well-named PDF, clears day fields, clones a fresh Slidesheet — no “Copy of Copy of FINAL v3.”
Light fixed-width HTML of the ops block people already know, plus a full corridor PNG attachment — not one crushed megaimage.
Corridor renderer shares plan/proximity helpers with the on-sheet gauge. The dial you drilled by and the picture you emailed do not disagree.
Protection-aware unprotect/work/reprotect, flicker-free screen guards, shortcuts for new Slidesheet and PDF when gloves are on.
Who ships with it
Slidesheet guidance, pipe tally, day roll, motors on location — offline after refresh.
EMAIL + corridor PNG, Mini/Full text, costs calendar that stays tied to FieldCap tickets.
A consistent morning package without spreadsheet archaeology or “final_final_v7.”
HTML they can read in Outlook; PNG when they want the spatial story at full size.
Adopt in an afternoon
Independent, unofficial, MIT-licensed. Not affiliated with PHX Technology or FieldCap — built to make their data portable into the sheet that already runs the well.
OpenCap\.src/chrome-extension/ unpacked.Slide Sheet - Demo.xlsm (enable macros).OpenCap\.Ship the morning package
Pull authoritative ops data once. Guide with the same plan maths that paints the dial. Email a body people can read and a corridor they can trust.