At 07:08 31/07/2008 -0700, Mark Knecht wrote:
I have two tables of data, both arranged vertically. I need to
create a matrix of data mapping all combinations of the difference
between one column in in the first table against a similar column in
the second table. I.e. - two tables of 100 entries each will create
an array with 10,000 data points. (100x100 square)
Is there any straight forward way in OO to build this matrix?
I think so.
It is probably easier - though not necessary - to have the two
existing sets of values across the top and down the side of your new table.
o Copy one array into the left column of your new table, e.g. A2 to A101.
o Copy your other array into the top row of your new table, e.g. B1
to CW1. To do this, copy the column, select the new B1, use Edit |
Paste Special... (or right-click | Paste Special..., or
Ctrl+Shift+V), and tick the Transpose box under Options.
o In B2, construct the formula =B$1-$A2 (or =$A2-B$1 if you prefer).
o Drag the fill handle to copy this formula down column B from B2 to B101.
o *With the resulting column still selected*, drag the result across
all rows at once from column B to column CW.
You can equally drag across row 2 and then down if you prefer, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
