| 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 | 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é de l’aréna | 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 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,710,100$ | 2,710,100$ | 745,115$ | 0$ | 718,475$ | 0 | 0 | 5,542,800$ | 135 | 15,272$ | 2,061,720$ |
| 2 |  Americans (Buf) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 3,365,000$ | 3,365,000$ | 1,039,358$ | 0$ | 1,012,710$ | 0 | 0 | 5,542,800$ | 135 | 18,832$ | 2,542,320$ |
| 3 |  Barracuda (SJ ) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 3,360,000$ | 3,360,000$ | 868,469$ | 0$ | 841,850$ | 0 | 0 | 5,364,000$ | 135 | 18,804$ | 2,538,540$ |
| 4 |  Bears (Was) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,340,000$ | 2,340,000$ | 674,733$ | 0$ | 648,098$ | 0 | 0 | 5,542,800$ | 135 | 13,261$ | 1,790,235$ |
| 5 |  BruinsF (Bos) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,345,000$ | 2,345,000$ | 694,011$ | 0$ | 667,357$ | 0 | 0 | 5,542,800$ | 135 | 13,288$ | 1,793,880$ |
| 6 |  Canucks (Van) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,375,000$ | 2,375,000$ | 708,823$ | 0$ | 682,198$ | 0 | 0 | 5,364,000$ | 135 | 13,451$ | 1,815,885$ |
| 7 |  Checkers (Flo) | 2000 | 1000 | 48 | 32 | 20019 | 9817 | 91.00% | 89.25% | 31 | 2712 - 90.41% | 181,989$ | 2,001,879$ | 3000 | 125 | 3,085,000$ | 3,085,000$ | 868,991$ | 0$ | 842,373$ | 0 | 0 | 5,641,659$ | 135 | 17,310$ | 2,336,850$ |
| 8 |  Comets (NJ ) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,525,000$ | 2,525,000$ | 720,331$ | 0$ | 693,689$ | 0 | 0 | 5,364,000$ | 135 | 14,266$ | 1,925,910$ |
| 9 |  Condors (Edm) | 2000 | 1000 | 53 | 38 | 18538 | 8633 | 84.26% | 78.48% | 31 | 2470 - 82.34% | 179,474$ | 1,974,213$ | 3000 | 125 | 3,625,000$ | 3,625,000$ | 973,658$ | 0$ | 947,048$ | 0 | 0 | 5,563,691$ | 135 | 20,245$ | 2,733,075$ |
| 10 |  Crunch (TB ) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,930,000$ | 2,930,000$ | 837,278$ | 0$ | 810,661$ | 0 | 0 | 5,542,800$ | 135 | 16,467$ | 2,223,045$ |
| 11 |  Eagles (Col) | 2000 | 1000 | 50 | 30 | 23056 | 12000 | 96.07% | 100.00% | 30 | 2921 - 97.38% | 187,218$ | 2,246,621$ | 3000 | 125 | 4,375,000$ | 4,375,000$ | 1,152,101$ | 0$ | 1,126,548$ | 0 | 0 | 5,616,552$ | 135 | 24,321$ | 3,283,335$ |
| 12 |  Firebirds (Kra) | 2000 | 1000 | 50 | 40 | 19460 | 8359 | 88.45% | 75.99% | 31 | 2529 - 84.30% | 177,088$ | 1,947,967$ | 3000 | 125 | 3,236,000$ | 3,236,000$ | 890,120$ | 0$ | 863,474$ | 0 | 0 | 5,489,725$ | 135 | 18,130$ | 2,447,550$ |
| 13 |  Griffins (Det) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,102,500$ | 2,102,500$ | 674,779$ | 0$ | 648,153$ | 0 | 0 | 5,542,800$ | 135 | 11,970$ | 1,615,950$ |
| 14 |  Gulls (Ana) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 3,460,000$ | 3,460,000$ | 968,101$ | 0$ | 941,468$ | 0 | 0 | 5,542,800$ | 135 | 19,348$ | 2,611,980$ |
| 15 |  Icehogs (Chi) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 4,050,000$ | 4,050,000$ | 1,081,703$ | 0$ | 1,055,085$ | 0 | 0 | 5,542,800$ | 135 | 22,554$ | 3,044,790$ |
| 16 |  Iowa Wild (Min) | 2000 | 1000 | 50 | 35 | 22145 | 10671 | 92.27% | 88.93% | 30 | 2735 - 91.16% | 183,858$ | 2,206,298$ | 3000 | 125 | 3,155,000$ | 3,155,000$ | 845,653$ | 0$ | 819,029$ | 0 | 0 | 5,515,745$ | 135 | 17,690$ | 2,388,150$ |
| 17 |  Islanders (NYI) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,705,000$ | 2,705,000$ | 788,297$ | 0$ | 761,645$ | 0 | 0 | 5,364,000$ | 135 | 15,245$ | 2,058,075$ |
| 18 |  Marlies (Tor) | 2000 | 1000 | 40 | 25 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 156,450$ | 1,877,400$ | 3000 | 125 | 2,865,000$ | 2,865,000$ | 821,380$ | 0$ | 794,773$ | 0 | 0 | 4,693,500$ | 135 | 16,114$ | 2,175,390$ |
| 19 |  Monsters (Clb) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,910,000$ | 2,910,000$ | 793,422$ | 0$ | 766,804$ | 0 | 0 | 5,364,000$ | 135 | 16,359$ | 2,208,465$ |
| 20 |  Moose (Win) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 3,285,000$ | 3,285,000$ | 910,907$ | 0$ | 884,272$ | 0 | 0 | 5,364,000$ | 135 | 18,397$ | 2,483,595$ |
| 21 |  PenguinsF (Pit) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 3,225,000$ | 3,225,000$ | 863,481$ | 0$ | 836,847$ | 0 | 0 | 5,364,000$ | 135 | 18,071$ | 2,439,585$ |
| 22 |  Phantoms (Phi) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,175,000$ | 2,175,000$ | 597,559$ | 0$ | 570,926$ | 0 | 0 | 5,364,000$ | 135 | 12,364$ | 1,669,140$ |
| 23 |  Reign (LA ) | 2000 | 1000 | 55 | 40 | 19521 | 9001 | 81.34% | 75.01% | 30 | 2377 - 79.23% | 178,017$ | 2,136,207$ | 3000 | 125 | 4,565,100$ | 4,565,100$ | 1,194,077$ | 0$ | 1,167,442$ | 0 | 0 | 5,340,518$ | 135 | 25,354$ | 3,422,790$ |
| 24 |  Roadrunners (Uta) | 2000 | 1000 | 46 | 30 | 20961 | 10649 | 95.28% | 96.81% | 31 | 2874 - 95.79% | 178,475$ | 1,963,230$ | 3000 | 125 | 3,450,000$ | 3,450,000$ | 926,006$ | 0$ | 899,378$ | 0 | 0 | 5,532,739$ | 135 | 19,293$ | 2,604,555$ |
| 25 |  Rocket (Mon) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,725,000$ | 2,725,000$ | 751,461$ | 0$ | 724,841$ | 0 | 0 | 5,542,800$ | 135 | 15,353$ | 2,072,655$ |
| 26 |  SenatorsF (Ott) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 3,340,000$ | 3,340,000$ | 931,124$ | 0$ | 904,471$ | 0 | 0 | 5,542,800$ | 135 | 18,696$ | 2,523,960$ |
| 27 |  Silver Knights (LV ) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,665,000$ | 2,665,000$ | 765,787$ | 0$ | 739,159$ | 0 | 0 | 5,542,800$ | 135 | 15,027$ | 2,028,645$ |
| 28 |  StarsF (Dal) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 3,140,000$ | 3,140,000$ | 882,725$ | 0$ | 856,074$ | 0 | 0 | 5,364,000$ | 135 | 17,609$ | 2,377,215$ |
| 29 |  Thunderbirds (Stl) | 2000 | 1000 | 35 | 15 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 124,212$ | 1,366,330$ | 3000 | 125 | 5,105,000$ | 5,105,000$ | 1,390,432$ | 0$ | 1,363,825$ | 0 | 0 | 3,850,566$ | 135 | 28,288$ | 3,818,880$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 45 | 30 | 22000 | 11000 | 100.00% | 100.00% | 31 | 3000 - 100.00% | 178,800$ | 1,966,800$ | 3000 | 125 | 2,898,500$ | 2,898,500$ | 834,471$ | 0$ | 807,833$ | 0 | 0 | 5,542,800$ | 135 | 16,296$ | 2,199,960$ |
| 31 |  Wolves (Car) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 2,845,000$ | 2,845,000$ | 834,755$ | 0$ | 808,121$ | 0 | 0 | 5,364,000$ | 135 | 16,005$ | 2,160,675$ |
| 32 |  Wranglers (Cal) | 2000 | 1000 | 45 | 30 | 24000 | 12000 | 100.00% | 100.00% | 30 | 3000 - 100.00% | 178,800$ | 2,145,600$ | 3000 | 125 | 3,295,500$ | 3,295,500$ | 923,213$ | 0$ | 896,563$ | 0 | 0 | 5,364,000$ | 135 | 18,454$ | 2,491,290$ |