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: Siding

 | Customer Name
 | Sale Date
 | Design Rep |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | [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
SIDING
[NAME] side | Per Square | 1 |  | 2227.759418374091 |  |  | 2227.759418374091 | 0 |  | 303.5 | 539.15 | 842.65 | 0.5 | 0.85 | 0.89 | 2227.759418374091 |  | 303.5 | 0 | 539.15 | 0
Stone Pedestal (32" tall)(no column included)(Provia) | Each | 1 |  | 1916.721744877726 |  |  | 1916.721744877726 | 0 |  | 300 | 425 | 725 | 0.5 | 0.85 | 0.89 | 1916.721744877726 |  | 300 | 0 | 425 | 0
Stone Pedestal (32" tall)(no column included)(all other stone) | Each |  |  | 2511.566424322538 |  |  | 0 | 0 |  | 300 | 650 | 950 | 0.5 | 0.85 | 0.89 | 2511.566424322538 |  | 364 | 0 | 0 | 0
Keystones/Coins (Stone) | Per Square |  |  | 79.31262392597489 |  |  | 0 | 0 |  | 15 | 15 | 30 | 0.5 | 0.85 | 0.89 | 79.31262392597489 |  | 0 | 0 | 0 | 0
Stone Light Blocks | Each |  |  | 660.9385327164574 |  |  | 0 | 0 |  | 100 | 150 | 250 | 0.5 | 0.85 | 0.89 | 660.9385327164574 |  | 0 | 0 | 0 | 0
Stone Sill or Ledge | Per Ln. Ft. |  |  | 47.58757435558493 |  |  | 0 | 0 |  | 3 | 15 | 18 | 0.5 | 0.85 | 0.89 | 47.58757435558493 |  | 0 | 0 | 0 | 0
Stone Veneer (Elderado Stone/Real Stone) | Per Square |  |  | 5816.259087904826 |  |  | 0 | 0 |  | 900 | 1300 | 2200 | 0.5 | 0.85 | 0.89 | 5816.259087904826 |  | 0 | 0 | 0 | 0
Stone Veneer (Provia Heritage Stone…) | Per Square |  |  | 4494.38202247191 |  |  | 0 | 0 |  | 900 | 800 | 1700 | 0.5 | 0.85 | 0.89 | 4494.38202247191 |  | 0 | 0 | 0 | 0
JH 7" Reveal Colorplus (Standard siding price) | Per Square |  |  | 1478.651685393259 |  |  | 0 | 0 |  | 250 | 309.3 | 559.3 | 0.5 | 0.85 | 0.89 | 1478.651685393259 |  | 0 | 0 | 0 | 0
Artisan Lap Siding Cost (Prefinished or Painted) | Per Square |  |  | 2270.799735624587 |  |  | 0 | 0 |  | 325 | 533.93 | 858.93 | 0.5 | 0.85 | 0.89 | 2270.799735624587 |  | 0 | 0 | 0 | 0
Dormer addition cost | Per Dormer |  |  | 331.9233311302049 |  |  | 0 | 0 |  | 125.55 | 0 | 125.55 | 0.5 | 0.85 | 0.89 | 331.9233311302049 |  | 0 | 0 | 0 | 0
Primed and Painted JH/Lap Panel additional cost | Per Square |  |  | 277.5941837409121 | normal part of JH/Lap Panel remod project |  | 0 | 0 |  | 80 | 25 | 105 | 0.5 | 0.85 | 0.89 | 277.5941837409121 |  | 0 | 0 | 0 | 0
Paint house only (Cedar) | Per Square |  |  | 277.5941837409121 |  |  | 0 | 0 |  | 80 | 25 | 105 | 0.5 | 0.85 | 0.89 | 277.5941837409121 |  | 0 | 0 | 0 | 0
Paint house only (Masonite/T-111/JH) | Per Square |  |  | 277.5941837409121 | Powerwash/scrape/1-coat |  | 0 | 0 |  | 80 | 25 | 105 | 0.5 | 0.85 | 0.89 | 277.5941837409121 |  | 0 | 0 | 0 | 0
Paint house only (2nd coat process) | Per Square |  |  | 237.9378717779247 | 2nd coat for light over dark color and vice vera |  | 0 | 0 |  | 65 | 25 | 90 | 0.5 | 0.85 | 0.89 | 237.9378717779247 |  | 0 | 0 | 0 | 0
Panel additional cost | Per Square |  |  | 110.641110376735 |  |  | 0 | 0 |  | 41.85 | 0 | 41.85 | 0.5 | 0.85 | 0.89 | 110.641110376735 |  | 0 | 0 | 0 | 0
All other reveal addition cost | Per Square |  |  | 110.641110376735 |  |  | 0 | 0 |  | 41.85 | 0 | 41.85 | 0.5 | 0.85 | 0.89 | 110.641110376735 |  | 0 | 0 | 0 | 0
Chimney additional cost | Per Chimney |  |  | 528.7508261731659 |  |  | 0 | 0 |  | 200 | 0 | 200 | 0.5 | 0.85 | 0.89 | 528.7508261731659 |  | 0 | 0 | 0 | 0
Bay 1st story additional cost | Per 1st Bay |  |  | 396.5631196298744 |  |  | 0 | 0 |  | 150 | 0 | 150 | 0.5 | 0.85 | 0.89 | 396.5631196298744 |  | 0 | 0 | 0 | 0
Bay 2nd story additional cost | Per 2nd Bay |  |  | 528.7508261731659 |  |  | 0 | 0 |  | 200 | 0 | 200 | 0.5 | 0.85 | 0.89 | 528.7508261731659 |  | 0 | 0 | 0 | 0
2nd story wall additional cost | Per 2nd story [NAME] |  |  | 55.32584269662922 |  |  | 0 | 0 |  | 20.927 | 0 | 20.927 | 0.5 | 0.85 | 0.89 | 55.32584269662922 |  | 0 | 0 | 0 | 0
3rd story wall additional cost | Per 3rd story [NAME] |  |  | 110.641110376735 |  |  | 0 | 0 |  | 41.85 | 0 | 41.85 | 0.5 | 0.85 | 0.89 | 110.641110376735 |  | 0 | 0 | 0 | 0
Rake wall additional cost | Per rake wall |  |  | 193.6259087904825 |  |  | 0 | 0 |  | 73.239 | 0 | 73.239 | 0.5 | 0.85 | 0.89 | 193.6259087904825 |  | 0 | 0 | 0 | 0
Progressive Pro Fold | Per Square |  |  | 137.4752148050231 |  |  | 0 | 0 |  | 20 | 32 | 52 | 0.5 | 0.85 | 0.89 | 137.4752148050231 |  | 0 | 0 | 0 | 0
Additional 2nd layer of tear off | Per Square |  |  | 79.31262392597489 |  |  | 0 | 0 |  | 30 | 0 | 30 | 0.5 | 0.85 | 0.89 | 79.31262392597489 |  | 0 | 0 | 0 | 0
Tear off of asbestos shingles | Per Square |  |  | 1652.346331791143 |  |  | $- | $- |  | 550 | 75 | 625 | 0.5 | 0.85 | 0.89 | 1652.346331791143 |  | 0 | 0 | 0 | 0
Deduction for no tear off | Per Square |  |  | -47.58757435558493 |  |  | 0 | 0 |  | -18 | 0 | -18 | 0.5 | 0.85 | 0.89 | -47.58757435558493 |  | 0 | 0 | 0 | 0
TRIM
JH 3.5 XLD Trim | Per Foot |  |  | 11.07732980832782 |  |  | 0 | 0 |  | 2.9 | 1.29 | 4.19 | 0.5 | 0.85 | 0.89 | 11.07732980832782 |  | 0 | 0 | 0 | 0
JH 5.5 XLD Trim | Per Foot |  |  | 12.55783212161269 |  |  | 0 | 0 |  | 3 | 1.75 | 4.75 | 0.5 | 0.85 | 0.89 | 12.55783212161269 |  | 0 | 0 | 0 | 0
JH 7.5 XLD Trim | Per Foot |  |  | 14.48777263714475 |  |  | 0 | 0 |  | 3.15 | 2.33 | 5.48 | 0.5 | 0.85 | 0.89 | 14.48777263714475 |  | 0 | 0 | 0 | 0
JH 11.25 XLD Trim | Per Foot |  |  | 20.43621943159286 |  |  | 0 | 0 |  | 4.1 | 3.63 | 7.73 | 0.5 | 0.85 | 0.89 | 20.43621943159286 |  | 0 | 0 | 0 | 0
Boral slopped sill | Per Foot |  |  | 19.32584269662921 |  |  | 0 | 0 |  | 4.25 | 3.63 | 7.31 | 0.5 | 0.85 | 0.89 | 19.32584269662921 |  | 0 | 0 | 0 | 0
[NAME] 2 1/2"x 4/4 | Per Foot |  |  | 8.671513549239922 |  |  | 0 | 0 |  | 2.25 | 1.03 | 3.28 | 0.5 | 0.85 | 0.89 | 8.671513549239922 |  | 0 | 0 | 0 | 0
Smooth Aluminum Wrap | Per Foot |  |  | 7.790262172284645 |  |  | 0 | 0 |  | 1.75 | 1.62 | 3.12 | 0.5 | 0.9 | 0.89 | 7.790262172284645 |  | 0 | 0 | 0 | 0
Charter Oak Triple 3 1/2" vented | Per Foot |  |  | 8.46441947565543 |  |  | 0 | 0 |  | 1.75 | 1.89 | 3.39 | 0.5 | 0.9 | 0.89 | 8.46441947565543 |  | 0 | 0 | 0 | 0
Miratek 5 1/2" Trim Painted | Per Foot |  |  | 11.97620621282221 |  |  | 0 | 0 |  | 3 | 1.53 | 4.53 | 0.5 | 0.85 | 0.89 | 11.97620621282221 |  | 0 | 0 | 0 | 0
Miratek 7 1/2" Trim Painted | Per Foot |  |  | 13.61533377395902 |  |  | 0 | 0 |  | 3.15 | 2 | 5.15 | 0.5 | 0.85 | 0.89 | 13.61533377395902 |  | 0 | 0 | 0 | 0
Miratek 11 1/2" Trim Painted | Per Foot |  |  | 19.06146728354263 |  |  | 0 | 0 |  | 4.1 | 3.11 | 7.209999999999999 | 0.5 | 0.85 | 0.89 | 19.06146728354263 |  | 0 | 0 | 0 | 0
[NAME] 16" Trim Painted | Per Foot |  |  | 23.18572372769333 |  |  | 0 | 0 |  | 4.75 | 4.02 | 8.77 | 0.5 | 0.85 | 0.89 | 23.18572372769333 |  | 0 | 0 | 0 | 0
PVC/Boral 4" x 5/4 Trim | Per Foot |  |  | 16.33840052875082 |  |  | 0 | 0 |  | 2.9 | 3.28 | 6.18 | 0.5 | 0.85 | 0.89 | 16.33840052875082 |  | 0 | 0 | 0 | 0
PVC/Boral 6" x 5/4 Trim | Per Foot |  |  | 19.32584269662921 |  |  | 0 | 0 |  | 3 | 4.31 | 7.31 | 0.5 | 0.85 | 0.89 | 19.32584269662921 |  | 0 | 0 | 0 | 0
PVC/Boral 8" x 5/4 Trim | Per Foot |  |  | 20.59484467944481 |  |  | 0 | 0 |  | 3.15 | 4.64 | 7.789999999999999 | 0.5 | 0.85 | 0.89 | 20.59484467944481 |  | 0 | 0 | 0 | 0
PVC/Boral 10" x 5/4 Trim | Per Foot |  |  | 21.89028420356907 |  |  | 0 | 0 |  | 3.15 | 5.13 | 8.28 | 0.5 | 0.85 | 0.89 | 21.89028420356907 |  | 0 | 0 | 0 | 0
PVC/Boral 12" x 5/4 Trim | Per Foot |  |  | 29.13417052214144 |  |  | 0 | 0 |  | 4.1 | 6.92 | 11.02 | 0.5 | 0.85 | 0.89 | 29.13417052214144 |  | 0 | 0 | 0 | 0
PVC/Boral 16" x 5/4 Trim | Per Foot |  |  | 37.62062128222075 |  |  | 0 | 0 |  | 4.75 | 9.48 | 14.23 | 0.5 | 0.85 | 0.89 | 37.62062128222075 |  | 0 | 0 | 0 | 0
FASCIA
[NAME] 4/4"x7 1/2" | Per Foot |  |  | 12.29345670852611 |  |  | 0 | 0 |  | 3.25 | 1.4 | 4.65 | 0.5 | 0.85 | 0.89 | 12.29345670852611 |  | 0 | 0 | 0 | 0
[NAME] 4/4"x11 1/2" | Per Foot |  |  | 15.70389953734303 |  |  | 0 | 0 |  | 4.25 | 1.69 | 5.94 | 0.5 | 0.85 | 0.89 | 15.70389953734303 |  | 0 | 0 | 0 | 0
Required flashing at gutter runs for XLD | Per Foot |  |  | 3.965631196298744 |  |  | 0 | 0 |  | 0.75 | 0.75 | 1.5 | 0.5 | 0.85 | 0.89 | 3.965631196298744 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 7.931262392597488 |  |  | 0 | 0 |  | 1.75 | 1.25 | 3 | 0.5 | 0.85 | 0.89 | 7.931262392597488 |  | 0 | 0 | 0 | 0
[NAME] 5/16" Shingle Mould | Per Foot |  |  | 8.327825512227363 |  |  | 0 | 0 |  | 1.75 | 1.4 | 3.15 | 0.5 | 0.85 | 0.89 | 8.327825512227363 |  | 0 | 0 | 0 | 0
[NAME] Mould 2 1/2"x 4/4 | Per Foot |  |  | 8.037012557832123 |  |  | 0 | 0 |  | 1.75 | 1.29 | 3.04 | 0.5 | 0.85 | 0.89 | 8.037012557832123 |  | 0 | 0 | 0 | 0
Miratec Shingle Mould 2 1/2"x 4/4 | Per Foot |  |  | 7.666886979510905 |  |  | 0 | 0 |  | 1.75 | 1.15 | 2.9 | 0.5 | 0.85 | 0.89 | 7.666886979510905 |  | 0 | 0 | 0 | 0
PVC Shingle Moulding | Per Foot |  |  | 8.592200925313946 |  |  | 0 | 0 |  | 1.75 | 1.5 | 3.25 | 0.5 | 0.85 | 0.89 | 8.592200925313946 |  | 0 | 0 | 0 | 0
Rafter Tail Blocking | Per Foot |  |  | 5.948446794448116 |  |  | 0 | 0 |  | 1.5 | 0.75 | 2.25 | 0.5 | 0.85 | 0.89 | 5.948446794448116 |  | 0 | 0 | 0 | 0
Soffit
[NAME]  (<12" overhang) | Per Foot |  |  | 20.17184401850628 |  |  | 0 | 0 |  | 3.5 | 4.13 | 7.63 | 0.5 | 0.85 | 0.89 | 20.17184401850628 |  | 0 | 0 | 0 | 0
[NAME]  (13" - 16" overhang) | Per Foot |  |  | 22.07534699272968 |  |  | 0 | 0 |  | 3.5 | 4.85 | 8.35 | 0.5 | 0.85 | 0.89 | 22.07534699272968 |  | 0 | 0 | 0 | 0
[NAME]  (24" - 36" overhang) | Per Foot |  |  | 23.34434897554527 |  |  | 0 | 0 |  | 3.5 | 5.33 | 8.83 | 0.5 | 0.85 | 0.89 | 23.34434897554527 |  | 0 | 0 | 0 | 0
Soffit over Existing Siding, Includes Trim | Per Foot |  |  | 17.58625247851949 |  |  | 0 | 0 |  | 4.002 | 2.65 | 6.651999999999999 | 0.5 | 0.85 | 0.89 | 17.58625247851949 |  | 0 | 0 | 0 | 0
Reynolds Vinyl Soffit (<12" overhang) | Per Foot |  |  | 11.92333113020489 |  |  | 0 | 0 |  | 2.25 | 2.26 | 4.51 | 0.5 | 0.85 | 0.89 | 11.92333113020489 |  | 0 | 0 | 0 | 0
Reynolds Vinyl Soffit (13"-24" overhang) | Per Foot |  |  | 14.27627230667548 |  |  | 0 | 0 |  | 2.25 | 3.15 | 5.4 | 0.5 | 0.85 | 0.89 | 14.27627230667548 |  | 0 | 0 | 0 | 0
Reynolds Vinyl Soffit (24"-36" overhang) | Per Foot |  |  | 14.03833443489756 |  |  | 0 | 0 |  | 2 | 3.31 | 5.31 | 0.5 | 0.85 | 0.89 | 14.03833443489756 |  | 0 | 0 | 0 | 0
[NAME] Porch Ceiling | Per Square |  |  | 1383.978849966953 |  |  | 0 | 0 |  | 195 | 328.49 | 523.49 | 0.5 | 0.85 | 0.89 | 1383.978849966953 |  | 0 | 0 | 0 | 0
[NAME] (including stain/poly) | Per Square |  |  | 2379.378717779246 |  |  | 0 | 0 |  | 425 | 475 | 900 | 0.5 | 0.85 | 0.89 | 2379.378717779246 |  | 0 | 0 | 0 | 0
Car siding porch ceiling (including stain/poly) | Per square |  |  | 1916.721744877726 |  |  | 0 | 0 |  | 350 | 375 | 725 | 0.5 | 0.85 | 0.89 | 1916.721744877726 |  | 0 | 0 | 0 | 0
Paint Foundation and/or Porch Ceiling | Per Square |  |  | 212.5049570389954 |  |  | 0 | 0 |  | 65 | 15.38 | 80.38 | 0.5 | 0.85 | 0.89 | 212.5049570389954 |  | 0 | 0 | 0 | 0
Paint Fascia | Per Foot |  |  | 7.799074686054198 |  |  | 0 | 0 |  | 2.25 | 0.7 | 2.95 | 0.5 | 0.85 | 0.89 | 7.799074686054198 |  | 0 | 0 | 0 | 0
Paint Soffit | Per Foot |  |  | 7.799074686054198 |  |  | 0 | 0 |  | 2.25 | 0.7 | 2.95 | 0.5 | 0.85 | 0.89 | 7.799074686054198 |  | 0 | 0 | 0 | 0
GUTTERS
5" Gutter with 2 x 3 Downspouts | Per Foot |  |  | 10.57501652346332 |  |  | 0 | 0 |  | 4 | 0 | 4 | 0.5 | 0.85 | 0.89 | 10.57501652346332 |  | 0 | 0 | 0 | 0
5" Gutter with 3 x 4 Downspouts | Per Foot |  |  | 11.34170522141441 |  |  | 0 | 0 |  | 4.29 | 0 | 4.29 | 0.5 | 0.85 | 0.89 | 11.34170522141441 |  | 0 | 0 | 0 | 0
6" Gutter with 3 x 4 Downspouts | Per Foot |  |  | 11.89689358889623 |  |  | 0 | 0 |  | 4.5 | 0 | 4.5 | 0.5 | 0.85 | 0.89 | 11.89689358889623 |  | 0 | 0 | 0 | 0
Remove and [NAME] | Per Foot |  |  | 11.89689358889623 |  |  | 0 | 0 |  | 4.5 | 0 | 4.5 | 0.5 | 0.85 | 0.89 | 11.89689358889623 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 7.931262392597488 |  |  | 0 | 0 |  | 3 | 0 | 3 | 0.5 | 0.85 | 0.89 | 7.931262392597488 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 21.15003304692664 |  |  | 0 | 0 |  | 8 | 0 | 8 | 0.5 | 0.85 | 0.89 | 21.15003304692664 |  | 0 | 0 | 0 | 0
JAMES HARDIE WRAP
[NAME] | Per Foot |  |  | 9.966953073364177 |  |  | 0 | 0 |  | 2.15 | 1.62 | 3.77 | 0.5 | 0.85 | 0.89 | 9.966953073364177 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 18.21546596166557 |  |  | 0 | 0 |  | 4.15 | 2.74 | 6.890000000000001 | 0.5 | 0.85 | 0.89 | 18.21546596166557 |  | 0 | 0 | 0 | 0
[NAME] 3-sided Wrap | Per Foot |  |  | 26.4375413086583 |  |  | 0 | 0 |  | 6.15 | 3.85 | 10 | 0.5 | 0.85 | 0.89 | 26.4375413086583 |  | 0 | 0 | 0 | 0
[NAME] | Per Foot |  |  | 33.33773959021811 |  |  | 0 | 0 |  | 8.15 | 4.46 | 12.61 | 0.5 | 0.85 | 0.89 | 33.33773959021811 |  | 0 | 0 | 0 | 0
[NAME] Timber 1-sided wrap | Per Foot |  |  | 29.21348314606742 |  |  | 0 | 0 |  | 3 | 8.05 | 11.05 | 0.5 | 0.85 | 0.89 | 29.21348314606742 |  | 0 | 0 | 0 | 0
[NAME] Timber 2-sided wrap | Per Foot |  |  | 31.85723727693325 |  |  | 0 | 0 |  | 4 | 8.05 | 12.05 | 0.5 | 0.85 | 0.89 | 31.85723727693325 |  | 0 | 0 | 0 | 0
[NAME] Timber 3-sided wrap | Per Foot |  |  | 55.78321216126901 |  |  | 0 | 0 |  | 5 | 16.1 | 21.1 | 0.5 | 0.85 | 0.89 | 55.78321216126901 |  | 0 | 0 | 0 | 0
[NAME] Timber 4-sided wrap | Per Foot |  |  | 79.70918704560475 |  |  | 0 | 0 |  | 6 | 24.15 | 30.15 | 0.5 | 0.85 | 0.89 | 79.70918704560475 |  | 0 | 0 | 0 | 0
Paint Porch Beam and/or Columns | Per Foot |  |  | 16.25908790482485 |  |  | 0 | 0 |  | 2.15 | 4 | 6.15 | 0.5 | 0.85 | 0.89 | 16.25908790482485 |  | 0 | 0 | 0 | 0
Aluminum Beam Wrap | Per Foot |  |  | 17.42233972240582 |  |  | 0 | 0 |  | 4.25 | 2.34 | 6.59 | 0.5 | 0.85 | 0.89 | 17.42233972240582 |  | 0 | 0 | 0 | 0
COLUMNS (Tuscan Cap and [NAME]) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0 | 0 | 0
New Aluminum Columns 8"x8' or less | Per Column |  |  | 715.3998678122935 |  |  | 0 | 0 |  | 95 | 175.6 | 270.6 | 0.5 | 0.85 | 0.89 | 715.3998678122935 |  | 0 | 0 | 0 | 0
New Aluminum Columns 8"x10' or less | Per Column |  |  | 793.1262392597488 |  |  | 0 | 0 |  | 95 | 205 | 300 | 0.5 | 0.85 | 0.89 | 793.1262392597488 |  | 0 | 0 | 0 | 0
SQUARE SMOOTH | Per Column |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0.5 | 0.85 | 0.89 | 0 |  | 0 | 0 | 0 | 0
Square 6" x 9' Smooth (Tuscan cap and base) | Per Column |  |  | 914.738929279577 |  |  | 0 | 0 |  | 95 | 251 | 346 | 0.5 | 0.85 | 0.89 | 914.738929279577 |  | 0 | 0 | 0 | 0
Square 8" x 9' Smooth (Tuscan cap and base) | Per Column |  |  | 1083.93919365499 |  |  | 0 | 0 |  | 95 | 315 | 410 | 0.5 | 0.85 | 0.89 | 1083.93919365499 |  | 0 | 0 | 0 | 0
Square 10" x 9' Smooth (Tuscan cap and base) | Per Column |  |  | 1335.095836087244 |  |  | 0 | 0 |  | 95 | 410 | 505 | 0.5 | 0.85 | 0.89 | 1335.095836087244 |  | 0 | 0 | 0 | 0
Square 12' x 9' Smooth (Tuscan cap and base) | Per Column |  |  | 1662.921348314607 |  |  | 0 | 0 |  | 95 | 534 | 629 | 0.5 | 0.85 | 0.89 | 1662.921348314607 |  | 0 | 0 | 0 | 0
SQAURE FLUTED | Per Column |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0.5 | 0.85 | 0.89 | 0 |  | 0 | 0 | 0 | 0
Square 8" x 9' Fluted (Tuscan cap and base) | Per Column |  |  | 1417.052214144085 |  |  | 0 | 0 |  | 95 | 441 | 536 | 0.5 | 0.85 | 0.89 | 1417.052214144085 |  | 0 | 0 | 0 | 0
Square 10" x 10' Fluted (Tuscan cap and base) | Per Column |  |  | 1890.284203569068 |  |  | 0 | 0 |  | 95 | 620 | 715 | 0.5 | 0.85 | 0.89 | 1890.284203569068 |  | 0 | 0 | 0 | 0
ROUND NON-TAPERED | Per Column |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0.5 | 0.85 | 0.89 | 0 |  | 0 | 0 | 0 | 0
Round 8" x 9' Smooth (Tuscan cap and base) | Per Column |  |  | 896.2326503635162 |  |  | 0 | 0 |  | 95 | 244 | 339 | 0.5 | 0.85 | 0.89 | 896.2326503635162 |  | 0 | 0 | 0 | 0
Round 10" x 9'  Smooth (Tuscan cap and base) | Per Column |  |  | 1036.351619299405 |  |  | 0 | 0 |  | 95 | 297 | 392 | 0.5 | 0.85 | 0.89 | 1036.351619299405 |  | 0 | 0 | 0 | 0
Round 12" x 9'  Smooth (Tuscan cap and base) | Per Column |  |  | 1242.56444150694 |  |  | 0 | 0 |  | 95 | 375 | 470 | 0.5 | 0.85 | 0.89 | 1242.56444150694 |  | 0 | 0 | 0 | 0
ROUNDS NON-TAPERED FLUTED | Per Column |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0.5 | 0.85 | 0.89 | 0 |  | 0 | 0 | 0 | 0
Round 8" x 9' Fluted (Tuscan cap and base) | Per Column |  |  | 880.3701255783212 |  |  | 0 | 0 |  | 95 | 238 | 333 | 0.5 | 0.85 | 0.89 | 880.3701255783212 |  | 0 | 0 | 0 | 0
Round 10" x 9' Fluted (Tuscan cap and base) | Per Column |  |  | 1046.926635822869 |  |  |  |  |  | 95 | 301 | 396 | 0.5 | 0.85 | 0.89 | 1046.926635822869 |  | 0 | 0 | 0 | 0
Round 12" x 9' Fluted (Tuscan cap and base) | Per Column |  |  | 1086.582947785856 |  |  | 0 | 0 |  | 95 | 316 | 411 | 0.5 | 0.85 | 0.89 | 1086.582947785856 |  | 0 | 0 | 0 | 0
ALL OTHER COLUMNS TO BE PRICED SEPARATELY | Per Column |  |  | 0 |  |  | 0 | 0 |  | 0 | 0 | 0 | 0.5 | 0.85 | 0.89 | 0 |  | 0 | 0 | 0 | 0
Garage Door Wraps
[NAME] Garage Door Wrap | Per Door |  |  | 519.8942498347654 |  |  | 0 | 0 |  | 95 | 101.65 | 196.65 | 0.5 | 0.85 | 0.89 | 519.8942498347654 |  | 0 | 0 | 0 | 0
[NAME] Garage Door Wrap | Per Door |  |  | 721.4805023132849 |  |  | 0 | 0 |  | 115 | 157.9 | 272.9 | 0.5 | 0.85 | 0.89 | 721.4805023132849 |  | 0 | 0 | 0 | 0
Shutters
New Shutters | Per Set |  |  | 280.2379378717779 |  |  | 0 | 0 |  | 40 | 66 | 106 | 0.5 | 0.85 | 0.89 | 280.2379378717779 |  | 0 | 0 | 0 | 0
New James Hardie Shutters | Per Set |  |  | 420.45 |  |  | 0 | 0 |  | 75 | 107 | 182 | 0.5 | 0.85 | 0.89 | 481.163251817581 |  | 0 | 0 | 0 | 0
Artisan Shutters | Per Set |  |  | 822.6834104428289 |  |  | 0 | 0 |  | 125 | 186.18 | 311.18 | 0.5 | 0.85 | 0.89 | 822.6834104428289 |  | 0 | 0 | 0 | 0
Cedar shutters with cap and hardware | Per Set |  |  | 1189.689358889623 |  |  | 0 | 0 |  | 250 | 200 | 450 | 0.5 | 0.85 | 0.89 | 1189.689358889623 |  | 0 | 0 | 0 | 0
Atlantic Premium Shutters with Hardware | Per Set |  |  | 2432.253800396563 |  |  |  |  |  | 275 | 645 | 920 | 0.5 | 0.85 | 0.89 | 2432.253800396563 |  | 0 | 0 | 0 | 0
Paint Shutters | Per Set |  |  | 252.8222075346993 |  |  | 0 | 0 |  | 70 | 25.63 | 95.63 | 0.5 | 0.85 | 0.89 | 252.8222075346993 |  | 0 | 0 | 0 | 0
Shutters on [NAME] | Per Shutter |  |  | 52.87508261731659 |  |  | 0 | 0 |  | 20 | 0 | 20 | 0.5 | 0.85 | 0.89 | 52.87508261731659 |  | 0 | 0 | 0 | 0
Vents
New Gable Vent | Per Vent |  |  | 277.5941837409121 |  |  | 0 | 0 |  | 40 | 65 | 105 | 0.5 | 0.85 | 0.89 | 277.5941837409121 |  | 0 | 0 | 0 | 0
New Round Gable Vent 22" to 36" | Per Vent |  |  | 335.9920687376074 |  |  | 0 | 0 |  | 40.089 | 87 | 127.089 | 0.5 | 0.85 | 0.89 | 335.9920687376074 |  | 0 | 0 | 0 | 0
Mouldings
PVC Dentil Moulding | Per Foot |  |  | 14.67283542630535 |  |  | 0 | 0 |  | 2.25 | 3.3 | 5.55 | 0.5 | 0.85 | 0.89 | 14.67283542630535 |  | 0 | 0 | 0 | 0
PVC Plant Moulding | Per Foot |  |  | 10.17845340383344 |  |  | 0 | 0 |  | 2.25 | 1.6 | 3.85 | 0.5 | 0.85 | 0.89 | 10.17845340383344 |  | 0 | 0 | 0 | 0
PVC [NAME] | Per Foot |  |  | 10.17845340383344 |  |  | 0 | 0 |  | 2.25 | 1.6 | 3.85 | 0.5 | 0.85 | 0.89 | 10.17845340383344 |  | 0 | 0 | 0 | 0
PVC Crown Moulding | Per Foot |  |  | 12.92795769993391 |  |  | 0 | 0 |  | 2.75 | 2.14 | 4.890000000000001 | 0.5 | 0.85 | 0.89 | 12.92795769993391 |  | 0 | 0 | 0 | 0
PVC Drip Cap | Per Foot |  |  | 10.17845340383344 |  |  | 0 | 0 |  | 2.25 | 1.6 | 3.85 | 0.5 | 0.85 | 0.89 | 10.17845340383344 |  | 0 | 0 | 0 | 0
PVC Window Crosshead | Per Window |  |  | 320.6609385327165 |  |  | 0 | 0 |  | 50 | 71.29 | 121.29 | 0.5 | 0.85 | 0.89 | 320.6609385327165 |  | 0 | 0 | 0 | 0
Raised panel for dormers | Per Door |  |  | 350.9319233311302 |  |  | 0 | 0 |  | 45 | 87.74 | 132.74 | 0.5 | 0.85 | 0.89 | 350.9319233311302 |  | 0 | 0 | 0 | 0
Keystone for windows/doors | Per Keystone |  |  | 52.87508261731659 |  |  | 0 | 0 |  | 5 | 15 | 20 | 0.5 | 0.85 | 0.89 | 52.87508261731659 |  | 0 | 0 | 0 | 0
Rot Repair
Replace [NAME] | Per Foot |  |  | 8.653007270323862 |  |  | 0 | 0 |  | 2.003 | 1.27 | 3.273 | 0.5 | 0.85 | 0.89 | 8.653007270323862 |  | 0 | 0 | 0 | 0
Replace Sheeting | Per Sheet |  |  | 118.9689358889623 |  |  | 0 | 0 |  | 20 | 25 | 45 | 0.5 | 0.85 | 0.89 | 118.9689358889623 |  | 0 | 0 | 0 | 0
Hourly rate (time and material quotes) | Per Hour |  |  | 105.7501652346332 |  |  | 0 | 0 |  | 40 | 0 | 40 | 0.5 | 0.85 | 0.89 | 105.7501652346332 |  | 0 | 0 | 0 | 0
Specialty Painting
Paint Dentil Mould | Per Foot |  |  | 12.82220753469927 |  |  | 0 | 0 |  | 2.5 | 2.35 | 4.85 | 0.5 | 0.85 | 0.89 | 12.82220753469927 |  | 0 | 0 | 0 | 0
Paint Dentil Mould/Frieze Board/Crown Combo | Per Foot |  |  | 18.05684071381361 |  |  | 0 | 0 |  | 3.75 | 3.08 | 6.83 | 0.5 | 0.85 | 0.89 | 18.05684071381361 |  | 0 | 0 | 0 | 0
Paint Entry Door | Per Door |  |  | 383.3443489755453 |  |  | 0 | 0 |  | 125 | 20 | 145 | 0.5 | 0.85 | 0.89 | 383.3443489755453 |  | 0 | 0 | 0 | 0
Paint Entry Door with glass/sidelite | Per Door |  |  | 449.438202247191 |  |  | 0 | 0 |  | 150 | 20 | 170 | 0.5 | 0.85 | 0.89 | 449.438202247191 |  | 0 | 0 | 0 | 0
Paint Garage Door (Single) | Per Door |  |  | 255.2015862524785 |  |  | 0 | 0 |  | 75 | 21.53 | 96.53 | 0.5 | 0.85 | 0.89 | 255.2015862524785 |  | 0 | 0 | 0 | 0
Paint Garage Door (Double) | Per Door |  |  | 474.3688037012558 |  |  | 0 | 0 |  | 125 | 54.43 | 179.43 | 0.5 | 0.85 | 0.89 | 474.3688037012558 |  | 0 | 0 | 0 | 0
Screen Eze Project
Section of screen-eze labor | Per Section |  |  | 185.0627891606081 |  |  | 0 | 0 |  | 70 | 0 | 70 | 0.5 | 0.85 | 0.89 | 185.0627891606081 |  | 0 | 0 | 0 | 0
Lineal Feet of track | Per Foot |  |  | 15.86252478519498 |  |  | 0 | 0 |  | 3 | 3 | 6 | 0.5 | 0.85 | 0.89 | 15.86252478519498 |  | 0 | 0 | 0 | 0
Screen Material | Per Square |  |  | 602.7759418374092 |  |  | 0 | 0 |  | 3 | 225 | 228 | 0.5 | 0.85 | 0.89 | 602.7759418374092 |  | 0 | 0 | 0 | 0
Zip Up Under-decking | Per Square Foot |  |  | 37.01255783212162 |  |  | 0 | 0 |  | 7 | 7 | 14 | 0.5 | 0.85 | 0.89 | 37.01255783212162 |  | 0 | 0 | 0 | 0
Garage Doors
Standard Double Garage Door | Per Door |  |  | 2060.621282220754 |  |  | 0 | 0 |  | 725 | 54.43 | 779.43 | 0.5 | 0.85 | 0.89 | 2060.621282220754 |  | 0 | 0 | 0 | 0
Standard Single Garaga Door | Per Door |  |  | 1531.870456047587 |  |  | 0 | 0 |  | 525 | 54.43 | 579.43 | 0.5 | 0.85 | 0.89 | 1531.870456047587 |  | 0 | 0 | 0 | 0
Lead Paint Extra Cost
Lead testing service | Per Job |  |  | 528.7508261731659 |  |  |  |  |  | 200 | 0 | 200 | 0.5 | 0.85 | 0.89 | 528.7508261731659 |  | 0 | 0 | 0 | 0
1st Story Lead paint containment procedures | Per Square |  |  | 267.0191672174488 |  |  | 0 | 0 |  | 75 | 26 | 101 | 0.5 | 0.85 | 0.89 | 267.0191672174488 |  | 0 | 0 | 0 | 0
2nd Story Lead paint containment procedures | Per Square |  |  | 280.2379378717779 |  |  | 0 | 0 |  | 80 | 26 | 106 | 0.5 | 0.85 | 0.89 | 280.2379378717779 |  | 0 | 0 | 0 | 0
1st Story Soffit/Fascia containment procedures | Per Ln. Ft. |  |  | 5.287508261731659 |  |  | 0 | 0 |  | 2 | 0 | 2 | 0.5 | 0.85 | 0.89 | 5.287508261731659 |  | 0 | 0 | 0 | 0
2nd Story Soffit/Fascia containment procedures | Per Ln. Ft. |  |  | 6.609385327164574 |  |  | 0 | 0 |  | 2.5 | 0 | 2.5 | 0.5 | 0.85 | 0.89 | 6.609385327164574 |  | 0 | 0 | 0 | 0
Additional/Custom Work
Custom Work | Per Job |  |  | 1 |  |  | 0 | 0
Custom Work | Per Job |  |  | 1 |  |  | 0 | 0
set up for fascia | Per Job |  |  | 450 |  |  | 0 | 0
Additional Work | Per Job |  |  | 1667 |  |  | 0 | 0
Material Prep | Per Job | 1 | 1 | 330 |  |  | 330 | 330 |  |  |  |  |  |  |  |  |  | 967.5 | 0 | 964.15 | 0
Administration Fee | Per Job | 1 | 1 | 125 |  |  | 125 | 125
Total |  |  |  |  |  |  | 4599.481163251818 | 455
Summary Recap | Sales | Production |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Summary Recap | Sales | Production
Retail Price ($) | 4599.481163251818 | 455 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Retail Price ($) | 4599.481163251818 | 455
Sale Price ($) | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Sale Price ($) | 0 | 0
Percent of Retail | 0 | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Percent of Retail | 0 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Labor cost | 967.5 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Material cost | 964.15 | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COGS $$ | 1931.65 | 0
 | Artic White | White-Artic White |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | COGS %% | #N/A | #N/A
 | [NAME] | [NAME]: [NAME] |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Gross Profit | -1931.65 | 0
 | [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