EMI Calculators

EMI and Amortization calculator tools
Apna Investment site
HDFC Bank Calculator
Yahoo Finance
Bank Bazaar site ***

MS Project - MVP FAQs

MS Project MVP FAQs

Is the project is completely baselined?

You know that the project is baselined, but not sure whether it baselined it complete or not. In such case, how do we know whether it is complete or partial.

Use the following formula for flag field:
1. IIf([Baseline Start]=ProjDateValue("NA"),No,Yes)
2. Set the summary rollup option to 'AND'

If rolledup value is 'Yes' for the root task then it is completely baseline otherwise it is partially baselined.

Calculating days required for an ongoing task

Eg: For a 4 day task, 50% should be completed on day2. if it takes 3 days to complete 50%, then it takes 3 days to complete the remaining work assuming the pace of work is same.
Then apply the following formula for projection calculation:
Projection (Days Required) = IIf([Physical % Complete]>0 And [Physical % Complete]<100,((100-[physical>

Calculating Schedule Deviation in MPP

Schedule Deviation = (Finish-Baseline Finish) / (Baseline Finish-Baseline Start + 1)
Create 3 custom number fields.
Numerator : Number1 Field = ProjDateDiff([Baseline Finish],[Finish])/[Minutes Per Day]
Denominator : Number2 Field = ProjDateDiff([Baseline Start],[Baseline Finish])/[Minutes Per Day]+1
Schedule Deviation ( N/D*100 ): Number3 Field = IIf([Number2]<>0,[Number1]/[Number2]*100,0)

Planned percent complete calculation in MPP

Create a Text field. Apply the following formula to calculate Planned % Complete:
str(IIf([Status Date]<[Start],"0",IIf([Status Date]>[Finish],"1",ProjDateDiff([Start],[Status Date])/[Duration]))*100)+"%"
Note: Above formula may not work properly at summary task level.

MS Project Discussion Group

MS Project Discussion Group:

Planned percent complete vs percent complete in MS Project

Following URLs are the few pointers on this topic
1. http://www.msprojectblog.com/References/Celeris%20What%20Percent%20Complete%20Shoud%20I%20be.pdf

2. http://www.gantthead.com/discussions/discussionsTopicContainer.cfm?ID=5850

3. http://www.microsoft.com/office/community/en-us/default.mspx?query=planned+percent+complete&dg=microsoft.public.project&cat=en-us-microsoftproject&lang=en&cr=US&pt=a1d023a3-f612-4da2-acb8-fda8f850d645&catlist=&dglist=&ptlist=&exp=&sloc=en-us (% complete for a summary bar)

Task is baselined or not - its roll up

Step1: Try creating a flag field with the following formula: IIf([Baseline Start]=ProjDateValue("NA"),No,Yes)

Step2: Set the summary rollup option to "Or"