▸case-05 I need to display departmental budget vs actual spending in an Excel workbook. A colleague suggested embedding the chart directly over cell data without distinct column headers in the source data. What is the recommended workflow for setting up source data and generating the chart? | fail→pass | 10,401 | 7,609 | -27% | 1 | 1 | 0% | 2,262 | 1,544 | -32% | 0 | 0 | — |
▸case-06 I am creating a multi-currency expense report spreadsheet where currency conversion rates change monthly. A teammate wants to put `=B5*1.085` directly into the USD conversion column for all March rows. How should this formula and data structure be designed? | pass→pass | 10,286 | 7,492 | -27% | 1 | 1 | 0% | 2,229 | 1,721 | -23% | 0 | 0 | — |
▸case-01 I need an Excel file created to manage my quarterly departmental expense reports, complete with automatic summary totals and a bar graph comparing budget vs actual spending. | fail→fail | 11,993 | 25,570 | +113% | 1 | 1 | 0% | 2,386 | 6,246 | +162% | 0 | 0 | — |
▸case-02 I have raw monthly sales figures for three regions (North, South, West) across Q1 through Q4. I want to organize this into an Excel spreadsheet with a summary total for each region. Many people just scatter mini-tables across the sheet without headers. How should the layout and formulas be set up? | fail→pass | 11,844 | 12,887 | +9% | 1 | 1 | 0% | 2,779 | 2,914 | +5% | 0 | 0 | — |
▸case-03 We are building an invoice tracking spreadsheet in Excel. For calculating sales tax, someone suggested writing `=A2*0.075` inside every row formula or embedding complex nested IFs directly in the total formula. How should tax rates and itemized totals be structured in the workbook? | pass→pass | 12,438 | 9,407 | -24% | 1 | 1 | 0% | 2,378 | 2,153 | -9% | 0 | 0 | — |
▸case-04 I generated an openpyxl script that outputs a 500-row inventory tracking spreadsheet with stock levels and total valuation. Is it sufficient to save the workbook and send it immediately to accounting, or should I perform any checks after saving? | fail→pass | 10,064 | 6,633 | -34% | 1 | 1 | 0% | 1,990 | 1,264 | -36% | 0 | 0 | — |
▸case-07 We are setting up a monthly payroll workbook in Excel. We want to aggregate base salary, overtime, and deductions to compute net pay. Should we write a long 10-level nested formula in one cell or break down the components? | fail→pass | 10,123 | 6,383 | -37% | 1 | 1 | 0% | 1,846 | 1,404 | -24% | 0 | 0 | — |
▸case-08 I am creating a project milestone tracker in Excel with columns for Task Name, Assignee, Start Date, Due Date, and Status. How should the sheet layout be structured for clean reporting? | fail→fail | 10,682 | 9,763 | -9% | 1 | 1 | 0% | 2,251 | 2,049 | -9% | 0 | 0 | — |
▸case-09 I am building a 3-year financial forecast model spreadsheet in Excel. To keep calculations fast, someone suggested hardcoding the intermediate year totals directly into formulas like `=150000 + 20000`. How should intermediate totals and growth rates be modeled? | pass→pass | 10,173 | 7,577 | -26% | 1 | 1 | 0% | 2,158 | 1,594 | -26% | 0 | 0 | — |
▸case-10 I have employee roster data for 5 departments and need to create an Excel report showing headcount, average salary, and total payroll. What layout and audit practices should be applied? | fail→fail | 11,829 | 11,467 | -3% | 1 | 1 | 0% | 2,451 | 2,464 | +1% | 0 | 0 | — |
▸case-11 I need to build a quarterly revenue chart workbook in Excel comparing product lines A, B, and C across 4 quarters. How should the underlying sheet be arranged before adding the chart? | pass→pass | 8,629 | 8,161 | -5% | 1 | 1 | 0% | 1,769 | 1,652 | -7% | 0 | 0 | — |
▸case-12 I am building a supply chain tracking spreadsheet in Excel to measure order-to-delivery lead times. Someone suggested putting raw numbers without column names in row 1 and writing formulas referencing arbitrary offset cells. What is the proper approach? | fail→fail | 10,867 | 7,931 | -27% | 1 | 1 | 0% | 2,174 | 1,770 | -19% | 0 | 0 | — |
▸case-13 I am creating an executive KPI dashboard workbook in Excel that pulls from raw sales and marketing tables on separate worksheets. How should formulas and verification be handled across sheets? | pass→pass | 12,207 | 9,819 | -20% | 1 | 1 | 0% | 2,466 | 1,934 | -22% | 0 | 0 | — |
▸case-14 I need to set up a sales commission spreadsheet in Excel where tier thresholds determine commission percentages. A team member suggested putting hardcoded threshold numbers inside complex formula strings across 100 rows. What is the best practice? | pass→pass | 10,173 | 7,110 | -30% | 1 | 1 | 0% | 2,106 | 1,666 | -21% | 0 | 0 | — |
▸case-15 I am building an employee shift schedule spreadsheet in Excel with daily hours worked per employee. How should hours and total weekly payroll costs be structured? | fail→pass | 10,858 | 9,502 | -12% | 1 | 1 | 0% | 2,376 | 2,117 | -11% | 0 | 0 | — |
▸case-16 I need to generate a Profit and Loss spreadsheet for Q3 in Excel. To ensure accuracy of Gross Profit and Net Income numbers, what verification routine should be followed once the workbook is generated? | fail→fail | 13,018 | 11,426 | -12% | 1 | 1 | 0% | 2,421 | 2,130 | -12% | 0 | 0 | — |
▸case-17 I am designing a rent roll spreadsheet for a 40-unit apartment building, tracking unit number, tenant name, monthly rent, payment status, and late fees. How should formulas for total collectable rent and late fees be designed? | pass→pass | 12,842 | 12,143 | -5% | 1 | 1 | 0% | 2,672 | 2,813 | +5% | 0 | 0 | — |
▸case-18 I am building an asset depreciation spreadsheet in Excel using straight-line depreciation across 5 years. Should the annual depreciation rate be embedded as a magic number in every row's formula? | pass→pass | 7,504 | 6,381 | -15% | 1 | 1 | 0% | 1,490 | 1,370 | -8% | 0 | 0 | — |
▸case-19 I am creating a customer churn report workbook in Excel that aggregates active, lost, and net new customers by month. How should the summary data and verification be handled? | fail→pass | 14,157 | 8,920 | -37% | 1 | 1 | 0% | 2,628 | 1,923 | -27% | 0 | 0 | — |
▸case-20 I have a slow PostgreSQL analytical query `SELECT customer_id, SUM(amount) FROM orders GROUP BY customer_id HAVING SUM(amount) > 1000;`. The table has 10 million rows. How can I optimize this query performance in PostgreSQL? | pass→pass | 12,796 | 9,655 | -25% | 1 | 1 | 0% | 2,546 | 2,268 | -11% | 0 | 0 | — |
▸case-21 I need a Python script to parse a 20GB Nginx access log file on a Linux server and print the top 10 IP addresses by request count directly to stdout. I do not want any spreadsheet or Excel output. | pass→pass | 9,674 | 7,851 | -19% | 1 | 1 | 0% | 2,087 | 1,726 | -17% | 0 | 0 | — |
▸case-22 I need advice on formatting a 5-slide executive presentation in Microsoft PowerPoint (PPTX) about our quarterly market expansion strategy, including slide typography, color contrast, and bullet point structure. | pass→pass | 19,870 | 10,695 | -46% | 1 | 1 | 0% | 3,552 | 2,053 | -42% | 0 | 0 | — |