豆丁微信公众号
君，已阅读到文档的结尾了呢~~
扫扫二维码，随身浏览文档
手机或平板扫扫即可继续访问
P6R8.2软件操作练习(建筑篇)正式版
举报该文档为侵权文档。
举报该文档含有违规或不良信息。
反馈该文档无法正常浏览。
举报该文档为重复文档。
推荐理由：
将文档分享至：
分享完整地址
文档地址：
粘贴到BBS或博客
flash地址：
支持嵌入FLASH地址的网站使用
html代码：
&embed src='http://www.docin.com/DocinViewer--144.swf' width='100%' height='600' type=application/x-shockwave-flash ALLOWFULLSCREEN='true' ALLOWSCRIPTACCESS='always'&&/embed&
450px*300px480px*400px650px*490px
支持嵌入HTML代码的网站使用
您的内容已经提交成功
您所提交的内容需要审核后才能发布，请您等待！
3秒自动关闭窗口 上传我的文档
 下载
 收藏
粉丝量：72
免责声明：本人所有资料来自网络和个人所创，版权归原作者所有，请注意保护知识产权，如有需要请购买正版图书，请您下载后勿作商用，于24小时内删除，本人所提供资料仅为方便学习交流。 本人如有侵犯作者权益，请作者联系官方或本人,本人将立即删除。
 下载此文档
建筑工程WBS工作分解结构P6
下载积分：800
内容提示：建筑工程WBS工作分解结构P6
文档格式：DOC|
浏览次数：357|
上传日期： 01:27:27|
文档星级：
全文阅读已结束，如果下载本文需要使用
 800 积分
下载此文档
该用户还上传了这些文档
建筑工程WBS工作分解结构P6
关注微信公众号How to Convert a Project’s WBS to Activity Codes in Oracle Primavera P6
| LinkedIn
Download the files to complete this tutorial on your own.
Project Plan (.xer) : &
P6 SDK Excel Tool :&& (Please note that this tool was created by Oracle Primavera and we do not provide support on its use)
WBS to Activity Code xls :&
The idea of this tutorial was inspired by a question in&LinkedIn forum, a planner have received a primavera schedule&using WBS, as in the oil and gas industry it is very useful to&have different layouts to present the schedule to different&audience, and more importantly the Work breakdown structure is&based on geographic area in the construction phase, and systems&in the commissioning phase, the tutorial will use the APEX sample&schedule to convert a WBS to activities codes, it is assumed you have already worked with the Primavera P6 SDK.
Step 1 – Open the schedule.
The APEX schedule organizedby the default “classic WBS&layout”.
Step 2 – Export WBS Dictionary to Excel
In P6, goto the WBS screen. &Customize the columns so only WBS code, and WBS name are displayed.
Highlight all WBS rows, copy and paste the two columns to the worksheet “WBS&dictionary” of the &”WBS-to-Activity-Code-P6.xls” file&(see Tutorial Assets). &Make sure that your WBS structure is well&organized (*). &It means every level must have the same exact number of characters. &In this regards P3 was&more rigorous, as the structure of the WBS is defined first. &In&P6, it is generated automatically. &It is very easy to edit the WBS Code, to have the same number&of character for every level.
The excel formula in “column F” generates a unique list of the number of&characters sort in ascending order, it is an array formula&(that’s why there is curly braces between the formula, if&not, use CTRL+SHIFT+ENTER to execute it).
In this example,&WBS code with four characters -eg “APEX”, this is level&1. &&WBS Code with 7 characters – eg “APEX.AM”, this is level&2.
Of course, L1, L2 are just used as an example, in a real&project, levels are usually defined as &project, phase, sub-project, area,&discipline, items, etc.
Step 3 – Export WBS Activity Assignment to Excel
Remove the Group and Sort by WBS, &in columns add WBS and Activity&ID.
Copy and paste the two columns to the excel worksheet “Activity&codes per Activity” in columns A and B. &Excel columns C through G will be generated automatically,&by default, if no code is available, a ” -“ is assigned.
Step 4 – Create Activities Codes Dictionary and Import&to P6
First define the new project activity codes in P6 that will represent the WBS.
Back in your excel file, goto the “activity code dictionary” worksheet. &Using an excel pivot table, the excel file will generate an activities&codes dictionary that we have to load back in P6 on this worksheet.
Using the dictionary excel utility (Dictionary6v7.xls – instructions on using this file can be obtained from. &Search for “dictionary6v7.xls”), click on “Get&Activity Codes”& (you need the SDK to be installed&and configured).
Copy and paste the activities dictionary from the excel file,&for every level add a dummy “-“ without a code&description, so P6 will not show the&ugly “no code” when you organize by activity code for&activities without a code assigned.
Now you can import back to P6 &the activities codes&dictionary (click “Set Activity Codes” on the Login tab). &Make sure you import to the right project.
Now your project is loaded with the activity codes&dictionary.
Step 5 – Import activities codes assignment to P6
Make a new Excel export. &Select the newly defined activities&codes (L1-L5) as columns in your layout.
Open the exported excel file.
Use a Vlookup formula to retrieve the values of L1, L2,&L3, L4, L5 from the excel sheet Activity codes per Activity. &In&the Excel file, there is sample vlookup sheet to show how the formula works.
Import the updated export file back to P6. &The WBS is now transfered to the L1-L5 project activity codes.
Step 6 – Enjoy.
Now, with a new layout the schedule is organized by activity&codes.
Primavera P6 has very strong activity codes capabilities. &Unfortunately, many planners use only the WBS as it is very easy&and intuitive, but once you start tailoring the schedule, printing for a different purpose and audience, in a way that&make a sense to them, activity codes should be used as Primavera only&permits one WBS per project.
(*) : if your WBS has not the same number of character for every level, you can use alternative method, explained&.
Written by Projcon Group. (C) Copyright 2015 by Projcon GroupLooking for more of the latest headlines on LinkedIn?P6练习题(火电篇打印版)_图文_百度文库
两大类热门资源免费畅读
续费一年阅读会员，立省24元！
P6练习题(火电篇打印版)
&&这是一篇完善的P6学习资料,该资料详细的讲解了P6应用的步骤。
阅读已结束，下载本文需要
想免费下载本文？
定制HR最喜欢的简历
下载文档到电脑，同时保存到云知识，更方便管理
还剩28页未读，继续阅读
定制HR最喜欢的简历
你可能喜欢药品服务许可证(京)-经营-违法不良信息举报: 电话、邮箱youkujubao@service.alibaba.com请使用者仔细阅读优酷、、、、和Copyright(C)2018 优酷 youku.com 版权所有}