The Two-Dimensional Conduction Heat Transfer Equation on a Square Plate: Explicit vs. Crank-Nicolson Method in MS Excel Spreadsheet

Abstract

Abstract In this paper, the two-dimensional conduction heat transfer equation on a square plate is analyzed using a finite difference method. We have developed both the forward time-centered space (FTCS) and Crank-Nicolson (CN) finite difference schemes for the two-dimensional heat equation, employing Taylor series. Subsequently, these schemes were employed to solve the governing equations. The primary objective of this study is to compare the efficiency of the two methods in solving the conduction heat transfer equation. This was accomplished by implementing Spreadsheet Excel instructions. The results are presented, highlighting a comparison between the exact and approximate solutions. Furthermore, to demonstrate the convergence of the numerical schemes, we estimated the error between the actual and approximate solutions for a specific numerical problem and presented the results graphically. The data utilized in this research included the thermal conductivity of the medium of the square plate concerning width, grid, and compliance with initial and boundary conditions. The findings indicate that the Crank-Nicolson method is more accurate than the forward time-centered space method, as it approaches the exact solution more effectively. Furthermore, this study confirms that the solution and simulation of the heat transfer equation on a square plate can be accurately performed using an Excel spreadsheet as well as other numerical software.