Do you need to see a 10 day rolling average for each of your measures
for each day, or just a single 10 day ra, for each measure which just
looks at the latest 10 days.
It's also a little difficult to visualise your data. You say you need
rolling averages for each of your jobs, and it appears that you have
more than 1 job on each sheet listed in column 1. To see 5 rolling
averages for each job would imply a set of 5 rows for each of the
jobs.
If the data is not confidential and you want to send me the workbook
it would make it easier to understand the data.
Regards
>I have a worksheet that I am trying to calculate the a rolling average
>of the last 10 days of activity for manhours/tons of steel.
[quoted text clipped - 18 lines]
>
>Ryan
__
Richard Buttrey
Grappenhall, Cheshire, UK
__________________________
ryan.chalupsky@apigroupinc.us - 25 Aug 2006 18:55 GMT
> Do you need to see a 10 day rolling average for each of your measures
> for each day, or just a single 10 day ra, for each measure which just
[quoted text clipped - 38 lines]
> Grappenhall, Cheshire, UK
> __________________________
Mr. Buttrey,
Worksheet on the way.
Ryan