NOTE: This has been updated to include the results from both days of P&G Championships.
Following up on the men’s Olympic team calculator, I’ve also done one for the women so that we can compare the scoring potentials of all the various team options we could possibly imagine, and some we couldn’t imagine.
We don’t have as much to go on yet for the women, but this calculator takes into account all scores recorded so far in competition in 2016 to make up for it.
Once again, here’s how it works. In the cell next to “Team Member #X,” write only the surnames of the five gymnasts on the prospective Olympic team you’d like to test. Once you’ve listed at least three gymnasts, you’ll see a three-up, three-count total for that team on each event along with a full team total. There are two calculation options here. The first is based on the highest score each gymnast has achieved in competition this year on each event, and the second is based on the average score each gymnast has achieved in competition this year on each event. The optimism option and the realism option.
As a handy reminder of who the people are and how their last names are spelled (be sure they’re spelled correctly), here are the 24 women included in this calculator: Biles, Raisman, Douglas, Hernandez, Nichols, Smith, Skinner, Baumann, Dowell, Locklear, Kocian, Gowey, Schild, Hundley, Dennis, Desiderio, Gaskins, Navarro, Frazier, Trautman, Paulson, Ramler, Musselman, DeGuzman.
[office src=”https://onedrive.live.com/embed?cid=074627716A738B87&resid=74627716A738B87%21126&authkey=AEKOv6Fux_Ernuo&em=2&wdAllowInteractivity=False&AllowTyping=True&ActiveCell='Sheet1'!A2&Item='Sheet1'!A2%3AC103″ width=”390″ height=”2500″]