Stratification Tool

[mattd17]

Think of a pivot table on steroids. In my industry, "strats" are commonly used to summarize pools of investment assets. You may have several commonly used columns that are a mix of sums and weighted averages, capable of having filtering applied to each column. So you may see an output like this:

Loan Status	Total Balance	% of Balance	% of Balance (in Southwest Region)	Loan to Value Ratio (WA)	Curr Rate (WA)	FICO (WA)	Mths Delinquent (WA)
Current	$9,000,000	90	80	85	4.5	720	0
Delinquent	$1,000,000	10	100	95	5.5	620	4
Total	$10,000,000	100	90	86	4.6	710	0.4

Right now, I feel like to create the several sums and weighted averages, it's just too inefficient to create all the different modules, link them all together and run them through a transpose and/or cross tab. And to create a summary report where I may have 15 different categories outside of Loan Status, I'd have to replicate that process with those modules 15 times.

Currently, I have a different piece of software where I can simply write out sum and WA calcs for each column, save that column list (with accompanying calcs) and then simply plug in a new leftmost category for each piece of data I'm looking at. And I get the Total row as well auto-calculated as well.