Deck & Fence Materials Planner (Excel & Google Sheets)

One spreadsheet for building a deck, a fence, or both. Enter the sizes and get deck boards, joists, screws and stain, fence posts, panels or pickets and rails, and the concrete for every post hole, with a budget and a shopping list.

What’s inside

• Deck: up to 5 decks or levels: rows of boards, boards to buy for your board length, joists and screws.
• Stain: stain or oil for each deck, including steps and railings, in gallons or litres.
• Fence: up to 5 fences with gates: sections, posts, panels, rails and pickets.
• Post holes: concrete per hole and bags to buy, for 40–80 lb or 20–30 kg bags.
• Budget, Expenses and Shopping List: 12 categories, planned against actual, and one list for everything.

How the numbers work: the same formulas as the free deck board, deck stain, fence and post hole concrete calculators on yardstickly.com. Concrete bag yields come from Quikrete’s data sheet; every other default is listed with its source inside the file.

Format: one .xlsx file for Excel, Google Sheets or LibreOffice Calc.

Good to know: it’s a materials planner, not a structural design. Check span tables, footing sizes and permit rules with your local building authority.