Differential equation solution Excel

For those first-order equations that cannot be expressed in polynomial form, there is no single analytical method to produce a solution as seen earlier in Section 2.1. This difficulty increases the importance of the issues of existence and uniqueness of a solution. For a very lucid discussion on the existence and uniqueness theorem for nonlinear first-order differential equations, many excellent texts are available [1,2]. 

The method of weighted residuals is a way of reducing the number of independent variables or the problem domain dimension. The basic idea of the method is to approximate the solution of the problem over a domain by a functional form called a trial function. The trial function s form is specified but it has adjustable constants. The trial function is chosen so as to give a good solution to the original differential equation. An excellent treatment of the method is given in the book by Finlayson (1972). As an example of how the method works, let us consider the heat conduction equation... 

Stability, Bifurcations, Limit Cycles Some aspects of this subject involve the solution of nonlinear equations other aspects involve the integration of ordinaiy differential equations apphcations include chaos and fractals as well as unusual operation of some chemical engineering eqmpment. Ref. 176 gives an excellent introduction to the subject and the details needed to apply the methods. Ref. 66 gives more details of the algorithms. A concise survey with some chemical engineering examples is given in Ref. 91. Bifurcation results are closely connected with stabihty of the steady states, which is essentially a transient phenomenon. 

A numerical solution of the Schrodinger equation in Eq. [1] often starts with the discretization of the wave function. Discretization is necessary because it converts the differential equation to a matrix form, which can then be readily handled by a digital computer. This process is typically done using a set of basis functions in a chosen coordinate system. As discussed extensively in the literature,5,9-11 the proper choice of the coordinate system and the basis functions is vital in minimizing the size of the problem and in providing a physically relevant interpretation of the solution. However, this important topic is out of the scope of this review and we will only discuss some related issues in the context of recursive diagonalization. Interested readers are referred to other excellent reviews on this topic.5,9,10... 

Because of the excellent agreement between experimental measurements and the values calculated on the basis of the Enskog theory, empirical formulas are not needed. Sometimes, however, it is convenient to have empirical formulas available for rapid calculations or for use in analytical solutions to differential equations. Some empirical relations have been assembled by Partington (PI). 

This appendix provides a detailed description of how to build Excel spreadsheet solutions for several of the problems that were presented and solved in Chapter 4. Generically, these include an ordinary-differential-equation boundary-value problem, a one-dimensional parabolic partial differential equation, and a two-dimensional elliptic partial differential equation. 

This is not the place for a treatise on the solution of differential equations, ordinary or partial. There are some excellent mathematical texts and some, such as Varma and Morbidelli s Mathematical Methods in Chemical Engineering (Oxford University Press, 1997), are specifically directed at the chemical engineer. What we shall try to do, however, is to explore some of the ad hoc methods that take advantage of peculiar features of particular problems and those that give partial solutions, as well as mentioning a few fall-traps for the unwary. 

INTRODUCTION TO LINEAR ALGEBRA AND DIFFERENTIAL EQUATIONS, John W. Dettman. Excellent text covers complex numbers, determinants, orthonormal bases, Laplace transforms, much more. Exercises with solutions. Undergraduate level. 416pp. 5k x 8k. 65191-6 Pa. 8.95... 

The values for the singlet energy transfer rate constants k and k do not appear directly in the experimental decays. Solution of a set of rate differential equations using the experimentally measured lifetimes of 12 ps and 700 ps as constants yields values of 2.0 x 10 s for ki and 4.1 x 10 s for k. The value thus obtained for ki is in excellent agreement with the results of Hsiao and coworkers [245], who... 

However, one useful technique is the method of Laplace transforms. An excellent tutorial is presented in the two papers by Mayersohn and Gibaldi. Benet and Turi, and Benet present more advanced techniques, such as the input and output disposition functions and the fingerprint technique for the solution of differential equations. 

Finally, in 65 there is for the first time a detailed presentation of the exponential fitting. This is an excellent book in which one can find reference work for the exponential fitting applied to differentiation, to integration and to the solution of differential equations. In chapter 2, some mathematical properties are studied and the mathematical theory of exponential fitting is presented. 

Helfferich (1997) and Rhee, Aris, and Amundson (1970, 1986, 1989), who derived instructive analytical solutions of the first-order system of nonlinear partial differential equations given by Equation 6.43. Most of the solutions are available for multicomponent Langmuir isotherms. Interested readers will find in the excellent treatment of Rhee et al. the basics of the method of characteristics applied to derive the solutions and to explain the wave phenomena that take place in chromatographic columns. 

C. Johnson. Numerical solution of Partial Differential Equations by the Finite Element Method. Cambridge University Press, Cambridge, 1990. An excellent introductory book on the finite element method. The text assumes mathematical background of first year graduate students in applied mathematics and computer science. An excellent introduction to the theory of adaptive methods. 

Strauss, Walter A. Partial Differential Equations An Introduction. 2d ed. Hoboken, N.J. John Wiley Sons, 2008. An excellent introduction to the numeric solution of partial differential equations. 

The treatment presented in Chapts. 3 and 4 is sufficient for digital simulation of all but particularly difficult cases. This chapter deals with some efficiency improvements, giving most emphasis to the more practical schemes. For an excellent mathematical text on the numerical solution of partial differential equations, see Lapidus and Finder (1982). ... 

In this relation, x denotes the fluid front position as a function of time t, system architecture a and b, and intrinsic material properties including contact angles of the fluid upon the hydrophiUc and hydrophobic materials 9i and 02 > respectively. The solution to this second order ordinary differential equation with respect to meniscus position squared can be solved relatively easy through numerical techniques. The solution determined by the investigators of this approach is in excellent agreement with experimental results [11]. Furthermore, the investigators demonstrated that confluent monolayers of cells could be cultured in their apparatus and proteins could be selectively adsorbed upon the device surface [11]. Consequently, the surface-directed approach may be advantageous for appli-... 

Analytical solutions of partial differential eqttations ate generally not easy to find. However, excellent and accurate numerical approxitnatiotrs are available today to solve this set of partial differential equations to find the response of one process variable to a change in another process variable. 

---