A C D E F G H Overall Entry Practice Number Number Average 1 Number Gymnast Team Class Rank Level Hours of Events of Medals Score 2 1001 Zoey Mullins MSU Junior 9 16 4 1 9.43 1002 Edith Bloom OSU Freshman 5 2 4 9.42 1003 Shirley Blake MSU Senior 9 16 4 9.34 5 1004 Ruby Getty IU Sophomore 6 2 4 1 9.33 1005 Rachel Werth MSU Freshman 5 2 4 9.29 T 1006 Piper Parker OSU Freshman 5 2 7.07 1007 Peyton Runyon IU Senior B 12 6.74 9 1008 Olivia Jakobs IU Sophomore 5 N 9.13 10 1009 Margo Jay IU Sophomore 6 2 9.34 11 1010 Rose Ballard OSU Senior 10 20 8.95 12 1011 Hannah Widger OSU Sophomore 5 2 9.05 19 1012 Evie Juliet MSU Junior 8 12 8.86 14 1013 Erin Zimmerman IU Freshman 6 2 6.87 15 1014 Elizabeth James OSU Junior 8 12 9.30 16 1015 Audrey Hageman MSU Freshman 7 6 O 6.87 17 Amount of Scholarship ($2.500) 18 Years to pay off bus 10.80Gymnast The Ohio State University Indiana University Michigan State University Edith Bloom 1015 Audrey Figena Fluabath James Peyton Bumpon 1017 Piper Farber 1001 Jory Mulin Hannah Widger Michael Werth Bout All Around Score Each Beit All Around Score Margo Ity But All Around Score Team Summary B C D F Practice Requirements by Level N Level # 5 6 10 Time [Hrs/Day) 2 5 4 Days/Week 2 Levels 6 Round of Performances 7 vault beam floor bars B Levels 5-6 Round 1 Round 2 Round 3 Round 4 9 Levels 7-8 Round 2 Round 3 Round 4 Round 1 10 Levels 9-10 Round 3 Round 4 Round 1 Round 2 C D N 0 individual All Around Jeare More than Team's Art 1 TRUE TRUE TRUE 1.43 9.65 9.30 17.70 TRUE TRUE TRUE 96 950 TRUE TRUE FRUE TRUE 954 940 TRUE TRUE TRUE TRUE TRUE TRUE TRUE FALSE TRUE FALSE TRUE TRUE 8.59 9.09 9.45 TRUE TRUE FRUE 2.45 9.19 9.29 TRUE TRUE TRUE TRUE 190 8.80 9.54 TRUE TRUE TRUE TRUE 100 2.39 9.64 TRUE TRUE TRUE TRUE TRUE TRUE 6 9.05 0.00 8.98 FALSE 16 1014 TRUE TRUE TRUE TRUE 9.30 947 919 932 TRUE 17 1035 FALSE TRUE TRUE TRUE 0.00 9.04 859 9.48 Events5. Write an EXCEL formula in cell 'Team Summary'!C3, that can be copied down, to determine the number of medals the corresponding gymnast won. The formula should work when it is copied into 'Team Summary"!H3, and 'Team Summary'!M3 and copied down