FreeCAD Spreadsheet Parameters by Hand vs Claude AI: Change One Number
▶ 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
.FCStdfile. No Excel needed. FreeCAD can import an Excel.xlsxfile, 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)
-
File, Open: lesson 2’s hook.
-
Workbench list: Spreadsheet. Click New Spreadsheet (the first button).
-
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_depth25 mm ·thickness5 mm ·lip_height10 mm ·plate_height60 mm ·width20 mm -
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:Size Expression the bottom 25 Spreadsheet.hook_depththe lip’s 10 Spreadsheet.lip_heightthe lip’s width 5 Spreadsheet.thicknessthe drop inside the lip 5 Spreadsheet.lip_height - Spreadsheet.thicknessthe back plate’s 60 Spreadsheet.plate_heightthe back plate’s 5 Spreadsheet.thicknessStill Fully constrained. Close.
-
Double-click Pad, in Length type
=thenSpreadsheet.width, OK. -
Windows, Tile. Change
hook_depthto 40 mm, thenthicknessto 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
Paramswith 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.999999999998in the console: a rounding speck, 8,500.
The course
- Previous: Lesson 2: Sketcher and Pad
- Next: Lesson 4: holes and fillets
- The lab for this lesson: freecad-course-lab/out/l3
- The same idea in SolidCraft: SolidCraft course, lesson 3
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.