Summary | How to write a Quantity Tablefill out the Quantity Table (Quantity Calculation Summary Table)? | ||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Related Function | Base Mode > Application >Construction> Quantity Table > Quantity Table (Template) / Quantity Table (Generate) /Quantity Table (Export) | ||||||||||||||||
Type |
|
Q. How
...
can I create
...
the Quantity Table (Quantity Calculation Summary Table)?
A.
...
The Quantity Table can be created in
...
the construction mode in under Construction of the Application tab.
Using the function related to Quantity Table, you can create (output in Excel form) a quantitative calculation table in Excel formThe user can generate the Quantity Calculation Summary Table in an Excel format (Output as an Excel format).
Application > Construction > Construction mode
...
Figure. 1 Enter Construction Mode
...
| Tip |
|---|
|
| Info |
|---|
Go to Construction Mode to create a quantity calculation aggregate table. |
...
Construction mode > Quantity Table > Template
...
Figure. 3 Work Type - Quantity table template dialog User environment configuration
| Info |
|---|
Quantity calculation content setting
① If you click Template, a dialog box for field classification is created. ② Change the Template Name. ➡ Example of expanation) it was changed to Quantity Aggregation Table . ③ Quantity Calculation Select the number of work types/standards set. Up to three can be set, and it is okay to set only one. ➡ Example of explanation) Enter 3 EA by entering the field items related to reinforcing bars into 3 classification systems . ④ Customize and input the classification items in the quantity aggregate table that is linked to Excel. ⑤ Enter the field composition contents and unit system such as material and tag items required for quantity calculation. ⑥ Apply and Close to close the dialog box. |
...
Construction mode > Quantity Table > Generate
...
Figure. 4 Specify the Quantity Table calculation range
| Info |
|---|
Quantity calculation range setting ① Go to the Quantity Calculation Range Setting tab. ② Picture. 3 Select the Quantitative Calculation Classification (Template list) defined in . ③ You can designate a range for the entire structure shown on the screen, or select a quantity calculation range according to the structure structure. ➡ Example of Explanation) the Structure configuration system was selected. ④ I selected the 1.1.2 lower hole checkbox to check the quantity below the lower hole ➡ You can check the quantity calculation statement by checking the level composition system unit. ⑤ Click Apply and Close to close the dialog box. |
...
Construction mode > Quantity Table > Export To Excel
...
Figure. 5 Quantity Table Export
| Info |
|---|
Quantity calculation table calculation ① Enter the Export To Excel step. ② Picture. Select the quantity calculation taxonomy defined in 3 and 4 (Template list). ③ Click Export To Excel to save the file path and name. ④ Click Apply and Close to close the dialog box. |
...
Quantity calculation confirmation
...
Figure. 6 Check the Quantity Table
| Info |
|---|
Quantity calculation confirmation ▶ Find the path where Excel is saved and open it. ▷ The sheet composition in Excel is calculated as in the list of structure structures configured when entering a quantity system. ▶ Quantity and related contents are calculated according to the field composition system entered in Work Type. ▷ You can check the contents of the quantity calculation statement in the structure in which the contents of the lower quantity are aggregated at the upper level. |
...