Western Digital 1TB Green EARS Hard Drive Giveaway Winner Announcement Linus Tech Tips
Linus Tech Tips
·Linus Tech Tips
·2010-05-08
·
631 words · ~3 min read
0:00
so we're finally doing our giveaway video for the Western Digital WD 1 tbte
0:05
green ears Advanced format drive if you don't know what an ears Advanced format
0:09
Drive is you should check out my videos I've done a few on this particular Drive
0:13
outlining exactly what Advanced format is basically it's better and it's going
0:17
to enable better storage densities in the future so let's do the giveaway now
0:21
I actually had some questions last time around about how I draw a random winner
0:27
and the way that I do it is like this I use Excel well I would normally use
0:32
Excel except I'm stuck using the cameraman's fail Mac but I'm going to
0:36
use numbers okay and I start with my
0:39
subscriber list so there's no easy way to just take your whole subscriber list
0:43
put it in a hat and draw one unless you have like 10 subscribers but I'm working
0:47
with 14726 subscribers so that's on my NC
0:52
Tech tips Channel basically I take that divide it by 40 because that's how many
0:56
subscribers are displayed on each page so it means I have 3 69 Pages or partial
1:01
pages of subscribers so I go into numbers and I use the ren between
1:06
formula I paste that in okay so I paste
1:09
that under page and I end up with 312 so
1:15
once I have that I take 312 * 40 which
1:19
is going to give me which page I want to
1:22
start on so I'm just going to go back over to YouTube here and we are going to
1:28
start on page AG no that's not right
1:31
hold on a minute hold on I can figure this out on camera it won't take that long so 312 yeah 312 time 40 equals oh
1:40
yeah okay so start at
1:45
12480 equals okay how could that
1:49
possibly be right no that can't be right oh yeah I guess it's like right near the
1:53
end okay yeah there we go okay so we have a page of subscribers next we are
1:57
going to go to our next sheet in the fail numbers program and we are going to
2:03
pick a Rend between row so we are going
2:06
to find that we are in row number two so
2:10
the winner is going to be one of these 10 people and then for our final formula
2:16
we are going to use Rand between 1 and 10 and we are going to pick a column so
2:22
let's go down to our column spreadsheet here this is a very inelegant way of
2:27
doing it so the winner is paage
2:30
uh whatever page this is row two and
2:33
column four so slug buug is the winner
2:37
as long as he is subscribed to both of my channels which he is so we just go in
2:42
here and verify he is subscribed to both ncixcom and lonus Tech tips he is the
2:48
winner we will get in touch with slug buug 55 and thank you everyone for
2:54
participating and thank you for checking out my video
2:58
blog don't forget this this isn't the only giveaway that I'm working on we're
3:02
also going to be giving away an antech true power Quattro
3:06
1200 I don't want toist that okay antech
3:09
true power Quattro 1200 watt 80 plus silver modular overclocking Edition
3:15
power supply as soon as my video blog which is my lonus tech tips channel
3:20
reaches 10,000 subscribers so right now
3:24
we're sitting at only 9,700 subscribers
3:27
so tell everyone you know to subscribe so that we can draw the winner of the
3:31
true power Quattro 1200 watt