Skip to content

Accessibility Conformance Report (ACR) for the Trusted Tester Process spreadsheet with automated WCAG 2.0 and disability impact reports

Jump to bottom
Anna Gingle edited this page May 1, 2024 · 1 revision

Assets

How to use this sheet

Simply enter your information into the Test results and Cover sheet tabs and the WCAG report and Disability impact score tab’s will be populated. Make sure to hide the TTID-FPC tab before exporting.

Cover sheet

The information displayed here is borrowed from Open-ACR and ACRT-master. cover sheet

Test results

This is where you'll record your results from the trusted tester process. test results

WCAG 2.0 Report

A report will be generated based on your input from the test results tab.

Conformance Level column formula

  • First Check - It looks in the 'Test results' sheet to see if the value in column B of the 'WCAG report' sheet (on the same row as the formula) exists. If not, it outputs "-".
  • Fail Condition - If there's a match, it then checks if any matched entries have "Fail" in column F of 'Test results'. If any do, it outputs "Fail".
  • Other Conditions - If no "Fail", it checks for "Does Not Apply" or "Not Tested" in column F. It outputs these statuses if they are found.
  • Final Decision - If none of these conditions are met, it checks if the matched entries in column F are all empty. If so, it returns "-". Otherwise, it returns "Pass".

Standard/Guideline column formula

  1. Main Action: It tries to create a list of items from column E of the 'Test results' sheet. But not just any items—it's looking for specific ones that meet two criteria.
  2. Criteria for Selection: The value in column B of the 'Test results' sheet must match the value in cell A3 of the 'WCAG Report' sheet. Also, the corresponding value in column F of the 'Test results' sheet must be "Fail".
  3. How It Presents the Results: If it finds any items that meet both criteria, it puts them together in a list, separated by ", " (a comma followed by a space).
  4. Handling Errors: If there's an issue (like no items meet the criteria, or there's an error with the formula's setup), instead of showing an error message, it simply shows an empty text (""). WCAG report

Disability Impact Score

The disability impact score is calculated based on your input on the Test results tab. The method used to calculate the score is borrowed from ACRT-master.

Risk score column formula

This formula checks two things the tab named 'TTID-FPC':

  1. Where things match: It looks in column G to find cells that match a specific value mentioned in column D on the same row where you're using this formula.
  2. Counting "Fails": Among those matches, it counts how many are labeled as "Fail" in column A.

Disability impact report

TTID-FPC

Used for calculations. Do not edit. Hide before exporting TTID-FPC

Clone this wiki locally