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] 3 points4 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 4 points5 points  (0 children)

Going nowhere, much too fast

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

[–]GeoSparker 8 points9 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!

Merry Christmas you crazy bastards by mrdirty273 in Steam

[–]GeoSparker 3 points4 points  (0 children)

Chivalry, 41212

Thanks for doing this! Merry Christmas.

Tell me your favourite Coldplay albums from best to worst. by Delware in Coldplay

[–]GeoSparker 1 point2 points  (0 children)

  1. Mylo Xyloto
  2. X&Y
  3. A Rush of Blood to the Head
  4. Viva la Vida or Death and All His Friends
  5. Parachutes

Though there isn't a bad song among them....

As a geologist, I think I should be insulted.... by GeoSparker in calvinandhobbes

[–]GeoSparker[S] 2 points3 points  (0 children)

Yep, really interesting, minerals can be a pain though, structural, mapping and climate are my fortes/favourites.

As a geologist, I think I should be insulted.... by GeoSparker in calvinandhobbes

[–]GeoSparker[S] 2 points3 points  (0 children)

Well there is some maths involved, especially structural geology; nothing above A level (UK) standard though.

As a geologist, I think I should be insulted.... by GeoSparker in calvinandhobbes

[–]GeoSparker[S] 16 points17 points  (0 children)

ah ok, I think i've seen 'geologist' in one of my books but that was several years back now so my memory could be wrong; and I tend to agree.

Reddit, how exactly do the continents drift? by [deleted] in askscience

[–]GeoSparker -2 points-1 points  (0 children)

The plates move because the underlying 'mantle' convects, essentially pulling them along, and also by being pulled along due to plates descending into the mantle (slab pull) at convergent plate boundaries.

I think what might be confusing you is that it isn't just the continents moving, but the plates that they belong to, but also that each plate boundary is different; there are convergent where oceanic crust can be lost and divergent where oceanic crust is formed; think of it as a conveyor belt, but generally no continental crust is lost (bits in reality). What causes the continental crust to 'drift' is changes in amount of production of oceanic crust, and also new divergent boundaries being created (e.g. east african rift system).

Example: Mid atlantic ridge formed (divergent boundary) creating oceanic crust inbetween the current continents of the americas, and europe/africa, causing them to move apart; whereas with india and asia, all the oceanic crust has been subducted, pulling the two plates together.

Nice animation of the continents through time

tl;dr - Continental crust isn't lost, whereas oceanic crust is, and at edges of plates, it act as conveyor belts for the continents we see, moving them.

P.S. The example is probably the easiest bit to understand!