58 STEPS
1. The first step is to open Analyze | ALICE and click Custom WBS
2. Click Custom WBS
3. Customize your WBS view with parameters and UDF's.
Note:The custom WBS view will also apply to the P6 export WBS levels.
4. Click + to add the next WBS level
5. Scroll and click highlight to select your WBS levels
6. Click highlight
7. Scroll and click highlight
8. Click OK
9. Right Click on the columns in gantt to expand rows, collapse rows, and edit columns
10. Note these shortcut Keys
11. With your mouse, hover Collapse level...
12. Click Level 2 to show Gantt at WBS level 2
13. With your mouse, hover highlight
14. Click Level 3 to expand the WBS level
15. Click highlight to expand the columns in the WBS
16. Click highlight
17. Click the filter builder
18. Click Criticality
19. Click to select the filter for Critical Tasks
20. Click Done
21. Click Criticality Tools
22. Click Show critical tasks
23. Click Gantt Only View
24. Click Done
25. Click Analytics & 4D to view and export resource analytics
26. Click Carpenter Crew to filter for the crew type
27. Click on 4D to apply your filters to the 4D simulation
28. Click Week
29. Select filter timeline in the 4D
30. Click Play
31. Click Crew:Carpenter Crew
32. Click Carpenter Crew
33. Click Export CSV to export the filtered crew utilization by day
34. Click highlight
35. Click Export CSV to export daily utilization for all crews
36. Click highlight
37. Click Equipment
38. Click Drill Rig Large
39. Click Drill Rig Large
40. Click Done
41. Click Crew Utilization
42. Select Equipment Utilization
43. Click Select date
44. Click 2023
45. Click 2021
46. Click Apr
47. With your mouse, hover 2021
48. Click Dec
49. Click 31
50. Click Export CSV
51. Click highlight
52. Click Analytics & 4D
53. Click Gantt Only
54. Scroll left and click Export
55. Click CSV to export raw data in csv format
Note: this is robust structured data for reporting & dashboards
56. Click P6 XML
57. Select Export Setting & Click Export P6 XML
That's it. You're done.
58. That's it. You're done.
Here's an interactive tutorial
** Best experienced in Full Screen (click the icon in the top right corner before you begin) **
https://www.iorad.com/player/2274799/Analyze---Export-ALICE-Solutions?iframeHash=trysteps-1
This clickable tutorial shares best practices for filtering WBS, Columns, Rows, and exporting data to CSV and Primavera P6 XML format.
Next step
