Spreadsheet: 854288d1704218516-filter-function-how-to-condense-a-worksheet-after-filtering-condensing-filtered-data-sets
Sheet: Summary

 |  |  |  |  |  |  |  | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10
 |  |  |  |  |  |  | 138655
 |  | SEARCH (Any Field)
 |  |  |  |  | Δ FTP Rate
 | Segment | [NAME] | Previous Balance | Start | PIF / Matured | 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) | Floating (Floored) | Floating | New Contracts | End | Current Balance | Δ Rate Total | Post PIF Balance | Update to Curr Balance | Interim Balance |  | RCMFTPRIPP | RCNFOTCT | WRBTCPB | UTCPP | ACCETNA | ITNA
113000 |  |  | 138655.815 | 0.04514632425621674 | 0 | -8.584834930043528e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.0450604759069163 | 134052.475 | -8.584834930043528e-05 | 138655.815 | 134052.475 | 134052.475
181000
311000
796000
838000
858000
859000
860000
869000
899000
935000
944000
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
 |  |  |  |  | Δ Coupon
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RCMFTPRIPP | RCNFOTCT | WRBTCPB | UTCPP | ACCETNA | ITNA
113000 |  |  | 138655.815 | 0.03910928738906479 | 0 | -1.68624257346206e-06 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0.03910760114649132 | 134052.475 | -1.68624257346206e-06 | 138655.815 | 134052.475 | 134052.475
181000
311000
796000
838000
858000
859000
860000
869000
899000
935000
944000
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
 |  |  |  |  | Δ Spread
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | RCMFTPRIPP | RCNFOTCT | WRBTCPB | UTCPP | ACCETNA | ITNA
113000 |  |  | 138655.815 | -0.00603703686715195 | 0 | 8.416210672697322e-05 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | -0.005952874760424977 | 134052.475 | 8.416210672697322e-05 | 138655.815 | 134052.475 | 134052.475
181000
311000
796000
838000
858000
859000
860000
869000
899000
935000
944000
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