Spreadsheet: 103982d1301606103-reorganizing-data-from-another-sheet-sample
Sheet: Solicitation

SOLICITED SUBCONTRACTOR CHECKLIST |  |  |  |  |  |  |  |  |  | CONTACT MADE? | SPECS MAILED? | ADDEMDUMS? | SITE VISIT MADE? | AWARD?
 | Job bid Date : |  | 2011-04-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | AWARD? | AWARD? |  |  | Name | Street | [NAME] | Phone Number | Fax Number | Trade | Entry Date | Ky | Zip Code
1 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  | >0 | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Select One
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | [NAME]
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Building
2 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Cabinet maker
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Carpentry
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Cement Mason
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Cladding
3 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Dogger
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Drainage
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Electrician
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Elevator Mechanic
4 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Fireproofing
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Firestopping
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  | 0 |  |  | 0 | 0 | 0 | 0 | 0 | Select One | 1900-01-01 00:00:00 | 0 | 0 |  |  |  | Framing
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Glazing
5 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Heavy Equipment Operator
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Hod carrier
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | HVAC
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Insulation
6 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Iron worker
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Laborer
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | landscaper
7 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Masonry
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Painting and Decorating
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Pipe fitter
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plastering
8 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Plumbing
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Roofing
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Rural building
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sealer
9 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Steel fixer
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  | AWARD? |  |  | Name | Street | [NAME] | Phone Number | Fax Number | Trade | Entry Date | Ky | Zip Code |  |  |  | Stonework
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Teamster
10 | NAME |  |  |  |  | ENTRY DATE |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Tile setter (Tile)
 | STREET |  |  |  |  | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Waterproofing
 | CITY |  |  | STATE |  | ZIP |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Window installer
 | PHONE |  |  | FAX |  |  | TRADE | Select One |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | OTHER
11 | NAME |  |  |  |  | ENTRY DATE
 | STREET |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP
 | PHONE |  |  | FAX |  |  | TRADE | Select One
12 | NAME |  |  |  |  | ENTRY DATE
 | STREET |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP
 | PHONE |  |  | FAX |  |  | TRADE | Select One
13 | NAME |  |  |  |  | ENTRY DATE
 | STREET |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP
 | PHONE |  |  | FAX |  |  | TRADE | Select One
14 | NAME |  |  |  |  | ENTRY DATE
 | STREET |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP
 | PHONE |  |  | FAX |  |  | TRADE | Select One
15 | NAME |  |  |  |  | ENTRY DATE
 | STREET |  |  |  |  | [NAME]
 | CITY |  |  | STATE |  | ZIP
 | PHONE |  |  | FAX |  |  | TRADE | Select One