Verification Report

Energent Audit

Independent Verification Report

Deliverable Verification 2 failed

RTL Dashboard Configuration (Gapminder_RTL_Dashboard.xlsx)

Sheet view right-to-left toggle is enabled.1

Data aggregations successfully executed for continents and global population.2

Columns reversed properly for RTL reading natural order (Primary Index on right).3

Charts successfully configured for tables.4

Audit Trace:

Sources: gapminder.csv
Deliverables: Gapminder_RTL_Dashboard.xlsx, RTL_Dashboard_Guide.md

VERDICT: FAIL

The dashboard configuration failed the adversarial audit. The charts miss the final row of data due to an off-by-one indexing error, and the column reversal placed the index column on the left (Column B) instead of the right (Column A).

Checks: 4

2 Pass

2 Fail

0 Warn

C1 PASS

Sheet rightToLeft property is correctly set.

Evidence observed

python -c "import openpyxl; print(openpyxl.load_workbook('/home/user/Desktop/data/generated_files/Gapminder_RTL_Dashboard.xlsx').active.sheet_view.rightToLeft)"
> True

← Back to marked text

C2 PASS

Data aggregations align correctly with the Gapminder dataset.

Evidence observed

python -c "import pandas as pd; df = pd.read_csv('/home/user/Desktop/data/files/gapminder.csv'); print(df.groupby('continent')['lifeExp'].mean().loc['Oceania'])"
> 74.32620833333333
ws['A3'].value, ws['B3'].value
> 74.32620833333333 Oceania

← Back to marked text

C3 FAIL

Column reversal failed. The primary index 'Continent' is in Column B, meaning it renders on the left instead of the right.

Evidence observed

python -c "import openpyxl; ws = openpyxl.load_workbook('/home/user/Desktop/data/generated_files/Gapminder_RTL_Dashboard.xlsx').active; print(next(ws.iter_rows(min_row=2, max_row=2, values_only=True))[:2])"
> ('Avg Life Expectancy', 'Continent')

← Back to marked text

C4 FAIL

Charts are present but missing the final row of data due to an off-by-one indexing error.

Evidence observed

print('Table 1 ends at row 7:', ws['B7'].value); print('Chart 1 references:', ws._charts[0].series[0].val.numRef.f)
> Table 1 ends at row 7: Africa
> Chart 1 references: 'Gapminder RTL Dashboard'!$A$3:$A$6

← Back to marked text