2016 Spreadsheet of all the Black Friday deals

All Site Suggestions or General Black Friday Tips

Moderators: Tony, Huy, cematra173, killasnake

Rajeshsp3691
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 3:19 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby Rajeshsp3691 » Mon Nov 14, 2016 3:24 pm

Hi ,

Can i get the password for the sheet pls.

avikanal
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 3:38 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby avikanal » Mon Nov 14, 2016 3:40 pm

Hey thanks so much for putting this together - pls send me the user/pass :)

Thanks
Avi

synaptix
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 3:58 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby synaptix » Mon Nov 14, 2016 4:01 pm

Another refugee from that "other site". All this time I thought I knew the original author! Shame on me.
Interested in the User name and password please. You do a great service to those of us dedicated to the Black Friday arts!

User avatar
bfaddict
Black Friday Pro
Posts: 4808
Joined: Thu Nov 16, 2006 4:19 pm
Contact:

Re: 2016 Spreadsheet of all the Black Friday deals

Postby bfaddict » Mon Nov 14, 2016 4:14 pm

Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?

User avatar
teknoge3k
Forum geek
Posts: 10694
Joined: Tue Oct 07, 2008 9:57 am
Location: Virginia
Contact:

Re: 2016 Spreadsheet of all the Black Friday deals

Postby teknoge3k » Mon Nov 14, 2016 4:41 pm

The username should be "thisspreadsheetwasstolenfrombfads.net" lol
That moment you realize that Bruce Jenner is Kanye Wests' mother in-law

facebook.com/teknoge3k
twitter.com/teknoge3k

MyOtherDealisAford
Black Friday Newbie
Posts: 3
Joined: Mon Nov 14, 2016 12:08 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby MyOtherDealisAford » Mon Nov 14, 2016 4:44 pm

bfaddict wrote:Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?

I could but you voted me to not get a copy of the list...

Dell070
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 4:52 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby Dell070 » Mon Nov 14, 2016 4:55 pm

Can you share the credentials to open the spreadsheet... thanks in advance

User avatar
bfaddict
Black Friday Pro
Posts: 4808
Joined: Thu Nov 16, 2006 4:19 pm
Contact:

Re: 2016 Spreadsheet of all the Black Friday deals

Postby bfaddict » Mon Nov 14, 2016 4:58 pm

MyOtherDealisAford wrote:
bfaddict wrote:Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?

I could but you voted me to not get a copy of the list...


ha! you got me there. but now we know you're real (i think) lol

MyOtherDealisAford
Black Friday Newbie
Posts: 3
Joined: Mon Nov 14, 2016 12:08 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby MyOtherDealisAford » Mon Nov 14, 2016 5:16 pm

bfaddict wrote:
MyOtherDealisAford wrote:
bfaddict wrote:Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?

I could but you voted me to not get a copy of the list...


ha! you got me there. but now we know you're real (i think) lol


A quick n dirty way to do it would be to also filter out anything less than $39.99. or whatever is the cheapest one available.

There are other ways but its a lot to type

User avatar
bfaddict
Black Friday Pro
Posts: 4808
Joined: Thu Nov 16, 2006 4:19 pm
Contact:

Re: 2016 Spreadsheet of all the Black Friday deals

Postby bfaddict » Mon Nov 14, 2016 5:22 pm

MyOtherDealisAford wrote:
bfaddict wrote:
MyOtherDealisAford wrote:I could but you voted me to not get a copy of the list...


ha! you got me there. but now we know you're real (i think) lol


A quick n dirty way to do it would be to also filter out anything less than $39.99. or whatever is the cheapest one available.

There are other ways but its a lot to type


Thank you! I will give that a shot.
I now vote to give you access lol

User avatar
hiker
Official Zipper
Posts: 3702
Joined: Wed Nov 23, 2005 4:07 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby hiker » Mon Nov 14, 2016 5:52 pm

bfaddict wrote:Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?


Do a search for bluray-player

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby Shopper X » Mon Nov 14, 2016 6:09 pm

teknoge3k wrote:Personally, I wouldn't give the information out to anyone who isn't an established forum regular. If a user doesn't have over X amount of posts, tough luck.

Many (actually most) of the people who have asked me for the password have been ones with a new account, created a few minutes before PMing me. Quite a few of those people have said that they've been using the bfads.net site for a number of years and have just never signed up to use the forums-- and, I believe them. There are a number of forums that I do the same thing on-- lurk and read but not post. So, I'm not inclined to adopt a "no new accounts" restriction.

Since the issue was exposed on the other site's forum, I imagine that the plagiarist might stop and this will no longer be an issue. If so, then I can remove the password protection (which would make things easier for me). Though, having the password seems to have been good for raising awareness/visibility of bfads.net. I don't like making people jump through hoops (having to register here just to be able to get the spreadsheet), but perhaps it will bring in new participating members. That would be good for the site. The Bfads.net web site is the one who actually pays people to type in all the adscan item listings that allow the spreadsheet to exist.

(The rest of this post are more notes to myself, for next year when I forget how the spreadsheet-generating scripts work.)

One thing that was unexpected is that the amount of time it takes to retrieve the deals for a store increases exponentially based on the number of items. Examples:
costco... (70 items, 14s)
walmart... (610 items, 75s)
jcpenney... (970 items, 2m 33s (153s))
shopko... (1110 items, 3m 8s (188s))
bonton... (1650 items, 8m 14s (494s))
boscovs... (1930 items, 12m 19s (739s))
I imagine that a hypothetical 2200 item ad might take 20 minutes to retrieve. I'm not sure why this happens. It must be some artifact of how PhantomJS or CasperJS works. Having a default 300 second timeout works for most ads. However, for larger ads the timeout value needs to be overridden and manually hardcoded in the script.

User avatar
Shopper X
Suspected Line Jumper
Posts: 2637
Joined: Wed Nov 16, 2005 6:05 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby Shopper X » Mon Nov 14, 2016 6:18 pm

bfaddict wrote:Can someone give me some tips on how I can filter/search for bluray players in the list without also getting all the bluray dvds included in that?

All the Blu-Ray players seem to be in the "Home Theatre >> Blu-ray Players" category, so searching only in that specific category might do the trick.

This support article has instructions on how to apply filters in Excel:
https://support.office.com/en-us/articl ... c37dcc180e

If you are working in some sort of Unix environment, like on a Mac computer using Terminal, you can also do something like "cat deals.csv | egrep -i blu | egrep -i ray | egrep -i player ".

Vb94555
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 6:31 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby Vb94555 » Mon Nov 14, 2016 6:34 pm

Can I get the username and password please?

sid85
Black Friday Newbie
Posts: 1
Joined: Mon Nov 14, 2016 6:54 pm

Re: 2016 Spreadsheet of all the Black Friday deals

Postby sid85 » Mon Nov 14, 2016 6:58 pm

Please pm me user name and password.


Return to “Suggestions and Tips”

Who is online

Users browsing this forum: No registered users and 1 guest