Summary
Macros are a very useful tool in Databuild's estimating armory. They are in essence collections of estimating actions you would normally undertake combined into one single macro. When this macro is run, all the actions are performed in the order they appear.
Details
Macros are accessed from the toolbar button in the following modules
Front End Update
Macros can call other macros, so the whole estimating process can be simplified and codified: by running a series of macros and sub-macros you can ensure that all operations have been undertaken in the correct order.
Macros can do nothing that you can't do long hand, but they can do those actions quickly and automatically. When done manually, some of the macro actions such as repricing allow various options to be selected. To keep the macro processing automatically, the macro uses the default or last used options.
Macros perform their operation on the current job in the module they were called from. However, if called from Global Quantities, the actions will be performed on all selected jobs
The Macro screen consists of 2 panels, each with command buttons at their base:
The left panel holds a grid of all Macros, and 3 command buttons:
Add a new Macro
Make a copy of the current Macro. Often macros are similar, and it is easier to copy & modify
Deletes the current or selected macro(s)
The right panel holds a grid of all lines in the current Macro, and 5 command buttons:
Add a new Macro Line
Selects or DeSelects all macro lines
Make a copy of the selected Macro lines.
Pastes copied macro lines
Deletes the current or selected macro line(s)
|
Action |
Value 1 |
Value 2 |
Other Values |
0 |
Add Item |
Item Code |
Cost Centre |
Value3=Quantity Value4=Price Level Value5=Load Workup=Workup
|
1 |
Replace Item |
Old Item Code |
New Item Code |
Value3=CC if only that Value4= factor for quantities |
2 |
Replace CC |
Old CC Code
|
New CC Code
|
|
3 |
Delete Item |
Item Code |
CC if only that CC
|
|
4 |
Delete CC |
Cost Centre |
|
|
5 |
Delete Bill |
|
|
|
6 |
Run Macro |
Macro Name |
|
|
7 |
Copy Quantity |
Source Job No |
CC if only that CC |
Source Database (if not Job database) |
8 |
Copy Budgets |
Source Job No |
CC if only that CC |
Source Database (if not Job database) |
9 |
Copy Order Profile |
Source Job No |
CC if only that CC |
Source Database (if not Job database)
|
10 |
Explode recipes |
|
|
|
11 |
Sort Bill |
|
|
|
12 |
Round |
|
|
|
13 |
Combine CC |
|
|
|
14 |
Clear Zero Items
|
|
|
|
15 |
Reprice
|
|
|
|
16 |
Set Text Variable
|
Variable Name |
Text |
|
17 |
Set Job Variable
|
Variable Name |
Number |
|
18 |
Print Summary
|
|
|
|
19 |
Print Bill |
|
|
|
20 |
Export Graphical Take Off |
|
|
|
21 |
Rebuild Missing Templates |
|
|
|
22 |
Rebuild ALL Templates |
|
|
|
23 |
Generate Quantities |
Cost Centre |
|
|
Toolbar
Save Changes
Previews Report
Process Current or selected Macro
Closes the routine