Question: can you post the excel sheet as well if possible? Task 3 For the following calculation, take T. = 288 K, h = 5 Wm'K',

can you post the excel sheet as well if possible?
can you post the excel sheet as well if possible? Task 3

Task 3 For the following calculation, take T. = 288 K, h = 5 Wm'K', p. = 1000 kgm. = 4200 Jkg 'K'.d = 0.2m. In reality the output from the sun is not constant all day. In order to simulate this, let Q, be a function of time given by 0,(t) = 1000 sin (3.1) 12 where is the time in hours. (a) Design a MS-Excel spreadsheet to implement the modified Euler method to solve the IVP (1.0) for Q, given by Egn. 3.1. with a time step of 15 s. for a total time period of 12 hours. Plot a graph of temperature vs. time in hours and use your results to determine the maximum temperature achieved during the 12 hour period. Include extracts of your spreadsheet with explanations of the formulae that you used. [30 marks) (b) Use your results to suggest the best strategy for using the solar heating tank. [10 marks)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Chemical Engineering Questions!