![]() Obviously I'll need to provide a file or screenshot or something, but just wanted to see if there's any interest in helping. Basically, so the suckers who guessed poorly in the first round can check out and stop reading my email updates. Make sense? Ok, so which one of you wizards can help me write the formula that gives a person their max points remaining. Nba playoff brackets series#if a person picks team C to win the NBA Finals, but team C loses in the first round, not only do they miss out on 64 points in the Finals, but every previous series as well. I would like to write a formula to calculate the max number of points available at the end of each round for a given participant's bracket, taking into account what has actually happened versus what their bracket says. If you pick the correct team, correct number of games, against the wrong opponent, your max points are reduced by 50%. In the play-in tournament, the Brooklyn Nets and Minnesota Timberwolves secured the No. Max points are only available if you pick the correct team, in the correct number of games, against the correct opponent. As such, each series in each progressive round is worth 2x that of the previous series (ie first round series are worth max 8 points, second round 16, third 32, and NBA finals 64). Each round is worth the same number of points. Picking the incorrect team results in 0 points, regardless of number of games. if you pick team A over team B in 7, but team A beats team B in 4, your delta is 3 and therefore you have a 75% reduction in points allotted). There is a 25% reduction in points for number of games per game delta (ie. Points are awarded by picking the correct team and additional points awarded for how close you get to the correct number of games. I created a NBA playoff bracket in Excel. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |