Recommender Systems in Visual Basic for Applications

[Waimea]

Hi, I am trying to create a recommender system in Excel by using VBA.

I am using a spreadsheet I created by watching this video:

https://www.youtube.com/watch?v=gOdLYa7GPQY&list=PLrwfR6PR5Z3g6nduXPW9W4sdokCFwZEeg&index=3

I am calculating correlation by using CORREL but I would like to use COSINE SIMILARITY and in this thread, https://www.mrexcel.com/forum/excel-questions/1071732-cosine-similarity.html user joeu2004 helped me with the code.

How can I use the code for COSINE SIMILARITY on my spreadsheet?

 

[Waimea]

For those who doesn't know what a recommender system is, this is a good read:

http://nbviewer.jupyter.org/github/...rial/1-Playing-with-Recommender-Systems.ipynb

If anyone is good at python3 and VBA, please PM me!