Excel Link Duration to Part Number 1

[dingpud]

OK, I am going to give this request a shot. I have machining operations which take a given amount of time...usually recorded in minutes. I can have multiple machining operations...usually up to 4. Is there any way that I can put a total number of parts that I want machined into Project/Excel so that the Ghantt chart will show the amount of machining time, based off of the amount of parts that I choose to build, given the preset durantion. Durantion in minutes * total number of parts = total number of minutes for lot of parts.

Previously I would complete this work before creating the project in Project. I would take my quantity needed and multipy by the machining time per piece. Works well as an Excel sheet. This works fine, but i have a project where being able to input (and possibly change/update) the quantities of parts, would be helpful. I don't want to run Excel as a separate operation and just reference the info. Cutting and pasting a column full of values would be helpful. ~350 lines, so i would rather not input manually. Quantities of parts required follows no typical pattern of any sort.

Sorry if this is difficult to understand. Thanks for any and all help.

--pud--

 

[dingpud]

I think I found the solution. I'll post it later tonight. For now, does anyone know how the plot on the Ghantt chart, a custom duration field? I have a custom duration field calculated, but I want to use the custom duration field, and not the standard one.

Any suggestions?

 

[PDQBach]

Do you mean you want to display the value in your custom duration field?

View | Gantt
Format | Bar Styles...

In the upper portion of the display, click on the Task row.
In the lower portion of the disaply, click on the Text tab.
Choose the location where you want to display your custom variance field.

Or did you mean something else?

 

[dingpud]

I think I got it to work, but now think that I need something different.

Is there a way to set your completion schedule as a # out of # complete? Meaning, can I get the % complete bar to self populate each time I put in a new completed value?

So, for Task 1 I have typed in and set that I need a quantity of 100 of that part before that task is complete. Each week, I would type in the amount complete. So if I had 50 out of 100 complete, the Ghantt chart would show that I am 50% complete.

I hope this doesn't seem like too much of a newbie question, but I just can't seem to figure out how to do it.

Thanks.

 

[PDQBach]

1. Display the %WrkComplete column. You'll have to calculate the %number. It's possible to get project to do the calculations but it's faster if you do it.

2. View | Gantt
Format Bar Styles ...
Look for the row labelled "Progress"
In the "To" column, change the entry to %WorkComplete.

Remember to keep your tasks as Fixed Work!