Unified JPA Tool · El1te AIO v1
⚡ PG&E JPA package builder
One JPA surface controls PG&E, SCE, FTR/Frontier, and AT&T. The selected entity controls expected documents, output file names, checklist, pole inventory, KML, report, and package manifest.
Project ID
943033-APLG-A-242
Output prefix
Expected Docs
6
Required package roles
Matched Uploads
0
0 file(s) staged
Estimated Value
$825
5 poles × $165
Drop inputs to build the package map
Stage PDFs, XLSX/XLSM, CSV, ZIP, O-Calc outputs, and make-ready forms. The current browser version records file names and builds download-ready manifests, KML, reports, and CSVs.
Complete package manifest
Authority-ready output names, sources, status, and folder plan.
Pole inventory CSV
Pole ID, tag, owner, attachers, class, height, make-ready, and QC state.
Printable JPA report
Cover sheet, expected documents, records, callouts, and submission checklist.
Project KML
Google-Earth ready route + pole markers for field/reference review.
Expected document checklist
PG&E required package roles
Make-Ready Workbook/Form
PGE_APLG_MAKE_READY_AT&T_ADDED_SPACED.xlsx
Match terms: make-ready, xlsx, xlsm
Combined Spaced PDF
PGE_APLG_MAKE_READY_AT&T_ADDED_COMBINED_SPACED.pdf
Match terms: combined spaced make-ready pdf
Individual Item PDFs ZIP
PGE_APLG_INDIVIDUAL_ITEM_PDFS_AT&T_ADDED.zip
Match terms: individual item pdf zip
O-Calc QC Highlighted PDF
PGE_APLG_OCALC_QC_HIGHLIGHTED.pdf
Match terms: ocalc, o-calc, wind, highlighted
QC Callouts PDF
PGE_APLG_QC_CALLOUTS.pdf
Match terms: qc callout, callouts
Full Combined Review Set
PGE_APLG_FULL_COMBINED_REVIEW_SET_AT&T_ADDED.pdf
Match terms: full combined review set
Workflow
JPA production sequence
01
Intake
Load authority, applicant, pole range, job ID, and expected document list.
02
Document Match
Match PDFs, XLSX/XLSM, ZIPs, and O-Calc outputs to required package roles.
03
Pole Inventory
Normalize pole ID, owner, attachments, class, height, loading notes, and make-ready status.
04
QC Callouts
Extract conflicts, clearance concerns, transfer notes, missing data, and O-Calc exceptions.
05
Package Build
Generate final naming, folder plan, CSV manifest, KML, workbook, PDF report, and closeout checklist.
06
Authority Submit
Export submission-ready artifacts and retain a package history for tracker, invoice, and closeout.
Package output plan
Final file names and sources
Make-ready workbook
PlannedPGE_APLG_MAKE_READY_AT&T_ADDED_SPACED.xlsx
AI generated or imported workbook
Combined spaced make-ready PDF
PlannedPGE_APLG_MAKE_READY_AT&T_ADDED_COMBINED_SPACED.pdf
AI generated from records
Individual item PDFs ZIP
PlannedPGE_APLG_INDIVIDUAL_ITEM_PDFS_AT&T_ADDED.zip
AI generated individual item PDFs
O-Calc QC highlighted PDF
PlannedPGE_APLG_OCALC_QC_HIGHLIGHTED.pdf
Imported O-Calc or AI generated QC summary
QC callouts PDF
PlannedPGE_APLG_QC_CALLOUTS.pdf
AI generated QC callout list
Full combined review set PDF
PlannedPGE_APLG_FULL_COMBINED_REVIEW_SET_AT&T_ADDED.pdf
AI generated full review package
Pole inventory
Make-ready and QC records
| Pole | Owner | Attachers | Status | Height/Class | Make-Ready |
|---|---|---|---|---|---|
| APLG-240-001 | PG&E | AT&T / Comcast | REVIEW | 45 ft · Class 3 | Transfer CATV drop; verify comm clearance |
| APLG-240-002 | PG&E | AT&T | READY | 40 ft · Class 4 | No make-ready required |
| APLG-240-003 | Joint | AT&T / Crown Castle | QC HOLD | 50 ft · Class 2 | O-Calc wind note; confirm guying and midspan clearance |
| APLG-240-004 | PG&E | AT&T / Comcast / City | READY | 45 ft · Class 3 | Raise existing fiber 12 inches |
| APLG-240-005 | AT&T | PG&E / AT&T | REVIEW | 40 ft · Class 4 | Missing photo set; field revisit required |