Jump to content

Sign in to follow this  
breeze

credit card spreadsheet

Recommended Posts

Heres a negative comment!

 

Just kidding buddy, We all appreciate your work on it. I have made quite a few improvements and modifications to suite my personal needs, added charts, graphs, calculations to snowball, etc...

 

Hope you don't mind B)

Share this post


Link to post
Share on other sites

Heres a negative comment!

 

Just kidding buddy, We all appreciate your work on it. I have made quite a few improvements and modifications to suite my personal needs, added charts, graphs, calculations to snowball, etc...

 

Hope you don't mind :)

Don’t mind at all, everybody should personalize as needed. I just ask you don’t start distributing the edited copy.

 

I made a very basic sheet for the people who don't know excel, I figured people who knew excel would make some changes.

 

The next sheet will be just a simple to use but provide a greater rnage of detail.

 

Credit Card SS 2008 comming soon! :D

Edited by nyrfann

Share this post


Link to post
Share on other sites

Of course I would never distribute someone else's work without their permission. Your sheet provided a great base for me to build off of, for that I am very thankful.

 

I think you need a movie poster... :lol:

Share this post


Link to post
Share on other sites

Here is a quick snippet from the age column I have added to CCSS 2008 :lol: :

 

Date Opened----- Age in years

04/22/2005---------- 3.1

05/22/2006---------- 2.0

05/22/2007---------- 1.0

05/22/2000---------- 8.0

 

Overall Average: 3.5

Edited by nyrfann

Share this post


Link to post
Share on other sites

This is a great SS. Thank you soo much. It has helped me ACTUALLY see what my credit card situation ACTUALLY looks like. THANKS

 

My only question is how do I get the date and balance to transfer over to Balance on Specific Date page? Sorry for the dumb question Im sure its obvious nad Im just missing it.

Share this post


Link to post
Share on other sites
This is a great SS. Thank you soo much. It has helped me ACTUALLY see what my credit card situation ACTUALLY looks like. THANKS

 

My only question is how do I get the date and balance to transfer over to Balance on Specific Date page? Sorry for the dumb question Im sure its obvious nad Im just missing it.

It does it automatically on close you need to do nothing.

 

When you close the book you should be asked to save, click yes. To check if working go back in and check page 2, balance should be there.

Share this post


Link to post
Share on other sites
I just tried it and nothing. The last date saved was 23apr08. Did I mess it up some how?
Did you add rows?

 

If it's not saving then I'd download the sheet again (Unless you know how to chage codes in excel) and renter the data again.

Edited by nyrfann

Share this post


Link to post
Share on other sites
Here is a quick snippet from the age column I have added to CCSS 2008 :D :

 

Date Opened----- Age in years

04/22/2005---------- 3.1

05/22/2006---------- 2.0

05/22/2007---------- 1.0

05/22/2000---------- 8.0

 

Overall Average: 3.5

 

That's awsome, Thank you.

Share this post


Link to post
Share on other sites
Here is a quick snippet from the age column I have added to CCSS 2008 ;) :

 

Date Opened----- Age in years

04/22/2005---------- 3.1

05/22/2006---------- 2.0

05/22/2007---------- 1.0

05/22/2000---------- 8.0

 

Overall Average: 3.5

 

That's awsome, Thank you.

And it only gets better, I really got back into it today, I hope to have a test page out to some by the weekend.

 

I will not be adding graphs & charts as everybody would probably want a different one and there are just too many to think off.

Edited by nyrfann

Share this post


Link to post
Share on other sites

Not sure if this was asked....

How about like a section like for each CC you place a check for EX EQ TU that the CC report on ... and at end the total section it will give you the Util of EX EQ TU

 

cause looking at my CR... some TL isnt reporting on certain CRA and if they dont then your Util be different in each CRA CR?

 

just a suggestion..

 

Example:

 

EX/TU/EQ CC use/limit

X X Hooters MC $100/1000

X X BofA Visa $0/5000

X X X NFCU $100/10000

 

EX total available 16000 use 200 util 1.25%

TU total 11000 200 util 1.8%

EQ total 15000 100 util .6%

 

blahh something like that... owell

 

lol darn edit smashed everything together

Edited by antsmith101

Share this post


Link to post
Share on other sites
Not sure if this was asked....

How about like a section like for each CC you place a check for EX EQ TU that the CC report on ... and at end the total section it will give you the Util of EX EQ TU

 

cause looking at my CR... some TL isnt reporting on certain CRA and if they dont then your Util be different in each CRA CR?

 

just a suggestion..

Doing UT for each individual CRA would take up to much space BUT I love the idea of adding a section where you can check (put a check) if it's reporting or not Edited by nyrfann

Share this post


Link to post
Share on other sites
ya looking at what I wrote would be some crazy formula needed... maybe easier in access
I could do it NO but i have so much info there now this would REALLY expand it.

Share this post


Link to post
Share on other sites

Just mailed the new "Beta" sheet to 6 CB members/ mods to play around with & test.

 

Hopefully all goes well with it.

Share this post


Link to post
Share on other sites
Just mailed the new "Beta" sheet to 6 CB members/ mods to play around with & test.

 

Hopefully all goes well with it.

 

Love it so far...

Share this post


Link to post
Share on other sites
Just mailed the new "Beta" sheet to 6 CB members/ mods to play around with & test.

 

Hopefully all goes well with it.

 

Love it so far...

Cool...I noiticed a copy of little formula problems that I have already corrected.

 

To all:

Here are some of the changes / additions to come:

 

Change: Totals now listed at top of page, no need to scroll to bottom.

Change: Formatting

Addition: Preferred UT Calculation & Payment needed to reach it

Addition: Payment due date

Addition: Date last used

Addition: Date opened

Addition: Date closed

Addition: Average age in years

Addition: Date of last cli

Addition: Last cli in months – When over 6 months will display in red

Addition: Reports to (Drop down)

Addition: “Notes†& “Other†cells

Edited by nyrfann

Share this post


Link to post
Share on other sites
Just mailed the new "Beta" sheet to 6 CB members/ mods to play around with & test.

 

Hopefully all goes well with it.

 

Love it so far...

Cool...I noiticed a copy of little formula problems that I have already corrected.

 

To all:

Here are some of the changes / additions to come:

 

Change: Totals now listed at top of page, no need to scroll to bottom.

Change: Formatting

Addition: Preferred UT Calculation & Payment needed to reach it

Addition: Payment due date

Addition: Date last used

Addition: Date opened

Addition: Date closed

Addition: Average age in years

Addition: Date of last cli

Addition: Last cli in months – When over 6 months will display in red

Addition: Reports to (Drop down)

Addition: “Notes†& “Other†cells

 

Thank you so much!! This has been essential to my organization.

Share this post


Link to post
Share on other sites
Just mailed the new "Beta" sheet to 6 CB members/ mods to play around with & test.

 

Hopefully all goes well with it.

 

Love it so far...

Cool...I noiticed a copy of little formula problems that I have already corrected.

 

To all:

Here are some of the changes / additions to come:

 

Change: Totals now listed at top of page, no need to scroll to bottom.

Change: Formatting

Addition: Preferred UT Calculation & Payment needed to reach it

Addition: Payment due date

Addition: Date last used

Addition: Date opened

Addition: Date closed

Addition: Average age in years

Addition: Date of last cli

Addition: Last cli in months – When over 6 months will display in red

Addition: Reports to (Drop down)

Addition: “Notes†& “Other†cells

 

 

I'm anxiously awaiting your new spreadsheet! I've been using the one currently available for quite some time now and love it. Really helps me keep things in perspective!

Share this post


Link to post
Share on other sites
I'm anxiously awaiting your new spreadsheet! I've been using the one currently available for quite some time now and love it. Really helps me keep things in perspective!

 

 

 

Same here .. THANKS !!!

Share this post


Link to post
Share on other sites

I heavily modded your org sheet but I would love to see the new one!

 

This was the single best thing that I have ever encountered as far as credit!!!!!!

Share this post


Link to post
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.

Sign in to follow this  




About Us

Since 2003, creditboards.com has helped thousands of people repair their credit, force abusive collection agents to follow the law, ensure proper reporting by credit reporting agencies, and provided financial education to help avoid the pitfalls that can lead to negative tradelines.
×
×
  • Create New...

Important Information

Guidelines