TX Tornado Forecast Worksheet

MOS data, bufkit data, and NWS forecast all in one place, in an easy to read format.

Download Here: Forecast Worksheet Version 3.0.1

Updated 8/25/16 - Quick update to correct headers in Past Runs tab.
***Updated 8/2/16 - New version features: Past MOS Runs, Updated MOS site list, dewpoints graph. To load past runs, go to Past Runs tab and push "Load Archive" button.***

If you feel so inclined...

Compatible with Excel versions XP, 2003, 2007, 2010, 2013.
Will not work with Mac or other open source versions of Office.

With no way to track who's using this program, I have no way to directly let everyone know when there are updates. If you would like to be on the mailing list for future updates, please send me an email penny.zabel@gmail.com and I'll add you to the list.


About | First Use | Troubleshooting | Model Information | Contact Information | Disclaimers





Forecast values are extracted from traditional MOS tables and Bufkit files and organized so that all data valid for the same hour can be read horizonally across the page.
*Note - Hawaii sites are not working at this time. Alaska sites may fail for a couple hours in the evening.
There is a lot of data available, which may be too much to digest all at once. To clean it up a bit, or if you are not interested in certain parameters, just toggle them off. They can be toggled on and off as you wish.




If you prefer to look at individual models together instead of parameters together, select the last toggle button on the left menu and the data will be sorted by model. Press again to switch back.
60-hour forecast graphs are also available for temperature, dewpoint and precipitation.

      


Instructions for First Use:

  • Download .xls file to your PC.
  • Open in Excel.
  • If any banners pop up at top of page, approve/allow them.
  • You may need to enable macros. This is achieved differently for each version of Excel. If there's no banner asking to allow macros, look for your security settings and macro settings within there. This will need to be set to Low...or possibly medium.
  • Enter a Site ID in the first box.
  • If the bufkit ID for the site is different, enter this in the second box. Most of the time this is left blank.
  • Choose the Bufkit source. For most people PSU will be the best choice. Some network security settings however will not allow the connection to the PSU FTP. In this case, use ISU. Also, at times if the PSU site is down, you can use ISU. The ISU site takes a bit longer to load, so be patient. If you do not want to or can't load bufkit, choose 'none'.
  • Hit the Load Data button. If you are using PSU, the first time you connect, a pop up with display to connect to the FTP. Leave the radio button set to Anonymous, and just hit OK.


    Troubleshooting:

    Using Excel for Mac: At this time the program does not work on a Mac. Attempts will be made to make it compatible, but they may or may not be successful. If you are unable to use the program because you are on a Mac, please send me an email.

    Invalid address error when loading from PSU: If you see this error, there are two possible problems. The PSU site could be down...or it could be rejecting the connection from your IP. If it is an ongoing problem, most likely it is the latter. The PSU ftp site rejects download requests from unregistered IP addresses. At this point there's nothing that can be done about this. You should still be able to use the ISU site, but *important* you will have to close and reopen the program. If you run on PSU and it errors, ISU will also error out. But reopening the program should allow ISU to work.

    Message saying ID is invalid:
    For MOS sites, check this site for correct ID... http://www.nws.noaa.gov/mdl/synop/products/bullform.mav.php
    For Bufkit sites, check one of these sites for correct ID.
    PSU: http://www.meteo.psu.edu/bufkit/CONUS_NAM_00.html
    ISU: http://www.meteor.iastate.edu/~ckarsten/bufkit/data/index.html



    About the models:

    NAM/GFS/GFSx MOS:
    http://www.nws.noaa.gov/mdl/synop/products.php

    NAM/GFS Bufkit:
    http://www.meteo.psu.edu/bufkit/CONUS_NAM_18.html -- All US
    http://www.meteor.iastate.edu/~ckarsten/bufkit/data/index.html -- Only continental US sites.
    *Note: NAM Buf Snow is calculated crudely as QPF*10 IF temp is less than 32. This is by no means perfect, but the only reasonable option at this time. GFS Buf Snow is calculated by QPF*SWE (snow water equivalent)

    GFS Ensemble:
    http://www.nws.noaa.gov/mdl/synop/products.php
    *Note: The ensemble data in this sheet is calculated by averaging all runs in the output...this includes control, operational and 20 pertubations.

    LAMP:
    NOAA/MDL: http://www.nws.noaa.gov/mdl/gfslamp/gfslamp.shtml

    NWS:
    NWS forecast data is queried from the NDFD database by the lat/lon of the site.
    *Note: beyond 60 hours some parameters (hourly T, dewpoint, wind ) may not necessarily line up on the 00 and 12 time steps for the extended periods. If this happens, the closest forecast time is used, with a preference toward the past time. ie... there may be a 21z and 09z value...the 21z would be used for 00z and 09z for 12z. If for some reason data is unavailable, these fields will remain blank.





    Contact Information:
    Questions/Comments/Suggestions/Bugs?
    Email: penny.zabel@gmail.com




    Disclaimers:
    This is an independent project not associated with NOAA or the NWS.
    Data is provided as a tool for weather forecasting and should not be used as an absolute forecast.