Programming in VBA

[Alexander Heide]

Hi group!

Is there a way to arrive this goal in VBA?

Another Question:

Situation:
in
_______________________________
|x| | a b c | |x'|
|y| = | d e f |* |y'|
|z| | g h i | |z'|
_______________________________

i have |x| |x'|
|y| and |y'|
|z| |z'| .

How can i calculate the Matrix???

Thank you very much!
Greetings
Alexander

[Anton Haumer]

Alexander Heide schrieb:

>
> Hi group!
>
> Is there a way to arrive this goal in VBA?
>

which goal?

>
> Another Question:
>
> Situation:
> in
> _______________________________
> |x| | a b c | |x'|
> |y| = | d e f |* |y'|
> |z| | g h i | |z'|
> _______________________________
>
> i have |x| |x'|
> |y| and |y'|
> |z| |z'| .
>
> How can i calculate the Matrix???
>
> Thank you very much!
> Greetings
> Alexander

I believe there is no single-valued solution.
You have three equations:
x = a*x' + b*y' + c*z'
y = d*x' + e*y' + f*z'
z = g*x' + h*y' + i*z'
but nine unknown variables a..i
You may choose 6 of them
and calculate the remaining ones;
e.g. b,c,d,f,g,h all zero
a = x / x'
e = y / y'
i = z / z'

Best regards, Toni