How do I know how many solar panels I need?
The solar panels need to be large enough to replace the Whrs used by the system. So if you use an average of 13000Wh/day, the panels need to produce an average of 13000Wh/day.
If every day was sunny and you get the full wattage every day, then you only need to divide the daily usage by the insolation number for your area.
(The Insolation number is the number of effective full hours of sun). Lets assume your insolation number is 5. The panels would need to be 13000/5 = 2600W.
However, the sound does not shine every day. Consequently, there has to be enough extra wattage to make up for lost generation on cloudy dayw.
So, if you get no power for a day and you want to make up for that in one day, then the panels have to be large enough to replace the daily usage *and* replace the energy from the previous cloudy day. (2600 x 2 = 5200W). However, if you are willing to accept it will take 2 days to make up for the lost day, then the panels only have to make up for 1/2 of the lost energy of the previous day. (2600 + 2600/2 = 3900W)
The spreadsheet assumes the batteries start from empty and must be recharged in the "Number of days to recharge while under load", So, the size of the batteries comes into play. If the batteries are 20KWh, it will take more to charge them to full than if the are 10KWH
NOTE: The spreadsheet assumes there will be zero production on cloudy days. This is perhaps overly conservative because there will be some amount of production.
Once the Wattage of the array is figured out, calculating the number of panels starts with a simple division. If you have 300W panels and need 6000W then 6000W/300W/Panel = 20. However, panels almost never produce at their rated wattage. Consequently, to be sure to hit the needed production, it should be assumed about 20% more panels are needed... so in this example, it would be 4 extra panels for a total of 24.
Note: As you saw with the fan, the actual usage of almost all devices is less than the actual usage. Sometimes by a lot. Consequently, the spreadsheet you have developed is probably indicating more usage than will actually happen. The way the spreadsheet works is that this gets amplified while calculating battery sizes and then amplified again when calculating the solar wattage needed. Unfortunately, I don't know of a good way to compensate for this other than actually measuring the usage of each device.
This does not mean the spreadsheet is useless. It gives you worst-case sizing and that is a very valuable thing to know. It also helps you understand where the big energy users are and that helps you make decisions around what you will use or not.
I have no idea how you get to 6000w
You might not be able to without getting into complex slide-out racks or hand-deployed ground panels. Unless you have an alternate source of power, this becomes the limiting factor of the system. Now comes the difficult task of scaling back the rest of the system accordingly.... but at least you go into the project with proper expectations.
Note: You mentioned that eventually the bus will be parked and not traveling. That makes the idea of ground-mount panels more practical.
One idea is to make a patio area just outside the bus with panels overhead providing shade.