WBS Generator


Code has been updated to run on Excel 365. This WBS Generator allows you to create a work breakdown structure by updating an Excel table and clicking a button. Users can create conditional formats to highlight keywords, change the options to modify the look and feel, maintain the WBS with on-the-fly updates, and add second- and third-level boxes. By creating custom conditional formats, such as on the word "GREEN", "RED" or "DONE", project managers focus stakeholder attention to key points in the WBS.

Users can also format the headers, number formats, styles, body background colors and fonts of individual detail boxes. To add more details within a box, simply add another column. To rearrange the details within a box, rearrange the columns in the table. To add more boxes, add a row. Each of the values within the WBS will be updated real time as the PM updates the table.

There are a dozen options that come with the WBS Generator template, including the ability to display the last field as vertical or horizontal and to display a legend, indicating which each detail within the box represents.

Note: The WBS Generator only works when Excel's default language is set to English. Please contact me if you'd like to localize this for your language.

People who downloaded this item also downloaded . . .

Premium Content
PMI Membership
$129 /year
(plus $10 application fee)
Sign up to download this deliverable and get unlimited access to our library of webinars, time-saving templates and more.
PMI Membership perks include job opportunities, local chapters, respected publications, and standards.   Learn more
Already a PMI Member? Log in now.



Reviews (27)

Login/join to subscribe

Do, or else do not. There is no 'try'.

- Yoda