So you may have some cells not filled jet? Then I'm afraid you are ot of luck!

Imagine a case, you have a cotinous row of dates with all 3 rows having 1 entered, and somewhere in middle cells in row 24:25 in some column are unchecked. You have go back to first column with 1 in row 26, and then check the full path back until the column with empty cells to decide, do those belong to this or previous column. Add one checked column more, and you have a step more to calculate.

Probably you have to add 2 more rows - 2 meals from current day, a night, and 2 meals from next day. And in column you can have 3 1's altogether.