Running into trouble with converting custom .EPW files to .MOS files.

[jmythms]

Hi,

I'm running into a The data at line 9 column 23 in .epw file is missing. You need to fix it before the convert. error when trying use ConvertWeatherData.jar to convert a custom .EPW file to a .MOS file.

The ConvertWeatherData.jar worked very well for TMY3 files, so I think it is something to do with my custom .EPW file. But I could not pinpoint where my issue is.

Line 9 column 23 corresponds to the "NOAA_ISD+MesoWest+NSRDB" word, and I have tried replacing it with text from a TMY3 file, but that did not help.
I have also tried rounding the floating points, and that did not help either.

Any help is appreciated.

First 30 lines of my custom .EPW file:

DESIGN CONDITIONS,1,Climate Design Data 2013 ASHRAE Handbook,,Heating,,,-14.0,,,,,,,,,11.5,,,,Cooling,,10.8,,,30.3,22.1,,,,,,,,,5.9,,,,,,,,21.2,,25.2,,,,,,,,Extremes,,,,,,,,,,,,,,,,
TYPICAL/EXTREME PERIODS,0
GROUND TEMPERATURES,0
HOLIDAYS/DAYLIGHT SAVINGS,NO,3/12,11/5,0
COMMENTS 1,
COMMENTS 2,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,, -- Ground temps produced with a standard soil diffusivity of 2.3225760E-03 {m**2/day}
DATA PERIODS,1,1,Data,Sunday, 1/ 1,12/31
2017,1,1,1,0,NOAA_ISD+MesoWest+NSRDB,-1.1,-6.7,62.31781884305313,101410.0,9999,9999,258.0824833876524,0.0,0.0,0.0,999999,999999,999999,9999,250.0,3.6,99,5.0,9999,99999,9,999999999,0.55,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,2,0,NOAA_ISD+MesoWest+NSRDB,-1.1,-6.3,63.968539509169815,101445.0,9999,9999,258.0824833876524,0.0,0.0,0.0,999999,999999,999999,9999,246.66666666666663,3.1,99,5.0,9999,99999,9,999999999,0.5505,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,3,0,NOAA_ISD+MesoWest+NSRDB,-2.8,-6.7,71.78968867987031,101590.0,9999,9999,250.1550101458696,0.0,0.0,0.0,999999,999999,999999,9999,250.0,2.6,99,5.0,9999,99999,9,999999999,0.5385,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,4,0,NOAA_ISD+MesoWest+NSRDB,-2.8,-6.7,71.78976134670401,101660.0,9999,9999,250.1550101458696,0.0,0.0,0.0,999999,999999,999999,9999,230.0,2.6,99,5.0,9999,99999,9,999999999,0.5285,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,5,0,NOAA_ISD+MesoWest+NSRDB,-3.6,-6.95,75.23342504983881,101655.0,9999,9999,246.4891746630791,0.0,0.0,0.0,999999,999999,999999,9999,210.0,2.6,99,5.0,9999,99999,9,999999999,0.5185,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,6,0,NOAA_ISD+MesoWest+NSRDB,-3.3,-6.7,74.86576923708918,101690.0,9999,9999,247.85904192956187,0.0,0.0,0.0,999999,999999,999999,9999,200.0,3.1,99,5.0,9999,99999,9,999999999,0.5095000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,7,0,NOAA_ISD+MesoWest+NSRDB,-4.4,-7.2,78.67720492776391,101790.0,9999,9999,242.86433229701998,0.0,0.0,0.0,999999,999999,999999,9999,190.0,3.6,99,5.0,9999,99999,9,999999999,0.513,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,8,0,NOAA_ISD+MesoWest+NSRDB,-3.85,-6.95,76.77158181924648,101840.0,9999,9999,245.352022868784,0.0,0.0,0.0,999999,999999,999999,9999,195.0,3.6,99,5.0,9999,99999,9,999999999,0.521,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,9,0,NOAA_ISD+MesoWest+NSRDB,-2.2,-5.6,75.04325731449708,101970.0,9999,9999,247.91820950871463,10.5,117.5,7.0,999999,999999,999999,9999,200.0,5.1,99,2.5,9999,99999,9,999999999,0.526,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,10,0,NOAA_ISD+MesoWest+NSRDB,-1.1,-5.0,72.08986893322721,102020.0,9999,9999,243.58894137579273,118.5,552.5,37.0,999999,999999,999999,9999,210.0,6.2,99,0.0,9999,99999,9,999999999,0.5295000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,11,0,NOAA_ISD+MesoWest+NSRDB,-0.2500000000000001,-5.0,67.59961833684991,102065.0,9999,9999,247.39702107211784,254.5,743.5,55.0,999999,999999,999999,9999,210.0,6.45,99,0.0,9999,99999,9,999999999,0.5325,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,12,0,NOAA_ISD+MesoWest+NSRDB,1.1,-5.0,60.88232157531522,102080.0,9999,9999,253.5380269273464,358.5,827.5,63.5,999999,999999,999999,9999,230.0,6.2,99,0.0,9999,99999,9,999999999,0.5405,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,13,0,NOAA_ISD+MesoWest+NSRDB,2.8,-5.0,53.94074551633995,102030.0,9999,9999,261.435323364937,414.0,863.0,67.5,999999,999999,999999,9999,240.0,4.1,99,0.0,9999,99999,9,999999999,0.5525,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,14,0,NOAA_ISD+MesoWest+NSRDB,3.05,-5.3,51.70627119869585,102015.0,9999,9999,262.6122891096756,414.0,858.0,68.5,999999,999999,999999,9999,235.0,4.6,99,0.0,9999,99999,9,999999999,0.5680000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,15,0,NOAA_ISD+MesoWest+NSRDB,3.3,-5.6,49.471837057848724,102020.0,9999,9999,263.7932823955109,359.0,824.5,63.5,999999,999999,999999,9999,190.0,3.1,99,0.0,9999,99999,9,999999999,0.5885,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,16,0,NOAA_ISD+MesoWest+NSRDB,3.9,-5.6,47.42983896765086,102100.0,9999,9999,266.6441557666373,256.0,740.0,55.0,999999,999999,999999,9999,190.0,3.6,99,0.0,9999,99999,9,999999999,0.6085,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,17,0,NOAA_ISD+MesoWest+NSRDB,3.35,-6.15,47.02978167290416,102130.0,9999,9999,264.0299651969577,120.5,544.0,38.0,999999,999999,999999,9999,195.0,3.1,99,0.0,9999,99999,9,999999999,0.6225,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,18,0,NOAA_ISD+MesoWest+NSRDB,1.7,-7.2,48.288060317409,102220.0,9999,9999,279.17943707130183,11.5,0.0,11.5,999999,999999,999999,9999,200.0,2.1,99,7.5,9999,99999,9,999999999,0.644,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,19,0,NOAA_ISD+MesoWest+NSRDB,1.1,-7.2,50.40568209296721,102290.0,9999,9999,268.62353952952344,0.0,0.0,0.0,999999,999999,999999,9999,203.3333333333333,0.0,99,5.0,9999,99999,9,999999999,0.6910000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,20,0,NOAA_ISD+MesoWest+NSRDB,0.55,-6.95,53.663150550621864,102310.0,9999,9999,265.9581301282547,0.0,0.0,0.0,999999,999999,999999,9999,126.66666666666669,0.0,99,5.0,9999,99999,9,999999999,0.7490000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,21,0,NOAA_ISD+MesoWest+NSRDB,-0.6,-5.6,65.72288281315802,102370.0,9999,9999,260.45004624745684,0.0,0.0,0.0,999999,999999,999999,9999,30.0,0.0,99,5.0,9999,99999,9,999999999,0.7695000000000001,0.9990000000000001,999,99,0.129,0.0,99
2017,1,1,22,0,NOAA_ISD+MesoWest+NSRDB,-1.1,-5.6,68.4924414534925,102350.0,9999,9999,258.0824833876524,0.0,0.0,0.0,999999,999999,999999,9999,40.0,0.0,99,5.0,9999,99999,9,999999999,0.7240000000000001,0.9990000000000001,999,99,0.129,0.0,99

[mwetter]

I suspect the reason is because your weather file has 6 lines before the hourly entries start, but 8 lines are expected, see https://github.com/lbl-srg/modelica-buildings/blob/master/Buildings/Resources/weatherdata/USA_CA_San.Francisco.Intl.AP.724940_TMY3.epw

[jmythms]

Ah, the mismatch in the number of lines in the header was a copy-paste mistake on my part.

Figured out the issue, it is the missing data in the 23rd (and 26th) column in the hourly entries. Everything works after replacing the missing value enumerations with non-missing values.

Thanks for responding!