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

Workbook evidence

TargetArchitecture_Partial.xlsx

480433cbc86b45db9ec61c5c174d60618afe10338cbd09c31c5a523ee7f33e5c

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
6127

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

[Workbook]
calculation-mode:unspecified
property.title:FDE Finance Target — Partial Gap
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

Literal text cells

found

152 items extracted and included.

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

[Sheet:Instructions]
A1:FDE Finance Target — Partial Gap
A3:Scenario
B3:Most items match; CostCentre, CurrencyCode, and AccountGroup are target gaps.
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:Target Fields]
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:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Account.AccountKey
I2:Existing Power BI semantic model
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Account.AccountName
I3:Existing Power BI semantic model
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Account.AccountType
I4:Existing Power BI semantic model
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Calendar.DateKey
I5:Existing Power BI semantic model
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Calendar.Date
I6:Existing Power BI semantic model
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Calendar.FiscalMonth
I7:Existing Power BI semantic model
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Ledger.DateKey
I8:Existing Power BI semantic model
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Ledger.AccountKey
I9:Existing Power BI semantic model
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Ledger.SignedAmount
I10:Existing Power BI semantic model
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Ledger.IsAdjustment
I11:Existing Power BI semantic model
A12:column
B12:Ledger
C12:CostCentre
D12:String
E12:Management cost-centre code.
F12:Yes
G12:Ledger.CostCentre
I12:Finance posting source / embedded reference data
J12:Not expected in current test model.
A13:column
B13:Ledger
C13:CurrencyCode
D13:String
E13:ISO reporting currency code.
F13:Yes
G13:Ledger.CurrencyCode
I13:Finance posting source
J13:Not expected in current test model.
A14:column
B14:Account
C14:AccountGroup
D14:String
E14:Management reporting group above account type.
F14:Yes
G14:Account.AccountGroup
I14:Account master / embedded mapping
J14:Target enrichment requirement.

[Sheet:Mapping Rules]
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:Reference Data]
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:Validation]
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

Workbook and sheet structure

found

20 items extracted and included.

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

[Sheet:Instructions]
state:visible
used-range:A1:B5
freeze-panes:not-found
auto-filter:not-found

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

[Sheet:Mapping Rules]
state:visible
used-range:A1:C5
freeze-panes:not-found
auto-filter:not-found

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

1 items extracted and included.

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

[Sheet:Target Fields]
table:TargetFields;range=A1:J14;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Current Hint,Formula,Source,Consultant Notes

formulas

Formulas and external formula references

found

2 items extracted and included.

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

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

10 items extracted and included.

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

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

[Sheet:Instructions]
sheet-protection:not-found

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

[Sheet:Mapping Rules]
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.

Instructions

5 × 2 · 0 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1FDE Finance Target — Partial GapFDE Finance Target — Partial GapGeneral
A3ScenarioScenarioGeneral
B3Most items match; CostCentre, CurrencyCode, and AccountGroup are target gaps.Most items match; CostCentre, CurrencyCode, and AccountGroup are target gaps.General
A5InterpretationInterpretationGeneral
B5The 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.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.General

Workbook visual aid

Instructions

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

Large visual aid preview of Instructions

Exact LLM input slice

Instructions

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

[Sheet:Instructions]
::text_cells
A1:FDE Finance Target — Partial Gap
A3:Scenario
B3:Most items match; CostCentre, CurrencyCode, and AccountGroup are target gaps.
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

14 × 10 · 0 formulas · visible

Inspect retained cell ledger+
TargetFields A1:J14
CellObserved value/formulaCached valueFormat
A1Object TypeObject TypeGeneral
B1EntityEntityGeneral
C1NameNameGeneral
D1Data TypeData TypeGeneral
E1Business DefinitionBusiness DefinitionGeneral
F1RequiredRequiredGeneral
G1Current HintCurrent HintGeneral
H1FormulaFormulaGeneral
I1SourceSourceGeneral
J1Consultant NotesConsultant NotesGeneral
A2columncolumnGeneral
B2AccountAccountGeneral
C2AccountKeyAccountKeyGeneral
D2Int64Int64General
E2Stable account identifier.Stable account identifier.General
F2YesYesGeneral
G2Account.AccountKeyAccount.AccountKeyGeneral
I2Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A3columncolumnGeneral
B3AccountAccountGeneral
C3AccountNameAccountNameGeneral
D3StringStringGeneral
E3Finance account display name.Finance account display name.General
F3YesYesGeneral
G3Account.AccountNameAccount.AccountNameGeneral
I3Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A4columncolumnGeneral
B4AccountAccountGeneral
C4AccountTypeAccountTypeGeneral
D4StringStringGeneral
E4Revenue or expense classification.Revenue or expense classification.General
F4YesYesGeneral
G4Account.AccountTypeAccount.AccountTypeGeneral
I4Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A5columncolumnGeneral
B5CalendarCalendarGeneral
C5DateKeyDateKeyGeneral
D5Int64Int64General
E5Integer date key in YYYYMMDD form.Integer date key in YYYYMMDD form.General
F5YesYesGeneral
G5Calendar.DateKeyCalendar.DateKeyGeneral
I5Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A6columncolumnGeneral
B6CalendarCalendarGeneral
C6DateDateGeneral
D6DateTimeDateTimeGeneral
E6Posting calendar date.Posting calendar date.General
F6YesYesGeneral
G6Calendar.DateCalendar.DateGeneral
I6Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A7columncolumnGeneral
B7CalendarCalendarGeneral
C7FiscalMonthFiscalMonthGeneral
D7Int64Int64General
E7Fiscal month number.Fiscal month number.General
F7YesYesGeneral
G7Calendar.FiscalMonthCalendar.FiscalMonthGeneral
I7Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A8columncolumnGeneral
B8LedgerLedgerGeneral
C8DateKeyDateKeyGeneral
D8Int64Int64General
E8Posting date foreign key.Posting date foreign key.General
F8YesYesGeneral
G8Ledger.DateKeyLedger.DateKeyGeneral
I8Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A9columncolumnGeneral
B9LedgerLedgerGeneral
C9AccountKeyAccountKeyGeneral
D9Int64Int64General
E9Account foreign key.Account foreign key.General
F9YesYesGeneral
G9Ledger.AccountKeyLedger.AccountKeyGeneral
I9Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A10columncolumnGeneral
B10LedgerLedgerGeneral
C10SignedAmountSignedAmountGeneral
D10DecimalDecimalGeneral
E10Signed ledger amount in reporting currency.Signed ledger amount in reporting currency.General
F10YesYesGeneral
G10Ledger.SignedAmountLedger.SignedAmountGeneral
I10Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A11columncolumnGeneral
B11LedgerLedgerGeneral
C11IsAdjustmentIsAdjustmentGeneral
D11BooleanBooleanGeneral
E11Identifies late or manual adjustments.Identifies late or manual adjustments.General
F11YesYesGeneral
G11Ledger.IsAdjustmentLedger.IsAdjustmentGeneral
I11Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A12columncolumnGeneral
B12LedgerLedgerGeneral
C12CostCentreCostCentreGeneral
D12StringStringGeneral
E12Management cost-centre code.Management cost-centre code.General
F12YesYesGeneral
G12Ledger.CostCentreLedger.CostCentreGeneral
I12Finance posting source / embedded reference dataFinance posting source / embedded reference dataGeneral
J12Not expected in current test model.Not expected in current test model.General
A13columncolumnGeneral
B13LedgerLedgerGeneral
C13CurrencyCodeCurrencyCodeGeneral
D13StringStringGeneral
E13ISO reporting currency code.ISO reporting currency code.General
F13YesYesGeneral
G13Ledger.CurrencyCodeLedger.CurrencyCodeGeneral
I13Finance posting sourceFinance posting sourceGeneral
J13Not expected in current test model.Not expected in current test model.General
A14columncolumnGeneral
B14AccountAccountGeneral
C14AccountGroupAccountGroupGeneral
D14StringStringGeneral
E14Management reporting group above account type.Management reporting group above account type.General
F14YesYesGeneral
G14Account.AccountGroupAccount.AccountGroupGeneral
I14Account master / embedded mappingAccount master / embedded mappingGeneral
J14Target enrichment requirement.Target enrichment requirement.General

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:Current Hint
H1:Formula
I1:Source
J1:Consultant Notes
A2:column
B2:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Account.AccountKey
I2:Existing Power BI semantic model
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Account.AccountName
I3:Existing Power BI semantic model
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Account.AccountType
I4:Existing Power BI semantic model
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Calendar.DateKey
I5:Existing Power BI semantic model
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Calendar.Date
I6:Existing Power BI semantic model
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Calendar.FiscalMonth
I7:Existing Power BI semantic model
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Ledger.DateKey
I8:Existing Power BI semantic model
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Ledger.AccountKey
I9:Existing Power BI semantic model
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Ledger.SignedAmount
I10:Existing Power BI semantic model
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Ledger.IsAdjustment
I11:Existing Power BI semantic model
A12:column
B12:Ledger
C12:CostCentre
D12:String
E12:Management cost-centre code.
F12:Yes
G12:Ledger.CostCentre
I12:Finance posting source / embedded reference data
J12:Not expected in current test model.
A13:column
B13:Ledger
C13:CurrencyCode
D13:String
E13:ISO reporting currency code.
F13:Yes
G13:Ledger.CurrencyCode
I13:Finance posting source
J13:Not expected in current test model.
A14:column
B14:Account
C14:AccountGroup
D14:String
E14:Management reporting group above account type.
F14:Yes
G14:Account.AccountGroup
I14:Account master / embedded mapping
J14:Target enrichment requirement.
::sheet_structure
state:visible
used-range:A1:J14
freeze-panes:A2
auto-filter:A1:J14
::tables_names
table:TargetFields;range=A1:J14;columns=Object Type,Entity,Name,Data Type,Business Definition,Required,Current Hint,Formula,Source,Consultant Notes
::package_security
sheet-protection:not-found

Mapping Rules

5 × 3 · 0 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1RuleRuleGeneral
B1ValueValueGeneral
C1MeaningMeaningGeneral
A2Exact qualified nameExact qualified nameGeneral
B211General
C2Safe deterministic candidateSafe deterministic candidateGeneral
A3Declared current hintDeclared current hintGeneral
B30.80.8General
C3Candidate requiring semantic confirmationCandidate requiring semantic confirmationGeneral
A4Same object nameSame object nameGeneral
B40.70.7General
C4Candidate only; table context may differCandidate only; table context may differGeneral
A5No candidateNo candidateGeneral
B500General
C5Research or confirm absenceResearch or confirm absenceGeneral

Workbook visual aid

Mapping Rules

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

Large visual aid preview of Mapping Rules

Exact LLM input slice

Mapping Rules

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

[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

4 × 3 · 0 formulas · hidden

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CostCentreCostCentreGeneral
B1AccountGroupAccountGroupGeneral
C1CurrencyCodeCurrencyCodeGeneral
A2CC100CC100General
B2OperationsOperationsGeneral
C2AUDAUDGeneral
A3CC200CC200General
B3CommercialCommercialGeneral
C3AUDAUDGeneral
A4CC300CC300General
B4CorporateCorporateGeneral
C4NZDNZDGeneral

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

Validation

3 × 3 · 2 formulas · visible

Inspect retained cell ledger+
CellObserved value/formulaCached valueFormat
A1CheckCheckGeneral
B1FormulaFormulaGeneral
C1ExpectedExpectedGeneral
A2Target row countTarget row countGeneral
B2=COUNTA('Target Fields'!C:C)-1NoneGeneral
C2Number of declared target itemsNumber of declared target itemsGeneral
A3Required rowsRequired rowsGeneral
B3=COUNTIF('Target Fields'!F:F,"Yes")NoneGeneral
C3All declared rows in these fixturesAll declared rows in these fixturesGeneral

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

Exact comparison payload

Complete workbook LLM evidence

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

XLSX.evidence v2
artifact:ev_sha256_480433cbc86b45db9ec61c5c174d60618afe10338cbd09c31c5a523ee7f33e5c
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:FDE Finance Target — Partial Gap
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=152; omitted=0]
sheet-items:152
::sheet_structure [status=found; inclusion=included; sensitivity=metadata; items=20; omitted=0]
sheet-items:20
::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=10; omitted=0]
workbook-protection:not-found
ooxml-part-count:15
vba-project:not-found
embedded-objects:0
digital-signatures:0

[Sheet:Instructions]
::text_cells
A1:FDE Finance Target — Partial Gap
A3:Scenario
B3:Most items match; CostCentre, CurrencyCode, and AccountGroup are target gaps.
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:Account
C2:AccountKey
D2:Int64
E2:Stable account identifier.
F2:Yes
G2:Account.AccountKey
I2:Existing Power BI semantic model
A3:column
B3:Account
C3:AccountName
D3:String
E3:Finance account display name.
F3:Yes
G3:Account.AccountName
I3:Existing Power BI semantic model
A4:column
B4:Account
C4:AccountType
D4:String
E4:Revenue or expense classification.
F4:Yes
G4:Account.AccountType
I4:Existing Power BI semantic model
A5:column
B5:Calendar
C5:DateKey
D5:Int64
E5:Integer date key in YYYYMMDD form.
F5:Yes
G5:Calendar.DateKey
I5:Existing Power BI semantic model
A6:column
B6:Calendar
C6:Date
D6:DateTime
E6:Posting calendar date.
F6:Yes
G6:Calendar.Date
I6:Existing Power BI semantic model
A7:column
B7:Calendar
C7:FiscalMonth
D7:Int64
E7:Fiscal month number.
F7:Yes
G7:Calendar.FiscalMonth
I7:Existing Power BI semantic model
A8:column
B8:Ledger
C8:DateKey
D8:Int64
E8:Posting date foreign key.
F8:Yes
G8:Ledger.DateKey
I8:Existing Power BI semantic model
A9:column
B9:Ledger
C9:AccountKey
D9:Int64
E9:Account foreign key.
F9:Yes
G9:Ledger.AccountKey
I9:Existing Power BI semantic model
A10:column
B10:Ledger
C10:SignedAmount
D10:Decimal
E10:Signed ledger amount in reporting currency.
F10:Yes
G10:Ledger.SignedAmount
I10:Existing Power BI semantic model
A11:column
B11:Ledger
C11:IsAdjustment
D11:Boolean
E11:Identifies late or manual adjustments.
F11:Yes
G11:Ledger.IsAdjustment
I11:Existing Power BI semantic model
A12:column
B12:Ledger
C12:CostCentre
D12:String
E12:Management cost-centre code.
F12:Yes
G12:Ledger.CostCentre
I12:Finance posting source / embedded reference data
J12:Not expected in current test model.
A13:column
B13:Ledger
C13:CurrencyCode
D13:String
E13:ISO reporting currency code.
F13:Yes
G13:Ledger.CurrencyCode
I13:Finance posting source
J13:Not expected in current test model.
A14:column
B14:Account
C14:AccountGroup
D14:String
E14:Management reporting group above account type.
F14:Yes
G14:Account.AccountGroup
I14:Account master / embedded mapping
J14:Target enrichment requirement.
::sheet_structure
state:visible
used-range:A1:J14
freeze-panes:A2
auto-filter:A1:J14
::tables_names
table:TargetFields;range=A1:J14;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: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