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. |