Large Deep Earthquakes up 500%, "Gap Day" Ground Shattering Research, Predicting EQ by Studying When They Don't Happen

NUKE PRO: Exposing Truth Anti-Nuclear Information and Resources, and Disaster Preparation Planning: http://nukeprofessional.blogspot.com/ stock here

Sometimes tedious and fairly random research comes up with remarkable things.   However, as an Excel user for 30 plus years, I am shocked at it’s levels of quirkiness.    An beyond the pale, is what looks like awesome support, that is so ineffective!    On that note, if there are any other Earthquake researchers out there, I have a solution for a horribly pesky date problem, Excel has 2 huge problems….it will often not recognize something as a date, even when you tell it that your cell or column is a date.    And then, it will not be able to sort by date, and tally up numbers by date, year, quarter, hour of day….and will just give you some half baked excuse that doesn’t get you any closer to an answer.    Solution at bottom of this article.
————————————————————————

Like has anyone in the World noted that Large Deep Earthquakes are up 500% in the last decade, compared to the whole period from  1952.

And how about this little tidbit that I just stumbled across. From around 1973 to 1982 there were basically NO LARGE DEEP EARTHQUAKES.     And this amazing fact is NOT DISCUSSED in any Earthquake Research.

I choose 1952 as the cutoff for much research.    From the data, it is clear, that is when our EQ data and equipment became “modern”.    Before that it was definitely sketchy.

Also, having 2 Large, 7.5 and over, in one day has taken a massive tick upward –
Historically, 2 Large in one day

1960
1968
1977
2000
2002
2007
2009
2010
2011
2012
2015

———————————————-
The problem: Excel does not want to recognize dates as dates, even though through “Format cells – Number – Custom” you are explicitly trying to tell it these are dates by “mm/dd/yyyy“. As you know; when excel has recognized something as a date, it further stores this as a number – such as “41004” but displays as date according to format you specify. To add to confusion excel may convert only part of your dates such as 08/04/2009, but leave other e.g. 07/28/2009 unconverted.

Solution: steps 1 and then 2

1) Select the date column. Under Data choose button Text to Columns. On first screen leave radio button on “delimited” and click Next. Unclick any of the delimiter boxes (any boxes blank; no checkmarks) and click Next. Under column data format choose Date and select MDY in the adjacent combo box and click Finish. Now you got date values (i.e. Excel has recognised your values as Date data type), but the formatting is likely still the locale date, not the mm/dd/yyyy you want.

2) To get the desired US date format displayed properly you first need to select the column (if unselected) then under Cell Format – Number choose Date AND select Locale : English (US). This will give you format like “m/d/yy“. Then you can select Custom and there you can either type “mm/dd/yyyy” or choose this from the list of custom strings.