Cargando…

Excel® VBA for physicists : a primer /

This 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 a...

Descripción completa

Detalles Bibliográficos
Clasificación:Libro Electrónico
Autor principal: Liengme, Bernard V. (Autor)
Formato: Electrónico eBook
Idioma:Inglés
Publicado: San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) : Morgan & Claypool Publishers, [2016]
Colección:IOP (Series). Release 3.
IOP concise physics.
Temas:
Acceso en línea:Texto completo

MARC

LEADER 00000nam a2200000 4500
001 IOP_9781681744612
003 IOP
005 20161208204624.0
006 m eo d
007 cr cn |||m|||a
008 161207s2016 caua ob 000 0 eng d
020 |a 9781681744612  |q ebook 
020 |a 9781681744636  |q mobi 
020 |z 9781681744605  |q print 
024 7 |a 10.1088/978-1-6817-4461-2  |2 doi 
035 |a (CaBNVSL)thg00972038 
035 |a (OCoLC)965604951 
040 |a CaBNVSL  |b eng  |e rda  |c CaBNVSL  |d CaBNVSL 
050 4 |a QC52  |b .L544 2016eb 
072 7 |a PH  |2 bicssc 
072 7 |a PHU  |2 bicssc 
072 7 |a PHV  |2 bicssc 
072 7 |a SCI055000  |2 bisacsh 
072 7 |a SCI040000  |2 bisacsh 
082 0 4 |a 005.13/3  |2 23 
100 1 |a Liengme, Bernard V.,  |e author. 
245 1 0 |a Excel® VBA for physicists :  |b a primer /  |c Bernard V. Liengme. 
246 3 |a Excel® Visual Basic for applications for physicists : a primer. 
264 1 |a San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) :  |b Morgan & Claypool Publishers,  |c [2016] 
264 2 |a Bristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) :  |b IOP Publishing,  |c [2016] 
300 |a 1 online resource (various pagings) :  |b color illustrations. 
336 |a text  |2 rdacontent 
337 |a electronic  |2 isbdmedia 
338 |a online resource  |2 rdacarrier 
490 1 |a [IOP release 3] 
490 1 |a IOP concise physics,  |x 2053-2571 
500 |a "Version: 20161101"--Title page verso. 
500 |a "A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso. 
504 |a Includes bibliographical references. 
505 0 |a Preface -- 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 |a 2. 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 |a 3. 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 |a 4. 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 |a 5. 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 |a 6. 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 |a 7. 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 |a 8. 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 |a This 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 |a Suitable for physicists and other scientists and engineers, including students. 
530 |a Also available in print. 
538 |a Mode of access: World Wide Web. 
538 |a System requirements: Adobe Acrobat Reader. 
545 |a Bernard 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. 
588 |a Title from PDF title page (viewed on December 7, 2016). 
630 0 0 |a Visual Basic. 
630 0 0 |a Microsoft Excel (Computer file) 
650 0 |a Physics  |x Data processing. 
650 7 |a Physics.  |2 bicssc 
650 7 |a Mathematical Physics.  |2 bicssc 
650 7 |a Applied Physics.  |2 bicssc 
650 7 |a SCIENCE / Physics / General.  |2 bisacsh 
650 7 |a SCIENCE / Physics / Mathematical & Computational.  |2 bisacsh 
710 2 |a Morgan & Claypool Publishers,  |e publisher. 
710 2 |a Institute of Physics (Great Britain),  |e publisher. 
776 0 8 |i Print version:  |z 9781681744605 
830 0 |a IOP (Series).  |p Release 3. 
830 0 |a IOP concise physics. 
856 4 0 |u https://iopscience.uam.elogim.com/book/978-1-6817-4461-2  |z Texto completo