Excel scientific and engineering cookbook:
Suitable for those who want to improve upon their Excel skills, this book teaches how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. It shows how to: use Excel and VBA in general; import data from a variety of sources; analyze dat...
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Beijing [u.a.]
O'Reilly
2006
|
| Ausgabe: | 1. ed. |
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Zusammenfassung: | Suitable for those who want to improve upon their Excel skills, this book teaches how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. It shows how to: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; and more. Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it - instead of FORTRAN - to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now, the "Excel Scientific and Engineering Cookbook" shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; visualize the results for interpretation and presentation; and use Excel to solve specific science and engineering problems Wherever possible, the "Excel Scientific and Engineering Cookbook" draws on real-world examples from a range of scientific disciplines, such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away |
| Beschreibung: | XV, 424 S. Ill. |
| ISBN: | 0596008791 9780596008796 |
Internformat
MARC
| LEADER | 00000nam a2200000 c 4500 | ||
|---|---|---|---|
| 001 | BV021489726 | ||
| 003 | DE-604 | ||
| 005 | 20150108 | ||
| 007 | t | ||
| 008 | 060224s2006 a||| |||| 00||| eng d | ||
| 016 | 7 | |a 976879514 |2 DE-101 | |
| 020 | |a 0596008791 |c Kt. : EUR 43.00 (freier Pr.), EUR 46.50 (AT) (freier Pr.), sfr 71.90 (freier Pr.) |9 0-596-00879-1 | ||
| 020 | |a 9780596008796 |9 978-0-596-00879-6 | ||
| 024 | 3 | |a 9780596008796 | |
| 035 | |a (OCoLC)474951185 | ||
| 035 | |a (DE-599)BVBBV021489726 | ||
| 040 | |a DE-604 |b ger |e rakddb | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-1051 |a DE-384 |a DE-703 | ||
| 084 | |a ST 371 |0 (DE-625)143672: |2 rvk | ||
| 084 | |a ST 620 |0 (DE-625)143684: |2 rvk | ||
| 084 | |a 004 |2 sdnb | ||
| 100 | 1 | |a Bourg, David M. |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel scientific and engineering cookbook |c David M. Bourg |
| 250 | |a 1. ed. | ||
| 264 | 1 | |a Beijing [u.a.] |b O'Reilly |c 2006 | |
| 300 | |a XV, 424 S. |b Ill. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 520 | |a Suitable for those who want to improve upon their Excel skills, this book teaches how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. It shows how to: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; and more. Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it - instead of FORTRAN - to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now, the "Excel Scientific and Engineering Cookbook" shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; visualize the results for interpretation and presentation; and use Excel to solve specific science and engineering problems | ||
| 520 | |a Wherever possible, the "Excel Scientific and Engineering Cookbook" draws on real-world examples from a range of scientific disciplines, such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away | ||
| 650 | 4 | |a Regneark | |
| 650 | 4 | |a Statistikprogrammer | |
| 650 | 4 | |a Statistisk databehandling | |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HEBIS Datenaustausch Darmstadt |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014706576&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-014706576 | ||
Datensatz im Suchindex
| _version_ | 1804135215883354112 |
|---|---|
| adam_text | EXCEL SCIENTIFIC AND ENGINEERING COOKBOOK DAVID M. BOURG O REILLY*
BEIJING * CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI *
TOKYO TABLE OF CONTENTS PREFACE XI 1. USING EXCEL 1 1.1 NAVIGATING THE
INTERFACE 1 1.2 ENTERING DATA 7 1.3 SETTING CELL DATA TYPES 9 1.4
SELECTING MORE THAN A SINGLE CELL 13 1.5 ENTERING FORMULAS 14 1.6
EXPLORING THE R1C1 CELL REFERENCE STYLE 19 1.7 REFERRING TO MORE THAN A
SINGLE CELL 21 1.8 UNDERSTANDING OPERATOR PRECEDENCE 21 1.9 USING
EXPONENTS IN FORMULAS 22 1.10 EXPLORING FUNCTIONS 22 1.11 FORMATTING
YOUR SPREADSHEETS 26 1.12 DEFINING CUSTOM FORMAT STYLES 29 1.13
LEVERAGING COPY, CUT, PASTE, AND PASTE SPECIAL 30 1.14 USING CELL NAMES
(LIKE PROGRAMMING VARIABLES) 32 1.15 VALIDATING DATA ., 34 1.16 TAKING
ADVANTAGE OF MACROS . 35 1.17 ADDING COMMENTS AND EQUATION NOTES 37 1.18
GETTING HELP 40 2. GETTING ACQUAINTED WITH VISUAL BASIC FOR APPLICATIONS
41 2.1 NAVIGATING THE VBA EDITOR 42 2.2 WRITING FUNCTIONS AND
SUBROUTINES 45 2.3 WORKING WITH DATA TYPES 49 2.4 DEFINING VARIABLES 50
2.5 DEFINING CONSTANTS 52 2.6 USING ARRAYS 53 2.7 COMMENTING CODE 54 2.8
SPANNING LONG STATEMENTS OVER MULTIPLE LINES 55 2.9 USING CONDITIONAL
STATEMENTS 55 2.10 USING LOOPS 56 2.11 DEBUGGING VBA CODE 59 2.12
EXPLORING VBA S BUILT-IN FUNCTIONS 62 2.13 EXPLORING EXCEL OBJECTS 64
2.14 CREATING YOUR OWN OBJECTS IN VBA 69 2.15 VBA HELP 72 3. COLLECTING
AND CLEANING UP DATA 73 3.1 IMPORTING DATA FROM TEXT FILES 73 3.2
IMPORTING DATA FROM DELIMITED TEXT FILES 78 3.3 IMPORTING DATA USING
DRAG-AND-DROP 79 3.4 IMPORTING DATA FROM ACCESS DATABASES 80 3.5
IMPORTING DATA FROM WEB PAGES 83 3.6 PARSING DATA 84 3.7 REMOVING WEIRD
CHARACTERS FROM IMPORTED TEXT 86 3.8 CONVERTING UNITS 87 3.9 SORTING
DATA ^ 90 3.10 FILTERING DATA 93 3.11 LOOKING UP VALUES IN TABLES 97
3.12 RETRIEVING DATA FROM XML FILES 105 4. CHARTING 108 4.1 CREATING
SIMPLE CHARTS 108 4.2 EXPLORING CHART STYLES 116 4.3 FORMATTING CHARTS *
117 4.4 CUSTOMIZING CHART AXES - 118 4.5 SETTING LOG OR SEMILOG SCALES .
121 4.6 USING MULTIPLE AXES 123 4.7 CHANGING THE TYPE OF AN EXISTING
CHART 128 4.8 COMBINING CHART TYPES 130 4.9 BUILDING 3D SURFACE PLOTS
131 4.10 PREPARING CONTOUR PLOTS 137 4.11 ANNOTATING CHARTS 139 4.12
SAVING CUSTOM CHART TYPES 142 TABLE OF CONTENTS 4.13 COPYING CHARTS TO
WORD 142 4.14 DISPLAYING ERROR BARS 143 5. STATISTICAL ANALYSIS 145 5.1
COMPUTING SUMMARY STATISTICS 146 5.2 PLOTTING FREQUENCY DISTRIBUTIONS
150 5.3 CALCULATING CONFIDENCE INTERVALS 154 5.4 CORRELATING DATA 155
5.5 RANKING AND PERCENTILES 160 5.6 PERFORMING STATISTICAL TESTS 162 5.7
CONDUCTING ANOVA 166 5.8 GENERATING RANDOM NUMBERS 168 5.9 SAMPLING DATA
169 6. TIME SERIES ANALYSIS 172 6.1 PLOTTING TIME SERIES DATA 172 6.2
ADDING TRENDLINES 173 6.3 COMPUTING MOVING AVERAGES 175 6.4 SMOOTHING
DATA USING WEIGHTED AVERAGES 182 6.5 CENTERING DATA 188 6.6 DETRENDING A
TIME SERIES 191 6.7 ESTIMATING SEASONAL INDICES 195 6.8
DESEASONALIZATION OF A TIME SERIES 199 6.9 FORECASTING 201 6.10
APPLYING DISCRETE FOURIER TRANSFORMS 204 7. MATHEMATICAL FUNCTIONS 215
7.1 USING SUMMATION FUNCTIONS 215 7.2 DELVING INTO DIVISION 216 7.3
MASTERING MULTIPLICATION ^ 2L7 7.4 EXPLORING EXPONENTIAL AND LOGARITHMIC
FUNCTIONS 219 7.5 USING TRIGONOMETRY FUNCTIONS 221 7.6 SEEING SIGNS 222
7.7 GETTING TO THE ROOT OF THINGS 222 7.8 ROUNDING AND TRUNCATING
NUMBERS 223 7.9 CONVERTING BETWEEN NUMBER SYSTEMS 224 7.10 MANIPULATING
MATRICES 225 7.11 BUILDING SUPPORT FOR VECTORS 227 7.12 USING
SPREADSHEET FUNCTIONS IN VBA CODE 230 7.13 DEALING WITH COMPLEX NUMBERS
230 TABLE OF CONTENTS I VII 8. CURVE FITTING AND REGRESSION 233 8.1
PERFORMING LINEAR CURVE FITTING USING EXCEL CHARTS 233 8.2 CONSTRUCTING
YOUR OWN LINEAR FIT USING SPREADSHEET FUNCTIONS 237 8.3 USING A SINGLE
SPREADSHEET FUNCTION FOR LINEAR CURVE FITTING 241 8.4 PERFORMING
MULTIPLE LINEAR REGRESSION 244 8.5 GENERATING NONLINEAR CURVE FITS USING
EXCEL CHARTS 247 8.6 FITTING NONLINEAR CURVES USING SOLVER 249 8.7
ASSESSING GOODNESS OF FIT 254 8.8 COMPUTING CONFIDENCE INTERVALS 259 9.
SOLVING EQUATIONS 263 9.1 FINDING ROOTS GRAPHICALLY 271 9.2 SOLVING
NONLINEAR EQUATIONS ITERATIVELY 273 9.3 AUTOMATING TEDIOUS PROBLEMS WITH
VBA 277 9.4 SOLVING LINEAR SYSTEMS 284 9.5 TACKLING NONLINEAR SYSTEMS OF
EQUATIONS 289 9.6 USING CLASSICAL METHODS FOR SOLVING EQUATIONS 291 10.
NUMERICAL INTEGRATION AND DIFFERENTIATION 296 10.1 INTEGRATING A
DEFINITE INTEGRAL 297 10.2 IMPLEMENTING THE TRAPEZOIDAL RULE IN VBA 301
10.3 COMPUTING THE CENTER OF AN AREA USING NUMERICAL INTEGRATION 304
10.4 CALCULATING THE SECOND MOMENT OF AN AREA 307 10.5 DEALING WITH
DOUBLE INTEGRALS 308 10.6 NUMERICAL DIFFERENTIATION 311 11. SOLVING
ORDINARY DIFFERENTIAL EQUATIONS 318 11.1 SOLVING FIRST-ORDER INITIAL
VALUE PROBLEMS 318 11.2 APPLYING THE RUNGE-KUTTA METHOD TO SECOND-ORDER
INITIAL VALUE PROBLEMS ^ 325 11.3 TACKLING COUPLED EQUATIONS 330 11.4
SHOOTING BOUNDARY VALUE PROBLEMS 337 12. SOLVING PARTIAL DIFFERENTIAL
EQUATIONS 342 12.1 LEVERAGING EXCEL TO DIRECTLY SOLVE FINITE DIFFERENCE
EQUATIONS 344 12.2 RECRUITING SOLVER TO ITERATIVELY SOLVE FINITE
DIFFERENCE EQUATIONS 346 12.3 SOLVING INITIAL VALUE PROBLEMS 351 12.4
USING EXCEL TO HELP SOLVE PROBLEMS FORMULATED USING THE FINITE
ELEMENT METHOD 355 VIII | TABLE OF CONTENTS 13. PERFORMING OPTIMIZATION
ANALYSES IN EXCEL 359 13.1 USING EXCEL FOR TRADITIONAL LINEAR
PROGRAMMING 359 13.2 EXPLORING RESOURCE ALLOCATION OPTIMIZATION PROBLEMS
363 13.3 GETTING MORE REALISTIC RESULTS WITH INTEGER CONSTRAINTS 368
13.4 TACKLING TROUBLESOME PROBLEMS 370 13.5 OPTIMIZING ENGINEERING
DESIGN PROBLEMS 376 13.6 UNDERSTANDING SOLVER REPORTS 380 13.7
PROGRAMMING A GENETIC ALGORITHM FOR OPTIMIZATION 385 14. INTRODUCTION TO
FINANCIAL CALCULATIONS 401 14.1 COMPUTING PRESENT VALUE 402 14.2
CALCULATING FUTURE VALUE 402 14.3 FIGURING OUT REQUIRED RATE OF RETURN
403 14.4 DOUBLING YOUR MONEY 404 14.5 DETERMINING MONTHLY PAYMENTS 404
14.6 CONSIDERING CASH FLOW ALTERNATIVES 405 14.7 ACHIEVING A CERTAIN
FUTURE VALUE 407 14.8 ASSESSING NET PRESENT WORTH 408 14.9 ESTIMATING
RATE OF RETURN 410 14.10 SOLVING INVERSE PROBLEMS 411 14.11 FIGURING A
BREAK-EVEN POINT 412 INDEX : 415 TABLE OF CONTENTS
|
| adam_txt |
EXCEL SCIENTIFIC AND ENGINEERING COOKBOOK DAVID M. BOURG O'REILLY*
BEIJING * CAMBRIDGE * FARNHAM * KOLN * PARIS * SEBASTOPOL * TAIPEI *
TOKYO TABLE OF CONTENTS PREFACE XI 1. USING EXCEL 1 1.1 NAVIGATING THE
INTERFACE 1 1.2 ENTERING DATA 7 1.3 SETTING CELL DATA TYPES 9 1.4
SELECTING MORE THAN A SINGLE CELL 13 1.5 ENTERING FORMULAS 14 1.6
EXPLORING THE R1C1 CELL REFERENCE STYLE 19 1.7 REFERRING TO MORE THAN A
SINGLE CELL 21 1.8 UNDERSTANDING OPERATOR PRECEDENCE ' 21 1.9 USING
EXPONENTS IN FORMULAS 22 1.10 EXPLORING FUNCTIONS 22 1.11 FORMATTING
YOUR SPREADSHEETS 26 1.12 DEFINING CUSTOM FORMAT STYLES 29 1.13
LEVERAGING COPY, CUT, PASTE, AND PASTE SPECIAL 30 1.14 USING CELL NAMES
(LIKE PROGRAMMING VARIABLES) 32 1.15 VALIDATING DATA ., 34 1.16 TAKING
ADVANTAGE OF MACROS . 35 1.17 ADDING COMMENTS AND EQUATION NOTES 37 1.18
GETTING HELP 40 2. GETTING ACQUAINTED WITH VISUAL BASIC FOR APPLICATIONS
41 2.1 NAVIGATING THE VBA EDITOR 42 2.2 WRITING FUNCTIONS AND
SUBROUTINES 45 2.3 WORKING WITH DATA TYPES 49 2.4 DEFINING VARIABLES 50
2.5 DEFINING CONSTANTS 52 2.6 USING ARRAYS 53 2.7 COMMENTING CODE 54 2.8
SPANNING LONG STATEMENTS OVER MULTIPLE LINES 55 2.9 USING CONDITIONAL
STATEMENTS 55 2.10 USING LOOPS 56 2.11 DEBUGGING VBA CODE 59 2.12
EXPLORING VBA'S BUILT-IN FUNCTIONS 62 2.13 EXPLORING EXCEL OBJECTS 64
2.14 CREATING YOUR OWN OBJECTS IN VBA 69 2.15 VBA HELP 72 3. COLLECTING
AND CLEANING UP DATA 73 3.1 IMPORTING DATA FROM TEXT FILES 73 3.2
IMPORTING DATA FROM DELIMITED TEXT FILES 78 3.3 IMPORTING DATA USING
DRAG-AND-DROP 79 3.4 IMPORTING DATA FROM ACCESS DATABASES 80 3.5
IMPORTING DATA FROM WEB PAGES 83 3.6 PARSING DATA 84 3.7 REMOVING WEIRD
CHARACTERS FROM IMPORTED TEXT 86 3.8 CONVERTING UNITS 87 3.9 SORTING
DATA ^ 90 3.10 FILTERING DATA 93 3.11 LOOKING UP VALUES IN TABLES 97
3.12 RETRIEVING DATA FROM XML FILES 105 4. CHARTING 108 4.1 CREATING
SIMPLE CHARTS 108 4.2 EXPLORING CHART STYLES 116 4.3 FORMATTING CHARTS *
117 4.4 CUSTOMIZING CHART AXES - 118 4.5 SETTING LOG OR SEMILOG SCALES .
121 4.6 USING MULTIPLE AXES 123 4.7 CHANGING THE TYPE OF AN EXISTING
CHART 128 4.8 COMBINING CHART TYPES 130 4.9 BUILDING 3D SURFACE PLOTS
131 4.10 PREPARING CONTOUR PLOTS 137 4.11 ANNOTATING CHARTS 139 4.12
SAVING CUSTOM CHART TYPES 142 TABLE OF CONTENTS 4.13 COPYING CHARTS TO
WORD 142 4.14 DISPLAYING ERROR BARS 143 5. STATISTICAL ANALYSIS 145 5.1
COMPUTING SUMMARY STATISTICS 146 5.2 PLOTTING FREQUENCY DISTRIBUTIONS
150 5.3 CALCULATING CONFIDENCE INTERVALS 154 5.4 CORRELATING DATA 155
5.5 RANKING AND PERCENTILES 160 5.6 PERFORMING STATISTICAL TESTS 162 5.7
CONDUCTING ANOVA 166 5.8 GENERATING RANDOM NUMBERS 168 5.9 SAMPLING DATA
169 6. TIME SERIES ANALYSIS 172 6.1 PLOTTING TIME SERIES DATA 172 6.2
ADDING TRENDLINES 173 6.3 COMPUTING MOVING AVERAGES 175 6.4 SMOOTHING
DATA USING WEIGHTED AVERAGES 182 6.5 CENTERING DATA 188 6.6 DETRENDING A
TIME SERIES 191 6.7 ESTIMATING SEASONAL INDICES 195 6.8
DESEASONALIZATION OF A TIME SERIES ' 199 6.9 FORECASTING 201 6.10
APPLYING DISCRETE FOURIER TRANSFORMS 204 7. MATHEMATICAL FUNCTIONS 215
7.1 USING SUMMATION FUNCTIONS 215 7.2 DELVING INTO DIVISION 216 7.3
MASTERING MULTIPLICATION ^ 2L7 7.4 EXPLORING EXPONENTIAL AND LOGARITHMIC
FUNCTIONS 219 7.5 USING TRIGONOMETRY FUNCTIONS 221 7.6 SEEING SIGNS 222
7.7 GETTING TO THE ROOT OF THINGS 222 7.8 ROUNDING AND TRUNCATING
NUMBERS 223 7.9 CONVERTING BETWEEN NUMBER SYSTEMS 224 7.10 MANIPULATING
MATRICES 225 7.11 BUILDING SUPPORT FOR VECTORS 227 7.12 USING
SPREADSHEET FUNCTIONS IN VBA CODE 230 7.13 DEALING WITH COMPLEX NUMBERS
230 TABLE OF CONTENTS I VII 8. CURVE FITTING AND REGRESSION 233 8.1
PERFORMING LINEAR CURVE FITTING USING EXCEL CHARTS 233 8.2 CONSTRUCTING
YOUR OWN LINEAR FIT USING SPREADSHEET FUNCTIONS 237 8.3 USING A SINGLE
SPREADSHEET FUNCTION FOR LINEAR CURVE FITTING 241 8.4 PERFORMING
MULTIPLE LINEAR REGRESSION 244 8.5 GENERATING NONLINEAR CURVE FITS USING
EXCEL CHARTS 247 8.6 FITTING NONLINEAR CURVES USING SOLVER 249 8.7
ASSESSING GOODNESS OF FIT 254 8.8 COMPUTING CONFIDENCE INTERVALS 259 9.
SOLVING EQUATIONS 263 9.1 FINDING ROOTS GRAPHICALLY 271 9.2 SOLVING
NONLINEAR EQUATIONS ITERATIVELY 273 9.3 AUTOMATING TEDIOUS PROBLEMS WITH
VBA 277 9.4 SOLVING LINEAR SYSTEMS 284 9.5 TACKLING NONLINEAR SYSTEMS OF
EQUATIONS 289 9.6 USING CLASSICAL METHODS FOR SOLVING EQUATIONS 291 10.
NUMERICAL INTEGRATION AND DIFFERENTIATION 296 10.1 INTEGRATING A
DEFINITE INTEGRAL 297 10.2 IMPLEMENTING THE TRAPEZOIDAL RULE IN VBA 301
10.3 COMPUTING THE CENTER OF AN AREA USING NUMERICAL INTEGRATION 304
10.4 CALCULATING THE SECOND MOMENT OF AN AREA 307 10.5 DEALING WITH
DOUBLE INTEGRALS 308 10.6 NUMERICAL DIFFERENTIATION 311 11. SOLVING
ORDINARY DIFFERENTIAL EQUATIONS 318 11.1 SOLVING FIRST-ORDER INITIAL
VALUE PROBLEMS 318 11.2 APPLYING THE RUNGE-KUTTA METHOD TO SECOND-ORDER
INITIAL VALUE PROBLEMS ^ 325 11.3 TACKLING COUPLED EQUATIONS 330 11.4
SHOOTING BOUNDARY VALUE PROBLEMS 337 12. SOLVING PARTIAL DIFFERENTIAL
EQUATIONS 342 12.1 LEVERAGING EXCEL TO DIRECTLY SOLVE FINITE DIFFERENCE
EQUATIONS 344 12.2 RECRUITING SOLVER TO ITERATIVELY SOLVE FINITE
DIFFERENCE EQUATIONS 346 12.3 SOLVING INITIAL VALUE PROBLEMS 351 12.4
USING EXCEL TO HELP SOLVE PROBLEMS FORMULATED USING THE FINITE
ELEMENT'METHOD 355 VIII | TABLE OF CONTENTS 13. PERFORMING OPTIMIZATION
ANALYSES IN EXCEL 359 13.1 USING EXCEL FOR TRADITIONAL LINEAR
PROGRAMMING 359 13.2 EXPLORING RESOURCE ALLOCATION OPTIMIZATION PROBLEMS
363 13.3 GETTING MORE REALISTIC RESULTS WITH INTEGER CONSTRAINTS 368
13.4 TACKLING TROUBLESOME PROBLEMS 370 13.5 OPTIMIZING ENGINEERING
DESIGN PROBLEMS 376 13.6 UNDERSTANDING SOLVER REPORTS 380 13.7
PROGRAMMING A GENETIC ALGORITHM FOR OPTIMIZATION 385 14. INTRODUCTION TO
FINANCIAL CALCULATIONS 401 14.1 COMPUTING PRESENT VALUE 402 14.2
CALCULATING FUTURE VALUE 402 14.3 FIGURING OUT REQUIRED RATE OF RETURN
403 14.4 DOUBLING YOUR MONEY 404 14.5 DETERMINING MONTHLY PAYMENTS 404
14.6 CONSIDERING CASH FLOW ALTERNATIVES 405 14.7 ACHIEVING A CERTAIN
FUTURE VALUE 407 14.8 ASSESSING NET PRESENT WORTH 408 14.9 ESTIMATING
RATE OF RETURN 410 14.10 SOLVING INVERSE PROBLEMS 411 14.11 FIGURING A
BREAK-EVEN POINT 412 INDEX : 415 TABLE OF CONTENTS |
| any_adam_object | 1 |
| any_adam_object_boolean | 1 |
| author | Bourg, David M. |
| author_facet | Bourg, David M. |
| author_role | aut |
| author_sort | Bourg, David M. |
| author_variant | d m b dm dmb |
| building | Verbundindex |
| bvnumber | BV021489726 |
| classification_rvk | ST 371 ST 620 |
| ctrlnum | (OCoLC)474951185 (DE-599)BVBBV021489726 |
| discipline | Informatik |
| discipline_str_mv | Informatik |
| edition | 1. ed. |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>03612nam a2200445 c 4500</leader><controlfield tag="001">BV021489726</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20150108 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">060224s2006 a||| |||| 00||| eng d</controlfield><datafield tag="016" ind1="7" ind2=" "><subfield code="a">976879514</subfield><subfield code="2">DE-101</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0596008791</subfield><subfield code="c">Kt. : EUR 43.00 (freier Pr.), EUR 46.50 (AT) (freier Pr.), sfr 71.90 (freier Pr.)</subfield><subfield code="9">0-596-00879-1</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780596008796</subfield><subfield code="9">978-0-596-00879-6</subfield></datafield><datafield tag="024" ind1="3" ind2=" "><subfield code="a">9780596008796</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)474951185</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV021489726</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rakddb</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1051</subfield><subfield code="a">DE-384</subfield><subfield code="a">DE-703</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 371</subfield><subfield code="0">(DE-625)143672:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">ST 620</subfield><subfield code="0">(DE-625)143684:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">004</subfield><subfield code="2">sdnb</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bourg, David M.</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel scientific and engineering cookbook</subfield><subfield code="c">David M. Bourg</subfield></datafield><datafield tag="250" ind1=" " ind2=" "><subfield code="a">1. ed.</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Beijing [u.a.]</subfield><subfield code="b">O'Reilly</subfield><subfield code="c">2006</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XV, 424 S.</subfield><subfield code="b">Ill.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Suitable for those who want to improve upon their Excel skills, this book teaches how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. It shows how to: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; and more. Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it - instead of FORTRAN - to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now, the "Excel Scientific and Engineering Cookbook" shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; visualize the results for interpretation and presentation; and use Excel to solve specific science and engineering problems</subfield></datafield><datafield tag="520" ind1=" " ind2=" "><subfield code="a">Wherever possible, the "Excel Scientific and Engineering Cookbook" draws on real-world examples from a range of scientific disciplines, such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Regneark</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Statistikprogrammer</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Statistisk databehandling</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">EXCEL</subfield><subfield code="0">(DE-588)4138932-3</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HEBIS Datenaustausch Darmstadt</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014706576&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-014706576</subfield></datafield></record></collection> |
| id | DE-604.BV021489726 |
| illustrated | Illustrated |
| index_date | 2024-07-02T14:12:20Z |
| indexdate | 2024-07-09T20:36:58Z |
| institution | BVB |
| isbn | 0596008791 9780596008796 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-014706576 |
| oclc_num | 474951185 |
| open_access_boolean | |
| owner | DE-1051 DE-384 DE-703 |
| owner_facet | DE-1051 DE-384 DE-703 |
| physical | XV, 424 S. Ill. |
| publishDate | 2006 |
| publishDateSearch | 2006 |
| publishDateSort | 2006 |
| publisher | O'Reilly |
| record_format | marc |
| spelling | Bourg, David M. Verfasser aut Excel scientific and engineering cookbook David M. Bourg 1. ed. Beijing [u.a.] O'Reilly 2006 XV, 424 S. Ill. txt rdacontent n rdamedia nc rdacarrier Suitable for those who want to improve upon their Excel skills, this book teaches how to leverage Excel to perform both routine and complex calculations, and then visualize the results for presentation. It shows how to: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; and more. Given the improved analytical capabilities of Excel, scientists and engineers everywhere are using it - instead of FORTRAN - to solve problems. And why not? Excel is installed on millions of computers, features a rich set of built-in analyses tools, and includes an integrated Visual Basic for Applications (VBA) programming language. No wonder it's today's computing tool of choice. Chances are you already use Excel to perform some fairly routine calculations. Now, the "Excel Scientific and Engineering Cookbook" shows you how to leverage Excel to perform more complex calculations, too, calculations that once fell in the domain of specialized tools. It does so by putting a smorgasbord of data analysis techniques right at your fingertips. The book shows how to perform these useful tasks and others: use Excel and VBA in general; import data from a variety of sources; analyze data; perform calculations; visualize the results for interpretation and presentation; and use Excel to solve specific science and engineering problems Wherever possible, the "Excel Scientific and Engineering Cookbook" draws on real-world examples from a range of scientific disciplines, such as biology, chemistry, and physics. This way, you'll be better prepared to solve the problems you face in your everyday scientific or engineering tasks. High on practicality and low on theory, this quick, look-up reference provides instant solutions, or "recipes," to problems both basic and advanced. And like other books in O'Reilly's popular cookbook format, each recipe also includes a discussion on how and why it works. As a result, you can take comfort in knowing that complete, practical answers are a mere page-flip away Regneark Statistikprogrammer Statistisk databehandling EXCEL (DE-588)4138932-3 gnd rswk-swf EXCEL (DE-588)4138932-3 s DE-604 HEBIS Datenaustausch Darmstadt application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014706576&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Bourg, David M. Excel scientific and engineering cookbook Regneark Statistikprogrammer Statistisk databehandling EXCEL (DE-588)4138932-3 gnd |
| subject_GND | (DE-588)4138932-3 |
| title | Excel scientific and engineering cookbook |
| title_auth | Excel scientific and engineering cookbook |
| title_exact_search | Excel scientific and engineering cookbook |
| title_exact_search_txtP | Excel scientific and engineering cookbook |
| title_full | Excel scientific and engineering cookbook David M. Bourg |
| title_fullStr | Excel scientific and engineering cookbook David M. Bourg |
| title_full_unstemmed | Excel scientific and engineering cookbook David M. Bourg |
| title_short | Excel scientific and engineering cookbook |
| title_sort | excel scientific and engineering cookbook |
| topic | Regneark Statistikprogrammer Statistisk databehandling EXCEL (DE-588)4138932-3 gnd |
| topic_facet | Regneark Statistikprogrammer Statistisk databehandling EXCEL |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=014706576&sequence=000001&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT bourgdavidm excelscientificandengineeringcookbook |