I hope I am not violating any forum rules by posting here.

The problem that I am trying to solve has to do with creating 2d arrays (matrices) by referencing cells and using formulas upon some of those cells.

Let me explain.

I have a table in Excel (defined as an Excel table, called "Table") with the following 10 columns as shown in the picture below.

Each row represents a point whose coordinates with respect to the original coordinating system (XYZ) are on the columns X, Y, Z.

I would like to transform those coordinates to another coordinate system, called X'Y'Z', which is the result of rotating the original coordinating system by "a" with respect to the original X axis, b with respect to the original Y axis and c with respect to the original Z axis. The new coordinates will be X', Y' and Z'.

From a mathematical point of view, the transformation is straight forward.

I have to calculate the product of a 3-element vector A=[X, Y Z] (transpose) and the of the 3 transformation matrices [Ra], [Rb], [Rc]:

A*Ra*Rb*Rc

The transformation matrices Ra, Rb, Rc are 3x3 in size, with elements such as 0, 1, cos(a), cos(b), cos(c), sin(a), sin(b), sin(c).

So for every point (or row if you will) on my table, the transformation matrices should be different.

Is there a way to write this matrices in a vector format to perform that calculation in a row style format?

I have tried to type a formula which I know is wrong, hoping that it will show you what I am trying to achieve.

In that formula for example Rx should be something like:

{1, 0, 0 ; 0, cos(radians[@α]), sin(radians[@α]) ; 0, -sin(radians[@α]), cos(radians[@α])}. But I guess it doesn't really work like that in Excel.

Thanks for taking the time to read this and for your help.

I don't mind macros myself, but this spreadsheet will be used by other macro-phobic people, thus it would be great if we could avoid them.

Regards,

K