Excel for scientists and engineers : numerical methods /
Billo, E. Joseph.
Excel for scientists and engineers : numerical methods / E. Joseph Billo. - Hoboken, N.J. : Wiley-Interscience, c2007. - xix, 454 p. : ill. ; 26 cm.
Includes bibliographical references (p. 429) and index.
Introducing visual basic for applications -- Fundamentals of programming with VBA -- Worksheet functions for working with matrices -- Number series -- Interpolation -- Differentiation -- Integration -- Roots of equations -- Systems of simultaneous equations -- Numerical integration of ordinary differential equations part I : initial conditions -- Numerical integration of ordinary differential equations part II : boundary conditions -- Partial differential equations -- Linear regression and curve fitting -- Nonlinear regression using the solver -- Random numbers and the Monte Carlo method. Table of contents
With this text as your guide, you can significantly enhance Microsoft Excels capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's capabilities, although you can still use the text without learning VBA." "This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package."--Jacket
9780471387343 0471387347
2006052999
Engineering--Data processing.
Science--Data processing.
Electronic spreadsheets.
620.00285 / BIE 2007
Excel for scientists and engineers : numerical methods / E. Joseph Billo. - Hoboken, N.J. : Wiley-Interscience, c2007. - xix, 454 p. : ill. ; 26 cm.
Includes bibliographical references (p. 429) and index.
Introducing visual basic for applications -- Fundamentals of programming with VBA -- Worksheet functions for working with matrices -- Number series -- Interpolation -- Differentiation -- Integration -- Roots of equations -- Systems of simultaneous equations -- Numerical integration of ordinary differential equations part I : initial conditions -- Numerical integration of ordinary differential equations part II : boundary conditions -- Partial differential equations -- Linear regression and curve fitting -- Nonlinear regression using the solver -- Random numbers and the Monte Carlo method. Table of contents
With this text as your guide, you can significantly enhance Microsoft Excels capabilities to execute the calculations needed to solve a variety of chemical, biochemical, physical, engineering, biological, and medicinal problems. The text begins with two chapters that introduce you to Excel's Visual Basic for Applications (VBA) programming language, which allows you to expand Excel's capabilities, although you can still use the text without learning VBA." "This text does not require any background in programming, so it is suitable for both undergraduate and graduate courses. Moreover, practitioners in science and engineering will find that this guide saves hours of time by enabling them to perform most of their calculations with one familiar spreadsheet package."--Jacket
9780471387343 0471387347
2006052999
Engineering--Data processing.
Science--Data processing.
Electronic spreadsheets.
620.00285 / BIE 2007