skills.rest
ha-giwan1203
ha-giwan1203COMMUNITY
Explore all skills by this author →
GitHub

chomul-module-partno

Automate batch RSP module number updates in BOM Excel workbooks.

Updated Jul 23, 2025
Search Tags:#automation#validation#excel#bom#win32com#rsp#module-number
One-click install
npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill chomul-module-partno
Or copy as Structured Prompt for Agent▼
Please help me install this Agent Skill.
Skill: chomul-module-partno
Source: https://github.com/ha-giwan1203/GIWANOS_AgentOS/tree/main/90_%EA%B3%B5%ED%86%B5%EA%B8%B0%EC%A4%80/%EC%8A%A4%ED%82%AC/chomul-module-partno
Command: npx skills add https://github.com/ha-giwan1203/GIWANOS_AgentOS --skill chomul-module-partno

SYSTEM DOCUMENTATION & REQUIREMENTS

What problem does it solve?

Automates batch updating of module numbers (RSP) in BOM Excel workbooks, reducing manual edits and errors across multiple sheets.

Core Features & Use Cases

  • Batch updates AB5:AJ14 and related ranges with latest module numbers.
  • Change line code SP3S03 to SP3M3 and harmonize view/borders across sheets.
  • Enforce color and border standards and perform validation post-edit.

Quick Start

Use the chomul-module-partno skill to automatically propagate the latest SP3M3 module numbers across all BOM sheets and standardize views and borders.

Frequently Asked Questions about chomul-module-partno

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

FAQPage Schema
How do I batch update module numbers in BOM Excel workbooks?▼

Batch updating module numbers in BOM Excel workbooks is automated by propagating the latest RSP mappings across multiple sheets, normalizing codes, and updating target AB5:AJ14 ranges.

How do I change SP3S03 line codes to SP3M3 in BOM sheets?▼

Changing SP3S03 line codes to SP3M3 in BOM sheets is handled automatically by mapping primary SKUs to RSP, normalizing codes, and harmonizing views and borders across worksheets.

Can I automate Excel border and color standardization across multiple sheets?▼

Automating Excel border and color standardization across multiple sheets is supported by enforcing border rules and applying mid-code color highlights during the RSP module number update process.

Do I need Windows and Excel to automate BOM module number updates?▼

Windows and Excel are required for automating BOM module number updates because the process relies on win32com to manipulate workbooks, apply mappings, and enforce formatting rules.

What is the best way to validate BOM Excel updates after batch editing?▼

Validating BOM Excel updates after batch editing is built into the workflow, performing a post-edit validation check to ensure line code changes, border unification, and color highlights are applied correctly.

Related Skills

Explore More Software Engineering Skills→
Awannaphasch2016Awannaphasch2016

mcp-integration

Register MCP servers via .mcp.json and escalate configuration through CLAUDE.md and hooks.

Community
Advanced
ha-giwan1203ha-giwan1203

zdm-daily-inspection

Automate daily ZDM inspection data entry for the SP3M3 line via API.

Community
Advanced
OpenSenseNovaOpenSenseNova
4.9k

excel-conditional-comparison-and-large-file-processing

Compare Excel cell values across sheets and generate color-coded reports.

Official
Intermediate
XJTLUmediaXJTLUmedia
28

docx

Create, edit, and analyze Word .docx documents via JavaScript and Python interfaces.

Community
Advanced