Muhammad Idrees 0 Posted January 11 Report Share Posted January 11 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. Quote Link to post Share on other sites
developer_mh 81 Posted January 12 Report Share Posted January 12 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. Open the csv file that you exported from Excel with a text editor Check which decimal separator is used Open Excel (without having the csv file opened) Go to File -> Options -> Advanced and set the decimal separator as found in the csv file Then open the csv file in Excel Hope that helps, kind regards, Martin Quote Link to post Share on other sites
Muhammad Idrees 0 Posted January 12 Author Report Share Posted January 12 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. Quote Link to post Share on other sites
Muhammad Idrees 0 Posted January 12 Author Report Share Posted January 12 Here, I have also attached the converted CSV file. Kindly find the attachment. Quote Link to post Share on other sites
developer_mh 81 Posted January 12 Report Share Posted January 12 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 Quote Link to post Share on other sites
Muhammad Idrees 0 Posted January 12 Author Report Share Posted January 12 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. Quote Link to post Share on other sites
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.