| 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 Total Estimate | ||||||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| # | Team | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Level1 | Level2 | Level3 | Level4 | Luxury | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Special Salary Cap Value | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Luxury Taxe Total | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses | Estimated Season Expenses | Current Bank Account | Projected Bank Account |
| 1 | AEROS | 3000 | 2500 | 1200 | 2000 | 500 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 9200 | 100 | 731,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 43,344,079$ | 43,344,079$ |
| 2 | CRUSADERS | 3000 | 2500 | 2000 | 1900 | 500 | 100 | 60 | 35 | 25 | 200 | 6000 | 5000 | 3616 | 3800 | 1000 | 100.00% | 100.00% | 90.40% | 100.00% | 100.00% | 40 | 9708 - 98.06% | 859,014$ | 1,718,028$ | 9900 | 100 | 859,500$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 46,156,062$ | 46,156,062$ |
| 3 | FIGHTING SAINTS | 5000 | 4000 | 3000 | 3500 | 500 | 100 | 60 | 35 | 25 | 200 | 3432 | 2857 | 1969 | 2190 | 500 | 68.64% | 71.43% | 65.63% | 62.57% | 100.00% | 41 | 10948 - 68.43% | 959,771$ | 959,771$ | 16000 | 100 | 704,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 47,167,690$ | 47,167,690$ |
| 4 | GOLDEN BLADES | 6000 | 5000 | 2000 | 4000 | 1006 | 100 | 60 | 35 | 25 | 200 | 3850 | 2784 | 2000 | 2278 | 550 | 64.17% | 55.68% | 100.00% | 56.95% | 54.67% | 41 | 11462 - 63.66% | 1,025,687$ | 1,025,687$ | 18006 | 100 | 1,204,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 46,703,384$ | 46,703,384$ |
| 5 | JETS | 3000 | 2500 | 2000 | 2000 | 600 | 100 | 60 | 35 | 25 | 200 | 3000 | 2500 | 1937 | 2000 | 539 | 100.00% | 100.00% | 96.85% | 100.00% | 89.83% | 41 | 9976 - 98.77% | 878,273$ | 878,273$ | 10100 | 100 | 984,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 45,359,707$ | 45,359,707$ |
| 6 | NORDIQUES | 3000 | 2500 | 2000 | 2000 | 534 | 100 | 60 | 35 | 25 | 200 | 6000 | 5000 | 3772 | 4000 | 1068 | 100.00% | 100.00% | 94.30% | 100.00% | 100.00% | 40 | 9920 - 98.86% | 874,653$ | 1,749,306$ | 10034 | 100 | 882,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 46,411,728$ | 46,411,728$ |
| 7 | OILERS | 1500 | 1250 | 1250 | 1000 | 200 | 100 | 60 | 35 | 25 | 200 | 3000 | 2500 | 2500 | 2000 | 400 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 40 | 5200 - 100.00% | 433,875$ | 867,750$ | 5200 | 100 | 782,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 28,308,376$ | 28,308,376$ |
| 8 | SHARKS | 5000 | 4000 | 2000 | 3000 | 546 | 100 | 60 | 35 | 25 | 200 | 3977 | 2816 | 1732 | 2186 | 546 | 79.54% | 70.40% | 86.60% | 72.87% | 100.00% | 41 | 11257 - 77.39% | 1,028,469$ | 1,028,469$ | 14546 | 100 | 664,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 47,099,455$ | 47,099,455$ |
| 9 | TOROS | 2000 | 1000 | 800 | 875 | 225 | 100 | 60 | 35 | 25 | 200 | 4000 | 2000 | 1600 | 1750 | 450 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 40 | 4900 - 100.00% | 461,337$ | 922,674$ | 4900 | 100 | 720,500$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 29,587,749$ | 29,587,749$ |
| 10 | WHALERS | 1900 | 900 | 800 | 850 | 216 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 4666 | 100 | 794,000$ | 0$ | 0$ | 0$ | 0$ | 0$ | 0 | 0 | 0$ | 0$ | 8 | 0$ | 0$ | 0$ | 27,578,435$ | 27,578,435$ |
