Spreadsheet: 672264d1586810639-how-to-check-data-in-cells-of-colum-for-0-if-so-return-data-from-another-cell-copy-of-jh-siding-pricing-sheet-1-
Sheet: Vinyl

 | Customer Name | [NAME], [NAME]
 | Sale Date | not sold yet
 | Design Rep | [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] | [NAME] | [NAME] | [NAME]
Products / Services | Measure Unit | Sales Units | Prod Units | Retail | Color | Texture/Profile | [NAME] | [NAME] | Additional Notes | Labor Amt | Mat Amt | [NAME] | Mulitplier | Sale multi | Finace fee | Retail |  | Labor | Labor | Material | Material
VINYL SIDING
EnergyWise Single 7" Clapboard | Per Square | 15 |  | 1130 |  |  | 16950 | 0 |  | 110 | 210 | 320 | 0.5 | 0.9 | 0.89 | 799.0012484394506 |  | 1650 | 0 | 3150 | 0
EnergyWise Double 6" Clapboard | Per Square |  |  | 1090 |  |  | 0 | 0 |  | 90 | 210 | 300 | 0.5 | 0.9 | 0.89 | 749.063670411985 |  | 0 | 0 | 0 | 0
EnergyWise 5" Dutchlap | Per Square |  |  | 1090 |  |  | 0 | 0 |  | 90 | 210 | 300 | 0.5 | 0.9 | 0.89 | 749.063670411985 |  | 0 | 0 | 0 | 0
Charter Oak Double 4.5" Clapboard | Per Square |  |  | 770 |  |  | 0 | 0 |  | 70 | 130 | 200 | 0.5 | 0.9 | 0.89 | 499.3757802746567 |  | 0 | 0 | 0 | 0
Charter Oak Double 4.5" Dutchlap | Per Square |  |  | 770 |  |  | 0 | 0 |  | 70 | 130 | 200 | 0.5 | 0.9 | 0.89 | 499.3757802746567 |  | 0 | 0 | 0 | 0
Architectural [NAME] 7" Shingle | Per Square |  |  | 1340 |  |  | 0 | 0 |  | 200 | 300 | 500 | 0.5 | 0.9 | 0.89 | 1248.439450686642 |  | 0 | 0 | 0 | 0
JH 7" Reveal Colorplus (Standard siding price) | Per Square |  |  | 1298 |  |  | 0 | 0 |  | 225 | 250 | 475 | 0.5 | 0.9 | 0.89 | 1186.017478152309 |  | 0 | 0 | 0 | 0
Primed and Painted additional cost | Per Square |  |  | 182.8614232209738 |  |  | 182.8614232209738 | 0 |  | 73.236 | 0 | 73.236 | 0.5 | 0.9 | 0.89 | 182.8614232209738 |  | 73.236 | 0 | 0 | 0
Panel additional cost | Per Square |  |  | 103.974 |  |  | 103.974 | 0 |  | 41.85 | 0 | 41.85 | 0.5 | 0.9 | 0.89 | 104.4943820224719 |  | 41.85 | 0 | 0 | 0
Board and Batten Vertical Single 7" | Per Square |  |  | 1090 |  |  | 0 | 0 |  | 200 | 208 | 408 | 0.5 | 0.9 | 0.89 | 1018.7265917603 |  | 0 | 0 | 0 | 0
Additional upcharge for premium colors | Per Square |  |  | 40 |  |  | 0 | 0 |  | 0 | 20 | 20 | 0.5 | 0.9 | 0.89 | 49.93757802746566 |  | 0 | 0 | 0 | 0
Remove Existing Siding | Per Square |  |  | 80 |  |  | 0 | 0 |  | 30 | 0 | 30 | 0.5 | 0.9 | 0.89 | 74.90636704119851 |  | 0 | 0 | 0 | 0
Install Tyvek Vapor Barrier | Per Square |  |  | 88 |  |  | 0 | 0 |  | 20 | 13 | 33 | 0.5 | 0.9 | 0.89 | 82.39700374531834 |  | 0 | 0 | 0 | 0
Cultured Stone Veneer | Per Square |  |  | 3600 |  |  | 0 | 0 |  | 500 | 800 | 1300 | 0.5 | 0.9 | 0.89 | 3245.942571785268 |  | 0 | 0 | 0 | 0
WINDOW TRIM
All Window Trim is included in vinyl pricing |  |  |  | included |  |  | n/c | n/c |  | 0 | 0 | 0 | 0.5 | 0.9 | 0.89 | 0 |  | 0 | 0 | 0 | 0
FASCIA
Smooth Aluminum Wrap | Per Foot |  |  | 8 |  |  | 0 | 0 |  | 1.5 | 1.5 | 3 | 0.5 | 0.9 | 0.89 | 7.49063670411985 |  | 0 | 0 | 0 | 0
Woodgrain (PVC coated) [NAME] | Per Foot |  |  | 8 |  |  | 0 | 0 |  | 1.5 | 1.5 | 3 | 0.5 | 0.9 | 0.89 | 7.49063670411985 |  | 0 | 0 | 0 | 0
Replace Wood | Per Foot |  |  | 11.75 |  |  | 0 | 0 |  | 1.5 | 2 | 3.5 | 0.5 | 0.9 | 0.89 | 8.739076154806492 |  | 0 | 0 | 0 | 0
SOFFIT
Charter Oak Triple 3 1/2" vented | Per Foot |  |  | 8.5 |  |  | 0 | 0 |  | 1.5 | 1.75 | 3.25 | 0.5 | 0.9 | 0.89 | 8.11485642946317 |  | 0 | 0 | 0 | 0
Standard Vinyl or [NAME] | Per Foot |  |  | 7.7 |  |  | 0 | 0 |  | 1.5 | 1 | 2.5 | 0.5 | 0.9 | 0.89 | 6.242197253433208 |  | 0 | 0 | 0 | 0
PORCH CEILING
Charter Oak Triple 3 1/2" | Per Square |  |  | 850 |  |  | 0 | 0 |  | 90 | 175 | 265 | 0.5 | 0.9 | 0.89 | 661.6729088639202 |  | 0 | 0 | 0 | 0
Standard Vinyl or [NAME] | Per Square |  |  | 770 |  |  | 0 | 0 |  | 90 | 100 | 190 | 0.5 | 0.9 | 0.89 | 474.4069912609239 |  | 0 | 0 | 0 | 0
GUTTERS
5" Gutter with 3 x 3 Downspouts | Per Foot |  |  | 10.56 |  |  | 0 | 0 |  | 3.915 | 0 | 3.915 | 0.5 | 0.9 | 0.89 | 9.775280898876403 |  | 0 | 0 | 0 | 0
6" Gutter with 3 x 4 Downspouts | Per Foot |  |  | 11.57 |  |  | 0 | 0 |  | 4.29 | 0 | 4.29 | 0.5 | 0.9 | 0.89 | 10.71161048689139 |  | 0 | 0 | 0 | 0
Remove and [NAME] | Per Foot |  |  | 8.881398252184768 |  |  | 0 | 0 |  | 3.557 | 0 | 3.557 | 0.5 | 0.9 | 0.89 | 8.881398252184768 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 5.8 |  |  | 0 | 0 |  | 2.143 | 0 | 2.143 | 0.5 | 0.9 | 0.89 | 5.350811485642946 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 12.05 |  |  | 0 | 0 |  | 4.465 | 0 | 4.465 | 0.5 | 0.9 | 0.89 | 11.14856429463171 |  | 0 | 0 | 0 | 0
ALUMINUM WRAP
Porch Beam (Smooth & Woodgrain) | Per Foot |  |  | 16 |  |  | 0 | 0 |  | 3 | 3 | 6 | 0.5 | 0.9 | 0.89 | 14.9812734082397 |  | 0 | 0 | 0 | 0
Porch Columns (Smooth & Woodgrain) | Per Foot | 7 |  | 20 |  |  | 140 | 0 |  | 3.998 | 4 | 7.998 | 0.5 | 0.9 | 0.89 | 19.97003745318352 |  | 27.986 | 0 | 28 | 0
Frieze/Band Board (Smooth & Woodgrain) | Per Foot |  |  | 10 |  |  | 0 | 0 |  | 1.5 | 2.25 | 3.75 | 0.5 | 0.9 | 0.89 | 9.363295880149813 |  | 0 | 0 | 0 | 0
ALUMINUM COLUMNS |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
[NAME] 3-sided Wrap | Per Foot |  |  | 25.01 |  |  | 575.23 | 0 |  | 5.998 | 3.4272 | 9.4252 | 0.5 | 0.9 | 0.89 | 23.53358302122347 |  | 137.954 | 0 | 78.8256 | 0
Square Fiberglass Columns 8"x8' (smooth/not tapered) | Per Column |  |  | 961.2983770287141 |  |  | 1922.596754057428 | 0 |  | 95 | 290 | 385 | 0.5 | 0.9 | 0.89 | 961.2983770287141 |  | 190 | 0 | 580 | 0
PVC Dentil Moulding | Per Foot |  |  | 12.68414481897628 |  |  | 418.5767790262173 | 0 |  | 2 | 3.08 | 5.08 | 0.5 | 0.9 | 0.89 | 12.68414481897628 |  | 66 | 0 | 101.64 | 0
PVC Crown Moulding | Per Foot |  |  | 11.25842696629214 |  |  | 405.3033707865169 | 0 |  | 2.509 | 2 | 4.509 | 0.5 | 0.9 | 0.89 | 11.25842696629214 |  | 90.324 | 0 | 72 | 0
New Aluminum Columns 10"x12' | Per Column |  |  | 1291.66 |  |  | 0 | 0 |  | 95 | 383.99 | 478.99 | 0.5 | 0.9 | 0.89 | 1195.980024968789 |  | 0 | 0 | 0 | 0
New Aluminum Columns 10''x16' | Per Column |  |  | 1663.171036204744 |  |  | 0 | 0 |  | 95 | 571.1 | 666.1 | 0.5 | 0.9 | 0.89 | 1663.171036204744 |  | 0 | 0 | 0 | 0
ALUMINUM Garage Door Wraps
Single Garage Door Wrap | Per Door |  |  | 306 |  |  | 0 | 0 |  | 75 | 40 | 115 | 0.5 | 0.9 | 0.89 | 287.1410736579276 |  | 0 | 0 | 0 | 0
Double Garage Door Wrap | Per Door |  |  | 426 |  |  | 0 | 0 |  | 99.996 | 60 | 159.996 | 0.5 | 0.9 | 0.89 | 399.4906367041198 |  | 0 | 0 | 0 | 0
SHUTTERS
New Shutters | Per Set |  |  | 240.9488139825218 |  |  | 0 | 0 |  | 35 | 61.5 | 96.5 | 0.5 | 0.9 | 0.89 | 240.9488139825218 |  | 0 | 0 | 0 | 0
Paint Shutters | Per Set |  |  | 213.6953807740324 |  |  | 0 | 0 |  | 59.955 | 25.63 | 85.585 | 0.5 | 0.9 | 0.89 | 213.6953807740324 |  | 0 | 0 | 0 | 0
Shutters on [NAME] | Per Shutter |  |  | 39.70786516853933 |  |  | 0 | 0 |  | 15.903 | 0 | 15.903 | 0.5 | 0.9 | 0.89 | 39.70786516853933 |  | 0 | 0 | 0 | 0
GABLE VENTS
New Gable Vent included in siding price | Included |  |  | included |  |  | n/c | n/c |  | 40 | 56.38 | 96.38 | 0.5 | 0.9 | 0.89 | 240.649188514357 |  | 0 | 0 | 0 | 0
Mouldings
PVC Dentil Moulding | Per Foot |  |  | 13.7 |  |  | 0 | 0 |  | 2 | 3.08 | 5.08 | 0.5 | 0.9 | 0.89 | 12.68414481897628 |  | 0 | 0 | 0 | 0
PVC Plant Moulding | Per Foot |  |  | 9.42 |  |  | 0 | 0 |  | 2.002 | 1.49 | 3.492 | 0.5 | 0.9 | 0.89 | 8.719101123595506 |  | 0 | 0 | 0 | 0
PVC [NAME] | Per Foot |  |  | 9.42 |  |  | 0 | 0 |  | 2.005 | 1.49 | 3.495 | 0.5 | 0.9 | 0.89 | 8.726591760299625 |  | 0 | 0 | 0 | 0
PVC Crown Moulding | Per Foot |  |  | 12.16 |  |  | 0 | 0 |  | 2.509 | 2 | 4.509 | 0.5 | 0.9 | 0.89 | 11.25842696629214 |  | 0 | 0 | 0 | 0
PVC Drip Cap | Per Foot |  |  | 9.42 |  |  | 0 | 0 |  | 2.002 | 1.49 | 3.492 | 0.5 | 0.9 | 0.89 | 8.719101123595506 |  | 0 | 0 | 0 | 0
PVC Window Crosshead | Per Window |  |  | 274.12 |  |  | 0 | 0 |  | 35.02 | 66.63 | 101.65 | 0.5 | 0.9 | 0.89 | 253.8077403245942 |  | 0 | 0 | 0 | 0
PVC Door Crosshead | Per Door |  |  | 329 |  |  | 0 | 0 |  | 40.003 | 82 | 122.003 | 0.5 | 0.9 | 0.89 | 304.6267166042447 |  | 0 | 0 | 0 | 0
PVC Keystone for Crosshead | Per Keystone |  |  | 13.69 |  |  | 0 | 0 |  | 2 | 3.08 | 5.08 | 0.5 | 0.9 | 0.89 | 12.68414481897628 |  | 0 | 0 | 0 | 0
Rot Repair
Replace [NAME] | Per Foot |  |  | 8.83 |  |  | 0 | 0 |  | 2.003 | 1.27 | 3.273 | 0.5 | 0.9 | 0.89 | 8.172284644194757 |  | 0 | 0 | 0 | 0
Replace Sheeting | Per Sheet |  |  | 85.86 |  |  | 0 | 0 |  | 13.288 | 18.55 | 31.838 | 0.5 | 0.9 | 0.89 | 79.4956304619226 |  | 0 | 0 | 0 | 0
Hourly rate (time and material quotes) | Per Hour |  |  | 94.38 |  |  | 0 | 0 |  | 35 | 0 | 35 | 0.5 | 0.9 | 0.89 | 87.39076154806492 |  | 0 | 0 | 0 | 0
Specialty Painting
Paint Dentil Mould | Per Foot |  |  | 11.54 |  |  | 0 | 0 |  | 2 | 2.35 | 4.35 | 0.5 | 0.9 | 0.89 | 10.86142322097378 |  | 0 | 0 | 0 | 0
Paint Dentil Mould/Frieze Board/Crown Combo | Per Foot |  |  | 17.54 |  |  | 0 | 0 |  | 3.425 | 3.08 | 6.505 | 0.5 | 0.9 | 0.89 | 16.24219725343321 |  | 0 | 0 | 0 | 0
Paint Entry Door | Per Door |  |  | 243 |  |  | 0 | 0 |  | 78.185 | 12.3 | 90.485 | 0.5 | 0.9 | 0.89 | 225.9300873907615 |  | 0 | 0 | 0 | 0
Paint Entry Door with glass/sidelite | Per Door |  |  | 318.72 |  |  | 0 | 0 |  | 100 | 18.19 | 118.19 | 0.5 | 0.9 | 0.89 | 295.1061173533084 |  | 0 | 0 | 0 | 0
Paint Garage Door (Single) | Per Door |  |  | 206.38 |  |  | 0 | 0 |  | 55 | 21.53 | 76.53 | 0.5 | 0.9 | 0.89 | 191.0861423220974 |  | 0 | 0 | 0 | 0
Paint Garage Door (Double) | Per Door |  |  | 448.81 |  |  | 0 | 0 |  | 112 | 54.43 | 166.43 | 0.5 | 0.9 | 0.89 | 415.5555555555555 |  | 0 | 0 | 0 | 0
Garage Doors
Standard Double Garage Door | Per Door |  |  | 2028.24 |  |  | 0 | 0 |  | 698 | 54.43 | 752.43 | 0.5 | 0.9 | 0.89 | 1878.726591760299 |  | 0 | 0 | 0 | 0
Standard Single Garaga Door | Per Door |  |  | 1338.69 |  |  | 0 | 0 |  | 442 | 54.43 | 496.43 | 0.5 | 0.9 | 0.89 | 1239.525593008739 |  | 0 | 0 | 0 | 0
Lead Paint Extra Cost
Lead testing service | Per Job |  |  | 216 |  |  |  |  |  | 200 | 0 | 200 | 1 | 1 | 1 | 200 |  | 0 | 0 | 0 | 0
1st Story Lead paint containment procedures | Per Square |  |  | 91.2 |  |  | 0 | 0 |  | 20 | 13.82 | 33.82 | 0.5 | 0.9 | 0.89 | 84.44444444444444 |  | 0 | 0 | 0 | 0
2nd Story Lead paint containment procedures | Per Square |  |  | 102.48 |  |  | 0 | 0 |  | 24.185 | 13.82 | 38.005 | 0.5 | 0.9 | 0.89 | 94.89388264669162 |  | 0 | 0 | 0 | 0
1st Story Soffit/Fascia containment procedures | Per Ln. Ft. |  |  | 3.25 |  |  | 0 | 0 |  | 1.2 | 0 | 1.2 | 0.5 | 0.9 | 0.89 | 2.99625468164794 |  | 0 | 0 | 0 | 0
2nd Story Soffit/Fascia containment procedures | Per Ln. Ft. |  |  | 4.35 |  |  | 0 | 0 |  | 1.6 | 0 | 1.6 | 0.5 | 0.9 | 0.89 | 3.995006242197254 |  | 0 | 0 | 0 | 0
Additional/Custom Work
Custom Work | Per Job |  |  | 1 |  |  | 0 | 0
Custom Work | Per Job |  |  | 1 |  |  | 0 | 0
Additional Work | Per Job |  |  | 0 |  |  | 0 | 0
Additional Work | Per Job |  |  | 0 |  |  | 0 | 0
Material Prep | Per Job |  |  | 330 |  |  | 0 | 0 |  |  |  |  |  |  |  |  |  | 2277.35 | 0 | 4010.4656 | 0
Administration Fee | Per Job |  |  | 125 |  |  | 0 | 0
Total |  |  |  |  |  |  | 20698.54232709113 | 0
Summary Recap | Sales | Production |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary Recap | Sales | Production
Retail Price ($) | 20698.54232709113 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retail Price ($) | 20698.54232709113 | 0
Sale Price ($) | 27608 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sale Price ($) | 27608 | 27608
Percent of Retail | 1.333813732567316 | #N/A |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent of Retail | 1.333813732567316 | #N/A
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor cost | 2277.35 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material cost | 4010.4656 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COGS $$ | 6287.8156 | 0
 | Artic White | White-Artic White |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COGS %% | 0.2277533903216459 | 0
 | [NAME] | [NAME]: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Profit | 21320.1844 | 27608
 | [NAME] | [NAME]: [NAME]
 | Cobble Stone | Cobblestone: Heribone
 | Soft Green | Soft Green: no gutter color
 | Light Mist | Light Mist: gray #39 Reynolds
 | Woodland Cream | Woodland Cream:  same Reynolds
 | Autumn Tan | Autumn Tan: same Reynolds
 | [NAME] | Sandstone Beige: Sandstone ABC
 | [NAME] | [NAME]: Clay ABC
 | [NAME] | [NAME]: n/a
 | Boothbay Blue | Boothbay Blue: n/a
 | [NAME] | [NAME]
 | Tuscan Gold | [NAME]: ABC or Lansing
 | [NAME] | [NAME]: Clay ABC
 | [NAME] | Timberbark n/a
 | Timber [NAME] | Mountain Sage: n/a
 | Mountain Sage | Evening Blue: n/a
 | Evening Blue | [NAME]: black
 | [NAME]
 | 001 White | [NAME]
 | 002 Black | Straight Edge
 | 004 Wedgewood Blue | 1/2 Round
 | 008 Clay
 | 009 Federal Brown | Smooth
 | 010 Musket Brown | Select Cedar Mill
 | 018 [NAME]
 | 023 Wicker | 8 1/4" SCM
 | 027 Burgundy Red | 8 1/4" Smooth
 | 028 Forest Green | 6 1/4" SCM
 | 036 Classic Blue | 6 1/4" Smooth
 | 078 [NAME] | Other
 | 117 Bright White
 | 122 Midnight Green | Sierra 8
 | 166 Midnight Blue | [NAME]
 | 167 Bordeaux | Stucco
 | 282 Colonial Green | Smooth
 | 283 Moss
 | 284 Sage | Smooth
 | 285 Plum | [NAME]
 | Double 5" | Raised Panel
 | Triple 3" | Louvered
 |  | Board/2 Battons
 |  | Board/3 Battons
 |  | Z-Pattern