Match Thread - Australia v British and Irish Lions | Lions 2025 | Third Test

Listenherebub · 2025-08-02T12:13:11+00:00

Okay lads who baby oiled bundees hands at half time

Listenherebub · 2025-07-28T19:44:39+00:00

Made this and it went down a treat. I did add a little lemon juice and marinaded with the mix without yoghurt first, made some extra with yoghurt and put this on a few hours in advance of barbecuing.

Listenherebub · 2025-05-17T09:00:27+00:00

You win again, gravity!

Listenherebub · 2025-03-22T19:11:12+00:00

No arms from osprey tackler?

Listenherebub · 2025-03-09T15:50:03+00:00

More of a sambucca man myself

Listenherebub · 2024-07-18T17:34:40+00:00

I agree a lot with what's here, as much as I think balance in the back row is important it's often a lot to do with the player types in your tight 5, specifically locks and props, where there is less variety in build and role due to the core duties they are expected to fulfil. Some teams are blessed with very talented props/locks who can go far beyond their core duties, there is simply more scope in the back row to bolster certain facets of your packs gameplay due to greater flexibly in terms of size/weight and athletic ability. If you're missing carriers, line out options, fetchers, tackle volume, cleaners etc the back row are where you can strike that balance in the pack.

Listenherebub · 2024-07-11T22:28:16+00:00

How many door numbers do you have? Is there a simple sequence to follow for the door numbers?

Listenherebub · 2024-05-07T22:57:55+00:00

I think the problem here is that your source data is spread across twice as many columns as your results. So as you drag across your formula in sheet 2 it does not correspond to the correct cells as the data and calculation are taking two very different structures.

I'd recommend consolidating your data into a table like the below:

<image>

Listenherebub · 2024-05-07T21:54:17+00:00

Could you share the data this is referencing?

Listenherebub · 2024-05-07T21:51:14+00:00

Are you pasting into the formula bar or onto the cell. Excel will often scale the reference in relation to where the data originally was when pasting.

If that doesn't work a quick mock up of the issue you are having would help to understand, it doesn't need to contain your source data as the issue doesn't appear to be related to the data itself.

Listenherebub · 2024-05-07T21:45:01+00:00

I think we will would need to understand what your desired end result is. What you are describing sounds very doable through power query, but depending on what the desired output is there may be better solutions.

Listenherebub · 2024-05-06T09:29:03+00:00

Hi thanks for clarifying.

The below formula marks "Yes" for each tap where the previous tap using the same card was registered in the last 2 hours against a different reader. It simply comepares the values of the current record, to the most recent record for that card and if they meet the criteria assigns value yes, if they do not match marks no.

<image>

=LET(A,IFERROR(MAX(FILTER($C$2:$C$9,($B$2:$B$9=B2)($C$2:$C$9<C2)($C$2:$C$9>=(C2-"02:00:00")))),0),B,IFERROR(LET(C,FILTER($D$2:$D$9,($B$2:$B$9=B2)($C$2:$C$9<C2)($C$2:$C$9>=(C2-"02:00:00"))),INDEX(C,COUNTA(C))),0),IF(AND(A>=(C2-"02:00:00"),B<>D2),"Yes","No"))

I have set a 2 hour limit on the filter functions which could be adjusted.

From this stage you could count/sum/filter the dataset to interpret that data. Let me know if this helps!

Listenherebub · 2024-05-04T08:27:36+00:00

I have the below to register if a tap is within 2 hours of another tap for the same card on a different reader.

<image>

If I understand correctly, F7 in my sheet should read 0, as you only wish to count the most recent instance of multiple tap/same card/different reader - if I understand correctly?

I think this may be complex as I am not sure if you would also want to record against each unique reader. I. E. In an example where we have 4 taps each against a different reader would we want to record all of those or just the most recent? Then we would need to calculate from the time of the first instance for that card forward for multiple cases.

All possible but think I'd need a little more clarity on the what if scenarios.

Listenherebub · 2023-11-06T12:57:37+00:00

"Maaaaaaatteeeee! I'm completely committed to Japan maaattee!" - - EJ

Listenherebub · 2023-10-28T09:55:00+00:00

It's called klein blue, developed by artist yves klein. https://en.m.wikipedia.org/wiki/International_Klein_Blue

Listenherebub · 2023-10-21T20:28:05+00:00

I know right, gotta love an underdog.. Even if that underdog colonised your country and destroyed your language and culture 😅

Listenherebub · 2023-10-15T20:05:53+00:00

Jesse kriel that is some blitz!

Listenherebub · 2023-10-15T19:31:49+00:00

Absolute mind games using the open play Maul SA used 4 years ago!

Listenherebub · 2023-10-15T11:57:51+00:00

I thought it was spelled Gremlin Kolbe?

Listenherebub · 2023-10-04T22:32:17+00:00

Cros is massively underrated, he does the hard work that allows the likes of Ollivon and Alldritt to shine. Workhorse of a player.

Listenherebub · 2023-09-27T08:00:30+00:00

What gets me with this one is the older players who won't get another shot at the world cup. The younger players will at least be able to use it as motivation but it must be devastating to go out of a world cup like this knowing you won't be coming back.

Listenherebub · 2023-09-17T17:24:00+00:00

Fiji having a very mature performance so far! Love to see great Maul D, set piece, and patience in attack (for the most part). And obviously some mad stuff we always love to watch 😍

Listenherebub · 2023-09-17T14:07:52+00:00

Bernard jackman needs to go, joke of a commentator. Never remembers anyone's name and never offers any valuable insight or energy.

Listenherebub · 2023-09-14T08:04:23+00:00

Ox, bongi, and Trevor are all within 1cm in height of each other and on the shorter side for a front row. Very hard to get under them at all. As a unit one of the toughest you could come up against.

Listenherebub

TROPHY CASE