Run2 excel verification
Verifying Excel formula results and handling errors using recalc.py and openpyxl.From its SKILL.md
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.
SKILL.md
1.1 KB, 271 tokens by cl100k_base, 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.
What ships with it
Read from the repository
Just SKILL.md. No reference files, no scripts.