How do we maximize win rates( getting win: loss ratio as high as possible in excel)

I am trying to solve a problem-solving challenge. There are 5 superheroes and 4 villains 1.You're trying to maximize win rates (i.e., get as high an overall win : loss ratio as possible) 2. Superheroes can't be in 2 places at once, and any years they're not fighting invaders they're on vacation / at rest 3. When the data denotes a 'win', this is always on the part of the hero 4. This work has been going on since the year 2000; this is the year 6000 Table referenceTable reference