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

Workbook evidence

TargetArchitecture_Match.xlsx

55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95

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
6195

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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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:unspecified
property.title:FDE Finance Target — Current-State Match
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

159 items extracted and included.

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

[Sheet:Instructions]
A1:FDE Finance Target — Current-State Match
A3:Scenario
B3:Every declared target item has a deterministic current-model match.
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:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:Metrics.Actual Net
H12:[Actual Revenue] - expenses
I12:Existing Power BI semantic model
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:Metrics.Actual Revenue
I13:Existing Power BI semantic model
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:Metrics.Budget Net
I14:Existing Power BI semantic model
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:Metrics.Net Variance
H15:[Actual Net] - [Budget Net]
I15:Existing Power BI semantic model

[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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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:J15
freeze-panes:A2
auto-filter:A1:J15

[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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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:J15;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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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 — Current-State MatchFDE Finance Target — Current-State MatchGeneral
A3ScenarioScenarioGeneral
B3Every declared target item has a deterministic current-model match.Every declared target item has a deterministic current-model match.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 — Current-State Match
A3:Scenario
B3:Every declared target item has a deterministic current-model match.
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

15 × 10 · 0 formulas · visible

Inspect retained cell ledger+
TargetFields A1:J15
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
A12measuremeasureGeneral
B12MetricsMetricsGeneral
C12Actual NetActual NetGeneral
D12DecimalDecimalGeneral
E12Net actual result.Net actual result.General
F12YesYesGeneral
G12Metrics.Actual NetMetrics.Actual NetGeneral
H12[Actual Revenue] - expenses[Actual Revenue] - expensesGeneral
I12Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A13measuremeasureGeneral
B13MetricsMetricsGeneral
C13Actual RevenueActual RevenueGeneral
D13DecimalDecimalGeneral
E13Total actual revenue.Total actual revenue.General
F13YesYesGeneral
G13Metrics.Actual RevenueMetrics.Actual RevenueGeneral
I13Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A14measuremeasureGeneral
B14MetricsMetricsGeneral
C14Budget NetBudget NetGeneral
D14DecimalDecimalGeneral
E14Budget net result.Budget net result.General
F14YesYesGeneral
G14Metrics.Budget NetMetrics.Budget NetGeneral
I14Existing Power BI semantic modelExisting Power BI semantic modelGeneral
A15measuremeasureGeneral
B15MetricsMetricsGeneral
C15Net VarianceNet VarianceGeneral
D15DecimalDecimalGeneral
E15Actual net less budget net.Actual net less budget net.General
F15YesYesGeneral
G15Metrics.Net VarianceMetrics.Net VarianceGeneral
H15[Actual Net] - [Budget Net][Actual Net] - [Budget Net]General
I15Existing Power BI semantic modelExisting Power BI semantic modelGeneral

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:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:Metrics.Actual Net
H12:[Actual Revenue] - expenses
I12:Existing Power BI semantic model
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:Metrics.Actual Revenue
I13:Existing Power BI semantic model
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:Metrics.Budget Net
I14:Existing Power BI semantic model
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:Metrics.Net Variance
H15:[Actual Net] - [Budget Net]
I15:Existing Power BI semantic model
::sheet_structure
state:visible
used-range:A1:J15
freeze-panes:A2
auto-filter:A1:J15
::tables_names
table:TargetFields;range=A1:J15;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_55d53340ad188bf8b20b867f577f5654ae91f3a8210e267e6d2dade7f4668a95
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 — Current-State Match
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=159; omitted=0]
sheet-items:159
::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 — Current-State Match
A3:Scenario
B3:Every declared target item has a deterministic current-model match.
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:measure
B12:Metrics
C12:Actual Net
D12:Decimal
E12:Net actual result.
F12:Yes
G12:Metrics.Actual Net
H12:[Actual Revenue] - expenses
I12:Existing Power BI semantic model
A13:measure
B13:Metrics
C13:Actual Revenue
D13:Decimal
E13:Total actual revenue.
F13:Yes
G13:Metrics.Actual Revenue
I13:Existing Power BI semantic model
A14:measure
B14:Metrics
C14:Budget Net
D14:Decimal
E14:Budget net result.
F14:Yes
G14:Metrics.Budget Net
I14:Existing Power BI semantic model
A15:measure
B15:Metrics
C15:Net Variance
D15:Decimal
E15:Actual net less budget net.
F15:Yes
G15:Metrics.Net Variance
H15:[Actual Net] - [Budget Net]
I15:Existing Power BI semantic model
::sheet_structure
state:visible
used-range:A1:J15
freeze-panes:A2
auto-filter:A1:J15
::tables_names
table:TargetFields;range=A1:J15;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