Does it support financial modeling standards?

Absolutely. It follows industry-standard color coding (blue for inputs, black for formulas) and specific number formatting for currencies, multiples, and percentages.

Does it preserve the formatting of my existing templates?

Yes, it is designed to study and match existing styles, ensuring that updates to your corporate templates remain consistent with your established conventions.

Can I use it to analyze data from existing spreadsheets?

Yes, the skill utilizes the pandas library to read, filter, and perform statistical analysis on data from .xlsx, .csv, and .tsv files.

Can this skill handle complex Excel formulas?

Yes, it prioritizes dynamic Excel formulas over hardcoded values and uses a specialized script to recalculate and verify them for errors like #REF! or #DIV/0!.

Excel & Spreadsheet Management

Name: Excel & Spreadsheet Management
Author: heyflouai

byheyflouai

0•

데이터 과학 및 ML

Automates the creation, editing, and analysis of professional Excel spreadsheets with advanced formula support and financial modeling standards.

This skill empowers Claude to handle complex spreadsheet tasks, ranging from simple data entry to sophisticated financial modeling. It provides a robust framework for creating dynamic workbooks using real Excel formulas rather than hardcoded values, ensuring data integrity through automated recalculation via LibreOffice. Users can leverage industry-standard formatting for financial models, perform deep data analysis using pandas, and modify existing templates while strictly preserving original styles and conventions.

주요 기능

01Automated formula recalculation and error detection using LibreOffice integration

02Industry-standard financial modeling with specific color-coding and formatting rules

030 GitHub stars

04Comprehensive data analysis and visualization using pandas and openpyxl

05Dynamic formula injection to replace hardcoded values for updateable workbooks

06Strict preservation of existing spreadsheet templates and custom formatting styles

사용 사례

01Building automated financial models with growth projections and valuation multiples

02Cleaning and analyzing large datasets from CSV/TSV files for business intelligence

03Updating existing corporate spreadsheet templates while maintaining formatting consistency

What are Skills?·How to Install

Install with 🐟 Skill.Fish

npx skillfish add heyflouai/ikf-central-dashboard xlsx

For use in Claude.ai and ChatGPT

Download Skill