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