Great stuff! Is there some database out there that provides standard costs for different jobs and different countries, or do you usually have to ask the costing experts in your business to give you those? Also, if you have an IT project, what if you have some people on your project who are in your business, therefore you can track costs, but you have outsourced the actual work to a vendor at a fixed-rate contract?
i have aproject with 4 elements each one with 25 hrs , if i finished the 1st one & 2nd & 87.5% from the third & 4.44% from the 4th ....pls what is the overall Work % Complete with decimal ... how can i use the ms project to know the answer ???
@MrBabylonlion Try this: Add a column and choose "Number1" for the field name. Left-click on the column, choose "Customize Fields", rename it "% Work Complete with 2 Decimals", select "Rollup" for "Calculation for task and group summary rows", choose "Average" for rollup, then click OK. You then can enter your % for each task with 2 decimals. Note this will not fill the % complete field to complete tasks.
Really? You want to show a task is 4.44% done? Hmpf. ;-)
In the example didn't show how one would determine how only 3 days of work was accomplished in 5 days. Meaning, on that 5th day, how would you know only 3 days of work was accomplished? By asking the developer what his % complete was. Which is a problem with EVM, how do you know what the true % complete is?
Also, didn't explain the example of, if on that 5th day, only 3 days of work had been accomplished, but developer was still paid for 5 days, how one would account for that.
I certainly agree with the percent complete dilemma. I NEVER ask the developer for his % complete. Instead I ask how many hours of work remain until completion. I then use this along with the baselined estimate to (re)calculate % complete. This problem is universal - not just peculiar to EVM.
Right - If the developer is paid for only the 3 days of work, then the actual cost coincides with the EV so CPI and CV are are not useful; SPI and SV are the key values. However, if the developer is paid for all 5 days, but only accomplishes work estimated to take 3 days, then there is a CV. We've paid for work not done. Actual cost is now higher that earned value. I plug in the cost of 5 days in the Actual Cost column for the 3 days' work. This discrepancy is then reflected in the CPI and CV.
Cool tutorial. Where does that intro song come from?
GameZoneRecreation 8 months ago
@GameZoneRecreation The song is from a saxophonist named Jeff Kashiwa.
powerpointchef 6 months ago
100%
ferdielopez1 11 months ago
Great stuff! Is there some database out there that provides standard costs for different jobs and different countries, or do you usually have to ask the costing experts in your business to give you those? Also, if you have an IT project, what if you have some people on your project who are in your business, therefore you can track costs, but you have outsourced the actual work to a vendor at a fixed-rate contract?
MrTwinsdad08 1 year ago
i have aproject with 4 elements each one with 25 hrs , if i finished the 1st one & 2nd & 87.5% from the third & 4.44% from the 4th ....pls what is the overall Work % Complete with decimal ... how can i use the ms project to know the answer ???
MrBabylonlion 10 months ago
@MrBabylonlion Try this: Add a column and choose "Number1" for the field name. Left-click on the column, choose "Customize Fields", rename it "% Work Complete with 2 Decimals", select "Rollup" for "Calculation for task and group summary rows", choose "Average" for rollup, then click OK. You then can enter your % for each task with 2 decimals. Note this will not fill the % complete field to complete tasks.
Really? You want to show a task is 4.44% done? Hmpf. ;-)
MrTwinsdad08 10 months ago
This has been flagged as spam show
Thank you very much. It was too fast for me as i am a beginner but i truly enjoyed it and learned it. Thank you very much for your time.
sbeshai 1 year ago
Thank you very much. It was too fast for me as i am a beginner but i truly enjoyed it and learned it. Thank you very much for your time.
sbeshai 1 year ago
Crisp and clear!
swoud 1 year ago
In the example didn't show how one would determine how only 3 days of work was accomplished in 5 days. Meaning, on that 5th day, how would you know only 3 days of work was accomplished? By asking the developer what his % complete was. Which is a problem with EVM, how do you know what the true % complete is?
Also, didn't explain the example of, if on that 5th day, only 3 days of work had been accomplished, but developer was still paid for 5 days, how one would account for that.
callmevegas 2 years ago
I certainly agree with the percent complete dilemma. I NEVER ask the developer for his % complete. Instead I ask how many hours of work remain until completion. I then use this along with the baselined estimate to (re)calculate % complete. This problem is universal - not just peculiar to EVM.
powerpointchef 1 year ago
Right - If the developer is paid for only the 3 days of work, then the actual cost coincides with the EV so CPI and CV are are not useful; SPI and SV are the key values. However, if the developer is paid for all 5 days, but only accomplishes work estimated to take 3 days, then there is a CV. We've paid for work not done. Actual cost is now higher that earned value. I plug in the cost of 5 days in the Actual Cost column for the 3 days' work. This discrepancy is then reflected in the CPI and CV.
powerpointchef 1 year ago
thanks man, you saved me
batmanforemka 2 years ago
Great video... thanks for posting these excellent videos.
dksharma77 2 years ago