hstORACLE

CONSTRUCTION COST INTELLIGENCE

"The most precise and efficient way to capture reliable job cost data."

PROJECTS

—
1SELECT METHOD
2PROJECT INFO
3UPLOAD FILE
HOW WOULD YOU LIKE TO ADD PROJECT/S?
Choose an import method below. You can always add or edit project details after creation.
📊
IMPORT FROM BILLING PLATFORM ...
Upload a raw Schedule of Values export from your billing platform (Textura, Sage, Procore, etc.). Your export must include at least 3 columns with headers: Contract Description, Line Item / Sub-Phase Description, and Scheduled Value. histORACLE maps the columns automatically and classifies every line item.
✏️
ADD MANUALLY
Enter project info and fill in a blank bid package cost summary. Ideal for projects not in Textura or high-level historical data entry.
📦
BULK IMPORT
Upload a multi-project Schedule of Values export. Your export must include 4 columns with headers: Project Number / Name, Contract Description, Line Item / Sub-Phase Description, and Scheduled Value. histORACLE automatically creates a separate project for each unique Project Number found.
PROJECT DETAILS
Fill in the project specifics. These drive your $/SF and escalation calculations.
COST BREAKDOWN
Enter the final values for the items listed below from the bid summary sheet.
ESCALATION
Defaults to today
Default 4% · typical 3–6%
ESCALATION FACTOR
—
Enter contract date and rate
UPLOAD LINE ITEMS
Your export must include 3 columns with headers: Contract Description, Line Item / Sub-Phase Description, and Scheduled Value. Export directly from your billing platform — no formatting needed. histORACLE maps the columns and classifies every line item automatically.
No file selected
📊
Or drag and drop your file here
Import your raw Schedule of Values export from Textura or equivalent billing software — no column stripping needed. histORACLE finds the right columns automatically.
LINE ITEMS —
0 coded 0 partial 0 uncoded
Show uncoded only
#
SUB PHASE CODE DESCRIPTION
SCHEDULED VALUE
UNIFORMAT L1
UNIFORMAT L2
UNIFORMAT L3
MASTERFORMAT
ESCALATION ACTIVE Contract Date: — Current Date: — Years Elapsed: — Rate: — Factor: —
SHOW:
COLS:
COST & SORT BUILDER
BID DATA
Each bid package's awarded value, matched exactly to the Cost Summary's Bid Package breakdown — plus up to 8 columns for recording every bid received on that package, and a live average across whichever of those are filled in.
PROJECT INFORMATION
No image
Shows at the top of this project's card on the home screen. Automatically resized for storage — large photos are fine to upload.
Total project SF including renovation + new/addition areas
COST BREAKDOWN
Enter the final values for the items listed below from the bid summary sheet.
—
Auto-totalled from imported line items · read only
—
Auto-calculated · Finalized Trade Cost minus SOV Import Total
—
Auto-calculated · Final Contract Value minus General Conditions minus Finalized Trade Cost
ESCALATION
Defaults to today · adjust to project future
Default 4% · typical 3–6%
ESCALATION FACTOR
—
Contract date → current date
PROJECT METRICS
Information can be edited or filled in once project is added. Additional metrics coming soon.
GENERAL / OVERALL
No floors defined
A10/20/40 — SUBSTRUCTURE
Footprint of the building, not total GSF — drives Substructure/foundation cost
Enter a footprint value above to see this project's A-Substructure $/SF Footprint (SOG)
Total project concrete (spans Substructure and Shell Structure — pulled from MasterFormat 03 Concrete, shown here for convenience)
Enter concrete volume above to see this project's $/CY
B10 — SUPERSTRUCTURE
Total structural steel tonnage/weight for the project — used to gauge how "heavy" (and likely costly) the structure is
Enter steel weight (and GSF above) to see this project's LBS/GSF
Enter steel weight above to see this project's $/Ton (pulled from MasterFormat 05 Metals)
B20 — EXTERIOR VERTICAL ENCLOSURES
Enter envelope area to see this project's Envelope $/SFCA
No glazing types defined
No cladding types defined
B30 — EXTERIOR HORIZONTAL ENCLOSURES
Pick this project's actual Roofing bid package — roofing is almost always let standalone, so this gives a clean $/SF
Select a Roofing BP above (and enter Roof Area) to see this project's $/SF of roof
C10 — INTERIOR CONSTRUCTION
Fill in whichever one matches how partitions get priced — linear foot of wall, or square foot of wall surface. Either (or both) is fine.
C30 — INTERIOR FINISHES
D40 — FIRE PROTECTION
Enter head quantity to see this project's Fire Protection $/Head
D20 — PLUMBING
Recommended: count drains and hose bibbs as 1/2 fixture each
Enter fixture quantity to see this project's Plumbing $/Fixture
D30 — HVAC
D50 — ELECTRICAL
D60 — COMMUNICATIONS
Typically includes: DAS, Telecom, Audiovisual, Nurse Call, Public Address, Clock, etc.
D70 — ELECTRONIC SAFETY AND SECURITY
Typically includes: Fire Alarm, BDA/ERCC, Video Surveillance, Access Controls, Intrusion Detection, Video Intercom, etc.
D10 — CONVEYING
Total stops across all elevators/escalators — drives $/Stop for Conveying
Enter stop quantity to see this project's Conveying $/Stop
F20/30 — SELECTIVE DEMOLITION & REMEDIATION
G10/20/30/40/90 — SITEWORK
Enter site acres to see this project's Sitework $/Acre
PROJECT NOTES

⚠ BEFORE YOU START

A quick step that makes auto-classification much more accurate

Auto-classification relies heavily on the contract name. Names that start with the bid package number — for example BP26 Electrical or BP03 Concrete — give it the most to work with.

Rename them in Manage Contracts — each name shows whether it matches as you type. The ⚠ next to that button stays until every contract matches.

HOW IT WORKS

Follow these steps to get your first project into histORACLE — about 10 minutes once your file is ready.

1
RETRIEVE YOUR SOV EXPORT
Log into Textura (Oracle), Procore, Sage, or your construction billing platform and export the subcontractor Schedule of Values for your project. Your export must include at least 3 columns with headers: Contract Description, Line Item / Sub-Phase Description, and Scheduled Value. For bulk multi-project imports, a 4th column is required: Project Number / Name. No formatting or column stripping needed — import the raw export directly.
2
EXPORT AS EXCEL
Run the Schedule of Values report in your billing platform and export as Excel (.xlsx). histORACLE finds the 3 required columns automatically and classifies every line item by Uniformat, Masterformat, and Bid Package. If only a PDF is available, you will need to convert it to Excel first using a PDF-to-Excel converter such as Bluebeam Revu (Export → Excel), Adobe Acrobat (Export PDF → Spreadsheet → Excel), or a free online tool like Smallpdf.com or ILovePDF.com. Once converted, import as normal.
3
CLICK + ADD NEW PROJECT/S
Click the + ADD NEW PROJECT/S button in the top right of the header to open the project wizard.
4
ENTER KEY PROJECT METRICS
Fill in project name, job number, sector, GMP date, total GMP value, GSF, and escalation rate (default 4%). These drive your $/SF and escalated $/SF calculations. Additional project metrics — including structure type, HVAC system, envelope type, project duration, and more — can be edited or filled in at any time after the project is created in the Project Info tab.
5
IMPORT YOUR EXCEL FILE
On Step 2 of the wizard, upload your raw SOV export. histORACLE automatically finds the correct columns and loads every line item. Click CREATE PROJECT.
6
REVIEW & ADJUST THE AUTO-SORT
histORACLE auto-classifies most line items using its built-in keyword library, but every SOV is worded a little differently, so some lines may need correction. Open the Line Items tab and review the Uniformat, Masterformat, and Bid Package dropdowns for each row. Use Apply to All in the column headers to code an entire contract at once when every line in it belongs to the same classification.
7
USE DRAG & DROP FOR FASTER RECLASSIFICATION
For a faster, more visual way to fix misclassified line items — especially when several items across different contracts need to move to the same classification — use the Drag & Drop Reclassify tool, available from the Line Items tab. Select one or more line items and drag them onto the correct Uniformat or Masterformat classification. This is the quickest way to get your baseline sort fully accurate.
8
GET YOUR BASELINE SORT RIGHT BEFORE STARTING CUSTOM SORTS
A Custom Sort in the Cost & Sort Builder tab works from your line items' existing Uniformat classification. If a line item's Uniformat code is wrong, it'll be harder to find when you go looking for it inside a category breakdown. Finish Steps 6 & 7 — a fully accurate Uniformat / Masterformat / Bid Package sort — before moving into Custom Sorts, so you're not troubleshooting two things at once.
9
USE CUSTOM SORTS FOR CATEGORY-LEVEL DETAIL
Once your baseline sort is accurate, open the Cost & Sort Builder tab to break any set of line items into your own categories — for example, splitting Plumbing into Fixtures, Piping Systems, and Equipment, or building a unit price comparison. Name the sort, add categories, and drag line items in (or use the dropdown next to each item). It's a blank slate every time — build whatever breakdown the project actually needs.
✓
YOU ARE FINISHED!
Your project is saved to the repository. The Cost Summary tab shows your full breakdown by Bid Package, Uniformat, and Masterformat with $/SF and Escalated $/SF.
💡 PRO TIP
The more projects you add, the more powerful histORACLE becomes — reliable sector benchmarks built entirely from your own data.

CLASSIFICATION REFERENCE GUIDE

Use this guide when classifying line items.

UNIFORMAT — DETAILED REFERENCE (UF1/2/3)
Every Level 3 code, its typical line items, and what it covers — search to jump straight to a code, material, or keyword
MASTERFORMAT
Organizes costs by trade / product type
DIVDIVISIONKEY SECTIONS
01General RequirementsSummary, admin, quality, temp facilities, closeout
02Existing ConditionsAssessment, demolition, hazmat remediation
03ConcreteForming, reinforcing, cast-in-place, precast
04MasonryUnit masonry, stone, refractory masonry
05MetalsStructural metal, joists, decking, fabrications
06Wood, Plastics & CompositesRough carpentry, finish carpentry, woodwork
07Thermal & Moisture ProtectionInsulation, roofing, flashing, sealants
08OpeningsDoors & frames, windows, hardware, glazing
09FinishesGypsum board, tiling, ceilings, flooring, paints
10SpecialtiesSignage, compartments, lockers, storage
11EquipmentFoodservice, theatre, medical, athletic equipment
12FurnishingsWindow treatments, casework, furnishings, seating
14Conveying EquipmentElevators, escalators, lifts
21Fire SuppressionWater-based suppression, fire pumps
22PlumbingPiping, equipment, fixtures, gas systems
23HVACFuel, piping, air distribution, air cleaning
25Integrated AutomationBuilding automation, BMS/DDC controls, control wiring
26ElectricalLow voltage, lighting, emergency, power generation
27CommunicationsStructured cabling, data, voice, audio-video
28Electronic Safety & SecurityAccess control, surveillance, fire alarm
31EarthworkSite clearing, earth moving, shoring, excavation
32Exterior ImprovementsPaving, site improvements, landscaping
33UtilitiesWater, sewer, storm drainage, electrical utilities

COMPANY STATISTICS

BASED ON FINAL CONTRACT VALUE

PORTFOLIO BREAKDOWN
MORE OPTIONS