PROJECT M ANAGEM ENT

®
MI CROSOFT

PROJECT 2010
A pplication

Disusun Oleh:

Arief Rahmana, ST., MT.

[Link]@ [Link]

Oktri Mohammad F irdaus, ST., MT.

[Link]@ [Link]

Singgih Saptadi, ST., MT.

singgihs@ [Link]
1. Memulai Microsoft Proyek 2010

J
ika menggunakan Window s XP, Window s Vist a or Window s 7, memulai M icrosoft
Project 2010 dapat dilakukan melalui St art M enu – Start > All Programs > M icrosoft
Office > M icrosoft Project 2010. Jika menggunakan w indow s versi sebelumnya,
mengeksekusi M icrosoft Project dapat dimulai melalui St art M enu – Start > Programs >
M icrosoft Office > M icrosoft Project 2010

Click on Start > Click on Start

All Programs > M icrosoft Project
M icrosoft Office 2010

Untuk memulai Microsoft Project 2010

1. Klik pada t ombol st art yang berada di pojok kiri baw ah layar unt uk menampilkan St art
M enu
2. Pilih All Programs > M icrosoft Office > M icrosoft Project 2010 dari St art M enu unt uk
me-launching aplikasi

2. Lembar Kerja Microsoft Proyek 2010

I n this lesson, we will look at the different parts of the Projectscreen

et ika unt uk pert ama kali membuka M icrosoft Project , aplikasi t ersebut akan

K membuka file proyek baru yang kosong dengan nama Project 1 . Tampilan Gant t Chart
view merupakan t ampilan default -nya pada saat pert ama kali dibuka.

2| Page
 The Project
Ribbon

Gantt Chart
Active View
Pane
Indicator
Gantt Table
Pane

Gantt Table
Pane Zoom
Controls

M enu dan t oolbar pada sist em M icrosoft Project sebelumnya t elah digant i dengan Ribbon.
Ribbon didesain unt uk membant u dalam menemukan perint ah yang dibut uhkan dengan
t ujuan unt uk melengkapi t ugas. Dalam Ribbon, menu bar t elah digant i dengan Command
Tabs, yang secara default t erdiri at as: File, Task, Resource, Project , View and Format .

3| Page
 Quick Access
Toolbars

Project
Button

3. Memulai Proyek Baru

I n this lesson, you will learn how to create a new project .

K
et ika pert ama kali memulai M icrosoft Project , aplikasi akan membuka file project
baru dengan nama Project 1. Anda juga dapat mengeset projek unt uk membuka file
yang lama dengan melakukan klik pada File tab pada Ribbon, kemudian klik Option
unt uk menampilkan Project Options, kemudian klik Advanced Tab pada bagian kiri w indow
dan klik Open last file on Startup.

2. Klik Blank
Project

3. Klik New dalam

Backstage View

1. Klik
Create

Perint ah dokumen baru (t he new document command) berada di File tab dalam Ribbon
(Backstage view) . Anda juga dapat menggunakan keyboard dengan perint ah Ctrl + N unt uk
mempercepat proses pembukaan file baru.

4| Page
Untuk M embuat File Proyek Baru
1. Klik F ile tab pada Ribbon dan klik New.
2. Klik Blank project
3. Klik Create

Atau
Tekan Ctrl + N dalam keyboard secara bersamaan.

5| Page
4. Memasukkan Informasi Proyek (Project Information)

I n this lesson, you will learn how to enter information about a project .

nt uk memulai proyek baru dengan menggunakan M icrosoft Project , harus

U dit ent ukan t erlebih dahulu kapan proyek t ersebut akan dimulai dan kapan harus
selesai. Hal ini merupakan bat asan w akt u proyek. Bat asan w akt u proyek merupakan
bat as w akt u kapan proyek t ersebut dimulai dan kapan proyek t ersebut akan
berakhir. Unt uk menent ukan bat asan w akt u proyek dapat dilakukan pada Project
Information dengan langkah sebagai berikut : Pada Ribbon, klik Project dan kemudian pilih
Project Information.

1. Klik M enu
Project

2. Klik Project
Information

Dialog bok Project Information t erdiri at as Start date, Finish date, Schedule from , Current
date, Status date, Calender, dan Priority.

6| Page
Informasi yang dapat diperoleh dari kot ak dialog project informat ion adalah sebagai berikut :
1. Start date , merupakan penet apan t anggal dimulainya proyek
2. Finish date , merupakan penet apan t anggal berakhirnya proyek
3. Schedule from , merupakan penet apan pendekat an penjadw alan proyek. Dalam
schedule from t erdapat 2 (dua) pendekat an yang bisa digunakan, yait u Project Start
Date dan Project Finish Date . Project Start Date merupakan pendekat an penjadw alan
proyek dengan menent ukan t anggal mulai proyek kemudia menjadw alkan ke depan
dari t anggal t ersebut , sedangkan Project Finish Date merupakan pendekat an
penjadw alan proyek dengan menent ukan t anggal berakhirnya proyek t erlebih dahulu,
kemudian menjadw alkan ke belakang.
4. Current date , merupakan informasi t anggal berjalan. Informasi ini akan berubah secara
ot omat is sesuai dengan perubahan t anggal.
5. Status date , merupakan t anggal yang dit et apkan unt uk melaporkan w akt u, biaya, dan
kondisi proyek.
6. Calender , merupakan penet apan basis kalender yang digunakan dalam mengelola
proyek. Terdapat 3 (t iga) pilihan, yait u: St andard, Niight Shift, dan 24 Hours.
7. Priority, merupakan angka t ingkat kepent ingan apabila proyek t ersebut merupakan
mult iple proyek. Dapat dimasukkan Angka 1 (kurang pent ing) sampai angka 1000
(paling pent ing). Default nya t ert ulis 500.

Dapat juga diisikan informasi proyek t ambahan, sepert i nama, penulis, nama manajer, dan
nama perusahaan dari Project Information window dalam Backstage view .

7| Page
Klik File tab pada Ribbon dan kemudian klik Info. Klik Project Information di sebelah kanan
w indow s dan klik Advanced Properties dari menu. M asukkan informasi t ambahan yang
diinginkan.

8| Page
9| Page
10 | P a g e
5. Membuat Kalender Proyek (Project Calender)
I n this lesson, you will learn how to create and assign a project to a calendar

U
nt uk dapat menyelesaikan suat u proyek dengan t epat sesuai jadw al, dibut uhkan
perencanaan proyek yang baik dengan menggunakan jadw al kerja yang berperan
pent ing dalam menyusun perencanaan, program kerja, jam kerja, dan perhit ungan
salary. Unt uk menent ukan penggunaan sebuah jadw al kerja pada proyek menggunakan
kalender proyek dengan perint ah: Klik Project pada Ribbon, kemudian klik Change W orking
Time.

Kalender dalam M icrosoft Project t erdiri at as t iga kat egori,yait u:

1. Standard – This calendar reflect s a t radit ional w ork schedule of 8:00 am t o 5:00 pm w it h
an hour lunch break from 12:00 pm t o 1:00 pm .
2. 24 Hours – This calendar reflect s an around t he clock schedule w it hout any nonw orking
t ime.
3. Night Shift – This calendar reflect s a shift schedule of 11:00 pm t o 8:00 am, w it h an hour
for lunch

1. Klik M enu
Project

2. Klik Change
W orking Time

Kalender Jadwal Kerja Standar

Pada kalender st andar dalam aplikasi M icrosoft Project 2010 menggunakan sist em 5 hari
kerja, dengan jadw al libur adalah hari Sabt u dan M inggu. Jika ingin mengubah kalender

11 | P a g e
st andar menjadi 6 hari kerja dengan menjadikan hari Sabt u sebagai hari kerja, dengan jam
kerja 08:00 s.d. 12:00, maka langkah-langkah yang harus dilakukan adalah

1. Pada ribbon Project , klik ikon Change W orking Time

2. Pada bok dialog Change W orking Time, klik ikon W ork W eeks

3. Klik ikon detail unt uk memunculkan kot ak dialog details

12 | P a g e
4. Pada kot ak daft ar Select day(s), pilih Sat urday
5. Di sebelah kanan kot ak daft ar, pilih Set day(s) t o these specific working times
6. Selanjut nya let akkan sel akt if pada kolom From dan t ent ukan jam kerja dimulai pukul
08:00, sedangkan pada kolom To t ent ukan jam kerja diakhiri pukul 12:00

7. Klik OK unt uk menut up kot ak dialog t ersebut

8. Selanjut nya akan t erlihat kot ak t anggal pada hari Sabt u t elah berubah menjadi w arna
put ih dan perubahan t ersebut berlaku pada seluruh kalender
9. Kembali ke ke kot ak dialog Change W orking Time, klik OK

13 | P a g e
M enyusun Hari Libur

Beberapa hari dalam kalender proyek yang berjalan akan dit ent ukan sebagai hari libur dan
akan berbeda pada set iap bulannya, sert a disesuaikan dengan kondisi yang berlaku di suat u
negara, diant aranya:
1. Hari libur yang berlaku secara int ernasional, m issal Tahun Baru dan Hari Nat al
2. Hari libur yang berlaku secara nasional, misal Hari Kemerdekaan.
3. Hari libur yang berlaku hanya pada pihak perusahaan dan berlaku hanya pada saat
proyek sedang berlangsung

Sebagai cont oh, dit et apkan t anggal 17 Agust us 2013 sebagai hari libur nasional yait u Hari
Kemerdekaan Negara Republik Indonesia. Langkah-langkah yang dilakukan adalah

1. Pada ribbon Project , klik ikon Change W orking Time

14 | P a g e
2. Geser scroll bar unt uk memilih bulan Agustus 2013
3. Pilih t anggal 17 Agustus 2013 yang akan dit et apkan sebagai Hari Libur Kemerdekaan
Republik Indonesia
4. Klik Exceptions, let akkan sel akt if pada baris yang kosong dan ket ik Hari Kemerdekaan
Indonesia
5. Tekan Enter
6. Selanjut nya, akan t erlihat bahw a t anggal 17 Desember 2013 akan dit andai dengan
w arna merah dan bergaris baw ah

7. Klik OK unt uk menut up kot ak dialog

M enyusun Jam Kerja Lembur

Jam kerja lembur juga bisa dit et apkan sesuai dengan kebut uhan yang dihadapi oleh proyek
yang sedang dijalankan. M isal pada t anggal 8 M ei 2013 akan dijadw alkan jam kerja lembur.
Langkah-langkah yang dilakukan adalah

1. Pada ribbon Project , klik ikon Change W orking Time

2. Geser scroll bar unt uk memilih bulan M ei 2013
3. Pilih t anggal 8 M ei 2013 yang akan dit et apkan sebagai Kerja Lembur
4. Klik Exceptions, let akkan sel akt if pada baris yang kosong dan ket ik Kerja Lembur
5. Tekan Enter
6. Selanjut nya, akan t erlihat bahw a t anggal 8 M ei 2013 akan dit andai dengan w arna
merah dan bergaris baw ah

15 | P a g e
7. Let akkan kembali sel akt if pada baris Kerja Lembur, kemudian klik Details

8. Pada kot ak dialog pilih t ombol, W orking Times

9. Pada kot ak daft ar jam kerja, t ent ukan jam kerja yang t elah disesuaikan pada baris
pert ama, misalnya From 8:00 dan To 12:00, sert a pada baris kedua, misalnya From
13:00 dan To 19:00

16 | P a g e
10. Pada kelompok Recurrence Pattern, pilih Daily, sedangkan pada kot ak masukkan Every
days, t ent ukan berlaku 1 hari
11. Pada Range of Recurrence t ent ukan w akt u yang berlaku, pada kot a Start t ent ukan W ed
5/ 8/ 13 dan pada kot ak End By t ent ukan W ed 5/ 8/ 13
12. Klik OK untuk menutup kotak dialog

6. Pengelolaan Aktivitas

This lesson will guide you t hrough t he process of creat ing a Task List .

Entering Task

Tasks represent an individual it em of w ork t hat is necessary t o accomplish t he goals of a

project . Task informat ion includes a descript ion of t he t ask and t he est imat ed amount of
t ime you expect it w ill t ake t o complet e t he t ask, called t he t ask‟s duration. When ent ering
a durat ion int o a project file, Project w ill aut omat ically calculat e t he st art dat e and t he finish
dat e of t he t ask. A Task List is a complet e list of all t asks and subt asks necessary t o
complet e a project in order of occurrence. Tasks are ent ered int o t he row s of t he Gant t
Chart sheet pane.

17 | P a g e
To Create a Task List

1. Ensure t hat Gantt Chart view is t he act ive view (click t he Gant t Chart view but t on on
t he low er right –hand corner of t he screen).
2. Click in t he first blank row in t he Gant t Table under t he Task Name column.
3. Type t he name for t he t ask.
4. Press Tab.
5. Type in t he durat ion of t he t ask.
6. Click in t he next blank row under t he Task Name column and repeat st eps 3-5 for any
addit ional t asks

18 | P a g e
19 | P a g e
Editing Task

As you w ork w it h M icrosoft Project , you w ill inevit ably need t o modify t asks t hat you have
ent ered, perhaps alt ering t he t ask descript ion or changing t he t ask durat ion. You can change
exist ing t asks direct ly in t he Gant t Chart Table. To change t he descript ion, click in t he cell
you w ant t o modify and t ype in t he new t ext . The exist ing t ext w ill be replaced by w hat you
t ype.

Anot her w ay t o modify t ask informat ion is from t he Task Information Dialog Box, from
w here you can ent er, review or change det ailed informat ion about a t ask. Task name and
t ask durat ion informat ion are locat ed under t he General t ab of t he dialog box. To display
t he Task Informat ion dialog box, select t he t ask whose informat ion you w ant t o change and
click t he Information button on t he Propert ies group of t he Task Ribbon.

20 | P a g e
Double-clicking a t ask w ill also display t he Task Informat ion dialog box.

To Edit Task Information using the Entry Bar

1. Click t he cell of t he t ask w hose informat ion you w ish t o change.
2. M ake any changes.
3. Press Enter w hen finished.

To Edit Task Information using the Task Information Dialog Box

1. Click anyw here in t he row of t he Task w hose informat ion you w ish t o change.
2. Click t he Task tab on t he Ribbon.
3. Click t he Information button on t he Propert ies group of t he Ribbon. The General Tab w ill
display from w here you can change t he Task Name and Task Durat ion

4. M ake any desired changes.

5. Click OK.

21 | P a g e
22 | P a g e
23 | P a g e
24 | P a g e
Inserting and Deleting Task

When creat ing a t ask list , it is very likely t hat you w ill forget t o ent er essent ial t asks t he first
t ime t hrough. You can add addit ional t asks t o t he t ask list at any t ime by select ing t he row
above w hich you w ant t o insert a new t ask and clicking t he Task button on t he Insert group
of t he Task Ribbon. You can also press t he Insert key t o add a new blank t ask row or right -
click and choose New Task from t he cont ext ual m enu.

25 | P a g e
To permanent ly remove a t ask from t he t ask list , select t he row for t he t ask you w ish t o
delet e, right -click and select Delete Task from t he cont ext ual menu. You can also press t he
Delete key on your keyboard.

To Insert a New Task

1. Click t he ID Field of t he t ask above w hich you w ish t o insert a new t ask.
2. Click t he Task button on t he Insert group of t he Task Ribbon.
Or
Press t he Insert (or Ins) key on your keyboard
Or
Right -click and choose New Task from t he cont ext ual menu.

To Delete a Task
1. Click t he ID Field of t he t ask you w ant t o delet e.
2. Press t he Delete key on your keyboard.
Or
Right -click and choose Delete Task from t he cont ext ual menu

26 | P a g e
Adding a Project Summary Task

A Project Summary Task is t he t op-level t ask in your t ask list . It usually represent s t he goal
or desired out come of your project . When displayed, it appears as t he first t ask in your
project plan w it h an ID of 0 as it is t he goal of t he project , not a t ask in it self.

The Project Summary Task is not displayed by default , but t hrough t he Advanced sect ion of
t he Options dialog box. When t he Project Summary Task is displayed, all ot her t asks in t he
t ask list are represent ed as subt asks

27 | P a g e
To Show the Project Summary Task
1. Click t he File tab on t he Ribbon.
2. Click Options in Backst age view .
3. Click Advanced in t he left pane.
4. Under t he Display options for this project area, check t he Show Project Summary Task
checkbox
5. To hide t he Project Summary Task, clear t he Show Project Summary Task checkbox.
6. Click OK.
7. 7. If desired, you can change t he name of t he Project Summary Task using t he Task
Informat ion dialog box

28 | P a g e
29 | P a g e
Outlining Task

It is helpful t o organize your t asks int o a hierarchical st ruct ure. To est ablish a hierarchical
st ruct ure, you indent or outdent t asks, w hich organizes your t ask list s int o summary t asks
and subt asks. When a t ask is indent ed, it t hen becomes a subtask and t he t ask t hat
precedes t he indent ed t ask(s) becomes a summary task. Out dent ing moves a t ask up one
level in a hierarchy. You can indent or out dent t asks using t he Indent or Outdent buttons on
t he Schedule group of t he Task Ribbon

You can collapse a summary t ask (t hus hiding it s subt asks) by clicking on t he minus (-)
symbol t hat appears t o t he left of t he t ask name. To expand a summary t ask (t hus displaying
it s subt asks), click on t he plus (+) symbol t o t he left of t he t ask name.

To Outline a Task List

1. Select t he t ask or t asks t o be out lined.
2. Click t he Indent button on t he Schedule group of t he Task Ribbon t o demot e t he
select ed t ask(s).
3. Click t he Outdent button on t he Schedule group of t he Task Ribbon t o prom ot e t he
select ed t ask(s)

To Collapse or Expand a Summary Task

1. Click t he minus (-) symbol next t o a summary t ask t o collapse it (t he minus symbol t hen
t urns int o a plus symbol).
2. Click t he plus (+) symbol next t o a summary t ask t o expand it .

30 | P a g e
31 | P a g e
32 | P a g e
Adding a Recurring Task

Recurring Tasks are t asks t hat occur at regular int ervals, such as a project st at us meet ings or
t he dist ribut ion of st at us report s. To help manage such t asks, ent er it as a recurring task in
your t ask list . The t ask w ill appear as a summary task w it h each inst ance list ed underneat h it
as subt asks. You can specify a specific number of occurrences of t he recurring t ask or a
specific dat e w hen t he t ask w ill t erminat e. The symbol next t o a t ask denot es it as a
recurring t ask.

To ent er a recurring t ask, click t he Task button arrow on t he Insert group of t he Task Ribbon
and ent er t he appropriat e informat ion in t he Recurring Task Informat ion dialog box.

33 | P a g e
To Add a Recurring Task

1. Click in t he row w here you w ish t o insert a recurring t ask.

2. Click t he Task t ab on t he Ribbon.
3. Click t he Task but t on arrow and choose Recurring Task from t he menu t o display t he
Recurring Task Informat ion dialog box.
4. Type a name for t he t ask in t he Task Name box
5. Select t he desired recurrence pattern opt ions for t he t ask.
6. Ent er in t he St art dat e for t he t ask.
7. Select t he End After radio but t on and t ype t he number of occurrences for t he t ask
Or
Select t he End by radio but t on and ent er in an ending dat e.
8. Click OK.

34 | P a g e
35 | P a g e
Displaying W BS Codes

The Work Breakdown Structure (WBS) is the hierarchical structure used to display the tasks in
your project. E ach task in your task list has its own, unique WBS code that defines its position in
the task hierarchy. The Project Summary Task has a WBS Code of 0. The first summary task is
assigned the number 1. In our E xcel Manual example, the Preparation Phase task is assigned a
WBS code of 1. As the Buy E xcel Software task and Draw up Writer Contract entries are
subtasks of the

Preparation Phase, they are assigned a WBS code of 1.1 and 1.2 respectively.
By default, the WBS code column is hidden from view. To view WBS Codes, display the
Column Definition dialog box.

To DisplayW BS Codes

1. Select the column heading to the left of which you want to insert a new column.
2. Right-click and choose Insert Column from the contextual menu.
3. Select WBS from the field list.
4. Click OK

36 | P a g e
37 | P a g e
7. Penjadwalan Aktivitas

Task Relationship

When creat ing a project plan, it is essent ial for you t o det erm ine t he sequence for doing
t asks in your project . Even t hough you may have ent ered all of your t asks int o a t ask list , you
st ill need t o know how long t he project w ill t ake. In order t o do t his, you must det ermine
task relationships, w hich is accomplished by linking tasks.

Linking t asks allow s you t o specify t he relat ionship bet w een t asks t hus est ablishing task
dependencies bet w een t asks – t hat is t o say, t he sequence in w hich t asks are t o be
performed in your project . Wit hout linking t asks, all your t asks w ould be scheduled t o begin
on t he Project st art dat e. In t he real w orld how ever, w e know t hat cert ain t asks must begin
or finish before anot her can begin or finish. For inst ance, w e could not very w ell proofread a
coursew are manual unt il it has been w rit t en first ! Before learning how t o link t asks, it is first
helpful t o underst and t ask relat ionships

In Project , a t ask t hat must st art or finish before anot her t ask can begin is called a
predecessor task. A t ask t hat cannot begin or end unt il anot her t ask st art s or complet es is
called a successor task. Whenever t he st art or finish dat e of a t ask depends on anot her t ask,
a precedence relationship exist s bet w een t he t w o t asks.

Tasks can have one of four types of relationships:

Finish-to-start dependency (FS) – Task 2 cannot begin unt il t ask 1 is complet ed. In t he
example of creat ing an Excel manual, you m ust first inst all t he soft w are before t he
coursew are w rit ing can begin. This is t he most common t ype of t ask dependency and is t he
default relat ionship w hen you link t w o t asks.

Start-to-start dependency (SS) – Task 2 begins w hen t ask 1 st art s. Using our Excel manual
example, you w ould begin creat ing t he lesson files t he same t ime you begin w rit ing t he class
cont ent .

38 | P a g e
Finish-to-finish dependency (FF) – Task 2 cannot finish unt il Task 1 finishes. For inst ance, if
w e hire a w rit er for 5 w eeks, t hen any t ask relat ing t o w rit ing course cont ent must finish
before his cont ract is up.

Start-to-finish dependency (SF) – Task 2 cannot finish unt il Task 1 st art s. For example,
proofing a soft w are manual cannot finish unt il all of t he cont ent has been w rit t en.

You can easily review and adjust t ask dependences t o ensure t hat your project is scheduled
t he w ay you w ant and t o ensure t hat you meet any project deadlines.

Linking Task

When linking t asks, t he default relat ionship is a finish-t o-st art t ask relat ionship – t hat is t o
say, one t ask must finish before anot her t ask begins. You link t asks by select ing t he tasks
you w ish t o link and t hen clicking t he Link Task Button on t he Schedule group of t he Task
Ribbon. You can also link t asks using t he Ctrl + F2 keyst roke combinat ion. When t asks are
linked, a blue link line is displayed in t he chart pane

39 | P a g e
To select a series of adjacent tasks, select t he first t ask, hold dow n t he Shift key and t hen
select t he last t ask in t he series. To select non-adjacent t asks, hold dow n t he Ctrl key as you
select .

To unlink tasks, select t he t asks you w ish t o unlink and t hen click t he Unlink Button on t he
Ribbon.

To Link Tasks
1. Ensure t hat you are in Gantt Chart view .
2. Select t he t asks in t he sheet pane t hat you w ish t o link.
3. Click t he Link Tasks icon on t he Schedule group of t he Task Ribbon

To Unlink Tasks
1. Select t he t asks in t he sheet pane t hat you w ish t o unlink.
2. Click t he Unlink Tasks but t on on t he Schedule group of t he Task Ribbon.

Changing Task Dependency

You can change a t ask‟s dependency, predecessors, lag time or lead time from the
Predecessors tab of t he Task Information dialog box. To change t he t ype of t ask
dependency, click t he Type drop-dow n list for t he relat ionship you w ish t o change and
select t he new dependency t ype. You can modify t he predecessor or even creat e a new
relat ionship by clicking t he Task Name field and select ing a new predecessor.

40 | P a g e
To Change Task Dependency

1. Right -click in t he Task Name field for t he t ask you w ish t o modify and select
Information from t he list
Or
2. Select t he t ask w hose informat ion you w ish t o m odify and click t he Information but t on
on t he Task Ribbon.
Or
3. Double-click t he Task Name field for t he t ask w hose informat ion you w ish t o modify.
4. Click t he Predecessors tab on t op of t he Task Informat ion dialog box.
5. Click t he Type drop-dow n box for t he Task w hose relat ionship dependency you w ish t o
change.
6. Select t he new
7. Click OK

Splitting Task

Unfort unat ely, not everyt hing alw ays goes as planned and you my find t hat you need t o
interrupt work on a particular task and resum e it at a lat er dat e. Perhaps one of your
resources is unavailable for a specific amount of t ime or t he resource needs t o be devot ed
t emporarily t o a higher priorit y t ask. Project allow s you t o Split a t ask int o one or more
part s. That is t o say, st op w ork on a t ask at a part icular dat e and resume w ork on t hat t ask
on a lat er dat e. A t ask can be split mult iple t imes and can be easily rescheduled by dragging
t he t ask segment t o t he desired dat e on t he Gant t Chart .

41 | P a g e
To Split a Task
1. Click t he Gantt Chart button on t he low er right corner of your screen t o ensure t hat you
are in Gant t Chart view .
2. Click t he Split Task button on t he Schedule group of t he Ribbon

3. On t he t ask‟s Gantt bar, move your mouse pointer over the bar until the desired date is
displayed in t he yellow st at us box. Click on t he bar w it h your mouse w hen t he desired
dat e displays.
4. Drag t he second segment of t he bar t o t he dat e where you w ant t o resume w ork on t he
t ask.
5. To remove a split , drag t he second segment t o t he left unt il it t ouches t he first bar
segment.

42 | P a g e
43 | P a g e
Setting Task Type

M icrosoft Project schedules t he t asks in your project based upon t he type of t ask. The
durat ion of t asks ent ered in M icrosoft Project is det ermined by t he formula Duration =
W ork/ Resource Units. For example, if you w ere to add ext ra resources t o a t ask, you w ould
have t o eit her decrease t he durat ion if t he w ork st ays const ant or increase t he w ork on t he
t asks if t he durat ion st ays const ant . If w e had 2 people (Resource Unit s) w orking for 36
hours (Work), t he Durat ion of t he t ask w ould be 18 hours

W ork defines t he scheduled effort for a t ask and is measured in in-person hours for each
person assigned t o a t ask. For inst ance if it t akes 16 hours for one person t o proofread a
coursew are manual, t hen 16 hours is scheduled for t his t ask. The formula for Work is:
Duration x Units = W ork. Units refer t o t he t ime a resource spends on a t ask. In t he
example above, if it t ook t w o people 8 hours t o paint a house, t hen t he w ork necessary t o
complet e t he t ask w ould be 16 hours.
Set t ing t he task type allow s you t o cont rol how M icrosoft Project schedules your t ask by
making one of t he variables – Durat ion, Work or Unit s unchangeable. There are t hree t ask
t ypes:

o Fixed Duration – t he durat ion w ill not change, even if you add resources t o or remove
resources from a t ask
o Fixed W ork – t he t ot al w ork t hat is t o be accomplished does not change. If t he durat ion
of t he t ask is changed or t he number of resources is changed, t he t ot al w ork remains
t he same. Adding more resources w ill short en t he durat ion, but not t he w ork.
o Fixed Units (t he default ) – t he quant it y of unit s necessary t o perform t he t ask does not
change. Adding addit ional resources w ill reduce t he durat ion of t he t ask.

To Change the Task Type

1. Click t he Gantt Chart button on t he low er right corner of your screen t o ensure t hat you
are in Gant t Chart view .
2. Right -click in t he Task Name field for t he t ask you w ish t o modify and select
Information from t he list
Or
Select t he t ask w hose informat ion you w ish t o modify and click t he Information but t on
on t he Task Ribbon.
Or
Double-click t he Task Name field for t he t ask w hose informat ion you w ish t o modify.
3. Click t he Advanced t ab.
4. Click t he Task Type drop-dow n arrow and choose t he desired t ask t ype

44 | P a g e
Setting M ilestone Tasks

M ilestone is a t ask of zero durat ion t hat is used t o ident ify a significant event in t he life
cycle of a project . Oft en, m ilest ones are used t o mark t he complet ion of a part icular phase
of a project , such as t he complet ion of t he preparat ion phase of a project . As a milest one
normally does not represent any w ork but rat her is used as an indicat or, it is represent ed
w it h zero (0) durat ion.

To creat e a milest one, simply set t he t ask durat ion t o 0. A milest one marker (a diamond)
along w it h t he milest one dat e displayed in t he Gant t Chart

To Create a Milestone

1. Click the Gantt Chart button on the lower right corner of your screen to ensure that you
are in Gantt Chart view.
2. Type 0d in the duration field for the task you wish to set as a milestone.
3. Press enter to confirm the entry.

W orking in Network Diagram View

Network Diagram View displays a complet e graphical represent at ion of your t asks and t ask
links in a flow chart format . Task informat ion is displayed in individual boxes called nodes
w it h lines connect ing t he nodes t o represent relat ionships bet w een t asks. Each node
displays t he t ask name, t he st art dat e, t he end dat e, t he t ask durat ion and t he t ask ID.
Summary Tasks are represent ed as a parallelogram and subt asks are represent ed by
rect angles. This view is ideal for focusing on relat ionships bet w een t asks as w ell as
modifying t ask dependencies.

45 | P a g e
To W ork in Network Diagram View
1. Click t he View tab on t he Ribbon.
2. Click t he Network Diagram but t on on t he Task View s group of t he Ribbon.

46 | P a g e
8. Resources
The management of resources is a major feat ure of M icrosoft Project . It is possible t o see
how each one is being used and det ermine t he t imes w hen t hey are under or over ut ilised.
The system can adjust t he project t o eliminat e over allocat ion of a resource. We can t hink of
resource dat a being st ored in a Project file, w hich is t he part ner t o t he t ask Project file. The
M icrosoft Project syst em merges t he dat a in t he t w o Project files t o provide t he facilit ies
t hat are available. There are a number of w ays we can view t he resources, as t he follow ing
t opics w ill show

Define The Resources

When you build a large pool of resources⎯for example, 200 em ployees⎯t he best place t o
ent er t his informat ion is in t he Resource Sheet . If t here are only a few resources w orking on
t he project , how ever, you might ent er t hem “ on t he fly” using t he Resource Assignment
dialog box.

Resource types
There are only 3 t ypes of resources -mat erial–w ork- and -cost .

M aterial
These are physical resources t hat you need t o complet e your project such as t ables chairs,
bricks and M ort ar once t hey are bought t hey are used in t he project t here is no furt her cost
accruing t o t hem (unless t hey need maint enance w hich w ould be a separat e
resource)

W ork
How ever, if t he t ables and chairs are rent ed t hey may become a w ork resource because
t hey need regular payment s on a hourly, daily, w eekly basis as you pay for st aff. All it ems or
people you pay for on a regular basis w ould really be ent ered as w or t o enable t he proper
cost ing’s t o be carried out

47 | P a g e
Reviewing And Navigating The Resource Sheet

The Resource Sheet cont ains an array of required fields for ent ering resources. A Resource
Sheet is illust rat ed below :

 Resource Name , diisi dengan nama-nama resource, misal t ukang bat u, t ukang kayu,


semen, pasir
Type , digunakan unt uk memasukkan t ipe resource dengan 2 nilai pilihan, yait u Work
dan M at erial. Sumber daya manusia dikat egorikan w ork, sedangkan sumber daya


mat erial dikat egorikan mat erial.
M aterial Label, diisi dengan sat uan unt uk resource yang bert ipe mat erial. M isal semen


adalah sak.
Initials, merupakan singkat an dari nama-nama resource pada kolom resource name,


misalnya Tukang Bat u disingkat menjadi TB.


Group, digunakan unt uk memasukkan nama kelompok dari sumber daya t ersebut .
M ax. Units, digunakan unt uk menent ukan jum lah resource yang digunakan selama


proyek t ersbebut berlangsung
Std. Rate, diisi dengan harga sat uan unt uk masing-masing resource yang berlaku unt uk


semua jenis resource, baik w ork maupun mat erial.


Ovt. Rate, diisi dengan t arif lembur dari resource name t ersebut .


Cost/ use, diisi khusus unt uk resource yang melakukan pekerjaan secara borongan.
Accrue At, berisi jenis pembayaran dari resource t ersebut . Unt uk jenis pembayaran
t erdapat 3 (t iga) macam:
a. Start, jenis pembayaran yang diberikan saat pekerjaan akan dim ulai
b. End, jenis pembayaran yang diberikan set elah resource t ersebut melakukan
pekerjaan dan diberlakukan unt uk sumber daya m anusia
c. Prorate, jenis pembayaran yang diberikan berdasarkan persent asi pekerjaan yang


t elah diselesaikan oleh resource t ersebut .
Base Calender, berisi jenis kalender yang digunakan oleh sumber daya t ersebut . Jenis


kalender t ersebut adalah 24 hours, Night Shift , dan St andard
Code, diisi dengan kode masing-masing resource.

To Add Resources To The Resource Sheet:

1. From t he VIEW but t on on t he TASK ribbon, choose RESOURCE Sheet .

2. In t he RESOURCE NAM E cell, t ype t he Resource Name.

48 | P a g e
3. Press TAB
4. Ent er t he TYPE and Press TAB
5. Ent er t he label in t he mat erial COLUM N if it is a m at erial resource and cont inue across
t he row unt il you have ent ered all t he informat ion needed for t he resource as described
previously.
6. Press ENTER t his brings you t o a new row
7. Press HOM E t his brings you t o t he beginning of t hat row t o st art again for a new
resource.
8. Repeat st eps 2 t hrough 7 for each resource.

9. Project Owner Estimate

Project Ow ner Est imat e dalam M icrosoft Project 2010 dapat dilihat dalam Tot al Cost . Unt uk
menampilkan Tot al Cost , klik View-Table-Cost.

Yang dimaksud dengan biaya t et ap (Fixed Cost ) adalah perhit ungan bahan/ mat erial yang
digunakan dalam suat u t ask/ pekerjaan. Sebagai cont oh dalam melakukan pekerjaan cor
pondasi dibut uhkan berbagai mat erial sepert i penyekat , paku, bekist ing, pasir, semen, bat u,
dan lain-lain. Selain it u yang t ermasuk ke dalam fixed cost adalah biaya perizinan, biaya
akomodasi, biaya t ransport asi, dan biaya pembeliaan alat . Karena kompleksnya unsur yang
mempengaruhi biaya t et ap, maka biaya t et ap dilakukan diluar M S Project , misalnya M S
Excel, sehingga biaya yang dikeluarkan adalah biaya yang t elah melalui proses perhit ungan
secara past i.

Selain it u pada umum nya biaya t et ap t idak mempengaruhi cepat at au t idak selesainya suat u
pekerjaan Berikut ini adalah kolom-kolom yang t erdapat pada t abel cost :
 Fixed Cost Accrual menent ukan bent uk pembayaran biaya t et ap, apakah pada saat
dimulai (st art ), pembayaran berkala / diangsur (prorat ed), at au set elah pekerjaan
selesai (end). Dalam cont oh diat as pekerjaan inst alasi digant i dengan end karena

 Tot al Cost = Fixed Cost +Resource Cost (gaji kali jam kerja).
merupakan pekerjaan borongan.

 Baseline = Tot al Cost apabila disim pan dalam Baseline dan menjadi kont rol pengeluaran
biaya (dibahas selanjut nya)

49 | P a g e
 Act ual =adalah biaya nyat a yang secara ot omat is t erjadi karena hasil t racking (dibahas


selanjut nya)
Remaining = sisa biaya yang masih diperlukan (Tot al Cost – Act ual Cost )

10. Baseline

Baseline digunakan sebagai rencana proyek dan unt uk bahan perbandingan ant ara rencana
proyek yang dibuat , baik schedule maupun biaya dengan kenyat aan di lapangan sert a hasil
yang dicapai. Baseline t idak hanya dapat dilakukan pada sat u proyek penuh saja, melainkan
juga dapat dilakukan pada t ask-t ask t ert ent u yang sudah siap unt uk segera dilaksanakan.
Langkah-langkah membuat baseline:
1. Pilih Ribbon Project kelompok Schedule, klik ikon Set Baseline, sehingga akan t ampil
kot ak dialog sepert i t ampak pada gambar berikut :

2. Akt ifkan pilihan Entire Project unt uk penyimpanan baseline pada sluruh file proyek
3. Klik Ok

Unt uk melakukan penyim panan baseline pada t ask-t ask t ert ent u, ikut i langkah-langkah
sebagai berikut :
1. Pilih Ribbon Project kelompok Schedule, klik ikon Set Baseline, sehingga akan t ampil
kot a dialog save baseline sepert i berikut

50 | P a g e
2. Klik at au blok t ask-t ask yang ingin disimpan sebagai baseline
3. Akt ifkan pilihan Selected task unt uk penyimpanan baseline at as seluruh t ask yang t elah

 To all summary task. Apabila pilihan ini diakt ifkan makan t ask yang dipilih adalah
diblok sebelumnya.

summary t ask sehingga hanya summary t ask t ersebut yang akan disimpan sebagai

 From subtask into selected summary task(s). Apabila pilihan ini diakt ifkan makan
baseline

subt ask juga akan ikut t ersimpan sebagai baseline

4. Klik OK

11. Update Task

2. Klik Ribbon 1. Klik M ark

Task on Track

1. M emperbarui Start Date dan Finish Date, berikut langkah-langkah memasukkan Act ual

 Klik at au pilih bagian t ask yang akan diubah dan kemudian pilih Ribbon Task
Dat e suat u proyek.

Kelompok Schedule – M ove on Track – Update Task, sehingga muncul kot ak dialog
Update Task.

51 | P a g e
 

Pilih dan ubah-ubah nilai pada t anggal Actual Start dan Actual Finish
Klik OK

2. M emasukkan Persentase Selesainya Task, berikut langkah-langkah memasukkan

 Klik at au pilih bagian t ask yang akan diubah dan kemudian pilih Ribbon Task
present ase selesainya t ask:

Kelompok Schedule – M ove on Track – Update Task, sehingga muncul kot ak dialog
Update Task.



Pilih dan ubah-ubah pada % complete
Klik OK

12. Rescheduling Uncompleted Task

Unfort unat ely, t hings do not alw ays go as planned during t he course of a project , and w ork
on a specific t ask or even for t he ent ire project may be int errupt ed. When t his occurs, you
can have Project reschedule t he remaining w ork t o rest art aft er a specific dat e, called t he
rescheduled date

52 | P a g e
Tasks w it h no w ork performed on t hem w ill be rescheduled t o begin aft er t he rescheduled
dat e. Tasks t hat have w ork performed before t he rescheduled dat e w ill be split and t he
remaining w ork w ill be scheduled aft er t he rescheduled dat e.

To Reschedule Uncompleted Tasks

1. Sw it ch t o Gant t Chart view .
2. Select t he t ask t hat you w ant t o reschedule. To reschedule all remaining tasks, do not
select any t asks.
3. Click t he Project tab on t he Ribbon.
4. Click t he Update Project but t on on t he Status group of t he Ribbon.
5. Select t he Reschedule uncompleted work to start after radio but t on.
6. Select t he Entire Project or Selected Tasks radio but t on.
7. Type in t he rescheduled dat e in t he date box.
8. Click OK.

13. Variance

Aft er t he onset of your act ual project , you will at some point wish t o compare t he difference
bet ween your baseline dat a and t he act ual dat a t o obt ain a m ore complet e pict ure of t he
progress of your project . To do t his, display t he Variance Table . In t his t able, you can view your
baseline st art and finish dat es and compare t hem wit h t he act ual st art and finish dat es. The
Variance fields in t his t able are calculat ed as follows: Variance = Actual – Baseline . If t he value is
negat ive, t he t ask finished earlier t han scheduled. If t he value is posit ive, t he t ask st art ed or
finished lat er t han scheduled.

53 | P a g e
 Variance = Actual
- Baseline

When referring t o t ask informat ion, Variance is usually t he difference bet w een t he baseline
st art dat e and t he act ual st art date. Variances can also be displayed for resource and t asks
costs by displaying t he Cost Table.

To Display Date Variances

1. Sw it ch t o Gant t Chart view .

2. Click t he View tab on t he Ribbon.
3. Click t he Tables but t on on t he Ribbon and choose Variance from t he menu t o display
t he Variance t able.
4. Review t he date values in t he Finish, Baseline St art , Baseline Finish, St art Variance and
Finish Variance fields.
5. To display Cost Variances, click t he Tables but t on on t he Ribbon and choose Variance .
6. Review t he cost values in t he Cost , Baseline Cost , Variance, Act ual Cost , and Remaining
field

54 | P a g e
14. Project Report

Unt uk menampilkan laporan projek, ikut i langkah-langkah sebagai berikut :

1. Pilih Ribbon Project kelompok Report, klik ikon Report s, sehingga akan t ampil kot ak
dialog sepert i t ampak pada gambar berikut .

55 | P a g e
2. Set elah t ampil kot ak dialog Report , pilih t ampilan yang diinginkan dan klik t ombol
Select . M isal pilih overview , sehingga akan t ampil sebagai berikut .

3. Pilihlah salah sat u pilihan yang t ersedia dan kemudian klik t ombol Select , sehingga akan
t ampil hasil laporan sesuai pilihan.
4. Unt uk menut up laporn dan melihat laporan yang lain, Klik Close

Jenis-jenis laporan yang berisi laporan proyek :

1. Overview : Laporan Projek Secara Keseluruhan
• Project Summary
– Ringkasan proyek secara global
• Top Level Tasks
– Daft ar pekerjaan ut ama
• Critical Tasks
– Daft ar pekerjaan yang berada pada lint asan krit is
• M ilestone
– Daft ar t asks yang menjadi milest one
• W orking Days
– Jadw al kerja yang dipakai

56 | P a g e
2. Current Activities : Laporan Kegiatan Proyek pada saat laporan dibuat
• Unstarted Tasks
– Pekerjaan yang belum dikerjakan
• Tasks Starting Soon
– Pekerjaan yang akan dimulai (pekerjaan yang belum dimulai)
• Tasks In Progress
– Pekerjaan yang akan segera dimulai
• Completed Tasks
– Pekerjaan yang t elah selesai 100% dilaksanakan
• Should Have Started Tasks
– Pekerjaan yang seharusnya t elah dimulai sesuai schedule
• Slipping Tasks
– Pekerjaan yang melew at i t anggal yang seharusnya t elah dimulai t et api
sampai saat ini belum dimulai

3. Cost : Laporan tentang pemakaian biaya proyek

• Cash Flow
– Keluar masuknya biaya dari sebuah proyek
• Budget
– Laporan keuangan proyek (diurut kan dari biaya yang t erbesar sampai yang
t erkecil)
• Overbudget Tasks
– Laporan keuangan dari pekerjaan yang melebihi anggaran
• Overbudget Resources
– Laporan keuangan dari resource yang kelebihan beban

• Earned Value
– Laporan keuangan t ent ang nilai t ambah sebuah proyek

4. Assignment : Laporan tentang pemakaian sumber daya proyek

• W ho Does W hat
– Laporan t ent ang sumber daya sert a t ugas masing-masing sumber daya
• W ho Does W hat W hen
– Laporan t ent ang masing-masing resources, bekerja pada kegiat an apa saja
dan t anggal bekerja
• To Do List
– Laporan t ent ang daft ar kegiat an yang dibebankan pada masing-masing
resource (biasanya mingguan)
• Overallocated Resources
– Laporan daft ar resources yang mengalami kelebihan bebab kerja
5. W orkload : Laporan tentang beban yang ditanggung masing-masing sumber daya

57 | P a g e
 • Tasks Usage
– Laporan t ent ang daft ar pekerjaan dengan sumber dayanya dan beban kerja
dalam jam per minggu
• Resources Usage
– Laporan perincian penggunaan masing-masing rsource dengan menampilkan
nama-nama kegiat an, di mana resource t ersebut bekerja

15. Printing Report

Before you’re finally ready t o print your report , you may first want t o set some Printer Options.
For inst ance, you may need t o specify which print er t o use, t he num ber of copies t o be print ed,
or even designat e Project t o print only a specific page range or dat e range of your report . Print er
opt ions you can set will vary, depending on t he t ype of print er you are using. If you wish t o set
print opt ions, you will need t o display t he Print Dialog Box.

To Set Printer Options

1. Click t he Project tab on t he Ribbon.

2. Click t he Reports but t on on t he Report s group of t he Ribbon.
3. Click t he desired report cat egory and t hen click t he Select but t on.
4. Click t he report you w ant and t hen click t he Select but t on t o display a preview of t he
report in Backst age view .
5. If necessary, choose w hich print er t o use from t he Name drop-dow n list .
6. To print a specific range, ent er t he page numbers in t he From and To boxes in t he Print
Range area.
7. To print more t han one copy of a report , ent er t he value in t he Number of copies box in
t he Copies area.

58 | P a g e
8. To print a specific t ime range, ent er t he beginning and ending dat es in t he From and To
combo boxes under t he Set t ings area.
9. Click t he Printer Properties link for addit ional print er opt ions (available propert ies w ill
vary according t o print er).
10. Click OK t o send t he document t o t he print er.

59 | P a g e
16. Creating Visual Report

Visual Reports allow you t o view t he dat a from your Project file in a Pivot Table in M icrosoft
Excel or in M icrosoft Visio. Project includes six cat egories of Visual Report s t hat you can creat e:
Task Usage, Resource Usage, Assignment Usage, Task Summary, Resource Summary, and
Assignment Summary. To view a det ailed explanat ion of each cat egory, use t he Help syst em and
search for Creat e a Visual Report .

When generat ing a Visual Report , you can choose w hich fields t o add (including any cust om
fields you have creat ed) and easily modify t he report ’s display from w it hin Visio or Excel.
Project provides several predefined report t emplat es t o get you st art ed.

To creat e a Visual Report , click t he Visual Reports but t on on t he Report s group of t he

Project Ribbon, choose t he report t emplat e you w ant t o use from t he All tab, click eit her t he
M icrosoft Office Excel or M icrosoft Office Visio checkbox and t hen click View. The report
w ill display in t he select ed application

60 | P a g e
To Create a Visual Report

1. Click t he Project tab on t he Ribbon.

2. Click t he Visual Reports but t on on t he Report s group of t he Ribbon.
3. Click t he All tab.
4. To view only t hose visual report t emplat es t hat use Excel or use Visio, clear t he check box
next t o t he t emplat e you do not w ish t o use.
5. Click t he report t emplat e you w ish t o use.
6. To specify t he level of usage dat a t o include in t he report , click t he drop dow n list and
choose Years, Quart ers, M ont hs, Weeks or Days from t he list .
7. Click t he check box next t o M icrosoft Office Excel or M icrosoft Office Visio.
8. Click View . The report w ill display in eit her Excel or Visio

61 | P a g e
62 | P a g e
17. Customizing Field - 1
If you w ant t o display specific informat ion about your project , t ailor-made t o your needs,
t hen Project provides a variet y of fields t hat are cust omizable t o your requirement s. Cust om
fields can be insert ed and displayed in any sheet view . Project ‘s cust omizable fields and t he
sort of dat a t hat can be used are:

Custome Field
1. Cost1 t o Cost10 fields can cont ain currency dat a.
2. Date1 t o Date10 fields can cont ain dat es
3. Duration1 t o Duration10 fields can cont ain durat ion or w ork values.
4. Finish1 t o Finish10 fields can cont ain finish dat es or ot her dat es.
5. Flag1 t o Flag20 fields can cont ain yes/ no flags.
6. Number1 t o Number20 fields can cont ain numeric values.
7. Start1 t o Start10 fields can cont ain st art dat es or ot her dat es.
8. Text1 t o Text30 fields can cont ain any t ext .
9. Outline Code1 t o Outline Code10 fields (int roduced in Project 2002) can cont ain an
alphanumeric code you define t o represent a hierarchical st ruct ure of t asks or
resources.

Insert Custom Field

M isal ingin memberi t anda pada bar chart , jika dikerjakan oleh pekerja maka bar chart akan
berw arna hijau

First w e need t o ident ify t asks assigned t o Pekerja by using a Flag field - click on t he add
new coloumn

63 | P a g e
In t he Column Definition dialog, you w ill see all the fields t hat can be applied t o t he Gantt
Chart view – w hilst you are t here, scroll t hrough t o see all t he cust omizable fields e.g. Text1
t o Text30 , et c. Then select t he Flag1 field.

Unt uk mendefinisikan kolom Flag1 dan digant i oleh nama “ Pekerja ” , klik mouse kanan pada
kolom Flag1, kemudian pilih Field Setting. M asukkan Pekerja pada Title, lalu klik OK

Gant i ket erangan No menjadi Yes pada kolom Pekerja

64 | P a g e
Changing the Gantt Chart

To finish, from t he Gantt Chart view , Format/ Bar Styles… make a copy of t he Task bar (Do
t his by clicking “ Task” and t hen Cut Row t o put a copy on t he clipboard, and Paste Row t o
put it back again.

65 | P a g e
Now scroll t o t he bot t om and in t he next blank space click Paste Row again. M ake duplicat e
t he t ask name t o Pekerja , t hen change it s colour t o Green and a solid pat t ern. Click in t he
Show For… Tasks cell, click t he drop-dow n arrow and select Flag1 , OK.

All bars for Fred w ill now show t he select ed appearance

66 | P a g e
18. Customizing Field - 2
Now right -click on t he Predecessors colum n heading and select Insert Column… and in t he
Field Name select or choose Text1 and OK.

Customize Fields Dialog.

Right -click t he Text1 column heading and select Custom Fields…

67 | P a g e
We’re going t o look at field Type:, Rename... funct ion, Value List… and Formula…, and
finally, Graphical Indicators….

Rename

Rename… w ill give t he field an alias t hat can t hen be referred t o t hroughout Project . Wit h
Text1 select ed, click on t he Rename… but t on and ent er “ Depart ment ” , as w e are going t o
indicat e w hich t asks belong t o w hich responsible depart ment s.

68 | P a g e
When you click OK, t he new name appears in t he Field list w it h t he default name in
bracket s, show ing t he original field name doesn’t change, but allow ing t he alias.

Look up

Look up … w ill enable a dialog t o creat e list s of values t hat can be ent ered int o t he field.
When act ivat ed, w herever t he column is displayed, a drop-dow n arrow w ill reveal t his pick
list , from w hich a select ion can be made. Click on t he Value List… but t on and fill it in w it h
t he depart ment s in row s 1 t o 2, as show n in t he pict ure at arrow #1.

69 | P a g e
Then click import lookup t able

70 | P a g e
Formula

Select View Ribbon t hen select Table-cost

The result is show n below

So, how can w e use formulae t o give indicat ions of individual t asks being, say, highly cost ly
and t hus w e should concent rat e on t hose, or of a sufficient ly low cost t hat w e don’t have t o
w orry t oo m uch about t heir planned cost ? Right -click on t he heading for t he Baseline
column, and insert a new column for Text2, t hen right -click on it s heading and Customise
Fields… and t hen click t he Formula… but t on .

71 | P a g e
Again w e w ill use t he basic IF st ruct ure: so select Function > General > IIf( expression,
truepart, falsepart ) t o insert t he formula. Select one of it s element s and ent er t he dat a or
click t he Field but t on and select . For example:: IIf([Cost]>[Baseline Cost];"High
Risk";IIf([Cost]=[Baseline Cost];"M oderate Risk";"Low Risk")).

72 | P a g e
OK/ OK and in t he Text2 column you w ill see t he w ord “ High Risk” w here t he t ot al cost is
more t han baseline cost and w ord “ M oderat e Risk” w here t he t ot al cost is equal t o t ot al
baseline cost , and w ord “ Low Risk” w here t he t ot al cost is less t han baseline cost

Graphical Indicator

New Table
Now , let ’s creat e t he condit ions w hereby Project w ill give you a Graphical Indicator (St op
light s or Traffic light s) depending upon t he cost range of each t ask. First ly, w e w ill creat e a
new t able in w hich t o view our result s. So View / Table / M ore Tables…

73 | P a g e
Check t hat t he Task radio but t on is select ed and t hen click New…

In t he Table Definition dialog, ent er t he Name of t he t able: Cost St oplight or w hat ever you
w ant t o call it . If you w ant t he new Table t o show in t he View menu, click t he adjacent box.
Click in t he first Field Name cell and t hen t he drop-dow n arrow and select ID from t he pick
list . Cont inue dow n t he cells t o include t he fields as show n below , insert ing t he Titles as
show n, and not ing t hat t he ot her paramet ers are aut omat ically provided for you. You can,
of course, change t hese, but w e’ll leave t hem as default . OK/ Apply.

74 | P a g e
Before w e cont inue, t ry View/ Table: Cost Stoplight/ M ore Tables… t o see t hat t he new
t able is included in t he pick list , from w here you can edit it if you need t o.

In t he view you should now see t he columns w e insert ed, w it h t he W arning colum n (t he
Cost1 field) and t he Total Cost colum n (t he Cost field) filled w it h cost ing dat a based on t he
resources’ cost s plus fixed cost s.

Graphical Indicators

Let ’s say w e w ant t o apply t ests t o a t ask W arning cell, w hich w ill show a graphical indicat or
in t hat cell for t hat condit ion using Boolean arit hmet ic. For example, if t he cost is great er
t han 1.000.000 show a red sphere, if less and 500.000 show a green square, and if bet w een
t he t w o, show a yellow diamond. To do t his w e have t o cust omize t he W arning (Cost1) field
t o give us t he Graphic Indicat ors. So, as before, right -click t he W arning colum n heading and

75 | P a g e
select Customise Fields…. In t he Customize Fields dialog, click t he Graphic Indicators…
but t on.

Not ice t hat t he Graphical Indicators dialog st ill specified t he Cost1 field, w hich w e have
renamed W arning. Also t hat you can include Summaries and you have t he abilit y t o edit t he
comput at ion by using t he but t ons for Cut , Copy, Paste , Insert and Delete row s in t he t able.

Click in t he first cell for t he Test , and select is greater than.

Cont inue dow n t he list t o ent er t he ot her t est s, t o give you a dialog like in t he pict ure.

76 | P a g e
OK/ OK w ill t hen show t he indicat ors in t he W arning column, but t hey are all green squares,
indicat ing t hat t he values in each cell are less t han 500000.

This is because w e haven’t put any values int o t he cells! What w e w ant is t he Total Cost
values t o populat e t hese cells. So, highlight t he Total Cost colum n by right -clicking on it s
heading and select Copy. Then right -click on t he W arning column heading and select Paste
Special….

77 | P a g e
In t he Paste Special dialog, select t he Paste Link: radio but t on, read t he not e below in t he
Results box and also not e t hat t he cell dat a w ill be passed as Text Data . Using Paste Link
allow s t he dat a t o be updat ed as changes are made in t he original cells. When you OK t hat ,
t he indicat ors w ill change t o represent t he condit ions t hat you w ant applied t o each cell (if
necessary,click in a cell t o rem ove t he column highlight ing).

78 | P a g e
 CONTOH KASUS
Tuan XX akan membangun sebuah rumah berlant ai sat u dengan t ipe 21. Dalam rencana, proyek
t ersebut akan dimulai pada t anggal __________. Berikut ini adalah daft ar pekerjaan/akt ivit as
yang akan dilakukan berikut wakt u dan akt ivit as yang mendahuluinya.

ID Task Name Duration Predecessor

1 1. Persiapan
2 1.1 Pembersihan Lokasi 1 hari
3 1.2 Pemagaran 1 hari 2
4 1.3 Pasang Bouw plank 1 hari 3
5 1.4 Pemb. Direksi Keet 1 hari 4
6 2. Pekerjaan Pondasi
7 2.1 Penggalian Tanah 2 hari 5
8 2.2 Pasangan Bat u Kosong 2 hari 7
9 2.3 Pasir Pasang 2 hari 8
10 2.4 Pondasi Bat u Kali 3 hari 9
11 2.5 Pekerjaan Tanah Urug 2 hari 10
12 3 Pekerjaan Beton
13 3.1 Sloof 15/25 3 hari 11
14 3.2 Kolom Prakt is 15/15 3 hari 13
15 3.3 Ring Balk 15/25 4 hari 13SS
16 4 Pekerjaan Pasangan/Dinding
17 4.1 Pasang Bat u Bat a 7 hari 15
18 4.2 Pekerjaan Plest eran 5 hari 17FS+2 hari
19 4.3 Pekerjaan Acian 5 hari 18 FS+1 hari
20 5 Pekerjaan Kayu
21 5.1 Kusen Pint u & Jendela 5 hari 19FS+2 hari
22 5.2 Pasang Kaca 1 hari 25
23 6 Pekerjaan Atap
24 6.1 Pekerjaan Kuda-kuda 1 hari 21
25 6.2 Pekerjaan Usuk dan Reng 2 hari 24
26 6.3 Pekerjaan Gent eng 2 hari 25
27 7 Pekerjaan Lantai
28 7.1 Pasang Keramik 30/30 3 hari 26
29 7.2 Pasang Keramik km/WC 20/20 1 hari 28SS
30 8 Pekerjaan Sanitasi dan Drainase
31 8.1 Sept ict ank dan Peresapan 2 hari 17
32 8.2 Pemipaan 3 hari 31
33 8.3 Pasang Kloset dan Kran 1 hari 29
34 9 Pekerjaan Instalasi
35 9.1 Pekerjaan Tit ik Lampu 2 hari 38
36 9.2 Pekerjaan Elekt rikal 1 hari 39
37 10 Pekerjaan Plafond
38 10.1 Pekerjaan Rangka Plaf ond 4 hari 33
39 10.2 Pasang Ent ernit + List 3 hari 35
40 11 Pekerjaan Finishing
41 11.1 Pengecat an 4 hari 36
42 11.2 Masa Perawat an 5 hari 41

79 | P a g e
Kebutuhan Sumber Daya

Kode Tukang Kayu Tukang Bat u Pekerja Tukang List rik Tukang Cat
Akt ivit as
1.1 - 4 3 - -
1.2 2 3 3 - -
1.3 2 - 2 - -
1.4 1 2 - - -
2.1 - 2 2 - -
2.2 2 2 2 - -
2.3 2 2 2 - -
2.4 - 2 2 - -
2.5 - 2 2 - -
3.1 2 2 - - -
3.2 - 2 2 - -
3.3 2 2 2 - -
4.1 3 2 2 - -
4.2 2 3 2 - -
4.3 - 2 2 - -
5.1 4 2 2 - -
5.2 2 - 2 - -
6.1 2 2 1 - -
6.2 2 2 2 - -
6.3 2 3 - - -
7.1 2 2 2 - -
7.2 2 2 2 - -
8.1 3 2 2 - -
8.2 - 3 1 - -
8.3 - 2 1 - -
9.1 - - - 2 -
9.2 - - - 2 -
10.1 2 3 1 - -
10.2 2 2 2 - -
11.1 - 2 - - 2
11.2 3 2 2 - -
Ongkos 70.000 70.000 50.000 70.000 60.000
Kerja per
Hari
Ongkos 10.000 10.000 5.000 7.500 7.500
Lembur
per Jam
Kapasit as 5 5 5 4 4

80 | P a g e