Creating a Calendar from Microsoft Streets & Trips | Google Earth, Maps, and Navigation | Forums

 Posted by on July 13, 2010
 
  • Everyone is welcome to view the Forums.  Only paid members can post.  You can certainly join right now if you want!
  • Watch this video to learn how to post a question.
  • Please  ask your questions here (not in email) – we promise to respond.
  • If you lead a computer club, or teach others on computers, let us know.  We'll add you to a special "Teachers Lounge" forum.

Please consider registering
guest

Log In

Lost password?
Advanced Search:

— Forum Scope —



— Match —



— Forum Options —




Wildcard usage:
*  matches any number of characters    %  matches exactly one character

Minimum search word length is 4 characters - maximum search word length is 84 characters

Creating a Calendar from Microsoft Streets & Trips
July 23, 2011
3:54 pm
John Schafer
Trabuco Canyon California
New Member
Forum Posts: 1
Member Since:
March 20, 2011
Offline

I have created a 100+ day using Microsoft Streets & Trips 2011.  We know the date we are starting (March 2, 2012).   Given that there are certain places we need to make advance reservations at, is there a way to import or create a calendar that starts March 2 2012 from Microsoft Streets and Trips that then shows the corresponding calendar dates that we could be at each planned stop?

 

Thanks, John

July 23, 2011
10:10 pm
David Cross
Fulltime RVer. Home is where I park it.
Member
Forum Posts: 83
Member Since:
August 5, 2010
Offline

John,

This is something I have been asking Microsoft to do for the past 8 or 9 years. For now, it can't be done. I use two methods to keep track. I create a spreadsheet with the days down column A with the location I am planning to be at on each day in column B and a notation of my reservations in column C.

In the S&T file, I use the rename function to add the date(s) and location as the name of each location along with the number of nights I will spend in each location. Here is an example of the S&T names:

12/31/10 Mesa, AZ – View Point RV and Golf Resort (1 night)

01/01-01/09 Earp, CA – Emerald Cove Resort – RPI – 34.20853°N 114.22413°W (5 nights)

01/10 La Quinta, CA – Walmart (1 night)

01/11-01/15 Indio, CA – FMCA Rally (5 nights)

and here is the spreadsheet for the same period:

Friday, December 31, 2010 Mesa, AZ – Viewpoint Golf Resort
Saturday, January
01, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred Confirmation # 1681714 on 11/10/2010
Sunday, January
02, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Monday, January
03, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Tuesday, January
04, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Wednesday, January
05, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Thursday, January
06, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Friday, January
07, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Saturday, January
08, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Sunday, January
09, 2011
Earp, CA – Emerald Cove Resort – RPI Preferred
Monday, January
10, 2011
La Quinta, CA – Wal*Mart Supercenter Meet Golden Spike group at Walmart
Tuesday, January
11, 2011
Indio, CA – FMCA Western Area Rally – Riverside County Fair and National
Date Festival.
Paid – FMCA Western Area Rally in Indio, CA
Wednesday, January
12, 2011
Indio, CA – FMCA Western Area Rally – Riverside County Fair and National
Date Festival.
FMCA Western Area Rally in Indio, CA
Thursday, January
13, 2011
Indio, CA – FMCA Western Area Rally – Riverside County Fair and National
Date Festival.
FMCA Western Area Rally in Indio, CA
Friday, January
14, 2011
Indio, CA – FMCA Western Area Rally – Riverside County Fair and National
Date Festival.
FMCA Western Area Rally in Indio, CA
Saturday, January
15, 2011
Indio, CA – FMCA Western Area Rally – Riverside County Fair and National
Date Festival.
FMCA Western Area Rally in Indio, CA

 

Day after day as I try to remember, I find my forgetter working better and better.
July 24, 2011
9:10 am
MrsGeek
Admin
Forum Posts: 645
Member Since:
July 2, 2010
Offline

Hey David,

I love your spreadsheet!  Wouldn't it be great if the Streets program allowed you to Expand the route planner and include a date column as well as custom columns, like Comments for your reservation numbers?  They surely can do this … if enough of us ask.  I will let our contacts know ..

Another good place to post this would be in laptopgpsworld.com

Meanwhile, something I find helpful is to print the route with the option of the Route Summary.  Then, in the segment detail area I can pencil in the date.  This is all completely manual, but it's something I can keep referring to anyway.  To see the Summary option I'm talking about – watch Printing video in the Streets and Trips series.

February 17, 2012
11:35 am
Barbara Dalderis
Northern CA
Member
Forum Posts: 43
Member Since:
September 20, 2010
Offline

David,  Thanks so much for this tip.  I've been downloading my MSST route onto an Excel file (using the MSST function) and then spending a lot of time editing to produce a informative itinerary with dates, confirms, etc.  Your idea is much better.

 

I also learned recently that you can eliminate via points using rename.  To force MSST to follow the route you want you often have to put in a stop as a via point.  I just use rename and delete the stop name and replace it with a space (using space bar).  Then it doesn't show up!

Forum Timezone: America/New_York

Most Users Ever Online: 46

Currently Online:
13 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

David Cross: 83

Bob Brown: 59

Barbara Dalderis: 43

S Allan Wilson: 43

Jim Bass: 37

Bill Osborne: 35

Member Stats:

Guest Posters: 34

Members: 1341

Moderators: 3

Admins: 4

Forum Stats:

Groups: 3

Forums: 18

Topics: 532

Posts: 1789

Newest Members: Dennis Sivits, Kenneth Storey, Garnett Von Eiff, Victoria Rains, hagit amitay, Merin Hawkins

Moderators: Christine Guld (0), Jim Guld (-1), rvnavigator (9)

Administrators: MrGeek (162), MrsGeek (645), Via Email (3), charlyleetham (0)

Powered by WishList Member - Membership Site Software