/
Table Item

Table Item

Owned by Julie Doyle-Whitelock (Deactivated)
Last updated: Feb 17, 2020

Tables are made up of pricing information for standard items that are available for a number of choices. Tables are particularly useful for calculating prices for non-standard selections, based on the quantity and the standard item on which it is based.

A Table Item is structured so that from the Rows Tab, Intersection Items can be launched that reflect the different components of the item.

In this example, a Brick upgrades for House Types are displayed, with one combination selected and launched.

An Intersection Item has the same layout as a Standard Item.

Table Item (Base Prices) Dialog - General Tab

The General tab is used to manage the basic details for a table item, such as row and column headings, and any notes about the table item.

Item Group

Field

Description

Full Reference

Full reference to the table item in the VPB. This field is locked and cannot be edited.

Example: The table item 13.4.1.1 includes the following VPB details:
- 13: Home Technology
- 13.4: Air Conditioners
- 13.4.1: Ducted Systems
- 13.4.1.1: Table Item for Ducted Systems

BOQ Count

Number of BOQ links for the table item.

These are created and maintained in the BOQ Links tab. This field is locked and cannot be edited.

Style

This field/function is currently disabled.

Font style applied to the table item when printed. Click the Style popup button to select.

Table items may be printed on a VPB, a report, or a document.

Example: Normal, Bold, etc.

Suppress?

Will the table item be suppressed on the printed VPB and in the Framework VPB Browserapplication?

  • No (default): The table item will be included in the printed VPB and in theFramework VPB Browser application.
  • Yes: The table item will be excluded from the printed VPB and in the Framework VPB Browser application.

An item would be suppressed if it is unavailable.

Columns

Total number of column headings in the table.

Column headings are created in the Columns tab. This field is locked and cannot be edited.

Row Column Group

Field

Description

Name

Name given to the row column group.

Example: If the table item relates to air conditioners for single storey houses, then the row column group may be called House Type or Single Storey House Type.

Reference

Reference name given to the row column group. Click the Reference copy button to copy the row column group name or manually enter a reference name.

The name entered here appears as the second column heading on the Rows tab

Quantity Column Group

Field

Description

Name

Name given to the quantity column.

Reference

Reference name given to the quantity column.

The name entered here appears as the third column heading on the Rows tab.

Suppress Quantity?

Will the quantity column be suppressed on the printed VPB?

  • No (default): The quantity column will be included in the printed VPB.
  • Yes: The quantity column will be excluded from the printed VPB.

Notes Group

Free text area for notes regarding the table item. Notes entered here help identify table items on the Items list of the Items and Section & Items screens.

Table Item (Base Prices) Dialog - Columns Tab

The Columns tab is used to create a column heading for a table item.

Column headings are visible on the Rows tab.

Important

A maximum of ten (10) column headings can be entered.

Example

If the table item relates to air conditioners for single storey houses, then the column headings may be all of the air conditioners that apply to the house types:
- Acme Active 11.1 kw
- Acme Active 14.5 kw
- Acme Active 16.4 kw
- Acme Active 18.2 kw

Table Columns List

Column

Description

#

Order in which the column heading will appear across the top of Table Rows list on the Rows tab.

To update the number, click the directional buttons in the toolbar.

Ref

Table column reference.

To update the reference, click the directional buttons in the toolbar.

Name

Full name of the table column heading.

Column Ref

Reference name of the table column heading.

Ref.

VPB item reference number.

Procedures

Creating A Table Item Column Heading

  1. Click the New toolbar icon. The Table Column dialog will be displayed.
  2. Enter the details.
  3. Click OK. The dialog will close and a new column heading will be created.

Table Item (Base Prices) Dialog - Rows Tab

The Rows tab is used to create a table row for a table item. Once a row has been created, prices for the intersection item can be modified by double-clicking a cell.

Table Rows List

The column headings available are dependent on the number of columns entered on the Columns tab.

Column

Description

#

Row number.

To update the number, click the directional buttons in the toolbar.

Column Heading: Second

The name of the second column heading is set in the Row Column group of the General tab.

Column Heading: Third

The name of the third column heading is set in the Quantity Column group of the General tab.

Column Heading: Fourth and Above

The names of the fourth and subsequent column headings are set on the Columns tab.

Procedures

Creating A Table Item Row

  1. Click the New toolbar icon. The Table Row dialog will be displayed.
  2. Enter the details.
  3. Click OK. The dialog will close and a new table row will be created.
In Framework ECM 2020
 Expand for further information

Copying A Table Item Row

  1. Highlight the Row you wish to copy.
  2. Click the Copy toolbar icon. A new row will be created at the bottom of the list with (copy) appended to the name.
  3. Edit the row and update as required.

Table Item (Base Prices) Dialog - Validity Tab

The Validity tab is used to manage the availability of a table item for a region/division or house type.

Example

A brick upgrade may not be available for the Metro - North region/division as the supplier used in that particular region/division doesn't handle those brick types.


Region/Division Validity Group

Field

Description

Valid For

Specific region/division validity for the selected table item. Click the This item applies to popup button to select. Standard selections include: 

  • All Region/Divisions: The table item is valid for all region/divisions.
  • All Except the Listed Region/Divisions: The table item is not valid for the listed region/divisions.
  • Only the Listed Region/Divisions: The table item is valid only for the listed region/divisions.

Region/Divisions List

Column

Description

Name

Name of the region/division to which validity will be applied.

Ref

Reference name of the region/division to which validity will be applied.

House Type Validity Group

Field

Description

Valid For

Specific house type validity for the selected table item. Click the This item applies to popup button to select. Standard selections include: 

  • All House Types: The table item is valid for all house types.
  • All Except the Listed House Types: The table item is not valid for the listed house types.
  • Only the Listed House Types: The table item is valid only for the listed house types.

House Types List

Column

Description

House Class

Name of the house class to which validity will be applied.

House Type

Name of the house type to which validity will be applied.


Table Item (Base Prices) Dialog - Image Tab

The Image tab is used to insert a full size image against the table item.

Image

Displays the image recorded against the table item.

Images are stored in the Framework ECM database. Moving or removing the image from the location on the network will not affect Framework ECM.

Table Item (Base Prices) Dialog - BOQ Links Tab

Important

BOQ links are ONLY required if information is integrated between Framework ECM and an external estimating system.

The BOQ Links tab is used to manage the Bill Of Quantities (BOQ) links for a table item.

A BOQ is also known in the housing industry as:
- Assembly
- Recipe
- Mini-bill
- Model

A BOQ is a document used in estimating in which costs for materials, parts, and labour are itemised to create the total cost for an item. Entering a BOQ link allows the exchange of information between Framework ECM and an external estimating system.

Example: A single wall oven may be connected to a BOQ that contains:

  • Required materials (in this case, the wall oven itself, gas piping, etc.)
  • Labour
  • Delivery

Multiple BOQ links can be created so that a single item can be tied to multiple BOQs.

Example: A house may be connected to multiple BOQs such as:

  • Bathroom BOQ
  • Garage BOQ
  • Kitchen BOQ, etc.


The details in this list can be edited using the BOQ Link dialog.

Column

Description

#

Order of the BOQ link in the BOQ Links list. BOQ links may be moved to a different position in the list by using the directional buttons in the toolbar.

Indicates the primary BOQ link. The primary BOQ link is indicated with a  icon.

QTY

BOQ link quantity.

Qty Method

Selected quantity method for BOQ links.

BOQ Reference

BOQ reference item in an estimating system for the table item.

Export

Export method for the BOQ link from Framework ECM to an external estimating system.

Pricing

Sales pricing import method for the BOQ link from an external estimating system to Framework ECM.

Notes

Free text area for notes regarding the BOQ link.

Procedures

  1. Click the New toolbar button. The BOQ Link dialog will be displayed.
  2. Enter the details.
  3. Click OK. The dialog will close and a new BOQ link will be created.

Tip

Multiple BOQ links can be created.