Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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?
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
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started