Associated Links |
|
ix | |
Preface |
|
xi | |
|
SECTION 1 GETTING ORIENTED |
|
|
|
1 Necessary Foundations for Decision Support |
|
|
3 | (4) |
|
2 The Development Environment |
|
|
7 | (30) |
|
|
8 | (3) |
|
|
11 | (4) |
|
|
15 | (3) |
|
|
18 | (1) |
|
|
19 | (1) |
|
|
19 | (4) |
|
2.7 Copying Content and Formats |
|
|
23 | (1) |
|
2.8 Built-in Tools and Matrix Functions |
|
|
24 | (13) |
|
Supplement: Logic and Structure in Conditional Statements |
|
|
30 | (5) |
|
|
35 | (2) |
|
3 Getting Data: Acquisition, Linkage, and Generation |
|
|
37 | (26) |
|
3.1 Text File Imports and Basic Table Transfers |
|
|
37 | (2) |
|
3.2 More Sophisticated Application Transfers |
|
|
39 | (5) |
|
3.3 Online Data Acquisition |
|
|
44 | (4) |
|
3.4 Simulating Continuous Data: The Basics |
|
|
48 | (2) |
|
3.5 Discrete Random Number Generation |
|
|
50 | (2) |
|
3.6 Living Data Records: The Basics - |
|
|
52 | (3) |
|
3.7 Living Records in Practice |
|
|
55 | (8) |
|
Supplement: Unique Data Generation and Sharing Tactics |
|
|
57 | (2) |
|
|
59 | (4) |
|
SECTION 2 HARVESTING INTELLIGENCE |
|
|
|
4 Structuring Problems and Option Visualization |
|
|
63 | (43) |
|
4.1 Value of Data Visualization |
|
|
64 | (10) |
|
4.2 Visualizing Continuous Data |
|
|
74 | (5) |
|
4.3 Less Conventional Depictions of Means and Variance |
|
|
79 | (1) |
|
4.4 Depictions in More Than Two Dimensions |
|
|
79 | (7) |
|
4.5 Complex-Form Heat Mapping |
|
|
86 | (10) |
|
4.6 Selective Pruning for Presentation and Analysis |
|
|
96 | (4) |
|
4.7 Visualizing Constraints |
|
|
100 | (6) |
|
|
105 | (1) |
|
|
106 | (34) |
|
5.1 Heuristics in Decision-Making Practice |
|
|
107 | (4) |
|
5.2 Heuristics Applied to Data Rationalization |
|
|
111 | (2) |
|
5.3 Attribute Grouping Approaches |
|
|
113 | (5) |
|
5.4 Data Grouping Approaches |
|
|
118 | (11) |
|
5.5 Giving Form to Future Categorization |
|
|
129 | (11) |
|
|
133 | (1) |
|
Supplement: Making Heuristics Automatic (the Inelegant Way) |
|
|
133 | (3) |
|
|
136 | (4) |
|
6 The Analytics of Optimization |
|
|
140 | (37) |
|
6.1 Optimization with Solver |
|
|
140 | (14) |
|
6.2 Deeper Insights into Optimization Solutions |
|
|
154 | (23) |
|
Supplement: The OUtCoMES Roadmap |
|
|
171 | (2) |
|
|
173 | (4) |
|
|
177 | (30) |
|
|
177 | (4) |
|
7.2 The Benefit of Alternate Optimization Options |
|
|
181 | (26) |
|
Supplement: A Primer on Genetic Algorithms |
|
|
197 | (6) |
|
|
203 | (4) |
|
SECTION 3 LEVERAGING DYNAMIC ANALYSIS |
|
|
|
8 Controlled Simulation Analysis |
|
|
207 | (38) |
|
8.1 Approaches to the Use of Simulation in Analysis |
|
|
208 | (2) |
|
8.2 Assessing Simulated Variants |
|
|
210 | (17) |
|
8.3 Assessing System Simulations |
|
|
227 | (8) |
|
8.4 An Introduction to Stochastic System Structures |
|
|
235 | (10) |
|
Supplement: Simulation Control Made Friendly |
|
|
237 | (7) |
|
|
244 | (1) |
|
9 Simulation Search, Optimization, and Reporting |
|
|
245 | (24) |
|
9.1 Basic Simulation Optimization Capabilities |
|
|
246 | (3) |
|
9.2 Optimization of Simulated Variants |
|
|
249 | (3) |
|
9.3 Optimization of System Simulations |
|
|
252 | (17) |
|
|
268 | (1) |
|
10 Visualizing Complex Analytical Dynamics |
|
|
269 | (22) |
|
|
270 | (1) |
|
|
271 | (1) |
|
10.3 Dynamics in Google Documents Visualization |
|
|
272 | (2) |
|
|
274 | (17) |
|
Supplement: Visually Derived Paths |
|
|
283 | (8) |
|
SECTION 4 ADVANCED AUTOMATION AND INTERFACING |
|
|
|
11 Visual Basic Editing and Code Development |
|
|
291 | (43) |
|
11.1 The Visual Basic Editor |
|
|
291 | (4) |
|
11.2 Additional VBA Capabilities: Object Manipulations |
|
|
295 | (8) |
|
|
303 | (8) |
|
11.4 Common Operations in VBA |
|
|
311 | (9) |
|
11.5 User-Defined Functions |
|
|
320 | (9) |
|
|
329 | (2) |
|
11.7 Making Functions and Macros Available to Other Workbooks: Creating Add-Ins |
|
|
331 | (3) |
|
|
332 | (2) |
|
12 Automating Application Calls |
|
|
334 | (25) |
|
|
334 | (4) |
|
|
338 | (3) |
|
12.3 Calls to RiskOptimizer |
|
|
341 | (6) |
|
|
347 | (2) |
|
12.5 A Final Note on the Value of Linguistics |
|
|
349 | (10) |
|
Supplement: Setups for Embedded MapPoint Controls |
|
|
350 | (7) |
|
|
357 | (2) |
|
13 Guided and User-Friendly Interfaces |
|
|
359 | (22) |
|
13.1 Interface Locking and Protecting |
|
|
361 | (2) |
|
13.2 Dynamic Interfacing: Pop-Ups and Dialogs |
|
|
363 | (7) |
|
13.3 Customizing Primary Excel Interfaces |
|
|
370 | (7) |
|
13.4 Ribbon Editing for Packaged Add-Ins |
|
|
377 | (1) |
|
13.5 Don't Give Up on the Spreadsheet |
|
|
377 | (4) |
|
|
378 | (3) |
Glossary of Key Terms |
|
381 | (8) |
Appendix: Shortcut (Hot Key) Reference |
|
389 | (2) |
Index |
|
391 | |