1
00:00:00,480 --> 00:00:07,799
so we're finally doing our giveaway video for the Western Digital WD 1 tbte

2
00:00:05,160 --> 00:00:11,160
green ears Advanced format drive if you don't know what an ears Advanced format

3
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

4
00:00:13,360 --> 00:00:18,960
outlining exactly what Advanced format is basically it's better and it's going

5
00:00:17,080 --> 00:00:24,039
to enable better storage densities in the future so let's do the giveaway now

6
00:00:21,880 --> 00:00:30,400
I actually had some questions last time around about how I draw a random winner

7
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

8
00:00:32,360 --> 00:00:39,719
Excel except I'm stuck using the cameraman's fail Mac but I'm going to

9
00:00:36,520 --> 00:00:41,440
use numbers okay and I start with my

10
00:00:39,719 --> 00:00:45,280
subscriber list so there's no easy way to just take your whole subscriber list

11
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

12
00:00:47,440 --> 00:00:54,199
with 14726 subscribers so that's on my NC

13
00:00:52,000 --> 00:00:58,519
Tech tips Channel basically I take that divide it by 40 because that's how many

14
00:00:56,239 --> 00:01:04,479
subscribers are displayed on each page so it means I have 3 69 Pages or partial

15
00:01:01,879 --> 00:01:09,840
pages of subscribers so I go into numbers and I use the ren between

16
00:01:06,680 --> 00:01:15,360
formula I paste that in okay so I paste

17
00:01:09,840 --> 00:01:19,960
that under page and I end up with 312 so

18
00:01:15,360 --> 00:01:22,960
once I have that I take 312 * 40 which

19
00:01:19,960 --> 00:01:25,520
is going to give me which page I want to

20
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

21
00:01:28,759 --> 00:01:33,280
start on page AG no that's not right

22
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

23
00:01:40,720 --> 00:01:44,759
yeah okay so start at

24
00:01:45,960 --> 00:01:52,360
12480 equals okay how could that

25
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

26
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

27
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

28
00:02:03,240 --> 00:02:10,879
pick a Rend between row so we are going

29
00:02:06,880 --> 00:02:13,640
to find that we are in row number two so

30
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

31
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

32
00:02:22,360 --> 00:02:30,599
let's go down to our column spreadsheet here this is a very inelegant way of

33
00:02:27,360 --> 00:02:33,599
doing it so the winner is paage

34
00:02:30,599 --> 00:02:37,480
uh whatever page this is row two and

35
00:02:33,599 --> 00:02:39,920
column four so slug buug is the winner

36
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

37
00:02:42,800 --> 00:02:50,959
here and verify he is subscribed to both ncixcom and lonus Tech tips he is the

38
00:02:48,560 --> 00:02:55,959
winner we will get in touch with slug buug 55 and thank you everyone for

39
00:02:54,080 --> 00:03:00,280
participating and thank you for checking out my video

40
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

41
00:03:02,080 --> 00:03:09,920
also going to be giving away an antech true power Quattro

42
00:03:06,920 --> 00:03:12,760
1200 I don't want toist that okay antech

43
00:03:09,920 --> 00:03:18,560
true power Quattro 1200 watt 80 plus silver modular overclocking Edition

44
00:03:15,640 --> 00:03:24,120
power supply as soon as my video blog which is my lonus tech tips channel

45
00:03:20,480 --> 00:03:27,799
reaches 10,000 subscribers so right now

46
00:03:24,120 --> 00:03:29,439
we're sitting at only 9,700 subscribers

47
00:03:27,799 --> 00:03:33,840
so tell everyone you know to subscribe so that we can draw the winner of the

48
00:03:31,239 --> 00:03:36,840
true power Quattro 1200 watt