2 years, 2 months ago
Is there a Mac program/Excel technique to score multiple entries for an Oscar prediction contest?
I'm running an Oscar prediction contest, and I'm looking for a way to organize and score all of the entries at once during the actual awards ceremony. Here's what I need:
I have several contestants sending in ballots. For each Oscar category, they fill in two responses: The nominee they want to win, and the nominee they think will win. That means that for every person who enters, there will be 24 categories, and 48 answers total. I would like to have a program into which I can enter all of the data ahead of time, and then as the winners are announced, I can plug in the correct answer and it will automatically tally up the points. (both answers in each category have different point values).
I know it sounds complicated, but I'd like to think that there is some way to do this easily other than printing out 20+ ballots and marking each one by hand. Any help?
I have several contestants sending in ballots. For each Oscar category, they fill in two responses: The nominee they want to win, and the nominee they think will win. That means that for every person who enters, there will be 24 categories, and 48 answers total. I would like to have a program into which I can enter all of the data ahead of time, and then as the winners are announced, I can plug in the correct answer and it will automatically tally up the points. (both answers in each category have different point values).
I know it sounds complicated, but I'd like to think that there is some way to do this easily other than printing out 20+ ballots and marking each one by hand. Any help?
Separate topics with commas, or by pressing return. Use the delete or backspace key to edit or remove existing topics.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$1 Answer
I can think of a way to do it in Excel:
If you open up a spreadsheet, you can use a column (up and down) for each contestant. Use the row as the place for the category.
For instance: Bob Best movie ..... Best actor .....
Not sure if the formatting will show up in the actual answer.
In any case, you can do this for Bob 1 and Bob 2 (since each has two selections). Make sure that when you're entering in the names, you make them consistent. Excel has an auto-fill function for strings they have already seen so make sure to use that.
Once you're done filling out the categories, at the end, you can fill in the winners. (So the last column is all the actual winners)
Once you've done that, you can compare each of the contestant's selections with the actual winners and tally up the correct selections.
You can do this by using a formula:
=if(exact(A1,Z1),1,0)
Let me explain the formula to you:
if ( condition, value if true, value if false) - the if function looks at the condition. If it's true, it will return the value if true; if not, the value if false.
In our case, if there's a match between the contestant's selection (say cell A1) and the actual winner (say cell Z1) then it will return 1, otherwise it will return 0.
All you have to do to get the other 23 categories is to drag and drop the corner of the cell down (this will change A1 and Z1 to A2 and Z2 for the cell below). Then, you can easily copy and paste for all your other ballots and then tally up the totals by going to the bottom and using the formula
=Sum(A1:A24) (say your categories are from row 1 to row 24).
I realize this is pretty complicated but maybe setting it up in the spreadsheet will let you compare the entries quicker.
If you open up a spreadsheet, you can use a column (up and down) for each contestant. Use the row as the place for the category.
For instance: Bob Best movie ..... Best actor .....
Not sure if the formatting will show up in the actual answer.
In any case, you can do this for Bob 1 and Bob 2 (since each has two selections). Make sure that when you're entering in the names, you make them consistent. Excel has an auto-fill function for strings they have already seen so make sure to use that.
Once you're done filling out the categories, at the end, you can fill in the winners. (So the last column is all the actual winners)
Once you've done that, you can compare each of the contestant's selections with the actual winners and tally up the correct selections.
You can do this by using a formula:
=if(exact(A1,Z1),1,0)
Let me explain the formula to you:
if ( condition, value if true, value if false) - the if function looks at the condition. If it's true, it will return the value if true; if not, the value if false.
In our case, if there's a match between the contestant's selection (say cell A1) and the actual winner (say cell Z1) then it will return 1, otherwise it will return 0.
All you have to do to get the other 23 categories is to drag and drop the corner of the cell down (this will change A1 and Z1 to A2 and Z2 for the cell below). Then, you can easily copy and paste for all your other ballots and then tally up the totals by going to the bottom and using the formula
=Sum(A1:A24) (say your categories are from row 1 to row 24).
I realize this is pretty complicated but maybe setting it up in the spreadsheet will let you compare the entries quicker.
You can leave an optional "tip" with Mahalo's virtual currency, Mahalo Dollars. If you are asking a difficult question that might require some research, or if you'd like a wide variety of feedback, a higher tip often leads to more answers to your question.
M$Report Abuse
