FRTR Retrieval Evaluation Report

Generated: 2026-04-29T23:41:29.813019 · Questions: 105 (54 excluded) · Modes: dense, bm25, hybrid

⚙ Query Strategy 📖 Metric Reference 📄 Doc Retrieval 🔍 Range Retrieval 🧩 Chunk Type 📊 Error Analysis 📋 Details
Query Strategy & Configuration

本报告的所有指标数据基于以下检索策略和配置产生，理解查询方式对解读指标至关重要。

Retrieval Modes

ModeDescription
dense 将 query 通过 embedding 模型编码为向量，在 Milvus 中执行 ANN（近似最近邻）向量检索。 度量方式为 COSINE，索引类型为 HNSW。 仅依赖语义相似度，对关键词不敏感。
bm25 利用 Milvus 内置的 BM25 稀疏检索，在 sparse 字段上执行全文检索。 基于词频和文档频率匹配，对精确关键词敏感，但不理解语义同义。
hybrid 同时执行 dense 和 bm25 两路检索，使用 RRF（Reciprocal Rank Fusion, k=60） 将两路排名合并。 兼顾语义相似度和关键词精确匹配。

Search Parameters

Collectionfrtr_spreadsheet_chunks
Embedding Modelbge-m3
Embed Max Text (bytes)8000
Milvus Text Max (bytes)8000
Vector Fieldembedding
Metric / IndexCOSINE / HNSW
Top-K (per query)50
Evaluation K values1, 3, 7, 20, 50

Dataset & Filtering

Dataset Dir/Users/yue.zhang04/try/FRTR-bench
Workbook Glob*.xlsx
Workbook Filter OFF (full-library search)
Exclude Image Qs YES
Excluded SheetsQuestions
Chunk Typescolumn, row, sheet, window

Chunking Geometry

每个 Excel region 被切分为三种 chunk：

TypeShapeInfo Density
row全部列 × 1 行低
column1 列 × 全部行低
windowN×M 矩形区域高

Range Recall 仅判定 anchor_range 与金标区域有矩形交集， row/column chunk 命中不代表包含回答所需的完整数据。

Metric Reference

检索评测从三个粒度衡量召回效果，从粗到细依次为 Doc → Sheet → Range。 Range 级别进一步区分"交集命中"（宽松）和"完整包含"（严格）两种判定。

Workbook Recall@K Doc 维度
Top-K 个 chunk 中，是否存在来自正确 workbook 的 chunk（仅匹配文件名）。衡量"能否找到相关文档"。
Sheet Recall@K Doc 维度
Top-K 个 chunk 中，是否存在来自正确 workbook 且正确 sheet 的 chunk。衡量定位到正确工作表的能力。
Range Recall@K 宽松 / 交集
Top-K 中是否存在 chunk 的 anchor_range 与金标 provenance 有交集。反映"是否沾边"，不代表信息量足以回答问题。
Range Containment@K 严格 / 包含
Top-K 中是否存在 chunk 完全包含金标区域。衡量召回信息的完整性。row/column chunk 很难满足此条件。
Ref Full Coverage@K 严格 / 全覆盖
多引用问题中，Top-K 是否全部覆盖每一个引用。单引用等价于 range_recall，多引用时更严格。
Containment Coverage@K
要求每个引用被 chunk 完全包含才计入覆盖，取平均比例。最严格的覆盖率指标。
MRR
首次命中排名倒数的平均。Workbook MRR / Range MRR 分别衡量不同粒度的排名质量。
Hit Chunk Type
首次 range 命中的 chunk 类型。row=单行，column=单列，window=矩形窗口。类型不同，信息密度差异大。
Doc-Level Retrieval (Workbook / Sheet)
dense
82%
Workbook Recall@3 · MRR 0.8194
bm25
56%
Workbook Recall@3 · MRR 0.5410
hybrid
85%
Workbook Recall@3 · MRR 0.7993

Workbook Recall@K

0% 25% 50% 75% 100% 1 3 7 20 50 81% 82% 83% 85% 87% 47% 56% 76% 82% 85% 72% 85% 90% 97% 98% dense bm25 hybrid

Sheet Recall@K

0% 25% 50% 75% 100% 1 3 7 20 50 35% 38% 40% 41% 43% 28% 38% 46% 50% 51% 29% 41% 52% 65% 68% dense bm25 hybrid

Workbook MRR by Mode

0.000 0.205 0.410 0.615 0.819 dense 0.8194 bm25 0.5410 hybrid 0.7993 Workbook MRR
Range-Level Retrieval (Cell Region)
dense
37%
Range Recall@7 · MRR 0.3399
bm25
25%
Range Recall@7 · MRR 0.1611
hybrid
41%
Range Recall@7 · MRR 0.3100

Recall vs Containment @K

Range Recall（交集）vs Range Containment（完整包含）。两条曲线的差距反映"沾边命中但信息不完整"的比例。

Range Recall@K (Intersect)

0% 25% 50% 75% 100% 1 3 7 20 50 32% 35% 37% 39% 41% 11% 20% 25% 29% 31% 25% 32% 41% 47% 52% dense bm25 hybrid

Range Containment@K (Full Cover)

0% 25% 50% 75% 100% 1 3 7 20 50 6% 8% 11% 13% 14% 2% 6% 9% 12% 13% 5% 9% 13% 17% 21% dense bm25 hybrid

Coverage Metrics @K

Ref Full Coverage 要求覆盖全部金标引用（适合多引用问题）；Containment Coverage 要求每个引用被完整包含。

Reference Full Coverage@K

0% 25% 50% 75% 100% 1 3 7 20 50 26% 29% 31% 34% 36% 8% 17% 19% 24% 25% 19% 26% 36% 41% 46% dense bm25 hybrid

Containment Coverage@K (Mean)

0% 25% 50% 75% 100% 1 3 7 20 50 5% 7% 10% 12% 13% 2% 6% 8% 10% 12% 4% 8% 12% 16% 20% dense bm25 hybrid

Range MRR by Mode

0.000 0.085 0.170 0.255 0.340 dense 0.3399 bm25 0.1611 hybrid 0.3100 Range MRR
Chunk Type Analysis

不同类型的 chunk（row / column / window）的几何覆盖范围差异大。 即使 range_recall 命中了 row chunk，它可能只覆盖了金标区域的一小部分，回答效果受限。

dense

按 chunk 类型拆分的 recall 贡献率 + 首次命中 chunk 类型分布。

Recall@K by Chunk Type

0% 25% 50% 75% 100% 1 3 7 20 50 1% 1% 3% 3% 4% 25% 30% 31% 34% 36% 0% 3% 7% 9% 10% 6% 13% 20% 24% 24% column row sheet window

First Hit Chunk Type Distribution

column (1, 2%) row (29, 71%) window (11, 27%)

bm25

按 chunk 类型拆分的 recall 贡献率 + 首次命中 chunk 类型分布。

Recall@K by Chunk Type

0% 25% 50% 75% 100% 1 3 7 20 50 1% 7% 7% 7% 8% 6% 11% 18% 22% 23% 1% 2% 4% 9% 10% 3% 5% 9% 13% 15% column row sheet window

First Hit Chunk Type Distribution

column (5, 16%) row (18, 58%) sheet (3, 10%) window (5, 16%)

hybrid

按 chunk 类型拆分的 recall 贡献率 + 首次命中 chunk 类型分布。

Recall@K by Chunk Type

0% 25% 50% 75% 100% 1 3 7 20 50 0% 1% 6% 8% 9% 19% 25% 34% 42% 47% 1% 5% 7% 11% 15% 5% 11% 17% 29% 31% column row sheet window

First Hit Chunk Type Distribution

column (1, 2%) row (36, 69%) sheet (3, 6%) window (12, 23%)
Error Analysis

Attribution Distribution

归因层级（从好到差）：success_full_coverage > partial_range_hit > sheet_hit_range_miss > workbook_hit_sheet_miss > workbook_miss

dense

no_range_gold (5, 5%) partial_range_hit (5, 5%) sheet_hit_range_miss (2, 2%) success_full_coverage (36, 34%) workbook_hit_sheet_miss (46, 44%) workbook_miss (11, 10%)

bm25

no_range_gold (5, 5%) partial_range_hit (6, 6%) sheet_hit_range_miss (20, 19%) success_full_coverage (25, 24%) workbook_hit_sheet_miss (35, 33%) workbook_miss (14, 13%)

hybrid

no_range_gold (5, 5%) partial_range_hit (6, 6%) sheet_hit_range_miss (16, 15%) success_full_coverage (46, 44%) workbook_hit_sheet_miss (31, 30%) workbook_miss (1, 1%)

Range Recall@10 by Difficulty

0.000 0.250 0.500 0.750 1.000 Easy 0.0000 0.0000 0.0000 Hard 0.0000 0.0000 0.0000 Hardest 0.0000 0.0000 0.0000 Medium 0.0000 0.0000 0.0000 dense bm25 hybrid
Per-Question Details
Mode Workbook Q# Question Difficulty Attribution Hit Type WB Rank Range Rank Contain Rank WB R@10 Range R@10 Contain@10
dense frtr_0001_quarterly-summary.xl... 1 What is total revenue in Q2 2024? Easy success_full_coverage row 1 1 1 0 0 0
dense frtr_0001_quarterly-summary.xl... 3 What is the gross margin percentage in Q3 2024? Easy success_full_coverage row 1 1 1 0 0 0
dense frtr_0001_quarterly-summary.xl... 4 What is total expenses in Q1 2024? Easy success_full_coverage row 1 1 1 0 0 0
dense frtr_0001_quarterly-summary.xl... 6 Which region appears most frequently in revenue records? Hard success_full_coverage window 2 2 — 0 0 0
dense frtr_00027_supply-chain-region... 1 On-time rate for West region in March 2024? Medium workbook_miss — — — — 0 0 0
dense frtr_00027_supply-chain-region... 3 Average cost per shipment for Midwest in September 2023? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_00027_supply-chain-region... 4 How many shipments from Northeast hubs in January 2024? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_00027_supply-chain-region... 5 Region with highest variability in 2024 AvgCost? Hard workbook_miss — — — — 0 0 0
dense frtr_0002_ops-inventory.xlsx 2 What is the net movement quantity for SKU SKU-00103? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0002_ops-inventory.xlsx 3 What average unit cost is reported for SKU SKU-00106? Easy partial_range_hit window 7 7 — 0 0 0
dense frtr_0002_ops-inventory.xlsx 4 Identify the VendorName for SKU SKU-00115 using XLOOKUP. Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0002_ops-inventory.xlsx 6 Is there a stockout risk (>30%) for any SKU in the table? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0002_ops-inventory.xlsx 7 What’s the total PO quantity for SKU SKU-00121 (from Purchas... Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0003_consolidation.xlsx 1 What is the consolidated total local amount for account 4000... Medium success_full_coverage row 1 1 1 0 0 0
dense frtr_0003_consolidation.xlsx 3 How many subsidiaries operate in EUR? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0003_consolidation.xlsx 4 What is the total local amount for 6000-Opex? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0003_consolidation.xlsx 5 Using FX_Rates, what rate is listed for EUR on 2024-06-30? Hard success_full_coverage row 1 1 — 0 0 0
dense frtr_0004_payroll-summary.xlsx 1 What is total base pay for Engineering? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0004_payroll-summary.xlsx 3 What is the sum of Q1 (Jan–Mar) base pay? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0004_payroll-summary.xlsx 4 How much employer contribution to 401k is recorded? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0004_payroll-summary.xlsx 5 Does Sales total compensation exceed Engineering by at least... Hard workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0005_ap-vendor-spend.xlsx 1 What is total invoice spend for Logistics? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0005_ap-vendor-spend.xlsx 3 What is the open (unpaid) amount for Marketing? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0005_ap-vendor-spend.xlsx 5 For tier A vendors, what is the count of unique vendors? Hard success_full_coverage row 1 1 — 0 0 0
dense frtr_0006_manufacturing-ops.xl... 2 What is total good quantity at WC-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0006_manufacturing-ops.xl... 3 What is the estimated standard cost at WC-010? Medium workbook_hit_sheet_miss — 9 — — 0 0 0
dense frtr_0006_manufacturing-ops.xl... 4 What is the overall scrap rate (QtyScrap / QtyGood)? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0007_ecommerce-metrics.xl... 2 What is the conversion rate for Paid Search? Medium workbook_miss — — — — 0 0 0
dense frtr_0007_ecommerce-metrics.xl... 3 How many sessions occurred in total across all channels? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0007_ecommerce-metrics.xl... 5 What is total email volume sent? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0008_cashflow-consolidati... 1 What is the net cash flow for SUB-01? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0008_cashflow-consolidati... 3 What is the total operating cash flow across all subsidiarie... Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0008_cashflow-consolidati... 5 Which Currency has the largest RatetoUSD Easy success_full_coverage row — 13 — 0 0 0
dense frtr_0009_healthcare-claims.xl... 2 What are the total charges for Medicare? Medium success_full_coverage row 1 1 3 0 0 0
dense frtr_0009_healthcare-claims.xl... 3 What is the total of payments across all payers? Easy success_full_coverage window 1 1 8 0 0 0
dense frtr_0009_healthcare-claims.xl... 5 How many payments rows are recorded? Easy workbook_miss — — — — 0 0 0
dense frtr_0010_energy-production.xl... 2 What are total MWh for PLANT-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0010_energy-production.xl... 3 What is the average capacity (MW) for PLANT-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0010_energy-production.xl... 5 What is the total outage hours across all plants? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0011_gov-grants-tracking.... 2 What is the total awarded USD for EPA? Medium success_full_coverage row 1 44 — 0 0 0
dense frtr_0011_gov-grants-tracking.... 3 What is the overall win rate across all agencies? Hard success_full_coverage row 1 1 15 0 0 0
dense frtr_0011_gov-grants-tracking.... 5 What is the total requested amount across all agencies? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0012_nonprofit-donations.... 2 What is the total gifts USD for campaign CMP-001? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0012_nonprofit-donations.... 3 What are total pledges across the listed campaigns? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0012_nonprofit-donations.... 5 What is the combined gifts + pledges total for CMP-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0013_education-outcomes.x... 2 What is the pass rate for Science (from data)? Medium success_full_coverage window 1 1 — 0 0 0
dense frtr_0013_education-outcomes.x... 3 What is the overall average attendance (DaysTotal-DaysAbsent... Medium success_full_coverage window 1 1 — 0 0 0
dense frtr_0013_education-outcomes.x... 5 How many enrollments are recorded in 2025-Fall? Easy success_full_coverage row 1 1 — 0 0 0
dense frtr_0014_retail-pos.xlsx 2 What are total units for STORE-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0014_retail-pos.xlsx 3 What is the estimated gross margin for STORE-010? Medium success_full_coverage window 1 1 1 0 0 0
dense frtr_0014_retail-pos.xlsx 5 What is total revenue across all stores? Easy success_full_coverage row 1 1 40 0 0 0
dense frtr_0015_telecom-churn.xlsx 2 How many Plus subscribers are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0015_telecom-churn.xlsx 3 What is ARPU for Pro plan? Medium workbook_miss — — — — 0 0 0
dense frtr_0015_telecom-churn.xlsx 5 What is overall churn rate? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0016_airline-ops.xlsx 2 How many flights operated on RT-0001? Easy success_full_coverage row 1 1 — 0 0 0
dense frtr_0016_airline-ops.xlsx 4 What is total passengers across the 60 summarized routes? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0016_airline-ops.xlsx 5 What is average arrival delay on RT-0025? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0017_realestate-portfolio... 2 How many Industrial properties are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0017_realestate-portfolio... 3 What is the average rent across all leases? Medium success_full_coverage window 1 7 — 0 0 0
dense frtr_0017_realestate-portfolio... 5 What is total acquisition cost across all types? Medium workbook_miss — — — — 0 0 0
dense frtr_0018_hospitality-bookings... 2 How many rooms sold via OTA? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0018_hospitality-bookings... 3 What is RevPAR overall (approx.)? Medium workbook_miss — — — — 0 0 0
dense frtr_0018_hospitality-bookings... 5 What is total revenue across all channels? Easy success_full_coverage row 8 1 4 0 0 0
dense frtr_0019_agriculture-yield.xl... 2 What is average yield for Corn? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0019_agriculture-yield.xl... 3 What are total input costs recorded for Soy? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0019_agriculture-yield.xl... 5 What is overall average yield across all crops? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0020_pharma-trials.xlsx 2 How many enrollments at SITE-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0020_pharma-trials.xlsx 3 What is the average ALT for SITE-010 patients? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0021_insurance-claims.xls... 2 What is average paid for Auto claims? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0021_insurance-claims.xls... 3 What is the total paid across all LOBs? Easy success_full_coverage row 1 1 7 0 0 0
dense frtr_0021_insurance-claims.xls... 5 How many claims are recorded? Easy sheet_hit_range_miss — 1 — — 0 0 0
dense frtr_0022_logistics-routing.xl... 2 How many shipments for CAR-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0022_logistics-routing.xl... 3 What is the average cost for CAR-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0022_logistics-routing.xl... 5 What is overall on-time rate? Medium success_full_coverage window — 15 — 0 0 0
dense frtr_0023_media-streaming.xlsx 2 How many views for title TIT-00001? Easy success_full_coverage row 1 1 — 0 0 0
dense frtr_0023_media-streaming.xlsx 3 What is the average minutes watched for TIT-00010? Medium success_full_coverage row 1 2 — 0 0 0
dense frtr_0023_media-streaming.xlsx 5 What is the overall buffering event rate per session? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0024_cybersecurity-incide... 2 How many incidents were handled by SOC-EMEA? Easy success_full_coverage row 1 1 2 0 0 0
dense frtr_0024_cybersecurity-incide... 3 What is the average MTTR for SOC-West? Medium success_full_coverage row 1 1 — 0 0 0
dense frtr_0024_cybersecurity-incide... 5 What is overall average MTTR? Medium workbook_miss — — — — 0 0 0
dense frtr_0025_construction-control... 1 For PRJ-00001, what are actuals to date? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0025_construction-control... 2 What is the budget for PRJ-00010? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0025_construction-control... 3 What is the variance (Budget - Actuals) for PRJ-00010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0026_consolidation-multi-... 1 Consolidated USD Revenue in May 2024? Hard partial_range_hit row 1 1 — 0 0 0
dense frtr_0026_consolidation-multi-... 3 Ratio of USD Expense to USD Revenue in Sep 2024? Medium workbook_miss — — — — 0 0 0
dense frtr_0026_consolidation-multi-... 4 Which subs most frequently post expenses? Medium workbook_miss — — — — 0 0 0
dense frtr_0026_consolidation-multi-... 5 Effect of stronger EURUSD on June 2024 revenue? Hard no_range_gold — 1 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 1 What is the total revenue shown in the Summary (Data_Main)? Easy success_full_coverage column 39 1 1 0 0 0
dense frtr_0028_payroll-analysis.xls... 3 Find revenue for SKU listed at Data_Main!C10. Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 4 What is the average margin % across all rows (Data_Main)? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 5 Estimate total revenue from ExpandedData (if calculated). Hardest workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 6 Using XLOOKUP, retrieve Units from Data_Main for SKU in C20. Hard no_range_gold — 3 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 7 What is the first date in ExpandedData? Hardest sheet_hit_range_miss — 1 — — 0 0 0
dense frtr_0028_payroll-analysis.xls... 8 What is the last populated row count in ExpandedData (exclud... Hard workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0029_customer-analytics.x... 1 Revenue in March 2024 for cohort 2023-01? Medium partial_range_hit window 1 1 — 0 0 0
dense frtr_0029_customer-analytics.x... 3 ARPU for 2023-06 cohort in July 2024? Medium success_full_coverage window 1 2 4 0 0 0
dense frtr_0029_customer-analytics.x... 4 Which region contributes most revenue in Q4 2024? Hard workbook_miss — — — — 0 0 0
dense frtr_0029_customer-analytics.x... 5 Retention rate of 2022-11 cohort in Jan 2024? Medium success_full_coverage row 28 28 — 0 0 0
dense frtr_0030_capex-project-portfo... 1 Total CapEx spend for Manufacturing in March 2024? Medium partial_range_hit row 1 1 — 0 0 0
dense frtr_0030_capex-project-portfo... 2 What is the trend for Monthly Portfolio Spend in the Chart Medium no_range_gold — 1 — — 0 0 0
dense frtr_0030_capex-project-portfo... 3 Active projects for Healthcare in July 2024? Medium partial_range_hit window 1 1 — 0 0 0
dense frtr_0030_capex-project-portfo... 4 Utilization for Tech in Q4 2024? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0030_capex-project-portfo... 5 Which BusinessUnit is underutilizing budget most in 2024? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
dense frtr_0030_capex-project-portfo... 6 What is the Budget for Project with Name Project 67 Easy no_range_gold — 1 — — 0 0 0
dense frtr_0030_capex-project-portfo... 7 What is the total spend for Vendor 406 Medium no_range_gold — — — — 0 0 0
bm25 frtr_0001_quarterly-summary.xl... 1 What is total revenue in Q2 2024? Easy partial_range_hit row 1 6 6 0 0 0
bm25 frtr_0001_quarterly-summary.xl... 3 What is the gross margin percentage in Q3 2024? Easy success_full_coverage row 1 2 2 0 0 0
bm25 frtr_0001_quarterly-summary.xl... 4 What is total expenses in Q1 2024? Easy success_full_coverage row 1 6 6 0 0 0
bm25 frtr_0001_quarterly-summary.xl... 6 Which region appears most frequently in revenue records? Hard workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_00027_supply-chain-region... 1 On-time rate for West region in March 2024? Medium success_full_coverage row 3 3 — 0 0 0
bm25 frtr_00027_supply-chain-region... 3 Average cost per shipment for Midwest in September 2023? Medium success_full_coverage row 7 16 — 0 0 0
bm25 frtr_00027_supply-chain-region... 4 How many shipments from Northeast hubs in January 2024? Easy sheet_hit_range_miss — 3 — — 0 0 0
bm25 frtr_00027_supply-chain-region... 5 Region with highest variability in 2024 AvgCost? Hard success_full_coverage row 1 1 — 0 0 0
bm25 frtr_0002_ops-inventory.xlsx 2 What is the net movement quantity for SKU SKU-00103? Easy workbook_hit_sheet_miss — 21 — — 0 0 0
bm25 frtr_0002_ops-inventory.xlsx 3 What average unit cost is reported for SKU SKU-00106? Easy workbook_miss — — — — 0 0 0
bm25 frtr_0002_ops-inventory.xlsx 4 Identify the VendorName for SKU SKU-00115 using XLOOKUP. Easy success_full_coverage window 1 1 1 0 0 0
bm25 frtr_0002_ops-inventory.xlsx 6 Is there a stockout risk (>30%) for any SKU in the table? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0002_ops-inventory.xlsx 7 What’s the total PO quantity for SKU SKU-00121 (from Purchas... Medium success_full_coverage row 6 6 6 0 0 0
bm25 frtr_0003_consolidation.xlsx 1 What is the consolidated total local amount for account 4000... Medium sheet_hit_range_miss — 3 — — 0 0 0
bm25 frtr_0003_consolidation.xlsx 3 How many subsidiaries operate in EUR? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0003_consolidation.xlsx 4 What is the total local amount for 6000-Opex? Medium workbook_hit_sheet_miss — 9 — — 0 0 0
bm25 frtr_0003_consolidation.xlsx 5 Using FX_Rates, what rate is listed for EUR on 2024-06-30? Hard success_full_coverage row 1 1 — 0 0 0
bm25 frtr_0004_payroll-summary.xlsx 1 What is total base pay for Engineering? Easy sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0004_payroll-summary.xlsx 3 What is the sum of Q1 (Jan–Mar) base pay? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0004_payroll-summary.xlsx 4 How much employer contribution to 401k is recorded? Medium success_full_coverage column 1 1 — 0 0 0
bm25 frtr_0004_payroll-summary.xlsx 5 Does Sales total compensation exceed Engineering by at least... Hard sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0005_ap-vendor-spend.xlsx 1 What is total invoice spend for Logistics? Easy workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0005_ap-vendor-spend.xlsx 3 What is the open (unpaid) amount for Marketing? Medium workbook_hit_sheet_miss — 4 — — 0 0 0
bm25 frtr_0005_ap-vendor-spend.xlsx 5 For tier A vendors, what is the count of unique vendors? Hard workbook_miss — — — — 0 0 0
bm25 frtr_0006_manufacturing-ops.xl... 2 What is total good quantity at WC-001? Easy sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0006_manufacturing-ops.xl... 3 What is the estimated standard cost at WC-010? Medium workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0006_manufacturing-ops.xl... 4 What is the overall scrap rate (QtyScrap / QtyGood)? Medium sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0007_ecommerce-metrics.xl... 2 What is the conversion rate for Paid Search? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0007_ecommerce-metrics.xl... 3 How many sessions occurred in total across all channels? Easy workbook_miss — — — — 0 0 0
bm25 frtr_0007_ecommerce-metrics.xl... 5 What is total email volume sent? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0008_cashflow-consolidati... 1 What is the net cash flow for SUB-01? Easy success_full_coverage row 1 8 8 0 0 0
bm25 frtr_0008_cashflow-consolidati... 3 What is the total operating cash flow across all subsidiarie... Medium success_full_coverage row 1 12 24 0 0 0
bm25 frtr_0008_cashflow-consolidati... 5 Which Currency has the largest RatetoUSD Easy success_full_coverage sheet 2 2 2 0 0 0
bm25 frtr_0009_healthcare-claims.xl... 2 What are the total charges for Medicare? Medium success_full_coverage sheet 1 10 10 0 0 0
bm25 frtr_0009_healthcare-claims.xl... 3 What is the total of payments across all payers? Easy workbook_miss — — — — 0 0 0
bm25 frtr_0009_healthcare-claims.xl... 5 How many payments rows are recorded? Easy success_full_coverage row — 3 — 0 0 0
bm25 frtr_0010_energy-production.xl... 2 What are total MWh for PLANT-001? Easy workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0010_energy-production.xl... 3 What is the average capacity (MW) for PLANT-010? Medium workbook_hit_sheet_miss — 20 — — 0 0 0
bm25 frtr_0010_energy-production.xl... 5 What is the total outage hours across all plants? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0011_gov-grants-tracking.... 2 What is the total awarded USD for EPA? Medium workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0011_gov-grants-tracking.... 3 What is the overall win rate across all agencies? Hard workbook_miss — — — — 0 0 0
bm25 frtr_0011_gov-grants-tracking.... 5 What is the total requested amount across all agencies? Easy workbook_miss — — — — 0 0 0
bm25 frtr_0012_nonprofit-donations.... 2 What is the total gifts USD for campaign CMP-001? Medium workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0012_nonprofit-donations.... 3 What are total pledges across the listed campaigns? Easy workbook_miss — — — — 0 0 0
bm25 frtr_0012_nonprofit-donations.... 5 What is the combined gifts + pledges total for CMP-010? Medium workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0013_education-outcomes.x... 2 What is the pass rate for Science (from data)? Medium success_full_coverage column 2 2 — 0 0 0
bm25 frtr_0013_education-outcomes.x... 3 What is the overall average attendance (DaysTotal-DaysAbsent... Medium success_full_coverage window 1 1 — 0 0 0
bm25 frtr_0013_education-outcomes.x... 5 How many enrollments are recorded in 2025-Fall? Easy success_full_coverage column 1 2 2 0 0 0
bm25 frtr_0014_retail-pos.xlsx 2 What are total units for STORE-001? Easy workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0014_retail-pos.xlsx 3 What is the estimated gross margin for STORE-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0014_retail-pos.xlsx 5 What is total revenue across all stores? Easy sheet_hit_range_miss — 9 — — 0 0 0
bm25 frtr_0015_telecom-churn.xlsx 2 How many Plus subscribers are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0015_telecom-churn.xlsx 3 What is ARPU for Pro plan? Medium success_full_coverage row 1 4 — 0 0 0
bm25 frtr_0015_telecom-churn.xlsx 5 What is overall churn rate? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0016_airline-ops.xlsx 2 How many flights operated on RT-0001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0016_airline-ops.xlsx 4 What is total passengers across the 60 summarized routes? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0016_airline-ops.xlsx 5 What is average arrival delay on RT-0025? Medium sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0017_realestate-portfolio... 2 How many Industrial properties are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0017_realestate-portfolio... 3 What is the average rent across all leases? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0017_realestate-portfolio... 5 What is total acquisition cost across all types? Medium sheet_hit_range_miss — 7 — — 0 0 0
bm25 frtr_0018_hospitality-bookings... 2 How many rooms sold via OTA? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0018_hospitality-bookings... 3 What is RevPAR overall (approx.)? Medium partial_range_hit window 3 4 11 0 0 0
bm25 frtr_0018_hospitality-bookings... 5 What is total revenue across all channels? Easy sheet_hit_range_miss — 7 — — 0 0 0
bm25 frtr_0019_agriculture-yield.xl... 2 What is average yield for Corn? Easy workbook_hit_sheet_miss — 4 — — 0 0 0
bm25 frtr_0019_agriculture-yield.xl... 3 What are total input costs recorded for Soy? Medium workbook_hit_sheet_miss — 7 — — 0 0 0
bm25 frtr_0019_agriculture-yield.xl... 5 What is overall average yield across all crops? Medium sheet_hit_range_miss — 19 — — 0 0 0
bm25 frtr_0020_pharma-trials.xlsx 2 How many enrollments at SITE-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0020_pharma-trials.xlsx 3 What is the average ALT for SITE-010 patients? Medium workbook_hit_sheet_miss — 17 — — 0 0 0
bm25 frtr_0021_insurance-claims.xls... 2 What is average paid for Auto claims? Medium workbook_hit_sheet_miss — 3 — — 0 0 0
bm25 frtr_0021_insurance-claims.xls... 3 What is the total paid across all LOBs? Easy sheet_hit_range_miss — 7 — — 0 0 0
bm25 frtr_0021_insurance-claims.xls... 5 How many claims are recorded? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0022_logistics-routing.xl... 2 How many shipments for CAR-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0022_logistics-routing.xl... 3 What is the average cost for CAR-010? Medium sheet_hit_range_miss — 5 — — 0 0 0
bm25 frtr_0022_logistics-routing.xl... 5 What is overall on-time rate? Medium workbook_hit_sheet_miss — 5 — — 0 0 0
bm25 frtr_0023_media-streaming.xlsx 2 How many views for title TIT-00001? Easy success_full_coverage row 1 1 — 0 0 0
bm25 frtr_0023_media-streaming.xlsx 3 What is the average minutes watched for TIT-00010? Medium sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0023_media-streaming.xlsx 5 What is the overall buffering event rate per session? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0024_cybersecurity-incide... 2 How many incidents were handled by SOC-EMEA? Easy sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0024_cybersecurity-incide... 3 What is the average MTTR for SOC-West? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0024_cybersecurity-incide... 5 What is overall average MTTR? Medium success_full_coverage window 3 3 — 0 0 0
bm25 frtr_0025_construction-control... 1 For PRJ-00001, what are actuals to date? Easy sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0025_construction-control... 2 What is the budget for PRJ-00010? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0025_construction-control... 3 What is the variance (Budget - Actuals) for PRJ-00010? Medium sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0026_consolidation-multi-... 1 Consolidated USD Revenue in May 2024? Hard partial_range_hit row 1 1 — 0 0 0
bm25 frtr_0026_consolidation-multi-... 3 Ratio of USD Expense to USD Revenue in Sep 2024? Medium success_full_coverage row 7 21 — 0 0 0
bm25 frtr_0026_consolidation-multi-... 4 Which subs most frequently post expenses? Medium workbook_miss — — — — 0 0 0
bm25 frtr_0026_consolidation-multi-... 5 Effect of stronger EURUSD on June 2024 revenue? Hard no_range_gold — 7 — — 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 1 What is the total revenue shown in the Summary (Data_Main)? Easy success_full_coverage column 1 3 3 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 3 Find revenue for SKU listed at Data_Main!C10. Medium sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 4 What is the average margin % across all rows (Data_Main)? Medium success_full_coverage sheet 1 1 1 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 5 Estimate total revenue from ExpandedData (if calculated). Hardest sheet_hit_range_miss — 1 — — 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 6 Using XLOOKUP, retrieve Units from Data_Main for SKU in C20. Hard no_range_gold — 1 — — 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 7 What is the first date in ExpandedData? Hardest workbook_miss — — — — 0 0 0
bm25 frtr_0028_payroll-analysis.xls... 8 What is the last populated row count in ExpandedData (exclud... Hard workbook_hit_sheet_miss — 44 — — 0 0 0
bm25 frtr_0029_customer-analytics.x... 1 Revenue in March 2024 for cohort 2023-01? Medium partial_range_hit row 1 1 — 0 0 0
bm25 frtr_0029_customer-analytics.x... 3 ARPU for 2023-06 cohort in July 2024? Medium success_full_coverage row 1 1 — 0 0 0
bm25 frtr_0029_customer-analytics.x... 4 Which region contributes most revenue in Q4 2024? Hard workbook_hit_sheet_miss — 13 — — 0 0 0
bm25 frtr_0029_customer-analytics.x... 5 Retention rate of 2022-11 cohort in Jan 2024? Medium sheet_hit_range_miss — 7 — — 0 0 0
bm25 frtr_0030_capex-project-portfo... 1 Total CapEx spend for Manufacturing in March 2024? Medium partial_range_hit column 38 38 — 0 0 0
bm25 frtr_0030_capex-project-portfo... 2 What is the trend for Monthly Portfolio Spend in the Chart Medium no_range_gold — 19 — — 0 0 0
bm25 frtr_0030_capex-project-portfo... 3 Active projects for Healthcare in July 2024? Medium partial_range_hit window 1 1 — 0 0 0
bm25 frtr_0030_capex-project-portfo... 4 Utilization for Tech in Q4 2024? Hard success_full_coverage row 3 3 — 0 0 0
bm25 frtr_0030_capex-project-portfo... 5 Which BusinessUnit is underutilizing budget most in 2024? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
bm25 frtr_0030_capex-project-portfo... 6 What is the Budget for Project with Name Project 67 Easy no_range_gold — 1 — — 0 0 0
bm25 frtr_0030_capex-project-portfo... 7 What is the total spend for Vendor 406 Medium no_range_gold — 7 — — 0 0 0
hybrid frtr_0001_quarterly-summary.xl... 1 What is total revenue in Q2 2024? Easy success_full_coverage row 1 1 1 0 0 0
hybrid frtr_0001_quarterly-summary.xl... 3 What is the gross margin percentage in Q3 2024? Easy success_full_coverage row 1 1 1 0 0 0
hybrid frtr_0001_quarterly-summary.xl... 4 What is total expenses in Q1 2024? Easy success_full_coverage row 1 1 1 0 0 0
hybrid frtr_0001_quarterly-summary.xl... 6 Which region appears most frequently in revenue records? Hard success_full_coverage window 3 3 — 0 0 0
hybrid frtr_00027_supply-chain-region... 1 On-time rate for West region in March 2024? Medium success_full_coverage row 6 6 — 0 0 0
hybrid frtr_00027_supply-chain-region... 3 Average cost per shipment for Midwest in September 2023? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_00027_supply-chain-region... 4 How many shipments from Northeast hubs in January 2024? Easy sheet_hit_range_miss — 2 — — 0 0 0
hybrid frtr_00027_supply-chain-region... 5 Region with highest variability in 2024 AvgCost? Hard success_full_coverage row 2 2 — 0 0 0
hybrid frtr_0002_ops-inventory.xlsx 2 What is the net movement quantity for SKU SKU-00103? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0002_ops-inventory.xlsx 3 What average unit cost is reported for SKU SKU-00106? Easy partial_range_hit window 13 13 — 0 0 0
hybrid frtr_0002_ops-inventory.xlsx 4 Identify the VendorName for SKU SKU-00115 using XLOOKUP. Easy success_full_coverage window 1 2 2 0 0 0
hybrid frtr_0002_ops-inventory.xlsx 6 Is there a stockout risk (>30%) for any SKU in the table? Medium workbook_hit_sheet_miss — 2 — — 0 0 0
hybrid frtr_0002_ops-inventory.xlsx 7 What’s the total PO quantity for SKU SKU-00121 (from Purchas... Medium success_full_coverage row 1 11 11 0 0 0
hybrid frtr_0003_consolidation.xlsx 1 What is the consolidated total local amount for account 4000... Medium success_full_coverage row 2 2 2 0 0 0
hybrid frtr_0003_consolidation.xlsx 3 How many subsidiaries operate in EUR? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0003_consolidation.xlsx 4 What is the total local amount for 6000-Opex? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0003_consolidation.xlsx 5 Using FX_Rates, what rate is listed for EUR on 2024-06-30? Hard success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0004_payroll-summary.xlsx 1 What is total base pay for Engineering? Easy sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0004_payroll-summary.xlsx 3 What is the sum of Q1 (Jan–Mar) base pay? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0004_payroll-summary.xlsx 4 How much employer contribution to 401k is recorded? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0004_payroll-summary.xlsx 5 Does Sales total compensation exceed Engineering by at least... Hard sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0005_ap-vendor-spend.xlsx 1 What is total invoice spend for Logistics? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0005_ap-vendor-spend.xlsx 3 What is the open (unpaid) amount for Marketing? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0005_ap-vendor-spend.xlsx 5 For tier A vendors, what is the count of unique vendors? Hard success_full_coverage row 2 2 — 0 0 0
hybrid frtr_0006_manufacturing-ops.xl... 2 What is total good quantity at WC-001? Easy sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0006_manufacturing-ops.xl... 3 What is the estimated standard cost at WC-010? Medium workbook_hit_sheet_miss — 13 — — 0 0 0
hybrid frtr_0006_manufacturing-ops.xl... 4 What is the overall scrap rate (QtyScrap / QtyGood)? Medium sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0007_ecommerce-metrics.xl... 2 What is the conversion rate for Paid Search? Medium workbook_hit_sheet_miss — 2 — — 0 0 0
hybrid frtr_0007_ecommerce-metrics.xl... 3 How many sessions occurred in total across all channels? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0007_ecommerce-metrics.xl... 5 What is total email volume sent? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0008_cashflow-consolidati... 1 What is the net cash flow for SUB-01? Easy success_full_coverage row 1 21 21 0 0 0
hybrid frtr_0008_cashflow-consolidati... 3 What is the total operating cash flow across all subsidiarie... Medium success_full_coverage row 1 24 48 0 0 0
hybrid frtr_0008_cashflow-consolidati... 5 Which Currency has the largest RatetoUSD Easy success_full_coverage sheet 4 4 4 0 0 0
hybrid frtr_0009_healthcare-claims.xl... 2 What are the total charges for Medicare? Medium success_full_coverage sheet 1 1 1 0 0 0
hybrid frtr_0009_healthcare-claims.xl... 3 What is the total of payments across all payers? Easy success_full_coverage window 1 1 16 0 0 0
hybrid frtr_0009_healthcare-claims.xl... 5 How many payments rows are recorded? Easy success_full_coverage row — 5 — 0 0 0
hybrid frtr_0010_energy-production.xl... 2 What are total MWh for PLANT-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0010_energy-production.xl... 3 What is the average capacity (MW) for PLANT-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0010_energy-production.xl... 5 What is the total outage hours across all plants? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0011_gov-grants-tracking.... 2 What is the total awarded USD for EPA? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0011_gov-grants-tracking.... 3 What is the overall win rate across all agencies? Hard success_full_coverage row 1 1 30 0 0 0
hybrid frtr_0011_gov-grants-tracking.... 5 What is the total requested amount across all agencies? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0012_nonprofit-donations.... 2 What is the total gifts USD for campaign CMP-001? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0012_nonprofit-donations.... 3 What are total pledges across the listed campaigns? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0012_nonprofit-donations.... 5 What is the combined gifts + pledges total for CMP-010? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0013_education-outcomes.x... 2 What is the pass rate for Science (from data)? Medium success_full_coverage window 1 1 — 0 0 0
hybrid frtr_0013_education-outcomes.x... 3 What is the overall average attendance (DaysTotal-DaysAbsent... Medium success_full_coverage window 1 1 — 0 0 0
hybrid frtr_0013_education-outcomes.x... 5 How many enrollments are recorded in 2025-Fall? Easy success_full_coverage row 1 1 3 0 0 0
hybrid frtr_0014_retail-pos.xlsx 2 What are total units for STORE-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0014_retail-pos.xlsx 3 What is the estimated gross margin for STORE-010? Medium success_full_coverage window 1 1 1 0 0 0
hybrid frtr_0014_retail-pos.xlsx 5 What is total revenue across all stores? Easy success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0015_telecom-churn.xlsx 2 How many Plus subscribers are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0015_telecom-churn.xlsx 3 What is ARPU for Pro plan? Medium success_full_coverage row 1 8 — 0 0 0
hybrid frtr_0015_telecom-churn.xlsx 5 What is overall churn rate? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0016_airline-ops.xlsx 2 How many flights operated on RT-0001? Easy success_full_coverage row 1 21 — 0 0 0
hybrid frtr_0016_airline-ops.xlsx 4 What is total passengers across the 60 summarized routes? Medium success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0016_airline-ops.xlsx 5 What is average arrival delay on RT-0025? Medium sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0017_realestate-portfolio... 2 How many Industrial properties are there? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0017_realestate-portfolio... 3 What is the average rent across all leases? Medium success_full_coverage window 1 11 — 0 0 0
hybrid frtr_0017_realestate-portfolio... 5 What is total acquisition cost across all types? Medium sheet_hit_range_miss — 14 — — 0 0 0
hybrid frtr_0018_hospitality-bookings... 2 How many rooms sold via OTA? Medium success_full_coverage row 1 4 — 0 0 0
hybrid frtr_0018_hospitality-bookings... 3 What is RevPAR overall (approx.)? Medium partial_range_hit window 5 8 22 0 0 0
hybrid frtr_0018_hospitality-bookings... 5 What is total revenue across all channels? Easy success_full_coverage row 14 1 8 0 0 0
hybrid frtr_0019_agriculture-yield.xl... 2 What is average yield for Corn? Easy workbook_hit_sheet_miss — 2 — — 0 0 0
hybrid frtr_0019_agriculture-yield.xl... 3 What are total input costs recorded for Soy? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0019_agriculture-yield.xl... 5 What is overall average yield across all crops? Medium sheet_hit_range_miss — 2 — — 0 0 0
hybrid frtr_0020_pharma-trials.xlsx 2 How many enrollments at SITE-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0020_pharma-trials.xlsx 3 What is the average ALT for SITE-010 patients? Medium workbook_hit_sheet_miss — 2 — — 0 0 0
hybrid frtr_0021_insurance-claims.xls... 2 What is average paid for Auto claims? Medium workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0021_insurance-claims.xls... 3 What is the total paid across all LOBs? Easy success_full_coverage row 1 2 14 0 0 0
hybrid frtr_0021_insurance-claims.xls... 5 How many claims are recorded? Easy sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0022_logistics-routing.xl... 2 How many shipments for CAR-001? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0022_logistics-routing.xl... 3 What is the average cost for CAR-010? Medium sheet_hit_range_miss — 2 — — 0 0 0
hybrid frtr_0022_logistics-routing.xl... 5 What is overall on-time rate? Medium success_full_coverage window 10 30 — 0 0 0
hybrid frtr_0023_media-streaming.xlsx 2 How many views for title TIT-00001? Easy success_full_coverage row 1 1 — 0 0 0
hybrid frtr_0023_media-streaming.xlsx 3 What is the average minutes watched for TIT-00010? Medium success_full_coverage row 1 7 — 0 0 0
hybrid frtr_0023_media-streaming.xlsx 5 What is the overall buffering event rate per session? Medium workbook_hit_sheet_miss — 2 — — 0 0 0
hybrid frtr_0024_cybersecurity-incide... 2 How many incidents were handled by SOC-EMEA? Easy success_full_coverage row 1 4 6 0 0 0
hybrid frtr_0024_cybersecurity-incide... 3 What is the average MTTR for SOC-West? Medium success_full_coverage row 1 12 — 0 0 0
hybrid frtr_0024_cybersecurity-incide... 5 What is overall average MTTR? Medium success_full_coverage window 5 5 — 0 0 0
hybrid frtr_0025_construction-control... 1 For PRJ-00001, what are actuals to date? Easy sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0025_construction-control... 2 What is the budget for PRJ-00010? Easy workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0025_construction-control... 3 What is the variance (Budget - Actuals) for PRJ-00010? Medium sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0026_consolidation-multi-... 1 Consolidated USD Revenue in May 2024? Hard partial_range_hit row 1 1 — 0 0 0
hybrid frtr_0026_consolidation-multi-... 3 Ratio of USD Expense to USD Revenue in Sep 2024? Medium success_full_coverage row 13 41 — 0 0 0
hybrid frtr_0026_consolidation-multi-... 4 Which subs most frequently post expenses? Medium workbook_miss — — — — 0 0 0
hybrid frtr_0026_consolidation-multi-... 5 Effect of stronger EURUSD on June 2024 revenue? Hard no_range_gold — 1 — — 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 1 What is the total revenue shown in the Summary (Data_Main)? Easy success_full_coverage column 5 4 4 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 3 Find revenue for SKU listed at Data_Main!C10. Medium sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 4 What is the average margin % across all rows (Data_Main)? Medium success_full_coverage sheet 1 2 2 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 5 Estimate total revenue from ExpandedData (if calculated). Hardest sheet_hit_range_miss — 1 — — 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 6 Using XLOOKUP, retrieve Units from Data_Main for SKU in C20. Hard no_range_gold — 1 — — 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 7 What is the first date in ExpandedData? Hardest sheet_hit_range_miss — 2 — — 0 0 0
hybrid frtr_0028_payroll-analysis.xls... 8 What is the last populated row count in ExpandedData (exclud... Hard workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0029_customer-analytics.x... 1 Revenue in March 2024 for cohort 2023-01? Medium partial_range_hit row 1 1 — 0 0 0
hybrid frtr_0029_customer-analytics.x... 3 ARPU for 2023-06 cohort in July 2024? Medium success_full_coverage row 1 1 7 0 0 0
hybrid frtr_0029_customer-analytics.x... 4 Which region contributes most revenue in Q4 2024? Hard workbook_hit_sheet_miss — 26 — — 0 0 0
hybrid frtr_0029_customer-analytics.x... 5 Retention rate of 2022-11 cohort in Jan 2024? Medium sheet_hit_range_miss — 14 — — 0 0 0
hybrid frtr_0030_capex-project-portfo... 1 Total CapEx spend for Manufacturing in March 2024? Medium partial_range_hit row 1 1 — 0 0 0
hybrid frtr_0030_capex-project-portfo... 2 What is the trend for Monthly Portfolio Spend in the Chart Medium no_range_gold — 1 — — 0 0 0
hybrid frtr_0030_capex-project-portfo... 3 Active projects for Healthcare in July 2024? Medium partial_range_hit window 1 1 — 0 0 0
hybrid frtr_0030_capex-project-portfo... 4 Utilization for Tech in Q4 2024? Hard success_full_coverage row 1 6 — 0 0 0
hybrid frtr_0030_capex-project-portfo... 5 Which BusinessUnit is underutilizing budget most in 2024? Hard workbook_hit_sheet_miss — 1 — — 0 0 0
hybrid frtr_0030_capex-project-portfo... 6 What is the Budget for Project with Name Project 67 Easy no_range_gold — 1 — — 0 0 0
hybrid frtr_0030_capex-project-portfo... 7 What is the total spend for Vendor 406 Medium no_range_gold — 14 — — 0 0 0