Install the ScriptLab Excel Add-in from the marketplace.
Once installed, click the Code icon and then click Import in the side pane.
In the Import section, copy the contents from here and click the IMPORT button.
Trust the script and click Register.
The Lineups function will now be available in your spreadsheets.
The LineupGen function should be available if you start typing =SCRIPTLAB.LINEUPGEN.LINEUPS().
Parameter Name | Type | Description | Default | Optional |
---|---|---|---|---|
token | String | Token from your LineupGen account | no | |
players* | Range of cells | Player data for competition | no | |
sport | String | "CFB", "GOLF", "MLB", "MMA", "NAS", "NBA", "NFL", "SOC", "TEN" | no | |
num | Number | Number of lineups to generate. If omitted, num = 1. | 1 | yes |
min_salary_cap | Number | Minimum total cost of each lineup. If omitted, min_salary_cap = 0. | 0 | yes |
max_salary_cap | Number | Maximum total cost of each lineup. If omitted, max_salary_cap = 50000. | 50000 | yes |
show_total_cost | TRUE/FALSE | Show total cost for each lineup. If omitted, show_total_cost = FALSE. | FALSE | yes |
multi_team | TRUE/FALSE | Players from more than 1 team are required in each lineup. If omitted, multi_team = FALSE. | FALSE | yes |
multi_game | TRUE/FALSE | Players from more than 1 game are required in each lineup. If omitted, multi_game = FALSE. | FALSE | yes |
The players data must include the following column headers as the first row:
These column headers are included in the lineup template.