Track them miles...
Aug 21, 2001 | 7:04 pm
#1
Original Poster
Join Date: Feb 2001
Location: New Hampshire
Posts: 213
Track them miles...
One of the threads in another group devolved into who was using spreadsheets and other tools to track and plan their miles. I've been using this oddball collection of things to track mine, including a spreadsheet. The problem was the spreadsheet didn't do all of the stuff I wanted (distance calculation, for example). With spare time on my hands I've re-written it to do all kinds of handy mileage tracking and planning things and thought I should share it with my fellow FT'ers.
You can read more about it and download a copy here.
It's less than a day old so some bugs are to be expected. Written & tested using Office 2000. There are a few VB functions.
Enjoy!
You can read more about it and download a copy here.
It's less than a day old so some bugs are to be expected. Written & tested using Office 2000. There are a few VB functions.
Enjoy!
Aug 21, 2001 | 7:15 pm
#2
Join Date: Nov 2000
Location: DTW
Programs: AA Plat 2MM
Posts: 1,048
hey LEB,
I too spent a lot of time building Excel spreadsheets to calculate miles, q miles, per segment, per q mile and per total mile costs. I've got an Excel sheet that works fine too (no macros either). It even gives you 500 miles for flights less than that. I'd be happy to share it if anyone's interested.
However, the best tool I know of for solving "I wanna do this..." challenges is a piece of software (I'm in no way affiliated, nor do I benefit from the plug) called Informed by Shana.
You build a "form" from scratch, with your own fields, calculations and embedded formulas, design it so it presents the way you want it to, and then save it as a template. Then you just create new "records" for each itinerary you want to check. I've even built in a formula to check the airline flown against the elite status my partner and I each hold to calculate elite bonuses. It's great. I have another one I've designed to track frequent flier accounts (YTD miles, lifetime miles, etc.). Your imagination is the limit with this one.
Don't know how much it sells for, but I think there is a demo available. Definitely worth checking out!
Oh yeah, I also have one that tracks my dining in the four iDine programs I belong to. That way I know what's outstanding and unfortunately, how much I spend a month in restaurants just to get miles (eek!).
I too spent a lot of time building Excel spreadsheets to calculate miles, q miles, per segment, per q mile and per total mile costs. I've got an Excel sheet that works fine too (no macros either). It even gives you 500 miles for flights less than that. I'd be happy to share it if anyone's interested.
However, the best tool I know of for solving "I wanna do this..." challenges is a piece of software (I'm in no way affiliated, nor do I benefit from the plug) called Informed by Shana.
You build a "form" from scratch, with your own fields, calculations and embedded formulas, design it so it presents the way you want it to, and then save it as a template. Then you just create new "records" for each itinerary you want to check. I've even built in a formula to check the airline flown against the elite status my partner and I each hold to calculate elite bonuses. It's great. I have another one I've designed to track frequent flier accounts (YTD miles, lifetime miles, etc.). Your imagination is the limit with this one.
Don't know how much it sells for, but I think there is a demo available. Definitely worth checking out!
Oh yeah, I also have one that tracks my dining in the four iDine programs I belong to. That way I know what's outstanding and unfortunately, how much I spend a month in restaurants just to get miles (eek!).
Aug 21, 2001 | 7:43 pm
#3
FlyerTalk Evangelist
Join Date: Apr 2001
Location: DCA
Programs: AMC MovieWatcher, Giant BonusCard, Petco PALS Card, Silver Diner Blue Plate Club
Posts: 22,314
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">Originally posted by rpmkwpw:
That way I know what's outstanding and unfortunately, how much I spend a month in restaurants just to get miles (eek!).</font>
That way I know what's outstanding and unfortunately, how much I spend a month in restaurants just to get miles (eek!).</font>
Taking a (hopefully) lady friend to lunch at the end of the week, so deciding where to go... and I settled on sushi because it was on idine's list.
I need help.
Aug 21, 2001 | 8:42 pm
#4
Join Date: Feb 2001
Location: MCI ** UA Silver, Bonvoy Lifetime Titanium
Posts: 1,297
<font face="Verdana, Arial, Helvetica, sans-serif" size="2">Originally posted by rpmkwpw:
You build a "form" from scratch, with your own fields, calculations and embedded formulas, design it so it presents the way you want it to, and then save it as a template. Then you just create new "records" for each itinerary you want to check.</font>
You build a "form" from scratch, with your own fields, calculations and embedded formulas, design it so it presents the way you want it to, and then save it as a template. Then you just create new "records" for each itinerary you want to check.</font>
Aug 22, 2001 | 4:52 am
#5
Original Poster
Join Date: Feb 2001
Location: New Hampshire
Posts: 213
rpmkwpw, thanks for the "plug" information I'll check into it. The nice thing about excel is it's something of a virus and most folks have it by now. 
My spreadsheet also does the 500 mile minimum, level of status bonus, and will take a itinerary like "bos-phl-sfo-bwi-pit-bos" apart and calculate all of the great circle distances, etc..
I'd be interested in looking your spreadsheet for new ideas and to learn. Taking apart strings and doing loops I didn't have any idea how to do in the spreadsheet.
My spreadsheet also does the 500 mile minimum, level of status bonus, and will take a itinerary like "bos-phl-sfo-bwi-pit-bos" apart and calculate all of the great circle distances, etc..
I'd be interested in looking your spreadsheet for new ideas and to learn. Taking apart strings and doing loops I didn't have any idea how to do in the spreadsheet.