{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Revision History","Cover","QMCO","Notes","Backsheet"],"not_rendered":{"charts":0,"images":1,"macros":1,"external_links":0,"defined_names":6,"comments":1,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Revision History","index":0,"n_rows":18,"n_cols":9,"rows_kept":18,"cut":false,"hidden":true,"merged":[]}
[]
[null,"Revision History "]
[null,null,"QMCO "]
[null,"Version","Date","Change ",null,null,null,null,"Notes"]
[null,0.1,"2017-08-16","Rebranding "]
[null,0.2,"2017-09-11","Re-formatting",null,null,null,null,"PROFORMA CHECKED WITH PAUL STEELE"]
[null,0.3,"2017-11-21","Spacing changes",null,null,null,null,"MAIN CONTACT IS NOW CHRIS EVISON"]
[null,0.4,"2017-11-22","Moved and edited validations so they are visible to the user and all in one column"]
[null,0.5,"2017-11-24","Contact email added"]
[null,0.6,"2017-12-15","Protected workbook and sheets"]
[null,0.7,"2017-12-18","Edit to formula - BMH"]
[null,0.8,"2017-12-20","updated backsheet",null,null,null,null,"to work with automation tool"]
[null,0.9,"2018-01-02","Format updates - FB"]
[null,1,"2018-09-28","backsheet validation added - NP"]
[null,2,"2019-10-10","Updated VBA password (DM-4718) - CR. Added Jira ticket number - 09/12/2019 RL"]
[null,2.1,"2020-01-27","Removed 1000 limit on q3 - CR"]
[null,null,"2020-01-28","Upversioned for next quarter - CR"]
[null,3,"07/20/2020","Removed upper limit of 100 on operating theatres. Added useful datavalidation messages."]

{"sheet":"Cover","index":1,"n_rows":22,"n_cols":11,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null,"For any technical queries relating to the collection please contact:",null,null,null,null,null,null,null,null,"england.nhsdata@nhs.net"]
[]
[null,"For any queries relating to the submission process please contact:",null,null,null,null,null,null,null,null,"data.collections@nhs.net"]

{"sheet":"QMCO","index":2,"n_rows":13,"n_cols":7,"rows_kept":13,"cut":false,"hidden":false,"merged":[[1,1,1,4],[5,3,5,4],[9,1,9,2],[9,3,9,4],[10,1,10,2],[10,3,10,4],[4,1,4,2],[4,3,4,4],[5,1,5,2]]}
[]
[null,"Cancelled Operations - QMCO"]
[]
[null,"Number of Operating Theatres "]
[null,"Q1) Total number of operating theatres",null,"Q2) OF WHICH: number of dedicated day case theatres",null,{"$f":"IF(ISBLANK(B6),\"Please complete Q1\",\"\")","v":"Please complete Q1"}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D6),\"Please complete Q2\",\"\")","v":"Please complete Q2"}]
[]
[]
[null,"Cancelled Operations for Non Clinical Reasons and Breaches of Standard"]
[null,"Q3) Number of last minute cancellations in the quarter",null,"Q4) Breaches of standard",null,{"$f":"IF(ISBLANK(B11), \"Please complete Q3\", \"\")","v":"Please complete Q3"}]
[null,null,null,null,null,{"$f":"IF(ISBLANK(D11), \"Please complete Q4\", \"\")","v":"Please complete Q4"}]
[]
[null,null,null,null,null,{"$f":"IF(COUNTIF(Backsheet!A2:D2,#REF!)>0,G13,\"\")","v":""},"Please do not cut and paste"]

{"sheet":"Notes","index":3,"n_rows":6,"n_cols":7,"rows_kept":6,"cut":false,"hidden":true,"merged":[]}
[]
[]
[]
[]
[]
[null,"Location of Validation","Formula Used","Description of Validation","Warning or Error","SDCS ","Notes"]

{"sheet":"Backsheet","index":4,"n_rows":2,"n_cols":4,"rows_kept":2,"cut":false,"hidden":true,"merged":[]}
["Total theatres:N","Day Case Theatres:N","Cancelled Operations:N","Breaches Of Standard:N"]
[{"$f":"QMCO!B6","v":0},{"$f":"QMCO!D6","v":0},{"$f":"QMCO!B11","v":0},{"$f":"QMCO!D11","v":0}]