By 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)
| Column | Header | Width | Format |
|---|---|---|---|
| A | 번호 | 8 | center |
| B | 품명 | 25 | left |
| C | 규격 | 20 | left |
| D | 단위 | 8 | center |
| E | 수량 | 10 | #,##0 |
| F | 단가 | 15 | #,##0원 |
| G | 금액 | 15 | #,##0원 |
| H | 비고 | 15 | left |
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_imagetool with the image file path - Supported: PNG, JPEG, BMP, GIF from local folder or Dropbox sync