{"text_format":"1","workbook":"xlsx","n_sheets":13,"sheets":["Front Page","Surgical Set Definitions","InstrumentDB","Heatmap","ESG_Collated","ESG_SubmitData","HPB_Collated","HPB_SubmitData","Day Case_Collated","Day Case_SubmitData","Acutes_Collated","Acutes_SubmitData","AllSpecialties_Collated"],"not_rendered":{"charts":0,"images":5,"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":"row_number_cap","date_system":"1900"}

{"sheet":"Front Page","index":0,"n_rows":12,"n_cols":9,"rows_kept":12,"cut":false,"hidden":false,"merged":[[2,1,6,11],[9,1,9,11],[11,5,11,6],[7,1,7,11]]}
[]
[]
[null,"Surgical Tray Rationalisation: Audit tool"]
[]
[]
[]
[]
[null,"ALPHA VERSION\nPlease send feedback & bug reports to england.ccf-sustainability@nhs.net using the Subject title Surgical Tray Rationalisation: Audit tool feedback"]
[]
[null,"Use audits across a wide range of surgical procedures indicate >75% of instruments in opened sets remain unused, resulting in unnecessary sterilisation, which has both cost and environmental implications. Optimising sets to consolidate fewer items into a smaller quantity / volume of trays offers carbon, cost and operational savings, without compromising patient safety.\n\nThis tool is designed to facilitate the collection and collation of surgical instrument use audit data, providing heatmap visualisation of % usage rates across cases, accommodating collation across a range of different tray setups.\n\n1. Define Instrument Sets\n\nCreate checklists for each core specialty for a given procedure. This supports the standardisation of instrument names, so that the audit can track usage across different tray setups. These can be printed out for manual use within the surgical context.\n\n2. Submit Data\n\nUse the quick navigation below to print checklists / submit collated data per core specialty.\n\n3. View Usage Heatmap\n\nUpon completion of data submission, view the usage statistics across all cases. Raw data can be extracted if required."]
[]
[null,1,null,null,2,"Submit Data",null,null,3]

{"sheet":"Surgical Set Definitions","index":1,"n_rows":28,"n_cols":7,"rows_kept":28,"cut":false,"hidden":false,"merged":[[2,1,6,8],[12,1,12,8],[9,1,9,2],[9,4,9,5],[10,4,10,5],[10,1,10,2],[7,1,7,8]],"read":"row_number_cap"}
[]
[]
[null,"Surgical Tray Rationalisation: Create audit forms"]
[]
[]
[]
[]
[null,"ALPHA VERSION\nPlease send feedback & bug reports to england.ccf-sustainability@nhs.net using the Subject title Surgical Tray Rationalisation: Audit tool feedback"]
[]
[null,"Procedure",null,null,"Location"]
[null,"Laparoscopic Cholecystectomy",null,null,"Leeds Teaching Hospitals"]
[]
[null,"1. Define setups\nCreate a column for each distinct setup (e.g., by core specialty / sites) using the Add/Remove Setup functionality below.\n\n2. Add /remove surgical instruments \nUse the + and - buttons to the left of the Instrument column to create a list of instruments present across all setups. Tick the boxes for each setup where the item is present. This should be used as an opportunity to standardised instrument names across setups. For instruments/devices that are always used in tandem, it may be useful to define an overarching instrument name for ease of data collection e.g., Diathermy Hook & Diathermy Cable = Diathermy Hook.\n\n3. Create audit forms\nOnce all instruments & tray setups are defined, click the CREATE AUDIT FORMS button above to populate instrument lists. NOTE: THIS WILL DELETE ALL PRE-EXISTING CASE DATA IN THE FILE. If you wish to extract any raw data before resetting the file, please navigate to the Heatmap tab to the EXPORT RAW DATA button.\n\n4. Print Lists / Submit Data\nUse the Submit Data buttons above each tray setup column to take you to each instrument checklist. This should be used to capture case usage and can also be printed out to facilitate manual data capture in the correct format.\n\n5. View Heatmap\nOnce all data is collected & submitted, navigate to the Heatmap tab to view usage statistics across all cases and by core specialty."]
[]
[null,null,"Add/Remove Setup"]
[]
[null,"DELETECOL","START HERE"]
[null,"DELETEBUTTON","        Instrument","ESG","HPB","Day Case","Acutes"]
[null,false,"Mother-In-Law",true,true,true,true]
[null,false,"Forceps",true,false,true,true]
[null,false,"Knife handle 7",true,false,true,false]
[null,false,"Knife handle 9",false,true,true,true]
[null,false,"Hemolok",true,true,true,true]
[null,false,"0 deg scope",true,false,true,true]
[null,false,"30 deg scope",true,true,true,true]
[null,false,"Scalpel",true,true,false,true]
[null,false,"Grasper",true,false,false,true]
[null,false,"Scalpel 2",false,true,false,true]

{"sheet":"InstrumentDB","index":2,"n_rows":12,"n_cols":4,"rows_kept":12,"cut":false,"hidden":true,"merged":[]}
["START HERE"]
["Instrument","Parts","Tag","Row"]
["Mother-In-Law",null,null,17]
["Forceps",null,null,18]
["Knife handle 7",null,null,19]
["Knife handle 9",null,null,20]
["Hemolok",null,null,21]
["0 deg scope",null,null,22]
["30 deg scope",null,null,23]
["Scalpel"]
["Grasper"]
["Scalpel 2"]

{"sheet":"Heatmap","index":3,"n_rows":25,"n_cols":5,"rows_kept":25,"cut":false,"hidden":false,"merged":[[9,1,9,5],[1,1,6,5],[7,1,7,5]]}
[]
[null,"Surgical tray rationalisation: Usage heatmap"]
[]
[]
[]
[]
[]
[null,"ALPHA VERSION\nPlease send feedback & bug reports to england.ccf-sustainability@nhs.net using the Subject title Surgical Tray Rationalisation: Audit tool feedback"]
[]
[null,"Click CREATE HEATMAP to visualise usage statistics. Click Export Raw Data to save a file of all raw case data.\n\nMetric Definitions\n1. % Cases Present - % cases where the instrument was available in the set\n2. Absolute Usage % - % cases where the instrument was used (across all cases)\n3. Usage when present % - % cases where the instrument was used (only for cases where the instrument was available)"]
[]
[]
[]
[null,"START HERE"]
[null,"Instrument","% Cases Present","Absolute Usage %","Usage When Present %"]
[null,"Mother-In-Law",1,0.90909090909090906,0.90909090909090906]
[null,"Forceps",0.72727272727272729,0.63636363636363635,0.875]
[null,"Knife handle 7",0.45454545454545453,0.36363636363636365,0.8]
[null,"Knife handle 9",0.72727272727272729,0.72727272727272729,1]
[null,"Hemolok",1,1,1]
[null,"0 deg scope",0.72727272727272729,0.18181818181818182,0.25]
[null,"30 deg scope",1,1,1]
[null,"Scalpel",0.81818181818181823,0.72727272727272729,0.88888888888888884]
[null,"Grasper",0.54545454545454541,0.54545454545454541,1]
[null,"Scalpel 2",0.54545454545454541,0.45454545454545453,0.83333333333333337]

{"sheet":"ESG_Collated","index":4,"n_rows":5,"n_cols":10,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["ESG"]
["CaseID","Date","Mother-In-Law","Forceps","Knife handle 7","Hemolok","0 deg scope","30 deg scope","Scalpel","Grasper"]
[1,"21/08/2023",true,true,true,true,false,true,true,true]
[2,"21/08/2023",true,true,true,true,false,true,true,true]
[4,"21/08/2023",true,false,true,true,false,true,true,true]

{"sheet":"ESG_SubmitData","index":5,"n_rows":16,"n_cols":4,"rows_kept":16,"cut":false,"hidden":true,"merged":[[1,1,2,2]]}
[]
[null,"ESG Case Submission"]
[]
[null,"Specialty-->","ESG"]
[null,"CaseID-->",null,"Last submitted id: 4"]
[null,"Date-->",{"$f":"TODAY()","v":"2023-10-12"}]
[null,"Instrument","Used?"]
[null,"Select all",false]
[null,"Mother-In-Law",false]
[null,"Forceps",false]
[null,"Knife handle 7",false]
[null,"Hemolok",false]
[null,"0 deg scope",false]
[null,"30 deg scope",false]
[null,"Scalpel",false]
[null,"Grasper",false]

{"sheet":"HPB_Collated","index":6,"n_rows":5,"n_cols":8,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["HPB"]
["CaseID","Date","Mother-In-Law","Knife handle 9","Hemolok","30 deg scope","Scalpel","Scalpel 2"]
[2,"21/08/2023",true,true,true,true,true,true]
[2,"21/08/2023",false,true,true,true,true,true]
[3,"21/08/2023",true,true,true,true,false,true]

{"sheet":"HPB_SubmitData","index":7,"n_rows":14,"n_cols":4,"rows_kept":14,"cut":false,"hidden":true,"merged":[[1,1,2,2]]}
[]
[null,"HPB Case Submission"]
[]
[null,"Specialty-->","HPB"]
[null,"CaseID-->",null,"Last submitted id: 3"]
[null,"Date-->",{"$f":"TODAY()","v":"2023-10-12"}]
[null,"Instrument","Used?"]
[null,"Select all",false]
[null,"Mother-In-Law",false]
[null,"Knife handle 9",false]
[null,"Hemolok",false]
[null,"30 deg scope",false]
[null,"Scalpel",false]
[null,"Scalpel 2",false]

{"sheet":"Day Case_Collated","index":8,"n_rows":4,"n_cols":9,"rows_kept":4,"cut":false,"hidden":true,"merged":[]}
["Day Case"]
["CaseID","Date","Mother-In-Law","Forceps","Knife handle 7","Knife handle 9","Hemolok","0 deg scope","30 deg scope"]
[1,"21/08/2023",true,true,false,true,true,true,true]
[2,"21/08/2023",true,true,true,true,true,false,true]

{"sheet":"Day Case_SubmitData","index":9,"n_rows":15,"n_cols":4,"rows_kept":15,"cut":false,"hidden":true,"merged":[[1,1,2,2]]}
[]
[null,"Day Case Case Submission"]
[]
[null,"Specialty-->","Day Case"]
[null,"CaseID-->",null,"Last submitted id: 2"]
[null,"Date-->",{"$f":"TODAY()","v":"2023-10-12"}]
[null,"Instrument","Used?"]
[null,"Select all",false]
[null,"Mother-In-Law",false]
[null,"Forceps",false]
[null,"Knife handle 7",false]
[null,"Knife handle 9",false]
[null,"Hemolok",false]
[null,"0 deg scope",false]
[null,"30 deg scope",false]

{"sheet":"Acutes_Collated","index":10,"n_rows":5,"n_cols":11,"rows_kept":5,"cut":false,"hidden":true,"merged":[]}
["Acutes"]
["CaseID","Date","Mother-In-Law","Forceps","Knife handle 9","Hemolok","0 deg scope","30 deg scope","Scalpel","Grasper","Scalpel 2"]
[1,"21/08/2023",true,true,true,true,false,true,true,true,true]
[2,"21/08/2023",true,true,true,true,true,true,true,true,true]
[3,"21/08/2023",true,true,true,true,false,true,true,true,false]

{"sheet":"Acutes_SubmitData","index":11,"n_rows":17,"n_cols":4,"rows_kept":17,"cut":false,"hidden":true,"merged":[[1,1,2,2]]}
[]
[null,"Acutes Case Submission"]
[]
[null,"Specialty-->","Acutes"]
[null,"CaseID-->",null,"Last submitted id: 3"]
[null,"Date-->",{"$f":"TODAY()","v":"2023-10-12"}]
[null,"Instrument","Used?"]
[null,"Select all",false]
[null,"Mother-In-Law",false]
[null,"Forceps",false]
[null,"Knife handle 9",false]
[null,"Hemolok",false]
[null,"0 deg scope",false]
[null,"30 deg scope",false]
[null,"Scalpel",false]
[null,"Grasper",false]
[null,"Scalpel 2",false]

{"sheet":"AllSpecialties_Collated","index":12,"n_rows":16,"n_cols":29,"rows_kept":16,"cut":false,"hidden":true,"merged":[]}
["nonsense"]
["Specialty","CaseID","Date","Mother-In-Law","Forceps","Knife handle 7","Knife handle 9","Hemolok","0 deg scope","30 deg scope","Scalpel","Grasper","Scalpel 2"]
["ESG",1,"21/08/2023",1,1,1,null,1,0,1,1,1]
["ESG",2,"21/08/2023",1,1,1,null,1,0,1,1,1]
["ESG",4,"21/08/2023",1,0,1,null,1,0,1,1,1]
["HPB",2,"21/08/2023",1,null,null,1,1,null,1,1,null,1]
["HPB",2,"21/08/2023",0,null,null,1,1,null,1,1,null,1]
["HPB",3,"21/08/2023",1,null,null,1,1,null,1,0,null,1]
["Day Case",1,"21/08/2023",1,1,0,1,1,1,1]
["Day Case",2,"21/08/2023",1,1,1,1,1,0,1]
["Acutes",1,"21/08/2023",1,1,null,1,1,0,1,1,1,1]
["Acutes",2,"21/08/2023",1,1,null,1,1,1,1,1,1,1]
["Acutes",3,"21/08/2023",1,1,null,1,1,0,1,1,1,0]
[null,null,null,0.90909090909090906,0.875,0.8,1,1,0.25,1,0.88888888888888884,1,0.83333333333333337]
[null,null,null,0.90909090909090906,0.63636363636363635,0.36363636363636365,0.72727272727272729,1,0.18181818181818182,1,0.72727272727272729,0.54545454545454541,0.45454545454545453,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]
[null,null,null,1,0.72727272727272729,0.45454545454545453,0.72727272727272729,1,0.72727272727272729,1,0.81818181818181823,0.54545454545454541,0.54545454545454541,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0]