Solving the two dimensional heat conduction equation with Microsoft Excel Solver
Vložit
- čas přidán 15. 09. 2017
- The 2-D heat conduction equation is solved in Excel using solver. See • Two dimensional heat c... to see how the equations were formulated.
You are a lifesaver, this video was more helpful than the actual lab instructions/instructor!
Didn't even know excel could do this, cool. Thanks.
Thank you this was very helpful
very helpful , thank you so much
Thanks! really help a lot
nice work
this is genius
Thank you
I know when other 2D shapes are used with conduction & convection, the B.C. formulas change per cell, but I keep getting the "cell reference box is empty or invalid". Any thoughts?
This is a cool little model! but in this video when imputing the formula isn't there meant to be a - sign at the beginning? according to the formula derivation there is?
Edit: I see later in the video that the - sign was integrated into the formula.
I was able to duplicate your analysis, and then created a fin (high temp on one end, long wall insulated on both sides, ambient temp at the other end). This ran and I got a nice distribution of temp from high to low using the GRG Nonlinear solver. However, when I changed just the dx value to 4x the original value, I got the exact same temp distribution (same temps at same cells) even though they should have been 1/4x the distance from the high temp source. The high temp distribution should have been congregated more at the high temp end of the 4x long fin. Does this solver actually take the dx and dy values into account or just perform a smooth curve distribution? This method could be very useful if trustworthy, I'd very much appreciate a response. Thanks.
Thanks for your interest! It's been a long time since I made this video. I believe I did it in term of heat flux (W/m^2) instead of W and assumed that dx and dy were the same. I'd recommend looking at your energy balances and incorporate the appropriate areas for heat transfer so that each term in your equations have units of W. The method is definitely valid as long as your energy balances are correct.
This problem solve in matlab is available in any video lecture?
Thank you and excellent video - one question: a change in k (f.e. insulation material versus a metal) does not seem to impact the distribution - would that be plausible for you ? Thank you.
You are searching for a steady state in this particular case. This equilibrium will happen at different times depending on the material, but no matter what it will happen. This is the solution, the gradient of temperature we're getting here.
You can see the thermal conductivity here as the speed at which we will reach the steady state.
I have copied exactly the example but it won't run on my mac. I get weird and inconsistent values: any suggestions? Thanks.
Edit:I missed the first minus in the formula. It works. Any suggestions for a circular cross-section?
Fantastic approach. However, this is only applicable for the rectangular boundary. For triangular boundary(like dam), while applying the solver, it is showing error by mentioning Too many variables.. Do you have any solution for this?
can you solve this issur
Hello, i was wondering if you were able to please help me construct something similar to your video for a varying geometry problem? I have a few different finite difference equations to use based upon a couple different conditions. I was using Excel solver to begin with, but can only use it for 100 calculations, rather than the thousands i require for an accurate solution? Am i able to email you something for advice? Thanks in advance
Hello sir
I'm looking for a solution to the advection diffusion equation using finite difference method!
Could you please share your Excel file, that would really help me to make some modification and help me solve the problem!
is it possible solve it with matlab? if yes, can you show the method of solving.
I couldn't find analyzer tab and solver button in my excel2016... How can i get that?
It's an add in that you need to get. If you search for it in Excel, it will come up.
Your sound level is very quiet
Volume so low
please help me with a chimney project if i fail i will get kicked out of college
rip
@@dipperpines5144 rofl
Update still in college
@@Lumichett what happened? you passed?
@@yeahx32p69 I graduated and moved across the country to work for Intel