1. Create a User defined VBA Function that calculates the rate of diffusion (diffusivity) of te. Carbon in Iron (Fe). Make sure that the function is in a module. See page 2 for equation and values 2. Input the values of Temperature from 50 C to 120o eC in steps of 50 degrees on the spreadsheet. Note the temperature in the calculation is in Kelvin. ate the values of the rate of Diffusion (Diffusivity) for Write a VBA sub routine that will calculate both the alpha and gamma iron (Fe) and write the rate of Diffusion to the s values for Diffusivity will b values 3. e on the order of (e-27 -e-05) a Use the user defined function from part 1 (above) to calculate diffusivity in the sub function for both alpha and gamma Fe. routine. Use only one user defined b. Use in your subroutine: number of temperature values for i = 1 to n where n is the next i Offset commands to move around the spreadsheet. ( do not use arrays) The program must calculate the diffusivity for all values of temperature for both Alpha and Gamma Fe. Convert to Kelvin in the sub program. Temperature Celsius Kelvin Alpha Fe Gamma Fe 100 450 500 750 950 1000 1050 1100 1150 1. Create a User defined VBA Function that calculates the rate of diffusion (diffusivity) of te. Carbon in Iron (Fe). Make sure that the function is in a module. See page 2 for equation and values 2. Input the values of Temperature from 50 C to 120o eC in steps of 50 degrees on the spreadsheet. Note the temperature in the calculation is in Kelvin. ate the values of the rate of Diffusion (Diffusivity) for Write a VBA sub routine that will calculate both the alpha and gamma iron (Fe) and write the rate of Diffusion to the s values for Diffusivity will b values 3. e on the order of (e-27 -e-05) a Use the user defined function from part 1 (above) to calculate diffusivity in the sub function for both alpha and gamma Fe. routine. Use only one user defined b. Use in your subroutine: number of temperature values for i = 1 to n where n is the next i Offset commands to move around the spreadsheet. ( do not use arrays) The program must calculate the diffusivity for all values of temperature for both Alpha and Gamma Fe. Convert to Kelvin in the sub program. Temperature Celsius Kelvin Alpha Fe Gamma Fe 100 450 500 750 950 1000 1050 1100 1150