Fashioning fair foursomes for the fairway (using a spreadsheet-based DSS as the driver)

Authors:
Cliff T. Ragsdale;Kevin P. Scheibe;Michael A. Trick
Affiliations:
Pamplin College of Business, Virginia Tech, Blacksburg, Virginia 24061, United States;College of Business, Iowa State University, Ames, IA 50011, United States;Tepper School of Business, Carnegie Mellon University, Pittsburgh, PA 15213, United States
Venue:
Decision Support Systems
Year:
2008

Citing 19
Cited 1

Some models of graphs for scheduling sports competitions

Discrete Applied Mathematics
Combinatorial aspects of construction of competition Dutch Professional Football Leagues

Discrete Applied Mathematics - Special issue: Timetabling and chromatic scheduling
The use of spreadsheets in organizations: determinants and consequences

Information and Management
A spreadsheet-based decision support system for wood panel manufacturing

Decision Support Systems
Construction of Basic Match Schedules for Sports Competitions by Using Graph Theory

PATAT '97 Selected papers from the Second International Conference on Practice and Theory of Automated Timetabling II
Scheduling a Major College Basketball Conference

Operations Research
Scheduling a Major College Basketball Conference--Revisited

Operations Research
Golf competition between individuals

WSC '79 Proceedings of the 11th conference on Winter simulation - Volume 2
A decision support system for the electrical power districting problem

Decision Support Systems
A decision support methodology for stochastic multi-criteria linear programming using spreadsheets

Decision Support Systems
A linear-time algorithm to solve the Sports League Scheduling Problem (prob026 of CSPLib)

Discrete Applied Mathematics
College basketball scheduling with travel swings

Computers and Industrial Engineering
Scheduling fixtures for basketball New Zealand

Computers and Operations Research
A constraint programming approach to the multiple-venue, sport-scheduling problem

Computers and Operations Research
Scheduling the professional soccer leagues of Austria and Germany

Computers and Operations Research
The role of spreadsheet knowledge in user-developed application success

Decision Support Systems
Integrated decision support systems: A data warehousing perspective

Decision Support Systems
Indiana University's Kelley School of Business Uses Integer Programming to Form Equitable, Cohesive Student Teams

Interfaces
Semidefinite programming based approaches to home-away assignment problems in sports scheduling

AAIM'05 Proceedings of the First international conference on Algorithmic Applications in Management

Eli Lilly and Company Uses Integer Programming to Form Volunteer Teams in Impoverished Countries

Interfaces

Quantified Score

Hi-index	0.00

Visualization

Abstract

Golf teams at most public universities derive much of their support for player scholarships from external donors. Relationships with current and potential donors are often created and maintained via annual golf tournaments that pair donors with varsity players and team coaches in a scramble format tournament. This paper introduces a new spreadsheet-based DSS tool for optimizing the formation of teams for multi-round, unique-team, golf scramble tournaments. The DSS uses mixed-integer programming to create unique teams for each round of play while considering the handicaps of all teams and individual players to ensure a reasonable level of fairness in the tournament.