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 | 84000 | 70000 | 28000 | 56000 | 14000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 28 | 18000 - 100.00% | 1,270,000$ | 17,780,000$ | 18000 | 100 | 37,287,096$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 682,324$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 395,260,644$ | 395,260,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$ | 0 | 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$ | 0 | 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$ | 0 | 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$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 406,204,196$ | 406,204,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 | 29,015,593$ | 760,000$ | 0$ | 0$ | 0$ | 0$ | 20 | 0 | 651,293$ | 0$ | 0 | 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$ | 0 | 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$ | 0 | 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$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 214,452,702$ | 214,452,702$ |
10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 54000 | 45000 | 18000 | 36000 | 9000 | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 33 | 18000 - 100.00% | 1,270,000$ | 11,430,000$ | 18000 | 100 | 31,669,124$ | 720,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 593,188$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 439,327,635$ | 439,327,635$ |
11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 229 | 159 | 119 | 89 | 469 | 73001 | 61237 | 24894 | 47233 | 13696 | 90.57% | 90.59% | 87.04% | 86.51% | 87.79% | 29 | 16928 - 89.09% | 2,158,478$ | 28,060,209$ | 19000 | 100 | 35,458,823$ | 1,294,000$ | 0$ | 0$ | 0$ | 0$ | 24 | 0 | 648,488$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 508,492,068$ | 508,492,068$ |
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$ | 0 | 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 | 66672 | 57752 | 28903 | 40500 | 12444 | 98.77% | 98.72% | 91.76% | 100.00% | 55.31% | 33 | 22919 - 93.55% | 1,725,621$ | 15,530,585$ | 24500 | 100 | 35,578,713$ | 720,000$ | 0$ | 0$ | 0$ | 0$ | 23 | 0 | 644,812$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 415,034,559$ | 415,034,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$ | 0 | 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,581,243$ | 1,890,000$ | 0$ | 0$ | 0$ | 0$ | 26 | 0 | 773,947$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 267,879,626$ | 267,879,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$ | 0 | 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$ | 0 | 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 | 99 | 59 | 35 | 25 | 225 | 32558 | 28597 | 11563 | 22961 | 5960 | 90.44% | 95.32% | 96.36% | 95.67% | 99.33% | 36 | 16940 - 94.11% | 1,749,364$ | 10,496,185$ | 18000 | 100 | 33,813,192$ | 640,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 648,189$ | 0$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 364,671,562$ | 364,671,562$ |
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 | 32,438,378$ | 800,000$ | 0$ | 0$ | 0$ | 0$ | 22 | 0 | 725,078$ | 0$ | 0 | 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$ | 0 | 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$ | 0 | 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$ | 0 | 0$ | 0$ | 0$ | 0$ | -15,000,000$ | 45,000,000$ | 45,000,000$ | 200,173,246$ | 200,173,246$ |