xlsx

Excel File Creation: Python + openpyxl/pandas

✅ REQUIRED Technology Stack for Excel Creation:

• Runtime: Python 3
• Primary Library: openpyxl (for Excel file creation, styling, formulas)
• Data Processing: pandas (for data manipulation, then export via openpyxl)
• Execution: Write a Python script in the workspace and run it with python through the Bash tool

🔧 Execution Environment:

• Daimon's managed interpreter is already first on the Bash tool's PATH. Run workspace scripts with python; do not hard-code the interpreter path

Python Excel Creation Pattern:

from openpyxl import Workbook
from openpyxl.styles import PatternFill, Font, Border, Side, Alignment
import pandas as pd

# Create workbook
wb = Workbook()
ws = wb.active
ws.title = "Data"

# Add data
ws['A1'] = "Header1"
ws['B1'] = "Header2"

# Apply styling
ws['A1'].font = Font(bold=True, color="FFFFFF")
ws['A1'].fill = PatternFill(start_color="333333", end_color="333333", fill_type="solid")

# Save
wb.save('output.xlsx')

</Technology Stack>

Finance Sub-Skills

For finance tasks, load only the needed sub skill. Use the active finance sub skill as the primary authority for methodology, model structure, workbook construction, layout, fonts, colors, formatting logic, and finance-specific review or validation standards. For content not covered by the active finance sub skill, follow this parent xlsx skill. If a finance sub skill defines stricter review, validation, checking, or delivery requirements, follow the finance sub skill first.

Default coordination:

1. comps-analysis is usually standalone. Combine it with another valuation workflow only when the user explicitly asks, and then refer to the method and reference
2. DCF usually builds on 3 statement model. If the user asks for a DCF, first leverage3 statement model, then build on it and extend with DCF , unless the user explicitly asks to skip the three-statement model or wants a very simple version.
3. Other model-based PE / IB valuation tasks such as LBO usually start from 3 statement model, unless the user asks for a presentation-only output or provides a completed model.