←Home
Case study

Tawreed
From BOQ to procurement packages

Tawreed turns construction Bills of Quantities into procurement packages. Add a project's BOQs; Tawreed reads them, designs the package structure, places every item in exactly one package, and publishes workbooks ready to send to suppliers and subcontractors for pricing.

In active development · v0.1.0 rebuild · MIT open sourceView on GitHub

The problem

Before a project can be priced by the market, its BOQ has to be split into packages that match how suppliers and subcontractors actually trade: concrete, steel, finishes, MEP and so on.

That split is slow, manual and error-prone. Items get missed or counted twice, totals stop reconciling, and the original BOQ ends up edited along the way.

Tawreed does the reading, planning and placing as fixed steps, and never changes what the BOQ says.

How it works

  1. 01Project

    Create a project and add BOQ files: Excel, CSV, PDF, scanned pages, in English, Arabic or both.

  2. 02Reading

    The AI works out each file's layout; Tawreed extracts the exact values into an item ledger, each item linked to its cell or page. Scanned rows are marked “read from image — verify”.

  3. 03Overlap

    When a new file overlaps existing sources, the engineer decides: addition, replacement or revision.

    Engineer approves
  4. 04Package plan

    The AI proposes packages, with the scope each covers and why. The engineer approves, edits or asks again with a note.

    Engineer approves
  5. 05Assignment

    Every item goes into one package. Uncertain items are shown with the candidates and reasoning; the engineer picks, for this item, the project or all projects.

    Engineer approves
  6. 06Checks

    Tawreed verifies that every item appears exactly once and that package totals reconcile with the source.

  7. 07Publish

    The engineer approves the revision; Tawreed writes all of it at once, or none of it.

    Engineer approves

Structure from AI, values from Tawreed

The AI

  • Works out each file's layout: sheet, header row, quantity column, PDF columns
  • Proposes the package plan, with scope and reasons
  • Places items, and explains the ones it is unsure about

The engineer and Tawreed

  • Item codes, descriptions, units, quantities, rates and amounts reach the outputs exactly as in the source
  • The engineer approves every gate; their own layouts and placements are final
  • Consent is asked before a project's content first goes to an AI provider
  • BOQ text is data, never instructions to the AI

What it publishes

  • A master workbook: cover, package index with item counts and totals, one sheet per package
  • A standalone workbook per package, with or without rates, ready for suppliers to price
  • Live Excel formulas (=Qty×Rate, =SUM) so the workbooks keep calculating
  • A decision log and a coverage check with every revision

First real BOQ

15 sheets · 320 items · 11 packages · totals reconciled to the cent

On its first real project BOQ, every item was placed and every package total matched the source file.

Built with

Python 3.12FastAPISQLAlchemySQLitePydantic AIopenpyxlReactTypeScriptViteTailwindTauri 2 (Rust)

Bring your own AI: Anthropic, OpenAI, Google, xAI or any OpenAI-compatible endpoint.