Hallo gent's,
my approach to the load analysis is quite different, I started from an assumption:
I will not take off with battery not enough loaded considering that I will need to land without alternator charging or without battery ( failure ).
So ( FAR ) if my alternator gives up in flight I must have 30' of partial load to land safely. The battery does not have the nominal capacity ( age, temp, efficiency) the alternator suffer from temp and low RPM.... so I calculated how much time is neaded after start ( energy absorbed from starter ) to recharge my battery with a stated load. My spreadsheet is developed in time( so it is easy to avoid to consider to use the flap motor all the time you flight ) and efficiency and not only in load. ( for example remember that you need 14,2V to charge a battery , the current of a resistive load at 14V will not be the same as at nominal 12V, the battery will give you the 80% of the electrons charged at 12V or less ).
Here the link at my simplified spread sheet :
https://www.dropbox.com/s/bxdxwe301z...%3A18.xls?dl=0
It is written in Italian but I hope it will be easy to translate the few words.
Claudio