XLSX creation, editing, and analysis

Requirements for All Excel Files

• Use a consistent, professional font (Arial, Times New Roman) for all deliverables
• Every Excel model MUST be delivered with ZERO formula errors (#REF!, #DIV/0!, #VALUE!, #N/A, #NAME?)
• Study and EXACTLY match existing format, style, and conventions when modifying files

Financial Model Color Coding Standards

• Blue text (RGB: 0,0,255): Hardcoded inputs
• Black text (RGB: 0,0,0): ALL formulas and calculations
• Green text (RGB: 0,128,0): Links pulling from other worksheets within same workbook
• Red text (RGB: 255,0,0): External links to other files

CRITICAL: Use Formulas, Not Hardcoded Values

Always use Excel formulas instead of calculating values in Python and hardcoding them.