#1
|
|||
|
|||
Project Progress - Actual vs Estimated
Hey
Probably a question asked may times... Im not looking for this by task, just a single Actual vs scheduled % value that i can deliver to my management team as this is the main question to me... so, i need to get the following values 1. the percentage through the scheduled project. If it was a 100 day project and im current 50 days in, this value would be 50% 2. the percentage of actual completed work. If it was a 100 day project, im at 50 days but have completed 65 days work, the value would (50%) 65% 3. the percentage ahead of actual completed work. If it was a 100 day project, im 65%, 15% over the schedule, the value would be 15% ahead I can do a report, i'd like to know if
Thanks |
#2
|
||||
|
||||
I might be wrong but I think you need to calculate Scheduled % (Baseline %) for tasks to get the overall value.
This video might help you. Also read the pinned comment as it improves the formula in the video when an error occurs. https://youtu.be/egWA82E1i1w |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Project Summary Task formula to show milestone progress | joday48 | Project | 1 | 01-21-2022 10:35 AM |
Actual hours Excel to Project | JHalter | Project | 0 | 12-06-2021 03:43 PM |
Trying to show Actual v. Estimated Progress | LVanpelt | Project | 0 | 05-03-2018 01:48 PM |
Need totoal cost despite project being in progress | Sognamed | Project | 1 | 07-23-2013 06:06 AM |
MS Project able to import actual start and or actual finish date from Excel? | mhacker | Project | 0 | 04-26-2010 11:29 AM |