I’ve done this before, and, I’ll probably do it again.
The graph above depicts how global warming would look if you were to check your thermometer, …. assuming it was the global temperature. It would look red because that’s how most alcohol thermometers look, rather than the silver looking mercury thermometer. I used Fahrenheit because I’m an American, and that’s the way we roll. Typically, our out-door temperature thermometers go from a max of about 120 degrees to a minimum of about –40, so, that’s what I used for the vertical axis.
I had in mind to do the same for the strange Celsius people, but, as I was making the graph it occurred to me that I had no idea what the min and max is of their typical thermometers!! Apparently, beer isn’t always good for everything! Who knew?!?!?!?!
This was a bit fun and a bit maddening. …….. strike that, incredibly maddening and funny all at the same time.
A friend of ours had seen the first post I did like this, and he asked me for the spreadsheet and method. I told him that I had no idea where that sheet was, or if I had even kept it. It could be somewhere on one of three computers, two of which I can make run again. But, I told him it was a fairly straightforward process and that I’d be happy to reproduce it for him. Five/ten minutes …. what’s the big deal, right?
Well, here’s the source for the data, it’s NASA’s GISS. The problem was, the page was down!!!! I couldn’t access the data!!!!! I told him I’d have it to him before the end of the night. Now, mind you, I’ve been forcing myself into a good mood for a while because of personal things …. like I forgot I had to bach it tonight. Don’t get me wrong, I don’t mind it from time to time, but, who the hell is going to fix me supper at this time of night? Well, I better have another beer and think on it for a bit ….. I digress. So GISS is down. I tried, ….. sipped some beer, tried again, sipped some more beer. It’s strange but regardless of the amount of beer I drank, the page was still not available!!! I thought this would be a teachable moment for all the henpecked fellows out there. You can tell your wives, regardless of the amount of beer you drink, things will still be screwed up!!! I’m assuming this wasn’t because some NASA web guy didn’t just get drunk and screwed things up, but, that’s probably not you, anyway, so you can still use that. …… Hmm, it seems I have to digress, again. Where was I? Oh, yeh, I can’t get to the data so I can’t accommodate, which wouldn’t be a big deal, except I said I would. Damned NASA!!!! They used to be able to send people to the moon and now they can’t keep a web page up!!! So, I sipped on some more beer and read about president Zero being pissy with reporters trying to ask questions. Better have some more beer on that one …. it’s weird, but, it wasn’t even St. Paulies (sic?) which made me realize that GISS being down was NBD!!!! There’s always our friend Paul Clark and WFT!!! He’s always got the GISS data!! Cool!!! I can oblige!!! ….. Except …. Paul formats it in a bit different manner. Don’t get me wrong, I prefer the way he does it, it’s just that it makes it a bit more, this way, rather than the way GISS does it. You see, Paul uses monthly averages only, not annual, Now, this wouldn’t be a big deal …. easy as pie!!! Except, that darned beer!!! At one point in my life, I used to use Excel as part of a way to make a living …. mostly to port spreadsheet date into a usable and meaningful database. Well, that’s not what I do, anymore, and I never did like that homely sister of a database, anyway. How does I Excel? ……..
Take the link of the WFT to Excel, or any other spread app. You gotta separate the text to columns. For the Fahrenheit, you have to multiply by 1.8. GISS says the average temp is suppose to be 14 deg C, or 57.2 deg F. For Fahrenheit, just add the 57.2 to the converted column. This gets us the monthly temp in Fahrenheit, but, we need to make it a yearly temp. So, “average” twelve months and complete it for every month …. (in Excel, just double click on the lower right corner of the cell you did this in and it will auto-fill the rest of the column). Now we have to get the “yearly” average, that is to say, January through December. Copy and special paste (values only) to anther sheet. Add a column next to the Year/decimal year .. should be column “A”. Highlight column A. Click on “data” which is now in the ribbon above, and then “text to columns” and separate by the period sign. Then sort by column B. Hide all else other than the “92” …. And then graph the values. On the vertical axis go to the negative desired, if desired, and then tell it to fill to the bottom value. Click on the bar graphs and format the data series to what color and separation you desire. Done.
Now, now ………now the GISS page is available and half that crap, the crap I had to think about, isn’t necessary any longer!!!! Funny stuff!
Anyway, thanks Lat!!!! I have no doubt in my mind you caused this!!!! But, it’s cool that you did! Thanks man!