Hello everybody,
I am writing on this forum because I am in doubt with a thermodynamic tool I am trying to develop on Excel: it aims to give an idea (I am not trying to have FEM-like accurate results), about the temperature distribution during a vulcanization process.
What I am thinking to do is "to slice" my parts in finite (and mass defined) parts, and to implement two fundamentals thermodynamics concepts:
- Fourier's law (heat conduction)
- Fundamental principle of calorimetry.
I will try to explain this better: I want to calculate step by step the heat flow and its consequences: starting from time=0, only the most external slice of the part is in contact with the heating system, thus the Fourier's law allows to calculate how much heat is moving, and the fundamental principle of calorimetry, knowing the specific heat of the material, allows me to calculate the temperature increment.
In time t=1 the heating system still has the same temperature as it is temperature controlled, but the most external slice is now warmer than before, starting the same process described before with both the colder more internal slice, and with the heating system which is still in contact, and go on.
I know that this implements thousand of simplifications, but I am wondering if it makes any sense.
Thank you very much and have a nice day,
Marco.
You are welcome. I am glad it worked out for you :)
Fantastic @Frictionless Beats! In the video is implemented exactly what I was trying to do, in a more-efficient way. I worked on it today and I made it work.
Thank you very much!
Hi Marco,
I have found a resource that might be useful to your problem. It tells you how to solve a 1-D heat equation in excel. They have also provided an example excel sheet file along with an explanation.
If you are trying to solve 2-D equations you might find a video by Kody Powell useful.
Here is the link to solve the 2-D heat equation in excel.
Cheers!