DPGFast
Intelligent DPGF comparator — automated analysis and comparison of supplier price bids for public construction tenders
Discuss a similar projectRéponse courte
DPGFast is a tool developed by Digit-AI that automates the comparison of DPGF priced bills of quantities (Décomposition du Prix Global et Forfaitaire) for construction cost estimators. It imports the Excel files of templates and supplier responses, automatically detects differences (identical, modified, added, removed lines) through a multi-level matching algorithm and a Claude AI agent, then generates professional Excel and HTML exports with comparative statistics. The result: analysis time drops from 2–4 hours to under 10 seconds per lot (−95%).
The challenges of bid analysis
In public construction tenders, comparing supplier price bids is a manual, lengthy and error-prone process
Construction cost estimators manually compare, line by line, Excel files of hundreds of items for each lot of each project. Every new supplier DPGF must be reconciled with the initial template to identify price gaps and added or removed lines — an entirely manual, time-consuming and high-error-risk process.
Manual Excel comparison
Cost estimators compare, line by line, Excel files of hundreds of items, with a high risk of human error.
Heterogeneous formats
Each project uses different formats (6 or 7 columns), making standardized processing impossible.
Added / removed lines
Suppliers modify the DPGF structure by adding or removing lines, making the comparison more complex.
Processing time
Several hours per lot for a manual analysis, multiplied by the number of suppliers and lots per project.
Functional scope
Construction cost estimators, project leads, purchasing management. Covered processes: DPGF file import, multi-supplier comparison, professional Excel and HTML exports, multi-lot batch processing.
Key constraints
Heterogeneous Excel formats (6 and 7 columns) · Merged cells and non-standard structures · Volume of hundreds of lines per file · Docker deployment compatible with Railway and on-premise.
What DPGFast solves
Three areas of improvement to transform the bid-analysis process
Radical time savings
Cut analysis time from several hours to a few seconds per lot by automating the detection of differences between the template and supplier responses.
Reliability and accuracy
Eliminate human errors through a multi-level matching algorithm (code, label, hierarchical context) and automated calculation validation.
Professional exports
Automatically generate professional Excel and HTML exports, with comparative statistics, color coding and embedded comments.
What DPGFast enables
A set of features covering the full DPGF comparison cycle, from import to export
Multi-format import
Support for 6-column and 7-column DPGF formats with automatic format detection. Adaptive AI agent for non-standard files.
Intelligent comparison
Multi-level matching algorithm: section code, line number, label (exact, partial, semantic) with hierarchical context constraints.
Professional Excel export
Excel files with professional design: embedded logo, merged headers, simplified supplier columns and statistics (min, max, average, spread).
Interactive HTML view
Web comparison interface with tooltips on modified fields, color legend and smooth navigation between lots and suppliers.
Claude AI agent
Adaptive Excel-reading agent using Claude Tool Use to analyze complex Excel structures (merged cells, non-standard formats).
Multi-lot batch processing
Automatic import and processing of complete projects with multiple lots, buildings and suppliers through an automated CLI pipeline.
Tech Stack
A modern Python stack optimized for Excel file manipulation and cloud deployment
Backend
Frontend
Excel & Data
Artificial intelligence
Database
Infrastructure
Differentiating pattern — multi-level matching: DPGFast's comparison algorithm is not limited to matching by line number. It combines section code, line number, exact label, partial label, semantic similarity and hierarchical context to precisely identify identical, modified, added or removed lines — even when the supplier has restructured the document.
Architecture Diagrams
Modular backend-oriented architecture with CLI and Web interfaces, a central comparison engine and adaptive AI agents
Measured impact and gains
The gains observed after deploying DPGFast at our clients
| Indicator | Before DPGFast | With DPGFast | Gain |
|---|---|---|---|
| Time per lot (5 suppliers) | 2–4 hours (manual) | < 10 seconds | −95% |
| Human error risk | High (fatigue, inattention) | None (automated) | Eliminated |
| Detection of added/removed lines | Manual, often incomplete | Automatic and exhaustive | 100% |
| Export quality | Manual formatting | Automatic professional design | Standardized |
| Multi-lot processing | Lot by lot, manual | Automatic batch | Automated |
Qualitative gains
Informed decisions
Comparative statistics (min, max, average, spread) enable an objective and fast analysis of supplier bids.
Focus on analysis
Cost estimators focus on interpreting the gaps rather than on manual, line-by-line comparison.
Full traceability
Versioning of comparisons, change history and comments embedded in the exports.
Data security
File validation on upload, protection against SQL injection, secure session-based authentication.
Scalability
Modular architecture allowing new DPGF formats, export types or AI agents to be added without an overhaul.
Professional image
Professionally designed exports with logo, color palette and consistent layout for each client.