CHE110_ModEulerVBA

CHE110_ModEulerVBA - Rose-Hulman Institute of Technology...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
Rose-Hulman Institute of Technology Department of Chemical Engineering CHE 110 - Introduction to Programming & Problem Solving Spring 2006 Workshop 4: Creating A Customized VBA Function to Perform Numerical Solution of an ODE Using the Modified Euler Method Background The modified Euler method is commonly used to solve 1 st order ordinary differential equations (ODEs). The method is shown here for a single ODE with a fixed integration step size, Δ x. () , dy f xy dx = , of x xx ( ) 0 o yx y = 1 , pc ii i i yy f x y x + =+ × Δ ( ) 11 1 0.5 , , cc p i i i i y yf x y f x y x ++ + ⎡⎤ =+× + × Δ ⎣⎦ Objective In Lecture 5, we implemented this method on a worksheet as shown below on the left. The objective of this computer workshop is to develop a customized VBA function procedure called ModEuler that simplifies the worksheet implementation. The VBA function will require that you specify values for the x and y at previous integration step ( i.e. x i and y i ) and a value for the integration step size, Δ x. The function then returns a
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/08/2009 for the course CHE 110 taught by Professor Coronell during the Spring '09 term at Rose-Hulman.

Page1 / 2

CHE110_ModEulerVBA - Rose-Hulman Institute of Technology...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online