Mmpi-2 Excel -

  • Composite validity decision logic to determine whether profile is interpretable, invalid due to random/over-reporting, or defensive.

  • Data entry (RawResponses sheet)

  • Implement keyed scoring

  • Validity scales

  • Converting raw to T-scores

  • Profile plotting

  • Automation and checks

  • Export and backup

  • If macros included: sign macros and provide code review checklist.
  • Export formats: Printable Excel sheet, PDF via Print-to-PDF, and CSV of scores for recordkeeping.
    • [ MMPI-2 Excel v1.0 ]
-------------------------------------
Input Sheet | Scores | Graph | Validity
-------------------------------------
Subject ID: MMPI_101   Gender: [M/F]

    Item responses (1-567):
1 [True]  2 [False]  3 [?] ...
[Load CSV] [Clear All]
    

    

    [SCORE PROFILE] (after clicking "Calculate")
Scale   Raw   K-corr   T-score   Interpretation
L       4     4        48        Normal
F       12    12       72        Elevated
K       15    15       55        Normal
Hs      8     12       68        Borderline
...
 mmpi-2 excel