Documentation

Quick Start

Get your first forecast in under 2 minutes.

1. Install

Open Google Sheets → Extensions → Add-ons → Get add-ons → Search "ForecastJedi" → Install.

2. Prepare Your Data

Your data needs at least two columns:

• Date column — dates in chronological order (any common format)
• Value column — numbers you want to forecast
• Minimum 10 rows of historical data (30+ recommended)

3. Select & Forecast

Highlight your data range (including headers) → Extensions → ForecastJedi → Create Forecast. Configure your horizon, frequency, and confidence level in the sidebar, then click Generate Forecast.

4. View Results

ForecastJedi writes results directly into your sheet:

• Forecast table — added below your data with columns: Forecast Date, Forecast Value, Upper Bound, Lower Bound
• Chart — a line chart showing historical data and forecast with confidence bands

Data Formats

ForecastJedi accepts dates in any common format:

• YYYY-MM-DD (recommended)
• MM/DD/YYYY, DD/MM/YYYY
• YYYY-MM-DD HH:MM:SS (for hourly data)

Supported frequencies: Daily (D), Weekly (W), Monthly (M), Quarterly (Q).

Values must be numeric. Missing values can be filled using our interpolation feature.

Forecasting Models

Standard Model (Default)

Fast synchronous model (<1s). Best for data with clear trends and seasonality. Available on all tiers.

Deep Learning (Pro/Team)

Amazon's deep learning foundation model for time series. Processes asynchronously (~2s warm, ~21s cold start). Best for complex patterns, non-linear relationships, and datasets with multiple covariates.

Choosing a Model

Start with the standard model for quick results. Switch to deep learning when you need to capture complex patterns or use covariates.

Missing Value Interpolation

ForecastJedi fills missing values using an iterative edges-first algorithm powered by machine learning with outlier detection. This approach:

• Handles up to 40% missing data
• Starts from the edges inward for maximum context
• Uses lag features when available, falls back gracefully
• Reports statistics: iterations, filled-with-lags, filled-without-lags

Billing & Subscriptions

ForecastJedi uses Polar for secure payment processing.

Subscribing

Go to Extensions → ForecastJedi → 💎 Manage Plan. Select Pro or Team and complete checkout via Polar.

Managing Your Subscription

Click Manage billing on Polar in the plan dialog to open your customer portal. From there you can:

• View orders and invoices
• Change or cancel your plan
• Update billing details

Upgrading / Downgrading

Switch between Pro and Team anytime. Changes take effect immediately and billing is prorated.

API & Architecture

ForecastJedi runs on a fully serverless AWS backend. All communication between the Google Sheets add-on and our servers is encrypted via TLS 1.3.

How It Works

• Forecasting — your selected data is sent to our API, processed in-memory, and results returned directly to your sheet
• AI Analysis — a sample of your data is analyzed by AI to recommend columns and settings
• Interpolation — missing values are filled using machine learning before forecasting

Authentication

ForecastJedi uses your Google account identity to authenticate requests. No separate login or API key is needed — it works seamlessly with your existing Google Sheets session.

Data Privacy

Your data is processed in-memory and never stored. See our Privacy Policy for full details.

Quotas & Limits

Daily limits reset at midnight UTC. Weekly limits reset on Monday at midnight UTC.