Тёмный
Spreadsheets are all you need
Spreadsheets are all you need
Spreadsheets are all you need
Подписаться
Комментарии
@somdubey5436
@somdubey5436 2 месяца назад
seeing this video made me feel I am not even close to say I know excel. Your understanding of concept is really really deep as implementing something like GPT-2 in excel requires one to have thorough understanding of all the concepts. Hats off to you.
@iamartandalchemy
@iamartandalchemy 3 месяца назад
🤯Truly Brilliant
@makacarp
@makacarp 3 месяца назад
I can’t wait for the next videos, as this really helps me understand really how this technology works!
@Tesserae
@Tesserae 5 месяцев назад
Are the 768 columns, for each word in the vocabulary, the equivalent of weights of the 768 layers of the neural network, or are they something else?
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
Not sure what you mean by equivalent. Technically they separate. That is the the neural networks in the model (also called the multi-layer perceptron stage) have their own set of weights that are separate from the embedding weights. But both sets of weights (embeddings and neural network) are learned during the training stage (i.e. backpropagation) so in that sense they are similar. Does that answer you question?
@Tesserae
@Tesserae 5 месяцев назад
@@Spreadsheetsareallyouneed yes you’ve answered my question. I was asking whether the embedding weights were the perceptron layer weights; they are not.
@mstx8047
@mstx8047 5 месяцев назад
This is so amazing - best way to see, play and tweak GPT. Thanks for so much work building the spreadsheet and making sure everything works. Must not be easy task. Waiting for you to cover "Text and Position Embeddings" video now.
@Vesture23
@Vesture23 5 месяцев назад
Very instructive video, easily understood. Look forward to you future videos!
@oo_wais
@oo_wais 5 месяцев назад
best explanation of word embeddings i have found so far..
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
Thanks! Notes like this are helpful motivation to keep going.
@intrancex
@intrancex 5 месяцев назад
This is really, really well done! Thank you so much for all the effort!!
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
Thank you! Spread the word and tell your friends.
@lewisbentley3177
@lewisbentley3177 5 месяцев назад
Fantastic! I was looking forward to this video. I really appreciate your excellent explanations, such as when you explain embeddings via an analogy of house buying. Great stuff, thank you so much for putting it together.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
Thrilled to hear you were looking forward to the video and it lived up to expectations. Glad you liked the housing analogy. Keep the feedback coming.
@alejandrogarcia-sw4ic
@alejandrogarcia-sw4ic 5 месяцев назад
I consider myself quite advance in excel... I understood nothing you did, not even the intention you had
@forceliquid2097
@forceliquid2097 6 месяцев назад
Very nice product. But I have always wondered why there is nothing to learn about AI in a spreadsheet. I'd also like something more minimalistic that works minimally for rapid learning. And I would like to see a diffusion-generated model product made as well.
@gbpferrao
@gbpferrao 6 месяцев назад
How long till runing gpt 4 on minecraft only
@JohnSmith-he5xg
@JohnSmith-he5xg 6 месяцев назад
Why does having a large Embedding Table matter? Can't it just be treated as a lookup into the Table (which should be pretty manageable regardless of size)? Do we really have to perform the actual matrix multiply ?
@fastler2000
@fastler2000 6 месяцев назад
Incredibly brilliant. Words fail me. Thank you for sharing this, it helps me enormously in understanding AI. On a side note: How ingenious can you handle Excel? Unbelievable!
@paulwillis88
@paulwillis88 6 месяцев назад
This is an incredible video. The way you describe these advanced AI concepts is awesome. I'd love to see more, maybe on the GAN technology that Sora uses
@vkm1650
@vkm1650 6 месяцев назад
interesting shit ^^ can you help how to teach an LED 2D matrix of 100*100LED with an AI to show images that you pronounce? #ubeartform instagram my shit about it -.-
@ouo9454
@ouo9454 6 месяцев назад
what is you favourite ide excel you mean vba no
@jjokela
@jjokela 6 месяцев назад
Really cool stuff, it really helps me to understand how the BPE works. Looking forward to your follow-up videos!
@rajahx
@rajahx 6 месяцев назад
Bravo! This is great way to introduce the nuts and bolts of large language models to a lay audience. Far, far more accessible than the baggage that comes with teaching it via pytorch or tensorflow. Just simple math and a little bit of excel wizadry. Lovely idea and thank you for making these videos.
@jytou
@jytou 6 месяцев назад
Excellent! Spreadsheets deserve more attention! 😀
@BryanSeigneur0
@BryanSeigneur0 6 месяцев назад
So clear! Great instruction!
@abbasbvohra
@abbasbvohra 6 месяцев назад
Modern Day i.e. by 2024 , spreadsheet software is way too advanced, so this ain't surprising really. Sadly i can't list the weird things people have achieved using Excel (weird but not really in a bad way & was mostly inspirational & definitely creative). Really Glad someone did this.
@carlt.8266
@carlt.8266 6 месяцев назад
It is an amazing lecture you compiled in this video. Do you also have one on the training of GPT2 or how the tokens get their semantic context/meaning?
@carlt.8266
@carlt.8266 6 месяцев назад
Thank you for explaining "Temperature" so easily <3
@MStrong95
@MStrong95 6 месяцев назад
Large language models and AI in general seems to do a good job of compressing and then turning back into an approximation of the input. Is this a byproduct of nural networks in general or just specific subsets? Could you make a large language model or a lot of purpose built AI that are good for various different compression situations and more often than not perform better than current compression algorithms?
@defface777
@defface777 6 месяцев назад
Very cool! Thanks
@lordadamson
@lordadamson 6 месяцев назад
amazing work. please keep going :D
@Seikou27
@Seikou27 6 месяцев назад
This input is so DN awesome. Well done! Definitely deserves more attention :-)
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Much appreciated!
@GaryKeramidas
@GaryKeramidas 6 месяцев назад
Great job. noticed on the tokens to text embedding sheet you have embedding missing the "b" in row 14
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
you're right. good catch! i'll have to fix that in subsequent versions.
@earlybyrdy
@earlybyrdy 6 месяцев назад
thank you so much! i can use this for my NLP class
@cz8986
@cz8986 6 месяцев назад
Best explanation I'have ever seen on transformers. Big KUDOS !
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Thanks!
@kennrich213
@kennrich213 6 месяцев назад
Great video. How exactly are the scores calculated from the possible pairs? You said a standard filter? Could you explain more?
@GrossGeneralization
@GrossGeneralization 6 месяцев назад
🤯
@paulwillis88
@paulwillis88 6 месяцев назад
Fantastic work! Thank you for the comprehensive and useful explanations
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Glad you enjoyed it!
@KelleyParker
@KelleyParker 6 месяцев назад
Nice video! So if I understand correctly, you have to click "Calculate Sheet" on all the sheets every time? There isn't a one button-click option?
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
You don’t have to. There are options in excel to both calculate the entire sheet at once or just do it sheet by sheet.
@SeaJay_Oceans
@SeaJay_Oceans 6 месяцев назад
0:23 so... 2030 Sapiens Silicon ?
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
I've been waiting for someone to comment on that...It was a funny throwaway observation right after I put the slide together but who knows. Ray Kurzweil has been predicting AGI by 2029 for over two decades now.
@SeaJay_Oceans
@SeaJay_Oceans 6 месяцев назад
@@Spreadsheetsareallyouneed We Can Think, Therefore, We Evolve ...
@lewisbentley3177
@lewisbentley3177 6 месяцев назад
This is amazing! Thank you for making this. Really looking forward to your next video about text and position embeddings
@lewisbentley3177
@lewisbentley3177 6 месяцев назад
This is fantastic! I'm really looking forward to the rest of the series.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Thanks. Notes like this are helpful motivation to keep going.
@j83lin
@j83lin 6 месяцев назад
Really educational video, thank you!
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Glad it was helpful!
@wshelton24
@wshelton24 6 месяцев назад
Super cool project!!! Very well done. Explanation was also incredibly easy to understand. Thanks brother.
@bikedawg
@bikedawg 6 месяцев назад
i did not understand a thing. lol
@richardgrosman5798
@richardgrosman5798 6 месяцев назад
Thank you for simplifying!
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
You're welcome!
@richardgrosman5798
@richardgrosman5798 6 месяцев назад
Good job!
@fastica
@fastica 6 месяцев назад
What I've learned from this video: Mike is quick and he moves quickly.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Lol. You have a bright future as a Large Language Model. 😃
@fxpatrickryanto2452
@fxpatrickryanto2452 6 месяцев назад
thank you for great explanation and the spreadsheet file, yet talking about v0.6.0, would you mind to explain where is the Split_Into_Characters formula is located? because when i run the manual calculation, sheet Prompt_to_Tokens, cell (column 2, row 4) only return #NAME? error
@TNIxeye
@TNIxeye 6 месяцев назад
same here
@robinhodson9890
@robinhodson9890 6 месяцев назад
I haven't downloaded the sample spreadsheet, but he notes in a different video on tokenisation, that it splits words into one or more tokens, not one token per word, and certainly not one per character, as these would result in a drastically larger memory footprint.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
This could be locale issue or an Excel version issue. See github.com/ianand/spreadsheets-are-all-you-need/issues/6
@RamiGB
@RamiGB 6 месяцев назад
I am sorry when It sounds like a cliche but honestly this video deserve way more views! so people can understand how GPTs work! excellent beautiful work thank you.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Wow, thank you. Please spread the word. A better understanding of AI is helpful as we have these societal debates about the technology.
@kynamnguy
@kynamnguy 6 месяцев назад
So good brooo
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Thanks!
@nevermnd001
@nevermnd001 6 месяцев назад
Haha.. This is great/intructive, but also crazy... In Excel (!?!)-- I like it.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Someone on Twitter put it similarly: "it is simultaneously incredible, and an aberration" twitter.com/bdkoepke/status/1769128618486112448
@frankenmizer828
@frankenmizer828 6 месяцев назад
Well done! Thank you!
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Thanks!
@jinyoungkim9087
@jinyoungkim9087 6 месяцев назад
Normally, I dont write comment but, this is the most useful video!
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 6 месяцев назад
Thank you for taking the time to write a positive comment!
@iraklimachabeli6659
@iraklimachabeli6659 6 месяцев назад
Great demo, cant wait to see the attention part video. Btw you can reduce excel lockups by disabling autosave. I just downloaded the excel file and looks like autosave is turned on.
@Spreadsheetsareallyouneed
@Spreadsheetsareallyouneed 5 месяцев назад
In my experience disabling auto save on the Mac does help but does not eliminate the lock up issue on the Mac.