[AccessD] average in matrix

Pedro Janssen pedro at plex.nl
Thu Jan 6 14:07:26 CST 2005


Hi Gustav,

1.Why is it sometimes so difficult to read a simple sentence properly??? Am
I realy getting older?

2.You almost "spelled"the vba code out for me.

Thanks

Pedro


----- Original Message -----
From: "Gustav Brock" <Gustav at cactus.dk>
To: <accessd at databaseadvisors.com>
Sent: Thursday, January 06, 2005 3:07 PM
Subject: Re: [AccessD] average in matrix


> Hi Pedro
>
> 1. It's the other way around:
> "as all cells - except those (in your example) containing 1 - are
> counted twice."
>
> 2. It is just to walk the matrix:
> Pick first row.
> For each row
>   Move right the row counting per column.
>   If column is Null move left and down, count cell.
>   Move down the column counting per row.
> Next Row
> Calculate average.
>
> /gustav
>
> >>> pedro at plex.nl 06-01-2005 13:51:26 >>>
> Hello Gustav,
>
> I don't understand what you mean by:  "as all cells except those (in
> your example) containing 1 are counted twice."   Why are the 1's counted
> twice.
>
> Can you explain how to do this in excel with a routine. I have several
> matrixes with about 100 samples. To do that by hand (even per sample)
> costs me a lot of time.
>
> Pedro Janssen
>
> In antwoord op:
>
> > From: "Gustav Brock" <Gustav at cactus.dk>
> > To: <accessd at databaseadvisors.com>
> > Date: Thu, 06 Jan 2005 11:54:01 +0100
> > Subject: Re: [AccessD] average in matrix
> >
> >
> > Hi Pedro
> >
> > OK, that explains.
> > The calculation can be easily done in Excel as well as with VBA in
> > Access.
> > The "strange" part is that the calculation is not a straight average
> of
> > the matrix as all cells except those (in your example) containing 1
> are
> > counted twice.
> >
> > /gustav
> >
> > >>> pedro at plex.nl 05-01-2005 23:40:25 >>>
> > Hello Gustav,
> >
> > In the cells, there was no text present, but after making the format
> of
> > the cells, Number (all cells were general), i saw all data in the
> linked
> > excel range. Strange that it is seen an text from column/row 26
> (column AA
> > in Excel).
> >
> > You were right saying that the query gave the average of all the
> cells
> > and not only the last row. I don't know why i said that.
> >
> > I will ask at a excel group if this "strange calculation" (its a
> matrix
> > for result of genetic DNA samples. The values give the differences
> between
> > a sample according to the other samples) can be done in Excel.
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>






More information about the AccessD mailing list