MARC record from Internet Archive

LEADER: 07545cam 2201033Ii 4500
001 ocn965604951
003 OCoLC
005 20211104005818.0
008 161208s2016 caua ob 000 0 eng d
006 m eo d
007 cr cn||m|||a||
040 $aCaBNVSL$beng$erda$cJ2I$dJ2I$dOCLCO$dUIU$dUKPUB$dMERER$dOCLCQ$dOTZ$dSNK$dFXR$dAUW$dDKU$dOCLCF$dCEF$dRRP$dOCLCQ$dOCLCO$dCAUOI$dWYU$dVT2$dUKAHL
020 $a9781681744612$q(ebook)
020 $a1681744619$q(ebook)
020 $a9781681744636$q(mobi)
020 $a1681744635$q(mobi)
020 $a1681744600
020 $a9781681744605
020 $z9781681744605$q(print)
024 7 $a10.1088/978-1-6817-4461-2$2doi
024 3 $a9781681744605
035 $a(OCoLC)965604951
037 $b01307586
050 4 $aQC52$b.L544 2016eb
072 7 $aPH$2bicssc
072 7 $aPHU$2bicssc
072 7 $aPHV$2bicssc
072 7 $aSCI055000$2bisacsh
072 7 $aSCI040000$2bisacsh
082 04 $a005.13/3$223
100 1 $aLiengme, Bernard V.,$eauthor.
245 10 $aExcel® VBA for physicists :$ba primer /$cBernard V. Liengme.
246 3 $aExcel® Visual Basic for applications for physicists :$ba primer
264 1 $aSan Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) :$bMorgan & Claypool Publishers,$c[2016]
264 2 $aBristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) :$bIOP Publishing,$c[2016]
300 $a1 online resource (1 volume (various pagings)) :$bcolor illustrations.
336 $atext$btxt$2rdacontent
337 $acomputer$bc$2rdamedia
338 $aonline resource$bcr$2rdacarrier
490 1 $aIOP concise physics,$x2053-2571
500 $a"Version: 20161101"--Title page verso.
500 $a"A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso.
504 $aIncludes bibliographical references.
505 0 $aPreface -- 1. Introduction -- 1.1. Preparation -- 1.2. Demonstrating a simple function -- 1.3. Saving a macro-enabled workbook -- 1.4. Using constants and VB functions -- 1.5. User-defined array function -- 1.6. Notes on VBA functions -- 1.7. A simple subroutine -- 1.8. Linking an image to a subroutine -- 1.9. Recording a macro -- 1.10. Finding a home for macros -- 1.11. Typographical matters.
505 8 $a2. Variables, Dim statements, and data types -- 2.1. Naming variables -- 2.2. The Dim statement -- 2.3. The major reason for variable declarations -- 2.4. Declarations in function headers and for constants -- 2.5. Data types -- 2.6. A second reason for variable declarations -- 2.7. Dimensioning arrays -- 2.8. The Set statement -- 2.9. The With ... End With structure.
505 8 $a3. Structured programming -- 3.1. Branching structures (If and Select Case) -- 3.2. Looping structures (For ... Next and Do ... While/Until) -- 3.3. Some further examples.
505 8 $a4. The Excel object model -- 4.1. Examples of properties, methods and events -- 4.2. The Range object properties -- 4.3. Range object methods -- 4.4. WorksheetFunction object -- 4.5. Workbook and worksheet events -- 4.6. Code for sending email.
505 8 $a5. Working with add-ins -- 5.1. Creating an add-in -- 5.2. Installation -- 5.3. Using the add-in -- 5.4. Making changes to the add-in -- 5.5. Viewing worksheets -- 5.6. Protecting the add-in -- 5.7. Reversing everything.
505 8 $a6. Numerical integration -- 6.1. The trapezoid approximation -- 6.2. The Simpson 1/3 approximation -- 6.3. An aside -- 6.4. Monte Carlo integration -- 6.5. Gaussian and Romberg integration.
505 8 $a7. Numerical methods for differential equations -- 7.1. Euler's method -- 7.2. The Runge-Kutta fourth-order method -- 7.3. Simultaneous OEDs -- 7.4. Example of a system of two OEDs -- 7.5. Higher order OEDs -- 7.6. R-L circuit.
505 8 $a8. Finding roots -- 8.1. The bisection method -- 8.2. The successive iteration method -- 8.3. Root finding with Solver -- 8.4. Using range names.
520 3 $aThis book is both an introduction and a demonstration of how Visual Basic for Applications (VBA) can greatly enhance Microsoft Excel® by giving users the ability to create their own functions within a worksheet and to create subroutines to perform repetitive actions. The book is written so readers are encouraged to experiment with VBA programming with examples using fairly simple physics or non-complicated mathematics such as root finding and numerical integration. Tested Excel® workbooks are available for each chapter and there is nothing to buy or install.
521 $aSuitable for physicists and other scientists and engineers, including students.
545 $aBernard V. Liengme is a Retired Professor of Chemistry and Lecturer in Information Systems of St Francis Xavier University in Nova Scotia, Canada. He is the author of several Microsoft Excel® guides for business and scientists and engineers, and two other titles published with IOP ebooks. Bernard has been awarded the Microsoft Most Valued Professional award in Excel® in eight consecutive years.
500 $aTitle from PDF title page (viewed on December 7, 2016).
506 $aAccess restricted to Ryerson students, faculty and staff.$5CaOTR
630 00 $aVisual Basic.
630 00 $aMicrosoft Excel (Computer file)
650 0 $aPhysics$xData processing.
650 7 $aPhysics.$2bicssc
650 7 $aMathematical Physics.$2bicssc
650 7 $aApplied Physics.$2bicssc
650 7 $aSCIENCE$xPhysics$xGeneral.$2bisacsh
650 7 $aSCIENCE$xPhysics$xMathematical & Computational.$2bisacsh
630 07 $aMicrosoft Excel (Computer file)$2fast$0(OCoLC)fst01366659
650 7 $aPhysics$xData processing.$2fast$0(OCoLC)fst01063041
655 4 $aElectronic books.
710 2 $aMorgan & Claypool Publishers,$epublisher.
710 2 $aInstitute of Physics (Great Britain),$epublisher.
776 08 $iPrint version:$z9781681744605
830 0 $aIOP concise physics.
856 40 $3IOP$uhttp://iopscience.iop.org/book/978-1-6817-4461-2
856 40 $3View book$uhttp://iopscience.iop.org/book/978-1-6817-4461-2
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zIOP Science (Restricted to University of Ottawa)
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zAccess restricted: SMU users only
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zAccess restricted: STFX users only
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zAccess restricted: ACAD users only
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zAccess restricted: DAL users only
856 40 $uhttp://iopscience.iop.org/book/978-1-6817-4461-2$zIOPscience
856 40 $uhttp://uproxy.library.dc-uoit.ca/login?url=http://iopscience.iop.org/book/978-1-6817-4461-2$zeBook available for UOIT via IOP. Click link to access
856 40 $uhttp://proxy.library.carleton.ca/login?url=http://iopscience.iop.org/book/978-1-6817-4461-2$zIOPscience
856 40 $zVIEW FULL TEXT$uhttp://VH7QX3XE2P.search.serialssolutions.com/?V=1.0&L=VH7QX3XE2P&S=AC_T_B&C=Excel%20VBA%20for%20Physicists%3A%20A%20primer&T=marc&tab=BOOKS
856 40 $uhttps://iopscience.iop.org/book/978-1-6817-4461-2
856 40 $uhttp://www.vlebooks.com/vleweb/product/openreader?id=none&isbn=9781681744612
938 $aAskews and Holts Library Services$bASKH$nAH32889902
938 $aIOP Publishing$bIOPE$n9781681744612
029 1 $aAU@$b000059792045
994 $aZ0$bP4A
948 $hNO HOLDINGS IN P4A - 108 OTHER HOLDINGS