Edit Advanced WBS in Excel with rental fields

Prev Next

You can open the Advanced WBS of a project rental quotation in Microsoft Excel. In Excel, you build or change the Advanced WBS, including the rental columns. When you publish from Excel, the data is published to the Advanced WBS of the quotation.

Prerequisites

Note

This article covers the Advanced WBS of the project rental quotation. To change a rental project after the transfer, see Change rental project and update rental order.

Generate WBS IDs automatically

This is optional. If you add projects and tasks in Excel, the WBS IDs can be generated when you publish. Otherwise, you enter the WBS IDs in Excel yourself.

  1. Go to Rental order management > Project rental quotations > Project rental quotations.

  2. In the list, open the project rental quotation.

  3. On the Header tab, in the Project control suite section, set Generate WBS ID to Yes.

    When you publish from Excel, rows with the line type Project become project lines with their own WBS ID. Rows with the line type Activity become tasks, numbered within their project.

    How consecutive project rows are numbered depends on the Use flat numbering for consecutive projects via Excel integration parameter (Project Control Suite parameters - Integration tab):

    • Yes: The project rows are numbered at the same level (1, 2, 3).

    • No: Each project row is nested under the previous one (1, 1.1, 1.1.1).

  4. Click Save.

Open the Advanced WBS in Excel

  1. On the project rental quotation, on the Action Pane, click Project quotation > Maintain > Advanced WBS or Advanced WBS Edit.

    For a project rental quotation, Open in Excel is available on both pages.

  2. Click Open in Excel.

  3. Select the bid import template, and click OK.

    The columns in Excel follow the template. The default templates include the rental columns.

Build or change the Advanced WBS in Excel

  1. Add a row for each project and each task. In the line type column, select Project or Activity.

    If Generate WBSID is No, enter the WBS IDs yourself.

  2. Add the estimate lines, and fill in the rental columns, such as Rental transaction type, On-rent date/time, and Expected off-rent date/time.

    Note

    The Rental Line Editor doesn't open from Excel. Enter supplementary items as separate rows.

  3. In the Microsoft Excel add-in pane, click Publish.

    Note

    You can fields on the Excel template using Design. You can also publish your own templates.

Review the result

  1. On the project rental quotation, on the Action Pane, click Project quotation > Maintain > Advanced WBS.

  2. Check the structure and the generated WBS IDs.

    Note

    If the project lines are nested under each other, check the Use flat numbering for consecutive projects via Excel integration parameter.