Spreadsheet: 288026d1389069586-penalty-shoot-out-spread-sheet-penalty-shootout
Sheet: Data

 |  | **Scored = "1" |  |  |  |  |  |  |  | http://www.excelforum.com/excel-general/979298-penalty-shoot-out-spread-sheet.html
Teams | Age | P1 | P2 | P3 | P4 | P5 | P6 | P7 | P8 | P9 | P10 | P11 | P12 | P13 | P14 | P15 | P16 | Total Goals | # of Shooters | Scoring % | Save %
[NAME] | 15 | 1 |  |  |  |  | 1 | 1 | 1 |  |  |  | 1 | 1 |  |  |  |  | 14
Freddie | 11 |  | 1 |  |  |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  |  | 15
Tobias | 15 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  | 1 |  |  |  | 1 | 1 |  |  | 15
[NAME] | 11 | 1 | 1 | 1 |  |  |  |  |  |  |  | 1 |  |  | 1 |  |  |  | 15
[NAME] | 11 | 1 | 1 | 1 | 1 |  |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  | 16
[NAME] | 7 |  |  | 1 |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  | 1 | 1 |  |  | 15
Toby | 8 | 1 |  |  | 1 | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  | 15
Burt | 12 |  | 1 |  | 1 |  |  |  | 1 | 1 |  | 1 | 1 | 1 | 1 | 1 |  |  | 15
[NAME] | 9 |  | 1 |  |  | 1 |  |  | 1 |  |  |  | 1 |  | 1 |  |  |  | 16
Fletcher | 9 | 1 | 1 |  | 1 | 1 | 1 |  |  |  |  | 1 |  | 1 |  |  |  |  | 14
Chase | 15 | 1 |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  |  |  | 1 |  |  |  | 14
Roland | 14 |  | 1 | 1 | 1 | 1 | 1 |  |  |  |  | 1 |  |  |  |  |  |  | 15
Richie | 11 | 1 |  |  | 1 | 1 | 1 |  | 1 |  | 1 |  |  | 1 | 1 | 1 | 1 |  | 16
Fermin | 7 |  | 1 |  | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 |  |  | 1 |  |  | 15
[NAME] | 12 | 1 |  |  | 1 | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  |  |  | 15
Darrell | 11 |  | 1 | 1 | 1 |  | 1 |  |  |  | 1 |  | 1 |  | 1 | 1 | 1 |  | 16
[NAME] | 14 |  | 1 | 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  | 1 |  | 1 | 1 |  | 16
Saul | 9 |  | 1 | 1 |  |  |  |  |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  | 16
Marion | 12 | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  |  |  | 14
Mack | 12 | 1 |  |  |  |  |  |  | 1 | 1 | 1 |  | 1 |  | 1 |  |  |  | 15
[NAME] | 15 | 1 |  | 1 |  |  | 1 |  | 1 |  | 1 | 1 |  |  |  |  | 1 |  | 16
Arturo | 11 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  | 14
[NAME] | 9 |  | 1 |  |  |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 15
[NAME] | 14 | 1 |  |  |  | 1 | 1 |  | 1 |  |  |  |  | 1 | 1 |  |  |  | 15
[NAME] | 10 |  | 1 | 1 |  | 1 |  | 1 |  | 1 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 16
Eduardo | 12 |  |  |  |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  |  |  | 14
Scotty | 11 |  |  | 1 | 1 |  |  | 1 |  |  | 1 | 1 |  |  | 1 |  |  |  | 16
Forest | 7 |  | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  |  |  | 16
Tyrone | 7 | 1 | 1 |  | 1 | 1 | 1 |  |  | 1 |  | 1 | 1 |  | 1 |  |  |  | 14
Lowell | 15 |  | 1 |  | 1 | 1 | 1 |  |  |  | 1 |  |  |  |  |  |  |  | 14
Vicente | 14 |  | 1 | 1 |  |  | 1 |  | 1 |  |  | 1 | 1 |  | 1 | 1 | 1 |  | 16
[NAME] | 13 | 1 | 1 |  |  |  |  | 1 |  | 1 | 1 |  |  | 1 |  |  |  |  | 14
[NAME] | 13 |  |  | 1 |  | 1 |  | 1 |  |  | 1 | 1 |  | 1 |  |  |  |  | 15
[NAME] | 16 |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 |  | 1 |  |  |  | 14
Dustin | 15 |  | 1 |  | 1 |  |  |  | 1 | 1 | 1 | 1 |  |  | 1 |  |  |  | 14
Grant | 16 | 1 | 1 | 1 |  |  |  |  |  | 1 |  | 1 |  |  | 1 | 1 |  |  | 15
[NAME] | 13 |  | 1 | 1 |  |  |  |  |  | 1 |  |  | 1 |  |  | 1 |  |  | 15
[NAME] | 8 | 1 |  |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  | 14
[NAME] | 15 |  | 1 |  | 1 |  |  | 1 |  |  |  |  | 1 |  | 1 |  |  |  | 14
[NAME] | 13 |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 15
Marlin | 8 |  | 1 | 1 | 1 |  |  | 1 | 1 | 1 |  |  | 1 |  |  | 1 | 1 |  | 16
Chung | 13 |  | 1 | 1 |  |  |  | 1 |  | 1 | 1 |  |  |  | 1 | 1 | 1 |  | 16
Jerold | 13 | 1 |  |  | 1 | 1 | 1 |  | 1 |  | 1 | 1 | 1 |  | 1 |  | 1 |  | 16
[NAME] | 15 | 1 | 1 | 1 |  |  |  | 1 |  | 1 |  | 1 |  | 1 |  |  |  |  | 15
Lindsey | 16 | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  |  |  | 1 | 1 |  |  |  | 14
[NAME] | 12 | 1 |  |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 | 1 |  |  | 15
[NAME] | 8 | 1 | 1 | 1 | 1 |  | 1 | 1 |  | 1 |  | 1 |  |  | 1 |  |  |  | 14
[NAME] | 14 |  |  |  | 1 |  |  |  | 1 |  | 1 |  | 1 | 1 |  |  |  |  | 14
[NAME] | 13 | 1 |  | 1 | 1 | 1 |  |  | 1 | 1 |  |  | 1 |  |  | 1 |  |  | 15
Mathew | 11 |  | 1 |  |  | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  | 16
Rosalba | 14 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 |  | 16
Hailey | 8 |  |  |  | 1 |  | 1 | 1 |  | 1 | 1 | 1 |  |  | 1 |  |  |  | 14
Eufemia | 14 | 1 |  | 1 | 1 |  |  | 1 | 1 |  |  |  | 1 |  | 1 |  |  |  | 15
[NAME] | 13 |  |  | 1 |  | 1 | 1 |  | 1 |  |  | 1 | 1 | 1 |  |  |  |  | 16
[NAME] | 11 |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  | 1 |  | 1 | 1 |  | 1 |  | 16
[NAME] | 9 |  |  | 1 |  | 1 | 1 | 1 | 1 |  |  |  |  | 1 | 1 |  |  |  | 14
Porsche | 11 | 1 |  |  | 1 | 1 |  | 1 |  |  |  |  | 1 | 1 |  |  | 1 |  | 16
Carli | 12 |  |  |  |  | 1 |  |  | 1 | 1 |  | 1 | 1 | 1 |  | 1 |  |  | 15
Tegan | 12 |  | 1 |  |  |  | 1 | 1 |  |  | 1 | 1 |  |  |  |  |  |  | 14
Chrystal | 15 | 1 |  |  |  | 1 |  | 1 |  |  | 1 | 1 |  | 1 |  |  | 1 |  | 16
Lovella | 13 |  |  | 1 |  |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 | 1 |  |  |  | 16
[NAME] | 10 |  | 1 | 1 | 1 | 1 | 1 | 1 |  | 1 |  |  |  |  | 1 |  |  |  | 16
Lady | 16 | 1 |  | 1 | 1 |  |  | 1 |  |  | 1 | 1 | 1 | 1 |  | 1 |  |  | 15
Bobbye | 8 |  | 1 |  |  |  |  |  | 1 | 1 | 1 |  | 1 | 1 |  |  |  |  | 14
Francie | 16 |  | 1 | 1 |  |  |  | 1 |  | 1 | 1 |  | 1 | 1 |  |  |  |  | 14
Melba | 7 |  | 1 |  | 1 |  |  | 1 |  |  | 1 | 1 |  | 1 | 1 |  |  |  | 15
[NAME] | 12 | 1 |  | 1 |  |  | 1 | 1 | 1 | 1 | 1 |  |  |  | 1 |  |  |  | 16
Rosalia | 12 | 1 | 1 |  | 1 | 1 | 1 |  |  |  | 1 | 1 | 1 | 1 |  |  |  |  | 16
Syreeta | 9 |  |  | 1 |  |  | 1 |  |  | 1 | 1 |  |  |  |  |  |  |  | 15
Julia | 10 |  | 1 |  |  |  |  | 1 | 1 |  | 1 | 1 |  | 1 |  | 1 |  |  | 16