Hey,
I'm using Microsoft Streets and Trips for the first time...
I'm not really an expert on computer software, so don't shot me.
I'm trying to create a routemap for several routes.
So I want to go from A to B and next day from B to C, next day from C to D and so on.
I'm interested in distances from B to C and C to D and so on.
I'm not interested in the total distance from A to D for example.
But the route planner gives me the total...
How do I do this?
Again, I'm sorry if this very simple, I've tried but cannot find the answer.
thanks in advance,
tatouage
I'm using Microsoft Streets and Trips for the first time...
I'm not really an expert on computer software, so don't shot me.
I'm trying to create a routemap for several routes.
So I want to go from A to B and next day from B to C, next day from C to D and so on.
I'm interested in distances from B to C and C to D and so on.
I'm not interested in the total distance from A to D for example.
But the route planner gives me the total...
How do I do this?
Again, I'm sorry if this very simple, I've tried but cannot find the answer.
thanks in advance,
tatouage
I'm afraid you'll have to do some low-grade math to get that information.
If you look at the Directions panel, you will see the projected time and cummulative mileage. For the B to C mileage, subtract the cummulative mileage at B from that of C and you have the result.
Alternatively, structure each leg as a separate trip.
If you look at the Directions panel, you will see the projected time and cummulative mileage. For the B to C mileage, subtract the cummulative mileage at B from that of C and you have the result.
Alternatively, structure each leg as a separate trip.
Hi Tatouage,
:welcome: to LaptopGPSWorld. You will be able to see the distance and driving time between your waypoints when you Print your directions including the "Summary Statistcs".
To do that,
1. you need to add your waypoints and 'Get Directions', then
2. Select Print from File menu,
3. Press the <More Options> button in the 'Print' dialog
4. In the 'More Printing Options' dialog, select 'Include summary statistics' checkbox.
Now, when you print the directions you will also see the summary statistics in the last page that shows the information that you are looking for.
:welcome: to LaptopGPSWorld. You will be able to see the distance and driving time between your waypoints when you Print your directions including the "Summary Statistcs".
To do that,
1. you need to add your waypoints and 'Get Directions', then
2. Select Print from File menu,
3. Press the <More Options> button in the 'Print' dialog
4. In the 'More Printing Options' dialog, select 'Include summary statistics' checkbox.
Now, when you print the directions you will also see the summary statistics in the last page that shows the information that you are looking for.
Gladwin did it again!
I didn't know it was at all possible to get the distances and times from A to B, B to C, etc. This is a nice trick! I've heard people asking for this feature numerous times over the years. Always people would answer it was not possible, the feature wasn't there, get a calculator, etc.
I have added a link to this thread to Tips & Tricks for Streets & Trips.
Thanks!
I didn't know it was at all possible to get the distances and times from A to B, B to C, etc. This is a nice trick! I've heard people asking for this feature numerous times over the years. Always people would answer it was not possible, the feature wasn't there, get a calculator, etc.
I have added a link to this thread to Tips & Tricks for Streets & Trips.
Thanks!
Thank you very much !!
This solution works really good!
My wife and I are planning our US trip, we like to thank you for the fast help you've given us.
best regards,
tatouage
This solution works really good!
My wife and I are planning our US trip, we like to thank you for the fast help you've given us.
best regards,
tatouage
Is there a way to preview that info without actually printing the directions? I can see it on my HP printer preview but it won't let me copy and paste it.
Quote:
Originally Posted by dzwiss
Is there a way to preview that info without actually printing the directions?..........
I do not have onenote, or Office, as I use Open Office instead for opening Office documents, however, in my printing dialog box there is an option to print to file. I checked this and told the printer to start printing. Nothing came out on the printer, but the computer was doing something, I'm not sure what, but I suspect that it was printing to a file (brilliant, eh?): however, I have no idea where that file is. I told it to go to desktop, but it seems to have mind of it's own . Am I barking up the right tree?
Microsoft products usually print to the default device without asking. Make sure your default printer is the one you actually have connected to the computer. If your setup works like mine, pointing at the printer icon in the top bar will tell you which printer the program will use.
Terry
Terry
I was not trying to print out the driving directions. I was trying to transfer to some other file where I could just view the info without printing it.
I tried Microsoft Office Document Image Writer and checked Print to file. The resulting prn file opened on the screen. However, I do have Microsoft Office so I don't know if your results would be the same.
Terry
Terry
I tried print to file from Notepad (didn't want to bring any wierdness of MS Office into play). Here's what I discovered.
I had no option to tell it where to print the file. It only offered me to enter a file name.
I searched and found the file in "C:\Documents and Settings\[my user name]. Yours is probably sitting there, too.
But if it's like mine you might not find it particularly useful. My default printer is an HP inkjet. The file contains all the necessary instructions to the printer to print my short text file, not just a simple text file.
I think your best bet is to track down a freeware PDF writer. They install as printers. You can select it just like selecting an alternate printer. It will ask you for a file name and usually gives you the standard file dialog so you can select the folder you want it in.
...ken...
I had no option to tell it where to print the file. It only offered me to enter a file name.
I searched and found the file in "C:\Documents and Settings\[my user name]. Yours is probably sitting there, too.
But if it's like mine you might not find it particularly useful. My default printer is an HP inkjet. The file contains all the necessary instructions to the printer to print my short text file, not just a simple text file.
I think your best bet is to track down a freeware PDF writer. They install as printers. You can select it just like selecting an alternate printer. It will ask you for a file name and usually gives you the standard file dialog so you can select the folder you want it in.
...ken...
I tried that with CutePDF Writer and Foxit PDF Reader. Works like a charm but don't check 'Print to File'
Terry
Terry
I tried both PDF995 and PDFCreator and they both work. PDF995 was better. Don't check print to file.
Have you set up a TEXT printer? That is always an option, and if you set one up as a choice, it will print a text file to your hard drive where you choose, without the printer commands. Start, Settings, Printers and choose, GENERIC, Text Only as a printer.
That is an amazing trick. I just downloaded the Cute Writer program and it works great. I no longer have to sit down with my calculater and figure out all the point-to-point distances and times.
You guys are the best. After much deliberation I went the CuteWriter route, and as mentioned above it works great.
I LOVE YOU GUYS!
I LOVE YOU GUYS!
I use MS Excel 2007 to calculate the day by day mileage and set up a checklist for making campground reservations, here's how I do it:
- Finish your route, but don't add any rest stops with times, and do a "Edit, Copy Directions". [This places your itinerary in the Clipboard memory]
- Open MS Excel 2007 and "Edit Paste" the directions into the spreadsheet. [I eliminate the "For" and "Toward" columns at this point]
- Hit the upper left corner box to highlight the entire spreadsheet and use the Sort & Filter/Custom sort feature - check the "My data has headers" box and sort on the "Instruction" column.
- Delete all lines that do not start with "Arrive", the header line and the one line that starts with "Depart" and has zero mileage [your starting point]. This should leave you with all your night stops.
- Go back to sort and sort on the "Mile" column.
- Add a column before the Mile column and in the second stop of the new column create a fomula that takes the mileage of that stop and subtracts the miles from the start [zero], and copy the formula down. This will give you the mileage for each day of the trip and provide a checklist of campgrounds with their addresses, and phone numbers for reservations.
- I also enter the number of nights into the spreadsheet and a start date in the first cell of a new column called Arrival Date. From there, I use a formula to take the start date and add the number of nights in the next line to give me the arrival date at the next location. When finished you will have the basic information for your reservations and you can see the daily driving distance and approximate time of arrival at each stop.
Sorry this is so long and no screen shots , but it is simple and is
Another way to save your map directions to excel and to update them every time u make changes to your route >>>>
1. save S&T Route as a Web page, can be found under File....besure to name it with easy name or use route name other than S&T default.
2. set S&T to auto update. (or update every time u save the map)
3. open up excel, click sheet where u want directions to be also click cell u want it to be installed to.
4. goto data tap (very top) of excel tool bar, click on "From Web" button (far left). Opens up a web page. Insert name of M&S route that u saved as a web page.
5. New window will open with saved route.
6. As u look at the new window. u will see yellow boxs with black arrows. Click on each arrow that u want placed into exel worksheet. (I recommend total driving distance and written directions)
7. At bottom right of window click "Import"
8. A small pop-up window will pop-up and ask where u want to put data..Click "ok", and that puts your data on the spread sheet. U may get another pop-up advising of the security risk, press ok and it goes away.
9. All your data is now in your spread sheet and can be used just as any other data
10. Now click on properties on the data screen (Should be next to Refresh All button), u get a new pop-up titled "External Data Range Properties" look down pop-up and u will see "Refresh control"
11.Click on refresh every , then click on when you want it to refresh.
12. Click ok, and u are done.
Now, evertime u make changes to your route, it is also updated in your excel spreadsheet.
Another way to save your map directions to excel and to update them every time u make changes to your route >>>>
1. save S&T Route as a Web page, can be found under File....besure to name it with easy name or use route name other than S&T default.
2. set S&T to auto update. (or update every time u save the map)
3. open up excel, click sheet where u want directions to be also click cell u want it to be installed to.
4. goto data tap (very top) of excel tool bar, click on "From Web" button (far left). Opens up a web page. Insert name of M&S route that u saved as a web page.
5. New window will open with saved route.
6. As u look at the new window. u will see yellow boxs with black arrows. Click on each arrow that u want placed into exel worksheet. (I recommend total driving distance and written directions)
7. At bottom right of window click "Import"
8. A small pop-up window will pop-up and ask where u want to put data..Click "ok", and that puts your data on the spread sheet. U may get another pop-up advising of the security risk, press ok and it goes away.
9. All your data is now in your spread sheet and can be used just as any other data
10. Now click on properties on the data screen (Should be next to Refresh All button), u get a new pop-up titled "External Data Range Properties" look down pop-up and u will see "Refresh control"
11.Click on refresh every , then click on when you want it to refresh.
12. Click ok, and u are done.
Now, evertime u make changes to your route, it is also updated in your excel spreadsheet.
I have been using Bulzip for several years for applications just like this. I also use this to store purchase and shipping notices e-mailed from on-line retailers. Has been just great, and easier to find than archiving these e-mails.
Hummmm this just might be handy. Maybe gotta try it.
That is just too cool. I directed my print output ( WIN 7) to an XPS printer. Therefore it creates a file which can be viewed with an XPS viewer.
I have run the directions posted by Gladwin to get daily totals (which was the original question) for a trip I will be taking this Spring. I think it works for some applications, but if the goal is to get mileage for each day, when the number of stops per day varies, I don't see how these summary statistics give you that information. I know that you can add the mileages for each segment of any given day to get a daily total, but you are still required to calculate some distances. It appears as thought you may as well go back to the directions panel and just do subtraction. Am I missing something?
I have a great spreadsheet program I use for distances and times.
Can a PDF file be uploaded to this site?
Al
Can a PDF file be uploaded to this site?
Al
Al, I just enabled .PDF attachments. I set the maximum size to 1MB. Is that enough? If not, let me know and I will increase it.
That would be lots but I still haven't figured out how to post a pdf. There seems to be only icons to insert links or pictures.
Al
Al
Click on the 'Go Advanced' button and then look for the 'Manage Attachments' button at the bottom of the screen.
Terry
Terry
Here is the file I mentioned in an earlier post to keep track of progress and arrival times. This particular one is for a trip from Winnipeg to Calgary. This one was originally designed before I had Streets & Trips and a laptop, so it has a lot more waypoints than necessary with a GPS.
I originally made this years ago and is a modified version of one I used as a flight plan when I was a pilot. I now make much simpler ones with fewer waypoints for use on my laptop, I keep the plan and S&T both active and can switch back and forth. After departure, you input your departure time at the top and the program will calculate your arrival time at each waypoint and the destination. As your trip progresses, and you find you are ahead or behind your estimate, you just enter your actual times and the program wiil update all the times. Just replace the times in the ETA column with the actual time. On this particular trip we have planned breaks at Brandon, Regina and Swift current. These stops have an "EX" line for you to enter your departure times.
At The top of the form are cells to enter your estimated average speed and also a cell to enter a speedometer correction in case your speedometer under or overreads. This is not necessary in most cars today but I originally made this in early '90s when a couple of my cars had inaccurate speedometers. It also is a hold-over from my flying days when a head or tailwind would have to be compensated for. We used to make several trips a year to Calgary and using this, we could usually predict our arrival time there within 15 minutes.
This was originally made with Microsoft Works but I also have used it with Microsoft Excel. I have blank versions of this which I could e-mail to anyone interested unless there is a way to upload Excel spreadsheets to this site.
Al
I originally made this years ago and is a modified version of one I used as a flight plan when I was a pilot. I now make much simpler ones with fewer waypoints for use on my laptop, I keep the plan and S&T both active and can switch back and forth. After departure, you input your departure time at the top and the program will calculate your arrival time at each waypoint and the destination. As your trip progresses, and you find you are ahead or behind your estimate, you just enter your actual times and the program wiil update all the times. Just replace the times in the ETA column with the actual time. On this particular trip we have planned breaks at Brandon, Regina and Swift current. These stops have an "EX" line for you to enter your departure times.
At The top of the form are cells to enter your estimated average speed and also a cell to enter a speedometer correction in case your speedometer under or overreads. This is not necessary in most cars today but I originally made this in early '90s when a couple of my cars had inaccurate speedometers. It also is a hold-over from my flying days when a head or tailwind would have to be compensated for. We used to make several trips a year to Calgary and using this, we could usually predict our arrival time there within 15 minutes.
This was originally made with Microsoft Works but I also have used it with Microsoft Excel. I have blank versions of this which I could e-mail to anyone interested unless there is a way to upload Excel spreadsheets to this site.
Al
You could just zip it first.The site already accepts zip files.
Terry
Terry
This spreadsheet is in Microsoft Excel. It can be changed to any trip you wish to plan. Using Streets and Trips, (or road maps) enter your desired waypoints and point to point distances. Simply type in the names and distances in place of those on this sample. Enter your estimated average speed in the speed column. unless you know that your speedometer has an error, leave that cell at zero. Enter your estimated departure time at the top right side. The program will calculate the point to point and ETA times. Note: if my trip will cross 2 or more time zones, I usually enter the departure time in the time zone of my planned overnight stop.) I have it in segments, allowing for lunch or pit stop breaks. If your trip requires more lines, simply insert additional rows to suit. If you require less, simply delete the unnecessary rows
If you find your times are not matching your estimates, simply replace the waypoint time in the ETA column and your times below that line will be adjusted. Also, if you find that your average speed is better or worse than planned, just change the red "AVERAGE SPEED" number.
This sheet is calculated in kilometers but the only thing you need to do to use it in miles is to enter your distances and average speed in miles. I have used it in kilometers, statute miles and nautical miles (when flying).
I also usually print off a copy and have it available should I have a laptop failure. This came in handy a couple of years ago on a trip to Calgary when a spilled glass of Coke burned out my inverter. Another use for a printed copy is when traveling with children, I give them a copy and let them enter the times and calculate the ETAs. Keeps them occupied.
I have this program running on my laptop when traveling as well as MS S&T and you can easily switch back and forth between the two programs.
I may be a bit over the top, using this when I have S&T but after 45 years of flying all over north America, I like to know where I am at all times and when I am going to get where I am going. It would be nice if S&T had a system like this that would automatically update your times like it does with distances.
Al Nelson
If you find your times are not matching your estimates, simply replace the waypoint time in the ETA column and your times below that line will be adjusted. Also, if you find that your average speed is better or worse than planned, just change the red "AVERAGE SPEED" number.
This sheet is calculated in kilometers but the only thing you need to do to use it in miles is to enter your distances and average speed in miles. I have used it in kilometers, statute miles and nautical miles (when flying).
I also usually print off a copy and have it available should I have a laptop failure. This came in handy a couple of years ago on a trip to Calgary when a spilled glass of Coke burned out my inverter. Another use for a printed copy is when traveling with children, I give them a copy and let them enter the times and calculate the ETAs. Keeps them occupied.
I have this program running on my laptop when traveling as well as MS S&T and you can easily switch back and forth between the two programs.
I may be a bit over the top, using this when I have S&T but after 45 years of flying all over north America, I like to know where I am at all times and when I am going to get where I am going. It would be nice if S&T had a system like this that would automatically update your times like it does with distances.
Al Nelson