Raffle Drawing Methods

The purpose of this exercise is to clean the raffle data set and prepare it to be imported to the randomizer.  Spelling errors and other integrity issues require attention and cannot be corrected using the webpage interface (Zeffy online platform).

Step 1 Get Zeffy Ticket Sales

Export Zeffy Tickets List to White Mountain Raffle_Ticket List_FINAL.xlsx;

SELECT ALL FIELDS EXCEPT Guest Name (redundant attribute).

Buyer: Primary purchase Name

Ticket: # is the individual ticket number purchased in Zeffy.

Question & Notes: Used to add/assign paper ticket sales to the Zeffy data set.

Note: Ruthie took advantage of the 3 for $25 bundle and her ticket numbers are 30, 31, 32. If it was a paper ticket sale, the paper ticket number appears in questions and notes as seen with the transactions for Cheryl and Mandy.

Step 2 Clean and Convert Data File from Excel to CSV

Export is an excel .xlsx file.  The raffle drawing platform requires a .csv file.  Prior to conversion to .csv, the data is cleaned as follows:

1. Update all entries for paper tickets where the ticket number was misreported as TTH-xx and should be THH-xx.
2. Delete rows in the excel file where ticket status = ‘Canceled’
3. Remove any duplicate rows.
4. Add column “Buyer” with formula =CONCAT(LEFT(A2,FIND(” “,A2)-1),MID(A2,FIND(” “,A2),2))
5. Save file as “Getaway Raffle 20251231.csv”

Step 3 Prepare and Execute Raffle Drawing Platform

Go to https://randomizer.uk/draw-with-many-participants#

1. Import .csv file previously saved.
2. Set Parameters
   • Number of Winners =1
   • Columns to use (all except Guest Name)
   • Winner Identifiers Setting (Columns to use (3))
     • Buyer (H)
     • Ticket number (C)
     • Ticket Notes (F)

Exclude sheet column headings (first row)and perform drawing.