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
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.
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.
You have a security role that allows you to edit the Advanced WBS.
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.
Go to Rental order management > Project rental quotations > Project rental quotations.
In the list, open the project rental quotation.
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).
Click Save.
Open the Advanced WBS in Excel
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.
Click Open in Excel.
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
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.
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.
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
On the project rental quotation, on the Action Pane, click Project quotation > Maintain > Advanced WBS.
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.