prompts/workflow/data_arrangement.txt

ORGANIZE REVENUE DATA FOR EXCEL

Your task: Organize the provided revenue data into a JSON file with 5 categories.

CATEGORIES TO CREATE:
1. Company_Overview - Company details and metadata
2. Total_Revenue - All total/consolidated revenue figures  
3. Segment_Revenue - Revenue by business segment/division
4. Regional_Revenue - Revenue by geographic region
5. Data_Quality - Confidence scores and extraction notes

JSON STRUCTURE:
{
  "Category_Name": {
    "headers": {"Item": "...", "Value": "...", "Unit": "...", "Period": "...", "Confidence": "..."},
    "data": [{"item": "...", "value": "...", "unit": "...", "period": "...", "confidence": "..."}],
    "metadata": {"description": "...", "data_count": "...", "quality_score": "..."}
  }
}

STEPS:
1. Parse the revenue data below
2. Map each data point to the correct category
3. Create the JSON structure
4. save_file('arranged_financial_data.json', json_content)
5. list_files() to verify the file exists
6. If file not found, retry save_file() once

RULES:
- Use EXACT values from the input data (no modifications)
- Use EXACT company name, currency, and period from input
- Focus ONLY on revenue data (ignore expenses, assets, etc.)

The revenue data to organize:
{extracted_data}