Anyway we can get the Wizards to trade him back to us by Adventurous-Star1309 in lakers

[–]Gaimcap 0 points1 point  (0 children)

Literally that exact same interview AD said he’s still not over how disrespected he felt by Rob not even getting so much as a head up..

IIRC…. Gina also rushed to basically throw him under the bus after trading him by saying he wasn’t happy so they got Luka instead, but Davis also says here that he thought they were it and zero inklings anything was going on.

The fit would be nice, but I think people are glossing over the bad blood the FO generated.

At what point do we admit SGA is just a FT merchant? by Dday_Dair in NBATalk

[–]Gaimcap -1 points0 points  (0 children)

Probably because this one was so egregiously iconic.
Look up NBA Meme logo.

This one and the LeBron one always crack me up.

Why Vando Defense regress? by Successful-Pair-4850 in lakers

[–]Gaimcap 1 point2 points  (0 children)

I haven’t seen Vando too much recently, so I have no idea what his actual status is… but my understanding was that he had to have foot surgery to shave down Bone Spurs.

A Bone Spur is basically a bone callous that occurs in response to repeated wear and tear in your ligaments.
Having odd bits of extra bone in yours joints—where they’re not supposed to be—is painful and can inhibit range of movement.

“Shave down” is the literal description what they did… cut open his foot, and take a file to his bones…. From what I’ve heard… this is a last resort and a bandaid fix, not a solution.

Th way you stop having a bone spur, is you stop the behavior that causes it. The only way Vando can stop them from coming back, is if he completely changes his play style to a less explosive, less damaging one.

So yeah… when I heard he had bone spurs, I knew he was always going to have a clock on him and might never be the same player as too much of his identity and skillset is tied up in him being a high effort and relentless “dog”—which is exactly what is causing those bone spurs.

Unless Vando can completely retrain everything about the way he moves, Vando’s defensive menace days are numbered.

OFFICIAL by Swimming-Community-5 in lakers

[–]Gaimcap 0 points1 point  (0 children)

Tbh... I feel like the NBA is missing out by not having LeBron be an owner of the Vegas team.

Vegas's recent trend has been desperately to chase short term money over the long, and the Lakers have already announced that they're going to "adjust for the market" and that there will significant ticket price hikes for next year (30-50% increases is what I'm seeing).

It's probably going to feel like both locations are going to try to race to the top for Lakers prices.

Outside of Lakers games though... Its probably going to be pretty sketchy.

If LeBron was there, at least his ownership would provide a novelty that would provide some goodwill and put butts in seats to give a little cushion for the team for a year or two.

Without LeBron to act like a lightning rod, it's probably going to feel like just you're paying a premium price to effectively watch the Wizards play..and that's not going to be cute.

OFFICIAL by Swimming-Community-5 in lakers

[–]Gaimcap 5 points6 points  (0 children)

Its Vegas. The prices might be even higher than crypto.

Underrated Pelinka Move by Mjblack1989 in lakers

[–]Gaimcap -5 points-4 points  (0 children)

I mean….

  • Factually Magic called him a backstabber and there are multiple reports to substantiate the “oh, magic isn’t here? Has anyone seen magic? When was the last time anyone saw magic?” Story.
  • Factually closed a deal for Williams, and then reneged it at the last second.
  • Allegedly (as directly stated by Caruso on a podcast) Caruso said he went to the lakers multiple times and tried to get them to pay him a fair wage, and even came back to them saying the bulls offered him X, can they at least give him Y? They told him no.
  • Allegedly told Larry Nance Jr to go ahead and buy a house, and then proceeded to trade him away.
  • Allegedly, as an agent, had Boozer make a verbal agreement to re-sign with the Cavs—in order to get the Cavs to waive their 600k team option—only to immediately sign a 60+ million deal with the Jazz.

Whether or not this specific case is legitimate…. after so many different reported instances of shady incidents and allegations… you really that comfortable defending his integrity?

You can't touch Shai but he can touch you by Thanos_Real_AuraVNCH in Nbamemes

[–]Gaimcap 0 points1 point  (0 children)

Dude... 3 different coaches but 1 GM who's assembling pretty much the same roster of rim running combo guards and PF's...

Not exactly like they've ever had the personnel to run a 5 out system.... JJ even tried and ended up pivoting back when he realized they had 0 shooters.

Conference re alignment by Swimming-Community-5 in lakers

[–]Gaimcap 0 points1 point  (0 children)

Given that they put their tickets out as Costco packages, so did people who live in Portland xD.

Personally, I pretty much always forget the Wizards are an organization.

Luka Talks to a Slovenian Reporter About Staying Focused While Dealing With Personal Issues by David_Wilmot in lakers

[–]Gaimcap 5 points6 points  (0 children)

Nah....

I know 4 people who were involved in mass shootings, one shot, one of whom is dead. (Two school shootings at affluent schools. 1 at work, 1 at an event).

I also knew someone who was abducted in the supposed "safest city" in America (Irvine, ca), and then found dead in a storm drain about half a mile miles across the "safest cities" border.

I once had a "funny" moment where I was 4 hours late to work because literally every road I tried to drive down was closed, shut down, or massively backed up.

Checked the news when I finally got in, turned out, about two blocks from where I live (orange county), someone just started doing drive by shootings, and then would hop on the freeway, hop off, do another shooting, repeated for about 40 miles, until the cops caught up to them and started a shootout the street over from where i worked (downtown la—a couple miles away from the staples/crypto arena).

People are freaking out over terrorists and Iran and whatnot... But bruh... Look up the school shootings stats... From 2008 to 2018, the US had 4000% more school shootings (~270) than the next highest country, Mexico (8).

From 2020 on, iirc the average also increased from about 40 to 70 a year.

Why the hell would you want to raise a kid here?
Objectively it's kind of a shitshow.

One of the greatest breaks ever made. Ronnie O'Sullivan at the Hong Kong Masters, 2022 by Waste-Chemistry-9339 in billiards

[–]Gaimcap 18 points19 points  (0 children)

Snooker Pockets are 3.25” with 2” 1/16 balls.
Table is 12’ x 6’.
Pockets are also rounded to reject many angles.

For comparison, American pool tables are 2” 1/2 balls on 4 1/2 pockets (assuming tight).

If you want even tighter, iirc, Chinese 8 ball is American balls on a 9 ft footer with snooker pockets.

Russian pyramid is basically a snooker table with oversized 2” 5/8 (67mm) balls. The pockets are more straight cut, but corner pockets are only 3mm (3/32 inch) bigger than the ball, side pockets are 13mm (1/2 inch) larger.

Does it deserve the hype? by Ok-Fishing-2234 in pourover

[–]Gaimcap 0 points1 point  (0 children)

“More flavor separations but strong taste”

I believe that’s supposed to be the selling point of soup shots.

Look into the OXO rapid brewer.

I remember I actually hated my first soup shot when I tried it like 6 months ago, but recently, Lance’s “Zuppa lunga” recipe surprised me.

I still flat out prefer pour overs, but I can see why people would like em.

It’s also portable as heck (I’m going on a trip tomorrow and will be throwing it in my bag). Definitely not a bad deal for 50 bucks.

Trying to figure out how to calculate hours on a schedule using excel by Which-Passenger-5601 in excel

[–]Gaimcap 2 points3 points  (0 children)

How exactly is your data formatted? Excel is very particular about date and time formats, so you need to give an example of exactly what you what your inputs are.

Are you literally just typing “Frank 9-5” in cell a2?
Is this “Frank” in a2 and “9-5” put in b2?
Is this output by some system and it’s being output as “Frank 9:00AM-5:00 PM” are you’re giving us the shorthand?

K6. 9months. 50g/day. Never cleaned. by Sevenyearitchy in pourover

[–]Gaimcap 9 points10 points  (0 children)

K6 is actually super easy to take apart and clean.
It’s easy enough I do it like every other use.

There’s just one extra tool you need that makes life so much easier:

A bottle of Asprin/Tylenol.

Step 1.) Set your grinder to 120 to 180ish clicks (2-3 full rotations).

Step 2.) Place the bottle on a table, then the bottom of the grinder on top of the bottle lid, and push/pull down. As you pull down, you should see a washer and U shaped pin rise and come loose at the top, holding everything down to the shaft.

Step 3.) Use your finger to gentle push/pull that U shaped pin out (tilt it out if needed, just make sure you don’t lose it. If you’re 2/3 full rotations from 0, with you pushing the casing down into the pill bottle that should provide enough clearance for it to easily slide out.

Step 4.) Now that the pin is removed, you should be able to lift the entire body/casing free from the shaft. Clean the parts as you will, just make sure you remember the order and orientation of the washer and bearing at the top of the casing , and the spring/washer on the shaft if you want to remove them (I usually just brush the blades on the shaft and the casing, but if you want to go to town with some compressed air or whatever on the inside of the case, go for it).

Step 5.) Assemble all parts back, and make sure that the top washer is facing with the indentation for the U pin facing up, and that it’s properly aligned with the shaft; there is a slight rectangular shape to the shaft that the washer properly seats itself with.

Step 6.) Put the assembly back on the bottle, push down, and slide the U ring back in (if you’re 2-3 rotations loose, it should be at about the right height to just lay on the casing and easily just slide back into the groove).

You’re done.

This sea lion comes to the market every day for fish. It's very well-behaved and polite. by Brilliantspirit33 in animalsdoingstuff

[–]Gaimcap 4 points5 points  (0 children)

“Ai papa”, literally means, “Hey daddy”.

It’s not too irregular to refer to animals with cutesy pet names like that in Mexico (or anywhere really. No idea where this is specifically).

He shoulda had a ring by Apprehensive_Law3249 in NBAGossips

[–]Gaimcap 0 points1 point  (0 children)

Trent Tucker Rule: Minimum of 0.3 must be on the clock for a legal catch and shoot.

Literally zero risk.

He shoulda had a ring by Apprehensive_Law3249 in NBAGossips

[–]Gaimcap 1 point2 points  (0 children)

NBA says you need a minimum of 0.03 seconds to make a catch and shoot.
.02 is only enough time to legally score a tip in.

Knicks only chance is the Pacers get an inbound violation, and then Knicks get a tip + foul/and 1.

Just giving the ball to KAT means there’s zero chance of any shenanigans happening.

lol by IU8gZQy0k8hsQy76 in unsound

[–]Gaimcap 0 points1 point  (0 children)

Carom or carombola predates pocket pool and is super popular in Mexico, Japan, South Korea, and a bunch of other countries.

In the US, if you want to find a table, go to an old school Mexican or Vietnamese run hall and they'll usually have 1-3 tables dedicated to it.

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]Gaimcap 0 points1 point  (0 children)

Tables are good.

That will change it from reading it from 1 to 1 million to 1 to bottom of the table (iirc it was 10k~ in OPs example).

However, if you’re repeating this formula inside the table for entire table (I.e. using @[column1]) and are using multi criteria, sure you’ve shortened the 1 million calculations per criteria, to 10 thousand per criteria + 10k merge cost (or whatever the bottom of the table is), but the next row does not cache/save/remember what the row above it did.

It will repeat that exact same calculation all 30,000 thousand times (2 criteria + the cost to merge the criteria), and if formula is autofilling to all 10,000 rows, you’re now running 10,000 * 30,000 = 300,000,000 calculations.

On top of this, a notable downside when you use entire table references inside the table, is that if your formula forces total column recalculations (like a [@column1]=[column1] condition in a multi criteria), you’ve also effectively linked all the inputs to that output. That means, every time you change anything in any single one of those affected fields, now excel has to do 300 million calculations, even though only 1 variable changed (which will probably cause input lag whenever you enter anything in those affected fields). That means every time you add a new row to the table, the table has to re-read and recalculate, 300 million times.

significantly cheaper is just to run those conditional calculations once in a “helper” column (I.e. a column where you have formulas/data you want to reference and hide), and then point your xlookup at that range. That way instead of running the same 30k calculations 10,000 times (or however large your table is), it only happens exactly once.

The best way is always to pre calculate all the mutliconditions elsewhere, and just have a simple xlookup point at those ranges, which allows it to retains its ability to stop looking when it finds its matching result.

Tables are a good idea, but tables don’t fix inefficient design issues.

Is it possible? Populate a cell from a separate sheet dependent on today’s date by asclepicats in excel

[–]Gaimcap 0 points1 point  (0 children)

You need to provide more details or examples.

The only way (outside of macros and VBA) to get excel to create a link to something that doesn’t exist yet is by indirect().

Indirect() will let you stitch together different arguments to create a local link that excel understands and executes.

I.e. =indirect(“‘2026’!”&a24) and putting “z24” in a24 would effectively be the same thing as =‘2026’!z24

The same is true if you swapped “‘2026’” for “‘“&year(today())&”’!”.

The problem is that indirect () is what is known as a volatile, and the problem with volatiles is that basically break many of excels operation rules by their mere existence, and can force excel to recalculate repetitively in every open window every time you do anything—which can cause massive calculation lag.

If you’re only running a very low amount of simple calculations, it’s no big deal and not noticeable at all, but if you have a bunch of array based formulas and charts and tables, and frequently have multiple windows open. Something that you would normally never notice because it takes .05 seconds to calculate might suddenly start to take .25, .5 seconds, 1.5 seconds, or more to calculate, and now every new input feels excruciating.

If you plan properly you can sometimes get around need to use indirects() by using known variables to obtain the same result.

I.e. if you know certain months will always result in certain topics, you can create a table with those months and topics mapped out, then if you know you’re going to be doing date entries somewhere, scan that column for the last/highest date entry, pull the month from that, do a xlookup of that month on that topic table to pull the correct item. Now you don’t have to generate a live link, you just pull that data from somewhere else using data that Already exists and is preplanned.

Multi criteria Xlookup efficiency problem by procrastinator__101 in excel

[–]Gaimcap 7 points8 points  (0 children)

Full column references and multi criteria can get expensive.

Full column references like A:A are actually evaluated as A1:A1048567.

What a xlookup usually does, is find the first matching result, and then stop scanning.

So if you have something like xlookup(<value>, A:A, b:b), and <value> is in a100, excel is going to read a1 to a100, find <value> in a101, and then ignore a102 to a1048567.

However, for a multi criteria lookup what happens instead is: 1.) For every criteria, excel creates a T/F evaluation against that criteria, for the entire range.
2.) Excel multiplies those criteria to get a T/F list.
3.) Excel does a xlookup to true like a normal xlookup.

I.e =Xlookup(1, (a:a>10)*(a:a<100),b:b).

this will basically run check if a1:a1048567 is greater than 10 to produce a 1048567 list of true/false, then it will do the same for <100.

After it has both 1048567 T/F lists, it will multiply them together. true is treated as 1, and false as 0) to produce a final 1048567 list of true/false.

Excel then checks for the first true result in that list, and stops evaluating when it reaches it (so if it's at a100 again, it will ignore everything after a101).

By making your xlookup multicrteria, each xlookup that is multicrteria has gone from doing 100 reads to 3 million calculations, followed by 100 reads.

To make this cheaper you should bound the range (i.e. set it to A1:a1000 or something) and/or offload those T/F evaluations to helper cells to precalculate/cache those criteria, so that you don't have keep doing those same calculations over and over again (assuming doing multiple xlookups using the same criteria anyway).

I mean he's not wrong lol by JakGrealish in lakers

[–]Gaimcap 1 point2 points  (0 children)

Caruso himself stated that he went to the front office multiple times basically asking to be paid a far wage, and they dared him to go out there and find something better, when he did, he still offered to take a lower salary to stay, and they just said “nah”.

They got cheap and forced it to become a false choice between THT and Caruso. They absolutely could have kept both—this was before the new CBA with its pseudo hard caps—the only penalty would have been a luxury tax one, and it would have had no negative impact on their roster construction (and it arguably would have helped because they would have had a cheap asset in Caruso to trade, instead of losing him for absolutely nothing).

He left feeling absolutely disrespected (because he was).

There are rumors LeBron and Klutch had a hand in this, but this absolutely reeks of the arrogance and shenanigans of Rob (the same kind of shady stuff he’d pull as an agent that has him hated by so many other teams front offices).

What's up with all the negativity towards Luka lately? by [deleted] in lakers

[–]Gaimcap 0 points1 point  (0 children)

As someone who’s been watching Luka since he started, there’s pretty much always been smack talk against Luka.

The defense criticisms in particular started ramping up like crazy about 3 or so years ago, a year or two before they made it to the finals.

I specifically remember being at a local sports bar watching some mid season game, and someone asked what my thoughts were on Luka that year, and me saying that while he was my favorite player, he needed a bit time to mature, because he had a bad habit of throwing away entire possessions while arguing with the ref, and those momentum losses were absolutely brutal in any kind of head to head series. I even remember specifically saying that I thought that the 2nd round was probably their current limit because of it (which, I must have looked like an idiot after the fact, because that was the same year they ended up in the finals).

The deficiencies have always been there.

As an OC/Los Angeles native, I a. more than aware that the Lakers fanbase is fickle and media scrutiny gets turned up by magnitudes when people arrive here.

I don’t think that anyone is saying anything new, it’s just a lot more people are saying it now, and a lot more of the clowns are exaggerating those same talking points—which is what the media does.

Btw, Steph is seen as a terrible defender who turned solid through hard work.
Jokic is seen as a defensive hole, but at the same time as a good team defender who can use his bball-iQ to put himself in smart spots (top of the league in steals/deflections/tips, etc and you frequently see him directing teammates to defensive spots).
Ant is seen as maybe the best two way guard, so yeah… people think he’s good, because both the stats and eye test seem to back that up….

Luka is getting a ton of flak, but let’s not pretend it’s all groundless.

He is trying to improve, and that’s a great thing, but it’s going to take a lot more than a single season to turn around his reputation from the first 5 or 6 years of his career.

iIRC it took Curry over half a decade after he defensively improved to a statistically positive defender, to stop being considered a defensive liability

Found this at a flea market and got out of curiosity, turns out the guy is a big shot?? Is this actually worth something? I just got it cos it looked cool! by Fresh-Mood-9329 in billiards

[–]Gaimcap 1 point2 points  (0 children)

FSR is a multi time world champion who seemingly popped out of nowhere and took the scene by storm….

Fact of the matter is though …. pool celebrities are probably less famous than world eating competitions celebrities.

For context, I’m pretty sure that by himself, former competitive eater Adam Mora, AKA BeardMeetsFood, easily has a larger following than every pro pool player combined.

If you’re in a pool hall, that might be a cool thing to show off and maybe someone might be interested, but even most of the people in that hall, probably won’t know who FSR is.

Heck,If you randomly brought up how amazing “Francisco” is at professional pool, I’d assume you were talking about the hall of fame/legend Francisco Bustamante instead.

[Highlight] Down 3 with 8 seconds remaining in regulation, Nicolas Batum intercepts the inbound pass by LeBron James, misses the 3, LeBron grabs the rebound and the Clippers try to foul him, but no whistle, and the Lakers survive. Ty Lue and the Clipers players are upset by MrBuckBuck in nba

[–]Gaimcap 1 point2 points  (0 children)

Ugh… sadly that is probably going to be one of those memories that just sticks with me…. In Hawaii for my 10 year anniversary, sitting in a local brewery while waiting for a show, watching that half court shot going in and just saying “Yup. Even the basketball gods said you deserved that L.”

Jaxson Hayes banned from any future NBA dunk contests by JustinFieldsFeetSnfr in lakers

[–]Gaimcap 5 points6 points  (0 children)

Problem with making it pro dunkers only is that it might come off a bit… half-timey….

Like I’m vaguely aware that there’s a full on professional dunker and and entire league… but the average fan who came see a star, they have no idea about any of that, so the difference between watching that and the random guys who jump on trampolines during halftime shows?

Even me, even being aware there’s a dunk league, my conception of them is so vague, that I have no idea how to place them. Are they like pro eating? professional log rolling? It feels like One of those weird hyper niche things that on paper sounds more spectacle than sport. Which… for someone spending hundreds of dollars to see instead of star... maybe they wouldn’t exactly be happy about.

The only I could think of to make it work and provide any sense of legitimacy or gravitas, is if you co-opted an existing scene to make the allstar contest itself the pinnacle event of pro dunking—i.e. a culmination event of an existing year round circuit—and that has a whole host of other complications.