Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Worksheet Functions / August 2006

Tip: Looking for answers? Try searching our database.

Aladin...HELP!!!  Running Averages of last 10 data entries, excluding blank cells

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
ryan.chalupsky@apigroupinc.us - 25 Aug 2006 17:34 GMT
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.
Each worksheet is 1 month of data
Row 1:  I have days of the week
Row 2:  I have the dates of the month
Row 3:  Manhours for the day
Row 4: Tons of Steel
Row 5: Pieces of steel

column 1: Job numbers
column 2: Descripition of rows (manhours, Tons, pieces)
rest of columns are days/dates

again, I want to calculate the average of the last 10 dates of activity
on that job with comparision between manhours per ton, manhours per
piece, sum of total manhours, and to date manhours per ton.

If anyone could help me, I would greatly appreciate it.

Respectfully

Ryan
Richard Buttrey - 25 Aug 2006 18:38 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
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
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.