I am attaching excel document and I need help to formulate excel sheet please.I
I am attaching excel document and I need help to formulate excel sheet please.I want the excel sheet as follow@
A,B,C,D the same
E: Title as Source of referral: then Inpatient (Y/N), OP (Y/N)
F: Title as Diagnosis: then CF Y/N, Bronchiectasis Y/N”, other Y/N”
G: ICS – Y/N
H: LD ICS (Y/N)
I: MD ICS – Y/N
J: HD ICS – Y/N
K: carbocysteine – Yes/N
L: HTS – Y/N
M: Eosinophil> 0.3 – Y/N
N: IgE>500 Y/N
O: Pre -test FeV1 – >1 (Y/N) or <1L (Y/N)
P: Prophylactic Antibiotic – Azithro (Y/N)/others (Y/N)
Q: Indication – PsA (Y/N)/others (Y/N)
R: First PsA - Y/N
S: Prior Antibiotic Y/N
T: IV/Oral
U: Prior physio- Y/N
V: Pre test salbutamol - Y/N
W: Outcome: Pass or fail X: Reasons for failure Spiro (Y/N) /Sym ( Y/N)
Y: 3month treatment - Y/N
Z: reason for discontinuing
AA: Sputum PsA status at 3months – PsA / No sputum