Absolutely amazing!! Thank you so much for this! More Excel neural network stuff would be a great help to many. It's a great way for those lacking formal programming skills/experience to get their feet wet and help them visualize everything much better.
Hi Skyler The spreadsheet is available on github so you can take a look there. Check out the description for the video. The simplest way to do that is use the "data -> text to columns" function in excel to split the training and testing data. But that ends up with big file sizes. I was suprised that there was not a simple split command in excel. So I came up with a formular to split the string on the fly. It was a bit tricky (probably the hardest part) and is recursive. I can't quite rememeber the thinking but looking at the spreadsheet I have in A32 =SEARCH(",",$A$30) B32 =INT(MID($A$30,A31+1,A32-1-A31)) This is copied for each of the cells. But from A33 on I have A33 =SEARCH(",",$A$30,A32+1) Then copying into the 28x28 was easy. Either use a transpose or just use a formula and copy and paste Hope this helps. Let me know if you need more. Mike
Is there any chance of the starting file being made available? Being totally new to this, the preprocessing and data formatting you did is difficult to figure out simply from the video. Being able to see the individual formulas for each cell and figure out how all of those features work together would be quite helpful.
So, i followed your guide here, building the same thing here, is there any chance I can share my file with you, I feel like there is a simple error made somewhere, it SHOULD improve, but im stuck at 10%, so something must be wrong with the learning update thing..
Sorry missed your comment If you can make it available I can take a look. I’ve put my version on GitHub so check it out and maybe put yours on there too
I mean this with utmost respect...you sir are a mad scientist.
Thank you Jordan
Absolutely amazing!! Thank you so much for this!
More Excel neural network stuff would be a great help to many. It's a great way for those lacking formal programming skills/experience to get their feet wet and help them visualize everything much better.
Thanks Tony
Excellent explanation for the NN...
Thank you for the video. This video really de-mystified machine learning for me.
Thanks David
Hey Mike! Loved the video... I was curious how you’re taking the string that represents the gray scale (on your control tab) and transposing it?
Hi Skyler
The spreadsheet is available on github so you can take a look there. Check out the description for the video.
The simplest way to do that is use the "data -> text to columns" function in excel to split the training and testing data. But that ends up with big file sizes.
I was suprised that there was not a simple split command in excel. So I came up with a formular to split the string on the fly. It was a bit tricky (probably the hardest part) and is recursive. I can't quite rememeber the thinking but looking at the spreadsheet I have in
A32 =SEARCH(",",$A$30)
B32 =INT(MID($A$30,A31+1,A32-1-A31))
This is copied for each of the cells. But from A33 on I have
A33 =SEARCH(",",$A$30,A32+1)
Then copying into the 28x28 was easy. Either use a transpose or just use a formula and copy and paste
Hope this helps. Let me know if you need more.
Mike
Is there any chance of the starting file being made available? Being totally new to this, the preprocessing and data formatting you did is difficult to figure out simply from the video. Being able to see the individual formulas for each cell and figure out how all of those features work together would be quite helpful.
Tony - added a link. Thanks
Thank you so much! You are a saint. Gonna share this with a bunch more people now.
The file on GitHub is missing the training and testing data. I've added the new file in the issues section on GitHub
So, i followed your guide here, building the same thing here, is there any chance I can share my file with you, I feel like there is a simple error made somewhere, it SHOULD improve, but im stuck at 10%, so something must be wrong with the learning update thing..
Sorry missed your comment
If you can make it available I can take a look. I’ve put my version on GitHub so check it out and maybe put yours on there too