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

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

--
Don Guillett
SalesAid Software

"Scott W" wrote in message
...
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

Col B Col D


20 20
20 19
20 20
20 18
20
20
20

On a separate work sheet I have the daily average of my yields but now it
includes the incompleted parts

"Scott W" wrote:

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

Sorry, I left out the formulas. I am just using
=SUM(WIP!F4:F15)/SUM(WIP!D4:D15)
"Scott W" wrote:

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

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

--
Don Guillett
SalesAid Software

"Scott W" wrote in message
...
Sorry, I left out the formulas. I am just using
=SUM(WIP!F4:F15)/SUM(WIP!D4:D15)
"Scott W" wrote:

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

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

"Scott W" wrote:

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

YOUR post

=SUM(WIP!F4:F15)/SUM(WIP!D4:D15)


Did you look at the AVERAGE function?

You may need to use an averageif array formula
=AVERAGE(IF($F$3:F330,$D$3:D33))
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.
--
Don Guillett
SalesAid Software

"Scott W" wrote in message
...
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

"Scott W" wrote:

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

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.

"Don Guillett" wrote:

YOUR post

=SUM(WIP!F4:F15)/SUM(WIP!D4:D15)


Did you look at the AVERAGE function?

You may need to use an averageif array formula
=AVERAGE(IF($F$3:F330,$D$3:D33))
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.
--
Don Guillett
SalesAid Software

"Scott W" wrote in message
...
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

"Scott W" wrote:

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