excel-row-limit

Your mission

Split a run of rows into files that each hold at most the row limit.

today's brief

October 2020. Public Health England was moving lab results between systems in an old Excel format that stops at 65536 rows, and every file that filled up simply dropped whatever came next. 15841 positive cases vanished before anyone noticed. Those people were never called and their contacts were never traced. Split the rows into files that fit.

See it in action

split_batches(out, 10, 4)

Expected result

3: 4 4 2

Your checklist

For your own tracking. Tests grade your code.

total is the number of rows to move, 0 or more, and cap is the row limit of one file, 1 or more.
Fill out with the size of each file, taking cap rows at a time until nothing is left.
The last file holds whatever remains, and a file is never written empty.
Return how many files you wrote.

More examples

split_batches(out, 8, 4)

Expected result

2: 4 4

split_batches(out, 65537, 65536)

Expected result

2: 65536 1

Constraints

Expected files

batches.c

Allowed functions

None. Write every helper yourself.

Back to compete

Solutions

excel-row-limit

Your mission

Split a run of rows into files that each hold at most the row limit.

today's brief

See it in action

split_batches(out, 10, 4)

Expected result

3: 4 4 2

Your checklist

For your own tracking. Tests grade your code.

total is the number of rows to move, 0 or more, and cap is the row limit of one file, 1 or more.
Fill out with the size of each file, taking cap rows at a time until nothing is left.
The last file holds whatever remains, and a file is never written empty.
Return how many files you wrote.

More examples

split_batches(out, 8, 4)

Expected result

2: 4 4

split_batches(out, 65537, 65536)

Expected result

2: 65536 1

Constraints

Expected files

batches.c

Allowed functions

None. Write every helper yourself.

Back to compete

Solutions