Question

Complete the excel sheet to find the temperature distribution along a cylindrical fin with convected tip.

One-Dimensional Temperature Distribution along a Fin with convection at the tip Solution with Matrix Inverse Method AI ITI= IBI т. Find the temperature distribution by matrix BI ITI JAI inversion method T19T31) MMULTIB19N31.019 0311- B19N30 MINVERSEIB2N4 ) Steps: 1. Invert coefficient matrix JAblock off NxN cells; type {-MINVERSE (B2 N14)), then [Ctrl+Shift+Enter]. by column matrix IBI- 2. Multiply inverted coefficient matrix JA - block off N cells; type {=MMULT (B19:N31,Q19:Q31)}, then [Ctrl+Shift+Enter]. Steady 1-D Temperature Distribution along a Cylindrical Fin with convection at the tip 100 W/(m2.K), T.=20°C Wall h Q 0.04 100°C 160 W/(m.K), D Convection at the fin tip Fin, k 0.025 m x 0 x L L 0.24 m NUMERICAL SOLUTION: x (m) 0 0.2 0.22 0.1 0.12 0.02 0.04 0.06 0.08 0.14 0.16 0.18 0.24 T (C)

Answer 1

*P=ザDS 25-o10785 m MLミ9、99 4- 377 2 4." Cosh m 55S Cohyecion tip T-Too Cosh m メニ0-02m; T20 C100 20) Coshx[2.1978 55 T:957 'C メミ0104-mm; T-20- x COsh 918J Tミ34,12°C. 5.55 た20 こ80x Cos h {、719] *つ。たいもッこム 555 5.0 c . 以20、08 m: Cosh 5a. T- 2.0 o x 555 0InM T-20 ミ80x Coshari393] 5 SS [86J450 x0名 こ 02ーム アミ4207°c. l 2o12m つ。to9 こ e 5.55 x20114.m: T-2.0 gox Cosh fo . 1q1/. 31.26c T-202 g0x CASha Co997/s.55 Cos h Co1/s っくニ016 )TE330g°c S 5S アー20 -80 マこ6,18m T35.S8 c. Cos hCo3/s 555 アー20 - 80× cosha Co.19/s.59 メニ0-22m: T-20 こ0x スSo24med vith20 80l CamScanner Tニ34.41°c 5.55