Panel App Solver

The Panel Assignment Solver app optimizes reviewer assignments to proposals using various algorithms, ensuring fairness and balance.

The Panel Assignment Solver app provides a streamlined way to allocate reviewers to proposals by calculating the optimal assignment matrix based on user inputs. It supports the following features:

Input Parameters:

Number of proposals, reviewers, reviews per proposal, and the maximum number of reviews per reviewer can be entered.

Users can upload a filled rankings matrix for the assignment process.

Solution Methods:

The app offers three methods for solving the assignment problem:

Optimization: Uses internal optimization techniques.

Optimization by Gurobi: Employs Gurobi optimization for better performance on larger datasets.

Greedy Algorithm: A heuristic approach that assigns reviewers based on available capacity.

Assignment Results:

The app displays the generated assignment matrix, reordered matrices (for leads and reviews), and a conflict matrix showing conflicts between reviewers and proposals.

Metrics for fairness among reviewers, leads, and proposals are also displayed.

Results are presented in an easy-to-understand tabular format within the app.

Download Capabilities:

Users can export results to Excel, including all assignment matrices and fairness metrics.

Lead as Scribe Option:

An optional feature allows users to assign the lead reviewer as the scribe for proposals.

This app is ideal for situations where proposals need to be reviewed by multiple reviewers, and fairness, balance, and optimization are key concerns.