Cabinet cut list in Excel or in a tool
What a cabinet cut list spreadsheet has to contain, how one wrong setting such as 3/4 versus 23/32 spreads through the parts, and when Excel is the better choice.
A spreadsheet can produce a cabinet cut list if you build every rule into it, and for one fixed cabinet design it is a fair choice. The cost is that you write and check every formula, and one wrong setting spreads through every part that depends on it. A tool carries the rules for you; a spreadsheet gives you control of them.
As a real case: enter 3/4 inch instead of 23/32 for the panel thickness and 4 of the 15 part lines on a 24 inch face frame base change size. The bottom alone goes from 22 9/16 to 22 1/2 long.
Every rule you would have to build
The product's rule set covers carcass, face frame, doors, drawer boxes, banding and layout, with 82 named settings behind it. A spreadsheet that does the same job needs each of these as a formula, plus a place for every setting. Rule IDs are the ones the tool prints on the cut list.
| Rule | What it gives | Formula in short |
|---|---|---|
| C-1 | Box width | W_box = W - 2 x ff_over (face frame), else W |
| C-2, C-3, C-4 | Kick, side height, box height | kick = kick_h (0 on wall); H_side = H or H - kick; H_box = H - kick |
| C-5, C-6 | Side depth, sides | D_side = D - T_ff (if included) - T_back (if applied); qty 2 x H_side |
| C-7 | Interior width | W_in = W_box - 2 x T |
| C-8, C-9, C-10 | Horizontal length and depth, bottom | L_h = W_in + 2j; D_h = D_side - T_back (rabbet) |
| C-11 | Top or stretchers | full top L_h x D_h, or two stretchers L_h x W_str |
| C-12 | Back | applied W_box x H_box; rabbet (W_in + 2 x d_rab) x H_box |
| C-13, C-14, C-15 | Hanging rail, shelf, fixed shelf | shelf (W_in - shelf_gap) x (D_h - shelf_setback) |
| C-16 | Toe kick | notch or legs: W_box x kick_h; separate base: rails plus n_x = max(2, ceil(W_box / 24) + 1) cross members |
| F-1 to F-4 | Frame, stiles, rails | L_rail = W_ff - 2 x S_ff + 2t; stiles S_ff x H_ff |
| F-5, F-6, F-7 | Openings, centre stile | W_op = W_ff - 2 x S_ff; H_avail = H_ff - R_top - R_bot - (n - 1) x R_mid |
| F-8 | Slide blocking | B = S_ff - ff_over - T; error if negative |
| D-1 to D-4 | Overlay doors and drawer fronts | opening + 2 x O; pair (W_op + 2O - G_pair) / 2; error if 2 x O is at least R_mid |
| D-5 to D-7 | Inset doors | opening - 2 x G_in; pair (W_op - 3 x G_in) / 2 |
| D-8 to D-11 | Frameless fronts | W_fz = W - 2 x rev_side; stack sum + (n - 1) x gap_v = H_fz; pair (W_fz - gap_pair) / 2 |
| D-12 to D-14 | Five-piece parts | rail W_door - 2 x S_d + 2 x g_d; panel less 2 x e_d |
| B-1 to B-4 | Box opening, width, height | side-mount W_dop - 2 x c_side; undermount W_dop - um_deduct + 2 x T_ds; H_bx = H_dop - c_top - c_bot |
| B-5 to B-8 | Slide, length, sides, bottom | longest slide at most D_clear - c_rear; bottom (W_bx - 2 x T_ds + 2 x d_bg) x (L_bx - 2 x T_ds + 2 x d_bg) |
| ER-1, ER-2, ER-3 | Banding, cut size, length | edge flags; cut = finished - T_eb x edges; total = sum x (1 + eb_waste) |
| L-1 to L-7 | Sheet layout | usable sheet, kerf inflation, grain, packing method, honesty line |
Each of those depends on settings that change between jobs: panel thickness, back method, joint, frame widths, overlay, slide type. The first design step in a spreadsheet is deciding where those live, so a formula never contains a typed number. The second is making every cabinet type use the same cells. See how to build a base cabinet box for the carcass rules worked through.
Where errors creep in: one setting, many parts
Most cut list mistakes are not formula mistakes. They are a wrong input that every formula then trusts. Plywood sold as 3/4 inch measures about 23/32, and the interior width, every horizontal length and the back all use it. Here is the same 24 inch face frame base with the panel thickness entered as 3/4 instead.
| Part | Rule | With 23/32 | With 3/4 | Difference |
|---|---|---|---|---|
| Bottom | C-8, C-9, C-10 | 22 9/16 x 23 | 22 1/2 x 23 | 1/16 / - |
| Stretcher | C-11 | 22 9/16 x 4 | 22 1/2 x 4 | 1/16 / - |
| Back, 1/4 | C-12 | 23 5/16 x 30 | 23 1/4 x 30 | 1/16 / - |
| Shelf | C-14 | 22 7/16 x 22 3/4 | 22 3/8 x 22 3/4 | 1/16 / - |
Each dimension moves by 1/16, which is small enough to miss on the bench and large enough to make a shelf bind or a bottom gap. In a spreadsheet the same entry does the same thing, silently. The tool also raises a hint when you enter 3/4 inch, so the entry is questioned. In a spreadsheet you add that check yourself. On the whole six-cabinet run the total sheet count is 8 with 23/32 and 9 with 3/4, so the same slip also reaches the plywood order, not only the fit.
Other places the same thing happens: a rounding rule (the engine does all its arithmetic in whole units of 1/8128 inch and rounds down on divisions so no part is oversize), a copied row that points at the old cell, a frame width changed in one tab and not another, and a pair of doors computed as half the door width without the gap.
The step a spreadsheet does not do for you
Sizing parts is arithmetic. Placing them on sheets is a packing problem. The product places each part with a guillotine method, tries eight combinations of sort order and split rule, and keeps the one with the fewest sheets. It is a heuristic and the product says so. A spreadsheet can total area, but a layout needs that packing logic or a separate program. The sample kitchen run below is 5 sheets of 23/32 plywood in the main group. See sheet layout and saw kerf for how to read it and how many sheets a kitchen needs for the counts.
When a spreadsheet is the better choice
- One cabinet design you build over and over. If every box is the same, a sheet with your own numbers fits you exactly and costs nothing to run.
- Construction the tool has no setting for. A spreadsheet takes any formula you can write.
- You already trust a sheet you built. Moving costs setup time, and a checked sheet is worth keeping.
- You want everything in Excel. CabinetCRUNCHER is Excel-based cut list and estimating software for face frame and frameless cabinets, with costing in its Professional series, according to its own site. Sheet optimisation is not stated on the page we read. If you want a spreadsheet you did not have to write, that is one place to look.
A tool is the better choice when you build many different cabinets, change settings between jobs, need a sheet layout, or want the rule ID and formula printed beside each part so you can check the shop's own method against it.
Common mistakes
- Typing 3/4 where the sheet measures 23/32, or the reverse. Measure the sheet.
- Typing a number into a formula instead of referencing a setting, so it is not updated when the setting changes.
- Rounding each part for display and then using the rounded value in the next formula.
- Leaving out the pair gap or the overlay limit, which makes door sizes look right and cannot be built.
- Not testing the sheet against a cabinet you have built.
To try the same cabinet in the tool, open it with the defaults. The cabinet calculator gives one cabinet's list free.
Questions people ask
Can I make a cabinet cut list in Excel?
Yes. You need a formula for each part of each cabinet type and a cell for every setting, such as panel thickness, joint and overlay. The rule table above lists them by ID. Sheet layout is the step that needs more than formulas.
What goes wrong most often in a cut list spreadsheet?
A wrong input that every formula trusts. Entering 3/4 inch for a 23/32 inch sheet moves the interior width and every horizontal part, as the table above shows. A formula copied with a stale cell reference does the same.
When is a spreadsheet better than a cut list tool?
When you build one or two fixed designs, when your construction is not covered by the tool settings, or when you already have a sheet you have checked against built cabinets. A spreadsheet lets you write any rule.
Is CabinetCRUNCHER a spreadsheet?
Its own site describes it as Excel-based professional cabinet cut list and estimating software, covering face frame and frameless cabinets. We have not tested it, so see its site for what it includes.
Does the tool tell me which formula made each size?
Yes. Each part lists its rule ID and a formula with your numbers substituted, so you can check a size by hand or compare it against a spreadsheet you already have.
Sources
- CabinetCRUNCHER Read .