 So we're finally doing our giveaway video for the Western Digital WD 1 terabyte green ears Advanced format drive if you don't know what an ears advanced format drive is you should check out my videos I've done a few on this particular drive Outlining exactly what advanced format is basically it's better And it's going to enable better storage densities in the future so let's do the giveaway now I actually had some questions last time around about how I draw a random winner And the way that I do it is like this I use excel well I would normally use excel except I'm stuck using the cameraman's fail Mac, but I'm going to use numbers Okay, and I start with my subscriber list So there's no easy way to just take your whole subscriber list put it in a hat and draw one unless you have like 10 subscribers But I'm working with fourteen thousand seven hundred and twenty six subscribers, so that's on my NCIX tech tips channel Basically I take that divided by 40 because that's how many subscribers are displayed on each page, so that means I have 369 pages or partial pages of subscribers, so I go into numbers And I use the ran between formula I paste that in okay, so I paste that under page and I end up with 312 so once I have that I take 312 times 40 which is going to give me which page I want to start on so I'm just going to go back over to YouTube here, and we are going to start on page No, that's not right hold on a minute hold on I can figure this out on camera. It won't take that long so 312 Yeah, 312 times 40 equals. Oh yeah, okay, so start at 12 480 equals Okay How could that possibly be right? Well that can't be right. Oh, yeah, I guess it's like right near the end. Okay. Yeah there we go Okay, so we have a page of subscribers next we are going to go to our next sheet in the fail numbers program And we are going to pick a rend between row so we are going to You find that we hair again row number two so the winner is going to be one of these ten people And then for our final formula we are going to use ran between one and ten and we are going to pick a column So let's go down to our column spreadsheet here. This is very inelegant way of doing it so the winner is page Whatever page this is row two and column four so slug bug is Is the winner as long as he is subscribed to both of my channels which he is so we just go in here and verify He is subscribed to both NCIX calm and Linus tech tips. He is the winner We will get in touch with slug bug 55 and thank you everyone for participating and thank you for checking out my video blog Don't forget this isn't the only giveaway that I'm working on we're also going to be giving away an Antek true power quattro 1200. Oh, I don't want to listen to that okay Antek true power quattro 1200 watt 80 plus silver modular overclocking edition power supply as soon as my video blog which is my Linus tech tips channel reaches 10,000 subscribers so right now. We're sitting at only 9,700 subscribers so tell everyone you know to subscribe so that we can draw the winner of the true power quattro 1200 watt