Calculation Help

Originally Posted by MrShorty

Pictures of charts don't allow us to see what you are doing in the spreadsheet, s it is difficult to see what you are doing wrong.

It looks like a basic rotation problem. It's too bad your math skills are not the greatest, because this looks to be a simple matrix multiplication. See wikipedia: https://en.wikipedia.org/wiki/Rotati...Two_dimensions Remember that Excel has the MMULT() function for matrix multiplications: https://support.office.com/en-us/art...3-e4ad3c7245eb
Also remember that, like almost all other programming languages, Excel's trig functions work with angles in radians.

Thanks for giving me some idea where to go Shorty ! I will investigate and see if I can work out a solution much much appreciated