Business applications Books

Book SynopsisThe ultimate handbook for Excel analysts who need reporting solutions using Access Excel and Access are intended to work together. This book offers a comprehensive review of the extensive analytical and reporting functionality that Access provides and how it enhances Excel reporting functions. Sales managers, operations analysts, administrative assistants, office managers, and many others who rely heavily on data can benefit from learning to integrate Excel and Access, and this book shows you how. Coverage includes: Data Analysis in Access & the Basics of Access Beyond Select Queries Transforming Your Data with Access Working with Calculations and Dates Performing Conditional Analysis Adding Dimension with Subqueries and Domain Aggregate Functions Running Descriptive Statistics in Access Scheduling and Running Batch Analysis Leveraging VBA to Enhance Data Analysis<Table of ContentsIntroduction xxix Part I Fundamentals of Data Analysis in Access 1 Chapter 1 The Case for Data Analysis in Access 3 Chapter 2 Access Basics 13 Chapter 3 Beyond Select Queries 47 Part II Basic Analysis Techniques 87 Chapter 4 Transforming Your Data with Access 89 Chapter 5 Working with Calculations and Dates 113 Chapter 6 Performing Conditional Analysis 141 Part III Advanced Analysis Techniques 161 Chapter 7 Adding Dimension with Subqueries and Domain Aggregate Functions 163 Chapter 8 Running Descriptive Statistics in Access 189 Chapter 9 Scheduling and Running Batch Analysis 209 Chapter 10 Leveraging VBA to Enhance Data Analysis 243 Part IV Reports, Dashboards, and Visualization in Access 267 Chapter 11 Presenting Data with Access Reports 269 Chapter 12 Using Pivot Tables and Pivot Charts in Access 291 Chapter 13 Enhancing Queries and Reports with Visualizations 323 Part V Advanced Excel and Access Integration Techniques 345 Chapter 14 Getting Access Data into Excel 347 Chapter 15 Using VBA to Move Data between Excel and Access 365 Chapter 16 Exploring Excel and Access Automation 389 Chapter 17 Integrating Excel and Access with XML 423 Chapter 18 Integrating Excel and Other Office Applications 441 Part VI Appendixes 475 Appendix A Access VBA Fundamentals 477 Appendix B Understanding and Using SQL 489 Appendix C Query Performance, Database Corruption, and Other Thoughts 509 Appendix D Data Analyst’s Function Reference 521 Index 563

Read more less

Book SynopsisGet up to speed on the latest features and enhancements to InDesign CS5 As the industry standard in professional layout and design, InDesign delivers powerful publishing solutions for magazine, newspaper, and other publishing fields.Table of ContentsIntroduction 1 Part I: Before You Begin 7 Chapter 1: Understanding InDesign Ingredients 9 Chapter 2: Making InDesign Work Your Way 33 Part II: Document Essentials 47 Chapter 3: Opening and Saving Your Work 49 Chapter 4: Discovering How Pages and Layers Work 59 Chapter 5: The Joys of Reuse 85 Chapter 6: Working with Color 99 Part III: Object Essentials 117 Chapter 7: Adding Essential Elements 119 Chapter 8: Manipulating Objects 137 Chapter 9: Organizing Objects 157 Chapter 10: Aligning and Arranging Objects 173 Part IV: Text Essentials 197 Chapter 11: Putting Words on the Page 199 Chapter 12: The Ins and Outs of Text Editing 219 Chapter 13: The Styles of Text 237 Chapter 14: Fine-Tuning Paragraph Details 247 Chapter 15: Finessing Character Details 263 Part V: Graphics Essentials 277 Chapter 16: Importing Graphics 279 Chapter 17: Fitting Graphics and Setting Paths 291 Part VI: Getting Down to Business 301 Chapter 18: Working with Tabs and Tables 303 Chapter 19: Working with Footnotes, Indexes, and TOCs 315 Chapter 20: Working with Automatic Text 327 Chapter 21: Publishing Books 337 Part VII: Printing, Presentation, and Web Essentials 345 Chapter 22: Printing and PDF’ing Your Work 347 Chapter 23: Web Project Basics 371 Chapter 24: Presentation Project Basics 383 Part VIII: The Part of Tens 405 Chapter 25: Top Ten New Features in InDesign CS5 407 Chapter 26: Top Ten Resources for InDesign Users 411 Index 415

Read more less

Book SynopsisProgrammers, scientists, and engineers are always in need of newer techniques and algorithms to manipulate and interpret images. Algorithms for Image Processing and Computer Vision is an accessible collection of algorithms for common image processing applications that simplifies complicated mathematical calculations.Table of ContentsPreface xxi Chapter 1 Practical Aspects of a Vision System — Image Display, Input/Output, and Library Calls 1 OpenCV 2 The Basic OpenCV Code 2 The IplImage Data Structure 3 Reading and Writing Images 6 Image Display 7 An Example 7 Image Capture 10 Interfacing with the AIPCV Library 14 Website Files 18 References 18 Chapter 2 Edge-Detection Techniques 21 The Purpose of Edge Detection 21 Traditional Approaches and Theory 23 Models of Edges 24 Noise 26 Derivative Operators 30 Template-Based Edge Detection 36 Edge Models: The Marr-Hildreth Edge Detector 39 The Canny Edge Detector 42 The Shen-Castan (ISEF) Edge Detector 48 A Comparison of Two Optimal Edge Detectors 51 Color Edges 53 Source Code for the Marr-Hildreth Edge Detector 58 Source Code for the Canny Edge Detector 62 Source Code for the Shen-Castan Edge Detector 70 Website Files 80 References 82 Chapter 3 Digital Morphology 85 Morphology Defined 85 Connectedness 86 Elements of Digital Morphology — Binary Operations 87 Binary Dilation 88 Implementing Binary Dilation 92 Binary Erosion 94 Implementation of Binary Erosion 100 Opening and Closing 101 MAX — A High-Level Programming Language for Morphology 107 The ‘‘Hit-and-Miss’’ Transform 113 Identifying Region Boundaries 116 Conditional Dilation 116 Counting Regions 119 Grey-Level Morphology 121 Opening and Closing 123 Smoothing 126 Gradient 128 Segmentation of Textures 129 Size Distribution of Objects 130 Color Morphology 131 Website Files 132 References 135 Chapter 4 Grey-Level Segmentation 137 Basics of Grey-Level Segmentation 137 Using Edge Pixels 139 Iterative Selection 140 The Method of Grey-Level Histograms 141 Using Entropy 142 Fuzzy Sets 146 Minimum Error Thresholding 148 Sample Results From Single Threshold Selection 149 The Use of Regional Thresholds 151 Chow and Kaneko 152 Modeling Illumination Using Edges 156 Implementation and Results 159 Comparisons 160 Relaxation Methods 161 Moving Averages 167 Cluster-Based Thresholds 170 Multiple Thresholds 171 Website Files 172 References 173 Chapter 5 Texture and Color 177 Texture and Segmentation 177 A Simple Analysis of Texture in Grey-Level Images 179 Grey-Level Co-Occurrence 182 Maximum Probability 185 Moments 185 Contrast 185 Homogeneity 185 Entropy 186 Results from the GLCM Descriptors 186 Speeding Up the Texture Operators 186 Edges and Texture 188 Energy and Texture 191 Surfaces and Texture 193 Vector Dispersion 193 Surface Curvature 195 Fractal Dimension 198 Color Segmentation 201 Color Textures 205 Website Files 205 References 206 Chapter 6 Thinning 209 What Is a Skeleton? 209 The Medial Axis Transform 210 Iterative Morphological Methods 212 The Use of Contours 221 Choi/Lam/Siu Algorithm 224 Treating the Object as a Polygon 226 Triangulation Methods 227 Force-Based Thinning 228 Definitions 229 Use of a Force Field 230 Subpixel Skeletons 234 Source Code for Zhang-Suen/Stentiford/Holt Combined Algorithm 235 Website Files 246 References 247 Chapter 7 Image Restoration 251 Image Degradations — The Real World 251 The Frequency Domain 253 The Fourier Transform 254 The Fast Fourier Transform 256 The Inverse Fourier Transform 260 Two-Dimensional Fourier Transforms 260 Fourier Transforms in OpenCV 262 Creating Artificial Blur 264 The Inverse Filter 270 The Wiener Filter 271 Structured Noise 273 Motion Blur — A Special Case 276 The Homomorphic Filter — Illumination 277 Frequency Filters in General 278 Isolating Illumination Effects 280 Website Files 281 References 283 Chapter 8 Classification 285 Objects, Patterns, and Statistics 285 Features and Regions 288 Training and Testing 292 Variation: In-Class and Out-Class 295 Minimum Distance Classifiers 299 Distance Metrics 300 Distances Between Features 302 Cross Validation 304 Support Vector Machines 306 Multiple Classifiers — Ensembles 309 Merging Multiple Methods 309 Merging Type 1 Responses 310 Evaluation 311 Converting Between Response Types 312 Merging Type 2 Responses 313 Merging Type 3 Responses 315 Bagging and Boosting 315 Bagging 315 Boosting 316 Website Files 317 References 318 Chapter 9 Symbol Recognition 321 The Problem 321 OCR on Simple Perfect Images 322 OCR on Scanned Images — Segmentation 326 Noise 327 Isolating Individual Glyphs 329 Matching Templates 333 Statistical Recognition 337 OCR on Fax Images — Printed Characters 339 Orientation — Skew Detection 340 The Use of Edges 345 Handprinted Characters 348 Properties of the Character Outline 349 Convex Deficiencies 353 Vector Templates 357 Neural Nets 363 A Simple Neural Net 364 A Backpropagation Net for Digit Recognition 368 The Use of Multiple Classifiers 372 Merging Multiple Methods 372 Results From the Multiple Classifier 375 Printed Music Recognition — A Study 375 Staff Lines 376 Segmentation 378 Music Symbol Recognition 381 Source Code for Neural Net Recognition System 383 Website Files 390 References 392 Chapter 10 Content-Based Search — Finding Images by Example 395 Searching Images 395 Maintaining Collections of Images 396 Features for Query by Example 399 Color Image Features 399 Mean Color 400 Color Quad Tree 400 Hue and Intensity Histograms 401 Comparing Histograms 402 Requantization 403 Results from Simple Color Features 404 Other Color-Based Methods 407 Grey-Level Image Features 408 Grey Histograms 409 Grey Sigma — Moments 409 Edge Density — Boundaries Between Objects 409 Edge Direction 410 Boolean Edge Density 410 Spatial Considerations 411 Overall Regions 411 Rectangular Regions 412 Angular Regions 412 Circular Regions 414 Hybrid Regions 414 Test of Spatial Sampling 414 Additional Considerations 417 Texture 418 Objects, Contours, Boundaries 418 Data Sets 418 Website Files 419 References 420 Systems 424 Chapter 11 High-Performance Computing for Vision and Image Processing 425 Paradigms for Multiple-Processor Computation 426 Shared Memory 426 Message Passing 427 Execution Timing 427 Using clock() 428 Using QueryPerformanceCounter 430 The Message-Passing Interface System 432 Installing MPI 432 Using MPI 433 Inter-Process Communication 434 Running MPI Programs 436 Real Image Computations 437 Using a Computer Network — Cluster Computing 440 A Shared Memory System — Using the PC Graphics Processor 444 GLSL 444 OpenGL Fundamentals 445 Practical Textures in OpenGL 448 Shader Programming Basics 451 Vertex and Fragment Shaders 452 Required GLSL Initializations 453 Reading and Converting the Image 454 Passing Parameters to Shader Programs 456 Putting It All Together 457 Speedup Using the GPU 459 Developing and Testing Shader Code 459 Finding the Needed Software 460 Website Files 461 References 461 Index 465

Read more less

Book SynopsisThe purpose of large--scale software architecture is to capture and describe practical representations to make development teams more effective. In this book the authors show how to utilise software architecture as a tool to guide the development instead of capturing the architectural details after all the design decisions have been made.Trade Review“…a welcome addition…recommended…” (CVU, June 04)Table of ContentsPreface. Acknowledgements. Introduction. Roles of the Software Architect. Software Architecture and the Development Process. Example System Overview. UML Quick Tour. System Context and Domain Analysis. Component Design and Modeling. Subsystem Design. Transaction and Data Design. Process and Deployment Design. Architecture Techniques. Applying the Viewpoints. Summary of Architectural Viewpoints. Bibliography.

Read more less

a huge range and FREE tracked UK delivery on ALL orders.

Read more less

Book SynopsisSoftware documentation forms the basis for all communication relating to a software project. To be truly effective and usable, it should be based on what needs to be known. Agile Documentation provides sound advice on how to produce lean and lightweight software documentation.Trade Review??many (Test Documents) would benefit from this treatment?? (Professional Tester, October 03) "...applicable to documentation for any project...highly recommended..." (CVu, Vol 16(4), August 2004)Table of ContentsForeword ix Preface xi Acknowledgements xvii Introduction 1 Project Background 11 1 Finding the Right Topics 19 Target Readers 24 Focused Information 26 Individual Documentation Requirements 28 Documentation Portfolio 30 Focus on Long-Term Relevance 34 Specification as a Joint Effort 36 Design Rationale 39 The Big Picture 40 Separation of Description and Evaluation 42 Realistic Examples 44 Experience Reports 46 2 Structuring Individual Documents 61 Structured information 66 Judicious Diagrams 70 Unambiguous Tables 73 Guidelines for Readers 75 Thumbnail Sketches 77 Traceable References 78 Glossary 79 Document History 81 Experience Reports 82 3 Layout and Typography 93 Text on 50% of a Page 98 Two Alphabets per Line 100 120% Line Spacing 102 Two Typefaces 104 Careful Use of Type Variations 106 Careful Ruling and Shading 108 Adjacent Placement 109 Coherent Pages 111 Experience Reports 112 4 Infrastructure and Technical Organisation 117 Document Landscape 120 Document Archive 123 Wiki 125 Code-Comment Proximity 126 Reader-Friendly Media 128 Separation of Contents and Layout 131 Single Source and Multiple Targets 133 Import by Reference 136 Separation of Processing and Printing 138 Document Templates 139 Few Tools 142 Annotated Changes 144 Notification upon Update 145 Reorganisation upon Request 147 Experience Reports 149 5 Management and Quality Assurance 159 A Distinct Activity 161 One Responsible Author 164 Continuing Documentation 166 Writing and Reflection 168 Review Culture 170 Review Before Delivery 174 Customer Review 175 A Distant View 177 Information Marketplace 179 Knowledge Management 180 Experience Reports 182 Final Remarks 193 Pattern Thumbnails 197 Finding the Right Topics 197 Structuring Individual Documents 198 Layout and Typography 200 Infrastructure and Technical Organisation 201 Management and Quality Assurance 203 Glossary 205 References 211 Index 221

Read more less

Book SynopsisThe field of data mining lies at the confluence of predictive analytics, statistical analysis, and business intelligence. Due to the ever-increasing complexity and size of data sets and the wide range of applications in computer science, business, and health care, the process of discovering knowledge in data is more relevant than ever before. This book provides the tools needed to thrive in today's big data world. The author demonstrates how to leverage a company's existing databases to increase profits and market share, and carefully explains the most current data science methods and techniques. The reader will learn data mining by doing data mining. By adding chapters on data modelling preparation, imputation of missing data, and multivariate statistical analysis, Discovering Knowledge in Data, Second Edition remains the eminent reference on data mining. The second edition of a highly praised, successful reference on data mining, with thorougTable of ContentsPreface xi Chapter 1 An Introduction to Data Mining 1 1.1 What is Data Mining? 1 1.2 Wanted: Data Miners 2 1.3 The Need for Human Direction of Data Mining 3 1.4 The Cross-Industry Standard Practice for Data Mining 4 1.4.1 Crisp-DM: The Six Phases 5 1.5 Fallacies of Data Mining 6 1.6 What Tasks Can Data Mining Accomplish? 8 1.6.1 Description 8 1.6.2 Estimation 8 1.6.3 Prediction 10 1.6.4 Classification 10 1.6.5 Clustering 12 1.6.6 Association 14 References 14 Exercises 15 Chapter 2 Data Preprocessing 16 2.1 Why do We Need to Preprocess the Data? 17 2.2 Data Cleaning 17 2.3 Handling Missing Data 19 2.4 Identifying Misclassifications 22 2.5 Graphical Methods for Identifying Outliers 22 2.6 Measures of Center and Spread 23 2.7 Data Transformation 26 2.8 Min-Max Normalization 26 2.9 Z-Score Standardization 27 2.10 Decimal Scaling 28 2.11 Transformations to Achieve Normality 28 2.12 Numerical Methods for Identifying Outliers 35 2.13 Flag Variables 36 2.14 Transforming Categorical Variables into Numerical Variables 37 2.15 Binning Numerical Variables 38 2.16 Reclassifying Categorical Variables 39 2.17 Adding an Index Field 39 2.18 Removing Variables that are Not Useful 39 2.19 Variables that Should Probably Not Be Removed 40 2.20 Removal of Duplicate Records 41 2.21 A Word About ID Fields 41 The R Zone 42 References 48 Exercises 48 Hands-On Analysis 50 Chapter 3 Exploratory Data Analysis 51 3.1 Hypothesis Testing Versus Exploratory Data Analysis 51 3.2 Getting to Know the Data Set 52 3.3 Exploring Categorical Variables 55 3.4 Exploring Numeric Variables 62 3.5 Exploring Multivariate Relationships 69 3.6 Selecting Interesting Subsets of the Data for Further Investigation 71 3.7 Using EDA to Uncover Anomalous Fields 71 3.8 Binning Based on Predictive Value 72 3.9 Deriving New Variables: Flag Variables 74 3.10 Deriving New Variables: Numerical Variables 77 3.11 Using EDA to Investigate Correlated Predictor Variables 77 3.12 Summary 80 The R Zone 82 Reference 88 Exercises 88 Hands-On Analysis 89 Chapter 4 Univariate Statistical Analysis 91 4.1 Data Mining Tasks in Discovering Knowledge in Data 91 4.2 Statistical Approaches to Estimation and Prediction 92 4.3 Statistical Inference 93 4.4 How Confident are We in Our Estimates? 94 4.5 Confidence Interval Estimation of the Mean 95 4.6 How to Reduce the Margin of Error 97 4.7 Confidence Interval Estimation of the Proportion 98 4.8 Hypothesis Testing for the Mean 99 4.9 Assessing the Strength of Evidence Against the Null Hypothesis 101 4.10 Using Confidence Intervals to Perform Hypothesis Tests 102 4.11 Hypothesis Testing for the Proportion 104 The R Zone 105 Reference 106 Exercises 106 Chapter 5 Multivariate Statistics 109 5.1 Two-Sample t-Test for Difference in Means 110 5.2 Two-Sample Z-Test for Difference in Proportions 111 5.3 Test for Homogeneity of Proportions 112 5.4 Chi-Square Test for Goodness of Fit of Multinomial Data 114 5.5 Analysis of Variance 115 5.6 Regression Analysis 118 5.7 Hypothesis Testing in Regression 122 5.8 Measuring the Quality of a Regression Model 123 5.9 Dangers of Extrapolation 123 5.10 Confidence Intervals for the Mean Value of y Given x 125 5.11 Prediction Intervals for a Randomly Chosen Value of y Given x 125 5.12 Multiple Regression 126 5.13 Verifying Model Assumptions 127 The R Zone 131 Reference 135 Exercises 135 Hands-On Analysis 136 Chapter 6 Preparing to Model the Data 138 6.1 Supervised Versus Unsupervised Methods 138 6.2 Statistical Methodology and Data Mining Methodology 139 6.3 Cross-Validation 139 6.4 Overfitting 141 6.5 BIAS–Variance Trade-Off 142 6.6 Balancing the Training Data Set 144 6.7 Establishing Baseline Performance 145 The R Zone 146 Reference 147 Exercises 147 Chapter 7 K-Nearest Neighbor Algorithm 149 7.1 Classification Task 149 7.2 k-Nearest Neighbor Algorithm 150 7.3 Distance Function 153 7.4 Combination Function 156 7.4.1 Simple Unweighted Voting 156 7.4.2 Weighted Voting 156 7.5 Quantifying Attribute Relevance: Stretching the Axes 158 7.6 Database Considerations 158 7.7 k-Nearest Neighbor Algorithm for Estimation and Prediction 159 7.8 Choosing k 160 7.9 Application of k-Nearest Neighbor Algorithm Using IBM/SPSS Modeler 160 The R Zone 162 Exercises 163 Hands-On Analysis 164 Chapter 8 Decision Trees 165 8.1 What is a Decision Tree? 165 8.2 Requirements for Using Decision Trees 167 8.3 Classification and Regression Trees 168 8.4 C4.5 Algorithm 174 8.5 Decision Rules 179 8.6 Comparison of the C5.0 and Cart Algorithms Applied to Real Data 180 The R Zone 183 References 184 Exercises 185 Hands-On Analysis 185 Chapter 9 Neural Networks 187 9.1 Input and Output Encoding 188 9.2 Neural Networks for Estimation and Prediction 190 9.3 Simple Example of a Neural Network 191 9.4 Sigmoid Activation Function 193 9.5 Back-Propagation 194 9.5.1 Gradient Descent Method 194 9.5.2 Back-Propagation Rules 195 9.5.3 Example of Back-Propagation 196 9.6 Termination Criteria 198 9.7 Learning Rate 198 9.8 Momentum Term 199 9.9 Sensitivity Analysis 201 9.10 Application of Neural Network Modeling 202 The R Zone 204 References 207 Exercises 207 Hands-On Analysis 207 Chapter 10 Hierarchical and K-Means Clustering 209 10.1 The Clustering Task 209 10.2 Hierarchical Clustering Methods 212 10.3 Single-Linkage Clustering 213 10.4 Complete-Linkage Clustering 214 10.5 k-Means Clustering 215 10.6 Example of k-Means Clustering at Work 216 10.7 Behavior of MSB, MSE, and PSEUDO-F as the k-Means Algorithm Proceeds 219 10.8 Application of k-Means Clustering Using SAS Enterprise Miner 220 10.9 Using Cluster Membership to Predict Churn 223 The R Zone 224 References 226 Exercises 226 Hands-On Analysis 226 Chapter 11 Kohonen Networks 228 11.1 Self-Organizing Maps 228 11.2 Kohonen Networks 230 11.2.1 Kohonen Networks Algorithm 231 11.3 Example of a Kohonen Network Study 231 11.4 Cluster Validity 235 11.5 Application of Clustering Using Kohonen Networks 235 11.6 Interpreting the Clusters 237 11.6.1 Cluster Profiles 240 11.7 Using Cluster Membership as Input to Downstream Data Mining Models 242 The R Zone 243 References 245 Exercises 245 Hands-On Analysis 245 Chapter 12 Association Rules 247 12.1 Affinity Analysis and Market Basket Analysis 247 12.1.1 Data Representation for Market Basket Analysis 248 12.2 Support, Confidence, Frequent Itemsets, and the a Priori Property 249 12.3 How Does the a Priori Algorithm Work? 251 12.3.1 Generating Frequent Itemsets 251 12.3.2 Generating Association Rules 253 12.4 Extension from Flag Data to General Categorical Data 255 12.5 Information-Theoretic Approach: Generalized Rule Induction Method 256 12.5.1 J-Measure 257 12.6 Association Rules are Easy to do Badly 258 12.7 How Can We Measure the Usefulness of Association Rules? 259 12.8 Do Association Rules Represent Supervised or Unsupervised Learning? 260 12.9 Local Patterns Versus Global Models 261 The R Zone 262 References 263 Exercises 263 Hands-On Analysis 264 Chapter 13 Imputation of Missing Data 266 13.1 Need for Imputation of Missing Data 266 13.2 Imputation of Missing Data: Continuous Variables 267 13.3 Standard Error of the Imputation 270 13.4 Imputation of Missing Data: Categorical Variables 271 13.5 Handling Patterns in Missingness 272 The R Zone 273 Reference 276 Exercises 276 Hands-On Analysis 276 Chapter 14 Model Evaluation Techniques 277 14.1 Model Evaluation Techniques for the Description Task 278 14.2 Model Evaluation Techniques for the Estimation and Prediction Tasks 278 14.3 Model Evaluation Techniques for the Classification Task 280 14.4 Error Rate, False Positives, and False Negatives 280 14.5 Sensitivity and Specificity 283 14.6 Misclassification Cost Adjustment to Reflect Real-World Concerns 284 14.7 Decision Cost/Benefit Analysis 285 14.8 Lift Charts and Gains Charts 286 14.9 Interweaving Model Evaluation with Model Building 289 14.10 Confluence of Results: Applying a Suite of Models 290 The R Zone 291 Reference 291 Exercises 291 Hands-On Analysis 291 Appendix: Data Summarization and Visualization 294 Index 309

Read more less

Book Synopsis? C++ is one of the best languages for the development of financial engineering and instrument pricing applications. ? This book applies C++ to the design and implementation of classes, libraries and latest applications for option and derivative pricing models.Table of ContentsCHAPTER 1 A Tour of C++ and Environs 1 1.1 Introduction and Objectives 1 1.2 What is C++? 1 1.3 C++ as a Multiparadigm Programming Language 2 1.4 The Structure and Contents of this Book: Overview 4 1.5 A Tour of C++11: Black–Scholes and Environs 6 1.6 Parallel Programming in C++ and Parallel C++ Libraries 12 1.7 Writing C++ Applications; Where and How to Start? 14 1.8 For whom is this Book Intended? 16 1.9 Next-Generation Design and Design Patterns in C++ 16 1.10 Some Useful Guidelines and Developer Folklore 17 1.11 About the Author 18 1.12 The Source Code and Getting the Source Code 19 CHAPTER 2 New and Improved C++ Fundamentals 21 2.1 Introduction and Objectives 21 2.2 The C++ Smart Pointers 21 2.3 Using Smart Pointers in Code 23 2.4 Extended Examples of Smart Pointers Usage 30 2.5 Move Semantics and Rvalue References 34 2.6 Other Bits and Pieces: Usability Enhancements 39 2.7 Summary and Conclusions 52 2.8 Exercises and Projects 52 CHAPTER 3 Modelling Functions in C++ 59 3.1 Introduction and Objectives 59 3.2 Analysing and Classifying Functions 60 3.3 New Functionality in C++: std::function<> 64 3.4 New Functionality in C++: Lambda Functions and Lambda Expressions 65 3.5 Callable Objects 69 3.6 Function Adapters and Binders 70 3.7 Application Areas 75 3.8 An Example: Strategy Pattern New Style 75 3.9 Migrating from Traditional Object-Oriented Solutions: Numerical Quadrature 78 3.10 Summary and Conclusions 81 3.11 Exercises and Projects 82 CHAPTER 4 Advanced C++ Template Programming 89 4.1 Introduction and Objectives 89 4.2 Preliminaries 91 4.3 decltype Specifier 94 4.4 Life Before and After decltype 101 4.5 std::result_of and SFINAE 106 4.6 std::enable_if 108 4.7 Boost enable_if 112 4.8 std::decay()Trait 114 4.9 A Small Application: Quantities and Units 115 4.10 Conclusions and Summary 118 4.11 Exercises and Projects 118 CHAPTER 5 Tuples in C++ and their Applications 123 5.1 Introduction and Objectives 123 5.2 An std:pair Refresher and New Extensions 123 5.3 Mathematical and Computer Science Background 128 5.4 Tuple Fundamentals and Simple Examples 130 5.5 Advanced Tuples 130 5.6 Using Tuples in Code 133 5.7 Other Related Libraries 138 5.8 Tuples and Run-Time Efficiency 140 5.9 Advantages and Applications of Tuples 142 5.10 Summary and Conclusions 143 5.11 Exercises and Projects 143 CHAPTER 6 Type Traits, Advanced Lambdas and Multiparadigm Design in C++ 147 6.1 Introduction and Objectives 147 6.2 Some Building Blocks 149 6.3 C++ Type Traits 150 6.4 Initial Examples of Type Traits 158 6.5 Generic Lambdas 161 6.6 How Useful will Generic Lambda Functions be in the Future? 164 6.7 Generalised Lambda Capture 171 6.7.1 Living Without Generalised Lambda Capture 173 6.8 Application to Stochastic Differential Equations 174 6.9 Emerging Multiparadigm Design Patterns: Summary 178 6.10 Summary and Conclusions 179 6.11 Exercises and Projects 179 CHAPTER 7 Multiparadigm Design in C++ 185 7.1 Introduction and Objectives 185 7.2 Modelling and Design 185 7.3 Low-Level C++ Design of Classes 190 7.4 Shades of Polymorphism 199 7.5 Is there More to Life than Inheritance? 206 7.6 An Introduction to Object-Oriented Software Metrics 207 7.7 Summary and Conclusions 210 7.8 Exercises and Projects 210 CHAPTER 8 C++ Numerics, IEEE 754 and Boost C++ Multiprecision 215 8.1 Introduction and Objectives 215 8.2 Floating-Point Decomposition Functions in C++ 219 8.3 A Tour of std::numeric_limits 221 8.4 An Introduction to Error Analysis 223 8.5 Example: Numerical Quadrature 224 8.6 Other Useful Mathematical Functions in C++ 228 8.7 Creating C++ Libraries 231 8.8 Summary and Conclusions 239 8.9 Exercises and Projects 239 CHAPTER 9 An Introduction to Unified Software Design 245 9.1 Introduction and Objectives 245 9.1.1 Future Predictions and Expectations 246 9.2 Background 247 9.3 System Scoping and Initial Decomposition 251 9.4 Checklist and Looking Back 259 9.5 Variants of the Software Process: Policy-Based Design 260 9.6 Using Policy-Based Design for the DVM Problem 268 9.7 Advantages of Uniform Design Approach 273 9.8 Summary and Conclusions 274 9.9 Exercises and Projects 275 CHAPTER 10 New Data Types, Containers and Algorithms in C++ and Boost C++ Libraries 283 10.1 Introduction and Objectives 283 10.2 Overview of New Features 283 10.3 C++ std::bitset and Boost Dynamic Bitset Library 284 10.4 Chrono Library 288 10.5 Boost Date and Time 301 10.6 Forwards Lists and Compile-Time Arrays 306 10.7 Applications of Boost.Array 311 10.8 Boost uBLAS (Matrix Library) 313 10.9 Vectors 316 10.10 Matrices 318 10.11 Applying uBLAS: Solving Linear Systems of Equations 322 10.12 Summary and Conclusions 330 10.13 Exercises and Projects 331 CHAPTER 11 Lattice Models Fundamental Data Structures and Algorithms 333 11.1 Introduction and Objectives 333 11.2 Background and Current Approaches to Lattice Modelling 334 11.3 New Requirements and Use Cases 335 11.4 A New Design Approach: A Layered Approach 335 11.5 Initial ‘101’ Examples of Option Pricing 347 11.6 Advantages of Software Layering 349 11.7 Improving Efficiency and Reliability 352 11.8 Merging Lattices 355 11.9 Summary and Conclusions 357 11.10 Exercises and Projects 357 CHAPTER 12 Lattice Models Applications to Computational Finance 367 12.1 Introduction and Objectives 367 12.2 Stress Testing the Lattice Data Structures 368 12.3 Option Pricing Using Bernoulli Paths 372 12.4 Binomial Model for Assets with Dividends 374 12.5 Computing Option Sensitivities 377 12.6 (Quick) Numerical Analysis of the Binomial Method 379 12.7 Richardson Extrapolation with Binomial Lattices 382 12.8 Two-Dimensional Binomial Method 382 12.9 Trinomial Model of the Asset Price 384 12.10 Stability and Convergence of the Trinomial Method 385 12.11 Explicit Finite Difference Method 386 12.12 Summary and Conclusions 389 12.13 Exercises and Projects 389 CHAPTER 13 Numerical Linear Algebra: Tridiagonal Systems and Applications 395 13.1 Introduction and Objectives 395 13.2 Solving Tridiagonal Matrix Systems 395 13.3 The Crank-Nicolson and Theta Methods 406 13.4 The ADE Method for the Impatient 411 13.5 Cubic Spline Interpolation 415 13.6 Some Handy Utilities 427 13.7 Summary and Conclusions 428 13.8 Exercises and Projects 429 CHAPTER 14 Data Visualisation in Excel 433 14.1 Introduction and Objectives 433 14.2 The Structure of Excel-Related Objects 433 14.3 Sanity Check: Is the Excel Infrastructure Up and Running? 435 14.4 ExcelDriver and Matrices 437 14.5 ExcelDriver and Vectors 444 14.6 Path Generation for Stochastic Differential Equations 448 14.7 Summary and Conclusions 459 14.8 Exercises and Projects 459 14.9 Appendix: COM Architecture Overview 463 14.10 An Example 468 14.11 Virtual Function Tables 471 14.12 Differences between COM and Object-Oriented Paradigm 473 14.13 Initialising the COM Library 474 CHAPTER 15 Univariate Statistical Distributions 475 15.1 Introduction, Goals and Objectives 475 15.2 The Error Function and Its Universality 475 15.3 One-Factor Plain Options 478 15.4 Option Sensitivities and Surfaces 488 15.5 Automating Data Generation 491 15.6 Introduction to Statistical Distributions and Functions 499 15.7 Advanced Distributions 504 15.8 Summary and Conclusions 511 15.9 Exercises and Projects 511 CHAPTER 16 Bivariate Statistical Distributions and Two-Asset Option Pricing 515 16.1 Introduction and Objectives 515 16.2 Computing Integrals Using PDEs 516 16.3 The Drezner Algorithm 521 16.4 The Genz Algorithm and the West/Quantlib Implementations 521 16.5 Abramowitz and Stegun Approximation 525 16.6 Performance Testing 528 16.7 Gauss–Legendre Integration 529 16.8 Applications to Two-Asset Pricing 531 16.9 Trivariate Normal Distribution 536 16.10 Chooser Options 543 16.11 Conclusions and Summary 545 16.12 Exercises and Projects 546 CHAPTER 17 STL Algorithms in Detail 551 17.1 Introduction and Objectives 551 17.2 Binders and std::bind 554 17.3 Non-modifying Algorithms 557 17.4 Modifying Algorithms 567 17.5 Compile-Time Arrays 575 17.6 Summary and Conclusions 576 17.7 Exercises and Projects 576 17.8 Appendix: Review of STL Containers and Complexity Analysis 583 CHAPTER 18 STL Algorithms Part II 589 18.1 Introduction and Objectives 589 18.2 Mutating Algorithms 589 18.3 Numeric Algorithms 597 18.4 Sorting Algorithms 601 18.5 Sorted-Range Algorithms 604 18.5.5 Merging 608 18.6 Auxiliary Iterator Functions 609 18.7 Needle in a Haystack: Finding the Right STL Algorithm 612 18.8 Applications to Computational Finance 613 18.9 Advantages of STL Algorithms 613 18.10 Summary and Conclusions 614 18.11 Exercises and Projects 614 CHAPTER 19 An Introduction to Optimisation and the Solution of Nonlinear Equations 617 19.1 Introduction and Objectives 617 19.2 Mathematical and Numerical Background 618 19.3 Sequential Search Methods 619 19.4 Solutions of Nonlinear Equations 620 19.5 Fixed-Point Iteration 622 19.6 Aitken’s Acceleration Process 623 19.7 Software Framework 623 19.8 Implied Volatility 632 19.9 Solvers in the Boost C++ Libraries 632 19.10 Summary and Conclusions 633 19.11 Exercises and Projects 633 19.12 Appendix: The Banach Fixed-Point Theorem 636 CHAPTER 20 The Finite Difference Method for PDEs: Mathematical Background 641 20.1 Introduction and Objectives 641 20.2 General Convection–Diffusion–Reaction Equations and Black–Scholes PDE 641 20.3 PDE Preprocessing 64520.3.2 Reduction of PDE to Conservative Form 646 20.4 Maximum Principles for Parabolic PDEs 649 20.5 The Fichera Theory 650 20.6 Finite Difference Schemes: Properties and Requirements 654 20.7 Example: A Linear Two-Point Boundary Value Problem 655 20.8 Exponentially Fitted Schemes for Time-Dependent PDEs 659 20.9 Richardson Extrapolation 663 20.10 Summary and Conclusions 665 20.11 Exercises and Projects 666 CHAPTER 21 Software Framework for One-Factor Option Models 669 21.1 Introduction and Objectives 669 21.2 A Software Framework: Architecture and Context 669 21.3 Modelling PDEs and Finite Difference Schemes: What is Supported? 670 21.4 Several Versions of Alternating Direction Explicit 671 21.5 A Software Framework: Detailed Design and Implementation 673 21.6 C++ Code for PDE Classes 674 21.7 C++ Code for FDM Classes 679 21.8 Examples and Test Cases 690 21.9 Summary and Conclusions 693 21.10 Exercises and Projects 694 CHAPTER 22 Extending the Software Framework 701 22.1 Introduction and Objectives 701 22.2 Spline Interpolation of Option Values 701 22.3 Numerical Differentiation Foundations 704 22.4 Numerical Greeks 710 22.5 Constant Elasticity of Variance Model 715 22.6 Using Software Design (GOF) Patterns 715 22.7 Multiparadigm Design Patterns 720 22.8 Summary and Conclusions 721 22.9 Exercises and Projects 721 CHAPTER 23A PDE Software Framework in C++11 for a Class of Path-Dependent Options 727 23.1 Introduction and Objectives 727 23.2 Modelling PDEs and Initial Boundary Value Problems in the Functional Programming Style 728 23.3 PDE Preprocessing 731 23.4 The Anchoring PDE 732 23.5 ADE for Anchoring PDE 739 23.6 Useful Utilities 746 23.7 Accuracy and Performance 748 23.8 Summary and Conclusions 750 23.9 Exercises and Projects 751 CHAPTER 24 Ordinary Differential Equations and their Numerical Approximation 755 24.1 Introduction and Objectives 755 24.2 What is an ODE? 755 24.3 Classifying ODEs 756 24.4 A Palette of Model ODEs 757 24.5 Existence and Uniqueness Results 760 24.6 Overview of Numerical Methods for ODEs: The Big Picture 763 24.7 Creating ODE Solvers in C++ 770 24.8 Summary and Conclusions 776 24.9 Exercises and Projects 776 24.10 Appendix 778 CHAPTER 25 Advanced Ordinary Differential Equations and Method of Lines 781 25.1 Introduction and Objectives 781 25.2 An Introduction to the Boost Odeint Library 782 25.3 Systems of Stiff and Non-stiff Equations 791 25.4 Matrix Differential Equations 796 25.5 The Method of Lines: What is it and what are its Advantages? 799 25.6 Initial Foray in Computational Finance: MOL for One-Factor Black-Scholes PDE 801 25.7 Barrier Options 806 25.8 Using Exponential Fitting of Barrier Options 808 25.9 Summary and Conclusions 808 25.10 Exercises and Projects 809 CHAPTER 26 Random Number Generation and Distributions 819 26.1 Introduction and Objectives 819 26.2 What is a Random Number Generator? 820 26.3 What is a Distribution? 821 26.4 Some Initial Examples 825 26.5 Engines in Detail 827 26.6 Distributions in C++: The List 830 26.7 Back to the Future: C-Style Pseudo-Random Number Generation 831 26.8 Cryptographic Generators 833 26.9 Matrix Decomposition Methods 833 26.10 Generating Random Numbers 845 26.11 Summary and Conclusions 848 26.12 Exercises and Projects 849 CHAPTER 27 Microsoft .Net, C# and C++11 Interoperability 853 27.1 Introduction and Objectives 853 27.2 The Big Picture 854 27.3 Types 858 27.4 Memory Management 859 27.5 An Introduction to Native Classes 861 27.6 Interfaces and Abstract Classes 861 27.7 Use Case: C++/CLI as ‘Main Language’ 862 27.8 Use Case: Creating Proxies, Adapters and Wrappers for Legacy C++ Applications 864 27.8.1 Alternative: SWIG (Simplified Wrapper and Interface Generator) 871 27.9 ‘Back to the Future’ Use Case: Calling C# Code from C++11 872 27.10 Modelling Event-Driven Applications with Delegates 876 27.11 Use Case: Interfacing with Legacy Code 886 27.12 Assemblies and Namespaces for C++/CLI 889 27.13 Summary and Conclusions 895 27.14 Exercises and Projects 896 CHAPTER 28 C++ Concurrency, Part I Threads 899 28.1 Introduction and Objectives 899 28.2 Thread Fundamentals 900 28.3 Six Ways to Create a Thread 903 28.4 Intermezzo: Parallelising the Binomial Method 909 28.5 Atomics 916 28.6 Smart Pointers and the Thread-Safe Pointer Interface 924 28.7 Thread Synchronisation 926 28.8 When should we use Threads? 929 28.9 Summary and Conclusions 929 28.10 Exercises and Projects 930 CHAPTER 29 C++ Concurrency, Part II Tasks 935 29.1 Introduction and Objectives 935 29.2 Finding Concurrency: Motivation 936 29.3 Tasks and Task Decomposition 937 29.4 Futures and Promises 941 29.5 Shared Futures 945 29.6 Waiting on Tasks to Complete 948 29.7 Continuations and Futures in Boost 950 29.8 Pure Functions 952 29.9 Tasks versus Threads 953 29.10 Parallel Design Patterns 953 29.11 Summary and Conclusions 955 29.12 Quizzes, Exercises and Projects 955 CHAPTER 30 Parallel Patterns Language (PPL) 961 30.1 Introduction and Objectives 961 30.2 Parallel Algorithms 962 30.3 Partitioning Work 967 30.4 The Aggregation/Reduction Pattern in PPL 971 30.5 Concurrent Containers 977 30.6 An Introduction to the Asynchronous Agents Library and Event-Based Systems 978 30.7 A Design Plan to Implement a Framework Using Message Passing and Other Approaches 986 30.8 Summary and Conclusions 989 30.9 Exercises and Projects 990 CHAPTER 31 Monte Carlo Simulation, Part I 993 31.1 Introduction and Objectives 993 31.2 The Boost Parameters Library for the Impatient 995 31.3 Monte Carlo Version 1: The Monolith Program (‘Ball of Mud’) 1000 31.4 Policy-Based Design: Dynamic Polymorphism 1003 31.5 Policy-Based Design Approach: CRTP and Static Polymorphism 1011 31.6 Builders and their Subcontractors (Factory Method Pattern) 1013 31.7 Practical Issue: Structuring the Project Directory and File Contents 1014 31.8 Summary and Conclusions 1016 31.9 Exercises and Projects 1017 CHAPTER 32 Monte Carlo Simulation, Part II 1023 32.1 Introduction and Objectives 1023 32.2 Parallel Processing and Monte Carlo Simulation 1023 32.3 A Family of Predictor–Corrector Schemes 1033 32.4 An Example (CEV Model) 1038 32.5 Implementing the Monte Carlo Method Using the Asynchronous Agents Library 1041 32.6 Summary and Conclusions 1047 32.7 Exercises and Projects 1050 Appendix 1: Multiple-Precision Arithmetic 1053 Appendix 2: Computing Implied Volatility 1075 References 1109 Index 1117

Read more less

Book SynopsisCrucial Help for Getting the Most from Today''s Information Systems Technology Deciding what type of information systems your company will need to stay competitive into the twenty-first century is a highly complex and risky exercise. SAP: An Executive''s Comprehensive Guide provides the information you need to assess your options realistically and make the most informed decisions possible. Written by a team of business, financial, and information systems professionals who have extensive experience with SAP system implementations at Fortune 500 companies, this book: * Explores the strategic role of client/server enterprise computing now and in the next century * Helps you to evaluate your company''s long-term IS requirements * Offers an impartial look at SAP R/3 strengths and weaknesses * Outlines the costs and benefits involved in implementing SAP R/3 * Helps you decide whether SAP R/3 is right for your organization * Shows you how to make SAP R/3 anTable of ContentsPartial table of contents: THE EXECUTIVE VIEW. Who Is SAP, and What Is R/3? What Is the Business Case for Implementing SAP Software? Are We Ready to Implement SAP/R3? What Do I Need to Know About SAP R/3 Functionality? Competitors to SAP. THE IMPLEMENTOR'S VIEW: TOOLS AND ISSUES. Methodologies. Tools. Process Redesign. Risk Management. Change Management. THE IMPLEMENTOR'S VIEW: TOOLS AND ISSUES. Methodologies. Tools. Process Redesign. Risk Management. Change Management. THE IMPLEMENTOR'S VIEW: THE IMPLEMENTATION PROCESS. Initiation and Planning. Getting SAP in Place. Deployment Options. SAP Tools. Third-Party Tools. Glossary. Index.

Read more less

Book SynopsisIn the last 10 years, there has been an explosion in the number of technologies, standards, and tools to provide process support. The book provides a unified and comprehensive overview of the principles, techniques and technologies underlying the emerging discipline of process aware information systems engineering.Trade Review"…well-written and edited, and includes a brief appendix and a word index, both useful aids." (Computing Reviews.com, January 9, 2007) "…a comprehensive overview of the technical aspects of building PAIS…it is a recommended starting resource." (Computing Reviews.com, May 17, 2006)Table of ContentsPreface. Contributors. PART I Concepts. 1 Introduction (Marlon Dumas, Wil van der Aalst, and Arthur H. M. ter Hofstede). 1.1 From Programs and Data to Processes. 1.2 PAIS: Definition and Rationale. 1.3 Techniques and Tools. 1.4 Classifications. 1.5 About the Book. References. 2 Person-to-Application Processes: Workflow Management (Andreas Oberweis). 2.1 Introduction. 2.2 Workflow Terminology. 2.3 Workflow Modeling. 2.4 Workflow Management Systems. 2.5 Outlook. 2.6 Exercises. References. 3 Person-to-Person Processes: Computer-Supported Collaborative Work (Clarence A. Ellis, Paulo Barthelmess, Jun Chen, and Jacques Wainer). 3.1 Introduction. 3.2 Characterization of Person-to-Person Interactions. 3.3 Characterization of Person-to-Person Systems. 3.4 Example Systems. 3.5 Summary and Conclusions. 3.6 Exercises. References. 4 Enterprise Application Integration and Business-to-Business Integration Processes (Christoph Bussler). 4.1 Introduction. 4.2 Examples of EAI and B2B Processes. 4.3 Concepts, Architectures, and Tools. 4.4 Future Developments. 4.5 Exercises. References. PART II Modeling Languages. 5 Process Modeling Using UML (Gregor Engels, Alexander Förster, Reiko Heckel, and Sebastian Thöne). 5.1 Introduction. 5.2 Modeling Control Flow with Activity Diagrams. 5.3 Modeling Objects and Object Flow. 5.4 Modeling Organizational Structure. 5.5 Modeling Business Partner Interactions. 5.6 System-Specific Process Models. 5.7 Summary. 5.8 Exercises. References. 6 Process Modeling Using Event-Driven Process Chains (August-Wilhelm Scheer, Oliver Thomas, and Otmar Adam). 6.1 Introduction. 6.2 Overview of EPC. 6.3 The ARIS Business Process Meta-Model. 6.4 How to Correctly Model EPCs. 6.5 The ARIS Architecture. 6.6 Future Extensions. 6.7 Exercises. References. 7 Process Modeling Using Petri Nets (Jörg Desel). 7.1 Introduction. 7.2 Petri Nets. 7.3 Petri Net Classes and Behavior. 7.4 Modeling Single Processes Without Resources. 7.5 Modeling Processes with Resources. 7.6 Behavior and Refinement. 7.7 Analysis. 7.8 Net Classes. Exercises. References. 8 Patterns of Process Modeling (Wil van der Aalst, Arthur H. M. ter Hofstede, and Marlon Dumas). 8.1 Introduction. 8.2 Classification of Patterns. 8.3 Examples of Control-Flow Patterns. 8.4 Conclusion. 8.5 Exercises. Acknowledgments. References. PART III Techniques. 9 Process Design and Redesign (Hajo A. Reijers). 9.1 Introduction. 9.2 Methodologies, Techniques, and Tools. 9.3 Business Process Performance Indicators. 9.4 Redesigning Processes Using Best Practices. 9.5 Information-Based Business Process Design. 9.6 Conclusion. 9.7 Exercises. References. 10 Process Mining (Wil van der Aalst and A.J.M.M. (Ton) Weijters). 10.1 Introduction. 10.2 Process Mining: An Overview. 10.3 Process Mining with the Algorithm. 10.4 Limitations of the Alpha Approach and Possible Solutions. 10.5 Conclusion. 10.6 Exercises. Acknowledgments. References. 11 Transactional Business Processes (Gustavo Alonso). 11.1 Introduction. 11.2 Transactional Consistency. 11.3 Atomicity. 11.4 Infrastructure for Implementing Atomicity. 11.5 Outlook. 11.6 Exercises and Assignments. Acknowledgments. References. PART IV Standards and Tools. 12 Standards for Workflow Definition and Execution (Jan Mendling, Michael zur Muehlen, and Adrian Price). 12.1 Introduction. 12.2 Standardization Bodies Relevant to PAIS. 12.3 WfMC Reference Model and WfMC Glossary. 12.4 Process Definition in XPDL. 12.5 Process Invocation Using WF-XML. 12.6 Trends. 12.7 Exercises. References. 13 The Business Process Execution Language for Web Services (Rania Khalaf, Nirmal Mukhi, Francisco Curbera, and Sanjiva Weerawarana). 13.1 Introduction to Web Services. 13.2 BPEL4WS. 13.3 Summary. 13.4 Exercises. References. 14 Workflow Management in Staffware (Charles Brown). 14.1 Introduction. 14.2 Architecture. 14.3 Integration Tools. 14.4 Methodology. 14.5 Resourcing. 14.6 Conclusion. 14.7 Exercises. References. 15 The FLOWer Case-Handling Approach: Beyond Workflow Management (Paul Berens). 15.1 Outline. 15.2 Overview of Case Handling and FLOWer. 15.3 Conceptual Integrity of FLOWer. 15.4 Golden Rules of Process Management. 15.5 Conclusion. Acknkowledgment. References. Appendix: Readings and Resources. Index.

Read more less

Book SynopsisAutoCAD 2007 is a premiere computer-aided designing program that lets you organize the objects you draw, their properties, and their files. It also helps you create great-looking models. But it's not always easy to figure out how to perform these functions, and many users end up missing out on AutoCAD's full potential.Table of ContentsIntroduction. Part I: AutoCAD 101. Chapter 1: Introducing AutoCAD and AutoCAD LT. Chapter 2: Le Tour de AutoCAD 2007. Chapter 3: A Lap Around the CAD Track. Chapter 4: Setup for Success. Part II: Let There Be Lines. Chapter 5: Get Ready to Draw. Chapter 6: Where to Draw the Line. Chapter 7: Edit for Credit. Chapter 8: A Zoom with a View. Chapter 9: On a 3D Spree. Part III: If Drawings Could Talk. Chapter 10: Text with Character. Chapter 11: Entering New Dimensions. Chapter 12: Down the Hatch. Chapter 13: The Plot Thickens. Part IV: Share and Share Alike. Chapter 14: Playing Blocks and Rasteroids. Chapter 15: Drawing on the Internet. Part V: The Part of Tens. Chapter 16: Ten Ways to Do No Harm. Chapter 17: Ten Ways to Swap Drawing Data with Other People and Programs. Index.

Read more less

Book SynopsisIncorporating recent developments in control and systems research,Linear Control Theory provides the fundamental theoreticalbackground needed to fully exploit control system design software.This logically-structured text opens with a detailed treatment ofthe relevant aspects of the state space analysis of linear systems.End-of-chapter problems facilitate the learning process byencouraging the student to put his or her skills into practice.Features include: * The use of an easy to understand matrix variational technique todevelop the time-invariant quadratic and LQG controllers * A step-by-step introduction to essential mathematical ideas asthey are needed, motivating the reader to venture beyond basicconcepts * The examination of linear system theory as it relates to controltheory * The use of the PBH test to characterize eigenvalues in the statefeedback and observer problems rather than its usual role as a testfor controllability or observability * The development Trade Review"...not only covers the essential topics of linear systems...but also covers the other popular control topics such as Linear Quadratic Regulator...will find its use for students interested in advanced control topics." (International Journal of Robust and Linear Control, Vol. 12, 2002)Table of ContentsIntroduction to State Space. State Feedback and Controllability. State Estimation and Observability. Model Approximation via Balanced Realization. Quadratic Control. LQG Control. Signal and System Spaces. System Algebra. Hx State Feedback and Estimation. Hx Output Feedback Control. Appendices. References. Index.

Read more less

Book SynopsisThe Interactive Accounting Workbook has been rigorously developed to support the revolutionary new Interactive Accounting software.Table of Contents1. Financial Accounting Manuel. 2. Absorption Costing Manuel. 3. Marginal Costing. 4. Standard Costing Manuel. 5. Capital Investment Appraisal Manuel. Index.

Read more less

Book SynopsisProvides an introductory guide to Microsoft's entry into the Customer Relationship Management (CRM) software marketplace. This book discusses the key features of Microsoft's CRM software, including tools to help businesses sell more effectively, track and convert leads, make informed decisions faster, and provide consistent service.Table of ContentsIntroduction. Part I: Microsoft CRM Basics. Chapter 1: Looking Over Microsoft CRM. Chapter 2: Navigating the Microsoft CRM System. Chapter 3: Personalizing Your System. Part II: Managing Sales. Chapter 4: Working with Accounts and Contacts. Chapter 5: Creating and Managing Activities. Chapter 6: Using Notes and Attachments. Chapter 7: Using Your E-Mail. Chapter 8: Managing Territories. Chapter 9: Leads and Opportunities. Chapter 10: Using the Product Catalog. Chapter 11: Generating Quotes, Orders, and Invoices. Chapter 12: Sales Literature and Competitors. Chapter 13: Sales Quotas and Forecasting. Part III: Customer Service. Chapter 14: Working with Cases. Chapter 15: The Subject Manager. Chapter 16: Using the Knowledge Base. Chapter 17: Managing the Queues. Chapter 18: Working with Contracts. Part IV: Managing the WorkPlace. Chapter 19: Managing Business Units. Chapter 20: Security and Access Rights. Chapter 21: Implementing a Sales Process. Chapter 22: Business Rules and Workflow. Chapter 23: Running Reports. Part V: The Part of Tens. Chapter 24: Almost Ten Add-On Products. Chapter 25: Ten Ways to Get Help. Part VI: Appendixes. Chapter 26: Imitating Outlook. Chapter 27: Importing and Exporting Data. Chapter 28: Glossary. Chapter 29: Hardware, Networks, and Licenses. Index.

Read more less

Book SynopsisCovers accessing and distilling PDF files; converting Microsoft Office documents; capturing paper documents and Web pages; printing, annotating, editing and securing PDF files; extracting text and graphics; cataloging and distributing PDF files; creating interactive forms; and building multimedia presentations.Table of ContentsIntroduction 1 Part I: Presenting Acrobat and PDF Files 7 Chapter 1: The Ins and Outs of PDF Files 9 Chapter 2: Accessing PDF Files 21 Chapter 3: Getting Acquainted with Acrobat 6 53 Part II: The Wealth of Ways for Creating PDF Files 79 Chapter 4: Distilling PDF Files 81 Chapter 5: Converting Microsoft Office Documents 107 Chapter 6: Capturing Paper Documents 121 Chapter 7: Capturing Web Pages 133 Chapter 8: Printing PDF Files 147 Part III: Reviewing, Editing, and Securing PDFs 159 Chapter 9: Annotating PDF Files for Review 161 Chapter 10: Editing PDF Files 203 Chapter 11: Securing PDF Files 239 Chapter 12: Extracting Text and Graphics from PDF Files 263 Chapter 13: Cataloging and Distributing PDF Files 275 Part IV: PDFs as Electronic Documents 291 Chapter 14: Creating Interactive Forms 293 Chapter 15: Building and Publishing eBooks 327 Chapter 16: Making PDFs into Multimedia Presentations 355 Part V: The Part of Tens 377 Chapter 17: Top Ten Third-Party Acrobat Plug-Ins 379 Chapter 18: Top Ten Online Resources 383 Index 387

Read more less

Book SynopsisShows you how to create simple or sophisticated reports, turning data into interactive, actionable reports that convey what's happening in your business. This title helps you how to store your information securely in Crystal Repository and use Crystal Analysis 10 to display OLAP data so you and your report's readers can analyze the information.Table of ContentsIntroduction. Part I: Reporting Basics. Chapter 1: Transforming Raw Data into Usable Information. Chapter 2: Create a Simple Report Right Now! Chapter 3: Report Design Guidelines. Chapter 4: Reporting Overview. Part II: Moving Up to Professional Quality Reports. Chapter 5: Pulling Specific Data from a Database. Chapter 6: Sorting, Grouping, and Totaling Result Sets. Chapter 7: Mastering Report Sections. Chapter 8: Formatting Your Reports. Part III: Advanced Report Types and Features. Chapter 9: Displaying Your Favorite Hit Parade with Group Sort. Chapter 10: Making Correlations with Cross-Tab Reports. Chapter 11: Adding Formulas to Reports. Chapter 12: Creating Reports within a Report. Chapter 13: Combining Report Elements with OLE. Chapter 14: Creating and Updating OLAP Reports. Chapter 15: Enhancing Reports with Charts. Chapter 16: Adding Geographic Detail with Maps. Part IV: Crystal Reports in the Enterprise. Chapter 17: Crystal Enterprise Components. Chapter 18: Crystal Repository. Chapter 19: Maintaining Security. Chapter 20: Navigating with Report Parts. Chapter 21: Crystal Analysis 10. Part V: Publishing Your Reports. Chapter 22: Distributing and Viewing Reports. Chapter 23: Displaying Reports Online. Chapter 24: SQL Commands. Part VI: The Part of Tens. Chapter 25: Ten Things to Do Before You Create a Report. Chapter 26: Ten Ways to Give Your Reports More Pizzaz. Index.

Read more less

Book SynopsisGet the scoope on how to use VBA to create more powerful Access databases and applications.Table of ContentsIntroduction 1 Part I: Introducing VBA Programming 7 Chapter 1: Where VBA Fits In 9 Chapter 2: Your VBA Toolkit 21 Chapter 3: Jumpstart: Creating a Simple VBA Program 35 Part II: VBA Tools and Techniques 49 Chapter 4: Understanding Your VBA Building Blocks 51 Chapter 5: Controlling Access through VBA 71 Chapter 6: Programming Access Forms 87 Part III: VBA, Recordsets, and SQL 115 Chapter 7: The Scoop on SQL and Recordsets 117 Chapter 8: Putting Recordsets to Work 147 Part IV: Applying VBA in the Real World 173 Chapter 9: Creating Your Own Dialog Boxes 175 Chapter 10: Customizing Lists and Drop-Down Menus 201 Chapter 11: Creating Your Own Functions 241 Chapter 12: Testing and Debugging Your Code 267 Part V: Reaching Out with VBA 295 Chapter 13: Using VBA with Multiple Databases 297 Chapter 14: Integrating with Other Office Applications 317 Part VI: The Part of Tens 349 Chapter 15: Ten Commandments of Writing VBA 351 Chapter 16: Top Ten Nerdy VBA Tricks 357 Chapter 17: (Way More Than) Ten Shortcut Keys 367 Index 371

Read more less

Book Synopsis

Read more less

Book Synopsis

Read more less

Book SynopsisNow in a fully updated new edition, this work presents the leading guide to architectural programming, giving the design practitioner a clear procedure when programming a building of any scale.Table of ContentsForeword vii Preface ix Acknowledgments xi Part One 1 Problem Seeking An Architectural Programming Primer Overview 2 The Primer 2 The Search 4 Programmers and Designers 6 Analysis and Synthesis 8 The Separation 10 The Interface 12 Process 14 Five Steps 14 Procedure 16 Considerations 18 The Whole Problem 18 Four Considerations 20 Framework 22 Information 24 Information Index Matrix 26 Organizing Information 28 Two- Phase Process 30 Data Clog 32 Processing and Discarding 34 Participation 36 User on Team 36 Effective Group Action 38 Team 40 Participatory Process 42 Background Information 43 Decision Making 44 Communication 46 Steps 48 Establish Goals 48 Collect and Analyze Facts 50 Uncover and Test Concepts 52 Determine Needs 66 Cost Estimate Analysis 68 Abstract to the Essence 70 State the Problem 72

Read more less

Book SynopsisThe latest in parallel EM solutions with both in-core and out-of-core solvers The solution of complex electromagnetic (EM) problems requires one to address the issues related with numerical accuracy and efficient distribution of the solution procedure over multiple computational nodes. With the advent of multicore processors and high performance computing (HPC) technology, the EM software designers need to know how to add new functionality to computational EM codes so that they can run efficiently on these new processors. Higher Order Basis Based Integral Equation Solver [HOBBIES] presents a road map for the analysis of complex material structures using the high-performance parallel simulation software known as HOBBIES. Focusing on the Method of Moments (MoM), the book features new parallel programming techniques and user-friendly code with superior capabilities for solving challenging EM radiation and scattering problems. It provides readers with Table of ContentsPreface xv Acknowledgments xxi Acronyms xxiii Chapter 1. Electromagnetic Modeling of Composite Metallic and Dielectric Structures Using Higher Order Basis Functions 1 1.0 Summary 1.1 Integral Equations for Dielectric Structures 1.2 A General Formulation for the Analysis of Composite Metallic and Dielectric Structures 5 1.3 Geometric Modeling 8 1.4 MoM Modeling of the Structures 14 1.5 Description of Higher Order Basis Functions 21 1.6 Testing Procedure 28 1.7 Modeling of the Excitations 35 1.8 Examples Illustrating the Requirements of the Geometrical Modeling 39 1.9 Examples Illustrating the Salient Features of the Higher Order Basis Functions 43 1.10 Performance of the PMCHW Formulation Using Higher Order Basis Functions for Different Values of the Dielectric Constants 48 1.11 Performance of the PMCHW Formulation at Very Low Frequencies Using Higher Order Basis Functions for Dielectric Bodies 50 1.12 Evaluation of Antenna and Scatterer Characteristics 52 1.13 Conclusions 55 References 55 Chapter 2. Parallel In-Core and Out-of-Core LU Factorization for Solving a Matrix Equation and the Corresponding Parallel Matrix Filling in HOBBIES 57 2.0 Summary 5 2.1 Matrix Equation Resulting from a MoM Code 58 2.2 In-core Matrix Equation Solver 58 2.3 Parallel Implementation of an In-core Solver 60 2.4 Data Decomposition for an Out-of-Core Solver 64 2.5 On-slab, Left-looking, Out-of-core LU Algorithm 66 2.6 Solving a Matrix Equation Using the Out-of-core LU Matrices 74 2.7 Parallel In-core and Out-of-core Matrix Filling Schemes 76 2.8 Conclusions 80 References 81 Chapter 3. Getting Started and Working with HOBBIES Projects 83 3.0 Summary 83 3.1 System Requirements 83 3.2 Installing HOBBIES 84 3.3 Starting HOBBIES 90 3.4 Navigation through HOBBIES 91 3.5 Working with HOBBIES Projects 101 3.6 Flowchart for Making a HOBBIES Simulation 103 3.7 Exiting HOBBIES 105 3.8 Getting Help 105 3.9 Quick Start 105 3.10 Conclusion 106 References 106 Chapter 4. Creating a Geometry Model in HOBBIES 107 4.0 Summary 107 4.1 Creating a Simple Model Using the Structure Menu 107 4.2 Creating an Arbitrarily Shaped Model Using the Geometry Menu 156 4.3 Operations on a Model 171 4.4 Manipulations on a Model 189 4.5 Delete a Model 197 4.6 Conclusion 197 References 198 Chapter 5. Meshing a Model in HOBBIES 199 5.0 Summary 199 5.1 Unstructured Mesh 200 5.2 Structured Mesh 202 5.3 Element Type 205 5.4 Mesh Criteria 206 5.5 Reset Mesh Data 207 5.6 Draw 208 5.7 Generate Mesh 210 5.8 Erase Mesh 211 5.9 Edit Mesh 211 5.10 Show Errors 212 5.11 Mesh Quality 213 5.12 Mesh Options from Model 214 5.13 Mesh Generation Example for Surfaces 214 5.14 Example of Mesh Generation for a Curve 218 5.15 Assigning Element Sizes for Generating the Mesh 221 5.16 Conclusion 226 References 226 Chapter 6. Setting up a HOBBIES Solution and Running a Simulation 227 6.0 Summary 227 6.1 Operation Mode 228 6.2 Units 228 6.3 Frequency Range 230 6.4 Domains 230 6.5 Loadings 238 6.6 Excitation 242 6.7 Symmetry 248 6.8 Edge 250 6.9 Output Settings 254 6.10 Options 258 6.11 Running Simulations 265 6.12 Conclusion 272 Chapter 7. HOBBIES Post-Processing for Visualizing the Results 273 7.0 Summary 273 7.1 Entering Post-Processing Window 274 7.2 Post-Processing Window 274 7.3 Example of Operations in Post-Processing 280 7.4 Leaving Post-Processing Window 316 7.5 Limitation of Post-Processing display in Academic Version of HOBBIES 320 7.6 Conclusion 320 Chapter 8. Solving Electromagnetic Field Problems Using HOBBIES 321 8.0 Summary 321 8.1 Metallic Structures 322 8.2 Composite Metallic and Dielectric Structures 350 8.3 Loadings 374 8.4 Use of Symmetry in the Analysis of a Problem 398 8.5 Antenna above a Real Ground 428 8.6 Use of Imaging for Generating an Accurate Solution 436 8.7 Conclusion 442 References 442 Chapter 9. Advanced Electromagnetic Modeling Using HOBBIES 443 9.0 Summary 443 9.1 Radiation Analysis of Complicated Antennas 444 9.2 Radar Cross Section (RCS) Calculation of Complex Targets 458 9.3 Conclusion 476 References 476 Chapter 10. HOBBIES Optimizer and its Applications 479 10.0 Summary 10.1 Flowchart of the HOBBIES Optimizer 480 10.2 Optimization Algorithms Used in the Optimizer 482 10.3 Setting up the HOBBIES Optimizer 487 10.4 Optimization Examples 507 10.5 Conclusion 516 References 516 Appendix A. A Brief Summary of Some Commands Used in HOBBIES 517 Appendix B. A List of all Codes in the Accompanying CD 525 Index 531

Read more less

Book SynopsisThe essential fundamentals of 3D animation for aspiring 3D artists 3D is everywhere--video games, movie and television special effects, mobile devices, etc. Many aspiring artists and animators have grown up with 3D and computers, and naturally gravitate to this field as their area of interest.Table of ContentsIntroduction xv Chapter 1 3D Animation Overview 1 Defining 3D Animation 1 Exploring the 3D Animation Industry 2 Entertainment 2 Scientific 4 Other 9 The History of 3D Animation 10 Early Computers 10 1960s: The Dawn of Computer Animation 11 1970s: The Building Blocks of 3D Animation 12 1980s: The Foundations of Modern Computing 14 1990s: 3D Animation Achieves Commercial Success 17 2000s: The Refining of 3D Animation 18 The Essentials and Beyond 19 Chapter 2 Getting to Know the Production Pipeline 21 Understanding the Production Pipeline’s Components 21 Working in 3D Animation Preproduction 22 Idea/Story 25 Script/Screenplay 27 Storyboard 28 Animatic/Pre-visualization 29 Design 30 Working in 3D Animation Production 33 Layout 34 Research and Development 36 Modeling 37 Texturing 39 Rigging/Setup 40 Animation 41 3D Visual Effects 41 Lighting/Rendering 42 Working in 3D Animation Postproduction 43 Compositing 44 2D Visual Effects/Motion Graphics 44 Color Correction 44 Final Output 45 Using Production Tools 45 Production Bible 46 Folder Management and Naming Conventions 52 The Essentials and Beyond 52 Chapter 3 Understanding Digital Imaging and Video 55 Understanding Digital Imaging 55 Pixels 55 Raster Graphics vs. Vector Graphics 58 Anti-Aliasing 59 Basic Graphic-File Formats 62 Channels 64 Color Depth or Bit Depth 66 Color Calibration 68 Understanding Digital Video 71 Resolution, Device Aspect Ratio, and Pixel Aspect Ratio 72 Safe Areas 74 Interlaced and Progressive Scanning 75 Compression 78 Frame Rate and Timecode 79 Digital Image Capture 80 The Essentials and Beyond 81 Chapter 4 Exploring Animation, Story, and Pre-visualization 83 Using Principles of Fine Art and Traditional Animation 83 Modeling 84 Texturing/Lighting 87 Character Animation 93 VFX 104 Building a Good Story 105 Story Arc 105 Character, Goal, and Conflict 106 The Hero’s Journey 110 Other Storytelling Principles 112 Using Pre-visualization Techniques 113 Basic Shot Framing 114 Camera Movements 126 Editing 130 The Essentials and Beyond 132 Chapter 5 Understanding Modeling and Texturing 135 Modeling 135 Polygons 136 NURBS 150 Subdivision Surfaces 153 Modeling Workflows 154 Texturing 158 UVs 160 Shaders 163 Texture Maps 167 Texturing Workflows 173 The Essentials and Beyond 174 Chapter 6 Rigging and Animation 177 Rigging 177 Parenting 179 Pivot Positions 180 Skeleton System 182 Forward and Inverse Kinematics 185 Deformers 186 Constraints 190 Scripting 191 Expressions 191 The Basic Rigging Workflow 192 Animation 193 Keyframe 196 Graph Editor 197 Timeline 202 Dope Sheet 202 Workspace 202 Tracking Marks and Ghosting 204 FK and IK 204 Video Reference 206 The Basic Animation Workflow 206 Animation Techniques 206 The Essentials and Beyond 210 Chapter 7 Understanding Visual Effects, Lighting, and Rendering 213 Creating Visual Effects 213 Particles 214 Hair and Fur 216 Fluids 218 Rigid Bodies 220 Soft Bodies 222 The Basic VFX Workflow 225 Lighting 225 Light Types 226 Light Attributes 230 Lighting Techniques 233 The Basic Lighting Workflow 236 Rendering 237 Basic Rendering Methods 237 Global Illumination 240 Advanced Shader Functions 243 The Basic Rendering Workflow 244 The Essentials and Beyond 246 Chapter 8 Hardware and Software Tools of the Trade 249 Choosing a Computer 250 Choosing a Computer Type 250 Understanding Operating Systems 252 Selecting the Components 255 Using Monitors/Displays 260 Working with Graphics Tablets 261 Using 3D Scanners 262 Setting Up Render Farms 264 Finding Data Storage Solutions 265 Local 266 Local Networked 266 Offsite 267 Cloud/Internet 267 Choosing Software 268 Comprehensive 3D Animation Packages 268 CAD 269 Compositing 269 Digital Imaging 270 3D Specialty 270 The Essentials and Beyond 272 Chapter 9 Industry Trends 275 Using Motion Capture 275 Marker Systems 276 Markerless Systems 277 Creating Stereoscopic 3D 278 Integrating Point-Cloud Data 281 Providing Real-Time Capabilities 282 Real-Time Rendering 284 Real-Time Animation 285 Real-Time Motion Performance 287 Working in Virtual Studios 288 The Essentials and Beyond 289 Appendix A Answers to Review Questions 291 Appendix B Gaining Insight into 3D Animation Education 299 Linda Sellheim 299 Larry Richman 303 Steve Kolbe 307 Appendix C Learning from Industry Pros 313 Brian Phillips 313 Jim Rivers 316 Rosie Server 321 Index 327

Read more less

Book SynopsisA complete guide to creating usable, realistic game characters with two powerful tools Creating viable game characters requires a combination of skills. This book teaches game creators how to create usable, realistic game assets using the power of an open-source 3D application and a free game engine.Table of ContentsIntroduction xv Chapter 1: Basic Game Art Concepts 1 Game Design Workflows 2 Creating Game Assets 4 Understanding and Optimizing 3D Game Art 9 Working with Game Engines 20 Scripting Happens 21 Chapter 2: Blender Basics for Game Characters 23 Working with Blender’s Unique Features 24 Working with Editor Arrangement and Types 26 Navigating and Viewing 3D Space 32 Creating and Manipulating Objects 33 Using the Properties Editor 36 Know Your Hotkeys 37 Making a Simple Block Character 39 Useful Techniques 44 Chapter 3: Modeling the Character 45 Working with Model Sheets 46 Shaping the Torso for Low Polygon Count 48 Extruding the Legs and Feet 51 Making the Arms and Hands 56 Separating Body Components to Create Clothing 62 Creating the Head with Poly-by-Poly Modeling 65 Carving Out Zombie Damage 82 Chapter 4: Prepping for Zombie Details with UV Unwrapping 87 The Uses of UV Layouts 88 Drawing Seams 89 Using Blender's UV/Image Editor 97 Laying Out a UV Sheet 100 Using Blender's Live Unwrap Functions 102 Chapter 5: Sculpting for Normal Maps 105 The Purpose of Sculpting 106 Introducing the Multires Modifier 107 Using Blender's Sculpting Interface 110 Sculpting the Zombie in Blender 120 Baking Normal Maps 128 Chapter 6: Digital Painting Color Maps 135 Understanding Digital Painting 136 Preparing for Color Map Painting 142 Digital Painting Best Practices 144 Applying Your Color Map to the Zombie 154 Chapter 7: Rigging for Realistic Movement 157 Understanding Rigging 158 Creating a Simple Armature 164 Finishing the Armature with Constraints 175 Linking the Armature and Zombie 184 Chapter 8: Animating the Zombie 193 Understanding and Planning Game Animation 194 Using Blender's Animation System 200 Creating an Idle Animation 203 Creating a Walk Animation 208 Creating a Chase Animation 210 Creating a Run Animation 212 Organizing Your Animations 214 Chapter 9: Unity Engine Basics 217 Understanding Unity’s Logic and Interface 218 Building a Whiteblock Level with Unity Primitives 223 Creating and Editing Materials in Unity 232 Organizing Assets with Unity Empties 234 Chapter 10: Implementing Your Zombie in a Unity Game 237 Importing Models into Unity 238 Unity Scripting--A Crash Course 240 Adding Interactivity to the Zombie 247 Turning the First Person Controller into an FPS Hero 259 Adding Other Gameplay Elements 270 Wrapping Up 278 Index 279

Read more less

Book SynopsisWe are facing a future of unbounded complexity. Whether that complexity is harnessed to build a world that is safe, pleasant, humane and profitable, or whether it causes us to careen off a cliff into an abyss of mind-numbing junk is an open question.Trade Review“This book provides a refreshing, insightful guide to how companies can prepare for future technology innovations and thrive in this emerging information age. Summing Up: Recommended. Business and computer science collections serving upper-division undergraduates and above; general readers.” (Choice, 1 July 2013)Table of ContentsPreface xi Acknowledgments xvii Chapter 1 The Future, So Far 01 Trillions Is a Done Deal 02 Connectivity Will Be the Seed of Change 05 Computing Turned Inside Out 07 The Power of Digital Literacy 11 Chapter 2 The Next Mountain 15 Fungible Devices 16 Liquid Information 25 Cyberspace for Real 30 Interlude Yesterday, Today, Tomorrow: Platforms and User Interfaces 39 Yesterday 40 Today 41 Tomorrow 44 Chapter 3 The Tyranny of the Orthodoxy 51 Information Interruptus 52 The King and the Mathematician 60 Links to Nowhere 63 The Wrong Cloud 65 The Dream of One Big Computer 67 The Grand Repository in the Sky 68 FUD and the Birth of the Impostor Cloud 69 The Children’s Crusade 71 The Peer-to-Peer Bogey 80 Chapter 4 How Nature Does It 83 The Internet of Plants 84 Nature Has Been There Before 85 The Qualities of Beautiful Complexity 93 At the Intersection of People and Information 102 Chapter 5 How Design Does It 105 Birth of Industrial Design 107 Novelty, Beauty, Ritual, and Comfort 113 Hearing History Rhyme 114 Instability as the Status Quo 117 Post-Industrial Design 119 Interlude Yesterday, Today, Tomorrow: Data Storage 133 Yesterday 133 Today 136 Tomorrow 136 Chapter 6 Design Science on Trillions Mountain 139 Beyond Design Thinking to Design Science 140 Make the Right Thing 143 Chapter 7 Architecture with a Capital “A” 167 Architecture as Organic Principles 169 Architecture as Model 170 Architecture as “Style” 171 Information Architecture 173 Architecture and Design Science 178 Chapter 8 Life in an Information Ecology 181 Components 183 Challenges in the Information Ecology 188 Chapter 9 Aspects of Tomorrow 205 Beyond the Internet 206 Simplification 208 Devices 210 The Information Commons 212 The World Wide Dataflow 213 Publishing 216 Safety, Security, and Privacy 218 Epilogue Thriving in the Spacious Foothills 221 Seize the Low Ground 224 Microtransactions and the Rise of T-Commerce 225 Strange Bedfellows 226 Big Data and Information Visualization 226 The Trillions Bubble 227 Notes 231 About the Authors 245 Index 247

Read more less

Book SynopsisA radical approach to getting IT projects done faster and cheaper than anyone thinks possible Software in 30 Days summarizes the Agile and Scrum software development method, which allows creation of game-changing software, in just 30 days. Projects that use it are three times more successful than those that don''t. Software in 30 Days is for the business manager, the entrepreneur, the product development manager, or IT manager who wants to develop software better and faster than they now believe possible. Learn how this unorthodox process works, how to get started, and how to succeed. Control risk, manage projects, and have your people succeed with simple but profound shifts in the thinking. The authors explain powerful concepts such as the art of the possible, bottom-up intelligence, and why it''s good to fail earlyall with no risk greater than thirty days. The productivity gain vs traditional waterfall methods has been over 100% on many prTable of ContentsAbout the Authors xi Acknowledgments xiii Introduction xv Section I Why Every Business in the World Can Produce Software in 30 Days 1 You are probably frustrated with your software organization. You would like it to be quicker, more flexible, understand your needs better, and help you become more profitable. We look at why you are frustrated and how to fix the problem. 1 The Crisis in Software: The Wrong Process Produces the Wrong Results 3 Many software organizations follow a development process that guarantees waste, uncontrolled risk, unpredictability, surprises, and low value. We will investigate why this process was chosen, how it guarantees failure, and look and some organizations that have recovered from it. 2 Scrum: The Right Process Produces the Right Results 17 There is a process that is appropriate for software development. When you get your developers to use it, you will immediately gain productivity, quality, value, control, predictability, and satisfaction. We look at how this happens in this chapter. 3 Try It Yourself: The Pilot 33 You have read our assertion that there is a better way for you to get software developed for you. However, a lot of people have made assertions and taken a lot of your money in the past, with little or no improvement. In this chapter we show you how to prove that our approach works for no money. 4 What Can I Do? 49 You learned how to do better and you’ve tried it yourself. You like the results and you know what to tell the software organization to do. In this chapter, we look at what you can do to help what you experience in the pilot project succeed. Section II How to Produce Software in 30 Days 55 Having better software developed for your needs is not so much hard as it is different from what you are used to. In this section, we look at a progressively beneficial set of approaches to get you from where you are now to organizational agility. 5 Getting Started with Scrum 57 Our secret sauce for improving your benefits from software is called “Scrum.” Yes, this is the rugby event that keeps the ball moving down the field. We’ll discuss Scrum, how it works, and why it works in this chapter. 6 Scrum at the Project Level 63 Most persistent improvement in software development starts at the project level. You can use Scrum to further prove its utility, or on critically important initiative that must succeed. We’ll explore what you can tell your developers to do after reading this chapter. 7 Develop a Scrum Capability 75 Success often breeds success. As more software initiatives using Scrum succeed, more people will want to get on the wagon. Rather than changing the entire organization, let’s look at how we can set up a software development universe separate from the disappointing, existing department. You can increasingly reap benefits here on an increasing number of projects and releases. 8 Scrum at the Enterprise Level 101 Scrum at a project or release level provides initiative level agility, the ability to rapidly respond to opportunities or rise to challenges. To gain the most significant benefits, Scrum’s empirical approach to software development must be fit into the organization as a whole. We’ll look at how to do this, and why some approaches are short-lived and others persist. 9 Enterprise Transformation: Profound and Persistent Change 107 You want to make your organization leaner, more efficient, and agile on your watch. Even more, you want these benefits and their underlying causes to persist and become the organizational culture. We’ll look at an enterprise change approach for achieving this in this chapter. 10 Scrumming Scrum 119 We devised Scrum for complex problem solving, like software development. We found Scrum a useful technique for managing organizational change, also a complex problem. The same benefits of transparency, waste removal, risk control, and predictability occurred. We’ll look at this use of Scrum in this chapter. Appendix 1: Terminology 127 We slowly and progressively introduced some new terminology. This appendix is your reference for those terms. Appendix 2: The Scrum Guide 133 Read the canonical guide to Scrum, its roles, artifacts, and events. This is the bible of Scrum. Appendix 3: A Playbook for Achieving Enterprise Agility 153 This appendix presents a more detailed plan for enterprise change, as discussed in Chapter 10. Index 185

Read more less

Book SynopsisMaster PowerPoint and improve your presentation skills with one book! In today's business climate, you need to know PowerPoint inside and out, and that's not all. You also need to be able to make a presentation that makes an impact.Table of ContentsPreface xxxv Part I: Building Your Presentation 1 Chapter 1: A First Look at PowerPoint 3 Chapter 2: Creating and Saving Presentation Files 41 Chapter 3: Creating Slides and Text Boxes 71 Chapter 4: Working with Layouts, Themes, and Masters 99 Chapter 5: Formatting Text 141 Chapter 6: Formatting Paragraphs and Text Boxes 179 Chapter 7: Correcting and Improving Text 207 Chapter 8: Creating and Formatting Tables 229 Part II: Using Graphics and Multimedia Content 255 Chapter 9: Drawing and Formatting Objects 257 Chapter 10: Creating SmartArt Graphics 313 Chapter 11: Working with Clip Art and Photos 335 Chapter 12: Working with Charts 377 Chapter 13: Incorporating Content from Other Programs 419 Chapter 14: Adding Sound Effects, Music, and Soundtracks 435 Chapter 15: Incorporating Motion Video 459 Chapter 16: Creating Animation Effects and Transitions 485 Part III: Interfacing with Your Audience 517 Chapter 17: Creating Support Materials 519 Chapter 18: Preparing for a Live Presentation 543 Chapter 19: Designing User-Interactive or Self-Running Presentations 577 Chapter 20: Preparing a Presentation for Mass Distribution 609 Chapter 21: Sharing and Collaborating 627 Chapter 22: Customizing PowerPoint 647 Part IV: Project Labs 673 Lab 1: Presenting Content without Bulleted Lists 675 Lab 2: Adding Sound and Movement to a Presentation 693 Lab 2A: Fading Text and Graphics In and Out 693 Lab 2B: Replacing One Picture with Another 701 Lab 2C: Zooming In on a Picture 704 Lab 2D: More Animation Practice 705 Lab 2E: Using Transitions and Soundtracks 709 Lab 3: Creating a Menu-Based Navigation System 713 Lab 4: Creating a Classroom Game 733 Appendix A: What Makes a Great Presentation? 753 Appendix B: Essential SkyDrive Skills 775 Index 787

Read more less

Book SynopsisThe go-to reference for the new Office Home & Student 2013 The Home & Student version of Microsoft Office targets the home and education markets, covering the four applications most used outside the workplace: Word, Excel, PowerPoint, and OneNote. The minibooks in this essential All-in-One guide include real-world examples and projects that cover the new features and capabilities of Office 2013. Straightforward advice and beneficial projects help you to learn the basics of creating a resume in Word, establishing a home budget in Excel, developing a dynamic school presentation with PowerPoint, and taking notes in OneNote. Targets home and school users of Office 2013, who primarily use Word, Excel, PowerPoint, and OneNote Walks you through how to use Office 2013 for everyday projects, such as creating a cover letter in Word or reusable templates in Excel Demonstrates how to jazz up a school presentation with PowerPoint ProviTable of ContentsIntroduction 1 What’s in This Book, Anyway? 1 What Makes This Book Different 2 Easy-to-look-up information 2 A task-oriented approach 3 Meaningful screen shots 3 Foolish Assumptions 3 Conventions Used in This Book 3 Icons Used in This Book 4 Book I: Common Office Tasks 5 Chapter 1: Office Nuts and Bolts 7 A Survey of Office Applications 7 Starting an Office Program 9 Starting an Office program in Windows 7 and Vista 9 Starting an Office program in Windows 8 10 Finding Your Way Around the Office Interface 12 The File tab and Backstage 13 The Quick Access toolbar 13 The Ribbon and its tabs 14 Context-sensitive tabs 14 The anatomy of a tab 15 Live previewing 16 Mini-toolbars and shortcut menus 17 Office 2013 for keyboard lovers 17 Saving Your Files 18 Saving a file 18 Saving a file for the first time 18 Declaring where you like to save files 19 Saving AutoRecovery information 20 Navigating the Save As and Open Windows 21 Opening and Closing Files 23 Opening a file 23 Closing a file 24 Reading and Recording File Properties 24 Locking a File with a Password 25 Password-protecting a file 25 Removing a password from a file 26 Chapter 2: Wrestling with the Text 27 Manipulating the Text 27 Selecting text 27 Moving and copying text 28 Taking advantage of the Clipboard task pane 29 Deleting text 30 Changing the Look of Text 30 Choosing fonts for text 31 Changing the font size of text 32 Applying font styles to text 33 Applying text effects to text 34 Underlining text 35 Changing the color of text 35 Quick Ways to Handle Case, or Capitalization 36 Entering Symbols and Foreign Characters 38 Creating Hyperlinks 39 Linking a hyperlink to a web page 39 Creating a hyperlink to another place in your file 41 Creating an e-mail hyperlink 42 Repairing and removing hyperlinks 43 Chapter 3: Speed Techniques Worth Knowing About 45 Undoing and Repeating Commands 45 Undoing a mistake 45 Repeating an action — and quicker this time 46 Zooming In, Zooming Out 47 Viewing a File Through More Than One Window 48 Correcting Typos on the Fly 48 Entering Text Quickly with the AutoCorrect Command 50 Book II: Word 2013 53 Chapter 1: Speed Techniques for Using Word 55 Introducing the Word Screen 55 Creating a New Document 57 Getting a Better Look at Your Documents 60 Viewing documents in different ways 60 Splitting the screen 63 Selecting Text in Speedy Ways 64 Moving Around Quickly in Documents 65 Keys for getting around quickly 65 Navigating from page to page or heading to heading 66 Going there fast with the Go To command 66 Bookmarks for hopping around 68 Inserting a Whole File into a Document 69 Entering Information Quickly in a Computerized Form 69 Creating a computerized form 70 Entering data in the form 72 Chapter 2: Laying Out Text and Pages 73 Paragraphs and Formatting 73 Inserting a Section Break for Formatting Purposes 74 Breaking a Line 76 Starting a New Page 76 Setting Up and Changing the Margins 77 Indenting Paragraphs and First Lines 79 Clicking an Indent button (for left-indents) 79 “Eyeballing it” with the ruler 80 Indenting in the Paragraph dialog box 81 Numbering the Pages 81 Numbering with page numbers only 82 Including a page number in a header or footer 83 Changing page number formats 83 Putting Headers and Footers on Pages 84 Creating, editing, and removing headers and footers 85 Fine-tuning a header or footer 87 Adjusting the Space between Lines 88 Adjusting the Space Between Paragraphs 89 Creating Numbered and Bulleted Lists 90 Simple numbered and bulleted lists 90 Constructing lists of your own 91 Managing a multilevel list 92 Working with Tabs 93 Hyphenating Text 94 Automatically and manually hyphenating a document 95 Unhyphenating and other hyphenation tasks 96 Chapter 3: Word Styles 97 All About Styles 97 Styles and templates 97 Types of styles 98 Applying Styles to Text and Paragraphs 99 Applying a style 99 Experimenting with style sets 100 Choosing which style names appear on the Style menus 101 Creating a New Style 103 Creating a style from a paragraph 103 Creating a style from the ground up 103 Modifying a Style 105 Creating and Managing Templates 106 Creating a new template 107 Opening a template so that you can modify it 110 Modifying, deleting, and renaming styles in templates 111 Chapter 4: Constructing the Perfect Table 113 Talking Table Jargon 113 Creating a Table 114 Entering the Text and Numbers 116 Selecting Different Parts of a Table 117 Laying Out Your Table 118 Changing the size of a table, columns, and rows 118 Adjusting column and row size 119 Inserting columns and rows 119 Deleting columns and rows 121 Moving columns and rows 122 Aligning Text in Columns and Rows 122 Merging and Splitting Cells 123 Repeating Header Rows on Subsequent Pages 124 Formatting Your Table 125 Designing a table with a table style 125 Calling attention to different rows and columns 127 Decorating your table with borders and colors 127 Using Math Formulas in Tables 130 Neat Table Tricks 131 Changing the direction of header row text 131 Wrapping text around a table 132 Using a picture as the table background 133 Drawing diagonal lines on tables 134 Drawing on a table 135 Chapter 5: Taking Advantage of the Proofing Tools 137 Correcting Your Spelling Errors 137 Correcting misspellings one at a time 138 Running a spell-check 139 Preventing text from being spell checked 140 Checking for Grammatical Errors in Word 141 Getting a Word Definition 142 Finding and Replacing Text 142 The basics: Finding stray words and phrases 143 Narrowing your search 144 Conducting a find-and-replace operation 149 Researching a Topic Inside Word 150 Finding the Right Word with the Thesaurus 152 Proofing Text Written in a Foreign Language 153 Telling Office which languages you will use 153 Marking text as foreign language text 154 Translating Foreign Language Text 155 Chapter 6: Desktop Publishing with Word 157 Experimenting with Themes 157 Sprucing Up Your Pages 159 Decorating a page with a border 159 Putting a background color on pages 160 Getting Word’s help with cover letters 160 Making Use of Charts, Diagrams, Shapes, Clip Art, and Photos 161 Working with the Drawing Canvas 162 Positioning and Wrapping Objects Relative to the Page and Text 163 Wrapping text around an object 163 Positioning an object on a page 165 Working with Text Boxes 167 Inserting a text box 167 Making text flow from text box to text box 168 Dropping In a Drop Cap 168 Watermarking for the Elegant Effect 169 Putting Newspaper-Style Columns in a Document 170 Doing the preliminary work 170 Running text into columns 171 Landscape Documents 172 Printing on Different Size Paper 173 Showing Online Video in a Document 173 Chapter 7: Getting Word’s Help with Office Chores 175 Highlighting Parts of a Document 175 Commenting on a Document 176 Entering a comment 176 Viewing and displaying comments 178 Caring for and feeding comments 178 Tracking Changes to Documents 179 Telling Word to start marking changes 180 Reading and reviewing a document with change marks 180 Marking changes when you forgot to turn on change marks 182 Accepting and rejecting changes to a document 184 Printing an Address on an Envelope 184 Printing a Single Address Label (Or a Page of the Same Label) 186 Churning Out Letters, Envelopes, and Labels for Mass Mailings 187 Preparing the source file 188 Merging the document with the source file 189 Printing form letters, envelopes, and labels 193 Chapter 8: Tools for Reports and Scholarly Papers 195 Alphabetizing a List 195 Outlines for Organizing Your Work 196 Viewing the outline in different ways 197 Rearranging document sections in Outline view 197 Collapsing and Expanding Parts of a Document 198 Generating a Table of Contents 199 Creating a TOC 199 Updating and removing a TOC 200 Customizing a TOC 200 Changing the structure of a TOC 201 Indexing a Document 203 Marking index items in the document 203 Generating the index 205 Editing an index 206 Putting Cross-References in a Document 207 Putting Footnotes and Endnotes in Documents 209 Entering a footnote or endnote 209 Choosing the numbering scheme and position of notes 210 Deleting, moving, and editing notes 211 Compiling a Bibliography 211 Inserting a citation for your bibliography 212 Editing a citation 214 Changing how citations appear in text 214 Generating the bibliography 214 Book III: Excel 2013 217 Chapter 1: Up and Running with Excel 219 Creating a New Excel Workbook 219 Getting Acquainted with Excel 221 Rows, columns, and cell addresses 222 Workbooks and worksheets 223 Entering Data in a Worksheet 223 The basics of entering data 223 Entering text labels 224 Entering numeric values 225 Entering date and time values 225 Quickly Entering Lists and Serial Data with the AutoFill Command 228 Formatting Numbers, Dates, and Time Values 231 Conditional Formats for Calling Attention to Data 232 Establishing Data-Validation Rules 234 Chapter 2: Refining Your Worksheet 237 Editing Worksheet Data 237 Moving Around in a Worksheet 238 Getting a Better Look at the Worksheet 239 Freezing and splitting columns and rows 239 Hiding columns and rows 241 Comments for Documenting Your Worksheet 242 Selecting Cells in a Worksheet 244 Deleting, Copying, and Moving Data 245 Handling the Worksheets in a Workbook 245 Keeping Others from Tampering with Worksheets 247 Hiding a worksheet 248 Protecting a worksheet 248 Chapter 3: Formulas and Functions for Crunching Numbers 251 How Formulas Work 251 Referring to cells in formulas 251 Referring to formula results in formulas 254 Operators in formulas 255 The Basics of Entering a Formula 257 Speed Techniques for Entering Formulas 257 Clicking cells to enter cell references 257 Entering a cell range 258 Naming cell ranges so that you can use them in formulas 259 Referring to cells in different worksheets 262 Copying Formulas from Cell to Cell 263 Detecting and Correcting Errors in Formulas 264 Correcting errors one at a time 264 Running the error checker 265 Tracing cell references 266 Working with Functions 267 Using arguments in functions 268 Entering a function in a formula 269 Chapter 4: Making a Worksheet Easier to Read and Understand 273 Laying Out a Worksheet 273 Aligning numbers and text in columns and rows 273 Inserting and deleting rows and columns 275 Changing the size of columns and rows 277 Decorating a Worksheet with Borders and Colors 278 Cell styles for quickly formatting a worksheet 279 Formatting cells with table styles 281 Slapping borders on worksheet cells 281 Decorating worksheets with colors 283 Getting Ready to Print a Worksheet 283 Making a worksheet fit on a page 284 Making a worksheet more presentable 287 Repeating row and column headings on each page 288 Chapter 5: Advanced Techniques for Analyzing Data 291 Seeing What the Sparklines Say 291 Managing Information in Lists 292 Sorting a list 293 Filtering a list 293 Forecasting with the Goal Seek Command 295 Performing What-If Analyses with Data Tables 297 Using a one-input table for analysis 297 Using a two-input table for analysis 299 Analyzing Data with PivotTables 300 Creating a PivotTable 301 Putting the finishing touches on a PivotTable 302 Book IV: PowerPoint 2013 303 Chapter 1: Getting Started in PowerPoint 305 Getting Acquainted with PowerPoint 306 A Brief Geography Lesson 307 A Whirlwind Tour of PowerPoint 309 Creating a New Presentation 310 Advice for Building Persuasive Presentations 312 Creating New Slides for Your Presentation 315 Inserting a new slide 315 Speed techniques for inserting slides 317 Conjuring slides from Word document headings 318 Selecting a different layout for a slide 318 Getting a Better View of Your Work 319 Changing views 319 Looking at the different views 319 Hiding and Displaying the Slides Pane and Notes Pane 321 Selecting, Moving, and Deleting Slides 321 Selecting slides 321 Moving slides 322 Deleting slides 322 Putting Together a Photo Album 322 Creating your photo album 323 Putting on the final touches 325 Editing a photo album 325 Hidden Slides for All Contingencies 325 Hiding a slide 326 Showing a hidden slide during a presentation 326 Chapter 2: Fashioning a Look for Your Presentation 327 Looking at Themes and Slide Backgrounds 327 Choosing a Theme for Your Presentation 329 Creating Slide Backgrounds on Your Own 330 Using a solid (or transparent) color for the slide background 330 Creating a gradient color blend for slide backgrounds 331 Placing a picture in the slide background 332 Using a photo of your own for a slide background 334 Using a texture for a slide background 335 Changing the Background of a Single or Handful of Slides 336 Choosing the Slide Size 337 Using Master Slides and Master Styles for a Consistent Design 337 Switching to Slide Master view 338 Understanding master slides and master styles 338 Editing a master slide 340 Changing a master slide layout 340 Chapter 3: Entering the Text 341 Entering Text 341 Choosing fonts for text 342 Changing the font size of text 342 Changing the look of text 343 Fun with Text Boxes and Text Box Shapes 345 Controlling How Text Fits in Text Frames and Text Boxes 346 Choosing how PowerPoint “AutoFits” text in text frames 346 Choosing how PowerPoint “AutoFits” text in text boxes 349 Positioning Text in Frames and Text Boxes 349 Handling Bulleted and Numbered Lists 350 Creating a standard bulleted or numbered list 350 Choosing a different bullet character, size, and color 351 Choosing a different list-numbering style, size, and color 352 Putting Footers (and Headers) on Slides 353 Some background on footers and headers 353 Putting a standard footer on all your slides 354 Creating a nonstandard footer 354 Removing a footer from a single slide 356 Chapter 4: Making Your Presentations Livelier 357 Suggestions for Enlivening Your Presentation 357 Presenting Information in a Table 358 Exploring Transitions and Animations 360 Showing transitions between slides 361 Animating parts of a slide 362 Making Audio Part of Your Presentation 364 Inserting an audio file on a slide 365 Telling PowerPoint when and how to play an audio file 366 Playing audio during a presentation 367 Playing Video on Slides 368 Inserting a video on a slide 368 Fine-tuning a video presentation 368 Experimenting with the look of the video 370 Recording a Voice Narration for Slides 371 Chapter 5: Delivering a Presentation 373 All about Notes 373 Rehearsing and Timing Your Presentation 374 Showing Your Presentation 375 Starting and ending a presentation 376 Going from slide to slide 377 Tricks for Making Presentations a Little Livelier 379 Wielding a pen or highlighter in a presentation 379 Blanking the screen 381 Zooming In 381 Delivering a Presentation When You Can’t Be There in Person 382 Providing handouts for your audience 382 Creating a self-running, kiosk-style presentation 383 Creating a user-run presentation 385 Presenting a Presentation Online 387 Packaging your presentation on a CD 389 Creating a presentation video 391 Book V: OneNote 2013 395 Chapter 1: Up and Running with OneNote 397 Introducing OneNote 397 Finding Your Way Around the OneNote Screen 398 Notebook pane 399 Section (and section group) tabs 399 Page window 399 Page pane 399 Units for Organizing Notes 399 Creating a Notebook 400 Creating Sections and Section Groups 402 Creating a new section 402 Creating a section group 403 Creating Pages and Subpages 404 Creating a new page 404 Creating a new subpage 404 Renaming and Deleting Groups and Pages 405 Getting from Place to Place in OneNote 405 Changing Your View of OneNote 406 Chapter 2: Taking Notes 409 Entering a Typewritten Note 409 Notes: The Basics 409 Moving and resizing note containers 410 Formatting the Text in Notes 410 Selecting notes 411 Deleting notes 412 Getting more space for notes on a page 412 Drawing on the Page 412 Drawing with a pen or highlighter 413 Drawing a shape 413 Changing the size and appearance of drawings and shapes 415 Converting a Handwritten Note to Text 416 Writing a Math Expression in a Note 417 Taking a Screen-Clipping Note 418 Recording and Playing Audio Notes 419 Recording an audio note 420 Playing an audio note 420 Attaching, Copying, and Linking Files to Notes 421 Attaching an Office file to a note 421 Copying an Office file into OneNote 423 Linking a Word or PowerPoint file to OneNote 423 Copying a note into another Office program 424 Chapter 3: Finding and Organizing Your Notes 425 Finding a Stray Note 425 Searching by word or phrase 425 Searching by author 426 Tagging Notes for Follow Up 427 Tagging a note 428 Arranging tagged notes in the task pane 428 Creating and modifying tags 429 Color-Coding Notebooks, Sections, and Pages 430 Merging and Moving Sections, Pages, and Notes 431 Book VI: Working with Charts and Graphics 433 Chapter 1: Creating a Chart 435 The Basics: Creating a Chart 435 Choosing the Right Chart 437 Area charts 438 Bar charts 439 Column charts 440 Combo charts 442 Line charts 442 Pie charts 443 Radar charts 444 Stock charts 445 Surface charts 446 XY (scatter) charts 447 Providing the Raw Data for Your Chart 448 Positioning Your Chart in a Workbook, Page, or Slide 450 Changing a Chart’s Appearance 450 Changing the chart type 452 Changing the size and shape of a chart 452 Choosing a new look for your chart 452 Changing the layout of a chart 453 Handling the gridlines 454 Changing a chart element’s color, font, or other particular 455 Saving a Chart as a Template So That You Can Use It Again 456 Saving a chart as a template 456 Creating a chart from a template 457 Chart Tricks for the Daring and Heroic 457 Decorating a chart with a picture 457 Annotating a chart 458 Displaying the raw data alongside the chart 459 Placing a trendline on a chart 460 Troubleshooting a Chart 461 Chapter 2: Making a SmartArt Diagram 463 The Basics: Creating SmartArt Diagrams 463 Choosing a diagram 464 Making the diagram your own 465 Creating the Initial Diagram 465 Creating a diagram 466 Swapping one diagram for another 466 Changing the Size and Position of a Diagram 467 Laying Out the Diagram Shapes 467 Selecting a diagram shape 468 Removing a shape from a diagram 468 Moving diagram shapes to different positions 468 Adding shapes to diagrams apart from hierarchy diagrams 469 Adding shapes to hierarchy diagrams 470 Adding shapes to Organization charts 471 Promoting and demoting shapes in hierarchy diagrams 473 Handling the Text on Diagram Shapes 474 Entering text on a diagram shape 474 Entering bulleted lists on diagram shapes 474 Changing a Diagram’s Direction 475 Choosing a Look for Your Diagram 476 Changing the Appearance of Diagram Shapes 477 Changing the size of a diagram shape 477 Exchanging one shape for another 478 Changing a shape’s color, fill, or outline 478 Changing fonts and font sizes on shapes 480 Creating a Diagram from Scratch 480 Chapter 3: Handling Graphics, Photos, and Clip Art 481 All about Picture File Formats 481 Bitmap and vector graphics 481 Resolution 483 Compression 484 Color depth 484 Choosing file formats for graphics 485 Inserting a Picture in an Office File 485 Inserting a picture of your own 486 Obtaining a picture online 487 Touching Up a Picture 489 Softening and sharpening pictures 489 Correcting a picture’s brightness and contrast 490 Recoloring a picture 491 Choosing an artistic effect 492 Selecting a picture style 493 Cropping off part of a picture 494 Removing the background 495 Compressing Pictures to Save Disk Space 496 Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 499 The Basics: Drawing Lines, Arrows, and Shapes 500 Handling Lines, Arrows, and Connectors 501 Changing the length and position of a line or arrow 502 Changing the appearance of a line, arrow, or connector 502 Attaching and handling arrowheads on lines and connectors 504 Connecting shapes by using connectors 504 Handling Rectangles, Ovals, Stars, and Other Shapes 506 Drawing a shape 506 Changing a shape’s symmetry 508 Using a shape as a text box 508 WordArt for Embellishing Letters and Words 509 Creating WordArt 510 Editing WordArt 510 Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 511 Selecting objects so that you can manipulate them 512 Hiding and displaying the rulers and grid 513 Changing an Object’s Size and Shape 514 Changing an Object’s Color, Outline Color, and Transparency 515 Filling an object with color, a picture, or a texture 516 Making a color transparent 518 Putting the outline around an object 518 Moving and Positioning Objects 520 Tricks for aligning and distributing objects 520 When objects overlap: Choosing which appears above the other 523 Rotating and flipping objects 525 Grouping objects to make working with them easier 526 Book VII: Office 2013 — One Step Beyond 529 Chapter 1: Customizing an Office Program 531 Customizing the Ribbon 531 Displaying and selecting tab, group, and command names 533 Moving tabs and groups on the Ribbon 533 Adding, removing, and renaming tabs, groups, and commands 534 Creating new tabs and groups 535 Resetting your Ribbon customizations 536 Customizing the Quick Access Toolbar 537 Adding buttons to the Quick Access toolbar 537 Changing the order of buttons on the Quick Access toolbar 539 Removing buttons from the Quick Access toolbar 539 Placing the Quick Access toolbar above or below the Ribbon 539 Customizing the Status Bar 540 Changing the Screen Background 541 Customizing Keyboard Shortcuts in Word 542 Chapter 2: Ways of Distributing Your Work 545 Printing — the Old Standby 545 Distributing a File in PDF Format 546 About PDF files 546 Saving an Office file as a PDF 547 Saving an Office File as a Web Page 548 Choosing how to save the component parts 548 Turning a file into a web page 549 Opening a web page in your browser 550 Blogging from inside Word 550 Describing a blog account to Word 550 Posting an entry to your blog 552 Taking advantage of the Blog Post tab 552 Chapter 3: Automating Tasks with Macros 553 What Is a Macro? 553 Displaying the Developer Tab 554 Managing the Macro Security Problem 554 Recording a Macro 556 Enabling your files for macros 556 Ground rules for recording macros 557 Recording the macro 558 Running a Macro 560 Editing a Macro 561 Opening a macro in the Visual Basic Editor 561 Reading a macro in the Code window 562 Editing the text that a macro enters 562 Deleting parts of a macro 563 Running a Macro from a Button on the Quick Access Toolbar 563 Chapter 4: Linking and Embedding in Compound Files 565 What Is OLE, Anyway? 565 Linking and embedding 566 Uses for object linking 566 Uses for object embedding 568 Pitfalls of object linking and embedding 568 Embedding Data from Other Programs 568 Embedding foreign data 569 Editing an embedded object 571 Linking to a Source File 571 Establishing the link 572 Updating a link 573 Editing data in the source file 574 Converting a linked object to an embedded object 574 Book VIII: File Sharing and Collaborating 577 Chapter 1: Preparing to Use the Office Web Apps 579 Introducing the Office Web Apps 579 Storing and Sharing Files on the Internet 580 Office Web Apps: The Big Picture 581 Creating a Microsoft Account 582 Signing In and Out of Your Microsoft Account 582 Navigating in a Microsoft Account 583 Managing Your Folders 583 Creating a folder 584 Viewing and locating folders in the SkyDrive window 584 Going from folder to folder in SkyDrive 586 Deleting, moving, and renaming folders 587 Chapter 2: Using the Office Web Apps 589 Creating an Office File in SkyDrive 589 Uploading Office Files to a Folder on SkyDrive 590 Saving a File from Office 2013 to SkyDrive 591 Opening Office Files Stored on SkyDrive 593 Opening a file in an Office Web App 593 Opening a file in an Office 2013 application 593 Downloading Files from SkyDrive to Your Computer 595 Managing Your Files on SkyDrive 596 Chapter 3: Sharing and Collaborating 599 Sharing Files: The Big Picture 599 File access privileges 599 Links for sharing files 600 Sharing Your Files and Folders with Others 601 Seeing Files and Folders Others Have Shared with You 603 Investigating and Changing How Files and Folders Are Shared 603 Co-editing Shared Files on SkyDrive 605 Soliciting Information with a Survey Form 605 Index 609

Read more less

Book SynopsisThe ultimate reference and tutorial for AutoCAD software This Autodesk Official Press book helps you become an AutoCAD and AutoCAD LT expert and has been fully updated to cover all of AutoCAD''s new capabilities. Featuring the popular, empowering presentation style of veteran award-winning author George Omura, this indispensable resource teaches AutoCAD essentials using concise explanations, focused examples, step-by-step instructions, and hands-on projects. Introduces you to the basics of the interface and drafting tools Details how to effectively use hatches, fields, and tables Covers attributes, dynamic blocks, curves, and geometric constraints Explores 3D modeling and imaging Discusses customization and integration Helps you prepare for the AutoCAD certification exams Features a website that includes all the project files necessary for the tutorials This detailed reference and tutorial

Read more less

Book SynopsisA comprehensive exploration of the mathematics behind the modeling and rendering of computer graphics scenes Mathematical Structures for Computer Graphics presents an accessible and intuitive approach to the mathematical ideas and techniques necessary for two- and three-dimensional computer graphics.Trade Review“The book is suitable for undergraduate students of computer science, mathematics, and engineering, as well as an ideal reference for researchers and professionals in computer graphics.” (Zentralblatt MATH, 1 June 2015) Table of ContentsPreface xiii 1 Basics 1 1.1 Graphics Pipeline 2 1.2 Mathematical Descriptions 4 1.3 Position 5 1.4 Distance 8 1.5 Complements and Details 11 1.5.1 Pythagorean Theorem Continued 11 1.5.2 Law of Cosines Continued 12 1.5.3 Law of Sines 13 1.5.4 Numerical Calculations 13 1.6 Exercises 14 1.6.1 Programming Exercises 16 2 Vector Algebra 17 2.1 Basic Vector Characteristics 18 2.1.1 Points Versus Vectors 20 2.1.2 Addition 20 2.1.3 Scalar Multiplication 21 2.1.4 Subtraction 22 2.1.5 Vector Calculations 22 2.1.6 Properties 24 2.1.7 Higher Dimensions 25 2.2 Two Important Products 25 2.2.1 Dot Product 25 2.2.2 Cross Product 29 2.3 Complements and Details 34 2.3.1 Vector History 34 2.3.2 More about Points Versus Vectors 35 2.3.3 Vector Spaces and Affine Spaces 36 2.4 Exercises 38 2.4.1 Programming Exercises 39 3 Vector Geometry 40 3.1 Lines and Planes 40 3.1.1 Vector Description of Lines 40 3.1.2 Vector Description of Planes 44 3.2 Distances 46 3.2.1 Point to a Line 46 3.2.2 Point to a Plane 48 3.2.3 Parallel Planes and Line to a Plane 48 3.2.4 Line to a Line 50 3.3 Angles 52 3.4 Intersections 54 3.4.1 Intersecting Lines 54 3.4.2 Lines Intersecting Planes 56 3.4.3 Intersecting Planes 57 3.5 Additional Key Applications 61 3.5.1 Intersection of Line Segments 61 3.5.2 Intersection of Line and Sphere 65 3.5.3 Areas and Volumes 66 3.5.4 Triangle Geometry 68 3.5.5 Tetrahedron 69 3.6 Homogeneous Coordinates 71 3.6.1 Two Dimensions 72 3.6.2 Three Dimensions 73 3.7 Complements and Details 75 3.7.1 Intersection of Three Planes Continued 75 3.7.2 Homogeneous Coordinates Continued 77 3.8 Exercises 79 3.8.1 Programming Exercises 82 4 Transformations 83 4.1 Types of Transformations 84 4.2 Linear Transformations 85 4.2.1 Rotation in Two Dimensions 88 4.2.2 Reflection in Two dimensions 90 4.2.3 Scaling in Two Dimensions 92 4.2.4 Matrix Properties 93 4.3 Three Dimensions 95 4.3.1 Rotations in Three Dimensions 95 4.3.2 Reflections in Three Dimensions 101 4.3.3 Scaling and Shear in Three Dimensions 102 4.4 Affine Transformations 103 4.4.1 Transforming Homogeneous Coordinates 105 4.4.2 Perspective Transformations 107 4.4.3 Transforming Normals 110 4.4.4 Summary 111 4.5 Complements and Details 112 4.5.1 Vector Approach to Reflection in an Arbitrary Plane 113 4.5.2 Vector Approach to Arbitrary Rotations 115 4.6 Exercises 121 4.6.1 Programming Exercises 123 5 Orientation 124 5.1 Cartesian Coordinate Systems 125 5.2 Cameras 132 5.2.1 Moving the Camera or Objects 134 5.2.2 Euler Angles 137 5.2.3 Quaternions 141 5.2.4 Quaternion Algebra 143 5.2.5 Rotations 145 5.2.6 Interpolation: Slerp 148 5.2.7 From Euler Angles and Quaternions to Rotation Matrices 151 5.3 Other Coordinate Systems 152 5.3.1 Non-orthogonal Axes 152 5.3.2 Polar, Cylindrical, and Spherical Coordinates 154 5.3.3 Barycentric Coordinates 157 5.4 Complements and Details 158 5.4.1 Historical Note: Descartes 158 5.4.2 Historical Note: Hamilton 158 5.4.3 Proof of Quaternion Rotation 159 5.5 Exercises 161 5.5.1 Programming Exercises 163 6 Polygons and Polyhedra 164 6.1 Triangles 164 6.1.1 Barycentric Coordinates 165 6.1.2 Areas and Barycentric Coordinates 166 6.1.3 Interpolation 171 6.1.4 Key Points in a Triangle 172 6.2 Polygons 178 6.2.1 Convexity 179 6.2.2 Angles and Area 180 6.2.3 Inside and Outside 184 6.2.4 Triangulation 187 6.2.5 Delaunay Triangulation 189 6.3 Polyhedra 192 6.3.1 Regular Polyhedra 194 6.3.2 Volume of Polyhedra 196 6.3.3 Euler’s Formula 200 6.3.4 Rotational Symmetries 202 6.4 Complements and Details 205 6.4.1 Generalized Barycentric Coordinates 205 6.4.2 Data Structures 206 6.5 Exercises 208 6.5.1 Programming Exercises 211 7 Curves and Surfaces 212 7.1 Curve Descriptions 213 7.1.1 Lagrange Interpolation 218 7.1.2 Matrix Form for Curves 222 7.2 Bézier Curves 223 7.2.1 Properties for Two-Dimensional Bézier Curves 226 7.2.2 Joining Bézier Curve Segments 228 7.2.3 Three-Dimensional Bézier Curves 229 7.2.4 Rational Bézier Curves 230 7.3 B-Splines 232 7.3.1 Linear Uniform B-Splines 233 7.3.2 Quadratic Uniform B-Splines 235 7.3.3 Cubic Uniform B-Splines 240 7.3.4 B-Spline Properties 242 7.4 Nurbs 246 7.5 Surfaces 250 7.6 Complements and Details 260 7.6.1 Adding Control Points to Bézier Curves 260 7.6.2 Quadratic B-Spline Blending Functions 262 7.7 Exercises 264 7.7.1 Programming Exercises 266 8 Visibility 267 8.1 Viewing 267 8.2 Perspective Transformation 269 8.2.1 Clipping 273 8.2.2 Interpolating the z Coordinate 275 8.3 Hidden Surfaces 278 8.3.1 Back Face Culling 281 8.3.2 Painter’s Algorithm 283 8.3.3 Z-Buffer 286 8.4 Ray Tracing 287 8.4.1 Bounding Volumes 289 8.4.2 Bounding Boxes 289 8.4.3 Bounding Spheres 291 8.5 Complements and Details 293 8.5.1 Frustum Planes 293 8.5.2 Axes for Bounding Volumes 294 8.6 Exercises 297 8.6.1 Programming Exercises 298 9 Lighting 299 9.1 Color Coordinates 299 9.2 Elementary Lighting Models 303 9.2.1 Gouraud and Phong Shading 307 9.2.2 Shadows 311 9.2.3 BRDFs in Lighting Models 315 9.3 Global Illumination 319 9.3.1 Ray Tracing 319 9.3.2 Radiosity 323 9.4 Textures 325 9.4.1 Mapping 325 9.4.2 Resolution 332 9.4.3 Procedural Textures 333 9.5 Complements and Details 335 9.5.1 Conversion between RGB and HSV 335 9.5.2 Shadows on Arbitrary Planes 336 9.5.3 Derivation of the Radiosity Equation 337 9.6 Exercises 339 9.6.1 Programming Exercises 340 10 Other Paradigms 341 10.1 Pixels 342 10.1.1 Bresenham Line Algorithm 342 10.1.2 Anti-Aliasing 345 10.1.3 Compositing 347 10.2 Noise 350 10.2.1 Random Number Generation 350 10.2.2 Distributions 351 10.2.3 Sequences of Random Numbers 353 10.2.4 Uniform and Normal Distributions 354 10.2.5 Terrain Generation 356 10.2.6 Noise Generation 357 10.3 L-Systems 361 10.3.1 Grammars 362 10.3.2 Turtle Interpretation 363 10.3.3 Analysis of Grammars 365 10.3.4 Extending L-Systems 367 10.4 Exercises 368 10.4.1 Programming Exercises 369 Appendix A Geometry and Trigonometry 370 A.1 Triangles 370 A.2 Angles 372 A.3 Trigonometric Functions 373 Appendix B Linear Algebra 376 B.1 Systems of Linear Equations 376 B.1.1 Solving the System 377 B.2 Matrix Properties 379 B.3 Vector Spaces 381 References 383 Index 387

Read more less

Book SynopsisDemystifying the power of the Oracle 12c database The Oracle database is the industry-leading relational database management system (RDMS) used from small companies to the world's largest enterprises alike for their most critical business and analytical processing. Oracle 12c includes industry leading enhancements to enable cloud computing and empowers users to manage both Big Data and traditional data structures faster and cheaper than ever before. Oracle 12c For Dummies is the perfect guide for a novice database administrator or an Oracle DBA who is new to Oracle 12c. The book covers what you need to know about Oracle 12c architecture, software tools, and how to successfully manage Oracle databases in the real world. Highlights the important features of Oracle 12c Explains how to create, populate, protect, tune, and troubleshoot a new Oracle database Covers advanced Oracle 12c technologies including Oracle Multitenantthe pluggablTable of ContentsIntroduction 1 Part I: Getting Started with Oracle 12c 5 Chapter 1: Discovering Databases and Oracle 12c 7 Chapter 2: Understanding Oracle Database Architecture 17 Chapter 3: Preparing to Implement Oracle 49 Part II: Implementing an Oracle Database 67 Chapter 4: Creating Your Database 69 Chapter 5: Connecting to the Database 93 Chapter 6: Understanding the Language of Databases: SQL 115 Chapter 7: Loading Data into Your Database 135 Part III: Caring for and Feeding an Oracle Database 153 Chapter 8: Keeping the Database Running 155 Chapter 9: Tuning an Oracle Database for Performance 185 Chapter 10: Securing and Auditing Your Database 215 Chapter 11: Facilitating Backup and Recovery 237 Chapter 12: Troubleshooting an Oracle Database 273 Chapter 13: Managing Your Database with Enterprise Manager 301 Part IV: Advanced Oracle Technologies 313 Chapter 14: Advanced Features 315 Chapter 15: Using High-Availability Options 351 Part V: The Part of Tens 373 Chapter 16: Ten Oracle Installation Do's 375 Chapter 17: Ten Database Design Do's 383 Appendix A: Installing Oracle 12c on Linux 391 Index 401

Read more less

Book SynopsisThe first and only book to offer detailed explanations of SAP ERP sales and distribution As the only book to provide in-depth configuration of the Sales and Distribution (SD) module in the latest version of SAP ERP, this valuable resource presents you with step-by-step instruction, conceptual explanations, and plenty of examples.Table of ContentsIntroduction xv Chapter 1 Introduction to Sales and Distribution 1 Chapter 2 Enterprise Structure 27 Chapter 3 Master Data in SD 69 Chapter 4 Partner, Text, and Output Determination 103 Chapter 5 Pricing and Tax Determination 155 Chapter 6 Availability Check, Transfer of Requirements, and Backorders 207 Chapter 7 Sales 247 Chapter 8 Shipping and Transportation 323 Chapter 9 Billing 371 Chapter 10 Account Assignment and Revenue Recognition 429 Chapter 11 Credit Management 453 Chapter 12 Material Determination, Listing, Exclusion, and Proposal 483 Chapter 13 Serial Numbers and Batch Management 519 Chapter 14 Advanced Techniques 551 Appendix Transaction Codes and Database Tables 597 Index 625

Read more less

Book SynopsisThe perfect reference for all AutoCAD users AutoCAD 2015 and AutoCAD LT 2015 Bible is the book you want to have close at hand to answer those day-to-day questions about this industry-leading software.Table of ContentsAcknowledgments ix Foreword xxxi Introduction xxxiii Part I: Introducing AutoCAD and AutoCAD LT Basics 1 Quick Start: Drawing a Window 3 Chapter 1: Starting to Draw 15 Chapter 2: Opening a Drawing 29 Chapter 3: Using Commands 35 Chapter 4: Specifying Coordinates 53 Chapter 5: Setting Up a Drawing 91 Part II: Drawing in Two Dimensions 107 Chapter 6: Drawing Simple Lines 109 Chapter 7: Drawing Curves and Points 119 Chapter 8: Viewing Your Drawing 135 Chapter 9: Editing Your Drawing with Basic Tools 167 Chapter 10: Editing Your Drawing with Advanced Tools 193 Chapter 11: Organizing Drawings with Layers and Object Properties 259 Chapter 12: Obtaining Information from Your Drawing 295 Chapter 13: Creating Text 325 Chapter 14: Drawing Dimensions 383 Chapter 15: Creating Dimension Styles 437 Chapter 16: Drawing Complex Objects 471 Chapter 17: Plotting and Printing Your Drawing 517 Part III: Working with Data 555 Chapter 18: Working with Blocks 557 Chapter 19: Adding Attributes to Blocks 607 Chapter 20: Referencing Other Drawings 629 Part IV: Drawing in Three Dimensions 657 Chapter 21: Specifying 3D Coordinates 659 Chapter 22: Viewing 3D Drawings 691 Chapter 23: Creating 3D Surfaces 747 Chapter 24: Creating Solids and Editing in 3D 795 Part V: Organizing and Managing Drawings 867 Chapter 25: Keeping Control of Your Drawings 869 Chapter 26: Working with Other Applications 925 Chapter 27: Collaborating and Creating Electronic Output 951 Part VI: Customizing AutoCAD and AutoCAD LT 983 Chapter 28: Customizing Commands, Toolbars, and Tool Palettes 985 Chapter 29: Creating Macros and Slide Shows 1013 Chapter 30: Creating Your Own Linetypes and Hatch Patterns 1027 Chapter 31: Creating Shapes and Fonts 1039 Chapter 32: Customizing the Ribbon and Menus 1051 Part VII: Programming AutoCAD 1083 Chapter 33: Understanding AutoLISP and Visual LISP Basics 1085 Chapter 34: Exploring AutoLISP Further 1101 Chapter 35: Exploring Advanced AutoLISP Topics 1129 Part VIII: Appendixes 1149 Appendix A: Installing and Configuring AutoCAD and AutoCAD LT 1151 Appendix B: AutoCAD and AutoCAD LT Resources 1191 Appendix C: What’s on the Companion Website 1197 Index 1201 Bonus Chapters on the Companion Website Chapter 1: Working with External Databases Chapter 2: Rendering in 3D Chapter 3: Programming with Visual Basic for Applications Chapter 4: Programming with NET

Read more less

Book SynopsisThe complete guide to the principles and practice of risk quantification for business applications. The assessment and quantification of risk provide an indispensable part of robust decision-making; to be effective, many professionals need a firm grasp of both the fundamental concepts and of the tools of the trade. Business Risk and Simulation Modelling in Practice is a comprehensive, indepth, and practical guide that aims to help business risk managers, modelling analysts and general management to understand, conduct and use quantitative risk assessment and uncertainty modelling in their own situations. Key content areas include: Detailed descriptions of risk assessment processes, their objectives and uses, possible approaches to risk quantification, and their associated decision-benefits and organisational challenges. Principles and techniques in the design of risk models, including the similarities and differences with traditionalTable of ContentsPreface xvii About the Author xxiii About the Website xxv Part I An Introduction to Risk Assessment – Its Uses, Processes, Approaches, Benefits and Challenges Chapter 1 The Context and Uses of Risk Assessment 3 1.1 Risk Assessment Examples 3 1.1.1 Everyday Examples of Risk Management 4 1.1.2 Prominent Risk Management Failures 5 1.2 General Challenges in Decision-Making Processes 7 1.2.1 Balancing Intuition with Rationality 7 1.2.2 The Presence of Biases 9 1.3 Key Drivers of the Need for Formalised Risk Assessment in Business Contexts 14 1.3.1 Complexity 14 1.3.2 Scale 15 1.3.3 Authority and Responsibility to Identify and Execute Risk-Response Measures 16 1.3.4 Corporate Governance Guidelines 16 1.3.5 General Organisational Effectiveness and the Creation of Competitive Advantage 18 1.3.6 Quantification Requirements 18 1.3.7 Reflecting Risk Tolerances in Decisions and in Business Design 19 1.4 The Objectives and Uses of General Risk Assessment 19 1.4.1 Adapt and Improve the Design and Structure of Plans and Projects 20 1.4.2 Achieve Optimal Risk Mitigation within Revised Plans 20 1.4.3 Evaluate Projects, Set Targets and Reflect Risk Tolerances in Decision-Making 21 1.4.4 Manage Projects Effectively 21 1.4.5 Construct, Select and Optimise Business and Project Portfolios 22 1.4.6 Support the Creation of Strategic Options and Corporate Planning 25 Chapter 2 Key Stages of the General Risk Assessment Process 29 2.1 Overview of the Process Stages 29 2.2 Process Iterations 30 2.3 Risk Identification 32 2.3.1 The Importance of a Robust Risk Identification Step 32 2.3.2 Bringing Structure into the Process 32 2.3.3 Distinguishing Variability from Decision Risks 34 2.3.4 Distinguishing Business Issues from Risks 34 2.3.5 Risk Identification in Quantitative Approaches: Additional Considerations 35 2.4 Risk Mapping 35 2.4.1 Key Objectives 35 2.4.2 Challenges 35 2.5 Risk Prioritisation and Its Potential Criteria 36 2.5.1 Inclusion/Exclusion 36 2.5.2 Communications Focus 37 2.5.3 Commonality and Comparison 38 2.5.4 Modelling Reasons 39 2.5.5 General Size of Risks, Their Impact and Likelihood 39 2.5.6 Influence: Mitigation and Response Measures, and Management Actions 40 2.5.7 Optimising Resource Deployment and Implementation Constraints 41 2.6 Risk Response: Mitigation and Exploitation 42 2.6.1 Reduction 42 2.6.2 Exploitation 42 2.6.3 Transfer 42 2.6.4 Research and Information Gathering 43 2.6.5 Diversification 43 2.7 Project Management and Monitoring 44 Chapter 3 Approaches to Risk Assessment and Quantification 45 3.1 Informal or Intuitive Approaches 46 3.2 Risk Registers without Aggregation 46 3.2.1 Qualitative Approaches 46 3.2.2 Quantitative Approaches 48 3.3 Risk Register with Aggregation (Quantitative) 50 3.3.1 The Benefits of Aggregation 50 3.3.2 Aggregation of Static Values 51 3.3.3 Aggregation of Risk-Driven Occurrences and Their Impacts 52 3.3.4 Requirements and Differences to Non-Aggregation Approaches 54 3.4 Full Risk Modelling 56 3.4.1 Quantitative Aggregate Risk Registers as a First Step to Full Models 56 Chapter 4 Full Integrated Risk Modelling: Decision-Support Benefits 59 4.1 Key Characteristics of Full Models 59 4.2 Overview of the Benefits of Full Risk Modelling 61 4.3 Creating More Accurate and Realistic Models 62 4.3.1 Reality is Uncertain: Models Should Reflect This 62 4.3.2 Structured Process to Include All Relevant Factors 63 4.3.3 Unambiguous Approach to Capturing Event Risks 63 4.3.4 Inclusion of Risk Mitigation and Response Factors 66 4.3.5 Simultaneous Occurrence of Uncertainties and Risks 66 4.3.6 Assessing Outcomes in Non-Linear Situations 67 4.3.7 Reflecting Operational Flexibility and Real Options 67 4.3.8 Assessing Outcomes with Other Complex Dependencies 71 4.3.9 Capturing Correlations, Partial Dependencies and Common Causalities 73 4.4 Using the Range of Possible Outcomes to Enhance Decision-Making 74 4.4.1 Avoiding “The Trap of the Most Likely” or Structural Biases 76 4.4.2 Finding the Likelihood of Achieving a Base Case 78 4.4.3 Economic Evaluation and Reflecting Risk Tolerances 82 4.4.4 Setting Contingencies, Targets and Objectives 83 4.5 Supporting Transparent Assumptions and Reducing Biases 84 4.5.1 Using Base Cases that are Separate to Risk Distributions 85 4.5.2 General Reduction in Biases 85 4.5.3 Reinforcing Shared Accountability 85 4.6 Facilitating Group Work and Communication 86 4.6.1 A Framework for Rigorous and Precise Work 86 4.6.2 Reconcile Some Conflicting Views 86 Chapter 5 Organisational Challenges Relating to Risk Modelling 87 5.1 “We Are Doing It Already” 87 5.1.1 “Our ERM Department Deals with Those Issues” 88 5.1.2 “Everybody Should Just Do Their Job Anyway!” 88 5.1.3 “We Have Risk Registers for All Major Projects” 89 5.1.4 “We Run Sensitivities and Scenarios: Why Do More?” 89 5.2 “We Already Tried It, and It Showed Unrealistic Results” 89 5.2.1 “All Cases Were Profitable” 90 5.2.2 “The Range of Outcomes Was Too Narrow” 90 5.3 “The Models Will Not Be Useful!” 91 5.3.1 “We Should Avoid Complicated Black Boxes!” 91 5.3.2 “All Models Are Wrong, Especially Risk Models!” 91 5.3.3 “Can You Prove that It Even Works?” 92 5.3.4 “Why Bother to Plan Things that Might Not Even Happen?” 93 5.4 Working Effectively with Enhanced Processes and Procedures 93 5.4.1 Selecting the Right Projects, Approach and Decision Stage 93 5.4.2 Managing Participant Expectations 95 5.4.3 Standardisation of Processes and Models 95 5.5 Management Processes, Culture and Change Management 96 5.5.1 Integration with Decision Processes 96 5.5.2 Ensuring Alignment of Risk Assessment and Modelling Processes 97 5.5.3 Implement from the Bottom Up or the Top Down? 98 5.5.4 Encouraging Issues to Be Escalated: Don’t Shoot the Messenger! 99 5.5.5 Sharing Accountability for Poor Decisions 99 5.5.6 Ensuring Alignment with Incentives and Incentive Systems 100 5.5.7 Allocation and Ownership of Contingency Budgets 101 5.5.8 Developing Risk Cultures and Other Change Management Challenges 102 Part II The Design of Risk Models – Principles, Processes and Methodology Chapter 6 Principles of Simulation Methods 107 6.1 Core Aspects of Simulation: A Descriptive Example 107 6.1.1 The Combinatorial Effects of Multiple Inputs and Distribution of Outputs 107 6.1.2 Using Simulation to Sample Many Diverse Scenarios 110 6.2 Simulation as a Risk Modelling Tool 112 6.2.1 Distributions of Input Values and Their Role 113 6.2.2 The Effect of Dependencies between Inputs 114 6.2.3 Key Questions Addressable using Risk-Based Simulation 114 6.2.4 Random Numbers and the Required Number of Recalculations or Iterations 115 6.3 Sensitivity and Scenario Analysis: Relationship to Simulation 116 6.3.1 Sensitivity Analysis 116 6.3.2 Scenario Analysis 119 6.3.3 Simulation using DataTables 121 6.3.4 GoalSeek 121 6.4 Optimisation Analysis and Modelling: Relationship to Simulation 122 6.4.1 Uncertainty versus Choice 122 6.4.2 Optimisation in the Presence of Risk and Uncertainty 129 6.4.3 Modelling Aspects of Optimisation Situations 131 6.5 Analytic and Other Numerical Methods 133 6.5.1 Analytic Methods and Closed-Form Solutions 133 6.5.2 Combining Simulation Methods with Exact Solutions 135 6.6 The Applicability of Simulation Methods 135 Chapter 7 Core Principles of Risk Model Design 137 7.1 Model Planning and Communication 138 7.1.1 Decision-Support Role 138 7.1.2 Planning the Approach and Communicating the Output 138 7.1.3 Using Switches to Control the Cases and Scenarios 139 7.1.4 Showing the Effect of Decisions versus Those of Uncertainties 140 7.1.5 Keeping It Simple, but not Simplistic: New Insights versus Modelling Errors 144 7.2 Sensitivity-Driven Thinking as a Model Design Tool 146 7.2.1 Enhancing Sensitivity Processes for Risk Modelling 150 7.2.2 Creating Dynamic Formulae 151 7.2.3 Example: Time Shifting for Partial Periods 153 7.3 Risk Mapping and Process Alignment 154 7.3.1 The Nature of Risks and Their Impacts 155 7.3.2 Creating Alignment between Modelling and the General Risk Assessment Process 156 7.3.3 Results Interpretation within the Context of Process Stages 157 7.4 General Dependency Relationships 158 7.4.1 Example: Commonality of Drivers of Variability 159 7.4.2 Example: Scenario-Driven Variability 160 7.4.3 Example: Category-Driven Variability 162 7.4.4 Example: Fading Impacts 168 7.4.5 Example: Partial Impact Aggregation by Category in a Risk Register 170 7.4.6 Example: More Complex Impacts within a Category 171 7.5 Working with Existing Models 173 7.5.1 Ensuring an Appropriate Risk Identification and Mapping 173 7.5.2 Existing Models using Manual Processes or Embedded Procedures 174 7.5.3 Controlling a Model Switch with a Macro at the Start and End of a Simulation 175 7.5.4 Automatically Removing Data Filters at the Start of a Simulation 176 7.5.5 Models with DataTables 178 Chapter 8 Measuring Risk using Statistics of Distributions 181 8.1 Defining Risk More Precisely 181 8.1.1 General Definition 181 8.1.2 Context-Specific Risk Measurement 181 8.1.3 Distinguishing Risk, Variability and Uncertainty 182 8.1.4 The Use of Statistical Measures 183 8.2 Random Processes and Their Visual Representation 184 8.2.1 Density and Cumulative Forms 184 8.2.2 Discrete, Continuous and Compound Processes 186 8.3 Percentiles 187 8.3.1 Ascending and Descending Percentiles 188 8.3.2 Inversion and Random Sampling 189 8.4 Measures of the Central Point 190 8.4.1 Mode 190 8.4.2 Mean or Average 191 8.4.3 Median 193 8.4.4 Comparisons of Mode, Mean and Median 193 8.5 Measures of Range 194 8.5.1 Worst and Best Cases, and Difference between Percentiles 194 8.5.2 Standard Deviation 195 8.6 Skewness and Non-Symmetry 199 8.6.1 The Effect and Importance of Non-Symmetry 201 8.6.2 Sources of Non-Symmetry 202 8.7 Other Measures of Risk 203 8.7.1 Kurtosis 204 8.7.2 Semi-Deviation 205 8.7.3 Tail Losses, Expected Tail Losses and Value-at-Risk 206 8.8 Measuring Dependencies 207 8.8.1 Joint Occurrence 207 8.8.2 Correlation Coefficients 209 8.8.3 Correlation Matrices 210 8.8.4 Scatter Plots (X–Y Charts) 212 8.8.5 Classical and Bespoke Tornado Diagrams 212 Chapter 9 The Selection of Distributions for Use in Risk Models 215 9.1 Descriptions of Individual Distributions 215 9.1.1 The Uniform Continuous Distribution 216 9.1.2 The Bernoulli Distribution 218 9.1.3 The Binomial Distribution 219 9.1.4 The Triangular Distribution 220 9.1.5 The Normal Distribution 222 9.1.6 The Lognormal Distribution 226 9.1.7 The Beta and Beta General Distributions 232 9.1.8 The PERT Distribution 234 9.1.9 The Poisson Distribution 236 9.1.10 The Geometric Distribution 238 9.1.11 The Negative Binomial Distribution 240 9.1.12 The Exponential Distribution 241 9.1.13 The Weibull Distribution 242 9.1.14 The Gamma Distribution 242 9.1.15 The General Discrete Distribution 244 9.1.16 The Integer Uniform Distribution 245 9.1.17 The Hypergeometric Distribution 245 9.1.18 The Pareto Distribution 246 9.1.19 The Extreme Value Distributions 246 9.1.20 The Logistic Distribution 250 9.1.21 The Log-Logistic Distribution 251 9.1.22 The Student (t), Chi-Squared and F-Distributions 252 9.2 A Framework for Distribution Selection and Use 256 9.2.1 Scientific and Conceptual Approaches 257 9.2.2 Data-Driven Approaches 258 9.2.3 Industry Standards 259 9.2.4 Pragmatic Approaches: Distributions, Parameters and Expert Input 259 9.3 Approximation of Distributions with Each Other 263 9.3.1 Modelling Choices 263 9.3.2 Distribution Comparison and Parameter Matching 265 9.3.3 Some Potential Pitfalls Associated with Distribution Approximations 267 Chapter 10 Creating Samples from Distributions 273 10.1 Readily Available Inverse Functions 274 10.1.1 Functions Provided Directly in Excel 274 10.1.2 Functions Whose Formulae Can Easily Be Created 276 10.2 Functions Requiring Lookup and Search Methods 277 10.2.1 Lookup Tables 277 10.2.2 Search Methods 278 10.3 Comparing Calculated Samples with Those in @RISK 279 10.4 Creating User-Defined Inverse Functions 280 10.4.1 Normal Distribution 281 10.4.2 Beta and Beta General Distributions 282 10.4.3 Binomial Distribution 283 10.4.4 Lognormal Distribution 283 10.4.5 Bernoulli Distribution 284 10.4.6 Triangular Distribution 284 10.4.7 PERT Distribution 284 10.4.8 Geometric Distribution 285 10.4.9 Weibull Distribution 285 10.4.10 Weibull Distribution with Percentile Inputs 285 10.4.11 Poisson Distribution 285 10.4.12 General Discrete Distribution 287 10.5 Other Generalisations 287 10.5.1 Iterative Methods using Specific Numerical Techniques 287 10.5.2 Creating an Add-In 289 Chapter 11 Modelling Dependencies between Sources of Risk 291 11.1 Parameter Dependency and Partial Causality 291 11.1.1 Example: Conditional Probabilities 293 11.1.2 Example: Common Risk Drivers 293 11.1.3 Example: Category Risk Drivers 294 11.1.4 Example: Phased Projects 294 11.1.5 Example: Economic Scenarios for the Price of a Base Commodity 295 11.1.6 Example: Prices of a Derivative Product 296 11.1.7 Example: Prices of Several Derivative Products 297 11.1.8 Example: Oil Price and Rig Cost 297 11.1.9 Example: Competitors and Market Share 298 11.1.10 Example: Resampling or Data-Structure-Driven Dependence 299 11.1.11 Implied Correlations within Parameter Dependency Relationships 302 11.2 Dependencies between Sampling Processes 302 11.2.1 Correlated Sampling 303 11.2.2 Copulas 304 11.2.3 Comparison and Selection of Parameter-Dependency and Sampling Relationships 306 11.2.4 Creating Correlated Samples in Excel using Cholesky Factorisation 309 11.2.5 Working with Valid Correlation Matrices 313 11.2.6 Correlation of Time Series 315 11.3 Dependencies within Time Series 316 11.3.1 Geometric Brownian Motion 317 11.3.2 Mean-Reversion Models 319 11.3.3 Moving Average Models 321 11.3.4 Autoregressive Models 321 11.3.5 Co-Directional (Integrated) Processes 323 11.3.6 Random State Switching and Markov Chains 323 Part III Getting Started with Simulation in Practice Chapter 12 Using Excel/VBA for Simulation Modelling 327 12.1 Description of Example Model and Uncertainty Ranges 327 12.2 Creating and Running a Simulation: Core Steps 328 12.2.1 Using Random Values 328 12.2.2 Using a Macro to Perform Repeated Recalculations and Store the Results 330 12.2.3 Working with the VBE and Inserting a VBA Code Module 330 12.2.4 Automating Model Recalculation 331 12.2.5 Creating a Loop to Recalculate Many Times 331 12.2.6 Adding Comments, Indentation and Line Breaks 332 12.2.7 Defining Outputs, Storing Results, Named Ranges and Assignment Statements 333 12.2.8 Running the Simulation 334 12.3 Basic Results Analysis 335 12.3.1 Building Key Statistical Measures and Graphs of the Results 335 12.3.2 Clearing Previous Results 336 12.3.3 Modularising the Code 338 12.3.4 Timing and Progress Monitoring 339 12.4 Other Simple Features 339 12.4.1 Taking Inputs from the User at Run Time 339 12.4.2 Storing Multiple Outputs 340 12.5 Generalising the Core Capabilities 340 12.5.1 Using Selected VBA Best Practices 340 12.5.2 Improving Speed 341 12.5.3 Creating User-Defined Functions 342 12.6 Optimising Model Structure and Layout 343 12.6.1 Simulation Control Sheet 343 12.6.2 Output Links Sheet 344 12.6.3 Results Sheets 344 12.6.4 Use of Analysis Sheets 346 12.6.5 Multiple Simulations 348 12.7 Bringing it All Together: Examples Using the Simulation Template 350 12.7.1 Model 1: Aggregation of a Risk Register using Bernoulli and PERT Distributions 351 12.7.2 Model 2: Cost Estimation using Lognormal Distributions 352 12.7.3 Model 3: Cost Estimation using Weibull Percentile Parameters 352 12.7.4 Model 4: Cost Estimation using Correlated Distributions 353 12.7.5 Model 5: Valuing Operational Flexibility 353 12.8 Further Possible uses of VBA 354 12.8.1 Creating Percentile Parameters 354 12.8.2 Distribution Samples as User-Defined Functions 354 12.8.3 Probability Samples as User-Defined Array Functions 355 12.8.4 Correlated Probability Samples as User-Defined Array Functions 356 12.8.5 Assigning Values from VBA into Excel 358 12.8.6 Controlling the Random Number Sequence 359 12.8.7 Sequencing and Freezing Distribution Samples 363 12.8.8 Practical Challenges in using Arrays and Assignment Operations 364 12.8.9 Bespoke Random Number Algorithms 364 12.8.10 Other Aspects 364 Chapter 13 Using @RISK for Simulation Modelling 365 13.1 Description of Example Model and Uncertainty Ranges 365 13.2 Creating and Running a Simulation: Core Steps and Basic Icons 366 13.2.1 Using Distributions to Create Random Samples 368 13.2.2 Reviewing the Effect of Random Samples 369 13.2.3 Adding an Output 370 13.2.4 Running the Simulation 370 13.2.5 Viewing the Results 370 13.2.6 Results Storage 373 13.2.7 Multiple Simulations 373 13.2.8 Results Statistics Functions 374 13.3 Simulation Control: An Introduction 377 13.3.1 Simulation Settings: An Overview 377 13.3.2 Static View 377 13.3.3 Random Number Generator and Sampling Methods 379 13.3.4 Comparison of Excel and @RISK Samples 381 13.3.5 Number of Iterations 382 13.3.6 Repeating a Simulation and Fixing the Seed 382 13.3.7 Simulation Speed 383 13.4 Further Core Features 384 13.4.1 Alternate Parameters 384 13.4.2 Input Statistics Functions 384 13.4.3 Creating Dependencies and Correlations 385 13.4.4 Scatter Plots and Tornado Graphs 385 13.4.5 Special Applications of Distributions 395 13.4.6 Additional Graphical Outputs and Analysis Tools 400 13.4.7 Model Auditing and Sense Checking 405 13.5 Working with Macros and the @RISK Macro Language 405 13.5.1 Using Macros with @RISK 405 13.5.2 The @RISK Macro Language or Developer Kit: An Introduction 407 13.5.3 Using the XDK to Analyse Random Number Generator and Sampling Methods 409 13.5.4 Using the XDK to Generate Reports of Simulation Data 417 13.6 Additional In-Built Applications and Features: An Introduction 417 13.6.1 Optimisation 419 13.6.2 Fitting Distributions and Time Series to Data 420 13.6.3 MS Project Integration 421 13.6.4 Other Features 421 13.7 Benefits of @RISK over Excel/VBA Approaches: A Brief Summary 421 Index 425

Read more less

Book SynopsisBuilding an analysis ecosystem for a smarter approach to intelligence Keith Carter''s Actionable Intelligence: A Guide to Delivering Business Results with Big Data Fast! is the comprehensive guide to achieving the dream that business intelligence practitioners have been chasing since the concept itself came into being. Written by an IT visionary with extensive global supply chain experience and insight, this book describes what happens when team members have accurate, reliable, usable, and timely information at their fingertips. With a focus on leveraging big data, the book provides expert guidance on developing an analytical ecosystem to effectively manage, use the internal and external information to deliver business results. This book is written by an author who''s been in the trenches for people who are in the trenches. It''s for practitioners in the real world, who know delivering results is easier said than done fraught with failure, and difficult politiTable of ContentsPreface xi Acknowledgments xvii Introduction 1 Chapter 1: Vision of Actionable Intelligence 5 The Challenge at Hand 7 The Big Data Lie 13 Actionable Intelligence: The Road and the Destination 14 Stages of Actionable Intelligence: Getting Ready for the Journey by Knowing Where You Are and Where to Go 22 Are You Ready to Take the First Step? 26 Summary and Considerations 29 Notes 29 Chapter 2: Discovery of the Business Situation (Business Discovery) 31 Government Intelligence 34 Ask the Questions 37 Answer the Questions: Business Discovery 38 Visual Consistency and the First Tool 42 Off to the Races 45 Summary and Considerations 45 Notes 45 Chapter 3: Creating a Foundation of Data 47 Building the Foundation 48 Benefits of Having the Right Data 49 The Data Challenge 50 Acquire Data in Four Consistent Steps 51 The Byproduct: Master Data Management 61 Data Management Issues in the Spotlight 63 The Data Supply Chain 65 Build the House 65 Summary and Considerations 67 Notes 68 Chapter 4: Visualization 69 Complete Circle 70 So Now, How Can You Do It? 74 The Way Ahead 77 Example of Iterative Visualization to Solve the Question “How Do I Get There Quickly, Safely, Efficiently:” Leveraging Global Positioning System Data 77 Effective Visualizations: Tell a Story to Your Mind 80 Noticing Visualization Pitfalls 80 Summary and Considerations 83 Notes 83 Chapter 5: The Initial Answers 85 Attempting to Regularly Capture Benefits, False Starts, and a Rhythm 87 The Results of Actionable Intelligence Delivered 87 The Power of Quotes 89 Possibilities with Actionable Intelligence 89 Almost Done? 98 Summary and Considerations 99 Note 99 Chapter 6: Time for Change 101 Collaborative Business Planning 103 Linking Collaboration to Actionable Intelligence 106 Summary and Considerations 110 Chapter 7: Governance: Funding Intelligence, Protecting the Results 111 An Actionable Intelligence Governance Methodology 112 Intelligence Budgeting 121 Remember the Key Points of the UPS Story 122 Governing the Use of Actionable Intelligence and Establishing Data Security 125 Summary and Considerations 133 Notes 133 Chapter 8: Sustaining Delivery of Actionable Intelligence 135 Leading Intelligence 136 Quick Wins to Build Trust 140 Hiring Done Right for Big Data with Big Data 145 Training 148 Business Cultural Change 149 Communication 155 Knowledge Lock‐In 157 What’s Next? 159 Summary and Considerations 161 Notes 161 Chapter 9: Tying It All Together 163 Clifford Siegel’s Journey at Lifetime Brands 163 Starting the Right Way 165 Finding the Right Pitch 166 Developing a Mission and Strategy for Intelligence Capabilities 167 TIE: The Intelligent Enterprise at STATS ChipPAC with Elizabeth Lim 170 The Recipe to Greatness 174 Summary and Considerations 179 Notes 180 Chapter 10: Next Frontiers 181 A Healthier Lifestyle with Actionable Intelligence 183 The Street‐Smart Cabbies 184 The Amplified Customer Experience 186 Selling Better 187 Serve Me Better . . . But Don’t Intrude on My Private Life 188 Getting Started 189 The Starbucks Experience 190 Summary and Considerations 191 Notes 191 Chapter 11: Epilogue 193 Four Steps of Actionable Intelligence 195 About the Author 197 About the Contributors 199 Index 201

Read more less

Book SynopsisMaster vSphere automation with this comprehensive reference VMware vSphere PowerCLI Reference, Automating vSphere Administration, 2nd Edition is a one-stop solution for vSphere automation. Fully updated to align with the latest vSphere and PowerCLI release, this detailed guide shows you how to get the most out of PowerCLI''s handy cmdlets using real-world examples and a practical, task-based approach. You''ll learn how to store, access, update, back up, and secure massive amounts of data quickly through the power of virtualization automation, and you''ll get acquainted with PowerCLI as you learn how to automate management, monitoring, and life-cycle operations for vSphere. Coverage includes areas like the PowerCLI SDK, SRM, vCOPS, and vCloud Air. Plus guidance toward scheduling and viewing automation, using DevOps methodology and structured testing and source control of your PowerCLI scripts. Clear language and detailed explanations make this reference the Table of ContentsIntroduction xxiii Part I Install, Configure, and Manage the vSphere Environment 1 Chapter 1 Automating vCenter Server Deployment and Configuration 3 Chapter 2 Automating vSphere Hypervisor Deployment and Configuration 41 Chapter 3 Automating Networking 75 Chapter 4 Automating Storage 119 Rule Sets 146 Chapter 5 Using Advanced vSphere Features 165 Part II Managing the Virtual Machine Life Cycle 211 Chapter 6 Creating Virtual Machines 213 Chapter 7 Using Templates and Customization Specifications 243 Chapter 8 Configuring Virtual Machine Hardware 265 Chapter 9 Advanced Virtual Machine Features 293 Chapter 10 Using vApps 331 Part III Securing Your vSphere Environment 373 Chapter 11 Backing Up and Restoring Your Virtual Machines 375 Chapter 12 Organize Your Disaster Recovery 397 Chapter 13 Hardening the vSphere Environment 441 Chapter 14 Maintain Security in Your vSphere Environment 475 Part IV Monitoring and Reporting 495 Chapter 15 Reporting and Auditing 497 Chapter 16 Using Statistical Data 545 Chapter 17 Alarms 585 Part V Integration 619 Chapter 18 The SDK 621 Managed Object References 644 Chapter 19 vCloud Director 663 Chapter 20 vCloud Air 693 Chapter 21 vRealize Orchestrator 711 Chapter 22 Site Recovery Manager 791 Chapter 23 PowerActions 811 Part VI PowerCLI and DevOps 839 Chapter 24 Source Control 841 Chapter 25 Running Scripts 895 Appendix Example Reports 915 Index 935

Read more less

Book SynopsisSTAYING THE COURSE AS A CIO: HOW TO OVERCOME THE TRIALS AND CHALLENGES OF IT LEADERSHIP The shelf-life of a Chief Information Officer can be shockingly short. Few survive in post for more than a few years. More often each falls prey to insurmountable problems and their careers come to a sharp and ignominious end. In this book, a global CIO with over thirty years of experience in major corporations examines the main reasons why this happens. Readers will understand which types of issue can cause problems for an IT Leader and more importantly, they will learn strategies of how these problems can be minimized or even avoided. IT is often seen a technical backwater, but it is a discipline which has the capability to add massive value to an organisation whether it is in the private or the public sector provided of course it has the right leadership doing the right things. Aspiring IT Leaders will need to deal with acommon set of recurring trials and challengeTrade Review“If you are a CIO or thinking about taking on the position, this book should be on your list of essential reading….it is an excellent book” (BCS, February 2015) “The distillation of 30 years of experience from a CIO who knows a thing or two about an extended shelf life” (i-cio.com, February 2015)“Michell gives useful advice on how to work through the toughest projects and solve some of the most pressing issues CIOs deal with today” (World Economic Forum, May 2015) “For IT professionals looking to fully integrate their function into the enterprise, 'Staying the Course as a CIO' is a valuable source of practical advice, all based on real experience.” (Good Reads, June 2015)Table of ContentsIntroduction xi Chapter 1 Dislocated Stakeholders 1 Wooden Poles with Holder 2 Because They’re Worth It? 4 The Joys of Middle Management 10 Layers and Spans 11 Middle Managers and the Linkage between IT and the Business 13 The View from the Top of the Tree 16 Bored Boards 18 The Relationship Conundrum 19 The Henry VIII Method 20 The Customer/Supplier Model 20 Teamwork! 23 Could I Have Something Impossible Please? 26 The Dead‐Hero Zone 26 Magicians, Circuses and Keeping Something in the Tank 28 Chapter 2 Pathogenic Projects 31 IT Projects are Harder than Climbing Everest 33 Not Everyone Gets to be a Pharaoh 36 Don’t Start Anything You Can’t Finish 38 Peaches Are not the Only Fruit 39 Ungrouping Group‐Think 40 Mugging by PowerPoint 42 Back to the Himalayas 43 Stalinist Project Management 44 Undo‐able Projects 44 Stalin’s Special Question 45 Being Nostradamus 49 My Piece of String is Skewed 51 Things Can Go Badly Wrong, but They Rarely Go Badly Right 52 Inoculating against Skew—Percentile Therapy 54 What Happens in Projects Stays in Projects 56 The Gates of Wrath 58 Looking Up from the Pit 62 Chapter 3 Seriously Shaky Software 63 Software Just Doesn’t Wo.. 65 Being Immune to Tangerines 70 The Unfortunate Side‐Effect of Moore’s Law 72 It Will be Fixed in the Next Release 74 Upgrade or You Will be Banished Naked to a World of Loneliness and Isolation 75 Belchware not Bloatware 77 Patched, Leaking and Lost in a Maze 79 The Wobbly Stack 81 Stabilising Shakiness 84 Safe Software 85 The Safe Software Game 86 Booking a Landing Slot at Heathrow 88 Don’t Try to Improve a Da Vinci, Unless You Are a Rembrandt 89 Bespoke Only When You’re Bespoken to 92 Chapter 4 Obsessive Outsourcing Compulsion 95 Outsourcing an Empire 97 Strains of Outsourcing Compulsion 101 Madness with Metrics 102 Giving the Fox the Keys to the Chicken Coop … 103 The Nineteenth Hole Contract 105 Dedicated Followers of Fashion 106 Finance is not about Engineering Anything 108 Contract Accounting and Runaway Trains 110 Faster than a Speeding Bullet … 113 The Capability Argument 113 The Economic Argument 114 Better Out than In? 115 Protecting the Crown Jewels 117 Everyone Needs to Win 121 In Summary 124 Chapter 5 Chronic Consultancy Syndrome 125 Consultants—The Hummingbirds of the IT Jungle 126 Survival of the Sharpest 128 Spotting Hummingbirds in the Wild 129 An Expensive Dose of Aviary Assistance 130 Predator or Prey? 131 What Consulting Isn’t …? 132 It Was Their Fault! 133 The Magic of a Name 134 The Consultant’s Crutch 135 But What Consulting Perhaps Should Be? 135 Forests, Trees and Spectacles 137 You Are not Alone on Planet Earth 139 Nothing New Under the Sun 141 Hummingbirds Flap Harder than Cash Cows 142 How Hummingbirds Turn into Cuckoos 143 Answer 1—The Cuckoo Consultancy End‐Game Solution 147 Answer 2—The Thin‐Edge‐Wedge‐End‐Game Cash Cow 147 And Finally 148 Chapter 6 Strategy Schizophrenia 151 A Beginner’s Guide to World Domination 152 Types of Strategy 154 The Better Tomorrow 154 The Grand Plan 158 Strategy Schizophrenia—Balancing the Unbalanceable 161 Summary 164 Chapter 7 Bleeding Budgets 167 A Beginner’s Guide to Building a Roulette Table 168 How Much Are You Going to Spend? 168 How Much Goodness? 170 Which Investments? 174 But What about Tomorrow? 177 Putting Today and Tomorrow’s Investments Together 180 Putting the Final Touches to the Roulette Table 181 Placing the Chips 182 Our Transformation Journey 184 Other Funding Profile Examples 186 Funding Choice 1—The Support Organisation 186 Funding Choice 2—The “Go for it” Organisation 187 Summary 188 Chapter 8 Epilogue—What Might Overcome You? 191 It’s Always the Same Culprits, Except When it Isn’t 191 Failure and Folklore 194 IT Leadership Morbidity Tables 195 First Tier—Dislocated Stakeholders 195 Second Tier—Money and Strategy 197 Third Tier—Projects and Software 198 Fourth Tier—Outsourcing 199 Fifth Tier—Consultancy 199 The Unknown Unknowns 200 Acknowledgements 203 Bibliography 207 Index 211

Read more less

Book SynopsisStart designing today with this hands-on beginner's guide to AutoCAD Civil 3D 2016 AutoCAD Civil 3D 2016 Essentials gets you quickly up to speed with the features and functions of this industry-leading civil engineering software.Table of ContentsIntroduction xii Chapter 1 Navigating the User Interface 1 Getting to Know the Civil 3D User Interface 2 Working with the Application Menu 3 Working with the Ribbon 5 Working with the Toolspace 8 Using the Drawing Area 11 Using the Command Line 12 Using Panorama 12 Using the Transparent Commands Toolbar 13 Using the Inquiry Tool 14 Chapter 2 Leveraging a Dynamic Environment 17 Connecting Objects and Styles 18 Connecting Labels and Label Styles 23 Connecting Objects to Objects 27 Connecting Objects to Labels 29 Appreciating the Richness of the 3-D Model 31 Sharing Data in a Dynamic Environment 33 Chapter 3 Establishing Existing Conditions Using Survey Data 37 What Is Survey Data? 38 Creating a Survey Database 39 Importing Survey Data 41 Automating Field-to-Finish 45 Editing Survey Points 57 Editing Survey Figures 59 Creating Additional Points 61 Chapter 4 Modeling the Existing Terrain Using Surfaces 65 Understanding Surfaces 66 Creating a Surface from Survey Data 67 Using Breaklines to Improve Surface Accuracy 71 Editing Surfaces 77 Displaying and Analyzing Surfaces 82 Annotating Surfaces 87 Chapter 5 Designing in 2-D Using Alignments 91 Understanding Alignments 92 Creating Alignments from Objects 92 Creating Alignments Using the Alignment Creation Tools 95 Editing Alignments 99 Applying Design Criteria Files and Check Sets 107 Chapter 6 Displaying and Annotating Alignments 113 Using Alignment Styles 114 Applying Alignment Labels and Label Sets 116 Creating Station/Offset Labels 121 Creating Segment Labels 123 Using Tag Labels and Tables 126 Chapter 7 Designing Vertically Using Profiles 131 Creating Surface Profiles 132 Displaying Profiles in Profile Views 133 Creating Design Profiles 134 Editing Profiles 136 Using Design Check Sets and Criteria Files 144 Chapter 8 Displaying and Annotating Profiles 149 Applying Profile Styles 150 Applying Profile View Styles 152 Applying Profile View Bands 154 Applying Profile Labels 157 Creating and Applying Profile Label Sets 159 Creating Profile View Labels 160 Projecting Objects to Profile Views 164 Chapter 9 Designing in 3D Using Corridors 169 Understanding Corridors 170 Creating an Assembly 173 Creating a Corridor 175 Applying Corridor Targets 176 Creating Corridor Surfaces 185 Chapter 10 Creating Cross Sections of the Design 191 Using the Section Editor 192 Creating Sample Lines 195 Creating Section Views 198 Sampling More Sources 202 Chapter 11 Displaying and Annotating Sections 207 Applying Section Styles 208 Applying Section Labels 210 Controlling Corridor Section Display with Code Set Styles 213 Applying Labels with Code Set Styles 215 Applying Section View Styles 217 Applying Section View Bands 220 Applying Group Plot Styles 223 Creating Section View Labels 225 Chapter 12 Designing and Analyzing Boundaries Using Parcels 229 Understanding Parcels 230 Creating Parcels from Objects 232 Creating Parcels by Layout 235 Editing Parcels 246 Chapter 13 Displaying and Annotating Parcels 253 Applying Parcel Styles 254 Applying Parcel Area Labels 258 Creating Parcel Segment Labels 261 Editing Parcel Segment Labels 264 Creating Parcel Tables 267 Chapter 14 Designing Gravity Pipe Networks 273 Understanding Gravity Pipe Networks 273 Creating Gravity Pipe Networks 277 Editing Gravity Pipe Networks 285 Chapter 15 Designing Pressure Pipe Networks 297 Understanding Pressure Pipe Networks 297 Creating Pressure Pipe Networks 300 Editing Pressure Pipe Networks 305 Chapter 16 Displaying and Annotating Pipe Networks 317 Displaying Pipe Networks Using Styles 318 Annotating Pipe Networks in Plan View 325 Annotating Pipe Networks in Profile View 331 Creating Pipe Network Tables 335 Chapter 17 Designing New Terrain 339 Understanding Grading 340 Understanding Feature Lines 341 Creating Feature Lines 342 Editing Feature Lines 344 Understanding Grading Objects 352 Creating Grading Objects 355 Editing Grading Objects 358 Chapter 18 Analyzing, Displaying, and Annotating Surfaces 361 Combining Design Surfaces 362 Analyzing Design Surfaces 368 Calculating Earthwork Volumes 376 Labeling Design Surfaces 380 Appendix AutoCAD Civil 3D 2016 Certification 385 Index 389

Read more less

Book SynopsisYour real-world introduction to mechanical design with Autodesk Inventor 2016 Mastering Autodesk Inventor 2016 and Autodesk Inventor LT 2016is a complete real-world reference and tutorial for those learning this mechanical design software. With straightforward explanations and practical tutorials, this guide brings you up to speed with Inventor in the context of real-world workflows and environments. You''ll begin designing right away as you become acquainted with the interface and conventions, and then move into more complex projects as you learn sketching, modeling, assemblies, weldment design, functional design, documentation, visualization, simulation and analysis, and much more. Detailed discussions are reinforced with step-by-step tutorials, and the companion website provides downloadable project files that allow you to compare your work to the pros. Whether you''re teaching yourself, teaching a class, or preparing for the Inventor certification exam, this is theTable of ContentsIntroduction xxvii Chapter 1 • Getting Started 1 Understanding Parametric Design 1 Creating a Base Sketch 1 Creating a Base Feature 2 Adding More Features 3 Using the Part in an Assembly 3 Making Changes 4 Understanding History-Based Modeling and Dependencies 4 Taking a Closer Look at Sketch Dimensions 5 Following Part Modeling Best Practices 7 Following Assembly Modeling Best Practices 8 Understanding the “Feel” of Inventor 10 Understanding the Intuitive Interface 10 Using General Tools vsSpecifi c Commands 12 When in Doubt, Right-Click 12 Using the Graphical Interface 13 Inventor Title Bar 14 Graphics Window Tools 15 The Ribbon Menu 17 The Browser Pane/Model Browser 19 Dialog Boxes and the In-Canvas Mini-Toolbars 19 Task-Based Tools 20 Learning the File Types in Inventor 20 What Is an Inventor Project? 22 Project Files and Search Paths 22 Library Folders and Library Editor IPJ Files 25 Content Center Files 26 How Search Paths and Project Files Are Used 26 Exploring Project File Types 27 Creating a Project File 29 Creating Single-User Projects 29 Creating Multiuser Projects 38 Understanding Inventor Templates39 Working with Styles, Style Libraries, and Company Standards 40 The Bottom Line 40 Chapter 2 • A Hands-on Test-Drive of the Workflow 43 Creating a Part Model 43 Starting with a Part Template 45 Understanding Origin Geometry 45 Creating a Base 2D Sketch 46 Creating a Profi le in the Sketch 48 Creating a Base 3D Feature 48 Creating a Secondary 2D Sketch 49 Creating a Secondary 3D Feature 51 Patterning a 3D Feature 52 Creating and Detailing Drawings of Part Models 53 Creating a Base View on a Drawing 53 Creating Projected Views on a Drawing 55 Creating Dimensions on a Drawing 55 Putting Part Models Together in Assembly Files 56 Placing, Rotating, and Moving Parts in an Assembly File 57 Working with Degrees of Freedom in an Assembly 58 Placing Assembly Constraints to Defi ne Mechanical Movement 60 Creating and Detailing Drawings of Assembly Models 63 Creating an Assembly Detail View 63 Placing a Parts List and Balloons 65 Exporting a Drawing to a PDF File 66 The Bottom Line 66 Chapter 3 • Sketch Techniques 69 Exploring the Options and Settings for Sketches 69 Application Options 70 Document Settings 75 Sketching Basics 75 Creating a Sketch on an Existing Sketch 76 Projecting Geometry into Your Sketch 77 Breaking Links to Projected Geometry 79 Deleting a Sketch 80 Creating Another New Sketch 80 Creating Dimensions 81 Creating a Sketch in a New Part 82 Creating a New Part File from a Template 82 Creating Lines Using the Line Tool 84 Understanding Sketch Constraints 86 Using Degrees of Freedom to View Underconstrained Sketch Elements 88 Using Dimensions to Fully Constrain a Sketch 89 Understanding the Save Options 92 Making a Sketch Active for Edits 93 Using Construction Geometry 93 Using the Polygon Tool and Creating an Aligned Dimension 95 Using Offset and Creating a Three-Point Rectangle 97 Creating Driven Dimensions 99 Taking a Closer Look at Sketch Constraints 102 The Tangent Constraint 103 The Perpendicular Constraint 103 The Parallel Constraint 104 The Coincident Constraint 105 The Concentric Constraint 105 The Collinear Constraint 106 The Horizontal Constraint 106 The Vertical Constraint 107 The Equal Constraint 108 The Fix Constraint 109 The Symmetric Constraint 109 The Smooth Constraint 110 Gaining More Sketch Skills 111 Creating Arcs 111 Creating Automatic Tangents with the Line Tool 113 Understanding the Point/Center Point Tool 113 Projecting Geometry 114 Learning More about Dimensions 115 Measuring Geometry 119 Creating Sketches from AutoCAD Geometry 120 Importing Existing AutoCAD Designs 120 Copying and Pasting Existing AutoCAD Designs into Inventor 122 Creating and Using 3D Sketches 123 Creating a 3D Path 123 Using the 3D Coordinate Triad 124 Exploring More 3D Sketch Tools 127 Best Practices for Working with Sketches 132 The Bottom Line 133 Chapter 4 • Basic Modeling Techniques 135 Exploring Application Options and Settings for Part Modeling 135 Specifying Global Settings 135 Specifying Document-Specific Settings 137 Key Concepts for Creating Basic Part Features 144 Simplifying Your Sketches 147 Exploring the Extrude Tool 148 Extruding Basic Features 149 Editing an Extrusion Feature 152 Extruding with Cut and Taper 152 Extruding with Intersect 153 Extruding Surfaces from Open Profiles 155 Extruding Solids from Open Profiles 156 Extruding with To 158 Extruding with the Minimum Solution Option 160 Extruding with To Next 160 Extruding Between 161 Extruding Multi-body Solids 162 Creating Revolved Parts 164 Revolved Cylindrical Parts vsStacked Circular Extrusions 164 Creating Revolved Parts 165 Creating Work Features 167 Work Planes 168 Work Axes and Work Points 174 Creating Fillets 175 Edge Fillets 176 Face Fillets 179 Full Round Fillets 180 Working with Fillet Features 180 Creating Threaded Features 182 Creating Cosmetic Threads Using the Thread Tool 182 Using the Coil Tool to Create Physical Threads 183 Hole Features 184 Using the Thread and Clearance Spreadsheets 184 Creating Holes in Parts 186 Setting Tolerance Values in Holes 188 Bend Parts 189 Part Modeling Exercise 190 Creating a Base Feature 191 Creating a Second Feature 192 Creating a Sketch-Based Hole Feature 194 Creating a Rectangular Hole Pattern 197 Editing Sketches and Features 199 Repairing Features and Sketches 202 The Bottom Line 204 Chapter 5 • Advanced Modeling Techniques 207 Creating Complex Sweeps and Lofts 207 Creating and Using Sweeps 208 Exploring Sweep Options 210 Creating Loft Features 214 Creating a Part Using Loft and Sculpt 221 Creating Multi-body Parts 223 Creating Multiple Solids 223 Using One Solid to Shape Another 225 Creating Derived Parts and Assemblies 230 Creating Derived Parts 230 Deriving a Part File 230 Deriving an Assembly File 232 Modifying Derived Parts 233 Using the Component Derive Tool 233 Working with Patterns 233 Rectangular Patterns 233 Circular Patterns 234 Patterns Along Curves 236 The Coil Tool and Spiral Patterns 238 Pattern Solids 240 Dynamic Patterns 243 Setting iProperties and Parameters 244 iProperties 244 Part Parameters 245 Assembly Parameters 250 Adding Part Tolerances 250 Tolerances in Sketches 251 Setting Global File Tolerances 252 Working with Limits and Fits 254 Working with Free-Form Modeling and Direct Editing Tools 257 Free-Form Modeling 257 Using the Direct Edit Tool 264 Troubleshooting Failures with the End-of-Part Marker 265 Step 1: Editing the First Feature 266 Step 2: Moving the EOP Marker Down One Feature at a Time 267 The Bottom Line 268 Chapter 6 • Sheet Metal 269 Understanding Sheet-Metal Parts 269 Getting to Know the Features 270 Starting with a Base Feature 270 Creating Secondary Flange Features 276 Adding, Removing, or Deforming Material 285 Using Sheet-Metal Templates and Rules 302 What Are Sheet-Metal Rules? 302 Working with Styles and Templates 310 Working with the Flat Pattern 311 Exploring the Flat Pattern Edit Features 311 Adding Manufacturing Information to the Flat Pattern 311 Using the Flat Pattern Definition Dialog Box 313 Manufacturing Your Flat Pattern 314 Using Sheet-Metal iPart Factories 315 iParts for Confi gurations 316 iParts for Fold Progression 316 Modeling with Non-Sheet-Metal Features 317 Selecting Problematic Features 317 Using Surface-Based Workflows 317 Working with Imported Parts 318 Setting Yourself Up for Success 318 Converting Components 318 Annotating Your Sheet-Metal Design 319 Creating a View of Your Sheet-Metal Design 319 Adding Bend, Punch, and Flat Pattern Annotations 321 The Bottom Line 323 Chapter 7 • Reusing Parts and Features 325 Working with iParts 325 Creating and Modifying iParts 326 Using iParts in Designs 338 Working with iFeatures 340 Creating iFeatures 341 Creating Punch Features 345 Reusing Existing Geometry 349 Copying Features 349 Cloning 351 Linking Parameters Between Two Files 352 Copying Sketches 353 Introducing Content Center 355 Confi guring Content Center 356 Using Content Center 358 Publishing Parts to Content Center 366 The Bottom Line 369 Chapter 8 • Assembly Design Workflows 371 Assembly Relationships 372 Degrees of Freedom 372 Grounded Components 374 How the Constrain Tool Works 375 How the Joint Tool Works 376 Working with Constraints 377 Additional Constrain Tools and Options 391 Working with Joint Relationships 397 Understanding Subassemblies 408 Top-Down Design 410 Developing an Efficient Assembly Workflow 410 Layout Sketches 414 Flexibility 417 Adaptivity 417 Creating Adaptivity 418 Removing Adaptivity from Parts 420 Assembly Features 421 Managing the Bill of Materials 423 Parts-Level BOM Control 424 Assembly-Level BOM Control 424 Assembly Reuse and Configurations 431 Copying Designs 431 Using Representations 433 Using iAssemblies 443 Use Assembly Design Accelerators 447 Functional Design vsGeometric Modeling 447 Working with Design Accelerators 448 The Bottom Line 455 Chapter 9 • Large Assembly Strategies 457 Selecting a Workstation 457 Physical Memory vs Virtual Memory 458 Hardware 458 Working with Performance Settings 461 Express Mode 461 Working with Drawing Settings 461 Working with Model Display Settings 465 Working with General Settings 466 Using the Memory Probe 468 Working with System Settings 469 Large Assembly Best Practices 470 Working with the Model 470 Improving File Open Time 471 Reducing Assembly Constraints 471 Adaptivity 474 Selection Tools 475 View Representations 477 Find 477 Opening the Model 478 Working with Large Assembly Drawings 479 Managing Assembly Detail 483 LOD Strategies 483 Substitute LODs 485 Subassembly LODs 487 Simplifying Parts 489 Removing or Suppressing Unneeded Features 489 The Bottom Line 491 Chapter 10 • Weldment Design 493 Exploring Weldment Design Methodologies 493 Part Files and Part Features 494 Weldment Assembly and Derived Technology 494 Weldment Assembly 495 Multi-body Part Files 496 Modeling Preparations 497 Exploring Cosmetic Welds 499 Creating a Simple Cosmetic Weld 501 Using Split Faces to Place Cosmetic Welds 502 Placing Cosmetic Welds with Extents 502 Creating Weld Beads 503 Creating Fillet Welds 504 Modeling a Fillet Weld 505 Fillet Welds and Gaps 507 Creating Intermittent Fillet Welds 508 Creating Groove Welds 509 Performing Machining Operations 512 Exploring Weld Properties and Combinations 513 Weld Properties 513 Replication 514 Groove and Fillet Weld Combinations 514 Split Technique 515 Using the Weld Symbol 517 Understanding Bead Property Report and Mass Properties 518 Creating Drawing Documentation 519 Weldment Design Stages 521 End Fill 523 Drawing Weld Symbols 524 Caterpillar 525 Generating a Bill of Materials and Parts List 526 The Bottom Line 527 Chapter 11 • Presentations and Exploded Views 529 Getting Started 530 Working in the Presentation Environment 530 Creating an Automatically Exploded Presentation 532 Creating Tweaks Individually 535 Preparing the Exploded Presentation to Be Used in an Animation 538 Hiding Components from View During Animations 544 Rounding Up Presentation Preparation 546 Creating and Publishing Animations 546 Animation File Types and Compression Codecs 547 The Bottom Line 549 Chapter 12 • Documentation 551 Creating Drawing Views 551 Creating a Base View 552 Moving and Copying Views 556 Creating Section Views 557 Slice Views 561 Using Breakout Views 562 Using Detail Views 566 Creating Break Views 567 Cropping Views 570 Using Draft Views 570 Creating Overlay Views 570 Annotating Part Drawings 571 Using Centerline and Center Marks 571 Creating Dimensions 576 Hole and Thread Notes 588 Leadered Symbols589 Drawing Text 590 General Tables 590 Hole Tables 592 Annotating Assembly Drawings 594 Assembly Representations 595 Reference Data in Drawing Views 597 Interference and Tangent Edge Display 598 Parts Lists 599 Balloons 601 Center of Gravity Display 603 Working with Sheet-Metal Drawings 604 Flat Pattern Views 604 Bend Centerlines and Extents 605 Bend and Punch Notes 605 Bend Tables 606 Punch Tables 607 Working with Weldment Views 608 Working with iParts and iAssembly Drawings 610 Drawing Standards 611 Creating Templates and Styles 612 Understanding Template Locations 613 Choosing a File Format 614 Utilizing Drawing Resources 615 Sheet Size 615 Multiple Sheets 616 Creating a Border 616 Creating a Title Block 618 Prompted Entry 623 Sketched Symbols 625 AutoCAD Blocks 627 Sketched Symbol Libraries 627 Sheet Formats 628 Transferring Drawing Resources 629 Editing Styles and Standards 630 Object Defaults 631 Creating Styles 634 Working with Substyles 635 Drawing Style Administration 636 Sharing Your Drawings Outside Your Workgroup 636 The Bottom Line 637 Chapter 13 • Tools Overview 641 Exploring the BIM Exchange 641 Assembly Model Simplification 642 Part Model Simplification 647 Model Authoring 649 Model Publishing 650 Using AutoLimits 653 Creating AutoLimits 655 Editing AutoLimits 657 Using the Design Assistant 658 Using the Find Files Tool 660 Using the Where Used Tool 661 Renaming, Copying, and Replacing Files 663 Using Pack And Go 664 Using the Drawing Resource Transfer Wizard 667 Using the Style Library Manager 668 Using the Task Scheduler 670 Creating a Task for Migrating Files 671 Performing Sequential Tasks 673 Performing Custom Tasks 674 Tweaking Multi-Process Settings 674 Publishing DWF Files and Filenames 675 Using iProperties 675 Copying iProperties to Drawings 677 Creating Expressions with iProperties 678 Working with the Design Assistant and iProperties 679 Creating Design Property Reports 680 Using the Measure Tools 681 Using Measurement Helpers 681 Measuring in Assemblies 683 Participating in the CIP and CER R 683 Participating in the CIP 683 Participating in CER 684 Using Miscellaneous Tools 684 Using the Autodesk Multi-Sheet Plot Tool 684 Using the Add-In Manager 685 Using the Project Editor 686 The Bottom Line 686 Chapter 14 • Exchanging Data with Other Systems 687 Importing and Exporting Geometry 687 Importing vsReferencing Geometry 688 Translating DWG and DXF Files 695 Mechanical Desktop DWG 703 STEP and IGES 704 SAT 706 CATIA Import Options 706 Pro/ENGINEER Import Options 707 Unigraphics and Parasolids Import Options 707 SolidWorks Import Options 708 Rhino Import Options 708 SMT Import Options 708 JT Import Options708 STL Import Options 709 IDF Board Files 709 Working with Imported Data 711 Repair Tools 711 Edit Solid Tools 711 Viewing DWF Markup 714 Publishing a DWF or DWFx File 715 Reviewing and Marking Up DWF and DWFx Files 716 Accessing DWF or DWFx Markups in Inventor 717 The Bottom Line 718 Chapter 15 • Frame Generator 719 Accessing Frame Generator Tools 719 Exploring the Frame Generator File Structure 720 Exploring the Anatomy of a Frame Member 722 Inserting Frame Members 723 Specifying a Structural Shape 723 Changing the Orientation 724 Selecting Placement Geometry 725 Creating a Basic Frame 726 Aligning Frame Members 730 Using the Change Tool731 Adding End Treatments 732 Miter 733 Trim/Extend to Face 736 Trim to Frame Member 737 Notch Frame Members 738 Lengthen/Shorten Frame Member 739 Reuse Frame Members 739 Maintaining Frames 741 Remove End Treatments 741 Frame Member Information 741 Refresh 741 Performing Calculations and Analysis 742 The Beam and Column Calculator 742 Publishing Frame Members 751 Authoring a Part 751 Publishing a Part 754 Frame Assemblies and BOMs 755 The Bottom Line 756 Chapter 16 • Inventor Studio 757 How to Make Your Models Look Great, Live Onscreen 758 Materials and Appearances 758 Visual Styles Settings 764 Saving an Image 773 Rounding Up 773 An Introduction to Inventor Studio 774 How to Create a Still Image (Render) 776 Inventor Studio Lighting Styles 780 How to Add Local Lights 781 How to Add Cameras 784 How to Create an Animated Render 788 Animating with Inventor Studio 790 Inventor Studio Video Producer 796 Rendering Animations 797 Inventor Studio Roundup 798 The Bottom Line 799 Chapter 17 • Stress Analysis and Dynamic Simulation 801 Introducing Analysis 801 Conducting Stress Analysis Simulations 802 Simulation Guide 803 Static Stress vsModal Analysis 803 Simplifying Your Model 803 Specifying Materials 804 Applying Simulation Constraints 805 Applying Loads 806 Specifying Contact Conditions 808 Preparing Thin Bodies 810 Generating a Mesh 810 Running the Simulation 812 Interpreting the Results 813 Using the Result, Scaling, Display, and Report Tools 814 Conducting Parameter Studies 815 Conducting a Frame Analysis 819 Frame Analysis Settings 819 Frame Constraints 819 Frame Loads 820 Connections 821 Results821 Conducting Dynamic Simulations 823 Working with Joints 823 More on Working with Joints 827 Working with Redundancy 828 Working with Environmental Constraints 829 Running a Simulation 835 Exporting to FEA 838 Using the Dynamic Simulation Information in Stress Analysis 839 The Bottom Line 839 Chapter 18 • Routed Systems 841 Tube and Pipe 841 Understanding Routes, Runs, and Assembly Structure 841 Tube and Pipe Settings 843 Exploring the Tube and Pipe Styles 844 Placing Fittings 849 Creating Routes 850 Exporting ISOGEN Files 859 Cable and Harness 859 Creating and Placing Electrical Parts 860 Creating a Harness 863 Placing Wires 865 Using the Cable & Harness Library 866 Placing Cables 867 Placing and Editing Segments 868 Copying Cable and Harness Designs 871 Creating Nailboard Drawings 873 The Bottom Line 875 Chapter 19 • Plastics Design Features 877 Creating Thicken/Offset Features 878 Creating Shell Features 879 Creating Split Features 881 Creating Grill Features 882 Creating Rule Fillet Features 884 Creating Rest Features 886 Creating Boss Features 888 Creating Lip and Groove Features 891 Creating Snap-Fit Features 892 Creating Rib and Web Features 894 Creating Draft Features 896 Mold Design Overview 898 Inventor Tooling 898 Importing a Plastic Part 899 Creating Runners and Gates 902 Analyzing and Creating Cores and Cavities 904 Working with Mold Bases 907 Working with Ejectors and Sprue Bushings 909 The Bottom Line 912 Chapter 20 • iLogic 915 What Is iLogic? 915 Understanding iLogic Rules 916 What Are Functions? 916 Conditional Statements 919 Understanding the iLogic Elements and Interface 921 Exploring iLogic Parameter Types 921 Using the iLogic Browser 924 Understanding the iTrigger 930 Working with Event Triggers 930 Creating iLogic Parameters, Rules, and Forms 931 Creating iLogic Rules 931 Creating iLogic Forms 946 Working with iLogic Components 957 iLogic Design Copy 958 The Bottom Line 959 Appendix A • Th e Bottom Line 961 Chapter 1: Getting Started 961 Chapter 2: A Hands-on Test-Drive of the Workflow 963 Chapter 3: Sketch Techniques 964 Chapter 4: Basic Modeling Techniques 966 Chapter 5: Advanced Modeling Techniques 968 Chapter 6: Sheet Metal 970 Chapter 7: Reusing Parts and Features 973 Chapter 8: Assembly Design Workfl ows 974 Chapter 9: Large Assembly Strategies 977 Chapter 10: Weldment Design 978 Chapter 11: Presentations and Exploded Views 980 Chapter 12: Documentation 981 Chapter 13: Tools Overview 984 Chapter 14: Exchanging Data with Other Systems 986 Chapter 15: Frame Generator 987 Chapter 16: Inventor Studio 988 Chapter 17: Stress Analysis and Dynamic Simulation 991 Chapter 18: Routed Systems 991 Chapter 19: Plastics Design Features 992 Chapter 20: iLogic 995 Appendix B • Autodesk Inventor 2016 Certification 999 Index 1009

Read more less

Book SynopsisLeverage the full power of Excel formulas Excel 2016 Formulas is fully updated to cover all of the tips, tricks, and techniques you need to maximize the power of Excel 2016 through the use of formulas.Table of ContentsIntroduction xxvii Part I: Understanding Formula Basics Chapter 1: The Excel User Interface in a Nutshell 3 The Workings of Workbooks 3 Worksheets 4 Chart sheets 5 Macro sheets and dialog sheets 5 The Excel User Interface 5 The Ribbon 6 Backstage View 7 Shortcut menus and the mini toolbar 7 Dialog boxes 7 Customizing the UI 8 Task panes 9 Customizing onscreen display 9 Numeric formatting 9 Stylistic formatting 9 Protection Options 10 Securing access to the entire workbook 10 Limiting access to specific worksheet ranges 13 Protecting the workbook structure 16 Chapter 2: Basic Facts About Formulas 19 Entering and Editing Formulas 19 Formula elements 20 Entering a formula 20 Pasting names 22 Spaces and line breaks 22 Formula limits 23 Sample formulas 23 Editing formulas 24 Using Operators in Formulas 25 Reference operators 25 Sample formulas that use operators 26 Operator precedence 27 Nested parentheses 29 Calculating Formulas 30 Cell and Range References 30 Creating an absolute or a mixed reference 31 Referencing other sheets or workbooks 33 Copying or Moving Formulas 35 Making an Exact Copy of a Formula 36 Converting Formulas to Values 37 Hiding Formulas 39 Errors in Formulas 40 Dealing with Circular References 41 Goal Seeking 42 A goal seeking example 42 More about goal seeking 43 Chapter 3: Working with Names 45 What’s in a Name? 45 A Name’s Scope 46 Referencing names 47 Referencing names from another workbook 48 Conflicting names 48 The Name Manager 48 Creating names 49 Editing names 50 Deleting names 50 Shortcuts for Creating Cell and Range Names 50 The New Name dialog box 51 Creating names using the Name box 52 Creating names from text in cells 52 Naming entire rows and columns 54 Names created by Excel 55 Creating Multisheet Names 55 Working with Range and Cell Names 57 Creating a list of names 58 Using names in formulas 59 Using the intersection operators with names 59 Using the range operator with names 61 Referencing a single cell in a multicell named range 61 Applying names to existing formulas 62 Applying names automatically when creating a formula 63 Unapplying names 63 Names with errors 64 Viewing named ranges 64 Using names in charts 64 How Excel Maintains Cell and Range Names 65 Inserting a row or column 65 Deleting a row or a column 65 Cutting and pasting 65 Potential Problems with Names 66 Name problems when copying sheets 66 Name problems when deleting sheets 66 The Secret to Understanding Names 68 Naming constants 68 Naming text constants 69 Using worksheet functions in named formulas 70 Using cell and range references in named formulas 71 Using named formulas with relative references 72 Advanced Techniques That Use Names 75 Using the INDIRECT function with a named range 75 Using arrays in named formulas 77 Creating a dynamic named formula 78 Using an XLM macro in a named formula 80 Part II: Leveraging Excel Functions Chapter 4: Introducing Worksheet Functions 85 What Is a Function? 85 Simplify your formulas 86 Perform otherwise impossible calculations 86 Speed up editing tasks 86 Provide decision-making capability 87 More about functions 87 Function Argument Types 88 Names as arguments 89 Full-column or full-row as arguments 89 Literal values as arguments 90 Expressions as arguments 90 Other functions as arguments 91 Arrays as arguments 91 Ways to Enter a Function into a Formula 91 Entering a function manually 91 Using the Function Library commands 93 Using the Insert Function dialog box 94 More tips for entering functions 96 Chapter 5: Manipulating Text 99 A Few Words About Text 99 How many characters in a cell? 99 Numbers as text 99 Text Functions 101 Determining whether a cell contains text 101 Working with character codes 102 Determining whether two strings are identical 105 Joining two or more cells 105 Displaying formatted values as text 106 Displaying formatted currency values as text 108 Removing excess spaces and nonprinting characters 108 Counting characters in a string 109 Repeating a character or string 109 Creating a text histogram 110 Padding a number 111 Changing the case of text 112 Extracting characters from a string 113 Replacing text with other text 113 Finding and searching within a string 114 Searching and replacing within a string 115 Advanced Text Formulas 115 Counting specific characters in a cell 116 Counting the occurrences of a substring in a cell 116 Removing trailing minus signs 116 Expressing a number as an ordinal 117 Determining a column letter for a column number 118 Extracting a filename from a path specification 118 Extracting the first word of a string 119 Extracting the last word of a string 119 Extracting all but the first word of a string 120 Extracting first names, middle names, and last names 120 Removing titles from names 122 Counting the number of words in a cell 122 Chapter 6: Working with Dates and Times 125 How Excel Handles Dates and Times 125 Understanding date serial numbers 126 Entering dates 127 Understanding time serial numbers 129 Entering times 130 Formatting dates and times 131 Problems with dates 133 Date-Related Functions 134 Displaying the current date 135 Displaying any date with a function 136 Generating a series of dates 137 Converting a nondate string to a date 138 Calculating the number of days between two dates 139 Calculating the number of work days between two dates 139 Offsetting a date using only work days 141 Calculating the number of years between two dates 141 Calculating a person’s age 142 Determining the day of the year 143 Determining the day of the week 144 Determining the week of the year 144 Determining the date of the most recent Sunday 144 Determining the first day of the week after a date 145 Determining the nth occurrence of a day of the week in a month 145 Counting the occurrences of a day of the week 146 Expressing a date as an ordinal number 147 Calculating dates of holidays 147 Determining the last day of a month 150 Determining whether a year is a leap year 151 Determining a date’s quarter 151 Converting a year to roman numerals 151 Time-Related Functions 152 Displaying the current time 152 Displaying any time using a function 153 Calculating the difference between two times 154 Summing times that exceed 24 hours 155 Converting from military time 157 Converting decimal hours, minutes, or seconds to a time 158 Adding hours, minutes, or seconds to a time 158 Converting between time zones 159 Rounding time values 160 Calculating Durations 161 Chapter 7: Counting and Summing Techniques 163 Counting and Summing Worksheet Cells 163 Other Counting Methods 165 Basic Counting Formulas 165 Counting the total number of cells 166 Counting blank cells 166 Counting nonblank cells 167 Counting numeric cells 167 Counting text cells 168 Counting nontext cells 168 Counting logical values 168 Counting error values in a range 168 Advanced Counting Formulas 169 Counting cells with the COUNTIF function 169 Counting cells that meet multiple criteria 170 Counting the most frequently occurring entry 173 Counting the occurrences of specific text 174 Counting the number of unique values 176 Creating a frequency distribution 178 Summing Formulas 184 Summing all cells in a range 184 Summing a range that contains errors 185 Computing a cumulative sum 186 Summing the “top n” values 187 Conditional Sums Using a Single Criterion 188 Summing only negative values 189 Summing values based on a different range 190 Summing values based on a text comparison 190 Summing values based on a date comparison 190 Conditional Sums Using Multiple Criteria 191 Using And criteria 191 Using Or criteria 192 Using And and Or criteria 193 Chapter 8: Using Lookup Functions 195 What Is a Lookup Formula? 195 Functions Relevant to Lookups 196 Basic Lookup Formulas 198 The VLOOKUP function 198 The HLOOKUP function 200 The LOOKUP function 201 Combining the MATCH and INDEX functions 202 Specialized Lookup Formulas 203 Looking up an exact value 204 Looking up a value to the left 206 Performing a case-sensitive lookup 207 Choosing among multiple lookup tables 207 Determining letter grades for test scores 208 Calculating a grade point average 209 Performing a two-way lookup 211 Performing a two-column lookup 212 Determining the address of a value within a range 213 Looking up a value by using the closest match 214 Looking up a value using linear interpolation 215 Chapter 9: Working with Tables and Lists 219 Tables and Terminology 219 A list example 220 A table example 220 Working with Tables 222 Creating a table 222 Changing the look of a table 223 Navigating and selecting in a table 224 Adding new rows or columns 225 Deleting rows or columns 226 Moving a table 226 Removing duplicate rows from a table 227 Sorting and filtering a table 228 Working with the Total row 233 Using formulas within a table 235 Referencing data in a table 237 Converting a table to a list 241 Using Advanced Filtering 242 Setting up a criteria range 242 Applying an advanced filter 243 Clearing an advanced filter 245 Specifying Advanced Filter Criteria 245 Specifying a single criterion 245 Specifying multiple criteria 247 Specifying computed criteria 249 Using Database Functions 250 Inserting Subtotals 252 Chapter 10: Miscellaneous Calculations 257 Unit Conversions 257 Rounding Numbers 261 Basic rounding formulas 262 Rounding to the nearest multiple 263 Rounding currency values 263 Working with fractional dollars 264 Using the INT and TRUNC functions 265 Rounding to an even or odd integer 266 Rounding to n significant digits 267 Solving Right Triangles 267 Area, Surface, Circumference, and Volume Calculations 270 Calculating the area and perimeter of a square 270 Calculating the area and perimeter of a rectangle 270 Calculating the area and perimeter of a circle 270 Calculating the area of a trapezoid 271 Calculating the area of a triangle 271 Calculating the surface and volume of a sphere 271 Calculating the surface and volume of a cube 271 Calculating the surface and volume of a rectangular solid 272 Calculating the surface and volume of a cone 272 Calculating the volume of a cylinder 272 Calculating the volume of a pyramid 273 Solving Simultaneous Equations 273 Working with Normal Distributions 274 Part III: Financial Formulas Chapter 11: Borrowing and Investing Formulas 279 The Time Value of Money 279 Loan Calculations 280 Worksheet functions for calculating loan information 281 A loan calculation example 284 Credit card payments 285 Creating a loan amortization schedule 287 Calculating a loan with irregular payments 288 Investment Calculations 290 Future value of a single deposit 290 Present value of a series of payments 296 Future value of a series of deposits 296 Chapter 12: Discounting and Depreciation Formulas 299 Using the NPV Function 299 Definition of NPV 300 NPV function examples 301 Using the IRR Function 306 Rate of return 307 Geometric growth rates 308 Checking results 309 Irregular Cash Flows 310 Net present value 310 Internal rate of return 311 Depreciation Calculations 312 Chapter 13: Financial Schedules 317 Creating Financial Schedules 317 Creating Amortization Schedules 318 A simple amortization schedule 318 A dynamic amortization schedule 320 Credit card calculations 323 Summarizing Loan Options Using a Data Table 325 Creating a one-way data table 325 Creating a two-way data table 327 Financial Statements and Ratios 329 Basic financial statements 329 Ratio analysis 333 Creating Indices 337 Part IV: Array Formulas Chapter 14: Introducing Arrays 341 Introducing Array Formulas 341 A multicell array formula 342 A single‐cell array formula 343 Creating an array constant 344 Array constant elements 345 Understanding the Dimensions of an Array 346 One‐dimensional horizontal arrays 346 One‐dimensional vertical arrays 347 Two‐dimensional arrays 347 Naming Array Constants 349 Working with Array Formulas 350 Entering an array formula 350 Selecting an array formula range 350 Editing an array formula 351 Expanding or contracting a multicell array formula 352 Using Multicell Array Formulas 353 Creating an array from values in a range 353 Creating an array constant from values in a range 353 Performing operations on an array 354 Using functions with an array 355 Transposing an array 355 Generating an array of consecutive integers 357 Using Single‐Cell Array Formulas 358 Counting characters in a range 358 Summing the three smallest values in a range 359 Counting text cells in a range 360 Eliminating intermediate formulas 362 Using an array in lieu of a range reference 364 Chapter 15: Performing Magic with Array Formulas 365 Working with Single‐Cell Array Formulas 365 Summing a range that contains errors 366 Counting the number of error values in a range 367 Summing the n largest values in a range 368 Computing an average that excludes zeros 368 Determining whether a particular value appears in a range 369 Counting the number of differences in two ranges 371 Returning the location of the maximum value in a range 372 Finding the row of a value’s nth occurrence in a range 373 Returning the longest text in a range 373 Determining whether a range contains valid values 374 Summing the digits of an integer 375 Summing rounded values 377 Summing every nth value in a range 377 Removing nonnumeric characters from a string 379 Determining the closest value in a range 380 Returning the last value in a column 380 Returning the last value in a row 381 Working with Multicell Array Formulas 382 Returning only positive values from a range 382 Returning nonblank cells from a range 384 Reversing the order of cells in a range 384 Sorting a range of values dynamically 385 Returning a list of unique items in a range 386 Displaying a calendar in a range 387 Part V: Miscellaneous Formula Techniques Chapter 16: Importing and Cleaning Data 393 A Few Words About Data 393 Importing Data 394 Importing from a file 394 Importing a text file into a specified range 396 Copying and pasting data 398 Data Cleanup Techniques 398 Removing duplicate rows 398 Identifying duplicate rows 400 Splitting text 401 Changing the case of text 407 Removing extra spaces 408 Removing strange characters 409 Converting values 409 Classifying values 410 Joining columns 411 Rearranging columns 412 Randomizing the rows 412 Matching text in a list 413 Change vertical data to horizontal data 414 Filling gaps in an imported report 417 Spelling checking 418 Replacing or removing text in cells 419 Adding text to cells 420 Fixing trailing minus signs 420 A Data Cleaning Checklist 421 Exporting Data 422 Exporting to a text file 422 Exporting to other file formats 423 Chapter 17: Charting Techniques 425 Understanding the SERIES Formula 425 Using names in a SERIES formula 427 Unlinking a chart series from its data range 428 Creating Links to Cells 429 Adding a chart title link 429 Adding axis title links 430 Adding text links 430 Adding a linked picture to a chart 430 Chart Examples 431 Single data point charts 431 Displaying conditional colors in a column chart 433 Creating a comparative histogram 434 Creating a Gantt chart 435 Creating a box plot 438 Plotting every nth data point 439 Identifying maximum and minimum values in a chart 441 Creating a Timeline 442 Plotting mathematical functions 443 Plotting a circle 448 Creating a clock chart 450 Creating awesome designs 452 Working with Trendlines 453 Linear trendlines 454 Working with nonlinear trendlines 460 Summary of trendline equations 461 Creating Interactive Charts 462 Selecting a series from a drop‐down list 462 Plotting the last n data points 463 Choosing a start date and number of points 464 Displaying population data 465 Displaying weather data 465 Chapter 18: Pivot Tables 469 About Pivot Tables 469 A Pivot Table Example 470 Data Appropriate for a Pivot Table 472 Creating a Pivot Table Automatically 475 Creating a Pivot Table Manually 477 Specifying the data 477 Specifying the location for the pivot table 478 Laying out the pivot table 480 Formatting the pivot table 481 Modifying the pivot table 483 More Pivot Table Examples 485 Question 1 485 Question 2 486 Question 3 487 Question 4 487 Question 5 488 Question 6 489 Question 7 490 Grouping Pivot Table Items 491 A manual grouping example 491 Viewing grouped data 493 Automatic grouping examples 494 Creating a Frequency Distribution 498 Creating a Calculated Field or Calculated Item 499 Creating a calculated field 501 Inserting a calculated item 503 Filtering Pivot Tables with Slicers 506 Filtering Pivot Tables with a Timeline 507 Referencing Cells Within a Pivot Table 508 Another Pivot Table Example 510 Using the Data Model 513 Creating Pivot Charts 516 A pivot chart example 517 More about pivot charts 519 Chapter 19: Conditional Formatting 521 About Conditional Formatting 521 Specifying Conditional Formatting 523 Formatting types you can apply 523 Making your own rules 524 Conditional Formats That Use Graphics 525 Using data bars 525 Using color scales 527 Using icon sets 530 Creating Formula-Based Rules 533 Understanding relative and absolute references 534 Conditional formatting formula examples 536 Working with Conditional Formats 543 Managing rules 544 Copying cells that contain conditional formatting 544 Deleting conditional formatting 545 Locating cells that contain conditional formatting 545 Chapter 20: Using Data Validation 547 About Data Validation 547 Specifying Validation Criteria 548 Types of Validation Criteria You Can Apply 549 Creating a Drop‐Down List 551 Using Formulas for Data Validation Rules 552 Understanding Cell References 552 Data Validation Formula Examples 554 Accepting text only 554 Accepting a larger value than the previous cell 554 Accepting nonduplicate entries only 554 Accepting text that begins with a specific character 555 Accepting dates by the day of the week 556 Accepting only values that don’t exceed a total 556 Creating a dependent list 557 Using Structured Table Referencing 558 Chapter 21: Creating Megaformulas 561 What Is a Megaformula? 561 Creating a Megaformula: A Simple Example 562 Megaformula Examples 564 Using a megaformula to remove middle names 564 Using a megaformula to return a string’s last space character position 569 Using a megaformula to determine the validity of a credit card number 573 Using Intermediate Named Formulas 578 Generating random names 579 The Pros and Cons of Megaformulas 580 Chapter 22: Tools and Methods for Debugging Formulas 581 Formula Debugging? 581 Formula Problems and Solutions 582 Mismatched parentheses 583 Cells are filled with hash marks 584 Blank cells are not blank 584 Extra space characters 585 Formulas returning an error 585 Absolute/relative reference problems 590 Operator precedence problems 591 Formulas are not calculated 592 Actual versus displayed values 592 Floating‐point number errors 593 Phantom link errors 594 Logical value errors 595 Circular reference errors 596 Excel’s Auditing Tools 596 Identifying cells of a particular type 596 Viewing formulas 597 Tracing cell relationships 598 Tracing error values 600 Fixing circular reference errors 600 Using background error checking 600 Using Excel’s Formula Evaluator 603 Part VI: Developing Custom Worksheet Functions Chapter 23: Introducing VBA 607 Fundamental Macro Concepts 607 Activating the Developer tab 608 Recording a macro 608 Understanding macro-enabled extensions 611 Macro security in Excel 611 Trusted locations 611 Storing macros in your Personal Macro Workbook 612 Assigning a macro to a button and other form controls 612 Placing a macro on the Quick Access toolbar 614 Working in the Visual Basic Editor 615 Understanding VBE components 615 Working with the Project window 616 Working with a code window 619 Customizing the VBA environment 622 Chapter 24: VBA Programming Concepts 627 A Brief Overview of the Excel Object Model 627 Understanding objects 628 Understanding collections 628 Understanding properties 629 Understanding methods 629 A brief look at variables 630 Error handling 633 Using code comments 636 An Introductory Example Function Procedure 636 Using Built-In VBA Functions 638 Controlling Execution 640 The If-Then construct 640 The Select Case construct 642 Looping blocks of instructions 643 Using Ranges 648 The For Each-Next construct 648 Referencing a range 649 Some useful properties of ranges 651 The Set keyword 655 The Intersect function 655 The Union function 656 The UsedRange property 656 Chapter 25: Function Procedure Basics 659 Why Create Custom Functions? 659 An Introductory VBA Function Example 660 About Function Procedures 662 Declaring a function 662 Choosing a name for your function 663 Using functions in formulas 664 Using function arguments 665 Using the Insert Function Dialog Box 665 Adding a function description 666 Specifying a function category 667 Adding argument descriptions 669 Testing and Debugging Your Functions 670 Using the VBA MsgBox statement 671 Using Debug.Print statements in your code 673 Calling the function from a Sub procedure 673 Setting a breakpoint in the function 676 Creating Add-Ins for Functions 676 Chapter 26: VBA Custom Function Examples 679 Simple Functions 679 Is the cell hidden? 680 Returning a worksheet name 680 Returning a workbook name 681 Returning the application’s name 681 Returning Excel’s version number 682 Returning cell formatting information 682 Determining a Cell’s Data Type 684 A Multifunctional Function 685 Generating Random Numbers 688 Generating random numbers that don’t change 688 Selecting a cell at random 690 Calculating Sales Commissions 691 A function for a simple commission structure 691 A function for a more complex commission structure 692 Text Manipulation Functions 693 Reversing a string 694 Scrambling text 694 Returning an acronym 695 Does the text match a pattern? 695 Does a cell contain a particular word? 696 Does a cell contain text? 698 Extracting the nth element from a string 698 Spelling out a number 699 Counting Functions 700 Counting pattern-matched cells 700 Counting sheets in a workbook 700 Counting words in a range 701 Date Functions 701 Calculating the next Monday 702 Calculating the next day of the week 702 Which week of the month? 703 Working with dates before 1900 703 Returning the Last Nonempty Cell in a Column or Row 704 The LASTINCOLUMN function 705 The LASTINROW function 705 Multisheet Functions 706 Returning the maximum value across all worksheets 706 The SHEETOFFSET function 708 Advanced Function Techniques 709 Returning an error value 709 Returning an array from a function 710 Returning an array of nonduplicated random integers 712 Randomizing a range 714 Using optional arguments 716 Using an indefinite number of arguments 717 Part VII: Appendixes Appendix A: Excel Function Reference 725 Appendix B: Using Custom Number Formats 743 Index 763

Read more less

Book SynopsisThe bestselling beginner's guide to Microsoft Word Written by the author of the first-ever For Dummies book, Dan Gookin, this new edition of Word For Dummies quickly and painlessly gets you up to speed on mastering the world's number-one word processing software.Table of ContentsIntroduction 1 About This Book 1 How to Use This Book 2 Foolish Assumptions 3 What’s Not Here 3 Icons Used in This Book 4 Where to Go from Here 4 Part I: Your Introduction to Word 5 Chapter 1: Hello, Word! 7 Start Your Word Day 7 Starting Word the traditional way 8 Starting Word the best way 8 Opening a document to start Word 9 Behold the Word Program 10 Working the Word Start screen 10 Examining Word’s main screen 11 Working the Ribbon 12 Showing and hiding the Ribbon 13 Changing the document view 14 Making text larger or smaller 15 End Your Word‐Processing Day 16 Quitting Word 16 Closing a document without quitting Word 17 Setting Word aside 18 Chapter 2: The Typing Chapter 19 Input Devices Galore 19 Using the PC keyboard 19 Understanding the mouse pointer 21 Keyboard Dos and Don’ts 21 Following the insertion pointer 22 Whacking the spacebar 22 Backing up and erasing 23 Pressing the Enter key 23 Stuff That Happens While You Type 23 Watching the status bar 24 Observing page breaks 24 Working collapsible headers 25 Dealing with spots and clutter in the text 25 Understanding colorful underlines 26 Part II: Your Basic Word 27 Chapter 3: To and Fro in a Document 29 Document Scrolling 29 Working the vertical scroll bar 29 Using the horizontal scroll bar 31 Scrolling with the mouse wheel 31 Move the Insertion Pointer 31 Commanding the insertion pointer 32 Moving in small increments 32 Moving from beginning to end 33 Go Back to Where You Once Edited 34 Go to Wherever with the Go To Command 34 Chapter 4: Text Editing 37 Remove Text You Don’t Want 37 Deleting single characters 38 Deleting a word 38 Deleting more than a word 39 Split and Join Paragraphs 41 Making two paragraphs from one 41 Making one paragraph from two 41 Soft and Hard Returns 42 Undo Mistakes with Undo Haste 43 Undoing the Undo command with Redo 44 Using the Repeat command 44 Chapter 5: Search for This, Replace It with That 45 Text Happily Found 45 Finding a tidbit o’ text 46 Scouring your document with Advanced Find 47 Finding stuff you can’t type 49 Replace Found Text 51 Replacing one thing with another 51 Replacing it all at once 53 Finding and replacing formatting 53 Chapter 6: Blocks o’ Text 55 Meet Mr Block 55 Mark a Block of Text 57 Using the keyboard to select text 57 Marking a block with the mouse 58 Using the F8 key to mark a block 59 Blocking the whole dang‐doodle document 60 Deselecting a block 61 Manipulate the Block of Text 61 Copying a block 62 Moving a block 62 Setting the pasted text format 63 Copying or moving a block with the mouse 64 Viewing the Clipboard 65 Chapter 7: Spell It Write 67 Check Your Spelling 67 Fixing a misspelled word 68 Dealing with incorrectly flagged words 69 AutoCorrect in Action 70 Undoing an AutoCorrect correction 70 Adjusting AutoCorrect settings 71 Grammar Be Good 72 All‐at‐Once Document Proofing 73 Spell Check and Grammar Settings 74 Undoing the Ignore All command 74 Customizing the custom dictionary 75 Disabling automatic spell check 76 Curtailing grammar checking 76 Chapter 8: Documents New, Saved, Opened, and Closed 77 Some Terms to Get Out of the Way 77 Behold! A New Document 78 Save Your Stuff! 79 Saving a document the first time 79 Dealing with document‐save errors 81 Saving or updating a document 82 Forgetting to save before you quit 83 Open a Document 84 Using the Open command 84 Opening one document inside another 86 Close a Document 87 Recover a Draft 87 Chapter 9: Publish Your Document 89 Your Document on Paper 89 Previewing before printing 90 Printing the whole document 91 Printing a specific page 92 Printing a range of pages 93 Printing on both sides of the page 94 Printing odd and even pages 94 Printing a block 95 Printing more than one copy of something 96 Choosing another printer 96 Canceling a print job 97 Electronically Publishing Your Document 97 Preparing a document for sharing 98 Sending a Word document via email 98 Making a PDF 99 Exporting your document 100 Part III: Fun with Formatting 101 Chapter 10: Character Formatting 103 Text‐Formatting Techniques 103 Basic Text Formats 104 Choosing a font 105 Applying character formats 106 Text Transcending Teensy to Titanic 107 Setting the text size 108 Nudging text size 108 More Colorful Text 109 Coloring the text 109 Shading the background 110 Change Text Case 111 Clear Character Formatting 112 Behold the Font Dialog Box 112 Chapter 11: Paragraph Formatting 115 Paragraph‐Formatting Rules and Regulations 115 Formatting a paragraph 116 Locating the paragraph‐formatting commands 116 Justification and Alignment 118 Line up on the left! 118 Everyone center! 118 Line up on the right! 119 Line up on both sides! 119 Make Room Before, After, or Inside Paragraphs 119 Setting the line spacing 120 Making space between paragraphs 121 Paragraph Indentation Madness 122 Indenting the first line of a paragraph 122 Making a hanging indent (an outdent) 123 Indenting a whole paragraph 124 Using the ruler to adjust indents 124 Chapter 12: Tab Formatting 127 Once Upon a Tab 127 Seeing tab characters 128 Seeing tab stops 129 Using the ruler to set tab stops 130 Using the Tabs dialog box to set tabs 130 The Standard Left Tab Stop 132 Creating a basic tabbed list 132 Creating a two‐tab paragraph thing 133 The Center Tab Stop 135 The Right Tab Stop 136 Making a right‐stop, left‐stop list 136 Building a two‐column right‐stop list 138 The Decimal Tab 139 The Bar Tab 140 Fearless Leader Tabs 141 Tab Stop, Be Gone! 142 Chapter 13: Page Formatting 143 Describe That Page 143 Setting page size 143 Changing orientation (landscape or portrait) 144 Setting the page margins 145 Using the Page Setup dialog box 146 Page Numbering 148 Adding an automatic page number 148 Starting with a different page number 149 Numbering with Roman numerals 150 Removing page numbers 151 New Pages from Nowhere 151 Starting text on a new page 152 Inserting a blank page 152 Page Background Froufrou 153 Coloring pages 153 Printing colored pages 154 Adding a watermark 154 Chapter 14: More Page Formatting 157 Slice Your Document into Sections 157 Understanding sections 158 Creating a section 159 Using sections 160 Deleting a section break 160 That First Page 161 Adding a cover page 162 Inserting a cover page manually 162 Headers and Footers 163 Using a preset header or footer 164 Creating a custom header or footer 164 Working with multiple headers and footers 167 Removing a header or a footer 169 Chapter 15: Style Formatting 171 The Big Style Overview 171 Finding the styles 172 Using a style 173 Discovering the current style 174 Removing style formatting 175 Make Your Own Styles 176 Creating a style 176 Using the Create New Style from Formatting dialog box 177 Modifying a style 178 Assigning a shortcut key to your style 179 Deleting a style 180 Style Tips and Tricks 181 Updating the Normal style 181 Creating heading styles 182 Customizing the Style Gallery 182 Chapter 16: Template and Themes Formatting 183 Instant Documents with Templates 183 Starting a new document by using a template 184 Changing a document’s associated template 186 Templates of Your Own 187 Creating a template based on a document you already have 187 Making a new template from scratch 188 Modifying a template 188 The Theme of Things 189 Applying a document theme 190 Modifying or creating a theme 190 Chapter 17: Sundry Formatting 191 Weird and Fun Text Effects 191 Steal This Format! 193 Automatic Formatting 194 Enjoying automagical text 194 Formatting tricks for paragraphs 196 Undoing an AutoFormat 198 Center a Page, Top to Bottom 198 Part IV: Spruce Up a Dull Document 201 Chapter 18: Borders and Lines 203 The Basics of Borders 203 Putting borders around a paragraph 205 Drawing a thick line between paragraphs 206 Boxing multiple paragraphs 206 Removing borders 207 The Borders and Shading Dialog Box 207 Creating a fancy title 208 Boxing text 209 Applying a page border 209 Chapter 19: Able Tables 211 Put a Table in Your Document 211 Working with tables in Word 212 Creating a table 213 Un-creating a table 216 Deleting a table 217 Text in Tables 217 Typing text in a table 217 Selecting in a table 218 Aligning text in a cell 218 Table Modification 219 Adding or removing rows or columns 220 Adjusting row and column size 220 Merging cells 221 Splitting cells 221 Making the table pretty 222 Adding a table caption 222 Chapter 20: Columns of Text 225 All about Columns 225 Making two-column text 227 Building a trifold brochure 227 Giving up on columns 228 Column Termination 229 Changing column formats 229 Placing a column break 230 Chapter 21: Lots of Lists 233 Lists with Bullets and Numbers 233 Making a bulleted list 234 Numbering a list 234 Creating a multilevel numbered list 235 Numbering lines on a page 235 Document Content Lists 236 Creating a table of contents 236 Building an index 237 Adding a list of figures 239 Footnotes and Endnotes 239 Chapter 22: Here Come the Graphics 241 Graphical Goobers in Your Text 241 Copying and pasting an image 243 Plopping down a picture 243 Stealing images from the Internet 244 Slapping down a shape 244 Sticking things into a shape 245 Using WordArt 246 Adding a caption 246 Image Layout 247 Wrapping text around an image 249 Floating an image 249 Keeping an image with text 250 Image Editing 250 Resizing an image 250 Cropping an image 251 Rotating an image 251 Changing an image’s appearance 252 Image Arrangement 252 Moving an image hither and thither 252 Aligning graphics 253 Shuffling images front or back 253 Grouping images 254 Chapter 23: Insert Tab Insanity 255 Characters Foreign and Funky 255 Nonbreaking spaces and hyphens 255 Typing characters such as Ü, Ç, and Ñ 256 Inserting special characters and symbols 257 Spice Up Your Document with a Text Box 258 Fun with Fields 259 Understanding fields 260 Adding some useful fields 261 Updating a field 262 Changing a field 262 Deleting fields 263 The Date and Time 263 Adding the current date or time 264 Using the PrintDate field 264 Part V: The Rest of Word 265 Chapter 24: Multiple Documents, Windows, and File Formats 267 Multiple Document Mania 267 Arranging open document windows 268 Comparing two documents side by side 269 Viewing one document in multiple windows 269 Using the old split‐screen trick 270 Many, Many Document Types 271 Understanding document formats 271 Opening a non‐Word document 272 Updating an older Word document 274 Chapter 25: Word for Writers 275 Organize Your Thoughts 275 Entering Outline view 276 Typing topics in the outline 277 Rearranging topics 278 Demoting and promoting topics 278 Expanding and collapsing topics 279 Adding a text topic 281 Printing an outline 281 Large Documents 282 Creating a master document 282 Splitting a document 284 Dan’s Writing Tips 285 Choosing the best word 285 Counting every word 285 Writing for writers 286 Chapter 26: Let’s Work This Out 287 Comments on Your Text 287 Adding a comment 288 Displaying or hiding comments 288 Reviewing comments one at a time 289 Printing comments (or not) 290 Deleting comments 291 The Yellow Highlighter 291 Look What They’ve Done to My Text, Ma 292 Comparing two versions of a document 292 Tracking changes as they’re made 294 Reviewing changes 294 Collaborate on the Internet 295 Sharing a document 296 Checking updates 296 Chapter 27: Mail Merge Mania 297 About Mail Merge 297 Understanding Word’s mail merge jargon 298 Reviewing the mail merge process 299 Using the Mail Merge Wizard 300 I The Main Document 300 Creating a mail merge form letter 300 Creating mail merge email messages 302 Creating mail merge envelopes 302 II The Recipient List 303 Building a new recipient list 303 Using an already created recipient list 307 Grabbing a recipient list from Outlook 308 Editing a recipient list 308 III Fold in the Fields 309 IV Preview the Merged Documents 310 V Mail Merge Ho! 311 Merging to a new set of documents 311 Merging to the printer 311 Merging to email 312 Chapter 28: Labels and Envelopes 313 Labels Everywhere 313 Printing sheets of identical labels 314 Printing an address list 315 Instant Envelope 317 Chapter 29: A More Custom Word 321 A Better Status Bar 321 The Quick Access Toolbar 323 Adding buttons to the Quick Access toolbar 324 Editing the Quick Access toolbar 324 Removing items from the Quick Access toolbar 326 Customize the Ribbon 326 Part VI: The Part of Tens 329 Chapter 30: The Ten Commandments of Word 331 Thou Shalt Remember to Save Thy Work 331 Thou Shalt Not Use Spaces Unnecessarily 332 Thou Shalt Not Abuse the Enter Key 332 Thou Shalt Not Neglect Keyboard Shortcuts 332 Thou Shalt Not Manually Number Thy Pages 333 Thou Shalt Not Force a New Page 333 Thou Shalt Not Forget Thy Undo Command 333 Honor Thy Printer 333 Thou Shalt Have Multiple Document Windows Before Thee 334 Neglecteth Not Windows 334 Chapter 31: Ten Cool Tricks 335 Automatic Save with AutoRecover 335 Accelerate the Ribbon 336 Ancient Word Keyboard Shortcuts 337 Build Your Own Fractions 337 Electronic Bookmarks 338 Lock Your Document 339 The Drop Cap 339 Map Your Document 340 Sort Your Text 341 Map Ctrl+F to the Advanced Find Command 342 Chapter 32: Ten Bizarre Things 343 Equations 343 Video in Your Document 344 Hidden Text 344 The Developer Tab 345 Hyphenation 345 Document Properties 346 Cross‐References 346 Collect and Paste 346 Click‐and‐Type 347 Word and the Internet 347 Chapter 33: Ten Automatic Features Worthy of Deactivation 349 Bye-Bye Start Screen 349 Restore the Traditional Open and Save Dialog Boxes 350 Turn Off the Mini Toolbar 350 Select Text by Letter 351 Disable Click‐and‐Type 352 Paste Plain Text Only 352 Disable AutoFormat Features (×4) 353 Index 355

Read more less

Book SynopsisThe fast and easy way to get things done with Office Perplexed by PowerPoint? Looking to excel at Excel? From Access to Word and every application in between this all-encompassing guide provides plain-English guidance on mastering the entire Microsoft Office suite.Table of ContentsIntroduction 1 About This Book 1 Foolish Assumptions 2 Icons Used in This Book 2 Beyond the Book 3 Where to Go from Here 4 Book I: Common Office Tasks 5 Chapter 1: Office Nuts and Bolts 7 Chapter 2: Wrestling with the Text 25 Chapter 3: Speed Techniques Worth Knowing About 43 Book II: Word 2016 51 Chapter 1: Speed Techniques for Using Word 53 Chapter 2: Laying Out Text and Pages 71 Chapter 3: Word Styles 95 Chapter 4: Constructing the Perfect Table 111 Chapter 5: Taking Advantage of the Proofing Tools 133 Chapter 6: Desktop Publishing with Word 153 Chapter 7: Getting Word’s Help with Office Chores 171 Chapter 8: Tools for Reports and Scholarly Papers 191 Book III: Excel 2016 213 Chapter 1: Up and Running with Excel 215 Chapter 2: Refining Your Worksheet 233 Chapter 3: Formulas and Functions for Crunching Numbers 247 Chapter 4: Making a Worksheet Easier to Read and Understand 279 Chapter 5: Advanced Techniques for Analyzing Data 297 Book IV: PowerPoint 2016 313 Chapter 1: Getting Started in PowerPoint 315 Chapter 2: Fashioning a Look for Your Presentation 337 Chapter 3: Entering the Text 351 Chapter 4: Making Your Presentations Livelier 367 Chapter 5: Delivering a Presentation 383 Book V: OneNote 2016 405 Chapter 1: Up and Running with OneNote 407 Chapter 2: Taking Notes 419 Chapter 3: Finding and Organizing Your Notes 435 Book VI: Outlook 2016 443 Chapter 1: Outlook Basics 445 Chapter 2: Maintaining the Contacts Folder 459Chapter 3: Handling Your Email 469 Chapter 4: Managing Your Time and Schedule 491 Chapter 5: Tasks, Reminders, and Notes 499 Book VII: Access 2016 507 Chapter 1: Introducing Access 509 Chapter 2: Building Your Database Tables 523 Chapter 3: Entering the Data 551 Chapter 4: Sorting, Querying, and Filtering for Data 561 Chapter 5: Presenting Data in a Report 581 Book VIII: Working with Charts and Graphics 587 Chapter 1: Creating a Chart 589 Chapter 2: Making a SmartArt Diagram 607 Chapter 3: Handling Graphics and Photos 625 Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 641 Book IX: Office 2016 — One Step Beyond 669 Chapter 1: Customizing an Office Program 671 Chapter 2: Ways of Distributing Your Work 685 Chapter 3: Working with Publisher 695 Book X: File Sharing and Collaborating 711 Chapter 1: Up and Running on OneDrive 713 Chapter 2: File Sharing and Collaborating 723 Index 731

Read more less

Book SynopsisThe bestselling book on Photoshop Elementsnow in a new edition Getting great photos is easier than you thinkit just takes some know-how and a tool like Adobe''s Photoshop Elements. Photoshop Elements 14 For Dummies is a fun and easy-to-follow guide for photographers and photo enthusiasts who want to make their snapshots picture perfect. In no time, you''ll tackle the basics of Photoshop Elements and find out how to execute hundreds of tasks, like using special effects and drawing tools, working with layers, improving your color and clarity, and so much more. Photoshop Elements is the #1 selling consumer photo editing software, and Adobe continues to add innovative features that allow professional and self-made digital photographers to do it all. Written by veteran authors Barb Obermeier and Ted Padova, this full-color guide shows you how to make the most of the latest version of the software in a fun and friendly way that makes learning feel like play. Even if you hTable of ContentsIntroduction 1 Part I: Getting Started with Photoshop Elements 14 5 Chapter 1: Getting Started with Image Editing 7 Chapter 2: Basic Image‐Editing Concepts 23 Chapter 3: Exploring the Photo Editor 49 Part II: Managing Media 73 Chapter 4: Navigating the Organizer 75 Chapter 5: Organizing Your Pictures 91 Chapter 6: Viewing and Finding Your Images 115 Part III: Selecting and Correcting Photos 131 Chapter 7: Making and Modifying Selections 133 Chapter 8: Working with Layers 163 Chapter 9: Simple Image Makeovers 185 Chapter 10: Correcting Contrast, Color, and Clarity 219 Part IV: Exploring Your Inner Artist 251 Chapter 11: Playing with Filters, Effects, Styles, and More 253 Chapter 12: Drawing and Painting 289 Chapter 13: Working with Type 315 Part V: Printing, Creating, and Sharing 335 Chapter 14: Getting It on Paper 337 Chapter 15: Sharing Your Work 353 Chapter 16: Making Creations 365 Part VI: The Part of Tens 373 Chapter 17: Ten Tips for Composing Better Photos 375 Chapter 18: Ten (Or So) More Project Ideas 381 Index 387

Read more less

Book SynopsisIntegrate big data into business to drive competitive advantage and sustainable success Big Data MBA brings insight and expertise to leveraging big data in business so you can harness the power of analytics and gain a true business advantage. Based on a practical framework with supporting methodology and hands-on exercises, this book helps identify where and how big data can help you transform your business. You''ll learn how to exploit new sources of customer, product, and operational data, coupled with advanced analytics and data science, to optimize key processes, uncover monetization opportunities, and create new sources of competitive differentiation. The discussion includes guidelines for operationalizing analytics, optimal organizational structure, and using analytic insights throughout your organization''s user experience to customers and front-end employees alike. You''ll learn to think like a data scientist as you build upon the decisions your businessTable of ContentsIntroduction xxiii Part I Business Potential of Big Data Chapter 1 Chapter 1 The Big Data Business Mandate 3 Big Data MBA Introduction 4 Focus Big Data on Driving Competitive Differentiation 6 Leveraging Technology to Power Competitive Differentiation 7 History Lesson on Economic-Driven Business Transformation 7 Critical Importance of “Thinking Differently” 10 Don’t Think Big Data Technology, Think Business Transformation 10 Don’t Think Business Intelligence, Think Data Science 11 Don’t Think Data Warehouse, Think Data Lake 11 Don’t Think “What Happened,” Think “What Will Happen” 12 Don’t Think HIPPO, Think Collaboration 14 Summary 14 Homework Assignment 15 Chapter 2 Big Data Business Model Maturity Index 17 Introducing the Big Data Business Model Maturity Index 18 Phase 1: Business Monitoring 20 Phase 2: Business Insights 21 Phase 3: Business Optimization 25 Phase 4: Data Monetization 27 Phase 5: Business Metamorphosis 28 Big Data Business Model Maturity Index Lessons Learned 30 Lesson 1: Focus Initial Big Data Efforts Internally 30 Lesson 2: Leverage Insights to Create New Monetization Opportunities 31 Lesson 3: Preparing for Organizational Transformation 32 Summary 33 Homework Assignment 34 Chapter 3 The Big Data Strategy Document 35 Establishing Common Business Terminology 37 Introducing the Big Data Strategy Document 37 Identifying the Organization’s Key Business Initiatives 39 What’s Important to Chipotle? 40 Identify Key Business Entities and Key Decisions 41 Identify Financial Drivers (Use Cases) 45 Identify and Prioritize Data Sources 48 Introducing the Prioritization Matrix 51 Using the Big Data Strategy Document to Win the World Series 52 Summary 57 Homework Assignment 58 Chapter 4 The Importance of the User Experience 61 The Unintelligent User Experience 62 Capture the Key Decisions 63 Support the User Decisions 63 Consumer Case Study: Improve Customer Engagement 64 Business Case Study: Enable Frontline Employees 66 Store Manager Dashboard 67 Sample Use Case: Competitive Analysis 69 Additional Use Cases 70 B2B Case Study: Make the Channel More Effective 71 The Advisors Are Your Partners—Make Them Successful 72 Financial Advisor Case Study 72 Informational Sections of Financial Advisor Dashboard 74 Recommendations Section of Financial Advisor Dashboard 77 Summary 80 Homework Assignment 81 Part II Data Science 83 Chapter 5 Differences Between Business Intelligence and Data Science 85 What Is Data Science? 86 BI Versus Data Science: The Questions Are Different 87 BI Questions 88 Data Science Questions 88 The Analyst Characteristics Are Different 89 The Analytic Approaches Are Different 91 Business Intelligence Analyst Engagement Process 91 The Data Scientist Engagement Process 93 The Data Models Are Different 96 Data Modeling for BI 96 Data Modeling for Data Science 98 The View of the Business Is Different 100 Summary 104 Homework Assignment 104 Chapter 6 Data Science 101 107 Data Science Case Study Setup 107 Fundamental Exploratory Analytics 110 Trend Analysis 110 Boxplots 112 Geographical (Spatial) Analysis 113 Pairs Plot 114 Time Series Decomposition 115 Analytic Algorithms and Models 116 Cluster Analysis 116 Normal Curve Equivalent (NCE) Analysis 117 Association Analysis 119 Graph Analysis 121 Text Mining 122 Sentiment Analysis 123 Traverse Pattern Analysis 124 Decision Tree Classifier Analysis 125 Cohorts Analysis 126 Summary 128 Homework Assignment 131 Chapter 7 The Data Lake 133 Introduction to the Data Lake 134 Characteristics of a Business-Ready Data Lake 136 Using the Data Lake to Cross the Analytics Chasm 137 Modernize Your Data and Analytics Environment 140 Action #1: Create a Hadoop-Based Data Lake 140 Action #2: Introduce the Analytics Sandbox 141 Action #3: Off-Load ETL Processes from Data Warehouses 142 Analytics Hub and Spoke Analytics Architecture 143 Early Learnings 145 Lesson #1: The Name Is Not Important 145 Lesson #2: It’s Data Lake, Not Data Lakes 146 Lesson #3: Data Governance Is a Life Cycle, Not a Project 147 Lesson #4: Data Lake Sits Before Your Data Warehouse, Not After It 148 What Does the Future Hold? 149 Summary 150 Homework Assignment 151 Part III Data Science for Business Stakeholders 153 Chapter 8 Thinking Like a Data Scientist 155 The Process of Thinking Like a Data Scientist 157 Step 1: Identify Key Business Initiative 157 Step 2: Develop Business Stakeholder Personas 158 Step 3: Identify Strategic Nouns 160 Step 4: Capture Business Decisions 161 Step 5: Brainstorm Business Questions 162 Step 8: Putting Analytics into Action 166 Summary 168 Homework Assignment 169 Chapter 9 “By” Analysis Technique 171 “By” Analysis Introduction 172 “By” Analysis Exercise 174 Foot Locker Use Case “By” Analysis 178 Summary 181 Homework Assignment 182 Chapter 10 Score Development Technique 183 Definition of a Score 184 FICO Score Example 185 Other Industry Score Examples 188 LeBron James Exercise Continued 189 Foot Locker Example Continued 193 Summary 197 Homework Assignment 197 Chapter 11 Monetization Exercise 199 Fitness Tracker Monetization Example 200 Step 1: Understand Product Usage 200 Step 2: Develop Stakeholder Personas 201 Step 3: Brainstorm Potential Recommendations 203 Step 4: Identify Supporting Data Sources 204 Step 5: Prioritize Monetization Opportunities 206 Step 6: Develop Monetization Plan 208 Summary 209 Homework Assignment 210 Chapter 12 Metamorphosis Exercise 211 Business Metamorphosis Review 212 Business Metamorphosis Exercise 213 Articulate the Business Metamorphosis Vision 214 Understand Your Customers 215 Articulate Value Propositions 215 Define Data and Analytic Requirements 216 Business Metamorphosis in Health Care 223 Summary 226 Homework Assignment 227 Part IV Building Cross-organizational Support 229 Chapter 13 Power of Envisioning 231 Envisioning: Fueling Creative Thinking 232 Big Data Vision Workshop Process 232 Pre-engagement Research 233 Business Stakeholder Interviews 234 Explore with Data Science 235 Workshop 236 Setting Up the Workshop 239 The Prioritization Matrix 241 Summary 243 Homework Assignment 244 Chapter 14 Organizational Ramifications 245 Chief Data Monetization Officer 245 CDMO Responsibilities 246 CDMO Organization 246 Analytics Center of Excellence 247 CDMO Leadership 248 Privacy, Trust, and Decision Governance 248 Privacy Issues = Trust Issues 249 Decision Governance 250 Unleashing Organizational Creativity 251 Summary 253 Homework Assignment 254 Chapter 15 Stories 255 Customer and Employee Analytics 257 Product and Device Analytics 261 Network and Operational Analytics 263 Characteristics of a Good Business Story 265 Summary 266 Homework Assignment 267 Index 269

Read more less

Book SynopsisThe easy way to take control of project timelines, resources, budgets, and details Project manager, meet your new assistant! Once you discover Project 2016 you'll be amazed at how efficient and effective the project management process can be.Table of ContentsIntroduction 1 Part I: Getting Started with Project 2016 5 Chapter 1: Project Management, Project 2016, and You 7 Chapter 2: Starting the Project 19 Chapter 3: Becoming a Task Master 39 Chapter 4: The Codependent Nature of Tasks 53 Chapter 5: Estimating Task Time 65 Chapter 6: Check Out This View! 81 Part II: Managing Resources 101 Chapter 7: Creating Resources 103 Chapter 8: Working with Calendars 119 Chapter 9: Assigning Resources 133 Chapter 10: Determining a Project’s Cost 145 Part III: Before You Baseline 155 Chapter 11: Fine‐Tuning Your Plan 157 Chapter 12: Negotiating Project Constraints 171 Chapter 13: Making the Project Look Good 185 Chapter 14: It All Begins with a Baseline 201 Part IV: Staying on Track 211 Chapter 15: On the Right Track 213 Chapter 16: Project Views: Observing Progress 237 Chapter 17: You’re Behind — Now What? 251 Chapter 18: Spreading the News: Reporting 267 Chapter 19: Getting Better All the Time 289 Part V: The Part of Tens 299 Chapter 20: Ten Golden Rules of Project Management 301 Chapter 21: Ten Cool Shortcuts in Project 2016 309 Appendix: Glossary 315 Index 325

Read more less

Book SynopsisExcel at predicting sales and forecasting trends using Microsoft Excel! If you''re a sales or marketing professional, you know that forecasting sales is one of the biggest challenges you face on the job. Unlike other books on the subject, Excel Sales Forecasting For Dummies, 2nd Edition leaves arcane business school terms and complex algebraic equations at the door, focusing instead on what you can do right now to utilize the world''s most popular spreadsheet program to produce forecasts you can rely on. Loaded with confidence boosters for anyone who succumbs to sweaty palms when sales predictions are mentioned, this trusted guide show you how to use the many tools Excel provides to arrange your past data, set up lists and pivot tables, use moving averages, and so much more. Before you know it, you''ll become a forecaster par excellenceeven if numbers aren''t your jam. Choose the right forecasting method Find relationships in your dataTable of ContentsIntroduction 1 Part 1: Understanding Sales Forecasting and How Excel Can Help 5 Chapter 1: A Forecasting Overview 7 Chapter 2: Forecasting: The Basic Issues 23 Chapter 3: Understanding Baselines 41 Chapter 4: Predicting the Future: Why Forecasting Works 53 Part 2: Organizing the Data 69 Chapter 5: Choosing Your Data: How to Get a Good Baseline 71 Chapter 6: Setting Up Tables in Excel 87 Chapter 7: Working with Tables in Excel 103 Part 3: Making a Basic Forecast 119 Chapter 8: Summarizing Sales Data with Pivot Tables 121 Chapter 9: Charting Your Baseline: It’s a Good Idea 141 Chapter 10: Forecasting with Excel’s Data Analysis Add-in 159 Chapter 11: Basing Forecasts on Regression 173 Part 4: Making Advanced Forecasts 189 Chapter 12: Entering the Formulas Yourself 191 Chapter 13: Using Moving Averages 219 Chapter 14: Changing Horses: From Moving Averages to Smoothing 237 Chapter 15: Smoothing: How You Profit from Your Mistakes 259 Chapter 16: Fine-Tuning a Regression Forecast 285 Chapter 17: Managing Trends 311 Chapter 18: Same Time Last Year: Forecasting Seasonal Sales 329 Part 5: The Part of Tens 349 Chapter 19: Ten Fun Facts to Know and Tell about Array Formulas 351 Chapter 20: The Ten Best Excel Tools 363 Index 373

Read more less

Book SynopsisOffice 2016 For Dummies (9781119293477) was previously published as Office 2016 For Dummies (9781119077374). While this version features a new Dummies cover and design, the content is the same as the prior release and should not be considered a new or updated product.Table of ContentsIntroduction 1 Part 1: Getting Started with Office 2016 5 Chapter 1: Introducing Microsoft Office 2016 7 Chapter 2: Selecting and Editing Data 35 Chapter 3: Modifying Pictures 51 Chapter 4: Getting Help from Office 2016 65 Part 2: Working with Word 73 Chapter 5: Typing Text in Word 75 Chapter 6: Formatting Text 99 Chapter 7: Designing Your Pages 121 Part 3: Playing the Numbers with Excel 153 Chapter 8: The Basics of Spreadsheets: Numbers, Labels, and Formulas 155 Chapter 9: Playing with Formulas 193 Chapter 10: Charting and Analyzing Data 225 Part 4: Making Presentations with PowerPoint 255 Chapter 11: Creating a PowerPoint Presentation 257 Chapter 12: Adding Color and Pictures to a Presentation 275 Chapter 13: Showing Off a Presentation 297 Part 5: Getting Organized with Outlook 321 Chapter 14: Managing Email with Outlook 323 Chapter 15: Calendars, Contacts, and Tasks 341 Part 6: Storing Stuff in Access 357 Chapter 16: Using a Database 359 Chapter 17: Searching, Sorting, and Querying a Database 377 Chapter 18: Creating a Database Report 399 Part 7: The Part of Tens 415 Chapter 19: Ten Tips for Using Office 2016 417 Chapter 20: Almost Ten Ways to Make Office 2016 Easier to Use 431 Index 437

Read more less

Book SynopsisAchieve best-in-class metrics and get more from your data with JMP JMP Connections is the small- and medium-sized business owner''s guide to exceeding customer expectations by getting more out of your data using JMP. Uniquely bifunctional, this book is divided into two parts: the first half of the book shows you what JMP can do for you. You''ll discover how to wring every last drop of insight out of your data, and let JMP parse reams of raw numbers into actionable insight that leads to better strategic decisions. You''ll also discover why it works so well; clear explanations break down the Connectivity platform and metrics in business terms to demystify data analysis and JMP while giving you a macro view of the benefits that come from optimal implementation. The second half of the book is for your technical team, demonstrating how to implement specific solutions relating to data set development and data virtualization. In the end, your organizationTable of ContentsPreface xv Chapter 1 Generalized Context for Decision Process Improvement 1 1.1 Situational Assessment (Current State) 3 1.2 Problem Statement 11 1.3 Visualizing State Transition 15 1.4 Metrics On-Demand 20 Chapter 2 Real-Time Metrics Business Case 25 2.1 Project Description and Objectives—A Case Study 27 2.2 Solution Description 31 2.3 Cost and Benefit Analysis 34 2.4 Financial Assessment 37 2.5 Implementation Timeline 42 2.5.1 Contemplating Startup 42 2.5.2 Skills Dependencies and Timeline Consideration 44 2.5.3 Implementation Starting Point 46 2.5.4 Implementation to Deployment 49 2.6 Critical Assumptions and Risk Assessment 50 2.6.1 Critical Assumptions 50 2.6.2 Risk Assessment 51 2.7 Recommendations: Transmigrate the Enterprise 58 Chapter 3 Technical Details and Practical Implementation 63 3.1 Hardware Foundations 69 3.2 Solution Stack 70 3.3 Integration of Hardware and Software Infrastructure 72 3.4 Build Out 72 3.5 The Construction of a Metric 79 3.6 Metric Case Study 80 Chapter 4 Harvesting Benefits and Extensibility 99 4.1 Benefits Example 100 4.2 Extensibility 101 4.3 Configuration Management Version Control 102 Chapter 5 So What About a Bad Economy? 107 5.1 Overachievement—Data Virtualization 110 5.2 JMP Connection as the Universal Server 114 5.3 Well-Formed Data 117 5.4 Linked Data 120 Chapter 6 Decision Streams 133 Chapter 7 Delivery and Presentations 139 7.1 Push Versus Pull Delivery 140 7.2 Presentation 143 7.3 DIY, But Leave the Poor Bi Person Alone! 156 7.4 Advanced Presentation Method 157 Chapter 8 In Closing (As-Built) 163 Glossary 169 Appendix A Server-Side PHP Code 173 Appendix B JMP JSL Time Constant Learning Curve Script 175 Appendix C JMP GUI User Interface Code Example 181 Appendix D Resource Description Framework File Example 185 Appendix E Sample Hardware Requirements 191 Appendix F Early Warning Deliverable 193 Appendix G JMP PRO Connections: The Transversality of the Capability Maturity Model 203 G.1 Tangential Concept 204 G.2 Transversal Concept 205 G.3 Univariate to Multivariate Process Control 206 G.4 JMP Process Screening 208 G.5 Transversal Maturity Space in Relation to JMP PRO Features 210 G.6 Summary 212 References 213 Suggested Reading 217 Index 219

Read more less

Book SynopsisShowcases the latest trends in new virtual/augmented reality healthcare and medical applications and provides an overview of the economic, psychological, educational and organizational impacts of these new applications and how we work, teach, learn and provide care. With the current advances in technology innovation, the field of medicine and healthcare is rapidly expanding and, as a result, many different areas of human health diagnostics, treatment and care are emerging. Wireless technology is getting faster and 5G mobile technology allows the Internet of Medical Things (IoMT) to greatly improve patient care and more effectively prevent illness from developing. This book provides an overview and review of the current and anticipated changes in medicine and healthcare due to new technologies and faster communication between users and devices. The groundbreaking book presents state-of-the-art chapters on many subjects including: A review of tTable of ContentsList of Figures xiii List of Tables xix Foreword xxi Preface xxiii Acknowledgments xxix Acronyms xxxi Part I Virtual Reality, Augmented Reality Technologies and Applications for Health and Medicine 1 Reviews of the Implications of VR/AR Health Care Applications 3Muhammad Sharif, Ghulam Jillani Ansari, Mussarat Yasmin, Steven Lawrence Fernandes 1.1 Introduction 4 1.2 Virtual Reality and Augmented Reality 5 1.2.1 Virtual Realty 5 1.2.2 Augmented Reality or Mixed Reality 6 1.2.3 Line of Difference between VR/AR 6 1.2.4 Formats and Design Elements of VR/AR Technology 7 1.2.5 Presence, Reality and Realism 8 1.3 Features of VR/AR Technology in Health Care 9 1.3.1 Implications of VR/AR Technology in Health Care Services and Applications 9 1.3.2 Health Care Services 9 1.3.3 Health Care Applications 11 1.4 Future Assessments in VR/AR Technology 14 1.5 Key Challenges for Adopting VR/AR Technology 14 1.6 Conclusion 15 References 15 2 Using 3D Simulation in Medical Education: A Comparative Test of Teaching Anatomy using VR 21Chung Van Le, J.G. Tromp, Vikram Puri 2.1 Introduction 22 2.2 Literature Review of Training with Medical VR 23 2.3 Methodology of this Study 24 2.4 Results 26 2.5 Discussion 29 References 30 3 Building Empathy in Young Children using Augmented Reality: A Case Study in Malaysia 35N.Zamin, F.A.Khairuddin, D.R.A.Rambli, E.N.M.Ibrahim, M.S.A.Soobni 3.1 Introduction 36 3.2 Motivations 36 3.3 Literature Review 36 3.4 Proposed Approach 38 3.5 Results and Discussions 38 3.6 Conclusions 41 References 41 4 Effectiveness of Virtual Reality Mock Interview Training 43J. Garcia, J. Tromp, H. Seaton 4.1 Introduction 44 4.2 Virtual Reality Training Literature Review 44 4.3 Methodology 45 4.3.1 Participants 45 4.3.2 Materials 46 4.3.3 Procedure 47 4.4 Results 47 4.5 Disscussion 48 4.6 Conclusions 49 References 50 5 Augmenting Dental Care: A Current Perspective 51Anand Nayyar, Gia Nhu Nguyen 5.1 Introduction 52 5.1.1 Origin of Augmented Reality 52 5.1.2 History of Augmented Reality 53 5.2 Augmented Reality Technology in Medical Technology 53 5.3 Existing Technologies in Medical/Healthcare Technology 55 5.4 Augmenting Dental Care-AR Technologies assisting Dentists for Dental Care 55 5.4.1 Augmented Reality Technologies in Oral and Maxillofacial Surgery 56 5.4.2 Augmented Reality Technologies in Dental Implant Surgery 58 5.4.3 Augmented Reality Technologies in Orthognathic Surgery 59 5.4.4 Augmented Reality Apps in Dental Applications 61 5.5 Augmented Reality in Dental Education 61 5.6 Augmented Reality based Education Technologies for Dentistry 62 5.6.1 DentSim 62 5.6.2 The Virtual Dental Patient: System for Virtual Teeth Drilling 63 5.6.3 Mobile AR Systems for Dental Morphology Learning 64 5.6.4 Periosim 64 5.7 Conclusion 65 References 65 6 Review of Virtual Reality Evaluation Methods and Psychophysiological Measurement Tools 69M.A. Munoz, J.G. Tromp, Cai Zhushun 6.1 Science Can Help Inform Virtual Reality Development 70 6.1.1 Objectives of Evaluations 71 6.1.2 Test Oft en and Test Early 73 6.1.3 Testing Options in the Early Pre-Prototype Phase 77 6.2 Virtual Reality Can Help Inform Psychology and Science 78 6.3 Types of Psychophysiological Measures and Tools 79 6.3.1 Electrodermal Activity 79 6.3.2 Cardiovascular activity 79 6.3.3 Muscular Activity: Facial Expressions 80 6.3.4 Electrical brain activity: Electroencephalography 81 6.4 Outcome of the Evaluation 82 6.5 Conclusions 83 References 83 Part II Artificial Intelligence Technologies and Applications for Health and Medicine 7 AI Technologies for Mobile Health of Stroke Monitoring & Rehabilitation Robotics Control 89B.M. Elbagoury, M.B.H.B. Shalhoub, M.I. Roushdy, Thomas Schrader 7.1 Introduction 90 7.2 Research Chapter Objectives 92 7.3 Literature Review 92 7.3.1 Pervasive Computing and Mobile Health Technologies 92 7.3.2 Rehabilitation Robotics for Stroke Patients 93 7.4 Description of the Research Telemedicine Platform 94 7.4.1 A State of the Art Telemedicine Robot Rehabilitation System 94 7.4.2 Wireless telemedicine module with robot 96 7.4.3 Wireless intelligence sensor network extract user’s biofeedback signal 96 7.5 A proposed intelligent adaptive behavior control to rehabilitation robotics 96 7.6 Materials and Methods 98 7.7 Conclusion Summary: Artificial Intelligence Technologies 98 References 100 8 Artificial Intelligence for Smart Cancer Diagnosis 103M.H.B. Shalhoub, Naif M. Hassan Bin Shalhoub, Bassant M. Elbagoury, Abdel-Badeeh M. Salem 8.1 Introduction 104 8.2 Background and Related work 105 8.2.1 De-noising methods 105 8.2.2 Image Segmentation Overview 106 8.3 Proposed System Architecture 107 8.4 Telemedicine System Modules 109 8.4.1 Image Compression 109 8.4.2 Image Enhancement and Region of Interest Segmentation 110 8.5 Results and discussion 113 8.6 Conclusion and Future Work 114 References 114 9 Mobile Doctor Brain AI App: Artificial Intelligence for IoT Healthcare 117Bassant M.Elbagoury, Ahmed A.Bakr, Mohamed Roushdy, Th omas Schrader 9.1 Introduction 118 9.2 State of the Art 118 9.2.1 Mobile Doctor AI App for Stroke Emergency in Haij Crowd 118 9.2.2 Proposed Architecture 119 9.3 Proposed System Design 120 9.3.1 AI Telemedicine Platform and Proposed System Architecture 120 9.3.2 Wireless intelligence sensor network extract user’s biofeedback signal 121 9.4 Proposed Artificial Intelligence Techniques for New AI IoT Health-Care Solutions for Stroke Monitoring 122 9.4.1 Support vector machine (SVM) 122 9.4.2 Case-based Reasoning 125 9.4.3 Particle Swarm Intelligence and ARX Model for Stroke Motion Estimation and Optimization 126 9.5 Conclusion 126 References 126 10 An Artificial Intelligence Mobile Cloud Computing Tool 129M. Hassan Bin Shalhoub, Mohammed H. Bin Shalhoub, Mariam Marzouq Al-Otaibi, Bassant M. Elbagoury 10.1 Introduction 130 10.2 Background and State-of-the-Art 130 10.3 Development and Proposing a New Intelligent case-based Reasoning Decision Engine for Cacer Diagnosis 131 10.4 Experimental Results of the Proposed System 132 10.5 Conclusion 133 References 133 11 Advanced Intelligent Robot Control Interfaces for the VR Simulation 137Gal IonelAlexandru, Vladareanu Luige and Shuang Cang 11.1 Introduction 138 11.2 Proposed Mechanical Structure 138 11.3 Unit 3D Integration 139 11.4 Results 148 11.5 Conclusion 150 Acknowledgments 150 References 150 12 Analysis of Telemedicine Technologies 153Vikram Puri, Jolanda G Tromp, Noell C.L. Leroy, Chung Le Van, Nhu Gia Nguyen 12.1 Introduction 154 12.2 Literature Review 154 12.3 Architecture of Telemedicine Technologies 155 12.4 Enabling Technologies for Telemedicine 156 12.4.1 Telehealth for Congestive Heart Failure 156 12.4.2 Telemedicine for the Veterans 157 12.4.3 Tele-ICU (Intensive Care Unit) 157 12.4.4 Helping Patients Adhere to Medication Regimes 158 12.4.5 eReferral - reduces consultation time 158 12.5 Conclusion 159 References 159 Part III Robotics Technologies and Applications for Health and Medicine 13 Critical Position using Environment Model Applied on Walking Robots 165M. Migdalovici, L. Vladareanu, N. Pop, H. Yu, M. Iliescu, V. Vladareanu, D. Baran, G. Vladeanu 13.1 Introduction 166 13.2 On the Environment’s Mathematical Model 166 13.3 Physical and Mathematical Models of the Walking Robot Leg 169 13.4 On Critical Positions of 3D Walking Robots 171 13.5 Mathematical model of beam without damping 173 13.6 Mathematical Model of Beam with Viscous Damping 175 13.7 Conclusion 175 References 176 14 The Walking Robot Equilibrium Recovery Applied on the NAO Robot 179N. Pop, L. Vladareanu, H.Wang, M. Ungureanu, M. Migdalovici, V. Vladareanu, Y. Feng, M. Lin, E. P. Mastan and I. El Emary 14.1 Introduction 180 14.2 The Choice of the Model 180 14.3 Mathematical Modeling of Twolink Biped Walking Robot 181 14.4 Linear Control Design 182 14.4.1 Linear Quadratic Regulator 183 14.4.2 Numerical Results using MATLAB 184 14.5 Results and Discussion 187 14.6 Conclusions 188 References 188 15 Development of a Robotic Teaching Aid for Disabled Children in Malaysia 191N.Zamin, N.I. Arshad, N. Rafiey and A.S. Hashim 15.1 Introduction 192 15.2 Case Study - Autism 192 15.3 Movitations 192 15.4 Proposed Approach 193 15.5 Results and Discussions 195 15.6 Robotic Intervention Enhance Autistic Students’ Engagement, Interaction and Focus 197 15.7 Conclusion 200 References 200 16 Training System Design of Lower Limb Rehabilitation Robot based on Virtual Reality 203H. Wang, M. Lin, Z. Jin, X. Wang, J. Niu, H. Yu, L. Zhang, L. Vladareanu 16.1 Introduction 204 16.2 Application Device 204 16.2.1 Lower Limb Rehabilitation Robot 204 16.2.2 Necessary Sensor Element 205 16.3 Trajectory Planning and Smooth Motion 206 16.3.1 Design of Training Velocity and Acceleration with Linear Path 206 16.3.2 Design of Training Velocity and Acceleration with Circle Path 208 16.3.3 Design of Training Velocity and Acceleration with Arbitrary Trajectory 209 16.3.4 The Analysis of Ambiguous Points 209 16.3.5 The Simulation of Training Velocity and Acceleration in the Planning Trajectory 209 16.4 Virtual Reality Training System 212 16.4.1 Design of Intention Judgment of Patients 213 16.4.2 Design of Adapting Training Posture Function 215 16.4.3 Interaction Control Strategy 215 16.5 Virtual Reality Software Design 216 16.5.1 Virtual Scene Build 216 16.5.2 Game Function Design 217 16.6 Virtual Reality Training Experiment 219 16.6.1 Model Synchronization Test 219 16.6.2 Feedback Terrains Test 219 16.7 Conclusion 220 Contributions 220 Acknowledgements 220 References 220 Part IV Internet of Things Technologies and Applications for Health and Medicine 17 Automation of Appliances Using Electroencephalography 225Shivam Kolhe, Dhaval Khemani, Chintan Bhatt, and Nilesh Dubey 17.1 Introduction 226 17.2 Background, History and Future Aspects 226 17.3 Brain with its Main Parts and Their Functions 227 17.3.1 Central Nervous System 228 17.3.2 Peripheral Nervous System 229 17.3.3 How are the Brain Signals Generated 230 17.3.4 What is Neuron Synapse? 232 17.4 Working of BCI 233 17.4.1 Types of Waves Generated and Detected by Brain 234 17.4.2 How to Perform Electroencephalogram 236 17.4.3 How to Take Measurements of the Head 237 17.4.4 How are EEG Signals Recorded 238 17.4.5 Methods to Display EEG on Screen 239 17.4.6 Eye Blink EEG Patterns 240 17.5 BCI Classes 241 17.5.1 Applications of BCI 242 17.5.2 Challenges BCI is facing 242 17.6 Conclusion 243 References 243 18 Designing a Beautiful Life for Indian Blind Peoples: A Smart Stick 245Aatrey Vyas, Dhaval Bhimani, Smit Patel, Hardik Mandora, Chintan Bhatt 18.1 Introduction 246 18.2 Internet of Things 246 18.3 Background 247 18.4 Purpose Approach 248 18.4.1 Ultrasonic Sensor 248 18.4.2 NodeMCU 249 18.4.3 Global positioning system (GPS) 249 18.4.4 Buzzer 250 18.4.5 Flow Diagram 251 18.5 Implementation 251 18.6 Advantages and Disadvantages 256 18.7 Conclusion 257 References 258 19 Smart Home: Personal Assistant and Baby Monitoring System 259Shivam Kolhe, Sonia Nagpal, Priya Makwana, Chintan Bhatt 19.1 Introduction 260 19.2 Background 261 19.3 Proposed Design and Implementation 261 19.3.1 Smart Home Personal Assistant 262 19.3.2 Baby Monitoring System 265 19.4 Online Energy Meter 268 19.5 Sensors used and Their Working 269 19.5.1 Temperature Sensor 269 19.5.2 Soil Moisture Sensor 270 19.5.3 PIR (Passive InfraRed) Sensor 272 19.6 Conclusion 283 References 284

Read more less