Yeah. I meant 80%. The reason that I have to show whole numbers is that
these #'s are loans. Can't really have 23.2 loans.

I should have mentioned this before, but the total line is based on a
separate calculation where a % of the total possible volume is taken to
get the total # of loans. Then from that total we take a % for each of
the 3 loan categories (80, 15, 5). So the Total of 29 is not a sum of
the 3 categories, but rather the 3 categories are populated by the sum
* the % of that specific category.



Jul - Aug - Sep - Oct - *Nov* - Dec - Annual

Conv 0 - 6 - 18 - 18 - *23* - 18 - 83
ALT A 0 - 1 - 3 - 3 - *4* - 3 - 15
Non 0 - 0 - 1 - 1 - *1* - 1 - 5

Total 0 - 7 - 22 - 22 - *29* - 22 - 103


--
jesterhs
------------------------------------------------------------------------
jesterhs's Profile: http://www.excelforum.com/member.php...o&userid=20902
View this thread: http://www.excelforum.com/showthread...hreadid=389210