Running Averages

[Guest]

I am trying to track running averages from one process to another, daily and
weekly. The issue that I have is that we are running product in lots and not
all of the lots are completed in one day. So I might have started 10 lots and
only 8 are complete so currently the average is looking at the number of
completed lots and dividing by the number of started lots. Can someone tell
me how to set up the work sheet so that the average is just the completed
lots and as the others get completed the average is recalculated.

Thanks

 

[Don Guillett]

Show us how you have it set up now and what formulas you are using.

 

[Guest]

Col B Col D


20 20
20 19
20 20
20 18
20
20
20

 

[Guest]

Sorry, I left out the formulas. I am just using
=SUM(WIP!F4:F15)/SUM(WIP!D415)

 

[Don Guillett]

and you didn't show the F column. Have a look in help index for AVERAGE

 

[Guest]

I am trying to get a running yield of parts going through my process

I sorry I am not sure what you mean by the F colum. What should be in the F
colum? I am looking at different operations and the amount of parts that make
it from one operation to the next, such as,


Process A Process B Process C Process D
Col A Col B Col C Col D Col E Col F Col G Col H
pcs in pcs out pcs in pcs out pcs in pcs out pcs in pcs out

20 20 20 19 19 10 10 9
20 19 19 19 19 19 19
20 20 20 20 20
20 18 18
20

I am trying to calulate the running averages for each process by dividing
the number I finished with by the number I started with and since not all
parts have gone through the process I am not getting an accurate yield. I
would like to know how I can get the running yields of those lot that have
gone through and update the yields as the others are completed

 

[Don Guillett]

YOUR post

=SUM(WIP!F4:F15)/SUM(WIP!D415)


Did you look at the AVERAGE function?

You may need to use an averageif array formula
=AVERAGE(IF($F$3:F33>0,$D$333))
this would have to be entered/edited with ctrl+shift+enter instead of just
enter.
Then copy down. Still not sure this is what you want since you don't give
desired result.

 

[Guest]

Sorry Don for not being more specific. What I am trying to do is have the
yields from each batch reported as a whole. So if the process had more
batches or parts enter and less exit because they were not all completed the
yield or average would only look at those cells completed and give me the
daily running average from each process. I hope that this makes sense. Thank
you for your help.