Programming Excel with VBA

Morgado, Flavio

doi:10.1007/978-1-4842-2205-8

Cited by 3 publications

(2 citation statements)

References 0 publications

Supporting

Mentioning

Contrasting

Order By: Relevance

“…The VBA code read the maximum and minimum deflections to determine the warpage index. To read and write to the ADPL file, the VBA functions for the text operations were intensively utilized [ 31 ]. Whenever the human engagement was required, the excel VBA paused the run and waited for the input, popping up a dialog box.…”

Section: Methodsmentioning

confidence: 99%

Optimal Dummy Pattern Design Method for PWB Warpage Control Using the Human-Based Genetic Algorithm

Kim¹,

Lee²

2020

Micromachines

View full text Add to dashboard Cite

In this work, a method that minimizes printed wiring board (PWB) warpage by dummy pattern design is proposed. This work suggests that dummy patterns are placed on a preset discretized location in the PWB to reduce the warpage. On each discretized candidate area, the dummy pattern can be set or unset. The warpage is numerically simulated based on direct modeling of the as-is PWB patterns to evaluate the warpage alongside the dummy pattern design set. The optimal pattern that minimizes warpage is determined using the human-based genetic algorithm where the objective function is evaluated by the structural simulation. The optimization method is realized in a spreadsheet that allows scripting language with which the input and output files of the simulation tool can be modified and read. Two different cases have been tested and the results show that the method can determine the optimal dummy patterns. The measured and simulated deflections agree well with each other. Moreover, it has been shown that certain dummy pattern designs that should reduce the warpage can be sought by the optimization.

show abstract

Section: Methodsmentioning

confidence: 99%

Optimal Dummy Pattern Design Method for PWB Warpage Control Using the Human-Based Genetic Algorithm

Kim¹,

Lee²

2020

Micromachines

View full text Add to dashboard Cite

show abstract

“…The implementation of Excel Rbox Client concerns both the creation and dispatch of the HTTP request to the Apache Web server, as well as the end‐user interface. The implementation first focuses on transforming the data into JSON format and then on the construction of the HTTP Request to Rbox using VBA (Visual Basic for Applications) [30]. More specifically, a worksheet called “rtemplates” contains generic templates of the JSON structure for each statistical test or graph.…”

Section: The Rbox Integrationmentioning

confidence: 99%

Rbox: A web API for software integration with the R programming language

Konomos

Chountasis²

2023

Comp Applic In Engineering

View full text Add to dashboard Cite

This paper presents an inventive software interface for the integration of some extensively used information systems with the R programming environment. The contribution of this paper is two‐fold. First, a more comprehensive and specialized data analysis tool is provided. Second, a notable software code analysis model has been proposed to perform statistical tests and execute machine learning algorithms using the capabilities of the R programming language. The recommended application programming interface is successfully tested and evaluated based on a real‐life data set. The obtained results verify the high computing performance of the model in terms of the execution proceedings and achieved objectives.

show abstract

Computer-Aided Selection of Participatory Design Methods

Bojko

Riedel

Tawalbeh³

2019

IFIP Advances in Information and Communication Technology

View full text Add to dashboard Cite

The activities to introduce Industry 4.0 and Digitalization into manufacturing environments imply a multitude of new systems and technologies which change work environments and tasks that are existing there up to now. In order to cope with the increasing complexity, employees in production must be transferred into knowledge workers. This requires new approaches of work organization, training and education, and the active involvement of employees in shaping future workplaces and processes. To achieve these goals new approaches and methods for collaborative design and reorganization of workplaces and processes involving employees by means of participatory design need to be developed and implemented. Due to the large number of available methods, targeted support for the workers is required for selecting suitable methods. In this paper, the motivation and reasons to use participatory design are explained, an approach to support method selection is developed, and a computer-aided selection procedure for empowering the responsible persons on the shop floors is presented. Following, this is the basis for applications in an industrial context, where the solution can be validated and improved based on practical experiences.

show abstract

Programming Excel with VBA

Cited by 3 publications

References 0 publications

Optimal Dummy Pattern Design Method for PWB Warpage Control Using the Human-Based Genetic Algorithm

Optimal Dummy Pattern Design Method for PWB Warpage Control Using the Human-Based Genetic Algorithm

Rbox: A web API for software integration with the R programming language

Computer-Aided Selection of Participatory Design Methods

Contact Info

Product

Resources

About