Structure of the workbook - Intergraph Smart Construction - 2019 (7.0) - Help - Hexagon PPM

Intergraph Smart Construction Help (2019)

Language
English
Product
Intergraph Smart Construction
Search by Category
Help
Smart Construction Version
2019(7.0)
SmartPlant Foundation / SDx Version
10

The workbook contains five tabs, Contractors, Contracts, CWPs, Drawings, and Resources. Each tab defines different project data and relationships.

Contractors tab

The following table lists the columns and their purpose for the Contractors tab of the project configuration workbook.

Column Name

Purpose

Contractor

Contractor name.

ContractorDescription

Description of the contractor.

PlanningGroup

Name of the planning group object from SmartPlant Foundation. For more information on planning groups, see Create and Configure Planning Groups.

Contract

Contract name or number.

Contracts tab

The following table lists the columns and their purpose for the Contracts tab of the project configuration workbook.

Column Name

Purpose

Contract

Contract name or number, as listed in the Contractors tab.

ContractDescription

Description of the contract.

CWPs tab

The following table lists the columns and their purpose for the CWPs tab of the project configuration workbook.

Column Name

Purpose

CWP

CWP name or number.

CWPDescription

Description of the CWP.

CWPEWP

EWP of the CWP.

CWPArea

Design area for the CWP.

CWPDiscipline

Discipline for the CWP. Disciplines listed in this column must be spelled the same as those in the Construction discipline enumerated list. For more information, see Configure Work Package Disciplines and Purposes.

WBSPath

Work breakdown structure for the CWP.

The WBSPath value is required if you plan to export your schedule data from Smart Construction and import it into Primavera P6.

PlannedStart

The planned start date for the CWP.

If you are using Primavera P6, the value matches the start_date value.

PlannedFinish

The planned finish date for the CWP.

If you are using Primavera P6, the value matches the end_date value.

ActualStart

The actual start date of the CWP.

If you are using Primavera P6, the value matches the act_start_date value.

ActualFinish

The actual finish date of the CWP.

If you are using Primavera P6, the value matches the act_end_date value.

EarlyStart

The earliest start date of the CWP.

EarlyFinish

The earliest finish date of the CWP.

LateStart

The latest start date of the CWP.

LateFinish

The latest finish date of the CWP.

BudgetedLabor

Amount of labor budgeted for the CWP in hours.

If you are using Primavera P6, the value matches the best_work_qty value.

In the workbook, the cell format should be of Date category for all the columns containing dates.

Drawings tab

The following table lists the columns and their purpose for the Drawings tab of the project configuration workbook.

Drawings must be retrieved in your Smart Construction project in order to create project configuration objects and relationships for them.

Column Name

Purpose

Drawing

The drawing name must be spelled correctly and must match the name of the drawing retrieved into Smart Construction. For more information, see Getting Data into Smart Construction.

CWP

CWP name or number, as listed in the CWP tab.

CommissioningSystem

Relates a commissioning system to a drawing as a property.

Resources tab

You can define the construction resource hierarchy in the Resources tab of the project configuration workbook. The Resources tab in the Smart Construction Import Project Data dialog box is read-only. When you process the construction resource data in the Import Project Data dialog box, Smart Construction syncs the construction resources in the project configuration workbook and your system. You can define a new level of a hierarchy in each column and details about a construction resource in each row. The column number defines the hierarchy level of the construction resource. All resources belong to the Level 1 resource or top-level category above it, and a new resource structure is created when a new top-level category is created.

Column Name

Purpose

Column 1

Defines Level 1 or top-level category of a construction resource hierarchy. Resources included under a top-level category resource are considered part of the hierarchy of the category, until a new category is defined.

Column [Number]

The column number defines the hierarchy level of a construction resource. A top-level category of a resource is defined in the column above and to the left of the resource in the list. And, other members of the hierarchy are defined in the columns below and to the right of it in the list.