Arch Schedule/de

Beschreibung
Das Ablaufplan Werkzeug ermöglicht dir ein Tabellenblatt zu erstellen und automatisch mit Inhalten aus dem Modell aufzufüllen.


 * Dieses Werkzeug wurde in FreeCAD 0.17 neu geschrieben und unterscheidet sich von früheren Versionen.

Für eine allgemeinere Lösung, siehe die Auswertung Arbeitsbereich in der Liste der Externe Arbeitsbereiche. Dieser Arbeitsbereich verwendet die SQL Syntax, um Informationen aus dem Dokument zu extrahieren.

Anwendung

 * 1) Öffne oder erstelle ein FreeCAD Dokument, das einige Objekte enthält.
 * 2) Drücke die  Schaltfläche.
 * 3) Stelle die gewünschten Optionen ein.
 * 4) Drücken.

Arbeitsablauf
Zuerst musst du ein Modell haben. Hier ist zum Beispiel ein Dokument mit ein paar Objekten. Ich habe hier Arch Sachen gemacht, aber es muss nicht Arch sein, es kann alles sein.



Dann drücke die Schaltfläche. Du bekommst ein Aufgaben Paneel wie dieses. Es ist ziemlich breit, so dass du das Aufgabenfenster verbreitern musst, um komfortabler zu sein.



Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the button to add a new line, and double-click each cell from that line to fill in the values. The button will delete the line which contains a currently selected cell, and  will delete all the lines. 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 line will be skipped and left blank in the spreadsheet. This allows you to add "separator" lines.
 * Value: 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 or an object property:
 * If you enter (or  or, it's case-insensitive) the selected objects will simply be counted.
 * If you enter an object property the value of this property for each of the selected objects will be retrieved and summed up. Objects that do not have the property will be skipped. Use dot notation to retrieve properties of properties: . 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 is the same as entering.
 * If you have added dynamic properties to objects and want to retrieve their values you need to know that their names have this syntax, where is the name of the group the property appears in in the Property editor.


 * 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 . If you use a wrong unit, for ex. cm, 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 (not labels). 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 button to add objects currently selected in the document.
 * Filter: Here you can add a semicolon-separated list of filters. Each filter is written in the form: . You can only use properties that hold a string value. Both the property and the value are case-insensitive. The can be left out but not the . Note that the  property will be translated to the  property.
 * For example:
 * will retain only objects that have "floor1" in their and "window" in their . A window with the  "Floor1-AA" and the  "Window Standard Case" will be included.
 * Will retain only objects that have "door" in their.
 * Will retain only objects that do not have "door" in their.
 * Will retain only objects that have "structural" in their.
 * Will retain only objects that do not have "structural" in their or that do not have the  property.
 * Will retain only objects that do not have the property.

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

So we can build a list of queries like this:



After that, press and a new Schedule object is added to the document, which contains a result spreadsheet:



By double-clicking the Schedule object, you get back to the task panel and change the values. By double-clicking the spreadsheet itself, you get the results in 3 columns: description, value, unit (if applicable):



Die Kalkulationstabelle kann dann ganz normal von der Arbeitsbereich Tabellenkalkulations aus nach csv exportiert werden.