Results 1 to 8 of 8

Gift Giving guessing game point accumulation help

Threaded View

  1. #1
    Valued Forum Contributor
    Join Date
    08-10-2012
    Location
    London, England
    MS-Off Ver
    Excel 2010
    Posts
    721

    Gift Giving guessing game point accumulation help

    I have been tasked to come up with a point tallying system that came out of my family's Christmas Secret Santa effort as i did it on pen and paper this year and it took me forever and a day to do and therefore missed out on serious eating/drinking time.

    Effectively every year rather than give our entire family a present each we do Secret Santa, so get allocated a person randomly to spend a £ amount on and then we play a game afterwards to see if we can guess who the Secret Santa was and allocate points according to how well we can guess.

    The points system is 2 points for a correct guess, 3 points (to the gift giver) if nobody guesses the correct gift giver plus 1 point to each person nominated that wasn’t the gift giver

    See the attached template. Range C2:L2 are the guessers. B3:B12 are the presents they received and need to guess whom gifted them to them. C3:L13 are the guesses that C2:L2 made.

    O2:X13 are the correct answers. For example Edith was the giver of the voucher to Delroy.

    Row 20 onwards is the scores (where i will really struggle!)
    In the above example nobody guesses Edith so Edith scores 3, Isaac would get three also (having been guessed that number of times), Ana gets 2, as do Harold and Gary, and Frank, having only been guessed once gets 1.

    In another example, the gift of the shoes: Charlie was the gift giver and he was guessed correctly by Ana and Harold who get 2 points each. In this example harold gets a further point as he was guessed as the gift giver by Charlie, and the other people who were guessed get a point for the times they were guessed.

    Hopefully this makes sense, but i cant seem to get a handle on how to code the points system as outlined above into my template.
    Attached Files Attached Files

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. How to design a simple guessing game, played by one player against the computer.
    By Papsco in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-06-2015, 10:40 PM
  2. Giving a point value to different ranks
    By Ndbarrow in forum Excel General
    Replies: 3
    Last Post: 01-29-2015, 01:09 PM
  3. Replies: 1
    Last Post: 10-13-2014, 09:38 AM
  4. Replies: 1
    Last Post: 09-17-2014, 06:00 AM
  5. Guessing numbers
    By Roadhog03 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-05-2014, 12:35 PM
  6. Filtering (I'm guessing)
    By Filtering (I'm guessing) in forum Excel General
    Replies: 4
    Last Post: 05-15-2006, 02:50 PM
  7. [SOLVED] Game score without game being played
    By Sheila in forum Excel Formulas & Functions
    Replies: 14
    Last Post: 05-17-2005, 07:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1