XLSX.evidence v2
artifact:ev_sha256_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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:auto
property.title:Customer and Order Analytics — Discovery Pack
property.subject:Synthetic target metadata and report prototype
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=197; omitted=0]
sheet-items:197
::sheet_structure [status=found; inclusion=included; sensitivity=metadata; items=32; omitted=0]
sheet-items:32
::tables_names [status=found; inclusion=included; sensitivity=semantic_metadata; items=3; omitted=0]
sheet-items:3
::formulas [status=found; inclusion=included; sensitivity=business_logic; items=4; omitted=0]
sheet-items:4
::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=12; omitted=0]
workbook-protection:not-found
ooxml-part-count:21
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Read Me]
::text_cells
A1:Customer and Order Analytics — Discovery Pack
A3:Document purpose
B3:Document the customer, sales-order, and commercial KPI metadata requested for a new analytics subject area.
A4:Prepared for
B4:Data and reporting discovery workshop
A5:Business owner
B5:Reporting Transformation
A6:Planning horizon
B6:FY2026–FY2027
A8:How to use this workbook
B8:Target Fields is the authoritative register of requested data objects. The working sheets contain synthetic records and formulas that illustrate grain and intended report behaviour.
A10:Scope note
B10:All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.
::sheet_structure
state:visible
used-range:A1:F10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:F1
::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:Business Owner
H1:Calculation
I1:Planned Source
J1:Implementation Notes
A2:column
B2:Customer
C2:CustomerIdentifier
D2:String
E2:Enterprise customer identity.
F2:Yes
G2:Customer Operations
I2:CRM customer master
A3:column
B3:Customer
C3:CustomerSegment
D3:String
E3:Commercial segment.
F3:Yes
G3:Customer Operations
I3:CRM customer master
A4:column
B4:Customer
C4:RelationshipOwner
D4:String
E4:Accountable relationship owner.
F4:Yes
G4:Customer Operations
I4:CRM customer master
A5:column
B5:SalesOrder
C5:OrderIdentifier
D5:String
E5:Customer order identity.
F5:Yes
G5:Sales Operations
I5:Order management platform
A6:column
B6:SalesOrder
C6:OrderGrossValue
D6:Decimal
E6:Gross order value before discounts.
F6:Yes
G6:Sales Operations
I6:Order management platform
A7:column
B7:SalesOrder
C7:SalesChannel
D7:String
E7:Order acquisition channel.
F7:Yes
G7:Sales Operations
I7:Order management platform
A8:measure
B8:SalesMetrics
C8:Customer Lifetime Value
D8:Decimal
E8:Expected customer lifetime value.
F8:Yes
G8:Commercial Analytics
H8:Average gross order value multiplied by expected order frequency
I8:Sales analytics calculation layer
A9:measure
B9:SalesMetrics
C9:Gross Order Intake
D9:Decimal
E9:Gross booked order value.
F9:Yes
G9:Commercial Analytics
H9:Sum of OrderGrossValue
I9:Sales analytics calculation layer
::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,Business Owner,Calculation,Planned Source,Implementation Notes
::package_security
sheet-protection:not-found

[Sheet:Customer Sample]
::text_cells
A1:Customer master — representative records
A2:Synthetic customer-level data for requirements workshops
A3:CustomerIdentifier
B3:CustomerSegment
C3:RelationshipOwner
A4:CUST-1001
B4:Enterprise
C4:Maya Chen
A5:CUST-1002
B5:Mid-market
C5:Noah Williams
A6:CUST-1003
B6:Small business
C6:Amelia Singh
A7:CUST-1004
B7:Enterprise
C7:Maya Chen
A8:CUST-1005
B8:Mid-market
C8:Jack Martin
A9:CUST-1006
B9:Small business
C9:Amelia Singh
A10:CUST-1007
B10:Enterprise
C10:Noah Williams
A11:CUST-1008
B11:Mid-market
C11:Jack Martin
::sheet_structure
state:visible
used-range:A1:C11
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1
::tables_names
table:CustomerSample;range=A3:C11;columns=CustomerIdentifier,CustomerSegment,RelationshipOwner
::package_security
sheet-protection:not-found

[Sheet:Sales Orders]
::text_cells
A1:Sales orders — representative booked orders
A2:Synthetic order-level data; gross values are before discounts
A3:OrderIdentifier
B3:CustomerIdentifier
C3:OrderGrossValue
D3:SalesChannel
A4:SO-260701
B4:CUST-1001
D4:Direct
A5:SO-260702
B5:CUST-1002
D5:Partner
A6:SO-260703
B6:CUST-1003
D6:Online
A7:SO-260704
B7:CUST-1004
D7:Direct
A8:SO-260705
B8:CUST-1005
D8:Partner
A9:SO-260706
B9:CUST-1006
D9:Online
A10:SO-260707
B10:CUST-1007
D10:Direct
A11:SO-260708
B11:CUST-1008
D11:Partner
A12:SO-260709
B12:CUST-1001
D12:Online
A13:SO-260710
B13:CUST-1002
D13:Direct
A14:SO-260711
B14:CUST-1004
D14:Partner
A15:SO-260712
B15:CUST-1007
D15:Online
::sheet_structure
state:visible
used-range:A1:D15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1
::tables_names
table:SalesOrders;range=A3:D15;columns=OrderIdentifier,CustomerIdentifier,OrderGrossValue,SalesChannel
::package_security
sheet-protection:not-found

[Sheet:Sales KPI Prototype]
::text_cells
A1:Sales KPI prototype — booked order view
A2:Formula-driven illustration using the synthetic customer and order sheets
A3:Metric
B3:Amount
C3:Interpretation
A4:Gross Order Intake
C4:Gross value of representative booked orders
A5:Customer Lifetime Value
C5:Illustrative frequency multiplier for discovery only
::sheet_structure
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:C1
::formulas
B4:=SUM('Sales Orders'!C4:C15) | format=$#,##0.00
B5:=B4/COUNTA('Customer Sample'!A4:A11)*3.2 | format=$#,##0.00
::package_security
sheet-protection:not-found

[Sheet:Reference Data]
::text_cells
A1:List
B1:Code
C1:Display Value
A2:CustomerSegment
B2:ENT
C2:Enterprise
A3:CustomerSegment
B3:MID
C3:Mid-market
A4:CustomerSegment
B4:SMB
C4:Small business
A5:SalesChannel
B5:DIR
C5:Direct
A6:SalesChannel
B6:PAR
C6:Partner
A7:SalesChannel
B7:ONL
C7:Online
::sheet_structure
state:hidden
used-range:A1:C7
freeze-panes:not-found
auto-filter:not-found
::package_security
sheet-protection:not-found

[Sheet:Validation]
::text_cells
A1:Check
B1:Result
C1:Expected
A2:Declared field count
C2:One row per requested attribute or measure
A3:Required field count
C3:All rows in the register are required
::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