Data Reconciliation for Spreadsheets
OfficialRecover missing data in financial and tabular data using mathematical constraints.
Finance & Accounting#spreadsheet#financial analysis#budgeting#data reconciliation#mathematical constraints
Authoragentscope-ai
Version1.0.0
Installs0
System Documentation
What problem does it solve?
This Skill addresses the challenge of identifying and recovering missing values in financial and tabular data, using mathematical constraints to ensure accuracy.
Core Features & Use Cases
- Row/Column Sum Constraints: Automatically calculate missing values when totals are provided.
- Year-over-Year (YoY) Change Recovery: Recovers previous values from current values based on percentage changes.
- Percentage Share Recovery: Calculates individual values based on their share of a total.
- Compound Annual Growth Rate (CAGR): Analyzes multi-year growth and calculates start or end values.
- Cross-Validation: Ensures recovered values meet all constraints.
- Use Case: Ideal for financial analysts who need to fill in gaps in budget sheets or financial reports.
Quick Start
Run the 'data-reconciliation' skill on your spreadsheet to recover missing values based on provided constraints.
Dependency Matrix
Required Modules
None requiredComponents
scriptsreferencesassets
💻 Claude Code Installation
Recommended: Let Claude install automatically. Simply copy and paste the text below to Claude Code.
Please help me install this Skill: Name: Data Reconciliation for Spreadsheets Download link: https://github.com/agentscope-ai/PawBench/archive/main.zip#data-reconciliation-for-spreadsheets Please download this .zip file, extract it, and install it in the .claude/skills/ directory.
Agent Skills Search Helper
Install a tiny helper to your Agent, search and equip skill from 620,000+ vetted skills library on demand.