{"id":7918,"date":"2022-06-15t13:15:12","date_gmt":"2022-06-15t17:15:12","guid":{"rendered":"\/\/www.deco-dalles.com\/?p=1812"},"modified":"2024-04-03t11:39:29","modified_gmt":"2024-04-03t15:39:29","slug":"export-p6-resource-assignment-data-excel","status":"publish","type":"post","link":"\/\/www.deco-dalles.com\/export-p6-resource-assignment-data-excel\/","title":{"rendered":"one trick to export p6 resource assignment data to excel"},"content":{"rendered":"
as you know primavera p6 has a lack of graphical features so often we schedulers need to export everything to other software packages (mostly excel) to produce an understandable schedule and graphs. i always had a problem when i export p6 resource assignment<\/a> data to excel with the standard exporting feature on p6 until i found a way to leverage the reports feature.<\/p>\n here you can use the current screen to develop a report and instead of making it a text report, we can have it produce an excel report<\/a>. this tutorial is good for anyone who wants to develop better resource curves<\/a> and analyze resource assignments.<\/p>\n so let’s go it.<\/p>\n <\/p>\n when you opened the desired project, on the left hand side, you can choose different options. in this case, to see the assignments, you need to select the aasignment tab<\/p>\n <\/p>\n in this table, we have a resource assignments table on the left hand side and time-distributed data on the right. we can modify these tables in some different ways. i describe my way below:<\/p>\n <\/p>\n right-click on the left table and choose filters.<\/p>\n <\/p>\n in the filters screen write the following formula:\u00a0\u00a0<where budgeted units\/time is greater than 0><\/strong>.<\/p>\n in this way you will have only the 世界杯时间比赛时间
that have assignment not all the 世界杯时间比赛时间
that has been defined.<\/p>\n <\/p>\n right-click on the right hand table (spreadsheet) and from the menu choose spreadsheet fields<\/strong> and then customize<\/strong>.<\/p>\n <\/p>\n in the open menu we have two categories of columns, cumulative and time interval. we\u2019ll select cum. budgeted units<\/strong> from cumulative and budgeted units<\/strong> from the time interval – in this way we will have data for each month separately and cumulatively.<\/p>\n you can select any kind of data for your report purposes. for this report we do not need any specific column on the left hand table.<\/p>\n what we need is just the resource name but it is visible that you can add any specific column to that table whenever is needed according to your report requirements.<\/p>\n now we have data to develop s-curves. now we focus on exporting these data to excel.<\/p>\nexport p6 resource assignments to excel with the help of reports<\/h2>\n
step 1 – select the assignment tab<\/h2>\n
step 2 – resource assignments page<\/h2>\n
step 3 – filter the 世界杯时间比赛时间
<\/h2>\n
step 4 – choose spreadsheet fields<\/h2>\n