Slightly off this thread topic, but what formula do you use to calc the
XTE?

I've used a variation of Ed Williams' formula "XTD
=asin(sin(dist_AD)*sin(crs_AD-crs_AB))" but if I run my calcs in parallel
with a GPS they are consistently different with the GPS numbers varying
considerably more than mine.

For anybody on the cross post response list, this refers to Ed William's
Aviation Formulary page. There are some things directly related such as
airspeed and altimetry issues. However, there are also some useful general
navigation formulas with more general applicability:
http://williams.best.vwh.net/avform.htm

Ron,

The way that I did the spreadsheet, I never had to use this formula.
Without checking, here is a guess: I think crs_AB would refer to the GPS
value of course and crs_AD would refer to the GPS value of BRG.

If you go to the very top of the text, Ed talks about using radians to
measure distance:

Great circle distance can be likewise be expressed in radians by defining
the distance to be the angle subtended by the arc at the center of the
earth. Since by definition, one nautical mile subtends one minute (=1/60
degree) of arc, we have:

distance_radians=(pi/(180*60))*distance_nm
distance_nm=((180*60)/pi)*distance_radians

Note: the nautical mile is currently defined to be 1852 meters - which to be
consistent with its historical definition implies the earth's radius to be
1.852 * (180*60/pi) = 6366.71 km, which indeed lies between the currently
accepted ( WGS84) equatorial and polar radii of 6378.137 and 6356.752 km,
respectively. Other choices of the earth's radius in this range are
consistent with the spherical approximation and may for some specialized
purposes be preferred.

Since 1 radian = 180/pi degrees, you can use distance_degrees=
distance_nm/60.

I keep some of Ed's formulas on my Palm PDA. For more info:
http://www.cockpitgps.com/palm/index.htm

John