Description
Generate synthetic grouped integer observations, plant one declared subtotal discrepancy and retain exact decimal-string subtotal, grand-total and checksum-row reconciliation answers.
CSV stores records as delimited text fields. Quoting can protect embedded delimiters and newlines, so a record need not equal one physical line. Cleaning field contents, interpreting their types, and preserving an exact import/export round trip are separate operations.
Generate synthetic grouped integer observations, plant one declared subtotal discrepancy and retain exact decimal-string subtotal, grand-total and checksum-row reconciliation answers.
When to use this tool
Use this generator to create reproducible csv aggregate reconciliation exercise cases from the supplied model or bank. Inspect the returned evidence before using cases in a test or exercise.
How to use the tool and how it works
- Supply groupCount, rowsPerGroup, minimumValue, maximumValue, discrepancy in the field shapes below. Set seed when you need an explicit replay.
- Run the tool and correct any input error. For generated controls, distinguish a successful fixture containing an invalid case from failure to generate the fixture.
- Read rows, subtotals, changedGroup, correctGrandTotal, reportedGrandTotal, answerCsv. Use the conventions below. Keep answer-bearing fields separate when presenting an exercise.
Draw integer rows in fixed-size groups, compute exact delegated subtotals, and alter one reported subtotal by discrepancy. Return correct and reported grand totals as exact decimal strings and an answer CSV with a checksum total row.1
Delegated operations used for this result: sum aggregate per numeric column; checksum total row appender. Their calculation or parsing conventions apply to the corresponding result fields.2, 3
| Input field | Meaning and units | Accepted input |
|---|---|---|
| groupCount | Group Count | Required. Safe integer; minimum 1; maximum 8. |
| rowsPerGroup | Rows Per Group | Required. Safe integer; minimum 1; maximum 8. |
| minimumValue | Minimum Value | Required. Safe integer. |
| maximumValue | Maximum Value | Required. Safe integer. |
| discrepancy | Discrepancy | Required. Safe integer. |
| seed | Optional numeric seed; takes precedence over context randomness. Without either, use the fixed tool.io default seed. | Optional. Safe integer. |
| Output field | Interpretation | Returned shape |
|---|---|---|
| rows | Rows | Required. Array of Object; no unknown keys.; minimum items 0; maximum items 64. |
| rows[].group | Group | Required. Text; maximum UTF-16 length 64. |
| rows[].value | Value | Required. Safe integer. |
| subtotals | Subtotals | Required. Array of Object; no unknown keys.; minimum items 0; maximum items 8. |
| subtotals[].group | Group | Required. Text; maximum UTF-16 length 64. |
| subtotals[].correct | Correct | Required. Text; maximum UTF-16 length 64. |
| subtotals[].reported | Reported | Required. Text; maximum UTF-16 length 64. |
| subtotals[].discrepancy | Discrepancy | Required. Text; maximum UTF-16 length 64. |
| changedGroup | Changed Group | Required. Safe integer; minimum 0; maximum 7. |
| correctGrandTotal | Correct Grand Total | Required. Text; maximum UTF-16 length 64. |
| reportedGrandTotal | Reported Grand Total | Required. Text; maximum UTF-16 length 64. |
| answerCsv | Answer Csv | Required. Text; maximum UTF-16 length 100000. |
| randomness | Replay source and normalized 32-bit seed, or null seed for an advancing context source. | Required. Object; no unknown keys. |
| randomness.seed | Optional safe-integer replay seed; normalization and precedence are explained below. | Required. Safe integer. or Null. |
| randomness.source | Source | Required. Text; one of "context", "seed". |
An explicit safe-integer seed takes precedence over injected context randomness and is normalized to an unsigned 32-bit integer. With no seed and no context source, replay uses the fixed tool.io default seed. A context source must return finite values from zero inclusive to one exclusive; its advancing state must be retained separately. randomness records the source and normalized seed, or null for context. These generators are not cryptographic random sources.
{
"input": {
"groupCount": 2,
"rowsPerGroup": 1,
"minimumValue": 1,
"maximumValue": 9,
"discrepancy": 2,
"seed": 42
},
"output": {
"rows": [
{
"group": "G1",
"value": 6
},
{
"group": "G2",
"value": 5
}
],
"subtotals": [
{
"group": "G1",
"correct": "6",
"reported": "6",
"discrepancy": "0"
},
{
"group": "G2",
"correct": "5",
"reported": "7",
"discrepancy": "2"
}
],
"changedGroup": 1,
"correctGrandTotal": "11",
"reportedGrandTotal": "13",
"answerCsv": "group,value\nG1,6\nG2,5\nGrand,11",
"randomness": {
"seed": 42,
"source": "seed"
}
}
}Limitations and assumptions
- changedGroup identifies the selected group even if discrepancy is zero. Numeric strings avoid loss of large aggregate precision. This constructs a reconciliation exercise rather than auditing actual accounts.
- A replay requires the same complete input and implementation. The stated sampling convention applies within its eligible space. A finite draw does not exhaust all possible outputs; repeats remain possible unless a distinct-selection rule is explicit.
- The field tables state structural bounds; cross-field constraints and bounded search or output budgets also apply. Unknown keys are rejected where the object contract disallows them. Input errors are distinct from null fields and deliberate invalid controls in a successful output.
Alternative or Complementary methods
For a supplied example, inspect the returned construction or delegated check directly. To evaluate a consumer, also test cases chosen for its own boundaries; a generated finite corpus does not establish exhaustive coverage.
References
Similar or alternative tools
- Random CSV Boolean Token Cleaning Exercise Generator
Sample caller-selected Boolean spellings, blank cells and unknown controls, retaining explicit classifications and nullable normalization answers from the Boolean token core.
- Random CSV Date Column Cleaning Exercise Generator
Spell supplied Gregorian ISO dates using sampled supported four-digit-year formats, retaining the declared ISO answer and every compatible detector interpretation for ambiguous slash dates.