Skip to content
FDE BI Evidence Workbenchobserved → compared → decided → scoped
← All workbooks

Workbook evidence

TargetArchitecture_CompleteMiss.xlsx

0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a

Packet receipt Source evidence

Extraction review

What the LLM can actually inspect

Every supported workbook evidence class is accounted for. Amber means content was detected but not fully decoded; red means packet bounds omitted detail. Ordinary numeric/date/Boolean cell values and opaque binary bodies are not sent.

Packet
xlsx-evidence-v2
Components
12
Characters
5564

workbook metadata

Workbook metadata

found

6 items extracted and included.

Items
6
LLM use
included
Sensitivity
metadata
Receipt

Exact extraction component

Workbook metadata

found · included · metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:workbook_metadata
label:Workbook metadata
status:found
inclusion:included
sensitivity:metadata
item-count:6
character-count:268
omitted-item-count:0

[Workbook]
calculation-mode:unspecified
property.title:Customer and Sales Target — Complete Miss
property.subject:Synthetic FDE BI target architecture fixture
property.creator:FDE BI web-app test harness
property.created:2026-01-01 00:00:00
property.modified:2026-01-01 00:00:00

text cells

Literal text cells

found

119 items extracted and included.

Items
119
LLM use
included
Sensitivity
source content
Receipt

Exact extraction component

Literal text cells

found · included · source content

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:text_cells
label:Literal text cells
status:found
inclusion:included
sensitivity:source_content
item-count:119
character-count:2307
omitted-item-count:0

[Sheet:Instructions]
A1:Customer and Sales Target — Complete Miss
A3:Scenario
B3:The target domain is not represented in the current FDEFinance semantic model.
A5:Interpretation
B5:The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.

[Sheet:Target Fields]
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Current Hint
H1:Formula
I1:Source
J1:Consultant Notes
A2:column
B2:Customer
C2:CustomerIdentifier
D2:String
E2:Enterprise customer identity.
F2:Yes
G2:Customer.CustomerIdentifier
I2:CRM
A3:column
B3:Customer
C3:CustomerSegment
D3:String
E3:Commercial segment.
F3:Yes
G3:Customer.CustomerSegment
I3:CRM
A4:column
B4:Customer
C4:RelationshipOwner
D4:String
E4:Accountable relationship owner.
F4:Yes
G4:Customer.RelationshipOwner
I4:CRM
A5:column
B5:SalesOrder
C5:OrderIdentifier
D5:String
E5:Customer order identity.
F5:Yes
G5:SalesOrder.OrderIdentifier
I5:Order platform
A6:column
B6:SalesOrder
C6:OrderGrossValue
D6:Decimal
E6:Gross order value before discounts.
F6:Yes
G6:SalesOrder.OrderGrossValue
I6:Order platform
A7:column
B7:SalesOrder
C7:SalesChannel
D7:String
E7:Order acquisition channel.
F7:Yes
G7:SalesOrder.SalesChannel
I7:Order platform
A8:measure
B8:SalesMetrics
C8:Customer Lifetime Value
D8:Decimal
E8:Expected customer lifetime value.
F8:Yes
G8:SalesMetrics.Customer Lifetime Value
I8:Derived target metric
A9:measure
B9:SalesMetrics
C9:Gross Order Intake
D9:Decimal
E9:Gross booked order value.
F9:Yes
G9:SalesMetrics.Gross Order Intake
I9:Derived target metric

[Sheet:Mapping Rules]
A1:Rule
B1:Value
C1:Meaning
A2:Exact qualified name
C2:Safe deterministic candidate
A3:Declared current hint
C3:Candidate requiring semantic confirmation
A4:Same object name
C4:Candidate only; table context may differ
A5:No candidate
C5:Research or confirm absence

[Sheet:Reference Data]
A1:CostCentre
B1:AccountGroup
C1:CurrencyCode
A2:CC100
B2:Operations
C2:AUD
A3:CC200
B3:Commercial
C3:AUD
A4:CC300
B4:Corporate
C4:NZD

[Sheet:Sample Input Data]
A1:OrderIdentifier
B1:CustomerIdentifier
C1:OrderGrossValue
D1:SalesChannel
A2:SO-1001
B2:CUST-001
D2:Direct
A3:SO-1002
B3:CUST-002
D3:Partner

[Sheet:Validation]
A1:Check
B1:Formula
C1:Expected
A2:Target row count
C2:Number of declared target items
A3:Required rows
C3:All declared rows in these fixtures

sheet structure

Workbook and sheet structure

found

24 items extracted and included.

Items
24
LLM use
included
Sensitivity
metadata
Receipt

Exact extraction component

Workbook and sheet structure

found · included · metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:sheet_structure
label:Workbook and sheet structure
status:found
inclusion:included
sensitivity:metadata
item-count:24
character-count:444
omitted-item-count:0

[Sheet:Instructions]
state:visible
used-range:A1:B5
freeze-panes:not-found
auto-filter:not-found

[Sheet:Target Fields]
state:visible
used-range:A1:J9
freeze-panes:A2
auto-filter:A1:J9

[Sheet:Mapping Rules]
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found

[Sheet:Reference Data]
state:hidden
used-range:A1:C4
freeze-panes:not-found
auto-filter:not-found

[Sheet:Sample Input Data]
state:visible
used-range:A1:D3
freeze-panes:not-found
auto-filter:not-found

[Sheet:Validation]
state:visible
used-range:A1:C3
freeze-panes:not-found
auto-filter:not-found

tables names

Tables and defined names

found

1 items extracted and included.

Items
1
LLM use
included
Sensitivity
semantic metadata
Receipt

Exact extraction component

Tables and defined names

found · included · semantic metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:tables_names
label:Tables and defined names
status:found
inclusion:included
sensitivity:semantic_metadata
item-count:1
character-count:147
omitted-item-count:0

[Sheet:Target Fields]
table:TargetFields;range=A1:J9;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Current Hint,Formula,Source,Consultant Notes

formulas

Formulas and external formula references

found

2 items extracted and included.

Items
2
LLM use
included
Sensitivity
business logic
Receipt

Exact extraction component

Formulas and external formula references

found · included · business logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:formulas
label:Formulas and external formula references
status:found
inclusion:included
sensitivity:business_logic
item-count:2
character-count:73
omitted-item-count:0

[Sheet:Validation]
B2:=COUNTA('Target Fields'!C:C)-1
B3:=COUNTIF('Target Fields'!F:F,"Yes")

annotations links

Comments, notes and hyperlinks

not found

No comments, notes and hyperlinks were found.

Items
0
LLM use
included
Sensitivity
source content
Receipt

Exact extraction component

Comments, notes and hyperlinks

not found · included · source content

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:annotations_links
label:Comments, notes and hyperlinks
status:not_found
inclusion:included
sensitivity:source_content
item-count:0
character-count:0
omitted-item-count:0

validation formatting

Validation and conditional formatting

not found

No validation and conditional formatting were found.

Items
0
LLM use
included
Sensitivity
business logic
Receipt

Exact extraction component

Validation and conditional formatting

not found · included · business logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:validation_formatting
label:Validation and conditional formatting
status:not_found
inclusion:included
sensitivity:business_logic
item-count:0
character-count:0
omitted-item-count:0

connectivity

Connections, queries and external links

not found

No connections, queries and external links were found.

Items
0
LLM use
included
Sensitivity
connection metadata
Receipt

Exact extraction component

Connections, queries and external links

not found · included · connection metadata

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:connectivity
label:Connections, queries and external links
status:not_found
inclusion:included
sensitivity:connection_metadata
item-count:0
character-count:0
omitted-item-count:0

power query

Power Query and DataMashup

not found

No power query and datamashup were found.

Items
0
LLM use
included
Sensitivity
connection logic
Receipt

Exact extraction component

Power Query and DataMashup

not found · included · connection logic

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:power_query
label:Power Query and DataMashup
status:not_found
inclusion:included
sensitivity:connection_logic
item-count:0
character-count:0
omitted-item-count:0

analytical objects

Pivots, caches, slicers and charts

not found

No pivots, caches, slicers and charts were found.

Items
0
LLM use
included
Sensitivity
potential data
Receipt

Exact extraction component

Pivots, caches, slicers and charts

not found · included · potential data

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:analytical_objects
label:Pivots, caches, slicers and charts
status:not_found
inclusion:included
sensitivity:potential_data
item-count:0
character-count:0
omitted-item-count:0

embedded model

Power Pivot and embedded data model

not found

No power pivot and embedded data model were found.

Items
0
LLM use
included
Sensitivity
potential data
Receipt

Exact extraction component

Power Pivot and embedded data model

not found · included · potential data

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:embedded_model
label:Power Pivot and embedded data model
status:not_found
inclusion:included
sensitivity:potential_data
item-count:0
character-count:0
omitted-item-count:0

package security

Package, macros, embedded objects and security

found

11 items extracted and included.

Items
11
LLM use
included
Sensitivity
executable or security
Receipt

Exact extraction component

Package, macros, embedded objects and security

found · included · executable or security

XLSX.evidence component xlsx-evidence-v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
category:package_security
label:Package, macros, embedded objects and security
status:found
inclusion:included
sensitivity:executable_or_security
item-count:11
character-count:274
omitted-item-count:0

[Workbook]
workbook-protection:not-found
ooxml-part-count:16
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Instructions]
sheet-protection:not-found

[Sheet:Target Fields]
sheet-protection:not-found

[Sheet:Mapping Rules]
sheet-protection:not-found

[Sheet:Reference Data]
sheet-protection:not-found

[Sheet:Sample Input Data]
sheet-protection:not-found

[Sheet:Validation]
sheet-protection:not-found
Interpretation boundary: “not found” is an inspected absence in this workbook package. “Indicator only” means the content exists but needs a specialist adapter—normally Excel/Analysis Services inside the Windows VM—for full query or semantic-model extraction.

Instructions

5 × 2 · 0 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1Customer and Sales Target — Complete MissCustomer and Sales Target — Complete MissGeneral
A3ScenarioScenarioGeneral
B3The target domain is not represented in the current FDEFinance semantic model.The target domain is not represented in the current FDEFinance semantic model.General
A5InterpretationInterpretationGeneral
B5The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.General

Workbook visual aid

Instructions

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Instructions

Exact LLM input slice

Instructions

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Instructions]
::text_cells
A1:Customer and Sales Target — Complete Miss
A3:Scenario
B3:The target domain is not represented in the current FDEFinance semantic model.
A5:Interpretation
B5:The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.
::sheet_structure
state:visible
used-range:A1:B5
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

Target Fields

9 × 10 · 0 formulas · visible

Inspect retained cell ledger+
TargetFields A1:J9
CellObserved value/formulaCached valueFormat
A1Object TypeObject TypeGeneral
B1EntityEntityGeneral
C1NameNameGeneral
D1Data TypeData TypeGeneral
E1Business DefinitionBusiness DefinitionGeneral
F1RequiredRequiredGeneral
G1Current HintCurrent HintGeneral
H1FormulaFormulaGeneral
I1SourceSourceGeneral
J1Consultant NotesConsultant NotesGeneral
A2columncolumnGeneral
B2CustomerCustomerGeneral
C2CustomerIdentifierCustomerIdentifierGeneral
D2StringStringGeneral
E2Enterprise customer identity.Enterprise customer identity.General
F2YesYesGeneral
G2Customer.CustomerIdentifierCustomer.CustomerIdentifierGeneral
I2CRMCRMGeneral
A3columncolumnGeneral
B3CustomerCustomerGeneral
C3CustomerSegmentCustomerSegmentGeneral
D3StringStringGeneral
E3Commercial segment.Commercial segment.General
F3YesYesGeneral
G3Customer.CustomerSegmentCustomer.CustomerSegmentGeneral
I3CRMCRMGeneral
A4columncolumnGeneral
B4CustomerCustomerGeneral
C4RelationshipOwnerRelationshipOwnerGeneral
D4StringStringGeneral
E4Accountable relationship owner.Accountable relationship owner.General
F4YesYesGeneral
G4Customer.RelationshipOwnerCustomer.RelationshipOwnerGeneral
I4CRMCRMGeneral
A5columncolumnGeneral
B5SalesOrderSalesOrderGeneral
C5OrderIdentifierOrderIdentifierGeneral
D5StringStringGeneral
E5Customer order identity.Customer order identity.General
F5YesYesGeneral
G5SalesOrder.OrderIdentifierSalesOrder.OrderIdentifierGeneral
I5Order platformOrder platformGeneral
A6columncolumnGeneral
B6SalesOrderSalesOrderGeneral
C6OrderGrossValueOrderGrossValueGeneral
D6DecimalDecimalGeneral
E6Gross order value before discounts.Gross order value before discounts.General
F6YesYesGeneral
G6SalesOrder.OrderGrossValueSalesOrder.OrderGrossValueGeneral
I6Order platformOrder platformGeneral
A7columncolumnGeneral
B7SalesOrderSalesOrderGeneral
C7SalesChannelSalesChannelGeneral
D7StringStringGeneral
E7Order acquisition channel.Order acquisition channel.General
F7YesYesGeneral
G7SalesOrder.SalesChannelSalesOrder.SalesChannelGeneral
I7Order platformOrder platformGeneral
A8measuremeasureGeneral
B8SalesMetricsSalesMetricsGeneral
C8Customer Lifetime ValueCustomer Lifetime ValueGeneral
D8DecimalDecimalGeneral
E8Expected customer lifetime value.Expected customer lifetime value.General
F8YesYesGeneral
G8SalesMetrics.Customer Lifetime ValueSalesMetrics.Customer Lifetime ValueGeneral
I8Derived target metricDerived target metricGeneral
A9measuremeasureGeneral
B9SalesMetricsSalesMetricsGeneral
C9Gross Order IntakeGross Order IntakeGeneral
D9DecimalDecimalGeneral
E9Gross booked order value.Gross booked order value.General
F9YesYesGeneral
G9SalesMetrics.Gross Order IntakeSalesMetrics.Gross Order IntakeGeneral
I9Derived target metricDerived target metricGeneral

Workbook visual aid

Target Fields

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Target Fields

Exact LLM input slice

Target Fields

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Target Fields]
::text_cells
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Current Hint
H1:Formula
I1:Source
J1:Consultant Notes
A2:column
B2:Customer
C2:CustomerIdentifier
D2:String
E2:Enterprise customer identity.
F2:Yes
G2:Customer.CustomerIdentifier
I2:CRM
A3:column
B3:Customer
C3:CustomerSegment
D3:String
E3:Commercial segment.
F3:Yes
G3:Customer.CustomerSegment
I3:CRM
A4:column
B4:Customer
C4:RelationshipOwner
D4:String
E4:Accountable relationship owner.
F4:Yes
G4:Customer.RelationshipOwner
I4:CRM
A5:column
B5:SalesOrder
C5:OrderIdentifier
D5:String
E5:Customer order identity.
F5:Yes
G5:SalesOrder.OrderIdentifier
I5:Order platform
A6:column
B6:SalesOrder
C6:OrderGrossValue
D6:Decimal
E6:Gross order value before discounts.
F6:Yes
G6:SalesOrder.OrderGrossValue
I6:Order platform
A7:column
B7:SalesOrder
C7:SalesChannel
D7:String
E7:Order acquisition channel.
F7:Yes
G7:SalesOrder.SalesChannel
I7:Order platform
A8:measure
B8:SalesMetrics
C8:Customer Lifetime Value
D8:Decimal
E8:Expected customer lifetime value.
F8:Yes
G8:SalesMetrics.Customer Lifetime Value
I8:Derived target metric
A9:measure
B9:SalesMetrics
C9:Gross Order Intake
D9:Decimal
E9:Gross booked order value.
F9:Yes
G9:SalesMetrics.Gross Order Intake
I9:Derived target metric
::sheet_structure
state:visible
used-range:A1:J9
freeze-panes:A2
auto-filter:A1:J9
::tables_names
table:TargetFields;range=A1:J9;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Current Hint,Formula,Source,Consultant Notes
::package_security
sheet-protection:not-found

Mapping Rules

5 × 3 · 0 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1RuleRuleGeneral
B1ValueValueGeneral
C1MeaningMeaningGeneral
A2Exact qualified nameExact qualified nameGeneral
B211General
C2Safe deterministic candidateSafe deterministic candidateGeneral
A3Declared current hintDeclared current hintGeneral
B30.80.8General
C3Candidate requiring semantic confirmationCandidate requiring semantic confirmationGeneral
A4Same object nameSame object nameGeneral
B40.70.7General
C4Candidate only; table context may differCandidate only; table context may differGeneral
A5No candidateNo candidateGeneral
B500General
C5Research or confirm absenceResearch or confirm absenceGeneral

Workbook visual aid

Mapping Rules

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Mapping Rules

Exact LLM input slice

Mapping Rules

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Mapping Rules]
::text_cells
A1:Rule
B1:Value
C1:Meaning
A2:Exact qualified name
C2:Safe deterministic candidate
A3:Declared current hint
C3:Candidate requiring semantic confirmation
A4:Same object name
C4:Candidate only; table context may differ
A5:No candidate
C5:Research or confirm absence
::sheet_structure
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

Reference Data

4 × 3 · 0 formulas · hidden

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CostCentreCostCentreGeneral
B1AccountGroupAccountGroupGeneral
C1CurrencyCodeCurrencyCodeGeneral
A2CC100CC100General
B2OperationsOperationsGeneral
C2AUDAUDGeneral
A3CC200CC200General
B3CommercialCommercialGeneral
C3AUDAUDGeneral
A4CC300CC300General
B4CorporateCorporateGeneral
C4NZDNZDGeneral

Workbook visual aid

Reference Data

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Reference Data

Exact LLM input slice

Reference Data

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Reference Data]
::text_cells
A1:CostCentre
B1:AccountGroup
C1:CurrencyCode
A2:CC100
B2:Operations
C2:AUD
A3:CC200
B3:Commercial
C3:AUD
A4:CC300
B4:Corporate
C4:NZD
::sheet_structure
state:hidden
used-range:A1:C4
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

Sample Input Data

3 × 4 · 0 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1OrderIdentifierOrderIdentifierGeneral
B1CustomerIdentifierCustomerIdentifierGeneral
C1OrderGrossValueOrderGrossValueGeneral
D1SalesChannelSalesChannelGeneral
A2SO-1001SO-1001General
B2CUST-001CUST-001General
C212501250General
D2DirectDirectGeneral
A3SO-1002SO-1002General
B3CUST-002CUST-002General
C3850850General
D3PartnerPartnerGeneral

Workbook visual aid

Sample Input Data

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Sample Input Data

Exact LLM input slice

Sample Input Data

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Sample Input Data]
::text_cells
A1:OrderIdentifier
B1:CustomerIdentifier
C1:OrderGrossValue
D1:SalesChannel
A2:SO-1001
B2:CUST-001
D2:Direct
A3:SO-1002
B3:CUST-002
D3:Partner
::sheet_structure
state:visible
used-range:A1:D3
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

Validation

3 × 3 · 2 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CheckCheckGeneral
B1FormulaFormulaGeneral
C1ExpectedExpectedGeneral
A2Target row countTarget row countGeneral
B2=COUNTA('Target Fields'!C:C)-1NoneGeneral
C2Number of declared target itemsNumber of declared target itemsGeneral
A3Required rowsRequired rowsGeneral
B3=COUNTIF('Target Fields'!F:F,"Yes")NoneGeneral
C3All declared rows in these fixturesAll declared rows in these fixturesGeneral

Workbook visual aid

Validation

Derived from retained preview cells; not evidence and not supplied to the LLM.

Large visual aid preview of Validation

Exact LLM input slice

Validation

Literal labels, structure, formulas and supported sheet metadata. Ordinary data values remain excluded.

[Sheet:Validation]
::text_cells
A1:Check
B1:Formula
C1:Expected
A2:Target row count
C2:Number of declared target items
A3:Required rows
C3:All declared rows in these fixtures
::sheet_structure
state:visible
used-range:A1:C3
freeze-panes:not-found
auto-filter:not-found
::formulas
B2:=COUNTA('Target Fields'!C:C)-1
B3:=COUNTIF('Target Fields'!F:F,"Yes")
::package_security
sheet-protection:not-found

Exact comparison payload

Complete workbook LLM evidence

This layered, capability-labelled packet is what the comparison model receives.

XLSX.evidence v2
artifact:ev_sha256_0e8e05870612083030a716d7c4543348c72982fbc2bc06fb257d6717d77c9f0a
profile:metadata-all
source-kind:xlsx
cell-values:literal-text-only
formulas:included
binary-payloads:indicator-only

[Workbook]
::workbook_metadata [status=found; inclusion=included; sensitivity=metadata; items=6; omitted=0]
calculation-mode:unspecified
property.title:Customer and Sales Target — Complete Miss
property.subject:Synthetic FDE BI target architecture fixture
property.creator:FDE BI web-app test harness
property.created:2026-01-01 00:00:00
property.modified:2026-01-01 00:00:00
::text_cells [status=found; inclusion=included; sensitivity=source_content; items=119; omitted=0]
sheet-items:119
::sheet_structure [status=found; inclusion=included; sensitivity=metadata; items=24; omitted=0]
sheet-items:24
::tables_names [status=found; inclusion=included; sensitivity=semantic_metadata; items=1; omitted=0]
sheet-items:1
::formulas [status=found; inclusion=included; sensitivity=business_logic; items=2; omitted=0]
sheet-items:2
::annotations_links [status=not_found; inclusion=included; sensitivity=source_content; items=0; omitted=0]
not-found
::validation_formatting [status=not_found; inclusion=included; sensitivity=business_logic; items=0; omitted=0]
not-found
::connectivity [status=not_found; inclusion=included; sensitivity=connection_metadata; items=0; omitted=0]
not-found
::power_query [status=not_found; inclusion=included; sensitivity=connection_logic; items=0; omitted=0]
not-found
::analytical_objects [status=not_found; inclusion=included; sensitivity=potential_data; items=0; omitted=0]
not-found
::embedded_model [status=not_found; inclusion=included; sensitivity=potential_data; items=0; omitted=0]
not-found
::package_security [status=found; inclusion=included; sensitivity=executable_or_security; items=11; omitted=0]
workbook-protection:not-found
ooxml-part-count:16
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Instructions]
::text_cells
A1:Customer and Sales Target — Complete Miss
A3:Scenario
B3:The target domain is not represented in the current FDEFinance semantic model.
A5:Interpretation
B5:The Target Fields sheet declares target architecture. Other sheets may contain mapping rules, validation formulas, reference data, or sample inputs and must not automatically become target fields.
::sheet_structure
state:visible
used-range:A1:B5
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Target Fields]
::text_cells
A1:Object Type
B1:Entity
C1:Name
D1:Data Type
E1:Business Definition
F1:Required
G1:Current Hint
H1:Formula
I1:Source
J1:Consultant Notes
A2:column
B2:Customer
C2:CustomerIdentifier
D2:String
E2:Enterprise customer identity.
F2:Yes
G2:Customer.CustomerIdentifier
I2:CRM
A3:column
B3:Customer
C3:CustomerSegment
D3:String
E3:Commercial segment.
F3:Yes
G3:Customer.CustomerSegment
I3:CRM
A4:column
B4:Customer
C4:RelationshipOwner
D4:String
E4:Accountable relationship owner.
F4:Yes
G4:Customer.RelationshipOwner
I4:CRM
A5:column
B5:SalesOrder
C5:OrderIdentifier
D5:String
E5:Customer order identity.
F5:Yes
G5:SalesOrder.OrderIdentifier
I5:Order platform
A6:column
B6:SalesOrder
C6:OrderGrossValue
D6:Decimal
E6:Gross order value before discounts.
F6:Yes
G6:SalesOrder.OrderGrossValue
I6:Order platform
A7:column
B7:SalesOrder
C7:SalesChannel
D7:String
E7:Order acquisition channel.
F7:Yes
G7:SalesOrder.SalesChannel
I7:Order platform
A8:measure
B8:SalesMetrics
C8:Customer Lifetime Value
D8:Decimal
E8:Expected customer lifetime value.
F8:Yes
G8:SalesMetrics.Customer Lifetime Value
I8:Derived target metric
A9:measure
B9:SalesMetrics
C9:Gross Order Intake
D9:Decimal
E9:Gross booked order value.
F9:Yes
G9:SalesMetrics.Gross Order Intake
I9:Derived target metric
::sheet_structure
state:visible
used-range:A1:J9
freeze-panes:A2
auto-filter:A1:J9
::tables_names
table:TargetFields;range=A1:J9;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Current Hint,Formula,Source,Consultant Notes
::package_security
sheet-protection:not-found

[Sheet:Mapping Rules]
::text_cells
A1:Rule
B1:Value
C1:Meaning
A2:Exact qualified name
C2:Safe deterministic candidate
A3:Declared current hint
C3:Candidate requiring semantic confirmation
A4:Same object name
C4:Candidate only; table context may differ
A5:No candidate
C5:Research or confirm absence
::sheet_structure
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Reference Data]
::text_cells
A1:CostCentre
B1:AccountGroup
C1:CurrencyCode
A2:CC100
B2:Operations
C2:AUD
A3:CC200
B3:Commercial
C3:AUD
A4:CC300
B4:Corporate
C4:NZD
::sheet_structure
state:hidden
used-range:A1:C4
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Sample Input Data]
::text_cells
A1:OrderIdentifier
B1:CustomerIdentifier
C1:OrderGrossValue
D1:SalesChannel
A2:SO-1001
B2:CUST-001
D2:Direct
A3:SO-1002
B3:CUST-002
D3:Partner
::sheet_structure
state:visible
used-range:A1:D3
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Validation]
::text_cells
A1:Check
B1:Formula
C1:Expected
A2:Target row count
C2:Number of declared target items
A3:Required rows
C3:All declared rows in these fixtures
::sheet_structure
state:visible
used-range:A1:C3
freeze-panes:not-found
auto-filter:not-found
::formulas
B2:=COUNTA('Target Fields'!C:C)-1
B3:=COUNTIF('Target Fields'!F:F,"Yes")
::package_security
sheet-protection:not-found