Barometer Conversion Excel Chart
10 posts
MOParker
says:
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
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
Log in to post a reply.