Skip to content

Test Case 19-16 File 3: Answer file includes "TSOS REQ" rows when instruction specifies "TSCO REQ" #28

@sanjay920

Description

@sanjay920

Issue Summary

Test case 19-16 (Sheet-Level Manipulation - Row Filtering) has an annotation inconsistency in File 3 (3_19-16_input.xlsx / 3_19-16_answer.xlsx).

Details

Instruction (from dataset.json):

retains only the rows containing "TSCO REQ" in column H

Raw Data (3_19-16_input.xlsx, sheet "Raw Data"):

  • Column H contains both:
    • "TSCO REQ" (with C): 176 rows ✓
    • "TSOS REQ" (with S): 31 rows ✗

Answer File (3_19-16_answer.xlsx, sheet "Sheet1"):

  • Contains 178 data rows
  • Rows 177-178 include data from raw data rows with "TSOS REQ":
    • Answer row 177: B=201470803, C=PN414085 (from raw row 235, H="TSOS REQ")
    • Answer row 178: B=201470847, C=AM227394 (from raw row 236, H="TSOS REQ")

Expected Behavior

Since the instruction specifies filtering for "TSCO REQ" (exact string match), the answer should contain 176 rows, not 178.


Either:

  1. Update instruction to: "TSCO REQ" or "TSOS REQ" (if both should be included)
  2. Remove rows 177-178 from 3_19-16_answer.xlsx (if only TSCO REQ should be included)

Files 1 and 2 of this test case work correctly.

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type
    No fields configured for issues without a type.

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions