Estimate Creation

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