{"text_format":"1","workbook":"xlsx","n_sheets":3,"sheets":["Cover Sheet","Final Report","dataVal"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":12,"comments":0,"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":"Cover Sheet","index":0,"n_rows":87,"n_cols":3,"rows_kept":87,"cut":false,"hidden":true,"merged":[]}
["Request Type:","Formal"]
["Application Name:","<App Name>"]
["Release / Version#:"]
["Project Aliases:"]
["Start Date:"]
["End Date:"]
["Test URL: "]
["Requestor's Name:"]
["JAWS Tester:  "]
["Code Inspector: "]
["Test Lead: "]
["Test Envn:","<JAWS 2020; Win 10; Chrome Edge; Dev Tools>"]
[{"$f":"IF($B$1=dataVal!#REF!,\"# Critical Defects:\",\"# Critical Issues:\")","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(COUNTIFS('Final Report'!F2:F63,dataVal!#REF!,'Final Report'!G2:G63,\"Critical\")+COUNTIFS('Final Report'!F2:F63,\"Fail\",'Final Report'!G2:G63,\"Deferred\"),\";\",\" \",dataVal!F3,\"(\",dataVal!#REF!,\")\")","v":{"$error":"#REF!"}}]
[{"$f":"IF($B$1=dataVal!#REF!,\"# Major Defects:\",\"# Major Issues:\")","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(COUNTIFS('Final Report'!F2:F63,dataVal!#REF!,'Final Report'!G2:G63,\"Major\")+COUNTIFS('Final Report'!F2:F63,dataVal!#REF!,'Final Report'!G2:G63,\"Deferred\"),\";\",\" \",dataVal!F3,\"(\",dataVal!#REF!,\")\")","v":{"$error":"#REF!"}}]
[{"$f":"IF($B$1=dataVal!#REF!,\"# Minor Defects:\",\"# Minor Issues:\")","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(COUNTIFS('Final Report'!F2:F63,dataVal!#REF!,'Final Report'!G2:G63,\"Minor\")+COUNTIFS('Final Report'!F2:F63,dataVal!#REF!,'Final Report'!G2:G63,\"Deferred\"),\";\",\" \",dataVal!F3,\"(\",dataVal!#REF!,\")\")","v":{"$error":"#REF!"}}]
[{"$f":"IF($B$1=dataVal!#REF!,\"# Deferred Defects:\",\"# Deferred Issues:\")","v":{"$error":"#REF!"}},{"$f":"CONCATENATE(dataVal!#REF!,\":\",dataVal!#REF!,\";\",dataVal!#REF!,\":\",dataVal!#REF!,\";\",dataVal!#REF!,\":\",dataVal!#REF!,\";\", dataVal!#REF!,\":\",dataVal!#REF!, \";\", dataVal!#REF!,\":\",dataVal!#REF!, \";\",dataVal!#REF!,\":\",dataVal!#REF!,\";\",dataVal!#REF!,\":\",dataVal!#REF!)","v":{"$error":"#REF!"}}]
[{"$f":"IF($B$1=dataVal!#REF!,\"# Resolved Defects:\",\"# Resolved Issues:\")","v":{"$error":"#REF!"}},{"$f":"COUNTIFS('Final Report'!F2:F63,\"Resolved\",'Final Report'!G2:G63,\"Critical\")+COUNTIFS('Final Report'!F2:F63,\"Resolved\",'Final Report'!G2:G63,\"Major\")+COUNTIFS('Final Report'!F2:F63,\"Resolved\",'Final Report'!G2:G63,\"Minor\")","v":0}]
["Comments:"]
["Important Information:",{"$f":"IF(B1=dataVal!#REF!,dataVal!#REF!,dataVal!#REF!)","v":{"$error":"#REF!"}}]
[null,{"$f":"IF(B1=dataVal!#REF!, HYPERLINK(\"http://testingwizard.ssahost.ba.ssa.gov/default.aspx\",\"http://testingwizard.ssahost.ba.ssa.gov/default.aspx\"),\"\")","v":{"$error":"#REF!"}}]
[]
["Req ID","Number of Defects","Number Failed per Req"]
[1.1000000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A23)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A23, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[1.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A24)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A24, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[1.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A25)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A25, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[1.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A26)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A26, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[1.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A27)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A27, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[2.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A28)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A28, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[3.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A29)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A29, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[3.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A30)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A30, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[4.0999999999999996,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A31)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A31, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[4.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A32)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A32, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[5.0999999999999996,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A33)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A33, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[5.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A34)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A34, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[6.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A35)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A35, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[6.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A36)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A36, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[7.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A37)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A37, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[7.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A38)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A38, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[7.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A39)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A39, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[7.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A40)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A40, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[7.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A41)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A41, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[7.6,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A42)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A42, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[7.7,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A43)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A43, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[8.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A44)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A44, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[8.1999999999999993,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A45)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A45, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[8.3000000000000007,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A46)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A46, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[9.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A47)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A47, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[11.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A48)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A48, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[11.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A49)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A49, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[11.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A50)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A50, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A51)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A51, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A52)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A52, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.6,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A53)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A53, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.7,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A54)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A54, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.8,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A55)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A55, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[11.9,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A56)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A56, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[12.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A57)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A57, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[13.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A58)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A58, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[13.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A59)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A59, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[13.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A60)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A60, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[13.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A61)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A61, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[14.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A62)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A62, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[14.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A63)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A63, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[15.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A64)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A64, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[15.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A65)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A65, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[16.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A66)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A66, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[16.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A67)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A67, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[16.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A68)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A68, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[17.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A69)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A69, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[17.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A70)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A70, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[18.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A71)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A71, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[18.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A72)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A72, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[19.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A73)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A73, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[19.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A74)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A74, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[20.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A75)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A75, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[20.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A76)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A76, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[21.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A77)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A77, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[22.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A78)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A78, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[23.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A79)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A79, 'Final Report'!$F$2:$F$63,\"Fail\")","v":1}]
[23.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A80)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A80, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[24.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A81)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A81, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[25.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A82)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A82, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[25.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A83)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A83, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[26.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A84)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A84, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[27.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A85)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A85, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[28.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A86)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A86, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]
[29.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$63, 'Cover Sheet'!$A87)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$63,'Cover Sheet'!$A87, 'Final Report'!$F$2:$F$63,\"Fail\")","v":0}]

{"sheet":"Final Report","index":1,"n_rows":52,"n_cols":11,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
["Tests"," Pass Condition"," Defect ID","Instance","Pass Conditions\n","Result","Severity","Reason for Deferred ","Location","Description","Remediation"]
["1. Speech Enabled",1.1000000000000001,{"$f":"CONCATENATE($B2,CONCATENATE(\".\",$D2))","v":"1.1.0"},0,"There is a speech mode for blind and low vision users.  ","Fail","N/A","N/A"]
["1. Speech Enabled",1.2,{"$f":"CONCATENATE($B3,CONCATENATE(\".\",$D3))","v":"1.2.0"},0,"There are Braille instructions on how to initiate speech mode (contracted Braille conforming to 36 CFR part 1191; Appendix D; Section 703.3.1).  ","Fail","N/A","N/A"]
["1. Speech Enabled",1.3,{"$f":"CONCATENATE($B4,CONCATENATE(\".\",$D4))","v":"1.3.0"},0,"Instructions on the location and layout of operable parts is available to the user through speech and Braille (contracted Braille conforming to 36 CFR part 1191; Appendix D; Section 703.3.1).  ","Fail","N/A","N/A"]
["1. Speech Enabled",1.4,{"$f":"CONCATENATE($B5,CONCATENATE(\".\",$D5))","v":"1.4.0"},0,"Except where necessary to protect privacy, the user receives speech output making them aware of the selections and and user input before data is sent to a system.  ","Fail","N/A","N/A"]
["2. Interruption/Repetition of Speech\n",2.1,"2.1.0",0,"Except when necessary to the user experience, speech output for any single function is interrupted when the user moves focus to another interface, activates an interface, or presses a designated operable control.","Fail","N/A","N/A"]
["2. Interruption/Repetition of Speech\n",2.2000000000000002,"2.2.0",0,"There is a method for the user to repeat the speech output for any single function.","Fail","N/A","N/A"]
["3. Screen Text Size/Contrast\n",3.1,"3.1.0",0,"Screen text is displayed in a sans serif font.","Fail","N/A","N/A"]
["3. Screen Text Size/Contrast\n",3.2,"3.2.0",0,"There is a screen enlargement mode or the screen text size is large (has an uppercase letter “I” of at least 3/16 inch (4.8 mm)).","Fail","N/A","N/A"]
["3. Screen Text Size/Contrast\n",3.3,"3.3.0",0,"Informational, non-decorative text has a contrast ratio of 4.5:1 or greater. Large, non-decorative text (font-size of 18pt or font-size of 14pt and bold) has a contrast ratio of 3:1 or greater.","Fail","N/A","N/A"]
["4. Visible Focus\n\n",4.0999999999999996,"4.1.0",0,"There must be a visible indication of the currently focused interactive element.","Fail","N/A","N/A"]
["5. Focus Order",5.0999999999999996,"5.1.0",0,"The focus order follows the logical order and component groupings.","Fail","N/A","N/A"]
["5. Focus Order",5.2,"5.2.0",0,"The relative order of repeated components does not change between screens.","Fail","N/A","N/A"]
["6. Forms and Instructions\n",6.1,"6.1.0",0,"All instructions and cues (including whether a field is considered 'required') are conveyed to the user through speech output.","Fail","N/A","N/A",null,{"$f":"CONCATENATE($B14,CONCATENATE(\".\",$D14))","v":"6.1.0"}]
["6. Forms and Instructions\n",6.2,"6.2.0",0,"[SSA Method]  All radio button and checkbox elements are associated with a visible label.","Fail","N/A","N/A"]
["6. Forms and Instructions\n",6.3,"6.3.0",0,"If an input error is automatically detected, the item with an error is identified and described to the user through speech output and screen text.","Fail","N/A","N/A"]
["6. Forms and Instructions\n",6.4,"6.4.0",0,"Users can review information before confirming legal commitments or financial transactions. ","Fail","N/A","N/A"]
["6. Forms and Instructions\n",6.5,"6.5.0",0,"[SSA Method]  When post-submission error handling is present, the SSA best practices are used.","Fail","N/A","N/A"]
["7. Links and User Controls",7.1,"7.1.0",0,"Information, relationships, and status of links, buttons, and other on-screen user controls must be conveyed visually and through speech output.","Fail","N/A","N/A"]
["8. Meaningful CAOS Characteristics",8.1,"8.1.0",0,"Color is not used as the only visual means of conveying information. ","Fail","N/A","N/A"]
["8. Meaningful CAOS Characteristics",8.1999999999999993,"8.2.0",0,"Meaningful visual characteristics are conveyed through speech output.","Fail","N/A","N/A"]
["8. Meaningful CAOS Characteristics",8.3000000000000007,"8.3.0",0,"Meaningful audio characteristics are conveyed visually.","Fail","N/A","N/A"]
["9. Time Outs",9.1,"9.1.0",0,"Before a time out is about to occur, users are presented with a visual and auditory alert and the alert is displayed for at least 20 seconds to request more time.","Fail","N/A","N/A"]
["10. Revealing Content \n",10.1,"10.1.0",0,"Focus moves to revealed content, OR instructions/status is provided through speech output by the interface that reveals content.","Fail","N/A","N/A"]
["10. Revealing Content \n",10.199999999999999,"10.2.0",0,"Modal dialog boxes receive focus when they are opened and do not allow focus to leave the box until the task is completed or canceled by the user.","Fail","N/A","N/A"]
["11. Multistate Components\n",11.1,"11.1.0",0,"Multistate components reveal their current status (state/value) through speech output.","Fail","N/A","N/A"]
["11. Multistate Components\n",11.2,"11.2.0",0,"Live error alerts and live page events receive focus or interrupt screen reader users with speech output about the live event.","Fail","N/A","N/A"]
["12. Graphics\n",12.1,"12.1.0",0,"The meaning of images necessary to complete tasks are described through speech output.","Fail","N/A","N/A"]
["12. Graphics\n",12.2,"12.2.0",0,"Decorative and non-functional images are not described in speech output.","Fail","N/A","N/A"]
["13. Synchronized Media\n",13.1,"13.1.0",0,"All synchronized media has accurate and synchronized captions.","Fail","N/A","N/A"]
["13. Synchronized Media\n",13.2,"13.2.0",0,"All synchronized media has accurate and synchronized audio description.","Fail","N/A","N/A"]
["13. Synchronized Media\n",13.3,"13.3.0",0,"When synchronized media is used, the kiosk provides user controls for closed captioning and audio description.","Fail","N/A","N/A"]
["14. Tactilely Discernible Operable Controls\n",14.1,"14.1.0",0,"Operable parts are controlled by touch and tactilely discernible without activation. When operable controls are not tactilly descernable, an alternative is provided.  ","Fail","N/A","N/A"]
["14. Tactilely Discernible Operable Controls\n",14.2,"14.2.0",0,"When the kiosk has an alphanumeric keyboard, the alphabetic keys are arranged in a QWERTY layout and the “F” and “J” keys are tactilely distinct.","Fail","N/A","N/A"]
["14. Tactilely Discernible Operable Controls\n",14.3,"14.3.0",0,"When the kiosk has a numeric keypad, the keys are arranged in an ascending layout, and the number five key is tactilely distinct from the other keys. ","Fail","N/A","N/A"]
["15. Contrast of Operable Controls\n",15.1,"15.1.0",0,"The characters/symbols on the keyboard and other controls are easy to see because they contrast visually from background surfaces (e.g. light characters on dark background or vice-versa).","Fail","N/A","N/A"]
["16. Volume Control\n",16.100000000000001,"16.1.0",0,"The kiosk has a volume control feature for both private and non-private listening. ","Fail","N/A","N/A"]
["16. Volume Control\n",16.2,"16.2.0",0,"When a kiosk provides speakers, the volume can be decreased, increased to at least 65 dB and automatically reset to the default level after every use.","Fail","N/A","N/A"]
["16. Volume Control\n",16.3,"16.3.0",0,"When a kiosk provides a transducer (e.g. telephone receiver), the transducer can magnetically couple to hearing technologies.","Fail","N/A","N/A"]
["17. Operation ",17.100000000000001,"17.1.0",0,"Operable controls can be activated using 5 pounds of force or less, with one hand, without grasping, pinching, or twisting the wrist.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.100000000000001,"18.1.0",0,"All operable parts are facing forward OR easilly discoverable by touch by a user without sight.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.2,"18.2.0",0,"All operable parts measure between 34 inches and 48 inches above the floor.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.3,"18.3.0",0,"The user does not reach over a protrusion higher than 34 inches from the floor.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.399999999999999,"18.4.0",0,"There shall be a space in front of the kiosk for a wheelchair user to turn around (48 inches wide on center).","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.5,"18.5.0",0,"No operable part is deeper than 10 inches from the leading protrusion for side reach or 20 inches for forward reach.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.600000000000001,"18.6.0",0,"The display screen is visible when the user’s eye is 40 inches above the floor.","Fail","N/A","N/A"]
["18. Reach and Viewing Limits of Operable Parts and Screens",18.7,"18.7.0",0,"Braille instructions are facing forward, it reads horizontally, and the reading surface does not require a standing user to bend their wrist more than 20 degrees.","Fail","N/A","N/A"]
["19. Status Indicators \n",19.100000000000001,"19.1.0",0,"Status indicators shall be discernible visually and by touch or sound.","Fail","N/A","N/A"]
["20. Key Repeat",20.100000000000001,"20.1.0",0,"Where key repeat is provided, key repeat is delayed for at least 2 seconds, or is adjustable to at least 2 seconds.","Fail","N/A","N/A"]
["21. Biometrics\n",21.1,"21.1.0",0,"Biometrics are not the only means to identify a user or initiate a kiosk session.","Fail","N/A","N/A"]
["22. Flashing",22.1,"22.1.0",0,"There is no area of the screen larger than 2 square inches that flashes.","Fail","N/A","N/A"]
["23. Custom\n",23.1,"23.1.0",0,"Custom Pass Condition","Fail","N/A","N/A"]

{"sheet":"dataVal","index":2,"n_rows":52,"n_cols":7,"rows_kept":52,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instance",null,"DeferredStatus",null,"Severity","Result"]
[null,1,null,"AT Issue",null,"N/A","N/A"]
[null,2,null,"Browser Issue",null,"Deferred","Pass"]
[null,3,null,"More Research Needed",null,"Critical","Fail"]
[null,4,null,"Other",null,"Major","Resolved"]
[null,5,null,null,null,"Minor","Deferred"]
[null,6]
[null,7]
[null,8]
[null,9]
[null,10]
[null,11]
[null,12]
[null,13]
[null,14]
[null,15]
[null,16]
[null,17]
[null,18]
[null,19]
[null,20]
[null,21]
[null,22]
[null,23]
[null,24]
[null,25]
[null,26]
[null,27]
[null,28]
[null,29]
[null,30]
[null,31]
[null,32]
[null,33]
[null,34]
[null,35]
[null,36]
[null,37]
[null,38]
[null,39]
[null,40]
[null,41]
[null,42]
[null,43]
[null,44]
[null,45]
[null,46]
[null,47]
[null,48]
[null,49]
[null,50]