gaspatchio-workbook-conversion

Converts Excel workbooks into gaspatchio actuarial models with executable reconciliation proofs.

4|Updated Jul 4, 2026
One-click install
npx skills add https://github.com/gaspatchio/gaspatchio --skill gaspatchio-workbook-conversion-gaspatchio
Or copy as Structured Prompt for Agent
Please help me install this Agent Skill.
Skill: gaspatchio-workbook-conversion
Source: https://github.com/gaspatchio/gaspatchio/tree/main/skills/gaspatchio-workbook-conversion
Command: npx skills add https://github.com/gaspatchio/gaspatchio --skill gaspatchio-workbook-conversion-gaspatchio

SYSTEM DOCUMENTATION & REQUIREMENTS

💡 This Skill requires xl-marinade, fastexcel, formulas, pycel.

What problem does it solve? Converting an Excel workbook into a gaspatchio model produces claims — the values were read losslessly, the formulas were translated correctly, the recursion reproduces the source — and without structure those claims are unverifiable. This Skill enforces a three-proof discipline so every conversion claim carries its own executable proof and any numeric discrepancy localises to exactly one stage. ## Core Features & Use Cases - Reader trust-boundary validation: Verifies fastexcel/calamine output against raw sheet XML <v> values, catching silent float truncation caused by String dtype inference. - Three-proof reconciliation structure: Separates reader verification, formula re-evaluation from cached precedents, and full-grid model reconciliation so residuals have exactly one cause. - Faithful-quirk reproduction: Reproduces VLOOKUP clamping, notional post-lapse charges, and rounding placement exactly as the source workbook behaves, flagging each quirk for the owner. - Use Case: An actuary must migrate a universal life pricing workbook to gaspatchio for regulatory audit. The Skill guides extraction via xl-marinade, reads assumptions through defined names, and delivers a model plus three self-reporting proof scripts and a reconciliation report. ## Quick Start Convert the attached UL pricing workbook into a gaspatchio model with full reader, formula, and full-grid reconciliation proofs.

Frequently Asked Questions about gaspatchio-workbook-conversion

High-intent search queries and answers about installing and using this skill.

FAQPage Schema
How do I convert an Excel workbook to a gaspatchio model?

Extract the workbook structure with xl-marinade, read assumptions through defined names rather than cell coordinates, then build three proofs: validate the reader against raw sheet XML, re-evaluate formulas from cached precedents, and reconcile the full output grid column by column.

Why does fastexcel read wrong values from my Excel file?

fastexcel/calamine silently truncates floats to about 9 significant figures when a column's dtype infers as String, which a text header row above the data block can trigger. Skip text headers, assert Float64 dtypes after load, and validate against the raw sheet XML values.

How do I verify an Excel-to-model conversion is correct?

Use three separate proofs: verify the reader against raw XML probe cells, re-evaluate each formula pattern from the workbook's own cached inputs, then machine-diff every output column over every period. A closing-balance check alone misses intermediate column errors.

Should I fix Excel quirks like VLOOKUP clamping during conversion?

No. Reproduce the quirk faithfully and flag it for the owner in the reconciliation report. A silent fix diverges the first time the quirk matters, while a silent quirk becomes an untraceable bug later.

What tools are needed for workbook structure extraction?

The extraction stack is xl-marinade, installed via uv tool install 'xl-marinade[llm,vba]>=0.3.0' and run with marinade extract. For branches without cached references, recalculate the workbook with formulas or pycel after validating that engine against cached values.