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

 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | All Current Contracts except the New Adds
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 |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon
2 | Loans | NULL | 42 | 43378390.645 | 43378390.645 | 43378390.645 | 2342237.00295719 | 43378390.645 | 43378390.645 | 0 | 43378390.645 | 43378390.645 |  |  |  | 1 | 0 | 0 | Loans | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285 |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
2 | Deposits | NULL | 3 | 507236.96 | 507236.96 | 507236.96 | 25361.62890677 | 507236.96 | 507236.96 | 31624.3090925 | 507236.96 | 507236.96 |  |  |  | 1 | 0 | 0 | Deposits | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285 |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
2 | Certificates of Deposit | NULL | 63 | 2275569.14 | 2275569.14 | 2275569.14 | 113824.682408055 | 2275569.14 | 2275569.14 | 140806.578012786 | 2275569.14 | 2275569.14 |  |  |  | 1 | 0 | 0 | Certificates of Deposit | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285 |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
1 | Leasing | 998608 | 310 | 852286227.125 | 835852263.765 | 835852263.765 | 37185218.8365734 | 36126358.4765875 | 36035442.075919 | 46305527.7965191 | 45042174.8950206 | 45032714.1529052 |  |  |  | 1 | 0 | 0 | Leasing |  |  |  |  |  |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
1 | Mortgage | 998667 | 310 | 852286227.125 | 835852263.765 | 835852263.765 | 37185218.8365734 | 36126358.4765875 | 36035442.075919 | 46305527.7965191 | 45042174.8950206 | 45032714.1529052 |  |  |  | 1 | 0 | 0 | Mortgage |  |  |  |  |  |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
1 | Mutual Funds | 998678 | 310 | 852286227.125 | 835852263.765 | 835852263.765 | 37185218.8365734 | 36126358.4765875 | 36035442.075919 | 46305527.7965191 | 45042174.8950206 | 45032714.1529052 |  |  |  | 1 | 0 | 0 | Mutual Funds |  |  |  |  |  |  | 310 | 852286227.125 | 0.04362996567715232 | 0.05433095868828082 | 0.0107009930111285
1 | Money Market | 998791 | 70 | 24879831.525 | 24989603.425 | 24989603.425 | 711516.270152741 | 714350.081295434 | 714335.412044211 | 1167385.87346775 | 1173202.0713135 | 1173237.6213135 |  |  |  | 1 | 0 | 0 | Money Market |  |  |  |  |  |  | 70 | 24879831.525 | 0.02859811447829895 | 0.04692097180379722 | 0.01832285732549827
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Compare to Ending values on the prior tab
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | <-- Should see no changes here
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Include the New Adds
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Step ID | [NAME] | [NAME] | ResponsibilityCenterCode | [NAME] | Balance | FTP Rate | Coupon | Spread |  | [NAME] | Balance | FTP Rate | Coupon | Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Loans
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Deposits
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Certificates of Deposit
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Leasing
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Mortgage
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Mutual Funds |  | 254564.99 | 0.012593 | 0 | -0.012593
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1 | 0 | 0 | Money Market