FlyerTalk Forums - View Single Post - Check out my brave attempt to spreadsheet'ize credit card rewards values

Oct 28, 2011 | 9:37 pm

#13

ThatAdamGuy

Join Date: Jun 2005

Location: Mountain View, CA (near SJC and SFO)

Programs: Hilton Gold, Marriott Gold, IHG Platinum, and no status whatsoever on the airlines (!)

Posts: 481

Hmm, Beltway and others... do you think it'd make sense to have separate "Average point worth [x] cents" row under each credit card that could be modifiable? Or just one "the average airline mile is worth [x cents]" field?

One thing I've been pondering is... how to make this single document useful to everyone. As it stands, since it's universally editable, anyone can test out different numbers (e.g., with the spend, changing 20K to 25K, etc.). But that changes those values for everyone, which could get confusing... especially if the doc becomes popular.

So alternatives are to:
- Create a set of defaults ("For assuming points = 1.5 cents each, see THIS row... for assuming points = 2.0 cents each, see THIS row..."). But obviously that creates clutter.
- Remove all quantitative ROI values. But that would make comparing cards more difficult, and at least some people I chatted with really liked the ROIs-at-a-glance.

Other options?

Reply