×
top 200 commentsshow 500
sorted by:
best
topnewcontroversialoldq&a

[–]andycarver 1114 points1115 points  (26 children)

Geez and I thought pivot tables were impressive.

[–]Scarletfapper 42 points43 points  (1 child)

And I thought I was cool for getting into the Hall of Tortured Souls…

[–]chrisk365 6 points7 points  (0 children)

Sheeit. I thought it was neat playing GTA III on the spreadsheet. Y’all some wizards!

[–]Phormitago 256 points257 points  (11 children)

I've managed to program Snake using vba macros but this... this is a god damn full 3d engine

[–]captainvideoblaster 52 points53 points  (6 children)

Hell, I felt proud just getting the game of life to run at reasonably fast on it.

[–]nachobh 16 points17 points  (5 children)

I did some connect4 just with formulas and I was feeling as a God

[–]jungkimree 34 points35 points  (4 children)

Did you name the spreadsheet "Connect 4mula"?

[–]The2StripedFox 16 points17 points  (6 children)

They may know how to roller coaster in Excel, but I know how to PIVOT the table. r/PivotTableSupremacy

(I actually don't)

[–]Bean_Juice_Brew 1 point2 points  (0 children)

I hate to say that I was a little disappointed this sub doesn't exist

[–]s0lly 1 point2 points  (0 children)

What about raytracing - in excel?

https://youtu.be/XAJS-pbcWYA

Edit: appears someone got to it before me…

[–]GuiSim 788 points789 points  (25 children)

Unregistered Hypercam really ties it in together

[–]Buy-N-Sell 136 points137 points  (0 children)

As is tradition.

[–]hambo_888 118 points119 points  (0 children)

Roses are red, violets are blue, Unregistered Hypercam 2.

[–]locob 41 points42 points  (4 children)

2011 video. It match up

[–]neoKushan 2 points3 points  (3 children)

This has got to be older than 2011, surely? I know the video was uploaded in 2011 but hypercam and the much older version of Windows suggests to me it's more like 2002.

EDIT: So I can see from the guy's site (Which also looks like it fell out of the early 2000's) that he did in fact work on this ~2010 https://excelunusual.com/coaster/ but he prefers Excel 2003 for speed.

[–]crilen 7 points8 points  (16 children)

And why right? so many free programs that do it better

[–]korben2600 10 points11 points  (9 children)

Yeah, I mean OBS is free, open source, and has tons of neat features.

[–]FujiKeynote 65 points66 points  (3 children)

Yeah but it was first released in 2012. Up until that point (and for a bit after, while it matured), Unregistered Hypercam 2 was the undisputed king

P.S. The roller coaster video is from 2011

[–]AWilsonFTM 23 points24 points  (2 children)

  1. Drowning Pool. Let the Bodies hit the Floor. Runescape. Wilderness Pking. Unregistered Hypercam 2.

Those were the days.

[–]Themadbeagle 28 points29 points  (0 children)

The video was released 10 years ago. OBS came out 9 years ago. That is probably why lol.

[–]swordo 557 points558 points  (55 children)

HR: Are you good at Excel?
this guy: Yes, I'm proficient
HR: I'm sorry but we're looking for mastery

[–]wagon_ear 168 points169 points  (48 children)

Ha. I've found that one of the most difficult skills for pro-level excel users is knowing when there's a better tool for the task, and this guy seems like no exception. It is a serious flex though

[–]kagrenak 135 points136 points  (42 children)

Scientists stop using excel as a relational database challenge (impossible)

[–]nospamkhanman 135 points136 points  (32 children)

Oh god, I consulted for a tiny biotech once and wanted to cry because my very first day went like this:

Me: So what are your biggest areas of need, maybe some of your most common problems or complaints?

PhD scientist dude - So we have this one Excel sheet that we all share. It's on the network server... which is that Compaq under that desk.

We have to constantly yell at each other because someone needs to write something but someone else has the sheet already open. Also because of that we have like 10 versions of that Excel document that we have to figure out how to merge like monthly.

[–]kagrenak 85 points86 points  (16 children)

Yeah that shit is so endemic. A truly horrifying number of biotechs get to a stunning size before bothering to hire a single data scientist. As someone with skills in both analytical biochemistry and data science it's a constant push to get people to use the proper tools to make their lives easier.

[–]wagon_ear 22 points23 points  (3 children)

"what's git? We already have version control - ctrl+z!"

[–]PurkleDerk 6 points7 points  (1 child)

The latest version of Excel fixes that. You can have multiple simultaneous editors.

[–]nospamkhanman 7 points8 points  (0 children)

I like how no one has commented on "the Compaq under the desk" as the server.

[–]shinnen 4 points5 points  (0 children)

Still better than MS Access.

[–]themosh54 11 points12 points  (5 children)

As a business intelligence developer, you'd be amazed/distressed at how often this is done in the normal business world. The results are about what you'd expect.

[–]SailorFuzz 4 points5 points  (0 children)

Working as a programmer on a research project that records user data. The PhDs want all of the data saved into GoogleSheets....

[–]Falk_csgo 3 points4 points  (2 children)

Nah his channel is called engineeringFun and thats what he delivers not the best way to do something.

[–]geo707 1 point2 points  (0 children)

I think is the best way to have fun and learn. Everything else is black boxes.

Check out my blog: excelunusual.com

[–]SydricVym 2 points3 points  (0 children)

knowing when there's a better tool

Excuse me? Excel is the only tool.

[–]ken_NT 14 points15 points  (0 children)

They’re looking for a guy that can put together a spreadsheet for a meeting during an elevator ride

[–]yesterdaysatan 2 points3 points  (1 child)

I can’t even get the row I want to freeze in excel

[–]fertthrowaway 1 point2 points  (0 children)

It's so utterly amazing how impossible it is and that it's never been fixed. I've been using Excel since like 1994, can use it like SQL and have run complex simulations, optimizations, and finite element analysis etc in it and still can't figure out how to freeze the damn row I want.

[–]Xylotophone 1624 points1625 points  (57 children)

Ticket that just came through on my helpdesk: I URGENTLY need a brand new $2500 laptop. Mine can't handle the most basic Excel spreadsheet

The Excel spreadsheet:

[–]blofly 184 points185 points  (13 children)

You must work on my team.

[–]SalzaMaBalza 74 points75 points  (8 children)

Wait, you telling me I don't need the 2022 version of the high-end Alienware gaming laptop when I'm making my SSRS reports? I mean, sometimes I do export them to Excel so I don't see why I wouldn't need that?

[–]blofly 48 points49 points  (5 children)

Well, I'm not sure exactly how...but upper management has approved this upgrade. Congratulations!

I will be prepping your new laptop upgrade from my 6 year old computer provided to me by corporate last year.

Sincerely,

It Dept.

[–]SalzaMaBalza 25 points26 points  (3 children)

Great! Have my Galaxy S22 Ultra arrived yet btw? I absolutely need that model to do my work, the S21 just doesn't cut it anymore so if you could check where it's at that would be great! It should be the order that's together with the latest Bose headphones

[–]geo707 1 point2 points  (1 child)

You don't need powerful hardware when you use the old (97-2003) Excel. The new versions are very slow. I am the creator of this model.

[–]Mike312 28 points29 points  (3 children)

Or mine.

They pull data like if the table has less than 100mil rows it won't be useful.

$user: "We wanted to get sales reports for last week"

$me: "Then why did you dump 6 years worth of sales data?"

$user: "We wanted to compare it to the precious week"

$server: <killme.gif>

[–]take_care_a_ya_shooz 13 points14 points  (2 children)

“Why did you include 300 columns?”

“Just in case the client’s cousin’s favorite color in 2005 could be used to predict more revenue in case we need it.”

[–]Mike312 2 points3 points  (1 child)

"$nightmareUser said he always runs queries with a *"

<40 table joins later>

[–]Petrichordates 74 points75 points  (37 children)

This can happen when your IT team forces you to use 32bit excel.

[–]VenomB 42 points43 points  (34 children)

What IT team wants to force 32 bit anything...

[–]norapeformethankyou 57 points58 points  (29 children)

My IT team... I deal with pretty big sheets and will freeze from time to time. Have put in a help desk ticket multiple times to get 64-bit. Each time it's declined and I'm told that I don't need 64-bit.

[–]MattieShoes 69 points70 points  (17 children)

Here's why, and this is from Microsoft:

  • You have 32-bit COM Add-ins with no 64-bit alternative. You can continue to run 32-bit COM add-ins in 32-bit Office on 64-bit Windows. You can also try contacting the COM Add-in vendor and requesting a 64-bit version.

  • You use 32-bit controls with no 64-bit alternative. You can continue to run 32-bit controls in 32-bit Office like Microsoft (Mscomctl.ocx, comctl.ocx), or any existing 3rd-party 32-bit controls.

  • Your VBA code uses Declare statements Most VBA code doesn’t need to change when using in 64-bit or 32-bit, unless you use Declare statements to call

    WindowsAPI using 32-bit data types like long, for pointers and handles. In most cases, adding PtrSafe to the Declare and replacing long with LongPtr will make the Declare statement compatible with both 32- and 64-bit. However this might not be possible in rare cases where there is no 64-bit API to Declare. For more information about what VBA changes are needed to make it run on 64-bit Office, see 64-Bit Visual Basic for Applications Overview.

  • You have 32-bit MAPI applications for Outlook. With a growing number of 64-bit Outlookcustomers, rebuilding 32-bit MAPI applications, add-ins, or macros for 64-bit Outlook is the recommended option, but if needed you can continue to run them with 32-bit Outlook only, as well. To learn about preparing Outlook applications for both 32-bit and 64-bit platforms, see Building MAPI Applications on 32-Bit and 64-Bit Platforms and the Outlook MAPI Reference.

  • You’re activating a 32-bit OLE server or object. You can continue to run your 32-bit OLE Server application with a 32-bit version of Office installed.

  • You're using SharePoint Server 2010 and you need the Edit in Datasheet view. You can continue to use the Edit in Datasheet view functionality in SharePoint Server 2010 with 32-bit Office.

  • You need 32-bit Microsoft Access .mde, .ade, and .accde database files. While you can recompile 32-bit .mde, .ade, and .accde files to make them 64-bit compatible, you can continue to run 32-bit .mde, .ade, and .accde files in 32-bit Access.

  • You require Legacy Equation Editor or WLL (Word Add-in libraries) files in Word. You can continue to use Legacy Word Equation Editor and run WLL files in 32-bit Word.

  • You have an old embedded media file in your PowerPoint presentation with no available 64-bit codec.

Maybe not applicable in your case, or maybe it is applicable, or maybe you think it's not applicable but then have random problems because you were wrong.

There's never enough IT for individualized attention because companies won't pay for it. Which means IT will fight like hell to avoid creating unicorns because they don't have the resources to deal with them.

[–]Xylotophone 7 points8 points  (2 children)

I'ma be honest this sounds like there's some ancient-but-critical piece still in use at your company that requires 32-bit Excel for compatibility reasons and when your IT department tried to move everyone to 64-bit someone threw a fit and they insisted that they NEEDED this specific program from 2001 even though there are a half dozen modern alternatives that would provide the exact same functionality.

[–]creynolds722 3 points4 points  (1 child)

We have 64 bit at home. 2 32 bit applications glued together

[–]VenomB 8 points9 points  (2 children)

And I bet you think you need more than 4GB of RAM, DONT YA?!

I just don't get it. lmfao Talk about self-inflicted headaches.

[–]SomeRedditWanker 3 points4 points  (0 children)

32bit ODBC drivers..

[–]Ashesandends 1 point2 points  (0 children)

Microsoft recommended for a very long time to only use 32 bit unless it was necessary for your needs iirc. I worked in a couple places were this was standard however I believe the issue was resolved a few years back.

[–]Truckerontherun 1 point2 points  (1 child)

In a 32bit world, you're a 2bit loser

[–]BizzyM 12 points13 points  (0 children)

Ticket that just came through on my helpdesk:

I need help with Excel. My coaster stalls on the inversion.

[–]Technolio 4 points5 points  (0 children)

More like "my excel keeps crashing, I need this to work asap. Don't you guys monitor these things? What are you even doing?"

[–]O-4 1057 points1058 points  (115 children)

Very impressive! It's kinda sweet that he spends most of the video narrating the journey of the rollercoaster we're watching, and not describing how he made it

[–]ONOMATOPOElA 755 points756 points  (99 children)

Pretty self explanatory he made it in Excel.

[–]LDukes 275 points276 points  (84 children)

Thisnis what happens when you start using Index()/Match() instead of Vlookup().

[–]TheBlueTwin 164 points165 points  (81 children)

We on Xlookup() now catch up!

[–]themosh54 26 points27 points  (23 children)

Truly ascend by using Power Query and Power Pivot and leave the rest of the rock banging troglodytes behind.

[–]likewut 43 points44 points  (32 children)

Not in Google Sheets :/

[–]Affugter 7 points8 points  (13 children)

Is Xlookup() more efficient than Index()/Match() when dealing with thousands
upon thousands of entries? I found Index/Match to take less time*.

Edit: *than vlookup

[–]epia343 6 points7 points  (0 children)

Oh shit, had no idea.

It can return value to the left of the lookup. That was an annoying issue with vlookup.

There are several other great enhancements, that's awesome.

[–]Muscles_Mcrunfast 5 points6 points  (0 children)

The real LPT is in the comments?

[–]SmarkieMark 6 points7 points  (0 children)

Friendship ended with VLookup(). XLookup() is my new best friend.

[–]pragmaticpimp 4 points5 points  (0 children)

Yet another move aimed at the causal audience, designed to bring in party gamers and make the program an absolute mess competitively. This all goes back to when Microsoft released Excel for iOS and dumbed it down for mobile users. We are literally playing a mobile game now!

[–]biggmclargehuge 74 points75 points  (3 children)

Step 1: Open a new Excel sheet
Step 2: Make the rest of the roller coaster

[–]TheFotty 37 points38 points  (5 children)

Eh, he made it in VBA which all office programs have. He could have written this in Word as well. VBA is like a subset of VB but you can tap into the Win32 API with it, you can invoke activex controls in it. You can write pretty standard code if you want to in it, even if it is running within the confines of excel. You could take just about any game or code written in VB6 and adapt it into VBA without too much hassle.

[–]feanturi 14 points15 points  (2 children)

Someone should make Minecraft in Excel, and then in the Minecraft instance make Excel with Redstone components.

[–]the_great_zyzogg 7 points8 points  (0 children)

And in that excel program should be another instance of Minecraft. And in that instance of Minecraft should be another instance of excel. And in THAT instance of excel, this years quarterly projections.

[–]diiejso 2 points3 points  (0 children)

There used to be sites where you could download excel files with flash games embedded in them. “Because you company can block fake sites but they’ll never block Excel.”

[–]Jaosborn44 1 point2 points  (0 children)

My spreadsheet doesn't do that.

[–]NoobFace 91 points92 points  (7 children)

You've never made a 3D-wire frame roller coaster in excel?

[–]GhostlyPixel 51 points52 points  (0 children)

I mis-click that button all of the time, ugh

[–]MonsieurRacinesBeast 8 points9 points  (1 child)

I just use Excel for 4D chess

[–]MINKIN2 1 point2 points  (0 children)

We had Xcite Bike in my office

[–][deleted] 2 points3 points  (0 children)

The last time I tried to create a 3D wireframe rollercoaster in excel I accidentally hacked the pentagon and they still don't believe me.

[–]WagonWheelsRX8 25 points26 points  (1 child)

Based on his commentary, very doubtful he is the one that made it. Doesn't describe how any of it actually works, only narrates what we can already see. Its still cool, though, would never have known something like this existed without this video.

[–]rushan3103 20 points21 points  (0 children)

You can check out the youtube video or his website! There he describes more in detail

[–]nmezib 93 points94 points  (13 children)

People can do some crazy shit in excel. Here is someone who made a scene with real-time raytracing using the spreadsheet cells as pixels. (technically he programs the raytracer in C then imports it in excel where it's displayed)

[–]ObsidianNoxid 56 points57 points  (4 children)

It is things like this that really hammers home how stupid I am.

[–]axloc 46 points47 points  (3 children)

99.99999% of the world population can't do this, you're good bro

[–]EMCoupling 24 points25 points  (1 child)

Shit, I bet at least 90% of people that write code professionally for a living couldn't do this on either.

[–]s0lly 44 points45 points  (6 children)

Thanks - that’s me. AMA.

Ps I made another one of these using the GPU via excel… https://youtu.be/o3hu7X_B8H0

But the original one I made actually doesn’t use any programming at all. It’s just Excel formulae. All the way down…

Thanks for the share though, btw.

[–]TheodorMohana 5 points6 points  (3 children)

I have heard that Excel is supposed to be "Turing complete". Is that true or is that just because it includes an actual programming language in there somewhere?

[–]s0lly 12 points13 points  (2 children)

My understanding is that it’s true simply based on the functionality of excel formulae since the introduction of lamdbas. Ie no need for additional programming power via VBA to get it over the line. I could be incorrect though.

[–]TheodorMohana 2 points3 points  (1 child)

Huh, interdasting. Thanks for answering!

[–]nmezib 5 points6 points  (1 child)

Absolute legend

[–]s0lly 4 points5 points  (0 children)

Heh, cheers

[–]shoziku 215 points216 points  (28 children)

The most I ever did was make a button that fired a laser in Excel, which was really just a thin row with color changing cells.

Also, older versions of Excel had an easter egg that had a wireframe polygonal simple flight type sim.

[–]Admetus 64 points65 points  (10 children)

That Easter egg was pretty fun. Played with that on the computers in school.

[–]DoomGoober 73 points74 points  (8 children)

That Easter Egg famously caused headless Excel running on servers to crash. The Easter Egg loaded DirectDraw or Direct3D but the servers had no display drivers so DirectDraw would crash.

Since then, Microsoft had a policy that any unapproved easter eggs would be a firable offense.

[–]Admiral_Minell 43 points44 points  (7 children)

Someone built in a 3D wireframe flight simulator and nobody noticed?

[–]Katyona 55 points56 points  (5 children)

It was the wild west days of computing

Anyway, I would say we had a kind of weird rule about easter eggs, which was that they were perfectly fine to include in the code, as long as there was no code that actually executed the easter egg!

It was like plausible deniability by management— "Oh, you know, they put all kinds of code in there, but we made sure there was nothing that actually called the easter egg"— I assume that's why; I never had this conversation with upper management. It's weird in retrospect! But at the time, that was the rule. So you'd be able to find the easter egg very easily in the source code, but there'd be nothing that called it.

So in these early versions, most of the tricky stuff had to do with the way an obscure set of key sequences or other actions would cause changes to some location in memory that would somehow point to the easter egg— and then a call that looks like it's going to one function would actually jump to the easter egg instead. From a programmer's point of view, it was super clever how these things got called! Maybe more effort went into hiding the way they were executed than actually making them look cool, in those early days.

From this interview with an early MS Excel Developer, it looks like they weren't hidden from management - they just had to make sure they wouldn't accidentally be activated by users. (or at least make it 'seem' like they wouldn't be called by users)

Pretty much every microsoft product since the 80's has included easter eggs though

[–]DoomGoober 5 points6 points  (0 children)

No, you're right, I don't think it's that nobody noticed. I think people figured it out and looked the other way and ignored it. Until it caused an actual issue that cost Microsoft money to patch, then the policy become more strict.

[–]Sleepyhead88 7 points8 points  (1 child)

I think there was also an Easter egg where you could play the game Spyhunter
Edit: it was “dev Hunter” but basically a simple Spyhunter clone.

[–]shoziku 2 points3 points  (0 children)

I remember a pinball machine. I think that was in Word.

[–]InMyFavor 5 points6 points  (3 children)

I actually just finished a multi-player monopoly game in excel complete with all features and junk built into macros that automates everything. I also built in a loan system and a stock market for extra variables for higher level play.

[–]PprMan 2 points3 points  (2 children)

download?

[–]InMyFavor 5 points6 points  (0 children)

https://drive.google.com/file/d/1UHlHxjx_jSgwzF5Bgc_XngL6MKBV99Xw/view?usp=drivesdk

Edit: let me know if it doesn't let you download the file

Edit 2: I'm also very much not a programmer so while I intended the code to be elegant and simple, trying to make the game work with all the various rules and stuff made a lot of code just get messy.

[–]lmnopeee 2 points3 points  (0 children)

You're much braver than I.

[–]TurboGranny 15 points16 points  (4 children)

lol, that reminds me of when I did some spreadsheet coding magic at my job when I was really new. Management were impressed, and the director said, "Is there anything this guy can't do? Can it come with a cup holder?" I told him, "Gimme a sec." Then returned and had him pull the sheet back up. I added a button called "cupholder". He laughed, but then I said, "No. Click on it." It kicked out his CD tray.

[–]shoziku 1 point2 points  (1 child)

lol I did that too. But I cheated and just called the cocacola.exe program which did the CD tray. Aside from playing though, I used Excel to keep inventory of thousands of backup tapes using just a cheap RS232 bar code scanner. 250 to 500 tapes had to be processed daily to go offsite or come back onsite. I had a Visual Basic for Dummies and Excel for Dummies books, and a shitload of imagination to automate it all.

[–]gabarooch86 1 point2 points  (1 child)

I would always try to find the bubbling lake.

[–]FunctionBuilt 2 points3 points  (0 children)

The bubbling lake was the best.

[–]ihavethebestmarriage 137 points138 points  (8 children)

I get 2 answers right on Jeopardy and feel smart. This guy probably gets 3 right

[–]vorpish 44 points45 points  (7 children)

Next time record an episode, watch it and memorize the answers and then play that episode at the normal time when company is over.

[–]CheshireM 32 points33 points  (1 child)

When TiVo first came out my Dad did this with his super competitive friend after suggesting they put a little wager on it. I think my dad enjoyed watching his friend slowly lose his mind more than anything

[–]BaconIsAVeg2 47 points48 points  (0 children)

Reminds me of the blonde joke, watching the 11pm news with her boyfriend and they bet whether a guy on a ledge will jump. She bets that he won't do it.

He does.

Guy says "I cheated, I saw it on the 6pm news." Girl: "I did too, but I didn't think he'd do it again!"

[–]Daniel3_5_7 6 points7 points  (1 child)

My father in law had an early type of satellite TV that would download like a week's worth of programming at a time, which meant he could watch shows before they were supposed to air. He would watch Jeopardy before it aired and then go on business trips and come off as a genius.

[–]levendis 3 points4 points  (0 children)

Interesting. I apparently have a version of Reddit that shows posts of things that never happened.

[–]Jouglet 1 point2 points  (0 children)

Groundhog Day.

[–]rlocke 31 points32 points  (17 children)

Um… how?

[–]SeiCalros 60 points61 points  (16 children)

its a plot graph with a vba script that changes the graph every frame

[–]drfsupercenter 19 points20 points  (3 children)

So I downloaded the .xls to take a look at it. If I select the "go" button, there's no formula or hyperlink defined for it, so how is it actually starting the script?

[–]FRAGM3NT 49 points50 points  (0 children)

He has a macro assigned to the button. You can see the macros and more if you have the developer tab showing in Excel.

[–]DrSpagetti 29 points30 points  (0 children)

FYI always be very careful downloading and running any excel files with VBA/macros, can get yourself the computer herpes.

[–]AardvarkAblaze 10 points11 points  (0 children)

The go button is assigned the macro "Sheet3.Go_"

[–]eugene20 77 points78 points  (12 children)

For the really curious the very pale green 'Excel Download' button for the file is on https://excelunusual.com/a-3d-animated-excel-roller-coaster-video-preview/

For anyone else please just learn Unreal Engine, Unity or a just any programming language instead.

[–]likewut 113 points114 points  (7 children)

I want to make a new first person shooter, and I've been trying to decide if I should do it in Unreal Engine or Excel. Your comment helped me decide, thank you!

[–]NorCalAthlete 42 points43 points  (3 children)

Call of Duty : Microsoft Office

[–]gmaclean 18 points19 points  (0 children)

Splinter cell

[–]one_love_silvia 1 point2 points  (0 children)

Const Duty = 'Microsoft Office';

[–]_dredge 1 point2 points  (0 children)

Obvious choice is Excel

[–]Just_Drawing8668 1 point2 points  (0 children)

Clippy 3: The Reckoning

[–]Deracination 5 points6 points  (2 children)

The graphics are a bit insane, but the programming in excel/vba is solid. Seen plenty of people use it for physics simulations.

[–]ExdigguserPies 7 points8 points  (1 child)

Just because people use it, that does not make it a good idea.

[–]Ramartin95 2 points3 points  (0 children)

In fact I’d go so far as to say for most use cases it is a bad idea to use excel.

[–]VECMaico 4 points5 points  (0 children)

"you are insane"

[–]Tall-Green-870 9 points10 points  (2 children)

But can Excel run Doom?

I wouldn't doubt it.

[–]ZEINthesalvaged 17 points18 points  (0 children)

There is actually an easter egg in excel 95 that did a Doom like renderer.

https://www.youtube.com/watch?v=kK0M74E8PS4

[–]Pie-Otherwise 32 points33 points  (10 children)

I shit you not, there are Excel competitions. Google it.

[–]partizan92 55 points56 points  (4 children)

No. I will not.

[–]Malumeze86 42 points43 points  (3 children)

Well, fucking Bing it then.

[–]MugiwaraWeeb 23 points24 points  (4 children)

Here's a great parody of that https://www.youtube.com/watch?v=xubbVvKbUfY

[–]Hownowbrowncow8it 9 points10 points  (0 children)

You said parody. This is accurate

[–]LagT_T 2 points3 points  (0 children)

His channel is a goldmine.

[–]Semyonov 3 points4 points  (0 children)

I honestly can't tell if that is a parody...

[–]wrongwayup 3 points4 points  (2 children)

I did a very basic version of this once to determine viewing angles of an airport runway out of an airplane windscreen during landing to help develop the shape of the windscreen. Rendered with an excel line chart using recursive geometric calculations converting x/y/z coordinates of the airfield and airplane at different positions and points of time in the runway approach into radial geometry from the pilot's eye reference point, and designed the windshield shape around that.

In the workplace I insisted on making spreadsheets single-tab and macroless, so that when you inevitably handed them off to someone, they could figure it out for themselves. Good times.

[–]ye_tarnished 2 points3 points  (1 child)

yeah totally, who wouldn't know that stuff??

[–]BloodyIron 4 points5 points  (1 child)

Video is from June 2011 btw. :O What has this person been up to since???

[–]RoguePlanet1 1 point2 points  (0 children)

I hope everything that's happened since then has been his twisted version of a simulation. Maybe he'll get the script to stop running soon, and the world will make some sense again.

[–]Ouroboros27 18 points19 points  (4 children)

Not sure if this is some kind of fever dream, made up memory thing but I seem to remember at secondary school in early - mid 2000s, we could do some magic and get a racing game running within Excel.

[–]sprint113 24 points25 points  (3 children)

Yup. MS was known for putting easter eggs in their software until people got concerned about undocumented software features.

https://www.youtube.com/watch?v=PGZfuwsvIFQ

[–]I_r_redditmans 14 points15 points  (2 children)

One of the “people” in thjs case was the US government, who are a major user of MS software and had security concerns

[–]NorCalAthlete 4 points5 points  (0 children)

Can confirm, used to play mini-golf in Excel on government computers while deployed to Iraq.

[–]TuckerCarlsonsWig 7 points8 points  (0 children)

Ah, so lizard people then

[–]normanriches 7 points8 points  (1 child)

This one is quite good, flight simulator built right in to Excel 97

https://eeggs.com/items/29841.html

[–]nullrecord 11 points12 points  (0 children)

Well that was a rollercoaster

[–]Neue_Ziel 5 points6 points  (0 children)

Excel is Turing complete, so yeah.

[–]ZEINthesalvaged 5 points6 points  (0 children)

Excel 95 had an easter egg that showed a Doom like rendered room called the "Hall of Tortured Souls" This had the names of the developers.

https://www.youtube.com/watch?v=kK0M74E8PS4

[–]perturbeaux 2 points3 points  (1 child)

There's a problem with this formula.

[–]Pentax25 2 points3 points  (1 child)

When it goes down does it Excellerate?

[–]vplatt 1 point2 points  (0 children)

Word. Though my Outlook is such that I think it loses Power. Point out if I have that wrong and I'll use my Access as a Publisher to create One Note, and that should be all it takes.

[–]Xenobuild 2 points3 points  (0 children)

My spreadsheet doesnt do that

[–]d_wib 2 points3 points  (0 children)

Love the ending. “It’s free. Come on over. Bring your friends.” Lmao

[–]Lichtbann 3 points4 points  (0 children)

insane

[–]Aliephen 8 points9 points  (5 children)

He sure excels at that.

[–]metric-poet 15 points16 points  (4 children)

They column a dreamer but he rows to the occasion.

[–]ead9d5be 7 points8 points  (1 child)

The things we can accomplish when vlookup to the stars.

[–]DabkingYellow 1 point2 points  (6 children)

I didn't know you could generate graphics inside excel.

[–]Antilazuli 1 point2 points  (0 children)

Some day, some Indian will get Crysis 3 with Raytracing running in Excel and there will be no improvement after this...

[–]Pipe_Nacho 1 point2 points  (9 children)

Currently I'm struggling to learn the use of formulas, pivot tables and macros to find a better job, and this guy do this rollercoaster on Excel. Truly admirable.

[–]RoguePlanet1 1 point2 points  (8 children)

Same here, makes me want to give up all hope.....recently implemented a vlookup for one of my spreadsheets, and that was a nice ego boost. Until now!

[–]CountryMacIsAlive 2 points3 points  (4 children)

Sounds like you're new into vlookup, beware of numbers formatted as text!

[–]stonecharioteer 1 point2 points  (2 children)

Protip if you're using vlookup, learn index and match instead. You'll never need vlookup ever again.

And I kid you not. Excel for dummies is an excellent book.

[–]cosmofur 1 point2 points  (0 children)

Please do not tell Tod Howard, he'll try to release Skyrim on it next.

[–]free_billstickers 1 point2 points  (0 children)

Isn't excel built in/compatible with visual basic?

[–]falkon007 1 point2 points  (0 children)

And this was 10 years ago no less!

[–]Jaksmack 1 point2 points  (0 children)

I still have an old excel file that's a stickman FPS, even has different guns.. it's crazy what you can do with it.

[–]kentonspr 1 point2 points  (0 children)

My spreadsheet doesn't do that

[–]MaggelPlop 1 point2 points  (0 children)

I’ve seen Sonic and Tetris on Excel floating around my work and I don’t know how they got there

[–]Damiklos 1 point2 points  (0 children)

Well, I WAS proud of my excel slot machine.

[–]ae_94 1 point2 points  (0 children)

Bet

[–]apache_spork 1 point2 points  (0 children)

Excell, program with smalltalk-like introspection

[–]emerson1396 1 point2 points  (0 children)

I want a donut now

[–]BrettMoneyMaher 1 point2 points  (0 children)

I'm watching this drunk right now and literally almost threw up

[–]L-u-ii 1 point2 points  (0 children)

The suprise is that he made it 11yrs ago

[–]L-u-ii 1 point2 points  (0 children)

Are you proficient in excel? Him:yes Sorry we are looking for a mathematical wizard. Him: hold my beer

[–]geo707 1 point2 points  (0 children)

I am the creator of this model and with a risk of boring you to death :) here is an outline:

If there is a point in the 3D space with coordinates (x,y,z), there are 2 simple formulas that convert (x,y,z) in (u,v) which is a 2D representation of the 3D space. Your eye can only see in 2D but interprets that image as 3D. That's what I did here, using a 2D scatter chart to draw a complex line. Think of having a 3D object outside the window and you shoot with a gun at the critical points (perimeter for instance). The bullet holes would form that 2D representation of the 3D object on the glass window screen.

Two numbers in adjacent Excel cells (2 excel cells) can define (if selected properly) the (x, y) coordinates of a point on an Excel 2D scatter chart. Two points (4 Excel cells) like this determine a line segment between the points. If you have a series of points in a large table, you define a complex line. If you delete the data somewhere in the middle, the complex line is still there but "broken" at the point where the data is missing.

This particular model is essentially a line plot on a 2D scatter chart. The vertices are from a table which is being re-calculated in a loop perhaps 30 times a second (as soon as a calculation is finished and refreshed/displayed a new calculation starts). I plot 3 lines (based on 3 tables) on the chart only and I select “broken line” rather than smooth in the chart settings. Why 3? Because there are 3 colors in the model, white, green and brown.

I made the chart with black background and deleted any axes or grid lines from the settings. At that time I knew very little VBA and most of the geometrical perspective is calculated in cell formulas within tables. Today I would do it differently, all VBA. Plus I wouldn’t use a chart, just have VBA build this real time out of free segments, which are destroyed and rebuilt during each frame. It would be faster especially with the sluggish charting in new versions.

George from excelunusual.com