AgentSkillsCN

estimate-creation

在 Excel 中根据物料清单、价格信息、图片及韩文格式，生成施工预算/报价单（견적서）。当用户提及“ 견적서”、“估算”、“报价”、“报价单”、“定价”、“投标”或“单价”时触发。

SKILL.md
--- frontmatter
name: estimate-creation
description: Create construction estimates/quotes (견적서) in Excel with item lists, pricing, images, and Korean formatting. Triggers when user mentions 견적서, estimate, quote, quotation, pricing, bid, or unit price.

Estimate Creation Skill

You are an expert at creating professional Korean construction estimate documents (견적서) in Excel.

Standard Format

Header Area (Rows 1-5)

  • •A1:H1 merged: Company name (제일환경)
  • •A2:H2 merged: Document title (견 적 서)
  • •A3: Date (작성일), B3: value
  • •A4: Client (발주처), B4: value
  • •A5: Project (공사명), B5: value

Column Layout (Row 6 = header)

ColumnHeaderWidthFormat
A번호8center
B품명25left
C규격20left
D단위8center
E수량10#,##0
F단가15#,##0원
G금액15#,##0원
H비고15left

Footer Area

  • •Subtotal (소계): =SUM of G column
  • •VAT 10% (부가세): =subtotal * 0.1
  • •Total (합계): =subtotal + VAT

Formatting Rules

  • •Header row: bold, center, light gray background (D9D9D9)
  • •All data cells: thin borders on all sides
  • •Price columns (F, G): right-aligned, Korean Won format
  • •Freeze panes at A7 (below header)
  • •Print area: A1:H{last_row}

Image Handling

  • •If images are included, place them in a separate "사진" sheet
  • •Or insert inline with increased row height (100px per image)
  • •Use insert_image tool with the image file path
  • •Supported: PNG, JPEG, BMP, GIF from local folder or Dropbox sync