Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / March 2008

Tip: Looking for answers? Try searching our database.

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

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
mstickma - 03 Mar 2008 20:09 GMT
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 - 04 Mar 2008 00:45 GMT
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

> Hi,
>
[quoted text clipped - 23 lines]
>
> Thanks!

Rate this thread:






 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.