Excel BoQ — any layout
ShippedHeaders detected automatically. Customer template? Industry template? Internal mess? All handled.
FEATURES · 118 CAPABILITIES · 84 SHIPPED
Eleven chapters of capability — from drag-and-drop ingestion to recursive composition trees, from live marketplace queries to GDPR-grade compliance. Each item is colour-coded by status. Search the page for a specific capability or scan the chapters end-to-end.
01 — INGEST
Excel, PDF, DWG, scanned drawings, photos. We read your existing format — no transcription, no template wrestling.
Headers detected automatically. Customer template? Industry template? Internal mess? All handled.
Memórias descritivas, cadernos de encargos, datasheets — text-extraction first, OCR fallback for scans.
Caderno de Encargos parsed into structured sections (PaddleOCR + LLM synthesis). Each section linked to BoQ lines.
YOLOv11-driven block detection counts luminaires, sockets, equipment — automatically.
PaddleOCR for documents that arrived as photos or scans rather than native text.
Drag a folder with mixed formats. Everything lands in the same project workspace.
Postal code, currency, deadline, multi-trade flags — drives downstream pricing and supplier resolution.
Every project gets a workspace for its files — drawings, specs, contracts, photos, exports. EU-hosted, tenant-isolated, encrypted at rest. Quota varies by tier (2 GB Free, 25 GB Starter, 100 GB Pro, 500 GB+ Enterprise). Soft warning at 90 %, 14-day grace at 100 %, read-only mode after — never destructive.
Upload supplier or client meeting recordings (mp3/m4a/wav/ogg/webm/aac/flac/opus). Local Whisper large-v3 transcribes on EU GPUs (no third-party API). Local Ollama qwen3 LLM extracts structured PT-PT minutes: decisões, acções (responsável + prazo), pontos discutidos, citações verbatim. Auto-creates tasks in obra_tasks tagged with origem=reuniao. 2 h/mo Starter, 20 h/mo Pro, unlimited Enterprise.
02 — AI ESTIMATION
Local AI inference on EU GPUs. Your historical estimates train your private model. No third-party LLM API ever sees your data.
Qwen3 family running on local GPUs. Zero data leaves the EU perimeter. No OpenAI / Anthropic / Google API calls.
Each customer has a private vector namespace. Two contractors using bidyou.ai see different recommendations because they had different histories.
768-d sentence-transformers (mpnet) map descriptions in EN/PT/ES/FR to your historical codes regardless of input language.
Dictionary-based first (75% top-1 accuracy from your history alone), semantic vector search on the remainder.
Picks the right historical article + components + labour for each line.
Not a generic template. Your accepted bids define what 1 metre of cable + 1 hour of electrician costs in your projects.
Every match comes with a score: exact SKU, brand+spec, fuzzy semantic. Low-confidence rows are flagged for review.
Hover any AI suggestion → see the source obras, the line numbers, the date. No black box.
Dictionary → text-canonical stats → semantic search → LLM. Only escalate when the cheaper signal is exhausted.
Every line your estimator accepts, edits or overrides is logged with reason; the per-tenant model updates from your accumulated history. The text dictionary refreshes weekly (130k+ mappings, 75% top-1 accuracy at baseline). The system you use this month is sharper than the one you used last month.
AI predictions logged in parallel to production (lpr_excel_ia, orc_item_ia, obras_ia_metricas) without touching live data. Foundation for backfill comparisons, model versioning, A/B testing of cascades.
Describe a project in natural language → get a BoQ draft. Tools call your DB and ChromaDB to compose the response.
Flags BoQ lines that don't satisfy the CE — e.g., LSZH required, PVC found.
"Cabo X appears with caixa Y in 87% of past bids → suggest Y." Catches the items the tired estimator forgets.
Closes the continuous-learning loop above. Once a job is finished, the actual cost is captured and compared with the original estimate; the model learns where it under-estimated, where it over-estimated, and adjusts coefficients for the next bid of similar profile.
Hover → "€18.40 based on 23 similar obras, median €17.90 ± €2.30; supplier X charged €18.10–18.90 last 4 times". Receipts everywhere.
03 — COMPOSITION DEPTH
Activities recursively contain materials, sub-activities, labour and equipment-hours. Battle-tested at scale on heavy-construction contracts. Electrical contractors use the materials+labour subset; civil/multi-trade unlocks equipment-hours.
Materials, labour, equipment-hours, and sub-activities live as the same composition row schema.
Currently up to 6 levels deep; configurable to 20+ on the roadmap to support deeply-recursive civil works.
Change a leaf material price → all parent activities recompute on save. SQL-CTE driven, no batch recalc.
Single screen with materials / sub-activities / labour grids inline (no popup wizards).
DAG validation prevents A → B → A loops at the database layer.
"1 light-point = 8m cable + 1 box + 1 switch + 0.3h labour" → BoM generated from parameters at design time.
Replaces hardcoded trade boundaries with explicit `is_activity + category` flags. Habilita civil/HVAC/plumbing beyond electrical.
`E.01.001`, `C.05.012` — aligns with DIN 276, NRM, OmniClass, MasterFormat conventions per market.
One combobox component to insert any code anywhere. Ranking: this-bid > your-history > canonical DB > companion items > semantic.
Compute internal cost-per-hour for owned heavy plant: acquisition + depreciation + fuel + operator.
04 — QUOTE ENGINE
Live retailer queries plus your private supplier database. Region-aware, confidence-scored, ranked by total cost delivered — not sticker price.
KuantoKusta, Worten, PCDiga, Würth PT, AKI, Leroy Merlin live in PT. UK / DE / US retailers rolling out.
Your loaded price lists queried first. Your private pricing wins on tied items.
Project postal code drives shipping zone, currency and tax regime. No surprise conversions at checkout.
Unit + shipping + lead time + stock-out risk. The cheapest item that arrives in 3 weeks loses to the slightly pricier one in stock locally.
Repeated lookups instantaneous. Respects retailer rate limits.
Exact SKU / brand+spec / fuzzy semantic. Low-confidence flagged.
Try a search without signing up. Rate-limited 5/min/IP. Sign up free for unlimited.
Where a retailer participates in an affiliate network, the link is decorated with disclosure. No price markup.
Live on /marketplace/ — type "cabo 4x25mm²" or "tomada Schuko" and see five real options.
"Buy in week N vs week N+8 saves €X with confidence Y%." Combines historical prices with project schedule.
05 — SUPPLIER WORKFLOW
Load price lists. Fan out RFQs. Capture replies inbound by email. Auto-discover new suppliers from the responses you didn't know existed. Big drawings go through audited share-links — no WeTransfer, no Dropbox.
XLSX, CSV, PDF. Merged into your private supplier catalogue.
Group BoQ lines by supplier, send parametric quote-request, get Excel exports per supplier. Filters to material + subcontracting items only (activities are internal composites). Explicit supplier-group priority ranking respected first; falls back to AI category.
When the BoQ + drawings package exceeds email attachment limits, generate per-supplier ZIP + download link (password-gated, 1–30 day expiry, max-uses anti-abuse) and a matching upload drop-zone for the supplier's response. Full audit log per access (IP, user-agent, timestamp, view/download/upload). Each supplier gets a unique link — sharing it does not compromise others. Replaces WeTransfer / Dropbox in the quote flow; everything stays inside the tenant and counts toward your storage quota.
Suppliers reply by email; bidyou.ai parses headers + bodies + attachments → links to your RFQ. 47% match rate without any manual curation.
New suppliers found in inbound replies are surfaced for one-click promotion to your supplier list. 315 candidates discovered from 5568 historical messages.
Per-supplier 24-month / 12-month / lifetime stats: top materials, top obras, average response time. Form 22 pattern: grid top + detail panel with tabs (Details / Emails / Groups / History / Communications).
One supplier, N email addresses. General email (synced from ERP if integration is on) plus up to 3 contacts from ERP plus unlimited manually-added emails. One default per supplier used in RFQ dispatch.
Explicitly declare which suppliers serve which BoQ groups (material / subcontracting) with priority 1–99 (1 = primary). Quote dispatch picks suppliers using these associations before falling back to AI category matching. Result: orçamentista's explicit ranking is respected.
Tenants with PHC ERP get suppliers synced from PHC daily at 04:30 (3475 suppliers synced at Sotecno reference deployment, 0 errors). SIOGO-only fields (categoria, observações, group associations, manual emails) preserved across syncs. tenant_integration_config declares PHC as master of supplier dataset → ERP-owned fields render read-only in UI.
Side-by-side response evaluation, currency-normalised, confidence-scored.
Push estimates as CSV/XLSX with column mapping configured once per ERP. Works with any system that imports tabular exports — Sage, QuickBooks, Primavera, Odoo, Excel-driven workflows. Pro and Enterprise.
Customer hands over the target ERP schema once; bidyou.ai's local LLM generates the field-mapping and transformation code, validated against a sample dataset. Onboarded per tenant. Enterprise only.
Bidirectional sync: Forms 44/45 cost calculation, tblClients CRUD, native PHC SQL Server connector. Reference deployment: Sotecno-Gaio. Enterprise on-premise only.
For ERPs without a CSV/XLSX export path or where bidirectional real-time sync is required (SAP, Primavera, dedicated APIs). Scoped on consulting basis. Enterprise by request.
06 — ESTIMATOR WORKFLOW
Review, adjust, ship. Every AI suggestion shows its receipts. Audit-grade history. Sanity checks before the bid leaves the building.
Single-screen layout: BoQ + composition + supplier responses + AI suggestions side-by-side.
AI draft vs your edits, per-line. Override with reason capture (feeds the RL loop).
Every CUD operation captured with: entity, entity ID, project, action, field, before/after values, user, IP, user-agent, endpoint, microsecond timestamp. Multi-row form edits grouped in a batch for atomic review and reversion. Retention configurable.
Sliding panel of every batched change to a project: time · who · description · N changes. One-click revert on any batch that hasn't been reverted yet. Click to expand the batch into individual changes (which field, before/after). Keyboard shortcut Ctrl+Shift+H or statusbar button.
Pre-bid red flags surfaced: missing labour rows, unusual price outliers, drawings without spec coverage.
Per-obra task list with templates. Personal notes scoped to user. Templates carry across projects.
v1.0, v1.1, v1.2 with diff between revisions. Rollback any change.
Cross-checks DWG block detection against CE / spec to flag missing items.
Drag v2 of a drawing → "+12 luminaries floor 3 → +€340". Hash-based identity already in place.
Row-level locks + version columns for teams editing the same project simultaneously. Workaround until shipped: divide sections among estimators.
07 — OUTPUT
Excel preserving the customer's template. PDF bid-ready. CSV for downstream tools. JSON for ERP integrations. Annotated drawings.
Preserves the layout your client uploaded. Or use the canonical bidyou.ai layout if you started fresh.
Bid-ready, branded per tenant. Printable with company header / logo / footer.
Lean format for downstream pipelines.
Every UI feature has an API endpoint. Pull projects, lines, suggestions, exports programmatically.
Pre-built printable reports: summary by trade, summary by supplier, labour breakdown, comparison vs target.
Original DWG / PDF with detected blocks visually highlighted for the customer.
Push estimate to Procore for tenants on Procore. (Not affiliated.)
08 — ACCOUNT & PLAN
3 active projects free. Then €39 (Starter) or €129 (Pro) per month. Or on-premise Enterprise. Annual pays 17% less.
Two fields (email + name) + magic-link activation. No credit card. No trial-expiry trick.
50 marketplace lookups/mo, 1 country, watermark on exports. Plenty for a homeowner pricing a kitchen reno or a freelancer running side jobs.
Unlimited projects on Starter, unlimited lookups + multi-country + batch ingest on Pro.
Toggle on /pricing/. Founding-customer rate locked for first 100 paid signups.
Your hardware (with AI-powered ERP integration — any system via file-based, AI-generated adapter, or bespoke connector) or a dedicated cloud tenant. SSO/SAML, custom model fine-tuning, named technical contact.
Self-service plan changes, payment method, invoices via Stripe portal.
When you hit a Free-tier limit, a soft modal invites upgrade — no abrupt feature lockout mid-flow.
EUR/GBP/USD/AUD by locale. Stripe Tax handles VAT.
Pro and Enterprise — connect your identity provider.
09 — PARTNER PROGRAM
Industry-standard B2B SaaS commission. Real partner portal with login, dashboard, payout history. Apply with one email, get your code, share.
partners@bidyou.ai. We reply within 5 business days with the agreement and your unique code.
?ref=YOURCODE on bidyou.ai or paste at signup. 30-day cookie window with last-click attribution.
On every subscription invoice for 12 months from the customer's first paid invoice.
Refunds within 60 days reverse the commission. After that, your money is yours.
Eligible / pending / paid lifetime totals. Commission rows. Payout history. Bank settings.
Magic-link activation, login, forgot/reset password — separate from customer auth.
Approve partners, generate monthly payout batch (SEPA-ready CSV), mark settled.
Same email domain / IP / payment method = void. Documented in agreement.
Auto-generated statement on each payout. Sent to partner with bank reference.
10 — SECURITY & COMPLIANCE
EU-hosted on operator-owned infrastructure. No third-party LLM ever sees your data. DPA available before first project upload. Quarterly external scans.
Production servers in Estoril, Portugal — operator-owned, not on AWS / Azure / US cloud. No FISA 702 / CLOUD Act exposure.
Per-customer DB schema, vector store namespace, file path. Cross-tenant access impossible by design.
AES-256 at rest. TLS 1.2+ AEAD-only ciphers in transit. Keys rotated annually.
Inference runs on local Qwen3 family. Your bids never reach OpenAI / Anthropic / Google.
Transactional email signed and aligned. Resend EU as transactional sender.
External vulnerability scans of the public attack surface. The operator is already PCI-compliant.
Daily authenticated vulnerability scanning against production. CVSS-prioritised remediation.
File integrity monitoring, log aggregation, MITRE ATT&CK rules, 12-month log retention.
Independent third-party offensive assessment. Executive summary on request under NDA.
Article 28 Data Processing Agreement template available before first project upload.
Versioned at /legal/subprocessors/. 30-day advance notice on any addition.
Schema designed for ISO 27001 event-logging conformance: every Create/Update/Delete on key entities captures user, IP, user-agent, endpoint, microsecond timestamp, field, before/after values. Available to the customer for forensic / compliance review. See chapter 06 for the operator-side History Ribbon UI.
Policies, runbooks, BCP/DR, asset inventory, risk register — foundation for ISO 27001.
Entry-level technical-controls cert for UK gov + corporate procurement.
Full ISMS audit including physical site. Pursued when revenue justifies the audit cost.
Gated to US-market entry strategy. Pursued when a US-customer pipeline justifies it.
11 — MARKETS
English-language UI from day one. Portuguese and Spanish for native speakers. UK / DE / US marketplaces rolling out as model coverage matures.
Default. The full estimating workspace works end-to-end in English.
Full coverage — the engine speaks Portuguese natively given its lineage.
i18n scaffolding ready, translations partial. Full coverage planned.
i18n ready, translations rolling out.
Tied to multi-trade rollout (DIN 276 alignment).
Wickes, Screwfix, Toolstation. Tied to Cyber Essentials Plus cert window.
Bauhaus, Hornbach, Obi.
Home Depot, Lowe's via affiliate networks. Tied to SOC 2 cert window.
START FREE
Free forever for 3 active projects. No credit card. No trial-expiry trap.
Tiered pricing kicks in only when you upgrade.
✓ You're on the list. We'll be in touch shortly.