Neural network in Excel

[@frodounterberg1113]

Hey Aleksey, thank you alot! It took me like 10 Hours to work that through - but I succeeded - learned alot from you! =) Keep on the good work

[@alekseyteslenko1608]

OMG! 10 hours. Your patience deverses admiration. )

[@scottlapierre1773]

Great course! I have had to spend many hours to follow along but very worthwhile - to know how to build a nn from the matrix math and in Excel. Thanks!

[@rakeshdwivedi5256]

Excellent Video and very simple stroke by stroke development.Many tx for it.

[@phillipka1750]

Aleksey, I enjoyed your video. I did not create my own version, but I did download your finished workbook from one of the comments. If you replace the copy and paste with Range("B8:I33").Value = Range("K8:R33").Value inside of your For statement the code runs much faster. I also set application.screenupdating = false while the code is running. I will be looking for ways to modify this neural network to assist with various things for my work. I am very interested in machine learning via VBA and look forward to any other videos you may have or may create in the future. Subscribed. Thank-you

[@alekseyteslenko1608]

Phil Lipka, thanks! Now I am thinking of make a class to build something more useable. Maybe to teach it playing in some simple game. Just for example.

[@nomadsoulkarma]

I have a question Aleksey or anyone: Which of these numbers can we consider our weights? Maybe B6 to I6? I'm trying to figure out how the numbers relate to the NN diagrams. For example in Tariq Rashid's book on page 54. If I can match the numbers up with a diagram it would greatly help

[@superpayaseria]

once again the least viewed videos are the absolute most useful.

[@frodounterberg1113]

Hey Aleksey, my network took about 11.000 trys to hit 100%. Was amazing :) I added after: For i = 1 to 1000 Cells(3, 1) = i And Cells(2, 1) = k before next i And added in the sheet in A4 the process in % (A4=A2/A3) so i could see it getting better while it was improving. Do you plan to make more Videos? I like them! :D

[@alekseyteslenko1608]

Such feedbacks inspire me ). Means I did nor waste a time making this video. So yes. Will come soon. )

[@alekseyteslenko1608]

Such feedbacks inspire me ). Means I did not waste a time making this video. So yes. Will come soon. )

[@nomadsoulkarma]

@@alekseyteslenko1608 No you did not waste time making this video.

[@giovanniportello297]

Hey Aleksey, why on the formula =(rand()*sqrt(1/count($B$6:$I$6))-0,01)+0,01)*if(randbetween(0;1)=1;1;-1) the -0,01)+0,01 part doesn't work? It says that the problem is especially on the -0,01. Can't continue with the video without this solved

[@alekseyteslenko1608]

Giovanni Portello, mayme it is because you need use point instead of coma? Like “0.01”

[@okboing]

please speak louder and clearer. i cant even finish watching the video because i have no idea what you're saying.

[@kishorb.surwade6722]

Dear sir, Nicely explained. Please share EXCEL Workbook of illustration.

[@alekseyteslenko1608]

Hi there. Please use this URL: drive.google.com/open?id=1Dzj86aVDetE_l-SjUayyWX508qkcMduM

[@almondjartone1206]

@@alekseyteslenko1608 Thank you good sir! Nice voice!

[@ritzosu34]

Wow, thanks for this video! I was able to work through it and get it to work. I have one question though. What is the purpose of the "YES/NO" line. Couldn't you just skip that step and go straight to .99 or .01 if it matches or not?

[@alekseyteslenko1608]

Colton Ritz , thanks for your comment! It is good question. I did it just to show that any analog signal like yes/no, exist/not exist etc. must be turned on numeric equivalent: 0.99, 0.01. Even 0/1 is not appropriate input.

[@nomadsoulkarma]

Completed everything and works perfectly. The button and the VBA code works however after a few button clicks almost all the data turns into #n/a in the cells. I wonder if anyone has encountered this?. Possibly something with the macro because it doesn't happen after pressing F9 multiple times

[@alekseyteslenko1608]

It means unfortunately that something was done wrong. Need to check.

[@nomadsoulkarma]

@@alekseyteslenko1608 Yes, Thank You

[@jecroisenme]

really nicely explained!! #kudos!

[@sanjitseet33]

I liked it. Fully on excel no coding...

[@EnriqueLuengoCorbal]

Hi Aleksey, nice video. Glad you have shared all the process on how to do the calculations. I'll be awesome if you had show a short schema on what the "blocks" mean and how they behave and evolve. Eitherway, it's a good one. I'll try to do my best to get this achieved (the schema thing), and will try to post/link/whaterver back here. Kind regards, and hope you can post more videos on this topic... and that we can see them ;) With VBA the MMULT and the TRANSPOSE functions could be overrided and the system could be applied to complex ones.

[@EnriqueLuengoCorbal]

For anyone interested, you should consider to take a look at the following links, that share much of the structure of what is exposed here. There you can find more about the theory and mathematics under the hood, and how the building blocks are organized and computed. When you get confident enough with what it is explained there, you can come back to follow the Aleksey video, that is a nice implementation of that theory on the Excel environment. stevenmiller888.github.io/mind-how-to-build-a-neural-network/ stevenmiller888.github.io/mind-how-to-build-a-neural-network-part-2/ As I'm trying to understand both and mix on a Excel VBA thing, for sure will get more on this. Would be nice to have a community where ANN over Excel can be explained and shared. Aleksey, I would be glad if you contact me, if you're interested on this. I'll love to share some more contents. Thank you in advance.

[@alekseyteslenko1608]

Enrique, thats cool you consider my video so much seriously. To make it possible I read a very good book where all the theory explained in in deep details. So I recommend it to everybody. My video was just to prove that it is possible at all. If I would try to clarify all the nuances it would take an hour. ) www.amazon.com/Make-Your-Own-Neural-Network-ebook/dp/B01EER4Z4G

[@EnriqueLuengoCorbal]

@@alekseyteslenko1608 Aleksey, thanks for the info, for a newbe (as I'm in ANN field) is hard to find good "filtered information". Considering to get the Kindle book... :). Now on the task of coding an Excel Add-In to build this kind of NN and overcome the hassle of MMULT and TRANSPOSE.

[@МС21-з5н]

Мощно!!!

[@bossprb]

Awesome! My baby took 8 thousand tries but learned indeed :D Thanks a lot!

[@alekseyteslenko1608]

)) Thank you! I would like to know it inspires you to make something more complicate.

[@bossprb]

@@alekseyteslenko1608 yeah sure!

[@pedron.3675]

Mine is not working ! Not even in +10000 tries !!!!!

[@alekseyteslenko1608]

Pedro, sometimes a random initial combination of weights can be so that it is not able to turn on into correct combination even after 10000 trials. Try to reset all the weights to random values. If no then you probably made a mistake on some step.

[@SanjeevKumar-jn2pt]

@@alekseyteslenko1608 mine is not even improving

[@alekseyteslenko1608]

@@SanjeevKumar-jn2pt This definately means that you skip something important on one of the steps. I could send you the working file if you want.

[@alekseyteslenko1608]

@Barly A. DINALO drive.google.com/open?id=1Dzj86aVDetE_l-SjUayyWX508qkcMduM