{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Cover Sheet","G6 & CoS7","Lookups","Settings"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":25,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Cover Sheet","index":0,"n_rows":20,"n_cols":3,"rows_kept":20,"cut":false,"hidden":false,"merged":[[1,1,1,13],[2,1,2,13],[16,1,16,9],[14,1,14,9],[9,1,9,9],[11,2,11,9],[12,2,12,9],[13,2,13,9]]}
[]
[null,"This template may be used by NHS foundation trusts and NHS trusts to record the self-certifications that must be made under their NHS provider licence.  "]
[null,"You do not need to return your completed template to NHS Improvement unless it is requested for audit purposes."]
[]
[]
[null,null,"Self-Certification Template - Conditions G6 and CoS7"]
[null,null,{"$f":"Settings!B5","v":"Bradford District Care NHS Foundation Trust"}]
[]
[]
[null,"Foundation Trusts and NHS trusts are required to make the following self-certifications to NHS Improvement:"]
[]
[null,null,"Systems or compliance with licence conditions - in accordance with General condition 6 of the NHS provider licence"]
[null,null,"Availability of resources and accompanying statement - in accordance with Continuity of Services condition 7 of the NHS provider licence (Foundation Trusts designated CRS providers only)"]
[]
[null,"These self-certifications are set out in this template."]
[]
[null,"How to use this template"]
[null,"1) Save this file to your Local Network or Computer."]
[null,"2) Enter responses and information into the yellow data-entry cells as appropriate."]
[null,"3) Once the data has been entered, add signatures to the document."]

{"sheet":"G6 & CoS7","index":1,"n_rows":38,"n_cols":11,"rows_kept":38,"cut":false,"hidden":false,"merged":[[3,3,3,10],[20,4,20,8],[21,4,21,8],[13,4,13,8],[14,4,14,8],[17,4,17,8],[18,4,18,8],[19,4,19,8],[37,4,37,9],[34,4,34,9],[6,4,6,9],[9,4,9,8],[35,4,35,9],[10,4,10,8],[15,4,15,8],[16,4,16,8]]}
[]
[null,null,null,"Worksheet \"G6 & CoS7\""]
[]
[null,null,null,"Declarations required by General condition 6 and Continuity of Service condition 7 of the NHS provider licence"]
[]
[]
[null,null,null,null,"The board are required to respond \"Confirmed\" or \"Not confirmed\" to the following statements (please select 'not confirmed' if confirming another option).  Explanatory information should be provided where required. "]
[]
[null,null,null,"1 & 2","General condition 6 - Systems for compliance with license conditions (FTs and NHS trusts)"]
[]
["CERT","CERT36",null,1,"Following a review for the purpose of paragraph 2(b) of licence condition G6, the Directors of the Licensee are satisfied that, in the Financial Year most recently ended, the Licensee took all such precautions as were necessary in order to comply with the conditions of the licence, any requirements imposed on it under the NHS Acts and have had regard to the NHS Constitution.",null,null,null,null,"Confirmed",{"$f":"IF(J11=\"\",\"Please Respond\",IF(J11=\"Confirmed\",\"OK\",\"Please complete the explanatory information in cell E36\"))","v":"OK"}]
[]
[null,null,null,3,"Continuity of services condition 7 - Availability of Resources (FTs designated CRS only)"]
[null,null,null,null,"EITHER:"]
["CERT","CERT38",null,"3a","After making enquiries the Directors of the Licensee have a reasonable expectation that the Licensee will have the Required Resources available to it after taking account distributions which might reasonably be expected to be declared or paid for the period of 12 months referred to in this certificate.",null,null,null,null,"Confirmed",{"$f":"IF(J15=\"\",\"Please Respond\",\"Please fill details in cell E22\")","v":"Please fill details in cell E22"}]
[null,null,null,null,"OR"]
["CERT","CERT39",null,"3b","After making enquiries the Directors of the Licensee have a reasonable expectation, subject to what is explained below, that the Licensee will have the Required Resources available to it after taking into account in particular (but without limitation) any distribution which might reasonably be expected to be declared or paid for the period of 12 months referred to in this certificate. However, they would like to draw attention to the following factors (as described in the text box below) which may cast doubt on the ability of the Licensee to provide Commissioner Requested Services.",null,null,null,null,null,{"$f":"IF(J17=\"\",\"Please Respond\",\"Please fill details in cell E22\")","v":"Please Respond"}]
[null,null,null,null,"OR"]
["CERT","CERT40",null,"3c","In the opinion of the Directors of the Licensee, the Licensee will not have the Required Resources available to it for the period of 12 months referred to in this certificate.",null,null,null,null,null,{"$f":"IF(J19=\"\",\"Please Respond\",\"Please fill details in cell E22\")","v":"Please Respond"}]
[null,null,null,null,"Statement of main factors taken into account in making the above declaration"]
[null,null,null,null,"In making the above declaration, the main factors which have been taken into account by the Board of Directors are as follows:"]
[null,null,null,null,"Approval of the Operational Plan, approval of assurance reports at Board and Committee meetings throughout the year, the Trust's Annual Report and Accounts (including the Annual Governance Statement) and assessment of licence conditions (the latter discussed and approved by the Board on 24 May 2018). "]
[]
[null,null,null,null,"Signed on behalf of the board of directors, and, in the case of Foundation Trusts, having regard to the views of the governors"]
[]
[null,null,null,null,"Signature",null,null,"Signature"]
[]
["CERT","CERTSIG",null,null,"Name","Michael Smith",null,"Name","Liz Romaniak"]
[]
["CERT","CERTJOB",null,null,"Capacity","Chair",null,"Capacity","Interim Chief Executive"]
[]
["CERT","CERTDATE",null,null,"Date","2018-05-24",null,"Date","2018-05-24"]
[]
[]
[null,null,null,null,"Further explanatory information should be provided below where the Board has been unable to confirm declarations under G6."]
["CERT","ALT1",null,"A"]
[]
["CERT","ALT3",null,"C"]

{"sheet":"Lookups","index":2,"n_rows":2,"n_cols":1,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Confirmed"]
["Not confirmed"]

{"sheet":"Settings","index":3,"n_rows":28,"n_cols":2,"rows_kept":28,"cut":false,"hidden":true,"merged":[]}
["Setting","Value"]
["TemplateVersionTxt",{"$f":"IF(LEN(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(SUBSTITUTE(B19,0,\"\"),1,\"\"),2,\"\"),3,\"\"),4,\"\"),5,\"\"),6,\"\"),7,\"\"),8,\"\"),9,\"\"),\".\",\"\"))>1,\"Too many letters\",IF(ISBLANK(B19),\"Data Version missing\",IF(ISNUMBER(VALUE(RIGHT(B19,1))),B19,LEFT(B19,LEN(B19)-1))))","v":"4.18.00.1"}]
["MARSID","BRADFORDCARE"]
["NHSCode","TAD"]
["LongName","Bradford District Care NHS Foundation Trust"]
["FTStatus","FT"]
["TrustSector","Mental Health"]
["Region","Y54"]
["Templatetype","SCT"]
["Returndate","31/05/2018"]
["Year","FY2018-19"]
["Period","M01"]
["Validation"]
["GUID","5EB8F901-8DC5-43E7-8C57-E23EC496BB99"]
["Filename","SCT_D_FY2018-19_M01_TAD.xlsm"]
["SubmissionNumber",1]
["Activity","Annual Self Certification"]
["Workstream","Regulation"]
["DataTemplateVersionTxt","4.18.00.1"]
[]
[]
["Last Fixed","22-11-2016 14:32:54"]
["sysDev","Yes"]
[]
["SysTolerance",1]
[]
["SysMinTolerance",-9999999]
["SysMaxTolerance",99999999]