I'd like to ask the experienced guys dealing with resources / export / import, etc, How do you export the Labor Units to Excel, in a time-bound format?
For example, let's say Activy 1 has 320h assigned between December '13 and January '14, and Activity 2 has 960h assigned between January '14 and March '14, respectively:
Act Description Start Finish Dec-13 Jan-14 Feb-14 Mar-14
Activity 1 01-Dec-13 31-Jan-14 160h 160h
Activity 2 02-Jan-14 31-Mar-14 320h 320h 320h
How do you export the Labor Units to Excel, in a time-bound format?
Dear,
First of all you check that your all activities must be having resource allocated to them if not then allocate each activity a resource. Now u have two ways to get your labor units
1. Create a report and then run it u will get your labor units. For report generation you need to select majorly 5 major categories in that last one is Time interval field just in that collumn select budgeted units and Cum budgeted units you will get each every thing done.
2. Second one easiest way to generate s curve on top of P6 bar select Activity usage spreadsheet In bottom it will display u labor units distribution just select all copy it and paste in excel sheet. u will get what u want. Rest other u know very well..
Make sure that the timescale which you selected in P6 must be according to time scale you want in your S Curve because your labor units distribution will come accordingly.
Thanks
Vivek
Hi there, when you have pasted the data into excel, there are a number of ways to ensure that the data is of numeric value by :
1. if the data comes eg: 140h , use LEFT formula to rid of the "h" so it becomes a numeric value.
2. if the data is of text value eg: '160, copy the data again & paste special as value.
3. Download ASAP Utilities or Power UItility Pack which are free add-ins for Excel & they will help with the format problems.
Other than that, you are stuck!
Regards,
Philip
You typed the units directly on the Column named "Budgeted Labor Units"
To get the data from the Activity Resource Spreadsheet, you may print the Report on HTML or ASCII File using the Tools Reports.
The difference as per my experience, I can Print directly from P6 the Layout shown on the Resource/Activity Usage Spreadsheet. While in the Resource Assigment Window, I can't Print the Layout but I can copy the data and paste to Excel.
Thanks Raymund, I opened the Resources Assignment window (Project->Resources Assignment) and I couldn't get anyhting.
This might be because the Labor Units are assigned directly to activities, not resources, that's why I tried the Activity Usage Spreadsheet (View->Show on Bottom->Activity Usage Spreadsheet) and then copied and pasted (not sure if this is the 'correct way' to try to develop an S-curve based on manhours).
I suppose that if the manhours (Labor Units) were assigned to resources, then I think I could use the way you are indicating.
Now, what is the difference between the Resources Assignment window (Project->Resources Assignment) and Resource Usage Spreadsheet (View->Show on Bottom->Resource Usage Spreadsheet)?
Use the Resource assigment Window.... then Copy and Paste to Excel
I tried doing the following: I showed on the bottom, the Activity Usage Spreadsheet, then selected everything and just copied and pasted on to an Excel spreadsheet ... the only thing is that all the information pasted is text type ... Is there a way to export the same thing (Labor Units values) as numeric values (in a time-bound format)?
My ultimate goal is to develop an S-curve with the cumulative values for the planned (budgeted), actual and remaining (fcst) values.
Thanks.