Chase Sapphire Preferred vs Amex SPG - Which Card Do You Reach For First?

[bubbles]

If I knew how to work it I might be able to provide feedback

link

still haven't figured out how to use my chart? 

[Dan]

link

still haven't figured out how to use my chart? 

Excel ain't my forte.

[bubbles]

Excel ain't my forte.

hopefully this will be easier for you. i set it up that you have the freedom, ink bold (w/ checking), ink classic, spg and sp. i also valued each spg at 2.3 cents and each ur at1.9. now just type in a purchase under a category

[AsherO]

hopefully this will be easier for you. i set it up that you have the freedom, ink bold (w/ checking), ink classic, spg and sp. i also valued each spg at 2.3 cents and each ur at1.9. now just type in a purchase under a category

It looks cool, but it's missing some things, like SP offers 2 points per $1 spent on travel and dining.

[bubbles]

It looks cool, but it's missing some things, like SP offers 2 points per $1 spent on travel and dining.

No it has that

[AsherO]

No it has that

Didn't work for me. Could be it's because I use the Office 2003 Compatibility Pack to convert it so I can open it with Office '03.

[bubbles]

Didn't work for me. Could be it's because I use the Office 2003 Compatibility Pack to convert it so I can open it with Office '03.

I doubt it. Its a simple SUM formula.

[AsherO]

I doubt it. Its a simple SUM formula.

At the SP line, I didn't see the factoring 2x for dining and travel, what cell should I be looking at to see that?

I put $100 into dining, and it told me to use the Freedom card (it was the default, and didn't change when I put $100 in dining).

[bubbles]

At the SP line, I didn't see the factoring 2x for dining and travel, what cell should I be looking at to see that?

the formula is "IF(A7="X",SUM((B2:AC2,C2,D2,E2,F2,G2,H2,I2,J2,K2))*(1.07),0)" so the first point is included in B2:AC2 and the second is C2

I put $100 into dining, and it told me to use the Freedom card (it was the default, and didn't change when I put $100 in dining).

thats because freedom has 5% for dining now. try putting 100 into travel

[AsherO]

the formula is "IF(A7="X",SUM((B2:AC2,C2,D2,E2,F2,G2,H2,I2,J2,K2))*(1.07),0)" so the first point is included in B2:AC2 and the second is C2
thats because freedom has 5% for dining now. try putting 100 into travel

I stand corrected. I commend your Excel erudition, I'm probably going to learn a thing or two from how you coded this spreadsheet.

[bubbles]

I stand corrected. I commend your Excel erudition, I'm probably going to learn a thing or two from how you coded this spreadsheet.

Would you believe this was the first time I used excel? Look what a little boredom and playing around can do

[AsherO]

Would you believe this was the first time I used excel? Look what a little boredom and playing around can do

Hard to believe. How long did it take you?

[bubbles]

Hard to believe. How long did it take you?

hard to say, I did it in bits and pieces. just browsing through and familiarizing myself with some of excels functions took some time as did looking up the card details

[DovidR]

Keep in mind that for lodging, a starwood business card with OPEN, which gives 5% back for certain hotels (I don't recall which ones) PLUS  the usual 1 point per dollar spent may well be a more worthwhile card to use over SP which gives 2 points but no cash back.

[Dan]

Bubbles, the Excel spreadsheet is very cool now that I have it working.

I would add the Open Savings categories for AMEX Business cards like SPG Business or Open Gold.
Also have to figure out how to adjust Freedom and Ink Bold if people do or don't have Chase checking.
And have to figure out how to adjust Ink Bold up to 1.5/1.65/1.675 ppd based on if you plan on spending $25K/$50K/$100K in a 12 month period.

[AsherO]

Bubbles, the Excel spreadsheet is very cool now that I have it working.

I would add the Open Savings categories for AMEX Business cards like SPG Business or Open Gold.
Also have to figure out how to adjust Freedom and Ink Bold if people do or don't have Chase checking.
And have to figure out how to adjust Ink Bold up to 1.5/1.65/1.675 ppd based on if you plan on spending $25K/$50K/$100K in a 12 month period.

Don't give the guy a hard time, for an Excel n00b he did an amazing job.

[bubbles]

Don't give the guy a hard time, for an Excel n00b he did an amazing job. 

thnx but I asked for the feedback

Bubbles, the Excel spreadsheet is very cool now that I have it working.

I would add the Open Savings categories for AMEX Business cards like SPG Business or Open Gold.
Also have to figure out how to adjust Freedom and Ink Bold if people do or don't have Chase checking.
And have to figure out how to adjust Ink Bold up to 1.5/1.65/1.675 ppd based on if you plan on spending $25K/$50K/$100K in a 12 month period.

Let me know what the OPEN savings are and can add it no problem
Thats an easy fix
Also I can add that in but you would have to know ahead of time that you plan on spending that much. Don't think I can make it track your spending easily

[bubbles]

Didn't work for me. Could be it's because I use the Office 2003 Compatibility Pack to convert it so I can open it with Office '03.

nothing major but you will lose the formatting during the conversion process

[AsherO]

nothing major but you will lose the formatting during the conversion process

Yup, I noticed that warning.
________________

I don't know if revolving categories are good to include in a spreadsheet, as they would require constant updates.

[Dan]

thnx but I asked for the feedback
Let me know what the OPEN savings are and can add it no problem
Thats an easy fix
Also I can add that in but you would have to know ahead of time that you plan on spending that much. Don't think I can make it track your spending easily

https://www257.americanexpress.com/opensavings/openpartners.do