Answered step by step
Verified Expert Solution
Link Copied!

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?
image text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Ceramic Matrix Composites Fiber Reinforced Ceramics And Their Applications

Authors: Walter Krenkel

1st Edition

3527313613, 978-3527313617

More Books

Students also viewed these Chemical Engineering questions

Question

1-1 Why is communication important to your career? [LO-1]

Answered: 1 week ago

Question

Have you defined the situation fairly and accurately?

Answered: 1 week ago