wildcats20;1843135 wrote:How do you figure your projections on the spreadsheet? Just by seed?
Terry_Tate;1843138 wrote:Pretty sure it's by True Seed rank. 1-2 projected for 6 games, 3-4 for 5 games, 5-8 for 4 games, etc.
And yeah, I don't think I've ever won a single category doing the Tournament Pick Em, lol. Hopefully Frank Mason III can get me something this year.
This, plus if the last game wasn't a "0" for a seed who wasn't projected to win, it projects him for another game. Only part it can't figure out is in these rounds like Wisconsin plays Florida...it projects both for only that game. Next year I might factor in the true seeds into the bracket, and add a cell for next games, and whether a lower seed should win or not. Wouldn't eliminate that issue totally, but would give at least a 2 game out projecting that's accurate. As of now, basically just projects all higher seeds to win all games, and if there is an upset that team to play just the 1 next game...
Also fucks up if a player has a 0 but they win. It's happened a few times over the years, but not enough for me to care enough to fix ahah. It corrects itself when they eventually score the next game.