| 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 | 42302 | 24778 | 84.60% | 99.11% | 17 | 2683 - 89.44% | 74,090$ | 1,852,240$ | 3000 | 100 | 2,617,234$ | 164,000$ | 2,115,928$ | 2,617,234$ | 1,485,150$ | 33 | 0 | 1,259,523$ | 55 | 25,471$ | 1,528,260$ |
| 2 | BROOKLYN GRINDERS (BRK) | 2000 | 1000 | 35 | 15 | 47164 | 25877 | 90.70% | 99.53% | 16 | 2809 - 93.64% | 71,481$ | 1,858,504$ | 3000 | 100 | 1,740,500$ | 116,000$ | 1,501,163$ | 1,740,500$ | 1,020,683$ | 29 | 0 | 1,143,695$ | 55 | 17,723$ | 1,063,380$ |
| 3 | CALGARY WRANGLERS (CAL) | 3000 | 2000 | 32 | 15 | 73892 | 48826 | 98.52% | 97.65% | 17 | 4909 - 98.17% | 123,877$ | 3,096,934$ | 5000 | 100 | 1,984,500$ | 132,000$ | 1,981,253$ | 1,984,500$ | 1,149,388$ | 34 | 0 | 2,105,915$ | 55 | 23,472$ | 1,408,320$ |
| 4 | CAPE BRETON LEPRECHAUNS (CEL) | 2000 | 1000 | 35 | 15 | 42120 | 25668 | 81.00% | 98.72% | 16 | 2607 - 86.91% | 71,508$ | 1,859,220$ | 3000 | 100 | 1,686,875$ | 112,000$ | 1,495,111$ | 1,686,875$ | 933,368$ | 28 | 0 | 1,144,135$ | 55 | 20,365$ | 1,221,900$ |
| 5 | CAPE FEAR WILDCATS (PRO) | 2000 | 1000 | 35 | 15 | 41840 | 24676 | 83.68% | 98.70% | 17 | 2661 - 88.69% | 73,382$ | 1,834,540$ | 3000 | 100 | 2,343,990$ | 140,000$ | 2,072,071$ | 2,343,990$ | 1,368,611$ | 35 | 0 | 1,247,487$ | 55 | 24,441$ | 1,466,460$ |
| 6 | CHICAGO UNDERTAKERS (CHI) | 3000 | 2000 | 50 | 30 | 45164 | 24979 | 57.90% | 48.04% | 16 | 2698 - 53.96% | 115,676$ | 3,007,570$ | 5000 | 100 | 1,901,000$ | 171,000$ | 1,651,248$ | 1,901,000$ | 1,065,060$ | 31 | 0 | 1,850,812$ | 55 | 20,007$ | 1,200,420$ |
| 7 | COLORADO CUBS (WOL) | 2000 | 1000 | 32 | 22 | 43403 | 24640 | 83.47% | 94.77% | 16 | 2617 - 87.23% | 72,825$ | 1,893,444$ | 3000 | 100 | 2,830,700$ | 192,000$ | 2,172,876$ | 2,830,700$ | 1,237,876$ | 30 | 0 | 1,165,196$ | 55 | 30,522$ | 1,831,320$ |
| 8 | COQUITLAM EXPRESS (COQ) | 2000 | 1000 | 40 | 20 | 36429 | 18131 | 72.86% | 72.52% | 17 | 2182 - 72.75% | 72,791$ | 1,819,780$ | 3000 | 100 | 1,668,000$ | 112,000$ | 1,843,287$ | 1,668,000$ | 974,307$ | 28 | 0 | 1,237,450$ | 55 | 21,848$ | 1,310,880$ |
| 9 | DETROIT STEELERS (DET) | 2000 | 1000 | 35 | 15 | 41302 | 24758 | 82.60% | 99.03% | 17 | 2642 - 88.08% | 72,678$ | 1,816,940$ | 3000 | 100 | 2,084,385$ | 132,000$ | 1,803,714$ | 2,084,385$ | 1,216,944$ | 33 | 0 | 1,235,519$ | 55 | 21,279$ | 1,276,740$ |
| 10 | EDMONTON OILERS (EDM) | 2000 | 1000 | 35 | 15 | 41837 | 24798 | 83.67% | 99.19% | 17 | 2665 - 88.85% | 73,451$ | 1,836,265$ | 3000 | 100 | 1,720,750$ | 108,000$ | 1,604,449$ | 1,720,750$ | 1,007,986$ | 30 | 0 | 1,248,660$ | 55 | 18,884$ | 1,133,040$ |
| 11 | HALIFAX HELL (HIG) | 2000 | 1000 | 23 | 12 | 49847 | 24861 | 99.69% | 99.44% | 17 | 2988 - 99.61% | 58,913$ | 1,472,836$ | 3000 | 100 | 2,300,606$ | 128,000$ | 1,893,091$ | 2,300,606$ | 1,277,942$ | 34 | 0 | 1,001,528$ | 55 | 23,103$ | 1,386,180$ |
| 12 | HAWAII PUNCH (HAW) | 2000 | 1000 | 35 | 15 | 41915 | 24742 | 83.83% | 98.97% | 17 | 2666 - 88.88% | 73,526$ | 1,838,155$ | 3000 | 100 | 2,118,450$ | 116,000$ | 1,916,898$ | 2,118,450$ | 1,272,088$ | 29 | 0 | 1,249,945$ | 55 | 22,196$ | 1,331,760$ |
| 13 | LAS CRUCES MESCALEROS (SPU) | 3000 | 2000 | 37 | 16 | 58278 | 48722 | 77.70% | 97.44% | 17 | 4280 - 85.60% | 117,434$ | 2,935,838$ | 5000 | 100 | 2,274,309$ | 120,000$ | 2,066,127$ | 2,274,309$ | 1,421,317$ | 30 | 0 | 1,996,370$ | 55 | 23,271$ | 1,396,260$ |
| 14 | MANHATTAN SWEDES (MAN) | 2000 | 1000 | 35 | 15 | 40590 | 24262 | 81.18% | 97.05% | 17 | 2594 - 86.47% | 71,383$ | 1,784,580$ | 3000 | 100 | 2,448,257$ | 120,000$ | 2,247,081$ | 2,448,257$ | 1,419,946$ | 32 | 0 | 1,213,514$ | 55 | 26,616$ | 1,596,960$ |
| 15 | NEWTON NIGHTHAWKS (NEW) | 2000 | 1000 | 25 | 15 | 51902 | 25441 | 99.81% | 97.85% | 16 | 2975 - 99.16% | 64,583$ | 1,679,165$ | 3000 | 100 | 2,680,000$ | 196,000$ | 1,799,762$ | 2,680,000$ | 1,360,107$ | 31 | 0 | 1,033,332$ | 55 | 23,655$ | 1,419,300$ |
| 16 | NORTH VAN ROCKERS (ROC) | 3500 | 2500 | 35 | 18 | 75248 | 48040 | 82.69% | 73.91% | 16 | 4742 - 79.03% | 139,118$ | 3,617,063$ | 6000 | 100 | 2,199,750$ | 116,000$ | 2,284,950$ | 2,199,750$ | 1,260,832$ | 31 | 0 | 2,225,885$ | 55 | 27,219$ | 1,633,140$ |
| 17 | PENSACOLA BLACK BEARS (PEN) | 2000 | 1000 | 15 | 12 | 50000 | 24945 | 100.00% | 99.78% | 17 | 2998 - 99.93% | 41,974$ | 1,049,340$ | 3000 | 100 | 2,207,425$ | 232,600$ | 1,961,188$ | 2,207,425$ | 1,374,965$ | 28 | 0 | 713,551$ | 55 | 22,120$ | 1,327,200$ |
| 18 | PHILADELPHIA PHANTOMS (PHI) | 2000 | 1000 | 36 | 15 | 42813 | 25871 | 82.33% | 99.50% | 16 | 2642 - 88.06% | 74,205$ | 1,929,333$ | 3000 | 100 | 2,087,781$ | 132,000$ | 1,556,533$ | 2,087,781$ | 1,166,655$ | 34 | 0 | 1,187,282$ | 55 | 19,040$ | 1,142,400$ |
| 19 | PINCHER CREEK WOLVERINES (PIN) | 3000 | 2000 | 50 | 30 | 42798 | 23766 | 57.06% | 47.53% | 17 | 2663 - 53.25% | 114,115$ | 2,852,880$ | 5000 | 100 | 1,812,600$ | 116,000$ | 2,149,946$ | 1,812,600$ | 1,118,218$ | 30 | 0 | 1,939,958$ | 55 | 24,639$ | 1,478,340$ |
| 20 | SAN JOSE AVACADOES (SAJ) | 2000 | 1000 | 35 | 15 | 41369 | 24692 | 82.74% | 98.77% | 17 | 2642 - 88.08% | 72,732$ | 1,818,295$ | 3000 | 100 | 2,485,218$ | 148,000$ | 1,861,674$ | 2,485,218$ | 1,402,079$ | 37 | 0 | 1,236,441$ | 55 | 22,546$ | 1,352,760$ |
| 21 | SYRACUSE BABY BULLS (BUL) | 2000 | 1000 | 30 | 25 | 51200 | 15162 | 98.46% | 58.32% | 16 | 2552 - 85.08% | 73,656$ | 1,915,050$ | 3000 | 100 | 2,194,897$ | 347,093$ | 1,798,848$ | 2,194,897$ | 1,288,848$ | 31 | 0 | 1,178,492$ | 55 | 21,137$ | 1,268,220$ |
| 22 | VANCOUVER THOUSANDAIRES (VAN) | 2000 | 1000 | 35 | 15 | 43501 | 25782 | 83.66% | 99.16% | 16 | 2665 - 88.82% | 73,433$ | 1,909,265$ | 3000 | 100 | 1,724,500$ | 112,000$ | 1,285,805$ | 1,724,500$ | 1,010,292$ | 28 | 0 | 1,174,932$ | 55 | 15,134$ | 908,040$ |