Smart Planner template

Job Shop Scheduling Template for Google Sheets and Excel

Download a job shop scheduling template and optimize it with Smart Planner inside Google Sheets.

Template columns

Keep the inputs structured

Smart Planner works best when columns have stable names and each row represents a real planning entity.

Job
Planning input used by the job shop scheduling workflow.
Operation
Planning input used by the job shop scheduling workflow.
Machine
Planning input used by the job shop scheduling workflow.
Duration
Planning input used by the job shop scheduling workflow.
Predecessor
Planning input used by the job shop scheduling workflow.
Due date
Planning input used by the job shop scheduling workflow.

Sample rows

Use these rows as the starting structure

JobOperationMachineDurationPredecessorDue date
J11M13-18
J12M22118
J21M12-20

Setup steps

  1. Step 1

    Download the template and open it in Google Sheets or Excel.

  2. Step 2

    Replace the sample rows with your own planning data.

  3. Step 3

    Keep the column names stable so Smart Planner can interpret the table.

  4. Step 4

    Install Smart Planner from Google Workspace Marketplace, then open it from your Google Sheet.

Related industry contexts