{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["SaN-CoT version 1.1","SaN-CoT 1.1 selected cols","Data Validation","Macro instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"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":"SaN-CoT version 1.1","index":0,"n_rows":5,"n_cols":16,"rows_kept":5,"cut":false,"hidden":false,"merged":[]}
["Study_ID","0.1 No of problems","0.2 Problem number (chronological that appear in notes)","0.3 Problem ICPC-2 Code","1.0 Safety-netting advice text","1.1 Problem or treatment safety-netting advice","2.1 Format\nWhat is the format of the of safety-netting advice?","3.1 Number of conditions / symptoms in safety-netting advice","3.2 Free text conditions / symptoms (1)","3.2 Free text conditions / symptoms (2)","3.2 Free text conditions / symptoms (3) +","3.3 Generic or specific conditions\nDo the conditionals meet the criteria for being classified as generic or specific?","4.1 Action advised\nWhat action is advised by the HCP if the conditionals of the safety-netting advice are met?","4.2 Timescale of action\nWhat is the timescale of the action advised?","5.1 Communication \nIs there evidence the patient was given written safety netting advice","Comments"]
[1,1,1,"R81 Pneumonia","review inb 2w","1 = Problem","1 = Conditional + Course of Action",1,"inb",null,null,"1 = Specific","2 = Return to / contact GP practice","1 = Named Day / fixed time period","0 = no evidence written SNA"]
[2,1,1,"K86 Hypertension uncomplicated","will let me know if gets ankle swelling on amlodipine","2 = Treatment / Management Plan","1 = Conditional + Course of Action",1,"ankle swelling",null,null,"1 = Specific","2 = Return to / contact GP practice","0 = Not specified","0 = no evidence written SNA"]
[3,1,1,"R74 Upper respiratory infection acute","Given patient leaflet on acute coughs",null,null,null,null,null,null,null,null,null,"2 = generic PIL / unclear"]
[4,1,1,"S84 Impetigo","see prn","3 = Both (often if vague but can be mixed specific)","1 = Conditional + Course of Action",1,"prn",null,null,"0 = Generic","2 = Return to / contact GP practice","0 = Not specified","0 = no evidence written SNA"]

{"sheet":"SaN-CoT 1.1 selected cols","index":1,"n_rows":1,"n_cols":17,"rows_kept":1,"cut":false,"hidden":false,"merged":[]}
["Study_ID","0.1 No of problems","0.2 Problem number (chronological that appear in notes)","0.3 Problem ICPC-2 Code","1.0 Safety-netting advice text","1.1 Problem or treatment safety-netting advice","2.1 Format\nWhat is the format of the of safety-netting advice?","3.1 Number of conditions / symptoms in safety-netting advice","3.2 Free text conditions / symptoms (1)","3.2 Free text conditions / symptoms (2)","3.2 Free text conditions / symptoms (3)","3.2 Free text conditions / symptoms (4)","3.3 Generic or specific conditions\nDo the conditionals meet the criteria for being classified as generic or specific?","4.1 Action advised\nWhat action is advised by the HCP if the conditionals of the safety-netting advice are met?","4.2 Timescale of action\nWhat is the timescale of the action advised?","5.1 Communication \nIs there evidence the patient was given written safety netting advice","Comments"]

{"sheet":"Data Validation","index":2,"n_rows":8,"n_cols":24,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["1.1 Diagnostic uncertainty\nIs the existence of any uncertainty around the diagnosis communicated?","1.2 Time course of illness\n Is the expected time course / time to recovery of the condition discussed?","2.1 Follow-up\nIs there evidence in this consultation that there is follow-up arranged for this problem?","2.2 Follow-up documentation\nAre the follow-up plans documented in the medical records?","Optional 1.1 – Acute or Chronic Problem\nIs the problem acute, acute on chronic, or chronic?","Optional 1.2 - First Presentation\nIs this the first presentation to a Healthcare Professional (HCP) with diagnostic capability  with this problem?","Optional 2.1 – Diagnosis given","Optional 2.2 – Diagnosis or\nknown diagnosis free text\n(copy and paste from transcript or if known from medical notes / transcript)","Optional 3 – Other continent management plan?\nIs another continent management plan offered that is not  safety-netting advice?","3.1 Number of times safety-netting advice given","3.2 Safety-netting number\nChronological order (e.g. 1 of 2)","3.4 Single or multiple problems\nDoes the safety-netting advice apply to one problem or multiple problems?","3.5 Problem or treatment safety-netting advice\nDoes safety-netting apply to the problem or a treatment management plan for the problem?","5.1 Format\nWhat is the format of the of safety-netting advice?","6.1 Number of conditions / symptoms in safety-netting advice\nHow many conditions / symptoms are communicated in the safety-netting advice?","6.2 Free text conditions / symptoms ","6.3 Generic or specific conditions\nDo the conditionals meet the criteria for being classified as generic or specific?","7.1 Action advised\nWhat action is advised by the HCP if the conditionals of the safety-netting advice are met?","7.2 Focus of the action advised\nIs action advised patient focussed, clinician focussed or both?","7.3 Timescale of action\nWhat is the timescale of the action advised?","8.1 Patient response\nHow does the patient immediately respond AT THE END of the delivery of the safety-netting advice?","8.2 Questions\nDoes the patient ask any questions about the safety-netting advice?","9.1 Communication \nIs the patient given written safety-netting advice?","10.1 Safety-netting advice documentation. Is the safety-netting advice documented in the medical notes"]
["0 = No (diagnostic uncertainty)","0 = No (time-course)","0 = None (FU)","0 = No FU documentation","1 = Acute","0 = No (not first presentation to HCP)","0 = No diagnosis given",null,"0 = No other contingent management plan",null,null,"1 = This problem only ","1 = Problem","0 = Conditional Only ",null,null,"0 = Generic","0 = No action advised","1 = Clinician","0 = Not specified","0 = No response","0 = no questions asked about SN advice","0 = no evidence written SNA","0 = No documentation of SNA"]
["1 = Yes (diagnostic uncertainty)","1 = Yes (time-course)","1 = Investigation only","1 = Documentation of FU present","2 = Acute on Chronic","1 = Yes (not first presentation to HCP)","1 = Known Diagnosis",null,"1 = Delayed script",null,null,"2 = Multiple Problems","2 = Treatment / Management Plan","1 = Conditional + Course of Action",null,null,"1 = Specific","1 = Other IN HOURS HCP (not based at practice e.g. pharmacist, counsellor, in hours secondary care clinics)","2 = Patient","1 = Named Day / fixed time period","1 = Resists, aligns / misaligning","1 = patient asks a question about SN advice","1 = evidence written SNA","1 = Documentation of SNA present"]
["99 = N/A = e.g. contraception","99 = N/A = e.g. contraception","2 = Practice FU","88 = CBD as NO RECORDS","3 = Chronic","88 = unclear","2 = Yes diagnosis given",null,"2 = Contingent self care",null,null,null,"3 = Both (often if vague but can be mixed specific)",null,null,null,null,"2 = Return to / contact GP practice","3 = Both Clinician & Patient","2 = Immediate / Urgent","2 = Nods Only",null,"2 = generic PIL / unclear","88 = CBD as NO RECORDS"]
[null,null,"3 = Same GP FU","99 = N/A as no follow up",null,null,"99 = N/A = e.g. contraception",null,"3 = Contingent on investigation result",null,null,null,null,null,null,null,null,"3 = Contact OOH / NHS 111","99 = N/A - no action component",null,"3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)"]
[null,null,"4 = Other",null,null,null,null,null,"4 = Changes mind about treatment already offered",null,null,null,null,null,null,null,null,"4 = Contact emergency services e.g. 999",null,null,"88 = CBD as no response and audio only"]
[null,null,"5 = Multiple",null,null,null,null,null,"5 = Contingent Admin / Other"]
[null,null,null,null,null,null,null,null,"6 = Multiple Contingent Plans"]

{"sheet":"Macro instructions","index":3,"n_rows":12,"n_cols":1,"rows_kept":12,"cut":false,"hidden":false,"merged":[]}
["How to use the macro for Stata processing"]
["1. Save a backup copy of the excel file before you run the macro"]
["2. Right click on spreadsheet tab and click on 'Move or Copy'"]
["3. Create a copy of the spreadsheet and call it 'macro'"]
["4. On the new macro spreadsheet click on 'View' then 'Macros' then 'View Macros'"]
["5. Run the convert_to_pure_numbers macro"]
["6. Delete the second row with the tracker and third row with text titles in the macro tab"]
["7. Import the spreadsheet to Stata and most columns should be in black font (numerical data) not red font (string data)"]
["Please note once you have processed the macro you cannot undo the changes that is why it is important to save a backup file and run the macro on a copy of spreadsheet"]
[]
[]
["Note you can just not use the macro and direct important to stata and use encode command "]