credit card spreadsheet

[Credit Ranker]

My pleasure, hope it comes in handy for CB members

 

If there are any questions or comment please feel free to PM me.

 

Can be useful for credit card arbitrage Thanks!

[longgoneusa]

WOW - if you have 100 credit cards, you're doing something seriously wrong somewhere, make that everywhere

[LKH]

WOW - if you have 100 credit cards, you're doing something seriously wrong somewhere, make that everywhere

 

 

Why is that?

[creditmojojunkie]

Hi NYRFan !

 

Thank you for providing a

Great spreadsheet ! I love having all that Info at-a-glance.

 

Anyway that i could get an "unlocked" copy of it ?

 

I have like 5 colunms of other data that i'd like to see as well.

 

or maybe you could them .

 

mcredit94527@gmail.com

 

Thanks

[nyrfann]

Hi NYRFan !

 

Thank you for providing a

Great spreadsheet ! I love having all that Info at-a-glance.

 

Anyway that i could get an "unlocked" copy of it ?

 

I have like 5 colunms of other data that i'd like to see as well.

 

or maybe you could them .

 

mcredit94527@gmail.com

 

Thanks

Glad you like it!

 

There is no passwaord, just go to protect and click unprotect.

[scottb99]

Thanks for the spreadsheet. Will come in handy.

[Tate74]

^

[LaylaChanel]

Thank you very much nyrfann! This is going to be a very helpful tool.

[CaughtShort]

This is helpful!

 

I downloaded it a while back and was a little confused by it and it seemed intimidating, so I forgot about it. But the other day I decided to take a closer look at it and I filled out all of my information and it's very nice having all of the info right there. Everybody needs this spreadsheet.

[mr504]

This might be a dumb question, but how do i use page 2.........

[nyrfann]

This might be a dumb question, but how do i use page 2.........

You do nothing on page 2, it's done automatically. It keeps a running tally of your balance every time you close.

 

When you close the sheet hit save. Next time you open it look at page 2.

 

If you don't want to save the amount after each close, save before closing then when you close hit no.

Edited January 8, 2009 by nyrfann

[mr504]

This might be a dumb question, but how do i use page 2.........

You do nothing on page 2, it's done automatically. It keeps a running tally of your balance every time you close.

 

When you close the sheet hit save. Next time you open it look at page 2.

 

If you don't want to save the amount after each close, save before closing then when you close hit no.

 

Thanks, but it's not working for me for some reason. I filled the spreadsheet out with some accounts and closed/saved it, but when I open it page 2 is blank

[markca]

This might be a dumb question, but how do i use page 2.........

You do nothing on page 2, it's done automatically. It keeps a running tally of your balance every time you close.

 

When you close the sheet hit save. Next time you open it look at page 2.

 

If you don't want to save the amount after each close, save before closing then when you close hit no.

 

Thanks, but it's not working for me for some reason. I filled the spreadsheet out with some accounts and closed/saved it, but when I open it page 2 is blank

 

Same here. The second page is not working. I tried this one and the OpenOffice one and get the same results for both.

[nyrfann]

This might be a dumb question, but how do i use page 2.........

You do nothing on page 2, it's done automatically. It keeps a running tally of your balance every time you close.

 

When you close the sheet hit save. Next time you open it look at page 2.

 

If you don't want to save the amount after each close, save before closing then when you close hit no.

 

Thanks, but it's not working for me for some reason. I filled the spreadsheet out with some accounts and closed/saved it, but when I open it page 2 is blank

 

Same here. The second page is not working. I tried this one and the OpenOffice one and get the same results for both.

I just tested the sheet all is working fine. You must have Macros enabled and security set to medium. If you don't page 2 will not work but everything else will work as designed. Edited January 12, 2009 by nyrfann

[mr504]

Thanks nryfann. I finally got it to work. @ Markca, you have to save the file two times before you see your balance on the second page. When you save the spreadsheet the first time the second spreadsheet will not reflect a balance. You have to open the spreadsheet again, add a new Credit Limit/Balance and save it again. Open it again and you should see an update on the second spreadsheet now.

[nyrfann]

Thanks nryfann. I finally got it to work. @ Markca, you have to save the file two times before you see your balance on the second page. When you save the spreadsheet the first time the second spreadsheet will not reflect a balance. You have to open the spreadsheet again, add a new Credit Limit/Balance and save it again. Open it again and you should see an update on the second spreadsheet now.

Thanks for the update.

[Melanie2009]

Thanks for the spreadsheet. Will come in handy.

 

+1

[concerned]

Quick thing about the spreadsheet:

 

I just noticed on an account that had a low balance ($820) that no matter what I put as a percentage (cells G2, H2 and I2), it would give me 20 as the minimum payment.

 

I changed the formula from the following to the following on those cells H7, H8, etc and I7, I8, etc to make it work.

 

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*H$2)) to =IF($D7=0,"",IF($D7*$H$2<20,20,$D7*H$2))

 

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*I$2)) to =IF($D7=0,"",IF($D7*$I$2<20,20,$D7*I$2))

 

Like I said, it is very hard to notice unless its a low amount. This way it will choose D7 * H7 instead of 20 for the 2nd and 3rd percentages.

 

Other than that, I've been burning hours on that program (and the old one) for more than a year, and still think its awesome. I've also added the amortization table from excel as new tabs for each credit card and converted it into a hybrid snowball.

 

Thanks again for the spreadsheet.

[nyrfann]

Quick thing about the spreadsheet:

 

I just noticed on an account that had a low balance ($820) that no matter what I put as a percentage (cells G2, H2 and I2), it would give me 20 as the minimum payment.

 

I changed the formula from the following to the following on those cells H7, H8, etc and I7, I8, etc to make it work.

 

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*H$2)) to =IF($D7=0,"",IF($D7*$H$2<20,20,$D7*H$2))

 

=IF($D7=0,"",IF($D7*$G$2<20,20,$D7*I$2)) to =IF($D7=0,"",IF($D7*$I$2<20,20,$D7*I$2))

 

Like I said, it is very hard to notice unless its a low amount. This way it will choose D7 * H7 instead of 20 for the 2nd and 3rd percentages.

 

Other than that, I've been burning hours on that program (and the old one) for more than a year, and still think its awesome. I've also added the amortization table from excel as new tabs for each credit card and converted it into a hybrid snowball.

 

Thanks again for the spreadsheet.

Hi concerned, I'm galad you like the sheet.

 

I purposely did it this way to show a payment is due when you only have a small balance. In most cases a creditor has payment terms of x% of the balance or min $20 whichever is higher, this is why I used $20. I figured people who knew how to use excel like yourself would know how to change it if it was not wanted.

[nyrfann]

I am currently working on a 2009 version, any and all requests will be considered for the new sheet.

 

Please PM me your ideas.

Edited February 21, 2009 by nyrfann

[cristina47454]

Wow! What a great tool! Thank you so much for sharing! I've been tracking my ccs for some time now, but your spreadsheet has categories I didn't know to add. And I'm seeing things much more clearly now. thanks!

[tarbaby]

2009 version.

 

Can't wait to see it!

 

I do like the snowball idea that concerned used.

[slutty]

subscribing

[chuckmanley83]

Great sheet, thank you so much. You saved me a lot of work!

[Really Trying 2]

Been reading Creditboards for a while but just now checked out this spreadsheet. WOW, thanks so very much for all the time consuming work you've put forth and then sharing it with us. I just started using it and don't even have everything inputed but love what I'm seeing - well, love the info but maybe not the figures.

 

Did you ever come up with the s/s for installment accounts? If so, I would love to use it also.

 

Again, THANKS for all your work.