ac0aed68-d265-48a6-ba64-2ea281e0e6fe.XLS <====CONTRACTOR NUMBER CONTRACTOR NAME====> COUNTY(IES)========> KANE- - AIRPORT============> AURORA MUNICIPAL BLANK PRICES 69 LETTING DATE=======> March 8, 2002 ITEM NUMBER========> 011A TOTAL QUANTITY PAY ITEMS 69 TOTAL BID $0.00 STATE NUMBER========> ARR2886 AU057 <====CONTRACT NUMBER 33,247.600 PIN PAY ITEM DESCRIPTION U OF M QUANTITY X UNIT PRICE = TOTAL PRICE AR106511 TYPE A AREA LGHT POLE W/1 FIXTURE EACH 4.000 $0.00 2 CONTRACTOR NUMBER 0 CONTRACTOR NAME 0 ITEM NUMBER 011A STATE NUMBER ARR2886 CONTRACT NUMBER AU057 THIS IS THE TOTAL BID>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>>> $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. 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.