I'm working on a Tennis game using excel. I would like to be able to stop using manual spinners to update each set's winner.



Key Cells
J9 shows the winner of the game
V55 show what set the match is in
O2 and T2 contain the player's names

Not sure what other details to give but I'm sure I'm leaving out a lot.

https://www.flickr.com/photos/781547...106362/player/

Looks like you need code...

When J9 is updated increment score
* offset score column by [V55-1]
* offset score row by [IF J9=O2 THEN 0 ELSE 1]

The Excel Programming forum may be able to help you more.

Looks pretty neat though!

Thank you. Thanks to you the fatigue tracks automagically! Working on the scoreboard now.

Not sure what I did, but great if it helped.

Better check on that Fan Favorite stat. Depending on which part of his career this is supposed to be, Connors was either loved or hated.

And if this is Roland Garros, Kodes has to have an edge. He was a master of clay. He also won Wimbledon, but only because a lot of players honored the the '73 boycott. Smith, Newcombe, Ashe, and Rosewall were all out though a couple of talented youngsters, Connors (19) and Borg (17), chose to play. Both were knocked out in the quarters.

Wow, you know your stuff. Kodes had a pretty sizable advantage in that match (in fact he won). My rankings were 89 Kodes to 75 Conners. I used their career record and titles at the specific tourney to arrive at their rankings. Borg is going to be VERY hard to beat at Roland Garros, he is in the quarters against Guillermo Vilas.

I'm currently slightly reworking the crowd support formulas.

Any more ideas on getting the crowd to influence a match would be appreciated.
Currently:
Home Country +1
Falling behind after the first set +1 (Neutral crowd seems to rally behind the first set loser)(This was the reason Kodes was getting a bonus for "UNDERDOG")
Heavy Favorite +1
Popular Player +1
Match Intensity *.3 (for close matches)

Might add in the notion of Fan Capacity based on matchups, dunno.

https://www.flickr.com/photos/78154717@N07/14957824970


Added Service Stats, Nerves, and Compiled Crowd Support