Spreadsheet: 24846d1215709286-conditional-formatting-and-colored-cells-book1
Sheet: Sheet1

JOB DATA AND COORDINATION
WORKBOOK | WORKBOOK OWNER |  | SELECT ▼ | READ AND FILED SIGNED PROPOSAL |  | APPROVALS AND INFORMATION
 | PARTNER-IN-CHARGE |  | SELECT ▼ | MET WITH PARTNER-IN-CHARGE
SA IDENTIFICATION | JOB NUMBER |  | SELECT ▼ | CREATED JOB FOLDERS ON SERVER
 | JOB ACRONYM |  | SELECT ▼ | SET UP JOB IN DOVICO (ATTACH REPORT)
PROJECT | [NAME] |  | SELECT ▼ | TERMS FOR INVOICING
 | SITE ADDRESS |  | SELECT ▼ | INVOICES SENT VIA
 | CITY, STATE  ZIP |  | SELECT ▼ | SET UP JOB IN QUICKBOOKS (ATTACH REPORT) |  | OWNER | DATE
CLIENT | NAME
 | MAILING ADDRESS
 | CITY, STATE  ZIP |  | SELECT ▼ | CLIENT'S INFO IS IN SA_CONTACTS
SCHEDULE | PROJECTED START |  | SELECT ▼ | POSTED JOB ON SCHEDULE BOARD
 | PROJECTED END |  | SELECT ▼ | REVIEWED JOB SCHEDULE SHOWING TEAM HOURS
ARCHITECTURAL FEE | FEE BASIS | SELECT ▼ |  |  |  | PARTNER IN CHARGE | DATE
 | MULTIPLIER | 0.14
JOB SCOPE AND FEES
CONSTRUCTION SCOPE |  |  | COST | 0 |  | CURRENT DATE
CONTRACT ~ COST | CONSTRUCTION | 0 | SELECT ▼ | CONTRACT ON FILE |  | 2008-07-10 00:00:00
CONTRACT ~ COST | LIGHTING | 0 | SELECT ▼ | CONTRACT ON FILE
CONTRACT ~ COST | CABINETRY | 0 | SELECT ▼ | CONTRACT ON FILE |  | FILE NAME
CONTRACT ~ COST | A/V | 0 | SELECT ▼ | CONTRACT ON FILE
CONTRACT ~ COST | CONTRACT 5 | 0 | SELECT ▼ | CONTRACT ON FILE
CONTRACT ~ COST | CONTRACT 6 | 0 | SELECT ▼ | CONTRACT ON FILE
BASIC ARCHITECTURAL SERVICES |  |  | FEE | 0
PHASE ~ % OF FEE | SCHEMATIC DESIGN | 0.15 | 0
PHASE ~ % OF FEE | DESIGN DEVELOPMENT | 0.25 | 0
PHASE ~ % OF FEE | CONSTRUCTION DOCUMENTS | 0.3 | 0
PHASE ~ % OF FEE | BIDDING AND NEGOTIATIONS | 0.05 | 0
PHASE ~ % OF FEE | CONSTRUCTION ADMINISTRATION | 0.25 | 0
CONSULTANT SERVICES |  |  | FEE | 0
CONSULTANT ~ FEE | STRUCTURAL ENGINEERING | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
CONSULTANT ~ FEE | MEP / FP ENGINEERING | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
CONSULTANT ~ FEE | ACOUSTICAL | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
CONSULTANT ~ FEE | CONSULTANT 4 | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
CONSULTANT ~ FEE | CONSULTANT 5 | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
CONSULTANT ~ FEE | CONSULTANT 6 | 0 | SELECT ▼ | REVIEWED PROPOSAL AND RECEIVED INSURANCE
ADDITIONAL SERVICES |  |  | FEE | 0
SERVICE ~ FEE | ASBESTOS | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 02 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 03 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 04 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 05 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 06 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 07 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 08 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 09 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION
SERVICE ~ FEE | ADDITIONAL SERVICE 10 | 0 | SELECT ▼ | REVIEWED PROPOSAL OR WRITTEN AUTHORIZATION