Jump to content

credit card spreadsheet


breeze
 Share

Recommended Posts


Thanks for the initial spreadsheet! I made some additions:

 

1. Date of credit activation

2. Days between CLI/GLI request

3. Calendar that lists days to call for CLI/GLI based on 1&2

4. Total utilization (all cards added up, divided by all credit limits)

5. Dollars to pay off utilization (to 50%, 30%, 10%)

mrliberty

May I also get a copy of your enhanced spreadsheet?

I'm looking to finally get organized, and am considering adding a field for time since last usage.

Also, some kind of alert if card has been inactive for 6 months.

Thanks,

Bob

Link to comment
Share on other sites

  • 2 weeks later...
Thanks for the initial spreadsheet! I made some additions:

 

1. Date of credit activation

2. Days between CLI/GLI request

3. Calendar that lists days to call for CLI/GLI based on 1&2

4. Total utilization (all cards added up, divided by all credit limits)

5. Dollars to pay off utilization (to 50%, 30%, 10%)

 

 

May i get the new spreadsheet as well. Can I find it posted somewhere? I found the original to be very helpful

Link to comment
Share on other sites

nyrfann, how do I use the spreadsheet to bring my balances down to 30%?
I'm not sure what you mean?

 

 

Utilization purposes what's needed to bring down to 30%.....Obviously your spreadsheet and mrliberty's are two completely different sheets.....does yours have that option?

Link to comment
Share on other sites

nyrfann, how do I use the spreadsheet to bring my balances down to 30%?
I'm not sure what you mean?

 

 

Utilization purposes what's needed to bring down to 30%.....Obviously your spreadsheet and mrliberty's are two completely different sheets.....does yours have that option?

I did not put that in mine but can easliy add it if wanted.

 

I have not seen mrliberty's but judging from his post he just added to my sheet and is passing it around which I am NOT TO HAPPY ABOUT!

Edited by nyrfann
Link to comment
Share on other sites

NYRFAN- In the Due Date column, what format is it looking for? Jut the day, or would you have to put it in every month and update it like 1/20, 2/20, etc?

 

Its a great sheet. Thank you very much for it.

What ever format you choose. I put the actual day (i.e. the 20). I use the last day I want to send my payment, not the actual due date. But that's just me some may like to use the actual due date.

 

The column is really all up to what the user prefers.

 

Glad you like the sheet.

Edited by nyrfann
Link to comment
Share on other sites

I am working on some updates for the sheet, I hope to have it done in the next couple of weeks.

 

It will be very user friendly as this one is. I could have made the sheet a lot more complicated but wanted to keep it as simple as possible as not everybody knows how to use excel.

 

I will ask the mods to post it along with the original when done.

Edited by nyrfann
Link to comment
Share on other sites

nyrfann, how do I use the spreadsheet to bring my balances down to 30%?
I'm not sure what you mean?

 

 

Utilization purposes what's needed to bring down to 30%.....Obviously your spreadsheet and mrliberty's are two completely different sheets.....does yours have that option?

I did not put that in mine but can easliy add it if wanted.

 

I have not seen mrliberty's but judging from his post he just added to my sheet and is passing it around which I am NOT TO HAPPY ABOUT!

 

I wouldn't be either.

Link to comment
Share on other sites

  • 4 weeks later...

I have a request Joe, I'm not sure how to do it myself.

 

Opening date column - age in months column, then overall average age.

 

Age and Util is all I really need to track at this point. Might help soothe my itchy trigger finger :P .

 

I'll keep playing with it when I get the chance.

 

ETA: WOW 10,160 downloads!!!

Edited by taylortr
Link to comment
Share on other sites

I have a request Joe, I'm not sure how to do it myself.

 

Opening date column - age in months column, then overall average age.

 

Age and Util is all I really need to track at this point. Might help soothe my itchy trigger finger ;) .

 

I'll keep playing with it when I get the chance.

 

ETA: WOW 10,160 downloads!!!

I am currently working on some improvements to the sheet and will keep your request in mind.

 

I had hoped to have had the new sheet done by now but I've been so busy lately with work and my personal life. There definatly will be an avg. age column though.

 

I think I may have the new sheet done within the next couple of weeks.

 

Yea 10K+ in downloads it's great. I don't even think there was one negative review.

Edited by nyrfann
Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.

Guest
Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

 Share

×
×
  • Create New...

Important Information

Guidelines