| 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 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 | 27850 | 13808 | 99.46% | 98.63% | 28 | 2976 - 99.19% | 84,419$ | 1,181,870$ | 3000 | 100 | 2,518,371$ | 234,400$ | 1,199,409$ | 2,518,371$ | 817,419$ | 33 | 0 | 2,363,740$ | 105 | 23,531$ | 2,494,286$ |
| 2 |  BROOKLYN GRINDERS (BRK) | 2000 | 1000 | 35 | 15 | 27544 | 13931 | 98.37% | 99.51% | 28 | 2963 - 98.75% | 83,786$ | 1,173,005$ | 3000 | 100 | 2,672,450$ | 291,000$ | 1,258,957$ | 2,672,450$ | 891,234$ | 35 | 0 | 2,346,010$ | 105 | 24,232$ | 2,568,592$ |
| 3 |  CALGARY WRANGLERS (CAL) | 3500 | 2500 | 32 | 15 | 47846 | 34866 | 97.64% | 99.62% | 28 | 5908 - 98.47% | 146,719$ | 2,054,062$ | 6000 | 100 | 2,620,200$ | 152,000$ | 1,311,508$ | 2,620,200$ | 850,541$ | 38 | 0 | 4,108,124$ | 105 | 25,727$ | 2,727,062$ |
| 4 |  CAPE BRETON LEPRECHAUNS (CEL) | 2000 | 1000 | 35 | 15 | 29263 | 14898 | 97.54% | 99.32% | 27 | 2944 - 98.14% | 83,178$ | 1,247,675$ | 3000 | 100 | 2,174,400$ | 128,000$ | 1,396,669$ | 2,174,400$ | 695,980$ | 32 | 0 | 2,245,815$ | 105 | 27,589$ | 2,924,434$ |
| 5 |  CAPE FEAR WILDCATS (PRO) | 2000 | 1000 | 35 | 15 | 27311 | 13920 | 97.54% | 99.43% | 28 | 2945 - 98.17% | 83,192$ | 1,164,685$ | 3000 | 100 | 2,542,250$ | 120,000$ | 1,247,451$ | 2,542,250$ | 825,171$ | 30 | 0 | 2,329,370$ | 105 | 24,473$ | 2,594,138$ |
| 6 |  CHICAGO UNDERTAKERS (CHI) | 3000 | 2000 | 50 | 30 | 28528 | 16790 | 63.40% | 55.97% | 27 | 3021 - 60.42% | 128,673$ | 1,930,100$ | 5000 | 100 | 2,036,400$ | 116,000$ | 1,013,318$ | 2,036,400$ | 688,451$ | 29 | 0 | 3,474,180$ | 105 | 19,340$ | 2,050,040$ |
| 7 |  COLORADO CUBS (WOL) | 2000 | 1000 | 35 | 25 | 27120 | 9078 | 96.86% | 64.84% | 28 | 2586 - 86.19% | 84,011$ | 1,176,150$ | 3000 | 100 | 2,882,214$ | 168,000$ | 1,307,049$ | 2,882,214$ | 982,229$ | 42 | 0 | 2,352,300$ | 105 | 24,727$ | 2,621,062$ |
| 8 |  COQUITLAM EXPRESS (COQ) | 2000 | 1000 | 40 | 20 | 21220 | 11393 | 75.79% | 81.38% | 28 | 2330 - 77.65% | 76,904$ | 1,076,660$ | 3000 | 100 | 2,176,000$ | 132,000$ | 975,357$ | 2,176,000$ | 705,936$ | 33 | 0 | 2,153,320$ | 105 | 19,143$ | 2,029,158$ |
| 9 |  DETROIT STEELERS (DET) | 2000 | 1000 | 35 | 15 | 29493 | 14881 | 98.31% | 99.21% | 27 | 2958 - 98.61% | 83,698$ | 1,255,470$ | 3000 | 100 | 2,674,600$ | 148,000$ | 1,178,685$ | 2,674,600$ | 853,548$ | 37 | 0 | 2,259,846$ | 105 | 23,411$ | 2,481,566$ |
| 10 |  EDMONTON OILERS (EDM) | 2000 | 1000 | 35 | 15 | 29275 | 14910 | 97.58% | 99.40% | 27 | 2946 - 98.19% | 83,218$ | 1,248,275$ | 3000 | 100 | 2,553,400$ | 136,000$ | 1,250,103$ | 2,553,400$ | 827,160$ | 34 | 0 | 2,246,895$ | 105 | 24,557$ | 2,603,042$ |
| 11 |  HALIFAX HELL (HIG) | 2000 | 1000 | 59 | 39 | 16788 | 6944 | 55.96% | 46.29% | 27 | 1582 - 52.74% | 82,645$ | 1,239,678$ | 3000 | 100 | 2,982,546$ | 136,000$ | 1,183,593$ | 2,982,546$ | 923,712$ | 35 | 0 | 2,231,420$ | 105 | 24,093$ | 2,553,858$ |
| 12 |  HAWAII PUNCH (HAW) | 2000 | 1000 | 35 | 15 | 27623 | 13971 | 98.65% | 99.79% | 28 | 2971 - 99.03% | 84,026$ | 1,176,370$ | 3000 | 100 | 2,359,344$ | 136,000$ | 1,014,761$ | 2,359,344$ | 754,912$ | 34 | 0 | 2,352,740$ | 105 | 20,123$ | 2,133,038$ |
| 13 |  LAS CRUCES MESCALEROS (SPU) | 3500 | 2500 | 37 | 16 | 46431 | 34363 | 94.76% | 98.18% | 28 | 5771 - 96.18% | 161,983$ | 2,267,755$ | 6000 | 100 | 2,346,461$ | 132,000$ | 1,286,343$ | 2,346,461$ | 768,234$ | 33 | 0 | 4,535,510$ | 105 | 25,105$ | 2,661,130$ |
| 14 |  MANHATTAN SWEDES (MAN) | 2000 | 1000 | 35 | 15 | 27471 | 13901 | 98.11% | 99.29% | 28 | 2955 - 98.50% | 83,571$ | 1,170,000$ | 3000 | 100 | 2,985,000$ | 180,000$ | 1,352,196$ | 2,985,000$ | 962,403$ | 45 | 0 | 2,340,000$ | 105 | 26,656$ | 2,825,536$ |
| 15 |  NEWTON NIGHTHAWKS (NEW) | 2000 | 1000 | 25 | 15 | 27993 | 13985 | 99.98% | 99.89% | 28 | 2998 - 99.95% | 64,971$ | 909,600$ | 3000 | 100 | 2,984,139$ | 136,000$ | 1,353,354$ | 2,984,139$ | 979,779$ | 35 | 0 | 1,819,200$ | 105 | 26,332$ | 2,791,192$ |
| 16 |  NORTH VAN ROCKERS (ROC) | 3500 | 2500 | 40 | 30 | 37685 | 19418 | 76.91% | 55.48% | 28 | 4079 - 67.98% | 149,281$ | 2,089,940$ | 6000 | 100 | 2,923,825$ | 152,000$ | 1,517,250$ | 2,923,825$ | 949,773$ | 39 | 0 | 4,179,880$ | 105 | 29,750$ | 3,153,500$ |
| 17 |  PENSACOLA BLACK BEARS (PEN) | 2000 | 1000 | 15 | 10 | 28000 | 14000 | 100.00% | 100.00% | 28 | 3000 - 100.00% | 40,000$ | 560,000$ | 3000 | 100 | 2,367,625$ | 120,000$ | 1,118,119$ | 2,367,625$ | 825,744$ | 30 | 0 | 1,120,000$ | 105 | 20,813$ | 2,206,178$ |
| 18 |  PHILADELPHIA PHANTOMS (PHI) | 2000 | 1000 | 64 | 36 | 16513 | 7548 | 58.98% | 53.91% | 28 | 1719 - 57.29% | 80,691$ | 1,129,676$ | 3000 | 100 | 2,527,772$ | 124,000$ | 1,280,427$ | 2,527,772$ | 822,071$ | 31 | 0 | 2,259,352$ | 105 | 25,088$ | 2,659,328$ |
| 19 |  PINCHER CREEK WOLVERINES (PIN) | 3000 | 2000 | 50 | 30 | 26078 | 15469 | 62.09% | 55.25% | 28 | 2968 - 59.35% | 126,284$ | 1,767,970$ | 5000 | 100 | 2,371,600$ | 124,000$ | 1,238,440$ | 2,371,600$ | 731,374$ | 31 | 0 | 3,535,940$ | 105 | 25,048$ | 2,655,088$ |
| 20 |  SAN JOSE AVACADOES (SAJ) | 2000 | 1000 | 35 | 15 | 27412 | 13886 | 97.90% | 99.19% | 28 | 2950 - 98.33% | 83,408$ | 1,167,710$ | 3000 | 100 | 2,667,000$ | 156,000$ | 1,146,803$ | 2,667,000$ | 854,421$ | 39 | 0 | 2,335,420$ | 105 | 22,720$ | 2,408,320$ |
| 21 |  SYRACUSE BABY BULLS (BUL) | 2000 | 1000 | 20 | 15 | 28000 | 13984 | 100.00% | 99.89% | 28 | 2999 - 99.96% | 54,983$ | 769,760$ | 3000 | 100 | 3,079,500$ | 148,000$ | 1,290,245$ | 3,079,500$ | 900,452$ | 37 | 0 | 1,539,520$ | 105 | 27,258$ | 2,889,348$ |
| 22 |  VANCOUVER THOUSANDAIRES (VAN) | 2000 | 1000 | 35 | 15 | 27288 | 13980 | 97.46% | 99.86% | 28 | 2948 - 98.26% | 83,199$ | 1,164,780$ | 3000 | 100 | 2,226,600$ | 128,000$ | 992,835$ | 2,226,600$ | 710,193$ | 32 | 0 | 2,329,560$ | 105 | 19,724$ | 2,090,744$ |