Looking for Project Management Excel Template 1

[REDesigner09]

Hi Group,

Would someone happen to have a good Excel template or two that can produce Project Management Metrics, such as:

[ul]
* Planned vs. Actual
[/ul]
[ul]
* Be able to calculate duration over or under target date(s)
[/ul]
[ul]
* Demonstrate current project statuses vs. milestones
[/ul]
[ul]
* Work Performances - Percentages
[/ul]
[ul]
* Costs
[/ul]
[ul]
* Factor in teams time off durations due to vacations or being out of office
[/ul]
[ul]
* Anything else that helps PMs to thoroughly track projects or programs.
[/ul]

Additionally, I would like to graphically represent these metrics or most of them in some type of "clean" representative format.

For example, MS Project is great to show the plan & its predecessors, but I think it sucks to graphically show it on single or few sheets of paper. Seems that it doesn't matter how much formatting is done, there's always something that is not representative well.



Thanks

 

[ntweisen]

I have some project management templates that I could send you. They don't inlcude all the capabilities that you're looking for but it could be a good place to start.

http://excelspreadsheetshelp.blogspot.com

-

http://scripting4v5.com

 

[REDesigner09]

Thanks

 

[ntweisen]

I uploaded my project management templates to Google docs here: [URL unfurl="true"]https://docs.google.com/spreadsheet/ccc?key=0Av7RTFdlK3AmdE10cUFRN1lweC1hcXV0RGVFUWFZNnc[/url]

http://excelspreadsheetshelp.blogspot.com

-

http://scripting4v5.com

 

[dik]

I haven't gone over it yet, but looks like a lot of effor went into it. Thanks, Dik

 

[dcasto]

look at openproject for free