With Visual Basic for Applications (VBA) programming, you can take advantage of numerous Excel options such as: creating new worksheet functions; automating tasks and operations; creating new appearances, toolbars, and menus; designing custom dialog boxes and add-ins; and much more. This guide is not for rank Excel amateurs. It-s for intermediate to advanced Excel users who want to learn VBA programming (or whose bosses want them to learn VBA programming). You need to know your way around Excel before you start creating customized short cuts or systems for speeding through Excel functions. If you-re an intermediate or advanced Excel user, Excel VBA For Dummies helps you take your skills (and your spreadsheets) to the next level. It includes: An introduction to the VBA language A hands-on, guided, step-by-step walk through developing a useful VBA macro, including recording, testing, and changing it, and testing it The essential foundation, including the Visual Basic Editor (VBE) and its components, modules, Excel object model, subroutines and functions, and the Excel macro recorder The essential VBA language elements, including comments, variables and constants, and labels Working with Range objects and discovering useful Range objective properties and methods Using VBA and worksheet functions, including a list and examples Programming constructions, including the GoTo statement, the If-Then structure, Select Case, For-Next loop, Do-While loop, and Do-Until loop Automatic procedures and Workbook events, including a table and event-handler procedures Error-handling and bug extermination techniques, and using the Excel debugging tools Creating custom dialog boxes, also known as UserForms, with a table of the toolbox controls and their capabilities, how-to for the dialog box controls, and UserForm techniques and tricks Customizing the Excel toolbars Using VBA code to modify the Excel menu system Creating worksheet functions and working with various types of arguments Creating Excel add-ins such as new worksheet functions you can use in formulas or new commands or utilities Author John Walkenbach is a leading authority on spreadsheet software and the author of more than 40 spreadsheet books including Excel 2003 Bible and Excel 2003 Power Programming with VBA. While this guide includes tons of examples and screenshots, Walkenbach knows there-s no substitute for hands-on learning. The book is complete with: A dedicated companion Web site that includes bonus chapters plus all sample programs to save you a lot of typing and let you play around and experiment with various changes Information to help you make the most of Excel-s built-in Help system so you can find out other stuff you may need to know What are you waiting for? Sure, learning to do VBA programming takes a little effort, but it-s a Very Big Accomplishment.

    It describes conventional and unconventional methods of electricity generation and its economics, distribution methods, substation location, electric drives, high frequency power for induction and heating, illumination engineering, and electric traction. Each chapter contains illustrative worked problems, exercises (some with answers) and a bibliography.

    

    Annotation (c) Book News, Inc., P

    It guides you step by step from simple tests to tests that are maintainable, readable, and trustworthy. It covers advanced subjects like mocks, stubs, and frameworks such as Typemock Isolator and Rhino Mocks. And you'll learn about advanced test patterns and organization, working with legacy code and even untestable code. The book discusses tools you need when testing databases and other technologies. It's written for .NET developers but others will also benefit from this book.Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.Table of ContentsThe basics of unit testingA first unit testUsing stubs to break dependenciesInteraction testing using mock objectsIsolation (mock object) frameworksTest hierarchies and organizationThe pillars of good testsIntegrating unit testing into the organizationWorking with legacy code

    In this book, author Gojko Adzic distills interviews with successful teams worldwide, sharing how they specify, develop, and deliver software, without defects, in short iterative delivery cycles.About the Technology Specification by Example is a collaborative method for specifying requirements and tests. Seven patterns, fully explored in this book, are key to making the method effective. The method has four main benefits: it produces living, reliable documentation; it defines expectations clearly and makes validation efficient; it reduces rework; and, above all, it assures delivery teams and business stakeholders that the software that's built is right for its purpose.About the Book This book distills from the experience of leading teams worldwide effective ways to specify, test, and deliver software in short, iterative delivery cycles. Case studies in this book range from small web startups to large financial institutions, working in many processes including XP, Scrum, and Kanban.This book is written for developers, testers, analysts, and business people working together to build great software.Purchase of the print book comes with an offer of a free PDF, ePub, and Kindle eBook from Manning. Also available is all code from the book.What's InsideCommon process patterns How to avoid bad practices Fitting SBE in your process 50+ case studies For additional resources go to specificationbyexample.com.

    But Neil Armstrong and Sally Ride would have never made history, and humankind would not have touched the stars, if not for the men and women on the ground who lit the fuse that launched the first rockets.Enthralled as a boy by the exploits of Flash Gordon and the novels of Robert Heinlein and Arthur C. Clarke—who put the science in science fiction—James French became one of the original unsung engineers of America’s groundbreaking space program. His fascinating memoir offers an up-close-and-technical look at building, testing, and perfecting the pioneering Saturn rockets and original lunar landing module, and he shares true tales, both humorous and harrowing, of life—and near death—on the front lines of scientific exploration.If you’ve ever said, “It’s not rocket science,” you’re right. It’s rocket engineering—and here’s your chance to marvel at how it changed the world and made it possible to explore all that lies beyond Earth. James R French graduated from MIT in 1958 with a degree of BSME Specializing in Propulsion. His first job was with Rocketdyne Division of North American Aviation where he worked on developmental testing of H-1 engines and combustion devices hardware for F-1 and J-2 engines used in Saturn 5. Mr. French has also worked at TRW Systems, where he was Lead Development Test Engineer on the Lunar Module Descent Engine, and Jet Propulsion Laboratory where he was Advanced Planetary studies Manager as well as Chief Engineer for the SP-100 Space Nuclear Power System and worked on Mariners 5, 6, 7, 8, and 9; Viking 1 & 2 and Voyager 1 & 2. . In 1986, he helped found American Rocket Co., a commercial launch company.Since 1987, Mr. French has been consultant to a variety of aerospace companies, SDIO, NASA, and USAF. He has participated in various startup companies in the private space flight arena and currently consults extensively to Blue Origin. Mr. French is co-author with Dr. Michael Griffin of the best-selling text Space Vehicle Design, published by AIAA. The second edition of the book has received the Summerfield Book Award for 2008. Mr. French is a Fellow of both AIAA and the British Interplanetary Society and a 50+ year member of AIAA. He has held several Technical Committee and other posts in AIAA. Cover design by Evan Twohy

    Get the most out of BDD in Ruby with The RSpec Book, written by the lead developer of RSpec, David Chelimsky. You'll get started right away with RSpec 2 and Cucumber by developing a simple game, using Cucumber to express high-level requirements in language your customer understands, and RSpec to express more granular requirements that focus on the behavior of individual objects in the system. You'll learn how to use test doubles (mocks and stubs) to control the environment and focus the RSpec examples on one object at a time, and how to customize RSpec to "speak" in the language of your domain. You'll develop Rails 3 applications and use companion tools such as Webrat and Selenium to express requirements for web applications both in memory and in the browser. And you'll learn to specify Rails views, controllers, and models, each in complete isolation from the other. Whether you're developing applications, frameworks, or the libraries that power them, The RSpec Book will help you write better code, better tests, and deliver better software to happier users.

    This well-established two-book course is designed for class teaching and private study leading to GCSE examinations in mathematics and further Mathematics at A Level.

    Software Craftsmanship transcends software engineering, demonstrating that quality software can't simply be manufactured: it must be built by craftspeople with pride in their work, and a personal commitment to excellence. In Software Craftsmanship, Pete McBreen focuses on the craft of software development, explaining why current software engineering techniques often fail, and offering programmers a new path to excellence. Just as the modern carpenter benefits from better tools, materials, and understanding, the modern programmer can benefit from better computers, reusable components, and more robust languages -- but only if he or she is prepared to treat the software profession as a true craft. McBreen explains what software craftsmanship means, how its affects users, and how it changes the developer's relationship with customers. He introduces the concepts of software apprentices and journeymen, shows what can (and can't) be learned from the software engineering movement, and presents specific steps you can take now to move towards craftsmanship in your work -- and your organization.

    The first edition of this book, Programming Perl, hit the shelves in 1990, and was quickly adopted as the undisputed bible of the language. Since then, Perl has grown with the times, and so has this book.Programming Perl is not just a book about Perl. It is also a unique introduction to the language and its culture, as one might expect only from its authors. Larry Wall is the inventor of Perl, and provides a unique perspective on the evolution of Perl and its future direction. Tom Christiansen was one of the first champions of the language, and lives and breathes the complexities of Perl internals as few other mortals do. Jon Orwant is the editor of The Perl Journal, which has brought together the Perl community as a common forum for new developments in Perl.Any Perl book can show the syntax of Perl's functions, but only this one is a comprehensive guide to all the nooks and crannies of the language. Any Perl book can explain typeglobs, pseudohashes, and closures, but only this one shows how they really work. Any Perl book can say that my is faster than local, but only this one explains why. Any Perl book can have a title, but only this book is affectionately known by all Perl programmers as "The Camel."This third edition of Programming Perl has been expanded to cover version 5.6 of this maturing language. New topics include threading, the compiler, Unicode, and other new features that have been added since the previous edition.

    Written for the engineer as well as the race car enthusiast, the authors, who developed many of the original vehicle dynamics theories and principles covered in this book, including the Moment Method, pair analysis and lap time simulation, include much information that is not available in any other vehicle dynamics text.

    It then builds systematically to cover all the steps involved in writing, testing, and debugging assembly programs. It also provides valuable how-to information on using procedures and macros. The only guide to assembly programming covering both DOS and Linux, the book presents working example programs for both operating system, and introduces Conditional Assembly -- a technique for assembling for both DOS and Linux systems from a single source file.

    Updated to cover the new Transportation and Structural codes. As the most comprehensive reference and study guide available for engineers preparing for the morning and afternoon topics on the Civil PE exam, the 11th edition of the Civil Engineering Reference Manual provides a concentrated review of the exam topics. No other exam-focused publication is more complete. The Most Trusted Reference for the Civil PE Exam is also the Most Up-To-Date A complete introduction to the exam format and content A suggested study schedule, plus tips for successful exam preparation Nearly 500 solved example problems Hundreds of key tables, charts, and figures at your fingertips An easy-to-use index and full glossary for quick reference Perfect for post-exam reference What's New in the 11th Edition 4 new construction engineering chapters Over 35 updated chapters—including extensively revised structural and transportation chapters 100 new equations Over 300 new, easy-to-use index entriesExam Topics CoveredConstruction—NewGeotechnical—UpdatedStructural—UpdatedTransportation—UpdatedWater Resources & Environmental—Updated_____________________________Since 1975 more than 2 million people preparing for their engineering, surveying, architecture, LEED®, interior design, and landscape architecture exams have entrusted their exam prep to PPI. For more information, visit us at www.ppi2pass.com.

    An illustration program supports the concepts and theories discussed.