I am trying to put together a worbook for a Premier League pick'em pool that I am that will showcase the winners by week, total points, total winnings and total expense (entry fee versus winning),
There are 26 participants who pick the straight up winner for each of the weeks Premier League matches.
Points are doled out as follows
1 point for guessing the correct result but not exact score
3 points for guessing the exact score
3 points for guessing the exact score of one designated joker game per week
Right now, I have the data in two separate sheets
The Results (Collected via a Google Form - Google Spreadshet - Excel)
I am stumped on how to format my workbooks to streamline the work as much as possible, particularly how to go from score prediction to actual result, translating that to a win, loss or tie and allocating the correct amount of points. Once I have that set, all of the other charts will work from that.
Does any one have any thoughts? Any help will be greatly appreciated.
I have attached the packaged workbook and the two original spreadsheets.