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

Our software designers use UML for modeling applications. Based on their use cases, we would like to plan a test strategy. Do you agree with this approach or would this mean more effort for the testers.

2101


What is performance tuning? What are tools of performance testing?

1120


What are the advantages of automation over manual testing?

1131


Testcases for msword( microsoct office word??

2124


What is system level testing?

1098


Please is there any one working with ITR.COM? Having interview with them. Any tips will help.

1800


Write test cases on duster

4913


what is fusion testing and impact analysis???

2257


Write positive and negative test cases for forgot password?

4830


Hi, I was asked following question during a interview. Please answer it: Password field is there,we can accepts every character except underscore and semicolon. It can accept min 6 characters and maximum 12 characters. Prepare boundary value and equivalence class test cases.

8251


what is date field test case

1924


Why do we need different environments and different data? What is the other name for environment? Justify your explanation ? real time experts pls xplain?

2780


Do you know anything about Set Top Boxes?

9692


Can you explain the various elements of function points ftr, ilf, eif, ei, eo, eq, and gsc?

1322


hi... guys can any one pls help me out.... I m civil engg graduate i want to come into s/w field... i have decided to do manual testing course. i know its not sufficient.. which r the other coures shall i do with this.. suggest me good atomation tool and SAP courses... thanks in advance.. i wil be thankfull to u all

2182