How to Extract Progress Percentages from Microsoft Project 2019 for an S-Curve?
Hello, everyone.
I have a schedule saved in Microsoft Project 2019 with the baseline set. I’m creating an S-curve in Excel that compares the planned progress percentage with the actual progress, as seen in the image. To simulate the percentages along the dates on the X-axis of the S-curve, I save the baseline in Microsoft Project and then manually update the status date to transfer the planned percentage for each date into Excel. The problem is that this process is… manual.
My question is: is there a way to extract a report from Microsoft Project that shows the progress percentages throughout the project? For example, if a project starts on August 10 and ends on August 15, the report needs to show something like this:
August 10: 0%
August 11: 16%
August 12: 42%
August 13: 65%
August 14: 88%
August 15: 100%
Hello, everyone. I have a schedule saved in Microsoft Project 2019 with the baseline set. I’m creating an S-curve in Excel that compares the planned progress percentage with the actual progress, as seen in the image. To simulate the percentages along the dates on the X-axis of the S-curve, I save the baseline in Microsoft Project and then manually update the status date to transfer the planned percentage for each date into Excel. The problem is that this process is… manual. My question is: is there a way to extract a report from Microsoft Project that shows the progress percentages throughout the project? For example, if a project starts on August 10 and ends on August 15, the report needs to show something like this: August 10: 0%August 11: 16%August 12: 42%August 13: 65%August 14: 88%August 15: 100% Read More