MS Excel DA Calculator
05-23-2007, 11:12 AM
#1
TECH Resident
Thread Starter
iTrader: (2)
Join Date: Sep 2004
Location: Cleveland, Oh
Posts: 810
Likes: 0
Received 0 Likes
on
0 Posts
MS Excel DA Calculator Someone wanna check this over for me? I've been working on it for a while and think its pretty close but since my tracks don't provide a lot of info I've had to make it up as I go along. If someone could review it and let me know if its correct or all BS I'd appreciate it.
Last edited by radkon; 05-24-2007 at 07:17 AM. Reason: Made a cosmetic update to the sheet and uploaded new version
05-24-2007, 06:30 AM
#3
TECH Resident
Thread Starter
iTrader: (2)
Join Date: Sep 2004
Location: Cleveland, Oh
Posts: 810
Likes: 0
Received 0 Likes
on
0 Posts
Originally Posted by Luis Castellanos
Congrats on getting the formula to calculate DA, thats such a bitch!
I see that the formula you used does not add the actual over sea elevation...
just that..
I see that the formula you used does not add the actual over sea elevation...
just that..
Last edited by radkon; 05-24-2007 at 08:39 AM. Reason: Revised the calc for base altitude
05-24-2007, 07:48 AM
#4
9 Second Club
iTrader: (11)
Join Date: Nov 2001
Location: Back home in Texas!!! (DFW)
Posts: 941
Likes: 0
Received 0 Likes
on
0 Posts
As an alternative...
For true DA, you need the station pressure, which can be plugged in here:
http://www.srh.noaa.gov/elp/wxcalc/stationpressure.html
Then, take that and plug it in here with the air temp. and dewpoint:
http://www.srh.noaa.gov/epz/wxcalc/d...altitude.shtml
The altimeter setting is what is reported as the barometer readings on most weather sites unless it specifically shows it as station pressure. Hope this helps. Take care. Dave
For true DA, you need the station pressure, which can be plugged in here:
http://www.srh.noaa.gov/elp/wxcalc/stationpressure.html
Then, take that and plug it in here with the air temp. and dewpoint:
http://www.srh.noaa.gov/epz/wxcalc/d...altitude.shtml
The altimeter setting is what is reported as the barometer readings on most weather sites unless it specifically shows it as station pressure. Hope this helps. Take care. Dave
