| 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é | Prix des billets | Assistance | Assistance PCT | Revenu | Dépenses | Estimation | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Équipe | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Niveau1 | Niveau2 | Matchs à domicile restants | Assistance moyenne - % | Revenu moyen par match | Revenu annuel à ce jour | Capacité | Popularité de l’équipe | Salaire total des joueurs | Plafond Salariale total des joueurs | Dépenses annuelles à ce jour | Plafond salarial par jour | Plafond salarial à ce jour | Joueurs Inclus dans le plafond salarial | Joueurs exclut du plafond Salarial | Revenus de la saison estimés | Jours restants de la saison | Dépenses par jour | Dépenses de la saison estimées |
| 1 |  Admirals (Nas) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 2,750,100$ | 2,750,100$ | 277,516$ | 0$ | 267,724$ | 0 | 0 | 6,794,400$ | 166 | 15,490$ | 2,571,340$ |
| 2 |  Americans (Buf) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 3,860,000$ | 3,860,000$ | 384,460$ | 0$ | 374,672$ | 0 | 0 | 6,794,400$ | 166 | 21,522$ | 3,572,652$ |
| 3 |  Barracuda (SJ ) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 3,160,000$ | 3,160,000$ | 313,801$ | 0$ | 304,023$ | 0 | 0 | 6,615,600$ | 166 | 17,717$ | 2,941,022$ |
| 4 |  Bears (Was) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,505,000$ | 2,505,000$ | 252,639$ | 0$ | 242,856$ | 0 | 0 | 6,615,600$ | 166 | 14,158$ | 2,350,228$ |
| 5 |  BruinsF (Bos) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 2,535,000$ | 2,535,000$ | 253,104$ | 0$ | 243,312$ | 0 | 0 | 6,794,400$ | 166 | 14,321$ | 2,377,286$ |
| 6 |  Canucks (Van) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,645,000$ | 2,645,000$ | 261,355$ | 0$ | 251,573$ | 0 | 0 | 6,615,600$ | 166 | 14,918$ | 2,476,388$ |
| 7 |  Checkers (Flo) | 2000 | 1000 | 49 | 34 | 7153 | 3515 | 89.41% | 87.88% | 38 | 2667 - 88.90% | 185,854$ | 743,416$ | 3000 | 125 | 3,120,000$ | 3,120,000$ | 317,037$ | 0$ | 307,263$ | 0 | 0 | 7,062,452$ | 166 | 17,500$ | 2,905,000$ |
| 8 |  Comets (NJ ) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,655,000$ | 2,655,000$ | 269,242$ | 0$ | 259,451$ | 0 | 0 | 6,615,600$ | 166 | 14,973$ | 2,485,518$ |
| 9 |  Condors (Edm) | 2000 | 1000 | 53 | 38 | 6828 | 3073 | 85.35% | 76.83% | 38 | 2475 - 82.51% | 183,667$ | 734,666$ | 3000 | 125 | 3,265,000$ | 3,265,000$ | 357,930$ | 0$ | 348,156$ | 0 | 0 | 6,979,327$ | 166 | 18,288$ | 3,035,808$ |
| 10 |  Crunch (TB ) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 3,140,000$ | 3,140,000$ | 318,258$ | 0$ | 308,482$ | 0 | 0 | 6,794,400$ | 166 | 17,609$ | 2,923,094$ |
| 11 |  Eagles (Col) | 2000 | 1000 | 50 | 30 | 9831 | 5000 | 98.31% | 100.00% | 37 | 2966 - 98.87% | 189,692$ | 948,460$ | 3000 | 125 | 4,230,000$ | 4,230,000$ | 419,971$ | 0$ | 411,280$ | 0 | 0 | 7,018,604$ | 166 | 23,533$ | 3,906,478$ |
| 12 |  Firebirds (Kra) | 2000 | 1000 | 50 | 40 | 7404 | 2884 | 92.55% | 72.10% | 38 | 2572 - 85.73% | 180,871$ | 723,485$ | 3000 | 125 | 3,356,000$ | 3,356,000$ | 334,125$ | 0$ | 324,335$ | 0 | 0 | 6,873,108$ | 166 | 18,783$ | 3,117,978$ |
| 13 |  Griffins (Det) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 2,467,500$ | 2,467,500$ | 244,646$ | 0$ | 234,864$ | 0 | 0 | 6,794,400$ | 166 | 13,954$ | 2,316,364$ |
| 14 |  Gulls (Ana) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 3,370,000$ | 3,370,000$ | 347,612$ | 0$ | 337,820$ | 0 | 0 | 6,794,400$ | 166 | 18,859$ | 3,130,594$ |
| 15 |  Icehogs (Chi) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 3,600,000$ | 3,600,000$ | 392,386$ | 0$ | 382,609$ | 0 | 0 | 6,794,400$ | 166 | 20,109$ | 3,338,094$ |
| 16 |  Iowa Wild (Min) | 2000 | 1000 | 50 | 35 | 11261 | 5263 | 93.84% | 87.72% | 36 | 2754 - 91.80% | 185,569$ | 1,113,412$ | 3000 | 125 | 2,960,000$ | 2,960,000$ | 305,652$ | 0$ | 295,872$ | 0 | 0 | 6,680,472$ | 166 | 16,630$ | 2,760,580$ |
| 17 |  Islanders (NYI) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,885,000$ | 2,885,000$ | 292,014$ | 0$ | 282,222$ | 0 | 0 | 6,615,600$ | 166 | 16,223$ | 2,693,018$ |
| 18 |  Marlies (Tor) | 2000 | 1000 | 40 | 25 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 156,450$ | 782,250$ | 3000 | 125 | 3,065,000$ | 3,065,000$ | 308,802$ | 0$ | 299,028$ | 0 | 0 | 5,788,650$ | 166 | 17,201$ | 2,855,366$ |
| 19 |  Monsters (Clb) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,910,000$ | 2,910,000$ | 296,493$ | 0$ | 286,714$ | 0 | 0 | 6,615,600$ | 166 | 16,359$ | 2,715,594$ |
| 20 |  Moose (Win) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 3,395,000$ | 3,395,000$ | 341,910$ | 0$ | 332,118$ | 0 | 0 | 6,615,600$ | 166 | 18,995$ | 3,153,170$ |
| 21 |  PenguinsF (Pit) | 2000 | 1000 | 45 | 30 | 12000 | 6000 | 100.00% | 100.00% | 36 | 3000 - 100.00% | 178,800$ | 1,072,800$ | 3000 | 125 | 3,105,000$ | 3,105,000$ | 305,320$ | 0$ | 295,545$ | 0 | 0 | 6,436,800$ | 166 | 17,418$ | 2,891,388$ |
| 22 |  Phantoms (Phi) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,105,000$ | 2,105,000$ | 210,574$ | 0$ | 200,786$ | 0 | 0 | 6,615,600$ | 166 | 11,984$ | 1,989,344$ |
| 23 |  Reign (LA ) | 2000 | 1000 | 55 | 40 | 8224 | 3809 | 82.24% | 76.18% | 37 | 2407 - 80.22% | 180,195$ | 900,974$ | 3000 | 125 | 4,490,100$ | 4,490,100$ | 431,926$ | 0$ | 422,144$ | 0 | 0 | 6,667,208$ | 166 | 24,946$ | 4,141,036$ |
| 24 |  Roadrunners (Uta) | 2000 | 1000 | 48 | 31 | 7411 | 3725 | 92.64% | 93.13% | 38 | 2784 - 92.80% | 178,068$ | 712,271$ | 3000 | 125 | 3,440,000$ | 3,440,000$ | 366,380$ | 0$ | 356,606$ | 0 | 0 | 6,766,574$ | 166 | 19,239$ | 3,193,674$ |
| 25 |  Rocket (Mon) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 2,580,000$ | 2,580,000$ | 276,848$ | 0$ | 267,064$ | 0 | 0 | 6,794,400$ | 166 | 14,565$ | 2,417,790$ |
| 26 |  SenatorsF (Ott) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 3,205,000$ | 3,205,000$ | 341,416$ | 0$ | 331,627$ | 0 | 0 | 6,794,400$ | 166 | 17,962$ | 2,981,692$ |
| 27 |  Silver Knights (LV ) | 2000 | 1000 | 45 | 30 | 8000 | 4000 | 100.00% | 100.00% | 38 | 3000 - 100.00% | 178,800$ | 715,200$ | 3000 | 125 | 2,790,000$ | 2,790,000$ | 284,676$ | 0$ | 274,894$ | 0 | 0 | 6,794,400$ | 166 | 15,707$ | 2,607,362$ |
| 28 |  StarsF (Dal) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 3,150,000$ | 3,150,000$ | 323,970$ | 0$ | 314,180$ | 0 | 0 | 6,615,600$ | 166 | 17,663$ | 2,932,058$ |
| 29 |  Thunderbirds (Stl) | 2000 | 1000 | 34 | 14 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 122,180$ | 610,900$ | 3000 | 125 | 5,105,000$ | 5,105,000$ | 513,504$ | 0$ | 503,730$ | 0 | 0 | 4,520,660$ | 166 | 28,288$ | 4,695,808$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 45 | 30 | 6000 | 3000 | 100.00% | 100.00% | 39 | 3000 - 100.00% | 178,800$ | 536,400$ | 3000 | 125 | 2,928,500$ | 2,928,500$ | 312,573$ | 0$ | 302,786$ | 0 | 0 | 6,973,200$ | 166 | 16,459$ | 2,732,194$ |
| 31 |  Wolves (Car) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 2,890,000$ | 2,890,000$ | 310,434$ | 0$ | 300,652$ | 0 | 0 | 6,615,600$ | 166 | 16,250$ | 2,697,500$ |
| 32 |  Wranglers (Cal) | 2000 | 1000 | 45 | 30 | 10000 | 5000 | 100.00% | 100.00% | 37 | 3000 - 100.00% | 178,800$ | 894,000$ | 3000 | 125 | 3,495,500$ | 3,495,500$ | 350,596$ | 0$ | 340,804$ | 0 | 0 | 6,615,600$ | 166 | 19,541$ | 3,243,806$ |