Skip to content
CyanBuild

Drywall takeoff spreadsheet: separate surface area, layers and board count

A drywall takeoff spreadsheet has to answer three separate questions: how much board surface the project needs, how many layers the assembly calls for, and how many sheets a supplier has to deliver. A worksheet that answers only the first gives you a square-foot figure with no product attached. Keep the surface, the layer count and the order quantity in separate fields, and let the drawing reference travel with every row. The downloadable CSV below opens in a spreadsheet and carries one labelled example row: an assumed 12 ft by 8 ft wall face, one layer, 96 square feet of gross area, and 3 sheets at a 32 square-foot sheet size. Those numbers illustrate the arithmetic. They are not a measured job, a specification or a waste allowance.

By CyanBuild. Figures checked .

Naming each surface so a face count cannot be read as a wall count

Start every row with the surface rather than the room. Level 2 corridor north face is a surface. Level 2 corridor is a place, and a place can hold four surfaces plus a ceiling. Give each face its own row, then add the ceiling planes as separate rows, and identify each side of a partition so the same wall is not counted once from each direction. Where a partition receives board on one side only, say so in the row instead of in a note at the foot of the sheet. The layer column then answers a different question from the surface column: a surface row can carry one layer, two layers, or a pointer to the wall section that sets the layer count for a rated assembly. Where a room has a bulkhead, a soffit and a sloped ceiling, those are three more surfaces. ASTM C1396/C1396M groups gypsum board into nine categories, including gypsum ceiling board and exterior gypsum soffit board, so a ceiling quantity and a soffit quantity belong on different rows even when both are measured in square feet.

Reading board thickness and type out of the assembly note

The board specification column should hold what the drawings actually say rather than a generic label such as drywall. A rated wall assembly, a moisture-resistant wallboard and an exterior gypsum sheathing board are different products with different sheet sizes, edge treatments and fastening. ASTM C1396/C1396M, the standard specification for gypsum board, covers gypsum wallboard, predecorated gypsum board, gypsum backing and coreboard, water-resistant gypsum backing board, exterior gypsum soffit board, gypsum sheathing board, gypsum base for veneer plaster, gypsum lath and gypsum ceiling board. Those categories are why one board column will not hold a whole job. Transcribe the thickness the assembly note gives, and transcribe the type as well. Where a detail calls for a thickness and the plan does not, the detail governs and the row should point at it. If two thicknesses appear on the same surface, split the surface into two rows and split the square footage between them.

Turning net area into a sheet count without dropping the layer

The sample row in the worksheet shows the conversion in its simplest form. An assumed 12 ft by 8 ft face gives a gross area of 96 square feet. A 4 ft by 8 ft sheet has a nominal area of 32 square feet, so 96 divided by 32 is 3 sheets for one layer. The arithmetic is exact because both numbers are multiples of the same sheet size. Two things break it in practice. Layers come first: the same 96 square feet at two layers needs 6 sheets, and the layer count has to stay visible next to the area so a reviewer can see which number moved. Cuts come second. A 96 square foot face rarely divides into whole sheets without offcuts, and those offcuts may or may not land on another surface. Record any order allowance on its own line with its reason, because a supplier asked for 4 sheets and a worksheet showing 3 starts a dispute. NIST Handbook 44 sets out the exact relationships between these US customary units and underlines the values that should not be rounded before the multiplication is done.

Handling openings so a door gap is not counted twice

Openings reduce net area, and there are two ways to handle them. You can deduct the full opening from the gross area, or you can deduct it and count the perimeter treatment separately. Pick one method and record it on the sheet. The common failure is deducting a 3 ft by 7 ft door from the wall area and then treating the doorway as an area of board as well, which credits the door twice. A second failure is subtracting an opening from a wall that never had it, because the count came from a floor plan symbol rather than from the elevation. Where the same opening sits in a rated wall, the assembly note may require board across the opening, and the deduction then follows the detail rather than the door schedule. A window smaller than a full sheet still has to be cut from a sheet, so the sheet count does not fall in proportion to the area. Keep gross area, deducted area and net area in three columns.

Keeping joint treatment, fasteners and accessories off the board count

Board is one scope item. Joint treatment, fasteners, corner bead and the edge accessories around openings and wall runs are separate items that a drywall supplier prices differently and often ships separately. ASTM C1047, the standard specification for accessories for gypsum wallboard and gypsum veneer base, covers the accessories used with gypsum wallboard assemblies to protect edges and corners and to provide architectural features. It sets requirements for the steel and paper components, and it requires that accessories be free of twist or camber and that their edges be free of burrs and sharp edges. The point for the takeoff is narrower than the standard. Corner bead and edge trim are line items with a length, and they do not follow from a square-foot consequence of the board count. A register that folds them into the board row hides them from review, and they are among the items most often left out of a delivery.

Recording the order allowance apart from the measured quantity

An allowance for cutting waste and offcuts is a purchasing decision, and it belongs in its own field with its reason attached. A percentage travels through the trade without a stated basis, and once it is in the sheet nobody can tell how much of the order came from measurement. Keep the measured area column unchanged, keep the sheet count as the arithmetic result, and add the allowance as a separate row that names the percentage and where it came from. If the allowance reflects a supplier's stated stock length rather than your own layout, say that, because the two behave differently. Two allowances on one surface is a recurring failure: a 10 percent allowance applied to the sheet count and then again to the order quantity. A reviewer should be able to trace any order figure back to a measured number plus one named adjustment. A figure that cannot be traced that way is a guess and should be labelled as one until the project team supplies the missing information.

What a supplier needs in order to price the board

A board request travels badly when it carries a square-foot total and a sheet count and nothing else. A supplier needs the product, the thickness, the assembly requirement behind it, the measured units, the site and the delivery constraints. Send the specification as the drawings state it, including whether the board is rated, moisture resistant or exterior sheathing, and send the quantity as sheets and square feet together so the supplier can check the arithmetic the same way you did. Put the accessory list in the request rather than describing it in a note, and state who is responsible for compatibility between the board, the joint treatment system and the accessories. ASTM C840 covers the minimum requirements for the methods of application and finishing of gypsum board, and its scope names the related items and accessories that go with interior walls, ceilings and exterior soffits.

What can you download and adapt?

A plain CSV worksheet you can open in Excel or another spreadsheet application. The values below are illustrative inputs, not measured project data. The CSV contains static values; it does not include formulas, macros, engineering checks or prices.

Illustration only. No project measurement or waste allowance is supplied.
DrawingSurfaceBoard specificationLength ftHeight ftLayersGross area SFSheet area SFExample sheet count
Example onlyWall faceConfirm from assembly128196323

The address receives the worksheet and occasional estimating notes. No account is created and no password is set.

What does CyanBuild software cost?

These are CyanBuild’s published software plans as checked on October 6, 2026. Each allowance is for PDF pages per month. You review the quantities; an outsourced takeoff service is a separate purchase.

Published monthly plans in USD. Source: CyanBuild pricing.
PlanMonthly pricePDF pages / month
Free$03
Starter$2930
Pro$99120
Enterprise$299400

Paid subscriptions renew according to their terms. A page allowance does not guarantee the completeness of a takeoff, and unused capacity does not turn the subscription into a per-project service. Check current features and terms before choosing a plan.

What else should you check?

Does the worksheet work for a corridor where one face is rated and the other is not?
Yes, as long as the two faces are separate rows. Put the rated face on one row with its assembly reference and layer count, and the other face on a second row with its own specification. The gross area may be identical for both rows and the sheet counts will not be, because the layer count and the board type differ. A single corridor row hides that difference, and it is the difference a supplier and an installer will ask about.
How do I handle a room where the drawings give a wall length but no wall height?
Take the height from the elevation, the wall section or the room dimension on the plan, and record which one you used in the drawing reference column. If nothing in the set gives the height, leave the height cell empty and flag the row for the project team. A ceiling height assumption multiplied across every room on a sheet is one of the easiest ways to carry a small error into a large order, and it is hard to unpick later.
Is a gypsum board ceiling on a metal grid measured the same way as one on framing?
The square feet are measured the same way, and the products are separate scope items. Record the board surface on the board rows, and record the grid, its supporting members and the hanger spacing on their own rows with their own units. A grid quantity is linear footage and hanger counts, while the board is area. Keeping them apart stops a grid total from being read as a board total and lets the two suppliers, who are often different companies, work from the same register.
Can I deduct a door opening once and apply the same figure to both layers?
The opening deduction applies to the net area, and the layer column then produces the sheet count for each layer. You do not deduct the door twice, once per layer, because the opening is a hole in the surface. Where a rated assembly needs board across the opening, that requirement comes from the detail and it overrides the door schedule, so record the change on the area or layer row where it stays visible.
Why does the sheet count in the sample not match what a supplier will deliver?
The sample divides 96 square feet by a 32 square-foot sheet size and arrives at 3, which is a pure area calculation. A supplier delivers whole sheets sized for the product and the framing, and the offcuts from one surface may or may not be usable on another. The gap between the area result and the delivered count is where layout, joint placement and the order allowance come in. Keep the area result and the delivered count as separate figures on the sheet.
Does the download carry a waste allowance?
No. The worksheet holds the measured dimensions, the gross area, the layer count and the area-based sheet count, and the note under the table says the sample values are illustrative. There is no default percentage in the file and the arithmetic does not imply one. If you add an allowance, add it as a separate row with the percentage and the reason, so a reviewer can separate the measurement from the purchasing decision.
Can this worksheet hold a suspended ceiling that is not gypsum board?
It can hold the rows, but the product column has to name what the ceiling actually is. That field is for the product the drawings specify, and a mineral fibre or acoustical tile ceiling is a different product with a different unit and a different supplier. Keep it on the register with its own rows and its own unit rather than forcing it into a square-foot board row. The worksheet is a structure, and the drawings decide what belongs in each row.

Where do the figures and product facts come from?

Sources checked November 9, 2026. Published prices can change; verify the actual terms before purchasing. Worked examples on this page are labeled separately from published product or service facts.

Check a drawing before you choose a plan.

Create an account, upload a representative PDF and compare the draft quantities with your drawing.

Create a free account