Smart Planner template

Demand Forecasting Template for Google Sheets and Excel

Download a demand forecasting 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.

Date
Planning input used by the demand forecasting workflow.
Item or role
Planning input used by the demand forecasting workflow.
Baseline demand
Planning input used by the demand forecasting workflow.
Event uplift
Planning input used by the demand forecasting workflow.
Forecast
Planning input used by the demand forecasting workflow.
Capacity need
Planning input used by the demand forecasting workflow.

Sample rows

Use these rows as the starting structure

DateItem or roleBaseline demandEvent upliftForecastCapacity need
MondayServer hours80109012 shifts
TuesdayProduct A42004203 batches
WednesdayProduct B300753752 lines

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.