Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

what is schedule variance and give the formula

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


Please Help Members By Posting Answers For Below Questions

How can software qa processes be implemented without stifling productivity?

1225


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

1542


what are the testing appraoch that you have tested for Bread toaster

2417


define risk management system with example ?

2011


What is black box testing, and what are the various techniques?

1246


What is a top-down and bottom-up approach in testing?

1272


how to explain banking domain project in testing?

10985


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

10713


Different types of design diagrams that supports to write test cases ?

2393


What are differences between Testing in Uncontrolled Environment and Abnormal Environment?

2934


What is difference between Bug resolution meeting & Bug Review Committee? Who are participants?

3007


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

2108


Explain the importance of agile testing?

1199


When we are recording in WinRunner and interact with the AUT, what does WinRunner do?

2082


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

4591