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 Average Salaries | 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 | Estimated Season Salary Cap | Over Minimum Salary Cap of 15,000,000$ | Maximum Salary Cap | Available Salary Cap | Current Bank Account | Projected Bank Account |
1 | BANGOR BEAGLES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 42000 | 35000 | 14000 | 28000 | 7000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 35 | 18000 - 100.00% | 1,270,000$ | 8,890,000$ | 18000 | 100 | 37,287,096$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 682,324$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 386,370,644$ | 386,370,644$ |
2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 24000 | 20000 | 8000 | 16000 | 4000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 38 | 18000 - 100.00% | 1,270,000$ | 5,080,000$ | 18000 | 100 | 37,109,946$ | 880,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 1 | 636,297$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 362,464,159$ | 362,464,159$ |
3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 22209 | 18155 | 8888 | 13500 | 3658 | 98.71% | 93.10% | 84.65% | 100.00% | 48.77% | 39 | 22137 - 90.35% | 1,544,246$ | 4,632,739$ | 24500 | 100 | 35,371,003$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 651,299$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 349,345,411$ | 349,345,411$ |
4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 36000 | 30000 | 12000 | 24000 | 6000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 36 | 18000 - 100.00% | 1,270,000$ | 7,620,000$ | 18000 | 100 | 38,171,758$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 663,572$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 413,746,129$ | 413,746,129$ |
5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,270,000$ | 3,810,000$ | 18000 | 100 | 40,638,343$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 752,426$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 405,949,196$ | 405,949,196$ |
6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 33,429,093$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 651,293$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 412,854,743$ | 412,854,743$ |
7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 50 | 30 | 250 | 12000 | 9844 | 4000 | 8000 | 2000 | 100.00% | 98.44% | 100.00% | 100.00% | 100.00% | 40 | 17922 - 99.57% | 1,414,540$ | 2,829,080$ | 18000 | 100 | 24,666,594$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 453,678$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 468,199,792$ | 468,199,792$ |
8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 26,365,000$ | 880,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 489,233$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 368,794,761$ | 368,794,761$ |
9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 33698 | 29573 | 12000 | 24000 | 6000 | 93.61% | 98.58% | 100.00% | 100.00% | 100.00% | 36 | 17545 - 97.47% | 1,521,704$ | 9,130,225$ | 18000 | 100 | 31,198,249$ | 800,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 603,684$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 214,367,702$ | 214,367,702$ |
10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 30000 | 25000 | 10000 | 20000 | 5000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 37 | 18000 - 100.00% | 1,270,000$ | 6,350,000$ | 18000 | 100 | 28,979,124$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 593,188$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 434,162,635$ | 434,162,635$ |
11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 165 | 110 | 77 | 60 | 399 | 33423 | 27316 | 10600 | 21704 | 5921 | 89.85% | 87.55% | 80.30% | 86.13% | 82.24% | 36 | 16494 - 86.81% | 1,748,000$ | 10,487,999$ | 19000 | 100 | 35,458,823$ | 1,294,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 648,488$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 489,852,155$ | 489,852,155$ |
12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 35,179,482$ | 800,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 715,612$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 419,731,186$ | 419,731,186$ |
13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 36672 | 31752 | 15175 | 22500 | 6521 | 97.79% | 97.70% | 86.71% | 100.00% | 52.17% | 37 | 22524 - 91.93% | 1,688,917$ | 8,444,585$ | 24500 | 100 | 35,578,713$ | 720,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 644,812$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 407,948,559$ | 407,948,559$ |
14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 31,969,603$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 21 | 0 | 567,501$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 350,558,147$ | 350,558,147$ |
15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,250,000$ | 3,750,000$ | 18000 | 100 | 43,531,243$ | 1,890,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 773,947$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 267,359,626$ | 267,359,626$ |
16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 22325 | 19148 | 9368 | 14831 | 4500 | 99.22% | 98.19% | 56.78% | 98.87% | 100.00% | 39 | 23391 - 89.96% | 1,659,229$ | 4,977,688$ | 26000 | 100 | 27,290,263$ | 1,210,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 504,809$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 412,291,927$ | 412,291,927$ |
17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 70 | 150 | 17822 | 11973 | 4385 | 6847 | 3000 | 99.01% | 79.82% | 73.08% | 57.06% | 100.00% | 39 | 14676 - 81.53% | 1,436,920$ | 4,310,760$ | 18000 | 100 | 28,416,363$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 569,214$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 356,660,726$ | 356,660,726$ |
18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 149 | 99 | 80 | 62 | 385 | 26785 | 23813 | 9769 | 19922 | 4960 | 89.28% | 95.25% | 97.69% | 99.61% | 99.20% | 37 | 17050 - 94.72% | 1,689,091$ | 8,445,454$ | 18000 | 100 | 34,613,192$ | 680,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 648,189$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 362,031,968$ | 362,031,968$ |
19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 20530 | 15114 | 8532 | 14171 | 4541 | 97.76% | 83.97% | 94.80% | 94.47% | 75.68% | 39 | 20963 - 91.14% | 1,557,355$ | 4,672,065$ | 23000 | 100 | 35,898,891$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 725,078$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 346,676,803$ | 346,676,803$ |
20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 23000 | 100 | 33,103,240$ | 1,040,000$ | 0$ | 0$ | 0$ | 0$ | 27 | 0 | 633,549$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 443,695,028$ | 443,695,028$ |
21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 75 | 150 | 0 | 0 | 0 | 0 | 0 | 0% | 0% | 0% | 0% | 0% | 42 | 0 - 0% | 0$ | 0$ | 18000 | 100 | 27,488,219$ | 960,000$ | 0$ | 0$ | 0$ | 0$ | 25 | 0 | 568,854$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 345,204,461$ | 345,204,461$ |
22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 18000 | 15000 | 6000 | 12000 | 3000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 18000 - 100.00% | 1,270,000$ | 3,810,000$ | 18000 | 100 | 32,579,959$ | 920,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 618,131$ | 0$ | 4 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 200,173,246$ | 200,173,246$ |