Milestone Tracking

Brendan Caulfield Palatine, Il, United States

Hi Everyone,

I am looking for a quick, low-tech milestone tracking template. I am envisioning some sort of an excel spreadsheet that can house multiple projects with many milestones. The spreadsheet will be used to give Project Managers/Directors and senior management a quick snapshot of which projects are on time and which are suffering. Detailed project data will be maintained and housed in the Project Plan.

Thanks is advance for your consideration,

Brendan Caulfield

Posted: Mar 8, 2007 4:12 PM

Sort By:

Bethany Schoenick PMP Montgomery, Al, United States

I think what you are looking for is the critical path of the milestones. To be accurate, you really need Project Server or link all projects into one master file (of course that in itself is a maintenance nightmare - better with server). The problem with tracking on .xls is that you will constantly be referring back to the actual schedules.....

Posted: Mar 30, 2007 12:33 PM

Bipin Lekshmanan PMP Project Manager| Wipro Technologies Edison, Nj, United States

I would use MS project. You can get mile stone charts and reports. Now a days, MS project is used universally so the report formats wouldn't surprise your audience, too.

Posted: Apr 5, 2007 1:19 PM

James Wyatt New York, Ny, United States

I was looking for an answer to this too and ended up using this to draw them. It isn't in Excel and the chart needs to be recreated each month, but it did work for my purposes.

Anyway thought I'd post this back here as this thread showed up when I was searching but no one seemed to have a free answer :-)

Posted: May 3, 2010 4:59 AM

Prasad Velaga Executive| Optisol College Station, Tx, United States

Brendan,

We have recently brought out an Excel-based tool for multi-project scheduling with automatic resource leveling. The task information of all projects (including milestone information) is stored in a single worksheet. The second worksheet contains resource information. The only limit for the data that can be handled by the tool is Excel capacity. Gantt chart of this tool may meet your requirement. We gave a copy to project scheduling expert, Andrew Maker for evaluation last week. For additional information, please have a glance at our web page,

http://www.optisol.biz/multi_project_scheduling.htm

Regards, Prasad

Posted: May 3, 2010 3:27 PM

Andrew Makar Program Manager| AMAKAR LLC Oakland Township, Mi, United States

Have you seen http://www.ppmlite.com?

They have several lite portfolio management features.

In my own projects, I developed an Excel based tool to analyze a project schedule and generate a task count report for each project.
I often use it when I consult on programs to evaluate their schedule capability. Here is the blog post that explains what it does:

http://www.tacticalprojectmanagement.com/project-management-tips/troubled-project-schedule-assessment.html

Thanks!

Andy Makar
http://www.tacticalprojectmanagement.com
Deliver projects better with our Microsoft Project Training!

Posted: May 24, 2010 5:26 PM

Naomi Caietti Senior Project Manager | ePMO | Higher Education | Healthcare & IT| Linkedin.com/In/NaomiCaietti

Hi Brendan:
I've used all low cost tools to accomplish what you're talking about. Excel, access, visio.

Check out this online tool:
http://www.projectmanager.com/index.php
Single user cost $25.00

Check out gantthead.com; there is probably a low cost solution here.

~N.

Posted: May 24, 2010 7:48 PM

Please login or join to reply

Milestone Tracking

Sponsors

Vendor Events

Guessing is not a strategy: How to build decision velocity with AI and real-time data

Newsletters