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

ExcelGanttchart.zip (18.01 KB)
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 Send mail to the author(s)
Archive
<September 2010>
SunMonTueWedThuFriSat
2930311234
567891011
12131415161718
19202122232425
262728293012
3456789
Blogs I read
Disclaimer

Disclaimer
Postings are provided as is with no warranties, and confer no rights. Opinions expressed here are my own delusions; my employers at best shake their heads and sigh, at worst repudiate the content with extreme prejudice, whenever it manages to appear on their radar.

© Copyright 2010
Rujith Anand

Statistics
Advertisement
All Content © 2010, Rujith Anand