| 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 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Level1 | Level2 | Home Games Left | Average Attendance - % | Average Income per Game | Year to Date Revenue | Arena Capacity | Team Popularity | Players Total Salaries | Players Total Average Salaries | 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 | BANGOR PUPPIES (BEA) | 2000 | 1000 | 35 | 15 | 15138 | 8933 | 84.10% | 99.26% | 33 | 2675 - 89.15% | 73,758$ | 663,825$ | 3000 | 100 | 2,529,734$ | 136,000$ | 794,353$ | 2,529,734$ | 556,888$ | 35 | 0 | 2,434,025$ | 108 | 24,867$ | 2,809,971$ |
| 2 | BROOKLYN GRINDERS (BRK) | 2000 | 1000 | 30 | 11 | 19714 | 9989 | 98.57% | 99.89% | 32 | 2970 - 99.01% | 70,130$ | 701,299$ | 3000 | 100 | 1,740,500$ | 116,000$ | 561,844$ | 1,740,500$ | 384,524$ | 29 | 0 | 2,244,157$ | 108 | 17,723$ | 2,002,699$ |
| 3 | CALGARY WRANGLERS (CAL) | 3000 | 2000 | 32 | 15 | 29519 | 19742 | 98.40% | 98.71% | 32 | 4926 - 98.52% | 124,074$ | 1,240,738$ | 5000 | 100 | 1,954,500$ | 128,000$ | 742,007$ | 1,954,500$ | 428,826$ | 33 | 0 | 3,970,362$ | 108 | 23,266$ | 2,629,058$ |
| 4 | CAPE BRETON LEPRECHAUNS (CEL) | 2000 | 1000 | 35 | 15 | 15905 | 9831 | 79.53% | 98.31% | 32 | 2574 - 85.79% | 70,414$ | 704,140$ | 3000 | 100 | 1,556,375$ | 108,000$ | 543,433$ | 1,556,375$ | 345,338$ | 27 | 0 | 2,253,248$ | 108 | 16,924$ | 1,912,412$ |
| 5 | CAPE FEAR WILDCATS (PRO) | 2000 | 1000 | 35 | 15 | 14804 | 8851 | 82.24% | 98.34% | 33 | 2628 - 87.61% | 72,323$ | 650,905$ | 3000 | 100 | 2,328,990$ | 140,000$ | 778,816$ | 2,328,990$ | 513,984$ | 35 | 0 | 2,386,652$ | 108 | 24,338$ | 2,750,194$ |
| 6 | CHICAGO UNDERTAKERS (CHI) | 3000 | 2000 | 50 | 30 | 16885 | 8958 | 56.28% | 44.79% | 32 | 2584 - 51.69% | 111,299$ | 1,112,990$ | 5000 | 100 | 1,748,500$ | 167,000$ | 593,476$ | 1,748,500$ | 372,792$ | 30 | 0 | 3,561,568$ | 108 | 18,955$ | 2,141,915$ |
| 7 | COLORADO CUBS (WOL) | 2000 | 1000 | 35 | 15 | 16168 | 9834 | 80.84% | 98.34% | 32 | 2600 - 86.67% | 71,339$ | 713,390$ | 3000 | 100 | 1,907,350$ | 128,000$ | 751,894$ | 1,907,350$ | 399,894$ | 32 | 0 | 2,282,848$ | 108 | 24,154$ | 2,729,402$ |
| 8 | COQUITLAM EXPRESS (COQ) | 2000 | 1000 | 40 | 20 | 14431 | 7347 | 72.16% | 73.47% | 32 | 2178 - 72.59% | 72,418$ | 724,180$ | 3000 | 100 | 1,668,000$ | 112,000$ | 685,343$ | 1,668,000$ | 364,648$ | 28 | 0 | 2,317,376$ | 108 | 21,848$ | 2,468,824$ |
| 9 | DETROIT STEELERS (DET) | 2000 | 1000 | 35 | 15 | 14477 | 8821 | 80.43% | 98.01% | 33 | 2589 - 86.29% | 71,001$ | 639,010$ | 3000 | 100 | 2,079,385$ | 132,000$ | 676,900$ | 2,079,385$ | 456,004$ | 33 | 0 | 2,343,037$ | 108 | 21,244$ | 2,400,572$ |
| 10 | EDMONTON OILERS (EDM) | 2000 | 1000 | 35 | 15 | 15600 | 8955 | 86.67% | 99.50% | 33 | 2728 - 90.94% | 75,592$ | 680,325$ | 3000 | 100 | 1,768,250$ | 112,000$ | 597,648$ | 1,768,250$ | 373,104$ | 31 | 0 | 2,494,525$ | 108 | 19,212$ | 2,170,956$ |
| 11 | HALIFAX HELL (HIG) | 2000 | 1000 | 23 | 12 | 19907 | 9918 | 99.54% | 99.18% | 32 | 2983 - 99.42% | 60,490$ | 604,900$ | 3000 | 100 | 2,235,606$ | 124,000$ | 678,934$ | 2,235,606$ | 447,347$ | 33 | 0 | 1,935,680$ | 108 | 22,655$ | 2,560,015$ |
| 12 | HAWAII PUNCH (HAW) | 2000 | 1000 | 35 | 15 | 15089 | 8930 | 83.83% | 99.22% | 33 | 2669 - 88.96% | 73,563$ | 662,065$ | 3000 | 100 | 2,115,950$ | 116,000$ | 741,394$ | 2,115,950$ | 498,642$ | 29 | 0 | 2,427,572$ | 108 | 22,179$ | 2,506,227$ |
| 13 | LAS CRUCES MESCALEROS (SPU) | 3000 | 2000 | 37 | 16 | 24023 | 19603 | 80.08% | 98.02% | 32 | 4363 - 87.25% | 120,250$ | 1,202,499$ | 5000 | 100 | 2,713,498$ | 128,000$ | 795,727$ | 2,713,498$ | 552,975$ | 32 | 0 | 3,847,997$ | 108 | 26,300$ | 2,971,900$ |
| 14 | MANHATTAN SWEDES (MAN) | 2000 | 1000 | 35 | 15 | 14704 | 8895 | 81.69% | 98.83% | 33 | 2622 - 87.40% | 72,007$ | 648,065$ | 3000 | 100 | 2,445,757$ | 120,000$ | 837,117$ | 2,445,757$ | 525,725$ | 32 | 0 | 2,376,238$ | 108 | 26,598$ | 3,005,574$ |
| 15 | NEWTON NIGHTHAWKS (NEW) | 2000 | 1000 | 25 | 15 | 19949 | 9839 | 99.75% | 98.39% | 32 | 2979 - 99.29% | 64,631$ | 646,310$ | 3000 | 100 | 2,172,500$ | 136,000$ | 644,960$ | 2,172,500$ | 479,456$ | 34 | 0 | 2,068,192$ | 108 | 20,155$ | 2,277,515$ |
| 16 | NORTH VAN ROCKERS (ROC) | 3500 | 2500 | 36 | 20 | 29735 | 17878 | 84.96% | 71.51% | 32 | 4761 - 79.36% | 139,629$ | 1,396,288$ | 6000 | 100 | 2,154,750$ | 112,000$ | 860,227$ | 2,154,750$ | 474,687$ | 30 | 0 | 4,468,122$ | 108 | 26,909$ | 3,040,717$ |
| 17 | PENSACOLA BLACK BEARS (PEN) | 2000 | 1000 | 15 | 12 | 18000 | 8967 | 100.00% | 99.63% | 33 | 2996 - 99.88% | 41,956$ | 377,604$ | 3000 | 100 | 2,439,925$ | 252,600$ | 754,357$ | 2,439,925$ | 533,653$ | 33 | 0 | 1,384,548$ | 108 | 23,724$ | 2,680,812$ |
| 18 | PHILADELPHIA PHANTOMS (PHI) | 2000 | 1000 | 36 | 15 | 16027 | 9945 | 80.14% | 99.45% | 32 | 2597 - 86.57% | 72,615$ | 726,147$ | 3000 | 100 | 2,022,781$ | 132,000$ | 596,389$ | 2,022,781$ | 452,499$ | 34 | 0 | 2,323,670$ | 108 | 18,592$ | 2,100,896$ |
| 19 | PINCHER CREEK WOLVERINES (PIN) | 3000 | 2000 | 50 | 30 | 14910 | 7825 | 55.22% | 43.47% | 33 | 2526 - 50.52% | 108,917$ | 980,250$ | 5000 | 100 | 1,913,600$ | 120,000$ | 831,390$ | 1,913,600$ | 442,974$ | 31 | 0 | 3,594,250$ | 108 | 25,335$ | 2,862,855$ |
| 20 | SAN JOSE AVACADOES (SAJ) | 2000 | 1000 | 35 | 15 | 14926 | 8916 | 82.92% | 99.07% | 33 | 2649 - 88.30% | 72,906$ | 656,150$ | 3000 | 100 | 2,367,718$ | 144,000$ | 694,123$ | 2,367,718$ | 521,099$ | 36 | 0 | 2,405,883$ | 108 | 21,736$ | 2,456,168$ |
| 21 | SYRACUSE BABY BULLS (BUL) | 2000 | 1000 | 30 | 25 | 19704 | 5760 | 98.52% | 57.60% | 32 | 2546 - 84.88% | 73,512$ | 735,120$ | 3000 | 100 | 2,186,897$ | 347,093$ | 698,276$ | 2,186,897$ | 506,276$ | 31 | 0 | 2,352,384$ | 108 | 21,082$ | 2,382,266$ |
| 22 | VANCOUVER THOUSANDAIRES (VAN) | 2000 | 1000 | 35 | 15 | 16745 | 9873 | 83.73% | 98.73% | 32 | 2662 - 88.73% | 73,417$ | 734,170$ | 3000 | 100 | 1,717,000$ | 108,000$ | 488,511$ | 1,717,000$ | 384,792$ | 27 | 0 | 2,349,344$ | 108 | 15,083$ | 1,704,379$ |