| 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 |
| Capacity | Ticket Price | Attendance | Attendance PCT | Income | Expenses | Estimate | ||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses |
| 1 |  Adirondack RED WINGS (DET) | 2397 | 2397 | 75 | 45 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 4794 | 130 | 3,063,900$ | 3,063,900$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 2 | 0$ | 0$ |
| 2 |  Anaheim DUCKS (NYR) | 2340 | 2340 | 150 | 75 | 5488 | 5258 | 78.18% | 74.90% | 37 | 3582 - 76.54% | 405,850$ | 1,217,550$ | 4680 | 130 | 4,087,250$ | 4,087,250$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 2 | 0$ | 0$ |
| 3 |  Bridgeport ISLANDERS (NYI) | 2390 | 2390 | 55 | 25 | 7170 | 7170 | 100.00% | 100.00% | 37 | 4780 - 100.00% | 191,200$ | 573,600$ | 4780 | 130 | 2,480,050$ | 2,480,050$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 2 | 0$ | 0$ |
| 4 |  Cleveland MONSTERS (VAN) | 3002 | 3002 | 50 | 25 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 6004 | 130 | 2,502,700$ | 2,502,700$ | 0$ | 0$ | 0$ | 25 | 0 | 0$ | 2 | 0$ | 0$ |
| 5 |  Fredericton EXPRESS (MTL) | 1639 | 1639 | 35 | 15 | 9834 | 9834 | 100.00% | 100.00% | 34 | 3278 - 100.00% | 81,950$ | 491,700$ | 3278 | 130 | 3,991,300$ | 3,991,300$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 2 | 0$ | 0$ |
| 6 |  Hershey BEARS (PHI) | 3643 | 3643 | 120 | 60 | 39057 | 39288 | 97.46% | 98.04% | 29 | 7122 - 97.75% | 640,375$ | 7,044,120$ | 7286 | 130 | 2,717,903$ | 2,717,903$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 2 | 0$ | 0$ |
| 7 |  Indianapolis ICE (CHI) | 7997 | 7997 | 30 | 10 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 15994 | 130 | 2,589,800$ | 2,589,800$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 2 | 0$ | 0$ |
| 8 |  Kalamazoo WINGS (MIN) | 2557 | 2557 | 50 | 30 | 7671 | 7671 | 100.00% | 100.00% | 37 | 5114 - 100.00% | 204,560$ | 613,680$ | 5114 | 130 | 2,324,900$ | 2,324,900$ | 0$ | 0$ | 0$ | 24 | 0 | 0$ | 2 | 0$ | 0$ |
| 9 |  Muskegon LUMBERJACKS (PIT) | 2550 | 2550 | 150 | 75 | 12356 | 12829 | 80.76% | 83.85% | 34 | 4198 - 82.30% | 469,263$ | 2,815,575$ | 5100 | 130 | 3,381,956$ | 3,381,956$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 2 | 0$ | 0$ |
| 10 |  New Haven NIGHTHAWKS (LAK) | 5586 | 5586 | 150 | 75 | 12547 | 12276 | 74.87% | 73.25% | 37 | 8274 - 74.06% | 934,250$ | 2,802,750$ | 11172 | 130 | 2,812,974$ | 2,812,974$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 2 | 0$ | 0$ |
| 11 |  Newmarket SAINTS (TOR) | 1850 | 1850 | 38 | 17 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3700 | 130 | 2,715,900$ | 2,715,900$ | 0$ | 0$ | 0$ | 31 | 0 | 0$ | 2 | 0$ | 0$ |
| 12 |  Orlando THUNDER (TBL) | 8923 | 8923 | 100 | 75 | 44615 | 37505 | 100.00% | 84.06% | 35 | 16424 - 92.03% | 1,454,875$ | 7,274,375$ | 17846 | 130 | 1,935,100$ | 1,935,100$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 2 | 0$ | 0$ |
| 13 |  Oshawa GENERALS (BOS) | 3367 | 3367 | 75 | 40 | 10101 | 10101 | 100.00% | 100.00% | 37 | 6734 - 100.00% | 387,205$ | 1,161,615$ | 6734 | 130 | 2,183,988$ | 2,183,988$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 2 | 0$ | 0$ |
| 14 |  Owen Sound ATTACK (VGK) | 2500 | 2500 | 150 | 75 | 19555 | 19955 | 86.91% | 88.69% | 31 | 4390 - 87.80% | 492,208$ | 4,429,875$ | 5000 | 130 | 2,768,300$ | 2,768,300$ | 0$ | 0$ | 0$ | 25 | 1 | 0$ | 2 | 0$ | 0$ |
| 15 |  PEI SENATORS (OTT) | 1859 | 1859 | 50 | 35 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 3718 | 130 | 2,200,900$ | 2,200,900$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 2 | 0$ | 0$ |
| 16 |  Rochester AMERICANS (BUF) | 5332 | 5332 | 50 | 0 | 15996 | 15996 | 100.00% | 100.00% | 37 | 10664 - 100.00% | 266,600$ | 799,800$ | 10664 | 130 | 2,108,800$ | 2,108,800$ | 0$ | 0$ | 0$ | 26 | 0 | 0$ | 2 | 0$ | 0$ |
| 17 |  Salt Lake GOLDEN EAGLES (CGY) | 3400 | 3400 | 150 | 75 | 4959 | 5323 | 72.93% | 78.28% | 38 | 5141 - 75.60% | 571,538$ | 1,143,075$ | 6800 | 130 | 2,583,800$ | 2,583,800$ | 0$ | 0$ | 0$ | 32 | 0 | 0$ | 2 | 0$ | 0$ |
| 18 |  Saskatchewan STAGS (HFD) | 3242 | 3242 | 30 | 20 | 16210 | 16210 | 100.00% | 100.00% | 35 | 6484 - 100.00% | 162,100$ | 810,500$ | 6484 | 130 | 2,411,600$ | 2,411,600$ | 0$ | 0$ | 0$ | 28 | 1 | 0$ | 2 | 0$ | 0$ |
| 19 |  Scottsdale HATTERS (PHX) | 1700 | 1700 | 150 | 75 | 19766 | 20401 | 89.44% | 92.31% | 27 | 3090 - 90.88% | 345,767$ | 4,494,975$ | 3400 | 130 | 2,410,000$ | 2,410,000$ | 0$ | 0$ | 0$ | 28 | 0 | 0$ | 2 | 0$ | 0$ |
| 20 |  Seattle KRAKEN (SJS) | 5013 | 5013 | 80 | 45 | 0 | 0 | 0% | 0% | 40 | 0 - 0% | 0$ | 0$ | 10026 | 130 | 1,986,400$ | 1,986,400$ | 0$ | 0$ | 0$ | 27 | 0 | 0$ | 2 | 0$ | 0$ |
| 21 |  Springfield THUNDERBIRDS (STL) | 3397 | 3397 | 60 | 40 | 6794 | 6794 | 100.00% | 100.00% | 38 | 6794 - 100.00% | 339,700$ | 679,400$ | 6794 | 130 | 2,807,638$ | 2,807,638$ | 0$ | 0$ | 0$ | 29 | 0 | 0$ | 2 | 0$ | 0$ |
| 22 |  Wyoming COWBOYS (KCS) | 2000 | 1000 | 150 | 75 | 15771 | 8137 | 87.62% | 90.41% | 31 | 2656 - 88.55% | 330,658$ | 2,975,925$ | 3000 | 130 | 2,748,512$ | 2,748,512$ | 0$ | 0$ | 0$ | 33 | 0 | 0$ | 2 | 0$ | 0$ |