If I take a total of 12 XYZ points. 4 on the print bed with it all the way forward, 4 with it all the way back, and then 1 point on the X carriage with it in the 4 extremes of it's movement, I can calculate how square each axis is to each other.
I just need to transform the input data into a new coordinate system so my mind can make sense of the points.
A-B should be along the X axis and A-D should be along the Y axis. This is called an alignment – I am just redefining the coordinates to something on the printer as opposed to those captured by the measuring device.
Rotated thusly, I can look at C and know if it's high or low. I can also look at EFGH and know if my print bed is tracking correctly. IJKL can be tweaked to be perpendicular to the print bed's travel using actual, real measurements of adjustment.
I remember matrices from college. I remember flunking the class they where in repeatedly. I remember changing majors to something that doesn't require that class. I've looked for some example spreadsheets, downloaded them, and they are as opaque to me now as they where back then.
I need a spreadsheet where I enter my 12 XYZ coordinates, and next to them I get the transformed points. The calculations should happen below on that sheet. Could somebody help me (read as 'make this for me')?