Jump to content

credit card spreadsheet


breeze
 Share

Recommended Posts

1/2008 #NAME?

it must be me, i am using openoffice.org CALC, had no probs with the last one. i will just ignore those columns. i have tried everything. IT IS A GREAT TOOL. thanx so much for doing it.

Yea, i may be open office not recognizing the formula.
Link to comment
Share on other sites


I' am formatting my dates as below:

 

 

7/2008

6/2008

 

Then the Avg. Years box reformats to 0.1, 0.2 etc..

Works fine for you, correct?

 

Also all your calculations working correctly now?

 

 

The UT calculations aren't showing up at the top.. Hmmm

Make sure to use row 1, this will fix the issue (the one you found).

 

I have sent another update to Stryker but as long as row 1 is used this IS NOT AN ISSUE.

Link to comment
Share on other sites

Everything works fine for me the only thing is that when I enter the oppened date I try to get it in the Month /year format but it automaticly goes to the mont/01/year format...but thats fine with me as long as a I have the ruff date in there. ITS GREAT

Link to comment
Share on other sites

Everything works fine for me the only thing is that when I enter the oppened date I try to get it in the Month /year format but it automaticly goes to the mont/01/year format...but thats fine with me as long as a I have the ruff date in there. ITS GREAT
I used that format as some will want xx/xx/xxxx. This was the best way I could solve this one. Either way the avg. age will be calculated correctly.

 

Unfortunately there is no way to have a format to satisfy all.

 

If you know excel you can easily change the format to your liking. To unlock go to Tools -> Protection -> hit enter, make your changes BUT make sure to protect again to protect the formulas. People not familiar with excel should not try this as you can change formulas that may throw of calculations.

Edited by nyrfann
Link to comment
Share on other sites

Jesus on a bicycle, thank you nyrfann!!!

 

 

Is this solely for CC balances and such, or can I add my revolving acct's to it?

 

 

 

Again, thank you! :clapping:

C/C is revolving. Did you mean installment?

 

Jesus on a bicycle
Now that I'd like to see :rofl: Edited by nyrfann
Link to comment
Share on other sites

C/C is revolving. Did you mean installment?

 

 

Yeah, like Staples, Office Depot, Home Depot (non-CC).

Yes, those are all revolving, same as a c/c.

 

Enter those as you would a c/c!

Edited by nyrfann
Link to comment
Share on other sites

1/2008 #NAME?

it must be me, i am using openoffice.org CALC, had no probs with the last one. i will just ignore those columns. i have tried everything. IT IS A GREAT TOOL. thanx so much for doing it.

Yea, i may be open office not recognizing the formula.

 

 

Thanks again Nyrfann, I love it

 

As for OO

I mostly use Open Office and this is the best I could come up with:

 

Highlight R7 and change to

 =IF(P7=0;"";YEARFRAC(P7;TODAY();0))

 

Then pull the box down to R 106

 

Again only in Open Office and only for somewhat experienced users.

Link to comment
Share on other sites

Joe.........After downloading the new spreadsheet something has changed in Excel and not only can't I enter any data in the new spreadsheet, I can't do anything with ANY Excel spreadsheet that I have................All I get when I access any of the Excel spreadsheets on my XP based computer is the "PLUS" sign, which effectively renders all of my spreadsheets "Read Only"...........Do you have any idea what's making it do this ?

I can't enter anything on the old CC spreadsheet or the new one.................Need Help, please. Thanks, Tax :warning:

Link to comment
Share on other sites

1/2008 #NAME?

it must be me, i am using openoffice.org CALC, had no probs with the last one. i will just ignore those columns. i have tried everything. IT IS A GREAT TOOL. thanx so much for doing it.

Yea, i may be open office not recognizing the formula.

 

 

Thanks again Nyrfann, I love it

 

As for OO

I mostly use Open Office and this is the best I could come up with:

 

Highlight R7 and change to

 =IF(P7=0;"";YEARFRAC(P7;TODAY();0))

 

Then pull the box down to R 106

 

Again only in Open Office and only for somewhat experienced users.

I am tryin to use the info that you gave above, but for some reason when I highlight the R column it says "Ptotected cells can not be modified"....What are you using/doing to change it?

Link to comment
Share on other sites

1/2008 #NAME?

it must be me, i am using openoffice.org CALC, had no probs with the last one. i will just ignore those columns. i have tried everything. IT IS A GREAT TOOL. thanx so much for doing it.

Yea, i may be open office not recognizing the formula.

 

 

Thanks again Nyrfann, I love it

 

As for OO

I mostly use Open Office and this is the best I could come up with:

 

Highlight R7 and change to

 =IF(P7=0;"";YEARFRAC(P7;TODAY();0))

 

Then pull the box down to R 106

 

Again only in Open Office and only for somewhat experienced users.

 

 

That almost worked, at least now when i put in 02/2007, i get 108.5, for average age,it's a number, even tho not the one i wanted. is there another tweak to it? thanks so much. it is such a great worksheet, would like full use of it.

Edited by rozzie01
Link to comment
Share on other sites

1/2008 #NAME?

it must be me, i am using openoffice.org CALC, had no probs with the last one. i will just ignore those columns. i have tried everything. IT IS A GREAT TOOL. thanx so much for doing it.

Yea, i may be open office not recognizing the formula.

 

 

Thanks again Nyrfann, I love it

 

As for OO

I mostly use Open Office and this is the best I could come up with:

 

Highlight R7 and change to

 =IF(P7=0;"";YEARFRAC(P7;TODAY();0))

 

Then pull the box down to R 106

 

Again only in Open Office and only for somewhat experienced users.

Need another one for time since cli

 

Highlight T7 and change formula to:

 

=IF(S9=0;"";MONTHS(S9;TODAY();1))

 

Then pull the T7 box down to T106

 

And yeah sorry you have to unlock the sheet to do it.

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