| 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 |  Admirals (NAS) | 2000 | 1000 | 30 | 4 | 88268 | 45934 | 95.94% | 99.86% | 0 | 2917 - 97.25% | 91,725$ | 4,219,347$ | 3000 | 100 | 3,211,500$ | 3,211,500$ | 4,142,226$ | 27,216$ | 3,142,240$ | 0 | 0 | 0$ | 2 | 35,691$ | 0$ |
| 2 |  Americans (BUF) | 2000 | 1000 | 26 | 15 | 90040 | 36517 | 97.87% | 79.38% | 0 | 2751 - 91.71% | 93,572$ | 4,304,302$ | 3000 | 100 | 6,077,126$ | 6,077,126$ | 6,567,271$ | 51,501$ | 5,817,271$ | 0 | 0 | 0$ | 2 | 57,857$ | 0$ |
| 3 |  Barracuda (SJS) | 2000 | 1000 | 15 | 10 | 91990 | 45317 | 99.99% | 98.52% | 0 | 2985 - 99.50% | 59,374$ | 2,731,200$ | 3000 | 100 | 3,314,012$ | 3,414,446$ | 4,108,329$ | 28,085$ | 3,190,942$ | 0 | 0 | 0$ | 2 | 34,441$ | 0$ |
| 4 |  Bears (WAS) | 2000 | 1000 | 20 | 15 | 90807 | 34328 | 98.70% | 74.63% | 0 | 2720 - 90.68% | 77,669$ | 3,572,762$ | 3000 | 100 | 3,295,043$ | 3,186,681$ | 4,692,252$ | 27,924$ | 3,942,246$ | 0 | 0 | 0$ | 2 | 34,280$ | 0$ |
| 5 |  Bruins (BOS) | 2000 | 1000 | 20 | 10 | 91887 | 45610 | 99.88% | 99.15% | 0 | 2989 - 99.64% | 74,300$ | 3,417,821$ | 3000 | 100 | 3,512,650$ | 3,230,317$ | 5,657,614$ | 29,768$ | 3,157,611$ | 0 | 0 | 0$ | 2 | 50,955$ | 0$ |
| 6 |  Canucks (VAN) | 2000 | 1000 | 35 | 15 | 65302 | 34826 | 70.98% | 75.71% | 0 | 2177 - 72.56% | 90,953$ | 4,183,859$ | 3000 | 100 | 2,345,959$ | 2,289,159$ | 3,149,939$ | 19,881$ | 2,149,913$ | 0 | 0 | 0$ | 2 | 28,356$ | 0$ |
| 7 |  Checkers (FLO) | 2000 | 1000 | 35 | 15 | 66835 | 35448 | 72.65% | 77.06% | 0 | 2224 - 74.12% | 92,994$ | 4,277,710$ | 3000 | 100 | 3,083,682$ | 3,023,882$ | 3,723,698$ | 26,133$ | 2,723,687$ | 0 | 0 | 0$ | 2 | 34,607$ | 0$ |
| 8 |  Comets (NJD) | 2000 | 1000 | 35 | 15 | 65575 | 35557 | 71.28% | 77.30% | 0 | 2199 - 73.28% | 91,618$ | 4,214,434$ | 3000 | 100 | 2,332,730$ | 2,325,343$ | 3,485,892$ | 19,769$ | 2,235,918$ | 0 | 0 | 0$ | 2 | 30,362$ | 0$ |
| 9 |  Condors (EDM) | 2000 | 1000 | 30 | 15 | 89398 | 36612 | 97.17% | 79.59% | 0 | 2739 - 91.31% | 104,660$ | 4,814,370$ | 3000 | 100 | 3,194,223$ | 2,737,463$ | 5,176,641$ | 27,070$ | 3,176,659$ | 0 | 0 | 0$ | 2 | 44,019$ | 0$ |
| 10 |  Crunch (TAM) | 2000 | 1000 | 35 | 15 | 64827 | 35208 | 70.46% | 76.54% | 0 | 2175 - 72.49% | 90,600$ | 4,167,622$ | 3000 | 100 | 2,552,400$ | 2,436,586$ | 3,562,285$ | 21,631$ | 2,562,313$ | 0 | 0 | 0$ | 2 | 30,105$ | 0$ |
| 11 |  Eagles (COL) | 2000 | 1000 | 35 | 15 | 66077 | 35608 | 71.82% | 77.41% | 0 | 2211 - 73.68% | 92,212$ | 4,241,755$ | 3000 | 100 | 2,575,016$ | 2,504,216$ | 3,180,601$ | 21,822$ | 2,418,518$ | 0 | 0 | 0$ | 2 | 28,178$ | 0$ |
| 12 |  Griffins (DET) | 2000 | 1000 | 35 | 15 | 66000 | 35967 | 71.74% | 78.19% | 0 | 2217 - 73.89% | 92,299$ | 4,245,766$ | 3000 | 100 | 2,576,873$ | 2,451,873$ | 3,500,703$ | 21,838$ | 2,500,691$ | 0 | 0 | 0$ | 2 | 30,312$ | 0$ |
| 13 |  Gulls (ANA) | 2000 | 1000 | 40 | 20 | 57775 | 26288 | 62.80% | 57.15% | 0 | 1827 - 60.92% | 91,886$ | 4,226,777$ | 3000 | 100 | 4,097,931$ | 4,020,642$ | 9,138,852$ | 34,728$ | 4,138,838$ | 0 | 0 | 0$ | 2 | 77,101$ | 0$ |
| 14 |  Heat (CAL) | 2000 | 1000 | 50 | 30 | 47092 | 23000 | 51.19% | 50.00% | 0 | 1524 - 50.79% | 98,619$ | 4,536,454$ | 3000 | 100 | 2,502,614$ | 2,525,414$ | 3,587,335$ | 21,209$ | 2,587,322$ | 0 | 0 | 0$ | 2 | 29,683$ | 0$ |
| 15 |  IceHogs (CHI) | 2000 | 1000 | 35 | 15 | 63242 | 33702 | 68.74% | 73.27% | 0 | 2107 - 70.25% | 88,072$ | 4,051,312$ | 3000 | 100 | 2,365,790$ | 2,339,990$ | 3,384,226$ | 20,049$ | 2,384,177$ | 0 | 0 | 0$ | 2 | 28,524$ | 0$ |
| 16 |  Islanders (NYI) | 2000 | 1000 | 30 | 15 | 87332 | 36297 | 94.93% | 78.91% | 0 | 2688 - 89.59% | 102,500$ | 4,714,981$ | 3000 | 100 | 2,618,500$ | 2,618,500$ | 3,498,926$ | 22,191$ | 2,688,534$ | 0 | 0 | 0$ | 2 | 28,928$ | 0$ |
| 17 |  Marlies (TOR) | 2000 | 1000 | 35 | 15 | 65806 | 35507 | 71.53% | 77.19% | 0 | 2202 - 73.42% | 91,856$ | 4,225,364$ | 3000 | 100 | 3,088,093$ | 3,045,393$ | 3,546,595$ | 26,170$ | 2,785,608$ | 0 | 0 | 0$ | 2 | 32,526$ | 0$ |
| 18 |  Monsters (CBJ) | 2000 | 1000 | 35 | 15 | 63889 | 35086 | 69.44% | 76.27% | 0 | 2152 - 71.72% | 89,478$ | 4,115,981$ | 3000 | 100 | 2,447,748$ | 2,310,356$ | 4,034,888$ | 20,744$ | 2,434,899$ | 0 | 0 | 0$ | 2 | 34,303$ | 0$ |
| 19 |  Moose (WPG) | 2000 | 1000 | 35 | 15 | 64024 | 35002 | 69.59% | 76.09% | 0 | 2153 - 71.76% | 89,590$ | 4,121,144$ | 3000 | 100 | 3,496,533$ | 3,496,533$ | 4,234,470$ | 29,632$ | 3,434,451$ | 0 | 0 | 0$ | 2 | 36,411$ | 0$ |
| 20 | Penguins (PIT) | 2000 | 1000 | 35 | 15 | 63933 | 34852 | 69.49% | 75.77% | 0 | 2148 - 71.58% | 89,414$ | 4,113,049$ | 3000 | 100 | 3,977,308$ | 3,977,308$ | 4,863,536$ | 33,706$ | 3,863,526$ | 0 | 0 | 0$ | 2 | 42,181$ | 0$ |
| 21 |  Phantoms (PHI) | 2000 | 1000 | 25 | 10 | 89039 | 45265 | 96.78% | 98.40% | 0 | 2920 - 97.32% | 86,764$ | 3,991,152$ | 3000 | 100 | 2,695,000$ | 2,695,000$ | 3,475,572$ | 22,839$ | 2,716,050$ | 0 | 0 | 0$ | 2 | 29,195$ | 0$ |
| 22 |  Reign (LAK) | 2000 | 1000 | 30 | 15 | 85967 | 34840 | 93.44% | 75.74% | 0 | 2626 - 87.54% | 100,465$ | 4,621,398$ | 3000 | 100 | 2,250,544$ | 2,227,044$ | 3,330,437$ | 19,072$ | 2,330,392$ | 0 | 0 | 0$ | 2 | 27,547$ | 0$ |
| 23 |  Roadrunners (ARZ) | 2000 | 1000 | 25 | 10 | 89276 | 44905 | 97.04% | 97.62% | 0 | 2917 - 97.23% | 86,840$ | 3,994,617$ | 3000 | 100 | 3,046,529$ | 3,035,529$ | 3,490,505$ | 25,818$ | 2,740,497$ | 0 | 0 | 0$ | 2 | 32,174$ | 0$ |
| 24 |  Rocket (MON) | 2000 | 1000 | 26 | 20 | 88780 | 26742 | 96.50% | 58.13% | 0 | 2511 - 83.71% | 92,092$ | 4,236,252$ | 3000 | 100 | 2,931,098$ | 2,887,398$ | 3,933,406$ | 24,840$ | 3,183,398$ | 0 | 0 | 0$ | 2 | 31,196$ | 0$ |
| 25 |  Senators (OTT) | 2000 | 1000 | 35 | 15 | 64807 | 35337 | 70.44% | 76.82% | 0 | 2177 - 72.57% | 90,641$ | 4,169,467$ | 3000 | 100 | 2,944,594$ | 2,954,653$ | 3,955,393$ | 24,954$ | 2,943,210$ | 0 | 0 | 0$ | 2 | 33,429$ | 0$ |
| 26 | Silver Knights (LVK) | 2000 | 1000 | 35 | 15 | 64638 | 34898 | 70.26% | 75.87% | 0 | 2164 - 72.13% | 90,236$ | 4,150,844$ | 3000 | 100 | 2,703,962$ | 2,620,396$ | 3,821,108$ | 22,915$ | 2,821,113$ | 0 | 0 | 0$ | 2 | 31,390$ | 0$ |
| 27 |  Stars (DAL) | 2000 | 1000 | 35 | 15 | 66396 | 36096 | 72.17% | 78.47% | 0 | 2228 - 74.27% | 92,811$ | 4,269,294$ | 3000 | 100 | 5,945,977$ | 5,809,485$ | 6,654,245$ | 50,390$ | 5,904,237$ | 0 | 0 | 0$ | 2 | 56,746$ | 0$ |
| 28 |  Thunderbirds (STL) | 2000 | 1000 | 28 | 12 | 89631 | 45228 | 97.43% | 98.32% | 0 | 2932 - 97.72% | 98,871$ | 4,548,083$ | 3000 | 100 | 5,393,646$ | 5,197,472$ | 7,775,415$ | 45,709$ | 5,775,410$ | 0 | 0 | 0$ | 2 | 62,658$ | 0$ |
| 29 |  Wild (MIN) | 2000 | 1000 | 25 | 10 | 89898 | 45689 | 97.72% | 99.32% | 0 | 2948 - 98.25% | 87,597$ | 4,029,465$ | 3000 | 100 | 3,319,263$ | 3,035,133$ | 4,805,728$ | 28,129$ | 3,805,698$ | 0 | 0 | 0$ | 2 | 36,604$ | 0$ |
| 30 |  Wolf Pack (NYR) | 2000 | 1000 | 35 | 15 | 64063 | 34703 | 69.63% | 75.44% | 0 | 2147 - 71.57% | 89,489$ | 4,116,500$ | 3000 | 100 | 3,500,233$ | 3,443,033$ | 4,429,905$ | 29,663$ | 3,429,862$ | 0 | 0 | 0$ | 2 | 38,138$ | 0$ |
| 31 |  Wolves (HAR) | 2000 | 1000 | 35 | 16 | 66733 | 33737 | 72.54% | 73.34% | 0 | 2184 - 72.80% | 93,140$ | 4,284,418$ | 3000 | 100 | 3,162,792$ | 2,816,568$ | 3,879,074$ | 26,803$ | 3,113,824$ | 0 | 0 | 0$ | 2 | 33,159$ | 0$ |