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 can software qa processes be implemented without stifling productivity?
date format and we should 8 digits - not accepted only /accepted write how many in test cases in the date format valid , and in valid
what are the testing appraoch that you have tested for Bread toaster
define risk management system with example ?
What is black box testing, and what are the various techniques?
What is a top-down and bottom-up approach in testing?
how to explain banking domain project in testing?
How to explain a banking project in interview ? like project discription is Client Online Banking Application provides access to information relating to Banking Online Services provided by Axis to View daily customer transactions, Current and Previous customer statements, Transfer funds from Chequing and Savings accounts ................ From interview point of view can any one explain this project in laymans language
Different types of design diagrams that supports to write test cases ?
What are differences between Testing in Uncontrolled Environment and Abnormal Environment?
What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?
1.For a single module how many builds are possible 2.what will be the max or min time to finish up an single module
Explain the importance of agile testing?
When we are recording in WinRunner and interact with the AUT, what does WinRunner do?
HI, This question is Investment Banking domain related Question. I was asked in an Interview to tell the 5 test cases for Equity,Bond,Futures and options. Please help.. Pragya