software

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

quot;Scott Wquot; gt; wrote in message
...
gt;I am trying to track running averages from one process to another, daily
gt;and
gt; weekly. The issue that I have is that we are running product in lots and
gt; not
gt; all of the lots are completed in one day. So I might have started 10 lots
gt; and
gt; only 8 are complete so currently the average is looking at the number of
gt; completed lots and dividing by the number of started lots. Can someone
gt; tell
gt; me how to set up the work sheet so that the average is just the completed
gt; lots and as the others get completed the average is recalculated.
gt;
gt; Thanks
Col B Col D20 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

quot;Scott Wquot; wrote:

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

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

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

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

--
Don Guillett
SalesAid Software

quot;Scott Wquot; gt; wrote in message
...
gt; Sorry, I left out the formulas. I am just using
gt; =SUM(WIP!F4:F15)/SUM(WIP!D415)
gt; quot;Scott Wquot; wrote:
gt;
gt;gt; I am trying to track running averages from one process to another, daily
gt;gt; and
gt;gt; weekly. The issue that I have is that we are running product in lots and
gt;gt; not
gt;gt; all of the lots are completed in one day. So I might have started 10 lots
gt;gt; and
gt;gt; only 8 are complete so currently the average is looking at the number of
gt;gt; completed lots and dividing by the number of started lots. Can someone
gt;gt; tell
gt;gt; me how to set up the work sheet so that the average is just the completed
gt;gt; lots and as the others get completed the average is recalculated.
gt;gt;
gt;gt; 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

quot;Scott Wquot; wrote:

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

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:F33gt;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.
--
Don Guillett
SalesAid Software

quot;Scott Wquot; gt; wrote in message
...
gt;I am trying to get a running yield of parts going through my process
gt;
gt; I sorry I am not sure what you mean by the F colum. What should be in the
gt; F
gt; colum? I am looking at different operations and the amount of parts that
gt; make
gt; it from one operation to the next, such as,
gt;
gt;
gt; Process A Process B Process C Process D
gt; Col A Col B Col C Col D Col E Col F Col G Col H
gt; pcs in pcs out pcs in pcs out pcs in pcs out pcs in pcs out
gt;
gt; 20 20 20 19 19 10 10
gt; 9
gt; 20 19 19 19 19 19 19
gt; 20 20 20 20 20
gt; 20 18 18
gt; 20
gt;
gt; I am trying to calulate the running averages for each process by dividing
gt; the number I finished with by the number I started with and since not all
gt; parts have gone through the process I am not getting an accurate yield. I
gt; would like to know how I can get the running yields of those lot that have
gt; gone through and update the yields as the others are completed
gt;
gt; quot;Scott Wquot; wrote:
gt;
gt;gt; I am trying to track running averages from one process to another, daily
gt;gt; and
gt;gt; weekly. The issue that I have is that we are running product in lots and
gt;gt; not
gt;gt; all of the lots are completed in one day. So I might have started 10 lots
gt;gt; and
gt;gt; only 8 are complete so currently the average is looking at the number of
gt;gt; completed lots and dividing by the number of started lots. Can someone
gt;gt; tell
gt;gt; me how to set up the work sheet so that the average is just the completed
gt;gt; lots and as the others get completed the average is recalculated.
gt;gt;
gt;gt; 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.

quot;Don Guillettquot; wrote:

gt; YOUR post
gt;
gt; =SUM(WIP!F4:F15)/SUM(WIP!D415)
gt;
gt;
gt; Did you look at the AVERAGE function?
gt;
gt; You may need to use an averageif array formula
gt; =AVERAGE(IF($F$3:F33gt;0,$D$333))
gt; this would have to be entered/edited with ctrl shift enter instead of just
gt; enter.
gt; Then copy down. Still not sure this is what you want since you don't give
gt; desired result.
gt; --
gt; Don Guillett
gt; SalesAid Software
gt;
gt; quot;Scott Wquot; gt; wrote in message
gt; ...
gt; gt;I am trying to get a running yield of parts going through my process
gt; gt;
gt; gt; I sorry I am not sure what you mean by the F colum. What should be in the
gt; gt; F
gt; gt; colum? I am looking at different operations and the amount of parts that
gt; gt; make
gt; gt; it from one operation to the next, such as,
gt; gt;
gt; gt;
gt; gt; Process A Process B Process C Process D
gt; gt; Col A Col B Col C Col D Col E Col F Col G Col H
gt; gt; pcs in pcs out pcs in pcs out pcs in pcs out pcs in pcs out
gt; gt;
gt; gt; 20 20 20 19 19 10 10
gt; gt; 9
gt; gt; 20 19 19 19 19 19 19
gt; gt; 20 20 20 20 20
gt; gt; 20 18 18
gt; gt; 20
gt; gt;
gt; gt; I am trying to calulate the running averages for each process by dividing
gt; gt; the number I finished with by the number I started with and since not all
gt; gt; parts have gone through the process I am not getting an accurate yield. I
gt; gt; would like to know how I can get the running yields of those lot that have
gt; gt; gone through and update the yields as the others are completed
gt; gt;
gt; gt; quot;Scott Wquot; wrote:
gt; gt;
gt; gt;gt; I am trying to track running averages from one process to another, daily
gt; gt;gt; and
gt; gt;gt; weekly. The issue that I have is that we are running product in lots and
gt; gt;gt; not
gt; gt;gt; all of the lots are completed in one day. So I might have started 10 lots
gt; gt;gt; and
gt; gt;gt; only 8 are complete so currently the average is looking at the number of
gt; gt;gt; completed lots and dividing by the number of started lots. Can someone
gt; gt;gt; tell
gt; gt;gt; me how to set up the work sheet so that the average is just the completed
gt; gt;gt; lots and as the others get completed the average is recalculated.
gt; gt;gt;
gt; gt;gt; Thanks
gt;
gt;
gt;