streets and trips - REO Property Preservation Forum
Reply
 
LinkBack Thread Tools Display Modes
post #1 of 11 (permalink) Old 08-05-2013, 09:15 PM Thread Starter
group think
 
Join Date: Jul 2013
Location: north alabama-you need grass cut here and pay more than break even, let me know
Posts: 36
Thanks: 13
Thanked 2 Times in 2 Posts
streets and trips

Anybody know how to turn a
docx work order list into a
excel file that Microsoft streets and trips can read.
cutting grass is offline  
Sponsored Links
Advertisement
 
post #2 of 11 (permalink) Old 08-05-2013, 09:48 PM
Member
 
Join Date: Jun 2013
Posts: 59
Thanks: 3
Thanked 23 Times in 18 Posts
I know how to create a route in excel and use Google maps.
REOmadness is offline  
post #3 of 11 (permalink) Old 08-06-2013, 04:21 AM Thread Starter
group think
 
Join Date: Jul 2013
Location: north alabama-you need grass cut here and pay more than break even, let me know
Posts: 36
Thanks: 13
Thanked 2 Times in 2 Posts
I can copy the docx to clip board
and then paste it in excel
But when I try to import the excel
File into streets and trips
I get an error message

I can copy and paste 1 address at a time
Using Google maps online
But that takes forever
cutting grass is offline  
Sponsored Links
Advertisement
 
post #4 of 11 (permalink) Old 08-06-2013, 07:40 AM
Senior Member
 
Join Date: Apr 2012
Posts: 751
Thanks: 123
Thanked 504 Times in 253 Posts
Goto: http://www.mapquest.com/routeplanner

Click on the Copy and paste tab or import spreadsheet.
Gypsos is offline  
post #5 of 11 (permalink) Old 08-06-2013, 08:44 PM Thread Starter
group think
 
Join Date: Jul 2013
Location: north alabama-you need grass cut here and pay more than break even, let me know
Posts: 36
Thanks: 13
Thanked 2 Times in 2 Posts
mapquest route planner is a little better
than the one at a time google crap
But its not going to help at all when I get a 150
property/work order list, since it has a 26 address max
cutting grass is offline  
post #6 of 11 (permalink) Old 08-07-2013, 07:05 AM
Member
 
Join Date: Jun 2013
Posts: 59
Thanks: 3
Thanked 23 Times in 18 Posts
in the first column of your spreadsheet put "to:" then copy all of the columns and rows with addresses into the search line in google maps at one time and it will plot all at once.
REOmadness is offline  
post #7 of 11 (permalink) Old 08-07-2013, 06:43 PM Thread Starter
group think
 
Join Date: Jul 2013
Location: north alabama-you need grass cut here and pay more than break even, let me know
Posts: 36
Thanks: 13
Thanked 2 Times in 2 Posts
Quote:
Originally Posted by REOmadness View Post
in the first column of your spreadsheet put "to:" then copy all of the columns and rows with addresses into the search line in google maps at one time and it will plot all at once.
Thats a neat trick
is there a limit on how many addresses
one can do at a time with google maps
cutting grass is offline  
post #8 of 11 (permalink) Old 08-08-2013, 06:29 AM
Member
 
Join Date: Jun 2013
Posts: 59
Thanks: 3
Thanked 23 Times in 18 Posts
22-24 is the limit per route.
REOmadness is offline  
post #9 of 11 (permalink) Old 08-08-2013, 10:03 PM Thread Starter
group think
 
Join Date: Jul 2013
Location: north alabama-you need grass cut here and pay more than break even, let me know
Posts: 36
Thanks: 13
Thanked 2 Times in 2 Posts
Thanks for the advice/tips
Keep em coming
As for my issue, I did the sensible thing
After doing everything else (as usual),
Ask my contact to send the list in excel
instead of word.
cutting grass is offline  
post #10 of 11 (permalink) Old 09-26-2013, 02:54 PM
Property Services
 
LAND's Avatar
 
Join Date: Mar 2013
Posts: 33
Thanks: 50
Thanked 11 Times in 7 Posts
how bout mapping then to gps?
anyone?
LAND is offline  
Reply

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the REO Property Preservation Forum forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome