PVsyst's forum

Welcome on PVsyst's forum.
It is currently Mon Jan 18, 2021 6:07 am

All times are UTC+02:00




Post new topic  Reply to topic  [ 1 post ] 
Author Message
PostPosted: Fri Oct 02, 2020 9:41 am 

Joined: Fri Oct 02, 2020 9:00 am
Posts: 1
Hello,


Ive been having this problem in pvsyst output files.
The hourly data file in the .csv format contains numbers with dots, so far so usual. But excel recocnizes some of those numbers with dots that count as a comma, and some with dots that count as a european delimiter (as in 10.000 m).

This results in completely unrealistic values. 150.36 kW of electrical power inserted to the grid on a certain hour can be read as 150,3 kW or 150.360 kW

I tried to convert the .csv file into an usual .xls file
I also tried in excel: File < Options < advanced < Use delimiter character accordingly to OS language setting, but the problem keeps on occuring.

Is there a solution to this subject?


Sincerely,
Paul


Top
   
Display posts from previous:  Sort by  
Post new topic  Reply to topic  [ 1 post ] 

All times are UTC+02:00


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Search for:
Jump to:  
Powered by phpBB® Forum Software © phpBB Limited