Arch Schedule/ru: Difference between revisions

From FreeCAD Documentation
(Created page with "{{GuiCommand/ru |Name=Arch Schedule |Name=Arch Schedule |Workbenches=Arch |MenuLocation=Архитектура → Create schedule... |Shortcut= }}")
 
(Updating to match new version of source page)
(23 intermediate revisions by 5 users not shown)
Line 1: Line 1:
⚫
<languages/>

{{Docnav
|[[Arch_MultiMaterial|MultiMaterial]]
|[[Arch_CompPipe|CompPipe]]
|[[Arch_Workbench|Arch]]
|IconL=Arch_MultiMaterial.svg
|IconR=Arch_CompPipe.png
|IconC=Workbench_Arch.svg
}}

<div class="mw-translate-fuzzy">
{{GuiCommand/ru
{{GuiCommand/ru
|Name=Arch Schedule
|Name=Arch Schedule
|Name=Arch Schedule
|Name/ru=Arch Schedule
⚫
|Workbenches=[[Arch Module/ru|Arch]]
|MenuLocation=Архитектура → Create schedule...
|MenuLocation=Архитектура → Create schedule...
⚫
|Workbenches=[[Arch_Workbench/ru|Arch]]
|Shortcut=
|Shortcut=
}}
}}
</div>



==Description==
==Description==


The Schedule tool allows you to create and automatically populate a [[Spreadsheet Module|spreadsheet]] with contents gathered from the model.
The Schedule tool allows you to create and automatically populate a [[Spreadsheet_Workbench|spreadsheet]] with contents gathered from the model.


{{Emphasis|Note}}: This tool has been rewritten in FreeCAD 0.17 and differs from previous versions.
[[Image:Arch quantities 01.jpg|800px]]


For a more general solution, see the [https://github.com/furti/FreeCAD-Reporting/tree/master Reporting Workbench] in the list of [[External_workbenches|external workbenches]]. This workbench uses SQL syntax to extract information from the document.
==How to use==


==Usage==
⚫
# Open or create a FreeCAD document with some [[Arch Module|Arch]] objects
⚫
# Press the {{KEY|[[Image:Arch Schedule.png|16px]] [[Arch Schedule|Schedule]]}} button
⚫
# Adjust the desired options
⚫
# Press '''OK'''


⚫
# Open or create a FreeCAD document which contains some objects.
== Options==
⚫
# Press the {{Button|[[Image:Arch_Schedule.svg|16px]] [[Arch_Schedule|Schedule]]}} button.
⚫
# Adjust the desired options.
⚫
# Press {{Button|OK}}.


==Workflow==
[[Image:Arch quantities 02.jpg]]


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.
* '''Schedule type''': Allows to choose between a quantities schedule, a spaces schedule and a doors and windows schedule. Curently only the quantities schedule is implemented.
* '''Start cell''': The location in the spreadsheet where the schedule should start
* '''Area unit''': The unit in which to express areas
* '''Volume unit''': The unit in which to express volumes
* '''Currency unit''': The unit in which to express prices, if the '''Add price calculation''' option is enabled. No currency conversion is performed, so you must ensure that the prices specified in the materials of your model use the same unit.
* '''Only show totals''': Doesn't create an individual line for each object


[[Image:Arch_schedule_example01.jpg]]
{{clear}}

⚫
<languages/>
Then you press the {{Button|[[Image:Arch_Schedule.svg|16px]] [[Arch_Schedule|Arch Schedule]]}} button. You get a task panel like this. It is pretty wide, so you'll need to widen the task panel to be comfortable.

[[Image:Arch_schedule_example02.jpg]]

Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the {{Button|Add}} button to add a new line, and double-click each cell from that line to fill in the values. The {{Button|Del}} button will delete the line which contains a currently selected cell, and {{Button|Clear}} 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 {{incode|count}} or an object property:
** If you enter {{incode|count}} (or {{incode|Count}} or {{incode|COUNT}}, 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: {{incode|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 {{incode|object.Shape.Volume}} is the same as entering {{incode|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 {{incode|m^3}}. 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|Selection}} button to add objects currently selected in the document.
* '''Filter''': Here you can add a semicolon{{incode|;}}-separated list of filters. Each filter is written in the form: {{incode|property:value}}. You can only use properties that hold a string value. Both the property and the value are case-insensitive. The {{incode|value}} can be left out but not the {{incode|:}}. To properly handle schedules created with previous versions of Arch Schedule the {{incode|type}} property will be translated to the {{incode|ifctype}} property. It is advisable to not use {{incode|type}} in new schedules.
: For example:
:: {{incode|label:floor1;ifctype:window}} will retain only objects that have "floor1" in their {{PropertyData|Label}} and "window" in their {{PropertyData|IFC Type}}. A window with the {{PropertyData|Label}} "Floor1-AA" and the {{PropertyData|IFC Type}} "Window Standard Case" will be included.
:: {{incode|label:door}} Will retain only objects that have "door" in their {{PropertyData|Label}}.
:: {{incode|!label:door}} Will retain only objects that do not have "door" in their {{PropertyData|Label}}.
:: {{incode|ifctype:structural}} Will retain only objects that have "structural" in their {{PropertyData|IFC Type}}.
:: {{incode|!ifctype:something}} Will retain only objects that do not have "structural" in their {{PropertyData|IFC Type}} or that do not have the {{PropertyData|IFC Type}} property.
:: {{incode|!ifctype:}} Will retain only objects that do not have the {{PropertyData|IFC Type}} property.

The {{Button|Import}} 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:

[[Image:Arch_schedule_example03.jpg]]

After that, press {{Button|OK}} and a new Schedule object is added to the document, which contains a result spreadsheet:

[[Image:Arch_schedule_example04.jpg]]

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):

[[Image:Arch_schedule_example05.jpg]]

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 [[Property_editor#Actions|Dynamic properties]]. If they have been added with the {{MenuCommand|Prefix group name}} option selected, their names will indeed start with the group name, but this prefix is not displayed in the [[Property_editor|Property editor]]. Their names have this form: {{incode|NameOfGroup_NameOfProperty}}. To reference them in a schedule this full name must be used.


{{Docnav
|[[Arch_MultiMaterial|MultiMaterial]]
|[[Arch_CompPipe|CompPipe]]
|[[Arch_Workbench|Arch]]
|IconL=Arch_MultiMaterial.svg
|IconR=Arch_CompPipe.png
|IconC=Workbench_Arch.svg
}}

{{Arch Tools navi{{#translation:}}}}
{{Userdocnavi{{#translation:}}}}

Revision as of 09:19, 17 April 2022

Other languages:

Arch Schedule

Системное название
Arch Schedule
Расположение в меню
Архитектура → Create schedule...
Верстаки
Arch
Быстрые клавиши
Нет
Представлено в версии
-
См. также
Нет

Description

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

Note: This tool has been rewritten in FreeCAD 0.17 and differs from previous versions.

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.
  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.

Then you press the Arch Schedule button. You get a task panel like this. It is pretty wide, so you'll need to widen the task panel to be comfortable.

Then you can fill line by line. Each line is a "query" and will render one line in the spreadsheet. Press the Add button to add a new line, and double-click each cell from that line to fill in the values. The Del button will delete the line which contains a currently selected cell, and Clear 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 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 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: 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. 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 Selection 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: 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.
For example:
label:floor1;ifctype:window will retain only objects that have "floor1" in their ДанныеLabel and "window" in their ДанныеIFC Type. A window with the ДанныеLabel "Floor1-AA" and the ДанныеIFC Type "Window Standard Case" will be included.
label:door Will retain only objects that have "door" in their ДанныеLabel.
!label:door Will retain only objects that do not have "door" in their ДанныеLabel.
ifctype:structural Will retain only objects that have "structural" in their ДанныеIFC Type.
!ifctype:something Will retain only objects that do not have "structural" in their ДанныеIFC Type or that do not have the ДанныеIFC Type property.
!ifctype: Will retain only objects that do not have the ДанныеIFC Type property.

The Import 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 OK 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):

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.


Arch
Документация пользователя
Retrieved from "http://wiki.freecad.org/index.php?title=Arch_Schedule/ru&oldid=1129806"