Quantity Worksheet Window

The quantity worksheet window is used to organize drawings, measurements and annotations. It also lets you perform calculations and easily transfer them to other applications. Use the View Ribbon bar's Quantity Worksheet button to show or hide the Quantity Worksheet Window

The heart of the worksheet window is the Worksheet Tree/Grid Control (see Figure 1 below). This tree part of the control allows you to define a hierarchy of project information (items). The structure of the hierarchy is up to you. The CSI Master Format structure is often used. It has 16 divisions at the top level, with four or five digit codes at the next level. The tree structure lets you open and close branches in the tree, showing more or less detail. When you open a branch, it's "child" or "member" branches become visible. The grid part of the control allows you to display or hide different columns of information.

You can assign measurements and annotations to the item branches in the tree. This can be done by simply dragging them from the drawing, or you can have them assigned automatically. Assigning measurements to items allows you to accumulate measurement quantities and even use them in calculations. The item quantities can then be dragged and dropped to other applications such as Excel.

Assignments can also be used to drill down to specifics in the drawings. If you're looking for information about a concrete slab, you can browse down through the tree until you find it. Then you can double click on the assigned measurements and annotations and jump to a view of the drawing they came from.

Window Layout


Figure 1: The Quantity Worksheet Window

Figure 1 shows the quantity worksheet window. Most of the window is taken up by the worksheet grid. The grid is actually a combination of a grid and a tree. Like a grid, it has columns and rows. But the rows are hierarchical - like a tree control.

Grid Rows

The first row in the grid is the "Project Branch". Below the project branch are the "Item Branches". There can be multiple levels of item branches. Measurements and Annotations can be assigned to item branches. These assignments are shown as children of the item they're assigned to. Figure 1 shows all the different branch types. They can be easily identified by the unique icon for each type.

Grid Columns

At the top of the grid are the column headings. The columns are highly configurable:

The following columns are available:

In some cases you may want to use several different quantities from the same measurement. For example, the area might determine the carpet required while the perimeter determines the base length. In the Trace Edit Window you can define up to three additional quantities to display for a measurement. The columns below let you display information about the additional quantities. For Item and annotation branches, the cells will be empty.

Saving and Re-loading Column Configurations

You will probably want to configure the columns differently for different purposes. For example, you might have one configuration for reviewing information and another for transferring information to Excel or other applications.

When you right-click in the column heading (any column), you will see the menu option "Save Column Configuration...". Select it and the Column Configuration Naming Window will appear.


Figure 2: The Column Configuration Naming Window

You can enter a name for the current configuration. If you wish to replace an existing configuration, you can press the down-arrow button and select from the list. Once you have entered a name, press the "OK" button and the configuration will be saved.

To re-load a saved configuration, right-click in the column heading and select "Load Column Configuration" from the menu. A sub-menu will appear listing the saved column configurations. Select a configuration and the columns will be set to match the configuration.

To delete a column configuration you no longer want, right-click in the column heading and select "Delete Column Configuration" from the menu. A sub-menu will appear listing the saved column configurations. Select a configuration and it will be deleted from the saved configurations

Resizing the Quantity Worksheet Window

You can change the size of the quantity worksheet window by dragging the edges or corners of the window or the Resizing Control in the lower right-hand corner of the window. The grid will expand or contract to adjust to the new window size. Dimension will remember the window size and re-use it as you close and re-open the window.

Command Buttons

Above the grid, at the top of the Quantity Worksheet Window are the command buttons:

Add Branch

Press this button to add a child branch to the branch that currently has focus. For example, to add a top-level branch, put the focus on the Project Branch and press this button. The Item Properties Window will appear. Fill in the item properties and press "OK". The child item branch will be added. (You won't see it unless the parent branch is "open".) This can also be done by selecting "Add a New Item..." from the context menu.
This button will be disabled in the Basic Viewer. It will also be disabled if you have defined a breakdown structure and the current node is at the last level of that structure.

Clone Branch

To add an item branch which is similar to another branch, put the focus on the branch you want to copy and press this button. The Item Properties Window will appear, showing a copy of the focus branch's properties. When cloning an item, you'll see a check box labeled "Clone member items". If you check this box, the new branch will have a copy of all the original branch's member items. Measurement and Annotation assignments are NOT copied. Modify the item properties as desired and press "OK". The "sibling" item branch will be added. This can also be done by selecting "Clone Item..." from the context menu.
This button will be disabled in the Basic Viewer.

Delete Branch

Press this button to delete a branch and all of its descendents. This can also be done by selecting "Delete Item..." from the context menu.
This button will be disabled in the Basic Viewer.

Branch Properties

Press this button to review and/or change the properties of an Item Branch. The Item Properties Window will appear. Modify the item properties as desired and press "OK". This can also be done by selecting "Display/Edit Item Properties..." from the context menu.
This button will be disabled in the Basic Viewer.

Increase Decimal Places

Press this button to increase the number of decimal places in the Quantity column.

Decrease Decimal Places

Press this button to decrease the number of decimal places in the Quantity column.

Show/Hide Comma Separator

Press this button to show or hide the comma separator for numeric values (12345.00 vs 12,345.00).

Print

Press this button to print the quantity worksheet. The Quantity Worksheet Print Window will be displayed, allowing you to select various options before printing.

Copy/Drag Values or Excel Links

This control has three settings that determine what happens when you drag and drop quantities to another application:

  • Copy/Drag Values

    When this option is selected, quantity values will be transferred.

  • Copy/Drag Item Links

    When this option is selected, Excel formulas will be transferred. The cell value will be the quantity of the item you drag or copy. You should only use this when you have installed the Dimension Excel Add-on and are transferring information to an Excel spreadsheet.

  • Copy/Drag Bid Code Links

    When this option is selected, Excel formulas will be transferred. The cell value will be the total quantity of the all worksheet items using the Bid Code of the item you drag or copy. You should only use this when you have installed the Dimension Excel Add-on and are transferring information to an Excel spreadsheet.

For more details see the Dimension Excel Add-on.

Audit Mode

When this box is Checked, the behavior of the quantity worksheet and the Main Window changes to facilitate auditing:

  • As the focus is moved from item to item in the quantity worksheet, the only measurements and annotations displayed in the main windod are those assigned to the item or one of it's sub items.
  • Any numeric input items that are blank are displayed with a highlighted background.
For more information see the Auditing Overview.

Hide Unused

When this box is Checked, unused branches in the tree are hidden. A branch is considered unused when it meets the following conditions:

  • It has no measurements or annotations assigned to it
  • If it uses a formula, the result of that formula is zero
  • Any child branches are also unused

Float Window

Dimension allows you to drag quantity worksheet information to other applications. (See Transferring Information to Other Applications.) This is done by "floating" the quantity worksheet window above the other application. Press this button to start or stop floating the Quantity Worksheet Window.

Recalculate Project

Under normal circumstances, the quantity worksheet is automatically recalculated and measurements are added, changed or deleted. But if your system should fail during one of these processes, the recalculation may not finish. Press this button to recalculate the entire quantity worksheet.

Quantity Worksheet Formula Bar

The Formula Bar in the Quantity Worksheet Window allows you to change the Quantity Calculation and the Quantity Formula for an item without displaying the Item Properties Window.

To edit the formula, place the focus on the desired item, then either press the F2 key or click on the Formula Bar. The formula for the item will be displayed with color coding to indicate references to other items. See Figure 2


Figure 3: The Quantity Worksheet Formula Bar

Note the item references in the formula ("Width" and "Depth") are color coded. The items referenced have an outline of the same color.

When entering a formula, you can enter an item reference by simply clicking on the desired item node. For more information, see Quantity Worksheet Formula Bar.

Creating and Re-using Quantity Worksheets

The first time you open the Quantity Worksheet Window for a new project, the only branch will be the Project Branch. You begin building the quantity worksheet by putting the focus on the project branch, pressing the Add Branch button and filling in the properties. If you have a number of similar branches, you can create one (including its child branches), then use the Clone Branch button to easily create the rest.

This is a lot of work and it may be necessary for the first project. But if many projects use the same or similar quantity worksheets, you can create Quantity Worksheet Templates to re-use quantity worksheets. A quantity worksheet template is a copy of part or all of an quantity worksheet. First, it doesn't include the measurement and annotation assignments. Secondly, the template may include the entire tree, or just one branch and its descendents. The template is saved as a file outside of the Dimension database.

To create a template, right-click on the branch you want in the template. To include the entire tree, right-click on the Project Branch. Select "Save Tree Branch as Template..." from the context menu. A standard Windows File Save Dialog will be displayed. Specify the file to contain the template and press "Save". You've just created an Quantity Worksheet Template.
This capability is not available in the Basic Viewer.

When you're ready to use the template in the quantity worksheet, right-click on any Item Branch and select "Import Template..." from the context menu. A standard Windows File Open Dialog will be displayed. Select the template you want to import and press "Open". The Import Quantity Worksheet Template will be displayed (see Figure 3).


Figure 4: The Import Quantity Worksheet Template Window

When templates are created, they are stored with all of their parent nodes. When they are imported, it often desirable to eliminate some of those parents and/or import them relative to another node.

Figure 4 shows two radio buttons. If you select "Import relative to Project", the original exported parents will be connected to the project node. If you right-clicked on a lower-level node to start import, you can select "Import relative to [node description]". If you select this, the exported parent nodes will be connected to that node.

This often creates a chain of several nodes that aren't needed. Any node that has only one child node can be deleted. Right-click on the node and select "Delete node, move children up".

When you import a template, you can select the individual branches you want to import. This allows you to import branches as needed. After you select a template, Dimension creates and displays an import tree. It compares the template tree to your existing tree and marks any existing items. In Figure 3, items 01, 02 and 03 are already in the tree and display an Item Branch icon. The other branches display a selection check box. Initially all boxes are checked. You can click on a check box to select or deselect the branch and all of its descendents. Or you can open a branch and select some of the descendents. After making the desired selections, press the "Add" button and the selected branches will be added to the project quantity worksheet.
This capability is not available in the Basic Viewer.

Assigning Measurements and Annotations

There are three ways to assign measurements and annotations to items.

To assign by dragging and dropping, first position the quantity worksheet window so that you can see it as well the measurements and annotations you want to assign. On the Ribbon Bar Home Tab or the Ribbon Bar Annotate Tab, click on the Select button. Then click-down on the measurement or annotation you want to assign. Holding the mouse button down, drag the measurement or annotation to the Breakdown Code cell of the Item Branch where you want it assigned. Then release the mouse button. The assignment is done. If the item branch is open, you will see the assignment as a member branch. If the item branch has a trace for its assigned measurements, you will see the measurement's appearance change.
To remove the assignment, focus on the assignment branch and press the Delete Branch button.
Assignment is not available in the Basic Viewer.

Transferring Information to Other Applications

Dimension uses the drag and drop technique to transfer information to other applications such as Excel. You can transfer individual cells, rectangles of cells, entire rows, entire columns or even the entire grid.

First, press the Float Window button . Dimension's main window will disappear and the Quantity Worksheet Window will float above all other windows on your screen. Start or switch to the application that will receive the transferred information. Position the quantity worksheet window so you can see both the information you want to transfer and its destination. The transfer is done by selecting the worksheet window cells, then dragging and dropping them. There are several ways to select cells:

The selected cells will have a light blue background and will be bordered by a blue line. To transfer them, click-down on one of the selected cells. Holding the mouse button down, drag the cells to the desired destination in the other application and release the mouse button.

Context Menu Options

The Context Menu is displayed when you click the right button on the mouse in the Breakdown Code column of the worksheet. It is displayed where the mouse cursor is positioned on the screen. Pressing the right mouse button on a row of the worksheet moves the focus to that row before the context menu is displayed. The context options are then applied to the focus row.

Assignment rows do not have context menus, the Project row and Item rows do. Which menu options are enabled will depend on whether the focus row is the Project row or an Item row. Here are the possibilities:

Shortcut Keys