2016 BBA Madness follow-up

The Brockton Bowling Association has posted the full results from the inaugural BBA Madness tournament on its website, including qualifying results and the full match play bracket.

As for how you can run a tournament with this format, I’m not sure how a tournament bracket can be done in Excel, but qualifying certainly can, with the wins against the field calculated with the formula COUNTIF(A1:A20,”<“&A10), with the range A1:A20 representing the field’s scores in one game and A10 representing one bowler’s score in that game. Ties against the field are similarly calculated (using = instead of <), but be sure to subtract 1 from the function’s result, as the function result will include the cell containing the bowler’s score.

Advertisements