17 September 2008 by Ross McLean
Last week I spent a bit of time working on a of Fuzzy Logic type problem. This was for a VB app, rather than anything to do with Excel, but I wanted to test the different methods quickly and in a flexibly way. Excel was obviously ideal for doing this.
I have complied about 5 methods into a workbook (very, very rough stuff mind), none of the code is my own work, it’s all just gathered from around the net, I thought it might be useful for other folks (and myself again at some point!) to have it all in one work book let me know if you tied it up. The algorithms are:
Levenshtein distance
SoundEx
SoundEx2
SoundEx – Daitch-Mokotoff
Metaphone
DoubleMetaphone
So that’s 6 ways then not 5 as I may have lead you to believe. The fastest by far is standard SoundEx (it should be, it much simpler than the rest!), the others have various strengths and weakness.
If you have any more, let me know!!!!
Fuzzy tests.xls
Tags: Downloads, Examples, VBA
Categories: UDF •
6 Comments »
11 September 2008 by Ross McLean
This caught my eye, it sure would be a nice to have tool or feature of VS. I built a tiny .Net app but cant really depoly it as it needs an install of 3.5, inc a reboot and 20-30 mins of install time.
http://www.xenocode.com/Products/Postbuild/
Anyone else seen anything like this or got any ideas? – I’m trying to re-write that app in Delphi!
Tags: Dev Tools, VB.Net
Categories: VB.Net •
4 Comments »
2 September 2008 by Ross McLean
Sam asked if you could build custom task panes with VB.Net Express edition. The simple answer is no. However this question raises a deeper issue.
What are all the options when it comes to extending Excel (or any other office app for that matter). Most of us know about XLA, XLL, DLL, etc but the .Nety stuff is not as well understood. In an attempt to shed some light on all of the options I have tried to make a simple table weighing up the options I’ve also bugged VB6 and Delphi in at the end just to help compare the options.
I should point out that I haven’t even used some of these technologies myself, so I’m not suggesting this is the definitive answer, but I think it’s a fair reflection, and I can tell you that I’ve not be able to find anything else like this on the net, so this is a World Exclusive!!!
Heres the PDF wall chart!!!!
Tags: Downloads, VB.Net, VB6, VSTA, VSTO
Categories: Addins, VB.Net, VSTA •
9 Comments »
