» WBS ORGANIZER v2.3 ADD-IN FOR MICROSOFT EXCEL

Please turn your device to horizontal position.
WBS ORGANIZER v2.3 ADD-IN FOR MICROSOFT EXCEL







Key Features: WBS Organizer v2.3
• Build Menu

Easily coloring and grouping activities by WBS Level using the "Build" button with Primavera P6's default color settings.

• Layout Settings Menu

Customize color settings with options for color, font size, saving, or deleting the layout. 
Previously saved color settings are available for re-use. Additionally, remove leading spaces in WBS and activity names. 
For applying coloring without grouping, use the "Remove Grouping" option.

• Gantt Chart Menu

















- Monthly Schedule: 
A feature has been added where you can choose the time interval in months and draw either just the current schedule or both the current schedule and the baseline at the same time with a single click.

- Weekly Schedule: 
You can now select any day as the first day of the week, set the time interval as a week, and draw either just the current schedule or both the current schedule and the baseline at the same time.

Additionally, by selecting your method for identifying critical activities (total float or longest path), you can draw your critical activities using the default red color, or you can change the color as per your preference, and by selecting the option to "draw by data date", you will be able to see the actual and remaining bars in two different colors (blue and green as default), just like in Primavera P6.



 
WBS Roll-up Menu

- Numerical Values Option: 
As everyone knows, when you transfer data from Primavera to Excel, it is retrieved as text. We manually add the =SUM formula to columns like units and costs to make the WBS dynamic. This process is tedious and time-consuming for large work schedules. Instead of doing this manually, this feature of the add-in will add the formulas to the relevant WBS level with a single click.






- Dates Option: 
Similarly, to make the dates in the WBS dynamic, this feature will place the (=MIN, =MAX) formulas according to the relevant WBS level.

Advanced Distribution Menu


















With Primavera P6, in the same settings, you can create a calendar for distribution by selecting the weekend days and special dates,
and have the ability to make linear, backload, and frontload distributions. This allows you to perform daily, weekly, or monthly distribution.

• Check for Updates Menu
As everyone knows, in this menu, you can follow the current version of the add-in and receive notifications.


New features added in WBS Organizer v2.2:
---------------------------------------------------

Print Calendars from XER to Excel
This feature allows you to read calendar data from an XER file, create separate sheets for each calendar, and view, analyze, or report all details (Working Days, Non-Working Days, Holidays) in a more organized manner.

Create WBS from Excel to XER

By structuring WBS names in cells based on levels, you can export the file as an XER and import it into Primavera P6, allowing you to quickly see your structured WBS in P6.

Create Activity Codes from Excel to XER
You can organize activity codes by levels in cells and save them as an XER file, which can then be imported into Primavera P6, enabling you to efficiently see your structured activity codes in P6.

Create Activity List from Excel to XER
By creating activities with their types in Excel, you can save them as an XER file, and after importing it into P6, you will have your activity list readily available.

Create Resource Dictionary from Excel to XER
You can structure your resources, resource types, unit prices, and units of measure in Excel, then export the data as an XER file. After importing it into Primavera P6, your resources will be quickly created.


Changes in the version 2.1 

1. 𝐆𝐚𝐧𝐭𝐭 𝐂𝐡𝐚𝐫𝐭 𝐌𝐞𝐧𝐮
• A daily period has been added to the Timescale.
In the Gantt chart drawing on a daily, weekly, or monthly basis;
• The ability to highlight critical paths based on Total Float and Longest Path methods has been added.
• The option to draw actual and remaining bars according to the data date has been added.
• Activity names can now be optionally added next to the bars in the drawing area.

2. 𝐀𝐝𝐯𝐚𝐧𝐜𝐞𝐝 𝐃𝐢𝐬𝐭𝐫𝐢𝐛𝐮𝐭𝐢𝐨𝐧 (𝐍𝐞𝐰 𝐌𝐞𝐧𝐮)
• A new feature has been added that allows you to perform linear, backload, or frontload distribution by selecting the desired start, finish, and quantity columns.
• You will be able to make distributions on a daily, weekly, or monthly basis as Timescale.
• You can define special holidays along with the weekly holidays, and like in Primavera P6, you can distribute your quantities excluding these days.
You will be able to view these distribution quantities either periodically or cumulatively.

3. 𝐋𝐢𝐜𝐞𝐧𝐬𝐢𝐧𝐠 𝐒𝐲𝐬𝐭𝐞𝐦
The licensing system of the add-in has been modified. In previous versions, the license code worked only for a single computer. In the new version, the activation process will work with email address and related activation code.

With this email system, if you wish to use your license on another computer, a license transfer feature has been added in the new version.
You will be able to transfer your license with you to every new company you join.

In previous versions, it was generally expected that users would have their licenses purchased by their companies. Now, you can purchase your license personally and transfer it to every new computer you use.
 


What is a WBS Organizer?

WBS Organizer is an add-on, designed to make your projects prepared in Oracle Primavera P6 and MS Project more visual and grouped on Microsoft Excel.

When you move your projects created with Oracle Primavera P6 or Microsoft Project software to Microsoft Excel with copy / paste method, it appears as non-functional plain text.

At this point, WBS Organizer can move the same project view as in Primavera P6 or MS Project software onto Microsoft Excel by grouping and coloring within seconds according to the hierarchy order.

Thanks to WBS Organizer, you will be able to group and colorize a project created with Primavera P6, keeping the activity table, resource allocation table or the WBS order, hierarchy structure, custom grouped and sorted by the user.

It works on all windows and office versions.
It can be used with two language options, English and Turkish.
How Does It Work?

WBS Organizer works as an Excel add-in, with the extension .xlam. License activation is based on an email address and an activation code. The license transfer feature allows you to use the add-in on any computer without being restricted to a specific PC. However, you cannot use the same activation code simultaneously on another computer. The add-in will only work on the last activated computer, automatically deactivating the license on the previous one. It is compatible with all versions of Windows and Office.



Latest Version: v2.3
Developer: Gürkan GEÇİCİ
Available languages: English, Turkish
PM Software Compatibility: Primavera P6, MS Project
OS Compatibility: Windows, Mac
MS Office Compatibility: x64, x86
License Type: Life-time
License Transfer: Yes
Trial Version: No
Upgrades: Free (v2.0+)
Price: $99 (one-time payment)