If I am running a cost loading report out of a status project, for the purposes to inform my customer what unfinished work is remaining on the project, and how it is time phased, I am only seeing BCWS. The remaining work of the in progress activities doesn't show up on the report, so I am short on budget.
How can I get both planned and remaining to show up on the same report, with time phasing represented as it stands in the status project?
Thank you!
Hi Alex
Try this,
> Go to the Activity Usage Spreadsheet
> Go to the Righthand bottom part of the bottom screen.
> Click right and select the following spreadsheet fields. Planned total cost, Remaining total cost and Actual total cost
Now, the values are displayed in the spreadsheet.
Select, copy and paste in Excel.
Regards
Johannes
sometime this works if you want to dump this to excel go to Project the Resource Assignments
get your time frame on the rigth hand side (by monthor quarter or what ever) by right click and select timescale
then on the roll up your resource on the left hand side click the + sign
Then on the right in the timescale select the first period that you want the data for and hold the shift key and select the last period that you and data for
select edit then copy
go to excel and select paste.
Thank you! And can this be dumped into Excel? The end result is we need to submit the data to our financial people via Excel.
Basically, we are required to submit our funding requirements via Excel to our CFO counterparts. While our baseline is sound, the status project (or forecast, as many call it) is what is determining what scope is scheduled to occur within the given time frame. With P6 cutting off the remaining work of in progress activities, my Excel numbers are short by that amount.
view show on bottom resource actviity uage profile and then right clikc on the right hand side in the histogram area and select Activity Usage Profile Options then Baseline and anything you want to comapre it to you can do this based on units or costs. You can also show a cumulative curve there as wel just chekc the box under cumulative.
I don't want the BCWS or Remaining work on in progress activities to show me the spread based on their baseline dates. I want the budget spread out over the time period in which the status project says it is planned to take place.
Basically, our customer is asking us the question - "What does P6 state that we are planning to perform during a certain time period," and they want the answer in $, by financial period. We initially ran a cost loading report out of the status project, but it only gave us the BCWS for the activities that had not yet started. The activities that were in progress didn't show up at all. The portion of the in progress activities that was claimed as BCWP didn't show up, which was perfect. However, the remaining work also did not show up either, which meant our budget for the overall time period in question (Fiscal Year 17, for example) was short by the amount of the remaining work of the in progress activities.
not sure what you mean by phasing ?
I have the proper baseline attached and assigned. I guess I didn't realize you could reference the baseline in a cost loading report. I will look into that. Thank you! Question: Will it give me the time phasing of the in progress activities from the baseline or the status project? I need the time phasing from the status.....
assign a baseline then reference it