FinWorkBench/Finch

1{
2  "id": "71",
3  "instruction_en": "Please list the top 10 individuals from the Forbes Global Billionaires Ranking for each year from 2019 to 2024 (including 2024). For each person, include their name, ranking, net worth, source of wealth, and age of that year end. Present the information in a table format. All your data should come from Forbes, which means the ages and net worth are calculated based on the publication date.\\n\\nPlease output an xlsx file with Sheet1 as the RawData sheet, with the column headers in order:\\nYear, Rank, Name, Net Worth (in USD billions), Age, Source of Wealth\\n\\nDon't ask me any questions, just output the results according to the columns without omitting cells arbitrarily.\\n\\nBased on the RawData sheet, complete the following 4 subtasks:\\n\\nSubtask 1 - Sheet2_Wealth_Growth: Analyze wealth growth trends and year-over-year changes.\\nColumns: Year, Name, Current Net Worth (USD billions), Annual Change (USD billions), Annual Change (%), Cumulative Growth (%), Growth Trend\\nAnnual Change calculates difference from previous year (N/A for first appearance, 2 decimals). Cumulative Growth (%) is relative to first year on list (2 decimals). Growth Trend: \\\"Rapid Growth\\\" if Annual Change % ≥ 20%, \\\"Steady Growth\\\" if ≥ 5%, \\\"Stable\\\" if -5% to 5%, \\\"Moderate Decline\\\" if -20% to -5%, \\\"Significant Decline\\\" if < -20%, \\\"New Entry\\\" if no previous year data. Net worth values to 2 decimals.\\n\\nSubtask 2 - Sheet3_Industry_Concentration: Aggregate by industry sector and analyze market concentration.\\nColumns: Year, Industry, Billionaire Count, Total Wealth (USD billions), Average Wealth (USD billions), Market Share (%), Concentration Level\\nIndustry standardization: Amazon → E-Commerce, Microsoft → Technology-Software, Tesla/SpaceX → Technology-Automotive/Aerospace, Facebook/Meta → Technology-Social Media, Google/Alphabet → Technology-Internet Services, Oracle → Technology-Enterprise Software, LVMH → Luxury Goods, Berkshire Hathaway → Diversified Holdings, Walmart → Retail, Zara → Fashion Retail, Bloomberg → Financial Services, Telecom → Telecommunications, Reliance → Conglomerate. Market Share (%) = (Industry Total / Year Total) × 100 (2 decimals). Average Wealth = Total / Count (2 decimals). Concentration Level: \\\"Monopolistic\\\" if count = 1, \\\"Highly Concentrated\\\" if count = 2, \\\"Concentrated\\\" if count ≤ 4, \\\"Diversified\\\" if count > 4. Sort by Year ascending, then Total Wealth descending within each year. Billionaire Count is integer.\\n\\nSubtask 3 - Sheet4_Ranking_Stability: Track individual ranking stability and volatility over time.\\nColumns: Name, Years on List, First Year, Last Year, Best Rank, Worst Rank, Average Rank, Rank Volatility, Ranking Trend, Stability Rating\\nYears on List = count of appearances (integer). Best Rank = minimum rank number (integer). Worst Rank = maximum rank number (integer). Average Rank = mean of all ranks (2 decimals). Rank Volatility = standard deviation of ranks, 0.00 if only one year (2 decimals). Ranking Trend: \\\"Rising\\\" if average annual rank change ≤ -1, \\\"Slightly Rising\\\" if ≤ -0.2, \\\"Stable\\\" if -0.2 to 0.2, \\\"Slightly Falling\\\" if ≤ 1, \\\"Falling\\\" if > 1 (rank change calculated as (last rank - first rank) / years span). Stability Rating: \\\"Highly Stable\\\" if years ≥ 6 and volatility ≤ 1.5, \\\"Stable\\\" if years ≥ 5 and volatility ≤ 2.5, \\\"Moderately Stable\\\" if years ≥ 4 and volatility ≤ 3.5, \\\"Volatile\\\" if years ≥ 3, \\\"Insufficient Data\\\" otherwise. Sort by Years on List descending, then by order of first appearance in RawData for ties. First Year, Last Year, Best Rank, Worst Rank are integers.\\n\\nSubtask 4 - Sheet5_Pivot_Summary: Create pivot summary showing top 3 and aggregate statistics by year.\\nColumns: Year, Rank 1 Name, Rank 1 Wealth (USD billions), Rank 2 Name, Rank 2 Wealth (USD billions), Rank 3 Name, Rank 3 Wealth (USD billions), Total Top 10 Wealth (USD billions), Average Top 10 Wealth (USD billions), Median Age, Wealth Gap (Rank 1 vs Rank 10), Top 3 Concentration (%)\\nTotal Top 10 Wealth = sum of all 10 billionaires (2 decimals). Average Top 10 Wealth = Total / 10 (2 decimals). Median Age = median of 10 ages (integer). Wealth Gap = Rank 1 wealth - Rank 10 wealth (2 decimals). Top 3 Concentration (%) = (Sum of Top 3 / Total Top 10) × 100 (2 decimals). All wealth values to 2 decimals. Sort by Year ascending.",
4  "source_files": [],
5  "source_files_urls": [],
6  "reference_outputs": {
7    "files": [
8      "71_ref_0.xlsx"
9    ],
10    "text": ""
11  },
12  "reference_file_urls": [
13    "https://huggingface.co/datasets/FinWorkBench/Finch/resolve/main/files/71/71_ref_0.xlsx"
14  ],
15  "task_type": "Web Search, Data Entry / Import, Structuring / Formatting, Calculation, Summary / Visualization",
16  "business_type": "Report",
17  "task_constraints": ""
18}