| 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 | 30 | 20 | 78580 | 37084 | 98.23% | 92.71% | -30 | 2892 - 96.39% | 96,846$ | 3,873,849$ | 3000 | 100 | 2,391,700$ | 2,391,700$ | 3,079,727$ | 0$ | 2,323,520$ | 0 | 0 | -2,905,387$ | 1 | 16,363$ | 16,363$ |
| 2 |  Americans (BUF) | 2000 | 1000 | 25 | 15 | 81244 | 40927 | 99.08% | 99.82% | -31 | 2980 - 99.33% | 80,640$ | 3,306,258$ | 3000 | 100 | 2,433,870$ | 2,433,870$ | 2,976,260$ | 0$ | 2,419,938$ | 0 | 0 | -2,499,854$ | 1 | 15,541$ | 15,541$ |
| 3 |  Barracuda (SJS) | 2000 | 1000 | 35 | 25 | 65115 | 29319 | 79.41% | 71.51% | -31 | 2303 - 76.78% | 91,829$ | 3,765,003$ | 3000 | 100 | 1,929,860$ | 1,929,860$ | 2,388,772$ | 0$ | 1,885,149$ | 0 | 0 | -2,846,710$ | 1 | 12,656$ | 12,656$ |
| 4 |  Bears (WSH) | 2000 | 1000 | 50 | 25 | 45805 | 28809 | 55.86% | 70.27% | -31 | 1820 - 60.66% | 91,783$ | 3,763,095$ | 3000 | 100 | 2,390,000$ | 2,390,000$ | 3,054,024$ | 0$ | 2,298,368$ | 0 | 0 | -2,845,267$ | 1 | 16,354$ | 16,354$ |
| 5 |  Bruins (BOS) | 2000 | 1000 | 48 | 28 | 47770 | 26184 | 58.26% | 63.86% | -31 | 1804 - 60.13% | 92,260$ | 3,782,640$ | 3000 | 100 | 2,669,990$ | 2,669,990$ | 3,370,610$ | 0$ | 2,765,896$ | 0 | 0 | -2,860,045$ | 1 | 17,031$ | 17,031$ |
| 6 |  Checkers (FLA) | 2000 | 1000 | 31 | 15 | 80251 | 40851 | 97.87% | 99.64% | -31 | 2954 - 98.46% | 94,529$ | 3,875,683$ | 3000 | 100 | 2,127,500$ | 2,127,500$ | 3,097,524$ | 0$ | 2,202,130$ | 0 | 0 | -2,930,394$ | 1 | 15,768$ | 15,768$ |
| 7 |  Comets (VAN) | 2000 | 1000 | 25 | 15 | 81348 | 40725 | 99.20% | 99.33% | -31 | 2977 - 99.25% | 80,627$ | 3,305,717$ | 3000 | 100 | 3,130,700$ | 3,130,700$ | 4,105,865$ | 0$ | 3,105,119$ | 0 | 0 | -2,499,445$ | 1 | 21,514$ | 21,514$ |
| 8 |  Condors (EDM) | 2000 | 1000 | 100 | 99 | 32391 | 11698 | 40.49% | 29.25% | -30 | 1102 - 36.74% | 93,593$ | 3,743,702$ | 3000 | 100 | 4,308,950$ | 4,308,950$ | 5,172,730$ | 0$ | 4,268,216$ | 0 | 0 | -2,807,776$ | 1 | 27,130$ | 27,130$ |
| 9 |  Crunch (TBL) | 2000 | 1000 | 28 | 17 | 81703 | 40149 | 99.64% | 97.92% | -31 | 2972 - 99.07% | 90,555$ | 3,712,772$ | 3000 | 100 | 2,979,970$ | 2,979,970$ | 3,736,999$ | 0$ | 2,936,101$ | 0 | 0 | -2,807,218$ | 1 | 19,687$ | 19,687$ |
| 10 |  Devils (NJD) | 2000 | 1000 | 20 | 10 | 81986 | 41000 | 99.98% | 100.00% | -31 | 3000 - 99.99% | 62,491$ | 2,562,150$ | 3000 | 100 | 3,404,520$ | 3,404,520$ | 3,856,094$ | 0$ | 3,348,335$ | 0 | 0 | -1,937,235$ | 1 | 20,336$ | 20,336$ |
| 11 |  Eagles (COL) | 2000 | 1000 | 30 | 15 | 78638 | 39857 | 98.30% | 99.64% | -30 | 2962 - 98.75% | 92,406$ | 3,696,245$ | 3000 | 100 | 2,845,900$ | 2,845,900$ | 3,455,496$ | 0$ | 2,551,297$ | 0 | 0 | -2,772,184$ | 1 | 19,510$ | 19,510$ |
| 12 |  Firebirds (SEA) | 2000 | 1000 | 35 | 25 | 66057 | 29188 | 80.56% | 71.19% | -31 | 2323 - 77.43% | 92,735$ | 3,802,117$ | 3000 | 100 | 2,480,000$ | 2,480,000$ | 3,300,384$ | 0$ | 2,497,812$ | 0 | 0 | -2,874,771$ | 1 | 17,083$ | 17,083$ |
| 13 |  Griffins (DET) | 2000 | 1000 | 35 | 15 | 65787 | 40948 | 80.23% | 99.87% | -31 | 2603 - 86.78% | 88,926$ | 3,645,952$ | 3000 | 100 | 1,687,500$ | 1,687,500$ | 2,419,370$ | 0$ | 1,673,260$ | 0 | 0 | -2,756,695$ | 1 | 12,695$ | 12,695$ |
| 14 |  Gulls (ANA) | 2000 | 1000 | 25 | 15 | 81564 | 40861 | 99.47% | 99.66% | -31 | 2986 - 99.53% | 80,854$ | 3,315,019$ | 3000 | 100 | 3,129,060$ | 3,129,060$ | 3,591,575$ | 0$ | 3,083,868$ | 0 | 0 | -2,506,478$ | 1 | 18,901$ | 18,901$ |
| 15 |  IceHogs (CHI) | 2000 | 1000 | 40 | 30 | 57218 | 24426 | 69.78% | 59.58% | -31 | 1991 - 66.38% | 92,119$ | 3,776,877$ | 3000 | 100 | 2,437,600$ | 2,437,600$ | 2,819,068$ | 0$ | 2,458,675$ | 0 | 0 | -2,855,687$ | 1 | 14,519$ | 14,519$ |
| 16 |  Marlies (TOR) | 2000 | 1000 | 40 | 25 | 56557 | 28896 | 68.97% | 70.48% | -31 | 2084 - 69.47% | 90,996$ | 3,730,852$ | 3000 | 100 | 1,855,000$ | 1,855,000$ | 2,773,185$ | 0$ | 1,918,750$ | 0 | 0 | -2,820,888$ | 1 | 14,089$ | 14,089$ |
| 17 |  Monsters (CBJ) | 2000 | 1000 | 25 | 15 | 81580 | 40881 | 99.49% | 99.71% | -31 | 2987 - 99.56% | 80,875$ | 3,315,892$ | 3000 | 100 | 2,320,830$ | 2,320,830$ | 3,082,569$ | 0$ | 2,332,062$ | 0 | 0 | -2,507,138$ | 1 | 15,994$ | 15,994$ |
| 18 |  Moose (WPG) | 2000 | 1000 | 25 | 15 | 79414 | 39858 | 99.27% | 99.65% | -30 | 2982 - 99.39% | 80,726$ | 3,229,024$ | 3000 | 100 | 1,433,880$ | 1,433,880$ | 2,551,345$ | 0$ | 1,549,110$ | 0 | 0 | -2,421,768$ | 1 | 12,676$ | 12,676$ |
| 19 |  Penguins (PIT) | 2000 | 1000 | 35 | 20 | 64849 | 38710 | 79.08% | 94.41% | -31 | 2526 - 84.19% | 93,325$ | 3,826,321$ | 3000 | 100 | 2,840,350$ | 2,840,350$ | 3,109,146$ | 0$ | 2,802,732$ | 0 | 0 | -2,893,072$ | 1 | 16,356$ | 16,356$ |
| 20 |  Phantoms (PHI) | 2000 | 1000 | 30 | 20 | 80192 | 38012 | 97.80% | 92.71% | -31 | 2883 - 96.10% | 96,524$ | 3,957,503$ | 3000 | 100 | 2,654,200$ | 2,654,200$ | 3,128,900$ | 0$ | 2,624,724$ | 0 | 0 | -2,992,258$ | 1 | 16,428$ | 16,428$ |
| 21 |  Reign (LAK) | 2000 | 1000 | 30 | 20 | 80904 | 39272 | 98.66% | 95.79% | -31 | 2931 - 97.70% | 97,944$ | 4,015,699$ | 3000 | 100 | 2,140,000$ | 2,140,000$ | 3,098,353$ | 0$ | 2,089,834$ | 0 | 0 | -3,036,260$ | 1 | 16,354$ | 16,354$ |
| 22 |  Roadrunners (UTA) | 2000 | 1000 | 35 | 20 | 67039 | 38315 | 83.80% | 95.79% | -30 | 2634 - 87.80% | 95,015$ | 3,800,593$ | 3000 | 100 | 2,393,650$ | 2,293,650$ | 2,847,516$ | 0$ | 2,344,581$ | 0 | 0 | -2,850,445$ | 1 | 15,071$ | 15,071$ |
| 23 |  Rocket (MTL) | 2000 | 1000 | 25 | 15 | 81681 | 40871 | 99.61% | 99.69% | -31 | 2989 - 99.64% | 80,948$ | 3,318,862$ | 3000 | 100 | 1,691,000$ | 1,691,000$ | 2,681,492$ | 0$ | 1,679,732$ | 0 | 0 | -2,509,383$ | 1 | 14,016$ | 14,016$ |
| 24 |  Senators (OTT) | 2000 | 1000 | 20 | 10 | 81956 | 41000 | 99.95% | 100.00% | -31 | 2999 - 99.96% | 62,473$ | 2,561,400$ | 3000 | 100 | 2,092,500$ | 2,092,500$ | 3,023,622$ | 0$ | 2,073,653$ | 0 | 0 | -1,936,668$ | 1 | 15,846$ | 15,846$ |
| 25 |  Silver Knights (VGK) | 2000 | 1000 | 30 | 15 | 80615 | 40766 | 98.31% | 99.43% | -31 | 2961 - 98.68% | 92,376$ | 3,787,426$ | 3000 | 100 | 1,840,000$ | 1,840,000$ | 2,550,314$ | 0$ | 1,754,462$ | 0 | 0 | -2,863,664$ | 1 | 13,750$ | 13,750$ |
| 26 |  Sound Tigers (NYI) | 2000 | 1000 | 30 | 15 | 80569 | 40780 | 98.25% | 99.46% | -31 | 2960 - 98.66% | 92,341$ | 3,785,964$ | 3000 | 100 | 1,867,880$ | 1,867,880$ | 3,049,122$ | 0$ | 1,853,026$ | 0 | 0 | -2,862,558$ | 1 | 15,979$ | 15,979$ |
| 27 |  Stars (DAL) | 2000 | 1000 | 45 | 35 | 49593 | 20687 | 60.48% | 50.46% | -31 | 1714 - 57.14% | 90,114$ | 3,694,662$ | 3000 | 100 | 2,316,000$ | 2,316,000$ | 2,911,125$ | 0$ | 2,408,802$ | 0 | 0 | -2,793,525$ | 1 | 14,667$ | 14,667$ |
| 28 |  Thunderbirds (STL) | 2000 | 1000 | 30 | 18 | 80022 | 40316 | 97.59% | 98.33% | -31 | 2935 - 97.84% | 95,315$ | 3,907,935$ | 3000 | 100 | 1,795,000$ | 1,795,000$ | 2,995,218$ | 0$ | 1,997,855$ | 0 | 0 | -2,954,780$ | 1 | 15,078$ | 15,078$ |
| 29 |  Wild (MIN) | 2000 | 1000 | 60 | 40 | 38101 | 18373 | 46.46% | 44.81% | -31 | 1377 - 45.91% | 92,103$ | 3,776,225$ | 3000 | 100 | 2,223,000$ | 2,223,000$ | 2,893,364$ | 0$ | 2,186,961$ | 0 | 0 | -2,855,195$ | 1 | 15,224$ | 15,224$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 25 | 15 | 81280 | 40782 | 99.12% | 99.47% | -31 | 2977 - 99.24% | 80,602$ | 3,304,663$ | 3000 | 100 | 2,147,980$ | 2,147,980$ | 2,561,615$ | 0$ | 2,047,214$ | 0 | 0 | -2,498,648$ | 1 | 13,792$ | 13,792$ |
| 31 |  Wolves (CAR) | 2000 | 1000 | 25 | 15 | 81423 | 40860 | 99.30% | 99.66% | -31 | 2983 - 99.42% | 80,746$ | 3,310,594$ | 3000 | 100 | 3,565,310$ | 3,565,310$ | 4,551,661$ | 0$ | 3,599,838$ | 0 | 0 | -2,503,132$ | 1 | 23,517$ | 23,517$ |
| 32 |  Wranglers (CGY) | 2000 | 1000 | 25 | 15 | 79688 | 39883 | 99.61% | 99.71% | -30 | 2989 - 99.64% | 80,951$ | 3,238,056$ | 3000 | 100 | 2,477,010$ | 2,477,010$ | 3,377,961$ | 0$ | 2,379,600$ | 0 | 0 | -2,428,542$ | 1 | 18,109$ | 18,109$ |