FreeCAD 1.0 Easy Parametric Modeling: Spreadsheets & VarSets

In this course, you'll learn how to use three powerful features in FreeCAD to control and supply data for your models: the expression engine, spreadsheets, and variable sets. We'll explore how the expression engine allows you to define parameters using math, functions, and logic for dynamic modeling. Spreadsheets will help you manage data like dimensions and properties in a table format, while variable sets offer a lightweight way to store data in name-value pairs. This course focuses on these core features, with a hands-on approach to data-driven parametric modeling. Perfect for beginners looking to get started with parametric design in FreeCAD!

In this tutorial, we’ll walk through how to use spreadsheets in FreeCAD to control model parameters. We’ll create a simple rectangle with adjustable length, width, and thickness, and link these values to the model using a spreadsheet. You’ll learn how to create and edit spreadsheets, set constraints, and use the expression editor to link spreadsheet cells to your 3D model. We’ll also cover how to use aliases for easier reference to cells. As you make changes in the spreadsheet, your model will automatically update, allowing for a flexible and data-driven design workflow.

In this section of the course, we’ll explore how to use variable sets (VarSets) to control model parameters in FreeCAD. You’ll learn how to create and manage VarSets, which store data in name-value pairs. We’ll work with common model properties like length, width, and thickness, and demonstrate how to connect these properties to your 3D model using the expression editor. Unlike spreadsheets, VarSets are lightweight and keep data strongly typed, ensuring accurate values throughout your model. By the end of this lesson, you’ll have a working setup where changing the values in your VarSet will automatically update your model in real time!

In this lesson, you’ll learn how to create and manage a configuration table within your spreadsheet model to control parameters like length, width, and thickness. Starting with a basic model, you’ll add a new column for configuration labels (e.g., Small, Medium, Large), define alias values, and link them to the model using a configuration table. You’ll also explore how to use dropdown menus to switch between different design setups, see real-time model updates, add new configurations like "Extra Large," and remove or modify the table when needed. This approach streamlines parametric design by making your model flexible, reusable, and easy to update.

In this lesson, we explore dependency cycles in FreeCAD—an important issue to understand when using spreadsheets to drive model parameters. You'll see how referencing values between a sketch and a spreadsheet can create circular dependencies that lead to errors and slow performance. The lesson demonstrates how to identify these cycles and resolve them by either restructuring your data flow or using a Variable Set (VarSet) to separate input values from derived references. By the end, you'll know how to safely manage data relationships and avoid unintended feedback loops in your models.

This lesson compares two powerful parameter management tools in FreeCAD: spreadsheets and variable sets (VarSets). You'll learn the strengths and trade-offs of each. Spreadsheets offer a flexible, familiar interface ideal for bulk data entry and sharing across files, while variable sets are more structured, efficient, and better suited for managing large numbers of parameters within a single part. The lesson also covers best practices for naming, customization, referencing parameters, and using configuration tables to create dynamic model options like small, medium, and large presets.

This project involves designing customizable toy bricks with adjustable lengths, widths, and heights. Each brick has a standard size of 8 mm by 8 mm, with a height of either 9.6 mm (high brick) or 3.2 mm (low profile). A 0.2 mm gap is required between bricks, so each side of the brick is reduced by 0.1 mm to ensure proper fitting. The design will be developed alongside a spreadsheet, allowing for easy parameter adjustments and more complex features like conditional parameters to suppress features when working producing a smaller sized brick.. By the end, you'll gain foundational skills applicable to future projects.

In this project, we’ll create a parametric box driven by a variable set. We’ll use the expression editor to calculate elements like hinge occurrences, allowing the box to grow and automatically increase the number of hinges needed. The data will be simplified with a variable set containing height, length, width, and a base value (base length), with the base length set as read-only to prevent accidental changes. During the project, you’ll encounter and resolve an error when scaling the box to a larger size, learning the reasons behind it. By the end, you'll have a box that can scale to any size.

When you're working on a design project, especially one involving customizable or complex data, adding documentation isn't just helpful, it's essential. Months down the line, you may not remember why certain decisions were made, and if someone else takes over your work, they'll need a clear understanding of the structure and logic behind it.

In this lesson, we'll explore how even simple notes and labels can make a big difference. You'll learn how to add meaningful context to your projects, from documenting calculated fields (like model thickness) to implementing smart error warnings that guide users when incorrect values are entered.

By the end of this video, you'll know how to build projects that are easier to maintain, easier to share, and less likely to break due to guesswork or misinterpretation.

In this project, you'll learn how to create geometry that dynamically adapts to the size of other elements, specifically, custom signs whose height and width are automatically determined by the physical length of the text.

We'll explore how to use a bounding box, a rectangular perimeter that surrounds a shape, to calculate the required dimensions. You'll also work with a configuration table, allowing you to generate multiple variations of a sign from a convenient drop-down menu within the body container.

To take things further, we'll introduce variant links in FreeCAD, a powerful feature that lets you reuse parts without duplicating geometry. These links reference the original object but allow changes to key properties like position, color, or content defined in the configuration table.

By the end of this project, you’ll be able to:

• Dynamically size objects based on input data

• Use bounding boxes for automated geometry scaling

• Create reusable design variants with customized properties

• Incorporate multiple visually distinct variants which can be exported.

This approach not only saves time but also improves flexibility and scalability in your design workflow.