Spreadsheet: 681075d1591345042-consecutive-count-that-resets-test
Sheet: Sheet1

Number | Number of days absent | Number of days present | 2020-05-01 00:00:00 | 2020-05-02 00:00:00 | 2020-05-03 00:00:00 | 2020-05-04 00:00:00 | 2020-05-05 00:00:00 | 2020-05-06 00:00:00 | 2020-05-07 00:00:00 | 2020-05-08 00:00:00 | 2020-05-09 00:00:00 | 2020-05-10 00:00:00 | 2020-05-11 00:00:00 | 2020-05-12 00:00:00 | 2020-05-13 00:00:00 | 2020-05-14 00:00:00 | 2020-05-15 00:00:00 | 2020-05-16 00:00:00 | 2020-05-17 00:00:00 | 2020-05-18 00:00:00 | 2020-05-19 00:00:00 | 2020-05-20 00:00:00 | 2020-05-21 00:00:00 | 2020-05-22 00:00:00 | 2020-05-23 00:00:00 | 2020-05-24 00:00:00 | 2020-05-25 00:00:00 | 2020-05-26 00:00:00 | 2020-05-27 00:00:00 | 2020-05-28 00:00:00 | 2020-05-29 00:00:00 | 2020-05-30 00:00:00 | 2020-05-31 00:00:00 | 2020-06-01 00:00:00 | 2020-06-02 00:00:00 | 2020-06-03 00:00:00 | 2020-06-04 00:00:00 | 2020-06-05 00:00:00 | 2020-06-06 00:00:00 | 2020-06-07 00:00:00 | 2020-06-08 00:00:00 | 2020-06-09 00:00:00 | 2020-06-10 00:00:00 | 2020-06-11 00:00:00 | 2020-06-12 00:00:00 | 2020-06-13 00:00:00 | 2020-06-14 00:00:00 | 2020-06-15 00:00:00 | 2020-06-16 00:00:00 | 2020-06-17 00:00:00 | 2020-06-18 00:00:00 | 2020-06-19 00:00:00 | 2020-06-20 00:00:00 | 2020-06-21 00:00:00 | 2020-06-22 00:00:00 | 2020-06-23 00:00:00 | 2020-06-24 00:00:00 | 2020-06-25 00:00:00 | 2020-06-26 00:00:00 | 2020-06-27 00:00:00 | 2020-06-28 00:00:00 | 2020-06-29 00:00:00 | 2020-06-30 00:00:00 | 2020-07-01 00:00:00 | 2020-07-02 00:00:00 | 2020-07-03 00:00:00 | 2020-07-04 00:00:00 | 2020-07-05 00:00:00 | 2020-07-06 00:00:00 | 2020-07-07 00:00:00 | 2020-07-08 00:00:00 | 2020-07-09 00:00:00 | 2020-07-10 00:00:00 | 2020-07-11 00:00:00 | 2020-07-12 00:00:00 | 2020-07-13 00:00:00 | 2020-07-14 00:00:00 | 2020-07-15 00:00:00 | 2020-07-16 00:00:00 | 2020-07-17 00:00:00 | 2020-07-18 00:00:00 | 2020-07-19 00:00:00 | 2020-07-20 00:00:00 | 2020-07-21 00:00:00 | 2020-07-22 00:00:00 | 2020-07-23 00:00:00 | 2020-07-24 00:00:00 | 2020-07-25 00:00:00 | 2020-07-26 00:00:00 | 2020-07-27 00:00:00 | 2020-07-28 00:00:00
454 | 0 | 84 | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
455 | 0 | 17 | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
456 | 0 | 85 | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
457 | 0 | 1 | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present
458 | 0 | 47 | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Absent | Absent | Absent | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
459 | 0 | 29 | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Absent | Absent | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
460 | 0 | 25 | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
461 | 0 | 3 |  | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present
462 | 0 | 86 |  | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
463 | 0 | 24 |  | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
464 | 0 | 16 |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
465 | 0 | 1 |  | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present
466 | 0 | 3 |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present
467 | 0 | 9 |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
468 | 0 | 78 |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
469 | 0 | 78 |  | Present | Present | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
470 | 0 | 87 |  |  | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
471 | 62 | 0 |  |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent
472 | 0 | 1 |  |  | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present
473 | 0 | 1 |  |  | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present
474 | 0 | 52 |  |  | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
475 | 0 | 14 |  |  | Present | Absent | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
476 | 0 | 83 |  |  | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present
477 | 1 | 0 |  |  | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Absent | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent
478 | 0 | 2 |  |  | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Absent | Absent | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present | Present | Present | Absent | Present | Present | Absent | Present | Present | Present | Present | Present | Present | Present | Present | Present | Absent | Absent | Absent | Present | Absent | Absent | Present | Present | Present | Present
479 | 0 | 87 |  |  | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present | Present