Southland Wx Posted February 3, 2012 Share Posted February 3, 2012 Hi all, A friend of mine just built what I think is a great little tool to throw on your desktop and add to your toolkit if you have Excel. I think a lot of folks here will find some good use from this. It's a forecast sheet that looks like this: Basically it fetches a bunch of BUFKIT and MOS data, including GFS ensemble data and imports it into a tidy little (ok, not terribly small) Excel sheet (Note that it will not work with any of the open source programs that are similar to Excel, such as Open Office), so if you're looking to get a lot of info in one window, this will do it. I think there's a good amount of use for this, especially since it's right off the desktop and fetches most MOS data you'd ever need + a good amount of other info. It also has charts/graphs for temps and precip and more built in. The author is very accessible and looking for feedback or tweaks as well, so don't hesitate to contact her. You can download it here: http://www.txtornado.net/Worksheet.html Link to comment Share on other sites More sharing options...
Rick G Posted February 3, 2012 Share Posted February 3, 2012 if you are running excel 2007 ot 2010 you will need to save it as a macro enabled spreadsheet. Do a file save as and then on the save as type. choose Excel Macro-enabled workbook. you will be promptedto enable content. that is normal. Pretty cool sheet. nice tool. Link to comment Share on other sites More sharing options...
WxChick Posted February 3, 2012 Share Posted February 3, 2012 You should not need to save as macro-enabled. You just have to enable the macros when u open the program. In 2007 and 2010 it can be as simple as clicking allow on the banners at the top of the screen. Link to comment Share on other sites More sharing options...
L.B. LaForce Posted February 3, 2012 Share Posted February 3, 2012 Looks really neat, but when I click load data, it goes through, and tried to get data, but I get a run time error 1004. Link to comment Share on other sites More sharing options...
WxChick Posted February 3, 2012 Share Posted February 3, 2012 Looks really neat, but when I click load data, it goes through, and tried to get data, but I get a run time error 1004. Hmmm. Not sure what that's about. I sent you a private message. (Wont be responding again until tomorrow though.) Link to comment Share on other sites More sharing options...
WestMichigan Posted February 3, 2012 Share Posted February 3, 2012 I can't get PSU to work so I switched to ISU and get "Run-time error '13': Type mismatch" with no option to debug or continue, just end or help. This looks like it could be a neat Excel application, I just wish I could get it to run. If it matters, I am using KGRR as my site and was loading the 2/3/12 6Z data. Link to comment Share on other sites More sharing options...
WxChick Posted February 3, 2012 Share Posted February 3, 2012 I can't get PSU to work so I switched to ISU and get "Run-time error '13': Type mismatch" with no option to debug or continue, just end or help. This looks like it could be a neat Excel application, I just wish I could get it to run. If it matters, I am using KGRR as my site and was loading the 2/3/12 6Z data. I was able to duplicate this using the ISU server. I know what the problem is, but I have to get to work, and wont be able to fix it until later this afternoon. Not sure why PSU wouldnt work for you? I just used it, maybe it was temporarily down earlier. Link to comment Share on other sites More sharing options...
SBUWX23 Posted February 3, 2012 Share Posted February 3, 2012 Wow this is really cool!!! Excellent work! I was able to duplicate this using the ISU server. I know what the problem is, but I have to get to work, and wont be able to fix it until later this afternoon. Not sure why PSU wouldnt work for you? I just used it, maybe it was temporarily down earlier. Link to comment Share on other sites More sharing options...
Scotty Lightning Posted February 4, 2012 Share Posted February 4, 2012 This topic should really be pinned because what was created here was pretty freakin' amazing(and saves me some time in the morning!)! Link to comment Share on other sites More sharing options...
WxChick Posted February 4, 2012 Share Posted February 4, 2012 Took care of a couple of bugs that were uncovered by above posters. Please download the updated version. http://www.txtornado.net/Worksheet.html Thanks for the comments guys, I appreciate them. Link to comment Share on other sites More sharing options...
wxmeddler Posted February 4, 2012 Share Posted February 4, 2012 Oh my gosh, this is absolutely amazing! I ran it through Excel 2003 with the macro security settings on "low" and just hit OK when the PSU FTP window popped up. I got the same Error:1004 on the ISU site but WOW!!! I am going to share this with my friends here at Millersville! Awesome work! Link to comment Share on other sites More sharing options...
WxChick Posted February 4, 2012 Share Posted February 4, 2012 Hmmm. What version are you running? The bug with the ISU site should be fixed. Did u grab V2.2? If so, what site id were u tying to load? Link to comment Share on other sites More sharing options...
wxmeddler Posted February 4, 2012 Share Posted February 4, 2012 Hmmm. What version are you running? The bug with the ISU site should be fixed. Did u grab V2.2? If so, what site id were u tying to load? V_2.2 and for whatever reason when I restarted the Excel, now it works. Link to comment Share on other sites More sharing options...
WxChick Posted February 4, 2012 Share Posted February 4, 2012 V_2.2 and for whatever reason when I restarted the Excel, now it works. Hmmm. Weird. There has at times been issues wih the ISU server not liking when you re run the program...it acts like it didnt close a previous connection, so doesnt know what ti do. Even then tho, it just hangs on the connecting boxes and doesnt actually crash. Glad its working for you though! Link to comment Share on other sites More sharing options...
Scotty Lightning Posted February 4, 2012 Share Posted February 4, 2012 Hmmm. Weird. There has at times been issues wih the ISU server not liking when you re run the program...it acts like it didnt close a previous connection, so doesnt know what ti do. Even then tho, it just hangs on the connecting boxes and doesnt actually crash. Glad its working for you though! I had that issue before with an FTP error from Penn State-I just restarted the Excel file and it worked again. I wouldn't really worry about it. Link to comment Share on other sites More sharing options...
KokomoWX Posted February 5, 2012 Share Posted February 5, 2012 Any way to make it work with three digit sites? My site is GVS. It rocks otherwise. Link to comment Share on other sites More sharing options...
WxMidwest Posted February 5, 2012 Share Posted February 5, 2012 This Excel is Ridiculous, Thanks.. Link to comment Share on other sites More sharing options...
SpartyOn Posted February 5, 2012 Share Posted February 5, 2012 Good idea.!!! Link to comment Share on other sites More sharing options...
Huffwx Posted February 5, 2012 Share Posted February 5, 2012 Very cool-- the PSU thing kept asking me for a password. ISU was great. Link to comment Share on other sites More sharing options...
WxChick Posted February 5, 2012 Share Posted February 5, 2012 Any way to make it work with three digit sites? My site is GVS. It rocks otherwise. It looks like GVS is not a valid MOS site. The MOS list is here... http://www.nws.noaa.gov/mdl/synop/products/bullform.mav.php Try KOKK for MOS and GVS for Bufkit. Link to comment Share on other sites More sharing options...
WxChick Posted February 5, 2012 Share Posted February 5, 2012 Very cool-- the PSU thing kept asking me for a password. ISU was great. With the PSU option, when the ftp box comes up you simply need to hit ok with it set to anonymous. Link to comment Share on other sites More sharing options...
WxMidwest Posted February 5, 2012 Share Posted February 5, 2012 WxChick Very Nice, just posted this on the NIU-AMS facebook... Link to comment Share on other sites More sharing options...
RCNYILWX Posted February 5, 2012 Share Posted February 5, 2012 This is awesome! Downloaded it at WFO Chicago and just sent out an email today promoting it to the rest of the staff. Thanks for putting it together and posting the link on here. Link to comment Share on other sites More sharing options...
kab2791 Posted February 5, 2012 Share Posted February 5, 2012 Wow, this is very awesome! Thanks for sharing the link! Link to comment Share on other sites More sharing options...
Coach McGuirk Posted February 5, 2012 Share Posted February 5, 2012 Oh my gosh, this is absolutely amazing! I ran it through Excel 2003 with the macro security settings on "low" and just hit OK when the PSU FTP window popped up. I got the same Error:1004 on the ISU site but WOW!!! I am going to share this with my friends here at Millersville! Awesome work! I have Excel 2003 too. I couldn't get it to work. For some reason I was unable to plug in the airport code or any data. Link to comment Share on other sites More sharing options...
WxChick Posted February 5, 2012 Share Posted February 5, 2012 I have Excel 2003 too. I couldn't get it to work. For some reason I was unable to plug in the airport code or any data. My best guess is that you haven't lowered your macro security? I believe in Excel 2003, you go under File ->Options -> Security Options -> Macro Security. But I could be wrong. If its not a macro setting issue send me a private message and we can try to figure it out. Link to comment Share on other sites More sharing options...
Coach McGuirk Posted February 5, 2012 Share Posted February 5, 2012 My best guess is that you haven't lowered your macro security? I believe in Excel 2003, you go under File ->Options -> Security Options -> Macro Security. But I could be wrong. If its not a macro setting issue send me a private message and we can try to figure it out. Oh, nice. Thanks. Much help. Link to comment Share on other sites More sharing options...
ThreeRedheads Posted February 6, 2012 Share Posted February 6, 2012 I have Excel 2003 too. I couldn't get it to work. For some reason I was unable to plug in the airport code or any data. My best guess is that you haven't lowered your macro security? I believe in Excel 2003, you go under File ->Options -> Security Options -> Macro Security. But I could be wrong. If its not a macro setting issue send me a private message and we can try to figure it out. For 2003, go straight to Tools then Macro then Security What a great program. Thanks so much! Link to comment Share on other sites More sharing options...
KokomoWX Posted February 6, 2012 Share Posted February 6, 2012 Any thoughts on doing this with a severe weather forecasting tool? I always love text output... Example of a web based one using one model - http://somdweather.com/ruc_run.php?rucstation=KMIA Link to comment Share on other sites More sharing options...
DaculaWeather Posted February 6, 2012 Share Posted February 6, 2012 Friggin' awesome! Worked first time even within my firewall at work (used ISU there). I'll try it at home this afternoon. Very nice, thank you. Link to comment Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.