In Google Sheets, go to View > Freeze > 1 row.Īlternatively, hover your mouse over the dark grey line underneath the “1” which marks the first row. Freeze the first row: This turns your column name into a proper header, so it’s always at the top of the sheet. It takes two steps to sort your addresses by zip/postal code.ġ. By assigning each zone to a dedicated driver, they are able to focus on a specific area of the city, get familiar with the route and its customers, and complete more deliveries per route in a shorter amount of time. This allows you to split a large geographic area up into delivery zones so your drivers aren’t wasting time driving all across the city. One popular method is to sort by zip or postal code. When you’re dealing with a long list of addresses, delivery companies often try to break the list up into smaller batches that are easier to work with. Spreadsheets allow you to sort your data in a way that makes sense to you. Three ways to plan routes with spreadsheets 1: Route planning with Excel alone Now that your spreadsheet is set up correctly, we can get on with the route planning. To do this, simply create two columns titled Latitude and Longitude instead of the Address column. In our free sample sheet, we’ve added a separate zip code column so you can enjoy the best of both worlds.Īnother option is to use latitude and longitude coordinates, if you have them. There are benefits to doing this if you want to be able to sort your addresses by zip or postal code, which is the first method we suggest below. If you prefer, you can split up the address into four separate columns: This makes it a lot easier for Google Maps to find the right location. “Address” should contain your customer’s full address, ideally including the street number, street name, city, state or province (if applicable), country, and zip or postal code. In the “Name” column, put either your customer’s first and last name or their business name. The two columns should be called “Name” and “Address”. Here's a free Excel template to help you get started. We suggest starting off by creating at least two columns, at the bare minimum. To plan your routes using Excel, Google Sheets, or any other spreadsheet program, you’ll need to include some basic data. How to format your Excel file for delivery route planning We're using Google Sheets in our examples, but you can apply the same principles to Excel sheets they both work almost exactly the same way. Our personal favorite at Routific is Google Sheets. There’s Microsoft Excel, of course, but Numbers (for Mac users) and LibreOffice Calc (open source and free!) are also popular choices. There are a few computer programs to choose from when you’re working with spreadsheets. Which spreadsheet app is best for route planning? Using Excel and Google Maps route planner to create an efficient route.Īll three ways use spreadsheets, but two of the tactics use other apps as well.īefore we start route planning, we need to make sure your spreadsheet is set up properly.Delivery route planning with spreadsheets alone.In this step by step tutorial, we’ll show you the best way to set up an Excel spreadsheet for deliveries, and three ways to plan routes: Love them or hate them, Excel spreadsheets are a part of life - and a common tool for managing route planning in a delivery business.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |