▸case-04 We have quarterly sales figures across four separate data files that need to be combined into a single workbook with dedicated tabs for each quarter and a master summary tab. How should this multi-tab file be constructed? | fail→fail | 13,060 | 13,157 | +1% | 1 | 1 | 0% | 2,313 | 2,413 | +4% | 0 | 0 | — |
▸case-05 I want to highlight all rows where the 'Days Overdue' column exceeds 30 in bright red in an Excel workbook. Is it better to manually select cells in Excel and apply fill color, or write code to build the sheet? | pass→pass | 10,575 | 10,063 | -5% | 1 | 1 | 0% | 1,911 | 1,917 | +0% | 0 | 0 | — |
▸case-18 We need to distribute a template workbook where formula cells are protected from accidental editing by staff, secured with a password 'Protect2024'. How can this worksheet protection be enabled programmatically? | pass→pass | 12,106 | 6,921 | -43% | 1 | 1 | 0% | 2,455 | 1,389 | -43% | 0 | 0 | — |
▸case-02 I need to audit an existing spreadsheet of inventory records to remove out-of-stock items and generate a refreshed Excel file containing only available stock, accompanied by a brief summary of removed entries. | fail→fail | 6,448 | 4,904 | -24% | 1 | 1 | 0% | 1,078 | 891 | -17% | 0 | 0 | — |
▸case-03 I need an automated script to generate a quarterly financial report spreadsheet with revenue, expenses, and net profit formatted as currency with two decimal places. Should I manually format the cells after creation, or how can this be automated programmatically? | pass→pass | 11,525 | 22,969 | +99% | 1 | 1 | 0% | 2,196 | 5,573 | +154% | 0 | 0 | — |
▸case-01 I have a CSV file containing recent sales data that I'd like converted into a structured Excel workbook with summarized category totals. Can you process the raw data and produce a ready-to-download .xlsx file? | fail→fail | 5,319 | 3,488 | -34% | 1 | 1 | 0% | 858 | 558 | -35% | 0 | 0 | — |
▸case-06 When exporting a monthly expense sheet with total row sums and average calculations, should the output file contain static computed number values or dynamic spreadsheet formulas? | fail→pass | 11,696 | 7,122 | -39% | 1 | 1 | 0% | 1,946 | 1,252 | -36% | 0 | 0 | — |
▸case-07 Whenever I export data to Excel using basic scripts, the text in column headers like 'Transaction_Identification_Number' gets truncated because columns are too narrow. What is the standard way to fix column sizing programmatically? | pass→pass | 11,514 | 10,325 | -10% | 1 | 1 | 0% | 2,144 | 2,021 | -6% | 0 | 0 | — |
▸case-08 I need to produce an Excel sheet containing region sales figures along with an embedded visual column chart comparing the regions. Can this chart be created directly inside the file programmatically? | pass→pass | 11,484 | 12,451 | +8% | 1 | 1 | 0% | 2,364 | 2,665 | +13% | 0 | 0 | — |
▸case-09 I need to write a script that generates an Excel workbook with 500,000 rows of transaction logs. Normal dataframe export crashes with out-of-memory errors. What programmatic approach handles massive Excel writes efficiently? | pass→pass | 15,713 | 15,775 | +0% | 1 | 1 | 0% | 3,116 | 3,286 | +5% | 0 | 0 | — |
▸case-10 I am generating an intake spreadsheet where users must enter a status value. To prevent typos, I want the 'Status' column restricted to a drop-down list of 'Pending', 'Approved', and 'Rejected'. How can this be embedded into the generated spreadsheet? | pass→pass | 10,338 | 10,463 | +1% | 1 | 1 | 0% | 2,184 | 2,245 | +3% | 0 | 0 | — |
▸case-11 Our company header styling guidelines require top table headers to have a navy blue background fill, bold white text, and centered alignment. How can we ensure newly generated spreadsheets adhere to these styling rules programmatically? | pass→pass | 12,550 | 12,750 | +2% | 1 | 1 | 0% | 2,611 | 2,502 | -4% | 0 | 0 | — |
▸case-12 When building an executive KPI dashboard in Excel, columns for 'Conversion Rate' show raw decimals like 0.1542 and 'Signup Date' shows raw timestamp numbers. How do we format these correctly in openpyxl? | pass→pass | 11,075 | 12,586 | +14% | 1 | 1 | 0% | 2,095 | 2,532 | +21% | 0 | 0 | — |
▸case-13 When users scroll down through hundreds of rows in our generated reports, they lose sight of the column headers. How can we lock the top row in place inside the output spreadsheet file using code? | pass→pass | 9,744 | 6,701 | -31% | 1 | 1 | 0% | 1,979 | 1,308 | -34% | 0 | 0 | — |
▸case-14 We have 12 monthly Excel files in a folder named 'sales_2023'. I need a script to read all 12 files, concatenate their data, and output a single consolidated master Excel file. What is the standard programmatic workflow? | pass→pass | 9,238 | 12,849 | +39% | 1 | 1 | 0% | 1,851 | 2,581 | +39% | 0 | 0 | — |
▸case-15 Instead of plain cell grid rows, I want my generated spreadsheet data formatted as a formal Excel Table object named 'SalesTable' with built-in column sorting and zebra striping filters. How is this achieved programmatically? | pass→pass | 13,709 | 13,665 | -0% | 1 | 1 | 0% | 2,880 | 3,078 | +7% | 0 | 0 | — |
▸case-16 I have a legacy Excel file where the relevant financial figures start at cell C5 and span through G25 on a sheet named 'Q4_Results'. How do I extract just this block into Python for analysis? | pass→pass | 16,743 | 5,761 | -66% | 1 | 1 | 0% | 1,946 | 1,103 | -43% | 0 | 0 | — |
▸case-17 After writing 50 rows of line item costs, I want the bottom row to automatically calculate total cost using SUM for column D and average unit price using AVERAGE for column E. How should the script construct this final row? | pass→fail | 11,910 | 8,343 | -30% | 1 | 1 | 0% | 2,353 | 1,598 | -32% | 0 | 0 | — |
▸case-19 We want our corporate logo image 'company_logo.png' inserted into cell A1 of every generated quarterly report spreadsheet. What Python code inserts image files into an Excel worksheet? | pass→pass | 7,973 | 3,909 | -51% | 1 | 1 | 0% | 1,656 | 838 | -49% | 0 | 0 | — |
▸case-20 We are migrating our legacy tabular data into PostgreSQL. Can you write a SQL CREATE TABLE schema definition for a customers table with fields for customer_id, company_name, signup_date, and total_spend? | pass→pass | 7,146 | 4,494 | -37% | 1 | 1 | 0% | 1,438 | 905 | -37% | 0 | 0 | — |
▸case-21 I need a Google Apps Script function to automate sending an email notification whenever a new row is appended to a cloud-hosted Google Sheet. Can you write the JavaScript trigger for SpreadsheetApp? | pass→pass | 12,690 | 9,646 | -24% | 1 | 1 | 0% | 2,519 | 1,952 | -23% | 0 | 0 | — |
▸case-22 We are setting up server monitoring in Grafana using Prometheus metrics. Can you provide a JSON dashboard panel configuration that tracks CPU utilization over time? | pass→pass | 9,567 | 6,909 | -28% | 1 | 1 | 0% | 2,084 | 1,537 | -26% | 0 | 0 | — |