This Google Sheets template for the Test of Pragmatic Language 2nd edition (TOPL-2) will help you analyze the different pragmatic contexts without having to reference the manual in-depth for each question.
This Sheet helps you efficiently identify which specific contexts of pragmatics might be most difficult for a student. Formulas were created by referencing the manual that described what questions target the various contexts. The following contexts are broken down further in the Sheet.