FinWorkBench/Finch

1{
2  "id": "8",
3  "instruction_en": "I am studying how partisan standoffs influence administrative efficiency and the macro-economy, so I need a quantitative overview of every federal government shutdown.\\n\\nPlease output an xlsx file with Sheet1 as the RawData sheet, with the columns in this order:\\nStart Date, End Date, Duration (days), President, Speaker of the House, Senate Majority Leader, Furloughed Employees, Estimated Loss (USD million) , Main Disputed Provisions\\n\\nRequirements:\\n1. Cover every officially recorded federal government shutdown between October 1976 and December 2024 (including October 1976 and December 2024).\\n2. Date should be formatted as YYYY-MM-DD.\\n3. Record the President, House and Senate leaders during the shutdown period.\\n4. For furloughed employees and estimated loss, give the exact number. If there is no exact number or data is unavailable, fill in with \\\"–\\\".\\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_Presidential_Era: Aggregate shutdowns by President to analyze patterns across different administrations.\\nColumns: President, Number of Shutdowns, Total Days, Average Duration (days), Longest Shutdown (days), Total Furloughed Employees, Total Estimated Loss (USD million), Era Severity Rating\\nAverage Duration with 1 decimal. Era Severity Rating: \\\"High Frequency & High Impact\\\" if ≥5 shutdowns AND ≥30 total days; \\\"High Frequency\\\" if ≥5 shutdowns only; \\\"High Impact\\\" if ≥30 total days only; \\\"Moderate\\\" if ≥2 shutdowns; \\\"Low\\\" otherwise. For totals: \\\"N/A\\\" if all source values are \\\"–\\\", otherwise sum available numeric values. Sort by presidential chronological order (by order of first appearance in RawData).\\n\\nSubtask 2 - Sheet3_Timeline_Context: Add chronological context and temporal analysis.\\nColumns: Start Date, End Date, Duration (days), Year, Decade, President, Days Since Previous Shutdown, Cumulative Shutdown Count, Duration Category\\nYear: extract from Start Date (integer). Decade: \\\"1970s\\\", \\\"1980s\\\", \\\"1990s\\\", \\\"2000s\\\", \\\"2010s\\\", \\\"2020s\\\". Days Since Previous Shutdown: days between previous shutdown's End Date and current Start Date (integer), \\\"First Event\\\" for row 1. Cumulative Shutdown Count: sequential number 1, 2, 3... (integer). Duration Category: \\\"Extended (≥14 days)\\\" if ≥14, \\\"Moderate (5-13 days)\\\" if 5-13, \\\"Brief (<5 days)\\\" if <5.\\n\\nSubtask 3 - Sheet4_Data_Validation: Assess data completeness for each shutdown event.\\nColumns: Start Date, President, Has Furloughed Data, Has Loss Data, Has Provisions Data, Data Completeness (%), Quality Rating, Missing Fields\\nHas [Field] Data: \\\"Yes\\\" if data exists, \\\"No\\\" if \\\"–\\\". Data Completeness (%): (count of \\\"Yes\\\" fields / 3) × 100 (1 decimal). Quality Rating: \\\"Complete\\\" if 100%, \\\"Good\\\" if ≥66.7%, \\\"Partial\\\" if ≥33.3%, \\\"Poor\\\" if <33.3%. Missing Fields: comma-separated list like \\\"Furloughed, Loss\\\" or \\\"None\\\".\\n\\nSubtask 4 - Sheet5_Impact_Classification: Classify shutdown severity based on multiple impact dimensions.\\nColumns: Start Date, Duration (days), President, Furloughed Employees, Estimated Loss (USD million), Duration Impact, Economic Impact, Workforce Impact, Overall Severity Score, Overall Impact Classification\\nDuration Impact: \\\"Severe\\\" if ≥14 days, \\\"Moderate\\\" if 5-13, \\\"Minor\\\" if <5. Economic Impact: \\\"Unknown\\\" if N/A or \\\"–\\\", \\\"Major\\\" if ≥1000M, \\\"Significant\\\" if ≥100M, \\\"Moderate\\\" if ≥10M, \\\"Minor\\\" if <10M. Workforce Impact: \\\"Unknown\\\" if N/A or \\\"–\\\", \\\"Massive\\\" if ≥500K, \\\"Major\\\" if ≥100K, \\\"Moderate\\\" if ≥10K, \\\"Limited\\\" if <10K. Overall Severity Score: Duration component (max 40 points) + Economic component (max 30 points) + Workforce component (max 30 points), result with 1 decimal. Overall Impact Classification: \\\"Critical\\\" if ≥70, \\\"High\\\" if ≥50, \\\"Moderate\\\" if ≥30, \\\"Low\\\" if ≥10, \\\"Minimal\\\" if <10.",
4  "source_files": [],
5  "source_files_urls": [],
6  "reference_outputs": {
7    "files": [
8      "8_ref_0.xlsx"
9    ],
10    "text": ""
11  },
12  "reference_file_urls": [
13    "https://huggingface.co/datasets/FinWorkBench/Finch/resolve/main/files/8/8_ref_0.xlsx"
14  ],
15  "task_type": "Web Search, Data Entry / Import, Structuring / Formatting, Calculation, Validation / Review",
16  "business_type": "Report, Predictive Modeling",
17  "task_constraints": ""
18}