| 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 | Salaire total moyen 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 (NSH) | 2000 | 1000 | 28 | 18 | 29431 | 14032 | 98.10% | 93.55% | 26 | 2898 - 96.58% | 86,310$ | 1,294,646$ | 3000 | 100 | 2,494,090$ | 2,214,230$ | 1,282,167$ | 12,990$ | 789,554$ | 0 | 0 | 2,244,053$ | 130 | 20,803$ | 2,704,390$ |
| 2 |  Americans (BUF) | 2000 | 1000 | 25 | 15 | 25503 | 12702 | 98.09% | 97.71% | 28 | 2939 - 97.96% | 79,625$ | 1,035,131$ | 3000 | 100 | 2,200,830$ | 1,931,200$ | 886,789$ | 11,463$ | 707,736$ | 0 | 0 | 2,229,513$ | 130 | 14,327$ | 1,862,510$ |
| 3 |  Barracuda (SJS) | 2000 | 1000 | 35 | 25 | 19269 | 8159 | 74.11% | 62.76% | 28 | 2110 - 70.33% | 84,460$ | 1,097,986$ | 3000 | 100 | 2,205,000$ | 2,002,680$ | 915,167$ | 11,484$ | 721,417$ | 0 | 0 | 2,364,893$ | 130 | 14,609$ | 1,899,170$ |
| 4 |  Bears (WSH) | 2000 | 1000 | 50 | 25 | 13759 | 8293 | 49.14% | 59.24% | 27 | 1575 - 52.50% | 79,935$ | 1,119,095$ | 3000 | 100 | 2,652,870$ | 2,365,370$ | 1,067,689$ | 13,817$ | 869,835$ | 0 | 0 | 2,158,255$ | 130 | 16,942$ | 2,202,460$ |
| 5 |  Bruins (BOS) | 2000 | 1000 | 48 | 28 | 13983 | 7083 | 53.78% | 54.48% | 28 | 1620 - 54.02% | 83,607$ | 1,086,885$ | 3000 | 100 | 3,240,000$ | 3,000,000$ | 1,360,254$ | 16,875$ | 1,034,409$ | 0 | 0 | 2,340,983$ | 130 | 22,083$ | 2,870,790$ |
| 6 |  Checkers (FLA) | 2000 | 1000 | 31 | 15 | 21454 | 12913 | 82.52% | 99.33% | 28 | 2644 - 88.12% | 82,574$ | 1,073,462$ | 3000 | 100 | 1,907,500$ | 1,707,500$ | 1,235,616$ | 9,935$ | 589,762$ | 0 | 0 | 2,312,072$ | 130 | 20,352$ | 2,645,760$ |
| 7 |  Comets (VAN) | 2000 | 1000 | 25 | 15 | 27778 | 13866 | 99.21% | 99.04% | 27 | 2975 - 99.15% | 80,575$ | 1,128,050$ | 3000 | 100 | 3,174,000$ | 2,752,400$ | 1,238,078$ | 16,531$ | 1,024,922$ | 0 | 0 | 2,175,525$ | 130 | 19,969$ | 2,595,970$ |
| 8 |  Condors (EDM) | 2000 | 1000 | 30 | 20 | 25004 | 9875 | 96.17% | 75.96% | 28 | 2683 - 89.43% | 91,117$ | 1,184,525$ | 3000 | 100 | 4,037,840$ | 3,318,200$ | 1,591,642$ | 21,030$ | 1,297,662$ | 0 | 0 | 2,551,285$ | 130 | 25,718$ | 3,343,340$ |
| 9 |  Crunch (TBL) | 2000 | 1000 | 28 | 17 | 27335 | 13824 | 97.63% | 98.74% | 27 | 2940 - 98.00% | 89,320$ | 1,250,486$ | 3000 | 100 | 2,501,120$ | 2,413,620$ | 968,621$ | 13,027$ | 805,670$ | 0 | 0 | 2,411,652$ | 130 | 15,631$ | 2,032,030$ |
| 10 |  Devils (NJD) | 2000 | 1000 | 20 | 10 | 23959 | 12000 | 99.83% | 100.00% | 29 | 2997 - 99.89% | 62,415$ | 748,975$ | 3000 | 100 | 1,979,400$ | 1,606,067$ | 813,011$ | 10,309$ | 651,523$ | 0 | 0 | 1,810,023$ | 130 | 12,914$ | 1,678,820$ |
| 11 |  Eagles (COL) | 2000 | 1000 | 30 | 15 | 24921 | 12935 | 95.85% | 99.50% | 28 | 2912 - 97.07% | 90,544$ | 1,177,067$ | 3000 | 100 | 2,072,730$ | 2,032,730$ | 990,229$ | 10,795$ | 664,272$ | 0 | 0 | 2,535,221$ | 130 | 16,004$ | 2,080,520$ |
| 12 |  Firebirds (SEA) | 2000 | 1000 | 35 | 25 | 19690 | 8562 | 70.32% | 61.16% | 27 | 2018 - 67.27% | 80,643$ | 1,129,000$ | 3000 | 100 | 1,597,500$ | 1,562,500$ | 796,296$ | 7,799$ | 535,337$ | 0 | 0 | 2,177,357$ | 130 | 12,487$ | 1,623,310$ |
| 13 |  Griffins (DET) | 2000 | 1000 | 35 | 15 | 22113 | 14850 | 73.71% | 99.00% | 26 | 2464 - 82.14% | 83,059$ | 1,245,881$ | 3000 | 100 | 2,112,400$ | 1,992,400$ | 907,786$ | 11,002$ | 687,544$ | 0 | 0 | 2,159,527$ | 130 | 14,648$ | 1,904,240$ |
| 14 |  Gulls (ANA) | 2000 | 1000 | 25 | 15 | 29848 | 14844 | 99.49% | 98.96% | 26 | 2979 - 99.32% | 80,738$ | 1,211,074$ | 3000 | 100 | 2,605,100$ | 2,440,500$ | 985,610$ | 13,568$ | 824,148$ | 0 | 0 | 2,099,195$ | 130 | 16,172$ | 2,102,360$ |
| 15 |  IceHogs (CHI) | 2000 | 1000 | 40 | 30 | 16673 | 6787 | 64.13% | 52.21% | 28 | 1805 - 60.15% | 83,705$ | 1,088,161$ | 3000 | 100 | 2,616,600$ | 2,256,600$ | 1,416,401$ | 13,133$ | 930,025$ | 0 | 0 | 2,343,731$ | 130 | 21,441$ | 2,787,330$ |
| 16 |  Marlies (TOR) | 2000 | 1000 | 40 | 25 | 16352 | 7976 | 62.89% | 61.35% | 28 | 1871 - 62.38% | 82,065$ | 1,066,850$ | 3000 | 100 | 1,852,500$ | 1,772,500$ | 855,147$ | 9,648$ | 575,895$ | 0 | 0 | 2,297,831$ | 130 | 14,076$ | 1,829,880$ |
| 17 |  Monsters (CBJ) | 2000 | 1000 | 25 | 15 | 33551 | 16791 | 98.68% | 98.77% | 24 | 2961 - 98.71% | 80,194$ | 1,363,301$ | 3000 | 100 | 1,688,390$ | 1,488,390$ | 849,694$ | 8,794$ | 557,074$ | 0 | 0 | 1,924,660$ | 130 | 13,481$ | 1,752,530$ |
| 18 |  Moose (WPG) | 2000 | 1000 | 25 | 15 | 27755 | 13727 | 99.13% | 98.05% | 27 | 2963 - 98.77% | 80,338$ | 1,124,725$ | 3000 | 100 | 1,791,780$ | 1,511,780$ | 872,547$ | 9,332$ | 562,373$ | 0 | 0 | 2,169,112$ | 130 | 14,280$ | 1,856,400$ |
| 19 |  Penguins (PIT) | 2000 | 1000 | 45 | 25 | 13835 | 7497 | 57.65% | 62.48% | 29 | 1778 - 59.26% | 84,375$ | 1,012,499$ | 3000 | 100 | 2,509,030$ | 2,438,970$ | 1,043,478$ | 13,068$ | 801,306$ | 0 | 0 | 2,446,873$ | 130 | 16,974$ | 2,206,620$ |
| 20 |  Phantoms (PHI) | 2000 | 1000 | 25 | 15 | 25642 | 12817 | 98.62% | 98.59% | 28 | 2958 - 98.61% | 80,126$ | 1,041,632$ | 3000 | 100 | 3,048,400$ | 2,749,500$ | 1,176,678$ | 15,395$ | 980,362$ | 0 | 0 | 2,243,515$ | 130 | 19,002$ | 2,470,260$ |
| 21 |  Reign (LAK) | 2000 | 1000 | 30 | 20 | 22744 | 9205 | 94.77% | 76.71% | 29 | 2662 - 88.75% | 90,252$ | 1,083,025$ | 3000 | 100 | 2,022,560$ | 1,964,710$ | 841,505$ | 10,534$ | 646,143$ | 0 | 0 | 2,617,310$ | 130 | 13,659$ | 1,775,670$ |
| 22 |  Roadrunners (ARI) | 2000 | 1000 | 35 | 19 | 22398 | 11396 | 86.15% | 87.66% | 28 | 2600 - 86.65% | 86,302$ | 1,121,920$ | 3000 | 100 | 2,327,100$ | 2,023,500$ | 881,029$ | 12,120$ | 719,581$ | 0 | 0 | 2,416,443$ | 130 | 14,724$ | 1,914,120$ |
| 23 |  Rocket (MTL) | 2000 | 1000 | 25 | 15 | 32000 | 15768 | 100.00% | 98.55% | 25 | 2986 - 99.52% | 80,978$ | 1,295,649$ | 3000 | 100 | 1,537,100$ | 1,394,600$ | 687,338$ | 8,006$ | 524,717$ | 0 | 0 | 2,024,452$ | 130 | 10,610$ | 1,379,300$ |
| 24 |  Senators (OTT) | 2000 | 1000 | 20 | 10 | 31950 | 16000 | 99.84% | 100.00% | 25 | 2997 - 99.90% | 62,422$ | 998,750$ | 3000 | 100 | 1,952,500$ | 1,592,500$ | 913,767$ | 10,169$ | 670,104$ | 0 | 0 | 1,560,547$ | 130 | 14,076$ | 1,829,880$ |
| 25 |  Silver Knights (VGK) | 2000 | 1000 | 30 | 15 | 27233 | 13754 | 97.26% | 98.24% | 27 | 2928 - 97.59% | 91,366$ | 1,279,124$ | 3000 | 100 | 2,950,070$ | 2,690,070$ | 1,210,102$ | 15,365$ | 951,757$ | 0 | 0 | 2,466,882$ | 130 | 19,532$ | 2,539,160$ |
| 26 |  Sound Tigers (NYI) | 2000 | 1000 | 30 | 15 | 27876 | 13927 | 99.56% | 99.48% | 27 | 2986 - 99.53% | 93,320$ | 1,306,482$ | 3000 | 100 | 1,970,000$ | 1,850,000$ | 958,024$ | 10,260$ | 635,066$ | 0 | 0 | 2,519,644$ | 130 | 15,469$ | 2,010,970$ |
| 27 |  Stars (DAL) | 2000 | 1000 | 45 | 35 | 13527 | 5334 | 56.36% | 44.45% | 29 | 1572 - 52.39% | 82,855$ | 994,258$ | 3000 | 100 | 3,093,160$ | 2,813,160$ | 1,181,644$ | 16,110$ | 1,017,460$ | 0 | 0 | 2,402,790$ | 130 | 18,714$ | 2,432,820$ |
| 28 |  Thunderbirds (STL) | 2000 | 1000 | 30 | 18 | 21387 | 10802 | 97.21% | 98.20% | 30 | 2926 - 97.54% | 95,005$ | 1,045,056$ | 3000 | 100 | 2,439,900$ | 2,399,900$ | 979,036$ | 12,708$ | 751,057$ | 0 | 0 | 2,850,153$ | 130 | 16,354$ | 2,126,020$ |
| 29 |  Wild (MIN) | 2000 | 1000 | 25 | 15 | 21928 | 10766 | 99.67% | 97.87% | 30 | 2972 - 99.07% | 80,647$ | 887,114$ | 3000 | 100 | 2,725,470$ | 2,610,470$ | 1,128,078$ | 13,700$ | 901,036$ | 0 | 0 | 2,419,402$ | 130 | 17,841$ | 2,319,330$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 25 | 15 | 21867 | 10806 | 99.40% | 98.24% | 30 | 2970 - 99.01% | 80,541$ | 885,956$ | 3000 | 100 | 2,071,000$ | 1,991,000$ | 835,533$ | 10,786$ | 674,034$ | 0 | 0 | 2,416,244$ | 130 | 13,391$ | 1,740,830$ |
| 31 |  Wolves (CAR) | 2000 | 1000 | 25 | 15 | 21853 | 10779 | 99.33% | 97.99% | 30 | 2967 - 98.88% | 80,456$ | 885,013$ | 3000 | 100 | 3,911,020$ | 3,711,020$ | 1,534,742$ | 19,863$ | 1,241,052$ | 0 | 0 | 2,413,672$ | 130 | 25,057$ | 3,257,410$ |
| 32 |  Wranglers (CGY) | 2000 | 1000 | 25 | 15 | 25738 | 12772 | 98.99% | 98.25% | 28 | 2962 - 98.74% | 80,291$ | 1,043,788$ | 3000 | 100 | 1,870,890$ | 1,815,790$ | 924,514$ | 9,744$ | 601,563$ | 0 | 0 | 2,248,159$ | 130 | 14,953$ | 1,943,890$ |