Spreadsheet: 863496d1710953858-calculating-farm-hay-bale-drop-locations-chatgp-nor-gemini-cant-figure-this-out-calculating-farm-hay-bale-drop-locations
Sheet: Coordinates

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Proof
 | Calculating Farm Hay Bale Drop Locations |  |  |  | Bale | Bale | Cumulative |  |  |  |  |  |  |  | Distance based on
 | https://www.excelforum.com/excel-formulas-and-functions/1421274-calculating-farm-hay-bale-drop-locations-chatgp-nor-gemini-cant-figure-this-out.html |  |  |  | [NAME] | Collection | Distance to | Distance to | Balance | Net | Net |  | Latitude | Longitude | Haversine | Maths
 |  |  |  |  | Point | Length | complete L | complete L | Distance | S→N | W→E |  |  |  | formula | Equation
 | Starting Latitude (Lat) | 40.152995
 | Starting Longitude (Long) | -105.007847 |  |  | 2 | 130
 | [NAME] of the farm (W) | 680 | ft |  | 3 | 130
 | Length of the farm (L) | 1200 | ft |  | 4 | 130
 | [NAME] (S) | 20 | ft |  | 5 | 130
 | Bale Collection Length | 130 | ft |  | 6 | 130
 | or [NAME] distance (D) |  |  |  | 7 | 130
 | Number of swath |  |  |  | 8 | 130
 | Total farming length |  | ft |  | 9 | 130
 | Total number of bale drop points |  |  |  | 10 | 130
 | ft to km conversion | 0.0003048 |  |  | 11 | 130
 |  |  |  |  | 12 | 130
 | Earth's circumference | 40075 | km |  | 13 | 130
 | Earth's radius | 6378 | km |  | 14 | 130
 |  |  |  |  | 15 | 130
 | [NAME] used |  |  |  | 16 | 130
 | New Latitude |  |  |  | 17 | 130
 | = Latitude+(Distance/Earth’s Circumference)×360​ |  |  |  | 18 | 130
 | = Latitude+(Distance/Earth’s [NAME] |  |  |  | 19 | 130
 | New Longitude |  |  |  | 20 | 130
 | = Longitude+(Distance/Earth’s Radius x COS(Latitude))×180/ϖ |  |  |  | 21 | 130
 |  |  |  |  | 22 | 130
 |  |  |  |  | 23 | 130
 |  |  |  |  | 24 | 130
 |  |  |  |  | 25 | 130
 |  |  |  |  | 26 | 130
 |  |  |  |  | 27 | 130
 |  |  |  |  | 28 | 130
 |  |  |  |  | 29 | 130
 |  |  |  |  | 30 | 130
 |  |  |  |  | 31 | 130
 |  |  |  |  | 32 | 130
 |  |  |  |  | 33 | 130
 |  |  |  |  | 34 | 130
 |  |  |  |  | 35 | 130
 |  |  |  |  | 36 | 130
 |  |  |  |  | 37 | 130
 |  |  |  |  | 38 | 130
 |  |  |  |  | 39 | 130
 |  |  |  |  | 40 | 130
 |  |  |  |  | 41 | 130
 |  |  |  |  | 42 | 130
 |  |  |  |  | 43 | 130
 |  |  |  |  | 44 | 130
 |  |  |  |  | 45 | 130
 |  |  |  |  | 46 | 130
 |  |  |  |  | 47 | 130
 |  |  |  |  | 48 | 130
 |  |  |  |  | 49 | 130
 |  |  |  |  | 50 | 130
 |  |  |  |  | 51 | 130
 |  |  |  |  | 52 | 130
 |  |  |  |  | 53 | 130
 |  |  |  |  | 54 | 130
 |  |  |  |  | 55 | 130
 |  |  |  |  | 56 | 130
 |  |  |  |  | 57 | 130
 |  |  |  |  | 58 | 130
 |  |  |  |  | 59 | 130
 |  |  |  |  | 60 | 130
 |  |  |  |  | 61 | 130
 |  |  |  |  | 62 | 130
 |  |  |  |  | 63 | 130
 |  |  |  |  | 64 | 130
 |  |  |  |  | 65 | 130
 |  |  |  |  | 66 | 130
 |  |  |  |  | 67 | 130
 |  |  |  |  | 68 | 130
 |  |  |  |  | 69 | 130
 |  |  |  |  | 70 | 130
 |  |  |  |  | 71 | 130
 |  |  |  |  | 72 | 130
 |  |  |  |  | 73 | 130
 |  |  |  |  | 74 | 130
 |  |  |  |  | 75 | 130
 |  |  |  |  | 76 | 130
 |  |  |  |  | 77 | 130
 |  |  |  |  | 78 | 130
 |  |  |  |  | 79 | 130
 |  |  |  |  | 80 | 130
 |  |  |  |  | 81 | 130
 |  |  |  |  | 82 | 130
 |  |  |  |  | 83 | 130
 |  |  |  |  | 84 | 130
 |  |  |  |  | 85 | 130
 |  |  |  |  | 86 | 130
 |  |  |  |  | 87 | 130
 |  |  |  |  | 88 | 130
 |  |  |  |  | 89 | 130
 |  |  |  |  | 90 | 130
 |  |  |  |  | 91 | 130
 |  |  |  |  | 92 | 130
 |  |  |  |  | 93 | 130
 |  |  |  |  | 94 | 130
 |  |  |  |  | 95 | 130
 |  |  |  |  | 96 | 130
 |  |  |  |  | 97 | 130
 |  |  |  |  | 98 | 130
 |  |  |  |  | 99 | 130
 |  |  |  |  | 100 | 130
 |  |  |  |  | 101 | 130
 |  |  |  |  | 102 | 130
 |  |  |  |  | 103 | 130
 |  |  |  |  | 104 | 130
 |  |  |  |  | 105 | 130
 |  |  |  |  | 106 | 130
 |  |  |  |  | 107 | 130
 |  |  |  |  | 108 | 130
 |  |  |  |  | 109 | 130
 |  |  |  |  | 110 | 130
 |  |  |  |  | 111 | 130
 |  |  |  |  | 112 | 130
 |  |  |  |  | 113 | 130
 |  |  |  |  | 114 | 130
 |  |  |  |  | 115 | 130
 |  |  |  |  | 116 | 130
 |  |  |  |  | 117 | 130
 |  |  |  |  | 118 | 130
 |  |  |  |  | 119 | 130
 |  |  |  |  | 120 | 130
 |  |  |  |  | 121 | 130
 |  |  |  |  | 122 | 130
 |  |  |  |  | 123 | 130
 |  |  |  |  | 124 | 130
 |  |  |  |  | 125 | 130
 |  |  |  |  | 126 | 130
 |  |  |  |  | 127 | 130
 |  |  |  |  | 128 | 130
 |  |  |  |  | 129 | 130
 |  |  |  |  | 130 | 130
 |  |  |  |  | 131 | 130
 |  |  |  |  | 132 | 130
 |  |  |  |  | 133 | 130
 |  |  |  |  | 134 | 130
 |  |  |  |  | 135 | 130
 |  |  |  |  | 136 | 130
 |  |  |  |  | 137 | 130
 |  |  |  |  | 138 | 130
 |  |  |  |  | 139 | 130
 |  |  |  |  | 140 | 130
 |  |  |  |  | 141 | 130
 |  |  |  |  | 142 | 130
 |  |  |  |  | 143 | 130
 |  |  |  |  | 144 | 130
 |  |  |  |  | 145 | 130
 |  |  |  |  | 146 | 130
 |  |  |  |  | 147 | 130
 |  |  |  |  | 148 | 130
 |  |  |  |  | 149 | 130
 |  |  |  |  | 150 | 130
 |  |  |  |  | 151 | 130
 |  |  |  |  | 152 | 130
 |  |  |  |  | 153 | 130
 |  |  |  |  | 154 | 130
 |  |  |  |  | 155 | 130
 |  |  |  |  | 156 | 130
 |  |  |  |  | 157 | 130
 |  |  |  |  | 158 | 130
 |  |  |  |  | 159 | 130
 |  |  |  |  | 160 | 130
 |  |  |  |  | 161 | 130
 |  |  |  |  | 162 | 130
 |  |  |  |  | 163 | 130
 |  |  |  |  | 164 | 130
 |  |  |  |  | 165 | 130
 |  |  |  |  | 166 | 130
 |  |  |  |  | 167 | 130
 |  |  |  |  | 168 | 130
 |  |  |  |  | 169 | 130
 |  |  |  |  | 170 | 130
 |  |  |  |  | 171 | 130
 |  |  |  |  | 172 | 130
 |  |  |  |  | 173 | 130
 |  |  |  |  | 174 | 130
 |  |  |  |  | 175 | 130
 |  |  |  |  | 176 | 130
 |  |  |  |  | 177 | 130
 |  |  |  |  | 178 | 130
 |  |  |  |  | 179 | 130
 |  |  |  |  | 180 | 130
 |  |  |  |  | 181 | 130
 |  |  |  |  | 182 | 130
 |  |  |  |  | 183 | 130
 |  |  |  |  | 184 | 130
 |  |  |  |  | 185 | 130
 |  |  |  |  | 186 | 130
 |  |  |  |  | 187 | 130
 |  |  |  |  | 188 | 130
 |  |  |  |  | 189 | 130
 |  |  |  |  | 190 | 130
 |  |  |  |  | 191 | 130
 |  |  |  |  | 192 | 130
 |  |  |  |  | 193 | 130
 |  |  |  |  | 194 | 130
 |  |  |  |  | 195 | 130
 |  |  |  |  | 196 | 130
 |  |  |  |  | 197 | 130
 |  |  |  |  | 198 | 130
 |  |  |  |  | 199 | 130
 |  |  |  |  | 200 | 130
 |  |  |  |  | 201 | 130
 |  |  |  |  | 202 | 130
 |  |  |  |  | 203 | 130
 |  |  |  |  | 204 | 130
 |  |  |  |  | 205 | 130
 |  |  |  |  | 206 | 130
 |  |  |  |  | 207 | 130
 |  |  |  |  | 208 | 130
 |  |  |  |  | 209 | 130
 |  |  |  |  | 210 | 130
 |  |  |  |  | 211 | 130
 |  |  |  |  | 212 | 130
 |  |  |  |  | 213 | 130
 |  |  |  |  | 214 | 130
 |  |  |  |  | 215 | 130
 |  |  |  |  | 216 | 130
 |  |  |  |  | 217 | 130
 |  |  |  |  | 218 | 130
 |  |  |  |  | 219 | 130
 |  |  |  |  | 220 | 130
 |  |  |  |  | 221 | 130
 |  |  |  |  | 222 | 130
 |  |  |  |  | 223 | 130
 |  |  |  |  | 224 | 130
 |  |  |  |  | 225 | 130
 |  |  |  |  | 226 | 130
 |  |  |  |  | 227 | 130
 |  |  |  |  | 228 | 130
 |  |  |  |  | 229 | 130
 |  |  |  |  | 230 | 130
 |  |  |  |  | 231 | 130
 |  |  |  |  | 232 | 130
 |  |  |  |  | 233 | 130
 |  |  |  |  | 234 | 130
 |  |  |  |  | 235 | 130
 |  |  |  |  | 236 | 130
 |  |  |  |  | 237 | 130
 |  |  |  |  | 238 | 130
 |  |  |  |  | 239 | 130
 |  |  |  |  | 240 | 130
 |  |  |  |  | 241 | 130
 |  |  |  |  | 242 | 130
 |  |  |  |  | 243 | 130
 |  |  |  |  | 244 | 130
 |  |  |  |  | 245 | 130
 |  |  |  |  | 246 | 130
 |  |  |  |  | 247 | 130
 |  |  |  |  | 248 | 130
 |  |  |  |  | 249 | 130
 |  |  |  |  | 250 | 130
 |  |  |  |  | 251 | 130
 |  |  |  |  | 252 | 130
 |  |  |  |  | 253 | 130
 |  |  |  |  | 254 | 130
 |  |  |  |  | 255 | 130
 |  |  |  |  | 256 | 130
 |  |  |  |  | 257 | 130
 |  |  |  |  | 258 | 130
 |  |  |  |  | 259 | 130
 |  |  |  |  | 260 | 130
 |  |  |  |  | 261 | 130
 |  |  |  |  | 262 | 130
 |  |  |  |  | 263 | 130
 |  |  |  |  | 264 | 130
 |  |  |  |  | 265 | 130
 |  |  |  |  | 266 | 130
 |  |  |  |  | 267 | 130
 |  |  |  |  | 268 | 130
 |  |  |  |  | 269 | 130
 |  |  |  |  | 270 | 130
 |  |  |  |  | 271 | 130
 |  |  |  |  | 272 | 130
 |  |  |  |  | 273 | 130
 |  |  |  |  | 274 | 130
 |  |  |  |  | 275 | 130
 |  |  |  |  | 276 | 130
 |  |  |  |  | 277 | 130
 |  |  |  |  | 278 | 130
 |  |  |  |  | 279 | 130
 |  |  |  |  | 280 | 130
 |  |  |  |  | 281 | 130
 |  |  |  |  | 282 | 130
 |  |  |  |  | 283 | 130
 |  |  |  |  | 284 | 130
 |  |  |  |  | 285 | 130
 |  |  |  |  | 286 | 130
 |  |  |  |  | 287 | 130
 |  |  |  |  | 288 | 130
 |  |  |  |  | 289 | 130
 |  |  |  |  | 290 | 130
 |  |  |  |  | 291 | 130
 |  |  |  |  | 292 | 130
 |  |  |  |  | 293 | 130
 |  |  |  |  | 294 | 130
 |  |  |  |  | 295 | 130
 |  |  |  |  | 296 | 130
 |  |  |  |  | 297 | 130
 |  |  |  |  | 298 | 130
 |  |  |  |  | 299 | 130
 |  |  |  |  | 300 | 130
 |  |  |  |  | 301 | 130
 |  |  |  |  | 302 | 130
 |  |  |  |  | 303 | 130
 |  |  |  |  | 304 | 130
 |  |  |  |  | 305 | 130
 |  |  |  |  | 306 | 130
 |  |  |  |  | 307 | 130
 |  |  |  |  | 308 | 130
 |  |  |  |  | 309 | 130
 |  |  |  |  | 310 | 130
 |  |  |  |  | 311 | 130
 |  |  |  |  | 312 | 130
 |  |  |  |  | 313 | 130
 |  |  |  |  | 314 | 130