Tutorial for Making Custom Meteograms

Winter Weather Discussion

Moderator: S2k Moderators

Forum rules

The posts in this forum are NOT official forecast and should not be used as such. They are just the opinion of the poster and may or may not be backed by sound meteorological data. They are NOT endorsed by any professional institution or STORM2K.

Help Support Storm2K
Message
Author
User avatar
wxman57
Moderator-Pro Met
Moderator-Pro Met
Posts: 22473
Age: 66
Joined: Sat Jun 21, 2003 8:06 pm
Location: Houston, TX (southwest)

Tutorial for Making Custom Meteograms

#1 Postby wxman57 » Tue Nov 16, 2010 9:22 am

A few years back, one of my coworkers designed a meteogram spreadsheet in Excel. The graphics have been quite popular here, so I thought I would share the technique and files with everyone here. This may also save me from many requests of "make one for my area, please!". ;-)

The meteogram spreadsheets below were crafted for the GFS run. However, they can be easily modified to make meteograms from the NAM/ETA or any other model data. I'll post links to NAM/ETA versions in the future.

First thing you'll need is a copy of Microsoft Excel, 2007 or later. If necessary, I can create an Excel 2003 version, but you really should update to a modern version of Excel.

Here are the links to the files:

The tutorial takes you through the production step-by-step, with pictures and arrows. The process may look a bit complex, but once you make a few of them you'll find that the whole process takes about 60 seconds.

Tutorial on How to Make the Meteograms:
http://www.wxman57.com/Meteograms/Making_Meteograms.pdf

GFS 0-240hr Meteogram:
http://www.wxman57.com/Meteograms/GFS.xlsx

GFS 240-384hr Meteogram:
http://www.wxman57.com/Meteograms/GFS_Extended.xlsx

Updated 3/10/17: Changed the links to my new domain - wxman57.com.
0 likes   

User avatar
Tireman4
S2K Supporter
S2K Supporter
Posts: 5674
Age: 58
Joined: Fri Jun 30, 2006 1:08 pm
Location: Humble, Texas
Contact:

#2 Postby Tireman4 » Tue Nov 16, 2010 10:12 am

Thank you so much for this Wxman57...We do appreciate it.
0 likes   

User avatar
gboudx
S2K Supporter
S2K Supporter
Posts: 4047
Joined: Thu Sep 04, 2003 1:39 pm
Location: Rockwall, Tx but from Harvey, La

#3 Postby gboudx » Tue Nov 16, 2010 11:22 am

Very easy to follow the Tutorial and create your own meteograms. Thanks a lot fellow Who Dat! ;)
0 likes   

rhoby13
Tropical Low
Tropical Low
Posts: 31
Joined: Thu Dec 03, 2009 4:02 pm
Location: Austin, TX

Re: Tutorial for Making Custom Meteograms

#4 Postby rhoby13 » Thu Dec 16, 2010 11:24 am

Thank you so much for this tutorial! I will definitely be able to impress my friends and family over Christmas with my weather forecasts.
0 likes   

User avatar
RideroftheStorm
Tropical Wave
Tropical Wave
Posts: 6
Joined: Wed Dec 15, 2010 4:52 pm

Re: Tutorial for Making Custom Meteograms

#5 Postby RideroftheStorm » Tue Dec 28, 2010 11:07 am

This is actually a pretty fantastic tutorial you posted, wxman! I honestly never really thought about making my own meteogram, but it does seem like it would be a really cool plan. I'll bookmark this thread for future use and see what happens. Thanks for sharing! :D
0 likes   
Janie
A winning effort begins with preparation.
Joe Gibbs

Disaster Recovery is a key part of my preparation.

User avatar
wxman57
Moderator-Pro Met
Moderator-Pro Met
Posts: 22473
Age: 66
Joined: Sat Jun 21, 2003 8:06 pm
Location: Houston, TX (southwest)

Re: Tutorial for Making Custom Meteograms

#6 Postby wxman57 » Tue Oct 02, 2012 3:16 pm

I just updated the tutorial and files to reflect new links. We don't use that other ISP any more.
0 likes   

User avatar
Stephanie
S2K Supporter
S2K Supporter
Posts: 23842
Age: 61
Joined: Thu Feb 06, 2003 9:53 am
Location: Glassboro, NJ

Re: Tutorial for Making Custom Meteograms

#7 Postby Stephanie » Sat Dec 22, 2012 9:13 pm

I JUST tried this. Looks like a little snow for Christmas Day and a lot of rain from Dec 26 - 27. :D

Pretty cool. Thank you for updating the links and the great instructions.
0 likes   

User avatar
Meteorcane
Category 2
Category 2
Posts: 541
Joined: Thu Jul 21, 2011 6:49 am
Location: North Platte Nebraska

Re: Tutorial for Making Custom Meteograms

#8 Postby Meteorcane » Tue Dec 03, 2013 12:49 pm

Thank you very much these things are quite useful (unfortunately I had to lower the scale of mine to 0F for the upcoming forecast period (let's pray it doesn't actually get that low).
0 likes   

User avatar
dhweather
S2K Supporter
S2K Supporter
Posts: 6163
Joined: Sat Aug 14, 2004 9:29 pm
Location: Heath, TX
Contact:

#9 Postby dhweather » Wed Jan 22, 2014 10:11 am

A coworker and I have taken wxman57's meteogram spreadsheets and made them a little more user friendly.

New features include:

Automatically puts the city name on the meteogram graph
Automatically changes dates for the model run
One click to generate the whole thing, no other activity required


Instructions for use:

1) You still have to go to the NOAA site in wxman57's instructions and follow those steps to get the data.
2) Then you copy all of the text output (highlight all of it , from GFS at the top of the text output to the end of the 192 hour data) and right click, select copy.
3) Open the spreadsheet, it will ask you to enable macros, select yes.
4) Select the yellow GFS Meteogram Data tab and then simply click on the button #2 "click here" (left click).


Then the magic happens, the spreadsheet does all the work, and the graph appears before your eyes. I've tested this for numerous cities throughout the US, and everything appears to be correct. If you are up to giving it a shot, here is where you can download it:

0-192 hours

http://www.heathweather.com/GFSv2.xlsm

192-384 hours

http://www.heathweather.com/GFS_Extendedv2.xlsm


Please let me know if you have trouble and we will try to help resolve it for you.
0 likes   
The above post and any post by dhweather is NOT an official forecast and should not be used as such. It is just the opinion of the poster and may or may not be backed by sound meteorological data. It is NOT endorsed by any professional institution including storm2k.org. For official information, please refer to NWS products.

User avatar
ravyrn
S2K Supporter
S2K Supporter
Posts: 992
Age: 41
Joined: Sun Aug 31, 2008 5:10 am
Location: Alderbranch, TX

Re: Tutorial for Making Custom Meteograms

#10 Postby ravyrn » Fri May 09, 2014 12:04 am

Here are some altered files I made for meteograms with altered directions included in an image file below. Wxman57 supplied me with the GFS 0-192hr meteogram and instructions on how to include 850mb temps. I altered the spreadsheet for the GFS 192-384 to include it as well and altered the directions originally supplied by Wxman57. I also managed to alter the original excel file and created one for the NAM 84hr that includes 850mb temps and altered the directions accordingly. I may have missed some minor details in the directions, but I did my best. All props goto Wxman57 and his colleague for the initial creation. I simply modified the directions and excel sheets to add 850mb temps to the long range GFS meteogram and to create the NAM.

GFS Model (1 degree, 0-192h, 3hrly, Global, pressure): http://www.filedropper.com/gfs0-192hrwith850mb

GFS Model (1 degree, 192-384h, 12hrly, Global, pressure): http://www.filedropper.com/gfs192-384hrwith850mb

NAM Model (12km, 84, 3hrly, CONUS, pressure): http://www.filedropper.com/nam0-84hrwith850mb

Goto the ARL website: http://ready.arl.noaa.gov/READYcmet.php%20to%20obtain%20the%20data for data.

Use this site to convert longitude/latitude to decimals as required by the ARL website: http://transition.fcc.gov/mb/audio/bickel/DDDMMSS-decimal.html

Directions for GFS excel meteograms: http://i.imgur.com/1Ynbhso.jpg (You may need to click the magnify button to read them properly).

Directions for NAM excel meteograms (84hr only): http://i.imgur.com/kJmIPIY.jpg

Sorry the directions are in image files and not .pdf. I would have made instructions in .pdf had I the means.
0 likes   

User avatar
ravyrn
S2K Supporter
S2K Supporter
Posts: 992
Age: 41
Joined: Sun Aug 31, 2008 5:10 am
Location: Alderbranch, TX

Re: Tutorial for Making Custom Meteograms

#11 Postby ravyrn » Thu Nov 06, 2014 1:08 am

Did anyone happen to snag any of these meteograms excel sheets I shared? My hard drive died two weeks ago and I'd rather see if someone has them available before I goto the trouble of making the alterations needed to Wxman57's original excel sheets to add 850mb temps to the long range GFS and recreating the NAM's. The file links don't work anymore so I'm hoping one of you guys snagged them.
0 likes   

User avatar
wxman57
Moderator-Pro Met
Moderator-Pro Met
Posts: 22473
Age: 66
Joined: Sat Jun 21, 2003 8:06 pm
Location: Houston, TX (southwest)

Re: Tutorial for Making Custom Meteograms

#12 Postby wxman57 » Wed Jan 14, 2015 2:47 pm

My spreadsheets have been updated for the updated GFS. The 3-hour high-res part now goes out to 240 hrs.
0 likes   

ejburas
Tropical Wave
Tropical Wave
Posts: 4
Age: 39
Joined: Sat Dec 22, 2012 7:31 pm
Location: NW Harris County, TX

#13 Postby ejburas » Wed Nov 18, 2015 12:31 pm

I lost the file, and when I click the links, it says page not found :(
0 likes   

Ralph's Weather
S2K Supporter
S2K Supporter
Posts: 2968
Age: 36
Joined: Fri Dec 13, 2013 11:55 am
Location: Lindale, TX

#14 Postby Ralph's Weather » Wed Nov 18, 2015 5:56 pm

I cannot find the data anywhere either. Anyone know where to get the data?
0 likes   
Follow on Facebook at Ralph's Weather.

User avatar
wxman57
Moderator-Pro Met
Moderator-Pro Met
Posts: 22473
Age: 66
Joined: Sat Jun 21, 2003 8:06 pm
Location: Houston, TX (southwest)

Re:

#15 Postby wxman57 » Fri Nov 20, 2015 11:26 am

Ralph's Weather wrote:I cannot find the data anywhere either. Anyone know where to get the data?


It seems that my ISP (Comcast) decided that their customers (me) no longer have a need for personal web page space so they shut down the server.

I have the tutorial and spreadsheets and can send them to someone who can post them on another server.

For now, I changed the links to dropbox links. They do work, but I'd like to find a better solution.
0 likes   

Ralph's Weather
S2K Supporter
S2K Supporter
Posts: 2968
Age: 36
Joined: Fri Dec 13, 2013 11:55 am
Location: Lindale, TX

Re: Re:

#16 Postby Ralph's Weather » Fri Nov 20, 2015 12:16 pm

wxman57 wrote:
Ralph's Weather wrote:I cannot find the data anywhere either. Anyone know where to get the data?


It seems that my ISP (Comcast) decided that their customers (me) no longer have a need for personal web page space so they shut down the server.

I have the tutorial and spreadsheets and can send them to someone who can post them on another server.

For now, I changed the links to dropbox links. They do work, but I'd like to find a better solution.

Thanks.
0 likes   
Follow on Facebook at Ralph's Weather.

User avatar
wxman57
Moderator-Pro Met
Moderator-Pro Met
Posts: 22473
Age: 66
Joined: Sat Jun 21, 2003 8:06 pm
Location: Houston, TX (southwest)

Re: Tutorial for Making Custom Meteograms

#17 Postby wxman57 » Fri Mar 10, 2017 8:52 am

I'm back online as "wxman57.com". My meteogram links at the top are updated and point to my new domain.
1 likes   

peter007
Tropical Wave
Tropical Wave
Posts: 1
Joined: Sat Apr 15, 2017 8:03 pm

Re: Tutorial for Making Custom Meteograms

#18 Postby peter007 » Sun Apr 16, 2017 9:58 am

Thank you , great tutorial.
HemorrhageTreatment
0 likes   


Return to “Winter Weather”

Who is online

Users browsing this forum: No registered users and 58 guests