3 ms·
> Imagine solving differential equations numerically using 10,000 cells in Excel, yes, it has been done! There's a nice treatment of how to do this for simple
by buescher 4y ago
> Imagine solving differential equations numerically using 10,000 cells in Excel, yes, it has been done!
There's a nice treatment of how to do this for simple heat transfer problems in Tony Kordyban's Hot Air Rises and Heat Sinks. You will amaze and frustrate your co-workers.
Excel is 100% the poor man's simulation package. I like Matlab and Simulink a lot better, and if I were 25 again I'd be a fool for Julia, but nothing beats it for sharing a simulation or other analysis with someone that doesn't have the same software you do on his or her computer.
- segfaultbuserr 4y ago> Tony Kordyban's Hot Air Rises and Heat Sinks It was a fun book, I don't remember the Excel modeling part though... I do remember seeing something similar on Microwaves101.com by The Unknown Editor... > The spreadsheet has 96 distance steps and 2000 time steps, or almost 100,000 cells. In the old days it would bring a computer to its knees when you changed a variable. Now it's almost instantaneous, however, it still measures 10MB. We will offer a zipped version of it in the download area, soon. https://www.microwaves101.com/encyclopedias/fourier-s-law https://www.microwaves101.com/encyclopedias/fourier-s-law
- buescher 4y agoChapter 25, "Even A Watched Pot Boils Eventually". If you want a whole lot of that, appendix D of Holman's Heat Transfer, which is referenced in Kordyban's book.