hi, i''m learing to be a project manger, but i can''t figure out what one would use excel and microsoft project for in game development other than accounting, which isn''t exactly project management? anyone know? please reply to ash@ashleymonif.com iconoclast

Task subdivision, delegation and completion dates
Timelines
Group specific goal tracking
Budget

You can use just Excel along for all of those and many more things. A good spreadsheet is an invaluable tool.

Charles Galyon

I disagree with the Anonymous Poster.

The article isn''t a "Don''t use Project" rant. It''s a well-thought-out presentation of how to do project scheduling in Excel. It just also happens to include a paragraph on why MS Project is overkill and perhaps ill-suited to the task. Don''t focus on the negative when it occuppies less than 5% of the total article.


DavidRM
Samu Games

There might be a reason why he prefers Excel - the guy worked on the Excel 4.0 team

The world holds two classes of men -- intelligent men without religion, and religious men without intelligence. Abu''l-Ala-Al-Ma''arri (973-1057; Syrian poet)

Thank you everyone for your replies. I''m taking all of your feedback into consideration and I feel better prepared to explore how to use both of these programs for the tasks that I usually do on paper.

One more question: I have a resume, but what would comprise of a "reel" or portfolio for a Project Manager? Would I submit urls of the games I worked on? Or a VHS tape of the games I made?






iconoclast

You just need a resume which lists the titles you have worked on. A reel or protfolio is for artists to show the range of their work in the same way that Programmers will send demos. Both their roles are more creative so it is important for them to supply examples. Project management is a mangement role so a list of titles will do.

Dan Marchant
Obscure Productions

Read the article. He's a moron and obviously has one or both of the following traits:

1) He is an unorganized, undisciplined loose cannon.
2) He has no clue as to how to use Project to it's highest ability.

In my company we have a master Project file that contains all the individual files for various products we are working on. They all share the same resource pool (though I wish I could have more of me to draw from). Right now, our current batch of work extends out to the middle of 2003. What came in handy was when we decided to change the priority of one project over another so as to take advantage of some slack time on the part of the lead designer (me). Just by changing the priorities on the 2 projects and re-leveling the tasks, it gave us a completely new snapshot of what are timelines were... which delayed the end of one project a few months, but moved a very important revenue stream up by 6 months (making money is good!)

The best part of it is, I can at a glance see where time is being spent or where there is down time to include other things. I can try different scenarios by just changing a number here or there and having the program re-level the rest of the tasks. (e.g. What if that particualar series of coding tasks takes 10 days rather than 5? Is there a better way of structuring the rest of the project around it so as not to have downtime for other people waiting for that series of tasks to be completed?)

To sum up, Project is good for projects - Excel is good for crunching numbers. Too many people out there are addcited to Excel for all the wrong applications. Sure, you could use Excel... but you could also use a quill pen. It just depends on what level of functionality you want to have. Your choice.

Dave Mark
Intrinsic Algorithm Development
"Reducing the world to mathematical equations!"

Edited by - InnocuousFox on March 1, 2002 12:14:08 PM