| Priority | Type | Description |
|---|---|---|
| 1 | | or OR | Logical "or" (Vertical bar). Filter the column for content that matches text from either side of the bar |
| 2 | && or AND | Logical "and". Filter the column for content that matches text from either side of the operator. |
| 3 | /\d/ | Add any regex to the query to use in the query ("mig" flags can be included /\w/mig) |
| 4 | < <= >= > | Find alphabetical or numerical values less than or greater than or equal to the filtered query |
| 5 | ! or != | Not operator, or not exactly match. Filter the column with content that do not match the query. Include an equal (=), single (') or double quote (") to exactly not match a filter. |
| 6 | " or = | To exactly match the search query, add a quote, apostrophe or equal sign to the beginning and/or end of the query |
| 7 | - or to | Find a range of values. Make sure there is a space before and after the dash (or the word "to") |
| 8 | ? | Wildcard for a single, non-space character. |
| 8 | * | Wildcard for zero or more non-space characters. |
| 9 | ~ | Perform a fuzzy search (matches sequential characters) by adding a tilde to the beginning of the query |
| 10 | text | Any text entered in the filter will match text found within the column |
| Capacité de l'Aréna | Prix des Billets | Assistance | Assistance PCT | Revenus | Dépenses | Éstimation | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Équipe | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Matchs à domicile Restants | Assistance Moyenne - % | Revenus Moyen par Match | Revenus Annuels à ce Jour | Capacité de l'Aréna | Popularité de l'Équipe | Salaire Total des Joueurs | Salaire Total Moyen des Joueurs | Dépenses Annuelles à Ce Jour | Cap Salarial Par Jour | Cap salarial à ce jour | Joueurs Inclut dans la Cap Salariale | Joueurs Exclut dans la Cap Salariale | Revenus de la Saison Éstimés | Jours Restants de la Saison | Dépenses Par Jour | Dépenses de la Saison Éstimées |
| 1 | Admirals (Ana) | 2000 | 1000 | 35 | 20 | 74244 | 25328 | 95.18% | 64.94% | 2 | 2553 - 85.10% | 79,618$ | 3,105,100$ | 3000 | 100 | 2,285,000$ | 2,285,000$ | 2,232,855$ | 12,285$ | 2,232,855$ | 26 | 0 | 159,236$ | 8 | 12,285$ | 98,280$ |
| 2 | Baby Hawks (Chi) | 2000 | 1000 | 50 | 20 | 47691 | 26042 | 61.14% | 66.77% | 2 | 1891 - 63.02% | 74,497$ | 2,905,390$ | 3000 | 100 | 2,455,084$ | 2,495,084$ | 2,200,344$ | 13,414$ | 2,299,934$ | 24 | 0 | 148,994$ | 8 | 13,199$ | 105,592$ |
| 3 | Bears (Was) | 2000 | 1000 | 40 | 20 | 60033 | 26001 | 76.97% | 66.67% | 2 | 2206 - 73.53% | 74,906$ | 2,921,340$ | 3000 | 100 | 3,444,636$ | 3,444,636$ | 3,422,022$ | 18,520$ | 3,422,022$ | 27 | 0 | 149,812$ | 8 | 18,520$ | 148,160$ |
| 4 | Bruins (Bos) | 2000 | 1000 | 35 | 15 | 75237 | 37356 | 96.46% | 95.78% | 2 | 2887 - 96.23% | 81,888$ | 3,193,635$ | 3000 | 100 | 1,981,083$ | 1,981,083$ | 1,933,858$ | 10,651$ | 1,933,858$ | 25 | 0 | 163,776$ | 8 | 10,651$ | 85,208$ |
| 5 | Cabaret Lady Mary Ann (Que) | 2000 | 1000 | 35 | 15 | 72281 | 36373 | 95.11% | 95.72% | 3 | 2859 - 95.31% | 80,932$ | 3,075,430$ | 3000 | 100 | 1,377,722$ | 1,416,722$ | 1,375,077$ | 7,617$ | 1,412,167$ | 21 | 0 | 242,797$ | 8 | 7,407$ | 59,256$ |
| 6 | Caroline (Car) | 2000 | 1000 | 32 | 12 | 72319 | 37211 | 95.16% | 97.92% | 3 | 2882 - 96.08% | 72,651$ | 2,760,740$ | 3000 | 100 | 3,836,535$ | 4,075,035$ | 2,875,623$ | 21,909$ | 3,103,895$ | 30 | 0 | 217,953$ | 8 | 20,627$ | 165,016$ |
| 7 | Chiefs (Stl) | 2000 | 1000 | 50 | 20 | 46952 | 25077 | 61.78% | 65.99% | 3 | 1896 - 63.18% | 74,977$ | 2,849,140$ | 3000 | 100 | 2,652,106$ | 2,652,106$ | 2,473,806$ | 14,259$ | 2,473,806$ | 29 | 0 | 224,932$ | 8 | 14,259$ | 114,072$ |
| 8 | Chill (Nas) | 2000 | 1000 | 38 | 18 | 74105 | 28944 | 95.01% | 74.22% | 2 | 2642 - 88.08% | 85,564$ | 3,336,982$ | 3000 | 100 | 1,859,972$ | 1,859,972$ | 2,077,921$ | 10,000$ | 2,097,632$ | 26 | 0 | 171,127$ | 8 | 10,000$ | 80,000$ |
| 9 | Comets (Van) | 2000 | 1000 | 30 | 15 | 76613 | 38062 | 98.22% | 97.59% | 2 | 2940 - 98.01% | 70,902$ | 2,765,185$ | 3000 | 100 | 2,444,133$ | 2,444,133$ | 2,271,847$ | 13,140$ | 2,271,847$ | 30 | 0 | 141,804$ | 8 | 13,140$ | 105,120$ |
| 10 | Cougars (Det) | 2000 | 1000 | 50 | 20 | 47170 | 26091 | 60.47% | 66.90% | 2 | 1878 - 62.62% | 73,854$ | 2,880,320$ | 3000 | 100 | 2,155,351$ | 2,155,351$ | 2,101,455$ | 11,588$ | 2,102,661$ | 25 | 0 | 147,709$ | 8 | 11,588$ | 92,704$ |
| 11 | Crunch (Buf) | 2000 | 1000 | 50 | 20 | 48180 | 25523 | 61.77% | 65.44% | 2 | 1890 - 62.99% | 74,858$ | 2,919,460$ | 3000 | 100 | 1,686,417$ | 1,686,417$ | 1,921,321$ | 9,067$ | 1,921,321$ | 21 | 0 | 149,716$ | 8 | 9,067$ | 72,536$ |
| 12 | Heat (Cal) | 2000 | 1000 | 35 | 15 | 72907 | 36585 | 95.93% | 96.28% | 3 | 2881 - 96.05% | 81,593$ | 3,100,520$ | 3000 | 100 | 1,706,084$ | 1,716,084$ | 1,532,219$ | 9,226$ | 1,541,763$ | 22 | 0 | 244,778$ | 8 | 9,172$ | 73,376$ |
| 13 | Jayhawks (KC ) | 2000 | 1000 | 50 | 20 | 46246 | 24969 | 60.85% | 65.71% | 3 | 1874 - 62.47% | 73,992$ | 2,811,680$ | 3000 | 100 | 1,714,917$ | 1,714,917$ | 2,137,271$ | 9,220$ | 2,137,271$ | 21 | 0 | 221,975$ | 8 | 9,220$ | 73,760$ |
| 14 | Las Vegas (Las) | 2000 | 1000 | 40 | 20 | 61381 | 27013 | 74.85% | 65.89% | 0 | 2156 - 71.87% | 73,061$ | 2,995,500$ | 3000 | 100 | 1,597,634$ | 1,597,634$ | 1,622,661$ | 8,589$ | 1,622,661$ | 22 | 0 | 0$ | 8 | 8,589$ | 68,712$ |
| 15 | Manchots (Pit) | 1750 | 1250 | 50 | 20 | 41299 | 33037 | 60.51% | 67.77% | 2 | 1906 - 63.54% | 69,795$ | 2,722,000$ | 3000 | 100 | 3,285,406$ | 3,429,406$ | 2,047,222$ | 18,438$ | 2,183,450$ | 27 | 0 | 139,590$ | 8 | 17,663$ | 141,304$ |
| 16 | Marlies (Tor) | 4000 | 2000 | 35 | 15 | 149826 | 74313 | 96.04% | 95.27% | 2 | 5747 - 95.79% | 163,041$ | 6,358,605$ | 6000 | 100 | 3,127,522$ | 3,372,522$ | 3,337,075$ | 18,132$ | 3,571,502$ | 26 | 0 | 326,082$ | 8 | 16,815$ | 134,520$ |
| 17 | Minnesota (Min) | 2000 | 1000 | 35 | 15 | 75750 | 38740 | 94.69% | 96.85% | 1 | 2862 - 95.41% | 80,809$ | 3,232,350$ | 3000 | 100 | 2,305,000$ | 2,305,000$ | 2,194,510$ | 12,392$ | 2,194,510$ | 25 | 0 | 80,809$ | 8 | 12,392$ | 99,136$ |
| 18 | Monarchs (LA ) | 2000 | 1000 | 50 | 20 | 47983 | 25998 | 61.52% | 66.66% | 2 | 1897 - 63.23% | 74,849$ | 2,919,110$ | 3000 | 100 | 2,129,477$ | 2,129,477$ | 2,103,111$ | 11,449$ | 2,103,111$ | 28 | 0 | 149,698$ | 8 | 11,449$ | 91,592$ |
| 19 | Monsters (Clb) | 2000 | 1000 | 35 | 15 | 74660 | 37280 | 95.72% | 95.59% | 2 | 2870 - 95.68% | 81,341$ | 3,172,300$ | 3000 | 100 | 2,428,833$ | 2,428,833$ | 2,163,928$ | 13,058$ | 2,163,928$ | 26 | 0 | 162,682$ | 8 | 13,058$ | 104,464$ |
| 20 | Monsters (Col) | 2000 | 1000 | 35 | 15 | 70987 | 35622 | 95.93% | 96.28% | 4 | 2881 - 96.04% | 81,591$ | 3,018,875$ | 3000 | 100 | 3,130,750$ | 3,130,750$ | 2,362,723$ | 16,832$ | 2,362,925$ | 28 | 0 | 326,365$ | 8 | 16,832$ | 134,656$ |
| 21 | Oceanics (Win) | 2000 | 1000 | 40 | 20 | 60045 | 26278 | 75.06% | 65.70% | 1 | 2158 - 71.94% | 73,184$ | 2,927,360$ | 3000 | 100 | 2,948,800$ | 2,836,300$ | 3,066,659$ | 15,249$ | 2,921,017$ | 29 | 0 | 73,184$ | 8 | 15,854$ | 126,832$ |
| 22 | Oil Kings (Edm) | 2000 | 1000 | 12 | 5 | 78000 | 39000 | 100.00% | 100.00% | 2 | 3000 - 100.00% | 29,000$ | 1,131,000$ | 3000 | 100 | 2,133,258$ | 2,133,258$ | 2,185,023$ | 11,469$ | 2,188,791$ | 28 | 0 | 58,000$ | 8 | 11,469$ | 91,752$ |
| 23 | Phantoms (Phi) | 2000 | 1000 | 35 | 15 | 73840 | 37871 | 94.67% | 97.11% | 2 | 2864 - 95.48% | 80,832$ | 3,152,465$ | 3000 | 100 | 1,666,333$ | 1,666,333$ | 1,806,424$ | 8,959$ | 1,806,424$ | 22 | 0 | 161,665$ | 8 | 8,959$ | 71,672$ |
| 24 | Rocket (Mon) | 2000 | 1000 | 42 | 20 | 58447 | 26378 | 73.06% | 65.95% | 1 | 2121 - 70.69% | 74,558$ | 2,982,334$ | 3000 | 100 | 1,636,850$ | 1,636,736$ | 1,860,111$ | 8,800$ | 1,860,042$ | 24 | 0 | 74,558$ | 8 | 8,800$ | 70,400$ |
| 25 | Senators (Ott) | 2000 | 1000 | 50 | 20 | 47690 | 25474 | 61.14% | 65.32% | 2 | 1876 - 62.53% | 74,205$ | 2,893,980$ | 3000 | 100 | 1,913,333$ | 1,913,333$ | 1,705,263$ | 10,287$ | 1,705,263$ | 25 | 0 | 148,409$ | 8 | 10,287$ | 82,296$ |
| 26 | Sharks (San) | 1750 | 1250 | 50 | 20 | 40962 | 31138 | 61.60% | 65.55% | 3 | 1897 - 63.25% | 70,286$ | 2,670,860$ | 3000 | 100 | 3,056,666$ | 3,056,666$ | 2,801,628$ | 16,434$ | 2,801,628$ | 28 | 0 | 210,857$ | 8 | 16,434$ | 131,472$ |
| 27 | Sound Tigers (Isl) | 2000 | 1000 | 30 | 12 | 73861 | 37165 | 97.19% | 97.80% | 3 | 2922 - 97.39% | 70,048$ | 2,661,810$ | 3000 | 100 | 2,016,416$ | 2,018,202$ | 2,002,716$ | 10,851$ | 2,004,471$ | 26 | 0 | 210,143$ | 8 | 10,841$ | 86,728$ |
| 28 | Spiders (Har) | 2000 | 1000 | 35 | 18 | 72716 | 27826 | 95.68% | 73.23% | 3 | 2646 - 88.19% | 80,156$ | 3,045,928$ | 3000 | 100 | 2,448,700$ | 2,448,700$ | 2,342,377$ | 13,165$ | 2,342,377$ | 28 | 0 | 240,468$ | 8 | 13,165$ | 105,320$ |
| 29 | Stars (Dal) | 2000 | 1000 | 20 | 5 | 76896 | 38103 | 98.58% | 97.70% | 2 | 2949 - 98.29% | 48,727$ | 1,900,364$ | 3000 | 100 | 2,612,700$ | 2,612,700$ | 1,819,227$ | 14,047$ | 1,819,227$ | 24 | 0 | 97,455$ | 8 | 14,047$ | 112,376$ |
| 30 | Thunder (Tam) | 2000 | 1000 | 35 | 15 | 75507 | 37291 | 96.80% | 95.62% | 2 | 2892 - 96.41% | 82,105$ | 3,202,110$ | 3000 | 100 | 2,508,417$ | 2,522,917$ | 2,401,442$ | 13,564$ | 2,415,262$ | 27 | 0 | 164,211$ | 8 | 13,486$ | 107,888$ |
| 31 | Wolf Pack (Ran) | 2000 | 1000 | 40 | 20 | 59567 | 25393 | 76.37% | 65.11% | 2 | 2178 - 72.62% | 74,116$ | 2,890,540$ | 3000 | 100 | 2,377,311$ | 2,377,811$ | 2,073,020$ | 12,784$ | 2,073,714$ | 27 | 0 | 148,233$ | 8 | 12,781$ | 102,248$ |
