Tern Client Services: Statement of work deliverables with an allocation that does not add up
Statement of work deliverables with an allocation that does not add up for Tern Client Services. The same 9 rows as sow-deliverables.csv with one number changed: the SOW-2026-03 D2 allocation is 2150.00 instead of 2200.00. The three SOW-2026-03 allocations therefore sum to 3950.00 against the 4000.00 that every row of that group states as sow_not_to_exceed_usd, a shortfall of 50.00 USD. The other two statements of work still balance exactly.
csv
text/csv
- Document Set
- contracts
- Industry
- professional-services
- Source Kit
- crm-services
- Entity
- Tern Client Services
- Synthetic
- true
- As Of
- 2026-09-08
Binary csv: no in-browser preview. Download it above to open in a compatible application.
Specifications
- Document Set
- contracts
- Industry
- professional-services
- Source Kit
- crm-services
- Entity
- Tern Client Services
- Synthetic
- true
- As Of
- 2026-09-08
- Rows
- 9
- Mutated Row
- 9
- Mutated Column
- allocation_usd
- Shortfall
- 50.00
- Balanced Groups
- 2
- Unbalanced Groups
- 1
Testing contract
Expected to fail- Scenario
- Run the same group-and-sum check used on sow-deliverables.csv.
- Expected result
- SOW-2026-03 sums to 3950.00 against a stated not-to-exceed of 4000.00, a shortfall of 50.00 USD on row 9 of the file; SOW-2026-01 and SOW-2026-02 still balance, so a checker that only tests the grand total of 8950.00 against 9000.00 finds the same 50.00 but cannot say which group caused it.
What is a .csv file?
CSV (Comma-Separated Values) is a plain-text tabular format where rows are lines and fields are separated by commas, with quoting rules for values that contain delimiters, quotes, or newlines. It has no formal type system and depends on encoding and dialect conventions. It is the most portable format for tabular data exchange.
How to use this file
Use an example CSV to test parsers against quoting and embedded-delimiter edge cases, header handling, encoding detection, and import pipelines into databases or spreadsheets.
How to use this file for testing
“Tern Client Services: Statement of work deliverables with an allocation that does not add up” is a deterministic Novus Examples fixture for Data import, CSV parsing, Error handling. Realistic faker-generated datasets with documented schemas for testing import and ETL flows.
Documented properties for this file: 9 rows. Compare results against paired or grouped companions on this page when present (clean↔damaged, searchable↔scanned, or format twins) so scores stay reproducible across runs.
Download the file once, keep the path stable in CI or local scripts, and treat the spec table as the contract: dimensions, seeds, field lists, and roles are intentional. Corrupt or invalid samples are labelled as such, expect parsers to fail loudly rather than silently accept them.
Data fixtures document their exact quirks (delimiters, encodings, null handling, schema, and row counts) in the spec table. Point your parser or importer at the file and assert it handles the documented edge cases; clean and deliberately-messy siblings make before/after diffs straightforward.
Code examples
import pandas as pd
df = pd.read_csv("sow-deliverables-allocation-mismatch.csv")
print(df.head())
print(df.dtypes)Related files
- csvAlder Table Bistro: Allergen matrix missing a menu itemAllergen matrix missing a menu item for Alder Table Bistro. Intentionally incomplete. 3 rows where the recipes cost 4 menu items. MENU-04 (Potato gratin) has no row, although it has costed recipe lines in plate-costs.csv and sales in sales-mix-pmix.csv. Its correct row would declare: milk: Cream.
- csvAlder Table Bistro: Allergen menu missing a dish on the menuAllergen menu missing a dish on the menu for Alder Table Bistro. Intentionally incomplete. 3 rows where allergen-menu.csv has 4. MENU-02 Tomato soup is printed on printed-menu.pdf at 11.50 CAD and declares 1 allergen in the costing folder, and it has no row here. The remaining rows are correct.
- csvAlder Table Bistro: Cost of goods sold that contradicts the count sheetCost of goods sold that contradicts the count sheet for Alder Table Bistro. Intentionally inconsistent. Row 3 reports a closing count of 22.20 kg for ING-03 (Potatoes), the counted figure with the two decimal digits transposed, where inventory-count-sheet.csv, inventory-variance.xlsx and cogs-report.json all count 22.02 kg. Every derived value follows the wrong count, so the file is internally consistent and its total of 1574.49 CAD differs from the correct 1574.81 CAD by -0.32 CAD.
- csvAlder Table Bistro: Inventory count sheet as transcribedInventory count sheet as transcribed for Alder Table Bistro. The same closing counts as inventory-count-sheet.csv, in the shape a paper count actually arrives in. CRLF line endings, a UTF-8 byte order mark, a semicolon delimiter and a decimal comma. Two blank lines, one section banner that is not a record, one ingredient split across two locations, one counted as whole packs plus a remainder, one superseded mid-shift row at 14:20, trailing whitespace in three fields, a leading-zero bin code, an empty bin code, and one record carrying ten fields where the header declares 9. Every quirk is named in README.md.
- csvAlder Table Bistro: Overtime computed on the wrong week boundaryOvertime computed on the wrong week boundary for Alder Table Bistro. Intentionally inconsistent. The same 74 shift segments are grouped into Sunday-start work weeks where the declared policy, and labour-hours-overtime.xlsx, start each week on Monday. The correct grouping yields 5.00 payable overtime hours and 51.50 CAD of premium; this file yields 3.00 hours and 31.50 CAD. The hours that disappear belong to EMP-01 in the week beginning 2026-08-24, whose 46.00 hours the Sunday grouping splits across two weeks.
- csvAlder Table Bistro: Product mix carrying items the menu does not haveProduct mix carrying items the menu does not have for Alder Table Bistro. Intentionally inconsistent. 6 rows where sales-mix-pmix.csv has 4. MENU-90 and MENU-91 are not in the shared menu table, and the first row renames MENU-01 to "Roast chicken plate (lunch)", which has a doubled space and a suffix the menu does not carry. The remaining rows are correct.
Generated by generation/industry_documents_two.py. Free for any use, no attribution required, license.