--- title: "Edit Advanced WBS in Excel with rental fields" slug: "edit-advanced-wbs-in-excel-with-rental-fields" description: "Edit a project rental quotation’s Advanced WBS in Microsoft Excel, add rental columns and WBS IDs, then publish and review the result." tags: ["Rental Management", "RM", "Task"] status: "new" updated: 2026-11-20T13:02:41Z published: 2026-11-20T13:02:41Z canonical: "docs.staedean.com/edit-advanced-wbs-in-excel-with-rental-fields" --- > ## Documentation Index > Fetch the complete documentation index at: https://docs.staedean.com/llms.txt > Use this file to discover all available pages before exploring further. # Edit Advanced WBS in Excel with rental fields 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. > [!NOTE] > Prerequisites > > - The STAEDEAN Rental Management and Project Control Suite integration is set up, including the Open in Excel. For more information, see [Set up Rental Management and Project Control Suite integration](/equipment-rental/docs/set-up-rental-management-and-project-control-suite-integration). > - The project rental quotation is created with **Show WBS with units and quantities** set to **Yes**. For more information, see [Create project rental quotation with Project Control Suite](/equipment-rental/docs/create-project-rental-quotation-with-project-control-suite). > - You have a security role that allows you to edit the Advanced WBS. > [!NOTE] > 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](/equipment-rental/docs/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] > 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] > 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] > Note > > If the project lines are nested under each other, check the **Use flat numbering for consecutive projects via Excel integration** parameter. ## Related - [Plan project rental quotation in Advanced WBS](/plan-project-rental-quotation-in-advanced-wbs.md) - [Set up Rental Management and Project Control Suite integration](/set-up-rental-management-and-project-control-suite-integration.md) - [Create project rental quotation with Project Control Suite](/create-project-rental-quotation-with-project-control-suite.md)