Coverting Square Feet Of Plywood To Sheets In Excel

If you would like to convert regular volume units into board feet use the following relation.

Coverting square feet of plywood to sheets in excel. By definition one board foot of lumber is one square foot that is one inch thick. Use the drop downs below to select a length in feet. It is used when purchasing multiple boards of lumber in various sizes. For more complicated shapes see the instructions below.

How many 4 x 8 sheets of plywood do i need. Here are a few tips on how to calculate or convert units of measure for lumber and panel products. Calculating thousand board feet mbf for lumber products. For example you can use convert to convert feet into meters pounds into kilograms fahrenheit to celsius gallons into liters and for many other unit conversions.

It figures how many pieces long then how many wide. Square feet of 1 2 inch plywood was equivalent to 2 000 square feet on the 3 8 basis. This calculator does not simply divide the total square footage by 32. A 4 8 sheet of plywood is 32 ft 2.

Take note of the length of each board and after all measurements are complete then use a calculator such as our feet and inches calculator to add the feet measurements together. Then do the same thing for the width. Unlike square footage the board footage is a measurement of volume. The excel convert function converts a number in one measurement system to another.

If the formula in section 1 which converts surface measure of any thickness to the 3 8 basis is substituted for sf3 8 the following general relationship is found. To find the linear feet of multiple pieces of lumber you need to measure the length of each piece and add the measurements together. For example convert will help us in converting pounds to kilograms feet to centimeters or fahrenheit to celsius. Yards to another unit type e g.

The excel convert function is useful in converting units from one measurement system to another measurement system. For example if the area to be covered in plywood is 800 ft 2 then 25 sheets of plywood will be needed to cover it. It will help us change units in excel with a formula. The syntax of the function is.

All mbf calculations are based upon the nominal size of the lumber and not the actual size. Finding linear feet of multiple boards. The function is new to excel 2007 so is not available in earlier versions of excel. Divide by the total square footage by the square footage of a sheet of plywood to find the number of sheets required to cover the space.