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
How could we start writing testcases without having the FRS,BRS Docs? My Project has some docs that are related to explain the operations which will be done in the application. It is deployed in UAT server and is a maintainance project. Tell me some technipues or best way to provide the quality to application?
How many types of api testing are there?
Which are the different tests for apparel testing?
Hi friends Does anyone have screen shot of POWERMHS and please can anyone post anything which will be helpful to understand POWERMHS. thanks.
What is the negative testing and example
When we are recording in WinRunner and interact with the AUT, what does WinRunner do?
Can anybody write the test cases for the following scenario. I want to create District. for that, District Code field, District Name field, Reset button, Submit button, Back button are there in the screen. whenever we enter District Code & District Name in the related fields, by clicking on Submit button, District should be created. By clicking on Reset button, all fieds should be cleared. By clicking on Back button, user should navigate to home page. Can you write the test cases for the scenario. I want to know the test case format for the scenario. what procedure is the best. tahnks in advance...
Can Anbody please send me Daily Work status format in which I can save my daily work activity
What types of software testing are available?
Can you explain the pdca cycle and where testing fits in?
when database testing comes into manual tesing
I have 2 years of exp. in testing and looking for a change if any body knows, about any vacancy in testing then plz contact me on deepti_ac@yahoo.co.in
Can any one give a summary of testing a territory management system? what would be the test scenarios, few test cases. how it works.
I HAVE AN INTERVIEW IN A SOFTWARE COMPANY FOR THE POST OF FUNCTIONAL TEST ENGINEER. THEY WANT THE PERSON FROM BCOM BACK GROUND( I AM A BCOME GRADUATE 2006) AND THE PERSON SHOULD HAVE GOOD ACCOUNTS KNOWLEDGE. NOW I WANT TO KNOW WHAT KINDS OF QUESTIONS THEY CAN ASK OR CAN GIVE IN WRITTEN TEST. I M NERVOUS COZ ITS BEEN 5 YEARS I HAVE DONE BCOM. SO HOW SHUD I PREPARE FOR INTERVIEW.PLEASE HELP? reply me pls. its urgent. thanks
I have an Interview about Guidewire claimcenter,so could you provide any info regd it?.I would really appreciate any kind of help- email at hvshah2001@gmail.com