View Data Source Map

Metric	Source Tab	Row	Notes
Gross Revenue	Total Company P&L	"Total" under Gross Revenue	MTD: col G. YTD: col U. TTM: col AI. Comparison basis (AOP or Forecast) selectable via the Compare To toggle; plan values come from the selected basis.
Net Revenue	Total Company P&L	"Total" under Net Revenue	MTD: col G. YTD: col U. TTM: col AI. PY columns dynamically detected via header scan. All variances pre-calculated.
Agency Bookings	Net Bookings	"Agency - Total" (New + Upsell combined)	MTD: col G. YTD: col U. TTM: col AI. PY columns dynamically detected. All variances pre-calculated.
EBITDA	Total Company P&L	"EBITDA Less SW Capitalization"	MTD: col G. YTD: col U. TTM: col AI. PY columns dynamically detected. All variances pre-calculated.
Cash Position	Cash Flow	"Ending Balance"	Point-in-time — same value for MTD, YTD, and TTM.
Headcount	Total Company P&L	"End of Period" under Headcount	Point-in-time. PY from Actuals tab header scan. Reduction = favorable (inverted color logic).
Net Rev / Headcount	Total Company P&L	"Net Revenue Per Avg. Headcount" (col C label, dynamically matched)	All values read directly — never calculated by dividing Net Revenue by Headcount.
Agency Labor %	Metrics	"Agency - Agency Labor as % of Net Revenue"	All values read directly — never computed. Stored as decimals, displayed as whole-number %.

All values — Actual, comparison basis (AOP or Forecast, selectable via the Compare To toggle), YTD, TTM, PY — are sourced directly from pre-calculated fields in the Excel file. Variances against the selected comparison basis are computed as actual minus plan; every other value is used directly as pre-calculated in the file.

Recent Activity