Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

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

MS Project Gantt chart help

Status
Not open for further replies.

silent54

Technical User
Mar 24, 2013
3
US
I've created a project within MS Project 2010. I'm not sure if this is possible to do with Gantt chart or with its data but I would like to create a Forward Pass - Backward Pass with slack time table. I've looked through all the table views and haven't seen anything that's close to what I need. If possible could someone clue me in or at least point me in a good direction? Thanks
 
The calculation for the forward and backward pass is already done. You may add early start, late start, early finish, late finish, total slack fields to any table to see the data. They don't exist put together in one table, but you can create your own.

I hope this helps.
 
I think I may have figured it out just prior to seeing your response. I would need to create a new custom field (ES, EF, LS, LF) with a formula to display the data. Then create a box style that represents what I need to display. I assume this is what you meant? The formulas for the custom fields is the chock point. I think I have the ES, EF, LS, LF) formulas.
ES: ProjDateDiff([Project Start],[EarlyStart])/[Minutes Per Day]
EF: ProjDateDiff([Project Start],[EarlyFinish])/[Minutes Per Day]
LS: ProjDateDiff([Project Start],[LateStart])/[Minutes Per Day]
LF: ProjDateDiff([LateFinish],[Project Start])/[Minutes Per Day]

Not sure if they are totally correct as I received syntax errors initially especially [Minutes Per Day], which I believe is optional. The one I haven't figured out is the SL (slack). I'm not sure which formula function field to use to create this.
 
The Total Slack field is already calculated as are all other fields. I don't understand why you are trying to calculate these again. You may add the existing fields to the Network diagram (I'm assuming that is why you are referring to "box style.")
 
Yea, I just ran across them. I'm having one of those days again. Instead of looking for Early Start, I was looking for ES. Two Mondays in a row. Thanks again for the assistance.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top