Spreadsheet: 142375d1329804951-value-cell-not-calculating-correctly-or-not-at-all-2-bid-fee-tabulation
Sheet: Fee Breakout

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Total
 |  |  | Percentage of Total Hours for Average Sheet: |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05 |  | 1
 | Sht No. | Architectural Drawings | Total Hours Per Sheet |  | Senior Principal | Principal | Supervisor | Professional I | Professional II | Tech I | Tech II | Tech III | Tech IV | Tech V | Tech VI
P1 |  | Scope Trip
 |  | Trip Coordination
 |  | Proposal, Permitting  / Initial Due Diligence |  |  |  |  | 2
 |  | Scope Trip Time / Travel Time
 |  | Scope Trip Report
 |  | Total Hours: |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Hours: |  |  | 0 | 0 | 2 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 2
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 250 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 250 | 300
P1 | Building Survey  / Pre-Development / Landlord Package
 | CS1.0 | Cover Sheet | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AS1.0 | Exterior & Site Plan Issues | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A1.0 | Floor Plan & Vacant Space/ Demising Wall | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4.0 | RCP & Lighting | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A5.0 | Skylights Layout & Coordination | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A6.0 | Exterior Storefront Elevations & Signage | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Hours: | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
 |  | Due Diligence |  |  |  |  |  |  |  |  | 0.5 |  |  | 2
 |  | Design Development Package/Coordination |  |  |  |  | 1 |  |  |  |  |  |  | 2
 |  | Consultant Coord. & Distribution |  |  |  |  | 0.5 |  |  |  |  |  |  | 1
 |  | Coordination
 |  | Devolper Coodination |  |  |  |  |  |  |  |  |  |  |  | 1
 |  | Miscellaneous |  |  |  |  | 1 |  |  |  | 1 |  |  | 1
 |  | Total Hours: |  |  | 0 | 0 | 2.5 | 0 | 0 | 0 | 1.5 | 0 | 0 | 7 | 0
 |  | Total Hours: |  |  | 0 | 0 | 2.5 | 0 | 0 | 0 | 1.5 | 0 | 0 | 7 | 0 |  | 11
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 312.5 | 0 | 0 | 0 | 147 | 0 | 0 | 546 | 0 |  | 1005.5 | 1000
P2 |  | Construction Documents
 | CS1.0 | Cover Sheet, Index and Location Maps | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | CS1.1 | Symbols / Abbreviations | 0.5 |  | 0 | 0 | 0.025 | 0 | 0 | 0 | 0.05 | 0 | 0 | 0.4 | 0.025
 | AS1.0 | Architectural Site Plan | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | LS1.0 | Life Safety Plan/ Code Analysis | 1 |  | 0 | 0 | 0.05 | 0 | 0 | 0 | 0.1 | 0 | 0 | 0.8 | 0.05
 | [NAME] | Demo Plan | 4 |  | 0 | 0 | 0.2 | 0 | 0 | 0 | 0.4 | 0 | 0 | 3.2 | 0.2
 | D2.0 | Demo Section & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A1.0 | [NAME] | 8 |  | 0 | 0 | 0.4 | 0 | 0 | 0 | 0.8 | 0 | 0 | 6.4 | 0.4
 | A3.0 | Finish Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A4.0 | Reflected Ceiling Plan | 4 |  | 0 | 0 | 0.2 | 0 | 0 | 0 | 0.4 | 0 | 0 | 3.2 | 0.2
 | A5.0 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A6.0 | Exterior Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A7.0 | Interior Elevations | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | A8.0 | Restroom Plan & Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A9.0 | Door Schedule & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A9.1 | Storefront Sections & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.0 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.1 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.2 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.0 | Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.1 | Exterior Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.2 | Interior Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.0 | MDC- [NAME] | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.1 | MDC- Reflected Ceiling Plan | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.2 | MDC- Schedules & Legends | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.3 | MDC- Interior Elevations | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A13.4 | MDC- Details | 3 |  | 0 | 0 | 0.15 | 0 | 0 | 0 | 0.3 | 0 | 0 | 2.4 | 0.15
 | A14.0 | MHT Floor Plan & Schedule | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.1 | MHT Finish Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.2 | MHT Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.3 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A15.0 | Pac Sales Enlarged Plans | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-1 | Fixture Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-2 | Fixture Sign & Paint Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-4 | Fixture Extension Plan & Details | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-5 | Fixture Extension Details | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 | F-6 | Pac Sales Stone Counter-top Plan | 2 |  | 0 | 0 | 0.1 | 0 | 0 | 0 | 0.2 | 0 | 0 | 1.6 | 0.1
 |  | Total Hours: | 48.5 |  | 0 | 0 | 2.425 | 0 | 0 | 0 | 4.850000000000001 | 0 | 0 | 38.8 | 2.425 |  | 48.5
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 303.1250000000001 | 0 | 0 | 0 | 475.3000000000001 | 0 | 0 | 3026.400000000001 | 169.75 |  | 3974.575000000001 | 4000
P2 |  | CD Coordination
 |  | Coordination |  |  |  |  | 0.5 |  |  |  | 0.5
 |  | Devolper Coodination
 |  | Specifications
 |  | Redlining / QC& QA |  |  |  |  | 2 |  |  |  |  |  |  | 1
 |  | Plotting Distribution |  |  |  |  | 0.5 |  |  |  |  |  |  | 2
 |  | Miscellaneous |  |  |  |  | 1 |  |  |  | 1 |  |  | 1
 |  | Total Hours: |  |  | 0 | 0 | 2.5 | 0 | 0 | 0 | 1.5 | 0 | 0 | 7 | 0
 |  | Total Hours: |  |  | 0 | 0 | 4 | 0 | 0 | 0 | 1.5 | 0 | 0 | 4 | 0 |  | 9.5
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 500 | 0 | 0 | 0 | 147 | 0 | 0 | 312 | 0 |  | 959 | 1000
P3 |  | Balance of Construction Documents
 | CS1.0 | Cover Sheet, Index and Location Maps | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | CS1.1 | Symbols / Abbreviations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | AS1.0 | Architectural Site Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | LS1.0 | Life Safety Plan/ Code Analysis | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | [NAME] | Demo Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | D2.0 | Demo Section & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A1.0 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A3.0 | Finish Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A4.0 | Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A5.0 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A6.0 | Exterior Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A7.0 | Interior Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A8.0 | Restroom Plan & Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A9.0 | Door Schedule & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A9.1 | Storefront Sections & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.0 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.1 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A10.2 | Wall Sections | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.0 | Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.1 | Exterior Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A11.2 | Interior Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.0 | MDC- [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.1 | MDC- Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.2 | MDC- Schedules & Legends | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.3 | MDC- Interior Elevations | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A13.4 | MDC- Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.0 | MHT Floor Plan & Schedule | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.1 | MHT Finish Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.2 | MHT Reflected Ceiling Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A14.3 | [NAME] | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | A15.0 | Pac Sales Enlarged Plans | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-1 | Fixture Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-2 | Fixture Sign & Paint Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-4 | Fixture Extension Plan & Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-5 | Fixture Extension Details | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 | F-6 | Pac Sales Stone Counter-top Plan | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0
 |  | Total Hours: | 0 |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  | 0 | 0
P3 |  | Construction Administration
 |  | Consultant Coordination & Distribution |  |  |  |  | 0.5 |  |  |  |  |  |  | 1
 |  | Redlining / QC& QA |  |  |  |  | 0 |  |  |  |  |  |  | 0
 |  | [NAME]
 |  | [NAME]
 |  | Plotting Distribution
 |  | Bldg. Dept Coordination & Revisions |  |  |  |  | 1 |  |  |  |  |  |  | 3
 |  | Construction Administration |  |  |  |  | 0.5 |  |  |  |  |  |  | 2 | 1
 |  | X-list / GO-21 & GO-13 Updates |  |  |  |  |  |  |  |  |  |  |  | 2
 |  | Construction Observation Visits/Punchlist
 |  | Review Shop Drawings / RFI's / GC Questions |  |  |  |  | 0.5 |  |  |  |  |  |  | 1
 |  | As-Builts & Archiving |  |  |  |  | 0.5 |  |  |  |  |  |  | 2
 |  | Final Close-out of Project |  |  |  | 0.5 | 1 |  |  |  |  | 2 |  | 2 | 2
 |  | .
 |  | SubTotal Hours: |  |  | 0 | 0.5 | 4 | 0 | 0 | 0 | 0 | 2 | 0 | 13 | 3
 |  | Total Hours: |  |  | 0 | 0.5 | 4 | 0 | 0 | 0 | 0 | 2 | 0 | 13 | 3 |  | 22.5
 |  | Hourly Rates: |  |  | 190 | 167 | 125 | 120 | 115 | 105 | 98 | 93 | 88 | 78 | 70
 |  | Total Fee: |  |  | 0 | 83.5 | 500 | 0 | 0 | 0 | 0 | 186 | 0 | 1014 | 210 |  | 1993.5 | 2000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sub Total: |  | 8182.575000000001 | 8200
 |  |  |  |  |  |  |  |  |  |  | Reimbursables |  |  | Consultants Estimate
 |  |  |  |  |  |  |  |  |  | Architectural | 850 |  |  |  | MEP |  | 26
 |  |  |  |  |  |  |  |  |  | MEP | 9 |  |  |  | ? |  | 0
 |  | Total Architectural Hours = | 93.5 |  |  |  |  |  |  | ? | 0 |  |  |  | Structural |  | 0
 |  |  |  |  |  |  |  |  |  | Structural | 0 |  |  |  | F.P. / F.A. |  | 0
 |  |  |  |  |  |  |  |  |  | F.P. / F.A. | 0 |  |  |  | Civil |  | 10
 |  |  |  |  |  |  |  |  |  | Functional Commissioning | 0 |  |  |  | Reimbursables |  | 874
 |  |  |  |  |  |  |  |  |  | Civil Engineering | 6 |  |  |  | Functional Comm. |  | 0
 |  |  |  |  |  |  |  |  |  | Bldg. Dept. Plan Review Fees | 0 |  |  |  | Bldg. Dept. Plan Review Fees |  | 0
 |  |  |  |  |  |  |  |  |  | GeoTech | 9 |  |  |  | GeoTech |  | 18
 |  |  |  |  |  |  |  |  |  | Skylight Energy Modeling | 0 |  |  |  | Skylight Energy Modeling |  | 0
 |  |  |  |  |  |  |  |  |  | Expediter/Third Party Reviewer | 0 |  |  |  | Expediter/Third Party Reviewer |  | 1500
 |  |  |  |  |  |  |  |  |  | Landscaping | 0 |  |  |  | Landscaping |  | 0
 |  |  |  |  |  |  |  |  |  | Sub Total: | 874 |  |  |  | Grand Total: |  | 10628