WEBVTT

00:00:00.480 --> 00:00:07.799
so we're finally doing our giveaway video for the Western Digital WD 1 tbte

00:00:05.160 --> 00:00:11.160
green ears Advanced format drive if you don't know what an ears Advanced format

00:00:09.480 --> 00:00:15.200
Drive is you should check out my videos I've done a few on this particular Drive

00:00:13.360 --> 00:00:18.960
outlining exactly what Advanced format is basically it's better and it's going

00:00:17.080 --> 00:00:24.039
to enable better storage densities in the future so let's do the giveaway now

00:00:21.880 --> 00:00:30.400
I actually had some questions last time around about how I draw a random winner

00:00:27.560 --> 00:00:33.800
and the way that I do it is like this I use Excel well I would normally use

00:00:32.360 --> 00:00:39.719
Excel except I'm stuck using the cameraman's fail Mac but I'm going to

00:00:36.520 --> 00:00:41.440
use numbers okay and I start with my

00:00:39.719 --> 00:00:45.280
subscriber list so there's no easy way to just take your whole subscriber list

00:00:43.000 --> 00:00:48.840
put it in a hat and draw one unless you have like 10 subscribers but I'm working

00:00:47.440 --> 00:00:54.199
with 14726 subscribers so that's on my NC

00:00:52.000 --> 00:00:58.519
Tech tips Channel basically I take that divide it by 40 because that's how many

00:00:56.239 --> 00:01:04.479
subscribers are displayed on each page so it means I have 3 69 Pages or partial

00:01:01.879 --> 00:01:09.840
pages of subscribers so I go into numbers and I use the ren between

00:01:06.680 --> 00:01:15.360
formula I paste that in okay so I paste

00:01:09.840 --> 00:01:19.960
that under page and I end up with 312 so

00:01:15.360 --> 00:01:22.960
once I have that I take 312 * 40 which

00:01:19.960 --> 00:01:25.520
is going to give me which page I want to

00:01:22.960 --> 00:01:31.920
start on so I'm just going to go back over to YouTube here and we are going to

00:01:28.759 --> 00:01:33.280
start on page AG no that's not right

00:01:31.920 --> 00:01:44.759
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

00:01:40.720 --> 00:01:44.759
yeah okay so start at

00:01:45.960 --> 00:01:52.360
12480 equals okay how could that

00:01:49.759 --> 00:01:55.560
possibly be right no that can't be right oh yeah I guess it's like right near the

00:01:53.799 --> 00:02:00.439
end okay yeah there we go okay so we have a page of subscribers next we are

00:01:57.640 --> 00:02:06.880
going to go to our next sheet in the fail numbers program and we are going to

00:02:03.240 --> 00:02:10.879
pick a Rend between row so we are going

00:02:06.880 --> 00:02:13.640
to find that we are in row number two so

00:02:10.879 --> 00:02:19.120
the winner is going to be one of these 10 people and then for our final formula

00:02:16.920 --> 00:02:24.720
we are going to use Rand between 1 and 10 and we are going to pick a column so

00:02:22.360 --> 00:02:30.599
let's go down to our column spreadsheet here this is a very inelegant way of

00:02:27.360 --> 00:02:33.599
doing it so the winner is paage

00:02:30.599 --> 00:02:37.480
uh whatever page this is row two and

00:02:33.599 --> 00:02:39.920
column four so slug buug is the winner

00:02:37.480 --> 00:02:44.959
as long as he is subscribed to both of my channels which he is so we just go in

00:02:42.800 --> 00:02:50.959
here and verify he is subscribed to both ncixcom and lonus Tech tips he is the

00:02:48.560 --> 00:02:55.959
winner we will get in touch with slug buug 55 and thank you everyone for

00:02:54.080 --> 00:03:00.280
participating and thank you for checking out my video

00:02:58.200 --> 00:03:04.720
blog don't forget this this isn't the only giveaway that I'm working on we're

00:03:02.080 --> 00:03:09.920
also going to be giving away an antech true power Quattro

00:03:06.920 --> 00:03:12.760
1200 I don't want toist that okay antech

00:03:09.920 --> 00:03:18.560
true power Quattro 1200 watt 80 plus silver modular overclocking Edition

00:03:15.640 --> 00:03:24.120
power supply as soon as my video blog which is my lonus tech tips channel

00:03:20.480 --> 00:03:27.799
reaches 10,000 subscribers so right now

00:03:24.120 --> 00:03:29.439
we're sitting at only 9,700 subscribers

00:03:27.799 --> 00:03:33.840
so tell everyone you know to subscribe so that we can draw the winner of the

00:03:31.239 --> 00:03:36.840
true power Quattro 1200 watt