| 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 | 131764 | 129953 | 52000 | 103910 | 25969 | 84.46% | 99.96% | 100.00% | 99.91% | 99.88% | 16 | 17061 - 94.79% | 1,176,351$ | 30,585,130$ | 18000 | 100 | 26,259,666$ | 1,000,000$ | 0$ | 15,859,546$ | 26,259,666$ | 15,259,571$ | 23 | 0 | 304,349$ | 18,821,618$ | 56 | 194,712$ | 10,903,872$ | 12,457,603$ | 28,876,900$ | 15,876,900$ | 37,000,000$ | 8,123,100$ | 264,481,948$ | 272,105,486$ |
| 2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 145782 | 115454 | 50997 | 90255 | 24474 | 93.45% | 88.81% | 98.07% | 86.78% | 94.13% | 16 | 16422 - 91.23% | 1,201,378$ | 31,235,823$ | 18000 | 100 | 28,598,424$ | 720,000$ | 0$ | 17,660,787$ | 28,598,424$ | 17,017,933$ | 22 | 0 | 339,508$ | 19,222,045$ | 56 | 211,417$ | 11,839,352$ | 12,920,455$ | 30,338,924$ | 17,338,924$ | 37,000,000$ | 6,661,076$ | 266,464,924$ | 273,983,254$ |
| 3 | CALGARY COWBOYS | 7000 | 6000 | 3000 | 4000 | 2000 | 90 | 65 | 33 | 25 | 225 | 174825 | 118470 | 67425 | 107867 | 26216 | 92.50% | 73.13% | 83.24% | 99.88% | 48.55% | 15 | 18326 - 83.30% | 1,268,707$ | 34,255,100$ | 22000 | 100 | 26,579,544$ | 600,000$ | 0$ | 17,535,767$ | 26,579,544$ | 16,659,213$ | 22 | 0 | 332,350$ | 19,030,611$ | 56 | 200,290$ | 11,216,240$ | 12,648,032$ | 28,564,044$ | 15,564,044$ | 37,000,000$ | 8,435,956$ | 261,632,851$ | 270,121,345$ |
| 4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 141041 | 135000 | 54000 | 108000 | 26941 | 87.06% | 100.00% | 100.00% | 100.00% | 99.78% | 15 | 17222 - 95.68% | 1,191,937$ | 32,182,300$ | 18000 | 100 | 25,569,110$ | 600,000$ | 0$ | 17,991,586$ | 25,569,110$ | 16,126,786$ | 22 | 0 | 321,694$ | 17,879,056$ | 56 | 204,836$ | 11,470,816$ | 12,713,081$ | 27,255,985$ | 14,255,985$ | 37,000,000$ | 9,744,015$ | 303,819,656$ | 310,197,813$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 140528 | 134907 | 54000 | 107887 | 26933 | 86.75% | 99.93% | 100.00% | 99.90% | 99.75% | 15 | 17195 - 95.53% | 1,189,666$ | 32,120,995$ | 18000 | 100 | 26,552,238$ | 1,464,000$ | 0$ | 16,398,851$ | 26,552,238$ | 15,918,847$ | 22 | 0 | 317,541$ | 17,844,997$ | 56 | 195,373$ | 10,940,888$ | 12,431,789$ | 28,896,228$ | 15,896,228$ | 37,000,000$ | 8,103,772$ | 296,865,660$ | 303,526,355$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 135583 | 105429 | 50388 | 85896 | 34855 | 71.74% | 65.08% | 62.21% | 63.63% | 64.55% | 15 | 15265 - 66.37% | 1,174,561$ | 31,713,155$ | 23000 | 100 | 22,230,324$ | 800,000$ | 0$ | 17,177,484$ | 22,230,324$ | 15,992,496$ | 23 | 0 | 319,010$ | 17,618,419$ | 56 | 172,895$ | 9,682,120$ | 10,900,412$ | 24,126,324$ | 11,126,324$ | 37,000,000$ | 12,873,676$ | 265,085,904$ | 273,654,723$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 92 | 65 | 40 | 25 | 225 | 136361 | 128238 | 51522 | 102000 | 25885 | 87.41% | 98.64% | 99.08% | 98.08% | 99.56% | 16 | 17077 - 94.87% | 1,190,659$ | 30,957,125$ | 18000 | 100 | 26,663,538$ | 1,500,000$ | 207,912$ | 13,921,973$ | 26,663,538$ | 13,242,763$ | 21 | 0 | 264,004$ | 19,050,538$ | 56 | 198,540$ | 11,118,240$ | 12,980,082$ | 29,702,150$ | 16,702,150$ | 37,000,000$ | 7,297,850$ | 325,918,493$ | 333,154,145$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 135976 | 114887 | 50131 | 84516 | 25298 | 87.16% | 88.37% | 96.41% | 81.27% | 97.30% | 16 | 15800 - 87.78% | 1,203,770$ | 31,298,025$ | 18000 | 100 | 29,010,200$ | 840,000$ | 0$ | 18,167,851$ | 29,010,200$ | 17,386,651$ | 22 | 0 | 346,883$ | 19,260,323$ | 56 | 216,516$ | 12,124,896$ | 13,457,624$ | 30,678,200$ | 17,678,200$ | 37,000,000$ | 6,321,800$ | 259,974,823$ | 267,014,972$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 139947 | 134924 | 54000 | 107959 | 26951 | 86.39% | 99.94% | 100.00% | 99.96% | 99.82% | 15 | 17177 - 95.43% | 1,187,752$ | 32,069,315$ | 18000 | 100 | 27,570,124$ | 760,000$ | 0$ | 17,636,689$ | 27,570,124$ | 16,704,098$ | 20 | 0 | 333,257$ | 17,816,286$ | 56 | 208,032$ | 11,649,792$ | 12,947,811$ | 29,654,509$ | 16,654,509$ | 37,000,000$ | 7,345,491$ | 95,896,448$ | 102,000,442$ |
| 10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 135497 | 134434 | 54000 | 107286 | 26928 | 83.64% | 99.58% | 100.00% | 99.34% | 99.73% | 15 | 16968 - 94.27% | 1,169,389$ | 31,573,490$ | 18000 | 100 | 23,133,022$ | 600,000$ | 0$ | 14,279,607$ | 23,133,022$ | 13,594,404$ | 22 | 0 | 271,040$ | 17,540,828$ | 56 | 173,393$ | 9,710,008$ | 10,861,932$ | 24,853,772$ | 11,853,772$ | 37,000,000$ | 12,146,228$ | 308,710,754$ | 316,638,310$ |
| 11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 88 | 62 | 37 | 20 | 193 | 156040 | 132334 | 56818 | 106641 | 30736 | 96.80% | 97.88% | 99.33% | 97.66% | 98.51% | 16 | 18560 - 97.69% | 1,219,849$ | 31,716,074$ | 19000 | 100 | 26,559,225$ | 1,474,000$ | 0$ | 17,281,453$ | 26,559,225$ | 16,681,445$ | 21 | 0 | 332,783$ | 19,517,584$ | 56 | 196,852$ | 11,023,712$ | 12,432,995$ | 28,859,831$ | 15,859,831$ | 37,000,000$ | 8,140,169$ | 312,032,152$ | 320,118,269$ |
| 12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 138469 | 144156 | 66263 | 114789 | 28604 | 73.26% | 88.99% | 81.81% | 85.03% | 52.97% | 15 | 18233 - 79.27% | 1,237,259$ | 33,405,990$ | 23000 | 100 | 32,944,966$ | 1,260,000$ | 0$ | 20,412,339$ | 32,944,966$ | 19,377,351$ | 22 | 2 | 386,696$ | 18,558,883$ | 56 | 247,643$ | 13,868,008$ | 15,220,927$ | 35,060,916$ | 22,060,916$ | 37,000,000$ | 1,939,084$ | 315,954,462$ | 320,542,363$ |
| 13 | LAS CRUCES SPURS | 7000 | 6000 | 3000 | 4000 | 2000 | 102 | 63 | 35 | 27 | 240 | 129921 | 118336 | 65233 | 93126 | 23912 | 68.74% | 73.05% | 80.53% | 86.23% | 44.28% | 15 | 15945 - 72.48% | 1,157,168$ | 31,243,547$ | 22000 | 100 | 27,927,371$ | 720,000$ | 0$ | 16,669,857$ | 27,927,371$ | 16,369,880$ | 25 | 0 | 326,555$ | 17,357,526$ | 56 | 203,053$ | 11,370,968$ | 12,790,499$ | 30,201,680$ | 17,201,680$ | 37,000,000$ | 6,798,320$ | 302,952,297$ | 309,515,694$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 133258 | 134448 | 54000 | 107250 | 26643 | 82.26% | 99.59% | 100.00% | 99.31% | 98.68% | 15 | 16874 - 93.74% | 1,158,983$ | 31,292,530$ | 18000 | 100 | 23,134,637$ | 480,000$ | 0$ | 15,110,961$ | 23,134,637$ | 14,026,130$ | 21 | 0 | 279,683$ | 17,384,739$ | 56 | 178,162$ | 9,977,072$ | 11,600,648$ | 25,582,894$ | 12,582,894$ | 37,000,000$ | 11,417,106$ | 265,451,692$ | 272,449,297$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 155980 | 104202 | 46187 | 84610 | 26000 | 99.99% | 80.16% | 88.82% | 81.36% | 100.00% | 16 | 16038 - 89.10% | 1,148,041$ | 29,849,055$ | 18000 | 100 | 31,308,000$ | 880,000$ | 0$ | 18,657,480$ | 31,308,000$ | 17,787,492$ | 24 | 0 | 354,923$ | 18,368,649$ | 56 | 233,986$ | 13,103,216$ | 14,546,171$ | 33,988,000$ | 20,988,000$ | 37,000,000$ | 3,012,000$ | 169,866,240$ | 174,786,350$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 80 | 50 | 24 | 23 | 175 | 169720 | 148745 | 68501 | 112087 | 35436 | 87.04% | 88.01% | 47.90% | 86.22% | 90.86% | 16 | 20557 - 79.07% | 1,133,910$ | 29,481,657$ | 26000 | 100 | 23,224,953$ | 2,499,750$ | 0$ | 14,672,758$ | 23,224,953$ | 14,096,706$ | 20 | 0 | 281,088$ | 18,142,558$ | 56 | 172,750$ | 9,674,000$ | 11,334,359$ | 25,424,703$ | 12,424,703$ | 37,000,000$ | 11,575,297$ | 241,477,432$ | 250,511,516$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 72 | 68 | 50 | 39 | 145 | 162000 | 112269 | 42076 | 67760 | 27000 | 100.00% | 83.16% | 77.92% | 62.74% | 100.00% | 15 | 15226 - 84.59% | 1,035,546$ | 27,959,732$ | 18000 | 100 | 31,325,068$ | 600,000$ | 0$ | 18,490,138$ | 31,325,068$ | 17,419,735$ | 23 | 0 | 347,558$ | 15,533,184$ | 56 | 236,493$ | 13,243,608$ | 14,592,928$ | 33,532,493$ | 20,532,493$ | 37,000,000$ | 3,467,507$ | 248,552,882$ | 250,206,689$ |
| 18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 59 | 38 | 29 | 193 | 161225 | 134717 | 52934 | 90902 | 26985 | 99.52% | 99.79% | 98.03% | 84.17% | 99.94% | 15 | 17288 - 96.04% | 1,196,826$ | 32,314,308$ | 18000 | 100 | 21,030,700$ | 2,230,000$ | 0$ | 12,811,823$ | 21,030,700$ | 11,764,230$ | 24 | 0 | 234,432$ | 17,952,393$ | 56 | 162,691$ | 9,110,696$ | 10,272,136$ | 23,118,481$ | 10,118,481$ | 37,000,000$ | 13,881,519$ | 231,861,598$ | 240,803,772$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 134231 | 108350 | 51201 | 84825 | 35488 | 71.02% | 66.88% | 63.21% | 62.83% | 65.72% | 15 | 15337 - 66.68% | 1,181,387$ | 31,897,440$ | 23000 | 100 | 23,846,239$ | 760,000$ | 0$ | 14,183,950$ | 23,846,239$ | 13,583,951$ | 24 | 0 | 270,851$ | 17,720,800$ | 56 | 177,473$ | 9,938,488$ | 11,441,467$ | 25,658,839$ | 12,658,839$ | 37,000,000$ | 11,341,161$ | 220,959,638$ | 229,178,929$ |
| 20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 129085 | 137820 | 64892 | 111994 | 27642 | 70.93% | 88.35% | 83.19% | 86.15% | 53.16% | 16 | 18132 - 78.83% | 1,222,199$ | 31,777,170$ | 23000 | 100 | 31,607,034$ | 1,220,000$ | 0$ | 18,876,463$ | 31,607,034$ | 17,582,262$ | 24 | 0 | 350,800$ | 19,555,182$ | 56 | 241,172$ | 13,505,632$ | 14,880,938$ | 34,092,252$ | 21,092,252$ | 37,000,000$ | 2,907,748$ | 315,304,597$ | 321,215,282$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 25 | 169 | 161966 | 117189 | 46911 | 108000 | 27000 | 99.98% | 86.81% | 86.87% | 100.00% | 100.00% | 15 | 17077 - 94.87% | 1,079,212$ | 29,138,730$ | 18000 | 100 | 22,887,141$ | 1,610,000$ | 0$ | 15,502,616$ | 22,887,141$ | 14,782,633$ | 20 | 0 | 294,813$ | 16,188,183$ | 56 | 172,051$ | 9,634,856$ | 10,924,213$ | 25,082,038$ | 12,082,038$ | 37,000,000$ | 11,917,962$ | 227,488,413$ | 233,930,875$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 136088 | 134364 | 54000 | 107366 | 26911 | 84.00% | 99.53% | 100.00% | 99.41% | 99.67% | 15 | 16990 - 94.39% | 1,171,370$ | 31,626,990$ | 18000 | 100 | 24,626,620$ | 840,000$ | 0$ | 16,078,513$ | 24,626,620$ | 15,087,649$ | 22 | 0 | 300,915$ | 17,570,550$ | 56 | 181,262$ | 10,150,672$ | 11,073,846$ | 26,351,120$ | 13,351,120$ | 37,000,000$ | 10,648,880$ | 94,560,732$ | 102,307,956$ |