byted-sol-excel-bill-discount

byted-sol-excel-bill-discount is a skill for Claude Code, Codex from bytedance/agentkit-samples. It costs 62 tokens per session (1,075 once invoked), scanned A, original, Apache-2.0.

An Excel billing tool that creates a discount overview pivot table from a billing workbook while preserving the original sheets and formatting. A pivot table groups and summarises rows, such as by product or billing period.

In plain words
What is it for?
It is for turning detailed cloud-billing Excel files into formatted monthly discount summaries with checked totals.
Why use it?
It automates date formatting, totals, validation, and spreadsheet styling while avoiding Excel repair warnings.

Skill for Claude CodeCodex ✓ vendor

Which agent this was written for is unclear — built for openclaw. Also seen: built for openclaw.

Good fit It is for turning detailed cloud-billing Excel files into formatted monthly discount summaries with checked totals.

Compare 6 skills from other repositories ↓
Install with agentmods
npx agentmods add skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount
About the project

bytedance/agentkit-samples is a collection of examples and tutorials for Volcengine AgentKit, an AI-agent development platform for building, deploying, and operating agent applications. Developers use the samples to learn agent creation, multi-agent collaboration, memory, retrieval, MCP integrations, media generation, customer service, and other workflows. The catalogue skills provide agent workflows based on these examples.

bytedance/agentkit-samples · 450 stars · on GitHub

Install

Getting it into your agent

One page per mod, every tool's command on it. A separate URL per tool would split the same page into five that compete with each other.

Any agent
npx skills add bytedance/agentkit-samples --skill byted-sol-excel-bill-discount
Clone the repo
git clone --depth 1 https://github.com/bytedance/agentkit-samples

Made for: Claude Code, Codex.

Wrote this? Show the measurements

A badge with what this costs and how it scanned, read live from this page, so it follows the numbers instead of freezing them. Markdown for a README, HTML for a documentation site or a project page.

agentmods badge for byted-sol-excel-bill-discount

README.md
[![agentmods](https://agentmods.dev/badge/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount/github.svg)](https://agentmods.dev/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount)
Your own site
<a href="https://agentmods.dev/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount"><img src="https://agentmods.dev/badge/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount/github.svg" alt="Measured on agentmods" height="20"></a>

Or the 80×15 button, for a site that already has a row of RSS and ATOM ones. Only the verdict fits; the numbers stay here.

agentmods 80×15 button for byted-sol-excel-bill-discount

Your own site · 80×15
<a href="https://agentmods.dev/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount"><img src="https://agentmods.dev/badge/skills/bytedance/agentkit-samples/byted-sol-excel-bill-discount.svg" alt="Reviewed on agentmods" width="80" height="20"></a>
Per session 62 Skills are progressive disclosure: only the name and description are preloaded; the body loads when the skill is used.
When invoked 1,075 The whole file, excluding the scripts and references it only reads on demand.
Security scan A 0 findings. A grade says what 26 rules found in the file — not that it is safe. Third-party audits
  • NVIDIA SkillSpector pass 7 Sept 2026
How audits are shown
Origin original No closer match found in the catalogue.
Token cost

What it costs to keep this loaded

Counted locally with the o200k_base tokenizer, which is exact for GPT models; Claude uses its own tokenizer and its counts differ. Treat this as one consistent yardstick across the catalogue rather than a bill. Prices are per million input tokens.

ModelPer sessionOnce invoked
Fable 5.1 $0.00062 $0.01075
Opus 5 $0.00031 $0.00537
Sonnet 5 $0.00012 $0.00215
Haiku 4.5 $0.00006 $0.00108

Measured 7d ago against content hash 24aeceae9a9a, method: parsed. Prices are Anthropic first-party input rates as of 2026-09-10, from the pricing page.

Security

Grade A, and why

byted-sol-excel-bill-discount scanned grade A with 0 findings against 26 rules in 11 categories — prompt injection, anti-refusal, data exfiltration, privilege escalation, supply chain, agent snooping, system-prompt leakage, SSRF and excessive agency — measured 7d ago.

The scan reads SKILL.md. This mod also ships 1 executable file (process_bill.py), listed below but not scanned — reading those needs a real analyzer, not pattern matching.

A static scan of the body, not an audit. Every finding is printed with the line that produced it so you can judge whether it matters here. A mod is markdown that instructs an agent; that is exactly why what it instructs is worth reading.

Nothing flagged

None of the 26 patterns this scan looks for appear in this file: no shell pipes, no recursive deletes, no credential paths, no hidden text, no instruction-override or anti-refusal phrasing, no agent-config snooping. That is not a guarantee, it is the absence of the things that are checkable.

skills/byted-sol-excel-bill-discount/SKILL.md · 72 lines

What it actually says

Excel账单处理工具

功能说明

自动处理上传的账单Excel明细表,生成符合格式要求的"账单折扣总览"透视表,严格遵循指定的格式、数据保留、验证规则,生成的文件无Excel修复弹窗,兼容Excel 2016+。

使用方法

当用户上传账单Excel文件并要求处理时,直接调用本技能的处理脚本,传入输入文件路径即可:

python ~/.openclaw/skills/byted-sol-excel-bill-discount/process_bill.py <输入文件路径>

处理规则(严格遵循)

1. 工作表要求

  • 新建"账单折扣总览"透视表,放在最左侧位置
  • 完全保留原工作表所有内容和格式
  • 原工作表日期字段格式化:
  • 账务账期、业务账期 → YYYY-MM格式
  • 账务日期 → YYYY/MM/DD格式
  • 消费开始时间(UTC+8)、消费结束时间(UTC+8)、交易时间(UTC+8) → YYYY/MM/DD hh:mm:ss格式
  • 原工作表字体:等线11号,缩放90%

2. 透视表字段要求

从以下字段列表中筛选原表实际存在的字段,按原顺序排列,原表中缺失的字段无需在透视表中展示: 账务账期、Payer账号ID、Payer ID、Owner账号ID、账号 ID、产品、商品、计费模式、账单类型、配置名称、计费单元、单价、单价单位、优惠类型、优惠内容、用量、原价、折后价、代金券抵扣、应付金额

  • 用量、原价、折后价、代金券抵扣、应付金额中在原表存在的字段进行聚合求和
  • 所有配置名称、计费单元数据必须完整保留,不得缺失

3. 格式要求

  • 全部单元格:微软雅黑10号字体,缩放90%,所有单元格加边框
  • 首行(表头):填充#BDD7EE,加粗居中
  • 尾行(合计行):填充#D9D9D9,加粗居中
  • 金额字段(原价、折后价、代金券抵扣、应付金额):2位小数,千位分隔符,居右对齐
  • 用量字段:无千位分隔符,保留数值自然长度,无固定小数位数
  • 居中列:账务账期、计费模式、账单类型、单价、单价单位、优惠类型、优惠内容
  • 列宽自动适配:每列宽度 = (最长单元格字符宽度,中文计2单位/英文数字计1单位) × 1.1
  • 账务账期格式:YYYY-MM

4. 输出文件名规则

从"账务账期"字段解析生成:A年B月产品折扣账单.xlsx

  • 例:Feb-26 → A=26,B=2
  • 例:2026-02-01 → A=26,B=2

5. 文件规范要求

必须使用xlsxwriter生成文件,确保:

  • 打开无任何修复提示弹窗
  • 符合Office Open XML规范,无XML结构错误
  • 兼容Microsoft Excel 2016+

6. 数据处理原则

  • 保留所有原始数据,不删除任何行、不过滤任何内容
  • 禁止自动清洗数据,禁止判定脏数据,禁止删除特殊格式名称
  • 分组聚合时强制使用dropna=False,不忽略任何数据

7. 验证规则

生成前必须验证:

  • 透视表原价总额 = 原表原价总额
  • 透视表折后价总额 = 原表折后价总额
  • 透视表应付金额总额 = 原表应付金额总额
  • 验证不通过则提示"总额不一致,无法生成"
Files

What ships with it

1 file beside SKILL.md in the same directory: the scripts, references and assets a skill reads on demand. Not counted in the per-session cost; read them before you install if any of them is executable.

Changes

What this file has done since we first saw it

Hashed on every crawl. A supply-chain change to an agent config is a question of when, not whether, so the history is kept rather than the latest state alone.

  1. 7d ago First seen · 72 lines · 62 tokens per session scan A 24aeceae9a9a

Subscribe to this mod's changes

byted-sol-excel-bill-discount is a skill published in the GitHub repository bytedance/agentkit-samples (450 stars, last pushed 6d ago), licensed Apache-2.0. It adds 62 tokens to every session and 1,075 once invoked, about $0.0003 per session on Opus 5. A static security scan graded it A with 0 findings. No closer match exists in the catalogue, so it is treated as the original; first seen 2026-09-03.

Related

Other skills, from other repositories

data-analysis

Use this skill when the user uploads Excel (.xlsx/.xls) or CSV files and wants to perform data analysis, generate statistics, create summaries, pivot tables, SQL queries, or any form of structured data exploration. Supports multi-sheet Excel workbooks, aggregation, filtering, joins, and exporting results to…

bytedance/deer-flow · 69 tokens

officecli-financial-model

Use this skill when the user wants to build a financial model — 3-statement model, DCF valuation, LBO, SaaS unit economics, sensitivity / scenario analysis, debt schedule, or fundraising projections — in Excel. Trigger on: 'financial model', '3-statement model', 'P&L + BS + CF', 'DCF', 'WACC', 'NPV', 'terminal value'…

iOfficeAI/OfficeCLI · 222 tokens

officecli-xlsx

Use this skill any time a .xlsx file is involved -- as input, output, or both. This includes: creating spreadsheets, financial models, dashboards, or trackers; reading, parsing, or extracting data from any .xlsx file; editing, modifying, or updating existing workbooks; working with formulas, charts, pivot tables, or…

iOfficeAI/OfficeCLI · 119 tokens

xlsx

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…

agentscope-ai/QwenPaw · 201 tokens

xlsx

A guide for working with spreadsheet files such as Excel workbooks, CSV files, and TSV files.

agentscope-ai/QwenPaw · 232 tokens

officecli

Create, analyze, proofread, and modify Office documents (.docx, .xlsx, .pptx) using the officecli CLI tool. Use when the user wants to create, inspect, check formatting, find issues, add charts, or modify Office documents.

iOfficeAI/OfficeCLI · 56 tokens