|
所在平台: Udemy |
课程主页: https://www.udemy.com/course/baseline-schedule-course-for-beginner/
课程评论：没有评论
**Coursera 课程总结：初学者基线进度计划课程** 本课程旨在教授初学者如何根据项目范围准备基线进度计划。您将学习如何从 Primavera P6 中提取数据，从而创建进度图（histogram）和 S 型曲线（S-curve）。 **核心内容概览：** 1. **从 Primavera P6 提取数据：** * 打开 Primavera P6 项目。 * 在“活动”选项卡中，自定义列以包含关键数据，如活动 ID、活动名称、开始日期、完成日期、计划值、实际值和剩余值。 * 筛选活动以专注于 S 型曲线分析所需的部分。 * 将数据导出为 XLSX 格式的电子表格。 2. **准备 S 型曲线所需数据：** * 在 Excel 中打开导出的文件。 * 整理数据，确保列标签清晰。 * 计算随时间推移的累计计划值和累计实际值。 * 创建项目时间轴序列。 3. **在 Excel 中创建 S 型曲线：** * 选择时间序列和累计值数据。 * 插入二维折线图。 * 定制图表，包括添加标题、标签、图例，并清晰格式化坐标轴。 * 使用不同的线型或颜色区分计划值和实际值。 **有效 S 型曲线分析技巧：** * **基线对比：** 将基线 S 型曲线叠加，以比较计划进度与实际进度。 * **进度分析：** 识别计划值和实际值之间的偏差，以评估项目绩效。 * **定期更新：** 定期更新 S 型曲线，以反映最新的项目数据。 完成这些步骤后，您将能够有效地从 Primavera P6 提取数据，并在 Excel 中创建 S 型曲线，从而分析项目进度。
In this course you will learn how to prepare baseline schedule as per provided scope of work you learn how to create histogram by extracting from primavera p6 also the S-curve after analyses of resources like manhour resource cost resource etc.Creating an S-curve by extracting data from Primavera P6 involves several steps. An S-curve is a graphical representation of cumulative progress over time, often used in project management to visualize project performance against a schedule.Here's a step-by-step guide to help you prepare for creating an S-curve from P6:1. Extracting Data from Primavera P6 1. Open Primavera P6 and load your project. 2. Select the Activities Tab to view the activity data. 3. Customize the Columns to include the necessary data for the S-curve, typically: • Activity ID • Activity Name • Start Date • Finish Date • Planned Value • Actual Value • Remaining Value 4. Filter the Activities to include only those relevant to your S-curve analysis. 5. Export the Data: • Go to File -> Export. • Choose Spreadsheet - (XLSX) format. • Follow the prompts to export the selected activities and data.2. Preparing the Data for the S-Curve 1. Open the Exported File in Excel. 2. Organize the Data: • Ensure that the data columns are correctly labeled. • Calculate cumulative planned and actual values over time. • Create a time series for the project timeline. 3. Create Cumulative Totals: • Use Excel functions to calculate cumulative sums for planned and actual values.3. Creating the S-Curve in Excel 1. Insert a Chart: • Select the time series and cumulative values. • Go to Insert -> Line Chart -> 2-D Line. 2. Customize the Chart: • Add titles, labels, and legends. • Format the axes for clarity. • Differentiate the planned and actual values with different line styles or colors.Tips for Effective S-Curve Analysis • Baseline Comparison: Overlay the baseline S-curve to compare planned vs. actual progress. • Progress Analysis: Identify any deviations between planned and actual values to assess project performance. • Regular Updates: Update the S-curve regularly to reflect the latest project data.By following these steps, you should be able to effectively extract data from Primavera P6 and create an S-curve in Excel to analyze your project's progress.
