LinkBack URL
About LinkBacks
Dear All,
I have a requirement to find the variances in percentage, between the planned and actual date.
Can someone help.
Gem
Formula to find Variances between Planned & Actual Dates
Dear All,
I have a requirement to find the variances in percentage, between the planned and actual date.
Can someone help.
Gem
Possibly ... Would you care to share a bit more detail?
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Attaching the sample sheet...
Last edited by AliGW; 08-22-2017 at 05:41 AM. Reason: Unnecessary quotation removed.
Not much use without your expected outcomes! Please manually fill in the variance % column and re-post the workbook.
See below - please provide the missing data manually.
Excel 2016 (Windows) 32 bit
Ticket # Variance Variance in % A83733 <<<< result? A81209 <<<< result? A83701 <<<< result? A82300 <<<< result?
Sheet: Sheet1
Still waiting for the extra data requested ...
if the planned date and target date are same then it is 100% met. If actual date is not met by planned date then what is the difference in %.
Last edited by AliGW; 08-22-2017 at 08:10 AM. Reason: Unnecessary quotation removed.
Please provide the ANSWERS you want in the sample data for cells F3 to F6. Work them out yourself so that I can work out a formula for your file.
In other words, what do you expect to see as a result of a formula in these cells (exact percentage, please):
F3 =
F4 =
F5 =
F6 =
Fill in the missing data.
Attached the revised file with expected results...
Last edited by AliGW; 08-22-2017 at 08:21 AM. Reason: Unnecessary quotation removed.
Although I really don't understand your use of the word variance, this formula gives the expected results.
F3 =1-E3/100
At last! It has taken three hours for you to finally produce what I needed to help you!!!!! In future, PLEASE answer questions fully to avoid wasting time.
Try this in F3 copied down:
=(100-E3)/100
formatted as a percentage.
Thank you so much...
You're welcome!
If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
Gem, how the variance in % is calculated does not make sense for projects with different durations.
Imagine a project took 10 days to complete but is 5 days late... and another took 100 days but is also 5 days late.... both will have the same variance in % based on your calculation.
[QUOTE=
Imagine a project took 10 days to complete but is 5 days late... and another took 100 days but is also 5 days late.... both will have the same variance in % based on your calculation.[/QUOTE]
So what do you expect as result.. ??
If I helped, Don't forget to add reputation (click on the little star ★ at bottom of this post)
Don't forget to mark threads as "Solved" (Thread Tools->Mark thread as Solved)
Difference in days between planned and actual completion dates, divided by planned duration in days.
Hi All,
I want to know if I can have a combined formula that can compute the difference in the number of Actual and Planned Start Dates to the Actual and Planned Finished dates as a whole to give the output in the variance days column.
At the moment I have calculated the number of days required based on the actual and planned start dates. Please if you can help me with developing the formula as requested showing a whole day where the difference between the start and finish days is actual and planned.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks