{"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:F47,dataVal!#REF!,'Final Report'!G2:G47,\"Critical\")+COUNTIFS('Final Report'!F2:F47,\"Fail\",'Final Report'!G2:G47,\"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:F47,dataVal!#REF!,'Final Report'!G2:G47,\"Major\")+COUNTIFS('Final Report'!F2:F47,dataVal!#REF!,'Final Report'!G2:G47,\"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:F47,dataVal!#REF!,'Final Report'!G2:G47,\"Minor\")+COUNTIFS('Final Report'!F2:F47,dataVal!#REF!,'Final Report'!G2:G47,\"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:F47,\"Resolved\",'Final Report'!G2:G47,\"Critical\")+COUNTIFS('Final Report'!F2:F47,\"Resolved\",'Final Report'!G2:G47,\"Major\")+COUNTIFS('Final Report'!F2:F47,\"Resolved\",'Final Report'!G2:G47,\"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$47, 'Cover Sheet'!$A23)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A23, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[1.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A24)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A24, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[1.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A25)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A25, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[1.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A26)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A26, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[1.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A27)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A27, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[2.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A28)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A28, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[3.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A29)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A29, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[3.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A30)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A30, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[4.0999999999999996,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A31)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A31, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[4.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A32)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A32, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[5.0999999999999996,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A33)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A33, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[5.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A34)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A34, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[6.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A35)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A35, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[6.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A36)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A36, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[7.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A37)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A37, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[7.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A38)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A38, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[7.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A39)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A39, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[7.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A40)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A40, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[7.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A41)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A41, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[7.6,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A42)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A42, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[7.7,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A43)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A43, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[8.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A44)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A44, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[8.1999999999999993,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A45)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A45, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[8.3000000000000007,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A46)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A46, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[9.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A47)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A47, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[11.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A48)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A48, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[11.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A49)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A49, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A50)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A50, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A51)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A51, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.5,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A52)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A52, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.6,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A53)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A53, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.7,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A54)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A54, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.8,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A55)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A55, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[11.9,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A56)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A56, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[12.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A57)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A57, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[13.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A58)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A58, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[13.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A59)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A59, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[13.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A60)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A60, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[13.4,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A61)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A61, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[14.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A62)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A62, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[14.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A63)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A63, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[15.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A64)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A64, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[15.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A65)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A65, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[16.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A66)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A66, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[16.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A67)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A67, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[16.3,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A68)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A68, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[17.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A69)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A69, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[17.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A70)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A70, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[18.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A71)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A71, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[18.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A72)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A72, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[19.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A73)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A73, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[19.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A74)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A74, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[20.100000000000001,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A75)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A75, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[20.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A76)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A76, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[21.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A77)","v":1},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A77, 'Final Report'!$F$2:$F$47,\"Fail\")","v":1}]
[22.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A78)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A78, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[23.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A79)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A79, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[23.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A80)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A80, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[24.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A81)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A81, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[25.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A82)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A82, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[25.2,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A83)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A83, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[26.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A84)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A84, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[27.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A85)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A85, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[28.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A86)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A86, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]
[29.1,{"$f":"COUNTIF('Final Report'!$B$2:$B$47, 'Cover Sheet'!$A87)","v":0},{"$f":"COUNTIFS('Final Report'!$B$2:$B$47,'Cover Sheet'!$A87, 'Final Report'!$F$2:$F$47,\"Fail\")","v":0}]

{"sheet":"Final Report","index":1,"n_rows":36,"n_cols":11,"rows_kept":36,"cut":false,"hidden":false,"merged":[]}
["Tests"," Pass Condition"," Defect ID","Instance","Pass Conditions\n","Result","Severity","Reason for Deferred ","Location","Description","Remediation"]
["1. Keyboard Navigation",1.1000000000000001,"1.1.0",0,"All Interactive interfaces can be accessed and controlled by the keyboard.   \n ","Fail","N/A","N/A"]
["1. Keyboard Navigation",1.2,{"$f":"CONCATENATE($B3,CONCATENATE(\".\",$D3))","v":"1.2.0"},0,"Keyboard traps do not keep a user from accessing all interactive interfaces.  ","Fail","N/A","N/A"]
["1. Keyboard Navigation",1.3,{"$f":"CONCATENATE($B4,CONCATENATE(\".\",$D4))","v":"1.3.0"},0,"Non-standard/Alternative keyboard commands are documented.  ","Fail","N/A","N/A"]
["1. Keyboard Navigation",1.4,"1.4.0",0,"Select boxes, radio buttons, and checkboxes do not cause unintentional shifts in focus or page reload.  ","Fail","N/A","N/A"]
["1. Keyboard Navigation",1.5,"1.5.0",0,"All interactive interfaces can be accessed and activated by gestures.    ","Fail","N/A","N/A"]
["2. Visible Focus \n",2.1,"2.1.0",0,"All interactive interfaces display a visible indication of focus on the correct interface.","Fail","N/A","N/A"]
["3. Focus Order\n",3.1,"3.1.0",0,"The focus order follows the logical order and component groupings.","Fail","N/A","N/A"]
["3. Focus Order\n",3.2,"3.2.0",0,"The relative order of repeated components does not change between pages.","Fail","N/A","N/A"]
["4. Skip Links\n\n",4.0999999999999996,"4.1.0",0,"There is a functioning method to skip past repeated blocks of content or links.","Fail","N/A","N/A"]
["5. Forms and Instructions",5.0999999999999996,"5.1.0",0,"Form controls (excluding buttons) are preceded by H2 or H3. ","Fail","N/A","N/A"]
["5. Forms and Instructions",5.2,"5.2.0",0,"Form controls (excluding buttons) have a visible label and meaningful accessible name.","Fail","N/A","N/A"]
["5. Forms and Instructions",5.3,"5.3.0",0,"If an input error is automatically detected, the item with an error is identified and described to the user in text.","Fail","N/A","N/A"]
["6. Links and User Controls\n",6.1,"6.1.0",0,"The purpose of each link and button should be clear and be unique. Ambiguous or duplicate links and buttons do not confuse users. ","Fail","N/A","N/A"]
["6. Links and User Controls\n",6.2,"6.2.0",0,"Users can access player controls on every slide, scene, and time based media","Fail","N/A","N/A"]
["7. Revealing Content",7.1,"7.1.0",0,"Focus moves to revealed content, OR instructions/status is provided by the interface that reveals content.","Fail","N/A","N/A"]
["8. Multistate Components",8.1,"8.1.0",0,"Multistate components reveal their current status (state/value).","Fail","N/A","N/A"]
["8. Multistate Components",8.1999999999999993,"8.2.0",0,"Live error alerts and live page events receive focus or interrupt screen reader users.","Fail","N/A","N/A"]
["9. Graphics",9.1,"9.1.0",0,"All non-decorative images are accompanied by a text description.","Fail","N/A","N/A"]
["9. Graphics",9.1999999999999993,"9.2.0",0,"Decorative Images are ignored by assistive technology.","Fail","N/A","N/A"]
["9. Graphics",9.3000000000000007,"9.3.0",0,"Images containing text are described using the text within the image. ","Fail","N/A","N/A"]
["9. Graphics",9.4,"9.4.0",0,"Descriptive text for images used multiple times is consistent.","Fail","N/A","N/A"]
["10. Data Tables \n",10.1,"10.1.0",0,"Data tables are described in text immediately preceding the table and includes \"table\" (text may not be visible).","Fail","N/A","N/A"]
["10. Data Tables \n",10.199999999999999,"10.2.0",0,"Data tables are linearized, and provide visually apparent header(s).","Fail","N/A","N/A"]
["11. Headings\n",11.1,"11.1.0",0,"Visually apparent headings are programmatically identified and generally follow the visual outline structure. Note: Pass condition 5.1 requires H2 and H3 for form elements.","Fail","N/A","N/A"]
["12. Contrast\n",12.1,"12.1.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"]
["13. Meaningful Color and Sensory Characteristics\n",13.1,"13.1.0",0,"Color is not used as the only visual means of conveying information.","Fail","N/A","N/A"]
["13. Meaningful Color and Sensory Characteristics\n",13.2,"13.2.0",0,"Visual characteristics are associated with a text description.","Fail","N/A","N/A"]
["14. Resizable Text\n",14.1,"14.1.0",0,"Except video captions and images of text, the page can be resized up to 200% without loss of text or functionality.","Fail","N/A","N/A"]
["15. Page Title\n",15.1,"15.1.0",0,"Slide/scene has a meaningful name","Fail","N/A","N/A"]
["16. Language\n",16.100000000000001,"16.1.0",0,"The default spoken language of the page can be programmatically determined.","Fail","N/A","N/A"]
["17. No Flashing",17.100000000000001,"17.1.0",0,"There is no area of the screen larger than 2 square inches that flashes.. ","Fail","N/A","N/A"]
["18. Time Outs\n",18.100000000000001,"18.1.0",0,"Users are alerted to time outs, the alert is displayed for at least 20 seconds, and users can request more time..  \n","Fail","N/A","N/A"]
["19. Synchronized Media",19.100000000000001,"19.1.0",0,"All synchronized media has accurate and synchronized captions.","Fail","N/A","N/A"]
["20. Documents",20.100000000000001,"20.1.0",0,"Documents Accessibility: All documents, including transcripts, are accessible. ","Fail","N/A","N/A"]
["21. Miscellaneous\n",21.1,"21.1.0",0,"Issue ","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]