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