| 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 Average Salaries | 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 |  Admirals (HAR) | 3000 | 2000 | 5 | 2 | 54020 | 36488 | 94.77% | 96.02% | 18 | 4764 - 95.27% | 15,348$ | 291,615$ | 5000 | 100 | 95,900$ | 95,900$ | 71,172$ | 0$ | 50,436$ | 0 | 0 | 276,267$ | 62 | 978$ | 65,526$ |
| 2 |  Americans (BUF) | 2000 | 1000 | 3 | 1 | 37886 | 19000 | 99.70% | 100.00% | 18 | 2994 - 99.80% | 5,935$ | 112,759$ | 3000 | 100 | 82,900$ | 82,900$ | 64,032$ | 0$ | 43,308$ | 0 | 0 | 106,824$ | 62 | 884$ | 59,228$ |
| 3 |  Blades (WIN) | 3000 | 2000 | 5 | 2 | 58862 | 38901 | 98.10% | 97.25% | 17 | 4888 - 97.76% | 15,815$ | 316,296$ | 5000 | 100 | 165,400$ | 165,400$ | 110,573$ | 0$ | 89,845$ | 0 | 0 | 268,852$ | 62 | 1,478$ | 99,026$ |
| 4 |  Brass (BOS) | 2000 | 1000 | 2 | 1 | 40000 | 20000 | 100.00% | 100.00% | 17 | 3000 - 100.00% | 4,250$ | 85,000$ | 3000 | 100 | 136,600$ | 136,600$ | 91,428$ | 0$ | 70,692$ | 0 | 0 | 72,250$ | 62 | 1,271$ | 85,157$ |
| 5 |  Bulls (STL) | 3000 | 2000 | 5 | 2 | 54710 | 36550 | 95.98% | 96.18% | 18 | 4803 - 96.06% | 15,508$ | 294,654$ | 5000 | 100 | 123,800$ | 123,800$ | 85,014$ | 0$ | 64,344$ | 0 | 0 | 279,146$ | 62 | 1,178$ | 78,926$ |
| 6 |  Canadiens (MTL) | 2000 | 1000 | 3 | 1 | 37939 | 19000 | 99.84% | 100.00% | 18 | 2997 - 99.89% | 5,942$ | 112,894$ | 3000 | 100 | 76,600$ | 76,600$ | 66,579$ | 0$ | 45,863$ | 0 | 0 | 106,952$ | 62 | 839$ | 56,213$ |
| 7 |  Cougars (CGS) | 2000 | 1000 | 3 | 1 | 38000 | 19000 | 100.00% | 100.00% | 18 | 3000 - 100.00% | 5,950$ | 113,050$ | 3000 | 100 | 129,200$ | 129,200$ | 86,178$ | 0$ | 65,442$ | 0 | 0 | 107,100$ | 62 | 1,217$ | 81,539$ |
| 8 |  Cougars (NYI) | 3000 | 2000 | 5 | 2 | 58193 | 39096 | 96.99% | 97.74% | 17 | 4864 - 97.29% | 15,689$ | 313,784$ | 5000 | 100 | 170,500$ | 170,500$ | 105,113$ | 0$ | 84,395$ | 0 | 0 | 266,716$ | 62 | 1,514$ | 101,438$ |
| 9 |  Devils (KCS) | 3000 | 2000 | 5 | 2 | 55843 | 36914 | 97.97% | 97.14% | 18 | 4882 - 97.64% | 15,794$ | 300,087$ | 5000 | 100 | 78,700$ | 78,700$ | 63,852$ | 0$ | 43,122$ | 0 | 0 | 284,293$ | 62 | 854$ | 57,218$ |
| 10 |  Eagles (COL) | 3000 | 2000 | 5 | 2 | 59007 | 39344 | 98.35% | 98.36% | 17 | 4918 - 98.35% | 15,883$ | 317,662$ | 5000 | 100 | 155,400$ | 155,400$ | 102,456$ | 0$ | 81,735$ | 0 | 0 | 270,013$ | 62 | 1,406$ | 94,202$ |
| 11 |  Flames (CGY) | 3000 | 2000 | 5 | 2 | 57479 | 39269 | 95.80% | 98.17% | 17 | 4837 - 96.75% | 15,552$ | 311,044$ | 5000 | 100 | 160,600$ | 160,600$ | 106,569$ | 0$ | 85,881$ | 0 | 0 | 264,387$ | 62 | 1,443$ | 96,681$ |
| 12 |  Grizzlies (PIT) | 3000 | 2000 | 5 | 2 | 58537 | 39061 | 97.56% | 97.65% | 17 | 4880 - 97.60% | 15,759$ | 315,184$ | 5000 | 100 | 53,250$ | 53,050$ | 53,729$ | 0$ | 33,023$ | 0 | 0 | 267,906$ | 62 | 671$ | 44,957$ |
| 13 |  Growlers (MIN) | 2000 | 1000 | 4 | 2 | 39257 | 19009 | 98.14% | 95.05% | 17 | 2913 - 97.11% | 8,289$ | 165,789$ | 3000 | 100 | 76,750$ | 76,750$ | 62,748$ | 0$ | 42,012$ | 0 | 0 | 140,921$ | 62 | 840$ | 56,280$ |
| 14 |  Gulls (EDM) | 3000 | 2000 | 5 | 2 | 55773 | 37416 | 97.85% | 98.46% | 18 | 4905 - 98.09% | 15,823$ | 300,642$ | 5000 | 100 | 146,600$ | 146,600$ | 97,350$ | 0$ | 76,683$ | 0 | 0 | 284,819$ | 62 | 1,342$ | 89,914$ |
| 15 |  Hurricanes (DET) | 2000 | 1000 | 5 | 3 | 38945 | 11756 | 97.36% | 58.78% | 17 | 2535 - 84.50% | 9,775$ | 195,495$ | 3000 | 100 | 99,250$ | 99,250$ | 66,965$ | 0$ | 46,278$ | 0 | 0 | 166,171$ | 62 | 1,002$ | 67,134$ |
| 16 |  Marlboros (TOR) | 2000 | 1000 | 5 | 1 | 39230 | 20000 | 98.08% | 100.00% | 17 | 2962 - 98.72% | 9,187$ | 183,730$ | 3000 | 100 | 143,600$ | 143,600$ | 95,058$ | 0$ | 74,322$ | 0 | 0 | 156,170$ | 62 | 1,321$ | 88,507$ |
| 17 |  Mooseheads (PHI) | 2000 | 1000 | 5 | 2 | 37031 | 18525 | 97.45% | 97.50% | 18 | 2924 - 97.47% | 9,941$ | 188,874$ | 3000 | 100 | 134,550$ | 134,550$ | 90,933$ | 0$ | 70,197$ | 0 | 0 | 178,933$ | 62 | 1,256$ | 84,152$ |
| 18 |  Remparts (QUE) | 3000 | 2000 | 5 | 2 | 58836 | 39179 | 98.06% | 97.95% | 17 | 4901 - 98.02% | 15,833$ | 316,658$ | 5000 | 100 | 133,200$ | 133,200$ | 88,836$ | 0$ | 68,109$ | 0 | 0 | 269,159$ | 62 | 1,246$ | 83,482$ |
| 19 |  Rush (LAK) | 3000 | 2000 | 5 | 2 | 55434 | 36802 | 97.25% | 96.85% | 18 | 4855 - 97.09% | 15,692$ | 298,155$ | 5000 | 100 | 101,350$ | 101,350$ | 70,544$ | 0$ | 49,835$ | 0 | 0 | 282,463$ | 62 | 1,017$ | 68,139$ |
| 20 |  Stingers (CLE) | 2000 | 1000 | 5 | 2 | 37004 | 18190 | 97.38% | 95.74% | 18 | 2905 - 96.83% | 9,905$ | 188,190$ | 3000 | 100 | 61,150$ | 61,150$ | 53,724$ | 0$ | 32,988$ | 0 | 0 | 178,285$ | 62 | 728$ | 48,776$ |
| 21 |  Thunder (NYR) | 2000 | 1000 | 5 | 2 | 38796 | 19537 | 96.99% | 97.69% | 17 | 2917 - 97.22% | 9,905$ | 198,094$ | 3000 | 100 | 157,740$ | 157,740$ | 103,743$ | 0$ | 83,007$ | 0 | 0 | 168,380$ | 62 | 1,423$ | 95,341$ |
| 22 |  Thunderbirds (VAN) | 2000 | 1000 | 8 | 5 | 21991 | 7593 | 54.98% | 37.97% | 17 | 1479 - 49.31% | 9,090$ | 181,809$ | 3000 | 100 | 177,550$ | 177,550$ | 107,144$ | 0$ | 86,423$ | 0 | 0 | 154,538$ | 62 | 1,565$ | 104,855$ |
| 23 |  Tigers (CHI) | 2000 | 1000 | 4 | 2 | 39573 | 19304 | 98.93% | 96.52% | 17 | 2944 - 98.13% | 8,368$ | 167,366$ | 3000 | 100 | 118,650$ | 118,650$ | 83,130$ | 0$ | 62,437$ | 0 | 0 | 142,261$ | 62 | 1,141$ | 76,447$ |
| 24 |  Wolves (WAS) | 2000 | 1000 | 15 | 5 | 11788 | 7302 | 31.02% | 38.43% | 18 | 1005 - 33.49% | 9,544$ | 181,330$ | 3000 | 100 | 151,650$ | 151,650$ | 97,857$ | 0$ | 77,126$ | 0 | 0 | 171,786$ | 62 | 1,379$ | 92,393$ |
