Resource Allocation from Excel to Primavera P6 | Resource assignment from Excel to Primavera P6 Tips

#Softedemy,#PrimaveraP6,#Resourceallocation

In this tutorial, let us learn to Resource Allocation from Excel to Primavera P6 | Resource assignment from Excel to Primavera P6 Tips
Previous Videos

1. Save print Settings | using Import and Export | Primavera P6 layout Files | Plf | Solutions | Tricks
2. Update Progress using Activity Steps | Create Template | Performance Percent | Primavera P6 | Tips |
3. How to Maintain an Activity Change Log | Primavera P6 | UDFs | Activity Steps | Delay log | Hacks
4. How to set Default Activity IDs numbering | Modify Activity Suffix and Prefix | Primavera P6 | Tip |

5. How To Renumber Activity IDs For All Activities In An Ascending Order In Primavera P6 | Tips

6. How to Change Activity IDs by Export and Import | Primavera P6 Simple Easy and Fast Method | Tips |

7. Primavera P6 Difference Between Activity Calendar and Resource Calendar | Change Calendar | Tips

8. What are activity types relationship and their role in Primavera P6 | Easy Complete Tutorial |

9. Import Project Expense cost in Primavera P6 from Excel file | Load Expense in Project | load Actuals

10. Export and Import Primavera P6 Project with Baseline in XML Format | Multi projects in single file |

11. Explained Difference Between XML and XER File while Importing and Exporting from Primavera P6
12. How to Convert WBS to Activity Code in Primavera P6 | Using Excel | Easy Fast Trick | Large Schedule
13. Easy Creating WBS and activities in Primavera P6 | Help of Excel and MPP | Import XML and MPX Format
14. How to Remove Actual from Updated Project in Primavera P6 | Remove Progress | Change Activity Status

15. Explain Difference between Delete and Dissolve Activity in Primavera P6

16. How To Remove Relationships From Multiple Activities In Primavera P6 | Remove Predecessor Successors

17. What are dangling logic in Project Schedules in Primavera P6 | Resolve dangling logic and Activity |

18. How to find or detect lag and dangling logic in Project Schedule of Primavera P6 by using Excel tips

19. How to build lookahead in primavera p6 | Lookahead Schedule | Layout | Plan | Filter | Tips Tricks

20. How to Highlight Activities Using Filters And Spotlight Feature In Primavera P6 | Tips and Tricks

21. How to fix Log File Can't Be Created Error in Primavera P6 during Scheduling | Problem Solution |

22. How to Change Password in Primavera P6 | Recover Password | Reset Password | Tips and Tricks | SQL

23. How to Assign or to Remove Multiple Resources From Multiple or all Activities in Primavera P6 | Tips

24. Difference Between Retained logic and Progress Override in Primavera P6 | Progress Update | schedule

25. How to Track Find Detect Out of Sequence Activities in Primavera P6 | Filter | Schedule log | Tips

26. How to Create Custom Selection of Activities by using Filter to Print in Primavera P6 | Tips Tricks

27. Print or display Highlighted Activities Gantt Chart different bars by apply Filter in Primavera P6

28. Suspend and resume activity in Primavera P6 adding delay events for Extension of Time | Tips tricks

29. Calculate and assign estimated weights from Excel to Primavera P6

30. How to fix deadlines of the project in Primavera P6 | without use constraints | Expected finish | P6

31. How to use progress line to monitor activities performance in Primavera P6| Show delays graphically

32. Explained Critical and Near Critical Activities differences in Primavera P6 | Total Float | P6

Contact Details

[akhtarali-qven]

Thanks for your valuable information 👍

[youssefj]

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

[ahsanrana]

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

[Mahrash]

My brother thanks for the above video can you share the project file for practice

[davidgray]

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?

[edpm]

I followed your steps, however it failed to import. It shows "foreign key not identified" . What will be the possible reasons .

TIA

[BaraRaed]

How do you prepare the excel sheet in colors ?

[zhangyong]

Hello, Why during importing, the list of project is not displayed in « selected project »?

[hendawyragabelashry]

thanks bro . could you plz share these materials

[mahesht]

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

[toppakistan]

How did you create Resource Assignment Excel Template?