If you already have the team providing their timesheets in excel, you could strip out the actual dates and do an excel import into P6. You just need to make sure you have the activity ID to reference, WBS code, actual start, actual finish, % complete, and remaining duration.
Depending on the excel form that they provide, you could create some sort of an excel template where you could "dump" the excel information from the file they provide you into your own excel template to auto-format the data into an importable format.
I've messed around with P6XL bridge, but from my experience, importing from excel was just as fast if you develop a good system extracting the data into an importable format.
Member for
5 years 5 monthsHey Jordan,If you already
Hey Jordan,
If you already have the team providing their timesheets in excel, you could strip out the actual dates and do an excel import into P6. You just need to make sure you have the activity ID to reference, WBS code, actual start, actual finish, % complete, and remaining duration.
Depending on the excel form that they provide, you could create some sort of an excel template where you could "dump" the excel information from the file they provide you into your own excel template to auto-format the data into an importable format.
I've messed around with P6XL bridge, but from my experience, importing from excel was just as fast if you develop a good system extracting the data into an importable format.
I wrote an article about importing actual dates into P6 here: https://jobsessions.com/post/51069F09-83B8-5B82-6D39-69B32B578BD2
Regards,
Patrick