Topic Wiki

DDFers with raffle entries:
as2: 2
sillypainter: 1
Yaalili: 1
tmendy226: 1
a good yeshiva bachur: 1
crony: 1
Zevi16: 1
ruv: 2
mendyt: 1
EJB:

https://www.dansdeals.com/advertisement/enter-win-twin-cabin-aboard-journey-lifetime-antarctica-5000-cash-private-consult-supporting-chabad-cleveland/

https://www.chabadofcleveland.com/templates/articlecco_cdo/aid/4096324/jewish/Antarctica-Cruise-Raffle.htm

Add your name if you will purchase a $100 raffle ticket for the Antarctica trip.

If you will buy more than 1 write it next to your user name:


1 - CM
2 - yossig
3 - JoeyShmoe
4 - Yitzyul 
5 - Wizmanison (2)
6 - Bentzy
7-  mendyt
8-  jes
9- nafnaf12
10- lubaby (2)
12-abey
13- Z56
14 - crony
15 - stever (2)
« Last edited by EJB on August 16, 2018, 02:37:35 AM »

Poll

Which amount and format would you buy in at? (vote for one of each)

50%+ to Charity
11 (8.7%)
10-15% to Charity
3 (2.4%)
Any amount to Charity
18 (14.3%)
I don't care if my money goes to charity
19 (15.1%)
Variable ticket prices $1-$360 chosen at random
11 (8.7%)
I wouldn't buy in at more than $150-$180
10 (7.9%)
I wouldn't buy in at more than $100-$150
15 (11.9%)
$100 is my max
39 (31%)

Total Members Voted: 85

Author Topic: Antarctica Cruise Raffle  (Read 106997 times)

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #560 on: August 24, 2018, 11:29:03 AM »
It did, but it gave each purchase a line.
Now they have to expand it according to how many tickets were bought by each person.
Which takes a total of one minute and isn’t necessary if you know how to use excel

Offline Dan

  • Administrator
  • Dansdeals Lifetime 50K Diamond Elite
  • **********
  • Join Date: May 2008
  • Posts: 67601
  • Total likes: 16913
  • DansDeals.com Hat Tips 16442
  • Gender: Male
    • View Profile
  • Location: CLE
  • Programs: UA GS, AA EXP, DL Dirt, Hyatt Glob, Fairmont Lifetime Plat, DD Diamond, Blocked By @NeriaKraus
Re: Now Live! Antarctica Cruise Raffle
« Reply #561 on: August 24, 2018, 11:33:45 AM »
Which takes a total of one minute and isn’t necessary if you know how to use excel
Unlikely the shul has any excel mavens and no offence, but I'm not sure it makes sense to hand over the raffle to someone who has entries in it.
Save your time, I don't answer PM. Post it in the forum and a dedicated DDF'er will get back to you as soon as possible.

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #562 on: August 24, 2018, 11:35:30 AM »
Unlikely the shul has any excel mavens and no offence, but I'm not sure it makes sense to hand over the raffle to someone who has entries in it.
It was worth a shot. Friday is a lucky day for me

Offline ExGingi

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: Nov 2015
  • Posts: 15633
  • Total likes: 7720
  • DansDeals.com Hat Tips 19
    • View Profile
  • Location: 770
  • Programs: בשורת הגאולה. From Exile to Redemption. GIYF. AAdvantage Executive Platinum®
Re: Now Live! Antarctica Cruise Raffle
« Reply #563 on: August 24, 2018, 11:36:05 AM »
Unlikely the shul has any excel mavens and no offence, but I'm not sure it makes sense to hand over the raffle to someone who has entries in it.

Just hand a spreadsheet with a few dummy entries showing what it looks like to someone who knows excel, and you can have them write a quick macro to do what needs to be done.

Would have made sense to take care of this in advance, but then again...

ETA: see responses here. Though you need to understand a little in order to figure out what the solution is.

Or read here for a few solutions: https://www.excelforum.com/excel-programming-vba-macros/958999-weighted-random-number-generator-for-raffle.html
« Last Edit: August 24, 2018, 11:42:55 AM by ExGingi »
I've been waiting over 5 years with bated breath for someone to say that!
-- Dan

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #564 on: August 24, 2018, 11:37:50 AM »
I’d be happy to take an anonymized version of the entries and convert it to a tool that can be used to randomize the selections if you have a need.

Offline Z56

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Dec 2014
  • Posts: 2420
  • Total likes: 100
  • DansDeals.com Hat Tips 2
    • View Profile
  • Location: NYC, TLV
  • Programs: SPG Gold, Marriot Gold, Hilton Gold, National EE, Hertz GP, Avis PP
Re: Now Live! Antarctica Cruise Raffle
« Reply #565 on: August 24, 2018, 12:17:54 PM »
I’d be happy to take an anonymized version of the entries and convert it to a tool that can be used to randomize the selections if you have a need.


Someone is ready to win
“I have nothing in common with lazy people who blame others for their lack of success. Great things come from hard work

Offline @Yehuda

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Oct 2013
  • Posts: 9693
  • Total likes: 187
  • DansDeals.com Hat Tips 5
  • Gender: Male
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #566 on: August 24, 2018, 12:25:32 PM »
It did, but it gave each purchase a line.
Now they have to expand it according to how many tickets were bought by each person.
Understood. Should be able to get someone from the Excel thread to do it (I assume at least one of those gurus didn't buy an entry).

Offline whYME

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2008
  • Posts: 3213
  • Total likes: 1241
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #567 on: August 24, 2018, 12:43:03 PM »
Which takes a total of one minute and isn’t necessary

That got me thinking.

This should be a quick & dirty solution (I'm not sure if this is what @EJB had in mind)

Lets say the number of tickets purchased are in column A, starting From row 2. Add 2 columns, let's say E&F.
In F put
Code: [Select]
=A2+F1And in E put
Code: [Select]
=F2-(A2-1)This will give you the range of ticket numbers for each purchase, Column E through column F


Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #568 on: August 24, 2018, 12:51:20 PM »
That got me thinking.

This should be a quick & dirty solution (I'm not sure if this is what @EJB had in mind)

Lets say the number of tickets purchased are in column A, starting From row 2. Add 2 columns, let's say E&F.
In F put
Code: [Select]
=A2+F1And in E put
Code: [Select]
=F2-(A2-1)This will give you the range of ticket numbers for each purchase, Column E through column F



Similar, but see attached for something I made in literally 30 seconds.

Add the names and number of tickets they bought in columns A and B
Column C calculates a running total of the ticket #s
F2 randomly draws a number between 1 and the total of the tickets purchased. Every time you press F9 it will redraw until my ticket wins.

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #569 on: August 24, 2018, 12:54:23 PM »
Similar, but see attached for something I made in literally 30 seconds.

Add the names and number of tickets they bought in columns A and B
Column C calculates a running total of the ticket #s
F2 randomly draws a number between 1 and the total of the tickets purchased. Every time you press F9 it will redraw until my ticket wins.
And yes, you can calculate a min and max # for each person pretty easily as whyme did

Offline whYME

  • Dansdeals Presidential Platinum Elite
  • ********
  • Join Date: May 2008
  • Posts: 3213
  • Total likes: 1241
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #570 on: August 24, 2018, 01:04:52 PM »
And in E put
Code: [Select]
=F2-(A2-1)
Actually  this shoulda just been
Code: [Select]
=F1+1I knew I was overcomplicating it...

Offline MosheD

  • Dansdeals Lifetime Platinum Elite
  • *******
  • Join Date: Aug 2011
  • Posts: 2275
  • Total likes: 40
  • DansDeals.com Hat Tips 3
  • Gender: Male
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #571 on: August 24, 2018, 05:09:22 PM »
Unlikely the shul has any excel mavens

What? Id ve shocked if they didnt, lots of professions require excel

Offline Dan

  • Administrator
  • Dansdeals Lifetime 50K Diamond Elite
  • **********
  • Join Date: May 2008
  • Posts: 67601
  • Total likes: 16913
  • DansDeals.com Hat Tips 16442
  • Gender: Male
    • View Profile
  • Location: CLE
  • Programs: UA GS, AA EXP, DL Dirt, Hyatt Glob, Fairmont Lifetime Plat, DD Diamond, Blocked By @NeriaKraus
Re: Now Live! Antarctica Cruise Raffle
« Reply #572 on: August 24, 2018, 05:16:49 PM »
What? Id ve shocked if they didnt, lots of professions require excel
There is one. He can do it tomorrow when he's not working :P
Save your time, I don't answer PM. Post it in the forum and a dedicated DDF'er will get back to you as soon as possible.

Offline 12HRS

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Jun 2013
  • Posts: 5108
  • Total likes: 575
  • DansDeals.com Hat Tips 6
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #573 on: August 24, 2018, 05:19:33 PM »
There is one. He can do it tomorrow when he's not working :P

Makes it sound like they are not willing to use their own employees time for this raffle...

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #574 on: August 24, 2018, 06:19:35 PM »
Makes it sound like they are not willing to use their own employees time for this raffle...
Or they have no incentive to do it earlier

Offline sky121

  • Dansdeals Lifetime 10K Presidential Platinum Elite
  • *******
  • Join Date: May 2011
  • Posts: 11513
  • Total likes: 168
  • DansDeals.com Hat Tips 12
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #575 on: August 24, 2018, 06:20:05 PM »
Is there a cash option in the end if someone doesn't want to take the trip?
"Not all who wander are lost"

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #576 on: August 24, 2018, 06:21:51 PM »
Is there a cash option in the end if someone doesn't want to take the trip?
/ is the prize transferrable?

Offline Dan

  • Administrator
  • Dansdeals Lifetime 50K Diamond Elite
  • **********
  • Join Date: May 2008
  • Posts: 67601
  • Total likes: 16913
  • DansDeals.com Hat Tips 16442
  • Gender: Male
    • View Profile
  • Location: CLE
  • Programs: UA GS, AA EXP, DL Dirt, Hyatt Glob, Fairmont Lifetime Plat, DD Diamond, Blocked By @NeriaKraus
Re: Now Live! Antarctica Cruise Raffle
« Reply #577 on: August 24, 2018, 06:22:36 PM »
Is there a cash option in the end if someone doesn't want to take the trip?
Sell it to a DDFer?
Save your time, I don't answer PM. Post it in the forum and a dedicated DDF'er will get back to you as soon as possible.

Offline Dan

  • Administrator
  • Dansdeals Lifetime 50K Diamond Elite
  • **********
  • Join Date: May 2008
  • Posts: 67601
  • Total likes: 16913
  • DansDeals.com Hat Tips 16442
  • Gender: Male
    • View Profile
  • Location: CLE
  • Programs: UA GS, AA EXP, DL Dirt, Hyatt Glob, Fairmont Lifetime Plat, DD Diamond, Blocked By @NeriaKraus
Re: Now Live! Antarctica Cruise Raffle
« Reply #578 on: August 24, 2018, 06:22:42 PM »
/ is the prize transferrable?
Yes.
Save your time, I don't answer PM. Post it in the forum and a dedicated DDF'er will get back to you as soon as possible.

Offline EJB

  • Dansdeals Lifetime Presidential Platinum Elite
  • *********
  • Join Date: Sep 2012
  • Posts: 5409
  • Total likes: 254
  • DansDeals.com Hat Tips 15
    • View Profile
Re: Now Live! Antarctica Cruise Raffle
« Reply #579 on: August 24, 2018, 06:23:37 PM »
Sell it to a DDFer?
So you can sell it on ddf?