Excel basics to blackbelt: an accelerated guide to decision support designs
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Cambridge [u.a.]
Cambridge Univ. Press
2008
|
| Schlagworte: | |
| Online-Zugang: | Contributor biographical information Publisher description Table of contents only Inhaltsverzeichnis |
| Beschreibung: | Includes index |
| Beschreibung: | VII, 333 S. Ill. 27 cm |
| ISBN: | 9780521889056 0521889057 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV036589829 | ||
| 003 | DE-604 | ||
| 005 | 20100826 | ||
| 007 | t | ||
| 008 | 100728s2008 xxka||| |||| 00||| eng d | ||
| 010 | |a 2007050174 | ||
| 015 | |a GBA877738 |2 dnb | ||
| 020 | |a 9780521889056 |9 978-0-521-88905-6 | ||
| 020 | |a 0521889057 |9 0-521-88905-7 | ||
| 035 | |a (OCoLC)636102100 | ||
| 035 | |a (DE-599)BVBBV036589829 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxk |c GB | ||
| 049 | |a DE-20 | ||
| 050 | 0 | |a HD30.213 | |
| 082 | 0 | |a 005.54 | |
| 084 | |a QP 327 |0 (DE-625)141858: |2 rvk | ||
| 084 | |a QP 345 |0 (DE-625)141866: |2 rvk | ||
| 100 | 1 | |a Bendoly, Elliot |e Verfasser |4 aut | |
| 245 | 1 | 0 | |a Excel basics to blackbelt |b an accelerated guide to decision support designs |c Elliot Bendoly |
| 264 | 1 | |a Cambridge [u.a.] |b Cambridge Univ. Press |c 2008 | |
| 300 | |a VII, 333 S. |b Ill. |c 27 cm | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index | ||
| 650 | 4 | |a Decision support systems | |
| 650 | 4 | |a Microsoft Excel (Computer file) | |
| 650 | 0 | 7 | |a Entscheidungsunterstützungssystem |0 (DE-588)4191815-0 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a EXCEL |0 (DE-588)4138932-3 |2 gnd |9 rswk-swf |
| 650 | 0 | 7 | |a Statistische Analyse |0 (DE-588)4116599-8 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Entscheidungsunterstützungssystem |0 (DE-588)4191815-0 |D s |
| 689 | 0 | 1 | |a Statistische Analyse |0 (DE-588)4116599-8 |D s |
| 689 | 0 | 2 | |a EXCEL |0 (DE-588)4138932-3 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050174-b.html |3 Contributor biographical information | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050174-d.html |3 Publisher description | |
| 856 | 4 | |u http://www.loc.gov/catdir/enhancements/fy0809/2007050174-t.html |3 Table of contents only | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020510562&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020510562 | ||
Datensatz im Suchindex
| _version_ | 1804143188988919810 |
|---|---|
| adam_text | Contents
SECTION 1. GETTING ORIENTED
1. Necessary Foundations for Decision Support page 3
2. The Development Environment 8
2.1. Fixed Data 8
2.2. Formatting 12
2.3. Labeling (Naming) 15
2.4. Comments 18
2.5. Hyperlinks 19
2.6. Formulae 19
2.7. Copying Content and Formats 23
2.8. Built-in Tools 23
Chapter 2 Supplement: Logic and Structure in
Conditional Statements 27
Practice Problems 33
3. Getting Data - Acquisition, Linkage, and Generation 34
3.1. Text File Imports and Basic Table Transfers 34
3.2. More Sophisticated Application Transfers 36
3.3. Online Data Acquisition 47
3.4. Simulating Data: The Basics 49
3.5. Living Data Records: The Basics 53
3.6. Living Records in Practice 56
Practice Problems 58
SECTION 2. HARVESTING INTELLIGENCE
4. Structuring Problems and Option Visualization 63
4.1. Value of Data Visualization 64
4.2. Selective Pruning for Presentation and Analysis 78
vi Contents
4.3. Visualizing Constraints 82
Practice Problems 87
5. Simplification Tactics 89
5.1. Heuristics in Decision-Making Practice 90
5.2. Heuristics Applied to Data Rationalization 94
5.3. Attribute Grouping Approaches 95
5.4. Data Grouping Approaches 102
5.5. Giving Form to Future Categorization 112
Cited References 116
Chapter 5 Supplement: Making Heuristics Automatic
(the Non-Elegant Way) 116
Practice Problems 119
6. The Analytics of Optimization 122
6.1. Optimization with Solver 122
6.2. Deeper Insights into Optimization Solutions 133
Practice Problems 150
7. Complex Optimization 154
7.1. How Solver Solves 154
7.2. The Benefit of Alternate Optimization Options 157
Chapter 7 Supplement: A Primer on Genetic Algorithms 173
Practice Problems 179
SECTION 3. LEVERAGING DYNAMIC ANALYSIS
8. Controlled Simulation Analysis 183
8.1. Approaches to the Use of Simulation in Analysis 184
8.2. Assessing Simulated Variants 187
8.3. Assessing System Simulations 192
8.4. An Introduction to Stochastic System Structures 199
Chapter 8 Supplement: Simulation Control Made Friendly 202
Practice Problems 207
9. Scenario Generation and Optimization 209
9.1. Basic Simulation Optimization Capabilities 210
9.2. Optimization of Simulated Variants 213
9.3. Optimization of System Simulations 216
Practice Problem . 227
10. Visualizing Complex Analytical Dynamics 229
10.1. Random Walks 230
10.2. Frictionless Boxes 231
10.3. Path-Directed Flows 232
Chapter 10 Supplement: Visually Derived Paths 240
Contents vii
SECTION 4. ADVANCED AUTOMATION AND INTERFACING
11. VB Editing and Code Development 249
11.1. The Visual Basic Editor 249
11.2. Object Manipulations 254
11.3. Syntax and Coding 259
11.4. User-Defined Functions 273
Practice Problems 279
12. Automating Application Calls 281
12.1. Calls to MapPoint 281
12.2. Calls to Solver 285
12.3. Calls to RiskOptimizer 288
12.4. Calls to XLStat 294
12.5. A Final Note on the Value of Linguistics 296
Practice Problems 296
13. Guided and User-Friendly Interfaces 298
13.1. Interface Locking and Protecting 300
13.2. Dynamic Interfacing: Pop-Ups/Dialogs 303
13.3. Customizing Primary Excel Interfaces 306
13.4. Don t Give Up on the Spreadsheet 314
Practice Problem 314
Glossary of Key Terms 317
Appendix - Shortcut (Hot Key) Reference 325
Index 327
|
| any_adam_object | 1 |
| author | Bendoly, Elliot |
| author_facet | Bendoly, Elliot |
| author_role | aut |
| author_sort | Bendoly, Elliot |
| author_variant | e b eb |
| building | Verbundindex |
| bvnumber | BV036589829 |
| callnumber-first | H - Social Science |
| callnumber-label | HD30 |
| callnumber-raw | HD30.213 |
| callnumber-search | HD30.213 |
| callnumber-sort | HD 230.213 |
| callnumber-subject | HD - Industries, Land Use, Labor |
| classification_rvk | QP 327 QP 345 |
| ctrlnum | (OCoLC)636102100 (DE-599)BVBBV036589829 |
| dewey-full | 005.54 |
| dewey-hundreds | 000 - Computer science, information, general works |
| dewey-ones | 005 - Computer programming, programs, data, security |
| dewey-raw | 005.54 |
| dewey-search | 005.54 |
| dewey-sort | 15.54 |
| dewey-tens | 000 - Computer science, information, general works |
| discipline | Informatik Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>02128nam a2200517zc 4500</leader><controlfield tag="001">BV036589829</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20100826 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100728s2008 xxka||| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2007050174</subfield></datafield><datafield tag="015" ind1=" " ind2=" "><subfield code="a">GBA877738</subfield><subfield code="2">dnb</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780521889056</subfield><subfield code="9">978-0-521-88905-6</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">0521889057</subfield><subfield code="9">0-521-88905-7</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)636102100</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV036589829</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxk</subfield><subfield code="c">GB</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-20</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HD30.213</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">005.54</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 327</subfield><subfield code="0">(DE-625)141858:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 345</subfield><subfield code="0">(DE-625)141866:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Bendoly, Elliot</subfield><subfield code="e">Verfasser</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Excel basics to blackbelt</subfield><subfield code="b">an accelerated guide to decision support designs</subfield><subfield code="c">Elliot Bendoly</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Cambridge [u.a.]</subfield><subfield code="b">Cambridge Univ. Press</subfield><subfield code="c">2008</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">VII, 333 S.</subfield><subfield code="b">Ill.</subfield><subfield code="c">27 cm</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="500" ind1=" " ind2=" "><subfield code="a">Includes index</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Decision support systems</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Microsoft Excel (Computer file)</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Entscheidungsunterstützungssystem</subfield><subfield code="0">(DE-588)4191815-0</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</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="650" ind1="0" ind2="7"><subfield code="a">Statistische Analyse</subfield><subfield code="0">(DE-588)4116599-8</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Entscheidungsunterstützungssystem</subfield><subfield code="0">(DE-588)4191815-0</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="1"><subfield code="a">Statistische Analyse</subfield><subfield code="0">(DE-588)4116599-8</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2="2"><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=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050174-b.html</subfield><subfield code="3">Contributor biographical information</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050174-d.html</subfield><subfield code="3">Publisher description</subfield></datafield><datafield tag="856" ind1="4" ind2=" "><subfield code="u">http://www.loc.gov/catdir/enhancements/fy0809/2007050174-t.html</subfield><subfield code="3">Table of contents only</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</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=020510562&sequence=000002&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-020510562</subfield></datafield></record></collection> |
| id | DE-604.BV036589829 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:43:35Z |
| institution | BVB |
| isbn | 9780521889056 0521889057 |
| language | English |
| lccn | 2007050174 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020510562 |
| oclc_num | 636102100 |
| open_access_boolean | |
| owner | DE-20 |
| owner_facet | DE-20 |
| physical | VII, 333 S. Ill. 27 cm |
| publishDate | 2008 |
| publishDateSearch | 2008 |
| publishDateSort | 2008 |
| publisher | Cambridge Univ. Press |
| record_format | marc |
| spelling | Bendoly, Elliot Verfasser aut Excel basics to blackbelt an accelerated guide to decision support designs Elliot Bendoly Cambridge [u.a.] Cambridge Univ. Press 2008 VII, 333 S. Ill. 27 cm txt rdacontent n rdamedia nc rdacarrier Includes index Decision support systems Microsoft Excel (Computer file) Entscheidungsunterstützungssystem (DE-588)4191815-0 gnd rswk-swf EXCEL (DE-588)4138932-3 gnd rswk-swf Statistische Analyse (DE-588)4116599-8 gnd rswk-swf Entscheidungsunterstützungssystem (DE-588)4191815-0 s Statistische Analyse (DE-588)4116599-8 s EXCEL (DE-588)4138932-3 s DE-604 http://www.loc.gov/catdir/enhancements/fy0809/2007050174-b.html Contributor biographical information http://www.loc.gov/catdir/enhancements/fy0809/2007050174-d.html Publisher description http://www.loc.gov/catdir/enhancements/fy0809/2007050174-t.html Table of contents only HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020510562&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Bendoly, Elliot Excel basics to blackbelt an accelerated guide to decision support designs Decision support systems Microsoft Excel (Computer file) Entscheidungsunterstützungssystem (DE-588)4191815-0 gnd EXCEL (DE-588)4138932-3 gnd Statistische Analyse (DE-588)4116599-8 gnd |
| subject_GND | (DE-588)4191815-0 (DE-588)4138932-3 (DE-588)4116599-8 |
| title | Excel basics to blackbelt an accelerated guide to decision support designs |
| title_auth | Excel basics to blackbelt an accelerated guide to decision support designs |
| title_exact_search | Excel basics to blackbelt an accelerated guide to decision support designs |
| title_full | Excel basics to blackbelt an accelerated guide to decision support designs Elliot Bendoly |
| title_fullStr | Excel basics to blackbelt an accelerated guide to decision support designs Elliot Bendoly |
| title_full_unstemmed | Excel basics to blackbelt an accelerated guide to decision support designs Elliot Bendoly |
| title_short | Excel basics to blackbelt |
| title_sort | excel basics to blackbelt an accelerated guide to decision support designs |
| title_sub | an accelerated guide to decision support designs |
| topic | Decision support systems Microsoft Excel (Computer file) Entscheidungsunterstützungssystem (DE-588)4191815-0 gnd EXCEL (DE-588)4138932-3 gnd Statistische Analyse (DE-588)4116599-8 gnd |
| topic_facet | Decision support systems Microsoft Excel (Computer file) Entscheidungsunterstützungssystem EXCEL Statistische Analyse |
| url | http://www.loc.gov/catdir/enhancements/fy0809/2007050174-b.html http://www.loc.gov/catdir/enhancements/fy0809/2007050174-d.html http://www.loc.gov/catdir/enhancements/fy0809/2007050174-t.html http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020510562&sequence=000002&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT bendolyelliot excelbasicstoblackbeltanacceleratedguidetodecisionsupportdesigns |