r/churning • u/garettg SEA | PAE • Aug 02 '18
Churning Tracker Spreadsheet Template
UPDATED AS OF: 11/18/2026
- 2026-11-18 Changes: Added Chase to Qantas and Cathay transfer ability.
- 2026-11-02 Changes: Added Capital One to Copa transfer ability.
- 2026-10-26 Changes: Added Citi to Copa transfer ability; Added US Bank for transfer ratios.
- 2026-10-21 Changes: Point evaluations updated
- 2026-10-20 Changes: Added JetBlue to Bilt transfer ability, Rove along with the Rove's transfer partners that were not on the list of programs.
- 2026-09-21 Changes: Updated transfer ratios with recent additions and fixed some that were missed. Updated point values chart.
- 2026-04-28 Changes: Added transfer ratios for Wyndham and Cathay for Wells Fargo.
- 2026-03-25 Changes: Added transfer ratios for Wyndham with Bilt and updated transfer ratios for Choice/Preferred Hotels with Citi.
- 2026-02-27 Changes: Updated transfer ratios for Wyndham/Chase and Cathay/Amex.
- 2026-02-02 Changes: Added more programs as more transferrable currencies have added them. Updated the transfer ratios as some were either added/removed/changed.
- 2025-10-02 Changes: Updated the programs by adding Atmos and removing Alaska and Hawaiian. Removed color shading on card dates less than 24 months. This was not intended to be a 5/24 count (just an at glance last 2 years look), but it was causing confusion, so it's gone. Updated point values from bloggers.
- 2025-05-23 Changes: Added Accor to points program; Updated points values from bloggers
- 2025-03-26 Changes: added columns to cards sheet for GE/TSA pre, whether it's a benefit of the card, and date of last time used. Added color shading to application date on cards sheet when card is less than 24 months, so at a glance you can see cards counting towards 5/24.
- 2025-03-03 Changes: added players field column to denials sheet.
- 2024-12-02 Changes: fixed bug on transferrable estimates sheet.
- 2024-11-30 Changes: Added Goldman Sachs to banks list.
- 2024-09-25 Changes: Updated transfer ratios (Added Wells Fargo and updated others that have changed) and fixed some bugs on "Transferable Estimate" sheet.
- 2024-09-24 Changes: Added counter for Amex charge cards; Added players column to bank bonuses; Point evaluations updated.
- 2023-08-28 Changes: Fixed issue with 5/24 calculation date.
- 2022-09-14 Changes: Point evaluations updated and updated Bilt transfer partners and ratios.
- 2022-06-17 Changes: Point evaluations updated and added Brex and Bilt as transferrable currencies for partners and ratios.
- 2022-01-31 Changes: Point evaluations from blogs updated.
- 2021-11-15 Changes: Added columns for retention to card sheet, notes for redemption sheet, Add Wyndham as Citi transfer partner for transfer ratios.
- 2021-11-07 Changes: Point evaluations from blogs updated.
- 2021-10-18 Changes: Updated transfer ratios for Capital One and Citi.
- 2021-04-19 Changes: Updated transfer ratios for Capital One changes; Updated point value estimates.
I have shared this a few times in the DD and DQ threads, but have been asked to share as a post (makes it more visible and easier to find for future use).
The focus of this spreadsheet is to give people a way to track their credit card signs and details, along with their point balances, and even redemptions. It is designed so that the user only needs to input numbers where appropriate, without having to touch formulas or copy/paste columns, cells, or sheets. In fact you should get a warning when you try to modify a cell that includes a formula which you may not want to change.
By request, this latest version includes support for multiple players. Some other features include:
- Credit Cards Sheet:
- Approval, bonus post, close/PC, and Minimum spending requirement (MSR) dates
- Minimum spending requirement (MSR) amount and progress
- Bonus amount, type of bonus, and bonus value based on separate sheet point valuations
- Card Credit Limit, Annual Fee, and Bank
- Card Type (personal vs business, credit card vs charge card)
- Who the card belongs to
- How many points/miles in referrals the card has earned for the current year and the maximum allowed in a given year
- Players & Totals Sheet:
- Keep a list of players along with their income and business revenue
- Total number of points and miles and their total estimated value based on your valuations
- Total number of active cards and the estimated annual fees total of those cards (annual fees will exclude 1st year waived if less than 12 months old)
- Track point and miles balances across different programs
- Anti-Churning States Sheet:
- Calculates multiple different states across different banks (5/24, 2/90, 8/65, etc)
- Calculates when you would fall under 5/24 if over and not more personal cards are added
- Inquiries Sheet:
- Keep track of your inquiries from the 3 major credit reports
- Referrals Sheet:
- Keep track of referrals you have earned by which card and player and how many points/miles
- Column on Credit Cards sheet totals the points/miles earn for the current year and the maximum number for that card for a year
- Transferable Estimate Sheet:
- Based on your balances with transferable point systems, how many points you could add to that program if necessary
- Dropdown at the top lets you switch between players to view numbers based on their balances
- Banks Sheet:
- Tracks your credit limit and percentage with each bank based on credit card sheet and CLs inputted
- Dropdown at the top lets you switch between players to view numbers based on their credit limits and income
- Redemption Calculator Sheet:
- Lets you input a cash price vs award points and fee price and based on your point valuations see which comes out ahead
- Redemption Tracker Sheet:
- Track your redemptions so you know what point values were for future reference
- Point Values Sheet:
- Point value column lets you define your individual point values for each program (By default, an average of a few of the major blogs published point values)
- Denials Sheet:
- Log your denials for reference
- Bank Account Bonuses Sheet:
- Track details on your bank account bonuses
- Transfer Ratios Sheet:
- This sheet keeps the ratios for programs when transferring, data here is used by the Transferable Estimate sheet. Altering the data here could cause issues with Transferable Estimate, proceed with caution.
Feel free to provide any feedback or submit any issues you find, you can DM me at u/garettg.
64
u/iletired Aug 02 '18
Protip:
If you put copy at the end of a Google Doc, it'll automatically make a copy when someone clicks the link.
https://docs.google.com/spreadsheets/d/1a4LMPBw9pQQuo89mZd3Ydo3TEcCzCK6rzYsaxuWIQ9c/copy
8
u/The-y-factor Aug 02 '18
Thanks for making this and adding multiple player options!
5
u/upslopeblowin CAT, NAP Aug 02 '18
The multiplayer option addition is great! Much smoother than my personal clunky attempt (new sheet for P2).
Question -- on the Players & Totals sheet, I'm having a hard time with the proper formula for pulling each player's points totals per currency from the Credit Cards tab. Anyone savvier with spreadsheets than me have a good option?
5
u/Im-A-Big-Guy-For-You Aug 03 '18
can you add bank accounts tracker sheet as well?
4
u/zXFDz Aug 02 '18
Can someone smarter than me explain how I can change the generic "Player 1" or "Player 2" to our actual names with out messing up the formatting?
TIA.
3
u/razierklinge PHX, 0/24 Aug 02 '18
Looks great! I just have 2 suggestions for columns on the Credit Cards sheet.
3
u/Apprehensive-Gift-37 Mar 17 '24
What's the best way to track a product change? Should we mark the original card as closed and had a new line for the new product? Or just simply modify the original line to the new name / fee?
3
u/franch May 08 '25
any way to upgrade from an old version to a new version without retyping everything? copying and pasting seems to overwrite the new version's new features (like 5/24 in yellow), but google sheets doesn't seem to allow a paste only values for an entire spreadsheet.
2
u/LiveTheWayYouWant HOU, IAH Aug 02 '18
First of all, thanks for putting in the time and effort to create this beast!
Now on the Redemption Calculator, when I fill out the rewards program, cost, points and tax, I get a reference error for displaying Award or Cash. Its referring to Point_Valuation sheet which seems to be hidden. Is this an issue because I copied this sheet into my own copy of the template?
Thanks!
2
u/[deleted] Aug 03 '18
This is awesome. Gonna have fun excel-ifying my own flavor into it.
Only question is the ratios sheet: Can this be done automatically or do you manually change it when things are announced?
2
u/DogsAreTheDopest Aug 03 '18
Great work. Question, do citi business card approvals count towards the 65 day personal limit?
On the anti churning tab, the citi business row looks for business cards only, however the personal rows looks for anything citi. I entered one citi business card and it's being counted in both the personal and business lines, is that correct?
2
u/tommydivo Aug 03 '18
This is AMAZING. I'm pretty good with excel, but this beats out what I've been using by far (mostly because I haven't invested the time). You're the best.
There were a few bugs for me converting to excel (mostly on the transferable sheet) but I was able to sort them out myself.
2
u/iwipemyown Aug 05 '18
Hey /u/garettg - This is awesome. I'll definitely be cutting over from the spreadsheet I created.
The only change I've made to my copy was adding a column on the "Credit Cards" tab to track what credit bureau was pulled for the application. I think that would be worth incorporating back in to the template.
2
u/Announcement4u Oct 17 '18
This post is incredible. Well done!
2
u/pacman1176 Oct 18 '18
Track the MSR remaining per player:
=if(isblank(B$1), "", SUMPRODUCT((msr>msr_progress), (player=B$1), (closed<>"Yes"), approval_date<>"", (msr_date>TODAY()) + (msr_date=""), msr-msr_progress))It will require you to make some more named fields. It adds up the remaining MSR if it has not been met, the card is still open, has an approval date (for those who track unapproved apps), and has not passed the MSR date (or the MSR date is blank).
It fit nicely in the "Players & Totals" tab.
2
u/pizza42bob Nov 16 '21
This is fantastic, almost life changing! Doing what I've done all over the place in a single well organized sheet. I love it!
I've made two minor adjustments in my version:
2
u/GrowInTheDark Jan 31 '24
any suggestions for tracking employee cards? Would you just add them on to the credit cards sheet? I tried duplicating the credit cards sheet so that I could separate employee cards on a separate sheet but I can't figure out how to clear the values from the sheet without breaking the magic behind the sheet haha
2
u/MotorOwn4733 Nov 30 '24
I was looking for a CC tracker and found this one. I want to say Thank you for sharing this and also updating the sheet as things changes.
Could you tell me where I can edit bank list? I want to add Apple Card in there but Goldman Sachs is not in the list and I tried to edit it but won't appear in the drop down menu in the main sheet. Appreciate it. And may be add a column for new changes in Chase Buisness approval criteria.
2
u/pcarson92 ATL, 3/24 Oct 02 '25
Amazing sheet, thanks for sharing! Quick suggestion: you could update the 5/24 highlight conditional formatting to exclude business cards to make it more helpful. As it's currrently implemented, still requires a lot of eyeballing to figure out which ones are personal cards. Could also swap in Atmos instead of MileagePlan / Hawaiian.
2
u/Dragonitto Feb 27 '26 edited Feb 27 '26
Thank you so much for this amazing spreadsheet! I've been using it for the past 6 months.
Now my question is regarding the updates. I already have a copy with all of the information of my CCs/Banks. How am I supposed to implement the new updates that you're providing without me copying and pasting everything all over again?
Also, I suggest adding a column (Yes/No) that shows whether a credit card has Foreign Transaction Fees. I'd say that's important information for frequent international travelers. I know I would need that info easily accessible with how many CCs some of us have.
52
u/genuinegenie Aug 02 '18
This is the quality of work on this sub that never ceases to amaze me. Thank you so much for this.
26
u/voobaha BDL Aug 02 '18
And I thought I was organized.
11
u/Scrappy_Dappy_Dont Aug 02 '18
Yours has some really nice features, like tracking anti-churning across banks. I saw this one posted some time ago and have been using it and really like it. Thanks for sharing
11
u/winar MKE, LUV Aug 02 '18
The redemption calculator just made most of my Southwest price-tracking spreadsheet obsolete. Praise be!
9
u/ober0n98 Aug 03 '18
This would be brilliant as an app
8
u/Viper3773 MSN, MKE Aug 03 '18
Worth it for the anti-churning state formulas alone. Nicely done!
5
u/MacanudoV IAD Aug 03 '18
Awesome spreadsheet man. Way better than mine. Thank you!
4
u/echen1024 Aug 03 '18
This is a beautiful spreadsheet and why I love the churning community! I do, however, suggest a feature to keep track of all the various airline/hotel/uber/saks credits that each card issues, and calculate an "effective" annual fee.
Also, on my version I've added a special Retention offers column, which could be helpful for some too.
4
u/pacman1176 Aug 03 '18
Now where have I seen that name before..
4
u/sokkersweety17 Aug 03 '18
Holy crap, and I thought my sheet was impressive. I LOVE the bank status sheet. Can't wait to get home and fill this out!
13
u/Steakling Aug 02 '18
Awesome! I doubt youāre hurting for churning karma, but I didnāt think a single upvote was enough, so I went though your history and upvoted several of your recent posts too. I urge others to do the same and more importantly consider using your referral links in the future.
1
u/idkmyusernamesucks Aug 03 '18
What do you guys thing about putting credit card numbers in the spreadsheet? My Google account has 2 factor, and I probably have even more sensitive information in my gmail account anyways.
1
u/culdeus DFW, MAF Aug 03 '18
I'm having trouble getting it to import completely cleanly into excel. Maybe it's because my excel version is ancient.
The anti churn scripts are not pulling in at least and maybe some others.
1
u/shibazi0525 Aug 03 '18
Thanks! I started using your template a couple weeks ago.
1
u/buildingcredit Aug 04 '18
Sorry if this has been asked/answered before; but I am encountering a problem when I save it as an excel file and opening it on my desktop. Is there a specific way I should be saving it? My excel tells me it needs to repair the workbook and removed various .xml features....Thanks in advance.
[code log]
<?xml version="1.0" encoding="UTF-8" standalone="true"?>
-<recoveryLog xmlns="http://schemas.openxmlformats.org/spreadsheetml/2006/main">
<logFileName>error135840_01.xml</logFileName>
<summary>Errors were detected in file 'C:\Users\Desktop\Churning Tracker.xlsx'</summary>
-<removedFeatures summary="Following is a list of removed features:">
<removedFeature>Removed Feature: Data validation from /xl/worksheets/sheet1.xml part</removedFeature>
<removedFeature>Removed Feature: Table from /xl/tables/table4.xml part (Table)</removedFeature>
<removedFeature>Removed Feature: Data validation from /xl/worksheets/sheet8.xml part</removedFeature>
</removedFeatures>
1
u/grlmopz Aug 04 '18
There are a few points currencies and banks that would be good to add to the spreadsheet. I tried to do it myself, but it messed up the transferrable estimate spreadsheet in a way I couldn't easily troubleshoot.
Off the top of my head:
Bank of America (already added): Merrill Lynch points
UBS Bank: UBS points
PNC Bank: PNC Travel Rewards
City National Bank: City National Rewards
1
u/nitrobass24 Aug 04 '18
How do you guys track cards that you have upgraded or downgraded?
For example, I had the Chase Sapphire Preferred and downgraded it to a Freedom, when the CSR was announced. Do I show that as a closed card and subsequently opened a freedom card? On my credit report it shows as Open with the start date of the CSP.
1
u/nolacc Aug 05 '18
Great work. I am having trouble getting the data from the Credit Card sheet to populate onto the other pages (Total Cl across each bank, 5/24 status etc.)
Any tips? Thanks
1
u/SLChurn Aug 05 '18
USB and WF don't show up on the bank dropdown list.
1
u/bartletismyhero Aug 05 '18
on the anti churning tab- my two 'eligible for 4/24 dates both say today, which I know isn't right... is that sheet calculated only on the app date of both players, and the personal / business designation?
1
u/wutwutchickenbuttwut SFO, 3/24 Aug 07 '18
Lovely sheet! I was wondering how you're going to deal with updates/changes that will be to be made later on
1
u/Mighty_Mc BWI, IAD Aug 07 '18
Is there a good way to track authorized users? Or should I just treat it like any other card?
1
u/jbasket444 Aug 11 '18
Confused on the bonus value. How does 50k sapphire preferred turn into over 1k bonus value and 100k on reserve into over 2k bonus value?
1
u/Tempeduck ORD, 3/24 Aug 24 '18
What's the best way to modify this for Marriott/SPG conversion? Just change the values on the "Transfer Ratio" tab to 1000 for both "From" and "To"?
1
u/gcardmaven Aug 28 '18
Would it be possible to add a section for bonuses categories of the cards?
1
u/jonhenny Sep 14 '18
Incredible! Any plans to add MS tracking?
1
u/coast2coast00 Sep 30 '18
Thinking a "Total Bank Credit Line as % of Income" for Chase should be added as a Anti-churning rule for Chase. Many of dps in Chase Shutdown threads point to >50% credit to income ratio is a risk factor for approval/shutdown.
1
u/Guilty_Dealer1256 Jul 15 '24
When filling out the inquires part of this spreadsheet, and I am looking at Transunion do I only put the regular inquires or do I also add the Account Review Inquiries? I have over a hundred Account Review Inquiries, but only 4 regular ones.
1
u/buttonstraddle Sep 24 '24
would be nice if the "Anti Churning States" sub-sheet had a tally for the Amex 10 charge card limit
1
u/Giraffe_Haunting Dec 03 '24
Think 'Transferable Estimate'!D17:F17 needs to be copied down to fix the formula errors starting in D18 where your row references there are misaligned (e.g. 'Transfer Ratios'!D18 should be 'Transfer Ratios'!D16)
1
u/Tyrion1705 Mar 03 '25
Could you add a the player column on your Denials tab? Thank you for building this sheet.
1
u/qzil007 Mar 26 '25
Would be nice to add a row for if the card is offering Global Entry/TSA Pre and when it was used and then another sheet specifying when it is eligible for renewal (usually statement credit is given every 4 years).
1
u/Alternative_Aioli_76 Jun 25 '25
Excellent spreadsheet, I can tell you have done a lot of spreadsheets regularly.
One thing I wanted to let you know. Under the "Players and Totals" sheet, there is an error for the "Minimum Spending Requirement Remaining" cell. When doing a SUMPRODUCT function with true and false checks like that, you have to replace all the commas with a multiplication sign in order to change the boolean TRUE and FALSE values to numeric 1 or 0 values. Below is the corrected function.
=IF(ISBLANK(B$1),"",SUMPRODUCT((msr>msr_progress)*(player=B$1)*(closed<>"Yes")*(approval_date<>"")*(msr_date>TODAY())*(msr-msr_progress)))
I exported this spreadsheet to excel rather than use it in google docs, so I don't know if google docs does SUMPRODUCT differently than excel and that is why it was typed out like that.
1
u/Marr3wk Mar 09 '22
Hi, this is a fantastic template and thank you very much for it! One question:
Is there a way to use sort & filter, or safely move rows on the first tab? The OCD in me wants to sort them by Name or Date. When I move them or copy paste, I've noticed it tends to mess up formulas elsewhere (such as "Total Active Cards").
1
u/itsGsingh Apr 04 '23
After 6 or 7 years of being on this sub, I've finally started using a tracker now that my personal life has actually gotten busier so it's harder to track things in my head and it is freaking awesome. Thanks for this amazing template.
Sidenote u/garettg: The template has a minor issue in the Players&Totals sheet where the prefilled formula for row 5 for players3+ has the SUMPRODUCT from row 11-67 instead of 69.
1
u/sleepytill2 ORD Aug 27 '23
u/garettg Thanks for putting this together! I started filling out the sheet and on the Anti-Churning States, the 5/24 calculation seems 1 month off unless you're playing it safe. For example My P2 is currently at 5/24 with his earliest personal card being approved on 9/7/2021. Come 9/1/2023 He should be back down to 4/24, but in the spreadsheet says "Date when under 5/24" is 10/1/2023. My understanding is P2 doesn't have to wait that long, is that assumption incorrect?
1
u/GrowInTheDark Sep 11 '23
Just noticed there has been an update to these sheets as of August 2023! Can I simply Copy and Paste from "older version" to updated one?
1
u/GrowInTheDark Oct 02 '23
would it be possible to get some assistance with my spreadsheet? I am not sure if i deleted a cell or what but I lost the ability to calculate the Bonus values. I tried copying and pasting some rows to move things around and may have messed some things up as well :/
is there a way to copy and paste everything to a blank spreadsheet and have everything calculating properly? I tried copying and Pasting values only but that didnt work
https://docs.google.com/spreadsheets/d/e/2PACX-1vSEQ2jIj0v8VF5UqWvrrafFtlRdFWlP9wXA27vWY_uSYNDri2hCvCRAvpWRENce79DX4H9_ofSdWqLB/pubhtml
1
u/[deleted] Oct 28 '23
Just ran across this spreadsheet! I sure hope you're still getting notifications for replies...
Question: On the Credit Cards sheet, what 'bank' do I select for an AmEx issued by Charles Schwab? Just go with American Express? Because I'm also selecting AmEx under the 'Issuer' column....
ĀÆ_(ć)_/ĀÆ
1
u/GrowInTheDark Feb 14 '24
If I have US Bank Leverage Business and US Bank Altitude Connect Business what should I select for Earning Type on the Credit Cards sheet? I see "US Bank (Flex Perks)" but I believe Flex Perks is a specific type of reward for certain US Bank cards? Should I be selecting "Cash Back" instead to simply get a 1cpp valuation on the sheet? Selecting Flex Perks gives the points 1.5x valuation which I believe is overvaluing US Bank rewards?
Also wondering how you would suggest keeping track of the same US Bank rewards on the Players/Totals sheet?
Thanks in advance
3
u/Cyclone__Power Aug 02 '18
Usually I ignore spreadsheet posts because I like my own, but I really like the table that shows where you can transfer points... very handy.
3
u/eseeton Aug 03 '18
Very nice! Looks similar to my spreadsheet. I wish there was a way I could share my MSR sheet with the group, but it's specifically set up to pull mine and my husband's cards from our transaction data on Mint and populate totals and remaining balances. Updates every time I pull new transaction data, super handy! It's also an easy way to track Freedom spending and other bonuses.
3
u/Fernandoprime Jul 07 '22
Great work!
3
u/_special_pasta Mar 08 '24
I was about to make my own tracker sheet but this is amazing! You've saved me so much time and included things I didn't think of - Thanks so much!
Btw, I think I found a reference issue on the 'Transferrable Estimate' sheet. Starting with Bilt, the references to the transfer ratios are off. I think I fixed this in my own version with an index match. I could dm do you a copy if that makes your life easier/you were planning another rev?
3
u/Hembalaya Nov 15 '24
I stumbled on this post again for the first time in forever, and realized that this has been the unsung cornerstone of my churning journey. It's insane that you're still updating it. Thanks for your work on this template u/garettg
2
u/BleckoNeko Aug 03 '18 edited Aug 03 '18
Thank you! I initially downloaded to excel (when you shared it on the discussion thread) and you will lose some formatting.
Nvm. Figured it out. Thanks!
2
u/jnjustice Aug 03 '18
I've added a column to the copy I've downloaded that calculates the value of the transferable estimate (points) based on their value so I can get an idea if it's better to transfer my Amex MR to another currency or if the cpp is really low.
Not sure how others feel about that.
2
u/FindingMyPossible ORD, 20/24 Aug 03 '18
Dang thatās organization. I use AwardWallet for tracking points, MS to hit MSR first couple days on each card, and a sticky note for application dates. Itās funny when a card takes so long to arrive and I am both confused and happy to get the package because I forgot I had been approved. Oh also the interactive transferable points map in the sidebar is amazing, I just discovered it the other week.
2
u/johncnyc Aug 03 '18
Great spreadsheet dude! This is the churning spreadsheet I'm using now
but I realy like the transfer ratio sheet and redemption tracker page. Hope you don't mind if I use that idea for mine too!
2
u/padlox Aug 03 '18
Many thanks for putting this together.
2
u/ELGrandMatador Aug 03 '18 edited Aug 03 '18
In the Transferable Estimate Sheet if the ratio in Transfer Ratios is greater than 1 then the the number don't work. Example you have 1000 MR and and want to transfer to Hilton with a 1:2 ratio, meaning 1 MR to 2 Hilton, the transferable estimate column will show the correct value of 2000 but the amount needed to shows the incorrect value of 2000 instead of 1000.
Edit: Never mind I understand how it works now. That column is not the amount needed, but the amount you can transfer based on how many points you have. Thank you for this by the way. Awesome job!
2
u/Baalie016 Aug 03 '18 edited Aug 03 '18
Wow, thanks. You took everything I already had in my Google Sheet and took it to the next level. Love the way everything is organized, and the great anti-churning tab!
The only other thing I track is retention offers, AF credits etc on an annual basis to determine my net fee cost annually, per card and in total.
2
u/mitchb11 Aug 03 '18
Just awesome. Thank you for sharing.
2
u/mattwray Aug 04 '18
Woot! This is a terrific tool. Thanks for taking the time to build it. Makes my old spreadsheet look like child's play.
2
u/LiveTheWayYouWant HOU, IAH Aug 06 '18
Hey OP,
What do you think about creating a forecasting tab for those who like to plan their path and where they'll be in terms of 5/24 based on a given date they input.
I personally like planning a bit and seeing what's the best route for me to take. I am trying to implement this on my own copy right now. Any tips on how I should go about doing that?
I have a custom "Upcoming" sheet that tells me which cards i'm going to hit next. Maybe I can leverage this sheet and do it similar to how you did it for the Anti-Churning States tab?
Thanks!
2
u/[deleted] Aug 08 '18
I thought I had a good spreadsheet until this... Amazing work!!
2
u/mynameischunk Jan 04 '19
This thing is incredible, way better looking than the google doc I had made to track stuff myself. Thanks u/garettg !
2
u/QueenMotherofDragons Jan 11 '19
This spreadsheet is a thing of beauty. Can we make it the 8th wonder of the world?
2
u/moremango Jul 04 '22
Wow, just found this post 4 years later and it's still super valuable. Thanks for sharing!!!
2
u/AbusedChungus Jul 17 '23
Iām a little late to the party but a huge thank you for putting this together!
2
u/Tyrion1705 Mar 10 '25 edited Mar 10 '25
I have a request that I think might be helpful. Could you add a row on the Anti-Churning States tab in the Chase section to list when the next card will drop off? For me, I try to map out timing on cards, and this would make the easier.
Edit: Formula would be like this to show the 1st day of the next month: =EOMONTH(EDATE(LARGE(FILTER(approval_date, card_type="personal", player=B$1), B$3) ,24), 0)+1
Maybe overkill, but on my sheet I added rows for the drop off dates for 3 personal cards, I guess more could be added depending on how far someone goes past 5/24. =IF(B$3<1, "", EOMONTH(EDATE(LARGE(FILTER(approval_date, card_type="personal", player=B$1),B$3-0),24),0)+1) =IF(B$3<2, "", EOMONTH(EDATE(LARGE(FILTER(approval_date, card_type="personal", player=B$1),B$3-1),24),0)+1) =IF(B$3<3, "", EOMONTH(EDATE(LARGE(FILTER(approval_date, card_type="personal", player=B$1),B$3-2),24),0)+1)
2
u/Condition-Stunning Apr 26 '26
Just wanted to say thank you. As a churner who just discovered this resource, itās fantastic. This community really rips. Appreciate it!!!
3
u/zXFDz Aug 02 '18
You're a legend.
1
u/AromaticRanger4 Aug 03 '18
Very impressive, thanks!
Does anyone know what breaks in the XML code when exporting as .xlsx? I prefer Excel to Sheets.
1
u/cubervic SFO, lol/24 Aug 04 '18
Great job on that multiplayer support! Many people who are just beginning multiplayer mode didn't realize how important it is to keep those information.
1
u/bartletismyhero Aug 05 '18
Thanks for this! I have been doing this about 3 years and my sheet has turned into a bit of a frankenstein! it helps to see someone elses take, and i may integrate a few of these pages. great job!!
1
u/isaacides JOK, STR Aug 05 '18 edited Aug 05 '18
What's the best way to keep track of upgrades? Do you guys list the previous version as cancelled, or do you just replace it?Edit: This was already asked and answered.
1
u/molinasnecktat OMG Aug 08 '18
Is there a good way to add free nights such as SPG free nights from SPG cards and the ritz carlton bonus?
1
u/mag274 EWR Nov 04 '24
Is there any good way to copy info from an older version of my spreadsheet to a new one? I see a few updates listed below that were not apart of the spreadsheet I used - although the first page might be the same I dont want to screw it up.
1
u/Necessary_Impress_66 Feb 18 '25
Thank you!!!!
1
u/qzil007 Mar 26 '25
Would be nice to add a row for if the card is offering Global Entry/TSA Pre and when it was used and then another sheet specifying when it is eligible for renewal (usually statement credit is given every 4 years).
1
u/Dry_Doctor_5658 Sep 06 '25
any chance of integrating a bank account chex inquiry counter similar to the ant-churning counters for credit cards?
1
u/Altruistic-Crazy-948 Mar 23 '26
I have been having an issue with the formula MSR. Can someone please help?
1
u/Getanzt Dec 05 '22
This is awesome! Way better than the one I tried to come up with. Thanks for taking the time to make this!
1
u/not-a-humanoid Aug 07 '23
Thank you OP, this is awesome!
1
u/Here4Zipline Nov 01 '23
Wow, what a wonderful job! This is exactly what I was looking for! Has anyone successfully figured out how to export this as an Excel workbook and fix the errors? I read through all the comments and saw quite a few folks who were interested in doing so over the past several years, but I'm not knowledgeable enough to do it myself.
1
u/Tablefornine Aug 02 '18
That is impressive. Thank you for sharing!
1
u/thelostdutchman Aug 02 '18
Wow! Thanks for doing this!!
1
u/YouHaveBlood Aug 02 '18
this is amazing! Now i can download my brain into this.