Topic thumbnail

Barometer Conversion Excel Chart

Below and Attached is an Excel spread sheet of Barometer Conversions with Related Facts as to Major Hurricane and Tornado Events in the US. I find the conversions fairly useful as I'm more understanding of pressure readings in Hg since that's how my barometer displays, but weather is generally reported in MilBar / hPa, also have included formula's to transfer one to another.

I also found it interesting how close we as humans are to potential disaster day by day. I've been following the barometer since I read and posted some time ago a weather description, (writer un-known) that had done some major personal research on Large Mouth Bass' Barometric Comfort Zone and established at 29.98" to 30.02" Hg. Then I've found it to be most profound and every-bit as meaningful as the solunar tables.

I have been tracking my local METAR Weather Station ( http://weather.gladstonefamily.net/site/KMEM ) that provides historical data that can be placed into Excel Spreadsheet and better diagnosed.... My post mortum has indicated the local average since December '11 to today Feb 12, '12 some + 2,000 hourly readings, to be 30.10..... averaging 00.08 higher and apparently the Lg Mouth Bass have fully cooperated in not biting.

Being able to work with this data in Excel, has allowed me to plug into the hourly weather data, our very own Fishingreminder.com's Major and Minor times, and Luck being with me on this.... wouldn't you know that for every good time, (understanding it's winter) the barometer has been pretty much off the chart. Never the less..... INTERESTING....

I enclosed my local web address, located at Memphis International Airport, hopejully if you're interested you might find a weather center close to you, should you be interested in following historic trends....



Mike Parker
moparker_38127@bellsouth.net


M Bar / hPa Hg Barrometric Pressure Facts & Conversions
x 0.0295301=Hg x 33.8837526=Mbar U.S. Major Recorded Occurances

850.0 25.17 Tornado 6.24.03 Manchester S.D.
867.9 25.63 Lowest World Record
880.0 26.00 Hurricane Agnes June 1972
880.5 26.00
880.5 26.00 Hurricane Camille 1975
883.8 26.10
887.2 26.20 Hurricane Gilbert 1988
892.0 26.35 Labor Day Hurricane 1935
894.0 26.40
897.4 26.50 Hurricane Rita August 2004
900.8 26.60
902.0 26.64 HurricaneKatrina Aug 28,'05
904.2 26.70
905.0 26.75 Toranado May 7, 2002 Pratt, Kansas
905.1 26.76 Hurricane Mitch March 2004
907.5 26.80
908.9 26.84 Hurricane Camille 1969
910.9 26.90
914.3 27.00 Category 5 = less than 27.17 inches, winds greater than 155 mph, storm surge higher than 18 feet
917.7 27.10
921.1 27.20 Category 4 = 27.17 inches to 27.90 inches, winds from 131 mph to 155 mph, storm surge 13 feet to 18 feet
922.1 27.23 Hurricane Andrew August 1992
924.5 27.30
927.2 27.38 Hurricane Inez Oct '66
927.9 27.40
929.9 27.46 Hurricane Donna Summer 1960
931.3 27.50
934.6 27.60
935.3 27.62 Hurricane Carla Sept 1961
938.0 27.70
938.0 27.70 Hurricane Ione Sept 1977
939.7 27.75 Hurricane Hellen Sept 27, 1958
941.4 27.80
944.8 27.90 Category 3 = 27.91 inches to 28.49 inches, winds from 111 mph to 130 mph, storm surge 9 to 12 feet
948.2 28.00
950.0 28.88 Hurricane Betsy Sept 31, 1965
951.6 28.10
955.0 28.20
955.0 28.20 Hurricane Eloise September 1975
958.3 28.30
961.7 28.40
965.0 28.50 Hurricane Carmen Oct 9, 1965
965.1 28.50 Category 2 = 28.5 inches to 28.93 inches, winds from 96 mph to 110 mph, storm surge 6 to 8 feet
968.5 28.60
971.9 28.70
975.3 28.80
976.0 28.83 Hurricane Olive Sept 1st, 1965
977.0 28.85
977.0 28.85 Hurricane Amy May 26, 1965
978.7 28.90 Category 1 = 28.94 inches or more and winds of 74 to 95 mph and a 4 to 5 foot storm surge
980.4 28.95 ^ ^ ^ 99.4% Of All Major Storms Occur At Or Below ^ ^ ^
982.0 29.00
983.7 29.05
985.4 29.10
987.1 29.15
988.8 29.20
990.5 29.25
992.2 29.30
993.9 29.35
995.6 29.40
997.3 29.45
999.0 29.50
999.3 29.51
999.7 29.52
1000.0 29.53
1000.3 29.54
1000.7 29.55
1001.0 29.56
1001.4 29.57
1001.7 29.58
1002.0 29.59
1002.4 29.60
1002.7 29.61
1003.0 29.62
1003.4 29.63
1003.7 29.64
1004.1 29.65
1004.4 29.66
1004.7 29.67
1005.1 29.68
1005.4 29.69
1005.8 29.70
1006.1 29.71
1006.4 29.72
1006.8 29.73
1007.1 29.74
1007.4 29.75
1007.8 29.76
1008.0 29.77
1008.0 29.76
1008.1 29.77
1008.5 29.78
1008.8 29.79
1009.1 29.80
1009.5 29.81
1009.8 29.82
1010.2 29.83
1010.5 29.84
1010.8 29.85
1011.2 29.86
1011.5 29.87
1011.8 29.88
1012.2 29.89
1012.5 29.90 ^ ^ ^ ^ ^ ^
1012.9 29.91 < Beginning of LOW PRESSURE
1013.2 29.92 World AVERAGE Barometric Pressure
1013.5 29.93
1013.9 29.94
1014.2 29.95
1014.6 29.96
1014.9 29.97
1015.2 29.98 Best
1015.6 29.99 Barometric
1015.9 30.00 Pressure
1016.3 30.01 For Catching
1016.6 30.02 Large Mouth Bass
1016.9 30.03 V Beginning of HIGH PRESSURE
1017.3 30.04
1017.6 30.05
1017.9 30.06
1018.3 30.07
1018.6 30.08
1019.0 30.09
1019.3 30.10
1019.6 30.11
1020.0 30.12
1020.3 30.13
1020.7 30.14
1021.0 30.15
1021.3 30.16
1021.7 30.17
1022.0 30.18
1022.3 30.19
1022.7 30.20
1023.0 30.21
1023.4 30.22
1023.7 30.23
1024.0 30.24
1024.4 30.25
1024.7 30.26
1025.1 30.27
1025.4 30.28
1025.7 30.29
1026.1 30.30
1026.4 30.31
1026.7 30.32
1027.1 30.33
1027.4 30.34
1027.8 30.35
1028.1 30.36
1028.4 30.37
1028.8 30.38
1029.1 30.39
1029.5 30.40
1029.8 30.41
1030.1 30.42
1030.5 30.43
1030.8 30.44
1031.2 30.45
1031.5 30.46
1031.8 30.47
1032.2 30.48
1032.5 30.49
1032.8 30.50
1033.2 30.51
1033.5 30.52
1033.9 30.53
1034.2 30.54
1034.5 30.55
1034.9 30.56
1035.2 30.57
1035.6 30.58
1035.9 30.59
1036.2 30.60
1036.6 30.61 Sky Lake 02 12 12
1036.9 30.62
1037.2 30.63
1037.6 30.64
1037.9 30.65
1038.3 30.66
1038.6 30.67
1038.9 30.68
1039.3 30.69
1039.6 30.70
1040.0 30.71
1040.3 30.72
1040.6 30.73
1041.0 30.74
1041.3 30.75
1041.6 30.76
1042.0 30.77
1042.3 30.78
1042.7 30.79
1043.0 30.80
1043.3 30.81
1043.7 30.82
1044.0 30.83
1044.4 30.84
1044.7 30.85
1045.0 30.86
1045.4 30.87
1045.7 30.88
1046.1 30.89
1046.4 30.90
1046.7 30.91
1047.1 30.92
1047.4 30.93
1047.7 30.94
1048.1 30.95
1048.4 30.96
1048.8 30.97
1049.1 30.98
1049.4 30.99
1049.8 31.00
1050.1 31.01
1050.5 31.02
1050.8 31.03
1051.1 31.04
1051.5 31.05
1051.8 31.06
1052.1 31.07
1052.5 31.08
1052.8 31.09
1053.2 31.10
1053.5 31.11
1053.8 31.12
1054.2 31.13
1054.5 31.14
1054.9 31.15
1055.2 31.16
1055.5 31.17
1055.9 31.18
1056.2 31.19
1056.5 31.20
1058.2 31.25
1059.9 31.30
1061.6 31.35
1063.3 31.40
1065.0 31.45
1066.7 31.50
1068.4 31.55
1070.1 31.60
1071.8 31.65
1073.5 31.70
1075.2 31.75
1076.9 31.80
1078.6 31.85
1080.3 31.90
1081.9 31.95
1083.6 32.00
1085.3 32.05
1085.7 32.06 Highest World Record
1087.0 32.10
Likes: 0 Login to reply 12 years ago
Here is a site that I sometimes use to check for historic weather data:

http://www.wunderground.com/history/
Mark,

Actually, I like the format of your's much better, the barometer is at least in inches of mercury which I'm used to, and don't have to convert, and the temps in F, that I'm used to...

The only thing is that I don't see a way to get like weeks or months at a time..... I get lazy sometimes and get caught up in important things like Swamp People and Seinfield to log all the daily weather event. But in my case, as you've seen from several of my posts, the little lake I live and fish on, has not been anything to be proud of. I do since it's a few steps to the bank, fish almost every day, unless it's lightening or raining cats & dogs, ( last week I stepped in a poodle ), but doo try to get in 50 or so casts at the soulunar (daylight) times anyway and since last September, luck, tables, and now the barometer haven't been with me. But I was Out There.....


AND by the way, I'm getting really concerned about you and your neighbors, I'm seeing the Pacific all lit up on my Yahoo Earth Quake Notification Widget 5's, 6's & 7's All Around You...... I live in an Earth Quake Area and been through a couple of at like 3ish and I gotta tell you, I don't like them, even though there is generally little damage, but in 1811 the New Madrid went off for weeks, and there are hwy's that really used to be old indian trails that go as far as Nashville, TN, One Specifically Hwy 70, Summer Avenue that has rolling hills that are 70 to 100 feet in elevation that go on like waves in the ocean for miles, and a 100 foot wave in the ocean is bad, but when it's earth rolling across the state, well that's the Fear of God..... So you can understand my concerns for you guys, .... I'll be preying for you regardless.....

Thanks for the Site.

MOParker