I haven't put any content up here in a while, so I thought I'd show off how needlessly addicted to Excel you become when you're working in finance by implementing the Mandelbrot set in Excel. For this spreadsheet, I changed the size of the cells to 2x2, put a formula in each cell to calculate how many iterations of Z -> Z^2 + C that each point C survives, and then used conditional formatting to fill the whole thing in. A slight modification to the sheet would make it approximate the area of the Mandelbrot set, although not to anywhere near the accuracy you can achieve by looking at things mathematically.
It might be a fun exercise to add zooming capability -- all you'd have to add are a couple of cells to replace the currently-hardcoded values in the formulas. Of course, it does calculate relatively slowly at the moment.
Speaking of finance and spreadsheets, I'm looking for a job at the moment. I have some experience with finance, a Series 7 license, and I think I'm pretty good at Excel.
0 comments:
Post a Comment