Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

1. Create a User defined VBA Function that calculates the rate of diffusion (diffusivity) of nd Carbon in Iron (Fe). Make sure that the function

image text in transcribed
image text in transcribed
1. Create a User defined VBA Function that calculates the rate of diffusion (diffusivity) of nd Carbon in Iron (Fe). Make sure that the function is in a module. See page 2 for eq values. 2. Input the values of Temperature from 50 C to 1200 -C in steps of 50 degrees on the spreadsheet. Note the temperature in the calculation is in Kelvin. 3. Write a VBA sub routine that will calculate the values of the rate of Diffusion (Diffusivity) for both the alpha and gamma iron (Fe) and write the rate of Diffusion to the spreadsheet. values for Diffusivity will be on the order of e-27-e-05) Use the user defined function from part 1 (above) to calculate diffusivity in the sub routine. Use only one user defined function for both alpha and gamma Fe. Use in your subroutine: a. b. for i-1 to n where n is the number of temperature values 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 Diffusivity Alpha Fe Gamma Fe Kelvin 100 200 300 350 400 450 500 550 650 700 750 800 850 900 950 1000 1050 1100 1150 1200

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Database Design Query Formulation And Administration Using Oracle And PostgreSQL

Authors: Michael Mannino

8th Edition

1948426951, 978-1948426954

More Books

Students also viewed these Databases questions