Appending collected x & y data from linkage analysis to another sheet

[mstickma]

Hi,

I want to run a test where I look at a various-length linkages that
each have two connecting pins. The linkage will have an angle
monitoring device added to it that wirelessly sends data to a display
box.
The pin at the right end will be (0,0), and the left pin is the one I
will measure the x,y position of. I then rotate the linkage about the
right pin and read the "rise" and "run" that the box displays. I then
want to see if the measured position of the pin matches the calculated
expected position. I am looking for system accuracy as a result.
I want the user to input the linkages' pin-to-pin distance, and the
"rise" and "run" from the display. Then I would like to add a button
that would append the inputted "rise" to a column on another sheet,
with then a calculated "rise" next to it in the same row. I would then
add blank column to create a space within the row to calculate the
delta of the input vs the calculated values later.
I would like to do the same with the "run" data, putting the inputted
"run" in a column next to the calculated "run" column, all in the same
row as the "rise" data. I am currently doing the calculations in cells
just below the inputs.
I intend to take many measurements, and this is why I wish a way to
automate this process. Can anyone suggest a way to do this? I am a
novice with macros, and so I this is why I am looking for some
guidance.

Thanks!

 

[Pete_UK]

I'm not sure exactly what you want, or why you need a macro. If in
Sheet1 you enter the "rise" (or y value) in, say, column C, then you
can copy this into Sheet2 column A with a formula like this:

=IF(Sheet1!C2="","",Sheet1!C2)

and copy this down. Similarly, if the "run" data is in column E:

=IF(Sheet1!E2="","",Sheet1!E2)

in D2 of Sheet2.

Using polar co-ordinates, sin(theta)=Rise/R and cos(theta)=Run/R,
where theta is the angle with the horizontal and R is the distance
between the two pins (the radius, as the linkage rotates). You can
also use pythagoras to determine R from your original co-ordinates of
the left-hand pin.

So what is it that you want to do?

Pete