1. Thermal diffusion: Consider a heat pump system connected to the ground by pipes through which a heat exchange fluid flows. An important aspect is how heat flows between the pipe and the surrounding soil. Analytic solutions are based on the thermal diffusion equation; we divide the thermal conductivity by the heat capacity per volume to afford the thermal diffusivity a = k/Cpp. Then we set up the time-dependent differential equation with suitable coordinates and boundary conditions and attempt to find a closed-form solution. Numerical solutions make the calculation much simpler. The reading 91 92 9n-1 by Formhals points out that thermal problems can be solved using a finite difference method. This is depicted in the figure as a chain of resistors and capacitors. In this problem you will construct a one-dimensional numerical model of heat flow using an Excel spreadsheet. This will reveal how slowly heat moves! The numerical format also allows you to test different situations; for example, by changing a time scale or a boundary condition, you can see how the temperature profile changes. The procedure: (i) Consider a 1-D problem in which the heat exchange piping approximates a plane and heat flows to the right into the soil (as in the figure). Heat flow will be per unit area. (ii) Let the columns of your table represent depth as thickness increments. These should be thin enough that the temperature difference between them is modest (I use 0.1 m which seems fine). (iii) Let the first column be the boundary condition. Here, it is the temperature of the heat exchange fluid, assumed to be a constant 40*C (i.e., rejected heat from air conditioning). (The real-world boundary condition also involves a heat transfer coefficient - another limitation - but here, to keep things simple, we assume that thermal diffusion is the only limitation.) (iv) Let the rows of the table represent time steps. The first row will be the starting temperature vs. depth, assumed to be a constant 20*C. For each time step, calculate the new temperature of eachcolumn as follows. Calculate the heat flux per unit area into and out of each increment based on the temperatures of the increments on either side of it, the thermal conductivity, and the thickness of the increment. Then calculate the temperature change in each increment based on the net heat flux, the length of the time step, and the heat capacity. (v) Plot the temperature vs. depth for selected times (for example, every 5th or 10th row). Important suggestion: define all the important variables at the top of your Excel sheet so that you can easily change them and observe the effect on your simulation.b. Arbitrarily define the "penetration depth" of the heat as the depth at which the soil temperature has reached 21*C. In your simulation, how long does it take for heat to penetrate 1 m deep? c. If you double the thermal diffusivity, how far does the heat penetrate during the same time as your answer to part a