note:<\/strong><\/span> ensure the layout is modified to include the following columns:<\/p>\n<\/p>\n
you can create a new filter to export only the activities that are either in progress or not yet started.<\/p>\n
<\/p>\n
upon successful export, your spreadsheet file should appear as follows:<\/p>\n
<\/p>\n
including these columns is essential to ensure the updates are correctly captured in the exported spreadsheet and can be successfully imported back into primavera p6.<\/p>\n
step 3:<\/strong> next, use the vlookup formula to transfer data from the initial template, where updates from various departments were collected, to the exported excel sheet.<\/p>\nyour vlookup formula should be structured as follows:<\/p>\n
<\/p>\n
note:<\/strong> <\/span>using the activity id, you can easily transfer data from the update sheet to the import sheet. once you have used vlookup to pull the data, ensure you copy all the data and paste it as values to remove the formulas from the import sheet.<\/p>\nstep 4: <\/strong>properly formatting the data<\/p>\nproper formatting is crucial for successful data import. use the following formats for these columns:<\/p>\n
\n\n\ncolumns<\/strong><\/td>\nformat<\/strong><\/td>\n<\/tr>\n\nactivity start & finish<\/td>\n | yyyy-mm-dd hh:mm (2017-01-05\u00a0 7:30:00 am)<\/td>\n<\/tr>\n | \nactivity % complete<\/td>\n | text<\/td>\n<\/tr>\n | \nremaining duration<\/td>\n | text<\/td>\n<\/tr>\n | \nactivity status<\/td>\n | text<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n <\/p>\n note:<\/strong><\/span> you can use the baseline start and baseline finish columns to replicate the format for the actual start and actual finish columns. additionally, you can copy the time from the baseline start and finish columns into the actual start and finish columns.<\/p>\n\n- activity % complete: this should be in text format, with 100% written as 100 (without the % sign).<\/li>\n
- activity status: this should be in text format.<\/li>\n
- remaining duration: this should also be in text format.<\/li>\n<\/ul>\n
<\/a><\/span> | | |