software

I have a number of worksheets where each contains two rows of data
representing wind speed and direction recorded every 10sec (8636 records per
day). I would like to average every 60 records so that each record on a new
worksheet (or rows)represents the average wind speed and direction every 10
minutes of the day. I would also like to be able to set up a new data set
with only data recorded every 10 minutes (or other time interval)
represented. Any help would be much appreciated
--
MC

In column A of Sheet2 I have some numbers
On Sheet3, I want the average of these in groups of 10
IN any cell in Sheet 3 I used:
=AVERAGE(INDIRECT(quot;Sheet2!Aquot;amp;(ROW(A1)-1)*10 1amp;quot;:Aquot;amp;(ROW(A1)-1)*10 10))
I copied this down the column and got what was needed

Can you adapt this?
To get every 10th entry I use =INDIRECT(quot;Sheet2!Aquot;amp;(ROW(A1)-1)*10 1) and
copied down the column
This gave me the data from A1, A11, A21..... on Sheet2
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

quot;MCquot; gt; wrote in message
...
gt;I have a number of worksheets where each contains two rows of data
gt; representing wind speed and direction recorded every 10sec (8636 records
gt; per
gt; day). I would like to average every 60 records so that each record on a
gt; new
gt; worksheet (or rows)represents the average wind speed and direction every
gt; 10
gt; minutes of the day. I would also like to be able to set up a new data set
gt; with only data recorded every 10 minutes (or other time interval)
gt; represented. Any help would be much appreciated
gt; --
gt; MC
Worked a treat, thanks
--
MCquot;Bernard Liengmequot; wrote:

gt; In column A of Sheet2 I have some numbers
gt; On Sheet3, I want the average of these in groups of 10
gt; IN any cell in Sheet 3 I used:
gt; =AVERAGE(INDIRECT(quot;Sheet2!Aquot;amp;(ROW(A1)-1)*10 1amp;quot;:Aquot;amp;(ROW(A1)-1)*10 10))
gt; I copied this down the column and got what was needed
gt;
gt; Can you adapt this?
gt; To get every 10th entry I use =INDIRECT(quot;Sheet2!Aquot;amp;(ROW(A1)-1)*10 1) and
gt; copied down the column
gt; This gave me the data from A1, A11, A21..... on Sheet2
gt; --
gt; Bernard V Liengme
gt; www.stfx.ca/people/bliengme
gt; remove caps from email
gt;
gt; quot;MCquot; gt; wrote in message
gt; ...
gt; gt;I have a number of worksheets where each contains two rows of data
gt; gt; representing wind speed and direction recorded every 10sec (8636 records
gt; gt; per
gt; gt; day). I would like to average every 60 records so that each record on a
gt; gt; new
gt; gt; worksheet (or rows)represents the average wind speed and direction every
gt; gt; 10
gt; gt; minutes of the day. I would also like to be able to set up a new data set
gt; gt; with only data recorded every 10 minutes (or other time interval)
gt; gt; represented. Any help would be much appreciated
gt; gt; --
gt; gt; MC
gt;
gt;
gt;