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 tablethe Quantity Calculation Summary Table. |
...
Construction mode > Quantity Table
...
Figure. 2 Construction Mode Quantity Setting Tool
| Info |
|---|
Figure to create a quantity calculation aggregate table. Set in the order of 2 numbersFor the Quantity Calculation Summary Table, Figure 2 above shows the process in steps. ① Template : Defines Define the format of the quantity calculation report. You can set the work type, standard, and unit for each materialQuantity Calculation form format. The construction types by material, specifications and units can be set. ② Generate : Select the quantity calculation target and template for the quantity calculation. (All / User Defined / By Structure) ③ Export : Export the quantity calculation aggregate table and link it Quantity Calculation Summary Table to link with Excel. |
...
Construction mode > Quantity Table > Template
...
Figure. 3 Configure the User Environment for the Dialog Box in the Work Type - Quantity table template dialog User environment configurationtemplate
| Info |
|---|
Quantity calculation content setting painting. In 3, enter the Field ItemEnter the details of the quantity calculation
① If you click Template, Click on the Template to create a dialog box for field Field classification is created. ② Change the Template Name. ➡ Example of expanation) it was changed to Quantity Aggregation Table In the example above, the name is set to ‘Quantity Summary Table’. ③ Quantity Calculation Select the quantity calculation type/number of work types/standards setspecification settings. Up to three 3 can be set, and it is okay to set only onesetting just 1 is also acceptable. ➡ Example of explanation) Enter 3 EA by entering the field items related to reinforcing bars into 3 classification systems In the example above, the Number of Fields is set to 3. ④ Customize and input enter the classification items in of the quantity aggregate table that is are linked to Excel. ⑤ Enter the field composition contents Field content and unit system such as material Material and tag Tag items required for the quantity calculation. ⑥ Apply and Close to close exit the dialog box. |
...
Construction mode > Quantity Table > Generate
...
Figure. 4 Specify Set the Calculation Scope for the Quantity Table calculation range
| Info |
|---|
Quantity calculation range settingSet the scope for the quantity calculation ① Go to the Quantity Calculation Range Setting Scope tab. ② Picture. 3 Select the Quantitative Calculation Classification quantity calculation summary table (Template listList) defined as shown in Figure. 3. ③ You The user can designate specify a range for the entire structure as shown on the screen, or select a quantity calculation range according to based on the structure structureconfiguration. ➡ Example of Explanation) the Structure configuration system was In the example above, the By Structure is selected. ④ I selected the To check the quantity below the substructure construction, 1.1.2 lower hole checkbox to check the quantity below the lower hole ➡ You substructure box is checked. ➡ The user can check the quantity calculation statement sheet by checking the level composition system unit. ⑤ Click Apply and Close to close exit the dialog box. |
...
Construction mode > Quantity Table > Export To Excel
...
...
Figure. 5 Export the Quantity Table (Quantity Calculation Summary Table Export)
| Info |
|---|
Quantity calculation table calculationExport the Quantity Calculation Summary Table ① Enter the Export ‘Export To Excel stepExcel’. ② Picture. ② Select the quantity calculation taxonomy defined in summary table (Template List) as shown in Figure 3 and 4 (Template list). ③ Click Export ‘Export To Excel to save Excel’ to select the directory path, set the file path name and namesave. ④ Click Apply and Close to close exit the dialog box. |
Quantity calculation confirmation
...
...
Check the Quantity Calculation Summary Table
...
Figure 6. Check the Quantity Table (Quantity Calculation Summary Table)
| Info |
|---|
Quantity calculation confirmationCheck the Quantity Calculation Summary Table ▶ Find Locate the path where Excel is saved file and open it. ▷ The sheet composition worksheet configuration in Excel is calculated as in the list of structure structures configured when entering a similar to the Structure configuration table when entering the quantity system. ▶ Quantity and its related contents information are calculated according to the field composition Field configuration system entered in the Work Type. ▷ You The user can check the contents of the quantity calculation statement in sheet with the structure in which where the contents of the lower quantity composition are aggregated at added to the upper higher level. |