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...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| 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 |