{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Instructions","Standards - Single Role","Calculator","Validation & Lookups"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":6,"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":"Instructions","index":0,"n_rows":4,"n_cols":1,"rows_kept":4,"cut":false,"hidden":false,"merged":[]}
["Instructions:\nSelect \"Enable Editing\" and \"Enable Content\" or \"Edit Macros\" if those options appear when opening this file. \nIf you were presented with any of these options and did not choose \"Enable\" then please close and re-open this file."]
["In Analytics, run a \"Status for All Roles\" report in PowerDMS. (You can do this by logging into PowerDMS, opening the Analytics menu from the blue sidebar menu, and choosing Standards. Choose \"Status for all roles,\" filter for your standards manual, open assessment, and the role in which your compliance documents are attached. Run the report and use the triple dots at the top of the table to download into an Excel document)."]
["Copy all data from the report, under the top two (\"header\") rows. Do not copy the headers themselves.  Paste it in the top-left cell of the \"Standards - Single Role\" tab in this file under the Blue Bar. "]
["Go to the \"Calculator\" tab of this file. Select the appropriate manual and agency size, then press \"Calculate.\""]

{"sheet":"Standards - Single Role","index":1,"n_rows":1,"n_cols":3,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Title","Description","StatusLabel"]

{"sheet":"Calculator","index":2,"n_rows":26,"n_cols":4,"rows_kept":26,"cut":false,"hidden":false,"merged":[[5,1,5,4],[20,1,20,4]]}
[null,null,"Standards Manual:"]
[null,null,"Agency Size Code:"]
[]
[]
[]
[null,"Applicable Standards"]
[]
[null,null," Mandatory Standards",385]
[null,null," Mandatory Standards In Compliance",3]
[]
[null,null,"Other-than-mandatory Standards",64]
[null,null,"Other-than-mandatory Standards In Compliance",0]
[null,null,"Percentage of Other-than-mandatory Standards In Compliance",{"$f":"IFERROR($D$12/$D$11,0)","v":0}]
[]
[null,null,"Current Number of Other-than-mandatory \"Elected 20%\" Standards",0]
[null,null,"Percentage of  Other-than-mandatory Standards Elected",{"$f":"IFERROR($D$15/$D$11,0)","v":0}]
[null,null,"Maximum allowable number of \"Elected 20%\" Standards",{"$f":"INT(0.2*$D$11)","v":12}]
[]
[]
[]
[null,"Not Applicable (N/A) Standards"]
[]
[null,null,"Total Not Applicable (N/A) Standards",0]
[]
[]
[null,null,"Mandatory Standards Marked as \"Elected 20%\":"]

{"sheet":"Validation & Lookups","index":3,"n_rows":5,"n_cols":5,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Manuals","Campus Security Standards","Communications Standards","Law Enforcement Standards","Training Academy Standards"]
["Campus Security Standards","A (1-24 personnel)","A (1-15 personnel)","A (1-24 personnel)","Any"]
["Communications Standards","B (25-74 personnel)","B (16-75 personnel)","B (25-74 personnel)"]
["Law Enforcement Standards","C (75-299 personnel)","C (76+ personnel)","C (75-299 personnel)"]
["Training Academy Standards","D (300+ personnel)",null,"D (300+ personnel)"]