Spreadsheet: 154931d1336606976-excel-2007-reapply-the-auto-filter-on-a-workbook-after-the-enter-key-stroke-sample
Sheet: MATERIAL & LABOR INPUT PAGE

 | Client: | Job Cost List
 |  | Prepared by:
 | Audit & Inspection | Qty. | Unit Cost | Total |  |  |  |  |  |  |  |  |  | 24.32
 | Auditor Hours | 0 |  |  |  | Labor Rates: |  | 24.32 |  |  |  |  |  | 28.41
 | Inspection hours | 0
 | Totals
 | Health & Safety | Qty. | Unit Cost | Total
 | CO Alarm |  | 41.1
 | 9v Smoke Alarm |  | 4.2
 | [NAME] |  | 29.97
 | Tyvek suits |  | 5.8
 | 6 mil poly-sf |  | 0.08
 | Furnace Cold Air Filter |  | 4.44
 | Tyvek boots-ea |  | 0.75
 | Trash bags |  | 0.3
 | Rubber Gloves |  | 0.25
 | Dust Masks |  | 0.62
 | TEST 1 |  | 0
 | test 2 |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Repairs | Qty. | Unit Cost | Total
 | Plywood-1/4"
 | Plywood-3/8" |  | 12.97
 | Plywood-1/2" |  | 16.17
 | Plywood-5/8" |  | 17.97
 | Plywood-3/4" |  | 19.97
 | Pine 1x3" per/lf |  | 0.48
 | Pine 1x4" per/lf |  | 0.6
 | 2x4" studs |  | 2.32
 | 2x6" studs |  | 4.38
 | 2x4" studs-PT
 | 2x6" studs-PT |  | 4.97
 | 4x8 floor register |  | 3.34
 | 4x10 floor register |  | 3.67
 | 4x12 floor register |  | 7.48
 | Drywall |  | 6.45
 | 1x3 strapping-lf |  | 0.2
 | Aluminun Roof coating
 | [NAME] |  | 18.97
 | Dryer Wall Vent |  | 16.37
 | Fan Wall Vent |  | 16.37
 | Eve Vent |  | 8.82
 | 4" alum flex pipe |  | 9.97
 | 4" galv elbow |  | 4.16
 | 4" galv pipe |  | 3.45
 | 4" Ins. [NAME] |  | 22.95
 | 3" FSK Tape |  | 9
 | P Bath Fan & light |  | 127.71
 | P Bath Fan |  | 86.75
 | Timer Delay Switch |  | 30.31
 | Rangehood Fan |  | 47.99
 | Rangehood Fan Vent |  | 18.97
 | Heat Tape-lf |  | 2.14
 | Heat Tape-fuse plug |  | 13.25
 | T-stat control for heat tape |  | 19.96
 | Grilles |  | 11.27
 | 6" ins. Duct |  | 23.99
 | 6"x 24" galv pipe |  | 4.55
 | 6"x 60" galv pipe |  | 4.38
 | 6" galv elbows |  | 1.42
 | tie cables 36" |  | 0.2
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Attic Insulation | Qty. | Unit Cost | Total
 | Cellulose per/bag |  | 8.7
 | R30 Fiberglass-15" per/sf |  | 0.41
 | R30 Fiberglass-23" per/sf |  | 0
 | R19 Fiberglass-unfaced 23" |  | 0
 | R19 Fiberglass-unfaced 15" |  | 0
 | R19 Fiberglass-faced 23" |  | 0
 | R19 Fiberglass-faced 15" |  | 0
 | Blown fiberglass |  | 21.85
 | Raftermates-16" |  | 1.35
 | Raftermates-24" |  | 1.35
 | 2" Thermax-FR  per/sf |  | 1.51
 | Plywood-3/4 |  | 0
 | Panning-(damming) |  | 11.74
 | Install Gable Vent 12x12-alum |  | 0
 | Install Gable Vent 12x18-alum |  | 0
 | Install Gable Vent 12x12-wood |  | 0
 | install Gable Vent 12x18-wood |  | 0
 | Install Gable Vent 12x12-Vinyl |  | 0
 | Install Gable Vent 12x18-Vinyl |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Wall Insulation | Qty. | Unit Cost | Total
 | R19 Fiberglass-unfaced 23"
 | R19 Fiberglass-unfaced 15"
 | R19 Fiberglass-faced 23"
 | R19 Fiberglass-faced 15"
 | [NAME] 23" |  | 23.43
 | [NAME] 15"
 | [NAME] 23"
 | [NAME] 15"
 | Wood Plugs-1" |  | 0.18
 | Wood Plugs-2" |  | 0.18
 | Wood Plugs-21/2" |  | 0.18
 | Wood Plugs-3" |  | 0.32
 | Plastic Plugs-3" |  | 1
 | Poly-6 mil-sf |  | 0.08
 | FSK paper |  | 0.1
 | Drywall |  | 6.45
 | [NAME] compound |  | 6.42
 | 2" fiberglass tape |  | 6.85
 | Sta-Put Adh 16oz |  | 11.88
 | R11 foundation wrap-sf |  | 0.55
 | Strapping 1x3"-lf |  | 0.2
 | .22 loads |  | 0.07
 | 1 1/2" concrete nails w/washers |  | 0.13
 | [NAME] |  | 0.6
 | Tapcon Screws |  | 0.25
 | Insulweb-sf |  | 0.08
 | insulationNetting-sf |  | 0.06
 | T50- Staples |  | 4.5
 | 2" Thermax-FR  per/sf |  | 1.51
 | Cellulose per/bag |  | 8.7
 | Blown fiberglass |  | 21.85
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | GHW | Qty. | Unit Cost | Total
 | Aerator-bath |  | 0.75
 | Aerator-Kitchen |  | 2.56
 | Showerhead-message |  | 3.7
 | Showerhead-hand held-Ch |  | 9.8
 | Showerhead-hand held-Wh |  | 8.51
 | Pipe Wrap-Small |  | 1.05
 | Pipe Wrap-Large |  | 1.05
 | DHW Wrap- |  | 11
 | Thermostat-low voltage |  | 24.97
 | Thermostat-in-line |  | 44.1
 | 14Watt cfl |  | 1.77
 | 20Watt cfl |  | 2.23
 | 14Watt cfl os capsule |  | 2.93
 | 11Watt cfl bathroom |  | 4.37
 | 23 Watt flood light cfl |  | 6.98
 | Interior fixture |  | 14.97
 | Exterior fixture |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Air Sealing | Qty. | Unit Cost | Total
 | Qlon-White |  | 14.18
 | Qlon-Bronze |  | 14.18
 | Door Sweep |  | 1.95
 | AC Foam |  | 1.69
 | Foam W/S-3/16" |  | 1.69
 | Foam W/S-3/8" |  | 1.69
 | Foam W/S-1/2" |  | 2.39
 | Foam W/S-3/4" |  | 2.39
 | Caulking-Silicone-Clear |  | 2.95
 | Caulking-Silicone-White |  | 2.95
 | Caulking-Paintable-White |  | 2.56
 | Caulking-Paintable-Clear |  | 2.56
 | Caulking-Hi Temp |  | 3.79
 | Caulking-Fire Block |  | 6.98
 | Caulking-Thru-the-roof |  | 6.75
 | Caulking-Intument |  | 9.4
 | Duct Mastic (RCD #6 Gal) |  | 16.42
 | Spray Foam-16 oz |  | 6.97
 | Spray Foam- 32 oz |  | 13.34
 | Spray Foam-2 part |  | 711.75
 | Plywood-1/4" |  | 11.97
 | Plywood-1/2" |  | 16.17
 | Plywood-5/8"
 | Plywood-3/4" |  | 18.97
 | Joint Compound |  | 6.42
 | Drywall |  | 6.45
 | Poly 6 Mil.-sf |  | 0.08
 | Backer rod |  | 2.41
 | 2" Fiberglass Tape |  | 6.85
 | [NAME] |  | 13.99
 | TP-350 Poly Tape |  | 18.8
 | Alum Tape |  | 14.66
 | Pleated Alum. Per/lf |  | 1.09
 | AC Foam |  | 1.69
 | Panning |  | 9.34
 | Bumper threshold |  | 2.52
 | Oak threshold |  | 4.8
 | Tremco Acoustical Sealant |  | 12.65
 | Sikabond const. Adhesive |  | 6.43
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Floor  Insulation | Qty. | Unit Cost | Total
 | R19 Fiberglass-unfaced 23"
 | R19 Fiberglass-unfaced 15"
 | R19 Fiberglass-faced 23"
 | R19 Fiberglass-faced 15"
 | Cellulose |  | 8.7
 | R30 Fiberglass-15" per/sf |  | 0.41
 | R30 Fiberglass-23" per/sf |  | 0.41
 | Blown fiberglass |  | 21.85
 | Insulweb-sf |  | 0.08
 | Insulation Netting-sf |  | 0.06
 | Insulation Supports-16"
 | T50- Staples |  | 4.4
 | Stitch staples |  | 4.5
 | Belly Patch-sf |  | 0.81
 | Tyvek |  | 0.18
 | Strapping 1x3"-lf |  | 0.2
 | 2" Thermax-FR  per/sf |  | 1.51
 | Spray Foam-2-Part |  | 711.75
 | Spray Foam 1-part |  | 13.34
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Sill Insulation: | Qty. | Unit Cost | Total
 | 2" Thermax-FR  per/sf |  | 1.51
 | Spray Foam-2-Part |  | 711.75
 | [NAME] |  | 13.34
 | Caulking-Silicone-Clear |  | 2.95
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Doors/Windows | Qty. | Unit Cost | Total
 | 32" Metal Ins. Door |  | 0
 | 36" Metal Ins. Door |  | 0
 | lockset |  | 0
 | Trailer Door |  | 0
 |  |  | 0
 | Vinyl Replacement Window |  | 0
 | [NAME] |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | Appliances | Qty. | Unit Cost | Total
 | Fridge |  | 0
 | Freezer |  | 0
 | Washer |  | 0
 | [NAME] |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | LSW | Qty. | Unit Cost | Total
 | Tyvek suits |  | 5.8
 | 6 mil poly-sf |  | 0.08
 | Tyvek boots-ea |  | 0.75
 | Trash bags |  | 0.3
 | Rubber Gloves |  | 0.25
 | Dust Masks |  | 0.62
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | HEATING/ REPAIRS | Qty. | Unit Cost | Total
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost
 | SOLAR | Qty. | Unit Cost | Total
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 |  |  | 0
 | Total Materials
 | Labor: crew hrs.:
 | Total Cost