Skip links

Lloyd & Preece Psychometric Auto-Scorer

Streamlining psychological assessments with our free Excel auto-scorer for common psychological questionnaires.

Click Here to Download Version 1.4 (Excel Format)

The Lloyd & Preece Psychometric Auto-Scorer is a free programmed Excel sheet designed by Dr Erin Lloyd and Dr David Preece, which:

  • Auto-scores a variety of common psychological questionnaires, calculating all subscale and composite scores.
  • Compares scores to a reference sample to aid interpretation.
  • Generates profile graphs visually showing client strengths and difficulties.


Currently the following measures are included within the Lloyd & Preece Psychometric Auto-Scorer:

Measures of Mental Health Symptoms

  • Depression Anxiety Stress Scales (DASS; Lovibond & Lovibond, 1995)
  • Depression Anxiety Stress Scales-21 (DASS-21; Lovibond & Lovibond, 1995)
  • Kessler Psychological Distress Scale (K10; Kessler et al., 2003)
  • Generalised Anxiety Disorder Assessment (GAD-7; Spitzer et al., 2006)
  • Patient Health Questionnaire (PHQ-9; Kroenke et al., 2001)
  • Beck Depression Inventory-II (BDI-II; Beck et al., 1996)
  • Beck Anxiety Inventory (BAI; Beck et al., 1993)
  • DSM-5-TR Self-Rated Level 1 Cross-Cutting Symptom Measure-Adult (DSM-5; American Psychiatric Association, 2013)
  • PTSD Checklist for DSM-5 (PCL-5; Weather et al., 2013)
  • Eating Disorder Examination Questionnaire (EDE-Q; Fairburn et al., 2008)
  • Eating Disorder Examination Questionnaire-Short (EDE-QS; Gideon et al., 2016)
  • Alcohol Use Disorders Identification Test (AUDIT; Babor et al., 1992)

Measures of Emotional Functioning:

  • Perth Alexithymia Questionnaire (PAQ; Preece et al., 2018a)
  • Perth Alexithymia Questionnaire-Short Form (PAQ-S; Preece et al., 2023)
  • Perth Emotion Regulation Competency Inventory (PERCI; Preece et al., 2018b)
  • Perth Emotional Reactivity Scale (PERS; Becerra et al., 2019)
  • Perth Emotional Reactivity Scale-Short Form (PERS-S; Preece et al., 2019)
  • Emotion Beliefs Questionnaire (EBQ; Becerra et al., 2020)
  • Emotion Regulation Questionnaire (ERQ; Gross & John, 2003)
  • Process Model of Emotion Regulation Questionnaire (PMERQ; Olderbak et al., 2022)
  • Perth Empathy Scale (PES; Brett et al., 2022)

Measures of Neurodevelopmental Disorder Symptoms or Traits:

  • Adult ADHD Self-Report Scale (ASRS; Kessler et al., 2005)
  • Autism-Spectrum Quotient (AQ; Baron-Cohen et al., 2001)
  • Autism-Spectrum Quotient-10 (AQ-10; Allison et al., 2012)
  • Comprehensive Autistic Trait Inventory (CATI; English et al., 2021)

Measures of Personality or Personality-Related Constructs:

  • Personality Inventory for DSM-5 (PID-5; Krueger et al., 2012)
  • The Personality Inventory for DSM-5 – Brief Form (PID-5-BF; Krueger et al., 2012)
  • Young Schema Questionnaire-Revised (YSQ-R; Yalcin et al., 2022)