Spreadsheet: 854438d1704311648-filter-function-how-to-condense-a-worksheet-after-filtering-condensing-filtered-data-setsv3
Sheet: 1. PopulationAttribution

StepID | PrevRC | CurrRC | NumContracts | PrevBalance | CurrBalance | CurrBalance2 | PrevBal_x_PrevFtpRate | CurBal_x_PrevFtpRate | CurBal_x_CurrFtpRate | PrevBal_x_PrevCoupon | CurBal_x_PrevCoupon | CurBal_x_CurrCoupon
5 | Loans | Loans | 1150 | 132283983.225 | 131914836.81 | 131914836.81 | 5956851.38171916 | 5939715.94106147 | 5965919.34277179 | 6988674.35461057 | 6965376.84548279 | 7004344.92414196
4 | Deposits | Deposits | 1 | 265.66 | 92.87 | 92.87 | 15.3359826927081 | 5.36118615023639 | 5.39799281682351 | 40.91164 | 14.30198 | 14.30198 |  | Prev Period
5 | Certificates of Deposit | Certificates of Deposit | 498 | 341134788.91 | 342136265.45 | 342136265.45 | 12172437.8137282 | 12270156.0114308 | 12238293.8229582 | 24145988.3290435 | 24274490.9672755 | 24105155.1862005 |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread
5 | Leasing | Leasing | 16 | 502861.935 | 494989.28 | 494989.28 | 8849.49522619798 | 8670.91410875304 | 8672.04320189945 | 21392.2220165 | 21078.571643 | 21078.571643 |  | 1 | 0 | 0 | Loans
4 | Mortgage | Mortgage | 1 | 8549.63 | 8407.615 | 8407.615 | 453.7288641 | 446.19212805 | 446.19212805 | 511.267874 | 502.775377 | 502.775377 |  | 1 | 0 | 0 | Deposits
5 | Mutual Funds | Mutual Funds | 5 | 5211417.215 | 5204391.72 | 5204391.72 | 227239.955679835 | 226950.878552105 | 226950.878552105 | 308427.4318675 | 308005.30292 | 308005.30292 |  | 1 | 0 | 0 | Certificates of Deposit
2 | Money Market | Money Market | 821 | 889071336.39 | 903197633.335001 | 903197633.335001 | 30266739.6878933 | 31110372.9423066 | 31111714.3017539 | 48685947.1781755 | 49811616.2717611 | 49816427.7175411 |  | 1 | 0 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Money Market
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove Contracts missing FTP Rate in Prev Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2 | 0 | 0 | Money Market
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Should see no changes here
 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME] not found on the Current Tape
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 3 | 0 | 0 | Money Market | 821 | 889071336.39 | 0.03404309468662984 | 0.0547604508046123 | 0.02071735611798246
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Remove Contracts missing FTP Rate in Curr Period
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 0 | 0 | Money Market | 821 | 889071336.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Should see no changes here
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Weight Rates by the Current Period Balance
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 0 | Money Market | 821 | 889071336.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Used the Current Period Product
 |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Mutual Funds
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4 | 1 | 1 | Money Market | 821 | 889071336.39
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon |  |  | [NAME] | Balance | FTP Rate | Coupon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 0
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 113000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 181000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 311000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 796000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 838000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 858000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 859000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 860000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 869000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 899000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 935000 |  |  |  |  |  |  |  |  |  |  |  | <-- Compare to starting values on the next tab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 944000 |  |  |  |  |  |  |  |  |  |  |  | <-- Should see no changes here
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 944004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 956001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 956002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957005
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957006
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957007
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957008
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957009
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 957011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 961000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 964000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 968000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 969000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 969001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970002
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970003
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970004
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970010
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970011
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970020
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970021
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970030
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970031
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970040
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970041
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970050
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970060
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 970070
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 978000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 980000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 981000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 982000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 983000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 983001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 984000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 985000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 987000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 988000
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 989001
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 991917
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994860
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994861
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994931
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994934
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994959
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994963
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 994990
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 997901
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998402
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998501
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998502
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998503
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998504
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998505
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998507
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998513
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998514
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998516
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998517
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998518
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998519
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998520
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998521
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998522
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998602
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998604
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998608
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998609
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998610
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998611
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998612
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998613
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998616
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998617
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998618
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998619
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998620
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998621
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998623
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998624
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998625
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998626
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998628
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998629
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998630
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998631
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998637
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998638
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998650
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998660
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998661
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998663
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998664
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998665
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998667
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998671
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998675
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998677
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998678
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998699
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998733
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998772
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998773
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998774
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998775
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998776
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998778
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998779
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998780
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998781
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998782
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998787
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998788
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998789
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998790
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998791
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998792
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998794
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998795
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998796
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998797
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998798
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998799
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998801
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998802
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998803
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 998830