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
Right now, I have the data in two separate sheets
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.