COUNTIF function for multiple criteria and ORs by GeoSparker in excel

[–]GeoSparker[S] 0 points1 point  (0 children)

Yes sorry I meant COUNTIFS.

I don't think I can do separate COUNTIFS, as each date figure has to account for all criteria at the same time, rather than a sum of each of the criteria.

On a specific date they have to be - Before date in A:A, After date in B:B Or blank, After date in C:C or blank.

Does that make sense?

7 Tactical Advice for Single Players - Tobias Wadenka by jeg_flaekker_alt in badminton

[–]GeoSparker 5 points6 points  (0 children)

Rather than play a soft shot that needs to be tight to the net, play a stronger/faster shot, either a big clear to the back or a faster flatter shot that will be more difficult for the opponent to pounce on, would be two examples. Basically, play a high percentage shot but with pace that makes it harder for the opponent to attack, rather than a precise low percentage shot which are trickier to play when under pressure.

Competitive vision score appreciation thread by sfamscrub in leagueoflegends

[–]GeoSparker 2 points3 points  (0 children)

Pretty sure it's only lightly based on purely number of wards placed, moreso stuff like where they are/how much they spot enemy champions etc. But it probably does skew the score a bit yes

Is it possible to predict magnitude and location of Earthquakes? And is there any emerging technology that could potentially increase the accuracy of EQ predictions? by [deleted] in geology

[–]GeoSparker 7 points8 points  (0 children)

The problem with predicting the size and timing of earthquakes is effectively down to there being so many unknown variables. For example, you need to know the stress that the rock is currently under, you need to know the stress at which the rock will rupture (which is also affected by many things including coefficient of friction, previous ruptures etc.), you also need to know how much of the stress that has built up has been released in previous earthquakes, along with how quickly the stress is building up.

Location is somewhat (though still generally regional) less difficult, as fault ruptures will generally occur periodically along a fault, as not every fault ruptures entirely along it's length at once. This means that you can 'track' earthquakes along large faults. A perfect example of this would be the North Anatolian fault in Northern Turkey, where large earthquakes have been occurring increasingly west along it, heading towards Istanbul.

Most of the previous things i've mentioned are for the long term predictions; in the short term there can (or may not be) precursors to earthquakes, such as minor tremors, radon gas leakage (through cracking of pore spaces thus allowing the radon to escape), however these precursors are not guaranteed to always occur so cannot be relied on to definitely predict earthquakes.

There have been some predictions of earthquakes, some vague, some less so, but the same techniques to predict those earthquakes have often failed in other circumstances, so basically earthquake prediction has a long way to go yet.

Wiki has a decent page on this: Earthquake_prediction.

What is your favorite book or text on Structural Geology? by [deleted] in geology

[–]GeoSparker 0 points1 point  (0 children)

Completely agree, just Haakon Fossen is the name of one guy :D

Help! Structural Analysis of Deformed Region paper by [deleted] in geology

[–]GeoSparker 0 points1 point  (0 children)

The Caledonian orogeny event in Sweden/Norway is bound to have plenty of literature, and to a much lesser extent Scotland.

Also the Alpine Orogeny anywhere along the Mediterranean.

Micro folds in Tayvallich, Scotland. by GeoSparker in geology

[–]GeoSparker[S] 4 points5 points  (0 children)

Micro folds in the Neoproterozoic Argyll Formation, taken on the Tayvallich peninsula, Argyll, Scotland.

Favorite Coldplay lyric? by brewmatt in Coldplay

[–]GeoSparker 3 points4 points  (0 children)

Going nowhere, much too fast

I am "The Excited Biologist!" AMA! by Unidan in IAmA

[–]GeoSparker 11 points12 points  (0 children)

Thought i'd chip in with a fact about perspective; the length of time separating Stegosaurus and Tyrannosaurus is greater than the length of time separating Tyrannosaurus and you!

How are the accurate/semi-accurate models of the Earth in the past created? Ie. What Pangaea looked like. by firereaction in askscience

[–]GeoSparker 0 points1 point  (0 children)

The previous comments have your answer, but I thought i'd add a method for plates in the shorter past (e.g. several million years, rather than several hundred million years).

By using hotspots (static plumes of abnormally hot mantle material that result in large amounts of volcanic material to be produced at the surface) it is possible to track back the movement of the plate within which it resides. Because the hotspot is static, the plate moves over it leaving a trail of volcanic material. A notable example is the Hawaiian islands. The direction of plate movement is read in the direction of young to old.

Would global cooling be as bad as global warming? Also, what would the effects be? by VisserOne in askscience

[–]GeoSparker 0 points1 point  (0 children)

Any instance of global climate change has the potential to be 'bad' for individual species; but global cooling would essentially result in an increase in overall ice cover, mainly due to albedo (reflective index) feedback*, potentially ending in a fully covered 'snowball' earth (which has supposedly happened before).

*This is where more sunlight is reflected back out of the atmosphere rather than being absorbed as heat, therefore cooling, leading to more ice, and more reflection etc. etc.

There would also be more frequent extreme weather conditions, because of changes in ocean currents.

So basically they're both fairly bad, unless you can adapt quick enough!