File size: 1,240 Bytes
8b21729 90b0a17 8b21729 90b0a17 8b21729 90b0a17 8b21729 90b0a17 8b21729 90b0a17 8b21729 |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 |
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} |