Search research articles

ABOUT JoVE

Overview Leadership Blog JoVE Help Center

AUTHORS

Publishing Process Editorial Board Scope & Policies Peer Review FAQ Submit

LIBRARIANS

Testimonials Subscriptions Access Resources Library Advisory Board FAQ

RESEARCH

JoVE Journal Methods Collections JoVE Encyclopedia of Experiments Archive

EDUCATION

JoVE Core JoVE Business JoVE Science Education JoVE Lab Manual Faculty Resource Center Faculty Site

Terms & Conditions of Use

Related Concept Videos

Overview of Microsoft Excel as a Data Analysis Tool

Overview of Microsoft Excel as a Data Analysis Tool

Microsoft Excel is a cornerstone tool for data analysis and statistical operations, offering a wide array of functionalities to manage, analyze, and visualize data efficiently. Recognized for its versatility, Excel facilitates the performance of basic to complex statistical operations, serving as an indispensable asset for analysts, researchers, and students alike. Excel's significance in data analysis emanates from its spreadsheet environment, where data can be organized in rows and columns,...

Performing a Simple Data Analysis using MS-Excel Function

Performing a Simple Data Analysis using MS-Excel Function

Microsoft Excel offers a suite of functions and tools ideal for statistical analysis, making it accessible to students and researchers. This article outlines fundamental Excel functions pivotal for data analysis.
SUM: This function calculates the total sum of a range of values. It's the foundation for aggregating data, essential for determining overall trends and totals in datasets.
AVERAGE: It computes the mean value of a given set of numbers, providing a quick insight into the central...

Control Systems: Applications

Control Systems: Applications

Electrical engineering plays a pivotal role in our daily lives, with control systems at the heart of many applications, from home appliances to sophisticated space shuttles. Control systems manage and regulate the behavior of devices and processes, ensuring they function safely, correctly, and efficiently.
In modern vehicles, control systems manage various functions to enhance performance and safety. The steering wheel and accelerator are primary inputs in a car's control system. The direction...

Open and closed-loop control systems

Open and closed-loop control systems

Control systems are foundational elements in automation and engineering. They are broadly categorized into open-loop and closed-loop systems. These classifications hinge on the presence or absence of feedback mechanisms, significantly influencing the system's performance, complexity, and application.
An open-loop control system operates without feedback from the output. It consists of two primary elements: the controller and the controlled process. The controller receives an input signal and...

Electro-mechanical Systems

Electro-mechanical Systems

Electromechanical systems are intricate configurations that effectively combine electrical and mechanical elements to achieve a desired outcome. Central to many of these systems is the DC motor, a device that converts electrical energy into mechanical motion, enabling various applications ranging from simple fans to complex robotic mechanisms.
A key component of the DC motor is the armature, a rotating circuit positioned within a magnetic field. As an electric current passes through the...

Control Systems

Control Systems

Control systems are everywhere in contemporary society, influencing diverse applications from aerospace to automated manufacturing. These systems can be found naturally within biological processes, such as blood sugar regulation and heart rate adjustment in response to stress, as well as in man-made systems like elevators and automated vehicles. A control system is essentially a network of subsystems and processes that collaboratively convert specific inputs into desired outputs.
At the heart...

You might also read

Related Articles

Articles linked to this work by shared authors, journal, and citation graph.

Sort by

Same author

Web and MATLAB-Based Platform for UAV Flight Management and Multispectral Image Processing.

Sensors (Basel, Switzerland)·2022

Same author

Dataset Construction from Naturalistic Driving in Roundabouts.

Sensors (Basel, Switzerland)·2020

Same author

Think Aloud Protocol Applied in Naturalistic Driving for Driving Rules Generation.

Sensors (Basel, Switzerland)·2020

Same author

Machine Learning Techniques for Undertaking Roundabouts in Autonomous Driving.

Sensors (Basel, Switzerland)·2019

Same author

A system for traffic violation detection.

Sensors (Basel, Switzerland)·2014

Search research articles

Related Experiment Video

Updated: Jun 13, 2026

A Computer-assisted Multi-electrode Patch-clamp System

A Computer-assisted Multi-electrode Patch-clamp System

Published on: October 18, 2013

Data acquisition and real-time control using spreadsheets: interfacing Excel with external hardware.

Nourdine Aliane¹

¹Dpto: Sistemas Informáticos y Automática, Universidad Europea de Madrid, Villaviciosa de Odón, Madrid 28670, Spain. nourdine.aliane@uem.es

ISA Transactions

|April 28, 2010

Summary

This study demonstrates using Excel spreadsheets and Visual Basic for Applications (VBA) for engineering calculations, data acquisition, and real-time control. Two interactive applications were developed for introductory control courses.

More Related Videos

Performing Behavioral Tasks in Subjects with Intracranial Electrodes

Performing Behavioral Tasks in Subjects with Intracranial Electrodes

Published on: October 2, 2014

Combining Multiple Data Acquisition Systems to Study Corticospinal Output and Multi-segment Biomechanics

Combining Multiple Data Acquisition Systems to Study Corticospinal Output and Multi-segment Biomechanics

Published on: January 9, 2016

Related Experiment Videos

Last Updated: Jun 13, 2026

A Computer-assisted Multi-electrode Patch-clamp System

A Computer-assisted Multi-electrode Patch-clamp System

Published on: October 18, 2013

Performing Behavioral Tasks in Subjects with Intracranial Electrodes

Performing Behavioral Tasks in Subjects with Intracranial Electrodes

Published on: October 2, 2014

Combining Multiple Data Acquisition Systems to Study Corticospinal Output and Multi-segment Biomechanics

Combining Multiple Data Acquisition Systems to Study Corticospinal Output and Multi-segment Biomechanics

Published on: January 9, 2016

Area of Science:

Engineering Education
Computational Tools

Background:

Spreadsheets are widely used for engineering calculations.
Spreadsheets can be extended with macro languages like Visual Basic for Applications (VBA).

Purpose of the Study:

To demonstrate the use of Excel and VBA for data acquisition and real-time control.
To present practical applications for introductory control courses.

Main Methods:

Utilizing Excel spreadsheets for computational tasks.
Employing Visual Basic for Applications (VBA) for programming add-ins.
Developing interactive user interfaces within Excel.

Main Results:

Successful implementation of data acquisition and real-time control using Excel and VBA.
Creation of two functional Excel applications for laboratory demonstrations.
Enhanced capabilities of spreadsheets through custom add-ins.

Conclusions:

Excel and VBA provide a powerful and accessible platform for engineering computations and control systems.
These tools can effectively support laboratory experiments and learning in introductory control courses.