Framing Lumber Estimator

Purpose and model boundary

This calculator estimates the wall framing to buy for a floor plan you draw: the studs, the plate sticks, the wall sheathing sheets and the nails, with a header for every window and door. You draw the outline, the interior walls, the windows and the doors, set one wall height for the plan and each opening's height, and the spreadsheet returns the counts. It frames the walls only: it does not frame floors, ceilings or roofs, and it does not price anything or estimate labour.

Inputs and units

The drawing is the first input. The drawing tool finds the rooms and writes one row per room (its ID, floor area and enclosing-wall length), one row per wall side of every room, and one row per window and per door with its width and the room it belongs to. A wall between two rooms is listed once for each room, and a free-standing partition once for each face. The outline is also sent as its corner points, and up to five islands or columns inside the floor as exclusions. Each exclusion can carry a height, set by double-clicking it on the drawing (blank is full height); it is carried for the drawing and its 3D view only, and no figure reads it, since an island or column is not framed whatever its height.

The heights are set on the drawing or in the tables under it: one wall height for the whole plan, floor to the top of the top plates, set with the drawing's Wall height button; each door's height; and each window's height and sill height. Lengths and heights are in feet under US and metres under Metric. The spreadsheet takes a wall height from 6 to 20 ft (1.80 to 6.00 m); on the page the drawing accepts the heights valid in both unit systems, 6 to about 19.68 ft (1.83 to 6.00 m), so a unit switch never leaves the wall out of range; in the same way it asks for a window at least 1 ft (0.3048 m) and a door at least 5 ft (1.524 m) tall in both systems, so in Metric it refuses a 0.30 m window or a 1.50 m door that the spreadsheet alone would take. The wall height is one physical height and converts exactly on a switch (8 ft is 2.4384 m). Each unit system keeps its own opening heights; a new opening, and after a switch or when a worked example loads an opening with no height in the current system, gets the drawing's default heights: a door 6 ft 8 in or 2.03 m, no higher than the wall, and a window 4 ft or 1.20 m on a 3 ft or 0.90 m sill, the sill lowered as needed so the window fits below the wall. The 3D view shows the same inputs and computes nothing. After Calculate it also draws the framing this spreadsheet counted, each stud, plate and header as a line, and computes no figure.

The inputs beside the drawing are:

• Stud spacing: on center, 16 in under US and 60 cm under Metric by default.
• Stud length: the studs you buy, 8 ft or 2.4 m. It is checked against the wall height less the plates and does not change the count.
• Wall junctions: how many junctions the interior walls make. Count once each point where an interior wall ends on a straight run of the outline, and each point where interior walls meet (a T, an L or a crossing, once each). Do not count the outline's corners or a wall's free end. The drawing's tables do not list junctions, so they are entered.
• Stud waste: extra studs for culls and miscuts, 10% by default, applied once to the stud total.
• Plates: how many plates run along each wall, 3 by default (a bottom plate and a double top plate).
• Plate stock length: 16 ft or 4.8 m.
• Sheathing sheet area: 32 sq ft (a 4 by 8 ft sheet) or 2.88 m².

The US and Metric defaults are separate figures from the worked examples, not conversions of each other; replace them with your own before you rely on the result.

Governing relationships

The outline's perimeter is measured from its points, closing side included. A point is an outline corner unless the outline goes straight on through it, within the drawing tool's own tolerance of 0.00001 in, so a break point on a straight wall is not a corner. The interior walls are counted once each: every interior wall is listed once for each room it divides, so the interior run is half of what the wall rows add beyond the outline.

Wall run = outline perimeter + interior run

Field studs are counted on the wall run outside the windows and doors, so none falls in an opening; each opening is framed by its kings, jacks, cripples and header instead:

Field studs = (wall run − the windows' and doors' widths) ÷ stud spacing, rounded up

Corner studs = 3 × outline corners, and junction studs = 2 × wall junctions

King and jack studs = 4 × (windows + doors): a king and a jack each side of every opening

Cripples are laid in a course where there is room: above an opening whose top is below the wall, and below a window whose sill is above the floor. Each course has one cripple per stud space across the opening, plus one:

Cripples in a course = opening width ÷ stud spacing, rounded up, + 1

Studs = (field + corner + junction + king and jack + cripple studs) × (1 + waste), rounded up

Plate sticks = wall run × plates ÷ plate stock length, rounded up, with no waste

Sheathed area = outline perimeter × wall height − each window of at least 16 sq ft (1.5 m²)

Sheathing sheets = sheathed area ÷ sheet area, rounded up

Nails = wall run × 0.1 lb per foot (0.149 kg per metre), rounded up

Each header's size comes from a header table on the spreadsheet's Data sheet: a span up to 4 ft (1.2 m) takes a double 2x6, up to 6 ft (1.8 m) a double 2x8, and longer a double 2x10. Its length is the span plus 3 in (8 cm) of bearing. The stud length the walls need is the wall height less the plates, each 1-1/2 in (38 mm) thick.

Calculation sequence

1. The spreadsheet measures the outline's perimeter and counts its corners from the points, then adds the interior run.
2. It counts the field studs along the wall run outside the openings, the corner and junction studs, a king and a jack each side of every opening, and the cripples above and below the openings, adds the waste once and rounds up. Every division is rounded to six decimals before it is rounded up, so a figure that is whole on paper stays whole.
3. It counts the plate sticks, the sheathing sheets and the nails, and sizes each header.

The default plan works through as follows: one 20 by 15 ft room with 8 ft walls and no openings has a 70 ft wall run and 4 outline corners. At 16 in on center, 70 ÷ 1.333 = 52.5 → 53 field studs; the corners take 12, so 65 studs before waste and 65 × 1.1 = 71.5 → 72 to buy. The plates take 70 × 3 ÷ 16 = 13.125 → 14 sticks; the walls take 70 × 8 = 560 sq ft of sheathing, 560 ÷ 32 = 17.5 → 18 sheets; and the nails 70 × 0.1 = 7 lb.

Outputs and interpretation

• Studs, plate sticks and sheathing sheets to buy, and the nails in pounds or kilograms.
• How the studs are counted: field, corner, junction, king and jack, and cripple studs, before waste, and the outline corners.
• The outline, interior and total wall run, and the sheathed wall area.
• The floor's net area, gross area and the area of each island or column, from the drawing.
• Each opening: one row per window, then per door, with its span, its header size, the header length, its kings and jacks, and its cripples above and below.
• By room: each room's wall faces, windows, doors, kings and jacks, and cripples. Field, corner and junction studs are counted for the whole plan, because a shared wall is framed once.

Validation and status logic

The status reads OK, CHECK with what to look at, or NOT VALID with what to fix. While it is NOT VALID every quantity reads zero and the Each opening and By room rows are blank; the drawn areas still show. CHECK shows every figure. The first problem found is reported, in this order:

1. NOT VALID: choose US or Metric
2. NOT VALID: draw at least three outline points
3. NOT VALID: every outline point needs both coordinates
4. NOT VALID: every point of exclusion 1 needs both coordinates
5. NOT VALID: every point of exclusion 2 needs both coordinates
6. NOT VALID: every point of exclusion 3 needs both coordinates
7. NOT VALID: every point of exclusion 4 needs both coordinates
8. NOT VALID: every point of exclusion 5 needs both coordinates
9. NOT VALID: each exclusion needs zero or at least three complete points
10. NOT VALID: outline and exclusion points must fill consecutive rows, with no blank row between them
11. NOT VALID: the floor outline encloses no area
12. NOT VALID: the exclusions leave no floor area
13. NOT VALID: room, wall, window and door rows must be complete, with lengths above zero and no negative area, and fill consecutive rows with no blank row between them
14. NOT VALID: the room areas do not add up to the floor area drawn
15. NOT VALID: every room must be listed once, and every wall, window and door must belong to a listed room
16. NOT VALID: the walls listed do not go all the way round every room and the outline drawn
17. NOT VALID: wall, window and door IDs must each be listed once, and no ID or room ID may contain *, ? or ~ or begin with <, > or =
18. NOT VALID: the wall height must be from 6 to 20 ft (US) or from 1.80 to 6.00 m (Metric)
19. NOT VALID: every window needs a height of at least 1 ft (US) or 0.30 m (Metric)
20. NOT VALID: every window needs a sill height of zero or more
21. NOT VALID: every door needs a height of at least 5 ft (US) or 1.50 m (Metric)
22. NOT VALID: a window or door reaches above the wall height
23. NOT VALID: an exclusion height must be greater than zero; leave it blank for full height
24. NOT VALID: an exclusion height is given for an exclusion that is not drawn
25. NOT VALID: a window or door is longer than the longest wall of its room, or the openings in a room are wider than its walls
26. NOT VALID: stud spacing must be greater than zero
27. NOT VALID: stud length must be greater than zero
28. NOT VALID: plates must be a whole number of at least one
29. NOT VALID: plate stock length must be greater than zero
30. NOT VALID: sheathing sheet area must be greater than zero
31. NOT VALID: enter a stud waste between 0% and 100%
32. NOT VALID: wall junctions must be a whole number of zero or more
33. CHECK: the studs are shorter than the walls need: the wall height less the plates is longer than the stud length entered
34. CHECK: the wall junctions entered do not fit the walls drawn: count once each point where an interior wall ends on a straight run of the outline and each point where interior walls meet, but not the outline's corners or a wall's free end

The height limits are the drawing tool's own: the spreadsheet holds a direct caller to the drawing tool's range for each unit system (items 18 to 22), and the page narrows the wall and the openings to the ranges valid in both systems. The junction check fires when interior walls are drawn and no junction is entered, when junctions are entered with no interior wall, or when the junctions entered need more wall rows than the drawing wrote. An interior wall that runs from one outline corner to another, or stands free at both ends, has no junction to count and still reads CHECK with 0 junctions; its figures are right. The wall lengths and the door and window widths are the drawing tool's rows; the spreadsheet re-measures only the outline from its points and checks the rows against it.

Assumptions and limitations

• Exclusions (islands and columns) are not framed.
• Field studs are counted for the whole plan and not split by room.
• Stud size and wall thickness are not modelled, and window sill plates are not counted.
• The header sizes are an estimating rule, not a span table; size headers from the span tables of the code that applies (for example the International Residential Code's header tables) or from an engineer. A header's size does not check the space above its opening, and an opening reaching the top plate leaves none. The header table is edited on the spreadsheet's Data sheet only.
• Corner and junction studs follow a common 3-stud corner and 2-stud junction rule, not every detail a code allows (two-stud corners, ladder blocking, framing anchors). Kings and jacks are counted as one each side, while a code's header table can require more jack studs on long spans.
• The sheathing takes off windows of at least 16 sq ft (1.5 m²) and no doors, because the tables cannot tell an exterior door from an interior one, so it can overstate by the exterior doors' area.
• The nail rate, 0.1 lb per foot of wall, is an estimating allowance, not a manufacturer's figure.
• One wall height applies to the whole plan; per-room heights are not used.
• Nothing is saved between visits. Export keeps the drawing but not the heights, and the room areas and enclosing lengths come from the drawing tool's room detection.

Restrictions and non-computing states

The spreadsheet computes nothing while the status is NOT VALID: every quantity reads zero and the Each opening and By room rows are blank. Edits on the page stay local until Calculate is pressed.

Errors and warnings

Each NOT VALID line above names the input to fix, and each CHECK line names what to look at. A height outside the drawing's limits, a blank opening height or a blank sill on a window that has a height is refused, because the opening must still fit the wall.

Sources and further reading

• International Code Council, 2021 International Residential Code, Chapter 6, Wall Construction, as adopted in the 2022 Connecticut State Building Code, on UpCodes. up.codes. Section R602.3: studs and plates of not less than 2 in nominal thickness. Section R602.3.2: the double top plate, behind the default of three plates (a bottom plate and two top plates). Table R602.3(5): the stud spacings. Section R602.7 and Table R602.7.5: headers over openings, with jack studs and full-height studs at each end, the kings and jacks this calculator counts. The code's header tables, not this calculator's estimating rule, size a header.
• National Institute of Standards and Technology, American Softwood Lumber Standard, Voluntary Product Standard PS 20-20 (Revision 1, October 2021), Table 3, "Nominal and minimum-dressed sizes of boards, dimension, and timbers". nist.gov. A nominal 2 in board is dressed to 1-1/2 in (38 mm) dry: the plate thickness behind the stud-length check.
• Eric W. Weisstein, "Polygon Area," MathWorld, Wolfram Research. mathworld.wolfram.com. The shoelace formula behind the gross, exclusion and net areas.

The stud spacing, stud length, plates, plate stock, sheet area and waste defaults are the worked examples' figures, and the framing counts, header table, sheathing threshold and nail rate are an estimating rule implied by those examples, not a code requirement. The height defaults and limits are the drawing tool's. These sources describe the code text, the lumber sizes and the geometry; they certify no particular result.