We Entered the World of Microsoft Excel eSports & Got Our Asses Beat 

This makes me want to see the template !

I recently Made a spreadsheet to calculate pokemon battles and stats and played a pokemon rpg in it with my friendgroup, also using spreadsheets as battle and dungeon maps

Where there's a will there's a way xD

Grorgar, B4, to E4. Whhhaaaaaag

As a guy working on google sheets daily, I can say they have a surprising amount of functionality. You can make a lot of stuff by using them.

The "e" is reaaaaally doing all the heavy lifting in "e-sports" in this case.

excel sports

@@Camilo_Z it's in the game

It shouldn't

'Excel as a sport' seems to be more of a math/statistics speedrun mixed with a coding competition, rather than a computer game in the traditional sense. It technically is a fast-paced competitive multiplayer game that is played on a computer, but it's not what most of us think of when we imagine "e-sports".

16:45 is the look of "I get to edit those dorks."

​​@@jcchurch they did a damn good job. Loved the little bits with Quinns on the spreadsheet.

“Nerds. Awww”

I was the 1,000th like :)

I shout excitedly about getting Excel to work quite often. I now want to try one of those competitions.

thats such a fun anecdote!

Omg I've been thinking of a forensic accounting game for ages and this is a really good format for it!

​@@CreatrixTiara I would play that game

Fun fact, computers have existed for thousands of years! One of the oldest was found in Greece over a century BC. And for the more modern ones there was a real boom in the 30s and 40s with the first electromechanical programmable computers, and later fully digital electronic computers (see Colossus, ENIAC, Konrad Zuse) which more directly led to the computers of today.

​@@LutraLovegood Until 70 years ago most references to computers were people, as in the people who compute. They were also usually women. You are largely thinking of calculators, which could be augmented devices or people as well.

Anni will be very pleased you noticed that!

It’s not often that I like a video before I’ve completely watched it or click away, but this was definitely one of the times I liked midway through

I have no idea what this means.

​@@scbtripwire light reflects from the environment onto the subject. When using greenscreen, this can cast green light onto the subject even if they're in, for example, a red room

@@scbtripwire I believe they're referring to how the same object will look different under different lighting. So an object in bright sunlight will appear bright with well-defined colors, while an object in a dimly-lit meeting room will be dimmer and washed-out. So if you copy-paste a video of Quinns into a scene without appropriately adjusting how vibrant the colors and lighting are, he'll look out of place. Or at least, more out of place. :D

The competitive time constraint really gets that representation when your manager gives you a problem that you have to solve before the QBR in the next 1 hour.

This video I find somewhat funny because I remember watching a channel "Krazam" do a parody/satirical video on this exact concept. Never would have thought this to actually be a thing, but it makes sense honestly.

It took me two days to write 20 lines of code to parse json into a sheet, I couldn't imagine doing anything in 30 minutes.

They made a competition out of the shit that gets dropped in my lap a work. 😂

When you procrastinated for far too long and have to speedrun everything within a day…

There's no greater feeling than writing your code, clicking run for the first time, and seeing every single correct answer flash up before you. A feeling like you've just parted the red sea

yep this is a big part of the satisfaction you can get from even the most dull, uncreative programming. here, the programmer can't design the thing they're modeling, nor can they even design the questions / scenarios they want to give to that model. but there's still some catharsis to creating that model and feeling some kind of dominion over the problem; making some new kind of ergonomic and efficient tool for a new kind of problem (no matter how specific or confected that problem is). it's closer to playing a puzzle game than it is to creative writing, but those very limiting constraints can be really fun to work against.

Absolutely. I feel in love with my programming course when I made a program that listed every prime number from x to y. Seeing that the computer spit a list of 100s of entries in a second, a process that would take me at least 20 minutes, was magical.

I am a programmer who has to fix companies whose whole business is built on 20 year old excel spreadsheets full of the worst VBA you have ever seen, so this video gives me anxiety.

Yeah, this is pretty much like hackerrank but excel version

We know you read this comment Quinn, we're waiting for an answer.

The most likely, and boring, answer is to get alcohol before you're of legal age to purchase it. But I'm pretty sure Quinns got their fake ID to participate in sketchy, back-alley, black-market, underground boardgame tournaments in Cuba.

@@skulver Ah. That does make a lot of sense

I love when he showed Chris that caster's view and motivation on excel and he said excel was more violent than he thought it was

Also the behind the scenes at the end showing the stool with green paper wrapped around it lmao

I'm not sure "it's _just_ a matrix multiplication" is a real thing people are allowed to say 😭

Same :)

Yeah, and claiming that Kurtosis measures skewness! Surely it measures kurtosis and Skewness measures skewness? Ha ha ha ha.

@@dominateeye what do you mean? its just 11th grade maths right? I feel like majority of the people should know this even if they didnt do maths

@@landsgevaer oh my god those words give me nightmares. I hate stats with a passion and those terms scared me so much that i never touched them until finals. Then I learnt I was scared for the dumbest stuff. Its just daunting words.

You could say they really exceled themselves this time

@@AlexBloggFilm You get a cookie for that pun.

I second this

Now I'm just imagining his animated form jumping from cell to cell resizing things as he scrambles through your sheet like its a jungle gym.

I propose the name Quippy!

@@hdruk1 OHHH YOU GENIUS!!!

How did I know I'd see you here

Holy crap. That's amazing!

I was amused to see the game devs appeared to actually be using Google Sheets, but same idea

Eve Online AKA Spreadsheets Online. That game is like working a second job but you're unpaid.

@@telaferrum It's pretty common nowadays. If you've seen the docs for a fighting game it's a loooot of numbers everywhere.

I used to do this a lot too, but then I realized a lot of time, the game wiki already has these spreadsheets typed out, at least in terms of data entry if not also stuff like efficiency and resource per action.

Or better, related

Wait till this guy learns about factorio

​@@pifre3051 well some simulators

So Excel-Sports.

​@@romainsavioz5466 You mean like those roller coasters excel videos?

MMULT means matrix multiply. The way it works is by using principles of linear algebra to multiply two matrices together (order matters). There's a whole class of M_ functions with MINVERSE, MUNIT, MDETERM that all have specific mathematical meaning. Not sure how often these are used in financial modeling, but as someone in a STEM program I have to use these all pretty frequently. I've never used the KURT function, but I've heard the concept of kurtosis mentioned in a statistics class before.

​@@kathrynfroese3689 kurtosis is the 4th moment of a distribution (after mean, variance, and skewness) and is basically fatness of tails

​@@footballmint Ooh boy, we're going into 3Blue1Brown territory now.

@@acctsys Always a good time when that happens :)

@@kathrynfroese3689 had a feeling it was Matrices related when it was calculating something from multiple columns and rows. But man I wish I knew how to use excel because that would have helped me with my matrix algebra class a few semesters ago lolol

It feels a lot like basically a programming competition, just inside Excel. Especially if people are using macros.

@@telaferrum Excel is just programming for the general public on the most likely use case.

It's often hard to believe that there are people who genuinely specialize in things from the heart, rather than the opposite: believing that everyone can find enjoyment in any field, so long as they put in the work... But seeing comments like these makes it very apparent that the former is more true. I, myself, no matter how much work I put into it, do not find enjoyment in making something work - especially with games. I enjoy crafting and toying around with them, creating humorous things with them, filling them with easter eggs - but seeing everything work out masterfully doesn't fill me with joy - just a sense of "Okay, onto the next project". It really goes to show that everyone has their own specific niches in work/life.

@@mrdocena8082 Perhaps you just haven't found what truly makes you happy?

The best way to describe it, Imagine if you wrote a 4000 word essay without ever proof-reading or looking back at anything you'd already written, then at the very end you read the whole thing back and it reads perfectly fine, no notes, no changes needed. That's kind of the feeling, a lot of brain power distributed all over the place building bits and pieces, then you click a button and everything works and it reinforces the fact you DO know what you're doing sometimes

Or, you know... Secure your future by leaving NO notes, so the company has to call you in as an expensive out-sourced person, and get proper payout for your work on that "brilliant system". Remember, hard work doesn't result in high pay. probably the only way to get value out of giving your hard work to a company is to make yourselv unexpendable to them, and then you can bargain for reasonable pay.

"glorified proprietary versions of Excel spreadsheets." And with less functionality! And slower! I can't imagine how many times now I have asked in a requirements specification session for a new program that they add an "export to Excel" feature so I can actually work through the whole thing in 4 seconds with a macro.

That's something that's done in the programming world, called pair programming. Usually one if not both get a keyboard *and* a mouse, though

🥳

Not sure what Ikea furniture has to do with solving Excel...

VLOOKUP!, a weapon for a more civilized age

😭 wow the world really does have everything

I play several games which could reasonably be described as ‘spreadsheet simulators’ lol

Truly the rtw moment of all time@@CassiopeiaDream

Learning VBA is like going from presets to a full custom character builder. It unlocks so much more power within Excel, but all the guide rails are off. Well worth it, though.

That is more or less what sports climbing is, especially bouldering. And I think a reason why it was so popular with viewers in the Olympics, even though it was one of the new events. With bouldering all you know is that you will face 3 problems, aka 3 short walls you want to reach the top of. And you can get halfway points by reaching check points on a wall. And the problems could be anything, and require really different techniques and approaches Anything from hanging on one foot and like a monkey swinging into a long jump maybe 2 meters away on the wall. To holding your whole body weight by squeezing your knee against two completely vertical walls. Or it’s all about balancing on super thin holds the thickness of a coin, and it’s more about balancing your way up to the top with no big moves. You are only allowed to see the walls when it’s your time to try to climb. And they get something like 3 minutes or something in total per wall and get to try how ever many times they want. With any technique they want. So a huge part of it is just seeing the problem, which could be nothing like anything you’ve done before, and come up with a good approach you want to try and see if you can make it successfully. But also understanding when you should drop and try a new way to approach the problem. It’s pretty exciting see maybe 3 people in a row being very close but failing to reach the top. To then see someone try a similar approach once, to then do some completely out of the box weird stuff, and reach the top right away on the first try on their first attempt. And also seeing multiple different solutions to the same problem.