| 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 |  BANGOR PUPPIES (BEA) | 2000 | 1000 | 35 | 15 | 19051 | 11000 | 86.60% | 100.00% | 31 | 2732 - 91.06% | 75,617$ | 831,785$ | 3000 | 100 | 2,870,850$ | 2,870,850$ | 972,286$ | 2,870,850$ | 689,754$ | 34 | 0 | 2,344,121$ | 112 | 26,278$ | 3,074,526$ |
| 2 |  BROOKLYN GRINDERS (BRK) | 2000 | 1000 | 35 | 15 | 18387 | 10000 | 91.94% | 100.00% | 32 | 2839 - 94.62% | 79,355$ | 793,545$ | 3000 | 100 | 2,476,500$ | 2,476,500$ | 959,675$ | 2,476,500$ | 630,127$ | 30 | 0 | 2,539,344$ | 112 | 25,497$ | 2,983,149$ |
| 3 |  CALGARY WRANGLERS (CAL) | 3500 | 2500 | 32 | 15 | 38378 | 27500 | 99.68% | 100.00% | 31 | 5989 - 99.82% | 149,145$ | 1,640,596$ | 6000 | 100 | 2,684,900$ | 2,684,900$ | 1,020,127$ | 2,684,900$ | 645,058$ | 37 | 0 | 4,623,498$ | 112 | 27,571$ | 3,225,807$ |
| 4 |  CAPE BRETON LEPRECHAUNS (CEL) | 2000 | 1000 | 35 | 15 | 17802 | 9999 | 89.01% | 99.99% | 32 | 2780 - 92.67% | 77,306$ | 773,055$ | 3000 | 100 | 2,456,600$ | 2,456,600$ | 769,075$ | 2,456,600$ | 580,708$ | 33 | 0 | 2,473,776$ | 112 | 21,043$ | 2,462,031$ |
| 5 |  CAPE FEAR WILDCATS (PRO) | 2000 | 1000 | 35 | 15 | 19506 | 10989 | 88.66% | 99.90% | 31 | 2772 - 92.41% | 77,050$ | 847,545$ | 3000 | 100 | 2,851,825$ | 2,851,825$ | 997,520$ | 2,851,825$ | 685,166$ | 33 | 0 | 2,388,536$ | 112 | 26,960$ | 3,154,320$ |
| 6 |  CHICAGO UNDERTAKERS (CHI) | 3000 | 2000 | 50 | 30 | 20768 | 11704 | 62.93% | 53.20% | 31 | 2952 - 59.04% | 126,320$ | 1,389,520$ | 5000 | 100 | 2,878,750$ | 2,878,750$ | 931,919$ | 2,878,750$ | 691,641$ | 37 | 0 | 3,915,920$ | 112 | 25,187$ | 2,946,879$ |
| 7 |  COLORADO CUBS (WOL) | 2000 | 1000 | 35 | 25 | 18884 | 6984 | 85.84% | 63.49% | 31 | 2352 - 78.39% | 75,958$ | 835,540$ | 3000 | 100 | 2,584,200$ | 2,584,200$ | 1,035,061$ | 2,584,200$ | 616,443$ | 35 | 0 | 2,354,704$ | 112 | 28,095$ | 3,287,115$ |
| 8 |  COQUITLAM EXPRESS (COQ) | 2000 | 1000 | 40 | 20 | 15947 | 8177 | 79.74% | 81.77% | 32 | 2412 - 80.41% | 80,142$ | 801,420$ | 3000 | 100 | 2,543,250$ | 2,543,250$ | 863,931$ | 2,543,250$ | 606,803$ | 33 | 0 | 2,564,544$ | 112 | 23,657$ | 2,767,869$ |
| 9 |  DETROIT STEELERS (DET) | 2000 | 1000 | 35 | 15 | 18863 | 10960 | 85.74% | 99.64% | 31 | 2711 - 90.37% | 74,964$ | 824,605$ | 3000 | 100 | 2,507,750$ | 2,507,750$ | 842,784$ | 2,507,750$ | 602,284$ | 32 | 0 | 2,323,887$ | 112 | 22,784$ | 2,665,728$ |
| 10 |  EDMONTON OILERS (EDM) | 2000 | 1000 | 35 | 15 | 18561 | 10984 | 84.37% | 99.85% | 31 | 2686 - 89.53% | 74,036$ | 814,395$ | 3000 | 100 | 2,999,500$ | 2,999,500$ | 1,033,484$ | 2,999,500$ | 720,649$ | 38 | 0 | 2,295,113$ | 112 | 27,932$ | 3,268,044$ |
| 11 |  HALIFAX HELL (HIG) | 2000 | 1000 | 25 | 15 | 18848 | 9409 | 94.24% | 94.09% | 32 | 2826 - 94.19% | 68,701$ | 687,006$ | 3000 | 100 | 3,022,800$ | 3,022,800$ | 1,023,010$ | 3,022,800$ | 708,762$ | 35 | 0 | 2,198,419$ | 112 | 28,122$ | 3,290,274$ |
| 12 |  HAWAII PUNCH (HAW) | 2000 | 1000 | 35 | 15 | 17360 | 9980 | 86.80% | 99.80% | 32 | 2734 - 91.13% | 75,730$ | 757,300$ | 3000 | 100 | 2,687,331$ | 2,687,331$ | 960,728$ | 2,687,331$ | 648,380$ | 38 | 0 | 2,423,360$ | 112 | 25,892$ | 3,029,364$ |
| 13 |  LAS CRUCES MESCALEROS (SPU) | 3500 | 2500 | 37 | 16 | 29498 | 24898 | 84.28% | 99.59% | 32 | 5440 - 90.66% | 148,979$ | 1,489,794$ | 6000 | 100 | 2,647,000$ | 2,647,000$ | 1,145,740$ | 2,647,000$ | 627,481$ | 35 | 0 | 4,767,341$ | 112 | 31,195$ | 3,649,815$ |
| 14 |  MANHATTAN SWEDES (MAN) | 2000 | 1000 | 35 | 15 | 17483 | 9976 | 87.42% | 99.76% | 32 | 2746 - 91.53% | 76,155$ | 761,545$ | 3000 | 100 | 3,166,575$ | 3,166,575$ | 1,049,098$ | 3,166,575$ | 760,794$ | 43 | 0 | 2,436,944$ | 112 | 28,354$ | 3,317,418$ |
| 15 |  NEWTON NIGHTHAWKS (NEW) | 2000 | 1000 | 25 | 15 | 22000 | 10982 | 100.00% | 99.84% | 31 | 2998 - 99.95% | 64,975$ | 714,730$ | 3000 | 100 | 3,032,100$ | 3,032,100$ | 991,956$ | 3,032,100$ | 715,652$ | 41 | 0 | 2,014,239$ | 112 | 27,156$ | 3,177,252$ |
| 16 |  NORTH VAN ROCKERS (ROC) | 3500 | 2500 | 35 | 25 | 31197 | 16413 | 89.13% | 65.65% | 32 | 4761 - 79.35% | 150,222$ | 1,502,220$ | 6000 | 100 | 2,397,900$ | 2,397,900$ | 1,006,547$ | 2,397,900$ | 586,819$ | 33 | 0 | 4,807,104$ | 112 | 26,915$ | 3,149,055$ |
| 17 |  PENSACOLA BLACK BEARS (PEN) | 2000 | 1000 | 15 | 10 | 20000 | 10000 | 100.00% | 100.00% | 32 | 3000 - 100.00% | 40,000$ | 400,000$ | 3000 | 100 | 2,979,570$ | 2,979,570$ | 902,228$ | 2,979,570$ | 691,994$ | 34 | 0 | 1,280,000$ | 112 | 25,030$ | 2,928,510$ |
| 18 |  PHILADELPHIA PHANTOMS (PHI) | 2000 | 1000 | 25 | 15 | 18852 | 9499 | 94.26% | 94.99% | 32 | 2835 - 94.50% | 67,829$ | 678,293$ | 3000 | 100 | 3,191,227$ | 3,191,227$ | 1,101,960$ | 3,191,227$ | 762,957$ | 33 | 0 | 2,170,538$ | 112 | 29,885$ | 3,496,545$ |
| 19 |  PINCHER CREEK WOLVERINES (PIN) | 3000 | 2000 | 50 | 30 | 21446 | 12047 | 64.99% | 54.76% | 31 | 3045 - 60.90% | 130,337$ | 1,433,710$ | 5000 | 100 | 3,170,945$ | 3,170,945$ | 1,002,092$ | 3,170,945$ | 761,816$ | 39 | 0 | 4,040,455$ | 112 | 27,084$ | 3,168,828$ |
| 20 |  SAN JOSE AVACADOES (SAJ) | 2000 | 1000 | 35 | 15 | 19665 | 10981 | 89.39% | 99.83% | 31 | 2786 - 92.87% | 77,545$ | 852,990$ | 3000 | 100 | 2,931,212$ | 2,931,212$ | 976,208$ | 2,931,212$ | 704,258$ | 40 | 0 | 2,403,881$ | 112 | 26,384$ | 3,086,928$ |
| 21 |  SYRACUSE BABY BULLS (BUL) | 2000 | 1000 | 20 | 15 | 22000 | 10783 | 100.00% | 98.03% | 31 | 2980 - 99.34% | 56,728$ | 624,009$ | 3000 | 100 | 3,054,914$ | 3,054,914$ | 956,372$ | 3,054,914$ | 740,144$ | 33 | 0 | 1,758,571$ | 112 | 25,681$ | 3,004,677$ |
| 22 |  VANCOUVER THOUSANDAIRES (VAN) | 2000 | 1000 | 35 | 15 | 19461 | 10998 | 88.46% | 99.98% | 31 | 2769 - 92.30% | 76,919$ | 846,105$ | 3000 | 100 | 2,387,000$ | 2,387,000$ | 866,136$ | 2,387,000$ | 565,826$ | 32 | 0 | 2,384,478$ | 112 | 23,617$ | 2,763,189$ |