Sound Matching - Excel

Dear All,

Hello and Greetings from Mysuru!

I am a Para-Medical Research student. I am naive of using the excel.

I would like to seek your kind suggestions and gestures regarding making "Automated Phonetic Matching" (Sound alike) list for the brand names of the drugs.

I have a drug brand list of 10,000 in excel 2010. Now, with this I would like to separate sound alike drugs thereby reduce the dispensing errors in our hospital.

After a brief search, I came across Soundex. But I cant put it to further use. So was with Beider-Morse Phonetic Matching.

I request all of you, to help me in this regard.

Warm regards
Harsha

Hello Ross,

Thank you.

Yes, I am having trouble making that codex work on my excel. Yes again, yet want to take a chance and see what happens.

Is there a way I can upload my excel sheet for your kind review?

Regards

Dear Ross,

Thank you. I have just uploaded the file. so the second column contains the brand names of the drugs. In this list, I want to separate the sound alike drugs.

Reason: a 45 yr old female was dispensed and administered with an antibiotic called Linezolid (Lincef) instead of vitamin C (Limcee) chews due to their brand names are sound alike.

I don't want this to happen with other patients.

Thanks for your time and efforts.

Warm Regards,
Harsha

Thank you so much Ross, I will acknowledge you as contributor in this work.

Many thanks, Ross.

Hi Ross,

Thank you for asking.

1 . No Ross, From the hospital formulary, they will order the drugs. Brands just get added up.

from these brand names (Column B) we want to separate sound alikes into column C.

Further, whenever some one tries to enter a drug brand name into Column B, the algorithm should be able to sort out its sound alikes and update the Column C.

Is that possible Ross?

Many Regards,
Harsha

Hi Ross,

I was just wondering what has happened...

Regards,
Harsha

Originally Posted by popipipo

Will this help you?
Fill in a part of the name in B2

Thank you Popipipo,

I'll get back to you shortly.

Originally Posted by popipipo

Will this help you?
Fill in a part of the name in B2

Thank you Popipipo,

I am happy that you helped to solve this. However, I am not able to figure this out. When I have the whole drug list, the phonetics codex should be able to highlight the sound alike within the list and highlight them. Eg. If I am about to see a brand "LIMCEE" it should highlight the sound alike like brand name "Lincef".

There by the dispenser of the medicines will be cautious.

Hope you understand...

Many Regards
Harsha