Sorry, not getting it.
My thinking is if 247 kWh is
two days maximum
consumption, and you want
two days
reserve then you need 247 kWh of battery, then you need to buy 247 kWh of battery. An actual day could consume more as that number is an average, but if the load draws more than the maximum (e.g., an exceptionally hot day) then the generator needs to kick in. Although I think
@wattmatters' use case is like mine, all the hot days consume pretty much the same amount of power and there are no outliers (at least the seasonally hot days have the best insolation).
If you only want 1-day reserve, then it would be half of that, but he had two days marked in his spreadsheet. That seems a good number as LFP only has 2000 cycles (5.5 years) at 100% DoD (ss chart in OP).
There are other things you can do to minimize battery kWh that have been mentioned in the thread (e.g., oversize the array as even on gloomy days you'll get some power). The spreadsheet has an "oversize" for the solar costs, but to get it to reflect back to the battery calculation you'd need to move down the two-day maximum correspondingly (no idea how to calculate that).