Exact model input
Everything the model was given
Literal labels, structure, formulas and supported metadata. Ordinary numeric, date and Boolean values are excluded, and opaque binary payloads are never placed in the prompt.
Complete packet
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
Instructions
[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
[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
[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
[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
[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
[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