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 application programming interface (api)?

1113


Why we have to do manual testing?

1671


Write the function test case to add a customer to database.

2152


How does compatibility testing differ while testing in Internet explorer and testing in Firefox?

3262


1)can u tell me, what is the roles and responsibles for database tester in DB testing from requirement stage to UAT stage....2) what are the i/p documents he wants and who wil give the i/p docs. to DB tester.and tell me what exactly db test case means what?

2529


What is client server application testing?

2010


What are the main key components in client and server applications?

1141


What about the test case if the field only takes a certain number of characters or a minimum number?

1142


I know functional test cases are derived from frs and system design specs. But are test cases for performance, database, boundary, relational integrity and other types of tests other than functional tests created from frs and system design specs as well? When are these test cases created? Are they in the same test plans alongside functional test cases or is their a different test plan that includes these test cases?

2238


What is srs and brs document?

1143


What is Pre UAT and UAT is there any difference ?

3575


tell wat u did in ur banking project?

2286


Hi friends, currently i am working with banking domain project in the part of testing..what kind of questions will be ask at interviews.. can anybody listout the project oriented questions which are asked in interviews...

3890


What are the Major Functionality for a ATM machine ??

5954


What are different types of verifications?

1288