Forum Discussion
Update Daily progress from excel into MS project
Dear All,
I am new to MS project and would you kindly help me please with my question:
There is task (actually lots of tasks, but for simplicity i will consider 1 task) that started at some time in the past and gradually was progressing on a daily basis.
So there are daily progress report excel files listing each day how many % was completed.
How can it be loaded automatically into MS Project showing progress of each day / cumulative daily progress to have a curve - visually to see how slow or fast is it progressing and to compare with baseline curve / graph...
Thank you so much ...
P.S. I am almost near zero in MS project..... looking forward to see you replies
Antares,
Robhprojility gave a good rundown on what is available in Project to view the data. However, your question asks how to get existing progress data from Excel to Project, so let me address that.
You can of course manually copy each day's data from Excel to the timescale grid on either the Task Usage or Resource Usage view but that process is tedious and can be prone to entry error.
If you don't need input logged on a daily basis in Project and can live with a cumulative update, then you can set up an import map to automatically update data from Excel to Project.
However, if you need/want to track daily data from Excel to Project, then the best option is with a VBA macro.
Hope this helps.
John
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!
