Bid Comparison Template

Line up subcontractor bids for each work package side by side — price with tax, duration, warranty and score — and award the best one.

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

Packages, Bids

Fields

24

Views

grid, calendar, kanban, form

Tables, columns and sample rows

The 2 linked tables in this template, with their real columns, field types and sample rows. Copy the template to edit them in Edesy Tables.

Packages

10 fields · 3 sample rows

  • Packages (Grid)
  • Bid calendar (Calendar)
PackageTextProjectTextBudgetCurrencyBid dueDateBidsLink to another tableBids receivedCountLowest bidRollupHighest bidRollupLowest vs budgetFormulaAwarded toText
Electrical works — Tower ASkyline Residency₹65,00,00016 Nov 2026Volt Electricals Pvt Ltd, PowerGrid Contractors, Sharma & Sons Electric3₹62,77,600₹71,98,000-3.4%
Plumbing & sanitary — Tower ASkyline Residency₹42,00,00023 Nov 2026AquaFlow Systems1₹44,60,400₹44,60,4006.2%
Facade glazingSkyline Residency₹98,00,00029 Nov 2026Gulf Glass Facades1₹1,05,02,000₹1,05,02,0007.2%
Field details
Package · Text
Project · Text
Budget · Currency
INR
Bid due · Date
Bids · Link to another table
Links to Bids
Bids received · Count
Lowest bid · Rollup
min of Total with tax via Bids
Highest bid · Rollup
max of Total with tax via Bids
Lowest vs budget · Formula
IF(AND({Budget}, {Lowest bid}), ({Lowest bid} - {Budget}) / {Budget}, BLANK())
Awarded to · Text

Bids

14 fields · 5 sample rows

  • Comparison (Grid)
  • Evaluation board (Kanban)
  • Submit a bid (Form)
BidderTextPackageLink to another tableContact emailEmailPhonePhoneBase priceCurrencyGSTPercentTotal with taxFormulaDuration (days)NumberWarranty (months)NumberMaterials includedCheckboxTechnical scoreRatingStatusSingle selectExclusionsLong textQuote documentAttachment
Volt Electricals Pvt LtdElectrical works — Tower A[email protected]₹56,50,00018%₹66,67,00012024Yes4/5Shortlisted
PowerGrid ContractorsElectrical works — Tower A[email protected]₹53,20,00018%₹62,77,60014012Yes3/5Under reviewDG set wiring, earthing pits
Sharma & Sons ElectricElectrical works — Tower A[email protected]₹61,00,00018%₹71,98,00011036Yes5/5Shortlisted
AquaFlow SystemsPlumbing & sanitary — Tower A[email protected]₹37,80,00018%₹44,60,40095244/5ReceivedCP fittings supplied by client
Gulf Glass FacadesFacade glazing[email protected]₹89,00,00018%₹1,05,02,00016060Yes5/5Received
Field details
Bidder · Text
Package · Link to another table
Links to Packages
Contact email · Email
Phone · Phone
Base price · Currency
INR
GST · Percent
Total with tax · Formula
ROUND({Base price} * (1 + {GST}), 0)
Duration (days) · Number
Warranty (months) · Number
Materials included · Checkbox
Technical score · Rating
Status · Single select
Received, Under review, Shortlisted, Awarded, Rejected
Exclusions · Long text
Quote document · Attachment

Form view “Bid submission” asks for: Bidder, Package, Contact email, Phone, Base price, GST, Duration (days), Warranty (months), Materials included, Exclusions, Quote document.

Bid Comparison 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