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 application programming interface (api)?
Why we have to do manual testing?
Write the function test case to add a customer to database.
How does compatibility testing differ while testing in Internet explorer and testing in Firefox?
1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?
What is client server application testing?
What are the main key components in client and server applications?
What about the test case if the field only takes a certain number of characters or a minimum number?
I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?
What is srs and brs document?
What is Pre UAT and UAT is there any difference ?
tell wat u did in ur banking project?
Hi friends, currently i am working with banking domain project in the part of testing..what kind of questions will be ask at interviews.. can anybody listout the project oriented questions which are asked in interviews...
What are the Major Functionality for a ATM machine ??
What are different types of verifications?