How to draw the Mandelbrot set in Excel, and what happens when mathematicians get angry
HTML-код
- Опубликовано: 11 сен 2024
- Includes some tips about iterative calc; relative reference defined names; and alphabetic worksheet calculation order. Also there is a dream sequence.
Spreadsheet download: chrisrae.com/p...
• Set animation created using Fraqtive: fraqtive.mimec...
• Original Mandelbrot set image from www.bgc.bard.e...
• Fake Tinder video created using github.com/plu...
• Pseudo code adapted from en.wikipedia.o...
• Spooky forest background created using Mid Journey AI: www.midjourney...
• Other images from Wikipedia Commons
Edit: It has been pointed out to me that this workbook could be much neater if it was rebuilt using Excel's new LAMBDA function instead of iterative calc. I think that would be a great improvement - iterative calc spreadsheets are neat, but they're no fun to work with. If you make that workbook, let me know! / pugwonk
This is brilliant - takes me back to when I was plotting the Mandelbrot set on my Apple //e as a kid. I can quite comfortably say that after all these years my understanding of the equations behind this has not improved. 🙂
Excel will handle complex numbers with the function COMPLEX(), it used only come with the analysis tool pack but might now be permanently installed
Ooh, good point. It's installed with Excel now (I was actually somewhat involved in the process of integrating those functions!).
This is pure gold. Thank you for making my day!
From the Purest of the Purest 🏆🏆🏆
Hilarious and clever and Excel - that's the sweetspot!
Amazing. Excel and maths never ceased to amaze me. Great video and awesome comedy!!
The Tinder profiles are Ada, Countess Lovelace, René Descartes and John "Beautiful Mind" Nash.
Chris, this is genius. Absolutely fantastic nerdery.
Thank you so much! This video alone helped me save my whole familty! for sure!
This is great! Looking forward to more content from you.
Bravo. This is excellent. Let’s get a beer soon.
This is massive!! mind-blown 👉👉🤯🤯👈👈
minute 9:15 = hilarious!!!! 😂😂😂😂😂😂
I wish i was smart enough to understand even a small portion of this video. Unfortunately all i understand is "Mandelbrot cool", and that's all i ever will understand. Cool display of immense intellect though.
Question... How is this actually used in real world scenarios? As in, what kinds of industries are they used?
Thanks for sharing
Great video and comedy! 🤣🤣🤣🤣
Hello, Chris Ik this is a year after but I need help as I'm not getting the same values as your 3calcx Which is highly likely the problem that is causing my mandelbrot set to not appear.
Brilliant, thank you
I've tried 100 times, idk what I'm doing wrong. I'm most likely not setting the values correctly when I make a new setup? I click b2 hit f3 edit erase click b2 hit f4 3 times n save looks exactly like yours in the box, the formulas b2:u21 =if(reset,0,2*x*y+y0) I have them damn near memorized i just cant get it right. comes up all 0
Why must it be so horribly stretched…
This is the best!!!
Thanks for the help making these!
I am confused why you are not Famous! maybe because your work is beyond our IQ😆
Nerd!
Guilty as charged!
Awesome Chris 💗. I always love your videos. Please keep it up.
This is Stephanie from Upwork and I would love to get your contact.
Thanks 👍.
Stephanie.