Project Management

Please login or join to subscribe to this thread

Excel Template for Scheduling

linkedin twitter facebook   Estimating  
avatar
Diana Lambrianou Stone Ridge, Va, United States
Hello,

I work on a fairly large program which currently has about 160 active task orders assigned to it. We've created an excel spreadsheet with each task order having it's own tab and shows the people working the task order and how many estimated hours it will take to complete. Each task order has a workforce HOWEVER, engineers can be allocated across multiple task orders.

Each task order has it's own period of performance and it's own funding. My manager now wants a roll up of all the hours each person is assigned to work by month and on which task order he/she is working. The spreadsheet I have now is getting out of hand and I need to know if there is anything else I can be using to make things a little easier.

Thanks!
Sort By:
< 1 2 >
avatar
Richard Infusino Project Manager| Washington State Lakewood, Wa, United States
Nov 27, 2017 5:45 PM
Replying to Stéphane Parent
...
The only examples I have are work-related. It's probably easier for me to create a "sample" than try to sanitize an existing one. I'll put one together and submit it as community content. I'll let you know when it's posted.
If you find time for that, I’ll be very appreciative. Thank you, Stephane.
avatar
Stéphane Parent Self Employed / Semi-retired| Leader Maker Prince Edward Island, Canada
The template is ready. I've submitted my request for content. Hopefully, it will be posted later this week.
...
1 reply by Richard Infusino
Nov 30, 2017 10:29 PM
Richard Infusino
...
Thank you, Stephane!
avatar
Richard Infusino Project Manager| Washington State Lakewood, Wa, United States
Nov 28, 2017 10:59 AM
Replying to Stéphane Parent
...
The template is ready. I've submitted my request for content. Hopefully, it will be posted later this week.
Thank you, Stephane!
avatar
Stéphane Parent Self Employed / Semi-retired| Leader Maker Prince Edward Island, Canada
It's finally posted! Check out this Excel template.
< 1 2 >

Please login or join to reply

Content ID:
ADVERTISEMENTS

"If at first you don't succeed, try, try again. Then quit. There's no use being a damned fool about it."

- W. C. Fields

ADVERTISEMENT

Sponsors







Vendor Events

See all Vendor Events

Newsletters

Jun 3: The Career Problem Facing New PMs
May 20: Your PM Career as a Project Life Cycle
May 13: The Big Lie After Layoffs

See all newsletters