bearing

Hi, I'm trying to use this expression in a macro to obtain the whole circle bearing between 2 points of known latitude and longitude, the LatA Lonb etc (all in radians) 360-(MOD(ATAN2((COS(LatA)*SIN(LatB))-(SIN(LatA)*COS(LatB)*COS(LonB-LonA)), SIN(LonB-LonA)*COS(LatB)),2*PI())*180/PI()) I...

hello everyone. im trying to get excel to look up a value from a list of possibilities. to give you some context im trying to create a spreadsheet to show me the possible universal joint bearings from a given measurement, either A or AD, with A being the measurement across the bearing, and AD...

hi, i am new to VBA. how increment using VBA can be done to find minimum requirement for Length(L) and width(B) of foundation so that Modified bearing pressure(PMOD) is less than allowable bearing pressure(ABP). Attached sample calculation for visualisation and better understanding. Regards...

I would like to create a very simple Lookup file that I can share with technicians to help them lookup parts. Basically, My file would take a text entry, say Bearing, go to the mass data sheet, find the word bearing in any cell, then return the value from a specified cell matching that row...

Hi All, I have huge data which I need to search changed parts from a same column and copy/paste to new column. Hope to use the VBA t search/copy/paste it. Attached is the sample. Thanks in advance for the helps. <colgroup><col width="94" style="width: 71pt; mso-width-source: userset...

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...

Dear All, Firstly I would like to thank Mr. Excel forum which has solved many complex queries which I had in regards to Excel. Finally I had post a thread for a solution which I didn't find. <tbody> Crank shaft Bearing journal - Main Bearing journal - Rear Intermediate bearing...

Any idea how to do this? You have LAT1, LON1, LAT2, LON2 and you want to calculate: A: distance B: bearing (initial bearing along a great circle ie the shortest distance) C: bearing along rhumb lines ("constant bearing") For example if you want to go from 0, 0 to 0, 90E, the answer to C would...

Hey guys and gals, here is a good one, Given 3 latitudes and longitudes, can you calculate the bearing from the first lat/long to the second lat/long. 2nd to 3rd, then 3rd to first? The ULTIMATE goal is to create an irregular polygon given multiple lat longs, and determine the area. I don't...