Spreadsheet: 854563d1704387324-filter-function-how-to-condense-a-worksheet-after-filtering-condensing-filtered-data-gk4
Sheet: Summary

 |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | 13 | 14 | 15 | 16 | 17 | 18 | 19 | 20 | 21 | 22 | 23 | 24
 | Search term | mortgage
 |  |  |  | Δ FTP Rate
 | [NAME] | Previous Balance | Start | PIF / Matured | Update Balance | Update Product | Update Balance | Update Product | Default FTP Rate | Override FTP Rate | Legacy Ftp Rate | Input -> Calc | Rate Type Change | Zero Coupon | Fixed Rate | Floating (No Reset) | New Contracts | End | Current Balance | Δ Rate Total | Post PIF Balance | Update to Curr Balance | Interim Balance |  | RCMFTPRIPP | RCNFOTCT | WRBTCPB | UTCPP | ACCETNA | ITNA
 | Mortgage | 994.98582 | 0.05076197483015889 | 0 | 4.300909575406797e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.05076627573973429 | 990.475405 | 4.300909575406797e-06 | 994.98582 | 990.475405 | 990.475405
FTPRate | Mortgage | 32148.65723 | 0.03379099852636971 | -1.210680275488818e-05 | 0.0001337327251723572 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -1.550269255157609e-08 | 0.0006552063185100868 | 0 | 6.54896863093806e-07 | 0 | 0.03456847016146797 | 31204.114925 | 0.000777471635098098 | 32105.132245 | 31204.114925 | 31204.114925
FTPRate | Mortgage | 47002.308795 | 0.02779518628893941 | 0 | 4.537110625977767e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.274790561490349e-05 | 0 | 0.0001170787355132822 | 0 | 0.02798038403632737 | 46528.26034000001 | 0.0001851977473879633 | 47002.308795 | 46528.26034000001 | 46528.26034000001
FTPRate | Mortgage | 1211.801895 | 0.02638567126667598 | -2.613652939076339e-07 | 1.753845493993739e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.02640294835632201 | 1203.714325 | 1.727708964602975e-05 | 1211.71165 | 1203.714325 | 1203.714325
FTPRate | Mortgage | 1864.348105 | 0.03420843152958819 | 0 | 6.830660570500413e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.03421526219015869 | 1856.561865 | 6.830660570500413e-06 | 1864.348105 | 1856.561865 | 1856.561865
FTPRate | Mortgage | 1276.8902 | 0.02075613723439572 | 0 | 2.09162130699464e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.02077705344746567 | 1257.117885 | 2.09162130699464e-05 | 1276.8902 | 1257.117885 | 1257.117885
FTPRate | Mortgage | 76391.87533 | 0.04068975932306511 | 4.275580208506352e-05 | 0.0003507086667055778 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0005694587489851871 | 0 | 3.867545940247445e-05 | 0 | 0.04169135800024328 | 74596.46967 | 0.001001598677178303 | 76069.136145 | 74596.46967 | 74596.46967
FTPRate | Mortgage | 46362.48757500001 | 0.0302482242574787 | 2.697969143473228e-05 | -8.6230845953994e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 2.352436975970948e-08 | 0.0001128602577560795 | 0 | 0 | 0 | 0.03037946464644387 | 45751.44631000001 | 0.0001312403889651721 | 46075.49264 | 45751.44631000001 | 45751.44631000001
FTPRate | Mortgage | 2811.800245 | 0.05560320684413341 | 0 | 1.589574903551605e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 6.770435013961996e-06 | 0 | 8.078899186209393e-06 | 0 | 0.05561964575323714 | 2800.96273 | 1.643890910372299e-05 | 2811.800245 | 2800.96273 | 2800.96273
FTPRate | Mortgage | 1851497.38088 | 0.01912056158176747 | -3.321443578997024e-06 | -4.965727940065001e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 1.629497980677656e-07 | 2.919733488338792e-05 | 0 | 8.282038807926495e-07 | 0 | 0.01914246289881064 | 1841960.571665 | 2.190131704318631e-05 | 1850137.50198 | 1841960.571665 | 1841960.571665
FTPRate | Mortgage | 3789393.77646001 | 0.02403460973470762 | -4.59300387810474e-05 | 8.86364590763078e-05 | 2.840810446472913e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 3.91837522072794e-07 | 2.918034778762997e-05 | -2.472474302348388e-05 | 0 | 0.0001855856221266265 | 0.02429615732388041 | 3835064.88917 | 0.0002615475891728349 | 3772134.37629001 | 3766794.976515 | 3811081.47658
FTPRate | Mortgage | -1.81898940354586e-15 | -84436353417232.94 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -84436353417232.94 | -1.81898940354586e-15 | 0 | -1.81898940354586e-15 | -1.81898940354586e-15 | -1.81898940354586e-15
FTPRate | Mortgage | 919419.9981799991 | 0.0476126168939912 | -1.905467207328343e-05 | 5.833007390772249e-06 | 0 | 0 | 0 | 0 | 3.908768486619068e-09 | 0 | 0 | 2.161982741848131e-08 | 4.336608514995621e-05 | 4.060108903740792e-09 | 3.980239567984963e-05 | 0 | 0.04768259329884326 | 914129.979759998 | 6.99764048521035e-05 | 918775.385814999 | 914129.979759998 | 914129.979759998