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

Workbook evidence

TargetArchitecture_CompleteMiss.xlsx

3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a

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
7833

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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:workbook_metadata
label:Workbook metadata
status:found
inclusion:included
sensitivity:metadata
item-count:6
character-count:267
omitted-item-count:0

[Workbook]
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

Literal text cells

found

197 items extracted and included.

Items
197
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:text_cells
label:Literal text cells
status:found
inclusion:included
sensitivity:source_content
item-count:197
character-count:3968
omitted-item-count:0

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

Workbook and sheet structure

found

32 items extracted and included.

Items
32
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:sheet_structure
label:Workbook and sheet structure
status:found
inclusion:included
sensitivity:metadata
item-count:32
character-count:585
omitted-item-count:0

[Sheet:Read Me]
state:visible
used-range:A1:F10
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:F1

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

[Sheet:Customer Sample]
state:visible
used-range:A1:C11
freeze-panes:A4
auto-filter:not-found
merged-range:A1:C1

[Sheet:Sales Orders]
state:visible
used-range:A1:D15
freeze-panes:A4
auto-filter:not-found
merged-range:A1:D1

[Sheet:Sales KPI Prototype]
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found
merged-range:A1:C1

[Sheet:Reference Data]
state:hidden
used-range:A1:C7
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

3 items extracted and included.

Items
3
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:tables_names
label:Tables and defined names
status:found
inclusion:included
sensitivity:semantic_metadata
item-count:3
character-count:363
omitted-item-count:0

[Sheet:Target Fields]
table:TargetFields;range=A1:J9;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Business Owner,Calculation,Planned Source,Implementation Notes

[Sheet:Customer Sample]
table:CustomerSample;range=A3:C11;columns=CustomerIdentifier,CustomerSegment,RelationshipOwner

[Sheet:Sales Orders]
table:SalesOrders;range=A3:D15;columns=OrderIdentifier,CustomerIdentifier,OrderGrossValue,SalesChannel

formulas

Formulas and external formula references

found

4 items extracted and included.

Items
4
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:formulas
label:Formulas and external formula references
status:found
inclusion:included
sensitivity:business_logic
item-count:4
character-count:186
omitted-item-count:0

[Sheet:Sales KPI Prototype]
B4:=SUM('Sales Orders'!C4:C15) | format=$#,##0.00
B5:=B4/COUNTA('Customer Sample'!A4:A11)*3.2 | format=$#,##0.00

[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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
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

12 items extracted and included.

Items
12
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_3437bb8ca30206049ceaf929ea025036c5b6d9bc6c2a9fc04bb6ce6182d4182a
category:package_security
label:Package, macros, embedded objects and security
status:found
inclusion:included
sensitivity:executable_or_security
item-count:12
character-count:301
omitted-item-count:0

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

[Sheet:Read Me]
sheet-protection:not-found

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

[Sheet:Customer Sample]
sheet-protection:not-found

[Sheet:Sales Orders]
sheet-protection:not-found

[Sheet:Sales KPI Prototype]
sheet-protection:not-found

[Sheet:Reference 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.

Read Me

10 × 6 · 0 formulas · visible

Inspect retained cell ledger+
merged A1:F1
CellObserved value/formulaCached valueFormat
A1Customer and Order Analytics — Discovery PackCustomer and Order Analytics — Discovery PackGeneral
A3Document purposeDocument purposeGeneral
B3Document the customer, sales-order, and commercial KPI metadata requested for a new analytics subject area.Document the customer, sales-order, and commercial KPI metadata requested for a new analytics subject area.General
A4Prepared forPrepared forGeneral
B4Data and reporting discovery workshopData and reporting discovery workshopGeneral
A5Business ownerBusiness ownerGeneral
B5Reporting TransformationReporting TransformationGeneral
A6Planning horizonPlanning horizonGeneral
B6FY2026–FY2027FY2026–FY2027General
A8How to use this workbookHow to use this workbookGeneral
B8Target Fields is the authoritative register of requested data objects. The working sheets contain synthetic records and formulas that illustrate grain and intended report behaviour.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.General
A10Scope noteScope noteGeneral
B10All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.All sample values are fictional and are provided for design discussion, not reconciliation or production reporting.General

Workbook visual aid

Read Me

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

Large visual aid preview of Read Me

Exact LLM input slice

Read Me

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

[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

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
G1Business OwnerBusiness OwnerGeneral
H1CalculationCalculationGeneral
I1Planned SourcePlanned SourceGeneral
J1Implementation NotesImplementation NotesGeneral
A2columncolumnGeneral
B2CustomerCustomerGeneral
C2CustomerIdentifierCustomerIdentifierGeneral
D2StringStringGeneral
E2Enterprise customer identity.Enterprise customer identity.General
F2YesYesGeneral
G2Customer OperationsCustomer OperationsGeneral
I2CRM customer masterCRM customer masterGeneral
A3columncolumnGeneral
B3CustomerCustomerGeneral
C3CustomerSegmentCustomerSegmentGeneral
D3StringStringGeneral
E3Commercial segment.Commercial segment.General
F3YesYesGeneral
G3Customer OperationsCustomer OperationsGeneral
I3CRM customer masterCRM customer masterGeneral
A4columncolumnGeneral
B4CustomerCustomerGeneral
C4RelationshipOwnerRelationshipOwnerGeneral
D4StringStringGeneral
E4Accountable relationship owner.Accountable relationship owner.General
F4YesYesGeneral
G4Customer OperationsCustomer OperationsGeneral
I4CRM customer masterCRM customer masterGeneral
A5columncolumnGeneral
B5SalesOrderSalesOrderGeneral
C5OrderIdentifierOrderIdentifierGeneral
D5StringStringGeneral
E5Customer order identity.Customer order identity.General
F5YesYesGeneral
G5Sales OperationsSales OperationsGeneral
I5Order management platformOrder management platformGeneral
A6columncolumnGeneral
B6SalesOrderSalesOrderGeneral
C6OrderGrossValueOrderGrossValueGeneral
D6DecimalDecimalGeneral
E6Gross order value before discounts.Gross order value before discounts.General
F6YesYesGeneral
G6Sales OperationsSales OperationsGeneral
I6Order management platformOrder management platformGeneral
A7columncolumnGeneral
B7SalesOrderSalesOrderGeneral
C7SalesChannelSalesChannelGeneral
D7StringStringGeneral
E7Order acquisition channel.Order acquisition channel.General
F7YesYesGeneral
G7Sales OperationsSales OperationsGeneral
I7Order management platformOrder management platformGeneral
A8measuremeasureGeneral
B8SalesMetricsSalesMetricsGeneral
C8Customer Lifetime ValueCustomer Lifetime ValueGeneral
D8DecimalDecimalGeneral
E8Expected customer lifetime value.Expected customer lifetime value.General
F8YesYesGeneral
G8Commercial AnalyticsCommercial AnalyticsGeneral
H8Average gross order value multiplied by expected order frequencyAverage gross order value multiplied by expected order frequencyGeneral
I8Sales analytics calculation layerSales analytics calculation layerGeneral
A9measuremeasureGeneral
B9SalesMetricsSalesMetricsGeneral
C9Gross Order IntakeGross Order IntakeGeneral
D9DecimalDecimalGeneral
E9Gross booked order value.Gross booked order value.General
F9YesYesGeneral
G9Commercial AnalyticsCommercial AnalyticsGeneral
H9Sum of OrderGrossValueSum of OrderGrossValueGeneral
I9Sales analytics calculation layerSales analytics calculation layerGeneral

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: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

11 × 3 · 0 formulas · visible

Inspect retained cell ledger+
CustomerSample A3:C11merged A1:C1
CellObserved value/formulaCached valueFormat
A1Customer master — representative recordsCustomer master — representative recordsGeneral
A2Synthetic customer-level data for requirements workshopsSynthetic customer-level data for requirements workshopsGeneral
A3CustomerIdentifierCustomerIdentifierGeneral
B3CustomerSegmentCustomerSegmentGeneral
C3RelationshipOwnerRelationshipOwnerGeneral
A4CUST-1001CUST-1001General
B4EnterpriseEnterpriseGeneral
C4Maya ChenMaya ChenGeneral
A5CUST-1002CUST-1002General
B5Mid-marketMid-marketGeneral
C5Noah WilliamsNoah WilliamsGeneral
A6CUST-1003CUST-1003General
B6Small businessSmall businessGeneral
C6Amelia SinghAmelia SinghGeneral
A7CUST-1004CUST-1004General
B7EnterpriseEnterpriseGeneral
C7Maya ChenMaya ChenGeneral
A8CUST-1005CUST-1005General
B8Mid-marketMid-marketGeneral
C8Jack MartinJack MartinGeneral
A9CUST-1006CUST-1006General
B9Small businessSmall businessGeneral
C9Amelia SinghAmelia SinghGeneral
A10CUST-1007CUST-1007General
B10EnterpriseEnterpriseGeneral
C10Noah WilliamsNoah WilliamsGeneral
A11CUST-1008CUST-1008General
B11Mid-marketMid-marketGeneral
C11Jack MartinJack MartinGeneral

Workbook visual aid

Customer Sample

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

Large visual aid preview of Customer Sample

Exact LLM input slice

Customer Sample

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

[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

15 × 4 · 0 formulas · visible

Inspect retained cell ledger+
SalesOrders A3:D15merged A1:D1
CellObserved value/formulaCached valueFormat
A1Sales orders — representative booked ordersSales orders — representative booked ordersGeneral
A2Synthetic order-level data; gross values are before discountsSynthetic order-level data; gross values are before discountsGeneral
A3OrderIdentifierOrderIdentifierGeneral
B3CustomerIdentifierCustomerIdentifierGeneral
C3OrderGrossValueOrderGrossValueGeneral
D3SalesChannelSalesChannelGeneral
A4SO-260701SO-260701General
B4CUST-1001CUST-1001General
C44250042500$#,##0.00
D4DirectDirectGeneral
A5SO-260702SO-260702General
B5CUST-1002CUST-1002General
C51280012800$#,##0.00
D5PartnerPartnerGeneral
A6SO-260703SO-260703General
B6CUST-1003CUST-1003General
C632003200$#,##0.00
D6OnlineOnlineGeneral
A7SO-260704SO-260704General
B7CUST-1004CUST-1004General
C75180051800$#,##0.00
D7DirectDirectGeneral
A8SO-260705SO-260705General
B8CUST-1005CUST-1005General
C81640016400$#,##0.00
D8PartnerPartnerGeneral
A9SO-260706SO-260706General
B9CUST-1006CUST-1006General
C947004700$#,##0.00
D9OnlineOnlineGeneral
A10SO-260707SO-260707General
B10CUST-1007CUST-1007General
C103360033600$#,##0.00
D10DirectDirectGeneral
A11SO-260708SO-260708General
B11CUST-1008CUST-1008General
C111120011200$#,##0.00
D11PartnerPartnerGeneral
A12SO-260709SO-260709General
B12CUST-1001CUST-1001General
C1286008600$#,##0.00
D12OnlineOnlineGeneral
A13SO-260710SO-260710General
B13CUST-1002CUST-1002General
C131940019400$#,##0.00
D13DirectDirectGeneral
A14SO-260711SO-260711General
B14CUST-1004CUST-1004General
C142350023500$#,##0.00
D14PartnerPartnerGeneral
A15SO-260712SO-260712General
B15CUST-1007CUST-1007General
C1569006900$#,##0.00
D15OnlineOnlineGeneral

Workbook visual aid

Sales Orders

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

Large visual aid preview of Sales Orders

Exact LLM input slice

Sales Orders

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

[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

5 × 3 · 2 formulas · visible

Inspect retained cell ledger+
merged A1:C1
CellObserved value/formulaCached valueFormat
A1Sales KPI prototype — booked order viewSales KPI prototype — booked order viewGeneral
A2Formula-driven illustration using the synthetic customer and order sheetsFormula-driven illustration using the synthetic customer and order sheetsGeneral
A3MetricMetricGeneral
B3AmountAmountGeneral
C3InterpretationInterpretationGeneral
A4Gross Order IntakeGross Order IntakeGeneral
B4=SUM('Sales Orders'!C4:C15)None$#,##0.00
C4Gross value of representative booked ordersGross value of representative booked ordersGeneral
A5Customer Lifetime ValueCustomer Lifetime ValueGeneral
B5=B4/COUNTA('Customer Sample'!A4:A11)*3.2None$#,##0.00
C5Illustrative frequency multiplier for discovery onlyIllustrative frequency multiplier for discovery onlyGeneral

Workbook visual aid

Sales KPI Prototype

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

Large visual aid preview of Sales KPI Prototype

Exact LLM input slice

Sales KPI Prototype

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

[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

7 × 3 · 0 formulas · hidden

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1ListListGeneral
B1CodeCodeGeneral
C1Display ValueDisplay ValueGeneral
A2CustomerSegmentCustomerSegmentGeneral
B2ENTENTGeneral
C2EnterpriseEnterpriseGeneral
A3CustomerSegmentCustomerSegmentGeneral
B3MIDMIDGeneral
C3Mid-marketMid-marketGeneral
A4CustomerSegmentCustomerSegmentGeneral
B4SMBSMBGeneral
C4Small businessSmall businessGeneral
A5SalesChannelSalesChannelGeneral
B5DIRDIRGeneral
C5DirectDirectGeneral
A6SalesChannelSalesChannelGeneral
B6PARPARGeneral
C6PartnerPartnerGeneral
A7SalesChannelSalesChannelGeneral
B7ONLONLGeneral
C7OnlineOnlineGeneral

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: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

3 × 3 · 2 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CheckCheckGeneral
B1ResultResultGeneral
C1ExpectedExpectedGeneral
A2Declared field countDeclared field countGeneral
B2=COUNTA('Target Fields'!C:C)-1NoneGeneral
C2One row per requested attribute or measureOne row per requested attribute or measureGeneral
A3Required field countRequired field countGeneral
B3=COUNTIF('Target Fields'!F:F,"Yes")NoneGeneral
C3All rows in the register are requiredAll rows in the register are requiredGeneral

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: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

Exact comparison payload

Complete workbook LLM evidence

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

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