{"text_format":"1","workbook":"xlsx","n_sheets":11,"sheets":["Introduction","Dashboard","Master sheet","Tables & graphs","Lookup","1. Preparing for requests","2. Recognising requests","3. Validating & managing reque ","4. Finding & retrieving info","5. Supplying information","6. Monitoring & improving perf"],"not_rendered":{"charts":12,"images":1,"macros":1,"external_links":0,"defined_names":7,"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":"Introduction","index":0,"n_rows":6,"n_cols":2,"rows_kept":6,"cut":false,"hidden":false,"merged":[[5,1,42,15],[4,1,4,15]]}
[]
[]
[]
[]
[null,"Requests For Access Toolkit Tracker"]
[null,"\nYou can use this Tracker to record and track your actions once you have read the toolkit. \n\nThe first tab is called ‘Dashboard’. The dashboard will update automatically when you fill in the spreadsheet.\n\nThe next tab is called ‘Master Sheet’. This shows the toolkit and records all your responses in one place.\n\nWe have suggested some columns to help you to build your own action plan and improve your compliance. However, as the spreadsheet contains formula we would not recommend altering any of the existing columns. If you do make changes, you may impact the dashboard, master sheet or general functionality. Please note that we cannot offer support for maintaining the spreadsheet.\n\nKey phrases:\n\nCurrent status – This refers to whether you are ‘fully meeting our expectation’, ‘partially meeting our expectation’, or ‘not meeting our expectation’. You can also record the status as ‘not applicable’ to your organisation. You can choose the status from a drop-down list.\n\nReasons for status – You can record the reasons why you have chosen the ‘Current status’ for this expectation.\n\nActions – You can describe what you need to do next to meet the expectation.\n\nAction Owner(s) – You can specify who is responsible for the action.\n\nAction Status – You can choose what stage the action is at from a drop-down list. \n\nDue Date – You can record when you expect to complete the action.\n\n\n\nThe Data Protection Audit Framework, including the Tracker, is available under the terms of the Open Government Licence v3.0."]

{"sheet":"Dashboard","index":1,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Master sheet","index":2,"n_rows":79,"n_cols":16,"rows_kept":79,"cut":false,"hidden":false,"merged":[[72,0,78,0],[0,0,0,3],[2,1,5,1],[2,2,5,2],[6,1,10,1],[6,2,10,2],[11,1,12,1],[11,2,12,2],[13,1,14,1],[13,2,14,2],[2,0,14,0],[15,1,17,1],[15,2,17,2],[18,1,20,1],[18,2,20,2],[15,0,20,0],[39,1,40,1],[39,2,40,2],[21,0,40,0],[41,1,45,1],[41,2,45,2],[21,1,25,1],[21,2,25,2],[26,1,31,1],[26,2,31,2],[32,1,38,1],[32,2,38,2],[46,1,49,1],[46,2,49,2],[50,1,53,1],[50,2,53,2],[41,0,53,0],[54,0,71,0],[54,1,57,1],[54,2,57,2],[58,1,62,1],[58,2,62,2],[63,1,65,1],[63,2,65,2],[72,1,78,1],[72,2,78,2],[66,1,67,1],[66,2,67,2],[68,1,71,1],[68,2,71,2]]}
["Requests for Access Tracker\nMaster Sheet"]
["Category","Number","Our expectations","Reference","Ways to meet our expectations ","Current Status","Reasons for Status","Action(s)","Action owner","Action Status","Completion date\n(DD/MM/YYYY)",{"$f":"IF(ISBLANK('1. Preparing for requests'!K1),\"\",'1. Preparing for requests'!K1)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!L1),\"\",'1. Preparing for requests'!L1)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!M1),\"\",'1. Preparing for requests'!M1)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!N1),\"\",'1. Preparing for requests'!N1)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!O1),\"\",'1. Preparing for requests'!O1)","v":""}]
["Preparing for requests",1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.1","Document how you handle requests in sufficient detail in policies, including who oversees the request process.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E2),\"\",'1. Preparing for requests'!E2)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F2),\"\",'1. Preparing for requests'!F2)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G2),\"\",'1. Preparing for requests'!G2)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H2),\"\",'1. Preparing for requests'!H2)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I2),\"\",'1. Preparing for requests'!I2)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J2),\"\",'1. Preparing for requests'!J2)","v":""}]
[{"$f":"A3","v":"Preparing for requests"},{"$f":"B3","v":1.1000000000000001},"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.2","Ensure these policies have appropriate document version control.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E3),\"\",'1. Preparing for requests'!E3)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F3),\"\",'1. Preparing for requests'!F3)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G3),\"\",'1. Preparing for requests'!G3)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H3),\"\",'1. Preparing for requests'!H3)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I3),\"\",'1. Preparing for requests'!I3)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J3),\"\",'1. Preparing for requests'!J3)","v":""}]
["Preparing for requests",1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.3","Communicate these policies to staff dealing with requests and make policies readily available for them to refer to.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E4),\"\",'1. Preparing for requests'!E4)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F4),\"\",'1. Preparing for requests'!F4)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G4),\"\",'1. Preparing for requests'!G4)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H4),\"\",'1. Preparing for requests'!H4)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I4),\"\",'1. Preparing for requests'!I4)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J4),\"\",'1. Preparing for requests'!J4)","v":""}]
["Preparing for requests",1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.4","Keep policies up-to-date, particularly with changes to data protection law.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E5),\"\",'1. Preparing for requests'!E5)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F5),\"\",'1. Preparing for requests'!F5)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G5),\"\",'1. Preparing for requests'!G5)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H5),\"\",'1. Preparing for requests'!H5)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I5),\"\",'1. Preparing for requests'!I5)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J5),\"\",'1. Preparing for requests'!J5)","v":""}]
["Preparing for requests",1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.1","Identify the specific staff member or team who manages and responds to requests.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E6),\"\",'1. Preparing for requests'!E6)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F6),\"\",'1. Preparing for requests'!F6)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G6),\"\",'1. Preparing for requests'!G6)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H6),\"\",'1. Preparing for requests'!H6)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I6),\"\",'1. Preparing for requests'!I6)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J6),\"\",'1. Preparing for requests'!J6)","v":""}]
["Preparing for requests",{"$f":"B7","v":1.2000000000000002},"Staff are in place and are competent to handle requests for access.","1.2.2","Assign sufficient resources to process the requests you receive.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E7),\"\",'1. Preparing for requests'!E7)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F7),\"\",'1. Preparing for requests'!F7)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G7),\"\",'1. Preparing for requests'!G7)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H7),\"\",'1. Preparing for requests'!H7)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I7),\"\",'1. Preparing for requests'!I7)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J7),\"\",'1. Preparing for requests'!J7)","v":""}]
["Preparing for requests",1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.3","Build resilience to mitigate the risk of request backlogs or failures to meet the statutory timeframes that result from staff absence.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E8),\"\",'1. Preparing for requests'!E8)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F8),\"\",'1. Preparing for requests'!F8)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G8),\"\",'1. Preparing for requests'!G8)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H8),\"\",'1. Preparing for requests'!H8)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I8),\"\",'1. Preparing for requests'!I8)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J8),\"\",'1. Preparing for requests'!J8)","v":""}]
["Preparing for requests",1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.4","Provide specialised training for staff who handle requests, particularly on statutory requirements and exemptions. ",{"$f":"IF(ISBLANK('1. Preparing for requests'!E9),\"\",'1. Preparing for requests'!E9)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F9),\"\",'1. Preparing for requests'!F9)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G9),\"\",'1. Preparing for requests'!G9)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H9),\"\",'1. Preparing for requests'!H9)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I9),\"\",'1. Preparing for requests'!I9)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J9),\"\",'1. Preparing for requests'!J9)","v":""}]
["Preparing for requests",1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.5","Record training requirements in a training needs analysis or training programme.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E10),\"\",'1. Preparing for requests'!E10)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F10),\"\",'1. Preparing for requests'!F10)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G10),\"\",'1. Preparing for requests'!G10)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H10),\"\",'1. Preparing for requests'!H10)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I10),\"\",'1. Preparing for requests'!I10)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J10),\"\",'1. Preparing for requests'!J10)","v":""}]
["Preparing for requests",1.3,"People are guided on how to make verbal or written requests for access.","1.3.1","Produce guidance on how to make verbal and written (including electronic) requests.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E11),\"\",'1. Preparing for requests'!E11)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F11),\"\",'1. Preparing for requests'!F11)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G11),\"\",'1. Preparing for requests'!G11)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H11),\"\",'1. Preparing for requests'!H11)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I11),\"\",'1. Preparing for requests'!I11)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J11),\"\",'1. Preparing for requests'!J11)","v":""}]
["Preparing for requests",{"$f":"B12","v":1.3},"People are guided on how to make verbal or written requests for access.","1.3.2","Make guidance easily accessible and available in electronic and paper formats.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E12),\"\",'1. Preparing for requests'!E12)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F12),\"\",'1. Preparing for requests'!F12)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G12),\"\",'1. Preparing for requests'!G12)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H12),\"\",'1. Preparing for requests'!H12)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I12),\"\",'1. Preparing for requests'!I12)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J12),\"\",'1. Preparing for requests'!J12)","v":""}]
["Preparing for requests",1.4000000000000004,"Processors acting on your behalf are ready and able to respond to requests for access.","1.4.1","Include requirements for processors to handle requests for access in contracts, including clear timescales for response.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E13),\"\",'1. Preparing for requests'!E13)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F13),\"\",'1. Preparing for requests'!F13)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G13),\"\",'1. Preparing for requests'!G13)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H13),\"\",'1. Preparing for requests'!H13)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I13),\"\",'1. Preparing for requests'!I13)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J13),\"\",'1. Preparing for requests'!J13)","v":""}]
[{"$f":"A14","v":"Preparing for requests"},1.4000000000000004,"Processors acting on your behalf are ready and able to respond to requests for access.","1.4.2","Check that processors can competently respond to requests for personal information prior to processing it.",{"$f":"IF(ISBLANK('1. Preparing for requests'!E14),\"\",'1. Preparing for requests'!E14)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!F14),\"\",'1. Preparing for requests'!F14)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!G14),\"\",'1. Preparing for requests'!G14)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!H13),\"\",'1. Preparing for requests'!H14)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!I13),\"\",'1. Preparing for requests'!I14)","v":""},{"$f":"IF(ISBLANK('1. Preparing for requests'!J13),\"\",'1. Preparing for requests'!J14)","v":""}]
["Recognising requests",2.1,"Staff can recognise verbal and written (including electronic) requests for access.","2.1.1","Produce guidance for staff on how to recognise verbal, electronic and written requests.",{"$f":"IF(ISBLANK('2. Recognising requests'!E2),\"\",'2. Recognising requests'!E2)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F2),\"\",'2. Recognising requests'!F2)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G2),\"\",'2. Recognising requests'!G2)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H2),\"\",'2. Recognising requests'!H2)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I2),\"\",'2. Recognising requests'!I2)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J2),\"\",'2. Recognising requests'!J2)","v":""}]
[{"$f":"A16","v":"Recognising requests"},{"$f":"B16","v":2.1},"Staff can recognise verbal and written (including electronic) requests for access.","2.1.2","Make guidance easily accessible and available in electronic and paper formats for staff who do not regularly work on computers.",{"$f":"IF(ISBLANK('2. Recognising requests'!E3),\"\",'2. Recognising requests'!E3)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F3),\"\",'2. Recognising requests'!F3)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G3),\"\",'2. Recognising requests'!G3)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H3),\"\",'2. Recognising requests'!H3)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I3),\"\",'2. Recognising requests'!I3)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J3),\"\",'2. Recognising requests'!J3)","v":""}]
["Recognising requests",2.1,"Staff can recognise verbal and written (including electronic) requests for access.","2.1.3","Train all staff on recognising requests.",{"$f":"IF(ISBLANK('2. Recognising requests'!E4),\"\",'2. Recognising requests'!E4)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F4),\"\",'2. Recognising requests'!F4)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G4),\"\",'2. Recognising requests'!G4)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H4),\"\",'2. Recognising requests'!H4)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I4),\"\",'2. Recognising requests'!I4)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J4),\"\",'2. Recognising requests'!J4)","v":""}]
["Recognising requests",2.2000000000000002,"Staff direct requests to the person or team who handles them.","2.2.1","Produce guidance for staff on how to direct or channel requests to the person or team who handles them.",{"$f":"IF(ISBLANK('2. Recognising requests'!E5),\"\",'2. Recognising requests'!E5)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F5),\"\",'2. Recognising requests'!F5)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G5),\"\",'2. Recognising requests'!G5)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H5),\"\",'2. Recognising requests'!H5)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I5),\"\",'2. Recognising requests'!I5)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J5),\"\",'2. Recognising requests'!J5)","v":""}]
[{"$f":"A19","v":"Recognising requests"},2.2000000000000002,"Staff direct requests to the person or team who handles them.","2.2.2","Make guidance easily accessible and available in electronic and paper formats for staff who do not regularly work on computers.",{"$f":"IF(ISBLANK('2. Recognising requests'!E6),\"\",'2. Recognising requests'!E6)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F6),\"\",'2. Recognising requests'!F6)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G6),\"\",'2. Recognising requests'!G6)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H6),\"\",'2. Recognising requests'!H6)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I6),\"\",'2. Recognising requests'!I6)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J6),\"\",'2. Recognising requests'!J6)","v":""}]
["Recognising requests",2.2000000000000002,"Staff direct requests to the person or team who handles them.","2.2.3","Train all staff on directing requests.",{"$f":"IF(ISBLANK('2. Recognising requests'!E7),\"\",'2. Recognising requests'!E7)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!F7),\"\",'2. Recognising requests'!F7)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!G7),\"\",'2. Recognising requests'!G7)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!H7),\"\",'2. Recognising requests'!H7)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!I7),\"\",'2. Recognising requests'!I7)","v":""},{"$f":"IF(ISBLANK('2. Recognising requests'!J7),\"\",'2. Recognising requests'!J7)","v":""}]
["Validating & managing requests",3.1,"Processes to verify the validity of requests are in place.","3.1.1","Verify the identity of the requestor and the address to send the information to, and keep records of the verification checks.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E2),\"\",'3. Validating & managing reque '!E2)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F2),\"\",'3. Validating & managing reque '!F2)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G2),\"\",'3. Validating & managing reque '!G2)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H2),\"\",'3. Validating & managing reque '!H2)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I2),\"\",'3. Validating & managing reque '!I2)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J2),\"\",'3. Validating & managing reque '!J2)","v":""}]
[{"$f":"A22","v":"Validating & managing requests"},{"$f":"B22","v":3.1},"Processes to verify the validity of requests are in place.","3.1.2","Verify that third parties making requests on behalf of people have written authority or power of attorney to make the request.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E3),\"\",'3. Validating & managing reque '!E3)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F3),\"\",'3. Validating & managing reque '!F3)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G3),\"\",'3. Validating & managing reque '!G3)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H3),\"\",'3. Validating & managing reque '!H3)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I3),\"\",'3. Validating & managing reque '!I3)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J3),\"\",'3. Validating & managing reque '!J3)","v":""}]
["Validating & managing requests",3.1,"Processes to verify the validity of requests are in place.","3.1.3","Ensure staff are aware why verification checks are important.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E4),\"\",'3. Validating & managing reque '!E4)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F4),\"\",'3. Validating & managing reque '!F4)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G4),\"\",'3. Validating & managing reque '!G4)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H4),\"\",'3. Validating & managing reque '!H4)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I4),\"\",'3. Validating & managing reque '!I4)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J4),\"\",'3. Validating & managing reque '!J4)","v":""}]
["Validating & managing requests",3.1,"Processes to verify the validity of requests are in place.","3.1.4","Sample or check that staff carry out verification checks appropriately on completed requests.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E5),\"\",'3. Validating & managing reque '!E5)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F5),\"\",'3. Validating & managing reque '!F5)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G5),\"\",'3. Validating & managing reque '!G5)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H5),\"\",'3. Validating & managing reque '!H5)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I5),\"\",'3. Validating & managing reque '!I5)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J5),\"\",'3. Validating & managing reque '!J5)","v":""}]
["Validating & managing requests",3.1,"Processes to verify the validity of requests are in place.","3.1.5","Document verification checks and how to carry them out  in sufficient detail in policies.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E6),\"\",'3. Validating & managing reque '!E6)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F6),\"\",'3. Validating & managing reque '!F6)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G6),\"\",'3. Validating & managing reque '!G6)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H6),\"\",'3. Validating & managing reque '!H6)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I6),\"\",'3. Validating & managing reque '!I6)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J6),\"\",'3. Validating & managing reque '!J6)","v":""}]
["Validating & managing requests",3.2,"Detailed records of requests handled are kept.","3.2.1","Keep a log of all verbal and written requests.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E7),\"\",'3. Validating & managing reque '!E7)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F7),\"\",'3. Validating & managing reque '!F7)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G7),\"\",'3. Validating & managing reque '!G7)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H7),\"\",'3. Validating & managing reque '!H7)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I7),\"\",'3. Validating & managing reque '!I7)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J7),\"\",'3. Validating & managing reque '!J7)","v":""}]
["Validating & managing requests",{"$f":"B27","v":3.2},"Detailed records of requests handled are kept.","3.2.2","Log who handled each request.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E8),\"\",'3. Validating & managing reque '!E8)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F8),\"\",'3. Validating & managing reque '!F8)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G8),\"\",'3. Validating & managing reque '!G8)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H8),\"\",'3. Validating & managing reque '!H8)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I8),\"\",'3. Validating & managing reque '!I8)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J8),\"\",'3. Validating & managing reque '!J8)","v":""}]
["Validating & managing requests",3.2,"Detailed records of requests handled are kept.","3.2.3","Log what stage each request is at.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E9),\"\",'3. Validating & managing reque '!E9)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F9),\"\",'3. Validating & managing reque '!F9)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G9),\"\",'3. Validating & managing reque '!G9)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H9),\"\",'3. Validating & managing reque '!H9)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I9),\"\",'3. Validating & managing reque '!I9)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J9),\"\",'3. Validating & managing reque '!J9)","v":""}]
["Validating & managing requests",3.2,"Detailed records of requests handled are kept.","3.2.4","Log the due date for a response to each request within the statutory timeframe, the actual date you responded to each request, and the reason for any delays, where you didn’t meet the statutory timeframe.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E10),\"\",'3. Validating & managing reque '!E10)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F10),\"\",'3. Validating & managing reque '!F10)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G10),\"\",'3. Validating & managing reque '!G10)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H10),\"\",'3. Validating & managing reque '!H10)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I10),\"\",'3. Validating & managing reque '!I10)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J10),\"\",'3. Validating & managing reque '!J10)","v":""}]
["Validating & managing requests",3.2,"Detailed records of requests handled are kept.","3.2.5","Log where information was withheld under exemption or related to third parties, and why this decision was made and by who.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E11),\"\",'3. Validating & managing reque '!E11)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F11),\"\",'3. Validating & managing reque '!F11)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G11),\"\",'3. Validating & managing reque '!G11)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H11),\"\",'3. Validating & managing reque '!H11)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I11),\"\",'3. Validating & managing reque '!I11)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J11),\"\",'3. Validating & managing reque '!J11)","v":""}]
["Validating & managing requests",3.2,"Detailed records of requests handled are kept.","3.2.6","Log requests that were refused entirely or handled following a different process, and why this decision was made and by who.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E12),\"\",'3. Validating & managing reque '!E12)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F12),\"\",'3. Validating & managing reque '!F12)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G12),\"\",'3. Validating & managing reque '!G12)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H12),\"\",'3. Validating & managing reque '!H12)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I12),\"\",'3. Validating & managing reque '!I12)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J12),\"\",'3. Validating & managing reque '!J12)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.1","Acknowledge each request by confirming receipt electronically or in writing and inform the requestor of the latest date they will receive a response by. This will be no later than one month from the date you received their request.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E13),\"\",'3. Validating & managing reque '!E13)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F13),\"\",'3. Validating & managing reque '!F13)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G13),\"\",'3. Validating & managing reque '!G13)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H13),\"\",'3. Validating & managing reque '!H13)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I13),\"\",'3. Validating & managing reque '!I13)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J13),\"\",'3. Validating & managing reque '!J13)","v":""}]
["Validating & managing requests",{"$f":"B33","v":3.3},"Processes to acknowledge and manage requests correctly are in place.","3.3.2","Seek clarification promptly when the nature of the request is unclear or the request doesn’t contain enough information to respond.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E14),\"\",'3. Validating & managing reque '!E14)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F14),\"\",'3. Validating & managing reque '!F14)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G14),\"\",'3. Validating & managing reque '!G14)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H14),\"\",'3. Validating & managing reque '!H14)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I14),\"\",'3. Validating & managing reque '!I14)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J14),\"\",'3. Validating & managing reque '!J14)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.3","Inform the requestor if you need to extend the response timeframe for their request. Only extend it by a further two months due to the volume or complexity of the request.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E15),\"\",'3. Validating & managing reque '!E15)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F15),\"\",'3. Validating & managing reque '!F15)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G15),\"\",'3. Validating & managing reque '!G15)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H15),\"\",'3. Validating & managing reque '!H15)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I15),\"\",'3. Validating & managing reque '!I15)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J15),\"\",'3. Validating & managing reque '!J15)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.4","Inform the requestor if their request is delayed, why it is delayed, and the expected date they will receive a response by.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E16),\"\",'3. Validating & managing reque '!E16)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F16),\"\",'3. Validating & managing reque '!F16)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G16),\"\",'3. Validating & managing reque '!G16)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H16),\"\",'3. Validating & managing reque '!H16)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I16),\"\",'3. Validating & managing reque '!I16)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J16),\"\",'3. Validating & managing reque '!J16)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.5","Prioritise or escalate requests that are delayed.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E17),\"\",'3. Validating & managing reque '!E17)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F17),\"\",'3. Validating & managing reque '!F17)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G17),\"\",'3. Validating & managing reque '!G17)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H17),\"\",'3. Validating & managing reque '!H17)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I17),\"\",'3. Validating & managing reque '!I17)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J17),\"\",'3. Validating & managing reque '!J17)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.6","Ensure managers monitor requests in progress, including what stage each request is at and any issues or delays, to meet timescales.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E18),\"\",'3. Validating & managing reque '!E18)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F18),\"\",'3. Validating & managing reque '!F18)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G18),\"\",'3. Validating & managing reque '!G18)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H18),\"\",'3. Validating & managing reque '!H18)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I18),\"\",'3. Validating & managing reque '!I18)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J18),\"\",'3. Validating & managing reque '!J18)","v":""}]
["Validating & managing requests",3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.7","Escalate details of requests that staff have not responded to within the statutory timeframe to a suitably senior manager or oversight group.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E19),\"\",'3. Validating & managing reque '!E19)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F19),\"\",'3. Validating & managing reque '!F19)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G19),\"\",'3. Validating & managing reque '!G19)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H19),\"\",'3. Validating & managing reque '!H19)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I19),\"\",'3. Validating & managing reque '!I19)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J19),\"\",'3. Validating & managing reque '!J19)","v":""}]
["Validating & managing requests",3.4,"Requests for access are responded to within the statutory timeframe.","3.4.1","Keep records to show that you have responded to requests for access and actioned them within the statutory timeframe.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E20),\"\",'3. Validating & managing reque '!E20)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F20),\"\",'3. Validating & managing reque '!F20)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G20),\"\",'3. Validating & managing reque '!G20)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H20),\"\",'3. Validating & managing reque '!H20)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I20),\"\",'3. Validating & managing reque '!I20)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J20),\"\",'3. Validating & managing reque '!J20)","v":""}]
[{"$f":"A40","v":"Validating & managing requests"},3.4,"Requests for access are responded to within the statutory timeframe.","3.4.2","Keep records of mitigating factors and actions taken for any requests for access that you didn’t respond to or action within the statutory timeframe.",{"$f":"IF(ISBLANK('3. Validating & managing reque '!E21),\"\",'3. Validating & managing reque '!E21)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!F21),\"\",'3. Validating & managing reque '!F21)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!G21),\"\",'3. Validating & managing reque '!G21)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!H21),\"\",'3. Validating & managing reque '!H21)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!I21),\"\",'3. Validating & managing reque '!I21)","v":""},{"$f":"IF(ISBLANK('3. Validating & managing reque '!J21),\"\",'3. Validating & managing reque '!J21)","v":""}]
["Finding & retrieving information",4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.1","Implement a process to quickly locate relevant current paper records (that are part of a filing system).",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E2),\"\",'4. Finding & retrieving info'!E2)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F2),\"\",'4. Finding & retrieving info'!F2)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G2),\"\",'4. Finding & retrieving info'!G2)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H2),\"\",'4. Finding & retrieving info'!H2)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I2),\"\",'4. Finding & retrieving info'!I2)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J2),\"\",'4. Finding & retrieving info'!J2)","v":""}]
[{"$f":"A42","v":"Finding & retrieving information"},{"$f":"B42","v":4.0999999999999996},"Processes to locate requested information in a timely manner are in place.","4.1.2","Implement a process to quickly locate and retrieve paper records from archives or external storage.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E3),\"\",'4. Finding & retrieving info'!E3)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F3),\"\",'4. Finding & retrieving info'!F3)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G3),\"\",'4. Finding & retrieving info'!G3)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H3),\"\",'4. Finding & retrieving info'!H3)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I3),\"\",'4. Finding & retrieving info'!I3)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J3),\"\",'4. Finding & retrieving info'!J3)","v":""}]
["Finding & retrieving information",4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.3","Implement a process to quickly locate relevant current electronic records.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E4),\"\",'4. Finding & retrieving info'!E4)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F4),\"\",'4. Finding & retrieving info'!F4)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G4),\"\",'4. Finding & retrieving info'!G4)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H4),\"\",'4. Finding & retrieving info'!H4)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I4),\"\",'4. Finding & retrieving info'!I4)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J4),\"\",'4. Finding & retrieving info'!J4)","v":""}]
["Finding & retrieving information",4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.4","Implement a process to quickly locate and retrieve electronic records from archives, back-ups, or email storage.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E5),\"\",'4. Finding & retrieving info'!E5)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F5),\"\",'4. Finding & retrieving info'!F5)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G5),\"\",'4. Finding & retrieving info'!G5)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H5),\"\",'4. Finding & retrieving info'!H5)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I5),\"\",'4. Finding & retrieving info'!I5)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J5),\"\",'4. Finding & retrieving info'!J5)","v":""}]
["Finding & retrieving information",4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.5","Assign points of contact in satellite departments or buildings who can quickly retrieve paper or electronic records stored locally.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E6),\"\",'4. Finding & retrieving info'!E6)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F6),\"\",'4. Finding & retrieving info'!F6)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G6),\"\",'4. Finding & retrieving info'!G6)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H6),\"\",'4. Finding & retrieving info'!H6)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I6),\"\",'4. Finding & retrieving info'!I6)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J6),\"\",'4. Finding & retrieving info'!J6)","v":""}]
["Finding & retrieving information",4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.1","Document how to apply exemptions, including redacting third party information, clearly in the relevant policies.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E7),\"\",'4. Finding & retrieving info'!E7)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F7),\"\",'4. Finding & retrieving info'!F7)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G7),\"\",'4. Finding & retrieving info'!G7)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H7),\"\",'4. Finding & retrieving info'!H7)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I7),\"\",'4. Finding & retrieving info'!I7)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J7),\"\",'4. Finding & retrieving info'!J7)","v":""}]
["Finding & retrieving information",{"$f":"B47","v":4.2},"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.2","Ensure staff apply exemptions and redactions appropriately and correctly.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E8),\"\",'4. Finding & retrieving info'!E8)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F8),\"\",'4. Finding & retrieving info'!F8)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G8),\"\",'4. Finding & retrieving info'!G8)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H8),\"\",'4. Finding & retrieving info'!H8)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I8),\"\",'4. Finding & retrieving info'!I8)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J8),\"\",'4. Finding & retrieving info'!J8)","v":""}]
["Finding & retrieving information",4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.3","Ensure a senior staff members reviews and authorises exemptions and redactions (or a sample of them).",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E9),\"\",'4. Finding & retrieving info'!E9)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F9),\"\",'4. Finding & retrieving info'!F9)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G9),\"\",'4. Finding & retrieving info'!G9)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H9),\"\",'4. Finding & retrieving info'!H9)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I9),\"\",'4. Finding & retrieving info'!I9)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J9),\"\",'4. Finding & retrieving info'!J9)","v":""}]
["Finding & retrieving information",4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.4","Provide specialised training for staff who apply, review or authorise exemptions.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E10),\"\",'4. Finding & retrieving info'!E10)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F10),\"\",'4. Finding & retrieving info'!F10)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G10),\"\",'4. Finding & retrieving info'!G10)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H10),\"\",'4. Finding & retrieving info'!H10)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I10),\"\",'4. Finding & retrieving info'!I10)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J10),\"\",'4. Finding & retrieving info'!J10)","v":""}]
["Finding & retrieving information",4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.1","Implement an appropriate redaction method.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E11),\"\",'4. Finding & retrieving info'!E11)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F11),\"\",'4. Finding & retrieving info'!F11)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G11),\"\",'4. Finding & retrieving info'!G11)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H11),\"\",'4. Finding & retrieving info'!H11)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I11),\"\",'4. Finding & retrieving info'!I11)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J11),\"\",'4. Finding & retrieving info'!J11)","v":""}]
[{"$f":"A51","v":"Finding & retrieving information"},4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.2","Review or sample exemptions and redactions to check staff are taking a consistent approach.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E12),\"\",'4. Finding & retrieving info'!E12)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F12),\"\",'4. Finding & retrieving info'!F12)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G12),\"\",'4. Finding & retrieving info'!G12)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H12),\"\",'4. Finding & retrieving info'!H12)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I12),\"\",'4. Finding & retrieving info'!I12)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J12),\"\",'4. Finding & retrieving info'!J12)","v":""}]
["Finding & retrieving information",4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.3","Keep records of all redactions to capture who did the redaction, the date, and the justification.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E13),\"\",'4. Finding & retrieving info'!E13)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F13),\"\",'4. Finding & retrieving info'!F13)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G13),\"\",'4. Finding & retrieving info'!G13)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H13),\"\",'4. Finding & retrieving info'!H13)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I13),\"\",'4. Finding & retrieving info'!I13)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J13),\"\",'4. Finding & retrieving info'!J13)","v":""}]
["Finding & retrieving information",4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.4","Retain these records for reference, in line with the retention schedule.",{"$f":"IF(ISBLANK('4. Finding & retrieving info'!E14),\"\",'4. Finding & retrieving info'!E14)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!F14),\"\",'4. Finding & retrieving info'!F14)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!G14),\"\",'4. Finding & retrieving info'!G14)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!H14),\"\",'4. Finding & retrieving info'!H14)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!I14),\"\",'4. Finding & retrieving info'!I14)","v":""},{"$f":"IF(ISBLANK('4. Finding & retrieving info'!J14),\"\",'4. Finding & retrieving info'!J14)","v":""}]
["Supplying information",5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.1","Provide information in a commonly used electronic format, or another format, if requested.",{"$f":"IF(ISBLANK('5. Supplying information'!E2),\"\",'5. Supplying information'!E2)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F2),\"\",'5. Supplying information'!F2)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G2),\"\",'5. Supplying information'!G2)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H2),\"\",'5. Supplying information'!H2)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I2),\"\",'5. Supplying information'!I2)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J2),\"\",'5. Supplying information'!J2)","v":""}]
[{"$f":"A55","v":"Supplying information"},{"$f":"B55","v":5.0999999999999996},"Information is provided to the requestor in a suitable format.","5.1.2","Ask what format the requestor prefers the information in, before fulfilling the request.",{"$f":"IF(ISBLANK('5. Supplying information'!E3),\"\",'5. Supplying information'!E3)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F3),\"\",'5. Supplying information'!F3)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G3),\"\",'5. Supplying information'!G3)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H3),\"\",'5. Supplying information'!H3)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I3),\"\",'5. Supplying information'!I3)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J3),\"\",'5. Supplying information'!J3)","v":""}]
["Supplying information",5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.3","Provide information in a secure way.",{"$f":"IF(ISBLANK('5. Supplying information'!E4),\"\",'5. Supplying information'!E4)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F4),\"\",'5. Supplying information'!F4)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G4),\"\",'5. Supplying information'!G4)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H4),\"\",'5. Supplying information'!H4)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I4),\"\",'5. Supplying information'!I4)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J4),\"\",'5. Supplying information'!J4)","v":""}]
["Supplying information",5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.4","Assess whether it is appropriate to provide original copies of documents containing personal information, or a transcript or extract with the personal information.",{"$f":"IF(ISBLANK('5. Supplying information'!E5),\"\",'5. Supplying information'!E5)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F5),\"\",'5. Supplying information'!F5)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G5),\"\",'5. Supplying information'!G5)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H5),\"\",'5. Supplying information'!H5)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I5),\"\",'5. Supplying information'!I5)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J5),\"\",'5. Supplying information'!J5)","v":""}]
["Supplying information",5.2,"Information is provided to help people understand the response.","5.2.1","Send a cover note or letter with the response, explaining clearly what searches you have completed and an overview of the information that you have provided.",{"$f":"IF(ISBLANK('5. Supplying information'!E6),\"\",'5. Supplying information'!E6)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F6),\"\",'5. Supplying information'!F6)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G6),\"\",'5. Supplying information'!G6)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H6),\"\",'5. Supplying information'!H6)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I6),\"\",'5. Supplying information'!I6)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J6),\"\",'5. Supplying information'!J6)","v":""}]
["Supplying information",{"$f":"B59","v":5.2},"Information is provided to help people understand the response.","5.2.2","Explain any information that people may not understand (eg codes, handwritten notes, or acronyms).",{"$f":"IF(ISBLANK('5. Supplying information'!E7),\"\",'5. Supplying information'!E7)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F7),\"\",'5. Supplying information'!F7)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G7),\"\",'5. Supplying information'!G7)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H7),\"\",'5. Supplying information'!H7)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I7),\"\",'5. Supplying information'!I7)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J7),\"\",'5. Supplying information'!J7)","v":""}]
["Supplying information",5.2,"Information is provided to help people understand the response.","5.2.3","Explain the purposes of the processing.",{"$f":"IF(ISBLANK('5. Supplying information'!E8),\"\",'5. Supplying information'!E8)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F8),\"\",'5. Supplying information'!F8)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G8),\"\",'5. Supplying information'!G8)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H8),\"\",'5. Supplying information'!H8)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I8),\"\",'5. Supplying information'!I8)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J8),\"\",'5. Supplying information'!J8)","v":""}]
["Supplying information",5.2,"Information is provided to help people understand the response.","5.2.4","Use clear, plain, non-technical language when providing explanations.",{"$f":"IF(ISBLANK('5. Supplying information'!E9),\"\",'5. Supplying information'!E9)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F9),\"\",'5. Supplying information'!F9)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G9),\"\",'5. Supplying information'!G9)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H9),\"\",'5. Supplying information'!H9)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I9),\"\",'5. Supplying information'!I9)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J9),\"\",'5. Supplying information'!J9)","v":""}]
["Supplying information",5.2,"Information is provided to help people understand the response.","5.2.5","Have a clear formal process for people to complain or appeal about decisions you’ve made about their request.",{"$f":"IF(ISBLANK('5. Supplying information'!E10),\"\",'5. Supplying information'!E10)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F10),\"\",'5. Supplying information'!F10)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G10),\"\",'5. Supplying information'!G10)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H10),\"\",'5. Supplying information'!H10)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I10),\"\",'5. Supplying information'!I10)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J10),\"\",'5. Supplying information'!J10)","v":""}]
["Supplying information",5.3,"Decisions to withhold information from responses are explained clearly to requestors.","5.3.1","Send a cover note or letter with the response, explaining clearly what information you have withheld and why.",{"$f":"IF(ISBLANK('5. Supplying information'!E11),\"\",'5. Supplying information'!E11)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F11),\"\",'5. Supplying information'!F11)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G11),\"\",'5. Supplying information'!G11)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H11),\"\",'5. Supplying information'!H11)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I11),\"\",'5. Supplying information'!I11)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J11),\"\",'5. Supplying information'!J11)","v":""}]
["Supplying information",{"$f":"B64","v":5.3},"Decisions to withhold information from responses are explained clearly to requestors.","5.3.2","Use clear, plain, non-technical language when providing explanations.",{"$f":"IF(ISBLANK('5. Supplying information'!E12),\"\",'5. Supplying information'!E12)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F12),\"\",'5. Supplying information'!F12)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G12),\"\",'5. Supplying information'!G12)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H12),\"\",'5. Supplying information'!H12)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I12),\"\",'5. Supplying information'!I12)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J12),\"\",'5. Supplying information'!J12)","v":""}]
["Supplying information",5.3,"Decisions to withhold information from responses are explained clearly to requestors.","5.3.3","Have a clear formal process for people to complain or appeal about decisions you’ve made about their request.",{"$f":"IF(ISBLANK('5. Supplying information'!E13),\"\",'5. Supplying information'!E13)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F13),\"\",'5. Supplying information'!F13)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G13),\"\",'5. Supplying information'!G13)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H13),\"\",'5. Supplying information'!H13)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I13),\"\",'5. Supplying information'!I13)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J13),\"\",'5. Supplying information'!J13)","v":""}]
["Supplying information",5.4,"People are given direct access to their information, if requested or required.","5.4.1","Allow people to view information in person on site if they request this.",{"$f":"IF(ISBLANK('5. Supplying information'!E14),\"\",'5. Supplying information'!E14)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F14),\"\",'5. Supplying information'!F14)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G14),\"\",'5. Supplying information'!G14)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H14),\"\",'5. Supplying information'!H14)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I14),\"\",'5. Supplying information'!I14)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J14),\"\",'5. Supplying information'!J14)","v":""}]
["Supplying information",{"$f":"B67","v":5.4},"People are given direct access to their information, if requested or required.","5.4.2","Allow people to view information using a secure online portal they can easily access.",{"$f":"IF(ISBLANK('5. Supplying information'!E15),\"\",'5. Supplying information'!E15)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F15),\"\",'5. Supplying information'!F15)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G15),\"\",'5. Supplying information'!G15)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H15),\"\",'5. Supplying information'!H15)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I15),\"\",'5. Supplying information'!I15)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J15),\"\",'5. Supplying information'!J15)","v":""}]
["Supplying information",5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.1","Address responses and information clearly with the person’s name.",{"$f":"IF(ISBLANK('5. Supplying information'!E16),\"\",'5. Supplying information'!E16)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F16),\"\",'5. Supplying information'!F16)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G16),\"\",'5. Supplying information'!G16)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H16),\"\",'5. Supplying information'!H16)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I16),\"\",'5. Supplying information'!I16)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J16),\"\",'5. Supplying information'!J16)","v":""}]
[{"$f":"A69","v":"Supplying information"},5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.2","Keep the contact information you hold up-to-date.",{"$f":"IF(ISBLANK('5. Supplying information'!E17),\"\",'5. Supplying information'!E17)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F17),\"\",'5. Supplying information'!F17)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G17),\"\",'5. Supplying information'!G17)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H17),\"\",'5. Supplying information'!H17)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I17),\"\",'5. Supplying information'!I17)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J17),\"\",'5. Supplying information'!J17)","v":""}]
["Supplying information",5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.3","Keep a log of who has had access to the information you’ve disclosed and regularly review access controls.",{"$f":"IF(ISBLANK('5. Supplying information'!E18),\"\",'5. Supplying information'!E18)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F18),\"\",'5. Supplying information'!F18)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G18),\"\",'5. Supplying information'!G18)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H18),\"\",'5. Supplying information'!H18)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I18),\"\",'5. Supplying information'!I18)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J18),\"\",'5. Supplying information'!J18)","v":""}]
["Supplying information",5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.4","Keep an accurate and up-to-date record of processing activities.",{"$f":"IF(ISBLANK('5. Supplying information'!E19),\"\",'5. Supplying information'!E19)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!F19),\"\",'5. Supplying information'!F19)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!G19),\"\",'5. Supplying information'!G19)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!H19),\"\",'5. Supplying information'!H19)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!I19),\"\",'5. Supplying information'!I19)","v":""},{"$f":"IF(ISBLANK('5. Supplying information'!J19),\"\",'5. Supplying information'!J19)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.1","Measure performance by looking at the number of requests you’ve received and the percentage you’ve completed within statutory timescales.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E2),\"\",'6. Monitoring & improving perf'!E2)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F2),\"\",'6. Monitoring & improving perf'!F2)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G2),\"\",'6. Monitoring & improving perf'!G2)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H2),\"\",'6. Monitoring & improving perf'!H2)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I2),\"\",'6. Monitoring & improving perf'!I2)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J2),\"\",'6. Monitoring & improving perf'!J2)","v":""}]
[{"$f":"A73","v":"Monitoring & improving performance"},6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.2","Report performance to senior managers regularly for oversight.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E3),\"\",'6. Monitoring & improving perf'!E3)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F3),\"\",'6. Monitoring & improving perf'!F3)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G3),\"\",'6. Monitoring & improving perf'!G3)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H3),\"\",'6. Monitoring & improving perf'!H3)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I3),\"\",'6. Monitoring & improving perf'!I3)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J3),\"\",'6. Monitoring & improving perf'!J3)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.3","Regularly discuss and act on metrics or key performance indicators for requests at relevant steering groups.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E4),\"\",'6. Monitoring & improving perf'!E4)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F4),\"\",'6. Monitoring & improving perf'!F4)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G4),\"\",'6. Monitoring & improving perf'!G4)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H4),\"\",'6. Monitoring & improving perf'!H4)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I4),\"\",'6. Monitoring & improving perf'!I4)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J4),\"\",'6. Monitoring & improving perf'!J4)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.4","Track issues, trends, and reasons for delays in handling requests, and report insight to senior managers regularly for oversight.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E5),\"\",'6. Monitoring & improving perf'!E5)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F5),\"\",'6. Monitoring & improving perf'!F5)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G5),\"\",'6. Monitoring & improving perf'!G5)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H5),\"\",'6. Monitoring & improving perf'!H5)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I5),\"\",'6. Monitoring & improving perf'!I5)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J5),\"\",'6. Monitoring & improving perf'!J5)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.5","Analyse complaints or appeals about requests, and use lessons learned to improve processes and review policies.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E6),\"\",'6. Monitoring & improving perf'!E6)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F6),\"\",'6. Monitoring & improving perf'!F6)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G6),\"\",'6. Monitoring & improving perf'!G6)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H6),\"\",'6. Monitoring & improving perf'!H6)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I6),\"\",'6. Monitoring & improving perf'!I6)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J6),\"\",'6. Monitoring & improving perf'!J6)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.6","Monitor the number of complaints to the ICO about how you’ve handled requests.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E7),\"\",'6. Monitoring & improving perf'!E7)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F7),\"\",'6. Monitoring & improving perf'!F7)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G7),\"\",'6. Monitoring & improving perf'!G7)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H7),\"\",'6. Monitoring & improving perf'!H7)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I7),\"\",'6. Monitoring & improving perf'!I7)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J7),\"\",'6. Monitoring & improving perf'!J7)","v":""}]
["Monitoring & improving performance",6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.7","Keep records to show clear and sustainable improvement in your request handling processes.",{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!E8),\"\",'6. Monitoring & improving perf'!E8)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!F8),\"\",'6. Monitoring & improving perf'!F8)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!G8),\"\",'6. Monitoring & improving perf'!G8)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!H8),\"\",'6. Monitoring & improving perf'!H8)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!I8),\"\",'6. Monitoring & improving perf'!I8)","v":""},{"$f":"IF(ISBLANK('6. Monitoring & improving perf'!J8),\"\",'6. Monitoring & improving perf'!J8)","v":""}]

{"sheet":"Tables & graphs","index":3,"n_rows":27,"n_cols":8,"rows_kept":27,"cut":false,"hidden":true,"merged":[]}
[null,"1. Preparing for requests","2. Recognising requests","3. Validating & managing requests","4. Finding & retrieving information","5. Supplying information","6. Monitoring & improving performance","Total"]
["Fully meeting our expectation",{"$f":"COUNTIF('1. Preparing for requests'!E:E,A2)","v":0},{"$f":"COUNTIF('2. Recognising requests'!E:E,A2)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!E:E,A2)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!E:E,A2)","v":0},{"$f":"COUNTIF('5. Supplying information'!E:E,A2)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!E:E,A2)","v":0},{"$f":"SUM(B2:G2)","v":0}]
["Partially meeting our expectation",{"$f":"COUNTIF('1. Preparing for requests'!E:E,A3)","v":0},{"$f":"COUNTIF('2. Recognising requests'!E:E,A3)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!E:E,A3)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!E:E,A3)","v":0},{"$f":"COUNTIF('5. Supplying information'!E:E,A3)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!E:E,A3)","v":0},{"$f":"SUM(B3:G3)","v":0}]
["Not meeting our expectation",{"$f":"COUNTIF('1. Preparing for requests'!E:E,A4)","v":0},{"$f":"COUNTIF('2. Recognising requests'!E:E,A4)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!E:E,A4)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!E:E,A4)","v":0},{"$f":"COUNTIF('5. Supplying information'!E:E,A4)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!E:E,A4)","v":0},{"$f":"SUM(B4:G4)","v":0}]
["Not Applicable",{"$f":"COUNTIF('1. Preparing for requests'!E:E,A5)","v":0},{"$f":"COUNTIF('2. Recognising requests'!E:E,A5)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!E:E,A5)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!E:E,A5)","v":0},{"$f":"COUNTIF('5. Supplying information'!E:E,A5)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!E:E,A5)","v":0},{"$f":"SUM(B5:G5)","v":0}]
["Blank",{"$f":"COUNTBLANK('1. Preparing for requests'!E2:E14)","v":13},{"$f":"COUNTBLANK('2. Recognising requests'!E2:E7)","v":6},{"$f":"COUNTBLANK('3. Validating & managing reque '!E2:E21)","v":20},{"$f":"COUNTBLANK('4. Finding & retrieving info'!E2:E14)","v":13},{"$f":"COUNTBLANK('5. Supplying information'!E2:E19)","v":18},{"$f":"COUNTBLANK('6. Monitoring & improving perf'!E2:E8)","v":7},{"$f":"SUM(B6:G6)","v":77}]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"1. Preparing for requests","2. Recognising requests","3. Validating & managing requests","4. Finding & retrieving information","5. Supplying information","6. Monitoring & improving performance","Total"]
["Not started",{"$f":"COUNTIF('1. Preparing for requests'!I:I,A18)","v":0},{"$f":"COUNTIF('2. Recognising requests'!I:I,A18)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!I:I,A18)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!I:I,A18)","v":0},{"$f":"COUNTIF('5. Supplying information'!I:I,A18)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!I:I,A18)","v":0},{"$f":"SUM(B18:G18)","v":0}]
["Action rejected",{"$f":"COUNTIF('1. Preparing for requests'!I:I,A19)","v":0},{"$f":"COUNTIF('2. Recognising requests'!I:I,A19)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!I:I,A19)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!I:I,A19)","v":0},{"$f":"COUNTIF('5. Supplying information'!I:I,A19)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!I:I,A19)","v":0},0]
["On track",{"$f":"COUNTIF('1. Preparing for requests'!I:I,A20)","v":0},{"$f":"COUNTIF('2. Recognising requests'!I:I,A20)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!I:I,A20)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!I:I,A20)","v":0},{"$f":"COUNTIF('5. Supplying information'!I:I,A20)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!I:I,A20)","v":0},0]
["Overdue",{"$f":"COUNTIF('1. Preparing for requests'!I:I,A21)","v":0},{"$f":"COUNTIF('2. Recognising requests'!I:I,A21)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!I:I,A21)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!I:I,A21)","v":0},{"$f":"COUNTIF('5. Supplying information'!I:I,A21)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!I:I,A21)","v":0},0]
["Completed",{"$f":"COUNTIF('1. Preparing for requests'!I:I,A22)","v":0},{"$f":"COUNTIF('2. Recognising requests'!I:I,A22)","v":0},{"$f":"COUNTIF('3. Validating & managing reque '!I:I,A22)","v":0},{"$f":"COUNTIF('4. Finding & retrieving info'!I:I,A22)","v":0},{"$f":"COUNTIF('5. Supplying information'!I:I,A22)","v":0},{"$f":"COUNTIF('6. Monitoring & improving perf'!I:I,A22)","v":0},0]
["Blank",{"$f":"COUNTBLANK('1. Preparing for requests'!I2:I14)","v":13},{"$f":"COUNTBLANK('2. Recognising requests'!I2:I7)","v":6},{"$f":"COUNTBLANK('3. Validating & managing reque '!I2:I21)","v":20},{"$f":"COUNTBLANK('4. Finding & retrieving info'!I2:I14)","v":13},{"$f":"COUNTBLANK('5. Supplying information'!I2:I19)","v":18},{"$f":"COUNTBLANK('6. Monitoring & improving perf'!I2:I8)","v":7},77]
[]
[]
[null,"Not started","Action rejected","On track","Overdue","Completed","Blank"]
[null,{"$f":"SUM(B18:G18)","v":0},{"$f":"SUM(B19:G19)","v":0},{"$f":"SUM(B20:G20)","v":0},{"$f":"SUM(B21:G21)","v":0},{"$f":"SUM(B22:G22)","v":0},{"$f":"SUM(B23:G23)","v":77}]

{"sheet":"Lookup","index":4,"n_rows":9,"n_cols":7,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
["Fully meeting our expectation",null,null,null,"Not started",null,"Not started"]
["Partially meeting our expectation",null,null,null,"Action rejected",null,"In progress"]
["Not meeting our expectation",null,null,null,"On track",null,"Overdue"]
["Not Applicable",null,null,null,"Overdue",null,"Completed"]
[null,null,null,null,"Completed"]
[]
[]
["2000-01-01"]
[{"$f":"TODAY()","v":"2024-09-17"}]

{"sheet":"1. Preparing for requests","index":5,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[12,1,13,1],[12,0,13,0],[1,0,4,0],[1,1,4,1],[5,0,9,0],[5,1,9,1],[10,1,11,1],[10,0,11,0]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current status","Reasons for Status","Actions","Action Owner","Action Status","Due date\n(DD/MM/YYYY)"]
[1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.1","Document how you handle requests in sufficient detail in policies, including who oversees the request process."]
[{"$f":"A2","v":1.1000000000000001},"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.2","Ensure these policies have appropriate document version control."]
[1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.3","Communicate these policies to staff dealing with requests and make policies readily available for them to refer to."]
[1.1000000000000001,"Processes for handling requests for access to personal information are in place and outlined in policies.","1.1.4","Keep policies up-to-date, particularly with changes to data protection law."]
[1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.1","Identify the specific staff member or team who manages and responds to requests."]
[{"$f":"A6","v":1.2000000000000002},"Staff are in place and are competent to handle requests for access.","1.2.2","Assign sufficient resources to process the requests you receive."]
[1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.3","Build resilience to mitigate the risk of request backlogs or failures to meet the statutory timeframes that result from staff absence."]
[1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.4","Provide specialised training for staff who handle requests, particularly on statutory requirements and exemptions. "]
[1.2000000000000002,"Staff are in place and are competent to handle requests for access.","1.2.5","Record training requirements in a training needs analysis or training programme."]
[1.3,"People are guided on how to make verbal or written requests for access.","1.3.1","Produce guidance on how to make verbal and written (including electronic) requests."]
[{"$f":"A11","v":1.3},"People are guided on how to make verbal or written requests for access.","1.3.2","Make guidance easily accessible and available in electronic and paper formats."]
[1.4000000000000004,"Processors acting on your behalf are ready and able to respond to requests for access.","1.4.1","Include requirements for processors to handle requests for access in contracts, including clear timescales for response."]
[{"$f":"A13","v":1.4000000000000004},"Processors acting on your behalf are ready and able to respond to requests for access.","1.4.2","Check that processors can competently respond to requests for personal information prior to processing it."]

{"sheet":"2. Recognising requests","index":6,"n_rows":7,"n_cols":10,"rows_kept":7,"cut":false,"hidden":false,"merged":[[1,12,3,12],[4,11,6,11],[4,12,6,12],[1,1,3,1],[1,0,3,0],[4,1,6,1],[4,0,6,0],[1,11,3,11]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current Status","Reasons for Status","Actions","Action Owner","Action Status","Due Date\n(DD/MM/YYYY)"]
[2.1,"Staff can recognise verbal and written (including electronic) requests for access.","2.1.1","Produce guidance for staff on how to recognise verbal, electronic and written requests."]
[{"$f":"A2","v":2.1},"Staff can recognise verbal and written (including electronic) requests for access.","2.1.2","Make guidance easily accessible and available in electronic and paper formats for staff who do not regularly work on computers."]
[2.1,"Staff can recognise verbal and written (including electronic) requests for access.","2.1.3","Train all staff on recognising requests."]
[2.2000000000000002,"Staff direct requests to the person or team who handles them.","2.2.1","Produce guidance for staff on how to direct or channel requests to the person or team who handles them."]
[{"$f":"A5","v":2.2000000000000002},"Staff direct requests to the person or team who handles them.","2.2.2","Make guidance easily accessible and available in electronic and paper formats for staff who do not regularly work on computers."]
[2.2000000000000002,"Staff direct requests to the person or team who handles them.","2.2.3","Train all staff on directing requests."]

{"sheet":"3. Validating & managing reque ","index":7,"n_rows":21,"n_cols":10,"rows_kept":21,"cut":false,"hidden":false,"merged":[[19,0,20,0],[19,1,20,1],[1,0,5,0],[1,1,5,1],[6,1,11,1],[6,0,11,0],[12,1,18,1],[12,0,18,0]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current status","Reasons fo Status","Actions","Action Owner","Action Status","Due Date\n(DD/MM/YYYY)"]
[3.1,"Processes to verify the validity of requests are in place.","3.1.1","Verify the identity of the requestor and the address to send the information to, and keep records of the verification checks."]
[{"$f":"A2","v":3.1},"Processes to verify the validity of requests are in place.","3.1.2","Verify that third parties making requests on behalf of people have written authority or power of attorney to make the request."]
[3.1,"Processes to verify the validity of requests are in place.","3.1.3","Ensure staff are aware why verification checks are important."]
[3.1,"Processes to verify the validity of requests are in place.","3.1.4","Sample or check that staff carry out verification checks appropriately on completed requests."]
[3.1,"Processes to verify the validity of requests are in place.","3.1.5","Document verification checks and how to carry them out  in sufficient detail in policies."]
[3.2,"Detailed records of requests handled are kept.","3.2.1","Keep a log of all verbal and written requests."]
[{"$f":"A7","v":3.2},"Detailed records of requests handled are kept.","3.2.2","Log who handled each request."]
[3.2,"Detailed records of requests handled are kept.","3.2.3","Log what stage each request is at."]
[3.2,"Detailed records of requests handled are kept.","3.2.4","Log the due date for a response to each request within the statutory timeframe, the actual date you responded to each request, and the reason for any delays, where you didn’t meet the statutory timeframe."]
[3.2,"Detailed records of requests handled are kept.","3.2.5","Log where information was withheld under exemption or related to third parties, and why this decision was made and by who."]
[3.2,"Detailed records of requests handled are kept.","3.2.6","Log requests that were refused entirely or handled following a different process, and why this decision was made and by who."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.1","Acknowledge each request by confirming receipt electronically or in writing and inform the requestor of the latest date they will receive a response by. This will be no later than one month from the date you received their request."]
[{"$f":"A13","v":3.3},"Processes to acknowledge and manage requests correctly are in place.","3.3.2","Seek clarification promptly when the nature of the request is unclear or the request doesn’t contain enough information to respond."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.3","Inform the requestor if you need to extend the response timeframe for their request. Only extend it by a further two months due to the volume or complexity of the request."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.4","Inform the requestor if their request is delayed, why it is delayed, and the expected date they will receive a response by."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.5","Prioritise or escalate requests that are delayed."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.6","Ensure managers monitor requests in progress, including what stage each request is at and any issues or delays, to meet timescales."]
[3.3,"Processes to acknowledge and manage requests correctly are in place.","3.3.7","Escalate details of requests that staff have not responded to within the statutory timeframe to a suitably senior manager or oversight group."]
[3.4,"Requests for access are responded to within the statutory timeframe.","3.4.1","Keep records to show that you have responded to requests for access and actioned them within the statutory timeframe."]
[{"$f":"A20","v":3.4},"Requests for access are responded to within the statutory timeframe.","3.4.2","Keep records of mitigating factors and actions taken for any requests for access that you didn’t respond to or action within the statutory timeframe."]

{"sheet":"4. Finding & retrieving info","index":8,"n_rows":14,"n_cols":10,"rows_kept":14,"cut":false,"hidden":false,"merged":[[1,1,5,1],[1,0,5,0],[6,0,9,0],[6,1,9,1],[10,1,13,1],[10,0,13,0]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current status","Reasons for Status","Actions","Action owner","Action Status","Due date\n(DD/MM/YYY)"]
[4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.1","Implement a process to quickly locate relevant current paper records (that are part of a filing system)."]
[{"$f":"A2","v":4.0999999999999996},"Processes to locate requested information in a timely manner are in place.","4.1.2","Implement a process to quickly locate and retrieve paper records from archives or external storage."]
[4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.3","Implement a process to quickly locate relevant current electronic records."]
[4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.4","Implement a process to quickly locate and retrieve electronic records from archives, back-ups, or email storage."]
[4.0999999999999996,"Processes to locate requested information in a timely manner are in place.","4.1.5","Assign points of contact in satellite departments or buildings who can quickly retrieve paper or electronic records stored locally."]
[4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.1","Document how to apply exemptions, including redacting third party information, clearly in the relevant policies."]
[{"$f":"A7","v":4.2},"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.2","Ensure staff apply exemptions and redactions appropriately and correctly."]
[4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.3","Ensure a senior staff members reviews and authorises exemptions and redactions (or a sample of them)."]
[4.2,"Processes to properly consider whether to withhold or redact information relating to the person or a third party are in place.","4.2.4","Provide specialised training for staff who apply, review or authorise exemptions."]
[4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.1","Implement an appropriate redaction method."]
[{"$f":"A11","v":4.3},"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.2","Review or sample exemptions and redactions to check staff are taking a consistent approach."]
[4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.3","Keep records of all redactions to capture who did the redaction, the date, and the justification."]
[4.3,"A consistent approach is taken to removing confidential or third-party information from information provided in response to requests.","4.3.4","Retain these records for reference, in line with the retention schedule."]

{"sheet":"5. Supplying information","index":9,"n_rows":19,"n_cols":10,"rows_kept":19,"cut":false,"hidden":false,"merged":[[15,0,18,0],[15,1,18,1],[5,0,9,0],[5,1,9,1],[1,1,4,1],[1,0,4,0],[10,0,12,0],[10,1,12,1],[13,0,14,0],[13,1,14,1]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current status","Reasons for Status","Actions","Action owner","Action Status","Due date\n(DD/MM/YYYY)"]
[5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.1","Provide information in a commonly used electronic format, or another format, if requested."]
[{"$f":"A2","v":5.0999999999999996},"Information is provided to the requestor in a suitable format.","5.1.2","Ask what format the requestor prefers the information in, before fulfilling the request."]
[5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.3","Provide information in a secure way."]
[5.0999999999999996,"Information is provided to the requestor in a suitable format.","5.1.4","Assess whether it is appropriate to provide original copies of documents containing personal information, or a transcript or extract with the personal information."]
[5.2,"Information is provided to help people understand the response.","5.2.1","Send a cover note or letter with the response, explaining clearly what searches you have completed and an overview of the information that you have provided."]
[{"$f":"A6","v":5.2},"Information is provided to help people understand the response.","5.2.2","Explain any information that people may not understand (eg codes, handwritten notes, or acronyms)."]
[5.2,"Information is provided to help people understand the response.","5.2.3","Explain the purposes of the processing."]
[5.2,"Information is provided to help people understand the response.","5.2.4","Use clear, plain, non-technical language when providing explanations."]
[5.2,"Information is provided to help people understand the response.","5.2.5","Have a clear formal process for people to complain or appeal about decisions you’ve made about their request."]
[5.3,"Decisions to withhold information from responses are explained clearly to requestors.","5.3.1","Send a cover note or letter with the response, explaining clearly what information you have withheld and why."]
[{"$f":"A11","v":5.3},"Decisions to withhold information from responses are explained clearly to requestors.","5.3.2","Use clear, plain, non-technical language when providing explanations."]
[5.3,"Decisions to withhold information from responses are explained clearly to requestors.","5.3.3","Have a clear formal process for people to complain or appeal about decisions you’ve made about their request."]
[5.4,"People are given direct access to their information, if requested or required.","5.4.1","Allow people to view information in person on site if they request this."]
[{"$f":"A14","v":5.4},"People are given direct access to their information, if requested or required.","5.4.2","Allow people to view information using a secure online portal they can easily access."]
[5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.1","Address responses and information clearly with the person’s name."]
[{"$f":"A16","v":5.5},"Access to information provided is tracked to identify the source of any further disclosures.","5.5.2","Keep the contact information you hold up-to-date."]
[5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.3","Keep a log of who has had access to the information you’ve disclosed and regularly review access controls."]
[5.5,"Access to information provided is tracked to identify the source of any further disclosures.","5.5.4","Keep an accurate and up-to-date record of processing activities."]

{"sheet":"6. Monitoring & improving perf","index":10,"n_rows":8,"n_cols":10,"rows_kept":8,"cut":false,"hidden":false,"merged":[[1,1,7,1],[1,0,7,0]]}
["Number","Our expectations","Reference","Ways to meet our expectations","Current status","Reasons for Status","Actions","Action owner","Action Status","Due Date\n(DD/MM/YYYY)"]
[6.1,"Performance and compliance in handling requests is monitored. Performance and compliance information is used to improve processes.","6.1.1","Measure performance by looking at the number of requests you’ve received and the percentage you’ve completed within statutory timescales."]
[null,null,"6.1.2","Report performance to senior managers regularly for oversight."]
[null,null,"6.1.3","Regularly discuss and act on metrics or key performance indicators for requests at relevant steering groups."]
[null,null,"6.1.4","Track issues, trends, and reasons for delays in handling requests, and report insight to senior managers regularly for oversight."]
[null,null,"6.1.5","Analyse complaints or appeals about requests, and use lessons learned to improve processes and review policies."]
[null,null,"6.1.6","Monitor the number of complaints to the ICO about how you’ve handled requests."]
[null,null,"6.1.7","Keep records to show clear and sustainable improvement in your request handling processes."]