Okay so this whole basketball stats thing started because my buddy Sofia kept texting me every Monday like clockwork – “Hey did Tindastoll climb up the division yet?” Manually checking that league table every week got old real fast. Figured there’s gotta be smarter way.
The Annoying Manual Hunt
First I just went straight to the usual league website last Tuesday morning. Coffee in hand, clicked through like five menus – division standings, women’s section, region selection – seriously why bury it so deep? Finally found their group standings… and boom, sixth position right there in the middle. Took like 15 clicks just to see one number.
Wednesday I thought maybe download their official PDF report from the news section. Big mistake:
- Had to register an account with email
- PDF was 20 pages full of fixtures and ads
- Tindastoll stats were on page 17 mixed with sponsor logos
Complete waste of time feeling stupid scrolling that tiny phone screen.
The Spreadsheet Rescue Attempt
Thursday I cracked open Google Sheets like “alright let’s automate this mess”. Tried copying table straight from website into Sheet – total disaster. Stuff went everywhere:
- Team names split across two columns
- Points showed up with weird symbols
- Win/loss columns mashed together
Spent an hour cleaning that garbage. Changed to just manually typing:
- Position: 6th
- Points: 14
- Wins/Losses: 4-3
Simple. Ugly. But worked.
Finally Fixed It
Friday afternoon I added two formula things I remembered:
=VLOOKUP function for grabbing just Tindastoll row
=RANK function showing position automatically
Double checked league site yesterday – yep still sixth place. My janky Sheet matched. Showed Sofia today – she actually understood it! Now every time scores update I just plug new numbers into my purple “input zone” cells. Position auto-shouts at me like “HEY THEY MOVED!”
Honestly? This trash spreadsheet gets uglier every week with my handwritten notes all over it. But beats checking that cursed league navigation ever again. If they jump to fifth next week? My stupid purple cells will yell it first.
