FreeCAD Spreadsheet Parameters by Hand vs Claude AI: Change One Number

November 3, 2026 · FreeCAD + Claude Course (part 3)

▶ Watch on YouTube & subscribe to The Stack Underflow

If every size in a sketch is a typed number, changing the part means retyping each one. FreeCAD’s built-in Spreadsheet lets you give sizes names (aliases) and write the sketch’s sizes from them as expressions. Then one cell changes the whole part. The name also settles what a word like “thickness” means.

The one-line version: five names in a spreadsheet, every size written from them, then change one cell and check the volume.

Last verified in our lab: 30 October 2026 (FreeCAD 1.1.4; freecad-mcp 0.1.28; Claude Code 2.1.308 with Claude Sonnet 5.5; Linux in Docker). Setup is lesson 1; the hook comes from lesson 2 (build it there and save it first).

The words first

  • Spreadsheet: part of FreeCAD, saved inside your .FCStd file. No Excel needed. FreeCAD can import an Excel .xlsx file, but that is a one-time copy, not a live link; this lesson doesn’t use Excel.
  • Alias: a cell’s name, like thickness, used instead of its address.
  • Expression: a size written as a formula, like Spreadsheet.lip_height - Spreadsheet.thickness.

By hand (FreeCAD 1.1.4)

  1. File, Open: lesson 2’s hook.

  2. Workbench list: Spreadsheet. Click New Spreadsheet (the first button).

  3. Rows 1 to 5: a label in column A, the value with mm in column B, then click the B cell, type its name in the Alias box at the top, Enter: hook_depth 25 mm · thickness 5 mm · lip_height 10 mm · plate_height 60 mm · width 20 mm

  4. Back to the hook’s tab, double-click the sketch. Double-click each size, type = (the Expression Editor opens), type the expression, Enter (pick from the list), Enter, Enter:

    SizeExpression
    the bottom 25Spreadsheet.hook_depth
    the lip’s 10Spreadsheet.lip_height
    the lip’s width 5Spreadsheet.thickness
    the drop inside the lip 5Spreadsheet.lip_height - Spreadsheet.thickness
    the back plate’s 60Spreadsheet.plate_height
    the back plate’s 5Spreadsheet.thickness

    Still Fully constrained. Close.

  5. Double-click Pad, in Length type = then Spreadsheet.width, OK.

  6. Windows, Tile. Change hook_depth to 40 mm, then thickness to 8 mm.

Check it yourself

Python console (View, Panels), click the Pad:

Gui.Selection.getSelection()[0].Shape.Volume
b = Gui.Selection.getSelection()[0].Shape.BoundBox; round(b.XMin, 3), round(b.XMax, 3)

You should get 8500.0 at the start, 10000.0 and (0.0, 40.0) at 40 deep, and 15040.0 at 8 thick. The hook stays fully constrained throughout.

On lesson 2’s plain hook (no names), typing 40 over the 25 directly also gives 10,000, because the arm’s top has no size of its own.

Then with Claude

A fresh window each run. The “asked” runs (B1, B2) started with:

Use named sizes in a spreadsheet: plate_height 60, width 20, thickness 5, hook_depth 25, lip_height 10, and write every length and the extrude distance from them.

followed by lesson 2’s message. The “not asked” run (A1) got lesson 2’s message only. Then, in every run: “Make the hook 40 deep instead of 25.” and “Make it 8 thick instead of 5.” The scoring was written down before the first run.

  • B1 (asked): its first call failed on an old property name; the corrected program made a spreadsheet named Params with the five names and wrote all seven lengths and the pad from them. 8,500; each change one cell (10,000; 15,040).
  • B2 (asked): two failed calls and a check, then the same result, one cell per change.
  • A1 (not asked): no names; it redrew every corner for each change. At 8 thick it made the plate and arm 8 but kept the lip 5 wide and raised it to 13 mm high: 15,220 mm³ instead of 15,040. The name decided what “thickness” means.
  • Replays with no AI: B1’s and A1’s logged calls in a fresh FreeCAD gave the same numbers.
  • Claude’s saved file prints 8499.999999999998 in the console: a rounding speck, 8,500.

The course

Sources

  • The lab: the pre-written scoring, scripts, logs and replays behind every number here

Change notes

  • 16 Nov 2026: first published, from the lesson’s lab results of 30 Oct 2026.

Not affiliated with or endorsed by the FreeCAD project, the freecad-mcp project or Anthropic. Found a mistake? Tell us in the video’s comments and we’ll correct this page.

Found this useful? The deep version lives on YouTube — new breakdowns of how AI dev tools actually work, weekly.

Subscribe on YouTube →

Prefer email? Get the free newsletter: one failure, traced step by step, about once a week.