Project Parameters Instructions for Use

Project Name PERENCANAAN JARINGAN TERSIER PLB

Project Manager BAMBANG YADI Input cells are formatted in blue. Global information in this sheet
flows through for display and selection in the 'Tasks' sheet. Task
Project Start Date 22-Aug-2017 timing and and corresponding Gantt schedule is calculated
Productivityautomatically. Project status below is based on the report date
Status Report Date 9-Feb-2021
Project Deadline
factors specified under Project Parameters.
The participant29-Dec-2017 Participant
Participant represent
cost per hour is email addresses Project phases
names are availability of
used to are for are chosen in
Human
chosenResources
in the participants and
calculate human information the Tasks sheet.
Tasks sheet. are used to
Working Hours per day resources
8.0costs. purposes only.
Start Hour 9:00 Phase Definition & Analysis
calculate task
timing.
Project Participants: Hour Analysis
Name Cost/Hr Email Address Factor Project Phases Scheduled Complete
Participant 1 25 email1 PREPARATION 0 0
Participant 2 25 email2 100% PROJECT DEFINITION 0 0
Participant 3 25 email3 100% ANALYSIS 0 0
Participant 4 25 email4 100% DESIGN 0 0
Participant 5 25 email5 100% DEVELOPMENT 0 0
Participant 6 25 email6 100% TESTING 0 0
Participant 7 25 email7 100% IMPLEMENTATION 0 0
Participant 8 25 email8 100% ACCEPTANCE 0 0
Participant 9 25 email9 100% REVIEW 0 0
Participant 10 25 email10 100% CLOSE-DOWN 0 0
OPERATIONAL SUPPORT 0 0
Total Available Productivity 900%

Budgeted Cost of Budgeted Cost of Actual Cost of Cost Performance

Work Scheduled Work Performed Work Performed Index
PERENCANAAN JARINGAN TERSIER PLB project status report as at 09-Feb-2021
(Start date: 22-Aug-2017, Earned Value analysis)

Earned Value Analysis Performance Measurements Variances Indices

BCWS BCWP ACWP Cost Schedule CPI SPI

Total HR Costs - - - - - 0.0% 0.0%

Capital Expenditure - - - - - 0.0% 0.0%

Total Project Costs - - - - - 0.0% 0.0%

Project Timing
Projected Duration 001 Days Deadline 29-Dec-2017 End Date 22-Aug-2017 Overrun -128 Days
 Enter the total
number of hours
Specify a task required to
Choose from Deliverables Total human Choose the
ID for Optional capital complete the
predefined define whether
Hourly cost
resource
per cost is participant from
For Dependency Task description
dependency. costs can be task. Hours are
phase titles the taskparticipant
has calculated
is by the defined list
Mapping flows through
The task
to will not applied to each allocated based
specified in
Task Description Dependencies & Deliverables been completed
HR Costs automatically
multiplying
Capital Staffing in the Resources Timing (Dates)
the schedule.
start until the task. on productivity,
ID Phase Resources sheet
Description DepID Deliverables successfully.
Cost populated.
Total hours
Costs by hourly Hours
Person sheet. Start
0 preceding task other tasks and
cost.
1 PREPARATION SURVEY SOSIAL is complete. - - available
2 ANALYSIS ANALISA SURVEY 1 - - working hours
3 - - per day.
4 - -
5 - -
6 - -
7 - -
8 - -
9 - -
10 - -
11 - -
12 - -
13 - -
14 - -
15 - -
16 - -
17 - -
18 - -
19 - -
20 - -
21 - -
22 - -
23 - -
24 - -
25 - -
26 - -
27 - -
28 - -
29 - -
30 - -
31 - -
32 - -
33 - -
34 - -
35 - -
36 - -
37 - -
38 - -
39 - -
40 - -
41 - -
42 - -
43 - -
44 - -
45 - -
 Enter the total
number of hours
Specify a task required to
Choose from Deliverables Total human Choose the
ID for Optional capital complete the
predefined define whether
Hourly cost
resource
per cost is participant from
For Dependency Task description
dependency. costs can be task. Hours are
phase titles the taskparticipant
has calculated
is by the defined list
Mapping flows through
The task
to will not applied to each allocated based
specified in
Task Description Dependencies & Deliverables been completed
HR Costs automatically
multiplying
Capital Staffing in the Resources Timing (Dates)
the schedule.
start until the task. on productivity,
ID Phase Resources sheet
Description DepID Deliverables successfully.
Cost populated.
Total hours
Costs by hourly Hours
Person sheet. Start
preceding task other tasks and
46 - - cost.
is complete. available
47 - - working hours
48 - -
per day.
49 - -
50 - -
51 - -
52 - -
53 - -
54 - -
55 - -
56 - -
57 - -
58 - -
59 - -
60 - -
61 - -
62 - -
63 - -
64 - -
65 - -
66 - -
67 - -
68 - -
69 - -
70 - -
71 - -
72 - -
73 - -
74 - -
75 - -
76 - -
77 - -
78 - -
79 - -
80 - -
81 - -
82 - -
83 - -
84 - -
85 - -
86 - -
87 - -
88 - -
89 - -
90 - -
 Enter the total
number of hours
Specify a task required to
Choose from Deliverables Total human Choose the
ID for Optional capital complete the
predefined define whether
Hourly cost
resource
per cost is participant from
For Dependency Task description
dependency. costs can be task. Hours are
phase titles the taskparticipant
has calculated
is by the defined list
Mapping flows through
The task
to will not applied to each allocated based
specified in
Task Description Dependencies & Deliverables been completed
HR Costs automatically
multiplying
Capital Staffing in the Resources Timing (Dates)
the schedule.
start until the task. on productivity,
ID Phase Resources sheet
Description DepID Deliverables successfully.
Cost populated.
Total hours
Costs by hourly Hours
Person sheet. Start
preceding task other tasks and
91 - - cost.
is complete. available
92 - - working hours
93 - -
per day.
94 - -
95 - -
96 - -
97 - -
98 - -
99 - -
100 - -

Totals - - -
 Enter the total
number of hours
required to The end date is
Choose from The start date is
complete the calculated Enter any capital
predefined calculated Enter the
For Dependency task. Hours are Task description automatically costs that have
phase titles automatically number of hours
Mapping allocated based flows through to based on hoursbeen incurred
specified in
Task Description Timing based on
(Dates) ProgresscompletedCompletion
fro
on productivity, the schedule. and for the task.
ID Phase Resources sheet
Description participnat
End Hrs the task.
Capex Date
0 other tasks and 22/Aug/17 17:00 productivity.
availability.
1 PREPARATION SURVEY SOSIAL available
2 ANALYSIS ANALISA SURVEY working hours
3 per day.
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
 Enter the total
number of hours
required to The end date is
Choose from The start date is
complete the calculated Enter any capital
predefined calculated Enter the
For Dependency task. Hours are Task description automatically costs that have
phase titles automatically number of hours
Mapping allocated based flows through to based on hoursbeen incurred
specified in
Task Description Timing based on
(Dates) ProgresscompletedCompletion
fro
on productivity, the schedule. and for the task.
ID Phase Resources sheet
Description participnat
End Hrs the task.
Capex Date
other tasks and productivity.
46 availability.
available
47 working hours
48
per day.
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
 Enter the total
number of hours
required to The end date is
Choose from The start date is
complete the calculated Enter any capital
predefined calculated Enter the
For Dependency task. Hours are Task description automatically costs that have
phase titles automatically number of hours
Mapping allocated based flows through to based on hoursbeen incurred
specified in
Task Description Timing based on
(Dates) ProgresscompletedCompletion
fro
on productivity, the schedule. and for the task.
ID Phase Resources sheet
Description participnat
End Hrs the task.
Capex Date
other tasks and productivity.
91 availability.
available
92 working hours
93
per day.
94
95
96
97
98
99
100

Totals
 19-Sep-2017
18-Sep-2017
17-Sep-2017
16-Sep-2017
15-Sep-2017
14-Sep-2017
13-Sep-2017
12-Sep-2017
11-Sep-2017
10-Sep-2017
09-Sep-2017
08-Sep-2017
07-Sep-2017
06-Sep-2017
05-Sep-2017
04-Sep-2017
03-Sep-2017
02-Sep-2017
01-Sep-2017
31-Aug-2017
30-Aug-2017
29-Aug-2017
28-Aug-2017
27-Aug-2017
frequency here.

26-Aug-2017
25-Aug-2017
schedule

24-Aug-2017
Change

23-Aug-2017
22-Aug-2017
Mon
Day Beginning:

ANALISA SURVEY
SURVEY SOSIAL
TASKS
 19-Sep-2017 0 0 0 0 0
18-Sep-2017 0 0 0 0 0
17-Sep-2017 0 0 0 0 0
16-Sep-2017 0 0 0 0 0
15-Sep-2017 0 0 0 0 0
14-Sep-2017 0 0 0 0 0
13-Sep-2017 0 0 0 0 0
12-Sep-2017 0 0 0 0 0
11-Sep-2017 0 0 0 0 0
10-Sep-2017 0 0 0 0 0
09-Sep-2017 0 0 0 0 0
08-Sep-2017 0 0 0 0 0
07-Sep-2017 0 0 0 0 0
06-Sep-2017 0 0 0 0 0
05-Sep-2017 0 0 0 0 0
04-Sep-2017 0 0 0 0 0
03-Sep-2017 0 0 0 0 0
02-Sep-2017 0 0 0 0 0
01-Sep-2017 0 0 0 0 0
31-Aug-2017 0 0 0 0 0
30-Aug-2017 0 0 0 0 0
29-Aug-2017 0 0 0 0 0
28-Aug-2017 0 0 0 0 0
27-Aug-2017 0 0 0 0 0
frequency here.

26-Aug-2017 0 0 0 0 0
25-Aug-2017 0 0 0 0 0
schedule

24-Aug-2017 0 0 0 0 0
Change

23-Aug-2017 0 0 0 0 0
22-Aug-2017 0 0 0 0 0
Mon
Day Beginning:

COSTS (Cumulative)
FULL-TIME HOURS

Capital Costs

Total Costs
Completed
Scheduled

HR Costs
 19-Oct-2017
18-Oct-2017
17-Oct-2017
16-Oct-2017
15-Oct-2017
14-Oct-2017
13-Oct-2017
12-Oct-2017
11-Oct-2017
10-Oct-2017
09-Oct-2017
08-Oct-2017
07-Oct-2017
06-Oct-2017
05-Oct-2017
04-Oct-2017
03-Oct-2017
02-Oct-2017
01-Oct-2017
30-Sep-2017
29-Sep-2017
28-Sep-2017
27-Sep-2017
26-Sep-2017
frequency here.

25-Sep-2017
24-Sep-2017
schedule

23-Sep-2017
Change

22-Sep-2017
21-Sep-2017
20-Sep-2017
Day Beginning:

ANALISA SURVEY
SURVEY SOSIAL
TASKS
 19-Oct-2017 0 0 0 0 0
18-Oct-2017 0 0 0 0 0
17-Oct-2017 0 0 0 0 0
16-Oct-2017 0 0 0 0 0
15-Oct-2017 0 0 0 0 0
14-Oct-2017 0 0 0 0 0
13-Oct-2017 0 0 0 0 0
12-Oct-2017 0 0 0 0 0
11-Oct-2017 0 0 0 0 0
10-Oct-2017 0 0 0 0 0
09-Oct-2017 0 0 0 0 0
08-Oct-2017 0 0 0 0 0
07-Oct-2017 0 0 0 0 0
06-Oct-2017 0 0 0 0 0
05-Oct-2017 0 0 0 0 0
04-Oct-2017 0 0 0 0 0
03-Oct-2017 0 0 0 0 0
02-Oct-2017 0 0 0 0 0
01-Oct-2017 0 0 0 0 0
30-Sep-2017 0 0 0 0 0
29-Sep-2017 0 0 0 0 0
28-Sep-2017 0 0 0 0 0
27-Sep-2017 0 0 0 0 0
26-Sep-2017 0 0 0 0 0
frequency here.

25-Sep-2017 0 0 0 0 0
24-Sep-2017 0 0 0 0 0
schedule

23-Sep-2017 0 0 0 0 0
Change

22-Sep-2017 0 0 0 0 0
21-Sep-2017 0 0 0 0 0
20-Sep-2017 0 0 0 0 0
Day Beginning:

COSTS (Cumulative)
FULL-TIME HOURS

Capital Costs

Total Costs
Completed
Scheduled

HR Costs
 18-Nov-2017
17-Nov-2017
16-Nov-2017
15-Nov-2017
14-Nov-2017
13-Nov-2017
12-Nov-2017
11-Nov-2017
10-Nov-2017
09-Nov-2017
08-Nov-2017
07-Nov-2017
06-Nov-2017
05-Nov-2017
04-Nov-2017
03-Nov-2017
02-Nov-2017
01-Nov-2017
31-Oct-2017
30-Oct-2017
29-Oct-2017
28-Oct-2017
27-Oct-2017
26-Oct-2017
frequency here.

25-Oct-2017
24-Oct-2017
schedule

23-Oct-2017
Change

22-Oct-2017
21-Oct-2017
20-Oct-2017
Day Beginning:

ANALISA SURVEY
SURVEY SOSIAL
TASKS
 18-Nov-2017 0 0 0 0 0
17-Nov-2017 0 0 0 0 0
16-Nov-2017 0 0 0 0 0
15-Nov-2017 0 0 0 0 0
14-Nov-2017 0 0 0 0 0
13-Nov-2017 0 0 0 0 0
12-Nov-2017 0 0 0 0 0
11-Nov-2017 0 0 0 0 0
10-Nov-2017 0 0 0 0 0
09-Nov-2017 0 0 0 0 0
08-Nov-2017 0 0 0 0 0
07-Nov-2017 0 0 0 0 0
06-Nov-2017 0 0 0 0 0
05-Nov-2017 0 0 0 0 0
04-Nov-2017 0 0 0 0 0
03-Nov-2017 0 0 0 0 0
02-Nov-2017 0 0 0 0 0
01-Nov-2017 0 0 0 0 0
31-Oct-2017 0 0 0 0 0
30-Oct-2017 0 0 0 0 0
29-Oct-2017 0 0 0 0 0
28-Oct-2017 0 0 0 0 0
27-Oct-2017 0 0 0 0 0
26-Oct-2017 0 0 0 0 0
frequency here.

25-Oct-2017 0 0 0 0 0
24-Oct-2017 0 0 0 0 0
schedule

23-Oct-2017 0 0 0 0 0
Change

22-Oct-2017 0 0 0 0 0
21-Oct-2017 0 0 0 0 0
20-Oct-2017 0 0 0 0 0
Day Beginning:

COSTS (Cumulative)
FULL-TIME HOURS

Capital Costs

Total Costs
Completed
Scheduled

HR Costs
 04-Dec-2017
03-Dec-2017
02-Dec-2017
01-Dec-2017
30-Nov-2017
29-Nov-2017
28-Nov-2017
27-Nov-2017
26-Nov-2017
25-Nov-2017
frequency here.

24-Nov-2017
23-Nov-2017
schedule

22-Nov-2017
Change

21-Nov-2017
20-Nov-2017
19-Nov-2017
Day Beginning:

ANALISA SURVEY
SURVEY SOSIAL
TASKS
 04-Dec-2017 0 0 0 0 0
03-Dec-2017 0 0 0 0 0
02-Dec-2017 0 0 0 0 0
01-Dec-2017 0 0 0 0 0
30-Nov-2017 0 0 0 0 0
29-Nov-2017 0 0 0 0 0
28-Nov-2017 0 0 0 0 0
27-Nov-2017 0 0 0 0 0
26-Nov-2017 0 0 0 0 0
25-Nov-2017 0 0 0 0 0
frequency here.

24-Nov-2017 0 0 0 0 0
23-Nov-2017 0 0 0 0 0
schedule

22-Nov-2017 0 0 0 0 0
Change

21-Nov-2017 0 0 0 0 0
20-Nov-2017 0 0 0 0 0
19-Nov-2017 0 0 0 0 0
Day Beginning:

COSTS (Cumulative)
FULL-TIME HOURS

Capital Costs

Total Costs
Completed
Scheduled

HR Costs