| 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 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Capacity | Team Popularity | Players Total Salaries | Players Total Salaries Cap | Year To Date Expenses | Salary Cap Per Days | Salary Cap To Date | Players In Salary Cap | Players Out of Salary Cap | Estimated Season Revenue | Remaining Season Days | Expenses Per Days | Estimated Season Expenses |
| 1 |  Abbotsford Canucks (VAN) | 5000 | 2500 | 35 | 15 | 69682 | 41994 | 77.42% | 93.32% | 18 | 6204 - 82.72% | 254,027$ | 4,572,484$ | 7500 | 100 | 2,135,333$ | 2,135,333$ | 1,660,446$ | 0$ | 1,095,906$ | 0 | 0 | 4,572,484$ | 95 | 17,118$ | 1,574,856$ |
| 2 |  Bakersfield Condors (EDM) | 5000 | 2500 | 30 | 15 | 85729 | 41997 | 95.25% | 93.33% | 18 | 7096 - 94.61% | 265,040$ | 4,770,721$ | 7500 | 100 | 1,754,249$ | 1,754,249$ | 1,504,270$ | 0$ | 878,135$ | 0 | 0 | 4,770,721$ | 95 | 15,737$ | 1,447,804$ |
| 3 |  Belleville Senators (OTT) | 5000 | 2500 | 35 | 15 | 68907 | 42766 | 76.56% | 95.04% | 18 | 6204 - 82.72% | 252,740$ | 4,549,319$ | 7500 | 100 | 2,412,833$ | 2,412,833$ | 1,851,133$ | 0$ | 1,283,984$ | 0 | 0 | 4,549,319$ | 95 | 18,613$ | 1,712,396$ |
| 4 |  Bridgeport Islanders (NYI) | 5000 | 2500 | 35 | 15 | 70583 | 43003 | 78.43% | 95.56% | 18 | 6310 - 84.14% | 257,890$ | 4,642,021$ | 7500 | 100 | 2,540,416$ | 2,540,416$ | 1,705,826$ | 0$ | 1,231,075$ | 0 | 0 | 4,642,021$ | 95 | 18,336$ | 1,686,912$ |
| 5 |  Calgary Wranglers (CAL) | 5000 | 2500 | 35 | 15 | 70019 | 42332 | 77.80% | 94.07% | 18 | 6242 - 83.22% | 255,423$ | 4,597,609$ | 7500 | 100 | 1,978,166$ | 1,978,166$ | 1,584,903$ | 0$ | 1,007,477$ | 0 | 0 | 4,597,609$ | 95 | 16,419$ | 1,510,548$ |
| 6 |  Charlotte Checkers (FLA) | 5000 | 2500 | 35 | 15 | 75096 | 45612 | 79.05% | 96.03% | 17 | 6353 - 84.71% | 259,773$ | 4,935,684$ | 7500 | 100 | 2,440,056$ | 2,440,056$ | 1,895,586$ | 0$ | 1,297,678$ | 0 | 0 | 4,416,138$ | 95 | 19,074$ | 1,754,808$ |
| 7 |  Chicago Wolves (CAR) | 5000 | 2500 | 35 | 15 | 71703 | 42596 | 79.67% | 94.66% | 18 | 6350 - 84.67% | 260,629$ | 4,691,329$ | 7500 | 100 | 1,745,000$ | 1,745,000$ | 1,827,738$ | 0$ | 796,143$ | 0 | 0 | 4,691,329$ | 95 | 19,868$ | 1,827,856$ |
| 8 |  Cleveland Monsters (CLB) | 5000 | 2500 | 35 | 15 | 73251 | 42537 | 81.39% | 94.53% | 18 | 6433 - 85.77% | 265,041$ | 4,770,741$ | 7500 | 100 | 1,995,583$ | 1,995,583$ | 1,624,578$ | 0$ | 984,863$ | 0 | 0 | 4,770,741$ | 95 | 15,453$ | 1,421,676$ |
| 9 |  Coachella Valley Firebirds (SEA) | 5000 | 2500 | 35 | 15 | 75712 | 45091 | 79.70% | 94.93% | 17 | 6358 - 84.77% | 260,851$ | 4,956,166$ | 7500 | 100 | 1,953,805$ | 1,953,805$ | 1,914,443$ | 0$ | 990,696$ | 0 | 0 | 4,434,464$ | 95 | 19,861$ | 1,827,212$ |
| 10 |  Colorado Eagles (COL) | 5000 | 2500 | 35 | 15 | 75754 | 45203 | 79.74% | 95.16% | 17 | 6366 - 84.88% | 261,098$ | 4,960,857$ | 7500 | 100 | 2,205,833$ | 2,205,833$ | 1,776,320$ | 0$ | 1,160,467$ | 0 | 0 | 4,438,662$ | 95 | 18,020$ | 1,657,840$ |
| 11 |  Grand Rapids Griffins (DET) | 5000 | 2500 | 36 | 16 | 67900 | 32273 | 75.44% | 71.72% | 18 | 5565 - 74.20% | 246,689$ | 4,440,401$ | 7500 | 100 | 2,245,166$ | 2,245,166$ | 1,553,759$ | 0$ | 1,063,618$ | 0 | 0 | 4,440,401$ | 95 | 16,932$ | 1,557,744$ |
| 12 |  Hartford Wolf Pack (NYR) | 5000 | 2500 | 36 | 16 | 70313 | 33279 | 78.13% | 73.95% | 18 | 5755 - 76.73% | 253,609$ | 4,564,961$ | 7500 | 100 | 1,842,534$ | 1,842,534$ | 1,681,461$ | 0$ | 937,277$ | 0 | 0 | 4,564,961$ | 95 | 17,421$ | 1,602,732$ |
| 13 |  Henderson Silver Knights (VEG) | 5000 | 2500 | 35 | 15 | 74519 | 44836 | 78.44% | 94.39% | 17 | 6282 - 83.76% | 257,276$ | 4,888,251$ | 7500 | 100 | 1,997,926$ | 1,997,926$ | 1,609,577$ | 0$ | 1,057,841$ | 0 | 0 | 4,373,698$ | 95 | 16,259$ | 1,495,828$ |
| 14 |  Hershey Bears (WAS) | 5000 | 2500 | 35 | 15 | 70956 | 41912 | 78.84% | 93.14% | 18 | 6270 - 83.61% | 257,616$ | 4,637,089$ | 7500 | 100 | 2,203,584$ | 2,203,584$ | 1,795,629$ | 0$ | 1,128,463$ | 0 | 0 | 4,637,089$ | 95 | 18,537$ | 1,705,404$ |
| 15 |  Iowa Wild (MIN) | 5000 | 2500 | 35 | 15 | 70814 | 42100 | 78.68% | 93.56% | 18 | 6273 - 83.64% | 257,438$ | 4,633,885$ | 7500 | 101 | 2,064,917$ | 2,064,917$ | 1,898,532$ | 0$ | 1,051,682$ | 0 | 0 | 4,633,885$ | 95 | 19,656$ | 1,808,352$ |
| 16 |  Laval Rocket (MON) | 5000 | 2500 | 35 | 15 | 76126 | 44760 | 80.13% | 94.23% | 17 | 6362 - 84.83% | 261,598$ | 4,970,357$ | 7500 | 100 | 1,840,417$ | 1,840,417$ | 1,427,091$ | 0$ | 965,177$ | 0 | 0 | 4,447,162$ | 95 | 14,500$ | 1,334,000$ |
| 17 |  Lehigh Valley Phantoms (PHI) | 5000 | 2500 | 35 | 15 | 69745 | 42720 | 77.49% | 94.93% | 18 | 6248 - 83.31% | 255,111$ | 4,591,992$ | 7500 | 100 | 2,011,417$ | 2,011,417$ | 1,718,784$ | 0$ | 1,051,570$ | 0 | 0 | 4,591,992$ | 95 | 17,521$ | 1,611,932$ |
| 18 |  Manitoba Moose (WIN) | 5000 | 2500 | 35 | 15 | 69595 | 42035 | 77.33% | 93.41% | 18 | 6202 - 82.69% | 253,826$ | 4,568,861$ | 7500 | 100 | 1,723,522$ | 1,723,522$ | 1,343,539$ | 0$ | 927,797$ | 0 | 0 | 4,568,861$ | 95 | 13,405$ | 1,233,260$ |
| 19 |  Milwaukee Admirals (NAS) | 5000 | 2500 | 35 | 15 | 70586 | 43638 | 78.43% | 96.97% | 18 | 6346 - 84.61% | 258,687$ | 4,656,370$ | 7500 | 100 | 2,521,917$ | 2,521,917$ | 2,286,101$ | 0$ | 1,259,647$ | 0 | 0 | 4,656,370$ | 95 | 23,925$ | 2,201,100$ |
| 20 |  Ontario Reign (LAK) | 5000 | 2500 | 35 | 15 | 76027 | 45578 | 80.03% | 95.95% | 17 | 6400 - 85.34% | 262,288$ | 4,983,475$ | 7500 | 100 | 2,136,666$ | 2,136,666$ | 1,579,265$ | 0$ | 1,091,647$ | 0 | 0 | 4,458,899$ | 95 | 16,332$ | 1,502,544$ |
| 21 |  Providence Bruins (BOS) | 5000 | 2500 | 35 | 15 | 71356 | 41858 | 79.28% | 93.02% | 18 | 6290 - 83.86% | 258,708$ | 4,656,744$ | 7500 | 100 | 1,914,055$ | 1,914,055$ | 1,693,470$ | 0$ | 1,013,412$ | 0 | 0 | 4,656,744$ | 95 | 17,138$ | 1,576,696$ |
| 22 |  Rochester Americans (BUF) | 5000 | 2500 | 35 | 15 | 71949 | 42579 | 79.94% | 94.62% | 18 | 6363 - 84.84% | 261,321$ | 4,703,780$ | 7500 | 100 | 1,898,000$ | 1,898,000$ | 1,484,810$ | 0$ | 1,009,249$ | 0 | 0 | 4,703,780$ | 95 | 14,381$ | 1,323,052$ |
| 23 |  Rockford IceHogs (CHI) | 5000 | 2500 | 37 | 18 | 71042 | 32353 | 74.78% | 68.11% | 17 | 5442 - 72.56% | 251,803$ | 4,784,253$ | 7500 | 100 | 2,292,000$ | 2,292,000$ | 1,698,800$ | 0$ | 1,082,947$ | 0 | 0 | 4,280,647$ | 95 | 18,476$ | 1,699,792$ |
| 24 |  San Diego Gulls (ANA) | 5000 | 2500 | 35 | 15 | 70566 | 41919 | 78.41% | 93.15% | 18 | 6249 - 83.32% | 256,495$ | 4,616,906$ | 7500 | 100 | 2,277,334$ | 2,277,334$ | 1,576,421$ | 0$ | 1,137,593$ | 0 | 0 | 4,616,906$ | 95 | 16,573$ | 1,524,716$ |
| 25 |  San Jose Barracuda (SJS) | 5000 | 2500 | 35 | 15 | 71955 | 42595 | 79.95% | 94.66% | 18 | 6364 - 84.85% | 261,358$ | 4,704,450$ | 7500 | 100 | 2,342,417$ | 2,342,417$ | 1,671,747$ | 0$ | 1,107,182$ | 0 | 0 | 4,704,450$ | 95 | 18,214$ | 1,675,688$ |
| 26 |  Springfield Thunderbirds (STL) | 5000 | 2500 | 34 | 14 | 87182 | 42332 | 96.87% | 94.07% | 18 | 7195 - 95.94% | 294,427$ | 5,299,686$ | 7500 | 100 | 2,166,084$ | 2,166,084$ | 1,820,781$ | 0$ | 1,107,423$ | 0 | 0 | 5,299,686$ | 95 | 18,815$ | 1,730,980$ |
| 27 |  Syracuse Crunch (TBL) | 5000 | 2500 | 35 | 15 | 72373 | 42638 | 80.41% | 94.75% | 18 | 6390 - 85.19% | 262,623$ | 4,727,211$ | 7500 | 100 | 2,380,666$ | 2,380,666$ | 1,600,093$ | 0$ | 1,189,492$ | 0 | 0 | 4,727,211$ | 95 | 16,829$ | 1,548,268$ |
| 28 |  Texas Stars (DAL) | 5000 | 2500 | 35 | 15 | 70412 | 42318 | 78.24% | 94.04% | 18 | 6263 - 83.50% | 256,544$ | 4,617,793$ | 7500 | 100 | 1,950,800$ | 1,950,800$ | 1,601,539$ | 0$ | 985,686$ | 0 | 0 | 4,617,793$ | 95 | 16,671$ | 1,533,732$ |
| 29 |  Toronto Marlies (TOR) | 5000 | 2500 | 35 | 15 | 69704 | 41907 | 77.45% | 93.13% | 18 | 6201 - 82.67% | 253,983$ | 4,571,686$ | 7500 | 100 | 2,382,167$ | 2,382,167$ | 1,820,504$ | 0$ | 1,186,685$ | 0 | 0 | 4,571,686$ | 95 | 19,138$ | 1,760,696$ |
| 30 |  Tucson Roadrunners (UHC) | 5000 | 2500 | 35 | 15 | 73271 | 43661 | 81.41% | 97.02% | 18 | 6496 - 86.62% | 266,495$ | 4,796,906$ | 7500 | 100 | 2,194,778$ | 2,194,778$ | 1,673,999$ | 0$ | 1,076,091$ | 0 | 0 | 4,796,906$ | 95 | 17,777$ | 1,635,484$ |
| 31 |  Utica Comets (NJD) | 5000 | 2500 | 35 | 15 | 76044 | 44391 | 80.05% | 93.45% | 17 | 6339 - 84.52% | 260,939$ | 4,957,835$ | 7500 | 100 | 2,059,834$ | 2,059,834$ | 1,494,452$ | 0$ | 1,053,093$ | 0 | 0 | 4,435,958$ | 95 | 15,449$ | 1,421,308$ |
| 32 |  Wilkes-Barre/Scranton Penguins (PIT) | 5000 | 2500 | 35 | 15 | 71518 | 42396 | 79.46% | 94.21% | 18 | 6329 - 84.38% | 259,845$ | 4,677,214$ | 7500 | 100 | 1,815,056$ | 1,815,056$ | 1,707,452$ | 0$ | 1,063,363$ | 0 | 0 | 4,677,214$ | 95 | 16,244$ | 1,494,448$ |