So I put together a electrical load calculator in google sheets, I have some preset loads already installed, that can be chosen or you can add your own.
Expo-Technology Electrical Load Calculator
The actual loads are stored in their own sheets, which contain a index number, load and input for watts (120 Volt) and Amps (12 Volt). You can add directly at the sheet level if you like.
So you can the choose the load for your daily use, pick the load and the amps will populate for you. You can then choose how many hours or mins the load is used for a day. For the items that are on 24 hours, but have a duty cycle like a fridge you can use the hours to get the correct daily load. 50/50 duty cycle would mean the 12 hours can be used to calculate the daily power.
There is a area to add a load, it uses a script so you would need to be logged into google for it top work.
The layout is similar for 120 volt loads, I use watts for the major input, and the amps are calculated. There are a couple of inputs for using an inverter. You need to put in your inverter efficiency (usually 85% to 95%), also put the amperage in for your inverters search mode(power saving mode), or inverting mode. If you are leaving you inverter on in one of these modes all day or partially during the day, you can add in the hours for that. If you just turn the inverter on when using it, then this won't be needed.
Most of the data is used on the misc sheet, here we add the two load inputs to get your daily electrical load. If you want a battery large enough to cover multiple days you can change the days with out charge section. This input when used to calculate the size of the battery.
We take the daily electrical load to also try and calculate the needed solar panel bank. For this I use 4 watts for each amp used a day. If you want a slightly more accurate input based on time of year, you can go on to the solar calculator.
The daily electrical load is passed directly into the sheet, you will need to change the state data , and size of your solar panel. The calculated size is not input directly from the previous sheet.
Note¹ I did put in CPAP machine power rates I found on a web page, they do not include the optional heater and humidifier.
Note² To use the add new load buttons, you will need to be logged into a google account. Other than that you should have access to the rest of the spreadsheet.
As always, any input, questions, requests are encouraged.