IME, the only way to do it is to measure loads as they turn on and then add the ones that will be together. Since all the loads you really want to measure are hard wired or wired with plugs too big for a kilawatt meter, this is not easy. Next best data is a neighbor keeps track of data.
The timing in the utility got me in the ball park, this got me as using almost 7 kW per hour, mostly two Air conditioners:
-one hour increments available to me, I did not know the duty cycle of the air conditioner so A 25% duty cycle meant 28 kW load, and a 50% duty cycle meant 14 kw, 100% duty cycle meant 7 kW.
-I did the calculation for the Running Load Amps, and it came out to 3kW. I totally forgot about the other circuit for the fan. That was power hungry.
-When I got my system installed, I could measure the one AC on the critical loads panel and it was 4.5 kW. I still have no idea how much AC 2 uses, but its bigger than AC1.
My utility provides 15 minute intervals of kWh usage. The most I’ve used in any 15 minute interval is about 2 kWh. Would that not be enough to calculate out to wattage output?
I would use that to start thinking A 10 kW inverter is needed if 2 kWh are expended in 15 minutes. There's more to it like moving all loads to run off battery. Also, what about the one time a year electric events if those will be covered like cooking two turkeys while the air fyer is going.
I really recommend you leave the oven and dryer off the critical loads panel. The extra electricity you generate should be used by those prior to the power company charging you for it, if needed those can be not used during an outage, and this will make the deign quite a bit easier. Turning both those items on could cost you 13.5 kW which ups the inverter requirement.