|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/advanced-planning-baseline-schedule-with-primavera-p6-excel/
课程评论:没有评论
课程名称:利用Primavera P6与Excel进行高级计划基线排期 概述:本课程是针对中级建设规划的真实项目案例研究,使用Oracle Primavera P6和Microsoft Excel。学员需具备基础的规划概念知识和Oracle Primavera P6软件操作能力,同时需要拥有2016或更新版本的Microsoft Office或Microsoft Office 365。课程将从一份项目工程量清单(BOQ)和一套图纸开始,具体内容包括: 1. 课程介绍 2. 阅读项目BOQ 3. 创建项目数据加载 4. 阅读图纸并将楼层添加到数据加载中 5. 活动清单和工作分解结构(WBS) 6. 成本加载 7. 资源加载 8. 将成本和资源加载到P6中 9. 估算活动持续时间 10. 活动关系 11. 施工图 12. 材料采购 13. 现金流和人力资源直方图 我们将使用智能规划技术,通过Microsoft Power Query和Oracle Primavera的导入导出功能,简化规划过程,从而提供详细的基线排期,节省数百小时的工作时间。课程包含所有项目文档以及最终的基线文档(Excel和XER文件),这些均可作为开源资源供学员修改和应用于下一个项目。课程将通过实际案例研究,讲师将打开文件并在真实项目中运用Oracle Primavera P6和Excel的高级技术进行基线排期。需要注意的是,本课程不包括项目时间进度更新、修订/复原进度安排,也不涉及工期延长(EOT)及索赔。
Real project case study course for an intermediate-level construction planning using Oracle Primavera p6 and Microsoft Excel.You need to have basic knowledge of Planning Concepts and Oracle Primavera P6 software. Furthermore, you need to have Microsoft Office 2016 or later or Microsoft Office 365.We will start from scratch with a project Bill of quantities BOQ and a set of drawings to create the following:1-Course introduction.2- Read project BOQ.3- Create Project Data Loading.4- Read Drawings and add floors to data loading.5- Activity list and WBS.6- Cost Loading.7- Resource Loading.8- Load Cost and Resources to P6.9- Estimate Activities Duration.10- Activities Relationships.11- Shop Drawings.12- Materials Procurement.13- Cash flow and Manpower Histograms.We will be using the smart Planning Technique using Microsoft Power Query and Oracle Primavera Import and Export to facilitate the Planning Process and provide a Detailed Baseline Schedule with minimal efforts saving 100's working hours.The course includes all the project documents and the final Baseline documents (Excel and XER files) as open-source for your use so you can modify and use them on your next project.This is a practical case study project where the instructor will open the files and start working on a real project case study doing the Baseline Schedule using Oracle Primavera P6 and Microsoft Excel advanced techniques. This course scope is NOT including the Project Time Schedule Update or Revised / Recovery schedule and does NOT involve Extension of Time EOT and Claims.