Muneer Tariq, Ivanova Stoyanka. Excel-VBA - From Solving Mathematical Puzzles to Analysing Complex Engineering Problems

Springer, Cham, 2022. — 170 p. — ISBN 978-3-030-94085-0.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.Games and PuzzlesNumerical Analysis
Error Analysis Using Chauvenet’s TechniqueComputer Graphics in Excel
Computer Graphics with MS Excel and VBA
Geometric Calculations with VBA
Geometric Transformations of Objects in the PlaneDynamics
Comparison of ICE and BEV
Regenerative Braking Offered by BEV
Factors That Affect Energy Consumption of BEV
Driving Cycles
The Vehicle Dynamic and Energy Consumption (VEDEC) Simulation Equations
Supporting Software
Validation of Simulations
MS Excel-VBA Functions in VEDEC Simulation SoftwareThermodynamicsSolar EnergyHeat Transfer and View Factors
Heat Transfer—Introduction
Heat Transfer and View Factors
View Factor Algebra
View Factor Between Two Surfaces with a Common Edge
View Factor from a Sloped Surface with Infinite Width
Infinite Uniform Horizon
View Factor from a Sloped Surface with Finite Width to Infinite Uniform Horizon
View Factor for Generalized Inclined-Rectangle Arrangement
View Factor Between Two Parallel Surfaces
View Factor Between Two Parallel Surfaces with Infinite Width and Finite Height
View Factor Between Two Directly Opposite Parallel Rectangles with Equal Size
View Factor for Generalized Parallel Rectangles
ArrangementArtificial Neural Networks in Excel
Introduction to Artificial Neural Networks
Principle of ANN Training with Back Propagation
Features of the Use of ANN. Areas of Application
Neural Network with One Hidden Layer in VBA for Regression Analysis
Preparation of the Complete Neural Network Training Database
Dividing the Complete Neural Network Training Database into Two Parts
Neural Network Training
Improving the Algorithm for Training of ANN
Use of a Trained Neural NetworkFluid Mechanics