Annualized Attrition....

[Davers]

This might get interesting....I am trying to figure out annualized attrition. I think I have it working correctly, except for my totals column seen here:

BAC AttritReport.xls
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
15	2002	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
16	EOMHeadcount	85	85											85.0
17	CSCAttrition	3	1											2.00
18	MonthlyAttrition%	3.53%	1.18%											2.35%
19	AnnualizedMCCAttrition	42.35%	28.24%											2.35%
20	2001MonthlyAttrition
21	2002vs.2001%	3.53%	1.18%											2.35%
CRC

The total annualized attrition rate, cell O19, should match what is in the latest entry for annualized attrition, in this example, cell D19. But I haven't figured out what the formula needs to be. Right now it is just figuring out average attrition so far for the year. I don't want to use a lookup formulae where you have to type in what month you are in...I would just like it to automatically know how many months are filled in and return the annualized attrition up to and including that month...Any idea's??? You guys have been great by the way answering all my newbie questions...I really appreciate it! I can't wait to have an answer to someone's EASY question....

Thanks,

Dave M.

 

[Davers]

Thanks guys...I can't seem to get it to work...I'm getting a #VALUE error...:-/

Alladin, what do you mean I'm computing some things twice to often....do you mean my ISERROR?

Thanks again everyone....

Dave M.

 

[Davers]

I just can't figure out what I'm doing wrong.... Maybe it's just late...here's my formulae...

BAC AttritReport.xls
	B	C	D	E	F	G	H	I	J	K	L	M	N	O
16	EOMHeadcount	85	85											85.0
17	CSCAttrition	3	1											2.00
18	MonthlyAttrition%	3.53%	1.18%											2.35%
19	AnnualizedMCCAttrition	42.35%	28.24%											#N/A
20	2001MonthlyAttrition
21	2002vs.2001%	3.53%	1.18%											2.35%
CRC

I entered everything else as he said...I just don't know....

Maybe tomorrow morning I can get it to work...thanks again for all your help!

Dave M.

 

[maxflia10]

Dave,

Check the Refers to window. The 9.99999 etc shouldn't have "" around them. If there is delete the range and just type in again.

 

[Aladin Akyurek]

On 2002-11-07 18:15, Davers wrote:
I just can't figure out what I'm doing wrong.... Maybe it's just late...here's my formulae...

[...]

I entered everything else as he said...I just don't know....

Maybe tomorrow morning I can get it to work...thanks again for all your help!

Dave,

You need to define BigNum as I described earlier. That's not a big deal.

What follows shows also possible rewrites for the original formulas (I hope I understood them as intended)...

aaAttritionCalcs Davers.xls
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P
14
15		2002	Jan	Feb	Mar	Apr	May	Jun	Jul	Aug	Sep	Oct	Nov	Dec	Total
16		EOMHeadcount	85	85											85.0
17		CSCAttrition	3	1											2.0
18		MonthlyAttrition%	3.53%	1.18%											2.35%
19		AnnualizedMCCAttrition	42.35%	28.24%											28.24%
20		2001MonthlyAttrition
21		2002vs.2001%	3.53%	1.18%											2.35%
22
Sheet1

Aladin

 

[Davers]

Aladin...you are amazing... Thank you for rewriting my formula's....if you couldn't tell...(hehe) I'm very new to Excel...This works perfectly!!! Thank you once again!!!!

 

[Davers]

Aladin...you are amazing... Thank you for rewriting my formula's....if you couldn't tell...(hehe) I'm very new to Excel...This works perfectly!!! Thank you once again!!!!

Regards,

Dave M....

P.S...once again, if you are ever in Michigan...you have a Guinness waiting for you...