Re: Matrix operations
- From: sensorflo@xxxxxxxxx
- Date: 2 Mar 2006 13:16:30 -0800
The problem with this approach however is that I don't have the place
for the extra cells that T2 needs. I very much liked to calculate T2
within the formula.
Maybe I have to say what this is all about. The sheet converts
coordinates between different coordinate systems. Look at the 'excel
sheet' below
A B C D E F G
1 T1: 1 0
2 0 1
3 V1: 1
4 1
5
8 |-sys1 -----------------|-sys2------------------
9 x y t x y t
10 |-----------------------|-----------------------
11 0 0 0 =f12x() =f12y() =f12t()
12 0 1 1 =f12x() =f12y() =f12t()
.........
20 =f21x() =f21y() =f21t() 0 0 0
21 =f21x() =f21y() =f21t() 0 1 1
The first part contains the parameters of the Transformation. That
would be T1 = B1:C2, V1 = B3:B4. The rest is a list of coordinates. In
each row coordinates are given in one system and calculated in the
other one. v1 would now be the 2 cells in the x y column, x (as in my
first posting) would be the t column. Note that the x in this posting
is not the x in the first posting - sorry for the confusion.
The formulas f12x() etc only symbolise the actual formulas and shows
which cells contain the same formulas. An actual example would be (for
D11):
=INDEX( MMULT( $B$1:$C$2 ; $B$3:$B$4 + MMULT( {cos(C11),sin(C11);
-sin(C11),cos(C11)}; A11:B11 ) ) ; 1 )
However, as said in my first posting, this is not possible.
As said the purpose is to transform any coordinates between the
systems. That is it is not known in advance which row converts from
which system into which. The user fills in values for the coordinates
of one system and then copies the required formulas into the other
columns of the same row. So he gets his custom list of coordinates.
Now one can see that I don't have space to put T2 into any cells. Each
Row would need a 2*2 cell block as temporary storage for T2.
Again, this is simplified. Actually I have 3 systems, each has 4
dimensions, and there are about 4 Matrices and 4 Vectors being the
parameters of the transformation.
Greetings
Florian Kaufmann
.
- References:
- Matrix operations
- From: sensorflo
- Re: Matrix operations
- From: sensorflo
- Re: Matrix operations
- From: delfiled
- Matrix operations
- Prev by Date: xlcFormulaArray strange behavior and UDF
- Next by Date: Re: hide and show columns using one control button
- Previous by thread: Re: Matrix operations
- Next by thread: Ranking
- Index(es):
Relevant Pages
|
