{"text_format":"1","workbook":"xlsx","n_sheets":6,"sheets":["Data Input","Instructions for use","Data for Analysis","Data Analysis","Excluded terms","Data for Tumour Stream Review"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":3,"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":65,"n_cols":59,"rows_kept":65,"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,null,null,null,null,"Regimen Name\t ","Version","Summary & Desc","Adm Start","UR","Patient Name","Ordered By","Dose Calc","Detail Rx Regimen","Version","CT","Agent","Agent Class","Status","Prev Dose","Dose pct","Dose","Reason","Intent","Line","Cycle","Day","Cycle 1 ","Significant Variations","Excluded medication","Analyse?","Manual Exclude","For discussion","DC/Error"]
["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,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(AND('Instructions for use'!$D$6=\"Cycle1\",AY2=1),\"Include\",\"\")","v":""},{"$f":"IF(OR(AT2<(100-'Instructions for use'!$D$5),AT2>(100+'Instructions for use'!$D$5)),\"Significant\",\"\")","v":"Significant"},{"$f":"IF(SUMPRODUCT(COUNTIF(AP2,\"*\"&EXCLUSION&\"*\"))>0,\"EXCLUDED\",\"\")","v":""},{"$f":"IF('Instructions for use'!$D$6=\"Cycle1\",IF(AND(BA2=\"Include\",BB2=\"Significant\",BC2=\"\"),\"Include\",\"\"),IF(AND(BB2=\"Significant\",BC2=\"\"),\"Include\",\"\"))","v":""},null,{"$f":"IF(AND(BD2=\"Include\",COUNTA(BE2)=0),\"Include\",\"\")","v":""},{"$f":"IF(OR(AR2=\"Discontinued\",AR2=\"Errored\"),\"DC/Error\",\"\")","v":""}]
[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,"Cycle1",null,null,null,{"$f":"CHAR(CODE(RIGHT(LEFT(ADDRESS(1,MATCH(\"Day\",'Data Input'!1:1,0)),2),1))+1)","v":{"$error":"#N/A"}}]
["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,"All cycles"]
[null,"Variation threshold",null,10,"(as a percentage)"]
[null,"Cycle",null,"Cycle1"]
[]
["Copy entire contents of ARIA 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)"]
[]
[null,"Evaluate each entry and type anything (E.g. \"Y\") into the manually excluded column (AA) if the entry should be excluded from going to the Tumour Stream Review (e.g. if the variation was clinically insignificant or evidence based)"]
[]
[]
[]
[]
[]
[]
[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 (e.g. supportive care agents that aren't "]
[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 ARIA Variation Report into \"Data Input\" worksheet"]
[null,"Do this by selecting all the data in the output report from the ARIA created CSV file and copy it over to the \"Data Input\" worksheet"]
[]
["Run \"Process Data ready for manual evaluation\" macro"]
[null,"This macro populates the \"Data for Analysis \" worksheet with  data and calculations and then filters for variations which meet the automatic inclusion criteria"]
[null,null,"You may need to enable macros (typically a bar just underneath the formula bar)"]
[null,null,"If you change parameters, you will need to re-run this macro (will filter for appropriate results) automatically"]
[]
["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)"]
[]
[]
["Once variations have been manually evaluated for inclusion, run the below macro to generate the \"Data for Tumour Stream Review\" tab ready for dissemination for discussion"]
["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"]
[]
[]
["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,"2024-02-07"]
[null,null,"Changes","Version 2.0 published"]
[]
[null,"Contact: shaun.oconnor@health.vic.gov.au for assistance if required"]

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

{"sheet":"Data Analysis","index":3,"n_rows":8,"n_cols":12,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Total Entries",{"$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,"For discussion"]
[null,"Excluded drugs",{"$f":"COUNTIF('Data for Analysis'!Y:Y,\"EXCLUDED\")","v":0},null,null,"% cycle 1 variations",{"$f":"C4/C2","v":1},{"$f":"C4","v":-1},{"$f":"C2","v":-1},null,null,"Include"]
[null,"Cycle 1 Exclusions",{"$f":"C2-COUNTIF('Data for Analysis'!W:W,\"Include\")","v":-1},null,null,"% Tool detected eligible variations",{"$f":"C6/C2","v":0},{"$f":"C6","v":0},{"$f":"C2","v":-1}]
[null,"Significant variations",{"$f":"COUNTIF('Data for Analysis'!X:X,\"Significant\")","v":0},null,null,"% manually removed variations (of detected)",{"$f":"C7/C6","v":{"$error":"#DIV/0!"}},{"$f":"C7","v":-1},{"$f":"C6","v":0}]
[null,"Eligible for manual review",{"$f":"COUNTIF('Data for Analysis'!Z:Z,\"Include\")","v":0},null,null,"% sent variations compared to reported",{"$f":"C8/C2","v":-1},{"$f":"C8","v":1},{"$f":"C2","v":-1}]
[null,"Manually Excluded",{"$f":"COUNTA('Data for Analysis'!AA:AA)-1","v":-1}]
[null,"Reviewed for sending to Tumour Stream Meeting",{"$f":"C6-C7","v":1}]

{"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"]
["Vitamin"]
["Zoledronic"]
["Immunoglobulin"]
["Citrate"]
["Heparin"]
["Minocycline"]
["Palonosetron"]
["Allopurinol"]
["Atropine"]
["Colecalciferol"]
["Glucose 5%"]
["Degarelix"]
["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 for Tumour Stream Review","index":5,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":false,"merged":[]}