Let me see if I understand AAoA

[cobaltnv]

---

@Anonymous wrote:

---

I have this pretty much working also. Questions:

1) The oldest account is the oldest reporting TL, open or closed, right?, and

Yes 

2) AAoA includes open and closed accounts?

Correct

I can only get it to come out right if I exclude the one account I have which is reporting closed.

This seems strange-not sure what the problem would be. Are any of your accounts under dispute or listed as disputed by customer? If so the account may not be counted in you AAoA.

Also, this value is truncated to a whole number, right? (No months.)

Fico truncates to the whole number of years. It is useful to know the number of months however. For example it is nice to know when you will reach a AAoA birthday. Or if you add a new account if the AAoA will drop a year 

I also have a UTIL calc and that is working correctly. I am working this out initially using an EQ Score Power report from here.

---

 

[Anonymous]

---

@cobaltnv wrote:

---

@Anonymous wrote:

---

I have this pretty much working also. Questions:

1) The oldest account is the oldest reporting TL, open or closed, right?, and

Yes 

2) AAoA includes open and closed accounts?

Correct

I can only get it to come out right if I exclude the one account I have which is reporting closed.

This seems strange-not sure what the problem would be. Are any of your accounts under dispute or listed as disputed by customer? If so the account may not be counted in you AAoA.

Also, this value is truncated to a whole number, right? (No months.)

Fico truncates to the whole number of years. It is useful to know the number of months however. For example it is nice to know when you will reach a AAoA birthday. Or if you add a new account if the AAoA will drop a year 

I also have a UTIL calc and that is working correctly. I am working this out initially using an EQ Score Power report from here.

---

---

I will throw the TL's and opening dates up here along with the reporing date in a little while (there aren't that many) and we'll see what you come up with. There aren't that many. No, no disputes. Everything is open save the one closed account. I even put together a formula to format decimal time spans like this: "10 y 6 m". I also have the AAoA computing in years and months. I really would like to get this working reliably and then crank in the currently reported info periodically.

If it is easier I can put the .xl* file up in the publically available section of my Sky Drive (windows live) and PM you the poop on how to get to it. It is not in "pretty" form yet...

[cobaltnv]

CWCID,

   Either way is fine with me. I can either input your data into my spreadsheet or I can link to your data on your sky drive. Whichever you prefer. 

Cheers 

[cobaltnv]

CWCID,

   I took a look at your spreadsheet and I am not quite sure what the issue is. If you do not exclude the closed account I get a total number of months of 516. Divided by 9 accounts gives and AAoA of 4y 9m (4 years by Fico's rounding)--as of June 2009. This matches your fico report. As of today your AAoA should be 5 years exactly. 

Let me know if I am missing something.

Cheers 

[Anonymous]

---

@cobaltnv wrote:

CWCID,

   I took a look at your spreadsheet and I am not quite sure what the issue is. If you do not exclude the closed account I get a total number of months of 516. Divided by 9 accounts gives and AAoA of 4y 9m (4 years by Fico's rounding)--as of June 2009. This matches your fico report. As of today your AAoA should be 5 years exactly. 

Let me know if I am missing something.

Cheers 

---

No, per my PM I was. Nothing like getting all the hard parts correct and the easiest thing wrong, Oh dear!