I understand you are doing an internal monitoring as a Contractor and these reports are not provided to the Client/Consultant, otherwise the industry practice is the BCWS is developed based on the BoQ when the contract requires the project to be monitored by EVM.
regards,
Anees
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Sat, 2006-12-09 11:25
You are right in a way, but actually theres a big difference between the contract amount & the contractor budget.
We all know as contractors that the prices given to client aint accurat estimates, not even near it. but as the project starts you start to allocate your budgets, thats what will be BCWSout which you start to measure against.
Moe
Member for
21 years 11 months
Member for22 years
Submitted by Aneesuddin Zub… on Sat, 2006-12-09 08:22
Picked up from the last few threads, for some the ACWP is mistery because you do have the pricing/bidding strategy. The ACWP has to be read in conjunction with the bidding strategy, in lumpsum contracts the bidders sometimes frontload the cost which makes the ACWP out of equation.
Just looking at the CPI and understanding profit and loss is misleading it is a bit more than that.
regards,
Anees
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Sat, 2006-12-09 06:54
in our case, the buyers the client, Sellers the contractor
For the In Cost:
BCWPin : The value of works (As per contract schedule of rates) completed to date, which you will claim in your monthly invoice
BCWSin: The value of works (AS per contract schedule of rates) which you should have claimed as per your baseline
ACWPin: the MONEY you have recieved already from client to date.
SPIin<1: Means You are claiming less than what you were supposed to claim as per basline = behind schedule
CPIin<1: means You are getting from client less money than the work you have performed = you are overestimating your % complete or client is understimating it
For the out Cost:
BCWPout: The value (as per contractor estimates) of works completed to date
BCWSout: The value of works (As per contractor estimates) which you should have spent as per your baseline
ACWPout: The actual amount you have spent to date
SPIout<1: Means you are behind schedule
CPIout<1: means you are losing money "unefficiency"
You can load all of these values on P3, & get very good results only if you load it in the right way by setting cost accounts.
I guess you can calculate Profit rates based on the outputs you will get from the above values.
I Didnt load all of them together before, but i guess that theory works, everyone is welcome to comment.
Moe
Member for
19 years
Member for19 years
Submitted by Tahir Naseem P… on Wed, 2006-12-06 15:47
Any how I accept my mistake in my sample project and thanks for the information. But still as Mr. Hamment said ACWP is a real mystery. Because even we change the Rule # 3 the figure we received becomes the forecast and we can say it is our new BCWP after the data date. The actual always come from the concern department under the proper cost code. No body fix that for next month I will spend 1 million to get 2% progress as following the previous expense trend. This one million again become forecast not actual.
May be I am getting old and not adopting new ideas. Sorry to Mohammad again.
Regards
Tahir
Member for
19 years
Member for19 years
Submitted by Tahir Naseem P… on Wed, 2006-12-06 15:39
Let I will accept your advise and explore where you wrong and still insist on wrong concepts.
I develop one activity with the duration of ten days with continuous work
Let start date is 10-Dec-2006
Resources require 5 craft man for ten days
10 hrs / day working hours
Budgeted hours = 5X10X10=500
Suppose cost /Hrs 10 US$
Budgeted Cost = 500X10=5000 US $
BCWS is 500$ per day as per linear basis.
After completing all these work
We update our plan after two days as per actual progress.
Unfortunately after two days progress achieved is only 10 % as compare to 20% and consume 130 hours rather then 100 hrs due to some work need to finish same day.
BCWS= 20%X5000=1000US$
BCWP=10%5000=500US$
ACWP=100X10$=1000 + 20 X15=300 OT = 1300
After manually feeding the actual cost in cost tab 1300 we develop the cost loading report and the result is given below
PRIMAVERA PROJECT PLANNER
REPORT DATE 29NOV06 RUN NO. 22 COST LOADING REPORT START DATE 28NOV06 FIN DATE 20DEC06
01:57
DATA DATE 12DEC06 PAGE NO. 1- 1
Cost Loading - Detailed by Day TOTAL USAGE FOR DAY
Yes up to now you are true but project is not completed yet and now after next two days we get the progress 15% more to-date become 25 %, and consume 200 hours due to 8 hrs work next day due to less work front and cost controlling.
BCWS= 40%X5000=2000US$
BCWP=25%5000=1250US$
ACWP=100X10$=1000 + 20 X15=300 OT = 1300 + 80X10=800 =2100
After manually feeding the actual cost in cost tab 2100 we develop the cost loading report and the result is given below which is totally different then previous for ACWP
PRIMAVERA PROJECT PLANNER
REPORT DATE 29NOV06 RUN NO. 30 COST LOADING REPORT START DATE 28NOV06 FIN DATE 21DEC06
02:02
DATA DATE 14DEC06 PAGE NO. 1- 1
Cost Loading - Detailed by Day TOTAL USAGE FOR DAY
No management will allow you to change your ACWP for every time for each work period. The graphical presentation will clear it more. I will send you these graphs if you send your email address
Here is clear that the ACWP from P3 is not a good idea even it provide you distribution but P3 not keep the previous history for each work period which is its big big big big big big big big big big big big big big big draw back.
Every time P3 will provide you BCWP and ACWP (after manually feeding) different cost of each work period based on the calculation start from actual start date and distribute as per applied curve up to data date.
I think this will clear that ACWP from P3 is not a good and even practical in real life costing analysis.
You give me a good task, thanks for it and my revision
Regard’s
Tahir
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Tue, 2006-11-28 10:42
Can you please make one activity schedule, load it with a resource & update it while autocost rule No5 is off, record actual costs more than the BCWP, & run cost loading report & see the results, before Data date it will be AC & after data date it will be BCWS (revised)
Moe
Member for
19 years
Member for19 years
Submitted by Tahir Naseem P… on Tue, 2006-11-28 05:34
With extreme sorry that UR procedure is not correct to get ACWP from P3. The reason whenevr you feed you fix some quantity/cost what so ever, it become your plan automatically which you calculate for the future for your best experince and the trend of progress. Then it will become again your forcast plan not actual.You dont know what happen in next month.
It is again surprising me that you got the AC %age with using the Budgted values. Really surprising??????.
In you reply it is clear that AC=EV so EV always come from budgte please remind.
My concept is still stand that P3 give you always BCWP even you feed it manually, in this case for future it is BCWP. you got the actual always at the end of progress period.
Please some one guid me to correct my concepts.
Regards
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Tue, 2006-11-28 01:26
when autocost rule #5 (use update percent complete to estimate actual quantity / cost to date) is off then the Formula should read as "EV=BC* %Comp" & u will enter AC manually based on data collected from payroll cards.
When the same rule is on, P3 will calculate AC=EV=BC* % comp, thats when u have a Crystal ball.
What u get from Cost Loading is AC, depending on ur autocost rule 5 it might be AC or EV.
yes u r right if u manually entered a cost value in p3, the actual cost is ACWP.
but i think what tahir (and me) wanted to point out is that by default entering % complete,
the actual cost = BC * PCT = BCWP
hey, Thanks for mentioning abt shift-F7! i never use that!
so P3 is capable of generating EV (BCWP) even if actual is entered! It would be nice if they incorporate this value in their Loading or Tabular reports.
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Mon, 2006-11-27 09:53
In a project where u record the actual manhours spent on each activity, what u will get from the cost loading report will be "ACWP" & the revised "BCWS" as per the current update of your schedule (before and after the data date)
I can get the original BCWS easily from the target program.
For the BCWP i cant get it through the report !
Right now what am doing is that i will use the cost table "shift+f7" to get the 3 variables "ACWP - Current Estimate", "BCWP - Earned value" & "BCWS - Planned Value as per Target", i will just print each table & record it manually on Excel.
My question was is there any other way to output directly the 3 values to excel distributed on a timescale ?
For Tahir - if your record AC on Primavera, u will get it on the cost loading report not Earned value, Try it n tell me.
Are u sure u generate the report correctly? because Cost Loading DOES generate by Time Period in a table format... each columns is a time period (in your case, you can choose MONTHLY)
and do remember Tahir’s reminder that P3 gives the BWCP not the ACWP (which you have to gather from wherever this is captured in your company.
and the idea of putting the BCWS in the custom is interesting. I never thought of it. I usually just generate the BCWS from the Baseline schedule (anyway just generate once). My Excel worksheet will hve this BCWS and monthly i will generate the Cost Loading report to get the latest BWCP to be "paste" into the excel sheet. And from "another" source, the ACWP, which unfortunately, i have to manually entered into that same excel sheet. But not a problem, since this is NOT at activty-level!)
Member for
19 years
Member for19 years
Submitted by Tahir Naseem P… on Thu, 2006-11-16 17:28
Sorry that i did not understand your problem but it is also little your fault that you did not clear in your query that you need these entire figure by time period.
This is easier than previous may be if I am not wrong.
In p3 which ACWP we get is basically BCWP not ACWP, why because the figure calculate simply
%age comp * budgeted cost= Budgeted cost work performed.
Actual cost for a certain period always come from the account department after the proper booking of each cost in it proper cost head. Normally each month this report will issue to cost department for verification and further usage. (this is my understanding and general practice)
No we come to the solution.
1- You create the same cost loading report from your target / base schedule (Period wise) for BCWS
2- Same create another report from your update schedule (Period wise) for BCWP
3- Collect the actual cost data from concern department (Period wise) ACWP
Now you have all three figures time period wise
Use only one excel sheet and copy all three figure under time period you defined and prepared graph.
The data is ready for to develop the graph same as ctrl+F7
Hope this will work for you
Regards
Tahir
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Thu, 2006-11-16 15:53
I got you wrong yesterday. So the problem isnt so easy definitely. Since they didnt include Earned Value for the cost loading report it not so easy to get BCWP spreading over timeframe. But it still can be done.
The point - you need 2 tables - same Cost Loading Reports from your current & baseline schedules. The resources, timeperiods - everything should be the same. Dont forget to include Row Totals in it. Next step is to load this 2 CSV files into Access and establish the link between tables through field RES. Last step - create Query taking 1st column Nov-06 (for instance) from Target Table (BCWS), 2nd column Nov-06 from current project (ACWP), 3rd - lil tricky - BCWP : [LB17.NOV 2006]/[LB17.TOTAL]*[LB01.TOTAL]
This is my real life projects LB01- Target, LB17 - current.
Thats it.
Andrew
Member for
19 years 1 month
Member for19 years1 month
Submitted by Mohamed Thabet on Thu, 2006-11-16 03:43
I want to have on a spreadsheet a table in which i will have columns of time Periods (July 07, August 07...) and each columns of these is divided to 3 columns (BCWS, BCWP, ACWP).
I want to have the same graph of cost profile which u get by pressing "Ctrl+F7" in P3 but on excel, the only difference is in each time period i will have 3 columns for the 3 values of BCWS, BCWP, ACWP.
Andrews Report shows BC or AC for completed activities, and it doesnt give you the chance to include BCWS, ACWP, BCWP in the outputs, while Tahirs method will not give you the values by Time periods, it will do it for activity by activity.
Therefore "Cost loading Report" and Export will not be a lot of help here.
Member for
19 years
Member for19 years
Submitted by Tahir Naseem P… on Wed, 2006-11-15 18:00
He is asking for all three values where as from current schedule we can get on ACWP & BCWP but BCWS is only get from the target or base line schedule. I also have this problem last month and how i solved it may be it is use full for others
1- First i create on custom data item such bcsc
2- Then run global change for bcsc=bcws ( keep in mind you already define your target first)
Now the bcws is in one column
3- go to export utility and create new report
4- Adding in the description
Earned value
Actual Cost
custom data item
5- run this report
You will find the all three values for you all activities up to data dates.
Hope if some one have another shortcut please share the knowledge
Regards
Tahir
Member for
20 years 11 months
Member for21 years
Submitted by Andrew Podolny on Wed, 2006-11-15 13:59
In Format Tab select [x] Export report in CSV format to the file...
Open this CSV file in Excel.
Sometimes - it depends on Regional Settings of your OS - you cant open CSV file properly - if the List separator differs from ",". Workaround is Find/Replace "," in CSV file to your system List separator symbol.
Member for
19 years 1 monthRE: EV
You can do both, internally & externally, as i have explained the difference between CASH in & CASH out.
Member for
21 years 11 monthsRE: EV
Hi Mohamed,
I understand you are doing an internal monitoring as a Contractor and these reports are not provided to the Client/Consultant, otherwise the industry practice is the BCWS is developed based on the BoQ when the contract requires the project to be monitored by EVM.
regards,
Anees
Member for
19 years 1 monthRE: EV
Well Anees,
You are right in a way, but actually theres a big difference between the contract amount & the contractor budget.
We all know as contractors that the prices given to client aint accurat estimates, not even near it. but as the project starts you start to allocate your budgets, thats what will be BCWSout which you start to measure against.
Moe
Member for
21 years 11 monthsRE: EV
Hi
Picked up from the last few threads, for some the ACWP is mistery because you do have the pricing/bidding strategy. The ACWP has to be read in conjunction with the bidding strategy, in lumpsum contracts the bidders sometimes frontload the cost which makes the ACWP out of equation.
Just looking at the CPI and understanding profit and loss is misleading it is a bit more than that.
regards,
Anees
Member for
19 years 1 monthRE: EV
Guys,
There are two types of costs, In & out.
In cost, is Buyers "OUT OF POCKET" Money
out cost, is Sellers "OUT OF POCKET" money
in our case, the buyers the client, Sellers the contractor
For the In Cost:
BCWPin : The value of works (As per contract schedule of rates) completed to date, which you will claim in your monthly invoice
BCWSin: The value of works (AS per contract schedule of rates) which you should have claimed as per your baseline
ACWPin: the MONEY you have recieved already from client to date.
SPIin<1: Means You are claiming less than what you were supposed to claim as per basline = behind schedule
CPIin<1: means You are getting from client less money than the work you have performed = you are overestimating your % complete or client is understimating it
For the out Cost:
BCWPout: The value (as per contractor estimates) of works completed to date
BCWSout: The value of works (As per contractor estimates) which you should have spent as per your baseline
ACWPout: The actual amount you have spent to date
SPIout<1: Means you are behind schedule
CPIout<1: means you are losing money "unefficiency"
You can load all of these values on P3, & get very good results only if you load it in the right way by setting cost accounts.
I guess you can calculate Profit rates based on the outputs you will get from the above values.
I Didnt load all of them together before, but i guess that theory works, everyone is welcome to comment.
Moe
Member for
19 yearsRE: EV
Dear Mohammad / hamment
Sorry for last may be enter key press.
Any how I accept my mistake in my sample project and thanks for the information. But still as Mr. Hamment said ACWP is a real mystery. Because even we change the Rule # 3 the figure we received becomes the forecast and we can say it is our new BCWP after the data date. The actual always come from the concern department under the proper cost code. No body fix that for next month I will spend 1 million to get 2% progress as following the previous expense trend. This one million again become forecast not actual.
May be I am getting old and not adopting new ideas. Sorry to Mohammad again.
Regards
Tahir
Member for
19 yearsRE: EV
Member for
23 yearsRE: EV
Can I interrupt
BCWS : What The Contractor Should Have Received From The Client On This Day If Everything Went As Per Plan !!!
BCWP : What The Contractor Will Get For The Works Performed Till Date (EV)
ACWP : What The Contractor Spent So Far ( No Program Will Give This Value)
Which Is Not Equal To “ Actual Qty This Period X Price / Unit “ which every program gives
Correct Me If Iam Wrong
if the Original question is exporting time phased cost data to excel
there was an excel interface with P3.2 installation CD (from my memory)which can show that in weekly intervals
or you may contact a French Gentleman In this Forum with excellant VBA Skills Mr Alexandre Faulx-Briole
Another option is using "Reportsmith" make custom querie and make reports and open data in excel
HEMANT
For planners like me ACWP is a mystery
So Nowadays I don’t bother beyond SV And SPI
Member for
19 years 1 monthRE: EV
Tahir,
What you got there was ACWP not BCWP.
You have 2 problems as i can see in your sample project:
1. You didnt use "Store Period Performance" Function
By the end of the upate period (Monthly, weekly, daily) you have to "Store Period Performance"
In the new update period, you will update "actual this period" not "Actual to date"
2. Autocost Rule #3, "Add Actual to ETC" is off, thats why i guess no matter how far was ur AC thn BCWS, still BAC remains the same.
From my humble point of view, P3 IS an amazing tool to store AC & compare it with BCWS & EV (just if you knew how to use it)
Try it that way & tell me what do u think
Moe
Member for
19 yearsRE: EV
hi Tahir,
nice of u to show the "try-out"
maybe u can try the Period Close-Out to see if it "freezes" the ACWP and BCWP of the prev update b4 proceeding with the next update.
i never use this function myself.
Mohammad, what about u? do you use the Period Close-out function?
Member for
19 yearsRE: EV
Dear Mohammad
Let I will accept your advise and explore where you wrong and still insist on wrong concepts.
I develop one activity with the duration of ten days with continuous work
Let start date is 10-Dec-2006
Resources require 5 craft man for ten days
10 hrs / day working hours
Budgeted hours = 5X10X10=500
Suppose cost /Hrs 10 US$
Budgeted Cost = 500X10=5000 US $
BCWS is 500$ per day as per linear basis.
After completing all these work
We update our plan after two days as per actual progress.
Unfortunately after two days progress achieved is only 10 % as compare to 20% and consume 130 hours rather then 100 hrs due to some work need to finish same day.
BCWS= 20%X5000=1000US$
BCWP=10%5000=500US$
ACWP=100X10$=1000 + 20 X15=300 OT = 1300
After manually feeding the actual cost in cost tab 1300 we develop the cost loading report and the result is given below
PRIMAVERA PROJECT PLANNER
REPORT DATE 29NOV06 RUN NO. 22 COST LOADING REPORT START DATE 28NOV06 FIN DATE 20DEC06
01:57
DATA DATE 12DEC06 PAGE NO. 1- 1
Cost Loading - Detailed by Day TOTAL USAGE FOR DAY
9DEC 10DEC 11DEC 12DEC 13DEC 14DEC 15DEC 16DEC 17DEC
ACT ID DESC TOTAL 2006 2006 2006 2006 2006 2006 2006 2006 2006
MH - ( )
0001 heat exchanger 5000.0 650.0 650.0 411.1 411.1 411.1 411.1 411.1 411.1
TOTAL MH 5000.0 650.0 650.0 411.1 411.1 411.1 411.1 411.1 411.1
REPORT TOTAL 5000.0 650.0 650.0 411.1 411.1 411.1 411.1 411.1 411.1
Yes up to now you are true but project is not completed yet and now after next two days we get the progress 15% more to-date become 25 %, and consume 200 hours due to 8 hrs work next day due to less work front and cost controlling.
BCWS= 40%X5000=2000US$
BCWP=25%5000=1250US$
ACWP=100X10$=1000 + 20 X15=300 OT = 1300 + 80X10=800 =2100
After manually feeding the actual cost in cost tab 2100 we develop the cost loading report and the result is given below which is totally different then previous for ACWP
PRIMAVERA PROJECT PLANNER
REPORT DATE 29NOV06 RUN NO. 30 COST LOADING REPORT START DATE 28NOV06 FIN DATE 21DEC06
02:02
DATA DATE 14DEC06 PAGE NO. 1- 1
Cost Loading - Detailed by Day TOTAL USAGE FOR DAY
9DEC 10DEC 11DEC 12DEC 13DEC 14DEC 15DEC 16DEC 17DEC
ACT ID DESC TOTAL 2006 2006 2006 2006 2006 2006 2006 2006 2006
MH - ( )
0001 heat exchanger 5000.0 525.0 525.0 525.0 525.0 362.5 362.5 362.5 362.5
TOTAL MH 5000.0 525.0 525.0 525.0 525.0 362.5 362.5 362.5 362.5
REPORT TOTAL 5000.0 525.0 525.0 525.0 525.0 362.5 362.5 362.5 362.5
No management will allow you to change your ACWP for every time for each work period. The graphical presentation will clear it more. I will send you these graphs if you send your email address
Here is clear that the ACWP from P3 is not a good idea even it provide you distribution but P3 not keep the previous history for each work period which is its big big big big big big big big big big big big big big big draw back.
Every time P3 will provide you BCWP and ACWP (after manually feeding) different cost of each work period based on the calculation start from actual start date and distribute as per applied curve up to data date.
I think this will clear that ACWP from P3 is not a good and even practical in real life costing analysis.
You give me a good task, thanks for it and my revision
Regard’s
Tahir
Member for
19 years 1 monthRE: EV
Tahir,
Can you please make one activity schedule, load it with a resource & update it while autocost rule No5 is off, record actual costs more than the BCWP, & run cost loading report & see the results, before Data date it will be AC & after data date it will be BCWS (revised)
Moe
Member for
19 yearsRE: EV
Dear Mohamed
With extreme sorry that UR procedure is not correct to get ACWP from P3. The reason whenevr you feed you fix some quantity/cost what so ever, it become your plan automatically which you calculate for the future for your best experince and the trend of progress. Then it will become again your forcast plan not actual.You dont know what happen in next month.
It is again surprising me that you got the AC %age with using the Budgted values. Really surprising??????.
In you reply it is clear that AC=EV so EV always come from budgte please remind.
My concept is still stand that P3 give you always BCWP even you feed it manually, in this case for future it is BCWP. you got the actual always at the end of progress period.
Please some one guid me to correct my concepts.
Regards
Member for
19 years 1 monthRE: EV
Eugene,
when autocost rule #5 (use update percent complete to estimate actual quantity / cost to date) is off then the Formula should read as "EV=BC* %Comp" & u will enter AC manually based on data collected from payroll cards.
When the same rule is on, P3 will calculate AC=EV=BC* % comp, thats when u have a Crystal ball.
What u get from Cost Loading is AC, depending on ur autocost rule 5 it might be AC or EV.
Moe
Member for
19 yearsRE: EV
mohamed,
yes u r right if u manually entered a cost value in p3, the actual cost is ACWP.
but i think what tahir (and me) wanted to point out is that by default entering % complete,
the actual cost = BC * PCT = BCWP
hey, Thanks for mentioning abt shift-F7! i never use that!
so P3 is capable of generating EV (BCWP) even if actual is entered! It would be nice if they incorporate this value in their Loading or Tabular reports.
Member for
19 years 1 monthRE: EV
Guys,
In a project where u record the actual manhours spent on each activity, what u will get from the cost loading report will be "ACWP" & the revised "BCWS" as per the current update of your schedule (before and after the data date)
I can get the original BCWS easily from the target program.
For the BCWP i cant get it through the report !
Right now what am doing is that i will use the cost table "shift+f7" to get the 3 variables "ACWP - Current Estimate", "BCWP - Earned value" & "BCWS - Planned Value as per Target", i will just print each table & record it manually on Excel.
My question was is there any other way to output directly the 3 values to excel distributed on a timescale ?
For Tahir - if your record AC on Primavera, u will get it on the cost loading report not Earned value, Try it n tell me.
Member for
19 yearsRE: EV
Dear Mohammad,
Are u sure u generate the report correctly? because Cost Loading DOES generate by Time Period in a table format... each columns is a time period (in your case, you can choose MONTHLY)
and do remember Tahir’s reminder that P3 gives the BWCP not the ACWP (which you have to gather from wherever this is captured in your company.
and the idea of putting the BCWS in the custom is interesting. I never thought of it. I usually just generate the BCWS from the Baseline schedule (anyway just generate once). My Excel worksheet will hve this BCWS and monthly i will generate the Cost Loading report to get the latest BWCP to be "paste" into the excel sheet. And from "another" source, the ACWP, which unfortunately, i have to manually entered into that same excel sheet. But not a problem, since this is NOT at activty-level!)
Member for
19 yearsRE: EV
Dear Mohammad
Sorry that i did not understand your problem but it is also little your fault that you did not clear in your query that you need these entire figure by time period.
This is easier than previous may be if I am not wrong.
In p3 which ACWP we get is basically BCWP not ACWP, why because the figure calculate simply
%age comp * budgeted cost= Budgeted cost work performed.
Actual cost for a certain period always come from the account department after the proper booking of each cost in it proper cost head. Normally each month this report will issue to cost department for verification and further usage. (this is my understanding and general practice)
No we come to the solution.
1- You create the same cost loading report from your target / base schedule (Period wise) for BCWS
2- Same create another report from your update schedule (Period wise) for BCWP
3- Collect the actual cost data from concern department (Period wise) ACWP
Now you have all three figures time period wise
Use only one excel sheet and copy all three figure under time period you defined and prepared graph.
The data is ready for to develop the graph same as ctrl+F7
Hope this will work for you
Regards
Tahir
Member for
19 years 1 monthRE: EV
Andrew, i dont work with access, i wanted to have those results in Excel, however cost loading doesnt arrange results by Timpe periods.
Member for
20 years 11 monthsRE: EV
Sorry guys,
I got you wrong yesterday. So the problem isnt so easy definitely. Since they didnt include Earned Value for the cost loading report it not so easy to get BCWP spreading over timeframe. But it still can be done.
The point - you need 2 tables - same Cost Loading Reports from your current & baseline schedules. The resources, timeperiods - everything should be the same. Dont forget to include Row Totals in it. Next step is to load this 2 CSV files into Access and establish the link between tables through field RES. Last step - create Query taking 1st column Nov-06 (for instance) from Target Table (BCWS), 2nd column Nov-06 from current project (ACWP), 3rd - lil tricky - BCWP : [LB17.NOV 2006]/[LB17.TOTAL]*[LB01.TOTAL]
This is my real life projects LB01- Target, LB17 - current.
Thats it.
Andrew
Member for
19 years 1 monthRE: EV
Guys,
I will try to be more clear
I want to have on a spreadsheet a table in which i will have columns of time Periods (July 07, August 07...) and each columns of these is divided to 3 columns (BCWS, BCWP, ACWP).
I want to have the same graph of cost profile which u get by pressing "Ctrl+F7" in P3 but on excel, the only difference is in each time period i will have 3 columns for the 3 values of BCWS, BCWP, ACWP.
Andrews Report shows BC or AC for completed activities, and it doesnt give you the chance to include BCWS, ACWP, BCWP in the outputs, while Tahirs method will not give you the values by Time periods, it will do it for activity by activity.
Therefore "Cost loading Report" and Export will not be a lot of help here.
Member for
19 yearsRE: EV
Dear Andrew
You did not under stand the question.
He is asking for all three values where as from current schedule we can get on ACWP & BCWP but BCWS is only get from the target or base line schedule. I also have this problem last month and how i solved it may be it is use full for others
1- First i create on custom data item such bcsc
2- Then run global change for bcsc=bcws ( keep in mind you already define your target first)
Now the bcws is in one column
3- go to export utility and create new report
4- Adding in the description
Earned value
Actual Cost
custom data item
5- run this report
You will find the all three values for you all activities up to data dates.
Hope if some one have another shortcut please share the knowledge
Regards
Tahir
Member for
20 years 11 monthsRE: EV
Easily
Tools-->Tabular Reports-->Cost-->Loading...
In Format Tab select [x] Export report in CSV format to the file...
Open this CSV file in Excel.
Sometimes - it depends on Regional Settings of your OS - you cant open CSV file properly - if the List separator differs from ",". Workaround is Find/Replace "," in CSV file to your system List separator symbol.
Andrew