Run2 excel verification
[COLM'26] SkillLearnBench is the first benchmark for evaluating continual learning methods that automatically generate agent skills.
npx -y skills add cxcscmu/SkillLearnBench --skill run2_excel-verificationAssembled from the repository path, not quoted from the project. Check it against their README if it does not work.
What its author says it does
Copied from the file, not written here
Verifying Excel formula results and handling errors using recalc.py and openpyxl.
SKILL.md
1.1 KB, as published. Nobody here has run it
Verifying Excel Formulas and Results
Always verify the output of Excel modifications to ensure formula correctness and data accuracy.
Error Checking with recalc.py
After saving the workbook, run recalc.py to identify formula errors (e.g., #NAME?, #REF!, #DIV/0!).
#NAME?: Check for incorrect function names (e.g., usePERCENTILEinstead ofPERCENTILE.INC).#REF!: Check for invalid cell references.#DIV/0!: Check for empty or zero denominators in division.
Value Verification with openpyxl (data_only=True)
To check the actual values calculated by Excel, reload the workbook with data_only=True:
from openpyxl import load_workbook
wb = load_workbook('file.xlsx', data_only=True)
sheet = wb['Task']
print(f"Cell H35 Value: {sheet['H35'].value}")
Manual Verification Formula
Perform a manual calculation to check a sample of cells:
- UAE 2019:
(Exports - Imports) / GDP * 100 - Bahrain 2019:
(Exports - Imports) / GDP * 100 - Confirm these match the values in the sheet.