| 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 (CAL) | 2000 | 1000 | 35 | 15 | 48183 | 24235 | 75.29% | 75.73% | 7 | 2263 - 75.44% | 64,060$ | 2,049,930$ | 3000 | 100 | 1,849,500$ | 0$ | 1,578,346$ | 0$ | 1,578,346$ | 0 | 0 | 448,422$ | 31 | 10,218$ | 316,758$ |
| 2 |  Athens Rock Lobsters (FLA) | 2000 | 1000 | 35 | 15 | 48245 | 24319 | 75.38% | 76.00% | 7 | 2268 - 75.59% | 64,168$ | 2,053,360$ | 3000 | 100 | 3,139,876$ | 0$ | 1,836,371$ | 0$ | 1,836,371$ | 0 | 0 | 449,172$ | 31 | 17,347$ | 537,757$ |
| 3 |  Bakersfield Condors (EDM) | 2000 | 1000 | 36 | 15 | 47446 | 24241 | 74.13% | 75.75% | 7 | 2240 - 74.67% | 64,811$ | 2,073,936$ | 3000 | 100 | 2,617,100$ | 0$ | 2,238,305$ | 0$ | 2,238,305$ | 0 | 0 | 453,674$ | 31 | 14,459$ | 448,229$ |
| 4 |  Bridgeport Islanders (NYI) | 2250 | 1250 | 35 | 16 | 55492 | 28265 | 77.07% | 70.66% | 7 | 2617 - 74.78% | 74,827$ | 2,394,460$ | 3500 | 100 | 1,585,500$ | 0$ | 1,392,660$ | 0$ | 1,392,660$ | 0 | 0 | 523,788$ | 31 | 8,760$ | 271,560$ |
| 5 |  Cleveland Monsters (CBJ) | 2000 | 1000 | 32 | 11 | 55080 | 27363 | 86.06% | 85.51% | 7 | 2576 - 85.88% | 67,840$ | 2,170,882$ | 3000 | 100 | 1,886,500$ | 0$ | 1,636,979$ | 0$ | 1,636,979$ | 0 | 0 | 474,880$ | 31 | 10,423$ | 323,113$ |
| 6 |  Coachella Valley Firebirds (SEA) | 2000 | 1000 | 31 | 11 | 61767 | 30820 | 96.51% | 96.31% | 7 | 2893 - 96.44% | 69,976$ | 2,239,244$ | 3000 | 100 | 2,361,500$ | 0$ | 2,040,466$ | 0$ | 2,040,466$ | 0 | 0 | 489,835$ | 31 | 13,047$ | 404,457$ |
| 7 |  Colorado Eagles (COL) | 2000 | 1000 | 35 | 15 | 48910 | 23952 | 76.42% | 74.85% | 7 | 2277 - 75.90% | 64,723$ | 2,071,130$ | 3000 | 100 | 1,866,000$ | 0$ | 1,527,058$ | 0$ | 1,527,058$ | 0 | 0 | 453,060$ | 31 | 10,309$ | 319,579$ |
| 8 |  Grand Rapids Griffins (DET) | 2000 | 1000 | 35 | 15 | 48849 | 24187 | 76.33% | 75.58% | 7 | 2282 - 76.08% | 64,766$ | 2,072,520$ | 3000 | 100 | 2,957,400$ | 0$ | 4,809,425$ | 0$ | 4,809,425$ | 0 | 0 | 453,364$ | 31 | 16,339$ | 506,509$ |
| 9 |  Greenville Swamp Rabbits (CAR) | 2000 | 1000 | 35 | 15 | 49686 | 23806 | 77.63% | 74.39% | 7 | 2297 - 76.55% | 65,503$ | 2,096,100$ | 3000 | 100 | 3,474,800$ | 0$ | 1,476,316$ | 0$ | 1,476,316$ | 0 | 0 | 458,522$ | 31 | 19,198$ | 595,138$ |
| 10 |  Henderson Silver Knights (VGK) | 2000 | 1000 | 35 | 15 | 48030 | 23812 | 75.05% | 74.41% | 7 | 2245 - 74.84% | 63,695$ | 2,038,230$ | 3000 | 100 | 3,277,505$ | 0$ | 1,757,198$ | 0$ | 1,757,198$ | 0 | 0 | 445,863$ | 31 | 18,108$ | 561,348$ |
| 11 |  Iowa Heartlanders (NYR) | 2000 | 1000 | 35 | 15 | 49175 | 23947 | 76.84% | 74.83% | 7 | 2285 - 76.17% | 65,010$ | 2,080,330$ | 3000 | 100 | 1,472,500$ | 0$ | 1,245,306$ | 0$ | 1,245,306$ | 0 | 0 | 455,072$ | 31 | 8,135$ | 252,185$ |
| 12 |  Laval Rocket (QUE) | 2000 | 1000 | 35 | 15 | 48743 | 23757 | 76.16% | 74.24% | 7 | 2266 - 75.52% | 64,449$ | 2,062,360$ | 3000 | 100 | 4,013,057$ | 0$ | 1,603,530$ | 0$ | 1,603,530$ | 0 | 0 | 451,141$ | 31 | 22,172$ | 687,332$ |
| 13 |  Lehigh Valley Phantoms (PHI) | 2000 | 1000 | 35 | 15 | 49454 | 24026 | 77.27% | 75.08% | 7 | 2296 - 76.54% | 65,353$ | 2,091,280$ | 3000 | 100 | 1,989,200$ | 0$ | 1,312,098$ | 0$ | 1,312,098$ | 0 | 0 | 457,468$ | 31 | 10,990$ | 340,690$ |
| 14 |  Macon Whoopee (STL) | 2000 | 1000 | 35 | 15 | 48432 | 23531 | 75.68% | 73.53% | 7 | 2249 - 74.96% | 64,003$ | 2,048,085$ | 3000 | 100 | 1,720,096$ | 0$ | 1,313,789$ | 0$ | 1,313,789$ | 0 | 0 | 448,019$ | 31 | 9,503$ | 294,593$ |
| 15 |  Orlando Solar Bears (TBL) | 2000 | 1000 | 35 | 15 | 49552 | 23586 | 77.43% | 73.71% | 7 | 2286 - 76.19% | 65,253$ | 2,088,110$ | 3000 | 100 | 2,633,700$ | 0$ | 2,255,153$ | 0$ | 2,255,153$ | 0 | 0 | 456,774$ | 31 | 14,551$ | 451,081$ |
| 16 |  Pee Dee Pride (MIN) | 2000 | 1000 | 32 | 16 | 61172 | 29341 | 95.58% | 91.69% | 7 | 2829 - 94.28% | 72,199$ | 2,310,374$ | 3000 | 100 | 2,844,241$ | 0$ | 2,770,585$ | 0$ | 2,770,585$ | 0 | 0 | 505,394$ | 31 | 15,714$ | 487,134$ |
| 17 |  Providence Bruins (BOS) | 2000 | 1000 | 34 | 15 | 54965 | 28979 | 85.88% | 90.56% | 7 | 2623 - 87.44% | 71,867$ | 2,299,737$ | 3000 | 100 | 1,692,700$ | 0$ | 1,397,596$ | 0$ | 1,397,596$ | 0 | 0 | 503,067$ | 31 | 9,352$ | 289,912$ |
| 18 |  Reading Royals (LAK) | 2000 | 1000 | 32 | 13 | 55985 | 28677 | 87.48% | 89.62% | 7 | 2646 - 88.19% | 72,721$ | 2,327,086$ | 3000 | 100 | 3,541,143$ | 0$ | 2,909,066$ | 0$ | 2,909,066$ | 0 | 0 | 509,050$ | 31 | 19,564$ | 606,484$ |
| 19 |  Rochester Americans (PIT) | 2000 | 1000 | 35 | 15 | 49498 | 23961 | 77.34% | 74.88% | 7 | 2296 - 76.52% | 65,370$ | 2,091,845$ | 3000 | 100 | 1,696,500$ | 0$ | 1,405,950$ | 0$ | 1,405,950$ | 0 | 0 | 457,591$ | 31 | 9,373$ | 290,563$ |
| 20 |  Rockford IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 49031 | 23562 | 76.61% | 73.63% | 7 | 2269 - 75.62% | 64,672$ | 2,069,515$ | 3000 | 100 | 2,621,000$ | 0$ | 2,172,150$ | 0$ | 2,172,150$ | 0 | 0 | 452,706$ | 31 | 14,481$ | 448,911$ |
| 21 |  Savannah Ghost Pirates (TOR) | 2000 | 1000 | 35 | 15 | 48502 | 23962 | 75.78% | 74.88% | 7 | 2265 - 75.48% | 64,281$ | 2,057,000$ | 3000 | 100 | 7,780,200$ | 0$ | 2,284,355$ | 0$ | 2,284,355$ | 0 | 0 | 449,969$ | 31 | 42,985$ | 1,332,535$ |
| 22 |  Trois Rivieres Lions (MTL) | 2000 | 1000 | 32 | 13 | 60805 | 30178 | 95.01% | 94.31% | 7 | 2843 - 94.77% | 73,065$ | 2,338,074$ | 3000 | 100 | 2,436,900$ | 0$ | 1,833,281$ | 0$ | 1,833,281$ | 0 | 0 | 511,454$ | 31 | 13,464$ | 417,384$ |
| 23 |  Utica Comets (NJD) | 2000 | 1000 | 35 | 15 | 49732 | 24090 | 77.71% | 75.28% | 7 | 2307 - 76.90% | 65,687$ | 2,101,970$ | 3000 | 100 | 1,723,930$ | 0$ | 1,313,439$ | 0$ | 1,313,439$ | 0 | 0 | 459,806$ | 31 | 9,524$ | 295,244$ |
| 24 |  Wheeling Nailers (HAM) | 2000 | 1000 | 35 | 15 | 47794 | 23496 | 74.68% | 73.43% | 7 | 2228 - 74.26% | 63,288$ | 2,025,230$ | 3000 | 100 | 2,146,900$ | 0$ | 1,765,433$ | 0$ | 1,765,433$ | 0 | 0 | 443,019$ | 31 | 11,861$ | 367,691$ |