scholarly journals Teaching Spreadsheet-Based Numerical Analysis with Visual Basic for Applications and Virtual Instruments

2020 ◽  
Author(s):  
Nikunja Swain
Keyword(s):  
Numerical Analysis ◽  
Visual Basic ◽  
Virtual Instruments ◽  
Visual Basic For Applications

DEVELOPMENT OF AUTOMATED EVALUATION OF POSITIONING ACCURACY FOR SPECIALIZED NETWORKS’ POINTS IN TRILATERATION NETWORKS

2020 ◽  
Author(s):  
Мурат Газизович Мустафин ◽  
Глеб Андреевич Фролов
Keyword(s):  
Coordinate System ◽  
Visual Basic ◽  
Microsoft Excel ◽  
Positioning Accuracy ◽  
Automated Evaluation ◽  
Visual Basic For Applications ◽  
Multiple Configurations

В данной работе рассмотрен принцип работы созданного алгоритма, позволяющего автоматически определять среднюю квадратическую погрешность планового положения пунктов сетей трилатерации и представлены результаты автоматизации данного процесса при различных конфигурациях сети, с использованием пакетов Microsoft Excel, Visual Basic for Applications. This paper presents automatic solution for evaluating accuracy of positioning for specialized networks’ points in a plane coordinate system. The paper presents results of automation of this process through analysis of multiple configurations of trilateral networks using Microsoft Excel, Visual Basic for Applications.

scholarly journals Optimization of material delivery time analysis by using Visual Basic for applications in Excel

2021 ◽  
Vol 2 (2) ◽  
pp. 89
Author(s):  
Muhammad Ali Khan ◽  
Muhammad Ahmed Kalwar ◽  
Abdul Karim Chaudhry
Keyword(s):  
Small And Medium Enterprises ◽  
Visual Basic ◽  
Delivery Time ◽  
Time Analysis ◽  
Monthly Basis ◽  
Visual Basic For Applications ◽  
Manual Tasks ◽  
Medium Enterprises ◽  
Automated Methods ◽  
Planning Production

<p>In small and medium enterprises, huge numbers of reports are prepared regarding the procurement, planning, production etc on daily, weekly, monthly, quarterly and yearly basis. If the interval between preparation of same report is longer then there is the greater probability that employee can forget the procedure of preparing the report; thus it is beneficial to automate these types of reports especially when there is no cost required for automation. In the same way, material delivery analysis is a kind of report which is prepared on monthly basis and as per the employees` feedback they usually forget some of the steps of report formation; therefore, there was the chance of mistake at the end of employee. Therefore, this report was automated for to minimize the chance of error and report preparation time. All the manual tasks were enlisted and were programmed for automation by the help of VBA macros. For the execution of macros, userform was designed in visual basic editor (in MS excel) consisted on four command buttons and macros were called on command buttons` click. On pressing ‘ctrl + q’ userform used to appear on the screen. Furthermore, the comparison of old and automated methods was conducted to reflect the best suitable method. The report used to take 1.55 minutes to be made manually. Comparison of time of both methods of report formation indicated that suggested method took 70.86% less time as compared to the old method of preparing material delivery time analysis report.</p>

Controlling a Twister II with VBA and the Zymark ZyRobot ICP

2002 ◽  
Vol 7 (6) ◽  
pp. 92-95
Author(s):  
David S. Pechter
Keyword(s):  
Visual Basic ◽  
Normal Operation ◽  
Automated Measurement ◽  
Direct Control ◽  
Visual Basic For Applications

A Visual Basic for Applications program was developed for direct control of a Twister II robot using the Zymark ZyRobot_ICP. Direct control enables automated check-out of the robot, and automated measurement of the plate stacks prior to a robot run. Normal operation of the robot program is performed with just two buttons.

GESTÃO DE LAYOUT COM VISUAL BASIC FOR APPLICATIONS NA INTERFACE DO EXCEL

2020 ◽  
pp. 55-70
Author(s):  
Abel Hames ◽  
Elpidio Oscar Benitez Nara ◽  
Fabio Lorenzi da Silva ◽  
Rafael Nagel ◽  
Richard Silva Martins
Keyword(s):  
Visual Basic ◽  
Visual Basic For Applications

scholarly journals A Brunnstrom Stage Evaluation System with Fuzzy-Accelerometer

2019 ◽  
Vol 9 (18) ◽  
pp. 3718
Author(s):  
Te-Jen Su ◽  
Kun-Liang Lo ◽  
Jason Sheng-Hong Tsai ◽  
Wen-An Yeh ◽  
Cho- Feng Kuo
Keyword(s):  
Health Care ◽  
Medical Care ◽  
Evaluation System ◽  
Long Term Care ◽  
Physical Therapists ◽  
Visual Basic ◽  
Term Care ◽  
Visual Basic For Applications ◽  
Stroke Victim

Advances in medical care has reduced the rate of mortality from strokes, but the incidence of stroke has remained stable while the incidence of ministrokes has increased. Most stroke victims require long-term care, imposing a heavy financial and emotional burden on families while incurring a heavy cost to society. Thus, strokes are a key issue in the context of health care in Taiwan. This paper proposes using VBA (Visual Basic for Applications) to build a system for assessing Brunnstrom stages based on the observation of several obvious rehabilitation features The system calculates features for accelerometer readings, which are then used as input parameters for a fuzzy algorithm to obtain the Brunnstrom action level. Experimental results show the proposed approach effectively assesses Brunnstrom level, and that the approach can be used to assist physical therapists in performing longitudinal assessments of stroke victim progress, thus improving evaluation efficiency.

scholarly journals A VBA module simulation for finding optimal lag order in time series models and its use on teaching financial data computation

2020 ◽  
Vol ahead-of-print (ahead-of-print) ◽  
Author(s):  
Alan Mustafa ◽  
Abdulnasser Hatemi-J
Keyword(s):  
Dynamic Model ◽  
Information Criterion ◽  
Visual Basic ◽  
Financial Data ◽  
Data Series ◽  
Time Series Models ◽  
Microsoft Excel ◽  
Step Process ◽  
Visual Basic For Applications ◽  
Multiple Variables

In this study, a tool has been designed and developed for learning about the concept of lag order within a dynamic model, which can be used in any teaching classes on statistics and financial data computation. To show a solution for a complex and multi-step process of finding the optimal lag order for multiple variables data series based on an information criterion a module using Visual Basic for Applications (VBA) for Microsoft Excel (MS Excel) is being developed. This module can be used for estimating a multivariate dynamic model as well as determining the optimal lag order of such a model.

Modeling the Behavior of a 50 MW Direct Steam Generation Plant for Southern Libya Based on the Thermodynamic and Thermophysical Properties of Water Substance

2012 ◽  
Vol 134 (4) ◽  
Author(s):  
Y. Aldali ◽  
B. Davison ◽  
T. Muneer ◽  
D. Henderson
Keyword(s):  
Software Tool ◽  
Visual Basic ◽  
Steam Generation ◽  
Construction Costs ◽  
Microsoft Excel ◽  
Solar Fraction ◽  
Visual Basic For Applications ◽  
Generation Plant ◽  
Direct Steam ◽  
Plant Capacity

This paper presents arguments for the use of direct steam generation (DSG) in preference to other forms of generation in particular locations according to the prevailing environmental and economic conditions. In addition, the paper describes the development of a software tool based on Microsoft Excel and Visual Basic for Applications (VBA), which draws upon established physical relationships in the heat transfer literature to perform plant capacity calculations in a fast and convenient manner. The results of the VBA program determine the solar fraction of the plant, assuming that the plant is in operation for 10 h per day (07:30–17:30 hours), the solar fraction is shown to be 76% and the DSG plant achieves a 76% reduction in emissions. Construction costs are also estimated based on formulae from previous work.

Sign in / Sign up

Export Citation Format

Share Document