| 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 | 15186 | 15000 | 6000 | 11996 | 3000 | 84.37% | 100.00% | 100.00% | 99.97% | 100.00% | 39 | 17061 - 94.78% | 1,176,167$ | 3,528,500$ | 18000 | 100 | 25,356,853$ | 1,000,000$ | 0$ | 1,506,104$ | 25,356,853$ | 1,448,960$ | 22 | 0 | 28,896$ | 45,870,500$ | 132 | 188,263$ | 24,850,716$ | 28,250,371$ | 27,879,087$ | 14,879,087$ | 37,000,000$ | 9,120,913$ | 252,314,664$ | 272,803,048$ |
| 2 | BROOKLYN BLAZERS | 6000 | 5000 | 2000 | 4000 | 1000 | 92 | 70 | 38 | 31 | 240 | 17713 | 11890 | 5832 | 8801 | 2743 | 98.41% | 79.27% | 97.20% | 73.34% | 91.43% | 39 | 15660 - 87.00% | 1,204,888$ | 3,614,663$ | 18000 | 100 | 28,928,560$ | 680,000$ | 0$ | 1,626,688$ | 28,928,560$ | 1,555,264$ | 22 | 0 | 31,028$ | 46,990,619$ | 132 | 215,561$ | 28,454,052$ | 30,820,727$ | 30,604,060$ | 17,604,060$ | 37,000,000$ | 6,395,940$ | 254,951,413$ | 273,888,732$ |
| 3 | CALGARY COWBOYS | 7000 | 6000 | 3000 | 4000 | 2000 | 90 | 65 | 33 | 25 | 225 | 19853 | 13247 | 7441 | 11970 | 2954 | 94.54% | 73.59% | 82.68% | 99.75% | 49.23% | 39 | 18488 - 84.04% | 1,285,759$ | 3,857,278$ | 22000 | 100 | 28,229,545$ | 680,000$ | 0$ | 1,721,283$ | 28,229,545$ | 1,637,796$ | 24 | 0 | 32,675$ | 50,144,614$ | 132 | 212,075$ | 27,993,900$ | 31,181,342$ | 30,184,045$ | 17,184,045$ | 37,000,000$ | 6,815,955$ | 246,397,248$ | 270,181,388$ |
| 4 | CAPE BRETON CELTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 16225 | 15000 | 6000 | 12000 | 2997 | 90.14% | 100.00% | 100.00% | 100.00% | 99.90% | 39 | 17407 - 96.71% | 1,210,633$ | 3,631,900$ | 18000 | 100 | 26,921,610$ | 600,000$ | 0$ | 1,783,477$ | 26,921,610$ | 1,605,877$ | 23 | 0 | 32,039$ | 47,214,700$ | 132 | 214,497$ | 28,313,604$ | 30,688,910$ | 28,537,985$ | 15,537,985$ | 37,000,000$ | 8,462,015$ | 291,466,999$ | 310,793,589$ |
| 5 | CAPE FEAR PROWLERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10904 | 10000 | 4000 | 7887 | 1994 | 90.87% | 100.00% | 100.00% | 98.59% | 99.70% | 40 | 17393 - 96.63% | 1,213,188$ | 2,426,375$ | 18000 | 100 | 26,502,238$ | 1,464,000$ | 0$ | 1,560,128$ | 26,502,238$ | 1,514,416$ | 22 | 0 | 30,208$ | 48,527,500$ | 132 | 195,016$ | 25,742,112$ | 29,076,418$ | 28,831,228$ | 15,831,228$ | 37,000,000$ | 8,168,772$ | 282,458,567$ | 304,771,349$ |
| 6 | CHICAGO CRUSHERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 15431 | 12343 | 5902 | 9552 | 3312 | 73.48% | 68.57% | 65.58% | 63.68% | 55.20% | 39 | 15513 - 67.45% | 1,197,383$ | 3,592,150$ | 23000 | 100 | 26,923,610$ | 800,000$ | 0$ | 1,651,709$ | 26,923,610$ | 1,538,853$ | 24 | 0 | 30,695$ | 46,697,950$ | 132 | 206,419$ | 27,247,308$ | 29,787,425$ | 28,612,110$ | 15,612,110$ | 37,000,000$ | 8,387,890$ | 251,405,016$ | 271,328,541$ |
| 7 | COLORADO WOLVES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 9807 | 10000 | 4000 | 7974 | 2000 | 81.73% | 100.00% | 100.00% | 99.68% | 100.00% | 40 | 16891 - 93.84% | 1,160,025$ | 2,320,050$ | 18000 | 100 | 21,817,922$ | 640,000$ | 0$ | 1,310,171$ | 21,817,922$ | 1,245,490$ | 22 | 0 | 24,828$ | 46,401,000$ | 132 | 163,928$ | 21,638,496$ | 24,758,671$ | 23,525,272$ | 10,525,272$ | 37,000,000$ | 13,474,728$ | 311,627,327$ | 336,083,246$ |
| 8 | COQUITLAM KNIGHTS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 65 | 40 | 30 | 225 | 15686 | 12941 | 5622 | 9525 | 2870 | 87.14% | 86.27% | 93.70% | 79.38% | 95.67% | 39 | 15548 - 86.38% | 1,188,715$ | 3,566,145$ | 18000 | 100 | 28,860,200$ | 840,000$ | 0$ | 1,759,268$ | 28,860,200$ | 1,684,868$ | 22 | 0 | 33,616$ | 46,359,885$ | 132 | 215,444$ | 28,438,608$ | 31,431,784$ | 30,528,200$ | 17,528,200$ | 37,000,000$ | 6,471,800$ | 248,949,901$ | 266,766,802$ |
| 9 | DETROIT RED WINGS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 14747 | 15000 | 6000 | 12000 | 3000 | 81.93% | 100.00% | 100.00% | 100.00% | 100.00% | 39 | 16916 - 93.98% | 1,161,567$ | 3,484,700$ | 18000 | 100 | 28,983,724$ | 720,000$ | 0$ | 1,745,032$ | 28,983,724$ | 1,656,216$ | 20 | 0 | 33,048$ | 45,301,100$ | 132 | 218,129$ | 28,793,028$ | 31,669,206$ | 31,026,859$ | 18,026,859$ | 37,000,000$ | 5,973,141$ | 83,516,587$ | 99,947,966$ |
| 10 | EDMONTON BUSCHWACKERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 15327 | 14924 | 6000 | 12000 | 3000 | 85.15% | 99.49% | 100.00% | 100.00% | 100.00% | 39 | 17084 - 94.91% | 1,179,380$ | 3,538,140$ | 18000 | 100 | 22,251,280$ | 560,000$ | 0$ | 1,374,828$ | 22,251,280$ | 1,309,568$ | 21 | 0 | 26,110$ | 45,995,820$ | 132 | 167,095$ | 22,056,540$ | 24,620,084$ | 23,947,030$ | 10,947,030$ | 37,000,000$ | 13,052,970$ | 293,581,959$ | 318,047,095$ |
| 11 | HALIFAX HIGHLANDERS | 6200 | 5200 | 2200 | 4200 | 1200 | 85 | 59 | 35 | 23 | 186 | 8375 | 9067 | 4018 | 7304 | 1977 | 67.54% | 87.18% | 91.32% | 86.95% | 82.38% | 40 | 15371 - 80.90% | 1,171,670$ | 2,343,339$ | 19000 | 100 | 27,164,937$ | 1,514,000$ | 0$ | 1,694,041$ | 27,164,937$ | 1,636,897$ | 23 | 0 | 32,658$ | 46,866,780$ | 132 | 201,178$ | 26,555,496$ | 29,476,199$ | 29,206,793$ | 16,206,793$ | 37,000,000$ | 7,793,207$ | 298,980,622$ | 318,956,903$ |
| 12 | HAWAII TYPHOON | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 15174 | 15283 | 6906 | 12933 | 3191 | 72.26% | 84.91% | 76.73% | 86.22% | 53.18% | 39 | 17829 - 77.52% | 1,212,538$ | 3,637,615$ | 23000 | 100 | 29,571,765$ | 1,260,000$ | 0$ | 1,788,384$ | 29,571,765$ | 1,689,816$ | 24 | 0 | 33,720$ | 47,288,995$ | 132 | 223,548$ | 29,508,336$ | 32,846,615$ | 32,005,035$ | 19,005,035$ | 37,000,000$ | 4,994,965$ | 305,246,568$ | 322,572,608$ |
| 13 | LAS CRUCES SPURS | 7000 | 6000 | 3000 | 4000 | 2000 | 102 | 63 | 35 | 27 | 240 | 15356 | 12784 | 7309 | 11580 | 2881 | 73.12% | 71.02% | 81.21% | 96.50% | 48.02% | 39 | 16637 - 75.62% | 1,210,540$ | 3,631,619$ | 22000 | 100 | 26,845,953$ | 1,367,000$ | 0$ | 1,671,850$ | 26,845,953$ | 1,643,278$ | 24 | 0 | 32,785$ | 47,211,047$ | 132 | 195,328$ | 25,783,296$ | 29,198,021$ | 29,360,062$ | 16,360,062$ | 37,000,000$ | 7,639,938$ | 289,781,988$ | 312,428,574$ |
| 14 | MANHATTAN ISLANDERS | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 10407 | 10000 | 4000 | 8000 | 2000 | 86.73% | 100.00% | 100.00% | 100.00% | 100.00% | 40 | 17204 - 95.58% | 1,190,350$ | 2,380,700$ | 18000 | 100 | 27,384,637$ | 640,000$ | 0$ | 1,668,152$ | 27,384,637$ | 1,564,840$ | 25 | 0 | 31,216$ | 47,614,000$ | 132 | 208,519$ | 27,524,508$ | 30,766,887$ | 29,405,394$ | 16,405,394$ | 37,000,000$ | 7,594,606$ | 250,623,222$ | 270,381,035$ |
| 15 | NEWTON NIGHTMARES | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 70 | 45 | 30 | 150 | 18000 | 11465 | 4908 | 9880 | 3000 | 100.00% | 76.43% | 81.80% | 82.33% | 100.00% | 39 | 15751 - 87.51% | 1,129,937$ | 3,389,810$ | 18000 | 100 | 29,183,000$ | 1,700,000$ | 0$ | 1,750,456$ | 29,183,000$ | 1,667,600$ | 22 | 1 | 33,272$ | 44,067,530$ | 132 | 218,807$ | 28,882,524$ | 31,643,759$ | 31,355,500$ | 18,355,500$ | 37,000,000$ | 5,644,500$ | 160,766,192$ | 175,786,363$ |
| 16 | NORTH VAN ROCKERS | 7500 | 6500 | 5500 | 5000 | 1500 | 75 | 40 | 27 | 23 | 150 | 12954 | 10528 | 5289 | 8183 | 2738 | 86.36% | 80.98% | 48.08% | 81.83% | 91.27% | 40 | 19846 - 76.33% | 1,117,196$ | 2,234,392$ | 26000 | 100 | 23,429,628$ | 1,892,750$ | 0$ | 1,393,696$ | 23,429,628$ | 1,338,832$ | 20 | 0 | 26,696$ | 44,687,840$ | 132 | 174,212$ | 22,995,984$ | 26,677,722$ | 25,579,378$ | 12,579,378$ | 37,000,000$ | 11,420,622$ | 226,607,765$ | 250,057,967$ |
| 17 | PENSACOLA BADGERS | 6000 | 5000 | 2000 | 4000 | 1000 | 72 | 68 | 50 | 39 | 145 | 18000 | 12449 | 4828 | 7383 | 3000 | 100.00% | 82.99% | 80.47% | 61.53% | 100.00% | 39 | 15220 - 84.56% | 1,035,623$ | 3,106,869$ | 18000 | 100 | 30,474,473$ | 760,000$ | 0$ | 1,791,417$ | 30,474,473$ | 1,689,473$ | 24 | 0 | 33,711$ | 40,389,297$ | 132 | 230,418$ | 30,415,176$ | 33,455,343$ | 32,692,122$ | 19,692,122$ | 37,000,000$ | 4,307,878$ | 241,508,032$ | 250,121,986$ |
| 18 | PHILADELPHIA MADMEN | 6000 | 5000 | 2000 | 4000 | 1000 | 90 | 59 | 38 | 29 | 193 | 18000 | 15000 | 5959 | 10811 | 3000 | 100.00% | 100.00% | 99.32% | 90.09% | 100.00% | 39 | 17590 - 97.72% | 1,207,987$ | 3,623,961$ | 18000 | 100 | 18,474,763$ | 2,150,000$ | 0$ | 1,155,472$ | 18,474,763$ | 1,055,704$ | 22 | 0 | 21,032$ | 47,111,493$ | 132 | 144,434$ | 19,065,288$ | 21,642,943$ | 20,529,919$ | 7,529,919$ | 37,000,000$ | 16,470,081$ | 214,796,665$ | 243,121,185$ |
| 19 | PINCHER CREEK PREDATORS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 70 | 40 | 30 | 175 | 15049 | 12515 | 5660 | 9596 | 3466 | 71.66% | 69.53% | 62.89% | 63.97% | 57.77% | 39 | 15429 - 67.08% | 1,196,143$ | 3,588,430$ | 23000 | 100 | 20,852,456$ | 560,000$ | 0$ | 1,248,712$ | 20,852,456$ | 1,191,568$ | 21 | 0 | 23,752$ | 46,649,590$ | 132 | 156,089$ | 20,603,748$ | 24,169,036$ | 22,865,956$ | 9,865,956$ | 37,000,000$ | 14,134,044$ | 205,051,630$ | 230,620,784$ |
| 20 | SAN JOSE BLASPHEMERS | 7000 | 6000 | 3000 | 5000 | 2000 | 100 | 60 | 35 | 25 | 200 | 9650 | 10494 | 4823 | 8592 | 2221 | 68.93% | 87.45% | 80.38% | 85.92% | 55.53% | 40 | 17890 - 77.78% | 1,211,223$ | 2,422,445$ | 23000 | 100 | 29,231,648$ | 800,000$ | 0$ | 1,745,524$ | 29,231,648$ | 1,622,262$ | 25 | 0 | 32,366$ | 48,448,900$ | 132 | 224,205$ | 29,595,060$ | 32,517,407$ | 31,540,616$ | 18,540,616$ | 37,000,000$ | 5,459,384$ | 303,397,204$ | 322,377,097$ |
| 21 | SYRACUSE BULLDOGS | 6000 | 5000 | 2000 | 4000 | 1000 | 75 | 65 | 45 | 25 | 169 | 18000 | 12662 | 5163 | 12000 | 3000 | 100.00% | 84.41% | 86.05% | 100.00% | 100.00% | 39 | 16942 - 94.12% | 1,070,788$ | 3,212,365$ | 18000 | 100 | 27,392,222$ | 1,570,000$ | 0$ | 1,636,721$ | 27,392,222$ | 1,568,153$ | 20 | 0 | 31,282$ | 41,760,745$ | 132 | 204,230$ | 26,958,360$ | 30,002,363$ | 29,743,994$ | 16,743,994$ | 37,000,000$ | 7,256,006$ | 216,085,286$ | 230,718,228$ |
| 22 | VANCOUVER MILLIONAIRES | 6000 | 5000 | 2000 | 4000 | 1000 | 100 | 60 | 35 | 25 | 200 | 14641 | 15000 | 6000 | 11861 | 3000 | 81.34% | 100.00% | 100.00% | 98.84% | 100.00% | 39 | 16834 - 93.52% | 1,156,875$ | 3,470,625$ | 18000 | 100 | 24,306,407$ | 880,000$ | 0$ | 1,521,512$ | 24,306,407$ | 1,420,184$ | 22 | 0 | 28,326$ | 45,118,125$ | 132 | 186,283$ | 24,589,356$ | 26,717,103$ | 26,088,407$ | 13,088,407$ | 37,000,000$ | 10,911,593$ | 80,767,387$ | 102,067,279$ |