Continue to Site

Eng-Tips is the largest engineering community on the Internet

Intelligent Work Forums for Engineering Professionals

  • Congratulations waross on being selected by the Eng-Tips community for having the most helpful posts in the forums last week. Way to Go!

Human Resource Planning Spreadsheets 2

Status
Not open for further replies.

jartgo

Civil/Environmental
Oct 20, 2005
220
I'm looking for a spreadsheet or inexpensive software that I can use to schedule projects and tasks from a human resource standpoint. For example, I have task A that will take 20 hours, I want Jim to work on it for 4 hours a week until complete, starting Monday. Task B will take 160 hours and I want Jim to work on it for 20 hours a week until complete, starting next Monday. Does anyone use of know of something like this. Something like a Gantt chart of this nature would be helpful.
Thanks in advance.
 
Replies continue below

Recommended for you

You can make your own in just a few hours using "Xcel".
You can make it "Smart" so it will do all the math for you by person, by project, by day, by week, (what else do you need or want). It is truly very simple.
You can also modify it yourself as your needs change, you do bot need to go back to any third party supplier.

prognosis: Lead or Lag
 
What you describe is exactly what MS Project does, and does well.
There are better programs, but they cost way more.
There are cheaper programs, but they don't really work.

You can sort of do it with Excel, but it's a lot more work for you, and that gets worse faster as the number of people goes up.

Get a trial version of Project, and beat on it for a while.





Mike Halloran
Pembroke Pines, FL, USA
 
Same stuff construction management types use.

MS Project can be expensive. Primavera can be even more expensive.

If wanting something cheaper but not necessarily as high tech, could try the open source LibrePlan.
 
Have you looked at:
Sourceforge has others:
TTFN
faq731-376
7ofakss

Need help writing a question or understanding a reply? forum1529
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor