On this page everything is explained how to configure and use the manual.xls Excelsheet. A sample manual.xls is supplied with the installation of jSunnyreports. You can find it in the same directory where you start jSunnyreports from.
Setup
First step is to copy the manual.xls file from the jSunnyreports directory to another location. For this tutorial the directory c:/inverter is used.
Inverters.conf
# ##### # 2 .xls: Manual entry ( using manual.xls ) # ##### # inverter.1.mandatory.invertername=SomeManualInverter inverter.1.mandatory.wattpeak=2000 inverter.1.mandatory.kwhkwp=1000 inverter.1.mandatory.invertertype=2 inverter.1.mandatory.inputdirectory=C:/inverter inverter.1.mandatory.barcolor=0,0,120 inverter.1.mandatory.linecolor=0,0,120 inverter.1.mandatory.fromdate=01-01-2015 inverter.1.optional.comparelinecolor=0,0,170 inverter.1.optional.correctionfactor=1.00 inverter.1.optional.inclination=45 inverter.1.optional.orientation=263 inverter.1.optional.tilldate=
Usage
Open the manual.xls file in the c:/inverter directory. The sheet contains two columns:
- A contains the date , this field is a date field.
- B contains the yield in kWh, this field is a numeric field.
In my case the date format used is dd-mm-yyyy but this may vary in your own situation.
Example
Hi, if you use the manual.xls file, you only use the total kWh per day? So no day graphs then I guess? I have a Goodwe inverter that’s connected to the Sems portal. Can you also change the xls file to have time and date and have the kWh production during the day? I guess the file would get very large quickly? How does that work with other inverters? Do you pull files from the inverter each day? I like jSunnyreports, and have it working except for the day graphs.
cheers,
Erik