Skip to content
Do you have adblock enabled?
 
If you can read this, either the style sheet didn't load or you have an older browser that doesn't support style sheets. Try clearing your browser cache and refreshing the page.

(Ars Technica)   ESPN takes a break from showing the monotony of watching the batter adjust his gloves for the 3rd time to air a real sport   (arstechnica.com) divider line
    More: Cool, Competition, Financial Modeling World Cup, ESPN, Excel Esports, version of the full two-hour, winner of the first championship, last weekend, David Brown  
•       •       •

1142 clicks; posted to Sports » on 11 Aug 2022 at 8:45 PM (7 weeks ago)   |   Favorite    |   share:  Share on Twitter share via Email Share on Facebook



25 Comments     (+0 »)
View Voting Results: Smartest and Funniest
 
2022-08-11 8:58:38 PM  
Boxing? Oh.
 
2022-08-11 9:11:45 PM  
I thought it was going to be about Rocket League. :(
 
2022-08-11 9:50:25 PM  
external-preview.redd.itView Full Size
 
BBH
2022-08-11 10:20:31 PM  
Hockey in the summer?
 
2022-08-11 10:22:57 PM  

WoodyHayes: I thought it was going to be about Rocket League. :(


i started playing a little over a year ago. real fun game.
 
2022-08-11 10:31:08 PM  
Fark user imageView Full Size


As someone who both really likes baseball and actually enjoys working with Excel, I'm giving Subby a bit of a side-eye with this one because it's difficult to tell just how facetious you're being about both.

/spreadsheet from when I did play-by-play for a baseball team and set up a heckova lot of VLOOKUPs to make prep a lot faster
//geek and proud
///geek, not nerd -- have never watched a Star Wars or Star Trek movie or episode all the way through
 
2022-08-11 10:33:05 PM  
Yeah, "a real sport"...

Fark user imageView Full Size


Finely crafted athletes. I bet that one chick is kinda frumpy hot too...like a shot-puter.

"Seven men, fingers aching, look to unplug the one woman who plays games with them. The one that could decapitate any of them. She'd snap their necks as easily as she opens a liter of Code Red Mountain Dew"
 
2022-08-11 10:35:59 PM  

Hyjamon: WoodyHayes: I thought it was going to be about Rocket League. :(

i started playing a little over a year ago. real fun game.


Oh it is an absolute blast, one of the better bangs for your bucks out there even before it was free. I've been playing for seven years and I still suck and still come absolutely nowhere close to making contact on every single attempt when flying. Big fan of the hockey mode because it levels the playing field for unskilled goobers like me.

I thought it might have been about Rocket League because I chanced upon some sort of tourney on Twitch the other day, there were over 100,000 people watching. Just looked it up and I guess the title game will be broadcast on Sunday.
 
2022-08-11 10:46:05 PM  
Fark user imageView Full Size
 
2022-08-11 10:56:40 PM  

WoodyHayes: Hyjamon: WoodyHayes: I thought it was going to be about Rocket League. :(

i started playing a little over a year ago. real fun game.

Oh it is an absolute blast, one of the better bangs for your bucks out there even before it was free. I've been playing for seven years and I still suck and still come absolutely nowhere close to making contact on every single attempt when flying. Big fan of the hockey mode because it levels the playing field for unskilled goobers like me.

I thought it might have been about Rocket League because I chanced upon some sort of tourney on Twitch the other day, there were over 100,000 people watching. Just looked it up and I guess the title game will be broadcast on Sunday.


yea, i started when it became free to play.  I float at the gold/plat levels.  getting much better at hitting aerials.  My problems are teammates that cluster and cannot understand the concept of passing.  I focused on jumping and hitting via goalie, then moved the skills to jumping at clears I hit.

one thing that helped my flying was having roll left on the Left button and roll right on the Right button
 
2022-08-11 11:05:25 PM  

Pfighting Polish: [Fark user image 850x397]

As someone who both really likes baseball and actually enjoys working with Excel, I'm giving Subby a bit of a side-eye with this one because it's difficult to tell just how facetious you're being about both.

/spreadsheet from when I did play-by-play for a baseball team and set up a heckova lot of VLOOKUPs to make prep a lot faster
//geek and proud
///geek, not nerd -- have never watched a Star Wars or Star Trek movie or episode all the way through


see, I have no idea if I am an expert in excel or not.  I have written scripts in VBA to preprocess data for an excel report, Xlookups, chained functions, can create custom functions, know cell references, both kinds $R4, filters, keyboard shortcuts, etc.

one part why I don't think I am an expert because I see other complex sheets like these and think I am an idiot.  I would have to lookup a lot of things to replicate it.

yet my tech-adverse coworker just learned had to add a filter to a sheet, and everyone thinks she is some excel data wizard now.

I have others that use excel for grade books but do not use formulas to calculate averages and grades. they do it by hand. why? I know they are too dumb too copypaste as values to hide any formulas and the curves they applied.
 
2022-08-11 11:22:37 PM  

WoodyHayes: I thought it was going to be about Rocket League. :(


I'm working some championship for that tomorrow and Sunday at the arena here in town. Never heard of it. 🤷‍♂
 
2022-08-11 11:54:48 PM  

WoodyHayes: I thought it was going to be about Rocket League. :(


I spent hundreds of hours playing car soccer but they changed it up and demanded I signup online with personal info and I avoid that when I can. not many people are good at protecting data and game companies are always targets so I yeeted.
 
2022-08-11 11:57:55 PM  

Pfighting Polish: [Fark user image 850x397]

As someone who both really likes baseball and actually enjoys working with Excel, I'm giving Subby a bit of a side-eye with this one because it's difficult to tell just how facetious you're being about both.

/spreadsheet from when I did play-by-play for a baseball team and set up a heckova lot of VLOOKUPs to make prep a lot faster
//geek and proud
///geek, not nerd -- have never watched a Star Wars or Star Trek movie or episode all the way through


get a brain MOR-man
 
2022-08-12 12:50:04 AM  
So there are people even more nerdy about Excel than me?  Huh.

/next month I'm giving approximately my 20th presentation on how to use Excel in my professional field
/sadly, it's about how to learn PowerBI by using Excel formulas.  The world is moving on...
 
2022-08-12 1:15:05 AM  

Hyjamon: see, I have no idea if I am an expert in excel or not.  I have written scripts in VBA to preprocess data for an excel report, Xlookups, chained functions, can create custom functions, know cell references, both kinds $R4, filters, keyboard shortcuts, etc.

one part why I don't think I am an expert because I see other complex sheets like these and think I am an idiot.  I would have to lookup a lot of things to replicate it.

yet my tech-adverse coworker just learned had to add a filter to a sheet, and everyone thinks she is some excel data wizard now.

I have others that use excel for grade books but do not use formulas to calculate averages and grades. they do it by hand. why? I know they are too dumb too copypaste as values to hide any formulas and the curves they applied.


Honestly, I can't even do all the stuff you described, and my day job is working with databases that produce Excel reports. Granted, Excel is a diverse-enough tool that you could easily make a career out of just living in parts of it.

Compared to the average working schmoe, if you can do just some of the things you described - write VBA, chain functions, do well with cell references and so on  - you can probably be considered to have Excel expertise at most places. Remember, you're being measured against salespeople who probably couldn't write a SUM function. Just being able to do SUMIF puts you ahead of the game, much less lookups and whatnot.

Honestly, that sheet I showed is as much about formatting and design as it is technical stuff.

1. The headers, inclusive of the records, I just update manually.

2. The players' positions (column C) are based off a lookup table based off their scorebook positions (light gray, column A) where 2-->C, 3-->1B and so on. If players swap positions or something, I just change it in column A.

3. I enter the players' numbers in the lineup and the rest populates from lookups:

3a. The first & last names come from a place where I copy-paste the team roster in. I do go into the roster and add the phonetic pronunciations. The roster is always in the same format for every team on the team website.

3b. Same goes for the players' information, including hometown, college, height, weight, etc. Some of it uses VLOOKUPs in concert with CONCAT or IF tests. IF a player's "inches" value for height is 0, for instance, only put out their feet height concatenated with "-foot." (See the third batter, Brett Sidall.) Otherwise, put out a concatenation of their feet height, "-foot-" and their inch height.

3c. For the college, I have a concatenation formula that puts the player's first and last name and college into a Google search URL hyperlink. So if the game is boring, I click on that link, the first result is the player's college bio, and I can click through to say, "Blake Butler is the son of Chris and Karen Butler and participated in Urban Ministries as well as mission trips to Memphis and Honduras." A heck of a lot easier than spending hours looking all that stuff up and writing it down.

4. All the rest of the stats are also just lookups, based on the players' number, and a tab where I copy-paste the team's individual stats from the league's website. You just have to do a quick check to make sure there haven't been duplicate player numbers during the season or anything (which you can do, in part, with conditional formatting on the tab you paste the stats to).

5. The results from the Aug. 4 game, again, go off a lookup based on the format the league uses for the box score on their website. Just lookups and fancy concatenation.

6. The defensive diagram is just lookups from the other team's lineup sheet in terms of the positions, names and the stat sheet in terms of the number of errors the player shown has committed on the season, again, with some concatenation. Sub a player on the other sheet, it changes dynamically on the defensive chart. And why not use the cell background colors to make it look like a baseball diamond? Similar for the "runner" slots, though there, the number in parentheses is their season stolen base count.

And ... yeah. Some of it is just taking the time to do it and debug weird things you come up. Or, just saying, "You know, it would be nice if it did ______," then taking the time to assemble the formulas and make sure they don't break what you already have in place.

There's a computational principle if you test to make sure something works for 0, 1, and x+1 occurrences, it should work for all instances. Master LEFT, RIGHT, CONCAT, FIND, LEN, VLOOKUP, IF and conditional formatting you'd be surprised just how much you can automate if you use them in concert. And you know even more than that, soooo ...

... yeah, consider yourself an expert, unless you work in some sort of accounting firm of Excel grandmasters or something.
 
2022-08-12 6:57:02 AM  
Fark user imageView Full Size
 
2022-08-12 7:19:58 AM  
Meh, bring back Magic: the Gathering.
 
2022-08-12 7:33:41 AM  

Pfighting Polish: Remember, you're being measured against salespeople who probably couldn't write a SUM function. Just being able to do SUMIF puts you ahead of the game, much less lookups and whatnot.


I worked up a pricing spreadsheet for a project the other day, gave it back to actual pricer for review. She is a self-professed excel nerd and wanted to add tables to total up the number of full-time people, but hard coded the values (that is, not linking them to the worksheets where all the data sat, just totaled up the bodies and dropped a "=14/52" in the summary tab). When I got it back, I rebuilt her tables to use SUMIFs so that I could move hours around and see the effects. Sent it back, and had 3 people on the team compliment my "magic" spreadsheet.

I rode that high for two days.
 
2022-08-12 12:33:16 PM  
ESPN 2 had some Minecraft competition on last week.
 
2022-08-12 2:47:56 PM  

Where wolf: She is a self-professed excel nerd


Dear Penthouse Forums, I never thought this would happen to me, but...
 
2022-08-12 8:30:51 PM  

Pfighting Polish: 3c. For the college, I have a concatenation formula that puts the player's first and last name and college into a Google search URL hyperlink. So if the game is boring, I click on that link, the first result is the player's college bio, and I can click through to say, "Blake Butler is the son of Chris and Karen Butler and participated in Urban Ministries as well as mission trips to Memphis and Honduras." A heck of a lot easier than spending hours looking all that stuff up and writing it down.


thanks for the vote of confidence and this part is awesome.

I am always amazed at the color commentators and how they ramble off random facts like that.

"Todays pitcher is Tom Somebody, who grew up not to far from here in the town of localsville and pitched in the state championship in 2005."
 
2022-08-12 8:45:16 PM  

Hyjamon: I am always amazed at the color commentators and how they ramble off random facts like that.

"Todays pitcher is Tom Somebody, who grew up not to far from here in the town of localsville and pitched in the state championship in 2005."


I work with one guy who still does it all the old-school way, writing down notes on each player before each game in the equivalent of size-6 font and in penmanship only he can read. Thing is, he doesn't/didn't have a day job, while I do (working with college fundraising databases while doing sports media work as a freelancer on the side). I don't have time to find all those facts.

It's all about two things:

1. Working smarter, not harder
2. Putting in more work ahead of time, designing a sheet like that, so that I do far less work day-to-day

A little brainpower up front makes the work going forward all that much easier.

Also, university Sports Information Directors are truly some of the hardest-working, most underappreciated people out there. They spend all kinds of time away from the stadium/arena gathering that info and doing the technical website work to get it online. They often manage teams' social media channels. They're often the first to come to and the last to leave games. At games, they're tasked with being the technical geniuses who coordinate everything from the in-game stat tabulating software to, at smaller institutions, the streaming broadcast, in addition to often being the ones doing the stat data entry. And yet, they're usually the lowest-paid people in athletics. They have to work insane hours and a stupid-crazy number of weekends. And, for all their effort, they also routinely get crapped on by coaches, players, players' parents and fans who feel little Johnny and the tennis team aren't being publicized enough, or little Julie on the softball team is getting screwed out of a scholarship because the SID called that easy grounder she bobbled an error instead of a hit.

So yeah, if you know an SID, buy him or her a coffee sometime and say thanks. They're hard-working folks and they do so much to help make the sports experience better for everyone.
 
2022-08-12 9:03:00 PM  

Pfighting Polish: At games, they're tasked with being the technical geniuses who coordinate everything from the in-game stat tabulating software to, at smaller institutions, the streaming broadcast, in addition to often being the ones doing the stat data entry.


that is one part that I really enjoy about baseball and sports, finding those fun things in data and stats.  I notice it in game broadcasts a lot.

*slow or dead air*

announcer: "Today is also the starting pitchers birthday, we wish him a happy birthday from the booth and hopefully a win for him today."

*a few minutes go by*

announcer: "Welcome back from the break, the birthday boy is still on the mound. Did you know that only seven pitchers have actually been starting pitchers on their birthday.  Turns out they all won when they pitched on their birthday except [player name]. Here are a few..[lists names of players]...some of those are in the hall of fame, so he is in good company if he can irk out a win today.  Here's the pitch, 2-1 is now the count."

I imagine during the break someone is pulling a query back in the studio of starting pitcher birthdays and the dates of the games they started and throwing together a quick graphic or list.
 
2022-08-12 10:37:23 PM  

Hyjamon: that is one part that I really enjoy about baseball and sports, finding those fun things in data and stats.  I notice it in game broadcasts a lot.

*slow or dead air*

announcer: "Today is also the starting pitchers birthday, we wish him a happy birthday from the booth and hopefully a win for him today."

*a few minutes go by*

announcer: "Welcome back from the break, the birthday boy is still on the mound. Did you know that only seven pitchers have actually been starting pitchers on their birthday.  Turns out they all won when they pitched on their birthday except [player name]. Here are a few..[lists names of players]...some of those are in the hall of fame, so he is in good company if he can irk out a win today.  Here's the pitch, 2-1 is now the count."

I imagine during the break someone is pulling a query back in the studio of starting pitcher birthdays and the dates of the games they started and throwing together a quick graphic or list.


When I did high school football, I had a spotter/statistician/producer who was spectacular at that stuff. He was more key to the broadcast than I was as the on-air guy.

I'm not a big Joe Buck or Troy Aikman guy, but I always point people to this piece on their support staff as a great behind-the-scenes glimpse into what all goes into making an NFL broadcast look and sound so flippin' good.
 
Displayed 25 of 25 comments

View Voting Results: Smartest and Funniest

This thread is closed to new comments.

Continue Farking




On Twitter


  1. Links are submitted by members of the Fark community.

  2. When community members submit a link, they also write a custom headline for the story.

  3. Other Farkers comment on the links. This is the number of comments. Click here to read them.

  4. Click here to submit a link.