credit card spreadsheet

[nyrfann]

To all looking to unlock the sheet to add lines and such the password is credit

Edited July 20, 2007 by nyrfann

[eirek]

Is anyone else having problems downloading this? Since the update to the boards I cant seem to get past the error saying I cant download.

[skinglist]

Is anyone else having problems downloading this? Since the update to the boards I cant seem to get past the error saying I cant download.

 

Same here:

 

"> Board Message

 

Sorry, an error occurred. If you are unsure on how to use a feature, or don't know why you got this error message, try looking through the help files for more information.

The error returned was:

 

Sorry, but you do not have permission to use this feature. If you are not logged in, you may do so using the form below if available.

"

 

It's not log in issues as I'm able to reply to threads.

[skinglist]

Is anyone else having problems downloading this? Since the update to the boards I cant seem to get past the error saying I cant download.

 

Same here:

 

"> Board Message

 

Sorry, an error occurred. If you are unsure on how to use a feature, or don't know why you got this error message, try looking through the help files for more information.

The error returned was:

 

Sorry, but you do not have permission to use this feature. If you are not logged in, you may do so using the form below if available.

"

 

It's not log in issues as I'm able to reply to threads.

 

Appears to be fixed now. Thanks all.

[solutions]

Hello All,

 

I know the sheet have been downloaded over 300 times, yet I have received very little feedback.

 

Are you all finding it useful? Any problems, comments, things you'd like different?

 

This is extremely useful. Many thanks!!!

[breeze]

nyrfan - people in general will let you know if anything's wrong, or they don't like it. Rarely do most folks think to say the nice stuff, so you can take the lack of complaints as a compliment.

[breeze]

Oh, and I use it like crazy. It's great.

 

Is there one for tracking BT terms? I mean like, someone has the latest Providian 1.99% for xx months with x% fee - calculate total cost and allow you to include that? or would that be like way too much to do with XL?? I've been calculaing it in my head (yeah I took that deal, want to use that money for something else making biggie bucks).

[skinglist]

nyrfan - people in general will let you know if anything's wrong, or they don't like it. Rarely do most folks think to say the nice stuff, so you can take the lack of complaints as a compliment.

 

I've only just started using the sheet and I like it. I'll give you any feedback if I think of anything. It's a great tool.

[sara21200]

QUESTION:

 

I had to unlock the spreadsheet to add additional lines. On the second page where the daily balances are shown, it no longer gives me the total only $0 now.

 

What can I do to fix this?

[nyrfann]

QUESTION:

 

I had to unlock the spreadsheet to add additional lines. On the second page where the daily balances are shown, it no longer gives me the total only $0 now.

 

What can I do to fix this?

Hi Sara,

 

Do you know how to change "codes" in excel? If yes then change .Range("A" & NextRow) = Worksheets("Main Credit Card ").Range("e32") to the correct cell that represents the new "overall total" cell

 

If not, let me know what cell your overall total in now in and your email address, I'll mail you a new spreadsheet.

[Islandgal]

Oh, and I use it like crazy. It's great.

 

Is there one for tracking BT terms? I mean like, someone has the latest Providian 1.99% for xx months with x% fee - calculate total cost and allow you to include that? or would that be like way too much to do with XL?? I've been calculaing it in my head (yeah I took that deal, want to use that money for something else making biggie bucks).

 

I have been playing with adding in a couple of columns or extra rows to track this, also to track last time since CLI request on different accts

[nyrfann]

Oh, and I use it like crazy. It's great.

 

Is there one for tracking BT terms? I mean like, someone has the latest Providian 1.99% for xx months with x% fee - calculate total cost and allow you to include that? or would that be like way too much to do with XL?? I've been calculaing it in my head (yeah I took that deal, want to use that money for something else making biggie bucks).

Breeze,

 

I like that thought/idea, let me think how to fit that nicely into the sheet.

 

I'll try and put something together over the next few days and get it over to you.

Edited August 5, 2007 by nyrfann

[sara21200]

QUESTION:

 

I had to unlock the spreadsheet to add additional lines. On the second page where the daily balances are shown, it no longer gives me the total only $0 now.

 

What can I do to fix this?

Hi Sara,

 

Do you know how to change "codes" in excel? If yes then change .Range("A" & NextRow) = Worksheets("Main Credit Card ").Range("e32") to the correct cell that represents the new "overall total" cell

 

If not, let me know what cell your overall total in now in and your email address, I'll mail you a new spreadsheet.

 

Thanks so much Joe - worked like a charm!

[Guest Chase in the Citi]

What an outstanding tool !!!

 

Thank you - Thank you - Thank you

 

~Chase

[montcotom]

I downloaded it last month and just got around to installing Open Office (couldn't get it running in Works). Runs great. Don't know what to do with my calculator now. Thanks much.

[turbo59]

nyrfann,

 

 

Thank you for this valuable tool! I am still trying to learn it. Just the other day I was thinking that I should create something like this but I didn't really know how to implement it.

 

Thank you for your efforts...the world is much better off with talent like yours!

 

 

I do need a sheet to keep a running total on my wife's school loans. Sheet one don't work too well in my opinion.

[nyrfann]

nyrfann,

 

 

Thank you for this valuable tool! I am still trying to learn it. Just the other day I was thinking that I should create something like this but I didn't really know how to implement it.

 

Thank you for your efforts...the world is much better off with talent like yours!

 

 

I do need a sheet to keep a running total on my wife's school loans. Sheet one don't work too well in my opinion.

I'd be willing to help with that. PM me what you need.

[LELE]

Thanks CB great tool. Where can I find out if my interest rate is variable or fixed?

[nyrfann]

Thanks CB great tool. Where can I find out if my interest rate is variable or fixed?

Look on your statment or call the creditor.

[hotgingersnap]

[weigojmi]

Great tool! Really helps one keep on his revolving debt. I noticed you are making revisions via PM for other CB members. Have you considered publishing a revised version with any/all of these changes/additions?

[Guest khaliltwo]

It a spreadsheet to track several things including ut, limits, dates etc.

Worksheet 2 "balance on a specific date" saves your total balance on close so you can see how your balances are moving day to day.

 

Also notice you can have 3 levels of payment % to compare.

 

I designed the whole thing for myself but felt it would be quite useful to many members out here so ask the CB mods to post it.

 

Any box that is grey can have data entered and everyting calculates automatically.

 

 

Is there anyway I can add additional rows/columns if I have more than the alloted amount of Credit Cards?

[Guest khaliltwo]

nyrfan - people in general will let you know if anything's wrong, or they don't like it. Rarely do most folks think to say the nice stuff, so you can take the lack of complaints as a compliment.

 

 

I for one love this database/spreadsheet. It's a lifesaver. THANKS SO MUCH as well as for the code to unlock it.

[joe715]

Thanks for the spreadsheet nyrfann. Works great and my cards are way more organized now. Thank you!

[smoovdowt]

I would like to thank you for the spread sheet.