This is a really interesting and powerful tool. I think you can take your summary analysis one step further by putting a "TOTAL" column at the right end of the table. Total the scores and sort low-to-high. Lower score cities are more desirable--less impact from climate change. Here is how your ranking would look:
LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL
Eugene, OR 76 18 13 1 1 109.0
Tucson, AZ 13 67 32 1 1 114.0
Spokane, WA 58 50 16 7 1 132.0
Duluth, MN 81 29 18 1 31 160.0
Santa Barbara, CA 47 7 45 76 24 199.0
Norfolk, VA 100 41 48 8 12 209.0
Our Town 97 28 29 66 1 221.0
Charleston, SC 86 36 49 70 1 242.0
Miami, FL 50 100 31 92 1 274.0
Eugene would be the most desirable to live, Miami the least desirable. Worst-case scenario would be a score of 500. Pick a limit--say any score in the bottom 30% would be desirable, so the best places would be with a score under 150.
Here are some scores for towns that mean something to me:
LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL
Marquette, MI 73 15 11 1 1 101.0
Atlanta, GA 88 51 38 1 1 179.0
Asheville, NC 97 74 49 16 1 237.0
St. Aug. Beach, FL 74 70 58 49 1 252.0
Boulder, CO 89 88 62 27 13 279.0
Marquette is where I grew up and where I still own a vacation home. Atlanta is where our son lives. Asheville is thrown in for comparison because it is said to be a lot like St. Augustine where we last lived. Boulder is where our daughter lives, and interestingly, Boulder is also the home of the National Center for Atmospheric Research which is a US government center studying climate change.
On checking my post, the chart loses its justification so the numbers are not all in column--sorry about that.
I like the simplicity of adding the five ratings to get an overall score. Since ClimateCheck's rating numbers are relative to all other properties, not abolute, maybe the sum is appropriate for an overall ranking.
Your emails continue to be incredibly detailed, helpful and informative- keep them coming! Thank you!!
No! This information is great and really needed. You and Buddy are doing a great job!
Thanks for the feedback, Kathy! We do worry, especially Buddy, that the letters are too dense, that readers think "This is more than I want to know."
This is a really interesting and powerful tool. I think you can take your summary analysis one step further by putting a "TOTAL" column at the right end of the table. Total the scores and sort low-to-high. Lower score cities are more desirable--less impact from climate change. Here is how your ranking would look:
LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL
Eugene, OR 76 18 13 1 1 109.0
Tucson, AZ 13 67 32 1 1 114.0
Spokane, WA 58 50 16 7 1 132.0
Duluth, MN 81 29 18 1 31 160.0
Santa Barbara, CA 47 7 45 76 24 199.0
Norfolk, VA 100 41 48 8 12 209.0
Our Town 97 28 29 66 1 221.0
Charleston, SC 86 36 49 70 1 242.0
Miami, FL 50 100 31 92 1 274.0
Eugene would be the most desirable to live, Miami the least desirable. Worst-case scenario would be a score of 500. Pick a limit--say any score in the bottom 30% would be desirable, so the best places would be with a score under 150.
Here are some scores for towns that mean something to me:
LOCATION STORM HEAT DROUGHT FLOOD FIRE TOTAL
Marquette, MI 73 15 11 1 1 101.0
Atlanta, GA 88 51 38 1 1 179.0
Asheville, NC 97 74 49 16 1 237.0
St. Aug. Beach, FL 74 70 58 49 1 252.0
Boulder, CO 89 88 62 27 13 279.0
Marquette is where I grew up and where I still own a vacation home. Atlanta is where our son lives. Asheville is thrown in for comparison because it is said to be a lot like St. Augustine where we last lived. Boulder is where our daughter lives, and interestingly, Boulder is also the home of the National Center for Atmospheric Research which is a US government center studying climate change.
On checking my post, the chart loses its justification so the numbers are not all in column--sorry about that.
Ohhhh! More numbers. I won't show these to Buddy.
I like the simplicity of adding the five ratings to get an overall score. Since ClimateCheck's rating numbers are relative to all other properties, not abolute, maybe the sum is appropriate for an overall ranking.