Skip to content
Gallery
BidTracker AI at Work Challenge
About this template
Bid Doc and Tracker with AI template
Challenge Checklist
Draft a Bid Doc and Tracker with AI
More
Share
Explore

icon picker
Draft a Bid Doc and Tracker with AI

Create a table with 10 items (replace items in BidTable as needed)
Bid Starter 1
Question
Question 1
Question 2
Question 3
Question 4
1
Who is the lowest bidder?
Which price is out of whack by section (rows) therefore skewing the total price of the contractor?
What is the lowest possible price to buy this project out at? In other words, for each section of the project, take the lowest price, and give the total lowest price.
What is the 2nd lowest price to buy it out at?
What is the 3rd lowest price to buy it out at?
2
​
​
​
​
​
There are no rows in this table
⁠
Sum of Bidder 1:
450
⁠
⁠
Sum of Bidder 2:
440
⁠
⁠
Sum of Bidder 3:
180
⁠
⁠

Sum of Lowest Price Buyout:
390
⁠
⁠
Max of Price Skew:
50
⁠
⁠
BidTable 1
Item
Bidder 1
Bidder 3
Bidder 2
Lowest Bid
Lowest Bidder
Price Skew
Column Sort
1
Paint
100
50
100
50
Bidder 3
50
​
2
Radiation
60
70
50
50
Bidder 2
20
​
3
Piping
50
60
50
50
Bidder 1
10
​
4
Valves
50
​
50
50
Bidder 1
0
​
5
Ducts
30
​
30
30
Bidder 1
0
​
6
Fans
50
​
50
50
Bidder 1
0
​
7
Coils
60
​
60
60
Bidder 1
0
​
8
Finish trim
50
​
50
50
Bidder 1
0
​
There are no rows in this table
⁠
Bid Total prices 350
440
⁠
180
⁠
⁠


Write a bid doc based on Bid Starter

Bid Document

Project Overview

We are submitting this bid for the project as outlined in the Bid Starter document. Our team is experienced in providing high-quality services for similar projects and we are confident that we can deliver the results you are looking for.

Scope of Work

Our proposed scope of work for this project includes the following:
Task 1: [Description of Task 1]
Task 2: [Description of Task 2]
Task 3: [Description of Task 3]

Deliverables

Our proposed deliverables for this project include the following:
(Copy/Paste BidTable 1 Items)
Deliverable 1: [Description of Deliverable 1]
Deliverable 2: [Description of Deliverable 2]
Deliverable 3: [Description of Deliverable 3]

Timeline

Our proposed timeline for this project is as follows:
Month 1: [Description of Month 1 tasks]
Month 2: [Description of Month 2 tasks]
Month 3: [Description of Month 3 tasks]

Budget

Our proposed budget for this project is [insert amount see BidTable 1]. This includes all costs associated with the project, including materials, labor, and any other expenses.

Conclusion

Thank you for considering our bid for this project. We are confident that we can provide the high-quality services you require and we look forward to the opportunity to work with you.
⁠
PriceTable 1
Action
Description
1
Make a column
In
https://coda.io/d/\_doD165rmFx0\#\_tuEYB
⁠
, create a new column with the name "Lowest Bid".
2
Formula
In the "Lowest Bid" column, use the following formula: Min([Bidder 1 Price], [Bidder 2 Price], [Bidder 3 Price]).
There are no rows in this table
⁠

Results Table
Question
answer
Column 3
1
Who is the lowest bidder?
Contact potential vendors for bids
Evaluate bids based on factors such as cost, quality, and reputation
Determine the lowest bidder based on the evaluation results
This is easy See Bidtable 1 low bid total = 180
2
Which price is out of whack by section (rows) therefore skewing the total price of the contractor?
​
see Bidtable 1 Price skew =50
There are no rows in this table
⁠

Buyout Table
Question
Answer
Buyout
Notes
1
What is the lowest possible price to buy this project out at? In other words, for each section of the project, take the lowest price, and give me the total lowest price.
Identify sections of the project
Find lowest price for each section
Add up lowest prices to get total lowest pric
Lowest Buyout = 390
Open
2
What is the 2nd lowest price to buy it out at?
​
see Bidtable 1 2nd Lowest =
Open
3
What is the 3rd lowest price to buy it out at?
​
see Bidtable 1 2nd Lowest =
Open
There are no rows in this table
⁠
Want to print your doc?
This is not the way.
Try clicking the ⋯ next to your doc name or using a keyboard shortcut (
CtrlP
) instead.