Please Subscribe to our YouTube Channel!

Quick tutorial showing you how to set up a Google Spreadsheet to automatically calculate and keep track of your business mileage, ready for your year-end expense claim. This quick tip was part of our 10 New Year’s Resolutions for Businesses, which you can watch at https://goo.gl/EnrT4R

https://goo.gl/XZdg2C – G Suite and Gmail for Business makes your email look more professional by using your website’s domain name as well as giving you access to collaborative tools like Google Docs, Google Sheets, Google Calendar and Google Drive. You can get a 14-day free trial and if you message us privately we can also give you a 20% discount code for your first year. Click: https://goo.gl/XZdg2C

The formula you’ll need for calculating the route distance in metres between your two points is:

=importxml(“http://maps.googleapis.com/maps/api/directions/xml?origin=” & C2 & “&destination=” & D2 & “&sensor=false&alternatives=false&key=___YOUR_API_KEY___”,”//leg/distance/value”)

Replace “___YOUR_API_KEY___” in the formula above with an API key from https://console.cloud.google.com/ – create a project, add a billing account ($200 free credit per month), activate Directions API and then generate credentials.

RØDE VideoMic Pro+ Microphone
UK: http://amzn.to/2Er1kEA / http://ebay.to/2EsVSRU
US: http://amzn.to/2AO7zjW / http://ebay.to/2qRfTj7

My Pop Filter
UK: http://amzn.to/2D0m6y2 / http://ebay.to/2CYYYRk
US: http://amzn.to/2memvCz / http://ebay.to/2CJUERB

My Desk mount arm
UK: http://amzn.to/2CZOmAQ / http://ebay.to/2EsfA04
US: http://amzn.to/2DfMaTz / http://ebay.to/2EsfOEs

*** My Video Editing PC Full Specs ***
(Built in 2012; GPU fitted in 2018.)

# Intel Core i7 3770K 3.5GHz Quad-Core Processor #
UK: http://amzn.to/2ggjEdj / http://ebay.to/2hEDagp
US: http://amzn.to/2xD2F7z / http://ebay.to/2ylaXoo

# Gigabyte Nvidia Geforce GTX 1080 Graphics Card #
UK: http://amzn.to/2CUByvp / http://ebay.to/2DcWc7Q
US: http://amzn.to/2qL9C8v / http://ebay.to/2AKEwgN

# 16GB Corsair Dominator GT RAM #
UK: http://amzn.to/2gBgPjW / http://ebay.to/2hF5WNI
US: http://amzn.to/2z4djpc / http://ebay.to/2xCIzKC

# ASRock Fatal1ty Z77 Professional Motherboard #
UK: http://amzn.to/2i9Litb / http://ebay.to/2xCYHvN
US: http://amzn.to/2xByvGx / http://ebay.to/2xCoLr0

# Intel 240GB SSD #
UK: http://amzn.to/2g6YFpt / http://ebay.to/2wRz8HN
US: http://amzn.to/2yljK9V / http://ebay.to/2wRGNFT

# Samsung 27-Inch LED Monitor #
UK: http://amzn.to/2g6tVFj / http://ebay.to/2yl2TE7
US: http://amzn.to/2zkhOg4 / http://ebay.to/2yHZvoi

# 2x Western Digital Caviar Black 500GB Hard Drives #
UK: http://amzn.to/2i97IKU / http://ebay.to/2g7Ttll
US: http://amzn.to/2xCDaU2 / http://ebay.to/2gBrnje

# Zalman Z11 Plus Case #
UK: http://amzn.to/2g7TwO3 / http://ebay.to/2gg4Xa3
US: http://amzn.to/2yJgdne / http://ebay.to/2i9I0G4

# Zalman CNPS12X CPU Heatsink/Cooler #
UK: http://amzn.to/2i8zEOW / http://ebay.to/2yIExFJ
US: http://amzn.to/2xCe6RS / http://ebay.to/2g7Buvq

# Coolermaster Silent Pro Gold 1000W Power Supply #
UK: http://amzn.to/2kKedVk / http://ebay.to/2yljBmw
US: http://amzn.to/2yl2OQx / http://ebay.to/2i9Josg

# Pioneer BDR-S09XLT Blu-Ray Writer #
UK: http://amzn.to/2kIW9ei / http://ebay.to/2yf8RXO
US: http://amzn.to/2yl0Akd / http://ebay.to/2ggzFju

# USB 3.0 Multi Card Reader #
UK: http://amzn.to/2ygUMXk / http://ebay.to/2yh4hWv
US: http://amzn.to/2xEyPnY / http://ebay.to/2xCV0Le

Facebook – https://www.facebook.com/SwitchedOnNetwork/
Twitter – https://twitter.com/SwitchedOnNet
Instagram – https://www.instagram.com/switchedonnetwork/
Google+ – https://plus.google.com/112924836454795429890
YouTube Channel – https://www.youtube.com/SwitchedOnNetwork?sub_confirmation=1

Visit our website at https://www.switchedonnetwork.com/

Paul Freeman-Powell

Paul (@paulfp) is the main presenter of the award-winning Switched On Network YouTube Channel, which covers a variety of interesting topics usually relating to his love of technology and all things geeky. He also founded and runs Innobella Media, where he leads in all aspects of video production, video editing, sound & lighting. A father of 3 children including twins, his hobbies used to include photography, playing the drums and cycling. With a degree in Modern European Languages, Paul speaks French, Spanish and a little bit of Italian, and holds dual British & Irish citizenship.

View all posts

6 comments

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

    • Have you set up your billing account? They’ve changed how it works since I made this video. You now have a limit of 1 lookup per day unless you set up a billing account, which gives you $200 credit per month – so you shouldn’t pay anything.

  • I set up a billing account and followed your instruction but. I keep getting an error there is a problem with the formula. I cannot figure out what I am missing.

    • Try the formula in another cell but strip out the xml function call and second argument, so you’re just printing the complete parsed URL to the cell. The paste this into a web browser and you should either see a bunch of XML with each step in the directions (if it’s worked) or an error message which will point you in the right direction.

  • Came across your youtube video and then came here per the directions.

    I was trying to make a simple driving expense report that would automatically calculate the number of miles after I input the to and from destinations. Still got an error after creating an account, starting a free trial, getting the API key. Seemed a little too complicated.

    For those who are trying to do the same as me; I suggest checking out this site for easy instructions on how to insert a custom script that will do this for you:

    https://developers.google.com/apps-script/quickstart/custom-functions#try_it_out

%d bloggers like this: