Because the analysis of copious amounts of data and the preparation of custom reports often take away time from true research, the automation of these processes is paramount to ensure productivity. Exploring the core areas of automation, report generation, data acquisition, and data analysis, Automated Data Analysis Using Excel illustrates how to minimize user intervention, automate parameter setup, obtain consistency in both analysis and reporting, and save time through automation. Focusing on the built-in Visual Basic® for Applications (VBA) scripting language of Excel®, the book shows step-by-step how to construct useful automated data analysis applications for both industrial and academic settings. It begins by discussing fundamental elements, the methods for importing and accessing data, and the creation of reports. The author then describes how to use Excel to obtain data from non-native sources, such as databases and third-party calculation tools. After providing the means to access any required information, the book explains how to automate manipulations and calculations on the acquired data sources. Collecting all of the concepts previously discussed in the book, the final chapter demonstrates from beginning to end how to create a cohesive, robust application. With an understanding of this book, readers should be able to construct applications that can import data from a variety of sources, apply algorithms to data that has been imported, and create meaningful reports based on the results.

If youre new to After Effects and want to get up to speed quickly, After Effects Apprentice was created just for you. With 11 core lessons plus a fun final project, youll quickly get into the program and learn how to tap its potential whether you want to create motion graphics for a network program, your companys video, or your own independent production.In this book, youll get a professional perspective on the most important features a motion graphics artist needs to learn to use this program effectively. Youll learn to creatively edit and combine layers, animate eye-catching titles, replace a screen on a computer monitor, place a studio shot in anew environment, manipulate 3D space, and use effects to generate excitement or enhance the realism of a scene. Easy to follow step-by-step instructions take you through each technique, including projects that encourage you to express it in your own way. Youll learn more than just the tools; youll learn skills that you can immediately put to work in your own projects.

Satellite navigation receivers are used to receive, process, and decode space-based navigation signals, such as those provided by the GPS constellation of satellites. There is an increasing need for a unified open platform that will enable enhanced receiver development and design, as well as cost-effective testing procedures for various applications. This book and companion DVD provide hands-on exploration of new technologies in this rapidly growing field.

One of the unique features of the work is the interactive approach used, giving readers the ability to construct their own Global Navigation Satellite Systems (GNSS) receivers. To construct such a reconfigurable receiver with a wide range of applications, the authors discuss receiver architecture based on software-defined radio (SDR) techniques. The presentation unfolds in a systematic, user-friendly style and goes from the basics to cutting-edge research.