{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Pages Reviewed","Severity"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":8,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Pages Reviewed","index":0,"n_rows":184,"n_cols":65,"rows_kept":184,"cut":false,"hidden":false,"merged":[[118,9,118,13],[110,9,110,13],[134,0,134,3],[99,1,99,3],[106,0,132,3]]}
["Protocol Items for Page","Help","Pass/Fail/NA","Severity (see Severity tab)","Notes - be thorough enough to understand/reproduce/see problem","     User First",null,null,"User Last     ","Reviewed","NA","Pass","Fail","Blocker","Critical","Major","Minor","Lesser",null,"1.1 Keyboard Focus Visibility","1.2. Keyboard Focus Order","1.3. Keyboard Access","1.4. Keyboard Traps","1.5. Heading Levels","1.6. Color Contrast (Visual)","1.7. Video Captions","1.8. Live Video Captions","1.9. Audio Controls","1.10. Video/Animation Controls","2.1. Flashing Content","2.2. Page Title","2.3. Sensory Characteristics","2.4. Color","2.5. Headings and Labels","2.6. Navigation Consistency","2.7. Form Labels and Instructions (Visual)","2.8. Form Error Identification (Visual)","3.1. Appropriate Reading Order","3.2. Text Alternatives","3.3. Keyboard Focus Order (Screen Reader)","3.4. Keyboard Access (Screen Reader)","3.5. Keyboard Traps (Screen Reader)","3.6. Heading Levels (Screen Reader)","3.7. Form Labels and Instructions (Screen Reader)","3.8. Form Error Identification (Screen Reader)","4.1. Tables and Lists (Screen Reader)","4.2. Focus Triggers","4.3. Input Triggers","4.4. Skip Navigation","4.5. Color Contrast (CCA)","4.6. Zooming","4.7. Link Purpose (In Context)","5.1. Multiple Ways to Reach Page","5.2. Form Error Suggestions","5.3. Legal, Financial, and Data Error Prevention","5.4. Text Alternatives for Audio-only and Video-only Content","5.5. Audio Descriptions","5.6. Time Limits","5.7. Visual Relationships (Screen Reader)","6.1. Code Validation","6.2. Page Language","6.3. Changes in Language","6.4. UI Consistency","6.5. Images of Text","6.6. Name, Role, Value"]
["Enter URL of evaluated page in below cell",null,"Table Naming Macro for each block is run by clicking the \"Set Table Name for:\" of the block. (Also see note or Macro_Info cell.)","Enter Page Name/Description in cell just above \"Severity\" table column heading in each block.",null,"      Column",null,null,"Column      "]
["https://msu.edu",null,null,"Home",null,null,null,null,null,"Select a column in User area then \"Remove\", or \"Insert\" before. WARNING: Nothing prevents deletion of all User columns! You can insert before first and after last."]
["Protocol Items for Page","Help","Pass/Fail/NA","Severity","Notes","     User First",null,null,"User Last      ","Reviewed","NA","Pass","Fail","Blocker","Critical","Major","Minor","Lesser",null,"1.1 Keyboard Focus Visibility","1.2. Keyboard Focus Order","1.3. Keyboard Access","1.4. Keyboard Traps","1.5. Heading Levels","1.6. Color Contrast (Visual)","1.7. Video Captions","1.8. Live Video Captions","1.9. Audio Controls","1.10. Video/Animation Controls","2.1. Flashing Content","2.2. Page Title","2.3. Sensory Characteristics","2.4. Color","2.5. Headings and Labels","2.6. Navigation Consistency","2.7. Form Labels and Instructions (Visual)","2.8. Form Error Identification (Visual)","3.1. Appropriate Reading Order","3.2. Text Alternatives","3.3. Keyboard Focus Order (Screen Reader)","3.4. Keyboard Access (Screen Reader)","3.5. Keyboard Traps (Screen Reader)","3.6. Heading Levels (Screen Reader)","3.7. Form Labels and Instructions (Screen Reader)","3.8. Form Error Identification (Screen Reader)","4.1. Tables and Lists (Screen Reader)","4.2. Focus Triggers","4.3. Input Triggers","4.4. Skip Navigation","4.5. Color Contrast (CCA)","4.6. Zooming","4.7. Link Purpose (In Context)","5.1. Multiple Ways to Reach Page","5.2. Form Error Suggestions","5.3. Legal, Financial, and Data Error Prevention","5.4. Text Alternatives for Audio-only and Video-only Content","5.5. Audio Descriptions","5.6. Time Limits","5.7. Visual Relationships (Screen Reader)","6.1. Code Validation","6.2. Page Language","6.3. Changes in Language","6.4. UI Consistency","6.5. Images of Text","6.6. Name, Role, Value"]
["1.1. Keyboard Focus Visibility (2.4.7)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-visible.html",null,null,null,null,null,null,null,{"$f":"IF(C5<>\"\",1,0)","v":0},{"$f":"IF($C5=K$1,1,0)","v":0},{"$f":"IF($C5=L$1,1,0)","v":0},0,{"$f":"IF($D5=N$1,1,0)","v":0},{"$f":"IF($D5=O$1,1,0)","v":0},0,0,0,null,{"$f":"$C5","v":0}]
["1.2. Keyboard Focus Order (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,{"$f":"IF($C6=K$1,1,0)","v":0},0,0,{"$f":"IF($D6=N$1,1,0)","v":0},0,0,0,0,null,null,{"$f":"$C6","v":0}]
["1.3. Keyboard Access (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"$C7","v":0}]
["1.4. Keyboard Traps (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"$C8","v":0}]
["1.5. Heading Levels (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$C9","v":0}]
["1.6. Color Contrast (Visual) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"$C10","v":0}]
["1.7. Video Captions (1.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"$C11","v":0}]
["1.8. Live Video Captions (1.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-real-time-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"$C12","v":0}]
["1.9. Audio Controls (1.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-dis-audio.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"$C13","v":0}]
["1.10. Video/Animation Controls (2.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-pause.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"$C14","v":0}]
["2.1. Flashing Content (2.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/seizure-does-not-violate.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C15","v":0}]
["2.2. Page Title (2.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-title.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C16","v":0}]
["2.3. Sensory Characteristics (1.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-understanding.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C17","v":0}]
["2.4. Color (1.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-without-color.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C18","v":0}]
["2.5. Headings and Labels (2.4.6)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-descriptive.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C19","v":0}]
["2.6. Navigation Consistency (3.2.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-locations.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C20","v":0}]
["2.7. Form Labels and Instructions (Visual) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C21","v":0}]
["2.8. Form Error Identification (Visual) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C22","v":0}]
["3.1. Appropriate Reading Order (1.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-sequence.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C23","v":0}]
["3.2. Text Alternatives (1.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/text-equiv-all.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C24","v":0}]
["3.3. Keyboard Focus Order (Screen Reader) (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C25","v":0}]
["3.4. Keyboard Access (Screen Reader) (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C26","v":0}]
["3.5. Keyboard Traps (Screen Reader) (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C27","v":0}]
["3.6. Heading Levels (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C28","v":0}]
["3.7. Form Labels and Instructions (Screen Reader) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C29","v":0}]
["3.8. Form Error Identification (Screen Reader) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C30","v":0}]
["4.1. Tables and Lists (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C31","v":0}]
["4.2. Focus Triggers (3.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-receive-focus.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C32","v":0}]
["4.3. Input Triggers (3.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-unpredictable-change.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C33","v":0}]
["4.4. Skip Navigation (2.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-skip.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C34","v":0}]
["4.5. Color Contrast (CCA) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C35","v":0}]
["4.6. Zooming (1.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-scale.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C36","v":0}]
["4.7. Link Purpose (In Context) (2.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-refs.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C37","v":0}]
["5.1. Multiple Ways to Reach Page (2.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-mult-loc.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C38","v":0}]
["5.2. Form Error Suggestions (3.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-suggestions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C39","v":0}]
["5.3. Legal, Financial, and Data Error Prevention (3.3.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-reversible.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C40","v":0}]
["5.4. Text Alternatives for Audio-only and Video-only Content (1.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-av-only-alt.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C41","v":0}]
["5.5. Audio Descriptions (1.2.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-audio-desc-only.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C42","v":0}]
["5.6. Time Limits (2.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-required-behaviors.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C43","v":0}]
["5.7. Visual Relationships (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C44","v":0}]
["6.1. Code Validation (4.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-parses.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C45","v":0}]
["6.2. Page Language (3.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-doc-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C46","v":0}]
["6.3. Changes in Language (3.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-other-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C47","v":0}]
["6.4. UI Consistency (3.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-functionality.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C48","v":0}]
["6.5. Images of Text (1.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-text-presentation.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C49","v":0}]
["6.6. Name, Role, Value (4.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-rsv.html",null,null,null,null,null,null,null,0,0,0,{"$f":"IF($C50=M$1,1,0)","v":0},0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C50","v":0}]
[]
["[Enter Page URL in this cell]",null,null,"[Enter Page Name/Description in this cell]"]
["Protocol Items for Page","Help","Pass/Fail/NA","Severity","Notes","     User First",null,null,"User Last      ","Reviewed","NA","Pass","Fail","Blocker","Critical","Major","Minor","Lesser",null,"1.1 Keyboard Focus Visibility","1.2. Keyboard Focus Order","1.3. Keyboard Access","1.4. Keyboard Traps","1.5. Heading Levels","1.6. Color Contrast (Visual)","1.7. Video Captions","1.8. Live Video Captions","1.9. Audio Controls","1.10. Video/Animation Controls","2.1. Flashing Content","2.2. Page Title","2.3. Sensory Characteristics","2.4. Color","2.5. Headings and Labels","2.6. Navigation Consistency","2.7. Form Labels and Instructions (Visual)","2.8. Form Error Identification (Visual)","3.1. Appropriate Reading Order","3.2. Text Alternatives","3.3. Keyboard Focus Order (Screen Reader)","3.4. Keyboard Access (Screen Reader)","3.5. Keyboard Traps (Screen Reader)","3.6. Heading Levels (Screen Reader)","3.7. Form Labels and Instructions (Screen Reader)","3.8. Form Error Identification (Screen Reader)","4.1. Tables and Lists (Screen Reader)","4.2. Focus Triggers","4.3. Input Triggers","4.4. Skip Navigation","4.5. Color Contrast (CCA)","4.6. Zooming","4.7. Link Purpose (In Context)","5.1. Multiple Ways to Reach Page","5.2. Form Error Suggestions","5.3. Legal, Financial, and Data Error Prevention","5.4. Text Alternatives for Audio-only and Video-only Content","5.5. Audio Descriptions","5.6. Time Limits","5.7. Visual Relationships (Screen Reader)","6.1. Code Validation","6.2. Page Language","6.3. Changes in Language","6.4. UI Consistency","6.5. Images of Text","6.6. Name, Role, Value"]
["1.1. Keyboard Focus Visibility (2.4.7)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-visible.html",null,null,null,null,null,null,null,{"$f":"IF(C54<>\"\",1,0)","v":0},{"$f":"IF($C54=K$1,1,0)","v":0},0,0,{"$f":"IF($D54=N$1,1,0)","v":0},0,0,0,0,null,{"$f":"$C54","v":0}]
["1.2. Keyboard Focus Order (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,{"$f":"$C55","v":0}]
["1.3. Keyboard Access (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"$C56","v":0}]
["1.4. Keyboard Traps (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"$C57","v":0}]
["1.5. Heading Levels (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$C58","v":0}]
["1.6. Color Contrast (Visual) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"$C59","v":0}]
["1.7. Video Captions (1.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"$C60","v":0}]
["1.8. Live Video Captions (1.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-real-time-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"$C61","v":0}]
["1.9. Audio Controls (1.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-dis-audio.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"$C62","v":0}]
["1.10. Video/Animation Controls (2.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-pause.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"$C63","v":0}]
["2.1. Flashing Content (2.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/seizure-does-not-violate.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C64","v":0}]
["2.2. Page Title (2.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-title.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C65","v":0}]
["2.3. Sensory Characteristics (1.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-understanding.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C66","v":0}]
["2.4. Color (1.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-without-color.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C67","v":0}]
["2.5. Headings and Labels (2.4.6)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-descriptive.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C68","v":0}]
["2.6. Navigation Consistency (3.2.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-locations.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C69","v":0}]
["2.7. Form Labels and Instructions (Visual) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C70","v":0}]
["2.8. Form Error Identification (Visual) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C71","v":0}]
["3.1. Appropriate Reading Order (1.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-sequence.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C72","v":0}]
["3.2. Text Alternatives (1.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/text-equiv-all.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C73","v":0}]
["3.3. Keyboard Focus Order (Screen Reader) (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C74","v":0}]
["3.4. Keyboard Access (Screen Reader) (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C75","v":0}]
["3.5. Keyboard Traps (Screen Reader) (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C76","v":0}]
["3.6. Heading Levels (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C77","v":0}]
["3.7. Form Labels and Instructions (Screen Reader) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C78","v":0}]
["3.8. Form Error Identification (Screen Reader) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C79","v":0}]
["4.1. Tables and Lists (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C80","v":0}]
["4.2. Focus Triggers (3.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-receive-focus.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C81","v":0}]
["4.3. Input Triggers (3.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-unpredictable-change.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C82","v":0}]
["4.4. Skip Navigation (2.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-skip.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C83","v":0}]
["4.5. Color Contrast (CCA) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C84","v":0}]
["4.6. Zooming (1.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-scale.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C85","v":0}]
["4.7. Link Purpose (In Context) (2.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-refs.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C86","v":0}]
["5.1. Multiple Ways to Reach Page (2.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-mult-loc.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C87","v":0}]
["5.2. Form Error Suggestions (3.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-suggestions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C88","v":0}]
["5.3. Legal, Financial, and Data Error Prevention (3.3.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-reversible.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C89","v":0}]
["5.4. Text Alternatives for Audio-only and Video-only Content (1.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-av-only-alt.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C90","v":0}]
["5.5. Audio Descriptions (1.2.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-audio-desc-only.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C91","v":0}]
["5.6. Time Limits (2.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-required-behaviors.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C92","v":0}]
["5.7. Visual Relationships (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C93","v":0}]
["6.1. Code Validation (4.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-parses.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C94","v":0}]
["6.2. Page Language (3.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-doc-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C95","v":0}]
["6.3. Changes in Language (3.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-other-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C96","v":0}]
["6.4. UI Consistency (3.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-functionality.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C97","v":0}]
["6.5. Images of Text (1.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-text-presentation.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C98","v":0}]
["6.6. Name, Role, Value (4.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-rsv.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C99","v":0}]
[null,"When macros are enabled the button at the left (or Ctrl-n) inserts space for a new page protocol scoring block from 1.1-6.6 then copies a blank protocol block from below the SUMS section into the new space where you can enter the URL for a new page and start reviewing it.",null,null,"Macros must always be enabled for automatic table naming (and renaming) to occur to make page blocks (the tables) readily accessible to screen reader users (via use of Control-g to \"GoTo\" and picking a specific table from the list). It may be necessary to close the workbook and reopen it choosing to enable macros or to click an \"Enable Content\" button. "]
[]
[null,null,null,null,null,null,null,null,null,"   ↑↑↑↑  Column above will all be 1s (ones) when all protocol lines correctly have the Pass/Fail/NA column completed"]
["SUMS",null,null,null,null,null,null,null,null,{"$f":"SUM(J1:J101)","v":0},0,0,0,0,0,0,0,0,"Pass",{"$f":"COUNTIF(T$1:T$102,$S103)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AD$1:AD$102,$S103)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AN$1:AN$102,$S103)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(AX$1:AX$102,$S103)","v":0},0,0,0,0,0,0,0,0,0,{"$f":"COUNTIF(BH$1:BH$102,$S103)","v":0},0,0,0,0,0]
["Check Row; if different, fix the data most likely. E.g., Pass/Fail..; Severity missing!",null,null,null,null,null,null,null,null,"↑ = →",{"$f":"SUM(K103:R103)-M103","v":0},null,null,null,null,null,null,null,"Fail",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"NA",0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Red/Pink","above and right",null,null,"If you MUST leave blank entries, that's",null,null,null,"0=Blank",0,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
["The Single/Double is not currently being used for Scoring and will probably be removed in the future. The % Target will stay but it is recommended to leave it at 100% so it effectively provides the same answer as Strict Scoring. This all will be reevaluated if WCAG 3.0 (Silver?) comes out with a \"rated\" conformance model and is adopted by MSU.\n\nNOTICE: There are two ways to handle mobile in this spreadsheet. Single: Using separate blocks of Tests (1.1-6.6) for desktop and mobile for each page reviewed will require more record keeping but allow scoring exactly as described in the MSU Evaluation Protocol for WCAG 2.0 AA Instructions PROVIDED that you use the \"Single Count Pass Entry\" rows in the summary rows to the right (thus avoiding double counting). Double: You could also use only a single block of Tests for both desktop and mobile however that requires that if a Test fails on either desktop or mobile that \"Fail\" be set for that Test for that page thus resulting in both mobile and desktop being counted as failures when using the \"Mobile Doubling Pass Entry\" rows to the right. \n\nYour choice how you do it though it is strongly recommended that when the mobile and desktop versions of a page contain significantly different content (a poor practice in general) that they be recorded separately. If one page has separate mobile and desktop blocks then all pages should for meaningful scoring. \n\nAs a general rule, when the Digital Content and Accessibility Team reviews websites we treat both mobile and desktop in the same block simply to reduce recordkeeping time knowing that a failure in only either desktop or mobile will be scored a little worse than otherwise but also understanding that any failure is excluding somebody from equal access.",null,null,null,null,null,null,null,null,"indicate possible issues.",null,null,null,"      OK but… it's not good practice.",null,null,null,null,"Single Count Denominator",{"$f":"SUM(T$103:T$104)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobile Doubling Denominator",{"$f":"(SUM(T$103:T$106)*2)-(T$105*2)","v":4},4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4,4]
[null,null,null,null,null,null,null,null,null,"→","Single","← See NOTICE: at left."]
[null,null,null,null,null,null,null,null,null,"MSU Evaluation Protocol for WCAG 2.0 AA Scoring Section",null,null,null,null,null,null,null,null,null,{"$f":"T1","v":"1.1 Keyboard Focus Visibility"},"1.2. Keyboard Focus Order","1.3. Keyboard Access","1.4. Keyboard Traps","1.5. Heading Levels","1.6. Color Contrast (Visual)","1.7. Video Captions","1.8. Live Video Captions","1.9. Audio Controls","1.10. Video/Animation Controls","2.1. Flashing Content","2.2. Page Title","2.3. Sensory Characteristics","2.4. Color","2.5. Headings and Labels","2.6. Navigation Consistency","2.7. Form Labels and Instructions (Visual)","2.8. Form Error Identification (Visual)","3.1. Appropriate Reading Order","3.2. Text Alternatives","3.3. Keyboard Focus Order (Screen Reader)","3.4. Keyboard Access (Screen Reader)","3.5. Keyboard Traps (Screen Reader)","3.6. Heading Levels (Screen Reader)","3.7. Form Labels and Instructions (Screen Reader)","3.8. Form Error Identification (Screen Reader)","4.1. Tables and Lists (Screen Reader)","4.2. Focus Triggers","4.3. Input Triggers","4.4. Skip Navigation","4.5. Color Contrast (CCA)","4.6. Zooming","4.7. Link Purpose (In Context)","5.1. Multiple Ways to Reach Page","5.2. Form Error Suggestions","5.3. Legal, Financial, and Data Error Prevention","5.4. Text Alternatives for Audio-only and Video-only Content","5.5. Audio Descriptions","5.6. Time Limits","5.7. Visual Relationships (Screen Reader)","6.1. Code Validation","6.2. Page Language","6.3. Changes in Language","6.4. UI Consistency","6.5. Images of Text","6.6. Name, Role, Value"]
[null,null,null,null,null,null,null,null,null,"Summary Percentage Scoring",null,null,null,null,null,"Set % Target →",null,"Percentage Scoring",null,100,"% Target","Set % Target at left appropriately. 100% nets the equivalent result to Strict Scoring."]
[null,null,null,null,null,null,null,null,null,"Tier #","Pass Entry","Fail %","NA #","Blank #","Fail #","Green background &",null,null,"Single Count Pass Entry",{"$f":"T$103&\"/\"&T107","v":"0/0"},"0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0","0/0"]
[null,null,null,null,null,null,null,null,null,"Tier 1",{"$f":"IF(SUM($T$103:$AC$104)=0,0,SUM($T$103:$AC$103)/SUM($T$103:$AC$104))","v":0},{"$f":"IF(SUM($T$103:$AC$104)=0,0,(SUM($T$129:$AC$129)/SUM($T$103:$AC$104)))","v":0},{"$f":"SUM($T$105:$AC$105)","v":0},{"$f":"SUM($T$106:$AC$106)","v":20},{"$f":"IF($K$109=\"Single\",SUM($T$129:$AC$129),SUM($T$130:$AC$130))","v":0},"boxed at right ",null,null,"    Mobile Doubling Pass Entry",{"$f":"(T$103*2)&\"/\"&T108","v":"0/4"},"0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4","0/4"]
[null,null,null,null,null,null,null,null,null,"Tier 2",{"$f":"IF(SUM($AD$107:$AK$107)=0,0,SUM($AD$103:$AK$103)/SUM($AD$107:$AK$107))","v":0},{"$f":"IF(SUM($AD$103:$AK$104)=0,0,SUM($AD$129:$AK$129)/SUM($AD$103:$AK$104))","v":0},{"$f":"SUM($AD$105:$AK$105)","v":0},{"$f":"SUM($AD$106:$AK$106)","v":16},{"$f":"IF($K$109=\"Single\",SUM($AD$129:$AK$129),SUM($AD$130:$AK$130))","v":0},"indicates which",null,null,"FYI Single Count % Pass",{"$f":"IF(T107=0,0,T$103/T107)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Tier 3",{"$f":"IF(SUM($AL$107:$AS$107)=0,0,SUM($AL$103:$AS$103)/SUM($AL$107:$AS$107))","v":0},{"$f":"IF(SUM($AL$103:$AS$104)=0,0,SUM($AL$129:$AS$129)/SUM($AL$103:$AS$104))","v":0},{"$f":"SUM($AL$105:$AS$105)","v":0},{"$f":"SUM($AL$106:$AS$106)","v":16},{"$f":"IF($K$109=\"Sintle\",SUM($AL$129:$AS$129),SUM($AL$130:$AS$130))","v":0},"Protocol Percentage",null,null,"FYI Mobile Doubling % Pass",{"$f":"IF(T108=0,0,(T$103*2)/T108)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Tier 4",{"$f":"IF(SUM($AT$107:$AZ$107)=0,0,SUM($AT$103:$AZ$103)/SUM($AT$107:$AZ$107))","v":0},{"$f":"IF(SUM($AT$103:$AZ$104)=0,0,SUM($AT$129:$AZ$129)/SUM($AT$103:$AZ$104))","v":0},{"$f":"SUM($AT$105:$AZ$105)","v":0},{"$f":"SUM($AT$106:$AZ$106)","v":14},{"$f":"IF($K$109=\"single\",SUM($AT$129:$AZ$129),SUM($AT$130:$AZ$130))","v":0},"Scoring rows match",null,null,"                      Single Count Fail",{"$f":"IF(T107=0,\"0 or blank\",IF(T114<($T$111/100),\"1 |√|X\",\"0 or blank\"))","v":"0 or blank"},"0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank"]
[null,null,null,null,null,null,null,null,null,"Tier 5",{"$f":"IF(SUM($BA$107:$BG$107)=0,0,SUM($BA$103:$BG$103)/SUM($BA$107:$BG$107))","v":0},{"$f":"IF(SUM($BA$103:$BG$104)=0,0,SUM($BA$129:$BG$129)/SUM($BA$103:$BG$104))","v":0},{"$f":"SUM($BA$105:$BG$105)","v":0},{"$f":"SUM($BA$106:$BG$106)","v":14},{"$f":"IF($K$109=\"Single\",SUM($BA$129:$BG$129),SUM($BA$130:$BG$130))","v":0},"Single/Double",null,null,"      Mobile Doubling Fail",{"$f":"IF(T107=0,\"0 or blank\",IF(T115<($T$111/100),\"1 |√|X\",\"0 or blank\"))","v":"0 or blank"},"0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank"]
[null,null,null,null,null,null,null,null,null,"Tier 6",{"$f":"IF(SUM($BH$107:$BM$107)=0,0,SUM($BH$103:$BM$103)/SUM($BH$107:$BM$107))","v":0},{"$f":"IF(SUM($BH$103:$BM$104)=0,0,SUM($BH$129:$BM$129)/SUM($BH$103:$BM$104))","v":0},{"$f":"SUM($BH$105:$BM$105)","v":0},{"$f":"SUM($BH$106:$BM$106)","v":12},{"$f":"IF($K$109=\"Single\",SUM($BH$129:$BM$129),SUM($BH$130:$BM$130))","v":0},"selection per above",null,null,"            Single Count N/A",{"$f":"T105","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"Summary Strict Scoring",null,null,null,null,null,"(and left NOTICE:)",null,null,"      Mobile Doubling N/A",{"$f":"T105*2","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,"(# of Criteria)","Pass Entry","Fail","NA","Blank #","(Hint)",null,null,null,"(not recorded in Protocol document) Blank",{"$f":"T106","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,null,null,null,null,null,"Tier 1 (10)",{"$f":"SUM($T$132:$AC$132)","v":0},{"$f":"SUM($T$133:$AC$133)","v":0},{"$f":"SUM($T$131:$AC$131)","v":0},{"$f":"SUM($T$106:$AC$106)","v":20}]
[null,null,null,null,null,null,null,null,null,"Tier 2 (8)",{"$f":"SUM($AD$132:$AK$132)","v":0},{"$f":"SUM($AD$133:$AK$133)","v":0},{"$f":"SUM($AD$131:$AK$131)","v":0},{"$f":"SUM($AD$106:$AK$106)","v":16},null,null,null,"Strict Scoring"]
[null,null,null,null,null,null,null,null,null,"Tier 3 (8)",{"$f":"SUM($AL$132:$AS$132)","v":0},{"$f":"SUM($AL$133:$AS$133)","v":0},{"$f":"SUM($AL$131:$AS$131)","v":0},{"$f":"SUM($AL$106:$AS$106)","v":16},null,null,null,null," Pass Entry",{"$f":"IF(AND(T$104=0,T$103>0),\"1 |√|X\",IF(AND(T$103>0,T$104=0),\"1 |√|X\",\"0 or blank\"))","v":"0 or blank"},"0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank"]
[null,null,null,null,null,null,null,null,null,"Tier 4 (7)",{"$f":"SUM($AT$132:$AZ$132)","v":0},{"$f":"SUM($AT$133:$AZ$133)","v":0},{"$f":"SUM($AT$131:$AZ$131)","v":0},{"$f":"SUM($AT$106:$AZ$106)","v":14},null,null,null,null,"Fail",{"$f":"IF(T$104>0,\"1 |√|X\",\"0 or blank\")","v":"0 or blank"},"0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank"]
[null,null,null,null,null,null,null,null,null,"Tier 5 (7)",{"$f":"SUM($BA$132:$BG$132)","v":0},{"$f":"SUM($BA$133:$BG$133)","v":0},{"$f":"SUM($BA$131:$BG$131)","v":0},{"$f":"SUM($BA$106:$BG$106)","v":14},null,null,null,null,"N/A",{"$f":"IF(T131=1,\"1 |√|X\",\"0 or blank\")","v":"0 or blank"},{"$f":"IF(U131=1,\"1 |√|X\",\"0 or blank\")","v":"0 or blank"},"0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank","0 or blank",{"$f":"IF(BM131=1,\"1 |√|X\",\"0 or blank\")","v":"0 or blank"}]
[null,null,null,null,null,null,null,null,null,"Tier 6 (6)",{"$f":"SUM($BH$132:$BM$132)","v":0},{"$f":"SUM($BH$133:$BM$133)","v":0},{"$f":"SUM($BH$131:$BM$131)","v":0},{"$f":"SUM($BH$106:$BM$106)","v":12},null,null,null,null,"Blank",{"$f":"T106","v":2},2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2,2]
[null,null,null,null,null,null,null,null,null,"(criteria=46)",{"$f":"SUM(K121:K126)","v":0},{"$f":"SUM(L121:L126)","v":0},0,92,"left blank",null,null,"Intermediate calculations"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Pass or Fail (Not NA or Blank)",{"$f":"T103+T104","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,"↑  Above Fail cells need to be 0 for WCAG 2.0 AA compliance.",null,null,null,null,null,null,"Single Count Percentage Fail",{"$f":"IF(T$104=0,0,IF(T114<($T$111/100),1,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Mobile Doubling Percentage Fail",{"$f":"IF(T$104=0,0,IF(T115<($T$111/100),1,0))","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strict N/A",{"$f":"IF(AND(SUM(T103:T105)=T105,T105>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strict Pass",{"$f":"IF(AND(IF(AND(T$104=0,T$103>0),1,IF(OR(T$104>0,T$131=1),0,1)),T$103>0),1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Strict Fail",{"$f":"IF(T$104>0,1,0)","v":0},0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[]
["The below block, starting with the blank line below this one, is reserved for copying into newly opened page spaces with the \"Insert New Page Block\" button."]
[]
["[Enter Page URL in this cell]",null,null,"[Enter Page Name/Description in this cell]"]
["Protocol Items for Page","Help","Pass/Fail/NA","Severity","Notes","     User First",null,null,"User Last      ","Reviewed","NA","Pass","Fail","Blocker","Critical","Major","Minor","Lesser",null,"1.1 Keyboard Focus Visibility","1.2. Keyboard Focus Order","1.3. Keyboard Access","1.4. Keyboard Traps","1.5. Heading Levels","1.6. Color Contrast (Visual)","1.7. Video Captions","1.8. Live Video Captions","1.9. Audio Controls","1.10. Video/Animation Controls","2.1. Flashing Content","2.2. Page Title","2.3. Sensory Characteristics","2.4. Color","2.5. Headings and Labels","2.6. Navigation Consistency","2.7. Form Labels and Instructions (Visual)","2.8. Form Error Identification (Visual)","3.1. Appropriate Reading Order","3.2. Text Alternatives","3.3. Keyboard Focus Order (Screen Reader)","3.4. Keyboard Access (Screen Reader)","3.5. Keyboard Traps (Screen Reader)","3.6. Heading Levels (Screen Reader)","3.7. Form Labels and Instructions (Screen Reader)","3.8. Form Error Identification (Screen Reader)","4.1. Tables and Lists (Screen Reader)","4.2. Focus Triggers","4.3. Input Triggers","4.4. Skip Navigation","4.5. Color Contrast (CCA)","4.6. Zooming","4.7. Link Purpose (In Context)","5.1. Multiple Ways to Reach Page","5.2. Form Error Suggestions","5.3. Legal, Financial, and Data Error Prevention","5.4. Text Alternatives for Audio-only and Video-only Content","5.5. Audio Descriptions","5.6. Time Limits","5.7. Visual Relationships (Screen Reader)","6.1. Code Validation","6.2. Page Language","6.3. Changes in Language","6.4. UI Consistency","6.5. Images of Text","6.6. Name, Role, Value"]
["1.1. Keyboard Focus Visibility (2.4.7)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-visible.html",null,null,null,null,null,null,null,{"$f":"IF(C139<>\"\",1,0)","v":0},{"$f":"IF($C139=K$1,1,0)","v":0},0,0,{"$f":"IF($D139=N$1,1,0)","v":0},0,0,0,0,null,{"$f":"$C139","v":0}]
["1.2. Keyboard Focus Order (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,{"$f":"$C140","v":0}]
["1.3. Keyboard Access (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,{"$f":"$C141","v":0}]
["1.4. Keyboard Traps (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,{"$f":"$C142","v":0}]
["1.5. Heading Levels (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,{"$f":"$C143","v":0}]
["1.6. Color Contrast (Visual) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,{"$f":"$C144","v":0}]
["1.7. Video Captions (1.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,{"$f":"$C145","v":0}]
["1.8. Live Video Captions (1.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-real-time-captions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,{"$f":"$C146","v":0}]
["1.9. Audio Controls (1.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-dis-audio.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,{"$f":"$C147","v":0}]
["1.10. Video/Animation Controls (2.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-pause.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,{"$f":"$C148","v":0}]
["2.1. Flashing Content (2.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/seizure-does-not-violate.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C149","v":0}]
["2.2. Page Title (2.4.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-title.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C150","v":0}]
["2.3. Sensory Characteristics (1.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-understanding.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C151","v":0}]
["2.4. Color (1.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-without-color.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C152","v":0}]
["2.5. Headings and Labels (2.4.6)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-descriptive.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C153","v":0}]
["2.6. Navigation Consistency (3.2.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-locations.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C154","v":0}]
["2.7. Form Labels and Instructions (Visual) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C155","v":0}]
["2.8. Form Error Identification (Visual) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C156","v":0}]
["3.1. Appropriate Reading Order (1.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-sequence.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C157","v":0}]
["3.2. Text Alternatives (1.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/text-equiv-all.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C158","v":0}]
["3.3. Keyboard Focus Order (Screen Reader) (2.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-focus-order.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C159","v":0}]
["3.4. Keyboard Access (Screen Reader) (2.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-keyboard-operable.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C160","v":0}]
["3.5. Keyboard Traps (Screen Reader) (2.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/keyboard-operation-trapping.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C161","v":0}]
["3.6. Heading Levels (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C162","v":0}]
["3.7. Form Labels and Instructions (Screen Reader) (3.3.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-cues.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C163","v":0}]
["3.8. Form Error Identification (Screen Reader) (3.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-identified.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C164","v":0}]
["4.1. Tables and Lists (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C165","v":0}]
["4.2. Focus Triggers (3.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-receive-focus.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C166","v":0}]
["4.3. Input Triggers (3.2.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-unpredictable-change.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C167","v":0}]
["4.4. Skip Navigation (2.4.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-skip.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C168","v":0}]
["4.5. Color Contrast (CCA) (1.4.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-contrast.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C169","v":0}]
["4.6. Zooming (1.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-scale.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C170","v":0}]
["4.7. Link Purpose (In Context) (2.4.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-refs.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C171","v":0}]
["5.1. Multiple Ways to Reach Page (2.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/navigation-mechanisms-mult-loc.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C172","v":0}]
["5.2. Form Error Suggestions (3.3.3)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-suggestions.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C173","v":0}]
["5.3. Legal, Financial, and Data Error Prevention (3.3.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/minimize-error-reversible.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C174","v":0}]
["5.4. Text Alternatives for Audio-only and Video-only Content (1.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-av-only-alt.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C175","v":0}]
["5.5. Audio Descriptions (1.2.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/media-equiv-audio-desc-only.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C176","v":0}]
["5.6. Time Limits (2.2.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/time-limits-required-behaviors.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C177","v":0}]
["5.7. Visual Relationships (Screen Reader) (1.3.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/content-structure-separation-programmatic.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C178","v":0}]
["6.1. Code Validation (4.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-parses.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C179","v":0}]
["6.2. Page Language (3.1.1)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-doc-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C180","v":0}]
["6.3. Changes in Language (3.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/meaning-other-lang-id.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C181","v":0}]
["6.4. UI Consistency (3.2.4)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/consistent-behavior-consistent-functionality.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C182","v":0}]
["6.5. Images of Text (1.4.5)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/visual-audio-contrast-text-presentation.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C183","v":0}]
["6.6. Name, Role, Value (4.1.2)","http://www.w3.org/TR/UNDERSTANDING-WCAG20/ensure-compat-rsv.html",null,null,null,null,null,null,null,0,0,0,0,0,0,0,0,0,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"$C184","v":0}]

{"sheet":"Severity","index":1,"n_rows":33,"n_cols":2,"rows_kept":33,"cut":false,"hidden":false,"merged":[]}
["Michigan State University accessibility severity scale"]
["ACCESSIBILITY SEVERITY SCALE"]
["Level 4, Blocker: Prevents access to core processes or many secondary processes; causes harm or significant discomfort."]
["Level 3, Critical: Prevents access to some secondary processes; makes it difficult to access core processes or many secondary proceseses."]
["Level 2, Major: Makes it inconvenient to access core proceses or many secondary processes."]
["Level 1, Minor: Makes it inconvenient to access isolated processes."]
["Level 0, Lesser: Usability observation."]
[]
[]
[]
["Pass"]
["Fail"]
["NA"]
[]
["NOTICE: For the time being we are only setting the \"Blocker\" severity unless others have been requested by the vendor or site maintainer"]
[null,"If persons with any 1 type of disability will experience the difficulty as described, choose that level."]
["Blocker","Level 4: Prevents access to core processes or many secondary processes; causes harm or significant discomfort."]
["Critical","Level 3: Critical: Prevents access to some secondary processes; makes it difficult to access core processes or many secondary proceseses."]
["Major","Level 2: Makes it inconvenient to access core proceses or many secondary processes."]
["Minor","Level 1: Makes it inconvenient to access isolated processes."]
["Lesser","Level 0: Usability observation."]
[null,"NOTICE: Lesser should not be used within the 1.1-6.6 Tests block. Instead, insert a blank line or lines for useability errors below the 6.6 line for the page."]
[null,"Fill in the first column with \"Usability Issue\" and then fill in the \"Pass/Fail/NA\", \"Severity\", and \"Notes\" columns  as appropriate."]
[null,"For useability issues DO NOT copy down the formulas, etc., from the 6.6 or any Test line or attempt to fill in columns farther to the right than \"Notes\" as that would mess up the accessibility scoring."]
[]
["Single"]
["Double"]
[]
[]
[100]
[90]
[80]
[70]