Answer Posted / sridhar
The purpose of SV is to know whether the delivery is done on time or not. If not, what is the variance.
PED- Planned END Date
PSD- Planned START Date
ASD- Actual START Date
AED- Actual END Date
Formula:
=IF(OR(ASD="",AED=""),"",IF(AED=PED,0%,IF(AED>PED,((NETWORKDAYS(ASD,AED)-NETWORKDAYS(PSD,PED))/NETWORKDAYS(PSD,PED))%,0%)))
| Is This Answer Correct ? | 0 Yes | 0 No |
Post New Answer View All Answers
How we allocate the priority(Blocker, Critical, etc.,) in Testing?
Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?
Define performance and stress testing?
Can you explain tailoring?
how to test a store procedure?
What are the Important test scenarios which can be used for testing a web site?
What processes/methodologies are you familiar with?
What is black box testing, and what are the various techniques?
Can any1 tell me suppose u r doing manual testing on unix platform with Shell Script, then how it is done? How u r implementing it & what is the use of Shell scripting on Manual Testing? plzzzzzzz i need ur help.
How to do Pixel Size testing in a PDF document. Is there any Open tool that will be avaiable?
How should validation activities be handled?
What are the main key components in web applications?
How does a coverage tool work?
Hi Friends, Can anubody give me brief overview of Automation tools.. (basics of tools-summary)of following tools? 1.Qualty Center 2.Load Runner 3.Win Runner 4.Q.T.P mail me on ...rachna.huda@gmail.com
What is the difference between manual testing and automation testing?