Excel Add-in Integration

Installation

1. Install the ScriptLab Excel Add-in from the marketplace.

2. Once installed, click the Code icon and then click Import in the side pane.

3. In the Import section, copy the contents from here and click the IMPORT button.

4. Trust the script and click Register.

The Lineups function will now be available in your spreadsheets.

Download lineup template(s)

1. Download the correct DraftKings lineup template for the sport, competition style, and start time that you'd like to generate lineups for.

Generate lineups

The LineupGen function should be available if you start typing =SCRIPTLAB.LINEUPGEN.LINEUPS().

Function Parameters

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

*Required column headers

The players data must include the following column headers as the first row:

• Name + ID
• Name
• ID
• Roster Position
• Salary
• Game Info
• TeamAbbrev

These column headers are included in the lineup template.