Excel-VBA

This compact text is a powerful introduction to the Excel/VBA computing environment. The book presents some of the most useful features of Excel. First by introducing mathematical puzzles that will grab the reader's attention with the reader invited to think hard on solving those puzzles. Then, solutions are presented in a logical manner. The book goes on to describe modern and up-to-date engineering problems and their solutions. Based on many years of the authors' teaching, the book provides a practical, useful and enjoyable learning methods for readers to become expert in Excel and its application to engineering.

A fun introduction to the VBA engine for Excel for engineers

Takes readers from no knowledge of the VBA engine through the solving of puzzles to real engineering problems

Containing many worked examples, problems and solutions and with online material to help readers learn

Auteur

Professor Muneer is the co-ordinator of Chartered Institution of Building Services Engineers' Solar Data Task Group and in this capacity he has been involved in the production of the CIBSE Guides A & J for Weather and Solar Data. Professor Muneer has also been employed both by the government and industry as a consultant on a large number of engineering projects. Professor Muneer has been awarded several prestigious awards including the Royal Academy of Engineering Industrial Fellowship (2000-02), the Royal Academy of Engineering Engineers Secondment Overseas (1995), the Leverhulme Trust (1989) and the University College, Oxford/General Electric Company (1989) Research Fellowships. He is also the recipient of the Osmania University's Karamat Jung Gold Medal (1974), CIBSE Carter Bronze Medal (1990), CIBSE Napier Shaw Bronze Medal (1999), Millennium Commission's Fellowship Award (1999), Walsh-Weston (Society of Light & Lighting, London) Award (2002), Services to Industry Group's Proof of Concept award (2003) and the Scottish Green Energy, Highly Recommended Best Renewable Award (2006).Assoc. Prof. Dr. Stoyanka M. Ivanova currently is Head of the Department of Computer-Aided Engineering at the University of Architecture, Civil Engineering, and Geodesy - Sofia, Bulgaria. She does research in Solar architecture, Solar Radiance/Irradiance Models, Ecological Engineering and Computing. She is a member of the National Expert Council for nZEB. She has many years of experience in programming, works with numerous programming languages - BASIC, Pascal, Fortran, C / C++ / C#, Perl, JavaScript, VBA, VB.NET, PowerBasic, OpenGL. She has developed a variety of software - from software for sale, to software for engineering and architectural design, energy efficiency, software for websites, training software, etc. She has more than 32 years of experience in teaching programming with different languages, computer-aided engineering, three-dimensional geometric modeling for engineers, resource and energy efficiency and more.

Contenu
Chapter 1. Introduction Chapter 2. The development of computer spreadsheets.

Chapter 3. The Microsoft Excel/VBA computing and logic environment. Chapter 4. Mathematical and word-forming puzzles. Chapter 5. Engineering applications with examples and case studies.

Chapter 6. Computer-aided architecture: applications, examples and case studies. Chapter 7. Concluding remarks.