Use this sheet to restrict which vehicles are allowed to perform specific tasks.

Each row represents a valid task–vehicle combination. If a task appears in this sheet, it may only be assigned to the vehicles listed here.

This sheet is optional. If a task does not appear in this sheet, it may be assigned to any vehicle that satisfies the other model constraints.

Task ID

Specifies the task being restricted.

This field must match a Task ID defined in the Tasks sheet exactly.

A Task ID may appear on multiple rows if the task is allowed to be performed by multiple vehicles.

Vehicle ID

Specifies a vehicle that is allowed to perform the associated task.

This field must match a Vehicle ID defined in the Vehicles sheet exactly.

Each row defines one allowed task–vehicle assignment.

Only the vehicles listed here are allowed to perform the specified task. Any vehicles not listed are not allowed to perform that task.

How This Constraint Works

If a task appears in this sheet, it can only be assigned to the vehicles listed for that task. For example:

In this case, Task 1 may only be performed by Truck A or Truck B. All other vehicles are not allowed to perform that task.

Rules and Structure

• Task ID must exist in the Tasks sheet.

• Vehicle ID must exist in the Vehicles sheet.

• A Task ID may appear multiple times to allow multiple vehicles.

• Each Task ID + Vehicle ID combination should appear only once.