Pellucid Forecasting
Build my forecast

Guide

Set up your model
in Excel.

Describe your business in AI Modeller, review the workbook data, build the model, then refresh outputs when assumptions change.

Walkthrough: install Pellucid in Excel.

Install the add-in

You need: Excel (Office 2021 or Microsoft 365), an internet connection, and permission to install add-ins from your Microsoft 365 tenant.

From Excel (Home → Add-ins)

  1. Open Excel (desktop or web, depending on what your licence supports).
  2. Go to Home, then Add-ins, then Get Add-ins.
  3. Search for Pellucid Forecasting, then choose Add or Continue.

If the add-in is unavailable, ask your Microsoft 365 admin.

Excel ribbon with the Home tab selected, showing the Pellucid group.
Pellucid on the Home tab after installation (your ribbon may differ slightly).

Step 1 — Open Pellucid

  1. Open Excel (new or existing workbook).
  2. On the Home tab, click Pellucid.
  3. The task pane opens with AI Modeller as the default screen.

Step 2 — Set up the model

  1. In AI Modeller, describe your business — what you sell, main costs, investments, and how far ahead to forecast.
  2. When asked, provide Break Forecast by (weeks, months, or years), number of periods, start date, and reporting currency.
  3. Review the sheets listed under Workbook sheets — especially ModelSetupDetails, Drivers, Rates, and Mapping. Edit in Excel or continue the chat.
  4. When the setup looks right, ask the AI to model it — e.g. “Model the business.”
Walkthrough: modelling with AI Modeller — building a model for a SaaS company.

Step 3 — Review your output

After modelling, check these sheets:

  • Prelim Output — line calculations
  • PrelimCashOutput — cash timing
  • IncomeStatement, BalanceSheet, CashflowStatement
  • Analysis — ratios, trends, valuation, and charts

Confirm totals tie and you can explain the numbers. See How to use & Tips in the workbook for more guidance.

Step 4 — Refine and refresh

Change assumptions on input sheets or ask AI Modeller to add or update lines. After any manual edit, press Refresh values in the sidebar to regenerate outputs.

Pellucid sidebar with the Refresh values button highlighted.
Refresh values after editing Drivers, Rates, Mapping, or other inputs.
Walkthrough: add a cost or revenue line, update its driver and rate, then refresh the forecast.
Walkthrough: change a mapping.
Walkthrough: how to change a mapping.

Workbook sheets

Sheet Purpose
ModelSetupDetails Forecast settings, business overview, and line items identified
How to use & Tips In-workbook guidance and suggested line items
P&L Actuals / BalanceSheet Actuals Historical profit and loss and balance sheet. Shown when you start from existing actuals
OpeningBalance Opening asset, liability, and equity amounts that seed the balance sheet
Drivers Quantities and other non-price values
Rates Unit prices and dollar values
Mapping How each activity links to a driver, rate, payment terms, and accounts — read Comments for AI rationale
PaymentTermsDistribution Cash-timing fractions by activity. Hidden on create; unhide in Excel to edit
EconomicParam Growth or inflation assumptions. Hidden on create; unhide in Excel to edit
Prelim Output Forecast line calculations
PrelimCashOutput Cash timing from payment terms
IncomeStatement / BalanceSheet / CashflowStatement Linked financial statements
Analysis Ratios, period trends, cash-flow valuation, and charts built from the statements
ConvHistory Conversation log. Hidden on create
hc-pl / hc-bs / hc-cf Hidden snapshots of the income statement, balance sheet, and cashflow statement

Tabs follow this order. Yellow tabs are inputs, orange tabs are preliminary calculations, and blue tabs are the statements and Analysis. PaymentTermsDistribution, EconomicParam, ConvHistory, and the hc-* snapshots are hidden when the workbook is created — unhide them with Format → Hide & Unhide → Unhide Sheet. Manual setup, Model Business Activity, and Highlight Formulas are available in the task pane for advanced use.

Get help

See Support or email admin@8bits.company. Privacy · Terms