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 fusion testing and impact analysis???
aplitue questions will be based on wich type ?
ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience
Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?
what is a horizontal and vertical matrix explain with examples
Write down ten test cases for below scenario: Increase the day by 1 and date format should be mm/dd/yyyy Conditions are : date should not be greater then 31 and date<1 month should not be greater then 12 and month<1 year should not be greater then 10000 and year<1 Thanks in advance
What is defect validity ratio?
How do you scope out the size of the testing effort?
a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh
What is build interval period?
Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance
What are the cases when you’ll consider to choose automated testing over manual testing?
how will we change the server system time?
How we allocate the priority(Blocker, Critical, etc.,) in Testing?
Write the test cases for yahoo home page