{"text_format":"1","workbook":"xlsx","n_sheets":16,"sheets":["working blank spare","Front Sheet","DO NOT USE","Activity (1)","Activity (2)","Activity (3)","Activity (4)","Activity (5)","Activity (6)","Premises (BAU)","Staff Requirements","   Activity interactions","BIA (5)","Data Processes","Further Guidance on BC ","Lists"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":284,"comments":14,"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":"working blank spare","index":0,"n_rows":32,"n_cols":14,"rows_kept":32,"cut":false,"hidden":true,"merged":[[30,10,32,10],[30,11,32,12],[32,1,33,2],[33,4,34,4],[33,5,34,5],[33,6,34,6],[33,7,34,9],[33,10,34,10],[33,11,34,12],[34,1,34,2],[30,1,31,2],[30,4,32,4],[30,5,32,5],[30,6,32,6],[30,7,32,9],[24,4,24,12],[25,7,25,9],[25,10,25,12],[26,1,28,1],[26,2,28,2],[26,4,26,9],[26,11,26,12],[27,4,29,4],[27,5,29,5],[27,6,29,6],[27,7,29,9],[27,10,29,10],[27,11,29,12],[29,1,29,2],[21,4,22,12],[17,1,22,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,22,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,null,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) "]
[]
[]
[]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C26=\"\",\"\",IF(C26>4,\"Essential\",IF(C27>4,\"Critical\",IF(C28>3,\"High\",IF(C29>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B27=\"\",\"\",IF(B27>4,\"Essential\",IF(B28>4,\"Critical\",IF(B29>3,\"High\",IF(B30>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C27=\"\",\"\",IF(C27>4,\"Essential\",IF(C28>4,\"Critical\",IF(C29>3,\"High\",IF(C30>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Front Sheet","index":1,"n_rows":23,"n_cols":7,"rows_kept":23,"cut":false,"hidden":false,"merged":[[3,1,14,2],[1,1,1,11],[3,6,8,11]]}
[]
[null,"NHS Business Impact Analysis Template"]
[]
[null,"Template Overview\n\nThis template is designed to assist the NHS in England in developing Business Continuity Plans. \n\nThis document can be amended and therefore be tailored to your organisaion. Under each tab  'Activity' 'Premises' etc there are red flags located in some of the fields. If you place your curser over these fields, you will see a text commentary box appear, which specifices what is required from each field.   \n\nThere are 6 activity tabs. Should you wish to add any additional tabs then link the new activity back to the template overview.                                                          \n                                                                                                                          The previous version of this template was created using Microsoft Word. The BIA has now been streamlined and transferred to Microsoft Excel.                                                                                                                 ",null,null,"Activity  (1)",null,"To add additional activities to the BIA:\n1. Right click on a blank activity tab below\n2. Select Move or Copy...\n3. Highlight staff requirements in the 'before sheet' box\n4. Ensure that the create a copy box is checked\n5. Click ok.\n\nCell 'B4' on the new activity sheet will also need to be updated to match the new activity number."]
[null,null,null,null,"Activity (2)"]
[null,null,null,null,"Activity (3)"]
[null,null,null,null,"Activity (4)"]
[null,null,null,null,"Activity (5)"]
[null,null,null,null,"Activity (6)"]
[null,null,null,null,"Premises (BAU)"]
[null,null,null,null,"Staff Requirements"]
[null,null,null,null,"Activity interactions"]
[null,null,null,null,"Data Processes"]
[null,null,null,null,"Further guidance"]
[]
[]
[null,"BIA Version:",1]
[null,"Name of Author:"]
[null,"Job Title:"]
[null,"Contact Details:"]
[null,"Date of Completion:"]
[null,"Business Continuity Lead:"]
[null,"Name & Location of Team:"]

{"sheet":"DO NOT USE","index":2,"n_rows":16,"n_cols":10,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
[]
[null,1,null,"Input",null,"National System",null,null,"Yes",1]
[null,2,null,"Output",null,"Local System",null,null,"No",2]
[null,3,null,null,null,"National Software",null,null,null,3]
[null,4,null,null,null,"Local Software",null,null,null,4]
[null,5,null,null,null,null,null,null,null,5]
[null,null,null,null,null,"Critical ",null,null,null,6]
[null,null,null,null,null,"Urgent ",null,null,null,7]
[null,null,null,null,null,"Non-Urgent ",null,null,null,8]
[null,null,null,null,null,null,null,null,null,9]
[null,null,null,null,null,null,null,null,null,10]
[null,null,null,null,null,null,null,null,null,11]
[null,null,null,null,null,null,null,null,null,12]
[null,null,null,null,null,null,null,null,null,13]
[null,null,null,null,null,null,null,null,null,14]
[null,null,null,null,null,null,null,null,null,15]

{"sheet":"Activity (1)","index":3,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[16,1,16,2],[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[13,9,15,9],[13,10,15,10],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[20,4,20,12],[13,11,15,11],[13,12,15,12],[24,4,25,12],[17,8,19,8],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[16,4,16,12],[21,4,22,12],[27,4,27,12],[29,1,31,1],[29,2,31,2],[28,4,28,13],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[23,4,23,12],[31,12,31,13],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[35,10,36,10],[35,11,36,12],[36,1,36,2],[33,1,34,2],[32,1,32,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[32,12,32,13]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Activity (2)","index":4,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[21,4,22,12],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[23,4,23,12],[24,4,25,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[27,4,27,12],[28,4,28,13],[29,1,31,1],[29,2,31,2],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[31,12,31,13],[36,1,36,2],[32,1,32,2],[32,12,32,13],[33,1,34,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[35,10,36,10],[35,11,36,12]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Activity (3)","index":5,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[21,4,22,12],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[23,4,23,12],[24,4,25,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[27,4,27,12],[28,4,28,13],[29,1,31,1],[29,2,31,2],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[31,12,31,13],[36,1,36,2],[32,1,32,2],[32,12,32,13],[33,1,34,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[35,10,36,10],[35,11,36,12]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Activity (4)","index":6,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[21,4,22,12],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[23,4,23,12],[24,4,25,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[27,4,27,12],[28,4,28,13],[29,1,31,1],[29,2,31,2],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[31,12,31,13],[36,1,36,2],[32,1,32,2],[32,12,32,13],[33,1,34,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[35,10,36,10],[35,11,36,12]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Activity (5)","index":7,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[21,4,22,12],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[23,4,23,12],[24,4,25,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[27,4,27,12],[28,4,28,13],[29,1,31,1],[29,2,31,2],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[31,12,31,13],[36,1,36,2],[32,1,32,2],[32,12,32,13],[33,1,34,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[35,10,36,10],[35,11,36,12]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Activity (6)","index":8,"n_rows":35,"n_cols":14,"rows_kept":35,"cut":false,"hidden":false,"merged":[[9,10,11,10],[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[9,13,25,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[21,4,22,12],[17,1,25,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[23,4,23,12],[24,4,25,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[27,4,27,12],[28,4,28,13],[29,1,31,1],[29,2,31,2],[29,4,29,6],[29,7,29,9],[29,10,29,13],[30,12,30,13],[31,12,31,13],[36,1,36,2],[32,1,32,2],[32,12,32,13],[33,1,34,2],[35,1,35,2],[35,4,36,4],[35,5,36,5],[35,6,36,6],[35,7,36,9],[35,10,36,10],[35,11,36,12]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,1,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",null,null,null,null,null,null,null,{"$f":"SUM(F10:L12)/7","v":0},{"$f":"SUM(M10+M14+M18)","v":0}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",null,null,null,null,null,null,null,{"$f":"SUM(F14:L16)/7","v":0}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",null,null,null,null,null,null,null,{"$f":"SUM(F18:L20)/7","v":0}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[null,null,null,null,"If this activity (or similar activity) is also carried out in other Directorates, has a comparison of the RTO, MTPoD and RAG rating been updertaken?"]
[]
[]
[]
[]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"RAG Rating Score"]
[null,null,null,null,"Less than 4.9 is GREEN",null,null,"Between 5 and 9.9 is AMBER",null,null,"Over 10 is RED"]
[null,null,null,null,"RTO","MTPOD","RPO","RTO","MTPOD","RPO","RTO","MTPOD","RPO"]
[null,null,null,null,"7 Days+","7 Days+","7 Days+","1 Day",">7 Days",">7 Days"," 0 Hours",">24 Hours",">24 Hours"]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Non-Urgent"},{"$f":"IF(C29=\"\",\"\",IF(C29>4,\"Essential\",IF(C30>4,\"Critical\",IF(C31>3,\"High\",IF(C32>2,\"Medium\",\"Low\")))))","v":"Essential"}]
[null,{"$f":"IF(B30=\"\",\"\",IF(B30>4,\"Essential\",IF(B31>4,\"Critical\",IF(B32>3,\"High\",IF(B33>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C30=\"\",\"\",IF(C30>4,\"Essential\",IF(C31>4,\"Critical\",IF(C32>3,\"High\",IF(C33>2,\"Medium\",\"Low\")))))","v":""}]

{"sheet":"Premises (BAU)","index":9,"n_rows":48,"n_cols":2,"rows_kept":48,"cut":false,"hidden":false,"merged":[[43,1,44,1],[43,2,44,9],[45,1,46,1],[45,2,46,9],[47,1,48,1],[47,2,48,9],[37,1,38,1],[37,2,38,9],[39,1,40,1],[39,2,40,9],[42,1,42,9],[31,1,32,1],[31,2,32,9],[34,1,34,9],[35,1,36,1],[35,2,36,9],[26,1,26,9],[27,1,28,1],[27,2,28,9],[29,1,30,1],[29,2,30,9],[19,1,20,1],[19,2,20,9],[21,1,22,1],[21,2,22,9],[23,1,24,1],[23,2,24,9],[13,1,14,1],[13,2,14,9],[15,1,16,1],[15,2,16,9],[18,1,18,9],[7,1,8,1],[7,2,8,9],[10,1,10,9],[11,1,12,1],[11,2,12,9],[2,1,2,9],[3,1,4,1],[3,2,4,9],[5,1,6,1],[5,2,6,9]]}
[]
[]
[null,"Activity 1 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]
[]
[]
[null,"Activity 2 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]
[]
[]
[null,"Activity 3 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]
[]
[]
[null,"Activity 4 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]
[]
[]
[null,"Activity 5 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]
[]
[]
[null,"Activity 6 - Premises Requirements "]
[null,"0 - 24 hrs."]
[]
[null,"24 hrs. > 7 days"]
[]
[null,"7 days +"]

{"sheet":"Staff Requirements","index":10,"n_rows":77,"n_cols":9,"rows_kept":77,"cut":false,"hidden":false,"merged":[[3,4,3,6],[3,7,3,9],[4,1,4,6],[4,8,4,9],[5,7,13,7],[5,8,13,9],[5,4,13,6],[11,1,13,1],[11,2,13,2],[11,3,13,3],[8,1,10,1],[8,2,10,2],[8,3,10,3],[5,1,7,1],[5,2,7,2],[5,3,7,3],[16,4,16,6],[16,7,16,9],[17,1,17,6],[17,8,17,9],[18,1,20,1],[18,2,20,2],[18,3,20,3],[18,4,26,6],[18,7,26,7],[18,8,26,9],[21,1,23,1],[21,2,23,2],[21,3,23,3],[24,1,26,1],[24,2,26,2],[24,3,26,3],[29,4,29,6],[29,7,29,9],[30,1,30,6],[30,8,30,9],[31,1,33,1],[31,2,33,2],[31,3,33,3],[31,4,39,6],[31,7,39,7],[31,8,39,9],[34,1,36,1],[34,2,36,2],[34,3,36,3],[37,1,39,1],[37,2,39,2],[37,3,39,3],[42,4,42,6],[42,7,42,9],[43,1,43,6],[43,8,43,9],[44,1,46,1],[44,2,46,2],[44,3,46,3],[44,4,52,6],[44,7,52,7],[44,8,52,9],[47,1,49,1],[47,2,49,2],[47,3,49,3],[50,1,52,1],[50,2,52,2],[50,3,52,3],[55,4,55,6],[55,7,55,9],[56,1,56,6],[56,8,56,9],[57,1,59,1],[57,2,59,2],[57,3,59,3],[57,4,65,6],[57,7,65,7],[57,8,65,9],[60,1,62,1],[60,2,62,2],[60,3,62,3],[63,1,65,1],[63,2,65,2],[63,3,65,3],[68,4,68,6],[68,7,68,9],[69,1,69,6],[69,8,69,9],[70,1,72,1],[70,2,72,2],[70,3,72,3],[70,4,78,6],[70,7,78,7],[70,8,78,9],[73,1,75,1],[73,2,75,2],[73,3,75,3],[76,1,78,1],[76,2,78,2],[76,3,78,3]]}
[]
[]
[null,"Activity  1                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]
[]
[]
[]
[null,"Activity  2                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]
[]
[]
[]
[null,"Activity  3                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]
[]
[]
[]
[null,"Activity  4                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]
[]
[]
[]
[null,"Activity  5                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]
[]
[]
[]
[null,"Activity  6                                                                                    Staff Requirements"]
[null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(Name / Tel / E-mail)"]
[null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,"0 - 24 hrs"]
[]
[]
[null,"24 hrs. > 7 days"]
[]
[]
[null,"7 days +"]

{"sheet":"   Activity interactions","index":11,"n_rows":5,"n_cols":6,"rows_kept":5,"cut":false,"hidden":false,"merged":[[10,3,10,4],[10,5,10,13],[3,1,3,13],[6,3,6,4],[6,5,6,13],[9,5,9,13],[9,3,9,4],[4,3,4,4],[4,5,4,13],[5,3,5,4],[5,5,5,13]]}
[]
[]
[]
[null,"                     Activity interactions"]
[null,"Activity Ref ","Input or Output","Supplier/Dependent name",null,"Interaction description"]

{"sheet":"BIA (5)","index":12,"n_rows":59,"n_cols":14,"rows_kept":59,"cut":false,"hidden":true,"merged":[[1,4,1,9],[2,1,2,2],[2,4,6,4],[2,5,2,9],[3,1,3,2],[5,1,5,2],[6,1,6,2],[9,13,22,13],[10,1,10,2],[11,1,15,2],[12,4,12,12],[13,4,15,4],[13,5,15,5],[13,6,15,6],[13,7,15,7],[7,1,9,2],[7,4,8,4],[7,5,7,12],[9,4,11,4],[9,5,11,5],[9,6,11,6],[9,7,11,7],[9,8,11,8],[9,9,11,9],[9,10,11,10],[13,8,15,8],[13,9,15,9],[13,10,15,10],[13,11,15,11],[13,12,15,12],[16,1,16,2],[16,4,16,12],[9,11,11,11],[9,12,11,12],[17,9,19,9],[17,10,19,10],[17,11,19,11],[17,12,19,12],[20,4,20,12],[21,4,22,12],[17,1,22,2],[17,4,19,4],[17,5,19,5],[17,6,19,6],[17,7,19,7],[17,8,19,8],[24,4,24,12],[25,7,25,9],[25,10,25,12],[26,1,28,1],[26,2,28,2],[26,4,26,9],[26,11,26,12],[27,4,29,4],[27,5,29,5],[27,6,29,6],[27,7,29,9],[27,10,29,10],[27,11,29,12],[29,1,29,2],[30,1,31,2],[30,4,32,4],[30,5,32,5],[30,6,32,6],[30,7,32,9],[30,10,32,10],[30,11,32,12],[32,1,33,2],[33,4,35,4],[33,5,35,5],[33,6,35,6],[33,7,35,9],[33,10,35,10],[33,11,35,12],[34,1,35,2],[42,5,43,12],[45,1,45,12],[46,2,46,3],[46,4,46,12],[47,2,47,3],[47,4,47,12],[37,4,37,12],[38,1,39,1],[38,2,39,2],[38,4,39,4],[38,5,39,12],[40,1,43,1],[40,2,43,2],[40,4,41,4],[40,5,41,12],[42,4,43,4],[52,1,52,12],[53,3,53,5],[53,6,53,7],[53,8,53,9],[54,3,54,5],[54,6,54,7],[54,8,54,9],[48,2,48,3],[48,4,48,12],[49,2,49,3],[49,4,49,12],[50,2,50,3],[50,4,50,12],[57,3,57,5],[57,6,57,7],[57,8,57,9],[58,1,58,12],[59,1,61,12],[55,3,55,5],[55,6,55,7],[55,8,55,9],[56,3,56,5],[56,6,56,7],[56,8,56,9]]}
[]
[null,null,null,null,"Impact Scoring Grid"]
[null,"Activity Reference Number",null,null,"Impact Scoring Key ","1 = Negligible - Unlikely to have any impact"]
[null,null,null,null,null,"2 = Low  - May have an impact"]
[null,null,null,null,null,"3 = Medium - Likely to have an impact"]
[null,"Activity Description",null,null,null,"4 = High - Highly probable it will have a significant impact"]
[null,"Name of Activity:",null,null,null,"5 = Very High - Will have a major impact"]
[null,null,null,null,"Length of disruption","Category of Impacts (please refer to descriptors in the instructions)"]
[null,null,null,null,null,"Financial","Service delivery","Reputation","Wellbeing, Health  &  safety","Information security","Statutory / regulatory duty","Business / work plan objective","Impact Score","RAG"]
[null,null,null,null,"0 - 24 hrs",1,1,1,1,1,1,5,{"$f":"SUM(F10:L12)/7","v":1.5714285714285714},{"$f":"SUM(M10+M14+M18)","v":7.5714285714285712}]
[null,"Description of activity:"]
[]
[]
[null,null,null,null,"24 hrs. > 7 days",1,5,5,5,5,5,1,{"$f":"SUM(F14:L16)/7","v":3.8571428571428572}]
[]
[]
[null,"Operational Tasks:"]
[null,null,null,null,"7 days +",1,1,1,1,1,5,5,{"$f":"SUM(F18:L20)/7","v":2.1428571428571428}]
[]
[]
[null,null,null,null,"Does  the activities vary at different times of the hour, day week, month or year? \nThe above should note the impact at the most important period of activity and will require additional information - enter below"]
[]
[]
[]
[null,null,null,null,"Staff Requirements"]
[null,"Recovery Time Objective (RTO) ","Maximum Tolerable Period of Disruption (MTPoD) ",null,"Length of disruption","Minimum number of staff required","Regular number of staff required","Role Requirements \n(skills, knowledge & experience)",null,null,"Key Contacts \n(name / tel / e-mail)"]
[null,null,null,null,null,null,null,null,null,null,"Activity Lead","Deputy"]
[null,null,null,null,"0 - 24 hrs"]
[]
[null,"Activity RAG rating "]
[null,{"$f":"IF(N10=\"\",\"\",IF(N10>9.9,\"Critical\",IF(N10>9.9,\"Critical\",IF(N10>4.99,\"Urgent\",IF(N10<5,\"Non-Urgent\",\"Low\")))))","v":"Urgent"},{"$f":"IF(C26=\"\",\"\",IF(C26>4,\"Essential\",IF(C27>4,\"Critical\",IF(C28>3,\"High\",IF(C29>2,\"Medium\",\"Low\")))))","v":"Essential"},null,"24 hrs. > 7 days"]
[null,{"$f":"IF(B27=\"\",\"\",IF(B27>4,\"Essential\",IF(B28>4,\"Critical\",IF(B29>3,\"High\",IF(B30>2,\"Medium\",\"Low\")))))","v":""},{"$f":"IF(C27=\"\",\"\",IF(C27>4,\"Essential\",IF(C28>4,\"Critical\",IF(C29>3,\"High\",IF(C30>2,\"Medium\",\"Low\")))))","v":""}]
[]
[null,null,null,null,"7 days +"]
[]
[]
[]
[null,null,null,null,"Premises Requirements "]
[null,"Number of VOiP phones required","Number of Dynamic Desktops required",null,"0 - 24 hrs."]
[]
[null,null,null,null,"24 hrs. > 7 days"]
[]
[null,null,null,null,"7 days +"]
[]
[]
[null,"                     Activity interactions"]
[null,"Input or Output","Supplier/Dependent name",null,"Interaction description"]
[]
[]
[]
[]
[]
[null,"Data Processes "]
[null,"Type of system/software","Name of System/software","Data/Information input",null,null,"Supplier/Provider name",null,"Data/Information output",null,"Dependent\nReceiver name","Alternative\nsystem?","RPO"]
[]
[]
[]
[]
[null,"Alternative systems and specialist ICT requirements/equipment - additional information  "]

{"sheet":"Data Processes","index":13,"n_rows":12,"n_cols":14,"rows_kept":12,"cut":false,"hidden":false,"merged":[[10,4,10,6],[10,7,10,8],[10,9,10,10],[11,1,11,13],[12,1,14,13],[6,4,6,6],[6,7,6,8],[6,9,6,10],[7,4,7,6],[7,7,7,8],[7,9,7,10],[3,1,3,13],[4,4,4,6],[4,7,4,8],[4,9,4,10],[5,4,5,6],[5,7,5,8],[5,9,5,10]]}
[]
[]
[]
[null,"Data Processes "]
[null,"Activity Reference Number","Type of system/software","Name of System/software","Data/Information input",null,null,"Supplier/Provider name",null,"Data/Information output",null,"Dependent\nReceiver name","Alternative\nsystem?","RPO"]
[null,1]
[null,2]
[null,3]
[null,4]
[null,5]
[null,6]
[null,"Alternative systems and specialist ICT requirements/equipment - additional information  "]

{"sheet":"Further Guidance on BC ","index":14,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
[]
[null,"The guidance is aligned to ISO 22301/22313 and the NHS England EPRR Core Standards."]
[null,"Guidance"]
[null,"Further guidance on Business Continuity is available from:"]
[null,"• ISO 22301 Security and Resilience - Business Continuity Management Systems – Requirements"]
[null,"• ISO 22313 Societal Security - Business Continuity Management Systems – Guidance"]
[null,"• PAS 2015 - Framework for Health Services Resilience"]
[null,"• NHS Commissioning Board Core Standards for EPRR"]
[null,"• NHS Commissioning Board Business Continuity Management Framework (service resilience)"]
[null,"Organisations Business Continuity Policy"]
[null,"• NHS Commissioning Board Emergency Preparedness Framework "]
[null,"• NHS England EPRR BC toolkit"]
[null,"• NHS Standard Contract"]
[null,"• Business Continuity Institute Good Practice Guidelines – A Guide to Global Good Practice in Business Continuity"]

{"sheet":"Lists","index":15,"n_rows":41,"n_cols":39,"rows_kept":41,"cut":false,"hidden":true,"merged":[]}
["Fifteen Minutes","Thirty Minutes","One Hour","Two Hours","Three Hours","Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Five Days","Six Days","One Week","Two Weeks","Three Weeks","Four Weeks","One Month","Two Months","Three Months","Four Months","Five Months"]
["Thirty Minutes","One Hour ","Two Hours","Three Hours","Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Six Days","Seven Days","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["One Hour ","Two Hours","Three Hours","Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Seven Days","One Week ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Two Hours","Three Hours","Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Three Hours","Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Four Hours","Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Five Hours","Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Three Months","Four Months","Five Months","Six Months"]
["Six Hours","Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Four Months","Five Months","Six Months"]
["Seven Hours","Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Five Months","Six Months"]
["Eight Hours","Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Six Months"]
["Nine Hours","Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months"]
["Ten Hours","Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Eleven Hours","Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Twelve Hours","Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Thirteen Hours","Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Fourteen Hours","Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Fifteen Hours","Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Sixteen Hours","Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Seventeen Hours","Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Eighteen Hours","Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Nineteen Hours","Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Twenty Hours","Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Twenty One Hours","Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Twenty Two Hours","Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Twenty Three Hours","One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["One Day","Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Two Days","Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Three Days","Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Four Days","Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Five Days","Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Six Days","One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["One Week ","Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Two Weeks ","Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Three Weeks ","Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Four Weeks ","One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["One Month","Two Months","Three Months","Four Months","Five Months","Six Months"]
["Two Months","Three Months","Four Months","Five Months","Six Months"]
["Three Months","Four Months","Five Months","Six Months"]
["Four Months","Five Months","Six Months"]
["Five Months","Six Months"]
["Six Months"]