| 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 Salaries Cap | 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 20,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 | 70479 | 60000 | 24000 | 48000 | 12000 | 97.89% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17873 - 99.30% | 1,257,325$ | 15,087,900$ | 18000 | 100 | 46,074,218$ | 46,074,218$ | 0$ | 13,662,403$ | 46,074,218$ | 13,345,106$ | 21 | 0 | 266,447$ | 37,719,750$ | 111 | 302,399$ | 33,566,289$ | 36,456,345$ | 49,038,768$ | 29,038,768$ | 60,000,000$ | 10,961,232$ | 426,236,474$ | 429,741,735$ |
| 2 | BROOKLYN BLAZERS | 6500 | 5500 | 2500 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 78780 | 71220 | 32500 | 52000 | 13000 | 93.23% | 99.61% | 100.00% | 100.00% | 100.00% | 29 | 19038 - 97.63% | 1,322,208$ | 17,188,700$ | 19500 | 100 | 30,935,782$ | 30,935,782$ | 0$ | 9,395,178$ | 30,935,782$ | 8,887,488$ | 20 | 0 | 177,297$ | 38,344,023$ | 111 | 209,588$ | 23,264,268$ | 26,624,612$ | 34,300,123$ | 14,300,123$ | 60,000,000$ | 25,699,877$ | 392,604,926$ | 406,470,037$ |
| 3 | CALGARY COWBOYS | 7500 | 6500 | 3500 | 4500 | 2500 | 90 | 65 | 33 | 25 | 225 | 82998 | 63054 | 33867 | 53632 | 14053 | 92.22% | 80.84% | 80.64% | 99.32% | 46.84% | 30 | 20634 - 84.22% | 1,432,389$ | 17,188,666$ | 24500 | 100 | 35,981,125$ | 35,981,125$ | 0$ | 10,701,984$ | 35,981,125$ | 10,295,544$ | 23 | 0 | 205,461$ | 42,971,665$ | 111 | 239,680$ | 26,604,480$ | 29,857,704$ | 39,080,925$ | 19,080,925$ | 60,000,000$ | 20,919,075$ | 412,704,405$ | 429,993,358$ |
| 4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 69821 | 60000 | 24000 | 48000 | 12000 | 96.97% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17818 - 98.99% | 1,251,842$ | 15,022,100$ | 18000 | 100 | 39,169,063$ | 39,169,063$ | 0$ | 11,642,997$ | 39,169,063$ | 11,325,702$ | 21 | 0 | 226,074$ | 37,555,250$ | 111 | 258,135$ | 28,652,985$ | 30,840,521$ | 41,519,063$ | 21,519,063$ | 60,000,000$ | 18,480,937$ | 447,320,132$ | 456,160,773$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 69245 | 60000 | 24000 | 48000 | 12000 | 96.17% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17770 - 98.72% | 1,247,042$ | 14,964,500$ | 18000 | 100 | 47,001,981$ | 47,001,981$ | 0$ | 13,932,140$ | 47,001,981$ | 13,557,148$ | 22 | 0 | 270,699$ | 37,411,250$ | 111 | 309,628$ | 34,368,708$ | 37,354,028$ | 49,979,056$ | 29,979,056$ | 60,000,000$ | 10,020,944$ | 435,647,308$ | 437,902,351$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 73067 | 54868 | 31536 | 54557 | 18332 | 86.98% | 76.21% | 87.60% | 90.93% | 76.38% | 30 | 19363 - 84.19% | 1,437,809$ | 17,253,710$ | 23000 | 100 | 42,837,002$ | 42,837,002$ | 0$ | 12,663,449$ | 42,837,002$ | 12,093,729$ | 20 | 0 | 241,423$ | 43,134,275$ | 111 | 287,256$ | 31,885,416$ | 34,294,160$ | 45,288,064$ | 25,288,064$ | 60,000,000$ | 14,711,936$ | 478,253,057$ | 490,685,804$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 120 | 70 | 50 | 40 | 300 | 58048 | 54310 | 22524 | 37341 | 10773 | 80.62% | 90.52% | 93.85% | 77.79% | 89.78% | 30 | 15250 - 84.72% | 1,384,933$ | 16,619,200$ | 18000 | 100 | 27,304,907$ | 27,304,907$ | 0$ | 8,285,314$ | 27,304,907$ | 8,034,349$ | 20 | 0 | 160,236$ | 41,548,000$ | 111 | 180,608$ | 20,047,488$ | 23,296,760$ | 30,217,757$ | 10,217,757$ | 60,000,000$ | 29,782,243$ | 542,011,659$ | 562,484,143$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 69637 | 58234 | 24000 | 48000 | 12000 | 96.72% | 97.06% | 100.00% | 100.00% | 100.00% | 30 | 17656 - 98.09% | 1,320,743$ | 15,848,910$ | 18000 | 100 | 36,529,000$ | 36,529,000$ | 0$ | 10,851,347$ | 36,529,000$ | 10,534,025$ | 21 | 0 | 210,224$ | 39,622,275$ | 111 | 241,212$ | 26,774,532$ | 29,210,628$ | 39,239,250$ | 19,239,250$ | 60,000,000$ | 20,760,750$ | 432,166,275$ | 444,704,802$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 125 | 75 | 40 | 30 | 250 | 56889 | 52424 | 24000 | 48000 | 11933 | 79.01% | 87.37% | 100.00% | 100.00% | 99.44% | 30 | 16104 - 89.47% | 1,368,848$ | 16,426,175$ | 18000 | 100 | 34,141,918$ | 34,141,918$ | 0$ | 9,925,542$ | 34,141,918$ | 9,637,080$ | 22 | 0 | 192,291$ | 41,065,438$ | 111 | 225,269$ | 25,004,859$ | 27,521,243$ | 36,746,168$ | 16,746,168$ | 60,000,000$ | 23,253,832$ | 261,629,722$ | 277,367,299$ |
| 10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 69819 | 60000 | 24000 | 48000 | 12000 | 96.97% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17818 - 98.99% | 1,251,825$ | 15,021,900$ | 18000 | 100 | 35,387,610$ | 35,387,610$ | 0$ | 10,456,578$ | 35,387,610$ | 10,081,008$ | 22 | 0 | 201,174$ | 37,554,750$ | 111 | 235,190$ | 26,106,090$ | 28,854,082$ | 38,424,710$ | 18,424,710$ | 60,000,000$ | 21,575,290$ | 485,715,194$ | 496,587,650$ |
| 11 | HALIFAX HIGHLANDERS | 6700 | 5700 | 2200 | 4200 | 1700 | 109 | 66 | 46 | 36 | 209 | 76459 | 65055 | 23797 | 42232 | 17012 | 95.10% | 95.11% | 90.14% | 83.79% | 83.39% | 30 | 18713 - 91.28% | 1,512,585$ | 18,151,021$ | 20500 | 100 | 40,115,235$ | 40,115,235$ | 0$ | 11,741,549$ | 40,115,235$ | 11,453,080$ | 24 | 0 | 228,611$ | 45,377,552$ | 111 | 263,559$ | 29,255,049$ | 32,275,521$ | 43,134,635$ | 23,134,635$ | 60,000,000$ | 16,865,365$ | 593,529,130$ | 608,486,971$ |
| 12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 75368 | 67861 | 32409 | 55819 | 17708 | 89.72% | 94.25% | 90.03% | 93.03% | 73.78% | 30 | 20764 - 90.28% | 1,473,321$ | 17,679,850$ | 23000 | 100 | 30,640,219$ | 30,640,219$ | 0$ | 9,286,610$ | 30,640,219$ | 8,826,495$ | 23 | 0 | 176,075$ | 44,199,625$ | 111 | 206,636$ | 22,936,596$ | 25,980,468$ | 33,701,115$ | 13,701,115$ | 60,000,000$ | 26,298,885$ | 482,497,417$ | 502,953,734$ |
| 13 | LAS CRUCES SPURS | 7500 | 6500 | 3500 | 4500 | 2500 | 102 | 63 | 35 | 27 | 240 | 68820 | 68166 | 32903 | 53097 | 12920 | 76.47% | 87.39% | 78.34% | 98.33% | 43.07% | 30 | 19659 - 80.24% | 1,416,677$ | 17,000,122$ | 24500 | 100 | 37,459,375$ | 37,459,375$ | 0$ | 10,824,585$ | 37,459,375$ | 10,489,965$ | 23 | 0 | 209,340$ | 42,500,305$ | 111 | 247,560$ | 27,479,160$ | 31,030,032$ | 40,389,713$ | 20,389,713$ | 60,000,000$ | 19,610,287$ | 489,304,037$ | 505,012,397$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 69027 | 60000 | 24000 | 48000 | 12000 | 95.87% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17752 - 98.62% | 1,245,225$ | 14,942,700$ | 18000 | 100 | 37,306,384$ | 37,306,384$ | 0$ | 11,272,950$ | 37,306,384$ | 10,761,435$ | 21 | 0 | 214,785$ | 37,356,750$ | 111 | 250,510$ | 27,806,610$ | 30,985,266$ | 40,660,459$ | 20,660,459$ | 60,000,000$ | 19,339,541$ | 398,647,606$ | 407,235,103$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 72000 | 54224 | 23524 | 48000 | 12000 | 100.00% | 90.37% | 98.02% | 100.00% | 100.00% | 30 | 17479 - 97.11% | 1,214,522$ | 14,574,260$ | 18000 | 100 | 36,966,639$ | 36,966,639$ | 0$ | 10,958,997$ | 36,966,639$ | 10,511,916$ | 23 | 0 | 209,802$ | 36,435,650$ | 111 | 246,902$ | 27,406,122$ | 30,324,362$ | 39,997,539$ | 19,997,539$ | 60,000,000$ | 20,002,461$ | 306,120,737$ | 314,116,992$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 100 | 60 | 30 | 28 | 200 | 73440 | 68907 | 33332 | 55516 | 17316 | 81.60% | 88.34% | 50.50% | 92.53% | 96.20% | 30 | 20709 - 79.65% | 1,458,002$ | 17,496,028$ | 26000 | 100 | 38,120,376$ | 38,120,376$ | 0$ | 11,429,914$ | 38,120,376$ | 10,925,979$ | 20 | 0 | 218,066$ | 43,740,070$ | 111 | 255,560$ | 28,367,160$ | 31,817,672$ | 42,063,896$ | 22,063,896$ | 60,000,000$ | 17,936,104$ | 509,971,638$ | 526,145,157$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 95 | 94 | 84 | 69 | 185 | 73138 | 44740 | 14794 | 24262 | 13000 | 93.77% | 68.83% | 56.90% | 46.66% | 100.00% | 29 | 13072 - 72.62% | 1,287,759$ | 16,740,865$ | 18000 | 100 | 35,690,167$ | 35,690,167$ | 0$ | 11,025,011$ | 35,690,167$ | 10,750,977$ | 21 | 0 | 214,581$ | 37,345,007$ | 111 | 234,873$ | 26,070,903$ | 28,422,655$ | 38,184,562$ | 18,184,562$ | 60,000,000$ | 21,815,438$ | 398,989,219$ | 409,071,571$ |
| 18 | PHILADELPHIA MADMEN | 6500 | 5500 | 2000 | 4000 | 1500 | 99 | 60 | 45 | 34 | 199 | 76911 | 60894 | 23107 | 42273 | 17175 | 98.60% | 92.26% | 96.28% | 88.07% | 95.42% | 30 | 18363 - 94.17% | 1,410,666$ | 16,927,990$ | 19500 | 100 | 30,698,606$ | 30,698,606$ | 0$ | 9,681,040$ | 30,698,606$ | 9,299,300$ | 22 | 0 | 185,534$ | 42,319,975$ | 111 | 206,401$ | 22,910,511$ | 26,512,447$ | 34,448,013$ | 14,448,013$ | 60,000,000$ | 25,551,987$ | 420,336,933$ | 438,053,796$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 74571 | 54835 | 31908 | 54755 | 18050 | 88.78% | 76.16% | 88.63% | 91.26% | 75.21% | 30 | 19510 - 84.83% | 1,447,773$ | 17,373,270$ | 23000 | 100 | 38,493,415$ | 38,493,415$ | 0$ | 11,986,205$ | 38,493,415$ | 11,695,145$ | 20 | 0 | 233,463$ | 43,433,175$ | 111 | 253,221$ | 28,107,531$ | 30,736,131$ | 41,259,390$ | 21,259,390$ | 60,000,000$ | 18,740,610$ | 429,337,292$ | 445,547,463$ |
| 20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 73551 | 69901 | 33618 | 57318 | 18270 | 87.56% | 97.08% | 93.38% | 95.53% | 76.13% | 30 | 21055 - 91.54% | 1,484,395$ | 17,812,740$ | 23000 | 100 | 34,146,406$ | 34,146,406$ | 0$ | 10,259,235$ | 34,146,406$ | 9,849,915$ | 22 | 0 | 196,560$ | 44,531,850$ | 111 | 227,983$ | 25,306,113$ | 28,333,449$ | 37,351,618$ | 17,351,618$ | 60,000,000$ | 22,648,382$ | 505,404,795$ | 523,800,024$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 80 | 72 | 62 | 60 | 400 | 72000 | 53038 | 17832 | 24775 | 9553 | 100.00% | 88.40% | 74.30% | 51.61% | 79.61% | 30 | 14767 - 82.04% | 1,180,116$ | 14,161,394$ | 18000 | 100 | 37,842,363$ | 37,842,363$ | 0$ | 10,654,875$ | 37,842,363$ | 10,308,700$ | 25 | 0 | 205,725$ | 35,403,485$ | 111 | 250,272$ | 27,780,192$ | 30,315,088$ | 40,574,082$ | 20,574,082$ | 60,000,000$ | 19,425,918$ | 392,812,375$ | 399,495,772$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 70906 | 60000 | 24000 | 48000 | 12000 | 98.48% | 100.00% | 100.00% | 100.00% | 100.00% | 30 | 17909 - 99.49% | 1,260,883$ | 15,130,600$ | 18000 | 100 | 36,334,375$ | 36,334,375$ | 0$ | 10,772,584$ | 36,334,375$ | 10,521,619$ | 21 | 0 | 209,991$ | 37,826,500$ | 111 | 238,490$ | 26,472,390$ | 29,013,838$ | 38,725,475$ | 18,725,475$ | 60,000,000$ | 21,274,525$ | 245,552,122$ | 256,530,928$ |