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_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
Instructions
[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
[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
[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