MeetOpt: A multi-event coaching decision support system

Abstract Track and field is one of the most popular and fastest growing high school sports in the United States. The teams' coaching staffs are often part-time employees that lack the time, budgets, and/or ability for the pre-competitive tactical analysis required for optimal assignment of athletes to events. In response to this often overlooked aspect of coaching, we present a new open-source spreadsheet-based DSS, MeetOpt, that offers coaches a decision making tool for the optimal athlete-to-event assignment. MeetOpt utilizes mixed-integer programming to create a lineup that maximizes the expected team score under a variety of common meet formats and assignment constraints. In addition, this framework is flexible enough to allow for the inclusion of opponent performance scenarios through the use of stochastic mixed-integer programming. We use real data to illustrate the value of this DSS in comparison with a commonly used decision aid utilizing a simple ranking criteria. In addition, we discuss the additional complexities when competing against teams in double duals - a meet with three teams scored as two head-to-head meets. Our results illustrate the sensitivity of a meet outcome to a selected lineup and the complexity associated with this decision process.

[1]  Michael A. Trick,et al.  Round robin scheduling - a survey , 2008, Eur. J. Oper. Res..

[2]  Peter M. Ellis,et al.  Using Bivalent Integer Programming to Select Teams for Intercollegiate Women's Gymnastics Competition , 1984 .

[3]  Mark Broadie,et al.  Assessing Golfer Performance on the PGA TOUR , 2012, Interfaces.

[4]  Jeffrey W. Ohlmann,et al.  A Player Selection Heuristic for a Sports League Draft , 2007 .

[5]  Maciek Nowak,et al.  Assignment of swimmers to dual meet events , 2006, Comput. Oper. Res..

[6]  Josef Fahlén,et al.  Simply the best, better than all the rest? Validity issues in selections in elite sport , 2017 .

[7]  Samuel Eilon,et al.  Note: Further Gymnastics , 1986 .

[8]  Susan W. Palocsay,et al.  A Translation Approach To Teaching Linear Program Formulation , 2004 .

[9]  Edward L. Hannan,et al.  Assigning Swimmers To Events In A Dual Swimming Meet , 1981 .

[10]  Andrew J. Mason,et al.  SolverStudio: A New Tool for Better Optimisation and Simulation Modelling in Excel , 2013, INFORMS Trans. Educ..

[11]  Kevin P. Scheibe,et al.  Fashioning fair foursomes for the fairway (using a spreadsheet-based DSS as the driver) , 2008, Decis. Support Syst..

[12]  James E. Payne,et al.  Efficiency in the National Basketball Association: a stochastic frontier approach with panel data , 2006 .

[13]  Simona Mancini Assignment of swimmers to events in a multi-team meeting for team global performance optimization , 2018, Ann. Oper. Res..

[15]  Ruud H. Koning,et al.  Statistical thinking in sports , 2007 .

[16]  William J. Hurley,et al.  The 2002 Ryder Cup: Was Strange's Decision to Put Tiger Woods in the Anchor Match a Good One? , 2007, Decis. Anal..

[17]  R. Lougee-Heimer,et al.  The Common Optimization INterface for Operations Research: Promoting open-source software in the operations research community , 2003 .

[18]  Celso C. Ribeiro,et al.  Scheduling in sports: An annotated bibliography , 2010, Comput. Oper. Res..

[19]  Shaul P. Ladany,et al.  Choosing a winning team for mixed medley events , 2018 .

[20]  Brian Macdonald Adjusted Plus-Minus for NHL Players using Ridge Regression with Goals, Shots, Fenwick, and Corsi , 2012, 1201.0317.

[21]  Bruce D. Weinberg,et al.  Predicting Run Production and Run Prevention in Baseball: The Impact of Sabermetrics , 2012 .

[22]  Jeffrey D. Camm ASP, The Art and Science of Practice: A (Very) Short Course in Suboptimization , 2014, Interfaces.

[23]  Patrick G. McKeown,et al.  Matching swimmers to events in a championship swimming meet , 1979, Comput. Oper. Res..

[24]  Sadjad Soltanzadeh,et al.  Systems Thinking and Team Performance Analysis , 2016 .

[25]  A. Becker,et al.  An analytical approach for fantasy football draft and lineup management , 2016 .