Does anyone know of an easy to use collaborative filtering tool? Ideally, that would be an add-in for Excel to work on an external data source on SQL Server.
Alternatively, any indication on how to code such an algorithm in Excel VBA or VB 2005?
The dataset consists of around 1,000,000 records.
2006-06-12 23:16:27 · 2 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design
There really isnt any add-on tool for such a task. I only deal with JAVA programming, but maybe VB logic would be simliar.
You can parse an excel form by converting it to a .csv file which creates a row of data and the deliminator is a comma. You can just create a filtering tool that would manipulate this csv file the way you want. Then just rewrite the results into a file in csv format, then you can actually create a macro to open this file in excel and then convert it to an excel format. It would only take a few programming logic to create the filtering tool you want it to just by running the program on your server.
2006-06-13 02:12:24 · answer #1 · answered by Sean I.T ? 7 · 0⤊ 0⤋
I fell pretty lonely here in your question.
Why do you always ask these sort of things? no one will say: "you are smart, smartie" or "you are so stupid, fak yu".
Try to be entertaining, and make me laugh instead.
I'm sorry, I got annoyed, don't know why...
2006-06-13 01:07:15 · answer #2 · answered by rakovica.blinks 2 · 0⤊ 1⤋