Smart questions
Smart answers
Smart people
INTELLIGENT WORK FORUMS
FOR ENGINEERING PROFESSIONALS

Member Login
Remember Me
Forgot Password?
Join Us!

Come Join Us!

Are you an
Engineering professional?
Join Eng-Tips now!
  • Talk With Other Members
  • Be Notified Of Responses
    To Your Posts
  • Keyword Search
  • One-Click Access To Your
    Favorite Forums
  • Automated Signatures
    On Your Posts
  • Best Of All, It's Free!
Join Eng-Tips
*Eng-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.

LINK TO THIS FORUM!

Add Stickiness To Your Site By Linking To This Professionally Managed Technical Forum.
Just copy and paste the
code below into your site.

Eng-Tips LinkedIn® Group

Partner With Us!

"Best Of Breed" Forums Add Stickiness To Your Site
Partner Button
(Download This Button Today!)

Feedback

"...Where have you been all my life! I found the answer I needed in seconds..."
More...

Geography

Where in the world do Eng-Tips members come from?
Click Here To Find Out!

Eng-Tips Shirts!

Get Eng-Tips Swag
Get your
Eng-Tips Forums
SWAG here!
Home > Forums > Engineering Computer Programs > General Engineering Programs > -Engineering spreadsheets Forum

Looking for Project Management Excel TemplateHelpful Member! 

thread770-323623
Read More Threads Like This One
REDesigner09 (Aerospace)
9 Jun 12 23:08
Hi Group,

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


    * Planned vs. Actual

    * Be able to calculate duration over or under target date(s)

    * Demonstrate current project statuses vs. milestones

    * Work Performances - Percentages

    * Costs

    * Factor in teams time off durations due to vacations or being out of office

    * Anything else that helps PMs to thoroughly track projects or programs.
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 (Mechanical)
13 Jun 12 13:39
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 (Aerospace)
16 Jun 12 11:27
Thanks
dik (Structural)
17 Jun 12 22:55
I haven't gone over it yet, but looks like a lot of effor went into it. Thanks, Dik
dcasto (Chemical)
21 Jun 12 0:45
look at openproject for free
Read More Threads Like This One

Reply To This Thread

Posting in the Eng-Tips forums is a member-only feature.

Click Here to join Eng-Tips and talk with other members!

Back To Forum

Back To -Engineering spreadsheets

Close Box

Join Eng-Tips® Today!

Join your peers on the Internet's largest technical engineering professional community.
It's easy to join and it's free.

Here's Why Members Love Eng-Tips Forums:

Register now while it's still free!

Already a member? Close this window and log in.

Join Us             Close