Thats an interesting application - but seems to be only available for the Russian market? Is there any infromation availabel in English - other than a website auto-translation?
The XLS import/export work as the Database tables are written, to have one line per activity with all the resoures horiztonally would not be a flat data file.
You could develop some excel forumals using INDEX and VLOOKUP formulas to achieve what you're after.
Thanks, could you guide me with an example like how the template would be in actual. I am in Oil and Gas same as you, so my current scenario for example there is a deliverable Design Basis for which all the Dicipline needs to give there input so that 1 Deliverable would have hours of Process, Mechanical, Piping, Electrical, Instrumentation, Civil. So I need to put hours of all of this dicipline into to this Delvierable as a separate resource.
I will be working on a Project in which there would be many engineering deliverable.
Member for
16 years 3 monthsassign the resources to the
assign the resources to the activities in p6 then export to excel then populate then import to p6
Member for
20 years 6 monthsKirill, Thank you, I look
Kirill,
Thank you, I look forward to seeing more about it.
Member for
9 years 7 monthsUnfortunately there are no
Unfortunately there are no materials in English for now.
We are in the process of creating a new website, the English version will be ready in a month i think.
Member for
9 years 7 monthsUnfortunately there are no
Unfortunately there are no materials in English for now.
We are in the process of creating a new website, the English version will be ready in a month i think.
Member for
20 years 6 monthsKirill, Thats an interesting
Kirill,
Thats an interesting application - but seems to be only available for the Russian market? Is there any infromation availabel in English - other than a website auto-translation?
Member for
9 years 7 monthsI think you are looking for
I think you are looking for something like this:
https://youtu.be/6_KZYCOBl-k
Member for
14 years 7 monthsHi Kannan, I stared doing
Hi Kannan,
I stared doing that. Filter it by Activity ID then populate.
Ya that is one more Idea, let me see which would be faster and better.
Regards
Jithin
Member for
20 years 6 monthsJithin,The XLS import/export
Jithin,
The XLS import/export work as the Database tables are written, to have one line per activity with all the resoures horiztonally would not be a flat data file.
You could develop some excel forumals using INDEX and VLOOKUP formulas to achieve what you're after.
Member for
17 years 4 monthsHi Jithin,I believe that
Hi Jithin,
I believe that after the exporting, you can't change the basic structure of the excel file ( top-down to horizontal).
You can filter the act-ID and populate the resource units much faster in the excel file, and then you can import it.
BR
Kannan
Member for
14 years 7 monthsHi Santosh, Ya did that and
Hi Santosh,
Ya did that and Yes it showing but in a Horizontal Way. Like if for 1 Activity if there is 10 Resource then the 10 Resource would be shown Vertically.
But before it is been exported under the Template, in the Subject Area you have to select Resource Assigment and add the related columnn
If the resource was shown Horizontally per Activty then the Resource loading would have been better.
Thanks
Regards
Member for
20 years 6 monthsJust manually populate one
Just manually populate one activity with the resources and units you want to include.
Then select FILE>EXPORT>XLS>RESOURCE ASSIGNMENTS and it will be easy to see how this is done
Then complete populating in Excel and select FILE>IMPORT>XLS and point to the same file exported above.
Member for
14 years 7 monthsHi David, Thanks, could you
Hi David,
Thanks, could you guide me with an example like how the template would be in actual. I am in Oil and Gas same as you, so my current scenario for example there is a deliverable Design Basis for which all the Dicipline needs to give there input so that 1 Deliverable would have hours of Process, Mechanical, Piping, Electrical, Instrumentation, Civil. So I need to put hours of all of this dicipline into to this Delvierable as a separate resource.
I will be working on a Project in which there would be many engineering deliverable.
So could you help me out with an example
Regards
Jithin
Member for
21 yearsJithin,Yes you can export a
Jithin,
Yes you can export a template of resource assignments, and import them with new values BUT it cannot be done in the format you want.
It must be one row in the spreadsheet, one resource assignment:
A-1000 Steelfixer 40
A-1000 Carpenter 16
A-1000 Mason 16
etc.