Hi,
I'm building a VBA project but seem to have had complete brain freeze.
I have large data sets that are being manipulated.
Part of the project (and I thought it was a minor one) is to take National Grid coordinates (Easting and Northing) and create new data sets. The positioning device is offset from the other data collected by a fixed amount along and left or right of the line walked. Therefore, my intention is to allow the user to input an x (left/right) and y (along the line walked) offsets, take the bearing between to adjacent points (eg. pt1 and pt2), use that bearing from the preceding point (pt1) and create a new coordinate (r1) with the x and y offset. Then continue from pt2 to pt3 to create coordinates for r2.....etc.
.........r1...................r2...................r3....
pt1..................pt2.................pt3...............etc
In the real world pt1 to pt2 to pt3 are not in a perfectly straight line and can go in any direction. This is data collected at 10Hz walking along lines.
Before I committed to VBA I was trying to achieve this in Excel. I don't know whats happened to me - quadrants - they seem to be flummoxing me. Bearings are taken clockwise from zero at north. But as you move into each quadrant my calculations fall to pieces.
I think I've resharpened my pencil until it's almost gone!
If someone could give me a pointer it would be much appreciated - and save me a fortune in pencils!
I'm building a VBA project but seem to have had complete brain freeze.
I have large data sets that are being manipulated.
Part of the project (and I thought it was a minor one) is to take National Grid coordinates (Easting and Northing) and create new data sets. The positioning device is offset from the other data collected by a fixed amount along and left or right of the line walked. Therefore, my intention is to allow the user to input an x (left/right) and y (along the line walked) offsets, take the bearing between to adjacent points (eg. pt1 and pt2), use that bearing from the preceding point (pt1) and create a new coordinate (r1) with the x and y offset. Then continue from pt2 to pt3 to create coordinates for r2.....etc.
.........r1...................r2...................r3....
pt1..................pt2.................pt3...............etc
In the real world pt1 to pt2 to pt3 are not in a perfectly straight line and can go in any direction. This is data collected at 10Hz walking along lines.
Before I committed to VBA I was trying to achieve this in Excel. I don't know whats happened to me - quadrants - they seem to be flummoxing me. Bearings are taken clockwise from zero at north. But as you move into each quadrant my calculations fall to pieces.
I think I've resharpened my pencil until it's almost gone!
If someone could give me a pointer it would be much appreciated - and save me a fortune in pencils!
