I built my own 16-Bit CPU in Excel 

Okeydokey

Next do “installing Windows 98 in Excel”

The are some channels that have been running this offer for years. How do you know if you're going to be one of the lucky "first 200?"

NO! SHOVE YOUR SPONSOR RIGHT WHERE IT FITS!!

Automatic thumbs down for putting the sponsor in the middle.

*at 0.00000000000148 FPS

Minecraft on excel. Doom on excel.. mario! Emulation! The possibilities!

​@@absolutetruth9975Yes if you give it enough time and memory 😏

This is so cliche and annoying. However, its better than the comments that are like “oH My gOodNeSS hE iS lIkE a gEnIus hE sHoUlD gEt a nObEL PEacE pRize”

If one were able to implement an 8086 and simple VGA, it’d be the best kind of possible.

Dude's resume is just a link to this video

​@@SamethokThe resume is also made in excel.

Turing completeness is so beautiful

Finally a Zoomer worth his salt

​@@Breakfast_of_Champions ok boomer

can it run doom

Technically it's an emulator

Yes, google “excel doom game”

Port it from graphics calculator?

Or Wolfenstein 3Diagram 📈 ?

​@@axelkidd9850no, doom

Yes

Like that one guy that made PowerPoint Turing complete...

Excel on non-Windoze platforms is crippled, but this would work.

Yea I did a raytracer only using Excel formulae. Much more fun having to work out solutions that don’t use VBA.

I'd have been tempted to add some VBA right at the end to generate the clock, but I can see that would open the door to more stuff. So yes impressive restraint indeed and a great video!

It might also make it more cross-platform compatible. Open Office sometimes has issues with Macro import, but cell formulas should be easier to import.

i love how that looks as if the source of the quote is "I'm stealing that"

@@NotHumanPerson””The best kind of possible - theoretically possible” - I’m Stealing That” - Michael Scott

yeah this is one of the best jokes i've ever heard

Slight adjustment to the Futurama meme innit?

🤓

Lol

jajajaj

They are waiting for Gta 7

@@zrayx7214 and Portal 3🤣

@@galacticviper4453 and half life 3 😭😭

it is more like a poly relationship really. Your cpu is totally in on it

@@gooseloose682 reddit cuck cpu

Emulators and VMs be like:

@@gooseloose682 Imagine getting your gf pregnant and dating the fetus

It’s pretty much just some simple code for doing math but in a really really unreadable way. Pretty much it’s like “okay is the clock tickin? Yeah? Ok then so like do I add, subtract, multiply, divide, etc…? Ok so you want me to add? Ok I’ll add these two numbers together.” In other words, “b30 is the clock tick and this cell is equal to a value dependent on the clocks tick as well as d30 which controls which operand is being done.”

Just what I like to see on my CPU!

www

This

Hahahaha

I was here ☕

And the rickroll music

assembly is not that hard, its pretty simple language, a lot simpler than c++

​@@jordixboyI used to think assembly was complicated, but really it's just a simple functional language, in a way. You can get really creative with your solutions for problems instead of doing bulk things, like maybe leaving Y register untouched in this function specifically so the calling function can forgo saving it. Most assembly languages are just the same basic principles but with some different commands or limitations, some need more instructions to do the same function as an x86 one, for instance. That's why macro assemblers exist. Sure, it's probably not a good idea to do anything substantial in it, but at least knowing what decent assembly looks like, so your most used functions can be assessed for optimization. Could also have fun with a 6502 or z80 retro computer as a learning experience.

@@jordixboy assembly isn't hard in itself but the trickiness starts arising when you start doing everything in it, at that point you pretty much have to manage everything yourself, which is pretty fun actually

I found 6502 assembly was really fun. It was designed to be used by humans. Even with as difficult as it is, there is something really enjoyable and simplistic about it.

@@ireallydontknowifiamhonest yeah, bookkeeping in a way gets hard, or if your code block gets so big that directly indexed jumps aren't far enough.. and then you have to push and pop registers awkwardly and whatnot.

That requires running doom on it

@@killpidone my god, a genius!

Same.

@@user-cs8qq5vt4v ik

fr

you ruined many student's life

There is a great book that really explain the principles and logic of a cpu. Its called "But how do it know" I strongly recommend it

Code by Charles Petzold is also rly good

Flip flops

@@PeacfullReal

You arr so right, that was my thinking

I learnt more in this than my actual computer science course

this dude literally made a full course in cpu design in a 15 minutes video

​@@miguelelgueta5830Pipelining is an important part of CPU design and rightfully made up the last third of my university's basic course on the matter. The alu was also cut short in the videos explanation and is way easier to implement in Excel. Overall it's a nice video but by no means a course.

Excuse me, this would be the INTRODUCTION?? damn

100%. I think you can evaluate if a worksheet is calculating, so just monitoring that would be enough. Then you could have it clock the system. I think if someone is writing a compiler in Python, then using VBA for this sort of operation is an acceptable application. I think it would also be justifiable to apply the cell coloring for the screen pixels in the same way, allowing 16.7 M true color output... This is just because Excel has a restriction for modifying the color of cells programmatically, but it unlocks a lot of potential that conditional formatting can't. For the sane reason, VBA could be used for loading the ROM. This wouldn't be all that different than using an EPROM burner, which still doesn't diminish or detract from the Excel CPU.

Yeah, that would be a whole lot better than doing ALL of it manually.

I'll have to play with it next time I'm at my computer but I think you might be able to get some sort of iterative calculation going (there is a setting in excel to allow it). Might just end up in an infinite loop that will crash Excel but it would be so neat to have a fast clock powered by formulas to keep the whole thing as pure as possible. Not even sure my version of Excel supports them but I've heard there is a lambda formula that can call other formulas so there may be a solution to be had there as well. I guess you could also implement a function (not a sub) in VBA that toggles a cell in a loop and then use that function in the formula bar (excel treats VBA functions as custom formulas since they both take some parameter(s) and return a result). Still cheating to me (especially since you'd likely wouldn't be using the return value but rather the loop and a direct reference to a cell) but I guess slightly less than just banging out VBA and running it as a macro.

Pretty sure the limitation is not how fast you push the button but how long it takes excel to process the formulas. That’s what he demonstrated at the end where each press of the button takes a couple of seconds to process the clock cycle, so any automation there just means you can leave the program running while you run some errands and it finishes in an hour

@@Eji1700 He said it runs at a few hertz, which is about how fast you can click. But, yeah, it's possible it can't run any faster.

At billions of times a second

Excel is already powerful so this wasv rudimentary at best...

Should be taught on cs

I was so disappointed seeing other Excel videos just write Basic programs, I had to undo an injustice.

@@InkboxSoftware EXACTLY! 😄

Wow

@@InkboxSoftware I personally would have just wrote nothing but VBA except for rendering the screen which is benefitted by =MAKEARRAY since VBA is not nearly quick enough to handle all those cells. Though, I do understand the challenge aspect, but when I did challenge myself to use almost exclusively formulas except for the one function making sure the player didn't have to manually hold F9, it was pretty boring even after I had completed it, it just wasn't very fun for me, but to each their own!

I would also like to see this

Doom has already been run on excel and on lower capacity programs. I'm sure it'd 100% run doom

Theres a guy on youtube who sees if every device can run doom. Somebody needs to tell him about this.

Sad ... Kinda cant in this condition, they need to finish the CMD, but as he say ... In theory, yes we can ... Just couple of more steps

Not without rewriting Doom itself. It was designed for 32-bit systems, and in this video, a very limited instruction set is used. It would not be possible to capture and react to keyboard input from an Excel spreadsheet simply with formula either. Would be cool though.

​@@jamieevans5979but can it ***fake*** running DOOM?

@@Akira-Aerins Sure. Just use a screen recorder and embed the video on the spreadsheet 😆

would be better for you if you did though

Front-end dev spotted

@@mmmmmmmmmmmmmmmmmmmmmmmmmmmm56 I make games and other programs, i don't make computers 🙃

If black boxes always worked exactly as you intend them too then I'd agree... But they don't and while I wouldn't recommend just opening everyone you find for the sake of it, it really does help to have some experience cracking a few cases because you will need to at some point. I'd hazard to guess this attitude is one reason why most modern software is horribly optimized and tends to be a nasty soup of cobbled together packages. Sure that might be a simple and blissful way to do things but ignorance will never produce something of higher quality than true understanding. Not to mention it doesn't pass the "what if everybody did it" test because at some point somebody needs to be able to create and service black boxes or the consumers will have nothing to stitch together.

Im just a PLC Technician not a Programmer, but how a CPU Works was literally the first Thing i learned. The First Code we wrote Was i Assembly, if you Understand how the Basics work, you can build on that

Video when

@@xdasdaasdasd4787 im not all that good at making videos but i will maybe upload one once i finish

Show us when it's done

Already been done use google

The Begining! :)

For irony, it would have to be lotus 1-2-3

@@killpidone that would be incredible

For pure "Microsoft-verse", it should be DOS and Excel. But just to annoy Microsoft, the operating system should be IBM OS/2 and the spreadsheet Lotus 123.

​@@killpidone DOS is not done til Lotus won't run.

Don't forget James Sharman

noam nisan and shimon shocken

And this comes in handy even for medium sized projects! I use this all the time, it makes everything so much more maintainable!

You can also use the name manager to do the same thing. It's even more powerful because you can create a named value that doesn't exist on any sheet.

@@MichaelStubbs What do you call medium sized?

Oh wow, that is insanely useful for writing things that will be easier for my teammates to read. Thanks!!

This is the way.

You know what that means, don't you? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNjxe8ShM-8.html

You know what that means, don't you? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNjxe8ShM-8.html

You know what that means, don't you? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNjxe8ShM-8.html

You know what that means, don't you? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNjxe8ShM-8.html

You know what that means, don't you? m.ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-uNjxe8ShM-8.html

No

@@Aligames5747 anything can run doom 😂 I would love you see him try it even if it is a failure.

@@noahorick986 but this is 16 bit and doom is 32 bit

Hahhaha