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.
Bookmarks