Spirometry Longitudinal Data Analysis (SPIROLA) Software
SPIROLA software is an easy-to-use visual and quantitative tool intended to assist the health care provider in monitoring and interpreting computerized longitudinal spirometry data for individuals as well as for a group. 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, graphics, or text. The users need to be aware of applicable federal, state and local laws and regulations that may impact utilization of this software. SPIROLA has been developed and is maintained by CDC and is licensed by CDC to be downloaded free of charge from the CDC webpage by anybody who may need it.
SPIROLA is easy to install and test-run with a demonstration database included with the software (names in the database are fictional). SPIROLA Worksite Assessment module is optional and is designed to help with worksite exposure evaluation (see user manual). SPIROLA only supports 32-bit versions of Microsoft Office. Additionally, if you do not have Microsoft Access 2007 or a newer version installed, download and install the 32-bit version of the Microsoft Access 2010 runtime.
Listed below are some of the features SPIROLA provides.
us your questions or comments on SPIROLA.
|SPIROLA V3.0.2 (28.3 MB)||download||March 28, 2014|
|SPIROLA Worksite Assessment (1.5 MB)||download||download||January 25, 2011|
|User manual (includes detailed installation instructions)|
- SPIROLA enables the user to display forced expiratory volume in one second (FEV1), forced vital capacity (FVC), and percent predicted values (Figure) plotted against age, as single or multiple charts (Figure), for each individual in the database (Cross-sectional and longitudinal limits shown on the chart can be selected by the user).
- SPIROLA enables the user to compare the most recent spirometry test results to population reference values derived from standard or user-specified reference equations (FEV1, FVC, and FEV1/FVC).
- SPIROLA enables the user to evaluate changes in FEV1 and FVC over time. For the first 8 years of an individual’s follow-up, SPIROLA uses the limit of longitudinal decline (LLD) which takes into account expected within-person variation in FEV1 or FVC and the duration of follow-up to determine whether or not the individual’s decline in FEV1 or FVC may be excessive (blue line in Figure). After 8 years of follow-up, the age at which the individual is projected to develop moderate-severe lung function impairment is considerate in the evaluation (Figure). Results of the cross-sectional and longitudinal evaluation are provided in an individual’s report.
- 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 FEV1 or FVC. The selection criteria are based on published reference values and can be modified by the user (Figure).
- SPIROLA enables the user to tag identified individuals for further spirometry evaluation such as spirometry quality control or retesting (Figure).
- 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).
- SPIROLA enables the user to monitor and evaluate the implementation of intervention for individuals and for a group of workers.
- SPIROLA enables the user to monitor group means for (FEV1) and (FVC) and in relation to mean predicted values based on group demographics (age, height, gender, ethnicity/race).
- 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.
- 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).
- 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).
Version 3.0.2 includes the following new features or functions:
- Added reference questions for Asian-American race/ethnicity, including options for specifying a correction factor.
- Fixed errors associated with using the Microsoft Access ACCDB file format.
- 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.
- Functions to help users to identify duplicate data.
- Reduced the load time of the Risk List Summary and added new filter options to view participants with intervention plans for specified time periods.
- The FILE menu in SPIROLA allows the user to create an empty Microsoft Access or Excel database in a SPIROLA format. Spirometry data can be imported or entered into the database (see user manual for details).
- Longitudinal limit has been added to the FVC chart to enable identification of individuals with excessive decline in FVC.
- The RISK LIST functions have been expanded to allow identification of individuals with excessive decline in FVC (Figure).
- The OPTIONS menu allows specification of the longitudinal limit for FVC, and of what height value is to be used for the cross-sectional evaluation (the mean or the most recent value).
- Intervention module
- to design and implement intervention
- to conduct Safety or Lifestyle Assessment at Worksite
- Questionnaire module
- to design a questionnaire
- to conduct electronic questionnaire survey
- to clean the questionnaire survey data
- to view and export questionnaire data
- Data input from various types of spirometry databases is supported:
- Microsoft Access
- Microsoft SQL Server
- Other ODBC-compliant databases
- Custom data input support for datasets created by different types of spirometers
- Flexible data format support (cm/in, l/ml, different date formats, race and gender values)
- 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.
Note: We appreciate that users provide us with feedback on the latest version of SPIROLA to help us to improve the software.
- National Institute for Occupational Safety and Health (NIOSH)
- Centers for Disease Control and Prevention
TTY: (888) 232-6348
- New Hours of Operation
- Contact CDC-INFO