Tutorial for Making Custom Meteograms
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.
- wxman57
- Moderator-Pro Met
- Posts: 22488
- Age: 66
- Joined: Sat Jun 21, 2003 8:06 pm
- Location: Houston, TX (southwest)
Tutorial for Making Custom Meteograms
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.
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
Re: Tutorial for Making Custom Meteograms
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
- RideroftheStorm
- Tropical Wave
- Posts: 6
- Joined: Wed Dec 15, 2010 4:52 pm
Re: Tutorial for Making Custom Meteograms
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!
0 likes
Janie
A winning effort begins with preparation.
Joe Gibbs
Disaster Recovery is a key part of my preparation.
A winning effort begins with preparation.
Joe Gibbs
Disaster Recovery is a key part of my preparation.
- wxman57
- Moderator-Pro Met
- Posts: 22488
- Age: 66
- Joined: Sat Jun 21, 2003 8:06 pm
- Location: Houston, TX (southwest)
Re: Tutorial for Making Custom Meteograms
I just updated the tutorial and files to reflect new links. We don't use that other ISP any more.
0 likes
- Stephanie
- S2K Supporter
- Posts: 23842
- Age: 61
- Joined: Thu Feb 06, 2003 9:53 am
- Location: Glassboro, NJ
Re: Tutorial for Making Custom Meteograms
I JUST tried this. Looks like a little snow for Christmas Day and a lot of rain from Dec 26 - 27.
Pretty cool. Thank you for updating the links and the great instructions.
Pretty cool. Thank you for updating the links and the great instructions.
0 likes
- Meteorcane
- Category 2
- Posts: 541
- Joined: Thu Jul 21, 2011 6:49 am
- Location: North Platte Nebraska
Re: Tutorial for Making Custom Meteograms
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
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.
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.
Re: Tutorial for Making Custom Meteograms
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.
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
Re: Tutorial for Making Custom Meteograms
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
- wxman57
- Moderator-Pro Met
- Posts: 22488
- Age: 66
- Joined: Sat Jun 21, 2003 8:06 pm
- Location: Houston, TX (southwest)
Re: Tutorial for Making Custom Meteograms
My spreadsheets have been updated for the updated GFS. The 3-hour high-res part now goes out to 240 hrs.
0 likes
-
- S2K Supporter
- Posts: 2968
- Age: 36
- Joined: Fri Dec 13, 2013 11:55 am
- Location: Lindale, TX
I cannot find the data anywhere either. Anyone know where to get the data?
0 likes
Follow on Facebook at Ralph's Weather.
- wxman57
- Moderator-Pro Met
- Posts: 22488
- Age: 66
- Joined: Sat Jun 21, 2003 8:06 pm
- Location: Houston, TX (southwest)
Re:
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
-
- S2K Supporter
- Posts: 2968
- Age: 36
- Joined: Fri Dec 13, 2013 11:55 am
- Location: Lindale, TX
Re: Re:
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.
- wxman57
- Moderator-Pro Met
- Posts: 22488
- Age: 66
- Joined: Sat Jun 21, 2003 8:06 pm
- Location: Houston, TX (southwest)
Re: Tutorial for Making Custom Meteograms
I'm back online as "wxman57.com". My meteogram links at the top are updated and point to my new domain.
1 likes
Who is online
Users browsing this forum: No registered users and 12 guests