How can I import the monthly budget profile for activities? The budget monthly spend comes in excel from the subcontractor for each activity (500). I need to import it as it takes too long to manually change it. Is there a way to do this?
@@SoftEdemy Excellent! Thank you for such a prompt reply. I have just watched the video. This is a really excellent new capability for planners that are working at client level and are not generating budgets from within P6, but need to add them to their schedule. It would be good to do a video just on this new capability.
Sir you told in the video that if you want to calculate bugeted video for example if we have 100 cm concrete then you have to calulate Budget unit = Boq Value /Productivity rate. Will you please tell me what is productivity rate Thanks.your videos are awsome
thank you sir for this awesome explanation it has worked for me, but in case we have an activity with two resources with different budgeted unit ( EX : activity duration 2 days - Project manager 6h/day and labor 8h/day ) how could we do that in excel, or we have to do it manually in P6
Sorry for the late response.Can you tell me which steps did you follow to resolve the issues and also can you tell me when this error appeared? It may be possible you have created the resource that you have assigned. or you have incorporated the wrong resource iD in the column. If you are facing still the same issue you can contact me at my Whatsapp wa.link/36dp7i
if you are importing a project which already exist with same Project ID and name.than during import it ask that do you want to update existing project.In that case if you have selected update existing project than it will be shown only the match project.if you select create new project than their will be new project added in the eps.but projects will be not shown.Because the excel file you are importing have specific data source.Which is related to specific project and it only integrated to that project. Excel import cannot to be done to different project.thats why only the project relevant to the excel data will be displayed and can be changed .I hope you got the answer.
Sir, How to edit the Resource Assignment area. I want to change the manpower. For example Activity 1 - 3 months duration. Month 1 - 6 painter, Month 2 - 8 painter, Month 3 - 8 painter I need to edit this much. But in primavera automatically it is changed for example M 1 - 4 days, M 2 - 6 days, M 3 - 7 days like this
@mahesht4162 go to resource assignment. On right side their is spreadsheet. Right to change spreadsheet columns to budgeted units and also intervals as spreadsheet intervals in same options
@toppakistan6129 already mentioned. The video is related to resource allocation using excel. It's not about how to create resource loading sheet. Their are other videos that explain how to create a resource loading sheet. Also please listen clearly what has been explained in the topic title. All the video's are strict to their title names.
Thanks Dastak .its may me one word for you. But this word releases our hard work stress and motivate us to work harder for all our viewer. The most important is our viewer's feedback. You have taken the responsibility for feedback. thanks for your comments
The best tutorial I've ever seen
Thanks
Thanks for your valuable information 👍
Thanks Akhtar bahi
How can I import the monthly budget profile for activities? The budget monthly spend comes in excel from the subcontractor for each activity (500). I need to import it as it takes too long to manually change it. Is there a way to do this?
Use P6 23.12 , copy and paste direct resource assignments.
Watch our video on P6 23.12 new features. I have explained how to do it.
@@SoftEdemy Excellent! Thank you for such a prompt reply. I have just watched the video. This is a really excellent new capability for planners that are working at client level and are not generating budgets from within P6, but need to add them to their schedule. It would be good to do a video just on this new capability.
@davidgray5764 currently very busy. I will create video on this later.
But you can understand how to use it from video.
Sir you told in the video that if you want to calculate bugeted video for example if we have 100 cm concrete then you have to calulate Budget unit = Boq Value /Productivity rate. Will you please tell me what is productivity rate Thanks.your videos are awsome
Get productivity rates from the company or get it as per your experience. You can download productivity from Google.
Sir thanks for the answer but actually i mean what is productivity rate is there any defination of productivity rate?
One more thing Sir i am waiting for your new videos. It has been 2 months gone you have not uploaded new video. Thanka
@@ahsanrana3804 the amount of you done in unit Time
Thanks for reply Sir
can you share the excel sheet which you imported into the P6
@hannanmohsin3303 it's an old video. The file may be deleted
@@SoftEdemy i want to upload boq from excel like you did
tell me how can I do it?
@@hannanmohsin3303 share the details at our contact
@@SoftEdemy you mean at your email address?
@@hannanmohsin3303 whatsapp email any
My brother thanks for the above video can you share the project file for practice
Send Request Email on Softedemy@gmail.com also mention the video link with name.Thanks
thank you sir for this awesome explanation it has worked for me, but in case we have an activity with two resources with different budgeted unit ( EX : activity duration 2 days - Project manager 6h/day and labor 8h/day ) how could we do that in excel, or we have to do it manually in P6
No you can do it on excel. Just add duplicate the activity with different resource name
@@SoftEdemy thank you sir
@@youssefj7396 welcome
I followed your steps, however it failed to import. It shows "foreign key not identified" . What will be the possible reasons .
TIA
Sorry for the late response.Can you tell me which steps did you follow to resolve the issues and also can you tell me when this error appeared? It may be possible you have created the resource that you have assigned. or you have incorporated the wrong resource iD in the column. If you are facing still the same issue you can contact me at my Whatsapp wa.link/36dp7i
👌👍👍
Thanks for your Comment
For any query contact us on our email : info@softedemy.com
Hello,Why during importing, the list of project is not displayed in « selected project »?
if you are importing a project which already exist with same Project ID and name.than during import it ask that do you want to update existing project.In that case if you have selected update existing project than it will be shown only the match project.if you select create new project than their will be new project added in the eps.but projects will be not shown.Because the excel file you are importing have specific data source.Which is related to specific project and it only integrated to that project. Excel import cannot to be done to different project.thats why only the project relevant to the excel data will be displayed and can be changed .I hope you got the answer.
How do you prepare the excel sheet in colors ?
Please check below link video
th-cam.com/video/uBhP_2jKTJE/w-d-xo.htmlsi=wYxt7NP1OxembbyP
I have done the same steps but while I'm importing from excel my first resource for every activity is not imported
I dont know why
@paventhanm1475 without looking the sheet you export .I couldn't conclude the reason
@SoftEdemy How can I share that excel sheet with you
Share your Mail Id
@paventhanm1475 check what'sapp above in description of video
Sir, How to edit the Resource Assignment area. I want to change the manpower. For example Activity 1 - 3 months duration. Month 1 - 6 painter, Month 2 - 8 painter, Month 3 - 8 painter I need to edit this much.
But in primavera automatically it is changed for example M 1 - 4 days, M 2 - 6 days, M 3 - 7 days like this
Change spreadsheet into budget units and remove any intervals.
Than you can edit by double click in a cell.
Sir actually I am a beginner, can you explain one more time. Which spread sheet and how to remove intervals. Please sir
@mahesht4162 go to resource assignment. On right side their is spreadsheet. Right to change spreadsheet columns to budgeted units and also intervals as spreadsheet intervals in same options
@@SoftEdemy I changed budgeted units
It is in month intervals
thanks bro . could you plz share these materials
Send Request Email on Softedemy@gmail.com also mention the video link with name.Thanks
How did you create Resource Assignment Excel Template?
From productivity rates and BOQ check other videos at our channel
Thank you
Kindly mention columns header in excel.
Regards
@toppakistan6129 already mentioned.
The video is related to resource allocation using excel.
It's not about how to create resource loading sheet.
Their are other videos that explain how to create a resource loading sheet.
Also please listen clearly what has been explained in the topic title.
All the video's are strict to their title names.
Good
Thanks Dastak .its may me one word for you. But this word releases our hard work stress and motivate us to work harder for all our viewer. The most important is our viewer's feedback. You have taken the responsibility for feedback. thanks for your comments
@@SoftEdemy really I appreciate your efforts. I am waqas.
Ok sir
Sure