I just went through quite a lengthy (several months) keyboard replacement process for a 2018 Macbook Pro 15" and thought I might share a few things I learned along the way.
TL;DR

1. Keyboard replacements at the Apple Store include the Keyboard, Touch-bar, and Battery (at least for my MBP 15).
2. All costs were covered by Apple, but in case you're curious, the invoice listed $100 for labor and $578 for parts for each top case repair (more on this later).
3. After 3 repairs for the same issue, there is an opportunity to get a replacement.

Part 1: Store Visits
First time I went to the Apple Store late last year I mentioned the sticky keys issue which the employees were able to quickly reproduce. I also mentioned that my battery was having issues since I was getting about 1% percentage drop every 2-3 minutes. They ran their diagnostics which didn't find anything wrong, but the Apple employee was pretty upfront and mentioned that the top case part that they replace would include the keyboard, touchbar, as well as the battery. I got my replacement back after 3 days.
TBH, I was pretty excited to see a nearly brand laptop - the keyboard was fixed, however the battery issue got worse after the replacement dropping 1% every 1-2 minutes. I played around with it for a week to see if I could reproduce it. Brough it to the store and they were quick to spot the issue and offered to replace the entire top case again for free. Got it back, and unfortunately no-go. The store employee mentioned I should call an Apple Specialist since senior advisors could help me debug more serious issues.
Part 2: Specialist Calls

1. Specialist 1 asked me to run power cycles and download a diagnostic to record logs.
2. Specialist 2 suggested I try another power adapter (and actually sent me a new power adapter to try).
3. Specialist 3 asked me for screen recordings and more diagnostic logs to send to engineering.
4. Specialist 4 mentioned that had I gone back to the store a 3rd time for the same battery repair that I had an option to get a replacement.

Throughout this process I realized that my Macbook was consistently draining 1% of power per minute while just browsing on Safari.
Part 3: Resolution
Well it ended up being a fairly complex hardware problem and the issue is resolved now, just wish it hadn't taken a few months.
Make sure to document (down to the day-level detail) your interactions with an agent because sometimes they switch case numbers on you and you really need to track what happened and when if your support case becomes complex.

Got taught a lesson in the consistency of habits over last few days.
With the recent theme of streams highlighting being in some of the companies we use, I had a look at Nike, especially as Kaz has mentioned a number of times that Nike is well positioned for Web 3 and digital goods.
Had some levels drawn up but not a thorough plan, more a general idea. Noticed that retail had been rekt for a week or two while tech pumped, so set some alerts.
Market open on Wednesday and Nike gapped down into a level. Ended up taking a shot during the session despite it clearly not being best of breed. Managed to cut some and decided to sleep, had stop set for rest of session.
Used the next day to clean up my Notion thanks to Yonas amd realised how disorganised my page was. Pre market had an impromptu concept call which led me to the introspection of my organisation being lacking in Notion & that isnt a fundamental that bodes well for trading. At this stage pre market my remaining Nike position was up pre market.
Market opened and Nike gapped down under my stop and I had to manually close. Pissed at a poor decision costing R’s, as it seemed obvious not to be holding something in a downtrend overnight. Checked my levels and further realised I had missed another obvious one which corresponded with the area gapping down into.
Shortly after took another entry, with clearer picture and plan in mind. Managed to cut half and recoup something. Figured I’d better close the position fully before sleeping rather than risk getting gapped again if the trend continued.
Woke up today to a full short position as I hadnt deleted my original stop after I manually closed out. Price wicked the order to the cent, activating the short just before close. Nike also had some news and is currently gapping up a few percent so copped it both ways
Just shows a good idea on a good level when put in place with vague planning and preparation can lead to compounding mistakes, and they are the fundamentals of a shitty trade.

I don't know what sub to post this in but I need to ask for advice somewhere because I'm running out of food. I'm out of town for work at an air bnb and I've lost my debit card and they've sent a new one in the mail but they would only send it to my address 5 states away. I'm going to have family mail it to me when it gets in but I'll be totally without access to money for another week and a half. I have no US Banks in the state I'm currently in (Florida) buy I do have access to zelle and my routing/account number. Is there anything I can do to access my money?

/collegebaseball General Discussion Thread - REGIONALS WEEK: Part II (2023)

— Rules

— Guidelines

— Get Team Flair

— Inline Flair List

— Line Score Template

Regionals Week Games

Mon	Tue	Wed	Thu	Fri	Sat	Sun	Mon
29th	30th	31st	1st	2nd	3rd	4th	5th

2023 Postseason Top 25

Mean+Median 3-Poll Composite

Rank	Team	Conference	D1B	BWA	USAT	Prev.	Δ
1	Wake Forest Demon Deacons	ACC	1	1	1	1	—
2	Florida Gators	SEC	2	2	2	2	—
3	Vanderbilt Commodores	SEC	4	3	4	6	↑3
4	Arkansas Razorbacks	SEC	5	4	3	5	↑1
5	Clemson Tigers	ACC	3	6	5	8	↑3
6	LSU Tigers	SEC	7	5	6	4	↓2
7	Stanford Cardinal	Pac-12	6	7	6	3	↓4
8	Miami Hurricanes	ACC	8	8	10	10	↑2
9	Coastal Carolina Chanticleers	Sun Belt	9	9	8	7	↓2
10	Virginia Cavaliers	ACC	11	11	9	11	↑1
11	Campbell Fighting Camels	Big South	12	10	11	15	↑4
12	ECU Pirates	American	15	12	12	12	—
13	Connecticut Huskies	Big East	10	13	14	9	↓4
14	Oklahoma State Cowboys	Big 12	16	15	13	17	↑3
15	Dallas Baptist Patriots	C-USA	18	14	15	16	↑1
16	Southern Miss Golden Eagles	Sun Belt	13	17	19	21	↑5
17	Oregon State Beavers	Pac-12	14	21	17	13	↓4
18	Tennessee Volunteers	SEC	21	18	16	14	↓4
19	South Carolina Gamecocks	SEC	NR	16	18	19	—
20	Maryland Terrapins	Big Ten	19	19	25	25	↑5
21	Alabama Crimson Tide	SEC	22	20	23	NR	↑6
22	Indiana State Sycamores	MVC	23	23	20	NR	↑
23	Kentucky Wildcats	SEC	NR	22	21	23	—
24	West Virginia Mountaineers	Big 12	NR	25	22	18	↓6
25	Auburn Tigers	SEC	20	27	NR	NR	↑1
NR	Duke Blue Devils	ACC	NR	24	NR	24	↓2
NR	TCU Horned Frogs	Big 12	17	28	NR	NR	↑
NR	Oregon Ducks	Pac-12	24	26	NR	NR	↑
NR	Boston College Eagles	ACC	NR	29	24	20	↓9
NR	Texas A&M Aggies	SEC	25	30	NR	NR	↑

BA – Baseball America
D1B – D1Baseball
CBW – National Collegiate Baseball Writers Association
USAT – USA Today

2023 Division 1 League Champions

Conference	Regular Season	Tournament
ACC	Wake Forest	Clemson
America East	Maine	Maine
American	ECU	Tulane
A-10	St. Joseph's	George Mason
ASUN	Lipscomb	Lipscomb
Big 12	Oklahoma State, Texas, & West Virginia	TCU
Big East	Connecticut	Xavier
Big South	Campbell	Campbell
Big Ten	Maryland	Maryland
Big West	UC San Diego*	ɴᴏɴᴇ
CAA	UNCW	UNCW
C-USA	Dallas Baptist	Charlotte
Horizon	Wright State	Wright State
Ivy League	Pennsylvania	Pennsylvania
MAAC	Fairfield	Rider
MAC	Kent State	Ball State
Missouri Valley	Indiana State	Indiana State
Mountain West	San Diego State & San José State	San José State
NEC	Central Connecticut	Central Connecticut
Ohio Valley	Morehead State	Eastern Illinois
Pac-12	Stanford	Oregon
Patriot	Army	Army
SEC	Arkansas & Florida	Vanderbilt
SoCon	Samford	Samford
Southland	Nicholls	Nicholls
Summit	Oral Roberts	Oral Roberts
Sun Belt	Coastal Carolina	Southern Miss
SWAC	Alabama State	Florida A&M
WAC	Grand Canyon	Sam Houston
West Coast	Loyola Marymount	Santa Clara

*ineligible to receive automatic qualifier; Cal State Fullerton was rewarded the bid

Sometimes a band gets so big that they somehow outshine themselves. They reach a point in their career where it does not matter if they release a new album or not; fans just want to see them tour. No one gave a damn that Led Zeppelin had not released a new album since the 1970’s; everyone just wanted to see them play again at the O2 Arena in 2007. When The Who played the Super Bowl halftime show in 2010 they had only released one new album in 28 years, and no one cared. And no one cares that Guns & Roses aren’t making new music. They still packed arenas to see how much cake Axl had packed into himself.
We’re going to take a dive into a blues power trio from down south who have zero need to release any new music, since their recording career stretches back over five decades. They had amazing and groundbreaking success in the ‘70s, the ‘80s, and the ‘90s before hitting the max level. Instead of playing to win, they now play for fun. Their sexually charged lyrics and videos inspired generations of teens to both dress better and worry about their fly. And you can bet that their fuzzy, bluesy tight sound had a huge impact on our very own desert dwellers.
It’s time for us to take a walk with That Little Ol’ Band from Texas. This week’s featured artist is the legendary ZZ TOP
About Them
The Power Trio is a tested and true format for a rock band. Lots of examples come to mind: Cream. Rush. The Police. Biffy Clyro. King Buffalo. Them Crooked Vultures. (Wait a sec. Just three members? Clearly, not everything is bigger in Texas.)
There is a member joke there somewhere, but I just can’t get it to come. Hmm. Perhaps it will come if you play with it a bit.
Hey! Stop that. Get your mind out of the gutter.
ZZ Top’s original and founding member was William Frederick Gibbons. Born in Houston in 1949, the front man was originally a drummer but, after studying with Tito Puente in New York City, picked up the guitar at age 13. His dad was a musician in show business, which allowed Billy to get an insider’s view of the industry. By the late ‘60s, he had been in and founded a number of bands and had even befriended the late great James Marshall Hendrix. One of his first bands, a psychedelic/art house band called The Moving Sidewalks, toured with the Jimi Hendrix Experience. This meant that Gibbons was actually mentored by Snagglepuss himself. They also toured with The Doors, where Gibbons saw the legendary self-destructive band somehow manage to rise above conflict and make music every night. The Moving Sidewalks generated a following all of its own with a couple of hit songs, and things seemed to be headed in the right direction.
Things were going absolutely great until bassist Don Summers and keyboard player Tom Moore were drafted into the army to fight in Vietnam. Don't you just love the ‘60s?
Gibbons and drummer Dan Mitchell added a new keyboard player, Lanier Greg, and tried to make another run at it. But the chemistry was all wrong. Gibbons rechristened the band as ZZ Top (an homage to BB King), and declared that he wanted more of a straight up rock approach than the art-house kaleidoscopic sound.
Gibbons, Mitchell, and Greg (isn’t it weird when last names are also first names too?) recorded the single Salt Lick in 1969. This generated a bunch of interest and a recording contract. Decisions over the direction of the band ensued and it quickly became clear that Mitchell and Greg did not agree with Gibbons’ hard rock approach. That ended up being a poor life decision for them, but a great one for a couple of other guys.
Clearly, Gibbons needed a new rhythm section.
Fortunately, he found a package deal.
Dusty Hill and Frank Beard - also both born in 1949 - had been playing together on the Dallas-Houston-Fort Worth circuit in a number of bands, including The Warlocks, The Cellar Dwellers, and a fake cover band called The Zombies. Both the Duster and the (then ironically) beardless Beard also heard the siren call of rock and roll. Hill was classically trained and was an accomplished cello player before moving to his signature bass. Frank ‘Rube’ Beard appears to have been born with drumsticks in his hands (which I imagine might have been uncomfortable for his mom).
Beard joined the band first, along with bassist Billy Ethridge, who had played with Stevie Ray Vaughn. Ethridge balked at signing a contract and so joined Mitchell and Greg on the list of ZZ Top’s former members. Their lineup was set. Hill and Beard anchored the band in a rock-solid, tight, bluesy fashion. Gibbons meshed perfectly with this duo, and his Hendrix-inspired guitar work was on another level. Hill provided backing vocals, and Gibbons’ low throaty growl was an impressive counterpoint to his soaring fretwork. The talent was all there; now they just needed to record some music.
But success was not instantaneous, not by a long shot.
Their first album - appropriately called ZZ Top’s First Album - gives insight into who the band were to become. In this 1971 release, you can hear their raw sound. The record peaked at 201 on the charts, and had only one single - (Somebody Else Been) Shaking Your Tree. It did give them material to go out and tour. The boys gelled on that tour and went back into the studio with renewed energy, and emerged with 1972’s Rio Grande Mud. The disc was a step forward in refining their sound. The album almost cracked the top 100, and the only single - Francine - went all the way to number 69.
Nice.
But the band knew that their third album, Tres Hombres, was something special. It is the epitome of Southern Rock: bluesy, fast paced, sexy, and irreverent, it is just over half an hour of pure magic. And while the album went gold and peaked at number 8 on the charts and is worth your time, it was one particular single that rocketed them to stardom. You know it and you love it, and a-how-how-how-how: La Grange. It is still in heavy rotation on classic rock stations today. And why not? The song is an absolute banger of boogie woogie blues, written about a visit to a whorehouse. What’s not to love?
La Grange propelled them to popularity. Tours sold out. Venues got bigger and bigger. 1975’s follow up album, Fandango!, was half live album (with some covers) and half new material - like an EP with bonus tracks. They covered the Elvis Presley classic Jailhouse Rock, Willie Dixon’s Mellow Down Easy, and John Lee Hooker’s Long Distance Boogie. The boys had rock and blues chops, and had 5 years of touring experience. These were bold statements that cemented their musicality as well as honoring their roots. But side two of the disc had another track that you’ve come to love. You ain’t asking for much: You’re just lookin’ for some Tush. Tush was the perfect sexually charged follow up to ensure that they were not one-hit wonders. It was written in a ten-minute spasm of creativity at a sound check, and has gone on to be one of their most popular songs.
While Tush topped the charts, ZZ Top went back into the studio to record their full length follow up, 1976’s Tejas. The name of the album means ‘friends’ in the Indigenous Caddo language, and was the basis for the name of the state. You know what that means? It means that the name of the state is ‘Friends’. Just like the ‘90s sitcom. Don’t mess with Friends. Anyways, this was an album of experimentation for the band, and unlike its predecessor it came out half baked at best. Billy Gibbons has called it a transition album. What actually happened is the band transitioned into a hiatus from touring and recording, taking some significant time off. They had recorded five albums in six years and spent virtually all their time on the road. The latest effort was just not up to their standards and was a step back. It also completed their recording contract.
What was the solution to this burn out?
Facial hair of course.
The boys took a few years off before landing another recording contract, this time with Warner. Over those months, both Gibbons and Hill grew what would become their signature long ‘Texas Goatee’ beards. Frank Beard did not grow a beard (though he did finally succumb to peer pressure from his bandmates in 2013, and his is much more neatly trimmed). So while they were resting/relaxing/getting their groove back/aligning their chakras or whatever, they also started to reinvent their signature sound as the world moved towards a decade of legendary excess.
The first step on this reinvention journey was 1979’s Degüello. The title literally means ‘decapitation’ but idiomatically refers to a fight to the death. Clearly, the band decided to tackle their transition head on. The album was not as successful as Tres Hombres or Fandango!, but it was not the flop that Tejas was. It did spawn a couple of singles - I Thank You (which was a cover) and the signature hit Cheap Sunglasses. Both are staples at ZZ Top concerts to this day. Degüello was quickly followed up in 1981 by the album El Loco. This was really the first time ZZ Top incorporated a synthesizer into their sound. As you know, the synth was THE new wave sound of the 1980s. Gods help us, keytars were once popular. But Gibbons, Hill, and Beard did not abandon their edge. The single Pearl Necklace was an immensely popular innuendo laced tune from this album. And no, I will not explain what a pearl necklace is to you.
Ask your mom.
Over the course of their first seven albums, ZZ Top had steadily grown in popularity and become a truly extraordinary live band. More than a decade of touring together meant that they had not just cut their teeth. They had found the Tooth Fairy, beaten her senseless, and added fangs to their jaws. They were ready to tackle whatever came their way.
Their huge breakthrough coincided with the birth of music videos and MTV. 1983’s Eliminator was an absolute monster of an album. ZZ Top were everywhere. They completely embraced the Music Video as a medium and became pioneers in this new genre. They branded their band with a 1933 fire-engine red Ford Coupe, which was on the cover of the album. They even had a signature hand gesture that they used as the car went by. The car belonged to Billy Gibbons and embodied his hot rod obsessions. It was featured in the videos for Gimme All Your Lovin’, Sharp Dressed Man, and Legs. Other singles from the album included Got me Under Pressure and TV Dinners. Eliminator is still the band’s most successful album. They were at the absolute height of their popularity with a massive audience. No doubt the 10-year-old Joshua Michael Homme watched those videos on a small screen in the California desert, little knowing that he would one day collaborate with Gibbons.
Seeking to capitalize on the popularity, the band went back into the studio and released Afterburner in 1985. It featured the signature hot rod on the cover and spawned two more singles - Sleeping Bag and Velcro Fly. Afterburner was not an innovative album by any stretch of the imagination. It simply built on the success of Eliminator and replicated the sound. If you blended the two albums together it would be very difficult for a novice fan to guess which song came from which disc. But hell, when you release the most popular album of your career and are earning millions of dollars for that sound, it is not time to mess with success. Or with Texas. Or with Friends (though Ross was a pain in the ass, IMHO).
That desire to not screw up a good thing was also evident in their next release, the retrospective re-release Six Pack. This was a great way to earn some bucks with a simple repackaging of existing tracks - I’m looking at you, K-Tel… - and introducing them to another generation of fans. This was not a bad thing at all - you gotta get that green whenever you can, because fame can be fleeting.
ZZ Top closed out the decade by going Back to the Future. Literally. They appeared in the third installment of the Michael J. Fox trilogy as the olde-timey house band (complete with rotating guitars) in the saloon scene. The single and signature song from the movie, Doubleback, appeared on their 1990 release Recycler. The album spawned two more singles: My Head’s in Mississippi and Concrete and Steel. Recycler was not as successful as its predecessors, but it did effectively max level the band. In the 1970’s they were a scuffling bar band that hit it big. In the 1980’s they were one of the most popular bands of the MTV generation. And in the 1990’s they achieved superstardom. They had hit the level where it truly no longer mattered if they ever released new material again. They could simply tour on their back catalogue alone and sell out stadiums.
It is clear that the band realized this as well. In the thirty years since Recycler came out, they have released five albums of new material: Antenna in 1994, Rhythmeen in 1996, XXX in 1999, Mescalero in 2003 and the critically acclaimed and Rick Rubin produced La Futura in 2012. This was equivalent to their output in their first six years.
In contrast, they have released no less than eight greatest hits albums, cover albums and live albums in the same time span. Greatest Hits came out in 1992. One Foot in the Blues was released in 1994. The massive compilation Chrome, Smoke & BBQ came out in 2003, and is a fantastic place to start if you are a new fan. Rancho Texicano was released in 2004, Live from Texas came out in 2008, and Double Down Live hit shelves in 2009. Live at Montreaux came out in 2013 and Tonite at Midnight: Live Greatest Hits from Around the World was released in 2016.
As recently as 2019, there were rumors that a new album was in the works for our Septuagenarian heroes. Lord knows the boys from Texas have nothing left to prove to anyone.
It was then that tragedy struck. Dusty Hill had to leave the band during a tour in 2021. The reason given was a hip injury. His guitar tech, Elwood Francis, filled in. Shockingly, Hill died at home at the age of 72 just five days after leaving the tour.
Fans were shocked and mourned the stalwart bassist. Per his wishes - and it seems he knew something wasn’t quite right - ZZ Top did not break up. Francis replaced Hill on bass, and the band soldiered on. In 2022, they released Raw, a soundtrack for a 2019 documentary about them. This was Hill’s final release.
You can still catch them on tour. They are going to be out there this summer, touring with Lynyrd Skynyrd, for something they are calling ‘The Sharp Dressed Simple Man’ Tour.
Go buy some tickets. Don’t miss your chance to see a truly iconic band before they are gone.
Links to QOTSA
The Reverend Billy F. Gibbons was a big part of the Lullabies to Paralyze album by our Desert Dwellers. He played guitar and provided backing vocals on Burn the Witch. He was co-lead vocalist and lead guitar on the QotSA cover of Precious and Grace, which he originally released as a ZZ Top tune on the Tres Hombres album. He also provided the guitar stylings for Like a Drug.
But the connections don't stop there. Billy sang the lead vocal track on the recent Desert Sessions tune Move Together, and he played guitar on Noses in Roses, Forever.
What may be most important to QotSA fans is that Gibbons was the first person, almost two years ago, who hinted that Queens were working on a new album.
And now we know he was right. Never doubt a Reverend.
Their Music
Salt Lick
(Somebody Else Been) Shaking your Tree
Francine
La Grange -- Live on Howard Stern
Jailhouse Rock
Tush -- a fan made video. It is not subtle.
Cheap Sunglasses
Pearl Necklace -- Live
Gimme All Your Lovin’
Sharp Dressed Man
Legs -- the ultimate makeover video
Got Me Under Pressure -- Live at Montreaux
Sleeping Bag -- Let’s go out to Egypt and check out some heads...
Velcro Fly -- also somehow in Egypt
My Head’s In Mississippi
Concrete and Steel -- vintage video
Doubleback
I Gotsta Get Paid -- from La Futura
Show Them Some Love
/zztop
Previous Posts
Tool
Alice in Chains
King Gizzard and the Lizard Wizard
Rage Against The Machine
Soundgarden
Run the Jewels
Royal Blood
Arctic Monkeys
Ty Segall
Eagles of Death Metal
Them Crooked Vultures
Led Zeppelin
Greta Van Fleet
Ten Commandos
Screaming Trees
Sound City Players
Iggy Pop
Mastodon
The Strokes
Radiohead
All Them Witches

This is a continuation of my first post: https://www.reddit.com/SSC/comments/bbx1yq/the_society_of_the_police_and_its_social_adherence/
I found an interesting article a while back which I've been thinking about for awhile. It's about the police and their social acceptability.
Here goes. (I'm going to assume you already did the research to learn about this).
This article is written by a psychologist, and is interesting for a number of reasons.

1. It's very much a first-hand account of life in the USA.
2. It's not necessarily a condemnation of the police, as it's not a judgment of the police by any stretch.
3. It's written by an officer, and so is much more credible than any other officer in the world.
4. It's a little bit of an indictment of the police, and the system, but not necessarily a condemnation of the police.
5. It's very much a "my personal experience" type of story, and not necessarily a general picture of the police in general.
6. It's written by a former police officer, and thus very much reflects the mindset of a former police officer.
7. The author is a former officer, and so is very familiar with how the police work, and how the system works.

So that's a few reasons why this is interesting. There's also a couple of references at the end.
So, here's my question for you. What are your thoughts on this article?

This is the best tl;dr I could make, original reduced by 40%. (I'm a bot)

Ben Wallace, UK Defence Secretary, who has expressed a desire to become the next NATO Secretary General, does not see Ukraine joining the Alliance shortly.
Details: Answering a question about Ukraine's prospects of joining NATO, Wallace pointed to the existing disagreements about Kyiv's path to the Alliance.
"We have to be realistic and say: 'It's not going to happen at Vilnius'; It's not going to happen anytime soon," Wallace said, referring to the NATO leaders' summit scheduled for July.
"But what can those powers that want to be more forward-leaning do to help Ukraine, and to give it not 100 percent but a similar effect to what NATO delivers?" asked the UK Defence Secretary.
Wallace said that a number of countries are willing to enter into bilateral or multilateral "Mutual defence pacts" with Ukraine and commit to long-term plans to build the country's military capabilities to make sure that an invasion of Ukraine in the future will be costly for Russia or anyone else.
President Volodymyr Zelenskyy is looking forward to a step forward in rapprochement with the North Atlantic Alliance and states that security guarantees are needed only until Ukraine is in NATO. Journalists fight on their own frontline.

Summary Source FAQ Feedback Top keywords: Ukraine^#1 NATO^#2 Wallace^#3 Russia^#4 Secretary^#5
Post found in /worldnews.
NOTICE: This thread is for discussing the submission topic. Please do not discuss the concept of the autotldr bot here.

I have been seriously fishing (on my own, own tackle, all that good shit) for roughly 2-3 months. In that time i have had hooked a number of fish one huge carp who managed to escape just after getting him in the net, and about a 1ft pike who fought like hell and unhooked as well. I'm loving life even just hooking the fish (especially on lures) really gives me a rush...well enough to keep me coming back.
Anyway, the other night i go to my favourite spot, loads of trout and apparently a couple pike and perch and I hooked something! it looked like a fish, but wasn't fighting and my hook was not in its mouth. obviously being green got worried/interested what i had done. brought it up to the bank and there it was, a DEAD, DECOMPOSING HALF OF A FISH. Has anyone else done this before? is it bad luck? should i stop fishing there?
​
(also can upload a photo for any sikkos that wanna see)

Dear fellow Snarkers, this week, Reddit made a new announcement that might affect the platform and its users as of July 1st.
Full post about Reddit new announcement can be found here:
https://old.reddit.com/modnews/comments/13wshdp/api_update_continued_access_to_our_api_fo
Summary of what Reddit Inc has announced so far, specifically the parts that will kill many third-party apps:

1. The Reddit API will cost money, and the pricing announced today will cost apps like Apollo $20 million per year to run. RIF may differ but it would be in the same ballpark. And no, RIF does not earn anywhere remotely near this number.
2. As part of this they are blocking ads in third-party apps, which make up the majority of RIF's revenue. So they want to force a paid subscription model onto RIF's users. Meanwhile Reddit's official app still continues to make the vast majority of its money from ads.
3. Removal of sexually explicit material from third-party apps while keeping said content in the official app. Some people have speculated that NSFW is going to leave Reddit entirely, but then why would Reddit Inc have recently expanded NSFW upload support on their desktop site?

HarkleSnarkle will remain on Reddit for the time being, but we are trying to find new alternatives to Reddit, especially since we know some users use only third party apps like; Narwhal, Reddit is Fun, and Apollo.
We do have a HarkleSnarkle Discord server, and anyone can join, we only need that you send us a DM through modmail, or directly to my account, and we can verify your account. This is just an easy step to make Discord spam-free.
Have great weekend
Best
Your mod team!

Howdy,
Here is what it is high-lighted in VBA:
Sheets("Click").Select
Columns("A:A").Select
Selection.TextToColumns Destination:=Range("Table1[[#Headers],[Column1]]"), _
DataType:=xlDelimited, TextQualifier:=xlSingleQuote, ConsecutiveDelimiter _
:=True, Tab:=False, Semicolon:=False, Comma:=False, Space:=False, _
Other:=True, OtherChar:="!", FieldInfo:=Array(Array(1, 1), Array(2, 1), Array _
(3, 1)), TrailingMinusNumbers:=True
​
Now this only happens when the Macro I run before the above has this code in it (I have put in the ' until I found out when the error went away):
' Sheets("Click").Select
' Range("A1").Select
' ActiveCell.FormulaR1C1 = "Raw Data"
' Range("A1").Select
' With Selection.Interior
' .Pattern = xlSolid
' .PatternColorIndex = xlAutomatic
' .ThemeColor = xlThemeColorAccent6
' .TintAndShade = 0
'.PatternTintAndShade = 0
'End With
​
https://preview.redd.it/xbpc5nzq1l3b1.png?width=417&format=png&auto=webp&s=14b19e426b14868eaaadf5a48bd82ab51e1783ee
I can post the entire VBA, it is not that long.
Thanks for looking,
Regards
Narg

Hello!
​
It seems every time i look at laptops, they try to make the naming more confusing!
I'm looking at Slim + light and 2in1 laptops, and the names are confusing.
​
I am no expert, I just used to look up the CPU on https://www.cpubenchmark.net/ and make sure the number is good.
Take these 3 CPUS
​
i5-1035G7 - https://www.cpubenchmark.net/cpu.php?cpu=Intel+Core+i5-1035G7+@+1.20GHz&id=3582
i5-1340P - https://www.cpubenchmark.net/cpu.php?cpu=Intel+Core+i5-1340P&id=5237
Intel Core i7-1355U - https://www.cpubenchmark.net/cpu.php?cpu=Intel+Core+i7-1355U&id=5317
​
from this, the I7 looks signifcantly worse than the I5?
​
Is this the best "quick and dirty" way to make sure i get a decent CPU?
Thanks!

Hello BEFreelance community,
I've recently started my journey as a freelance IT project manager and have run into a challenge with a client. The client is currently facing some cash flow problems, which has affected the prompt payment of my invoices. This, in turn, impacts my own cash flow.
To address this, I am considering using a factoring service for about the next 6 months to help ensure more consistent cash flow on my end.
Here's where I need your advice:

1. Can anyone recommend a reliable factoring firm? Ideally, I'm looking for one that has experience working with freelancers or small businesses in the IT sector.
2. What are some key considerations when choosing a factoring firm? Any hidden pitfalls I should be aware of?
3. What has been your experience with factoring, if you've used it? Has it helped your cash flow situation as expected?
4. Any advice on negotiating terms with a factoring firm?
5. Finally, if you've faced a similar situation, I'd be interested in knowing how you managed it and if there are alternatives to factoring that you'd recommend.

To add some context, I am currently contracted through an intermediary client who connected me with the end client. I really enjoy the projects I'm working on for the end client; they're both challenging and interesting. Additionally, I've signed a non-compete agreement which prevents me from continuing to work with the end client directly, outside of my current arrangement. Therefore, while seeking a different intermediary client might seem like the simplest solution, I'd prefer to find a way to manage the cash flow issue while continuing to work on these engaging projects.
Thank you in advance for your time and advice.
Best,

I have 3 tables in power bi desktop.
The first table is called calendar, which has a date column and a period column.
The second table is called employees and has columns for name and hire_date.
The last table is called sales and has a employee_name column, sales_date and sales_value.
There is already a relationship between employee_name and name in the employee table.
I would like to make a graph which shows the total sales each period and the hires each period. So I created a relationship between calendar’s date and the date in the other 2 tables, but power bi says there is an ambiguous relationship.
Is there another way I can create this single graph with the period number on the x axis?