summary bar % - planned vs actual
in [Project]
|
From: Nick Boot-Handford Nick on 22 Jan 2010 09:16 I need to calculate planned % complete so that I can work out the SPI as we do not monitor cost on this project. What is the formula you use for the individual bars? Nick "Andrew" wrote: > I have a formula which works out the planned % for individual bars - works > great. The problem I have is with the summary bars. My formula works in a > straight line ie 2 days out of 10 = 20%. I know that MSP uses a different > method to calculate the actual % of summary bars - I understand how it does > it, what I was hoping for is there somebody out there that could issue a > formula (via a macro) that copies that method, as at the moment the two do > not correlate. > > Thanks in anticipation. > > Andrew
From: "Steve House" sjhouse at hotmail dot on 22 Jan 2010 18:54 If you do not monitor costs, set all resource standard and overtime rates to $1. Set the currency format to have no dollar sign. Now you can use the built-in conventional earned value tools, including SPI, but with them based on man-hours instead of dollars. "Planned % Complete" doesn't really tell you much. -- Steve House MS Project Trainer & Consultant "Nick Boot-Handford" <Nick Boot-Handford(a)discussions.microsoft.com> wrote in message news:76F031A7-5646-47D4-B191-BA2FB82865B3(a)microsoft.com... >I need to calculate planned % complete so that I can work out the SPI as we > do not monitor cost on this project. What is the formula you use for the > individual bars? > > Nick > > "Andrew" wrote: > >> I have a formula which works out the planned % for individual bars - >> works >> great. The problem I have is with the summary bars. My formula works in a >> straight line ie 2 days out of 10 = 20%. I know that MSP uses a different >> method to calculate the actual % of summary bars - I understand how it >> does >> it, what I was hoping for is there somebody out there that could issue a >> formula (via a macro) that copies that method, as at the moment the two >> do >> not correlate. >> >> Thanks in anticipation. >> >> Andrew
From: Nick Boot-Handford Nick on 25 Jan 2010 10:01 So how do you set the resource rates? "Steve House" wrote: > If you do not monitor costs, set all resource standard and overtime rates to > $1. Set the currency format to have no dollar sign. Now you can use the > built-in conventional earned value tools, including SPI, but with them based > on man-hours instead of dollars. "Planned % Complete" doesn't really tell > you much. > -- > Steve House > MS Project Trainer & Consultant > > > > "Nick Boot-Handford" <Nick Boot-Handford(a)discussions.microsoft.com> wrote in > message news:76F031A7-5646-47D4-B191-BA2FB82865B3(a)microsoft.com... > >I need to calculate planned % complete so that I can work out the SPI as we > > do not monitor cost on this project. What is the formula you use for the > > individual bars? > > > > Nick > > > > "Andrew" wrote: > > > >> I have a formula which works out the planned % for individual bars - > >> works > >> great. The problem I have is with the summary bars. My formula works in a > >> straight line ie 2 days out of 10 = 20%. I know that MSP uses a different > >> method to calculate the actual % of summary bars - I understand how it > >> does > >> it, what I was hoping for is there somebody out there that could issue a > >> formula (via a macro) that copies that method, as at the moment the two > >> do > >> not correlate. > >> > >> Thanks in anticipation. > >> > >> Andrew > > . >
From: Rob Schneider on 25 Jan 2010 10:07
In the Resource Sheet. --rms www.rmschneider.com On 25/01/10 15:01, Nick Boot-Handford wrote: > So how do you set the resource rates? > > "Steve House" wrote: > >> If you do not monitor costs, set all resource standard and overtime rates to >> $1. Set the currency format to have no dollar sign. Now you can use the >> built-in conventional earned value tools, including SPI, but with them based >> on man-hours instead of dollars. "Planned % Complete" doesn't really tell >> you much. >> -- >> Steve House >> MS Project Trainer& Consultant >> >> >> >> "Nick Boot-Handford"<Nick Boot-Handford(a)discussions.microsoft.com> wrote in >> message news:76F031A7-5646-47D4-B191-BA2FB82865B3(a)microsoft.com... >>> I need to calculate planned % complete so that I can work out the SPI as we >>> do not monitor cost on this project. What is the formula you use for the >>> individual bars? >>> >>> Nick >>> >>> "Andrew" wrote: >>> >>>> I have a formula which works out the planned % for individual bars - >>>> works >>>> great. The problem I have is with the summary bars. My formula works in a >>>> straight line ie 2 days out of 10 = 20%. I know that MSP uses a different >>>> method to calculate the actual % of summary bars - I understand how it >>>> does >>>> it, what I was hoping for is there somebody out there that could issue a >>>> formula (via a macro) that copies that method, as at the moment the two >>>> do >>>> not correlate. >>>> >>>> Thanks in anticipation. >>>> >>>> Andrew >> >> . >> |