The techie in me RSS 2.0
 Saturday, September 26, 2009

For my new project I had to create a plan, I guess all the project managers need one… and the best way to represent the plan is in Gantt chart. So that your boss will know when each milestone will be achieved in the timeline.
I searched in the web for free Gantt chart tools and couldn’t find any good ones, and we didn't had budget to buy one.

Then I decided to use the almighty excel to create one. It was very easy to create one, excel support charts, what else you need. Excel is really powerful isn't it..I remember when I used to share accommodation with my friends I used excel spreadsheet to calculate our common expenses, though some of them argue there is mistake in the formula they are paying more :)

So to cut the crap out, the Excel Project Plan Gantt chart is available here for download. In short the features include
1. Gantt chart of the project plan
2. Need only minimal inputs(project start date, tasks and task estimates)
3. The formula takes care of Weekends(NOT holidays) while calculating dates.
3. Fully customizable. you are free to change the formula to suit your purpose. you can even convert it into an excel template Gantt chart if you like.

Rest you can see yourself in the spreadsheet.

Please feel free to leave your comments and suggestions in this blog.

Some of the references I have used are below

1. Using Excel to Create a Gantt Chart by Michele McDonough
http://www.brighthub.com/office/project-management/articles/3418.aspx

2. and of course office online excel help

Excel spreadsheet Project plan with Gantt Chart can be Download here

 

-Rujith

Saturday, September 26, 2009 6:29:00 PM (GMT Standard Time, UTC+00:00)  #    Comments [0] -
Office
Name
E-mail
Home page

Comment (Some html is allowed: blockquote@cite, strike) where the @ means "attribute." For example, you can use <a href="" title=""> or <blockquote cite="Scott">.  

Enter the code shown (prevents robots):

Live Comment Preview
About me
Name : Rujith Anand
Occupation : Eating, drinking, sleeping and Yes ofcourse coding.
Location : Reading, UK
Archive
<March 2010>
SunMonTueWedThuFriSat
28123456
78910111213
14151617181920
21222324252627
28293031123
45678910
Blogs I read
Disclaimer

Disclaimer
The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.

© Copyright 2010
Rujith Anand

Statistics
Follow me on Twitter
All Content © 2010, Rujith Anand