Bid Tabulation Template

A classic bid tab: each BOQ line priced by three bidders against the engineer’s estimate, with extended totals and the lowest bidder per line.

Sign in with your Edesy account, then click Use template in the preview to copy the base, with its sample rows, into your workspace.

Category

Construction

Tables

Bid tab

Fields

15

Views

grid, dashboard

Tables, columns and sample rows

The table in this template, with its real columns, field types and sample rows. Copy the template to edit it in Edesy Tables.

Bid tab

15 fields · 6 sample rows

  • Bid tab (Grid)
  • Summary (Dashboard)
Item no.TextDescriptionTextUnitSingle selectQuantityNumberEstimate rateCurrencyBidder A rateCurrencyBidder B rateCurrencyBidder C rateCurrencyEstimate totalFormulaBidder A totalFormulaBidder B totalFormulaBidder C totalFormulaLowest rateFormulaLowest bidderFormulaLowest vs estimateFormula
1.01Earthwork excavation in all soilscum1,850.00₹320₹295₹340₹310₹5,92,000₹5,45,750₹6,29,000₹5,73,500₹295A-7.8%
1.02PCC M10 below foundationscum210.00₹5,400₹5,600₹5,250₹5,480₹11,34,000₹11,76,000₹11,02,500₹11,50,800₹5,250B-2.8%
2.01RCC M25 in footings & columnscum960.00₹7,800₹7,650₹7,900₹8,100₹74,88,000₹73,44,000₹75,84,000₹77,76,000₹7,650A-1.9%
2.02TMT Fe500D reinforcementMT118.00₹72,000₹74,500₹71,800₹73,200₹84,96,000₹87,91,000₹84,72,400₹86,37,600₹71,800B-0.3%
3.01AAC block masonry 200 mmsqm4,200.00₹980₹1,020₹1,005₹940₹41,16,000₹42,84,000₹42,21,000₹39,48,000₹940C-4.1%
4.01Mobilisation & site establishmentLS1.00₹4,50,000₹3,80,000₹5,20,000₹4,00,000₹4,50,000₹3,80,000₹5,20,000₹4,00,000₹3,80,000A-15.6%
Field details
Item no. · Text
Description · Text
Unit · Single select
cum, sqm, rmt, MT, nos, LS
Quantity · Number
Estimate rate · Currency
INR
Bidder A rate · Currency
INR
Bidder B rate · Currency
INR
Bidder C rate · Currency
INR
Estimate total · Formula
{Quantity} * {Estimate rate}
Bidder A total · Formula
{Quantity} * {Bidder A rate}
Bidder B total · Formula
{Quantity} * {Bidder B rate}
Bidder C total · Formula
{Quantity} * {Bidder C rate}
Lowest rate · Formula
MIN({Bidder A rate}, {Bidder B rate}, {Bidder C rate})
Lowest bidder · Formula
IFS({Lowest rate} = {Bidder A rate}, 'A', {Lowest rate} = {Bidder B rate}, 'B', TRUE(), 'C')
Lowest vs estimate · Formula
IF({Estimate rate}, ({Lowest rate} - {Estimate rate}) / {Estimate rate}, BLANK())

Bid Tabulation Template: questions

Yes. Copy the template, then import a .csv, .tsv or .xlsx file into any of its tables and map the columns. Delete the sample rows first if you do not need them.

Yes. An automation runs when a record is created, updated or matches a filter, when a form is submitted, on a schedule or when a date arrives, and can update or create records, call a webhook or post to a connected Slack channel.

Related templates