Spirometry Longitudinal Data Analysis Software

1. SPIROLA enables the user to monitor group means for (FEV₁) and (FVC) and in relation to mean predicted values based on group demographics (age, height, gender, ethnicity/race).
2. SPIROLA enables the user to monitor the precision of longitudinal spirometry data for a group of participants (Figure). This function helps in assuring that data precision remains acceptable over time, and provides an appropriate basis upon which to determine a limit of longitudinal decline (LLD) for use as a criterion to evaluate longitudinal decline.

1. SPIROLA enables the user to identify for further evaluation individuals whose most recent spirometry test results are below LLN values or who may experience excessive decline in FEV₁ or FVC. The selection criteria are based on published reference values and can be modified by the user (Figure).
2. SPIROLA enables the user to tag identified individuals for further spirometry evaluation such as spirometry quality control or retesting (Figure).

1. SPIROLA’s intervention module enables the user to develop a comprehensive intervention program for respiratory disease prevention for a group of workers and to implement the intervention plan in individuals (Example, Figure).
2. SPIROLA enables the user to monitor and evaluate the implementation of intervention for individuals and for a group of workers.

1. SPIROLA V3.0 enables the user to conduct an electronic questionnaire survey for respiratory symptoms, occupational and non-occupational risk factors, and workplace exposure. The questionnaire data stored in SPIROLA can be integrated into decision-making in developing intervention plans for individuals and a group. Also, the data can be exported as a CSV file (Figure).

1. SPIROLA enables the user to monitor the percentage of spirometry tests that do not meet the 2005 ATS/ERS criteria for acceptability and repeatability, for individual technicians and overall. This function helps to assure acceptable data quality and precision by each spirometry technician (Figure).

1. Added reference questions for Asian-American race/ethnicity, including options for specifying a correction factor.
2. Fixed errors associated with using the Microsoft Access ACCDB file format.
3. Outlying or incorrect FEV1 or FVC data points excluded by the user from the analysis are now kept permanently excluded, with the option of inclusion if needed.
4. Functions to help users to identify duplicate data.
5. Reduced the load time of the Risk List Summary and added new filter options to view participants with intervention plans for specified time periods.

Version 3.0 includes the following enhancements and additions. Please refer to the SPIROLA user manual for details.

1. Intervention module
   1. to design and implement intervention
   2. to conduct Safety or Lifestyle Assessment at Worksite
2. Questionnaire module
   1. to design a questionnaire
   2. to conduct electronic questionnaire survey
   3. to clean the questionnaire survey data
   4. to view and export questionnaire data
3. Data input from various types of spirometry databases is supported:
   1. Microsoft Access
   2. Microsoft SQL Server
   3. Other ODBC-compliant databases
   4. Custom data input support for datasets created by different types of spirometers
4. Flexible data format support (cm/in, l/ml, different date formats, race and gender values)
5. SPIROLA can be started from third party applications (i.e., from another software)

Disclaimer: This software is provided to assist health care practitioners in their management of occupational medical monitoring programs using spirometry. The software is only intended to assist the user in assembling the information required to make medical decisions, but cannot be substituted for competent and informed professional judgment. NIOSH does not warrant the reliability or accuracy of the software, graphic screens, or text. Software users need to be aware of all applicable federal, state and local laws and regulations that may impact utilization of this software.