Answer Posted / tamil
Schedule Variance.
First find out the Delay(AED(Actual END Date)-PED(Planned
END Date)). Formula for this:
=IF(Actual Finish date="",0,IF(Actual Finish Date = Planned
Finish Date,0,IF(Actual Finish Date>Planned Finish
Date,NETWORKDAYS(Actual Finish,Planned Finish)-1,NETWORKDAYS
(Actual Finish,Planned Finish))))).
And then Find out the Actual Schedule(PED(Planned End Date)-
PSD(Planned Start Date)). Formula for this:
NETWORKDAYS(Planned Finish date,Planned Start Date)
And then Finally Schedule Variance Formula Is:
IF(NOT(Actual Schedule=0),(Actual Schedule/Delay%),0)
Please check it....
| Is This Answer Correct ? | 7 Yes | 3 No |
Post New Answer View All Answers
What is data matrix? What is the use of it?
What are the benefits of creating multiple actions within any virtual user script?
Can you explain requirement traceability and its importance?
Give me an example of something you tried at work but did not work out so you had to go at things another way.
What is smoke test?
What is concurrent user hits in load testing?
How to test the below code and write test case? Prove that this code is wrong? int add(int a ,int b) {return a+b; }
what types of bugs will we find out in banking projects
What is the difference between load testing and performace testing?
Why performance testing is performed? What are tools of performance testing?
HI FRNDS, I HAVE 2.5 years OF exp In Manual Testing,Plz let me know if thr r any oppurtunities in any company in Bangalore ID:dsnithi@gmail.com Thanks in Advance
Hi everyone, My name is Salil Mishra. I am having 1.7 years of experience in manual testing. But as i m 2008 passout, there are limited position for me in the companies. Please help me out in getting a good job guys..I f you find something then please mail me at salilmishra29@gmail.com
What are microsoft 6 rules?
hi friends .......... from srs to signoff what r the tests the testing team will conduct either sequentially or parallel pls advice thanks in advance
What is Independant Testing? When and where this type of testing will be performed?