| 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 | 77792 | 63828 | 31200 | 50850 | 12164 | 99.73% | 98.20% | 100.00% | 97.79% | 93.57% | 16 | 9071 - 98.59% | 820,246$ | 21,326,408$ | 9200 | 100 | 871,000$ | 0$ | 0$ | 513,624$ | 0$ | 513,624$ | 0 | 0 | 0$ | 13,123,943$ | 71 | 4,977$ | 353,367$ | 353,367$ | 30,812,784$ | 43,583,360$ |
| 2 | CRUSADERS | 3000 | 2500 | 2000 | 1900 | 500 | 100 | 60 | 35 | 25 | 200 | 74952 | 61108 | 42198 | 47417 | 11639 | 99.94% | 97.77% | 84.40% | 99.83% | 93.11% | 17 | 9493 - 95.88% | 839,895$ | 20,997,386$ | 9900 | 100 | 861,500$ | 0$ | 0$ | 501,402$ | 0$ | 501,402$ | 0 | 0 | 0$ | 14,278,222$ | 71 | 4,923$ | 349,533$ | 349,533$ | 30,495,984$ | 44,424,673$ |
| 3 | FIGHTING SAINTS | 5000 | 4000 | 3000 | 3500 | 500 | 100 | 60 | 35 | 25 | 200 | 80875 | 63400 | 40827 | 51078 | 11771 | 64.70% | 63.40% | 54.44% | 58.37% | 94.17% | 17 | 9918 - 61.99% | 881,483$ | 22,037,072$ | 16000 | 100 | 730,000$ | 0$ | 0$ | 413,267$ | 0$ | 413,267$ | 0 | 0 | 0$ | 14,985,209$ | 71 | 4,171$ | 296,141$ | 296,141$ | 31,623,805$ | 46,312,873$ |
| 4 | GOLDEN BLADES | 6000 | 5000 | 2000 | 4000 | 1006 | 100 | 60 | 35 | 25 | 200 | 80740 | 63412 | 41164 | 51739 | 11670 | 53.83% | 50.73% | 82.33% | 51.74% | 46.40% | 17 | 9949 - 55.25% | 881,241$ | 22,031,014$ | 18006 | 100 | 1,229,000$ | 0$ | 0$ | 659,535$ | 0$ | 659,535$ | 0 | 0 | 0$ | 14,981,090$ | 71 | 7,023$ | 498,633$ | 498,633$ | 31,371,479$ | 45,853,936$ |
| 5 | JETS | 3000 | 2500 | 2000 | 2000 | 600 | 100 | 60 | 35 | 25 | 200 | 74855 | 61583 | 41353 | 49094 | 11949 | 99.81% | 98.53% | 82.71% | 98.19% | 79.66% | 17 | 9553 - 94.59% | 844,739$ | 21,118,480$ | 10100 | 100 | 984,000$ | 0$ | 0$ | 582,468$ | 0$ | 582,468$ | 0 | 0 | 0$ | 14,360,566$ | 71 | 5,623$ | 399,233$ | 399,233$ | 30,536,012$ | 44,497,345$ |
| 6 | NORDIQUES | 3000 | 2500 | 2000 | 2000 | 534 | 100 | 60 | 35 | 25 | 200 | 77943 | 63311 | 42726 | 51154 | 12309 | 99.93% | 97.40% | 82.17% | 98.37% | 88.66% | 16 | 9517 - 94.85% | 841,451$ | 21,877,725$ | 10034 | 100 | 705,000$ | 0$ | 0$ | 427,638$ | 0$ | 427,638$ | 0 | 0 | 0$ | 13,463,215$ | 71 | 4,029$ | 286,059$ | 286,059$ | 31,450,087$ | 44,627,243$ |
| 7 | OILERS | 1500 | 1250 | 1250 | 1000 | 200 | 100 | 60 | 35 | 25 | 200 | 37500 | 31250 | 31250 | 25000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 17 | 5200 - 100.00% | 433,875$ | 10,846,875$ | 5200 | 100 | 782,000$ | 0$ | 0$ | 463,346$ | 0$ | 463,346$ | 0 | 0 | 0$ | 7,375,875$ | 71 | 4,469$ | 317,299$ | 317,299$ | 20,383,529$ | 27,442,105$ |
| 8 | SHARKS | 5000 | 4000 | 2000 | 3000 | 546 | 100 | 60 | 35 | 25 | 200 | 80648 | 62336 | 40757 | 51053 | 11695 | 64.52% | 62.34% | 81.51% | 68.07% | 85.68% | 17 | 9860 - 67.78% | 876,033$ | 21,900,813$ | 14546 | 100 | 664,000$ | 0$ | 0$ | 347,617$ | 0$ | 347,617$ | 0 | 0 | 0$ | 14,892,553$ | 71 | 3,794$ | 269,374$ | 269,374$ | 31,553,196$ | 46,176,375$ |
| 9 | TOROS | 2000 | 1000 | 800 | 875 | 225 | 100 | 60 | 35 | 25 | 200 | 50000 | 25000 | 20000 | 21875 | 5625 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 17 | 4900 - 100.00% | 461,337$ | 11,533,425$ | 4900 | 100 | 745,500$ | 0$ | 0$ | 416,198$ | 0$ | 416,198$ | 0 | 0 | 0$ | 7,842,729$ | 71 | 4,260$ | 302,460$ | 302,460$ | 21,117,227$ | 28,657,496$ |
| 10 | WHALERS | 1900 | 900 | 800 | 850 | 216 | 100 | 60 | 35 | 25 | 200 | 49400 | 23400 | 20800 | 22100 | 5616 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 16 | 4666 - 100.00% | 437,385$ | 11,372,010$ | 4666 | 100 | 794,000$ | 0$ | 0$ | 469,608$ | 0$ | 469,608$ | 0 | 0 | 0$ | 6,998,160$ | 71 | 4,537$ | 322,127$ | 322,127$ | 20,902,402$ | 27,578,435$ |
