Business applications Books

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

Book SynopsisOne practical book that''s ten books in one: Learn everything you need to know about Microsoft Office with one comprehensive guide on your bookshelf To know your way around all the applications within Microsoft Office would require you to be part mathematician, part storyteller, and part graphic designer--with some scheduling wizard and database architect sprinkled in. If these talents don''t come naturally to you in equal measure, don''t panic--Office 2019 All-in-One For Dummies can help. This hefty but easily accessible tome opens with Book 1, an overview of the Office suite of applications and tips for handling text and becoming more efficient. From there, you''ll find a book on each of the suite''s major applications: Word: Learn the basics of word processing with Word, plus lay out text and pages; use Word''s styles and proofing tools; construct tables, reports, and scholarly papers; and become familiar with manipulating documentsTable of ContentsIntroduction 1 What Makes This Book Different 2 Foolish Assumptions 3 Conventions Used in This Book 3 Icons Used in This Book 4 Beyond the Book 4 Book 1: Common Office Tasks 5 Chapter 1: Office Nuts and Bolts 7 A Survey of Office Applications 7 All about Office 365 9 Finding Your Way Around the Office Interface 11 Saving Your Files 18 Navigating the Save As and Open Windows 19 Opening and Closing Files 21 Reading and Recording File Properties 22 Locking a File with a Password 23 Trusting (or not Trusting) Microsoft with Your “Content” 24 Chapter 2: Wrestling with the Text 27 Manipulating the Text 27 Speaking, not Typing, the Words 30 Changing the Look of Text 32 Quick Ways to Handle Case, or Capitalization 39 Entering Symbols and Foreign Characters 41 Creating Hyperlinks 42 Chapter 3: Speed Techniques Worth Knowing About 47 Undoing and Repeating Commands 47 Zooming In, Zooming Out 49 Viewing a File Through More Than One Window 50 Correcting Typos on the Fly 51 Entering Text Quickly with the AutoCorrect Command 52 Book 2: Word 2019 55 Chapter 1: Speed Techniques for Using Word 57 Introducing the Word Screen 57 Creating a New Document 59 Getting a Better Look at Your Documents 61 Selecting Text in Speedy Ways 66 Moving Around Quickly in Documents 67 Inserting a Whole File into a Document 71 Getting Word to Read It 72 Entering Information Quickly in a Computerized Form 72 Chapter 2: Laying Out Text and Pages 77 Paragraphs and Formatting 77 Inserting a Section Break for Formatting Purposes 78 Breaking a Line 81 Starting a New Page 81 Setting Up and Changing the Margins 82 Indenting Paragraphs and First Lines 84 Numbering the Pages 86 Putting Headers and Footers on Pages 89 Adjusting the Space Between Lines 93 Adjusting the Space Between Paragraphs 95 Creating Numbered and Bulleted Lists 96 Working with Tabs 99 Hyphenating Text 101 Chapter 3: Word Styles 105 All About Styles 105 Applying Styles to Text and Paragraphs 107 Creating a New Style 112 Modifying a Style 114 Creating and Managing Templates 116 Chapter 4: Constructing the Perfect Table 123 Talking Table Jargon 124 Creating a Table 124 Entering the Text and Numbers 127 Selecting Different Parts of a Table 128 Laying Out Your Table 128 Aligning Text in Columns and Rows 133 Merging and Splitting Cells 134 Repeating Header Rows on Subsequent Pages 135 Formatting Your Table 137 Using Math Formulas in Tables 140 Neat Table Tricks 141 Chapter 5: Taking Advantage of the Proofing Tools 147 Correcting Your Spelling Errors 148 Correcting Grammatical Errors 151 Finding and Replacing Text 153 Finding the Right Word with the Thesaurus 161 Proofing Text Written in a Foreign Language 162 Translating Foreign Language Text 164 Chapter 6: Desktop Publishing with Word 167 Experimenting with Themes 167 Sprucing Up Your Pages 168 Making Use of Charts, Diagrams, Shapes, and Photos 171 Working with the Drawing Canvas 172 Positioning and Wrapping Objects Relative to the Page and Text 173 Working with Text Boxes 177 Dropping In a Drop Cap 179 Watermarking for the Elegant Effect 180 Putting Newspaper-Style Columns in a Document 181 Landscape Documents 183 Printing on Different Size Paper 184 Showing Online Video in a Document 184 Chapter 7: Getting Word’s Help with Office Chores 187 Highlighting Parts of a Document 187 Commenting on a Document 188 Tracking Changes to Documents 192 Printing an Address on an Envelope 197 Printing a Single Address Label (Or a Page of the Same Label) 199 Churning Out Letters, Envelopes, and Labels for Mass Mailings 200 Chapter 8: Tools for Reports and Scholarly Papers 209 Alphabetizing a List 209 Outlines for Organizing Your Work 210 Collapsing and Expanding Parts of a Document 212 Generating a Table of Contents 213 Indexing a Document 218 Putting Cross-References in a Document 222 Putting Footnotes and Endnotes in Documents 225 Compiling a Bibliography 227 Book 3: Excel 2019 233 Chapter 1: Up and Running with Excel 235 Creating a New Excel Workbook 235 Getting Acquainted with Excel 237 Entering Data in a Worksheet 239 Quickly Entering Lists and Serial Data with the AutoFill Command 245 Formatting Numbers, Dates, and Time Values 248 Establishing Data-Validation Rules 249 Chapter 2: Refining Your Worksheet 253 Editing Worksheet Data 253 Moving Around in a Worksheet 254 Getting a Better Look at the Worksheet 255 Comments for Documenting Your Worksheet 258 Selecting Cells in a Worksheet 260 Deleting, Copying, and Moving Data 261 Handling the Worksheets in a Workbook 261 Keeping Others from Tampering with Worksheets 264 Chapter 3: Formulas and Functions for Crunching Numbers 267 How Formulas Work 267 The Basics of Entering a Formula 273 Speed Techniques for Entering Formulas 273 Copying Formulas from Cell to Cell 279 Detecting and Correcting Errors in Formulas 281 Working with Functions 284 A Look at Some Very Useful Functions 289 Chapter 4: Making a Worksheet Easier to Read and Understand 299 Laying Out a Worksheet 299 Decorating a Worksheet with Borders and Colors 305 Getting Ready to Print a Worksheet 310 Chapter 5: Advanced Techniques for Analyzing Data 317 Seeing What the Sparklines Say 317 Conditional Formats for Calling Attention to Data 319 Managing Information in Lists 320 Forecasting with the Goal Seek Command 323 Performing What-If Analyses with Data Tables 325 Analyzing Data with PivotTables 329 Book 4: Powerpoint 2019 335 Chapter 1: Getting Started in PowerPoint 337 Getting Acquainted with PowerPoint 338 A Brief Geography Lesson 339 A Whirlwind Tour of PowerPoint 340 Creating a New Presentation 341 Advice for Building Persuasive Presentations 344 Creating New Slides for Your Presentation 346 Getting a Better View of Your Work 350 Hiding and Displaying the Slides Pane and Notes Pane 352 Selecting, Moving, and Deleting Slides 352 Putting Together a Photo Album 354 Hidden Slides for All Contingencies 357 Chapter 2: Fashioning a Look for Your Presentation 359 Looking at Themes and Slide Backgrounds 360 Choosing a Theme for Your Presentation 361 Creating Slide Backgrounds on Your Own 362 Changing the Background of a Single or Handful of Slides 368 Choosing the Slide Size 369 Using Master Slides and Master Styles for a Consistent Design 370 Chapter 3: Entering the Text 373 Entering Text 373 Fun with Text Boxes and Text Box Shapes 377 Controlling How Text Fits in Text Frames and Text Boxes 379 Positioning Text in Frames and Text Boxes 382 Handling Bulleted and Numbered Lists 382 Putting Footers (and Headers) on Slides 385 Some background on footers and headers 386 Putting a standard footer on all your slides 386 Creating a nonstandard footer 387 Removing a footer from a single slide 388 Chapter 4: Making Your Presentations Livelier 389 Suggestions for Enlivening Your Presentation 389 Presenting Information in a Table 390 Exploring Transitions and Animations 393 Making Audio Part of Your Presentation 396 Playing Video on Slides 399 Recording a Voice Narration for Slides 403 Chapter 5: Delivering a Presentation 405 All about Notes 405 Rehearsing and Timing Your Presentation 406 Showing Your Presentation 408 Tricks for Making Presentations a Little Livelier 411 Delivering a Presentation When You Can’t Be There in Person 414 Book 5: Outlook 2019 425 Chapter 1: Outlook Basics 427 What Is Outlook, Anyway? 427 Navigating the Outlook Folders 429 Categorizing Items 430 Searching for Stray Folder Items 432 Deleting Email Messages, Contacts, Tasks, and Other Items 435 Cleaning Out Your Folders 436 Chapter 2: Maintaining the Contacts Folder 441 Maintaining a Happy and Healthy Contacts Folder 442 Contact Groups for Sending Messages to Groups 445 Finding a Contact in the Contacts Folder 447 Printing the Contacts Folder 448 Chapter 3: Handling Your Email 451 Setting Up an Email Account 451 Addressing and Sending Email Messages 452 Sending Files and Photos 458 Receiving Email Messages 460 Reading Your Email in the Inbox Window 461 Handling Files That Were Sent to You 463 Techniques for Organizing Email Messages 464 All about Email Folders 468 Yes, You Can Prevent Junk Mail (Sort of) 470 Chapter 4: Managing Your Time and Schedule 473 Introducing the Calendar 473 The Different Kinds of Activities 474 Seeing Your Schedule 475 Scheduling Appointments and Events 477 Scheduling an activity: The basics 477 Scheduling a recurring appointment or event 478 Scheduling an event 479 Canceling, Rescheduling, and Altering Activities 480 Chapter 5: Tasks, Reminders, and Notes 481 Tasks: Seeing What Needs to Get Done 481 Reminders for Being Alerted to Activities and Tasks 484 Making Notes to Yourself 487 Book 6: Access 2019 489 Chapter 1: Introducing Access 491 What Is a Database, Anyway? 492 Tables, Queries, Forms, and Other Objects 492 Creating a Database File 497 Finding Your Way Around the Navigation Pane 499 Designing a Database 501 Chapter 2: Building Your Database Tables 507 Creating a Database Table 507 Opening and Viewing Tables 511 Entering and Altering Table Fields 512 Field Properties for Making Sure That Data Entries Are Accurate 518 Indexing for Faster Sorts, Searches, and Queries 526 Establishing Relationships Among Database Tables 528 Chapter 3: Entering the Data 535 The Two Ways to Enter Data 535 Entering the Data in Datasheet View 536 Entering the Data in a Form 540 Finding a Missing Record 542 Finding and Replacing Data 543 Chapter 4: Sorting, Querying, and Filtering for Data 545 Sorting Records in a Database Table 545 Filtering to Find Information 546 Querying: The Basics 552 Six Kinds of Queries 560 Chapter 5: Presenting Data in a Report 567 Creating a Report 567 Opening and Viewing Reports 569 Tweaking a Report 569 Book 7: Publisher 2019 573 Chapter 1: Introducing Publisher 575 “A Print Shop in a Can” 575 Introducing Frames 576 Creating a Publication 577 Redesigning a Publication 578 Getting a Better View of Your Work 580 Understanding and Using the Layout Guides 582 Chapter 2: Refining a Publication 587 Entering Text on the Pages 587 Making Text Fit in Text Frames 588 Formatting Text 592 Making Text Wrap around a Frame or Graphic 592 Replacing the Placeholder Pictures 593 Inserting Frames on the Pages 594 Making Frames Overlap 596 Inserting, Removing, and Moving Pages 596 Chapter 3: Putting on the Finishing Touches 599 Decorating the Text 600 Techniques for Decorating Pages 602 Master Pages for Handling Page Backgrounds 606 Running the Design Checker 608 Commercially Printing a Publication 609 Book 8: Working with Charts and Graphics 611 Chapter 1: Creating a Chart 613 The Basics: Creating a Chart 613 Choosing the Right Chart 615 Providing the Raw Data for Your Chart 617 Positioning Your Chart in a Workbook, Page, or Slide 619 Handling the gridlines 624 Changing a chart element’s color, font, or other particular 624 Saving a Chart as a Template So That You Can Use It Again 626 Chart Tricks for the Daring and Heroic 627 Troubleshooting a Chart 630 Chapter 2: Making a SmartArt Diagram 633 The Basics: Creating SmartArt Diagrams 633 Creating the Initial Diagram 636 Changing the Size and Position of a Diagram 638 Laying Out the Diagram Shapes 638 Handling the Text on Diagram Shapes 644 Changing a Diagram’s Direction 647 Choosing a Look for Your Diagram 647 Changing the Appearance of Diagram Shapes 648 Creating a Diagram from Scratch 651 Chapter 3: Handling Graphics and Photos 653 All about Picture File Formats 653 Inserting a Picture in an Office File 657 Touching Up a Picture 660 Compressing Pictures to Save Disk Space 668 Chapter 4: Drawing and Manipulating Lines, Shapes, and Other Objects 671 The Basics: Making Lines, Arrows, and Shapes 672 Handling Lines, Arrows, and Connectors 674 Handling Rectangles, Ovals, Stars, and Other Shapes 678 Drawing by Freehand 682 Decorating Your Work with Icons 685 Inserting a 3-D Model 686 WordArt for Embellishing Letters and Words 686 Manipulating Lines, Shapes, Art, Text Boxes, and Other Objects 688 Changing an Object’s Size and Shape 691 Changing an Object’s Color, Outline Color, and Transparency 692 Moving and Positioning Objects 697 Book 9: Office 2019: One Step Beyond 705 Chapter 1: Customizing an Office Program 707 Customizing the Ribbon 707 Customizing the Quick Access Toolbar 713 Customizing the Status Bar 716 Changing the Screen Background and Office Theme 717 Customizing Keyboard Shortcuts in Word 718 Chapter 2: Ways of Distributing Your Work 721 Printing — the Old Standby 721 Distributing a File in PDF Format 723 Sending Your File in an Email Message 725 Saving an Office File as a Web Page 726 Book 10: File Sharing and Collaborating 729 Chapter 1: Up and Running on OneDrive 731 Signing In to OneDrive 731 Exploring the OneDrive Window 733 Managing Your OneDrive Folders 733 Uploading Files to a Folder on OneDrive 738 Saving a File from Office 2019 to OneDrive 739 Opening a File from OneDrive 740 Downloading Files from OneDrive to Your Computer 741 Chapter 2: File Sharing and Collaborating 743 Sharing Files: The Big Picture 743 Sharing Your Files and Folders with Others 745 Inviting people by email 745 Seeing Files and Folders Others Shared with You 748 Investigating and Managing How Files and Folders Are Shared 749 Index 751

Read more less

Book SynopsisTable of ContentsIntroduction 1 About This Book 2 About the Version Numbers 3 Foolish Assumptions 3 Conventions Used in This Book 3 Dialog boxes 4 Ribbons and tabs 4 Keyboard shortcuts 5 Icons Used in This Book 6 Part 1: Getting Started with Outlook 2019 7 Chapter 1: Outlook Features You Really Need to Know 9 Explaining Why So Many People Use Outlook 9 Doing Anything in Outlook the Easy Way 10 Using Email: Basic Delivery Techniques 11 Reading email 11 Answering email 12 Creating new email messages 13 Sending a File 14 Maintaining Your Calendar 17 Entering an appointment 17 Managing your schedule 18 Adding a Contact 18 Entering a Task 19 Taking Notes 21 Chapter 2: Inside Outlook: Getting More Done with Less Effort 23 Outlook and Other Programs 24 There’s No Place Like Home: Outlook’s Main Screen 25 Moving between modules 27 Using the Folder pane 28 The Information Viewer: Outlook’s hotspot 29 Navigating folders 31 Tying It All Together: The Ribbon 31 Viewing ScreenTips 32 Using the New Items button 32 Finding Things in a Flash with Instant Search 33 Taking Peeks 35 Getting Help in Outlook 35 Chapter 3: On the Fast Track: Drag ’Til You Drop 37 Dragging 37 Dispatching Tasks in a Flash 39 Making Time Stand Still with Calendar Wizardry 42 Keeping Friends Close and Enemies Closer 44 Creating Instant Email Messages 45 Creating email from a name in your Contacts list 45 Creating an email from an appointment 46 Expanding Your Outlook Workspace 47 Zen of the Right Button 48 Part 2: Taming the Email Beast 49 Chapter 4: The Essential Secrets of Email 51 Front Ends and Back Ends 51 Creating Messages 52 The quick-and-dirty way 52 The slow but complete way 53 Setting priorities 55 Setting sensitivity 57 Setting other message options 58 Adding an Internet link to an email message 58 Reading and Replying to Email Messages 59 Viewing previews of message text 60 Sending a reply 61 Resending messages 63 Don’t get caught by phishing 63 That’s Not My Department: Forwarding Email 64 Blind Copying for Privacy 65 Deleting Messages 66 Saving Interrupted Messages 66 Saving a Message as a File 67 Chapter 5: Email Tools You Can’t Do Without 69 Nagging by Flagging 70 One-click flagging 70 Setting flags for different days 71 Changing the default flag date 71 Adding a flag with a customized reminder 72 Changing the date on a reminder 73 Saving Copies of Your Messages 74 Setting Your Reply and Forward Options 75 Adding Comments to a Reply or a Forward 77 Sending Attachments 78 Emailing Screenshots 80 Creating Signatures for Your Messages 81 Chapter 6: Conquering Your Mountain of Messages 85 Organizing Folders 86 Creating a new mail folder 86 Moving messages to another folder 87 Organizing Your Email with Search Folders 88 Setting up a search folder 88 Using a search folder 90 Deleting a search folder 91 Using the Reading Pane 91 Playing by the Rules 92 Creating a rule 92 Running a rule 95 Filtering Junk Email 96 Fine-tuning the filter’s sensitivity 96 Filtering your email with sender and recipient lists 98 Filtering domains 100 Archiving for Posterity 101 Setting up AutoArchive 102 Setting AutoArchive for individual folders 103 Starting the archive process manually 105 Finding and viewing archived items 106 Closing the archive data file 108 Arranging Your Messages 108 Viewing conversations 111 Ignoring conversations 112 Cleaning up conversations 113 Simplifying Tasks Using Quick Steps 115 Creating and managing Quick Steps 118 Creating Quick Parts to save keystrokes 120 Part 3: Managing Contacts, Dates, Tasks, and More 123 Chapter 7: Your Little Black Book: Creating Contacts Lists 125 Putting in Your Contacts: Names, Numbers, and Other Stuff 126 The quick-and-dirty way to enter contacts 126 The slow, complete way to enter contacts 126 Viewing Your Contacts 132 Sorting a view 133 Rearranging views 134 Using grouped views 134 Flagging Your Friends 136 Using Contact Information 138 Searching for contacts 138 Finding a contact from any Outlook module 141 Forwarding a business card 141 Gathering People Into Groups 143 Creating a Contact group 143 Editing a Contact group 145 Using a Contact group 145 Adding pictures to contacts 145 Chapter 8: Unleashing the Calendar’s Power 147 Getting Around the Outlook Calendar 147 Meetings Galore: Scheduling Appointments 150 The quick-and-dirty way to enter an appointment 150 The complete way to enter an appointment 151 Not this time: Changing dates 153 Not ever: Breaking dates 155 We’ve got to keep seeing each other: Recurring dates 156 Getting a Good View of Your Calendar 158 Printing Your Appointments 159 Adding Holidays 161 Handling Multiple Calendars 162 Creating multiple calendars 162 Managing multiple calendars 163 Chapter 9: Task Mastery: Discovering All the Bells and Whistles 165 Entering New Tasks in the Tasks Module 166 The quick-and-dirty way to enter a task 166 The regular way to enter a task 166 Adding an Internet link to a task 169 Editing Your Tasks 169 The quick-and-dirty way to change a task 169 The regular way to change a task 170 Deleting a task 172 Managing Recurring Tasks 173 Creating a regenerating task 174 Skipping a recurring task once 175 Marking Tasks as Complete 176 Marking it off 176 Picking a color for completed or overdue tasks 177 Viewing Your Tasks 178 Frequenting the To-Do Bar 180 Adding a new item to the To-Do bar 180 Tasks in the Calendar 181 Chapter 10: Seeing It Your Way: Customizing Outlook 183 Customizing the Quick Access Toolbar 184 Customizing the Ribbon 185 Enjoying the Views 186 Table/List view 187 Card view 188 Calendar views 188 Playing with Columns in Table/List Views 189 Adding a column 189 Moving a column 190 Widening or narrowing a column 191 Removing a column 192 Sorting Items 192 Sorting from Table view 193 Sorting from the Sort dialog box 193 Grouping Items 194 Viewing grouped items 194 Viewing headings only 195 Saving Custom Views 195 Using Categories 196 Assigning a category 196 Renaming a category 197 Changing a category color 198 Assigning a category shortcut key 198 Part 4: Beyond the Basics: Tips and Tricks You Won’t Want to Miss 201 Chapter 11: Social Media Magic with Outlook RSS 203 Brushing Up on Social Media Basics 204 Sending an SOS for RSS 204 Feeling like a social butterfly 205 Subscribing to an RSS Feed via Internet Explorer 207 Setting Up an RSS Feed in Outlook 208 Reading Feeds 211 Chapter 12: Managing Multiple Email Accounts 213 Choosing an Email Provider 213 Buying Your Own Domain Name 215 Setting Up Email Accounts in Outlook 216 Understanding POP3 vs IMAP 216 Collecting the needed information for setup 217 Setting up an account using automatic settings 218 Setting up an account using manual settings 220 Modifying Mail Account Settings 222 Changing the Mail Server 223 Sending Messages from Different Accounts 224 Chapter 13: Merging Mail From Outlook to Microsoft Word 227 Conjuring Mailing Label Magic 228 Urging to merge 228 Making and using a merge template 232 Mastering Form Letter Formalities 233 Merging From Selected Contacts 234 You’ll Still Have to Lick It: Printing Envelopes 234 Merging to Email 235 Part 5: Outlook At Work 237 Chapter 14: Big-Time Collaboration with Outlook 239 Collaborating with Outlook’s Help 240 Organizing a meeting 240 Responding to a meeting request 243 Checking responses to your meeting request 244 Taking a vote 245 Tallying votes 247 Assigning tasks 247 Sending a status report 248 Collaborating with Outlook and Exchange 249 Giving delegate permissions 250 Opening someone else’s folder 251 Viewing Two Calendars Side by Side 252 Setting access permissions 252 Viewing two accounts 254 Managing Your Out of Office Message 256 Managing Your Address Books 257 Scheduling a Skype Meeting 259 Setting up a Skype meeting 259 Joining a Skype meeting 260 Chapter 15: Outlook for the iPad and Android Phones 261 Understanding the Mobile Difference 262 Accessing Mobile Email 263 Reading email 263 Replying to email 264 Composing email 265 Archiving, scheduling, and deleting email messages 267 Deleting messages 269 Managing groups of messages 269 Using Your Mobile Calendar 270 Navigating the mobile calendar 270 Creating a new appointment 271 Chapter 16: Telecommuting with Outlook.com and the Outlook Web App 273 Signing In to Outlook.com 274 Exploring the Outlook.com Interface 274 Getting Caught Up on Web Email Basics 276 Reading messages 276 Sending a message 277 Setting message importance 278 Flagging messages 278 Organizing Contacts 279 Viewing your contacts 279 Adding contacts 279 Using Your Calendar 281 Viewing your calendar 281 Entering an appointment 282 Moving an appointment 284 Exploring Your Options 285 Automated vacation replies/out of office message 286 Creating a signature 287 Understanding the Outlook Web App 288 Knowing when it’s handy 289 Signing in and out 289 Part 6: The Part of Tens 291 Chapter 17: Ten Shortcuts Worth Taking 293 Using the New Items Tool 293 Sending a File to an Email Recipient 294 Sending a File From a Microsoft Office Application 295 Turning a Message Into a Meeting 296 Finding Something 296 Undoing Your Mistakes 296 Using the Go to Date Dialog Box 296 Adding Items to List Views 297 Sending Repeat Messages 297 Resending a Message 298 Chapter 18: Ten Accessories for Outlook 299 Smartphones 299 A Tablet Computer 300 For Dummies E-Learning 300 Microsoft Office 301 A Business-Card Scanner 301 Online Backup 301 Skype 301 Microsoft SharePoint 302 Microsoft Exchange 302 OneDrive 302 Chapter 19: Ten Things You Can’t Do with Outlook 303 Create a Unified Inbox 304 Insert a Phone Number Into Your Calendar 304 Open a Message From the Reading Pane 304 Perform Two-Sided Printing 305 Search and Replace Area Codes 305 Print a List of Meeting Attendees 305 Enlarge the Type in the Calendar Location Box 305 Create Contact Records for All Recipients of an Email 306 Track Time Zones for Meetings 306 Back Up Outlook Data Easily 306 Ten More Things Outlook Can’t Do for You 307 Chapter 20: Ten Things You Can Do After You’re Comfy 309 Take Notes 310 Customize the Quick Access Toolbar 310 Wise Up Your Messages with Smart Art 311 Translate Your Email Messages 312 Add Charts for Impact 312 Use Symbols in Email 313 Open Multiple Calendars 313 Superimpose Calendars 313 Select Dates as a Group 314 Pin a Contact Card 314 Index 315

Read more less

Book SynopsisLearn data science by doing data science! Data Science Using Python and R will get you plugged into the world's two most widespread open-source platforms for data science: Python and R. Data science is hot. Bloomberg called data scientist the hottest job in America. Python and R are the top two open-source data science tools in the world. In Data Science Using Python and R, you will learn step-by-step how to produce hands-on solutions to real-world business problems, using state-of-the-art techniques. Data Science Using Python and R is written for the general reader with no previous analytics or programming experience. An entire chapter is dedicated to learning the basics of Python and R. Then, each chapter presents step-by-step instructions and walkthroughs for solving data science problems using Python and R. Those with analytics experience will appreciate having a one-stop shop for learning how to do data science using Python and R. Topics covered include data preparation, expTable of ContentsPreface xi About the Authors xv Acknowledgements xvii Chapter 1 Introduction to Data Science 1 1.1 Why Data Science? 1 1.2 What is Data Science? 1 1.3 The Data Science Methodology 2 1.4 Data Science Tasks 5 1.4.1 Description 6 1.4.2 Estimation 6 1.4.3 Classification 6 1.4.4 Clustering 7 1.4.5 Prediction 7 1.4.6 Association 7 Exercises 8 Chapter 2 The Basics of Python and R 9 2.1 Downloading Python 9 2.2 Basics of Coding in Python 9 2.2.1 Using Comments in Python 9 2.2.2 Executing Commands in Python 10 2.2.3 Importing Packages in Python 11 2.2.4 Getting Data into Python 12 2.2.5 Saving Output in Python 13 2.2.6 Accessing Records and Variables in Python 14 2.2.7 Setting Up Graphics in Python 15 2.3 Downloading R and RStudio 17 2.4 Basics of Coding in R 19 2.4.1 Using Comments in R 19 2.4.2 Executing Commands in R 20 2.4.3 Importing Packages in R 20 2.4.4 Getting Data into R 21 2.4.5 Saving Output in R 23 2.4.6 Accessing Records and Variables in R 24 References 26 Exercises 26 Chapter 3 Data Preparation 29 3.1 The Bank Marketing Data Set 29 3.2 The Problem Understanding Phase 29 3.2.1 Clearly Enunciate the Project Objectives 29 3.2.2 Translate These Objectives into a Data Science Problem 30 3.3 Data Preparation Phase 31 3.4 Adding an Index Field 31 3.4.1 How to Add an Index Field Using Python 31 3.4.2 How to Add an Index Field Using R 32 3.5 Changing Misleading Field Values 33 3.5.1 How to Change Misleading Field Values Using Python 34 3.5.2 How to Change Misleading Field Values Using R 34 3.6 Reexpression of Categorical Data as Numeric 36 3.6.1 How to Reexpress Categorical Field Values Using Python 36 3.6.2 How to Reexpress Categorical Field Values Using R 38 3.7 Standardizing the Numeric Fields 39 3.7.1 How to Standardize Numeric Fields Using Python 40 3.7.2 How to Standardize Numeric Fields Using R 40 3.8 Identifying Outliers 40 3.8.1 How to Identify Outliers Using Python 41 3.8.2 How to Identify Outliers Using R 42 References 43 Exercises 44 Chapter 4 Exploratory Data Analysis 47 4.1 EDA Versus HT 47 4.2 Bar Graphs with Response Overlay 47 4.2.1 How to Construct a Bar Graph with Overlay Using Python 49 4.2.2 How to Construct a Bar Graph with Overlay Using R 50 4.3 Contingency Tables 51 4.3.1 How to Construct Contingency Tables Using Python 52 4.3.2 How to Construct Contingency Tables Using R 53 4.4 Histograms with Response Overlay 53 4.4.1 How to Construct Histograms with Overlay Using Python 55 4.4.2 How to Construct Histograms with Overlay Using R 58 4.5 Binning Based on Predictive Value 58 4.5.1 How to Perform Binning Based on Predictive Value Using Python 59 4.5.2 How to Perform Binning Based on Predictive Value Using R 62 References 63 Exercises 63 Chapter 5 Preparing to Model the Data 69 5.1 The Story So Far 69 5.2 Partitioning the Data 69 5.2.1 How to Partition the Data in Python 70 5.2.2 How to Partition the Data in R 71 5.3 Validating your Partition 72 5.4 Balancing the Training Data Set 73 5.4.1 How to Balance the Training Data Set in Python 74 5.4.2 How to Balance the Training Data Set in R 75 5.5 Establishing Baseline Model Performance 77 References 78 Exercises 78 Chapter 6 Decision Trees 81 6.1 Introduction to Decision Trees 81 6.2 Classification and Regression Trees 83 6.2.1 How to Build CART Decision Trees Using Python 84 6.2.2 How to Build CART Decision Trees Using R 86 6.3 The C5.0 Algorithm for Building Decision Trees 88 6.3.1 How to Build C5.0 Decision Trees Using Python 89 6.3.2 How to Build C5.0 Decision Trees Using R 90 6.4 Random Forests 91 6.4.1 How to Build Random Forests in Python 92 6.4.2 How to Build Random Forests in R 92 References 93 Exercises 93 Chapter 7 Model Evaluation 97 7.1 Introduction to Model Evaluation 97 7.2 Classification Evaluation Measures 97 7.3 Sensitivity and Specificity 99 7.4 Precision, Recall, and Fβ Scores 99 7.5 Method for Model Evaluation 100 7.6 An Application of Model Evaluation 100 7.6.1 How to Perform Model Evaluation Using R 103 7.7 Accounting for Unequal Error Costs 104 7.7.1 Accounting for Unequal Error Costs Using R 105 7.8 Comparing Models with and without Unequal Error Costs 106 7.9 Data‐Driven Error Costs 107 Exercises 109 Chapter 8 Naïve Bayes Classification 113 8.1 Introduction to Naive Bayes 113 8.2 Bayes Theorem 113 8.3 Maximum a Posteriori Hypothesis 114 8.4 Class Conditional Independence 114 8.5 Application of Naive Bayes Classification 115 8.5.1 Naive Bayes in Python 121 8.5.2 Naive Bayes in R 123 References 125 Exercises 126 Chapter 9 Neural Networks 129 9.1 Introduction to Neural Networks 129 9.2 The Neural Network Structure 129 9.3 Connection Weights and the Combination Function 131 9.4 The Sigmoid Activation Function 133 9.5 Backpropagation 134 9.6 An Application of a Neural Network Model 134 9.7 Interpreting the Weights in a Neural Network Model 136 9.8 How to Use Neural Networks in R 137 References 138 Exercises 138 Chapter 10 Clustering 141 10.1 What is Clustering? 141 10.2 Introduction to the K‐Means Clustering Algorithm 142 10.3 An Application of K‐Means Clustering 143 10.4 Cluster Validation 144 10.5 How to Perform K‐Means Clustering Using Python 145 10.6 How to Perform K‐Means Clustering Using R 147 Exercises 149 Chapter 11 Regression Modeling 151 11.1 The Estimation Task 151 11.2 Descriptive Regression Modeling 151 11.3 An Application of Multiple Regression Modeling 152 11.4 How to Perform Multiple Regression Modeling Using Python 154 11.5 How to Perform Multiple Regression Modeling Using R 156 11.6 Model Evaluation for Estimation 157 11.6.1 How to Perform Estimation Model Evaluation Using Python 159 11.6.2 How to Perform Estimation Model Evaluation Using R 160 11.7 Stepwise Regression 161 11.7.1 How to Perform Stepwise Regression Using R 162 11.8 Baseline Models for Regression 162 References 163 Exercises 164 Chapter 12 Dimension Reduction 167 12.1 The Need for Dimension Reduction 167 12.2 Multicollinearity 168 12.3 Identifying Multicollinearity Using Variance Inflation Factors 171 12.3.1 How to Identify Multicollinearity Using Python 172 12.3.2 How to Identify Multicollinearity in R 173 12.4 Principal Components Analysis 175 12.5 An Application of Principal Components Analysis 175 12.6 How Many Components Should We Extract? 176 12.6.1 The Eigenvalue Criterion 176 12.6.2 The Proportion of Variance Explained Criterion 177 12.7 Performing Pca with K = 4 178 12.8 Validation of the Principal Components 178 12.9 How to Perform Principal Components Analysis Using Python 179 12.10 How to Perform Principal Components Analysis Using R 181 12.11 When is Multicollinearity Not a Problem? 183 References 184 Exercises 184 Chapter 13 Generalized Linear Models 187 13.1 An Overview of General Linear Models 187 13.2 Linear Regression as a General Linear Model 188 13.3 Logistic Regression as a General Linear Model 188 13.4 An Application of Logistic Regression Modeling 189 13.4.1 How to Perform Logistic Regression Using Python 190 13.4.2 How to Perform Logistic Regression Using R 191 13.5 Poisson Regression 192 13.6 An Application of Poisson Regression Modeling 192 13.6.1 How to Perform Poisson Regression Using Python 193 13.6.2 How to Perform Poisson Regression Using R 194 Reference 195 Exercises 195 Chapter 14 Association Rules 199 14.1 Introduction to Association Rules 199 14.2 A Simple Example of Association Rule Mining 200 14.3 Support, Confidence, and Lift 200 14.4 Mining Association Rules 202 14.4.1 How to Mine Association Rules Using R 203 14.5 Confirming Our Metrics 207 14.6 The Confidence Difference Criterion 208 14.6.1 How to Apply the Confidence Difference Criterion Using R 208 14.7 The Confidence Quotient Criterion 209 14.7.1 How to Apply the Confidence Quotient Criterion Using R 210 References 211 Exercises 211 Appendix Data Summarization and Visualization 215 Part 1: Summarization 1: Building Blocks of Data Analysis 215 Part 2: Visualization: Graphs and Tables for Summarizing and Organizing Data 217 Part 3: Summarization 2: Measures of Center, Variability, and Position 222 Part 4: Summarization and Visualization of Bivariate Elationships 225 Index 231

Read more less

Book SynopsisCOMPUTATION IN BIOINFORMATICS Bioinformatics is a platform between the biology and information technology and this book provides readers with an understanding of the use of bioinformatics tools in new drug design. The discovery of new solutions to pandemics is facilitated through the use of promising bioinformatics techniques and integrated approaches. This book covers a broad spectrum of the bioinformatics field, starting with the basic principles, concepts, and application areas. Also covered is the role of bioinformatics in drug design and discovery, including aspects of molecular modeling. Some of the chapters provide detailed information on bioinformatics related topics, such as silicon design, protein modeling, DNA microarray analysis, DNA-RNA barcoding, and gene sequencing, all of which are currently needed in the industry. Also included are specialized topics, such as bioinformatics in cancer detection, genomics, and proteomics. Moreover, a few chapters explTable of ContentsPreface xiii 1 Bioinfomatics as a Tool in Drug Designing 1Rene Barbie Browne, Shiny C. Thomas and Jayanti Datta Roy 1.1 Introduction 1 1.2 Steps Involved in Drug Designing 3 1.2.1 Identification of the Target Protein/Enzyme 5 1.2.2 Detection of Molecular Site (Active Site) in the Target Protein 6 1.2.3 Molecular Modeling 6 1.2.4 Virtual Screening 9 1.2.5 Molecular Docking 10 1.2.6 QSAR (Quantitative Structure-Activity Relationship) 12 1.2.7 Pharmacophore Modeling 14 1.2.8 Solubility of Molecule 14 1.2.9 Molecular Dynamic Simulation 14 1.2.10 ADME Prediction 15 1.3 Various Softwares Used in the Steps of Drug Designing 16 1.4 Applications 18 1.5 Conclusion 20 References 20 2 New Strategies in Drug Discovery 25Vivek Chavda, Yogita Thalkari and Swati Marwadi 2.1 Introduction 26 2.2 Road Toward Advancement 27 2.3 Methodology 30 2.3.1 Target Identification 30 2.3.2 Docking-Based Virtual Screening 32 2.3.3 Conformation Sampling 33 2.3.4 Scoring Function 34 2.3.5 Molecular Similarity Methods 35 2.3.6 Virtual Library Construction 37 2.3.7 Sequence-Based Drug Design 37 2.4 Role of OMICS Technology 38 2.5 High-Throughput Screening and Its Tools 40 2.6 Chemoinformatic 44 2.6.1 Exploratory Data Analysis 45 2.6.2 Example Discovery 46 2.6.3 Pattern Explanation 46 2.6.4 New Technologies 46 2.7 Concluding Remarks and Future Prospects 46 References 48 3 Role of Bioinformatics in Early Drug Discovery: An Overview and Perspective 49Shasank S. Swain and Tahziba Hussain 3.1 Introduction 50 3.2 Bioinformatics and Drug Discovery 51 3.2.1 Structure-Based Drug Design (SBDD) 52 3.2.2 Ligand-Based Drug Design (LBDD) 53 3.3 Bioinformatics Tools in Early Drug Discovery 54 3.3.1 Possible Biological Activity Prediction Tools 55 3.3.2 Possible Physicochemical and Drug-Likeness Properties Verification Tools 58 3.3.3 Possible Toxicity and ADME/T Profile Prediction Tools 60 3.4 Future Directions With Bioinformatics Tool 61 3.5 Conclusion 63 Acknowledgements 64 References 64 4 Role of Data Mining in Bioinformatics 69Vivek P. Chavda, Amit Sorathiya, Disha Valu and Swati Marwadi 4.1 Introduction 70 4.2 Data Mining Methods/Techniques 71 4.2.1 Classification 71 4.2.1.1 Statistical Techniques 71 4.2.1.2 Clustering Technique 73 4.2.1.3 Visualization 74 4.2.1.4 Induction Decision Tree Technique 74 4.2.1.5 Neural Network 75 4.2.1.6 Association Rule Technique 75 4.2.1.7 Classification 75 4.3 DNA Data Analysis 77 4.4 RNA Data Analysis 79 4.5 Protein Data Analysis 79 4.6 Biomedical Data Analysis 80 4.7 Conclusion and Future Prospects 81 References 81 5 In Silico Protein Design and Virtual Screening 85Vivek P. Chavda, Zeel Patel, Yashti Parmar and Disha Chavda 5.1 Introduction 86 5.2 Virtual Screening Process 88 5.2.1 Before Virtual Screening 90 5.2.2 General Process of Virtual Screening 90 5.2.2.1 Step 1 (The Establishment of the Receptor Model) 91 5.2.2.2 Step 2 (The Generation of Small-Molecule Libraries) 92 5.2.2.3 Step 3 (Molecular Docking) 92 5.2.2.4 Step 4 (Selection of Lead Protein Compounds) 94 5.3 Machine Learning and Scoring Functions 94 5.4 Conclusion and Future Prospects 95 References 96 6 New Bioinformatics Platform-Based Approach for Drug Design 101Vivek Chavda, Soham Sheta, Divyesh Changani and Disha Chavda 6.1 Introduction 102 6.2 Platform-Based Approach and Regulatory Perspective 104 6.3 Bioinformatics Tools and Computer-Aided Drug Design 107 6.4 Target Identification 109 6.5 Target Validation 110 6.6 Lead Identification and Optimization 111 6.7 High-Throughput Methods (HTM) 112 6.8 Conclusion and Future Prospects 114 References 115 7 Bioinformatics and Its Application Areas 121Ragini Bhardwaj, Mohit Sharma and Nikhil Agrawal 7.1 Introduction 121 7.2 Review of Bioinformatics 124 7.3 Bioinformatics Applications in Different Areas 126 7.3.1 Microbial Genome Application 126 7.3.2 Molecular Medicine 129 7.3.3 Agriculture 130 7.4 Conclusion 131 References 131 8 DNA Microarray Analysis: From Affymetrix CEL Files to Comparative Gene Expression 139Sandeep Kumar, Shruti Shandilya, Suman Kapila, Mohit Sharma and Nikhil Agrawal 8.1 Introduction 140 8.2 Data Processing 140 8.2.1 Installation of Workflow 140 8.2.2 Importing the Raw Data for Processing 141 8.2.3 Retrieving Sample Annotation of the Data 142 8.2.4 Quality Control 143 8.2.4.1 Boxplot 144 8.2.4.2 Density Histogram 145 8.2.4.3 MA Plot 145 8.2.4.4 NUSE Plot 145 8.2.4.5 RLE Plot 145 8.2.4.6 RNA Degradation Plot 145 8.2.4.7 QCstat 148 8.3 Normalization of Microarray Data Using the RMA Method 148 8.3.1 Background Correction 148 8.3.2 Normalization 149 8.3.3 Summarization 149 8.4 Statistical Analysis for Differential Gene Expression 151 8.5 Conclusion 153 References 153 9 Machine Learning in Bioinformatics 155Rahul Yadav, Mohit Sharma and Nikhil Agrawal 9.1 Introduction and Background 156 9.1.1 Bioinformatics 158 9.1.2 Text Mining 159 9.1.3 IoT Devices 159 9.2 Machine Learning Applications in Bioinformatics 159 9.3 Machine Learning Approaches 161 9.4 Conclusion and Closing Remarks 162 References 162 10 DNA-RNA Barcoding and Gene Sequencing 165Gifty Sawhney, Mohit Sharma and Nikhil Agrawal 10.1 Introduction 166 10.2 RNA 169 10.3 DNA Barcoding 172 10.3.1 Introduction 172 10.3.2 DNA Barcoding and Molecular Phylogeny 177 10.3.3 Ribosomal DNA (rDNA) of the Nuclear Genome (nuDNA)—ITS 178 10.3.4 Chloroplast DNA 180 10.3.5 Mitochondrial DNA 181 10.3.6 Molecular Phylogenetic Analysis 181 10.3.7 Metabarcoding 189 10.3.8 Materials for DNA Barcoding 190 10.4 Main Reasons of DNA Barcoding 191 10.5 Limitations/Restrictions of DNA Barcoding 192 10.6 RNA Barcoding 192 10.6.1 Overview of the Method 193 10.7 Methodology 194 10.7.1 Materials Required 195 10.7.2 Barcoded RNA Sequencing High-Level Mapping of Single-Neuron Projections 196 10.7.3 Using RNA to Trace Neurons 196 10.7.4 A Life Conservation Barcoder 198 10.7.5 Gene Sequencing 199 10.7.5.1 DNA Sequencing Methods 200 10.7.5.2 First-Generation Sequencing Techniques 204 10.7.5.3 Maxam’s and Gilbert’s Chemical Method 204 10.7.5.4 Sanger Sequencing 205 10.7.5.5 Automation in DNA Sequencing 206 10.7.5.6 Use of Fluorescent-Marked Primers and ddNTPs 206 10.7.5.7 Dye Terminator Sequencing 207 10.7.5.8 Using Capillary Electrophoresis 207 10.7.6 Developments and High-Throughput Methods in DNA Sequencing 208 10.7.7 Pyrosequencing Method 209 10.7.8 The Genome Sequencer 454 FLX System 210 10.7.9 Illumina/Solexa Genome Analyzer 210 10.7.10 Transition Sequencing Techniques 211 10.7.11 Ion-Torrent’s Semiconductor Sequencing 211 10.7.12 Helico’s Genetic Analysis Platform 211 10.7.13 Third-Generation Sequencing Techniques 212 10.8 Conclusion 212 Abbreviations 213 Acknowledgement 214 References 214 11 Bioinformatics in Cancer Detection 229Mohit Sharma, Umme Abiha, Parul Chugh, Balakumar Chandrasekaran and Nikhil Agrawal 11.1 Introduction 230 11.2 The Era of Bioinformatics in Cancer 230 11.3 Aid in Cancer Research via NCI 232 11.4 Application of Big Data in Developing Precision Medicine 233 11.5 Historical Perspective and Development 235 11.6 Bioinformatics-Based Approaches in the Study of Cancer 237 11.6.1 SLAMS 237 11.6.2 Module Maps 238 11.6.3 COPA 239 11.7 Conclusion and Future Challenges 240 References 240 12 Genomic Association of Polycystic Ovarian Syndrome: Single-Nucleotide Polymorphisms and Their Role in Disease Progression 245Gowtham Kumar Subbaraj and Sindhu Varghese 12.1 Introduction 246 12.2 FSHR Gene 252 12.3 IL-10 Gene 252 12.4 IRS-1 Gene 253 12.5 PCR Primers Used 254 12.6 Statistical Analysis 255 12.7 Conclusion 258 References 259 13 An Insight of Protein Structure Predictions Using Homology Modeling 265S. Muthumanickam, P. Boomi, R. Subashkumar, S. Palanisamy, A. Sudha, K. Anand, C. Balakumar, M. Saravanan, G. Poorani, Yao Wang, K. Vijayakumar and M. Syed Ali 13.1 Introduction 266 13.2 Homology Modeling Approach 268 13.2.1 Strategies for Homology Modeling 269 13.2.2 Procedure 269 13.3 Steps Involved in Homology Modeling 270 13.3.1 Template Identification 270 13.3.2 Sequence Alignment 271 13.3.3 Backbone Generation 271 13.3.4 Loop Modeling 271 13.3.5 Side Chain Modeling 272 13.3.6 Model Optimization 272 13.3.6.1 Model Validation 272 13.4 Tools Used for Homology Modeling 273 13.4.1 Robetta 273 13.4.2 M4T (Multiple Templates) 273 13.4.3 I-Tasser (Iterative Implementation of the Threading Assembly Refinement) 273 13.4.4 ModBase 274 13.4.5 Swiss Model 274 13.4.6 PHYRE2 (Protein Homology/Analogy Recognition Engine 2) 274 13.4.7 Modeller 274 13.4.8 Conclusion 275 Acknowledgement 275 References 275 14 Basic Concepts in Proteomics and Applications 279Jesudass Joseph Sahayarayan, A.S. Enogochitra and Murugesan Chandrasekaran 14.1 Introduction 280 14.2 Challenges on Proteomics 281 14.3 Proteomics Based on Gel 283 14.4 Non-Gel–Based Electrophoresis Method 284 14.5 Chromatography 284 14.6 Proteomics Based on Peptides 285 14.7 Stable Isotopic Labeling 286 14.8 Data Mining and Informatics 287 14.9 Applications of Proteomics 289 14.10 Future Scope 290 14.11 Conclusion 291 References 292 15 Prospects of Covalent Approaches in Drug Discovery: An Overview 295Balajee Ramachandran, Saravanan Muthupandian and Jeyakanthan Jeyaraman 15.1 Introduction 296 15.2 Covalent Inhibitors Against the Biological Target 297 15.3 Application of Physical Chemistry Concepts in Drug Designing 299 15.4 Docking Methodologies—An Overview 301 15.5 Importance of Covalent Targets 302 15.6 Recent Framework on the Existing Docking Protocols 303 15.7 SN2 Reactions in the Computational Approaches 304 15.8 Other Crucial Factors to Consider in the Covalent Docking 305 15.8.1 Role of Ionizable Residues 305 15.8.2 Charge Regulation 306 15.8.3 Charge-Charge Interactions 306 15.9 QM/MM Approaches 309 15.10 Conclusion and Remarks 310 Acknowledgements 311 References 311 Index 321

Read more less

Book SynopsisHANDBOOK ON INTERACTIVE STORYTELLING Discover the latest research on crafting compelling narratives in interactive entertainment Electronic games are no longer considered mere fluff alongside the real forms of entertainment, like film, music, and television. Instead, many games have evolved into an art form in their own right, including carefully constructed stories and engaging narratives enjoyed by millions of people around the world. In Handbook on Interactive Storytelling, readers will find a comprehensive discussion of the latest research covering the creation of interactive narratives that allow users to experience a dramatically compelling story that responds directly to their actions and choices. Systematically organized, with extensive bibliographies and academic exercises included in each chapter, the book offers readers new perspectives on existing research and fresh avenues ripe for further study. In-depth case studies explore the challenges involved in crafting a narrativeTable of ContentsList of Figures ix List of Tables xiii Preface xv Acknowledgements xvii 1 Introduction 1 1.1 Interactive Storytelling 3 1.1.1 Partakers 5 1.1.2 Narrative, Plot, and Story 6 1.1.3 Interaction 8 1.2 History of Interactive Storytelling 10 1.2.1 Theatre 11 1.2.2 Multicursal Literature 12 1.3 Role-playing Games 13 1.3.1 Hypertext Fiction 14 1.3.2 Webisodics 14 1.3.3 Interactive Cinema 15 1.3.4 Television 17 1.3.5 Games 17 1.3.5.1 Interactive Fiction 18 1.3.5.2 Digital Games 19 1.4 Summary 21 Exercises 22 2 Background 25 2.1 Analysis of Storytelling 25 2.1.1 Aristotle's Poetics 25 2.1.1.1 Elements of Tragedy 26 2.1.1.2 Narrative Forms 27 2.1.1.3 Dramatic Arc 27 2.1.2 Visual Storytelling 29 2.1.2.1 Semiotics 30 2.1.2.2 Work of Art 31 2.1.2.3 Video Games as Visual Art 31 2.1.3 Structuralism 33 2.1.3.1 Propp's Morphology of Russian Folktales 33 2.1.3.2 Colby's Grammar of Alaska Natives' Folktales 35 2.1.3.3 Story Grammars 37 2.1.4 Joseph Campbell and the Hero's Journey 41 2.1.5 Kernels and Satellites 42 2.2 Research on Interactive Storytelling 44 2.2.1 Brenda Laurel and Interactive Drama 46 2.2.2 Janet Murray and the Cyberbard 47 2.2.3 Models for Interactive Storytelling 48 2.2.4 Narrative Paradox and Other Research Challenges 49 2.2.4.1 Platform 52 2.2.4.2 Designer 52 2.2.4.3 Interactors 53 2.2.4.4 Storyworld 53 2.2.4.5 Terminology 53 2.3 Summary 54 Exercises 54 3 Platform 57 3.1 Software Development 58 3.1.1 Model-View-Controller 59 3.1.2 Interactor's Interface 61 3.1.3 Designer's Interface 63 3.1.4 Modding 63 3.2 Solving the Narrative Paradox 65 3.2.1 Author-centric Approach 66 3.2.2 Character-centric Approach 68 3.2.3 Hybrid Approach 69 3.3 Implementations 71 3.3.1 Pioneering Storytelling Systems 71 3.3.2 Crawford's IDS Systems 73 3.3.3 Stern's and Mateas's Façade 74 3.3.4 Experimental Systems 75 3.3.5 Other Systems 76 3.4 Summary 77 Exercises 78 4 Designer 81 4.1 Storyworld Types 82 4.1.1 Linear Storyworlds 83 4.1.2 Branching Storyworlds 84 4.1.3 Open Storyworlds 87 4.2 Design Process and Tools 89 4.2.1 Concepting the Storyworld 90 4.2.1.1 Character Design 92 4.2.1.2 Plot Composition 93 4.2.1.3 Adapting Material from Other Media 94 4.2.1.4 Transmedia Design 95 4.2.1.5 Adams' Template for Requirements Specifications 96 4.2.2 Iterative Design Process 97 4.2.3 Evaluating Interactive Stories 98 4.3 Relationship with the Interactor 100 4.3.1 Focalization 100 4.3.2 Story as Message 101 4.4 Summary 103 Exercises 103 5 Interactor 107 5.1 Experiencing an Interactive Story 108 5.1.1 Onboarding -- From Amnesia to Awareness 109 5.1.2 Supporting the Journey 110 5.1.3 Is There an End? 111 5.1.4 Re-experiencing an Interactive Story 112 5.2 Agency 113 5.2.1 Theoretical and Perceived Agency 114 5.2.2 Local and Global Agency 115 5.2.3 Invisible Agency 115 5.2.4 Limited Agency and No Agency 116 5.2.5 Illusion of Agency 116 5.3 Immersion 117 5.3.1 Immersion Types 117 5.3.2 Models for Immersion 118 5.3.3 Flow 119 5.4 Transformation 120 5.5 Interactor Types 121 5.5.1 Top-down Analysis 122 5.5.2 Bottom-up Analysis 124 5.5.3 Discussion 125 5.6 Summary 126 Exercises 126 6 Storyworld 131 6.1 Characters 132 6.1.1 Perception 133 6.1.2 Memory 133 6.1.3 Personality 135 6.1.4 Decision-making 138 6.2 Elemental Building Blocks 141 6.2.1 Props 141 6.2.1.1 Schrödinger's Gun 142 6.2.1.2 Internal Economy 143 6.2.2 Scenes 144 6.2.3 Events 144 6.3 Representation 145 6.3.1 Visual 147 6.3.2 Audio 148 6.3.2.1 Diegetic 148 6.3.2.2 Non-diegetic 149 6.4 Summary 150 Exercises 151 7 Perspectives 153 7.1 Multiple Interactors 153 7.1.1 Multiple Focus 153 7.1.2 Persistence 154 7.2 Extended Reality 155 7.2.1 Visual Considerations 155 7.2.2 Developing a Language of Expression 157 7.3 Streaming Media 157 7.3.1 Problems 157 7.3.2 Solution Proposals 159 7.4 Other Technological Prospects 160 7.4.1 Voice Recognition 160 7.4.2 Locating 160 7.4.3 Artificial Intelligence 161 7.5 Ethical Considerations 162 7.5.1 Platform 163 7.5.2 Designer 163 7.5.3 Interactor 164 7.5.4 Storyworld 164 7.6 Summary 165 Exercises 165 Bibliography 169 Ludography 187 Index 191

Read more less

Book SynopsisOrganizations can make data science a repeatable, predictable tool, which business professionals use to get more value from their data Enterprise data and AI projects are often scattershot, underbaked, siloed, and not adaptable to predictable business changes. As a result, the vast majority fail. These expensive quagmires can be avoided, and this book explains precisely how. Data science is emerging as a hands-on tool for not just data scientists, but business professionals as well. Managers, directors, IT leaders, and analysts must expand their use of data science capabilities for the organization to stay competitive. Smarter Data Science helps them achieve their enterprise-grade data projects and AI goals. It serves as a guide to building a robust and comprehensive information architecture program that enables sustainable and scalable AI deployments. When an organization manages its data effectively, its data science program becomes a fully scalaTable of ContentsForeword for Smarter Data Science xix Epigraph xxi Preamble xxiii Chapter 1 Climbing the AI Ladder 1 Readying Data for AI 2 Technology Focus Areas 3 Taking the Ladder Rung by Rung 4 Constantly Adapt to Retain Organizational Relevance 8 Data-Based Reasoning is Part and Parcel in the Modern Business 10 Toward the AI-Centric Organization 14 Summary 16 Chapter 2 Framing Part I: Considerations for Organizations Using AI 17 Data-Driven Decision-Making 18 Using Interrogatives to Gain Insight 19 The Trust Matrix 20 The Importance of Metrics and Human Insight 22 Democratizing Data and Data Science 23 Aye, a Prerequisite: Organizing Data Must Be a Forethought 26 Preventing Design Pitfalls 27 Facilitating the Winds of Change: How Organized Data Facilitates Reaction Time 29 Quae Quaestio (Question Everything) 30 Summary 32 Chapter 3 Framing Part II: Considerations for Working with Data and AI 35 Personalizing the Data Experience for Every User 36 Context Counts: Choosing the Right Way to Display Data 38 Ethnography: Improving Understanding Through Specialized Data 42 Data Governance and Data Quality 43 The Value of Decomposing Data 43 Providing Structure Through Data Governance 43 Curating Data for Training 45 Additional Considerations for Creating Value 45 Ontologies: A Means for Encapsulating Knowledge 46 Fairness, Trust, and Transparency in AI Outcomes 49 Accessible, Accurate, Curated, and Organized 52 Summary 54 Chapter 4 A Look Back on Analytics: More Than One Hammer 57 Been Here Before: Reviewing the Enterprise Data Warehouse 57 Drawbacks of the Traditional Data Warehouse 64 Paradigm Shift 68 Modern Analytical Environments: The Data Lake 69 By Contrast 71 Indigenous Data 72 Attributes of Difference 73 Elements of the Data Lake 75 The New Normal: Big Data is Now Normal Data 77 Liberation from the Rigidity of a Single Data Model 78 Streaming Data 78 Suitable Tools for the Task 78 Easier Accessibility 79 Reducing Costs 79 Scalability 79 Data Management and Data Governance for AI 80 Schema-on-Read vs. Schema-on-Write 81 Summary 84 Chapter 5 A Look Forward on Analytics: Not Everything Can Be a Nail 87 A Need for Organization 87 The Staging Zone 90 The Raw Zone 91 The Discovery and Exploration Zone 92 The Aligned Zone 93 The Harmonized Zone 98 The Curated Zone 100 Data Topologies 100 Zone Map 103 Data Pipelines 104 Data Topography 105 Expanding, Adding, Moving, and Removing Zones 107 Enabling the Zones 108 Ingestion 108 Data Governance 111 Data Storage and Retention 112 Data Processing 114 Data Access 116 Management and Monitoring 117 Metadata 118 Summary 119 Chapter 6 Addressing Operational Disciplines on the AI Ladder 121 A Passage of Time 122 Create 128 Stability 128 Barriers 129 Complexity 129 Execute 130 Ingestion 131 Visibility 132 Compliance 132 Operate 133 Quality 134 Reliance 135 Reusability 135 The xOps Trifecta: DevOps/MLOps, DataOps, and AIOps 136 DevOps/MLOps 137 DataOps 139 AIOps 142 Summary 144 Chapter 7 Maximizing the Use of Your Data: Being Value Driven 147 Toward a Value Chain 148 Chaining Through Correlation 152 Enabling Action 154 Expanding the Means to Act 155 Curation 156 Data Governance 159 Integrated Data Management 162 Onboarding 163 Organizing 164 Cataloging 166 Metadata 167 Preparing 168 Provisioning 169 Multi-Tenancy 170 Summary 173 Chapter 8 Valuing Data with Statistical Analysis and Enabling Meaningful Access 175 Deriving Value: Managing Data as an Asset 175 An Inexact Science 180 Accessibility to Data: Not All Users are Equal 183 Providing Self-Service to Data 184 Access: The Importance of Adding Controls 186 Ranking Datasets Using a Bottom-Up Approach for Data Governance 187 How Various Industries Use Data and AI 188 Benefi ting from Statistics 189 Summary 198 Chapter 9 Constructing for the Long-Term 199 The Need to Change Habits: Avoiding Hard-Coding 200 Overloading 201 Locked In 202 Ownership and Decomposition 204 Design to Avoid Change 204 Extending the Value of Data Through AI 206 Polyglot Persistence 208 Benefi ting from Data Literacy 213 Understanding a Topic 215 Skillsets 216 It’s All Metadata 218 The Right Data, in the Right Context, with the Right Interface 219 Summary 221 Chapter 10 A Journey’s End: An IA for AI 223 Development Efforts for AI 224 Essential Elements: Cloud-Based Computing, Data, and Analytics 228 Intersections: Compute Capacity and Storage Capacity 234 Analytic Intensity 237 Interoperability Across the Elements 238 Data Pipeline Flight Paths: Preflight, Inflight, Postflight 242 Data Management for the Data Puddle, Data Pond, and Data Lake 243 Driving Action: Context, Content, and Decision-Makers 245 Keep It Simple 248 The Silo is Dead; Long Live the Silo 250 Taxonomy: Organizing Data Zones 252 Capabilities for an Open Platform 256 Summary 260 Appendix Glossary of Terms 263 Index 269

Read more less