Skip to content
CyanBuild

Framing takeoff spreadsheet: counts, lengths and sheet goods

A framing takeoff spreadsheet has to separate three quantities that a summary hides: the number of members of each size, the length of each member, and the area of the sheet goods that cover them. Those three produce piece counts, linear feet and square feet, and they are bought from different suppliers. A register that mixes them produces a number that cannot be ordered. Keep the drawing, the assembly, the member specification and the unit on every row. The downloadable CSV below carries one labelled example: 12 assumed members at 8 ft, giving 96 linear feet. That is a multiplication and nothing more. It is not a member schedule, it is not a stud count derived from floor area, and the sheet carries no spacing, no structural assumption and no waste factor.

By CyanBuild. Figures checked .

Separating walls, floors and roof framing into their own assemblies

Start the register by assembly rather than by material. Wall framing, floor framing and roof framing have different member schedules, different sheet goods and different suppliers, and a wall stud never belongs in the same total as a roof rafter. Within each assembly, identify members by their actual specified dimensions and by any product requirement that distinguishes them. Engineered members sit apart from ordinary dimension lumber, because they are ordered from a different list at a different price. Where a member repeats identically across a floor, keep one row for it and record the repetition in the count, and name the floor or the grid area in the review note so a reader can find the repetition. A register that starts with the assembly is easier to reconcile against the framing plans than one that starts with the board size.

Naming a member by its actual dimensions rather than by its trade name

The member specification column should carry the dimensions and the product, because the trade name alone does not identify what arrives. A nominal 2x4 and a 2x4 of the same species and grade are different lengths and different weights, and a nominal size is not the actual dimension: NIST Handbook 44 gives the US customary relationships for length, area and volume, including 12 inches to a foot and 1,728 cubic inches to a cubic foot, and those conversions are what turn a nominal size and a board length into a volume. Write the species or the product name, the nominal size and the actual dimension where the drawings give one. Where the project uses engineered products, record them by their designation rather than by a nominal size, and keep steel studs and joists on rows of their own.

Recording stock lengths so a piece count can be converted into an order

A count of 12 members tells a supplier nothing about what to deliver. The register needs the length each member is cut to, and it needs to know whether that length comes off a stock length or is cut on site. Where the framing details give a member length, record it and note the piece count. Where the length comes from a dimension plus an allowance, record the dimension and the allowance separately so a reader can see where the number came from. Where a member is delivered in full length and trimmed on site, say that in the review column, because the order quantity and the installed quantity are then different numbers. Keep a piece count, a length and a linear-foot total in separate columns so that changing one of them does not silently rewrite the others, and recheck the total after any change.

Keeping sheathing area out of the linear-foot total

Sheet goods cover the framing and they are measured in square feet, sometimes in sheets. Both belong on the register, and neither belongs in a linear-foot total. A wall that is 20 ft long with 9 ft of height produces 180 square feet of sheathing coverage, and no length figure describes that. The American Wood Council lists a National Design Specification, a Wood Frame Construction Manual, Special Design Provisions for Wind and Seismic and a range of design aids among the resources its catalogue names, and it publishes span options and connection calculators for wood joists and rafters. Those references set the basis for the framing itself. The takeoff sheet records how much of each product the project consumes, in the unit the product is sold in.

Keeping connectors, fasteners and temporary works as their own rows

Connectors are counted each and priced by type. Hold-downs, hurricane ties, anchor bolts, joist hangers, seismic connectors and blocking connectors each carry a count and a reference back to the detail that requires them. Fasteners are a separate exercise again, because the schedule follows the sheathing nailing requirements and the member schedule rather than the board area. Record the type, the quantity and the reference, and where a detail requires a connector at a spacing, record the spacing with the count rather than a bare number. Keep temporary bracing, permanent bracing and construction aids distinct, because the last of those three is often supplied by the erector and is not a line on the material list. Each of these rows is small, and each is the row that a purchase order most often leaves out.

Reading the members that a plan view cannot show

A plan shows the outline of a wall or a floor, and the members inside that outline live in the framing plan, the section and the detail sheets. Headers over openings, cripples at the ends of openings, posts at beam locations, joists at the edges of a floor, rim members and the pieces that carry a point load all come from documents you have to open. Where a member is continuous across two plan locations, count it once and record the span of the count. Where the elevation or the section shows a member that the plan does not, the section governs, and the row should carry that reference so the reader knows where the piece came from. A framing takeoff read from one sheet is a takeoff of that sheet. Read the set before the count, because the members that arrive late are the ones that were on a sheet nobody opened.

Telling a supplier which member they are pricing

A member list reaches a supplier as a product, a size, a length and a quantity. Species and grade, engineered product designation, treatment, and whether the material is dimension lumber or a truss or a joist all change what the supplier quotes, and the register has to say which one it is. Steel framing sits apart from wood framing for the same reason: ASTM C955 covers cold-formed steel structural framing members with a base steel thickness of not less than 0.0329 in. (0.836 mm) in load-bearing construction assemblies, and ASTM A1003 covers the coated steel sheet used to manufacture cold-formed framing members such as studs, joists, purlins, girts and track. Give the delivery conditions, the site access constraints and the required dates in the request, and state the drawing revision the list was measured from.

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.

Not a measured material list. No spacing, structural design or waste factor is supplied.
DrawingAssemblyMember specificationLength ftCountTotal LFReview note
Example onlyExample wallConfirm from design81296Illustrative values only

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 spreadsheet calculate stud spacing?
No. Use the spacing and the framing requirements given in the approved project design. The worksheet organises reviewed quantities and does not supply structural assumptions, because a spacing assumption applied to every wall on a set produces a member list that cannot be reconciled with the framing plan. Where the drawings give a spacing, record the member count and the reference to the plan that established it, and let the design carry the spacing itself.
Why does the example show 96 linear feet when the framing will also include headers and joists?
Because the example is one row of one assembly, chosen to show how a piece count and a length produce a linear-foot figure. Twelve members at 8 ft is 96 linear feet, and that arithmetic is the whole point of the row. A real framing set adds headers, joists, cripples and rim members as their own rows, because each has a different specification and a different supplier. The example does not claim to describe a framing package.
How should I record a member that is cut on site?
Record the length as specified and note in the review column that the piece is trimmed in the field. Where a member is ordered in a standard stock length and shortened on site, the ordered quantity and the installed quantity are different numbers, and the register has to show which of the two it carries. Where a length comes from a dimension plus an allowance, record the dimension and the allowance in separate places so a reviewer can see the basis.
Can I convert linear feet into board feet?
Only with the nominal size, the actual length and the unit convention the project uses, and it is a different quantity from linear feet. NIST Handbook 44 sets out the US customary relationships for length, area and volume, which is what a conversion needs, and it warns that rounding belongs at the end of a calculation rather than partway through it. Keep the linear-foot total and the board-foot total in separate fields. A supplier pricing linear feet and a supplier pricing board feet are not quoting the same thing.
Do steel studs and joists fit the same worksheet?
The structure fits, because the register already separates assemblies and carries a specification column, but the specification has to name the steel product rather than a nominal lumber size. ASTM C955 covers cold-formed steel structural framing members in load-bearing assemblies and sets a minimum base steel thickness, and ASTM A1003 covers the coated sheet from which studs, joists, purlins, girts and track are made. Gauge, coating and thickness belong on the row, and they decide which fabricator or supplier the row goes to.
How should I handle a floor area where the framing is not drawn?
Leave the rows open and record the area so the gap is visible. A member count generated from floor area and a spacing assumption is a different kind of figure from a counted member, and mixing the two produces a list that cannot be checked against a drawing. If the framing for an area is absent from the set, the responsible project team has to supply it. The register records what the documents show, and a blank row is more useful than a plausible number with no source.
Does the download include a waste factor?
No. The file holds the drawing reference, the assembly, the member specification, the length, the count, the linear-foot total and a review note, and the note under the table says the values are illustrative. There is no default percentage and no structural assumption in it. Where you add an allowance, add it as its own row with the percentage and the reason, so the measured quantities and the purchasing decision stay apart.

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