s-curve by ms project 060317

7/25/2019 S-Curve by MS Project 060317

http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 1/50



2Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Sample of Visual in excel




This article is to explain ProjectManagement Concept as a quick reference through step by step guidance using MSProject 2!"

The targeted audience is a beginner tothe project management and experienced#ith MS Project in early $ersion% such 2& or 2!

'uide line



Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

1. Start Project

2. Plan the Tasks

3. (ssign resources

. Project )aseline set up

!. *pdate progress6. +orecast ,nformation

7. Step by Step to S-Cur$e

". Step by Step .xport /ata to .xcel 0Visual1eport

#. Close Project

Table of Contents


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 5/50 !Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Prior to start the project planning% Project

manager should be identi3ed% #ho can setup a project plan in MS project 2!"

Step-!4 Start Project

1. Create ane$ Pro%e&t'i(e

)o &reate a ne$ *(an+ pro%e&t inPro%e&t, &(i&+ the (e ta*. C(i&+ ne$


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 6/50 6Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

2. Set pro%e&t

tart ate

o to Pro%e&t ta*. C(i&+ Pro%e&t

inoration

Step-!4 Start Project


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 7/50 7Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-!4 Start Project3. ene

Pro%e&tCa(enar

o to Pro%e&t ta*. C(i&+ Change

4or+ing tie


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 8/50"Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-!4 Start Project. Save the

Pro%e&t (e

o to )a* (e, e(e&t ave a $ith

Pro%e&t 5ae or o* Orer runningnu*er


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 9/50#Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

,n the planning stage% #e need to

achie$ed project5s goals6 To do this% #e ha$e to identify the project5s milestone% deli$erables and tasks6

This plan can be use #ork breakdo#nstructure 07)S6

Step-24 Plan the Tasks


http://slidepdf.com/reader/full/s-curve-by-ms-project-060317 10/5010Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-24 Plan the Tasks1. Enter )a+ C(i&+ ie$ ta*. 8n the )a+ ie$

group, &(i&+ antt Chart. 8n the )a+ 5ae e(, enter ta+.




Step-24 Plan the Tasks2. e&ie ho$

9ou $ant toS&heu(e )a+

8n Pro%e&t 2013, $e &an &heu(e

ta+ anua((9 or autoati&a((9.Se(e&t &heu(e etho aterenter a ne$ ta+ *9 &(i&+ing inthe )a+ Moe &o(un:-

5ote: 5e$ )a+ anua((9 et *9eau(t in Option )a*




Step-24 Plan the Tasks3. Out(ine

)a+

Create ta+ hierar&h9 in&(uing

ta+ an i(etone uneruar9 ta+, $hi&h &an *erepreent phae or other $or+iviion.

C(i&+ the )a+ ta*. 8n the S&heu(egroup e(e&t 8nent or Outent*utton• )ip: i 9ou &reate a uar9

ta+ $ith uration, tart or

nih ate, then the ta+ thata(( uner the uar9 ta+ $i((not *e ro((e up to thi




. Enter

uration

C(i&+ the uration e( or a ta+

an enter a uration. )$o $a9 toentering a uration:-

Mutually Schedule task A nu*er or tet (i+e

;)oorro$< or ;5et aterro(( he((< et&. Auto Schedule task

5u*er on(9, 3=3 a9,0=i(etone, 6> i an

etiate uration.5ote: ?oth &an e(e&te in the )a+Moe

Step-24 Plan the Tasks




Step-24 Plan the Tasks!. @in+ )a+

to ho$re(ationhip

C(i&+ the )a+ ta*, in the ie$

roup &(i&+ antt Chart. Se(e&t theta+ that 9ou $ant to (in+ then&(i&+ the @in+ )a+ *utton in theS&heu(e group, or ove a oue

to *ar &hart pre an ra&+ o$nto ta+ that 9ou $ant to (in+. )o &hange the eau(t 'inih-to-Start 'SB, ou*(e &(i&+ the (in+ (inean &hange.



1!Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

(ssignments are the associations bet#een

speci3c tasks and the resources neededto completed them6 7e can assign more than one resources to a tasks6

7e can assign #ork resources 0People%material 0pipe8shell etc6 and cost 0T9) totasks6

Step-"4 (ssign 1esources




Step-"4 (ssign 1esources1. A

Reour&e toPro%e&t

C(i&+ the )a+ )a*, in the ie$

ropo$n (it e(e&t Reour&eSheet. 8n the Reour&e 5ae(e, t9pe the nae o reour&ethat $e(( ue in thi pro%e&t.




2. Aign

Reour&e to )a+

8n the Reour&e )a*, C(i&+ Aign

Reour&e the &(i&+ reour&enae then &(i&+ aign

Step-"4 (ssign 1esources



1"Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-"4 (ssign 1esources3. Enter the

4or+ Dourpening on

)a+

Ater aign a reour&e to the

)a+, $or+ hour autoati&a((9ho$ in a 4or+. 8 PM preer&ontro( a 4or+ing hour, it &an *e&hange in in 4or+ 'ie(. Entering

4or+ ree&t rea( $or(&heu(ing.o to antt Chart, right &(i&+ on&o(un then &(i&+ 8nert Co(unt9pe F4ORG< to e(e&t the 4or+

Co(un



1#Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-"4 (ssign 1esources. Gno$ the

4or+ )a+ )9pe

Ater Aign a reour&e to )a+,

MS Pro%e&t eterine ho$ to&heu(e the ta+ *ae on theta+ t9pe.Manua((9 ta+ ontue ta+ t9peB uration a9

&hange a $e aign reour&e tota+.How tasks tyes work 4or+, uration an unit areeterine *9 oru(a:-

!ork "#uratio$ % &$its




Step-"4 (ssign 1esources'$ a( ') we

revised!ork

') we

revised#uratio$

') we

revisedu$its

'ie unit ta+ uration&hange

4or+ &hange uration&hange

'ie $or+ ta+ uration

&hange

Hnit &hange uration

&hange'ie urationta+

Hnit &hange 4or+ &hange 4or+ &hange )o et a eau(t ta+ t9pe or the entire pro%e&t,

&(i&+ the option. o to S&heu(e group, in theeau(t ta+ t9pe *o ho$n e unit a aeau(t, $e &an &hange to 'ie uration or

'ie 4or+ )o &hange the ta+ t9pe or an iniviua(, go to

ta+ ta* in propertie group &(i&+ inorationor to ta+ nae ou*(e &(i&+ it $i(( a ear.




Step-"4 (ssign 1esources!. 8enti9

a&toreIe&ting ta+&heu(e

4e &an ue MS Pro%e&t 2013 to

he(p or unertaning ho$&hange one ta+ &an eIe&t theret o the pro%e&t.C(i&+ the ta+ ta* then in the

S&heu(e group &(i&+ 8npe&t )a+.A pane open on the (et ho$ingthe a&tor that aIe&t the&heu(ing o e(e&te ta+.Or ou*(e &(i&+ in ta+ nae.




Create a baseline or interim plan is to

compare bet#een plan and actual6 Sa$ing baseline plan enables to identify

and sol$e discrepancy and plan more accu

rately for similar future projects6

Step-:4 Set the Project )aseline

Step :4 Set the Project )ase




Step-:4 Set the Project )ase;ine1. Save the

*ae(ine p(an

Ater the p(an i o(i(9 in p(a&e or

the nih ate, *uget an &ope,$e &an u*it a p(an or approva(.On&e it ha *een approve, avethe *ae(ine p(an.C(i&+ the Pro%e&t ta*, in S&heu(egroup &(i&+ Set ?ae(ine

Step :4 Set the Project )ase




Step-:4 Set the Project )ase;ine2.ie$

*ae(ine atain antt Chartvie$

8n antt &hart vie$, ove a oue

to gantt area, right &(i&+ an e(e&t?ar St9(e.

*a+e Aeara$ce

Show )or,ask

ow .ro+ ,o

?ae P(anCutoB

Se(e&t *arhave an&o(or

Se(e&t5ora(

2 or 3 ?ae(ineStart

?ae(inenih

Step-:4 Set the Project )ase




Step-:4 Set the Project )ase;ine3. ie$

?ae(ine in a )a*(e

o to ie$ ta*, in ata group &(i&+

to )a*(e an e(e&t arian&e orinert &o(un $ith &uto e(.




*pdating the progress is the only #ay to

ensure it stays on tracks as #ork is performed6 The focus at this point is on managing changes% updating the schedule% tracking progress and communicating project inf ormation6

MS Project 2!" tracks " sets of date4Current% )aseline and (ctual6 7hen #e set

the baseline% current < baseline6 #hen a task is != complete% current<actual6

Step->4 *pdate Progress




Step->4 *pdate Progress1. Manage

Change

Managing &hange invo(ve

oi9ing uration, ate,epenen&ie, reour&eaignent or ta+ *ae onreJuete &hange or ne$inoration.Geep the &urrent e( up to atean &opare to *ae(ine.




Step->4 *pdate Progress2. )ra&+ a&tua(

ate anuration

8t the *et to e&ie on a ing(e

etho or tra&+ing progre. 4e&an enter per&entage &op(ete,a&tua( tart an nih ate,a&tua( reaining uration ora&tua( an reaining $or+.C(i&+ the )a+ ta*, e(e&t the ta+that $e $ant to enter a&tua(progre. 8n the S&heu(e groupe(e&t the aount o progre

one on the ta+.eau(t: 0K, 2!K, !0K, 7!K,100K

d




Step->4 *pdate Progress3. )ra&+ A&tua(

Dour anCot

8 $e $ant to enter a&tua( an

reaining $or+ hour or &ot, uetra&+ing ta*(e.C(i&+ ie$ ta*, in ata group point

)a*(e an e(e&t )ra&+ing.Enter progre ata in the A&t.4or+ or A&t. Cot e( or the ta+.Progra i eterine i $e put thea&tua( tart an a&tua( nih or KCop(ete.

S @ Vi 1 , f i




MS Project 2!" pro$ide many #ays of

built in report% but for us #e ha$e to create a customi?e report by using S-Cur$e 1eports6

Step-@4 Vie# 1eport ,nformation

St @ Vi 1 t , f ti




Step-@4 Vie# 1eport ,nformation1. Se(e&t a

ie$

MS Pro%e&t 2013 ha o( an ne$

vie$ to he(p 9ou to ee pro%e&tinoration an report it to other.C(i&+ the ie$ )a*, in either the

)a+ ie$ group or Reour&eie$ group, e(e&t the vie$ 9ou$ant to ue. )herere an9 vie$*ut ot uu( one in&(ue:-• )ea p(anner ie$• )ie(ine ie$

• antt Chart ie$• Ca(enar ie$

St @ Vi 1 t , f ti




Step-@4 Vie# 1eport ,nformation2. CutoiLe

a ie$

Se(e&t the vie$ 9ou $ant to

&utoiLe an then on the 'oratta* &(i&+ the t9pe o vie$ e(eent9ou $ant to &hange, u&h a the*ar t9(e on the antt Chart orgri(ine an tie &a(e o an9vie$.

)ip )ri&+, i 9ou $ant to (ter,ort or group ta+ prior toprinting, &(i&+ the ie$ ta* an

then in the ata group, &(i&+ ort,'i(ter or roup option.

St @ Vi 1 t , f ti




Step-@4 Vie# 1eport ,nformation3. Print a ie$

or Report

Set up the &urrent vie$ that $e

$ant it to (oo+ $hen printe. C(i&+the 'i(e )a* an then &(i&+ Print. Aprevie$ part o the vie$ to ee thea&tua( iLe o the vie$ a it $i(( *eprinte.

St @ Vi 1 t , f ti




Step-@4 Vie# 1eport ,nformation. enerate a

Report

8n Report ta* ha an9 report to

vie$ inoration o pro%e&t *ut$ere intent to &reate the S-Curve*9 uing MS Pro%e&t a a too(,$e(( o&u on ho$ to o it.C(i&+ the Report ta*, go to ie$report group, e(e&t Cutoer

St & St b St t S C




Step-&4 Step by Step to S-Cur$e

,n the 3eld list 0right hand Select

Category to Time6

Step & Step by Step to S Cur$e





Then Select +ield go to 7ork% click (ctual

7ork and Cumulati$e (ctual 7ork only6

Step &4 Step by Step to S Cur$e





The Click on )aseline% click )aseline

Cumulati$e 7ork% just only one6






,n chart area 1ight click to change chart

type6 Select Chart type to Combo6






,n the Change Chart Type dialog in Series

Aame choose (ll Cumulati$e 0(ctual B )aseline Chart type to ;ine Type6

(ctual 7ork chart type to ClusteredColumn and Click Secondary (xis






,n +ield ;ist% in Tasks Tab look at Select

Category% click .dit customi?e time from /ays to 7eeks and change format as you like6






,n design Tab% choose format color as you

like6 ,n Chart ;ayout select ;ayout Ao > to

sho# /ata






+inal as just +onts si?e and others

Step 4 .xport /ata to .xcel




Step-4 .xport /ata to .xcel1. iua(

Report

o to Report ta*, e(e&t on iua(

report Eport.Se(e&t tep(ate ia(og ho$, go to )a+ Hage ta*, ove a oue onCah '(o$ Report tep(ate, then&(i&+ Eit )ep(ate.

8n iua( Report-'ie( Pi&+er i popup, in Avai(a*(e 'ie(, e(e&t ?ae(ine Cuu(ative 4or+ anCuu(ative A&tua( 4or+ a to

e(e&te 'ie(.

Step-4 .xport /ata to .xcel



Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-4 .xport /ata to .xcel2. Ana(9Le

ata in Pivot )a*(e

8n Pivot)a*(e 'ie(, e(e&t on(9

A&tua( 4or+, ?ae(ine Cuu(ative$or+ an Cuu(ative A&tua( 4or+.




!Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step-4 .xport /ata to .xcel3. Cuto

Chart inE&e(

8n Pivot )a* 'ie(, e(e&t on(9

?ae(ine Cuu(ative 4or+,Cuu(ative A&tua( 4or+ an A&tua(4or+.8n Chart Area Right C(i&+ ouee(e&t Co*o &hart, then A((

&uu(ative &hange t9pe to @ineon(9 A&tua( 4or+ to C(utterCo(un.





Step 4 .xport /ata to .xcel

Step-G4 Close the Project




Dust because your project is almost 3nished

doesn5t mean that your #ork is done6 7e still need to sol$e any 3nal project detail

and customer acceptance for 3nal deli$erables6

Conduct a E;essons ;earnedF session%

recording information about areas for impro$ement and best practices6

Make any 3nal update to project plan6

+inally archi$e the project plan according to our

organi?ation5s guideline6

Step G4 Close the Project




"Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step G4 Close the Project1. Create a

'ina( Report

C(i&+ the Report ta*, &(i&+ iua(

Report to ee pro%e&t ata a aPivot )a*(e report in E&e( 2013 orPivot iagra vie$ in iioproeiona( 20134e &an a(o vie$ *ai& report

that ont reJuire E&e( or iio.C(i&+ Report )a* an9 report&ategor9 avai(a*(e to vie$ epenon ho$ $e $ant to vie$.




#Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Step G4 Close the Project2. Save a

Pro%e&t a a )ep(ate

Ater &op(eting a pro%e&t, $e

have to (everage $hat $eve(earne in the pro%e&t *9 a+ing ita a tep(ate or uture pro%e&t.C(i&+ the 'i(e ta* an Save A anthen in the Save A )9pe *o &(i&+

)ep(ate.

Thanks you



!0Author: Ong-Art Sanpinit Charter Engineer วฟก. 1037

Thanks you

.nd

s-curve by ms project 060317

Documents