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 | 230445 | 195000 | 78000 | 156000 | 39000 | 98.48% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 17909 - 99.49% | 1,260,885$ | 49,174,500$ | 18000 | 100 | 37,287,096$ | 640,000$ | 0$ | 32,349,373$ | 37,287,096$ | 31,326,922$ | 23 | 0 | 625,084$ | 3,782,654$ | 11 | 246,071$ | 2,706,781$ | 2,983,225$ | 39,727,967$ | 24,727,967$ | 45,000,000$ | 5,272,033$ | 376,790,785$ | 377,756,792$ |
2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 226983 | 195000 | 78000 | 155927 | 39000 | 97.00% | 100.00% | 100.00% | 99.95% | 100.00% | 3 | 17818 - 98.99% | 1,251,961$ | 48,826,475$ | 18000 | 100 | 34,709,946$ | 760,000$ | 0$ | 30,275,235$ | 34,709,946$ | 29,223,966$ | 21 | 0 | 583,017$ | 3,755,883$ | 11 | 229,551$ | 2,525,061$ | 2,816,613$ | 37,392,396$ | 22,392,396$ | 45,000,000$ | 7,607,604$ | 356,165,858$ | 357,356,476$ |
3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 258703 | 215243 | 102777 | 172648 | 41173 | 86.23% | 82.79% | 73.41% | 95.92% | 41.17% | 2 | 19764 - 80.67% | 1,356,146$ | 54,245,831$ | 24500 | 100 | 35,271,003$ | 760,000$ | 0$ | 31,234,394$ | 35,271,003$ | 29,924,754$ | 23 | 0 | 597,092$ | 2,712,292$ | 11 | 235,128$ | 2,586,408$ | 2,891,196$ | 37,839,703$ | 22,839,703$ | 45,000,000$ | 7,160,297$ | 344,610,820$ | 344,726,468$ |
4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 229709 | 194932 | 78000 | 155969 | 39000 | 98.17% | 99.97% | 100.00% | 99.98% | 100.00% | 3 | 17887 - 99.37% | 1,258,873$ | 49,096,045$ | 18000 | 100 | 33,009,258$ | 680,000$ | 0$ | 33,137,521$ | 33,009,258$ | 30,387,434$ | 22 | 0 | 606,288$ | 3,776,619$ | 11 | 225,425$ | 2,479,675$ | 2,747,095$ | 35,258,658$ | 20,258,658$ | 45,000,000$ | 9,741,342$ | 405,511,813$ | 406,709,329$ |
5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 229748 | 195000 | 78000 | 156000 | 39000 | 98.18% | 100.00% | 100.00% | 100.00% | 100.00% | 3 | 17891 - 99.39% | 1,259,097$ | 49,104,800$ | 18000 | 100 | 40,603,343$ | 680,000$ | 0$ | 35,318,777$ | 40,603,343$ | 34,575,217$ | 22 | 0 | 690,034$ | 3,777,292$ | 11 | 265,406$ | 2,919,466$ | 3,213,142$ | 43,145,593$ | 28,145,593$ | 45,000,000$ | 1,854,407$ | 401,206,486$ | 402,019,813$ |
6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 246458 | 171693 | 98648 | 170195 | 54033 | 88.02% | 71.54% | 82.21% | 85.10% | 67.54% | 2 | 18526 - 80.55% | 1,379,296$ | 55,171,855$ | 23000 | 100 | 34,429,093$ | 1,000,000$ | 0$ | 31,836,582$ | 34,429,093$ | 30,000,819$ | 26 | 0 | 598,573$ | 2,758,593$ | 11 | 233,360$ | 2,566,960$ | 2,806,372$ | 36,561,393$ | 21,561,393$ | 45,000,000$ | 8,438,607$ | 412,599,986$ | 412,805,369$ |
7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 70 | 50 | 30 | 250 | 227940 | 171125 | 70802 | 155744 | 36152 | 97.41% | 87.76% | 90.77% | 99.84% | 92.70% | 3 | 16968 - 94.27% | 1,333,927$ | 52,023,170$ | 18000 | 100 | 24,541,594$ | 760,000$ | 0$ | 21,677,098$ | 24,541,594$ | 20,868,443$ | 20 | 0 | 415,922$ | 4,001,782$ | 11 | 162,895$ | 1,791,845$ | 2,089,337$ | 27,433,808$ | 12,433,808$ | 45,000,000$ | 17,566,192$ | 462,982,257$ | 465,150,339$ |
8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 226134 | 192195 | 78000 | 153924 | 37437 | 96.64% | 98.56% | 100.00% | 98.67% | 95.99% | 3 | 17633 - 97.96% | 1,314,542$ | 51,267,120$ | 18000 | 100 | 26,365,000$ | 880,000$ | 0$ | 24,159,216$ | 26,365,000$ | 22,511,083$ | 23 | 0 | 448,793$ | 3,943,625$ | 11 | 180,373$ | 1,984,103$ | 2,213,471$ | 28,536,500$ | 13,536,500$ | 45,000,000$ | 16,463,500$ | 367,117,295$ | 369,001,467$ |
9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 202330 | 180888 | 80000 | 159982 | 38857 | 84.30% | 90.44% | 100.00% | 99.99% | 97.14% | 2 | 16551 - 91.95% | 1,294,041$ | 51,761,625$ | 18000 | 100 | 31,173,249$ | 800,000$ | 0$ | 29,307,877$ | 31,173,249$ | 27,863,180$ | 23 | 0 | 555,831$ | 2,588,081$ | 11 | 209,792$ | 2,307,712$ | 2,626,900$ | 34,348,349$ | 19,348,349$ | 45,000,000$ | 10,651,651$ | 204,824,552$ | 204,953,721$ |
10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 231789 | 194972 | 78000 | 156000 | 39000 | 99.06% | 99.99% | 100.00% | 100.00% | 100.00% | 3 | 17943 - 99.68% | 1,264,288$ | 49,307,220$ | 18000 | 100 | 28,979,124$ | 640,000$ | 0$ | 28,555,024$ | 28,979,124$ | 27,510,299$ | 22 | 0 | 548,728$ | 3,792,863$ | 11 | 192,969$ | 2,122,659$ | 2,431,827$ | 31,722,124$ | 16,722,124$ | 45,000,000$ | 13,277,876$ | 426,085,165$ | 427,613,441$ |
11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 111 | 78 | 51 | 35 | 239 | 219294 | 159091 | 67761 | 130516 | 41447 | 90.69% | 78.45% | 78.98% | 79.68% | 88.56% | 3 | 15849 - 83.42% | 1,361,773$ | 53,109,137$ | 19000 | 100 | 35,358,823$ | 1,334,000$ | 0$ | 30,768,499$ | 35,358,823$ | 29,839,026$ | 25 | 0 | 595,314$ | 4,085,318$ | 11 | 233,069$ | 2,563,759$ | 2,837,599$ | 38,141,519$ | 23,141,519$ | 45,000,000$ | 6,858,481$ | 477,419,133$ | 478,834,496$ |
12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 245734 | 213263 | 100378 | 171871 | 50277 | 87.76% | 88.86% | 83.65% | 85.94% | 62.85% | 2 | 19538 - 84.95% | 1,380,865$ | 55,234,585$ | 23000 | 100 | 35,223,634$ | 840,000$ | 0$ | 34,029,159$ | 35,223,634$ | 33,099,626$ | 26 | 0 | 660,570$ | 2,761,729$ | 11 | 232,203$ | 2,554,233$ | 2,812,749$ | 37,805,878$ | 22,805,878$ | 45,000,000$ | 7,194,122$ | 419,617,845$ | 419,734,523$ |
13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 211920 | 216522 | 101376 | 168267 | 39678 | 72.45% | 85.41% | 74.27% | 95.88% | 40.70% | 3 | 18917 - 77.21% | 1,355,662$ | 52,870,815$ | 24500 | 100 | 35,578,713$ | 720,000$ | 0$ | 30,605,611$ | 35,578,713$ | 29,583,176$ | 23 | 0 | 590,200$ | 4,066,986$ | 11 | 235,120$ | 2,586,320$ | 2,878,592$ | 37,807,674$ | 22,807,674$ | 45,000,000$ | 7,192,326$ | 398,265,874$ | 399,771,084$ |
14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 228333 | 194824 | 78000 | 155997 | 39000 | 97.58% | 99.91% | 100.00% | 100.00% | 100.00% | 3 | 17850 - 99.17% | 1,255,197$ | 48,952,665$ | 18000 | 100 | 31,969,603$ | 760,000$ | 0$ | 27,675,434$ | 31,969,603$ | 25,994,884$ | 21 | 0 | 518,433$ | 3,765,590$ | 11 | 216,523$ | 2,381,753$ | 2,702,009$ | 34,959,603$ | 19,959,603$ | 45,000,000$ | 10,040,397$ | 349,323,205$ | 350,554,389$ |
15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 233706 | 171657 | 75666 | 155686 | 39000 | 99.87% | 88.03% | 97.01% | 99.80% | 100.00% | 3 | 17326 - 96.26% | 1,204,489$ | 46,975,080$ | 18000 | 100 | 39,477,042$ | 1,770,000$ | 0$ | 37,074,117$ | 39,477,042$ | 35,633,397$ | 23 | 0 | 711,210$ | 3,613,468$ | 11 | 262,994$ | 2,892,934$ | 3,225,358$ | 42,676,181$ | 27,676,181$ | 45,000,000$ | 2,323,819$ | 263,170,950$ | 263,688,972$ |
16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 247371 | 220144 | 105534 | 174574 | 51559 | 82.46% | 84.67% | 47.97% | 87.29% | 85.93% | 2 | 19980 - 76.84% | 1,407,791$ | 56,311,632$ | 26000 | 100 | 27,290,263$ | 1,210,000$ | 0$ | 24,300,076$ | 27,290,263$ | 23,221,878$ | 20 | 0 | 462,941$ | 2,815,582$ | 11 | 182,373$ | 2,006,103$ | 2,368,263$ | 30,281,588$ | 15,281,588$ | 45,000,000$ | 14,718,412$ | 406,028,281$ | 406,773,848$ |
17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 70 | 150 | 201456 | 127721 | 43845 | 67040 | 39000 | 86.09% | 65.50% | 56.21% | 42.97% | 100.00% | 3 | 12284 - 68.24% | 1,219,385$ | 47,556,000$ | 18000 | 100 | 38,816,363$ | 920,000$ | 0$ | 26,331,764$ | 38,816,363$ | 25,566,794$ | 23 | 0 | 509,877$ | 3,658,154$ | 11 | 254,098$ | 2,795,078$ | 3,049,274$ | 41,242,088$ | 26,242,088$ | 45,000,000$ | 3,757,912$ | 351,767,625$ | 352,456,505$ |
18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 109 | 78 | 56 | 32 | 249 | 217209 | 173269 | 71399 | 131508 | 38796 | 90.50% | 86.63% | 89.25% | 82.19% | 96.99% | 2 | 15805 - 87.80% | 1,302,060$ | 52,082,415$ | 18000 | 100 | 34,613,192$ | 680,000$ | 0$ | 31,457,570$ | 34,613,192$ | 29,826,039$ | 23 | 0 | 595,053$ | 2,604,121$ | 11 | 231,495$ | 2,546,445$ | 2,856,513$ | 37,258,964$ | 22,258,964$ | 45,000,000$ | 7,741,036$ | 353,380,933$ | 353,373,100$ |
19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 244749 | 170314 | 99624 | 167597 | 53891 | 89.65% | 72.78% | 85.15% | 85.95% | 69.09% | 3 | 18876 - 82.07% | 1,406,171$ | 54,840,675$ | 23000 | 100 | 35,898,891$ | 920,000$ | 0$ | 34,509,367$ | 35,898,891$ | 33,571,529$ | 25 | 0 | 669,974$ | 4,218,513$ | 11 | 236,589$ | 2,602,479$ | 2,886,351$ | 38,051,841$ | 23,051,841$ | 45,000,000$ | 6,948,159$ | 340,371,043$ | 342,081,247$ |
20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 248537 | 217769 | 102227 | 178272 | 50907 | 88.76% | 90.74% | 85.19% | 89.14% | 63.63% | 2 | 19943 - 86.71% | 1,403,400$ | 56,135,985$ | 23000 | 100 | 30,811,990$ | 960,000$ | 0$ | 30,201,277$ | 30,811,990$ | 29,271,797$ | 25 | 0 | 583,953$ | 2,806,799$ | 11 | 203,923$ | 2,243,153$ | 2,506,805$ | 33,361,490$ | 18,361,490$ | 45,000,000$ | 11,638,510$ | 443,547,842$ | 444,014,180$ |
21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 105 | 95 | 85 | 75 | 150 | 197127 | 124019 | 42329 | 64162 | 39000 | 84.24% | 63.60% | 54.27% | 41.13% | 100.00% | 3 | 11965 - 66.47% | 1,198,468$ | 46,740,255$ | 18000 | 100 | 26,963,219$ | 920,000$ | 0$ | 27,192,550$ | 26,963,219$ | 26,463,853$ | 24 | 0 | 527,835$ | 3,595,404$ | 11 | 177,867$ | 1,956,537$ | 2,311,425$ | 30,406,349$ | 15,406,349$ | 45,000,000$ | 14,593,651$ | 344,019,705$ | 345,413,658$ |
22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 234621 | 199998 | 80000 | 160000 | 40000 | 97.76% | 100.00% | 100.00% | 100.00% | 100.00% | 2 | 17865 - 99.25% | 1,256,550$ | 50,261,980$ | 18000 | 100 | 30,932,959$ | 920,000$ | 0$ | 30,137,123$ | 30,932,959$ | 28,501,233$ | 23 | 0 | 568,549$ | 2,513,099$ | 11 | 209,570$ | 2,305,270$ | 2,542,330$ | 33,164,559$ | 18,164,559$ | 45,000,000$ | 11,835,441$ | 196,397,903$ | 196,534,442$ |