Skip to content
FDE BI Evidence Workbenchobserved → compared → decided → scoped
Engagement board Current gold promoted Model codex Packet xlsx-evidence-v2 Identifiers and receipts

TargetArchitecture_CompleteMiss.xlsx

7 sheets · compared 2026-07-30T13:23:49.465Z

Exact model input Extraction review Receipts
  1. Source input Original workbook bytes · 7 sheets Source input detail
  2. XLSX.evidence 12 categories accounted for XLSX.evidence detail
  3. Current gold promoted build Current gold detail
  4. Model walk codex Model walk detail
  5. Your decisions 0 of 8 answered Your decisions detail
  6. Scope / SOW blocked · 0 items Scope / SOW detail

The model says

8 findings

8 not found

You say

0 of 8 answered

The gap is the outstanding work. Context-only findings are excluded — they describe the estate rather than propose it.

Sales KPI Prototype

5 × 3 · 2 formulas · 2 findings cite this sheet

Visual aid Exact model input Clear filter

Needs your call 2

Each becomes a final, immutable disposition.

Review all 2
SalesMetrics.Customer Lifetime Value measure Not found in this gold boundary · Target Fields!A8:J8 · Sales KPI Prototype!A5:C5 +1 Decide

How the model read it

No Customer Lifetime Value measure or supporting customer/order structure was observed. The current model's four finance measures are differently named and have unknown exact DAX. The workbook prototype's 3.2 frequency multiplier is illustrative and does not establish a production definition.

What forecast horizon and expected-order-frequency method should production CLV use?

Should CLV use gross order value, net revenue, gross margin or contribution margin?

How should churn, returns, discounts and customer tenure affect the calculation?

Evidence

Target Fields!A8:J8 Sales KPI Prototype!A5:C5 Sales KPI Prototype!B5

Cited current gold

fde-finance.current-model
SalesMetrics.Gross Order Intake measure Not found in this gold boundary · Target Fields!A9:J9 · Sales KPI Prototype!A4:C4 +1 Decide

How the model read it

The required sum of OrderGrossValue and its prototype formula have no observed counterpart in current gold. Actual Revenue cannot be assumed equivalent to gross booked order value, particularly because exact DAX and production semantics for current measures were not returned.

What event makes an order count as booked intake, and which date drives reporting?

Should cancelled or amended orders restate prior periods?

Are intake values reported before discounts, tax and currency conversion in all views?

Evidence

Target Fields!A9:J9 Sales KPI Prototype!A4:C4 Sales KPI Prototype!B4

Cited current gold

fde-finance.current-model

This project defines the next engagement. It does not assert that the target has been implemented.