| 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 | 53804 | 30317 | 82.78% | 93.28% | 23 | 6471 - 86.28% | 267,959$ | 3,483,463$ | 7500 | 100 | 2,010,083$ | 2,010,083$ | 1,069,556$ | 10,203$ | 689,852$ | 0 | 0 | 6,163,050$ | 128 | 15,787$ | 2,036,523$ |
| 2 |  Bakersfield Condors (EDM) | 5000 | 2500 | 30 | 15 | 67372 | 33721 | 96.25% | 96.35% | 22 | 7221 - 96.28% | 274,021$ | 3,836,288$ | 7500 | 100 | 1,663,466$ | 1,663,466$ | 987,436$ | 8,444$ | 566,332$ | 0 | 0 | 6,028,453$ | 128 | 14,637$ | 1,888,173$ |
| 3 |  Belleville Senators (OTT) | 5000 | 2500 | 35 | 15 | 56723 | 32746 | 81.03% | 93.56% | 22 | 6391 - 85.21% | 263,570$ | 3,689,978$ | 7500 | 100 | 2,094,500$ | 2,094,500$ | 1,139,201$ | 10,632$ | 776,761$ | 0 | 0 | 5,798,537$ | 128 | 15,962$ | 2,059,098$ |
| 4 |  Bridgeport Islanders (NYI) | 5000 | 2500 | 35 | 15 | 56335 | 32762 | 80.48% | 93.61% | 22 | 6364 - 84.85% | 262,150$ | 3,670,101$ | 7500 | 100 | 2,132,883$ | 2,132,883$ | 1,099,064$ | 10,827$ | 753,891$ | 0 | 0 | 5,767,302$ | 128 | 15,903$ | 2,051,487$ |
| 5 |  Calgary Wranglers (CAL) | 5000 | 2500 | 35 | 15 | 56249 | 33340 | 80.36% | 95.26% | 22 | 6399 - 85.32% | 262,752$ | 3,678,534$ | 7500 | 100 | 2,248,833$ | 2,248,833$ | 1,079,487$ | 11,415$ | 768,795$ | 0 | 0 | 5,780,553$ | 128 | 15,984$ | 2,061,936$ |
| 6 |  Charlotte Checkers (FLA) | 5000 | 2500 | 35 | 15 | 56857 | 33250 | 81.22% | 95.00% | 22 | 6436 - 85.82% | 264,874$ | 3,708,230$ | 7500 | 100 | 2,665,167$ | 2,665,167$ | 1,321,078$ | 13,529$ | 918,982$ | 0 | 0 | 5,827,219$ | 128 | 19,442$ | 2,508,018$ |
| 7 |  Chicago Wolves (CAR) | 5000 | 2500 | 35 | 15 | 56832 | 33455 | 81.19% | 95.59% | 22 | 6449 - 85.99% | 265,108$ | 3,711,507$ | 7500 | 100 | 1,895,917$ | 1,895,917$ | 910,483$ | 9,624$ | 634,362$ | 0 | 0 | 5,832,368$ | 128 | 13,685$ | 1,765,365$ |
| 8 |  Cleveland Monsters (CLB) | 5000 | 2500 | 35 | 15 | 55320 | 32646 | 79.03% | 93.27% | 22 | 6283 - 83.78% | 258,184$ | 3,614,575$ | 7500 | 100 | 1,779,500$ | 1,779,500$ | 1,066,444$ | 9,033$ | 614,244$ | 0 | 0 | 5,680,046$ | 128 | 15,683$ | 2,023,107$ |
| 9 |  Coachella Valley Firebirds (SEA) | 5000 | 2500 | 35 | 15 | 54248 | 33225 | 77.50% | 94.93% | 22 | 6248 - 83.31% | 255,115$ | 3,571,614$ | 7500 | 100 | 1,892,611$ | 1,892,611$ | 1,023,328$ | 9,607$ | 643,616$ | 0 | 0 | 5,612,536$ | 128 | 15,191$ | 1,959,639$ |
| 10 |  Colorado Eagles (COL) | 5000 | 2500 | 35 | 15 | 51853 | 30489 | 79.77% | 93.81% | 23 | 6334 - 84.45% | 260,428$ | 3,385,562$ | 7500 | 100 | 1,738,083$ | 1,738,083$ | 1,125,177$ | 8,823$ | 710,989$ | 0 | 0 | 5,989,840$ | 128 | 14,914$ | 1,923,906$ |
| 11 |  Grand Rapids Griffins (DET) | 5000 | 2500 | 35 | 15 | 56543 | 31420 | 80.78% | 89.77% | 22 | 6283 - 83.77% | 263,803$ | 3,693,246$ | 7500 | 100 | 2,024,916$ | 2,024,916$ | 1,044,140$ | 10,279$ | 698,972$ | 0 | 0 | 5,803,672$ | 128 | 15,355$ | 1,980,795$ |
| 12 |  Hartford Wolf Pack (NYR) | 5000 | 2500 | 35 | 15 | 55307 | 33749 | 79.01% | 96.43% | 22 | 6361 - 84.82% | 259,896$ | 3,638,550$ | 7500 | 100 | 2,121,651$ | 2,121,651$ | 1,076,740$ | 10,770$ | 731,570$ | 0 | 0 | 5,717,721$ | 128 | 15,846$ | 2,044,134$ |
| 13 |  Henderson Silver Knights (VEG) | 5000 | 2500 | 35 | 15 | 54563 | 33375 | 77.95% | 95.36% | 22 | 6281 - 83.75% | 256,528$ | 3,591,391$ | 7500 | 100 | 2,096,886$ | 2,096,886$ | 1,137,980$ | 10,644$ | 723,792$ | 0 | 0 | 5,643,614$ | 128 | 16,735$ | 2,158,815$ |
| 14 |  Hershey Bears (WAS) | 5000 | 2500 | 35 | 15 | 55494 | 33026 | 79.28% | 94.36% | 22 | 6323 - 84.30% | 259,439$ | 3,632,144$ | 7500 | 100 | 2,103,750$ | 2,103,750$ | 1,192,329$ | 10,679$ | 743,597$ | 0 | 0 | 5,707,655$ | 128 | 17,278$ | 2,228,862$ |
| 15 |  Iowa Wild (MIN) | 5000 | 2500 | 35 | 15 | 56363 | 32781 | 80.52% | 93.66% | 22 | 6367 - 84.90% | 262,285$ | 3,671,986$ | 7500 | 100 | 2,137,833$ | 2,137,833$ | 1,270,683$ | 10,852$ | 701,153$ | 0 | 0 | 5,770,264$ | 128 | 19,228$ | 2,480,412$ |
| 16 |  Laval Rocket (MON) | 5000 | 2500 | 35 | 15 | 55499 | 32256 | 79.28% | 92.16% | 22 | 6268 - 83.58% | 258,228$ | 3,615,194$ | 7500 | 100 | 1,923,167$ | 1,923,167$ | 981,685$ | 9,762$ | 619,250$ | 0 | 0 | 5,681,019$ | 128 | 15,092$ | 1,946,868$ |
| 17 |  Lehigh Valley Phantoms (PHI) | 5000 | 2500 | 35 | 15 | 57285 | 32903 | 81.84% | 94.01% | 22 | 6442 - 85.89% | 265,914$ | 3,722,794$ | 7500 | 100 | 2,364,917$ | 2,364,917$ | 1,089,426$ | 12,005$ | 796,045$ | 0 | 0 | 5,850,105$ | 128 | 16,319$ | 2,105,151$ |
| 18 |  Manitoba Moose (WIN) | 5000 | 2500 | 35 | 15 | 52606 | 30450 | 80.93% | 93.69% | 23 | 6389 - 85.19% | 263,382$ | 3,423,960$ | 7500 | 100 | 2,290,273$ | 2,290,273$ | 1,199,644$ | 11,626$ | 832,018$ | 0 | 0 | 6,057,775$ | 128 | 17,032$ | 2,197,128$ |
| 19 |  Milwaukee Admirals (NAS) | 5000 | 2500 | 35 | 15 | 52727 | 31290 | 81.12% | 96.28% | 23 | 6463 - 86.17% | 265,311$ | 3,449,044$ | 7500 | 100 | 2,394,000$ | 2,394,000$ | 1,226,677$ | 12,152$ | 812,421$ | 0 | 0 | 6,102,155$ | 128 | 18,244$ | 2,353,476$ |
| 20 |  Ontario Reign (LAK) | 5000 | 2500 | 35 | 15 | 52754 | 31046 | 81.16% | 95.53% | 23 | 6446 - 85.95% | 265,000$ | 3,445,001$ | 7500 | 100 | 2,213,916$ | 2,213,916$ | 1,068,454$ | 11,238$ | 740,551$ | 0 | 0 | 6,095,002$ | 128 | 16,060$ | 2,071,740$ |
| 21 |  Providence Bruins (BOS) | 5000 | 2500 | 35 | 15 | 54682 | 32865 | 78.12% | 93.90% | 22 | 6253 - 83.38% | 256,157$ | 3,586,198$ | 7500 | 100 | 2,269,750$ | 2,269,750$ | 1,109,427$ | 11,522$ | 781,526$ | 0 | 0 | 5,635,454$ | 128 | 16,344$ | 2,108,376$ |
| 22 |  Rochester Americans (BUF) | 5000 | 2500 | 35 | 15 | 55168 | 33664 | 78.81% | 96.18% | 22 | 6345 - 84.60% | 259,243$ | 3,629,401$ | 7500 | 100 | 2,304,576$ | 2,304,576$ | 1,147,439$ | 11,698$ | 772,895$ | 0 | 0 | 5,703,344$ | 128 | 17,206$ | 2,219,574$ |
| 23 |  Rockford IceHogs (CHI) | 5000 | 2500 | 37 | 18 | 49074 | 21540 | 75.50% | 66.28% | 23 | 5432 - 72.42% | 252,550$ | 3,283,154$ | 7500 | 100 | 2,319,658$ | 2,319,658$ | 1,214,888$ | 11,775$ | 800,700$ | 0 | 0 | 5,808,657$ | 128 | 17,866$ | 2,304,714$ |
| 24 |  San Diego Gulls (ANA) | 5000 | 2500 | 35 | 15 | 55963 | 32638 | 79.95% | 93.25% | 22 | 6329 - 84.38% | 260,566$ | 3,647,929$ | 7500 | 100 | 2,351,414$ | 2,351,414$ | 1,061,658$ | 11,936$ | 820,036$ | 0 | 0 | 5,732,460$ | 128 | 15,489$ | 1,998,081$ |
| 25 |  San Jose Barracuda (SJS) | 5000 | 2500 | 35 | 15 | 53695 | 30830 | 82.61% | 94.86% | 23 | 6502 - 86.69% | 268,403$ | 3,489,244$ | 7500 | 100 | 2,001,333$ | 2,001,333$ | 1,069,126$ | 10,159$ | 689,414$ | 0 | 0 | 6,173,278$ | 128 | 15,743$ | 2,030,847$ |
| 26 |  Springfield Thunderbirds (STL) | 5000 | 2500 | 35 | 15 | 55924 | 32827 | 79.89% | 93.79% | 22 | 6339 - 84.52% | 260,723$ | 3,650,121$ | 7500 | 100 | 2,072,167$ | 2,072,167$ | 1,081,518$ | 10,519$ | 701,840$ | 0 | 0 | 5,735,904$ | 128 | 16,102$ | 2,077,158$ |
| 27 |  Syracuse Crunch (TBL) | 5000 | 2500 | 35 | 15 | 51836 | 30910 | 79.75% | 95.11% | 23 | 6365 - 84.87% | 261,084$ | 3,394,086$ | 7500 | 100 | 2,111,500$ | 2,111,500$ | 1,004,972$ | 10,718$ | 728,824$ | 0 | 0 | 6,004,921$ | 128 | 14,779$ | 1,906,491$ |
| 28 |  Texas Stars (DAL) | 5000 | 2500 | 35 | 15 | 52666 | 29971 | 81.02% | 92.22% | 23 | 6357 - 84.76% | 262,991$ | 3,418,883$ | 7500 | 100 | 2,065,651$ | 2,065,651$ | 1,124,266$ | 10,486$ | 710,078$ | 0 | 0 | 6,048,793$ | 128 | 16,577$ | 2,138,433$ |
| 29 |  Toronto Marlies (TOR) | 5000 | 2500 | 35 | 15 | 52741 | 30369 | 81.14% | 93.44% | 23 | 6393 - 85.24% | 263,784$ | 3,429,189$ | 7500 | 100 | 1,883,167$ | 1,883,167$ | 952,106$ | 9,559$ | 624,174$ | 0 | 0 | 6,067,027$ | 128 | 14,382$ | 1,855,278$ |
| 30 |  Tucson Roadrunners (UHC) | 5000 | 2500 | 35 | 15 | 52222 | 30518 | 80.34% | 93.90% | 23 | 6365 - 84.86% | 261,958$ | 3,405,455$ | 7500 | 100 | 1,866,333$ | 1,866,333$ | 1,071,231$ | 9,474$ | 669,084$ | 0 | 0 | 6,025,036$ | 128 | 15,387$ | 1,984,923$ |
| 31 |  Utica Comets (NJD) | 5000 | 2500 | 35 | 15 | 53681 | 30798 | 82.59% | 94.76% | 23 | 6498 - 86.65% | 268,292$ | 3,487,801$ | 7500 | 100 | 1,941,445$ | 1,941,445$ | 1,120,572$ | 9,855$ | 670,140$ | 0 | 0 | 6,170,725$ | 128 | 16,479$ | 2,125,791$ |
| 32 |  Wilkes-Barre/Scranton Penguins (PIT) | 5000 | 2500 | 35 | 15 | 56674 | 33569 | 80.96% | 95.91% | 22 | 6446 - 85.95% | 264,701$ | 3,705,815$ | 7500 | 100 | 2,396,834$ | 2,396,834$ | 1,243,132$ | 12,167$ | 809,931$ | 0 | 0 | 5,823,424$ | 128 | 18,537$ | 2,391,273$ |