koby on Nostr: I do but not in time to share before tourney, because it’s on my fiancée’s ...
I do but not in time to share before tourney, because it’s on my fiancée’s laptop and she’s traveling.
I will break down the best I can in this note:
1) make a chart of all 16 seeds and rounds. Input the historical % that seed will win each round. I googled this info and used the first source I found.
2) set up your “brackets” for the randomized output.
3) return % change to win a rd.
4) return a weighted winner. I used a clunky formula.
IF(team A % > team B) then IF random number (1-1000) <= team B%*1000, then team B, else Team A. Then the reverse is team A> team B)
5) this works all the way until the final 4 where you same seed #s and % chances of winning.
Here I do essentially a coin flip. I would have a space where the seeds would be assigned A,B,C…. So that the 50/50 odds here would determine the winner of two identical seeds.
I will break down the best I can in this note:
1) make a chart of all 16 seeds and rounds. Input the historical % that seed will win each round. I googled this info and used the first source I found.
2) set up your “brackets” for the randomized output.
3) return % change to win a rd.
4) return a weighted winner. I used a clunky formula.
IF(team A % > team B) then IF random number (1-1000) <= team B%*1000, then team B, else Team A. Then the reverse is team A> team B)
5) this works all the way until the final 4 where you same seed #s and % chances of winning.
Here I do essentially a coin flip. I would have a space where the seeds would be assigned A,B,C…. So that the 50/50 odds here would determine the winner of two identical seeds.