One of the standard equations for calculating the heat capacity (specific heat) of a gas at a specified temperature is the third order polynomial C, =a+b7 +cI? + dT'. If the coefficients (a, b, c and d) are known for a particular gas, the heat capacity can be calculated for the gas at any temperature, T, within the allowable range. Coefficients for several common gases are shown in the table below, for the temperature entered in C. The result is in units of kJ/gmolC. a Gas Air co, CHA H2O 28.94 x 10- 36.11 x 10-3 34.31 x 10 33.46 x 10 b 0.4147 x 10 4.233 x 10-5 5.469 x 105 0.6880 x 10-5 0.3191 x 10-8 -2.887 x 108 0.3661 x 10 0.7607 x 108 d -1.965 x 10-12 7.464 x 10-12 -11.00 x 10-12 -3.593 x 10-12 Valid Range for T 0-1500C 0-1500C 0-1200C 0-1500C Develop a well-structured sub procedure in VBA for Excel to calculate the heat capacity of a gas. Your program should have the following characteristics: . . Display a UserForm for the user to enter the input variables of the type of gas and the temperature, with units shown. The selection of the gas should be made with a ComboBox, with the options Air, CO2, CH4, H20 and Other. If one of the first four options is selected, the values for a, b, c, d and upper and lower range for temperature shown in the above table are used (and the values displayed to the user on the UserForm). If Other is chosen, the user can enter the values for a, b, c, d and upper and lower range for temperature. The values of a, b, c, d, temperature range and the resulting Heat Capacity should be displayed on the UserForm. The results should be clearly labelled (with units) for the user. Include a button to perform the calculation, and one to reset the form so that the user can perform another calculation. Write your own function for the heat capacity calculation, which is called by the sub procedure. Error trapping should be included to ensure correct user inputs for all coefficients, the range and that the value entered for the temperature is within the allowable range and is an appropriate number. Dimension all your variables with appropriate data types