W9.0 – Ahmed AL-Abri- Create a Basic Gantt chart in Excel


1. Problem Definition

A consultant company wants to present their Schedule for the client in the kick of meeting and their planner who is professional in Microsoft project is in vacation. And he will not come back prior the presentation’s date.

2. Identify the Feasible Alternative

The project manager of the consultant company decided to create the Gantt chart in excel.

3. Development of the Outcome for Alternative

The table below summarizes the task, start date, duration and finish date

Figure 1- Task Data

Figure 1- Task Data

4. Selection Criteria

The steps to create the Gantt chart in excel are explained clearly in the below link of YouTube:-

http://www.youtube.com/watch?v=sA67g6zaKOE

5. Analysis and Comparison of the Alternative

For our case the implementation of the instruction in the above link will result to the following Figure

Figure 2- Gantt Chart in excell

Figure 2- Gantt Chart in excel

 6. Selection of the Preferred Alternative

Gantt charts are most commonly used for tracking project schedules. It is useful to show information about the various tasks or phases of the project, the tasks relate to each other, how far each task has progressed, what resources are being used for each task and so on. For quick events such a presentation or small assignments Gantt chart in excel will be sufficed.

 7. Performance Monitoring and the Post Evaluation of Result

A Gantt chart, commonly used in project management, is one of the most popular and useful ways of showing activities (tasks or events) displayed against time. Each activity is represented by a bar; the position and length of the bar reflects the start date, duration and end date of the activity. This allows you to see at a glance:

  • What the various activities are
  • When each activity begins and ends
  • How long each activity is scheduled to last
  • Where activities overlap with other activities, and by how much
  • The start and end date of the whole project

To summarize, a Gantt chart shows you what has to be done (the activities) and when (the schedule).

For presentation and small assignment a Gantt chart might be presented in excel. For big project a Gantt chart should be presented in primavera or Microsoft project.

8. Reference:

1. Jodi Sorensen (2013, July). How to Create a Gantt chart in Excel Retrieved July 06, 2014, from http://www.smartsheet.com/blog/gantt-chart-excel?page=27

2. Chart Director (2008, December). Simple Gantt Chart. Retrieved July 06, 2014, from http://www.qrb-bw.de/pdf_pool/pythondemo/cdpydoc/gantt.htm

3. Project smart. (2013, August). How to Create a Gantt Chart Using Microsoft Excel. Retrieved July 06, 2014, from http://www.projectsmart.co.uk/creating-a-gantt-chart-using-excel.php

 

Advertisements

3 thoughts on “W9.0 – Ahmed AL-Abri- Create a Basic Gantt chart in Excel

  1. Ahmad, you started out OK but there is no alternative to compare against….??? Gantt chart or ???????

    If you want to make a comparison, why not compare the “One Page Project Manager” https://www.oppmi.com/download-project-manager.cfm vs your Gantt Chart (above) and the Blog Posting template I sent out earlier today…..

    When using our research based analysis model, you must have at least two alternatives to compare and then based on some criteria (financial? multi-attribute? qualitative? quantitative? you have to make a decision which one you will use based on the criteria or objectives.

    Bottom llne- you picked an interesting subject but your analysis is not consistent with our step by step model…… Try again but for your W9.1, I need to see you comparing TWO or more methods. (HINT: Turn to page 86 in your Memory Jogger 2 and maybe you could use a force field analysis to compare using a Gantt vs using One Page Project Manager? Or how about using multi-attribute decision making to compare the alternatives?

    BR,
    Dr. PDG, Jakarta

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s