Spreadsheet: 83562d1283523426-how-do-i-make-this-filter-type-box-that-can-be-seen-in-this-spreadsheet-temp
Sheet: Model

 | (Problem - Totals don’t recalculate when 'filters' applied) |  |  |  |  |  |  | FE Code |  |  | Invoice Has (Select) | GST Only (no PST)
 |  |  |  |  |  |  |  | Invoice Subtotal | 1000 |  | GST Rate | 0.05
 |  |  |  |  |  |  |  | Tax | 130 |  | QST Rate | 0.075
 | Note: PST is included in the line amount, HST is part of the GST amount |  |  |  |  |  |  | Invoice Total | 1130 |  | PST Rate | 0.08
 | NoA
 | Type of Fund | Fund Name | IM Code / Fund# | Fund Series# | Series | AUM | NoA |  | AUM / NoA Percentage |  | Line Amount | Expense Amount | Fund Level Expense | Fund Allocated GST - Previous Sheet Calcs
 | CORPORATE CLASS FUNDS | BACF Corporate Class | JT4555 | JT4555 | A | 1000000 | 700 |  | 0.008049215201517851 |  | 9.095613177715173 | 8.049215201517852 | 9.889035819007647 | 0.4331244370340558
 | CORPORATE CLASS FUNDS | BACF Corporate Class | JT4555 | JT4556 | F | 900000 | 75 |  | 0.0008624159144483413 |  | 0.9745299833266257 | 0.8624159144483413 |  | 0.04640618968222027
 | CORPORATE CLASS FUNDS | BACF Corporate Class | JT4555 | JT4557 | I | 30000 | 10 |  | 0.0001149887885931122 |  | 0.1299373311102168 | 0.1149887885931122 |  | 0.00618749195762937
 | CORPORATE CLASS FUNDS | BACF Corporate Class | JT4555 | JT4558 | O | 400000 | 75 |  | 0.0008624159144483413 |  | 0.9745299833266257 | 0.8624159144483413 |  | 0.04640618968222027
 | CORPORATE CLASS FUNDS | BB Corporate Class | JT2555 | JT2555 | A | 5812312.3 | 1100 |  | 0.01264876674524234 |  | 14.29310642212384 | 12.64876674524234 | 13.30420284022308 | 0.6806241153392306
 | CORPORATE CLASS FUNDS | BB Corporate Class | JT2555 | JT2556 | F | 526277.443 | 48 |  | 0.0005519461852469384 |  | 0.6236991893290404 | 0.5519461852469384 |  | 0.02969996139662097
 | CORPORATE CLASS FUNDS | BB Corporate Class | JT2555 | JT2557 | I | 260000 | 3 |  | 3.449663657793365e-05 |  | 0.03898119933306503 | 0.03449663657793365 |  | 0.001856247587288811
 | CORPORATE CLASS FUNDS | BB Corporate Class | JT2555 | JT2558 | O | 320000 | 6 |  | 6.89932731558673e-05 |  | 0.07796239866613006 | 0.0689932731558673 |  | 0.003712495174577622
 | CORPORATE CLASS FUNDS | FTM Yield Class | JT4300 | JT4300 | A | 4000065.4 | 714 |  | 0.008210199505548209 |  | 9.277525441269477 | 8.210199505548209 | 11.36089231299948 | 0.441786925774737
 | CORPORATE CLASS FUNDS | FTM Yield Class | JT4300 | JT4301 | F | 908000.4 | 45 |  | 0.0005174495486690048 |  | 0.5847179899959754 | 0.5174495486690047 |  | 0.02784371380933216
 | CORPORATE CLASS FUNDS | FTM Yield Class | JT4300 | JT4302 | I | 164951.65275 | 6 |  | 6.89932731558673e-05 |  | 0.07796239866613006 | 0.0689932731558673 |  | 0.003712495174577622
 | CORPORATE CLASS FUNDS | FTM Yield Class | JT4300 | JT4303 | O | 4897521.153 | 223 |  | 0.002564249985626401 |  | 2.897602483757834 | 2.564249985626402 |  | 0.137981070655135
 | OPEN-END MUTUAL FUNDS | BACF Fund | JT4911 | JT4911 | A | 2218723.61325 | 2996 |  | 0.03445064106249641 |  | 38.92922440062094 | 34.45064106249641 | 44.65014661070546 | 1.853772590505759
 | OPEN-END MUTUAL FUNDS | BACF Fund | JT4911 | JT4912 | F | 260549.2875 | 268 |  | 0.003081699534295406 |  | 3.482320473753809 | 3.081699534295407 |  | 0.1658247844644671
 | OPEN-END MUTUAL FUNDS | BACF Fund | JT4911 | JT4913 | I | 531.6532500000001 | 500 |  | 0.005749439429655608 |  | 6.496866555510837 | 5.749439429655609 |  | 0.3093745978814684
 | OPEN-END MUTUAL FUNDS | BACF Fund | JT4911 | JT4914 | O | 1480859.474250006 | 119 |  | 0.001368366584258035 |  | 1.54625424021158 | 1.368366584258035 |  | 0.07363115429578951
 | OPEN-END MUTUAL FUNDS | BB Fund | JT2525 | JT2525 | A | 1329556.05525 | 12576 |  | 0.1446099005346979 |  | 163.4091876042086 | 144.6099005346979 | 160.2943712987984 | 7.781389885914693
 | OPEN-END MUTUAL FUNDS | BB Fund | JT2525 | JT2526 | F | 2517065.4465 | 1051 |  | 0.01208532168113609 |  | 13.65641349968378 | 12.08532168113609 |  | 0.6503054047468467
 | OPEN-END MUTUAL FUNDS | BB Fund | JT2525 | JT2527 | I | 35567.331 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | OPEN-END MUTUAL FUNDS | BB Fund | JT2525 | JT2528 | O | 18619310.13375001 | 312 |  | 0.0035876502041051 |  | 4.054044730638763 | 3.5876502041051 |  | 0.1930497490780363
 | OPEN-END MUTUAL FUNDS | BCB Fund | JT2511 | JT2511 | A | 2252647.07275 | 27851 |  | 0.3202552751106767 |  | 361.8884608750647 | 320.2552751106767 | 363.3185764387972 | 17.23278385119356
 | OPEN-END MUTUAL FUNDS | BCB Fund | JT2511 | JT2514 | F | 7122921.3945 | 3046 |  | 0.03502558500546197 |  | 39.57891105617202 | 35.02558500546197 |  | 1.884710050293906
 | OPEN-END MUTUAL FUNDS | BCB Fund | JT2511 | JT2515 | I | 378.723 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | OPEN-END MUTUAL FUNDS | BCB Fund | JT2511 | JT2516 | O | 17415288.723 | 59 |  | 0.0006784338526993618 |  | 0.7666302535502789 | 0.6784338526993619 |  | 0.03650620255001328
 | OPEN-END MUTUAL FUNDS | BCB Fund | JT2511 | JT2517 | T | 1099976.826 | 639 |  | 0.007347783591099868 |  | 8.30299545794285 | 7.347783591099868 |  | 0.3953807360925167
 | OPEN-END MUTUAL FUNDS | BCD Fund | [NAME] | [NAME] | A | 14153260.62975 | 100 |  | 0.001149887885931122 |  | 1.299373311102167 | 1.149887885931122 | 7.876732018628184 | 0.06187491957629369
 | OPEN-END MUTUAL FUNDS | BCD Fund | [NAME] | A3001 | F | 806590.0342499999 | 561 |  | 0.006450871040073592 |  | 7.28948427528316 | 6.450871040073593 |  | 0.3471182988230076
 | OPEN-END MUTUAL FUNDS | BCD Fund | [NAME] | A3002 | O | 160644.4042500012 | 24 |  | 0.0002759730926234692 |  | 0.3118495946645202 | 0.2759730926234692 |  | 0.01484998069831049
 | OPEN-END MUTUAL FUNDS | BCE Fund | A2666 | A2666 | A | 37643261.2005 | 3224 |  | 0.03707238544241936 |  | 41.89179554993388 | 37.07238544241937 | 121.2901742080147 | 1.994847407139709
 | OPEN-END MUTUAL FUNDS | BCE Fund | A2666 | A2667 | F | 17720020.88025 | 6990 |  | 0.0803771632265854 |  | 90.82619444604151 | 80.37716322658541 |  | 4.325056878382929
 | OPEN-END MUTUAL FUNDS | BCE Fund | A2666 | A2668 | I | 41405.73075 | 3 |  | 3.449663657793365e-05 |  | 0.03898119933306503 | 0.03449663657793365 |  | 0.001856247587288811
 | OPEN-END MUTUAL FUNDS | BCE Fund | A2666 | A2669 | O | 3003266.76975 | 331 |  | 0.003806128902432013 |  | 4.300925659748175 | 3.806128902432013 |  | 0.2048059837975321
 | POOLED TRUST FUNDS | BCCB Trust | P7897 | P7897 | A | 845974.305 | 38 |  | 0.0004369573966538262 |  | 0.4937618582188236 | 0.4369573966538262 | 0.4369573966538262 | 0.0235124694389916
 | Quotential Funds | QBGP | A5462 | A5462 | A | 16455181.53475 | 5018 |  | 0.05770137411602369 |  | 65.20255275110677 | 57.70137411602369 | 141.3557178175128 | 3.104883464338418
 | Quotential Funds | QBGP | A5462 | A5463 | F | 3009889.6995 | 1041 |  | 0.01197033289254298 |  | 13.52647616857356 | 11.97033289254298 |  | 0.6441179127892174
 | Quotential Funds | QBGP | A5462 | A5464 | I | 120072.5025 | 8 |  | 9.199103087448974e-05 |  | 0.1039498648881734 | 0.09199103087448975 |  | 0.004949993566103496
 | Quotential Funds | QBGP | A5462 | A5465 | O | 645583.09025 | 239 |  | 0.002748232047375381 |  | 3.10550221353418 | 2.748232047375381 |  | 0.1478810577873419
 | Quotential Funds | QBGP | A5462 | A5466 | R | 240704.9925 | 6 |  | 6.89932731558673e-05 |  | 0.07796239866613006 | 0.0689932731558673 |  | 0.003712495174577622
 | Quotential Funds | QBGP | A5462 | A5467 | S | 231764.27325 | 41 |  | 0.0004714540332317599 |  | 0.5327430575518887 | 0.4714540332317599 |  | 0.02536871702628041
 | Quotential Funds | QBGP | A5462 | A5468 | T | 11608820.94175 | 5940 |  | 0.06830334042430863 |  | 77.18277467946875 | 68.30334042430863 |  | 3.675370222831845
 | Quotential Funds | QBIP | B8080 | B8080 | A | 3083413.10425 | 1500 |  | 0.01724831828896682 |  | 19.49059966653251 | 17.24831828896682 | 51.23900419709079 | 0.9281237936444052
 | Quotential Funds | QBIP | B8080 | B8081 | F | 1029186.018 | 278 |  | 0.003196688322888518 |  | 3.612257804864026 | 3.196688322888519 |  | 0.1720122764220965
 | Quotential Funds | QBIP | B8080 | B8082 | I | 29896.94325 | 5 |  | 5.749439429655609e-05 |  | 0.06496866555510838 | 0.05749439429655609 |  | 0.003093745978814685
 | Quotential Funds | QBIP | B8080 | B8083 | O | 1491335.02025 | 113 |  | 0.001299373311102168 |  | 1.468291841545449 | 1.299373311102168 |  | 0.06991865912121187
 | Quotential Funds | QBIP | B8080 | B8084 | R | 37603.42725 | 3 |  | 3.449663657793365e-05 |  | 0.03898119933306503 | 0.03449663657793365 |  | 0.001856247587288811
 | Quotential Funds | QBIP | B8080 | B8085 | S | 29207.9865 | 6 |  | 6.89932731558673e-05 |  | 0.07796239866613006 | 0.0689932731558673 |  | 0.003712495174577622
 | Quotential Funds | QBIP | B8080 | B8086 | T | 9158050.4145 | 2551 |  | 0.02933363997010292 |  | 33.1470131662163 | 29.33363997010292 |  | 1.578429198391252
 | Quotential Funds | QCGB | X1140 | X1140 | A | 3643565.63775 | 2053 |  | 0.02360719829816593 |  | 26.6761340769275 | 23.60719829816593 | 24.53860748577014 | 1.27029209890131
 | Quotential Funds | QCGB | X1140 | X1141 | F | 86750.0625 | 68 |  | 0.0007819237624331627 |  | 0.8835738515494739 | 0.7819237624331628 |  | 0.04207494531187971
 | Quotential Funds | QCGB | X1140 | X1142 | I | 601.161 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | Quotential Funds | QCGB | X1140 | [NAME] | O | 480247.0627499999 | 12 |  | 0.0001379865463117346 |  | 0.1559247973322601 | 0.1379865463117346 |  | 0.007424990349155243
 | Quotential Funds | QDIP | P55 | P55 | A | 6082347.345749999 | 2343 |  | 0.02694187316736618 |  | 30.44431667912378 | 26.94187316736618 | 46.27148852986834 | 1.449729365672561
 | Quotential Funds | QDIP | P55 | P56 | F | 355616.03475 | 74 |  | 0.0008509170355890301 |  | 0.961536250215604 | 0.8509170355890301 |  | 0.04578744048645733
 | Quotential Funds | QDIP | P55 | P57 | I | 565.43625 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | Quotential Funds | QDIP | P55 | P58 | O | 9908489.48025 | 52 |  | 0.0005979417006841833 |  | 0.675674121773127 | 0.5979417006841833 |  | 0.03217495817967272
 | Quotential Funds | QDIP | P55 | P59 | S | 998666.2575 | 284 |  | 0.003265681596044386 |  | 3.690220203530156 | 3.265681596044386 |  | 0.1757247715966741
 | Quotential Funds | QDIP | P55 | P60 | T | 41352150.94275 | 1270 |  | 0.01460357615132525 |  | 16.50204105099753 | 14.60357615132525 |  | 0.7858114786189299
 | Tapestry Funds | Tapestry BGPP Corporate Class | P609 | P609 | A | 2383672.31925 | 164 |  | 0.00188581613292704 |  | 2.130972230207555 | 1.88581613292704 | 2.564249985626402 | 0.1014748681051217
 | Tapestry Funds | Tapestry BGPP Corporate Class | P609 | P610 | F | 122430.78375 | 10 |  | 0.0001149887885931122 |  | 0.1299373311102168 | 0.1149887885931122 |  | 0.00618749195762937
 | Tapestry Funds | Tapestry BGPP Corporate Class | P609 | P611 | O | 575864.39175 | 24 |  | 0.0002759730926234692 |  | 0.3118495946645202 | 0.2759730926234692 |  | 0.01484998069831049
 | Tapestry Funds | Tapestry BGPP Corporate Class | P609 | P612 | R | 103.3005 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | Tapestry Funds | Tapestry BGPP Corporate Class | P609 | P613 | T | 457489.9725 | 24 |  | 0.0002759730926234692 |  | 0.3118495946645202 | 0.2759730926234692 |  | 0.01484998069831049
 | Tapestry Funds | Tapestry BLIP Corporate Class | P6060 | P6060 | A | 977869.6185000001 | 62 |  | 0.0007129304892772955 |  | 0.8056114528833439 | 0.7129304892772955 | 1.115391249353188 | 0.03836245013730209
 | Tapestry Funds | Tapestry BLIP Corporate Class | P6060 | P6061 | F | 230368.6815 | 7 |  | 8.049215201517852e-05 |  | 0.09095613177715173 | 0.08049215201517852 |  | 0.004331244370340558
 | Tapestry Funds | Tapestry BLIP Corporate Class | P6060 | P6062 | O | 468121.8675000001 | 24 |  | 0.0002759730926234692 |  | 0.3118495946645202 | 0.2759730926234692 |  | 0.01484998069831049
 | Tapestry Funds | Tapestry BLIP Corporate Class | P6060 | P6063 | R | 104.30775 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | Tapestry Funds | Tapestry BLIP Corporate Class | P6060 | P6064 | T | 75496.25475 | 3 |  | 3.449663657793365e-05 |  | 0.03898119933306503 | 0.03449663657793365 |  | 0.001856247587288811
 | Tapestry Funds | Tapestry DIP Corporate Class | P2220 | P2221 | A | 358193.4885 | 24 |  | 0.0002759730926234692 |  | 0.3118495946645202 | 0.2759730926234692 |  | 0.01484998069831049
 | Tapestry Funds | Tapestry DIP Corporate Class | P2220 | P2222 | F | 44157.50625 | 3 |  | 3.449663657793365e-05 |  | 0.03898119933306503 | 0.03449663657793365 |  | 0.001856247587288811
 | Tapestry Funds | Tapestry DIP Corporate Class | P2220 | P2223 | O | 244471.01175 | 13 |  | 0.0001494854251710458 |  | 0.1689185304432818 | 0.1494854251710458 |  | 0.00804373954491818
 | Tapestry Funds | Tapestry DIP Corporate Class | P2220 | P2224 | R | 106.45575 | 1 |  | 1.149887885931122e-05 |  | 0.01299373311102168 | 0.01149887885931122 |  | 0.000618749195762937
 | Tapestry Funds | Tapestry DIP Corporate Class | P2220 | P2225 | T | 15563.77575 | 2 |  | 2.299775771862243e-05 |  | 0.02598746622204335 | 0.02299775771862244 |  | 0.001237498391525874
 |  |  |  |  |  | 263980651.1427501 | 86965 |  | 1 |  | 1129.999999999999 | 1000 | 999.5055482090496 | 53.80952380952383