Use Excel to Make Sure You'll be Warm on Your Vacation

Use Excel to Make Sure You'll be Warm on Your Vacation

People can do amazing things with excel training. Enter Anish Shah, a self-proclaimed magician who wanted to take a short vacation recently (who doesn't?). The trouble was, his primary criteria was a warm place, and while there are plenty of sites out there that will tell you all you need to know about a place, there aren't too many that disgorge information about temperatures all that easily. Of course, Google will get you what you need, but it needs a little bit of inspired searching. And when your shortlist of locations spreads across continents, you can be sure you need a couple of hours at the least of tedious searching. That's where Anish comes in - This excel wiz used a feature in Excel called web queries to create a database of weather information from over two thousand places across the world. Yes, you read that right: 2000 places.

In his own words:

"That is why I created a very simple tool called Destination Decider. Download the small excel file here. Raw weather data1 gathered from the U.S Department of Energy from over two thousand locations2 across the globe was aggregated in Excel 2010 tutorial with the help of web queries. (I highly recommend learning how to use web queries as it can be a highly efficient way of downloading large amounts of data into Excel with little effort). Once the data was downloaded, I created a simple pivot table that summarizes the weather data where an even simpler form pulls from the pivot table. The form asks you to input the following: Month in which you plan on travelling Low-end of a desirable temperature range High-end of a desirable temperature range"

... and that's it really - you're good to go, with a list that tells you places that fit your requirements. Talk about an innovative (and useful!) way to use the many and myriad powers of Excel. Here's the website, which also has a link from where you can download the Excel file that will perform said miracle.

POST COMMENT

Fast Cars Deserve A Bachelorette Party? Las Vegas Vacation Bundles Are Waiting For You! Learn How To Scoop Up Up-to-the-minute Old Vallarta, Mexico Resort Guide Along With No-nonsense Mentions For Vacationers Handy Central Florida Usa Place Information As Well As Practical Mentions For Vacationers Three mobile broadband deals ­ Major network that provide broadband with high speeds Seeking A Break? Las Vegas Vacation Bundles Are Affordable! Get Hints On How To Grab Packages Includ Paradise Punta Cana Favorite Vacation Guides Bookings Price-offs Dining And Destinations Searching For A Vacation? Sin City Trip Bundles Are Available At Great Rates! Get Suggestions On How Rome Absolute Rest Advices: Lodging Inn, Eating Time, Pleasure, And Vacation Sites Old Cars for Sale – General Instruction for Buyers The Fundamental Traveler Manual To A Astonishing Vacation At Fort Lauderdale And Getting A Top-quali Selecting a Mediator in a Car Accident Lawsuit Wisconsin Uninsured And Under-insured Motorists Rise With Unemployment