Calc new Long/Lat based on centroid Long/Lat

bjcwheeler

New Member
Joined
Feb 22, 2018
Messages
2
Hello all,
I have a centroid (center pivot) with a known Longitude/Latitude. I have a distance, in feet, away from the known center point for both Latitude(X)/Longitude(Y). I need to calculate the new Latitude/Longitude for each point so that I can create a yield map. In the example below, I need to go 1278.303527 feet to the West of 44.111834 Lat and 195 feet north of Longitude -120.102744. There are 48K records that need a new X/Y calculated. Any assistance greatly appreciated.


X Y Yield X and Y are distance from the pivot in feet.
-1278.303527 195 32.60610248 Yield is in tons per acre.
-1278.303527 175 17.17232552
-1278.303527 165 0.501224722 Pivot
-1278.303527 155 4.907260956 44.111834 LAT 44° 6' 42.6"
-1278.303527 145 4.297264892 -120.102744 LONG -120° 6' 9.88"
-1278.303527 135 1.531962682
 

Some videos you may like

Excel Facts

Using Function Arguments with nested formulas
If writing INDEX in Func. Arguments, type MATCH(. Use the mouse to click inside MATCH in the formula bar. Dialog switches to MATCH.

offthelip

Well-known Member
Joined
Dec 23, 2017
Messages
1,242
Office Version
2010
Platform
Windows
What earth model are you using? If you are using a spherical earth model what radius are you using?
 

Watch MrExcel Video

Forum statistics

Threads
1,099,376
Messages
5,468,248
Members
406,575
Latest member
Joe00

This Week's Hot Topics

Top