Forum Discussion
Update Daily progress from excel into MS project
Hi, in MS Project you have available a series of 'Views' (top left corner when you open a project), which show different tables and charts of info on that project. One of those is the 'Task Usage' view, which shows you Tasks on the left, and then the right is a table showing you 'time-phased' data such as planned hours, actual hours, baseline hours.
Assuming you've built your schedule and laid out the hours appropriately, and then baselined the schedule, you can go to that view to update 'actual hours' and see these alongside planned (forecast) and baselined.
You can then go to the 'Reports' table and pick a report that shows this data (or something similar) and then in the pivotable on each report, add these three measures. There you can adjust the chart in the report just like Excel to show a cumulative curve. You could also export this data out to Excel and run reports there, or plug into a BI tool like Power BI or a visualization tool that may show prettier curves, of plan, actual and baseline.
By doing this you can compare the three and show progress over time. Of course you need to plug the data in first.
Hope this helps!