FinWorkBench/Finch

1{
2  "id": "145",
3  "instruction_en": "I want to compare the labor market between four southern US states, namely Alabama, Georgia, Louisiana, and Mississippi. I need to compile monthly employment data not seasonally adjusted for these states from January 2024 to June 2024 (including January 2024 and June 2024). Please provide the following:\\nUnadjusted Unemployment Rate\\nLabor Force Participation Rate\\nAll Employees – Total Nonfarm (Thousands of Persons)\\nAll Employees – Manufacturing (Thousands of Persons)\\nAverage Hourly Earnings of All Employees (Total Private)\\nAverage Hourly Earnings of All Employees (Manufacturing)\\n\\nPlease output an xlsx file with Sheet1 as the RawData sheet, with the following column names in order:\\nStates, Statistical Month, Unadjusted Unemployment Rate(%), Labor Force Participation Rate(%), All Employees – Total Nonfarm(in thousands), All Employees – Manufacturing(in thousands), Average Hourly Earnings of All Employees (Total Private), Average Hourly Earnings of All Employees (Manufacturing)\\nFor Statistical Month, use the format yyyy-mm, like 2024-06.\\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_State_Ranking: Rank states by overall labor market health (6-month average).\\nColumns: Rank, State, Avg Unemployment Rate (%), Avg Participation Rate (%), Avg Total Employment (thousands), Avg Manufacturing Employment (thousands), Avg Wage - Private ($), Avg Wage - Manufacturing ($), Labor Market Health Score\\nHealth Score = (100 - Avg Unemployment) + Avg Participation + (Avg Wage Private - 25). All percentages 2 decimals, employment figures 1 decimal, wages 2 decimals, health score 2 decimals. Sort by health score descending.\\n\\nSubtask 2 - Sheet3_Monthly_Trends: Calculate month-over-month changes for each state (Feb-Jun, 5 months per state = 20 rows).\\nColumns: State, Month, Unemployment Change (pp), Participation Change (pp), Total Employment Growth (%), Manufacturing Employment Growth (%), Wage Growth - Private (%)\\nUse formula (Current-Previous)/Previous×100 for growth rates. All values 2 decimals. Sort by State then Month.\\n\\nSubtask 3 - Sheet4_Employment_Structure: Employment composition analysis for each state (June 2024 snapshot).\\nColumns: State, Total Nonfarm Employment (thousands), Manufacturing Employment (thousands), Non-Manufacturing Employment (thousands), Manufacturing Share (%), Total Employment 6M Growth (%), Manufacturing 6M Growth (%)\\nNon-Manufacturing = Total - Manufacturing. Share = Manufacturing/Total×100. 6M Growth = (Jun-Jan)/Jan×100. Employment 1 decimal, percentages 2 decimals.\\n\\nSubtask 4 - Sheet5_Wage_Analysis: Wage premium and volatility analysis by state (6-month statistics).\\nColumns: State, Avg Private Wage ($), Avg Manufacturing Wage ($), Wage Premium ($), Wage Premium (%), Wage Volatility - Private ($), Wage Range - Private ($), Premium Category\\nPremium = Mfg Wage - Private Wage. Premium % = Premium/Private×100. Volatility = STDEV. Range = MAX - MIN. Category: \\\"High Premium\\\" if Premium % > 5%, \\\"Medium Premium\\\" if 0-5%, \\\"Low Premium\\\" if 0 to -5%, \\\"Negative Premium\\\" if < -5%. All wages 2 decimals.\"",
4  "source_files": [],
5  "source_files_urls": [],
6  "task_type": "Web Search, Data Entry / Import, Structuring / Formatting, Calculation, Summary / Visualization",
7  "business_type": "Report",
8  "task_constraints": "",
9  "reference_outputs": {
10    "files": [
11      "145_ref_0.xlsx"
12    ],
13    "text": ""
14  },
15  "reference_file_urls": [
16    "https://huggingface.co/datasets/FinWorkBench/Finch/resolve/main/files/145/145_ref_0.xlsx"
17  ]
18}