Importing Climate Data into PVSol

[dongash 0]

Hi Martin,

I am not sure what I am doing wrong. I am having a challenge  uploading my last two (2) measured climate data files into PVSol. I have converted the files into .DAT  format, as per the instructions but I keep getting "Conversion failed, Formatting error" message  whenever I try to upload same into PVSol. 

I have attached the two (2) files for your kind review and support. Could you please convert them into .DAT file for me.  I am  using  PVSOl Premium 2019 (R10)

Thanks 

Dongash

MLow Values.xlsx MHigh Values.xlsx

[developer_mh 79]

Hi Dongash,

I guess it is line 3, as mentioned in our previous conversation, and the whitespace (space) right after the column name "Ta". Copy the values from your Excel sheet to a text file, remove the (invisible) tabs in line 3 and at the end of lines 1 and 2, remoe also the whitespace after Ta in line 4 (only the space, not the tab), then save as *.dat. That should work.

This doesn't import.

This works.

Hope that helps, kind regards,

Martin

[dongash 0]

Thank you. Problem solved.

Dongash

[Nasr 0]

weather.dat

I am getting this error

can you please fix this error

"Conversion failed, Formatting error" 

Diamond_Tyres-hour_modified.dat

[developer_mh 79]

Hello Nasr,

there are values missing at the end of the file. You should provide 8760 rows with values, one row for each hour of the year. So, including the header, the last line number of the file should be 8764.

Kind regards,

Martin

[Nasr 0]

Diamond_Tyres-hour.datsame issue with this file

[developer_mh 79]

Hallo again,

here the header seems to be the problem:

1. Remove the " from the second line
2. Replace the space between Ta and Gh and Gh and FF with a tab (\t)

Kind regards,

Martin

[Nasr 0]

1.which text editor you are using

2.can you please explain what do you mean by a tab between  Ta and Gh and Gh and FF

3. i tried this it doesn't worked for me i have also attached the screenshot and file.

4.can you please update the file and send it to me.

Diamond_Tyres-hour.dat

 

[developer_fw 4]

Hi Nasr,

1. In this case it is https://notepad-plus-plus.org/, a free editor which can show you "hidden characters" like SPACE, TAB, NEWLINE and so on. View > Show Symbol > ...

2. TAB is a special character https://en.wikipedia.org/wiki/Tab_key#Tab_characters

So in this case the \t is represented as string:

and here as character:

Best regards,
Frederik

Diamond_Tyres-hour_fixed.dat

[Nasr 0]

Thank you @developer_fw for the help.