Richard's solar spreadsheet

    This spreadsheet was designed for my benefit so that I could choose the solar panel(s) that I would need to match the battery capacity in the Prado and the anticipated drawdowns by the fridge etc.

    I designed the spreadsheet to reflect what we typically do, that is, arrive at a camping site late in the afternoon with the battery "fully" charged by the car's alternator, and then spend one or more days camped.

    The spreadsheet contains calculations for both day and night periods as the power requirements are different for each and of course, there is no solar power generated at night.

    Power generated by the solar panels is used by the fridge etc with any surplus fed to the battery until the battery is 100% charged.

    The arithmetic in the spreadsheet is correct, but it relies on assumptions and these are up to the user. There is considerable flexibility to do “what if” type scenarios – ie change the panel size, number of sun hours, battery size etc. etc.

    Input assumptions are made in the cells formatted in yellow. The other cells are not protected from alteration and the calculations can be changed if desired. Some of the formulae are complex so as to allow for the green /orange/red formatting that indicates whether or not there is sufficient power available.

    I have seen claims that a car’s alternator will charge a battery anywhere between 70% and 100%. Choose your initial state of charge either by picking a figure between 70% (pessimistic) and 100% (optimistic) or measure the open circuit voltage of your battery after a decent drive and after allowing the battery to “rest” for several hours, ie nothing running off it. The table in the spreadsheet gives SOC for various voltages for wet standard/low maintenance and maintenance free/AGM/Gell batteries. This data is taken from William Darden's website 'Car and deep cycle battery answers to Frequently Asked Questions (FAQs)'  http://www.uuhome.de/william.darden/

    The solar panels are unlikely to operate at 100% efficiency due to eg, temperature, occasional shade, not directly facing the sun etc. The 70% figure I have in the spreadsheet was taken from a book on solar written by Collyn Rivers.  http://www.caravanandmotorhomebooks.com/ You may wish to change this figure.

    The figure for system losses is a pure guess, it can be set to zero if you wish.

    All loads (fridge, lights etc) are assumed to be at 12V and battery charging is assumed to be at 14V.

    The spreadsheet is provided “as is” and no responsibility will be accepted by myself for the use of this spreadsheet or for any outcomes that may arise by using the spreadsheet. User beware – it is a guide only!!!

    I would like to thank other members of the Campertrailers Group, especially Jeff Pethybridge, for their constructive criticism.

Richard's  Microsoft Excel spreadsheet 'Solar Power' can be downloaded here>>>>>   

Peak Solar Sun average low peak solar hours

Bureau of Meteorology average daily sunshine hours maps

Peak Solar Sun hours map & monthly chart

Richard Graylin

may 07