Guild of Project Controls: Compendium | Roles | Assessment | Certifications | Membership

Tips on using this forum..

(1) Explain your problem, don't simply post "This isn't working". What were you doing when you faced the problem? What have you tried to resolve - did you look for a solution using "Search" ? Has it happened just once or several times?

(2) It's also good to get feedback when a solution is found, return to the original post to explain how it was resolved so that more people can also use the results.

Looking for project management solution - MSProject?

15 replies [Last post]
Tue, 2007-07-24 08:52
Bob Trimpe
User offline. Last seen 16 years 39 weeks ago. Offline
Joined: 24 Jul 2007
Posts: 4
Groups: None
I manage a group of technical writers. Current management tool is an Excel srpeadsheet. Volume has become such that I need a more sophisticated tool to track hours, due dates, budget. I also need to be able to generate charts that report total hours for all users, be able to graphically represent capacity problems and contrast desired vs actual schedules.

Is MSProject the tool I need? Any other suggestions?

Regards,
Bob Trimpe
Top

Replies

Mon, 2007-08-27 16:41
#1
Andrew Dick
User offline. Last seen 8 years 14 weeks ago. Offline
Joined: 14 Feb 2007
Posts: 295
Groups: Regional Representatives, The GrapeVine
You should look at

www.microplanning.com.au

Microplanner X-Pert is a good tool and it works in the network view and is easy to use and gives very accurate results

Andy
Top
Mon, 2007-08-27 04:20
#2
Daniel Limson
User offline. Last seen 4 years 39 weeks ago. Offline
Joined: 13 Oct 2001
Posts: 318
Groups: None
Try AMS Real Time, See link below

http://www.amsrealtime.com/products/projects.htm

Cheers,
Daniel
Top
Tue, 2007-07-31 03:44
#3
Oliver Melling
User offline. Last seen 4 years 30 weeks ago. Offline
Joined: 24 Apr 2007
Posts: 595
Groups: The GrapeVine
Bob,

Primavera is too powerful for your needs and it’s easier to get support on MSP than it is for Spider.

Get MSP standard, not even a new copy, get MSP 2002 and do as Niclas says, put each project as an indiviual WBS element in a master project, resource the activities, run histograms that show a resource overload, show them your boss and tell him to put a job vacancy in the local paper.

HTH

Ol
Top
Mon, 2007-07-30 10:23
#4
Nicolas Igersheim
User offline. Last seen 7 years 16 weeks ago. Offline
Joined: 25 Jun 2007
Posts: 62
Groups: Petro-Chem / Oil & Gas
HI all,

Bob, as I understand it, your Excel tool does not go into
the detail of the different projects;
Therefore I suggest, use MSP (alas)
and input each project as a different task.
This should allow you to track resources and loads
just as you wish

hth

Nicolas
Top
Mon, 2007-07-30 04:25
#5
Anoon Iimos
User offline. Last seen 2 years 15 weeks ago. Offline
Joined: 22 Sep 2006
Posts: 1422
Groups: Pinoy Planning Planet Community
looking for Project Management Solution? First, look for a good Project Manager, the tool will follow...

i still prefer San Mig Lite!

cheers
Top
Wed, 2007-07-25 13:05
#6
Vladimir Liberzon
User offline. Last seen 17 weeks 2 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Yes, Dieter, I know these questions since 1993 when Spider Project was initially launched. Now it is used by largest Russian companies (like Russian Aluminium - largest aluminium company in the world), Russian Ministry of Defense and Accounting Chamber, and many large and small companies around the world. I don’t think that this kind of questions will be asked in this case. Usually it is a problem of IT people that chose software for large enterprises and don’t want to take any risk.
MSP has very poor resource management capabilities but in this case the number of resources is low and resource conflicts are rare. I am not sure that it is the best solution but it is fast to learn and cheap.
There is no need to manage portfolio in this case. It will be easier to create one multiproject that will include all current projects.
Spider Lite has more useful functions (skill scheduling, resource constrained schedule optimization, unlimited number of cost components, ability to set and to use corporate norms, power - no limits for anything, etc.) and is even cheaper. But it is not known in the USA, you are right.
When I wrote about Spider I just wanted to tell that the task is simple even for Spider Lite (most easy and cheap software in Spider Project family).
Regards,
Vladimir
Top
Wed, 2007-07-25 12:39
#7
Dieter Wambach
User offline. Last seen 7 years 6 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Vladimir
As my experience is limited to three of the current tools, the others are obsolete since many years, I can just give an opinion on those three and typical behaviours of management.
MSP, if your focus is on resource-planning with multiple projects might become a nightmare.
Spider might be much more efficient. I don’t know it. But I assume some remarks from management, e.g. Russian Spyder tool, will it still exist in five years? Can we get planners, support.... I’m sure you know those questions better than me.
Bob’s role would be easier with a well known tool. This was my concern.

Regards

Dieter
Top
Wed, 2007-07-25 12:04
#8
Vladimir Liberzon
User offline. Last seen 17 weeks 2 days ago. Offline
Joined: 5 Feb 2001
Posts: 2748
Groups: Accreditation Editors, Board of Advisors, Civil Engineering, GPCCAR Editors, Petro-Chem / Oil & Gas, Regional Representatives, Spider Project Team, TURNAROUND & SHUTDOWN (T/A & S/D)
Dieter,
the task is simple and I am sure that it does not make sense to throw away money that are needed for bying Primavera tools. MS Project Standard may be sufficient, Spider Project Lite (for 450 Euros) will certainly do all necessary things better than Primavera.
And you know that no tool will guarantee that the data that were used are correct.
Regards,
Vladimir
Top
Wed, 2007-07-25 09:23
#9
Dieter Wambach
User offline. Last seen 7 years 6 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi Bob

At a first glance Primavera maybe would mean to shoot with cannons against sparrows. MSP cannot really handle that people work in different projects or you’ll need the enterprise solution, which would with all required tools be more expensive than Primavera.

For such a resource planning to be considered:
- Admin work, holidays, training, sickness ...to cover all working time
- Roll/qualification concept, because at first you know which qualification required, technical-, scientific- .. writer to do a roadmap-planning
- What-if scenarios
- To convince management, that the result of your planning with excess of capacity is correct, a good name - Primavera - is better, than "I found a good software-house which has an excellent tool for a low price" or a good tool with no real representative in your country. This I had to experience rather frequently already. This would be a good argument for Primavera again.

Hope, this will help you.

Regards from Germany

Dieter
Top
Wed, 2007-07-25 08:34
#10
Bob Trimpe
User offline. Last seen 16 years 39 weeks ago. Offline
Joined: 24 Jul 2007
Posts: 4
Groups: None
WOW, thanks for the thoughtful responses.

A little background - I have three writers who may have two or three active projects going at a time. I currently manage their schedules using an excel spreadsheet, a cell for each week, all the writers projects lined up one under the other. By placing an anticipated value in the weekly cell for each writer’s projects, I can graph the manpower requirements for the group.

I need a way to demonstrate that my needs have exceeded my manpower. If I have more projects than manpower for a given week, the graph shows it. In reality, however, the the project timelines become longer (and my projects go late). I ran into trouble because it does not reflect my actual workload - only the desired work to be done for a week. I need to be able to reflect actual workload spread out over more time (for scheduling purposes) but be able to demonstrate to my boss the excess capacity demands week by week.

Hope that’s not too confusing. I’m new to the site, so I don’t know if I am able to posts pictures that illustrate.

Regards,
Bob
Top
Wed, 2007-07-25 03:47
#11
Charleston-Joseph...
User offline. Last seen 2 years 39 weeks ago. Offline
Joined: 10 Jul 2005
Posts: 1347
Groups: None
Hi Bob,

What you need is a project management system and procedure approach.

MSP, P3 or any software will not solve your problem.

While it is true you need any one of the above mentioned planning software, the project team approach is still efficient and combined deliverables with excel charts.

If you need further elucidation, please let me know.


Cheers,

Joseph
Top
Tue, 2007-07-24 23:42
#12
A D
User offline. Last seen 3 years 24 weeks ago. Offline
Joined: 20 May 2007
Posts: 1027
Groups: Accreditation Editors
Hi BOB,

I totally agree with Dieter. It seems that team size is small and there are not different type of resources.

MSP is the best tool in this case.

P3 takes time to learn and not that user friendly as MS Project.

Otherwise, you can try "SAFRAN Planner" also. Its free download (38 MB) is available at

http://www.safran.com/Downloads/Planner%20Eval.exe

Cheers,

Raviraj A Bhedase
Top
Tue, 2007-07-24 16:51
#13
Dieter Wambach
User offline. Last seen 7 years 6 days ago. Offline
Joined: 15 Jan 2007
Posts: 1350
Groups: Petro-Chem / Oil & Gas, TILOS
Hi Bob
it depends on how many resources you’ll have to plan and for how many projects they work the same time. If not more than about 10 people and just one project a time, MSP is ok. If there are more projects per person or more persons I have some doubts on the results.
P3 is getting more and more obsolete - by pricing policy too. So it wouldn’t be the best idea to start with - for my opinion.
For resource planning in IT area - many small projects, resources working on multiple projects - I had very good results with P3e/P5.
Unfortunately I don’t know other software. There may be other better or similiar, but cheaper tools as the one Alexandre mentioned.

Good luck in your choice!

Dieter
Top
Tue, 2007-07-24 09:08
#14
Brad Lord
User offline. Last seen 9 years 47 weeks ago. Offline
Joined: 27 May 2003
Posts: 256
Groups: None
hi Bob

Primavera P3.1 would do this for you, it is alot more powerful than MSP and can handle any amount of activities, very good at resourcing/cost control, you can export resource and cost information into a csv file which you can open up in Excel, have a look at www.primavera.co.uk

hope that helps

regards

brad
Top