AlterLab XLSX
Skill ActivePart of the AlterLab Academic Skills suite. Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
To provide a specialized tool for any task involving spreadsheet files as primary input or output, ensuring dynamic and error-free Excel deliverables.
Features
- Edit, read, and fix existing spreadsheet files (.xlsx, .xlsm, .csv, .tsv)
- Add columns, compute formulas, format, chart, and clean messy data
- Create new spreadsheets from scratch or other data sources
- Convert between tabular file formats
- Recalculate formulas and verify error-free deliverables
- Clean and restructure messy tabular data files
Use Cases
- Use when needing to add columns or compute formulas in an existing .xlsx file.
- Use when requiring data cleaning or formatting for .csv or .tsv files.
- Use when creating new spreadsheets from scratch or converting data between formats.
- Use when needing to fix formula errors in an Excel model.
Non-Goals
- Do NOT trigger when the primary deliverable is a Word document.
- Do NOT trigger when the primary deliverable is an HTML report.
- Do NOT trigger when the primary deliverable is a standalone Python script.
- Do NOT trigger when the primary deliverable is a database pipeline.
- Do NOT trigger when the primary deliverable is a Google Sheets API integration.
Workflow
- Load or create the Excel file using pandas or openpyxl.
- Modify data, formulas, and formatting as required.
- Save the modified Excel file.
- Recalculate all formulas using the `scripts/recalc.py` script.
- Verify and fix any identified formula errors before finalizing.
Execution
- warning:Pinned dependenciesThe skill relies on external libraries like pandas and openpyxl, but there is no explicit mention of pinned dependencies or lockfiles in the documentation, which could lead to compatibility issues.
- warning:Pinned dependenciesThe skill relies on Python libraries (pandas, openpyxl) and LibreOffice, but there is no mention of pinned versions or lockfiles, potentially leading to compatibility issues with future updates.
Trust
- info:Issues AttentionThe repository has 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity, but the total count is small.
- info:Issues AttentionThere are 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity, but the overall issue count is small.
- info:Issues AttentionThere are 2 open issues and 0 closed issues in the last 90 days, indicating low recent activity but a small total count.
Maintenance
- warning:Dependency ManagementWhile the skill uses standard Python libraries and LibreOffice, there's no explicit mention of dependency pinning or lockfiles, which could lead to version conflicts.
Installation
npx skills add AlterLab-IEU/AlterLab-Academic-SkillsRuns the Vercel skills CLI (skills.sh) via npx — needs Node.js locally and at least one installed skills-compatible agent (Claude Code, Cursor, Codex, …). Assumes the repo follows the agentskills.io format.
Quality Score
Trust Signals
Similar Extensions
XLSX Skill
96Use this skill any time a spreadsheet file is the primary input or output. This means any task where the user wants to: open, read, edit, or fix an existing .xlsx, .xlsm, .csv, or .tsv file (e.g., adding columns, computing formulas, formatting, charting, cleaning messy data); create a new spreadsheet from scratch or from other data sources; or convert between tabular file formats. Trigger especially when the user references a spreadsheet file by name or path — even casually (like "the xlsx in my downloads") — and wants something done to it or produced from it. Also trigger for cleaning or restructuring messy tabular data files (malformed rows, misplaced headers, junk data) into proper spreadsheets. The deliverable must be a spreadsheet file. Do NOT trigger when the primary deliverable is a Word document, HTML report, standalone Python script, database pipeline, or Google Sheets API integration, even if tabular data is involved.
Lark Cli sheets
92飞书电子表格:创建和操作电子表格。支持创建表格、创建/复制/删除/更新工作表、读写单元格、追加行数据、查找内容、导出文件。当用户需要创建电子表格、管理工作表、批量读写数据、在已知表格中查找内容、导出或下载表格时使用。若用户是想按名称或关键词搜索云空间里的表格文件,请改用 lark-doc 的 docs +search 先定位资源。
Xlsx Processing Openai
85Toolkit for comprehensive Spreadsheet reading, creation, editing, and analysis with visual quality control. Use to work with spreadsheets (.xlsx, .xlsm, .csv, .tsv) for: (1) Creating new spreadsheets with formulas and formatting, (2) Reading or analyzing tabular data, (3) Modifying existing spreadsheets while preserving formulas, (4) Building financial models with proper formatting, (5) Data visualization with in-sheet charts, or any other spreadsheet tasks.
Embedding Strategies
100Select and optimize embedding models for semantic search and RAG applications. Use when choosing embedding models, implementing chunking strategies, or optimizing embedding quality for specific domains.
Aws Cdk Development
100AWS Cloud Development Kit (CDK) expert for building cloud infrastructure with TypeScript/Python. Use when creating CDK stacks, defining CDK constructs, implementing infrastructure as code, or when the user mentions CDK, CloudFormation, IaC, cdk synth, cdk deploy, or wants to define AWS infrastructure programmatically. Covers CDK app structure, construct patterns, stack composition, and deployment workflows.
Fit Drift Diffusion Model
100Fit cognitive drift-diffusion models (Ratcliff DDM) to reaction time and accuracy data with parameter estimation (drift rate, boundary separation, non-decision time), model comparison, and parameter recovery validation. Use when modeling binary decision-making with reaction time data, estimating cognitive parameters from experimental data, comparing sequential sampling model variants, or decomposing speed-accuracy tradeoff effects into latent cognitive components.