Homework #$2$

Due Tuesday, January ${23}^{rd}$

Write a program that calculates the heat flow from a single component system. This program will utilize the integral form of specific heat.

The heat flow is calculated as:

$Q=nA=n{\displaystyle \underset{T_{in}}{\overset{T_{\text{o}\text{u}\text{t}}}{}}}{C}_p(T)dT$

where

${\displaystyle \underset{T_{ln}}{\overset{T_{\text{o}\text{u}\text{t}}}{}}}{C}_p(T)dT={\displaystyle \underset{T_{in}}{\overset{T_{\text{o}\text{u}\text{t}}}{}}}A+BT+C{T}^2+D{T}^{3}dT$

This program will run from a Userform that will resemble the form given below. The user will enter the heat capacity constants $A,B,C$ and $D,$ as well as the physical properties of the molar flow rate $mo\frac{l}{s},$ inlet temperature $C,$ and outlet temperature $C.$ The example is for gaseous nitrogen. The Userform is shown once a button on the corresponding spreadsheet is pressed.

Heat Flow Calculator

Physical Data

$[$ molar flow $,],[$ Inlet Temperature $,C],[$ Outlet Temperature $,C]$

Heat Capacity Constants

A

$(\frac{\mathrm{.}002199}{B})$

C $(\frac{\mathrm{.}5723e-5}{?})$