The Resource Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Resource Information
The item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Sydney Jones Library, University of Liverpool.This item is available to borrow from 1 library branch.
Resource Information
The item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book) represents a specific, individual, material embodiment of a distinct intellectual or artistic creation found in Sydney Jones Library, University of Liverpool.
This item is available to borrow from 1 library branch.
 Summary
 This book demonstrates some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly Excel is never going to outperform the wonderful symbolic algebra tools that we have today  Mathematica, Mathcad, Maple, MATLAB, etc. However, from a pedagogical stance Excel has the advantage of not being a 'black box' approach to problem solving. The user must do a lot more work than just call up a function. The intermediate steps in a calculation are displayed on the worksheet. Another advantage is the somewhat less steep learning curve. This book shows Excel in action in various areas within Physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA. Those with programming experience in any other language should be able to follow the code
 Language
 eng
 Extent
 1 online resource (96 pages)
 Note

 "Version: 20141001"Title page verso
 "A Morgan & Claypool publication as part of IOP Concise Physics"Title page verso
 Contents

 Preface  Acknowledgments  Author biography
 Projectile trajectory  Football trajectory  Adding air resistance
 The pursuit problem  The numerical approach  Comparison with the analytical solution
 Equation solving with and without Solver  The van der Waals equation : the fixed point iteration method  van der Waals equation : using Solver  Finding roots graphically  NewtonRaphson method  Using Solver to obtain multiple roots  The secant method and goal seek  The inverse quadratic method  Solving systems of linear equations  Solving a system of nonlinear equations  Closing note on Solver
 Temperature profile  A formula method  A matrix method  A Solver method
 Numerical integration  Trapezoid rule and Simpson's 1/3 rule  Centroid of a plane using Simpson's 1/3 rule  Monte Carlo method I  Monte Carlo method II  Buffon's needle
 Approximate solutions to differential equations  Ordinary differential equations (ODEs)  Euler's method  The RungeKutta method  Testing for convergence  Systems of ODEs and secondorder ODEs
 Superposition of sine waves and Fourier series  Addition of sine waves; generation of beats  Fourier series  Parametric plots and Lissajous curves
 Fast Fourier transform
 Applying statistics to experimental data  Comparing averages  Comparing variances  Are my data normally distributed?
 Electrostatics  Coulomb's law  Electrostatic potential  Discrete form of Laplace equation
 Random events  Random walk and Brownian motion  A random selfavoiding walk
 Isbn
 9781627054195
 Label
 Modelling physics with Microsoft Excel
 Title
 Modelling physics with Microsoft Excel
 Statement of responsibility
 Bernard V. Liengme
 Title variation
 Modeling physics with Microsoft Excel
 Language
 eng
 Summary
 This book demonstrates some of the ways in which Microsoft Excel may be used to solve numerical problems in the field of physics. But why use Excel in the first place? Certainly Excel is never going to outperform the wonderful symbolic algebra tools that we have today  Mathematica, Mathcad, Maple, MATLAB, etc. However, from a pedagogical stance Excel has the advantage of not being a 'black box' approach to problem solving. The user must do a lot more work than just call up a function. The intermediate steps in a calculation are displayed on the worksheet. Another advantage is the somewhat less steep learning curve. This book shows Excel in action in various areas within Physics. Some Visual Basic for Applications (VBA) has been introduced, the purpose here is to show how the power of Excel can be greatly extended and hopefully to whet the appetite of a few readers to get familiar with the power of VBA. Those with programming experience in any other language should be able to follow the code
 Cataloging source
 CaBNVSL
 http://library.link/vocab/creatorName
 Liengme, Bernard V
 Illustrations
 illustrations
 Index
 no index present
 Intended audience
 Professional and scholarly
 LC call number
 QA76.95
 LC item number
 .L546eb
 Literary form
 non fiction
 Nature of contents

 dictionaries
 bibliography
 http://library.link/vocab/subjectName

 Physics
 Mathematics
 Electronic spreadsheets
 Mathematical modelling
 SCIENCE / Physics / Mathematical & Computational
 Target audience
 adult
 Label
 Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
 Note

 "Version: 20141001"Title page verso
 "A Morgan & Claypool publication as part of IOP Concise Physics"Title page verso
 Bibliography note
 Includes bibliographical references
 Carrier category
 online resource
 Carrier MARC source
 rdacarrier
 Color
 black and white
 Content category
 text
 Content type MARC source
 rdacontent
 Contents

 Preface  Acknowledgments  Author biography
 Projectile trajectory  Football trajectory  Adding air resistance
 The pursuit problem  The numerical approach  Comparison with the analytical solution
 Equation solving with and without Solver  The van der Waals equation : the fixed point iteration method  van der Waals equation : using Solver  Finding roots graphically  NewtonRaphson method  Using Solver to obtain multiple roots  The secant method and goal seek  The inverse quadratic method  Solving systems of linear equations  Solving a system of nonlinear equations  Closing note on Solver
 Temperature profile  A formula method  A matrix method  A Solver method
 Numerical integration  Trapezoid rule and Simpson's 1/3 rule  Centroid of a plane using Simpson's 1/3 rule  Monte Carlo method I  Monte Carlo method II  Buffon's needle
 Approximate solutions to differential equations  Ordinary differential equations (ODEs)  Euler's method  The RungeKutta method  Testing for convergence  Systems of ODEs and secondorder ODEs
 Superposition of sine waves and Fourier series  Addition of sine waves; generation of beats  Fourier series  Parametric plots and Lissajous curves
 Fast Fourier transform
 Applying statistics to experimental data  Comparing averages  Comparing variances  Are my data normally distributed?
 Electrostatics  Coulomb's law  Electrostatic potential  Discrete form of Laplace equation
 Random events  Random walk and Brownian motion  A random selfavoiding walk
 Control code
 9781627054195
 Dimensions
 unknown
 Extent
 1 online resource (96 pages)
 File format
 multiple file formats
 Form of item
 online
 Isbn
 9781627054195
 Media category
 electronic
 Media MARC source
 isbdmedia
 Other control number
 10.1088/9781627054195
 Other physical details
 illustrations.
 Reformatting quality
 access
 Specific material designation
 remote
 System details

 "The workbooks for this project were made using Excel 2013 but they should all work with the earlier Excel 2007 or Excel 2010 versions" Preface
 System requirements: Adobe Acrobat Reader
 Label
 Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
 Note

 "Version: 20141001"Title page verso
 "A Morgan & Claypool publication as part of IOP Concise Physics"Title page verso
 Bibliography note
 Includes bibliographical references
 Carrier category
 online resource
 Carrier MARC source
 rdacarrier
 Color
 black and white
 Content category
 text
 Content type MARC source
 rdacontent
 Contents

 Preface  Acknowledgments  Author biography
 Projectile trajectory  Football trajectory  Adding air resistance
 The pursuit problem  The numerical approach  Comparison with the analytical solution
 Equation solving with and without Solver  The van der Waals equation : the fixed point iteration method  van der Waals equation : using Solver  Finding roots graphically  NewtonRaphson method  Using Solver to obtain multiple roots  The secant method and goal seek  The inverse quadratic method  Solving systems of linear equations  Solving a system of nonlinear equations  Closing note on Solver
 Temperature profile  A formula method  A matrix method  A Solver method
 Numerical integration  Trapezoid rule and Simpson's 1/3 rule  Centroid of a plane using Simpson's 1/3 rule  Monte Carlo method I  Monte Carlo method II  Buffon's needle
 Approximate solutions to differential equations  Ordinary differential equations (ODEs)  Euler's method  The RungeKutta method  Testing for convergence  Systems of ODEs and secondorder ODEs
 Superposition of sine waves and Fourier series  Addition of sine waves; generation of beats  Fourier series  Parametric plots and Lissajous curves
 Fast Fourier transform
 Applying statistics to experimental data  Comparing averages  Comparing variances  Are my data normally distributed?
 Electrostatics  Coulomb's law  Electrostatic potential  Discrete form of Laplace equation
 Random events  Random walk and Brownian motion  A random selfavoiding walk
 Control code
 9781627054195
 Dimensions
 unknown
 Extent
 1 online resource (96 pages)
 File format
 multiple file formats
 Form of item
 online
 Isbn
 9781627054195
 Media category
 electronic
 Media MARC source
 isbdmedia
 Other control number
 10.1088/9781627054195
 Other physical details
 illustrations.
 Reformatting quality
 access
 Specific material designation
 remote
 System details

 "The workbooks for this project were made using Excel 2013 but they should all work with the earlier Excel 2007 or Excel 2010 versions" Preface
 System requirements: Adobe Acrobat Reader
Library Links
Embed
Settings
Select options that apply then copy and paste the RDF/HTML data fragment to include in your application
Embed this data in a secure (HTTPS) page:
Layout options:
Include data citation:
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.liverpool.ac.uk/portal/ModellingphysicswithMicrosoftExcelBernard/wZY3drB4lBo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.liverpool.ac.uk/portal/ModellingphysicswithMicrosoftExcelBernard/wZY3drB4lBo/">Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.liverpool.ac.uk/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.liverpool.ac.uk/">Sydney Jones Library, University of Liverpool</a></span></span></span></span></div>
Note: Adjust the width and height settings defined in the RDF/HTML code fragment to best match your requirements
Preview
Cite Data  Experimental
Data Citation of the Item Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)
Copy and paste the following RDF/HTML data fragment to cite this resource
<div class="citation" vocab="http://schema.org/"><i class="fa faexternallinksquare fafw"></i> Data from <span resource="http://link.liverpool.ac.uk/portal/ModellingphysicswithMicrosoftExcelBernard/wZY3drB4lBo/" typeof="Book http://bibfra.me/vocab/lite/Item"><span property="name http://bibfra.me/vocab/lite/label"><a href="http://link.liverpool.ac.uk/portal/ModellingphysicswithMicrosoftExcelBernard/wZY3drB4lBo/">Modelling physics with Microsoft Excel, Bernard V. Liengme, (electronic book)</a></span>  <span property="potentialAction" typeOf="OrganizeAction"><span property="agent" typeof="LibrarySystem http://library.link/vocab/LibrarySystem" resource="http://link.liverpool.ac.uk/"><span property="name http://bibfra.me/vocab/lite/label"><a property="url" href="http://link.liverpool.ac.uk/">Sydney Jones Library, University of Liverpool</a></span></span></span></span></div>