What you used in picking the winner in the art contest
What you used in picking the winner in the art contest
The 6 Best Resources to Randomly Pick Contest Winners
These Tools Make Picking Your Next Contest Winner Both Easy and Fair
Image (c) Materio / Getty Images
Sponsoring giveaways is an effective way to build buzz about products, grow your social media following, and encourage sign-ups to your newsletter. But once your entry period ends, you need to answer an important question: How will you randomly pick your contest winner(s)?
A fair and random winner selection process is vital to end your giveaway on a positive note and avoid accusations of favoritism or fraud. Here are five resources to help you randomly pick a contest winner fairly and easily.
1. Use Google’s Random Number Generator to Pick Winners
Among the many interesting features offered by Google is a random number generator. Using it to pick your winners is easy and free of charge.
To start, assign each of your valid entries a number. One way to do this fairly is to assign a number based on the order in which the entries arrived. So your first entrant would be number one, the second would be number two, and so on.
Then, go to Google.com and search for «random number generator.» This will bring up a box that asks you to enter the minimum and maximum numbers to use. The minimum should be the first number you assigned (probably «1») and the maximum should be the number of total valid entries your giveaway received. Once you have entered these numbers, press the «Generate» button.
If you prefer not to use Google, there are many free random number generators available; just do an internet search to find your favorite.
Whichever generator you use, it’s a smart idea to take a screenshot of the result to document how you randomly picked the contest winner.
2. Use a Random Name Picker for Your Winner Selection Process
If you prefer to pick the contest winner’s name directly rather than assigning a number to each entry, you can use a random name picker like the one offered by MiniWebTool.com.
To use MiniWebTool’s random name picker, enter one name per line into the text field, then click the button to «Pick a Random Name.» One name will be drawn at random to be your winner. Again, you can take a screenshot to document the result.
Of course, typing each name into the text field is time-consuming, but if you’re recording your entries in a spreadsheet, you can save time by copy-pasting the list into the web form.
3. Use Woobox’s «Pick a Winner» Tool to Draw Contest Winners on Social Media
If you’re running a contest on your Facebook page’s timeline, you can use Woobox’s free «Pick a Winner» Tool to randomly choose who’ll walk away with a prize.
To use the tool, sign up for a free account with Woobox and connect it to your Facebook account. Then click the «Posts» tab to select the giveaway post.
Next, select whether comments alone or comments and reactions count as entries. Finally, click the «Pick Winner» button. Take a screenshot of the result.
You can then either contact your winner yourself or upgrade your Woobox account to a paid account so you can use the tool to let them know they won.
Note that you can also use the Pick a Winner tool to randomly choose winners from YouTube or Instagram comments and hashtags.
4. Use YouTube’s «Random Comment Picker» to Choose Winners
If you’re building your YouTube following by offering giveaways to commenters, the YouTube Comment Picker will make randomly picking your winners easy.
To use it, all you need to do is to put in the URL of your video and click the «Search» button.
Once you’ve entered the URL, you click another button to choose the winner. A few seconds later, you’ll have the winning commenter’s name.
5. Use Easypromo’s Instagram Sweepstakes App to Pick Winners from Comments and Hashtags
If you’re running giveaways on Instagram, it can be difficult to keep track of different entry methods like leaving valid comments, sharing the giveaway with friends, and using hashtags to enter. An app like Easypromos’ Instagram Sweepstakes App can help.
This tool not only chooses your winner, it also generates a winner’s list and a certificate of validity to show that the contest was fair.
Your first giveaway made through the Instagram Sweepstakes app is free, giving you the chance to try it out with no risk. You’ll need to purchase a subscription for any additional giveaways after the first.
6 All-in-One Sweepstakes App
Most sweepstakes apps come with a winner selection tool out of the box. Gleam and Rafflecopter, for example, both accept entrants and pick winners at the end of the giveaway.
If you run an Amazon Giveaway, it will also select the winner for you automatically, based on the criteria you set.
The advantage of these services is that not only is winner selection easy, but also, there’s no question of bias or favoritism in the winner selection.
Want to Know More?
If you’re interested in learning more about random numbers, check out these weird and wacky methods that random number generators use to be as unpredictable as possible.
If you’d like to run a raffle rather than a giveaway, check out these tips for running a legal raffle in the United States or Canada.
If you’d like some more help running your giveaway, check out this article on what sweepstakes administrators are and why companies use them. Good luck!
Pick a Winner From a List of Names in Excel
Here’s how I ran a small contest, and what I did to pick a winner from a list of names in Excel.
Facebook Page
Remember the old days, when only the kids belonged to Facebook, and they used it to plan parties, and post embarrassing photos? Well, now almost everybody has signed up, and the kids have probably moved somewhere else, and they’re hoping that we don’t discover where.
I have a personal account, and also created a page for Contextures. I hadn’t done much with that page (okay – nothing), and it had a couple of fans. (Thank you, to those first two fans.)
Over the weekend, I read that pages with 25+ fans could register for a customized URL. That sounded like a fun challenge, so I created my first ever book giveaway event (you need to log in to Facebook to see that page).
The rules were simple — become a fan by Sunday evening, for a chance to win a signed copy of one of my pivot table books (US and Canada mailing addresses only).
Selecting the winner
Since my books are about Excel, it seemed logical that Excel should pick the winning fan. As I explained in the giveaway announcement:
All fan names will be entered in an Excel sheet, and the Rand function will be used to select the winner’s name.
Here’s how I picked the winner:
Excelapalooza!
Well, the giveaway was fun, so I’ll do it again in a couple of weeks.
Or maybe we could organize an Excelapalooza, and everybody with an Excel site or blog could collect names and contribute a prize. Imagine the awesomeness!
______________
16 thoughts on “Pick a Winner From a List of Names in Excel”
Count me in Deb!
Let me chip in:
– A copy of the Pro Excel Dev book
– A copy of Excel VBA programming for dummies
– 3 1 gig USB keys with some give-away tools of mine.
Thanks Jan Karel! We’re off to a great start.
Ooh ahh! I just became your 25th fan, so it looks like you can register for that URL. 🙂
Oh, and count me in for a copy of RibbonX too.
Thanks Ken, for both things. Unfortunately, the Facebook URL signup page now says you need 100 fans!
Oh well, who needs a stinkin’ custom URL anyway? 😉
Oh nice! Nothing like a moving target, eh?
Do you get emails when people become fans? Maybe you should offer a book to the 100th fan then.. and then the 250th, since that will be probably be the next target!
Yeah, I almost had a toe over that finish line, then they yanked it back a couple of miles.
Anyway, I’m very happy to have the fans that I do, and will forget about the custom URL for now.
Your fan count has just gone up by one!
Woohoo! Thanks teylyn. 🙂
Do we have to belong to Facebook to participate in future events? I can only handle one social networking website at a time (LinkedIn is my choice). I joined Facebook briefly to get in touch with some old high school friends, then cancelled.
By the way, my method for random selection (just because I don’t like RAND and sorting) is to use one formula (ATP has to be installed to use RANDBETWEEN in older XL versions). Something like:
Jason, I’ll do another giveaway in Facebook in July, and I’ll also do one here in the blog this summer.
Ken and Jan Karel have generously agreed to participate, and maybe we can get a few more Excel bloggers to join in the fun. I just like saying, “Excelapalooza!”
Методичні вказівки призначені для студентів 2-го курсу спеціальності «Переклад». Вони розраховані на більш вищий рівень знань з теорії та практики перекладу, їх систематизацію, актуалізацію та автоматизацію
Назва | Методичні вказівки призначені для студентів 2-го курсу спеціальності «Переклад». Вони розраховані на більш вищий рівень знань з теорії та практики перекладу, їх систематизацію, актуалізацію та автоматизацію |
Сторінка | 2/4 |
Дата | 24.05.2013 |
Розмір | 318.92 Kb. |
Тип | Методичні вказівки |
1 Translate. Circle the correct answerA many mail B much mail C many mails D much mails A schools are B school is C school are D school’s is A student is B students are C student are D students is A much luggages B many luggages C much luggage D many luggage A Do, student B Does, student C Do, students D Does, students C the other D the another A isn’t a lot of job B aren’t many jobs C isn’t many jobs D aren’t much job А participants in the race do B participant in the race does C participants in the race does D participant in the race does A of lions were B lion was C of the lions was D lions were A railroad tracks, are B railroad’s track, is C railroad tracks, is D railroad’s tracks, are A monkeys were B monkeys was C monkies were D monkies was C his and hers D his and her A seven years old B seven-years-old C seven-year-old D seven year olds A is, computer company B is, computer companies C are, computers companies D are, computer companies 21 What … you used in picking a winner in the art contest? A is the criteria C are the criterion B are the criteria D are the criterions 2 Translate. Cross out the word which should not be in the sentence 1 Very few people can speak the Chinese. 2 Vera is not used to a cold weather. 3 Mark is very good at the painting landscapes. 4 What shall we have for a dinner tonight? 5 He likes all the kinds of modern music. 6 The tennis is one of the oldest sports. 7 They travelled to Nice by a car. 8 The nanny took a great care of the child that had been placed in her charge. 9 The most people are concerned about global warming and its effects. 10 What’s on a TV tonight? 11 He had a serious accident so he’s been in the hospital for two months. 12 He gave me a valuable advice on how to invest my money. 13 The Christmas is time to be merry. 14 It gives me a great pleasure to welcome you to our hotel. 15 Our daughter was nervous on her first day at the school. 16 We’ve got a plenty of time spare before the show begins. 17 The Sir Lawrence Oliver was born in Britain in 1907 18 We decided to meet at the Victoria Station. 19 I ran into an old friend on my way to the work this morning. 20 Bats come out at the night. ^ 3 Translate. Cross out the word which should not be in the sentence 1 My sister she gave birth to a lovely baby last week. 2 There he is a man at the door. It must be the postman. 3 Our children want themselves to go camping this summer; what about yours? 4 We felt ourselves relieved when the plane landed at the airport. 5 “This it is your captain speaking. Welcome on board!” 6 He kept talking about how so expensive their holiday had turned out to be. 7 She spent the all morning buying gifts for her family. 8 Computers are not easy to use them unless you know the software. 9 There it seems that we are in for a long hot summer. 10 The manager wants all of applicants to be called for an interview. 11 She likes to wake up herself early in the morning. 12 We haven’t got an our own camera but we intend to buy one. 13 If anyone person arrives late, they will not be allowed to enter the room. 14 You can call on us any one day you want. 15 He’s got a little patience so he wouldn’t be any good at teaching. 16 These books are out of print but the others ones are available. 17 He could very hardly understand what was going on. 18 Every one employee has to clock in at 9-00. 19 All that we can do it is to wait for their phone call. 20 Unless the both parties agree to share discussions, there won’t be any progress. 21 Neither of the teacher nor the students enjoyed the trip to Aspen. 22 We know a very few people here so we feel lonely at times. 23 A lot of people gathered at the airport to welcome the Olympic winners. 24 Would you like to spend the whole all month with us? 25 Some people enjoy going to the opera but others themselves don’t. ^ 4 Translate. Complete the paragraph with a, an, the or no article A day in the life of an ordinary man. This morning I woke up around ten, I made …(1)… cup of coffee, took it into …(2)… bedroom and put it on …(3)… table next to …(4)… bed, on …(5)… side my wife sleeps on. I go through this ritual twice …(6)… week – I do it on …(7)… Saturday and …(8)… Sunday mornings. On …(9)… other days of …(10)… week, we go to …(11)… work at different time and I always get up first to get …(12)… kids ready for …(13)… school. I drop them off outside …(14)… school which is an old Victorian building on the corner of …(15)… Hill Road, and then go straight to …(16)… work. I work in …(17)… office in …(18)… city center and I always have …(19)… problem finding …(20)… parking space. My wife says I’m always complaining about …(21)… traffic and the pollution, which is true – you see. I grew up in …(22)… country, close to …(23)… nature and I have never got used to living in …(24)… city. I think the only thing I would miss about not living in …(25)… big city like this is going to …(26)… concerts of all kinds. I love rock and classical music, too, and occasionally we go out and have …(2)… cinema, which I am particularly keep on. I also like …(2)… good food and occasionally we go out and have …(24)… dinner in a nice restaurant, but most of the time we eat at …(24)… home, where food is delicious – except when I make it!
^ 5 Translate. Vocabulary. Circle the correct answer 2 After his … the insurance company refused to pay his life insurance policy. 3 There are … countries that use Cyrillic. A the other B the others C other D others 4 Could you give me … book to read, this one is not informative. A other B another C an other D the other. How to win the PBR Can Art Contest, from 4 artists who did itShare this article!While the brief is packed full of useful guidelines, sometimes it helps to hear straight from the horse’s mouth. So we have enlisted four previous winners of the PBR can contest to give you the inside scoop on how they went from staring at a blank page to becoming a competition winner. 1. Immerse yourself in the PBR brand“I had been a fan of PBR already because of their involvement and support of art and artists,” explains Tenbeete Solomon. “So I really just wanted to get my name in front of them to hopefully work together in the future.” “I was no stranger to PBR’s product,” adds Denton Burrows. “Living in the expensive city of New York, it has always been a cheaper and refreshing go-to beer for me. Additionally, I always enjoyed the vibe of the bars where I found PBR; dive bars, dark, live music, graffiti in the bathrooms. All that came together to make me think my style might have a chance with their contest and product.” Stefan Mallette’s winning designIn testament to the power of perseverance, Stefan Mallette submitted three years in a row before his design was selected as a winner. He explains, “All three years of submissions were different in style and content, but had the same underlying theme. I wanted to create lore for the brand.” 2. Put *yourself* into the designTenbeete’s starting advice is to look at your own work before anything else. “I tried to imagine how I would want the can to look that would both represent myself and the brand, as well as make someone want to pick it up off a shelf.” Only after that are you ready to seek inspiration elsewhere. “I then looked at the past winners and their work, and just other artists PBR had worked with or highlighted. There was a lot of diversity in styles and mediums. It really reinforced the idea that I could do it my way.” Tenbeete’s winning can design seen on shelves in the wild“It’s about using your voice as a filter for what’s provided,” adds Charles Kendall. “In the context of this challenge, it was about coming up with what the client’s goals might be. Since it’s not a 1:1 commission, the goals aren’t spoken to you. There’s some detective work to be done.” 3. Trust the processEvery artist’s process is different, otherwise, where is the fun? For Denton it all starts with visual and verbal research, collecting imagery and words that evoke visuals until a concept starts to form. “Maybe sneak something related in that they are not expecting but that works well.” Verbal communication is also important to Charles. “ Personally I look for words that tell a story. Or words that are calling out to be crafted into a story. Sometimes there are gaps that need to be filled in, but that is remedied by research into the brand and what they are, where they’ve come from, where they are going, and the community they’re creating.” For Tenbeete, the two key factors are objective and communication. “ I figure out the main objective and what is important for me to communicate, and let those two factors work together.” She notes, “I try not to get caught up on either factor, as it’s easy to get tunnel vision with your own work. I step back in the process and ask myself why I made these decisions, did I try something unexpected or look at options, or just get stuck on my first idea. You have to remind yourself that nothing is permanent and that’s why it’s called a process.” “Trust in your ability to be you,” adds Stefan. “That’s the best tool all creatives have. Easier said than done of course.” 4. Remember, there is no right or wrong in artOur winners are as diverse in style as they are in medium.“My PBR winning submission was created entirely with ink and colored pencil and then scanned in high resolution for submission,» Denton tells Talenthouse. “That was primarily how I was working at the time. I still work this way and also do some illustration projects with a combination of ink and digital color and finishing.” “For this piece, I used photoshop,” explains Stefan. “I began by creating a halftone pattern from the photo. I was originally going for a different concept but ended up using the custom halftone because I loved the unique texture it brought to the piece.” Denton Burrows’ winning can designAlternatively, Tenbeete’s submission was created in Adobe Illustrator. Being able to apply your creativity within the limitations of the brief requires balance, explains Tenbeete. “ I don’t necessarily believe in rules in art, but I appreciate the structure and purpose they can give a project. So knowing that I’m not tied to a brief, but am using it to do my best work is a helpful approach.” In a similar vein, Charles refuses to limit himself to one medium, working with pencil, paper, pen and ink, and digital. “There’s always a way to shine the work beyond the limitations of the brief,” he notes. “They are simply tracks for a train that can be built in any way possible.” 5. Believe that great things are coming your way“I remember that I was standing in line for opening night of The Dark Night when I got the call,” explains Denton. “I was honestly over the moon. I had won a few small things here and there but nothing of that magnitude. Winning it has certainly had an impact on my career. I got to do other things for PBR that year and it added a level of legitimacy to my early illustration career that undoubtedly helped me get other jobs and make important connections I still have today.” “Winning was amazing,“ says Stefan. “Being able to find my design on shelves. I’ll always look back at this win as a great landmark in my career “Definitely a major highlight in my career,” also describes Tenbeete. “It let me see myself and my work in a way I had never before. It made me want to do more, go bigger, and take more risks. I want to inspire other artists to take chances and I always say ‘don’t cancel yourself out.'» 9 Ways To Pick A Contest Winner So Everyone Is Happy As a digital marketer, you’re not in the business of keeping everyone happy… we get that. But, at the same time, no one likes disgruntled customers! When planning a contest, you walk a knife’s edge between bliss and destruction. The winners are ecstatic and the not-so-lucky participants feel deflated and in some cases “ripped off.” At the end of the day, you are running a contest to build awareness for your business, generate leads, and develop long-term trust with prospects, so the last thing you want is for this effect to be reversed. There are a number of ways to pick a contest winner that are both fair and transparent, and for the most part, keep everyone involved happy, even if they don’t win. When I say everyone, I’m not just talking about the contest participants either. Your team and business are stakeholders in this scenario too. So it’s important to progress towards the objectives you set out to achieve with this interactive marketing campaign. Whether they are driven by branding, lead generation, sales, or customer success. As well as meeting your customers’ expectations. So, how do you pick a contest winner that keeps as many stakeholders as possible happy? Here are 9 ways: 1. Social engagementSocial engagement contests are fun and easy. You can use your social timeline to determine who commented, liked, or who enticed others to do the same, to determine a winner. If you are using a contest app, this makes it even easier. Your social friends will enjoy competing for a prize, and you will probably gain more followers in the process. Judging a contest winner by social engagement comes with little friction because it is subjective. Subjectivity is critical to keeping everyone happy. 2. Judging panelA judging panel is an effective way to choose a winner for your contest. With this approach, contestants submit their contest application and a roundtable of judges give their feedback and deliberate on which entry is the best. An example of this can be seen below from Canadian fishing retailer Rapala. Their well-known photo contest is judged by “a Rapala jury.” Example of a contest with a judging panel. The only problem with the judging panel approach to determining a winner is that some participants may feel the judges are biased. You can balance this perspective out by including the wider audience in the final winner selection. Once the entries are accumulated, you can share their entries on social media and have the audience provide votes and arguments on which ones are the best. 3. At randomRandomly selecting a contest winner is without a doubt the most subjective method. But it’s so subjective that some people think the subjectiveness is fake. I know … sometimes you just can’t win! The key to making the selection of a winner truly random is to leverage contest software to handle it for you. Taking humans out of the equation removes any unwanted bias and gives participants confidence that they have just as much chance to win as the next entrant. 4. Popular voteMuch like the hybrid judging panel-audience selection method I mentioned above, this one takes the process public. This approach works best when entrants submit something that can be judged – such as a video, picture, or another piece of content based on a pre-set brief. Each participant is given a unique link to share their submission and have people vote for them. The person with the most votes wins the prize. Simple. Below is an example of a popular vote contest by Live Nation for P!nk tickets: An example of a contest where the winner is determined by popular vote. This way of picking a winner is a bit like a popularity contest. So, rightly or wrongly, some participants may feel like the quality of their submission is less important than their ability to attract votes. In saying that, it’s hard to argue about the subjectivity of this approach. After all, you aren’t picking a winner by yourself! 5. Referral entriesThis type of contest encourages participants to share the contest with a custom link, which is automatically generated by the contest software. For each new person who uses the unique link to sign up for the contest, the original participant acquires a point. At the end of the contest, the person with the most points (referrals) wins the top prize. Choosing a winner based on referrals is a popular one with marketers because it organically encourages shares and contest sign-ups, which increases the contest’s reach. If done well this type of contest can go viral. However, much like the “Popular Vote” contest, this becomes a bit of a popularity contest determined by the reach and influence of an individual participant. Either way, just like the previous point, you can’t argue with its subjectivity. 6. Multiple winnersSome contests give away a number of prizes. These may be tiered prizes, all the same prize, or a regular prize, such as a weekly winner. This style of contest naturally keeps more people happy because you have more winners! Here is a contest run by Wreaths of America that has three winners: Example of a contest with multiple winners. However, you may still come under scrutiny when determining a fair winner, even though there are several winners. The criteria can be based on how many shares, referrals, or a combination of things to get the most entrants into the contest – but consider the approach with the least amount of friction given your unique situation. 7. Answers to a quizMarketing quizzes can unlock information about your potential customers more than almost any other form of marketing. They’re interactive, engaging, and intriguing-ly packed with qualifying questions. But they are also extremely enticing for potential contest participants. Participants see quizzes as an enjoyable experience that ends with them seeing their quiz results. Human beings hold a deeply embedded desire to attain results and compare them with our peers. The contest below from Jarlsberg, a cheese producer, uses a quiz to entice people to enter their contest: A quiz-based contest. To top it all off, contests camouflaged as quizzes are a sneaky way to keep everyone happy. The entry to the contest is secondary to the interactive experience and results they receive. You attain valuable data about your customers, the customers have a good ‘ol time completing the quiz, and believe it or not… everyone is happy! 8. Daily, weekly, or monthly winnersJust as it sounds this type of contest rewards entrants with the chance to win more than once. It may be every day, week, month, or some other predetermined time frame. A number of companies use this form of contest to boost participation and sales during holidays or other events like back-to-school. When there is a chance to win a prize on a regular basis, contestants make a point to enter on a continual basis so their name will always be in the pool of possible winners. Naturally, the chance to win more than once is attractive to entrants, and because there is more than one winner, more people are happy. As with some of the other tips in this post, there is an underlying risk. If someone enters the same contest multiple times and still doesn’t win, they may become disgruntled. So there is a strategic balancing act between keeping the contest running for long enough to pique interest, without keeping it open for too long and losing engagement. This is one reason you may choose to reward everyone that enters with a special offer or discount. 9. Best entry (photo, written, or design submissions)The “best entry” contest is a longstanding favorite for companies of all shapes and sizes. It gives entrants the opportunity to showcase their creative skills for what is often a unique and compelling prize. Examples include a product naming contest or a design contest for a new product. Below is Oreo’s now famous “New Flavor” contest: Oreo’s new flavor contest. The problem with best-entry contests is deciding who determines what constitutes the “best” entry. Whether this is based on a set of published quality criteria or the intuition or a judging panel, there is room for backlash and unhappy contestants. So, if you go down this path make sure you consider these risks and be as clear as possible with the winning criteria and stating who will select the best entry. Additional tips for keeping contest stakeholders happyKeeping everyone happy when you run a contest isn’t only about how you choose the winner. So, here are 5 more tips: Ready to run your next contest? How will you keep everyone happy?It’s free and we don’t need your credit card. Источники информации:
|