LO Allocator

1

Course Name Mapping

⌄

Map full course names to short codes. Matching is partial and case-insensitive.

2

Column Configuration

⌄

Course Column

Column with course names

Company Column

Column with company names

Assign Column

Column to write assigned teacher

Preferred Teacher Cols

Comma-separated, in priority order

Teacher Worksheet (2nd sheet)

Teacher Name Col

1-based index (B=2)

Teacher Max Col

1-based index (I=9)

Course Cols (D,E,F)

1-based, comma-separated

3

Assignment Rules

⌄

Delete Keywords

Rows containing any of these words get marked NA

Clear Keywords

Teacher names in col J matching these get cleared

Single Teacher Threshold

Companies with ≤ this many students will try to use only 1 teacher

Label new companies as "New Company" (no teacher assigned)

Turn off to assign teachers to new companies via course match

4

Upload & Process

⌄

📊

or click to browse · .xlsx / .xls supported

File is ready to download