| 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 |
| Arena 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 | Arena 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 13,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 | 91811 | 89953 | 36000 | 71934 | 17984 | 85.01% | 99.95% | 100.00% | 99.91% | 99.91% | 24 | 17093 - 94.96% | 1,179,635$ | 21,233,430$ | 18000 | 100 | 25,406,853$ | 1,000,000$ | 0$ | 10,170,486$ | 25,406,853$ | 9,784,776$ | 22 | 0 | 195,144$ | 28,311,240$ | 86 | 188,620$ | 16,221,320$ | 18,484,217$ | 27,936,587$ | 14,936,587$ | 37,000,000$ | 9,063,413$ | 260,999,658$ | 272,735,008$ |
| 2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 100035 | 70470 | 32997 | 54399 | 15474 | 98.07% | 82.91% | 97.05% | 80.00% | 91.02% | 25 | 16081 - 89.34% | 1,213,864$ | 20,635,683$ | 18000 | 100 | 28,598,424$ | 720,000$ | 0$ | 11,318,277$ | 28,598,424$ | 10,889,713$ | 22 | 0 | 217,258$ | 30,346,593$ | 86 | 211,417$ | 18,181,862$ | 19,794,655$ | 30,338,924$ | 17,338,924$ | 37,000,000$ | 6,661,076$ | 262,205,039$ | 274,598,312$ |
| 3 | CALGARY COWBOYS | 7000 | 6000 | 3000 | 4000 | 2000 | 90 | 65 | 33 | 25 | 225 | 110117 | 74560 | 42502 | 67867 | 16348 | 92.54% | 73.10% | 83.34% | 99.80% | 48.08% | 25 | 18317 - 83.26% | 1,266,734$ | 21,534,471$ | 22000 | 100 | 28,279,545$ | 680,000$ | 0$ | 11,485,301$ | 28,279,545$ | 10,921,804$ | 24 | 0 | 217,901$ | 31,668,340$ | 86 | 212,432$ | 18,269,152$ | 20,386,358$ | 30,234,045$ | 17,234,045$ | 37,000,000$ | 6,765,955$ | 254,663,714$ | 269,162,528$ |
| 4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 89891 | 85000 | 34000 | 68000 | 16983 | 88.13% | 100.00% | 100.00% | 100.00% | 99.90% | 25 | 17287 - 96.04% | 1,198,571$ | 20,375,700$ | 18000 | 100 | 26,799,110$ | 640,000$ | 0$ | 11,775,504$ | 26,799,110$ | 10,576,704$ | 23 | 0 | 210,988$ | 29,964,265$ | 86 | 213,622$ | 18,371,492$ | 19,911,576$ | 28,355,485$ | 15,355,485$ | 37,000,000$ | 8,644,515$ | 298,253,935$ | 310,152,908$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 88470 | 84907 | 34000 | 67887 | 16936 | 86.74% | 99.89% | 100.00% | 99.83% | 99.62% | 25 | 17188 - 95.49% | 1,189,164$ | 20,215,795$ | 18000 | 100 | 26,552,238$ | 1,464,000$ | 0$ | 10,537,661$ | 26,552,238$ | 10,229,077$ | 22 | 0 | 204,051$ | 29,729,110$ | 86 | 195,373$ | 16,802,078$ | 19,021,568$ | 28,888,728$ | 15,888,728$ | 37,000,000$ | 8,111,272$ | 291,003,599$ | 303,612,789$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 87286 | 66538 | 31935 | 54422 | 21968 | 73.35% | 65.23% | 62.62% | 64.03% | 64.61% | 25 | 15421 - 67.05% | 1,189,619$ | 20,223,520$ | 23000 | 100 | 29,648,512$ | 800,000$ | 0$ | 11,508,670$ | 29,648,512$ | 10,746,892$ | 24 | 0 | 214,398$ | 29,740,471$ | 86 | 225,882$ | 19,425,852$ | 21,150,757$ | 31,397,012$ | 18,397,012$ | 37,000,000$ | 5,602,988$ | 258,800,550$ | 270,343,978$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 88573 | 84942 | 34000 | 67933 | 16998 | 86.84% | 99.93% | 100.00% | 99.90% | 99.99% | 25 | 17203 - 95.57% | 1,190,691$ | 20,241,745$ | 18000 | 100 | 21,147,922$ | 560,000$ | 0$ | 8,606,792$ | 21,147,922$ | 8,170,156$ | 20 | 0 | 162,854$ | 29,767,272$ | 86 | 159,142$ | 13,686,212$ | 16,287,174$ | 23,697,272$ | 10,697,272$ | 37,000,000$ | 13,302,728$ | 322,007,130$ | 337,273,544$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 89126 | 74163 | 32523 | 55468 | 16395 | 87.38% | 87.25% | 95.66% | 81.57% | 96.44% | 25 | 15746 - 87.48% | 1,199,237$ | 20,387,030$ | 18000 | 100 | 28,910,200$ | 840,000$ | 0$ | 11,675,229$ | 28,910,200$ | 11,173,029$ | 22 | 0 | 222,919$ | 29,980,926$ | 86 | 215,801$ | 18,558,886$ | 20,547,054$ | 30,578,200$ | 17,578,200$ | 37,000,000$ | 6,421,800$ | 255,673,574$ | 266,988,384$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 92986 | 89924 | 36000 | 71959 | 17965 | 86.10% | 99.92% | 100.00% | 99.94% | 99.81% | 24 | 17157 - 95.32% | 1,185,890$ | 21,346,015$ | 18000 | 100 | 27,545,124$ | 760,000$ | 0$ | 11,398,593$ | 27,545,124$ | 10,799,076$ | 20 | 0 | 215,451$ | 28,461,353$ | 86 | 207,853$ | 17,875,358$ | 19,810,109$ | 29,627,009$ | 16,627,009$ | 37,000,000$ | 7,372,991$ | 91,495,087$ | 102,006,785$ |
| 10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 84297 | 84608 | 34000 | 67357 | 16964 | 82.64% | 99.54% | 100.00% | 99.05% | 99.79% | 25 | 16896 - 93.86% | 1,163,112$ | 19,772,905$ | 18000 | 100 | 22,568,022$ | 600,000$ | 0$ | 9,116,647$ | 22,568,022$ | 8,676,154$ | 21 | 0 | 172,975$ | 29,077,801$ | 86 | 169,357$ | 14,564,702$ | 16,315,542$ | 24,340,272$ | 11,340,272$ | 37,000,000$ | 12,659,728$ | 302,090,540$ | 316,780,252$ |
| 11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 85 | 59 | 35 | 23 | 186 | 100662 | 86459 | 37018 | 69381 | 19946 | 95.50% | 97.80% | 98.98% | 97.17% | 97.77% | 25 | 18439 - 97.05% | 1,216,404$ | 20,678,867$ | 19000 | 100 | 27,484,850$ | 1,514,000$ | 0$ | 11,303,845$ | 27,484,850$ | 10,918,127$ | 20 | 1 | 217,818$ | 30,410,099$ | 86 | 203,463$ | 17,497,818$ | 19,571,981$ | 29,740,456$ | 16,740,456$ | 37,000,000$ | 7,259,544$ | 307,260,750$ | 319,647,174$ |
| 12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 87209 | 89601 | 41800 | 72818 | 18085 | 73.28% | 87.84% | 81.96% | 85.67% | 53.19% | 25 | 18207 - 79.16% | 1,235,142$ | 20,997,410$ | 23000 | 100 | 32,894,966$ | 1,260,000$ | 0$ | 12,985,197$ | 32,894,966$ | 12,319,863$ | 24 | 0 | 245,858$ | 30,878,544$ | 86 | 247,285$ | 21,266,510$ | 23,284,799$ | 35,010,916$ | 22,010,916$ | 37,000,000$ | 1,989,084$ | 311,118,077$ | 320,624,447$ |
| 13 | LAS CRUCES SPURS | 7000 | 6000 | 3000 | 4000 | 2000 | 102 | 63 | 35 | 27 | 240 | 82809 | 75138 | 40985 | 59310 | 15058 | 69.59% | 73.66% | 80.36% | 87.22% | 44.29% | 25 | 16076 - 73.07% | 1,166,469$ | 19,829,977$ | 22000 | 100 | 27,459,007$ | 720,000$ | 0$ | 10,434,956$ | 27,459,007$ | 10,242,116$ | 25 | 0 | 204,307$ | 29,161,731$ | 86 | 199,707$ | 17,174,802$ | 19,403,756$ | 29,910,705$ | 16,910,705$ | 37,000,000$ | 7,089,295$ | 297,540,373$ | 310,376,503$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85528 | 84908 | 34000 | 67568 | 16835 | 83.85% | 99.89% | 100.00% | 99.36% | 99.03% | 25 | 16991 - 94.39% | 1,170,205$ | 19,893,480$ | 18000 | 100 | 23,134,637$ | 480,000$ | 0$ | 9,766,101$ | 23,134,637$ | 9,068,720$ | 21 | 0 | 180,833$ | 29,255,118$ | 86 | 178,162$ | 15,321,932$ | 17,742,350$ | 25,580,394$ | 12,580,394$ | 37,000,000$ | 11,419,606$ | 259,652,839$ | 273,022,779$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 102000 | 66672 | 29858 | 55656 | 17000 | 100.00% | 78.44% | 87.82% | 81.85% | 100.00% | 25 | 15952 - 88.62% | 1,141,784$ | 19,410,330$ | 18000 | 100 | 29,358,000$ | 1,700,000$ | 0$ | 11,847,903$ | 29,358,000$ | 11,288,625$ | 23 | 0 | 225,236$ | 28,544,603$ | 86 | 220,057$ | 18,924,902$ | 20,762,192$ | 31,535,500$ | 18,535,500$ | 37,000,000$ | 5,464,500$ | 166,472,306$ | 175,932,725$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 80 | 45 | 27 | 23 | 150 | 109528 | 99059 | 44246 | 71915 | 23337 | 85.90% | 89.65% | 47.32% | 84.61% | 91.52% | 25 | 20476 - 78.75% | 1,110,012$ | 18,870,207$ | 26000 | 100 | 23,429,628$ | 1,892,750$ | 0$ | 9,407,448$ | 23,429,628$ | 9,037,116$ | 20 | 0 | 180,198$ | 27,750,304$ | 86 | 174,212$ | 14,982,232$ | 17,430,951$ | 25,584,378$ | 12,584,378$ | 37,000,000$ | 11,415,622$ | 235,796,289$ | 249,609,266$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 72 | 68 | 50 | 39 | 145 | 108000 | 74823 | 27770 | 45024 | 18000 | 100.00% | 83.14% | 77.14% | 62.53% | 100.00% | 24 | 15201 - 84.45% | 1,034,356$ | 18,618,400$ | 18000 | 100 | 27,402,495$ | 680,000$ | 0$ | 11,489,187$ | 27,402,495$ | 10,801,065$ | 22 | 0 | 215,487$ | 24,824,533$ | 86 | 208,475$ | 17,928,850$ | 19,932,397$ | 29,594,920$ | 16,594,920$ | 37,000,000$ | 7,405,080$ | 246,624,265$ | 252,607,563$ |
| 18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 59 | 38 | 29 | 193 | 101927 | 85000 | 33235 | 56582 | 16996 | 99.93% | 100.00% | 97.75% | 83.21% | 99.98% | 25 | 17279 - 95.99% | 1,198,380$ | 20,372,466$ | 18000 | 100 | 20,583,200$ | 2,190,000$ | 0$ | 8,004,140$ | 20,583,200$ | 7,330,687$ | 23 | 0 | 146,071$ | 29,959,509$ | 86 | 159,494$ | 13,716,484$ | 15,340,834$ | 22,498,481$ | 9,498,481$ | 37,000,000$ | 14,501,519$ | 224,677,672$ | 241,207,644$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 84406 | 68716 | 32401 | 52498 | 22045 | 70.93% | 67.37% | 63.53% | 61.76% | 64.84% | 25 | 15298 - 66.51% | 1,180,366$ | 20,066,225$ | 23000 | 100 | 23,782,826$ | 1,167,000$ | 0$ | 8,897,042$ | 23,782,826$ | 8,511,330$ | 22 | 0 | 169,691$ | 29,509,154$ | 86 | 177,020$ | 15,223,720$ | 17,497,810$ | 25,646,426$ | 12,646,426$ | 37,000,000$ | 11,353,574$ | 214,212,160$ | 229,157,978$ |
| 20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 83706 | 89836 | 41922 | 72433 | 18074 | 70.34% | 88.07% | 82.20% | 85.22% | 53.16% | 25 | 17998 - 78.25% | 1,214,921$ | 20,653,655$ | 23000 | 100 | 28,644,148$ | 1,180,000$ | 0$ | 11,895,271$ | 28,644,148$ | 11,063,280$ | 23 | 0 | 220,726$ | 30,373,022$ | 86 | 220,008$ | 18,920,688$ | 20,900,211$ | 31,014,366$ | 18,014,366$ | 37,000,000$ | 5,985,634$ | 311,307,798$ | 322,677,398$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 25 | 169 | 101966 | 74409 | 29215 | 68000 | 17000 | 99.97% | 87.54% | 85.93% | 100.00% | 100.00% | 25 | 17094 - 94.96% | 1,080,689$ | 18,371,710$ | 18000 | 100 | 23,037,141$ | 1,610,000$ | 0$ | 10,282,517$ | 23,037,141$ | 9,819,674$ | 20 | 0 | 195,854$ | 27,017,221$ | 86 | 173,122$ | 14,888,492$ | 16,712,860$ | 25,074,038$ | 12,074,038$ | 37,000,000$ | 11,925,962$ | 222,007,113$ | 234,160,187$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 85933 | 84535 | 34000 | 67713 | 16971 | 84.25% | 99.45% | 100.00% | 99.58% | 99.83% | 25 | 17009 - 94.49% | 1,173,084$ | 19,942,425$ | 18000 | 100 | 25,744,907$ | 880,000$ | 0$ | 10,382,661$ | 25,744,907$ | 9,698,697$ | 23 | 0 | 193,435$ | 29,327,096$ | 86 | 196,558$ | 16,903,988$ | 18,249,878$ | 27,419,407$ | 14,419,407$ | 37,000,000$ | 9,580,593$ | 88,462,326$ | 101,444,922$ |