{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions for use","Audit Data","Data for Tumour Stream RV","Data Analysis","Audit Data (Example)"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"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":"Instructions for use","index":0,"n_rows":22,"n_cols":10,"rows_kept":22,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Use tool in conjunction with \"Paper variation report - instructions for generation\""]
[]
[null,"Collect data using the process in the instructions and fill in the \"Audit Data\" tab (see example data in \"Audit Data (Example)\" for guidance"]
[]
[null,"Use the below Macro to copy the appropriate patients for review to the \"Data for Tumour Stream RV\" tab"]
[]
[null,null,null,null,null,"This macro populates the worksheet with calculations appropriately and then filters for variations which meet the inclusion criteria"]
[null,null,null,null,null,null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[]
[null,"The \"Data for Tumour Stream RV\" can now be distributed for review by clinicians"]
[]
[null,"For statistical analysis of data (if desired):"]
[null,"Complete the data (patients without chemotherapy, patients audited without variation etc.) in the \"Data Analysis\" tab"]
[]
["To reset the tool for further data:"]
[null,null,null,null,null,null,null,"This process will:",null,"Delete columns A-H in \"Input Data\""]
[null,null,null,null,null,null,null,null,null,"Delete any information typed into Column L (apart from the header)"]
[null,null,null,null,null,null,null,null,null,"Delete calculations downwards of row 2"]
[]
[]
[null,"Last updated:",null,"2024-02-07"]

{"sheet":"Audit Data","index":1,"n_rows":2,"n_cols":10,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["UR/MR/MRN ","Patient name","Protocol","Doctor","Tumour Stream","Variation (Yes/No)","Variation Description","Variation comments","Exclude from discussion? (Yes/No)","For presentation to TSG"]
[null,null,null,null,null,null,null,null,null,{"$f":"IF(F2=\"Yes\",IF(I2=\"Yes\",\"No\",\"Yes\"),\"\")","v":""}]

{"sheet":"Data for Tumour Stream RV","index":2,"n_rows":1,"n_cols":10,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["UR/MR/MRN ","Patient name","Protocol","Doctor","Tumour Stream","Variation","Variation Description","Variation comments","Exclude from discussion?","For presentation to TSG"]

{"sheet":"Data Analysis","index":3,"n_rows":9,"n_cols":27,"rows_kept":9,"cut":false,"hidden":false,"merged":[]}
["To be completed:",null,null,null,null,null,null,null,null,null,null,"DO NOT EDIT - FOR MACRO USE"]
["Patients audited",0,null,null,null,null,null,null,null,null,null,"For presentation to TSG",null,"Yes",null,null,null,null,null,null,null,null,null,null,null,null,"Yes"]
["Patients with chemotherapy audited:",0,null,null,null,null,"Variation rate of patients audited:",{"$f":"B8/B2","v":{"$error":"#DIV/0!"}},null,null,null,"Yes",null,"No",null,null,null,null,null,null,null,null,null,null,null,null,"No"]
["Time taken to complete audit:",0,"minutes",null,null,null,"Variation rate of patients with chemotherapy: ",{"$f":"B8/B3","v":{"$error":"#DIV/0!"}}]
[]
[null,null,null,null,null,null,"Time per patient audited ",{"$f":"B4/B2","v":{"$error":"#DIV/0!"}},"minutes"]
["Automatic statistics:"]
["Patients with variations:",{"$f":"COUNTIF('Audit Data'!F:F,\"Yes\")","v":0}]
["Patients with variations for discussion:",{"$f":"COUNTIF('Audit Data'!J:J,\"Yes\")","v":0}]

{"sheet":"Audit Data (Example)","index":4,"n_rows":3,"n_cols":10,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["UR/MR/MRN ","Patient name","Protocol","Doctor","Tumour Stream","Variation","Variation Description","Variation comments","Exclusion?","For presentation to TSG"]
[123,"(wouldn't fill in as not going to meeting and can track with UR)","ABVD","AG","Lymphoma","Yes","Bleo excluded","Evidence based - lung","Yes","(This column is filled out by the macro)"]
[789,"Good, John","BR","JA","Lymphoma","Yes","Benda reduced 50%","?","No"]