{"text_format":"1","workbook":"xlsx","n_sheets":4,"sheets":["Example dataset","Example dataset with optional","Data Validation","Macro instructions"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":2,"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":"Example dataset","index":0,"n_rows":10,"n_cols":30,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,6,7,6],[6,7,7,7],[6,8,7,8],[6,9,7,9],[6,10,7,10],[1,26,1,27],[1,12,1,15],[8,28,9,28],[8,29,9,29],[8,9,9,9],[8,10,9,10],[8,11,9,11],[6,28,7,28],[6,29,7,29],[6,27,7,27],[8,27,9,27],[6,11,7,11],[3,0,4,0],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,4,7,4],[6,5,7,5],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,4,9,4],[8,5,9,5],[8,6,9,6],[8,7,9,7],[8,8,9,8],[1,20,1,22],[1,23,1,25],[1,0,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[1,16,1,17],[1,18,1,19]]}
["record_id","S0_4","S3_1","S3_3_text","S0_1","S0_2","S0_3_text","S0_3_icpc","S1_1","S1_2","S2_1","S2_2","S3_1","S3_2","S3_4","S3_5","S4_1","S4_2","S5_1","S5_2","S6_1","S6_2_text","S6_3_text","S7_1","S7_2","S7_3","S8_1","S8_2","S9_1","S10_1"]
["Tracker",null,null,null,"Administrative Codes",null,null,null,"Contextual Codes",null,"Contextual Codes",null,"Safety-netting advice codes",null,null,null,"Safety-netting advice codes",null,"Safety-netting advice codes",null,"Safety-netting advice codes",null,null,"Safety-netting advice codes",null,null,"Safety-netting advice codes",null,"Safety-netting advice codes","Safety-netting advice codes"]
["Study ID","0.4 Problem ICPC-Code","3.1 Number of times safety-netting advice given","3.3 Line number and text of safety-netting advice present in the transcript","0.1 Number of problems","0.2 Problem number (chronological)","0.3 Presenting Complaint text","0.3 Presenting Complaint ICPC","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?","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 advice apply to the problem or a treatment / management plan for the problem?","4.1 Stage of consultation\nWhat stage of the consultation is the safety-netting advice deliver during?","4.2 Initiation by\nWho initiates the safety-netting advice?","5.1 Format\nWhat is the format of the of safety-netting advice?","5.2 Strength of endorsement\nWhat is the strength of the endorsement of the 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"]
[1,"K96 Haemorrhoids",1,"87: if the bleeding persists you must come back",2,1,"I've been noticing some blood mixed in with my poo","D16 Rectal bleeding","1 = Yes (diagnostic uncertainty)","0 = No (time-course)","3 = Same GP FU","1 = Documentation of FU present",1,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","2 = Stronger (must, should, need to, this is important)",1,"bleeding persists","0 = Generic","2 = Return to / contact practice","2 = Patient","0 = Not specified","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","1 = Verbal only","0 = No documentation of SNA"]
[null,"K77 Heart failure\n",1,"113: If the tablets make your ankles swell up, you could just stop taking them and let me know because we could try a different one",2,2,"Can we also do my annual heart failure review?","K77 Heart failure","0 = No (diagnostic uncertainty)","0 = No (time-course)","2 = Practice FU","0 = No FU documentation",1,1,"1 = This problem only ","2 = Treatment / Management Plan","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","0 = Weaker (can, could)",1,"ankles swell up","1 = Specific","3 = Return to same HCP","3 = Both Clinician & Patient","0 = Not specified","2 = Nods Only","0 = no questions asked about SN advice","1 = Verbal only","0 = No documentation of SNA"]
[2,"N89 Migraine",0,"-",1,1,"My headaches have been getting really bad recently","N01 Headache","1 = Yes (diagnostic uncertainty)","0 = No (time-course)","3 = Same GP FU","88 = CBD as NO RECORDS",0,0]
[3,"F70 Conjunctivitis infectious",2,"111: As long as your vision doesn't suddenly change then I don't think there is anything to worry about.",1,1,"I woke up and both my eyes were really red","F02 Red eye","1 = Yes (diagnostic uncertainty)","1 = Yes (time-course)","0 = None (FU)","99 = N/A as no follow up",2,2,"1 = This problem only ","1 = Problem","3 = Delivering Diagnoses","1 = Clinician","0 = Conditional Only ","0 = Weaker (can, could)",1,"vision doesn't suddenly change","1 = Specific","0 = No action advised","99 = N/A - no action component","0 = Not specified","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","1 = Verbal only","1 = Documentation of SNA present"]
[null,null,null,"140: This should settle down in the next few days, but if it doesn't then come back and I'll have another a look at it",null,null,null,null,null,null,null,null,2,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","1 = Neutral",1,"doesn’t (settle down in next few days)","1 = Specific","3 = Return to same HCP","3 = Both Clinician & Patient","1 = Named Day / fixed time period","0 = No response"]
[4,"K74 Ischaemic heart disease w. angina",2,"105: Look it says here that if the chest pain lasts more than 5 minutes you must ring 999 straight away",1,1,"I've been having some tightness in my chest when walking up hills","K02 Pressure/tightness of heart","1 = Yes (diagnostic uncertainty)","1 = Yes (time-course)","5 = Multiple","1 = Documentation of FU present",2,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","2 = Stronger (must, should, need to, this is important)",1,"chest pain lass more than 5 minutes","1 = Specific","5 = Contact emergency services e.g. 999","2 = Patient","2 = Immediate / Urgent","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","2 = Verbal and written","1 = Documentation of SNA present"]
[null,null,null,"150: Any other problems or concerns let me know",null,null,null,null,null,null,null,null,2,2,"1 = This problem only ","3 = Both (often if vague but can be mixed specific)","5 = Closing","1 = Clinician","1 = Conditional + Course of Action","1 = Neutral",2,"other problems; concerns","0 = Generic","3 = Return to same HCP","2 = Patient","0 = Not specified","0 = No response"]

{"sheet":"Example dataset with optional","index":1,"n_rows":10,"n_cols":35,"rows_kept":10,"cut":false,"hidden":false,"merged":[[6,13,7,13],[6,34,7,34],[6,8,7,8],[6,9,7,9],[6,10,7,10],[6,11,7,11],[6,33,7,33],[6,14,7,14],[6,15,7,15],[6,16,7,16],[6,32,7,32],[6,5,7,5],[6,6,7,6],[6,7,7,7],[8,34,9,34],[8,11,9,11],[8,12,9,12],[8,14,9,14],[8,15,9,15],[8,16,9,16],[8,33,9,33],[8,13,9,13],[8,32,9,32],[8,8,9,8],[8,9,9,9],[8,10,9,10],[6,12,7,12],[1,0,1,3],[1,4,1,7],[1,8,1,9],[1,10,1,11],[8,5,9,5],[8,6,9,6],[8,7,9,7],[3,0,4,0],[8,0,9,0],[8,1,9,1],[8,2,9,2],[8,4,9,4],[6,0,7,0],[6,1,7,1],[6,2,7,2],[6,4,7,4],[1,31,1,32],[1,12,1,16],[1,17,1,20],[1,25,1,27],[1,28,1,30],[1,21,1,22],[1,23,1,24]]}
["record_id","S0_4","S3_1","S3_3_text","S0_1","S0_2","S0_3_text","S0_3_icpc","S1_1","S1_2","S2_1","S2_2","optional_1_1","optional_1_2","optional_2_1","optional_2_2","optional_3","S3_1","S3_2","S3_4","S3_5","S4_1","S4_2","S5_1","S5_2","S6_1","S6_2_text","S6_3_text","S7_1","S7_2","S7_3","S8_1","S8_2","S9_1","S10_1"]
["Tracker",null,null,null,"Administrative Codes",null,null,null,"Contextual Codes",null,"Contextual Codes",null,"OPTIONAL Contextual Codes",null,null,null,null,"Safety-netting advice codes",null,null,null,"Safety-netting advice codes",null,"Safety-netting advice codes",null,"Safety-netting advice codes",null,null,"Safety-netting advice codes",null,null,"Safety-netting advice codes",null,"Safety-netting advice codes","Safety-netting advice codes"]
["Study ID","0.4 Problem ICPC-Code","3.1 Number of times safety-netting advice given","3.3 Line number and text of safety-netting advice present in the transcript","0.1 Number of problems","0.2 Problem number (chronological)","0.3 Presenting Complaint text","0.3 Presenting Complaint ICPC","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 contingent 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 advice apply to the problem or a treatment / management plan for the problem?","4.1 Stage of consultation\nWhat stage of the consultation is the safety-netting advice deliver during?","4.2 Initiation by\nWho initiates the safety-netting advice?","5.1 Format\nWhat is the format of the of safety-netting advice?","5.2 Strength of endorsement\nWhat is the strength of the endorsement of the 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"]
[1,"K96 Haemorrhoids",1,"87: if the bleeding persists you must come back",2,1,"I've been noticing some blood mixed in with my poo","D16 Rectal bleeding","1 = Yes (diagnostic uncertainty)","0 = No (time-course)","3 = Same GP FU","1 = Documentation of FU present","1 = Acute","1 = Yes (not first presentation to HCP)","2 = Yes diagnosis given","Haemorrhoids ","3 = Contingent on investigation result",1,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","2 = Stronger (must, should, need to, this is important)",1,"bleeding persists","0 = Generic","2 = Return to / contact practice","2 = Patient","0 = Not specified","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","1 = Verbal only","0 = No documentation of SNA"]
[null,"K77 Heart failure\n",1,"113: If the tablets make your ankles swell up, you could just stop taking them and let me know because we could try a different one",2,2,"Can we also do my annual heart failure review?","K77 Heart failure","0 = No (diagnostic uncertainty)","0 = No (time-course)","2 = Practice FU","0 = No FU documentation","3 = Chronic","0 = No (not first presentation to HCP)","1 = Known Diagnosis","Heart Failure","2 = Contingent self care",1,1,"1 = This problem only ","2 = Treatment / Management Plan","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","0 = Weaker (can, could)",1,"ankles swell up","1 = Specific","3 = Return to same HCP","3 = Both Clinician & Patient","0 = Not specified","2 = Nods Only","0 = no questions asked about SN advice","1 = Verbal only","0 = No documentation of SNA"]
[2,"N89 Migraine",0,"-",1,1,"My headaches have been getting really bad recently","N01 Headache","1 = Yes (diagnostic uncertainty)","0 = No (time-course)","3 = Same GP FU","88 = CBD as NO RECORDS","2 = Acute on Chronic","0 = No (not first presentation to HCP)","1 = Known Diagnosis","Migraine","0 = No other contingent management plan",0,0]
[3,"F70 Conjunctivitis infectious",2,"111: As long as your vision doesn't suddenly change then I don't think there is anything to worry about.",1,1,"I woke up and both my eyes were really red","F02 Red eye","1 = Yes (diagnostic uncertainty)","1 = Yes (time-course)","0 = None (FU)","99 = N/A as no follow up","1 = Acute","1 = Yes (not first presentation to HCP)","2 = Yes diagnosis given","Conjunctivitis","0 = No other contingent management plan",2,2,"1 = This problem only ","1 = Problem","3 = Delivering Diagnoses","1 = Clinician","0 = Conditional Only ","0 = Weaker (can, could)",1,"vision doesn't suddenly change","1 = Specific","0 = No action advised","99 = N/A - no action component","0 = Not specified","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","1 = Verbal only","1 = Documentation of SNA present"]
[null,null,null,"140: This should settle down in the next few days, but if it doesn't then come back and I'll have another a look at it",null,null,null,null,null,null,null,null,null,null,null,null,null,2,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","1 = Neutral",1,"doesn’t (settle down in next few days)","1 = Specific","3 = Return to same HCP","3 = Both Clinician & Patient","1 = Named Day / fixed time period","0 = No response"]
[4,"K74 Ischaemic heart disease w. angina",2,"105: Look it says here that if the chest pain lasts more than 5 minutes you must ring 999 straight away",1,1,"I've been having some tightness in my chest when walking up hills","K02 Pressure/tightness of heart","1 = Yes (diagnostic uncertainty)","1 = Yes (time-course)","5 = Multiple","1 = Documentation of FU present","1 = Acute","1 = Yes (not first presentation to HCP)","2 = Yes diagnosis given","Angina","0 = No other contingent management plan",2,1,"1 = This problem only ","1 = Problem","4 = Treatment Planning","1 = Clinician","1 = Conditional + Course of Action","2 = Stronger (must, should, need to, this is important)",1,"chest pain lass more than 5 minutes","1 = Specific","5 = Contact emergency services e.g. 999","2 = Patient","2 = Immediate / Urgent","3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)","0 = no questions asked about SN advice","2 = Verbal and written","1 = Documentation of SNA present"]
[null,null,null,"150: Any other problems or concerns let me know",null,null,null,null,null,null,null,null,null,null,null,null,null,2,2,"1 = This problem only ","3 = Both (often if vague but can be mixed specific)","5 = Closing","1 = Clinician","1 = Conditional + Course of Action","1 = Neutral",2,"other problems; concerns","0 = Generic","3 = Return to same HCP","2 = Patient","0 = Not specified","0 = No response"]

{"sheet":"Data Validation","index":2,"n_rows":8,"n_cols":35,"rows_kept":8,"cut":false,"hidden":false,"merged":[]}
["Patient ID . Problem no","ICPC-2 Code Problem 1","3.1 Number of times safety-netting advice given","3.3 Line number and text of safety-netting advice present in the transcript","0.1 Number of problems","0.2 Problem number (chronological)","0.3 Presenting Complaint text","0.4 Problem ICPC-2 Code","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?","4.1 Stage of consultation\nWhat stage of the consultation is the safety-netting advice deliver during?","4.2 Initiation by\nWho initiates the safety-netting advice?","5.1 Format\nWhat is the format of the of safety-netting advice?","5.2 Strength of endorsement\nWhat is the strength of the endorsement of the 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"]
[null,null,null,null,null,null,null,null,"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","1 = Establishing Reason","1 = Clinician","0 = Conditional Only ","0 = Weaker (can, could)",null,null,"0 = Generic","0 = No action advised","1 = Clinician","0 = Not specified","0 = No response","0 = no questions asked about SN advice","1 = Verbal only","0 = No documentation of SNA"]
[null,null,null,null,null,null,null,null,"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","2 = Gathering Information","2 = Patient","1 = Conditional + Course of Action","1 = Neutral",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","2 = Verbal and written","1 = Documentation of SNA present"]
[null,null,null,null,null,null,null,null,"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)","3 = Delivering Diagnoses",null,null,"2 = Stronger (must, should, need to, this is important)",null,null,null,"2 = Return to / contact practice","3 = Both Clinician & Patient","2 = Immediate / Urgent","2 = Nods Only",null,"3 = unclear","88 = CBD as NO RECORDS"]
[null,null,null,null,null,null,null,null,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,"4 = Treatment Planning",null,null,null,null,null,null,"3 = Return to same HCP","99 = N/A - no action component",null,"3 = Acknowledgement (yeah, right, umm), positive assessment (great fine) or Acceptance (okay, alright, sure)"]
[null,null,null,null,null,null,null,null,null,null,"4 = Other",null,null,null,null,null,"4 = Changes mind about treatment already offered",null,null,null,null,"5 = Closing",null,null,null,null,null,null,"4 = Contact OOH / NHS 111",null,null,"88 = CBD as no response and audio only"]
[null,null,null,null,null,null,null,null,null,null,"5 = Multiple",null,null,null,null,null,"5 = Contingent Admin / Other",null,null,null,null,"88 = unclear",null,null,null,null,null,null,"5 = Contact emergency services e.g. 999"]
[null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 = Multiple Contingent Plans"]

{"sheet":"Macro instructions","index":3,"n_rows":9,"n_cols":1,"rows_kept":9,"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"]