Spreadsheets in the Shop
You don't need fancy software to run a woodworking operation. A well-built worksheet is what keeps you from buying 12 board feet of walnut when your bill of materials only calls for 8. I used to run my shop on scratch paper and hope. That changed after I cut a batch of table legs and realized I'd ordered roughly half the stock I actually needed, then waited three days for an overnight delivery at a markup. The fix wasn't a new tool. It was a spreadsheet. Start with a single sheet that tracks every project from the moment you sketch it. The columns I actually use are project name, piece designation, material type, rough length, rough width, finished thickness, board footage, quantity, waste percentage, source, unit cost, and total cost. Some people build these with conditional formatting and dropdowns right away. I suggest against that. A simple sheet with basic numbers is easier to maintain. You can add features later when you figure out which fields actually matter to you. The hardest part is usually the waste calculation. Woodworkers tend to think in whole boards, but you buy by board foot and cut to dimensions. If you need four pieces at 24 inches long by 5 inches wide from hardwood, a 1-board-foot piece won't get you there. A standard 4/4 walnut board is roughly 1 inch thick, and the actual usable length depends on how many defects you work around. I once put a chair project in my spreadsheet and calculated 18 board feet. I bought 18 board feet. I still ran short on the stretchers because I hadn't accounted for cross-grain cuts and bow correction. The workaround was to stop using flat waste percentages and start calculating each piece individually against real lumber dimensions. Instead of a blanket 20 percent waste number, I note the actual board length I'm committing each piece to, then subtract any offcuts I can realistically reuse. That method took longer to set up but reduced my material overage from about 25 percent down to somewhere between 8 and 12 percent on most projects.
Building the Core Sheet
The layout matters less than consistency. A messy sheet you actually use will outperform a perfectly formatted one you abandon after two weeks. Here is the structure I stick to now. Create a Projects tab. Each row is one project. Include a project ID, date started, and current status so you can sort by what is still open. This helps when five projects are sitting on the same bench and you need to know which one has an urgent deadline. Create a separate Materials tab. This is where the actual calculations live. Every cut list item gets its own row. The piece designation column should match whatever naming convention you use in the shop. If you call them Table_Top_Breadboard_Left and Table_Top_Breadboard_Right, put that in the sheet. If you call them BT-Left and BT-Right, do that instead. The sheet only works if you actually reference it when you are at the lumber rack.
For the board footage formula, multiply rough thickness in eighths by width in inches by length in inches, then divide by 144. That gives you the raw board footage before any jointing or planing. Then add your yield factor based on the species and grain condition. Quarter-sawn white oak usually needs more waste than flat-sawn poplar because of checking and runout. I track yield factors by species and grade, not by project. Once you have a year of data, the numbers settle into something useful. The cost columns are where most people make things more complicated than they need to be. You do not need to track every nail or bit. Focus on the material that actually moves money. Lumber, plywood, and hardware. Glue and finish are cheap enough that minor overestimates do not hurt. Hardware is annoying to track per-project because you often buy in bulk. I put hardware costs on a monthly multiplier instead. Whatever I spend on hinges, pulls, and fasteners that month gets divided by the number of projects I ship that month, then allocated evenly. It is not perfect, but it is close enough and it saves me an hour of spreadsheet time I would rather spend sanding.
Get the Full Details
What Most People Miss
The biggest mistake I see is building worksheets for finished dimensions instead of rough dimensions. You cut to finished size, yes, but you buy rough. If your cut list says 3/4 by 5-1/2 by 24, that is your finished size. Your rough size is probably 13/16 by 5-3/4 by 25. The difference looks small until you are ordering from a supplier who sells in whole board feet and your total drops through the floor because you undercounted by three board feet on a ten-project batch. Another issue is treating board footage and piece count as interchangeable. They are not. A single 8/4 cherry board might give you all the blanks for a small cabinet, but it could also sit unused for six months if the grain pattern does not work. I learned this the hard way on a credenza project. I bought one beautiful 8/4 cherry board for the face frames and main panels. The grain was gorgeous. I cut my joinery. Then I discovered the board had a hidden shake running through the center third. I lost roughly 14 inches of usable length across the entire board. My worksheet had assumed full yield. I ended up buying a second board for 90 dollars just to finish the project. After that, I added a defect notation column for every board I buy. It takes ten seconds to fill in and it prevents that exact scenario.
A Practical Example
Say you are building a simple live-edge shelf. The span is 48 inches. You need one shelf board at roughly 10 inches wide by 1 inch thick after planing. Your worksheet row would list Live_Edge_Shelf as the piece, White_Oak as the species, 4/4 as the rough thickness, 11 inches rough width to allow for edge cleanup, 50 inches rough length to account for the live edge and any trim, and a yield factor of 0.85 since live-edge stock always has more waste. The formula spits out about 3.4 board feet. You then look up what 4/4 white oak costs at your local supplier, maybe 8 to 12 dollars a board foot depending on grade. You multiply and add the defect notation if the board you pick has a knot near one end. That single row now tells you exactly what to budget and what to expect at the counter. For plywood projects, the math shifts. Plywood is sold by the sheet, not by board foot. I keep a separate line item for sheet goods. You cut a sheet to your listed dimensions, so the waste is mostly edge trim and failed cuts. A standard 4 by 8 sheet gives you a predictable yield on most cabinet boxes. I calculate yield based on how many full sheets a project requires, then add a half-sheet buffer for mistakes. That buffer covers roughly 80 percent of errors without inflating every order unnecessarily.
Downsides You Should Know About
Spreadsheet tracking does not scale well if you run a production shop with dozens of small orders per week. The overhead of maintaining individual rows for every bracket and screw becomes a full-time job. In that scenario, a quick rough estimate using historical averages per project type works better. The same applies if you primarily work in softwoods for construction framing. The margins are thin enough that detailed tracking rarely changes purchasing decisions. Another problem is data rot. If you build a system and then stop updating it for three months, the numbers become useless. I had a spreadsheet full of outdated lumber prices that made me underquote a batch of dovetail boxes by about 18 percent. The species prices had shifted, and I had not refreshed the tab in over a year. Set a reminder to update your price list quarterly at minimum. Price changes happen every spring and again before the holiday rush. If you find spreadsheets too rigid, a simple notebook with a consistent grid works. Some woodworkers prefer tracking on index cards pinned to a board. I have tried both. The spreadsheet wins for cost calculation because the formulas catch errors you will never notice by hand. The notebook wins for quick sketch-to-number workflows when you are at the lumber yard and do not want to open a laptop. Use whichever tool you will actually reach for without hesitation.
Final Notes on Maintenance
Keep one master file. Clone it for each new project rather than starting from scratch. Copy-pasting a working template saves maybe ten minutes but forces you to rebuild the column structure every time, which is where shortcuts creep in. Before you know it, you are missing a yield column on three projects and wondering why your numbers do not match your receipts. Add a Lessons column to each project when you finish it. Not a long essay. One line about what you underestimated, what you overestimated, and whether the supplier delivered grade as promised. Those lines compound faster than you expect. Six months into that habit, you will look back and realize you already know which species to trust and which ones consistently arrive warped. That knowledge is worth more than any fancy automation.
