The "Essential" Excel Formulas for Estimating Concrete, Lumber, Brick, Roofing & Vents

For current price and purchase information, please visit:
takeoff-tech.m...
This spreadsheet includes:
Cubic Yard Formulas
You can easily estimate the volume of fill and concrete for:
✔ Slabs and Flatwork
✔ Round Piers
✔ Foundation Beams
Framing Lumber Takeoff Formulas
Do you ever need to calculate the sloped length of framing members? Use these formulas:
✔ Common Rafters & Barge Rafters
✔ Hip & Valley Rafters (both Equal and Unequal Roof Slopes)
✔ Stair Carriages (and Stair Riser Heights)
Brick Takeoff Formulas
If you do brick takeoffs, you've got to have these:
✔ Layup Factors (Bricks per Square Foot)
✔ Brick Wall Coverage Areas per Cube
✔ Brick Count and Full Cube Order Quantities
Roofing Takeoff Formulas
These are "must-haves" for roofing and roof decking estimators:
✔ Roof Slope Factors
✔ Roof Surface Area
✔ Squares and Bundles of Shingles
Roof Ventilation Formulas
Have you evert tried to interpret the Build Code? These make your calculations a breeze:
✔ 1/150 Net Free Attic Vent Area
✔ 1/300 Net Free Attic Vent Area
Area Square Footage Formulas
You can easily calculate the area of complex shapes when you're estimating foundations, walls, roofs, topsoil, building sites...
✔ Rectangles, Squares and Parallelograms
✔ Trapezoids
✔ Triangles (including Heron's Formula)
✔ Regular Polygons
✔ Cones
✔ Circles
✔ Rhombuses (Kites)
Feet-Inches Calculators
Skip the hand-held calculators and use Excel to keep a running total of all your plan measurements.
✔ Feet-Inches-Fractions
✔ Feet-Inches-Sixteenths (F-I-S)
Board Foot Calculators
Do you ever work with Board Feet? These formulas cuts through the confusion:
✔ Board Feet per Linear Foot
Estimator's Cheat Sheet
Improve your productivity with these handy references:
✔ Foot/Inch Decimal Equivalents
✔ 16" On Center & Foot/Inch Equivalents
✔ Roof Slope Factors
✔ Square Footage Yield per Cubic Yard of Concrete, Fill or Topsoil.
✔ Board Feet per Linear Piece
✔ Convert Price Per Thousand to Cost Per Piece
✔ Convert Cost Per Piece to Price Per Thousand
Takeoff Waste Factors
This report lists “field-tested” estimating waste factors for 63 takeoff items - including cornice, drywall, framing interior trim, masonry, roofing, sheathing & decking, and weatherproofing.
As estimators, we know over-estimating or under-estimating can cost thousands. I’ve been refining and using these waste factors over 25 years in the biz - giving trades “just enough” material to finish the job.

[@georgekiadii45]

I love this video, it actually help me a lot.How can I get a copy of the formula sheet?

[@Celine-ry9zj]

Hi John, great video! I would like to get a copy of the formula. Where can I get more information?