Spreadsheet · digital download

Deck & Fence Materials Planner

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, an expense log and a shopping list for the timber yard.

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 and tins.
• Fence: up to 5 fences with gates and several runs: 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 quantities use the same formulas as our free deck board, deck stain, fence and post hole concrete calculators. Concrete bag yields come from Quikrete’s data sheet, and the other defaults (joist spacing, stain coverage, hole size) are listed with their sources inside the file.

Good to know

• Format: One .xlsx file. Works with Microsoft Excel, Google Sheets and LibreOffice Calc.
• Units: feet and inches or metres and millimetres, and any currency.
• Limits: It’s a materials planner, not a structural design. Check span tables, footing sizes and permit rules with your local building authority.
• Refunds: If the file doesn't work for you, email hello@yardstickly.com within 14 days for a full refund.
• Questions? Contact us.

Quantities are estimates for planning. Check product labels and local building rules before you buy or build.