| 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 | BELLEVILLE Senators (OTW) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,705,000$ | 1,705,000$ | 1,830,807$ | 0$ | 1,396,228$ | 0 | 0 | 0$ | 15 | 20,607$ | 288,498$ |
| 2 | BRIDGEPORT Sound Tigers (ISL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,702,000$ | 1,702,000$ | 2,185,493$ | 0$ | 1,455,440$ | 0 | 0 | 0$ | 15 | 23,757$ | 332,598$ |
| 3 | BROOKLYN Wolfpack (NYR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 3 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,121,500$ | 1,121,500$ | 1,253,503$ | 0$ | 1,123,117$ | 0 | 0 | 0$ | 15 | 11,883$ | 166,362$ |
| 4 | CHICAGO Wolves (STL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,042,000$ | 1,042,000$ | 984,471$ | 0$ | 913,326$ | 0 | 0 | 0$ | 15 | 10,503$ | 147,042$ |
| 5 | CLEVELAND Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,326,500$ | 1,326,500$ | 1,218,114$ | 0$ | 1,152,921$ | 0 | 0 | 0$ | 15 | 13,098$ | 183,372$ |
| 6 | COLORADO Eagles (COL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,700,000$ | 1,700,000$ | 1,667,128$ | 0$ | 1,535,905$ | 0 | 0 | 0$ | 15 | 17,299$ | 242,186$ |
| 7 | CORNWALL Aces (QUE) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 740,000$ | 740,000$ | 1,135,960$ | 0$ | 701,371$ | 0 | 0 | 0$ | 15 | 11,589$ | 162,246$ |
| 8 | HERSEY Bears (WSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,170,000$ | 1,170,000$ | 1,648,869$ | 0$ | 1,170,827$ | 0 | 0 | 0$ | 15 | 16,075$ | 225,050$ |
| 9 | HOLLYWOOD Oscar (SEA) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,535,000$ | 1,492,500$ | 1,671,580$ | 0$ | 1,384,766$ | 0 | 0 | 0$ | 15 | 17,430$ | 244,020$ |
| 10 | IOWA Wild (MIN) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,375,000$ | 1,375,000$ | 1,228,679$ | 0$ | 1,163,486$ | 0 | 0 | 0$ | 15 | 13,551$ | 189,714$ |
| 11 | LAVAL Rockets (MTL) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,834,000$ | 1,759,000$ | 2,251,688$ | 0$ | 1,599,773$ | 0 | 0 | 0$ | 15 | 24,150$ | 338,100$ |
| 12 | LEHIGH VALLEY Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,570,000$ | 1,570,000$ | 2,118,433$ | 0$ | 1,381,389$ | 0 | 0 | 0$ | 15 | 22,598$ | 316,372$ |
| 13 | MANITOBA Moose (WPG) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 3 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,867,500$ | 1,867,500$ | 1,653,820$ | 0$ | 1,582,501$ | 0 | 0 | 0$ | 15 | 18,220$ | 255,080$ |
| 14 | MILWAUKEE Admirals (NSH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,615,000$ | 1,572,500$ | 1,948,602$ | 0$ | 1,383,630$ | 0 | 0 | 0$ | 15 | 21,168$ | 296,352$ |
| 15 | MONT-LAURIER Sommet (EDM) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,545,000$ | 1,545,000$ | 1,499,820$ | 0$ | 1,326,003$ | 0 | 0 | 0$ | 15 | 16,308$ | 228,312$ |
| 16 | PROVIDENCE Bruins (BOS) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,500,000$ | 2,475,000$ | 2,106,834$ | 0$ | 1,748,731$ | 0 | 0 | 0$ | 15 | 27,215$ | 381,010$ |
| 17 | PV Sharapovas (DET) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,862,500$ | 1,862,500$ | 1,715,302$ | 0$ | 1,584,930$ | 0 | 0 | 0$ | 15 | 18,808$ | 263,312$ |
| 18 | ROCKFORD IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,925,000$ | 1,925,000$ | 2,120,439$ | 0$ | 1,729,374$ | 0 | 0 | 0$ | 15 | 22,196$ | 310,744$ |
| 19 | SAN DIEGO Gulls (ANH) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 496,000$ | 496,000$ | 578,064$ | 0$ | 429,987$ | 0 | 0 | 0$ | 15 | 6,228$ | 87,192$ |
| 20 | STOCKTON Flames (CGY) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 5 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,880,000$ | 1,880,000$ | 1,874,113$ | 0$ | 1,743,730$ | 0 | 0 | 0$ | 15 | 18,972$ | 265,608$ |
| 21 | SYRACUSE Crunch (TB ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,828,000$ | 1,828,000$ | 1,932,989$ | 0$ | 1,650,546$ | 0 | 0 | 0$ | 15 | 20,121$ | 281,694$ |
| 22 | TORONTO Marlies (TOR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,380,000$ | 1,380,000$ | 2,282,431$ | 0$ | 1,181,204$ | 0 | 0 | 0$ | 15 | 24,738$ | 346,332$ |
| 23 | TUSCON Roadrunners (ARZ) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,986,000$ | 1,986,000$ | 2,430,626$ | 0$ | 1,732,142$ | 0 | 0 | 0$ | 15 | 27,907$ | 390,698$ |
| 24 | UTICA Comets (VCR) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,989,500$ | 1,989,500$ | 2,306,782$ | 0$ | 1,872,198$ | 0 | 0 | 0$ | 15 | 23,266$ | 325,724$ |
| 25 | VICTORIAVILLE Tigres (VGK) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 1,975,000$ | 1,932,500$ | 2,023,485$ | 0$ | 1,893,099$ | 0 | 0 | 0$ | 15 | 19,860$ | 278,040$ |
| 26 | WILKIES-BARRIE Penguins (PIT) | 2000 | 1000 | 35 | 15 | 0 | 0 | 0.00% | 0.00% | 4 | 0 - 0.00% | 0$ | 0$ | 3000 | 100 | 2,002,500$ | 2,002,500$ | 2,038,820$ | 0$ | 1,716,382$ | 0 | 0 | 0$ | 15 | 22,182$ | 310,548$ |