{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Lists","Instructions","Results","Report","508 Impact Guide & Score Sheet"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":19,"comments":2,"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":"Lists","index":0,"n_rows":15,"n_cols":9,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
["Standards Options"]
["--"]
["Not Compliant"]
["Compliant"]
["NA"]
["Baseline Options"]
["--","--"]
["NC","NC"]
["C","DNA"]
["DNA"]
[]
["--",null,"--",null,"--",null,"--"]
["iOS",null,"Internet Explorer 8",null,"Compliant",null,"Disabled",null,"iOS AT: VoiceOver, Zoom, Inverse Color, AssistiveTouch, Larger Text"]
["Android",null,"Internet Explorer 9",null,"Not Compliant",null,"Enabled",null,"Android: TalkBack, Magnification, Large Text"]
[null,null,"Internet Explorer 11"]

{"sheet":"Instructions","index":1,"n_rows":45,"n_cols":5,"rows_kept":45,"cut":false,"hidden":false,"merged":[[3,2,3,13],[29,2,29,13],[31,3,31,13],[9,2,9,13],[10,2,10,13],[21,4,21,13],[22,4,22,13],[23,4,23,13],[18,2,18,13],[11,3,11,13],[13,3,13,13],[14,3,14,13],[15,3,15,13],[16,3,16,13],[38,2,38,13],[42,2,42,13],[43,2,43,13],[48,2,48,13],[30,3,30,13],[32,3,32,13],[33,3,33,13],[44,4,44,13],[47,4,47,13],[39,2,39,13],[45,4,45,13],[46,4,46,13],[0,2,0,13],[34,3,34,13],[8,2,8,13],[6,2,6,13],[7,2,7,13],[28,2,28,13],[20,2,20,13],[27,3,27,13],[5,2,5,13],[4,2,4,13],[2,2,2,13],[1,2,1,13],[12,3,12,13],[24,4,24,13],[17,3,17,13],[19,3,19,13]]}
[null,null,"Instructions"]
[]
[]
[null,null,"IMPORTANT: Save this file to a project folder before entering screenshots. "]
[null,null,"This workbook is protected so that only certain cells are editable and certain operations are allowed. Unprotecting it may allow you to edit it in a way that produces invalid results."]
[null,null,"Some worksheets, such as this one, have Grouping controls in the left margin. These allow you to expand or collapse certain sections for easier viewing, by clicking on the + or - icons or outlines."]
[]
[]
[]
[null,null,"Results Worksheet"]
[null,null,"This is where you enter testing results, which are later compiled into the Report worksheet. You should not add or delete rows manually; use the provided macros instead."]
[null,null,"1.","For each test, enter the test results in the Test Results column. Typing C, N, or D, should autofill with C (Compliant), NC (Not Compliant) or DNA (Does Not Apply)."]
[null,null,"2.","Enter the failure details in the Failure Details column. All tests marked NC must have failure details."]
[null,null,"3.","To include a screenshot, select the associated cell in the Screenshots column and click Insert Image (or Ctrl-i). Remember to crop screenshots judiciously, and highlight the specific error if necessary. Note: inserted images are copied to the current directory in order to generate the HTML report."]
[null,null,"4.","You should insert only one screenshot per row. To include more than one screenshot for the same failure condition, click Add Row (or Ctrl-d) and insert a new screenshot in the new row."]
[null,null,"5.","To delete a screenshot, select the cell that contains the screenshot and click Delete Image (or Ctrl-j). (If you select the image object instead of the containing cell, you will get an error message.)"]
[null,null,"6.","To view an embedded screenshot (by double-clicking), unprotect the worksheet (Review > Unprotect Sheet). This is also needed if you need to perform formatting operations (e.g. resizing rows, etc.)."]
[null,null,"6.","To delete an added row, click Delete Row (or Ctrl-e). This deletes the screenshot on that row as well."]
[]
[null,null,null,"Most of the following shortcuts should normally be used at the start of testing, as their effects are NOT undoable:"]
[]
[null,null,null,"Toggle DNA","Some sections have \"Toggle DNA\" buttons in the first column. These buttons switch between \"DNA\" and \"--\" for all rows in that section."]
[null,null,null,"Set Android-Only to DNA","Sets all Android-only tests to DNA."]
[null,null,null,"Set iOS-Only to DNA","Sets all iOS-only tests to DNA."]
[null,null,null,"Clear All","Clears all Test Results, Failure Details, and screenshots, and deletes added rows."]
[]
[]
[]
[null,null,"Report Worksheet"]
[null,null,"This worksheet provides fields to enter information about the report (e.g. tester name, application name, etc.), and also compiles NC results from the Results worksheet."]
[null,null,"1.","Click Generate Report Summary. This compiles information from the Results worksheet."]
[null,null,"2.","Enter the report header information (E6 to E33). (Disabilities Impacted is automatically calculated from the Impact Guide worksheet.)"]
[null,null,"3.","Review the NC Defects section for accuracy. If edits are necessary, please make them on the Results worksheet and regenerate the Report Summary. "]
[null,null,"4.","The Section 508 Baseline Test Report Checklist section is automatically calculated from the Results worksheet."]
[null,null,"5.","To create the HTML report, click Generate HTML report button located below the checklist (at cell J60)"]
[]
[]
[]
[null,null,"508 Impact Guide Worksheet"]
[null,null,"This worksheet calculates the impact of the failures reported in the Results worksheet. No user input is needed."]
[]
[]
[]
[null,null,"Version History"]
[null,null,"Mi1.0","2017-04-06","Initial version"]

{"sheet":"Results","index":2,"n_rows":59,"n_cols":75,"rows_kept":59,"cut":false,"hidden":false,"merged":[[1,23,1,24]]}
["Import old version?","N"]
[null,null,"Version Mi1.0",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"22(b)"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(OR(X4=\"NC\",Y4=\"NC\"),\"NC\",IF(OR(X4=\"C\",Y4=\"C\"),\"C\",IF(OR(X4=\"DNA\",Y4=\"DNA\"),\"DNA\",\"--\")))","v":"--"}]
[null,null,null,null,null,null,null,null,null,"Results:",{"$f":"IF(COUNTIF(K6:K56,\"NC\"),\"NC\",IF(COUNTIF(K6:K56,\"C\"),\"C\",IF(COUNTIF(K6:K56,\"DNA\"),\"DNA\",\"--\")))","v":"--"},"--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--",{"$f":"IF(COUNTIF(AQ6:AQ56,\"NC\"),\"NC\",IF(COUNTIF(AQ6:AQ56,\"C\"),\"C\",IF(COUNTIF(AQ6:AQ56,\"DNA\"),\"DNA\",\"--\")))","v":"--"},"--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--","--"]
["DHS Test Steps","Test IDs","Failure Conditions","Standards","Baselines","Test Results","Web-only or SW only?","Section ID (for setting NA)","Failure Details (Provide Screen/Location)","Screenshots","21(a)","21(b)","21(c)","21(d)","21(e)","21(f)","21(g)","21(h)","21(i)","21(j)","21(k)","21(l)","22(a)","22(b1)","22(b2)","22(c)","22(d)","22(e)","22(f)","22(g)","22(h)","22(i)","22(j)","22(k)","22(l)","22(m)","22(n)","22(o)","22(p)","24(c)","24(d)","31(a)","31(b)","31(c)","31(d)","31(e)","31(f)","B01","B02","B03","B04","B05","B06","B07","B08","B09","B10","B11","B12","B13","B14","B15","B16","B17","B18","B19","B20","B21","B22","B23","B24","B25","B26","B27","B28"]
["1.1 Keyboard Access","A","An interactive element or function cannot be accessed or activated by keyboard","31(a), 31(f)","B01","--",null,null,null,null,{"$f":"IFERROR(IF(SEARCH(K$5,$D6),$F6,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--",{"$f":"IFERROR(IF(SEARCH(AV$5,$E6),$F6,\"-\"),\"x\")","v":"--"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"B","A keyboard \"trap\" is found","31(a), 31(f)","B01","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"C","Non-standard or alternative keyboard commands are required for access but are not documented","31(a), 31(f)","B01","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"D","Information/Interactive elements revealed by single finger Tap and Hold gesture are not available to keyboard-only users","31(a), 31(f)","B01","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"E","At any time, there is no visual indication of the current focus (loss of focus)","31(a), 31(f)","B02","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"F","The visual focus appears on the wrong element","31(a), 31(f)","B02","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"G","The visual focus does not remain within a modal dialog box until closed ","31(a), 31(f)","B04","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(U$5,$D12),$F12,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AK$5,$D12),$F12,\"-\"),\"x\")","v":"x"},"x","x","x","x","--","x","x","x","x","--","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"H","The visual focus does not move to revealed content and no description of the content change is provided ","31(a), 31(f)","B04","--",null,null,null,null,{"$f":"IFERROR(IF(SEARCH(K$5,$D13),$F13,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"I","The keyboard reading order is not logical","31(a), 31(f)","B03","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","--","x","x","--",{"$f":"IFERROR(IF(SEARCH(AY$5,$E14),$F14,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BO$5,$E14),$F14,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x"]
["2.1 Elements Test","A","A meaningful image does not have an equivalent  description (purpose and function)","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AV$5,$E15),$F15,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"B","A decorative image is announced by the screen reader","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"C","An image has inconsistent meaning","31(a), 31(b)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"D","An image that contains text does not have the same text announced by the screen reader","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"E","Any element that has multiple statuses that are meaningful for interaction does not indicate its current status","31(a), 31(b)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"F","The screen reader output for form fields (text field, checkbox, radio button, etc.) does not match its visual label or does not include complete instructions and cues","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"G","A user control, link, or other interactive element does not have a descriptive and unique name  and does not identify purpose (to include alerting the user of the interactive function of the control)","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"H","Visually apparent headings are not programmatically identified","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AJ$5,$D22),$F22,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"I","Programmatically identified heading levels do not match the visual outline","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AA$5,$D23),$F23,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"J","Every element does not provide sufficient information for user operation (otherwise not listed)","31(a)","B09","--",null,null,null,null,{"$f":"IFERROR(IF(SEARCH(K$5,$D24),$F24,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"K","An element or function cannot be accessed or activated by gesture","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BL$5,$E25),$F25,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BV$5,$E25),$F25,\"-\"),\"x\")","v":"x"},"x"]
[null,"L","A gesture \"trap\" is found","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AV$5,$E26),$F26,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"M","Non-standard or alternative gesture commands are required for access but are not documented","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"N","Information/Interactive elements revealed by single finger Tap and Hold gesture are not available to screen reader users","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["2.2 Layout Test","A","Layout changes such as changes from portrait to landscape or a forced application direction are not indicated or announced by screen reader with sufficient information for user to orient device.","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.1 Video-only and Animation","A","Video-only content that starts automatically does not have a playback control.","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"B","Animation that starts automatically, lasts more than 5 seconds and is presented in parallel with other content does not have a playback control or allow control of frequency for update.","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"C","Video-only or animated content does not have an equivalent text or audio description.","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.2 Audio-only","A","Audio content that plays automatically and lasts for more than 3 seconds does not have a playback control or a mechanism to independently control audio volume","31(c)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"B","An audio file does not have an equivalent text description/transcript","31(c)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["3.3 Multimedia","A","Multimedia content that starts automatically does not have a playback control.","31(a), 31(c) ","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"B","Synchronized captions are not provided for multimedia","31(c) ","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"C","The provided captions for multimedia are not equivalent","31(c) ","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"D","Synchronized audio descriptions are not provided for multimedia","31(a)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AP$5,$D38),$F38,\"-\"),\"x\")","v":"--"},"x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"E","The provided audio descriptions are not equivalent","31(a) ","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(Z$5,$D39),$F39,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"F","The application did not adopt all of the iOS Caption settings","31(c) ","B09","--",null,null,null,null,{"$f":"IFERROR(IF(SEARCH(K$5,$D40),$F40,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["4.1 Color Dependence","A","Information is provided only by color","31(a) ","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BL$5,$E41),$F41,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x"]
["4.2 Color Contrast","A","The contrast ratio is less than 4.5:1 for content background and foreground colors","31(b)","B09","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AV$5,$E42),$F42,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
["5 Flashing","A","If the page contains flashing, flickering, or scrolling","21(k)","B10","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BV$5,$E43),$F43,\"-\"),\"x\")","v":"x"},"x"]
["6 Time Outs","A","The application timed out without notification","31(a), 31(b), 31(c), 31 (d), 31(f)","B25","--",null,6,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","--","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
[null,"B","The application's time out notification is displayed for less than 20 seconds","31(f)","B25","--",null,6,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
[null,"C","The application timed out without an option to request more time","31(a), 31(b), 31(c), 31 (d), 31(f)","B25","--",null,6,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","--","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
["7  Built-in Accessibility Features","A","The app did not completely adopt larger text","31(b) ","B26","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x"]
[null,"B","The application does not adopt the inverse color settings","31(b) ","B26","--","IO",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x"]
[null,"C","The application did not adopt the OS invert colors, or the application does not offer at least 4 color options","31(b)",null,"--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"D","Text of application did not enlarge or became illegible when enlarged with zoom","31(b)",null,"--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x"]
[null,"E","AssistiveTouch functionality was disrupted in the application","31(f)","B26","--","IO",null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(BM$5,$E51),$F51,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","--","x","x"]
[null,"F","Speak Screen did not read the entire screen or highlighting was not in sync with the audio","31(b)","B26","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x"]
[null,"G","The application did not allow user to utilize the microphone for text input","31(f)","B25","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(Z$5,$D53),$F53,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","x","x","x","x","x","x","x","x","x",{"$f":"IFERROR(IF(SEARCH(AO$5,$D53),$F53,\"-\"),\"x\")","v":"x"},"x","x","x","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
[null,"H","The application disrupted any of the OS Accessibility options (VoiceOver, Zoom, Larger Text, Invert Color, AssistiveTouch, Speak Screen, Caption settings)","31(a), 31(b), 31(c), 31 (d), 31(f)","B25","--",null,null,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","--","x","x","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
["8 Alternative (Accessible) Version","A","An alternative does not contain equivalent information as the primary application","31(a), 31(b), 31(c), 31(d), 31(e), 31(f)","B25","--",null,8,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--",{"$f":"IFERROR(IF(SEARCH(AQ$5,$D55),$F55,\"-\"),\"x\")","v":"--"},"--","--","--","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
[null,"B","The primary application can be made compliant","31(a), 31(b), 31(c), 31(d), 31(e), 31(f)","B25","--",null,8,null,null,"x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","--","--","--","--","--","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","x","--","x","x","x"]
[null,null,null,null,null,"NC","Last"]
[null,null,null,null,null,"C"]
[null,null,null,null,null,"DNA"]

{"sheet":"Report","index":3,"n_rows":45,"n_cols":12,"rows_kept":45,"cut":false,"hidden":false,"merged":[[34,3,34,4],[36,7,36,23],[0,7,0,23],[19,10,21,21],[12,11,13,21],[12,10,13,10],[9,11,9,21],[17,10,17,21],[18,10,18,21],[5,10,5,21],[1,10,1,21],[7,10,7,21],[8,11,8,21],[10,11,11,21]]}
[null,null,null,null,null,null,null,"Agency Specific Test Approaches for DHS"]
[]
[null,null,null,null,"2.  Complete the fields below (E6 - E33)."]
[null,null,null,null,"3.  Generate the HTML report (button below or at J60 or Control + Shift + R)"]
[null,null,null,"Requestor"]
[null,null,null,"Name:",null,null,null,null,null,null,"DHS specific test approach for Flashing (Section 508 [21k])"]
[null,null,null,"Agency:"]
[null,null,null,"Component:",null,null,null,null,null,null,"How to Test"]
[null,null,null,"Email:",null,null,null,null,null,null,1,"Visually check for any flashing or blinking interface elements or scrolling text. Scrolling images should be tested under Section 2.2 (SW animation) or Section 2.4 (video)."]
[null,null,null,"Phone:",null,null,null,null,null,null,2,"Mark any such elements as NC."]
[null,null,null,"Trusted Tester"]
[null,null,null,"Name:"]
[null,null,null,"Agency:"]
[null,null,null,"Component:"]
[null,null,null,"Email:"]
[null,null,null,"Phone:"]
[null,null,null,"Trusted Tester ID #:"]
[null,null,null,"Report Summary",null,null,null,null,null,null,"DHS specific test approach for Variety of Color Selections in SW (Section 508 21j)"]
[null,null,null,"Review Date:",null,null,null,null,null,null,"How to Test"]
[null,null,null,"Application Name:",null,null,null,null,null,null,"If the application did not adopt the OS high contrast colors, and the application does not offer at least 4 color options, 31(b) is Not Compliant"]
[null,null,null,"Application Version Tested:"]
[null,null,null,"URL (if web site):"]
[null,null,null,"Vendor:"]
[null,null,null,"Application Description:"]
[null,null,null,"Functions Tested:"]
[null,null,null,"Test Results:"]
[null,null,null,"Disabilities Impacted:",{"$f":"'508 Impact Guide & Score Sheet'!C54","v":"None"}]
[null,null,null,"Test Environment"]
[null,null,null,"Operating System:","iOS"]
[null,null,null,"OS Version:"]
[null,null,null,"Device:"]
[null,null,null,"Built-in AT Used:","iOS AT: VoiceOver, Zoom, Inverse Color, AssistiveTouch, Larger Text, Speak Screen, Caption Settings"]
[null,null,null,"Comments:"]
[]
[null,null,null,"Note: This review is a sampling of pages to confirm the component self-assessment as to their compliance with Section 508. The responsibility for full and complete testing and compliance remains with the owner of the application or website.\n\n\n"]
[]
["Defect #","Standards","Baselines","DHS Test","Details","Screenshot (Ctrl-w)",null,"Section 508 Test Report Checklist"]
[null,null,null,null,null,null,null,null,"21(k)","Blinking objects ",{"$f":"Results!U$4","v":"--"}]
[]
[null,null,null,null,null,null,null,null,"31(a)","Use without vision",{"$f":"Results!AP$4","v":"--"}]
[null,null,null,null,null,null,null,null,"31(b)","Use with low vision",{"$f":"Results!AQ$4","v":"--"}]
[null,null,null,null,null,null,null,null,"31(c)","Use without hearing",{"$f":"Results!AR$4","v":"--"}]
[null,null,null,null,null,null,null,null,"31(d)","Use with hard of hearing",{"$f":"Results!AS$4","v":"--"}]
[null,null,null,null,null,null,null,null,"31(e)","Use without speech",{"$f":"Results!AT$4","v":"--"}]
[null,null,null,null,null,null,null,null,"31(f)","Use with physical limitations",{"$f":"Results!AU$4","v":"--"}]

{"sheet":"508 Impact Guide & Score Sheet","index":4,"n_rows":58,"n_cols":8,"rows_kept":58,"cut":false,"hidden":false,"merged":[[57,2,57,6],[54,0,54,6],[0,1,0,6],[1,0,1,6],[2,0,2,6],[16,0,16,6],[52,0,52,6],[53,2,53,6]]}
["Application Name:",{"$f":"Report!E20","v":0}]
["Section 508 Software, Web, Multimedia and Functional Performance Criteria Failures Impact Report"]
["The results of testing for 508 Software and Web standards are shown below: C=compliant, NC=not compliant, NA=not applicable.  This table shows the impact of each 508 standard on specific disability groups.  (*Other includes color blindness, cognitive and seizure-related disabilities.)  The testing outcome is shown at the bottom of this page."]
["1194.21 Software Standards","Test Results","Blind","Low Vision","Deaf/ Hard of Hearing","Mobility","*Other"]
["a. Keyboard access",{"$f":"Results!K4","v":"--"},"x",null,null,"x"]
["b. OS accessibility settings ",{"$f":"Results!L4","v":"--"},null,"x","x","x"]
["c. On screen focus",{"$f":"Results!M4","v":"--"},"x","x",null,"x"]
["d. Sufficient information for user interface elements",{"$f":"Results!N4","v":"--"},"x",null,null,"x"]
["e. Bit map image consistency",{"$f":"Results!O4","v":"--"},null,null,null,null,"x"]
["f. Textual information through operating system functions",{"$f":"Results!P4","v":"--"},"x"]
["g. User color and contrast settings",{"$f":"Results!Q4","v":"--"},null,"x"]
["h. Animation alternative",{"$f":"Results!R4","v":"--"},"x","x"]
["i. Color dependency",{"$f":"Results!S4","v":"--"},"x","x",null,null,"x"]
["j. Color selection variety",{"$f":"Results!T4","v":"--"},null,"x",null,null,"x"]
["k. Flashing elements",{"$f":"Results!U4","v":"--"},null,null,null,null,"x"]
["l. Label form fields",{"$f":"Results!V4","v":"--"},"x"]
[]
["Disabilities Impacted by all 508 Software Failures",null,{"$f":"IF(OR(B5=\"nc\",,B7=\"nc\",B8=\"nc\",B10=\"nc\",B12=\"nc\",B13=\"nc\",B16=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B6=\"nc\",B7=\"nc\",B11=\"nc\",B12=\"nc\",B13=\"nc\",B14=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(B6=\"nc\",\"X\",\"\")","v":""},{"$f":"IF(OR(B5=\"nc\",B6=\"nc\",B7=\"nc\",B8=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B9=\"nc\",B15=\"nc\",B14=\"nc\",B13=\"nc\"),\"X\",\"\")","v":""}]
[]
["1194.22 Web Standards","Test Results","Blind","Low Vision","Deaf/ Hard of Hearing","Mobility","*Other"]
["a. Text equivalents ",{"$f":"Results!W4","v":"--"},"x"]
["b1. Synchronized captions",{"$f":"Results!X4","v":"--"},null,null,"x"]
["b2. Synchronized audio description",{"$f":"Results!Y4","v":"--"},"x","x"]
["c. Color dependence",{"$f":"Results!Z4","v":"--"},"x","x",null,null,"x"]
["d. Style sheet dependence",{"$f":"Results!AA4","v":"--"},"x","x",null,null,"x"]
["e and f. Use of server side image maps",{"$f":"Results!AC4","v":"--"},"x",null,null,"x"]
["g. Data tables: Identify row and column headers",{"$f":"Results!AD4","v":"--"},"x"]
["h. Complex data tables: Associate data cells to row and column headers",{"$f":"Results!AE4","v":"--"},"x"]
["i. Descriptive titles for frames.",{"$f":"Results!AF4","v":"--"},"x"]
["j. Flashing elements",{"$f":"Results!AG4","v":"--"},null,null,null,null,"x"]
["k. Equivalent text only page, only when necessary.",{"$f":"Results!AH4","v":"--"},"x","x","x","x"]
["l. Functional text for scripts",{"$f":"Results!AI4","v":"--"},"x"]
["m. Provide plugin links when required",{"$f":"Results!AJ4","v":"--"},"x"]
["n. Label form fields",{"$f":"Results!AK4","v":"--"},"x"]
["o. Skip repetitive navigation links",{"$f":"Results!AL4","v":"--"},"x","x",null,"x"]
["p. Timed response",{"$f":"Results!AM4","v":"--"},"x","x",null,"x","x"]
[]
["Disabilities Impacted by all 508 Web Failures",null,{"$f":"IF(OR(B21=\"nc\",B23=\"nc\",B24=\"nc\",B25=\"nc\",B26=\"nc\",B27=\"nc\",B28=\"nc\",B29=\"nc\",B31=\"nc\",B32=\"nc\",B32=\"nc\",B33=\"nc\",B34=\"nc\",B35=\"nc\",B36=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B23=\"nc\", B24=\"nc\",B25=\"nc\",B31=\"nc\",B35=\"nc\",B36=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B22=\"nc\",B31=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B26=\"nc\",B31=\"nc\",B35=\"nc\",B36=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(B25=\"nc\",B30=\"nc\",B36=\"nc\",B24=\"nc\"),\"X\",\"\")","v":""}]
[]
["1194.24 Multimedia Standards","Test Results","Blind","Low Vision","Deaf/ Hard of Hearing","Mobility","*Other"]
["c. Captions",{"$f":"Results!X4","v":"--"},null,null,"x"]
["d. Audio Descriptions",{"$f":"Results!Y4","v":"--"},"x","x"]
[]
["1194.31 Functional Performance Criteria Standards","Test Results","Blind","Low Vision","Deaf/ Hard of Hearing","Mobility","*Other","Speech"]
["a. Use without vision",{"$f":"Results!AP4","v":"--"},"x"]
["b. Use with low vision",{"$f":"Results!AQ4","v":"--"},null,"x"]
["c. Use without hearing",{"$f":"Results!AR4","v":"--"},null,null,"x"]
["e. Use without speech",{"$f":"Results!AU4","v":"--"},null,null,null,null,null,"x"]
["f. Use with physical limitations",{"$f":"Results!AU4","v":"--"},null,null,null,"x"]
[]
["Disabilities Impacted by Software, Web  and FPC Provision Failures",{"$f":"IF(AND(B18=\"none\", B38=\"none\"),\"NONE\",\"\")","v":""},{"$f":"IF(OR(B42=\"nc\",C18=\"X\",C38=\"X\", B45=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(D18=\"X\",D38=\"X\",B42=\"nc\", B46=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(E18=\"X\",E38=\"X\", B41=\"nc\",B47=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(F18=\"X\",F38=\"X\", B49=\"nc\"),\"X\",\"\")","v":""},{"$f":"IF(OR(G18=\"X\",G38=\"X\"),\"X\",\"\")","v":""},{"$f":"IF(B48=\"X\",\"X\",\"\")","v":""}]
[]
["Testing Outcome"]
["Total Disabilities Impacted by 508 failures:",{"$f":"COUNTIF(C51:H51,\"X\")","v":0},{"$f":"IF(B54>0, LEFT(C58,LEN(C58)-2),\"None\")","v":"None"}]
["(If 1 or more disabilities are unable to use this application due to 508 failures, this application is Not Compliant.)"]
[]
[null,null,{"$f":"IF(C51=\"X\", \"Blind, \",\"\")","v":""},{"$f":"IF(D51=\"X\", \"Low Vision, \",\"\")","v":""},{"$f":"IF(E51=\"X\", \"Deaf/Hard of Hearing, \",\"\")","v":""},{"$f":"IF(F51=\"X\", \"Mobility, \",\"\")","v":""},{"$f":"IF(G51=\"X\", \"Other, \",\"\")","v":""}]
[null,null,{"$f":"IF(B54>0, CONCATENATE(C57,D57,E57,F57,G57,H57),\"None\")","v":"None"}]