Forum Discussion
Barometric Scale Error
Afraid very few people here know something about Barometric Scale Error. Perhaps you may provide some sample to explain?
So what I have to do is tune an altimeter to a specific setting and then read what the altimeter says the altitude is. I have to write down that number and then add or subtract what the altimeter should be reading to what it is reading and get the difference between them. Also there is a tolerance of +/- 25ft.
Example:
set altimeter to 29.92 (standard) it should read what ground level is which in this case is 1220ft.
set altimeter to 30.50 it should read +531ft from 1220ft. reading was 1750ft so then 1220 + 531=1751 so then the difference is +1ft.
set altimeter to 28.50 it should read -1340ft from 1220ft. reading was -100ft so then 1220 - 1340=-120
so then the difference is +20ft
Thank you. Do I understand correctly that's like
where number in black are entered and numbers in red are calculated?
Please check as well in attached file.
SergeiBaklan Yes and no. Yes what I need to do is find the scale error. But it shouldn't have the shall be column.
For this sample
in E6
=$D$10+C6-D6and drag it down.
Here we manually fixed the cell for zero altitude. Better to define it automatically. That slightly depends on your Excel version and how actual data is organized, for this sample it could be (in F6)
=INDEX( $D$6:$D$13, MATCH( 0, $C$6:$C$13, 0 ) ) + C6 - D6and drag it down.
If, for example, transform your data in structured table
formula in last column
=INDEX( [Altimeter], MATCH( 0, [Altitude], 0 ) ) + [@Altitude] - [@Altimeter]is filled automatically.
Of course, other variants are possible.
