Excel� VBA for physicists : (Record no. 46984)

MARC details
000 -LEADER
fixed length control field 05746nam a2200793 i 4500
001 - CONTROL NUMBER
control field 9781681744612
003 - CONTROL NUMBER IDENTIFIER
control field IOP
005 - DATE AND TIME OF LATEST TRANSACTION
control field 20190906141358.0
006 - FIXED-LENGTH DATA ELEMENTS--ADDITIONAL MATERIAL CHARACTERISTICS
fixed length control field m eo d
007 - PHYSICAL DESCRIPTION FIXED FIELD--GENERAL INFORMATION
fixed length control field cr cn |||m|||a
008 - FIXED-LENGTH DATA ELEMENTS--GENERAL INFORMATION
fixed length control field 161207s2016 caua ob 000 0 eng d
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781681744612
Qualifying information ebook
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
International Standard Book Number 9781681744636
Qualifying information mobi
020 ## - INTERNATIONAL STANDARD BOOK NUMBER
Canceled/invalid ISBN 9781681744605
Qualifying information print
024 7# - OTHER STANDARD IDENTIFIER
Standard number or code 10.1088/978-1-6817-4461-2
Source of number or code doi
035 ## - SYSTEM CONTROL NUMBER
System control number (CaBNVSL)thg00972038
035 ## - SYSTEM CONTROL NUMBER
System control number (OCoLC)965604951
040 ## - CATALOGING SOURCE
Original cataloging agency CaBNVSL
Language of cataloging eng
Description conventions rda
Transcribing agency CaBNVSL
Modifying agency CaBNVSL
050 #4 - LIBRARY OF CONGRESS CALL NUMBER
Classification number QC52
Item number .L544 2016eb
072 #7 - SUBJECT CATEGORY CODE
Subject category code PH
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code PHU
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code PHV
Source bicssc
072 #7 - SUBJECT CATEGORY CODE
Subject category code SCI055000
Source bisacsh
072 #7 - SUBJECT CATEGORY CODE
Subject category code SCI040000
Source bisacsh
082 04 - DEWEY DECIMAL CLASSIFICATION NUMBER
Classification number 005.13/3
Edition number 23
100 1# - MAIN ENTRY--PERSONAL NAME
Personal name Liengme, Bernard V.,
Relator term author.
245 10 - TITLE STATEMENT
Title Excel� VBA for physicists :
Remainder of title a primer /
Statement of responsibility, etc. Bernard V. Liengme.
246 3# - VARYING FORM OF TITLE
Title proper/short title Excel� Visual Basic for applications for physicists : a primer.
264 #1 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Place of production, publication, distribution, manufacture San Rafael [California] (40 Oak Drive, San Rafael, CA, 94903, USA) :
Name of producer, publisher, distributor, manufacturer Morgan & Claypool Publishers,
Date of production, publication, distribution, manufacture, or copyright notice [2016]
264 #2 - PRODUCTION, PUBLICATION, DISTRIBUTION, MANUFACTURE, AND COPYRIGHT NOTICE
Place of production, publication, distribution, manufacture Bristol [England] (Temple Circus, Temple Way, Bristol BS1 6HG, UK) :
Name of producer, publisher, distributor, manufacturer IOP Publishing,
Date of production, publication, distribution, manufacture, or copyright notice [2016]
300 ## - PHYSICAL DESCRIPTION
Extent 1 online resource (various pagings) :
Other physical details color illustrations.
336 ## - CONTENT TYPE
Content type term text
Source rdacontent
337 ## - MEDIA TYPE
Media type term electronic
Source isbdmedia
338 ## - CARRIER TYPE
Carrier type term online resource
Source rdacarrier
490 1# - SERIES STATEMENT
Series statement [IOP release 3]
490 1# - SERIES STATEMENT
Series statement IOP concise physics,
International Standard Serial Number 2053-2571
500 ## - GENERAL NOTE
General note "Version: 20161101"--Title page verso.
500 ## - GENERAL NOTE
General note "A Morgan & Claypool publication as part of IOP Concise Physics"--Title page verso.
504 ## - BIBLIOGRAPHY, ETC. NOTE
Bibliography, etc Includes bibliographical references.
505 0# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - FORMATTED CONTENTS NOTE
Formatted contents note 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# - SUMMARY, ETC.
Summary, etc. 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 ## - TARGET AUDIENCE NOTE
Target audience note Suitable for physicists and other scientists and engineers, including students.
530 ## - ADDITIONAL PHYSICAL FORM AVAILABLE NOTE
Additional physical form available note Also available in print.
538 ## - SYSTEM DETAILS NOTE
System details note Mode of access: World Wide Web.
538 ## - SYSTEM DETAILS NOTE
System details note System requirements: Adobe Acrobat Reader.
545 ## - BIOGRAPHICAL OR HISTORICAL DATA
Biographical or historical data 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 ## - SOURCE OF DESCRIPTION NOTE
Source of description note Title from PDF title page (viewed on December 7, 2016).
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Visual Basic.
630 00 - SUBJECT ADDED ENTRY--UNIFORM TITLE
Uniform title Microsoft Excel (Computer file)
650 #0 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Physics
General subdivision Data processing.
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Physics.
Source of heading or term bicssc
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Mathematical Physics.
Source of heading or term bicssc
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element Applied Physics.
Source of heading or term bicssc
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element SCIENCE / Physics / General.
Source of heading or term bisacsh
650 #7 - SUBJECT ADDED ENTRY--TOPICAL TERM
Topical term or geographic name as entry element SCIENCE / Physics / Mathematical & Computational.
Source of heading or term bisacsh
710 2# - ADDED ENTRY--CORPORATE NAME
Corporate name or jurisdiction name as entry element Morgan & Claypool Publishers,
Relator term publisher.
710 2# - ADDED ENTRY--CORPORATE NAME
Corporate name or jurisdiction name as entry element Institute of Physics (Great Britain),
Relator term publisher.
776 08 - ADDITIONAL PHYSICAL FORM ENTRY
Relationship information Print version:
International Standard Book Number 9781681744605
830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE
Uniform title IOP (Series).
Name of part/section of a work Release 3.
830 #0 - SERIES ADDED ENTRY--UNIFORM TITLE
Uniform title IOP concise physics.
856 40 - ELECTRONIC LOCATION AND ACCESS
Uniform Resource Identifier <a href="https://iopscience.iop.org/book/978-1-6817-4461-2">https://iopscience.iop.org/book/978-1-6817-4461-2</a>
Holdings
Withdrawn status Lost status Source of classification or shelving scheme Damaged status Not for loan Home library Current library Date acquired Full call number Barcode Date last seen Price effective from Koha item type
    Dewey Decimal Classification     BITS Pilani Hyderabad BITS Pilani Hyderabad 06/09/2019 005.13/3 IOP00027 06/09/2019 06/09/2019 Institue of Physics
An institution deemed to be a University Estd. Vide Sec.3 of the UGC
Act,1956 under notification # F.12-23/63.U-2 of Jun 18,1964
© 2024 BITS-Library, BITS-Hyderabad, India.