PVSOL is generating correct pdf report but the values in excel file are not correct.

[Muhammad Idrees 0]

PV electric generation in pdf report is correct because I confirmed it by doing manual calculations. But the values in the excel file are not correct. Please guide me regarding this.

[developer_mh 82]

Hi Muhammad,

when importing or viewing the csv data in Excel, you should make sure that the decimal separator (point or comma) in Excel is set correctly.

1. Open the csv file that you exported from Excel with a text editor
2. Check which decimal separator is used
3. Open Excel (without having the csv file opened)
4. Go to File -> Options -> Advanced and set the decimal separator as found in the csv file
5. Then open the csv file in Excel

Hope that helps, kind regards,

Martin

[Muhammad Idrees 0]

I have done all of this before. I know how to convert the CSV data. But still the excel file is giving the wrong values.

Can you check by yourself, I have attached the files.

 

[Muhammad Idrees 0]

Here, I have also attached the converted CSV file. Kindly find the attachment. 

 

[developer_mh 82]

Hi again,

thanks for the files. What happened here is that both your list separator and your decimal separator are commata (,). This can't work. Try to set the decimal separator to a point (this is a Windows system setting) or set the list separator for the export in PV*SOL to a semi-colon (;), like so:

Hope that helps, kind regards,

Martin

[Muhammad Idrees 0]

Yes, this solved my problem. Thanks for your support and really appreciable work. 

PVSOL generates correct files, but the problem was a mismatch between the list separator in PVSOL and in my system settings.