Hello guys,
I’m sure what I’m trying to do already exists. Has anyone else done something similar?
I manage an esports team, with four teams from four divisions competing each week in BO3 matches to reach Division 1. Before each BO, each team flips a coin, and the winner gets to pick two maps and ban two maps, while the loser gets to pick one map and ban two maps. I enjoy entering all this data into an Excel spreadsheet every week, but I would like to be able to generate a dashboard that shows me each team’s pick and ban trends for each map, as well as their win rate and loss rate on each map. This will allow me to anticipate a team’s favorite maps so I can ban them and, conversely, pick the maps they like the least. I’m terrible at pivot tables in Excel and can’t get what I want, and I don’t know what other tools could help me do that.
submitted by /u/cgx3577
[link] [comments]
