The new Ensolva subsystem enables easy import, publishing, filling out, and analysis of large design Excel cost estimates — even those with thousands of items.
Today, many infrastructure, construction, and engineering tenders include Bills of Quantities (BoQs) containing thousands of line items. These documents often go through multiple revisions, require extensive manual processing, and make bid comparison more difficult. A single incorrect formula or modified row can turn the evaluation process into hours—or even days—of work.
That is why Ensolva developed the Bill of Quantities (BoQ) module—a solution that allows complex Excel-based Bills of Quantities to remain in their familiar format while the system takes care of all the heavy lifting involved in processing, comparing, and analyzing them.
The module can be used for any tender involving complex Excel-based Bills of Quantities (BoQs). Its purpose is to transform these documents into a fast, structured, and fully transparent procurement process—from import and publication to bid submission and evaluation.
Keep Working in Excel as Usual
One of the module’s biggest advantages is that it requires no changes to your existing workflow. Designers and engineers can continue creating Bills of Quantities (BoQs) in Excel using their existing templates and document structures.
Ensolva supports:
More worksheets
Multi-level hierarchies (groups and subgroups)
Multi-line item descriptions
Complex procurement items
Existing formatting (colors, borders, bold, italics, and more)
This preserves the familiar layout of the Bill of Quantities while transforming its data into a structured format ready for digital processing.
Easy Excel Import
Importing an Excel spreadsheet no longer takes hours—it takes just minutes.
During the import process, the system automatically recognizes:
Headers
Item numbers
Structure
Column names
Hierarchy
Based on the detected structure, the system automatically suggests column mapping, which users can simply confirm or adjust if needed. If a required column does not already exist, Ensolva can create it automatically and make it immediately available in the tender.
This significantly reduces the time required to prepare large Bills of Quantities (BoQs).
Suppliers work in the Excel environment they already know
One of the biggest advantages for suppliers is that they don’t have to learn a new way of working.
When downloading a tender, suppliers receive an Excel file that closely matches the original Bill of Quantities (BoQ) prepared by the designer.
This means:
No additional training required
No need to adapt to new templates
Fewer data entry errors
Faster bid submission
While suppliers continue working in the familiar Excel environment, Ensolva automatically captures and stores all data in a structured database, ready for analysis.
Više nema ručnog uspoređivanja verzija troškovnika
In large-scale projects, revisions to Bills of Quantities (BoQs) are almost inevitable.
Instead of manually comparing two Excel files, the system automatically identifies:
New Items
Changed Items
Deleted Items
Suppliers can immediately see which items need to be updated, while previously entered prices are retained for all unchanged line items.
This significantly reduces the risk of errors and speeds up every subsequent round of the tender process.
The Greatest Time Savings Come After Bid Submission
With large Bills of Quantities (BoQs), most of the time is spent not on publishing the tender, but on evaluating the submitted bids.
Ensolva automatically:
Calculates subtotals
Generates summary reports
Compares bids
Prepares analysis
Preserves all data down to the individual line-item level
In practice, this can save several working days on a single tender.
All Data Remains Available After the Tender Is Completed
Unlike traditional Excel spreadsheets, all data is securely stored in a centralized database.
This enables you to:
Analyze pricing at a later stage
Compare supplier bids
Track procurement history
Generate reports
Plan future procurements more effectively
In other words, a Bill of Quantities (BoQ) is no longer just a document for a single tender—it becomes a valuable source of data for future procurement decisions.
Participant | Benefits |
Designers | Continue using existing Excel templates. |
Procurement | Prepare tenders faster and automatically process revisions. |
Suppliers | Complete familiar Excel files without any additional training. |
Executive Management | Gain deeper insights and greater transparency. |
Organization | Reduce errors, shorten tender cycles, and improve data quality. |
Bills of Quantities (BoQs) are often one of the most complex parts of the procurement process. Ensolva’s Bill of Quantities (BoQ) module allows organizations to maintain their existing workflows while automating the most time-consuming manual tasks. The result is faster tender preparation, a smoother experience for suppliers, more efficient bid evaluation, and reliable data to support future procurement decisions. For organizations that regularly manage complex procurement projects, this means less administrative effort, fewer errors, and significant time savings on every tender.
Interested in seeing how Ensolva can support your procurement processes? Contact us to schedule a personalized demo.
