ab749a52-2f25-4f05-8a60-6589f5032ddb.xls <====CONTRACTOR NUMBER CONTRACTOR NAME====> COUNTY(IES)========> COOK-- SECTION============> 2424.2B-R BLANK PRICES 289 LETTING DATE=======> August 14, 2009 ITEM NUMBER========> 1 TOTAL QUANTITY PAY ITEMS 290 TOTAL BID $1,200.00 60D61 <====CONTRACT NUMBER 476,396.320 PIN PAY ITEM DESCRIPTION U OF M QUANTITY X UNIT PRICE = TOTAL PRICE XX003988 TEMP CONC BARRIER REM FOOT 3,136.000 $0.00 2 CONTRACTOR NUMBER 0 CONTRACTOR NAME 0 ITEM NUMBER 1 CONTRACT NUMBER 60D61 THIS IS THE TOTAL BID>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> $1,200.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: 6. 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. 7. 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 NOTICE 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. 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.