This archive contains answers to questions sent to Unidata support through mid-2025. Note that the archive is no longer being updated. We provide the archive for reference; many of the answers presented here remain technically correct, even if somewhat outdated. For the most up-to-date information on the use of NSF Unidata software and data services, please consult the Software Documentation first.
> Hi Yuan, > > Thanks for fixing it! So re-download the IDV tomorrow night and it should > be good? > > Thanks, > Rebecca > Yes, only the nightly release. Yuan > address@hidden> wrote: > > > > Thank you for your work on this. I thought using the IDV tool was easier > > > than coding in the Terminal for me. Do you have a recommendation for > > > converting a large number of netcdf files directly into Excel files with > > > the same format that IDV gives?: > > > > > > > > > > Rebecca, > > This is a bug in the EXCEL output. I just checked in a fix and you > > can download tomorrow's nightly. > > > > > > Yuan > > > > > > Latitude > > > > > > Longitude > > > > > > Timestep > > > > > > Station 1 > > > > > > > > > > > > > > > > > > > > > > > > Station 2 > > > > > > > > > > > > > > > > > > > > > > > > I will be compiling all my data and using the temp and precip to compute > > > potential evapotranspiration and direct runoff in Excel. Any ideas you > > > might have would be greatly appreciated. > > > > > > Thank you, > > > Rebecca > > > > > > address@hidden> wrote: > > > > > > > Rebecca, > > > > > > > > I spent quite a bit of time looking into this problem this AM, and I > > > > believe we > > > > have a bonafide IDV bug which I have not gotten to the bottom of yet. > > > > > > > > But can we step back a moment and talk about your ultimate objective? > > The > > > > truth > > > > is that the IDV is not really designed to be a data conversion tool. > > If > > > > data > > > > conversion into Excel is solely your ultimate objective, there may be > > > > better > > > > ways of going about about this problem. > > > > > > > > Also, I don't believe your date range has simply been shifted. But > > rather > > > > the > > > > dates are actually corrupt. Simply export the first time stamp and you > > > > will see > > > > that it gets shifted from the original January back into December. > > > > > > > > Best, > > > > > > > > Unidata IDV Support > > > > > > > > > I should have saved it, but didn't so here is my attempt to rewrite > > the > > > > > issue: > > > > > > > > > > I have been using the IDV to convert my netcdf files to Excel files > > since > > > > > that issue was resolved back in March. The first 30 or so that I > > > > converted, > > > > > I checked the outputs and the files were good. A few weekends ago > > while > > > > > converting more files, I opened one to check it and the dates that I > > had > > > > > selected in the conversion tool were not the dates that were > > recorded in > > > > > the Excel file. I am attaching an Excel file and netcdf file for > > > > > Precipitation October 1991 as an example. I selected the times > > > > > 1991_10_01_03 so 10/1/1991 time-step starting at 03:00 through > > > > > 1991_11_01_00 so 11/1/1991 time-step 00:00 when converting the netcdf > > > > file > > > > > in IDV, however the dates/times that appear in the Excel file are > > > > > 1991-09-26 03:00:00Z through 1991-10-27 00:00:00Z. > > > > > I am wondering what went wrong and how to fix this? Additionally, I > > am > > > > > wondering if the data is still correct and the dates listed are just > > > > > incorrect in the Excel file, meaning I could just manually change the > > > > > dates? Or if everything has just somehow been converted with the > > wrong > > > > > information all together? > > > > > > > > > > Thank you, > > > > > Rebecca Boyd > > > > > > > > > > pr_RCM3_gfdl_1991010103.nc > > > > > > https://docs.google.com/file/d/0B8Vzg9Q6QiWRX2MyOF9Dajh5RGc/edit?usp=drive_web > > > > > > > > > > > > > > > > > > > > pr_RCM3_gfdl_1991100103_1991110100.xls > > > > > > https://docs.google.com/file/d/0B8Vzg9Q6QiWRaHd0Q3Y1Z080OW8/edit?usp=drive_web > > > > > > > > > > > > > > > > > > > > address@hidden> wrote: > > > > > > > > > > > > > > > > > Hi Rebecca, > > > > > > > > > > > > re: > > > > > > >I submitted a "Support Request Form" via the IDV last Monday > > 4/27/15 > > > > and > > > > > > >was wondering if it had been received? > > > > > > > > > > > > The last support inquiry we can find for you was on March 10: > > > > > > > > > > > > Subject: Trouble Converting NetCDF to Excel > > > > > > > > > > > > A reply to this inquiry was sent on March 11. > > > > > > > > > > > > Please resend the inquiry you sent last week, and we will take a > > look. > > > > > > > > > > > > Cheers, > > > > > > > > > > > > Unidata User Support > > > > > > -- > > > > > > > > ********************************************************************** > > > > > > Unidata User Support UCAR Unidata > > Program > > > > > > (303)497-8643 P.O. Box > > > > > > address@hidden Boulder, CO > > > > > > > > ---------------------------------------------------------------------- > > > > > > Unidata Web Support > > http://www.unidata.ucar.edu/support > > > > > > > > ---------------------------------------------------------------------- > > > > > > > > > > > > > > > > > > > > > > > > > > -- > > > > > University of Denver 2015 > > > > > MS Student in Geographic Information Science > > > > > > > > > > > > > > > > > > > > > > Ticket Details > > > > =================== > > > > Ticket ID: UUL-161546 > > > > Department: Support IDV > > > > Priority: Normal > > > > Status: Closed > > > > > > > > > > > > > > > > > -- > > > University of Denver 2015 > > > MS Student in Geographic Information Science > > > > > > > > > > > > Ticket Details > > =================== > > Ticket ID: UUL-161546 > > Department: Support IDV > > Priority: Normal > > Status: Closed > > > > > > > -- > University of Denver 2015 > MS Student in Geographic Information Science > > Ticket Details =================== Ticket ID: UUL-161546 Department: Support IDV Priority: Normal Status: Closed