Pro · first 1 of 5 tasks freeIntermediateTender stage
Estimate data ETL: import, clean and reconcile cost data
Professional course, about 3 h 30, five tasks on the tender cost plan of the fictional Kestrel Point Learning Centre.
Pricing will be announced when the programme opens.
Netherlands · English- 5 tasks
- 5.0 h of study
- Professional certificate
Who this course is for
Invented character and company, drawn for this case
What you will do
Load a subcontractor's CSV export with German number formats, read the importer's warnings, remove a duplicate row and reconcile to the offer total; map an ambiguous workbook so the plan carries net rates; convert kilograms to tonnes and mesh to square metres with the rates; bring a 2024 price list in pounds to 2026 euros; and take in a revised offer by Position ID instead of appending it. Every figure is checked in the ERP.
You will be able to
Skills checked
- Import a subcontractor's CSV or Excel offer into the cost plan and read the importer's warnings
- Find duplicate rows and reconcile imported totals with the sender's subtotals
- Map ambiguous spreadsheet columns so the cost plan carries net rates
- Convert units, currency and price date together so line totals stay true
- Bring a revised offer in by Position ID and report the change
Tasks
- 1Import a subcontractor's offer: read the warnings, remove the duplicate, reconcile the totalBOQFree
- 2Map the columns yourself: description, net rate, and what to leave outBOQ
- 3Units: a schedule in kilograms, a cost plan in tonnes and square metresBOQ
- 4Currency and price date: a 2024 price list in pounds into a 2026 cost plan in eurosBOQ
- 5A revised offer: update in place, never append, and report the changeBOQ
Certificate
Awarded when all 5 tasks pass the numbers, trace and explain checks. The free tasks give a progress badge, not the certificate.
5.0 h of study
Files you work with
Created in your OpenConstructionERP workspace the moment you enrol.
- project
- parties4 records
- BOQbill of quantities5 lines
- Documentsdrawings and model5 files
The Ashbrook Community Health Centre tender set: drawings with revisions and a model, the same files a contractor's tender team receives.
Before you start
No other course is needed first. You can start with this one.
Questions
How long does the course take?
5 tasks · 5.0 h of study
Is it free?
Pro · first 1 of 5 tasks free. Pricing will be announced when the programme opens.
Do I get a certificate?
Awarded when all 5 tasks pass the numbers, trace and explain checks. The free tasks give a progress badge, not the certificate.
Join the waitlist
What's included
- 16 professional courses on one building, 80 checked tasks
- A professional certificate for each course and 4 track certificates
- The full tender set: drawings with revisions and a model
- The first 1 tasks of every course are free now
Pricing will be announced when the programme opens.
Questions about this course? Write to info@datadrivenconstruction.io