Problem using the create climate file tool

[Matthew Smith]

I am having trouble creating a wac. file. When I click on the 'Export to .wac' macro icon in the Createclimatefile spreadsheet (version 1.4), I receive the message "Run-time error 13: Type mismatch" in a visual basic window.

My weather file seems compatible; I have 8760 lines of data in 9 columns (temperature,RH,wind direction/speed, global and diffuse radiation, cloud index, mean sea level pressure and rainfall), have rounded up some of the values to the same number of decimal places as on the demo films, converted 360 to 0 for wind direction, cleaned up the oktans so they only contain 0-8, and have had a fairly good look through to search for missing data. I have now run out of ideas. If you can think of anything I have missed, please help.

Yours,
Matt

[CR]

Hi Matt:
I was having similar problems trying to create a .wac weather file and getting the Run-time error 13.
I am also using WUFI 5.0, but version 1.5 of the spread.

Eventually I found I did have bad data in my pressure column. Once I cleaned up all the bad data I could create 9 columns.

For debugging I saved off the base spread with all the data in it.
Then I took copies of the whole spread and started deleting columns until I could create the .wac file. Eventually I narrowed down the problem to my pressure. I then took the pressure raw data and pasted it into a different spread and asked to sort it. I could then see I had bad data and did a more careful search.

Something like that might help you. I suspect there is still some bad data hiding somewhere in the over 8000 rows of data

CR

[Matthew Smith]

Dear CR,

You were right, thankyou. I did have a row with some bad data. I found it by opening the incomplete .wac file (from tools folder) on a spreadsheet, thereby finding the row number at which the file creation had broken down.

Yours,
Matt