 Dwi'n meddwl i'n cael blaes. Ond ydych chi'n campus ysgol ni'n meddwl i chi'n ddod ffodol y fath, a'r eich senol yng Nghymru yn ymlaen nhw, Ond, mae'n tryn meddwl gafodol ei wneud o bobl i'r mynd yn y hunai. Mae'r mewn sydd yma yn ychydig i'n mynd i Fel Yn Yn Nwy. Fe ydych i'n meddwl i erbyn hyn. A Plain Mind Superb before you'll be thinking whaitt hang on you're supposed to click on them in the you should click over here and That reveals things. Oh, you can't quite do that natively in Excel without VBA Spreadsheets are a static object they just calculate what's on screen and then they stop if you want to detect a change and then change it again you need some additional code to do that and I haven't done that It's certainly straightforward thing. You just need to ychwanegi'r oed, a'r arddangos ar yr uch. That's... I should be fairly straight forward to do, but I've not implemented that. I just want to see if I could do it with just the sheets alone. So that sounds interesting. Like, share, subscribe, whatever I don't care. I'm just doing this because it's fun and stupid and I'm a nerd. So let's unhide this and see what we're doing. At the top here I've got a field. Dyna 10x10, ac mae'r llag yn ysgrifau, mae'n gwybod am y cyntaf. Felly mae'r llag yn ysgrifau. Ac mae'n roi'r llag yn llag ysgrifau. Mae hynny'n gweithio'r llag yn ysgrifau, dwi'n gweithio'r llag a phrywwch. Mae'r llag yn ei ddiwedd. Mae'n trwy'r llog yn eu ddylch ar gyfer y fung ac yn ysgrifau. Mae'r llog yn ysgrifau. A'r llog yn ysgrifau. So... Mae'r llog yn ysgrifau. That being the number being triggered. That's counting are up. I will go to that in a second. Down here there's another one called field. See I've got a field. This is kind of generating what the game show you. So basically if I click into the formula, it becomes obvious what it's doing. It looking up in the Mines array, and if it's m that's for a mind, it is replacing it with the flag character. If that's not true, we're going to ask it again of the number of m's around it in this 3x3 grid, equal to 0 and if so, it's going to return blank. If not, it's going to return the number, the count of m in there so that that part won't trigger if there's an m already here so the maximum candelion we need to do is 8. mwy o'r rai o'r dwi'n cyffredinol o'r ddynami ac yw'r funisiwn ar gyfer dechydig. Rwy'n ei gael arnynod o'r ddyfodol o'r cyffredinol, felly mae'r ddangos o'r ddynai i'r unllustau, ond mae'n meddwl yn gwneud yn ymddangos, a'n defnyddio'r ddrago'r ddoddau a'r ddoddau i'r ddoddau i'r ddoddau i'r ddoddau. Felly mae'n gwybod i'r ddoddau i'r ddoddau i'r ddoddau i'r ddoddau i'r ddoddau. Cyngor, mae ydy o'n gwybod rhywbeth y blaen i gweithio'r gweithio. Rwy'n iawn cael ei gael ei gweld 8, 7, 6, 5, 4. Mae hyn yn gallu cwylau'r blaen. Mae wedi gweithio'r blaen oherwydd y llawd o'r cynnydd, maen nhw'n gwybod iawn erbyn chi'n cael ei gweld'r gweithio'r gweithio'r ffaith, mae'r bobl add eto frydym. Mae'r ffordd yn gweithio'r bobl yn cael ei gweld. Mae ddim ei ddim fel o millenu, ac os ydych chi'n gweld i'r ffordd ac oeddwn i'r ffordd fel ymylion. Felly mae'r 8 o ffordd a mlynedd. Ond ydych chi'n dechrau o'n bwysig i'r wneud. Mae'r ffordd yn gweithio. Rwy'n ffordd o'n dwylo, mae'r ffordd yn gweld i'r ffordd. Ac oedd gweld i'r ffordd. Mae'n ffordd yn y cysylltu ac yn y pwynt. Ac mae'n rhaid i'r bwysig. Dyna'r gweld i ddechrau i'r ffordd. ac ydyna daeth yn y cwyl chi eich clywed o'ch gwbl ychydig yng Nghymru? Mae'r cwyl i'r ailwydd i'r llwy, ac symud ond rwy'n iawn. Mae ydych chi'n… Mustafel, rydyn ni'n gwneud email ar gyfer cael ei bod yn hyfgafio gyda'r cwyl bars rak y pêriau yn cyntrwyd â'i ddim yn gwneud eich cymaint? Mae'r cwyl yn cael ei fusyll yn gwychais yn fawr. Mae rhaid eu masbydd ychydigam, mae'n gwybod gyda slyctau, ac rydych chi'n credu hefyd. If the number of explosions is greater than zero, I'll go back and just show how that's done now, it's some product this one, so if the mines array is equal to M, make it one, if not make it zero, and if the input array is the clear character, x in this case, make it one and zero, and then some product will multiply those together. So, as that's put in as an array formula, it will do each cell kind of individually, so that's now equal to one, that's equal to zero, that's equal to zero, that's equal to one, they're going to multiply together to be zero, but if I put myself in M here, that top left's one, that top left's one, more times one is one, they're going to add up, and the more of these M's I put in here you can see it goes up because I've got the x's here. The number correct is the exact same thing, actually mines equal to M, and the input is equal to the flag, so I'm working out the number that are correct as well as the number of being incorrectly detonated. So anyway, if that explosion is zero, when the mines is equal to M, replace it with the little Unicode Explosion Collision character, you can google that one, it's basically an emoji, oops, didn't do that. N of it isn't an M, replace it with whatever is in the field so you can see the number appearing. So if we trigger this off, you can see all the answers appear. But if we don't have that end game, we're going to a different one. If the input is the clear character, replace it with whatever is on the field, so if I correctly hit X and don't trigger a mine, I'm copying the numbers from the input field here, this field, the mine field. And otherwise, if the input is a flag, whatever the flag character said, put the flag on there, if not a blank it. Now in mine super, you do get the option to put a question mark just to kind of hedge your bets on something. That's another thing that could just be coded in here as another if statement that's not beyond the wit of man to do. And that's basically the whole game. You only need VBA code to really transfer this over to here when you change character. The only last final thing, there's a little win counter here if the remaining is zero and the number of correct and the total mines are equal to each other. Present it is a win and there's a little bit of conditional formatting that will turn it all green. But do you want to put Z on all of these to prove it? That does the trick. Where am I up to? Another one there. Oh, where am I missing? No, I've put too many in. Put them in the wrong direction. There you go. I'm just copying that. So it turns out all green. And I've won it. There we go. That's Minesweeper in Excel without VBA. So it's a little bit awkward without that extra bit of coding step, but it's the starting point. This is what you'd have to do if you want to program the game in a spreadsheet. Why would you want to do that? I don't know. Maybe you just got a time management problem like me or maybe you just like doing things that this was not designed to do.