{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Input","Instructions for use","Data for Analysis","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":"Data Input","index":0,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}

{"sheet":"Instructions for use","index":1,"n_rows":60,"n_cols":46,"rows_kept":60,"cut":false,"hidden":false,"merged":[]}
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"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,"Reason Unfilled",null,null,"Cycle 1 "]
["Instructions and parameters:",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUMPRODUCT(COUNTIF(AG2,\"*\"&EXCLUSION&\"*\"))>0,\"EXCLUDED\",\"\")","v":""},{"$f":"IF(SUMPRODUCT(COUNTIF(AG2,{\"*Cycle 1 *\";\"*C1 *\";\"*C1D*\"}))>0,\"CYCLE 1\",\"\")","v":""},{"$f":"IF(AI2=\"\",IF('Instructions for use'!$D$5='Instructions for use'!$AT$1,IF(AJ2=\"CYCLE 1\",\"YES\",\"\"),\"YES\"),\"\")","v":""},null,{"$f":"IF(AK2=\"YES\",IF(COUNTA(AL2)=0,\"YES\",\"\"),\"\")","v":""},null,null,null,{"$f":"IF(SUMPRODUCT(COUNTIF(AP2,{\"ason:\";\"rks: \";\"ote: \";\"ange:\"}))>0,\"Yes\",\"\")","v":""},null,null,"All Cycles"]
[]
["Parameters"]
["Cycle 1 or all cycles?",null,null,"Cycle 1 "]
[]
["Copy entire contents of CHARM Variation report into Worksheet named Data Input"]
[]
[null,null,null,null,null,null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[]
[]
[]
["In the \"Data for Analysis\" tab, 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)"]
[]
["To enter/refresh the data in the \"Data for Tumour Stream RV\" sheet for easy export and/or anlysis by the group, please click the following button and a macro will automatically filter for you:"]
[]
[]
[]
[]
[]
["To reset the tool for further data:"]
[]
[null,null,null,null,null,null,"This process will delete everything in the \"Data Input\", \"Data for Analysis\" and \"Data for Tumour Stream RV\" worksheets"]
[]
[]
[]
["To add extra terms for exclusion"]
[null,"Replace one 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,"(Do NOT touch the \"Palonosetron\" entry in Row 4!)"]
[]
["Process Explanation:"]
[]
["Analyse Data and Formula Extension"]
["To put data into the tool:"]
["Copy and paste data from CHARM Variation Report into \"Data Input\" "]
[null,"Do this by selecting all the data in the output report from CHARM and copy it over to the \"Data Input\" worksheet"]
[]
["Run the \"Analyse Data and Formula Extension\" macro"]
[null,"This will transfer the data to the \"Data for Analysis\" worksheet and automatically filter for variations requiring assessment "]
[]
["In the \"Data for Analysis\" tab, 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)"]
[]
[]
["The \"Filter Data for Tumour Stream Review\" macro populates the \"Data for Tumour Stream RV\" worksheet with calculations appropriately and then filters for variations which meet the inclusion criteria"]
[null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[]
["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)"]
[]
["Run the \"Filter Data for Tumour Stream Review\" macro"]
[null,"This will transfer all of the variations still flagged for review to the \"Data for Tumour Stream RV\"\" worksheet for ease of copying/access (removes the excess data to make it clear cut)"]
[]
[null,"Please note this filtering process is not dynamic (i.e. if you change anything on the \"Data for Analysis\" tab, you will need to rerun this process to refill the \"Data for Tumour Stream RV\" sheet)"]
["\"Data in Tumour Stream RV\" can now be disseminated or copied to another file and disseminated"]
[]
[]
[null,"Worksheet updated",null,"2019-11-18","v1.1"]
[null,null,"Changes","Added Data Input worksheet to make the process of entering data less fiddly"]
[null,null,null,"Streamlined \"Instructions for use\" Worksheet"]
[null,null,null,"Added toggle for Cycle 1/All Cycles to \"Instructions for Use\" page rather than have different spreadsheets"]

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

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

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