Exact model input
Everything the model was given
Literal labels, structure, formulas and supported metadata. Ordinary numeric, date and Boolean values are excluded, and opaque binary payloads are never placed in the prompt.
Complete packet
XLSX.evidence v2
artifact:ev_sha256_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
Instructions
[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
[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
[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
[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
[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