Can read project data and know whom to ask to get missing information
Can create cost loading excel sheet to distribute the BOQ items to activities
Understand the excel tables. this is different than the normal table; this can be done by selecting any range of data in excel
Can create a simple Macro in excel to automate the repetitive tasks
Can create activities list from BOQ and project drawings
Understand the productivity rates and able to create excel resource loading
Able to develop WBS in a professional way. By work standard division of work
Calculate in Excel the Cost and hours for each activity.
Can import the activities along with cost and resources from excel to p6
Can develop shop drawings and materials logs in excel and import to p6
Can perform resource leveling in p6 – not the standard option but manually
Can export the schedule date from p6 and create separate reports in excel showing the required quantities for each activity over time – weekly or monthly
Can create detailed dashboard in excel to show the progress based on EVM, working hours, productivity, and other KPI’s.
Know the differences and able to develop both revised and recovery schedule
Know the concept of claims and EOT
Know how to find the claim events from project different documents such as RFI, SWI, IR, comments …etc
Know how to collect and record supporting documents for any claim
Know how to analysis the events before submitting as a claim and how to involve project team in this exercise
Know how to build a strong narrative report from the events and prepare professional EOT report
Know how to build a strong case to the claim
Know how to defend your claim case in front of the client
Understand the different methods of claims analysis techniques
Understand the main FDIC clauses and construction contracts
Understand the concept of Excel Database and how to store data
Know the differences between storing data in good or messy way
Understand the Pivot Tables and create interactive reports in Excel