85bd99bd-8974-4d66-833b-840530ee58f1.xls
COUNTY(IES)========> ROCK ISLAND- -
AIRPORT============> QUAD-CITY INTERNATIONAL BLANK PRICES 58
LETTING DATE=======> June 15, 2007
ITEM NUMBER========> 009A TOTAL QUANTITY PAY ITEMS 58 TOTAL BID $0.00
STATE NUMBER========> MLI 3623
QU003 >>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> $0.00
NOTES:
1. Each PAY ITEM should have a UNIT PRICE and a TOTAL PRICE.
2. The UNIT PRICE shall govern if no TOTAL PRICE is shown or if there is a
discrepancy between the product of the UNIT PRICE multiplied by the QUANTITY.
3. If a UNIT PRICE is omitted, the TOTAL PRICE will be divided by the QUANTITY
in order to establish a UNIT PRICE.
4. A bid may be declared UNACCEPTABLE if neither a unit price nor a total price is shown.
5. NOTICE Regarding Addenda - It is your responsibility to determine which, if any, addenda
pertains to any project you may be bidding. Failure to incorporate all relevant addenda may
cause your bid to be declared unacceptable. The Department will not be sending addenda
to individual plan holders.
ADDITIONAL NOTES WHICH APPLY FOR THE COMPUTER GENERATED (IDOTCBID)
SCHEDULE OF PRICES:
5. Pay item numbers (PIN), descriptions, unit of measure (U OF M), quantities, and Department
supplied unit prices MUST BE CORRECT and CORRESPOND to the latest
schedule of prices issued by the Department or the bid may be declared UNACCEPTABLE.
6. Insert this computer generated schedule of prices into the bidding proposal directly
in front of the Department issued schedule of prices.
INSTRUCTIONS FOR CBID SPREADSHEET
To fill out Cbid spreadsheet all you will need to do is make sure your cursor is sitting
in the Contractor Number cell, enter your Contractor Number then hit your tab key or
the down arrow, you will then go to the Contractor Name field, fill that in then hit the Tab
key or the down arrow again and you will then be in the Unit Price column to begin entering
the Unit Price that you are bidding.
After you have completed all the unit price entries you will need to hold
down the CTRL key and the letter A for the contract to print.
If there is an addendum you will need to go to TOOLS, PROTECTION,
UNPROTECT SHEET to be able to delete contents of row. Highlight entire row then
go to Edit, Delete, the remaining rows will automatically move up so there will
be no blank lines. To add a row go to the last line of pay items then enter required information.
The formulas will automatically recalculate the number of line items and the Total Quantity.
!!!! DO NOT ADD A ROW IN THE MIDDLE OF SPREADSHEET !!!!
** There will be a separate sheet that will print out first, that has all the
information needed on it, there will be no need to fill it out separately.
You will also need to send it along with your bid, it will now be the first
sheet of the bid. The information on this sheet was previously the last page of your bid.