China 
Africa 
Explore chapters and articles related to this topic
Prerequisites
Published in S. Can Gülen, Gas Turbine Combined Cycle Power Plants, 2019
The last one is extremely popular among the younger generation – students and practitioners. Even though the author has not had extensive experience with it, he is aware that it is a very simple and powerful tool for computational purposes. The most beneficial one, in this author’s opinion of course, which is also quite easy to learn and implement, is Visual Basic. In particular, VBA (Visual Basic for Applications) is the programming language of Excel and other Microsoft Office programs. (It is highly unlikely that the reader of this book does not have access to MS Office and Excel through his organization or on his or her own.) If you are not already familiar with VBA, you can get started by automating tasks in Excel by using the Macro feature, which, essentially records a sequence of your Excel spreadsheet actions in a VB function.
.NET, ActiveX, and COM
Published in Rick Bitter, Taqi Mohiuddin, Matt Nawrocki, LabVIEW™ Advanced Programming Techniques, 2017
Rick Bitter, Taqi Mohiuddin, Matt Nawrocki
This example will give a brief overview of programming Microsoft Word through LabVIEW. Microsoft Office is designed to be programmable and extensible through Visual Basic for Applications (VBA). Complete coverage of all of Word’s automation abilities is well beyond the scope of this book, but we will try to give you a starting point for using Microsoft Word to add to your current applications. Controlling any of the components of Microsoft Office is not true ActiveX programming; it is actually OLE Automation.
Inverse analysis for rock mechanics based on a high dimensional model representation
Published in Inverse Problems in Science and Engineering, 2021
The optimization method is the key component and influences the efficiency and accuracy of the inverse analysis. Excel solver is a powerful and general-purpose optimization tool. It has a user-friendly interface, and the problem of setting-up is straightforward. Excel also provides a visual development language named Visual Basic for Applications (VBA). It makes it easy to call Excel solver in code and to solve various optimization problems with spreadsheets. Excel solver provides different optimization algorithms such as simplex optimization, gradient optimization, nonlinear programming, evolutionary algorithm, etc. Meanwhile, Excel solver is easy to employ in the inverse analysis to improve practicability [17]. Compared with other optimization methods such as genetic algorithm, particle swarm optimization, etc., it is easier to learn, and also it can reduce a lot of algorithm analysis and code debugging. More importantly, Excel solver has good adaptability and is convenient for solving various optimization problems. In this study, it was adopted to determine the mechanical parameters of rock mass for the inverse analysis.