{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Self Audit Calculation"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"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":"Self Audit Calculation","index":0,"n_rows":22,"n_cols":7,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
["DigIn Accessibility Self -Audit"]
[]
["Audit Date:"]
["Prepared By:"]
["Site  Name:"]
["Site URL:"]
["Note:"]
["Page #",null,"Errors","Contrast Errors","Alerts","Score"]
[1,null,0,1,2,{"$f":"C9+D9+E9/5","v":1.4}]
[{"$f":"1+A9","v":2},null,null,null,null,{"$f":"C10+D10+E10/5","v":0}]
[{"$f":"1+A10","v":3},null,null,null,null,0]
[4,null,null,null,null,0]
[5,null,null,null,null,{"$f":"C13+D13+E13/5","v":0}]
[6,null,null,null,null,0]
[]
[null,null,null,null,"Weighted Accessibility Score:",{"$f":"SUM(F9:F14)/COUNTA(C9:C14)","v":1.4}]
[null,null,null,null,"Website Accessibility Grade:",{"$f":"IF(F16<=3,5,IF(F16<=12,4,IF(F16<=21,3,(IF(F16<=30,2,1)))))","v":5}]
[]
[null,"NYC DOE Grade Key",5,4,3,2,1]
[null,"Weighted Accessibilty Score*","0.0 - 3.0","3.1 - 12.0","12.1 - 21.0","21.1 - 30.0","30.1+"]
[]
[null,null,"*The goal for all DOE digital properties is a grade of 5."]