Jove
Visualize
Contact Us

Related Experiment Videos

Behavioral data management using Visual Basics for Applications to automate data capture and analysis.

Maurice L Sipos1, Richard E Sweeney

  • 1Advanced Assessment Branch, Drug Assessment Division, United States Army Medical Research Institute of Chemical Defense, Aberdeen Proving Ground, MD 21010, USA. maurice.sipos@us.army.mil

Journal of Neuroscience Methods
|September 2, 2003
PubMed
Summary
This summary is machine-generated.

Related Concept Videos

You might also read

Related Articles

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

Sort by
Same author

Positive and negative family communication and mental distress: Married service members during a non-combat deployment.

Family process·2023
Same author

Conjugates of human serum butyrylcholinesterase and nerve agents are behaviorally safe in rhesus macaques.

Chemico-biological interactions·2021
Same author

Mental Health Service Utilization and Perceived Barriers to Receiving Care in Deployed Soldiers.

Military medicine·2020
Same author

Determinants of mental and physical health treatment-seeking among military personnel.

The British journal of psychiatry : the journal of mental science·2019
Same author

U.S. Soldiers and Foreign Language School: Stressors and Health.

Military medicine·2019
Same author

Testing the effects of using a behavioral health provider to deliver a routine post-deployment assessment for soldiers returning from combat.

Psychological services·2018
Same journal

Time as the language of Behavior: events, sequences, patterns and meanings.

Journal of neuroscience methods·2026
Same journal

Detection of cochlear microphonic for differential diagnosis between auditory neuropathy mice and noise-induced sensorineural hearing loss mice.

Journal of neuroscience methods·2026
Same journal

Assessment metrics for pain control in rats: A methodological commentary.

Journal of neuroscience methods·2026
Same journal

Infant EEG preprocessing pipelines: A capability framework and current gaps in practice.

Journal of neuroscience methods·2026
Same journal

Methods for measuring neural activity during voluntary wheel running.

Journal of neuroscience methods·2026
Same journal

Serotype-dependent differences in AAV cellular transduction rates in the hypothalamus of Arctic ground squirrels.

Journal of neuroscience methods·2026
See all related articles
JoVE
x logofacebook logolinkedin logoyoutube logo
ABOUT JoVE
OverviewLeadershipBlogJoVE Help Center
AUTHORS
Publishing ProcessEditorial BoardScope & PoliciesPeer ReviewFAQSubmit
LIBRARIANS
TestimonialsSubscriptionsAccessResourcesLibrary Advisory BoardFAQ
RESEARCH
JoVE JournalMethods CollectionsJoVE Encyclopedia of ExperimentsArchive
EDUCATION
JoVE CoreJoVE BusinessJoVE Science EducationJoVE Lab ManualFaculty Resource CenterFaculty Site
Terms & Conditions of Use
Privacy Policy
Policies

Researchers can save time and reduce errors using custom Visual Basic for Applications (VBA) macros in Microsoft Excel for data management. These VBA macros automate repetitive tasks in data capture, analysis, and plotting for research protocols.

Area of Science:

  • Biomedical Research
  • Data Management
  • Scientific Computing

Background:

  • Microsoft Excel is widely used by researchers but its advanced capabilities, such as Visual Basic for Applications (VBA) macros, are often underutilized.
  • Repetitive data handling tasks in research can be time-consuming and prone to errors.

Purpose of the Study:

  • To demonstrate the implementation of customized VBA macros in Microsoft Excel for efficient research data management.
  • To reduce time and manpower required for data capture, analysis, and plotting.

Main Methods:

  • Development of "template" Excel workbooks with a
  • setup information
  • worksheet to define study parameters.
  • Implementation of VBA code triggered by control buttons to create subject/group worksheets and charts.

Related Experiment Videos

  • Utilizing a
  • pairmatch
  • function for random or variable-based group assignment.
  • VBA code to parse data files, calculate group averages, and automatically update charts.
  • Reformatting data into a
  • statistical output
  • worksheet for easy import into statistical software.

    • Main Results:

    • Significant savings in time and manpower for data management.
    • Reduced number of data entry errors.
    • Automated data analysis, plotting, and reformatting capabilities.
    • Consistent and up-to-date data visualization through automatic chart updates.

    Conclusions:

    • Customized VBA macros offer a powerful solution for automating repetitive data management tasks in research.
    • The implemented system streamlines data capture, analysis, and reporting, enhancing research efficiency and data reliability.
    • The approach is versatile and applicable to various study types, as demonstrated at USAMRICD.