Spreadsheet: 109857d1306666960-conditional-formula-to-change-other-formulas-based-on-entry-worksheets-experimental-
Sheet: Middletown-Hudson Valley Market

P&M ASSOCIATES, INC.
AN AUTHORIZED INSTALLER
 |  |  |  |  |  | CUSTOMER:
 |  |  |  |  |  | HOME DEPOT STORE #:
 |  |  |  |  |  | ORDER NUMBER:
 |  |  |  |  |  | SALESPERSON:
 |  |  |  |  |  | DATE:
 |  |  |  |  |  | AFFIRMED BY:
 |  |  |  |  |  | DATE:
INSTALLATION QUOTE SUMMARY |  |  |  |  |  |  | AFFIRMATION SUMMARY
BASIC CAB. INSTALLATION |  |  |  |  |  |  | BASIC CAB. INSTALLATION
ELECTRICAL |  |  |  |  |  |  | ELECTRICAL
PLUMBING |  |  |  |  |  |  | PLUMBING
SUBTOTAL |  |  |  |  |  |  | SUBTOTAL
DEMOLITION/HAUL AWAY |  |  |  |  |  |  | DEMOLITION/HAUL AWAY
CABINETRY |  |  |  |  |  |  | CABINETRY
MOLDING INSTALLATION |  |  |  |  |  |  | MOLDING INSTALLATION
APPLIANCE INSTALLATION |  |  |  |  |  |  | APPLIANCE INSTALLATION
FLOORING/BACKSPLASH |  |  |  |  |  |  | FLOORING/BACKSPLASH
CARPENTRY |  |  |  |  |  |  | CARPENTRY
ADDITIONAL FEES |  |  |  |  |  |  | ADDITIONAL FEES
SUBTOTAL |  |  |  |  |  |  | SUBTOTAL
QUOTE TOTAL |  |  |  |  |  |  | AFFIRMATION TOTAL
BASIC INSTALLATION |  |  |  |  |  |  | BASIC INSTALLATION
PRE-CONSTRUCTION, DEMOLITION, REMOVAL, AND HAUL AWAY |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | [NAME]. Ft. | 0.75
 |  | [NAME]. Ft. | 0.5
 |  | [NAME]. Ft. | 0.3
 |  | Per Job | 13
 |  | Each | 1.5
 |  | Each | 2
 |  | Per Job | 24
 |  | Sq. Ft. | 0.15
 |  | Sq. Ft. | 0.15
 |  | Per Job | 3
 |  | Sq. Ft. | 0.07
 |  | Sq. Ft. | 0.05
 |  | Sq. Ft. | 0.1
 |  | Sq. Ft. | 0.05
 |  | Sq. Ft. | 0.05
 |  | Sq. Ft. | 0.05
 |  | Sq. Ft. | 0.05
 |  | Sq. Ft. | 0.35
 |  | JSQ | 1
TOTAL DEMOLITION/HAUL AWAY |  |  |  |  |  |  | AFFIRM. TOTAL DEMOLITION/HAUL AWAY
DEMOLITION/HAUL AWAY NOTES:
PER-BOX BASIC CABINET INSTALLATION |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Each
 |  | Each
TOTAL BASIC CABINET INSTALLATION |  |  |  |  |  |  | AFFIRM. TOTAL BASIC CABINET INSTALLATION
CUSTOM ASSEMBLY OR INSTALLATION (CABINETRY) |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Each | 4
 |  | Each | 4
 |  | Each | 4.5
 |  | Each | 1.2
 |  | [NAME]. Ft. | 0.65
 |  | Sq. Ft. | 0.5
 |  | Each | 3
 |  | Each | 0.05
 |  | Each | 1
 |  | Each | 1.5
 |  | Each | 2.5
 |  | Each | 1.5
 |  | Each | 1.5
 |  | Each | 3
 |  | Each | 9
 |  | Each | 5
 |  | Each | 1.5
 |  | Each | 2.85
 |  | Each | 9
 |  | Each | 1
 |  | Each | 2.5
 |  | JSQ | 1
TOTAL CABINETRY |  |  |  |  |  |  | AFFIRM. TOTAL CABINETRY
LIST ACCESSORIES, ALTERATIONS, AND ADDITIONAL CARPENTRY:
MOLDING INSTALLATION |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.5
 |  | [NAME]. Ft. | 0.25
 |  | [NAME]. Ft. | 0.68
 |  | [NAME]. Ft. | 0.25
TOTAL MOLDING INSTALLATION |  |  |  |  |  |  | AFFIRM. TOTAL MOLDING INSTALLATION
ELECTRICAL |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Each | 3
 |  | Each | 3
 |  | Each | 6.5
 |  | Each | 3
 |  | Each | 6.5
 |  | Each | 5
 |  | Each | 6
 |  | Each | 3
 |  | Each | 11
 |  | Each | 16
 |  | Each | 7
 |  | Each | 14
 |  | Each | 3
 |  | Each | 7
 |  | Each | 7
 |  | Each | 2.35
 |  | Each | 2
 |  | Each | 6
 |  | Each | 5
 |  | Each | 23
 |  | Each | 11
 |  | Each | 2.85
 |  | Each | 18
 |  | JSQ | 1
TOTAL ELECTRICAL |  |  |  |  |  |  | AFFIRM. TOTAL ELECTRICAL
ELECTRICAL NOTES:
PLUMBING |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Each | 13
 |  | Each | 15
 |  | Each | 11
 |  | Each | 22
 |  | Each | 7
 |  | Each | 4.6
 |  | Each | 3
 |  | Each | 8.2
 |  | Each | 5
 |  | [NAME]. Ft. | 1
 |  | [NAME]. Ft. | 1.6
 |  | Each | 21
 |  | Each | 11
 |  | Each | 15
 |  | [NAME]. Ft. | 3
 |  | Each | 3
 |  | Each | 3
 |  | Each | 2
 |  | Each | 26
 |  | JSQ | 1
TOTAL PLUMBING |  |  |  |  |  |  | AFFIRM. TOTAL PLUMBING
PLUMBING NOTES:
APPLIANCE INSTALLATION |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Each | 3.5
 |  | Each | 4.75
 |  | Each | 4
 |  | Each | 10
 |  | [NAME]. Ft. | 2
 |  | Each | 5
 |  | Each | 4
 |  | Each | 5.5
 |  | Each | 5
 |  | Each | 3.2
 |  | Each | 4.5
 |  | Each | 2.2
 |  | Each | 4
 |  | Each | 10
 |  | Each | 17
 |  | Each | 1.6
 |  | Each | 2
 |  | Each | 4.8
 |  | Each | 2.3
 |  | Each | 9
 |  | Each | 3.5
 |  | Each | 5
 |  | Each | 17
 |  | Each | 5
 |  | Each | 8.5
 |  | JSQ | 1
TOTAL APPLIANCE INSTALLATION |  |  |  |  |  |  | AFFIRM. TOTAL APPLIANCE INSTALLATION
APPLIANCE NOTES:
FLOORING AND BACKSPLASH INSTALLATION |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Sq. Ft. | 0.28
 |  | [NAME]. Ft. | 0.32
 |  | Sq. Ft. | 0.11
 |  | Sq. Ft. | 0.15
 |  | Sq. Ft. | 0.11
 |  | Sq. Ft. | 0.27
 |  | Sq. Ft. | 0.36
 |  | Sq. Ft. | 0.51
 |  | Sq. Ft. | 0.05
 |  | Each | 0.9
 |  | Each | 2
 |  | Each | 3
 |  | [NAME]. Ft. | 0.8
 |  | [NAME]. Ft. | 1.4
 |  | JSQ | 1
TOTAL FLOORING/BACKSPLASH |  |  |  |  |  |  | AFFIRM. TOTAL FLOORING/BACKSPLASH
FLOORING/BACKSPLASH NOTES:
DRYWALL WORK (CARPENTRY) |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | [NAME]. Ft. | 0.8
 |  | [NAME]. Ft. | 0.88
 |  | Sq. Ft. | 0.1
 |  | Sq. Ft. | 0.12
 |  | Sq. Ft. | 0.25
 |  | Sq. Ft. | 0.35
 |  | Sq. Ft. | 0.07
 |  | Sq. Ft. | 0.4
 |  | Sq. Ft. | 0.49
 |  | Sq. Ft. | 0.32
 |  | Each | 4.5
 |  | Each | 19
 |  | Each | 10
 |  | Each | 10
 |  | Each | 6
 |  | Each | 12
 |  | Each | 6
 |  | Each | 2.4
 |  | [NAME]. Ft. | 0.32
 |  | Each | 6
 |  | Each | 14
 |  | [NAME]. Ft. | 3
 |  | Each | 17
 |  | [NAME]. Ft. | 2
 |  | Each | 6
 |  | [NAME]. Ft. | 1.5
 |  | [NAME]. Ft. | 3
TOTAL CARPENTRY |  |  |  |  |  |  | AFFIRM. TOTAL CARPENTRY
CARPENTRY NOTES:
ADDITIONAL FEES AND TRIP CHARGES |  |  |  |  |  |  |  |  | AFFIRMATION
[NAME] |  | UNITS | POINTS | QTY. | PRICE | JOB PTS. | NOTES |  | QTY. | PRICE |  | JOB PTS.
 |  | Job | 19
 |  | Job | 9
 |  | Job | 10
 |  | Job | 10
 |  | Job | 10
 |  | Each | 3
 |  | Job | 5
 |  | Each | 3.5
 |  | Each | 7
 |  | Each | 10
 |  | JSQ | 1
TOTAL ADDITIONAL FEES/TRIP CHARGES |  |  |  |  |  |  | AFFIRM. TOTAL ADDITIONAL FEES/TRIP CHARGES
ADDITIONAL FEES/TRIP CHARGES NOTES:
GENERAL PROJECT NOTES: