Desktop Sheet Calculator

Desktop software for PCs is available to generate predicted values, lower limits of normal and z-scores for spirometric indices for datasets containing up to 60,000 records. The input file must adhere to a strict format, so please read the instructions first:

GLI-2012 Desktop Software for Large Data Sets - Instructions
Philip H. Quanjer, Sanja Stanojevic, Tim J. Cole, Janet Stocks
PDF journal article, handout or slides
PDF journal article, handout or slides

The software serves 3 purposes: 

  1. add predicted values, lower limit of normal, z-scores to up to 60,000 records ('Database conversion')
  2. obtain estimated coefficients for an ethnic group not covered in the Quanjer GLI-2012 equations ('New Ethnic Group')
  3. obtain mean z-scores for males and females for each of the spirometric indices ('Key Statistics')
GLI-2012 Desktop Software for Large Data Sets
Philip H. Quanjer, Sanja Stanojevic, Tim J. Cole, Janet Stocks

Version 1.3.4. Build 3, 7 April 2013
Exe file
Exe file

GLI-2012 Desktop Software for Large Data Sets Image


Click here for information about applicability of GLI-2012 equations (indices, age range, ethnicity, countries covered) or here for validation studies of the GLI-2012 equations and impact if implementation on clinical interpretation of measurements.