Arch Schedule

Materials

Preflight

BIM

Description

The Arch Schedule tool allows you to create and automatically populate a spreadsheet with contents gathered from the model.

For a more general solution, see the Reporting Workbench in the list of external workbenches. This workbench uses SQL syntax to extract information from the document.

Usage

1. Open or create a FreeCAD document which contains some objects.
2. Press the Schedule button.
3. Adjust the desired options. Enable the Associate spreadsheet option if you want the schedule to generate a FreeCAD spreadsheet. Or, alternatively, right-click the schedule in the Tree view after creation, and select Attach spreadsheet from the context menu.
4. Press OK.

Workflow

First you need to have a model. For example, here is a document with a couple of Arch objects, but other objects are also supported.

When you press the Schedule button this dialog opens:

You can now fill the schedule row by row. Each row is a "query" and will render one row in the spreadsheet. Press the Add row button to add a new row, and double-click each cell from that row to fill in the values. The Del row button will delete the row which contains a currently selected cell, and Clear will delete all rows. Possible values to put in columns are:

• Description: A description for this query. The Description column will be the first column of the resulting spreadsheet. The description is mandatory to have a query performed. If you leave the description cell empty, the whole row will be skipped and left blank in the spreadsheet. This allows you to add "separator" rows.
• Property: This is the real query that you want to perform on all the objects selected by the query. It can be two things: either the word count or an object property:
  • If you enter count (or Count or COUNT, it's case-insensitive) the selected objects will simply be counted.
  • If you enter an object property the value of this property will be retrieved for each of the selected objects and summed up. Objects that do not have the given property will be skipped. Generally a property name will be that shown in the Property editor, without spaces (e.g. type PerimeterLength in the Property column if the object has a Perimeter Length in the Property editor). Use the dot notation to retrieve properties of properties: PropertyOfObject.PropertyOfProperty1.PropertyOfProperty2. If the property before the first dot starts with a lowercase letter it will be considered a reference to the object itself and be ignored. Entering for example object.Shape.Volume is the same as entering Shape.Volume.
• Unit: An optional unit to express the results in. It's up to you to give a unit that matches the query you are doing, for example, if you are retrieving volumes, you should use a volume unit, such as m^3 or m³. If you use a wrong unit for the property, e.g. cm for volume, you'll get wrong results.
• Objects: You can leave this empty, then all the objects of the document will be considered by this query, or give a semicolon;-separated list of object names. If any of the objects in this list is a group, its children will be selected as well. So the easiest way to use this feature is to group your objects meaningfully in the document, and just give a group name here. You can also use the Add selection button to add objects currently selected in the document. You must use internal names here. To select objects by their label, leave this column empty and use the Filter column instead.
• Filter: Here you can add a semicolon;-separated list of filters. Each filter is written in the form: property:value. You can only use properties that hold a string value. Both the property and the value are case-insensitive. The value can be left out but not the :. To properly handle schedules created with previous versions of Arch Schedule the type property will be translated to the ifctype property. It is advisable to not use type in new schedules.

The Import button allows you to build this list in another spreadsheet application, and import that as a csv file here.

The finished schedule may look like this:

Finally, press OK and a new schedule is added to the document. If the related option has been selected, the schedule will contain an associate spreadsheet:

To edit an existing schedule double-click it in the Tree view. By double-clicking the spreadsheet, you get the results in 3 columns: Description, Value, Unit (if applicable):

The spreadsheet can then be exported to csv normally, from the Spreadsheet Workbench.

Dynamic properties

It is possible to add your own properties to objects. These are called Dynamic properties. If they have been added with the Prefix group name option selected, their names will indeed start with the group name, but this prefix is not displayed in the Property editor. Their names have this form: NameOfGroup_NameOfProperty. To reference them in a schedule this full name must be used.

Materials

Preflight

BIM

BIM

• 2D drafting: Sketch, Line, Polyline, Circle, Arc, Arc by 3 points, Fillet, Ellipse, Polygon, Rectangle, B-spline, Bézier curve, Cubic Bézier curve, Point

---

• 3D/BIM: Project, Site, Building, Level, Space, Wall, Curtain Wall, Column, Beam, Slab, Door, Window, Pipe, Pipe Connector, Stairs, Roof, Panel, Frame, Fence, Truss, Equipment
  • Reinforcement tools: Custom Rebar, Straight Rebar, U-Shape Rebar, L-Shape Rebar, Stirrup, Bent-Shape Rebar, Helical Rebar, Column Reinforcement, Beam Reinforcement, Slab Reinforcement, Footing Reinforcement
  • Generic 3D tools: Profile, Box, Shape builder..., Facebinder, Objects library, Component, External reference

---

• Annotation: Text, Shape from text, Aligned dimension, Horizontal dimension, Vertical dimension, Leader, Label, Axis, Axes System, Grid, Section Plane, Hatch, Page, View, Shape-based view

---

• Snapping: Snap lock, Snap endpoint, Snap midpoint, Snap center, Snap angle, Snap intersection, Snap perpendicular, Snap extension, Snap parallel, Snap special, Snap near, Snap ortho, Snap grid, Snap working plane, Snap dimensions, Toggle grid, Working Plane Top, Working Plane Front, Working Plane Side

---

• Modify: Move, Copy, Rotate, Clone, Create simple copy, Make compound, Offset, 2D Offset..., Trimex, Join, Split, Scale, Stretch, Draft to sketch, Upgrade, Downgrade, Add component, Remove component, Array, Path array, Polar array, Point array, Cut with plane, Mirror, Extrude..., Difference, Union, Intersection

---

• Manage: BIM Setup..., Views manager, Manage project..., Manage doors and windows..., Manage IFC elements..., Manage IFC quantities..., Manage IFC properties..., Manage classification..., Manage layers..., Material, Schedule, Preflight checks..., Annotation styles...

---

• Utils: Toggle bottom panels, Move to Trash, Working Plane View, Select group, Set slope, Create working plane proxy, Add to construction group, Split Mesh, Mesh to Shape, Select non-manifold meshes, Remove Shape from Arch, Close Holes, Merge Walls, Check, Toggle IFC Brep flag, Toggle subcomponents, Survey, IFC Diff, IFC explorer, Create IFC spreadsheet..., Image plane, Unclone, Rewire, Glue, Reextrude
  • Panel tools: Panel, Panel Cut, Panel Sheet, Nest
  • Structure tools: Structure, Structural System, Multiple Structures
  • IFC tools: IFC Diff..., IFC Expand, Make IFC project, IfcOpenShell update
  • Nudge: Nudge Switch, Nudge Up, Nudge Down, Nudge Left, Nudge Right, Nudge Rotate Left, Nudge Rotate Right, Nudge Extend, Nudge Shrink

---

• Additional: Preferences, Fine tuning, Import Export Preferences, IFC, DAE, OBJ, JSON, 3DS, SHP

User documentation

• Getting started
• Installation: Download, Windows, Linux, Mac, Additional components, Docker, AppImage, Ubuntu Snap
• Basics: About FreeCAD, Interface, Mouse navigation, Selection methods, Object name, Preferences, Workbenches, Document structure, Properties, Help FreeCAD, Donate

---

• Help: Tutorials, Video tutorials
• Workbenches: Std Base, Assembly, BIM, CAM, Draft, FEM, Inspection, Material, Mesh, OpenSCAD, Part, PartDesign, Points, Reverse Engineering, Robot, Sketcher, Spreadsheet, Surface, TechDraw, Test Framework

---

• Addons: Addon Manager, External workbenches, Scripting and macros

---

• Hubs: User hub, Power users hub, Developer hub