Download Microsoft Project Schedule files. Contoh Perencanaan Proyek, MPP files


Since WordPress basic packet, only allowed these files:  jpg, jpeg, png, gif, pdf, doc, ppt, odt, pptx, docx, pps, ppsx, xls, xlsx, key.



So please after download files, change extension file from xls to mpp,

How to change, see below instruction:

file explorer, click menu VIEW, tick file name extension,

click file, right click, rename extension from XLS to MPP



source ; microsoft

just click to Download,

  1. agile-project-management                       Agile project management
  2. commercial-construction                          Commercial Construction
  3. create-a-budget                                      Create a Budget
  4. customer-service                                     Customer Service
  5. earned-value                                          Earned Value
  6. home-move-plan                                     Home Move Plan
  7. install-project-server-2013                       Install project Server 2013
  8. market-research-schedule                       Market Research Schedule
  9. marketing-campaign-plan                        Marketing Campaign Plan
  10. merger-or-acquisition-evaluation              Merger or acquisition evaluation
  11. new-business-plan                                  New Business Plan
  12. new-product-launch                                New product launch
  13. project-management-institute-process    Project Management Institute process
  14. project-management-plan                       project management plan
  15. six-sigma-dmaic-cycle                              Six sigma dmaic Cycle
  16. software-development-plan                      Software Development Plan
  17. sox-compliance-and-technology                 Sox Compliance & Technology
  18. startup-business-plan                                Startup Business Plan
  19. training-rollout-initiative-and-plan               training roll out initiative and plan
  20. wedding-planner                                         wedding planner

Best Mens Watches  Would you Stylest

Best Computers  ever seen

source from     ( Where Project Managers and Microsoft® meet )

The top best selling Software

  1. annual-report-preparation   annual report preparation
  2. electronic-government        Electronic government
  3. human-resource-information-system-implementation   human resource information system implementation
  4. marketing-campaign-planning    marketing campaign planning
  5. marketing-event-planning-and-execution marketing event planning and execution
  6. microsoft-office-2007-deployment  microsoft office 2007 deployment
  7. microsoft-office-sharepoint-server-2007-deployment  microsoft office sharepoint server 2007 deployment
  8. microsoft-solutions-framework-application-development-project-plan microsoft solution framework application development project plan
  9. microsoft-windows-sharepoint-services-deployment office-move-plan   microsoft windows sharepoint service deployment office move plan
  10. project-plan-for-new-business residential-construction-project-plan   project plan for new business residential construction project plan
  11. software-localization-plan software localization plan

International best seller books

The best downloaded Games

jangan lupa setelah anda download, ganti extension files dari XLS menjadi MPP , agar bisa dibuka dgn microsoft project , cara mengganti extension, tinggal ikuti petunjuk di bagian atas.



Series Microsoft Project : Link projects to create a master project

Ketika Ada beberapa project yg berhubungan satu sama lain, daripada menyatukannya dan membuat ribuan baris task activities yg buanyak, dan kelemahan ms Project adalah lambat dlm processing , tak jarang restart sendiri, dan membuat ada pekerjaan yg harus diulang lagi,

ada trick yg bisa meringankan beban penderitaan di atas:

dgn menu Project, lalu dibawah plng kiri anda clik menu subproject

ada 2 pilihan : saling mengupdate atau tdk saling mengupdate

kalau di tick berarti, Antara master dan subproject akan saling meng update bila salah satu ada yg diubah schedulenya,

sebaliknya bila di untick tidak akan berpengaruh , satu sama lain, jadi seperti copy saja.

kemudian setelah tick link project , ada pilihan lagi Mode : read/write or read only

kalau read/write : edit bisa di master project atau subproject

kalau read only: edit hy bisa di sub project.


Menu : project then click Subproject to insert  subproject to master project.

option :

  1. tick / untick link to project
  2. Mode : read/write or read only

Link to project.png

Link projects to create a master project – Project

Link projects to create a master project

To help keep a large project more organized, you can link several project files together to create a master project/ subproject arrangement (also known as external dependencies). For example, a construction master project might have subproject files for plumbing, electrical, and carpentry work. Here’s how:

  1. Create separate Project files for each subproject, then open or create the project that you want to be the master project.
  2. In the master project, click View > Gantt Chart.
  3. In the Task Name field, click the row below which you want to insert the subproject. You can insert a subproject anywhere in the task list of the master project.
  4. Click Project > Subproject.

    The Project ribbon tab, showing the Insert subproject command.

  5. In the Insert Project box, select the subproject you want to insert.
    • To insert multiple subprojects, hold down Ctrl and click the subprojects in the order that you want to insert them.
    • In most cases, you’ll want to leave the Link to project box checked, so that changes in the subproject are reflected in the master project, and vice-versa. But if you just want to copy the subproject into the master project without the files being dynamically linked, uncheck the box.
  6. Click Insert, or to insert a project in read-only format, click the arrow on the Insert button, and then click Insert Read-Only. Inserting a project read-only creates a link between the two projects, but prevents you from updating the subproject from within the master project. If you update the subproject file directly, however, its changes are reflected in the master project. The Insert Read-Only option is only available when the Link to project box is checked.

Avoiding duplicate resource names in linked projects

If you link projects that have resources with the same name, you’ll create duplicate resource names, which could be confusing. To avoid this, uncheck the Link to project box in the Insert Project dialog box. Doing this will ensure that the resource information in the master project (such as pay rates, resource calendars) will be honored over the subproject resource information.

Note:  When you update an unlinked subproject from within the master project, the original subproject file will not show this change.

<img alt=”” style=”width: 1px; height: 1px” src=”//” />

What’s new in Microsoft Project 2016

We are excited to announce availability of Project 2016. This release includes significant updates to Project Professional, Project Pro for Office 365 and Project Online. Project 2016 delivers on some of the most requested capabilities: Resource Management and Resource Capacity Planning. Supporting these key capabilities are enhancements such as new Resource Engagements, a brand new experience for resource managers, and Capacity heat maps. Project 2016 now provides an end-to-end experience for managing and optimizing your resource utilization.

In addition to resource management, there are a host of improvements and new features to help you be more productive with Project, such as improved timelines, Tell Me integration and full support for Office add-ins.

Resource Engagements

For project managers, securing resources to ensure your project is properly staffed has always been a challenge. With Project 2016, it’s now possible to systematically request a resource, and once approved, lock that resource to guarantee it’s available.

Creating an engagement and submitting it for approval sets off a simple workflow that enables the resource manager to approve or reject the request.

The project manager will always have an up-to-date view of the status of their requests from within Project Professional 2016 or Project Pro for Office 365. Once a locked resource is assigned to a project for a duration of time, managers of other projects will get notified if they try to overbook a resource.

The resource manager experience

The resource manager (or line manager) is a people manager who may not want to use the full Project client. To allow the resource manager to collaborate with the project manager, Project Online now has an area for the resource manager to view and approve or reject all proposed resource contracts. In addition, the new resource views allow the manager to understand the capacity utilization of their resources at a quick glance.

Resource Capacity heat maps

Ensuring that the resources are well utilized and productive is a key strategic need for any company. Project 2016 introduces the Capacity heat maps and a brand new set of intuitive reports to enable at-a-glance visualization of resource utilization. Both under- and over-utilization of resources can be problematic, and both can be seen quickly with the new heat map.


Communicating the project schedule is a critical part of any project manager’s job. But for many audiences, a Gantt chart isn’t the best way to visualize the schedule. More than ever, a timeline is the best way to communicate how a project’s lifecycle lays out. With this in mind, we have overhauled the Timeline feature to include multiple timelines, each with different start and end dates, representing a user-defined set of tasks and milestones.

There are several rich features in the new Timeline visualization, including:

  • Independent start and end dates for each timeline.
  • Drag and drop between different timelines.
  • Save to PowerPoint with editable objects.

Tell Me

With so many features in Project 2016, wouldn’t it be great if you could just ask where a certain feature was, instead of having to hunt for it? With Tell Me, you can do just that. Better yet, the answer that Tell Me provides is a live button, so you just have to click the answer and it will do as you ask. It’s a huge time saver.

new in Project 2016 6

Read/Write Office add-ins

Office add-ins are extensions that you can download from the Office store that add functionality to Project. This means that Microsoft and its partners can continuously and easily deliver new features so you can customize Project to your tastes. With Project 2016 release, Office add-ins now have full Read/Write access to the project you are working on, providing richer extensions than have ever been possible.

new in Project 2016 7


Project 2016 is immediately available online as part of Office 365. The new service side features, such as Capacity heat maps, are being rolled out intoProject Pro for Office 365 andProject Online right now. When you choose to activate these features, we will automatically upgrade all of your existing Resource Plans to Engagements. The new resource management features will be available to on-premises customers in the spring of 2016 when Project Server 2016 is released.

Enjoy the new Project!

—Howard Crow, principal group program manager in the Project engineering team

Seri MS Project : apa arti Effort Driven


anda masuk ke option ms project,

masuk ke schedule,

ada pilihan centang, new task are effort driven ?

apa arti effort driven:  adalah task atau activity di project anda tidak tergantung dgn resource, berapa pun resource yg anda assign, duration task akan tetap sama.

berbeda bila kita unchecked, ketika ada tambahan resource , penambahan itu akan mengurangi waktu duration task tersebut.

masing2 activities mempunyai characteristic berbeda, jadi anda harus paham maknanya,

misal membersihkan halaman semakin banyak orng yg mengerjakan akan semakin cepat selesai, dan ketika seorang artis mengerjakan karya inovasi, belum tentu penambahan orang juga align dgn lbh cepatnya waktu kerja.


effort driven

Seri MS Project: kenapa status late, padahal tanggal belum lewat.

Jangan gemes, dgn ms project,

Konsep project management, setidaknya harus ada kita pelajari, dan jangan pernah membayangkan ms project adalah seperti Excel.

contoh, tanggal masih jauh, tapi statusnya Late-terlambat.

Status late


caranya adalah, di menu project, masuk project information:

ubahlah status date dan start date dgn benar.

project Information.PNG


setelah diubah sbb:

Project Information_after


setelah anda ok in,

bagaimana statusnya sekarang, dari late menjadi future task.

status after tune up


Seri MS Project: Mengubah working time

Liburan sudah tiba, asyikkk,

Jangan lupa ketika memulai project, semua hari libur atau cuti massal, diperhitungkan,

Bagaimana caranya:


di menu project, klik change working time:

change working time 1


Isi manual libur resmi nasional atau cuti massal,

isi namenya,pilih tanggal mulai  liburnya, di start dan finish, bila hanya libur satu hari, start dan finish datenya sama.

bila anda bekerja di MS Project server, minta admin anda utk mengedit, bila terpaksanya , anda bisa create new calendar.


setelah done, jgn lupa, masuk ke resource sheet, ( menu task, klik gantt chart plng kiri)

setelah masuk di resource sheet, ubah, base, calender resource anda ke calender yg telah edit-sesuaikan hr liburnya.

resource sheet

check, di activites project anda, apakah ada task yg masih masuk di hr libur.




apakah anda frustasi dgn microsoft project?

Michael A. Steinberg, PMP, Senior Project Management Consultant, Project Assistants, Inc. (MPA member, Atlanta, GA)

   How many of you felt frustrated with Microsoft Project not behaving like you expect it to?

1.      It’s not a spreadsheet

This may seem obvious, but it’s worth a mention.  A new user may look at the grid-like layout of the default “Gantt Chart” view and assume that because it looks like a spreadsheet that it also behaves like a spreadsheet.  They quickly discover that the tool automatically performs some scheduling functions, like, for example, changing start and finish dates.   Not understanding how or why it does this, they quickly become intimidated and abandon the tool.  The bottom line:  Project is a scheduling tool.  Scheduling tools will change dates!

  • How many of you felt frustrated with Microsoft Project not behaving like you expect it to?

2.      Know the “Basic Scheduling Formula”

Duration = Work/Units

Understanding of the meaning of these three terms (See Project Help), as well as the formula itself, is key to understanding how Project schedules a task.  To anyone who has changed any of these three parameters on a task, without understanding this formula, the changes that Project makes to the other parameter(s) can sometimes seem totally unexpected or bizarre.

In my experience, not knowing this formula is the biggest cause of frustration that people experience with the tool.   Knowing the formula will not stop Project from doing things that you don’t expect, but it will allow you to know what changes to make so that it will do what you want.

3.      Use Task Types correctly

What will Project do when you change either work, duration or units on a task – that is, which of the others will it change and which will it keep constant?   The Task Type parameter is what tells Project how to behave.  The general rule is:

If work, units or duration is fixed and you change one of the others, Project will recalculate the third, but wont change the one that’s “fixed”.

Even if you don’t set task type explicitly, each task defaults to one of the three – and the system default is “Fixed Units”.  This can cause problems in many cases, because since most technical tasks are driven by the amount of work effort required, they should generally be “fixed work”.

4.      Estimate work, rather than duration

As mentioned in the previous tip, most technical tasks are driven by the amount of work effort, not by duration.  Therefore, it is a good practice to estimate how much heads-down work effort a task is likely to need, and estimate the number (or fractions) of resources (which is the definition  of units), and let the tool calculate duration.

Duration is dependent on many things – not only work effort and assignment units, but calendars, task splits and a number of other factors.  Often, when we estimate duration first, we are really applying the basic scheduling formula (Tip number 2) in our heads. Why not let the tool do the math!

5.      Understand “Effort Driven”

If a task is effort driven, the total task work will remain the same if you add or remove resources.  If you add a resource, the total amount of work effort will be divided among all of the resources, including the new ones, thereby reducing duration.

A good practice when adding resources to a task, even if you do understand this concept, is to explicitly specify the work and units for each assignment, so you remain in control of the division of labor.  Do this in a usage view or the bottom half of a split-screen view.

6.      Don’t assign everyone at 100%

When you assign a resource to a task, the default level of “assignment units” is 100%.  This means that the resource will be assigned full time on that task for its entire duration!  Is that what you always want?  Probably not, but it is easy to fall into that trap.  This will result in a serious distortion of their true allocation.  Be especially careful when people are assigned to concurrent (parallel) tasks.  Be sure not to assign them full time in these cases.

7.      Minimize constraints

Constraints, such as “Start no earlier than”, or “Finish no later than”, are really telling Project not to schedule a particular task.  Sure, there are legitimate uses for them, such as a dependency on a truly external event.  However, the best practice is to estimate each task and its dependencies, and let Project adjust the schedule.  This is called “Dynamic Scheduling”.

Hard (or “inflexible”) constraints such as “Finish no later than”, should be avoided if possible.  Hard constraints can cause scheduling conflicts, where Project may be forced to choose to ignore either a constraint or a dependency – again, a situation where you are tying one hand behind its back.

“What if my sponsor mandates an end date?” you say.  Use deadlines instead.  Deadlines will flag a missed milestone but will not disable scheduling of the task.

One note about constraints:  When you manually key in a start date, you are effectively setting a “Start no earlier than” constraint.  That is why project sometimes ignores a date that you type in.

8.      Avoid estimating Percent Complete

Estimating percent complete is not a best practice for many reasons, not the least of which is its vulnerability to abuse.  A better practice is to ask a resource (or manager) to report actual work and to estimate remaining work, and let the tool calculate percent work complete.  (In fact, when we estimate percent complete, aren’t we really mentally estimating those two amounts and doing the math in our heads?)

Another note:  In Project, the “% Complete” field really means “% duration complete”, as distinguished from the “% work complete” field.  Make sure you understand the difference and which you want to use.

9.      Heed the Planning Wizard

Yes, those annoying messages like “This action will cause a scheduling conflict…” are really your friend.  They warn you of potential problems, like the one described in the previous tip.  Deal with them immediately, because their consequences may become more difficult to trace back to their root causes when they are no longer fresh in your mind.

10.  Leveling is not a magic bullet

As anyone who has used automatic leveling knows, there is really no magic to it.  It simply delays the start (or continuation) of tasks in your schedule until resources are no longer overallocated.  This is not always practical.

The best practice is to use some thought when first assigning resources to tasks.  For example, don’t assign the same person full time to two tasks at the same time.  If you are careful, leveling can work for you.  If you are not, it is sure to make things worse!

11.  Tools do not replace communication

With all of the collaboration tools in the Enterprise Project Management (EPM) environment, like notifications and SharePoint, one might be tempted to think the tool can communicate for us.  Wrong!  Ninety percent of a project manager’s job is interpersonal communication.  EPM tools will facilitate communication and relieve us of some of the more mundane tasks so we can spend more time communicating – but it won’t replace it.

12.  Tool expertise will not make you a perfect project manager

This point expands on the previous tip.  Microsoft Project is a great scheduling tool.  But that’s all it is.  PMI® identifies 47 processes that a project manager performs.  Project really only supports a handful of those processes.  As they say, “a PM tool makes a good manager better faster and a bad manager worse faster.”  Microsoft Project will facilitate some of our more routine scheduling tasks, so that we can devote the bulk of our time truly managing our projects.

Project management is not only schedule.


[1] Thanks to Dr. Fred Oettle, Director of Training at Project Assistants, for articulating these concepts in our training.

MS project -What causes overallocation, and manually resolved an over allocation.

MS project -What causes over allocation, and manually resolved an over allocation.

• You can find on MS project : in Tools menu –click Level Resources

• Resource leveling is the process of delaying or splitting a resource’s work on a task to resolve an overallocation.

• The options in the Level Resources dialog box enable you to set parameters about
how you want Project to resolve resource overallocations.

• Project will attempt to resolve such overallocations when you choose to level resources. Depending on the options you choose, this might involve delaying the start date of an assignment or task or splitting the work on the task.

• Resource leveling is a powerful tool, it does a few basic things:
o Delays tasks, splits tasks, and delays resource assignments.

• Resource leveling is a great fine-tuning tool, but it cannot replace your good judgment about resource availability.

Sekilas Microsoft Project server Business intelligence

Microsoft Project server Business intelligence,

Judul nya keren ya :),

Business intelligence seperti yg anda ketahui adalah big data, menemukan emas dlm timbunan data2.

Pernah ke warehouse ?

Yg luas besar berhektar2,
Kontras dgn barang2 besar ribuan dan atau yg kecil ratusan ribu, bgmn cara me manage utk tdk deadstock atau  kita scrap dibuang percuma.

Konsepnya semua data adalh berharga namun bgmn cara mengolah menjadi lbh emas.

Kl term marketing , analisa data, behavor -opinion- user attitude- how they use- compare ,
categorized by segmentasi :needs, user, pattern, buying criteria, lalu create atau enhance product,
Menjadi limpahan revenue derass.

Sama juga diproject,

Didlm portfolio project ada byk project itu mungkin setahun, bgmn bila 5 thn?

Berapa task activities didlmnya?

Berapa resource utilization?
Berapa rata2 task yg paling lama dikerjakan atau yg byk memakai resource.
Brp rata2 waktu yg dibutuhkan utk setiap tahapan projects?

Dr project mandates ke kick off meeting brp rata2 waktu.
Dr bast ke  milestone  AR payment brp waktu.
Apa saja issue atau risk yg sering muncul ?

Perumpamaan seperti menggunakan pivot, anda bisa mengolah data yg bisa berguna utk meningkatkan kualitas dan efisiensi.
Gaji ke 13 dan 14 pegawai negeri belum turun tp harga2 sudah berubah, kondisi cash flow yg terancam akan jadi kontras bila tdk segera dilakukan efisiensi.

Inti dr BI di msp server adlh:

Measurements : day, week, currency dll

Dimensioning: task dlm wbs, wbs dlm project dll.

Attributes: sebagai pendamping utk lbh mendetailkan dimensioning.

Apa yg dihasilkan bisa menjadi bahan top executive, sdh jadi kewajiban kita yg dibawah memberikan panduan data utk arah kebijakan yg lbh tepat real dan cepat.

Reporting tsb juga bisa menjadi lesson learned yg sangat akurat, bukan subjective atau dibuat2. Atau malah kita tdk pernah menggunakan data lesson learned.??

.tenang itu sudah jamak, wkkk.

Msh byk lagi yg blm dibahaas , 🙂

Sekilas Microsoft project server

Beralih ke Microsoft project server , mengapakah?

Bila anda sudah terbiasa dgn microsoft project ( msp) dan ditempat anda simultant ada byk projects , tak pelak anda butuh lebih utk bisa optimization.

Program atau porfolio mgt dibutuhkan utk menata lbh baik , lbh baik menuju arah perusahaan terdepan :

Project interdependecies,
Resolve Common problems, masalah klasik: resource, utilization , cost dll.

Lalu apa yg bisa kita ambil lebih  dr msp server,?

Pertama anda bisa membuat dashboard report yg lbh cepat, anda bisa atur merah utk below, hijau utk above bisa schedule, cost tcpi misalnya, dll

Konsep dasar dr msp server adalah:
PM create project schedule, save publish to server, assigned global resources.
Resources beserta rate cost bisa di maintainance dr hr , sap misalnya.

Setiap resources yg diassign py akses ke project schedule tsb,
Confirmasi completed status dr tasks diproject tsb.

Status akan dilihat oleh pm utk projec ini.
Dr sisi management akan melihat lbh cepat utk semua result status update dr semua project. Percentage completed misalnya.

Decision bisa sgr diambil, utk peningkatan yg dibuthkan.

Minusny diatas ada prlu tambahan license, utk cost saving PM bisa mewakilkan utk melakukan konfirmasi task.

Lalu apa kelebihan lain,

Krn terintegrasi, resource bisa dr satu sumber,valid rate,nama, role yg lbh update drpd assign manual.

Status report, bisa anda create bisa misalnya weekly: anda isi highlight, next task, dll anda bisa customize.

Repository docs,
Semua project dokument bisa anda simpan terpusat dan bisa dijadikan check list utk project governance dr misal proposal, charter, mom dlll dll

Issue dan risk bisa digenerate.

Automatically alert reminder by email, sfb atau lync.


Microsoft Project server business intelligence, keren ya wkk.



the PMO Architecture Layer:

  1. A Project Portfolio Management (PPM) Application
    • Microsoft Project Server, HP/Mercury ITG, CA/Niku Clarity, Planview, SaaS Appls, etc.
  2. Desktop Tools supporting the PMO and/or PPM Application
    • Microsoft Project Professional, Open Workbench, etc.
  3. A Collaboration and Document Management Platform (Teamsites, Workspaces, eRooms, etc.)
    • Microsoft SharePoint, IBM Lotus, Documentum, etc.
  4. PMO Content Assets (Processes, Templates, Policies, SME Knowledge, Executive Dashboards, etc.)
    • BOT Processes On Demand, PM Solutions PMCoP, Tensteps, etc.


Top 10 Tips for Microsoft Project Server

Tip 1: Valuable, but not a simple tool. Microsoft Project Server is an extremely valuable application for companies seeking to engage in enterprise project management and project team collaboration. However, Project Server is not a simple tool, even for those who have used Project Server before and have experience using Microsoft Project Professional. Ensure adequate administrator and user training when implementing Project Server.

Tip 2: The difference between saving and publishing. There is a difference between saving and publishing your project to Project Server. When you are working on a project plan, you will want to save your project from time to time to protect against losing your work. However, you may not have finalized your project plan and want to continue to add information to it, review it, and/or modify it before publishing. Therefore, you save it first, and publish your project only when you believe that it contains enough information that will make it useful to other viewers of the project plan on Project Server.

Tip 3: Enterprise projects. A project is an enterprise project when you create the project schedule using Microsoft Project Professional while connected to Project Server with Enterprise Features enabled and you import the project to the enterprise using the Import Project to Enterprise wizard. In a Project Server environment, no other non-programmatic method of creating an enterprise project is possible because all projects are stored in the Project Server database.

Tip 4: Enterprise resources. A resource is an enterprise resource when it is either created in the Enterprise Resource Pool using the Microsoft Project Professional client while connected to Project Server with Enterprise Features enabled or when the resource is imported into the Enterprise Resource Pool using the Import Resource to Enterprise Wizard in Microsoft Project Professional. Resources that exist in local projects, but not the Enterprise Resource Pool, are termed a local resource, meaning that it is local to the project only.

Tip 5: Enterprise resource pool. The centralized enterprise resource pool is key and required in order to implement the advanced resource management functionality in Project Server. The resource pool contains resources and attributions that drive functionality like matching people to tasks. After you complete task planning, you can then begin the resource management process and build a team for your project.

Tip 6: Understanding the project communications life cycle. At the heart of Project Server is the cyclical assignment and update process between project managers and team members. Work assignments flow from the project plan to the project resources that perform the work and resources report progress data back to the plan. This communications life cycle flows through the following five steps.

  1. Project manager publishes the plan to the Project Server database
  2. Project Server notifies resources of their new task assignments
  3. Team members update their progress on the project
  4. Project manager receives and reviews team member task updates
  5. Project manager publishes the latest project schedule

At any time throughout the project, executives can view the project portfolio of the organization.

Tip 7: Additional communication tools. In addition to the core communication between project managers, project team members, and the leadership team, Project Server provides additional features for communication and collaboration. Some of these features are native to Project Server, others leverage SharePoint. Features native to Project Server include Status Reports, Automated Alerts and Reminders, To Do Lists, Outlook Integration, Task Delegation, and Ad hoc Reporting.

Tip 8: Understanding Windows SharePoint Services (WSS). Each time a new project is saved in the Project Server database, the system optionally provisions a new project workspace on the server running Windows SharePoint Services (WSS). The project workspace contains the WSS services customized specifically for Project Server such as document libraries, issues and risks, lists, discussions and surveys, which users access through the Project Web Access interface.

Tip 9: Understanding OLAP. Online Analytic Processing (OLAP) technology relies upon a multidimensional view of data. While relational database structures are two dimensional, OLAP leverages data cubes which contain preprocessed three-dimensional data, time-phased and aggregated by business dimension. Each time Project Server processes the OLAP Cube, it stores the data in a collection of tables labeled with the prefix “msp_cube.”

Tip 10: Portfolio Modeling. Project Server offers a Portfolio Modeler Tool for portfolio analysis that allows you to perform basic what-if analysis for such things as staffing changes in a single project or across a portfolio of projects. This tool can help you improve resource assignments and avoid resource over allocation.

cara Import file Excel ke MS project, Export file MS Project ke Excel


Import  file Excel ke MS project, Export file MS Project ke Excel

download file utk lebih mudah: Belajar Project-basic Import excel to MS Project

Setelah file di atas anda download, lakukan step2 dibawah ini,

Computer ( bila anda simpan di computer local)
open, ganti projects dgn pilih excel workbook
double click

muncul import wizard
click next to continue

pilih use existing map
click next

click next
pilih as a new project


centang, task, resources,assignment, import includes headers
click next

muncul task_table
click add all
bila benar muncul di bawah preview ( mapping excel ke ms project)
click next

bila muncul OUT OF CONTEXT:Who_Does_What
click next saja,

muncul assignment_table
click add all
bila benar muncul di bawah preview ( mapping excel ke ms project)
click next

bila berhasil muncul congratulations
click finish

muncul di ms project


import excel to ms project

setelah muncul

anda di view gantt chart
check lah juga di view resource sheet, sudah terisi,
dr 3 sheet yg anda import, sudah menjadi data di ms project, task, resource dan assignmnet ( siap melakukan apa)

balik lagi di view gantt chart, kemudian,
ubahlah manual di duration : prepare project charter dari 0 days menjadi 1 days


import excel to ms project 2

export balik ms project ke excel

Belajar Project-basic export frm MS Project
menu file
pilih export
save project as file
pilihlah microsoft excel workbook
save as type: microsoft excel workbook

muncul export wizard
click next
ubah ke project excel template

click ok saja

file excel anda sudah jadi.


bila anda ada sap project system, bisa anda transfer, dari SAP PS ke excel lalu ke MS Project,

kalau ada open ps lebih mudah,

atau dr sap ps tcode CNs41 export ke ms project, cuman ms projectnya jadul



Cara membuat S curve langsung di Microsoft project, how to create s curve by microsoft project 2013

Cara membuat S curve langsung di Microsoft project,

utk konsep s curve:


Ini report yg bisa langsung kita generate di MS Project , sumbu y yg dihasilkan adalah waktu  ( week, month ,day) bila yg ingin anda tampilkan percentage, silahkan lihat artikel saya yg satu lagi, khusus s curve percentage. ( )

Yg perlu diingat scruve, adalah compare antara actual dengan plan, tujuannya ingin mengetahui progress project anda yg berjalan saat ini : on schedule, behind schedule atau malah lbh bagus dr schedule:

  1. Plan Diwakili dengan baseline Cumulative work
    1. Yg perlu dilakukan adalah anda harus create baseline dulu, anda bisa lakukan sbb: di menu project-set baseline-set baseline. Baseline yg  anda create pertama adalah nol percentage donenya
  2. Actual disini , diwakili cumulative actual work
    1. Yg perlu dilakukan, setelah anda create baseline seperti diatas, confirmasilah task atau aktifitas yg telah anda lakukan misalnya kick off meeting task done, anda set set 100% , bisa lewat task information-tab general,percent complete

Pada menu reports:

  1. Create a new report., pilih blank dulu saja,
  2. Insert a line graph (menu design, lalu pilih chart) ( pilih yg seperti dibawah, plihan graph harus seperti ini, kl tdk , tdk bisa)

scurve MSproject1


3.Double click graph, muncul field list table , disebelah kanan

Field list, Di work, pilihlah atau Select Cumulative Work ,

Field list, Di work-baseline- pilihlah atau select baseline Cumulative work


Muncul lah seperti dibawah, anda bisa customize sesuai kebutuhan anda.


scurve MSproject2

Membuat S Curve Percentage dari Microsoft Project , how to create s curve percentages % by microsoft project

S curve tdk bisa dilepaskan dari project management, apa yg menarik dari s curve adalah orang bisa cepat paham saat ini berapa percentage pekerjaan telah dilakukan, baseline/plan seharusnya, apa yg utama dr  scurve juga bisa memberikan awareness ke stakeholder,
posisi saat ini project kita berjalan-bagaimana team bersatu utk on track schedule, ingat dukungan dari executive sangat kita perlukan,
dgn memberikan informasi yg tepat dikemas dlm visual menarik, akan menarik perhatian dan decision cepat.


utk lbh jelas tentang konsep S Curve :

asumsi anda sudah familiar dgn ms project, tp jgn khawatir, akan terpisah dijelaskan dari mulai step2 yg sederhana dlm posting terpisah, ( )


Menu Report- click Visual reportreport-visual report

 Baseline work report-edit report  Click view (generate excel report)

Edit template, add: Baseline Cumulative work,Cumulative Actual work,Cumulative workEdit template addBaseline Cumulative


Click view (generate  excel report)Baseline work report-edit report

Sheet assignment usageSheet assignment usage


Change data to percentage








Baseline Cumulative Work:  Baseline Cumulative Work (week awal) /baseline cumulative work (week akhir)
Cumulative Actual Work:  Cumulative Actual Work (week awal) /cumulative work (week akhir)


Cumulative Work : Cumulative  Work (week awal) /cumulative work (week akhir)




Insert chart- line chart type , jadilah s curve, anda bisa atur layout,warna, add data sesuai kebutuhanInsert chart- line chart type

pemilihan chart: chart


Percentage check- % must be same with : menu report-dashboard-work overview ,dibawah hanya contoh tampilan, datanya berbeda dgn diatas,

Percentage check