Coverting Square Feet Of Plywood To Sheets In Excel

Square feet of 1 2 inch plywood was equivalent to 2 000 square feet on the 3 8 basis.

Coverting square feet of plywood to sheets in excel.

The excel convert function converts a number in one measurement system to another. Then do the same thing for the width. A 4 8 sheet of plywood is 32 ft 2. It is used when purchasing multiple boards of lumber in various sizes.

It will help us change units in excel with a formula. Substituting this into the above formula results in an equivalent of 62 5 cubic feet of plywood. The excel convert function converts a number from one unit type e g. Unlike square footage the board footage is a measurement of volume.

How many 4 x 8 sheets of plywood do i need. If you would like to convert regular volume units into board feet use the following relation. This calculator does not simply divide the total square footage by 32. The excel convert function is useful in converting units from one measurement system to another measurement system.

Some videos you may like excel facts. I have a column of data with dimensions entered as y x z and need to convert them in the next column to square footage. Use the drop downs below to select a length in feet. All mbf calculations are based upon the nominal size of the lumber and not the actual size.

The function is new to excel 2007 so is not available in earlier versions of excel. Excel questions calculate square footage. Aug 6 2009 1 morning. 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 if the area to be covered in plywood is 800 ft 2 then 25 sheets of plywood will be needed to cover it. It figures how many pieces long then how many wide. 800 32 25 sheets.

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. For more complicated shapes see the instructions below. Yards to another unit type e g. By definition one board foot of lumber is one square foot that is one inch thick.

Hope someone has run into this before. The syntax of the function is. 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.