Jump to content

radi8

Debt Snowball spreadsheets

Recommended Posts


I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

Share this post


Link to post
Share on other sites
I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

 

Do you have macros disabled in Excel? If you do the spreadsheets won't work.

Share this post


Link to post
Share on other sites

I'm trying the Snowball spreadsheet that is in the link above, and I can't get any of the macros to work, no matter what I do. It's frustrating.

 

Do you have macros disabled in Excel? If you do the spreadsheets won't work.

 

 

How do you enable them? I don't think I disabled them but I may have as the spreadsheets don't work for me either. And I'm not longer asked if I want them disabled or not. :yahoo:

Share this post


Link to post
Share on other sites

Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

Share this post


Link to post
Share on other sites
Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

 

 

Mine does not ask that info... :aggressive: Oh well, I guess I don't need to use it. :aggressive:

Share this post


Link to post
Share on other sites

Yes I had to disable them to get it to work. Now whenever I open the program it asks to disable them. It works just fine as long as that is disabled. Now that I have figured it out it works great. IF I can help more let me know.

 

 

Mine does not ask that info... :aggressive: Oh well, I guess I don't need to use it. :aggressive:

 

Try the one I posted, it's not an online spreadsheet, and you can save as many as you'd like. :aggressive:

Share this post


Link to post
Share on other sites

The instructions for this spreadsheet suck, and it's not naturally intuitive, but once I finally figured it out it was great.

Share this post


Link to post
Share on other sites

I don't think this works with Excel 07. I get some message about VBA converters.

 

I got that, too.

 

I clicked ok for the error messages, and it actually seems to work fine for 2007.

Share this post


Link to post
Share on other sites

I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

Share this post


Link to post
Share on other sites
I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

 

 

 

 

 

I just copied it down with formulas and formats. I just today figured out how to get my payments to amortize on each credit card. You just click create rows. After that brought all my credit cards down I felt like such a dope..lol

Share this post


Link to post
Share on other sites
I can't figure out how to add more months. I am by no means an expert at Excel, but I would definately think I know more than the average person. Any tips on how to add additional months/years that way I can tell how long the snowball will take and my current financial situation.

 

 

 

 

 

I just copied it down with formulas and formats. I just today figured out how to get my payments to amortize on each credit card. You just click create rows. After that brought all my credit cards down I felt like such a dope..lol

 

 

 

 

 

 

 

 

I've been playing with this all afternoon and I finally figured it out!

 

 

 

If you put in the years you want to snowball and click add rows. It adds everything you need. geesh..that was so hard to figure out..lol

Share this post


Link to post
Share on other sites

Yeah I finally got it all to work myself. I guess I just assumed it would figure out how long it would take to bring the debts to zero.

 

For those of you that can't quite figure it out, if you have more than 2 cards to Snowball then you must highlight one of the cards and paste it into new cells, do this for as many cards as you have.

 

The other thing you must do is change years in plan to at least 5 (depending on how long it will take) and then click Create Rows. If you want to tidy up the spreadsheet after that, you can see where your balance equals zero and count the number of years and months and put that in for years in plan and click Create Rows again.

 

Hope that helps!

 

Great spreadsheet by the way. Just some constructive criticism if there ever happens to be another version.

 

1. Better instructions

2. An option to choose how long you want to be in the Snowball plan then give you what the minimum payment would have to be.

3. Lastly, an option to choose whether you want to pay it by lowest balance or highest interest rate as I know mentally the lowest balance can help a lot. (Although you can rearrange the snowballs in any order you so choose)

Share this post


Link to post
Share on other sites
Yeah I finally got it all to work myself. I guess I just assumed it would figure out how long it would take to bring the debts to zero.

 

For those of you that can't quite figure it out, if you have more than 2 cards to Snowball then you must highlight one of the cards and paste it into new cells, do this for as many cards as you have.

 

 

 

Actually you don't need to copy anything. You put in the number of years you want to be on the plan, change the month and year you want to start, put in how much you can contriubute, click create rows and it will do it for you.

 

To get it to figure out the number of years for you just put in a large number of years and it will add those number of years but if the debt is paid off earlier the remaining numbers will be zero.

Edited by sunwhipped

Share this post


Link to post
Share on other sites

I am just starting to work up my spreadsheet, but I don't have any teaser rates, so my snowball order is pretty straightforward. Is there a way to factor in multiple interest rates on the same card?

 

I have one card that currently has a $6,644 balance. $5,914 is at 1.99 fixed and $795 at 10.52 variable. However, the lower interest rate balance is being paid off 1st. Aren't cc companies great. :D

Share this post


Link to post
Share on other sites

Ugh, I went through all of the trouble to get all of my thousands of cc's information in there, set it to 5 years and clikc on "create rows" and it gave me a damn error about macros. And being as I have office 2007, I have no idea how to confirm they're turned on . . . grrr!

Share this post


Link to post
Share on other sites
Ugh, I went through all of the trouble to get all of my thousands of cc's information in there, set it to 5 years and clikc on "create rows" and it gave me a damn error about macros. And being as I have office 2007, I have no idea how to confirm they're turned on . . . grrr!

 

 

It is crazy hidden. Follow these steps:

File (I still call it file - but the nice big marble in top left) --> Excel Options (Lower right corner)

Trust Center --> Trust Center Settings --> Macro Settings --> Disable All Macros With Notification

 

Now, when you open the document it will prompt you just between the workbook and the Ribbon that Macros are disabled and should give you an option to Enable them.

 

Hope that works for you!

Share this post


Link to post
Share on other sites

i dont think that i will be able to use this... it looks complicated and intimidating when you look at it.. i am not someone that is very familiar with Excel and such... is there a version for dummies????

Share this post


Link to post
Share on other sites

Hey gang, I've had this for awhile and I figured I'd help my CB friends. I've designed a excel monthly budget spreadsheet that might be able to help you keep track of your bills. It was designed in Excel 2007 but I have saved a copy in Excel 2003, just not sure if it will work with the features I have in it.

 

Some of the features;

1. Allows you to enter all your bills a month

2. Colums for Payee, Amount, Due Date, Payoff, etc.

3. Shows money left over after all bills are paid (comes from entering your monthly gross income)

 

It has helped me, so hopefully it will help some of you all.

 

I'll attach both 2007, and 2003. If anyone is interested let me know.

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.


  • Today's Birthdays

  • Member Statistics

    • Total Members
      176,745
    • Most Online
      1,528

    Newest Member
    zerocat1
    Joined

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