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

what is fusion testing and impact analysis???

2259


aplitue questions will be based on wich type ?

2478


ive been looking for a junior tester job for quite some time now, but most company keep requisting for experienced staffs, but if i dont start from somewhere how do i get the experience

1873


Usually customers won’t give all the requirements. How will you manage & collect all the necessary information?

1165


what is a horizontal and vertical matrix explain with examples

2590


Write down ten test cases for below scenario: Increase the day by 1 and date format should be mm/dd/yyyy Conditions are : date should not be greater then 31 and date<1 month should not be greater then 12 and month<1 year should not be greater then 10000 and year<1 Thanks in advance

2224


What is defect validity ratio?

7291


How do you scope out the size of the testing effort?

2299


a newly launched web site is hosted on web server.It is expected that 100 people visit the website every hour and browse 30 pages spending a total 15 minutes. what is the maximum hits/sec that the web server should support this load?justify your answer. need urgently. by rimesh

1861


What is build interval period?

2305


Hi Everybody could you please send me the ISTQB Material to my mail id karthik18487@gmail.com Thanking you in advance

1979


What are the cases when you’ll consider to choose automated testing over manual testing?

1088


how will we change the server system time?

2239


How we allocate the priority(Blocker, Critical, etc.,) in Testing?

1794


Write the test cases for yahoo home page

2227