1.Create an explicit FDM in VBA for the case of acylindersubmerged in water. You can ignore the heat transfer into and out of the ends of the log. Hint: Write the code so that it (i) loops only...

1.Create an explicit FDM in VBA for the case of a

cylinder

submerged in water. You can ignore the heat transfer into and out of the ends of the log. Hint: Write the code so that it (i) loops only until the log centerline exceeds 292.5°C and (ii) prints the results to the worksheet every 60 seconds while using a timeStep of 5 seconds.

2. Examine the effect that log diameter has on the time needed for log centerline temperature to reach 20º. Assume the species is Aspen and that the log diameter distribution attached is a reasonable estimate of the actual log distribution. Compare the time needed to reach 20°C for logs 90% of the mean diameter and logs 110% of the mean diameter. The values for the thermophysical properties are as follows: