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 / sridhar

The purpose of SV is to know whether the delivery is done on time or not. If not, what is the variance.

PED- Planned END Date
PSD- Planned START Date
ASD- Actual START Date
AED- Actual END Date

Formula:
=IF(OR(ASD="",AED=""),"",IF(AED=PED,0%,IF(AED>PED,((NETWORKDAYS(ASD,AED)-NETWORKDAYS(PSD,PED))/NETWORKDAYS(PSD,PED))%,0%)))

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

what is the diff. bw separate database testers and manual testers with sql knowledge guys... iam confusing so much ,,in cmpny database testers are not working on manual..? both positions are same are not? explian clesly with example? thank u

2166


What are the qualities needed by a software tester?

1107


What is the difference between stlc and sdlc?

1044


According to RBI rule how much money can be transferred through online banking at one time...?

2863


which domain is of high demand for software testing, Right now i am working in Education domain .How about demand for Education domain and which companies are recruiting in education domain

3620


Describe a past experience with implementing a test harness in the development of software.

3947


Can you explain decision tables?

1086


What are the cases why parameterization is necessary when load testing the Web server and the database server?

2172


plz tell me the difference b/w PB/MF based appl.with examples. Thanks

2174


What do you mean by Cause Effect Graphing? in which standard its mentioned?

2110


1.Tell me negative test cases for notepad 2.Tell me the factors for for writing severity based test cases

6313


Test cases for Internal IP Messenger

4795


What is localization testing (l10n testing)?

1226


What r the functional testing u perform?

2139


Explain crud testing.

1111