IT Employment

General discussion


Project tracking metrics

By tejas_tt ·
Looking for some help (may be a tool) which helps tracking projects which has a recurring set of 10-15 activities to be performed across 500+ locations. In a tool like MS project, these activities have to be repeated 500+ times...we need better view, preferably in grouped locations. Any clue? Any feature of MS project which can scale up to this requirement?

This conversation is currently closed to new comments.

Thread display: Collapse - | Expand +

All Comments

Collapse -

by tejas_tt In reply to Project tracking metrics

I need to emphasize that suggestions needed are for something other than XL tracking sheet having activities in columns and locations in rows which is how we handle at present

Collapse -

by MichaelTsen In reply to Project tracking metrics

Depends on your actual situation & details, this may or may not help.

Create one project to represent each location, another project as a group of some locations using the sub-project feature, then finally the master project contains all the groups. This way you have a grouped viewed MS project. This is if you have many group managers helping you to track the progress.

If you are tracking project centrally (ie. call ppl for update and then perform data entry at HQ), then you can modify MS project columns to emulate your existing excel.

Perhaps I can help better if I get a glimpse of your current excel file.

If your locations are remote locations, then you need to enable the Project Central features for realtime tracking. But be forewarn, there isn't many successful implementation of Project Central. But since you are surviving with Excel, I am guessing you are tracking project from a central location anyway, if that is true, then MS project should be OK.

An alternative to MS project is Iplan.
You can define a project of 10-15 activities, assign them to your 'group managers', each of them can in trun break the task to their own locations. Let me know if you are interested, I may have a word with the MD.

A lot of people love to stick to Excel even when they have MS project. Even though common complain is MS project deficiency. But usually after some analysis with their top management, we found that people who like excel are those who are more 'creative' saying 'I want to know the real situation first, then I will decide how to put it on paper for presentation', while the other people who uses MSproject are those more 'scientific' saying 'show me the facts on paper, I will decide how to present that.'

Collapse -

by MichaelTsen In reply to

wrong spelling, in trun -> in turn

Collapse -

by MichaelTsen In reply to

Sorry about the late response, my email is

Collapse -

by MichaelTsen In reply to

Due to the virus spread, I have been deleting a lot of emails without reading from users that I don't know. I apologize if you did send something to me and I deleted that. If needed, please resend by mentioning this discussion.


Collapse -

by tejas_tt In reply to Project tracking metrics

Hi. Thanx for your response. Let me know where to send you sample XL tracking sheet. You guessed right, projects are monitored centrally, feedback received on mail/phone and by central PM and updated in XL, hardly any group managers, but can't be ruled out either. These are only one kind of projects that our group does. There are other single location projects to which MS project suits well. We have IT HW/SW packages deployment services which is single location in case of central architecture and multilocation for point-of service roll-out. The kind of answers we/mgmt seek are that of typical metrics..
1. How much work is complete, when is the project likely to finish?
2. Given an activity, it is completed in how many locations?
3. Which activities are usually delayed?
4. How do you measure progress - as progress at each location (or group of locations) will be different..?
5. I've checked on, looks like elaborate tool towards process automation...may be I am looking for a small bit. Most clients are based out of my own country, India - so can check that out.

Collapse -

by RAMSDELL_KEVIN In reply to Project tracking metrics

If you would like to roll your plan up to a high level, only list your 15 tasks with % complete up to date (#locations completed/500)*100 for each task. This will give everyone a good executive status.

For actual tracking, all you care about now is keeping track of the % complete. DELEGATE it to people that will be overseeing the tasks in each location. Require a status daily (% complete daily). If you have a network, they can enter directly into MS Project.

Just some ideas!!!

Collapse -

by tejas_tt In reply to

Dear Kevin,
Thanx and i appologize for not having looked at the site for long time. The rating is binary - hence marked only as unacceptable. I know there can't be an elaborate and concrete solution. But thought may be some one has sailed in similar boat....Your sugg is what we end-up doing in XL more effectively...No of activities, no of locations and grouping of type of locations are different for each project. Yes, we did think over some sort of centralized delegated desk which will do all the data collection for each site and update centrally. So PM does more value-add in problem solving and managing stake holders. The TOOL is in question. It has to integrate with our legacy systems (SAP). SAP project system has our revenue/costs for project, the project timesheet. We arent too sure about tight integration between MS-Project Server and SAP. All we get out of discussion with Microsoft is a thick quote for design and integration...! Thanx for your interest. Will be glad to see your response again.


Related Discussions

Related Forums