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_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
Read Me
[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
Target Fields
[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
Customer Sample
[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
Sales Orders
[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
Sales KPI Prototype
[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
Reference Data
[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
Validation
[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