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 TEXTURA
Upload a raw Textura "Schedule of Values with GC Line Codes" export. histORACLE finds the right 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 Textura export. histORACLE automatically creates a separate project for each job number found. Fill in project details afterwards.
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
Upload your 3-column SOV export. The app loads every line item exactly as-is and adds sort dropdowns to each row.
No file selected
📊
Or drag and drop your file here
Import raw Textura "Schedule of Values with GC Line Codes" export — no column stripping needed. histORACLE finds the right columns automatically.
LINE ITEMS
0 coded 0 partial 0 uncoded
Show uncoded only
#
CONTRACT DESCRIPTION
SUB PHASE CODE DESCRIPTION
SCHEDULED VALUE
UNIFORMAT
MASTERFORMAT
BID PACKAGE
ESCALATION ACTIVE Contract Date: Current Date: Years Elapsed: Rate: Factor:
SHOW:
COLS:
PROJECT INFORMATION

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

ESCALATION
Defaults to today · adjust to project future
Default 4% · typical 3–6%
ESCALATION FACTOR
Contract date → current date
PROJECT NOTES

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 FROM TEXTURA
Log into Textura (Oracle) or equivalent construction payment management software and export the subcontractor Schedule of Values for your project. This is your raw cost data source.
2
EXPORT FROM TEXTURA
In Textura, run the Schedule of Values with GC Line Codes report and export as Excel (.xlsx). No column stripping or reformatting needed — import the raw export directly into histORACLE.
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.
5
IMPORT YOUR EXCEL FILE
On Step 2 of the wizard, upload your raw Textura 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. Open the Line Items tab and review the Uniformat, Masterformat, and Bid Package dropdowns. MEP trades are straightforward — trades like Masonry may span multiple categories. Use Apply to All in the column headers to code an entire contract at once.
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.

WHY HISTORACLE?

A note from the founder

Our success as construction companies relies heavily on historical data. It is most critical earlier in the design process when there are limited design documents and cost metrics are based primarily on square footage.

Databases are typically formed in Excel sheets and estimating software that auto-adjust estimate line items to match bid results. The issue with this approach lies mainly in unit pricing. Bids can come in under or over budget, but there is no science to find the true variance as it relates to a unit price. A mass adjustment can alter pricing that was actually accurate.

Furthermore, most construction companies capture GMP or bid data in Bid Package format. Once a GMP is finalized, going back to an estimate and making a mass adjustment can alter pricing that was accurate. Take Uniformat as an example — Bid Package 04A Masonry scope can end up in structure, interiors, and envelope. If that package comes in under budget and a GMP-to-estimate adjustment is made, resorting the estimate into Masterformat or Uniformat will skew disciplines that should not have changed.

That is where histORACLE shines. It relies on subcontractor Schedule of Values line items to sort projects into the three most important categories: Masterformat, Uniformat, and Bid Package. Those responsible for reviewing requisitions before approval need to coordinate with the estimating team to understand what line items to look for. The more detail, the better.

The good news is that if a trade contractor prepares their SOV correctly, the line items they bill for naturally follow the estimating buckets that make our historical data flourish. Subcontractor requisition line items are the most precise way to store true bid data — and that is the core of histORACLE's functionality and its true differentiator.

— Michael Parent

CLASSIFICATION REFERENCE GUIDE

Use this guide when classifying line items.

UNIFORMAT — ASTM E1557
Organizes costs by building system
L1L2DESCRIPTIONTYPICAL SCOPE
AA10FoundationsStandard & special foundations, slab on grade
A20Basement ConstructionBasement excavation, walls, slabs
BB10SuperstructureFloor & roof construction, structural steel, concrete frame
B20Exterior EnclosureExterior walls, windows, doors, curtainwall
B30RoofingRoof coverings, openings, skylights, accessories
CC10Interior ConstructionPartitions, interior doors, toilet compartments
C20StaircasesStair construction, finishes, railings
C30Interior FinishesWall, floor & ceiling finishes, tile, paint
DD10ConveyingElevators, escalators, lifts
D20PlumbingFixtures, domestic water, sanitary waste
D30HVACHeating, cooling, distribution, controls
D40Fire ProtectionSprinklers, standpipes, fire protection
D50ElectricalService, lighting, communications, security
EE10EquipmentCommercial, institutional, kitchen, gym equipment
E20FurnishingsFixed & moveable furnishings, casework
FF10Special ConstructionSpecial structures, special purpose rooms
F20Selective DemolitionBuilding demo, hazardous abatement
GG10Site PreparationClearing, demolition, earthwork
G20Site ImprovementsParking, paving, fencing, landscaping
G30Site Mechanical UtilitiesWater, sewer, storm drainage
G40Site Electrical UtilitiesElectrical distribution, site lighting
ZZ10General RequirementsProject management, insurance, bonds, GC
MASTERFORMAT 2020
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
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
COST BREAKDOWN
Filter by: