All articles with 'xpath' Tag

Calculate travel time and distance between two addresses using Excel + Maps API

Published on Jul 19, 2018 in Excel Howtos
Calculate travel time and distance between two addresses using Excel + Maps API

Ever wanted to calculate distance using Excel  – between two locations (physical addresses)? If we know the addresses, we can go to either Google Maps or Bing Maps and type them out to find the distance and travel time. But what if you are building some model (or calculator) and want to find out the […]

Continue »

Finding Nearby Zipcodes using Excel Formulas

Published on Mar 18, 2013 in Excel Howtos
Finding Nearby Zipcodes using Excel Formulas

Recently, I had a peculiar problem. I have a list of zip codes and I wanted to find out nearest zip codes for each of them.

Now, If I wanted to find out near by zip codes for one area, I could go and search in Google. But, how to do it for dozens of them?

Today, lets understand how you can use Excel (that’s right) to do this automatically. We will be using Excel 2013 for this.

Continue »

Web Page Monitor using Google Docs

Published on Sep 16, 2008 in ideas, Learn Excel, technology
Web Page Monitor using Google Docs

My guest post on monitoring web page changes using google docs is posted in Digital Inspiration – one of the most popular technology blogs. Do read it to learn a little bit about using XPATH, RSS Feeds, Google Spreadsheet import() functions. Here is a summary of the technique: First go to the web page which […]

Continue »