Measured In ChE 3232, students estimate the steady state temperature (Tss) attained by a heated plate that is in contact with a fowing stream of air. They do this for different air flow rates. Each time the air flow rate is changed, it takes up to 1hr to establish a new steady state temperature. They collect unsteady state data shown in the Excel Spreadsheet below and use the following equation to estimate (Tss) and the thermal time constant () t (min) Temperature T 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 90.81 89.97 89.12 88.31 87.56 86.88 86.20 85.61 85.03 84.46 83.94 83.45 82.99 82.54 82.13 81.71 81.32 80.97 80.66 80.33 To is the plate temperature (T) at t - 1 min. Using the values in Cells D23 & D24 as initial guesses, you have been asked to use Excel to find Tss & that allow the equation above to best fit the experimental data Use of graph plotting and "Trendline is forbidden. Use Lecture 7 for guidance. Follow the hints given below and submit a completed spreadsheet to blackboard. No credit will be given for incomplete work. ints: Cells C1, D1 & E1 should describe the operation performed in the Cell (S) directly below them What would you enter into Cells C1, D1 & E1? What equation must be entered into Cell C2? The formula should be copy-able to Cells C3 to C21 What equation must be entered into Cell D2? The formula should be copy-able to Cells D3 to D21 What equation must be entered into Cell E2? What operation must be carried out on the function/formula/contents of Cell E2 to obtain the desired values of Tss & ? a. C. d e. 50 50 f Which Excel tool allows you to carry out part 8(e)? Are there any constraints that must be imposed on the values of Tss & ? Measured In ChE 3232, students estimate the steady state temperature (Tss) attained by a heated plate that is in contact with a fowing stream of air. They do this for different air flow rates. Each time the air flow rate is changed, it takes up to 1hr to establish a new steady state temperature. They collect unsteady state data shown in the Excel Spreadsheet below and use the following equation to estimate (Tss) and the thermal time constant () t (min) Temperature T 1.00 2.00 3.00 4.00 5.00 6.00 7.00 8.00 9.00 10.00 11.00 12.00 13.00 14.00 15.00 16.00 17.00 18.00 19.00 20.00 90.81 89.97 89.12 88.31 87.56 86.88 86.20 85.61 85.03 84.46 83.94 83.45 82.99 82.54 82.13 81.71 81.32 80.97 80.66 80.33 To is the plate temperature (T) at t - 1 min. Using the values in Cells D23 & D24 as initial guesses, you have been asked to use Excel to find Tss & that allow the equation above to best fit the experimental data Use of graph plotting and "Trendline is forbidden. Use Lecture 7 for guidance. Follow the hints given below and submit a completed spreadsheet to blackboard. No credit will be given for incomplete work. ints: Cells C1, D1 & E1 should describe the operation performed in the Cell (S) directly below them What would you enter into Cells C1, D1 & E1? What equation must be entered into Cell C2? The formula should be copy-able to Cells C3 to C21 What equation must be entered into Cell D2? The formula should be copy-able to Cells D3 to D21 What equation must be entered into Cell E2? What operation must be carried out on the function/formula/contents of Cell E2 to obtain the desired values of Tss & ? a. C. d e. 50 50 f Which Excel tool allows you to carry out part 8(e)? Are there any constraints that must be imposed on the values of Tss &
