{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["Instructions for use","Input data","Data for Tumour Stream RV","Excluded terms","Data Analysis"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":4,"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":32,"n_cols":10,"rows_kept":32,"cut":false,"hidden":false,"merged":[]}
["To put data into the tool:"]
[null,"Copy and paste data from CHARM Variation Report into \"Input Data Sheet\" "]
[null,null,"Do this by selecting the columns A-H in the output report from CHARM and copy them over columns A-H in the Input Data Sheet in this file"]
[null,"Ensure the equations in columns I-M copy down to the end of the data entered "]
[]
[null,"Run this macro"]
[null,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,null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[]
[null,"Evaluate each entry and type anything (E.g. \"Y\") into the manually excluded column (L) if the entry should be excluded from going to the Tumour Stream Review (e.g. if the variation was a small rounding  and does not need tumour stream review)"]
[]
[null,"To enter/refresh the data in the \"Data for Tumour Stream RV\" sheet, please click the following button and a macro will automatically filter for you:"]
[null,null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[]
[]
[]
[null,null,"Please note this filtering process is not dynamic (i.e. if you change anything on the \"Input data\" tab, you will need to rerun this process to refill the \"Data for Tumour Stream RV\" sheet)"]
[null,"\"Data in Tumour Stream RV\" can now be disseminated or copied to another file and disseminated"]
[]
["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"]
[]
[]
["To add extra terms for exclusion"]
[null,"Replace on of the terms in the \"Excluded terms\" sheet that say Palonosetron"]
[null,null,"Do not leave an empty slot - if you want to remove one, type Palonosetron into the slot, otherwise the tool will exclude every entry (since they all contain \"\")"]
[null,null,null,"(Do NOT touch the \"Palonosetron\" entry in Row 4!)"]
[]
[]
[null,"Last updated:",null,"2019-07-02"]

{"sheet":"Input data","index":1,"n_rows":2,"n_cols":20,"rows_kept":2,"cut":false,"hidden":false,"merged":[]}
["DateModified","MRNumber","FamilyName","FirstName","Disease","PathwayName","PathwayHistoryNote","ModifiedBy","Excluded - Supportive agents","Cycle 1 selector","Eligible for Manual Review","Manually Excluded","For Tumour Stream Group Review",null,null,null,null,null,null,"Reason Unfilled"]
[null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(COUNTIF(G2,\"*\"&EXCLUSION&\"*\"))>0,\"EXCLUDED\",\"\")","v":""},{"$f":"IF(SUMPRODUCT(COUNTIF(G2,{\"*Cycle 1 *\";\"*C1 *\";\"*C1D*\"}))>0,\"CYCLE 1\",\"\")","v":""},{"$f":"IF(I2=\"\",\"YES\",\"\")","v":"YES"},null,{"$f":"IF(K2=\"YES\",IF(COUNTA(L2)=0,\"YES\",\"\"),\"\")","v":"YES"},null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(COUNTIF(S2,{\"ason:\";\"rks: \";\"ote: \";\"ange:\"}))>0,\"Yes\",\"\")","v":""}]

{"sheet":"Data for Tumour Stream RV","index":2,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Excluded terms","index":3,"n_rows":100,"n_cols":1,"rows_kept":100,"cut":false,"hidden":false,"merged":[]}
[]
["Supportive medications for exclusion"]
[]
["Palonosetron"]
["Tropisetron"]
["Granisetron"]
["Ondansetron"]
["G-CSF"]
["GCSF"]
["Filgrastim"]
["Pegfilgrastim"]
["Aprepitant"]
["Netupitant"]
["Metoclopramide"]
["Allopurinol"]
["Prochlorperazine"]
["Paracetamol"]
["Hydrocortisone"]
["Loratadine"]
["Oxycodone"]
["Adrenaline"]
["Epinephrine"]
["Haloperidol"]
["Atropine"]
["Lorazepam"]
["Promethazine"]
["Ranitidine"]
["Cetirizine"]
["Domperidone"]
["Fosaprepitant"]
["Cyclizine"]
["Lipegfilgrastim"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]
["Palonosetron"]

{"sheet":"Data Analysis","index":4,"n_rows":7,"n_cols":12,"rows_kept":7,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Total Variations in the report",{"$f":"COUNTA('Input data'!A:A)-1","v":0},null,null,"% variations excluded for supportive care",{"$f":"C3/C2","v":{"$error":"#DIV/0!"}},{"$f":"C3","v":0},{"$f":"C2","v":0},null,null,"For Tumour Stream Group Review"]
[null,"Excluded drugs",{"$f":"COUNTIF('Input data'!I:I,\"EXCLUDED\")","v":0},null,null,"% cycle 1 variations",{"$f":"C4/C2","v":{"$error":"#DIV/0!"}},{"$f":"C4","v":0},{"$f":"C2","v":0},null,null,"YES"]
[null,"Cycle 1",{"$f":"COUNTIF('Input data'!J:J,\"CYCLE 1\")","v":0},null,null,"% Tool detected eligible variations",{"$f":"C5/C2","v":{"$error":"#DIV/0!"}},{"$f":"C5","v":1},{"$f":"C2","v":0}]
[null,"Pilot-eligible",{"$f":"COUNTIF('Input data'!K:K,\"YES\")","v":1},null,null,"% manually removed variations (of detected)",{"$f":"C6/C5","v":0},{"$f":"C6","v":0},{"$f":"C5","v":1}]
[null,"Manually Excluded",{"$f":"COUNTA('Input data'!L:L)-1","v":0},null,null,"% sent variations compared to reported",{"$f":"C7/C2","v":{"$error":"#DIV/0!"}},{"$f":"C7","v":1},{"$f":"C2","v":0}]
[null,"Reviewed for sending to Tumour Stream Meeting",{"$f":"C5-C6","v":1}]