Heat Equation Excel Solver
Heat Equation Excel Solver
Heat Equation Excel Solver
Updated 22 OCT 2018 to correct for an error in radiation / convection boundary condition.
INTERIOR NODE
CONVECTIVE BOUNDARY 1
T_conv, h_1
k, q_dot
T_conv, h_1
k, q_dot
Top convective surface, or inside bottom surface
T_conv, h_1
k, q_dot
k, q_dot
T_conv, h_1
T_conv, h_1
T_conv, h_1
k, q_dot
Top left convective corner
T_conv, h_1
k, q_dot
T_conv, h_1
Bottom right convective corner
T_conv, h_1
k, q_dot
T_conv, h_1
T_conv, h_1
k, q_dot
T_conv, h_1
k, q_dot
T_conv, h_1
T_conv, h_1
k, q_dot
T_conv, h_1
k, q_dot
CONVECTIVE BOUNDARY 2
T_conv, h_2
k, q_dot
T_conv, h_2
k, q_dot
T_conv, h_2
k, q_dot
k, q_dot
T_conv, h_2
T_conv, h_2
T_conv, h_2
T_conv, h_2
k, q_dot
Top left convective corner
T_conv, h_2
k, q_dot
T_conv, h_2
Bottom right convective corner
T_conv, h_2
k, q_dot
T_conv, h_2
T_conv, h_2
k, q_dot
T_conv, h_2
k, q_dot
T_conv, h_2
k, q_dot
T_conv, h_2
k, q_dot
INSULATED BOUNDARY
k, q_dot
k, q_dot
Top insulated surface, or inside bottom surface
k, q_dot
Bottom insulated surface, or inside top surface
k, q_dot
k, q_dot
Top left insulated corner
k, q_dot
Bottom right insulated corner
k, q_dot
k, q_dot
k, q_dot
k, q_dot
k, q_dot
k, q_dot
T_conv, h_3
q''
k, q_dot
T_conv, h_3
q''
T_conv, h_3
q''
k, q_dot
k, q_dot
T_conv, h
q''
T_conv, h_3
T_conv, h_3
q''
T_conv, h_3
k, q_dot
T_conv, h_3
q''
T_conv, h_3
k, q_dot
k, q_dot
T_conv, h_3
q''
T_conv, h_3
k, q_dot
T_conv, h_3
q''
q''
T_conv, h_3
k, q_dot
q''
T_conv, h_3
k, q_dot
q''
T_conv, h_3
q''
T_conv, h_3
k, q_dot
q''
T_conv, h_3
k, q_dot
k, q_dot
q''
k, q_dot
q''
q''
k, q_dot
k, q_dot
q''
q''
q''
k, q_dot
q''
k, q_dot
k, q_dot
q''
k, q_dot
q''
k, q_dot
q''
Interior top right corner
k, q_dot
q''
q''
k, q_dot
q''
k, q_dot
COMPOSITE SOLIDS 1
k_ext,
q_dot_ext
k_int,
q_dot_int
k_int,
q_dot_int
k_ext,
q_dot_ext
k_ext
q_dot_ext
k_int
q_dot_int
k_ext
q_dot_ext
k_int
q_dot_int
k_ext
q_dot_ext
T_conv, h
k_ext k_int
q_dot_ext q_dot_int
T_conv, h
k_int k_ext
q_dot_int q_dot_ext
Left comp. conv. surface, internal material at bottom
k_ext
q_dot_ext
T_conv, h k_int
q_dot_int
Left comp. conv. surface, internal material at top
k_int
q_dot_int
T_conv, h
k_ext
q_dot_ext
k_int
q_dot_int T_conv, h
k_int
q_dot_int
T_conv, h
k_ext
q_dot_ext
k_int k_ext
q_dot_int q_dot_ext
T_conv, h
k_ext k_int
q_dot_ext q_dot_int
T_conv, h
COMPOSITE SOLIDS 2
k_ext,
q_dot_ext
k_int,
q_dot_int
Right composite surface
k_ext,
k_int, q_dot_ext
q_dot_int
k_int,
q_dot_int
k_ext,
q_dot_ext
k_int k_ext
q_dot_int q_dot_ext
Top left composite corner
k_ext
q_dot_ext
k_int
q_dot_int
k_int
q_dot_int
k_ext
q_dot_ext
T_conv, h
k_ext k_int
q_dot_ext q_dot_int
Top comp. conv. surface, internal material to the left
T_conv, h
k_int k_ext
q_dot_int q_dot_ext
T_conv, h k_int
q_dot_int
Left comp. conv. surface, internal material at top
k_int
q_dot_int
k_int
q_dot_int
T_conv, h
k_ext
q_dot_ext
k_int
q_dot_int T_conv, h
k_int
q_dot_int
T_conv, h
k_ext
q_dot_ext
k_int k_ext
q_dot_int q_dot_ext
T_conv, h
k_ext k_int
q_dot_ext q_dot_int
T_conv, h
RADIATION AND CONVECTION BOUNDARY 1
Surface Emissivity e=
Surroundings Temperature [K] T_surr =
Stefan-Boltzmann Constant [W/m^2 K^4] s = 5.669E-08
Conv. Heat Transfer Coefficient [W/m^2 K] h=
Thermal Conductivity [W/m K] k=
Mesh Size [m] Dx = Dy =
Generation Rate [W/m^3] q_dot =
T_surr
k, q_rad
e,
q_dot
T_conv, h
Left convective surface, or inside right surface
T_surr
q_rad
k,
e,
q_dot
T_conv, h
Top convective surface, or inside bottom surface
T_surr
q_rad
T_conv, h
k, e, q_dot
k, e, q_dot
k, e, q_dot
T_conv, h
q_rad
T_surr
k, e, q_dot T_conv, h
k, e, q_dot
T_conv, h
Bottom right convective corner
T_conv, h
k, e, q_dot
q_rad
T_conv, h
T_surr
Bottom left convective corner
T_conv, h
k, e, q_dot
q_rad
T_conv, h
T_surr
k, e,
q_dot
q_rad
T_conv, h T_surr
Interior top right convective corner
k, e,
q_dot
q_rad
T_surr T_conv, h
Interior bottom left convective corner
T_surr
q_rad
T_conv, h
k, e,
q_dot
T_conv, h
Surface Emissivity e=
Surroundings Temperature [K] T_surr =
Stefan-Boltzmann Constant [W/m^2 K^4] s = 5.669E-08
Conv. Heat Transfer Coefficient [W/m^2 K] h=
Thermal Conductivity [W/m K] k=
Mesh Size [m] Dx = Dy =
Generation Rate [W/m^3] q_dot =
T_surr
k, q_rad
e,
q_dot
T_conv, h
Left convective surface, or inside right surface
T_surr
q_rad
k,
e,
q_dot
T_conv, h
Top convective surface, or inside bottom surface
T_surr
q_rad
T_conv, h
k, e, q_dot
k, e, q_dot
T_conv, h
q_rad
T_surr
k, e, q_dot T_conv, h
k, e, q_dot
k, e, q_dot
T_conv, h
Bottom right convective corner
T_conv, h
k, e, q_dot
q_rad
T_conv, h
T_surr
Bottom left convective corner
T_conv, h
k, e, q_dot
q_rad
T_conv, h
T_surr
k, e,
q_dot
q_rad
T_conv, h T_surr
Interior top right convective corner
k, e,
q_dot
q_rad
T_surr T_conv, h
Interior bottom left convective corner
T_surr
q_rad
q_rad
T_conv, h
k, e,
q_dot
T_conv, h
RADIATION BOUNDARY
Surface Emissivity e=
Surroundings Temperature [K] T_surr =
Stefan-Boltzmann Constant [W/m^2 K^4] s = 5.669E-08
Thermal Conductivity [W/m K] k=
Mesh Size [m] Dx = Dy =
Generation Rate [W/m^3] q_dot =
k,
e, q_rad T_surr
q_dot
q_rad
T_surr k,
e,
q_dot
k,
e,
q_dot
q_rad
k, e, q_dot
k, e, q_dot
q_rad
T_surr
T_surr
q_rad
k, e, q_dot
T_surr q_rad
k, e, q_dot
k, e, q_dot
q_rad
T_surr
Bottom left convective corner
k, e, q_dot
q_rad
T_surr
k, e,
q_dot
q_rad
T_surr
Interior top right convective corner
k, e,
q_dot
q_rad
T_surr
Interior bottom left convective corner
T_surr
q_rad
k, e,
q_dot
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
0
0
Err:522
Err:522
Err:522
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
0
Err:522
Err:522
Err:522
Err:522
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
#DIV/0!
25 25 25 25 25 25
25 25 25 25 25 25
25 25 25 25 25 25
25 25 25 25 25 25
25 25 25 25 25 25